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=5326293825db4b13dd7550d41c6b28111dd0477a;hp=fe6130e0fe4dad1d09a043af7d27304e010338db;hb=fed9fc9e4e053c8b61895e78d1fbe045fadf7348;hpb=fee05864d61145a06ee870fbffd3bff1e95af08c 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 fe6130e0..53262938 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,7 @@ create table TTL_AUDIT_REVISION ( ID bigint not null, - EVENT_DATE timestamp, + EVENT_DATE timestamp not null, ENVERS_TSTAMP bigint not null, USER_NAME varchar(80) not null, primary key (ID) @@ -28,6 +28,6 @@ foreign key (REV) references TTL_AUDIT_REVISION; - create sequence TTL_AUDIT_REVISION_SEQ; + create sequence TTL_AUDIT_REVISION_SEQ start with 1; - create sequence TTL_EVENT_SEQ; + create sequence TTL_EVENT_SEQ start with 1;