X-Git-Url: https://juplo.de/gitweb/?p=hibernate4-maven-plugin;a=blobdiff_plain;f=src%2Fit%2Ftutorials-5.4.2%2Fschema-osgi-unmanaged-native.sql;fp=src%2Fit%2Ftutorials-5.4.2%2Fschema-osgi-unmanaged-native.sql;h=d89e2801edfe55ffe693874cd4af3b9fc844c61f;hp=0000000000000000000000000000000000000000;hb=9866cabaae00b8766c6e97bac61074b9b35a2909;hpb=0e67b8c355ad7f932b552d7a02a0158e17af5aa7 diff --git a/src/it/tutorials-5.4.2/schema-osgi-unmanaged-native.sql b/src/it/tutorials-5.4.2/schema-osgi-unmanaged-native.sql new file mode 100644 index 00000000..d89e2801 --- /dev/null +++ b/src/it/tutorials-5.4.2/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;