VbzCart/tables/cat depts

From HTYP, the free directory anyone can edit

[edit] About

• Purpose: catalog departments within a supplier. Not all suppliers split things into departments, but they still need one department record with a NULL PageKey.

[edit] SQL

 CREATE TABLE `cat_depts` (
   `ID` INT  NOT NULL AUTO_INCREMENT,
   `Name` VARCHAR(64) COMMENT 'name of department as displayed',
   `ID_Supplier` INT DEFAULT NULL COMMENT 'cat_suppliers.ID',
   `isActive` BOOL COMMENT 'items.ID' COMMENT 'department is available for adding titles',
   `Sort` VARCHAR(8) COMMENT 'listing order; default to CatKey',
   `CatKey` VARCHAR(4) COMMENT 'use for building title catalog numbers',
   `PageKey` VARCHAR(4) COMMENT 'use for building URL of Dept page',
   `Descr` VARCHAR(255) COMMENT 'descriptive text for Dept page',
   PRIMARY KEY(`ID`)
 )
 ENGINE = MYISAM;