php - SQL Syntax Error with PDO and MySQL, Not Anywhere Else -

i created table in sequel pro , exported create table syntax. eye, looks fine. issue is, i'm trying run query using pdo , encountering syntax error:

general error: 1 near "unsigned": syntax error 

the query works fine if run in sequel pro again, or if run in phpmyadmin. clues why query failing in pdo only?

create table `users` (   `id` int(11) unsigned not null auto_increment,   `parent_id` int(11) unsigned default null,   `name` varchar(30) not null,   `email` varchar(50) not null,   `password` varchar(60) not null,   `passwordresetkey` varchar(8) default null,   `activationkey` varchar(8) default null,   `permissions` smallint(5) unsigned not null default '0',   primary key (`id`),   key `parent_id` (`parent_id`),   constraint `users_ibfk_1` foreign key (`parent_id`) references `users` (`id`) on delete set null ) engine=innodb default charset=latin1; 

note: included line breaks above clarity, there's no line breaks in query that's run.

the code runs query:

$query = 'create table `users` ( `id` int(11) unsigned not null auto_increment, `parent_id` int(11) unsigned default null, `name` varchar(30) not null, `email` varchar(50) not null, `password` varchar(60) not null, `passwordresetkey` varchar(8) default null, `activationkey` varchar(8) default null, `permissions` smallint(5) unsigned not null default 0, primary key (`id`), key `parent_id` (`parent_id`), constraint `users_ibfk_1` foreign key (`parent_id`) references `users` (`id`) on delete set null ) engine=innodb default charset=latin1'; $statement = $conn->prepare($query); $statement->execute(); 

in case, turns out issue was not connecting database prior running query. code setup script, checked database credentials on page previous page ran queries.

however, in setup pages, app setup database must explicitly connected (which occurred when checking credentials, not running these queries). had connect database properly, , queries started functioning.