2797186e7d69a8b79b92e30118bed55548f04caf
hiram
  Thu Feb 8 14:39:16 2018 -0800
adding externalId column to ncbiRefSeqLink table refs #20215

diff --git src/hg/lib/ncbiRefSeqLink.sql src/hg/lib/ncbiRefSeqLink.sql
index d79f553..f3944f2 100644
--- src/hg/lib/ncbiRefSeqLink.sql
+++ src/hg/lib/ncbiRefSeqLink.sql
@@ -11,21 +11,22 @@
     product varchar(255) not null,	# product
     mrnaAcc varchar(255) not null,	# transcript_id
     protAcc varchar(255) not null,	# protein_id
     locusLinkId varchar(255) not null,	# locus link identifier, from Dbxref
     omimId varchar(255) not null,	# OMIM identifier, from Dbxref
     hgnc varchar(255) not null,		# HGNC identifier, from Dbxref
     genbank varchar(255) not null,	# genbank identifier from Dbxref
     pseudo varchar(255) not null,	# 'true' if pseudo gene, or n/a
     gbkey varchar(255) not null,	# genbank key: Gene, mRNA, ncRNA, rRNA, tRNA, etc...
     source varchar(255) not null,	# source: RefSeq, tRNAscan-SE, Gnomon, Curated Genomic, BestRefSeq
     gene_biotype varchar(255) not null,	# bio type: protein_coding, pseudogene, C_region, J_segment_pseudogene, other
     gene_synonym varchar(255) not null,	# list of synonym names
     ncrna_class varchar(255) not null,	# type of RNA: miRNA, lncRNA, snoRNA, etc...
     note longblob not null,		# other notes from genbank record
     description longblob not null,	# description from rna gbff record via gbProcess
+    externalId varchar(255) not null,	# for outside URL link, WormBase, FlyBase, RGD, SGD, etc... from Dbxref
               #Indices
     PRIMARY KEY(id),
     index(name),
     index(mrnaAcc),
     index(protAcc)
 );