Files
zitadel/apps/api/cmd/setup/10/10_update.sql
2025-08-05 15:20:32 -07:00

11 lines
235 B
SQL

UPDATE
eventstore.events e
SET
creation_date = we.next_cd
, "position" = (EXTRACT(EPOCH FROM we.next_cd))
FROM
wrong_events we
WHERE
e.event_sequence = we.event_sequence
AND e.instance_id = we.instance_id;