Help with creating tables in SQL

[chrisj]

I am not well versed in creating tables in SQL. Could someone help me/instructed me as to how/where I'd do this? I have myphpadmin.
Thanks.
In PHPbb Forum Notification MOD, they state:

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
##

[leatherback]

Hi,

If I understand you correctly, all you have to do is go to phpadmin. There select the database which you want to use (the text-dropdown box on the lefttop), or, if you do not have any databases yet, create one by typing a name of the database in the form.
then go to sql (In the top menu) and paste the code there, and press 'GO'.

That should do the trick.

But if you are not sure how to do this, maybe it is an idea to first read a bit on the idea of mysqladmin / SQL, and databasemanagement?

J.