CREATE TABLE {$prefix}posts(
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL ,
slug VARCHAR( 255 ) NOT NULL ,
content_type SMALLINT NOT NULL ,
title VARCHAR( 255 ) NOT NULL ,
guid VARCHAR( 255 ) NOT NULL ,
content TEXT NOT NULL ,
cached_content LONGTEXT NOT NULL ,
user_id SMALLINT NOT NULL ,
STATUS SMALLINT NOT NULL ,
pubdate TIMESTAMP NOT NULL ,
updated TIMESTAMP NOT NULL
);

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{$prefix}posts (
    id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL
,    slug VARCHAR' at line 1