ALTER TABLE `popular_feelings`
    CHANGE COLUMN `site_name` `site_name` VARCHAR (100) NOT NULL COMMENT '网站名称' COLLATE 'utf8mb4_general_ci' AFTER `id`,
    CHANGE COLUMN `keywords` `keywords` VARCHAR (500) NOT NULL COMMENT '监控关键词' COLLATE 'utf8mb4_general_ci' AFTER `site_name`,
    CHANGE COLUMN `domain` `domain` VARCHAR (200) NOT NULL COMMENT '域名' COLLATE 'utf8mb4_general_ci' AFTER `keywords`,
    ADD COLUMN `url_patterns` TEXT NOT NULL AFTER `domain`,
    CHANGE COLUMN `start_urls` `start_urls` VARCHAR (500) NOT NULL COMMENT '启动域名' COLLATE 'utf8mb4_general_ci' AFTER `url_patterns`;

REPLACE
INTO `authority_info` (`id`, `parent_id`, `name`, `remark`)
VALUES (2300, 0, 'popular.feelings', '舆情监控管理'),
       (2301, 2300, 'popular.feelings.find', '查询'),
       (2302, 2300, 'popular.feelings.add', '添加'),
       (2303, 2300, 'popular.feelings.edit', '修改'),
       (2304, 2300, 'popular.feelings.delete', '删除'),
       (2305, 2300, 'popular.feelings.start', '启动'),
       (2306, 2300, 'popular.feelings.stop', '停止');

