Project

General

Profile

« Previous | Next » 

Revision 6129

schemas/vegbien.sql: referencecontributor: Point to party instead of referenceparty, which duplicates party

View differences:

schemas/vegbien.my.sql
6023 6023
-- Name: referencecontributor_referenceparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6024 6024
--
6025 6025

  
6026
ALTER TABLE referencecontributor
6027
    ADD CONSTRAINT referencecontributor_referenceparty_id_fkey FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
6028 6026

  
6029 6027

  
6028

  
6030 6029
--
6031 6030
-- Name: referenceparty_currentparty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
6032 6031
--
schemas/vegbien.sql
7024 7024
--
7025 7025

  
7026 7026
ALTER TABLE ONLY referencecontributor
7027
    ADD CONSTRAINT referencecontributor_referenceparty_id_fkey FOREIGN KEY (referenceparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;
7027
    ADD CONSTRAINT referencecontributor_referenceparty_id_fkey FOREIGN KEY (referenceparty_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;
7028 7028

  
7029 7029

  
7030 7030
--

Also available in: Unified diff