fe042be01ed22a4402743cc06b66c1a5c9a0e974
fanhsu
  Tue May 17 15:47:13 2011 -0700
Updated omimGeneMap.sql.
diff --git src/hg/lib/omimGeneMap.sql src/hg/lib/omimGeneMap.sql
index 719bfea..349a59b 100644
--- src/hg/lib/omimGeneMap.sql
+++ src/hg/lib/omimGeneMap.sql
@@ -1,22 +1,22 @@
 CREATE TABLE omimGeneMap (
-    numbering varchar(255) not null,	# Numbering system, in the format  Chromosome.Map_Entry_Number
-    month int not null,	# Month entered
-    day int not null,	# Day entered
+    numbering varchar(10),	# Numbering system, in the format  Chromosome.Map_Entry_Number
+    month int,		# Month entered
+    day int,		# Day entered
     year int not null,	# Year entered
-    location varchar(255) not null,	# Location
-    geneSymbol varchar(255) not null,	# Gene Symbol(s)
-    geneStatus char(1) not null,	# Gene Status
-    title1 varchar(255) not null,	# Title line1
-    title2 varchar(255) not null,	# Title line 2
+    location varchar(40),	# Location
+    geneSymbol varchar(255),	# Gene Symbol(s)
+    geneStatus char(1),	# Gene Status
+    title1 blob,	# Title line1
+    title2 blob,	# Title line 2
     omimId int not null,	# MIM Number
-    method varchar(255) not null,	# Method
-    comment1 varchar(255) not null,	# Comments line 1
-    comment2 varchar(255) not null,	# Comments line 2
-    disorders1 blob not null,	# Disorders line 1
-    disorders2 blob not null,	# Disorders line 2
-    disorders3 blob not null,	# Disorders line 3
-    mouseCorrelate varchar(255) not null,	# Mouse correlate
-    reference varchar(255) not null,	# Reference
+    method blob,	# Method
+    comment1 blob,	# Comments line 1
+    comment2 blob,	# Comments line 2
+    disorders1 blob,	# Disorders line 1
+    disorders2 blob,	# Disorders line 2
+    disorders3 blob,	# Disorders line 3
+    mouseCorrelate blob,# Mouse correlate
+    reference blob,	# Reference
               #Indices
     KEY(omimId)
 );