Windows SQL 5.0 won't install due to default values on text big and blob database columns

Well, this one has aggravated the heck out of me. Getting this error on install into a Zend Community Server running on local host with MySQL 5.1.50.


user warning: BLOB/TEXT column 'attrib_value' can't have a default value query: CREATE TABLE queryable_variables ( `id` BIGINT DEFAULT 0, `field_name` VARCHAR(255) DEFAULT '', `php_data_type` VARCHAR(255) DEFAULT '', `element_name` VARCHAR(255) DEFAULT '', `element_value` LONGTEXT DEFAULT NULL, `attrib_name` VARCHAR(255) DEFAULT '', `attrib_value` LONGTEXT DEFAULT '', `date` DATETIME DEFAULT NULL, `date_value` DATETIME DEFAULT NULL, `aid` BIGINT DEFAULT 0, `bid` BIGINT DEFAULT 0, `cid` BIGINT DEFAULT 0, `did` BIGINT DEFAULT 0, `eid` BIGINT DEFAULT 0, `fid` BIGINT DEFAULT 0, `gid` BIGINT DEFAULT 0, `hid` BIGINT DEFAULT 0, `iid` BIGINT DEFAULT 0, `jid` BIGINT DEFAULT 0, `kid` BIGINT DEFAULT 0, `lid` BIGINT DEFAULT 0, `mid` BIGINT DEFAULT 0, `nid` BIGINT DEFAULT 0, `oid` BIGINT DEFAULT 0, `pid` BIGINT DEFAULT 0, `qid` BIGINT DEFAULT 0, `rid` BIGINT DEFAULT 0, `sid` BIGINT DEFAULT 0, `tid` BIGINT DEFAULT 0, `uid` BIGINT DEFAULT 0, `vid` BIGINT DEFAULT 0, `wid` BIGINT DEFAULT 0, `xid` BIGINT DEFAULT 0, `yid` BIGINT DEFAULT 0, `zid` BIGINT DEFAULT 0, `bool_value` TINYINT DEFAULT 0, `float_value` FLOAT DEFAULT 0, `filedata` LONGBLOB DEFAULT NULL, INDEX id (id), INDEX aid (aid), INDEX bid (bid), INDEX cid (cid), INDEX did (did), INDEX eid (eid), INDEX fid (fid), INDEX gid (gid), INDEX hid (hid), INDEX iid (iid), INDEX jid (jid), INDEX kid (kid), INDEX lid (lid), INDEX mid (mid), INDEX nid (nid), INDEX oid (oid), INDEX pid (pid), INDEX qid (qid), INDEX rid (rid), INDEX sid (sid), INDEX tid (tid), INDEX uid (uid), INDEX vid (vid), INDEX wid (wid), INDEX xid (xid), INDEX yid (yid), INDEX zid (zid), INDEX field_name (field_name), INDEX element_name (element_name), INDEX php_data_type (php_data_type), INDEX attrib_name (attrib_name), INDEX date (date), INDEX date_value (date_value), INDEX float_value (float_value), INDEX bool_value (bool_value) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in C:\Program Files (x86)\Zend\Apache2\htdocs\code\includes\database.inc on line 550.


I tracked this down.
http://drupal.org/node/143881 as it appears to be similar and I am going to remove the default values from the affected lines and see if that works...

...and yes it does now install.. I am attaching the modified .install file. Not sure if this will break other things.. If not, might consider it as a patch source.