MySQL syntax error; don't know where to begin -

i'm trying create table. think specifications of table should pretty obvious command i'm running:

create table users{     id mediumint unsigned not null auto_increment,     username varchar(40) not null,     sprinkles bigint unsigned not null,     passhash binary(64) not null,     passsalt binary(64) not null,     x decimal(10,1),     y decimal(10,1),     primary key (id),     unique key idx_unique_username (username) } engine = innodb default character set = utf8 collate = utf8_general_ci; 

however, when try entering mysql, gives me error:

error 1064 (42000): have error in sql syntax; check manual corresponds mysql server version right syntax use near '{ id mediumint unsigned not null auto_increment, username varchar(40) not null, ' @ line 1 

my mysql version ver 14.14 distrib 5.5.31, debian-linux-gnu (x86_64) using readline 6.2

begin parentheses shape.

hint: find any create table example , compare have

hint 2: when mysql returns error incorrect syntax - points directly first token couldn't parse. attention should drawn exact character , characters before it.