You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by ag...@apache.org on 2006/09/01 01:40:50 UTC

svn commit: r439104 - in /incubator/roller/branches/roller_3.0/metadata/database: 240-to-300-migration.vm createdb.vm

Author: agilliland
Date: Thu Aug 31 16:40:50 2006
New Revision: 439104

URL: http://svn.apache.org/viewvc?rev=439104&view=rev
Log:
need an index on new weblogentry.locale database column.


Modified:
    incubator/roller/branches/roller_3.0/metadata/database/240-to-300-migration.vm
    incubator/roller/branches/roller_3.0/metadata/database/createdb.vm

Modified: incubator/roller/branches/roller_3.0/metadata/database/240-to-300-migration.vm
URL: http://svn.apache.org/viewvc/incubator/roller/branches/roller_3.0/metadata/database/240-to-300-migration.vm?rev=439104&r1=439103&r2=439104&view=diff
==============================================================================
--- incubator/roller/branches/roller_3.0/metadata/database/240-to-300-migration.vm (original)
+++ incubator/roller/branches/roller_3.0/metadata/database/240-to-300-migration.vm Thu Aug 31 16:40:50 2006
@@ -16,6 +16,7 @@
 -- add new column which holds the locale for a weblog entry
 -- then set the values and make column not null
 #addColumnNull("weblogentry" "locale" "varchar(20)")
+create index we_locale_idx on weblogentry(locale);
 
 -- add new column which holds the hidden status for a page, default is false
 #addColumnNotNull("webpage" "hidden" $BOOLEAN_SQL_TYPE $BOOLEAN_FALSE)

Modified: incubator/roller/branches/roller_3.0/metadata/database/createdb.vm
URL: http://svn.apache.org/viewvc/incubator/roller/branches/roller_3.0/metadata/database/createdb.vm?rev=439104&r1=439103&r2=439104&view=diff
==============================================================================
--- incubator/roller/branches/roller_3.0/metadata/database/createdb.vm (original)
+++ incubator/roller/branches/roller_3.0/metadata/database/createdb.vm Thu Aug 31 16:40:50 2006
@@ -206,6 +206,7 @@
 create index we_pubentry_idx on weblogentry(publishentry);
 create index we_userid_idx on weblogentry(userid);
 create index we_status_idx on weblogentry(status);
+create index we_locale_idx on weblogentry(locale);
 
 create table newsfeed (
     id              varchar(48) not null primary key,