# bToBeCfg.sql was originally generated by the autoSql program, which also 
# generated bToBeCfg.c and bToBeCfg.h.  This creates the database representation of
# an object which can be loaded and saved from RAM in a fairly 
# automatic way.

#Helper to convert bed files to bed+exp file.
CREATE TABLE bToBeCfg (
    factor varchar(255) not null,	# Protein factor, antibody, etc.
    source varchar(255) not null,	# Cell line, tissue, etc.
    sourceId varchar(255) not null,	# Short ID (one letter usually) for source
    dataSource varchar(255) not null,	# Either 'file' or a database name
    scoreCol int not null,	# Score column Index
    multiplier float not null,	# Multiply by this to get score close to 0-1 range.
    dataTable varchar(255) not null,	# File name or table name
              #Indices
    PRIMARY KEY(factor)
);
