· 6 years ago · Jun 13, 2019, 05:24 PM
1██████╗ ███████╗███╗ ███╗ ██████╗ ███╗ ██╗███████╗ █████╗ ██████╗
2██╔══██╗██╔════╝████╗ ████║██╔═══██╗████╗ ██║██╔════╝██╔══██╗██╔══██╗
3██║ ██║█████╗ ██╔████╔██║██║ ██║██╔██╗ ██║███████╗███████║██║ ██║
4██║ ██║██╔══╝ ██║╚██╔╝██║██║ ██║██║╚██╗██║╚════██║██╔══██║██║ ██║
5██████╔╝███████╗██║ ╚═╝ ██║╚██████╔╝██║ ╚████║███████║██║ ██║██████╔╝
6╚═════╝ ╚══════╝╚═╝ ╚═╝ ╚═════╝ ╚═╝ ╚═══╝╚══════╝╚═╝ ╚═╝╚═════╝
7
8███╗ ██╗███████╗██╗ ██╗███████╗███████╗ ██████╗
9████╗ ██║██╔════╝██║ ██║██╔════╝██╔════╝██╔════╝
10██╔██╗ ██║█████╗ ██║ █╗ ██║███████╗█████╗ ██║
11██║╚██╗██║██╔══╝ ██║███╗██║╚════██║██╔══╝ ██║
12██║ ╚████║███████╗╚███╔███╔╝███████║███████╗╚██████╗
13╚═╝ ╚═══╝╚══════╝ ╚══╝╚══╝ ╚══════╝╚══════╝ ╚═════╝
14
15Target :http://www.bu.edu ( Universidade De Boston )
16
17"Saiba Que Pra Mim Vocês Não Passam De Insetos"
18
19We Are NewSec : DemonSad, Nedlock, Kami, S1lver
20
21-- ------------------------------------------------------
22Database: Bs_db
23
24/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
25/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
26/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
27/*!40101 SET NAMES utf8 */;
28/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
29/*!40103 SET TIME_ZONE='+00:00' */;
30/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
31/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
32/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
33/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
34
35--
36-- Table structure for table `AttachmentTable`
37--
38
39DROP TABLE IF EXISTS `AttachmentTable`;
40SET @saved_cs_client = @@character_set_client;
41SET character_set_client = utf8;
42CREATE TABLE `AttachmentTable` (
43 `idAttachment` varchar(63) NOT NULL,
44 `fileName` char(255) default NULL,
45 `attachmentType` varchar(63) default NULL,
46 `fileBlob` mediumblob,
47 `dateCreated` datetime default NULL,
48 `lastModified` datetime default NULL,
49 `wikiTextId` varchar(63) default NULL,
50 PRIMARY KEY (`idAttachment`),
51 KEY `fk_AttachmentTable_WikitextTable1` (`wikiTextId`),
52 CONSTRAINT `fk_AttachmentTable_WikitextTable1` FOREIGN KEY (`wikiTextId`) REFERENCES `WikitextTable` (`idWikitext`) ON DELETE NO ACTION ON UPDATE NO ACTION
53) ENGINE=InnoDB DEFAULT CHARSET=latin1;
54SET character_set_client = @saved_cs_client;
55
56--
57-- Dumping data for table `AttachmentTable`
58--
59
60LOCK TABLES `AttachmentTable` WRITE;
61/*!40000 ALTER TABLE `AttachmentTable` DISABLE KEYS */;
62/*!40000 ALTER TABLE `AttachmentTable` ENABLE KEYS */;
63UNLOCK TABLES;
64
65--
66-- Table structure for table `CollectionTable`
67--
68
69DROP TABLE IF EXISTS `CollectionTable`;
70SET @saved_cs_client = @@character_set_client;
71SET character_set_client = utf8;
72CREATE TABLE `CollectionTable` (
73 `idCollection` varchar(63) NOT NULL,
74 `name` char(255) default NULL,
75 `description` char(255) default NULL,
76 `dateCreated` datetime default NULL,
77 `lastModified` datetime default NULL,
78 `authorId` varchar(63) default NULL,
79 PRIMARY KEY (`idCollection`),
80 KEY `fk_CollectionTable_PersonTable1` (`authorId`),
81 CONSTRAINT `fk_CollectionTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION
82) ENGINE=InnoDB DEFAULT CHARSET=latin1;
83SET character_set_client = @saved_cs_client;
84
85--
86-- Dumping data for table `CollectionTable`
87--
88
89LOCK TABLES `CollectionTable` WRITE;
90/*!40000 ALTER TABLE `CollectionTable` DISABLE KEYS */;
91INSERT 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');
92/*!40000 ALTER TABLE `CollectionTable` ENABLE KEYS */;
93UNLOCK TABLES;
94
95--
96-- Table structure for table `CollectionXref`
97--
98
99DROP TABLE IF EXISTS `CollectionXref`;
100SET @saved_cs_client = @@character_set_client;
101SET character_set_client = utf8;
102CREATE TABLE `CollectionXref` (
103 `xrefID` varchar(63) default NULL,
104 `collectionId` varchar(63) NOT NULL,
105 `objectId` varchar(63) NOT NULL,
106 `objectType` varchar(63) default NULL,
107 `authorId` varchar(63) default NULL,
108 `dateCreated` datetime default NULL,
109 `lastmodified` datetime default NULL,
110 PRIMARY KEY (`collectionId`,`objectId`),
111 KEY `fk_CollectionXref_CollectionTable1` (`collectionId`),
112 KEY `fk_CollectionXref_PersonTable1` (`authorId`),
113 CONSTRAINT `fk_CollectionXref_CollectionTable1` FOREIGN KEY (`collectionId`) REFERENCES `CollectionTable` (`idCollection`) ON DELETE NO ACTION ON UPDATE NO ACTION,
114 CONSTRAINT `fk_CollectionXref_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION
115) ENGINE=InnoDB DEFAULT CHARSET=latin1;
116SET character_set_client = @saved_cs_client;
117
118--
119-- Dumping data for table `CollectionXref`
120--
121
122LOCK TABLES `CollectionXref` WRITE;
123/*!40000 ALTER TABLE `CollectionXref` DISABLE KEYS */;
124INSERT 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');
125/*!40000 ALTER TABLE `CollectionXref` ENABLE KEYS */;
126UNLOCK TABLES;
127
128--
129-- Table structure for table `CompositeXref`
130--
131
132DROP TABLE IF EXISTS `CompositeXref`;
133SET @saved_cs_client = @@character_set_client;
134SET character_set_client = utf8;
135CREATE TABLE `CompositeXref` (
136 `idComposite` varchar(63) NOT NULL,
137 `childPart` varchar(63) default NULL,
138 `parentPart` varchar(63) default NULL,
139 `position` int(11) default NULL,
140 PRIMARY KEY (`idComposite`),
141 KEY `FK_CompositeXref_PartTable_parent` (`parentPart`),
142 KEY `FK_CompositeXref_PartTable_child` (`childPart`),
143 CONSTRAINT `FK_CompositeXref_PartTable_child` FOREIGN KEY (`childPart`) REFERENCES `PartTable` (`idPart`) ON DELETE NO ACTION ON UPDATE NO ACTION,
144 CONSTRAINT `FK_CompositeXref_PartTable_parent` FOREIGN KEY (`parentPart`) REFERENCES `PartTable` (`idPart`) ON DELETE NO ACTION ON UPDATE NO ACTION
145) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
146SET character_set_client = @saved_cs_client;
147
148--
149-- Dumping data for table `CompositeXref`
150--
151
152LOCK TABLES `CompositeXref` WRITE;
153/*!40000 ALTER TABLE `CompositeXref` DISABLE KEYS */;
154/*!40000 ALTER TABLE `CompositeXref` ENABLE KEYS */;
155UNLOCK TABLES;
156
157--
158-- Table structure for table `ContainerTable`
159--
160
161DROP TABLE IF EXISTS `ContainerTable`;
162SET @saved_cs_client = @@character_set_client;
163SET character_set_client = utf8;
164CREATE TABLE `ContainerTable` (
165 `idContainer` varchar(63) NOT NULL,
166 `name` char(255) default NULL,
167 `row` smallint(6) default NULL,
168 `col` smallint(6) default NULL,
169 `barcode` char(255) default NULL,
170 `isFixed` tinyint(1) default NULL,
171 `dateCreated` datetime default NULL,
172 `lastModified` datetime default NULL,
173 `plateId` varchar(63) default NULL,
174 PRIMARY KEY (`idContainer`),
175 KEY `fk_ContainerTable_PlateTable1` (`plateId`),
176 CONSTRAINT `fk_ContainerTable_PlateTable1` FOREIGN KEY (`plateId`) REFERENCES `PlateTable` (`idPlate`) ON DELETE NO ACTION ON UPDATE NO ACTION
177) ENGINE=InnoDB DEFAULT CHARSET=latin1;
178SET character_set_client = @saved_cs_client;
179
180--
181-- Dumping data for table `ContainerTable`
182--
183
184LOCK TABLES `ContainerTable` WRITE;
185/*!40000 ALTER TABLE `ContainerTable` DISABLE KEYS */;
186/*!40000 ALTER TABLE `ContainerTable` ENABLE KEYS */;
187UNLOCK TABLES;
188
189--
190-- Table structure for table `FactoidTable`
191--
192
193DROP TABLE IF EXISTS `FactoidTable`;
194SET @saved_cs_client = @@character_set_client;
195SET character_set_client = utf8;
196CREATE TABLE `FactoidTable` (
197 `idFactoid` varchar(63) NOT NULL,
198 `name` char(255) default NULL,
199 `reference` varchar(63) default NULL,
200 `wikiTextId` varchar(63) default NULL,
201 `authorId` varchar(63) default NULL,
202 `dateCreated` datetime default NULL,
203 `lastModified` datetime default NULL,
204 PRIMARY KEY (`idFactoid`),
205 KEY `fk_FactoidTable_WikitextTable1` (`wikiTextId`),
206 KEY `fk_FactoidTable_PersonTable1` (`authorId`),
207 CONSTRAINT `fk_FactoidTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION,
208 CONSTRAINT `fk_FactoidTable_WikitextTable1` FOREIGN KEY (`wikiTextId`) REFERENCES `WikitextTable` (`idWikitext`) ON DELETE NO ACTION ON UPDATE NO ACTION
209) ENGINE=InnoDB DEFAULT CHARSET=latin1;
210SET character_set_client = @saved_cs_client;
211
212--
213-- Dumping data for table `FactoidTable`
214--
215
216LOCK TABLES `FactoidTable` WRITE;
217/*!40000 ALTER TABLE `FactoidTable` DISABLE KEYS */;
218/*!40000 ALTER TABLE `FactoidTable` ENABLE KEYS */;
219UNLOCK TABLES;
220
221--
222-- Table structure for table `FamilyNoteXref`
223--
224
225DROP TABLE IF EXISTS `FamilyNoteXref`;
226SET @saved_cs_client = @@character_set_client;
227SET character_set_client = utf8;
228CREATE TABLE `FamilyNoteXref` (
229 `familyId` varchar(63) NOT NULL,
230 `noteId` varchar(63) NOT NULL,
231 `dateCreated` datetime default NULL,
232 `lastModified` datetime default NULL,
233 PRIMARY KEY (`familyId`,`noteId`),
234 KEY `fk_FamilyNoteXref_FamilyTable1` (`familyId`),
235 KEY `fk_FamilyNoteXref_NoteTable1` (`noteId`),
236 CONSTRAINT `fk_FamilyNoteXref_FamilyTable1` FOREIGN KEY (`familyId`) REFERENCES `FamilyTable` (`idFamily`) ON DELETE NO ACTION ON UPDATE NO ACTION,
237 CONSTRAINT `fk_FamilyNoteXref_NoteTable1` FOREIGN KEY (`noteId`) REFERENCES `NoteTable` (`idNote`) ON DELETE NO ACTION ON UPDATE NO ACTION
238) ENGINE=InnoDB DEFAULT CHARSET=latin1;
239SET character_set_client = @saved_cs_client;
240
241--
242-- Dumping data for table `FamilyNoteXref`
243--
244
245LOCK TABLES `FamilyNoteXref` WRITE;
246/*!40000 ALTER TABLE `FamilyNoteXref` DISABLE KEYS */;
247/*!40000 ALTER TABLE `FamilyNoteXref` ENABLE KEYS */;
248UNLOCK TABLES;
249
250--
251-- Table structure for table `FamilyTable`
252--
253
254DROP TABLE IF EXISTS `FamilyTable`;
255SET @saved_cs_client = @@character_set_client;
256SET character_set_client = utf8;
257CREATE TABLE `FamilyTable` (
258 `idFamily` varchar(63) NOT NULL,
259 `SOterm` varchar(20) default NULL,
260 `level` int(11) default NULL,
261 `isExtendable` tinyint(4) default NULL,
262 `name` char(255) default NULL,
263 `riskGroup` smallint(6) default NULL,
264 `description` char(255) default NULL,
265 `dateCreated` datetime default NULL,
266 `lastModified` datetime default NULL,
267 `familyData` text,
268 `superFamilyId` varchar(63) default NULL,
269 `authorId` varchar(63) default NULL,
270 PRIMARY KEY (`idFamily`),
271 KEY `fk_FamilyTable_PersonTable1` (`authorId`),
272 KEY `fk_FamilyTable_FamilyTable1` (`superFamilyId`),
273 CONSTRAINT `fk_FamilyTable_FamilyTable1` FOREIGN KEY (`superFamilyId`) REFERENCES `FamilyTable` (`idFamily`) ON DELETE NO ACTION ON UPDATE NO ACTION,
274 CONSTRAINT `fk_FamilyTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION
275) ENGINE=InnoDB DEFAULT CHARSET=latin1;
276SET character_set_client = @saved_cs_client;
277
278--
279-- Dumping data for table `FamilyTable`
280--
281
282LOCK TABLES `FamilyTable` WRITE;
283/*!40000 ALTER TABLE `FamilyTable` DISABLE KEYS */;
284/*!40000 ALTER TABLE `FamilyTable` ENABLE KEYS */;
285UNLOCK TABLES;
286
287--
288-- Table structure for table `FeatureFamilyXref`
289--
290
291DROP TABLE IF EXISTS `FeatureFamilyXref`;
292SET @saved_cs_client = @@character_set_client;
293SET character_set_client = utf8;
294CREATE TABLE `FeatureFamilyXref` (
295 `featureId` varchar(63) NOT NULL,
296 `familyId` varchar(63) NOT NULL,
297 `dateCreated` datetime default NULL,
298 `lastModified` datetime default NULL,
299 PRIMARY KEY (`featureId`,`familyId`),
300 KEY `fk_FeatureFamilyXref_FeatureTable1` (`featureId`),
301 KEY `fk_FeatureFamilyXref_FamilyTable1` (`familyId`),
302 CONSTRAINT `fk_FeatureFamilyXref_FeatureTable1` FOREIGN KEY (`featureId`) REFERENCES `FeatureTable` (`idFeature`) ON DELETE NO ACTION ON UPDATE NO ACTION,
303 CONSTRAINT `fk_FeatureFamilyXref_FamilyTable1` FOREIGN KEY (`familyId`) REFERENCES `FamilyTable` (`idFamily`) ON DELETE NO ACTION ON UPDATE NO ACTION
304) ENGINE=InnoDB DEFAULT CHARSET=latin1;
305SET character_set_client = @saved_cs_client;
306
307--
308-- Dumping data for table `FeatureFamilyXref`
309--
310
311LOCK TABLES `FeatureFamilyXref` WRITE;
312/*!40000 ALTER TABLE `FeatureFamilyXref` DISABLE KEYS */;
313/*!40000 ALTER TABLE `FeatureFamilyXref` ENABLE KEYS */;
314UNLOCK TABLES;
315
316--
317-- Table structure for table `FeatureNoteXref`
318--
319
320DROP TABLE IF EXISTS `FeatureNoteXref`;
321SET @saved_cs_client = @@character_set_client;
322SET character_set_client = utf8;
323CREATE TABLE `FeatureNoteXref` (
324 `featureId` varchar(63) NOT NULL,
325 `noteId` varchar(63) NOT NULL,
326 `dateCreated` datetime default NULL,
327 `lastModified` datetime default NULL,
328 PRIMARY KEY (`noteId`,`featureId`),
329 KEY `fk_FeatureNoteXref_FeatureTable1` (`featureId`),
330 KEY `fk_FeatureNoteXref_NoteTable1` (`noteId`),
331 CONSTRAINT `fk_FeatureNoteXref_FeatureTable1` FOREIGN KEY (`featureId`) REFERENCES `FeatureTable` (`idFeature`) ON DELETE NO ACTION ON UPDATE NO ACTION,
332 CONSTRAINT `fk_FeatureNoteXref_NoteTable1` FOREIGN KEY (`noteId`) REFERENCES `NoteTable` (`idNote`) ON DELETE NO ACTION ON UPDATE NO ACTION
333) ENGINE=InnoDB DEFAULT CHARSET=latin1;
334SET character_set_client = @saved_cs_client;
335
336--
337-- Dumping data for table `FeatureNoteXref`
338--
339
340LOCK TABLES `FeatureNoteXref` WRITE;
341/*!40000 ALTER TABLE `FeatureNoteXref` DISABLE KEYS */;
342/*!40000 ALTER TABLE `FeatureNoteXref` ENABLE KEYS */;
343UNLOCK TABLES;
344
345--
346-- Table structure for table `FeatureTable`
347--
348
349DROP TABLE IF EXISTS `FeatureTable`;
350SET @saved_cs_client = @@character_set_client;
351SET character_set_client = utf8;
352CREATE TABLE `FeatureTable` (
353 `idFeature` varchar(63) NOT NULL,
354 `name` char(255) default NULL,
355 `authorId` varchar(63) default NULL,
356 `nucseqId` varchar(63) default NULL,
357 `riskGroup` smallint(6) default NULL,
358 `genbankId` varchar(63) default NULL,
359 `swissprotId` varchar(63) default NULL,
360 `pdbId` varchar(63) default NULL,
361 `forColor` int(11) default NULL,
362 `revColor` int(11) default NULL,
363 `isCDS` tinyint(1) default NULL,
364 `dateCreated` datetime default NULL,
365 `lastModified` datetime default NULL,
366 `featureData` text,
367 PRIMARY KEY (`idFeature`),
368 KEY `fk_FeatureTable_PersonTable1` (`authorId`),
369 KEY `fk_FeatureTable_NucseqTable1` (`nucseqId`),
370 CONSTRAINT `fk_FeatureTable_NucseqTable1` FOREIGN KEY (`nucseqId`) REFERENCES `NucseqTable` (`idNucseq`) ON DELETE NO ACTION ON UPDATE NO ACTION,
371 CONSTRAINT `fk_FeatureTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION
372) ENGINE=InnoDB DEFAULT CHARSET=latin1;
373SET character_set_client = @saved_cs_client;
374
375--
376-- Dumping data for table `FeatureTable`
377--
378
379LOCK TABLES `FeatureTable` WRITE;
380/*!40000 ALTER TABLE `FeatureTable` DISABLE KEYS */;
381/*!40000 ALTER TABLE `FeatureTable` ENABLE KEYS */;
382UNLOCK TABLES;
383
384--
385-- Table structure for table `FeatureTraitXref`
386--
387
388DROP TABLE IF EXISTS `FeatureTraitXref`;
389SET @saved_cs_client = @@character_set_client;
390SET character_set_client = utf8;
391CREATE TABLE `FeatureTraitXref` (
392 `featureId` varchar(63) NOT NULL,
393 `traitId` varchar(63) NOT NULL,
394 `value` text,
395 `dateCreated` datetime default NULL,
396 `lastModified` datetime default NULL,
397 PRIMARY KEY (`featureId`,`traitId`),
398 KEY `fk_FeatureTraitXref_FeatureTable1` (`featureId`),
399 KEY `fk_FeatureTraitXref_TraitTable1` (`traitId`),
400 CONSTRAINT `fk_FeatureTraitXref_FeatureTable1` FOREIGN KEY (`featureId`) REFERENCES `FeatureTable` (`idFeature`) ON DELETE NO ACTION ON UPDATE NO ACTION,
401 CONSTRAINT `fk_FeatureTraitXref_TraitTable1` FOREIGN KEY (`traitId`) REFERENCES `TraitTable` (`idTrait`) ON DELETE NO ACTION ON UPDATE NO ACTION
402) ENGINE=InnoDB DEFAULT CHARSET=latin1;
403SET character_set_client = @saved_cs_client;
404
405--
406-- Dumping data for table `FeatureTraitXref`
407--
408
409LOCK TABLES `FeatureTraitXref` WRITE;
410/*!40000 ALTER TABLE `FeatureTraitXref` DISABLE KEYS */;
411/*!40000 ALTER TABLE `FeatureTraitXref` ENABLE KEYS */;
412UNLOCK TABLES;
413
414--
415-- Table structure for table `FlexfieldDataXref`
416--
417
418DROP TABLE IF EXISTS `FlexfieldDataXref`;
419SET @saved_cs_client = @@character_set_client;
420SET character_set_client = utf8;
421CREATE TABLE `FlexfieldDataXref` (
422 `idFlexfieldDataXref` varchar(63) NOT NULL,
423 `flexfieldId` varchar(63) default NULL,
424 `objectId` varchar(63) default NULL,
425 `objectType` varchar(63) default NULL,
426 `authorId` varchar(63) default NULL,
427 `data1` text,
428 `data2` varchar(63) default NULL,
429 `date3` varchar(63) default NULL,
430 PRIMARY KEY (`idFlexfieldDataXref`),
431 KEY `fk_FlexfieldDataXref_FlexfieldTable1` (`flexfieldId`),
432 KEY `fk_FlexfieldDataXref_PersonTable1` (`authorId`),
433 CONSTRAINT `fk_FlexfieldDataXref_FlexfieldTable1` FOREIGN KEY (`flexfieldId`) REFERENCES `FlexfieldTable` (`idFlexfield`) ON DELETE NO ACTION ON UPDATE NO ACTION,
434 CONSTRAINT `fk_FlexfieldDataXref_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION
435) ENGINE=InnoDB DEFAULT CHARSET=latin1;
436SET character_set_client = @saved_cs_client;
437
438--
439-- Dumping data for table `FlexfieldDataXref`
440--
441
442LOCK TABLES `FlexfieldDataXref` WRITE;
443/*!40000 ALTER TABLE `FlexfieldDataXref` DISABLE KEYS */;
444/*!40000 ALTER TABLE `FlexfieldDataXref` ENABLE KEYS */;
445UNLOCK TABLES;
446
447--
448-- Table structure for table `FlexfieldTable`
449--
450
451DROP TABLE IF EXISTS `FlexfieldTable`;
452SET @saved_cs_client = @@character_set_client;
453SET character_set_client = utf8;
454CREATE TABLE `FlexfieldTable` (
455 `idFlexfield` varchar(63) NOT NULL,
456 `pluginId` varchar(63) default NULL,
457 `name` varchar(63) default NULL,
458 `dateCreated` datetime default NULL,
459 `lastModified` datetime default NULL,
460 PRIMARY KEY (`idFlexfield`)
461) ENGINE=InnoDB DEFAULT CHARSET=latin1;
462SET character_set_client = @saved_cs_client;
463
464--
465-- Dumping data for table `FlexfieldTable`
466--
467
468LOCK TABLES `FlexfieldTable` WRITE;
469/*!40000 ALTER TABLE `FlexfieldTable` DISABLE KEYS */;
470/*!40000 ALTER TABLE `FlexfieldTable` ENABLE KEYS */;
471UNLOCK TABLES;
472
473--
474-- Table structure for table `FormatTable`
475--
476
477DROP TABLE IF EXISTS `FormatTable`;
478SET @saved_cs_client = @@character_set_client;
479SET character_set_client = utf8;
480CREATE TABLE `FormatTable` (
481 `idformat` varchar(63) NOT NULL,
482 `name` char(255) default NULL,
483 `pluginHelpLink` char(255) default NULL,
484 `pluginDownloadLink` char(255) default NULL,
485 `description` char(255) default NULL,
486 `pluginId` varchar(63) default NULL,
487 `dateCreated` datetime default NULL,
488 `lastModified` datetime default NULL,
489 PRIMARY KEY (`idformat`)
490) ENGINE=InnoDB DEFAULT CHARSET=latin1;
491SET character_set_client = @saved_cs_client;
492
493--
494-- Dumping data for table `FormatTable`
495--
496
497LOCK TABLES `FormatTable` WRITE;
498/*!40000 ALTER TABLE `FormatTable` DISABLE KEYS */;
499INSERT 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');
500/*!40000 ALTER TABLE `FormatTable` ENABLE KEYS */;
501UNLOCK TABLES;
502
503--
504-- Table structure for table `GrammarTable`
505--
506
507DROP TABLE IF EXISTS `GrammarTable`;
508SET @saved_cs_client = @@character_set_client;
509SET character_set_client = utf8;
510CREATE TABLE `GrammarTable` (
511 `idGrammar` varchar(63) NOT NULL,
512 `name` char(255) default NULL,
513 `pluginHelpLink` char(255) default NULL,
514 `pluginDownloadLink` char(255) default NULL,
515 `description` char(255) default NULL,
516 `pluginId` varchar(63) default NULL,
517 `dateCreated` datetime default NULL,
518 `lastModified` datetime default NULL,
519 PRIMARY KEY (`idGrammar`)
520) ENGINE=InnoDB DEFAULT CHARSET=latin1;
521SET character_set_client = @saved_cs_client;
522
523--
524-- Dumping data for table `GrammarTable`
525--
526
527LOCK TABLES `GrammarTable` WRITE;
528/*!40000 ALTER TABLE `GrammarTable` DISABLE KEYS */;
529/*!40000 ALTER TABLE `GrammarTable` ENABLE KEYS */;
530UNLOCK TABLES;
531
532--
533-- Table structure for table `InstitutionTable`
534--
535
536DROP TABLE IF EXISTS `InstitutionTable`;
537SET @saved_cs_client = @@character_set_client;
538SET character_set_client = utf8;
539CREATE TABLE `InstitutionTable` (
540 `idInstitution` varchar(63) NOT NULL,
541 `name` char(255) default NULL,
542 `city` char(255) default NULL,
543 `stateProvince` char(255) default NULL,
544 `country` char(255) default NULL,
545 `dateCreated` datetime default NULL,
546 `lastModified` datetime default NULL,
547 PRIMARY KEY (`idInstitution`)
548) ENGINE=InnoDB DEFAULT CHARSET=latin1;
549SET character_set_client = @saved_cs_client;
550
551--
552-- Dumping data for table `InstitutionTable`
553--
554
555LOCK TABLES `InstitutionTable` WRITE;
556/*!40000 ALTER TABLE `InstitutionTable` DISABLE KEYS */;
557INSERT INTO `InstitutionTable` VALUES ('9f304e9b21424c6896b45e9cfbf89d19','UC Berkeley','Berkeley','CA','USA','2010-10-30 18:41:20','2010-10-30 18:41:20');
558/*!40000 ALTER TABLE `InstitutionTable` ENABLE KEYS */;
559UNLOCK TABLES;
560
561--
562-- Table structure for table `LabTable`
563--
564
565DROP TABLE IF EXISTS `LabTable`;
566SET @saved_cs_client = @@character_set_client;
567SET character_set_client = utf8;
568CREATE TABLE `LabTable` (
569 `idLab` varchar(63) NOT NULL,
570 `name` char(255) default NULL,
571 `department` char(255) default NULL,
572 `website` char(255) default NULL,
573 `address` char(255) default NULL,
574 `dateCreated` datetime default NULL,
575 `lastModified` datetime default NULL,
576 `institutionId` varchar(63) default NULL,
577 `principalInvestigatorId` varchar(63) default NULL,
578 PRIMARY KEY (`idLab`),
579 KEY `fk_LabTable_InstitutionTable` (`institutionId`),
580 KEY `fk_LabTable_PersonTable1` (`principalInvestigatorId`),
581 CONSTRAINT `fk_LabTable_InstitutionTable` FOREIGN KEY (`institutionId`) REFERENCES `InstitutionTable` (`idInstitution`) ON DELETE NO ACTION ON UPDATE NO ACTION,
582 CONSTRAINT `fk_LabTable_PersonTable1` FOREIGN KEY (`principalInvestigatorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION
583) ENGINE=InnoDB DEFAULT CHARSET=latin1;
584SET character_set_client = @saved_cs_client;
585
586--
587-- Dumping data for table `LabTable`
588--
589
590LOCK TABLES `LabTable` WRITE;
591/*!40000 ALTER TABLE `LabTable` DISABLE KEYS */;
592INSERT 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);
593/*!40000 ALTER TABLE `LabTable` ENABLE KEYS */;
594UNLOCK TABLES;
595
596--
597-- Table structure for table `NoteFactoidXref`
598--
599
600DROP TABLE IF EXISTS `NoteFactoidXref`;
601SET @saved_cs_client = @@character_set_client;
602SET character_set_client = utf8;
603CREATE TABLE `NoteFactoidXref` (
604 `noteId` varchar(63) NOT NULL,
605 `factoidId` varchar(63) NOT NULL,
606 `authorId` varchar(63) default NULL,
607 `dateCreated` datetime default NULL,
608 `lastModified` datetime default NULL,
609 PRIMARY KEY (`noteId`,`factoidId`),
610 KEY `fk_NoteFactoidXref_NoteTable1` (`noteId`),
611 KEY `fk_NoteFactoidXref_FactoidTable1` (`factoidId`),
612 KEY `fk_NoteFactoidXref_PersonTable1` (`authorId`),
613 CONSTRAINT `fk_NoteFactoidXref_FactoidTable10` FOREIGN KEY (`factoidId`) REFERENCES `FactoidTable` (`idFactoid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
614 CONSTRAINT `fk_NoteFactoidXref_NoteTable10` FOREIGN KEY (`noteId`) REFERENCES `NoteTable` (`idNote`) ON DELETE NO ACTION ON UPDATE NO ACTION,
615 CONSTRAINT `fk_NoteFactoidXref_PersonTable10` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION
616) ENGINE=InnoDB DEFAULT CHARSET=latin1;
617SET character_set_client = @saved_cs_client;
618
619--
620-- Dumping data for table `NoteFactoidXref`
621--
622
623LOCK TABLES `NoteFactoidXref` WRITE;
624/*!40000 ALTER TABLE `NoteFactoidXref` DISABLE KEYS */;
625/*!40000 ALTER TABLE `NoteFactoidXref` ENABLE KEYS */;
626UNLOCK TABLES;
627
628--
629-- Table structure for table `NoteNoteXref`
630--
631
632DROP TABLE IF EXISTS `NoteNoteXref`;
633SET @saved_cs_client = @@character_set_client;
634SET character_set_client = utf8;
635CREATE TABLE `NoteNoteXref` (
636 `childNoteId` varchar(63) NOT NULL,
637 `parentNoteId` varchar(63) NOT NULL,
638 `authorId` varchar(63) default NULL,
639 `dateCreated` datetime default NULL,
640 `lastModified` datetime default NULL,
641 PRIMARY KEY (`parentNoteId`,`childNoteId`),
642 KEY `fk_NoteFactoidXref_NoteTable1` (`parentNoteId`),
643 KEY `fk_NoteFactoidXref_PersonTable1` (`authorId`),
644 KEY `fk_NoteNoteXref_NoteTable1` (`childNoteId`),
645 CONSTRAINT `fk_NoteFactoidXref_NoteTable1` FOREIGN KEY (`parentNoteId`) REFERENCES `NoteTable` (`idNote`) ON DELETE NO ACTION ON UPDATE NO ACTION,
646 CONSTRAINT `fk_NoteFactoidXref_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION,
647 CONSTRAINT `fk_NoteNoteXref_NoteTable1` FOREIGN KEY (`childNoteId`) REFERENCES `NoteTable` (`idNote`) ON DELETE NO ACTION ON UPDATE NO ACTION
648) ENGINE=InnoDB DEFAULT CHARSET=latin1;
649SET character_set_client = @saved_cs_client;
650
651--
652-- Dumping data for table `NoteNoteXref`
653--
654
655LOCK TABLES `NoteNoteXref` WRITE;
656/*!40000 ALTER TABLE `NoteNoteXref` DISABLE KEYS */;
657/*!40000 ALTER TABLE `NoteNoteXref` ENABLE KEYS */;
658UNLOCK TABLES;
659
660--
661-- Table structure for table `NoteTable`
662--
663
664DROP TABLE IF EXISTS `NoteTable`;
665SET @saved_cs_client = @@character_set_client;
666SET character_set_client = utf8;
667CREATE TABLE `NoteTable` (
668 `idNote` varchar(63) NOT NULL,
669 `name` char(255) default NULL,
670 `blurbId` varchar(63) default NULL,
671 `authorId` varchar(63) default NULL,
672 `dateCreated` datetime default NULL,
673 `lastModified` datetime default NULL,
674 PRIMARY KEY (`idNote`),
675 KEY `fk_NoteTable_WikitextTable1` (`blurbId`),
676 KEY `fk_NoteTable_PersonTable1` (`authorId`),
677 CONSTRAINT `fk_NoteTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION,
678 CONSTRAINT `fk_NoteTable_WikitextTable1` FOREIGN KEY (`blurbId`) REFERENCES `WikitextTable` (`idWikitext`) ON DELETE NO ACTION ON UPDATE NO ACTION
679) ENGINE=InnoDB DEFAULT CHARSET=latin1;
680SET character_set_client = @saved_cs_client;
681
682--
683-- Dumping data for table `NoteTable`
684--
685
686LOCK TABLES `NoteTable` WRITE;
687/*!40000 ALTER TABLE `NoteTable` DISABLE KEYS */;
688/*!40000 ALTER TABLE `NoteTable` ENABLE KEYS */;
689UNLOCK TABLES;
690
691--
692-- Table structure for table `NucseqAnnotation`
693--
694
695DROP TABLE IF EXISTS `NucseqAnnotation`;
696SET @saved_cs_client = @@character_set_client;
697SET character_set_client = utf8;
698CREATE TABLE `NucseqAnnotation` (
699 `name` char(255) default NULL,
700 `annotationId` varchar(63) NOT NULL,
701 `nucseqId` varchar(63) default NULL,
702 `featureId` varchar(63) default NULL,
703 `authorId` varchar(63) default NULL,
704 `forwardColor` int(11) default NULL,
705 `reverseColor` int(11) default NULL,
706 `startx` int(11) default NULL,
707 `endx` int(11) default NULL,
708 `reverseComplement` tinyint(1) default NULL,
709 `dateCreated` datetime default NULL,
710 `lastModified` datetime default NULL,
711 PRIMARY KEY (`annotationId`),
712 KEY `fk_NucseqAnnotation_NucseqTable1` (`nucseqId`),
713 KEY `fk_NucseqAnnotation_FeatureTable1` (`featureId`),
714 KEY `fk_NucseqAnnotation_PersonTable1` (`authorId`),
715 CONSTRAINT `fk_NucseqAnnotation_FeatureTable1` FOREIGN KEY (`featureId`) REFERENCES `FeatureTable` (`idFeature`) ON DELETE NO ACTION ON UPDATE NO ACTION,
716 CONSTRAINT `fk_NucseqAnnotation_NucseqTable1` FOREIGN KEY (`nucseqId`) REFERENCES `NucseqTable` (`idNucseq`) ON DELETE NO ACTION ON UPDATE NO ACTION,
717 CONSTRAINT `fk_NucseqAnnotation_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION
718) ENGINE=InnoDB DEFAULT CHARSET=latin1;
719SET character_set_client = @saved_cs_client;
720
721--
722-- Dumping data for table `NucseqAnnotation`
723--
724
725LOCK TABLES `NucseqAnnotation` WRITE;
726/*!40000 ALTER TABLE `NucseqAnnotation` DISABLE KEYS */;
727/*!40000 ALTER TABLE `NucseqAnnotation` ENABLE KEYS */;
728UNLOCK TABLES;
729
730--
731-- Table structure for table `NucseqTable`
732--
733
734DROP TABLE IF EXISTS `NucseqTable`;
735SET @saved_cs_client = @@character_set_client;
736SET character_set_client = utf8;
737CREATE TABLE `NucseqTable` (
738 `idNucseq` varchar(63) NOT NULL,
739 `sequence` text,
740 `isLocked` tinyint(1) default '1',
741 `dateCreated` datetime default NULL,
742 `lastmodified` datetime default NULL,
743 PRIMARY KEY (`idNucseq`)
744) ENGINE=InnoDB DEFAULT CHARSET=latin1;
745SET character_set_client = @saved_cs_client;
746
747--
748-- Dumping data for table `NucseqTable`
749--
750
751LOCK TABLES `NucseqTable` WRITE;
752/*!40000 ALTER TABLE `NucseqTable` DISABLE KEYS */;
753INSERT 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');
754/*!40000 ALTER TABLE `NucseqTable` ENABLE KEYS */;
755UNLOCK TABLES;
756
757--
758-- Table structure for table `OligoTable`
759--
760
761DROP TABLE IF EXISTS `OligoTable`;
762SET @saved_cs_client = @@character_set_client;
763SET character_set_client = utf8;
764CREATE TABLE `OligoTable` (
765 `idOligo` varchar(63) NOT NULL,
766 `name` char(255) default NULL,
767 `nucseqId` varchar(63) default NULL,
768 `description` char(255) default NULL,
769 `authorId` varchar(63) default NULL,
770 `dateCreated` datetime default NULL,
771 `lastModified` datetime default NULL,
772 PRIMARY KEY (`idOligo`),
773 KEY `fk_OligoTable_NucseqTable1` (`nucseqId`),
774 KEY `fk_OligoTable_PersonTable1` (`authorId`),
775 CONSTRAINT `fk_OligoTable_NucseqTable1` FOREIGN KEY (`nucseqId`) REFERENCES `NucseqTable` (`idNucseq`) ON DELETE NO ACTION ON UPDATE NO ACTION,
776 CONSTRAINT `fk_OligoTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION
777) ENGINE=InnoDB DEFAULT CHARSET=latin1;
778SET character_set_client = @saved_cs_client;
779
780--
781-- Dumping data for table `OligoTable`
782--
783
784LOCK TABLES `OligoTable` WRITE;
785/*!40000 ALTER TABLE `OligoTable` DISABLE KEYS */;
786/*!40000 ALTER TABLE `OligoTable` ENABLE KEYS */;
787UNLOCK TABLES;
788
789--
790-- Table structure for table `PartGrammarXref`
791--
792
793DROP TABLE IF EXISTS `PartGrammarXref`;
794SET @saved_cs_client = @@character_set_client;
795SET character_set_client = utf8;
796CREATE TABLE `PartGrammarXref` (
797 `partId` varchar(63) NOT NULL,
798 `grammarId` varchar(63) NOT NULL,
799 `authorId` varchar(63) default NULL,
800 `token` varchar(63) default NULL,
801 `dateCreated` datetime default NULL,
802 `lastModified` datetime default NULL,
803 PRIMARY KEY (`partId`,`grammarId`),
804 KEY `fk_PartGrammarXref_PartTable1` (`partId`),
805 KEY `fk_PartGrammarXref_GrammarTable1` (`grammarId`),
806 KEY `fk_PartGrammarXref_PersonTable1` (`authorId`),
807 CONSTRAINT `fk_PartGrammarXref_GrammarTable1` FOREIGN KEY (`grammarId`) REFERENCES `GrammarTable` (`idGrammar`) ON DELETE NO ACTION ON UPDATE NO ACTION,
808 CONSTRAINT `fk_PartGrammarXref_PartTable1` FOREIGN KEY (`partId`) REFERENCES `PartTable` (`idPart`) ON DELETE NO ACTION ON UPDATE NO ACTION,
809 CONSTRAINT `fk_PartGrammarXref_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION
810) ENGINE=InnoDB DEFAULT CHARSET=latin1;
811SET character_set_client = @saved_cs_client;
812
813--
814-- Dumping data for table `PartGrammarXref`
815--
816
817LOCK TABLES `PartGrammarXref` WRITE;
818/*!40000 ALTER TABLE `PartGrammarXref` DISABLE KEYS */;
819/*!40000 ALTER TABLE `PartGrammarXref` ENABLE KEYS */;
820UNLOCK TABLES;
821
822--
823-- Table structure for table `PartTable`
824--
825
826DROP TABLE IF EXISTS `PartTable`;
827SET @saved_cs_client = @@character_set_client;
828SET character_set_client = utf8;
829CREATE TABLE `PartTable` (
830 `idPart` varchar(63) NOT NULL,
831 `formatId` varchar(63) default NULL,
832 `nucseqId` varchar(63) default NULL,
833 `description` char(255) default NULL,
834 `authorId` varchar(63) default NULL,
835 `name` char(255) default NULL,
836 `riskGroup` smallint(6) default NULL,
837 `dateCreated` datetime default NULL,
838 `lastModified` datetime default NULL,
839 `hash` varchar(63) default NULL,
840 `isBasic` tinyint(4) default NULL,
841 PRIMARY KEY (`idPart`),
842 KEY `fk_PartTable_FormatTable1` (`formatId`),
843 KEY `fk_PartTable_NucseqTable1` (`nucseqId`),
844 KEY `fk_PartTable_PersonTable1` (`authorId`),
845 CONSTRAINT `fk_PartTable_FormatTable1` FOREIGN KEY (`formatId`) REFERENCES `FormatTable` (`idformat`) ON DELETE NO ACTION ON UPDATE NO ACTION,
846 CONSTRAINT `fk_PartTable_NucseqTable1` FOREIGN KEY (`nucseqId`) REFERENCES `NucseqTable` (`idNucseq`) ON DELETE NO ACTION ON UPDATE NO ACTION,
847 CONSTRAINT `fk_PartTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION
848) ENGINE=InnoDB DEFAULT CHARSET=latin1;
849SET character_set_client = @saved_cs_client;
850
851--
852-- Dumping data for table `PartTable`
853--
854
855LOCK TABLES `PartTable` WRITE;
856/*!40000 ALTER TABLE `PartTable` DISABLE KEYS */;
857/*!40000 ALTER TABLE `PartTable` ENABLE KEYS */;
858UNLOCK TABLES;
859
860--
861-- Table structure for table `PersonTable`
862--
863
864DROP TABLE IF EXISTS `PersonTable`;
865SET @saved_cs_client = @@character_set_client;
866SET character_set_client = utf8;
867CREATE TABLE `PersonTable` (
868 `idPerson` varchar(63) NOT NULL,
869 `labId` varchar(63) default NULL,
870 `displayName` char(255) default NULL,
871 `givenName` char(255) default NULL,
872 `surName` char(255) default NULL,
873 `nickName` char(255) default NULL,
874 `emailAddress` char(255) default NULL,
875 `snailMailAddress` char(255) default NULL,
876 `registryName` char(255) default NULL,
877 `dateCreated` datetime default NULL,
878 `lastModified` datetime default NULL,
879 `password` varchar(63) default NULL,
880 `isAdministrator` tinyint(1) default NULL,
881 `personalCollectionId` varchar(63) default NULL,
882 `biographID` varchar(63) default NULL,
883 PRIMARY KEY (`idPerson`),
884 KEY `fk_PersonTable_LabTable1` (`labId`),
885 KEY `fk_PersonTable_CollectionTable1` (`personalCollectionId`),
886 KEY `fk_PersonTable_WikitextTable1` (`biographID`),
887 CONSTRAINT `fk_PersonTable_CollectionTable1` FOREIGN KEY (`personalCollectionId`) REFERENCES `CollectionTable` (`idCollection`) ON DELETE NO ACTION ON UPDATE NO ACTION,
888 CONSTRAINT `fk_PersonTable_LabTable1` FOREIGN KEY (`labId`) REFERENCES `LabTable` (`idLab`) ON DELETE NO ACTION ON UPDATE NO ACTION,
889 CONSTRAINT `fk_PersonTable_WikitextTable1` FOREIGN KEY (`biographID`) REFERENCES `WikitextTable` (`idWikitext`) ON DELETE NO ACTION ON UPDATE NO ACTION
890) ENGINE=InnoDB DEFAULT CHARSET=latin1;
891SET character_set_client = @saved_cs_client;
892
893--
894-- Dumping data for table `PersonTable`
895--
896
897LOCK TABLES `PersonTable` WRITE;
898/*!40000 ALTER TABLE `PersonTable` DISABLE KEYS */;
899INSERT 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');
900/*!40000 ALTER TABLE `PersonTable` ENABLE KEYS */;
901UNLOCK TABLES;
902
903--
904-- Table structure for table `PlasmidTable`
905--
906
907DROP TABLE IF EXISTS `PlasmidTable`;
908SET @saved_cs_client = @@character_set_client;
909SET character_set_client = utf8;
910CREATE TABLE `PlasmidTable` (
911 `idPlasmid` varchar(63) NOT NULL,
912 `vectorId` varchar(63) default NULL,
913 `partId` varchar(63) default NULL,
914 `formatId` varchar(63) default NULL,
915 `name` char(255) default NULL,
916 `authorId` varchar(63) default NULL,
917 `constructionFile` text,
918 `riskGroup` smallint(6) default NULL,
919 `dateCreated` datetime default NULL,
920 `lastModified` datetime default NULL,
921 PRIMARY KEY (`idPlasmid`),
922 KEY `fk_PlasmidTable_VectorTable1` (`vectorId`),
923 KEY `fk_PlasmidTable_PartTable1` (`partId`),
924 KEY `fk_PlasmidTable_FormatTable1` (`formatId`),
925 KEY `fk_PlasmidTable_PersonTable1` (`authorId`),
926 CONSTRAINT `fk_PlasmidTable_FormatTable1` FOREIGN KEY (`formatId`) REFERENCES `FormatTable` (`idformat`) ON DELETE NO ACTION ON UPDATE NO ACTION,
927 CONSTRAINT `fk_PlasmidTable_PartTable1` FOREIGN KEY (`partId`) REFERENCES `PartTable` (`idPart`) ON DELETE NO ACTION ON UPDATE NO ACTION,
928 CONSTRAINT `fk_PlasmidTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION,
929 CONSTRAINT `fk_PlasmidTable_VectorTable1` FOREIGN KEY (`vectorId`) REFERENCES `VectorTable` (`idVector`) ON DELETE NO ACTION ON UPDATE NO ACTION
930) ENGINE=InnoDB DEFAULT CHARSET=latin1;
931SET character_set_client = @saved_cs_client;
932
933--
934-- Dumping data for table `PlasmidTable`
935--
936
937LOCK TABLES `PlasmidTable` WRITE;
938/*!40000 ALTER TABLE `PlasmidTable` DISABLE KEYS */;
939/*!40000 ALTER TABLE `PlasmidTable` ENABLE KEYS */;
940UNLOCK TABLES;
941
942--
943-- Table structure for table `PlateTable`
944--
945
946DROP TABLE IF EXISTS `PlateTable`;
947SET @saved_cs_client = @@character_set_client;
948SET character_set_client = utf8;
949CREATE TABLE `PlateTable` (
950 `idPlate` varchar(63) NOT NULL,
951 `name` char(255) default NULL,
952 `barcode` char(255) default NULL,
953 `location` char(255) default NULL,
954 `plateTypeId` varchar(63) default NULL,
955 `authorId` varchar(63) default NULL,
956 `dateCreated` datetime default NULL,
957 `lastModified` datetime default NULL,
958 PRIMARY KEY (`idPlate`),
959 KEY `fk_PlateTable_PlateTypeTable1` (`plateTypeId`),
960 KEY `fk_PlateTable_PersonTable1` (`authorId`),
961 CONSTRAINT `fk_PlateTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION,
962 CONSTRAINT `fk_PlateTable_PlateTypeTable1` FOREIGN KEY (`plateTypeId`) REFERENCES `PlateTypeTable` (`idPlateType`) ON DELETE NO ACTION ON UPDATE NO ACTION
963) ENGINE=InnoDB DEFAULT CHARSET=latin1;
964SET character_set_client = @saved_cs_client;
965
966--
967-- Dumping data for table `PlateTable`
968--
969
970LOCK TABLES `PlateTable` WRITE;
971/*!40000 ALTER TABLE `PlateTable` DISABLE KEYS */;
972/*!40000 ALTER TABLE `PlateTable` ENABLE KEYS */;
973UNLOCK TABLES;
974
975--
976-- Table structure for table `PlateTypeTable`
977--
978
979DROP TABLE IF EXISTS `PlateTypeTable`;
980SET @saved_cs_client = @@character_set_client;
981SET character_set_client = utf8;
982CREATE TABLE `PlateTypeTable` (
983 `idPlateType` varchar(63) NOT NULL,
984 `name` char(255) default NULL,
985 `numRows` smallint(6) default NULL,
986 `numColumns` smallint(6) default NULL,
987 `isContainerFixed` tinyint(1) default NULL,
988 `AttachmentTable_idAttachment` varchar(63) default NULL,
989 `dateCreated` datetime default NULL,
990 `wellPosX` mediumtext,
991 `wellPosY` mediumtext,
992 `lastModified` datetime default NULL,
993 `wellDiameter` int(11) default NULL,
994 `squareWells` tinyint(1) default NULL,
995 `squareWellHeight` int(11) default NULL,
996 `squareWellWidth` int(11) default NULL,
997 `mmWidth` double default NULL,
998 `mmHeight` double default NULL,
999 `mmXOffset` double default NULL,
1000 `mmYOffset` double default NULL,
1001 `mmXWellSpacing` double default NULL,
1002 `mmYWellSpacing` double default NULL,
1003 `mmWellWidth` double default NULL,
1004 `mmWellHeight` double default NULL,
1005 `mmWellDiameter` double default NULL,
1006 PRIMARY KEY (`idPlateType`),
1007 KEY `fk_PlateTypeTable_AttachmentTable1` (`AttachmentTable_idAttachment`),
1008 CONSTRAINT `fk_PlateTypeTable_AttachmentTable1` FOREIGN KEY (`AttachmentTable_idAttachment`) REFERENCES `AttachmentTable` (`idAttachment`) ON DELETE NO ACTION ON UPDATE NO ACTION
1009) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1010SET character_set_client = @saved_cs_client;
1011
1012--
1013-- Dumping data for table `PlateTypeTable`
1014--
1015
1016LOCK TABLES `PlateTypeTable` WRITE;
1017/*!40000 ALTER TABLE `PlateTypeTable` DISABLE KEYS */;
1018/*!40000 ALTER TABLE `PlateTypeTable` ENABLE KEYS */;
1019UNLOCK TABLES;
1020
1021--
1022-- Table structure for table `SampleDataTable`
1023--
1024
1025DROP TABLE IF EXISTS `SampleDataTable`;
1026SET @saved_cs_client = @@character_set_client;
1027SET character_set_client = utf8;
1028CREATE TABLE `SampleDataTable` (
1029 `idSampleData` varchar(63) NOT NULL,
1030 `authorId` varchar(63) default NULL,
1031 `wikiTextId` varchar(63) default NULL,
1032 `attachmentId` varchar(63) default NULL,
1033 `name` char(255) default NULL,
1034 `dataType` varchar(63) default NULL,
1035 `dateCreated` datetime default NULL,
1036 `lastModified` datetime default NULL,
1037 `freeString1` text,
1038 `freeString2` text,
1039 `freeString3` text,
1040 `freeString4` text,
1041 PRIMARY KEY (`idSampleData`),
1042 KEY `fk_SampleDataTable_WikitextTable1` (`wikiTextId`),
1043 KEY `fk_SampleDataTable_PersonTable1` (`authorId`),
1044 KEY `fk_SampleDataTable_AttachmentTable1` (`attachmentId`),
1045 CONSTRAINT `fk_SampleDataTable_AttachmentTable1` FOREIGN KEY (`attachmentId`) REFERENCES `AttachmentTable` (`idAttachment`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1046 CONSTRAINT `fk_SampleDataTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1047 CONSTRAINT `fk_SampleDataTable_WikitextTable1` FOREIGN KEY (`wikiTextId`) REFERENCES `WikitextTable` (`idWikitext`) ON DELETE NO ACTION ON UPDATE NO ACTION
1048) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1049SET character_set_client = @saved_cs_client;
1050
1051--
1052-- Dumping data for table `SampleDataTable`
1053--
1054
1055LOCK TABLES `SampleDataTable` WRITE;
1056/*!40000 ALTER TABLE `SampleDataTable` DISABLE KEYS */;
1057/*!40000 ALTER TABLE `SampleDataTable` ENABLE KEYS */;
1058UNLOCK TABLES;
1059
1060--
1061-- Table structure for table `SampleDataXref`
1062--
1063
1064DROP TABLE IF EXISTS `SampleDataXref`;
1065SET @saved_cs_client = @@character_set_client;
1066SET character_set_client = utf8;
1067CREATE TABLE `SampleDataXref` (
1068 `sampleId` varchar(63) NOT NULL,
1069 `sampleDataId` varchar(63) NOT NULL,
1070 `dateCreated` datetime default NULL,
1071 `lastModified` datetime default NULL,
1072 PRIMARY KEY (`sampleId`,`sampleDataId`),
1073 KEY `fk_SampleDataXref_SampleTable1` (`sampleId`),
1074 KEY `fk_SampleDataXref_SampleDataTable1` (`sampleDataId`),
1075 CONSTRAINT `fk_SampleDataXref_SampleDataTable1` FOREIGN KEY (`sampleDataId`) REFERENCES `SampleDataTable` (`idSampleData`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1076 CONSTRAINT `fk_SampleDataXref_SampleTable1` FOREIGN KEY (`sampleId`) REFERENCES `SampleTable` (`idSample`) ON DELETE NO ACTION ON UPDATE NO ACTION
1077) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1078SET character_set_client = @saved_cs_client;
1079
1080--
1081-- Dumping data for table `SampleDataXref`
1082--
1083
1084LOCK TABLES `SampleDataXref` WRITE;
1085/*!40000 ALTER TABLE `SampleDataXref` DISABLE KEYS */;
1086/*!40000 ALTER TABLE `SampleDataXref` ENABLE KEYS */;
1087UNLOCK TABLES;
1088
1089--
1090-- Table structure for table `SampleTable`
1091--
1092
1093DROP TABLE IF EXISTS `SampleTable`;
1094SET @saved_cs_client = @@character_set_client;
1095SET character_set_client = utf8;
1096CREATE TABLE `SampleTable` (
1097 `idSample` varchar(63) NOT NULL,
1098 `sampleType` varchar(63) default NULL,
1099 `name` char(255) default NULL,
1100 `quality` smallint(6) default NULL,
1101 `concentration` double default NULL,
1102 `volume` double default NULL,
1103 `containerId` varchar(63) default NULL,
1104 `authorId` varchar(63) default NULL,
1105 `dateLastUsed` datetime default NULL,
1106 `dateCreated` datetime default NULL,
1107 `lastModified` datetime default NULL,
1108 `oligoId` varchar(63) default NULL,
1109 `plasmidId` varchar(63) default NULL,
1110 `strainId` varchar(63) default NULL,
1111 PRIMARY KEY (`idSample`),
1112 KEY `fk_SampleTable_ContainerTable1` (`containerId`),
1113 KEY `fk_SampleTable_PersonTable1` (`authorId`),
1114 KEY `fk_SampleTable_OligoTable1` (`oligoId`),
1115 KEY `fk_SampleTable_PlasmidTable1` (`plasmidId`),
1116 KEY `fk_SampleTable_StrainTable1` (`strainId`),
1117 CONSTRAINT `fk_SampleTable_ContainerTable1` FOREIGN KEY (`containerId`) REFERENCES `ContainerTable` (`idContainer`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1118 CONSTRAINT `fk_SampleTable_OligoTable1` FOREIGN KEY (`oligoId`) REFERENCES `OligoTable` (`idOligo`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1119 CONSTRAINT `fk_SampleTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1120 CONSTRAINT `fk_SampleTable_PlasmidTable1` FOREIGN KEY (`plasmidId`) REFERENCES `PlasmidTable` (`idPlasmid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1121 CONSTRAINT `fk_SampleTable_StrainTable1` FOREIGN KEY (`strainId`) REFERENCES `StrainTable` (`idStrain`) ON DELETE NO ACTION ON UPDATE NO ACTION
1122) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1123SET character_set_client = @saved_cs_client;
1124
1125--
1126-- Dumping data for table `SampleTable`
1127--
1128
1129LOCK TABLES `SampleTable` WRITE;
1130/*!40000 ALTER TABLE `SampleTable` DISABLE KEYS */;
1131/*!40000 ALTER TABLE `SampleTable` ENABLE KEYS */;
1132UNLOCK TABLES;
1133
1134--
1135-- Table structure for table `SearchtagTable`
1136--
1137
1138DROP TABLE IF EXISTS `SearchtagTable`;
1139SET @saved_cs_client = @@character_set_client;
1140SET character_set_client = utf8;
1141CREATE TABLE `SearchtagTable` (
1142 `idSearchtag` varchar(63) NOT NULL,
1143 `name` char(255) default NULL,
1144 `authorId` varchar(63) default NULL,
1145 `objectId` varchar(63) default NULL,
1146 `objectType` varchar(63) default NULL,
1147 `dateCreated` datetime default NULL,
1148 `lastModified` datetime default NULL,
1149 PRIMARY KEY (`idSearchtag`),
1150 KEY `fk_CollectionTable_PersonTable1` (`authorId`),
1151 CONSTRAINT `fk_CollectionTable_PersonTable10` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION
1152) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1153SET character_set_client = @saved_cs_client;
1154
1155--
1156-- Dumping data for table `SearchtagTable`
1157--
1158
1159LOCK TABLES `SearchtagTable` WRITE;
1160/*!40000 ALTER TABLE `SearchtagTable` DISABLE KEYS */;
1161/*!40000 ALTER TABLE `SearchtagTable` ENABLE KEYS */;
1162UNLOCK TABLES;
1163
1164--
1165-- Table structure for table `StrainNoteXref`
1166--
1167
1168DROP TABLE IF EXISTS `StrainNoteXref`;
1169SET @saved_cs_client = @@character_set_client;
1170SET character_set_client = utf8;
1171CREATE TABLE `StrainNoteXref` (
1172 `strainId` varchar(63) NOT NULL,
1173 `noteId` varchar(63) NOT NULL,
1174 `dateCreated` datetime default NULL,
1175 `lastModified` datetime default NULL,
1176 PRIMARY KEY (`strainId`,`noteId`),
1177 KEY `fk_StrainNoteXref_StrainTable1` (`strainId`),
1178 KEY `fk_StrainNoteXref_NoteTable1` (`noteId`),
1179 CONSTRAINT `fk_StrainNoteXref_NoteTable1` FOREIGN KEY (`noteId`) REFERENCES `NoteTable` (`idNote`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1180 CONSTRAINT `fk_StrainNoteXref_StrainTable1` FOREIGN KEY (`strainId`) REFERENCES `StrainTable` (`idStrain`) ON DELETE NO ACTION ON UPDATE NO ACTION
1181) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1182SET character_set_client = @saved_cs_client;
1183
1184--
1185-- Dumping data for table `StrainNoteXref`
1186--
1187
1188LOCK TABLES `StrainNoteXref` WRITE;
1189/*!40000 ALTER TABLE `StrainNoteXref` DISABLE KEYS */;
1190/*!40000 ALTER TABLE `StrainNoteXref` ENABLE KEYS */;
1191UNLOCK TABLES;
1192
1193--
1194-- Table structure for table `StrainPlasmidXref`
1195--
1196
1197DROP TABLE IF EXISTS `StrainPlasmidXref`;
1198SET @saved_cs_client = @@character_set_client;
1199SET character_set_client = utf8;
1200CREATE TABLE `StrainPlasmidXref` (
1201 `strainId` varchar(63) NOT NULL,
1202 `plasmidId` varchar(63) NOT NULL,
1203 `authorId` varchar(63) default NULL,
1204 `genomeStart` int(11) default NULL,
1205 `genomeEnd` int(11) default NULL,
1206 `revComp` tinyint(1) default NULL,
1207 `isGenomic` tinyint(1) default NULL,
1208 `dateCreated` datetime default NULL,
1209 `lastModified` datetime default NULL,
1210 PRIMARY KEY (`strainId`,`plasmidId`),
1211 KEY `fk_StrainPlasmidXref_StrainTable1` (`strainId`),
1212 KEY `fk_StrainPlasmidXref_PlasmidTable1` (`plasmidId`),
1213 KEY `fk_StrainPlasmidXref_PersonTable1` (`authorId`),
1214 CONSTRAINT `fk_StrainPlasmidXref_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1215 CONSTRAINT `fk_StrainPlasmidXref_PlasmidTable1` FOREIGN KEY (`plasmidId`) REFERENCES `PlasmidTable` (`idPlasmid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1216 CONSTRAINT `fk_StrainPlasmidXref_StrainTable1` FOREIGN KEY (`strainId`) REFERENCES `StrainTable` (`idStrain`) ON DELETE NO ACTION ON UPDATE NO ACTION
1217) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1218SET character_set_client = @saved_cs_client;
1219
1220--
1221-- Dumping data for table `StrainPlasmidXref`
1222--
1223
1224LOCK TABLES `StrainPlasmidXref` WRITE;
1225/*!40000 ALTER TABLE `StrainPlasmidXref` DISABLE KEYS */;
1226/*!40000 ALTER TABLE `StrainPlasmidXref` ENABLE KEYS */;
1227UNLOCK TABLES;
1228
1229--
1230-- Table structure for table `StrainTable`
1231--
1232
1233DROP TABLE IF EXISTS `StrainTable`;
1234SET @saved_cs_client = @@character_set_client;
1235SET character_set_client = utf8;
1236CREATE TABLE `StrainTable` (
1237 `idStrain` varchar(63) NOT NULL,
1238 `name` char(255) default NULL,
1239 `description` char(255) default NULL,
1240 `personId` varchar(63) default NULL,
1241 `isBasic` tinyint(1) default NULL,
1242 `genbankFileId` varchar(63) default NULL,
1243 `genomeId` varchar(63) default NULL,
1244 `strainType` varchar(63) default NULL,
1245 `parentStrainId` varchar(63) default NULL,
1246 `riskGroup` smallint(6) default NULL,
1247 `dateCreated` datetime default NULL,
1248 `lastModified` datetime default NULL,
1249 PRIMARY KEY (`idStrain`),
1250 KEY `fk_StrainTable_PersonTable1` (`personId`),
1251 KEY `fk_StrainTable_AttachmentTable1` (`genbankFileId`),
1252 KEY `fk_StrainTable_StrainTable1` (`parentStrainId`),
1253 CONSTRAINT `fk_StrainTable_AttachmentTable1` FOREIGN KEY (`genbankFileId`) REFERENCES `AttachmentTable` (`idAttachment`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1254 CONSTRAINT `fk_StrainTable_PersonTable1` FOREIGN KEY (`personId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1255 CONSTRAINT `fk_StrainTable_StrainTable1` FOREIGN KEY (`parentStrainId`) REFERENCES `StrainTable` (`idStrain`) ON DELETE NO ACTION ON UPDATE NO ACTION
1256) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1257SET character_set_client = @saved_cs_client;
1258
1259--
1260-- Dumping data for table `StrainTable`
1261--
1262
1263LOCK TABLES `StrainTable` WRITE;
1264/*!40000 ALTER TABLE `StrainTable` DISABLE KEYS */;
1265/*!40000 ALTER TABLE `StrainTable` ENABLE KEYS */;
1266UNLOCK TABLES;
1267
1268--
1269-- Table structure for table `TraitFamilyXref`
1270--
1271
1272DROP TABLE IF EXISTS `TraitFamilyXref`;
1273SET @saved_cs_client = @@character_set_client;
1274SET character_set_client = utf8;
1275CREATE TABLE `TraitFamilyXref` (
1276 `traitId` varchar(63) NOT NULL,
1277 `familyId` varchar(63) NOT NULL,
1278 `position` int(11) default NULL,
1279 `dateCreated` datetime default NULL,
1280 `lastModified` datetime default NULL,
1281 PRIMARY KEY (`traitId`,`familyId`),
1282 KEY `fk_TraitFamilyXref_TraitTable1` (`traitId`),
1283 KEY `fk_TraitFamilyXref_FamilyTable1` (`familyId`),
1284 CONSTRAINT `fk_TraitFamilyXref_TraitTable1` FOREIGN KEY (`traitId`) REFERENCES `TraitTable` (`idTrait`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1285 CONSTRAINT `fk_TraitFamilyXref_FamilyTable1` FOREIGN KEY (`familyId`) REFERENCES `FamilyTable` (`idFamily`) ON DELETE NO ACTION ON UPDATE NO ACTION
1286) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1287SET character_set_client = @saved_cs_client;
1288
1289--
1290-- Dumping data for table `TraitFamilyXref`
1291--
1292
1293LOCK TABLES `TraitFamilyXref` WRITE;
1294/*!40000 ALTER TABLE `TraitFamilyXref` DISABLE KEYS */;
1295/*!40000 ALTER TABLE `TraitFamilyXref` ENABLE KEYS */;
1296UNLOCK TABLES;
1297
1298--
1299-- Table structure for table `TraitTable`
1300--
1301
1302DROP TABLE IF EXISTS `TraitTable`;
1303SET @saved_cs_client = @@character_set_client;
1304SET character_set_client = utf8;
1305CREATE TABLE `TraitTable` (
1306 `idTrait` varchar(63) NOT NULL,
1307 `familyId` varchar(63) default NULL,
1308 `position` int(11) default NULL,
1309 `name` char(255) default NULL,
1310 `kind` varchar(63) default NULL,
1311 `type` char(255) default NULL,
1312 `value` char(255) default NULL,
1313 `constraint` text,
1314 `dateCreated` datetime default NULL,
1315 `lastModified` datetime default NULL,
1316 PRIMARY KEY (`idTrait`),
1317 KEY `fk_TraitTable_FamilyTable1` (`familyId`),
1318 CONSTRAINT `fk_TraitTable_FamilyTable1` FOREIGN KEY (`familyId`) REFERENCES `FamilyTable` (`idFamily`) ON DELETE NO ACTION ON UPDATE NO ACTION
1319) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1320SET character_set_client = @saved_cs_client;
1321
1322--
1323-- Dumping data for table `TraitTable`
1324--
1325
1326LOCK TABLES `TraitTable` WRITE;
1327/*!40000 ALTER TABLE `TraitTable` DISABLE KEYS */;
1328/*!40000 ALTER TABLE `TraitTable` ENABLE KEYS */;
1329UNLOCK TABLES;
1330
1331--
1332-- Table structure for table `VectorTable`
1333--
1334
1335DROP TABLE IF EXISTS `VectorTable`;
1336SET @saved_cs_client = @@character_set_client;
1337SET character_set_client = utf8;
1338CREATE TABLE `VectorTable` (
1339 `idVector` varchar(63) NOT NULL,
1340 `formatId` varchar(63) default NULL,
1341 `nucseqId` varchar(63) default NULL,
1342 `description` char(255) default NULL,
1343 `isCircular` tinyint(1) default NULL,
1344 `isGenomic` tinyint(1) default NULL,
1345 `authorId` varchar(63) default NULL,
1346 `name` char(255) default NULL,
1347 `riskGroup` smallint(6) default NULL,
1348 `dateCreated` datetime default NULL,
1349 `lastModified` datetime default NULL,
1350 `hash` varchar(63) default NULL,
1351 PRIMARY KEY (`idVector`),
1352 KEY `fk_VectorTable_FormatTable1` (`formatId`),
1353 KEY `fk_VectorTable_NucseqTable1` (`nucseqId`),
1354 KEY `fk_VectorTable_PersonTable1` (`authorId`),
1355 CONSTRAINT `fk_VectorTable_FormatTable1` FOREIGN KEY (`formatId`) REFERENCES `FormatTable` (`idformat`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1356 CONSTRAINT `fk_VectorTable_NucseqTable1` FOREIGN KEY (`nucseqId`) REFERENCES `NucseqTable` (`idNucseq`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1357 CONSTRAINT `fk_VectorTable_PersonTable1` FOREIGN KEY (`authorId`) REFERENCES `PersonTable` (`idPerson`) ON DELETE NO ACTION ON UPDATE NO ACTION
1358) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1359SET character_set_client = @saved_cs_client;
1360
1361--
1362-- Dumping data for table `VectorTable`
1363--
1364
1365LOCK TABLES `VectorTable` WRITE;
1366/*!40000 ALTER TABLE `VectorTable` DISABLE KEYS */;
1367INSERT 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');
1368/*!40000 ALTER TABLE `VectorTable` ENABLE KEYS */;
1369UNLOCK TABLES;
1370
1371--
1372-- Table structure for table `WikitextTable`
1373--
1374
1375DROP TABLE IF EXISTS `WikitextTable`;
1376SET @saved_cs_client = @@character_set_client;
1377SET character_set_client = utf8;
1378CREATE TABLE `WikitextTable` (
1379 `idWikitext` varchar(63) NOT NULL,
1380 `name` char(255) default NULL,
1381 `text` text,
1382 `dateCreated` datetime default NULL,
1383 `lastModified` datetime default NULL,
1384 PRIMARY KEY (`idWikitext`)
1385) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1386SET character_set_client = @saved_cs_client;
1387
1388--
1389-- Dumping data for table `WikitextTable`
1390--
1391
1392LOCK TABLES `WikitextTable` WRITE;
1393/*!40000 ALTER TABLE `WikitextTable` DISABLE KEYS */;
1394INSERT 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');
1395/*!40000 ALTER TABLE `WikitextTable` ENABLE KEYS */;
1396UNLOCK TABLES;
1397
1398--
1399-- Dumping routines for database 'AndersonLabMain'
1400--
1401DELIMITER ;;
1402DELIMITER ;
1403/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1404
1405/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1406/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1407/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1408/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1409/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1410/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1411/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;