X-Git-Url: https://juplo.de/gitweb/?p=hibernate4-maven-plugin;a=blobdiff_plain;f=src%2Fit%2Ftutorials-4.3.9%2Fschema-osgi-unmanaged-native.sql;fp=src%2Fit%2Ftutorials-4.3.9%2Fschema-osgi-unmanaged-native.sql;h=d89e2801edfe55ffe693874cd4af3b9fc844c61f;hp=0000000000000000000000000000000000000000;hb=64f720667c586f37a72ca1592fc5dbd4533dd557;hpb=ea93983d161f5d37d389298df4ff42d24263a621 diff --git a/src/it/tutorials-4.3.9/schema-osgi-unmanaged-native.sql b/src/it/tutorials-4.3.9/schema-osgi-unmanaged-native.sql new file mode 100644 index 00000000..d89e2801 --- /dev/null +++ b/src/it/tutorials-4.3.9/schema-osgi-unmanaged-native.sql @@ -0,0 +1,26 @@ +create sequence hibernate_sequence start with 1 increment by 1; + + create table DataPoint ( + id bigint not null, + name varchar(255), + primary key (id) + ); + + create table DataPoint_AUD ( + id bigint not null, + REV integer not null, + REVTYPE tinyint, + name varchar(255), + primary key (id, REV) + ); + + create table REVINFO ( + REV integer generated by default as identity, + REVTSTMP bigint, + primary key (REV) + ); + + alter table DataPoint_AUD + add constraint FK43jw6b5mtbfxur0xhyjxynbea + foreign key (REV) + references REVINFO;