Project

General

Profile

« Previous | Next » 

Revision 5474

inputs/test_taxonomic_names/_scrub/public.sql: Regenerated with schema changes

View differences:

inputs/test_taxonomic_names/_scrub/public.sql
451 451
ALTER FUNCTION public.taxonconcept_1_matched_concept_min_fit() OWNER TO bien;
452 452

  
453 453
--
454
-- Name: taxonconcept_2_propagate_accepted_concept_id(); Type: FUNCTION; Schema: public; Owner: bien
455
--
456

  
457
CREATE FUNCTION taxonconcept_2_propagate_accepted_concept_id() RETURNS trigger
458
    LANGUAGE plpgsql
459
    AS $$
460
BEGIN
461
    IF new.matched_concept_id IS NOT NULL THEN
462
        IF new.matched_concept_id = new.taxonconcept_id THEN -- self-reference
463
            new.accepted_concept_id = new.taxonconcept_id;-- make self-reference
464
        ELSE -- propagate from matched concept
465
            new.accepted_concept_id = (
466
                SELECT accepted_concept_id
467
                FROM taxonconcept
468
                WHERE taxonconcept_id = new.matched_concept_id
469
            );
470
        END IF;
471
    END IF;
472
    RETURN new;
473
END;
474
$$;
475

  
476

  
477
ALTER FUNCTION public.taxonconcept_2_propagate_accepted_concept_id() OWNER TO bien;
478

  
479
--
454 480
-- Name: taxonconcept_update_ancestors(); Type: FUNCTION; Schema: public; Owner: bien
455 481
--
456 482

  
......
1214 1240
CREATE TABLE taxonconcept (
1215 1241
    taxonconcept_id integer NOT NULL,
1216 1242
    creator_id integer NOT NULL,
1243
    sourceaccessioncode text,
1217 1244
    creationdate timestamp with time zone,
1218 1245
    accepted_concept_id integer,
1219 1246
    matched_concept_id integer,
......
1232 1259
    description text,
1233 1260
    accessioncode text,
1234 1261
    CONSTRAINT taxonconcept_matched_concept_fit_fraction_range CHECK (((matched_concept_fit_fraction >= (0)::double precision) AND (matched_concept_fit_fraction <= (1)::double precision))),
1235
    CONSTRAINT taxonconcept_required_key CHECK ((((((taxonname IS NOT NULL) OR (identifyingtaxonomicname IS NOT NULL)) OR (taxonomicname IS NOT NULL)) OR (taxonomicnamewithauthor IS NOT NULL)) OR ((parent_id IS NOT NULL) AND ((creationdate IS NOT NULL) OR (author IS NOT NULL)))))
1262
    CONSTRAINT taxonconcept_required_key CHECK (((((((sourceaccessioncode IS NOT NULL) OR (taxonname IS NOT NULL)) OR (identifyingtaxonomicname IS NOT NULL)) OR (taxonomicname IS NOT NULL)) OR (taxonomicnamewithauthor IS NOT NULL)) OR ((parent_id IS NOT NULL) AND ((creationdate IS NOT NULL) OR (author IS NOT NULL)))))
1236 1263
);
1237 1264

  
1238 1265

  
......
1261 1288

  
1262 1289

  
1263 1290
--
1291
-- Name: COLUMN taxonconcept.sourceaccessioncode; Type: COMMENT; Schema: public; Owner: bien
1292
--
1293

  
1294
COMMENT ON COLUMN taxonconcept.sourceaccessioncode IS 'The datasource''s identifier for the taxonconcept.';
1295

  
1296

  
1297
--
1264 1298
-- Name: COLUMN taxonconcept.creationdate; Type: COMMENT; Schema: public; Owner: bien
1265 1299
--
1266 1300

  
......
1268 1302

  
1269 1303

  
1270 1304
--
1305
-- Name: COLUMN taxonconcept.accepted_concept_id; Type: COMMENT; Schema: public; Owner: bien
1306
--
1307

  
1308
COMMENT ON COLUMN taxonconcept.accepted_concept_id IS 'The accepted synonym of the taxonconcept.';
1309

  
1310

  
1311
--
1271 1312
-- Name: COLUMN taxonconcept.matched_concept_id; Type: COMMENT; Schema: public; Owner: bien
1272 1313
--
1273 1314

  
......
4773 4814
-- Data for Name: taxonconcept; Type: TABLE DATA; Schema: public; Owner: bien
4774 4815
--
4775 4816

  
4776
COPY taxonconcept (taxonconcept_id, creator_id, creationdate, accepted_concept_id, matched_concept_id, matched_concept_fit_fraction, parent_id, taxonname, rank, verbatimrank, identifyingtaxonomicname, taxonomicname, author, taxonomicnamewithauthor, family, genus, species, description, accessioncode) FROM stdin;
4777
2	1	\N	\N	\N	\N	\N	Poaceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4778
4	1	\N	\N	\N	\N	2	Poa	genus	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4779
6	1	\N	\N	\N	\N	4	annua	species	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4780
18	1	\N	\N	18	\N	6	\N	species	species	Poa annua L.	Poa annua	L.	\N	Poaceae	Poa	annua	\N	\N
4781
54	1	\N	\N	\N	\N	6	annua	variety	variety	\N	\N	\N	\N	\N	\N	\N	\N	\N
4782
56	1	\N	\N	56	\N	54	\N	variety	variety	Poa annua var. annua	Poa annua var. annua	\N	\N	Poaceae	Poa	annua	\N	\N
4783
82	1	\N	\N	\N	\N	4	infirma	species	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4784
94	1	\N	\N	94	\N	82	\N	species	species	Poa infirma Kunth	Poa infirma	Kunth	\N	Poaceae	Poa	infirma	\N	\N
4785
132	1	\N	\N	132	\N	\N	\N	family	family	Asteraceae	Asteraceae	\N	\N	\N	\N	\N	\N	\N
4786
152	1	\N	\N	132	1	\N	Bercht. & J. Presl	\N	\N	Asteraceae Bercht. & J. Presl	Asteraceae	\N	\N	Asteraceae	\N	\N	\N	\N
4787
154	1	\N	\N	\N	\N	\N	Compositae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4788
172	1	\N	\N	\N	\N	\N	Asteraceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4789
170	1	\N	\N	152	\N	154	\N	family	family	Compositae Giseke	Compositae	Giseke	\N	Compositae	\N	\N	\N	\N
4790
190	1	\N	\N	170	1	\N	indet. sp.1	\N	\N	Compositae indet. sp.1	Compositae	\N	\N	Compositae	\N	\N	\N	\N
4791
192	1	\N	\N	\N	\N	\N	Fabaceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4792
208	1	\N	\N	208	\N	192	\N	family	family	Fabaceae Lindl.	Fabaceae	Lindl.	\N	Fabaceae	\N	\N	\N	\N
4793
228	1	\N	\N	208	1	\N	Boyle#6500	\N	\N	Fabaceae Boyle#6500	Fabaceae	\N	\N	Fabaceae	\N	\N	\N	\N
4794
232	1	\N	\N	\N	\N	192	Inga	genus	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4795
246	1	\N	\N	246	\N	232	\N	genus	genus	Inga Mill.	Inga	Mill.	\N	Fabaceae	Inga	\N	\N	\N
4796
266	1	\N	\N	246	1	\N	"fuzzy leaf"	\N	\N	Fabaceae Inga "fuzzy leaf"	Inga	\N	\N	Fabaceae	Inga	\N	\N	\N
4797
304	1	\N	\N	246	1	\N	sp.3	\N	\N	Fabaceae Inga sp.3	Inga	\N	\N	Fabaceae	Inga	\N	\N	\N
4798
342	1	\N	\N	208	1	\N	unknown #2	\N	\N	Fabaceae unknown #2	Fabaceae	\N	\N	Fabaceae	\N	\N	\N	\N
4799
380	1	\N	\N	18	1	\N	\N	\N	\N	Poa annua	Poa annua	\N	\N	\N	Poa	annua	\N	\N
4800
396	1	\N	\N	\N	\N	6	lanuginosa	forma	forma	\N	\N	\N	\N	\N	\N	\N	\N	\N
4801
398	1	\N	\N	56	\N	396	\N	forma	forma	Poa annua fo. lanuginosa Sennen	Poa annua fo. lanuginosa	Sennen	\N	Poaceae	Poa	annua	\N	\N
4802
418	1	\N	\N	398	1	\N	\N	\N	fo.	Poa annua fo. lanuginosa	Poa annua fo. lanuginosa	\N	\N	\N	Poa	annua	\N	\N
4803
434	1	\N	\N	\N	\N	6	exilis	subspecies	subspecies	\N	\N	\N	\N	\N	\N	\N	\N	\N
4804
436	1	\N	\N	94	\N	434	\N	subspecies	subspecies	Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.	Poa annua subsp. exilis	(Tomm. ex Freyn) Asch. & Graebn.	\N	Poaceae	Poa	annua	\N	\N
4805
456	1	\N	\N	436	1	\N	\N	\N	subsp.	Poa annua ssp. exilis	Poa annua subsp. exilis	\N	\N	\N	Poa	annua	\N	\N
4806
494	1	\N	\N	436	1	\N	\N	\N	subsp.	Poa annua subsp. exilis	Poa annua subsp. exilis	\N	\N	\N	Poa	annua	\N	\N
4807
510	1	\N	\N	\N	\N	6	minima	subvariety	subvariety	\N	\N	\N	\N	\N	\N	\N	\N	\N
4808
512	1	\N	\N	512	\N	510	\N	subvariety	subvariety	Poa annua subvar. minima (Schur) Asch. & Graebn.	Poa annua subvar. minima	(Schur) Asch. & Graebn.	\N	Poaceae	Poa	annua	\N	\N
4809
532	1	\N	\N	512	1	\N	\N	\N	subvar.	Poa annua subvar. minima	Poa annua subvar. minima	\N	\N	\N	Poa	annua	\N	\N
4810
548	1	\N	\N	\N	\N	6	eriolepis	variety	variety	\N	\N	\N	\N	\N	\N	\N	\N	\N
4811
550	1	\N	\N	18	\N	548	\N	variety	variety	Poa annua var. eriolepis E. Desv.	Poa annua var. eriolepis	E. Desv.	\N	Poaceae	Poa	annua	\N	\N
4812
570	1	\N	\N	550	1	\N	\N	\N	var.	Poa annua var. eriolepis	Poa annua var. eriolepis	\N	\N	\N	Poa	annua	\N	\N
4813
572	1	\N	\N	\N	\N	\N	Caryophyllaceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4814
574	1	\N	\N	\N	\N	572	Silene	genus	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4815
576	1	\N	\N	\N	\N	574	scouleri	species	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4816
586	1	\N	\N	\N	\N	576	pringlei	subspecies	subspecies	\N	\N	\N	\N	\N	\N	\N	\N	\N
4817
588	1	\N	\N	588	\N	586	\N	subspecies	subspecies	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	Silene scouleri subsp. pringlei	(S. Watson) C.L. Hitchc. & Maguire	\N	Caryophyllaceae	Silene	scouleri	\N	\N
4818
608	1	\N	\N	588	1	\N	var. grisea	\N	subsp.	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	Silene scouleri subsp. pringlei	\N	\N	\N	Silene	scouleri	\N	\N
4819
646	1	\N	\N	588	1	\N	var. grisea	\N	subsp.	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	Silene scouleri subsp. pringlei	\N	\N	\N	Silene	scouleri	\N	\N
4820
664	1	\N	\N	\N	\N	\N	\N	\N	\N	No suitable matches found.	No suitable matches found.	\N	\N	\N	\N	\N	\N	\N
4821
684	1	\N	\N	\N	\N	\N	\N	\N	\N	Fam_indet. Boyle#6501	No suitable matches found.	\N	\N	\N	\N	\N	\N	\N
4822
725	2	\N	\N	380	\N	\N	\N	\N	\N	\N	Poa annua	\N	\N	\N	\N	\N	\N	\N
4823
728	2	\N	\N	18	\N	\N	\N	\N	\N	\N	Poa annua L.	\N	\N	\N	\N	\N	\N	\N
4824
731	2	\N	\N	570	\N	\N	\N	\N	\N	\N	Poa annua var. eriolepis	\N	\N	\N	\N	\N	\N	\N
4825
734	2	\N	\N	494	\N	\N	\N	\N	\N	\N	Poa annua subsp. exilis	\N	\N	\N	\N	\N	\N	\N
4826
737	2	\N	\N	456	\N	\N	\N	\N	\N	\N	Poa annua ssp. exilis	\N	\N	\N	\N	\N	\N	\N
4827
740	2	\N	\N	532	\N	\N	\N	\N	\N	\N	Poa annua subvar. minima	\N	\N	\N	\N	\N	\N	\N
4828
743	2	\N	\N	418	\N	\N	\N	\N	\N	\N	Poa annua fo. lanuginosa	\N	\N	\N	\N	\N	\N	\N
4829
746	2	\N	\N	646	\N	\N	\N	\N	\N	\N	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	\N	\N	\N	\N	\N	\N	\N
4830
749	2	\N	\N	608	\N	\N	\N	\N	\N	\N	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	\N	\N	\N	\N	\N	\N	\N
4831
752	2	\N	\N	304	\N	\N	\N	\N	\N	\N	Fabaceae Inga sp.3	\N	\N	\N	\N	\N	\N	\N
4832
755	2	\N	\N	266	\N	\N	\N	\N	\N	\N	Fabaceae Inga "fuzzy leaf"	\N	\N	\N	\N	\N	\N	\N
4833
758	2	\N	\N	342	\N	\N	\N	\N	\N	\N	Fabaceae unknown #2	\N	\N	\N	\N	\N	\N	\N
4834
761	2	\N	\N	228	\N	\N	\N	\N	\N	\N	Fabaceae Boyle#6500	\N	\N	\N	\N	\N	\N	\N
4835
764	2	\N	\N	684	\N	\N	\N	\N	\N	\N	Fam_indet. Boyle#6501	\N	\N	\N	\N	\N	\N	\N
4836
767	2	\N	\N	190	\N	\N	\N	\N	\N	\N	Compositae indet. sp.1	\N	\N	\N	\N	\N	\N	\N
4817
COPY taxonconcept (taxonconcept_id, creator_id, sourceaccessioncode, creationdate, accepted_concept_id, matched_concept_id, matched_concept_fit_fraction, parent_id, taxonname, rank, verbatimrank, identifyingtaxonomicname, taxonomicname, author, taxonomicnamewithauthor, family, genus, species, description, accessioncode) FROM stdin;
4818
2	1	\N	\N	\N	\N	\N	\N	Poaceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4819
4	1	\N	\N	\N	\N	\N	2	Poa	genus	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4820
6	1	\N	\N	\N	\N	\N	4	annua	species	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4821
18	1	\N	\N	18	18	\N	6	\N	species	species	Poa annua L.	Poa annua	L.	\N	Poaceae	Poa	annua	\N	\N
4822
54	1	\N	\N	\N	\N	\N	6	annua	variety	variety	\N	\N	\N	\N	\N	\N	\N	\N	\N
4823
56	1	\N	\N	56	56	\N	54	\N	variety	variety	Poa annua var. annua	Poa annua var. annua	\N	\N	Poaceae	Poa	annua	\N	\N
4824
82	1	\N	\N	\N	\N	\N	4	infirma	species	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4825
94	1	\N	\N	94	94	\N	82	\N	species	species	Poa infirma Kunth	Poa infirma	Kunth	\N	Poaceae	Poa	infirma	\N	\N
4826
132	1	\N	\N	132	132	\N	\N	\N	family	family	Asteraceae	Asteraceae	\N	\N	\N	\N	\N	\N	\N
4827
152	1	\N	\N	132	132	1	\N	Bercht. & J. Presl	\N	\N	Asteraceae Bercht. & J. Presl	Asteraceae	\N	\N	Asteraceae	\N	\N	\N	\N
4828
154	1	\N	\N	\N	\N	\N	\N	Compositae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4829
172	1	\N	\N	\N	\N	\N	\N	Asteraceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4830
170	1	\N	\N	132	152	\N	154	\N	family	family	Compositae Giseke	Compositae	Giseke	\N	Compositae	\N	\N	\N	\N
4831
190	1	\N	\N	132	170	1	\N	indet. sp.1	\N	\N	Compositae indet. sp.1	Compositae	\N	\N	Compositae	\N	\N	\N	\N
4832
192	1	\N	\N	\N	\N	\N	\N	Fabaceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4833
208	1	\N	\N	208	208	\N	192	\N	family	family	Fabaceae Lindl.	Fabaceae	Lindl.	\N	Fabaceae	\N	\N	\N	\N
4834
228	1	\N	\N	208	208	1	\N	Boyle#6500	\N	\N	Fabaceae Boyle#6500	Fabaceae	\N	\N	Fabaceae	\N	\N	\N	\N
4835
232	1	\N	\N	\N	\N	\N	192	Inga	genus	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4836
246	1	\N	\N	246	246	\N	232	\N	genus	genus	Inga Mill.	Inga	Mill.	\N	Fabaceae	Inga	\N	\N	\N
4837
266	1	\N	\N	246	246	1	\N	"fuzzy leaf"	\N	\N	Fabaceae Inga "fuzzy leaf"	Inga	\N	\N	Fabaceae	Inga	\N	\N	\N
4838
304	1	\N	\N	246	246	1	\N	sp.3	\N	\N	Fabaceae Inga sp.3	Inga	\N	\N	Fabaceae	Inga	\N	\N	\N
4839
342	1	\N	\N	208	208	1	\N	unknown #2	\N	\N	Fabaceae unknown #2	Fabaceae	\N	\N	Fabaceae	\N	\N	\N	\N
4840
380	1	\N	\N	18	18	1	\N	\N	\N	\N	Poa annua	Poa annua	\N	\N	\N	Poa	annua	\N	\N
4841
396	1	\N	\N	\N	\N	\N	6	lanuginosa	forma	forma	\N	\N	\N	\N	\N	\N	\N	\N	\N
4842
398	1	\N	\N	56	56	\N	396	\N	forma	forma	Poa annua fo. lanuginosa Sennen	Poa annua fo. lanuginosa	Sennen	\N	Poaceae	Poa	annua	\N	\N
4843
418	1	\N	\N	56	398	1	\N	\N	\N	fo.	Poa annua fo. lanuginosa	Poa annua fo. lanuginosa	\N	\N	\N	Poa	annua	\N	\N
4844
434	1	\N	\N	\N	\N	\N	6	exilis	subspecies	subspecies	\N	\N	\N	\N	\N	\N	\N	\N	\N
4845
436	1	\N	\N	94	94	\N	434	\N	subspecies	subspecies	Poa annua subsp. exilis (Tomm. ex Freyn) Asch. & Graebn.	Poa annua subsp. exilis	(Tomm. ex Freyn) Asch. & Graebn.	\N	Poaceae	Poa	annua	\N	\N
4846
456	1	\N	\N	94	436	1	\N	\N	\N	subsp.	Poa annua ssp. exilis	Poa annua subsp. exilis	\N	\N	\N	Poa	annua	\N	\N
4847
494	1	\N	\N	94	436	1	\N	\N	\N	subsp.	Poa annua subsp. exilis	Poa annua subsp. exilis	\N	\N	\N	Poa	annua	\N	\N
4848
510	1	\N	\N	\N	\N	\N	6	minima	subvariety	subvariety	\N	\N	\N	\N	\N	\N	\N	\N	\N
4849
512	1	\N	\N	512	512	\N	510	\N	subvariety	subvariety	Poa annua subvar. minima (Schur) Asch. & Graebn.	Poa annua subvar. minima	(Schur) Asch. & Graebn.	\N	Poaceae	Poa	annua	\N	\N
4850
532	1	\N	\N	512	512	1	\N	\N	\N	subvar.	Poa annua subvar. minima	Poa annua subvar. minima	\N	\N	\N	Poa	annua	\N	\N
4851
548	1	\N	\N	\N	\N	\N	6	eriolepis	variety	variety	\N	\N	\N	\N	\N	\N	\N	\N	\N
4852
550	1	\N	\N	18	18	\N	548	\N	variety	variety	Poa annua var. eriolepis E. Desv.	Poa annua var. eriolepis	E. Desv.	\N	Poaceae	Poa	annua	\N	\N
4853
570	1	\N	\N	18	550	1	\N	\N	\N	var.	Poa annua var. eriolepis	Poa annua var. eriolepis	\N	\N	\N	Poa	annua	\N	\N
4854
572	1	\N	\N	\N	\N	\N	\N	Caryophyllaceae	family	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4855
574	1	\N	\N	\N	\N	\N	572	Silene	genus	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4856
576	1	\N	\N	\N	\N	\N	574	scouleri	species	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
4857
586	1	\N	\N	\N	\N	\N	576	pringlei	subspecies	subspecies	\N	\N	\N	\N	\N	\N	\N	\N	\N
4858
588	1	\N	\N	588	588	\N	586	\N	subspecies	subspecies	Silene scouleri subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire	Silene scouleri subsp. pringlei	(S. Watson) C.L. Hitchc. & Maguire	\N	Caryophyllaceae	Silene	scouleri	\N	\N
4859
608	1	\N	\N	588	588	1	\N	var. grisea	\N	subsp.	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	Silene scouleri subsp. pringlei	\N	\N	\N	Silene	scouleri	\N	\N
4860
646	1	\N	\N	588	588	1	\N	var. grisea	\N	subsp.	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	Silene scouleri subsp. pringlei	\N	\N	\N	Silene	scouleri	\N	\N
4861
664	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	No suitable matches found.	No suitable matches found.	\N	\N	\N	\N	\N	\N	\N
4862
684	1	\N	\N	\N	\N	\N	\N	\N	\N	\N	Fam_indet. Boyle#6501	No suitable matches found.	\N	\N	\N	\N	\N	\N	\N
4863
725	2	\N	\N	18	380	\N	\N	\N	\N	\N	\N	Poa annua	\N	\N	\N	\N	\N	\N	\N
4864
728	2	\N	\N	18	18	\N	\N	\N	\N	\N	\N	Poa annua L.	\N	\N	\N	\N	\N	\N	\N
4865
731	2	\N	\N	18	570	\N	\N	\N	\N	\N	\N	Poa annua var. eriolepis	\N	\N	\N	\N	\N	\N	\N
4866
734	2	\N	\N	94	494	\N	\N	\N	\N	\N	\N	Poa annua subsp. exilis	\N	\N	\N	\N	\N	\N	\N
4867
737	2	\N	\N	94	456	\N	\N	\N	\N	\N	\N	Poa annua ssp. exilis	\N	\N	\N	\N	\N	\N	\N
4868
740	2	\N	\N	512	532	\N	\N	\N	\N	\N	\N	Poa annua subvar. minima	\N	\N	\N	\N	\N	\N	\N
4869
743	2	\N	\N	56	418	\N	\N	\N	\N	\N	\N	Poa annua fo. lanuginosa	\N	\N	\N	\N	\N	\N	\N
4870
746	2	\N	\N	588	646	\N	\N	\N	\N	\N	\N	Silene scouleri subsp. pringlei var. grisea C.L. Hitchc. & Maguire	\N	\N	\N	\N	\N	\N	\N
4871
749	2	\N	\N	588	608	\N	\N	\N	\N	\N	\N	Silene scouleri Hook. subsp. pringlei (S. Watson) C.L. Hitchc. & Maguire var. grisea C.L. Hitchc. & Maguire	\N	\N	\N	\N	\N	\N	\N
4872
752	2	\N	\N	246	304	\N	\N	\N	\N	\N	\N	Fabaceae Inga sp.3	\N	\N	\N	\N	\N	\N	\N
4873
755	2	\N	\N	246	266	\N	\N	\N	\N	\N	\N	Fabaceae Inga "fuzzy leaf"	\N	\N	\N	\N	\N	\N	\N
4874
758	2	\N	\N	208	342	\N	\N	\N	\N	\N	\N	Fabaceae unknown #2	\N	\N	\N	\N	\N	\N	\N
4875
761	2	\N	\N	208	228	\N	\N	\N	\N	\N	\N	Fabaceae Boyle#6500	\N	\N	\N	\N	\N	\N	\N
4876
764	2	\N	\N	\N	684	\N	\N	\N	\N	\N	\N	Fam_indet. Boyle#6501	\N	\N	\N	\N	\N	\N	\N
4877
767	2	\N	\N	132	190	\N	\N	\N	\N	\N	\N	Compositae indet. sp.1	\N	\N	\N	\N	\N	\N	\N
4837 4878
\.
4838 4879

  
4839 4880

  
......
6002 6043

  
6003 6044

  
6004 6045
--
6046
-- Name: taxonconcept_1_unique_sourceaccessioncode; Type: INDEX; Schema: public; Owner: bien; Tablespace: 
6047
--
6048

  
6049
CREATE UNIQUE INDEX taxonconcept_1_unique_sourceaccessioncode ON taxonconcept USING btree (creator_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
6050

  
6051

  
6052
--
6005 6053
-- Name: taxonconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: bien; Tablespace: 
6006 6054
--
6007 6055

  
......
6012 6060
-- Name: taxonconcept_unique; Type: INDEX; Schema: public; Owner: bien; Tablespace: 
6013 6061
--
6014 6062

  
6015
CREATE UNIQUE INDEX taxonconcept_unique ON taxonconcept USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(taxonname, '\\N'::text)), (COALESCE(rank, 'unknown'::taxonrank)), creator_id, (COALESCE(creationdate, 'infinity'::timestamp with time zone)), (COALESCE(identifyingtaxonomicname, '\\N'::text)), (COALESCE(taxonomicname, '\\N'::text)), (COALESCE(author, '\\N'::text)), (COALESCE(taxonomicnamewithauthor, '\\N'::text)));
6063
CREATE UNIQUE INDEX taxonconcept_unique ON taxonconcept USING btree ((COALESCE(parent_id, 2147483647)), (COALESCE(taxonname, '\\N'::text)), (COALESCE(rank, 'unknown'::taxonrank)), creator_id, (COALESCE(sourceaccessioncode, '\\N'::text)), (COALESCE(creationdate, 'infinity'::timestamp with time zone)), (COALESCE(identifyingtaxonomicname, '\\N'::text)), (COALESCE(taxonomicname, '\\N'::text)), (COALESCE(author, '\\N'::text)), (COALESCE(taxonomicnamewithauthor, '\\N'::text)));
6016 6064

  
6017 6065

  
6018 6066
--
......
6114 6162

  
6115 6163

  
6116 6164
--
6165
-- Name: taxonconcept_2_propagate_accepted_concept_id; Type: TRIGGER; Schema: public; Owner: bien
6166
--
6167

  
6168
CREATE TRIGGER taxonconcept_2_propagate_accepted_concept_id BEFORE INSERT OR UPDATE ON taxonconcept FOR EACH ROW EXECUTE PROCEDURE taxonconcept_2_propagate_accepted_concept_id();
6169

  
6170

  
6171
--
6117 6172
-- Name: taxonconcept_update_ancestors; Type: TRIGGER; Schema: public; Owner: bien
6118 6173
--
6119 6174

  

Also available in: Unified diff