aboutsummaryrefslogtreecommitdiff
path: root/contrib/scripts/mark_all_read.sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/scripts/mark_all_read.sql')
-rw-r--r--contrib/scripts/mark_all_read.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/contrib/scripts/mark_all_read.sql b/contrib/scripts/mark_all_read.sql
new file mode 100644
index 00000000..5a887c4e
--- /dev/null
+++ b/contrib/scripts/mark_all_read.sql
@@ -0,0 +1 @@
+update subscr_messages, (select m.message_id midd, m.replies from messages m inner join subscr_messages s on m.message_id=s.message_id) r set subscr_messages.last_read_rid=r.replies where subscr_messages.message_id=r.midd; \ No newline at end of file