Skip to content

armgit / ente

Public Imported from GitHub
0

πŸ’š End-to-end encrypted cloud for everything.

1.1 KB
Raw Blame
CREATE TABLE IF NOT EXISTS collection_actions (
    id TEXT PRIMARY KEY,
    user_id BIGINT NOT NULL,
    actor_user_id BIGINT NOT NULL,
    collection_id BIGINT NOT NULL,
    file_id BIGINT,
    data JSONB,
    action TEXT NOT NULL,
    is_pending BOOLEAN NOT NULL DEFAULT TRUE,
    created_at BIGINT NOT NULL DEFAULT now_utc_micro_seconds(),
    updated_at BIGINT NOT NULL DEFAULT now_utc_micro_seconds(),
    CONSTRAINT collection_actions_file_required CHECK (
        (action IN ('REMOVE','DELETE_SUGGESTED') AND file_id IS NOT NULL)
        OR (action NOT IN ('REMOVE','DELETE_SUGGESTED'))
    )
);

CREATE INDEX IF NOT EXISTS collection_actions_user_id_idx ON collection_actions (user_id);
CREATE INDEX IF NOT EXISTS collection_actions_collection_id_idx ON collection_actions (collection_id);
CREATE INDEX IF NOT EXISTS collection_actions_pending_remove_delete_user_time_idx
    ON collection_actions (user_id, updated_at)
    WHERE action IN ('REMOVE', 'DELETE_SUGGESTED') AND is_pending = true;

CREATE TRIGGER update_collection_actions_updated_at
    BEFORE UPDATE ON collection_actions
    FOR EACH ROW
EXECUTE PROCEDURE trigger_updated_at_microseconds_column();