| 1 | -- One-time: add structured crash/exception fields and sample-retention metadata. |
| 2 | -- Apply once before deploying the matching worker: |
| 3 | -- wrangler d1 execute reasonix-crash --remote --file=migrate-structured-reports.sql |
| 4 | |
| 5 | ALTER TABLE groups ADD COLUMN first_version TEXT NOT NULL DEFAULT ''; |
| 6 | ALTER TABLE groups ADD COLUMN source TEXT NOT NULL DEFAULT 'legacy'; |
| 7 | ALTER TABLE groups ADD COLUMN label TEXT NOT NULL DEFAULT ''; |
| 8 | ALTER TABLE groups ADD COLUMN error_type TEXT NOT NULL DEFAULT ''; |
| 9 | ALTER TABLE groups ADD COLUMN top_frame TEXT NOT NULL DEFAULT ''; |
| 10 | ALTER TABLE groups ADD COLUMN severity TEXT NOT NULL DEFAULT 'medium'; |
| 11 | ALTER TABLE groups ADD COLUMN last_os TEXT NOT NULL DEFAULT ''; |
| 12 | ALTER TABLE groups ADD COLUMN last_arch TEXT NOT NULL DEFAULT ''; |
| 13 | ALTER TABLE groups ADD COLUMN last_build_commit TEXT NOT NULL DEFAULT ''; |
| 14 | ALTER TABLE groups ADD COLUMN last_channel TEXT NOT NULL DEFAULT ''; |
| 15 | ALTER TABLE groups ADD COLUMN resolved_in TEXT NOT NULL DEFAULT ''; |
| 16 | ALTER TABLE groups ADD COLUMN resolved_at TEXT NOT NULL DEFAULT ''; |
| 17 | ALTER TABLE groups ADD COLUMN regressed_at TEXT NOT NULL DEFAULT ''; |
| 18 | ALTER TABLE groups ADD COLUMN last_sample_at TEXT NOT NULL DEFAULT ''; |
| 19 | |
| 20 | ALTER TABLE reports ADD COLUMN source TEXT NOT NULL DEFAULT 'legacy'; |
| 21 | ALTER TABLE reports ADD COLUMN label TEXT NOT NULL DEFAULT ''; |
| 22 | ALTER TABLE reports ADD COLUMN error_type TEXT NOT NULL DEFAULT ''; |
| 23 | ALTER TABLE reports ADD COLUMN error_message TEXT NOT NULL DEFAULT ''; |
| 24 | ALTER TABLE reports ADD COLUMN top_frame TEXT NOT NULL DEFAULT ''; |
| 25 | ALTER TABLE reports ADD COLUMN build_commit TEXT NOT NULL DEFAULT ''; |
| 26 | ALTER TABLE reports ADD COLUMN channel TEXT NOT NULL DEFAULT ''; |
| 27 | ALTER TABLE reports ADD COLUMN language TEXT NOT NULL DEFAULT ''; |
| 28 | ALTER TABLE reports ADD COLUMN view TEXT NOT NULL DEFAULT ''; |
| 29 | ALTER TABLE reports ADD COLUMN breadcrumbs TEXT NOT NULL DEFAULT ''; |
| 30 | ALTER TABLE reports ADD COLUMN component_stack TEXT NOT NULL DEFAULT ''; |
| 31 | ALTER TABLE reports ADD COLUMN stack TEXT NOT NULL DEFAULT ''; |
| 32 | ALTER TABLE reports ADD COLUMN occurred_at TEXT NOT NULL DEFAULT ''; |
| 33 | |
| 34 | UPDATE groups SET first_version = last_version WHERE first_version = ''; |
| 35 | UPDATE groups SET last_sample_at = last_seen WHERE last_sample_at = ''; |
| 36 |