7fd86d24ec58a7e91f2abcc696bc7c108a866400 max Tue Mar 20 11:43:40 2012 -0700 changed table names in sql files as hiram code review, redmine #7363 diff --git src/hg/lib/t2g.sql src/hg/lib/t2g.sql deleted file mode 100644 index 8a54645..0000000 --- src/hg/lib/t2g.sql +++ /dev/null @@ -1,19 +0,0 @@ -#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, # displayId of article - `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, links out to hgFixed.t2gSequenceAnnot - KEY `name` (`name`(16)), - KEY `chrom` (`chrom`(6)), - KEY `chromStartAndName` (`chrom`(6), chromStart, name) -);