Skip to main content

MIGRATION

Constant MIGRATION 

Source
pub const MIGRATION: &str = "-- Migration-owner only, applied explicitly; never executed by the runtime crate.\n-- Roles are provisioned by the deployment operator (see roles.sql).\nBEGIN;\nCREATE SCHEMA federate_session;\nREVOKE ALL ON SCHEMA federate_session FROM PUBLIC;\nCREATE TABLE federate_session.schema_version (\n    version integer PRIMARY KEY CHECK (version = 1)\n);\nINSERT INTO federate_session.schema_version VALUES (1);\nCREATE TABLE federate_session.profile_state (\n    host text NOT NULL CHECK (length(host) BETWEEN 1 AND 2048),\n    profile text NOT NULL CHECK (profile = \'federate-session-v1\'),\n    enabled boolean NOT NULL DEFAULT false,\n    authority_generation bytea NOT NULL CHECK (octet_length(authority_generation) = 32),\n    lock_version bigint NOT NULL DEFAULT 0,\n    PRIMARY KEY (host, profile)\n);\n-- No profile is seeded/enabled by migration. An absent row denies admission.\nCREATE TABLE federate_session.sessions (\n    host text NOT NULL,\n    profile text NOT NULL,\n    sid text NOT NULL CHECK (length(sid) BETWEEN 1 AND 128),\n    account_id text NOT NULL CHECK (length(account_id) BETWEEN 1 AND 256),\n    subject text NOT NULL CHECK (length(subject) BETWEEN 1 AND 256),\n    tenant text NOT NULL CHECK (length(tenant) BETWEEN 1 AND 256),\n    client_id text NOT NULL CHECK (length(client_id) BETWEEN 1 AND 256),\n    resource text NOT NULL CHECK (length(resource) BETWEEN 1 AND 2048),\n    scopes text[] NOT NULL CHECK (cardinality(scopes) BETWEEN 1 AND 64),\n    grant_revision text NOT NULL CHECK (length(grant_revision) BETWEEN 1 AND 256),\n    suite text NOT NULL CHECK (suite = \'hs-cose-sign-ed25519-mldsa65-wns-v1\'),\n    ed_public bytea NOT NULL CHECK (octet_length(ed_public) = 32),\n    pq_public bytea NOT NULL CHECK (octet_length(pq_public) = 1952),\n    generation bytea NOT NULL CHECK (octet_length(generation) = 32),\n    created_at bigint NOT NULL CHECK (created_at >= 0),\n    expires_at bigint NOT NULL CHECK (expires_at > created_at AND expires_at - created_at <= 300),\n    status text NOT NULL DEFAULT \'active\' CHECK (status IN (\'active\',\'revoked\')),\n    PRIMARY KEY (host, sid),\n    FOREIGN KEY (host, profile) REFERENCES federate_session.profile_state(host, profile)\n);\nCREATE TABLE federate_session.replay (\n    issuer text NOT NULL CHECK (length(issuer) BETWEEN 1 AND 2048),\n    client_id text NOT NULL CHECK (length(client_id) BETWEEN 1 AND 256),\n    source_subject text NOT NULL CHECK (length(source_subject) BETWEEN 1 AND 256),\n    jti text NOT NULL CHECK (length(jti) BETWEEN 1 AND 256),\n    nonce text NOT NULL CHECK (length(nonce) BETWEEN 1 AND 256),\n    token_hash bytea NOT NULL UNIQUE CHECK (octet_length(token_hash) = 32),\n    source_iat bigint NOT NULL CHECK (source_iat >= 0),\n    source_exp bigint NOT NULL CHECK (source_exp > source_iat AND source_exp - source_iat <= 300),\n    retain_until bigint NOT NULL CHECK (retain_until >= source_iat + 330 AND retain_until >= source_exp + 30),\n    host text NOT NULL,\n    sid text NOT NULL,\n    PRIMARY KEY (issuer, client_id, jti),\n    UNIQUE (issuer, client_id, nonce),\n    FOREIGN KEY (host, sid) REFERENCES federate_session.sessions(host, sid)\n);\nCREATE INDEX replay_cleanup ON federate_session.replay(retain_until);\nCREATE INDEX session_cleanup ON federate_session.sessions(expires_at);\nREVOKE ALL ON ALL TABLES IN SCHEMA federate_session FROM PUBLIC;\nCOMMIT;\n";