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/FograCT9/
Upload Files
File: C:/xampp/htdocs/FograCT9/psaproduction.sql
/*
MySQL Data Transfer
Source Host: localhost
Source Database: tvicheck-st
Target Host: localhost
Target Database: tvicheck-st
Date: 2015/5/9 �U�� 10:16:04
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for psaproduction
-- ----------------------------
CREATE TABLE `psaproduction` (
  `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,
  `cmmt` varchar(255) CHARACTER SET big5 DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `filename` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `po` varchar(255) DEFAULT NULL,
  `sNo` int(11) DEFAULT NULL,
  `passbit` tinyint(1) DEFAULT '0',
  `ddate` datetime DEFAULT NULL,
  `pdate` date DEFAULT NULL,
  `device` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `dsn` varchar(255) DEFAULT NULL,
  `press` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `strip` varchar(255) 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',
  `pL` double(10,2) DEFAULT NULL,
  `pa` double(10,2) DEFAULT NULL,
  `pb` double(10,2) DEFAULT NULL,
  `dek` double(10,2) DEFAULT NULL,
  `decc` double(10,2) DEFAULT NULL,
  `dem` double(10,2) DEFAULT NULL,
  `dey` double(10,2) DEFAULT NULL,
  `dek50` double(10,2) DEFAULT NULL,
  `dec50` double(10,2) DEFAULT NULL,
  `dem50` double(10,2) DEFAULT NULL,
  `dey50` double(10,2) DEFAULT NULL,
  `deg` double(10,2) DEFAULT NULL,
  `k100L` double(10,2) DEFAULT NULL,
  `k100a` double(10,2) DEFAULT NULL,
  `k100b` double(10,2) DEFAULT NULL,
  `k50L` double(10,2) DEFAULT NULL,
  `k50a` double(10,2) DEFAULT NULL,
  `k50b` double(10,2) DEFAULT NULL,
  `c100L` double(10,2) DEFAULT NULL,
  `c100a` double(10,2) DEFAULT NULL,
  `c100b` double(10,2) DEFAULT NULL,
  `c50L` double(10,2) DEFAULT NULL,
  `c50a` double(10,2) DEFAULT NULL,
  `c50b` double(10,2) DEFAULT NULL,
  `m100L` double(10,2) DEFAULT NULL,
  `m100a` double(10,2) DEFAULT NULL,
  `m100b` double(10,2) DEFAULT NULL,
  `m50L` double(10,2) DEFAULT NULL,
  `m50a` double(10,2) DEFAULT NULL,
  `m50b` double(10,2) DEFAULT NULL,
  `y100L` double(10,2) DEFAULT NULL,
  `y100a` double(10,2) DEFAULT NULL,
  `y100b` double(10,2) DEFAULT NULL,
  `y50L` double(10,2) DEFAULT NULL,
  `y50a` double(10,2) DEFAULT NULL,
  `y50b` double(10,2) DEFAULT NULL,
  `g50L` double(10,2) DEFAULT NULL,
  `g50a` double(10,2) DEFAULT NULL,
  `g50b` double(10,2) DEFAULT NULL,
  `setOK` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1373 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `psaproduction` VALUES ('1303', null, '', null, null, null, '318-ControlTarget_d1_ip_M0.txt', null, null, '0', '2014-06-04 18:08:14', null, '', '', '', null, 'Sterling', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1328', null, null, null, 'Test', null, '170-ControlTarget_d1_ip_M0.txt', 'psa001', '1', '0', '2014-06-05 16:02:26', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '1.53', '2.98', '1.38', '2.52', '2.63', '2.36', '1.83', '2.96', '2.36', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1350', null, null, null, null, null, '566-ControlTarget_d2_ip_M0.txt', 'psa001', '2', '0', '2014-06-05 16:25:42', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '1.53', '2.98', '1.38', '2.52', '2.63', '2.36', '1.83', '2.96', '2.36', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1351', null, null, null, null, null, '578-ControlTarget_d3_ip_M0.txt', 'psa001', '3', '0', '2014-06-05 16:25:54', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '1.96', '2.06', '1.98', '2.41', '3.77', '2.00', '1.36', '3.44', '1.99', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1352', null, null, null, null, null, '585-ControlTarget_d4_ip_M0.txt', 'psa001', '4', '0', '2014-06-05 16:26:01', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '2.53', '3.03', '2.26', '2.55', '2.26', '1.35', '1.81', '3.17', '1.79', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1353', null, null, null, null, null, '591-ControlTarget_d5_ip_M0.txt', 'psa001', '5', '0', '2014-06-05 16:26:07', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '2.09', '2.06', '1.79', '2.52', '3.54', '2.39', '1.76', '3.54', '2.19', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1354', null, null, null, null, null, '606-ControlTarget_d6_ip_M0.txt', 'psa001', '6', '0', '2014-06-05 16:26:22', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '2.88', '2.98', '2.21', '2.48', '2.58', '1.28', '1.85', '3.42', '2.31', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1355', null, null, null, null, null, '612-ControlTarget_d7_ip_M0.txt', 'psa001', '7', '0', '2014-06-05 16:26:28', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '1.82', '2.77', '1.35', '2.69', '3.18', '2.05', '1.55', '3.32', '2.37', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1356', null, null, null, null, null, '619-ControlTarget_d8_ip_M0.txt', 'psa001', '8', '0', '2014-06-05 16:26:35', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '2.14', '2.95', '1.38', '2.48', '3.66', '1.73', '1.40', '3.24', '1.53', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1357', null, null, null, null, null, '630-ControlTarget_d9_ip_M0.txt', 'psa001', '9', '0', '2014-06-05 16:26:46', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '2.86', '1.65', '2.09', '2.48', '4.02', '1.69', '1.40', '3.25', '2.01', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1358', null, null, null, null, null, '636-ControlTarget_d10_ip_M0.txt', 'psa001', '10', '0', '2014-06-05 16:26:52', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '2.58', '2.66', '2.38', '2.49', '2.38', '1.28', '1.47', '3.26', '1.33', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1359', null, null, null, null, null, '642-ControlTarget_d11_ip_M0.txt', 'psa001', '11', '0', '2014-06-05 16:26:58', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '1.65', '3.54', '2.47', '3.83', '1.75', '2.46', '1.84', '4.36', '1.04', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1360', null, null, null, null, null, '647-ControlTarget_d12_ip_M0.txt', 'psa001', '12', '0', '2014-06-05 16:27:03', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '2.25', '3.84', '2.44', '3.41', '2.21', '2.52', '1.78', '3.88', '1.16', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1361', null, null, null, null, null, '656-ControlTarget_d13_ip_M0.txt', 'psa001', '13', '0', '2014-06-05 16:27:13', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '1.78', '2.72', '1.35', '2.50', '2.98', '2.01', '1.58', '3.47', '2.16', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1362', null, null, null, null, null, '663-ControlTarget_d14_ip_M0.txt', 'psa001', '14', '0', '2014-06-05 16:27:19', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '2.16', '2.37', '1.31', '2.70', '2.59', '2.06', '1.59', '3.27', '1.62', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1363', null, null, null, null, null, '678-ControlTarget_d15_ip_M0.txt', 'psa001', '15', '0', '2014-06-05 16:27:34', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '2.19', '1.98', '1.98', '2.38', '3.55', '1.67', '1.25', '3.19', '2.20', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1364', null, null, null, null, null, '685-ControlTarget_d16_ip_M0.txt', 'psa001', '16', '0', '2014-06-05 16:27:41', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '2.10', '2.88', '2.21', '2.43', '2.90', '1.32', '1.24', '3.17', '1.40', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1365', null, null, null, null, null, '691-ControlTarget_d17_ip_M0.txt', 'psa001', '17', '0', '2014-06-05 16:27:47', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '2.46', '1.70', '2.07', '2.39', '3.70', '1.78', '1.43', '3.44', '1.96', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1366', null, null, null, null, null, '697-ControlTarget_d18_ip_M0.txt', 'psa001', '18', '0', '2014-06-05 16:27:53', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '2.48', '2.72', '2.31', '2.50', '2.43', '1.41', '1.48', '3.21', '1.49', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1367', null, null, null, null, null, '703-ControlTarget_d19_ip_M0.txt', 'psa001', '19', '0', '2014-06-05 16:27:59', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '1.80', '2.11', '1.70', '2.56', '3.44', '2.43', '1.76', '3.34', '2.09', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1368', null, null, null, 'Test', null, '711-ControlTarget_d20_ip_M0.txt', 'psa001', '20', '0', '2014-06-05 16:28:07', '2014-06-04', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '2.68', '3.04', '2.20', '2.62', '2.42', '1.35', '1.89', '3.42', '2.26', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1370', null, null, null, 'Test2', null, '472-ControlV20_cp40.txt', 'psa002', '1', '0', '2014-06-11 07:57:28', '2014-06-11', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '55.60', '38.65', '1.66', '77.50', '32.71', '17.75', '58.37', '40.02', '3.88', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1371', null, null, null, '', null, '507-JIYITVI-280-x2.txt', 'psa00XD', '1', '0', '2014-07-15 18:04:43', '2014-07-16', null, null, 'Heidelberg', null, '', '', null, null, 'No', null, null, null, '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `psaproduction` VALUES ('1372', null, null, null, '', null, '793-102-ControlTarget_d1_ip_M0.txt', 'psa00XD', '2', '0', '2014-07-15 18:09:29', '2014-07-16', null, null, 'Heidelberg', null, '', '', null, null, 'No', null, null, null, '1.53', '2.98', '1.38', '2.52', '2.63', '2.36', '1.83', '2.96', '2.36', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
@ Telegram