-- updated 040423 DDH

-- Map: chromband->mapchromband->map
-- Drawing: removed
-- Contains: removed
-- Contained_in: removed
-- Inside: removed
-- Positive_pool_probe: removed
-- Contains_breakpoint: removed
-- Does_not_contain_breakpoint: removed

create table chromband (
	id integer auto_increment primary key,
	name varchar(255)
) ENGINE=InnoDB;
create index name_index on chromband (name);

create table chrombandtype (
        id integer auto_increment primary key,
        chrombandid integer,
	-- Type
	type varchar(100)
) ENGINE=InnoDB;
create index chrombandid_index on chrombandtype (chrombandid);

create table chrombandreference (
	id integer auto_increment primary key,
	chrombandid integer,
	-- Reference
	referenceid integer
) ENGINE=InnoDB;
create index chrombandid_index on chrombandreference (chrombandid);
create index referenceid_index on chrombandreference (referenceid);