/************************************************************************
 * Name     :drop_db_objects.sql					*
 * Issue    :03-09-2003 - H. Korte - Intevation - Osnabrueck		*	
 * Purpose  :delete seq.'s, func.'s, triggers and tables from spec. db	*
 * Parameter:								*
 * Changes  :								*
 * [ Date   ] - [ Name ] - [ Action ]					*
 ************************************************************************/

 DROP SEQUENCE GROUP_SEQ;
 DROP SEQUENCE PHRASE_SEQ;
 DROP SEQUENCE BIN_OBJ_SEQ;
 DROP SEQUENCE SUBST_SEQ;
 DROP SEQUENCE SUBST_DET_SEQ;
 DROP SEQUENCE ENV_SEQ;
 DROP SEQUENCE ENV_DET_SEQ;
 DROP SEQUENCE MARKET_SEQ;
 DROP SEQUENCE MOD_SEQ;
 DROP SEQUENCE MOD_DET_SEQ;
 DROP SEQUENCE RES_SEQ;
 DROP SEQUENCE RES_STRETCH_SEQ;
 DROP SEQUENCE RES_DISCH_SEQ;
 DROP SEQUENCE SESS_SEQ;
 DROP SEQUENCE SESS_DISCH_SEQ;
 DROP SEQUENCE CATCH_SEQ;

 DROP FUNCTION BIN_OBJ_PROCF();
 DROP FUNCTION CATCH_PROCF();
 DROP FUNCTION RES_PROCF();
 DROP FUNCTION dbms_init_seq();
 DROP FUNCTION instr(VARCHAR,VARCHAR); 
 DROP FUNCTION instr(VARCHAR,VARCHAR,INTEGER);
 DROP FUNCTION instr(VARCHAR,VARCHAR,INTEGER,INTEGER);
 DROP FUNCTION pg_decode(NUMERIC,NUMERIC,NUMERIC,NUMERIC);
 DROP FUNCTION replace(VARCHAR, VARCHAR, VARCHAR);
 
 DROP TRIGGER BIN_OBJ_TRG ON BIN_OBJ_TAB;
 DROP TRIGGER CATCH_TRG ON CATCH_TAB;
 DROP TRIGGER RES_TRG ON RES_TAB;

 DROP TABLE BIN_OBJ_SEARCH_TAB; 
 DROP TABLE BIN_OBJ_TAB;
 DROP TABLE GROUP_TAB;
 DROP TABLE MESSAGE_TAB;
 DROP TABLE PHRASE_TAB;
 DROP TABLE PARA_TREE_DEF_TAB;
 DROP TABLE USER_TAB;
 DROP TABLE CATCH_TAB;
 DROP TABLE BACKGRD_JOIN_TAB;
 DROP TABLE DISCH_CLASS_TAB;
 DROP TABLE STRETCH_CLASS_TAB;
 DROP TABLE SUBST_TAB;
 DROP TABLE SUBST_DET_TAB;
 DROP TABLE ENV_TAB;
 DROP TABLE ENV_DET_TAB;
 DROP TABLE STRETCH_TAB;
 DROP TABLE DISCH_TAB;
 DROP TABLE MARKET_TAB;
 DROP TABLE MOD_TAB;
 DROP TABLE MOD_DET_TAB;
 DROP TABLE RES_TAB;
 DROP TABLE RES_DISCH_TAB;
 DROP TABLE RES_STRETCH_TAB;
 DROP TABLE SESS_TAB;
 DROP TABLE SESS_DISCH_TAB;
 
