From: Scott C. <sco...@us...> - 2004-10-18 09:16:11
|
Update of /cvsroot/gmod/schema/chado/modules/cv In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv15287/modules/cv Modified Files: cv.sql Log Message: change the length of cvterm varchars Index: cv.sql =================================================================== RCS file: /cvsroot/gmod/schema/chado/modules/cv/cv.sql,v retrieving revision 1.24 retrieving revision 1.25 diff -C2 -d -r1.24 -r1.25 *** cv.sql 22 Jul 2004 21:36:18 -0000 1.24 --- cv.sql 18 Oct 2004 09:16:03 -0000 1.25 *************** *** 8,12 **** cv_id serial not null, primary key (cv_id), ! name varchar(255) not null, definition text, constraint cv_c1 unique (name) --- 8,12 ---- cv_id serial not null, primary key (cv_id), ! name varchar(1024) not null, definition text, constraint cv_c1 unique (name) *************** *** 22,26 **** cv_id int not null, foreign key (cv_id) references cv (cv_id) on delete cascade INITIALLY DEFERRED, ! name varchar(255) not null, definition text, dbxref_id int, --- 22,26 ---- cv_id int not null, foreign key (cv_id) references cv (cv_id) on delete cascade INITIALLY DEFERRED, ! name varchar(1024) not null, definition text, dbxref_id int, *************** *** 87,91 **** cvterm_id int not null, foreign key (cvterm_id) references cvterm (cvterm_id) on delete cascade INITIALLY DEFERRED, ! synonym varchar(255) not null, constraint cvtermsynonym_c1 unique (cvterm_id,synonym) ); --- 87,91 ---- cvterm_id int not null, foreign key (cvterm_id) references cvterm (cvterm_id) on delete cascade INITIALLY DEFERRED, ! synonym varchar(1024) not null, constraint cvtermsynonym_c1 unique (cvterm_id,synonym) ); |