1 -- @tag: custom_variables_delete_via_trigger_requirement_specs
2 -- @description: Benutzerdefinierte Variablen von Pflichtenheften via Trigger löschen
3 -- @depends: custom_variables_delete_via_trigger requirement_specs
4 CREATE OR REPLACE FUNCTION delete_requirement_spec_custom_variables_trigger() RETURNS trigger AS $$
6 DELETE FROM custom_variables WHERE (sub_module = '' OR sub_module IS NULL)
8 AND (SELECT module FROM custom_variable_configs WHERE id = config_id) = 'RequirementSpecs';
14 DROP TRIGGER IF EXISTS delete_requirement_spec_custom_variables ON requirement_specs;
16 CREATE TRIGGER delete_requirement_spec_custom_variables
17 BEFORE DELETE ON requirement_specs
18 FOR EACH ROW EXECUTE PROCEDURE delete_requirement_spec_custom_variables_trigger();