CREATE TABLE sources (

    id                   TEXT PRIMARY KEY,

    name                 TEXT NOT NULL,

    category             TEXT NOT NULL CHECK (category IN ('primary','resale','sports','festival','social')),

    enabled              BOOLEAN NOT NULL DEFAULT TRUE,

    status               TEXT NOT NULL DEFAULT 'healthy'

                         CHECK (status IN ('healthy','degraded','down','disabled')),

    poll_interval_s      INTEGER NOT NULL DEFAULT 300 CHECK (poll_interval_s BETWEEN 1 AND 86400),

    tight_interval_s     INTEGER NOT NULL DEFAULT 10  CHECK (tight_interval_s BETWEEN 1 AND 3600),

    last_poll_at         TIMESTAMPTZ,

    last_success_at      TIMESTAMPTZ,

    last_error           TEXT,

    consecutive_failures INTEGER NOT NULL DEFAULT 0 CHECK (consecutive_failures >= 0),

    created_at           TIMESTAMPTZ NOT NULL DEFAULT NOW(),

    updated_at           TIMESTAMPTZ NOT NULL DEFAULT NOW()

);

CREATE TRIGGER sources_set_updated_at

    BEFORE UPDATE ON sources

    FOR EACH ROW EXECUTE FUNCTION set_updated_at();