TMP: patches... basislager-master
authorKai Moritz <kai@juplo.de>
Wed, 13 Nov 2019 15:06:28 +0000 (16:06 +0100)
committerKai Moritz <kai@juplo.de>
Wed, 13 Nov 2019 15:06:28 +0000 (16:06 +0100)
patch.txt [new file with mode: 0644]
src/it/patch.txt [new file with mode: 0644]

diff --git a/patch.txt b/patch.txt
new file mode 100644 (file)
index 0000000..15bbb92
--- /dev/null
+++ b/patch.txt
@@ -0,0 +1,1302 @@
+commit 714c3fe792905476d026b8c2ef6504e54e1bffe6
+Author: Kai Moritz <kai@juplo.de>
+Date:   Fri Apr 5 15:17:13 2019 +0200
+
+    Upgraded Hibernate 5.2.18.Final 5.3.9.Final
+
+diff --git a/src/it/transport/create.sql b/src/it/transport/create.sql
+index a7f9d94..1e47a91 100644
+--- a/src/it/transport/create.sql
++++ b/src/it/transport/create.sql
+@@ -1,6 +1,6 @@
+     create table Category_Category (
+-        Category_id varchar(191) not null,
++       Category_id varchar(191) not null,
+         Category_nodeType integer not null,
+         Category_source VARCHAR(191) not null,
+         parents_id varchar(191) not null,
+@@ -9,7 +9,7 @@
+     );
+     create table Custom_Category (
+-        Custom_id varchar(191) not null,
++       Custom_id varchar(191) not null,
+         Custom_nodeType integer not null,
+         Custom_source VARCHAR(191) not null,
+         categories_id varchar(191) not null,
+@@ -18,7 +18,7 @@
+     );
+     create table Custom_contributors (
+-        Custom_id varchar(191) not null,
++       Custom_id varchar(191) not null,
+         Custom_nodeType integer not null,
+         Custom_source VARCHAR(191) not null,
+         contributor_id varchar(191),
+@@ -29,7 +29,7 @@
+     );
+     create table Custom_emails (
+-        Custom_id varchar(191) not null,
++       Custom_id varchar(191) not null,
+         Custom_nodeType integer not null,
+         Custom_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -41,7 +41,7 @@
+     );
+     create table Custom_links (
+-        Custom_id varchar(191) not null,
++       Custom_id varchar(191) not null,
+         Custom_nodeType integer not null,
+         Custom_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -53,7 +53,7 @@
+     );
+     create table Custom_numbers (
+-        Custom_id varchar(191) not null,
++       Custom_id varchar(191) not null,
+         Custom_nodeType integer not null,
+         Custom_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -65,7 +65,7 @@
+     );
+     create table Date_contributors (
+-        Date_id varchar(191) not null,
++       Date_id varchar(191) not null,
+         Date_nodeType integer not null,
+         Date_source VARCHAR(191) not null,
+         contributor_id varchar(191),
+@@ -76,7 +76,7 @@
+     );
+     create table Date_emails (
+-        Date_id varchar(191) not null,
++       Date_id varchar(191) not null,
+         Date_nodeType integer not null,
+         Date_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -88,7 +88,7 @@
+     );
+     create table Date_links (
+-        Date_id varchar(191) not null,
++       Date_id varchar(191) not null,
+         Date_nodeType integer not null,
+         Date_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -100,7 +100,7 @@
+     );
+     create table Date_numbers (
+-        Date_id varchar(191) not null,
++       Date_id varchar(191) not null,
+         Date_nodeType integer not null,
+         Date_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -112,14 +112,14 @@
+     );
+     create table Date_types (
+-        Date_id varchar(191) not null,
++       Date_id varchar(191) not null,
+         Date_nodeType integer not null,
+         Date_source VARCHAR(191) not null,
+         types varchar(255)
+     );
+     create table Event_Category (
+-        Event_id varchar(191) not null,
++       Event_id varchar(191) not null,
+         Event_nodeType integer not null,
+         Event_source VARCHAR(191) not null,
+         categories_id varchar(191) not null,
+@@ -128,7 +128,7 @@
+     );
+     create table Event_contributors (
+-        Event_id varchar(191) not null,
++       Event_id varchar(191) not null,
+         Event_nodeType integer not null,
+         Event_source VARCHAR(191) not null,
+         contributor_id varchar(191),
+@@ -139,7 +139,7 @@
+     );
+     create table Event_emails (
+-        Event_id varchar(191) not null,
++       Event_id varchar(191) not null,
+         Event_nodeType integer not null,
+         Event_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -151,7 +151,7 @@
+     );
+     create table Event_links (
+-        Event_id varchar(191) not null,
++       Event_id varchar(191) not null,
+         Event_nodeType integer not null,
+         Event_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -163,7 +163,7 @@
+     );
+     create table Event_numbers (
+-        Event_id varchar(191) not null,
++       Event_id varchar(191) not null,
+         Event_nodeType integer not null,
+         Event_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -175,7 +175,7 @@
+     );
+     create table EventInfo_Group (
+-        nodeId varchar(191) not null,
++       nodeId varchar(191) not null,
+         nodeType integer not null,
+         source VARCHAR(191) not null,
+         groups_id varchar(191) not null,
+@@ -184,7 +184,7 @@
+     );
+     create table Exhibition_contributors (
+-        Exhibition_id varchar(191) not null,
++       Exhibition_id varchar(191) not null,
+         Exhibition_nodeType integer not null,
+         Exhibition_source VARCHAR(191) not null,
+         contributor_id varchar(191),
+@@ -195,7 +195,7 @@
+     );
+     create table Exhibition_emails (
+-        Exhibition_id varchar(191) not null,
++       Exhibition_id varchar(191) not null,
+         Exhibition_nodeType integer not null,
+         Exhibition_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -207,17 +207,17 @@
+     );
+     create table Exhibition_hours (
+-        Exhibition_id varchar(191) not null,
++       Exhibition_id varchar(191) not null,
+         Exhibition_nodeType integer not null,
+         Exhibition_source VARCHAR(191) not null,
+-        close time,
++        close timestamp,
+         day integer,
+-        open time,
++        open timestamp,
+         type varchar(255)
+     );
+     create table Exhibition_links (
+-        Exhibition_id varchar(191) not null,
++       Exhibition_id varchar(191) not null,
+         Exhibition_nodeType integer not null,
+         Exhibition_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -229,7 +229,7 @@
+     );
+     create table Exhibition_numbers (
+-        Exhibition_id varchar(191) not null,
++       Exhibition_id varchar(191) not null,
+         Exhibition_nodeType integer not null,
+         Exhibition_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -241,7 +241,7 @@
+     );
+     create table Group_contributors (
+-        Group_id varchar(191) not null,
++       Group_id varchar(191) not null,
+         Group_nodeType integer not null,
+         Group_source VARCHAR(191) not null,
+         contributor_id varchar(191),
+@@ -252,7 +252,7 @@
+     );
+     create table Group_emails (
+-        Group_id varchar(191) not null,
++       Group_id varchar(191) not null,
+         Group_nodeType integer not null,
+         Group_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -264,7 +264,7 @@
+     );
+     create table Group_links (
+-        Group_id varchar(191) not null,
++       Group_id varchar(191) not null,
+         Group_nodeType integer not null,
+         Group_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -276,7 +276,7 @@
+     );
+     create table Group_numbers (
+-        Group_id varchar(191) not null,
++       Group_id varchar(191) not null,
+         Group_nodeType integer not null,
+         Group_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -288,7 +288,7 @@
+     );
+     create table LegalPerson_Category (
+-        LegalPerson_id varchar(191) not null,
++       LegalPerson_id varchar(191) not null,
+         LegalPerson_nodeType integer not null,
+         LegalPerson_source VARCHAR(191) not null,
+         categories_id varchar(191) not null,
+@@ -297,7 +297,7 @@
+     );
+     create table LegalPerson_emails (
+-        LegalPerson_id varchar(191) not null,
++       LegalPerson_id varchar(191) not null,
+         LegalPerson_nodeType integer not null,
+         LegalPerson_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -309,7 +309,7 @@
+     );
+     create table LegalPerson_links (
+-        LegalPerson_id varchar(191) not null,
++       LegalPerson_id varchar(191) not null,
+         LegalPerson_nodeType integer not null,
+         LegalPerson_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -321,7 +321,7 @@
+     );
+     create table LegalPerson_numbers (
+-        LegalPerson_id varchar(191) not null,
++       LegalPerson_id varchar(191) not null,
+         LegalPerson_nodeType integer not null,
+         LegalPerson_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -333,7 +333,7 @@
+     );
+     create table Location_Category (
+-        Location_id varchar(191) not null,
++       Location_id varchar(191) not null,
+         Location_nodeType integer not null,
+         Location_source VARCHAR(191) not null,
+         categories_id varchar(191) not null,
+@@ -342,7 +342,7 @@
+     );
+     create table Location_emails (
+-        Location_id varchar(191) not null,
++       Location_id varchar(191) not null,
+         Location_nodeType integer not null,
+         Location_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -354,17 +354,17 @@
+     );
+     create table Location_hours (
+-        Location_id varchar(191) not null,
++       Location_id varchar(191) not null,
+         Location_nodeType integer not null,
+         Location_source VARCHAR(191) not null,
+-        close time,
++        close timestamp,
+         day integer,
+-        open time,
++        open timestamp,
+         type varchar(255)
+     );
+     create table Location_links (
+-        Location_id varchar(191) not null,
++       Location_id varchar(191) not null,
+         Location_nodeType integer not null,
+         Location_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -376,7 +376,7 @@
+     );
+     create table Location_numbers (
+-        Location_id varchar(191) not null,
++       Location_id varchar(191) not null,
+         Location_nodeType integer not null,
+         Location_source VARCHAR(191) not null,
+         extra varchar(255),
+@@ -388,7 +388,7 @@
+     );
+     create table Node (
+-        DTYPE integer not null,
++       DTYPE integer not null,
+         id varchar(191) not null,
+         nodeType integer not null,
+         source VARCHAR(191) not null,
+@@ -421,12 +421,12 @@
+         firstName varchar(255),
+         lastName varchar(255),
+         type varchar(255),
+-        end date,
+-        start date,
++        end timestamp,
++        start timestamp,
+         gemkey varchar(31),
+         generator varchar(255),
+         after varchar(255),
+-        date date,
++        date timestamp,
+         photographer_id varchar(191),
+         photographer_nodeType integer,
+         photographer_source VARCHAR(191),
+@@ -461,14 +461,14 @@
+     );
+     create table Node_features (
+-        Node_id varchar(191) not null,
++       Node_id varchar(191) not null,
+         Node_nodeType integer not null,
+         Node_source VARCHAR(191) not null,
+         features varchar(255)
+     );
+     create table Node_fields (
+-        Node_id varchar(191) not null,
++       Node_id varchar(191) not null,
+         Node_nodeType integer not null,
+         Node_source VARCHAR(191) not null,
+         fields varchar(255),
+@@ -477,7 +477,7 @@
+     );
+     create table Node_Media (
+-        nodeId varchar(191) not null,
++       nodeId varchar(191) not null,
+         nodeType integer not null,
+         source VARCHAR(191) not null,
+         media_id varchar(191) not null,
+@@ -486,7 +486,7 @@
+     );
+     create table Node_Nodes (
+-        Node_id varchar(191) not null,
++       Node_id varchar(191) not null,
+         Node_nodeType integer not null,
+         Node_source VARCHAR(191) not null,
+         nodes_dbid bigint not null,
+@@ -495,20 +495,20 @@
+     );
+     create table Nodes (
+-        dbid bigint generated by default as identity,
++       dbid bigint generated by default as identity,
+         type varchar(255),
+         primary key (dbid)
+     );
+     create table Nodes_Node (
+-        Nodes_dbid bigint not null,
++       Nodes_dbid bigint not null,
+         nodes_id varchar(191) not null,
+         nodes_nodeType integer not null,
+         nodes_source VARCHAR(191) not null
+     );
+     create table Organization_contributors (
+-        Organization_id varchar(191) not null,
++       Organization_id varchar(191) not null,
+         Organization_nodeType integer not null,
+         Organization_source VARCHAR(191) not null,
+         contributor_id varchar(191),
+@@ -519,7 +519,7 @@
+     );
+     create table Place_Region (
+-        Place_id varchar(191) not null,
++       Place_id varchar(191) not null,
+         Place_nodeType integer not null,
+         Place_source VARCHAR(191) not null,
+         regions_id varchar(191) not null,
+@@ -528,7 +528,7 @@
+     );
+     create table Price (
+-        dbid bigint generated by default as identity,
++       dbid bigint generated by default as identity,
+         currency varchar(255),
+         text varchar(255),
+         type varchar(255),
+@@ -540,7 +540,7 @@
+     );
+     create table Price_emails (
+-        Price_dbid bigint not null,
++       Price_dbid bigint not null,
+         extra varchar(255),
+         icon_id varchar(191),
+         icon_nodeType integer,
+@@ -550,7 +550,7 @@
+     );
+     create table Price_links (
+-        Price_dbid bigint not null,
++       Price_dbid bigint not null,
+         extra varchar(255),
+         icon_id varchar(191),
+         icon_nodeType integer,
+@@ -560,7 +560,7 @@
+     );
+     create table Price_numbers (
+-        Price_dbid bigint not null,
++       Price_dbid bigint not null,
+         extra varchar(255),
+         icon_id varchar(191),
+         icon_nodeType integer,
+@@ -570,7 +570,7 @@
+     );
+     create table Region_City (
+-        Region_id varchar(191) not null,
++       Region_id varchar(191) not null,
+         Region_nodeType integer not null,
+         Region_source VARCHAR(191) not null,
+         cities_id varchar(191) not null,
+@@ -579,527 +579,527 @@
+     );
+     create table Source (
+-        uri VARCHAR(191) not null,
++       uri VARCHAR(191) not null,
+         name varchar(255),
+         primary key (uri)
+     );
+     create table Source_features (
+-        Source_uri VARCHAR(191) not null,
++       Source_uri VARCHAR(191) not null,
+         features binary(255),
+         features_KEY varchar(255) not null,
+         primary key (Source_uri, features_KEY)
+     );
+     create table Source_types (
+-        Source_uri VARCHAR(191) not null,
++       Source_uri VARCHAR(191) not null,
+         types binary(255),
+         types_KEY varchar(255) not null,
+         primary key (Source_uri, types_KEY)
+     );
+     alter table Category_Category 
+-        add constraint UK_ed5lqxomulp7x8hcy3104lw7t unique (parents_id, parents_nodeType, parents_source);
++       add constraint UK_ed5lqxomulp7x8hcy3104lw7t unique (parents_id, parents_nodeType, parents_source);
+     alter table Node 
+-        add constraint uri unique (source, nodeType, id, locale, version);
++       add constraint uri unique (source, nodeType, id, locale, version);
+     alter table Category_Category 
+-        add constraint FKbtv4wjkjdxcopetysbong6ui6 
+-        foreign key (parents_id, parents_nodeType, parents_source) 
+-        references Node;
++       add constraint FKbtv4wjkjdxcopetysbong6ui6 
++       foreign key (parents_id, parents_nodeType, parents_source) 
++       references Node;
+     alter table Category_Category 
+-        add constraint FKkvdv0b6eqyobky9sah5hv2new 
+-        foreign key (Category_id, Category_nodeType, Category_source) 
+-        references Node;
++       add constraint FKkvdv0b6eqyobky9sah5hv2new 
++       foreign key (Category_id, Category_nodeType, Category_source) 
++       references Node;
+     alter table Custom_Category 
+-        add constraint FK2o95493movsb6l1yw4n4khtbh 
+-        foreign key (categories_id, categories_nodeType, categories_source) 
+-        references Node;
++       add constraint FK2o95493movsb6l1yw4n4khtbh 
++       foreign key (categories_id, categories_nodeType, categories_source) 
++       references Node;
+     alter table Custom_Category 
+-        add constraint FK9k7jg7cp6xluljk2qt815tdjp 
+-        foreign key (Custom_id, Custom_nodeType, Custom_source) 
+-        references Node;
++       add constraint FK9k7jg7cp6xluljk2qt815tdjp 
++       foreign key (Custom_id, Custom_nodeType, Custom_source) 
++       references Node;
+     alter table Custom_contributors 
+-        add constraint FKi7asp1dwf0b59mmrqjlhuspfe 
+-        foreign key (contributor_id, contributor_nodeType, contributor_source) 
+-        references Node;
++       add constraint FKi7asp1dwf0b59mmrqjlhuspfe 
++       foreign key (contributor_id, contributor_nodeType, contributor_source) 
++       references Node;
+     alter table Custom_contributors 
+-        add constraint FKthm0rsemcxntnnw2vqa9fbjtg 
+-        foreign key (Custom_id, Custom_nodeType, Custom_source) 
+-        references Node;
++       add constraint FKthm0rsemcxntnnw2vqa9fbjtg 
++       foreign key (Custom_id, Custom_nodeType, Custom_source) 
++       references Node;
+     alter table Custom_emails 
+-        add constraint FKphffh59qd5yhax6ompthaby5w 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FKphffh59qd5yhax6ompthaby5w 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Custom_emails 
+-        add constraint FKt2p150a9i7yores6qhhrxdlqg 
+-        foreign key (Custom_id, Custom_nodeType, Custom_source) 
+-        references Node;
++       add constraint FKt2p150a9i7yores6qhhrxdlqg 
++       foreign key (Custom_id, Custom_nodeType, Custom_source) 
++       references Node;
+     alter table Custom_links 
+-        add constraint FKoavtb3ysx30i4vkp1o9qha3x8 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FKoavtb3ysx30i4vkp1o9qha3x8 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Custom_links 
+-        add constraint FKdp6pu85ss0k17nhnhg8wt95qu 
+-        foreign key (Custom_id, Custom_nodeType, Custom_source) 
+-        references Node;
++       add constraint FKdp6pu85ss0k17nhnhg8wt95qu 
++       foreign key (Custom_id, Custom_nodeType, Custom_source) 
++       references Node;
+     alter table Custom_numbers 
+-        add constraint FKspyya70ibrtp0yp0aet1aulv0 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FKspyya70ibrtp0yp0aet1aulv0 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Custom_numbers 
+-        add constraint FK9n5qkj8uw768qyxluocmgp86l 
+-        foreign key (Custom_id, Custom_nodeType, Custom_source) 
+-        references Node;
++       add constraint FK9n5qkj8uw768qyxluocmgp86l 
++       foreign key (Custom_id, Custom_nodeType, Custom_source) 
++       references Node;
+     alter table Date_contributors 
+-        add constraint FKi6oc1dly4i431dvbh5p6bf8mk 
+-        foreign key (contributor_id, contributor_nodeType, contributor_source) 
+-        references Node;
++       add constraint FKi6oc1dly4i431dvbh5p6bf8mk 
++       foreign key (contributor_id, contributor_nodeType, contributor_source) 
++       references Node;
+     alter table Date_contributors 
+-        add constraint FKr39enr8uc3pjasjsvts2qk67t 
+-        foreign key (Date_id, Date_nodeType, Date_source) 
+-        references Node;
++       add constraint FKr39enr8uc3pjasjsvts2qk67t 
++       foreign key (Date_id, Date_nodeType, Date_source) 
++       references Node;
+     alter table Date_emails 
+-        add constraint FKipovx7k7ccjs6ovv2p1squaqb 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FKipovx7k7ccjs6ovv2p1squaqb 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Date_emails 
+-        add constraint FK8ewik7de7eruekfjln9wiw9u7 
+-        foreign key (Date_id, Date_nodeType, Date_source) 
+-        references Node;
++       add constraint FK8ewik7de7eruekfjln9wiw9u7 
++       foreign key (Date_id, Date_nodeType, Date_source) 
++       references Node;
+     alter table Date_links 
+-        add constraint FK56sagoqdlfivnhx9j64ffq0aq 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FK56sagoqdlfivnhx9j64ffq0aq 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Date_links 
+-        add constraint FK2epditya9rqnwedje5clh9fst 
+-        foreign key (Date_id, Date_nodeType, Date_source) 
+-        references Node;
++       add constraint FK2epditya9rqnwedje5clh9fst 
++       foreign key (Date_id, Date_nodeType, Date_source) 
++       references Node;
+     alter table Date_numbers 
+-        add constraint FK8sybhsii1xwy1b6ay4yw29aad 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FK8sybhsii1xwy1b6ay4yw29aad 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Date_numbers 
+-        add constraint FKpi1tiq27ga4vg10jpu3lcn00j 
+-        foreign key (Date_id, Date_nodeType, Date_source) 
+-        references Node;
++       add constraint FKpi1tiq27ga4vg10jpu3lcn00j 
++       foreign key (Date_id, Date_nodeType, Date_source) 
++       references Node;
+     alter table Date_types 
+-        add constraint FKdwuqn78ynn843lq8qnay7m99d 
+-        foreign key (Date_id, Date_nodeType, Date_source) 
+-        references Node;
++       add constraint FKdwuqn78ynn843lq8qnay7m99d 
++       foreign key (Date_id, Date_nodeType, Date_source) 
++       references Node;
+     alter table Event_Category 
+-        add constraint FK796bki6riterk5qhwwer52i7e 
+-        foreign key (categories_id, categories_nodeType, categories_source) 
+-        references Node;
++       add constraint FK796bki6riterk5qhwwer52i7e 
++       foreign key (categories_id, categories_nodeType, categories_source) 
++       references Node;
+     alter table Event_Category 
+-        add constraint FKoxnijth24p7efxasu8gbqglnh 
+-        foreign key (Event_id, Event_nodeType, Event_source) 
+-        references Node;
++       add constraint FKoxnijth24p7efxasu8gbqglnh 
++       foreign key (Event_id, Event_nodeType, Event_source) 
++       references Node;
+     alter table Event_contributors 
+-        add constraint FK1tegfyer7c6f6gvjaxum2qoh4 
+-        foreign key (contributor_id, contributor_nodeType, contributor_source) 
+-        references Node;
++       add constraint FK1tegfyer7c6f6gvjaxum2qoh4 
++       foreign key (contributor_id, contributor_nodeType, contributor_source) 
++       references Node;
+     alter table Event_contributors 
+-        add constraint FK9nb0vn1fpg02lv1xqwrnymp2a 
+-        foreign key (Event_id, Event_nodeType, Event_source) 
+-        references Node;
++       add constraint FK9nb0vn1fpg02lv1xqwrnymp2a 
++       foreign key (Event_id, Event_nodeType, Event_source) 
++       references Node;
+     alter table Event_emails 
+-        add constraint FKgukmvw30p78pd01t0ub3yhl89 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FKgukmvw30p78pd01t0ub3yhl89 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Event_emails 
+-        add constraint FK44jxwok6hcnl26utfhmabp0w6 
+-        foreign key (Event_id, Event_nodeType, Event_source) 
+-        references Node;
++       add constraint FK44jxwok6hcnl26utfhmabp0w6 
++       foreign key (Event_id, Event_nodeType, Event_source) 
++       references Node;
+     alter table Event_links 
+-        add constraint FKh2cty42m9dcwee8jrbwcykd00 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FKh2cty42m9dcwee8jrbwcykd00 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Event_links 
+-        add constraint FKhnuhk1ebnx3lhblp9tobx2xkm 
+-        foreign key (Event_id, Event_nodeType, Event_source) 
+-        references Node;
++       add constraint FKhnuhk1ebnx3lhblp9tobx2xkm 
++       foreign key (Event_id, Event_nodeType, Event_source) 
++       references Node;
+     alter table Event_numbers 
+-        add constraint FKgpmu2w9h057i4412lhy35u8wk 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FKgpmu2w9h057i4412lhy35u8wk 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Event_numbers 
+-        add constraint FK7vkbmaxmvnycab6grkx1enack 
+-        foreign key (Event_id, Event_nodeType, Event_source) 
+-        references Node;
++       add constraint FK7vkbmaxmvnycab6grkx1enack 
++       foreign key (Event_id, Event_nodeType, Event_source) 
++       references Node;
+     alter table EventInfo_Group 
+-        add constraint FKpwna397y3jfavhfbi631jrfuc 
+-        foreign key (groups_id, groups_nodeType, groups_source) 
+-        references Node;
++       add constraint FKpwna397y3jfavhfbi631jrfuc 
++       foreign key (groups_id, groups_nodeType, groups_source) 
++       references Node;
+     alter table EventInfo_Group 
+-        add constraint FK7vvheht7xq6t8q60x0iwbbo8e 
+-        foreign key (nodeId, nodeType, source) 
+-        references Node;
++       add constraint FK7vvheht7xq6t8q60x0iwbbo8e 
++       foreign key (nodeId, nodeType, source) 
++       references Node;
+     alter table Exhibition_contributors 
+-        add constraint FK5x96y7obyfslktrjb3lw5ksnf 
+-        foreign key (contributor_id, contributor_nodeType, contributor_source) 
+-        references Node;
++       add constraint FK5x96y7obyfslktrjb3lw5ksnf 
++       foreign key (contributor_id, contributor_nodeType, contributor_source) 
++       references Node;
+     alter table Exhibition_contributors 
+-        add constraint FKhb6cddg2ut19lyqhvhkm3n8k6 
+-        foreign key (Exhibition_id, Exhibition_nodeType, Exhibition_source) 
+-        references Node;
++       add constraint FKhb6cddg2ut19lyqhvhkm3n8k6 
++       foreign key (Exhibition_id, Exhibition_nodeType, Exhibition_source) 
++       references Node;
+     alter table Exhibition_emails 
+-        add constraint FKrj3srkor5p48sqctfmqk7kndb 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FKrj3srkor5p48sqctfmqk7kndb 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Exhibition_emails 
+-        add constraint FK4hdpyj0v87bnl6qjs8q50esot 
+-        foreign key (Exhibition_id, Exhibition_nodeType, Exhibition_source) 
+-        references Node;
++       add constraint FK4hdpyj0v87bnl6qjs8q50esot 
++       foreign key (Exhibition_id, Exhibition_nodeType, Exhibition_source) 
++       references Node;
+     alter table Exhibition_hours 
+-        add constraint FK27vcm7e9ercq01vac5vfjy8lp 
+-        foreign key (Exhibition_id, Exhibition_nodeType, Exhibition_source) 
+-        references Node;
++       add constraint FK27vcm7e9ercq01vac5vfjy8lp 
++       foreign key (Exhibition_id, Exhibition_nodeType, Exhibition_source) 
++       references Node;
+     alter table Exhibition_links 
+-        add constraint FKd7q17uoid3jjmj5juqnn6kh3t 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FKd7q17uoid3jjmj5juqnn6kh3t 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Exhibition_links 
+-        add constraint FK9a6f7rvpeplqd2w7se00d6k7i 
+-        foreign key (Exhibition_id, Exhibition_nodeType, Exhibition_source) 
+-        references Node;
++       add constraint FK9a6f7rvpeplqd2w7se00d6k7i 
++       foreign key (Exhibition_id, Exhibition_nodeType, Exhibition_source) 
++       references Node;
+     alter table Exhibition_numbers 
+-        add constraint FK50xco0skes213iffdar4rsjdl 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FK50xco0skes213iffdar4rsjdl 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Exhibition_numbers 
+-        add constraint FKr3esjj54fnif36h8khekq6cjl 
+-        foreign key (Exhibition_id, Exhibition_nodeType, Exhibition_source) 
+-        references Node;
++       add constraint FKr3esjj54fnif36h8khekq6cjl 
++       foreign key (Exhibition_id, Exhibition_nodeType, Exhibition_source) 
++       references Node;
+     alter table Group_contributors 
+-        add constraint FKbmsmbeitqbq8iex4vylge405d 
+-        foreign key (contributor_id, contributor_nodeType, contributor_source) 
+-        references Node;
++       add constraint FKbmsmbeitqbq8iex4vylge405d 
++       foreign key (contributor_id, contributor_nodeType, contributor_source) 
++       references Node;
+     alter table Group_contributors 
+-        add constraint FKf636sk9rghhtgj07a9b19ln5h 
+-        foreign key (Group_id, Group_nodeType, Group_source) 
+-        references Node;
++       add constraint FKf636sk9rghhtgj07a9b19ln5h 
++       foreign key (Group_id, Group_nodeType, Group_source) 
++       references Node;
+     alter table Group_emails 
+-        add constraint FKmip0rdn17823nw0ev7j07658u 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FKmip0rdn17823nw0ev7j07658u 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Group_emails 
+-        add constraint FK7skv245m9v0iq1pksnqul1ljx 
+-        foreign key (Group_id, Group_nodeType, Group_source) 
+-        references Node;
++       add constraint FK7skv245m9v0iq1pksnqul1ljx 
++       foreign key (Group_id, Group_nodeType, Group_source) 
++       references Node;
+     alter table Group_links 
+-        add constraint FKe52ogqykhxk91v8l6tnvwt1gn 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FKe52ogqykhxk91v8l6tnvwt1gn 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Group_links 
+-        add constraint FKd3p24awb4qhm7i7sqhm7gmw3y 
+-        foreign key (Group_id, Group_nodeType, Group_source) 
+-        references Node;
++       add constraint FKd3p24awb4qhm7i7sqhm7gmw3y 
++       foreign key (Group_id, Group_nodeType, Group_source) 
++       references Node;
+     alter table Group_numbers 
+-        add constraint FKadx9i37o50hkycey1s3q1uc97 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FKadx9i37o50hkycey1s3q1uc97 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Group_numbers 
+-        add constraint FK4w1p7ivthda1sxpmt2py3n4r5 
+-        foreign key (Group_id, Group_nodeType, Group_source) 
+-        references Node;
++       add constraint FK4w1p7ivthda1sxpmt2py3n4r5 
++       foreign key (Group_id, Group_nodeType, Group_source) 
++       references Node;
+     alter table LegalPerson_Category 
+-        add constraint FKqqfb7yiroxuw542ni9p54ge6i 
+-        foreign key (categories_id, categories_nodeType, categories_source) 
+-        references Node;
++       add constraint FKqqfb7yiroxuw542ni9p54ge6i 
++       foreign key (categories_id, categories_nodeType, categories_source) 
++       references Node;
+     alter table LegalPerson_Category 
+-        add constraint FKq571u0kqnrtbw1kaebgp5o5b6 
+-        foreign key (LegalPerson_id, LegalPerson_nodeType, LegalPerson_source) 
+-        references Node;
++       add constraint FKq571u0kqnrtbw1kaebgp5o5b6 
++       foreign key (LegalPerson_id, LegalPerson_nodeType, LegalPerson_source) 
++       references Node;
+     alter table LegalPerson_emails 
+-        add constraint FK57r51bhrrtkphral2s5g8fliw 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FK57r51bhrrtkphral2s5g8fliw 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table LegalPerson_emails 
+-        add constraint FKcw2plu6hr2x0cn9oif1vb8fnc 
+-        foreign key (LegalPerson_id, LegalPerson_nodeType, LegalPerson_source) 
+-        references Node;
++       add constraint FKcw2plu6hr2x0cn9oif1vb8fnc 
++       foreign key (LegalPerson_id, LegalPerson_nodeType, LegalPerson_source) 
++       references Node;
+     alter table LegalPerson_links 
+-        add constraint FK2n9qnfwvfu8np8w29h7k3323g 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FK2n9qnfwvfu8np8w29h7k3323g 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table LegalPerson_links 
+-        add constraint FKqtqxdehi6fu72ko6odlbg6r3t 
+-        foreign key (LegalPerson_id, LegalPerson_nodeType, LegalPerson_source) 
+-        references Node;
++       add constraint FKqtqxdehi6fu72ko6odlbg6r3t 
++       foreign key (LegalPerson_id, LegalPerson_nodeType, LegalPerson_source) 
++       references Node;
+     alter table LegalPerson_numbers 
+-        add constraint FKe37ecgbbetkxwlw77m973rqwe 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FKe37ecgbbetkxwlw77m973rqwe 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table LegalPerson_numbers 
+-        add constraint FKo2l34vktv5jnysok64g3wfqvq 
+-        foreign key (LegalPerson_id, LegalPerson_nodeType, LegalPerson_source) 
+-        references Node;
++       add constraint FKo2l34vktv5jnysok64g3wfqvq 
++       foreign key (LegalPerson_id, LegalPerson_nodeType, LegalPerson_source) 
++       references Node;
+     alter table Location_Category 
+-        add constraint FKbpj9fd3vreu4hi2xpe2ll55vo 
+-        foreign key (categories_id, categories_nodeType, categories_source) 
+-        references Node;
++       add constraint FKbpj9fd3vreu4hi2xpe2ll55vo 
++       foreign key (categories_id, categories_nodeType, categories_source) 
++       references Node;
+     alter table Location_Category 
+-        add constraint FK5b6fpm548a7lgts68vhy7mcj4 
+-        foreign key (Location_id, Location_nodeType, Location_source) 
+-        references Node;
++       add constraint FK5b6fpm548a7lgts68vhy7mcj4 
++       foreign key (Location_id, Location_nodeType, Location_source) 
++       references Node;
+     alter table Location_emails 
+-        add constraint FKn2xd9u1a04ks23nd0ussna3rq 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FKn2xd9u1a04ks23nd0ussna3rq 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Location_emails 
+-        add constraint FKckgpp1j0ob5bspu854g61goko 
+-        foreign key (Location_id, Location_nodeType, Location_source) 
+-        references Node;
++       add constraint FKckgpp1j0ob5bspu854g61goko 
++       foreign key (Location_id, Location_nodeType, Location_source) 
++       references Node;
+     alter table Location_hours 
+-        add constraint FK2fgc24b4d2v3pu1opsfvowt3o 
+-        foreign key (Location_id, Location_nodeType, Location_source) 
+-        references Node;
++       add constraint FK2fgc24b4d2v3pu1opsfvowt3o 
++       foreign key (Location_id, Location_nodeType, Location_source) 
++       references Node;
+     alter table Location_links 
+-        add constraint FK22oj3jm0qo3ylcojflryeovsj 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FK22oj3jm0qo3ylcojflryeovsj 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Location_links 
+-        add constraint FKr1c5cxw7f0kea4e6jf3t4wwbl 
+-        foreign key (Location_id, Location_nodeType, Location_source) 
+-        references Node;
++       add constraint FKr1c5cxw7f0kea4e6jf3t4wwbl 
++       foreign key (Location_id, Location_nodeType, Location_source) 
++       references Node;
+     alter table Location_numbers 
+-        add constraint FKn5fopoumjl9peoc0wydq0y7if 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FKn5fopoumjl9peoc0wydq0y7if 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Location_numbers 
+-        add constraint FKr5k04mtbvfnbof26m75de5ujl 
+-        foreign key (Location_id, Location_nodeType, Location_source) 
+-        references Node;
++       add constraint FKr5k04mtbvfnbof26m75de5ujl 
++       foreign key (Location_id, Location_nodeType, Location_source) 
++       references Node;
+     alter table Node 
+-        add constraint FK9ted8q3xnwgdae6r2b6a2j2c8 
+-        foreign key (photographer_id, photographer_nodeType, photographer_source) 
+-        references Node;
++       add constraint FK9ted8q3xnwgdae6r2b6a2j2c8 
++       foreign key (photographer_id, photographer_nodeType, photographer_source) 
++       references Node;
+     alter table Node 
+-        add constraint FKdbvdgnv0766xu7jlxwghad4oq 
+-        foreign key (country_id, country_nodeType, country_source) 
+-        references Node;
++       add constraint FKdbvdgnv0766xu7jlxwghad4oq 
++       foreign key (country_id, country_nodeType, country_source) 
++       references Node;
+     alter table Node 
+-        add constraint FKkh3kdosgk406i59pksttr398b 
+-        foreign key (state_id, state_nodeType, state_source) 
+-        references Node;
++       add constraint FKkh3kdosgk406i59pksttr398b 
++       foreign key (state_id, state_nodeType, state_source) 
++       references Node;
+     alter table Node 
+-        add constraint FKqwd2vxgkcydcohnw9xuxu4w8n 
+-        foreign key (city_id, city_nodeType, city_source) 
+-        references Node;
++       add constraint FKqwd2vxgkcydcohnw9xuxu4w8n 
++       foreign key (city_id, city_nodeType, city_source) 
++       references Node;
+     alter table Node 
+-        add constraint FKcfsvjllpwnsrxy2qkv2fg1wli 
+-        foreign key (district_id, district_nodeType, district_source) 
+-        references Node;
++       add constraint FKcfsvjllpwnsrxy2qkv2fg1wli 
++       foreign key (district_id, district_nodeType, district_source) 
++       references Node;
+     alter table Node 
+-        add constraint FKhuf20tlghhk21gs0n65cdgwxh 
+-        foreign key (parent_id, parent_nodeType, parent_source) 
+-        references Node;
++       add constraint FKhuf20tlghhk21gs0n65cdgwxh 
++       foreign key (parent_id, parent_nodeType, parent_source) 
++       references Node;
+     alter table Node 
+-        add constraint FK3t7obkasckpeh8lam3gul13k 
+-        foreign key (event_id, event_nodeType, event_source) 
+-        references Node;
++       add constraint FK3t7obkasckpeh8lam3gul13k 
++       foreign key (event_id, event_nodeType, event_source) 
++       references Node;
+     alter table Node 
+-        add constraint FK5v23em75p47f86muwm34i6ibk 
+-        foreign key (location_id, location_nodeType, location_source) 
+-        references Node;
++       add constraint FK5v23em75p47f86muwm34i6ibk 
++       foreign key (location_id, location_nodeType, location_source) 
++       references Node;
+     alter table Node 
+-        add constraint FKnsy9f76nf7ocajkfuuvxmv5g7 
+-        foreign key (node_id, node_nodeType, node_source) 
+-        references Node;
++       add constraint FKnsy9f76nf7ocajkfuuvxmv5g7 
++       foreign key (node_id, node_nodeType, node_source) 
++       references Node;
+     alter table Node 
+-        add constraint FK6udg7k9o0ffj9lesyf3a12pqr 
+-        foreign key (subunit_id, subunit_nodeType, subunit_source) 
+-        references Node;
++       add constraint FK6udg7k9o0ffj9lesyf3a12pqr 
++       foreign key (subunit_id, subunit_nodeType, subunit_source) 
++       references Node;
+     alter table Node_features 
+-        add constraint FKrq26l7t2c19663gew9ml6cvud 
+-        foreign key (Node_id, Node_nodeType, Node_source) 
+-        references Node;
++       add constraint FKrq26l7t2c19663gew9ml6cvud 
++       foreign key (Node_id, Node_nodeType, Node_source) 
++       references Node;
+     alter table Node_fields 
+-        add constraint FKneblsglqyju4ma3kpju4c7orq 
+-        foreign key (Node_id, Node_nodeType, Node_source) 
+-        references Node;
++       add constraint FKneblsglqyju4ma3kpju4c7orq 
++       foreign key (Node_id, Node_nodeType, Node_source) 
++       references Node;
+     alter table Node_Media 
+-        add constraint FKn0qdv3hrutqr6r0umned27d4c 
+-        foreign key (media_id, media_nodeType, media_source) 
+-        references Node;
++       add constraint FKn0qdv3hrutqr6r0umned27d4c 
++       foreign key (media_id, media_nodeType, media_source) 
++       references Node;
+     alter table Node_Media 
+-        add constraint FK1xaqp7wwyf36aporbvniekdrv 
+-        foreign key (nodeId, nodeType, source) 
+-        references Node;
++       add constraint FK1xaqp7wwyf36aporbvniekdrv 
++       foreign key (nodeId, nodeType, source) 
++       references Node;
+     alter table Node_Nodes 
+-        add constraint FKi3m2oeejpb1njux7j14pvo16b 
+-        foreign key (nodes_dbid) 
+-        references Nodes;
++       add constraint FKi3m2oeejpb1njux7j14pvo16b 
++       foreign key (nodes_dbid) 
++       references Nodes;
+     alter table Node_Nodes 
+-        add constraint FKee84dn6iionubhwkf575y9vax 
+-        foreign key (Node_id, Node_nodeType, Node_source) 
+-        references Node;
++       add constraint FKee84dn6iionubhwkf575y9vax 
++       foreign key (Node_id, Node_nodeType, Node_source) 
++       references Node;
+     alter table Nodes_Node 
+-        add constraint FKq8jht9sf4j6k5qo8cuwn65cbo 
+-        foreign key (nodes_id, nodes_nodeType, nodes_source) 
+-        references Node;
++       add constraint FKq8jht9sf4j6k5qo8cuwn65cbo 
++       foreign key (nodes_id, nodes_nodeType, nodes_source) 
++       references Node;
+     alter table Nodes_Node 
+-        add constraint FKjp2exc3ajmkmmt4oa151243e 
+-        foreign key (Nodes_dbid) 
+-        references Nodes;
++       add constraint FKjp2exc3ajmkmmt4oa151243e 
++       foreign key (Nodes_dbid) 
++       references Nodes;
+     alter table Organization_contributors 
+-        add constraint FKdr4ufvx8juh8jpq913j63mvjy 
+-        foreign key (contributor_id, contributor_nodeType, contributor_source) 
+-        references Node;
++       add constraint FKdr4ufvx8juh8jpq913j63mvjy 
++       foreign key (contributor_id, contributor_nodeType, contributor_source) 
++       references Node;
+     alter table Organization_contributors 
+-        add constraint FKlda1w56spi8gim216xocg2n5t 
+-        foreign key (Organization_id, Organization_nodeType, Organization_source) 
+-        references Node;
++       add constraint FKlda1w56spi8gim216xocg2n5t 
++       foreign key (Organization_id, Organization_nodeType, Organization_source) 
++       references Node;
+     alter table Place_Region 
+-        add constraint FK1barpdkpy4p8f2tcgwhqaay1n 
+-        foreign key (regions_id, regions_nodeType, regions_source) 
+-        references Node;
++       add constraint FK1barpdkpy4p8f2tcgwhqaay1n 
++       foreign key (regions_id, regions_nodeType, regions_source) 
++       references Node;
+     alter table Place_Region 
+-        add constraint FK3gga17h07k8awue3capjepjb2 
+-        foreign key (Place_id, Place_nodeType, Place_source) 
+-        references Node;
++       add constraint FK3gga17h07k8awue3capjepjb2 
++       foreign key (Place_id, Place_nodeType, Place_source) 
++       references Node;
+     alter table Price 
+-        add constraint FKson2y4hg9osya48c5idq0kguk 
+-        foreign key (nodeId, nodeType, source) 
+-        references Node;
++       add constraint FKson2y4hg9osya48c5idq0kguk 
++       foreign key (nodeId, nodeType, source) 
++       references Node;
+     alter table Price_emails 
+-        add constraint FK7j7cjie0a3qemqlgwlxqqlc92 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FK7j7cjie0a3qemqlgwlxqqlc92 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Price_emails 
+-        add constraint FKq6ito5fik1kniadn6cwqm0l9f 
+-        foreign key (Price_dbid) 
+-        references Price;
++       add constraint FKq6ito5fik1kniadn6cwqm0l9f 
++       foreign key (Price_dbid) 
++       references Price;
+     alter table Price_links 
+-        add constraint FKobn3hdtitjci6trqdwnrmj7m2 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FKobn3hdtitjci6trqdwnrmj7m2 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Price_links 
+-        add constraint FKhmji8edy6h9017ktwlrr9vmw 
+-        foreign key (Price_dbid) 
+-        references Price;
++       add constraint FKhmji8edy6h9017ktwlrr9vmw 
++       foreign key (Price_dbid) 
++       references Price;
+     alter table Price_numbers 
+-        add constraint FK4xahu5ppk7qmu1g6toypk0a13 
+-        foreign key (icon_id, icon_nodeType, icon_source) 
+-        references Node;
++       add constraint FK4xahu5ppk7qmu1g6toypk0a13 
++       foreign key (icon_id, icon_nodeType, icon_source) 
++       references Node;
+     alter table Price_numbers 
+-        add constraint FKiejn1brgdrrpflwykhlpw0w4n 
+-        foreign key (Price_dbid) 
+-        references Price;
++       add constraint FKiejn1brgdrrpflwykhlpw0w4n 
++       foreign key (Price_dbid) 
++       references Price;
+     alter table Region_City 
+-        add constraint FKogds6ncpkoqv484wign95w0sd 
+-        foreign key (cities_id, cities_nodeType, cities_source) 
+-        references Node;
++       add constraint FKogds6ncpkoqv484wign95w0sd 
++       foreign key (cities_id, cities_nodeType, cities_source) 
++       references Node;
+     alter table Region_City 
+-        add constraint FKhifiimy7x0ksxh6ffenvqw38t 
+-        foreign key (Region_id, Region_nodeType, Region_source) 
+-        references Node;
++       add constraint FKhifiimy7x0ksxh6ffenvqw38t 
++       foreign key (Region_id, Region_nodeType, Region_source) 
++       references Node;
+     alter table Source_features 
+-        add constraint FKbowlk95psbed0re5f8b2x8xch 
+-        foreign key (Source_uri) 
+-        references Source;
++       add constraint FKbowlk95psbed0re5f8b2x8xch 
++       foreign key (Source_uri) 
++       references Source;
+     alter table Source_types 
+-        add constraint FK2miu98q4nc71gepck5sx3v7ye 
+-        foreign key (Source_uri) 
+-        references Source;
++       add constraint FK2miu98q4nc71gepck5sx3v7ye 
++       foreign key (Source_uri) 
++       references Source;
diff --git a/src/it/patch.txt b/src/it/patch.txt
new file mode 100644 (file)
index 0000000..cb8338d
--- /dev/null
@@ -0,0 +1,545 @@
+commit 046df1b894a9f65737461b4146bfe72acf97ca8e
+Author: Kai Moritz <kai@juplo.de>
+Date:   Fri Apr 5 12:37:19 2019 +0200
+
+    Configured the 5.2.18-tutorials to use the hibernate-maven-plugin
+
+diff --git a/src/it/tutorials-5.2.18/annotations/pom.xml b/src/it/tutorials-5.2.18/annotations/pom.xml
+index effd4b7..505432c 100644
+--- a/src/it/tutorials-5.2.18/annotations/pom.xml
++++ b/src/it/tutorials-5.2.18/annotations/pom.xml
+@@ -23,6 +23,30 @@
+     <properties>
+         <!-- Skip artifact deployment -->
+         <maven.deploy.skip>true</maven.deploy.skip>
++        <hibernate-maven-plugin.version>@project.version@</hibernate-maven-plugin.version>
+     </properties>
++
++    <build>
++        <plugins>
++            <plugin>
++                <groupId>de.juplo</groupId>
++                <artifactId>hibernate-maven-plugin</artifactId>
++                <version>${hibernate-maven-plugin.version}</version>
++                <executions>
++                    <execution>
++                        <phase>process-test-classes</phase>
++                        <goals>
++                            <goal>create</goal>
++                        </goals>
++                    </execution>
++                </executions>
++                <configuration>
++                    <scanTestClasses>true</scanTestClasses>
++                    <format>true</format>
++                </configuration>
++            </plugin>
++        </plugins>
++    </build>
++
+ </project>
+diff --git a/src/it/tutorials-5.2.18/annotations/src/test/resources/hibernate.cfg.xml b/src/it/tutorials-5.2.18/annotations/src/test/resources/hibernate.cfg.xml
+index a9590c1..df29d83 100644
+--- a/src/it/tutorials-5.2.18/annotations/src/test/resources/hibernate.cfg.xml
++++ b/src/it/tutorials-5.2.18/annotations/src/test/resources/hibernate.cfg.xml
+@@ -15,7 +15,7 @@
+         <!-- Database connection settings -->
+         <property name="connection.driver_class">org.h2.Driver</property>
+-        <property name="connection.url">jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE</property>
++        <property name="connection.url">jdbc:h2:${project.build.directory}/db/test;MVCC=TRUE</property>
+         <property name="connection.username">sa</property>
+         <property name="connection.password"></property>
+@@ -31,9 +31,6 @@
+         <!-- Echo all executed SQL to stdout -->
+         <property name="show_sql">true</property>
+-        <!-- Drop and re-create the database schema on startup -->
+-        <property name="hbm2ddl.auto">create</property>
+-
+         <!-- Names the annotated entity class -->
+         <mapping class="org.hibernate.tutorial.annotations.Event"/>
+diff --git a/src/it/tutorials-5.2.18/basic/pom.xml b/src/it/tutorials-5.2.18/basic/pom.xml
+index 783ac6b..032919a 100644
+--- a/src/it/tutorials-5.2.18/basic/pom.xml
++++ b/src/it/tutorials-5.2.18/basic/pom.xml
+@@ -23,6 +23,29 @@
+     <properties>
+         <!-- Skip artifact deployment -->
+         <maven.deploy.skip>true</maven.deploy.skip>
++        <hibernate-maven-plugin.version>@project.version@</hibernate-maven-plugin.version>
+     </properties>
++    <build>
++        <plugins>
++            <plugin>
++                <groupId>de.juplo</groupId>
++                <artifactId>hibernate-maven-plugin</artifactId>
++                <version>${hibernate-maven-plugin.version}</version>
++                <executions>
++                    <execution>
++                        <phase>process-test-classes</phase>
++                        <goals>
++                            <goal>create</goal>
++                        </goals>
++                    </execution>
++                </executions>
++                <configuration>
++                    <scanTestClasses>true</scanTestClasses>
++                    <format>true</format>
++                </configuration>
++            </plugin>
++        </plugins>
++    </build>
++
+ </project>
+diff --git a/src/it/tutorials-5.2.18/basic/src/test/resources/hibernate.cfg.xml b/src/it/tutorials-5.2.18/basic/src/test/resources/hibernate.cfg.xml
+index 03d3937..df55e96 100644
+--- a/src/it/tutorials-5.2.18/basic/src/test/resources/hibernate.cfg.xml
++++ b/src/it/tutorials-5.2.18/basic/src/test/resources/hibernate.cfg.xml
+@@ -15,7 +15,7 @@
+         <!-- Database connection settings -->
+         <property name="connection.driver_class">org.h2.Driver</property>
+-        <property name="connection.url">jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE</property>
++        <property name="connection.url">jdbc:h2:${project.build.directory}/db/test;MVCC=TRUE</property>
+         <property name="connection.username">sa</property>
+         <property name="connection.password"/>
+diff --git a/src/it/tutorials-5.2.18/entitymanager/pom.xml b/src/it/tutorials-5.2.18/entitymanager/pom.xml
+index d928fb6..8c13cf8 100644
+--- a/src/it/tutorials-5.2.18/entitymanager/pom.xml
++++ b/src/it/tutorials-5.2.18/entitymanager/pom.xml
+@@ -23,6 +23,7 @@
+     <properties>
+         <!-- Skip artifact deployment -->
+         <maven.deploy.skip>true</maven.deploy.skip>
++        <hibernate-maven-plugin.version>@project.version@</hibernate-maven-plugin.version>
+     </properties>
+     <dependencies>
+@@ -33,4 +34,27 @@
+         </dependency>
+     </dependencies>
++    <build>
++        <plugins>
++            <plugin>
++                <groupId>de.juplo</groupId>
++                <artifactId>hibernate-maven-plugin</artifactId>
++                <version>${hibernate-maven-plugin.version}</version>
++                <executions>
++                    <execution>
++                        <phase>process-test-classes</phase>
++                        <goals>
++                            <goal>create</goal>
++                        </goals>
++                    </execution>
++                </executions>
++                <configuration>
++                    <scanTestClasses>true</scanTestClasses>
++                    <dialect>org.hibernate.dialect.H2Dialect</dialect>
++                    <format>true</format>
++                </configuration>
++            </plugin>
++        </plugins>
++    </build>
++
+ </project>
+diff --git a/src/it/tutorials-5.2.18/entitymanager/src/test/resources/META-INF/persistence.xml b/src/it/tutorials-5.2.18/entitymanager/src/test/resources/META-INF/persistence.xml
+index 0fc9523..edf7005 100644
+--- a/src/it/tutorials-5.2.18/entitymanager/src/test/resources/META-INF/persistence.xml
++++ b/src/it/tutorials-5.2.18/entitymanager/src/test/resources/META-INF/persistence.xml
+@@ -18,7 +18,7 @@
+         <properties>
+             <property name="javax.persistence.jdbc.driver" value="org.h2.Driver" />
+-            <property name="javax.persistence.jdbc.url" value="jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE" />
++            <property name="javax.persistence.jdbc.url" value="jdbc:h2:${project.build.directory}/db/test;MVCC=TRUE" />
+             <property name="javax.persistence.jdbc.user" value="sa" />
+             <property name="javax.persistence.jdbc.password" value="" />
+diff --git a/src/it/tutorials-5.2.18/envers/pom.xml b/src/it/tutorials-5.2.18/envers/pom.xml
+index 7fa8a48..1d740ea 100644
+--- a/src/it/tutorials-5.2.18/envers/pom.xml
++++ b/src/it/tutorials-5.2.18/envers/pom.xml
+@@ -23,6 +23,7 @@
+     <properties>
+         <!-- Skip artifact deployment -->
+         <maven.deploy.skip>true</maven.deploy.skip>
++        <hibernate-maven-plugin.version>@project.version@</hibernate-maven-plugin.version>
+     </properties>
+     <dependencies>
+@@ -33,4 +34,27 @@
+         </dependency>
+     </dependencies>
++    <build>
++        <plugins>
++            <plugin>
++                <groupId>de.juplo</groupId>
++                <artifactId>hibernate-maven-plugin</artifactId>
++                <version>${hibernate-maven-plugin.version}</version>
++                <executions>
++                    <execution>
++                        <phase>process-test-classes</phase>
++                        <goals>
++                            <goal>create</goal>
++                        </goals>
++                    </execution>
++                </executions>
++                <configuration>
++                    <scanTestClasses>true</scanTestClasses>
++                    <dialect>org.hibernate.dialect.H2Dialect</dialect>
++                    <format>true</format>
++                </configuration>
++            </plugin>
++        </plugins>
++    </build>
++
+ </project>
+diff --git a/src/it/tutorials-5.2.18/envers/src/test/resources/META-INF/persistence.xml b/src/it/tutorials-5.2.18/envers/src/test/resources/META-INF/persistence.xml
+index 45a7daf..fadc2a3 100644
+--- a/src/it/tutorials-5.2.18/envers/src/test/resources/META-INF/persistence.xml
++++ b/src/it/tutorials-5.2.18/envers/src/test/resources/META-INF/persistence.xml
+@@ -18,7 +18,7 @@
+         <properties>
+             <property name="javax.persistence.jdbc.driver" value="org.h2.Driver" />
+-            <property name="javax.persistence.jdbc.url" value="jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE" />
++            <property name="javax.persistence.jdbc.url" value="jdbc:h2:${project.build.directory}/db/test;MVCC=TRUE" />
+             <property name="javax.persistence.jdbc.user" value="sa" />
+             <property name="javax.persistence.jdbc.password" value="" />
+diff --git a/src/it/tutorials-5.2.18/osgi/managed-jpa/pom.xml b/src/it/tutorials-5.2.18/osgi/managed-jpa/pom.xml
+index 55ccacd..35ad150 100644
+--- a/src/it/tutorials-5.2.18/osgi/managed-jpa/pom.xml
++++ b/src/it/tutorials-5.2.18/osgi/managed-jpa/pom.xml
+@@ -12,6 +12,10 @@
+   <version>1.0.0</version>
+   <packaging>bundle</packaging>
++  <properties>
++    <hibernate-maven-plugin.version>@project.version@</hibernate-maven-plugin.version>
++  </properties>
++
+   <dependencies>
+     <dependency>
+       <groupId>org.hibernate.javax.persistence</groupId>
+@@ -65,6 +69,23 @@
+           </instructions>
+         </configuration>
+       </plugin>
++      <plugin>
++        <groupId>de.juplo</groupId>
++        <artifactId>hibernate-maven-plugin</artifactId>
++        <version>${hibernate-maven-plugin.version}</version>
++        <executions>
++          <execution>
++            <goals>
++              <goal>create</goal>
++            </goals>
++          </execution>
++        </executions>
++        <configuration>
++          <url>jdbc:h2:mem:db_managed_jpa;MVCC=TRUE</url>
++          <format>true</format>
++          <execute>false</execute>
++        </configuration>
++      </plugin>
+     </plugins>
+   </build>
+ </project>
+diff --git a/src/it/tutorials-5.2.18/osgi/unmanaged-jpa/pom.xml b/src/it/tutorials-5.2.18/osgi/unmanaged-jpa/pom.xml
+index e45aab5..2836c5e 100644
+--- a/src/it/tutorials-5.2.18/osgi/unmanaged-jpa/pom.xml
++++ b/src/it/tutorials-5.2.18/osgi/unmanaged-jpa/pom.xml
+@@ -12,6 +12,10 @@
+   <version>1.0.0</version>
+   <packaging>bundle</packaging>
++  <properties>
++    <hibernate-maven-plugin.version>@project.version@</hibernate-maven-plugin.version>
++  </properties>
++
+   <dependencies>
+     <dependency>
+       <groupId>org.hibernate.javax.persistence</groupId>
+@@ -76,6 +80,21 @@
+           </instructions>
+         </configuration>
+       </plugin>
++      <plugin>
++        <groupId>de.juplo</groupId>
++        <artifactId>hibernate-maven-plugin</artifactId>
++        <version>${hibernate-maven-plugin.version}</version>
++        <configuration>
++          <format>true</format>
++        </configuration>
++        <executions>
++          <execution>
++            <goals>
++              <goal>create</goal>
++            </goals>
++          </execution>
++        </executions>
++      </plugin>
+     </plugins>
+   </build>
+ </project>
+diff --git a/src/it/tutorials-5.2.18/osgi/unmanaged-jpa/src/main/resources/META-INF/persistence.xml b/src/it/tutorials-5.2.18/osgi/unmanaged-jpa/src/main/resources/META-INF/persistence.xml
+index b0ebfe7..788ccab 100644
+--- a/src/it/tutorials-5.2.18/osgi/unmanaged-jpa/src/main/resources/META-INF/persistence.xml
++++ b/src/it/tutorials-5.2.18/osgi/unmanaged-jpa/src/main/resources/META-INF/persistence.xml
+@@ -15,10 +15,10 @@
+         <properties>
+             <property name="hibernate.connection.driver_class" value="org.h2.Driver"/>
+             <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect"/>
+-            <property name="hibernate.connection.url" value="jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE"/>
++            <property name="hibernate.connection.url" value="jdbc:h2:mem:db_unmanaged_jpa;DB_CLOSE_DELAY=-1;MVCC=TRUE"/>
+             <property name="hibernate.connection.username" value="sa"/>
+             <property name="hibernate.connection.password" value=""/>
+             <property name="hibernate.hbm2ddl.auto" value="create-drop"/>
+         </properties>
+     </persistence-unit>
+-</persistence>
+\ No newline at end of file
++</persistence>
+diff --git a/src/it/tutorials-5.2.18/osgi/unmanaged-native/pom.xml b/src/it/tutorials-5.2.18/osgi/unmanaged-native/pom.xml
+index d24f03d..b3e19de 100644
+--- a/src/it/tutorials-5.2.18/osgi/unmanaged-native/pom.xml
++++ b/src/it/tutorials-5.2.18/osgi/unmanaged-native/pom.xml
+@@ -12,6 +12,10 @@
+   <version>1.0.0</version>
+   <packaging>bundle</packaging>
++  <properties>
++    <hibernate-maven-plugin.version>@project.version@</hibernate-maven-plugin.version>
++  </properties>
++
+   <dependencies>
+     <dependency>
+       <groupId>org.hibernate.javax.persistence</groupId>
+@@ -84,6 +88,21 @@
+           </instructions>
+         </configuration>
+       </plugin>
++      <plugin>
++        <groupId>de.juplo</groupId>
++        <artifactId>hibernate-maven-plugin</artifactId>
++        <version>${hibernate-maven-plugin.version}</version>
++        <configuration>
++          <format>true</format>
++        </configuration>
++        <executions>
++          <execution>
++            <goals>
++              <goal>create</goal>
++            </goals>
++          </execution>
++        </executions>
++      </plugin>
+     </plugins>
+   </build>
+ </project>
+diff --git a/src/it/tutorials-5.2.18/osgi/unmanaged-native/src/main/resources/hibernate.cfg.xml b/src/it/tutorials-5.2.18/osgi/unmanaged-native/src/main/resources/hibernate.cfg.xml
+index 7f9f238..175a2bf 100644
+--- a/src/it/tutorials-5.2.18/osgi/unmanaged-native/src/main/resources/hibernate.cfg.xml
++++ b/src/it/tutorials-5.2.18/osgi/unmanaged-native/src/main/resources/hibernate.cfg.xml
+@@ -12,7 +12,7 @@
+ <hibernate-configuration>
+     <session-factory>
+         <property name="hibernate.connection.driver_class">org.h2.Driver</property>
+-        <property name="hibernate.connection.url">jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE</property>
++        <property name="hibernate.connection.url">jdbc:h2:mem:db_unmanaged_native;DB_CLOSE_DELAY=-1;MVCC=TRUE</property>
+         <property name="hibernate.connection.username">sa</property>
+         <property name="hibernate.connection.password"></property>
+         <property name="hibernate.dialect">org.hibernate.dialect.H2Dialect</property>
+diff --git a/src/it/tutorials-5.2.18/osgi/unmanaged-native/src/main/resources/pool-one.properties b/src/it/tutorials-5.2.18/osgi/unmanaged-native/src/main/resources/pool-one.properties
+index 7e1c4cf..0085971 100644
+--- a/src/it/tutorials-5.2.18/osgi/unmanaged-native/src/main/resources/pool-one.properties
++++ b/src/it/tutorials-5.2.18/osgi/unmanaged-native/src/main/resources/pool-one.properties
+@@ -5,9 +5,9 @@
+ # See the lgpl.txt file in the root directory or <http://www.gnu.org/licenses/lgpl-2.1.html>.
+ #
+ jdbc-0.proxool.alias=pool-one
+-jdbc-0.proxool.driver-url=jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE
++jdbc-0.proxool.driver-url=jdbc:h2:mem:db_unmanaged_native;DB_CLOSE_DELAY=-1;MVCC=TRUE
+ jdbc-0.proxool.driver-class=org.h2.Driver
+ jdbc-0.user=sa
+ jdbc-0.password=
+ jdbc-0.proxool.maximum-connection-count=2
+-jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE
+\ No newline at end of file
++jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE
+diff --git a/src/it/tutorials-5.2.18/pom.xml b/src/it/tutorials-5.2.18/pom.xml
+index 26d0f89..a7e9b66 100644
+--- a/src/it/tutorials-5.2.18/pom.xml
++++ b/src/it/tutorials-5.2.18/pom.xml
+@@ -70,6 +70,7 @@
+             </testResource>
+             <testResource>
+                 <directory>src/test/resources</directory>
++                <filtering>true</filtering>
+             </testResource>
+         </testResources>
+     </build>
+diff --git a/src/it/tutorials-5.2.18/schema-annotations.sql b/src/it/tutorials-5.2.18/schema-annotations.sql
+new file mode 100644
+index 0000000..48eb18e
+--- /dev/null
++++ b/src/it/tutorials-5.2.18/schema-annotations.sql
+@@ -0,0 +1,7 @@
++
++    create table EVENTS (
++        id bigint not null,
++        EVENT_DATE timestamp,
++        title varchar(255),
++        primary key (id)
++    );
+diff --git a/src/it/tutorials-5.2.18/schema-basic.sql b/src/it/tutorials-5.2.18/schema-basic.sql
+new file mode 100644
+index 0000000..c5e2c0e
+--- /dev/null
++++ b/src/it/tutorials-5.2.18/schema-basic.sql
+@@ -0,0 +1,7 @@
++
++    create table EVENTS (
++        EVENT_ID bigint not null,
++        EVENT_DATE timestamp,
++        title varchar(255),
++        primary key (EVENT_ID)
++    );
+diff --git a/src/it/tutorials-5.2.18/schema-entitymanager.sql b/src/it/tutorials-5.2.18/schema-entitymanager.sql
+new file mode 100644
+index 0000000..48eb18e
+--- /dev/null
++++ b/src/it/tutorials-5.2.18/schema-entitymanager.sql
+@@ -0,0 +1,7 @@
++
++    create table EVENTS (
++        id bigint not null,
++        EVENT_DATE timestamp,
++        title varchar(255),
++        primary key (id)
++    );
+diff --git a/src/it/tutorials-5.2.18/schema-envers.sql b/src/it/tutorials-5.2.18/schema-envers.sql
+new file mode 100644
+index 0000000..ecec80e
+--- /dev/null
++++ b/src/it/tutorials-5.2.18/schema-envers.sql
+@@ -0,0 +1,27 @@
++
++    create table EVENTS (
++        id bigint not null,
++        EVENT_DATE timestamp,
++        title varchar(255),
++        primary key (id)
++    );
++
++    create table EVENTS_AUD (
++        id bigint not null,
++        REV integer not null,
++        REVTYPE tinyint,
++        EVENT_DATE timestamp,
++        title varchar(255),
++        primary key (id, REV)
++    );
++
++    create table REVINFO (
++        REV integer generated by default as identity,
++        REVTSTMP bigint,
++        primary key (REV)
++    );
++
++    alter table EVENTS_AUD 
++        add constraint FK5cembm6xahf542q8e4h0pq2t1 
++        foreign key (REV) 
++        references REVINFO;
+diff --git a/src/it/tutorials-5.2.18/schema-osgi-managed-jpa.sql b/src/it/tutorials-5.2.18/schema-osgi-managed-jpa.sql
+new file mode 100644
+index 0000000..de92e46
+--- /dev/null
++++ b/src/it/tutorials-5.2.18/schema-osgi-managed-jpa.sql
+@@ -0,0 +1,7 @@
++create sequence hibernate_sequence start with 1 increment by 1;
++
++    create table DataPoint (
++        id bigint not null,
++        name varchar(255),
++        primary key (id)
++    );
+diff --git a/src/it/tutorials-5.2.18/schema-osgi-unmanaged-jpa.sql b/src/it/tutorials-5.2.18/schema-osgi-unmanaged-jpa.sql
+new file mode 100644
+index 0000000..de92e46
+--- /dev/null
++++ b/src/it/tutorials-5.2.18/schema-osgi-unmanaged-jpa.sql
+@@ -0,0 +1,7 @@
++create sequence hibernate_sequence start with 1 increment by 1;
++
++    create table DataPoint (
++        id bigint not null,
++        name varchar(255),
++        primary key (id)
++    );
+diff --git a/src/it/tutorials-5.2.18/schema-osgi-unmanaged-native.sql b/src/it/tutorials-5.2.18/schema-osgi-unmanaged-native.sql
+new file mode 100644
+index 0000000..d89e280
+--- /dev/null
++++ b/src/it/tutorials-5.2.18/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;
+diff --git a/src/it/tutorials-5.2.18/verify.bsh b/src/it/tutorials-5.2.18/verify.bsh
+new file mode 100644
+index 0000000..9156c4a
+--- /dev/null
++++ b/src/it/tutorials-5.2.18/verify.bsh
+@@ -0,0 +1,19 @@
++import de.juplo.test.FileComparator;
++
++
++FileComparator comparator = new FileComparator(basedir);
++
++if (!comparator.isEqual("schema-annotations.sql","annotations/target/create.sql"))
++  return false;
++if (!comparator.isEqual("schema-basic.sql","basic/target/create.sql"))
++  return false;
++if (!comparator.isEqual("schema-entitymanager.sql","entitymanager/target/create.sql"))
++  return false;
++if (!comparator.isEqual("schema-envers.sql","envers/target/create.sql"))
++  return false;
++if (!comparator.isEqual("schema-osgi-managed-jpa.sql","osgi/managed-jpa/target/create.sql"))
++  return false;
++if (!comparator.isEqual("schema-osgi-unmanaged-jpa.sql","osgi/unmanaged-jpa/target/create.sql"))
++  return false;
++if (!comparator.isEqual("schema-osgi-unmanaged-native.sql","osgi/unmanaged-native/target/create.sql"))
++  return false;