roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From snoopd...@apache.org
Subject svn commit: r356859 - in /incubator/roller/trunk/metadata/database: control-derby.vm createdb.vm
Date Wed, 14 Dec 2005 20:26:29 GMT
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,



Mime
View raw message