diff options
Diffstat (limited to 'makima/migrations/20260427000000_create_user_settings.sql')
| -rw-r--r-- | makima/migrations/20260427000000_create_user_settings.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/makima/migrations/20260427000000_create_user_settings.sql b/makima/migrations/20260427000000_create_user_settings.sql new file mode 100644 index 0000000..60acbcc --- /dev/null +++ b/makima/migrations/20260427000000_create_user_settings.sql @@ -0,0 +1,11 @@ +-- Create user_settings table for per-user feature flags and preferences +CREATE TABLE IF NOT EXISTS user_settings ( + id UUID PRIMARY KEY DEFAULT gen_random_uuid(), + owner_id UUID NOT NULL, + key TEXT NOT NULL, + value JSONB NOT NULL DEFAULT '"false"'::jsonb, + created_at TIMESTAMPTZ NOT NULL DEFAULT now(), + updated_at TIMESTAMPTZ NOT NULL DEFAULT now(), + UNIQUE(owner_id, key) +); +CREATE INDEX idx_user_settings_owner ON user_settings(owner_id); |