roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From snoopd...@apache.org
Subject svn commit: r583598 - in /roller/branches/roller_4.1_dev: apps/weblogger/src/sql/400-to-410-migration.vm metadata/database/macros.vm
Date Wed, 10 Oct 2007 20:02:18 GMT
Author: snoopdave
Date: Wed Oct 10 13:02:18 2007
New Revision: 583598

URL: http://svn.apache.org/viewvc?rev=583598&view=rev
Log:
Fixing remove-not-null-from-column logic

Modified:
    roller/branches/roller_4.1_dev/apps/weblogger/src/sql/400-to-410-migration.vm
    roller/branches/roller_4.1_dev/metadata/database/macros.vm

Modified: roller/branches/roller_4.1_dev/apps/weblogger/src/sql/400-to-410-migration.vm
URL: http://svn.apache.org/viewvc/roller/branches/roller_4.1_dev/apps/weblogger/src/sql/400-to-410-migration.vm?rev=583598&r1=583597&r2=583598&view=diff
==============================================================================
--- roller/branches/roller_4.1_dev/apps/weblogger/src/sql/400-to-410-migration.vm (original)
+++ roller/branches/roller_4.1_dev/apps/weblogger/src/sql/400-to-410-migration.vm Wed Oct
10 13:02:18 2007
@@ -39,13 +39,20 @@
 
 #dropNotNullFromColumn("website" "creator" "varchar(48)")
 #addColumnNull("website" "creator" "varchar(255)")
-update website as w set creator = (select u.username from rolleruser as u where u.id = w.userid);
+update website as w set 
+    lastmodified = lastmodified,
+    datecreated = datecreated,
+    creator = (select u.username from rolleruser as u where u.id = w.userid);
 
 #dropNotNullFromColumn("weblogentry" "userid" "varchar(48)")
 #addColumnNull("weblogentry" "creator" "varchar(255)")
-update weblogentry as w set creator = (select u.username from rolleruser as u where u.id
= w.userid);
+update weblogentry as w set
+    pubtime = pubtime,
+    updatetime = updatetime, 
+    creator = (select u.username from rolleruser as u where u.id = w.userid);
 
 #dropNotNullFromColumn("roller_weblogentrytag" "userid" "varchar(48)")
 #addColumnNull("roller_weblogentrytag" "creator" "varchar(255)")
-update roller_weblogentrytag as w set creator = (select u.username from rolleruser as u where
u.id = w.userid);
-
+update roller_weblogentrytag as w set 
+    time = time,
+    creator = (select u.username from rolleruser as u where u.id = w.userid);

Modified: roller/branches/roller_4.1_dev/metadata/database/macros.vm
URL: http://svn.apache.org/viewvc/roller/branches/roller_4.1_dev/metadata/database/macros.vm?rev=583598&r1=583597&r2=583598&view=diff
==============================================================================
Binary files /tmp/tmpJNfzev and /tmp/tmp556WPO differ



Mime
View raw message