-- MySQL
--
-- Database: fRNAdb
-- ---------------------------------------------------------


--
-- Table structure for table `cytoband2pos`
--
DROP TABLE IF EXISTS `cytoband2pos`;
CREATE TABLE `cytoband2pos` (
  `cytoband` text NOT NULL default '',
  `pos` text NOT NULL default '',
  PRIMARY KEY (`cytoband`(255))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `db`
--
DROP TABLE IF EXISTS `db`;
CREATE TABLE `db` (
  `dbID` mediumint(16) unsigned NOT NULL default '0',
  `dbName` text,
  `site_url` text,
  `link` text,
  `synonym` text,
  `rawname` text,
  `version` text,
  PRIMARY KEY  (`dbID`),
  FULLTEXT KEY `synonym` (`synonym`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `evidence`
--
DROP TABLE IF EXISTS `evidence`;
CREATE TABLE `evidence` (
  `eID` mediumint(16) unsigned NOT NULL default '0',
  `type` varchar(16) NOT NULL default '',
  `def` text NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY  (`eID`, `type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `expID2pmid`
--
DROP TABLE IF EXISTS `expID2pmid`;
CREATE TABLE `expID2pmid` (
  `expID` mediumint(16) unsigned default NULL,
  `PMID` int(32) unsigned default NULL,
  KEY `expID` (`expID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `exp_tissue`
--
DROP TABLE IF EXISTS `exp_tissue`;
CREATE TABLE `exp_tissue` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `tissueID` mediumint(16) unsigned NOT NULL default 0,
  `value` mediumint(16) unsigned NOT NULL default 0,
  `normalized_value` float NULL,
  `eID` mediumint(16) unsigned NOT NULL default 0,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `experiment`
--
DROP TABLE IF EXISTS `experiment`;
CREATE TABLE `experiment` (
  `expID` mediumint(16) unsigned NOT NULL default 0,
  `Author` text,
  `description` text,
  `Date` date default NULL,
  `xrefDB` mediumint(16) unsigned default NULL,
  `xrefID` varchar(255) default NULL,
  `taxonID` mediumint(16) unsigned default NULL,
  PRIMARY KEY  (`expID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `id2acc`
--
DROP TABLE IF EXISTS `id2acc`;
CREATE TABLE `id2acc` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `acc` varchar(16) NOT NULL default '',
  `matchof_acc` char(1) default NULL,
  KEY `id` (`id`,`acc`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `id2gbtrack`
--
DROP TABLE IF EXISTS `id2gbtrack`;
CREATE TABLE `id2gbtrack` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `gbtrack` varchar(32) NOT NULL default '',
  KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `id2omim`
--
DROP TABLE IF EXISTS `id2omim`;
CREATE TABLE `id2omim` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `omimID` mediumint(16) unsigned default NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `id2pmid`
--
DROP TABLE IF EXISTS `id2pmid`;
CREATE TABLE `id2pmid` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `PMID` int(32) unsigned NOT NULL default 0,
  KEY  `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `id2soid`
--
DROP TABLE IF EXISTS `id2soid`;
CREATE TABLE `id2soid` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `soID` mediumint(16) unsigned NOT NULL default 0,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `id2taxonomy`
--
DROP TABLE IF EXISTS `id2taxonomy`;
CREATE TABLE `id2taxonomy` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `taxonID` mediumint(16) unsigned default NULL,
  KEY `id` (`id`,`taxonID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `keyword`
--
DROP TABLE IF EXISTS `keyword`;
CREATE TABLE `keyword` (
  `id` mediumint(16) unsigned NOT NULL,
  `word` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `keyword_publication`
--
DROP TABLE IF EXISTS `keyword_publication`;
CREATE TABLE `keyword_publication` (
  `PMID` varchar(255) NOT NULL default '',
  `Title` text,
  `Abstract` text,
  PRIMARY KEY  (`PMID`),
  FULLTEXT KEY `Title` (`Title`),
  FULLTEXT KEY `Abstract` (`Abstract`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `kg_xref`
--
DROP TABLE IF EXISTS `kg_xref`;
CREATE TABLE `kg_xref` (
  `kgID` varchar(64) NOT NULL default '',
  `geneSymbol` varchar(64) NOT NULL default '',
  `word` text NOT NULL default '',
   PRIMARY KEY  (`kgID`),
   FULLTEXT KEY (`word`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `mapping`
--
DROP TABLE IF EXISTS `mapping`;
CREATE TABLE `mapping` (
  `id` mediumint(16) unsigned NOT NULL,
  `subject` varchar(16) NOT NULL,
  `chrom` varchar(16) NOT NULL,
  `chrom_eva` varchar(16) NOT NULL,
  `cytoband` varchar(32) NOT NULL,
  `txStart` int(32) unsigned NOT NULL,
  `txEnd` int(32) unsigned NOT NULL,
  `strand` char(1) NOT NULL,
  `identity` tinyint(3) unsigned NOT NULL,
  `eID` mediumint(16) unsigned NOT NULL,
  KEY  `composite` (`id`,`subject`,`chrom`,`txStart`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `method`
--
DROP TABLE IF EXISTS `method`;
CREATE TABLE `method` (
  `methodID` mediumint(16) unsigned NOT NULL,
  `description` text,
  PRIMARY KEY  (`methodID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `omim`
--
DROP TABLE IF EXISTS `omim`;
CREATE TABLE `omim` (
  `omimID` mediumint(16) unsigned NOT NULL,
  `name` text NOT NULL,
  `locus` varchar(255),
  PRIMARY KEY  (`omimID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `omim_synonym`
--
DROP TABLE IF EXISTS `omim_synonym`;
CREATE TABLE `omim_synonym` (
  `omimID` mediumint(16) unsigned NOT NULL,
  `synonym` text NOT NULL,
  KEY  (`omimID`),
  FULLTEXT (`synonym`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `ref_mapping`
--
DROP TABLE IF EXISTS `ref_mapping`;
CREATE TABLE `ref_mapping` (
  `subject` varchar(16) NOT NULL,
  `commonName` varchar(32) NOT NULL,
  `synonym` text NOT NULL,
  `hasGB` tinyint(1) NOT NULL default '0',
  `xrefDB` mediumint(16) unsigned,
  FULLTEXT (`synonym`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `repeat_mapping`
--
DROP TABLE IF EXISTS `repeat_mapping`;
CREATE TABLE `repeat_mapping` (
  `id` mediumint(16) unsigned NOT NULL,
  `subject` varchar(16) NOT NULL,
  KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `sec_structure`
--
DROP TABLE IF EXISTS `sec_structure`;
CREATE TABLE `sec_structure` (
  `id` mediumint(16) unsigned NOT NULL,
  `structure` longtext NOT NULL,
  `eID` mediumint(16) unsigned NOT NULL,
  KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `sequence`
--
DROP TABLE IF EXISTS `sequence`;
CREATE TABLE `sequence` (
  `id` mediumint(16) unsigned NOT NULL,
  `seq` longtext NOT NULL,
  KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `sequence_similarity`
--
DROP TABLE IF EXISTS `sequence_similarity`;
CREATE TABLE `sequence_similarity` (
  `id` mediumint(16) unsigned NOT NULL,
  `subject_id` mediumint(16) unsigned NOT NULL,
  `eID` mediumint(16) unsigned NOT NULL,  
  KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `so`
--
DROP TABLE IF EXISTS `so`;
CREATE TABLE `so` (
  `soID` mediumint(16) unsigned NOT NULL,
  `name` text,
  `def` text,
  `parent` text,
  `link` text,
   PRIMARY KEY  (`soID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `so_synonym`
--
DROP TABLE IF EXISTS `so_synonym`;
CREATE TABLE `so_synonym` (
  `soID` mediumint(16) unsigned NOT NULL,
  `synonym` text NOT NULL,
   KEY  (`soID`),
   FULLTEXT KEY `synonym` (`synonym`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `structural_alignment`
--
DROP TABLE IF EXISTS `structural_alignment`;
CREATE TABLE `structural_alignment` (
  `id` int(11) NOT NULL default '0',
  `branch` int(11) NOT NULL default '0',
  `method` varchar(32) NOT NULL default '',
  `extFile` varchar(255) NOT NULL default '',
  `offset` int(11) NOT NULL default '0',
  `length` int(11) NOT NULL default '0',
  `struct_raw` text NOT NULL,
  `struct` text NOT NULL,
  `energy` float NOT NULL default '0',
  KEY `structural_alignment_id_idx` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `summary`
--
DROP TABLE IF EXISTS `summary`;
CREATE TABLE `summary` (
  `id` mediumint(16) unsigned NOT NULL,
  `acc` varchar(16) NOT NULL default '',
  `description` text,
  `length` mediumint(10) unsigned NOT NULL,
  `taxonID` varchar(255) NOT NULL default '',
  `citation` tinyint(3) unsigned NOT NULL default 0,
  PRIMARY KEY  (`id`),
  INDEX (`acc`), 
  INDEX (`length`),
  INDEX (`taxonID`),
  INDEX (`citation`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `taxonomy`
--
DROP TABLE IF EXISTS `taxonomy`;
CREATE TABLE `taxonomy` (
  `taxonID` mediumint(16) unsigned NOT NULL,
  `name` text,
  `parent` text,
  PRIMARY KEY  (`taxonID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `taxonomy_synonym`
--
DROP TABLE IF EXISTS `taxonomy_synonym`;
CREATE TABLE `taxonomy_synonym` (
  `taxonID` mediumint(16) unsigned NOT NULL,
  `synonym` text NOT NULL,
  KEY  (`taxonID`),
  FULLTEXT (`synonym`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `tissue`
--
DROP TABLE IF EXISTS `tissue`;
CREATE TABLE `tissue` (
  `tissueID` mediumint(16) unsigned NOT NULL,
  `taxonID` mediumint(16) unsigned NOT NULL,
  `description` text,
  `xrefDB` mediumint(16) unsigned,
  `xrefID` varchar(255),
  `methodID` mediumint(16) unsigned,
  PRIMARY KEY  (`tissueID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `tissueID2expID`
--
DROP TABLE IF EXISTS `tissueID2expID`;
CREATE TABLE `tissueID2expID` (
  `tissueID` mediumint(16) unsigned default NULL,
  `expID` mediumint(16) unsigned default NULL,
  KEY `tissueID` (`tissueID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `xref`
--
DROP TABLE IF EXISTS `xref`;
CREATE TABLE `xref` (
  `id` mediumint(16) unsigned NOT NULL,
  `xrefDB` mediumint(16) unsigned NOT NULL,
  `xrefID` varchar(255),
  KEY  (`id`),
  INDEX(`xrefDB`),
  INDEX(`xrefID`(6))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `nr_upstream`
--
DROP TABLE IF EXISTS `nr_upstream`;
CREATE TABLE `nr_upstream` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `subject` varchar(16) NOT NULL default '',
  `gene` text NOT NULL default '',
  `strand` char(1) NOT NULL default '',
  KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `nr_dwstream`
--
DROP TABLE IF EXISTS `nr_dwstream`;
CREATE TABLE `nr_dwstream` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `subject` varchar(16) NOT NULL default '',
  `gene` text NOT NULL default '',
  `strand` char(1) NOT NULL default '',
  KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `ov_5utr`
--
DROP TABLE IF EXISTS `ov_5utr`;
CREATE TABLE `ov_5utr` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `subject` varchar(16) NOT NULL default '',
  `gene` text NOT NULL default '',
  `strand` char(1) NOT NULL default '',
  KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `ov_exon`
--
DROP TABLE IF EXISTS `ov_exon`;
CREATE TABLE `ov_exon` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `subject` varchar(16) NOT NULL default '',
  `gene` text NOT NULL default '',
  `strand` char(1) NOT NULL default '',
  KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `ov_intron`
--
DROP TABLE IF EXISTS `ov_intron`;
CREATE TABLE `ov_intron` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `subject` varchar(16) NOT NULL default '',
  `gene` text NOT NULL default '',
  `strand` char(1) NOT NULL default '',
  KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `ov_3utr`
--
DROP TABLE IF EXISTS `ov_3utr`;
CREATE TABLE `ov_3utr` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `subject` varchar(16) NOT NULL default '',
  `gene` text NOT NULL default '',
  `strand` char(1) NOT NULL default '',
  KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `affy_array_hg18`
--
DROP TABLE IF EXISTS `affy_array_hg18`;
CREATE TABLE `affy_array_hg18` (
  `probeID` mediumint(16) unsigned NOT NULL,
  `TranscriptID` varchar(255) NOT NULL,
  `locus` varchar(255),
  `strand` char(1),
   PRIMARY KEY  (`probeID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `affy_array_mm9`
--
DROP TABLE IF EXISTS `affy_array_mm9`;
CREATE TABLE `affy_array_mm9` (
  `probeID` mediumint(16) unsigned NOT NULL,
  `TranscriptID` varchar(255) NOT NULL,
  `locus` varchar(255),
  `strand` char(1),  
   PRIMARY KEY  (`probeID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `affy_array_rn3`
--
DROP TABLE IF EXISTS `affy_array_rn3`;
CREATE TABLE `affy_array_rn3` (
  `probeID` mediumint(16) unsigned NOT NULL,
  `TranscriptID` varchar(255) NOT NULL,
  `locus` varchar(255),
  `strand` char(1),
   PRIMARY KEY  (`probeID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `ivgn_array_hg18`
--
DROP TABLE IF EXISTS `ivgn_array_hg18`;
CREATE TABLE `ivgn_array_hg18` (
  `probeID` varchar(32) NOT NULL,
  `TranscriptID` varchar(255) NOT NULL,
  `locus` varchar(255),
  `strand` char(1),
   PRIMARY KEY  (`probeID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `ivgn_array_mm9`
--
DROP TABLE IF EXISTS `ivgn_array_mm9`;
CREATE TABLE `ivgn_array_mm9` (
  `probeID` varchar(32) NOT NULL,
  `TranscriptID` varchar(255) NOT NULL,
  `locus` varchar(255),
  `strand` char(1),
   PRIMARY KEY  (`probeID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `id2affy_array_hg18`
--
DROP TABLE IF EXISTS `id2affy_array_hg18`;
CREATE TABLE `id2affy_array_hg18` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `probeID` mediumint(16) unsigned NOT NULL default 0,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `id2affy_array_mm9`
--
DROP TABLE IF EXISTS `id2affy_array_mm9`;
CREATE TABLE `id2affy_array_mm9` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `probeID` mediumint(16) unsigned NOT NULL default 0,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `id2affy_array_rn3`
--
DROP TABLE IF EXISTS `id2affy_array_rn3`;
CREATE TABLE `id2affy_array_rn3` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `probeID` mediumint(16) unsigned NOT NULL default 0,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `id2ivgn_array_hg18`
--
DROP TABLE IF EXISTS `id2ivgn_array_hg18`;
CREATE TABLE `id2ivgn_array_hg18` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `probeID` varchar(32) NOT NULL default "",
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `id2ivgn_array_mm9`
--
DROP TABLE IF EXISTS `id2ivgn_array_mm9`;
CREATE TABLE `id2ivgn_array_mm9` (
  `id` mediumint(16) unsigned NOT NULL default 0,
  `probeID` varchar(32) NOT NULL default "",
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
