Error in CREATE TABLE clause

[farukara]

CREATE TABLE party (
nes_party_id BIGINT UNSIGNED PRIMARY KEY not null, -- Error on this line
nes_party_name VARCHAR(255) not null,
INDEX(nes_party_id)
);

I'm getting error on the line for "nes_party_id" pointing to the first "N" of the UNSIGNED.

The error is:

Expected "(", ")", ",", "--", "/*", "AUTO_INCREMENT", "DEFAULT", "GENERATED", "NOT NULL", "PRIMARY KEY", "UNIQUE", or [ \t\n\r] but "U" found.

The create table is working alright but do you have any idea why I'm getting this error? Is Something to do with the order of the keywords?

Thanks.