ec2755546760d8f741f9b330d0d3ef17f5afc093 kuhn Sun Feb 24 10:08:40 2013 -0800 added some chars to index to accommodate larger chromNames. changed description of some fields diff --git src/hg/lib/cytoBandIdeo.sql src/hg/lib/cytoBandIdeo.sql index de61095..608e5c6 100644 --- src/hg/lib/cytoBandIdeo.sql +++ src/hg/lib/cytoBandIdeo.sql @@ -1,16 +1,16 @@ # cytoBand.sql was originally generated by the autoSql program, which also # generated cytoBand.c and cytoBand.h. This creates the database representation of # an object which can be loaded and saved from RAM in a fairly # automatic way. #Describes the positions of cytogenetic bands with a chromosome CREATE TABLE cytoBandIdeo ( - chrom varchar(255) not null, # Human chromosome number - chromStart int unsigned not null, # Start position in genoSeq - chromEnd int unsigned not null, # End position in genoSeq + chrom varchar(255) not null, # Chromosome number + chromStart int unsigned not null, # Start position of band + chromEnd int unsigned not null, # End position of band name varchar(255) not null, # Name of cytogenetic band gieStain varchar(255) not null, # Giemsa stain results #Indices - PRIMARY KEY(chrom(12),chromStart), - UNIQUE(chrom(12),chromEnd) + PRIMARY KEY(chrom(25),chromStart), + UNIQUE(chrom(25),chromEnd) );