From d0c7631276223aae6954f7643abac262aa080e50 Mon Sep 17 00:00:00 2001
From: Arun Isaac
Date: Fri, 11 Feb 2022 11:55:14 +0530
Subject: sql: Remove database mapping code.

These tools have been greatly improved and moved to a new home at
https://git.genenetwork.org/arunisaac/dump-genenetwork-database

* sql/map-database.sh, sql/schema-from-in-db-documentation.org,
sql/schema-original.sql, sql/schema.png, sql/schema.sql, sql/schema.svg: New
files.
---
 sql/schema.sql | 2406 --------------------------------------------------------
 1 file changed, 2406 deletions(-)
 delete mode 100644 sql/schema.sql

(limited to 'sql/schema.sql')

diff --git a/sql/schema.sql b/sql/schema.sql
deleted file mode 100644
index c37754b..0000000
--- a/sql/schema.sql
+++ /dev/null
@@ -1,2406 +0,0 @@
--- This is a work-in-progress schema for the GeneNetwork database. The
--- GeneNetwork database has no foreign key constraint information. This schema
--- has them manually added. But, the work is not complete, and there may be
--- errors. A visualization of this schema can be found in schema.png and
--- schema.svg.
-
--- 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 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`),
-  FOREIGN KEY (StrainId1) REFERENCES Strain(Id),
-  FOREIGN KEY (StrainId2) REFERENCES Strain(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`),
-  FOREIGN KEY (ProbeSetFreezeId) REFERENCES ProbeSetFreeze(Id),
-  FOREIGN KEY (StrainId) REFERENCES Strain(Id),
-  FOREIGN KEY (CaseAttributeId) REFERENCES CaseAttribute(Id)
-) 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`),
-  FOREIGN KEY (InbredSetId) REFERENCES InbredSet(InbredSetId),
-  FOREIGN KEY (StrainId) REFERENCES Strain(Id),
-  FOREIGN KEY (CaseAttributeId) REFERENCES CaseAttribute(Id)
-) 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`),
-  FOREIGN KEY (DBTypeId) REFERENCES DBType(Id),
-  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`),
-  FOREIGN KEY (SpeciesId) REFERENCES Species(SpeciesId),
-  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`),
-  FOREIGN KEY (SpeciesId) REFERENCES Species(SpeciesId)
-) 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,
-  FOREIGN KEY (GeneChipId) REFERENCES GeneChip(GeneChipId),
-  FOREIGN KEY (EnsemblChipId) REFERENCES EnsemblChip(Id)
-) 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`),
-  FOREIGN KEY (SpeciesId) REFERENCES Species(SpeciesId),
-  FOREIGN KEY (GenBankID) REFERENCES Genbank(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 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`),
-  FOREIGN KEY (SpeciesId) REFERENCES Species(SpeciesId),
-  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 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`),
-  FOREIGN KEY (SpeciesId) REFERENCES Species(SpeciesId),
-  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`),
-  FOREIGN KEY (SpeciesId) REFERENCES Species(SpeciesId),
-  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`),
-  FOREIGN KEY (StrainId) REFERENCES Strain(Id)
-) 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`),
-  FOREIGN KEY (InbredSetId) REFERENCES InbredSet(InbredSetId),
-) 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`),
-  FOREIGN KEY (GenoFreezeId) REFERENCES GenoFreeze(Id),
-  FOREIGN KEY (GenoId) REFERENCES Geno(Id),
-  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`),
-  FOREIGN KEY (SpeciesId) REFERENCES Species(SpeciesId),
-  FOREIGN KEY (MappingMethodId) REFERENCES MappingMethod(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`),
-  FOREIGN KEY (SpeciesId) REFERENCES Species(SpeciesId),
-  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`),
-  FOREIGN KEY (IndelId) REFERENCES IndelAll(Id),
-  FOREIGN KEY (StrainId1) REFERENCES Strain(Id),
-  FOREIGN KEY (StrainId2) REFERENCES Strain(Id)
-) 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 DEFAULT NULL,
-  `UserLevel` int(8) DEFAULT NULL,
-  `OrganizationId` int(5) NOT NULL,
-  `InvestigatorId` int(5) NOT NULL AUTO_INCREMENT,
-  PRIMARY KEY (`InvestigatorId`),
-  FOREIGN KEY (OrganizationId) REFERENCES Organizations(OrganizationId)
-) 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 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`),
-  FOREIGN KEY (StrainId) REFERENCES Strain(Id)
-) 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`),
-  FOREIGN KEY (ProbeSetId) REFERENCES ProbeSet(ProbeSetId),
-  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`),
-  FOREIGN KEY (StrainId) REFERENCES Strain(Id)
-) 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`),
-  FOREIGN KEY (TissueId) REFERENCES Tissue(TissueId),
-  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`),
-  FOREIGN KEY (ProbeFreezeId) REFERENCES ProbeFreeze(ProbeFreezeId),
-  FOREIGN KEY (ProbeId) REFERENCES Probe(Id)
-) 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`),
-  FOREIGN KEY (StrainId) REFERENCES Strain(Id)
-) 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`),
-  FOREIGN KEY (HomoloGeneID) REFERENCES Homologene(HomologeneId),
-  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`),
-  FOREIGN KEY (StrainId) REFERENCES Strain(Id)
-) 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`),
-  FOREIGN KEY (ProbeFreezeId) REFERENCES ProbeFreeze(ProbeFreezeId),
-  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`),
-  FOREIGN KEY (StrainId) REFERENCES Strain(Id)
-) 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`),
-  FOREIGN KEY (ProbeSetFreezeId) REFERENCES ProbeSetFreeze(Id),
-  FOREIGN KEY (ProbeSetId) REFERENCES ProbeSet(Id),
-  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`),
-  FOREIGN KEY (ProbeFreezeId) REFERENCES ProbeFreeze(ProbeFreezeId),
-  FOREIGN KEY (ProbeId) REFERENCES Probe(Id)
-) 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`),
-  FOREIGN KEY (StrainId) REFERENCES Strain(Id)
-) 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`),
-  FOREIGN KEY (InbredSetId) REFERENCES InbredSet(InbredSetId),
-  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`),
-  FOREIGN KEY (StrainId) REFERENCES Strain(Id)
-) 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`),
-  FOREIGN KEY (InbredSetId) REFERENCES InbredSet(InbredSetId),
-  FOREIGN KEY (PhenotypeId) REFERENCES Phenotype(Id),
-  FOREIGN KEY (PublicationId) REFERENCES Publication(Id),
-  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`),
-  FOREIGN KEY (SpeciesId) REFERENCES Species(SpeciesId),
-  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`),
-  FOREIGN KEY (SpeciesId) REFERENCES Species(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`),
-  FOREIGN KEY (InbredSetId) REFERENCES InbredSet(InbredSetId),
-  FOREIGN KEY (StrainId) REFERENCES Strain(Id)
-) 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 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`),
-  FOREIGN KEY (InbredSetId) REFERENCES InbredSet(InbredSetId)
-) 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`),
-  FOREIGN KEY (StrainId) REFERENCES Strain(Id)
-) 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`),
-  FOREIGN KEY (StrainId) REFERENCES Strain(Id)
-) 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`),
-  FOREIGN KEY (TissueID) REFERENCES Tissue(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`),
-  FOREIGN KEY (TissueProbeFreezeId) REFERENCES TissueProbeFreeze(Id),
-  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`),
-  FOREIGN KEY (TissueProbeSetFreezeId) REFERENCES TissueProbeSetFreeze(Id),
-  FOREIGN KEY (ProbesetId) REFERENCES ProbeSet(Id),
-  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 NOT NULL DEFAULT '0000-00-00 00:00:00',
-  `user_ip` varchar(20) DEFAULT NULL,
-  `lastlogin` datetime 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`),
-  FOREIGN KEY (UserId) REFERENCES User(id),
-  FOREIGN KEY (ProbeSetFreezeId) REFERENCES ProbeSetFreeze(Id)
-) 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 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`),
-  FOREIGN KEY (user) REFERENCES user(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 DEFAULT NULL,
-  `changed_timestamp` datetime DEFAULT NULL,
-  `members` text DEFAULT NULL,
-  PRIMARY KEY (`id`),
-  FOREIGN KEY (user) REFERENCES user(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`),
-  FOREIGN KEY (user_id) REFERENCES user(id),
-  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
-- 
cgit v1.2.3

