blob: bbeac67e3193311677d1ae6cbd693b920b28e7f6 [file] [log] [blame]
ALTER TABLE JPA22_XML_FORK_COSTS DROP FOREIGN KEY FK_JPA22_XML_FORK_COSTS_ID
ALTER TABLE JPA22_XML_DDL_ORGANIZER DROP FOREIGN KEY XMLOrganizer_Race_Foreign_Key
ALTER TABLE JPA22_XML_DDL_SHOE DROP FOREIGN KEY XMLRunner_ShoeTag_Foreign_Key
ALTER TABLE JPA22_XML_DDL_SHOE DROP FOREIGN KEY XMLShoes_Runner_Foreign_Key
ALTER TABLE JPA22_XML_DDL_SPRINTER DROP FOREIGN KEY XML_Sprinter_Foreign_Key
ALTER TABLE JPA22_XML_FORK_USES DROP FOREIGN KEY FK_JPA22_XML_FORK_USES_XMLFork_ID
ALTER TABLE JPA22_XML_FORK_FORK_USERS DROP FOREIGN KEY FK_JPA22_XML_FORK_FORK_USERS_FORK_ID
ALTER TABLE JPA22_XML_FORK_FORK_USERS DROP FOREIGN KEY FK_JPA22_XML_FORK_FORK_USERS_FORK_USER_ID
ALTER TABLE DDL_RUNNERS_RACES DROP FOREIGN KEY XMLRunners_Races_Inverse_Foreign_Key
ALTER TABLE DDL_RUNNERS_RACES DROP FOREIGN KEY XMLRunners_Races_Foreign_Key
ALTER TABLE JPA22_XML_DDL_RUNNER_ACS DROP FOREIGN KEY XMLAccomplistments_Foreign_Key
ALTER TABLE JPA22_XML_DDL_ENDORSEMENTS DROP FOREIGN KEY XMLEndorsements_Key_Foreign_Key
ALTER TABLE JPA22_XML_DDL_ENDORSEMENTS DROP FOREIGN KEY XMLEndorsements_Foreign_Key
ALTER TABLE JPA22_XML_DDL_RUNNER_PBS DROP FOREIGN KEY XML_Runner_PBS_Foreign_Key
DROP INDEX INDEX_JPA22_XML_FORK_STYLE_COLOR ON JPA22_XML_FORK
DROP TABLE JPA22_XML_FORK
DROP INDEX XML_FORK_COSTS_INDEX ON JPA22_XML_FORK_COSTS
DROP TABLE JPA22_XML_FORK_COSTS
DROP TABLE JPA22_XML_DDL_ORGANIZER
DROP TABLE JPA22_XML_DDL_ENDORSER
DROP TABLE JPA22_XML_DDL_RACE
DROP TABLE JPA22_XML_DLL_RUNNER
DROP TABLE JPA22_XML_DDL_SHOE_TAG
DROP TABLE JPA22_XML_FORK_USER
DROP TABLE JPA22_XML_DDL_SHOE
DROP TABLE JPA22_XML_DDL_SPRINTER
DROP INDEX JPA22_XML_FORK_USES_INDEX ON JPA22_XML_FORK_USES
DROP TABLE JPA22_XML_FORK_USES
DROP INDEX JPA22_XML_FORK_USERS_INDEX ON JPA22_XML_FORK_FORK_USERS
DROP TABLE JPA22_XML_FORK_FORK_USERS
DROP TABLE DDL_RUNNERS_RACES
DROP TABLE JPA22_XML_DDL_RUNNER_ACS
DROP TABLE JPA22_XML_DDL_ENDORSEMENTS
DROP TABLE JPA22_XML_DDL_RUNNER_PBS
DROP INDEX XML_TABLE_GENERATOR_INDEX ON JPA22_XML_PK_SEQ
DELETE FROM JPA22_XML_PK_SEQ WHERE XML_SEQ_NAME = 'XML_UTENSIL_SEQ'
DELETE FROM SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN'