migrations/20251244_did_web_overrides.sql at 5be4dc2fbf9b637b4ed1760e17fb74067ece9054 · lewis.moe/bspds-sandbox

lewis.moe / bspds-sandbox

this repo has no description

bspds-sandbox / migrations / 20251244_did_web_overrides.sql

at 5be4dc2fbf9b637b4ed1760e17fb74067ece9054 322 B view raw

1CREATE TABLE IF NOT EXISTS did_web_overrides (
2    user_id UUID PRIMARY KEY REFERENCES users(id) ON DELETE CASCADE,
3    verification_methods JSONB NOT NULL DEFAULT '[]',
4    also_known_as TEXT[] NOT NULL DEFAULT '{}',
5    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
6    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
7);