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 2006/10/05 17:17:34 UTC
svn commit: r453264 - in /incubator/roller/trunk/metadata/database:
300-to-310-migration.vm control.vm
Author: snoopdave
Date: Thu Oct 5 08:17:33 2006
New Revision: 453264
URL: http://svn.apache.org/viewvc?view=rev&rev=453264
Log:
Adding tag tables and 3.1 migration script
Modified:
incubator/roller/trunk/metadata/database/300-to-310-migration.vm
incubator/roller/trunk/metadata/database/control.vm
Modified: incubator/roller/trunk/metadata/database/300-to-310-migration.vm
URL: http://svn.apache.org/viewvc/incubator/roller/trunk/metadata/database/300-to-310-migration.vm?view=diff&rev=453264&r1=453263&r2=453264
==============================================================================
--- incubator/roller/trunk/metadata/database/300-to-310-migration.vm (original)
+++ incubator/roller/trunk/metadata/database/300-to-310-migration.vm Thu Oct 5 08:17:33 2006
@@ -4,4 +4,26 @@
DON'T RUN THIS, IT'S NOT A DATABASE CREATION SCRIPT!!!
**#
-alter table rag_group_subscription drop column id;
\ No newline at end of file
+alter table rag_group_subscription drop column id;
+
+create table weblogentrytag (
+ id varchar(48) not null primary key,
+ entryid varchar(48) not null,
+ websiteid varchar(48) not null,
+ userid varchar(48) not null,
+ name varchar(255) not null,
+ time $TIMESTAMP_SQL_TYPE not null
+);
+create index wet_entryid_idx on weblogentrytag( entryid );
+create index wet_websiteid_idx on weblogentrytag( websiteid );
+create index wet_userid_idx on weblogentrytag( userid );
+create index wet_name_idx on weblogentrytag( name );
+
+create table weblogtagagg (
+ id varchar(48) not null primary key,
+ websiteid varchar(48) ,
+ name varchar(255) not null,
+ count integer not null
+);
+create index weta_websiteid_idx on weblogtagagg( websiteid );
+create index weta_name_idx on weblogtagagg( name );
\ No newline at end of file
Modified: incubator/roller/trunk/metadata/database/control.vm
URL: http://svn.apache.org/viewvc/incubator/roller/trunk/metadata/database/control.vm?view=diff&rev=453264&r1=453263&r2=453264
==============================================================================
--- incubator/roller/trunk/metadata/database/control.vm (original)
+++ incubator/roller/trunk/metadata/database/control.vm Thu Oct 5 08:17:33 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-230-migration", "230-to-240-migration", "240-to-300-migration"])
+#set( $templates = ["createdb", "200-to-210-migration", "210-to-230-migration", "230-to-240-migration", "240-to-300-migration", "300-to-310-migration"])
#**