Thanks mate, no panic. Im sure you have plenty of more important things to do. I found the code on an old post here somewhere
CREATE TABLE IF NOT EXISTS wx_data
(
time
time NOT NULL DEFAULT ‘00:00:00’,
date
date NOT NULL DEFAULT ‘0000-00-00’,
mintemp
float NOT NULL DEFAULT ‘0’,
maxtemp
float NOT NULL DEFAULT ‘0’,
temperature
float NOT NULL DEFAULT ‘0’,
average_windspeed
float NOT NULL DEFAULT ‘0’,
wind_direction
float NOT NULL DEFAULT ‘0’,
gust_windspeed
float NOT NULL DEFAULT ‘0’,
UV
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’,
hourly_rainfall
float NOT NULL DEFAULT ‘0’,
rain_rate
float NOT NULL DEFAULT ‘0’,
max_rain_rate_curent_day
float NOT NULL DEFAULT ‘0’,
monthtodatemaxtemp
float NOT NULL DEFAULT ‘0’,
monthtodatemintemp
float NOT NULL DEFAULT ‘0’,
day_hours
varbinary(20) NOT NULL DEFAULT ‘0’,
forecast_icon
float NOT NULL DEFAULT ‘0’,
yesterday_rainfall
float NOT NULL DEFAULT ‘0’,
extra_temperature_sensor_1
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_temperature_sensor_8
float NOT NULL DEFAULT ‘0’,
extra_temperature_sensor_9
float NOT NULL DEFAULT ‘0’,
extra_temperature_sensor_10
float NOT NULL DEFAULT ‘0’,
extra_humidity_1
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’,
actual_solar_reading
float NOT NULL DEFAULT ‘0’,
current_windchill
float NOT NULL DEFAULT ‘0’,
current_humidex
float NOT NULL DEFAULT ‘0’,
current_weather_desc
float NOT NULL DEFAULT ‘0’,
barometer_trend_last_hour
varchar(20) NOT NULL DEFAULT ‘0’,
todaywindrun
float NOT NULL DEFAULT ‘0’,
max_gust_current_day
float NOT NULL DEFAULT ‘0’,
dew_point_temperature
varchar(20) NOT NULL DEFAULT ‘0’,
cloud_height
float NOT NULL DEFAULT ‘0’,
current_heatindex
float NOT NULL DEFAULT ‘0’,
soil_moist
float NOT NULL DEFAULT ‘0’,
leaf_moist
float NOT NULL DEFAULT ‘0’,
lightning_last_hour
float NOT NULL DEFAULT ‘0’,
temp_change_last_hour
varchar(20) NOT NULL DEFAULT ‘0’,
UNIQUE KEY Index
(date
,time
)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT=‘wx_data from Weather Display’;