diff options
author | martin <martin> | 2004-11-11 19:41:46 +0000 |
---|---|---|
committer | martin <martin> | 2004-11-11 19:41:46 +0000 |
commit | 1e0285046a39d882662204b71efe6184ea009dca (patch) | |
tree | 71195ada90522888b9d36141d0c411333014ad5d /misc | |
parent | 7407ed9989db5098b1ec2bceba342c030a771761 (diff) | |
download | pkgsrc-1e0285046a39d882662204b71efe6184ea009dca.tar.gz |
Homogenize the two suggested database structures.
Diffstat (limited to 'misc')
-rw-r--r-- | misc/open2300-mysql/MESSAGE | 38 |
1 files changed, 19 insertions, 19 deletions
diff --git a/misc/open2300-mysql/MESSAGE b/misc/open2300-mysql/MESSAGE index 845e6032a17..d89861e1e92 100644 --- a/misc/open2300-mysql/MESSAGE +++ b/misc/open2300-mysql/MESSAGE @@ -1,5 +1,5 @@ =========================================================================== -$NetBSD: MESSAGE,v 1.2 2004/11/10 10:38:18 wiz Exp $ +$NetBSD: MESSAGE,v 1.3 2004/11/11 19:41:46 martin Exp $ Before you can use this program, you need to configure the MySQL connection in the open2300.conf file. The mysql user used by the @@ -35,29 +35,29 @@ needs to be compatible. This alternative structure (for newer MySQL versions) works as well: CREATE TABLE `weather` ( - `id` datetime NOT NULL default '0000-00-00 00:00:00', - `day` date NOT NULL default '0000-00-00', - `clock` time NOT NULL default '00:00:00', - `tempin` float NOT NULL default '0', - `tempout` float NOT NULL default '0', + `timestamp` datetime NOT NULL default '0000-00-00 00:00:00', + `rec_date` date NOT NULL default '0000-00-00', + `rec_time` time NOT NULL default '00:00:00', + `temp_in` float NOT NULL default '0', + `temp_out` float NOT NULL default '0', `dewpoint` float NOT NULL default '0', - `humin` int(11) NOT NULL default '0', - `humout` int(11) NOT NULL default '0', + `rel_hum_in` int(11) NOT NULL default '0', + `rel_hum_out` int(11) NOT NULL default '0', `windspeed` float NOT NULL default '0', - `winddir` float NOT NULL default '0', - `windcode` enum('N','NNE','NE','ENE','E','ESE','SE','SSE','S','SSW','SW','WSW','W','WNW','NW','NNW') character set ascii NOT NULL default 'N', - `windchill` float NOT NULL default '0', - `rain1` float NOT NULL default '0', - `rain24` float NOT NULL default '0', - `raintotal` float NOT NULL default '0', - `pressure` float NOT NULL default '0', - `tendency` enum('Steady','Rising','Falling') character set ascii NOT NULL default 'Steady', - `forecast` enum('Rainy','Cloudy','Sunny') character set ascii NOT NULL default 'Rainy', - PRIMARY KEY (`id`) + `wind_angle` float NOT NULL default '0', + `wind_direction` enum('N','NNE','NE','ENE','E','ESE','SE','SSE','S','SSW','SW','WSW','W','WNW','NW','NNW') NOT NULL default 'N', + `wind_chill` float NOT NULL default '0', + `rain_1h` float NOT NULL default '0', + `rain_24h` float NOT NULL default '0', + `rain_total` float NOT NULL default '0', + `rel_pressure` float NOT NULL default '0', + `tendency` enum('Steady','Rising','Falling') NOT NULL default 'Steady', + `forecast` enum('Rainy','Cloudy','Sunny') NOT NULL default 'Rainy', + PRIMARY KEY (`timestamp`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Weather as reported by WS 2300'; - + The program will not output anything, unless errors occur. This makes it easy to use it in cron jobs. |