svn commit: r464617 - /incubator/roller/trunk/metadata/database/300-to-310-migration.vm

[el...@apache.org]

Author: eliast
Date: Mon Oct 16 11:36:17 2006
New Revision: 464617

URL: http://svn.apache.org/viewvc?view=rev&rev=464617
Log:
- Refactored tagging table names to have a roller- prefix

Modified:
    incubator/roller/trunk/metadata/database/300-to-310-migration.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=464617&r1=464616&r2=464617
==============================================================================
--- incubator/roller/trunk/metadata/database/300-to-310-migration.vm (original)
+++ incubator/roller/trunk/metadata/database/300-to-310-migration.vm Mon Oct 16 11:36:17 2006
@@ -6,7 +6,7 @@
 
 alter table rag_group_subscription drop column id;
 
-create table weblogentrytag (
+create table roller_weblogentrytag (
     id              varchar(48)   not null primary key,
     entryid         varchar(48)   not null,
     websiteid       varchar(48)   not null,    
@@ -15,12 +15,12 @@
     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 index wet_entryid_idx on roller_weblogentrytag( entryid );
+create index wet_websiteid_idx on roller_weblogentrytag( websiteid );
+create index wet_userid_idx on roller_weblogentrytag( userid );
+create index wet_name_idx on roller_weblogentrytag( name );
 
-create table weblogentrytagagg (
+create table roller_weblogentrytagagg (
     id              varchar(48)   not null primary key,
     websiteid       varchar(48) ,    
     name            varchar(255)  not null,
@@ -28,9 +28,9 @@
     lastused        $TIMESTAMP_SQL_TYPE 	not null
 );
 
-create index weta_websiteid_idx on weblogentrytagagg( websiteid );
-create index weta_name_idx on weblogentrytagagg( name );
-create index weta_lastused_idx on weblogentrytagagg( lastused );
+create index weta_websiteid_idx on roller_weblogentrytagagg( websiteid );
+create index weta_name_idx on roller_weblogentrytagagg( name );
+create index weta_lastused_idx on roller_weblogentrytagagg( lastused );
 
 create table roller_tasklock (
     id              varchar(48)   not null primary key,