]> git.ozlabs.org Git - patchwork/blob - lib/sql/migration/003-add-comment-parent.sql
sql: update grant-all.mysql.sql
[patchwork] / lib / sql / migration / 003-add-comment-parent.sql
1 BEGIN;
2 ALTER TABLE "patchwork_comment" ADD COLUMN "parent_id" integer NULL;
3 ALTER TABLE "patchwork_comment" ADD CONSTRAINT parent_id_refs_id_7b721867
4         FOREIGN KEY ("parent_id")
5         REFERENCES "patchwork_comment" ("id")
6         DEFERRABLE INITIALLY DEFERRED;
7 COMMIT;