Project

General

Profile

« Previous | Next » 

Revision 7050

schemas/vegbien.sql: Renamed *_reference_id_fkey fkeys to *_source_id_fkey

View differences:

schemas/vegbien.my.sql
5679 5679

  
5680 5680

  
5681 5681
--
5682
-- Name: commconcept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5682
-- Name: commconcept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
5683 5683
--
5684 5684

  
5685 5685

  
......
6353 6353

  
6354 6354

  
6355 6355
--
6356
-- Name: taxonconcept_concept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6356
-- Name: taxonconcept_concept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6357 6357
--
6358 6358

  
6359 6359

  
schemas/vegbien.sql
6799 6799

  
6800 6800

  
6801 6801
--
6802
-- Name: commconcept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6802
-- Name: commconcept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6803 6803
--
6804 6804

  
6805 6805
ALTER TABLE ONLY commconcept
6806
    ADD CONSTRAINT commconcept_reference_id_fkey FOREIGN KEY (source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
6806
    ADD CONSTRAINT commconcept_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
6807 6807

  
6808 6808

  
6809 6809
--
......
7503 7503

  
7504 7504

  
7505 7505
--
7506
-- Name: taxonconcept_concept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
7506
-- Name: taxonconcept_concept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
7507 7507
--
7508 7508

  
7509 7509
ALTER TABLE ONLY taxonconcept
7510
    ADD CONSTRAINT taxonconcept_concept_reference_id_fkey FOREIGN KEY (concept_reference_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
7510
    ADD CONSTRAINT taxonconcept_concept_source_id_fkey FOREIGN KEY (concept_reference_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
7511 7511

  
7512 7512

  
7513 7513
--

Also available in: Unified diff