database - PHP SQLITE3 Create Table -

for reason table i'm trying create isn't being created when run following code:

$database = new pdo('sqlite:maindb.db');  $database->query("create table friends(id integer primary key, int, int);"); 

has else faced similar issue? i've tried exec well, no luck.