forward/src/main/resources/db/migration/V1.0.2__dev_config.sql

CREATE TABLE `user_config`
(
    `id`            varchar(45) NOT NULL COMMENT '用户ID',
    `wifi`          varchar(2000)                                                DEFAULT NULL COMMENT 'wifi信息:[{“name”:"tuoren1",“password”:"12345678"},{},{},...]',
    `local_address` varchar(45)                                                  DEFAULT NULL COMMENT '医院数据对接服务地址',
    `local_port`    int                                                          DEFAULT NULL COMMENT '医院数据对接服务端口',
    `device_secret` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '设备密钥',
    `createtime`    datetime                                                     DEFAULT NULL COMMENT '创建时间',
    `modifytime`    datetime                                                     DEFAULT NULL COMMENT '修改时间',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户配置表';

CREATE TABLE `forward`.`regist_log`
(
    `id`         VARCHAR(45) NOT NULL COMMENT 'ID',
    `mac`        VARCHAR(32) NULL COMMENT '设备MAC',
    `param`      VARCHAR(200) NULL COMMENT '参数',
    `result`     VARCHAR(200) NULL COMMENT '注册结果',
    `status`     CHAR(1) NULL COMMENT '操作结果，0:成功,1:失败,2:异常',
    `waste`      VARCHAR(8) NULL COMMENT '耗时,单位:ms',
    `createtime` DATETIME NULL COMMENT '创建时间',
    PRIMARY KEY (`id`)
) COMMENT = '注册日志表';


ALTER TABLE `forward`.`dev_config`
    ADD COLUMN `local_address` VARCHAR(45) NULL COMMENT '医院数据对接服务地址' AFTER `mqtt_topic`,
ADD COLUMN `local_port` INT NULL COMMENT '医院数据对接服务端口' AFTER `local_address`;