-- MySQL dump 10.10
--
-- Host: localhost    Database: PO_0107
-- ------------------------------------------------------
-- Server version	5.0.22-standard-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `assoc_rel`
--

DROP TABLE IF EXISTS `assoc_rel`;
CREATE TABLE `assoc_rel` (
  `id` int(11) NOT NULL auto_increment,
  `from_id` int(11) NOT NULL,
  `to_id` int(11) NOT NULL,
  `relationship_type_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `from_id` (`from_id`),
  KEY `to_id` (`to_id`),
  KEY `relationship_type_id` (`relationship_type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `association`
--

DROP TABLE IF EXISTS `association`;
CREATE TABLE `association` (
  `id` int(11) NOT NULL auto_increment,
  `term_id` int(11) NOT NULL,
  `gene_product_id` int(11) NOT NULL,
  `is_not` int(11) default NULL,
  `role_group` int(11) default NULL,
  `assocdate` int(11) default NULL,
  `source_db_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `a0` (`id`),
  KEY `source_db_id` (`source_db_id`),
  KEY `a1` (`term_id`),
  KEY `a2` (`gene_product_id`),
  KEY `a3` (`term_id`,`gene_product_id`),
  KEY `a4` (`id`,`term_id`,`gene_product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `association_qualifier`
--

DROP TABLE IF EXISTS `association_qualifier`;
CREATE TABLE `association_qualifier` (
  `id` int(11) NOT NULL auto_increment,
  `association_id` int(11) NOT NULL,
  `term_id` int(11) NOT NULL,
  `value` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  KEY `association_id` (`association_id`),
  KEY `term_id` (`term_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `db`
--

DROP TABLE IF EXISTS `db`;
CREATE TABLE `db` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(55) default NULL,
  `fullname` varchar(255) default NULL,
  `datatype` varchar(255) default NULL,
  `generic_url` varchar(255) default NULL,
  `url_syntax` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `db0` (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `db1` (`name`),
  KEY `db2` (`fullname`),
  KEY `db3` (`datatype`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `dbxref`
--

DROP TABLE IF EXISTS `dbxref`;
CREATE TABLE `dbxref` (
  `id` int(11) NOT NULL auto_increment,
  `xref_key` varchar(255) NOT NULL,
  `xref_keytype` varchar(32) default NULL,
  `xref_dbname` varchar(55) NOT NULL,
  `xref_desc` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `xref_key` (`xref_key`,`xref_dbname`),
  UNIQUE KEY `dx0` (`id`),
  KEY `dx1` (`xref_dbname`),
  KEY `dx2` (`xref_key`),
  KEY `dx3` (`id`,`xref_dbname`),
  KEY `dx4` (`id`,`xref_key`,`xref_dbname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `evidence`
--

DROP TABLE IF EXISTS `evidence`;
CREATE TABLE `evidence` (
  `id` int(11) NOT NULL auto_increment,
  `code` varchar(8) NOT NULL,
  `association_id` int(11) NOT NULL,
  `dbxref_id` int(11) NOT NULL,
  `seq_acc` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `association_id` (`association_id`,`dbxref_id`,`code`),
  UNIQUE KEY `ev0` (`id`),
  KEY `ev1` (`association_id`),
  KEY `ev2` (`code`),
  KEY `ev3` (`dbxref_id`),
  KEY `ev4` (`association_id`,`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `evidence_dbxref`
--

DROP TABLE IF EXISTS `evidence_dbxref`;
CREATE TABLE `evidence_dbxref` (
  `evidence_id` int(11) NOT NULL,
  `dbxref_id` int(11) NOT NULL,
  KEY `evx1` (`evidence_id`),
  KEY `evx2` (`dbxref_id`),
  KEY `evx3` (`evidence_id`,`dbxref_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gene_product`
--

DROP TABLE IF EXISTS `gene_product`;
CREATE TABLE `gene_product` (
  `id` int(11) NOT NULL auto_increment,
  `symbol` varchar(128) NOT NULL,
  `dbxref_id` int(11) NOT NULL,
  `species_id` int(11) default NULL,
  `secondary_species_id` int(11) default NULL,
  `type_id` int(11) default NULL,
  `full_name` text,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `dbxref_id` (`dbxref_id`),
  UNIQUE KEY `g0` (`id`),
  KEY `type_id` (`type_id`),
  KEY `g1` (`symbol`),
  KEY `g2` (`dbxref_id`),
  KEY `g3` (`species_id`),
  KEY `g4` (`id`,`species_id`),
  KEY `g5` (`dbxref_id`,`species_id`),
  KEY `g6` (`id`,`dbxref_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gene_product_count`
--

DROP TABLE IF EXISTS `gene_product_count`;
CREATE TABLE `gene_product_count` (
  `term_id` int(11) NOT NULL,
  `code` varchar(8) default NULL,
  `speciesdbname` varchar(55) NOT NULL,
  `product_count` int(11) NOT NULL,
  KEY `gpc1` (`term_id`),
  KEY `gpc2` (`code`),
  KEY `gpc3` (`speciesdbname`),
  KEY `gpc4` (`term_id`,`code`,`speciesdbname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gene_product_property`
--

DROP TABLE IF EXISTS `gene_product_property`;
CREATE TABLE `gene_product_property` (
  `gene_product_id` int(11) NOT NULL,
  `property_key` varchar(64) NOT NULL,
  `property_val` varchar(255) default NULL,
  UNIQUE KEY `gppu4` (`gene_product_id`,`property_key`,`property_val`),
  KEY `gpp1` (`gene_product_id`),
  KEY `gpp2` (`property_key`),
  KEY `gpp3` (`property_val`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gene_product_seq`
--

DROP TABLE IF EXISTS `gene_product_seq`;
CREATE TABLE `gene_product_seq` (
  `gene_product_id` int(11) NOT NULL,
  `seq_id` int(11) NOT NULL,
  `is_primary_seq` int(11) default NULL,
  KEY `gpseq1` (`gene_product_id`),
  KEY `gpseq2` (`seq_id`),
  KEY `gpseq3` (`seq_id`,`gene_product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `gene_product_synonym`
--

DROP TABLE IF EXISTS `gene_product_synonym`;
CREATE TABLE `gene_product_synonym` (
  `gene_product_id` int(11) NOT NULL,
  `product_synonym` varchar(255) NOT NULL,
  UNIQUE KEY `gene_product_id` (`gene_product_id`,`product_synonym`),
  KEY `gs1` (`gene_product_id`),
  KEY `gs2` (`product_synonym`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `graph_path`
--

DROP TABLE IF EXISTS `graph_path`;
CREATE TABLE `graph_path` (
  `id` int(11) NOT NULL auto_increment,
  `term1_id` int(11) NOT NULL,
  `term2_id` int(11) NOT NULL,
  `distance` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `graph_path0` (`id`),
  KEY `graph_path1` (`term1_id`),
  KEY `graph_path2` (`term2_id`),
  KEY `graph_path3` (`term1_id`,`term2_id`),
  KEY `graph_path4` (`term1_id`,`distance`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `graph_path2term`
--

DROP TABLE IF EXISTS `graph_path2term`;
CREATE TABLE `graph_path2term` (
  `graph_path_id` int(11) NOT NULL,
  `term_id` int(11) NOT NULL,
  `rank` int(11) NOT NULL,
  KEY `graph_path_id` (`graph_path_id`),
  KEY `term_id` (`term_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `instance_data`
--

DROP TABLE IF EXISTS `instance_data`;
CREATE TABLE `instance_data` (
  `release_name` varchar(255) default NULL,
  `release_type` varchar(255) default NULL,
  `release_notes` text,
  UNIQUE KEY `release_name` (`release_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `seq`
--

DROP TABLE IF EXISTS `seq`;
CREATE TABLE `seq` (
  `id` int(11) NOT NULL auto_increment,
  `display_id` varchar(64) default NULL,
  `description` varchar(255) default NULL,
  `seq` mediumtext,
  `seq_len` int(11) default NULL,
  `md5checksum` varchar(32) default NULL,
  `moltype` varchar(25) default NULL,
  `timestamp` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `seq0` (`id`),
  UNIQUE KEY `display_id` (`display_id`,`md5checksum`),
  KEY `seq1` (`display_id`),
  KEY `seq2` (`md5checksum`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `seq_dbxref`
--

DROP TABLE IF EXISTS `seq_dbxref`;
CREATE TABLE `seq_dbxref` (
  `seq_id` int(11) NOT NULL,
  `dbxref_id` int(11) NOT NULL,
  UNIQUE KEY `seq_id` (`seq_id`,`dbxref_id`),
  KEY `seqx0` (`seq_id`),
  KEY `seqx1` (`dbxref_id`),
  KEY `seqx2` (`seq_id`,`dbxref_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `seq_property`
--

DROP TABLE IF EXISTS `seq_property`;
CREATE TABLE `seq_property` (
  `id` int(11) NOT NULL auto_increment,
  `seq_id` int(11) NOT NULL,
  `property_key` varchar(64) NOT NULL,
  `property_val` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `seq_id` (`seq_id`,`property_key`,`property_val`),
  KEY `seqp0` (`seq_id`),
  KEY `seqp1` (`property_key`),
  KEY `seqp2` (`property_val`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `source_audit`
--

DROP TABLE IF EXISTS `source_audit`;
CREATE TABLE `source_audit` (
  `source_path` varchar(255) default NULL,
  `source_type` varchar(255) default NULL,
  `source_md5` char(32) default NULL,
  `source_mtime` int(11) default NULL,
  KEY `fa1` (`source_path`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `species`
--

DROP TABLE IF EXISTS `species`;
CREATE TABLE `species` (
  `id` int(11) NOT NULL auto_increment,
  `ncbi_taxa_id` int(11) default NULL,
  `common_name` varchar(255) default NULL,
  `lineage_string` text,
  `genus` varchar(55) default NULL,
  `species` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `sp0` (`id`),
  UNIQUE KEY `ncbi_taxa_id` (`ncbi_taxa_id`),
  UNIQUE KEY `genus` (`genus`,`species`),
  KEY `sp1` (`ncbi_taxa_id`),
  KEY `sp2` (`common_name`),
  KEY `sp3` (`genus`),
  KEY `sp4` (`species`),
  KEY `sp5` (`genus`,`species`),
  KEY `sp6` (`id`,`ncbi_taxa_id`),
  KEY `sp7` (`id`,`ncbi_taxa_id`,`genus`,`species`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `term`
--

DROP TABLE IF EXISTS `term`;
CREATE TABLE `term` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `term_type` varchar(55) NOT NULL,
  `acc` varchar(255) NOT NULL,
  `is_obsolete` int(11) NOT NULL default '0',
  `is_root` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `acc` (`acc`),
  UNIQUE KEY `t0` (`id`),
  KEY `t1` (`name`),
  KEY `t2` (`term_type`),
  KEY `t3` (`acc`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `term2term`
--

DROP TABLE IF EXISTS `term2term`;
CREATE TABLE `term2term` (
  `id` int(11) NOT NULL auto_increment,
  `relationship_type_id` int(11) NOT NULL,
  `term1_id` int(11) NOT NULL,
  `term2_id` int(11) NOT NULL,
  `complete` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `term1_id` (`term1_id`,`term2_id`,`relationship_type_id`),
  KEY `tt1` (`term1_id`),
  KEY `tt2` (`term2_id`),
  KEY `tt3` (`term1_id`,`term2_id`),
  KEY `tt4` (`relationship_type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `term_audit`
--

DROP TABLE IF EXISTS `term_audit`;
CREATE TABLE `term_audit` (
  `term_id` int(11) NOT NULL,
  `term_loadtime` int(11) default NULL,
  UNIQUE KEY `term_id` (`term_id`),
  KEY `ta1` (`term_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `term_dbxref`
--

DROP TABLE IF EXISTS `term_dbxref`;
CREATE TABLE `term_dbxref` (
  `term_id` int(11) NOT NULL,
  `dbxref_id` int(11) NOT NULL,
  `is_for_definition` int(11) NOT NULL default '0',
  UNIQUE KEY `term_id` (`term_id`,`dbxref_id`,`is_for_definition`),
  KEY `tx0` (`term_id`),
  KEY `tx1` (`dbxref_id`),
  KEY `tx2` (`term_id`,`dbxref_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `term_definition`
--

DROP TABLE IF EXISTS `term_definition`;
CREATE TABLE `term_definition` (
  `term_id` int(11) NOT NULL,
  `term_definition` text NOT NULL,
  `dbxref_id` int(11) default NULL,
  `term_comment` mediumtext,
  `reference` varchar(255) default NULL,
  UNIQUE KEY `term_id` (`term_id`),
  KEY `dbxref_id` (`dbxref_id`),
  KEY `td1` (`term_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `term_synonym`
--

DROP TABLE IF EXISTS `term_synonym`;
CREATE TABLE `term_synonym` (
  `term_id` int(11) NOT NULL,
  `term_synonym` varchar(255) default NULL,
  `acc_synonym` varchar(255) default NULL,
  `synonym_type_id` int(11) NOT NULL,
  UNIQUE KEY `term_id` (`term_id`,`term_synonym`),
  KEY `synonym_type_id` (`synonym_type_id`),
  KEY `ts1` (`term_id`),
  KEY `ts2` (`term_synonym`),
  KEY `ts3` (`term_id`,`term_synonym`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;