From 0f8a4bb658bbea15c75dc30d590cb3818dd182eb Mon Sep 17 00:00:00 2001 From: Arun Isaac Date: Thu, 22 Jul 2021 13:26:25 +0530 Subject: sql: Add schema and schema map. * sql/map-database.sh, sql/schema-original.sql, sql/schema.png, sql/schema.sql, sql/schema.svg: New files. --- sql/schema.sql | 2406 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 2406 insertions(+) create mode 100644 sql/schema.sql (limited to 'sql/schema.sql') diff --git a/sql/schema.sql b/sql/schema.sql new file mode 100644 index 0000000..c37754b --- /dev/null +++ b/sql/schema.sql @@ -0,0 +1,2406 @@ +-- 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