1-- MySQL dump 10.11 2-- 3-- Host: localhost Database: test 4-- ------------------------------------------------------ 5-- Server version 5.0.67 6 7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 10/*!40101 SET NAMES utf8 */; 11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; 12/*!40103 SET TIME_ZONE='+00:00' */; 13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; 14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; 15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; 16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; 17 18-- 19-- Table structure for table `Bio_MAGETAB_ArrayDesign` 20-- 21 22DROP TABLE IF EXISTS `Bio_MAGETAB_ArrayDesign`; 23SET @saved_cs_client = @@character_set_client; 24SET character_set_client = utf8; 25CREATE TABLE `Bio_MAGETAB_ArrayDesign` ( 26 `id` int(11) NOT NULL, 27 `provider` varchar(255) default NULL, 28 `substrateType_type` int(11) default NULL, 29 `sequencePolymerType_type` int(11) default NULL, 30 `printingProtocol` text, 31 `version` varchar(255) default NULL, 32 `name` varchar(255) default NULL, 33 `substrateType` int(11) default NULL, 34 `technologyType` int(11) default NULL, 35 `surfaceType` int(11) default NULL, 36 `sequencePolymerType` int(11) default NULL, 37 `uri` varchar(255) default NULL, 38 `surfaceType_type` int(11) default NULL, 39 `technologyType_type` int(11) default NULL, 40 PRIMARY KEY (`id`), 41 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_DatabaseEntry` (`id`) ON DELETE CASCADE, 42 FOREIGN KEY (`substrateType`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`), 43 FOREIGN KEY (`surfaceType`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`), 44 FOREIGN KEY (`technologyType`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`), 45 FOREIGN KEY (`sequencePolymerType`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`) 46) ENGINE=InnoDB DEFAULT CHARSET=latin1; 47SET character_set_client = @saved_cs_client; 48 49-- 50-- Dumping data for table `Bio_MAGETAB_ArrayDesign` 51-- 52 53LOCK TABLES `Bio_MAGETAB_ArrayDesign` WRITE; 54/*!40000 ALTER TABLE `Bio_MAGETAB_ArrayDesign` DISABLE KEYS */; 55/*!40000 ALTER TABLE `Bio_MAGETAB_ArrayDesign` ENABLE KEYS */; 56UNLOCK TABLES; 57 58-- 59-- Table structure for table `Bio_MAGETAB_Assay` 60-- 61 62DROP TABLE IF EXISTS `Bio_MAGETAB_Assay`; 63SET @saved_cs_client = @@character_set_client; 64SET character_set_client = utf8; 65CREATE TABLE `Bio_MAGETAB_Assay` ( 66 `id` int(11) NOT NULL, 67 `arrayDesign_type` int(11) default NULL, 68 `arrayDesign` int(11) default NULL, 69 `technologyType_type` int(11) default NULL, 70 `technologyType` int(11) default NULL, 71 PRIMARY KEY (`id`), 72 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_Event` (`id`) ON DELETE CASCADE, 73 FOREIGN KEY (`technologyType`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`), 74 FOREIGN KEY (`arrayDesign`) REFERENCES `Bio_MAGETAB_ArrayDesign` (`id`) 75) ENGINE=InnoDB DEFAULT CHARSET=latin1; 76SET character_set_client = @saved_cs_client; 77 78-- 79-- Dumping data for table `Bio_MAGETAB_Assay` 80-- 81 82LOCK TABLES `Bio_MAGETAB_Assay` WRITE; 83/*!40000 ALTER TABLE `Bio_MAGETAB_Assay` DISABLE KEYS */; 84/*!40000 ALTER TABLE `Bio_MAGETAB_Assay` ENABLE KEYS */; 85UNLOCK TABLES; 86 87-- 88-- Table structure for table `Bio_MAGETAB_BaseClass` 89-- 90 91DROP TABLE IF EXISTS `Bio_MAGETAB_BaseClass`; 92SET @saved_cs_client = @@character_set_client; 93SET character_set_client = utf8; 94CREATE TABLE `Bio_MAGETAB_BaseClass` ( 95 `id` int(11) NOT NULL, 96 `type` int(11) NOT NULL, 97 `namespace` varchar(255) NOT NULL, 98 `authority` varchar(255) NOT NULL, 99 PRIMARY KEY (`id`), 100 KEY (`type`) 101) ENGINE=InnoDB DEFAULT CHARSET=latin1; 102SET character_set_client = @saved_cs_client; 103 104-- 105-- Dumping data for table `Bio_MAGETAB_BaseClass` 106-- 107 108LOCK TABLES `Bio_MAGETAB_BaseClass` WRITE; 109/*!40000 ALTER TABLE `Bio_MAGETAB_BaseClass` DISABLE KEYS */; 110/*!40000 ALTER TABLE `Bio_MAGETAB_BaseClass` ENABLE KEYS */; 111UNLOCK TABLES; 112 113-- 114-- Table structure for table `Bio_MAGETAB_Comment` 115-- 116 117DROP TABLE IF EXISTS `Bio_MAGETAB_Comment`; 118SET @saved_cs_client = @@character_set_client; 119SET character_set_client = utf8; 120CREATE TABLE `Bio_MAGETAB_Comment` ( 121 `id` int(11) NOT NULL, 122 `Bio_MAGETAB_Node_comments_slot` int(11) default NULL, 123 `Bio_MAGETAB_Investigation_comments_slot` int(11) default NULL, 124 `Bio_MAGETAB_CompositeElement_comments` int(11) default NULL, 125 `Bio_MAGETAB_Node_comments` int(11) default NULL, 126 `Bio_MAGETAB_ParameterValue_comments_slot` int(11) default NULL, 127 `Bio_MAGETAB_Contact_comments` int(11) default NULL, 128 `Bio_MAGETAB_ParameterValue_comments` int(11) default NULL, 129 `value` varchar(255) default NULL, 130 `Bio_MAGETAB_Contact_comments_slot` int(11) default NULL, 131 `name` varchar(255) default NULL, 132 `Bio_MAGETAB_ArrayDesign_comments` int(11) default NULL, 133 `Bio_MAGETAB_ArrayDesign_comments_slot` int(11) default NULL, 134 `Bio_MAGETAB_ProtocolApplication_comments` int(11) default NULL, 135 `Bio_MAGETAB_ProtocolApplication_comments_slot` int(11) default NULL, 136 `Bio_MAGETAB_Investigation_comments` int(11) default NULL, 137 `Bio_MAGETAB_CompositeElement_comments_slot` int(11) default NULL, 138 PRIMARY KEY (`id`), 139 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 140 FOREIGN KEY (`Bio_MAGETAB_Node_comments`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`), 141 FOREIGN KEY (`Bio_MAGETAB_CompositeElement_comments`) REFERENCES `Bio_MAGETAB_CompositeElement` (`id`), 142 FOREIGN KEY (`Bio_MAGETAB_ParameterValue_comments`) REFERENCES `Bio_MAGETAB_ParameterValue` (`id`), 143 FOREIGN KEY (`Bio_MAGETAB_Contact_comments`) REFERENCES `Bio_MAGETAB_Contact` (`id`), 144 FOREIGN KEY (`Bio_MAGETAB_ArrayDesign_comments`) REFERENCES `Bio_MAGETAB_ArrayDesign` (`id`), 145 FOREIGN KEY (`Bio_MAGETAB_ProtocolApplication_comments`) REFERENCES `Bio_MAGETAB_ProtocolApplication` (`id`), 146 FOREIGN KEY (`Bio_MAGETAB_Investigation_comments`) REFERENCES `Bio_MAGETAB_Investigation` (`id`) 147) ENGINE=InnoDB DEFAULT CHARSET=latin1; 148SET character_set_client = @saved_cs_client; 149 150-- 151-- Dumping data for table `Bio_MAGETAB_Comment` 152-- 153 154LOCK TABLES `Bio_MAGETAB_Comment` WRITE; 155/*!40000 ALTER TABLE `Bio_MAGETAB_Comment` DISABLE KEYS */; 156/*!40000 ALTER TABLE `Bio_MAGETAB_Comment` ENABLE KEYS */; 157UNLOCK TABLES; 158 159-- 160-- Table structure for table `Bio_MAGETAB_CompositeElement` 161-- 162 163DROP TABLE IF EXISTS `Bio_MAGETAB_CompositeElement`; 164SET @saved_cs_client = @@character_set_client; 165SET character_set_client = utf8; 166CREATE TABLE `Bio_MAGETAB_CompositeElement` ( 167 `id` int(11) NOT NULL, 168 `name` varchar(255) default NULL, 169 PRIMARY KEY (`id`), 170 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_DesignElement` (`id`) ON DELETE CASCADE 171) ENGINE=InnoDB DEFAULT CHARSET=latin1; 172SET character_set_client = @saved_cs_client; 173 174-- 175-- Dumping data for table `Bio_MAGETAB_CompositeElement` 176-- 177 178LOCK TABLES `Bio_MAGETAB_CompositeElement` WRITE; 179/*!40000 ALTER TABLE `Bio_MAGETAB_CompositeElement` DISABLE KEYS */; 180/*!40000 ALTER TABLE `Bio_MAGETAB_CompositeElement` ENABLE KEYS */; 181UNLOCK TABLES; 182 183-- 184-- Table structure for table `Bio_MAGETAB_CompositeElement_compositeElements` 185-- 186 187DROP TABLE IF EXISTS `Bio_MAGETAB_CompositeElement_compositeElements`; 188SET @saved_cs_client = @@character_set_client; 189SET character_set_client = utf8; 190CREATE TABLE `Bio_MAGETAB_CompositeElement_compositeElements` ( 191 `item` int(11) default NULL, 192 `coll` int(11) default NULL, 193 `slot` int(11) default NULL, 194 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_Reporter` (`id`) ON DELETE CASCADE, 195 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_CompositeElement` (`id`) ON DELETE CASCADE 196) ENGINE=InnoDB DEFAULT CHARSET=latin1; 197SET character_set_client = @saved_cs_client; 198 199-- 200-- Dumping data for table `Bio_MAGETAB_CompositeElement_compositeElements` 201-- 202 203LOCK TABLES `Bio_MAGETAB_CompositeElement_compositeElements` WRITE; 204/*!40000 ALTER TABLE `Bio_MAGETAB_CompositeElement_compositeElements` DISABLE KEYS */; 205/*!40000 ALTER TABLE `Bio_MAGETAB_CompositeElement_compositeElements` ENABLE KEYS */; 206UNLOCK TABLES; 207 208-- 209-- Table structure for table `Bio_MAGETAB_Contact` 210-- 211 212DROP TABLE IF EXISTS `Bio_MAGETAB_Contact`; 213SET @saved_cs_client = @@character_set_client; 214SET character_set_client = utf8; 215CREATE TABLE `Bio_MAGETAB_Contact` ( 216 `id` int(11) NOT NULL, 217 `firstName` varchar(255) default NULL, 218 `midInitials` varchar(255) default NULL, 219 `phone` varchar(255) default NULL, 220 `email` varchar(255) default NULL, 221 `fax` varchar(255) default NULL, 222 `lastName` varchar(255) default NULL, 223 `address` varchar(511) default NULL, 224 `organization` varchar(255) default NULL, 225 PRIMARY KEY (`id`), 226 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE 227) ENGINE=InnoDB DEFAULT CHARSET=latin1; 228SET character_set_client = @saved_cs_client; 229 230-- 231-- Dumping data for table `Bio_MAGETAB_Contact` 232-- 233 234LOCK TABLES `Bio_MAGETAB_Contact` WRITE; 235/*!40000 ALTER TABLE `Bio_MAGETAB_Contact` DISABLE KEYS */; 236/*!40000 ALTER TABLE `Bio_MAGETAB_Contact` ENABLE KEYS */; 237UNLOCK TABLES; 238 239-- 240-- Table structure for table `Bio_MAGETAB_Contact_contacts` 241-- 242 243DROP TABLE IF EXISTS `Bio_MAGETAB_Contact_contacts`; 244SET @saved_cs_client = @@character_set_client; 245SET character_set_client = utf8; 246CREATE TABLE `Bio_MAGETAB_Contact_contacts` ( 247 `item` int(11) default NULL, 248 `coll` int(11) default NULL, 249 `slot` int(11) default NULL, 250 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_Investigation` (`id`) ON DELETE CASCADE, 251 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_Contact` (`id`) ON DELETE CASCADE 252) ENGINE=InnoDB DEFAULT CHARSET=latin1; 253SET character_set_client = @saved_cs_client; 254 255-- 256-- Dumping data for table `Bio_MAGETAB_Contact_contacts` 257-- 258 259LOCK TABLES `Bio_MAGETAB_Contact_contacts` WRITE; 260/*!40000 ALTER TABLE `Bio_MAGETAB_Contact_contacts` DISABLE KEYS */; 261/*!40000 ALTER TABLE `Bio_MAGETAB_Contact_contacts` ENABLE KEYS */; 262UNLOCK TABLES; 263 264-- 265-- Table structure for table `Bio_MAGETAB_Contact_performers` 266-- 267 268DROP TABLE IF EXISTS `Bio_MAGETAB_Contact_performers`; 269SET @saved_cs_client = @@character_set_client; 270SET character_set_client = utf8; 271CREATE TABLE `Bio_MAGETAB_Contact_performers` ( 272 `item` int(11) default NULL, 273 `coll` int(11) default NULL, 274 `slot` int(11) default NULL, 275 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_ProtocolApplication` (`id`) ON DELETE CASCADE, 276 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_Contact` (`id`) ON DELETE CASCADE 277) ENGINE=InnoDB DEFAULT CHARSET=latin1; 278SET character_set_client = @saved_cs_client; 279 280-- 281-- Dumping data for table `Bio_MAGETAB_Contact_performers` 282-- 283 284LOCK TABLES `Bio_MAGETAB_Contact_performers` WRITE; 285/*!40000 ALTER TABLE `Bio_MAGETAB_Contact_performers` DISABLE KEYS */; 286/*!40000 ALTER TABLE `Bio_MAGETAB_Contact_performers` ENABLE KEYS */; 287UNLOCK TABLES; 288 289-- 290-- Table structure for table `Bio_MAGETAB_Contact_providers` 291-- 292 293DROP TABLE IF EXISTS `Bio_MAGETAB_Contact_providers`; 294SET @saved_cs_client = @@character_set_client; 295SET character_set_client = utf8; 296CREATE TABLE `Bio_MAGETAB_Contact_providers` ( 297 `item` int(11) default NULL, 298 `coll` int(11) default NULL, 299 `slot` int(11) default NULL, 300 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_Material` (`id`) ON DELETE CASCADE, 301 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_Contact` (`id`) ON DELETE CASCADE 302) ENGINE=InnoDB DEFAULT CHARSET=latin1; 303SET character_set_client = @saved_cs_client; 304 305-- 306-- Dumping data for table `Bio_MAGETAB_Contact_providers` 307-- 308 309LOCK TABLES `Bio_MAGETAB_Contact_providers` WRITE; 310/*!40000 ALTER TABLE `Bio_MAGETAB_Contact_providers` DISABLE KEYS */; 311/*!40000 ALTER TABLE `Bio_MAGETAB_Contact_providers` ENABLE KEYS */; 312UNLOCK TABLES; 313 314-- 315-- Table structure for table `Bio_MAGETAB_ControlledTerm` 316-- 317 318DROP TABLE IF EXISTS `Bio_MAGETAB_ControlledTerm`; 319SET @saved_cs_client = @@character_set_client; 320SET character_set_client = utf8; 321CREATE TABLE `Bio_MAGETAB_ControlledTerm` ( 322 `id` int(11) NOT NULL, 323 `value` varchar(255) default NULL, 324 `category` varchar(255) default NULL, 325 PRIMARY KEY (`id`), 326 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_DatabaseEntry` (`id`) ON DELETE CASCADE 327) ENGINE=InnoDB DEFAULT CHARSET=latin1; 328SET character_set_client = @saved_cs_client; 329 330-- 331-- Dumping data for table `Bio_MAGETAB_ControlledTerm` 332-- 333 334LOCK TABLES `Bio_MAGETAB_ControlledTerm` WRITE; 335/*!40000 ALTER TABLE `Bio_MAGETAB_ControlledTerm` DISABLE KEYS */; 336/*!40000 ALTER TABLE `Bio_MAGETAB_ControlledTerm` ENABLE KEYS */; 337UNLOCK TABLES; 338 339-- 340-- Table structure for table `Bio_MAGETAB_ControlledTerm_characteristics` 341-- 342 343DROP TABLE IF EXISTS `Bio_MAGETAB_ControlledTerm_characteristics`; 344SET @saved_cs_client = @@character_set_client; 345SET character_set_client = utf8; 346CREATE TABLE `Bio_MAGETAB_ControlledTerm_characteristics` ( 347 `item` int(11) default NULL, 348 `coll` int(11) default NULL, 349 `slot` int(11) default NULL, 350 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_Material` (`id`) ON DELETE CASCADE, 351 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`) ON DELETE CASCADE 352) ENGINE=InnoDB DEFAULT CHARSET=latin1; 353SET character_set_client = @saved_cs_client; 354 355-- 356-- Dumping data for table `Bio_MAGETAB_ControlledTerm_characteristics` 357-- 358 359LOCK TABLES `Bio_MAGETAB_ControlledTerm_characteristics` WRITE; 360/*!40000 ALTER TABLE `Bio_MAGETAB_ControlledTerm_characteristics` DISABLE KEYS */; 361/*!40000 ALTER TABLE `Bio_MAGETAB_ControlledTerm_characteristics` ENABLE KEYS */; 362UNLOCK TABLES; 363 364-- 365-- Table structure for table `Bio_MAGETAB_ControlledTerm_designTypes` 366-- 367 368DROP TABLE IF EXISTS `Bio_MAGETAB_ControlledTerm_designTypes`; 369SET @saved_cs_client = @@character_set_client; 370SET character_set_client = utf8; 371CREATE TABLE `Bio_MAGETAB_ControlledTerm_designTypes` ( 372 `item` int(11) default NULL, 373 `coll` int(11) default NULL, 374 `slot` int(11) default NULL, 375 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_Investigation` (`id`) ON DELETE CASCADE, 376 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`) ON DELETE CASCADE 377) ENGINE=InnoDB DEFAULT CHARSET=latin1; 378SET character_set_client = @saved_cs_client; 379 380-- 381-- Dumping data for table `Bio_MAGETAB_ControlledTerm_designTypes` 382-- 383 384LOCK TABLES `Bio_MAGETAB_ControlledTerm_designTypes` WRITE; 385/*!40000 ALTER TABLE `Bio_MAGETAB_ControlledTerm_designTypes` DISABLE KEYS */; 386/*!40000 ALTER TABLE `Bio_MAGETAB_ControlledTerm_designTypes` ENABLE KEYS */; 387UNLOCK TABLES; 388 389-- 390-- Table structure for table `Bio_MAGETAB_ControlledTerm_groups` 391-- 392 393DROP TABLE IF EXISTS `Bio_MAGETAB_ControlledTerm_groups`; 394SET @saved_cs_client = @@character_set_client; 395SET character_set_client = utf8; 396CREATE TABLE `Bio_MAGETAB_ControlledTerm_groups` ( 397 `item` int(11) default NULL, 398 `coll` int(11) default NULL, 399 `slot` int(11) default NULL, 400 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_Reporter` (`id`) ON DELETE CASCADE, 401 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`) ON DELETE CASCADE 402) ENGINE=InnoDB DEFAULT CHARSET=latin1; 403SET character_set_client = @saved_cs_client; 404 405-- 406-- Dumping data for table `Bio_MAGETAB_ControlledTerm_groups` 407-- 408 409LOCK TABLES `Bio_MAGETAB_ControlledTerm_groups` WRITE; 410/*!40000 ALTER TABLE `Bio_MAGETAB_ControlledTerm_groups` DISABLE KEYS */; 411/*!40000 ALTER TABLE `Bio_MAGETAB_ControlledTerm_groups` ENABLE KEYS */; 412UNLOCK TABLES; 413 414-- 415-- Table structure for table `Bio_MAGETAB_ControlledTerm_normalizationTypes` 416-- 417 418DROP TABLE IF EXISTS `Bio_MAGETAB_ControlledTerm_normalizationTypes`; 419SET @saved_cs_client = @@character_set_client; 420SET character_set_client = utf8; 421CREATE TABLE `Bio_MAGETAB_ControlledTerm_normalizationTypes` ( 422 `item` int(11) default NULL, 423 `coll` int(11) default NULL, 424 `slot` int(11) default NULL, 425 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_Investigation` (`id`) ON DELETE CASCADE, 426 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`) ON DELETE CASCADE 427) ENGINE=InnoDB DEFAULT CHARSET=latin1; 428SET character_set_client = @saved_cs_client; 429 430-- 431-- Dumping data for table `Bio_MAGETAB_ControlledTerm_normalizationTypes` 432-- 433 434LOCK TABLES `Bio_MAGETAB_ControlledTerm_normalizationTypes` WRITE; 435/*!40000 ALTER TABLE `Bio_MAGETAB_ControlledTerm_normalizationTypes` DISABLE KEYS */; 436/*!40000 ALTER TABLE `Bio_MAGETAB_ControlledTerm_normalizationTypes` ENABLE KEYS */; 437UNLOCK TABLES; 438 439-- 440-- Table structure for table `Bio_MAGETAB_ControlledTerm_qualityControlTypes` 441-- 442 443DROP TABLE IF EXISTS `Bio_MAGETAB_ControlledTerm_qualityControlTypes`; 444SET @saved_cs_client = @@character_set_client; 445SET character_set_client = utf8; 446CREATE TABLE `Bio_MAGETAB_ControlledTerm_qualityControlTypes` ( 447 `item` int(11) default NULL, 448 `coll` int(11) default NULL, 449 `slot` int(11) default NULL, 450 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_Investigation` (`id`) ON DELETE CASCADE, 451 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`) ON DELETE CASCADE 452) ENGINE=InnoDB DEFAULT CHARSET=latin1; 453SET character_set_client = @saved_cs_client; 454 455-- 456-- Dumping data for table `Bio_MAGETAB_ControlledTerm_qualityControlTypes` 457-- 458 459LOCK TABLES `Bio_MAGETAB_ControlledTerm_qualityControlTypes` WRITE; 460/*!40000 ALTER TABLE `Bio_MAGETAB_ControlledTerm_qualityControlTypes` DISABLE KEYS */; 461/*!40000 ALTER TABLE `Bio_MAGETAB_ControlledTerm_qualityControlTypes` ENABLE KEYS */; 462UNLOCK TABLES; 463 464-- 465-- Table structure for table `Bio_MAGETAB_ControlledTerm_replicateTypes` 466-- 467 468DROP TABLE IF EXISTS `Bio_MAGETAB_ControlledTerm_replicateTypes`; 469SET @saved_cs_client = @@character_set_client; 470SET character_set_client = utf8; 471CREATE TABLE `Bio_MAGETAB_ControlledTerm_replicateTypes` ( 472 `item` int(11) default NULL, 473 `coll` int(11) default NULL, 474 `slot` int(11) default NULL, 475 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_Investigation` (`id`) ON DELETE CASCADE, 476 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`) ON DELETE CASCADE 477) ENGINE=InnoDB DEFAULT CHARSET=latin1; 478SET character_set_client = @saved_cs_client; 479 480-- 481-- Dumping data for table `Bio_MAGETAB_ControlledTerm_replicateTypes` 482-- 483 484LOCK TABLES `Bio_MAGETAB_ControlledTerm_replicateTypes` WRITE; 485/*!40000 ALTER TABLE `Bio_MAGETAB_ControlledTerm_replicateTypes` DISABLE KEYS */; 486/*!40000 ALTER TABLE `Bio_MAGETAB_ControlledTerm_replicateTypes` ENABLE KEYS */; 487UNLOCK TABLES; 488 489-- 490-- Table structure for table `Bio_MAGETAB_ControlledTerm_roles` 491-- 492 493DROP TABLE IF EXISTS `Bio_MAGETAB_ControlledTerm_roles`; 494SET @saved_cs_client = @@character_set_client; 495SET character_set_client = utf8; 496CREATE TABLE `Bio_MAGETAB_ControlledTerm_roles` ( 497 `item` int(11) default NULL, 498 `coll` int(11) default NULL, 499 `slot` int(11) default NULL, 500 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_Contact` (`id`) ON DELETE CASCADE, 501 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`) ON DELETE CASCADE 502) ENGINE=InnoDB DEFAULT CHARSET=latin1; 503SET character_set_client = @saved_cs_client; 504 505-- 506-- Dumping data for table `Bio_MAGETAB_ControlledTerm_roles` 507-- 508 509LOCK TABLES `Bio_MAGETAB_ControlledTerm_roles` WRITE; 510/*!40000 ALTER TABLE `Bio_MAGETAB_ControlledTerm_roles` DISABLE KEYS */; 511/*!40000 ALTER TABLE `Bio_MAGETAB_ControlledTerm_roles` ENABLE KEYS */; 512UNLOCK TABLES; 513 514-- 515-- Table structure for table `Bio_MAGETAB_Data` 516-- 517 518DROP TABLE IF EXISTS `Bio_MAGETAB_Data`; 519SET @saved_cs_client = @@character_set_client; 520SET character_set_client = utf8; 521CREATE TABLE `Bio_MAGETAB_Data` ( 522 `id` int(11) NOT NULL, 523 `dataType` int(11) default NULL, 524 `dataType_type` int(11) default NULL, 525 `uri` varchar(255) default NULL, 526 PRIMARY KEY (`id`), 527 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 528 FOREIGN KEY (`dataType`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`) 529) ENGINE=InnoDB DEFAULT CHARSET=latin1; 530SET character_set_client = @saved_cs_client; 531 532-- 533-- Dumping data for table `Bio_MAGETAB_Data` 534-- 535 536LOCK TABLES `Bio_MAGETAB_Data` WRITE; 537/*!40000 ALTER TABLE `Bio_MAGETAB_Data` DISABLE KEYS */; 538/*!40000 ALTER TABLE `Bio_MAGETAB_Data` ENABLE KEYS */; 539UNLOCK TABLES; 540 541-- 542-- Table structure for table `Bio_MAGETAB_DataFile` 543-- 544 545DROP TABLE IF EXISTS `Bio_MAGETAB_DataFile`; 546SET @saved_cs_client = @@character_set_client; 547SET character_set_client = utf8; 548CREATE TABLE `Bio_MAGETAB_DataFile` ( 549 `id` int(11) NOT NULL, 550 `format` int(11) default NULL, 551 `format_type` int(11) default NULL, 552 PRIMARY KEY (`id`), 553 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_Data` (`id`) ON DELETE CASCADE, 554 FOREIGN KEY (`format`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`) 555) ENGINE=InnoDB DEFAULT CHARSET=latin1; 556SET character_set_client = @saved_cs_client; 557 558-- 559-- Dumping data for table `Bio_MAGETAB_DataFile` 560-- 561 562LOCK TABLES `Bio_MAGETAB_DataFile` WRITE; 563/*!40000 ALTER TABLE `Bio_MAGETAB_DataFile` DISABLE KEYS */; 564/*!40000 ALTER TABLE `Bio_MAGETAB_DataFile` ENABLE KEYS */; 565UNLOCK TABLES; 566 567-- 568-- Table structure for table `Bio_MAGETAB_DataMatrix` 569-- 570 571DROP TABLE IF EXISTS `Bio_MAGETAB_DataMatrix`; 572SET @saved_cs_client = @@character_set_client; 573SET character_set_client = utf8; 574CREATE TABLE `Bio_MAGETAB_DataMatrix` ( 575 `id` int(11) NOT NULL, 576 `rowIdentifierType` varchar(255) default NULL, 577 PRIMARY KEY (`id`), 578 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_Data` (`id`) ON DELETE CASCADE 579) ENGINE=InnoDB DEFAULT CHARSET=latin1; 580SET character_set_client = @saved_cs_client; 581 582-- 583-- Dumping data for table `Bio_MAGETAB_DataMatrix` 584-- 585 586LOCK TABLES `Bio_MAGETAB_DataMatrix` WRITE; 587/*!40000 ALTER TABLE `Bio_MAGETAB_DataMatrix` DISABLE KEYS */; 588/*!40000 ALTER TABLE `Bio_MAGETAB_DataMatrix` ENABLE KEYS */; 589UNLOCK TABLES; 590 591-- 592-- Table structure for table `Bio_MAGETAB_DatabaseEntry` 593-- 594 595DROP TABLE IF EXISTS `Bio_MAGETAB_DatabaseEntry`; 596SET @saved_cs_client = @@character_set_client; 597SET character_set_client = utf8; 598CREATE TABLE `Bio_MAGETAB_DatabaseEntry` ( 599 `id` int(11) NOT NULL, 600 `termSource_type` int(11) default NULL, 601 `termSource` int(11) default NULL, 602 `accession` varchar(255) default NULL, 603 PRIMARY KEY (`id`), 604 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 605 FOREIGN KEY (`termSource`) REFERENCES `Bio_MAGETAB_TermSource` (`id`) 606) ENGINE=InnoDB DEFAULT CHARSET=latin1; 607SET character_set_client = @saved_cs_client; 608 609-- 610-- Dumping data for table `Bio_MAGETAB_DatabaseEntry` 611-- 612 613LOCK TABLES `Bio_MAGETAB_DatabaseEntry` WRITE; 614/*!40000 ALTER TABLE `Bio_MAGETAB_DatabaseEntry` DISABLE KEYS */; 615/*!40000 ALTER TABLE `Bio_MAGETAB_DatabaseEntry` ENABLE KEYS */; 616UNLOCK TABLES; 617 618-- 619-- Table structure for table `Bio_MAGETAB_DatabaseEntry_databaseEntries` 620-- 621 622DROP TABLE IF EXISTS `Bio_MAGETAB_DatabaseEntry_databaseEntries`; 623SET @saved_cs_client = @@character_set_client; 624SET character_set_client = utf8; 625CREATE TABLE `Bio_MAGETAB_DatabaseEntry_databaseEntries` ( 626 `item` int(11) default NULL, 627 `coll` int(11) default NULL, 628 `slot` int(11) default NULL, 629 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_DesignElement` (`id`) ON DELETE CASCADE, 630 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_DatabaseEntry` (`id`) ON DELETE CASCADE 631) ENGINE=InnoDB DEFAULT CHARSET=latin1; 632SET character_set_client = @saved_cs_client; 633 634-- 635-- Dumping data for table `Bio_MAGETAB_DatabaseEntry_databaseEntries` 636-- 637 638LOCK TABLES `Bio_MAGETAB_DatabaseEntry_databaseEntries` WRITE; 639/*!40000 ALTER TABLE `Bio_MAGETAB_DatabaseEntry_databaseEntries` DISABLE KEYS */; 640/*!40000 ALTER TABLE `Bio_MAGETAB_DatabaseEntry_databaseEntries` ENABLE KEYS */; 641UNLOCK TABLES; 642 643-- 644-- Table structure for table `Bio_MAGETAB_DesignElement` 645-- 646 647DROP TABLE IF EXISTS `Bio_MAGETAB_DesignElement`; 648SET @saved_cs_client = @@character_set_client; 649SET character_set_client = utf8; 650CREATE TABLE `Bio_MAGETAB_DesignElement` ( 651 `id` int(11) NOT NULL, 652 `startPosition` int(11) default NULL, 653 `chromosome` varchar(255) default NULL, 654 `endPosition` int(11) default NULL, 655 PRIMARY KEY (`id`), 656 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE 657) ENGINE=InnoDB DEFAULT CHARSET=latin1; 658SET character_set_client = @saved_cs_client; 659 660-- 661-- Dumping data for table `Bio_MAGETAB_DesignElement` 662-- 663 664LOCK TABLES `Bio_MAGETAB_DesignElement` WRITE; 665/*!40000 ALTER TABLE `Bio_MAGETAB_DesignElement` DISABLE KEYS */; 666/*!40000 ALTER TABLE `Bio_MAGETAB_DesignElement` ENABLE KEYS */; 667UNLOCK TABLES; 668 669-- 670-- Table structure for table `Bio_MAGETAB_DesignElement_designElements` 671-- 672 673DROP TABLE IF EXISTS `Bio_MAGETAB_DesignElement_designElements`; 674SET @saved_cs_client = @@character_set_client; 675SET character_set_client = utf8; 676CREATE TABLE `Bio_MAGETAB_DesignElement_designElements` ( 677 `item` int(11) default NULL, 678 `coll` int(11) default NULL, 679 `slot` int(11) default NULL, 680 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_ArrayDesign` (`id`) ON DELETE CASCADE, 681 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_DesignElement` (`id`) ON DELETE CASCADE 682) ENGINE=InnoDB DEFAULT CHARSET=latin1; 683SET character_set_client = @saved_cs_client; 684 685-- 686-- Dumping data for table `Bio_MAGETAB_DesignElement_designElements` 687-- 688 689LOCK TABLES `Bio_MAGETAB_DesignElement_designElements` WRITE; 690/*!40000 ALTER TABLE `Bio_MAGETAB_DesignElement_designElements` DISABLE KEYS */; 691/*!40000 ALTER TABLE `Bio_MAGETAB_DesignElement_designElements` ENABLE KEYS */; 692UNLOCK TABLES; 693 694-- 695-- Table structure for table `Bio_MAGETAB_Edge` 696-- 697 698DROP TABLE IF EXISTS `Bio_MAGETAB_Edge`; 699SET @saved_cs_client = @@character_set_client; 700SET character_set_client = utf8; 701CREATE TABLE `Bio_MAGETAB_Edge` ( 702 `id` int(11) NOT NULL, 703 `Bio_MAGETAB_Node_outputEdges` int(11) default NULL, 704 `inputNode` int(11) default NULL, 705 `Bio_MAGETAB_Node_inputEdges_slot` int(11) default NULL, 706 `Bio_MAGETAB_Node_inputEdges` int(11) default NULL, 707 `Bio_MAGETAB_Node_outputEdges_slot` int(11) default NULL, 708 `inputNode_type` int(11) default NULL, 709 `outputNode` int(11) default NULL, 710 `outputNode_type` int(11) default NULL, 711 PRIMARY KEY (`id`), 712 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 713 FOREIGN KEY (`Bio_MAGETAB_Node_outputEdges`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 714 FOREIGN KEY (`Bio_MAGETAB_Node_inputEdges`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 715 FOREIGN KEY (`outputNode`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 716 FOREIGN KEY (`inputNode`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE 717) ENGINE=InnoDB DEFAULT CHARSET=latin1; 718SET character_set_client = @saved_cs_client; 719 720-- 721-- Dumping data for table `Bio_MAGETAB_Edge` 722-- 723 724LOCK TABLES `Bio_MAGETAB_Edge` WRITE; 725/*!40000 ALTER TABLE `Bio_MAGETAB_Edge` DISABLE KEYS */; 726/*!40000 ALTER TABLE `Bio_MAGETAB_Edge` ENABLE KEYS */; 727UNLOCK TABLES; 728 729-- 730-- Table structure for table `Bio_MAGETAB_Event` 731-- 732 733DROP TABLE IF EXISTS `Bio_MAGETAB_Event`; 734SET @saved_cs_client = @@character_set_client; 735SET character_set_client = utf8; 736CREATE TABLE `Bio_MAGETAB_Event` ( 737 `id` int(11) NOT NULL, 738 `name` varchar(255) default NULL, 739 PRIMARY KEY (`id`), 740 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE 741) ENGINE=InnoDB DEFAULT CHARSET=latin1; 742SET character_set_client = @saved_cs_client; 743 744-- 745-- Dumping data for table `Bio_MAGETAB_Event` 746-- 747 748LOCK TABLES `Bio_MAGETAB_Event` WRITE; 749/*!40000 ALTER TABLE `Bio_MAGETAB_Event` DISABLE KEYS */; 750/*!40000 ALTER TABLE `Bio_MAGETAB_Event` ENABLE KEYS */; 751UNLOCK TABLES; 752 753-- 754-- Table structure for table `Bio_MAGETAB_Factor` 755-- 756 757DROP TABLE IF EXISTS `Bio_MAGETAB_Factor`; 758SET @saved_cs_client = @@character_set_client; 759SET character_set_client = utf8; 760CREATE TABLE `Bio_MAGETAB_Factor` ( 761 `id` int(11) NOT NULL, 762 `factorType_type` int(11) default NULL, 763 `factorType` int(11) default NULL, 764 `Bio_MAGETAB_Investigation_factors` int(11) default NULL, 765 `name` varchar(255) default NULL, 766 `Bio_MAGETAB_Investigation_factors_slot` int(11) default NULL, 767 PRIMARY KEY (`id`), 768 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 769 FOREIGN KEY (`factorType`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`), 770 FOREIGN KEY (`Bio_MAGETAB_Investigation_factors`) REFERENCES `Bio_MAGETAB_Investigation` (`id`) 771) ENGINE=InnoDB DEFAULT CHARSET=latin1; 772SET character_set_client = @saved_cs_client; 773 774-- 775-- Dumping data for table `Bio_MAGETAB_Factor` 776-- 777 778LOCK TABLES `Bio_MAGETAB_Factor` WRITE; 779/*!40000 ALTER TABLE `Bio_MAGETAB_Factor` DISABLE KEYS */; 780/*!40000 ALTER TABLE `Bio_MAGETAB_Factor` ENABLE KEYS */; 781UNLOCK TABLES; 782 783-- 784-- Table structure for table `Bio_MAGETAB_FactorValue` 785-- 786 787DROP TABLE IF EXISTS `Bio_MAGETAB_FactorValue`; 788SET @saved_cs_client = @@character_set_client; 789SET character_set_client = utf8; 790CREATE TABLE `Bio_MAGETAB_FactorValue` ( 791 `id` int(11) NOT NULL, 792 `term_type` int(11) default NULL, 793 `factor_type` int(11) default NULL, 794 `measurement` int(11) default NULL, 795 `measurement_type` int(11) default NULL, 796 `term` int(11) default NULL, 797 `factor` int(11) default NULL, 798 PRIMARY KEY (`id`), 799 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 800 FOREIGN KEY (`term`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`), 801 FOREIGN KEY (`measurement`) REFERENCES `Bio_MAGETAB_Measurement` (`id`), 802 FOREIGN KEY (`factor`) REFERENCES `Bio_MAGETAB_Factor` (`id`) 803) ENGINE=InnoDB DEFAULT CHARSET=latin1; 804SET character_set_client = @saved_cs_client; 805 806-- 807-- Dumping data for table `Bio_MAGETAB_FactorValue` 808-- 809 810LOCK TABLES `Bio_MAGETAB_FactorValue` WRITE; 811/*!40000 ALTER TABLE `Bio_MAGETAB_FactorValue` DISABLE KEYS */; 812/*!40000 ALTER TABLE `Bio_MAGETAB_FactorValue` ENABLE KEYS */; 813UNLOCK TABLES; 814 815-- 816-- Table structure for table `Bio_MAGETAB_FactorValue_factorValues` 817-- 818 819DROP TABLE IF EXISTS `Bio_MAGETAB_FactorValue_factorValues`; 820SET @saved_cs_client = @@character_set_client; 821SET character_set_client = utf8; 822CREATE TABLE `Bio_MAGETAB_FactorValue_factorValues` ( 823 `item` int(11) default NULL, 824 `coll` int(11) default NULL, 825 `slot` int(11) default NULL, 826 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_SDRFRow` (`id`) ON DELETE CASCADE, 827 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_FactorValue` (`id`) ON DELETE CASCADE 828) ENGINE=InnoDB DEFAULT CHARSET=latin1; 829SET character_set_client = @saved_cs_client; 830 831-- 832-- Dumping data for table `Bio_MAGETAB_FactorValue_factorValues` 833-- 834 835LOCK TABLES `Bio_MAGETAB_FactorValue_factorValues` WRITE; 836/*!40000 ALTER TABLE `Bio_MAGETAB_FactorValue_factorValues` DISABLE KEYS */; 837/*!40000 ALTER TABLE `Bio_MAGETAB_FactorValue_factorValues` ENABLE KEYS */; 838UNLOCK TABLES; 839 840-- 841-- Table structure for table `Bio_MAGETAB_Feature` 842-- 843 844DROP TABLE IF EXISTS `Bio_MAGETAB_Feature`; 845SET @saved_cs_client = @@character_set_client; 846SET character_set_client = utf8; 847CREATE TABLE `Bio_MAGETAB_Feature` ( 848 `id` int(11) NOT NULL, 849 `reporter_type` int(11) default NULL, 850 `blockCol` int(11) default NULL, 851 `blockRow` int(11) default NULL, 852 `col` int(11) default NULL, 853 `row` int(11) default NULL, 854 `reporter` int(11) default NULL, 855 PRIMARY KEY (`id`), 856 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_DesignElement` (`id`) ON DELETE CASCADE, 857 FOREIGN KEY (`reporter`) REFERENCES `Bio_MAGETAB_Reporter` (`id`) 858) ENGINE=InnoDB DEFAULT CHARSET=latin1; 859SET character_set_client = @saved_cs_client; 860 861-- 862-- Dumping data for table `Bio_MAGETAB_Feature` 863-- 864 865LOCK TABLES `Bio_MAGETAB_Feature` WRITE; 866/*!40000 ALTER TABLE `Bio_MAGETAB_Feature` DISABLE KEYS */; 867/*!40000 ALTER TABLE `Bio_MAGETAB_Feature` ENABLE KEYS */; 868UNLOCK TABLES; 869 870-- 871-- Table structure for table `Bio_MAGETAB_Investigation` 872-- 873 874DROP TABLE IF EXISTS `Bio_MAGETAB_Investigation`; 875SET @saved_cs_client = @@character_set_client; 876SET character_set_client = utf8; 877CREATE TABLE `Bio_MAGETAB_Investigation` ( 878 `id` int(11) NOT NULL, 879 `publicReleaseDate` varchar(255) default NULL, 880 `date` varchar(255) default NULL, 881 `title` varchar(255) default NULL, 882 `description` text, 883 PRIMARY KEY (`id`), 884 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE 885) ENGINE=InnoDB DEFAULT CHARSET=latin1; 886SET character_set_client = @saved_cs_client; 887 888-- 889-- Dumping data for table `Bio_MAGETAB_Investigation` 890-- 891 892LOCK TABLES `Bio_MAGETAB_Investigation` WRITE; 893/*!40000 ALTER TABLE `Bio_MAGETAB_Investigation` DISABLE KEYS */; 894/*!40000 ALTER TABLE `Bio_MAGETAB_Investigation` ENABLE KEYS */; 895UNLOCK TABLES; 896 897-- 898-- Table structure for table `Bio_MAGETAB_LabeledExtract` 899-- 900 901DROP TABLE IF EXISTS `Bio_MAGETAB_LabeledExtract`; 902SET @saved_cs_client = @@character_set_client; 903SET character_set_client = utf8; 904CREATE TABLE `Bio_MAGETAB_LabeledExtract` ( 905 `id` int(11) NOT NULL, 906 `label_type` int(11) default NULL, 907 `label` int(11) default NULL, 908 PRIMARY KEY (`id`), 909 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_Material` (`id`) ON DELETE CASCADE, 910 FOREIGN KEY (`label`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`) 911) ENGINE=InnoDB DEFAULT CHARSET=latin1; 912SET character_set_client = @saved_cs_client; 913 914-- 915-- Dumping data for table `Bio_MAGETAB_LabeledExtract` 916-- 917 918LOCK TABLES `Bio_MAGETAB_LabeledExtract` WRITE; 919/*!40000 ALTER TABLE `Bio_MAGETAB_LabeledExtract` DISABLE KEYS */; 920/*!40000 ALTER TABLE `Bio_MAGETAB_LabeledExtract` ENABLE KEYS */; 921UNLOCK TABLES; 922 923-- 924-- Table structure for table `Bio_MAGETAB_Material` 925-- 926 927DROP TABLE IF EXISTS `Bio_MAGETAB_Material`; 928SET @saved_cs_client = @@character_set_client; 929SET character_set_client = utf8; 930CREATE TABLE `Bio_MAGETAB_Material` ( 931 `id` int(11) NOT NULL, 932 `materialType_type` int(11) default NULL, 933 `name` varchar(255) default NULL, 934 `description` varchar(255) default NULL, 935 `materialType` int(11) default NULL, 936 PRIMARY KEY (`id`), 937 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 938 FOREIGN KEY (`materialType`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`) 939) ENGINE=InnoDB DEFAULT CHARSET=latin1; 940SET character_set_client = @saved_cs_client; 941 942-- 943-- Dumping data for table `Bio_MAGETAB_Material` 944-- 945 946LOCK TABLES `Bio_MAGETAB_Material` WRITE; 947/*!40000 ALTER TABLE `Bio_MAGETAB_Material` DISABLE KEYS */; 948/*!40000 ALTER TABLE `Bio_MAGETAB_Material` ENABLE KEYS */; 949UNLOCK TABLES; 950 951-- 952-- Table structure for table `Bio_MAGETAB_MatrixColumn` 953-- 954 955DROP TABLE IF EXISTS `Bio_MAGETAB_MatrixColumn`; 956SET @saved_cs_client = @@character_set_client; 957SET character_set_client = utf8; 958CREATE TABLE `Bio_MAGETAB_MatrixColumn` ( 959 `id` int(11) NOT NULL, 960 `quantitationType_type` int(11) default NULL, 961 `quantitationType` int(11) default NULL, 962 `Bio_MAGETAB_DataMatrix_matrixColumns_slot` int(11) default NULL, 963 `Bio_MAGETAB_DataMatrix_matrixColumns` int(11) default NULL, 964 `columnNumber` int(11) default NULL, 965 PRIMARY KEY (`id`), 966 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 967 FOREIGN KEY (`quantitationType`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`), 968 FOREIGN KEY (`Bio_MAGETAB_DataMatrix_matrixColumns`) REFERENCES `Bio_MAGETAB_DataMatrix` (`id`) 969) ENGINE=InnoDB DEFAULT CHARSET=latin1; 970SET character_set_client = @saved_cs_client; 971 972-- 973-- Dumping data for table `Bio_MAGETAB_MatrixColumn` 974-- 975 976LOCK TABLES `Bio_MAGETAB_MatrixColumn` WRITE; 977/*!40000 ALTER TABLE `Bio_MAGETAB_MatrixColumn` DISABLE KEYS */; 978/*!40000 ALTER TABLE `Bio_MAGETAB_MatrixColumn` ENABLE KEYS */; 979UNLOCK TABLES; 980 981-- 982-- Table structure for table `Bio_MAGETAB_MatrixRow` 983-- 984 985DROP TABLE IF EXISTS `Bio_MAGETAB_MatrixRow`; 986SET @saved_cs_client = @@character_set_client; 987SET character_set_client = utf8; 988CREATE TABLE `Bio_MAGETAB_MatrixRow` ( 989 `id` int(11) NOT NULL, 990 `Bio_MAGETAB_DataMatrix_matrixRows` int(11) default NULL, 991 `rowNumber` int(11) default NULL, 992 `designElement_type` int(11) default NULL, 993 `Bio_MAGETAB_DataMatrix_matrixRows_slot` int(11) default NULL, 994 `designElement` int(11) default NULL, 995 PRIMARY KEY (`id`), 996 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 997 FOREIGN KEY (`designElement`) REFERENCES `Bio_MAGETAB_DesignElement` (`id`), 998 FOREIGN KEY (`Bio_MAGETAB_DataMatrix_matrixRows`) REFERENCES `Bio_MAGETAB_DataMatrix` (`id`) 999) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1000SET character_set_client = @saved_cs_client; 1001 1002-- 1003-- Dumping data for table `Bio_MAGETAB_MatrixRow` 1004-- 1005 1006LOCK TABLES `Bio_MAGETAB_MatrixRow` WRITE; 1007/*!40000 ALTER TABLE `Bio_MAGETAB_MatrixRow` DISABLE KEYS */; 1008/*!40000 ALTER TABLE `Bio_MAGETAB_MatrixRow` ENABLE KEYS */; 1009UNLOCK TABLES; 1010 1011-- 1012-- Table structure for table `Bio_MAGETAB_Measurement` 1013-- 1014 1015DROP TABLE IF EXISTS `Bio_MAGETAB_Measurement`; 1016SET @saved_cs_client = @@character_set_client; 1017SET character_set_client = utf8; 1018CREATE TABLE `Bio_MAGETAB_Measurement` ( 1019 `id` int(11) NOT NULL, 1020 `Bio_MAGETAB_Material_measurements_slot` int(11) default NULL, 1021 `value` varchar(255) default NULL, 1022 `maxValue` varchar(255) default NULL, 1023 `unit_type` int(11) default NULL, 1024 `unit` int(11) default NULL, 1025 `minValue` varchar(255) default NULL, 1026 `measurementType` varchar(255) default NULL, 1027 `Bio_MAGETAB_Material_measurements` int(11) default NULL, 1028 PRIMARY KEY (`id`), 1029 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 1030 FOREIGN KEY (`unit`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`), 1031 FOREIGN KEY (`Bio_MAGETAB_Material_measurements`) REFERENCES `Bio_MAGETAB_Material` (`id`) 1032) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1033SET character_set_client = @saved_cs_client; 1034 1035-- 1036-- Dumping data for table `Bio_MAGETAB_Measurement` 1037-- 1038 1039LOCK TABLES `Bio_MAGETAB_Measurement` WRITE; 1040/*!40000 ALTER TABLE `Bio_MAGETAB_Measurement` DISABLE KEYS */; 1041/*!40000 ALTER TABLE `Bio_MAGETAB_Measurement` ENABLE KEYS */; 1042UNLOCK TABLES; 1043 1044-- 1045-- Table structure for table `Bio_MAGETAB_Node_nodes` 1046-- 1047 1048DROP TABLE IF EXISTS `Bio_MAGETAB_Node_nodes`; 1049SET @saved_cs_client = @@character_set_client; 1050SET character_set_client = utf8; 1051CREATE TABLE `Bio_MAGETAB_Node_nodes` ( 1052 `item` int(11) default NULL, 1053 `coll` int(11) default NULL, 1054 `slot` int(11) default NULL, 1055 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_SDRFRow` (`id`) ON DELETE CASCADE, 1056 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE 1057) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1058SET character_set_client = @saved_cs_client; 1059 1060-- 1061-- Dumping data for table `Bio_MAGETAB_Node_nodes` 1062-- 1063 1064LOCK TABLES `Bio_MAGETAB_Node_nodes` WRITE; 1065/*!40000 ALTER TABLE `Bio_MAGETAB_Node_nodes` DISABLE KEYS */; 1066/*!40000 ALTER TABLE `Bio_MAGETAB_Node_nodes` ENABLE KEYS */; 1067UNLOCK TABLES; 1068 1069-- 1070-- Table structure for table `Bio_MAGETAB_Node_referencedNodes` 1071-- 1072 1073DROP TABLE IF EXISTS `Bio_MAGETAB_Node_referencedNodes`; 1074SET @saved_cs_client = @@character_set_client; 1075SET character_set_client = utf8; 1076CREATE TABLE `Bio_MAGETAB_Node_referencedNodes` ( 1077 `item` int(11) default NULL, 1078 `coll` int(11) default NULL, 1079 `slot` int(11) default NULL, 1080 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_MatrixColumn` (`id`) ON DELETE CASCADE, 1081 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE 1082) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1083SET character_set_client = @saved_cs_client; 1084 1085-- 1086-- Dumping data for table `Bio_MAGETAB_Node_referencedNodes` 1087-- 1088 1089LOCK TABLES `Bio_MAGETAB_Node_referencedNodes` WRITE; 1090/*!40000 ALTER TABLE `Bio_MAGETAB_Node_referencedNodes` DISABLE KEYS */; 1091/*!40000 ALTER TABLE `Bio_MAGETAB_Node_referencedNodes` ENABLE KEYS */; 1092UNLOCK TABLES; 1093 1094-- 1095-- Table structure for table `Bio_MAGETAB_ParameterValue` 1096-- 1097 1098DROP TABLE IF EXISTS `Bio_MAGETAB_ParameterValue`; 1099SET @saved_cs_client = @@character_set_client; 1100SET character_set_client = utf8; 1101CREATE TABLE `Bio_MAGETAB_ParameterValue` ( 1102 `id` int(11) NOT NULL, 1103 `parameter` int(11) default NULL, 1104 `parameter_type` int(11) default NULL, 1105 `measurement` int(11) default NULL, 1106 `measurement_type` int(11) default NULL, 1107 `Bio_MAGETAB_ProtocolApplication_parameterValues_slot` int(11) default NULL, 1108 `Bio_MAGETAB_ProtocolApplication_parameterValues` int(11) default NULL, 1109 PRIMARY KEY (`id`), 1110 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 1111 FOREIGN KEY (`parameter`) REFERENCES `Bio_MAGETAB_ProtocolParameter` (`id`), 1112 FOREIGN KEY (`measurement`) REFERENCES `Bio_MAGETAB_Measurement` (`id`), 1113 FOREIGN KEY (`Bio_MAGETAB_ProtocolApplication_parameterValues`) REFERENCES `Bio_MAGETAB_ProtocolApplication` (`id`) 1114) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1115SET character_set_client = @saved_cs_client; 1116 1117-- 1118-- Dumping data for table `Bio_MAGETAB_ParameterValue` 1119-- 1120 1121LOCK TABLES `Bio_MAGETAB_ParameterValue` WRITE; 1122/*!40000 ALTER TABLE `Bio_MAGETAB_ParameterValue` DISABLE KEYS */; 1123/*!40000 ALTER TABLE `Bio_MAGETAB_ParameterValue` ENABLE KEYS */; 1124UNLOCK TABLES; 1125 1126-- 1127-- Table structure for table `Bio_MAGETAB_Protocol` 1128-- 1129 1130DROP TABLE IF EXISTS `Bio_MAGETAB_Protocol`; 1131SET @saved_cs_client = @@character_set_client; 1132SET character_set_client = utf8; 1133CREATE TABLE `Bio_MAGETAB_Protocol` ( 1134 `id` int(11) NOT NULL, 1135 `name` varchar(255) default NULL, 1136 `contact` varchar(255) default NULL, 1137 `software` varchar(255) default NULL, 1138 `hardware` varchar(255) default NULL, 1139 `text` text, 1140 `protocolType` int(11) default NULL, 1141 `protocolType_type` int(11) default NULL, 1142 PRIMARY KEY (`id`), 1143 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_DatabaseEntry` (`id`) ON DELETE CASCADE, 1144 FOREIGN KEY (`protocolType`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`) 1145) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1146SET character_set_client = @saved_cs_client; 1147 1148-- 1149-- Dumping data for table `Bio_MAGETAB_Protocol` 1150-- 1151 1152LOCK TABLES `Bio_MAGETAB_Protocol` WRITE; 1153/*!40000 ALTER TABLE `Bio_MAGETAB_Protocol` DISABLE KEYS */; 1154/*!40000 ALTER TABLE `Bio_MAGETAB_Protocol` ENABLE KEYS */; 1155UNLOCK TABLES; 1156 1157-- 1158-- Table structure for table `Bio_MAGETAB_ProtocolApplication` 1159-- 1160 1161DROP TABLE IF EXISTS `Bio_MAGETAB_ProtocolApplication`; 1162SET @saved_cs_client = @@character_set_client; 1163SET character_set_client = utf8; 1164CREATE TABLE `Bio_MAGETAB_ProtocolApplication` ( 1165 `id` int(11) NOT NULL, 1166 `protocol` int(11) default NULL, 1167 `date` varchar(255) default NULL, 1168 `protocol_type` int(11) default NULL, 1169 PRIMARY KEY (`id`), 1170 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 1171 FOREIGN KEY (`protocol`) REFERENCES `Bio_MAGETAB_Protocol` (`id`) 1172) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1173SET character_set_client = @saved_cs_client; 1174 1175-- 1176-- Dumping data for table `Bio_MAGETAB_ProtocolApplication` 1177-- 1178 1179LOCK TABLES `Bio_MAGETAB_ProtocolApplication` WRITE; 1180/*!40000 ALTER TABLE `Bio_MAGETAB_ProtocolApplication` DISABLE KEYS */; 1181/*!40000 ALTER TABLE `Bio_MAGETAB_ProtocolApplication` ENABLE KEYS */; 1182UNLOCK TABLES; 1183 1184-- 1185-- Table structure for table `Bio_MAGETAB_ProtocolApplication_protocolApplications` 1186-- 1187 1188DROP TABLE IF EXISTS `Bio_MAGETAB_ProtocolApplication_protocolApplications`; 1189SET @saved_cs_client = @@character_set_client; 1190SET character_set_client = utf8; 1191CREATE TABLE `Bio_MAGETAB_ProtocolApplication_protocolApplications` ( 1192 `item` int(11) default NULL, 1193 `coll` int(11) default NULL, 1194 `slot` int(11) default NULL, 1195 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_Edge` (`id`) ON DELETE CASCADE, 1196 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_ProtocolApplication` (`id`) ON DELETE CASCADE 1197) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1198SET character_set_client = @saved_cs_client; 1199 1200-- 1201-- Dumping data for table `Bio_MAGETAB_ProtocolApplication_protocolApplications` 1202-- 1203 1204LOCK TABLES `Bio_MAGETAB_ProtocolApplication_protocolApplications` WRITE; 1205/*!40000 ALTER TABLE `Bio_MAGETAB_ProtocolApplication_protocolApplications` DISABLE KEYS */; 1206/*!40000 ALTER TABLE `Bio_MAGETAB_ProtocolApplication_protocolApplications` ENABLE KEYS */; 1207UNLOCK TABLES; 1208 1209-- 1210-- Table structure for table `Bio_MAGETAB_ProtocolParameter` 1211-- 1212 1213DROP TABLE IF EXISTS `Bio_MAGETAB_ProtocolParameter`; 1214SET @saved_cs_client = @@character_set_client; 1215SET character_set_client = utf8; 1216CREATE TABLE `Bio_MAGETAB_ProtocolParameter` ( 1217 `id` int(11) NOT NULL, 1218 `protocol` int(11) default NULL, 1219 `name` varchar(255) default NULL, 1220 `protocol_type` int(11) default NULL, 1221 PRIMARY KEY (`id`), 1222 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 1223 FOREIGN KEY (`protocol`) REFERENCES `Bio_MAGETAB_Protocol` (`id`) 1224) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1225SET character_set_client = @saved_cs_client; 1226 1227-- 1228-- Dumping data for table `Bio_MAGETAB_ProtocolParameter` 1229-- 1230 1231LOCK TABLES `Bio_MAGETAB_ProtocolParameter` WRITE; 1232/*!40000 ALTER TABLE `Bio_MAGETAB_ProtocolParameter` DISABLE KEYS */; 1233/*!40000 ALTER TABLE `Bio_MAGETAB_ProtocolParameter` ENABLE KEYS */; 1234UNLOCK TABLES; 1235 1236-- 1237-- Table structure for table `Bio_MAGETAB_Protocol_protocols` 1238-- 1239 1240DROP TABLE IF EXISTS `Bio_MAGETAB_Protocol_protocols`; 1241SET @saved_cs_client = @@character_set_client; 1242SET character_set_client = utf8; 1243CREATE TABLE `Bio_MAGETAB_Protocol_protocols` ( 1244 `item` int(11) default NULL, 1245 `coll` int(11) default NULL, 1246 `slot` int(11) default NULL, 1247 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_Investigation` (`id`) ON DELETE CASCADE, 1248 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_Protocol` (`id`) ON DELETE CASCADE 1249) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1250SET character_set_client = @saved_cs_client; 1251 1252-- 1253-- Dumping data for table `Bio_MAGETAB_Protocol_protocols` 1254-- 1255 1256LOCK TABLES `Bio_MAGETAB_Protocol_protocols` WRITE; 1257/*!40000 ALTER TABLE `Bio_MAGETAB_Protocol_protocols` DISABLE KEYS */; 1258/*!40000 ALTER TABLE `Bio_MAGETAB_Protocol_protocols` ENABLE KEYS */; 1259UNLOCK TABLES; 1260 1261-- 1262-- Table structure for table `Bio_MAGETAB_Publication` 1263-- 1264 1265DROP TABLE IF EXISTS `Bio_MAGETAB_Publication`; 1266SET @saved_cs_client = @@character_set_client; 1267SET character_set_client = utf8; 1268CREATE TABLE `Bio_MAGETAB_Publication` ( 1269 `id` int(11) NOT NULL, 1270 `authorList` varchar(511) default NULL, 1271 `pubMedID` varchar(255) default NULL, 1272 `DOI` varchar(255) default NULL, 1273 `status` int(11) default NULL, 1274 `status_type` int(11) default NULL, 1275 `title` varchar(511) default NULL, 1276 PRIMARY KEY (`id`), 1277 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 1278 FOREIGN KEY (`status`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`) 1279) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1280SET character_set_client = @saved_cs_client; 1281 1282-- 1283-- Dumping data for table `Bio_MAGETAB_Publication` 1284-- 1285 1286LOCK TABLES `Bio_MAGETAB_Publication` WRITE; 1287/*!40000 ALTER TABLE `Bio_MAGETAB_Publication` DISABLE KEYS */; 1288/*!40000 ALTER TABLE `Bio_MAGETAB_Publication` ENABLE KEYS */; 1289UNLOCK TABLES; 1290 1291-- 1292-- Table structure for table `Bio_MAGETAB_Publication_publications` 1293-- 1294 1295DROP TABLE IF EXISTS `Bio_MAGETAB_Publication_publications`; 1296SET @saved_cs_client = @@character_set_client; 1297SET character_set_client = utf8; 1298CREATE TABLE `Bio_MAGETAB_Publication_publications` ( 1299 `item` int(11) default NULL, 1300 `coll` int(11) default NULL, 1301 `slot` int(11) default NULL, 1302 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_Investigation` (`id`) ON DELETE CASCADE, 1303 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_Publication` (`id`) ON DELETE CASCADE 1304) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1305SET character_set_client = @saved_cs_client; 1306 1307-- 1308-- Dumping data for table `Bio_MAGETAB_Publication_publications` 1309-- 1310 1311LOCK TABLES `Bio_MAGETAB_Publication_publications` WRITE; 1312/*!40000 ALTER TABLE `Bio_MAGETAB_Publication_publications` DISABLE KEYS */; 1313/*!40000 ALTER TABLE `Bio_MAGETAB_Publication_publications` ENABLE KEYS */; 1314UNLOCK TABLES; 1315 1316-- 1317-- Table structure for table `Bio_MAGETAB_Reporter` 1318-- 1319 1320DROP TABLE IF EXISTS `Bio_MAGETAB_Reporter`; 1321SET @saved_cs_client = @@character_set_client; 1322SET character_set_client = utf8; 1323CREATE TABLE `Bio_MAGETAB_Reporter` ( 1324 `id` int(11) NOT NULL, 1325 `controlType` int(11) default NULL, 1326 `sequence` varchar(255) default NULL, 1327 `name` varchar(255) default NULL, 1328 `controlType_type` int(11) default NULL, 1329 PRIMARY KEY (`id`), 1330 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_DesignElement` (`id`) ON DELETE CASCADE, 1331 FOREIGN KEY (`controlType`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`) 1332) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1333SET character_set_client = @saved_cs_client; 1334 1335-- 1336-- Dumping data for table `Bio_MAGETAB_Reporter` 1337-- 1338 1339LOCK TABLES `Bio_MAGETAB_Reporter` WRITE; 1340/*!40000 ALTER TABLE `Bio_MAGETAB_Reporter` DISABLE KEYS */; 1341/*!40000 ALTER TABLE `Bio_MAGETAB_Reporter` ENABLE KEYS */; 1342UNLOCK TABLES; 1343 1344-- 1345-- Table structure for table `Bio_MAGETAB_SDRF` 1346-- 1347 1348DROP TABLE IF EXISTS `Bio_MAGETAB_SDRF`; 1349SET @saved_cs_client = @@character_set_client; 1350SET character_set_client = utf8; 1351CREATE TABLE `Bio_MAGETAB_SDRF` ( 1352 `id` int(11) NOT NULL, 1353 `Bio_MAGETAB_Investigation_sdrfs_slot` int(11) default NULL, 1354 `Bio_MAGETAB_Investigation_sdrfs` int(11) default NULL, 1355 `uri` varchar(255) default NULL, 1356 PRIMARY KEY (`id`), 1357 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 1358 FOREIGN KEY (`Bio_MAGETAB_Investigation_sdrfs`) REFERENCES `Bio_MAGETAB_Investigation` (`id`) 1359) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1360SET character_set_client = @saved_cs_client; 1361 1362-- 1363-- Dumping data for table `Bio_MAGETAB_SDRF` 1364-- 1365 1366LOCK TABLES `Bio_MAGETAB_SDRF` WRITE; 1367/*!40000 ALTER TABLE `Bio_MAGETAB_SDRF` DISABLE KEYS */; 1368/*!40000 ALTER TABLE `Bio_MAGETAB_SDRF` ENABLE KEYS */; 1369UNLOCK TABLES; 1370 1371-- 1372-- Table structure for table `Bio_MAGETAB_SDRFRow` 1373-- 1374 1375DROP TABLE IF EXISTS `Bio_MAGETAB_SDRFRow`; 1376SET @saved_cs_client = @@character_set_client; 1377SET character_set_client = utf8; 1378CREATE TABLE `Bio_MAGETAB_SDRFRow` ( 1379 `id` int(11) NOT NULL, 1380 `rowNumber` int(11) default NULL, 1381 `Bio_MAGETAB_SDRF_sdrfRows_slot` int(11) default NULL, 1382 `Bio_MAGETAB_SDRF_sdrfRows` int(11) default NULL, 1383 `channel_type` int(11) default NULL, 1384 `channel` int(11) default NULL, 1385 PRIMARY KEY (`id`), 1386 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 1387 FOREIGN KEY (`channel`) REFERENCES `Bio_MAGETAB_ControlledTerm` (`id`), 1388 FOREIGN KEY (`Bio_MAGETAB_SDRF_sdrfRows`) REFERENCES `Bio_MAGETAB_SDRF` (`id`) 1389) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1390SET character_set_client = @saved_cs_client; 1391 1392-- 1393-- Dumping data for table `Bio_MAGETAB_SDRFRow` 1394-- 1395 1396LOCK TABLES `Bio_MAGETAB_SDRFRow` WRITE; 1397/*!40000 ALTER TABLE `Bio_MAGETAB_SDRFRow` DISABLE KEYS */; 1398/*!40000 ALTER TABLE `Bio_MAGETAB_SDRFRow` ENABLE KEYS */; 1399UNLOCK TABLES; 1400 1401-- 1402-- Table structure for table `Bio_MAGETAB_SDRFRow_sdrfRows` 1403-- 1404 1405DROP TABLE IF EXISTS `Bio_MAGETAB_SDRFRow_sdrfRows`; 1406SET @saved_cs_client = @@character_set_client; 1407SET character_set_client = utf8; 1408CREATE TABLE `Bio_MAGETAB_SDRFRow_sdrfRows` ( 1409 `item` int(11) default NULL, 1410 `coll` int(11) default NULL, 1411 `slot` int(11) default NULL, 1412 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE, 1413 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_SDRFRow` (`id`) ON DELETE CASCADE 1414) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1415SET character_set_client = @saved_cs_client; 1416 1417-- 1418-- Dumping data for table `Bio_MAGETAB_SDRFRow_sdrfRows` 1419-- 1420 1421LOCK TABLES `Bio_MAGETAB_SDRFRow_sdrfRows` WRITE; 1422/*!40000 ALTER TABLE `Bio_MAGETAB_SDRFRow_sdrfRows` DISABLE KEYS */; 1423/*!40000 ALTER TABLE `Bio_MAGETAB_SDRFRow_sdrfRows` ENABLE KEYS */; 1424UNLOCK TABLES; 1425 1426-- 1427-- Table structure for table `Bio_MAGETAB_TermSource` 1428-- 1429 1430DROP TABLE IF EXISTS `Bio_MAGETAB_TermSource`; 1431SET @saved_cs_client = @@character_set_client; 1432SET character_set_client = utf8; 1433CREATE TABLE `Bio_MAGETAB_TermSource` ( 1434 `id` int(11) NOT NULL, 1435 `version` varchar(255) default NULL, 1436 `name` varchar(255) default NULL, 1437 `uri` varchar(255) default NULL, 1438 PRIMARY KEY (`id`), 1439 FOREIGN KEY (`id`) REFERENCES `Bio_MAGETAB_BaseClass` (`id`) ON DELETE CASCADE 1440) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1441SET character_set_client = @saved_cs_client; 1442 1443-- 1444-- Dumping data for table `Bio_MAGETAB_TermSource` 1445-- 1446 1447LOCK TABLES `Bio_MAGETAB_TermSource` WRITE; 1448/*!40000 ALTER TABLE `Bio_MAGETAB_TermSource` DISABLE KEYS */; 1449/*!40000 ALTER TABLE `Bio_MAGETAB_TermSource` ENABLE KEYS */; 1450UNLOCK TABLES; 1451 1452-- 1453-- Table structure for table `Bio_MAGETAB_TermSource_termSources` 1454-- 1455 1456DROP TABLE IF EXISTS `Bio_MAGETAB_TermSource_termSources`; 1457SET @saved_cs_client = @@character_set_client; 1458SET character_set_client = utf8; 1459CREATE TABLE `Bio_MAGETAB_TermSource_termSources` ( 1460 `item` int(11) default NULL, 1461 `coll` int(11) default NULL, 1462 `slot` int(11) default NULL, 1463 FOREIGN KEY (`coll`) REFERENCES `Bio_MAGETAB_Investigation` (`id`) ON DELETE CASCADE, 1464 FOREIGN KEY (`item`) REFERENCES `Bio_MAGETAB_TermSource` (`id`) ON DELETE CASCADE 1465) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1466SET character_set_client = @saved_cs_client; 1467 1468-- 1469-- Dumping data for table `Bio_MAGETAB_TermSource_termSources` 1470-- 1471 1472LOCK TABLES `Bio_MAGETAB_TermSource_termSources` WRITE; 1473/*!40000 ALTER TABLE `Bio_MAGETAB_TermSource_termSources` DISABLE KEYS */; 1474/*!40000 ALTER TABLE `Bio_MAGETAB_TermSource_termSources` ENABLE KEYS */; 1475UNLOCK TABLES; 1476 1477-- 1478-- Table structure for table `tangram` 1479-- 1480 1481DROP TABLE IF EXISTS `tangram`; 1482SET @saved_cs_client = @@character_set_client; 1483SET character_set_client = utf8; 1484CREATE TABLE `tangram` ( 1485 `layout` int(11) NOT NULL, 1486 `engine` varchar(255) default NULL, 1487 `engine_layout` int(11) default NULL, 1488 `mark` int(11) NOT NULL, 1489 UNIQUE KEY `Tangram_Guard` (`layout`,`engine`,`engine_layout`) 1490) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1491SET character_set_client = @saved_cs_client; 1492 1493-- 1494-- Dumping data for table `tangram` 1495-- 1496 1497LOCK TABLES `tangram` WRITE; 1498/*!40000 ALTER TABLE `tangram` DISABLE KEYS */; 1499INSERT INTO `tangram` VALUES (2,'Tangram::Relational::Engine',1,0); 1500/*!40000 ALTER TABLE `tangram` ENABLE KEYS */; 1501UNLOCK TABLES; 1502/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 1503 1504/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 1505/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 1506/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 1507/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 1508/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 1509/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 1510/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 1511 1512-- Dump completed on 2009-01-16 15:13:38 1513