emq docker 搭建

SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for conf_network_device -- ---------------------------- DROP TABLE IF EXISTS `conf_network_device`; CREATE TABLE `conf_network_device` ( `id` varchar(20) CHARACTER SET utf8mb4 NOT NULL, `station_code` varchar(45) CHARACTER SET utf8mb4 NOT NULL, `device_list_name` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '设备列表', `register_date` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '注册时间', `device_id` varchar(45) CHARACTER SET utf8mb4 NOT NULL COMMENT '设备id', `device_ip` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '设备ip', `user_name` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL, `password` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '密码', `lock` tinyint(1) DEFAULT NULL COMMENT '校验成功后为锁定状态1', `project_code` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '项目', `active_time` datetime DEFAULT NULL COMMENT '激活时间', `create_time` datetime DEFAULT NULL, `update_time` datetime DEFAULT NULL, `create_by` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL, `update_by` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `index2` (`device_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='网络设备';