need help with mysql query syntax running it manually

[sross]

this was in a mod i am installing and i need to run it manually in phpmyadmin but am not sure how:

$db->query_write("
	CREATE TABLE " . TABLE_PREFIX . "journal_comments (
	comment_id int(10) NOT NULL auto_increment,
	journal_id int(10) NOT NULL,
	entry_id int(10) NOT NULL,
	commenter varchar(50) NOT NULL,
	commenter_id int(10) NOT NULL,
	comment_title varchar(100) NOT NULL,
	comment_text text NOT NULL,
	comment_date int(10) NOT NULL,
	ipaddress varchar(15) NOT NULL,
	PRIMARY KEY (comment_id))
");

i try to run that but it fails and i've tried several changes as a guess with no luck. I'm sure it's simple i just don't know it.. Thanks for any help!

[Ranma2k]

if there no table prefix use

CREATE TABLE journal_comments (
	comment_id int(10) NOT NULL auto_increment,
	journal_id int(10) NOT NULL,
	entry_id int(10) NOT NULL,
	commenter varchar(50) NOT NULL,
	commenter_id int(10) NOT NULL,
	comment_title varchar(100) NOT NULL,
	comment_text text NOT NULL,
	comment_date int(10) NOT NULL,
	ipaddress varchar(15) NOT NULL,
	PRIMARY KEY (comment_id))

if there a table prefix replace " . TABLE_PREFIX . " with it

for example if table prefix is vb_

then the query will be

CREATE TABLE vb_journal_comments (
	comment_id int(10) NOT NULL auto_increment,
	journal_id int(10) NOT NULL,
	entry_id int(10) NOT NULL,
	commenter varchar(50) NOT NULL,
	commenter_id int(10) NOT NULL,
	comment_title varchar(100) NOT NULL,
	comment_text text NOT NULL,
	comment_date int(10) NOT NULL,
	ipaddress varchar(15) NOT NULL,
	PRIMARY KEY (comment_id))