Introduced the goal "drop"

[hibernate4-maven-plugin] / src / it / hibernate4-maven-plugin-envers-sample / create-tables-hsqldb.sql

diff --git a/src/it/hibernate4-maven-plugin-envers-sample/create-tables-hsqldb.sql b/src/it/hibernate4-maven-plugin-envers-sample/create-tables-hsqldb.sql
index 5326293..180166f 100644 (file)
--- a/src/it/hibernate4-maven-plugin-envers-sample/create-tables-hsqldb.sql
+++ b/src/it/hibernate4-maven-plugin-envers-sample/create-tables-hsqldb.sql
@@ -1,7 +1,11 @@
 
+    create sequence TTL_AUDIT_REVISION_SEQ start with 1 increment by 10;
+
+    create sequence TTL_EVENT_SEQ start with 1 increment by 10;
+
     create table TTL_AUDIT_REVISION (
         ID bigint not null,
-        EVENT_DATE timestamp not null,
+        EVENT_DATE timestamp,
         ENVERS_TSTAMP bigint not null,
         USER_NAME varchar(80) not null,
         primary key (ID)
@@ -24,10 +28,6 @@
     );
 
     alter table TTL_EVENT_AUD 
-        add constraint FK_cjsh8995uabmdm9b30uvmyj6p 
+        add constraint FK295td34se5kaxwgo8i1ph0k4 
         foreign key (REV) 
         references TTL_AUDIT_REVISION;
-
-    create sequence TTL_AUDIT_REVISION_SEQ start with 1;
-
-    create sequence TTL_EVENT_SEQ start with 1;