6afca455c54a8978418619a55933beb76897e09c
hiram
  Wed Jun 26 14:59:55 2024 -0700
code to work with genomePriority.hgcentral table refs #32897

diff --git src/hg/lib/genomePriority.sql src/hg/lib/genomePriority.sql
new file mode 100644
index 0000000..3c5b336
--- /dev/null
+++ src/hg/lib/genomePriority.sql
@@ -0,0 +1,16 @@
+# genomePriority.sql was originally generated by the autoSql program, which also 
+# generated genomePriority.c and genomePriority.h.  This creates the database representation of
+# an object which can be loaded and saved from RAM in a fairly 
+# automatic way.
+
+#listing all UCSC genomes, dbDb or GenArk, with search priority
+CREATE TABLE genomePriority (
+    name varchar(255) not null,	# UCSC genome: dbDb name or GenArk accession
+    priority int unsigned not null,	# assigned search priority
+    commonName varchar(255) not null,	# a common name
+    scientificName varchar(255) not null,	# binomial scientific name
+    taxId int unsigned not null,	# Entrez taxon ID: www.ncbi.nlm.nih.gov/taxonomy/?term=xxx
+    description varchar(255) not null,	# other description text
+              #Indices
+    PRIMARY KEY(name)
+);