added PolytomousKey_TaxonBase to persistence .dll
authorAndreas Müller <a.mueller@bgbm.org>
Mon, 6 Dec 2010 17:12:31 +0000 (17:12 +0000)
committerAndreas Müller <a.mueller@bgbm.org>
Mon, 6 Dec 2010 17:12:31 +0000 (17:12 +0000)
cdmlib-persistence/src/test/resources/dbscripts/001_cdm.ddl

index 6477958e4ac13df5b5109f8ebb37190b0437746e..d064a6524bddc81a2ed7a9a41ed89d50705902c9 100644 (file)
         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,