-- updated 040423 DDH

-- Gene: image->geneimage->gene
-- Locus: image->locusimage->locus
-- Allele: image->alleleimage->allele
-- Pathology: image->pathologyimage->pathology
-- Probe: image->probeimage->probe
-- Polymorphism: image->polymorphismimage->polymorphism
-- QTL: image->qtlimage->qtl
-- Germplasm: image->germplasmimage->germplasm
-- Species: image->speciesimage->species
-- Map: image->mapdataimage->mapdata
-- Colleague: image->colleagueimage->colleague
-- Trait_study: image->traitstudyimage->traitstudy
-- Author: image->authorimage->author
-- Reference: image->referenceimage->reference
-- Linkage_data: removed
-- Continued_in: removed
-- Pick_me_to_call: removed

create table image (
	id integer auto_increment primary key,
	name varchar(255),
	-- Continued_from
	continuedfrom_imageid integer,
	filename varchar(100),
	path varchar(255),
	url varchar(255)
) ENGINE=InnoDB;
create index name_index on image (name);
create index continuedfrom_imageid_index on image (continuedfrom_imageid);

create table imagecaption (
	id integer auto_increment primary key,
	imageid integer,
	-- Caption
	caption text
) ENGINE=InnoDB;
create index imageid_index on imagecaption (imageid);