src/hg/lib/encode/broadPeak.sql 1.3

Index: src/hg/lib/encode/broadPeak.sql
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/lib/encode/broadPeak.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -b -B -U 1000000 -r1.2 -r1.3
--- src/hg/lib/encode/broadPeak.sql	24 Oct 2008 19:17:50 -0000	1.2
+++ src/hg/lib/encode/broadPeak.sql	6 Apr 2009 05:09:44 -0000	1.3
@@ -1,19 +1,22 @@
 # broadPeak.sql was originally generated by the autoSql program, which also
 # generated broadPeak.c and broadPeak.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly
 # automatic way.
 
 #peaks of signal enrichment based on pooled, normalized (interpreted) data. It is a BED6+3 format
 CREATE TABLE broadPeak (
     chrom varchar(255) not null,	# Name of the chromosome
     chromStart int unsigned not null,	# Start position in chromosome
     chromEnd int unsigned not null,	# End position in chromosome
     name varchar(255) not null,	# Optional. Name given to a region (preferably unique). Use . if no name is assigned.
     score int unsigned not null,	# Optional. Indicates how dark the peak will be displayed in the browser (1-1000). If '0', the DCC will assign this based on signal value. Ideally average signalValue per base spread between 100-1000.
     strand char(2) not null,	# Optional. +/- to denote strand or orientation (whenever applicable). Use '.' if no orientation is assigned.
     signalValue float not null,	# Measurement of average enrichment for the region
     pValue float not null default -1,	# Within dataset statistical significance of signal value (-log10)
     qValue float not null default -1,	# Cross-dataset statistical significance of signal value (-log10)
               #Indices
     INDEX chromStart (chrom(8), chromStart)
-);
+)
+AVG_ROW_LENGTH = 40
+MAX_ROWS = 200000000000
+;