Bad Query

[Osterling]

I am not sure if this is allowed since I got this hack off another site, but I am just wondering if anyone could help me here...

The First Query Is:


CREATE TABLE journal (
'journalid' int(11) NOT NULL auto_increment,
'title' text NOT NULL,
'description' text NOT NULL,
'imagename' text NOT NULL,
'entries' int(11) NOT NULL default '0',
'views' int(11) NOT NULL default '0',
'enabled' smallint(6) default '0',
'timestamp' int(11) NOT NULL default '0',
'userid' int(11) NOT NULL default '0',
'mood' text NOT NULL,
'np' text NOT NULL,
PRIMARY KEY ('journalid')
) TYPE=MyISAM ;


well I ran it and i got this error:

MySQL said:


#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 ''journalid'int( 11 ) NOT NULL AUTO_INCREMENT ,
'title'text