OK, je t'ai transmis ça par mail.
Code : Tout sélectionner
CREATE TABLE `data` (
`tstamp` bigint(20) NOT NULL,
`recdateUTC` bigint(20) DEFAULT NULL,
`recdateTZ` bigint(20) DEFAULT NULL,
`archiveInterval` tinyint(4) DEFAULT NULL,
`winddir` double DEFAULT NULL,
`windspeed` double DEFAULT NULL,
`windgust` double DEFAULT NULL,
`indoorhumidity` double DEFAULT NULL,
`outdoorhumidity` double DEFAULT NULL,
`indoortemperature` double DEFAULT NULL,
`outdoortemperature` double DEFAULT NULL,
`hioutdoortemperature` double DEFAULT NULL,
`lowoutdoortemperature` double DEFAULT NULL,
`barometricpressure` double DEFAULT NULL,
`evapotranspiration` double DEFAULT NULL,
`uvindex` double DEFAULT NULL,
`solarradiation` double DEFAULT NULL,
`windchill` double DEFAULT NULL,
`indoorheatindex` double DEFAULT NULL,
`outdoorheatindex` double DEFAULT NULL,
`dewpoint` double DEFAULT NULL,
`frostpoint` double DEFAULT NULL,
`sealevelpressure` double DEFAULT NULL,
`barometer3H` double DEFAULT NULL,
`pressurealtitude` double DEFAULT NULL,
`cloudbase` double DEFAULT NULL,
`airdensity` double DEFAULT NULL,
`virtualtemperature` double DEFAULT NULL,
`vaporpressure` double DEFAULT NULL,
`windrun` double DEFAULT NULL,
`windrundaily` double DEFAULT NULL,
`windrunmonthly` double DEFAULT NULL,
`windrunyearly` double DEFAULT NULL,
`moonphase` double DEFAULT NULL,
`daily_ET` double DEFAULT NULL,
`daily_UV` double DEFAULT NULL,
`daily_SolarRad` double DEFAULT NULL,
`instantrain` double DEFAULT NULL,
`rain_hourly` double DEFAULT NULL,
`rain_daily` double DEFAULT NULL,
`last24hrrain` double DEFAULT NULL,
`rain_monthly` double DEFAULT NULL,
`rain_yearly` double DEFAULT NULL,
`rain_total` double DEFAULT NULL,
`rainrate` double DEFAULT NULL,
`hiuv` double DEFAULT NULL,
`hisolarrad` double DEFAULT NULL,
`hiTHSW` double DEFAULT NULL,
`lowTHSW` double DEFAULT NULL,
`hiTHW` double DEFAULT NULL,
`lowTHW` double DEFAULT NULL,
`degdaysheating` double DEFAULT NULL,
`degdayscooling` double DEFAULT NULL,
`degdaysheatingdaily` double DEFAULT NULL,
`degdayscoolingdaily` double DEFAULT NULL,
`degdaysheatingmonthly` double DEFAULT NULL,
`degdayscoolingmonthly` double DEFAULT NULL,
`degdaysheatingyearly` double DEFAULT NULL,
`degdayscoolingyearly` double DEFAULT NULL,
`ch1temperature` double DEFAULT NULL,
`ch1humidity` double DEFAULT NULL,
`ch2temperature` double DEFAULT NULL,
`ch2humidity` double DEFAULT NULL,
`ch3temperature` double DEFAULT NULL,
`ch3humidity` double DEFAULT NULL,
`soil1temperature` double DEFAULT NULL,
`soil1moisture` double DEFAULT NULL,
`leaf1Wetness` double DEFAULT NULL,
`soil2temperature` double DEFAULT NULL,
`soil2moisture` double DEFAULT NULL,
`leaf2Wetness` double DEFAULT NULL,
`soil3temperature` double DEFAULT NULL,
`soil3moisture` double DEFAULT NULL,
`leaf3Wetness` double DEFAULT NULL,
`soil4temperature` double DEFAULT NULL,
`soil4moisture` double DEFAULT NULL,
`leaf4Wetness` double DEFAULT NULL,
`Unused` double DEFAULT NULL,
PRIMARY KEY (`tstamp`),
KEY `minimaxi_tz` (`recdateTZ`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;