src/hg/lib/t2g.sql 1.1

Index: src/hg/lib/t2g.sql
===================================================================
RCS file: src/hg/lib/t2g.sql
diff -N src/hg/lib/t2g.sql
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ src/hg/lib/t2g.sql	26 May 2010 18:23:29 -0000	1.1
@@ -0,0 +1,19 @@
+#Text to Genome project feature table, in bed12+ format, additional field seqIds
+CREATE TABLE `t2g` (
+  `chrom` varchar(255) NOT NULL, # chromosome
+  `chromStart` int(10) unsigned NOT NULL, # start position on chromosome
+  `chromEnd` int(10) unsigned NOT NULL, # end position on chromosome
+  `name` varchar(255) NOT NULL, #name of feature
+  `score` int(10) unsigned NOT NULL, # score of feature
+  `strand` char(1) NOT NULL, # strand of feature
+  `thickStart` int(10) unsigned NOT NULL, # start of exons
+  `thickEnd` int(10) unsigned NOT NULL, #end of exons
+  `reserved` int(10) unsigned NOT NULL, # no idea
+  `blockCount` int(10) unsigned NOT NULL, # number of blocks
+  `blockSizes` longblob NOT NULL, # size of blocks
+  `chromStarts` longblob NOT NULL, # A comma-separated list of block starts
+  `seqIds` longblob NOT NULL, # comma-separated list of sequenceIds used to generate this feature, require a trailing comma at the end
+  KEY `name` (`name`(16)),
+  KEY `chrom` (`chrom`(6)),
+  KEY `chromStartAndName` (`chrom`(6), chromStart, name)
+);