Return-Path: 
 <torque-user-return-8350-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
X-Original-To: apmail-db-torque-user-archive@www.apache.org
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id B8607428A
	for <apmail-db-torque-user-archive@www.apache.org>;
 Tue, 31 May 2011 11:32:17 +0000 (UTC)
Received: (qmail 70014 invoked by uid 500); 31 May 2011 11:32:17 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 69970 invoked by uid 500); 31 May 2011 11:32:16 -0000
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-user-unsubscribe@db.apache.org>
List-Help: <mailto:torque-user-help@db.apache.org>
List-Post: <mailto:torque-user@db.apache.org>
List-Id: "Apache Torque Users List" <torque-user.db.apache.org>
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 69961 invoked by uid 99); 31 May 2011 11:32:16 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 May 2011 11:32:16 +0000
X-ASF-Spam-Status: No, hits=3.5 required=5.0
	tests=SPF_PASS,TO_NO_BRKTS_DIRECT
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [207.107.7.34] (HELO busstop.trapezegroup.com) (207.107.7.34)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 May 2011 11:32:10 +0000
To: torque-user@db.apache.org
MIME-Version: 1.0
Subject: Define a Foreign Key with a One-to-One mapping
X-KeepSent: 0F4C46EF:B3C480D7-802578A1:003F0175;
 type=4; name=$KeepSent
X-Mailer: Lotus Notes Release 8.5.1 September 28, 2009
Message-ID: 
 <OF0F4C46EF.B3C480D7-ON802578A1.003F0175-802578A1.003F567F@trapezegroup.com>
From: Neil Sherman <Neil.Sherman@trapezegroup.co.uk>
Date: Tue, 31 May 2011 12:31:49 +0100
X-MIMETrack: Serialize by Router on BusStop/Trapsoft Inc at 05/31/2011
 07:32:08 AM,
	Serialize complete at 05/31/2011 07:32:08 AM
Content-Type: text/plain; charset="US-ASCII"

Hi,

This may be a bit of a simple question but...

How do I define a foreign key in my Torque schema with a one-to-one 
mapping ?  No matter what I do I always seem to end up with a one-to-many 
relationship ?

I've tried adding in multiplicity option but it doesnt seem to have any 
effect:

                <foreign-key foreignTable="styledJourneys">
                        <option key="bidirectional" value="false"/>
                        <option key="multiplicity" value="one-to-one"/> 
                        <reference local="journeySetID" foreign=
"journeySetID"/>
                </foreign-key>

I'm using mySQL 5.1 as my database backend

Thanks for your time

Neil



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org