[Gmod-schema-cmts] schema/chado/modules/genetic genetic.sql, 1.22, 1.23

[David E. <em...@us...>]

Update of /cvsroot/gmod/schema/chado/modules/genetic
In directory sc8-pr-cvs2.sourceforge.net:/tmp/cvs-serv23296/genetic

Modified Files:
	genetic.sql 
Log Message:
Add phendesc.type_id for distinguishing types of text descriptions on 
phendesc.description, eg, complementation, phenotypic class, suppression, 
enhancement, etc.


Index: genetic.sql
===================================================================
RCS file: /cvsroot/gmod/schema/chado/modules/genetic/genetic.sql,v
retrieving revision 1.22
retrieving revision 1.23
diff -C2 -d -r1.22 -r1.23
*** genetic.sql	11 Apr 2006 14:45:43 -0000	1.22
--- genetic.sql	31 Jul 2006 15:27:47 -0000	1.23
***************
*** 155,161 ****
      FOREIGN KEY (environment_id) REFERENCES environment ( environment_id) ON DELETE CASCADE,
      description TEXT NOT NULL,
      pub_id INT NOT NULL,
      FOREIGN KEY (pub_id) REFERENCES pub (pub_id) ON DELETE CASCADE,
!     CONSTRAINT phendesc_c1 UNIQUE (genotype_id,environment_id,pub_id)
  );
  CREATE INDEX phendesc_idx1 ON phendesc (genotype_id);
--- 155,163 ----
      FOREIGN KEY (environment_id) REFERENCES environment ( environment_id) ON DELETE CASCADE,
      description TEXT NOT NULL,
+     type_id INT NOT NULL,
+         FOREIGN KEY (type_id) REFERENCES cvterm (cvterm_id) ON DELETE CASCADE,
      pub_id INT NOT NULL,
      FOREIGN KEY (pub_id) REFERENCES pub (pub_id) ON DELETE CASCADE,
!     CONSTRAINT phendesc_c1 UNIQUE (genotype_id,environment_id,type_id,pub_id)
  );
  CREATE INDEX phendesc_idx1 ON phendesc (genotype_id);