migrations/20260923000000_reliability_event_kinds.up.sql

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

ALTER TABLE shardline_reliability_events
    ADD COLUMN operation_kind TEXT;

UPDATE shardline_reliability_events
SET operation_kind = event_json->'operation'->>'kind'
WHERE operation_kind IS NULL;

ALTER TABLE shardline_reliability_events
    ALTER COLUMN operation_kind SET NOT NULL;

ALTER TABLE shardline_reliability_events
    DROP CONSTRAINT IF EXISTS shardline_reliability_events_pkey;

ALTER TABLE shardline_reliability_events
    ADD CONSTRAINT shardline_reliability_events_pkey
    PRIMARY KEY (operation_kind, operation_id, sequence);