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);
