Dear all,
even though we may not be doing much on BASE anytime soon, I still thought it
might be useful to share a relatively recent patch of ours, which is fairly
minimal, but nonetheless important. It concerns the ubiquitous use of
integers which we think really ought to be reals. The context diff is
appended^Wincluded. If anything, it might provoke some debate on the
issue. Kind regards,
Philip
------------------------------------------------------------------------
Index: base.sql
===================================================================
RCS file: /usr/local/nfs_share/cvsroot/basedb/base.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -c -r1.2 -r1.3
*** base.sql 20 Aug 2002 20:15:55 -0000 1.2
--- base.sql 27 Aug 2002 14:35:54 -0000 1.3
***************
*** 750,770 ****
x mediumint(9) default NULL,
y mediumint(9) default NULL,
dia smallint(6) default NULL,
! FCh1Median smallint(5) unsigned default NULL,
! FCh1Mean smallint(5) unsigned default NULL,
! FCh1SD smallint(5) unsigned default NULL,
! BCh1Median smallint(5) unsigned NOT NULL default '0',
! BCh1Mean smallint(5) unsigned NOT NULL default '0',
! BCh1SD smallint(5) unsigned default NULL,
percCh1SD1 tinyint(4) default NULL,
percCh1SD2 tinyint(4) default NULL,
percCh1Sat tinyint(4) default NULL,
! FCh2Median smallint(5) unsigned default NULL,
! FCh2Mean smallint(5) unsigned default NULL,
! FCh2SD smallint(5) unsigned default NULL,
! BCh2Median smallint(5) unsigned NOT NULL default '0',
! BCh2Mean smallint(5) unsigned NOT NULL default '0',
! BCh2SD smallint(5) unsigned default NULL,
percCh2SD1 tinyint(4) default NULL,
percCh2SD2 tinyint(4) default NULL,
percCh2Sat tinyint(4) default NULL,
--- 750,770 ----
x mediumint(9) default NULL,
y mediumint(9) default NULL,
dia smallint(6) default NULL,
! FCh1Median float default NULL,
! FCh1Mean float default NULL,
! FCh1SD float default NULL,
! BCh1Median float default NULL,
! BCh1Mean float default NULL,
! BCh1SD float default NULL,
percCh1SD1 tinyint(4) default NULL,
percCh1SD2 tinyint(4) default NULL,
percCh1Sat tinyint(4) default NULL,
! FCh2Median float default NULL,
! FCh2Mean float default NULL,
! FCh2SD float default NULL,
! BCh2Median float default NULL,
! BCh2Mean float default NULL,
! BCh2SD float default NULL,
percCh2SD1 tinyint(4) default NULL,
percCh2SD2 tinyint(4) default NULL,
percCh2Sat tinyint(4) default NULL,
------------------------------------------------------------------------
--
Philip Lijnzaad
Genomics Laboratory
Dept. of Biomedical Genetics
University Medical Center (UMC), Utrecht
Stratenum, STR 3.223
P.O. Box 85060, 3508 AB Utrecht
(Universiteitsweg 100, 3584 CG Utrecht)
The Netherlands
tel: +31 (0)30 253 8464
fax: +31 (0)30 253 9035
|