text: CREATE TABLE `stockitemproperties` (
    `stockid` varchar(20) NOT NULL,
    `stkcatpropid` int(11) NOT NULL,
    `value` varchar(50) NOT NULL,
    PRIMARY KEY  (`stockid`,`stkcatpropid`),
    KEY `stockid` (`stockid`),
    KEY `value` (`value`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  CREATE TABLE `stockcatproperties` (
    `stkcatpropid` int(11) NOT NULL auto_increment,
    `categoryid` char(6) NOT NULL,
    `label` text NOT NULL,
    `controltype` tinyint(4) NOT NULL default '0',
    `defaultvalue` varchar(100) NOT NULL default '''''',
    `reqatsalesorder` tinyint(4) NOT NULL default '0',
    PRIMARY KEY  (`stkcatpropid`),
    KEY `categoryid` (`categoryid`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  