/*
MySQL Data Transfer
Source Host: localhost
Source Database: tvicheck-st
Target Host: localhost
Target Database: tvicheck-st
Date: 2016/9/5 �W�� 07:10:37
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for platecv
-- ----------------------------
CREATE TABLE `platecv` (
  `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,
  `color` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `po` varchar(255) DEFAULT NULL,
  `cmmt` varchar(255) CHARACTER SET big5 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=810 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `platecv` VALUES ('806', '', '', '', '', '', null, '471-PlateCurveTT.txt', '100', '0', '2016-09-04', '', '', '', '', '', '0', null, 'No');
INSERT INTO `platecv` VALUES ('807', '', '', '', '', '', null, '634-PlateCurveTT.txt', '100', '0', '2016-09-05', '', '', '', '', '', '0', null, 'No');
INSERT INTO `platecv` VALUES ('808', '', '', '', '', '', null, '215-PlateCurveTT.txt', '100', '0', '2016-09-05', '', '', '', '', '', '0', null, 'No');
INSERT INTO `platecv` VALUES ('809', '', '', '', 'C', '', null, '611-PlateCurveTT.txt', '100', '0', '2016-09-05', '', '', '', '', '', '0', null, 'No');