c36eab92d8a9d8cdfd5b7a782b097a3e6f638441
hiram
  Mon Mar 23 18:53:36 2020 -0700
hgFixed.asmEquivalent table definition refs #21074

diff --git src/hg/lib/asmEquivalent.sql src/hg/lib/asmEquivalent.sql
new file mode 100644
index 0000000..66be4e5
--- /dev/null
+++ src/hg/lib/asmEquivalent.sql
@@ -0,0 +1,18 @@
+# asmEquivalent.sql was originally generated by the autoSql program, which also 
+# generated asmEquivalent.c and asmEquivalent.h.  This creates the database representation of
+# an object which can be loaded and saved from RAM in a fairly 
+# automatic way.
+
+#Equivalence relationship of assembly versions, Ensembl: UCSC, NCBI genbank/refseq
+CREATE TABLE asmEquivalent (
+    source varchar(255) not null,	# assembly name
+    destination varchar(255) not null,	# equivalent assembly name
+    sourceAuthority enum("ensembl", "ucsc", "genbank", "refseq") not null,	# origin of source assembly
+    destinationAuthority enum("ensembl", "ucsc", "genbank", "refseq") not null,	# origin of equivalent assembly
+    matchCount int unsigned not null,	# number of exactly matching sequences
+    sourceCount int unsigned not null,	# number of sequences in source assembly
+    destinationCount int unsigned not null,	# number of sequences in equivalent assembly
+              #Indices
+    INDEX (source),
+    INDEX (destination)
+);