Migration safety report

Planned statements, classified by what they remove or tighten
8
statements
5
safe
1
warning
2
destructive

Statements

#SeveritySubjectReasonStatement
1 safe foreign_keys does not remove data or tighten constraints
PRAGMA foreign_keys = off
2 safe new_products does not remove data or tighten constraints
CREATE TABLE "new_products" (
  "id" INTEGER PRIMARY KEY AUTOINCREMENT,
  "sku" TEXT NOT NULL UNIQUE,
  "name" TEXT NOT NULL,
  "price_cents" INTEGER NOT NULL
)
3 safe sqlite_sequence does not remove data or tighten constraints
INSERT INTO sqlite_sequence (name, seq) SELECT 'new_products', seq FROM sqlite_sequence WHERE name = 'products'
4 safe new_products does not remove data or tighten constraints
INSERT INTO "new_products" ("id", "sku", "name", "price_cents") SELECT "id", "sku", "name", "price_cents" FROM "products"
5 destructive products DROP TABLE removes the table and all rows
DROP TABLE "products"
6 warning new_products rename can break deployed readers and writers
ALTER TABLE "new_products" RENAME TO "products"
7 destructive legacy_inventory DROP TABLE removes the table and all rows
DROP TABLE "legacy_inventory"
8 safe foreign_keys does not remove data or tighten constraints
PRAGMA foreign_keys = on