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)
);