-- 工位客户端 JAR/EXE 升级包
CREATE TABLE IF NOT EXISTS `mes_client_upgrade` (
  `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'id',
  `version` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'version',
  `line_sn` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'line sn',
  `oprno` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'station oprno',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'update content',
  `state` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT 'state',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'create by',
  `create_date` datetime NOT NULL COMMENT 'create date',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT 'update by',
  `update_date` datetime NOT NULL COMMENT 'update date',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_mes_client_upgrade_match` (`state`, `line_sn`, `oprno`, `version`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'client upgrade package' ROW_FORMAT = DYNAMIC;

-- 系统设置 / 客户端版本上传（可从工位管理「JAR管理」进入，菜单用于全局包）
INSERT INTO `js_sys_menu`
SELECT
'2092800000000000001', '1582259828007895040', '0,1582259822626603008,1582259828007895040,',
160, '0000009000,0000000500,0000000160,', '1', 2,
'系统管理/系统设置/客户端版本上传', '客户端版本上传', '1', '/mes/mesClientUpgrade/list',
'', '', '', '', 'mes:mesLineProcess:view,mes:mesLineProcess:edit',
40, '1', 'default', 'core', NULL, NULL, '0',
'system', NOW(), 'system', NOW(),
'', '', '', '', '', '', '', '', '',
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM `js_sys_menu` WHERE `menu_code` = '2092800000000000001');

INSERT INTO `js_sys_role_menu` (`role_code`, `menu_code`)
SELECT rm.`role_code`, '2092800000000000001'
FROM `js_sys_role_menu` rm
WHERE rm.`menu_code` = '1669223760170397696'
  AND NOT EXISTS (
    SELECT 1 FROM `js_sys_role_menu` x
    WHERE x.`role_code` = rm.`role_code`
      AND x.`menu_code` = '2092800000000000001'
  );