-- updated 040507 DDH
-- 29Nov2004 NL changed protein.title from varchar to text to avoid truncation

-- Peptide[1]: removed
-- Database[2]: removed
-- From_Database[1]: removed
-- Pep_homol: removed

create table protein (
	id integer auto_increment primary key,
	name varchar(255),
	-- Peptide[0]
	peptideid integer,
	-- Title
	title text,
	-- Corresponding_DNA
	correspondingsequence_sequenceid integer,
	-- From_Database[0]
	fromdatabase varchar(100)
) ENGINE=InnoDB;
create index name_index on protein (name);
create index peptideid_index on protein (peptideid);
create index correspondingsequence_sequenceid_index on protein (correspondingsequence_sequenceid);

create table proteinexternaldb (
	id integer auto_increment primary key,
	proteinid integer,
	-- Database[0]
	name varchar(100),
	-- Database[1]
	accession varchar(100),
	url varchar(100)
) ENGINE=InnoDB;
create index proteinid_index on proteinexternaldb (proteinid);

create table proteinblasthits (
	id integer auto_increment primary key,
	proteinid integer,
	blasttype varchar(25),
	dbname varchar(100),
	dbversion varchar(100),
	-- DNA_homol
	accession varchar(25),
	title varchar(255),
	evalue float,
	score integer,
	querybegin integer,
	queryend integer,
	subjectbegin integer,
	subjectend integer
) ENGINE=InnoDB;
create index proteinid_index on proteinblasthits (proteinid);
create index accession_index on proteinblasthits (accession);
create index title_index on proteinblasthits (title);