Author: gmazza
Date: Sat Jun 7 01:13:01 2014
New Revision: 1601049
URL: http://svn.apache.org/r1601049
Log:
Error in DB migration script fixed.
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=1601049&r1=1601048&r2=1601049&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 Sat Jun 7
01:13:01 2014
@@ -50,8 +50,9 @@ update folder set name = 'default' where
-- If a folder with name 'default' already exists, rename it by adding its id
to it.
update roller_mediafiledir set name = #concat("name" "id") where name =
'default';
update roller_mediafiledir set name = 'default' where name = 'root' and
parentid is null;
-#dropColumn("roller_mediafiledir", "path")
-#dropColumn("roller_mediafiledir", "parentid")
+#dropColumn("roller_mediafiledir" "path")
+#dropIndex("mf_parentid_fk" "roller_mediafiledir")
+#dropColumn("roller_mediafiledir" "parentid")
-- Adding blog-specific web analytics (e.g. Google Analytics) tracking code
#addColumnNull("website" "analyticscode" $db.TEXT_SQL_TYPE)
