I think this is the most current table definition.

Table structure for table wx_data

CREATE TABLE wx_data (
station_id varchar(10) NOT NULL default ’ ',
date date NOT NULL default ‘0000-00-00’,
time time NOT NULL default ‘00:00:00’,
average_windspeed float NOT NULL default ‘0’,
wind_direction smallint(3) NOT NULL default ‘0’,
gust_windspeed float NOT NULL default ‘0’,
temperature float NOT NULL default ‘0’,
outdoor_humidity float NOT NULL default ‘0’,
barometer float NOT NULL default ‘0’,
daily_rainfall float NOT NULL default ‘0’,
monthly_rainfall float NOT NULL default ‘0’,
yearly_rainfall float NOT NULL default ‘0’,
rain_rate float NOT NULL default ‘0’,
max_rain_rate_curent_day float NOT NULL default ‘0’,
indoor_temperature float NOT NULL default ‘0’,
indoor_humidity float NOT NULL default ‘0’,
soil_temperature float NOT NULL default ‘0’,
forecast_icon int(3) NOT NULL default ‘0’,
wmr968_extra_temperature float NOT NULL default ‘0’,
wmr968_extra_humidity float NOT NULL default ‘0’,
wmr968_extra_sensor_number smallint(2) NOT NULL default ‘0’,
yesterday_rainfall float NOT NULL default ‘0’,
extra_temperature_sensor_2 float NOT NULL default ‘0’,
extra_temperature_sensor_3 float NOT NULL default ‘0’,
extra_temperature_sensor_4 float NOT NULL default ‘0’,
extra_temperature_sensor_5 float NOT NULL default ‘0’,
extra_temperature_sensor_6 float NOT NULL default ‘0’,
extra_temperature_sensor_7 float NOT NULL default ‘0’,
extra_humidity_2 float NOT NULL default ‘0’,
extra_humidity_3 float NOT NULL default ‘0’,
extra_humidity_4 float NOT NULL default ‘0’,
hour smallint(2) NOT NULL default ‘0’,
minute smallint(2) NOT NULL default ‘0’,
second smallint(2) NOT NULL default ‘0’,
station_name varchar(100) NOT NULL default ‘’,
dallas_1_wire_lightning_count int(11) NOT NULL default ‘0’,
actual_solar_reading int(11) NOT NULL default ‘0’,
day smallint(2) NOT NULL default ‘0’,
month smallint(2) NOT NULL default ‘0’,
wmr968_battery_level_1 smallint(3) NOT NULL default ‘0’,
wmr968_battery_level_2 smallint(3) NOT NULL default ‘0’,
wmr968_battery_level_3 smallint(3) NOT NULL default ‘0’,
wmr968_battery_level_4 smallint(3) NOT NULL default ‘0’,
wmr968_battery_level_5 smallint(3) NOT NULL default ‘0’,
wmr968_battery_level_6 smallint(3) NOT NULL default ‘0’,
wmr968_battery_level_7 smallint(3) NOT NULL default ‘0’,
current_windchill float NOT NULL default ‘0’,
current_humidex float NOT NULL default ‘0’,
max_daily_temperature float NOT NULL default ‘0’,
min_daily_temperature float NOT NULL default ‘0’,
icon_type smallint(3) NOT NULL default ‘0’,
current_weather_desc varchar(20) NOT NULL default ‘’,
barometer_trend_last_hour float NOT NULL default ‘0’,
max_gust_current_day float NOT NULL default ‘0’,
dew_point_temperature float NOT NULL default ‘0’,
cloud_height float NOT NULL default ‘0’,
max_humidex float NOT NULL default ‘0’,
min_humidex float NOT NULL default ‘0’,
max_windchill float NOT NULL default ‘0’,
min_windchill float NOT NULL default ‘0’,
davis_vp_uv float NOT NULL default ‘0’,
max_heat_index float NOT NULL default ‘0’,
min_heat_index float NOT NULL default ‘0’,
heat_index float NOT NULL default ‘0’,
max_average_windspeed_day float NOT NULL default ‘0’,
UNIQUE KEY station_id (station_id,date,time)
) TYPE=MyISAM COMMENT=‘wx_data from Weather Display’;

Mike - N7DQ