novice: table design FOREIGN key

From: Date: Thu, 19 May 2005 13:51:38 +0000
Subject: novice: table design FOREIGN key
Groups: php.general 
Request: Send a blank email to php-general+get-215593@lists.php.net to get a copy of this message
Hi All Thanks for all your comments on my previous mail, very much appreciated. I'm stuck again! I've created the following lookup table for m <-> m relationship between a Group and a Contact table. CREATE TABLE Group_Contact( GroupID INT NOT NULL, ContactID INT NOT NULL, Index (GroupID), FOREIGN KEY (GroupID) REFERENCES Group (PKey) ON DELETE CASCADE, Index (ContactID), FOREIGN KEY (ContactID) REFERENCES Contact (PKey) ON DELETE CASCADE ) TYPE=InnoDB COMMENT='Group to Contact lookup'; what do I need to do to ensure only unique (GroupID,ContactID) pair can be inserted into the table? Thanks Tony Yau

« previous php.general (#215593) next »