X-Git-Url: http://juplo.de/gitweb/?p=hibernate4-maven-plugin;a=blobdiff_plain;f=src%2Fit%2Fhibernate4-maven-plugin-envers-sample%2Fcreate-tables-hsqldb.sql;fp=src%2Fit%2Fhibernate4-maven-plugin-envers-sample%2Fcreate-tables-hsqldb.sql;h=fe6130e0fe4dad1d09a043af7d27304e010338db;hp=0000000000000000000000000000000000000000;hb=1628bcf6c9290a729352215ee22e5b48fa628c4c;hpb=25079f13c0eda6807d5aee67086a21ddde313213

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
new file mode 100644
index 00000000..fe6130e0
--- /dev/null
+++ b/src/it/hibernate4-maven-plugin-envers-sample/create-tables-hsqldb.sql
@@ -0,0 +1,33 @@
+
+    create table TTL_AUDIT_REVISION (
+        ID bigint not null,
+        EVENT_DATE timestamp,
+        ENVERS_TSTAMP bigint not null,
+        USER_NAME varchar(80) not null,
+        primary key (ID)
+    );
+
+    create table TTL_EVENT (
+        ID bigint not null,
+        EVENT_DATE timestamp not null,
+        TITLE varchar(80) not null,
+        primary key (ID)
+    );
+
+    create table TTL_EVENT_AUD (
+        ID bigint not null,
+        REV bigint not null,
+        REVTYPE tinyint,
+        EVENT_DATE timestamp,
+        TITLE varchar(80),
+        primary key (ID, REV)
+    );
+
+    alter table TTL_EVENT_AUD 
+        add constraint FK_cjsh8995uabmdm9b30uvmyj6p 
+        foreign key (REV) 
+        references TTL_AUDIT_REVISION;
+
+    create sequence TTL_AUDIT_REVISION_SEQ;
+
+    create sequence TTL_EVENT_SEQ;