b5648914270e1f508c7276e3d0a4318a49898f48 braney Wed Feb 26 14:17:41 2014 -0800 a bunch of changes to SQL files to accomodate a change from TYPE=ISAM toENGINE=ISAM. diff --git src/hg/lib/knownGene.sql src/hg/lib/knownGene.sql index a23e6be..b0c0a6a 100644 --- src/hg/lib/knownGene.sql +++ src/hg/lib/knownGene.sql @@ -5,17 +5,17 @@ strand char(1) NOT NULL default '', # Strand, + or - txStart int(10) unsigned NOT NULL default '0',# Transcription start position txEnd int(10) unsigned NOT NULL default '0', # Transcription end position cdsStart int(10) unsigned NOT NULL default '0',# Coding region start cdsEnd int(10) unsigned NOT NULL default '0', # Coding region end exonCount int(10) unsigned NOT NULL default '0', # Number of exons exonStarts longblob NOT NULL, # Exon start positions exonEnds longblob NOT NULL, # Exon end positions proteinID varchar(40) NOT NULL default '', # UniProt display ID for Known Genes, UniProt accession or RefSeq protein ID for UCSC Genes alignID varchar(255) NOT NULL default '', # Unique identifier for each alignment KEY name (name), KEY chrom (chrom(16),txStart), KEY chrom_2 (chrom(16),txEnd), KEY protein (proteinID(16)), KEY align (alignID) -) TYPE=MyISAM; +) ENGINE=MyISAM;