From: Roland Mas <lolando@debian.org>
Date: Fri, 26 Oct 2012 09:14:45 +0000 (+0200)
Subject: More database polishing
X-Git-Tag: v5.3-rc1~1795
X-Git-Url: https://scm.fusionforge.org/anonscm/gitweb?p=fusionforge%2Ffusionforge.git;a=commitdiff_plain;h=a46a7267f3793eddf5e76ee7f281ec15690dcf01

More database polishing
---

diff --git a/src/db/20121026-more-db-cleaning.sql b/src/db/20121026-more-db-cleaning.sql
new file mode 100644
index 0000000000..96b7c0c570
--- /dev/null
+++ b/src/db/20121026-more-db-cleaning.sql
@@ -0,0 +1,20 @@
+ALTER TABLE project_assigned_to DROP COLUMN project_assigned_id;
+DROP INDEX projectassigned_assignedtotaskid;
+DROP SEQUENCE project_assigned_to_pk_seq;
+
+ALTER TABLE forum_saved_place DROP COLUMN saved_place_id;
+DROP SEQUENCE forum_saved_place_pk_seq;
+ALTER TABLE forum_saved_place ADD FOREIGN KEY (forum_id) REFERENCES forum ON DELETE CASCADE ON UPDATE CASCADE;
+
+ALTER TABLE filemodule_monitor DROP COLUMN id;
+DROP SEQUENCE filemodule_monitor_pk_seq;
+ALTER TABLE filemodule_monitor ADD FOREIGN KEY (filemodule_id) REFERENCES frs_package ON DELETE CASCADE ON UPDATE CASCADE;
+
+ALTER TABLE prdb_dbs ADD FOREIGN KEY (created_by) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
+
+ALTER TABLE trove_treesums DROP COLUMN trove_treesums_id;
+DROP SEQUENCE trove_treesums_pk_seq;
+
+ALTER TABLE prdb_dbs ADD FOREIGN KEY (created_by) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
+
+ALTER TABLE mail_group_list ADD FOREIGN KEY (list_admin) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;