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 2005/12/21 16:45:57 UTC
svn commit: r358307 - in
/incubator/roller/branches/roller_2.0/metadata/database:
130-to-200-migration-raw.sql createdb-raw.sql
Author: snoopdave
Date: Wed Dec 21 07:45:50 2005
New Revision: 358307
URL: http://svn.apache.org/viewcvs?rev=358307&view=rev
Log:
Index for weblogentry.status
Modified:
incubator/roller/branches/roller_2.0/metadata/database/130-to-200-migration-raw.sql
incubator/roller/branches/roller_2.0/metadata/database/createdb-raw.sql
Modified: incubator/roller/branches/roller_2.0/metadata/database/130-to-200-migration-raw.sql
URL: http://svn.apache.org/viewcvs/incubator/roller/branches/roller_2.0/metadata/database/130-to-200-migration-raw.sql?rev=358307&r1=358306&r2=358307&view=diff
==============================================================================
--- incubator/roller/branches/roller_2.0/metadata/database/130-to-200-migration-raw.sql (original)
+++ incubator/roller/branches/roller_2.0/metadata/database/130-to-200-migration-raw.sql Wed Dec 21 07:45:50 2005
@@ -45,6 +45,7 @@
update weblogentry set status='';
@ALTER_TABLE_WEBLOGENTRY_STATUS_NOT_NULL@;
+create index we_status_idx on weblogentry(status);
create index weblogentry_userid_index on weblogentry(userid);
alter table rolleruser add column isenabled @BOOLEAN_SQL_TYPE@;
Modified: incubator/roller/branches/roller_2.0/metadata/database/createdb-raw.sql
URL: http://svn.apache.org/viewcvs/incubator/roller/branches/roller_2.0/metadata/database/createdb-raw.sql?rev=358307&r1=358306&r2=358307&view=diff
==============================================================================
--- incubator/roller/branches/roller_2.0/metadata/database/createdb-raw.sql (original)
+++ incubator/roller/branches/roller_2.0/metadata/database/createdb-raw.sql Wed Dec 21 07:45:50 2005
@@ -194,6 +194,7 @@
create index we_pinnedtom_idx on weblogentry(pinnedtomain);
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 table newsfeed (
id varchar(48) not null primary key,