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