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=eee70612a1b9c969f7cff1ee2a128aadf21bc4fb;hp=5326293825db4b13dd7550d41c6b28111dd0477a;hb=ee7f6da0225efc14d89fab58d88a45c98823399e;hpb=fed9fc9e4e053c8b61895e78d1fbe045fadf7348 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..eee70612 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,9 @@ +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 +26,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;