sql.migration.V20150821183625__UpdateReadDateGroupsFix.sql Maven / Gradle / Ivy
The newest version!
update dialogs d set last_read_at = now(), owner_last_read_at = now() where d.peer_type = 2 and d.peer_id not in (select group_id from group_users gu where gu.user_id = d.user_id);