From 9371b1aeb98c34da5baf8cb0c4ea95d6e800496f Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Sat, 18 Jan 2020 23:49:38 +0100 Subject: [PATCH] forgot new trigger sql --- sql/table-triggers.sql | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 sql/table-triggers.sql diff --git a/sql/table-triggers.sql b/sql/table-triggers.sql new file mode 100644 index 00000000..5bf895a1 --- /dev/null +++ b/sql/table-triggers.sql @@ -0,0 +1,22 @@ +-- insert creates the location tables, creates location indexes if indexed == true +CREATE TRIGGER placex_before_insert BEFORE INSERT ON placex + FOR EACH ROW EXECUTE PROCEDURE placex_insert(); +CREATE TRIGGER osmline_before_insert BEFORE INSERT ON location_property_osmline + FOR EACH ROW EXECUTE PROCEDURE osmline_insert(); + +-- update insert creates the location tables +CREATE TRIGGER placex_before_update BEFORE UPDATE ON placex + FOR EACH ROW EXECUTE PROCEDURE placex_update(); +CREATE TRIGGER osmline_before_update BEFORE UPDATE ON location_property_osmline + FOR EACH ROW EXECUTE PROCEDURE osmline_update(); + +-- diff update triggers +CREATE TRIGGER placex_before_delete AFTER DELETE ON placex + FOR EACH ROW EXECUTE PROCEDURE placex_delete(); +CREATE TRIGGER place_before_delete BEFORE DELETE ON place + FOR EACH ROW EXECUTE PROCEDURE place_delete(); +CREATE TRIGGER place_before_insert BEFORE INSERT ON place + FOR EACH ROW EXECUTE PROCEDURE place_insert(); + +CREATE TRIGGER location_postcode_before_update BEFORE UPDATE ON location_postcode + FOR EACH ROW EXECUTE PROCEDURE postcode_update(); -- 2.39.5