Skip to main content

MIGRATION_V4

Constant MIGRATION_V4 

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