BUG: MySQL Table Script

Due to changes in the SVN Tree, the create tablescript is outdated. Affected: mysql2300.sql, mysql2003.c

This one works for me.

CREATE TABLE `weather` (
  `datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `temp_in` decimal(3,1) NOT NULL default '0.0',
  `temp_out` decimal(3,1) NOT NULL default '0.0',
  `dewpoint` decimal(3,1) NOT NULL default '0.0',
  `rel_hum_in` tinyint(3) NOT NULL default '0',
  `rel_hum_out` tinyint(3) NOT NULL default '0',
  `wind_speed` decimal(3,1) NOT NULL default '0.0',
  `wind_angle` decimal(4,1) NOT NULL default '0.0',
  `wind_direction` char(3) NOT NULL default '',
  `wind_chill` decimal(3,1) NOT NULL default '0.0',
  `rain_1h` decimal(3,1) NOT NULL default '0.0',
  `rain_24h` decimal(3,1) NOT NULL default '0.0',
  `rain_total` decimal(5,1) NOT NULL default '0.0',
  `rel_pressure` decimal(5,1) NOT NULL default '0.0',
  `tendency` varchar(7) NOT NULL default '',
  `forecast` varchar(6) NOT NULL default '',
  UNIQUE KEY `timestamp` (`datetime`)
) TYPE=MyISAM;

Test case

Environment

Open2300 version:	1.11pre_svn030607
Shared libraries:	mysql
Server OS:	Debian Sarge

-- AlexW - 03 Jun 2007

Follow up

Fix record

This was fixed some time ago on Subversion. But the temperature fields needed to be 4,1 for the Fahrenheit guys.

-- KennethLavrsen - 01 Dec 2007