Further model changes for DescriptionElementBase and DescriptionElementSource

[cdmlib.git] / cdmlib-persistence / src / test / resources / dbscripts / 001_cdm.ddl

diff --git a/cdmlib-persistence/src/test/resources/dbscripts/001_cdm.ddl b/cdmlib-persistence/src/test/resources/dbscripts/001_cdm.ddl
index 7d33dc83e795bba3a81251c6ec46d03039fdb60f..e500b082e7901d89fd9ab4afbcf9276a137c0c6f 100644 (file)
--- a/cdmlib-persistence/src/test/resources/dbscripts/001_cdm.ddl
+++ b/cdmlib-persistence/src/test/resources/dbscripts/001_cdm.ddl
@@ -2536,7 +2536,8 @@ create table DefinedTermBase_MeasurementUnit (
         updated timestamp,
         citationmicroreference varchar(255),
         originalnamestring varchar(255),
-        idinsource varchar(255),
+        nameUsedInSource_id integer,
+               idinsource varchar(255),
         idnamespace varchar(255),
         sourcedObj_type varchar(255),
         sourcedObj_id integer not null,
@@ -2557,7 +2558,8 @@ create table DefinedTermBase_MeasurementUnit (
         updated timestamp,
         citationmicroreference varchar(255),
         originalnamestring varchar(255),
-        idinsource varchar(255),
+        nameUsedInSource_id integer,
+               idinsource varchar(255),
         idnamespace varchar(255),
         createdby_id integer,
         updatedby_id integer,
@@ -6743,6 +6745,11 @@ create table DefinedTermBase_MeasurementUnit (
         foreign key (citation_id) 
         references Reference;
 
+    alter table OriginalSourceBase 
+        add constraint FK820A492C9803E12F 
+        foreign key (nameUsedInSource_id) 
+        references TaxonNameBase;
+
     alter table OriginalSourceBase 
         add constraint FK229A496CBC5DA539 
         foreign key (updatedby_id)