[vhffs-dev] [473] Disable DROP TABLE until 4.1 is ready

[subversion@xxxxxxxxx]

Revision: 473
Author:   beuss
Date:     2007-02-17 12:32:01 +0000 (Sat, 17 Feb 2007)

Log Message:
-----------
Disable DROP TABLE until 4.1 is ready

Modified Paths:
--------------
    branches/vhffs_4.1/vhffs-compat/4.0.sql


Modified: branches/vhffs_4.1/vhffs-compat/4.0.sql
===================================================================
--- branches/vhffs_4.1/vhffs-compat/4.0.sql	2007-02-17 11:47:37 UTC (rev 472)
+++ branches/vhffs_4.1/vhffs-compat/4.0.sql	2007-02-17 12:32:01 UTC (rev 473)
@@ -69,14 +69,14 @@
     FROM vhffs_user_info ui
     WHERE ui.uid = vhffs_users.uid;
 
-DROP TABLE vhffs_user_info;
+-- DROP TABLE vhffs_user_info;
 
 -- merge vhffs_notes to vhffs_users
 ALTER TABLE vhffs_users ADD COLUMN note int4;
 UPDATE vhffs_users SET note = 0 WHERE object_id NOT IN (SELECT object_id FROM vhffs_notes);
 UPDATE vhffs_users SET note = n.note FROM vhffs_notes n WHERE n.object_id = vhffs_users.object_id;
 
-DROP TABLE vhffs_notes;
+-- DROP TABLE vhffs_notes;
 
 -- merge vhffs_panel_user_prefs to vhffs_users
 ALTER TABLE vhffs_users ADD COLUMN language varchar(16);
@@ -87,7 +87,7 @@
     FROM vhffs_panel_user_prefs up
     WHERE up.uid = vhffs_users.uid;
 
-DROP TABLE vhffs_panel_user_prefs;
+-- DROP TABLE vhffs_panel_user_prefs;
 
 -- merge vhffs_groups_info to vhffs_groups
 ALTER TABLE vhffs_groups ADD COLUMN owner_uid int4;
@@ -96,7 +96,7 @@
     FROM vhffs_groups_info gi
     WHERE gi.gid = vhffs_groups.gid;
 
-DROP TABLE vhffs_groups_info;
+-- DROP TABLE vhffs_groups_info;
 
 -- merge vhffs_ml_prefs to vhffs_ml
 ALTER TABLE vhffs_ml ADD COLUMN admin varchar(250);
@@ -117,13 +117,13 @@
     FROM vhffs_ml_prefs mlp
     WHERE mlp.ml_id = vhffs_ml.ml_id;
 
-DROP TABLE vhffs_ml_prefs;
+-- DROP TABLE vhffs_ml_prefs;
 
 -- merge vhffs_ml_lang to vhffs_ml_subscribers
 ALTER TABLE vhffs_ml_subscribers ADD COLUMN language varchar(16);
 UPDATE vhffs_ml_subscribers SET language = mll.lang FROM vhffs_ml_lang mll WHERE mll.member = vhffs_ml_subscribers.member;
 
-DROP TABLE vhffs_ml_lang;
+-- DROP TABLE vhffs_ml_lang;
 
 -- update vhffs_forum view
 DROP VIEW vhffs_forum;