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 2007/09/13 20:47:31 UTC
svn commit: r575399 -
/roller/trunk/apps/weblogger/src/sql/310-to-400-migration.vm
Author: snoopdave
Date: Thu Sep 13 11:47:31 2007
New Revision: 575399
URL: http://svn.apache.org/viewvc?rev=575399&view=rev
Log:
More fixes for http://opensource.atlassian.com/projects/roller/browse/ROL-1548
Modified:
roller/trunk/apps/weblogger/src/sql/310-to-400-migration.vm
Modified: roller/trunk/apps/weblogger/src/sql/310-to-400-migration.vm
URL: http://svn.apache.org/viewvc/roller/trunk/apps/weblogger/src/sql/310-to-400-migration.vm?rev=575399&r1=575398&r2=575399&view=diff
==============================================================================
--- roller/trunk/apps/weblogger/src/sql/310-to-400-migration.vm (original)
+++ roller/trunk/apps/weblogger/src/sql/310-to-400-migration.vm Thu Sep 13 11:47:31 2007
@@ -137,10 +137,7 @@
-- remove old indexes that are no longer of value
-#dropIndex('index_we_pubtime_idx' 'weblogentry')
#dropIndex('we_pubentry_idx' 'weblogentry')
--- #dropIndex('co_pending_idx' 'roller_comment')
--- #dropIndex('co_approved_idx' 'roller_comment')
-- fix wacky indexs which ended up with a size constraint
@@ -155,10 +152,6 @@
-- remove no-longer-used needed tables
-#dropTableIfExists('usercookie')
-#dropTableIfExists('rag_config')
-#dropTableIfExists('folderassoc')
-#dropTableIfExists('weblogcategoryassoc')
-- remove old rollerconfig table which has been deprecated since 1.2
-- NOTE: since this breaks the pre-1.2 -> 4.0+ direct upgrade path then
@@ -173,9 +166,16 @@
#dropColumn('roller_comment' 'spam')
#dropColumn('roller_comment' 'pending')
--- remove bastard columns from various tables (optional)
+-- remove bastard columns and indexes (optional)
+-- #dropIndex('index_we_pubtime_idx' 'weblogentry')
+-- #dropIndex('co_pending_idx' 'roller_comment')
+-- #dropIndex('co_approved_idx' 'roller_comment')
-- #dropColumn('website' 'userid')
-- #dropColumn('website' 'weblogdayid')
-- #dropColumn('weblogentry' 'publishentry')
-- #dropColumn('weblogentry' 'link')
+-- #dropTableIfExists('usercookie')
+-- #dropTableIfExists('rag_config')
+-- #dropTableIfExists('folderassoc')
+-- #dropTableIfExists('weblogcategoryassoc')