Author: snoopdave
Date: Sun Jul 20 19:24:58 2014
New Revision: 1612158
URL: http://svn.apache.org/r1612158
Log:
Commented out several instances of drop-index that were dropping indexes that
do not exist in all Roller databases and cause the migration script to fail.
There does not seem to be a "drop index if exists" capability in MySQL.
Also added and commented out an additional drop-index call for a column that
does exist in some Roller databases and will cause the bookmark folder
migration to fail.
Modified:
roller/trunk/app/src/main/resources/sql/500-to-510-migration.vm
Modified: roller/trunk/app/src/main/resources/sql/500-to-510-migration.vm
URL:
http://svn.apache.org/viewvc/roller/trunk/app/src/main/resources/sql/500-to-510-migration.vm?rev=1612158&r1=1612157&r2=1612158&view=diff
==============================================================================
--- roller/trunk/app/src/main/resources/sql/500-to-510-migration.vm (original)
+++ roller/trunk/app/src/main/resources/sql/500-to-510-migration.vm Sun Jul 20
19:24:58 2014
@@ -36,9 +36,13 @@ delete from weblogcategory where name =
-- Removal of custom ping targets
delete from pingtarget where websiteid is not null;
-#dropIndex("pingtarget" "pt_websiteid_fk")
+(this index does not exist on all Roller databases)
+-- #dropIndex("pingtarget" "pt_websiteid_fk")
#dropColumn("pingtarget" "websiteid")
+-- NOTE: you might need to drop this index on some Roller databases
+-- drop index folder_namefolderid_uq on folder;
+
-- Removal of bookmark subfolders and renaming of former root folder to
'default'
-- If a folder with name 'default' already exists, rename it by adding its id
to it.
update folder set name = #concat("name" "id") where name = 'default';
@@ -61,5 +65,6 @@ update roller_mediafiledir set name = 'd
-- Referer table no longer populated, retaining for older DB's in case legacy
data
-- is desired to keep; but removing its FK relationships to other tables
-#dropIndex("referer" "ref_entryid_fk")
-#dropIndex("referer" "ref_websiteid_fk")
+-- (these indexes do not exist on all Roller databases for some reason)
+-- #dropIndex("referer" "ref_entryid_fk")
+-- #dropIndex("referer" "ref_websiteid_fk")
