Why this error?

[Dark Aura]

Everytime I try to run a query for this quote it hack I keep getting this error what ever it is, what is wrong with my database?

----------------

Database error in vBulletin 3.0.3:

Invalid SQL:
CREATE TABLE vb3_quotes (
`quoteid` int(10) unsigned NOT NULL auto_increment,
`quote` mediumtext NOT NULL,
`author` mediumtext NOT NULL,
`userid` int(10) unsigned NOT NULL default '0',
`approved` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`quoteid`,`quoteid`),
KEY `approved` (`approved`)
) TYPE=MyISAM AUTO_INCREMENT=1

mysql error: Duplicate column name 'quoteid'

mysql error number: 1060

Date: Tuesday 29th of March 2005 02:09:54 PM
Script: http://www.silent-imperfection.net/a...ll_quoteit.php
Referer: http://www.silent-imperfection.net/a...ll_quoteit.php
Username: Spade
IP Address: 62.64.214.70