4328042324eec8b4bc0e5309c0754b2ebe75c62e markd Mon May 4 21:38:32 2015 -0700 drop grp table before attempting to create (no redmine) diff --git src/hg/lib/grp.sql src/hg/lib/grp.sql index 2fe713c..29293cb 100644 --- src/hg/lib/grp.sql +++ src/hg/lib/grp.sql @@ -1,22 +1,23 @@ # grp.sql was originally generated by the autoSql program, which also # generated grp.c and grp.h. This creates the database representation of # an object which can be loaded and saved from RAM in a fairly # automatic way. #This describes a group of annotation tracks. +DROP TABLE IF EXISTS grp; CREATE TABLE grp ( name varchar(255) not null, # Group name. Connects with trackDb.grp label varchar(255) not null, # Label to display to user priority float not null, # 0 is top #Indices PRIMARY KEY(name) ); INSERT grp VALUES("user", "Custom Tracks", 1); INSERT grp VALUES("map", "Mapping and Sequencing", 2); INSERT grp VALUES("genes", "Genes and Gene Predictions", 3); INSERT grp VALUES("pub", "Phenotype and Literature", 3.5); INSERT grp VALUES("rna", "mRNA and EST", 4); INSERT grp VALUES("regulation", "Expression and Regulation", 5);