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: dev-general-boun...@lists.oxidforge.org [mailto:dev-general-boun...@lists.oxidforge.org] Im Auftrag von Hans-Peter Szcazmus Gesendet: Donnerstag, 20. März 2014 10:22 An: dev-general@lists.oxidforge.org 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 dev-general@lists.oxidforge.org http://dir.gmane.org/gmane.comp.php.oxid.general