File: C:/xampp/htdocs/PBN/PSASID/psasid.sql
/*
Navicat Premium Data Transfer
Source Server : local
Source Server Type : MySQL
Source Server Version : 50616
Source Host : localhost
Source Database : tvicheck-st
Target Server Type : MySQL
Target Server Version : 50616
File Encoding : utf-8
Date: 07/03/2015 12:05:49 PM
*/
SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for `psasid`
-- ----------------------------
DROP TABLE IF EXISTS `psasid`;
CREATE TABLE `psasid` (
`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,
`score` double DEFAULT NULL,
`passbit` tinyint(1) DEFAULT '0',
`ddate` datetime DEFAULT NULL,
`device` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`dsn` varchar(255) DEFAULT NULL,
`printer` 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',
`bk` double(10,2) DEFAULT NULL,
`k100` double(10,2) DEFAULT NULL,
`k80` decimal(10,2) DEFAULT NULL,
`k40` double(10,2) DEFAULT NULL,
`bc` double(10,2) DEFAULT NULL,
`c100` double(10,2) DEFAULT NULL,
`c80` double(10,2) DEFAULT NULL,
`c40` double(10,2) DEFAULT NULL,
`bm` double(10,2) DEFAULT NULL,
`m100` double(10,2) DEFAULT NULL,
`m80` double(10,2) DEFAULT NULL,
`m40` double(10,2) DEFAULT NULL,
`by` double(10,2) DEFAULT NULL,
`y100` double(10,2) DEFAULT NULL,
`y80` double(10,2) DEFAULT NULL,
`y40` double(10,2) DEFAULT NULL,
`setOK` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of `psasid`
-- ----------------------------
BEGIN;
INSERT INTO `psasid` VALUES ('1', '', 'Fred', null, null, null, '798-742-ControlTarget_v2-CP.txt', null, null, null, '0', '2014-08-05 23:16:38', 'isis', '', '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('2', '', 'Fred', null, null, null, '803-742-ControlTarget_v2-CP.txt', null, null, null, '0', '2014-08-05 23:16:44', 'isis', '', '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('3', '', 'Fred', null, null, null, '867-742-ControlTarget_v2-CP.txt', null, null, null, '0', '2014-08-05 23:17:47', 'isis', null, '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('4', null, 'Fred', null, null, null, '902-742-ControlTarget_v2-CP.txt', null, null, null, '0', '2014-08-05 23:18:22', 'isis', null, '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('5', null, 'Fred', null, null, null, '070-742-ControlTarget_v2-CP.txt', null, null, null, '0', '2014-08-05 23:21:10', 'isis', null, '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('6', null, 'Fred', null, null, null, '110-742-ControlTarget_v2-CP.txt', null, null, null, '0', '2014-08-05 23:21:51', 'isis', null, '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('7', null, 'Fred', null, null, null, '537-742-ControlTarget_v2-CP.txt', null, null, null, '0', '2014-08-05 23:28:57', 'isis', null, '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('8', null, 'Fred', null, null, null, '574-742-ControlTarget_v2-CP.txt', null, null, null, '0', '2014-08-05 23:29:34', 'isis', null, '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('9', null, 'Fred', null, null, null, '108-742-ControlTarget_v2-CP.txt', null, null, null, '0', '2014-08-05 23:38:28', 'isis', null, '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('10', null, 'Fred', null, null, null, '128-742-ControlTarget_v2-CP.txt', null, null, null, '0', '2014-08-05 23:38:49', 'isis', null, '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('11', null, 'Fred', null, null, null, '681-PCCUSID_M0.txt', null, null, null, '0', '2014-08-06 10:54:41', null, null, 'Versant 2100', null, 'Sterling', 'Xerox', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('12', null, 'Fred H.', null, null, null, '076-Control_Target_v2_M1.txt', null, null, null, '0', '2014-08-15 10:34:37', null, null, 'Color Copier', null, 'Excel', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('13', null, 'Fred H.', null, null, null, '467-CTv2_M1_2.txt', null, null, null, '0', '2014-08-15 11:14:27', null, null, 'Color Copier', null, 'Excel', '2', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('14', null, 'LIYI', null, null, null, '748-wcms_coated_card_contrrlTargetV2.txt', null, null, null, '0', '2014-11-19 14:15:48', null, null, 'HJ Printing', null, '150p Coated', 'KODAK NextPress', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('15', null, 'LIYI', null, null, null, '296-CRPC7_coated_120_contrrlTargetV2.txt', null, null, null, '0', '2014-12-11 13:04:57', null, null, 'HJ Printing', null, '120pCoated', 'NextPressCRPC7', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('16', null, 'LIYI', null, null, null, '361-CRPC6_coated_120_contrrlTargetV2.txt', null, null, null, '0', '2014-12-11 13:06:01', null, null, 'HJ Printing', null, '120pCoated', 'NextPressCRPC6', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('17', null, 'Fred', null, null, null, '217-032-ControlTarget_v2-itr1_M0.txt', null, null, null, '0', '2015-04-16 08:46:58', null, null, 'Man Roland', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('18', null, 'Fred', null, null, null, '194-032-ControlTarget_v2-itr1_M0.txt', 'Fogra39', null, null, '0', '2015-04-16 09:19:55', null, null, 'Man Roland', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('19', null, 'Fred', null, null, null, '322-032-ControlTarget_v2-itr1_M0.txt', 'Fogra39', null, null, '0', '2015-04-16 09:22:03', null, null, 'Man Roland', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('20', null, 'Fred', null, null, null, '337-032-ControlTarget_v2-itr1_M0.txt', 'CRPC6', null, null, '0', '2015-04-16 09:22:17', null, null, 'Man Roland', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('21', null, 'Fred', null, null, null, '359-032-ControlTarget_v2-itr1_M0.txt', 'GRACoL2006', null, null, '0', '2015-04-16 09:22:39', null, null, 'Man Roland', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('22', null, 'Fred', null, null, null, '369-032-ControlTarget_v2-itr1_M0.txt', 'CRPC6', null, null, '0', '2015-04-16 09:22:50', null, null, 'Man Roland', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('23', null, 'Fred', null, null, null, '829-032-ControlTarget_v2-itr1_M0.txt', 'CRPC6', null, null, '0', '2015-04-16 09:47:09', null, null, 'Man Roland', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('24', null, 'Fred', null, null, null, '053-032-ControlTarget_v2-itr1_M0.txt', 'Fogra39', null, null, '0', '2015-04-16 09:50:54', null, null, 'Man Roland', null, 'YF120', 'DIC', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('25', null, 'Fred', null, null, null, '029-032-ControlTarget_v2-itr1_M0.txt', 'CRPC6', null, null, '0', '2015-04-16 10:23:50', null, null, 'Man Roland', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('26', null, 'Fred', null, null, null, '698-032-ControlTarget_v2-itr1_M0.txt', 'Fogra39', null, null, '0', '2015-04-16 10:34:58', null, null, 'Man Roland', null, 'YF120', 'DIC', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('27', null, 'Fred', null, null, null, '', 'CRPC6', null, null, '0', '2015-05-09 18:18:00', null, null, '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('28', null, 'Fred', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-05-09 18:22:38', null, null, '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('29', null, '[email protected]', null, null, null, '106-Samp1.txt', 'CRPC6', null, null, '0', '2015-06-02 23:31:46', null, null, 'ManRoland', null, 'YF126', 'DIC', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('30', null, '[email protected]', null, null, null, '417-Samp1.txt', 'CRPC6', null, null, '0', '2015-06-02 23:36:57', null, null, 'ManRoland', null, 'YF126', 'DIC', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('31', null, '[email protected]', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-06-02 23:37:45', null, null, 'ManRoland', null, 'YF126', 'DIC', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('32', null, '[email protected]', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-06-02 23:38:46', null, null, 'ManRoland', null, 'YF126', 'DIC', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('33', null, '[email protected]', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-06-02 23:39:00', null, null, 'ManRoland', null, 'YF126', 'DIC', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('34', null, '[email protected]', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-06-02 23:39:45', null, null, 'ManRoland', null, 'YF126', 'DIC', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('35', null, '[email protected]', null, null, null, '607-Samp1.txt', 'CRPC6', null, null, '0', '2015-06-02 23:40:07', null, null, 'ManRoland', null, 'YF126', 'DIC', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('36', null, '[email protected]', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-06-02 23:40:59', null, null, 'ManRoland', null, '120', 'DIC', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('37', null, '[email protected]', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-06-03 00:16:22', null, null, 'ManRoland', null, '120', 'DIC', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('38', null, '[email protected]', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-06-03 00:16:28', null, null, 'ManRoland', null, '120', 'DIC', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('39', null, '[email protected]', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-06-03 00:17:36', null, null, 'ManRoland', null, '120', 'DIC', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('40', null, '[email protected]', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-06-03 00:19:25', null, null, 'ManRoland', null, '120', 'DIC', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('41', null, '[email protected]', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-06-03 00:43:08', null, null, 'ManRoland', null, '120', 'DIC', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('42', null, '[email protected]', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-06-03 00:47:32', null, null, 'ManRoland', null, '120', 'DIC', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('43', null, '[email protected]', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-06-03 00:48:18', null, null, 'ManRoland', null, 'YF126', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('44', null, '[email protected]', null, null, null, '722-Samp1.txt', 'CRPC6', null, null, '0', '2015-06-03 00:48:42', null, null, 'ManRoland', null, 'YF126', 'DIC', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('45', null, '[email protected]', null, null, null, '820-Test1_M1.txt', 'CRPC6', null, null, '0', '2015-06-05 13:40:21', null, null, '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('46', null, '[email protected]', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-06-05 13:43:38', null, null, '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('47', null, '[email protected]', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-06-05 13:44:13', null, null, '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('48', null, '[email protected]', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-06-05 13:45:18', null, null, '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('49', null, '[email protected]', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-06-05 13:46:22', null, null, '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('50', null, '[email protected]', null, null, null, 'text-area', 'CRPC6', null, null, '0', '2015-06-11 13:53:22', null, null, '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('51', null, '[email protected]', null, null, null, '000-ControlTarget2.txt', 'CRPC6', null, null, '0', '2015-06-13 14:30:00', null, null, '', null, '', '', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('52', null, '[email protected]', null, null, null, '710-ControlTarget1.txt', 'CRPC6', null, null, '0', '2015-06-28 12:11:50', null, null, 'ManRoland', null, 'YF126', 'Comax', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('53', null, '[email protected]', null, null, null, '842-ControlTarget2.txt', 'CRPC6', null, null, '0', '2015-06-28 12:14:02', null, null, 'ManRoland', null, 'YF126', 'Comax', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('54', null, '[email protected]', null, null, null, '999-ControlTarget2.txt', 'CRPC6', null, null, '0', '2015-06-28 12:16:40', null, null, 'ManRoland', null, 'YF126', 'Comax', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('55', null, '[email protected]', null, null, null, '023-ControlTarget1.txt', 'CRPC6', null, null, '0', '2015-06-28 12:17:04', null, null, 'ManRoland', null, 'YF126', 'Comax', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('56', null, '[email protected]', null, null, null, '149-ControlTarget1.txt', 'CRPC6', 'test job 92', null, '0', '2015-06-28 12:19:09', null, null, 'ManRoland', null, 'YF126', 'Comax', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('57', null, '[email protected]', null, null, null, '883-ControlTarget1.txt', 'CRPC6', 'test job 92', null, '0', '2015-06-28 15:01:24', null, null, 'ManRoland', null, 'YF126', 'Comax', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null), ('58', null, '[email protected]', null, null, null, '493-ControlTarget1.txt', 'CRPC6', 'test job 92', null, '0', '2015-06-28 17:41:33', null, null, 'ManRoland', null, 'YF126', 'Comax', null, null, 'No', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;