PHP query CREATE statement won't create table, why?

[ELVIS MACHUCA]

$SMT = $db->query("CREATE TABLE activitytable (ActivityID INT NOT NULL AUTO_INCREMENT, UserID INT, UserName LONGTEXT NULL, UserIP TINYTEXT NULL, ServerCommand MIDIUMTEXT NULL, ActivityDescription LONGTEXT NULL)");

but it won't work, I keep getting error code 42000.

for php purpose, do you have to create tables manually yourself at the workbench utility?

Why is it that one cannot create tables dynamically?

Help