mvhub-dev team mailing list archive

["James Reynolds Jr." <jreynoldm@xxxxxxxxx>]

James Reynolds Jr. has proposed merging lp:~jim-reynolds/mvhub/remove_additional_seq into lp:mvhub.

Requested reviews:
  MVHub devs with commit rights (mvhub-commit)
Related bugs:
  #592401 more sequences to drop synonym_id_sequence user_id_sequence   
  https://bugs.launchpad.net/bugs/592401


Adds a script to drop two vestigial sequences from the database.
-- 
https://code.launchpad.net/~jim-reynolds/mvhub/remove_additional_seq/+merge/27878
Your team MVHub Developers is subscribed to branch lp:mvhub.

=== modified file 'app-mvhub/setup/database/sql/004_remove_unused_tables_and_seq.sql'
--- app-mvhub/setup/database/sql/004_remove_unused_tables_and_seq.sql	2010-06-10 20:15:47 +0000
+++ app-mvhub/setup/database/sql/004_remove_unused_tables_and_seq.sql	2010-06-17 19:57:26 +0000
@@ -6,6 +6,7 @@
 
 DROP TABLE user_type, log_category_search, web_requests CASCADE;
 
-DROP SEQUENCE user_type_type_id_seq, log_category_search_search_id_seq, web_requests_id_seq;
+DROP SEQUENCE user_type_type_id_seq, log_category_search_search_id_seq, web_requests_id_seq,
+     	      synonym_id_sequence, user_id_sequence;
      
 COMMIT;