c0a6048e07b4cae079738ca5b3cb076493dbd19e braney Fri Jan 4 10:00:37 2019 -0800 modify some knownGene SQL files to use full query for index #22713 diff --git src/hg/lib/knownTo.sql src/hg/lib/knownTo.sql index 9f4f8b5..935de59 100644 --- src/hg/lib/knownTo.sql +++ src/hg/lib/knownTo.sql @@ -1,13 +1,13 @@ # knownTo.sql was originally generated by the autoSql program, which also # generated knownTo.c and knownTo.h. This creates the database representation of # an object which can be loaded and saved from RAM in a fairly # automatic way. #Map known gene to some other id CREATE TABLE knownTo ( name varchar(255) not null, # Same as name field in known gene value varchar(255) not null, # Other id #Indices - INDEX(name(12)), - INDEX(value(12)) + INDEX(name), + INDEX(value) );