mrlee
278f8267b7
- 公网反代：Nginx 状态卡片（版本 / 运行状态 / 配置校验 / 端口监听） - 部署设置第一、二梯队（HTTPS 开关、安全头、限流、连接数、仅中国大陆 IP） - 隧道检测兼容 frps v0.68 / v0.71（V2 与旧版端点） - 恢复被清空的 internal/frp/store.go、internal/api/ddns_handler.go、web/src/views/DdnsView.vue
23 lines
822 B
SQL
23 lines
822 B
SQL
UPDATE proxy_hosts
|
|
SET listen_port = (
|
|
SELECT listen_port FROM proxy_rules WHERE proxy_rules.id = proxy_hosts.rule_id
|
|
)
|
|
WHERE listen_port IS NULL;
|
|
|
|
CREATE TABLE proxy_hosts_new (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
rule_id INTEGER NOT NULL REFERENCES proxy_rules(id) ON DELETE CASCADE,
|
|
hostname TEXT NOT NULL COLLATE NOCASE,
|
|
listen_port INTEGER NOT NULL CHECK (listen_port > 0 AND listen_port <= 65535),
|
|
created_at TEXT NOT NULL DEFAULT (datetime('now')),
|
|
UNIQUE(hostname, listen_port)
|
|
);
|
|
|
|
INSERT INTO proxy_hosts_new (id, rule_id, hostname, listen_port, created_at)
|
|
SELECT id, rule_id, hostname, listen_port, created_at FROM proxy_hosts;
|
|
|
|
DROP TABLE proxy_hosts;
|
|
ALTER TABLE proxy_hosts_new RENAME TO proxy_hosts;
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_proxy_hosts_rule_id ON proxy_hosts(rule_id);
|