User:Lindenb/Notebook/UMR915/20100630

=BAM DB= creating a db to store the path to the BAM, will be used to display the reads at a given location. create table bam(  id int unsigned not null primary key auto_increment,   filename varchar(255) not null,   description text,   sample_id int unsigned not null, index(sample_id), foreign key(sample_id) references sample(id) on delete RESTRICT,   meta text,   creation datetime,   modified timestamp   ) engine=InnoDB;