Campo contatore in MySql

[Sonikag]

mysql> create table SOGGETTO (
-> 'idsoggetto' int not null auto_increment primary key,
-> 'cognrag' char(30) not null,
-> 'nome' char(30)
-> );
ERROR 1064: You have an error in your SQL syntax near ''idsoggetto' int not null
auto_increment primary key,
'cognrag' char(30) not nul' at line 2
mysql> create table SOGGETTO (
-> 'idsoggetto' int unique auto_increment primary key,
-> 'cognrag' char(30) not null,
-> 'nome' char(30)
-> );
ERROR 1064: You have an error in your SQL syntax near ''idsoggetto' int unique a
uto_increment primary key,
'cognrag' char(30) not null,' at line 2
mysql>


Dove sbaglio?