lib/sql/migration/003-add-comment-parent.sql


1
2
3
4
5
6
7

BEGIN;
ALTER TABLE "patchwork_comment" ADD COLUMN "parent_id" integer NULL;
ALTER TABLE "patchwork_comment" ADD CONSTRAINT parent_id_refs_id_7b721867
        FOREIGN KEY ("parent_id")
        REFERENCES "patchwork_comment" ("id")
        DEFERRABLE INITIALLY DEFERRED;
COMMIT;