1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
|
CREATE TABLE `MaCentrale` (
`releve_id` int(11) NOT NULL AUTO_INCREMENT,
`onduleur_id` varchar(255) NOT NULL,
`pac` varchar(255) NOT NULL,
`iac` varchar(255) NOT NULL,
`vac` varchar(255) NOT NULL,
`pcc1` varchar(255) NOT NULL,
`pcc2` varchar(255) NOT NULL,
`ucc1` varchar(255) NOT NULL,
`icc1` varchar(255) NOT NULL,
`ucc2` varchar(255) NOT NULL,
`icc2` varchar(255) NOT NULL,
`edaily` varchar(255) NOT NULL,
`eweekly` varchar(255) NOT NULL,
`emonth` varchar(255) NOT NULL,
`eyear` varchar(255) NOT NULL,
`etotal` varchar(255) NOT NULL,
`epartial` varchar(255) NOT NULL,
`date` datetime NOT NULL,
`date_insert` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`file` varchar(255) NOT NULL,
PRIMARY KEY (`releve_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20249 ;
--
-- Contenu de la table `MaCentrale`
--
INSERT INTO `MaCentrale` VALUES(10236, '225587', '5935.91', '7.867', '239.466', '3949.215', '2103.288', '533.96', '7.245', '514.954', '4.062', '17759', '0', '0', '0', '0', '0', '2011-07-28 12:10:00', '2011-08-07 05:19:42', 'MaCentrale_INV_1_1_110728_103020.csv.gz');
INSERT INTO `MaCentrale` VALUES(10237, '225587', '4761.839', '6.215', '240.096', '3167.993', '1675.513', '548.267', '5.668', '534.857', '3.128', '18490', '0', '0', '0', '0', '0', '2011-07-28 12:20:00', '2011-08-07 05:19:42', 'MaCentrale_INV_1_1_110728_103020.csv.gz');
INSERT INTO `MaCentrale` VALUES(10238, '225587', '4895.292', '6.422', '239.789', '3293.91', '1686.46', '542.218', '6.04', '532.292', '3.17', '19356', '0', '0', '0', '0', '0', '2011-07-28 12:30:00', '2011-08-07 05:19:42', 'MaCentrale_INV_1_1_110728_103020.csv.gz');
INSERT INTO `MaCentrale` VALUES(10239, '240977', '6187.081', '8.083', '239.407', '4104.207', '2207.123', '556.7', '7.032', '538.528', '4.043', '18468', '0', '0', '0', '0', '0', '2011-07-28 12:10:00', '2011-08-07 05:19:42', 'MaCentrale_INV_1_1_110728_103020.csv.gz');
INSERT INTO `MaCentrale` VALUES(10240, '240977', '5086.869', '6.542', '239.938', '3390.576', '1780.113', '563.993', '5.868', '556.544', '3.171', '19293', '0', '0', '0', '0', '0', '2011-07-28 12:20:00', '2011-08-07 05:19:42', 'MaCentrale_INV_1_1_110728_103020.csv.gz'); |
Partager