4bb9e8caea515342ba98d3871da76cd4ec69916f
chmalee
  Fri May 1 14:10:00 2026 -0700
Initial myVariants implementation: a form on hgTracks where users can enter item details in one of three ways: hgvs/item search, simple bed form, advanced bed form where additional non-bed fields can dynamically created. Allows changing the color of items, writing descriptions, and editing the items after creation. Show overlaps with hardcoded tracks when hgc page is open (not in the hgc dialog). Next commit has implementation of sharing these tracks with other users

diff --git src/hg/lib/myVariants.sql src/hg/lib/myVariants.sql
new file mode 100644
index 00000000000..7204b1a25ba
--- /dev/null
+++ src/hg/lib/myVariants.sql
@@ -0,0 +1,25 @@
+# An item in a myVariants type track.
+CREATE TABLE myVariants (
+    bin int unsigned not null,    # Bin for range index
+    chrom varchar(255) not null,  # Reference sequence chromosome or scaffold
+    chromStart int unsigned not null,    # Start position in chromosome
+    chromEnd int unsigned not null,      # End position in chromosome
+    name varchar(255) not null,   # Name of item - up to 16 chars
+    score int unsigned not null,  # 0-1000.  Higher numbers are darker.
+    strand char(1) not null,      # + or - for strand
+    thickStart int unsigned not null,    # Start of thick part
+    thickEnd int unsigned not null,      # End position of thick part
+    itemRgb int unsigned not null,   # RGB 8 bits each as in bed
+    description longblob not null,   # Longer item description
+    db varchar(255) not null,        # database name of this annotation
+    ref varchar(255) not null,       # reference allele
+    alt varchar(255) not null,       # alternate allele
+    project varchar(255) not null,   # project name for grouping variants
+    mouseover varchar(255) not null, # short mouseover text for hover display
+    id int auto_increment,           # Unique ID for item
+              #Indices
+    PRIMARY KEY(id),
+    INDEX(chrom(16),bin),
+    INDEX(db),
+    INDEX(project)
+);