VbzCart/tables/ depts

About

 * Purpose: Calculated information about departments

SQL
DROP TABLE IF EXISTS `_depts`; CREATE TABLE `_depts` (  `ID` int(11) unsigned NOT NULL auto_increment,   `ID_Supp` int(11) unsigned NOT NULL COMMENT 'needed to simplify calculation of _titles',   `CatNum` varchar(63) NOT NULL,   `CatKey` varchar(7),   `CatWeb_Dept` varchar(63) NOT NULL,   `CatWeb_Title` varchar(63) NOT NULL,   `cntForSale` int DEFAULT NULL,   `cntInPrint` int DEFAULT NULL,   `qtyInStock` int DEFAULT NULL,   PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;