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

lewis.moe / bspds-sandbox

this repo has no description

bspds-sandbox / migrations / 20251244_did_web_overrides.sql

at main 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);