Hi Frank,
you’re right, by chance I checked two shops where we added this unique index ourselves. Best regards Michael Gerhardt -- Dipl.-Inf. (FH) Michael Gerhardt eWorks GmbH Hebelstraße 11 60318 Frankfurt am Main http://www.eWorks.de <mailto:[email protected]> [email protected] Fon: +49 (69) 9637250 - 117 Fax: +49 (69) 9637250 - 115 AG Frankfurt am Main HRB 80907 USt-IdNr: DE255807115 Geschäftsführung: Martin Klossek, Fabian Wleklinski Von: [email protected] [mailto:[email protected]] Im Auftrag von Frank Zunderer Gesendet: Donnerstag, 20. März 2014 10:53 An: [email protected] Betreff: Re: [oxid-dev-general] No unique indices in oxobject2* tables Hi, +1, i suggested this here: https://bugs.oxid-esales.com/view.php?id=5666 If an importer assigns an article twice to a category, number of articles displayed in list view is wrong. @Michael Gerhardt, this index is not unique. Regards, Frank Von: [email protected] [mailto:[email protected]] Im Auftrag von Hans-Peter Szcazmus Gesendet: Donnerstag, 20. März 2014 10:22 An: [email protected] Betreff: [oxid-dev-general] No unique indices in oxobject2* tables Dear developers, why are there no unique indices in the oxobject2* tables? Example for oxobject2category: It shouldn't be possible to assign a cateogory to an article twice. With a pure MySQL INSERT statement that would be possible. Wouldn't it make sense to create a unique index with OXOBJECTID and OXCATNID? Best regards, Hans Peter
_______________________________________________ dev-general mailing list [email protected] http://dir.gmane.org/gmane.comp.php.oxid.general
