Hi to all... I had to tweak the default weatherdump.sql file supplied so as that all fields would display correctly...
I'm using open2300 1.10 and the default SQL supplied with Ubuntu Hardy here is what I have... CREATE TABLE `weather` ( `timestamp` bigint(14) NOT NULL default '0', `rec_date` date NOT NULL default '0000-00-00', `rec_time` time NOT NULL default '00:00:00', `temp_in` decimal(4,1) NOT NULL default '0.0', `temp_out` decimal(4,1) NOT NULL default '0.0', `dewpoint` decimal(4,1) NOT NULL default '0.0', `rel_hum_in` tinyint(3) NOT NULL default '0', `rel_hum_out` tinyint(3) NOT NULL default '0', `windspeed` 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(4,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` (`timestamp`) ) TYPE=MyISAM; Scott Evans <[EMAIL PROTECTED]> http://www.vk7hse.hobby-site.org/ PGP/GPG Key ID 74639624 _______________________________________________ Xastir mailing list [email protected] http://lists.xastir.org/cgi-bin/mailman/listinfo/xastir
