[Typo3] EM cannot create tables for static_info_tables

[Steve Webster]

Hi Steve,

Thanks for your quick suggestion.  Tried this but it didn't work.

It's a really weird problem.  When I get prompted to create the tables I can 
see the DEFAULT '0' has been correctly stripped.  But, with t3lib_db 
debugging enabled, when I then click the "Make Updates" button I can see 
that the SQL commands that Typo has tried to run are the old/invalid ones.  
E.g.:


caller	t3lib_DB::admin_query
ERROR	Invalid default value for 'uid'
lastBuiltQuery	SELECT content
FROM cache_hash
WHERE
hash="0de64bd01f3abb66cd42a34883e93e97"
debug_backtrace
file	c:\temp\php\alpha\typo3\mod\tools\em\index.php
line	3610
function	admin_query
class	t3lib_db
type	->
args
0	CREATE TABLE static_countries (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
cn_iso_2 char(2) DEFAULT '' NOT NULL,
cn_iso_3 char(3) DEFAULT '' NOT NULL,
cn_iso_nr int(11) unsigned DEFAULT '0' NOT NULL,
cn_official_name_local varchar(45) DEFAULT '' NOT NULL,
cn_official_name_en varchar(45) DEFAULT '' NOT NULL,
cn_capital varchar(45) DEFAULT '' NOT NULL,
cn_tldomain char(2) DEFAULT '' NOT NULL,
cn_currency_iso_3 char(3) DEFAULT '' NOT NULL,
cn_currency_iso_nr int(10) unsigned DEFAULT '0' NOT NULL,
cn_phone int(10) unsigned DEFAULT '0' NOT NULL,
cn_eu_member tinyint(3) unsigned DEFAULT '0' NOT NULL,
cn_address_format tinyint(3) unsigned DEFAULT '0' NOT NULL,
cn_zone_flag tinyint(4) DEFAULT '0' NOT NULL,
cn_short_local varchar(45) DEFAULT '' NOT NULL,
cn_short_en varchar(45) DEFAULT '' NOT NULL,
cn_short_dk varchar(45) DEFAULT '' NOT NULL,
cn_short_de varchar(45) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
UNIQUE uid (uid)
);