Re: multiple foreign key references on one column

2003-10-02 Thread dobbo
Quoting Roman Neuhauser <[EMAIL PROTECTED]>: > # [EMAIL PROTECTED] / 2003-09-25 > 14:59:33 +0100: > > CREATE TABLE `pheno` ( > > `id` smallint(5) unsigned NOT NULL > auto_increment, > > `relevant` enum('y','n') default NULL, > > `phenotype` varchar(50) NOT NULL default > '', > > PRIMARY KE

Re: multiple foreign key references on one column

2003-09-26 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-09-25 14:59:33 +0100: > CREATE TABLE `pheno` ( > `id` smallint(5) unsigned NOT NULL auto_increment, > `relevant` enum('y','n') default NULL, > `phenotype` varchar(50) NOT NULL default '', > PRIMARY KEY (`id`,`phenotype`), > KEY `id` (`id`), > CONSTRAINT `0_12