How do you create a table?

[eJM]

Okay, I'm clueless. This is part of the 404.impex.readme.txt:

You will need to create this table in your vBulletin database :

CREATE TABLE `404_actions` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`time` INT UNSIGNED NOT NULL ,
`incomming` VARCHAR( 250 ) NOT NULL ,
`outgoing` VARCHAR( 250 ) NOT NULL ,
`action` TINYINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY ( `id` )
) TYPE = MYISAM ;
Exactly how do you do that? I do have access to phpMyAdmin and I can see the "Create a new table on database...". There's a place for the name and another for the number of fields, but I have a bad feeling that if I just take a wild guess the name is 404_actions, I still don't know how many fields there are, not to mention what any of that means or what input boxes to put it in, so I'd prob'y get database errors or even corrupt a perfectly good database trying.

Can someone explain this a step at a time for me and anyone else who isn't exactly proficient in "database", but can follow directions really well?

Thank you,

Jim

[Steve Machol]

Run this query in the SQL tab in phpMyAdmin:

CREATE TABLE `404_actions` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`time` INT UNSIGNED NOT NULL ,
`incomming` VARCHAR( 250 ) NOT NULL ,
`outgoing` VARCHAR( 250 ) NOT NULL ,
`action` TINYINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY ( `id` )
) TYPE = MYISAM ;

[eJM]

Thank you, Steve.