about summary refs log tree commit diff
path: root/docs
diff options
context:
space:
mode:
authorPjotr Prins <pjotr.public01@thebird.nl>2026-10-03 10:56:10 +0000
committerPjotr <wrk@bosa.lan>2026-10-03 10:56:10 +0000
commiteb18351880af6eb978103eb902855f668206dbec (patch)
tree6c31b338c1c446ef9ad8b574ce13963ce22a0e0f /docs
parent13c3ecfe01c9272b91f10dd8e2941e5f14e6a5fb (diff)
downloadgenenetwork4-eb18351880af6eb978103eb902855f668206dbec.tar.gz
doc: Add db_webqtl MariaDB schema dump.
* docs/mariadb_db-webqtl.md: New file.  CREATE TABLE statement for
each of the 112 tables in db_webqtl, dumped with mysqldump --no-data
and grouped under a linked table of contents.
Diffstat (limited to 'docs')
-rw-r--r--docs/mariadb_db-webqtl.md2204
1 files changed, 2204 insertions, 0 deletions
diff --git a/docs/mariadb_db-webqtl.md b/docs/mariadb_db-webqtl.md
new file mode 100644
index 0000000..66d923a
--- /dev/null
+++ b/docs/mariadb_db-webqtl.md
@@ -0,0 +1,2204 @@
+# db_webqtl MariaDB schema
+
+Table definitions dumped from `db_webqtl` via
+`mysqldump --no-data`. Schema only, no data.
+
+## Tables
+
+- [AccessLog](#accesslog)
+- [AvgMethod](#avgmethod)
+- [BACKUP_CaseAttribute_20240601T01_34_02__842794](#backup_caseattribute_20240601t01_34_02__842794)
+- [BACKUP_CaseAttributeXRefNew_20240601T01_34_02__842794](#backup_caseattributexrefnew_20240601t01_34_02__842794)
+- [BXDSnpPosition](#bxdsnpposition)
+- [CaseAttribute](#caseattribute)
+- [caseattributes_audit](#caseattributes_audit)
+- [CaseAttributeXRef](#caseattributexref)
+- [CaseAttributeXRefNew](#caseattributexrefnew)
+- [CeleraINFO_mm6](#celerainfo_mm6)
+- [Chr_Length](#chr_length)
+- [Dataset_mbat](#dataset_mbat)
+- [DatasetMapInvestigator](#datasetmapinvestigator)
+- [Datasets](#datasets)
+- [DatasetStatus](#datasetstatus)
+- [DBList](#dblist)
+- [DBType](#dbtype)
+- [Docs](#docs)
+- [EnsemblChip](#ensemblchip)
+- [EnsemblProbe](#ensemblprobe)
+- [EnsemblProbeLocation](#ensemblprobelocation)
+- [Genbank](#genbank)
+- [GeneCategory](#genecategory)
+- [GeneChip](#genechip)
+- [GeneChipEnsemblXRef](#genechipensemblxref)
+- [GeneIDXRef](#geneidxref)
+- [GeneInfo](#geneinfo)
+- [GeneList](#genelist)
+- [GeneList081722](#genelist081722)
+- [GeneList_rn3](#genelist_rn3)
+- [GeneList_rn33](#genelist_rn33)
+- [GeneMap_cuiyan](#genemap_cuiyan)
+- [GeneRIF](#generif)
+- [GeneRIF_BASIC](#generif_basic)
+- [GeneRIFXRef](#generifxref)
+- [Geno](#geno)
+- [GenoCode](#genocode)
+- [GenoData](#genodata)
+- [GenoFile](#genofile)
+- [GenoFreeze](#genofreeze)
+- [GenoSE](#genose)
+- [GenoXRef](#genoxref)
+- [GORef](#goref)
+- [H2](#h2)
+- [Homologene](#homologene)
+- [InbredSet](#inbredset)
+- [InbredSetMapInvestigator](#inbredsetmapinvestigator)
+- [IndelAll](#indelall)
+- [IndelXRef](#indelxref)
+- [InfoFiles](#infofiles)
+- [InfoFilesUser_md5](#infofilesuser_md5)
+- [Investigators](#investigators)
+- [LCorrRamin3](#lcorrramin3)
+- [login](#login)
+- [MachineAccessLog](#machineaccesslog)
+- [MappingMethod](#mappingmethod)
+- [metadata_audit](#metadata_audit)
+- [mytest1](#mytest1)
+- [News](#news)
+- [NStrain](#nstrain)
+- [Organizations](#organizations)
+- [Phenotype](#phenotype)
+- [Probe](#probe)
+- [ProbeData](#probedata)
+- [ProbeFreeze](#probefreeze)
+- [ProbeH2](#probeh2)
+- [ProbeSE](#probese)
+- [ProbeSet](#probeset)
+- [ProbeSetData](#probesetdata)
+- [ProbeSetFreeze](#probesetfreeze)
+- [ProbeSetSE](#probesetse)
+- [ProbeSetXRef](#probesetxref)
+- [ProbeSetXRef_old](#probesetxref_old)
+- [ProbeXRef](#probexref)
+- [Publication](#publication)
+- [Publication_Test](#publication_test)
+- [PublishData](#publishdata)
+- [PublishFreeze](#publishfreeze)
+- [PublishSE](#publishse)
+- [PublishXRef](#publishxref)
+- [pubmedsearch](#pubmedsearch)
+- [RatSnpPattern](#ratsnppattern)
+- [role](#role)
+- [roles_users](#roles_users)
+- [Sample](#sample)
+- [SampleXRef](#samplexref)
+- [SnpAll](#snpall)
+- [SnpAllele_to_be_deleted](#snpallele_to_be_deleted)
+- [SnpAllRat](#snpallrat)
+- [SnpPattern](#snppattern)
+- [SnpSource](#snpsource)
+- [Species](#species)
+- [Strain](#strain)
+- [StrainXRef](#strainxref)
+- [TableComments](#tablecomments)
+- [TableFieldAnnotation](#tablefieldannotation)
+- [Temp](#temp)
+- [TempData](#tempdata)
+- [temporary](#temporary)
+- [test_table](#test_table)
+- [Tissue](#tissue)
+- [TissueProbeFreeze](#tissueprobefreeze)
+- [TissueProbeSetData](#tissueprobesetdata)
+- [TissueProbeSetFreeze](#tissueprobesetfreeze)
+- [TissueProbeSetXRef](#tissueprobesetxref)
+- [TraitMetadata](#traitmetadata)
+- [User](#user)
+- [user](#user)
+- [user_collection](#user_collection)
+- [user_openids](#user_openids)
+- [UserPrivilege](#userprivilege)
+- [Vlookup](#vlookup)
+
+## AccessLog
+
+```sql
+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=InnoDB AUTO_INCREMENT=1511441 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## AvgMethod
+
+```sql
+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=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## BACKUP_CaseAttribute_20240601T01_34_02__842794
+
+```sql
+CREATE TABLE `BACKUP_CaseAttribute_20240601T01_34_02__842794` (
+  `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+  `Name` varchar(30) NOT NULL DEFAULT '',
+  `Description` varchar(250) DEFAULT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## BACKUP_CaseAttributeXRefNew_20240601T01_34_02__842794
+
+```sql
+CREATE TABLE `BACKUP_CaseAttributeXRefNew_20240601T01_34_02__842794` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `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`),
+  UNIQUE KEY `Id` (`Id`)
+) ENGINE=InnoDB AUTO_INCREMENT=390448 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## BXDSnpPosition
+
+```sql
+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=InnoDB AUTO_INCREMENT=7791982 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## CaseAttribute
+
+```sql
+CREATE TABLE `CaseAttribute` (
+  `InbredSetId` int(5) unsigned NOT NULL,
+  `CaseAttributeId` int(5) unsigned NOT NULL,
+  `Name` varchar(30) NOT NULL,
+  `Description` varchar(250) NOT NULL,
+  PRIMARY KEY (`InbredSetId`,`CaseAttributeId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## caseattributes_audit
+
+```sql
+CREATE TABLE `caseattributes_audit` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `status` enum('review','rejected','approved') NOT NULL,
+  `editor` varchar(255) NOT NULL,
+  `json_diff_data` longtext DEFAULT 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=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## CaseAttributeXRef
+
+```sql
+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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## CaseAttributeXRefNew
+
+```sql
+CREATE TABLE `CaseAttributeXRefNew` (
+  `InbredSetId` int(5) unsigned NOT NULL,
+  `StrainId` int(20) unsigned NOT NULL,
+  `CaseAttributeId` int(5) unsigned NOT NULL,
+  `Value` varchar(100) NOT NULL,
+  PRIMARY KEY (`InbredSetId`,`StrainId`,`CaseAttributeId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## CeleraINFO_mm6
+
+```sql
+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=InnoDB AUTO_INCREMENT=3028848 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## Chr_Length
+
+```sql
+CREATE TABLE `Chr_Length` (
+  `Name` char(3) NOT NULL DEFAULT '',
+  `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 0,
+  `OrderId` smallint(5) unsigned NOT NULL,
+  `Length` int(10) unsigned NOT NULL DEFAULT 0,
+  `Length_2016` int(10) unsigned NOT NULL DEFAULT 0,
+  `Length_mm8` int(10) unsigned DEFAULT NULL,
+  PRIMARY KEY (`SpeciesId`,`OrderId`),
+  UNIQUE KEY `nameIdx` (`SpeciesId`,`Name`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## Dataset_mbat
+
+```sql
+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=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## DatasetMapInvestigator
+
+```sql
+CREATE TABLE `DatasetMapInvestigator` (
+  `Id` mediumint(9) NOT NULL AUTO_INCREMENT,
+  `DatasetId` int(6) NOT NULL,
+  `ProbeFreezeId` int(6) DEFAULT NULL,
+  `InvestigatorId` int(6) NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB AUTO_INCREMENT=2409 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## Datasets
+
+```sql
+CREATE TABLE `Datasets` (
+  `DatasetId` int(6) NOT NULL AUTO_INCREMENT,
+  `ProbeFreezeId` int(8) DEFAULT NULL,
+  `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=InnoDB AUTO_INCREMENT=449 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## DatasetStatus
+
+```sql
+CREATE TABLE `DatasetStatus` (
+  `DatasetStatusId` int(5) NOT NULL,
+  `DatasetStatusName` varchar(20) DEFAULT NULL,
+  UNIQUE KEY `DatasetStatusId` (`DatasetStatusId`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## DBList
+
+```sql
+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=InnoDB AUTO_INCREMENT=956 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## DBType
+
+```sql
+CREATE TABLE `DBType` (
+  `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+  `Name` char(30) NOT NULL DEFAULT '',
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## Docs
+
+```sql
+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=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## EnsemblChip
+
+```sql
+CREATE TABLE `EnsemblChip` (
+  `Id` int(11) NOT NULL,
+  `ProbeSetSize` int(11) NOT NULL,
+  `Name` varchar(40) NOT NULL,
+  `Type` enum('AFFY','OLIGO') DEFAULT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## EnsemblProbe
+
+```sql
+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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## EnsemblProbeLocation
+
+```sql
+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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## Genbank
+
+```sql
+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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## GeneCategory
+
+```sql
+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=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## GeneChip
+
+```sql
+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=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## GeneChipEnsemblXRef
+
+```sql
+CREATE TABLE `GeneChipEnsemblXRef` (
+  `GeneChipId` int(11) NOT NULL,
+  `EnsemblChipId` int(11) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## GeneIDXRef
+
+```sql
+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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## GeneInfo
+
+```sql
+CREATE TABLE `GeneInfo` (
+  `Id` int(10) NOT NULL AUTO_INCREMENT,
+  `GeneId` int(10) DEFAULT NULL,
+  `TaxId` int(10) DEFAULT NULL,
+  `SpeciesId` int(10) DEFAULT NULL,
+  `Symbol` varchar(255) DEFAULT NULL,
+  `Alias` longtext DEFAULT NULL,
+  `Chr` char(3) DEFAULT NULL,
+  `Mb` double DEFAULT NULL,
+  `Probe_set_Blat_Mb_start` double DEFAULT NULL,
+  `Probe_set_Blat_Mb_end` double DEFAULT NULL,
+  `BlatSeq` text DEFAULT NULL,
+  `Strand_Probe` char(1) DEFAULT NULL,
+  `Strand_Gene` char(1) DEFAULT NULL,
+  `OMIM` varchar(20) DEFAULT NULL,
+  `HomoloGeneID` varchar(20) DEFAULT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `GeneId_Symbol` (`GeneId`,`Symbol`)
+) ENGINE=InnoDB AUTO_INCREMENT=9560977 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## GeneList
+
+```sql
+CREATE TABLE `GeneList` (
+  `SpeciesId` int(5) unsigned NOT NULL DEFAULT 1,
+  `Id` int(10) unsigned NOT NULL,
+  `GeneSymbol` varchar(15) DEFAULT NULL,
+  `GeneDescription` mediumtext 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` mediumtext DEFAULT NULL,
+  `exonEnds` mediumtext 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` mediumtext DEFAULT NULL,
+  `exonEnds_mm8` mediumtext DEFAULT NULL,
+  `cdsStart_mm8` double DEFAULT NULL,
+  `cdsEnd_mm8` double DEFAULT NULL,
+  `Chromosome_mm8` varchar(10) DEFAULT NULL,
+  `Info_mm9` mediumtext 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=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## GeneList081722
+
+```sql
+CREATE TABLE `GeneList081722` (
+  `SpeciesId` int(5) unsigned NOT NULL DEFAULT 1,
+  `Id` int(20) unsigned NOT NULL AUTO_INCREMENT,
+  `GeneSymbol` varchar(20) DEFAULT NULL,
+  `GeneDescription` text DEFAULT NULL,
+  `alias` longtext DEFAULT NULL,
+  `Chr_mm11` varchar(10) DEFAULT NULL,
+  `TxStart_mm11` double DEFAULT NULL,
+  `TxEnd_mm11` double DEFAULT NULL,
+  `Strand_mm11` char(1) DEFAULT NULL,
+  `Chr_mm10` varchar(10) DEFAULT NULL,
+  `TxStart_mm10` double DEFAULT NULL,
+  `TxEnd_mm10` double DEFAULT NULL,
+  `Strand_mm10` char(1) DEFAULT NULL,
+  `Chr_mm9` varchar(10) DEFAULT NULL,
+  `TxStart_mm9` double DEFAULT NULL,
+  `TxEnd_mm9` double DEFAULT NULL,
+  `Strand_mm9` char(1) DEFAULT NULL,
+  `Chr_rn7` varchar(10) DEFAULT NULL,
+  `TxStart_rn7` double DEFAULT NULL,
+  `TxEnd_rn7` double DEFAULT NULL,
+  `Strand_rn7` char(1) DEFAULT NULL,
+  `Chr_rn6` varchar(10) DEFAULT NULL,
+  `TxStart_rn6` double DEFAULT NULL,
+  `TxEnd_rn6` double DEFAULT NULL,
+  `Strand_rn6` char(1) DEFAULT NULL,
+  `GeneID` varchar(15) DEFAULT NULL,
+  `NM_ID` varchar(20) DEFAULT NULL,
+  `kgID` varchar(10) DEFAULT NULL,
+  `GenBankID` varchar(20) DEFAULT NULL,
+  `UnigenID` varchar(20) DEFAULT NULL,
+  `ProteinID` varchar(20) 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,
+  `cdsEnd` double DEFAULT NULL,
+  `RGD_ID` int(20) DEFAULT NULL,
+  `ENSEMBL_ID` varchar(50) DEFAULT NULL,
+  PRIMARY KEY (`Id`),
+  UNIQUE KEY `geneId` (`SpeciesId`,`Id`),
+  KEY `geneSymbol` (`GeneSymbol`),
+  KEY `geneSymbol2` (`SpeciesId`,`GeneSymbol`),
+  KEY `Loc1` (`SpeciesId`,`Chr_mm10`,`TxStart_mm10`),
+  KEY `Loc2` (`SpeciesId`,`Chr_mm10`,`TxEnd_mm10`)
+) ENGINE=InnoDB AUTO_INCREMENT=142506 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## GeneList_rn3
+
+```sql
+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=InnoDB AUTO_INCREMENT=14917 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## GeneList_rn33
+
+```sql
+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=InnoDB AUTO_INCREMENT=9790 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## GeneMap_cuiyan
+
+```sql
+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=InnoDB AUTO_INCREMENT=10537 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## GeneRIF
+
+```sql
+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` mediumtext 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=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## GeneRIF_BASIC
+
+```sql
+CREATE TABLE `GeneRIF_BASIC` (
+  `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 1,
+  `TaxID` int(10) DEFAULT NULL,
+  `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` mediumtext DEFAULT NULL,
+  `VersionId` smallint(5) unsigned NOT NULL,
+  PRIMARY KEY (`GeneId`,`SpeciesId`,`createtime`,`PubMed_ID`,`VersionId`),
+  KEY `symbol` (`symbol`,`SpeciesId`,`createtime`),
+  FULLTEXT KEY `commts` (`comment`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## GeneRIFXRef
+
+```sql
+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=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## Geno
+
+```sql
+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` longtext 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`)
+) ENGINE=InnoDB AUTO_INCREMENT=1140082 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## GenoCode
+
+```sql
+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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## GenoData
+
+```sql
+CREATE TABLE `GenoData` (
+  `Id` int(10) unsigned NOT NULL DEFAULT 0,
+  `StrainId` int(5) DEFAULT NULL,
+  `value` float NOT NULL,
+  UNIQUE KEY `DataId` (`Id`,`StrainId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## GenoFile
+
+```sql
+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=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## GenoFreeze
+
+```sql
+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=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## GenoSE
+
+```sql
+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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## GenoXRef
+
+```sql
+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=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## GORef
+
+```sql
+CREATE TABLE `GORef` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `goterm` varchar(255) DEFAULT NULL,
+  `genes` text DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=17510 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## H2
+
+```sql
+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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## Homologene
+
+```sql
+CREATE TABLE `Homologene` (
+  `HomologeneId` int(11) DEFAULT NULL,
+  `GeneId` int(11) DEFAULT NULL,
+  `TaxonomyId` int(11) DEFAULT NULL,
+  KEY `GeneId` (`GeneId`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## InbredSet
+
+```sql
+CREATE TABLE `InbredSet` (
+  `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+  `InbredSetId` int(5) unsigned NOT 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,
+  `Description` longtext DEFAULT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## InbredSetMapInvestigator
+
+```sql
+CREATE TABLE `InbredSetMapInvestigator` (
+  `Id` mediumint(9) NOT NULL AUTO_INCREMENT,
+  `InbredSetId` int(6) NOT NULL DEFAULT 0,
+  `InvestigatorId` int(6) NOT NULL DEFAULT 177,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## IndelAll
+
+```sql
+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=InnoDB AUTO_INCREMENT=142895 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## IndelXRef
+
+```sql
+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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## InfoFiles
+
+```sql
+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=InnoDB AUTO_INCREMENT=1530 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## InfoFilesUser_md5
+
+```sql
+CREATE TABLE `InfoFilesUser_md5` (
+  `Username` varchar(16) DEFAULT NULL,
+  `Password` varchar(32) DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## Investigators
+
+```sql
+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(255) DEFAULT NULL,
+  `UserDate` datetime /* mariadb-5.3 */ DEFAULT NULL,
+  `UserLevel` int(8) DEFAULT NULL,
+  `active` enum('0','1') DEFAULT NULL,
+  `token` varchar(255) DEFAULT NULL,
+  `OrganizationId` int(5) DEFAULT NULL,
+  `InvestigatorId` int(5) NOT NULL AUTO_INCREMENT,
+  PRIMARY KEY (`InvestigatorId`)
+) ENGINE=InnoDB AUTO_INCREMENT=208 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## LCorrRamin3
+
+```sql
+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=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## login
+
+```sql
+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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## MachineAccessLog
+
+```sql
+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=InnoDB AUTO_INCREMENT=514946 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## MappingMethod
+
+```sql
+CREATE TABLE `MappingMethod` (
+  `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+  `Name` varchar(100) NOT NULL DEFAULT '',
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## metadata_audit
+
+```sql
+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` longtext DEFAULT 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=1228 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## mytest1
+
+```sql
+CREATE TABLE `mytest1` (
+  `Id` int(10) unsigned NOT NULL DEFAULT 0,
+  `StrainId` mediumint(8) unsigned NOT NULL DEFAULT 0,
+  `value` float NOT NULL,
+  PRIMARY KEY (`Id`,`StrainId`),
+  KEY `StrainId` (`StrainId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## News
+
+```sql
+CREATE TABLE `News` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `date` date DEFAULT NULL,
+  `details` text DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=296 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## NStrain
+
+```sql
+CREATE TABLE `NStrain` (
+  `DataId` int(10) unsigned DEFAULT NULL,
+  `StrainId` int(20) DEFAULT NULL,
+  `count` varchar(5) DEFAULT NULL,
+  UNIQUE KEY `DataId` (`DataId`,`StrainId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## Organizations
+
+```sql
+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=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## Phenotype
+
+```sql
+CREATE TABLE `Phenotype` (
+  `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+  `Pre_publication_description` mediumtext DEFAULT NULL,
+  `Post_publication_description` mediumtext DEFAULT NULL,
+  `Original_description` mediumtext DEFAULT NULL,
+  `Units` varchar(100) NOT NULL DEFAULT 'Unknown',
+  `Pre_publication_abbreviation` varchar(60) DEFAULT NULL,
+  `Post_publication_abbreviation` varchar(60) 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`(250)),
+  KEY `Pre_publication_description_Index` (`Pre_publication_description`(250)),
+  KEY `Pre_publication_abbreviation_Index` (`Pre_publication_abbreviation`),
+  KEY `Post_publication_abbreviation_Index` (`Post_publication_abbreviation`),
+  FULLTEXT KEY `index_table` (`Post_publication_description`,`Pre_publication_description`,`Pre_publication_abbreviation`,`Post_publication_abbreviation`,`Lab_code`)
+) ENGINE=InnoDB AUTO_INCREMENT=47278 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## Probe
+
+```sql
+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=InnoDB AUTO_INCREMENT=19054073 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## ProbeData
+
+```sql
+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=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## ProbeFreeze
+
+```sql
+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`)
+) ENGINE=InnoDB AUTO_INCREMENT=451 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## ProbeH2
+
+```sql
+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=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## ProbeSE
+
+```sql
+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=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## ProbeSet
+
+```sql
+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` mediumtext DEFAULT NULL,
+  `TargetSeq` mediumtext 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` mediumtext DEFAULT 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,
+  `HGNC_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,
+  `id64` varchar(100) 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 `ft_ProbeSet_Symbol` (`Symbol`),
+  FULLTEXT KEY `ft_ProbeSet_RefSeq_TranscriptId` (`RefSeq_TranscriptId`),
+  FULLTEXT KEY `ft_ProbeSet_Name` (`Name`),
+  FULLTEXT KEY `ft_ProbeSet_Alias` (`alias`),
+  FULLTEXT KEY `ft_ProbeSet_full` (`Name`,`description`,`Symbol`,`alias`,`GenbankId`,`UniGeneId`,`Probe_Target_Description`)
+) ENGINE=InnoDB AUTO_INCREMENT=13424654 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## ProbeSetData
+
+```sql
+CREATE TABLE `ProbeSetData` (
+  `Id` int(10) unsigned NOT NULL DEFAULT 0,
+  `StrainId` int(20) NOT NULL,
+  `value` float NOT NULL,
+  UNIQUE KEY `DataId` (`Id`,`StrainId`),
+  KEY `strainid` (`StrainId`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## ProbeSetFreeze
+
+```sql
+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`)
+) ENGINE=InnoDB AUTO_INCREMENT=1083 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## ProbeSetSE
+
+```sql
+CREATE TABLE `ProbeSetSE` (
+  `DataId` int(10) unsigned NOT NULL DEFAULT 0,
+  `StrainId` int(20) NOT NULL,
+  `error` float DEFAULT NULL,
+  PRIMARY KEY (`DataId`,`StrainId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## ProbeSetXRef
+
+```sql
+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` varchar(50) DEFAULT NULL,
+  `LRS` double DEFAULT NULL,
+  `pValue` double DEFAULT NULL,
+  `additive` double DEFAULT NULL,
+  `h2` float DEFAULT NULL,
+  PRIMARY KEY (`DataId`),
+  KEY `ProbeSetFreezeId` (`ProbeSetFreezeId`),
+  KEY `ProbeSetId` (`ProbeSetId`),
+  KEY `Locus_2` (`Locus`(5))
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## ProbeSetXRef_old
+
+```sql
+CREATE TABLE `ProbeSetXRef_old` (
+  `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` varchar(50) DEFAULT NULL,
+  `LRS` double DEFAULT NULL,
+  `pValue` double DEFAULT NULL,
+  `additive` double DEFAULT NULL,
+  `h2` float DEFAULT NULL,
+  PRIMARY KEY (`ProbeSetFreezeId`,`ProbeSetId`),
+  UNIQUE KEY `DataId_IDX` (`DataId`),
+  KEY `Locus_IDX` (`Locus`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## ProbeXRef
+
+```sql
+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=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## Publication
+
+```sql
+CREATE TABLE `Publication` (
+  `Id` int(10) NOT NULL AUTO_INCREMENT,
+  `PubMed_ID` int(10) unsigned DEFAULT NULL,
+  `Abstract` mediumtext DEFAULT NULL,
+  `Authors` mediumtext 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`),
+  FULLTEXT KEY `index_table` (`Title`,`Abstract`,`Authors`)
+) ENGINE=InnoDB AUTO_INCREMENT=39815 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## Publication_Test
+
+```sql
+CREATE TABLE `Publication_Test` (
+  `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+  `PubMed_ID` int(10) unsigned DEFAULT NULL,
+  `Abstract` mediumtext DEFAULT NULL,
+  `Authors` mediumtext 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`)
+) ENGINE=InnoDB AUTO_INCREMENT=26076 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## PublishData
+
+```sql
+CREATE TABLE `PublishData` (
+  `Id` int(10) unsigned NOT NULL DEFAULT 0,
+  `StrainId` int(20) NOT NULL,
+  `value` float(14,6) DEFAULT NULL,
+  UNIQUE KEY `DataId` (`Id`,`StrainId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## PublishFreeze
+
+```sql
+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`)
+) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## PublishSE
+
+```sql
+CREATE TABLE `PublishSE` (
+  `DataId` int(10) unsigned NOT NULL DEFAULT 0,
+  `StrainId` int(20) NOT NULL,
+  `error` float NOT NULL,
+  UNIQUE KEY `DataId` (`DataId`,`StrainId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## PublishXRef
+
+```sql
+CREATE TABLE `PublishXRef` (
+  `Id` int(10) unsigned NOT NULL,
+  `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` mediumtext NOT NULL,
+  `NSamples` int(11) DEFAULT 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_IDX` (`Locus`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## pubmedsearch
+
+```sql
+CREATE TABLE `pubmedsearch` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `pubmedid` bigint(20) DEFAULT NULL,
+  `title` mediumtext DEFAULT NULL,
+  `authorfullname` mediumtext DEFAULT NULL,
+  `authorshortname` mediumtext DEFAULT NULL,
+  `institute` mediumtext DEFAULT NULL,
+  `geneid` varchar(20) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  KEY `NewIndex4` (`geneid`),
+  FULLTEXT KEY `NewIndex1` (`institute`),
+  FULLTEXT KEY `NewIndex3` (`authorfullname`,`authorshortname`)
+) ENGINE=InnoDB AUTO_INCREMENT=1401371 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## RatSnpPattern
+
+```sql
+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=InnoDB AUTO_INCREMENT=4711685 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## role
+
+```sql
+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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## roles_users
+
+```sql
+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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## Sample
+
+```sql
+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=InnoDB AUTO_INCREMENT=252 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## SampleXRef
+
+```sql
+CREATE TABLE `SampleXRef` (
+  `SampleId` smallint(5) unsigned NOT NULL DEFAULT 0,
+  `ProbeFreezeId` smallint(5) unsigned NOT NULL DEFAULT 0,
+  PRIMARY KEY (`ProbeFreezeId`,`SampleId`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## SnpAll
+
+```sql
+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` mediumtext DEFAULT NULL,
+  `5Prime_UTR` mediumtext DEFAULT NULL,
+  `Upstream` mediumtext DEFAULT NULL,
+  `Downstream` mediumtext DEFAULT NULL,
+  `Intron` char(1) DEFAULT NULL,
+  `Non_Splice_Site` mediumtext DEFAULT NULL,
+  `Splice_Site` mediumtext DEFAULT NULL,
+  `Intergenic` char(1) DEFAULT NULL,
+  `Exon` char(1) DEFAULT NULL,
+  `Non_Synonymous_Coding` mediumtext DEFAULT NULL,
+  `Synonymous_Coding` mediumtext DEFAULT NULL,
+  `Start_Gained` mediumtext DEFAULT NULL,
+  `Start_Lost` mediumtext DEFAULT NULL,
+  `Stop_Gained` mediumtext DEFAULT NULL,
+  `Stop_Lost` mediumtext DEFAULT NULL,
+  `Unknown_Effect_In_Exon` mediumtext 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=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## SnpAllele_to_be_deleted
+
+```sql
+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=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## SnpAllRat
+
+```sql
+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=InnoDB AUTO_INCREMENT=97663615 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## SnpPattern
+
+```sql
+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=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## SnpSource
+
+```sql
+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=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## Species
+
+```sql
+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 '',
+  `Family` varchar(50) DEFAULT NULL,
+  `FamilyOrderId` smallint(6) DEFAULT NULL,
+  `TaxonomyId` int(11) DEFAULT NULL,
+  `OrderId` smallint(6) DEFAULT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `Name` (`Name`)
+) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## Strain
+
+```sql
+CREATE TABLE `Strain` (
+  `Id` int(20) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(100) DEFAULT NULL,
+  `Name2` varchar(100) DEFAULT NULL,
+  `SpeciesId` smallint(5) unsigned NOT NULL DEFAULT 0,
+  `Symbol` varchar(20) DEFAULT NULL,
+  `Alias` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`Id`),
+  UNIQUE KEY `Name` (`Name`,`SpeciesId`),
+  KEY `Symbol` (`Symbol`)
+) ENGINE=InnoDB AUTO_INCREMENT=88253 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## StrainXRef
+
+```sql
+CREATE TABLE `StrainXRef` (
+  `InbredSetId` smallint(5) unsigned NOT NULL DEFAULT 0,
+  `StrainId` int(20) NOT NULL,
+  `OrderId` int(20) DEFAULT NULL,
+  `Used_for_mapping` char(1) DEFAULT 'N',
+  `PedigreeStatus` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`InbredSetId`,`StrainId`),
+  UNIQUE KEY `Orders` (`InbredSetId`,`OrderId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## TableComments
+
+```sql
+CREATE TABLE `TableComments` (
+  `TableName` varchar(100) NOT NULL DEFAULT '',
+  `Comment` text DEFAULT NULL,
+  PRIMARY KEY (`TableName`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## TableFieldAnnotation
+
+```sql
+CREATE TABLE `TableFieldAnnotation` (
+  `TableField` varchar(100) NOT NULL DEFAULT '',
+  `Foreign_Key` varchar(100) DEFAULT NULL,
+  `Annotation` text DEFAULT NULL,
+  PRIMARY KEY (`TableField`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## Temp
+
+```sql
+CREATE TABLE `Temp` (
+  `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  `dbdisplayname` varchar(255) DEFAULT NULL,
+  `Name` varchar(30) DEFAULT NULL,
+  `description` mediumtext 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=InnoDB AUTO_INCREMENT=178077 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## TempData
+
+```sql
+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=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## temporary
+
+```sql
+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=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## test_table
+
+```sql
+CREATE TABLE `test_table` (
+  `first_col` int(11) DEFAULT NULL,
+  `second_col` varchar(255) DEFAULT NULL,
+  `third_col` varchar(255) DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## Tissue
+
+```sql
+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=InnoDB AUTO_INCREMENT=189 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## TissueProbeFreeze
+
+```sql
+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=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## TissueProbeSetData
+
+```sql
+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=InnoDB AUTO_INCREMENT=90563 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## TissueProbeSetFreeze
+
+```sql
+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=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## TissueProbeSetXRef
+
+```sql
+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=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```
+
+## TraitMetadata
+
+```sql
+CREATE TABLE `TraitMetadata` (
+  `type` varchar(255) DEFAULT NULL,
+  `value` longtext DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## User
+
+```sql
+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=InnoDB AUTO_INCREMENT=358 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
+```
+
+## user
+
+```sql
+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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## user_collection
+
+```sql
+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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## user_openids
+
+```sql
+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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## UserPrivilege
+
+```sql
+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=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
+```
+
+## Vlookup
+
+```sql
+CREATE TABLE `Vlookup` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `VLProbeSetId` mediumtext 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` mediumtext DEFAULT NULL,
+  `exonEnds` mediumtext 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` mediumtext 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,
+  PRIMARY KEY (`Id`),
+  KEY `Id` (`Id`)
+) ENGINE=InnoDB AUTO_INCREMENT=754396017 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
+```