-- updated 040423 DDH

-- Linkage_data: removed
-- Extent: removed
-- Default_view: removed
-- Minimal_view: removed
-- View: removed
-- From_map: removed
-- Author: removed
-- Date: removed
-- Main_Locus: removed
-- Band: removed
-- Interval: removed
-- Contig: removed
-- map_position.Multi_Position: removed
-- map_position.Multi_Ends: removed
-- map_position.With_locus: removed

create table map (
	id integer auto_increment primary key,
	name varchar(255),
	-- Mapping_data
	mapdataid integer,
	-- Flipped
	flipped tinyint(1),
	-- Unit
	unit varchar(25),
	-- Centre
	viewrangebegin float,
	viewrangeend float
) ENGINE=InnoDB;
create index name_index on map (name);
create index mapdataid_index on map (mapdataid);

create table maptype (
	id integer auto_increment primary key,
	mapid integer,
	-- Type
	type varchar(100)
) ENGINE=InnoDB;
create index mapid_index on maptype (mapid);

create table mapspecies (
	id integer auto_increment primary key,
	mapid integer,
	-- Species
	speciesid integer
) ENGINE=InnoDB;
create index mapid_index on mapspecies (mapid);
create index speciesid_index on mapspecies (speciesid);

create table mapremark (
	id integer auto_increment primary key,
	mapid integer,
	-- Remark
	type varchar(50),
	remark text
) ENGINE=InnoDB;
create index mapid_index on mapremark (mapid);

create table maplocus (
	id integer auto_increment primary key,
	mapid integer,
	-- Locus
	locusid integer,
	-- map_position.Position, map_position.Left
	begin float,
	-- map_error.Error
	beginerror float,
	-- map_position.Right
	end float
) ENGINE=InnoDB;
create index mapid_index on maplocus (mapid);
create index locusid_index on maplocus (locusid);

create table mapchromband (
	id integer auto_increment primary key,
	mapid integer,
	-- Chrom_Band
	chrombandid integer,
	-- map_position.Position, map_position.Left
	begin float,
	-- map_error.Error
	beginerror float,
	-- map_position.Right
	end float
) ENGINE=InnoDB;
create index mapid_index on mapchromband (mapid);
create index chrombandid_index on mapchromband (chrombandid);

create table maprearrangement (
	id integer auto_increment primary key,
	mapid integer,
	-- Rearrangement
	rearrangementid integer,
	-- map_position.Position, map_position.Left
	begin float,
	-- map_error.Error
	beginerror float,
	-- map_position.Right
	end float
) ENGINE=InnoDB;
create index mapid_index on maprearrangement (mapid);
create index rearrangementid_index on maprearrangement (rearrangementid);

create table mapbreakpoint (
	id integer auto_increment primary key,
	mapid integer,
	-- Breakpoint
	breakpointid integer,
	-- map_position.Position, map_position.Left
	begin float,
	-- map_error.Error
	beginerror float,
	-- map_position.Right
	end float
) ENGINE=InnoDB;
create index mapid_index on mapbreakpoint (mapid);
create index breakpointid_index on mapbreakpoint (breakpointid);

create table mapbreakpointinterval (
	id integer auto_increment primary key,
	mapid integer,
	-- Breakpoint_interval
	breakpointintervalid integer,
	-- map_position.Position, map_position.Left
	begin float,
	-- map_error.Error
	beginerror float,
	-- map_position.Right
	end float
) ENGINE=InnoDB;
create index mapid_index on mapbreakpointinterval (mapid);
create index breakpointintervalid_index on mapbreakpointinterval (breakpointintervalid);

create table mapqtl (
	id integer auto_increment primary key,
	mapid integer,
	-- QTL
	qtlid integer,
	-- map_position.Position, map_position.Left
	begin float,
	-- map_error.Error
	beginerror float,
	-- map_position.Right
	end float
) ENGINE=InnoDB;
create index mapid_index on mapqtl (mapid);
create index qtlid_index on mapqtl (qtlid);

create table mapbin (
	id integer auto_increment primary key,
	mapid integer,
	-- Bin
	binid integer,
	-- map_position.Position, map_position.Left
	begin float,
	-- map_error.Error
	beginerror float,
	-- map_position.Right
	end float
) ENGINE=InnoDB;
create index mapid_index on mapbin (mapid);
create index binid_index on mapbin (binid);