ae3969602106c0229160648f6ff6c87c3ad0de2d
giardine
  Tue Dec 7 14:13:12 2010 -0800
Addition of wiki track and supporting tracks for microattribution reviews (part of the variome project)
diff --git src/hg/lib/variome.sql src/hg/lib/variome.sql
new file mode 100644
index 0000000..bd55ada
--- /dev/null
+++ src/hg/lib/variome.sql
@@ -0,0 +1,29 @@
+# variome.sql was originally generated by the autoSql program, which also 
+# generated variome.c and variome.h.  This creates the database representation of
+# an object which can be loaded and saved from RAM in a fairly 
+# automatic way.
+
+#variome bed 6+ structure
+CREATE TABLE variome (
+    bin smallint unsigned not null,	# used for efficient position indexing
+    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
+    score int unsigned not null,	# Score from 0-1000
+    strand char(1) not null,	# + or -
+    db varchar(36) not null,	# database for item
+    owner varchar(255) not null,	# creator of item
+    color varchar(255) not null,	# rgb color of item (currently unused)
+    class varchar(255) not null,	# classification of item (browser group)
+    creationDate varchar(255) not null,	# date item created
+    lastModifiedDate varchar(255) not null,	# date item last updated
+    descriptionKey varchar(255) not null,	# name of wiki description page
+    id int unsigned not null auto_increment,	# auto-increment item ID
+    geneSymbol varchar(255) not null,	# knownGene kgXref geneSymbol name
+              #Indices
+    PRIMARY KEY(id),
+    INDEX chrom (db,bin,chrom),
+    INDEX name (db,name),
+    INDEX gene (geneSymbol)
+);