You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by sn...@apache.org on 2006/03/14 14:37:50 UTC
svn commit: r385800 - in
/incubator/roller/branches/roller_2.1/web/WEB-INF/dbscripts:
hsqldb/130-to-200-migration.sql mysql/130-to-200-migration.sql
postgresql/130-to-200-migration.sql
Author: snoopdave
Date: Tue Mar 14 05:37:47 2006
New Revision: 385800
URL: http://svn.apache.org/viewcvs?rev=385800&view=rev
Log:
Fixes ROL-1081, 1.3-2.0 migration script clears entry pubtime and updatetimes
Modified:
incubator/roller/branches/roller_2.1/web/WEB-INF/dbscripts/hsqldb/130-to-200-migration.sql
incubator/roller/branches/roller_2.1/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql
incubator/roller/branches/roller_2.1/web/WEB-INF/dbscripts/postgresql/130-to-200-migration.sql
Modified: incubator/roller/branches/roller_2.1/web/WEB-INF/dbscripts/hsqldb/130-to-200-migration.sql
URL: http://svn.apache.org/viewcvs/incubator/roller/branches/roller_2.1/web/WEB-INF/dbscripts/hsqldb/130-to-200-migration.sql?rev=385800&r1=385799&r2=385800&view=diff
==============================================================================
--- incubator/roller/branches/roller_2.1/web/WEB-INF/dbscripts/hsqldb/130-to-200-migration.sql (original)
+++ incubator/roller/branches/roller_2.1/web/WEB-INF/dbscripts/hsqldb/130-to-200-migration.sql Tue Mar 14 05:37:47 2006
@@ -37,12 +37,12 @@
-- Add userid to weblogentry so we can track original creator of entry
alter table weblogentry add column userid varchar(48);
alter table weblogentry alter userid varchar(48) default '';
-update weblogentry set userid='';
+update weblogentry set userid='', pubtime=pubtime, updatetime=updatetime;
alter table weblogentry alter userid varchar(48) not null;
alter table weblogentry add column status varchar(20);
alter table weblogentry alter status varchar(20) default '';
-update weblogentry set status='';
+update weblogentry set status='', pubtime=pubtime, updatetime=updatetime;
alter table weblogentry alter status varchar(20) not null;
create index we_status_idx on weblogentry(status);
Modified: incubator/roller/branches/roller_2.1/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql
URL: http://svn.apache.org/viewcvs/incubator/roller/branches/roller_2.1/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql?rev=385800&r1=385799&r2=385800&view=diff
==============================================================================
--- incubator/roller/branches/roller_2.1/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql (original)
+++ incubator/roller/branches/roller_2.1/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql Tue Mar 14 05:37:47 2006
@@ -37,12 +37,12 @@
-- Add userid to weblogentry so we can track original creator of entry
alter table weblogentry add column userid varchar(48);
alter table weblogentry modify userid varchar(48) default '';
-update weblogentry set userid='';
+update weblogentry set userid='', pubtime=pubtime, updatetime=updatetime;
alter table weblogentry modify userid varchar(48) not null;
alter table weblogentry add column status varchar(20);
alter table weblogentry modify status varchar(20) default '';
-update weblogentry set status='';
+update weblogentry set status='', pubtime=pubtime, updatetime=updatetime;
alter table weblogentry modify status varchar(20) not null;
create index we_status_idx on weblogentry(status);
Modified: incubator/roller/branches/roller_2.1/web/WEB-INF/dbscripts/postgresql/130-to-200-migration.sql
URL: http://svn.apache.org/viewcvs/incubator/roller/branches/roller_2.1/web/WEB-INF/dbscripts/postgresql/130-to-200-migration.sql?rev=385800&r1=385799&r2=385800&view=diff
==============================================================================
--- incubator/roller/branches/roller_2.1/web/WEB-INF/dbscripts/postgresql/130-to-200-migration.sql (original)
+++ incubator/roller/branches/roller_2.1/web/WEB-INF/dbscripts/postgresql/130-to-200-migration.sql Tue Mar 14 05:37:47 2006
@@ -37,12 +37,12 @@
-- Add userid to weblogentry so we can track original creator of entry
alter table weblogentry add column userid varchar(48);
alter table weblogentry alter userid set default '';
-update weblogentry set userid='';
+update weblogentry set userid='', pubtime=pubtime, updatetime=updatetime;
alter table weblogentry alter userid set not null;
alter table weblogentry add column status varchar(20);
alter table weblogentry alter status set default '';
-update weblogentry set status='';
+update weblogentry set status='', pubtime=pubtime, updatetime=updatetime;
alter table weblogentry alter status set not null;
create index we_status_idx on weblogentry(status);