In creating tables for the database for phpnuke using the supplied sql file of which I am troubleshooting. I created all the tables up to the "contactbook" table. When I copied/pasted the table structure, I get back this:
MySQL said:
You have an error in your SQL syntax near 'events text, reminders int(11) default NULL, notes text, PRIMARY KEY (contactid)' at line 1
here is the code:
Table structure for table nuke_contactbook
#
CREATE TABLE nuke_contactbook (
uid int(11) NOT NULL default '0',
contactid int(11) NOT NULL auto_increment,
firstname varchar(50) default NULL,
lastname varchar(50) default NULL,
email varchar(255) default NULL,
company varchar(255) default NULL,
homeaddress varchar(255) default NULL,
city varchar(80) default NULL,
homephone varchar(255) default NULL,
workphone varchar(255) default NULL,
homepage varchar(255) default NULL,
IM varchar(255) default NULL,
events text,
reminders int(11) default NULL,
notes text,
PRIMARY KEY (contactid),
KEY uid (uid),
KEY contactid (contactid)
) TYPE=MyISAM;
#
Dumping data for table nuke_contactbook
#
SINCE I am just copy/pasteing, I don't understand what the heck is wrong? Sheeesh, Its going to be a loooong year.
