X-Git-Url: http://juplo.de/gitweb/?p=hibernate4-maven-plugin;a=blobdiff_plain;f=src%2Fit%2Ftutorials%2Fschema-osgi-unmanaged-native.sql;fp=src%2Fit%2Ftutorials%2Fschema-osgi-unmanaged-native.sql;h=37165353765dc85b3cb963946a99ad73e1efce2c;hp=0000000000000000000000000000000000000000;hb=94e6b2e93fe107e75c9d20aa1eb3126e78a5ed0a;hpb=b3f8db2fdd9eddbaac002f94068dd1b4e6aef9a8

diff --git a/src/it/tutorials/schema-osgi-unmanaged-native.sql b/src/it/tutorials/schema-osgi-unmanaged-native.sql
new file mode 100644
index 00000000..37165353
--- /dev/null
+++ b/src/it/tutorials/schema-osgi-unmanaged-native.sql
@@ -0,0 +1,31 @@
+
+    drop table DataPoint if exists;
+
+    drop table DataPoint_AUD if exists;
+
+    drop table REVINFO if exists;
+
+    create table DataPoint (
+        id bigint generated by default as identity,
+        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 FK_7pdslro8w1n74eqwmorrn0hnb 
+        foreign key (REV) 
+        references REVINFO;