added PolytomousKey_TaxonBase to persistence .dll

[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 6477958e4ac13df5b5109f8ebb37190b0437746e..d064a6524bddc81a2ed7a9a41ed89d50705902c9 100644 (file)
--- a/cdmlib-persistence/src/test/resources/dbscripts/001_cdm.ddl
+++ b/cdmlib-persistence/src/test/resources/dbscripts/001_cdm.ddl
@@ -3126,6 +3126,20 @@
         primary key (REV, polytomousKey_id, taxon_id)
     );
     
+    create table PolytomousKey_TaxonBase (
+        polytomousKey_id integer not null,
+        coveredtaxa_id integer not null,
+        primary key (polytomousKey_id, coveredtaxa_id)
+    );
+
+    create table PolytomousKey_TaxonBase_AUD (
+        REV integer not null,
+        polytomousKey_id integer not null,
+        coveredtaxa_id integer not null,
+        revtype tinyint,
+        primary key (REV, polytomousKey_id, coveredtaxa_id)
+    );
+    
         
     create table PolytomousKeyNode (
         id integer not null,