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,