keiro-migrations-0.2.0.0: sql-migrations/2026-06-15-21-49-37-keiro-projection-dedup.sql

CREATE TABLE IF NOT EXISTS keiro.keiro_projection_dedup (
  projection_name TEXT        NOT NULL,
  event_id        UUID        NOT NULL,
  applied_at      TIMESTAMPTZ NOT NULL DEFAULT now(),
  PRIMARY KEY (projection_name, event_id)
);

CREATE INDEX IF NOT EXISTS keiro_projection_dedup_applied_at_idx
  ON keiro.keiro_projection_dedup (applied_at);