Project

General

Profile

« Previous | Next » 

Revision 5271

schemas/vegbien.sql: Fixed bug where taxonconcept.parent_id was missing a foreign key constraint

View differences:

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

  

Also available in: Unified diff