/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50528
Source Host           : localhost:3306
Source Database       : gmms2_gangda

Target Server Type    : MYSQL
Target Server Version : 50528
File Encoding         : 65001

Date: 2021-01-31 19:06:53
*/

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=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_count_machine
-- ----------------------------
INSERT INTO `gmms_count_machine` VALUES ('1', '01', '设备停止', '未连接', '8150');
INSERT INTO `gmms_count_machine` VALUES ('2', '02', '设备停止', '未连接', '8151');

-- ----------------------------
-- 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,
  `gmms_raw_package_txt_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `glass_id` (`glass_id`),
  KEY `count_machine_id` (`count_machine_id`),
  KEY `gmms_raw_package_txt_id` (`gmms_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 (`gmms_raw_package_txt_id`) REFERENCES `gmms_raw_package_txt` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_count_machine_task
-- ----------------------------

-- ----------------------------
-- Table structure for `gmms_cut_machine`
-- ----------------------------
DROP TABLE IF EXISTS `gmms_cut_machine`;
CREATE TABLE `gmms_cut_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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_cut_machine
-- ----------------------------
INSERT INTO `gmms_cut_machine` VALUES ('1', '01', null, null, null, '3000');
INSERT INTO `gmms_cut_machine` VALUES ('2', '02', null, null, null, '3001');

-- ----------------------------
-- 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_dummy_fix_rack`
-- ----------------------------
DROP TABLE IF EXISTS `gmms_dummy_fix_rack`;
CREATE TABLE `gmms_dummy_fix_rack` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `glass_id` varchar(50) DEFAULT NULL,
  `pieces` int(11) unsigned zerofill 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) unsigned zerofill DEFAULT NULL,
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_dummy_fix_rack
-- ----------------------------
INSERT INTO `gmms_dummy_fix_rack` VALUES ('1', null, '00000000000', '空闲', '01', '0', '0', '0', null, '00000000000', '2019-03-19 16:10:44');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('2', null, '00000000000', '空闲', '02', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('3', null, '00000000012', '使用中', '03', '3333', '2222', '12', 'PLC-80', '00000000012', '2019-03-19 16:10:54');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('4', null, '00000000000', '空闲', '04', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('5', null, '00000000012', '使用中', '05', '2222', '2222', '12', 'C', '00000000012', '2019-03-19 16:11:13');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('6', null, '00000000000', '空闲', '06', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('7', null, '00000000012', '使用中', '07', '4444', '2222', '8', 'PLE-60', '00000000012', '2019-03-19 16:11:35');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('8', null, '00000000012', '使用中', '08', '1234', '1234', '8', 'PLC-80', '00000000012', '2019-03-19 16:11:53');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('9', null, '00000000000', '空闲', '09', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('10', null, '00000000000', '空闲', '10', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('11', null, '00000000000', '空闲', '11', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('12', null, '00000000000', '空闲', '12', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('13', null, '00000000000', '空闲', '13', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('14', null, '00000000000', '空闲', '14', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('15', null, '00000000000', '空闲', '15', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('16', null, '00000000000', '空闲', '16', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('17', null, '00000000000', '空闲', '17', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('18', null, '00000000000', '空闲', '18', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('19', null, '00000000000', '空闲', '19', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('20', null, '00000000000', '空闲', '20', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('21', null, '00000000000', '空闲', '21', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('22', null, '00000000000', '空闲', '22', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('23', null, '00000000000', '空闲', '23', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('24', null, '00000000000', '空闲', '24', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('25', null, '00000000000', '空闲', '25', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('26', null, '00000000000', '空闲', '26', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('27', null, '00000000000', '空闲', '27', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('28', null, '00000000000', '空闲', '28', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('29', null, '00000000000', '空闲', '29', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');
INSERT INTO `gmms_dummy_fix_rack` VALUES ('30', null, '00000000000', '空闲', '30', '0', '0', '0', null, '00000000000', '2019-03-18 11:17:03');

-- ----------------------------
-- 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_gaoliwei_machine
-- ----------------------------
INSERT INTO `gmms_gaoliwei_machine` VALUES ('1', '01', '设备停止', '正在连接', '8130');
INSERT INTO `gmms_gaoliwei_machine` VALUES ('2', '02', '设备停止', '正在连接', '8131');

-- ----------------------------
-- 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_gaoliwei_statu
-- ----------------------------
INSERT INTO `gmms_gaoliwei_statu` VALUES ('1', '0000', '0', '0', '0', '2019-01-03 13:45:50');
INSERT INTO `gmms_gaoliwei_statu` VALUES ('2', '0000', '0', '0', '0', '2018-11-08 15:46:46');

-- ----------------------------
-- 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,
  `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,
  `manufacture_batch_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 '出处',
  `flag` int(10) unsigned zerofill DEFAULT NULL,
  `info_id` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `manufacture_batch_id` (`manufacture_batch_id`),
  CONSTRAINT `gmms_glass_ibfk_1` FOREIGN KEY (`manufacture_batch_id`) REFERENCES `gmms_manufacture_batch` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_glass
-- ----------------------------
INSERT INTO `gmms_glass` VALUES ('1', '1', '2144', '786', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.05', 'M8252', '18', '0', '0', '0', '3', null, '0100177220', '5mm白钢+9A+5mm白钢双钢中空', '2#，TM1823,2-顶层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '35');
INSERT INTO `gmms_glass` VALUES ('2', '2', '2144', '786', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.05', 'M8252', '6', '0', '0', '0', '3', null, '0100177220', '5mm白钢+9A+5mm白钢双钢中空', '2#，TM1823,2-顶层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '9');
INSERT INTO `gmms_glass` VALUES ('3', '3', '1180', '631', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.09', 'M8252', '14', '0', '0', '0', '7', null, '0100177224', '5mm白钢+9A+5mm白钢双钢中空', '2#，C3221a,6、8、10、12、14、16、18，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '17');
INSERT INTO `gmms_glass` VALUES ('4', '4', '2144', '786', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.05', 'M8252', '18', '0', '0', '0', '3', null, '0200177220', '5mm白钢+9A+5mm白钢双钢中空', '2#，TM1823,2-顶层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '36');
INSERT INTO `gmms_glass` VALUES ('5', '5', '2144', '786', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.05', 'M8252', '6', '0', '0', '0', '3', null, '0200177220', '5mm白钢+9A+5mm白钢双钢中空', '2#，TM1823,2-顶层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '10');
INSERT INTO `gmms_glass` VALUES ('6', '6', '1180', '631', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.09', 'M8252', '14', '0', '0', '0', '7', null, '0200177224', '5mm白钢+9A+5mm白钢双钢中空', '2#，C3221a,6、8、10、12、14、16、18，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '18');
INSERT INTO `gmms_glass` VALUES ('7', '7', '2144', '786', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.06', 'M8252', '18', '0', '0', '0', '4', null, '0100177221', '5mm白钢+9A+5mm白钢双钢中空', '2#，TM1823,2-顶层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '37');
INSERT INTO `gmms_glass` VALUES ('8', '8', '2144', '786', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.06', 'M8252', '6', '0', '0', '0', '4', null, '0100177221', '5mm白钢+9A+5mm白钢双钢中空', '2#，TM1823,2-顶层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '11');
INSERT INTO `gmms_glass` VALUES ('9', '9', '1180', '631', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.10', 'M8252', '24', '0', '0', '0', '7', null, '0100177225', '5mm白钢+9A+5mm白钢双钢中空', '2#，C9821a,6、10、14、18，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '19');
INSERT INTO `gmms_glass` VALUES ('10', '10', '2144', '786', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.06', 'M8252', '18', '0', '0', '0', '4', null, '0200177221', '5mm白钢+9A+5mm白钢双钢中空', '2#，TM1823,2-顶层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '38');
INSERT INTO `gmms_glass` VALUES ('11', '11', '631', '786', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.06', 'M8252', '6', '0', '0', '0', '4', null, '0200177221', '5mm白钢+9A+5mm白钢双钢中空', '2#，TM1823,2-顶层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '12');
INSERT INTO `gmms_glass` VALUES ('12', '12', '2144', '786', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.07', 'M8252', '24', '0', '0', '0', '5', null, '0100177222', '5mm白钢+9A+5mm白钢双钢中空', '2#，TM1823,2-顶层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '13');
INSERT INTO `gmms_glass` VALUES ('13', '13', '537', '317', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.01', 'M8252', '24', '0', '0', '0', '1', null, '0100177216', '5mm白钢+9A+5mm白钢双钢中空', '2#，C0914\',复式下层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '1');
INSERT INTO `gmms_glass` VALUES ('14', '14', '1180', '631', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.10', 'M8252', '24', '0', '0', '0', '7', null, '0200177225', '5mm白钢+9A+5mm白钢双钢中空', '2#，C9821a,6、10、14、18，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '20');
INSERT INTO `gmms_glass` VALUES ('15', '15', '631', '317', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.01', 'M8252', '24', '0', '0', '0', '1', null, '0200177216', '5mm白钢+9A+5mm白钢双钢中空', '2#，C0914\',复式下层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '2');
INSERT INTO `gmms_glass` VALUES ('16', '16', '537', '317', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.02', 'M8252', '24', '0', '0', '0', '1', null, '0100177217', '5mm白钢+9A+5mm白钢双钢中空', '2#，C0914\',复式下层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '3');
INSERT INTO `gmms_glass` VALUES ('17', '17', '2144', '786', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.07', 'M8252', '24', '0', '0', '0', '5', null, '0200177222', '5mm白钢+9A+5mm白钢双钢中空', '2#，TM1823,2-顶层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '14');
INSERT INTO `gmms_glass` VALUES ('18', '18', '631', '317', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.02', 'M8252', '24', '0', '0', '0', '1', null, '0200177217', '5mm白钢+9A+5mm白钢双钢中空', '2#，C0914\',复式下层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '4');
INSERT INTO `gmms_glass` VALUES ('19', '19', '537', '317', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.03', 'M8252', '24', '0', '0', '0', '2', null, '0100177218', '5mm白钢+9A+5mm白钢双钢中空', '2#，C0914\',复式下层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '5');
INSERT INTO `gmms_glass` VALUES ('20', '20', '1180', '631', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.11', 'M8252', '18', '0', '0', '0', '7', null, '0100177226', '5mm白钢+9A+5mm白钢双钢中空', '2#，C9819,8、12、16，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '21');
INSERT INTO `gmms_glass` VALUES ('21', '21', '537', '317', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.03', 'M8252', '24', '0', '0', '0', '2', null, '0200177218', '5mm白钢+9A+5mm白钢双钢中空', '2#，C0914\',复式下层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '6');
INSERT INTO `gmms_glass` VALUES ('22', '22', '2144', '786', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.08', 'M8252', '24', '0', '0', '0', '6', null, '0100177223', '5mm白钢+9A+5mm白钢双钢中空', '2#，TM1823,2-顶层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '15');
INSERT INTO `gmms_glass` VALUES ('23', '23', '631', '317', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.04', 'M8252', '24', '0', '0', '0', '2', null, '0100177219', '5mm白钢+9A+5mm白钢双钢中空', '2#，C0914\',复式下层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '7');
INSERT INTO `gmms_glass` VALUES ('24', '24', '537', '317', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.04', 'M8252', '24', '0', '0', '0', '2', null, '0200177219', '5mm白钢+9A+5mm白钢双钢中空', '2#，C0914\',复式下层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '8');
INSERT INTO `gmms_glass` VALUES ('25', '25', '1180', '631', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.11', 'M8252', '18', '0', '0', '0', '7', null, '0200177226', '5mm白钢+9A+5mm白钢双钢中空', '2#，C9819,8、12、16，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '22');
INSERT INTO `gmms_glass` VALUES ('26', '26', '2144', '786', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.08', 'M8252', '24', '0', '0', '0', '6', null, '0200177223', '5mm白钢+9A+5mm白钢双钢中空', '2#，TM1823,2-顶层，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '16');
INSERT INTO `gmms_glass` VALUES ('27', '27', '631', '631', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.12', 'M8252', '2', '0', '0', '0', '8', null, '0100177227', '5mm白钢+9A+5mm白钢双钢中空', '2#，C3217,4，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '23');
INSERT INTO `gmms_glass` VALUES ('28', '28', '631', '631', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.12', 'M8252', '2', '0', '0', '0', '8', null, '0200177227', '5mm白钢+9A+5mm白钢双钢中空', '2#，C3217,4，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '24');
INSERT INTO `gmms_glass` VALUES ('29', '29', '631', '631', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.12', 'M8252', '6', '0', '0', '0', '8', null, '0100177228', '5mm白钢+9A+5mm白钢双钢中空', '2#，C9817,4，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '25');
INSERT INTO `gmms_glass` VALUES ('30', '30', '631', '631', '5', 'C', '泉州亚林新材料（洛江世茂璀璨天城01地块）', null, null, 'G20001671.12', 'M8252', '6', '0', '0', '0', '8', null, '0200177228', '5mm白钢+9A+5mm白钢双钢中空', '2#，C9817,4，扇玻', '切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)', '5mm白玻钢化', '只印3C标志带编码', '未发送', '未发送', '泉州市南安市福建宏茂科技有限公司东南90米工厂', '0000000000', '26');

-- ----------------------------
-- Table structure for `gmms_glass_commer`
-- ----------------------------
DROP TABLE IF EXISTS `gmms_glass_commer`;
CREATE TABLE `gmms_glass_commer` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_glass_commer
-- ----------------------------
INSERT INTO `gmms_glass_commer` VALUES ('1', '台玻');
INSERT INTO `gmms_glass_commer` VALUES ('3', '北玻');

-- ----------------------------
-- 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=12 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');

-- ----------------------------
-- 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=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_identify_floor
-- ----------------------------
INSERT INTO `gmms_identify_floor` VALUES ('1', '2', '2');
INSERT INTO `gmms_identify_floor` VALUES ('2', '2', '2');

-- ----------------------------
-- 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,
  `initialized` tinyint(1) DEFAULT NULL,
  `ceiling` int(11) DEFAULT NULL,
  `floor` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_identify_machine
-- ----------------------------

-- ----------------------------
-- 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,
  `thinckness` int(11) DEFAULT NULL,
  `resize` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_identify_pattern
-- ----------------------------
INSERT INTO `gmms_identify_pattern` VALUES ('1', 'old', null, '5', null);
INSERT INTO `gmms_identify_pattern` VALUES ('2', 'old', null, '5', null);

-- ----------------------------
-- 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,
  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=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_load_machine
-- ----------------------------
INSERT INTO `gmms_load_machine` VALUES ('1', '01', '设备停止', '正在连接', '8120', null, 'CUTMACHINE1_M8259_2020-04-13-15-37-04.opt', '1');
INSERT INTO `gmms_load_machine` VALUES ('2', '02', '设备停止', '正在连接', '8121', null, 'CUTMACHINE2_DeBug0014_2019-01-17-15-48-01.opt', '2');

-- ----------------------------
-- 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-02-21 19:52:09');
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=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_load_machine_rack
-- ----------------------------
INSERT INTO `gmms_load_machine_rack` VALUES ('1', '101', '空闲', '', null, '1', null);
INSERT INTO `gmms_load_machine_rack` VALUES ('2', '102', '空闲', '', null, '1', null);
INSERT INTO `gmms_load_machine_rack` VALUES ('3', '103', '空闲', '', null, '2', null);
INSERT INTO `gmms_load_machine_rack` VALUES ('4', '104', '空闲', '', null, '2', 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_load_statu
-- ----------------------------
INSERT INTO `gmms_load_statu` VALUES ('1', 'MES全自动', '0', '上片完成', '10', '12', '0', '2018-11-09 17:12:08');
INSERT INTO `gmms_load_statu` VALUES ('2', '无设备', '0', '0', '0', '0', '0', '2019-08-29 16:16:20');

-- ----------------------------
-- 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=24 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_opt_pattern
-- ----------------------------
INSERT INTO `gmms_opt_pattern` VALUES ('1', 'M8252_01', '5C', '5C', '5', '6', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=6\r\nWidth=3660\r\nHeight=2440\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2144\r\nY=786 Info=35\r\nY=786 Info=35\r\nY=786 Info=35\r\nX=786\r\nY=2144 Info=9\r\nX=631\r\nY=1180 Info=17\r\nY=1180 Info=17\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2367.00\r\nx=3.00 y=2368.00 X=2153.00 Y=2368.00\r\nx=2154.00 y=2439.00 X=2154.00 Y=11.00\r\nx=2153.00 y=796.00 X=11.00 Y=796.00\r\nx=11.00 y=1582.00 X=2153.00 Y=1582.00\r\nx=2155.00 y=2154.00 X=2939.00 Y=2154.00\r\nx=2941.00 y=2370.00 X=3570.00 Y=2370.00\r\nx=3571.00 y=2439.00 X=3571.00 Y=1.00\r\nx=3570.00 y=10.00 X=1.00 Y=10.00\r\nx=2940.00 y=11.00 X=2940.00 Y=2437.00\r\nx=2941.00 y=1190.00 X=3570.00 Y=1190.00\r\n\r\n[Info]\r\nId=9\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.05*3*0100177220\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=4\r\n\r\n[Info]\r\nId=35\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.05*3*0100177220\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =2144.000\r\nSheetHeight=786.000\r\nQuantityOnLayer=4\r\n\r\n[Info]\r\nId=17\r\nOrderNo=631*1180*14\r\nPosNo=G20001671.09*7*0100177224\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C3221a,6、8、10、12、14、16、18，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('2', 'M8252_02', '5C', '5C', '5', '1', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660\r\nHeight=2440\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2144\r\nY=786 Info=36\r\nY=786 Info=36\r\nY=786 Info=36\r\nX=786\r\nY=2144 Info=10\r\nX=631\r\nY=1180 Info=17\r\nY=1180 Info=17\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2367.00\r\nx=3.00 y=2368.00 X=2153.00 Y=2368.00\r\nx=2154.00 y=2439.00 X=2154.00 Y=11.00\r\nx=2153.00 y=796.00 X=11.00 Y=796.00\r\nx=11.00 y=1582.00 X=2153.00 Y=1582.00\r\nx=2155.00 y=2154.00 X=2939.00 Y=2154.00\r\nx=2941.00 y=2370.00 X=3570.00 Y=2370.00\r\nx=3571.00 y=2439.00 X=3571.00 Y=1.00\r\nx=3570.00 y=10.00 X=1.00 Y=10.00\r\nx=2940.00 y=11.00 X=2940.00 Y=2437.00\r\nx=2941.00 y=1190.00 X=3570.00 Y=1190.00\r\n\r\n[Info]\r\nId=10\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.05*3*0200177220\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=4\r\n\r\n[Info]\r\nId=36\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.05*3*0200177220\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =2144.000\r\nSheetHeight=786.000\r\nQuantityOnLayer=4\r\n\r\n[Info]\r\nId=17\r\nOrderNo=631*1180*14\r\nPosNo=G20001671.09*7*0100177224\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C3221a,6、8、10、12、14、16、18，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('3', 'M8252_03', '5C', '5C', '5', '5', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=5\r\nWidth=3660\r\nHeight=2440\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2144\r\nY=786 Info=36\r\nY=786 Info=36\r\nY=786 Info=36\r\nX=786\r\nY=2144 Info=10\r\nX=631\r\nY=1180 Info=18\r\nY=1180 Info=18\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2367.00\r\nx=3.00 y=2368.00 X=2153.00 Y=2368.00\r\nx=2154.00 y=2439.00 X=2154.00 Y=11.00\r\nx=2153.00 y=796.00 X=11.00 Y=796.00\r\nx=11.00 y=1582.00 X=2153.00 Y=1582.00\r\nx=2155.00 y=2154.00 X=2939.00 Y=2154.00\r\nx=2941.00 y=2370.00 X=3570.00 Y=2370.00\r\nx=3571.00 y=2439.00 X=3571.00 Y=1.00\r\nx=3570.00 y=10.00 X=1.00 Y=10.00\r\nx=2940.00 y=11.00 X=2940.00 Y=2437.00\r\nx=2941.00 y=1190.00 X=3570.00 Y=1190.00\r\n\r\n[Info]\r\nId=10\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.05*3*0200177220\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=4\r\n\r\n[Info]\r\nId=36\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.05*3*0200177220\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =2144.000\r\nSheetHeight=786.000\r\nQuantityOnLayer=4\r\n\r\n[Info]\r\nId=18\r\nOrderNo=631*1180*14\r\nPosNo=G20001671.09*7*0200177224\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C3221a,6、8、10、12、14、16、18，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('4', 'M8252_04', '5C', '5C', '5', '2', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=2\r\nWidth=3660\r\nHeight=2440\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2144\r\nY=786 Info=37\r\nY=786 Info=37\r\nY=786 Info=37\r\nX=786\r\nY=2144 Info=11\r\nX=631\r\nY=1180 Info=18\r\nY=1180 Info=18\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2367.00\r\nx=3.00 y=2368.00 X=2153.00 Y=2368.00\r\nx=2154.00 y=2439.00 X=2154.00 Y=11.00\r\nx=2153.00 y=796.00 X=11.00 Y=796.00\r\nx=11.00 y=1582.00 X=2153.00 Y=1582.00\r\nx=2155.00 y=2154.00 X=2939.00 Y=2154.00\r\nx=2941.00 y=2370.00 X=3570.00 Y=2370.00\r\nx=3571.00 y=2439.00 X=3571.00 Y=1.00\r\nx=3570.00 y=10.00 X=1.00 Y=10.00\r\nx=2940.00 y=11.00 X=2940.00 Y=2437.00\r\nx=2941.00 y=1190.00 X=3570.00 Y=1190.00\r\n\r\n[Info]\r\nId=11\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.06*4*0100177221\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=4\r\n\r\n[Info]\r\nId=37\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.06*4*0100177221\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =2144.000\r\nSheetHeight=786.000\r\nQuantityOnLayer=4\r\n\r\n[Info]\r\nId=18\r\nOrderNo=631*1180*14\r\nPosNo=G20001671.09*7*0200177224\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C3221a,6、8、10、12、14、16、18，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('5', 'M8252_05', '5C', '5C', '5', '4', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=4\r\nWidth=3660\r\nHeight=2440\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2144\r\nY=786 Info=37\r\nY=786 Info=37\r\nY=786 Info=37\r\nX=786\r\nY=2144 Info=11\r\nX=631\r\nY=1180 Info=19\r\nY=1180 Info=19\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2367.00\r\nx=3.00 y=2368.00 X=2153.00 Y=2368.00\r\nx=2154.00 y=2439.00 X=2154.00 Y=11.00\r\nx=2153.00 y=796.00 X=11.00 Y=796.00\r\nx=11.00 y=1582.00 X=2153.00 Y=1582.00\r\nx=2155.00 y=2154.00 X=2939.00 Y=2154.00\r\nx=2941.00 y=2370.00 X=3570.00 Y=2370.00\r\nx=3571.00 y=2439.00 X=3571.00 Y=1.00\r\nx=3570.00 y=10.00 X=1.00 Y=10.00\r\nx=2940.00 y=11.00 X=2940.00 Y=2437.00\r\nx=2941.00 y=1190.00 X=3570.00 Y=1190.00\r\n\r\n[Info]\r\nId=11\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.06*4*0100177221\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=4\r\n\r\n[Info]\r\nId=37\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.06*4*0100177221\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =2144.000\r\nSheetHeight=786.000\r\nQuantityOnLayer=4\r\n\r\n[Info]\r\nId=19\r\nOrderNo=631*1180*24\r\nPosNo=G20001671.10*7*0100177225\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9821a,6、10、14、18，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('6', 'M8252_06', '5C', '5C', '5', '6', '0', '3660', '2440', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=6\r\nWidth=3660\r\nHeight=2440\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2144\r\nY=786 Info=38\r\nY=786 Info=38\r\nY=786 Info=38\r\nX=786\r\nY=2144 Info=12\r\nX=631\r\nY=1180 Info=19\r\nY=1180 Info=19\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2367.00\r\nx=3.00 y=2368.00 X=2153.00 Y=2368.00\r\nx=2154.00 y=2439.00 X=2154.00 Y=11.00\r\nx=2153.00 y=796.00 X=11.00 Y=796.00\r\nx=11.00 y=1582.00 X=2153.00 Y=1582.00\r\nx=2155.00 y=2154.00 X=2939.00 Y=2154.00\r\nx=2941.00 y=2370.00 X=3570.00 Y=2370.00\r\nx=3571.00 y=2439.00 X=3571.00 Y=1.00\r\nx=3570.00 y=10.00 X=1.00 Y=10.00\r\nx=2940.00 y=11.00 X=2940.00 Y=2437.00\r\nx=2941.00 y=1190.00 X=3570.00 Y=1190.00\r\n\r\n[Info]\r\nId=12\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.06*4*0200177221\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=4\r\n\r\n[Info]\r\nId=38\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.06*4*0200177221\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =2144.000\r\nSheetHeight=786.000\r\nQuantityOnLayer=4\r\n\r\n[Info]\r\nId=19\r\nOrderNo=631*1180*24\r\nPosNo=G20001671.10*7*0100177225\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9821a,6、10、14、18，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('7', 'M8252_07', '5C', '5C', '5', '2', '0', '3660', '2300', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=2\r\nWidth=3660\r\nHeight=2300\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2358\r\nY=2144\r\nZ=786 Info=13\r\nZ=786 Info=13\r\nZ=786 Info=13\r\nX=1292\r\nY=1074\r\nZ=317\r\nW=537 Info=1\r\nW=537 Info=1\r\nZ=317\r\nW=537 Info=1\r\nW=537 Info=1\r\nZ=317\r\nW=537 Info=1\r\nW=537 Info=1\r\nZ=317\r\nW=537 Info=1\r\nW=537 Info=1\r\nY=1180\r\nZ=631 Info=19\r\nZ=631 Info=19\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2153.00\r\nx=3.00 y=2154.00 X=2367.00 Y=2154.00\r\nx=2369.00 y=2264.00 X=3657.00 Y=2264.00\r\nx=3630.00 y=2263.00 X=3630.00 Y=1085.00\r\nx=3636.00 y=1083.00 X=3636.00 Y=1.00\r\nx=3635.00 y=10.00 X=1.00 Y=10.00\r\nx=796.00 y=11.00 X=796.00 Y=2153.00\r\nx=1582.00 y=2153.00 X=1582.00 Y=11.00\r\nx=2368.00 y=11.00 X=2368.00 Y=2297.00\r\nx=2999.00 y=2263.00 X=2999.00 Y=1085.00\r\nx=3002.00 y=1083.00 X=3002.00 Y=11.00\r\nx=2685.00 y=11.00 X=2685.00 Y=1083.00\r\nx=2369.00 y=1084.00 X=3657.00 Y=1084.00\r\nx=3319.00 y=1083.00 X=3319.00 Y=11.00\r\nx=3635.00 y=547.00 X=2369.00 Y=547.00\r\n\r\n[Info]\r\nId=13\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.07*5*0100177222\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=3\r\n\r\n[Info]\r\nId=1\r\nOrderNo=317*537*24\r\nPosNo=G20001671.01*1*0100177216\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C0914\',复式下层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =317.000\r\nSheetHeight=537.000\r\nQuantityOnLayer=8\r\n\r\n[Info]\r\nId=19\r\nOrderNo=631*1180*24\r\nPosNo=G20001671.10*7*0100177225\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9821a,6、10、14、18，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('8', 'M8252_08', '5C', '5C', '5', '1', '0', '3660', '2300', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660\r\nHeight=2300\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2358\r\nY=2144\r\nZ=786 Info=13\r\nZ=786 Info=13\r\nZ=786 Info=13\r\nX=1292\r\nY=1074\r\nZ=317\r\nW=537 Info=1\r\nW=537 Info=1\r\nZ=317\r\nW=537 Info=1\r\nW=537 Info=1\r\nZ=317\r\nW=537 Info=1\r\nW=537 Info=1\r\nZ=317\r\nW=537 Info=1\r\nW=537 Info=1\r\nY=1180\r\nZ=631 Info=20\r\nZ=631 Info=20\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2153.00\r\nx=3.00 y=2154.00 X=2367.00 Y=2154.00\r\nx=2369.00 y=2264.00 X=3657.00 Y=2264.00\r\nx=3630.00 y=2263.00 X=3630.00 Y=1085.00\r\nx=3636.00 y=1083.00 X=3636.00 Y=1.00\r\nx=3635.00 y=10.00 X=1.00 Y=10.00\r\nx=796.00 y=11.00 X=796.00 Y=2153.00\r\nx=1582.00 y=2153.00 X=1582.00 Y=11.00\r\nx=2368.00 y=11.00 X=2368.00 Y=2297.00\r\nx=2999.00 y=2263.00 X=2999.00 Y=1085.00\r\nx=3002.00 y=1083.00 X=3002.00 Y=11.00\r\nx=2685.00 y=11.00 X=2685.00 Y=1083.00\r\nx=2369.00 y=1084.00 X=3657.00 Y=1084.00\r\nx=3319.00 y=1083.00 X=3319.00 Y=11.00\r\nx=3635.00 y=547.00 X=2369.00 Y=547.00\r\n\r\n[Info]\r\nId=13\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.07*5*0100177222\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=3\r\n\r\n[Info]\r\nId=1\r\nOrderNo=317*537*24\r\nPosNo=G20001671.01*1*0100177216\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C0914\',复式下层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =317.000\r\nSheetHeight=537.000\r\nQuantityOnLayer=8\r\n\r\n[Info]\r\nId=20\r\nOrderNo=631*1180*24\r\nPosNo=G20001671.10*7*0200177225\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9821a,6、10、14、18，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('9', 'M8252_09', '5C', '5C', '5', '3', '0', '3660', '2300', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=3\r\nWidth=3660\r\nHeight=2300\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2358\r\nY=2144\r\nZ=786 Info=13\r\nZ=786 Info=13\r\nZ=786 Info=13\r\nX=1292\r\nY=1074\r\nZ=317\r\nW=537 Info=2\r\nW=537 Info=2\r\nZ=317\r\nW=537 Info=2\r\nW=537 Info=2\r\nZ=317\r\nW=537 Info=2\r\nW=537 Info=2\r\nZ=317\r\nW=537 Info=2\r\nW=537 Info=2\r\nY=1180\r\nZ=631 Info=20\r\nZ=631 Info=20\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2153.00\r\nx=3.00 y=2154.00 X=2367.00 Y=2154.00\r\nx=2369.00 y=2264.00 X=3657.00 Y=2264.00\r\nx=3630.00 y=2263.00 X=3630.00 Y=1085.00\r\nx=3636.00 y=1083.00 X=3636.00 Y=1.00\r\nx=3635.00 y=10.00 X=1.00 Y=10.00\r\nx=796.00 y=11.00 X=796.00 Y=2153.00\r\nx=1582.00 y=2153.00 X=1582.00 Y=11.00\r\nx=2368.00 y=11.00 X=2368.00 Y=2297.00\r\nx=2999.00 y=2263.00 X=2999.00 Y=1085.00\r\nx=3002.00 y=1083.00 X=3002.00 Y=11.00\r\nx=2685.00 y=11.00 X=2685.00 Y=1083.00\r\nx=2369.00 y=1084.00 X=3657.00 Y=1084.00\r\nx=3319.00 y=1083.00 X=3319.00 Y=11.00\r\nx=3635.00 y=547.00 X=2369.00 Y=547.00\r\n\r\n[Info]\r\nId=13\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.07*5*0100177222\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=3\r\n\r\n[Info]\r\nId=2\r\nOrderNo=317*537*24\r\nPosNo=G20001671.01*1*0200177216\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C0914\',复式下层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =317.000\r\nSheetHeight=537.000\r\nQuantityOnLayer=8\r\n\r\n[Info]\r\nId=20\r\nOrderNo=631*1180*24\r\nPosNo=G20001671.10*7*0200177225\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9821a,6、10、14、18，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('10', 'M8252_10', '5C', '5C', '5', '2', '0', '3660', '2300', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=2\r\nWidth=3660\r\nHeight=2300\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2358\r\nY=2144\r\nZ=786 Info=13\r\nZ=786 Info=13\r\nZ=786 Info=13\r\nX=1292\r\nY=1074\r\nZ=317\r\nW=537 Info=3\r\nW=537 Info=3\r\nZ=317\r\nW=537 Info=3\r\nW=537 Info=3\r\nZ=317\r\nW=537 Info=3\r\nW=537 Info=3\r\nZ=317\r\nW=537 Info=3\r\nW=537 Info=3\r\nY=1180\r\nZ=631 Info=20\r\nZ=631 Info=20\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2153.00\r\nx=3.00 y=2154.00 X=2367.00 Y=2154.00\r\nx=2369.00 y=2264.00 X=3657.00 Y=2264.00\r\nx=3630.00 y=2263.00 X=3630.00 Y=1085.00\r\nx=3636.00 y=1083.00 X=3636.00 Y=1.00\r\nx=3635.00 y=10.00 X=1.00 Y=10.00\r\nx=796.00 y=11.00 X=796.00 Y=2153.00\r\nx=1582.00 y=2153.00 X=1582.00 Y=11.00\r\nx=2368.00 y=11.00 X=2368.00 Y=2297.00\r\nx=2999.00 y=2263.00 X=2999.00 Y=1085.00\r\nx=3002.00 y=1083.00 X=3002.00 Y=11.00\r\nx=2685.00 y=11.00 X=2685.00 Y=1083.00\r\nx=2369.00 y=1084.00 X=3657.00 Y=1084.00\r\nx=3319.00 y=1083.00 X=3319.00 Y=11.00\r\nx=3635.00 y=547.00 X=2369.00 Y=547.00\r\n\r\n[Info]\r\nId=13\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.07*5*0100177222\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=3\r\n\r\n[Info]\r\nId=3\r\nOrderNo=317*537*24\r\nPosNo=G20001671.02*1*0100177217\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C0914\',复式下层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =317.000\r\nSheetHeight=537.000\r\nQuantityOnLayer=8\r\n\r\n[Info]\r\nId=20\r\nOrderNo=631*1180*24\r\nPosNo=G20001671.10*7*0200177225\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9821a,6、10、14、18，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('11', 'M8252_11', '5C', '5C', '5', '1', '0', '3660', '2300', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660\r\nHeight=2300\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2358\r\nY=2144\r\nZ=786 Info=14\r\nZ=786 Info=14\r\nZ=786 Info=14\r\nX=1292\r\nY=1074\r\nZ=317\r\nW=537 Info=3\r\nW=537 Info=3\r\nZ=317\r\nW=537 Info=3\r\nW=537 Info=3\r\nZ=317\r\nW=537 Info=3\r\nW=537 Info=3\r\nZ=317\r\nW=537 Info=3\r\nW=537 Info=3\r\nY=1180\r\nZ=631 Info=20\r\nZ=631 Info=20\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2153.00\r\nx=3.00 y=2154.00 X=2367.00 Y=2154.00\r\nx=2369.00 y=2264.00 X=3657.00 Y=2264.00\r\nx=3630.00 y=2263.00 X=3630.00 Y=1085.00\r\nx=3636.00 y=1083.00 X=3636.00 Y=1.00\r\nx=3635.00 y=10.00 X=1.00 Y=10.00\r\nx=796.00 y=11.00 X=796.00 Y=2153.00\r\nx=1582.00 y=2153.00 X=1582.00 Y=11.00\r\nx=2368.00 y=11.00 X=2368.00 Y=2297.00\r\nx=2999.00 y=2263.00 X=2999.00 Y=1085.00\r\nx=3002.00 y=1083.00 X=3002.00 Y=11.00\r\nx=2685.00 y=11.00 X=2685.00 Y=1083.00\r\nx=2369.00 y=1084.00 X=3657.00 Y=1084.00\r\nx=3319.00 y=1083.00 X=3319.00 Y=11.00\r\nx=3635.00 y=547.00 X=2369.00 Y=547.00\r\n\r\n[Info]\r\nId=14\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.07*5*0200177222\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=3\r\n\r\n[Info]\r\nId=3\r\nOrderNo=317*537*24\r\nPosNo=G20001671.02*1*0100177217\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C0914\',复式下层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =317.000\r\nSheetHeight=537.000\r\nQuantityOnLayer=8\r\n\r\n[Info]\r\nId=20\r\nOrderNo=631*1180*24\r\nPosNo=G20001671.10*7*0200177225\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9821a,6、10、14、18，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('12', 'M8252_12', '5C', '5C', '5', '3', '0', '3660', '2300', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=3\r\nWidth=3660\r\nHeight=2300\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2358\r\nY=2144\r\nZ=786 Info=14\r\nZ=786 Info=14\r\nZ=786 Info=14\r\nX=1292\r\nY=1074\r\nZ=317\r\nW=537 Info=4\r\nW=537 Info=4\r\nZ=317\r\nW=537 Info=4\r\nW=537 Info=4\r\nZ=317\r\nW=537 Info=4\r\nW=537 Info=4\r\nZ=317\r\nW=537 Info=4\r\nW=537 Info=4\r\nY=1180\r\nZ=631 Info=20\r\nZ=631 Info=20\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2153.00\r\nx=3.00 y=2154.00 X=2367.00 Y=2154.00\r\nx=2369.00 y=2264.00 X=3657.00 Y=2264.00\r\nx=3630.00 y=2263.00 X=3630.00 Y=1085.00\r\nx=3636.00 y=1083.00 X=3636.00 Y=1.00\r\nx=3635.00 y=10.00 X=1.00 Y=10.00\r\nx=796.00 y=11.00 X=796.00 Y=2153.00\r\nx=1582.00 y=2153.00 X=1582.00 Y=11.00\r\nx=2368.00 y=11.00 X=2368.00 Y=2297.00\r\nx=2999.00 y=2263.00 X=2999.00 Y=1085.00\r\nx=3002.00 y=1083.00 X=3002.00 Y=11.00\r\nx=2685.00 y=11.00 X=2685.00 Y=1083.00\r\nx=2369.00 y=1084.00 X=3657.00 Y=1084.00\r\nx=3319.00 y=1083.00 X=3319.00 Y=11.00\r\nx=3635.00 y=547.00 X=2369.00 Y=547.00\r\n\r\n[Info]\r\nId=14\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.07*5*0200177222\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=3\r\n\r\n[Info]\r\nId=4\r\nOrderNo=317*537*24\r\nPosNo=G20001671.02*1*0200177217\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C0914\',复式下层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =317.000\r\nSheetHeight=537.000\r\nQuantityOnLayer=8\r\n\r\n[Info]\r\nId=20\r\nOrderNo=631*1180*24\r\nPosNo=G20001671.10*7*0200177225\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9821a,6、10、14、18，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('13', 'M8252_13', '5C', '5C', '5', '2', '0', '3660', '2300', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=2\r\nWidth=3660\r\nHeight=2300\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2358\r\nY=2144\r\nZ=786 Info=14\r\nZ=786 Info=14\r\nZ=786 Info=14\r\nX=1292\r\nY=1074\r\nZ=317\r\nW=537 Info=5\r\nW=537 Info=5\r\nZ=317\r\nW=537 Info=5\r\nW=537 Info=5\r\nZ=317\r\nW=537 Info=5\r\nW=537 Info=5\r\nZ=317\r\nW=537 Info=5\r\nW=537 Info=5\r\nY=1180\r\nZ=631 Info=20\r\nZ=631 Info=20\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2153.00\r\nx=3.00 y=2154.00 X=2367.00 Y=2154.00\r\nx=2369.00 y=2264.00 X=3657.00 Y=2264.00\r\nx=3630.00 y=2263.00 X=3630.00 Y=1085.00\r\nx=3636.00 y=1083.00 X=3636.00 Y=1.00\r\nx=3635.00 y=10.00 X=1.00 Y=10.00\r\nx=796.00 y=11.00 X=796.00 Y=2153.00\r\nx=1582.00 y=2153.00 X=1582.00 Y=11.00\r\nx=2368.00 y=11.00 X=2368.00 Y=2297.00\r\nx=2999.00 y=2263.00 X=2999.00 Y=1085.00\r\nx=3002.00 y=1083.00 X=3002.00 Y=11.00\r\nx=2685.00 y=11.00 X=2685.00 Y=1083.00\r\nx=2369.00 y=1084.00 X=3657.00 Y=1084.00\r\nx=3319.00 y=1083.00 X=3319.00 Y=11.00\r\nx=3635.00 y=547.00 X=2369.00 Y=547.00\r\n\r\n[Info]\r\nId=14\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.07*5*0200177222\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=3\r\n\r\n[Info]\r\nId=5\r\nOrderNo=317*537*24\r\nPosNo=G20001671.03*2*0100177218\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C0914\',复式下层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =317.000\r\nSheetHeight=537.000\r\nQuantityOnLayer=8\r\n\r\n[Info]\r\nId=20\r\nOrderNo=631*1180*24\r\nPosNo=G20001671.10*7*0200177225\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9821a,6、10、14、18，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('14', 'M8252_14', '5C', '5C', '5', '1', '0', '3660', '2300', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660\r\nHeight=2300\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2358\r\nY=2144\r\nZ=786 Info=14\r\nZ=786 Info=14\r\nZ=786 Info=14\r\nX=1292\r\nY=1074\r\nZ=317\r\nW=537 Info=5\r\nW=537 Info=5\r\nZ=317\r\nW=537 Info=5\r\nW=537 Info=5\r\nZ=317\r\nW=537 Info=5\r\nW=537 Info=5\r\nZ=317\r\nW=537 Info=5\r\nW=537 Info=5\r\nY=1180\r\nZ=631 Info=21\r\nZ=631 Info=21\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2153.00\r\nx=3.00 y=2154.00 X=2367.00 Y=2154.00\r\nx=2369.00 y=2264.00 X=3657.00 Y=2264.00\r\nx=3630.00 y=2263.00 X=3630.00 Y=1085.00\r\nx=3636.00 y=1083.00 X=3636.00 Y=1.00\r\nx=3635.00 y=10.00 X=1.00 Y=10.00\r\nx=796.00 y=11.00 X=796.00 Y=2153.00\r\nx=1582.00 y=2153.00 X=1582.00 Y=11.00\r\nx=2368.00 y=11.00 X=2368.00 Y=2297.00\r\nx=2999.00 y=2263.00 X=2999.00 Y=1085.00\r\nx=3002.00 y=1083.00 X=3002.00 Y=11.00\r\nx=2685.00 y=11.00 X=2685.00 Y=1083.00\r\nx=2369.00 y=1084.00 X=3657.00 Y=1084.00\r\nx=3319.00 y=1083.00 X=3319.00 Y=11.00\r\nx=3635.00 y=547.00 X=2369.00 Y=547.00\r\n\r\n[Info]\r\nId=14\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.07*5*0200177222\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=3\r\n\r\n[Info]\r\nId=5\r\nOrderNo=317*537*24\r\nPosNo=G20001671.03*2*0100177218\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C0914\',复式下层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =317.000\r\nSheetHeight=537.000\r\nQuantityOnLayer=8\r\n\r\n[Info]\r\nId=21\r\nOrderNo=631*1180*18\r\nPosNo=G20001671.11*7*0100177226\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9819,8、12、16，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('15', 'M8252_15', '5C', '5C', '5', '1', '0', '3660', '2300', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660\r\nHeight=2300\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2358\r\nY=2144\r\nZ=786 Info=14\r\nZ=786 Info=14\r\nZ=786 Info=14\r\nX=1292\r\nY=1074\r\nZ=317\r\nW=537 Info=6\r\nW=537 Info=6\r\nZ=317\r\nW=537 Info=6\r\nW=537 Info=6\r\nZ=317\r\nW=537 Info=6\r\nW=537 Info=6\r\nZ=317\r\nW=537 Info=6\r\nW=537 Info=6\r\nY=1180\r\nZ=631 Info=21\r\nZ=631 Info=21\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2153.00\r\nx=3.00 y=2154.00 X=2367.00 Y=2154.00\r\nx=2369.00 y=2264.00 X=3657.00 Y=2264.00\r\nx=3630.00 y=2263.00 X=3630.00 Y=1085.00\r\nx=3636.00 y=1083.00 X=3636.00 Y=1.00\r\nx=3635.00 y=10.00 X=1.00 Y=10.00\r\nx=796.00 y=11.00 X=796.00 Y=2153.00\r\nx=1582.00 y=2153.00 X=1582.00 Y=11.00\r\nx=2368.00 y=11.00 X=2368.00 Y=2297.00\r\nx=2999.00 y=2263.00 X=2999.00 Y=1085.00\r\nx=3002.00 y=1083.00 X=3002.00 Y=11.00\r\nx=2685.00 y=11.00 X=2685.00 Y=1083.00\r\nx=2369.00 y=1084.00 X=3657.00 Y=1084.00\r\nx=3319.00 y=1083.00 X=3319.00 Y=11.00\r\nx=3635.00 y=547.00 X=2369.00 Y=547.00\r\n\r\n[Info]\r\nId=14\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.07*5*0200177222\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=3\r\n\r\n[Info]\r\nId=6\r\nOrderNo=317*537*24\r\nPosNo=G20001671.03*2*0200177218\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C0914\',复式下层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =317.000\r\nSheetHeight=537.000\r\nQuantityOnLayer=8\r\n\r\n[Info]\r\nId=21\r\nOrderNo=631*1180*18\r\nPosNo=G20001671.11*7*0100177226\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9819,8、12、16，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('16', 'M8252_16', '5C', '5C', '5', '2', '0', '3660', '2300', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=2\r\nWidth=3660\r\nHeight=2300\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2358\r\nY=2144\r\nZ=786 Info=15\r\nZ=786 Info=15\r\nZ=786 Info=15\r\nX=1292\r\nY=1074\r\nZ=317\r\nW=537 Info=6\r\nW=537 Info=6\r\nZ=317\r\nW=537 Info=6\r\nW=537 Info=6\r\nZ=317\r\nW=537 Info=6\r\nW=537 Info=6\r\nZ=317\r\nW=537 Info=6\r\nW=537 Info=6\r\nY=1180\r\nZ=631 Info=21\r\nZ=631 Info=21\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2153.00\r\nx=3.00 y=2154.00 X=2367.00 Y=2154.00\r\nx=2369.00 y=2264.00 X=3657.00 Y=2264.00\r\nx=3630.00 y=2263.00 X=3630.00 Y=1085.00\r\nx=3636.00 y=1083.00 X=3636.00 Y=1.00\r\nx=3635.00 y=10.00 X=1.00 Y=10.00\r\nx=796.00 y=11.00 X=796.00 Y=2153.00\r\nx=1582.00 y=2153.00 X=1582.00 Y=11.00\r\nx=2368.00 y=11.00 X=2368.00 Y=2297.00\r\nx=2999.00 y=2263.00 X=2999.00 Y=1085.00\r\nx=3002.00 y=1083.00 X=3002.00 Y=11.00\r\nx=2685.00 y=11.00 X=2685.00 Y=1083.00\r\nx=2369.00 y=1084.00 X=3657.00 Y=1084.00\r\nx=3319.00 y=1083.00 X=3319.00 Y=11.00\r\nx=3635.00 y=547.00 X=2369.00 Y=547.00\r\n\r\n[Info]\r\nId=15\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.08*6*0100177223\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=3\r\n\r\n[Info]\r\nId=6\r\nOrderNo=317*537*24\r\nPosNo=G20001671.03*2*0200177218\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C0914\',复式下层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =317.000\r\nSheetHeight=537.000\r\nQuantityOnLayer=8\r\n\r\n[Info]\r\nId=21\r\nOrderNo=631*1180*18\r\nPosNo=G20001671.11*7*0100177226\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9819,8、12、16，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('17', 'M8252_17', '5C', '5C', '5', '3', '0', '3660', '2300', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=3\r\nWidth=3660\r\nHeight=2300\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2358\r\nY=2144\r\nZ=786 Info=15\r\nZ=786 Info=15\r\nZ=786 Info=15\r\nX=1292\r\nY=1074\r\nZ=317\r\nW=537 Info=7\r\nW=537 Info=7\r\nZ=317\r\nW=537 Info=7\r\nW=537 Info=7\r\nZ=317\r\nW=537 Info=7\r\nW=537 Info=7\r\nZ=317\r\nW=537 Info=7\r\nW=537 Info=7\r\nY=1180\r\nZ=631 Info=21\r\nZ=631 Info=21\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2153.00\r\nx=3.00 y=2154.00 X=2367.00 Y=2154.00\r\nx=2369.00 y=2264.00 X=3657.00 Y=2264.00\r\nx=3630.00 y=2263.00 X=3630.00 Y=1085.00\r\nx=3636.00 y=1083.00 X=3636.00 Y=1.00\r\nx=3635.00 y=10.00 X=1.00 Y=10.00\r\nx=796.00 y=11.00 X=796.00 Y=2153.00\r\nx=1582.00 y=2153.00 X=1582.00 Y=11.00\r\nx=2368.00 y=11.00 X=2368.00 Y=2297.00\r\nx=2999.00 y=2263.00 X=2999.00 Y=1085.00\r\nx=3002.00 y=1083.00 X=3002.00 Y=11.00\r\nx=2685.00 y=11.00 X=2685.00 Y=1083.00\r\nx=2369.00 y=1084.00 X=3657.00 Y=1084.00\r\nx=3319.00 y=1083.00 X=3319.00 Y=11.00\r\nx=3635.00 y=547.00 X=2369.00 Y=547.00\r\n\r\n[Info]\r\nId=15\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.08*6*0100177223\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=3\r\n\r\n[Info]\r\nId=7\r\nOrderNo=317*537*24\r\nPosNo=G20001671.04*2*0100177219\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C0914\',复式下层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =317.000\r\nSheetHeight=537.000\r\nQuantityOnLayer=8\r\n\r\n[Info]\r\nId=21\r\nOrderNo=631*1180*18\r\nPosNo=G20001671.11*7*0100177226\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9819,8、12、16，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('18', 'M8252_18', '5C', '5C', '5', '2', '0', '3660', '2300', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=2\r\nWidth=3660\r\nHeight=2300\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2358\r\nY=2144\r\nZ=786 Info=15\r\nZ=786 Info=15\r\nZ=786 Info=15\r\nX=1292\r\nY=1074\r\nZ=317\r\nW=537 Info=8\r\nW=537 Info=8\r\nZ=317\r\nW=537 Info=8\r\nW=537 Info=8\r\nZ=317\r\nW=537 Info=8\r\nW=537 Info=8\r\nZ=317\r\nW=537 Info=8\r\nW=537 Info=8\r\nY=1180\r\nZ=631 Info=21\r\nZ=631 Info=21\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2153.00\r\nx=3.00 y=2154.00 X=2367.00 Y=2154.00\r\nx=2369.00 y=2264.00 X=3657.00 Y=2264.00\r\nx=3630.00 y=2263.00 X=3630.00 Y=1085.00\r\nx=3636.00 y=1083.00 X=3636.00 Y=1.00\r\nx=3635.00 y=10.00 X=1.00 Y=10.00\r\nx=796.00 y=11.00 X=796.00 Y=2153.00\r\nx=1582.00 y=2153.00 X=1582.00 Y=11.00\r\nx=2368.00 y=11.00 X=2368.00 Y=2297.00\r\nx=2999.00 y=2263.00 X=2999.00 Y=1085.00\r\nx=3002.00 y=1083.00 X=3002.00 Y=11.00\r\nx=2685.00 y=11.00 X=2685.00 Y=1083.00\r\nx=2369.00 y=1084.00 X=3657.00 Y=1084.00\r\nx=3319.00 y=1083.00 X=3319.00 Y=11.00\r\nx=3635.00 y=547.00 X=2369.00 Y=547.00\r\n\r\n[Info]\r\nId=15\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.08*6*0100177223\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=3\r\n\r\n[Info]\r\nId=8\r\nOrderNo=317*537*24\r\nPosNo=G20001671.04*2*0200177219\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C0914\',复式下层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =317.000\r\nSheetHeight=537.000\r\nQuantityOnLayer=8\r\n\r\n[Info]\r\nId=21\r\nOrderNo=631*1180*18\r\nPosNo=G20001671.11*7*0100177226\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9819,8、12、16，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('19', 'M8252_19', '5C', '5C', '5', '1', '0', '3660', '2300', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660\r\nHeight=2300\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2358\r\nY=2144\r\nZ=786 Info=15\r\nZ=786 Info=15\r\nZ=786 Info=15\r\nX=1292\r\nY=1074\r\nZ=317\r\nW=537 Info=8\r\nW=537 Info=8\r\nZ=317\r\nW=537 Info=8\r\nW=537 Info=8\r\nZ=317\r\nW=537 Info=8\r\nW=537 Info=8\r\nZ=317\r\nW=537 Info=8\r\nW=537 Info=8\r\nY=1180\r\nZ=631 Info=22\r\nZ=631 Info=22\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2153.00\r\nx=3.00 y=2154.00 X=2367.00 Y=2154.00\r\nx=2369.00 y=2264.00 X=3657.00 Y=2264.00\r\nx=3630.00 y=2263.00 X=3630.00 Y=1085.00\r\nx=3636.00 y=1083.00 X=3636.00 Y=1.00\r\nx=3635.00 y=10.00 X=1.00 Y=10.00\r\nx=796.00 y=11.00 X=796.00 Y=2153.00\r\nx=1582.00 y=2153.00 X=1582.00 Y=11.00\r\nx=2368.00 y=11.00 X=2368.00 Y=2297.00\r\nx=2999.00 y=2263.00 X=2999.00 Y=1085.00\r\nx=3002.00 y=1083.00 X=3002.00 Y=11.00\r\nx=2685.00 y=11.00 X=2685.00 Y=1083.00\r\nx=2369.00 y=1084.00 X=3657.00 Y=1084.00\r\nx=3319.00 y=1083.00 X=3319.00 Y=11.00\r\nx=3635.00 y=547.00 X=2369.00 Y=547.00\r\n\r\n[Info]\r\nId=15\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.08*6*0100177223\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=3\r\n\r\n[Info]\r\nId=8\r\nOrderNo=317*537*24\r\nPosNo=G20001671.04*2*0200177219\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C0914\',复式下层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =317.000\r\nSheetHeight=537.000\r\nQuantityOnLayer=8\r\n\r\n[Info]\r\nId=22\r\nOrderNo=631*1180*18\r\nPosNo=G20001671.11*7*0200177226\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9819,8、12、16，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('20', 'M8252_20', '5C', '5C', '5', '1', '0', '3660', '2300', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660\r\nHeight=2300\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2358\r\nY=2144\r\nZ=786 Info=16\r\nZ=786 Info=16\r\nZ=786 Info=16\r\nX=1262\r\nY=1180\r\nZ=631 Info=22\r\nZ=631 Info=22\r\nY=1080\r\nZ=631 Info=23\r\nZ=631 Info=23\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2153.00\r\nx=3.00 y=2154.00 X=2367.00 Y=2154.00\r\nx=2369.00 y=2270.00 X=3629.00 Y=2270.00\r\nx=3630.00 y=2299.00 X=3630.00 Y=1.00\r\nx=3629.00 y=10.00 X=1.00 Y=10.00\r\nx=796.00 y=11.00 X=796.00 Y=2153.00\r\nx=1582.00 y=2153.00 X=1582.00 Y=11.00\r\nx=2368.00 y=11.00 X=2368.00 Y=2297.00\r\nx=2999.00 y=2269.00 X=2999.00 Y=11.00\r\nx=2369.00 y=1190.00 X=3629.00 Y=1190.00\r\n\r\n[Info]\r\nId=16\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.08*6*0200177223\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=3\r\n\r\n[Info]\r\nId=22\r\nOrderNo=631*1180*18\r\nPosNo=G20001671.11*7*0200177226\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9819,8、12、16，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n[Info]\r\nId=23\r\nOrderNo=631*1080*2\r\nPosNo=G20001671.12*8*0100177227\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C3217,4，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1080.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('21', 'M8252_21', '5C', '5C', '5', '1', '0', '3660', '2300', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=1\r\nWidth=3660\r\nHeight=2300\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2358\r\nY=2144\r\nZ=786 Info=16\r\nZ=786 Info=16\r\nZ=786 Info=16\r\nX=1262\r\nY=1180\r\nZ=631 Info=22\r\nZ=631 Info=22\r\nY=1080\r\nZ=631 Info=24\r\nZ=631 Info=24\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2153.00\r\nx=3.00 y=2154.00 X=2367.00 Y=2154.00\r\nx=2369.00 y=2270.00 X=3629.00 Y=2270.00\r\nx=3630.00 y=2299.00 X=3630.00 Y=1.00\r\nx=3629.00 y=10.00 X=1.00 Y=10.00\r\nx=796.00 y=11.00 X=796.00 Y=2153.00\r\nx=1582.00 y=2153.00 X=1582.00 Y=11.00\r\nx=2368.00 y=11.00 X=2368.00 Y=2297.00\r\nx=2999.00 y=2269.00 X=2999.00 Y=11.00\r\nx=2369.00 y=1190.00 X=3629.00 Y=1190.00\r\n\r\n[Info]\r\nId=16\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.08*6*0200177223\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=3\r\n\r\n[Info]\r\nId=22\r\nOrderNo=631*1180*18\r\nPosNo=G20001671.11*7*0200177226\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9819,8、12、16，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n[Info]\r\nId=24\r\nOrderNo=631*1080*2\r\nPosNo=G20001671.12*8*0200177227\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C3217,4，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1080.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('22', 'M8252_22', '5C', '5C', '5', '3', '0', '3660', '2300', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=3\r\nWidth=3660\r\nHeight=2300\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2358\r\nY=2144\r\nZ=786 Info=16\r\nZ=786 Info=16\r\nZ=786 Info=16\r\nX=1262\r\nY=1180\r\nZ=631 Info=22\r\nZ=631 Info=22\r\nY=1080\r\nZ=631 Info=25\r\nZ=631 Info=25\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2153.00\r\nx=3.00 y=2154.00 X=2367.00 Y=2154.00\r\nx=2369.00 y=2270.00 X=3629.00 Y=2270.00\r\nx=3630.00 y=2299.00 X=3630.00 Y=1.00\r\nx=3629.00 y=10.00 X=1.00 Y=10.00\r\nx=796.00 y=11.00 X=796.00 Y=2153.00\r\nx=1582.00 y=2153.00 X=1582.00 Y=11.00\r\nx=2368.00 y=11.00 X=2368.00 Y=2297.00\r\nx=2999.00 y=2269.00 X=2999.00 Y=11.00\r\nx=2369.00 y=1190.00 X=3629.00 Y=1190.00\r\n\r\n[Info]\r\nId=16\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.08*6*0200177223\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=3\r\n\r\n[Info]\r\nId=22\r\nOrderNo=631*1180*18\r\nPosNo=G20001671.11*7*0200177226\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9819,8、12、16，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n[Info]\r\nId=25\r\nOrderNo=631*1080*6\r\nPosNo=G20001671.12*8*0100177228\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9817,4，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1080.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');
INSERT INTO `gmms_opt_pattern` VALUES ('23', 'M8252_23', '5C', '5C', '5', '3', '0', '3660', '2300', null, 'C', '[OPT_Pattern]\r\nGlassID=5C\r\nGlassDescription=5C\r\nGlassThickness=5\r\nGlassStructured=0\r\nGlassCoated=0\r\nPieces=3\r\nWidth=3660\r\nHeight=2300\r\nTrimLeft=10\r\nTrimBottom=10\r\nX=2358\r\nY=2144\r\nZ=786 Info=16\r\nZ=786 Info=16\r\nZ=786 Info=16\r\nX=1262\r\nY=1180\r\nZ=631 Info=22\r\nZ=631 Info=22\r\nY=1080\r\nZ=631 Info=26\r\nZ=631 Info=26\r\n\r\n[Cuttings]\r\nx=10.00 y=3.00 X=10.00 Y=2153.00\r\nx=3.00 y=2154.00 X=2367.00 Y=2154.00\r\nx=2369.00 y=2270.00 X=3629.00 Y=2270.00\r\nx=3630.00 y=2299.00 X=3630.00 Y=1.00\r\nx=3629.00 y=10.00 X=1.00 Y=10.00\r\nx=796.00 y=11.00 X=796.00 Y=2153.00\r\nx=1582.00 y=2153.00 X=1582.00 Y=11.00\r\nx=2368.00 y=11.00 X=2368.00 Y=2297.00\r\nx=2999.00 y=2269.00 X=2999.00 Y=11.00\r\nx=2369.00 y=1190.00 X=3629.00 Y=1190.00\r\n\r\n[Info]\r\nId=16\r\nOrderNo=786*2144*24\r\nPosNo=G20001671.08*6*0200177223\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，TM1823,2-顶层，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =786.000\r\nSheetHeight=2144.000\r\nQuantityOnLayer=3\r\n\r\n[Info]\r\nId=22\r\nOrderNo=631*1180*18\r\nPosNo=G20001671.11*7*0200177226\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9819,8、12、16，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1180.000\r\nQuantityOnLayer=2\r\n\r\n[Info]\r\nId=26\r\nOrderNo=631*1080*6\r\nPosNo=G20001671.12*8*0200177228\r\nCustomer=泉州亚林新材料（洛江世茂璀璨天城01地块）*2#，C9817,4，扇玻*5mm白钢+9A+5mm白钢双钢中空\r\nCommision=切割(反)->磨边(正)->清洗(反)->钢化(正)->中空(反)->库(正)*5mm白玻钢化&泉州市南安市福建宏茂科技有限公司东南90米工厂*只印3C标志带编码\r\nSheetWidth =631.000\r\nSheetHeight=1080.000\r\nQuantityOnLayer=2\r\n\r\n\r\n', 'M8252', null, '1');

-- ----------------------------
-- 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,
  `actual_length` double DEFAULT NULL,
  `actual_width` double DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `glass_id` bigint(20) DEFAULT NULL,
  `gmms_raw_package_txt_id` bigint(20) DEFAULT NULL,
  `identify_machine_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `gmms_raw_package_txt_id` (`gmms_raw_package_txt_id`),
  KEY `glass_id` (`glass_id`),
  KEY `identify_machine_id` (`identify_machine_id`),
  CONSTRAINT `gmms_preprocessing_glass_ibfk_1` FOREIGN KEY (`gmms_raw_package_txt_id`) REFERENCES `gmms_raw_package_txt` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `gmms_preprocessing_glass_ibfk_2` FOREIGN KEY (`glass_id`) REFERENCES `gmms_glass` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `gmms_preprocessing_glass_ibfk_3` FOREIGN KEY (`identify_machine_id`) REFERENCES `gmms_identify_machine` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_preprocessing_glass
-- ----------------------------

-- ----------------------------
-- 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', 'notPrint', '1', '竖打');
INSERT INTO `gmms_print_machine` VALUES ('Golive-two', '2', 'notPrint', '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_rank`
-- ----------------------------
DROP TABLE IF EXISTS `gmms_rank`;
CREATE TABLE `gmms_rank` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `glass_id` varchar(50) DEFAULT NULL,
  `pieces` int(11) DEFAULT NULL,
  `width` double DEFAULT NULL,
  `height` double DEFAULT NULL,
  `thickness` double DEFAULT NULL,
  `color` varchar(50) DEFAULT NULL,
  `endtime` timestamp NULL DEFAULT NULL,
  `manufacturer` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `createtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `flag` varchar(255) DEFAULT NULL,
  `shelf_rank_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `shelf_rank_id` (`shelf_rank_id`),
  CONSTRAINT `gmms_rank_ibfk_1` FOREIGN KEY (`shelf_rank_id`) REFERENCES `gmms_shelf_rank` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_rank
-- ----------------------------
INSERT INTO `gmms_rank` VALUES ('1', '5c', '15', '3660', '2440', '5', 'c', '2019-08-06 16:09:12', 'jinhua', '进库', '2019-08-05 16:09:31', '1', '4');
INSERT INTO `gmms_rank` VALUES ('2', '6white', '20', '3660', '2440', '6', 'white', '2019-08-09 10:06:45', '台玻', '进库', '2019-08-09 10:06:45', '0', '5');
INSERT INTO `gmms_rank` VALUES ('3', '5white', '20', '3300', '2440', '5', 'white', '2019-08-09 10:10:57', null, '退库', '2019-04-02 14:00:08', '1', '3');

-- ----------------------------
-- 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 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_raw_package
-- ----------------------------

-- ----------------------------
-- 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=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_raw_package_txt
-- ----------------------------
INSERT INTO `gmms_raw_package_txt` VALUES ('1', 'M8252', '', '等待下发', null, '2020-04-20 09:29:22');

-- ----------------------------
-- 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 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_report_task
-- ----------------------------

-- ----------------------------
-- 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_shelf
-- ----------------------------
INSERT INTO `gmms_shelf` VALUES ('1', '01', '8110', '设备停止', '正在连接');

-- ----------------------------
-- 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=33 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_shelf_rank
-- ----------------------------
INSERT INTO `gmms_shelf_rank` VALUES ('1', '01', '空闲', null, null, '2018-12-24 16:49:37', null, null, null, null, null, null, null, '2020-04-14 11:47:31', null, '1');
INSERT INTO `gmms_shelf_rank` VALUES ('2', '02', '空闲', null, null, '2018-11-08 10:17:39', null, null, null, null, null, null, null, '2020-04-14 11:47:31', null, '1');
INSERT INTO `gmms_shelf_rank` VALUES ('3', '03', '空闲', null, null, '2018-11-14 13:41:56', null, null, null, null, null, null, null, '2020-04-14 11:47:31', 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-14 11:47:31', null, '1');
INSERT INTO `gmms_shelf_rank` VALUES ('5', '05', '空闲', null, null, '2018-11-12 15:32:33', null, null, null, null, null, null, null, '2020-04-14 11:47:31', 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 11:47:31', 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 11:47:31', 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 11:47:31', 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 11:47:31', null, '1');
INSERT INTO `gmms_shelf_rank` VALUES ('10', '10', '空闲', null, null, '2018-10-20 09:55:31', null, null, null, null, null, null, null, '2020-04-14 11:47:31', 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 11:47:31', 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 11:47:31', 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 11:47:31', 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 11:47:31', 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');
INSERT INTO `gmms_shelf_rank` VALUES ('31', '31', '空闲', null, null, '2018-10-20 09:55:44', null, null, null, null, null, null, null, '0000-00-00 00:00:00', null, '1');
INSERT INTO `gmms_shelf_rank` VALUES ('32', '32', '空闲', null, null, '2018-10-20 09:55:45', 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_shelf_statu
-- ----------------------------
INSERT INTO `gmms_shelf_statu` VALUES ('1', '自动', '无故障', '10', '10', '0001', '2018-11-09 17:12:09');

-- ----------------------------
-- 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 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_shelf_task
-- ----------------------------

-- ----------------------------
-- 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,
  `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,
  `manufacture_batch_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,
  PRIMARY KEY (`id`),
  KEY `opt_pattern_id` (`opt_pattern_id`),
  KEY `manufacture_batch_id` (`manufacture_batch_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 (`manufacture_batch_id`) REFERENCES `gmms_manufacture_batch` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gmms_singal_glass
-- ----------------------------

-- ----------------------------
-- 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');
