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/PBN/PSAinstrument/
Upload Files
File: C:/xampp/htdocs/PBN/PSAinstrument/psainstrument.sql
/*
MySQL Data Transfer
Source Host: localhost
Source Database: tvicheck-st
Target Host: localhost
Target Database: tvicheck-st
Date: 2014/8/5 �U�� 09:51:34
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for psainstrument
-- ----------------------------
CREATE TABLE `psainstrument` (
  `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,
  `cmmt` varchar(255) CHARACTER SET big5 DEFAULT NULL,
  `filename` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `fileP` varchar(255) DEFAULT NULL,
  `score` double DEFAULT NULL,
  `passbit` tinyint(1) DEFAULT '0',
  `ddate` date DEFAULT NULL,
  `instr1` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `instr2` varchar(255) DEFAULT NULL,
  `sn1` varchar(255) DEFAULT NULL,
  `sn2` varchar(255) 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',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1149 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `psainstrument` VALUES ('1090', '', 'Fred', null, null, null, '165-ControlTarget_v2-it4.txt', '165-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1091', '', 'Fred', null, null, null, '239-ControlTarget_v2-it4.txt', '239-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1092', '', 'Fred', null, null, null, '878-ControlTarget_v2-it4.txt', '878-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1093', '', 'Fred', null, null, null, '925-ControlTarget_v2-it4.txt', '925-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1094', '', 'Fred', null, null, null, '142-ControlTarget_v2-it4.txt', '142-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1095', '', 'Fred', null, null, null, '205-ControlTarget_v2-it4.txt', '205-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1096', '', 'Fred', null, null, null, '273-ControlTarget_v2-it4.txt', '273-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1097', '', 'Fred', null, null, null, '345-ControlTarget_v2-it4.txt', '345-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1098', '', 'Fred', null, null, null, '393-ControlTarget_v2-it4.txt', '393-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1099', '', 'Fred', null, null, null, '623-ControlTarget_v2-it4.txt', '623-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1100', '', 'Fred', null, null, null, '653-ControlTarget_v2-it4.txt', '653-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1101', '', 'Fred', null, null, null, '686-ControlTarget_v2-it4.txt', '686-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1102', '', 'Fred', null, null, null, '933-ControlTarget_v2-it4.txt', '933-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1103', '', 'Fred', null, null, null, '645-ControlTarget_v2-it4.txt', '645-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1104', '', 'Fred', null, null, null, '016-ControlTarget_v2-it4.txt', '016-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1105', '', 'Fred', null, null, null, '193-ControlTarget_v2-it4.txt', '193-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1106', '', 'Fred', null, null, null, '337-ControlTarget_v2-it4.txt', '337-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1107', '', 'Fred', null, null, null, '425-ControlTarget_v2-it4.txt', '425-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1108', '', 'Fred', null, null, null, '464-ControlTarget_v2-it4.txt', '464-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1109', '', 'Fred', null, null, null, '490-ControlTarget_v2-it4.txt', '490-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1110', '', 'Fred', null, null, null, '024-ControlTarget_v2-it4.txt', '024-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1111', '', 'Fred', null, null, null, '684-ControlTarget_v2-it4.txt', '684-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1112', '', 'Fred', null, null, null, '764-ControlTarget_v2-it4.txt', '764-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1113', '', 'Fred', null, null, null, '902-ControlTarget_v2-it4.txt', '902-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1114', '', 'Fred', null, null, null, '965-ControlTarget_v2-it4.txt', '965-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1115', '', 'Fred', null, null, null, '032-ControlTarget_v2-it4.txt', '032-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1116', '', 'Fred', null, null, null, '148-ControlTarget_v2-it4.txt', '148-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1117', '', 'Fred', null, null, null, '215-ControlTarget_v2-it4.txt', '215-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1118', '', 'Fred', null, null, null, '361-ControlTarget_v2-it4.txt', '361-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1119', '', 'Fred', null, null, null, '550-ControlTarget_v2-it4.txt', '550-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1120', '', 'Fred', null, null, null, '797-ControlTarget_v2-it4.txt', '797-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1121', '', 'Fred', null, null, null, '914-ControlTarget_v2-it4.txt', '914-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1122', '', 'Fred', null, null, null, '116-ControlTarget_v2-it4.txt', '116-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1123', '', 'Fred', null, null, null, '209-ControlTarget_v2-it4.txt', '209-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1124', '', 'Fred', null, null, null, '333-ControlTarget_v2-it4.txt', '333-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1125', '', 'Fred', null, null, null, '363-ControlTarget_v2-it4.txt', '363-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1126', '', 'Fred', null, null, null, '398-ControlTarget_v2-it4.txt', '398-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1127', '', 'Fred', null, null, null, '422-ControlTarget_v2-it4.txt', '422-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1128', '', 'Fred', null, null, null, '463-ControlTarget_v2-it4.txt', '463-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1129', '', 'Fred', null, null, null, '493-ControlTarget_v2-it4.txt', '493-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1130', '', 'Fred', null, null, null, '475-ControlTarget_v2-it4.txt', '475-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-30', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1131', '', 'Fred', null, null, null, '566-ControlTarget_v2-it4.txt', '566-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-30', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1132', '', 'Fred', null, null, null, '630-ControlTarget_v2-it4.txt', '630-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-30', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1133', '', 'Fred', null, null, null, '636-ControlTarget_v2-it4.txt', '636-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-30', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1134', '', 'Fred', null, null, null, '672-ControlTarget_v2-it4.txt', '672-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-30', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1135', '', 'Fred', null, null, null, '733-ControlTarget_v2-it4.txt', '733-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-30', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1136', '', 'Fred', null, null, null, '763-ControlTarget_v2-it4.txt', '763-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-30', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1137', '', 'Fred', null, null, null, '844-ControlTarget_v2-it4.txt', '844-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-30', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1138', '', 'Fred', null, null, null, '899-ControlTarget_v2-it4.txt', '899-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-30', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1139', '', 'Fred', null, null, null, '641-ControlTarget_v4-CP.txt', '641-ControlTarget_v4-CPx2.txt', null, '0', '2014-07-30', 'i1Pro', 'i1Pro', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1140', '', 'Fred', null, null, null, '791-ControlTarget_v4-CP.txt', '791-ControlTarget_v4-CPx2.txt', null, '0', '2014-07-30', 'i1Pro', 'i1Pro', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1141', '', 'Fred', null, null, null, '394-ControlTarget_v4-CP.txt', '394-ControlTarget_v4-CPx2.txt', null, '0', '2014-07-30', 'i1Pro', 'i1Pro', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1142', '', 'Fred', null, null, null, '617-ControlTarget_v4-CP.txt', '617-ControlTarget_v4-CPx2.txt', null, '0', '2014-07-30', 'i1Pro', 'i1Pro', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1143', '', 'Fred', null, null, null, '682-ControlTarget_v2-it4.txt', '682-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-30', 'i1Pro', 'i1Pro', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1144', '', 'Fred', null, null, null, '762-ControlTarget_v2-it4.txt', '762-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-30', 'i1Pro', 'i1Pro', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1145', '', 'Fred', null, null, null, '835-ControlTarget_v2-it4.txt', '835-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-30', 'i1Pro', 'i1Pro', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1088', '', 'Fred', null, null, null, '519-ControlTarget_v2-it4.txt', '519-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1089', '', 'Fred', null, null, null, '992-ControlTarget_v2-it4.txt', '992-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-29', 'i1', 'i1', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1146', '', 'Fred', null, null, null, '975-ControlTarget_v2-it4.txt', '975-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-30', 'i1Pro', 'i1Pro', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1147', '', 'Fred', null, null, null, '061-ControlTarget_v2-it4.txt', '061-ControlTarget_v2-it4x2.txt', null, '0', '2014-07-30', 'i1Pro', 'i1Pro', '1234-1', '1234-2', '', 'ManRoland', '敦榮156', 'Xerox', null, null, 'No');
INSERT INTO `psainstrument` VALUES ('1148', '', 'Fred', null, null, null, '313-CRN705509.txt', '313-CRN879289.txt', null, '0', '2014-07-30', 'i1Pro', 'i1Pro', '705509', '879289', '', 'ManRoland', 'YF126', 'DIC', null, null, 'No');
@ Telegram