roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From agillil...@apache.org
Subject svn commit: r501137 - /incubator/roller/trunk/metadata/database/droptables.sql
Date Mon, 29 Jan 2007 18:23:14 GMT
Author: agilliland
Date: Mon Jan 29 10:23:13 2007
New Revision: 501137

URL: http://svn.apache.org/viewvc?view=rev&rev=501137
Log:
reorganize droptables sequence to make sure we don't run into conflicts with foreign key violations
when dropping tables.


Modified:
    incubator/roller/trunk/metadata/database/droptables.sql

Modified: incubator/roller/trunk/metadata/database/droptables.sql
URL: http://svn.apache.org/viewvc/incubator/roller/trunk/metadata/database/droptables.sql?view=diff&rev=501137&r1=501136&r2=501137
==============================================================================
--- incubator/roller/trunk/metadata/database/droptables.sql (original)
+++ incubator/roller/trunk/metadata/database/droptables.sql Mon Jan 29 10:23:13 2007
@@ -14,35 +14,44 @@
 -- copyright in this work, please see the NOTICE file in the top level
 -- directory of this distribution.
 
+-- planet tables
+drop table rag_config;
+drop table rag_group;
+drop table rag_subscription;
+drop table rag_entry;
+drop table rag_group_subscription;
+
+-- non-associated tables
+drop table newsfeed;
+drop table usercookie;
+drop table rollerconfig;
+drop table roller_properties;
+drop table roller_audit_log;
+drop table roller_tasklock;
+
+-- supplemental services tables
 drop table pingqueueentry;
 drop table pingcategory;
 drop table autoping;
 drop table pingtarget;
 drop table referer;
-drop table newsfeed;
-drop table weblogcategoryassoc;
 drop table bookmark;
+drop table folder;
+drop table folderassoc;
+
+-- core services tables
+drop table roller_hitcounts;
 drop table roller_comment;
-drop table entryattribute;
-drop table weblogentry;
 drop table roller_weblogentrytag;
 drop table roller_weblogentrytagagg;
+drop table entryattribute;
+drop table weblogentry;
+drop table weblogcategoryassoc;
 drop table weblogcategory;
-drop table folder;
-drop table folderassoc;
 drop table webpage;
+
+-- core platform tables
+drop table roller_user_permissions;
 drop table website;
 drop table userrole;
-drop table rollerconfig;
-drop table rolleruser; 
-drop table usercookie; 
-drop table rag_config;
-drop table rag_group;
-drop table rag_subscription;
-drop table rag_entry;
-drop table rag_group_subscription;
-drop table roller_properties;
-drop table roller_audit_log;
-drop table roller_user_permissions;
-drop table roller_tasklock;
-drop table roller_hitcounts;
+drop table rolleruser;



Mime
View raw message