aboutsummaryrefslogtreecommitdiff
path: root/contrib/scripts/mark_all_read.sql
blob: 5a887c4ec16259f9e61c6affedd4bfc60cf6a629 (plain) (blame)
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;