roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject svn commit: r356036 - /incubator/roller/branches/roller_2.0/metadata/database/130-to-200-migration-raw.sql
Date Sun, 11 Dec 2005 21:45:56 GMT
Author: bayard
Date: Sun Dec 11 13:45:54 2005
New Revision: 356036

fixing some bits for the 130->200 postgres migration


Modified: incubator/roller/branches/roller_2.0/metadata/database/130-to-200-migration-raw.sql
--- incubator/roller/branches/roller_2.0/metadata/database/130-to-200-migration-raw.sql (original)
+++ incubator/roller/branches/roller_2.0/metadata/database/130-to-200-migration-raw.sql Sun
Dec 11 13:45:54 2005
@@ -14,14 +14,17 @@
 alter table website add column handle varchar(255);
+update website set handle='';
 alter table website add column datecreated timestamp;
+update website set datecreated='20050101';
 alter table website add column emailaddress varchar(255);
+update website set emailaddress='';
 create index website_handle_index on website(handle);
@@ -34,24 +37,29 @@
 -- Add userid to weblogentry so we can track original creator of entry
 alter table weblogentry add column userid varchar(48);
+update weblogentry set userid='';
 alter table weblogentry add column status varchar(20);
+update weblogentry set status='';
 create index weblogentry_userid_index on weblogentry(userid);
 alter table rolleruser add column isenabled @BOOLEAN_SQL_TYPE@;
+update rolleruser set isenabled=true;
 alter table rolleruser add column locale varchar(50);
+update rolleruser set locale='';
 alter table rolleruser add column timezone varchar(50);
+update rolleruser set timezone='';
 create index user_isenabled_index on rolleruser( isenabled );
@@ -94,11 +102,12 @@
 -- have to remove the "not null" clause here.
 alter table pingtarget add column conditioncode integer;
+update pingtarget set conditioncode=0;
 -- 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 pt set pt.conditioncode=pt.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

View raw message