First of all I'm not a database guy...I'm a web designer..the db admin is out of pocket and the server died...now I'm left to reload the db. Maybe someone can help me.
After the server came back up, mysql running I tried using the dump utility from the myphpadmin area to reload the database from an uzipped backup file.
I'm receiving the following error...also including the code I think is generating the error... I don't have a clue what it is referring to
error:
mySQL said:
You have an error in your SQL syntax near 'references varchar(127) NOT NULL default '',
PRIMARY KEY (company_id),
KEY' at line 16
Code:
DROP TABLE IF EXISTS companies;
CREATE TABLE companies (
company_id int(10) unsigned NOT NULL auto_increment,
category_id int(10) unsigned NOT NULL default '0',
name varchar(39) NOT NULL default '',
slogan varchar(255) NOT NULL default '',
address varchar(63) NOT NULL default '',
phone varchar(31) NOT NULL default '',
fax varchar(31) NOT NULL default '',
email varchar(127) NOT NULL default '',
web varchar(127) NOT NULL default '',
about varchar(127) NOT NULL default '',
directions varchar(127) NOT NULL default '',
logo char(0) NOT NULL default '',
priority enum('#1','#2','#3','#4') NOT NULL default '#3',
coupons varchar(127) NOT NULL default '',
references varchar(127) NOT NULL default '',
PRIMARY KEY (company_id),
KEY category_id(category_id),
KEY name(name),
KEY priority(priority)
) TYPE=MyISAM;
Thanks RSG
