Revision 7050
Added by Aaron Marcuse-Kubitza over 11 years ago
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
schemas/vegbien.sql: Renamed *_reference_id_fkey fkeys to *_source_id_fkey