From 0f3b76430ad276e8956ac388452e007d501cc54d Mon Sep 17 00:00:00 2001 From: Jeremy Kerr Date: Thu, 8 Dec 2011 22:28:22 +0800 Subject: [PATCH] sql: remove development migration script The projectmaintainer heirachy hasn't been implemented, so we don't need the migration script yet. Signed-off-by: Jeremy Kerr --- .../006-maintainer-project-attributes.sql | 22 ------------------- 1 file changed, 22 deletions(-) delete mode 100644 lib/sql/migration/006-maintainer-project-attributes.sql diff --git a/lib/sql/migration/006-maintainer-project-attributes.sql b/lib/sql/migration/006-maintainer-project-attributes.sql deleted file mode 100644 index 86b82e1..0000000 --- a/lib/sql/migration/006-maintainer-project-attributes.sql +++ /dev/null @@ -1,22 +0,0 @@ -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; -- 2.39.2