X-Git-Url: https://juplo.de/gitweb/?p=hibernate4-maven-plugin;a=blobdiff_plain;f=src%2Fit%2Fh4mp-mod%2Fschema.sql;fp=src%2Fit%2Fh4mp-mod%2Fschema.sql;h=1fc1d887a379a0a9b61eca4bd10cc7cea8630d42;hp=0000000000000000000000000000000000000000;hb=d5a4326bf1fe2045a7b2183cfd3d8fdb30fcb406;hpb=5da1114d419ae10f94a83ad56cea9856a39f00b6 diff --git a/src/it/h4mp-mod/schema.sql b/src/it/h4mp-mod/schema.sql new file mode 100644 index 00000000..1fc1d887 --- /dev/null +++ b/src/it/h4mp-mod/schema.sql @@ -0,0 +1,28 @@ + + create table MainEntity ( + id int8 not null, + str varchar(255), + primary key (id) + ); + + create table MainEntity_AUD ( + id int8 not null, + REV int4 not null, + REVTYPE int2, + str varchar(255), + str_MOD boolean, + primary key (id, REV) + ); + + create table REVINFO ( + REV int4 not null, + REVTSTMP int8, + primary key (REV) + ); + + alter table MainEntity_AUD + add constraint FK_kpx35pyi0ssiutbfxbf8klu06 + foreign key (REV) + references REVINFO; + + create sequence hibernate_sequence;