Added an integration-test, that depends on properties from a persistence.xml
[hibernate4-maven-plugin] / src / it / h4mp-mod / schema.sql
diff --git a/src/it/h4mp-mod/schema.sql b/src/it/h4mp-mod/schema.sql
new file mode 100644 (file)
index 0000000..1fc1d88
--- /dev/null
@@ -0,0 +1,28 @@
+
+    create table MainEntity (
+        id int8 not null,
+        str varchar(255),
+        primary key (id)
+    );
+
+    create table MainEntity_AUD (
+        id int8 not null,
+        REV int4 not null,
+        REVTYPE int2,
+        str varchar(255),
+        str_MOD boolean,
+        primary key (id, REV)
+    );
+
+    create table REVINFO (
+        REV int4 not null,
+        REVTSTMP int8,
+        primary key (REV)
+    );
+
+    alter table MainEntity_AUD 
+        add constraint FK_kpx35pyi0ssiutbfxbf8klu06 
+        foreign key (REV) 
+        references REVINFO;
+
+    create sequence hibernate_sequence;