aboutsummaryrefslogtreecommitdiff
path: root/sql/schema-original.sql
diff options
context:
space:
mode:
authorMuriithi Frederick Muriuki2021-07-22 14:03:28 +0300
committerMuriithi Frederick Muriuki2021-07-22 14:03:28 +0300
commit598d17fd415e905ede6ad4457a3283dcf2ef350a (patch)
treef450ac2be6cce51496762e08fe5710ae0c791039 /sql/schema-original.sql
parent0263a7c79e3131d42006a38ac2fbb80556506491 (diff)
parent086b7151295ede3aed32f29fb537bb5c6172393d (diff)
downloadgenenetwork3-598d17fd415e905ede6ad4457a3283dcf2ef350a.tar.gz
Merge branch 'main' of github.com:genenetwork/genenetwork3
Diffstat (limited to 'sql/schema-original.sql')
-rw-r--r--sql/schema-original.sql2334
1 files changed, 2334 insertions, 0 deletions
diff --git a/sql/schema-original.sql b/sql/schema-original.sql
new file mode 100644
index 0000000..8803d8a
--- /dev/null
+++ b/sql/schema-original.sql
@@ -0,0 +1,2334 @@
+-- MySQL dump 10.16 Distrib 10.1.41-MariaDB, for debian-linux-gnu (x86_64)
+--
+-- Host: localhost Database: db_webqtl
+-- ------------------------------------------------------
+-- Server version 10.5.8-MariaDB-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 utf8mb4 */;
+/*!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 `AccessLog`
+--
+
+DROP TABLE IF EXISTS `AccessLog`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `AccessLog` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `accesstime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `ip_address` char(20) NOT NULL DEFAULT '0.0.0.0',
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=1366832 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `AvgMethod`
+--
+
+DROP TABLE IF EXISTS `AvgMethod`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `AvgMethod` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `AvgMethodId` int(5) DEFAULT NULL,
+ `Name` char(30) NOT NULL DEFAULT '',
+ `Normalization` varchar(30) DEFAULT NULL,
+ PRIMARY KEY (`Id`)
+) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `BXDSnpPosition`
+--
+
+DROP TABLE IF EXISTS `BXDSnpPosition`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `BXDSnpPosition` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `Chr` char(2) DEFAULT NULL,
+ `StrainId1` int(11) DEFAULT NULL,
+ `StrainId2` int(11) DEFAULT NULL,
+ `Mb` double DEFAULT NULL,
+ `Mb_2016` double DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `BXDSnpPosition` (`Chr`,`StrainId1`,`StrainId2`,`Mb`)
+) ENGINE=MyISAM AUTO_INCREMENT=7791982 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `CaseAttribute`
+--
+
+DROP TABLE IF EXISTS `CaseAttribute`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `CaseAttribute` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `Name` varchar(30) NOT NULL DEFAULT '',
+ PRIMARY KEY (`Id`)
+) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `CaseAttributeXRef`
+--
+
+DROP TABLE IF EXISTS `CaseAttributeXRef`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `CaseAttributeXRef` (
+ `ProbeSetFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `CaseAttributeId` smallint(5) NOT NULL DEFAULT 0,
+ `Value` varchar(100) NOT NULL DEFAULT '',
+ PRIMARY KEY (`ProbeSetFreezeId`,`StrainId`,`CaseAttributeId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `CaseAttributeXRefNew`
+--
+
+DROP TABLE IF EXISTS `CaseAttributeXRefNew`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `CaseAttributeXRefNew` (
+ `InbredSetId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `StrainId` int(8) unsigned NOT NULL DEFAULT 0,
+ `CaseAttributeId` smallint(5) NOT NULL DEFAULT 0,
+ `Value` varchar(100) NOT NULL DEFAULT '',
+ PRIMARY KEY (`InbredSetId`,`StrainId`,`CaseAttributeId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `CeleraINFO_mm6`
+--
+
+DROP TABLE IF EXISTS `CeleraINFO_mm6`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `CeleraINFO_mm6` (
+ `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `SNPID` char(14) NOT NULL DEFAULT '',
+ `chromosome` char(3) DEFAULT NULL,
+ `MB_UCSC` double DEFAULT NULL,
+ `MB_celera` double DEFAULT NULL,
+ `allele_B6` char(4) DEFAULT NULL,
+ `allele_D2` char(4) DEFAULT NULL,
+ `allele_AJ` char(4) DEFAULT NULL,
+ `B6_D2` char(1) DEFAULT NULL,
+ `B6_AJ` char(1) DEFAULT NULL,
+ `D2_AJ` char(1) DEFAULT NULL,
+ `MB_UCSC_OLD` double DEFAULT NULL,
+ `allele_S1` char(4) DEFAULT NULL,
+ `allele_X1` char(4) DEFAULT NULL,
+ `flanking5` char(100) DEFAULT NULL,
+ `flanking3` char(100) DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ KEY `celeraIndex` (`chromosome`,`MB_celera`),
+ KEY `celeraIndex2` (`chromosome`,`MB_UCSC`),
+ KEY `chromosome_2` (`chromosome`,`MB_UCSC`),
+ KEY `MB_UCSC_2` (`MB_UCSC`,`chromosome`),
+ KEY `SNPID` (`SNPID`)
+) ENGINE=MyISAM AUTO_INCREMENT=3028848 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Chr_Length`
+--
+
+DROP TABLE IF EXISTS `Chr_Length`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Chr_Length` (
+ `Name` char(3) NOT NULL DEFAULT '',
+ `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `OrderId` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `Length` int(10) unsigned NOT NULL DEFAULT 0,
+ `Length_2016` int(10) unsigned NOT NULL DEFAULT 0,
+ `Length_mm8` int(10) unsigned DEFAULT NULL,
+ UNIQUE KEY `nameIdx` (`SpeciesId`,`Name`),
+ UNIQUE KEY `SpeciesIdx` (`SpeciesId`,`OrderId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `DBList`
+--
+
+DROP TABLE IF EXISTS `DBList`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `DBList` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `DBTypeId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `FreezeId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `Name` char(50) NOT NULL DEFAULT '',
+ `Code` char(50) DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ UNIQUE KEY `Cde` (`Code`),
+ KEY `DBIndex` (`DBTypeId`,`FreezeId`)
+) ENGINE=MyISAM AUTO_INCREMENT=907 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `DBType`
+--
+
+DROP TABLE IF EXISTS `DBType`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `DBType` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `Name` char(30) NOT NULL DEFAULT '',
+ PRIMARY KEY (`Id`)
+) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `DatasetMapInvestigator`
+--
+
+DROP TABLE IF EXISTS `DatasetMapInvestigator`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `DatasetMapInvestigator` (
+ `Id` mediumint(9) NOT NULL AUTO_INCREMENT,
+ `DatasetId` int(6) NOT NULL,
+ `InvestigatorId` int(6) NOT NULL,
+ PRIMARY KEY (`Id`)
+) ENGINE=MyISAM AUTO_INCREMENT=2403 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `DatasetStatus`
+--
+
+DROP TABLE IF EXISTS `DatasetStatus`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `DatasetStatus` (
+ `DatasetStatusId` int(5) NOT NULL,
+ `DatasetStatusName` varchar(20) DEFAULT NULL,
+ UNIQUE KEY `DatasetStatusId` (`DatasetStatusId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Dataset_mbat`
+--
+
+DROP TABLE IF EXISTS `Dataset_mbat`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Dataset_mbat` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `switch` int(1) DEFAULT NULL,
+ `species` varchar(255) DEFAULT NULL,
+ `cross` varchar(255) DEFAULT NULL,
+ `tissue` varchar(255) DEFAULT NULL,
+ `database` varchar(255) DEFAULT NULL,
+ `database_LongName` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Datasets`
+--
+
+DROP TABLE IF EXISTS `Datasets`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Datasets` (
+ `DatasetId` int(6) NOT NULL AUTO_INCREMENT,
+ `DatasetName` varchar(255) DEFAULT NULL,
+ `GeoSeries` varchar(30) DEFAULT NULL,
+ `PublicationTitle` longtext DEFAULT NULL,
+ `Summary` longtext DEFAULT NULL,
+ `ExperimentDesign` longtext DEFAULT NULL,
+ `AboutCases` longtext DEFAULT NULL,
+ `AboutTissue` longtext DEFAULT NULL,
+ `AboutPlatform` longtext DEFAULT NULL,
+ `AboutDataProcessing` longtext DEFAULT NULL,
+ `Contributors` longtext DEFAULT NULL,
+ `Citation` longtext DEFAULT NULL,
+ `Acknowledgment` longtext DEFAULT NULL,
+ `Notes` longtext DEFAULT NULL,
+ `InvestigatorId` int(5) NOT NULL,
+ `DatasetStatusId` int(5) NOT NULL,
+ PRIMARY KEY (`DatasetId`),
+ UNIQUE KEY `DatasetId` (`DatasetId`)
+) ENGINE=MyISAM AUTO_INCREMENT=301 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Docs`
+--
+
+DROP TABLE IF EXISTS `Docs`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Docs` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `entry` varchar(255) NOT NULL,
+ `title` varchar(255) NOT NULL,
+ `content` text NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `EnsemblChip`
+--
+
+DROP TABLE IF EXISTS `EnsemblChip`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `EnsemblChip` (
+ `Id` int(11) NOT NULL,
+ `ProbeSetSize` int(11) NOT NULL,
+ `Name` varchar(40) NOT NULL,
+ `Type` enum('AFFY','OLIGO') DEFAULT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `EnsemblProbe`
+--
+
+DROP TABLE IF EXISTS `EnsemblProbe`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `EnsemblProbe` (
+ `Id` int(11) NOT NULL,
+ `ChipId` int(11) NOT NULL,
+ `ProbeSet` varchar(40) DEFAULT NULL,
+ `Name` varchar(40) DEFAULT NULL,
+ `length` int(11) NOT NULL,
+ KEY `EnsemblProbeId` (`Id`),
+ KEY `EnsemblProbeName` (`Name`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `EnsemblProbeLocation`
+--
+
+DROP TABLE IF EXISTS `EnsemblProbeLocation`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `EnsemblProbeLocation` (
+ `Chr` char(2) NOT NULL,
+ `Start` int(11) NOT NULL,
+ `Start_2016` int(11) DEFAULT NULL,
+ `End` int(11) NOT NULL,
+ `End_2016` int(11) DEFAULT NULL,
+ `Strand` int(11) NOT NULL,
+ `MisMataches` int(11) DEFAULT NULL,
+ `ProbeId` int(11) NOT NULL,
+ KEY `EnsemblLocationProbeId` (`ProbeId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GORef`
+--
+
+DROP TABLE IF EXISTS `GORef`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GORef` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `goterm` varchar(255) DEFAULT NULL,
+ `genes` text DEFAULT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=17510 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Genbank`
+--
+
+DROP TABLE IF EXISTS `Genbank`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Genbank` (
+ `Id` varchar(20) NOT NULL DEFAULT '',
+ `Sequence` text DEFAULT NULL,
+ `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ PRIMARY KEY (`Id`),
+ KEY `Id` (`Id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GeneCategory`
+--
+
+DROP TABLE IF EXISTS `GeneCategory`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GeneCategory` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `Name` char(255) NOT NULL DEFAULT '',
+ PRIMARY KEY (`Id`),
+ KEY `name_idx` (`Name`)
+) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GeneChip`
+--
+
+DROP TABLE IF EXISTS `GeneChip`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GeneChip` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `GeneChipId` int(5) DEFAULT NULL,
+ `GeneChipName` varchar(200) DEFAULT NULL,
+ `Name` char(30) NOT NULL DEFAULT '',
+ `GeoPlatform` char(15) DEFAULT NULL,
+ `Title` varchar(100) DEFAULT NULL,
+ `SpeciesId` int(5) DEFAULT 1,
+ `GO_tree_value` varchar(50) DEFAULT NULL,
+ PRIMARY KEY (`Id`)
+) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GeneChipEnsemblXRef`
+--
+
+DROP TABLE IF EXISTS `GeneChipEnsemblXRef`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GeneChipEnsemblXRef` (
+ `GeneChipId` int(11) NOT NULL,
+ `EnsemblChipId` int(11) NOT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GeneIDXRef`
+--
+
+DROP TABLE IF EXISTS `GeneIDXRef`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GeneIDXRef` (
+ `mouse` int(11) NOT NULL DEFAULT 0,
+ `rat` int(11) NOT NULL DEFAULT 0,
+ `human` int(11) NOT NULL DEFAULT 0,
+ KEY `mouse_index` (`mouse`),
+ KEY `rat_index` (`rat`),
+ KEY `human_index` (`human`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GeneList`
+--
+
+DROP TABLE IF EXISTS `GeneList`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GeneList` (
+ `SpeciesId` int(5) unsigned NOT NULL DEFAULT 1,
+ `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `GeneSymbol` varchar(15) DEFAULT NULL,
+ `GeneDescription` text DEFAULT NULL,
+ `Chromosome` varchar(10) DEFAULT NULL,
+ `TxStart` double DEFAULT NULL,
+ `TxStart_2016` double DEFAULT NULL,
+ `TxEnd` double DEFAULT NULL,
+ `TxEnd_2016` double DEFAULT NULL,
+ `Strand` char(1) DEFAULT NULL,
+ `GeneID` varchar(10) DEFAULT NULL,
+ `NM_ID` varchar(15) DEFAULT NULL,
+ `kgID` varchar(10) DEFAULT NULL,
+ `GenBankID` varchar(15) DEFAULT NULL,
+ `UnigenID` varchar(15) DEFAULT NULL,
+ `ProteinID` varchar(15) DEFAULT NULL,
+ `AlignID` varchar(10) DEFAULT NULL,
+ `exonCount` int(7) NOT NULL DEFAULT 0,
+ `exonStarts` text DEFAULT NULL,
+ `exonEnds` text DEFAULT NULL,
+ `cdsStart` double DEFAULT NULL,
+ `cdsStart_2016` double DEFAULT NULL,
+ `cdsEnd` double DEFAULT NULL,
+ `cdsEnd_2016` double DEFAULT NULL,
+ `TxStart_mm8` double DEFAULT NULL,
+ `TxEnd_mm8` double DEFAULT NULL,
+ `Strand_mm8` char(1) DEFAULT NULL,
+ `exonCount_mm8` int(7) DEFAULT NULL,
+ `exonStarts_mm8` text DEFAULT NULL,
+ `exonEnds_mm8` text DEFAULT NULL,
+ `cdsStart_mm8` double DEFAULT NULL,
+ `cdsEnd_mm8` double DEFAULT NULL,
+ `Chromosome_mm8` varchar(10) DEFAULT NULL,
+ `Info_mm9` text DEFAULT NULL,
+ `RGD_ID` int(10) DEFAULT NULL,
+ UNIQUE KEY `geneId` (`SpeciesId`,`Id`),
+ KEY `geneSymbol` (`GeneSymbol`),
+ KEY `geneSymbol2` (`SpeciesId`,`GeneSymbol`),
+ KEY `Loc1` (`SpeciesId`,`Chromosome`,`TxStart`),
+ KEY `Loc2` (`SpeciesId`,`Chromosome`,`TxEnd`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GeneList_rn3`
+--
+
+DROP TABLE IF EXISTS `GeneList_rn3`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GeneList_rn3` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `ProbeSet` varchar(16) DEFAULT NULL,
+ `geneSymbol` varchar(15) DEFAULT NULL,
+ `geneID` varchar(10) DEFAULT NULL,
+ `kgID` varchar(10) DEFAULT NULL,
+ `geneDescription` text DEFAULT NULL,
+ `genBankID` varchar(15) DEFAULT NULL,
+ `unigenID` varchar(15) DEFAULT NULL,
+ `score` int(4) DEFAULT NULL,
+ `qStart` int(3) DEFAULT NULL,
+ `qEnd` int(3) DEFAULT NULL,
+ `qSize` int(3) DEFAULT NULL,
+ `identity` varchar(7) DEFAULT NULL,
+ `chromosome` varchar(8) DEFAULT NULL,
+ `strand` char(1) DEFAULT NULL,
+ `txStart` double DEFAULT NULL,
+ `txEnd` double DEFAULT NULL,
+ `txSize` double DEFAULT NULL,
+ `span` int(7) DEFAULT NULL,
+ `specificity` double DEFAULT NULL,
+ `sequence` text DEFAULT NULL,
+ `flag` int(1) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `geneSymbol` (`geneSymbol`),
+ KEY `Loc1` (`chromosome`,`txStart`),
+ KEY `Loc2` (`chromosome`,`txEnd`)
+) ENGINE=MyISAM AUTO_INCREMENT=14917 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GeneList_rn33`
+--
+
+DROP TABLE IF EXISTS `GeneList_rn33`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GeneList_rn33` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `geneSymbol` varchar(15) DEFAULT NULL,
+ `txStart` double DEFAULT NULL,
+ `txEnd` double DEFAULT NULL,
+ `exonCount` int(7) DEFAULT NULL,
+ `NM_ID` varchar(15) DEFAULT NULL,
+ `chromosome` varchar(8) DEFAULT NULL,
+ `strand` char(1) DEFAULT NULL,
+ `cdsStart` double DEFAULT NULL,
+ `cdsEnd` double DEFAULT NULL,
+ `exonStarts` text DEFAULT NULL,
+ `exonEnds` text DEFAULT NULL,
+ `kgID` varchar(10) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `geneSymbol` (`geneSymbol`),
+ KEY `Loc1` (`chromosome`,`txStart`),
+ KEY `Loc2` (`chromosome`,`txEnd`)
+) ENGINE=MyISAM AUTO_INCREMENT=9790 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GeneMap_cuiyan`
+--
+
+DROP TABLE IF EXISTS `GeneMap_cuiyan`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GeneMap_cuiyan` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `TranscriptID` varchar(255) DEFAULT NULL,
+ `GeneID` varchar(255) DEFAULT NULL,
+ `Symbol` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=10537 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GeneRIF`
+--
+
+DROP TABLE IF EXISTS `GeneRIF`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GeneRIF` (
+ `Id` int(10) unsigned NOT NULL DEFAULT 0,
+ `versionId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `symbol` varchar(30) NOT NULL DEFAULT '',
+ `PubMed_ID` varchar(255) DEFAULT NULL,
+ `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 1,
+ `comment` text DEFAULT NULL,
+ `email` varchar(50) DEFAULT NULL,
+ `createtime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `user_ip` varchar(20) DEFAULT NULL,
+ `weburl` varchar(255) DEFAULT NULL,
+ `initial` varchar(10) DEFAULT NULL,
+ `display` tinyint(4) DEFAULT 1,
+ `reason` varchar(100) NOT NULL DEFAULT '',
+ PRIMARY KEY (`Id`,`versionId`),
+ KEY `name_idx` (`symbol`),
+ KEY `status` (`display`),
+ KEY `timestamp` (`createtime`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GeneRIFXRef`
+--
+
+DROP TABLE IF EXISTS `GeneRIFXRef`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GeneRIFXRef` (
+ `GeneRIFId` int(10) unsigned NOT NULL DEFAULT 0,
+ `versionId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `GeneCategoryId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ PRIMARY KEY (`GeneRIFId`,`versionId`,`GeneCategoryId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GeneRIF_BASIC`
+--
+
+DROP TABLE IF EXISTS `GeneRIF_BASIC`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GeneRIF_BASIC` (
+ `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 1,
+ `GeneId` int(10) unsigned NOT NULL DEFAULT 0,
+ `symbol` varchar(255) NOT NULL DEFAULT '',
+ `PubMed_ID` int(10) unsigned NOT NULL DEFAULT 0,
+ `createtime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `comment` text DEFAULT NULL,
+ `VersionId` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
+ PRIMARY KEY (`GeneId`,`SpeciesId`,`createtime`,`PubMed_ID`,`VersionId`),
+ KEY `symbol` (`symbol`,`SpeciesId`,`createtime`),
+ FULLTEXT KEY `commts` (`comment`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Geno`
+--
+
+DROP TABLE IF EXISTS `Geno`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Geno` (
+ `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 1,
+ `Name` varchar(40) NOT NULL DEFAULT '',
+ `Marker_Name` varchar(40) DEFAULT NULL,
+ `Chr` char(3) DEFAULT NULL,
+ `Mb` double DEFAULT NULL,
+ `Mb_2016` double DEFAULT NULL,
+ `Sequence` text DEFAULT NULL,
+ `Source` varchar(40) DEFAULT NULL,
+ `chr_num` smallint(5) unsigned DEFAULT NULL,
+ `Source2` varchar(40) DEFAULT NULL,
+ `Comments` varchar(255) DEFAULT NULL,
+ `used_by_geno_file` varchar(40) DEFAULT NULL,
+ `Mb_mm8` double DEFAULT NULL,
+ `Chr_mm8` char(3) DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ UNIQUE KEY `species_name` (`SpeciesId`,`Name`),
+ KEY `Name` (`Name`)
+) ENGINE=MyISAM AUTO_INCREMENT=716770 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GenoCode`
+--
+
+DROP TABLE IF EXISTS `GenoCode`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GenoCode` (
+ `InbredSetId` smallint(5) unsigned NOT NULL DEFAULT 1,
+ `AlleleType` char(3) NOT NULL DEFAULT '',
+ `AlleleSymbol` char(2) NOT NULL DEFAULT '',
+ `DatabaseValue` smallint(5) DEFAULT NULL,
+ PRIMARY KEY (`InbredSetId`,`AlleleType`,`AlleleSymbol`),
+ UNIQUE KEY `InbredSetId_AlleleType` (`InbredSetId`,`AlleleType`),
+ UNIQUE KEY `InbredSetId_AlleleSymbol` (`InbredSetId`,`AlleleSymbol`),
+ UNIQUE KEY `InbredSetId_DatabaseValue` (`InbredSetId`,`DatabaseValue`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GenoData`
+--
+
+DROP TABLE IF EXISTS `GenoData`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GenoData` (
+ `Id` int(10) unsigned NOT NULL DEFAULT 0,
+ `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `value` float NOT NULL,
+ UNIQUE KEY `DataId` (`Id`,`StrainId`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GenoFile`
+--
+
+DROP TABLE IF EXISTS `GenoFile`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GenoFile` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `server` varchar(100) NOT NULL,
+ `InbredSetID` int(11) NOT NULL,
+ `location` varchar(255) NOT NULL,
+ `title` varchar(255) NOT NULL,
+ `sort` int(3) DEFAULT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GenoFreeze`
+--
+
+DROP TABLE IF EXISTS `GenoFreeze`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GenoFreeze` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `Name` varchar(100) NOT NULL DEFAULT '',
+ `FullName` varchar(100) NOT NULL DEFAULT '',
+ `ShortName` varchar(100) NOT NULL DEFAULT '',
+ `CreateTime` date NOT NULL DEFAULT '2001-01-01',
+ `public` tinyint(4) NOT NULL DEFAULT 0,
+ `InbredSetId` smallint(5) unsigned DEFAULT 1,
+ `confidentiality` tinyint(3) unsigned DEFAULT 0,
+ `AuthorisedUsers` varchar(100) DEFAULT NULL,
+ PRIMARY KEY (`Id`)
+) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GenoSE`
+--
+
+DROP TABLE IF EXISTS `GenoSE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GenoSE` (
+ `DataId` int(10) unsigned NOT NULL DEFAULT 0,
+ `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `error` float NOT NULL,
+ UNIQUE KEY `DataId` (`DataId`,`StrainId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `GenoXRef`
+--
+
+DROP TABLE IF EXISTS `GenoXRef`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GenoXRef` (
+ `GenoFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `GenoId` int(10) unsigned NOT NULL DEFAULT 0,
+ `DataId` int(10) unsigned NOT NULL DEFAULT 0,
+ `cM` double DEFAULT 0,
+ `Used_for_mapping` char(1) DEFAULT 'N',
+ UNIQUE KEY `ProbeSetId` (`GenoFreezeId`,`GenoId`),
+ UNIQUE KEY `DataId` (`DataId`),
+ KEY `GenoId` (`GenoId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `H2`
+--
+
+DROP TABLE IF EXISTS `H2`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `H2` (
+ `DataId` int(10) unsigned NOT NULL DEFAULT 0,
+ `ICH2` double NOT NULL DEFAULT 0,
+ `H2SE` double NOT NULL DEFAULT 0,
+ `HPH2` double NOT NULL DEFAULT 0,
+ UNIQUE KEY `DataId` (`DataId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Homologene`
+--
+
+DROP TABLE IF EXISTS `Homologene`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Homologene` (
+ `HomologeneId` int(11) DEFAULT NULL,
+ `GeneId` int(11) DEFAULT NULL,
+ `TaxonomyId` int(11) DEFAULT NULL,
+ KEY `GeneId` (`GeneId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `InbredSet`
+--
+
+DROP TABLE IF EXISTS `InbredSet`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `InbredSet` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `InbredSetId` int(5) DEFAULT NULL,
+ `InbredSetName` varchar(100) DEFAULT NULL,
+ `Name` char(30) NOT NULL DEFAULT '',
+ `SpeciesId` smallint(5) unsigned DEFAULT 1,
+ `FullName` varchar(100) DEFAULT NULL,
+ `public` tinyint(3) unsigned DEFAULT 2,
+ `MappingMethodId` char(50) DEFAULT '1',
+ `GeneticType` varchar(255) DEFAULT NULL,
+ `Family` varchar(100) DEFAULT NULL,
+ `FamilyOrder` int(5) DEFAULT NULL,
+ `MenuOrderId` double NOT NULL,
+ `InbredSetCode` varchar(5) DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ KEY `Name` (`Name`),
+ KEY `SpeciesId` (`SpeciesId`),
+ KEY `Id` (`Id`),
+ KEY `InbredSetCode` (`InbredSetCode`)
+) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `IndelAll`
+--
+
+DROP TABLE IF EXISTS `IndelAll`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `IndelAll` (
+ `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `SpeciesId` smallint(5) unsigned DEFAULT 1,
+ `SourceId` smallint(5) unsigned DEFAULT NULL,
+ `Name` char(30) DEFAULT NULL,
+ `Chromosome` char(2) DEFAULT NULL,
+ `Mb_start` double DEFAULT NULL,
+ `Mb_start_2016` double DEFAULT NULL,
+ `Strand` char(1) DEFAULT NULL,
+ `Type` char(15) DEFAULT NULL,
+ `Mb_end` double DEFAULT NULL,
+ `Mb_end_2016` double DEFAULT NULL,
+ `Size` double DEFAULT NULL,
+ `InDelSequence` char(30) DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ UNIQUE KEY `SnpId` (`SpeciesId`,`Name`),
+ KEY `SnpId2` (`Name`),
+ KEY `Position` (`SpeciesId`,`Chromosome`,`Mb_start`) USING BTREE
+) ENGINE=MyISAM AUTO_INCREMENT=142895 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `IndelXRef`
+--
+
+DROP TABLE IF EXISTS `IndelXRef`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `IndelXRef` (
+ `IndelId` int(10) unsigned NOT NULL DEFAULT 0,
+ `StrainId1` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `StrainId2` smallint(5) unsigned DEFAULT NULL,
+ PRIMARY KEY (`IndelId`,`StrainId1`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `InfoFiles`
+--
+
+DROP TABLE IF EXISTS `InfoFiles`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `InfoFiles` (
+ `DatasetId` int(5) DEFAULT NULL,
+ `SpeciesId` int(5) DEFAULT NULL,
+ `TissueId` int(5) DEFAULT NULL,
+ `InbredSetId` int(5) DEFAULT NULL,
+ `GeneChipId` int(5) DEFAULT NULL,
+ `AvgMethodId` int(5) DEFAULT NULL,
+ `InfoFileTitle` longtext DEFAULT NULL,
+ `Specifics` longtext DEFAULT NULL,
+ `Status` varchar(255) DEFAULT NULL,
+ `Title` varchar(255) DEFAULT NULL,
+ `Organism` varchar(255) DEFAULT NULL,
+ `Experiment_Type` longtext DEFAULT NULL,
+ `Summary` longtext DEFAULT NULL,
+ `Overall_Design` longtext DEFAULT NULL,
+ `Contributor` longtext DEFAULT NULL,
+ `Citation` longtext DEFAULT NULL,
+ `Submission_Date` varchar(255) DEFAULT NULL,
+ `Contact_Name` varchar(255) DEFAULT NULL,
+ `Emails` varchar(255) DEFAULT NULL,
+ `Phone` varchar(255) DEFAULT NULL,
+ `URL` varchar(255) DEFAULT NULL,
+ `Organization_Name` varchar(255) DEFAULT NULL,
+ `Department` varchar(255) DEFAULT NULL,
+ `Laboratory` varchar(255) DEFAULT NULL,
+ `Street` varchar(255) DEFAULT NULL,
+ `City` varchar(255) DEFAULT NULL,
+ `State` varchar(255) DEFAULT NULL,
+ `ZIP` varchar(255) DEFAULT NULL,
+ `Country` varchar(255) DEFAULT NULL,
+ `Platforms` varchar(255) DEFAULT NULL,
+ `Samples` longtext DEFAULT NULL,
+ `Species` varchar(255) DEFAULT NULL,
+ `Normalization` varchar(255) DEFAULT NULL,
+ `InbredSet` varchar(255) DEFAULT NULL,
+ `InfoPageName` varchar(255) NOT NULL,
+ `DB_Name` varchar(255) DEFAULT NULL,
+ `Organism_Id` varchar(60) DEFAULT NULL,
+ `InfoPageTitle` varchar(255) DEFAULT NULL,
+ `GN_AccesionId` int(4) DEFAULT NULL,
+ `Tissue` varchar(60) DEFAULT NULL,
+ `AuthorizedUsers` varchar(100) DEFAULT NULL,
+ `About_Cases` longtext DEFAULT NULL,
+ `About_Tissue` longtext DEFAULT NULL,
+ `About_Download` longtext DEFAULT NULL,
+ `About_Array_Platform` longtext DEFAULT NULL,
+ `About_Data_Values_Processing` longtext DEFAULT NULL,
+ `Data_Source_Acknowledge` longtext DEFAULT NULL,
+ `Progreso` varchar(20) DEFAULT NULL,
+ `QualityControlStatus` longtext DEFAULT NULL,
+ `InfoFileId` int(6) NOT NULL AUTO_INCREMENT,
+ PRIMARY KEY (`InfoFileId`),
+ UNIQUE KEY `InfoPageName` (`InfoPageName`),
+ UNIQUE KEY `GN_AccesionId` (`GN_AccesionId`)
+) ENGINE=MyISAM AUTO_INCREMENT=1470 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `InfoFilesUser_md5`
+--
+
+DROP TABLE IF EXISTS `InfoFilesUser_md5`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `InfoFilesUser_md5` (
+ `Username` varchar(16) DEFAULT NULL,
+ `Password` varchar(32) DEFAULT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Investigators`
+--
+
+DROP TABLE IF EXISTS `Investigators`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Investigators` (
+ `FirstName` varchar(20) DEFAULT NULL,
+ `LastName` varchar(20) DEFAULT NULL,
+ `Address` varchar(200) DEFAULT NULL,
+ `City` varchar(20) DEFAULT NULL,
+ `State` varchar(20) DEFAULT NULL,
+ `ZipCode` varchar(20) DEFAULT NULL,
+ `Phone` varchar(200) DEFAULT NULL,
+ `Email` varchar(200) DEFAULT NULL,
+ `Country` varchar(35) DEFAULT NULL,
+ `Url` text DEFAULT NULL,
+ `UserName` varchar(30) DEFAULT NULL,
+ `UserPass` varchar(50) DEFAULT NULL,
+ `UserDate` datetime /* mariadb-5.3 */ DEFAULT NULL,
+ `UserLevel` int(8) DEFAULT NULL,
+ `OrganizationId` int(5) NOT NULL,
+ `InvestigatorId` int(5) NOT NULL AUTO_INCREMENT,
+ PRIMARY KEY (`InvestigatorId`)
+) ENGINE=MyISAM AUTO_INCREMENT=151 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `LCorrRamin3`
+--
+
+DROP TABLE IF EXISTS `LCorrRamin3`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `LCorrRamin3` (
+ `GeneId1` int(12) unsigned DEFAULT NULL,
+ `GeneId2` int(12) unsigned DEFAULT NULL,
+ `value` double DEFAULT NULL,
+ KEY `GeneId1` (`GeneId1`),
+ KEY `GeneId2` (`GeneId2`),
+ KEY `GeneId1_2` (`GeneId1`,`GeneId2`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `MachineAccessLog`
+--
+
+DROP TABLE IF EXISTS `MachineAccessLog`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `MachineAccessLog` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `accesstime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `ip_address` char(20) NOT NULL DEFAULT '0.0.0.0',
+ `db_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
+ `data_id` int(10) unsigned DEFAULT NULL,
+ `action` char(10) DEFAULT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=514946 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `MappingMethod`
+--
+
+DROP TABLE IF EXISTS `MappingMethod`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `MappingMethod` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `Name` varchar(100) NOT NULL DEFAULT '',
+ PRIMARY KEY (`Id`)
+) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `NStrain`
+--
+
+DROP TABLE IF EXISTS `NStrain`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `NStrain` (
+ `DataId` int(10) unsigned DEFAULT NULL,
+ `StrainId` smallint(5) unsigned DEFAULT NULL,
+ `count` varchar(5) DEFAULT NULL,
+ UNIQUE KEY `DataId` (`DataId`,`StrainId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `News`
+--
+
+DROP TABLE IF EXISTS `News`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `News` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `date` date DEFAULT NULL,
+ `details` text DEFAULT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=MyISAM AUTO_INCREMENT=296 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Organizations`
+--
+
+DROP TABLE IF EXISTS `Organizations`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Organizations` (
+ `OrganizationId` int(5) NOT NULL AUTO_INCREMENT,
+ `OrganizationName` varchar(200) NOT NULL,
+ PRIMARY KEY (`OrganizationId`),
+ UNIQUE KEY `OrganizationId` (`OrganizationId`),
+ UNIQUE KEY `OrganizationName` (`OrganizationName`)
+) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Phenotype`
+--
+
+DROP TABLE IF EXISTS `Phenotype`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Phenotype` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `Pre_publication_description` text DEFAULT NULL,
+ `Post_publication_description` text DEFAULT NULL,
+ `Original_description` text DEFAULT NULL,
+ `Units` varchar(100) NOT NULL DEFAULT 'Unknown',
+ `Pre_publication_abbreviation` varchar(40) DEFAULT NULL,
+ `Post_publication_abbreviation` varchar(40) DEFAULT NULL,
+ `Lab_code` varchar(255) DEFAULT NULL,
+ `Submitter` varchar(255) DEFAULT NULL,
+ `Owner` varchar(255) DEFAULT NULL,
+ `Authorized_Users` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ KEY `Post_publication_description_Index` (`Post_publication_description`(255)),
+ KEY `Pre_publication_description_Index` (`Pre_publication_description`(255)),
+ KEY `Pre_publication_abbreviation_Index` (`Pre_publication_abbreviation`),
+ KEY `Post_publication_abbreviation_Index` (`Post_publication_abbreviation`),
+ KEY `Lab_code` (`Lab_code`),
+ FULLTEXT KEY `Post_publication_description` (`Post_publication_description`),
+ FULLTEXT KEY `Pre_publication_description` (`Pre_publication_description`),
+ FULLTEXT KEY `Pre_publication_abbreviation` (`Pre_publication_abbreviation`),
+ FULLTEXT KEY `Post_publication_abbreviation` (`Post_publication_abbreviation`),
+ FULLTEXT KEY `Lab_code1` (`Lab_code`),
+ FULLTEXT KEY `SEARCH_FULL_IDX` (`Post_publication_description`,`Pre_publication_description`,`Pre_publication_abbreviation`,`Post_publication_abbreviation`,`Lab_code`)
+) ENGINE=MyISAM AUTO_INCREMENT=29299 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Probe`
+--
+
+DROP TABLE IF EXISTS `Probe`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Probe` (
+ `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `ProbeSetId` int(10) unsigned NOT NULL DEFAULT 0,
+ `Name` char(20) DEFAULT NULL,
+ `Sequence` char(30) DEFAULT NULL,
+ `ExonNo` char(7) DEFAULT NULL,
+ `SerialOrder` double DEFAULT NULL,
+ `Tm` double DEFAULT NULL,
+ `E_GSB` double DEFAULT NULL,
+ `E_NSB` double DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ UNIQUE KEY `ProbeSetId` (`ProbeSetId`,`Name`),
+ KEY `SerialOrder` (`ProbeSetId`,`SerialOrder`)
+) ENGINE=MyISAM AUTO_INCREMENT=19054073 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `ProbeData`
+--
+
+DROP TABLE IF EXISTS `ProbeData`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ProbeData` (
+ `Id` int(10) unsigned NOT NULL DEFAULT 0,
+ `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `value` float NOT NULL,
+ UNIQUE KEY `DataId` (`Id`,`StrainId`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `ProbeFreeze`
+--
+
+DROP TABLE IF EXISTS `ProbeFreeze`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ProbeFreeze` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `ProbeFreezeId` int(5) DEFAULT NULL,
+ `ChipId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `TissueId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `Name` varchar(100) NOT NULL DEFAULT '',
+ `FullName` varchar(100) NOT NULL DEFAULT '',
+ `ShortName` varchar(100) NOT NULL DEFAULT '',
+ `CreateTime` date NOT NULL DEFAULT '0000-00-00',
+ `InbredSetId` smallint(5) unsigned DEFAULT 1,
+ PRIMARY KEY (`Id`),
+ UNIQUE KEY `Name` (`Name`),
+ KEY `TissueId` (`TissueId`),
+ KEY `InbredSetId` (`InbredSetId`)
+) ENGINE=MyISAM AUTO_INCREMENT=416 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `ProbeH2`
+--
+
+DROP TABLE IF EXISTS `ProbeH2`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ProbeH2` (
+ `ProbeFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `ProbeId` int(10) unsigned NOT NULL DEFAULT 0,
+ `h2` double DEFAULT NULL,
+ `weight` double DEFAULT NULL,
+ UNIQUE KEY `ProbeId` (`ProbeFreezeId`,`ProbeId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `ProbeSE`
+--
+
+DROP TABLE IF EXISTS `ProbeSE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ProbeSE` (
+ `DataId` int(10) unsigned NOT NULL DEFAULT 0,
+ `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `error` float NOT NULL,
+ UNIQUE KEY `DataId` (`DataId`,`StrainId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `ProbeSet`
+--
+
+DROP TABLE IF EXISTS `ProbeSet`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ProbeSet` (
+ `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `ChipId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `Name` varchar(100) DEFAULT NULL,
+ `TargetId` varchar(150) DEFAULT NULL,
+ `Symbol` varchar(100) DEFAULT NULL,
+ `description` longtext DEFAULT NULL,
+ `Chr` char(3) DEFAULT NULL,
+ `Mb` double DEFAULT NULL,
+ `Chr_2016` char(3) DEFAULT NULL,
+ `Mb_2016` double DEFAULT NULL,
+ `alias` longtext DEFAULT NULL,
+ `GeneId` varchar(20) DEFAULT NULL,
+ `GenbankId` varchar(1000) DEFAULT NULL,
+ `SNP` int(2) DEFAULT NULL,
+ `BlatSeq` text NOT NULL,
+ `TargetSeq` text DEFAULT NULL,
+ `UniGeneId` varchar(100) DEFAULT NULL,
+ `Strand_Probe` char(1) DEFAULT NULL,
+ `Strand_Gene` char(1) DEFAULT NULL,
+ `OMIM` varchar(20) DEFAULT NULL,
+ `comments` text NOT NULL,
+ `Probe_set_target_region` varchar(255) DEFAULT NULL,
+ `Probe_set_specificity` double DEFAULT NULL,
+ `Probe_set_BLAT_score` double DEFAULT NULL,
+ `Probe_set_Blat_Mb_start` double DEFAULT NULL,
+ `Probe_set_Blat_Mb_end` double DEFAULT NULL,
+ `Probe_set_Blat_Mb_start_2016` double DEFAULT NULL,
+ `Probe_set_Blat_Mb_end_2016` double DEFAULT NULL,
+ `Probe_set_strand` varchar(255) DEFAULT NULL,
+ `Probe_set_Note_by_RW` varchar(255) DEFAULT NULL,
+ `flag` char(1) DEFAULT NULL,
+ `Symbol_H` varchar(100) DEFAULT NULL,
+ `description_H` varchar(255) DEFAULT NULL,
+ `chromosome_H` char(3) DEFAULT NULL,
+ `MB_H` double DEFAULT NULL,
+ `alias_H` varchar(255) DEFAULT NULL,
+ `GeneId_H` varchar(20) DEFAULT NULL,
+ `chr_num` smallint(5) unsigned DEFAULT 30,
+ `name_num` int(10) unsigned DEFAULT 4294967290,
+ `Probe_Target_Description` varchar(225) DEFAULT NULL,
+ `RefSeq_TranscriptId` varchar(255) DEFAULT NULL,
+ `ENSEMBLGeneId` varchar(50) DEFAULT NULL,
+ `Chr_mm8` char(3) DEFAULT NULL,
+ `Mb_mm8` double DEFAULT NULL,
+ `Probe_set_Blat_Mb_start_mm8` double DEFAULT NULL,
+ `Probe_set_Blat_Mb_end_mm8` double DEFAULT NULL,
+ `HomoloGeneID` varchar(20) DEFAULT NULL,
+ `Biotype_ENS` varchar(255) DEFAULT NULL,
+ `ProteinID` varchar(50) DEFAULT NULL,
+ `ProteinName` varchar(50) DEFAULT NULL,
+ `UniProtID` varchar(20) DEFAULT NULL,
+ `Flybase_Id` varchar(25) DEFAULT NULL,
+ `RGD_ID` int(10) DEFAULT NULL,
+ `HMDB_ID` varchar(255) DEFAULT NULL,
+ `Confidence` int(5) DEFAULT NULL,
+ `ChEBI_ID` int(10) DEFAULT NULL,
+ `ChEMBL_ID` varchar(100) DEFAULT NULL,
+ `CAS_number` varchar(100) DEFAULT NULL,
+ `PubChem_ID` int(10) DEFAULT NULL,
+ `ChemSpider_ID` int(10) DEFAULT NULL,
+ `UNII_ID` varchar(100) DEFAULT NULL,
+ `EC_number` varchar(100) DEFAULT NULL,
+ `KEGG_ID` varchar(100) DEFAULT NULL,
+ `Molecular_Weight` double DEFAULT NULL,
+ `Nugowiki_ID` int(10) DEFAULT NULL,
+ `Type` varchar(255) DEFAULT NULL,
+ `Tissue` varchar(255) DEFAULT NULL,
+ `PrimaryName` varchar(255) DEFAULT NULL,
+ `SecondaryNames` longtext DEFAULT NULL,
+ `PeptideSequence` varchar(20) DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ UNIQUE KEY `ProbeSetId` (`ChipId`,`Name`),
+ KEY `Name_IDX` (`Name`),
+ KEY `symbol_IDX` (`Symbol`),
+ KEY `RefSeq_TranscriptId` (`RefSeq_TranscriptId`),
+ KEY `GENBANK_IDX` (`GenbankId`),
+ KEY `TargetId` (`TargetId`),
+ KEY `Position` (`Chr`),
+ KEY `GeneId_IDX` (`GeneId`),
+ FULLTEXT KEY `SEARCH_GENE_IDX` (`Symbol`,`alias`),
+ FULLTEXT KEY `SEARCH_FULL_IDX` (`Name`,`description`,`Symbol`,`alias`,`GenbankId`,`UniGeneId`,`Probe_Target_Description`),
+ FULLTEXT KEY `RefSeq_FULL_IDX` (`RefSeq_TranscriptId`)
+) ENGINE=MyISAM AUTO_INCREMENT=12118724 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `ProbeSetData`
+--
+
+DROP TABLE IF EXISTS `ProbeSetData`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ProbeSetData` (
+ `Id` int(10) unsigned NOT NULL DEFAULT 0,
+ `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `value` float NOT NULL,
+ UNIQUE KEY `DataId` (`Id`,`StrainId`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `ProbeSetFreeze`
+--
+
+DROP TABLE IF EXISTS `ProbeSetFreeze`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ProbeSetFreeze` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `ProbeFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `AvgID` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `Name` varchar(40) DEFAULT NULL,
+ `Name2` varchar(100) NOT NULL DEFAULT '',
+ `FullName` varchar(100) NOT NULL DEFAULT '',
+ `ShortName` varchar(100) NOT NULL DEFAULT '',
+ `CreateTime` date NOT NULL DEFAULT '0000-00-00',
+ `OrderList` int(5) DEFAULT NULL,
+ `public` tinyint(4) NOT NULL DEFAULT 0,
+ `confidentiality` tinyint(4) NOT NULL DEFAULT 0,
+ `AuthorisedUsers` varchar(300) NOT NULL,
+ `DataScale` varchar(20) NOT NULL DEFAULT 'log2',
+ PRIMARY KEY (`Id`),
+ UNIQUE KEY `FullName` (`FullName`),
+ UNIQUE KEY `Name` (`Name`),
+ KEY `NameIndex` (`Name2`),
+ KEY `ShortName` (`ShortName`),
+ KEY `ProbeFreezeId` (`ProbeFreezeId`),
+ KEY `conf_and_public` (`confidentiality`,`public`)
+) ENGINE=MyISAM AUTO_INCREMENT=1006 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `ProbeSetSE`
+--
+
+DROP TABLE IF EXISTS `ProbeSetSE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ProbeSetSE` (
+ `DataId` int(10) unsigned NOT NULL DEFAULT 0,
+ `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `error` float NOT NULL,
+ UNIQUE KEY `DataId` (`DataId`,`StrainId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `ProbeSetXRef`
+--
+
+DROP TABLE IF EXISTS `ProbeSetXRef`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ProbeSetXRef` (
+ `ProbeSetFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `ProbeSetId` int(10) unsigned NOT NULL DEFAULT 0,
+ `DataId` int(10) unsigned NOT NULL DEFAULT 0,
+ `Locus_old` char(20) DEFAULT NULL,
+ `LRS_old` double DEFAULT NULL,
+ `pValue_old` double DEFAULT NULL,
+ `mean` double DEFAULT NULL,
+ `se` double DEFAULT NULL,
+ `Locus` char(20) DEFAULT NULL,
+ `LRS` double DEFAULT NULL,
+ `pValue` double DEFAULT NULL,
+ `additive` double DEFAULT NULL,
+ `h2` float DEFAULT NULL,
+ UNIQUE KEY `ProbeSetId` (`ProbeSetFreezeId`,`ProbeSetId`),
+ UNIQUE KEY `DataId_IDX` (`DataId`),
+ KEY `ProbeSetId1` (`ProbeSetId`),
+ KEY `Locus` (`Locus`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `ProbeXRef`
+--
+
+DROP TABLE IF EXISTS `ProbeXRef`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ProbeXRef` (
+ `ProbeFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `ProbeId` int(10) unsigned NOT NULL DEFAULT 0,
+ `DataId` int(10) unsigned NOT NULL DEFAULT 0,
+ UNIQUE KEY `ProbeId` (`ProbeFreezeId`,`ProbeId`),
+ UNIQUE KEY `DataId_IDX` (`DataId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Publication`
+--
+
+DROP TABLE IF EXISTS `Publication`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Publication` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `PubMed_ID` int(10) unsigned DEFAULT NULL,
+ `Abstract` text DEFAULT NULL,
+ `Authors` text NOT NULL,
+ `Title` varchar(255) DEFAULT NULL,
+ `Journal` varchar(255) DEFAULT NULL,
+ `Volume` varchar(255) DEFAULT NULL,
+ `Pages` varchar(255) DEFAULT NULL,
+ `Month` varchar(255) DEFAULT NULL,
+ `Year` varchar(255) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`Id`),
+ UNIQUE KEY `Name` (`PubMed_ID`),
+ KEY `PubMed_ID` (`PubMed_ID`),
+ FULLTEXT KEY `Abstract1` (`Abstract`),
+ FULLTEXT KEY `Title1` (`Title`),
+ FULLTEXT KEY `Authors1` (`Authors`),
+ FULLTEXT KEY `SEARCH_FULL_IDX` (`Abstract`,`Title`,`Authors`)
+) ENGINE=MyISAM AUTO_INCREMENT=26076 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `PublishData`
+--
+
+DROP TABLE IF EXISTS `PublishData`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PublishData` (
+ `Id` int(10) unsigned NOT NULL DEFAULT 0,
+ `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `value` float(14,6) DEFAULT NULL,
+ UNIQUE KEY `DataId` (`Id`,`StrainId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `PublishFreeze`
+--
+
+DROP TABLE IF EXISTS `PublishFreeze`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PublishFreeze` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `Name` varchar(100) NOT NULL DEFAULT '',
+ `FullName` varchar(100) NOT NULL DEFAULT '',
+ `ShortName` varchar(100) NOT NULL DEFAULT '',
+ `CreateTime` date NOT NULL DEFAULT '2001-01-01',
+ `public` tinyint(4) NOT NULL DEFAULT 0,
+ `InbredSetId` smallint(5) unsigned DEFAULT 1,
+ `confidentiality` tinyint(3) DEFAULT 0,
+ `AuthorisedUsers` varchar(100) DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ KEY `InbredSetId` (`InbredSetId`)
+) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `PublishSE`
+--
+
+DROP TABLE IF EXISTS `PublishSE`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PublishSE` (
+ `DataId` int(10) unsigned NOT NULL DEFAULT 0,
+ `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `error` float NOT NULL,
+ UNIQUE KEY `DataId` (`DataId`,`StrainId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `PublishXRef`
+--
+
+DROP TABLE IF EXISTS `PublishXRef`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PublishXRef` (
+ `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `InbredSetId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `PhenotypeId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `PublicationId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `DataId` int(10) unsigned NOT NULL DEFAULT 0,
+ `mean` double DEFAULT NULL,
+ `Locus` char(50) DEFAULT NULL,
+ `LRS` double DEFAULT NULL,
+ `additive` double DEFAULT NULL,
+ `Sequence` smallint(5) unsigned NOT NULL DEFAULT 1,
+ `comments` text NOT NULL,
+ UNIQUE KEY `InbredSet` (`InbredSetId`,`Id`),
+ UNIQUE KEY `record` (`InbredSetId`,`PhenotypeId`,`PublicationId`,`Sequence`),
+ UNIQUE KEY `PhenotypeId` (`PhenotypeId`),
+ UNIQUE KEY `DataId` (`DataId`),
+ KEY `InbredSetId` (`InbredSetId`),
+ KEY `Locus` (`Locus`),
+ KEY `PublicationId` (`PublicationId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `RatSnpPattern`
+--
+
+DROP TABLE IF EXISTS `RatSnpPattern`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `RatSnpPattern` (
+ `Id` int(12) NOT NULL AUTO_INCREMENT,
+ `SnpId` int(12) NOT NULL,
+ `BN` char(1) DEFAULT NULL,
+ `F344` char(1) DEFAULT NULL,
+ `ACI` char(1) DEFAULT NULL,
+ `BBDP` char(1) DEFAULT NULL,
+ `FHH` char(1) DEFAULT NULL,
+ `FHL` char(1) DEFAULT NULL,
+ `GK` char(1) DEFAULT NULL,
+ `LE` char(1) DEFAULT NULL,
+ `LEW` char(1) DEFAULT NULL,
+ `LH` char(1) DEFAULT NULL,
+ `LL` char(1) DEFAULT NULL,
+ `LN` char(1) DEFAULT NULL,
+ `MHS` char(1) DEFAULT NULL,
+ `MNS` char(1) DEFAULT NULL,
+ `SBH` char(1) DEFAULT NULL,
+ `SBN` char(1) DEFAULT NULL,
+ `SHR` char(1) DEFAULT NULL,
+ `SHRSP` char(1) DEFAULT NULL,
+ `SR` char(1) DEFAULT NULL,
+ `SS` char(1) DEFAULT NULL,
+ `WAG` char(1) DEFAULT NULL,
+ `WLI` char(1) DEFAULT NULL,
+ `WMI` char(1) DEFAULT NULL,
+ `WKY` char(1) DEFAULT NULL,
+ `ACI_N` char(1) DEFAULT NULL,
+ `BN_N` char(1) DEFAULT NULL,
+ `BUF_N` char(1) DEFAULT NULL,
+ `F344_N` char(1) DEFAULT NULL,
+ `M520_N` char(1) DEFAULT NULL,
+ `MR_N` char(1) DEFAULT NULL,
+ `WKY_N` char(1) DEFAULT NULL,
+ `WN_N` char(1) DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ UNIQUE KEY `SnpId` (`SnpId`)
+) ENGINE=MyISAM AUTO_INCREMENT=4711685 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Sample`
+--
+
+DROP TABLE IF EXISTS `Sample`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Sample` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `Name` varchar(30) DEFAULT NULL,
+ `Age` smallint(6) NOT NULL DEFAULT 0,
+ `Sex` enum('F','M') NOT NULL DEFAULT 'F',
+ `CreateTime` date NOT NULL DEFAULT '2001-01-01',
+ `TissueType` varchar(30) DEFAULT NULL,
+ `FromSrc` varchar(10) DEFAULT NULL,
+ `ImageURL` varchar(100) DEFAULT NULL,
+ `CELURL` varchar(120) DEFAULT NULL,
+ `DATURL` varchar(100) DEFAULT NULL,
+ `CHPURL` varchar(100) DEFAULT NULL,
+ `RPTURL` varchar(100) DEFAULT NULL,
+ `EXPURL` varchar(100) DEFAULT NULL,
+ `TXTURL` varchar(100) DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ UNIQUE KEY `Name` (`StrainId`,`Name`,`CreateTime`)
+) ENGINE=MyISAM AUTO_INCREMENT=252 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `SampleXRef`
+--
+
+DROP TABLE IF EXISTS `SampleXRef`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `SampleXRef` (
+ `SampleId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `ProbeFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ PRIMARY KEY (`ProbeFreezeId`,`SampleId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `SnpAll`
+--
+
+DROP TABLE IF EXISTS `SnpAll`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `SnpAll` (
+ `Id` int(20) unsigned NOT NULL AUTO_INCREMENT,
+ `SpeciesId` smallint(5) unsigned DEFAULT 1,
+ `SnpName` char(30) DEFAULT NULL,
+ `Rs` char(30) DEFAULT NULL,
+ `Chromosome` char(2) DEFAULT NULL,
+ `Position` double DEFAULT NULL,
+ `Position_2016` double DEFAULT NULL,
+ `Alleles` char(5) DEFAULT NULL,
+ `Source` char(35) DEFAULT NULL,
+ `ConservationScore` double DEFAULT NULL,
+ `3Prime_UTR` text DEFAULT NULL,
+ `5Prime_UTR` text DEFAULT NULL,
+ `Upstream` text DEFAULT NULL,
+ `Downstream` text DEFAULT NULL,
+ `Intron` char(1) DEFAULT NULL,
+ `Non_Splice_Site` text DEFAULT NULL,
+ `Splice_Site` text DEFAULT NULL,
+ `Intergenic` char(1) DEFAULT NULL,
+ `Exon` char(1) DEFAULT NULL,
+ `Non_Synonymous_Coding` text DEFAULT NULL,
+ `Synonymous_Coding` text DEFAULT NULL,
+ `Start_Gained` text DEFAULT NULL,
+ `Start_Lost` text DEFAULT NULL,
+ `Stop_Gained` text DEFAULT NULL,
+ `Stop_Lost` text DEFAULT NULL,
+ `Unknown_Effect_In_Exon` text DEFAULT NULL,
+ `Domain` varchar(50) DEFAULT NULL,
+ `Gene` varchar(30) DEFAULT NULL,
+ `Transcript` varchar(50) DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ KEY `SnpName` (`SnpName`),
+ KEY `Rs` (`Rs`),
+ KEY `Position` (`Chromosome`,`Position`),
+ KEY `Source` (`Source`)
+) ENGINE=InnoDB AUTO_INCREMENT=84086331 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `SnpAllRat`
+--
+
+DROP TABLE IF EXISTS `SnpAllRat`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `SnpAllRat` (
+ `Id` int(20) NOT NULL AUTO_INCREMENT,
+ `SpeciesId` int(5) DEFAULT 2,
+ `SnpName` char(30) DEFAULT NULL,
+ `Chromosome` char(2) DEFAULT NULL,
+ `Position` double DEFAULT NULL,
+ `Alleles` char(5) DEFAULT NULL,
+ `Source` char(35) DEFAULT NULL,
+ `ConservationScore` double DEFAULT NULL,
+ `Domain` varchar(50) DEFAULT NULL,
+ `Gene` varchar(30) DEFAULT NULL,
+ `Transcript` varchar(50) DEFAULT NULL,
+ `Function` varchar(50) DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ KEY `SnpName` (`SnpName`),
+ KEY `Position` (`Chromosome`,`Position`),
+ KEY `Source` (`Source`)
+) ENGINE=MyISAM AUTO_INCREMENT=97663615 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `SnpAllele_to_be_deleted`
+--
+
+DROP TABLE IF EXISTS `SnpAllele_to_be_deleted`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `SnpAllele_to_be_deleted` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `Base` char(20) DEFAULT NULL,
+ `Info` char(255) DEFAULT NULL,
+ PRIMARY KEY (`Id`)
+) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `SnpPattern`
+--
+
+DROP TABLE IF EXISTS `SnpPattern`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `SnpPattern` (
+ `SnpId` int(10) unsigned NOT NULL DEFAULT 0,
+ `129P2/OlaHsd` char(1) DEFAULT NULL,
+ `129S1/SvImJ` char(1) DEFAULT NULL,
+ `129S5/SvEvBrd` char(1) DEFAULT NULL,
+ `AKR/J` char(1) DEFAULT NULL,
+ `A/J` char(1) DEFAULT NULL,
+ `BALB/cJ` char(1) DEFAULT NULL,
+ `C3H/HeJ` char(1) DEFAULT NULL,
+ `C57BL/6J` char(1) DEFAULT NULL,
+ `CAST/EiJ` char(1) DEFAULT NULL,
+ `CBA/J` char(1) DEFAULT NULL,
+ `DBA/2J` char(1) DEFAULT NULL,
+ `LP/J` char(1) DEFAULT NULL,
+ `NOD/ShiLtJ` char(1) DEFAULT NULL,
+ `NZO/HlLtJ` char(1) DEFAULT NULL,
+ `PWK/PhJ` char(1) DEFAULT NULL,
+ `SPRET/EiJ` char(1) DEFAULT NULL,
+ `WSB/EiJ` char(1) DEFAULT NULL,
+ `PWD/PhJ` char(1) DEFAULT NULL,
+ `SJL/J` char(1) DEFAULT NULL,
+ `NZL/LtJ` char(1) DEFAULT NULL,
+ `CZECHII/EiJ` char(1) DEFAULT NULL,
+ `CALB/RkJ` char(1) DEFAULT NULL,
+ `ST/bJ` char(1) DEFAULT NULL,
+ `ISS/IbgTejJ` char(1) DEFAULT NULL,
+ `C57L/J` char(1) DEFAULT NULL,
+ `Qsi5` char(1) DEFAULT NULL,
+ `B6A6_Esline_Regeneron` char(1) DEFAULT NULL,
+ `129T2/SvEmsJ` char(1) DEFAULT NULL,
+ `BALB/cByJ` char(1) DEFAULT NULL,
+ `NZB/BlNJ` char(1) DEFAULT NULL,
+ `P/J` char(1) DEFAULT NULL,
+ `I/LnJ` char(1) DEFAULT NULL,
+ `PERC/EiJ` char(1) DEFAULT NULL,
+ `TALLYHO/JngJ` char(1) DEFAULT NULL,
+ `CE/J` char(1) DEFAULT NULL,
+ `MRL/MpJ` char(1) DEFAULT NULL,
+ `PERA/EiJ` char(1) DEFAULT NULL,
+ `IS/CamRkJ` char(1) DEFAULT NULL,
+ `ZALENDE/EiJ` char(1) DEFAULT NULL,
+ `Fline` char(1) DEFAULT NULL,
+ `BTBRT<+>tf/J` char(1) DEFAULT NULL,
+ `O20` char(1) DEFAULT NULL,
+ `C58/J` char(1) DEFAULT NULL,
+ `BPH/2J` char(1) DEFAULT NULL,
+ `DDK/Pas` char(1) DEFAULT NULL,
+ `C57BL/6NHsd` char(1) DEFAULT NULL,
+ `C57BL/6NTac` char(1) DEFAULT NULL,
+ `129S4/SvJae` char(1) DEFAULT NULL,
+ `BPL/1J` char(1) DEFAULT NULL,
+ `BPN/3J` char(1) DEFAULT NULL,
+ `PL/J` char(1) DEFAULT NULL,
+ `DBA/1J` char(1) DEFAULT NULL,
+ `MSM/Ms` char(1) DEFAULT NULL,
+ `MA/MyJ` char(1) DEFAULT NULL,
+ `NZW/LacJ` char(1) DEFAULT NULL,
+ `C57BL/10J` char(1) DEFAULT NULL,
+ `C57BL/6ByJ` char(1) DEFAULT NULL,
+ `RF/J` char(1) DEFAULT NULL,
+ `C57BR/cdJ` char(1) DEFAULT NULL,
+ `129S6/SvEv` char(1) DEFAULT NULL,
+ `MAI/Pas` char(1) DEFAULT NULL,
+ `RIIIS/J` char(1) DEFAULT NULL,
+ `C57BL/6NNIH` char(1) DEFAULT NULL,
+ `FVB/NJ` char(1) DEFAULT NULL,
+ `SEG/Pas` char(1) DEFAULT NULL,
+ `MOLF/EiJ` char(1) DEFAULT NULL,
+ `C3HeB/FeJ` char(1) DEFAULT NULL,
+ `Lline` char(1) DEFAULT NULL,
+ `SKIVE/EiJ` char(1) DEFAULT NULL,
+ `C57BL/6NCrl` char(1) DEFAULT NULL,
+ `KK/HlJ` char(1) DEFAULT NULL,
+ `LG/J` char(1) DEFAULT NULL,
+ `C57BLKS/J` char(1) DEFAULT NULL,
+ `SM/J` char(1) DEFAULT NULL,
+ `NOR/LtJ` char(1) DEFAULT NULL,
+ `ILS/IbgTejJ` char(1) DEFAULT NULL,
+ `C57BL/6JOlaHsd` char(1) DEFAULT NULL,
+ `SWR/J` char(1) DEFAULT NULL,
+ `C57BL/6JBomTac` char(1) DEFAULT NULL,
+ `SOD1/EiJ` char(1) DEFAULT NULL,
+ `NON/LtJ` char(1) DEFAULT NULL,
+ `JF1/Ms` char(1) DEFAULT NULL,
+ `129X1/SvJ` char(1) DEFAULT NULL,
+ `C2T1_Esline_Nagy` char(1) DEFAULT NULL,
+ `C57BL/6NJ` char(1) DEFAULT NULL,
+ `LEWES/EiJ` char(1) DEFAULT NULL,
+ `RBA/DnJ` char(1) DEFAULT NULL,
+ `DDY/JclSidSeyFrkJ` char(1) DEFAULT NULL,
+ `SEA/GnJ` char(1) DEFAULT NULL,
+ `C57BL/6JCrl` char(1) DEFAULT NULL,
+ `EL/SuzSeyFrkJ` char(1) DEFAULT NULL,
+ `HTG/GoSfSnJ` char(1) DEFAULT NULL,
+ `129S2/SvHsd` char(1) DEFAULT NULL,
+ `MOLG/DnJ` char(1) DEFAULT NULL,
+ `BUB/BnJ` char(1) DEFAULT NULL,
+ PRIMARY KEY (`SnpId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `SnpSource`
+--
+
+DROP TABLE IF EXISTS `SnpSource`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `SnpSource` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `Name` char(35) DEFAULT NULL,
+ `DateCreated` date DEFAULT NULL,
+ `DateAdded` date DEFAULT NULL,
+ PRIMARY KEY (`Id`)
+) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Species`
+--
+
+DROP TABLE IF EXISTS `Species`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Species` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `SpeciesId` int(5) DEFAULT NULL,
+ `SpeciesName` varchar(50) DEFAULT NULL,
+ `Name` char(30) NOT NULL DEFAULT '',
+ `MenuName` char(50) DEFAULT NULL,
+ `FullName` char(100) NOT NULL DEFAULT '',
+ `TaxonomyId` int(11) DEFAULT NULL,
+ `OrderId` smallint(6) DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ KEY `Name` (`Name`)
+) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Strain`
+--
+
+DROP TABLE IF EXISTS `Strain`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Strain` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `Name` varchar(100) DEFAULT NULL,
+ `Name2` varchar(100) DEFAULT NULL,
+ `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `Symbol` char(5) DEFAULT NULL,
+ `Alias` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ UNIQUE KEY `Name` (`Name`,`SpeciesId`),
+ KEY `Symbol` (`Symbol`)
+) ENGINE=MyISAM AUTO_INCREMENT=63438 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `StrainXRef`
+--
+
+DROP TABLE IF EXISTS `StrainXRef`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `StrainXRef` (
+ `InbredSetId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `OrderId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `Used_for_mapping` char(1) DEFAULT 'N',
+ `PedigreeStatus` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`InbredSetId`,`StrainId`),
+ UNIQUE KEY `Orders` (`InbredSetId`,`OrderId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `TableComments`
+--
+
+DROP TABLE IF EXISTS `TableComments`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `TableComments` (
+ `TableName` varchar(100) NOT NULL DEFAULT '',
+ `Comment` text DEFAULT NULL,
+ PRIMARY KEY (`TableName`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `TableFieldAnnotation`
+--
+
+DROP TABLE IF EXISTS `TableFieldAnnotation`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `TableFieldAnnotation` (
+ `TableField` varchar(100) NOT NULL DEFAULT '',
+ `Foreign_Key` varchar(100) DEFAULT NULL,
+ `Annotation` text DEFAULT NULL,
+ PRIMARY KEY (`TableField`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Temp`
+--
+
+DROP TABLE IF EXISTS `Temp`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Temp` (
+ `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `dbdisplayname` varchar(255) DEFAULT NULL,
+ `Name` varchar(30) DEFAULT NULL,
+ `description` text DEFAULT NULL,
+ `createtime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '2004-01-01 12:00:00',
+ `DataId` int(11) NOT NULL DEFAULT 0,
+ `InbredSetId` smallint(5) unsigned NOT NULL DEFAULT 1,
+ `IP` varchar(20) DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ UNIQUE KEY `Name` (`Name`)
+) ENGINE=MyISAM AUTO_INCREMENT=98608 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `TempData`
+--
+
+DROP TABLE IF EXISTS `TempData`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `TempData` (
+ `Id` int(10) unsigned NOT NULL DEFAULT 0,
+ `StrainId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `value` double NOT NULL DEFAULT 0,
+ `SE` double DEFAULT NULL,
+ `NStrain` smallint(6) DEFAULT NULL,
+ UNIQUE KEY `DataId` (`Id`,`StrainId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Tissue`
+--
+
+DROP TABLE IF EXISTS `Tissue`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Tissue` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `TissueId` int(5) DEFAULT NULL,
+ `TissueName` varchar(50) DEFAULT NULL,
+ `Name` char(50) DEFAULT NULL,
+ `Short_Name` char(30) NOT NULL DEFAULT '',
+ `BIRN_lex_ID` char(30) DEFAULT NULL,
+ `BIRN_lex_Name` char(30) DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ UNIQUE KEY `Short_Name` (`Short_Name`),
+ UNIQUE KEY `Name` (`Name`)
+) ENGINE=MyISAM AUTO_INCREMENT=180 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `TissueProbeFreeze`
+--
+
+DROP TABLE IF EXISTS `TissueProbeFreeze`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `TissueProbeFreeze` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `ChipId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `StrainId` varchar(100) NOT NULL DEFAULT '0',
+ `Name` varchar(100) NOT NULL DEFAULT '',
+ `FullName` varchar(100) NOT NULL DEFAULT '',
+ `ShortName` varchar(100) NOT NULL DEFAULT '',
+ `CreateTime` date NOT NULL DEFAULT '0000-00-00',
+ `InbredSetId` smallint(5) unsigned DEFAULT 1,
+ PRIMARY KEY (`Id`),
+ UNIQUE KEY `Name` (`Name`),
+ UNIQUE KEY `FullName` (`FullName`)
+) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `TissueProbeSetData`
+--
+
+DROP TABLE IF EXISTS `TissueProbeSetData`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `TissueProbeSetData` (
+ `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `TissueID` int(10) unsigned NOT NULL DEFAULT 0,
+ `value` float NOT NULL DEFAULT 0,
+ PRIMARY KEY (`Id`,`TissueID`)
+) ENGINE=MyISAM AUTO_INCREMENT=90563 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `TissueProbeSetFreeze`
+--
+
+DROP TABLE IF EXISTS `TissueProbeSetFreeze`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `TissueProbeSetFreeze` (
+ `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+ `TissueProbeFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `AvgID` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `Name` varchar(40) DEFAULT NULL,
+ `Name2` varchar(100) NOT NULL DEFAULT '',
+ `FullName` varchar(100) NOT NULL DEFAULT '',
+ `ShortName` varchar(100) NOT NULL DEFAULT '',
+ `CreateTime` date NOT NULL DEFAULT '0000-00-00',
+ `public` tinyint(4) NOT NULL DEFAULT 0,
+ `confidentiality` tinyint(4) NOT NULL DEFAULT 0,
+ `AuthorisedUsers` varchar(100) DEFAULT NULL,
+ PRIMARY KEY (`Id`),
+ UNIQUE KEY `FullName` (`FullName`),
+ UNIQUE KEY `Name` (`Name`),
+ KEY `NameIndex` (`Name2`)
+) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `TissueProbeSetXRef`
+--
+
+DROP TABLE IF EXISTS `TissueProbeSetXRef`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `TissueProbeSetXRef` (
+ `TissueProbeSetFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0,
+ `ProbesetId` int(10) unsigned NOT NULL DEFAULT 0,
+ `DataId` int(10) unsigned NOT NULL DEFAULT 0,
+ `Mean` float DEFAULT 0,
+ `useStatus` char(1) DEFAULT NULL,
+ `Symbol` varchar(100) DEFAULT NULL,
+ `GeneId` varchar(20) DEFAULT NULL,
+ `Chr` char(3) DEFAULT NULL,
+ `Mb` double DEFAULT NULL,
+ `Mb_2016` double DEFAULT NULL,
+ `description` varchar(255) DEFAULT NULL,
+ `Probe_Target_Description` varchar(225) DEFAULT NULL,
+ PRIMARY KEY (`TissueProbeSetFreezeId`,`ProbesetId`),
+ UNIQUE KEY `DataId_IDX` (`DataId`),
+ KEY `symbol_IDX` (`Symbol`),
+ KEY `GeneId_IDX` (`GeneId`),
+ KEY `Position` (`Chr`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `TraitMetadata`
+--
+
+DROP TABLE IF EXISTS `TraitMetadata`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `TraitMetadata` (
+ `type` varchar(255) DEFAULT NULL,
+ `value` longtext DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `User`
+--
+
+DROP TABLE IF EXISTS `User`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `User` (
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `name` varchar(100) NOT NULL DEFAULT '',
+ `password` varchar(100) NOT NULL DEFAULT '',
+ `email` varchar(100) DEFAULT NULL,
+ `createtime` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `user_ip` varchar(20) DEFAULT NULL,
+ `lastlogin` datetime /* mariadb-5.3 */ NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `disable` enum('Y','N') DEFAULT 'N',
+ `privilege` enum('guest','user','admin','root') DEFAULT NULL,
+ `grpName` varchar(40) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `name_index` (`name`)
+) ENGINE=MyISAM AUTO_INCREMENT=353 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `UserPrivilege`
+--
+
+DROP TABLE IF EXISTS `UserPrivilege`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `UserPrivilege` (
+ `UserId` int(10) unsigned NOT NULL,
+ `ProbeSetFreezeId` smallint(5) unsigned NOT NULL,
+ `download_result_priv` enum('N','Y') NOT NULL DEFAULT 'N',
+ KEY `userId` (`UserId`,`ProbeSetFreezeId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `Vlookup`
+--
+
+DROP TABLE IF EXISTS `Vlookup`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Vlookup` (
+ `Id` int(11) NOT NULL AUTO_INCREMENT,
+ `VLProbeSetId` text DEFAULT NULL,
+ `VLBlatSeq` longtext DEFAULT NULL,
+ `InfoFileId` int(5) DEFAULT NULL,
+ `DatasetId` int(5) DEFAULT NULL,
+ `SpeciesId` int(5) DEFAULT NULL,
+ `TissueId` int(5) DEFAULT NULL,
+ `InbredSetId` int(5) DEFAULT NULL,
+ `GeneChipId` int(5) DEFAULT NULL,
+ `AvgMethodId` int(5) DEFAULT NULL,
+ `InfoPageName` varchar(255) DEFAULT NULL,
+ `GN_AccesionId` int(5) DEFAULT NULL,
+ `Name` varchar(100) DEFAULT NULL,
+ `GeneId` varchar(10) DEFAULT NULL,
+ `Mb` double DEFAULT NULL,
+ `Chr` varchar(10) DEFAULT NULL,
+ `Probe_set_Blat_Mb_start` double DEFAULT NULL,
+ `Probe_set_Blat_Mb_end` double DEFAULT NULL,
+ `Strand` char(1) DEFAULT NULL,
+ `TxStart` double DEFAULT NULL,
+ `TxEnd` double DEFAULT NULL,
+ `cdsStart` double DEFAULT NULL,
+ `cdsEnd` double DEFAULT NULL,
+ `exonCount` int(7) DEFAULT NULL,
+ `exonStarts` text DEFAULT NULL,
+ `exonEnds` text DEFAULT NULL,
+ `ProteinID` varchar(15) DEFAULT NULL,
+ `AlignID` varchar(10) DEFAULT NULL,
+ `kgID` varchar(10) DEFAULT NULL,
+ `NM_ID` varchar(15) DEFAULT NULL,
+ `SnpName` char(30) DEFAULT NULL,
+ `Position` double DEFAULT NULL,
+ `HMDB_ID` varchar(255) DEFAULT NULL,
+ `Symbol` varchar(100) DEFAULT NULL,
+ `description` longtext DEFAULT NULL,
+ `alias` longtext DEFAULT NULL,
+ `Full_Description` longtext DEFAULT NULL,
+ `BlatSeq` text DEFAULT NULL,
+ `ChEBI_ID` int(10) DEFAULT NULL,
+ `ChEMBL_ID` varchar(100) DEFAULT NULL,
+ `CAS_number` varchar(100) DEFAULT NULL,
+ `PubChem_ID` int(10) DEFAULT NULL,
+ `ChemSpider_ID` varchar(10) DEFAULT NULL,
+ `UNII_ID` varchar(100) DEFAULT NULL,
+ `EC_number` varchar(100) DEFAULT NULL,
+ `KEGG_ID` varchar(100) DEFAULT NULL,
+ `Molecular_Weight` varchar(100) DEFAULT NULL,
+ `Nugowiki_ID` varchar(100) DEFAULT NULL,
+ `assembly` varchar(10) DEFAULT NULL,
+ KEY `Id` (`Id`)
+) ENGINE=MyISAM AUTO_INCREMENT=753474564 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `login`
+--
+
+DROP TABLE IF EXISTS `login`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `login` (
+ `id` varchar(36) NOT NULL,
+ `user` varchar(36) DEFAULT NULL,
+ `timestamp` datetime /* mariadb-5.3 */ DEFAULT NULL,
+ `ip_address` varchar(39) DEFAULT NULL,
+ `successful` tinyint(1) NOT NULL,
+ `session_id` text DEFAULT NULL,
+ `assumed_by` varchar(36) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `user` (`user`),
+ KEY `assumed_by` (`assumed_by`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `metadata_audit`
+--
+
+DROP TABLE IF EXISTS `metadata_audit`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `metadata_audit` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `dataset_id` int(11) NOT NULL,
+ `editor` varchar(255) NOT NULL,
+ `json_diff_data` varchar(2048) NOT NULL,
+ `time_stamp` timestamp NOT NULL DEFAULT current_timestamp(),
+ PRIMARY KEY (`id`),
+ CONSTRAINT `CONSTRAINT_1` CHECK (json_valid(`json_diff_data`))
+) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `pubmedsearch`
+--
+
+DROP TABLE IF EXISTS `pubmedsearch`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `pubmedsearch` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `pubmedid` bigint(20) DEFAULT NULL,
+ `title` text DEFAULT NULL,
+ `authorfullname` text DEFAULT NULL,
+ `authorshortname` text DEFAULT NULL,
+ `institute` text DEFAULT NULL,
+ `geneid` varchar(20) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `NewIndex4` (`geneid`),
+ FULLTEXT KEY `NewIndex1` (`institute`),
+ FULLTEXT KEY `NewIndex3` (`authorfullname`,`authorshortname`)
+) ENGINE=MyISAM AUTO_INCREMENT=1401371 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `role`
+--
+
+DROP TABLE IF EXISTS `role`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `role` (
+ `the_id` varchar(36) NOT NULL,
+ `name` varchar(80) NOT NULL,
+ `description` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`the_id`),
+ UNIQUE KEY `name` (`name`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `roles_users`
+--
+
+DROP TABLE IF EXISTS `roles_users`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `roles_users` (
+ `user_id` int(11) DEFAULT NULL,
+ `role_id` int(11) DEFAULT NULL,
+ KEY `user_id` (`user_id`),
+ KEY `role_id` (`role_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `temporary`
+--
+
+DROP TABLE IF EXISTS `temporary`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `temporary` (
+ `tax_id` varchar(20) DEFAULT NULL,
+ `GeneID` varchar(20) DEFAULT NULL,
+ `Symbol` varchar(100) DEFAULT NULL,
+ `OMIM` varchar(100) DEFAULT NULL,
+ `HomoloGene` varchar(100) DEFAULT NULL,
+ `Other_GeneID` varchar(20) DEFAULT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `user`
+--
+
+DROP TABLE IF EXISTS `user`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `user` (
+ `id` varchar(36) NOT NULL,
+ `email_address` varchar(50) NOT NULL,
+ `password` text NOT NULL,
+ `full_name` varchar(50) DEFAULT NULL,
+ `organization` varchar(50) DEFAULT NULL,
+ `active` tinyint(1) NOT NULL,
+ `registration_info` text DEFAULT NULL,
+ `confirmed` text DEFAULT NULL,
+ `superuser` text DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `email_address` (`email_address`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `user_collection`
+--
+
+DROP TABLE IF EXISTS `user_collection`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `user_collection` (
+ `id` varchar(36) NOT NULL,
+ `user` varchar(36) DEFAULT NULL,
+ `name` text DEFAULT NULL,
+ `created_timestamp` datetime /* mariadb-5.3 */ DEFAULT NULL,
+ `changed_timestamp` datetime /* mariadb-5.3 */ DEFAULT NULL,
+ `members` text DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `user` (`user`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `user_openids`
+--
+
+DROP TABLE IF EXISTS `user_openids`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `user_openids` (
+ `openid_url` varchar(255) NOT NULL,
+ `user_id` varchar(36) NOT NULL,
+ PRIMARY KEY (`openid_url`),
+ KEY `user_id` (`user_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+/*!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 */;
+
+-- Dump completed on 2021-07-14 5:26:53