src/hg/lib/rgdGene2.sql 1.1

Index: src/hg/lib/rgdGene2.sql
===================================================================
RCS file: src/hg/lib/rgdGene2.sql
diff -N src/hg/lib/rgdGene2.sql
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ src/hg/lib/rgdGene2.sql	9 Feb 2010 18:55:13 -0000	1.1
@@ -0,0 +1,15 @@
+CREATE TABLE `rgdGene2` (
+  `name` varchar(255) NOT NULL default '',
+  `chrom` varchar(255) NOT NULL default '',
+  `strand` char(1) NOT NULL default '',
+  `txStart` int(10) unsigned NOT NULL default '0',
+  `txEnd` int(10) unsigned NOT NULL default '0',
+  `cdsStart` int(10) unsigned NOT NULL default '0',
+  `cdsEnd` int(10) unsigned NOT NULL default '0',
+  `exonCount` int(10) unsigned NOT NULL default '0',
+  `exonStarts` longblob NOT NULL,
+  `exonEnds` longblob NOT NULL,
+  KEY `name` (`name`(10)),
+  KEY `chrom` (`chrom`(12),`txStart`),
+  KEY `chrom_2` (`chrom`(12),`txEnd`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;