Add preferred flag to vernacular name table in checklistbank

12533
Reporter: mdoering
Assignee: mdoering
Type: Improvement
Summary: Add preferred flag to vernacular name table in checklistbank
Description: It is in the model API already, but not stored and indexed in clb right now. Needs to go into table vernacular_name and the locale sensitive methods should pick the preferred one if it exists
Priority: Major
Resolution: Fixed
Status: Closed
Created: 2012-12-12 14:41:33.154
Updated: 2013-12-09 14:01:19.448
Resolved: 2013-08-29 15:21:45.299

Author: mdoering@gbif.org
Created: 2013-08-29 15:21:45.331
Updated: 2013-08-29 15:21:45.331
        
added in new schema:
https://code.google.com/p/gbif-ecat/source/browse/checklistbank/trunk/checklistbank-mybatis-service/src/main/resources/liquibase/clb2.sql

CREATE TABLE vernacular_name (
    id serial NOT NULL,
    dataset_key uuid NOT NULL,
    usage_fk integer NOT NULL,
    name text,
    language character(2),
    preferred boolean DEFAULT false,