/*
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', '[REDACTED]', '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');
