pub const MIGRATION_V2: &str = "-- Migration-owner only. Apply explicitly after 001_admission.sql and before\n-- 002_roles.sql. No runtime path executes migrations or creates a profile.\n-- Existing dynamic rows cannot be assigned a trustworthy inventory or epoch.\nBEGIN;\nDO $$\nBEGIN\n IF (SELECT count(*) FROM federate_session.schema_version WHERE version = 1) <> 1\n OR EXISTS (SELECT 1 FROM federate_session.profile_state)\n OR EXISTS (SELECT 1 FROM federate_session.sessions)\n OR EXISTS (SELECT 1 FROM federate_session.replay) THEN\n RAISE EXCEPTION \'federate session v2 requires empty v1 profile and replay state\';\n END IF;\nEND;\n$$;\n\nALTER TABLE federate_session.profile_state\n ADD COLUMN collision_inventory_id bytea NOT NULL\n CHECK (octet_length(collision_inventory_id) = 32);\n\nALTER TABLE federate_session.sessions\n ADD COLUMN collision_inventory_id bytea NOT NULL\n CHECK (octet_length(collision_inventory_id) = 32),\n ADD COLUMN proof_epoch bigint GENERATED ALWAYS AS IDENTITY\n (START WITH 1 INCREMENT BY 1 NO CYCLE)\n CHECK (proof_epoch > 0),\n ADD CONSTRAINT sessions_proof_epoch_unique UNIQUE (proof_epoch),\n ADD CONSTRAINT sessions_host_ed_unique UNIQUE (host, ed_public),\n ADD CONSTRAINT sessions_host_pq_unique UNIQUE (host, pq_public);\n\n-- Generation-only rotation with the same complete inventory ID is valid while\n-- disabled. The control procedure must still issue one paired UPDATE setting\n-- both columns; a row trigger cannot inspect which unchanged columns were SET.\nCREATE FUNCTION federate_session.guard_profile_rotation() RETURNS trigger\nLANGUAGE plpgsql AS $$\nBEGIN\n IF NEW.collision_inventory_id IS DISTINCT FROM OLD.collision_inventory_id\n AND NEW.authority_generation IS NOT DISTINCT FROM OLD.authority_generation THEN\n RAISE EXCEPTION \'inventory change requires generation rotation\';\n END IF;\n IF (NEW.authority_generation IS DISTINCT FROM OLD.authority_generation\n OR NEW.collision_inventory_id IS DISTINCT FROM OLD.collision_inventory_id)\n AND (OLD.enabled OR NEW.enabled) THEN\n RAISE EXCEPTION \'rotation requires disabled profile\';\n END IF;\n RETURN NEW;\nEND;\n$$;\nCREATE TRIGGER guard_profile_rotation BEFORE UPDATE ON federate_session.profile_state\n FOR EACH ROW EXECUTE FUNCTION federate_session.guard_profile_rotation();\n\nCREATE FUNCTION federate_session.guard_proof_epoch() RETURNS trigger\nLANGUAGE plpgsql AS $$\nBEGIN\n IF NEW.proof_epoch IS DISTINCT FROM OLD.proof_epoch THEN\n RAISE EXCEPTION \'proof epoch is immutable\';\n END IF;\n RETURN NEW;\nEND;\n$$;\nCREATE TRIGGER guard_proof_epoch BEFORE UPDATE ON federate_session.sessions\n FOR EACH ROW EXECUTE FUNCTION federate_session.guard_proof_epoch();\n\nCREATE TABLE federate_session.request_replay (\n verified_namespace bytea NOT NULL CHECK (octet_length(verified_namespace) = 32),\n request_id bytea NOT NULL CHECK (octet_length(request_id) = 16),\n retain_until bigint NOT NULL CHECK (retain_until > 0),\n PRIMARY KEY (verified_namespace, request_id)\n);\nCREATE INDEX request_replay_cleanup ON federate_session.request_replay(retain_until);\nREVOKE ALL ON federate_session.request_replay FROM PUBLIC;\n\nALTER TABLE federate_session.schema_version\n DROP CONSTRAINT schema_version_version_check;\nUPDATE federate_session.schema_version SET version = 2 WHERE version = 1;\nALTER TABLE federate_session.schema_version\n ADD CONSTRAINT schema_version_version_check CHECK (version = 2);\nCOMMIT;\n";