You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by ag...@apache.org on 2006/12/06 20:44:00 UTC
svn commit: r483197 -
/incubator/roller/trunk/metadata/database/3xx-to-400-migration.vm
Author: agilliland
Date: Wed Dec 6 11:43:59 2006
New Revision: 483197
URL: http://svn.apache.org/viewvc?view=rev&rev=483197
Log:
just making note of various other db cleanup items for the 4.0 release.
Modified:
incubator/roller/trunk/metadata/database/3xx-to-400-migration.vm
Modified: incubator/roller/trunk/metadata/database/3xx-to-400-migration.vm
URL: http://svn.apache.org/viewvc/incubator/roller/trunk/metadata/database/3xx-to-400-migration.vm?view=diff&rev=483197&r1=483196&r2=483197
==============================================================================
--- incubator/roller/trunk/metadata/database/3xx-to-400-migration.vm (original)
+++ incubator/roller/trunk/metadata/database/3xx-to-400-migration.vm Wed Dec 6 11:43:59 2006
@@ -4,5 +4,24 @@
DON'T RUN THIS, IT'S NOT A DATABASE CREATION SCRIPT!!!
**#
-## remove old id column of group subscription table
-alter table rag_group_subscription drop column id;
\ No newline at end of file
+-- remove old id column of group subscription table
+alter table rag_group_subscription drop column id;
+
+-- remove old usercookie table which has been unused since 0.x?
+drop table if exists usercookie;
+
+-- remove old assoc tables which were EOLed in 3.2
+drop table if exists folderassoc;
+drop table if exists 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
+-- maybe we want to attempt to fix that by doing that upgrade via sql?
+drop table if exists rollerconfig;
+
+-- remove bastard columns from various tables
+-- NOTE: these are only here as options, we don't *have* to do them
+--alter table website drop column userid;
+--alter table website drop column weblogdayid;
+--alter table weblogentry drop column publishentry;
+--alter table weblogentry drop column link;
\ No newline at end of file