alter table sys_reagent add column deadline int(11) default 0 comment '货期(天数)';

INSERT INTO `base_meta_group` (`id`, `name`, `order_index`, `create_time`, `update_time`, `edit_flag`, `valid_flag`)
VALUES
('sync_reagent_recorder', '接口同步时间', 0, NULL, NULL, 1, 1);

INSERT INTO `base_meta` (`id`, `group_id`, `meta_key`, `meta_value`, `order_index`, `memo`, `create_time`, `update_time`, `valid_flag`)
VALUES
	('syncreagentflowlastdata', 'sync_reagent_recorder', 'sync_reagent_flow_lastdata', '2018-04-25 21:52:01', 0, '', '2017-11-29 18:42:50', '2018-04-25 21:52:36', 1),
	('syncreagentstatuslastdata', 'sync_reagent_recorder', 'sync_reagent_status_lastdata', '2018-04-25 21:41:49', 0, '', '2017-11-29 18:42:50', '2018-04-25 21:41:53', 1),
	('syncsensorslastdata', 'sync_reagent_recorder', 'sync_sensors_lastdata', '2018-04-25 21:54:37', 0, '', '2017-11-29 18:42:50', '2018-04-25 21:54:50', 1);


create table sys_container_sensors (
	`id` varchar(32) NOT NULL DEFAULT '' COMMENT '主键ID',
	`container_id` varchar(32) DEFAULT NULL COMMENT '货柜ID',
	`temp` double comment '温度值',
	`humidity` int(11) comment '湿度值',
	`voc1` int(11) comment '气体浓度',
	`flag` varchar(30) comment '报警信息 0表示没有报警，非0值看哪些比特位被置位，定义如下：Bit0：温度低报警; Bit1：温度高报警; Bit2：湿度低报警; Bit3：湿度高报警; Bit4：VOC1',
	`type` tinyint(4) comment '1:sys_laboratory_container 2:sys_warehouse_container',
 	`update_time` timestamp NULL DEFAULT NULL COMMENT '更新时间',
	  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


update base_page set level_index = level_index+1 where level_index>=4;

INSERT INTO `base_page` (`id`, `parent_id`, `name`, `level_type`, `level_index`, `valid_flag`, `create_time`, `update_time`)
VALUES
	('container_status_mng', NULL, '试剂柜状态管理', NULL, 5, 1, '2017-11-18 11:23:00', '2017-11-18 11:23:00');


INSERT INTO `base_role_page` (`id`, `role_id`, `page_id`)
VALUES
	('53c088d7a12e49638ae4fc843a4', '15fc90a1f7bf43bda01313904b543195', 'container_status_mng');