Hi,
there is a unique key on OXCATNID and OXOBJECTID in oxobject2category and it is very good, that this key exists :-) Or am I mistaken? I checked two shop databases. But this key is missing in for example oxobject2action, there should be a unique key on OXOBJECTID and OXACTIONID. The same goes for several other oxobject2* tables, just not oxobject2category. 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 Tim Aniol Gesendet: Donnerstag, 20. März 2014 10:41 An: [email protected] Betreff: Re: [oxid-dev-general] No unique indices in oxobject2* tables 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" <mailto:[email protected]> <[email protected]> An: [email protected] Betreff: Re: [oxid-dev-general] No unique indices in oxobject2* tables Hello Hans Peter, for categories its correct that there is no key because its 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
