You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by ga...@apache.org on 2006/11/16 08:49:57 UTC
svn commit: r475615 - in /incubator/roller/trunk/metadata/database:
200-to-210-migration.vm 210-to-230-migration.vm 230-to-240-migration.vm
Author: gangolli
Date: Wed Nov 15 23:49:56 2006
New Revision: 475615
URL: http://svn.apache.org/viewvc?view=rev&rev=475615
Log:
Use addColumnNull macro uniformly.
Modified:
incubator/roller/trunk/metadata/database/200-to-210-migration.vm
incubator/roller/trunk/metadata/database/210-to-230-migration.vm
incubator/roller/trunk/metadata/database/230-to-240-migration.vm
Modified: incubator/roller/trunk/metadata/database/200-to-210-migration.vm
URL: http://svn.apache.org/viewvc/incubator/roller/trunk/metadata/database/200-to-210-migration.vm?view=diff&rev=475615&r1=475614&r2=475615
==============================================================================
--- incubator/roller/trunk/metadata/database/200-to-210-migration.vm (original)
+++ incubator/roller/trunk/metadata/database/200-to-210-migration.vm Wed Nov 15 23:49:56 2006
@@ -13,7 +13,8 @@
#addColumnNotNull("website" "commentmod" $BOOLEAN_SQL_TYPE $BOOLEAN_FALSE)
#addColumnNotNull("website" "defaultallowcomments" $BOOLEAN_SQL_TYPE $BOOLEAN_TRUE)
#addColumnNotNull("website" "defaultcommentdays" "integer" 7)
-alter table website add column blacklist $TEXT_SQL_TYPE;
+#addColumnNull("website" "blacklist" $TEXT_SQL_TYPE)
+
update website set commentmod=$BOOLEAN_FALSE, defaultallowcomments=$BOOLEAN_TRUE, defaultcommentdays=7, blacklist='', datecreated=datecreated;
-- Add weblog displaydays column
Modified: incubator/roller/trunk/metadata/database/210-to-230-migration.vm
URL: http://svn.apache.org/viewvc/incubator/roller/trunk/metadata/database/210-to-230-migration.vm?view=diff&rev=475615&r1=475614&r2=475615
==============================================================================
--- incubator/roller/trunk/metadata/database/210-to-230-migration.vm (original)
+++ incubator/roller/trunk/metadata/database/210-to-230-migration.vm Wed Nov 15 23:49:56 2006
@@ -11,8 +11,8 @@
-- Roller 2.3 schema changes
-alter table weblogentry add column summary $TEXT_SQL_TYPE default null;
-alter table weblogentry add column content_type varchar(48) default null;
-alter table weblogentry add column content_src varchar(255) default null;
+#addColumnNull("weblogentry" "summary" $TEXT_SQL_TYPE)
+#addColumnNull("weblogentry" "content_type" "varchar(48)")
+#addColumnNull("weblogentry" "content_src" "varchar(255)")
Modified: incubator/roller/trunk/metadata/database/230-to-240-migration.vm
URL: http://svn.apache.org/viewvc/incubator/roller/trunk/metadata/database/230-to-240-migration.vm?view=diff&rev=475615&r1=475614&r2=475615
==============================================================================
--- incubator/roller/trunk/metadata/database/230-to-240-migration.vm (original)
+++ incubator/roller/trunk/metadata/database/230-to-240-migration.vm Wed Nov 15 23:49:56 2006
@@ -8,4 +8,4 @@
#addColumnNotNull("pingtarget" "autoenabled" $BOOLEAN_SQL_TYPE $BOOLEAN_FALSE)
-alter table website add column lastmodified $TIMESTAMP_SQL_TYPE default null;
+#addColumnNull("website" "lastmodified" $TIMESTAMP_SQL_TYPE)