Hi, my queries did not run so i was going to run them in phpmyadmin but i am unsure what syntax to use> currently it is for example:
Code:
$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))
");
But i do not think that is right for manually running the query. If someone could supply what the above should be i can mimic it to the rest. Total mysql noob.
Thanks!