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

ALTER TABLE groups ADD COLUMN is_hidden BOOLEAN DEFAULT FALSE;
ALTER TABLE dialogs DROP COLUMN is_hidden;
ALTER TABLE dialogs ADD COLUMN is_archived BOOLEAN DEFAULT FALSE;
CREATE INDEX idx_groups_id_is_hidden ON groups (id, is_hidden);
CREATE INDEX idx_dialogs_user_id_is_archived ON dialogs (user_id, is_archived);