migrations/20260418110000_provider_repository_reconciliation.up.sql

Rama main · réplica de lectura del repositorio original.

ALTER TABLE shardline_provider_repository_states
    ADD COLUMN IF NOT EXISTS last_cache_invalidated_at_unix_seconds BIGINT CHECK (
        last_cache_invalidated_at_unix_seconds IS NULL
        OR last_cache_invalidated_at_unix_seconds >= 0
    );

ALTER TABLE shardline_provider_repository_states
    ADD COLUMN IF NOT EXISTS last_authorization_rechecked_at_unix_seconds BIGINT CHECK (
        last_authorization_rechecked_at_unix_seconds IS NULL
        OR last_authorization_rechecked_at_unix_seconds >= 0
    );

ALTER TABLE shardline_provider_repository_states
    ADD COLUMN IF NOT EXISTS last_drift_checked_at_unix_seconds BIGINT CHECK (
        last_drift_checked_at_unix_seconds IS NULL
        OR last_drift_checked_at_unix_seconds >= 0
    );