LX15gYPQ

1
2-- Swapnil Bhatia BU (swapnilb@bu.edu) -- Sun Oct 31 17:09:26 EDT 2010 -- Replaced database creation script with Anderson's new script which includes minimal startup data -- -- swapnilb begin -- Change mysql prompt to show current user and database. prompt (\u@\h) [\d]>\_ -- Change current database to be the mysql user info database. use mysql; -- Delete old Clotho database and create a new one. show databases; drop database if exists TestClothoDBv0; show databases; create database TestClothoDBv0; show databases; -- Delete old user accounts and create a new one. drop user "cidar.rwdu"@"%"; create user "cidar.rwdu"@"%" identified by "cidar"; -- Give new user account read, write, delete, and update permissions. Show -- result. grant insert, select, delete, update on TestClothoDBv0.* to "cidar.rwdu"@"%"; select user,host,db,select_priv,insert_priv,delete_priv,update_priv from mysql.db; -- Make the new database the current database, so subsequent commands create -- tables in it. use TestClothoDBv0; -- swapnilb end -- Create Clotho tables: all code courtesy of J. Chris Anderson -- (jcanderson@berkeley.edu) -- -- MySQL dump 10.11 -- -- Host: localhost Database: AndersonLabMain -- ------------------------------------------------------ -- Server version	5.0.51a-3ubuntu5.7-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 utf8 */; /*!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 `AttachmentTable` -- DROP TABLE IF EXISTS `AttachmentTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `AttachmentTable` ( `idAttachment` varchar(63) NOT NULL, `fileName` char(255) default NULL, `attachmentType` varchar(63) default NULL, `fileBlob` mediumblob, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, `wikiTextId` varchar(63) default NULL, PRIMARY KEY (`idAttachment`), KEY `fk_AttachmentTable_WikitextTable1` (`wikiTextId`), CONSTRAINT `fk_AttachmentTable_WikitextTable1` FOREIGN KEY (`wikiTextId`) REFERENCES `WikitextTable` (`idWikitext`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `AttachmentTable` -- LOCK TABLES `AttachmentTable` WRITE; /*!40000 ALTER TABLE `AttachmentTable` DISABLE KEYS */; /*!40000 ALTER TABLE `AttachmentTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `CollectionTable` -- DROP TABLE IF EXISTS `CollectionTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `CollectionTable` ( `idCollection` varchar(63) NOT NULL, `name` char(255) default NULL, `description` char(255) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, `authorId` varchar(63) default NULL, PRIMARY KEY (`idCollection`), KEY `fk_CollectionTable_PersonTable1` (`authorId`), CONSTRAINT `fk_CollectionTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `CollectionTable` -- LOCK TABLES `CollectionTable` WRITE; /*!40000 ALTER TABLE `CollectionTable` DISABLE KEYS */; INSERT INTO `CollectionTable` VALUES ('06532154e5b541e3b6cc309e9901ccd1','admin\'s collection','User admin\'s personal collection of objects','2010-10-30 18:41:27','2010-10-30 18:41:37','54929d1b80fe495b8e9c8546321fd686'),('0efae16c74d047c4a4ab15c5386882fc','Commmon Vectors','A common set of vectors for denoting gene deletions and \"vectorless\" plasmids','2010-10-30 18:41:37','2010-10-30 18:42:55','54929d1b80fe495b8e9c8546321fd686'); /*!40000 ALTER TABLE `CollectionTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `CollectionXref` -- DROP TABLE IF EXISTS `CollectionXref`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `CollectionXref` ( `xrefID` varchar(63) default NULL, `collectionId` varchar(63) NOT NULL, `objectId` varchar(63) NOT NULL, `objectType` varchar(63) default NULL, `authorId` varchar(63) default NULL, `dateCreated` datetime default NULL, `lastmodified` datetime default NULL, PRIMARY KEY (`collectionId`,`objectId`), KEY `fk_CollectionXref_CollectionTable1` (`collectionId`), KEY `fk_CollectionXref_PersonTable1` (`authorId`), CONSTRAINT `fk_CollectionXref_CollectionTable1` FOREIGN KEY (`collectionId`) REFERENCES `CollectionTable` (`idCollection`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_CollectionXref_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `CollectionXref` -- LOCK TABLES `CollectionXref` WRITE; /*!40000 ALTER TABLE `CollectionXref` DISABLE KEYS */; INSERT INTO `CollectionXref` VALUES (NULL,'06532154e5b541e3b6cc309e9901ccd1','0efae16c74d047c4a4ab15c5386882fc','COLLECTION','54929d1b80fe495b8e9c8546321fd686','2010-10-30 18:41:27','2010-10-30 18:41:37'),(NULL,'0efae16c74d047c4a4ab15c5386882fc','0023d6a2bde74439acb062491e8b3eb0','VECTOR','54929d1b80fe495b8e9c8546321fd686','2010-10-30 18:41:37','2010-10-30 18:42:55'),(NULL,'0efae16c74d047c4a4ab15c5386882fc','11c69a1538c14ea99d216a64ff9d2626','VECTOR','54929d1b80fe495b8e9c8546321fd686','2010-10-30 18:41:37','2010-10-30 18:42:55'),(NULL,'0efae16c74d047c4a4ab15c5386882fc','2317e7794775404b8861c6d5209b3aa4','VECTOR','54929d1b80fe495b8e9c8546321fd686','2010-10-30 18:41:37','2010-10-30 18:42:55'); /*!40000 ALTER TABLE `CollectionXref` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `CompositeXref` -- DROP TABLE IF EXISTS `CompositeXref`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `CompositeXref` ( `idComposite` varchar(63) NOT NULL, `childPart` varchar(63) default NULL, `parentPart` varchar(63) default NULL, `position` int(11) default NULL, PRIMARY KEY (`idComposite`), KEY `FK_CompositeXref_PartTable_parent` (`parentPart`), KEY `FK_CompositeXref_PartTable_child` (`childPart`), CONSTRAINT `FK_CompositeXref_PartTable_child` FOREIGN KEY (`childPart`) REFERENCES `PartTable` (`idPart`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_CompositeXref_PartTable_parent` FOREIGN KEY (`parentPart`) REFERENCES `PartTable` (`idPart`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `CompositeXref` -- LOCK TABLES `CompositeXref` WRITE; /*!40000 ALTER TABLE `CompositeXref` DISABLE KEYS */; /*!40000 ALTER TABLE `CompositeXref` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ContainerTable` -- DROP TABLE IF EXISTS `ContainerTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `ContainerTable` ( `idContainer` varchar(63) NOT NULL, `name` char(255) default NULL, `row` smallint(6) default NULL, `col` smallint(6) default NULL, `barcode` char(255) default NULL, `isFixed` tinyint(1) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, `plateId` varchar(63) default NULL, PRIMARY KEY (`idContainer`), KEY `fk_ContainerTable_PlateTable1` (`plateId`), CONSTRAINT `fk_ContainerTable_PlateTable1` FOREIGN KEY (`plateId`) REFERENCES `PlateTable` (`idPlate`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `ContainerTable` -- LOCK TABLES `ContainerTable` WRITE; /*!40000 ALTER TABLE `ContainerTable` DISABLE KEYS */; /*!40000 ALTER TABLE `ContainerTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `FactoidTable` -- DROP TABLE IF EXISTS `FactoidTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `FactoidTable` ( `idFactoid` varchar(63) NOT NULL, `name` char(255) default NULL, `reference` varchar(63) default NULL, `wikiTextId` varchar(63) default NULL, `authorId` varchar(63) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`idFactoid`), KEY `fk_FactoidTable_WikitextTable1` (`wikiTextId`), KEY `fk_FactoidTable_PersonTable1` (`authorId`), CONSTRAINT `fk_FactoidTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_FactoidTable_WikitextTable1` FOREIGN KEY (`wikiTextId`) REFERENCES `WikitextTable` (`idWikitext`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `FactoidTable` -- LOCK TABLES `FactoidTable` WRITE; /*!40000 ALTER TABLE `FactoidTable` DISABLE KEYS */; /*!40000 ALTER TABLE `FactoidTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `FamilyNoteXref` -- DROP TABLE IF EXISTS `FamilyNoteXref`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `FamilyNoteXref` ( `familyId` varchar(63) NOT NULL, `noteId` varchar(63) NOT NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`familyId`,`noteId`), KEY `fk_FamilyNoteXref_FamilyTable1` (`familyId`), KEY `fk_FamilyNoteXref_NoteTable1` (`noteId`), CONSTRAINT `fk_FamilyNoteXref_FamilyTable1` FOREIGN KEY (`familyId`) REFERENCES `FamilyTable` (`idFamily`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_FamilyNoteXref_NoteTable1` FOREIGN KEY (`noteId`) REFERENCES `NoteTable` (`idNote`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `FamilyNoteXref` -- LOCK TABLES `FamilyNoteXref` WRITE; /*!40000 ALTER TABLE `FamilyNoteXref` DISABLE KEYS */; /*!40000 ALTER TABLE `FamilyNoteXref` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `FamilyTable` -- DROP TABLE IF EXISTS `FamilyTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `FamilyTable` ( `idFamily` varchar(63) NOT NULL, `SOterm` varchar(20) default NULL, `level` int(11) default NULL, `isExtendable` tinyint(4) default NULL, `name` char(255) default NULL, `riskGroup` smallint(6) default NULL, `description` char(255) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, `familyData` text, `superFamilyId` varchar(63) default NULL, `authorId` varchar(63) default NULL, PRIMARY KEY (`idFamily`), KEY `fk_FamilyTable_PersonTable1` (`authorId`), KEY `fk_FamilyTable_FamilyTable1` (`superFamilyId`), CONSTRAINT `fk_FamilyTable_FamilyTable1` FOREIGN KEY (`superFamilyId`) REFERENCES `FamilyTable` (`idFamily`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_FamilyTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `FamilyTable` -- LOCK TABLES `FamilyTable` WRITE; /*!40000 ALTER TABLE `FamilyTable` DISABLE KEYS */; /*!40000 ALTER TABLE `FamilyTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `FeatureFamilyXref` -- DROP TABLE IF EXISTS `FeatureFamilyXref`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `FeatureFamilyXref` ( `featureId` varchar(63) NOT NULL, `familyId` varchar(63) NOT NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`featureId`,`familyId`), KEY `fk_FeatureFamilyXref_FeatureTable1` (`featureId`), KEY `fk_FeatureFamilyXref_FamilyTable1` (`familyId`), CONSTRAINT `fk_FeatureFamilyXref_FeatureTable1` FOREIGN KEY (`featureId`) REFERENCES `FeatureTable` (`idFeature`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_FeatureFamilyXref_FamilyTable1` FOREIGN KEY (`familyId`) REFERENCES `FamilyTable` (`idFamily`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `FeatureFamilyXref` -- LOCK TABLES `FeatureFamilyXref` WRITE; /*!40000 ALTER TABLE `FeatureFamilyXref` DISABLE KEYS */; /*!40000 ALTER TABLE `FeatureFamilyXref` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `FeatureNoteXref` -- DROP TABLE IF EXISTS `FeatureNoteXref`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `FeatureNoteXref` ( `featureId` varchar(63) NOT NULL, `noteId` varchar(63) NOT NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`noteId`,`featureId`), KEY `fk_FeatureNoteXref_FeatureTable1` (`featureId`), KEY `fk_FeatureNoteXref_NoteTable1` (`noteId`), CONSTRAINT `fk_FeatureNoteXref_FeatureTable1` FOREIGN KEY (`featureId`) REFERENCES `FeatureTable` (`idFeature`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_FeatureNoteXref_NoteTable1` FOREIGN KEY (`noteId`) REFERENCES `NoteTable` (`idNote`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `FeatureNoteXref` -- LOCK TABLES `FeatureNoteXref` WRITE; /*!40000 ALTER TABLE `FeatureNoteXref` DISABLE KEYS */; /*!40000 ALTER TABLE `FeatureNoteXref` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `FeatureTable` -- DROP TABLE IF EXISTS `FeatureTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `FeatureTable` ( `idFeature` varchar(63) NOT NULL, `name` char(255) default NULL, `authorId` varchar(63) default NULL, `nucseqId` varchar(63) default NULL, `riskGroup` smallint(6) default NULL, `genbankId` varchar(63) default NULL, `swissprotId` varchar(63) default NULL, `pdbId` varchar(63) default NULL, `forColor` int(11) default NULL, `revColor` int(11) default NULL, `isCDS` tinyint(1) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, `featureData` text, PRIMARY KEY (`idFeature`), KEY `fk_FeatureTable_PersonTable1` (`authorId`), KEY `fk_FeatureTable_NucseqTable1` (`nucseqId`), CONSTRAINT `fk_FeatureTable_NucseqTable1` FOREIGN KEY (`nucseqId`) REFERENCES `NucseqTable` (`idNucseq`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_FeatureTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `FeatureTable` -- LOCK TABLES `FeatureTable` WRITE; /*!40000 ALTER TABLE `FeatureTable` DISABLE KEYS */; /*!40000 ALTER TABLE `FeatureTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `FeatureTraitXref` -- DROP TABLE IF EXISTS `FeatureTraitXref`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `FeatureTraitXref` ( `featureId` varchar(63) NOT NULL, `traitId` varchar(63) NOT NULL, `value` text, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`featureId`,`traitId`), KEY `fk_FeatureTraitXref_FeatureTable1` (`featureId`), KEY `fk_FeatureTraitXref_TraitTable1` (`traitId`), CONSTRAINT `fk_FeatureTraitXref_FeatureTable1` FOREIGN KEY (`featureId`) REFERENCES `FeatureTable` (`idFeature`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_FeatureTraitXref_TraitTable1` FOREIGN KEY (`traitId`) REFERENCES `TraitTable` (`idTrait`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `FeatureTraitXref` -- LOCK TABLES `FeatureTraitXref` WRITE; /*!40000 ALTER TABLE `FeatureTraitXref` DISABLE KEYS */; /*!40000 ALTER TABLE `FeatureTraitXref` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `FlexfieldDataXref` -- DROP TABLE IF EXISTS `FlexfieldDataXref`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `FlexfieldDataXref` ( `idFlexfieldDataXref` varchar(63) NOT NULL, `flexfieldId` varchar(63) default NULL, `objectId` varchar(63) default NULL, `objectType` varchar(63) default NULL, `authorId` varchar(63) default NULL, `data1` text, `data2` varchar(63) default NULL, `date3` varchar(63) default NULL, PRIMARY KEY (`idFlexfieldDataXref`), KEY `fk_FlexfieldDataXref_FlexfieldTable1` (`flexfieldId`), KEY `fk_FlexfieldDataXref_PersonTable1` (`authorId`), CONSTRAINT `fk_FlexfieldDataXref_FlexfieldTable1` FOREIGN KEY (`flexfieldId`) REFERENCES `FlexfieldTable` (`idFlexfield`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_FlexfieldDataXref_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `FlexfieldDataXref` -- LOCK TABLES `FlexfieldDataXref` WRITE; /*!40000 ALTER TABLE `FlexfieldDataXref` DISABLE KEYS */; /*!40000 ALTER TABLE `FlexfieldDataXref` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `FlexfieldTable` -- DROP TABLE IF EXISTS `FlexfieldTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `FlexfieldTable` ( `idFlexfield` varchar(63) NOT NULL, `pluginId` varchar(63) default NULL, `name` varchar(63) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`idFlexfield`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `FlexfieldTable` -- LOCK TABLES `FlexfieldTable` WRITE; /*!40000 ALTER TABLE `FlexfieldTable` DISABLE KEYS */; /*!40000 ALTER TABLE `FlexfieldTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `FormatTable` -- DROP TABLE IF EXISTS `FormatTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `FormatTable` ( `idformat` varchar(63) NOT NULL, `name` char(255) default NULL, `pluginHelpLink` char(255) default NULL, `pluginDownloadLink` char(255) default NULL, `description` char(255) default NULL, `pluginId` varchar(63) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`idformat`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `FormatTable` -- LOCK TABLES `FormatTable` WRITE; /*!40000 ALTER TABLE `FormatTable` DISABLE KEYS */; INSERT INTO `FormatTable` VALUES ('org-clothocad-format-bglbricks-connect','BglBricks','http://wiki.bu.edu/ece-clotho/index.php/Format:_BglBricks','','The BamHI/BglII standard','org-clothocad-format-bglbricks-connect','2010-10-30 18:41:19','2010-10-30 18:41:19'),('org-clothocad-format-concatenateformat-connect','Concatenate Format','http://wiki.bu.edu/ece-clotho/index.php/Format:_Concatenate_Format','','Format with no rules on sequence, it just concatenates parts and vectors','org-clothocad-format-concatenateformat-connect','2010-10-30 18:41:20','2010-10-30 18:41:20'),('org-clothocad-format-freeform-connect','Freeform','http://wiki.bu.edu/ece-clotho/index.php/Format:_Freeform','','Parts belonging to Freeform can be any sequence. The sequence of the Part is the sequence of the Plasmid','org-clothocad-format-freeform-connect','2010-10-30 18:41:19','2010-10-30 18:41:19'),('org-clothocad-format-goldengatefour-connect','Golden Gate - 4bp','http://wiki.bu.edu/ece-clotho/index.php/Format:_Golden_Gate_-_4bp','','Golden Gate cloning with 4bp sticky ends','org-clothocad-format-goldengatefour-connect','2010-10-30 18:41:19','2010-10-30 18:41:19'),('org-clothocad-format-goldengatetwo-connect','Golden Gate - 2bp','http://wiki.bu.edu/ece-clotho/index.php/Format:_Golden_Gate_-_2bp','','Golden Gate cloning with 2bp sticky ends','org-clothocad-format-goldengatetwo-connect','2010-10-30 18:41:20','2010-10-30 18:41:20'),('org-clothocad-format-rfc10-connect','RFC10','http://wiki.bu.edu/ece-clotho/index.php/Format:_RFC10','','The original Knight standard, this one for all but coding sequences','org-clothocad-format-rfc10-connect','2010-10-30 18:41:20','2010-10-30 18:41:20'),('org-clothocad-format-rfctencds-connect','RFC10 - CDS','http://wiki.bu.edu/ece-clotho/index.php/Format:_RFC10_CDS','','The original Knight standard, this one for coding sequences','org-clothocad-format-rfctencds-connect','2010-10-30 18:41:20','2010-10-30 18:41:20'),('org-clothocad-format-spexba-connect','SpeXba','http://wiki.bu.edu/ece-clotho/index.php/Format:_SpeXba','','The original Knight standard, with sticky ends explicitly included in the part sequence','org-clothocad-format-spexba-connect','2010-10-30 18:41:20','2010-10-30 18:41:20'); /*!40000 ALTER TABLE `FormatTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `GrammarTable` -- DROP TABLE IF EXISTS `GrammarTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `GrammarTable` ( `idGrammar` varchar(63) NOT NULL, `name` char(255) default NULL, `pluginHelpLink` char(255) default NULL, `pluginDownloadLink` char(255) default NULL, `description` char(255) default NULL, `pluginId` varchar(63) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`idGrammar`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `GrammarTable` -- LOCK TABLES `GrammarTable` WRITE; /*!40000 ALTER TABLE `GrammarTable` DISABLE KEYS */; /*!40000 ALTER TABLE `GrammarTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `InstitutionTable` -- DROP TABLE IF EXISTS `InstitutionTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `InstitutionTable` ( `idInstitution` varchar(63) NOT NULL, `name` char(255) default NULL, `city` char(255) default NULL, `stateProvince` char(255) default NULL, `country` char(255) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`idInstitution`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `InstitutionTable` -- LOCK TABLES `InstitutionTable` WRITE; /*!40000 ALTER TABLE `InstitutionTable` DISABLE KEYS */; INSERT INTO `InstitutionTable` VALUES ('9f304e9b21424c6896b45e9cfbf89d19','UC Berkeley','Berkeley','CA','USA','2010-10-30 18:41:20','2010-10-30 18:41:20'); /*!40000 ALTER TABLE `InstitutionTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `LabTable` -- DROP TABLE IF EXISTS `LabTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `LabTable` ( `idLab` varchar(63) NOT NULL, `name` char(255) default NULL, `department` char(255) default NULL, `website` char(255) default NULL, `address` char(255) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, `institutionId` varchar(63) default NULL, `principalInvestigatorId` varchar(63) default NULL, PRIMARY KEY (`idLab`), KEY `fk_LabTable_InstitutionTable` (`institutionId`), KEY `fk_LabTable_PersonTable1` (`principalInvestigatorId`), CONSTRAINT `fk_LabTable_InstitutionTable` FOREIGN KEY (`institutionId`) REFERENCES `InstitutionTable` (`idInstitution`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_LabTable_PersonTable1` FOREIGN KEY (`principalInvestigatorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `LabTable` -- LOCK TABLES `LabTable` WRITE; /*!40000 ALTER TABLE `LabTable` DISABLE KEYS */; INSERT INTO `LabTable` VALUES ('6203e62c59634a1fa14a6093162a917b','ClothoCore','Bioengineering',NULL,'327 Stanley Hall\nBerkeley, CA 94709','2010-10-30 18:41:21','2010-10-30 18:41:21','9f304e9b21424c6896b45e9cfbf89d19',NULL); /*!40000 ALTER TABLE `LabTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `NoteFactoidXref` -- DROP TABLE IF EXISTS `NoteFactoidXref`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `NoteFactoidXref` ( `noteId` varchar(63) NOT NULL, `factoidId` varchar(63) NOT NULL, `authorId` varchar(63) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`noteId`,`factoidId`), KEY `fk_NoteFactoidXref_NoteTable1` (`noteId`), KEY `fk_NoteFactoidXref_FactoidTable1` (`factoidId`), KEY `fk_NoteFactoidXref_PersonTable1` (`authorId`), CONSTRAINT `fk_NoteFactoidXref_FactoidTable10` FOREIGN KEY (`factoidId`) REFERENCES `FactoidTable` (`idFactoid`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_NoteFactoidXref_NoteTable10` FOREIGN KEY (`noteId`) REFERENCES `NoteTable` (`idNote`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_NoteFactoidXref_PersonTable10` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `NoteFactoidXref` -- LOCK TABLES `NoteFactoidXref` WRITE; /*!40000 ALTER TABLE `NoteFactoidXref` DISABLE KEYS */; /*!40000 ALTER TABLE `NoteFactoidXref` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `NoteNoteXref` -- DROP TABLE IF EXISTS `NoteNoteXref`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `NoteNoteXref` ( `childNoteId` varchar(63) NOT NULL, `parentNoteId` varchar(63) NOT NULL, `authorId` varchar(63) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`parentNoteId`,`childNoteId`), KEY `fk_NoteFactoidXref_NoteTable1` (`parentNoteId`), KEY `fk_NoteFactoidXref_PersonTable1` (`authorId`), KEY `fk_NoteNoteXref_NoteTable1` (`childNoteId`), CONSTRAINT `fk_NoteFactoidXref_NoteTable1` FOREIGN KEY (`parentNoteId`) REFERENCES `NoteTable` (`idNote`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_NoteFactoidXref_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_NoteNoteXref_NoteTable1` FOREIGN KEY (`childNoteId`) REFERENCES `NoteTable` (`idNote`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `NoteNoteXref` -- LOCK TABLES `NoteNoteXref` WRITE; /*!40000 ALTER TABLE `NoteNoteXref` DISABLE KEYS */; /*!40000 ALTER TABLE `NoteNoteXref` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `NoteTable` -- DROP TABLE IF EXISTS `NoteTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `NoteTable` ( `idNote` varchar(63) NOT NULL, `name` char(255) default NULL, `blurbId` varchar(63) default NULL, `authorId` varchar(63) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`idNote`), KEY `fk_NoteTable_WikitextTable1` (`blurbId`), KEY `fk_NoteTable_PersonTable1` (`authorId`), CONSTRAINT `fk_NoteTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_NoteTable_WikitextTable1` FOREIGN KEY (`blurbId`) REFERENCES `WikitextTable` (`idWikitext`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `NoteTable` -- LOCK TABLES `NoteTable` WRITE; /*!40000 ALTER TABLE `NoteTable` DISABLE KEYS */; /*!40000 ALTER TABLE `NoteTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `NucseqAnnotation` -- DROP TABLE IF EXISTS `NucseqAnnotation`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `NucseqAnnotation` ( `name` char(255) default NULL, `annotationId` varchar(63) NOT NULL, `nucseqId` varchar(63) default NULL, `featureId` varchar(63) default NULL, `authorId` varchar(63) default NULL, `forwardColor` int(11) default NULL, `reverseColor` int(11) default NULL, `startx` int(11) default NULL, `endx` int(11) default NULL, `reverseComplement` tinyint(1) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`annotationId`), KEY `fk_NucseqAnnotation_NucseqTable1` (`nucseqId`), KEY `fk_NucseqAnnotation_FeatureTable1` (`featureId`), KEY `fk_NucseqAnnotation_PersonTable1` (`authorId`), CONSTRAINT `fk_NucseqAnnotation_FeatureTable1` FOREIGN KEY (`featureId`) REFERENCES `FeatureTable` (`idFeature`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_NucseqAnnotation_NucseqTable1` FOREIGN KEY (`nucseqId`) REFERENCES `NucseqTable` (`idNucseq`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_NucseqAnnotation_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `NucseqAnnotation` -- LOCK TABLES `NucseqAnnotation` WRITE; /*!40000 ALTER TABLE `NucseqAnnotation` DISABLE KEYS */; /*!40000 ALTER TABLE `NucseqAnnotation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `NucseqTable` -- DROP TABLE IF EXISTS `NucseqTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `NucseqTable` ( `idNucseq` varchar(63) NOT NULL, `sequence` text, `isLocked` tinyint(1) default '1', `dateCreated` datetime default NULL, `lastmodified` datetime default NULL, PRIMARY KEY (`idNucseq`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `NucseqTable` -- LOCK TABLES `NucseqTable` WRITE; /*!40000 ALTER TABLE `NucseqTable` DISABLE KEYS */; INSERT INTO `NucseqTable` VALUES ('41df362bc4fc49319aaa88ab1fa7d911','.',1,'2010-10-30 18:42:12','2010-10-30 18:42:12'),('bd632df26b93471b9a2250f20050ab74','',1,'2010-10-30 18:42:34','2010-10-30 18:42:34'),('e2d5e7e4341148ba8ee4135c6290b65d','.',1,'2010-10-30 18:41:37','2010-10-30 18:41:37'); /*!40000 ALTER TABLE `NucseqTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `OligoTable` -- DROP TABLE IF EXISTS `OligoTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `OligoTable` ( `idOligo` varchar(63) NOT NULL, `name` char(255) default NULL, `nucseqId` varchar(63) default NULL, `description` char(255) default NULL, `authorId` varchar(63) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`idOligo`), KEY `fk_OligoTable_NucseqTable1` (`nucseqId`), KEY `fk_OligoTable_PersonTable1` (`authorId`), CONSTRAINT `fk_OligoTable_NucseqTable1` FOREIGN KEY (`nucseqId`) REFERENCES `NucseqTable` (`idNucseq`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_OligoTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `OligoTable` -- LOCK TABLES `OligoTable` WRITE; /*!40000 ALTER TABLE `OligoTable` DISABLE KEYS */; /*!40000 ALTER TABLE `OligoTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PartGrammarXref` -- DROP TABLE IF EXISTS `PartGrammarXref`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `PartGrammarXref` ( `partId` varchar(63) NOT NULL, `grammarId` varchar(63) NOT NULL, `authorId` varchar(63) default NULL, `token` varchar(63) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`partId`,`grammarId`), KEY `fk_PartGrammarXref_PartTable1` (`partId`), KEY `fk_PartGrammarXref_GrammarTable1` (`grammarId`), KEY `fk_PartGrammarXref_PersonTable1` (`authorId`), CONSTRAINT `fk_PartGrammarXref_GrammarTable1` FOREIGN KEY (`grammarId`) REFERENCES `GrammarTable` (`idGrammar`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_PartGrammarXref_PartTable1` FOREIGN KEY (`partId`) REFERENCES `PartTable` (`idPart`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_PartGrammarXref_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `PartGrammarXref` -- LOCK TABLES `PartGrammarXref` WRITE; /*!40000 ALTER TABLE `PartGrammarXref` DISABLE KEYS */; /*!40000 ALTER TABLE `PartGrammarXref` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PartTable` -- DROP TABLE IF EXISTS `PartTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `PartTable` ( `idPart` varchar(63) NOT NULL, `formatId` varchar(63) default NULL, `nucseqId` varchar(63) default NULL, `description` char(255) default NULL, `authorId` varchar(63) default NULL, `name` char(255) default NULL, `riskGroup` smallint(6) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, `hash` varchar(63) default NULL, `isBasic` tinyint(4) default NULL, PRIMARY KEY (`idPart`), KEY `fk_PartTable_FormatTable1` (`formatId`), KEY `fk_PartTable_NucseqTable1` (`nucseqId`), KEY `fk_PartTable_PersonTable1` (`authorId`), CONSTRAINT `fk_PartTable_FormatTable1` FOREIGN KEY (`formatId`) REFERENCES `FormatTable` (`idformat`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_PartTable_NucseqTable1` FOREIGN KEY (`nucseqId`) REFERENCES `NucseqTable` (`idNucseq`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_PartTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `PartTable` -- LOCK TABLES `PartTable` WRITE; /*!40000 ALTER TABLE `PartTable` DISABLE KEYS */; /*!40000 ALTER TABLE `PartTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PersonTable` -- DROP TABLE IF EXISTS `PersonTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `PersonTable` ( `idPerson` varchar(63) NOT NULL, `labId` varchar(63) default NULL, `displayName` char(255) default NULL, `givenName` char(255) default NULL, `surName` char(255) default NULL, `nickName` char(255) default NULL, `emailAddress` char(255) default NULL, `snailMailAddress` char(255) default NULL, `registryName` char(255) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, `password` varchar(63) default NULL, `isAdministrator` tinyint(1) default NULL, `personalCollectionId` varchar(63) default NULL, `biographID` varchar(63) default NULL, PRIMARY KEY (`idPerson`), KEY `fk_PersonTable_LabTable1` (`labId`), KEY `fk_PersonTable_CollectionTable1` (`personalCollectionId`), KEY `fk_PersonTable_WikitextTable1` (`biographID`), CONSTRAINT `fk_PersonTable_CollectionTable1` FOREIGN KEY (`personalCollectionId`) REFERENCES `CollectionTable` (`idCollection`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_PersonTable_LabTable1` FOREIGN KEY (`labId`) REFERENCES `LabTable` (`idLab`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_PersonTable_WikitextTable1` FOREIGN KEY (`biographID`) REFERENCES `WikitextTable` (`idWikitext`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `PersonTable` -- LOCK TABLES `PersonTable` WRITE; /*!40000 ALTER TABLE `PersonTable` DISABLE KEYS */; INSERT INTO `PersonTable` VALUES ('54929d1b80fe495b8e9c8546321fd686','6203e62c59634a1fa14a6093162a917b','admin','Admin','Admin','Chris','admin@university.edu','293 Address St.\nCity, ST 93929','admin','2010-10-30 18:41:21','2010-10-30 19:27:28','d033e22ae348aeb5660fc2140aec35850c4da997',1,'06532154e5b541e3b6cc309e9901ccd1','8eed4179ffc04881a629ad725775ac8e'); /*!40000 ALTER TABLE `PersonTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PlasmidTable` -- DROP TABLE IF EXISTS `PlasmidTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `PlasmidTable` ( `idPlasmid` varchar(63) NOT NULL, `vectorId` varchar(63) default NULL, `partId` varchar(63) default NULL, `formatId` varchar(63) default NULL, `name` char(255) default NULL, `authorId` varchar(63) default NULL, `constructionFile` text, `riskGroup` smallint(6) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`idPlasmid`), KEY `fk_PlasmidTable_VectorTable1` (`vectorId`), KEY `fk_PlasmidTable_PartTable1` (`partId`), KEY `fk_PlasmidTable_FormatTable1` (`formatId`), KEY `fk_PlasmidTable_PersonTable1` (`authorId`), CONSTRAINT `fk_PlasmidTable_FormatTable1` FOREIGN KEY (`formatId`) REFERENCES `FormatTable` (`idformat`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_PlasmidTable_PartTable1` FOREIGN KEY (`partId`) REFERENCES `PartTable` (`idPart`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_PlasmidTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_PlasmidTable_VectorTable1` FOREIGN KEY (`vectorId`) REFERENCES `VectorTable` (`idVector`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `PlasmidTable` -- LOCK TABLES `PlasmidTable` WRITE; /*!40000 ALTER TABLE `PlasmidTable` DISABLE KEYS */; /*!40000 ALTER TABLE `PlasmidTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PlateTable` -- DROP TABLE IF EXISTS `PlateTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `PlateTable` ( `idPlate` varchar(63) NOT NULL, `name` char(255) default NULL, `barcode` char(255) default NULL, `location` char(255) default NULL, `plateTypeId` varchar(63) default NULL, `authorId` varchar(63) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`idPlate`), KEY `fk_PlateTable_PlateTypeTable1` (`plateTypeId`), KEY `fk_PlateTable_PersonTable1` (`authorId`), CONSTRAINT `fk_PlateTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_PlateTable_PlateTypeTable1` FOREIGN KEY (`plateTypeId`) REFERENCES `PlateTypeTable` (`idPlateType`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `PlateTable` -- LOCK TABLES `PlateTable` WRITE; /*!40000 ALTER TABLE `PlateTable` DISABLE KEYS */; /*!40000 ALTER TABLE `PlateTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `PlateTypeTable` -- DROP TABLE IF EXISTS `PlateTypeTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `PlateTypeTable` ( `idPlateType` varchar(63) NOT NULL, `name` char(255) default NULL, `numRows` smallint(6) default NULL, `numColumns` smallint(6) default NULL, `isContainerFixed` tinyint(1) default NULL, `AttachmentTable_idAttachment` varchar(63) default NULL, `dateCreated` datetime default NULL, `wellPosX` mediumtext, `wellPosY` mediumtext, `lastModified` datetime default NULL, `wellDiameter` int(11) default NULL, `squareWells` tinyint(1) default NULL, `squareWellHeight` int(11) default NULL, `squareWellWidth` int(11) default NULL, `mmWidth` double default NULL, `mmHeight` double default NULL, `mmXOffset` double default NULL, `mmYOffset` double default NULL, `mmXWellSpacing` double default NULL, `mmYWellSpacing` double default NULL, `mmWellWidth` double default NULL, `mmWellHeight` double default NULL, `mmWellDiameter` double default NULL, PRIMARY KEY (`idPlateType`), KEY `fk_PlateTypeTable_AttachmentTable1` (`AttachmentTable_idAttachment`), CONSTRAINT `fk_PlateTypeTable_AttachmentTable1` FOREIGN KEY (`AttachmentTable_idAttachment`) REFERENCES `AttachmentTable` (`idAttachment`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `PlateTypeTable` -- LOCK TABLES `PlateTypeTable` WRITE; /*!40000 ALTER TABLE `PlateTypeTable` DISABLE KEYS */; /*!40000 ALTER TABLE `PlateTypeTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SampleDataTable` -- DROP TABLE IF EXISTS `SampleDataTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `SampleDataTable` ( `idSampleData` varchar(63) NOT NULL, `authorId` varchar(63) default NULL, `wikiTextId` varchar(63) default NULL, `attachmentId` varchar(63) default NULL, `name` char(255) default NULL, `dataType` varchar(63) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, `freeString1` text, `freeString2` text, `freeString3` text, `freeString4` text, PRIMARY KEY (`idSampleData`), KEY `fk_SampleDataTable_WikitextTable1` (`wikiTextId`), KEY `fk_SampleDataTable_PersonTable1` (`authorId`), KEY `fk_SampleDataTable_AttachmentTable1` (`attachmentId`), CONSTRAINT `fk_SampleDataTable_AttachmentTable1` FOREIGN KEY (`attachmentId`) REFERENCES `AttachmentTable` (`idAttachment`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_SampleDataTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_SampleDataTable_WikitextTable1` FOREIGN KEY (`wikiTextId`) REFERENCES `WikitextTable` (`idWikitext`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `SampleDataTable` -- LOCK TABLES `SampleDataTable` WRITE; /*!40000 ALTER TABLE `SampleDataTable` DISABLE KEYS */; /*!40000 ALTER TABLE `SampleDataTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SampleDataXref` -- DROP TABLE IF EXISTS `SampleDataXref`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `SampleDataXref` ( `sampleId` varchar(63) NOT NULL, `sampleDataId` varchar(63) NOT NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`sampleId`,`sampleDataId`), KEY `fk_SampleDataXref_SampleTable1` (`sampleId`), KEY `fk_SampleDataXref_SampleDataTable1` (`sampleDataId`), CONSTRAINT `fk_SampleDataXref_SampleDataTable1` FOREIGN KEY (`sampleDataId`) REFERENCES `SampleDataTable` (`idSampleData`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_SampleDataXref_SampleTable1` FOREIGN KEY (`sampleId`) REFERENCES `SampleTable` (`idSample`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `SampleDataXref` -- LOCK TABLES `SampleDataXref` WRITE; /*!40000 ALTER TABLE `SampleDataXref` DISABLE KEYS */; /*!40000 ALTER TABLE `SampleDataXref` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SampleTable` -- DROP TABLE IF EXISTS `SampleTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `SampleTable` ( `idSample` varchar(63) NOT NULL, `sampleType` varchar(63) default NULL, `name` char(255) default NULL, `quality` smallint(6) default NULL, `concentration` double default NULL, `volume` double default NULL, `containerId` varchar(63) default NULL, `authorId` varchar(63) default NULL, `dateLastUsed` datetime default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, `oligoId` varchar(63) default NULL, `plasmidId` varchar(63) default NULL, `strainId` varchar(63) default NULL, PRIMARY KEY (`idSample`), KEY `fk_SampleTable_ContainerTable1` (`containerId`), KEY `fk_SampleTable_PersonTable1` (`authorId`), KEY `fk_SampleTable_OligoTable1` (`oligoId`), KEY `fk_SampleTable_PlasmidTable1` (`plasmidId`), KEY `fk_SampleTable_StrainTable1` (`strainId`), CONSTRAINT `fk_SampleTable_ContainerTable1` FOREIGN KEY (`containerId`) REFERENCES `ContainerTable` (`idContainer`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_SampleTable_OligoTable1` FOREIGN KEY (`oligoId`) REFERENCES `OligoTable` (`idOligo`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_SampleTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_SampleTable_PlasmidTable1` FOREIGN KEY (`plasmidId`) REFERENCES `PlasmidTable` (`idPlasmid`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_SampleTable_StrainTable1` FOREIGN KEY (`strainId`) REFERENCES `StrainTable` (`idStrain`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `SampleTable` -- LOCK TABLES `SampleTable` WRITE; /*!40000 ALTER TABLE `SampleTable` DISABLE KEYS */; /*!40000 ALTER TABLE `SampleTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `SearchtagTable` -- DROP TABLE IF EXISTS `SearchtagTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `SearchtagTable` ( `idSearchtag` varchar(63) NOT NULL, `name` char(255) default NULL, `authorId` varchar(63) default NULL, `objectId` varchar(63) default NULL, `objectType` varchar(63) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`idSearchtag`), KEY `fk_CollectionTable_PersonTable1` (`authorId`), CONSTRAINT `fk_CollectionTable_PersonTable10` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `SearchtagTable` -- LOCK TABLES `SearchtagTable` WRITE; /*!40000 ALTER TABLE `SearchtagTable` DISABLE KEYS */; /*!40000 ALTER TABLE `SearchtagTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `StrainNoteXref` -- DROP TABLE IF EXISTS `StrainNoteXref`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `StrainNoteXref` ( `strainId` varchar(63) NOT NULL, `noteId` varchar(63) NOT NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`strainId`,`noteId`), KEY `fk_StrainNoteXref_StrainTable1` (`strainId`), KEY `fk_StrainNoteXref_NoteTable1` (`noteId`), CONSTRAINT `fk_StrainNoteXref_NoteTable1` FOREIGN KEY (`noteId`) REFERENCES `NoteTable` (`idNote`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_StrainNoteXref_StrainTable1` FOREIGN KEY (`strainId`) REFERENCES `StrainTable` (`idStrain`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `StrainNoteXref` -- LOCK TABLES `StrainNoteXref` WRITE; /*!40000 ALTER TABLE `StrainNoteXref` DISABLE KEYS */; /*!40000 ALTER TABLE `StrainNoteXref` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `StrainPlasmidXref` -- DROP TABLE IF EXISTS `StrainPlasmidXref`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `StrainPlasmidXref` ( `strainId` varchar(63) NOT NULL, `plasmidId` varchar(63) NOT NULL, `authorId` varchar(63) default NULL, `genomeStart` int(11) default NULL, `genomeEnd` int(11) default NULL, `revComp` tinyint(1) default NULL, `isGenomic` tinyint(1) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`strainId`,`plasmidId`), KEY `fk_StrainPlasmidXref_StrainTable1` (`strainId`), KEY `fk_StrainPlasmidXref_PlasmidTable1` (`plasmidId`), KEY `fk_StrainPlasmidXref_PersonTable1` (`authorId`), CONSTRAINT `fk_StrainPlasmidXref_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_StrainPlasmidXref_PlasmidTable1` FOREIGN KEY (`plasmidId`) REFERENCES `PlasmidTable` (`idPlasmid`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_StrainPlasmidXref_StrainTable1` FOREIGN KEY (`strainId`) REFERENCES `StrainTable` (`idStrain`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `StrainPlasmidXref` -- LOCK TABLES `StrainPlasmidXref` WRITE; /*!40000 ALTER TABLE `StrainPlasmidXref` DISABLE KEYS */; /*!40000 ALTER TABLE `StrainPlasmidXref` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `StrainTable` -- DROP TABLE IF EXISTS `StrainTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `StrainTable` ( `idStrain` varchar(63) NOT NULL, `name` char(255) default NULL, `description` char(255) default NULL, `personId` varchar(63) default NULL, `isBasic` tinyint(1) default NULL, `genbankFileId` varchar(63) default NULL, `genomeId` varchar(63) default NULL, `strainType` varchar(63) default NULL, `parentStrainId` varchar(63) default NULL, `riskGroup` smallint(6) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`idStrain`), KEY `fk_StrainTable_PersonTable1` (`personId`), KEY `fk_StrainTable_AttachmentTable1` (`genbankFileId`), KEY `fk_StrainTable_StrainTable1` (`parentStrainId`), CONSTRAINT `fk_StrainTable_AttachmentTable1` FOREIGN KEY (`genbankFileId`) REFERENCES `AttachmentTable` (`idAttachment`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_StrainTable_PersonTable1` FOREIGN KEY (`personId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_StrainTable_StrainTable1` FOREIGN KEY (`parentStrainId`) REFERENCES `StrainTable` (`idStrain`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `StrainTable` -- LOCK TABLES `StrainTable` WRITE; /*!40000 ALTER TABLE `StrainTable` DISABLE KEYS */; /*!40000 ALTER TABLE `StrainTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `TraitFamilyXref` -- DROP TABLE IF EXISTS `TraitFamilyXref`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `TraitFamilyXref` ( `traitId` varchar(63) NOT NULL, `familyId` varchar(63) NOT NULL, `position` int(11) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`traitId`,`familyId`), KEY `fk_TraitFamilyXref_TraitTable1` (`traitId`), KEY `fk_TraitFamilyXref_FamilyTable1` (`familyId`), CONSTRAINT `fk_TraitFamilyXref_TraitTable1` FOREIGN KEY (`traitId`) REFERENCES `TraitTable` (`idTrait`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_TraitFamilyXref_FamilyTable1` FOREIGN KEY (`familyId`) REFERENCES `FamilyTable` (`idFamily`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `TraitFamilyXref` -- LOCK TABLES `TraitFamilyXref` WRITE; /*!40000 ALTER TABLE `TraitFamilyXref` DISABLE KEYS */; /*!40000 ALTER TABLE `TraitFamilyXref` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `TraitTable` -- DROP TABLE IF EXISTS `TraitTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `TraitTable` ( `idTrait` varchar(63) NOT NULL, `familyId` varchar(63) default NULL, `position` int(11) default NULL, `name` char(255) default NULL, `kind` varchar(63) default NULL, `type` char(255) default NULL, `value` char(255) default NULL, `constraint` text, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`idTrait`), KEY `fk_TraitTable_FamilyTable1` (`familyId`), CONSTRAINT `fk_TraitTable_FamilyTable1` FOREIGN KEY (`familyId`) REFERENCES `FamilyTable` (`idFamily`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `TraitTable` -- LOCK TABLES `TraitTable` WRITE; /*!40000 ALTER TABLE `TraitTable` DISABLE KEYS */; /*!40000 ALTER TABLE `TraitTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `VectorTable` -- DROP TABLE IF EXISTS `VectorTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `VectorTable` ( `idVector` varchar(63) NOT NULL, `formatId` varchar(63) default NULL, `nucseqId` varchar(63) default NULL, `description` char(255) default NULL, `isCircular` tinyint(1) default NULL, `isGenomic` tinyint(1) default NULL, `authorId` varchar(63) default NULL, `name` char(255) default NULL, `riskGroup` smallint(6) default NULL, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, `hash` varchar(63) default NULL, PRIMARY KEY (`idVector`), KEY `fk_VectorTable_FormatTable1` (`formatId`), KEY `fk_VectorTable_NucseqTable1` (`nucseqId`), KEY `fk_VectorTable_PersonTable1` (`authorId`), CONSTRAINT `fk_VectorTable_FormatTable1` FOREIGN KEY (`formatId`) REFERENCES `FormatTable` (`idformat`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_VectorTable_NucseqTable1` FOREIGN KEY (`nucseqId`) REFERENCES `NucseqTable` (`idNucseq`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_VectorTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `VectorTable` -- LOCK TABLES `VectorTable` WRITE; /*!40000 ALTER TABLE `VectorTable` DISABLE KEYS */; INSERT INTO `VectorTable` VALUES ('0023d6a2bde74439acb062491e8b3eb0','org-clothocad-format-concatenateformat-connect','bd632df26b93471b9a2250f20050ab74','Episomal vector with null sequence',0,0,'54929d1b80fe495b8e9c8546321fd686','p',1,'2010-10-30 18:42:34','2010-10-30 18:45:56','44c4ff56edc880e6a9fbbc9f8badcef'),('11c69a1538c14ea99d216a64ff9d2626','org-clothocad-format-concatenateformat-connect','e2d5e7e4341148ba8ee4135c6290b65d','Genomic insertion, null sequence',0,0,'54929d1b80fe495b8e9c8546321fd686','::',1,'2010-10-30 18:41:37','2010-10-30 18:45:56','31d2852cf9d038cd9e5cce3ba7ea11f'),('2317e7794775404b8861c6d5209b3aa4','org-clothocad-format-concatenateformat-connect','41df362bc4fc49319aaa88ab1fa7d911','Deletion of a gene, use with a part that encodes the sequence of the gene scar and flanking sequence',0,0,'54929d1b80fe495b8e9c8546321fd686','delta',1,'2010-10-30 18:42:12','2010-10-30 18:45:56','31d2852cf9d038cd9e5cce3ba7ea11f'); /*!40000 ALTER TABLE `VectorTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `WikitextTable` -- DROP TABLE IF EXISTS `WikitextTable`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `WikitextTable` ( `idWikitext` varchar(63) NOT NULL, `name` char(255) default NULL, `text` text, `dateCreated` datetime default NULL, `lastModified` datetime default NULL, PRIMARY KEY (`idWikitext`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `WikitextTable` -- LOCK TABLES `WikitextTable` WRITE; /*!40000 ALTER TABLE `WikitextTable` DISABLE KEYS */; INSERT INTO `WikitextTable` VALUES ('8eed4179ffc04881a629ad725775ac8e','wikitext','If you need to log in as the admin, the password is \"admin\"\n\nYou can change any of the information for the admin (name, email, etc). It won\'t hurt anything.','2010-10-30 18:41:27','2010-10-30 19:29:12'); /*!40000 ALTER TABLE `WikitextTable` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping routines for database 'AndersonLabMain' -- DELIMITER ;; DELIMITER ; /*!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 2010-10-31 4:08:54