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

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

Update of /cvsroot/basedb/basedb
In directory usw-pr-cvs1:/tmp/cvs-serv31316

Modified Files:
	base_pg.sql 
Log Message:
Changed smallint to float (should have been unsigned smallint, but there's no such type in pgsql)

Index: base_pg.sql
===================================================================
RCS file: /cvsroot/basedb/basedb/base_pg.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** base_pg.sql	9 Sep 2002 19:53:54 -0000	1.3
--- base_pg.sql	10 Sep 2002 09:31:04 -0000	1.4
***************
*** 212,222 ****
  CREATE TABLE BioAssaySetCreation (
  	"bioAssaySet" integer DEFAULT '0' NOT NULL,
! 	"partMeanFG" double precision DEFAULT '0' NOT NULL,
! 	"partMedianFG" double precision DEFAULT '0' NOT NULL,
! 	"partMeanBG" double precision DEFAULT '0' NOT NULL,
! 	"partMedianBG" double precision DEFAULT '0' NOT NULL,
! 	"partMeanMeanBG" double precision DEFAULT '0' NOT NULL,
! 	"partMeanMedianBG" double precision DEFAULT '0' NOT NULL,
! 	"partTotalIntensity" double precision DEFAULT '0' NOT NULL,
  	Constraint BioAssaySetCreation_pkey Primary Key ("bioAssaySet")
[...114 lines suppressed...]
! 	"CV" real,
  	Constraint RawBioAssayData_pkey Primary Key ("rawBioAssay", position)
  );
***************
*** 1388,1394 ****
  	position integer DEFAULT '0' NOT NULL,
  	molecule integer DEFAULT '0' NOT NULL,
! 	intensity1 double precision DEFAULT '0' NOT NULL,
! 	intensity2 double precision DEFAULT '0' NOT NULL,
! 	ratio double precision DEFAULT '0' NOT NULL,
  	Constraint TemplateBioAssayData_pkey Primary Key ("bioAssay", position)
  );
--- 1388,1394 ----
  	position integer DEFAULT '0' NOT NULL,
  	molecule integer DEFAULT '0' NOT NULL,
! 	intensity1 real DEFAULT '0' NOT NULL,
! 	intensity2 real DEFAULT '0' NOT NULL,
! 	ratio real DEFAULT '0' NOT NULL,
  	Constraint TemplateBioAssayData_pkey Primary Key ("bioAssay", position)
  );