/*
MySQL Data Transfer
Source Host: localhost
Source Database: tvicheck
Target Host: localhost
Target Database: tvicheck
Date: 2011/1/7 �U�� 05:27:40
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for tvibase
-- ----------------------------
CREATE TABLE `tvibase` (
  `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,
  `rankbit` tinyint(1) DEFAULT NULL,
  `rank` int(11) DEFAULT NULL,
  `onsite` varchar(255) DEFAULT 'No',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=82 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `tvibase` VALUES ('80', 'XX3公司', 'Fred', '[email protected]', '', '1390_MVTR_CCP_101201_ag0.csv', '44.24', '0', '2010-12-22', 'Eye-One', '339082', 'Speedmaster XL 105', 'YFS', 'cervo', '1', null, 'No');
INSERT INTO `tvibase` VALUES ('81', '', '', '', '', '1390_CT4_YFS_101202_ag0.csv', '49.86', '0', '2010-12-23', 'Eye-One', '', '', '', '', '0', null, 'No');
INSERT INTO `tvibase` VALUES ('78', 'XX1公司', 'Fred', '[email protected]', '', 'FograTVI_noPaper_ok.csv', '51.32', '1', '2010-12-22', 'Eye-One', '34221', 'Speedmaster XL 105', 'CCP', 'Sun Chemical', '1', null, 'No');
INSERT INTO `tvibase` VALUES ('79', 'XX2公司', 'Jack', '[email protected]', '', 'ColorPortTest_TVI2.csv', '36.6', '0', '2010-12-22', 'Eye-One', '34221', 'Speedmaster XL 105', 'CCP', 'Sun Chemical', '1', null, 'No');