svn commit: r227478 - /portals/jetspeed-2/branches/JS2-319/etc/sql/drop.sql

[at...@apache.org]

Author: ate
Date: Thu Aug  4 13:46:01 2005
New Revision: 227478

URL: http://svn.apache.org/viewcvs?rev=227478&view=rev
Log:
portal tables are now always dropped before a new schema is created
using one central drop.sql script with setting "continue" on execute errors.
Note: for database without generated "drop table if exists" logic (Oracle, PostgreSQL)
the drop statements will be removed automatically now after generation.
The drop drops goals will not be needed anymore this way. 

Added:
    portals/jetspeed-2/branches/JS2-319/etc/sql/drop.sql

Added: portals/jetspeed-2/branches/JS2-319/etc/sql/drop.sql
URL: http://svn.apache.org/viewcvs/portals/jetspeed-2/branches/JS2-319/etc/sql/drop.sql?rev=227478&view=auto
==============================================================================
--- portals/jetspeed-2/branches/JS2-319/etc/sql/drop.sql (added)
+++ portals/jetspeed-2/branches/JS2-319/etc/sql/drop.sql Thu Aug  4 13:46:01 2005
@@ -0,0 +1,64 @@
+drop table A;
+drop table B;
+drop table CLUBS;
+drop table OJB_HL_SEQ;
+drop table OJB_LOCKENTRY;
+drop table OJB_NRM;
+drop table OJB_DLIST;
+drop table OJB_DLIST_ENTRIES;
+drop table OJB_DSET;
+drop table OJB_DSET_ENTRIES;
+drop table OJB_DMAP;
+DROP TABLE CAPABILITY;
+DROP TABLE MIMETYPE;
+DROP TABLE CLIENT;
+DROP TABLE MEDIA_TYPE;
+DROP TABLE CLIENT_TO_CAPABILITY;
+DROP TABLE CLIENT_TO_MIMETYPE;
+DROP TABLE MEDIATYPE_TO_CAPABILITY;
+DROP TABLE MEDIATYPE_TO_MIMETYPE;
+DROP TABLE SUB_PAGES;
+DROP TABLE PAGE;
+DROP TABLE FRAGMENT;
+DROP TABLE PAGE_FRAGMENTS;
+DROP TABLE SUB_FRAGMENTS;
+DROP TABLE FRAGMENT_PARAMETER;
+DROP TABLE FRAGMENT_REF;
+DROP TABLE FRAGMENT_REFS;
+DROP TABLE RULE_CRITERION;
+DROP TABLE PRINCIPAL_RULE_ASSOC;
+DROP TABLE PROFILE_PAGE_ASSOC;
+DROP TABLE PROFILING_RULE;
+drop table PREFS_PROPERTY_VALUE;
+drop table PREFS_NODE_PROPERTY_KEY;
+drop table PREFS_PROPERTY_KEY;
+drop table PREFS_NODE;
+DROP TABLE PA_METADATA_FIELDS;
+DROP TABLE PD_METADATA_FIELDS;
+DROP TABLE LANGUAGE; 
+DROP TABLE PORTLET_CONTENT_TYPE; 
+DROP TABLE PARAMETER; 
+DROP TABLE PREFERENCE_VALUE; 
+DROP TABLE PORTLET_PREFERENCE; 
+DROP TABLE PORTLET_ENTITY; 
+DROP TABLE SECURITY_ROLE_REFERENCE;
+DROP TABLE SECURITY_ROLE;
+DROP TABLE USER_ATTRIBUTE_REF;
+DROP TABLE USER_ATTRIBUTE;
+DROP TABLE JETSPEED_SERVICE;
+DROP TABLE LOCALIZED_DESCRIPTION; 
+DROP TABLE LOCALIZED_DISPLAY_NAME; 
+DROP TABLE WEB_APPLICATION; 
+DROP TABLE PORTLET_DEFINITION; 
+DROP TABLE PORTLET_APPLICATION; 
+drop table PRINCIPAL_PERMISSION;
+DROP TABLE SECURITY_CREDENTIAL;
+drop table SSO_SITE_TO_PRINCIPALS;
+drop table SSO_PRINCIPAL_TO_REMOTE;
+drop table SSO_SITE_TO_REMOTE;
+DROP TABLE SECURITY_USER_ROLE;
+DROP TABLE SECURITY_USER_GROUP;
+DROP TABLE SECURITY_GROUP_ROLE;
+drop table SSO_SITE;
+drop table SECURITY_PERMISSION;
+drop table SECURITY_PRINCIPAL;



---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org