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/14 21:26:29 UTC
svn commit: r356859 - in /incubator/roller/trunk/metadata/database:
control-derby.vm createdb.vm
Author: snoopdave
Date: Wed Dec 14 12:25:48 2005
New Revision: 356859
URL: http://svn.apache.org/viewcvs?rev=356859&view=rev
Log:
Derby timestamp fix, plus index for weblogentry.status
Modified:
incubator/roller/trunk/metadata/database/control-derby.vm
incubator/roller/trunk/metadata/database/createdb.vm
Modified: incubator/roller/trunk/metadata/database/control-derby.vm
URL: http://svn.apache.org/viewcvs/incubator/roller/trunk/metadata/database/control-derby.vm?rev=356859&r1=356858&r2=356859&view=diff
==============================================================================
--- incubator/roller/trunk/metadata/database/control-derby.vm (original)
+++ incubator/roller/trunk/metadata/database/control-derby.vm Wed Dec 14 12:25:48 2005
@@ -16,7 +16,7 @@
#set( $INDEXSIZE = "")
#set( $INDEXSIZE_LARGE = "")
#set( $ADDL_FK_PARAMS = "")
-#set( $TIMESTAMP_SQL_TYPE_NULL = "timestamp null")
+#set( $TIMESTAMP_SQL_TYPE_NULL = "timestamp")
#foreach ($template in $templates)
#set($in = "${template}.vm")
Modified: incubator/roller/trunk/metadata/database/createdb.vm
URL: http://svn.apache.org/viewcvs/incubator/roller/trunk/metadata/database/createdb.vm?rev=356859&r1=356858&r2=356859&view=diff
==============================================================================
--- incubator/roller/trunk/metadata/database/createdb.vm (original)
+++ incubator/roller/trunk/metadata/database/createdb.vm Wed Dec 14 12:25:48 2005
@@ -198,6 +198,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,