Cosa č CUSTOMER???


Cmq il codice esatto č il seguente:

codice:
CREATE TABLE category(
ID INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255),
description TEXT,
parent INT(11),
root INT(11)
)type = InnoDb;

CREATE TABLE item(
ID INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
ksCategory INT(11),
name VARCHAR(255),
description TEXT,
FOREIGN KEY (KsCategory) REFERENCES category(parent);
)type = InnoDb;