pub const MIGRATION_V3: &str = "-- Migration-owner only; required before using bounded per-use primary lookup.\n-- The foreign key is keyed by (host, sid), but use-time source binding joins\n-- from the session to replay on (host, sid, client_id). This index keeps that\n-- exact lookup bounded as replay history grows.\nBEGIN;\nDO $$\nBEGIN\n IF (SELECT count(*) FROM federate_session.schema_version WHERE version = 2) <> 1\n THEN RAISE EXCEPTION \'expected federate session schema v2\'; END IF;\nEND $$;\nCREATE INDEX replay_primary_lookup\n ON federate_session.replay(host, sid, client_id);\nALTER TABLE federate_session.schema_version\n DROP CONSTRAINT schema_version_version_check;\nUPDATE federate_session.schema_version SET version = 3 WHERE version = 2;\nALTER TABLE federate_session.schema_version\n ADD CONSTRAINT schema_version_version_check CHECK (version = 3);\nCOMMIT;\n";