From fbe4a66623bbf6ad9b90a23fd97baad0e18a7825 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Andreas=20M=C3=BCller?= Date: Tue, 30 Aug 2011 10:59:52 +0000 Subject: [PATCH] remove PolytomousKeyNode_LanguageString from cdm.ddl for tests --- .../src/test/resources/dbscripts/001_cdm.ddl | 33 +++++++++++++++++++ .../src/test/resources/dbscripts/001_cdm.ddl | 33 +++++++++++++++++++ .../src/test/resources/dbscripts/001_cdm.ddl | 33 +++++++++++++++++++ .../src/test/resources/dbscripts/001_cdm.ddl | 33 +++++++++++++++++++ 4 files changed, 132 insertions(+) diff --git a/cdmlib-ext/src/test/resources/dbscripts/001_cdm.ddl b/cdmlib-ext/src/test/resources/dbscripts/001_cdm.ddl index 564d86301f..128ac7a251 100644 --- 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 564d86301f..128ac7a251 100644 --- 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 564d86301f..128ac7a251 100644 --- 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 564d86301f..128ac7a251 100644 --- 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) -- 2.34.1