svn commit: r573871 - /roller/trunk/apps/weblogger/web/WEB-INF/classes/dbscripts/mysql/130-to-200-migration.sql

[sn...@apache.org]

Author: snoopdave
Date: Sat Sep  8 08:57:26 2007
New Revision: 573871

URL: http://svn.apache.org/viewvc?rev=573871&view=rev
Log:
Fixes for some MySQL 1.3 to 2.0 upgrade problems found by Eric Wittle:
http://opensource.atlassian.com/projects/roller/browse/ROL-1536
http://opensource.atlassian.com/projects/roller/browse/ROL-1538

Modified:
    roller/trunk/apps/weblogger/web/WEB-INF/classes/dbscripts/mysql/130-to-200-migration.sql

Modified: roller/trunk/apps/weblogger/web/WEB-INF/classes/dbscripts/mysql/130-to-200-migration.sql
URL: http://svn.apache.org/viewvc/roller/trunk/apps/weblogger/web/WEB-INF/classes/dbscripts/mysql/130-to-200-migration.sql?rev=573871&r1=573870&r2=573871&view=diff
==============================================================================
--- roller/trunk/apps/weblogger/web/WEB-INF/classes/dbscripts/mysql/130-to-200-migration.sql (original)
+++ roller/trunk/apps/weblogger/web/WEB-INF/classes/dbscripts/mysql/130-to-200-migration.sql Sat Sep  8 08:57:26 2007
@@ -137,6 +137,16 @@
 
 -- -----------------------------------------------------
 
+-- See ROL-1538
+alter table website add column isenabled tinyint(1) default 1;
+update website set isenabled=1;
+alter table website modify isenabled tinyint(1) default 1 not null; 
+
+-- See ROL-1536
+update folder set name='root' where name='top'; 
+
+-- -----------------------------------------------------
+
 -- Removing all indexes, foreign key with long names to support DB2
 
 alter table website drop foreign key website_userid_fk;
@@ -163,12 +173,12 @@
 alter table userrole drop index userrole_username_index;
 alter table usercookie drop index usercookie_username_index;
 alter table usercookie drop index usercookie_cookieid_index;
-alter table webpage drop index webpage_name_index;
-alter table webpage drop index webpage_link_index;
+-- See ROL-1538 -- alter table webpage drop index webpage_name_index;
+-- See ROL-1538 -- alter table webpage drop index webpage_link_index;
 alter table webpage drop index webpage_id_index;
 alter table website drop index website_id_index;
 alter table website drop index website_userid_index;
-alter table website drop index website_isenabled_index;
+-- See ROL-1538 -- alter table website drop index website_isenabled_index;
 alter table folder drop index folder_websiteid_index;
 alter table folderassoc drop index folderassoc_folderid_index;
 alter table folderassoc drop index folderassoc_ancestorid_index;