/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50528 Source Host : localhost:3306 Source Database : beijing Target Server Type : MYSQL Target Server Version : 50528 File Encoding : 65001 Date: 2021-01-31 18:30:25 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `gmms_add_optpattern` -- ---------------------------- DROP TABLE IF EXISTS `gmms_add_optpattern`; CREATE TABLE `gmms_add_optpattern` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `glass_description` varchar(255) DEFAULT NULL, `glass_id` varchar(50) DEFAULT NULL, `glass_thickness` double DEFAULT NULL, `pieces` int(11) DEFAULT NULL, `width` double DEFAULT NULL, `height` double DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `manufacture_batch_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `manufacture_batch_id` (`manufacture_batch_id`), CONSTRAINT `gmms_add_optpattern_ibfk_1` FOREIGN KEY (`manufacture_batch_id`) REFERENCES `gmms_manufacture_batch` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_add_optpattern -- ---------------------------- -- ---------------------------- -- 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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_arrange_machine -- ---------------------------- INSERT INTO `gmms_arrange_machine` VALUES ('1', '01', null, '正在连接', null, '8170'); -- ---------------------------- -- 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, `touid` varchar(50) DEFAULT NULL, `length` double DEFAULT NULL, `width` double DEFAULT NULL, `isus` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=161 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_arrange_machine_rank -- ---------------------------- INSERT INTO `gmms_arrange_machine_rank` VALUES ('1', '01', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('2', '02', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('3', '03', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('4', '04', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('5', '05', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('6', '06', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('7', '07', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('8', '08', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('9', '09', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('10', '10', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('11', '11', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('12', '12', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('13', '13', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('14', '14', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('15', '15', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('16', '16', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('17', '17', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('18', '18', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('19', '19', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('20', '20', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('21', '21', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('22', '22', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('23', '23', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('24', '24', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('25', '25', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('26', '26', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('27', '27', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('28', '28', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('29', '29', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('30', '30', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('31', '31', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('32', '32', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('33', '33', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('34', '34', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('35', '35', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('36', '36', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('37', '37', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('38', '38', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('39', '39', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('40', '40', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('41', '41', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('42', '42', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('43', '43', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('44', '44', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('45', '45', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('46', '46', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('47', '47', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('48', '48', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('49', '49', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('50', '50', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('51', '51', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('52', '52', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('53', '53', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('54', '54', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('55', '55', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('56', '56', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('57', '57', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('58', '58', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('59', '59', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('60', '60', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('61', '61', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('62', '62', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('63', '63', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('64', '64', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('65', '65', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('66', '66', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('67', '67', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('68', '68', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('69', '69', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('70', '70', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('71', '71', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('72', '72', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('73', '73', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('74', '74', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('75', '75', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('76', '76', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('77', '77', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('78', '78', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('79', '79', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('80', '80', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('81', '81', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('82', '82', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('83', '83', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('84', '84', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('85', '85', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('86', '86', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('87', '87', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('88', '88', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('89', '89', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('90', '90', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('91', '91', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('92', '92', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('93', '93', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('94', '94', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('95', '95', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('96', '96', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('97', '97', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('98', '98', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('99', '99', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('100', '100', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('101', '101', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('102', '102', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('103', '103', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('104', '104', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('105', '105', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('106', '106', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('107', '107', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('108', '108', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('109', '109', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('110', '110', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('111', '111', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('112', '112', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('113', '113', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('114', '114', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('115', '115', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('116', '116', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('117', '117', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('118', '118', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('119', '119', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('120', '120', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('121', '121', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('122', '122', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('123', '123', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('124', '124', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('125', '125', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('126', '126', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('127', '127', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('128', '128', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('129', '129', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('130', '130', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('131', '131', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('132', '132', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('133', '133', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('134', '134', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('135', '135', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('136', '136', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('137', '137', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('138', '138', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('139', '139', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('140', '140', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('141', '141', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('142', '142', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('143', '143', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('144', '144', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('145', '145', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('146', '146', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('147', '147', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('148', '148', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('149', '149', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('150', '150', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('151', '151', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('152', '152', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('153', '153', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('154', '154', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('155', '155', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('156', '156', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('157', '157', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('158', '158', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('159', '159', null, null, '0', '0', null); INSERT INTO `gmms_arrange_machine_rank` VALUES ('160', '160', null, null, '0', '0', 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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_arrange_machine_statu -- ---------------------------- INSERT INTO `gmms_arrange_machine_statu` VALUES ('1', ''); -- ---------------------------- -- 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, `touid` varchar(50) DEFAULT NULL, `pieces` int(11) DEFAULT NULL, `measure_machine_id` bigint(20) DEFAULT NULL, `arrange_machine_rank_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`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 (`measure_machine_id`) REFERENCES `gmms_measure_machine` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_arrange_machine_task_ibfk_2` 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_color` -- ---------------------------- DROP TABLE IF EXISTS `gmms_color`; CREATE TABLE `gmms_color` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_color -- ---------------------------- INSERT INTO `gmms_color` VALUES ('1', 'white'); INSERT INTO `gmms_color` VALUES ('2', 'ts'); INSERT INTO `gmms_color` VALUES ('3', 'G'); INSERT INTO `gmms_color` VALUES ('4', 'FG'); INSERT INTO `gmms_color` VALUES ('5', 'GT'); INSERT INTO `gmms_color` VALUES ('6', 'OZH'); INSERT INTO `gmms_color` VALUES ('7', 'YGDM'); INSERT INTO `gmms_color` VALUES ('8', '126'); INSERT INTO `gmms_color` VALUES ('9', '148'); INSERT INTO `gmms_color` VALUES ('10', '147'); INSERT INTO `gmms_color` VALUES ('11', '33'); INSERT INTO `gmms_color` VALUES ('12', '130DM'); INSERT INTO `gmms_color` VALUES ('13', '2350DM'); INSERT INTO `gmms_color` VALUES ('14', '250DM'); INSERT INTO `gmms_color` VALUES ('15', 'SJH'); INSERT INTO `gmms_color` VALUES ('16', '127'); INSERT INTO `gmms_color` VALUES ('17', 'C'); INSERT INTO `gmms_color` VALUES ('18', 'SC'); -- ---------------------------- -- 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, `length` double DEFAULT NULL, `width` double DEFAULT NULL, `apart` 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', `count_machine_id` bigint(20) DEFAULT NULL, `glass_id` bigint(20) DEFAULT NULL, `manufacture_batch_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `glass_id` (`glass_id`), KEY `count_machine_id` (`count_machine_id`), KEY `manufacture_batch_id` (`manufacture_batch_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 (`manufacture_batch_id`) REFERENCES `gmms_manufacture_batch` (`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', `manufacture_batch_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `opt_pattern_id` (`opt_pattern_id`), KEY `load_machine_id` (`load_machine_id`), KEY `cut_machine_id` (`cut_machine_id`), KEY `manufacture_batch_id` (`manufacture_batch_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, CONSTRAINT `gmms_cut_machine_task_ibfk_4` FOREIGN KEY (`manufacture_batch_id`) REFERENCES `gmms_manufacture_batch` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_cut_machine_task -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_damage_glass` -- ---------------------------- DROP TABLE IF EXISTS `gmms_damage_glass`; CREATE TABLE `gmms_damage_glass` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `length` double DEFAULT NULL, `width` double DEFAULT NULL, `thickness` double DEFAULT NULL, `color` varchar(25) DEFAULT NULL, `customer` varchar(255) DEFAULT NULL, `pieces` int(11) DEFAULT NULL, `manufacture_batch_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `manufacture_batch_id` (`manufacture_batch_id`), CONSTRAINT `gmms_damage_glass_ibfk_1` FOREIGN KEY (`manufacture_batch_id`) REFERENCES `gmms_manufacture_batch` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_damage_glass -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_down_piece` -- ---------------------------- DROP TABLE IF EXISTS `gmms_down_piece`; CREATE TABLE `gmms_down_piece` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `batch` varchar(255) DEFAULT NULL, `total_amount` varchar(255) DEFAULT NULL, `complete_amount` varchar(255) DEFAULT NULL, `area` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_down_piece -- ---------------------------- -- ---------------------------- -- 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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_film_remove_machine -- ---------------------------- INSERT INTO `gmms_film_remove_machine` VALUES ('1', '01', null, null, null, '7000'); INSERT INTO `gmms_film_remove_machine` VALUES ('2', '02', null, null, null, '7001'); -- ---------------------------- -- 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, `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, 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 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_glass -- ---------------------------- -- ---------------------------- -- 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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_grind_edge_machine -- ---------------------------- INSERT INTO `gmms_grind_edge_machine` VALUES ('1', '01', null, null, '8140', null, null, null); INSERT INTO `gmms_grind_edge_machine` VALUES ('2', '02', null, null, '8141', null, null, null); -- ---------------------------- -- 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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_grind_edge_machine_two -- ---------------------------- INSERT INTO `gmms_grind_edge_machine_two` VALUES ('1', '01', null, null, '8142', null, null, null); INSERT INTO `gmms_grind_edge_machine_two` VALUES ('2', '02', null, null, '8143', null, null, null); -- ---------------------------- -- 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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_identify_machine -- ---------------------------- INSERT INTO `gmms_identify_machine` VALUES ('1', '01', null, null, '8130', '0', '2', '2'); INSERT INTO `gmms_identify_machine` VALUES ('2', '02', null, null, '8131', '0', '2', '2'); -- ---------------------------- -- 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, 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'); INSERT INTO `gmms_identify_pattern` VALUES ('2', 'old', null, '5'); -- ---------------------------- -- Table structure for `gmms_identify_warn` -- ---------------------------- DROP TABLE IF EXISTS `gmms_identify_warn`; CREATE TABLE `gmms_identify_warn` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `length` varchar(50) DEFAULT NULL, `width` varchar(50) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `number` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_identify_warn -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_light` -- ---------------------------- DROP TABLE IF EXISTS `gmms_light`; CREATE TABLE `gmms_light` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(255) DEFAULT NULL, `state` varchar(255) DEFAULT NULL, `voltage` varchar(255) DEFAULT NULL, `groups` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_light -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_light_number` -- ---------------------------- DROP TABLE IF EXISTS `gmms_light_number`; CREATE TABLE `gmms_light_number` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(255) DEFAULT NULL, `line` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_light_number -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_light_task` -- ---------------------------- DROP TABLE IF EXISTS `gmms_light_task`; CREATE TABLE `gmms_light_task` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `number` varchar(255) DEFAULT NULL, `state` varchar(255) DEFAULT NULL, `groups` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_light_task -- ---------------------------- -- ---------------------------- -- 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, `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, '1'); INSERT INTO `gmms_load_machine` VALUES ('2', '02', '停机中', '未连接', '8121', null, '2'); -- ---------------------------- -- 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, `raw_package_id` bigint(20) DEFAULT NULL, `load_machine_id` bigint(20) DEFAULT NULL, `raw_package_ready` tinyint(1) 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', '01', null, null, '1', null); INSERT INTO `gmms_load_machine_rack` VALUES ('2', '02', null, null, '1', null); INSERT INTO `gmms_load_machine_rack` VALUES ('3', '03', null, null, '2', null); INSERT INTO `gmms_load_machine_rack` VALUES ('4', '04', null, 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', '手动状态', '0', '0', '0', '0', '0', '2018-12-20 14:34:28'); INSERT INTO `gmms_load_statu` VALUES ('2', '手动状态', '0', '0', '0', '0', '0', '2018-12-20 14:34:29'); -- ---------------------------- -- 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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_measure_machine -- ---------------------------- INSERT INTO `gmms_measure_machine` VALUES ('1', '01', null, '正在连接', null, '8160'); INSERT INTO `gmms_measure_machine` VALUES ('2', '02', null, '正在连接', null, '8161'); -- ---------------------------- -- Table structure for `gmms_mission` -- ---------------------------- DROP TABLE IF EXISTS `gmms_mission`; CREATE TABLE `gmms_mission` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(50) DEFAULT NULL, `batch` 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', `state` varchar(50) DEFAULT NULL, `groups` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_mission -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_only_team` -- ---------------------------- DROP TABLE IF EXISTS `gmms_only_team`; CREATE TABLE `gmms_only_team` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `temperedid` varchar(100) DEFAULT NULL, `percent` double DEFAULT NULL, `status` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_only_team -- ---------------------------- -- ---------------------------- -- 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, `content` varchar(6000) DEFAULT NULL, `manufacture_batch_id` bigint(20) DEFAULT NULL, `batch` varchar(255) DEFAULT NULL, `groups` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `manufacture_batch_id` (`manufacture_batch_id`), CONSTRAINT `gmms_opt_pattern_ibfk_1` FOREIGN KEY (`manufacture_batch_id`) REFERENCES `gmms_manufacture_batch` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_opt_pattern -- ---------------------------- -- ---------------------------- -- 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, `manufacture_batch_id` bigint(20) DEFAULT NULL, `identify_machine_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `manufacture_batch_id` (`manufacture_batch_id`), KEY `glass_id` (`glass_id`), KEY `identify_machine_id` (`identify_machine_id`), CONSTRAINT `gmms_preprocessing_glass_ibfk_1` FOREIGN KEY (`manufacture_batch_id`) REFERENCES `gmms_manufacture_batch` (`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` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `pattern` varchar(255) DEFAULT NULL, `line` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_print_machine -- ---------------------------- -- ---------------------------- -- 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, `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, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_raw_package -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_search_shelf_rank` -- ---------------------------- DROP TABLE IF EXISTS `gmms_search_shelf_rank`; CREATE TABLE `gmms_search_shelf_rank` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `gmms_shelf_rank_id` bigint(20) DEFAULT NULL, `gmms_cut_machine_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `gmms_shelf_rank_id` (`gmms_shelf_rank_id`), KEY `gmms_cut_machine_id` (`gmms_cut_machine_id`), CONSTRAINT `gmms_search_shelf_rank_ibfk_1` FOREIGN KEY (`gmms_shelf_rank_id`) REFERENCES `gmms_shelf_rank` (`id`) ON UPDATE CASCADE, CONSTRAINT `gmms_search_shelf_rank_ibfk_2` FOREIGN KEY (`gmms_cut_machine_id`) REFERENCES `gmms_cut_machine` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_search_shelf_rank -- ---------------------------- -- ---------------------------- -- 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`) ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_shelf_hoist -- ---------------------------- INSERT INTO `gmms_shelf_hoist` VALUES ('1', '01', null, null); INSERT INTO `gmms_shelf_hoist` VALUES ('2', '02', null, 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, `raw_package_id` bigint(20) 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=40 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_shelf_rank -- ---------------------------- INSERT INTO `gmms_shelf_rank` VALUES ('1', '01', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('2', '02', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('3', '03', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('4', '04', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('5', '05', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('6', '06', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('7', '07', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('8', '08', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('9', '09', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('10', '10', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('11', '11', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('12', '12', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('13', '13', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('14', '14', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('15', '15', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('16', '16', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('17', '17', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('18', '18', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('19', '19', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('20', '20', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('21', '21', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('36', '36', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('37', '37', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('38', '38', null, null); INSERT INTO `gmms_shelf_rank` VALUES ('39', '39', null, null); -- ---------------------------- -- 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, `statu` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_shelf_statu -- ---------------------------- INSERT INTO `gmms_shelf_statu` VALUES ('1', 'manual'); -- ---------------------------- -- 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_tam` -- ---------------------------- DROP TABLE IF EXISTS `gmms_tam`; CREATE TABLE `gmms_tam` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `val` varchar(128) NOT NULL, `k` int(11) DEFAULT NULL, `length` double DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_tam -- ---------------------------- -- ---------------------------- -- 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_team` -- ---------------------------- DROP TABLE IF EXISTS `gmms_team`; CREATE TABLE `gmms_team` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `teamid` int(11) DEFAULT NULL, `length` double DEFAULT NULL, `width` double DEFAULT NULL, `team` varchar(50) DEFAULT NULL, `area` double DEFAULT NULL, `status` varchar(50) DEFAULT NULL, `percent` double DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_team -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_temp_parameter` -- ---------------------------- DROP TABLE IF EXISTS `gmms_temp_parameter`; CREATE TABLE `gmms_temp_parameter` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `templength` double NOT NULL, `tempwidth` double NOT NULL, `templengthinterval` double NOT NULL, `tempwidthinterval` double NOT NULL, `tempsidelengthinterval` double NOT NULL, `tempsidewidthinterval` double NOT NULL, `tempuppercent` double NOT NULL, `temponpercent` double NOT NULL, `teampercent` double NOT NULL, `templengthpercent` double NOT NULL, `tempwidthpercent` double NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_temp_parameter -- ---------------------------- INSERT INTO `gmms_temp_parameter` VALUES ('1', '8000', '3000', '50', '30', '50', '30', '0.65', '0.85', '0.85', '0.15', '0.15'); -- ---------------------------- -- 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, `userid` varchar(50) DEFAULT NULL, `teamid` varchar(50) DEFAULT NULL, `glass_id` bigint(20) DEFAULT NULL, `manufacture_batch_id` bigint(20) DEFAULT NULL, `measure_machine_id` bigint(20) DEFAULT NULL, `gmms_arrange_machine_rank_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`), KEY `gmms_arrange_machine_rank_id` (`gmms_arrange_machine_rank_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, CONSTRAINT `gmms_toughening_glass_ibfk_4` FOREIGN KEY (`gmms_arrange_machine_rank_id`) REFERENCES `gmms_arrange_machine_rank` (`id`) ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_toughening_glass -- ---------------------------- -- ---------------------------- -- Table structure for `gmms_transmit_machine` -- ---------------------------- DROP TABLE IF EXISTS `gmms_transmit_machine`; CREATE TABLE `gmms_transmit_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=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_transmit_machine -- ---------------------------- INSERT INTO `gmms_transmit_machine` VALUES ('1', '01', '停机中', '正在连接', null, '8180'); -- ---------------------------- -- 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 CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `login_name` (`login_name`) ) ENGINE=InnoDB AUTO_INCREMENT=14 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', 'user', 'Calvin', '2488aa0c31c624687bd9928e0a5d29e7d1ed520b', '6d65d24122c30500', 'user', '1', '2012-06-04 02:00:00'); INSERT INTO `gmms_user` VALUES ('3', 'cangchu', 'cangchu', '0b758ab9fb7b358b93961ab047224fda16a8bf6a', 'd04571a0f1ca1a30', 'cangchu', '1', '2012-06-04 02:00:00'); INSERT INTO `gmms_user` VALUES ('4', 'qiege', 'qiege', '1f6ca85a796572b9d236e0487521c870a7a60be1', 'fc961ed3a7d9da04', 'qiege', '1', '2012-06-04 02:00:00'); INSERT INTO `gmms_user` VALUES ('5', 'manager', 'manager', '680ed74ba20ea5fb0454cc0bbfbeee4e917c1e89', '69247bcc1a1dd877', 'manager', '1', '2012-06-04 02:00:00'); INSERT INTO `gmms_user` VALUES ('6', 'group', 'group', 'b387bc3bd054d66bcd9f07324d5f1c408603dc86', '37f680f83155559d', 'group', '1', '2012-06-04 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 ('8', 'celiang', 'celiang', 'bf9b3d04d7a74f67ea4101d53935a1e580be20e1', '883ab755fc387bef', 'celiang', '1', '2012-06-04 02:00:00'); INSERT INTO `gmms_user` VALUES ('9', 'zuzhang', 'zuzhang', 'ad56fe11012c113fcd60263e404d57f69f7a9947', 'dcf2bf4ba2ec9569', 'grouper', '1', '2012-06-04 02:00:00'); INSERT INTO `gmms_user` VALUES ('10', 'xiapian2', 'xiapian2', 'aa85bd5a296f54105a1180197d400cc0203bcda7', 'ec1f393b29ae0179', 'xiapian', '2', '2012-06-04 02:00:00'); INSERT INTO `gmms_user` VALUES ('11', 'celiang2', 'celiang2', 'bf9b3d04d7a74f67ea4101d53935a1e580be20e1', '883ab755fc387bef', 'celiang', '2', '2012-06-04 02:00:00'); INSERT INTO `gmms_user` VALUES ('12', 'zuzhang2', 'zuzhang2', 'ad56fe11012c113fcd60263e404d57f69f7a9947', 'dcf2bf4ba2ec9569', 'grouper', '2', '2012-06-04 02:00:00'); INSERT INTO `gmms_user` VALUES ('13', 'qiege2', 'qiege2', '1f6ca85a796572b9d236e0487521c870a7a60be1', 'fc961ed3a7d9da04', 'qiege', '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 AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of gmms_wash_machine -- ---------------------------- INSERT INTO `gmms_wash_machine` VALUES ('1', '01', null, null, null, '10000'); INSERT INTO `gmms_wash_machine` VALUES ('2', '02', null, null, null, '10001'); -- ---------------------------- -- 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', 'start');