#
# Table structure for table `stationdata`
#

CREATE TABLE stationdata (
  timekey int(11) NOT NULL default '0',
  station varchar(9) NOT NULL default '',
  year smallint(6) NOT NULL default '0',
  month tinyint(4) NOT NULL default '0',
  mday tinyint(4) NOT NULL default '0',
  hour tinyint(4) NOT NULL default '0',
  min tinyint(4) NOT NULL default '0',
  temperature double default NULL,
  temperature_inside double default NULL,
  barometer double default NULL,
  humidity tinyint(4) default NULL,
  humidity_inside tinyint(4) default NULL,
  windspeed double default NULL,
  winddir double default NULL,
  windgust double default NULL,
  windgustdir double default NULL,
  solar double default NULL,
  uv double default NULL,
  bartrend varchar(15) default NULL,
  rainrate double default NULL,
  stormrain double default NULL,
  stormdate varchar(10) default NULL,
  rainday double default NULL,
  rainmonth double default NULL,
  rainyear double default NULL,
  consbat float default NULL,
  transbat float default NULL,
  forecasticons int(11) default NULL,
  forecastrule int(11) default NULL,
  sunrise varchar(6) default NULL,
  sunset varchar(6) default NULL,
  PRIMARY KEY  (timekey,station)
) TYPE=MyISAM;