All Downloads are FREE. Search and download functionalities are using the official Maven repository.

sql.migration.V20151014194156__AddIsHiddenToGroups.sql Maven / Gradle / Ivy

There is a newer version: 3.0.0
Show newest version
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);




© 2015 - 2024 Weber Informatics LLC | Privacy Policy