VbzCart/tables/ supplier ittyps

From HTYP, the free directory anyone can edit

Jump to: navigation, search

[edit] About

[edit] SQL

DROP TABLE IF EXISTS `_supplier_ittyps`;
CREATE TABLE `_supplier_ittyps` (
   `ID` INT(11) UNSIGNED NOT NULL,
   `ItemType` VARCHAR(63) NOT NULL,
   `ItemCount` INT NOT NULL,
   `Name` VARCHAR(63) NOT NULL,
   `CatKey` VARCHAR(7) NOT NULL,
   PRIMARY KEY (`ID`,`ItemType`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Personal tools