Revision 5271
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 5072 | 5072 |
|
| 5073 | 5073 |
|
| 5074 | 5074 |
-- |
| 5075 |
-- Name: taxonconcept_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5076 |
-- |
|
| 5077 |
|
|
| 5078 |
ALTER TABLE taxonconcept |
|
| 5079 |
ADD CONSTRAINT taxonconcept_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES taxonconcept(taxonconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5080 |
|
|
| 5081 |
|
|
| 5082 |
-- |
|
| 5075 | 5083 |
-- Name: taxonconcept_taxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5076 | 5084 |
-- |
| 5077 | 5085 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 5763 | 5763 |
|
| 5764 | 5764 |
|
| 5765 | 5765 |
-- |
| 5766 |
-- Name: taxonconcept_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5767 |
-- |
|
| 5768 |
|
|
| 5769 |
ALTER TABLE ONLY taxonconcept |
|
| 5770 |
ADD CONSTRAINT taxonconcept_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES taxonconcept(taxonconcept_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5771 |
|
|
| 5772 |
|
|
| 5773 |
-- |
|
| 5766 | 5774 |
-- Name: taxonconcept_taxon_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5767 | 5775 |
-- |
| 5768 | 5776 |
|
Also available in: Unified diff
schemas/vegbien.sql: Fixed bug where taxonconcept.parent_id was missing a foreign key constraint