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

[<sco...@us...>]

Revision: 24124
          http://gmod.svn.sourceforge.net/gmod/?rev=24124&view=rev
Author:   scottcain
Date:     2010-11-10 21:08:40 +0000 (Wed, 10 Nov 2010)

Log Message:
-----------
removing the not null constraint on cvprop.value

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

Modified: schema/trunk/chado/modules/cv/cv.sql
===================================================================
--- schema/trunk/chado/modules/cv/cv.sql	2010-11-10 20:45:46 UTC (rev 24123)
+++ schema/trunk/chado/modules/cv/cv.sql	2010-11-10 21:08:40 UTC (rev 24124)
@@ -296,7 +296,7 @@
     foreign key (cv_id) references cv (cv_id) INITIALLY DEFERRED,
     type_id int not null,
     foreign key (type_id) references cvterm (cvterm_id) INITIALLY DEFERRED,
-    value text not null default '',
+    value text,
     rank int not null default 0,
     constraint cvprop_c1 unique (cv_id,type_id,rank)
 );


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