this repo has no description
lewis.moe
1CREATE TABLE IF NOT EXISTS account_preferences (
2 id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
3 user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
4 name TEXT NOT NULL,
5 value_json JSONB NOT NULL,
6 created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
7 updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
8 UNIQUE(user_id, name)
9);
10
11CREATE INDEX IF NOT EXISTS idx_account_preferences_user_id ON account_preferences(user_id);
12CREATE INDEX IF NOT EXISTS idx_account_preferences_name ON account_preferences(name);