-- RedefineTables PRAGMA defer_foreign_keys=ON; PRAGMA foreign_keys=OFF; CREATE TABLE "new_ProcessedWebhook" ( "webhookId" TEXT NOT NULL PRIMARY KEY, "topic" TEXT NOT NULL, "shopDomain" TEXT NOT NULL, "status" TEXT NOT NULL DEFAULT 'done', "receivedAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ); INSERT INTO "new_ProcessedWebhook" ("receivedAt", "shopDomain", "topic", "webhookId") SELECT "receivedAt", "shopDomain", "topic", "webhookId" FROM "ProcessedWebhook"; DROP TABLE "ProcessedWebhook"; ALTER TABLE "new_ProcessedWebhook" RENAME TO "ProcessedWebhook"; CREATE INDEX "ProcessedWebhook_shopDomain_topic_idx" ON "ProcessedWebhook"("shopDomain", "topic"); PRAGMA foreign_keys=ON; PRAGMA defer_foreign_keys=OFF;