SQL parser does not support NULL as default value
When preparing a database schema with proper referential integrity, one typically has to choose NULL as default value for foreign keys:
CREATE TABLE tx_myext_domain_model_member ( uid int(11) NOT NULL auto_increment, pid int(11) DEFAULT '0' NOT NULL, some_fk int(11) DEFAULT NULL,
However, database analyzer does not support NULL as default value and shows an empty string ('') instead, thus suggesting that the underlying table structure is invalid and should be adapted.
Updated by Markus Klein almost 12 years ago
I had a look at these things a while ago. I discovered that the MySQL driver for PHP actually doesn't tell you the difference between a default '' and defaul NULL. It always returns '' (with type string).
So I'm not entirely sure, whether we can really fix this.