roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From snoopd...@apache.org
Subject svn commit: r386671 - /incubator/roller/trunk/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql
Date Fri, 17 Mar 2006 16:55:52 GMT
Author: snoopdave
Date: Fri Mar 17 08:55:50 2006
New Revision: 386671

URL: http://svn.apache.org/viewcvs?rev=386671&view=rev
Log:
Fixing ROL-1081 in trunk

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

Modified: incubator/roller/trunk/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql
URL: http://svn.apache.org/viewcvs/incubator/roller/trunk/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql?rev=386671&r1=386670&r2=386671&view=diff
==============================================================================
--- incubator/roller/trunk/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql (original)
+++ incubator/roller/trunk/web/WEB-INF/dbscripts/mysql/130-to-200-migration.sql Fri Mar 17
08:55:50 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);



Mime
View raw message