/**************************************************************/
/**************************************************************/ -- Trigger
/**************************************************************/

DROP TRIGGER TTBPCM_CHAMADO_CAT_B01D;
DROP TRIGGER TTBPCM_CHAMADO_CAT_B01I;
DROP TRIGGER TTBPCM_CHAMADO_CAT_B01U;
DROP TRIGGER TTBPCM_CHAMADO_CAT_B02D;
DROP TRIGGER TTBPCM_CHAMADO_CAT_B02I;

DROP TRIGGER TTBPCM_CHAMADO_SUBCAT_B01D;
DROP TRIGGER TTBPCM_CHAMADO_SUBCAT_B01I;
DROP TRIGGER TTBPCM_CHAMADO_SUBCAT_B01U;
DROP TRIGGER TTBPCM_CHAMADO_SUBCAT_B02I;

DROP TRIGGER TTBPCM_CHAMADO_TIPO_B01D;
DROP TRIGGER TTBPCM_CHAMADO_TIPO_B01I;
DROP TRIGGER TTBPCM_CHAMADO_TIPO_B01U;
DROP TRIGGER TTBPCM_CHAMADO_TIPO_B02D;
DROP TRIGGER TTBPCM_CHAMADO_TIPO_B02I;

DROP TRIGGER TTBPCM_REGISTRO_CHA_AVAL_B01D;
DROP TRIGGER TTBPCM_REGISTRO_CHA_AVAL_B01I;
DROP TRIGGER TTBPCM_REGISTRO_CHA_AVAL_B01U;
DROP TRIGGER TTBPCM_REGISTRO_CHA_AVAL_B02I;
DROP TRIGGER TTBPCM_REGISTRO_CHA_AVAL_B02U;

DROP TRIGGER TTBPCM_REGISTRO_CHA_ITEM_B01D;
DROP TRIGGER TTBPCM_REGISTRO_CHA_ITEM_B01I;
DROP TRIGGER TTBPCM_REGISTRO_CHA_ITEM_B01U;
DROP TRIGGER TTBPCM_REGISTRO_CHA_ITEM_B02I;
DROP TRIGGER TTBPCM_REGISTRO_CHA_ITEM_B02U;

DROP TRIGGER TTBPCM_REGISTRO_CHA_MSG_B01D;
DROP TRIGGER TTBPCM_REGISTRO_CHA_MSG_B01I;
DROP TRIGGER TTBPCM_REGISTRO_CHA_MSG_B01U;
DROP TRIGGER TTBPCM_REGISTRO_CHA_MSG_B02I;
DROP TRIGGER TTBPCM_REGISTRO_CHA_MSG_B02U;

DROP TRIGGER TTBPCM_REGISTRO_CHAMADO_B01D;
DROP TRIGGER TTBPCM_REGISTRO_CHAMADO_B01I;
DROP TRIGGER TTBPCM_REGISTRO_CHAMADO_B01U;
DROP TRIGGER TTBPCM_REGISTRO_CHAMADO_B02D;
DROP TRIGGER TTBPCM_REGISTRO_CHAMADO_B02I;
DROP TRIGGER TTBPCM_REGISTRO_CHAMADO_B02U;
DROP TRIGGER TTBPCM_REGISTRO_CHAMADO_B03U;

DROP TRIGGER TTBPCM_SETOR_B01D;
DROP TRIGGER TTBPCM_SETOR_B01I;
DROP TRIGGER TTBPCM_SETOR_B01U;
DROP TRIGGER TTBPCM_SETOR_B02D;
DROP TRIGGER TTBPCM_SETOR_B02I;

DROP TRIGGER TTBPCM_SETOR_OPERADOR_B01D;
DROP TRIGGER TTBPCM_SETOR_OPERADOR_B01I;
DROP TRIGGER TTBPCM_SETOR_OPERADOR_B01U;
DROP TRIGGER TTBPCM_SETOR_OPERADOR_B02I;

/**************************************************************/
/**************************************************************/ -- Generetor
/**************************************************************/

DROP SEQUENCE GTBPCM_CHAMADO_CATEGORIA;
DROP SEQUENCE GTBPCM_CHAMADO_SUBCATEGORIA;
DROP SEQUENCE GTBPCM_CHAMADO_TIPO;
DROP SEQUENCE GTBPCM_REGISTRO_CHAMADO;
DROP SEQUENCE GTBPCM_REGISTRO_CHAMADO_AVAL;
DROP SEQUENCE GTBPCM_REGISTRO_CHAMADO_ITEM;
DROP SEQUENCE GTBPCM_REGISTRO_CHAMADO_MSG;
DROP SEQUENCE GTBPCM_SETOR;
DROP SEQUENCE GTBPCM_SETOR_OPERADOR;

/**************************************************************/
/**************************************************************/ -- Table
/**************************************************************/

DROP TABLE TBPCM_CHAMADO_CATEGORIA;
DROP TABLE TBPCM_CHAMADO_SUBCATEGORIA;
DROP TABLE TBPCM_CHAMADO_TIPO;
DROP TABLE TBPCM_REGISTRO_CHAMADO;
DROP TABLE TBPCM_REGISTRO_CHAMADO_AVAL;
DROP TABLE TBPCM_REGISTRO_CHAMADO_ITEM;
DROP TABLE TBPCM_REGISTRO_CHAMADO_MSG;
DROP TABLE TBPCM_SETOR;
DROP TABLE TBPCM_SETOR_OPERADOR;