/*
 * Create MySQL config
 * Edit to appropriate values before running.
 * $Id: mkdb,v 1.3 2009/12/20 00:44:15 grog Exp grog $
 */
insert into config
( version,                                      /* format version number */
  latitude,                                     /* In ° */
  longitude,
  elevation,                                    /* metres */
  pressure_error,                               /* difference between actual and real, hPa */
  poll_interval,
  station_id,                                   /* this is the one we use for the database */
  address,                                      /* Address to display on web pages */
  wunderground_station_id,
  wunderground_passwd,
  wunderground_report_interval,                 /* how many seconds between reports to Wunderground */
  weatheforyou_station_id,
  weatheforyou_passwd,
  weatherforyou_report_interval,                /* how many seconds between reports to Weather for you */
  website_generation_interval,                  /* how many seconds between generating PHP header file */
  db_host,                                      /* database on this host */
  db_user,                                      /* user ID on host */
  db_passwd,                                    /* and password */
  db,                                           /* database name */
  db_table,                                     /* table */
  php_header,                                   /* php header file with weather data */
  comparefile)                                  /* file to compare local weather stations */
values (
  /* version */ 1,                          /* don't change this */
  /* latitude */ -37.8185,
  /* longitude */ 143.739473,
  /* elevation */ 340,                       /* elevation of the station in metres */
  /* pressure_error */ -13.5,                /* offset of pressure measurements, hPa */
  /* poll_interval */ 60,                    /* poll once a minute */
  /* station_id */ "MYID",
  /* address */ "MYADDRESS",
  /* wunderground_station_id */ "MYID",
  /* wunderground_passwd */ "insecure",
  /* wunderground_report_interval */ 300,    /* how many seconds between reports to Wunderground */
  /* weatheforyou_station_id */ "",
  /* weatheforyou_passwd */ "",
  /* weatherforyou_report_interval */ 300,   /* how many seconds between reports to Weather for you */
  /* website_generation_interval */ 60,      /* how many seconds between generating PHP header file */
  /* db_host */ "dereel.lemis.com",
  /* db_user */ "grog",
  /* db_passwd */ "",
  /* db */ "weather",
  /* db_table */ "observations",
  /* php_header */ "/home/grog/public_html/weather/current.php",
  /* comparefile */ "/home/grog/public_html/weather/BoM-compare"
);


insert into config
( version,                                      /* format version number */
  latitude,                                     /* In ° */
  longitude,
  elevation,                                    /* metres */
  pressure_error,                               /* difference between actual and real, hPa */
  poll_interval,                                /* between reading the device */
  station_id,                                   /* this is the one we use for the database */
  address,                                      /* Address to display on web pages */
  wunderground_station_id,
  wunderground_passwd,
  wunderground_report_interval,                 /* how many seconds between reports to Wunderground */
  weatheforyou_station_id,
  weatheforyou_passwd,
  weatherforyou_report_interval,                /* how many seconds between reports to Weather for you */
  website_generation_interval,                  /* how many seconds between generating PHP header file */
  db_table,                                     /* table */
  php_header,                                   /* php header file with weather data */
  comparefile)                                  /* file to compare local weather stations */
values (
  /* version */ 1,                          /* don't change this */
  /* latitude */ -37.8185,
  /* longitude */ 143.739473,
  /* elevation */ 340,                       /* elevation of the station in metres */
  /* pressure_error */ -13.5,                /* offset of pressure measurements, hPa */
  /* poll_interval */ 60,                    /* poll once a minute */
  /* station_id */ "Dereel",
  /* address */ "Dereel, Victoria, Australia",
  /* wunderground_station_id */ "IVICTORI124",
  /* wunderground_passwd */ "breached",
  /* wunderground_report_interval */ 300,    /* how many seconds between reports to Wunderground */
  /* weatheforyou_station_id */ "",
  /* weatheforyou_passwd */ "",
  /* weatherforyou_report_interval */ 300,   /* how many seconds between reports to Weather for you */
  /* website_generation_interval */ 60,      /* how many seconds between generating PHP header file */
  /* db_table */ "observations",
  /* php_header */ "/home/grog/public_html/weather/current.php",
  /* comparefile */ "/home/grog/public_html/weather/BoM-compare",
);