• Home
• im.actor.server
• actor-persist
• 3.0.0
• source code
• V20150512234700__AddOwnerReadReceivedAt.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.V20150512234700__AddOwnerReadReceivedAt.sql Maven / Gradle / Ivy

ALTER TABLE dialogs
  ADD COLUMN owner_last_received_at timestamp,
  ADD COLUMN owner_last_read_at timestamp;

UPDATE dialogs SET owner_last_received_at = last_received_at;
UPDATE dialogs SET owner_last_read_at = last_read_at;

ALTER TABLE dialogs
  ALTER COLUMN owner_last_received_at SET NOT NULL,
  ALTER COLUMN owner_last_read_at SET NOT NULL;