Open2300 - Bug Report 2007x 06x 03x 114621

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
Topic revision: r3 - 01 Dec 2007, KennethLavrsen
Copyright © 1999-2018 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
This website only use harmless session cookies. See Cookie Policy for details. By using this website you accept the use of these cookies.