1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
| 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');
|
|
