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=0b6b9a1bd8950880713885618d8e31c772a085ec;hpb=9e37fd1049f8a6794396cd7c8879dc413fbcb87c 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;