--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/db/mkdb	Tue Feb 09 13:44:25 2010 +1030
@@ -0,0 +1,68 @@
+/*
+ * Create MySQL databases
+ * $Id: mkdb,v 1.3 2009/12/20 00:44:15 grog Exp grog $
+ */
+create database if not exists weather;
+use weather;
+create table if not exists observations
+(station_id char (16),
+ date date,
+ time time,
+ inside_humidity smallint null,                 /* humidity in percent */
+ inside_temp float null,                        /* inside temperature */
+ inside_dewpoint float null,                    /* inside dewpoint temperature */
+ outside_temp float null,                       /* outside temperature */
+ outside_dewpoint float null,                   /* outside dewpoint temperature */
+ apparent_temp float null,                      /* apparent outside temperature */
+ delta_t float null,                            /* delta to wet bulb temperature */
+ outside_humidity smallint null,                /* humidity in percent */
+ pressure_abs float null,                       /* absolute pressure, hPa */
+ pressure_msl float null,                       /* sea-level relative pressure, hPa */
+ pressure_qnh float null,                       /* qnh pressure, hPa */
+ visibility float null,
+ wind_direction float,                          /* wind direction, in 45° increments */
+ wind_direction_text char (6) null,             /* wind direction, text */
+ wind_speed float null,                         /* wind speed in km/h */
+ wind_gust float null,                          /* wind gust speed in km/h */
+ rain float null,                               /* rainfall in mm */
+ events text null,                              /* Not sure what this is */
+ conditions text null,                          /* Not sure what this is */
+ clouds text null,                              /* but what? */
+ primary key (date, time, station_id));
+create table if not exists remote_observations like observations;
+
+/* Time of last report for this station to this remote site */
+create table if not exists lastreport
+(station_id char (16),                          /* which station? */
+ report_id char (16),                           /* and which remote site? */
+ date timestamp,                                /* last report */
+ primary key (station_id, report_id)
+);
+
+/* Configuration */
+create table if not exists config
+( version int,                                  /* format version number */
+  latitude float,                               /* In ° */
+  longitude float,
+  elevation float,                              /* metres */
+  pressure_error float,                         /* difference between actual and real pressure, hPa */
+  poll_interval int,                            /* time, in seconds, between reading the device */
+  station_id char (16),                              /* this is the one we use for the database */
+  address text,                                 /* Address to display on web pages */
+  wunderground_station_id text,
+  wunderground_passwd text,
+  wunderground_report_interval int,             /* how many seconds between reports to Wunderground */
+  weatheforyou_station_id text,
+  weatheforyou_passwd text,
+  weatherforyou_report_interval int,            /* how many seconds between reports to Weather for you */
+  website_generation_interval int,              /* how many seconds between generating PHP header file */
+  db_host text,                                 /* database on this host */
+  db_user text,                                 /* user ID on host */
+  db_passwd text,                               /* and password */
+  db text,                                      /* database name */
+  db_table text,                                /* table */
+  sharefile text,                               /* shared segment file */
+  php_header text,                              /* php header file with weather data */
+  comparefile text,                              /* file to compare local weather stations */
+  primary key (station_id)  	      
+);