Project

General

Profile

« Previous | Next » 

Revision 13583

inputs/.TNRS/schema.sql: unique constraint on Name_submitted: added Name_matched to allow multiple matches per name, as is needed to implement #917

View differences:

trunk/inputs/.TNRS/schema.sql
706 706

  
707 707

  
708 708
--
709
-- Name: tnrs_Name_submitted_key; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: 
709
-- Name: tnrs_Name_submitted_Name_matched_key; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: 
710 710
--
711 711

  
712 712
ALTER TABLE ONLY tnrs
713
    ADD CONSTRAINT "tnrs_Name_submitted_key" UNIQUE ("Name_submitted");
713
    ADD CONSTRAINT "tnrs_Name_submitted_Name_matched_key" UNIQUE ("Name_submitted", "Name_matched");
714 714

  
715 715

  
716 716
--
trunk/schemas/vegbien.my.sql
13552 13552

  
13553 13553

  
13554 13554
--
13555
-- Name: tnrs_Name_submitted_key; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: 
13555
-- Name: tnrs_Name_submitted_Name_matched_key; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: 
13556 13556
--
13557 13557

  
13558 13558
ALTER TABLE tnrs
13559
    ADD CONSTRAINT `tnrs_Name_submitted_key` UNIQUE (`Name_submitted`);
13559
    ADD CONSTRAINT `tnrs_Name_submitted_Name_matched_key` UNIQUE (`Name_submitted`, `Name_matched`);
13560 13560

  
13561 13561

  
13562 13562
--
trunk/schemas/vegbien.sql
17589 17589

  
17590 17590

  
17591 17591
--
17592
-- Name: tnrs_Name_submitted_key; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: 
17592
-- Name: tnrs_Name_submitted_Name_matched_key; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: 
17593 17593
--
17594 17594

  
17595 17595
ALTER TABLE ONLY tnrs
17596
    ADD CONSTRAINT "tnrs_Name_submitted_key" UNIQUE ("Name_submitted");
17596
    ADD CONSTRAINT "tnrs_Name_submitted_Name_matched_key" UNIQUE ("Name_submitted", "Name_matched");
17597 17597

  
17598 17598

  
17599 17599
--

Also available in: Unified diff