7e5c73375ec879890233ed77f22a52fb2f82d9ba angie Wed Jan 27 13:48:51 2016 -0800 Adding taxId column to dbDb.{as,c,h,sql} -- the column seems to have been in our dbDb tables for years, just not in these files. diff --git src/hg/lib/dbDb.sql src/hg/lib/dbDb.sql index 36ab90b..b755023 100644 --- src/hg/lib/dbDb.sql +++ src/hg/lib/dbDb.sql @@ -6,18 +6,19 @@ #Description of annotation database CREATE TABLE dbDb ( name varchar(255) not null, # Short name of database. 'hg8' or the like description varchar(255) not null, # Short description - 'Aug. 8, 2001' or the like nibPath longblob not null, # Path to packed sequence files organism varchar(255) not null, # Common name of organism - first letter capitalized defaultPos varchar(255) not null, # Default starting position active int not null, # Flag indicating whether this db is in active use orderKey int not null, # Int used to control display order within a genome genome varchar(255) not null, # Unifying genome collection to which an assembly belongs scientificName varchar(255) not null, # Genus and species of the organism; e.g. Homo sapiens htmlPath varchar(255) not null, # path in /gbdb for assembly description hgNearOk tinyint not null, # Have hgNear for this? hgPbOk tinyint not null, # Have pbTracks for this? sourceName varchar(255) not null, # Source build/release/version of the assembly + taxId int not null, # NCBI Taxonomy ID for genome #Indices PRIMARY KEY(name) );