diff options
| -rw-r--r-- | lib/sql/migration/003-add-comment-parent.sql | 7 | ||||
| -rw-r--r-- | lib/sql/migration/006-maintainer-project-attributes.sql | 22 |
2 files changed, 29 insertions, 0 deletions
diff --git a/lib/sql/migration/003-add-comment-parent.sql b/lib/sql/migration/003-add-comment-parent.sql new file mode 100644 index 0000000..e6f9f64 --- /dev/null +++ b/lib/sql/migration/003-add-comment-parent.sql @@ -0,0 +1,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; diff --git a/lib/sql/migration/006-maintainer-project-attributes.sql b/lib/sql/migration/006-maintainer-project-attributes.sql new file mode 100644 index 0000000..86b82e1 --- /dev/null +++ b/lib/sql/migration/006-maintainer-project-attributes.sql @@ -0,0 +1,22 @@ +BEGIN; + +CREATE TABLE "patchwork_projectmaintainer" ( + "id" serial NOT NULL PRIMARY KEY, + "project_id" integer NOT NULL + REFERENCES "patchwork_project" ("id") DEFERRABLE INITIALLY DEFERRED, + "user_id" integer NOT NULL + REFERENCES "auth_user" ("id") DEFERRABLE INITIALLY DEFERRED, + "master" boolean NOT NULL +); + +INSERT INTO patchwork_projectmaintainer + (project_id, user_id, master) + SELECT project_id, patchwork_userprofile.user_id, False + FROM patchwork_userprofile_maintainer_projects + INNER JOIN patchwork_userprofile + ON patchwork_userprofile.id = + patchwork_userprofile_maintainer_projects.userprofile_id; + +--DROP TABLE patchwork_userprofile_maintainer_projects; + +COMMIT; |