RE: Larger Item Category Properties
Well it is only 50 chars I think.
What about a number of different category properties fields. Or, if you are trying to write quite lot of info - perhaps we need to change it to a TEXT? Are you talking about
CREATE TABLE IF NOT EXISTS `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`),
KEY `stkcatpropid` (`stkcatpropid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
There looks to be a mismatch between the defaultvalue in the stockcatproperties definition table and the actual "value" stored in this table above. We should change the two to be the same!
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
|