Installation fails to create signup_status_codes table in MySQL

mysql> CREATE TABLE signup_status_codes (
-> cid int unsigned NOT NULL auto_increment,
-> name varchar(128) NOT NULL default '',
-> description text NOT NULL,
-> mod_signup_count int NOT NULL default 0,
-> auto_transition int NOT NULL default 0,
-> show_on_form int NOT NULL default 0,
-> PRIMARY KEY (cid),
-> UNIQUE KEY name (name)
-> );

I modified the create table script and go it to work with the above code.