Install fails on 4.7.x/MySql 4.1.13a

// $Id: tablemanager.install,v 1.17 2006/11/01 16:17:51 pobster Exp $
// $Id: tablemanager.module,v 1.72 2006/10/25 07:31:45 pobster Exp $

When installing, I get this message:

Table installation for the Tablemanager module was unsuccessful. The tables may need to be installed by hand. See tablemanager.install file for a list of the installation queries.

These are in the watchdog log:

Invalid default value for 'tid' query: CREATE TABLE tablemanager ( tid int(11) unsigned DEFAULT '0' NOT NULL auto_increment, uid int(11) DEFAULT '1' NOT NULL, name varchar(255) DEFAULT '' NOT NULL, description varchar(255) DEFAULT '' NOT NULL, header text NOT NULL, PRIMARY KEY (tid) )TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in $base_url/includes/database.mysql.inc on line 120.

Invalid default value for 'id' query: CREATE TABLE tablemanager_data ( id int(11) unsigned DEFAULT '0' NOT NULL auto_increment, tid int(11) DEFAULT '0' NOT NULL, uid int(11) DEFAULT '1' NOT NULL, data text NOT NULL, format int(3) DEFAULT '1' NOT NULL, PRIMARY KEY (id) )TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in $base_url/html/includes/database.mysql.inc on line 120.

Table 'timelesscreatures_db.tablemanager' doesn't exist query: SELECT * FROM tablemanager in $base_url/html/includes/database.mysql.inc on line 120.

I was able to get past this problem by modifying the table creation scripts as follows in MySql Query Browser:

CREATE TABLE tablemanager (
            tid int(11) unsigned NOT NULL auto_increment,
          uid int(11) DEFAULT 1 NOT NULL,
          name varchar(255) DEFAULT '' NOT NULL,
          description varchar(255) DEFAULT '' NOT NULL,
          header text NOT NULL,
          PRIMARY KEY (tid)
        )TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

CREATE TABLE tablemanager_data (
          id int(11) unsigned NOT NULL auto_increment,
          tid int(11) DEFAULT 0 NOT NULL,
          uid int(11) DEFAULT 1 NOT NULL,
          data text NOT NULL,
          format int(3) DEFAULT 1 NOT NULL,
          PRIMARY KEY (id)
        )TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;

So, it looks like the install script for MySql has a 'default' specification for the primary key, which is causing errors.