Create table if not exists

[Stickers]

Hi all..

Im trying to add in the userfield a new table, but wheb i run this..
i dont see the sound table in the database..

any idea's?

PHP Code:

CREATE TABLE IF NOT EXISTS `userfield` (
  `userid` int(10) unsigned NOT NULL default '0',
  `temp` mediumtext,
  `field1` mediumtext,
  `field2` mediumtext,
  `field3` mediumtext,
  `field4` mediumtext,
  `sound` mediumtext,
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 


Best regards..

--------------- Added [DATE]1232155874[/DATE] at [TIME]1232155874[/TIME] ---------------

anyone???

[Dismounted]

The table "userfield" is a vBulletin table, and already exists on an installation of vBulletin. Your query creates a table if it does not exist. What you are looking for is to alter the user table, not userfield.

[Stickers]

sow there is no way to add the tablename sound in the userfield table?

[Dismounted]

Use the ALTER command on the user table.

ALTER TABLE Syntax

[Marco van Herwaarden]

Your question is very confusing. You are trying to add a table to another table?