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
| -- 种子质检四项合格范围模板。初检与复检可修改本次范围，按实际提交值判定。
| CREATE TABLE IF NOT EXISTS mes_qc_seed_indicator_range (
| indicator_code varchar(32) NOT NULL COMMENT 'purity/cleanliness/germination_rate/moisture',
| min_value decimal(18,6) NOT NULL COMMENT '合格下限，含边界',
| max_value decimal(18,6) NOT NULL COMMENT '合格上限，含边界',
| creator varchar(64) DEFAULT '',
| create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
| updater varchar(64) DEFAULT '',
| update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
| deleted bit(1) NOT NULL DEFAULT b'0',
| PRIMARY KEY (indicator_code)
| ) ENGINE=InnoDB COMMENT='种子质检项合格范围配置';
|
| INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
| SELECT '质检项合格范围配置', '', 2, 10, 5500, 'seed-range', 'ep:data-analysis', 'mes/qc/seedRange/index', 'MesQcSeedRange', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM system_menu WHERE parent_id = 5500 AND path = 'seed-range' AND deleted = b'0');
|
| INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
| SELECT '查询', 'mes:qc-seed-range:query', 3, 1, id, '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| FROM system_menu WHERE parent_id = 5500 AND path = 'seed-range' AND deleted = b'0'
| AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id = system_menu.id AND m.permission = 'mes:qc-seed-range:query' AND m.deleted = b'0');
| INSERT INTO system_menu (name, permission, type, sort, parent_id, path, icon, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted)
| SELECT '修改', 'mes:qc-seed-range:update', 3, 2, id, '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'
| FROM system_menu WHERE parent_id = 5500 AND path = 'seed-range' AND deleted = b'0'
| AND NOT EXISTS (SELECT 1 FROM system_menu m WHERE m.parent_id = system_menu.id AND m.permission = 'mes:qc-seed-range:update' AND m.deleted = b'0');
|
|
