mescloud/db/mysql/create_mes_client_upgrade.sql

CREATE TABLE IF NOT EXISTS `mes_client_upgrade` (
  `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'id',
  `version` int(11) 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;