18 lines
906 B
SQL
18 lines
906 B
SQL
|
CREATE TABLE users_next (
|
||
|
|
login TEXT PRIMARY KEY,
|
||
|
|
display_name TEXT NOT NULL,
|
||
|
|
git_name TEXT NOT NULL DEFAULT '',
|
||
|
|
git_email TEXT NOT NULL DEFAULT '',
|
||
|
|
created_at TEXT NOT NULL,
|
||
|
|
notification_prefs TEXT NOT NULL DEFAULT '{"questions":true,"reports":false,"errors":false,"rate_limits":false}',
|
||
|
|
focus TEXT NOT NULL DEFAULT '{"tab":"transcript"}',
|
||
|
|
default_model TEXT NOT NULL DEFAULT 'claude-opus-5-5',
|
||
|
|
review_model TEXT NOT NULL DEFAULT 'gpt-6.1-sol',
|
||
|
|
second_review_model TEXT NOT NULL DEFAULT 'claude-opus-5-5'
|
||
|
|
);
|
||
|
|
INSERT INTO users_next (login, display_name, git_name, git_email, created_at, notification_prefs, focus, default_model, review_model, second_review_model)
|
||
|
|
SELECT login, display_name, git_name, git_email, created_at, notification_prefs, json_remove(focus, '$.tabs'), default_model, review_model, second_review_model
|
||
|
|
FROM users;
|
||
|
|
DROP TABLE users;
|
||
|
|
ALTER TABLE users_next RENAME TO users;
|