I'm restoring the data and structure to a database.  I am receiving errors
due to the following code:

************** BEGIN **************

CREATE TABLE BGColors (
  Name varchar(100) NOT NULL default '',
  Color varchar(100) NOT NULL default '',
  BGColorID int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (BGColorID),
  KEY BGColorID (BGColorID)
) TYPE=MyISAM;

--
-- Dumping data for table 'BGColors'
--

INSERT INTO BGColors VALUES ('White on Blue','#FFFFFF #333399',1);
INSERT INTO BGColors VALUES ('Light Lavendar on Purple','#993399
#FFCCFF',13);

***************END***************
Any ideas what may be causing this?  Is it related to the KEY and PRIMARY
KEY that is specified?  The code is from a backup I did today, but I can't
get it to restore because of this.

Thanks,
Keith D Sellars
WebGraffix
www.webgraffix.com

"Making database sites seem easy"

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA