File: C:/xampp/htdocs/PBN/PSAproduction3/psaproduction2.sql
/*
MySQL Data Transfer
Source Host: 192.168.1.100
Source Database: tvicheck-st
Target Host: 192.168.1.100
Target Database: tvicheck-st
Date: 2015/3/29 �W�� 12:27:47
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for psaproduction2
-- ----------------------------
CREATE TABLE `psaproduction2` (
`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,
`target` varchar(255) 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=1378 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `psaproduction2` VALUES ('1371', null, null, null, 'Test4', null, '818-ControlV20_cp38.txt', null, 'psa005', '0', '0', '2014-06-16 09:07:00', '2014-06-16', null, null, 'Heidelberg', null, 'Sterling', '', null, null, 'No', null, null, null, '9.84', '49.72', '44.61', '88.89', '46.90', '66.97', '62.18', '90.22', '43.83', 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 `psaproduction2` VALUES ('1372', null, null, null, '', null, '485-PSA_20Test_M0.txt', null, '13', '0', '0', '2015-03-21 23:41:36', '2015-03-21', null, null, 'HD', null, '150', '', null, null, 'No', null, null, null, '9.84', '49.72', '44.61', '88.89', '46.90', '66.97', '62.18', '90.22', '43.83', 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 `psaproduction2` VALUES ('1373', null, null, null, '', null, '894-PSA_20Test_M0.txt', null, '14', '0', '0', '2015-03-22 00:38:25', '2015-03-21', null, null, 'HD', null, '150', '', null, null, 'No', null, null, null, '9.84', '49.72', '44.61', '88.89', '46.90', '66.97', '62.18', '90.22', '43.83', 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 `psaproduction2` VALUES ('1374', null, null, null, '', null, '063-PSA_20Test_M0.txt', null, '1508', '0', '0', '2015-03-22 00:41:06', '2015-03-22', null, null, 'HD', null, '150', '', null, null, 'No', null, null, null, '9.84', '49.72', '44.61', '88.89', '46.90', '66.97', '62.18', '90.22', '43.83', 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 `psaproduction2` VALUES ('1370', null, null, null, 'Test3', null, '598-ControlV20_cp38.txt', null, 'psa003', '1', '0', '2014-06-11 07:59:35', '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 `psaproduction2` VALUES ('1375', null, null, null, '', null, '430-PSA_20Test_M0.txt', 'Fogra39', '15030132', '0', '0', '2015-03-29 00:00:40', '2015-03-23', null, null, 'HD', null, 'YF126', '', null, null, 'No', null, null, null, '9.84', '48.88', '44.53', '88.89', '48.36', '67.48', '63.29', '90.31', '44.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 `psaproduction2` VALUES ('1376', null, null, null, '', null, '476-PSA_20Test_M0.txt', 'CRPC6', '15030132', '0', '0', '2015-03-29 00:01:18', '2015-03-23', null, null, 'HD', null, 'YF126', '', null, null, 'No', null, null, null, '9.84', '49.72', '44.61', '88.89', '46.90', '66.97', '62.18', '90.22', '43.83', 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 `psaproduction2` VALUES ('1377', null, null, null, '', null, '642-PSA_20Test_M0.txt', 'CRPC6', '15030132', '0', '0', '2015-03-29 00:04:11', '2015-03-23', null, null, 'HD', null, 'YF126', '', null, null, 'No', null, null, null, '9.84', '49.72', '44.61', '88.89', '46.90', '66.97', '62.18', '90.22', '43.83', 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);