mvhub-dev team mailing list archive

Thread
Date

[Branch ~mvhub-commit/mvhub/trunk] Rev 416: production / dev db mismatch kludgery

To: MVHub Developers <mvhub-dev@xxxxxxxxxxxxxxxxxxx>
From: noreply@xxxxxxxxxxxxx
Date: Fri, 18 Jun 2010 19:43:14 -0000
Reply-to: noreply@xxxxxxxxxxxxx
Sender: bounces@xxxxxxxxxxxxx

------------------------------------------------------------
revno: 416
committer: Dan MacNeil <dan@xxxxxxxxxx>
branch nick: trunk
timestamp: Fri 2010-06-18 15:39:24 -0400
message:
  production / dev db mismatch kludgery
  
  drop seq only if it exists 
modified:
  app-mvhub/setup/database/sql/004_remove_unused_tables_and_seq.sql


--
lp:mvhub
https://code.launchpad.net/~mvhub-commit/mvhub/trunk

Your team MVHub Developers is subscribed to branch lp:mvhub.
To unsubscribe from this branch go to https://code.launchpad.net/~mvhub-commit/mvhub/trunk/+edit-subscription

=== 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-18 18:56:01 +0000
+++ app-mvhub/setup/database/sql/004_remove_unused_tables_and_seq.sql	2010-06-18 19:39:24 +0000
@@ -4,7 +4,7 @@
 INSERT INTO version_log ( version,note ) 
 	VALUES (4,'Remove user_type, log_category_search, and web_request tables.');
 
-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 CASCADE;
 
 DROP TABLE user_type, log_category_search, web_requests CASCADE;