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,
