sql.migration.V20160203202648__PinPresenceToAuthId.sql Maven / Gradle / Ivy
ALTER TABLE user_presences ADD COLUMN auth_id BIGINT NOT NULL;
CREATE INDEX ON user_presences (user_id, last_seen_at);
CREATE INDEX ON user_presences (user_id, auth_id);
ALTER TABLE user_presences ADD COLUMN auth_id BIGINT NOT NULL;
CREATE INDEX ON user_presences (user_id, last_seen_at);
CREATE INDEX ON user_presences (user_id, auth_id);