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/10/10 22:02:18 UTC
svn commit: r583598 - in /roller/branches/roller_4.1_dev:
apps/weblogger/src/sql/400-to-410-migration.vm metadata/database/macros.vm
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