digitalJE5U5
10-11-2002, 03:10 AM
I gotta problem. I'm wanting to install the Store hack, and the FIRST instruction is to run a querie on the DB:
CREATE TABLE store (
id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
action varchar(255) NOT NULL,
title varchar(255) NOT NULL,
costs varchar(255) NOT NULL,
sold smallint(5) DEFAULT '0',
imgurl varchar(255) NOT NULL,
description varchar(255) NOT NULL,
ok char(1) NOT NULL default '',
quantity smallint(5) DEFAULT '0',
PRIMARY KEY (id)
);
and I keep getting the result:
MySQL said:
You have an error in your SQL syntax near '\'0\' NOT NULL auto_increment,
action varchar(255) NOT NULL,
title varc' at line 2
Any help?
Thanks alot!
/DJ
CREATE TABLE store (
id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
action varchar(255) NOT NULL,
title varchar(255) NOT NULL,
costs varchar(255) NOT NULL,
sold smallint(5) DEFAULT '0',
imgurl varchar(255) NOT NULL,
description varchar(255) NOT NULL,
ok char(1) NOT NULL default '',
quantity smallint(5) DEFAULT '0',
PRIMARY KEY (id)
);
and I keep getting the result:
MySQL said:
You have an error in your SQL syntax near '\'0\' NOT NULL auto_increment,
action varchar(255) NOT NULL,
title varc' at line 2
Any help?
Thanks alot!
/DJ