SQL Error creating tables

[chrisj]

I am instructed to:

Do not forget to run the following commands on your sql database (replace phpbb2_ with your db prefix):
##CREATE TABLE phpbb2_forums_watch (

forum_id smallint(5) unsigned NOT NULL default '0',

user_id mediumint( NOT NULL default '0',

notify_status tinyint(1) NOT NULL default '0',

KEY forum_id (forum_id),

KEY user_id (user_id),

KEY notify_status (notify_status)

)

##ALTER TABLE phpbb2_forums

ADD forum_notify TINYINT(1) UNSIGNED DEFAULT '1' NOT NULL

AFTER forum_last_post_id

I have replaced phpbb2 and proceeded, and I have this error:

Error
SQL-query:

CREATE TABLE yan_forums_watch(

forum_id smallint( 5 ) unsigned NOT NULL default '0',
user_id mediumint( 8 ) NOT NULL default '0',
notify_status tinyint( 1 ) NOT NULL default '0',
KEY forum_id( forum_id ) ,
KEY user_id( user_id ) ,
KEY notify_status( notify_status )
) ALTER TABLE yan_forums ADD forum_notify TINYINT( 1 ) UNSIGNED DEFAULT '1' NOT NULL AFTER forum_last_post_id

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 'ALTER TABLE yan_forums
ADD forum_notify TINYINT(1) U

Can someone provide me with some insight into what I should do from here? Thanks.

[mrhappiness]

ALTER TABLE starts a 2nd mysql-command

just call mysql_query twice (once for each command) or use phpmyadmin (and don't forget to separat the commands via ;