Files
MonkeyCode/backend/migration/000006_alter_settings_table.up.sql
2025-07-15 11:34:20 +08:00

7 lines
415 B
SQL

ALTER TABLE settings DROP COLUMN IF EXISTS enable_dingtalk_oauth;
ALTER TABLE settings DROP COLUMN IF EXISTS dingtalk_client_id;
ALTER TABLE settings DROP COLUMN IF EXISTS dingtalk_client_secret;
ALTER TABLE settings ADD COLUMN dingtalk_oauth JSONB DEFAULT '{}'::JSONB;
ALTER TABLE settings ADD COLUMN custom_oauth JSONB DEFAULT '{}'::JSONB;
ALTER TABLE settings ADD COLUMN enable_auto_login BOOLEAN DEFAULT FALSE;