-- drop table summarybed_1;
-- drop table agbed_1;
-- table for summary data
/*
create table summarybed_1 (
  chromosome varchar(8) not null, 
  startpos bigint not null,
  endpos bigint not null,
  peakval int(15) not null,
  directionality enum('+','-'),
  regulation varchar(50) default NULL,
  summarybed_id int(11) auto_increment primary key
--  rawbed_id int(11),
--  experiment_id int(11) not null
) engine=InnoDB default charset=utf8;

LOAD DATA LOCAL INFILE "GHcont_responsive_DHS.txt"
INTO TABLE summarybed_1
FIELDS TERMINATED BY "\t";

-- table for annotated data
create table agbed_1 (
--  agbed_id int(11) auto_increment primary key,
--  experiment_id int(11), -- optional
  chromosome varchar(8) not null,
  startpos bigint not null,
  endpos bigint not null,
--  accession varchar(32) not null,
  directionality enum('+', '-'),  
  gene varchar(32) not null
--  source varchar(128)
) engine=InnoDB default charset=utf8;

LOAD DATA LOCAL INFILE "mm9Refseq.txt"
INTO TABLE agbed_1
FIELDS TERMINATED BY "\t";
*/

create table rawbed_1 (
  rawbed_id int(11) auto_increment primary key,
--  experiment_id int(11) not null,
  filepath varchar(128) not null,
  chromosome varchar(8) not null
) engine=InnoDB default charset=utf8;

INSERT INTO rawbed_1 (filepath, chromosome) VALUES('/var/www/DASR_2011/DB\ Data/Type\ A\ \ sequence\ reads/chr1.bed', 'chr1');




