src/hg/encode/expTblTools/loadCVTbl 1.2

Index: src/hg/encode/expTblTools/loadCVTbl
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/encode/expTblTools/loadCVTbl,v
retrieving revision 1.1
retrieving revision 1.2
diff -b -B -U 4 -r1.1 -r1.2
--- src/hg/encode/expTblTools/loadCVTbl	3 Jun 2010 00:04:58 -0000	1.1
+++ src/hg/encode/expTblTools/loadCVTbl	3 Jun 2010 23:30:30 -0000	1.2
@@ -33,14 +33,16 @@
 
 ################################################################################
 
 my $commentedout = <<EOS;
+# cell table
 CREATE TABLE cell (
     name VARCHAR(255) NOT NULL,
     tag VARCHAR(255) NOT NULL,
     organism VARCHAR(255) NOT NULL,
-    category VARCHAR(20),
+    Category VARCHAR(20),
     description TEXT,
+    tissue VARCHAR(255),
     vendorName TEXT,
     vendorId VARCHAR(255),
     orderUrl VARCHAR(255),
     karyotype VARCHAR(255),
@@ -52,15 +54,57 @@
     tier INT,
     protocol VARCHAR(255),
     PRIMARY KEY (name)
 );
+
+#antibody table
+CREATE TABLE antibody (
+    name VARCHAR(255) NOT NULL,
+    tag VARCHAR(255) NOT NULL,
+    displayName VARCHAR(255) DEFAULT "Not Decided",
+    antibodyDescription TEXT,
+    validation VARCHAR(255),
+    lab VARCHAR(255),
+    targetId VARCHAR(255),
+    targetDescription TEXT,
+    targetUrl VARCHAR(255),
+    geneId VARCHAR(255),
+    vendorName VARCHAR(255),
+    vendorId VARCHAR(255),
+    lots VARCHAR(255),
+    orderUrl VARCHAR(255),
+    PRIMARY KEY (name)
+);
+
+#protocol table
+CREATE TABLE protocol (
+    name VARCHAR(255) NOT NULL,
+    tag VARCHAR(255) NOT NULL,
+    description VARCHAR(255) NOT NULL
+);
+
+#treatment table
+CREATE TABLE treatment (
+    name VARCHAR(255) NOT NULL,
+    tag VARCHAR(255) NOT NULL,
+    description VARCHAR(255),
+    label VARCHAR(255) DEFAULT "Not Decided"
+);
+
+#control table
+CREATE TABLE control (
+    name VARCHAR(255) NOT NULL,
+    tag VARCHAR(255) NOT NULL,
+    description VARCHAR(255)
+);
+
 EOS
 
 ################################################################################
 
 my %termToColumnMapper = (
     "term" => "name",
-    "Category" => "category",
+    "Lots" => "lots" # not sure why the term is spelled different need to investigate
 );
 
 sub mapTermToColumn { 
     my $term = shift;