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:57:19 UTC
svn commit: r358309 -
/incubator/roller/trunk/metadata/database/200-to-210-migration.vm
Author: snoopdave
Date: Wed Dec 21 07:57:16 2005
New Revision: 358309
URL: http://svn.apache.org/viewcvs?rev=358309&view=rev
Log:
Added weblogentry.status index, just in case
Modified:
incubator/roller/trunk/metadata/database/200-to-210-migration.vm
Modified: incubator/roller/trunk/metadata/database/200-to-210-migration.vm
URL: http://svn.apache.org/viewcvs/incubator/roller/trunk/metadata/database/200-to-210-migration.vm?rev=358309&r1=358308&r2=358309&view=diff
==============================================================================
--- incubator/roller/trunk/metadata/database/200-to-210-migration.vm (original)
+++ incubator/roller/trunk/metadata/database/200-to-210-migration.vm Wed Dec 21 07:57:16 2005
@@ -5,19 +5,16 @@
**#
-- Add to roller_comment table: approved and pending fields
-
#addColumnNotNull("roller_comment" "approved" $BOOLEAN_SQL_TYPE $BOOLEAN_TRUE)
#addColumnNotNull("roller_comment" "pending" $BOOLEAN_SQL_TYPE $BOOLEAN_FALSE)
update roller_comment set approved=$BOOLEAN_TRUE, pending=$BOOLEAN_FALSE, posttime=posttime;
-- Add to website table: commentmod, blacklist, defaultallowcomments and defaultcommentdays
-
#addColumnNotNull("website" "commentmod" $BOOLEAN_SQL_TYPE $BOOLEAN_FALSE)
#addColumnNotNull("website" "defaultallowcomments" $BOOLEAN_SQL_TYPE $BOOLEAN_TRUE)
#addColumnNotNull("website" "defaultcommentdays" "integer" "7")
alter table website add column blacklist $TEXT_SQL_TYPE;
update website set commentmod=$BOOLEAN_FALSE, defaultallowcomments=$BOOLEAN_TRUE, defaultcommentdays=7, blacklist='', datecreated=datecreated;
-
-
-
+-- If you don't already have this, you need it:
+create index we_status_idx on weblogentry(status);