User:Lindenb/Notebook/UMR915/20100630
From OpenWetWare
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;