/*
MySQL Data Transfer
Source Host: localhost
Source Database: tvicheck-st
Target Host: localhost
Target Database: tvicheck-st
Date: 2014/9/3 �U�� 02:12:06
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for fplate
-- ----------------------------
CREATE TABLE `fplate` (
  `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,
  `po` varchar(255) DEFAULT NULL,
  `pt` varchar(255) DEFAULT NULL,
  `ctp` varchar(255) DEFAULT NULL,
  `size` varchar(255) DEFAULT NULL,
  `fStep` varchar(255) DEFAULT NULL,
  `dvTime` varchar(255) DEFAULT NULL,
  `dvTemp` varchar(255) DEFAULT NULL,
  `pNo` varchar(255) DEFAULT NULL,
  `filter` varchar(255) CHARACTER SET big5 DEFAULT NULL,
  `chem` varchar(255) DEFAULT NULL,
  `wash` varchar(255) DEFAULT NULL,
  `stf` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `cmmt` varchar(255) DEFAULT NULL,
  `score` double DEFAULT NULL,
  `passbit` tinyint(1) DEFAULT '0',
  `date` date DEFAULT NULL,
  `plog` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `SID` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `paper` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `T50` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `T25` varchar(255) DEFAULT NULL,
  `rankbit` tinyint(1) DEFAULT NULL,
  `rank` int(11) DEFAULT NULL,
  `onsite` varchar(255) DEFAULT 'No',
  `ip` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=814 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `fplate` VALUES ('810', null, '', null, null, '377.csv', null, 'Y', '88', '790', '5', '24', '22.8', '0', '????', '', '', '??', null, null, '0', '2014-09-01', 'CNPT1', '-0.000', '0.000', '175', '225', null, null, 'No', null);
INSERT INTO `fplate` VALUES ('809', null, '', null, null, '320-M-44444.csv', '44444', 'M', null, null, null, null, null, null, null, null, null, null, null, null, '0', '2014-08-21', 'CNPT1', '0.051', '0.051', '33.33', '300', null, null, 'No', null);
INSERT INTO `fplate` VALUES ('811', null, '', null, null, '377.csv', null, 'Y', '88', '790', '5', '24', '22.8', '', '????', '', '', '??', null, null, '0', '2014-09-01', 'CNPT1', '-0.000', '0.000', '175', '225', null, null, 'No', null);
INSERT INTO `fplate` VALUES ('812', null, '', null, null, '96.csv', null, 'M', '88', '790', '5', '24', '22.8', '121', '????', '', '', '??', null, null, '0', '2014-09-01', 'CNPT1', '0.937', '0.000', '90.86', '45.07', null, null, 'No', null);
INSERT INTO `fplate` VALUES ('813', null, '', null, null, '377.csv', null, 'Y', '88', '790', '5', '24', '22.8', '101', '更換濾心', '', '', '翠柳', null, null, '0', '2014-09-01', 'CNPT1', '-0.000', '0.000', '175', '225', null, null, 'No', null);