Hi Marcel, I guess what he means ist that it should not be possible to assign the article twice to "Clothes", so he thinks about a unique key for the combination of oxobjectid and oxcatnid which should be unique even in your scenario.
Best Regards, André Am Donnerstag, 20. März 2014, 10:31:48 schrieb Marcel Müller: > 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 -- André Gregor-Herrmann Technischer Leiter mail [ [email protected] ] web [ www.fatchip.de ] FATCHIP [ GmbH ] | sitz [ Helmholtzstrasse 2-9 | 10587 Berlin ] | fon [ 030.39 88 93 51 ] | fax [ 030.39 88 93 52 ] | mail [ [email protected] ] | Ust-Id. [ DE 265567757 ] | Amtsgericht [ Berlin-Charlottenburg ] | HRB [120567 B] | Geschäftsführung [ Dipl.-Ing. Hendrik Bahr ] Be Smart, Go Green. Don’t print this email unless you really need to.
BEGIN:VCARD ADR;TYPE=pref;TYPE=work:;;Helmholtzstraße 2-9;Berlin;Berlin;10587;Deutschl and BDAY:1978-12-07 EMAIL:[email protected] FN:André Gregor-Herrmann N:Gregor-Herrmann;André;;; ORG:Fatchip GmbH;Entwicklung TEL;TYPE=WORK:030 / 39 88 93 51 UID:Qw6xRQtAGY URL:http://www.fatchip.de VERSION:3.0 X-KADDRESSBOOK-MailAllowToRemoteContent:TRUE X-KADDRESSBOOK-X-Profession:Technischer Leiter END:VCARD
_______________________________________________ dev-general mailing list [email protected] http://dir.gmane.org/gmane.comp.php.oxid.general
