/* 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', 'aa85bd5a296f54105a1180197d400cc0203bcda7', 'ec1f393b29ae0179', 'xiapian', '1', '2012-06-04 02:00:00'); INSERT INTO `gmms_user` VALUES ('10', 'xiapian2', 'xiapian2', 'aa85bd5a296f54105a1180197d400cc0203bcda7', 'ec1f393b29ae0179', 'xiapian', '2', '2012-06-04 02:00:00'); -- ---------------------------- -- Table structure for `gmms_wash_machine` -- ---------------------------- DROP TABLE IF EXISTS `gmms_wash_machine`; CREATE TABLE `gmms_wash_machine` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `connect_state` varchar(50) DEFAULT NULL, `picture_url` varchar(255) DEFAULT NULL, `port` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_wash_machine -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_with_pieces_statu` -- ---------------------------- DROP TABLE IF EXISTS `gmms_with_pieces_statu`; CREATE TABLE `gmms_with_pieces_statu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `state` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_with_pieces_statu -- ---------------------------- INSERT INTO `gmms_with_pieces_statu` VALUES ('1', 'waiting');