[basedb-cvs] basedb base_pg.sql,1.4,1.5

[<tr...@us...>]

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)
  );