svn commit: r573870 - /roller/branches/roller_3.1/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql

[sn...@apache.org]

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

URL: http://svn.apache.org/viewvc?rev=573870&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/branches/roller_3.1/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql

Modified: roller/branches/roller_3.1/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql
URL: http://svn.apache.org/viewvc/roller/branches/roller_3.1/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql?rev=573870&r1=573869&r2=573870&view=diff
==============================================================================
--- roller/branches/roller_3.1/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql (original)
+++ roller/branches/roller_3.1/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql Sat Sep  8 08:57:08 2007
@@ -61,6 +61,11 @@
 update weblogentry set status='', pubtime=pubtime, updatetime=updatetime;
 alter table weblogentry modify status varchar(20) not null;
 
+-- add new column which holds the locale for a weblog entry
+-- then set the values and make column not null
+alter table weblogentry add column locale varchar(20) default null;
+create index we_locale_idx on weblogentry(locale);
+
 create index we_status_idx on weblogentry(status);
 create index weblogentry_userid_index on weblogentry(userid);
 
@@ -124,7 +129,7 @@
 
 -- Transfer old column data to the new column.  This is not critical as currently it is not used, and
 -- later the data will be generated by usage in the ping processor.
-update pingtarget set conditioncode=condition;
+-- update pingtarget set conditioncode=condition;
 
 -- Drop the old column 
 -- Don't do this until you're sure you don't need to back-off to Roller 1.2
@@ -132,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;
@@ -158,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;