sql.migration.V20150512234700__AddOwnerReadReceivedAt.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of actor-persist Show documentation

actor-persist

There is a newer version: 3.0.0

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;