VbzCart/tables/ dept ittyps

From HTYP, the free directory anyone can edit

[edit] SQL

 DROP TABLE IF EXISTS `_dept_ittyps`;
 CREATE TABLE `_dept_ittyps` (
   `ID_ItTyp` INT UNSIGNED NOT NULL,
   `ID_Dept` INT UNSIGNED NOT NULL,
   `cntForSale` INT UNSIGNED NOT NULL,
   `cntInPrint` INT UNSIGNED NOT NULL,
   `qtyInStock` INT UNSIGNED NOT NULL,
   `ItTypNameSng` VARCHAR(64) DEFAULT NULL COMMENT 'cat_ittyps.NameSng',
   `ItTypNamePlr` VARCHAR(64) DEFAULT NULL COMMENT 'cat_ittyps.NamePlr; default to ItTypNameSng',
   PRIMARY KEY (`ID_ItTyp`,`ID_Dept`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;