mysql error when createing spam_comments table

The create statment for the spam_comments table gave me the following error when I tried to run it:

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

I changed the statement for the cid field to this:

cid int(10) unsigned NOT NULL,

and everything went through fine.