/*
MySQL Data Transfer
Source Host: localhost
Source Database: tvicheck-st
Target Host: localhost
Target Database: tvicheck-st
Date: 2016/1/11 �U�� 05:11:19
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for cc24
-- ----------------------------
CREATE TABLE `cc24` (
  `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,
  `cmmt` varchar(255) CHARACTER SET big5 DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `filename` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `iccname` varchar(255) 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,
  `rankbit` tinyint(1) DEFAULT NULL,
  `rank` int(11) DEFAULT NULL,
  `onsite` varchar(255) DEFAULT 'No',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=731 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `cc24` VALUES ('730', 'JIYI', 'Fred', '', null, 'PhaseOne', '730-CC24', '730-PhaseOneTT.icm', '81.11', '0', '2016-01-11', '', '', '0', null, 'No');
INSERT INTO `cc24` VALUES ('725', 'JIYI', 'Fred', '', null, 'PhaseOne', '725-Cx24', '725-PhaseOneTT.icm', '-1588.09', '0', '2016-01-11', '', '', '0', null, 'No');
INSERT INTO `cc24` VALUES ('726', 'JIYI', 'Fred', '', null, 'PhaseOne', '726-Cx24', '726-PhaseOneTT.icm', '80.28', '0', '2016-01-11', '', '', '0', null, 'No');
INSERT INTO `cc24` VALUES ('727', 'JIYI', 'Fred', '', null, 'PhaseOne', '727-Cx24', '727-PhaseOneTT.icm', '80.28', '0', '2016-01-11', '', '', '0', null, 'No');
INSERT INTO `cc24` VALUES ('728', 'JIYI', 'Fred', '', null, 'PhaseOne', '728-Cx24', '728-PhaseOneD50_141230.icc', '-2.78', '0', '2016-01-11', '', '', '0', null, 'No');
INSERT INTO `cc24` VALUES ('729', 'JIYI', 'Fred', '', null, 'PhaseOne', '729-CC24', '729-PhaseOneD50_141230.icc', '-1.98', '0', '2016-01-11', '', '', '0', null, 'No');