RE: How to use Item Category Properties?
I´m also interested on category properties in SO.
Something like that?
create table salesorderdetailsproperties (
`orderlineno` int(11) NOT NULL DEFAULT '0',
`orderno` int(11) NOT NULL DEFAULT '0',
`stkcatpropid` int(11) NOT NULL,
`value` varchar(50) NOT NULL,
PRIMARY KEY (`orderno`,`orderlineno`, `stkcatpropid`),
CONSTRAINT `salesorderdetailsproperties_ibfk_1` FOREIGN KEY (`orderlineno`,`orderno`) REFERENCES `salesorderdetails` (`orderlineno`,`orderno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|