nexarch/migrations/0026_rollback_criteria_approval.up.sql

-- ROL-01: Freigabe-Datensatz fuer die vorab festgelegten
-- Rollback-Schwellenwerte, analog zu 0024/0025 (tenant/user_migration_map
-- Freigabe). Eine Zeile je Freigabe-Entscheidung, die juengste gilt.
CREATE TABLE rollback_criteria_approval (
    id                              BIGSERIAL PRIMARY KEY,
    max_affected_tenant_fraction    DOUBLE PRECISION NOT NULL CHECK (max_affected_tenant_fraction > 0 AND max_affected_tenant_fraction < 1),
    description                     TEXT NOT NULL,
    approved_by                     TEXT NOT NULL,
    approved_at                     TIMESTAMPTZ NOT NULL DEFAULT now(),
    note                            TEXT
);

CREATE INDEX rollback_criteria_approval_approved_at_idx ON rollback_criteria_approval (approved_at DESC);