VbzCart/tables/ titles

About

 * Purpose: cached information about titles

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;