From 1e9c7c65533405f418eb38e395c912d6bbcff8af Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Wed, 16 Dec 2015 12:00:40 +0100 Subject: [PATCH] =?utf8?q?mtime-Trigger=20f=C3=BCr=20die=20Tabelle=20proje?= =?utf8?q?ct=20hinzuf=C3=BCgen.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit In der Tabelle gibt es zwar die Spalte mitime, aber keinen Trigger zum setzen. Das holt dieser commit nach. --- sql/Pg-upgrade2/project_mtime_trigger.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/Pg-upgrade2/project_mtime_trigger.sql diff --git a/sql/Pg-upgrade2/project_mtime_trigger.sql b/sql/Pg-upgrade2/project_mtime_trigger.sql new file mode 100644 index 000000000..7b90764fb --- /dev/null +++ b/sql/Pg-upgrade2/project_mtime_trigger.sql @@ -0,0 +1,6 @@ +-- @tag: project_mtime_trigger +-- @description: mtime-Trigger für Tabelle project hinzufügen. +-- @depends: release_3_3_0 +-- @encoding: utf-8 + +CREATE TRIGGER mtime_project BEFORE UPDATE ON project FOR EACH ROW EXECUTE PROCEDURE set_mtime(); -- 2.20.1