dd/fn部署.md

master的option里加freenode_client freenode_client-fn_a和freenode_client都要有

master的site_map里加config字段，加api_path字段

master加crawl_freenode表，加freenode_pool表

master的fn文件夹里加template

master加dog_option表

cfn的option里嫁freenode_client { "id": 10, "key": "freenode_client", "value": "v2ray,clash" }

cnf加http_queue表 - 不用

cfn的env里加url_master_base

cfn的public里加sub文件夹

另外注意权限，nginx一个权限，php-fpm一个权限

ALTER TABLE site_map ADD COLUMN config LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(config)), ADD COLUMN api_path LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(api_path));

CREATE TABLE crawl_freenode ( id int(11) unsigned NOT NULL AUTO_INCREMENT, name varchar(120) DEFAULT NULL, group varchar(50) DEFAULT NULL, url_base varchar(255) DEFAULT NULL, url_node varchar(255) DEFAULT NULL, url_file longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(url_file)), file_real longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(file_real)), status tinyint(1) DEFAULT 1, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE freenode_pool ( id int(11) unsigned NOT NULL AUTO_INCREMENT, date date DEFAULT NULL, content longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(content)), content_custom longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(content_custom)), content_v2ray longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(content_v2ray)), content_clash longtext DEFAULT NULL, PRIMARY KEY (id), KEY date (date) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE dog_option ( id int(11) unsigned NOT NULL AUTO_INCREMENT, dog_name varchar(255) DEFAULT NULL, k varchar(255) DEFAULT NULL, v varchar(255) DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY unique_this_name_k (dog_name,k) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;