Skip to content

Modern Docker Management, Designed for Everyone

2.0 KB
Raw Blame
-- +goose Up
CREATE INDEX IF NOT EXISTS idx_environments_enabled ON environments(enabled);
CREATE INDEX IF NOT EXISTS idx_environments_status ON environments(status);
CREATE INDEX IF NOT EXISTS idx_environments_last_seen ON environments(last_seen);
CREATE INDEX IF NOT EXISTS idx_container_registries_enabled ON container_registries(enabled);
CREATE INDEX IF NOT EXISTS idx_projects_status ON projects(status);
CREATE INDEX IF NOT EXISTS idx_projects_name ON projects(name);
CREATE INDEX IF NOT EXISTS idx_users_username ON users(username);
CREATE INDEX IF NOT EXISTS idx_users_email ON users(email);
CREATE INDEX IF NOT EXISTS idx_users_oidc_subject_id ON users(oidc_subject_id);
CREATE INDEX IF NOT EXISTS idx_image_updates_has_update ON image_updates(has_update);
CREATE INDEX IF NOT EXISTS idx_image_updates_has_update_notification ON image_updates(has_update, notification_sent);
CREATE INDEX IF NOT EXISTS idx_image_updates_check_time ON image_updates(check_time);
CREATE INDEX IF NOT EXISTS idx_image_updates_notification_sent ON image_updates(notification_sent);
CREATE INDEX IF NOT EXISTS idx_notification_settings_enabled ON notification_settings(enabled);
CREATE INDEX IF NOT EXISTS idx_apprise_settings_enabled ON apprise_settings(enabled);

-- +goose Down
-- Remove all indexes added in migration 027
DROP INDEX IF EXISTS idx_environments_enabled;
DROP INDEX IF EXISTS idx_environments_status;
DROP INDEX IF EXISTS idx_environments_last_seen;
DROP INDEX IF EXISTS idx_container_registries_enabled;
DROP INDEX IF EXISTS idx_projects_status;
DROP INDEX IF EXISTS idx_projects_name;
DROP INDEX IF EXISTS idx_users_username;
DROP INDEX IF EXISTS idx_users_email;
DROP INDEX IF EXISTS idx_users_oidc_subject_id;
DROP INDEX IF EXISTS idx_image_updates_has_update;
DROP INDEX IF EXISTS idx_image_updates_has_update_notification;
DROP INDEX IF EXISTS idx_image_updates_check_time;
DROP INDEX IF EXISTS idx_image_updates_notification_sent;
DROP INDEX IF EXISTS idx_notification_settings_enabled;
DROP INDEX IF EXISTS idx_apprise_settings_enabled;