remove PolytomousKeyNode_LanguageString from cdm.ddl for tests

diff --git a/cdmlib-ext/src/test/resources/dbscripts/001_cdm.ddl b/cdmlib-ext/src/test/resources/dbscripts/001_cdm.ddl
index 564d86301fcfc2f86b1d2e7d5d4286fb6b408270..128ac7a251c73034d274ca8879e749e47f2bd194 100644 (file)
--- a/cdmlib-ext/src/test/resources/dbscripts/001_cdm.ddl
+++ b/cdmlib-ext/src/test/resources/dbscripts/001_cdm.ddl
@@ -3183,6 +3183,23 @@
         primary key (id, REV)
     );
     
+    create table PolytomousKeyNode_LanguageString (
+               PolytomousKeyNode_id integer not null,
+               modifyingtext_id integer not null,
+               modifyingtext_mapkey_id integer not null,
+               primary key (PolytomousKeyNode_id, modifyingtext_mapkey_id),
+               unique (modifyingtext_id)
+       )
+       
+       create table PolytomousKeyNode_LanguageString_AUD (
+               REV integer not null,
+               revtype tinyint,
+               PolytomousKeyNode_id integer not null,
+               modifyingtext_id integer not null,
+               modifyingtext_mapkey_id integer not null,
+               primary key (REV, PolytomousKeyNode_id, modifyingtext_id, modifyingtext_mapkey_id)
+       )
+    
     create table PolytomousKeyNode_PolytomousKeyNode_AUD(
        id integer not null,
         REV integer not null,
@@ -7414,6 +7431,22 @@
         foreign key (grantedauthorities_id) 
         references GrantedAuthorityImpl;
 
+    alter table PolytomousKeyNode_LanguageString 
+        add constraint FK5574E12EF05D08D4 
+        foreign key (modifyingtext_id) 
+        references LanguageString;
+
+    alter table PolytomousKeyNode_LanguageString 
+        add constraint FK5574E12EF135C42B 
+        foreign key (PolytomousKeyNode_id) 
+        references PolytomousKeyNode;
+
+    alter table PolytomousKeyNode_LanguageString 
+        add constraint FK5574E12E9682414B 
+        foreign key (modifyingtext_mapkey_id) 
+        references DefinedTermBase;
+
+
     alter table PolytomousKey_NamedArea 
         add constraint FK1C727CFF3FF8E7B2 
         foreign key (geographicalscope_id) 

diff --git a/cdmlib-io/src/test/resources/dbscripts/001_cdm.ddl b/cdmlib-io/src/test/resources/dbscripts/001_cdm.ddl
index 564d86301fcfc2f86b1d2e7d5d4286fb6b408270..128ac7a251c73034d274ca8879e749e47f2bd194 100644 (file)
--- a/cdmlib-io/src/test/resources/dbscripts/001_cdm.ddl
+++ b/cdmlib-io/src/test/resources/dbscripts/001_cdm.ddl
@@ -3183,6 +3183,23 @@
         primary key (id, REV)
     );
     
+    create table PolytomousKeyNode_LanguageString (
+               PolytomousKeyNode_id integer not null,
+               modifyingtext_id integer not null,
+               modifyingtext_mapkey_id integer not null,
+               primary key (PolytomousKeyNode_id, modifyingtext_mapkey_id),
+               unique (modifyingtext_id)
+       )
+       
+       create table PolytomousKeyNode_LanguageString_AUD (
+               REV integer not null,
+               revtype tinyint,
+               PolytomousKeyNode_id integer not null,
+               modifyingtext_id integer not null,
+               modifyingtext_mapkey_id integer not null,
+               primary key (REV, PolytomousKeyNode_id, modifyingtext_id, modifyingtext_mapkey_id)
+       )
+    
     create table PolytomousKeyNode_PolytomousKeyNode_AUD(
        id integer not null,
         REV integer not null,
@@ -7414,6 +7431,22 @@
         foreign key (grantedauthorities_id) 
         references GrantedAuthorityImpl;
 
+    alter table PolytomousKeyNode_LanguageString 
+        add constraint FK5574E12EF05D08D4 
+        foreign key (modifyingtext_id) 
+        references LanguageString;
+
+    alter table PolytomousKeyNode_LanguageString 
+        add constraint FK5574E12EF135C42B 
+        foreign key (PolytomousKeyNode_id) 
+        references PolytomousKeyNode;
+
+    alter table PolytomousKeyNode_LanguageString 
+        add constraint FK5574E12E9682414B 
+        foreign key (modifyingtext_mapkey_id) 
+        references DefinedTermBase;
+
+
     alter table PolytomousKey_NamedArea 
         add constraint FK1C727CFF3FF8E7B2 
         foreign key (geographicalscope_id) 

diff --git a/cdmlib-persistence/src/test/resources/dbscripts/001_cdm.ddl b/cdmlib-persistence/src/test/resources/dbscripts/001_cdm.ddl
index 564d86301fcfc2f86b1d2e7d5d4286fb6b408270..128ac7a251c73034d274ca8879e749e47f2bd194 100644 (file)
--- a/cdmlib-persistence/src/test/resources/dbscripts/001_cdm.ddl
+++ b/cdmlib-persistence/src/test/resources/dbscripts/001_cdm.ddl
@@ -3183,6 +3183,23 @@
         primary key (id, REV)
     );
     
+    create table PolytomousKeyNode_LanguageString (
+               PolytomousKeyNode_id integer not null,
+               modifyingtext_id integer not null,
+               modifyingtext_mapkey_id integer not null,
+               primary key (PolytomousKeyNode_id, modifyingtext_mapkey_id),
+               unique (modifyingtext_id)
+       )
+       
+       create table PolytomousKeyNode_LanguageString_AUD (
+               REV integer not null,
+               revtype tinyint,
+               PolytomousKeyNode_id integer not null,
+               modifyingtext_id integer not null,
+               modifyingtext_mapkey_id integer not null,
+               primary key (REV, PolytomousKeyNode_id, modifyingtext_id, modifyingtext_mapkey_id)
+       )
+    
     create table PolytomousKeyNode_PolytomousKeyNode_AUD(
        id integer not null,
         REV integer not null,
@@ -7414,6 +7431,22 @@
         foreign key (grantedauthorities_id) 
         references GrantedAuthorityImpl;
 
+    alter table PolytomousKeyNode_LanguageString 
+        add constraint FK5574E12EF05D08D4 
+        foreign key (modifyingtext_id) 
+        references LanguageString;
+
+    alter table PolytomousKeyNode_LanguageString 
+        add constraint FK5574E12EF135C42B 
+        foreign key (PolytomousKeyNode_id) 
+        references PolytomousKeyNode;
+
+    alter table PolytomousKeyNode_LanguageString 
+        add constraint FK5574E12E9682414B 
+        foreign key (modifyingtext_mapkey_id) 
+        references DefinedTermBase;
+
+
     alter table PolytomousKey_NamedArea 
         add constraint FK1C727CFF3FF8E7B2 
         foreign key (geographicalscope_id) 

diff --git a/cdmlib-services/src/test/resources/dbscripts/001_cdm.ddl b/cdmlib-services/src/test/resources/dbscripts/001_cdm.ddl
index 564d86301fcfc2f86b1d2e7d5d4286fb6b408270..128ac7a251c73034d274ca8879e749e47f2bd194 100644 (file)
--- a/cdmlib-services/src/test/resources/dbscripts/001_cdm.ddl
+++ b/cdmlib-services/src/test/resources/dbscripts/001_cdm.ddl
@@ -3183,6 +3183,23 @@
         primary key (id, REV)
     );
     
+    create table PolytomousKeyNode_LanguageString (
+               PolytomousKeyNode_id integer not null,
+               modifyingtext_id integer not null,
+               modifyingtext_mapkey_id integer not null,
+               primary key (PolytomousKeyNode_id, modifyingtext_mapkey_id),
+               unique (modifyingtext_id)
+       )
+       
+       create table PolytomousKeyNode_LanguageString_AUD (
+               REV integer not null,
+               revtype tinyint,
+               PolytomousKeyNode_id integer not null,
+               modifyingtext_id integer not null,
+               modifyingtext_mapkey_id integer not null,
+               primary key (REV, PolytomousKeyNode_id, modifyingtext_id, modifyingtext_mapkey_id)
+       )
+    
     create table PolytomousKeyNode_PolytomousKeyNode_AUD(
        id integer not null,
         REV integer not null,
@@ -7414,6 +7431,22 @@
         foreign key (grantedauthorities_id) 
         references GrantedAuthorityImpl;
 
+    alter table PolytomousKeyNode_LanguageString 
+        add constraint FK5574E12EF05D08D4 
+        foreign key (modifyingtext_id) 
+        references LanguageString;
+
+    alter table PolytomousKeyNode_LanguageString 
+        add constraint FK5574E12EF135C42B 
+        foreign key (PolytomousKeyNode_id) 
+        references PolytomousKeyNode;
+
+    alter table PolytomousKeyNode_LanguageString 
+        add constraint FK5574E12E9682414B 
+        foreign key (modifyingtext_mapkey_id) 
+        references DefinedTermBase;
+
+
     alter table PolytomousKey_NamedArea 
         add constraint FK1C727CFF3FF8E7B2 
         foreign key (geographicalscope_id)