VbzCart/tables/ title ittyps

About

 * Returns: list of available titles for each item type
 * This table provides some of the same information as, but consolidated by ItTyp
 * Sources:, ,
 * Used by:, ,
 * History:
 * 2007-09-20 Added cntInStock field because we need to be able to figure out how many line items are available but not in stock (cntForSale-cntInStock)
 * 2010-11-13 Added 2 fields to help with availability status display: cntLines, cntCurrent

SQL
DROP TABLE IF EXISTS `_title_ittyps`; CREATE TABLE `_title_ittyps` (  `ID_Title` int unsigned NOT NULL,   `ID_ItTyp` int unsigned NOT NULL,   `ID_Dept` int unsigned NOT NULL,   `TitleName` varchar(127),   `ItTypNameSng` varchar(63) COMMENT "cat_ittyps.NameSng",   `ItTypNamePlr` varchar(63) COMMENT "cat_ittyps.NamePlr",   `ItTypSort` varchar(31) COMMENT "cat_ittyps.Sort",   `cntLines` int COMMENT "# of different items for this title+type",   `cntCurrent` int COMMENT "# of different items whose item data is current, for this title+type",   `cntInPrint` int COMMENT "# of different items (for type) in print for this title",   `cntForSale` int COMMENT "# of different items available for type (either in stock or in print)",   `cntInStock` int COMMENT "# of different items (for type) which are for sale due to at least being in stock",   `qtyInStock` int COMMENT "-1 = some in stock, but don't know how many",   `currMinPrice` DECIMAL(9,2) DEFAULT NULL COMMENT 'minimum price for this item type', `currMaxPrice` DECIMAL(9,2) DEFAULT NULL COMMENT 'maximum price for this item type', `CatNum` varchar(63) DEFAULT NULL, `CatWeb` varchar(63) DEFAULT NULL, `CatDir` varchar(63) DEFAULT NULL, PRIMARY KEY (`ID_Title`,`ID_ItTyp`,`ID_Dept`) ) ENGINE=MyISAM;