Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Larger Item Category Properties
09-06-2014, 01:10 PM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


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

Forum Jump:


User(s) browsing this thread: 1 Guest(s)