mirror of
https://github.com/hknsh/project-knedita.git
synced 2024-11-28 17:41:15 +00:00
7 lines
279 B
MySQL
7 lines
279 B
MySQL
|
-- AlterTable
|
||
|
ALTER TABLE "Comments" ADD COLUMN "parentId" TEXT,
|
||
|
ALTER COLUMN "kweekId" DROP NOT NULL;
|
||
|
|
||
|
-- AddForeignKey
|
||
|
ALTER TABLE "Comments" ADD CONSTRAINT "Comments_parentId_fkey" FOREIGN KEY ("parentId") REFERENCES "Comments"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|