From OpenWetWare
Jump to: navigation, search
Owwnotebook icon.png

20100629        Top        20100701       


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;