• Home
• im.actor.server
• actor-persist
• 3.0.0
• source code
• V20150820183625__UpdateReadDateGroups.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sql.migration.V20150820183625__UpdateReadDateGroups.sql Maven / Gradle / Ivy

update dialogs d set last_read_at = now(), owner_last_received_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);