/*
MySQL Data Transfer
Source Host: localhost
Source Database: tvicheck-st
Target Host: localhost
Target Database: tvicheck-st
Date: 2024/5/7 �U�� 01:39:14
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for lightdb
-- ----------------------------
CREATE TABLE `lightdb` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `company` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `dns` varchar(20) DEFAULT NULL,
  `contact` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `sn` 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,
  `CCT` int(11) DEFAULT NULL,
  `Lux` double DEFAULT NULL,
  `SSI` int(11) DEFAULT NULL,
  `ddate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2207 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `lightdb` VALUES ('2199', 'crony', null, null, null, '1051700', 'ppo', null, 'ppo-06-08-230041.txt', '4353', '194.182', '71', '2024-05-07 11:30:56');
INSERT INTO `lightdb` VALUES ('2205', 'pbndemo', null, null, null, '1051700', 'ppo', null, 'ppo-just.txt', '4715', '1754.81', '86', '2024-05-07 13:06:07');
INSERT INTO `lightdb` VALUES ('2198', 'crony', null, null, null, '1051700', 'ppo', null, 'ppo-just.txt', '4715', '1754.81', '86', '2024-05-07 00:00:00');