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
$ pwd: C:/xampp/htdocs/Xerox/
Upload Files
File: C:/xampp/htdocs/Xerox/xdata.sql
/*
MySQL Data Transfer
Source Host: localhost
Source Database: tvicheck-st
Target Host: localhost
Target Database: tvicheck-st
Date: 2014/1/16 �U�� 10:11:27
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for xdata
-- ----------------------------
CREATE TABLE `xdata` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `contact` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `filename` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `ddate` datetime DEFAULT NULL,
  `cmmt` varchar(1) DEFAULT NULL,
  `PO` varchar(255) DEFAULT NULL,
  `score` double 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,
  `deK` double(10,2) DEFAULT NULL,
  `k100` double(10,2) DEFAULT NULL,
  `k40` double(10,2) DEFAULT NULL,
  `deCy` double(10,2) DEFAULT NULL,
  `c100` double(10,2) DEFAULT NULL,
  `c40` double(10,2) DEFAULT NULL,
  `deM` double(10,2) DEFAULT NULL,
  `m100` double(10,2) DEFAULT NULL,
  `m40` double(10,2) DEFAULT NULL,
  `deY` double(10,2) DEFAULT NULL,
  `y100` double(10,2) DEFAULT NULL,
  `y40` double(10,2) DEFAULT NULL,
  `kl` double DEFAULT NULL,
  `ka` double DEFAULT NULL,
  `kb` double DEFAULT NULL,
  `cl` double DEFAULT NULL,
  `ca` double DEFAULT NULL,
  `cb` double DEFAULT NULL,
  `ml` double DEFAULT NULL,
  `ma` double DEFAULT NULL,
  `mb` double DEFAULT NULL,
  `yl` double DEFAULT NULL,
  `ya` double DEFAULT NULL,
  `yb` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2020 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `xdata` VALUES ('1997', 'Fred', '224-X9.csv', '2014-01-15 18:42:06', null, null, '0', 'i1', '', '', '', '', '2.90', '1.68', '0.46', '3.98', '1.50', '0.41', '0.00', '1.54', '0.44', '2.07', '1.36', '0.43', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xdata` VALUES ('1998', 'Fred', '378-X9.csv', '2014-01-15 18:42:34', null, null, '0', 'i1', '', '', '', '', '2.90', '1.68', '0.46', '3.98', '1.50', '0.41', '0.00', '1.54', '0.44', '2.07', '1.36', '0.43', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xdata` VALUES ('1999', '', '671-X9.csv', '2014-01-16 00:54:07', null, '', '0', '', '', '', '', '', '2.90', '1.68', '0.46', '3.98', '1.50', '0.41', '0.00', '1.54', '0.44', '2.07', '1.36', '0.43', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xdata` VALUES ('2000', 'Fred', '736-X9.csv', '2014-01-16 00:55:12', null, 'A1234', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '2.90', '1.68', '0.46', '3.98', '1.50', '0.41', '0.00', '1.54', '0.44', '2.07', '1.36', '0.43', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xdata` VALUES ('2001', 'Fred', '757-X9.csv', '2014-01-16 00:55:33', null, 'A1234', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '2.90', '1.68', '0.46', '3.98', '1.50', '0.41', '0.00', '1.54', '0.44', '2.07', '1.36', '0.43', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xdata` VALUES ('2002', 'Fred', '769-X9.csv', '2014-01-16 00:55:45', null, 'A1234', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '2.90', '1.68', '0.46', '3.98', '1.50', '0.41', '1.39', '1.54', '0.44', '2.07', '1.36', '0.43', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xdata` VALUES ('2003', 'Fred', '779-X9.csv', '2014-01-16 00:55:55', null, 'A1234', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '2.90', '1.68', '0.46', '3.98', '1.50', '0.41', '1.39', '1.54', '0.44', '2.07', '1.36', '0.43', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xdata` VALUES ('2004', 'Fred', '997-X9-1.csv', '2014-01-16 00:59:33', null, 'A1234', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '3.02', '1.78', '0.46', '3.48', '1.40', '0.41', '1.39', '1.64', '0.44', '2.93', '1.46', '0.43', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xdata` VALUES ('2005', 'Fred', '159-X9-1.csv', '2014-01-16 01:02:15', null, 'A1234', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '3.02', '1.78', '0.46', '3.48', '1.40', '0.41', '2.46', '1.64', '0.44', '2.93', '1.46', '0.43', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xdata` VALUES ('2006', 'Fred', '179-X9.csv', '2014-01-16 01:02:35', null, 'A1234', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '2.90', '1.68', '0.46', '3.98', '1.50', '0.41', '1.39', '1.54', '0.44', '2.07', '1.36', '0.43', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xdata` VALUES ('2007', 'Fred', '341-X9-2.csv', '2014-01-16 01:05:17', null, 'A1234', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '1.96', '1.88', '0.46', '3.56', '1.49', '0.51', '2.46', '1.69', '0.44', '3.43', '1.26', '0.43', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xdata` VALUES ('2008', 'Fred', '366-X9.csv', '2014-01-16 01:05:42', null, 'A1234', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '2.90', '1.68', '0.46', '3.98', '1.50', '0.41', '1.39', '1.54', '0.44', '2.07', '1.36', '0.43', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xdata` VALUES ('2009', 'Fred', '372-X9-1.csv', '2014-01-16 01:05:48', null, 'A1234', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '3.02', '1.78', '0.46', '3.48', '1.40', '0.41', '2.46', '1.64', '0.44', '2.93', '1.46', '0.43', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xdata` VALUES ('2010', 'Fred', '381-X9-2.csv', '2014-01-16 01:05:57', null, 'A1234', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '1.96', '1.88', '0.46', '3.56', '1.49', '0.51', '2.46', '1.69', '0.44', '3.43', '1.26', '0.43', null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `xdata` VALUES ('2011', 'Fred', '964-X9-2.csv', '2014-01-16 01:32:20', null, 'A12345', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '1.96', '1.88', '0.46', '3.56', '1.49', '0.51', '2.46', '1.69', '0.44', '3.43', '1.26', '0.43', '15.76', '0.59', '1.87', '55.92', '-38.2', '-46.75', '46.54', '75.61', '-1.84', '86.57', '-3.79', '90.9');
INSERT INTO `xdata` VALUES ('2012', 'Fred', '005-X9-1.csv', '2014-01-16 01:33:01', null, 'A12345', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '3.02', '1.78', '0.46', '3.48', '1.40', '0.41', '2.46', '1.64', '0.44', '2.93', '1.46', '0.43', '16.76', '0.59', '2.87', '55.42', '-38.2', '-46.75', '46.54', '75.61', '-1.84', '86.57', '-3.79', '91.9');
INSERT INTO `xdata` VALUES ('2013', 'Fred', '168-X9-5.csv', '2014-01-16 01:35:44', null, 'A12345', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '1.92', '1.88', '0.46', '5.02', '1.49', '0.51', '1.62', '1.69', '0.44', '2.56', '1.16', '0.43', '15.76', '0.89', '1.7', '55.92', '-37.2', '-45.05', '46.54', '74.61', '-2.64', '86.57', '-5.79', '92.9');
INSERT INTO `xdata` VALUES ('2014', 'Fred', '173-X9-4.csv', '2014-01-16 01:35:49', null, 'A12345', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '1.92', '1.88', '0.46', '4.49', '1.49', '0.51', '2.56', '1.69', '0.44', '2.44', '1.26', '0.43', '15.76', '0.89', '1.7', '55.92', '-38.2', '-45.75', '46.54', '75.61', '-1.64', '86.57', '-4.79', '92.9');
INSERT INTO `xdata` VALUES ('2015', 'Fred', '179-X9-2.csv', '2014-01-16 01:35:55', null, 'A12345', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '1.96', '1.88', '0.46', '3.56', '1.49', '0.51', '2.46', '1.69', '0.44', '3.43', '1.26', '0.43', '15.76', '0.59', '1.87', '55.92', '-38.2', '-46.75', '46.54', '75.61', '-1.84', '86.57', '-3.79', '90.9');
INSERT INTO `xdata` VALUES ('2016', 'Fred', '187-X9-1.csv', '2014-01-16 01:36:03', null, 'A12345', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '3.02', '1.78', '0.46', '3.48', '1.40', '0.41', '2.46', '1.64', '0.44', '2.93', '1.46', '0.43', '16.76', '0.59', '2.87', '55.42', '-38.2', '-46.75', '46.54', '75.61', '-1.84', '86.57', '-3.79', '91.9');
INSERT INTO `xdata` VALUES ('2017', 'Fred', '196-X9.csv', '2014-01-16 01:36:12', null, 'A12345', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '2.90', '1.68', '0.46', '3.98', '1.50', '0.41', '1.39', '1.54', '0.44', '2.07', '1.36', '0.43', '15.76', '0.39', '2.87', '54.42', '-39.2', '-46.75', '47.54', '74.61', '-1.84', '87.57', '-3.99', '91.9');
INSERT INTO `xdata` VALUES ('2018', 'Fred', '203-X9-4.csv', '2014-01-16 01:36:19', null, 'A12345', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '1.92', '1.88', '0.46', '4.49', '1.49', '0.51', '2.56', '1.69', '0.44', '2.44', '1.26', '0.43', '15.76', '0.89', '1.7', '55.92', '-38.2', '-45.75', '46.54', '75.61', '-1.64', '86.57', '-4.79', '92.9');
INSERT INTO `xdata` VALUES ('2019', 'Fred', '212-X9-5.csv', '2014-01-16 01:36:28', null, 'A12345', '0', 'i1', '', 'J75', '100P特銅', 'Xerox', '1.92', '1.88', '0.46', '5.02', '1.49', '0.51', '1.62', '1.69', '0.44', '2.56', '1.16', '0.43', '15.76', '0.89', '1.7', '55.92', '-37.2', '-45.05', '46.54', '74.61', '-2.64', '86.57', '-5.79', '92.9');
@ Telegram