23 lines
895 B
MySQL
23 lines
895 B
MySQL
|
/*
|
||
|
|
Warnings:
|
||
|
|
|
||
|
|
- Added the required column `ms_between` to the `Transition` table without a default value. This is not possible if the table is not empty.
|
||
|
|
|
||
|
|
*/
|
||
|
|
-- RedefineTables
|
||
|
|
PRAGMA foreign_keys=OFF;
|
||
|
|
CREATE TABLE "new_Transition" (
|
||
|
|
"before_id" INTEGER NOT NULL,
|
||
|
|
"after_id" INTEGER NOT NULL,
|
||
|
|
"ms_between" BIGINT NOT NULL,
|
||
|
|
|
||
|
|
PRIMARY KEY ("before_id", "after_id"),
|
||
|
|
CONSTRAINT "Transition_before_id_fkey" FOREIGN KEY ("before_id") REFERENCES "Score" ("id") ON DELETE RESTRICT ON UPDATE CASCADE,
|
||
|
|
CONSTRAINT "Transition_after_id_fkey" FOREIGN KEY ("after_id") REFERENCES "Score" ("id") ON DELETE RESTRICT ON UPDATE CASCADE
|
||
|
|
);
|
||
|
|
INSERT INTO "new_Transition" ("after_id", "before_id") SELECT "after_id", "before_id" FROM "Transition";
|
||
|
|
DROP TABLE "Transition";
|
||
|
|
ALTER TABLE "new_Transition" RENAME TO "Transition";
|
||
|
|
PRAGMA foreign_key_check("Transition");
|
||
|
|
PRAGMA foreign_keys=ON;
|