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 2007/02/03 21:48:17 UTC

svn commit: r503304 - /incubator/roller/trunk/metadata/database/310-to-320-migration.vm

Author: snoopdave
Date: Sat Feb  3 12:48:17 2007
New Revision: 503304

URL: http://svn.apache.org/viewvc?view=rev&rev=503304
Log:
Preserve pubtime and updatetime timestamps

Modified:
    incubator/roller/trunk/metadata/database/310-to-320-migration.vm

Modified: incubator/roller/trunk/metadata/database/310-to-320-migration.vm
URL: http://svn.apache.org/viewvc/incubator/roller/trunk/metadata/database/310-to-320-migration.vm?view=diff&rev=503304&r1=503303&r2=503304
==============================================================================
--- incubator/roller/trunk/metadata/database/310-to-320-migration.vm (original)
+++ incubator/roller/trunk/metadata/database/310-to-320-migration.vm Sat Feb  3 12:48:17 2007
@@ -36,7 +36,7 @@
 update roller_comment set status = 'DISAPPROVED', posttime=posttime where approved=0 and spam=0 and pending=0;
 
 -- add new status option 'SCHEDULED' for future published entries
-update weblogentry set status = 'SCHEDULED' where pubtime > now();
+update weblogentry set status = 'SCHEDULED', pubtime=pubtime, updatetime=updatetime where pubtime > now();
 
 -- add new client column to roller_tasklock table
 #addColumnNull("roller_tasklock" "client" "varchar(255)")