237c7802e5
Some checks failed
Deploy / deploy (push) Has been cancelled
Full-stack web application for Telegram management - Frontend: Vue 3 + Vben Admin - Backend: NestJS - Features: User management, group broadcast, statistics 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude <noreply@anthropic.com>
48 lines
1.5 KiB
SQL
48 lines
1.5 KiB
SQL
-- 添加Rola-IP代理平台到数据库
|
||
-- 执行此SQL文件将Rola-IP平台配置插入到proxy_platform表中
|
||
|
||
-- 检查是否已存在Rola-IP配置
|
||
SELECT COUNT(*) as existing_count FROM proxy_platform WHERE platform = 'rola-ip';
|
||
|
||
-- 插入Rola-IP平台配置（如果不存在）
|
||
INSERT INTO proxy_platform (
|
||
platform,
|
||
description,
|
||
apiUrl,
|
||
authType,
|
||
apiKey,
|
||
username,
|
||
password,
|
||
proxyTypes,
|
||
countries,
|
||
concurrentLimit,
|
||
rotationInterval,
|
||
remark,
|
||
isEnabled,
|
||
createdAt,
|
||
updatedAt
|
||
)
|
||
SELECT * FROM (
|
||
SELECT
|
||
'rola-ip' as platform,
|
||
'Rola-IP专业代理IP服务平台，支持住宅IP、数据中心IP、移动IP等多种类型' as description,
|
||
'https://admin.rola-ip.co' as apiUrl,
|
||
'userPass' as authType,
|
||
'' as apiKey,
|
||
'' as username,
|
||
'' as password,
|
||
'residential,datacenter,mobile,static_residential,ipv6' as proxyTypes,
|
||
'US,UK,DE,FR,JP,KR,AU,CA,BR,IN,SG,HK,TW,RU,NL' as countries,
|
||
100 as concurrentLimit,
|
||
300 as rotationInterval,
|
||
'支持多种代理类型和15个国家/地区，提供住宅IP、数据中心IP、移动IP、静态住宅IP和IPv6代理服务。需要配置用户名和密码后启用。' as remark,
|
||
0 as isEnabled,
|
||
NOW() as createdAt,
|
||
NOW() as updatedAt
|
||
) AS tmp
|
||
WHERE NOT EXISTS (
|
||
SELECT 1 FROM proxy_platform WHERE platform = 'rola-ip'
|
||
);
|
||
|
||
-- 验证插入结果
|
||
SELECT * FROM proxy_platform WHERE platform = 'rola-ip'; |