svn commit: r400118 - in /incubator/roller/trunk/metadata/database: 210-to-220-migration.vm 210-to-230-migration.vm 220-to-230-migration.vm control.vm

[sn...@apache.org]

Author: snoopdave
Date: Fri May  5 10:40:40 2006
New Revision: 400118

URL: http://svn.apache.org/viewcvs?rev=400118&view=rev
Log:
One migration script for 2.1 to 2.3

Added:
    incubator/roller/trunk/metadata/database/210-to-230-migration.vm
Removed:
    incubator/roller/trunk/metadata/database/210-to-220-migration.vm
    incubator/roller/trunk/metadata/database/220-to-230-migration.vm
Modified:
    incubator/roller/trunk/metadata/database/control.vm

Added: incubator/roller/trunk/metadata/database/210-to-230-migration.vm
URL: http://svn.apache.org/viewcvs/incubator/roller/trunk/metadata/database/210-to-230-migration.vm?rev=400118&view=auto
==============================================================================
--- incubator/roller/trunk/metadata/database/210-to-230-migration.vm (added)
+++ incubator/roller/trunk/metadata/database/210-to-230-migration.vm Fri May  5 10:40:40 2006
@@ -0,0 +1,18 @@
+#** 
+220-to-230-migration.vm: Velocity template that generates vendor-specific database scripts 
+
+DON'T RUN THIS, IT'S NOT A DATABASE CREATION SCRIPT!!!
+**#
+
+-- Roller 2.2 schema changes
+
+#addColumnNotNull("website" "isactive" $BOOLEAN_SQL_TYPE $BOOLEAN_TRUE)
+update website set isactive=$BOOLEAN_TRUE, datecreated=datecreated;
+
+-- 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;
+
+

Modified: incubator/roller/trunk/metadata/database/control.vm
URL: http://svn.apache.org/viewcvs/incubator/roller/trunk/metadata/database/control.vm?rev=400118&r1=400117&r2=400118&view=diff
==============================================================================
--- incubator/roller/trunk/metadata/database/control.vm (original)
+++ incubator/roller/trunk/metadata/database/control.vm Fri May  5 10:40:40 2006
@@ -5,7 +5,7 @@
 Follow the installation guide for instructions on setting up your database.
 
 #** Define templates to be generated **#
-#set( $templates = ["createdb", "200-to-210-migration", "210-to-220-migration", "220-to-230-migration"]) 
+#set( $templates = ["createdb", "200-to-210-migration", "210-to-230-migration"]) 
 
 #** Define special macro needed for alter table with not-null restriction **#
 #macro(addColumnNotNull $table $column $type $default)