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

ALTER TABLE user_dialogs ADD COLUMN archived_at TIMESTAMP DEFAULT NULL;
ALTER TABLE user_dialogs DROP COLUMN is_archived;
CREATE INDEX ON user_dialogs(user_id, archived_at);
UPDATE user_dialogs SET archived_at = (
  CASE shown_at
    WHEN NULL THEN NOW() + ((RANDOM()*1000)::INT::TEXT || ' seconds')::INTERVAL
    ELSE NULL
  END
);