[Gmod-schema-cmts] SF.net SVN: gmod:[24902] schema/trunk/chado/modules/natural_diversity/ natural_diversity.sql

[<nm...@us...>]

Revision: 24902
          http://gmod.svn.sourceforge.net/gmod/?rev=24902&view=rev
Author:   nm249
Date:     2011-05-11 16:36:50 +0000 (Wed, 11 May 2011)

Log Message:
-----------
removed NOT NULL constraint from nd_experimentprop.value. added type_id (cvterm FK) to nd_protocol 

Modified Paths:
--------------
    schema/trunk/chado/modules/natural_diversity/natural_diversity.sql

Modified: schema/trunk/chado/modules/natural_diversity/natural_diversity.sql
===================================================================
--- schema/trunk/chado/modules/natural_diversity/natural_diversity.sql	2011-05-09 20:14:55 UTC (rev 24901)
+++ schema/trunk/chado/modules/natural_diversity/natural_diversity.sql	2011-05-11 16:36:50 UTC (rev 24902)
@@ -63,7 +63,7 @@
     nd_experimentprop_id serial PRIMARY KEY NOT NULL,
     nd_experiment_id integer NOT NULL references nd_experiment (nd_experiment_id) on delete cascade INITIALLY DEFERRED,
     type_id integer NOT NULL references cvterm (cvterm_id) on delete cascade INITIALLY DEFERRED ,
-    value character varying(255) NOT NULL,
+    value character varying(255),
     rank integer NOT NULL default 0,
     constraint nd_experimentprop_c1 unique (nd_experiment_id,type_id,rank)
 );
@@ -104,7 +104,8 @@
 
 CREATE TABLE nd_protocol (
     nd_protocol_id serial PRIMARY KEY  NOT NULL,
-    name character varying(255) NOT NULL unique
+    name character varying(255) NOT NULL unique,
+    type_id integer NOT NULL references cvterm (cvterm_id) on delete cascade INITIALLY DEFERRED
 );
 
 COMMENT ON TABLE nd_protocol IS 'A protocol can be anything that is done as part of the experiment.';


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.