Author: snoopdave
Date: Sun Oct 16 14:08:53 2011
New Revision: 1184825
URL: http://svn.apache.org/viewvc?rev=1184825&view=rev
Log:
start of a 5.1 migration script
Added:
roller/trunk/weblogger-business/src/main/resources/sql/500-to-510-migration.vm
Modified:
roller/trunk/weblogger-business/src/main/resources/sql/dbscripts.properties
Added:
roller/trunk/weblogger-business/src/main/resources/sql/500-to-510-migration.vm
URL:
http://svn.apache.org/viewvc/roller/trunk/weblogger-business/src/main/resources/sql/500-to-510-migration.vm?rev=1184825&view=auto
==============================================================================
---
roller/trunk/weblogger-business/src/main/resources/sql/500-to-510-migration.vm
(added)
+++
roller/trunk/weblogger-business/src/main/resources/sql/500-to-510-migration.vm
Sun Oct 16 14:08:53 2011
@@ -0,0 +1,26 @@
+#**
+500-to-510-migration.vm: Velocity template that generates vendor-specific
database scripts
+
+DON'T RUN THIS, IT'S NOT A DATABASE CREATION SCRIPT!!!
+**#
+
+create table rol_weblogtheme (
+ id varchar(48) not null primary key,
+ weblogid varchar(48) not null,
+ name varchar(255) not null,
+ custom $db.BOOLEAN_SQL_TYPE_FALSE not null,
+ #columnNotNullWithDefault('type' 'varchar(16)' 'standard')
+);
+
+create table rol_templatecode (
+ id varchar(48) not null primary key,
+ templateid varchar(48) not null,
+ template $db.TEXT_SQL_TYPE not null,
+ templatelang varchar(48),
+ contenttype varchar(48),
+ #columnNotNullWithDefault('type' 'varchar(16)' 'standard')
+);
+
+#addColumnNull("webpage" "type" "varchar(16)")
+
+
Modified:
roller/trunk/weblogger-business/src/main/resources/sql/dbscripts.properties
URL:
http://svn.apache.org/viewvc/roller/trunk/weblogger-business/src/main/resources/sql/dbscripts.properties?rev=1184825&r1=1184824&r2=1184825&view=diff
==============================================================================
--- roller/trunk/weblogger-business/src/main/resources/sql/dbscripts.properties
(original)
+++ roller/trunk/weblogger-business/src/main/resources/sql/dbscripts.properties
Sun Oct 16 14:08:53 2011
@@ -7,5 +7,5 @@ databases=db2 derby hsqldb mssql mysql o
# list all db templates to generate, separated by spaces
templates=createdb 200-to-210-migration 210-to-230-migration \
230-to-240-migration 240-to-300-migration 300-to-310-migration \
-310-to-400-migration 400-to-500-migration
+310-to-400-migration 400-to-500-migration, 500-to-510-migration
