BEGIN;
CREATE TABLE IF NOT EXISTS mcp_management_channels (
 id uuid PRIMARY KEY, server_id bigint NOT NULL UNIQUE REFERENCES servers(id) ON DELETE CASCADE,
 config_sealed text NOT NULL, identity_hash text NOT NULL, attestation text NOT NULL,
 created_by text NOT NULL, generation text NOT NULL, expires_at timestamptz NOT NULL,
 verified_at timestamptz NOT NULL DEFAULT now(), revoked_at timestamptz
);
COMMIT;