src/hg/lib/gsidSubjInfo3.sql 1.1

1.1 2009/04/16 17:36:38 fanhsu
Getting ready for the next wave of new data items.

Index: src/hg/lib/gsidSubjInfo3.sql
===================================================================
RCS file: src/hg/lib/gsidSubjInfo3.sql
diff -N src/hg/lib/gsidSubjInfo3.sql
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ src/hg/lib/gsidSubjInfo3.sql	16 Apr 2009 17:36:38 -0000	1.1
@@ -0,0 +1,18 @@
+CREATE TABLE gsidSubjInfo3 (
+  subjId varchar(255) NOT NULL default '',
+  age varchar(255) NOT NULL default '',
+  gender varchar(255) NOT NULL default '',
+  race varchar(255) NOT NULL default '',
+  weight varchar(255) NOT NULL default '',
+  immunStatus varchar(255) NOT NULL default '',
+  geography varchar(255) NOT NULL default '',
+  injections int(11) NOT NULL default '0',
+  riskFactor varchar(255) NOT NULL default '',
+  daysInfectF int(11) NOT NULL default '0',
+  daysInfectL int(11) NOT NULL default '0',
+  comment varchar(255) NOT NULL default '',
+  newField1 varchar(255) NOT NULL default '',
+  newField2 varchar(255) NOT NULL default '',
+  KEY subjId (subjId)
+) TYPE=MyISAM;
+