/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Type : MySQL Source Server Version : 50528 Source Host : localhost:3306 Source Schema : Haojing Target Server Type : MySQL Target Server Version : 50528 File Encoding : 65001 Date: 19/11/2021 17:23:19 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for gmms_load_rack -- ---------------------------- DROP TABLE IF EXISTS `gmms_load_rack`; CREATE TABLE `gmms_load_rack` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `rack_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `number` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号', `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态', `out_tasks_id` bigint(20) NULL DEFAULT NULL, `machine_load_id` bigint(20) NULL DEFAULT NULL, `machine_secondrelay_id` bigint(20) NULL DEFAULT NULL, `exist_glass` int(11) NOT NULL COMMENT '该接力装置是否存在玻璃标志位', `flag` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '启用', `out_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `in_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `machine_id`(`machine_load_id`) USING BTREE, INDEX `gmms_load_rack_ibfk_2`(`out_tasks_id`) USING BTREE, INDEX `machine_secondrelay_id`(`machine_secondrelay_id`) USING BTREE, CONSTRAINT `gmms_load_rack_ibfk_3` FOREIGN KEY (`machine_secondrelay_id`) REFERENCES `gmms_machine` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `gmms_load_rack_ibfk_1` FOREIGN KEY (`machine_load_id`) REFERENCES `gmms_machine` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `gmms_load_rack_ibfk_2` FOREIGN KEY (`out_tasks_id`) REFERENCES `gmms_out_tasks` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of gmms_load_rack -- ---------------------------- INSERT INTO `gmms_load_rack` VALUES (1, '上片台1', '1101', '空闲', NULL, 15, 2, 599, '启用', '0002', '0001'); INSERT INTO `gmms_load_rack` VALUES (2, '上片台1', '1102', '使用中', 3, 15, 2, 597, '启用', '0004', '0003'); INSERT INTO `gmms_load_rack` VALUES (3, '上片台2', '1103', '使用中', 7, 16, 3, 595, '启用', '0002', '0001'); INSERT INTO `gmms_load_rack` VALUES (4, '上片台2', '1104', '空闲', NULL, 16, 3, 593, '启用', '0004', '0003'); INSERT INTO `gmms_load_rack` VALUES (5, '上片台3', '1105', '使用中', 1, 17, 4, 607, '启用', '0002', '0001'); INSERT INTO `gmms_load_rack` VALUES (6, '上片台3', '1106', '使用中', 4, 17, 4, 605, '启用', '0004', '0003'); INSERT INTO `gmms_load_rack` VALUES (7, '上片台4', '1107', '空闲', NULL, 18, 5, 603, '启用', '0002', '0001'); INSERT INTO `gmms_load_rack` VALUES (8, '上片台4', '1108', '使用中', 5, 18, 5, 601, '启用', '0004', '0003'); INSERT INTO `gmms_load_rack` VALUES (9, '上片台5', '1109', '使用中', 2, 19, 6, 615, '启用', '0002', '0001'); INSERT INTO `gmms_load_rack` VALUES (10, '上片台5', '1110', '空闲', NULL, 19, 6, 613, '启用', '0004', '0003'); INSERT INTO `gmms_load_rack` VALUES (11, '上片台6', '1111', '空闲', NULL, 20, 7, 611, '启用', '0002', '0001'); INSERT INTO `gmms_load_rack` VALUES (12, '上片台6', '1112', '空闲', NULL, 20, 7, 609, '启用', '0004', '0003'); INSERT INTO `gmms_load_rack` VALUES (13, '上片台7', '1113', '空闲', NULL, 21, 8, 623, '启用', '0002', '0001'); INSERT INTO `gmms_load_rack` VALUES (14, '上片台7', '1114', '空闲', NULL, 21, 8, 621, '启用', '0004', '0003'); INSERT INTO `gmms_load_rack` VALUES (15, '990', '990', '空闲', NULL, NULL, NULL, 0, '启用', '', ''); INSERT INTO `gmms_load_rack` VALUES (16, '991', '991', '空闲', NULL, NULL, NULL, 0, '启用', '', ''); INSERT INTO `gmms_load_rack` VALUES (17, '992', '992', '空闲', NULL, NULL, NULL, 0, '启用', '', ''); INSERT INTO `gmms_load_rack` VALUES (18, '993', '993', '空闲', NULL, NULL, NULL, 0, '启用', '', ''); -- ---------------------------- -- Table structure for gmms_machine -- ---------------------------- DROP TABLE IF EXISTS `gmms_machine`; CREATE TABLE `gmms_machine` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '机器编号', `telecoms_id` bigint(20) NOT NULL, `type_id` bigint(20) NOT NULL COMMENT '机器类型', `work_state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工作状态', `flag` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '启动标志', `rank` int(11) NOT NULL COMMENT '序号', `mode_select` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模式选择', `key_log` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '5,20-0,10', PRIMARY KEY (`id`) USING BTREE, INDEX `type`(`type_id`) USING BTREE, INDEX `telecoms_id`(`telecoms_id`) USING BTREE, CONSTRAINT `gmms_machine_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `gmms_machine_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `gmms_machine_ibfk_2` FOREIGN KEY (`telecoms_id`) REFERENCES `gmms_telecoms` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of gmms_machine -- ---------------------------- INSERT INTO `gmms_machine` VALUES (1, '仓储', 1, 1, '等待中', '启用', 0, '', '5,20-0,10'); INSERT INTO `gmms_machine` VALUES (2, '接力装置1', 2, 8, '等待中', '启用', 0, '', '0,10-311,551-310,551'); INSERT INTO `gmms_machine` VALUES (3, '接力装置2', 2, 8, '等待中', '启用', 0, '', '1,11-309,550-308,550'); INSERT INTO `gmms_machine` VALUES (4, '接力装置3', 2, 8, '等待中', '启用', 0, '', '2,12-307,549-306,549'); INSERT INTO `gmms_machine` VALUES (5, '接力装置4', 2, 8, '等待中', '启用', 0, '', '3,13-305,548-304,548'); INSERT INTO `gmms_machine` VALUES (6, '接力装置5', 2, 8, '等待中', '启用', 0, '', '4,14-318,547-317,547'); INSERT INTO `gmms_machine` VALUES (7, '接力装置6', 2, 8, '等待中', '启用', 0, '', '5,15-316,546-315,546'); INSERT INTO `gmms_machine` VALUES (8, '接力装置7', 2, 8, '等待中', '启用', 0, '', '6,16-314,545-313,545'); INSERT INTO `gmms_machine` VALUES (15, '上片台1', 3, 2, '等待中', '启用', 0, '', '5,20-0,10'); INSERT INTO `gmms_machine` VALUES (16, '上片台2', 4, 2, '等待中', '启用', 0, '', '5,20-0,10'); INSERT INTO `gmms_machine` VALUES (17, '上片台3', 5, 2, '等待中', '启用', 0, '', '5,20-0,10'); INSERT INTO `gmms_machine` VALUES (18, '上片台4', 6, 2, '等待中', '启用', 0, '', '5,20-0,10'); INSERT INTO `gmms_machine` VALUES (19, '上片台5', 7, 2, '等待中', '启用', 0, '', '5,20-0,10'); INSERT INTO `gmms_machine` VALUES (20, '上片台6', 8, 2, '等待中', '启用', 0, '', '5,20-0,10'); INSERT INTO `gmms_machine` VALUES (21, '上片台7', 9, 2, '等待中', '启用', 0, '', '5,20-0,10'); -- ---------------------------- -- Table structure for gmms_machine_dispose -- ---------------------------- DROP TABLE IF EXISTS `gmms_machine_dispose`; CREATE TABLE `gmms_machine_dispose` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `type_id` bigint(20) NOT NULL, `machine_id` bigint(20) NULL DEFAULT NULL, `font_flag` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `font_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `font_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `return_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `describ` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `send_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '发送内容', `exe_logic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '描述', PRIMARY KEY (`id`) USING BTREE, INDEX `machineid`(`type_id`) USING BTREE, CONSTRAINT `gmms_machine_dispose_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `gmms_machine_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 80 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of gmms_machine_dispose -- ---------------------------- INSERT INTO `gmms_machine_dispose` VALUES (1, 1, NULL, '0,10', '0001,0000', 'font', '0001', 'PLC发送请求,查找任务', '', '任务发送'); INSERT INTO `gmms_machine_dispose` VALUES (2, 1, NULL, '0,10', '0001,0001', 'font', '0000', 'PLC收到任务,清空任务', '', '发送清除'); INSERT INTO `gmms_machine_dispose` VALUES (3, 1, NULL, '5,20', '0001,0000', 'font', '0001', 'PLC自动汇报完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (4, 1, NULL, '5,20', '0002,0000', 'font', '0002', 'PLC完成失败', '', '完成失败'); INSERT INTO `gmms_machine_dispose` VALUES (5, 1, NULL, '5,20', '0003,0000', 'font', '0003', 'PLC手动汇报完成', '', '手动完成'); INSERT INTO `gmms_machine_dispose` VALUES (6, 1, NULL, '5,20', '0000,0001', 'font', '0000', '正常：完成清空', '', '完成清除'); INSERT INTO `gmms_machine_dispose` VALUES (7, 1, NULL, '5,20', '0000,0002', 'font', '0000', '失败：完成清空', '', '完成清除'); INSERT INTO `gmms_machine_dispose` VALUES (8, 1, NULL, '5,20', '0000,0003', 'font', '0000', '手动：完成清空', '', '完成清除'); INSERT INTO `gmms_machine_dispose` VALUES (9, 2, NULL, '0,10', '0001,0000', 'font', '0001', 'PLC发送请求,查找任务', '', '任务发送'); INSERT INTO `gmms_machine_dispose` VALUES (10, 2, NULL, '0,10', '0001,0001', 'font', '0000', 'PLC收到任务,清空任务', '', '清空发送'); INSERT INTO `gmms_machine_dispose` VALUES (11, 2, NULL, '5,20', '0001,0000', 'font', '0001', 'PLC汇报完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (12, 2, NULL, '5,20', '0002,0000', 'font', '0002', 'PLC手动汇报失败', '', '任务失败'); INSERT INTO `gmms_machine_dispose` VALUES (13, 2, NULL, '5,20', '0003,0000', 'font', '0003', 'PLC手动汇报破损', '', '任务破损'); INSERT INTO `gmms_machine_dispose` VALUES (14, 2, NULL, '5,20', '0000,0001', 'font', '0000', 'PLC完成清空', '', '完成清空'); INSERT INTO `gmms_machine_dispose` VALUES (15, 2, NULL, '5,20', '0000,0002', 'font', '0000', 'PLC失败清空', '', '完成清空'); INSERT INTO `gmms_machine_dispose` VALUES (16, 2, NULL, '5,20', '0000,0003', 'font', '0000', 'PLC破损清空', '', '完成清空'); INSERT INTO `gmms_machine_dispose` VALUES (17, 8, 2, '0,10', '0000,0000', 'font', '0001,0002,0003,0004', 'PLC一号二次接力空闲,查找任务', '', '任务发送'); INSERT INTO `gmms_machine_dispose` VALUES (18, 8, 2, '0,10', '0001,0001', 'font', '0000', 'PLC一号二次接力汇报二次接力1>上片位1，完成', '', '任务完成1'); INSERT INTO `gmms_machine_dispose` VALUES (19, 8, 2, '0,10', '0002,0002', 'font', '0000', 'PLC一号二次接力汇报上片位1>二次接力1，完成', '', '任务完成1'); INSERT INTO `gmms_machine_dispose` VALUES (20, 8, 2, '0,10', '0003,0003', 'font', '0000', 'PLC一号二次接力汇报二次接力2>上片位2，完成', '', '任务完成2'); INSERT INTO `gmms_machine_dispose` VALUES (21, 8, 2, '0,10', '0004,0004', 'font', '0000', 'PLC一号二次接力汇报上片位2>二次接力2，完成', '', '任务完成2'); INSERT INTO `gmms_machine_dispose` VALUES (22, 8, 2, '311,551', '0,0', 'byte', '1', 'PLC一号二次接力空闲，取间隔条', '', '亮灯发送1'); INSERT INTO `gmms_machine_dispose` VALUES (23, 8, 2, '311,551', '1,1', 'byte', '0', 'PLC一号二次接力完成，取间隔条', '', '亮灯清除1'); INSERT INTO `gmms_machine_dispose` VALUES (24, 8, 2, '310,551', '0,0', 'byte', '1', 'PLC一号二次接力空闲，取间隔条', '', '亮灯发送2'); INSERT INTO `gmms_machine_dispose` VALUES (25, 8, 2, '310,551', '1,1', 'byte', '0', 'PLC一号二次接力完成，取间隔条', '', '亮灯清除2'); INSERT INTO `gmms_machine_dispose` VALUES (26, 8, 3, '1,11', '0000,0000', 'font', '0001,0002,0003,0004', 'PLC二号二次接力空闲,查找任务', '', '任务发送'); INSERT INTO `gmms_machine_dispose` VALUES (27, 8, 3, '1,11', '0001,0001', 'font', '0000', 'PLC二号二次接力汇报二次接力1>上片位1，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (28, 8, 3, '1,11', '0002,0002', 'font', '0000', 'PLC二号二次接力汇报上片位1>二次接力1，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (29, 8, 3, '1,11', '0003,0003', 'font', '0000', 'PLC二号二次接力汇报二次接力2>上片位2，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (30, 8, 3, '1,11', '0004,0004', 'font', '0000', 'PLC二号二次接力汇报上片位2>二次接力2，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (31, 8, 3, '309,550', '0,0', 'byte', '1', 'PLC二号二次接力空闲，取间隔条', '', '亮灯发送1'); INSERT INTO `gmms_machine_dispose` VALUES (32, 8, 3, '309,550', '1,1', 'byte', '0', 'PLC二号二次接力完成，取间隔条', '', '亮灯清除1'); INSERT INTO `gmms_machine_dispose` VALUES (33, 8, 3, '308,550', '0,0', 'byte', '1', 'PLC二号二次接力空闲，取间隔条', '', '亮灯发送2'); INSERT INTO `gmms_machine_dispose` VALUES (34, 8, 3, '308,550', '1,1', 'byte', '0', 'PLC二号二次接力完成，取间隔条', '', '亮灯清除2'); INSERT INTO `gmms_machine_dispose` VALUES (35, 8, 4, '2,12', '0000,0000', 'font', '0001,0002,0003,0004', 'PLC三号二次接力空闲,查找任务', '', '任务发送'); INSERT INTO `gmms_machine_dispose` VALUES (36, 8, 4, '2,12', '0001,0001', 'font', '0000', 'PLC三号二次接力汇报二次接力1>上片位1，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (37, 8, 4, '2,12', '0002,0002', 'font', '0000', 'PLC三号二次接力汇报上片位1>二次接力1，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (38, 8, 4, '2,12', '0003,0003', 'font', '0000', 'PLC三号二次接力汇报二次接力2>上片位2，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (39, 8, 4, '2,12', '0004,0004', 'font', '0000', 'PLC三号二次接力汇报上片位2>二次接力2，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (40, 8, 4, '307,549', '0,0', 'byte', '1', 'PLC三号二次接力空闲，取间隔条', '', '亮灯发送1'); INSERT INTO `gmms_machine_dispose` VALUES (41, 8, 4, '307,549', '1,1', 'byte', '0', 'PLC三号二次接力完成，取间隔条', '', '亮灯清除1'); INSERT INTO `gmms_machine_dispose` VALUES (42, 8, 4, '306,549', '0,0', 'byte', '1', 'PLC三号二次接力空闲，取间隔条', '', '亮灯发送2'); INSERT INTO `gmms_machine_dispose` VALUES (43, 8, 4, '306,549', '1,1', 'byte', '0', 'PLC三号二次接力完成，取间隔条', '', '亮灯清除2'); INSERT INTO `gmms_machine_dispose` VALUES (44, 8, 5, '3,13', '0000,0000', 'font', '0001,0002,0003,0004', 'PLC四号二次接力空闲,查找任务', '', '任务发送'); INSERT INTO `gmms_machine_dispose` VALUES (45, 8, 5, '3,13', '0001,0001', 'font', '0000', 'PLC四号二次接力汇报二次接力1>上片位1，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (46, 8, 5, '3,13', '0002,0002', 'font', '0000', 'PLC四号二次接力汇报上片位1>二次接力1，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (47, 8, 5, '3,13', '0003,0003', 'font', '0000', 'PLC四号二次接力汇报二次接力2>上片位2，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (48, 8, 5, '3,13', '0004,0004', 'font', '0000', 'PLC四号二次接力汇报上片位2>二次接力2，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (49, 8, 5, '305,548', '0,0', 'byte', '1', 'PLC四号二次接力空闲，取间隔条', '', '亮灯发送1'); INSERT INTO `gmms_machine_dispose` VALUES (50, 8, 5, '305,548', '1,1', 'byte', '0', 'PLC四号二次接力完成，取间隔条', '', '亮灯清除1'); INSERT INTO `gmms_machine_dispose` VALUES (51, 8, 5, '304,548', '0,0', 'byte', '1', 'PLC四号二次接力空闲，取间隔条', '', '亮灯发送2'); INSERT INTO `gmms_machine_dispose` VALUES (52, 8, 5, '304,548', '1,1', 'byte', '0', 'PLC四号二次接力完成，取间隔条', '', '亮灯清除2'); INSERT INTO `gmms_machine_dispose` VALUES (53, 8, 6, '4,14', '0000,0000', 'font', '0001,0002,0003,0004', 'PLC五号二次接力空闲,查找任务', '', '任务发送'); INSERT INTO `gmms_machine_dispose` VALUES (54, 8, 6, '4,14', '0001,0001', 'font', '0000', 'PLC五号二次接力汇报二次接力1>上片位1，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (55, 8, 6, '4,14', '0002,0002', 'font', '0000', 'PLC五号二次接力汇报上片位1>二次接力1，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (56, 8, 6, '4,14', '0003,0003', 'font', '0000', 'PLC五号二次接力汇报二次接力2>上片位2，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (57, 8, 6, '4,14', '0004,0004', 'font', '0000', 'PLC五号二次接力汇报上片位2>二次接力2，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (58, 8, 6, '318,547', '0,0', 'byte', '1', 'PLC五号二次接力空闲，取间隔条', '', '亮灯发送1'); INSERT INTO `gmms_machine_dispose` VALUES (59, 8, 6, '318,547', '1,1', 'byte', '0', 'PLC五号二次接力完成，取间隔条', '', '亮灯清除1'); INSERT INTO `gmms_machine_dispose` VALUES (60, 8, 6, '317,547', '0,0', 'byte', '1', 'PLC五号二次接力空闲，取间隔条', '', '亮灯发送2'); INSERT INTO `gmms_machine_dispose` VALUES (61, 8, 6, '317,547', '1,1', 'byte', '0', 'PLC五号二次接力完成，取间隔条', '', '亮灯清除2'); INSERT INTO `gmms_machine_dispose` VALUES (62, 8, 7, '5,15', '0000,0000', 'font', '0001,0002,0003,0004', 'PLC六号二次接力空闲,查找任务', '', '任务发送'); INSERT INTO `gmms_machine_dispose` VALUES (63, 8, 7, '5,15', '0001,0001', 'font', '0000', 'PLC六号二次接力汇报二次接力1>上片位1，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (64, 8, 7, '5,15', '0002,0002', 'font', '0000', 'PLC六号二次接力汇报上片位1>二次接力1，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (65, 8, 7, '5,15', '0003,0003', 'font', '0000', 'PLC六号二次接力汇报二次接力2>上片位2，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (66, 8, 7, '5,15', '0004,0004', 'font', '0000', 'PLC六号二次接力汇报上片位2>二次接力2，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (67, 8, 7, '316,546', '0,0', 'byte', '1', 'PLC六号二次接力空闲，取间隔条', '', '亮灯发送1'); INSERT INTO `gmms_machine_dispose` VALUES (68, 8, 7, '316,546', '1,1', 'byte', '0', 'PLC六号二次接力完成，取间隔条', '', '亮灯清除1'); INSERT INTO `gmms_machine_dispose` VALUES (69, 8, 7, '315,546', '0,0', 'byte', '1', 'PLC六号二次接力空闲，取间隔条', '', '亮灯发送2'); INSERT INTO `gmms_machine_dispose` VALUES (70, 8, 7, '315,546', '1,1', 'byte', '0', 'PLC六号二次接力完成，取间隔条', '', '亮灯清除2'); INSERT INTO `gmms_machine_dispose` VALUES (71, 8, 8, '6,16', '0000,0000', 'font', '0001,0002,0003,0004', 'PLC七号二次接力空闲,查找任务', '', '任务发送'); INSERT INTO `gmms_machine_dispose` VALUES (72, 8, 8, '6,16', '0001,0001', 'font', '0000', 'PLC七号二次接力汇报二次接力1>上片位1，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (73, 8, 8, '6,16', '0002,0002', 'font', '0000', 'PLC七号二次接力汇报上片位1>二次接力1，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (74, 8, 8, '6,16', '0003,0003', 'font', '0000', 'PLC七号二次接力汇报二次接力2>上片位2，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (75, 8, 8, '6,16', '0004,0004', 'font', '0000', 'PLC七号二次接力汇报上片位2>二次接力2，完成', '', '任务完成'); INSERT INTO `gmms_machine_dispose` VALUES (76, 8, 8, '314,545', '0,0', 'byte', '1', 'PLC七号二次接力空闲，取间隔条', '', '亮灯发送1'); INSERT INTO `gmms_machine_dispose` VALUES (77, 8, 8, '314,545', '1,1', 'byte', '0', 'PLC七号二次接力完成，取间隔条', '', '亮灯清除1'); INSERT INTO `gmms_machine_dispose` VALUES (78, 8, 8, '313,545', '0,0', 'byte', '1', 'PLC七号二次接力空闲，取间隔条', '', '亮灯发送2'); INSERT INTO `gmms_machine_dispose` VALUES (79, 8, 8, '313,545', '1,1', 'byte', '0', 'PLC七号二次接力完成，取间隔条', '', '亮灯清除2'); -- ---------------------------- -- Table structure for gmms_machine_type -- ---------------------------- DROP TABLE IF EXISTS `gmms_machine_type`; CREATE TABLE `gmms_machine_type` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号', `types_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型名称', `type_model` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模式：集成，单个', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of gmms_machine_type -- ---------------------------- INSERT INTO `gmms_machine_type` VALUES (1, '', 'shelf', '单个'); INSERT INTO `gmms_machine_type` VALUES (2, '', 'load', '单个'); INSERT INTO `gmms_machine_type` VALUES (3, '', 'cut', '单个'); INSERT INTO `gmms_machine_type` VALUES (4, '', 'trant', '单个'); INSERT INTO `gmms_machine_type` VALUES (5, '', 'edge', '单个'); INSERT INTO `gmms_machine_type` VALUES (6, '', 'cham', '单个'); INSERT INTO `gmms_machine_type` VALUES (7, '', 'ident', '单个'); INSERT INTO `gmms_machine_type` VALUES (8, '', 'secondrelay', '集成'); -- ---------------------------- -- Table structure for gmms_out_tasks -- ---------------------------- DROP TABLE IF EXISTS `gmms_out_tasks`; CREATE TABLE `gmms_out_tasks` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `task_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `task_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `mes_status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '派尔状态', `machine_status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '机器状态', `work_status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '工作状态', `pkg_id` int(11) NOT NULL COMMENT '包ID', `stock_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '料架编号', `destination` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '目的地', `plan_load_num1` int(11) NOT NULL, `plan_load_num2` int(11) NOT NULL, `plan_load_num3` int(11) NOT NULL, `stock_num` int(11) NOT NULL, `loade_num` int(11) NOT NULL, `posun_count` int(11) NOT NULL, `new_pkg_id` int(11) NOT NULL, `new_pkg_num` int(11) NOT NULL, `bb` double(255, 0) NOT NULL, `hh` double(255, 0) NOT NULL, `color` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `thickness` double(255, 0) NOT NULL, `pkg_num` int(11) NOT NULL, `stock_thickness` double(255, 0) NOT NULL, `start_time` datetime NOT NULL COMMENT '领取时间', `load_time` datetime NOT NULL COMMENT '上片时间', `finsh_time` datetime NOT NULL COMMENT '完成时间', `flag` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态', `info_content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `rack_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 59 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of gmms_out_tasks -- ---------------------------- INSERT INTO `gmms_out_tasks` VALUES (1, '5708', '在线库到上片台', '派尔确认可退回', '等待退回库区', '等待中', 3090, '53', '上片台3', 8, 0, 0, 16, 8, 0, 0, 0, 4880, 3300, '超白', 6, 16, 96, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '正常', '', ''); INSERT INTO `gmms_out_tasks` VALUES (2, '5738', '在线库到上片台', '派尔确认可退回', '等待退回库区', '等待中', 3084, '20', '上片台5', 5, 0, 0, 26, 5, 0, 0, 0, 4580, 3300, '超白', 8, 7, 408, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '正常', '', ''); INSERT INTO `gmms_out_tasks` VALUES (3, '5737', '在线库到上片台', '派尔确认可退回', '等待退回库区', '等待中', 3570, '15', '上片台1', 1, 0, 0, 9, 1, 0, 0, 0, 4880, 3050, '白玻', 10, 10, 100, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '正常', '', ''); INSERT INTO `gmms_out_tasks` VALUES (4, '5731', '在线库到上片台', '派尔确认可退回', '等待退回库区', '等待中', 3295, '202', '上片台3', 6, 0, 0, 12, 6, 0, 0, 0, 3660, 2440, '超白', 6, 12, 72, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '正常', '', ''); INSERT INTO `gmms_out_tasks` VALUES (5, '5747', '在线库到上片台', '派尔确认可退回', '等待退回库区', '等待中', 3339, '263', '上片台4', 2, 0, 0, 15, 0, 0, 0, 0, 3300, 3050, '白玻', 10, 15, 350, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '正常', '', ''); INSERT INTO `gmms_out_tasks` VALUES (7, '5754', '在线库到上片台', '派尔确认可退回', '等待退回库区', '等待中', 2279, '30', '上片台2', 2, 0, 0, 36, 2, 0, 0, 0, 5500, 1930, '白玻', 8, 18, 338, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '正常', '', ''); -- ---------------------------- -- Table structure for gmms_task -- ---------------------------- DROP TABLE IF EXISTS `gmms_task`; CREATE TABLE `gmms_task` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `title` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `user_id` bigint(20) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of gmms_task -- ---------------------------- INSERT INTO `gmms_task` VALUES (1, 'Study PlayFramework 2.0', 'http://www.playframework.org/', 2); INSERT INTO `gmms_task` VALUES (2, 'Study Grails 2.0', 'http://www.grails.org/', 2); INSERT INTO `gmms_task` VALUES (3, 'Try SpringFuse', 'http://www.springfuse.com/', 2); INSERT INTO `gmms_task` VALUES (4, 'Try Spring Roo', 'http://www.springsource.org/spring-roo', 2); INSERT INTO `gmms_task` VALUES (5, 'Release SpringSide 4.0', 'As soon as posibble.', 2); -- ---------------------------- -- Table structure for gmms_telecoms -- ---------------------------- DROP TABLE IF EXISTS `gmms_telecoms`; CREATE TABLE `gmms_telecoms` ( `id` bigint(20) NOT NULL, `number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ip_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'ip地址', `port` int(11) NOT NULL COMMENT '端口', `serial_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '序列号', `font_size` int(11) NOT NULL COMMENT '数据大小', `message` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '交互数据', `mod_time` datetime NOT NULL COMMENT '交互时间', `conn_state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '连接状态', `interprets` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '翻译', `conn_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '连接类型：机器，接口', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of gmms_telecoms -- ---------------------------- INSERT INTO `gmms_telecoms` VALUES (1, 'plc仓储', '192.168.10.100', 502, '00010000000601030000002D', 45, '000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', '2021-11-19 16:25:37', '无法连接', '', '0'); INSERT INTO `gmms_telecoms` VALUES (2, 'plc二次接力', '192.168.10.154', 502, '00010000000601030000002D', 45, '000000000000000000000200000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', '2021-11-19 16:25:38', '无法连接', '', '0'); INSERT INTO `gmms_telecoms` VALUES (3, 'plc上片机1', '192.168.10.110', 502, '00010000000601030000002D', 45, '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000', '2021-11-19 16:25:38', '无法连接', '', '0'); INSERT INTO `gmms_telecoms` VALUES (4, 'plc上片机2', '192.168.10.114', 502, '00010000000601030000002D', 45, '', '2021-11-19 16:25:38', '无法连接', '', '0'); INSERT INTO `gmms_telecoms` VALUES (5, 'plc上片机3', '192.168.10.118', 502, '00010000000601030000002D', 45, '', '2021-11-19 16:25:39', '无法连接', '', '0'); INSERT INTO `gmms_telecoms` VALUES (6, 'plc上片机4', '192.168.10.122', 502, '00010000000601030000002D', 45, '', '2021-11-19 16:25:39', '无法连接', '', '0'); INSERT INTO `gmms_telecoms` VALUES (7, 'plc上片机5', '192.168.10.126', 502, '00010000000601030000002D', 45, '', '2021-11-19 16:25:39', '无法连接', '', '0'); INSERT INTO `gmms_telecoms` VALUES (8, 'plc上片机6', '192.168.10.130', 502, '00010000000601030000002D', 45, '', '2021-11-19 16:25:40', '无法连接', '', '0'); INSERT INTO `gmms_telecoms` VALUES (9, 'plc上片机7', '192.168.10.134', 502, '00010000000601030000002D', 45, '', '2021-11-19 16:25:40', '无法连接', '', '0'); INSERT INTO `gmms_telecoms` VALUES (10, '派尔', '192.168.3.200', 9006, '', 0, '', '0000-00-00 00:00:00', '连接', '', '1'); -- ---------------------------- -- Table structure for gmms_user -- ---------------------------- DROP TABLE IF EXISTS `gmms_user`; CREATE TABLE `gmms_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `login_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `salt` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `roles` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `groups` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `register_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `login_name`(`login_name`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT; -- ---------------------------- -- Records of gmms_user -- ---------------------------- INSERT INTO `gmms_user` VALUES (1, 'admin', 'admin', '691b14d79bf0fa2215f155235df5e670b64394cc', '7efbd59d9741d34f', 'admin', '1', '2012-06-04 01:00:00'); INSERT INTO `gmms_user` VALUES (2, 'cangchu', 'cangchu', '0b758ab9fb7b358b93961ab047224fda16a8bf6a', 'd04571a0f1ca1a30', 'cangchu', '1', '2012-06-04 02:00:00'); INSERT INTO `gmms_user` VALUES (3, 'qiege', 'qiege', '1f6ca85a796572b9d236e0487521c870a7a60be1', 'fc961ed3a7d9da04', 'qiege', '1', '2012-06-04 02:00:00'); INSERT INTO `gmms_user` VALUES (4, 'qiege2', 'qiege2', '1f6ca85a796572b9d236e0487521c870a7a60be1', 'fc961ed3a7d9da04', 'qiege2', '2', '2012-06-04 02:00:00'); INSERT INTO `gmms_user` VALUES (5, 'hmi', 'hmi', 'cdb74c7e0af74d02b1d8ddb31748f490f325bbad', '56c1988f1539be86', 'hmi', '1', '2012-11-19 02:00:00'); INSERT INTO `gmms_user` VALUES (7, 'xiapian', 'xiapian', 'aa85bd5a296f54105a1180197d400cc0203bcda7', 'ec1f393b29ae0179', 'xiapian', '1', '2012-06-04 02:00:00'); INSERT INTO `gmms_user` VALUES (10, 'xiapian2', 'xiapian2', 'aa85bd5a296f54105a1180197d400cc0203bcda7', 'ec1f393b29ae0179', 'xiapian', '2', '2012-06-04 02:00:00'); INSERT INTO `gmms_user` VALUES (11, 'deng', 'deng', '6012b4887f00534196ef25f16aa883ed95acf95a', '8ce2bb5b403dc6d5', 'user', '1', '2021-05-19 10:09:34'); SET FOREIGN_KEY_CHECKS = 1;