/*
Navicat MySQL Data Transfer

Source Server         : fred
Source Server Version : 50141
Source Host           : 127.0.0.1:3306
Source Database       : tvicheck

Target Server Type    : MYSQL
Target Server Version : 50141
File Encoding         : 65001

Date: 2010-12-01 22:29:49
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `tvibase`
-- ----------------------------
DROP TABLE IF EXISTS `tvibase`;
CREATE TABLE `tvibase` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `company` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `score` double DEFAULT NULL,
  `date` date DEFAULT NULL,
  `device` varchar(255) DEFAULT NULL,
  `dsn` varchar(255) DEFAULT NULL,
  `printer` varchar(255) DEFAULT NULL,
  `paper` varchar(255) DEFAULT NULL,
  `ink` varchar(255) DEFAULT NULL,
  `rankbit` bit(1) DEFAULT NULL,
  `rank` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of tvibase
-- ----------------------------
INSERT INTO tvibase VALUES ('44', '', '', '', 'na', 'FograTVI_noPaper_ok.csv', null, '2010-12-01', null, null, null, null, null, null, null);
INSERT INTO tvibase VALUES ('45', '', '', '', 'na', 'FograTVI_noPaper_ok.csv', null, '2010-12-01', null, null, null, null, null, null, null);
INSERT INTO tvibase VALUES ('46', '', '', '', 'na', 'ColorPortTest_TVI.csv', null, '2010-12-01', null, null, null, null, null, null, null);
INSERT INTO tvibase VALUES ('47', '', '', '', 'na', 'ColorPortTest_TVI2.csv', null, '2010-12-01', null, null, null, null, null, null, null);
INSERT INTO tvibase VALUES ('48', '', '', '', 'na', '1390_MVTR_CCP_101201_ag0.csv', null, '2010-12-01', null, null, null, null, null, null, null);
INSERT INTO tvibase VALUES ('49', '', '', '', 'na', 'ColorPortTest_TVI2.csv', null, '2010-12-01', null, null, null, null, null, null, null);
INSERT INTO tvibase VALUES ('50', '', '', '', 'na', 'FograTVI_noPaper_ok.csv', null, '2010-12-01', null, null, null, null, null, null, null);
INSERT INTO tvibase VALUES ('51', '', '', '', 'na', '1390_MVTR_CCP_101201_ag0.csv', null, '2010-12-01', null, null, null, null, null, null, null);