roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From snoopd...@apache.org
Subject svn commit: r503303 - /incubator/roller/trunk/metadata/database/310-to-320-migration.vm
Date Sat, 03 Feb 2007 20:47:07 GMT
Author: snoopdave
Date: Sat Feb  3 12:47:07 2007
New Revision: 503303

URL: http://svn.apache.org/viewvc?view=rev&rev=503303
Log:
preserve posttime timestamp

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=503303&r1=503302&r2=503303
==============================================================================
--- 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:47:07 2007
@@ -30,10 +30,10 @@
 create index co_status_idx on roller_comment(status);
 
 -- update existing data to use new status column
-update roller_comment set status = 'APPROVED' where approved=1;
-update roller_comment set status = 'PENDING' where pending=1;
-update roller_comment set status = 'SPAM' where spam=1;
-update roller_comment set status = 'DISAPPROVED' where approved=0 and spam=0 and pending=0;
+update roller_comment set status = 'APPROVED', posttime=posttime where approved=1;
+update roller_comment set status = 'PENDING', posttime=posttime where pending=1;
+update roller_comment set status = 'SPAM', posttime=posttime where spam=1;
+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();



Mime
View raw message