Hello Hans Peter, for categories it’s correct that there is no key because it’s n:m.
Here the scenario: An article is in category „Clothes“ AND in category „Shirt“ … btw: every article has a main category which indicates as oxpos = 0 Mit freundlichen Grüßen Marcel Müller Webentwicklung / Projektmanagement eMail: [email protected] aikme GmbH Rheinstraße 43-45 55116 Mainz / Deutschland Telefon: 06131 92 06 503 Telefax: 06131 92 08 334 www.aikme.de aikme GmbH Geschäftsführer: Sascha Coldewey Sitz in Mainz, Registergericht: Mainz Registernummer: HRB 44835 Umsatzsteuer ID: DE282561622 Am 20.03.2014 um 10:22 schrieb Hans-Peter Szcazmus <[email protected]>: > 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
_______________________________________________ dev-general mailing list [email protected] http://dir.gmane.org/gmane.comp.php.oxid.general
