create table gene2accession(
primary_id BIGINT NOT NULL PRIMARY KEY,
tax_id INT,
gene_id INT,
status varchar(30),
RNA_nuc_access_version varchar(30),
RNA_nuc_gi varchar(30),
protein_access_version varchar(30),
protein_gi varchar(30),
genome_nuc_access_version varchar(30),
genome_nuc_gi varchar(30),
start_pos_gen_access varchar(30),
end_pos_gen_access varchar(30),
orientation varchar(30),
index gene2accession_index_tax (tax_id),
index gene2accession_index_nuc (RNA_nuc_access_version),
index gene2accession_index (gene_id)
);



create table gene2go(
primary_id BIGINT NOT NULL PRIMARY KEY,
tax_id INT,
gene_id INT,
go_id varchar(30),
evidence varchar(250),
qualifier varchar(250),
go_term varchar(250),
pubmed_ids varchar(250),
index gene2go_index (gene_id)
);

create table gene2pubmed(
primary_id BIGINT NOT NULL PRIMARY KEY,
tax_id INT,
gene_id INT,
pubmed_id varchar(30),
index gene2pubmed_index (gene_id)
);

create table gene2refseq(
primary_id BIGINT NOT NULL PRIMARY KEY,
tax_id INT,
gene_id INT,
status varchar(30),
RNA_nuc_access_version varchar(30),
RNA_nuc_gi varchar(30),
protein_access_version varchar(30),
protein_gi varchar(30),
genome_nuc_access_version varchar(30),
genome_nuc_gi varchar(30),
start_pos_gen_access varchar(30),
end_pos_gen_access varchar(30),
orientation varchar(30),
assembly varchar(30),
index gene2refseq_index_protein (protein_access_version),
index gene2refseq_index_nuc (RNA_nuc_access_version),
index gene2refseq_index_tax (tax_id),
index gene2refseq_index (gene_id)
);

create table gene2sts(
primary_id BIGINT NOT NULL PRIMARY KEY,
gene_id INT,
UniSTS_id varchar(30),
index gene2sts_index (gene_id)
);

create table gene2unigene(
primary_id BIGINT NOT NULL PRIMARY KEY,
gene_id INT,
unigene_cluster varchar(30),
index gene2unigene_index (gene_id)
);

create table gene_history(
primary_id BIGINT NOT NULL PRIMARY KEY,
tax_id INT,
gene_id INT,
disc_gene_id INT,
disc_symbol varchar(30),
index gene_history_index (gene_id)
);

create table gene_info(
primary_id BIGINT NOT NULL PRIMARY KEY,
tax_id INT,
gene_id INT,
symbol varchar(50),
locusTag varchar(30),
synonyms varchar(1000),
dbXrefs varchar(100),
chromosome varchar(30),
map_location varchar(100),
description varchar(3000),
type_of_gene varchar(30),
symbol_nomen varchar(30),
full_name_nomen varchar(250),
status_nomen varchar(30),
index gene_info_indextax (tax_id),
index gene_info_indexsym (symbol_nomen),
index gene_info_index_symbol (symbol),
index gene_info_index (gene_id)
);

create table mim2gene(
primary_id BIGINT NOT NULL PRIMARY KEY,
mim_number INT,
gene_id INT,
type varchar(30),
index mim2gene_index(gene_id)
);

create table generifs_basic(
primary_id BIGINT NOT NULL PRIMARY KEY,
tax_id INT,
gene_id INT,
pubmed_id varchar(250),
last_update varchar(30),
description TEXT (3000),
index generifs_basic_index (gene_id)
);


create table interactions(
primary_id BIGINT NOT NULL PRIMARY KEY,
1_tax_id INT,
1_gene_id INT,
1_accn_vers varchar(30),
1_name TEXT(300),
keyphrase varchar(250),
2_tax_id INT,
2_interactant_id varchar(30),
2_interactant_id_type varchar(30),
2_accn_vers varchar(30),
2_name TEXT(300),
complex_id varchar(50),
complex_id_type varchar(30),
complex_name varchar(250),
pubmed_id_list TEXT(500),
last_mod varchar(30),
generif_text TEXT (260),
source_interactant_id varchar(30),
source_interactant_id_type varchar(30),
index interactions_index (1_gene_id)
);

create table tax2name(
tax_id INT,
organism varchar(100),
index tax2name_index (tax_id)
);

create table refSeqSummary(
primary_id BIGINT NOT NULL PRIMARY KEY,
gene_id INT,
mrnaAcc varchar(255) NOT NULL default '',
completeness enum('Unknown','Complete5End','Complete3End','FullLength','IncompleteBothEnds','Incomplete5End','Incomplete3End','Partial') NOT NULL default 'Unknown',
summary text NOT NULL,
index refSeqSummary_index (mrnaAcc),
index refSeqSummary_indexgene (gene_id)
);