Added tutorials of the hibernate-release 5.2.18.Final

[hibernate4-maven-plugin] / src / it / tutorials-4.3.9 / schema-osgi-unmanaged-native.sql

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 (file)
index 0000000..d89e280
--- /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;