migrations/202512211401_reserved_signing_keys.sql at 0d4328cd6ea2cd929d35e9555558d4a94b238c19 · lewis.moe/bspds-sandbox

lewis.moe / bspds-sandbox

this repo has no description

bspds-sandbox / migrations / 202512211401_reserved_signing_keys.sql

at 0d4328cd6ea2cd929d35e9555558d4a94b238c19 575 B view raw

 1CREATE TABLE IF NOT EXISTS reserved_signing_keys (
 2    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
 3    did TEXT,
 4    public_key_did_key TEXT NOT NULL,
 5    private_key_bytes BYTEA NOT NULL,
 6    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
 7    expires_at TIMESTAMPTZ NOT NULL DEFAULT NOW() + INTERVAL '24 hours',
 8    used_at TIMESTAMPTZ
 9);
10
11CREATE INDEX IF NOT EXISTS idx_reserved_signing_keys_did ON reserved_signing_keys(did) WHERE did IS NOT NULL;
12CREATE INDEX IF NOT EXISTS idx_reserved_signing_keys_expires ON reserved_signing_keys(expires_at) WHERE used_at IS NULL;