X-Git-Url: http://git.ozlabs.org/?a=blobdiff_plain;f=lib%2Fsql%2Fmigration%2F006-maintainer-project-attributes.sql;fp=lib%2Fsql%2Fmigration%2F006-maintainer-project-attributes.sql;h=0000000000000000000000000000000000000000;hb=0f3b76430ad276e8956ac388452e007d501cc54d;hp=86b82e1e3cf689dd3aa0ffcb03e3152b9b46372c;hpb=6431966311d9ebe151c28abdff975ed80038455e;p=patchwork

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;