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