HEX
Server: Apache/2.4.46 (Win64) OpenSSL/1.1.1j PHP/8.4.25
System: Windows NT DESKTOP-4TAV2RJ 10.0 build 19045 (Windows 10) AMD64
User: fred (0)
PHP: 8.4.25
Disabled: NONE
Upload Files
File: C:/xampp/htdocs/PBN/G7CMYK/gcmyk.sql
/*
MySQL Data Transfer
Source Host: localhost
Source Database: tvicheck
Target Host: localhost
Target Database: tvicheck
Date: 2015/9/11 �W�� 12:35:02
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for gcmyk
-- ----------------------------
CREATE TABLE `gcmyk` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `company` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `contact` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `filename` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `cmmt` varchar(255) DEFAULT NULL,
  `score` double DEFAULT NULL,
  `passbit` tinyint(1) DEFAULT '0',
  `date` date DEFAULT NULL,
  `device` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `dsn` varchar(255) DEFAULT NULL,
  `printer` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `paper` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `ink` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `rankbit` tinyint(1) DEFAULT NULL,
  `rank` int(11) DEFAULT NULL,
  `onsite` varchar(255) DEFAULT 'No',
  `ip` varchar(255) DEFAULT NULL,
  `L` double DEFAULT NULL,
  `a` double DEFAULT NULL,
  `b` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=816 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `gcmyk` VALUES ('757', 'HP', 'Fred', '', '', '916-HP53P2P.txt', null, '-69.48', '0', '2014-08-28', 'Eye-One', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('758', 'HP', 'Fred', '', '', '768-HP53P2P-m1.txt', null, '-89.14', '0', '2014-08-28', 'Eye-One', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('759', 'JIYI', '', '', '', '522-P2p246CMY-x1.txt', null, '-62.52', '0', '2014-09-17', 'Eye-One', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('760', '', '', '', '', '032-P2p246RGBHp-x1.txt', null, '-39.37', '0', '2014-09-17', 'Eye-One', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('761', '', '', '', '', '170-P2p246RGBHp-x2.txt', null, '-76.19', '0', '2014-09-18', 'Eye-One', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('762', '', '', '', '', '319-P2p246RGBHp-x3.txt', null, '-37.2', '0', '2014-09-18', 'Eye-One', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('763', '', '', '', '', '236-P2p246RGBHp-LC.txt', null, '-69.29', '0', '2014-09-18', 'Eye-One', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('764', 'JIYI', '', '', '', '430-Hp_Coated.txt', null, '-53.41', '0', '2014-09-18', 'Eye-One', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('765', 'JIYI', 'Fred', '', '', '082-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', '', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('766', 'JIYI', 'Fred', '', '', '133-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('767', 'JIYI', 'Fred', '', '', '249-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('768', 'JIYI', 'Fred', '', '', '285-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('769', 'JIYI', 'Fred', '', '', '011-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('770', 'JIYI', 'Fred', '', '', '056-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('771', 'JIYI', 'Fred', '', '', '300-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('772', 'JIYI', 'Fred', '', '', '035-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('773', 'JIYI', 'Fred', '', '', '111-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('774', 'JIYI', 'Fred', '', '', '997-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('775', 'JIYI', 'Fred', '', '', '064-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('776', 'JIYI', 'Fred', '', '', '146-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('777', 'JIYI', 'Fred', '', '', '154-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('778', 'JIYI', 'Fred', '', '', '449-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('779', 'JIYI', 'Fred', '', '', '698-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('780', 'JIYI', 'Fred', '', '', '704-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('781', 'JIYI', 'Fred', '', '', '754-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('782', 'JIYI', 'Fred', '', '', '798-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('783', 'JIYI', 'Fred', '', '', '881-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('784', 'JIYI', 'Fred', '', '', '906-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('785', 'JIYI', 'Fred', '', '', '949-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('786', 'JIYI', 'Fred', '', '', '080-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('787', 'JIYI', 'Fred', '', '', '149-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('788', 'JIYI', 'Fred', '', '', '500-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('789', 'JIYI', 'Fred', '', '', '526-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('790', 'JIYI', 'Fred', '', '', '539-G7CMYK.txt', null, '-858.71', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('791', 'JIYI', 'Fred', '', '', '551-FX-G7CMYK.txt', null, '-829.26', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('792', 'JIYI', 'Fred', '', '', '606-FX-G7CMYK.txt', null, '-829.26', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('793', 'JIYI', 'Fred', '', '', '868-FX-G7CMYK.txt', null, '-829.26', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('794', 'JIYI', 'Fred', '', '', '181-FX-G7CMYK.txt', null, '-829.26', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('795', 'JIYI', 'Fred', '', '', '190-FX-G7CMYK.txt', null, '-829.26', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('796', 'JIYI', 'Fred', '', '', '267-FX-G7CMYK.txt', null, '-829.26', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('797', 'JIYI', 'Fred', '', '', '507-FX-G7CMYK.txt', null, '-829.26', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('798', 'JIYI', 'Fred', '', '', '545-FX-G7CMYK.txt', null, '-829.26', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('799', 'JIYI', 'Fred', '', '', '707-FX-G7CMYK.txt', null, '-829.26', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('800', 'JIYI', 'Fred', '', '', '490-FX-G7CMYK.txt', null, '0', '0', '2015-09-02', 'i1Pro2', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('801', '', '', '', '', '879-490-FX-G7CMYK.txt', null, '0', '0', '2015-09-04', '', '', '', '', '', '0', null, 'No', '127.0.0.1', null, null, null);
INSERT INTO `gcmyk` VALUES ('802', '', '', '', '', '076-490-FX-G7CMYK.txt', null, '0', '0', '2015-09-04', '', '', '', '', '', '0', null, 'No', '127.0.0.1', '62', '1.2', '-2');
INSERT INTO `gcmyk` VALUES ('803', '', '', '', '', '889-490-FX-G7CMYK.txt', null, '0', '0', '2015-09-04', '', '', '', '', '', '0', null, 'No', '127.0.0.1', '62', '1.2', '-2');
INSERT INTO `gcmyk` VALUES ('804', '', '', '', '', '148-490-FX-G7CMYK.txt', null, '0', '0', '2015-09-04', '', '', '', '', '', '0', null, 'No', '127.0.0.1', '62', '1.2', '-2');
INSERT INTO `gcmyk` VALUES ('805', '', '', '', '', '212-490-FX-G7CMYK.txt', null, '0', '0', '2015-09-04', '', '', '', '', '', '0', null, 'No', '127.0.0.1', '62', '1.2', '-2');
INSERT INTO `gcmyk` VALUES ('806', 'Pro', '', '', '', '904-5500Fx1.txt', null, '0', '0', '2015-09-04', 'i1Pro2', '', 'HP5500', '', '', '0', null, 'No', '127.0.0.1', '58.8', '-2', '-5');
INSERT INTO `gcmyk` VALUES ('807', 'Pro', '', '', '', '902-5500Fx1.txt', null, '0', '0', '2015-09-04', 'i1Pro2', '', 'HP5500', '', '', '0', null, 'No', '127.0.0.1', '58.8', '-2', '-5');
INSERT INTO `gcmyk` VALUES ('808', 'Pro', '', '', '', '911-5500Fx1.txt', null, '0', '0', '2015-09-04', 'i1Pro2', '', 'HP5500', '', '', '0', null, 'No', '127.0.0.1', '58.8', '-2', '-5');
INSERT INTO `gcmyk` VALUES ('809', 'Pro', '', '', '', '901-5500Fx1.txt', null, '0', '0', '2015-09-04', 'i1Pro2', '', 'HP5500', '', '', '0', null, 'No', '127.0.0.1', '58.8', '-2', '-5');
INSERT INTO `gcmyk` VALUES ('810', 'Pro', '', '', '', '431-5500Fx1.txt', null, '0', '0', '2015-09-04', 'i1Pro2', '', 'HP5500', '', '', '0', null, 'No', '127.0.0.1', '58.8', '-2', '-5');
INSERT INTO `gcmyk` VALUES ('811', 'Pro', '', '', '', '538-5500Fx1.txt', null, '0', '0', '2015-09-04', 'i1Pro2', '', 'HP5500', '', '', '0', null, 'No', '127.0.0.1', '58.8', '-2', '-5');
INSERT INTO `gcmyk` VALUES ('812', 'Pro', '', '', '', '704-5500Fx1.txt', null, '0', '0', '2015-09-04', 'i1Pro2', '', 'HP5500', '', '', '0', null, 'No', '127.0.0.1', '58.8', '-2', '-5');
INSERT INTO `gcmyk` VALUES ('813', 'Pro', '', '', '', '834-5500Fx1.txt', null, '0', '0', '2015-09-04', 'i1Pro2', '', 'HP5500', '', '', '0', null, 'No', '127.0.0.1', '58.8', '-2', '-5');
INSERT INTO `gcmyk` VALUES ('814', 'Pro', '', '', '', '417-5500Fx2.txt', null, '0', '0', '2015-09-04', 'i1Pro2', '', 'HP5500', '', '', '0', null, 'No', '127.0.0.1', '58.8', '-2', '-5');
INSERT INTO `gcmyk` VALUES ('815', 'Crony', 'Fred', '', '', '335-Crony5065.txt', null, '0', '0', '2015-09-09', 'i1', '', '5065', 'MattCoated', 'Xerox', '0', null, 'No', '127.0.0.1', '57.2', '0.4', '-0.3');