Hi All,
In the file "Build.sql" I saw many fields I don't understand how they
are releated, and why we need them.
in the department table, for example:
CREATE TABLE department (
ID int(11) NOT NULL AUTO_INCREMENT,
Name varchar(255),
Graphic varchar(255),
_____________________________
Parent int(11), /* why this? */
_____________________________
Description blob,
__________________________________________
DisplayPrecedence int(11), /* and this one? */
__________________________________________
PRIMARY KEY(ID)
);
and in item:
CREATE TABLE item (
ID int(11) NOT NULL AUTO_INCREMENT,
Name varchar(255),
Description blob,
_____________________________________
Keywords blob, /* this one ?*/
_____________________________________
Thumbnail varchar(255),
Graphic varchar(255),
LargeGraphic varchar(255),
______________________________
DisplayPrecedence int(11), /* this one? */
______________________________
Active char(1),
PRIMARY KEY(ID)
);
It would be useful if somebody could publish an example of a little
database with all fields filled.
jilani
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
