blob: b76698bd240020947cb4d7e84cbeac50913b00b8 [file] [log] [blame]
ALTER TABLE DTO_TEST_PARENT DROP CONSTRAINT DTTSTBNXCRSSRFCHLD
ALTER TABLE DTO_TEST_PARENT DROP CONSTRAINT DTTSTPRCRSSRFCHLDD
ALTER TABLE DTO_TEST_CHILD_CONTAINMENT DROP CONSTRAINT DTTSTCHLDCNTCNTNRD
ALTER TABLE DTO_TEST_CHILD_CROSS_REF DROP CONSTRAINT DTTSTCHLDCRSCNTNRD
ALTER TABLE CASH_SLIP DROP CONSTRAINT CASHSLIPREGISTERID
ALTER TABLE CASH_SLIP DROP CONSTRAINT CASHSLIPCUSTOMERID
ALTER TABLE CASH_POSITION DROP CONSTRAINT CASHPOSITIONSLIPID
ALTER TABLE CASH_SUB_POSITION DROP CONSTRAINT CSHSBPOSITIONPRNTD
ALTER TABLE CASH_PAYMENT DROP CONSTRAINT CASHPAYMENTCLOSEID
ALTER TABLE CASH_PAYMENT DROP CONSTRAINT CSHPYMNMTHDFPYMNTD
ALTER TABLE CASH_PAYMENT DROP CONSTRAINT CASHPAYMENTSLIP_ID
ALTER TABLE CASH_DRAWER_SUM DROP CONSTRAINT CSHDRAWERSUMDRWRID
ALTER TABLE COMPANY_GROUP DROP CONSTRAINT CMPNYGRUPMNCMPNYID
ALTER TABLE COMPANY DROP CONSTRAINT CMPNYCMPANYGROUPID
ALTER TABLE COMPANY DROP CONSTRAINT CMPANYRLTIONTYPEID
ALTER TABLE ADDRESS DROP CONSTRAINT ADDRESS_COMPANY_ID
ALTER TABLE ADDRESS DROP CONSTRAINT DDRESSDEPARTMENTID
ALTER TABLE DEPARTMENT DROP CONSTRAINT DPARTMENTCOMPANYID
ALTER TABLE CAR DROP CONSTRAINT FK_CAR_OWNER_ID
ALTER TABLE ADDON DROP CONSTRAINT FK_ADDON_CAR_ID
ALTER TABLE TO_CYCLE1 DROP CONSTRAINT TO_CYCLE1_CAR_ID
ALTER TABLE TO_CYCLE2 DROP CONSTRAINT TO_CYCLE2PARENT_ID
ALTER TABLE TO_CYCLE2 DROP CONSTRAINT TO_CYCLE2_CAR_ID
DROP TABLE DTO_TEST_PARENT
DROP TABLE DTO_TEST_CHILD_CONTAINMENT
DROP TABLE DTO_TEST_CHILD_CROSS_REF
DROP TABLE MCUSTOMER
DROP INDEX CASH_IP_INDEX
DROP INDEX CASH_NUM_INDEX
DROP TABLE CASH_REGISTER
DROP INDEX CURRENT_DAY_INDEX
DROP INDEX SERIAL_INDEX
DROP TABLE CASH_SLIP
DROP TABLE CASH_POSITION
DROP TABLE CASH_SUB_POSITION
DROP TABLE CASH_PAYMENT
DROP INDEX PAYMENT_NUM_INDEX
DROP TABLE CASH_PAYMENT_METHOD
DROP TABLE CASH_DRAWER_CURRENCY
DROP TABLE CASH_DRAWER_SUM
DROP TABLE COMPANY_RELATION_TYPE
DROP TABLE COMPANY_GROUP
DROP TABLE COMPANY
DROP TABLE ADDRESS
DROP TABLE DEPARTMENT
DROP TABLE CAR
DROP TABLE ADDON
DROP TABLE TO_CYCLE1
DROP TABLE TO_CYCLE2
DROP TABLE PERSON
DELETE FROM SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN'