mvhub-dev team mailing list archive

[noreply@xxxxxxxxxxxxx]

Merge authors:
  James Reynolds <jimbox@xxxxxxxxxx>
Related merge proposals:
  https://code.launchpad.net/~jimbox-comcast/mvhub/remove_db_tables/+merge/27206
  proposed by: James Reynolds Jr. (jimbox-comcast)
  review: Approve - Dan MacNeil (omacneil)
------------------------------------------------------------
revno: 405 [merge]
committer: Dan MacNeil <dan@xxxxxxxxxx>
branch nick: trunk
timestamp: Sun 2010-06-13 12:44:57 -0400
message:
  merged jimbox-comcast/mvhub/remove_db_tables
added:
  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

=== added 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	1970-01-01 00:00:00 +0000
+++ app-mvhub/setup/database/sql/004_remove_unused_tables_and_seq.sql	2010-06-10 20:15:47 +0000
@@ -0,0 +1,11 @@
+--add version number and note before you add the other sql
+BEGIN;
+
+INSERT INTO version_log ( version,note ) 
+	VALUES (4,'Remove user_type, log_category_search, and web_request tables.');
+
+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;
+     
+COMMIT;