5265349367cdbf70dbcf82d2c86e6e39d2df0eaa
fanhsu
  Tue Mar 1 15:48:27 2011 -0800
Created omimAv.sql.
diff --git src/hg/lib/omimAv.sql src/hg/lib/omimAv.sql
new file mode 100644
index 0000000..16f3fa6
--- /dev/null
+++ src/hg/lib/omimAv.sql
@@ -0,0 +1,15 @@
+CREATE TABLE omimAv (
+    avId varchar(40) not null,	# MIM AV Number
+    omimId int not null,	# MIM ID
+    seqNo  int not null,	# sequence number
+    
+    geneSymbol varchar(255),	# gene symbol
+    replacement varchar(255),	# AA replacement
+    repl1 varchar(255),	# part 1 of replacement
+    repl2 varchar(255),	# part 2 of replacement
+    dbSnpId varchar(255),	# dbSNP ID if available
+              #Indices
+    description blob,
+    KEY(avId),
+    KEY(omimId)
+);