a80a8de2fc8f3573cd184b2a4032afff1f959e16
kate
  Wed Jan 17 16:19:15 2018 -0800
First cut of interact track type.  Same display as longTabix, but with new schema to support phase 2 features. refs #17512

diff --git src/hg/lib/interact.sql src/hg/lib/interact.sql
new file mode 100644
index 0000000..a940a56
--- /dev/null
+++ src/hg/lib/interact.sql
@@ -0,0 +1,26 @@
+# interact.sql was originally generated by the autoSql program, which also 
+# generated interact.c and interact.h.  This creates the database representation of
+# an object which can be loaded and saved from RAM in a fairly 
+# automatic way.
+
+#Interaction between two regions
+CREATE TABLE interact (
+    bin smallint not null,              # Bin number for browser speedup
+    chrom varchar(255) not null,	# Chromosome (or contig, scaffold, etc.). For interchromosomal, use 2 records
+    chromStart int unsigned not null,	# Start position in chromosome of lower region
+    chromEnd int unsigned not null,	# End position in chromosome of upper region. For interchromosomal, set to chromStart+1
+    name varchar(255) not null,	# Name of item, for display.  Usually 'name1/name2' or empty
+    score int unsigned not null,	# Score from 0-1000
+    strand char(1) not null,	# Direction of interaction (+ or -)
+    color int unsigned not null,	# Item color, as itemRgb in bed9
+    chrom1 varchar(255) not null,	# Chromosome of first region
+    chromStart1 int unsigned not null,	# Start position in chromosome of first region
+    chromEnd1 int unsigned not null,	# End position in chromosome of first region
+    name1 varchar(255) not null,	# Identifier of first region. Can be used as link to related table
+    chrom2 varchar(255) not null,	# Chromosome of second region
+    chromStart2 int unsigned not null,	# Start position in chromosome of second region
+    chromEnd2 int unsigned not null,	# End position in chromosome of second region
+    name2 varchar(255) not null,	# Identifier of second region. Can be used as link to related table
+              #Indices
+    INDEX(chrom(20), chromStart)
+);