Project

General

Profile

Revision 5eaab3bf

ID5eaab3bfcc0e1851a508b51dfd5c7321d925dd68
Parent c41c3457
Child b5e55a3d

Added by Andreas Müller about 2 months ago

ref #6581 fully remove nomenclaturalReference and nomenclaturalMicroReference fields from TaxonName

View differences:

cdmlib-test/src/main/resources/dbscripts/001-cdm.h2.sql
5095 5095
        NAMEAPPROBATION varchar(255),
5096 5096
        NAMECACHE varchar(255),
5097 5097
        NAMETYPE varchar(15),
5098
        NOMENCLATURALMICROREFERENCE varchar(255),
5099 5098
        ORIGINALPUBLICATIONYEAR integer,
5100 5099
        PARSINGPROBLEM integer not null,
5101 5100
        PROBLEMENDS integer not null,
......
5116 5115
        HOMOTYPICALGROUP_ID integer,
5117 5116
        INBASIONYMAUTHORSHIP_ID integer,
5118 5117
        INCOMBINATIONAUTHORSHIP_ID integer,
5119
        NOMENCLATURALREFERENCE_ID integer,
5120 5118
        NOMENCLATURALSOURCE_ID integer,
5121 5119
        RANK_ID integer,
5122 5120
        primary key (ID)
......
5166 5164
        NAMEAPPROBATION varchar(255),
5167 5165
        NAMECACHE varchar(255),
5168 5166
        NAMETYPE varchar(15),
5169
        NOMENCLATURALMICROREFERENCE varchar(255),
5170 5167
        ORIGINALPUBLICATIONYEAR integer,
5171 5168
        PARSINGPROBLEM integer,
5172 5169
        PROBLEMENDS integer,
......
5187 5184
        HOMOTYPICALGROUP_ID integer,
5188 5185
        INBASIONYMAUTHORSHIP_ID integer,
5189 5186
        INCOMBINATIONAUTHORSHIP_ID integer,
5190
        NOMENCLATURALREFERENCE_ID integer,
5191 5187
        NOMENCLATURALSOURCE_ID integer,
5192 5188
        RANK_ID integer,
5193 5189
        primary key (ID, REV)
......
11289 11285
        references PUBLIC.AGENTBASE;
11290 11286

  
11291 11287
    alter table PUBLIC.TAXONNAME 
11292
        add constraint FK1dmy5xlaq1fn7omo0dom0kpbr 
11293
        foreign key (NOMENCLATURALREFERENCE_ID) 
11294
        references PUBLIC.REFERENCE;
11295

  
11296
    alter table PUBLIC.TAXONNAME 
11297 11288
        add constraint FKle80w71xca5aftjkqxfvgjdq6 
11298 11289
        foreign key (NOMENCLATURALSOURCE_ID) 
11299 11290
        references PUBLIC.ORIGINALSOURCEBASE;

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)