From: Scott C. <sco...@us...> - 2008-08-25 19:53:06
|
Update of /cvsroot/gmod/schema/chado/modules/genetic In directory sc8-pr-cvs2.sourceforge.net:/tmp/cvs-serv25188 Modified Files: genetic.sql Log Message: adding foreign key to pub in phenotype_comparison_cvterm table (bug caught by Rob Bruggner). Index: genetic.sql =================================================================== RCS file: /cvsroot/gmod/schema/chado/modules/genetic/genetic.sql,v retrieving revision 1.30 retrieving revision 1.31 diff -C2 -d -r1.30 -r1.31 *** genetic.sql 25 Jun 2007 19:52:34 -0000 1.30 --- genetic.sql 25 Aug 2008 19:53:14 -0000 1.31 *************** *** 193,197 **** -- ================================================ CREATE TABLE phenotype_comparison_cvterm ( - pub_id INT NOT NULL, phenotype_comparison_cvterm_id serial not null, primary key (phenotype_comparison_cvterm_id), --- 193,196 ---- *************** *** 200,203 **** --- 199,204 ---- cvterm_id int not null, FOREIGN KEY (cvterm_id) references cvterm (cvterm_id) on delete cascade, + pub_id INT not null, + FOREIGN KEY (pub_id) references pub (pub_id) on delete cascade, rank int not null default 0, CONSTRAINT phenotype_comparison_cvterm_c1 unique (phenotype_comparison_id, cvterm_id) |