
-- =======================================================================
--   system database                                                      
-- =======================================================================
DROP TABLE if exists CFG_PROPS_2;
DROP TABLE if exists GLOBAL_NLS_FONT_1;
DROP TABLE if exists GLOBAL_NLS_FORMAT_1;
DROP TABLE if exists GLOBAL_NLS_TEXT_1;
DROP TABLE if exists MEMBERS;
DROP TABLE if exists RESOURCE_LOCK;
DROP TABLE if exists TBL_DUAL_JINFONET;
DROP TABLE if exists TBL_IDGENRATOR_JINFONET;
DROP TABLE if exists TBL_LOCK_JINFONET;
DROP TABLE if exists UPDATEDETAILS_1;

-- =======================================================================
--   profile database                                                     
-- =======================================================================
DROP TABLE if exists RESOURCE_LOCK;
DROP TABLE if exists TASKAUDIT;
DROP TABLE if exists TASKCONTEXT_2;
DROP TABLE if exists TBL_DUAL_JINFONET;
DROP TABLE if exists TBL_IDGENRATOR_JINFONET;
DROP TABLE if exists TBL_LOCK_JINFONET;
DROP TABLE if exists UPDATEDETAILS_1;

-- =======================================================================
--   realm database                                                       
-- =======================================================================
DROP TABLE if exists ACLENTRIES_3;
DROP TABLE if exists ACLS_2;
DROP TABLE if exists ACLS_WITH_RESOURCE_1;
DROP TABLE if exists ALIASES_2;
DROP TABLE if exists ALIAS_MAPPING;
DROP TABLE if exists ALIAS_MAPPING_KEY;
DROP TABLE if exists CATALOGVERSION_4;
DROP TABLE if exists CFG_PROPS_2;
DROP TABLE if exists COMPLETEDPUBLISHTABLE_2;
DROP TABLE if exists COMPLETEDRESULTTABLE_3;
DROP TABLE if exists COMPLETEDTABLE_4;
DROP TABLE if exists JR_QRTZ_TRIGGER_LISTENERS;
DROP TABLE if exists JR_QRTZ_SIMPLE_TRIGGERS;
DROP TABLE if exists JR_QRTZ_JOB_LISTENERS;
DROP TABLE if exists JR_QRTZ_CRON_TRIGGERS;
DROP TABLE if exists JR_QRTZ_BLOB_TRIGGERS;
DROP TABLE if exists JR_QRTZ_TRIGGERS;
DROP TABLE if exists JR_QRTZ_JOB_DETAILS;
DROP TABLE if exists DYN_BVELE_NAME_MAPPING_1;
DROP TABLE if exists DYN_BVELE_NAME_1;
DROP TABLE if exists DYNAMIC_CONNECTIONS_MAPPING_2;
DROP TABLE if exists DYNAMIC_CONNECTIONS_2;
DROP TABLE if exists DASHBOARDLISTENERTARGET_1;
DROP TABLE if exists DASHBOARDLISTENER_1;
DROP TABLE if exists CRD_CONN_INFO_1;
DROP TABLE if exists CRDRUNDETAIL_1;
DROP TABLE if exists CRD_INFO_5;
DROP TABLE if exists COMP_CRD_CONN_INFO_1;
DROP TABLE if exists COMPLETED_CRD_INFO_3;
DROP TABLE if exists CUSTOM_FIELD_1;
DROP TABLE if exists CUSTOM_FIELD_VALUE_1;
DROP TABLE if exists DRESULT_3;
DROP TABLE if exists DYNAMICNODE_5;
DROP TABLE if exists DYNAMICRESULT_2;
DROP TABLE if exists DYN_SECURITY_1;
DROP TABLE if exists EXTENDACLENTRIES_3;
DROP TABLE if exists FOLDERS_4;
DROP TABLE if exists GROUPPROFILES_2;
DROP TABLE if exists GROUPS_3;
DROP TABLE if exists GUPROFILES_3;
DROP TABLE if exists HISTORY_PARAMLIST_TABLE_1;
DROP TABLE if exists JR_QRTZ_CALENDARS;
DROP TABLE if exists JR_QRTZ_FIRED_TRIGGERS;
DROP TABLE if exists JR_QRTZ_LOCKS;
DROP TABLE if exists JR_QRTZ_PAUSED_TRIGGER_GRPS;
DROP TABLE if exists JR_QRTZ_SCHEDULER_STATE;
DROP TABLE if exists LCVERSION_2;
DROP TABLE if exists NODES_6;
DROP TABLE if exists ORGANIZATIONS_1;
DROP TABLE if exists REPORTVERSION_4;
DROP TABLE if exists RESOURCEMAP_2;
DROP TABLE if exists RESOURCENLS_1;
DROP TABLE if exists RESOURCENODES_5;
DROP TABLE if exists RESOURCE_LOCK;
DROP TABLE if exists RESULTVERSION_3;
DROP TABLE if exists RESULT_3;
DROP TABLE if exists RGPROFILES_2;
DROP TABLE if exists ROLEPROFILES_3;
DROP TABLE if exists ROLES_4;
DROP TABLE if exists SCHDLASTEXETIME_1;
DROP TABLE if exists STORAGE_MEMBER_1;
DROP TABLE if exists STORAGE_RESOURCE_1;
DROP TABLE if exists TBL_DUAL_JINFONET;
DROP TABLE if exists TBL_IDGENRATOR_JINFONET;
DROP TABLE if exists TBL_LOCK_JINFONET;
DROP TABLE if exists TRIGGERS_1;
DROP TABLE if exists UPDATEDETAILS_1;
DROP TABLE if exists USERPROFILES_4;
DROP TABLE if exists USERS_4;
DROP TABLE if exists VERSIONNODES_3;
