git.ozlabs.org Git - patchwork/blob - lib/sql/migration/006-maintainer-project-attributes.sql

   1 BEGIN;
   2
   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
  10 );
  11
  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;
  19
  20 --DROP TABLE patchwork_userprofile_maintainer_projects;
  21
  22 COMMIT;