I'm trying to install ProBIND, and I'm running mysql 4.1.20.

One of the ProBIND install scripts calls for tables to be created in MySQL, and I've culled it down to this:

mysql> CREATE TABLE zones (
-> id INT(11) DEFAULT '1' NOT NULL AUTO_INCREMENT,
-> PRIMARY KEY (id)
-> );
ERROR 1067 (42000): Invalid default value for 'id'


I've tried double quotes, changing it to INT(1), and still I get that error.

Any hints?
=== Al