sql/Pg-upgrade2/requirement_spec_parts_foreign_key_cascade.sql

   1 -- @tag: requirement_spec_parts_foreign_key_cascade
   2 -- @description: Automatisches Löschen in requirement_spec_parts wenn zugehöriges Pflichtenheft gelöscht wird
   3 -- @depends: requirement_spec_parts
   4 ALTER TABLE requirement_spec_parts
   5 DROP CONSTRAINT requirement_spec_parts_requirement_spec_id_fkey;
   6
   7 ALTER TABLE requirement_spec_parts
   8 ADD FOREIGN KEY (requirement_spec_id) REFERENCES requirement_specs (id)
   9 ON DELETE CASCADE;