X-Git-Url: http://juplo.de/gitweb/?p=hibernate4-maven-plugin;a=blobdiff_plain;f=src%2Fit%2Fhibernate4-maven-plugin-envers-sample%2Fdrop-tables-hsqldb.sql;h=04b457d091dc3dfc2e205ea68db680af42d4bc1c;hp=1578d8986d3a880efa3c765c88660afc285bdc7b;hb=4940080670944a15916c68fb294e18a6bfef12d5;hpb=1628bcf6c9290a729352215ee22e5b48fa628c4c

diff --git a/src/it/hibernate4-maven-plugin-envers-sample/drop-tables-hsqldb.sql b/src/it/hibernate4-maven-plugin-envers-sample/drop-tables-hsqldb.sql
index 1578d898..04b457d0 100644
--- a/src/it/hibernate4-maven-plugin-envers-sample/drop-tables-hsqldb.sql
+++ b/src/it/hibernate4-maven-plugin-envers-sample/drop-tables-hsqldb.sql
@@ -1,10 +1,13 @@
-    drop table TTL_AUDIT_REVISION if exists cascade;
 
-    drop table TTL_EVENT if exists cascade;
+    alter table TTL_EVENT_AUD 
+        drop constraint FK_cjsh8995uabmdm9b30uvmyj6p;
 
-    drop table TTL_EVENT_AUD if exists cascade;
+    drop table TTL_AUDIT_REVISION if exists;
 
-    drop sequence TTL_AUDIT_REVISION_SEQ if exists ;
+    drop table TTL_EVENT if exists;
 
-    drop sequence TTL_EVENT_SEQ if exists ;
+    drop table TTL_EVENT_AUD if exists;
 
+    drop sequence TTL_AUDIT_REVISION_SEQ;
+
+    drop sequence TTL_EVENT_SEQ;