Skip to main content

MIGRATION_V2

Constant MIGRATION_V2 

Source
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";