mvhub-dev team mailing list archive

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

James Reynolds Jr. has proposed merging lp:~jimbox-comcast/mvhub/remove_db_tables into lp:mvhub.

Requested reviews:
  MVHub devs with commit rights (mvhub-commit)


Added a script to remove three tables from the database.
1 file added: /app-mvhub/setup/database/sql/004_remove_unused_tables_and_seq.sql

-- 
https://code.launchpad.net/~jimbox-comcast/mvhub/remove_db_tables/+merge/27206
Your team MVHub Developers is subscribed to branch lp:mvhub.

=== 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-09 22:15:40 +0000
@@ -0,0 +1,9 @@
+--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;
+
+COMMIT;