Revision 7051
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.sql | ||
|---|---|---|
| 6799 | 6799 |
|
| 6800 | 6800 |
|
| 6801 | 6801 |
-- |
| 6802 |
-- Name: commconcept_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6802 |
-- Name: commconcept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 6803 | 6803 |
-- |
| 6804 | 6804 |
|
| 6805 | 6805 |
ALTER TABLE ONLY commconcept |
| 6806 |
ADD CONSTRAINT commconcept_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 6806 |
ADD CONSTRAINT commconcept_reference_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_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 7506 |
-- Name: taxonconcept_concept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 7507 | 7507 |
-- |
| 7508 | 7508 |
|
| 7509 | 7509 |
ALTER TABLE ONLY taxonconcept |
| 7510 |
ADD CONSTRAINT taxonconcept_concept_source_id_fkey FOREIGN KEY (concept_reference_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 7510 |
ADD CONSTRAINT taxonconcept_concept_reference_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 taxonconcept_concept_source_id_fkey back to taxonconcept_concept_reference_id_fkey