Project

General

Profile

« Previous | Next » 

Revision 13539

Added by Aaron Marcuse-Kubitza over 10 years ago

schemas/public_.sql: added scrubbed_specific_epithet, scrubbed_species_binomial, which are needed by Jeff Ott's analysis (wiki.vegpath.org/Data_requests)

View differences:

trunk/schemas/vegbien.my.sql
3196 3196 
    taxonomic_status varchar(255),
3197 3197 
    scrubbed_family varchar(255),
3198 3198 
    scrubbed_genus varchar(255),
3199 
    scrubbed_morphospecies_binomial varchar(255),
3199 
    scrubbed_specific_epithet varchar(255),
3200 
    scrubbed_species_binomial varchar(255),
3200 3201 
    scrubbed_taxon_name_no_author varchar(255),
3201 3202 
    scrubbed_author varchar(255),
3203 
    scrubbed_morphospecies_binomial varchar(255),
3202 3204 
    `growthForm` varchar(255),
3203 3205 
    `reproductiveCondition` varchar(255),
3204 3206 
    threatened_bien int(11),
trunk/schemas/public_.sql
5370 5370 
    taxonomic_status text,
5371 5371 
    scrubbed_family text,
5372 5372 
    scrubbed_genus text,
5373 
    scrubbed_morphospecies_binomial text,
5373 
    scrubbed_specific_epithet text,
5374 
    scrubbed_species_binomial text,
5374 5375 
    scrubbed_taxon_name_no_author text,
5375 5376 
    scrubbed_author text,
5377 
    scrubbed_morphospecies_binomial text,
5376 5378 
    "growthForm" growthform,
5377 5379 
    "reproductiveCondition" text,
5378 5380 
    threatened_bien integer,
trunk/schemas/vegbien.sql
5370 5370 
    taxonomic_status text,
5371 5371 
    scrubbed_family text,
5372 5372 
    scrubbed_genus text,
5373 
    scrubbed_morphospecies_binomial text,
5373 
    scrubbed_specific_epithet text,
5374 
    scrubbed_species_binomial text,
5374 5375 
    scrubbed_taxon_name_no_author text,
5375 5376 
    scrubbed_author text,
5377 
    scrubbed_morphospecies_binomial text,
5376 5378 
    "growthForm" growthform,
5377 5379 
    "reproductiveCondition" text,
5378 5380 
    threatened_bien integer,

Also available in: Unified diff