From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sat, 18 Jan 2020 22:49:38 +0000 (+0100)
Subject: forgot new trigger sql
X-Git-Tag: v3.5.0~96^2~2
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/9371b1aeb98c34da5baf8cb0c4ea95d6e800496f?ds=sidebyside;hp=-c

forgot new trigger sql
---

9371b1aeb98c34da5baf8cb0c4ea95d6e800496f
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();