-- updated 040502 DDH

-- Gene: geneproduct->genegeneproduct->gene
-- Species[1]: removed
-- Germplasm[2]: removed
-- Gene_class: removed (see D.M. e-mail 040426)
-- Other_name: removed
-- Type: removed
-- Function: removed
-- RNA_type: removed
-- IUB_number: removed
-- Tissue: removed
-- Organelle: removed
-- Membrane_Associated: removed
-- Pathway: removed
-- Substrate_specificity: removed
-- pH_optimum: removed
-- Temp_optimum: removed
-- Regulation: removed
-- Ancillary_enzyme: removed
-- Catalytic_mechanism: removed
-- Prosthetic_group: removed
-- Isozymes: removed
-- Native_Mr: removed
-- 3D_structure: removed
-- Purification: removed
-- Isoelectric_point: removed
-- Biochemistry: removed
-- Remarks: removed
-- Contact: removed
-- Species[0]: removed (see D.M. e-mail 040426)

create table geneproduct (
	id integer auto_increment primary key,
	name varchar(255),
	-- EC_number
	ecnumber varchar(100)
) ENGINE=InnoDB;
create index name_index on geneproduct (name);

create table geneproductallele (
	id integer auto_increment primary key,
	geneproductid integer,
	-- Allele
	alleleid integer
) ENGINE=InnoDB;
create index geneproductid_index on geneproductallele (geneproductid);
create index alleleid_index on geneproductallele (alleleid);

create table geneproductgermplasm (
	id integer auto_increment primary key,
	geneproductid integer,
	-- Germplasm[0]
	germplasmid integer,
	-- Germplasm[1]
	referenceid integer
) ENGINE=InnoDB;
create index geneproductid_index on geneproductgermplasm (geneproductid);
create index germplasmid_index on geneproductgermplasm (germplasmid);
create index referenceid_index on geneproductgermplasm (referenceid);

create table geneproductreference (
	id integer auto_increment primary key,
	geneproductid integer,
	-- Reference
	referenceid integer
) ENGINE=InnoDB;
create index geneproductid_index on geneproductreference (geneproductid);
create index referenceid_index on geneproductreference (referenceid);

create table geneproductsequence (
	id integer auto_increment primary key,
	geneproductid integer,
	-- Sequence
	sequenceid integer
) ENGINE=InnoDB;
create index geneproductid_index on geneproductsequence (geneproductid);
create index sequenceid_index on geneproductsequence (sequenceid);