Project

General

Profile

« Previous | Next » 

Revision 5054

Moved tnrs table from public (schemas/vegbien.sql) to its own TNRS schema, which is created by a new .TNRS datasource. Note that .TNRS is included in the automated testing, but not yet in the import.

View differences:

vegbien.my.sql
2633 2633

  
2634 2634

  
2635 2635
--
2636
-- Name: tnrs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2637
--
2638

  
2639
CREATE TABLE tnrs (
2640
    `Name_number` text,
2641
    `Name_submitted` text,
2642
    `Overall_score` text,
2643
    `Name_matched` text,
2644
    `Name_matched_rank` text,
2645
    `Name_score` text,
2646
    `Name_matched_author` text,
2647
    `Name_matched_url` text,
2648
    `Author_matched` text,
2649
    `Author_score` text,
2650
    `Family_matched` text,
2651
    `Family_score` text,
2652
    `Name_matched_accepted_family` text,
2653
    `Genus_matched` text,
2654
    `Genus_score` text,
2655
    `Specific_epithet_matched` text,
2656
    `Specific_epithet_score` text,
2657
    `Infraspecific_rank` text,
2658
    `Infraspecific_epithet_matched` text,
2659
    `Infraspecific_epithet_score` text,
2660
    `Infraspecific_rank_2` text,
2661
    `Infraspecific_epithet_2_matched` text,
2662
    `Infraspecific_epithet_2_score` text,
2663
    `Annotations` text,
2664
    `Unmatched_terms` text,
2665
    `Taxonomic_status` text,
2666
    `Accepted_name` text,
2667
    `Accepted_name_author` text,
2668
    `Accepted_name_rank` text,
2669
    `Accepted_name_url` text,
2670
    `Accepted_name_species` text,
2671
    `Accepted_name_family` text,
2672
    `Selected` text,
2673
    `Source` text,
2674
    `Warnings` text,
2675
    `Accepted_name_lsid` text
2676
);
2677

  
2678

  
2679
--
2680 2636
-- Name: trait; Type: TABLE; Schema: public; Owner: -; Tablespace: 
2681 2637
--
2682 2638

  

Also available in: Unified diff