error on creating tables, country should be not null

I got these errors on my first visit to admin / build / modules after installing location module. Trying this sql by hand, the first one works no problem, the second one didn't like country not being "not null":

ERROR 1171: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

* user warning: You have an error in your SQL syntax near '; ' at line 18 query: CREATE TABLE drupallocation ( eid int unsigned NOT NULL default '0', lid int unsigned NOT NULL default '0', type varchar(6) NOT NULL default '', name varchar(255) default NULL, street varchar(255) default NULL, additional varchar(255) default NULL, city varchar(255) default NULL, province varchar(16) default NULL, postal_code varchar(16) default NULL, country char(2) default NULL, latitude decimal(10,6) default NULL, longitude decimal(10,6) default NULL, source tinyint default '0', is_primary tinyint NOT NULL default '0', PRIMARY KEY (lid) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in /Applications/MAMP/htdocs/includes/database.mysql.inc on line 172.

    * user warning: You have an error in your SQL syntax near '; ' at line 17 query: CREATE TABLE drupalzipcodes ( zip varchar(16) NOT NULL default '0', city varchar(30) NOT NULL default '', state varchar(30) NOT NULL default '', latitude decimal(10,6) NOT NULL default '0.000000', longitude decimal(10,6) NOT NULL default '0.000000', timezone tinyint NOT NULL default '0', dst tinyint NOT NULL default '0', country char(2) default '', PRIMARY KEY (country, zip), KEY pc (country, zip), KEY zip (zip), KEY latitude (latitude), KEY longitude (longitude), KEY country (country) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in /Applications/MAMP/htdocs/includes/database.mysql.inc on line 172.

adding in a "not null" fixed this, can't see whythe first creat errored though.