svn commit: r483643 - in /incubator/roller/trunk/metadata/database: 310-to-320-migration.vm createdb.vm

[ag...@apache.org]

Author: agilliland
Date: Thu Dec  7 12:14:48 2006
New Revision: 483643

URL: http://svn.apache.org/viewvc?view=rev&rev=483643
Log:
just use varchar(255) for new 'path' columns in folder and weblogentry tables.


Modified:
    incubator/roller/trunk/metadata/database/310-to-320-migration.vm
    incubator/roller/trunk/metadata/database/createdb.vm

Modified: incubator/roller/trunk/metadata/database/310-to-320-migration.vm
URL: http://svn.apache.org/viewvc/incubator/roller/trunk/metadata/database/310-to-320-migration.vm?view=diff&rev=483643&r1=483642&r2=483643
==============================================================================
--- incubator/roller/trunk/metadata/database/310-to-320-migration.vm (original)
+++ incubator/roller/trunk/metadata/database/310-to-320-migration.vm Thu Dec  7 12:14:48 2006
@@ -9,23 +9,15 @@
 create index ws_parentid_idx on weblogcategory( parentid );
 
 -- add new path column to weblogcategory table
-#if($DBTYPE == "MYSQL")
-    #addColumnNull("weblogcategory" "path" $TEXT_SQL_TYPE)
-#else
-    #addColumnNull("weblogcategory" "path" "varchar(1000)")
-#end
-create index ws_path_idx on weblogcategory( path$!INDEXSIZE );
+#addColumnNull("weblogcategory" "path" "varchar(255)")
+create index ws_path_idx on weblogcategory( path );
 
 -- need to add this index for existing folder.parentid
 create index fo_parentid_idx on folder( parentid );
 
 -- add new path column to folder table
-#if($DBTYPE == "MYSQL")
-    #addColumnNull("folder" "path" $TEXT_SQL_TYPE)
-#else
-    #addColumnNull("folder" "path" "varchar(1000)")
-#end
-create index fo_path_idx on folder( path$!INDEXSIZE );
+#addColumnNull("folder" "path" "varchar(255)")
+create index fo_path_idx on folder( path );
 
 
 -- some various indexes to improve performance

Modified: incubator/roller/trunk/metadata/database/createdb.vm
URL: http://svn.apache.org/viewvc/incubator/roller/trunk/metadata/database/createdb.vm?view=diff&rev=483643&r1=483642&r2=483643
==============================================================================
--- incubator/roller/trunk/metadata/database/createdb.vm (original)
+++ incubator/roller/trunk/metadata/database/createdb.vm Thu Dec  7 12:14:48 2006
@@ -130,11 +130,11 @@
     description      varchar(255),
     websiteid        varchar(48) not null,
     parentid         varchar(48),
-    path             #longtext(1000) 
+    path             varchar(255) 
 );
 create index fo_websiteid_idx on folder( websiteid );
 create index fo_parentid_idx on folder( parentid );
--- Can't index a CLOB create index fo_path_idx on folder( path$!INDEXSIZE );
+create index fo_path_idx on folder( path );
 
 create table folderassoc (
     id               varchar(48) not null primary key,
@@ -166,11 +166,11 @@
     websiteid        varchar(48)  not null,
     image            varchar(255),
     parentid         varchar(48),
-    path             #longtext(1000)
+    path             varchar(255)
 );
 create index wc_websiteid_idx on weblogcategory( websiteid );
 create index ws_parentid_idx on weblogcategory( parentid );
--- Can't index a CLOB create index ws_path_idx on weblogcategory( path$!INDEXSIZE );
+create index ws_path_idx on weblogcategory( path );
 
 create table weblogcategoryassoc (
     id               varchar(48) not null primary key,