Hello Marcel,
thanks for your quick reply but that is not what I've asked.
I said: It shouldn't be possible to assign a (one) cateogory to an article twice.
For example you have an article. What sense would it make to assign the category "Kites" TWO TIMES to this article?
Best regards,
Hans Peter
Hans Peter
Gesendet: Donnerstag, 20. März 2014 um 10:31 Uhr
Von: "Marcel Müller" <[email protected]>
An: [email protected]
Betreff: Re: [oxid-dev-general] No unique indices in oxobject2* tables
Von: "Marcel Müller" <[email protected]>
An: [email protected]
Betreff: Re: [oxid-dev-general] No unique indices in oxobject2* tables
Hello Hans Peter,
for categories it’s correct that there is no key because it’s n:m.
btw: every article has a main category which indicates as oxpos = 0
aikme GmbH
Rheinstraße 43-45
55116 Mainz / Deutschland
Telefon: 06131 92 06 503
Telefax: 06131 92 08 334
www.aikme.de
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
