[icinga-checkins] icinga.org: icinga-core/cmaser/fixes: update oracle-drop.sql

git at icinga.org git at icinga.org
Sat Jul 24 13:35:54 CEST 2010


Module: icinga-core
Branch: cmaser/fixes
Commit: 01bf708a865bf828627fd5c04c2d1439f1f1e710
URL:    https://git.icinga.org/?p=icinga-core.git;a=commit;h=01bf708a865bf828627fd5c04c2d1439f1f1e710

Author: Michael Friedrich <michael.friedrich at univie.ac.at>
Date:   Tue Jul 13 13:57:21 2010 +0200

update oracle-drop.sql

---

 module/idoutils/db/oracle/oracle-drop.sql |  178 +++++++++++++++++++----------
 1 files changed, 118 insertions(+), 60 deletions(-)

diff --git a/module/idoutils/db/oracle/oracle-drop.sql b/module/idoutils/db/oracle/oracle-drop.sql
index f008bec..ea9930d 100644
--- a/module/idoutils/db/oracle/oracle-drop.sql
+++ b/module/idoutils/db/oracle/oracle-drop.sql
@@ -1,62 +1,120 @@
-DROP TABLE instances;
-DROP TABLE conninfo;
-DROP TABLE objects;
-DROP TABLE logentries;
-DROP TABLE systemcommands;
-DROP TABLE eventhandlers;
-DROP TABLE servicechecks;
-DROP TABLE hostchecks;
-DROP TABLE programstatus;
-DROP TABLE externalcommands;
-DROP TABLE servicestatus;
-DROP TABLE hoststatus;
-DROP TABLE processevents;
-DROP TABLE timedevents;
-DROP TABLE timedeventqueue;
-DROP TABLE flappinghistory;
-DROP TABLE commenthistory;
-DROP TABLE comments;
-DROP TABLE notifications;
-DROP TABLE contactnotifications;
-DROP TABLE contactnotificationmethods;
-DROP TABLE acknowledgements;
-DROP TABLE statehistory;
-DROP TABLE downtimehistory;
-DROP TABLE scheduleddowntime;
-DROP TABLE configfiles;
-DROP TABLE configfilevariables;
-DROP TABLE runtimevariables;
-DROP TABLE contactstatus;
-DROP TABLE customvariablestatus;
-DROP TABLE commands;
-DROP TABLE timeperiods;
-DROP TABLE timeperiod_timeranges;
-DROP TABLE contactgroups;
-DROP TABLE contactgroup_members;
-DROP TABLE hostgroups;
-DROP TABLE hostgroup_members;
-DROP TABLE servicegroups;
-DROP TABLE servicegroup_members;
-DROP TABLE hostescalations;
-DROP TABLE hostescalation_contacts;
-DROP TABLE serviceescalations;
-DROP TABLE serviceescalation_contacts;
-DROP TABLE hostdependencies;
-DROP TABLE servicedependencies;
-DROP TABLE contacts;
-DROP TABLE contact_addresses;
-DROP TABLE contact_notificationcommands;
-DROP TABLE hosts;
-DROP TABLE host_parenthosts;
-DROP TABLE host_contacts;
-DROP TABLE services;
-DROP TABLE service_contacts;
-DROP TABLE customvariables;
-DROP TABLE host_contactgroups;
-DROP TABLE service_contactgroups;
-DROP TABLE hostescalation_contactgroups;
-DROP TABLE serviceescalationcontactgroups;
-DROP TABLE dbversion;
+DROP TABLE ACKNOWLEDGEMENTS CASCADE CONSTRAINTS;
+DROP TABLE COMMANDS CASCADE CONSTRAINTS;
+DROP TABLE COMMENTHISTORY CASCADE CONSTRAINTS;
+DROP TABLE COMMENTS CASCADE CONSTRAINTS;
+DROP TABLE CONFIGFILES CASCADE CONSTRAINTS;
+DROP TABLE CONFIGFILEVARIABLES CASCADE CONSTRAINTS;
+DROP TABLE CONNINFO CASCADE CONSTRAINTS;
+DROP TABLE CONTACT_ADDRESSES CASCADE CONSTRAINTS;
+DROP TABLE CONTACT_NOTIFICATIONCOMMANDS CASCADE CONSTRAINTS;
+DROP TABLE CONTACTGROUP_MEMBERS CASCADE CONSTRAINTS;
+DROP TABLE CONTACTGROUPS CASCADE CONSTRAINTS;
+DROP TABLE CONTACTNOTIFICATIONMETHODS CASCADE CONSTRAINTS;
+DROP TABLE CONTACTNOTIFICATIONS CASCADE CONSTRAINTS;
+DROP TABLE CONTACTS CASCADE CONSTRAINTS;
+DROP TABLE CONTACTSTATUS CASCADE CONSTRAINTS;
+DROP TABLE CUSTOMVARIABLES CASCADE CONSTRAINTS;
+DROP TABLE CUSTOMVARIABLESTATUS CASCADE CONSTRAINTS;
+DROP TABLE DBVERSION CASCADE CONSTRAINTS;
+DROP TABLE DOWNTIMEHISTORY CASCADE CONSTRAINTS;
+DROP TABLE EVENTHANDLERS CASCADE CONSTRAINTS;
+DROP TABLE EXTERNALCOMMANDS CASCADE CONSTRAINTS;
+DROP TABLE FLAPPINGHISTORY CASCADE CONSTRAINTS;
+DROP TABLE HOST_CONTACTGROUPS CASCADE CONSTRAINTS;
+DROP TABLE HOST_CONTACTS CASCADE CONSTRAINTS;
+DROP TABLE HOST_PARENTHOSTS CASCADE CONSTRAINTS;
+DROP TABLE HOSTCHECKS CASCADE CONSTRAINTS;
+DROP TABLE HOSTDEPENDENCIES CASCADE CONSTRAINTS;
+DROP TABLE HOSTESCALATION_CONTACTGROUPS CASCADE CONSTRAINTS;
+DROP TABLE HOSTESCALATION_CONTACTS CASCADE CONSTRAINTS;
+DROP TABLE HOSTESCALATIONS CASCADE CONSTRAINTS;
+DROP TABLE HOSTGROUP_MEMBERS CASCADE CONSTRAINTS;
+DROP TABLE HOSTGROUPS CASCADE CONSTRAINTS;
+DROP TABLE HOSTS CASCADE CONSTRAINTS;
+DROP TABLE HOSTSTATUS CASCADE CONSTRAINTS;
+DROP TABLE INSTANCES CASCADE CONSTRAINTS;
+DROP TABLE LOGENTRIES CASCADE CONSTRAINTS;
+DROP TABLE NOTIFICATIONS CASCADE CONSTRAINTS;
+DROP TABLE OBJECTS CASCADE CONSTRAINTS;
+DROP TABLE PROCESSEVENTS CASCADE CONSTRAINTS;
+DROP TABLE PROGRAMSTATUS CASCADE CONSTRAINTS;
+DROP TABLE RUNTIMEVARIABLES CASCADE CONSTRAINTS;
+DROP TABLE SCHEDULEDDOWNTIME CASCADE CONSTRAINTS;
+DROP TABLE SERVICE_CONTACTGROUPS CASCADE CONSTRAINTS;
+DROP TABLE SERVICE_CONTACTS CASCADE CONSTRAINTS;
+DROP TABLE SERVICECHECKS CASCADE CONSTRAINTS;
+DROP TABLE SERVICEDEPENDENCIES CASCADE CONSTRAINTS;
+DROP TABLE SERVICEESCALATIONCONTACTGROUPS CASCADE CONSTRAINTS;
+DROP TABLE SERVICEESCALATION_CONTACTS CASCADE CONSTRAINTS;
+DROP TABLE SERVICEESCALATIONS CASCADE CONSTRAINTS;
+DROP TABLE SERVICEGROUP_MEMBERS CASCADE CONSTRAINTS;
+DROP TABLE SERVICEGROUPS CASCADE CONSTRAINTS;
+DROP TABLE SERVICES CASCADE CONSTRAINTS;
+DROP TABLE SERVICESTATUS CASCADE CONSTRAINTS;
+DROP TABLE STATEHISTORY CASCADE CONSTRAINTS;
+DROP TABLE SYSTEMCOMMANDS CASCADE CONSTRAINTS;
+DROP TABLE TIMEDEVENTQUEUE CASCADE CONSTRAINTS;
+DROP TABLE TIMEDEVENTS CASCADE CONSTRAINTS;
+DROP TABLE TIMEPERIOD_TIMERANGES CASCADE CONSTRAINTS;
+DROP TABLE TIMEPERIODS CASCADE CONSTRAINTS;
 
-DROP SEQUENCE autoincrement;
+
+DROP SEQUENCE SEQ_ACKNOWLEDGEMENTS;
+DROP SEQUENCE SEQ_COMMANDS;
+DROP SEQUENCE SEQ_COMMENTHISTORY;
+DROP SEQUENCE SEQ_COMMENTS;
+DROP SEQUENCE SEQ_CONFIGFILES;
+DROP SEQUENCE SEQ_CONFIGFILEVARIABLES;
+DROP SEQUENCE SEQ_CONNINFO;
+DROP SEQUENCE SEQ_CONTACTGROUPS;
+DROP SEQUENCE SEQ_CONTACTGROUP_MEMBERS;
+DROP SEQUENCE SEQ_CONTACTNOTIFICATIONS;
+DROP SEQUENCE SEQ_CONTACTNOTIFMETHODS;
+DROP SEQUENCE SEQ_CONTACTS;
+DROP SEQUENCE SEQ_CONTACTSTATUS;
+DROP SEQUENCE SEQ_CONTACT_ADDRESSES;
+DROP SEQUENCE SEQ_CONTACT_NOTIFCOMMANDS;
+DROP SEQUENCE SEQ_CUSTOMVARIABLES;
+DROP SEQUENCE SEQ_CUSTOMVARIABLESTATUS;
+DROP SEQUENCE SEQ_DOWNTIMEHISTORY;
+DROP SEQUENCE SEQ_EVENTHANDLERS;
+DROP SEQUENCE SEQ_EXTERNALCOMMANDS;
+DROP SEQUENCE SEQ_FLAPPINGHISTORY;
+DROP SEQUENCE SEQ_HOSTCHECKS;
+DROP SEQUENCE SEQ_HOSTDEPENDENCIES;
+DROP SEQUENCE SEQ_HOSTESCALATIONS;
+DROP SEQUENCE SEQ_HOSTESC_CONTACTGROUPS;
+DROP SEQUENCE SEQ_HOSTESC_CONTACTS;
+DROP SEQUENCE SEQ_HOSTGROUPS;
+DROP SEQUENCE SEQ_HOSTGROUP_MEMBERS;
+DROP SEQUENCE SEQ_HOSTS;
+DROP SEQUENCE SEQ_HOSTSTATUS;
+DROP SEQUENCE SEQ_HOST_CONTACTGROUPS;
+DROP SEQUENCE SEQ_HOST_CONTACTS;
+DROP SEQUENCE SEQ_HOST_PARENTHOSTS;
+DROP SEQUENCE SEQ_INSTANCES;
+DROP SEQUENCE SEQ_LOGENTRIES;
+DROP SEQUENCE SEQ_NOTIFICATIONS;
+DROP SEQUENCE SEQ_OBJECTS;
+DROP SEQUENCE SEQ_PROCESSEVENTS;
+DROP SEQUENCE SEQ_PROGRAMSTATUS;
+DROP SEQUENCE SEQ_RUNTIMEVARIABLES;
+DROP SEQUENCE SEQ_SCHEDULEDDOWNTIME;
+DROP SEQUENCE SEQ_SERVICECHECKS;
+DROP SEQUENCE SEQ_SERVICEDEPENDENCIES;
+DROP SEQUENCE SEQ_SERVICEESCALATIONS;
+DROP SEQUENCE SEQ_SERVICEESCCONTACTGROUPS;
+DROP SEQUENCE SEQ_SERVICEESC_CONTACTS;
+DROP SEQUENCE SEQ_SERVICEGROUPS;
+DROP SEQUENCE SEQ_SERVICEGROUP_MEMBERS;
+DROP SEQUENCE SEQ_SERVICES;
+DROP SEQUENCE SEQ_SERVICESTATUS;
+DROP SEQUENCE SEQ_SERVICE_CONTACTGROUPS;
+DROP SEQUENCE SEQ_SERVICE_CONTACTS;
+DROP SEQUENCE SEQ_STATEHISTORY;
+DROP SEQUENCE SEQ_SYSTEMCOMMANDS;
+DROP SEQUENCE SEQ_TIMEDEVENTQUEUE;
+DROP SEQUENCE SEQ_TIMEDEVENTS;
+DROP SEQUENCE SEQ_TIMEPERIODS;
+DROP SEQUENCE SEQ_TIMEP_TIMER;
 





More information about the icinga-checkins mailing list