Hmm. After waiting for about half an hour on my 56k modem to apply the Database changes I get an error with the first damn query when it tried to create the forecast table:
Code:
CREATE TABLE forecast(
id int( 4 ) NOT NULL AUTO_INCREMENT ,
rid char( 2 ) default NULL ,
region varchar( 15 ) default NULL ,
cid char( 2 ) default NULL ,
country varchar( 33 ) default NULL ,
sid char( 2 ) NOT NULL default '',
state varchar( 20 ) default NULL ,
pid varchar( 5 ) NOT NULL default '',
place varchar( 120 ) default NULL ,
code varchar( 8 ) default NULL ,
PRIMARY KEY ( id ) ,
KEY forecast_rid_cid_sid_pid( rid, cid, sid, pid )
)ENGINE = MYISAM DEFAULT CHARSET = latin1
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET = latin1' at line 12
I'm pretty sure it's because my PHP version is too old, which is a shame as this isn't my server so I don't have a choice as to upgrading the version.

But this is a great hack though!

Thanks!