Update of /cvsroot/basedb/basedb
In directory usw-pr-cvs1:/tmp/cvs-serv23365
Modified Files:
base_pg.sql
Log Message:
Changed char to varchar, renamed some constraints
Index: base_pg.sql
===================================================================
RCS file: /cvsroot/basedb/basedb/base_pg.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** base_pg.sql 10 Sep 2002 09:31:04 -0000 1.4
--- base_pg.sql 10 Sep 2002 10:58:47 -0000 1.5
***************
*** 730,734 ****
sequence text DEFAULT '' NOT NULL,
length smallint DEFAULT '0' NOT NULL,
! species character(2) DEFAULT '' NOT NULL,
"clusterId" integer DEFAULT '0' NOT NULL,
"cloneId" character varying(255) DEFAULT '' NOT NULL,
--- 730,734 ----
sequence text DEFAULT '' NOT NULL,
length smallint DEFAULT '0' NOT NULL,
! species character varying(2) DEFAULT '' NOT NULL,
"clusterId" integer DEFAULT '0' NOT NULL,
"cloneId" character varying(255) DEFAULT '' NOT NULL,
***************
*** 738,742 ****
accession character varying(20) DEFAULT '' NOT NULL,
nid character varying(20) DEFAULT '' NOT NULL,
! chromosome character(3) DEFAULT '' NOT NULL,
"cytoBand" character varying(30) DEFAULT '' NOT NULL,
"geneName" text DEFAULT '' NOT NULL,
--- 738,742 ----
accession character varying(20) DEFAULT '' NOT NULL,
nid character varying(20) DEFAULT '' NOT NULL,
! chromosome character varying(3) DEFAULT '' NOT NULL,
"cytoBand" character varying(30) DEFAULT '' NOT NULL,
"geneName" text DEFAULT '' NOT NULL,
***************
*** 896,900 ****
name character varying(40) DEFAULT '' NOT NULL,
"lastTouched" timestamp with time zone NOT NULL,
! CONSTRAINT Preset_type CHECK ("searchType" IN ('sample','arraytype','extract','hybridization','plate','user','value','labeled','raw','exp','gene','array','molecule','upload')),
Constraint Preset_pkey Primary Key (search)
);
--- 896,900 ----
name character varying(40) DEFAULT '' NOT NULL,
"lastTouched" timestamp with time zone NOT NULL,
! CONSTRAINT Preset_searchType CHECK ("searchType" IN ('sample','arraytype','extract','hybridization','plate','user','value','labeled','raw','exp','gene','array','molecule','upload')),
Constraint Preset_pkey Primary Key (search)
);
***************
*** 962,970 ****
name character varying(40) DEFAULT '' NOT NULL,
"commonName" character varying(40) DEFAULT '' NOT NULL,
! "valueType" character(2) DEFAULT 'i' NOT NULL,
options text DEFAULT '' NOT NULL,
"defaultValue" text DEFAULT '' NOT NULL,
"enumOptions" text default '' not null,
! CONSTRAINT ProgramParameter_type CHECK ("valueType" IN ('i','f','t','a','n','h','e')),
Constraint ProgramParameter_pkey Primary Key (program, position)
);
--- 962,970 ----
name character varying(40) DEFAULT '' NOT NULL,
"commonName" character varying(40) DEFAULT '' NOT NULL,
! "valueType" character(1) DEFAULT 'i' NOT NULL,
options text DEFAULT '' NOT NULL,
"defaultValue" text DEFAULT '' NOT NULL,
"enumOptions" text default '' not null,
! CONSTRAINT ProgramParameter_valueType CHECK ("valueType" IN ('i','f','t','a','n','h','e')),
Constraint ProgramParameter_pkey Primary Key (program, position)
);
|
