/*
MySQL Data Transfer
Source Host: MACBOOKPRO\SQLEXPRESS
Source Database: fograproof
Target Host: MACBOOKPRO\SQLEXPRESS
Target Database: fograproof
Date: 2011/2/9 �U�� 02:48:42
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for proofbase
-- ----------------------------
CREATE TABLE `proofbase` (
  `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,
  `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=154 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `proofbase` VALUES ('148', 'inhousePOD.com', 'Fred', '[email protected]', '', 'EP4880_EPI_EZS_101215_F46-Lab.txt', '87.730969477642', '1', '2011-01-11', 'Eye-One', '34221', 'Epson 4880', 'EZS', 'MVK', null, null, '1', null, 'No');
INSERT INTO `proofbase` VALUES ('152', '', '', '', '', '', '87.730969477642', '1', '2011-01-14', '', '', '', '', '', null, null, '0', null, 'No');
INSERT INTO `proofbase` VALUES ('153', '', '', '', '', 'EP4880_MVK_CCP_Heat_110113-lab.txt', '82.837121471297', '1', '2011-01-14', 'Eye-One', '', '', '', '', '', '', '0', null, 'No');