Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Larger Item Category Properties
09-06-2014, 01:10 PM,
#2
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
Reply


Messages In This Thread
Larger Item Category Properties - by agaluski - 09-06-2014, 06:09 AM
RE: Larger Item Category Properties - by phil - 09-06-2014, 01:10 PM
RE: Larger Item Category Properties - by agaluski - 09-07-2014, 07:24 AM
RE: Larger Item Category Properties - by phil - 09-07-2014, 07:59 AM
RE: Larger Item Category Properties - by agaluski - 09-08-2014, 10:46 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)