User:Lindenb/Notebook/UMR915/20100630
From OpenWetWare
![](https://s3-us-west-2.amazonaws.com/oww-files-public/f/f8/Owwnotebook_icon.png)
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;