VbzCart/tables/ titles

From HTYP, the free directory anyone can edit

[edit] About

• Purpose: cached information about titles

[edit] SQL

 DROP TABLE IF EXISTS `_titles`;
 CREATE TABLE `_titles` (
   `ID` INT(11) UNSIGNED NOT NULL,
   `ID_Supp` INT(11) UNSIGNED NOT NULL COMMENT "avoids need for joining with cat_depts",
   `CatNum` VARCHAR(63) NOT NULL,
   `CatWeb` VARCHAR(63) NOT NULL,
   `cntForSale` INT DEFAULT NULL,
   `cntInPrint` INT DEFAULT NULL,
   `qtyInStock` INT DEFAULT NULL,
   `currMinSell` DECIMAL(9,2) DEFAULT NULL COMMENT "minimum selling price for an item of this title",
   `currMaxSell` DECIMAL(9,2) DEFAULT NULL COMMENT "maximum selling price for an item of this title",
   PRIMARY KEY (`ID`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;