#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 'NOT NULL, state smallint DEFAULT 0 NOT NULL, catid bigint DEFAULT 0 NO' at line 7

gistfile1.sql

CREATE TABLE d6twp_content (
    id int(11) NOT NULL,
    asset_id bigint DEFAULT 0 NOT NULL,
    title varchar(255) DEFAULT '',
    alias varchar(255) DEFAULT '',
    introtext text NOT NULL,
    fulltext text NOT NULL,
    state smallint DEFAULT 0 NOT NULL,
    catid bigint DEFAULT 0 NOT NULL,
    created timestamp DEFAULT 0,
    created_by bigint DEFAULT 0 NOT NULL,
    created_by_alias varchar(255) DEFAULT '',
    modified timestamp DEFAULT 0,
    modified_by bigint DEFAULT 0 NOT NULL,
    checked_out bigint DEFAULT 0 NOT NULL,
    checked_out_time timestamp DEFAULT 0,
    publish_up timestamp DEFAULT 0,
    publish_down timestamp DEFAULT 0,
    images text NOT NULL,
    urls text NOT NULL,
    attribs text NOT NULL,
    version bigint DEFAULT 1 NOT NULL,
    ordering bigint DEFAULT 0 NOT NULL,
    metakey text NOT NULL,
    metadesc text NOT NULL,
    access bigint DEFAULT 0 NOT NULL,
    hits bigint DEFAULT 0 NOT NULL,
    metadata text NOT NULL,
    featured smallint DEFAULT 0 NOT NULL,
    language varchar(7) DEFAULT '',
    xreference varchar(50) DEFAULT ''
) TYPE=MyISAM;