/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50528 Source Host : localhost:3306 Source Database : gmms_chd Target Server Type : MYSQL Target Server Version : 50528 File Encoding : 65001 Date: 2021-01-31 19:03:40 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `gmms_arrange_machine` -- ---------------------------- DROP TABLE IF EXISTS `gmms_arrange_machine`; CREATE TABLE `gmms_arrange_machine` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `connect_state` varchar(50) DEFAULT NULL, `picture_url` varchar(255) DEFAULT NULL, `port` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_arrange_machine -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_arrange_machine_rank` -- ---------------------------- DROP TABLE IF EXISTS `gmms_arrange_machine_rank`; CREATE TABLE `gmms_arrange_machine_rank` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `toughening_glass_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `toughening_glass_id` (`toughening_glass_id`), CONSTRAINT `gmms_arrange_machine_rank_ibfk_1` FOREIGN KEY (`toughening_glass_id`) REFERENCES `gmms_toughening_glass` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_arrange_machine_rank -- ---------------------------- INSERT INTO `gmms_arrange_machine_rank` VALUES ('1', '01', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('2', '02', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('3', '03', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('4', '04', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('5', '05', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('6', '06', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('7', '07', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('8', '08', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('9', '09', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('10', '10', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('11', '11', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('12', '12', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('13', '13', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('14', '14', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('15', '15', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('16', '16', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('17', '17', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('18', '18', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('19', '19', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('20', '20', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('21', '21', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('22', '22', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('23', '23', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('24', '24', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('25', '25', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('26', '26', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('27', '27', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('28', '28', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('29', '29', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('30', '30', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('31', '31', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('32', '32', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('33', '33', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('34', '34', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('35', '35', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('36', '36', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('37', '37', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('38', '38', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('39', '39', null, null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('40', '40', null, null); -- ---------------------------- -- Table structure for `gmms_arrange_machine_statu` -- ---------------------------- DROP TABLE IF EXISTS `gmms_arrange_machine_statu`; CREATE TABLE `gmms_arrange_machine_statu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `state` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_arrange_machine_statu -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_arrange_machine_task` -- ---------------------------- DROP TABLE IF EXISTS `gmms_arrange_machine_task`; CREATE TABLE `gmms_arrange_machine_task` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `state` varchar(50) DEFAULT NULL, `goals` varchar(50) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `complete_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `task_type` varchar(50) DEFAULT NULL, `toughening_glass_id` bigint(20) DEFAULT NULL, `measure_machine_id` bigint(20) DEFAULT NULL, `arrange_machine_rank_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `toughening_glass_id` (`toughening_glass_id`), KEY `measure_machine_id` (`measure_machine_id`), KEY `arrange_machine_rank_id` (`arrange_machine_rank_id`), CONSTRAINT `gmms_arrange_machine_task_ibfk_1` FOREIGN KEY (`toughening_glass_id`) REFERENCES `gmms_toughening_glass` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_arrange_machine_task_ibfk_2` FOREIGN KEY (`measure_machine_id`) REFERENCES `gmms_measure_machine` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_arrange_machine_task_ibfk_3` FOREIGN KEY (`arrange_machine_rank_id`) REFERENCES `gmms_arrange_machine_rank` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_arrange_machine_task -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_break_report` -- ---------------------------- DROP TABLE IF EXISTS `gmms_break_report`; CREATE TABLE `gmms_break_report` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `opt_batch` varchar(50) DEFAULT NULL, `glass_id` varchar(50) DEFAULT NULL, `width` double DEFAULT NULL, `height` double DEFAULT NULL, `thickness` double DEFAULT NULL, `color` varchar(50) DEFAULT NULL, `loadmachine_number` varchar(5) DEFAULT NULL, `break_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_break_report -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_card_number` -- ---------------------------- DROP TABLE IF EXISTS `gmms_card_number`; CREATE TABLE `gmms_card_number` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_card_number -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_count_machine` -- ---------------------------- DROP TABLE IF EXISTS `gmms_count_machine`; CREATE TABLE `gmms_count_machine` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `connect_state` varchar(50) DEFAULT NULL, `port` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_count_machine -- ---------------------------- INSERT INTO `gmms_count_machine` VALUES ('1', '01', '停机中', '正在连接', '502'); -- ---------------------------- -- Table structure for `gmms_count_machine_copy` -- ---------------------------- DROP TABLE IF EXISTS `gmms_count_machine_copy`; CREATE TABLE `gmms_count_machine_copy` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `connect_state` varchar(50) DEFAULT NULL, `port` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_count_machine_copy -- ---------------------------- INSERT INTO `gmms_count_machine_copy` VALUES ('1', '01', '停机中', '正在连接', '502'); -- ---------------------------- -- Table structure for `gmms_count_machine_task` -- ---------------------------- DROP TABLE IF EXISTS `gmms_count_machine_task`; CREATE TABLE `gmms_count_machine_task` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `state` varchar(50) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `complete_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `length` double DEFAULT NULL, `width` double DEFAULT NULL, `apart` varchar(50) DEFAULT NULL, `count_machine_id` bigint(20) DEFAULT NULL, `glass_id` bigint(20) DEFAULT NULL, `raw_package_txt_id` bigint(20) DEFAULT NULL, `info_id` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `glass_id` (`glass_id`), KEY `count_machine_id` (`count_machine_id`), KEY `raw_package_txt_id` (`raw_package_txt_id`), CONSTRAINT `gmms_count_machine_task_ibfk_1` FOREIGN KEY (`glass_id`) REFERENCES `gmms_glass` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_count_machine_task_ibfk_2` FOREIGN KEY (`count_machine_id`) REFERENCES `gmms_count_machine` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_count_machine_task_ibfk_3` FOREIGN KEY (`raw_package_txt_id`) REFERENCES `gmms_raw_package_txt` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=205 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_count_machine_task -- ---------------------------- INSERT INTO `gmms_count_machine_task` VALUES ('204', '已完成', null, '2020-04-17 09:51:34', '2020-04-17 09:47:56', '2020-04-17 09:47:53', '1334', '1445', '1', '1', null, null, '00e3'); -- ---------------------------- -- Table structure for `gmms_cut_machine` -- ---------------------------- DROP TABLE IF EXISTS `gmms_cut_machine`; CREATE TABLE `gmms_cut_machine` ( `ip_address` varchar(50) DEFAULT NULL, `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `connect_state` varchar(50) DEFAULT NULL, `picture_url` varchar(255) DEFAULT NULL, `port` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_cut_machine -- ---------------------------- INSERT INTO `gmms_cut_machine` VALUES ('192.168.1.21', '1', '01', '设备停止', '未连接', null, '502'); INSERT INTO `gmms_cut_machine` VALUES ('192.168.1.22', '2', '02', '设备停止', '未连接', null, '502'); -- ---------------------------- -- Table structure for `gmms_cut_machine_message` -- ---------------------------- DROP TABLE IF EXISTS `gmms_cut_machine_message`; CREATE TABLE `gmms_cut_machine_message` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `cut_machine_id` bigint(20) DEFAULT NULL, `reada` tinyint(1) DEFAULT NULL, `message_type` varchar(50) DEFAULT NULL, `client_address` varchar(255) DEFAULT NULL, `client_port` varchar(10) DEFAULT NULL, `content` varchar(5000) DEFAULT NULL, `send_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `receive_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `cut_machine_id` (`cut_machine_id`), CONSTRAINT `gmms_cut_machine_message_ibfk_1` FOREIGN KEY (`cut_machine_id`) REFERENCES `gmms_cut_machine` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_cut_machine_message -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_cut_machine_task` -- ---------------------------- DROP TABLE IF EXISTS `gmms_cut_machine_task`; CREATE TABLE `gmms_cut_machine_task` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `state` varchar(50) DEFAULT NULL, `message` varchar(255) DEFAULT NULL, `cut_machine_id` bigint(20) DEFAULT NULL, `load_machine_id` bigint(20) DEFAULT NULL, `opt_pattern_id` bigint(20) DEFAULT NULL, `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `complete_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `opt_pattern_id` (`opt_pattern_id`), KEY `load_machine_id` (`load_machine_id`), KEY `cut_machine_id` (`cut_machine_id`), CONSTRAINT `gmms_cut_machine_task_ibfk_1` FOREIGN KEY (`opt_pattern_id`) REFERENCES `gmms_opt_pattern` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_cut_machine_task_ibfk_2` FOREIGN KEY (`load_machine_id`) REFERENCES `gmms_load_machine` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_cut_machine_task_ibfk_3` FOREIGN KEY (`cut_machine_id`) REFERENCES `gmms_cut_machine` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_cut_machine_task -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_edge_machine` -- ---------------------------- DROP TABLE IF EXISTS `gmms_edge_machine`; CREATE TABLE `gmms_edge_machine` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `connect_state` varchar(50) DEFAULT NULL, `ip_address` varchar(50) DEFAULT NULL, `port` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_edge_machine -- ---------------------------- INSERT INTO `gmms_edge_machine` VALUES ('1', '01', '等待中', null, '192.168.2.31', '502'); -- ---------------------------- -- Table structure for `gmms_film_remove_machine` -- ---------------------------- DROP TABLE IF EXISTS `gmms_film_remove_machine`; CREATE TABLE `gmms_film_remove_machine` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `connect_state` varchar(50) DEFAULT NULL, `picture_url` varchar(255) DEFAULT NULL, `port` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_film_remove_machine -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_gaoliwei_machine` -- ---------------------------- DROP TABLE IF EXISTS `gmms_gaoliwei_machine`; CREATE TABLE `gmms_gaoliwei_machine` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `connect_state` varchar(50) DEFAULT NULL, `port` int(11) DEFAULT NULL, `ip_address` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_gaoliwei_machine -- ---------------------------- INSERT INTO `gmms_gaoliwei_machine` VALUES ('1', '01', '停机中', '正在连接', '502', '192.168.1.120'); -- ---------------------------- -- Table structure for `gmms_gaoliwei_statu` -- ---------------------------- DROP TABLE IF EXISTS `gmms_gaoliwei_statu`; CREATE TABLE `gmms_gaoliwei_statu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `messagetype` varchar(50) DEFAULT NULL, `glassid` varchar(50) DEFAULT NULL, `plcid` varchar(50) DEFAULT NULL, `mesid` varchar(50) DEFAULT NULL, `set_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `message` varchar(500) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_gaoliwei_statu -- ---------------------------- INSERT INTO `gmms_gaoliwei_statu` VALUES ('1', '0000', '0', '0', '0', '2020-04-21 11:51:42', '00025222555'); -- ---------------------------- -- Table structure for `gmms_glass` -- ---------------------------- DROP TABLE IF EXISTS `gmms_glass`; CREATE TABLE `gmms_glass` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `glass_id` int(11) DEFAULT NULL, `length` double DEFAULT NULL, `width` double DEFAULT NULL, `startlength` double DEFAULT NULL, `startwidth` double DEFAULT NULL, `thickness` double DEFAULT NULL, `color` varchar(25) DEFAULT NULL, `customer` varchar(255) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `groups` varchar(50) DEFAULT NULL, `apart_id` varchar(50) DEFAULT NULL, `manufacture_batch` varchar(255) DEFAULT NULL, `pieces` int(11) DEFAULT NULL, `complete_pieces` int(11) DEFAULT NULL, `damage_pieces` int(11) DEFAULT NULL, `arrange_pieces` int(11) DEFAULT NULL, `arrange_statu` varchar(50) DEFAULT NULL, `raw_package_txt_id` bigint(20) DEFAULT NULL, `application` varchar(50) DEFAULT NULL, `production` varchar(50) DEFAULT NULL, `floor_number` varchar(50) DEFAULT NULL, `order_number` varchar(50) DEFAULT NULL, `piece_sign` varchar(50) DEFAULT NULL, `remark` varchar(50) DEFAULT NULL, `send_state` varchar(50) DEFAULT NULL, `send_states` varchar(50) DEFAULT NULL, `thingsout` varchar(100) DEFAULT NULL COMMENT '出处', PRIMARY KEY (`id`), KEY `raw_package_txt_id` (`raw_package_txt_id`), CONSTRAINT `gmms_glass_ibfk_1` FOREIGN KEY (`raw_package_txt_id`) REFERENCES `gmms_raw_package_txt` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4057907 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_glass -- ---------------------------- INSERT INTO `gmms_glass` VALUES ('4057900', '0', '1022', '1500', '1022', '1500', '12', 'C', '张学军', '待识别', '', 'A1', '4244', '2', '1', '1', '0', '待识别', '18', '', '12厘钢化', '', '1', 'A', '', '未发送', '未发送', null); INSERT INTO `gmms_glass` VALUES ('4057901', '0', '830', '1790', '830', '1790', '12', 'C', '于海泉', '待识别', '', 'A1', '4244', '1', '0', '0', '0', '待识别', '18', '', '12厘钢化', '', '1', 'A', '', '未发送', '未发送', null); INSERT INTO `gmms_glass` VALUES ('4057902', '0', '784', '2295', '784', '2295', '12', 'C', '薛柏森', '待识别', '', 'A1', '4244', '1', '0', '0', '0', '待识别', '18', '', '12厘钢化', '', '3', 'A', '', '未发送', '未发送', null); INSERT INTO `gmms_glass` VALUES ('4057903', '0', '784', '2280', '784', '2280', '12', 'C', '薛柏森', '待识别', '', 'A1', '4244', '1', '0', '0', '0', '待识别', '18', '', '12厘钢化', '', '4', 'A', '', '未发送', '未发送', null); INSERT INTO `gmms_glass` VALUES ('4057904', '0', '1750', '2240', '1750', '2240', '12', 'C', '薛柏森', '待识别', '', 'A1', '4244', '1', '0', '0', '0', '待识别', '18', '', '12厘钢化', '', '2', 'A', '', '未发送', '未发送', null); INSERT INTO `gmms_glass` VALUES ('4057905', '0', '1715', '2240', '1715', '2240', '12', 'C', '薛柏森', '待识别', '', 'A1', '4244', '1', '0', '0', '0', '待识别', '18', '', '12厘钢化', '', '1', 'A', '', '未发送', '未发送', null); INSERT INTO `gmms_glass` VALUES ('4057906', '0', '814', '2280', '814', '2280', '12', 'C', '薛柏森', '待识别', '', 'A1', '4244', '1', '0', '0', '0', '待识别', '18', '', '12厘钢化', '', '5', 'A', '', '未发送', '未发送', null); -- ---------------------------- -- Table structure for `gmms_glass_number_color` -- ---------------------------- DROP TABLE IF EXISTS `gmms_glass_number_color`; CREATE TABLE `gmms_glass_number_color` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `glass_id` varchar(50) DEFAULT NULL, `flag` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_glass_number_color -- ---------------------------- INSERT INTO `gmms_glass_number_color` VALUES ('1', 'white', '0'); INSERT INTO `gmms_glass_number_color` VALUES ('2', 'low_e', '0'); INSERT INTO `gmms_glass_number_color` VALUES ('4', 'PLE-60', '0'); INSERT INTO `gmms_glass_number_color` VALUES ('7', 'PLC-80', '0'); INSERT INTO `gmms_glass_number_color` VALUES ('8', 'C', '0'); INSERT INTO `gmms_glass_number_color` VALUES ('11', 'SC', '0'); INSERT INTO `gmms_glass_number_color` VALUES ('12', '5mm白玻', '0'); -- ---------------------------- -- Table structure for `gmms_grind_edge_machine` -- ---------------------------- DROP TABLE IF EXISTS `gmms_grind_edge_machine`; CREATE TABLE `gmms_grind_edge_machine` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `connect_state` varchar(50) DEFAULT NULL, `port` int(11) DEFAULT NULL, `proximity_switch` varchar(50) DEFAULT NULL, `allow_control` varchar(50) DEFAULT NULL, `glass_info` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_grind_edge_machine -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_grind_edge_machine_task` -- ---------------------------- DROP TABLE IF EXISTS `gmms_grind_edge_machine_task`; CREATE TABLE `gmms_grind_edge_machine_task` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `state` varchar(50) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `glass_id` bigint(20) DEFAULT NULL, `manufacture_batch_id` bigint(20) DEFAULT NULL, `grind_edge_machine_id` bigint(20) DEFAULT NULL, `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `complete_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `manufacture_batch_id` (`manufacture_batch_id`), KEY `grind_edge_machine_id` (`grind_edge_machine_id`), KEY `glass_id` (`glass_id`), CONSTRAINT `gmms_grind_edge_machine_task_ibfk_1` FOREIGN KEY (`manufacture_batch_id`) REFERENCES `gmms_manufacture_batch` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_grind_edge_machine_task_ibfk_2` FOREIGN KEY (`grind_edge_machine_id`) REFERENCES `gmms_grind_edge_machine` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_grind_edge_machine_task_ibfk_3` FOREIGN KEY (`glass_id`) REFERENCES `gmms_glass` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_grind_edge_machine_task -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_grind_edge_machine_two` -- ---------------------------- DROP TABLE IF EXISTS `gmms_grind_edge_machine_two`; CREATE TABLE `gmms_grind_edge_machine_two` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `connect_state` varchar(50) DEFAULT NULL, `port` int(11) DEFAULT NULL, `proximity_switch` varchar(50) DEFAULT NULL, `allow_control` varchar(50) DEFAULT NULL, `glass_info` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_grind_edge_machine_two -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_grind_face_machine` -- ---------------------------- DROP TABLE IF EXISTS `gmms_grind_face_machine`; CREATE TABLE `gmms_grind_face_machine` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `connect_state` varchar(50) DEFAULT NULL, `port` int(11) DEFAULT NULL, `allow_control_one` varchar(50) DEFAULT NULL, `fault_one` varchar(50) DEFAULT NULL, `allow_control_two` varchar(50) DEFAULT NULL, `fault_two` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_grind_face_machine -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_identify_floor` -- ---------------------------- DROP TABLE IF EXISTS `gmms_identify_floor`; CREATE TABLE `gmms_identify_floor` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `ceiling` int(11) DEFAULT NULL, `floor` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_identify_floor -- ---------------------------- INSERT INTO `gmms_identify_floor` VALUES ('1', '10', '10'); -- ---------------------------- -- Table structure for `gmms_identify_machine` -- ---------------------------- DROP TABLE IF EXISTS `gmms_identify_machine`; CREATE TABLE `gmms_identify_machine` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `connect_state` varchar(50) DEFAULT NULL, `port` int(11) DEFAULT NULL, `ip_address` varchar(30) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_identify_machine -- ---------------------------- INSERT INTO `gmms_identify_machine` VALUES ('1', '01', '停机中', '正在连接', '502', '192.168.1.10'); -- ---------------------------- -- Table structure for `gmms_identify_pattern` -- ---------------------------- DROP TABLE IF EXISTS `gmms_identify_pattern`; CREATE TABLE `gmms_identify_pattern` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `pattern` varchar(255) DEFAULT NULL, `line` varchar(255) DEFAULT NULL, `speech` int(20) DEFAULT NULL, `thinckness` int(11) DEFAULT NULL, `resize` int(11) DEFAULT NULL, `raw_package_txt_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `raw_package_txt_id` (`raw_package_txt_id`), CONSTRAINT `gmms_identify_pattern_ibfk_1` FOREIGN KEY (`raw_package_txt_id`) REFERENCES `gmms_raw_package_txt` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_identify_pattern -- ---------------------------- INSERT INTO `gmms_identify_pattern` VALUES ('1', '订单匹配', '一对一', '5166', '8', '2', '18'); -- ---------------------------- -- Table structure for `gmms_identify_statu` -- ---------------------------- DROP TABLE IF EXISTS `gmms_identify_statu`; CREATE TABLE `gmms_identify_statu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `messagetype` varchar(50) DEFAULT NULL, `glassid` varchar(50) DEFAULT NULL, `plcid` varchar(50) DEFAULT NULL, `mesid` varchar(50) DEFAULT NULL, `set_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `message` varchar(500) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_identify_statu -- ---------------------------- INSERT INTO `gmms_identify_statu` VALUES ('1', '0000', '0', '0', '0', '2020-04-21 11:51:49', '000052655452'); -- ---------------------------- -- Table structure for `gmms_label` -- ---------------------------- DROP TABLE IF EXISTS `gmms_label`; CREATE TABLE `gmms_label` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `filedname` varchar(50) DEFAULT NULL, `xlength` int(11) DEFAULT NULL, `ylength` int(11) DEFAULT NULL, `size` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_label -- ---------------------------- INSERT INTO `gmms_label` VALUES ('1', 'remark', '100', '100', '10'); INSERT INTO `gmms_label` VALUES ('4', 'pieceSign', '200', '200', '12'); INSERT INTO `gmms_label` VALUES ('5', 'apartId', '50', '50', '12'); -- ---------------------------- -- Table structure for `gmms_load_machine` -- ---------------------------- DROP TABLE IF EXISTS `gmms_load_machine`; CREATE TABLE `gmms_load_machine` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `connect_state` varchar(50) DEFAULT NULL, `port` int(11) DEFAULT NULL, `message` varchar(255) DEFAULT NULL, `opt_name` varchar(255) DEFAULT NULL, `cut_machine_id` bigint(20) DEFAULT NULL, `ip_address` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `cut_machine_id` (`cut_machine_id`), CONSTRAINT `gmms_load_machine_ibfk_1` FOREIGN KEY (`cut_machine_id`) REFERENCES `gmms_cut_machine` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_load_machine -- ---------------------------- INSERT INTO `gmms_load_machine` VALUES ('1', '01', '设备停止', '正在连接', '502', null, null, '1', '192.168.1.11'); -- ---------------------------- -- Table structure for `gmms_load_machine_fix_rack` -- ---------------------------- DROP TABLE IF EXISTS `gmms_load_machine_fix_rack`; CREATE TABLE `gmms_load_machine_fix_rack` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `glass_id` varchar(50) DEFAULT NULL, `pieces` int(11) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `number` varchar(50) DEFAULT NULL, `width` double DEFAULT NULL, `height` double DEFAULT NULL, `thickness` double DEFAULT NULL, `color` varchar(50) DEFAULT NULL, `left_pieces` int(11) DEFAULT NULL, `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_load_machine_fix_rack -- ---------------------------- INSERT INTO `gmms_load_machine_fix_rack` VALUES ('1', null, '0', '空闲', '105', '0', '0', '0', null, '0', '2019-03-11 12:33:50'); INSERT INTO `gmms_load_machine_fix_rack` VALUES ('2', null, '0', '空闲', '106', '0', '0', '0', null, '0', '2019-02-21 19:37:37'); -- ---------------------------- -- Table structure for `gmms_load_machine_rack` -- ---------------------------- DROP TABLE IF EXISTS `gmms_load_machine_rack`; CREATE TABLE `gmms_load_machine_rack` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `message` varchar(255) DEFAULT NULL, `raw_package_id` bigint(20) DEFAULT NULL, `load_machine_id` bigint(20) DEFAULT NULL, `raw_package_ready` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `raw_package_id` (`raw_package_id`), KEY `load_machine_id` (`load_machine_id`), CONSTRAINT `gmms_load_machine_rack_ibfk_1` FOREIGN KEY (`raw_package_id`) REFERENCES `gmms_raw_package` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_load_machine_rack_ibfk_2` FOREIGN KEY (`load_machine_id`) REFERENCES `gmms_load_machine` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_load_machine_rack -- ---------------------------- INSERT INTO `gmms_load_machine_rack` VALUES ('1', '101', '等待出库', '', '5', '1', null); INSERT INTO `gmms_load_machine_rack` VALUES ('2', '102', '空闲', '', null, '1', null); -- ---------------------------- -- Table structure for `gmms_load_machine_task` -- ---------------------------- DROP TABLE IF EXISTS `gmms_load_machine_task`; CREATE TABLE `gmms_load_machine_task` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `state` varchar(50) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `complete_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `load_machine_id` bigint(20) DEFAULT NULL, `load_machine_rack_id` bigint(20) DEFAULT NULL, `raw_package_id` bigint(20) DEFAULT NULL, `opt_pattern_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `raw_package_id` (`raw_package_id`), KEY `opt_pattern_id` (`opt_pattern_id`), KEY `load_machine_id` (`load_machine_id`), KEY `load_machine_rack_id` (`load_machine_rack_id`), CONSTRAINT `gmms_load_machine_task_ibfk_1` FOREIGN KEY (`raw_package_id`) REFERENCES `gmms_raw_package` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_load_machine_task_ibfk_2` FOREIGN KEY (`opt_pattern_id`) REFERENCES `gmms_opt_pattern` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_load_machine_task_ibfk_3` FOREIGN KEY (`load_machine_id`) REFERENCES `gmms_load_machine` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_load_machine_task_ibfk_4` FOREIGN KEY (`load_machine_rack_id`) REFERENCES `gmms_load_machine_rack` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_load_machine_task -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_load_statu` -- ---------------------------- DROP TABLE IF EXISTS `gmms_load_statu`; CREATE TABLE `gmms_load_statu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `autostate` varchar(50) DEFAULT NULL, `errorstate` varchar(50) DEFAULT NULL, `loadfinish` varchar(50) DEFAULT NULL, `plcid` varchar(50) DEFAULT NULL, `mesid` varchar(50) DEFAULT NULL, `statuid` varchar(50) DEFAULT NULL, `set_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `message` varchar(500) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_load_statu -- ---------------------------- INSERT INTO `gmms_load_statu` VALUES ('1', 'MES全自动', '0', '上片中', '11', '11', '0', '2020-04-21 11:50:53', '0000000000'); -- ---------------------------- -- Table structure for `gmms_manufacture_batch` -- ---------------------------- DROP TABLE IF EXISTS `gmms_manufacture_batch`; CREATE TABLE `gmms_manufacture_batch` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `complete_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_manufacture_batch -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_manufacture_batch_machine` -- ---------------------------- DROP TABLE IF EXISTS `gmms_manufacture_batch_machine`; CREATE TABLE `gmms_manufacture_batch_machine` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `machine_type` varchar(100) DEFAULT NULL, `machine_id` bigint(20) DEFAULT NULL, `manufacture_batch_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `manufacture_batch_id` (`manufacture_batch_id`), CONSTRAINT `gmms_manufacture_batch_machine_ibfk_1` FOREIGN KEY (`manufacture_batch_id`) REFERENCES `gmms_manufacture_batch` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_manufacture_batch_machine -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_manufacture_sequence` -- ---------------------------- DROP TABLE IF EXISTS `gmms_manufacture_sequence`; CREATE TABLE `gmms_manufacture_sequence` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `manufacture_date` varchar(50) DEFAULT NULL, `max_sequence` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_manufacture_sequence -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_measure_machine` -- ---------------------------- DROP TABLE IF EXISTS `gmms_measure_machine`; CREATE TABLE `gmms_measure_machine` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `connect_state` varchar(50) DEFAULT NULL, `picture_url` varchar(255) DEFAULT NULL, `port` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_measure_machine -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_opt_pattern` -- ---------------------------- DROP TABLE IF EXISTS `gmms_opt_pattern`; CREATE TABLE `gmms_opt_pattern` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `opt_id` varchar(50) DEFAULT NULL, `glass_id` varchar(50) DEFAULT NULL, `glass_description` varchar(255) DEFAULT NULL, `glass_thickness` double DEFAULT NULL, `pieces` int(11) DEFAULT NULL, `completed_pieces` int(11) DEFAULT NULL, `width` double DEFAULT NULL, `height` double DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `color` varchar(50) DEFAULT NULL, `content` varchar(10000) DEFAULT NULL, `batch` varchar(255) DEFAULT NULL, `groups` varchar(255) DEFAULT NULL, `raw_package_txt_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `raw_package_txt_id` (`raw_package_txt_id`), CONSTRAINT `gmms_opt_pattern_ibfk_1` FOREIGN KEY (`raw_package_txt_id`) REFERENCES `gmms_raw_package_txt` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=148 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_opt_pattern -- ---------------------------- INSERT INTO `gmms_opt_pattern` VALUES ('11', 'bbbbbbbb_01', '4', null, '5', '1', '1', '3660', '2134', null, '5mm白玻', '[OPT_Pattern]\r\nGlassID=4\r\nGlassThickness=5.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2134.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=2328.00\r\n Y=1235.00\r\n Z=582.00 Info=1\r\n Z=582.00 Info=1\r\n Z=582.00 Info=2\r\n Z=582.00 Info=2\r\n Y=899.00\r\n Z=1420.00\r\n W=480.00\r\n V=355.00 Info=9\r\n V=355.00 Info=9\r\n V=355.00 Info=10\r\n V=355.00 Info=10\r\n W=355.00\r\n V=1352.00 Info=7\r\n Z=890.00\r\n W=895.00 Info=5\r\nX=1332.00\r\n Y=1970.00\r\n Z=1258.00\r\n W=985.00 Info=3\r\n W=985.00 Info=4\r\n\r\n[Cuttings]\r\nx=582.00 y=3.00 X=582.00 Y=1234.00\r\nx=710.00 y=1236.00 X=710.00 Y=1714.00\r\nx=355.00 y=1714.00 X=355.00 Y=1236.00\r\nx=3.00 y=1235.00 X=2327.00 Y=1235.00\r\nx=2310.00 y=1236.00 X=2310.00 Y=2131.00\r\nx=2309.00 y=2130.00 X=1421.00 Y=2130.00\r\nx=1420.00 y=2131.00 X=1420.00 Y=1236.00\r\nx=1164.00 y=1234.00 X=1164.00 Y=3.00\r\nx=1746.00 y=3.00 X=1746.00 Y=1234.00\r\nx=1419.00 y=1715.00 X=3.00 Y=1715.00\r\nx=3.00 y=2070.00 X=1419.00 Y=2070.00\r\nx=1352.00 y=2069.00 X=1352.00 Y=1716.00\r\nx=1065.00 y=1714.00 X=1065.00 Y=1236.00\r\nx=2329.00 y=985.00 X=3585.00 Y=985.00\r\nx=3586.00 y=3.00 X=3586.00 Y=1969.00\r\nx=3657.00 y=1970.00 X=2329.00 Y=1970.00\r\nx=2328.00 y=2131.00 X=2328.00 Y=3.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=5+12A+5双钢中空&5mm白玻&A\r\nOrderNo=GY200413002&杨总1325632155&吴忠&A1\r\nPosNo=1\r\nCustomer=1&C5&5563&打孔&没有备注&2\r\nCommision=5+12A+5双钢中空&5mm白玻&A\r\nRackNo=\r\nSheetWidth=1235.00\r\nSheetHeight=582.00\r\n\r\n[Info]\r\nId=2\r\nSecondGlassReference=5+12A+5双钢中空&5mm白玻&B\r\nOrderNo=GY200413002&杨总1325632155&吴忠&A1\r\nPosNo=2\r\nCustomer=1&C5&5563&打孔&没有备注&2\r\nCommision=5+12A+5双钢中空&5mm白玻&B\r\nRackNo=\r\nSheetWidth=1235.00\r\nSheetHeight=582.00\r\n\r\n[Info]\r\nId=3\r\nSecondGlassReference=5+12A+5双钢中空&5mm白玻&A\r\nOrderNo=GY200413002&杨总1325632155&吴忠&A1\r\nPosNo=3\r\nCustomer=2&C5&5563&打孔&没有备注&2\r\nCommision=5+12A+5双钢中空&5mm白玻&A\r\nRackNo=\r\nSheetWidth=1258.00\r\nSheetHeight=985.00\r\n\r\n[Info]\r\nId=4\r\nSecondGlassReference=5+12A+5双钢中空&5mm白玻&B\r\nOrderNo=GY200413002&杨总1325632155&吴忠&A1\r\nPosNo=4\r\nCustomer=2&C5&5563&打孔&没有备注&2\r\nCommision=5+12A+5双钢中空&5mm白玻&B\r\nRackNo=\r\nSheetWidth=1258.00\r\nSheetHeight=985.00\r\n\r\n[Info]\r\nId=5\r\nSecondGlassReference=5+12A+5双钢中空&5mm白玻&A\r\nOrderNo=GY200413002&杨总1325632155&吴忠&A1\r\nPosNo=5\r\nCustomer=3&C5&5563&打孔&没有备注&2\r\nCommision=5+12A+5双钢中空&5mm白玻&A\r\nRackNo=\r\nSheetWidth=890.00\r\nSheetHeight=895.00\r\n\r\n[Info]\r\nId=7\r\nSecondGlassReference=5+12A+5双钢中空&5mm白玻&A\r\nOrderNo=GY200413002&杨总1325632155&吴忠&A1\r\nPosNo=7\r\nCustomer=4&C5&5563&打孔&没有备注&2\r\nCommision=5+12A+5双钢中空&5mm白玻&A\r\nRackNo=\r\nSheetWidth=1352.00\r\nSheetHeight=355.00\r\n\r\n[Info]\r\nId=9\r\nSecondGlassReference=5+12A+5双钢中空&5mm白玻&A\r\nOrderNo=GY200413002&杨总1325632155&吴忠&A1\r\nPosNo=9\r\nCustomer=5&C5&5563&打孔&没有备注&2\r\nCommision=5+12A+5双钢中空&5mm白玻&A\r\nRackNo=\r\nSheetWidth=355.00\r\nSheetHeight=480.00\r\n\r\n[Info]\r\nId=10\r\nSecondGlassReference=5+12A+5双钢中空&5mm白玻&B\r\nOrderNo=GY200413002&杨总1325632155&吴忠&A1\r\nPosNo=10\r\nCustomer=5&C5&5563&打孔&没有备注&2\r\nCommision=5+12A+5双钢中空&5mm白玻&B\r\nRackNo=\r\nSheetWidth=355.00\r\nSheetHeight=480.00\r\n\r\n', 'bbbbbbbb', null, '6'); INSERT INTO `gmms_opt_pattern` VALUES ('12', 'bbbbbbbb_02', '4', null, '5', '1', '1', '3660', '2134', null, '5mm白玻', '[OPT_Pattern]\r\nGlassID=4\r\nGlassThickness=5.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2134.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=890.00\r\n Y=895.00 Info=5\r\n Y=895.00 Info=6\r\nX=2770.00\r\n Y=895.00\r\n Z=890.00 Info=6\r\n Z=1880.00\r\n W=355.00\r\n V=1352.00 Info=8\r\n\r\n[Cuttings]\r\nx=890.00 y=3.00 X=890.00 Y=2131.00\r\nx=889.00 y=1790.00 X=3.00 Y=1790.00\r\nx=3.00 y=895.00 X=3657.00 Y=895.00\r\nx=3657.00 y=355.00 X=1781.00 Y=355.00\r\nx=1780.00 y=3.00 X=1780.00 Y=894.00\r\nx=3132.00 y=354.00 X=3132.00 Y=3.00\r\n\r\n[Info]\r\nId=5\r\nSecondGlassReference=5+12A+5双钢中空&5mm白玻&A\r\nOrderNo=GY200413002&杨总1325632155&吴忠&A1\r\nPosNo=5\r\nCustomer=3&C5&5563&打孔&没有备注&2\r\nCommision=5+12A+5双钢中空&5mm白玻&A\r\nRackNo=\r\nSheetWidth=890.00\r\nSheetHeight=895.00\r\n\r\n[Info]\r\nId=6\r\nSecondGlassReference=5+12A+5双钢中空&5mm白玻&B\r\nOrderNo=GY200413002&杨总1325632155&吴忠&A1\r\nPosNo=6\r\nCustomer=3&C5&5563&打孔&没有备注&2\r\nCommision=5+12A+5双钢中空&5mm白玻&B\r\nRackNo=\r\nSheetWidth=890.00\r\nSheetHeight=895.00\r\n\r\n[Info]\r\nId=8\r\nSecondGlassReference=5+12A+5双钢中空&5mm白玻&B\r\nOrderNo=GY200413002&杨总1325632155&吴忠&A1\r\nPosNo=8\r\nCustomer=4&C5&5563&打孔&没有备注&2\r\nCommision=5+12A+5双钢中空&5mm白玻&B\r\nRackNo=\r\nSheetWidth=1352.00\r\nSheetHeight=355.00\r\n', 'bbbbbbbb', null, '6'); INSERT INTO `gmms_opt_pattern` VALUES ('83', '424_01', '8C', '', '8', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=733.00\r\n Y=2135.00 Info=40\r\nX=2927.00\r\n Y=978.00\r\n Z=1403.00 Info=6\r\n Z=1403.00 Info=6\r\n Y=1462.00\r\n Z=978.00\r\n W=1403.00 Info=6\r\n Z=958.00\r\n W=1293.00 Info=28\r\n Z=991.00\r\n W=1293.00\r\n V=948.00 Info=10\r\n\r\n[Cuttings]\r\nx=733.00 y=3.00 X=733.00 Y=2437.00\r\nx=734.00 y=2381.00 X=1710.00 Y=2381.00\r\nx=1711.00 y=2437.00 X=1711.00 Y=979.00\r\nx=2136.00 y=977.00 X=2136.00 Y=3.00\r\nx=2669.00 y=979.00 X=2669.00 Y=2437.00\r\nx=3617.00 y=2270.00 X=3617.00 Y=979.00\r\nx=3657.00 y=978.00 X=734.00 Y=978.00\r\nx=732.00 y=2135.00 X=3.00 Y=2135.00\r\nx=1712.00 y=2271.00 X=3657.00 Y=2271.00\r\nx=3539.00 y=977.00 X=3539.00 Y=3.00\r\n\r\n[Info]\r\nId=6\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=6\r\nCustomer=4&&&&&1400*975\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=978.00\r\n\r\n[Info]\r\nId=10\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=10\r\nCustomer=8&&&&&1290*945\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1293.00\r\nSheetHeight=948.00\r\n\r\n[Info]\r\nId=28\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=28\r\nCustomer=26&&&&&1290*955\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1293.00\r\nSheetHeight=958.00\r\n\r\n[Info]\r\nId=40\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423008&魏金龙&&A1\r\nPosNo=40\r\nCustomer=1&&&&&2132*730\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=2135.00\r\nSheetHeight=733.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('84', '424_02', '8C', '', '8', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=3660.00\r\n Y=1046.00\r\n Z=1703.00 Info=1\r\n Z=1703.00 Info=1\r\n Y=1394.00\r\n Z=2330.00\r\n W=1307.00 Info=41\r\n Z=1330.00\r\n W=1178.00\r\n V=1258.00 Info=22\r\n\r\n[Cuttings]\r\nx=3.00 y=1046.00 X=3657.00 Y=1046.00\r\nx=3588.00 y=1047.00 X=3588.00 Y=2223.00\r\nx=3657.00 y=2224.00 X=2331.00 Y=2224.00\r\nx=2329.00 y=2353.00 X=3.00 Y=2353.00\r\nx=1703.00 y=1045.00 X=1703.00 Y=3.00\r\nx=2330.00 y=1047.00 X=2330.00 Y=2437.00\r\nx=3406.00 y=1045.00 X=3406.00 Y=3.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423003&李成顺&&A1\r\nPosNo=1\r\nCustomer=1&&&&&1700*1043\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1703.00\r\nSheetHeight=1046.00\r\n\r\n[Info]\r\nId=22\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=22\r\nCustomer=20&&&&&1255*1175\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1258.00\r\nSheetHeight=1178.00\r\n\r\n[Info]\r\nId=41\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423008&魏金龙&&A1\r\nPosNo=41\r\nCustomer=2&&&&&2327*1304\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=2330.00\r\nSheetHeight=1307.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('85', '424_03', '8C', '', '8', '2', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=2\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=3138.00\r\n Y=1703.00\r\n Z=1046.00 Info=1\r\n Z=1046.00 Info=1\r\n Z=1046.00 Info=1\r\n Y=737.00\r\n Z=1953.00\r\n W=588.00 Info=34\r\n Z=1099.00\r\n W=651.00 Info=37\r\nX=522.00\r\n Y=2128.00\r\n Z=408.00 Info=35\r\n\r\n[Cuttings]\r\nx=1046.00 y=3.00 X=1046.00 Y=1702.00\r\nx=1953.00 y=1704.00 X=1953.00 Y=2437.00\r\nx=1954.00 y=2354.00 X=3051.00 Y=2354.00\r\nx=3052.00 y=2437.00 X=3052.00 Y=1704.00\r\nx=3137.00 y=1703.00 X=3.00 Y=1703.00\r\nx=3.00 y=2291.00 X=1952.00 Y=2291.00\r\nx=2092.00 y=1702.00 X=2092.00 Y=3.00\r\nx=3138.00 y=3.00 X=3138.00 Y=2437.00\r\nx=3139.00 y=2128.00 X=3657.00 Y=2128.00\r\nx=3546.00 y=2127.00 X=3546.00 Y=3.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423003&李成顺&&A1\r\nPosNo=1\r\nCustomer=1&&&&&1700*1043\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1703.00\r\nSheetHeight=1046.00\r\n\r\n[Info]\r\nId=34\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423005&张伟&&A1\r\nPosNo=34\r\nCustomer=1&&&&&1950*585\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1953.00\r\nSheetHeight=588.00\r\n\r\n[Info]\r\nId=35\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423005&张伟&&A1\r\nPosNo=35\r\nCustomer=2&&&&&2125*405\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=2128.00\r\nSheetHeight=408.00\r\n\r\n[Info]\r\nId=37\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423006&固恒&&A1\r\nPosNo=37\r\nCustomer=2&&&&&1096*648\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1099.00\r\nSheetHeight=651.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('86', '424_04', '8C', '', '8', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=3660.00\r\n Y=1046.00\r\n Z=1703.00 Info=1\r\n Z=1703.00 Info=1\r\n Y=1394.00\r\n Z=1403.00\r\n W=1178.00 Info=20\r\n Z=1178.00\r\n W=1293.00 Info=21\r\n Z=1079.00\r\n W=1293.00\r\n V=983.00 Info=11\r\n\r\n[Cuttings]\r\nx=3.00 y=1046.00 X=3657.00 Y=1046.00\r\nx=3564.00 y=1047.00 X=3564.00 Y=2338.00\r\nx=3657.00 y=2339.00 X=1404.00 Y=2339.00\r\nx=1403.00 y=2437.00 X=1403.00 Y=1047.00\r\nx=1703.00 y=1045.00 X=1703.00 Y=3.00\r\nx=2581.00 y=1047.00 X=2581.00 Y=2437.00\r\nx=1402.00 y=2224.00 X=3.00 Y=2224.00\r\nx=3406.00 y=1045.00 X=3406.00 Y=3.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423003&李成顺&&A1\r\nPosNo=1\r\nCustomer=1&&&&&1700*1043\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1703.00\r\nSheetHeight=1046.00\r\n\r\n[Info]\r\nId=11\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=11\r\nCustomer=9&&&&&1290*980\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1293.00\r\nSheetHeight=983.00\r\n\r\n[Info]\r\nId=20\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=20\r\nCustomer=18&&&&&1400*1175\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=1178.00\r\n\r\n[Info]\r\nId=21\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=21\r\nCustomer=19&&&&&1290*1175\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1293.00\r\nSheetHeight=1178.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('87', '424_05', '8C', '', '8', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=3660.00\r\n Y=1046.00\r\n Z=1703.00 Info=1\r\n Z=1703.00 Info=1\r\n Y=1394.00\r\n Z=1198.00\r\n W=1258.00 Info=26\r\n Z=1178.00\r\n W=1258.00 Info=22\r\n Z=1123.00\r\n W=1293.00 Info=3\r\n\r\n[Cuttings]\r\nx=3.00 y=1046.00 X=3657.00 Y=1046.00\r\nx=3499.00 y=1047.00 X=3499.00 Y=2437.00\r\nx=3498.00 y=2339.00 X=2377.00 Y=2339.00\r\nx=2375.00 y=2304.00 X=3.00 Y=2304.00\r\nx=1198.00 y=2437.00 X=1198.00 Y=1047.00\r\nx=1703.00 y=1045.00 X=1703.00 Y=3.00\r\nx=2376.00 y=1047.00 X=2376.00 Y=2437.00\r\nx=3406.00 y=1045.00 X=3406.00 Y=3.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423003&李成顺&&A1\r\nPosNo=1\r\nCustomer=1&&&&&1700*1043\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1703.00\r\nSheetHeight=1046.00\r\n\r\n[Info]\r\nId=3\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=3\r\nCustomer=1&&&&&1290*1120\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1293.00\r\nSheetHeight=1123.00\r\n\r\n[Info]\r\nId=22\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=22\r\nCustomer=20&&&&&1255*1175\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1258.00\r\nSheetHeight=1178.00\r\n\r\n[Info]\r\nId=26\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=26\r\nCustomer=24&&&&&1255*1195\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1258.00\r\nSheetHeight=1198.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('88', '424_06', '8C', '', '8', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=3660.00\r\n Y=1046.00\r\n Z=1703.00 Info=1\r\n Z=1703.00 Info=1\r\n Y=1394.00\r\n Z=1403.00\r\n W=1178.00 Info=20\r\n Z=1178.00\r\n W=1293.00 Info=21\r\n Z=978.00\r\n W=1293.00 Info=5\r\n\r\n[Cuttings]\r\nx=3.00 y=1046.00 X=3657.00 Y=1046.00\r\nx=3559.00 y=1047.00 X=3559.00 Y=2437.00\r\nx=3558.00 y=2339.00 X=1404.00 Y=2339.00\r\nx=1403.00 y=2437.00 X=1403.00 Y=1047.00\r\nx=1703.00 y=1045.00 X=1703.00 Y=3.00\r\nx=2581.00 y=1047.00 X=2581.00 Y=2437.00\r\nx=1402.00 y=2224.00 X=3.00 Y=2224.00\r\nx=3406.00 y=1045.00 X=3406.00 Y=3.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423003&李成顺&&A1\r\nPosNo=1\r\nCustomer=1&&&&&1700*1043\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1703.00\r\nSheetHeight=1046.00\r\n\r\n[Info]\r\nId=5\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=5\r\nCustomer=3&&&&&1290*975\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1293.00\r\nSheetHeight=978.00\r\n\r\n[Info]\r\nId=20\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=20\r\nCustomer=18&&&&&1400*1175\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=1178.00\r\n\r\n[Info]\r\nId=21\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=21\r\nCustomer=19&&&&&1290*1175\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1293.00\r\nSheetHeight=1178.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('89', '424_07', '8C', '', '8', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=3660.00\r\n Y=1046.00\r\n Z=1703.00 Info=1\r\n Z=1703.00 Info=1\r\n Y=1394.00\r\n Z=1403.00\r\n W=1128.00 Info=14\r\n Z=1203.00\r\n W=1293.00 Info=17\r\n Z=1054.00\r\n W=1293.00\r\n V=993.00 Info=27\r\n\r\n[Cuttings]\r\nx=3.00 y=1046.00 X=3657.00 Y=1046.00\r\nx=3599.00 y=1047.00 X=3599.00 Y=2338.00\r\nx=3657.00 y=2339.00 X=1404.00 Y=2339.00\r\nx=1403.00 y=2437.00 X=1403.00 Y=1047.00\r\nx=1703.00 y=1045.00 X=1703.00 Y=3.00\r\nx=2606.00 y=1047.00 X=2606.00 Y=2437.00\r\nx=1402.00 y=2174.00 X=3.00 Y=2174.00\r\nx=3406.00 y=1045.00 X=3406.00 Y=3.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423003&李成顺&&A1\r\nPosNo=1\r\nCustomer=1&&&&&1700*1043\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1703.00\r\nSheetHeight=1046.00\r\n\r\n[Info]\r\nId=14\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=14\r\nCustomer=12&&&&&1400*1125\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=1128.00\r\n\r\n[Info]\r\nId=17\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=17\r\nCustomer=15&&&&&1290*1200\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1293.00\r\nSheetHeight=1203.00\r\n\r\n[Info]\r\nId=27\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=27\r\nCustomer=25&&&&&1290*990\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1293.00\r\nSheetHeight=993.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('90', '424_08', '8C', '', '8', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=2092.00\r\n Y=1703.00\r\n Z=1046.00 Info=1\r\n Z=1046.00 Info=1\r\n Y=737.00\r\n Z=1558.00\r\n W=651.00\r\n V=779.00 Info=36\r\n V=779.00 Info=36\r\nX=1568.00\r\n Y=1203.00\r\n Z=1403.00 Info=18\r\n Y=1237.00\r\n Z=1403.00\r\n W=1198.00 Info=23\r\n\r\n[Cuttings]\r\nx=1046.00 y=3.00 X=1046.00 Y=1702.00\r\nx=779.00 y=1704.00 X=779.00 Y=2353.00\r\nx=3.00 y=2354.00 X=1557.00 Y=2354.00\r\nx=1558.00 y=2437.00 X=1558.00 Y=1704.00\r\nx=2091.00 y=1703.00 X=3.00 Y=1703.00\r\nx=2093.00 y=1203.00 X=3657.00 Y=1203.00\r\nx=3494.00 y=2401.00 X=2093.00 Y=2401.00\r\nx=2092.00 y=2437.00 X=2092.00 Y=3.00\r\nx=3495.00 y=3.00 X=3495.00 Y=2437.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423003&李成顺&&A1\r\nPosNo=1\r\nCustomer=1&&&&&1700*1043\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1703.00\r\nSheetHeight=1046.00\r\n\r\n[Info]\r\nId=18\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=18\r\nCustomer=16&&&&&1400*1200\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=1203.00\r\n\r\n[Info]\r\nId=23\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=23\r\nCustomer=21&&&&&1400*1195\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=1198.00\r\n\r\n[Info]\r\nId=36\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423006&固恒&&A1\r\nPosNo=36\r\nCustomer=1&&&&&776*648\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=779.00\r\nSheetHeight=651.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('91', '424_09', '8C', '', '8', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=3660.00\r\n Y=1046.00\r\n Z=1703.00 Info=1\r\n Z=1703.00 Info=1\r\n Y=1394.00\r\n Z=1403.00\r\n W=1128.00 Info=14\r\n Z=1198.00\r\n W=1293.00 Info=25\r\n Z=1059.00\r\n W=1283.00\r\n V=973.00 Info=30\r\n\r\n[Cuttings]\r\nx=3.00 y=1046.00 X=3657.00 Y=1046.00\r\nx=3574.00 y=1047.00 X=3574.00 Y=2328.00\r\nx=3657.00 y=2329.00 X=2602.00 Y=2329.00\r\nx=2600.00 y=2339.00 X=1404.00 Y=2339.00\r\nx=1403.00 y=2437.00 X=1403.00 Y=1047.00\r\nx=1703.00 y=1045.00 X=1703.00 Y=3.00\r\nx=2601.00 y=1047.00 X=2601.00 Y=2437.00\r\nx=1402.00 y=2174.00 X=3.00 Y=2174.00\r\nx=3406.00 y=1045.00 X=3406.00 Y=3.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423003&李成顺&&A1\r\nPosNo=1\r\nCustomer=1&&&&&1700*1043\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1703.00\r\nSheetHeight=1046.00\r\n\r\n[Info]\r\nId=14\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=14\r\nCustomer=12&&&&&1400*1125\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=1128.00\r\n\r\n[Info]\r\nId=25\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=25\r\nCustomer=23&&&&&1290*1195\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1293.00\r\nSheetHeight=1198.00\r\n\r\n[Info]\r\nId=30\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=30\r\nCustomer=28&&&&&1280*970\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1283.00\r\nSheetHeight=973.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('92', '424_10', '8C', '', '8', '2', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=2\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=3660.00\r\n Y=1046.00\r\n Z=1703.00 Info=1\r\n Z=1703.00 Info=1\r\n Y=1394.00\r\n Z=1403.00\r\n W=1123.00 Info=4\r\n Z=1213.00\r\n W=1243.00 Info=39\r\n Z=1044.00\r\n W=1293.00\r\n V=998.00 Info=7\r\n\r\n[Cuttings]\r\nx=3.00 y=1046.00 X=3657.00 Y=1046.00\r\nx=3614.00 y=1047.00 X=3614.00 Y=2338.00\r\nx=3657.00 y=2339.00 X=2617.00 Y=2339.00\r\nx=2615.00 y=2289.00 X=1404.00 Y=2289.00\r\nx=1402.00 y=2169.00 X=3.00 Y=2169.00\r\nx=1403.00 y=2437.00 X=1403.00 Y=1047.00\r\nx=1703.00 y=1045.00 X=1703.00 Y=3.00\r\nx=2616.00 y=1047.00 X=2616.00 Y=2437.00\r\nx=3406.00 y=1045.00 X=3406.00 Y=3.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423003&李成顺&&A1\r\nPosNo=1\r\nCustomer=1&&&&&1700*1043\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1703.00\r\nSheetHeight=1046.00\r\n\r\n[Info]\r\nId=4\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=4\r\nCustomer=2&&&&&1400*1120\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=1123.00\r\n\r\n[Info]\r\nId=7\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=7\r\nCustomer=5&&&&&1290*995\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1293.00\r\nSheetHeight=998.00\r\n\r\n[Info]\r\nId=39\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423007&杨广付&&A1\r\nPosNo=39\r\nCustomer=2&&&&&1240*1210\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1243.00\r\nSheetHeight=1213.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('93', '424_11', '8C', '', '8', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=1823.00\r\n Y=1178.00 Info=16\r\n Y=1178.00 Info=16\r\nX=1703.00\r\n Y=1046.00 Info=1\r\n Y=1046.00 Info=1\r\n\r\n[Cuttings]\r\nx=3.00 y=1178.00 X=1822.00 Y=1178.00\r\nx=1824.00 y=1046.00 X=3525.00 Y=1046.00\r\nx=3526.00 y=3.00 X=3526.00 Y=2437.00\r\nx=3525.00 y=2092.00 X=1824.00 Y=2092.00\r\nx=1822.00 y=2356.00 X=3.00 Y=2356.00\r\nx=1823.00 y=2437.00 X=1823.00 Y=3.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423003&李成顺&&A1\r\nPosNo=1\r\nCustomer=1&&&&&1700*1043\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1703.00\r\nSheetHeight=1046.00\r\n\r\n[Info]\r\nId=16\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=16\r\nCustomer=14&&&&&1820*1175\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1823.00\r\nSheetHeight=1178.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('94', '424_12', '8C', '', '8', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=3660.00\r\n Y=1046.00\r\n Z=1703.00 Info=1\r\n Z=1703.00 Info=1\r\n Y=1394.00\r\n Z=1403.00\r\n W=998.00 Info=8\r\n Z=1203.00\r\n W=1258.00 Info=19\r\n Z=1054.00\r\n W=1293.00\r\n V=998.00 Info=7\r\n\r\n[Cuttings]\r\nx=3.00 y=1046.00 X=3657.00 Y=1046.00\r\nx=3604.00 y=1047.00 X=3604.00 Y=2338.00\r\nx=3657.00 y=2339.00 X=2607.00 Y=2339.00\r\nx=2605.00 y=2304.00 X=1404.00 Y=2304.00\r\nx=1403.00 y=2437.00 X=1403.00 Y=1047.00\r\nx=1703.00 y=1045.00 X=1703.00 Y=3.00\r\nx=2606.00 y=1047.00 X=2606.00 Y=2437.00\r\nx=1402.00 y=2044.00 X=3.00 Y=2044.00\r\nx=3406.00 y=1045.00 X=3406.00 Y=3.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423003&李成顺&&A1\r\nPosNo=1\r\nCustomer=1&&&&&1700*1043\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1703.00\r\nSheetHeight=1046.00\r\n\r\n[Info]\r\nId=7\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=7\r\nCustomer=5&&&&&1290*995\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1293.00\r\nSheetHeight=998.00\r\n\r\n[Info]\r\nId=8\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=8\r\nCustomer=6&&&&&1400*995\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=998.00\r\n\r\n[Info]\r\nId=19\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=19\r\nCustomer=17&&&&&1255*1200\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1258.00\r\nSheetHeight=1203.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('95', '424_13', '8C', '', '8', '2', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=2\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=1703.00\r\n Y=1046.00 Info=1\r\n Y=1046.00 Info=1\r\nX=1957.00\r\n Y=1403.00\r\n Z=973.00 Info=31\r\n Z=958.00 Info=29\r\n Y=1037.00\r\n Z=1403.00\r\n W=998.00 Info=8\r\n\r\n[Cuttings]\r\nx=3.00 y=1046.00 X=1702.00 Y=1046.00\r\nx=1704.00 y=1403.00 X=3657.00 Y=1403.00\r\nx=3634.00 y=1402.00 X=3634.00 Y=3.00\r\nx=2676.00 y=3.00 X=2676.00 Y=1402.00\r\nx=3106.00 y=1404.00 X=3106.00 Y=2437.00\r\nx=3105.00 y=2401.00 X=1704.00 Y=2401.00\r\nx=1703.00 y=2437.00 X=1703.00 Y=3.00\r\nx=1702.00 y=2092.00 X=3.00 Y=2092.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423003&李成顺&&A1\r\nPosNo=1\r\nCustomer=1&&&&&1700*1043\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1703.00\r\nSheetHeight=1046.00\r\n\r\n[Info]\r\nId=8\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=8\r\nCustomer=6&&&&&1400*995\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=998.00\r\n\r\n[Info]\r\nId=29\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=29\r\nCustomer=27&&&&&1400*955\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=958.00\r\n\r\n[Info]\r\nId=31\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=31\r\nCustomer=29&&&&&1400*970\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=973.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('96', '424_14', '8C', '', '8', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=3660.00\r\n Y=1046.00\r\n Z=1703.00 Info=1\r\n Z=1703.00 Info=1\r\n Y=1394.00\r\n Z=1403.00\r\n W=993.00 Info=24\r\n Z=1128.00\r\n W=1283.00 Info=13\r\n Z=978.00\r\n W=1293.00 Info=5\r\n\r\n[Cuttings]\r\nx=3.00 y=1046.00 X=3657.00 Y=1046.00\r\nx=3509.00 y=1047.00 X=3509.00 Y=2437.00\r\nx=3508.00 y=2339.00 X=2532.00 Y=2339.00\r\nx=2530.00 y=2329.00 X=1404.00 Y=2329.00\r\nx=1403.00 y=2437.00 X=1403.00 Y=1047.00\r\nx=1703.00 y=1045.00 X=1703.00 Y=3.00\r\nx=2531.00 y=1047.00 X=2531.00 Y=2437.00\r\nx=1402.00 y=2039.00 X=3.00 Y=2039.00\r\nx=3406.00 y=1045.00 X=3406.00 Y=3.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423003&李成顺&&A1\r\nPosNo=1\r\nCustomer=1&&&&&1700*1043\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1703.00\r\nSheetHeight=1046.00\r\n\r\n[Info]\r\nId=5\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=5\r\nCustomer=3&&&&&1290*975\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1293.00\r\nSheetHeight=978.00\r\n\r\n[Info]\r\nId=13\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=13\r\nCustomer=11&&&&&1280*1125\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1283.00\r\nSheetHeight=1128.00\r\n\r\n[Info]\r\nId=24\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=24\r\nCustomer=22&&&&&1400*990\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=993.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('97', '424_15', '8C', '', '8', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=1703.00\r\n Y=1046.00 Info=1\r\n Y=1046.00 Info=2\r\nX=1957.00\r\n Y=1403.00\r\n Z=983.00 Info=12\r\n Z=948.00 Info=9\r\n Y=1037.00\r\n Z=1403.00\r\n W=993.00 Info=32\r\n\r\n[Cuttings]\r\nx=3.00 y=1046.00 X=1702.00 Y=1046.00\r\nx=1704.00 y=1403.00 X=3657.00 Y=1403.00\r\nx=3634.00 y=1402.00 X=3634.00 Y=3.00\r\nx=2686.00 y=3.00 X=2686.00 Y=1402.00\r\nx=3106.00 y=1404.00 X=3106.00 Y=2437.00\r\nx=3105.00 y=2396.00 X=1704.00 Y=2396.00\r\nx=1703.00 y=2437.00 X=1703.00 Y=3.00\r\nx=1702.00 y=2092.00 X=3.00 Y=2092.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423003&李成顺&&A1\r\nPosNo=1\r\nCustomer=1&&&&&1700*1043\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1703.00\r\nSheetHeight=1046.00\r\n\r\n[Info]\r\nId=2\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423003&李成顺&&A1\r\nPosNo=2\r\nCustomer=2&&&打孔&&1700*1043\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1703.00\r\nSheetHeight=1046.00\r\n\r\n[Info]\r\nId=9\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=9\r\nCustomer=7&&&&&1400*945\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=948.00\r\n\r\n[Info]\r\nId=12\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=12\r\nCustomer=10&&&&&1400*980\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=983.00\r\n\r\n[Info]\r\nId=32\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=32\r\nCustomer=30&&&有豁&&1400*990\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=993.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('98', '424_16', '8C', '', '8', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=1703.00\r\n Y=1046.00 Info=1\r\n Y=1046.00 Info=1\r\nX=1957.00\r\n Y=998.00\r\n Z=1403.00 Info=33\r\n Y=1442.00\r\n Z=978.00\r\n W=1403.00 Info=6\r\n Z=979.00\r\n W=1403.00\r\n V=948.00 Info=9\r\n\r\n[Cuttings]\r\nx=3.00 y=1046.00 X=1702.00 Y=1046.00\r\nx=1704.00 y=998.00 X=3657.00 Y=998.00\r\nx=3629.00 y=999.00 X=3629.00 Y=2400.00\r\nx=3657.00 y=2401.00 X=1704.00 Y=2401.00\r\nx=1703.00 y=2437.00 X=1703.00 Y=3.00\r\nx=2681.00 y=999.00 X=2681.00 Y=2437.00\r\nx=1702.00 y=2092.00 X=3.00 Y=2092.00\r\nx=3106.00 y=997.00 X=3106.00 Y=3.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423003&李成顺&&A1\r\nPosNo=1\r\nCustomer=1&&&&&1700*1043\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1703.00\r\nSheetHeight=1046.00\r\n\r\n[Info]\r\nId=6\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=6\r\nCustomer=4&&&&&1400*975\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=978.00\r\n\r\n[Info]\r\nId=9\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=9\r\nCustomer=7&&&&&1400*945\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=948.00\r\n\r\n[Info]\r\nId=33\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=33\r\nCustomer=31&&&有豁&&1400*995\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=998.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('99', '424_17', '8C', '', '8', '2', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=2\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=1703.00\r\n Y=1046.00 Info=1\r\n Y=1046.00 Info=1\r\nX=1957.00\r\n Y=1388.00\r\n Z=1823.00 Info=15\r\n Y=1052.00\r\n Z=1403.00\r\n W=998.00 Info=8\r\n\r\n[Cuttings]\r\nx=3.00 y=1046.00 X=1702.00 Y=1046.00\r\nx=1704.00 y=1388.00 X=3657.00 Y=1388.00\r\nx=3526.00 y=1387.00 X=3526.00 Y=3.00\r\nx=3106.00 y=1389.00 X=3106.00 Y=2437.00\r\nx=3105.00 y=2386.00 X=1704.00 Y=2386.00\r\nx=1703.00 y=2437.00 X=1703.00 Y=3.00\r\nx=1702.00 y=2092.00 X=3.00 Y=2092.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423003&李成顺&&A1\r\nPosNo=1\r\nCustomer=1&&&&&1700*1043\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1703.00\r\nSheetHeight=1046.00\r\n\r\n[Info]\r\nId=8\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=8\r\nCustomer=6&&&&&1400*995\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=998.00\r\n\r\n[Info]\r\nId=15\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=15\r\nCustomer=13&&&&&1820*1385\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1823.00\r\nSheetHeight=1388.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('100', '424_18', '8C', '', '8', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=3660.00\r\n Y=1403.00\r\n Z=983.00 Info=12\r\n Z=1956.00\r\n W=1213.00\r\n V=978.00 Info=38\r\n V=978.00 Info=38\r\n Y=978.00\r\n Z=1213.00 Info=38\r\n Z=1213.00 Info=38\r\n Z=1213.00 Info=38\r\n\r\n[Cuttings]\r\nx=983.00 y=3.00 X=983.00 Y=1402.00\r\nx=984.00 y=1213.00 X=2938.00 Y=1213.00\r\nx=2939.00 y=1402.00 X=2939.00 Y=3.00\r\nx=1961.00 y=3.00 X=1961.00 Y=1212.00\r\nx=2426.00 y=1404.00 X=2426.00 Y=2380.00\r\nx=3639.00 y=2380.00 X=3639.00 Y=1404.00\r\nx=3657.00 y=1403.00 X=3.00 Y=1403.00\r\nx=3.00 y=2381.00 X=3657.00 Y=2381.00\r\nx=1213.00 y=2380.00 X=1213.00 Y=1404.00\r\n\r\n[Info]\r\nId=12\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423004&韩宝东&&A1\r\nPosNo=12\r\nCustomer=10&&&&&1400*980\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1403.00\r\nSheetHeight=983.00\r\n\r\n[Info]\r\nId=38\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423007&杨广付&&A1\r\nPosNo=38\r\nCustomer=1&&&&&1210*975\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1213.00\r\nSheetHeight=978.00\r\n\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('101', '424_19', '8C', '', '8', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=8C\r\nGlassDescription=\r\nGlassThickness=8.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=3660.00\r\n Y=1213.00\r\n Z=978.00 Info=38\r\n Z=978.00 Info=38\r\n Z=978.00 Info=38\r\n\r\n[Cuttings]\r\nx=978.00 y=3.00 X=978.00 Y=1212.00\r\nx=3.00 y=1213.00 X=3657.00 Y=1213.00\r\nx=2934.00 y=1212.00 X=2934.00 Y=3.00\r\nx=1956.00 y=3.00 X=1956.00 Y=1212.00\r\n\r\n[Info]\r\nId=38\r\nSecondGlassReference=8厘钢化&A\r\nOrderNo=GY200423007&杨广付&&A1\r\nPosNo=38\r\nCustomer=1&&&&&1210*975\r\nCommision=8厘钢化&A\r\nRackNo=8厘钢化\r\nSheetWidth=1213.00\r\nSheetHeight=978.00\r\n', '424', null, '14'); INSERT INTO `gmms_opt_pattern` VALUES ('145', '4244_01', '12C', '', '12', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=12C\r\nGlassDescription=\r\nGlassThickness=12.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=2044.00\r\n Y=1500.00\r\n Z=1022.00 Info=1\r\n Z=1022.00 Info=1\r\n Y=940.00\r\n Z=1790.00\r\n W=830.00 Info=2\r\nX=784.00\r\n Y=2295.00 Info=5\r\nX=832.00\r\n Y=2280.00\r\n Z=784.00 Info=6\r\n\r\n[Cuttings]\r\nx=1022.00 y=3.00 X=1022.00 Y=1499.00\r\nx=1790.00 y=1501.00 X=1790.00 Y=2437.00\r\nx=1789.00 y=2330.00 X=3.00 Y=2330.00\r\nx=3.00 y=1500.00 X=2043.00 Y=1500.00\r\nx=2045.00 y=2295.00 X=2827.00 Y=2295.00\r\nx=2829.00 y=2280.00 X=3657.00 Y=2280.00\r\nx=3612.00 y=2279.00 X=3612.00 Y=3.00\r\nx=2828.00 y=3.00 X=2828.00 Y=2437.00\r\nx=2044.00 y=2437.00 X=2044.00 Y=3.00\r\n\r\n[Info]\r\nId=1\r\nSecondGlassReference=12厘钢化&A\r\nOrderNo=GY200424008&&A1\r\nPosNo=1\r\nCustomer=张学军\r\nCommision=12厘钢化&A\r\nRackNo=1&&&&&1500*1022\r\nSheetWidth=1500.00\r\nSheetHeight=1022.00\r\n\r\n[Info]\r\nId=2\r\nSecondGlassReference=12厘钢化&A\r\nOrderNo=GY200424009&&A1\r\nPosNo=2\r\nCustomer=于海泉\r\nCommision=12厘钢化&A\r\nRackNo=1&&&&&1790*830\r\nSheetWidth=1790.00\r\nSheetHeight=830.00\r\n\r\n[Info]\r\nId=5\r\nSecondGlassReference=12厘钢化&A\r\nOrderNo=GY200424010&&A1\r\nPosNo=5\r\nCustomer=薛柏森\r\nCommision=12厘钢化&A\r\nRackNo=3&&&&&2295*784\r\nSheetWidth=2295.00\r\nSheetHeight=784.00\r\n\r\n[Info]\r\nId=6\r\nSecondGlassReference=12厘钢化&A\r\nOrderNo=GY200424010&&A1\r\nPosNo=6\r\nCustomer=薛柏森\r\nCommision=12厘钢化&A\r\nRackNo=4&&&&&2280*784\r\nSheetWidth=2280.00\r\nSheetHeight=784.00\r\n\r\n', '4244', null, '18'); INSERT INTO `gmms_opt_pattern` VALUES ('146', '4244_02', '12C', '', '12', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=12C\r\nGlassDescription=\r\nGlassThickness=12.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=1750.00\r\n Y=2240.00 Info=4\r\nX=1910.00\r\n Y=2240.00\r\n Z=1715.00 Info=3\r\n\r\n[Cuttings]\r\nx=1750.00 y=3.00 X=1750.00 Y=2437.00\r\nx=3465.00 y=2239.00 X=3465.00 Y=3.00\r\nx=3657.00 y=2240.00 X=3.00 Y=2240.00\r\n\r\n[Info]\r\nId=3\r\nSecondGlassReference=12厘钢化&A\r\nOrderNo=GY200424010&&A1\r\nPosNo=3\r\nCustomer=薛柏森\r\nCommision=12厘钢化&A\r\nRackNo=1&&&&&2240*1715\r\nSheetWidth=2240.00\r\nSheetHeight=1715.00\r\n\r\n[Info]\r\nId=4\r\nSecondGlassReference=12厘钢化&A\r\nOrderNo=GY200424010&&A1\r\nPosNo=4\r\nCustomer=薛柏森\r\nCommision=12厘钢化&A\r\nRackNo=2&&&&&2240*1750\r\nSheetWidth=2240.00\r\nSheetHeight=1750.00\r\n\r\n', '4244', null, '18'); INSERT INTO `gmms_opt_pattern` VALUES ('147', '4244_03', '12C', '', '12', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=12C\r\nGlassDescription=\r\nGlassThickness=12.00\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660.00\r\nHeight=2440.00\r\nTrimLeft=0.00\r\nTrimBottom=0.00\r\nX=814.00\r\n Y=2280.00 Info=7\r\n\r\n[Cuttings]\r\nx=814.00 y=3.00 X=814.00 Y=2437.00\r\nx=813.00 y=2280.00 X=3.00 Y=2280.00\r\n\r\n[Info]\r\nId=7\r\nSecondGlassReference=12厘钢化&A\r\nOrderNo=GY200424010&&A1\r\nPosNo=7\r\nCustomer=薛柏森\r\nCommision=12厘钢化&A\r\nRackNo=5&&&&&2280*814\r\nSheetWidth=2280.00\r\nSheetHeight=814.00\r\n', '4244', null, '18'); -- ---------------------------- -- Table structure for `gmms_preprocessing_glass` -- ---------------------------- DROP TABLE IF EXISTS `gmms_preprocessing_glass`; CREATE TABLE `gmms_preprocessing_glass` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `glass_id` bigint(20) DEFAULT NULL, `raw_package_txt_id` bigint(20) DEFAULT NULL, `actual_length` double(20,0) DEFAULT NULL, `actual_width` double(20,0) DEFAULT NULL, `length` double(10,0) DEFAULT NULL, `width` double(10,0) DEFAULT NULL, `statu` varchar(50) DEFAULT NULL, `color` varchar(50) DEFAULT NULL, `thickness` varchar(50) DEFAULT NULL, `txtname` varchar(50) DEFAULT NULL, `flag` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `glass_id` (`glass_id`), KEY `raw_package_txt_id` (`raw_package_txt_id`), CONSTRAINT `gmms_preprocessing_glass_ibfk_1` FOREIGN KEY (`glass_id`) REFERENCES `gmms_glass` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_preprocessing_glass_ibfk_2` FOREIGN KEY (`raw_package_txt_id`) REFERENCES `gmms_raw_package_txt` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_preprocessing_glass -- ---------------------------- INSERT INTO `gmms_preprocessing_glass` VALUES ('1', null, null, '603', '805', '807', '605', '匹配成功', '5mm白玻', '8.0', 'M708', '1'); -- ---------------------------- -- Table structure for `gmms_print_machine` -- ---------------------------- DROP TABLE IF EXISTS `gmms_print_machine`; CREATE TABLE `gmms_print_machine` ( `name` varchar(255) DEFAULT NULL COMMENT '名称', `id` bigint(20) NOT NULL AUTO_INCREMENT, `pattern` varchar(255) DEFAULT NULL, `line` varchar(255) DEFAULT NULL, `statu` varchar(255) DEFAULT NULL COMMENT '名称', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_print_machine -- ---------------------------- INSERT INTO `gmms_print_machine` VALUES ('ZDesigner GK888t (EPL)', '1', 'single', '1', '竖打'); INSERT INTO `gmms_print_machine` VALUES ('Golive-two', '2', 'single', '2', '竖打'); -- ---------------------------- -- Table structure for `gmms_print_name` -- ---------------------------- DROP TABLE IF EXISTS `gmms_print_name`; CREATE TABLE `gmms_print_name` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `printname` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_print_name -- ---------------------------- INSERT INTO `gmms_print_name` VALUES ('1', 'ZDesigner GK888t (EPL)one'); INSERT INTO `gmms_print_name` VALUES ('2', 'ZDesigner GK888t (EPL)two'); -- ---------------------------- -- Table structure for `gmms_print_size` -- ---------------------------- DROP TABLE IF EXISTS `gmms_print_size`; CREATE TABLE `gmms_print_size` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `apartidsize` int(11) DEFAULT NULL, `apartidw` int(11) DEFAULT NULL, `apartidh` int(11) DEFAULT NULL, `customersize` int(11) DEFAULT NULL, `customerw` int(11) DEFAULT NULL, `customerh` int(11) DEFAULT NULL, `productionsize` int(11) DEFAULT NULL, `productionw` int(11) DEFAULT NULL, `productionh` int(11) DEFAULT NULL, `lengthStrsize` int(11) DEFAULT NULL, `lengthStrw` int(11) DEFAULT NULL, `lengthStrh` int(11) DEFAULT NULL, `applicationsize` int(11) DEFAULT NULL, `applicationw` int(11) DEFAULT NULL, `applicationh` int(11) DEFAULT NULL, `width` int(11) DEFAULT NULL, `length` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_print_size -- ---------------------------- INSERT INTO `gmms_print_size` VALUES ('1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1'); -- ---------------------------- -- Table structure for `gmms_prod_line_state` -- ---------------------------- DROP TABLE IF EXISTS `gmms_prod_line_state`; CREATE TABLE `gmms_prod_line_state` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `line` int(11) DEFAULT NULL, `state` tinyint(1) DEFAULT NULL, `standalonestate` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_prod_line_state -- ---------------------------- INSERT INTO `gmms_prod_line_state` VALUES ('1', '1', '0', '0'); INSERT INTO `gmms_prod_line_state` VALUES ('2', '2', '0', '0'); -- ---------------------------- -- Table structure for `gmms_raw_package` -- ---------------------------- DROP TABLE IF EXISTS `gmms_raw_package`; CREATE TABLE `gmms_raw_package` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `glass_id` varchar(50) DEFAULT NULL, `pieces` int(11) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `width` double DEFAULT NULL, `height` double DEFAULT NULL, `thickness` double DEFAULT NULL, `color` varchar(50) DEFAULT NULL, `left_pieces` int(11) DEFAULT NULL, `manufacturer` varchar(255) DEFAULT NULL, `comment` varchar(255) DEFAULT NULL, `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `flag` varchar(255) DEFAULT NULL, `raw_package_txt_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `raw_package_txt_id` (`raw_package_txt_id`), CONSTRAINT `gmms_raw_package_ibfk_1` FOREIGN KEY (`raw_package_txt_id`) REFERENCES `gmms_raw_package_txt` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_raw_package -- ---------------------------- INSERT INTO `gmms_raw_package` VALUES ('1', '5C', '20', '使用中', '3660', '2134', '5', 'C', '20', null, null, '2020-04-16 08:54:33', null, null); INSERT INTO `gmms_raw_package` VALUES ('2', '55mm白玻', '20', '等待出库', '3660', '2440', '5', '5mm白玻', '20', null, null, '2020-04-16 08:56:43', null, null); INSERT INTO `gmms_raw_package` VALUES ('3', '55mm白玻', '20', '使用中', '3660', '2134', '5', '5mm白玻', '20', null, null, '2020-04-16 08:57:47', null, null); INSERT INTO `gmms_raw_package` VALUES ('4', '6white', '10', '正在使用', '3660', '2440', '6', 'white', '8', null, null, '2020-04-20 16:15:07', null, null); INSERT INTO `gmms_raw_package` VALUES ('5', '5PLE-60', '10', '正在使用', '3660', '2440', '5', 'PLE-60', '7', null, null, '2020-04-20 16:29:43', null, null); INSERT INTO `gmms_raw_package` VALUES ('6', '8C', '50', '正在使用', '2333', '5555', '8', 'C', '34', null, null, '2020-04-20 16:38:16', null, null); -- ---------------------------- -- Table structure for `gmms_raw_package_txt` -- ---------------------------- DROP TABLE IF EXISTS `gmms_raw_package_txt`; CREATE TABLE `gmms_raw_package_txt` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `txt_name` varchar(50) DEFAULT NULL, `groups` varchar(50) DEFAULT NULL, `status` varchar(50) DEFAULT NULL, `operator` varchar(50) DEFAULT NULL, `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_raw_package_txt -- ---------------------------- INSERT INTO `gmms_raw_package_txt` VALUES ('6', 'bbbbbbbb', '1', '已完成', '1', '2020-04-16 08:48:19'); INSERT INTO `gmms_raw_package_txt` VALUES ('14', '424', '', '等待下发', null, '2020-04-24 13:24:46'); INSERT INTO `gmms_raw_package_txt` VALUES ('18', '4244', '', '等待下发', null, '2020-04-24 17:17:08'); -- ---------------------------- -- Table structure for `gmms_report_task` -- ---------------------------- DROP TABLE IF EXISTS `gmms_report_task`; CREATE TABLE `gmms_report_task` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `opt_name` varchar(50) DEFAULT NULL, `piece` int(11) DEFAULT NULL, `complete_piece` int(11) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `complete_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `reson` varchar(255) DEFAULT NULL, `area` double DEFAULT NULL, `load_machine_id` bigint(20) DEFAULT NULL, `opt_pattern_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `load_machine_id` (`load_machine_id`), KEY `opt_pattern_id` (`opt_pattern_id`), CONSTRAINT `gmms_report_task_ibfk_1` FOREIGN KEY (`load_machine_id`) REFERENCES `gmms_load_machine` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_report_task_ibfk_2` FOREIGN KEY (`opt_pattern_id`) REFERENCES `gmms_opt_pattern` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_report_task -- ---------------------------- INSERT INTO `gmms_report_task` VALUES ('1', 'bbbbbbbb-1', '1', '0', '已完成', '2020-04-16 08:48:19', '2020-04-20 16:14:45', null, '7.81', '1', '11'); INSERT INTO `gmms_report_task` VALUES ('2', 'bbbbbbbb-1', '1', '0', '已完成', '2020-04-16 08:48:19', '2020-04-20 16:14:45', null, '7.81', '1', '12'); -- ---------------------------- -- Table structure for `gmms_report_task_load` -- ---------------------------- DROP TABLE IF EXISTS `gmms_report_task_load`; CREATE TABLE `gmms_report_task_load` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `opt_name` varchar(50) DEFAULT NULL, `piece` int(11) DEFAULT NULL, `complete_piece` int(11) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `complete_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `reson` varchar(255) DEFAULT NULL, `load_machine_id` bigint(20) DEFAULT NULL, `opt_pattern_id` bigint(20) DEFAULT NULL, `area` double DEFAULT NULL, PRIMARY KEY (`id`), KEY `load_machine_id` (`load_machine_id`), KEY `opt_pattern_id` (`opt_pattern_id`), CONSTRAINT `gmms_report_task_load_ibfk_1` FOREIGN KEY (`load_machine_id`) REFERENCES `gmms_load_machine` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_report_task_load_ibfk_2` FOREIGN KEY (`opt_pattern_id`) REFERENCES `gmms_opt_pattern` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_report_task_load -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_shelf` -- ---------------------------- DROP TABLE IF EXISTS `gmms_shelf`; CREATE TABLE `gmms_shelf` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `port` int(11) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `connect_state` varchar(50) DEFAULT NULL, `ip_address` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_shelf -- ---------------------------- INSERT INTO `gmms_shelf` VALUES ('1', '01', '502', '设备停止', '正在连接', '192.168.1.1'); -- ---------------------------- -- Table structure for `gmms_shelf_hoist` -- ---------------------------- DROP TABLE IF EXISTS `gmms_shelf_hoist`; CREATE TABLE `gmms_shelf_hoist` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `raw_package_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `raw_package_id` (`raw_package_id`), CONSTRAINT `gmms_shelf_hoist_ibfk_1` FOREIGN KEY (`raw_package_id`) REFERENCES `gmms_raw_package` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_shelf_hoist -- ---------------------------- INSERT INTO `gmms_shelf_hoist` VALUES ('1', '99', '空闲', null); -- ---------------------------- -- Table structure for `gmms_shelf_message` -- ---------------------------- DROP TABLE IF EXISTS `gmms_shelf_message`; CREATE TABLE `gmms_shelf_message` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `shelf_id` bigint(20) DEFAULT NULL, `reada` tinyint(1) DEFAULT NULL, `message_type` varchar(50) DEFAULT NULL, `client_address` varchar(255) DEFAULT NULL, `client_port` varchar(10) DEFAULT NULL, `content` varchar(5000) DEFAULT NULL, `send_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `receive_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `shelf_id` (`shelf_id`), CONSTRAINT `gmms_shelf_message_ibfk_1` FOREIGN KEY (`shelf_id`) REFERENCES `gmms_shelf` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_shelf_message -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_shelf_rank` -- ---------------------------- DROP TABLE IF EXISTS `gmms_shelf_rank`; CREATE TABLE `gmms_shelf_rank` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `usestatu` varchar(50) DEFAULT NULL, `raw_package_id` bigint(20) DEFAULT NULL, `lastest_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `glass_id` varchar(50) DEFAULT NULL, `pieces` varchar(50) DEFAULT NULL, `width` double DEFAULT NULL, `length` double DEFAULT NULL, `thickness` double DEFAULT NULL, `color` varchar(50) DEFAULT NULL, `precent` varchar(50) DEFAULT NULL, `create_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `complete_pieces` int(11) DEFAULT NULL, `flag` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `raw_package_id` (`raw_package_id`), CONSTRAINT `gmms_shelf_rank_ibfk_1` FOREIGN KEY (`raw_package_id`) REFERENCES `gmms_raw_package` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_shelf_rank -- ---------------------------- INSERT INTO `gmms_shelf_rank` VALUES ('1', '01', '使用中', null, '3', '2018-12-24 16:49:37', '55mm白玻', '20', '3660', '2134', '5', '5mm白玻', null, '2020-04-16 08:57:47', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('2', '02', '使用中', null, '1', '2018-11-08 10:17:39', '5C', '20', '3660', '2134', '5', 'C', null, '2020-04-16 08:54:33', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('3', '03', '等待出库', null, '2', '2019-05-23 13:41:56', '55mm白玻', '20', '3660', '2440', '5', '5mm白玻', null, '2020-04-16 08:56:43', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('4', '04', '空闲', null, null, '2018-11-12 15:32:33', null, null, null, null, null, null, null, '2020-04-20 16:38:16', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('5', '05', '正在使用', null, '5', '2018-11-12 15:32:33', '5PLE-60', '7', '3660', '2440', '5', 'PLE-60', null, '2020-04-20 16:29:43', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('6', '06', '空闲', null, null, '2018-11-12 15:32:37', null, null, null, null, null, null, null, '2020-04-14 15:27:02', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('7', '07', '空闲', null, null, '2018-10-24 15:15:26', null, null, null, null, null, null, null, '2020-04-14 15:27:02', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('8', '08', '空闲', null, null, '2018-10-26 11:01:54', null, null, null, null, null, null, null, '2020-04-14 15:27:02', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('9', '09', '空闲', null, null, '2018-10-20 09:55:31', null, null, null, null, null, null, null, '2020-04-14 15:27:02', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('10', '10', '空闲', null, null, '2019-05-27 11:01:57', null, null, null, null, null, null, null, '2020-04-14 15:27:02', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('11', '11', '空闲', null, null, '2018-10-20 09:55:31', null, null, null, null, null, null, null, '2020-04-14 15:27:02', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('12', '12', '空闲', null, null, '2018-10-20 09:55:32', null, null, null, null, null, null, null, '2020-04-14 15:27:02', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('13', '13', '空闲', null, null, '2018-10-20 09:55:32', null, null, null, null, null, null, null, '2020-04-14 15:27:02', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('14', '14', '空闲', null, null, '2018-10-20 09:55:33', null, null, null, null, null, null, null, '2020-04-14 15:27:02', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('15', '15', '空闲', null, null, '2018-10-20 09:55:35', null, null, null, null, null, null, null, '0000-00-00 00:00:00', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('16', '16', '空闲', null, null, '2018-10-20 09:55:35', null, null, null, null, null, null, null, '0000-00-00 00:00:00', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('17', '17', '空闲', null, null, '2018-10-20 09:55:36', null, null, null, null, null, null, null, '0000-00-00 00:00:00', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('18', '18', '空闲', null, null, '2018-10-20 09:55:36', null, null, null, null, null, null, null, '0000-00-00 00:00:00', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('19', '19', '空闲', null, null, '2018-10-20 09:55:36', null, null, null, null, null, null, null, '0000-00-00 00:00:00', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('20', '20', '空闲', null, null, '2018-10-20 09:55:37', null, null, null, null, null, null, null, '0000-00-00 00:00:00', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('21', '21', '空闲', null, null, '2018-10-20 09:55:38', null, null, null, null, null, null, null, '0000-00-00 00:00:00', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('22', '22', '空闲', null, null, '2018-10-20 09:55:38', null, null, null, null, null, null, null, '0000-00-00 00:00:00', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('23', '23', '空闲', null, null, '2018-10-20 09:55:39', null, null, null, null, null, null, null, '0000-00-00 00:00:00', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('24', '24', '空闲', null, null, '2018-10-20 09:55:39', null, null, null, null, null, null, null, '0000-00-00 00:00:00', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('25', '25', '空闲', null, null, '2018-10-20 09:55:40', null, null, null, null, null, null, null, '0000-00-00 00:00:00', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('26', '26', '空闲', null, null, '2018-10-20 09:55:40', null, null, null, null, null, null, null, '0000-00-00 00:00:00', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('27', '27', '空闲', null, null, '2018-10-20 09:55:41', null, null, null, null, null, null, null, '0000-00-00 00:00:00', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('28', '28', '空闲', null, null, '2018-10-20 09:55:41', null, null, null, null, null, null, null, '0000-00-00 00:00:00', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('29', '29', '空闲', null, null, '2018-10-20 09:55:43', null, null, null, null, null, null, null, '0000-00-00 00:00:00', null, '1'); INSERT INTO `gmms_shelf_rank` VALUES ('30', '30', '空闲', null, null, '2018-10-20 09:55:43', null, null, null, null, null, null, null, '0000-00-00 00:00:00', null, '1'); -- ---------------------------- -- Table structure for `gmms_shelf_statu` -- ---------------------------- DROP TABLE IF EXISTS `gmms_shelf_statu`; CREATE TABLE `gmms_shelf_statu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `autostate` varchar(50) DEFAULT NULL, `errorstate` varchar(50) DEFAULT NULL, `plcid` varchar(50) DEFAULT NULL, `mesid` varchar(50) DEFAULT NULL, `statuid` varchar(50) DEFAULT NULL, `set_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `message` varchar(500) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_shelf_statu -- ---------------------------- INSERT INTO `gmms_shelf_statu` VALUES ('1', '自动', '无故障', '10', '12', '0001', '2020-04-21 11:48:07', '00000000000'); -- ---------------------------- -- Table structure for `gmms_shelf_task` -- ---------------------------- DROP TABLE IF EXISTS `gmms_shelf_task`; CREATE TABLE `gmms_shelf_task` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `state` varchar(50) DEFAULT NULL, `task_type` varchar(255) DEFAULT NULL, `message` varchar(255) DEFAULT NULL, `flag` varchar(255) DEFAULT NULL, `shelf_hoist_id` bigint(20) DEFAULT NULL, `shelf_rank_id` bigint(20) DEFAULT NULL, `load_machine_rack_id` bigint(20) DEFAULT NULL, `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `complete_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `shelf_hoist_id` (`shelf_hoist_id`), KEY `shelf_rank_id` (`shelf_rank_id`), KEY `load_machine_rack_id` (`load_machine_rack_id`), CONSTRAINT `gmms_shelf_task_ibfk_1` FOREIGN KEY (`shelf_hoist_id`) REFERENCES `gmms_shelf_hoist` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_shelf_task_ibfk_2` FOREIGN KEY (`shelf_rank_id`) REFERENCES `gmms_shelf_rank` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_shelf_task_ibfk_3` FOREIGN KEY (`load_machine_rack_id`) REFERENCES `gmms_load_machine_rack` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_shelf_task -- ---------------------------- INSERT INTO `gmms_shelf_task` VALUES ('1', '等待中', '从上片位到仓位', null, '1', null, '4', '2', '2020-04-20 16:39:20', '2020-04-20 16:39:20', '2020-04-20 16:39:20'); INSERT INTO `gmms_shelf_task` VALUES ('2', '等待中', '从上片位到仓位', null, '1', null, '5', '1', '2020-04-20 16:44:43', '2020-04-20 16:44:43', '2020-04-20 16:44:43'); INSERT INTO `gmms_shelf_task` VALUES ('3', '等待中', '从仓位到吊装位', null, '0', '1', '3', null, '2020-04-23 11:25:47', '2020-04-23 11:25:47', '2020-04-23 11:25:47'); INSERT INTO `gmms_shelf_task` VALUES ('4', '等待中', '从吊装位到空仓位', null, '0', '1', '3', null, '2020-04-23 11:25:47', '2020-04-23 11:25:47', '2020-04-23 11:25:47'); -- ---------------------------- -- Table structure for `gmms_singal_glass` -- ---------------------------- DROP TABLE IF EXISTS `gmms_singal_glass`; CREATE TABLE `gmms_singal_glass` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `glass_id` int(11) DEFAULT NULL, `length` double DEFAULT NULL, `width` double DEFAULT NULL, `startlength` double DEFAULT NULL, `startwidth` double DEFAULT NULL, `thickness` double DEFAULT NULL, `color` varchar(25) DEFAULT NULL, `customer` varchar(255) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `groups` varchar(50) DEFAULT NULL, `apart_id` varchar(50) DEFAULT NULL, `manufacture_batch` varchar(255) DEFAULT NULL, `pieces` int(11) DEFAULT NULL, `complete_pieces` int(11) DEFAULT NULL, `arrange_pieces` int(11) DEFAULT NULL, `arrange_statu` varchar(50) DEFAULT NULL, `raw_package_txt_id` bigint(20) DEFAULT NULL, `opt_pattern_id` bigint(20) DEFAULT NULL, `application` varchar(50) DEFAULT NULL, `production` varchar(50) DEFAULT NULL, `floor_number` varchar(50) DEFAULT NULL, `order_number` varchar(50) DEFAULT NULL, `piece_sign` varchar(50) DEFAULT NULL, `remark` varchar(50) DEFAULT NULL, `info_id` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `opt_pattern_id` (`opt_pattern_id`), KEY `raw_package_txt_id` (`raw_package_txt_id`), CONSTRAINT `gmms_singal_glass_ibfk_1` FOREIGN KEY (`opt_pattern_id`) REFERENCES `gmms_opt_pattern` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_singal_glass_ibfk_2` FOREIGN KEY (`raw_package_txt_id`) REFERENCES `gmms_raw_package_txt` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=543 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_singal_glass -- ---------------------------- INSERT INTO `gmms_singal_glass` VALUES ('373', '0', '730', '2132', '733', '2135', '8', 'C', '魏金龙', null, null, 'A1', '424', '1', '0', '0', '', '14', '83', '', null, '', '1', null, '', '40'); INSERT INTO `gmms_singal_glass` VALUES ('374', '0', '975', '1400', '978', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '3', '0', '0', '', '14', '83', '', null, '', '4', null, '', '6'); INSERT INTO `gmms_singal_glass` VALUES ('375', '0', '955', '1290', '958', '1293', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '83', '', null, '', '26', null, '', '28'); INSERT INTO `gmms_singal_glass` VALUES ('376', '0', '945', '1290', '948', '1293', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '83', '', null, '', '8', null, '', '10'); INSERT INTO `gmms_singal_glass` VALUES ('377', '0', '1043', '1700', '1046', '1703', '8', 'C', '李成顺', null, null, 'A1', '424', '2', '0', '0', '', '14', '84', '', null, '', '1', null, '', '1'); INSERT INTO `gmms_singal_glass` VALUES ('378', '0', '1304', '2327', '1307', '2330', '8', 'C', '魏金龙', null, null, 'A1', '424', '1', '0', '0', '', '14', '84', '', null, '', '2', null, '', '41'); INSERT INTO `gmms_singal_glass` VALUES ('379', '0', '1175', '1255', '1178', '1258', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '84', '', null, '', '20', null, '', '22'); INSERT INTO `gmms_singal_glass` VALUES ('380', '0', '1043', '1700', '1046', '1703', '8', 'C', '李成顺', null, null, 'A1', '424', '3', '0', '0', '', '14', '85', '', null, '', '1', null, '', '1'); INSERT INTO `gmms_singal_glass` VALUES ('381', '0', '585', '1950', '588', '1953', '8', 'C', '张伟', null, null, 'A1', '424', '1', '0', '0', '', '14', '85', '', null, '', '1', null, '', '34'); INSERT INTO `gmms_singal_glass` VALUES ('382', '0', '648', '1096', '651', '1099', '8', 'C', '固恒', null, null, 'A1', '424', '1', '0', '0', '', '14', '85', '', null, '', '2', null, '', '37'); INSERT INTO `gmms_singal_glass` VALUES ('383', '0', '405', '2125', '408', '2128', '8', 'C', '张伟', null, null, 'A1', '424', '1', '0', '0', '', '14', '85', '', null, '', '2', null, '', '35'); INSERT INTO `gmms_singal_glass` VALUES ('384', '0', '1043', '1700', '1046', '1703', '8', 'C', '李成顺', null, null, 'A1', '424', '2', '0', '0', '', '14', '86', '', null, '', '1', null, '', '1'); INSERT INTO `gmms_singal_glass` VALUES ('385', '0', '1175', '1400', '1178', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '86', '', null, '', '18', null, '', '20'); INSERT INTO `gmms_singal_glass` VALUES ('386', '0', '1175', '1290', '1178', '1293', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '86', '', null, '', '19', null, '', '21'); INSERT INTO `gmms_singal_glass` VALUES ('387', '0', '980', '1290', '983', '1293', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '86', '', null, '', '9', null, '', '11'); INSERT INTO `gmms_singal_glass` VALUES ('388', '0', '1043', '1700', '1046', '1703', '8', 'C', '李成顺', null, null, 'A1', '424', '2', '0', '0', '', '14', '87', '', null, '', '1', null, '', '1'); INSERT INTO `gmms_singal_glass` VALUES ('389', '0', '1195', '1255', '1198', '1258', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '87', '', null, '', '24', null, '', '26'); INSERT INTO `gmms_singal_glass` VALUES ('390', '0', '1175', '1255', '1178', '1258', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '87', '', null, '', '20', null, '', '22'); INSERT INTO `gmms_singal_glass` VALUES ('391', '0', '1120', '1290', '1123', '1293', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '87', '', null, '', '1', null, '', '3'); INSERT INTO `gmms_singal_glass` VALUES ('392', '0', '1043', '1700', '1046', '1703', '8', 'C', '李成顺', null, null, 'A1', '424', '2', '0', '0', '', '14', '88', '', null, '', '1', null, '', '1'); INSERT INTO `gmms_singal_glass` VALUES ('393', '0', '1175', '1400', '1178', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '88', '', null, '', '18', null, '', '20'); INSERT INTO `gmms_singal_glass` VALUES ('394', '0', '1175', '1290', '1178', '1293', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '88', '', null, '', '19', null, '', '21'); INSERT INTO `gmms_singal_glass` VALUES ('395', '0', '975', '1290', '978', '1293', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '88', '', null, '', '3', null, '', '5'); INSERT INTO `gmms_singal_glass` VALUES ('396', '0', '1043', '1700', '1046', '1703', '8', 'C', '李成顺', null, null, 'A1', '424', '2', '0', '0', '', '14', '89', '', null, '', '1', null, '', '1'); INSERT INTO `gmms_singal_glass` VALUES ('397', '0', '1125', '1400', '1128', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '89', '', null, '', '12', null, '', '14'); INSERT INTO `gmms_singal_glass` VALUES ('398', '0', '1200', '1290', '1203', '1293', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '89', '', null, '', '15', null, '', '17'); INSERT INTO `gmms_singal_glass` VALUES ('399', '0', '990', '1290', '993', '1293', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '89', '', null, '', '25', null, '', '27'); INSERT INTO `gmms_singal_glass` VALUES ('400', '0', '1043', '1700', '1046', '1703', '8', 'C', '李成顺', null, null, 'A1', '424', '2', '0', '0', '', '14', '90', '', null, '', '1', null, '', '1'); INSERT INTO `gmms_singal_glass` VALUES ('401', '0', '648', '776', '651', '779', '8', 'C', '固恒', null, null, 'A1', '424', '2', '0', '0', '', '14', '90', '', null, '', '1', null, '', '36'); INSERT INTO `gmms_singal_glass` VALUES ('402', '0', '1200', '1400', '1203', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '90', '', null, '', '16', null, '', '18'); INSERT INTO `gmms_singal_glass` VALUES ('403', '0', '1195', '1400', '1198', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '90', '', null, '', '21', null, '', '23'); INSERT INTO `gmms_singal_glass` VALUES ('404', '0', '1043', '1700', '1046', '1703', '8', 'C', '李成顺', null, null, 'A1', '424', '2', '0', '0', '', '14', '91', '', null, '', '1', null, '', '1'); INSERT INTO `gmms_singal_glass` VALUES ('405', '0', '1125', '1400', '1128', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '91', '', null, '', '12', null, '', '14'); INSERT INTO `gmms_singal_glass` VALUES ('406', '0', '1195', '1290', '1198', '1293', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '91', '', null, '', '23', null, '', '25'); INSERT INTO `gmms_singal_glass` VALUES ('407', '0', '970', '1280', '973', '1283', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '91', '', null, '', '28', null, '', '30'); INSERT INTO `gmms_singal_glass` VALUES ('408', '0', '1043', '1700', '1046', '1703', '8', 'C', '李成顺', null, null, 'A1', '424', '2', '0', '0', '', '14', '92', '', null, '', '1', null, '', '1'); INSERT INTO `gmms_singal_glass` VALUES ('409', '0', '1120', '1400', '1123', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '92', '', null, '', '2', null, '', '4'); INSERT INTO `gmms_singal_glass` VALUES ('410', '0', '1210', '1240', '1213', '1243', '8', 'C', '杨广付', null, null, 'A1', '424', '1', '0', '0', '', '14', '92', '', null, '', '2', null, '', '39'); INSERT INTO `gmms_singal_glass` VALUES ('411', '0', '995', '1290', '998', '1293', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '92', '', null, '', '5', null, '', '7'); INSERT INTO `gmms_singal_glass` VALUES ('412', '0', '1175', '1820', '1178', '1823', '8', 'C', '韩宝东', null, null, 'A1', '424', '2', '0', '0', '', '14', '93', '', null, '', '14', null, '', '16'); INSERT INTO `gmms_singal_glass` VALUES ('413', '0', '1043', '1700', '1046', '1703', '8', 'C', '李成顺', null, null, 'A1', '424', '2', '0', '0', '', '14', '93', '', null, '', '1', null, '', '1'); INSERT INTO `gmms_singal_glass` VALUES ('414', '0', '1043', '1700', '1046', '1703', '8', 'C', '李成顺', null, null, 'A1', '424', '2', '0', '0', '', '14', '94', '', null, '', '1', null, '', '1'); INSERT INTO `gmms_singal_glass` VALUES ('415', '0', '995', '1400', '998', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '94', '', null, '', '6', null, '', '8'); INSERT INTO `gmms_singal_glass` VALUES ('416', '0', '1200', '1255', '1203', '1258', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '94', '', null, '', '17', null, '', '19'); INSERT INTO `gmms_singal_glass` VALUES ('417', '0', '995', '1290', '998', '1293', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '94', '', null, '', '5', null, '', '7'); INSERT INTO `gmms_singal_glass` VALUES ('418', '0', '1043', '1700', '1046', '1703', '8', 'C', '李成顺', null, null, 'A1', '424', '2', '0', '0', '', '14', '95', '', null, '', '1', null, '', '1'); INSERT INTO `gmms_singal_glass` VALUES ('419', '0', '970', '1400', '973', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '95', '', null, '', '29', null, '', '31'); INSERT INTO `gmms_singal_glass` VALUES ('420', '0', '955', '1400', '958', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '95', '', null, '', '27', null, '', '29'); INSERT INTO `gmms_singal_glass` VALUES ('421', '0', '995', '1400', '998', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '95', '', null, '', '6', null, '', '8'); INSERT INTO `gmms_singal_glass` VALUES ('422', '0', '1043', '1700', '1046', '1703', '8', 'C', '李成顺', null, null, 'A1', '424', '2', '0', '0', '', '14', '96', '', null, '', '1', null, '', '1'); INSERT INTO `gmms_singal_glass` VALUES ('423', '0', '990', '1400', '993', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '96', '', null, '', '22', null, '', '24'); INSERT INTO `gmms_singal_glass` VALUES ('424', '0', '1125', '1280', '1128', '1283', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '96', '', null, '', '11', null, '', '13'); INSERT INTO `gmms_singal_glass` VALUES ('425', '0', '975', '1290', '978', '1293', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '96', '', null, '', '3', null, '', '5'); INSERT INTO `gmms_singal_glass` VALUES ('426', '0', '1043', '1700', '1046', '1703', '8', 'C', '李成顺', null, null, 'A1', '424', '1', '0', '0', '', '14', '97', '', null, '', '1', null, '', '1'); INSERT INTO `gmms_singal_glass` VALUES ('427', '0', '1043', '1700', '1046', '1703', '8', 'C', '李成顺', null, null, 'A1', '424', '1', '0', '0', '打孔', '14', '97', '', null, '', '2', null, '', '2'); INSERT INTO `gmms_singal_glass` VALUES ('428', '0', '980', '1400', '983', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '97', '', null, '', '10', null, '', '12'); INSERT INTO `gmms_singal_glass` VALUES ('429', '0', '945', '1400', '948', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '97', '', null, '', '7', null, '', '9'); INSERT INTO `gmms_singal_glass` VALUES ('430', '0', '990', '1400', '993', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '有豁', '14', '97', '', null, '', '30', null, '', '32'); INSERT INTO `gmms_singal_glass` VALUES ('431', '0', '1043', '1700', '1046', '1703', '8', 'C', '李成顺', null, null, 'A1', '424', '2', '0', '0', '', '14', '98', '', null, '', '1', null, '', '1'); INSERT INTO `gmms_singal_glass` VALUES ('432', '0', '995', '1400', '998', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '有豁', '14', '98', '', null, '', '31', null, '', '33'); INSERT INTO `gmms_singal_glass` VALUES ('433', '0', '975', '1400', '978', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '98', '', null, '', '4', null, '', '6'); INSERT INTO `gmms_singal_glass` VALUES ('434', '0', '945', '1400', '948', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '98', '', null, '', '7', null, '', '9'); INSERT INTO `gmms_singal_glass` VALUES ('435', '0', '1043', '1700', '1046', '1703', '8', 'C', '李成顺', null, null, 'A1', '424', '2', '0', '0', '', '14', '99', '', null, '', '1', null, '', '1'); INSERT INTO `gmms_singal_glass` VALUES ('436', '0', '1385', '1820', '1388', '1823', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '99', '', null, '', '13', null, '', '15'); INSERT INTO `gmms_singal_glass` VALUES ('437', '0', '995', '1400', '998', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '99', '', null, '', '6', null, '', '8'); INSERT INTO `gmms_singal_glass` VALUES ('438', '0', '980', '1400', '983', '1403', '8', 'C', '韩宝东', null, null, 'A1', '424', '1', '0', '0', '', '14', '100', '', null, '', '10', null, '', '12'); INSERT INTO `gmms_singal_glass` VALUES ('439', '0', '975', '1210', '978', '1213', '8', 'C', '杨广付', null, null, 'A1', '424', '5', '0', '0', '', '14', '100', '', null, '', '1', null, '', '38'); INSERT INTO `gmms_singal_glass` VALUES ('440', '0', '975', '1210', '978', '1213', '8', 'C', '杨广付', null, null, 'A1', '424', '3', '0', '0', '', '14', '101', '', null, '', '1', null, '', '38'); INSERT INTO `gmms_singal_glass` VALUES ('536', '0', '1022', '1500', '1022', '1500', '12', 'C', '张学军', null, null, 'A1', '4244', '2', '0', '0', '', '18', '145', '', '12厘钢化', '', '1', 'A', '', '1'); INSERT INTO `gmms_singal_glass` VALUES ('537', '0', '830', '1790', '830', '1790', '12', 'C', '于海泉', null, null, 'A1', '4244', '1', '0', '0', '', '18', '145', '', '12厘钢化', '', '1', 'A', '', '2'); INSERT INTO `gmms_singal_glass` VALUES ('538', '0', '784', '2295', '784', '2295', '12', 'C', '薛柏森', null, null, 'A1', '4244', '1', '0', '0', '', '18', '145', '', '12厘钢化', '', '3', 'A', '', '5'); INSERT INTO `gmms_singal_glass` VALUES ('539', '0', '784', '2280', '784', '2280', '12', 'C', '薛柏森', null, null, 'A1', '4244', '1', '0', '0', '', '18', '145', '', '12厘钢化', '', '4', 'A', '', '6'); INSERT INTO `gmms_singal_glass` VALUES ('540', '0', '1750', '2240', '1750', '2240', '12', 'C', '薛柏森', null, null, 'A1', '4244', '1', '0', '0', '', '18', '146', '', '12厘钢化', '', '2', 'A', '', '4'); INSERT INTO `gmms_singal_glass` VALUES ('541', '0', '1715', '2240', '1715', '2240', '12', 'C', '薛柏森', null, null, 'A1', '4244', '1', '0', '0', '', '18', '146', '', '12厘钢化', '', '1', 'A', '', '3'); INSERT INTO `gmms_singal_glass` VALUES ('542', '0', '814', '2280', '814', '2280', '12', 'C', '薛柏森', null, null, 'A1', '4244', '1', '0', '0', '', '18', '147', '', '12厘钢化', '', '5', 'A', '', '7'); -- ---------------------------- -- 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) NOT NULL, `description` varchar(255) DEFAULT NULL, `user_id` bigint(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; -- ---------------------------- -- 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_test_out` -- ---------------------------- DROP TABLE IF EXISTS `gmms_test_out`; CREATE TABLE `gmms_test_out` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `name` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_test_out -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_toughening_glass` -- ---------------------------- DROP TABLE IF EXISTS `gmms_toughening_glass`; CREATE TABLE `gmms_toughening_glass` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `actual_length` double DEFAULT NULL, `actual_width` double DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `glass_id` bigint(20) DEFAULT NULL, `manufacture_batch_id` bigint(20) DEFAULT NULL, `measure_machine_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `manufacture_batch_id` (`manufacture_batch_id`), KEY `glass_id` (`glass_id`), KEY `measure_machine_id` (`measure_machine_id`), CONSTRAINT `gmms_toughening_glass_ibfk_1` FOREIGN KEY (`manufacture_batch_id`) REFERENCES `gmms_manufacture_batch` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_toughening_glass_ibfk_2` FOREIGN KEY (`glass_id`) REFERENCES `gmms_glass` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_toughening_glass_ibfk_3` FOREIGN KEY (`measure_machine_id`) REFERENCES `gmms_measure_machine` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_toughening_glass -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_toughening_group` -- ---------------------------- DROP TABLE IF EXISTS `gmms_toughening_group`; CREATE TABLE `gmms_toughening_group` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_toughening_group -- ---------------------------- -- ---------------------------- -- 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) NOT NULL, `name` varchar(64) NOT NULL, `password` varchar(255) NOT NULL, `salt` varchar(64) NOT NULL, `roles` varchar(255) NOT NULL, `groups` varchar(255) NOT NULL, `register_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `login_name` (`login_name`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; -- ---------------------------- -- 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'); -- ---------------------------- -- Table structure for `gmms_wash_machine` -- ---------------------------- DROP TABLE IF EXISTS `gmms_wash_machine`; CREATE TABLE `gmms_wash_machine` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `connect_state` varchar(50) DEFAULT NULL, `picture_url` varchar(255) DEFAULT NULL, `port` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_wash_machine -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_with_pieces_statu` -- ---------------------------- DROP TABLE IF EXISTS `gmms_with_pieces_statu`; CREATE TABLE `gmms_with_pieces_statu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `state` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_with_pieces_statu -- ---------------------------- INSERT INTO `gmms_with_pieces_statu` VALUES ('1', 'waiting');