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