/*
MySQL Data Transfer
Source Host: localhost
Source Database: fograproof
Target Host: localhost
Target Database: fograproof
Date: 2014/4/18 �U�� 04:25:37
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for proofbasev3
-- ----------------------------
CREATE TABLE `proofbasev3` (
  `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) DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `filename` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `score` double DEFAULT NULL,
  `passbit` tinyint(1) DEFAULT '0',
  `date` date 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,
  `rip` varchar(255) DEFAULT NULL,
  `icc` varchar(255) DEFAULT NULL,
  `rankbit` tinyint(1) DEFAULT NULL,
  `rank` int(11) DEFAULT NULL,
  `onsite` varchar(255) DEFAULT 'No',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=980 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `proofbasev3` VALUES ('928', 'AC', 'Fred', '', 'AC-HPz3200', '', '203-0819x .csv', '68.523886891818', '0', '2013-08-21', 'i1', '', 'Z3200', 'HP', 'HP', 'Caldera', 'ArgyllCMS', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('972', 'YS', 'fred', '', null, '', '142-YS_140224-V3Proof.csv', '39.999457232765', '0', '2014-02-24', 'i1', '', '9890', 'Coated', '', 'StarProof', '', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('930', 'GW', 'Fred', '', 'GW KM6500', '', '212-GWKM2.csv', '53.399730333321', '0', '2013-08-22', 'i1', '', 'KM6500', 'Coated', 'KM', 'KM', 'Argyll', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('970', 'GW', 'Fred', '', null, '', '770-KM-2.csv', '35.361930500031', '0', '2014-01-16', 'i1', '', 'KM 6500', '100P特銅', 'KM', '', '', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('971', 'GW', 'Fred', '', null, '', '821-KM-2.csv', '35.361930500031', '0', '2014-01-16', 'i1', '', 'KM 6500', '100P特銅', 'KM', '', '', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('938', '', '', '', 'YF 9980', '', '643-839-YFx9890-tt.csv', '63.003632770436', '0', '2013-09-13', '', '', '', '', '', '', '', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('943', '', '', '', 'Xerox C100', '', '886-442-ProofV3testC-1000.csv', '61.565673117667', '0', '2013-09-13', '', '', '9880', 'Coated', 'Epson', 'Efi', '', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('962', 'Xerox', '', '', null, '', '225-XC1000.csv', '22.384080724713', '0', '2014-01-10', '', '', 'X560', '', '', '', '', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('951', '', '', '', 'GW', '', '051-GW1310.csv', '74.617621197257', '1', '2013-10-24', '', '', '', '', '', '', '', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('963', '', '', '', null, '', '819-J75.csv', '51.205942929247', '0', '2014-01-10', '', '', 'J75', '', '', '', '', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('964', '', '', '', null, '', '848-XC1000.csv', '22.384080724713', '0', '2014-01-10', '', '', 'C1000', '', '', '', '', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('965', '', '', '', null, '', '966-C1000.csv', '57.010647834919', '0', '2014-01-10', '', '', 'C1000', '', '', '', '', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('966', 'GW', 'Fred', '', null, '', '405-KM-1.csv', '42.36802785266', '0', '2014-01-16', 'i1', '', 'KM 6500', '', '', '', '', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('967', 'GW', 'Fred', '', null, '', '385-KM-2.csv', '35.361930500031', '0', '2014-01-16', 'i1', '', 'KM 6500', '100P特銅', 'KM', '', '', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('968', 'GW', 'Fred', '', null, '', '154-KM-2.csv', '35.361930500031', '0', '2014-01-16', 'i1', '', 'KM 6500', '100P特銅', 'KM', '', '', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('969', 'GW', 'Fred', '', null, '', '553-KM-2.csv', '35.361930500031', '0', '2014-01-16', 'i1', '', 'KM 6500', '100P特銅', 'KM', '', '', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('973', 'CCU', 'fred', '', null, '', '094-R290-1.txt', '-1265.3751550254', '0', '2014-03-27', 'i1', '', 'R290', '', '', '', '', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('974', 'CCU', 'fred', '', null, '', '247-R290-1.csv', '35.867376927977', '0', '2014-03-27', 'i1', '', 'R290', '', '', '', '', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('975', 'CCU', 'fred', '', null, '', '377-R290-2.csv', '28.482115258294', '0', '2014-03-27', 'i1', '', 'R290', '', '', '', '', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('976', 'Sser', 'fred', '', null, '', '699-EfiCMS.csv', '-833.32002165488', '0', '2014-04-08', 'i1', '', 'X700', '', '', 'Efi', 'Efi', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('977', 'Sser', 'fred', '', null, '', '785-EfiCMS.csv', '47.53761683102', '0', '2014-04-08', 'i1', '', 'X700', '', '', 'Efi', 'Efi', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('978', 'Sser', 'fred', '', null, '', '866-Argyll-1.csv', '22.643563433139', '0', '2014-04-08', 'i1', '', 'X700', '', '', 'Efi', 'Efi', '0', null, 'No');
INSERT INTO `proofbasev3` VALUES ('979', 'Sser', 'fred', '', null, '', '095-Argyll-F1.csv', '24.424054747246', '0', '2014-04-08', 'i1', '', 'X700', '', '', 'Efi', 'ARGYll', '0', null, 'No');