ALTER TABLE `wuhuyancao`.`device`
|
MODIFY COLUMN `door_no` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '门禁点编号' AFTER `install_location`;
|
|
INSERT INTO `wuhuyancao`.`quartz_job` (`id`, `bean_name`, `params`, `cron_expres`, `state`, `remark`, `create_time`, `module`) VALUES (NULL, 'visitServiceJob', '{}', '0 0/5 * * * ? *', 1, '【断路器】开启定时远程控制断路器分闸', '2023-07-26 13:17:17', 'autoCloseCmd');
|
|
|
CREATE TABLE `device_data` (
|
`ID` int NOT NULL AUTO_INCREMENT COMMENT '主键',
|
`CREATOR` int DEFAULT NULL COMMENT '创建人编码',
|
`CREATE_DATE` datetime DEFAULT NULL COMMENT '创建时间',
|
`EDITOR` int DEFAULT NULL COMMENT '更新人编码',
|
`EDIT_DATE` datetime DEFAULT NULL COMMENT '更新时间',
|
`ISDELETED` int DEFAULT NULL COMMENT '是否删除0否 1是',
|
`REMARK` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
|
`DATA_JSON` text COLLATE utf8mb4_unicode_ci COMMENT '数据json对象',
|
`DEVICE_ID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '设备编码（关联device)',
|
`HAPPEN_TIME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '发生时间',
|
`VAL1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '属性值1',
|
`VAL2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '属性值2',
|
`VAL3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '属性值3',
|
`VAL4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '属性值4',
|
`VAL5` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '属性值5',
|
`VAL6` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '属性值6',
|
`DATA_TYPE` int DEFAULT NULL COMMENT '数据来源 0mqtt上报 1其他',
|
PRIMARY KEY (`ID`),
|
UNIQUE KEY `eventIdnex` (`DEVICE_ID`,`HAPPEN_TIME`) USING BTREE
|
) ENGINE=InnoDB AUTO_INCREMENT=106097 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='门禁事件推送记录表';
|
