HOMD Taxon Hierarchy Tab Delimit Text

-- HOMD database SQL structure Dump
-- http://www.homd.org
-- Generation Time: Apr 29, 2010 at 09:50 AM
-- Server version: 5.0.45

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `HOMD_taxonomy`
--

-- --------------------------------------------------------

--
-- Table structure for table `16S_rRNA_sequence`
--

CREATE TABLE IF NOT EXISTS `16S_rRNA_sequence` (
  `Oral_taxon_id` int(5) NOT NULL,
  `order` int(2) NOT NULL,
  `16S_rRNA_sequence` varchar(100) NOT NULL,
  KEY `Oral_taxon_id` (`Oral_taxon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `community_comments`
--

CREATE TABLE IF NOT EXISTS `community_comments` (
  `id` int(12) NOT NULL auto_increment,
  `Oral_taxon_id` int(5) NOT NULL,
  `comments` text NOT NULL,
  `comments_by` int(5) NOT NULL,
  `date` date NOT NULL,
  `prove` int(1) NOT NULL,
  `prove_date` date NOT NULL,
  `proved_by` int(5) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `Oral_taxon_id` (`Oral_taxon_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Table structure for table `cultivability`
--

CREATE TABLE IF NOT EXISTS `cultivability` (
  `Oral_taxon_id` int(5) NOT NULL,
  `order` int(2) NOT NULL,
  `description` text NOT NULL,
  KEY `Oral_taxon_id` (`Oral_taxon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `disease_associations`
--

CREATE TABLE IF NOT EXISTS `disease_associations` (
  `Oral_taxon_id` int(5) NOT NULL,
  `order` int(2) NOT NULL,
  `description` text NOT NULL,
  KEY `Oral_taxon_id` (`Oral_taxon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------

--
-- Table structure for table `general`
--

CREATE TABLE IF NOT EXISTS `general` (
  `Oral_taxon_id` int(5) NOT NULL,
  `order` int(2) NOT NULL,
  `description` text NOT NULL,
  KEY `Oral_taxon_id` (`Oral_taxon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------

--
-- Table structure for table `HOT_count`
--

CREATE TABLE IF NOT EXISTS `HOT_count` (
  `Oral_taxon_id` int(11) NOT NULL,
  `HOT_count` int(11) NOT NULL,
  `Rank` int(11) NOT NULL,
  `Tied` tinyint(4) NOT NULL,
  PRIMARY KEY  (`Oral_taxon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------

--
-- Table structure for table `phenotypic_characteristics`
--

CREATE TABLE IF NOT EXISTS `phenotypic_characteristics` (
  `Oral_taxon_id` int(5) NOT NULL,
  `order` int(2) NOT NULL,
  `description` text NOT NULL,
  KEY `Oral_taxon_id` (`Oral_taxon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `phylogeny`
--

CREATE TABLE IF NOT EXISTS `phylogeny` (
  `Oral_taxon_id` int(11) NOT NULL,
  `tree_id` tinyint(4) NOT NULL,
  PRIMARY KEY  (`Oral_taxon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `prevalence`
--

CREATE TABLE IF NOT EXISTS `prevalence` (
  `Oral_taxon_id` int(5) NOT NULL,
  `order` int(2) NOT NULL,
  `description` text NOT NULL,
  KEY `Oral_taxon_id` (`Oral_taxon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `references`
--

CREATE TABLE IF NOT EXISTS `references` (
  `Oral_taxon_id` int(5) NOT NULL,
  `pubmed_id` int(15) default NULL,
  `journal` varchar(150) NOT NULL,
  `authors` varchar(200) character set utf8 collate utf8_unicode_ci NOT NULL,
  `title` varchar(200) NOT NULL,
  `auto_id` int(8) NOT NULL auto_increment,
  PRIMARY KEY  (`auto_id`),
  KEY `Oral_taxon_id` (`Oral_taxon_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=528 ;

-- --------------------------------------------------------

--
-- Table structure for table `reference_strain`
--

CREATE TABLE IF NOT EXISTS `reference_strain` (
  `Oral_taxon_id` int(5) NOT NULL,
  `order` int(2) NOT NULL,
  `reference_strain` varchar(100) NOT NULL,
  KEY `Oral_taxon_id` (`Oral_taxon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `status`
--

CREATE TABLE IF NOT EXISTS `status` (
  `Oral_taxon_id` int(11) NOT NULL,
  `group` text NOT NULL,
  PRIMARY KEY  (`Oral_taxon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------

--
-- Table structure for table `synonyms`
--

CREATE TABLE IF NOT EXISTS `synonyms_correct` (
  `Oral_taxon_id` int(5) NOT NULL,
  `order` int(2) NOT NULL,
  `synonyms` text NOT NULL,
  KEY `Oral_taxon_id` (`Oral_taxon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------

--
-- Table structure for table `type_strain`
--

CREATE TABLE IF NOT EXISTS `type_strain` (
  `Oral_taxon_id` int(5) NOT NULL,
  `order` int(2) NOT NULL,
  `type_strain` varchar(100) NOT NULL,
  KEY `Oral_taxon_id` (`Oral_taxon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `warning`
--

CREATE TABLE IF NOT EXISTS `warning` (
  `Oral_taxon_id` int(11) NOT NULL,
  `warning` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`Oral_taxon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `ClassifyTitle`
--

CREATE TABLE IF NOT EXISTS `ClassifyTitle` (
  `item_id` int(5) NOT NULL,
  `item_title` varchar(150) NOT NULL,
  `level` varchar(2) NOT NULL COMMENT '0=>Domain, 1=>Phylum, 2=>Class,  3=>Order, 4=>Family, 5=>Genus, 6=>Species',
  KEY `item_id` (`item_id`),
  KEY `item_title` (`item_title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `classify_level`
--

CREATE TABLE IF NOT EXISTS `classify_level` (
  `level` int(1) NOT NULL,
  `classify` varchar(50) NOT NULL,
  KEY `level` (`level`,`classify`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `ItemLink_Item`
--

CREATE TABLE IF NOT EXISTS `ItemLink_Item` (
  `item1_id` int(11) NOT NULL,
  `item2_id` int(11) NOT NULL,
  `taxonid_count` int(8) NOT NULL default '0',
  `seq_id_count` int(5) default '0',
  `sequenced_count` int(5) default '0',
  `clone_count` int(11) default '0' COMMENT 'runt this script to update this field: index.php?name=Download&file=update_clone_count',
  KEY `item1_id` (`item1_id`,`item2_id`),
  KEY `item2_id` (`item2_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `ItemLink_OralTaxonId`
--

CREATE TABLE IF NOT EXISTS `ItemLink_OralTaxonId` (
  `item_id` int(5) NOT NULL,
  `oral_taxon_id` int(5) NOT NULL,
  KEY `Item_id` (`item_id`,`oral_taxon_id`),
  KEY `oral_taxon_id` (`oral_taxon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------

--
-- Table structure for table `taxon_list`
--

CREATE TABLE IF NOT EXISTS `taxon_list` (
  `Oral_taxon_id` int(5) NOT NULL,
  `Genus` varchar(150) NOT NULL,
  `Species` varchar(150) NOT NULL,
  PRIMARY KEY  (`Oral_taxon_id`),
  KEY `Genus` (`Genus`,`Species`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;