redline-api/bin/migration_v0.3-v0.4.sql
wangdong 75079c05d3 Initial commit: One API with custom Server Configuration UI
- Added Server Configuration settings page (backend + frontend)
- Added .env config download/import API
- Runtime config updates via UI
- Support for all 3 themes (default, air, berry)
- i18n support (zh/en)
2026-07-28 01:25:29 +08:00

18 lines
464 B
SQL

INSERT INTO abilities (`group`, model, channel_id, enabled)
SELECT c.`group`, m.model, c.id, 1
FROM channels c
CROSS JOIN (
SELECT 'gpt-3.5-turbo' AS model UNION ALL
SELECT 'gpt-3.5-turbo-0301' AS model UNION ALL
SELECT 'gpt-4' AS model UNION ALL
SELECT 'gpt-4-0314' AS model
) AS m
WHERE c.status = 1
AND NOT EXISTS (
SELECT 1
FROM abilities a
WHERE a.`group` = c.`group`
AND a.model = m.model
AND a.channel_id = c.id
);