pub const MIGRATION_V4: &str = "-- Migration-owner only; binds the signed Dex upstream ATProto DID to durable\n-- source provenance. Old replay rows have no recoverable DID and therefore\n-- remain unreadable as active primary records until their sessions expire.\nBEGIN;\nDO $$\nBEGIN\n IF (SELECT count(*) FROM federate_session.schema_version WHERE version = 3) <> 1\n THEN RAISE EXCEPTION \'expected federate session schema v3\'; END IF;\nEND $$;\nALTER TABLE federate_session.replay\n ADD COLUMN source_atproto_did text\n CHECK (source_atproto_did IS NULL OR length(source_atproto_did) BETWEEN 7 AND 255);\nALTER TABLE federate_session.schema_version\n DROP CONSTRAINT schema_version_version_check;\nUPDATE federate_session.schema_version SET version = 4 WHERE version = 3;\nALTER TABLE federate_session.schema_version\n ADD CONSTRAINT schema_version_version_check CHECK (version = 4);\nCOMMIT;\n";