Hi Hans,
I think you have to take care of this by yourself. That's also the usual
way for constraints (primary and foreign key).
BR
Tim
Mit freundlichen Grüßen
Tim Aniol
Softwareentwickler
*************************************
shoptimax GmbH
Ulmenstr. 52 H
90443 Nürnberg
Tel (09 11) 2 55 66 - 17
Fax (09 11) 2 55 66 - 29
eMail [email protected]
Web www.shoptimax.de
*************************************
Geschäftsführung: Friedrich Schreieck
Ust.-IdNr.: DE 814340642
Amtsgericht Nürnberg HRB 21703
Am 20.03.2014 10:36, schrieb Hans-Peter Szcazmus:
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
*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
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 <http://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
_______________________________________________
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
