X-Git-Url: https://juplo.de/gitweb/?p=hibernate4-maven-plugin;a=blobdiff_plain;f=src%2Fit%2Fhibernate4-maven-plugin-envers-sample%2Fcreate-tables-hsqldb.sql;h=180166f7f1c5cc3cab57c91008dd4f59e33589ed;hp=5326293825db4b13dd7550d41c6b28111dd0477a;hb=8e5921c9e76b4540f1d4b75e05e338001145ff6d;hpb=6dff3bfb0f9ea7a1d0cc56398aaad29e31a17b91;ds=sidebyside

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 53262938..180166f7 100644
--- 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;