What is wrong with this syntax?

[Hex_legend]

I am trying to add a table called licences to my "demoforum" db.

The db is called demoforum

I am using this code:

CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX . `licenses` (
			`id` int(6) NOT NULL auto_increment,
			`userid` int(6) NOT NULL,
			`productid` int(6) NOT NULL,
			`licensenum` varchar(250) NOT NULL,
			`dateline` varchar(10) NOT NULL,
			`status` int(1) NOT NULL,
			`url` varchar(250) NOT NULL,
			`title` varchar(250) NOT NULL,
			`description` text NOT NULL,
			`add_urls` text NOT NULL,
			`public` int(1) NOT NULL default '0',
			`upgrades` text NOT NULL,
			PRIMARY KEY  (`id`)
		)

yet its giving an error all the time. I need this to be able to be run via the vb acp in the query section. Can anyone help with the correct syntax?

[Lynne]

Check the area where you have TABLE_PREFIX. Your quotes don't add up correctly.

[Dismounted]

You can't actually run PHP code (you have used TABLE_PREFIX) in the Admin CP SQL Query executer.