diff options
Diffstat (limited to 'eclipselink/org.eclipse.emf.teneo.eclipselink.examples.library.orm.tests/dropDDL.jdbc')
-rwxr-xr-x | eclipselink/org.eclipse.emf.teneo.eclipselink.examples.library.orm.tests/dropDDL.jdbc | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/eclipselink/org.eclipse.emf.teneo.eclipselink.examples.library.orm.tests/dropDDL.jdbc b/eclipselink/org.eclipse.emf.teneo.eclipselink.examples.library.orm.tests/dropDDL.jdbc new file mode 100755 index 000000000..1fda3296d --- /dev/null +++ b/eclipselink/org.eclipse.emf.teneo.eclipselink.examples.library.orm.tests/dropDDL.jdbc @@ -0,0 +1,27 @@ +ALTER TABLE EMFLIB_PUBLISHER_WRITER DROP CONSTRAINT MFLBPBLSHRWRwrtrsD +ALTER TABLE EMFLIB_PUBLISHER_WRITER DROP CONSTRAINT MFLBPBLSHRpblshrsD +ALTER TABLE EMFLIB_COVER DROP CONSTRAINT MFLBCOVERCNTINERID +ALTER TABLE EMFLIB_LIBRARY_BOOK_MAP DROP CONSTRAINT MFLBLBRRYBKMLBRRYD +ALTER TABLE EMFLIB_LIBRARY_BOOK_MAP DROP CONSTRAINT MFLBLBRRYBOKMAPBKD +ALTER TABLE EMFLIB_BOOK_STYLE_MAP DROP CONSTRAINT MFLBBOKSTYLEMAPBKD +ALTER TABLE EMFLIB_BOOK_STYLE_MAP DROP CONSTRAINT MFLBBKSTYLMAPSTYLD +ALTER TABLE EMFLIB_WRITER DROP CONSTRAINT MFLBWRITERCNTNERID +ALTER TABLE EMFLIB_WRITER DROP CONSTRAINT MFLBWRITERDDRESSID +ALTER TABLE EMFLIB_BOOK DROP CONSTRAINT EMFLIBBOOKAUTHORID +ALTER TABLE EMFLIB_BOOK DROP CONSTRAINT MFLBBOOKTRNSLTORID +ALTER TABLE EMFLIB_WRITER_TYPEWRITER DROP CONSTRAINT MFLBWRTRTtypwrtrsD +ALTER TABLE EMFLIB_WRITER_TYPEWRITER DROP CONSTRAINT MFLBWRTRTYPWRWrtrD +DROP TABLE EMFLIB_STYLE +DROP TABLE EMFLIB_PUBLISHER +DROP TABLE EMFLIB_PUBLISHER_WRITER +DROP TABLE EMFLIB_COVER +DROP TABLE EMFLIB_LIBRARY +DROP TABLE EMFLIB_TRANSLATOR +DROP TABLE EMFLIB_LIBRARY_BOOK_MAP +DROP TABLE EMFLIB_BOOK_STYLE_MAP +DROP TABLE EMFLIB_ADDRESS +DROP TABLE EMFLIB_TYPEWRITER +DROP TABLE EMFLIB_WRITER +DROP TABLE EMFLIB_BOOK +DROP TABLE EMFLIB_WRITER_TYPEWRITER +DELETE FROM SEQUENCE WHERE SEQ_NAME = 'SEQ_GEN' |