3 CREATE TABLE "patchwork_projectmaintainer" (
4 "id" serial NOT NULL PRIMARY KEY,
5 "project_id" integer NOT NULL
6 REFERENCES "patchwork_project" ("id") DEFERRABLE INITIALLY DEFERRED,
7 "user_id" integer NOT NULL
8 REFERENCES "auth_user" ("id") DEFERRABLE INITIALLY DEFERRED,
9 "master" boolean NOT NULL
12 INSERT INTO patchwork_projectmaintainer
13 (project_id, user_id, master)
14 SELECT project_id, patchwork_userprofile.user_id, False
15 FROM patchwork_userprofile_maintainer_projects
16 INNER JOIN patchwork_userprofile
17 ON patchwork_userprofile.id =
18 patchwork_userprofile_maintainer_projects.userprofile_id;
20 --DROP TABLE patchwork_userprofile_maintainer_projects;