-- updated 040427 DDH
-- 29Nov2004 NL changed restriction.site and .cleavage from varchar(25) to varchar(50) to avoid truncation
 
-- Company: removed
-- Reference: removed
-- Remark: removed

create table restrictionenzyme (
	id integer auto_increment primary key,
	name varchar(255),
	-- Site
	site varchar(50),
	-- Offset
	offset varchar(25),
	-- Cleavage
	cleavage varchar(50),
	-- Overhang
	overhang varchar(25),
	-- Isoschizomers
	isoschizomerof_restrictionenzymeid integer
) ENGINE=InnoDB;
create index name_index on restrictionenzyme (name);
create index isoschizomerof_restrictionenzymeid_index on restrictionenzyme (isoschizomerof_restrictionenzymeid);

create table restrictionenzymeisoschizomer (
	id integer auto_increment primary key,
	restrictionenzymeid integer,
	-- Isoschizomers
	isoschizomer_restrictionenzymeid integer
) ENGINE=InnoDB;
create index restrictionenzymeid_index on restrictionenzymeisoschizomer (restrictionenzymeid);
create index isoschizomer_restrictionenzymeid_index on restrictionenzymeisoschizomer (isoschizomer_restrictionenzymeid);