TYPO3 Core

#1310027793: ERROR: Query could not be parsed: "SQL engine parse ERROR: Field type unknown in parseFieldDef()!: near "date default '0000-00-00' "". Query: "ALTER TABLE fe_users ADD birthday date default '0000-00-00';"

When installing an extension having ext_tables.sql:

#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
    birthday date DEFAULT '0000-00-00',
    subscribed_courses int(11) unsigned DEFAULT '0' NOT NULL,
    tx_extbase_type varchar(255) DEFAULT '' NOT NULL,
);