summaryrefslogtreecommitdiffstats
path: root/lib/sql
diff options
context:
space:
mode:
authorJeremy Kerr <jk@ozlabs.org>2011-12-08 22:28:22 +0800
committerJeremy Kerr <jk@ozlabs.org>2011-12-08 22:28:22 +0800
commit0f3b76430ad276e8956ac388452e007d501cc54d (patch)
tree0781c0bc5631b447d3ac50f6eef16312fc1225da /lib/sql
parent6431966311d9ebe151c28abdff975ed80038455e (diff)
downloadpatchwork-0f3b76430ad276e8956ac388452e007d501cc54d.tar.bz2
patchwork-0f3b76430ad276e8956ac388452e007d501cc54d.tar.xz
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 <jk@ozlabs.org>
Diffstat (limited to 'lib/sql')
-rw-r--r--lib/sql/migration/006-maintainer-project-attributes.sql22
1 files changed, 0 insertions, 22 deletions
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;