X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2Fsetup_062_add_trigger_backlog_lastmsgid_update.sql;fp=src%2Fcore%2FSQL%2FPostgreSQL%2Fsetup_062_add_trigger_backlog_lastmsgid_update.sql;h=88d2e141164570132be7c225667a6a1f4f42fedd;hp=0000000000000000000000000000000000000000;hb=1d1178f7d73ab19e62798f23c1d0cd5e0b4cdb59;hpb=3cf5c49e7753be48a994917fe898730add4292b1

diff --git a/src/core/SQL/PostgreSQL/setup_062_add_trigger_backlog_lastmsgid_update.sql b/src/core/SQL/PostgreSQL/setup_062_add_trigger_backlog_lastmsgid_update.sql
new file mode 100644
index 00000000..88d2e141
--- /dev/null
+++ b/src/core/SQL/PostgreSQL/setup_062_add_trigger_backlog_lastmsgid_update.sql
@@ -0,0 +1,5 @@
+CREATE TRIGGER backlog_lastmsgid_update_trigger
+AFTER INSERT OR UPDATE
+ON public.backlog
+FOR EACH ROW
+EXECUTE PROCEDURE public.backlog_lastmsgid_update();