20 lines
930 B
MySQL
20 lines
930 B
MySQL
|
-- RedefineTables
|
||
|
|
PRAGMA defer_foreign_keys=ON;
|
||
|
|
PRAGMA foreign_keys=OFF;
|
||
|
|
CREATE TABLE "new_Sub" (
|
||
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
||
|
|
"storyId" INTEGER,
|
||
|
|
"pubId" INTEGER,
|
||
|
|
"submitted" TEXT NOT NULL,
|
||
|
|
"responded" TEXT,
|
||
|
|
"responseId" INTEGER,
|
||
|
|
CONSTRAINT "Sub_storyId_fkey" FOREIGN KEY ("storyId") REFERENCES "Story" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
|
||
|
|
CONSTRAINT "Sub_pubId_fkey" FOREIGN KEY ("pubId") REFERENCES "Pub" ("id") ON DELETE SET NULL ON UPDATE CASCADE,
|
||
|
|
CONSTRAINT "Sub_responseId_fkey" FOREIGN KEY ("responseId") REFERENCES "Response" ("id") ON DELETE SET NULL ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
INSERT INTO "new_Sub" ("id", "pubId", "responded", "responseId", "storyId", "submitted") SELECT "id", "pubId", "responded", "responseId", "storyId", "submitted" FROM "Sub";
|
||
|
|
DROP TABLE "Sub";
|
||
|
|
ALTER TABLE "new_Sub" RENAME TO "Sub";
|
||
|
|
PRAGMA foreign_keys=ON;
|
||
|
|
PRAGMA defer_foreign_keys=OFF;
|