1 -- MySQL dump 10.14 Distrib 5.5.32-MariaDB, for Linux () 2 -- 3 -- Host: localhost Database: chromeos_autotest_db 4 -- ------------------------------------------------------ 5 -- Server version 5.5.32-MariaDB 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 `afe_aborted_host_queue_entries` 20 -- 21 22 DROP TABLE IF EXISTS `afe_aborted_host_queue_entries`; 23 /*!40101 SET @saved_cs_client = @@character_set_client */; 24 /*!40101 SET character_set_client = utf8 */; 25 CREATE TABLE `afe_aborted_host_queue_entries` ( 26 `queue_entry_id` int(11) NOT NULL, 27 `aborted_by_id` int(11) NOT NULL, 28 `aborted_on` datetime NOT NULL, 29 PRIMARY KEY (`queue_entry_id`), 30 KEY `aborted_host_queue_entries_aborted_by_id_fk` (`aborted_by_id`), 31 CONSTRAINT `aborted_host_queue_entries_aborted_by_id_fk` FOREIGN KEY (`aborted_by_id`) REFERENCES `afe_users` (`id`) ON DELETE NO ACTION, 32 CONSTRAINT `aborted_host_queue_entries_queue_entry_id_fk` FOREIGN KEY (`queue_entry_id`) REFERENCES `afe_host_queue_entries` (`id`) ON DELETE NO ACTION 33 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 34 /*!40101 SET character_set_client = @saved_cs_client */; 35 36 -- 37 -- Table structure for table `afe_acl_groups` 38 -- 39 40 DROP TABLE IF EXISTS `afe_acl_groups`; 41 /*!40101 SET @saved_cs_client = @@character_set_client */; 42 /*!40101 SET character_set_client = utf8 */; 43 CREATE TABLE `afe_acl_groups` ( 44 `id` int(11) NOT NULL AUTO_INCREMENT, 45 `name` varchar(255) DEFAULT NULL, 46 `description` varchar(255) DEFAULT NULL, 47 PRIMARY KEY (`id`) 48 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; 49 /*!40101 SET character_set_client = @saved_cs_client */; 50 51 -- 52 -- Table structure for table `afe_acl_groups_hosts` 53 -- 54 55 DROP TABLE IF EXISTS `afe_acl_groups_hosts`; 56 /*!40101 SET @saved_cs_client = @@character_set_client */; 57 /*!40101 SET character_set_client = utf8 */; 58 CREATE TABLE `afe_acl_groups_hosts` ( 59 `id` int(11) NOT NULL AUTO_INCREMENT, 60 `aclgroup_id` int(11) DEFAULT NULL, 61 `host_id` int(11) DEFAULT NULL, 62 PRIMARY KEY (`id`), 63 UNIQUE KEY `acl_groups_hosts_both_ids` (`aclgroup_id`,`host_id`), 64 KEY `acl_groups_hosts_host_id` (`host_id`), 65 CONSTRAINT `acl_groups_hosts_aclgroup_id_fk` FOREIGN KEY (`aclgroup_id`) REFERENCES `afe_acl_groups` (`id`) ON DELETE NO ACTION, 66 CONSTRAINT `acl_groups_hosts_host_id_fk` FOREIGN KEY (`host_id`) REFERENCES `afe_hosts` (`id`) ON DELETE NO ACTION 67 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 68 /*!40101 SET character_set_client = @saved_cs_client */; 69 70 -- 71 -- Table structure for table `afe_acl_groups_users` 72 -- 73 74 DROP TABLE IF EXISTS `afe_acl_groups_users`; 75 /*!40101 SET @saved_cs_client = @@character_set_client */; 76 /*!40101 SET character_set_client = utf8 */; 77 CREATE TABLE `afe_acl_groups_users` ( 78 `id` int(11) NOT NULL AUTO_INCREMENT, 79 `aclgroup_id` int(11) DEFAULT NULL, 80 `user_id` int(11) DEFAULT NULL, 81 PRIMARY KEY (`id`), 82 UNIQUE KEY `acl_groups_users_both_ids` (`aclgroup_id`,`user_id`), 83 KEY `acl_groups_users_user_id` (`user_id`), 84 CONSTRAINT `acl_groups_users_aclgroup_id_fk` FOREIGN KEY (`aclgroup_id`) REFERENCES `afe_acl_groups` (`id`) ON DELETE NO ACTION, 85 CONSTRAINT `acl_groups_users_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `afe_users` (`id`) ON DELETE NO ACTION 86 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; 87 /*!40101 SET character_set_client = @saved_cs_client */; 88 89 -- 90 -- Table structure for table `afe_atomic_groups` 91 -- 92 93 DROP TABLE IF EXISTS `afe_atomic_groups`; 94 /*!40101 SET @saved_cs_client = @@character_set_client */; 95 /*!40101 SET character_set_client = utf8 */; 96 CREATE TABLE `afe_atomic_groups` ( 97 `id` int(11) NOT NULL AUTO_INCREMENT, 98 `name` varchar(255) NOT NULL, 99 `description` longtext, 100 `max_number_of_machines` int(11) NOT NULL, 101 `invalid` tinyint(1) NOT NULL, 102 PRIMARY KEY (`id`), 103 UNIQUE KEY `name` (`name`) 104 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 105 /*!40101 SET character_set_client = @saved_cs_client */; 106 107 -- 108 -- Table structure for table `afe_autotests` 109 -- 110 111 DROP TABLE IF EXISTS `afe_autotests`; 112 /*!40101 SET @saved_cs_client = @@character_set_client */; 113 /*!40101 SET character_set_client = utf8 */; 114 CREATE TABLE `afe_autotests` ( 115 `id` int(11) NOT NULL AUTO_INCREMENT, 116 `name` varchar(255) DEFAULT NULL, 117 `test_class` varchar(255) DEFAULT NULL, 118 `description` text, 119 `test_type` int(11) DEFAULT NULL, 120 `path` varchar(255) DEFAULT NULL, 121 `author` varchar(256) DEFAULT NULL, 122 `dependencies` varchar(256) DEFAULT NULL, 123 `experimental` smallint(6) DEFAULT '0', 124 `run_verify` smallint(6) DEFAULT '1', 125 `test_time` smallint(6) DEFAULT '1', 126 `test_category` varchar(256) DEFAULT NULL, 127 `sync_count` int(11) DEFAULT '1', 128 `test_retry` int(11) NOT NULL DEFAULT '0', 129 `run_reset` smallint(6) NOT NULL DEFAULT '1', 130 PRIMARY KEY (`id`) 131 ) ENGINE=InnoDB AUTO_INCREMENT=2857 DEFAULT CHARSET=latin1; 132 /*!40101 SET character_set_client = @saved_cs_client */; 133 134 -- 135 -- Table structure for table `afe_autotests_dependency_labels` 136 -- 137 138 DROP TABLE IF EXISTS `afe_autotests_dependency_labels`; 139 /*!40101 SET @saved_cs_client = @@character_set_client */; 140 /*!40101 SET character_set_client = utf8 */; 141 CREATE TABLE `afe_autotests_dependency_labels` ( 142 `id` int(11) NOT NULL AUTO_INCREMENT, 143 `test_id` int(11) NOT NULL, 144 `label_id` int(11) NOT NULL, 145 PRIMARY KEY (`id`), 146 UNIQUE KEY `test_id` (`test_id`,`label_id`), 147 KEY `autotests_dependency_labels_label_id_fk` (`label_id`), 148 CONSTRAINT `autotests_dependency_labels_label_id_fk` FOREIGN KEY (`label_id`) REFERENCES `afe_labels` (`id`) ON DELETE NO ACTION, 149 CONSTRAINT `autotests_dependency_labels_test_id_fk` FOREIGN KEY (`test_id`) REFERENCES `afe_autotests` (`id`) ON DELETE NO ACTION 150 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 151 /*!40101 SET character_set_client = @saved_cs_client */; 152 153 -- 154 -- Table structure for table `afe_drone_sets` 155 -- 156 157 DROP TABLE IF EXISTS `afe_drone_sets`; 158 /*!40101 SET @saved_cs_client = @@character_set_client */; 159 /*!40101 SET character_set_client = utf8 */; 160 CREATE TABLE `afe_drone_sets` ( 161 `id` int(11) NOT NULL AUTO_INCREMENT, 162 `name` varchar(255) NOT NULL, 163 PRIMARY KEY (`id`), 164 UNIQUE KEY `afe_drone_sets_unique` (`name`) 165 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 166 /*!40101 SET character_set_client = @saved_cs_client */; 167 168 -- 169 -- Table structure for table `afe_drone_sets_drones` 170 -- 171 172 DROP TABLE IF EXISTS `afe_drone_sets_drones`; 173 /*!40101 SET @saved_cs_client = @@character_set_client */; 174 /*!40101 SET character_set_client = utf8 */; 175 CREATE TABLE `afe_drone_sets_drones` ( 176 `id` int(11) NOT NULL AUTO_INCREMENT, 177 `droneset_id` int(11) NOT NULL, 178 `drone_id` int(11) NOT NULL, 179 PRIMARY KEY (`id`), 180 UNIQUE KEY `afe_drone_sets_drones_unique` (`drone_id`), 181 KEY `afe_drone_sets_drones_droneset_ibfk` (`droneset_id`), 182 CONSTRAINT `afe_drone_sets_drones_drone_ibfk` FOREIGN KEY (`drone_id`) REFERENCES `afe_drones` (`id`), 183 CONSTRAINT `afe_drone_sets_drones_droneset_ibfk` FOREIGN KEY (`droneset_id`) REFERENCES `afe_drone_sets` (`id`) 184 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 185 /*!40101 SET character_set_client = @saved_cs_client */; 186 187 -- 188 -- Table structure for table `afe_drones` 189 -- 190 191 DROP TABLE IF EXISTS `afe_drones`; 192 /*!40101 SET @saved_cs_client = @@character_set_client */; 193 /*!40101 SET character_set_client = utf8 */; 194 CREATE TABLE `afe_drones` ( 195 `id` int(11) NOT NULL AUTO_INCREMENT, 196 `hostname` varchar(255) NOT NULL, 197 PRIMARY KEY (`id`), 198 UNIQUE KEY `afe_drones_unique` (`hostname`) 199 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 200 /*!40101 SET character_set_client = @saved_cs_client */; 201 202 -- 203 -- Table structure for table `afe_host_attributes` 204 -- 205 206 DROP TABLE IF EXISTS `afe_host_attributes`; 207 /*!40101 SET @saved_cs_client = @@character_set_client */; 208 /*!40101 SET character_set_client = utf8 */; 209 CREATE TABLE `afe_host_attributes` ( 210 `id` int(11) NOT NULL AUTO_INCREMENT, 211 `host_id` int(11) NOT NULL, 212 `attribute` varchar(90) NOT NULL, 213 `value` varchar(300) NOT NULL, 214 PRIMARY KEY (`id`), 215 KEY `host_id` (`host_id`), 216 KEY `attribute` (`attribute`), 217 CONSTRAINT `afe_host_attributes_ibfk_1` FOREIGN KEY (`host_id`) REFERENCES `afe_hosts` (`id`) 218 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 219 /*!40101 SET character_set_client = @saved_cs_client */; 220 221 -- 222 -- Table structure for table `afe_host_queue_entries` 223 -- 224 225 DROP TABLE IF EXISTS `afe_host_queue_entries`; 226 /*!40101 SET @saved_cs_client = @@character_set_client */; 227 /*!40101 SET character_set_client = utf8 */; 228 CREATE TABLE `afe_host_queue_entries` ( 229 `id` int(11) NOT NULL AUTO_INCREMENT, 230 `job_id` int(11) DEFAULT NULL, 231 `host_id` int(11) DEFAULT NULL, 232 `status` varchar(255) DEFAULT NULL, 233 `meta_host` int(11) DEFAULT NULL, 234 `active` tinyint(1) DEFAULT '0', 235 `complete` tinyint(1) DEFAULT '0', 236 `deleted` tinyint(1) NOT NULL, 237 `execution_subdir` varchar(255) NOT NULL, 238 `atomic_group_id` int(11) DEFAULT NULL, 239 `aborted` tinyint(1) NOT NULL DEFAULT '0', 240 `started_on` datetime DEFAULT NULL, 241 `finished_on` datetime DEFAULT NULL, 242 PRIMARY KEY (`id`), 243 UNIQUE KEY `host_queue_entries_job_id_and_host_id` (`job_id`,`host_id`), 244 KEY `host_queue_entries_host_id` (`host_id`), 245 KEY `host_queue_entries_meta_host` (`meta_host`), 246 KEY `atomic_group_id` (`atomic_group_id`), 247 KEY `host_queue_entries_host_active` (`host_id`,`active`), 248 KEY `host_queue_entry_status` (`status`), 249 KEY `host_queue_entries_abort_incomplete` (`aborted`,`complete`), 250 KEY `afe_host_queue_entries_active` (`active`), 251 KEY `afe_host_queue_entries_complete` (`complete`), 252 KEY `afe_host_queue_entries_deleted` (`deleted`), 253 KEY `afe_host_queue_entries_aborted` (`aborted`), 254 KEY `afe_host_queue_entries_started_on` (`started_on`), 255 KEY `afe_host_queue_entries_finished_on` (`finished_on`), 256 KEY `afe_host_queue_entries_job_id` (`job_id`), 257 CONSTRAINT `afe_host_queue_entries_ibfk_1` FOREIGN KEY (`atomic_group_id`) REFERENCES `afe_atomic_groups` (`id`) ON DELETE NO ACTION, 258 CONSTRAINT `host_queue_entries_host_id_fk` FOREIGN KEY (`host_id`) REFERENCES `afe_hosts` (`id`) ON DELETE NO ACTION, 259 CONSTRAINT `host_queue_entries_job_id_fk` FOREIGN KEY (`job_id`) REFERENCES `afe_jobs` (`id`) ON DELETE NO ACTION, 260 CONSTRAINT `host_queue_entries_meta_host_fk` FOREIGN KEY (`meta_host`) REFERENCES `afe_labels` (`id`) ON DELETE NO ACTION 261 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 262 /*!40101 SET character_set_client = @saved_cs_client */; 263 264 -- 265 -- Table structure for table `afe_host_queue_entry_start_times` 266 -- 267 268 DROP TABLE IF EXISTS `afe_host_queue_entry_start_times`; 269 /*!40101 SET @saved_cs_client = @@character_set_client */; 270 /*!40101 SET character_set_client = utf8 */; 271 CREATE TABLE `afe_host_queue_entry_start_times` ( 272 `id` int(11) NOT NULL AUTO_INCREMENT, 273 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 274 `highest_hqe_id` int(11) NOT NULL, 275 PRIMARY KEY (`id`), 276 KEY `afe_hqe_insert_times_index` (`insert_time`) 277 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 278 /*!40101 SET character_set_client = @saved_cs_client */; 279 280 -- 281 -- Table structure for table `afe_hosts` 282 -- 283 284 DROP TABLE IF EXISTS `afe_hosts`; 285 /*!40101 SET @saved_cs_client = @@character_set_client */; 286 /*!40101 SET character_set_client = utf8 */; 287 CREATE TABLE `afe_hosts` ( 288 `id` int(11) NOT NULL AUTO_INCREMENT, 289 `hostname` varchar(255) DEFAULT NULL, 290 `locked` tinyint(1) DEFAULT '0', 291 `synch_id` int(11) DEFAULT NULL, 292 `status` varchar(255) DEFAULT NULL, 293 `invalid` tinyint(1) DEFAULT '0', 294 `protection` int(11) NOT NULL, 295 `locked_by_id` int(11) DEFAULT NULL, 296 `lock_time` datetime DEFAULT NULL, 297 `dirty` tinyint(1) NOT NULL, 298 `leased` tinyint(1) NOT NULL DEFAULT '1', 299 `shard_id` int(11) DEFAULT NULL, 300 `lock_reason` text, 301 PRIMARY KEY (`id`), 302 KEY `hosts_locked_by_fk` (`locked_by_id`), 303 KEY `leased_hosts` (`leased`,`locked`), 304 KEY `hosts_to_shard_ibfk` (`shard_id`), 305 CONSTRAINT `hosts_locked_by_fk` FOREIGN KEY (`locked_by_id`) REFERENCES `afe_users` (`id`) ON DELETE NO ACTION, 306 CONSTRAINT `hosts_to_shard_ibfk` FOREIGN KEY (`shard_id`) REFERENCES `afe_shards` (`id`) 307 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 308 /*!40101 SET character_set_client = @saved_cs_client */; 309 310 -- 311 -- Table structure for table `afe_hosts_labels` 312 -- 313 314 DROP TABLE IF EXISTS `afe_hosts_labels`; 315 /*!40101 SET @saved_cs_client = @@character_set_client */; 316 /*!40101 SET character_set_client = utf8 */; 317 CREATE TABLE `afe_hosts_labels` ( 318 `id` int(11) NOT NULL AUTO_INCREMENT, 319 `host_id` int(11) DEFAULT NULL, 320 `label_id` int(11) DEFAULT NULL, 321 PRIMARY KEY (`id`), 322 UNIQUE KEY `hosts_labels_both_ids` (`label_id`,`host_id`), 323 KEY `hosts_labels_host_id` (`host_id`), 324 CONSTRAINT `hosts_labels_host_id_fk` FOREIGN KEY (`host_id`) REFERENCES `afe_hosts` (`id`) ON DELETE NO ACTION, 325 CONSTRAINT `hosts_labels_label_id_fk` FOREIGN KEY (`label_id`) REFERENCES `afe_labels` (`id`) ON DELETE NO ACTION 326 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 327 /*!40101 SET character_set_client = @saved_cs_client */; 328 329 -- 330 -- Table structure for table `afe_ineligible_host_queues` 331 -- 332 333 DROP TABLE IF EXISTS `afe_ineligible_host_queues`; 334 /*!40101 SET @saved_cs_client = @@character_set_client */; 335 /*!40101 SET character_set_client = utf8 */; 336 CREATE TABLE `afe_ineligible_host_queues` ( 337 `id` int(11) NOT NULL AUTO_INCREMENT, 338 `job_id` int(11) DEFAULT NULL, 339 `host_id` int(11) DEFAULT NULL, 340 PRIMARY KEY (`id`), 341 UNIQUE KEY `ineligible_host_queues_both_ids` (`host_id`,`job_id`), 342 KEY `ineligible_host_queues_job_id` (`job_id`), 343 CONSTRAINT `ineligible_host_queues_host_id_fk` FOREIGN KEY (`host_id`) REFERENCES `afe_hosts` (`id`) ON DELETE NO ACTION, 344 CONSTRAINT `ineligible_host_queues_job_id_fk` FOREIGN KEY (`job_id`) REFERENCES `afe_jobs` (`id`) ON DELETE NO ACTION 345 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 346 /*!40101 SET character_set_client = @saved_cs_client */; 347 348 -- 349 -- Table structure for table `afe_job_handoffs` 350 -- 351 352 DROP TABLE IF EXISTS `afe_job_handoffs`; 353 /*!40101 SET @saved_cs_client = @@character_set_client */; 354 /*!40101 SET character_set_client = utf8 */; 355 CREATE TABLE `afe_job_handoffs` ( 356 `job_id` int(11) NOT NULL, 357 `created` datetime NOT NULL, 358 `completed` tinyint(1) NOT NULL, 359 `drone` varchar(128) DEFAULT NULL, 360 PRIMARY KEY (`job_id`), 361 CONSTRAINT `job_fk` FOREIGN KEY (`job_id`) REFERENCES `afe_jobs` (`id`) ON DELETE CASCADE 362 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 363 /*!40101 SET character_set_client = @saved_cs_client */; 364 365 -- 366 -- Table structure for table `afe_job_keyvals` 367 -- 368 369 DROP TABLE IF EXISTS `afe_job_keyvals`; 370 /*!40101 SET @saved_cs_client = @@character_set_client */; 371 /*!40101 SET character_set_client = utf8 */; 372 CREATE TABLE `afe_job_keyvals` ( 373 `id` int(11) NOT NULL AUTO_INCREMENT, 374 `job_id` int(11) NOT NULL, 375 `key` varchar(90) NOT NULL, 376 `value` varchar(300) NOT NULL, 377 PRIMARY KEY (`id`), 378 KEY `afe_job_keyvals_job_id` (`job_id`), 379 KEY `afe_job_keyvals_key` (`key`) 380 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 381 /*!40101 SET character_set_client = @saved_cs_client */; 382 383 -- 384 -- Table structure for table `afe_jobs` 385 -- 386 387 DROP TABLE IF EXISTS `afe_jobs`; 388 /*!40101 SET @saved_cs_client = @@character_set_client */; 389 /*!40101 SET character_set_client = utf8 */; 390 CREATE TABLE `afe_jobs` ( 391 `id` int(11) NOT NULL AUTO_INCREMENT, 392 `owner` varchar(255) DEFAULT NULL, 393 `name` varchar(255) DEFAULT NULL, 394 `priority` int(11) DEFAULT NULL, 395 `control_file` text, 396 `control_type` int(11) DEFAULT NULL, 397 `created_on` datetime DEFAULT NULL, 398 `synch_count` int(11) NOT NULL, 399 `timeout` int(11) NOT NULL, 400 `run_verify` tinyint(1) DEFAULT '1', 401 `email_list` varchar(250) NOT NULL, 402 `reboot_before` smallint(6) NOT NULL, 403 `reboot_after` smallint(6) NOT NULL, 404 `parse_failed_repair` tinyint(1) NOT NULL DEFAULT '1', 405 `max_runtime_hrs` int(11) NOT NULL, 406 `drone_set_id` int(11) DEFAULT NULL, 407 `parameterized_job_id` int(11) DEFAULT NULL, 408 `max_runtime_mins` int(11) NOT NULL, 409 `parent_job_id` int(11) DEFAULT NULL, 410 `test_retry` int(11) NOT NULL DEFAULT '0', 411 `run_reset` smallint(6) NOT NULL DEFAULT '1', 412 `timeout_mins` int(11) NOT NULL, 413 `shard_id` int(11) DEFAULT NULL, 414 `require_ssp` tinyint(1) DEFAULT NULL, 415 PRIMARY KEY (`id`), 416 KEY `afe_jobs_drone_set_ibfk` (`drone_set_id`), 417 KEY `afe_jobs_parameterized_job_ibfk` (`parameterized_job_id`), 418 KEY `created_on` (`created_on`), 419 KEY `parent_job_id_index` (`parent_job_id`), 420 KEY `owner_index` (`owner`), 421 KEY `jobs_to_shard_ibfk` (`shard_id`), 422 KEY `name_index` (`name`), 423 CONSTRAINT `afe_jobs_drone_set_ibfk` FOREIGN KEY (`drone_set_id`) REFERENCES `afe_drone_sets` (`id`), 424 CONSTRAINT `afe_jobs_parameterized_job_ibfk` FOREIGN KEY (`parameterized_job_id`) REFERENCES `afe_parameterized_jobs` (`id`), 425 CONSTRAINT `jobs_to_shard_ibfk` FOREIGN KEY (`shard_id`) REFERENCES `afe_shards` (`id`) 426 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 427 /*!40101 SET character_set_client = @saved_cs_client */; 428 429 -- 430 -- Table structure for table `afe_jobs_dependency_labels` 431 -- 432 433 DROP TABLE IF EXISTS `afe_jobs_dependency_labels`; 434 /*!40101 SET @saved_cs_client = @@character_set_client */; 435 /*!40101 SET character_set_client = utf8 */; 436 CREATE TABLE `afe_jobs_dependency_labels` ( 437 `id` int(11) NOT NULL AUTO_INCREMENT, 438 `job_id` int(11) NOT NULL, 439 `label_id` int(11) NOT NULL, 440 PRIMARY KEY (`id`), 441 UNIQUE KEY `job_id` (`job_id`,`label_id`), 442 KEY `jobs_dependency_labels_label_id_fk` (`label_id`), 443 CONSTRAINT `jobs_dependency_labels_job_id_fk` FOREIGN KEY (`job_id`) REFERENCES `afe_jobs` (`id`) ON DELETE NO ACTION, 444 CONSTRAINT `jobs_dependency_labels_label_id_fk` FOREIGN KEY (`label_id`) REFERENCES `afe_labels` (`id`) ON DELETE NO ACTION 445 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 446 /*!40101 SET character_set_client = @saved_cs_client */; 447 448 -- 449 -- Table structure for table `afe_kernels` 450 -- 451 452 DROP TABLE IF EXISTS `afe_kernels`; 453 /*!40101 SET @saved_cs_client = @@character_set_client */; 454 /*!40101 SET character_set_client = utf8 */; 455 CREATE TABLE `afe_kernels` ( 456 `id` int(11) NOT NULL AUTO_INCREMENT, 457 `version` varchar(255) NOT NULL, 458 `cmdline` varchar(255) DEFAULT '', 459 PRIMARY KEY (`id`), 460 UNIQUE KEY `afe_kernals_unique` (`version`,`cmdline`) 461 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 462 /*!40101 SET character_set_client = @saved_cs_client */; 463 464 -- 465 -- Table structure for table `afe_labels` 466 -- 467 468 DROP TABLE IF EXISTS `afe_labels`; 469 /*!40101 SET @saved_cs_client = @@character_set_client */; 470 /*!40101 SET character_set_client = utf8 */; 471 CREATE TABLE `afe_labels` ( 472 `id` int(11) NOT NULL AUTO_INCREMENT, 473 `name` varchar(750) DEFAULT NULL, 474 `kernel_config` varchar(255) DEFAULT NULL, 475 `platform` tinyint(1) DEFAULT '0', 476 `invalid` tinyint(1) NOT NULL, 477 `only_if_needed` tinyint(1) NOT NULL, 478 `atomic_group_id` int(11) DEFAULT NULL, 479 PRIMARY KEY (`id`), 480 UNIQUE KEY `name` (`name`), 481 KEY `atomic_group_id` (`atomic_group_id`), 482 CONSTRAINT `afe_labels_ibfk_1` FOREIGN KEY (`atomic_group_id`) REFERENCES `afe_atomic_groups` (`id`) ON DELETE NO ACTION 483 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 484 /*!40101 SET character_set_client = @saved_cs_client */; 485 486 -- 487 -- Table structure for table `afe_parameterized_job_parameters` 488 -- 489 490 DROP TABLE IF EXISTS `afe_parameterized_job_parameters`; 491 /*!40101 SET @saved_cs_client = @@character_set_client */; 492 /*!40101 SET character_set_client = utf8 */; 493 CREATE TABLE `afe_parameterized_job_parameters` ( 494 `id` int(11) NOT NULL AUTO_INCREMENT, 495 `parameterized_job_id` int(11) NOT NULL, 496 `test_parameter_id` int(11) NOT NULL, 497 `parameter_value` text NOT NULL, 498 `parameter_type` enum('int','float','string') DEFAULT NULL, 499 PRIMARY KEY (`id`), 500 UNIQUE KEY `afe_parameterized_job_parameters_unique` (`parameterized_job_id`,`test_parameter_id`), 501 KEY `afe_parameterized_job_parameters_test_parameter_ibfk` (`test_parameter_id`), 502 CONSTRAINT `afe_parameterized_job_parameters_test_parameter_ibfk` FOREIGN KEY (`test_parameter_id`) REFERENCES `afe_test_parameters` (`id`), 503 CONSTRAINT `afe_parameterized_job_parameters_job_ibfk` FOREIGN KEY (`parameterized_job_id`) REFERENCES `afe_parameterized_jobs` (`id`) 504 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 505 /*!40101 SET character_set_client = @saved_cs_client */; 506 507 -- 508 -- Table structure for table `afe_parameterized_job_profiler_parameters` 509 -- 510 511 DROP TABLE IF EXISTS `afe_parameterized_job_profiler_parameters`; 512 /*!40101 SET @saved_cs_client = @@character_set_client */; 513 /*!40101 SET character_set_client = utf8 */; 514 CREATE TABLE `afe_parameterized_job_profiler_parameters` ( 515 `id` int(11) NOT NULL AUTO_INCREMENT, 516 `parameterized_job_profiler_id` int(11) NOT NULL, 517 `parameter_name` varchar(255) NOT NULL, 518 `parameter_value` text NOT NULL, 519 `parameter_type` enum('int','float','string') DEFAULT NULL, 520 PRIMARY KEY (`id`), 521 UNIQUE KEY `afe_parameterized_job_profiler_parameters_unique` (`parameterized_job_profiler_id`,`parameter_name`), 522 CONSTRAINT `afe_parameterized_job_profiler_parameters_ibfk` FOREIGN KEY (`parameterized_job_profiler_id`) REFERENCES `afe_parameterized_jobs_profilers` (`id`) 523 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 524 /*!40101 SET character_set_client = @saved_cs_client */; 525 526 -- 527 -- Table structure for table `afe_parameterized_jobs` 528 -- 529 530 DROP TABLE IF EXISTS `afe_parameterized_jobs`; 531 /*!40101 SET @saved_cs_client = @@character_set_client */; 532 /*!40101 SET character_set_client = utf8 */; 533 CREATE TABLE `afe_parameterized_jobs` ( 534 `id` int(11) NOT NULL AUTO_INCREMENT, 535 `test_id` int(11) NOT NULL, 536 `label_id` int(11) DEFAULT NULL, 537 `use_container` tinyint(1) DEFAULT '0', 538 `profile_only` tinyint(1) DEFAULT '0', 539 `upload_kernel_config` tinyint(1) DEFAULT '0', 540 PRIMARY KEY (`id`), 541 KEY `afe_parameterized_jobs_test_ibfk` (`test_id`), 542 KEY `afe_parameterized_jobs_label_ibfk` (`label_id`), 543 CONSTRAINT `afe_parameterized_jobs_label_ibfk` FOREIGN KEY (`label_id`) REFERENCES `afe_labels` (`id`), 544 CONSTRAINT `afe_parameterized_jobs_test_ibfk` FOREIGN KEY (`test_id`) REFERENCES `afe_autotests` (`id`) 545 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 546 /*!40101 SET character_set_client = @saved_cs_client */; 547 548 -- 549 -- Table structure for table `afe_parameterized_jobs_kernels` 550 -- 551 552 DROP TABLE IF EXISTS `afe_parameterized_jobs_kernels`; 553 /*!40101 SET @saved_cs_client = @@character_set_client */; 554 /*!40101 SET character_set_client = utf8 */; 555 CREATE TABLE `afe_parameterized_jobs_kernels` ( 556 `parameterized_job_id` int(11) NOT NULL, 557 `kernel_id` int(11) NOT NULL, 558 PRIMARY KEY (`parameterized_job_id`,`kernel_id`), 559 CONSTRAINT `afe_parameterized_jobs_kernels_parameterized_job_ibfk` FOREIGN KEY (`parameterized_job_id`) REFERENCES `afe_parameterized_jobs` (`id`) 560 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 561 /*!40101 SET character_set_client = @saved_cs_client */; 562 563 -- 564 -- Table structure for table `afe_parameterized_jobs_profilers` 565 -- 566 567 DROP TABLE IF EXISTS `afe_parameterized_jobs_profilers`; 568 /*!40101 SET @saved_cs_client = @@character_set_client */; 569 /*!40101 SET character_set_client = utf8 */; 570 CREATE TABLE `afe_parameterized_jobs_profilers` ( 571 `id` int(11) NOT NULL AUTO_INCREMENT, 572 `parameterized_job_id` int(11) NOT NULL, 573 `profiler_id` int(11) NOT NULL, 574 PRIMARY KEY (`id`), 575 UNIQUE KEY `afe_parameterized_jobs_profilers_unique` (`parameterized_job_id`,`profiler_id`), 576 KEY `afe_parameterized_jobs_profilers_profile_ibfk` (`profiler_id`), 577 CONSTRAINT `afe_parameterized_jobs_profilers_profile_ibfk` FOREIGN KEY (`profiler_id`) REFERENCES `afe_profilers` (`id`), 578 CONSTRAINT `afe_parameterized_jobs_profilers_parameterized_job_ibfk` FOREIGN KEY (`parameterized_job_id`) REFERENCES `afe_parameterized_jobs` (`id`) 579 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 580 /*!40101 SET character_set_client = @saved_cs_client */; 581 582 -- 583 -- Table structure for table `afe_profilers` 584 -- 585 586 DROP TABLE IF EXISTS `afe_profilers`; 587 /*!40101 SET @saved_cs_client = @@character_set_client */; 588 /*!40101 SET character_set_client = utf8 */; 589 CREATE TABLE `afe_profilers` ( 590 `id` int(11) NOT NULL AUTO_INCREMENT, 591 `name` varchar(255) NOT NULL, 592 `description` longtext NOT NULL, 593 PRIMARY KEY (`id`), 594 UNIQUE KEY `name` (`name`) 595 ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1; 596 /*!40101 SET character_set_client = @saved_cs_client */; 597 598 -- 599 -- Table structure for table `afe_recurring_run` 600 -- 601 602 DROP TABLE IF EXISTS `afe_recurring_run`; 603 /*!40101 SET @saved_cs_client = @@character_set_client */; 604 /*!40101 SET character_set_client = utf8 */; 605 CREATE TABLE `afe_recurring_run` ( 606 `id` int(11) NOT NULL AUTO_INCREMENT, 607 `job_id` int(11) NOT NULL, 608 `owner_id` int(11) NOT NULL, 609 `start_date` datetime NOT NULL, 610 `loop_period` int(11) NOT NULL, 611 `loop_count` int(11) NOT NULL, 612 PRIMARY KEY (`id`), 613 KEY `recurring_run_job_id` (`job_id`), 614 KEY `recurring_run_owner_id` (`owner_id`), 615 CONSTRAINT `recurring_run_job_id_fk` FOREIGN KEY (`job_id`) REFERENCES `afe_jobs` (`id`) ON DELETE NO ACTION, 616 CONSTRAINT `recurring_run_owner_id_fk` FOREIGN KEY (`owner_id`) REFERENCES `afe_users` (`id`) ON DELETE NO ACTION 617 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 618 /*!40101 SET character_set_client = @saved_cs_client */; 619 620 -- 621 -- Table structure for table `afe_replaced_labels` 622 -- 623 624 DROP TABLE IF EXISTS `afe_replaced_labels`; 625 /*!40101 SET @saved_cs_client = @@character_set_client */; 626 /*!40101 SET character_set_client = utf8 */; 627 CREATE TABLE `afe_replaced_labels` ( 628 `id` int(11) NOT NULL AUTO_INCREMENT, 629 `label_id` int(11) DEFAULT NULL, 630 PRIMARY KEY (`id`), 631 UNIQUE KEY `label_id` (`label_id`), 632 CONSTRAINT `afe_replaced_labels_ibfk_1` FOREIGN KEY (`label_id`) REFERENCES `afe_labels` (`id`) ON DELETE CASCADE 633 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 634 /*!40101 SET character_set_client = @saved_cs_client */; 635 636 -- 637 -- Table structure for table `afe_shards` 638 -- 639 640 DROP TABLE IF EXISTS `afe_shards`; 641 /*!40101 SET @saved_cs_client = @@character_set_client */; 642 /*!40101 SET character_set_client = utf8 */; 643 CREATE TABLE `afe_shards` ( 644 `id` int(11) NOT NULL AUTO_INCREMENT, 645 `hostname` varchar(255) NOT NULL, 646 PRIMARY KEY (`id`) 647 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 648 /*!40101 SET character_set_client = @saved_cs_client */; 649 650 -- 651 -- Table structure for table `afe_shards_labels` 652 -- 653 654 DROP TABLE IF EXISTS `afe_shards_labels`; 655 /*!40101 SET @saved_cs_client = @@character_set_client */; 656 /*!40101 SET character_set_client = utf8 */; 657 CREATE TABLE `afe_shards_labels` ( 658 `id` int(11) NOT NULL AUTO_INCREMENT, 659 `shard_id` int(11) NOT NULL, 660 `label_id` int(11) NOT NULL, 661 PRIMARY KEY (`id`), 662 UNIQUE KEY `shard_label_id_uc` (`label_id`), 663 KEY `shard_shard_id_fk` (`shard_id`), 664 CONSTRAINT `shard_label_id_fk` FOREIGN KEY (`label_id`) REFERENCES `afe_labels` (`id`), 665 CONSTRAINT `shard_shard_id_fk` FOREIGN KEY (`shard_id`) REFERENCES `afe_shards` (`id`) 666 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 667 /*!40101 SET character_set_client = @saved_cs_client */; 668 669 -- 670 -- Table structure for table `afe_special_tasks` 671 -- 672 673 DROP TABLE IF EXISTS `afe_special_tasks`; 674 /*!40101 SET @saved_cs_client = @@character_set_client */; 675 /*!40101 SET character_set_client = utf8 */; 676 CREATE TABLE `afe_special_tasks` ( 677 `id` int(11) NOT NULL AUTO_INCREMENT, 678 `host_id` int(11) NOT NULL, 679 `task` varchar(64) NOT NULL, 680 `time_requested` datetime NOT NULL, 681 `is_active` tinyint(1) NOT NULL DEFAULT '0', 682 `is_complete` tinyint(1) NOT NULL DEFAULT '0', 683 `time_started` datetime DEFAULT NULL, 684 `queue_entry_id` int(11) DEFAULT NULL, 685 `success` tinyint(1) NOT NULL DEFAULT '0', 686 `requested_by_id` int(11) NOT NULL, 687 `is_aborted` tinyint(1) NOT NULL DEFAULT '0', 688 `time_finished` datetime DEFAULT NULL, 689 PRIMARY KEY (`id`), 690 KEY `special_tasks_host_id` (`host_id`), 691 KEY `special_tasks_host_queue_entry_id` (`queue_entry_id`), 692 KEY `special_tasks_requested_by_id` (`requested_by_id`), 693 KEY `special_tasks_active_complete` (`is_active`,`is_complete`), 694 CONSTRAINT `special_tasks_requested_by_id` FOREIGN KEY (`requested_by_id`) REFERENCES `afe_users` (`id`) ON DELETE NO ACTION, 695 CONSTRAINT `special_tasks_to_hosts_ibfk` FOREIGN KEY (`host_id`) REFERENCES `afe_hosts` (`id`), 696 CONSTRAINT `special_tasks_to_host_queue_entries_ibfk` FOREIGN KEY (`queue_entry_id`) REFERENCES `afe_host_queue_entries` (`id`) 697 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 698 /*!40101 SET character_set_client = @saved_cs_client */; 699 700 -- 701 -- Table structure for table `afe_stable_versions` 702 -- 703 704 DROP TABLE IF EXISTS `afe_stable_versions`; 705 /*!40101 SET @saved_cs_client = @@character_set_client */; 706 /*!40101 SET character_set_client = utf8 */; 707 CREATE TABLE `afe_stable_versions` ( 708 `id` int(11) NOT NULL AUTO_INCREMENT, 709 `board` varchar(255) NOT NULL, 710 `version` varchar(255) NOT NULL, 711 `archive_url` text, 712 PRIMARY KEY (`id`), 713 UNIQUE KEY `board_UNIQUE` (`board`) 714 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 715 /*!40101 SET character_set_client = @saved_cs_client */; 716 717 -- 718 -- Table structure for table `afe_static_host_attributes` 719 -- 720 721 DROP TABLE IF EXISTS `afe_static_host_attributes`; 722 /*!40101 SET @saved_cs_client = @@character_set_client */; 723 /*!40101 SET character_set_client = utf8 */; 724 CREATE TABLE `afe_static_host_attributes` ( 725 `id` int(11) NOT NULL AUTO_INCREMENT, 726 `host_id` int(11) NOT NULL, 727 `attribute` varchar(90) NOT NULL, 728 `value` varchar(300) NOT NULL, 729 PRIMARY KEY (`id`), 730 KEY `host_id` (`host_id`), 731 KEY `attribute` (`attribute`), 732 CONSTRAINT `afe_static_host_attributes_ibfk_1` FOREIGN KEY (`host_id`) REFERENCES `afe_hosts` (`id`) ON DELETE CASCADE 733 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 734 /*!40101 SET character_set_client = @saved_cs_client */; 735 736 -- 737 -- Table structure for table `afe_static_hosts_labels` 738 -- 739 740 DROP TABLE IF EXISTS `afe_static_hosts_labels`; 741 /*!40101 SET @saved_cs_client = @@character_set_client */; 742 /*!40101 SET character_set_client = utf8 */; 743 CREATE TABLE `afe_static_hosts_labels` ( 744 `id` int(11) NOT NULL AUTO_INCREMENT, 745 `host_id` int(11) DEFAULT NULL, 746 `staticlabel_id` int(11) DEFAULT NULL, 747 PRIMARY KEY (`id`), 748 UNIQUE KEY `hosts_labels_both_ids` (`staticlabel_id`,`host_id`), 749 KEY `hosts_labels_host_id` (`host_id`), 750 CONSTRAINT `static_hosts_labels_host_id_fk` FOREIGN KEY (`host_id`) REFERENCES `afe_hosts` (`id`) ON DELETE NO ACTION, 751 CONSTRAINT `static_hosts_labels_label_id_fk` FOREIGN KEY (`staticlabel_id`) REFERENCES `afe_static_labels` (`id`) ON DELETE NO ACTION 752 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 753 /*!40101 SET character_set_client = @saved_cs_client */; 754 755 -- 756 -- Table structure for table `afe_static_labels` 757 -- 758 759 DROP TABLE IF EXISTS `afe_static_labels`; 760 /*!40101 SET @saved_cs_client = @@character_set_client */; 761 /*!40101 SET character_set_client = utf8 */; 762 CREATE TABLE `afe_static_labels` ( 763 `id` int(11) NOT NULL AUTO_INCREMENT, 764 `name` varchar(750) DEFAULT NULL, 765 `kernel_config` varchar(255) DEFAULT NULL, 766 `platform` tinyint(1) DEFAULT '0', 767 `invalid` tinyint(1) NOT NULL, 768 `only_if_needed` tinyint(1) NOT NULL, 769 `atomic_group_id` int(11) DEFAULT NULL, 770 PRIMARY KEY (`id`), 771 UNIQUE KEY `name` (`name`(50)), 772 KEY `atomic_group_id` (`atomic_group_id`), 773 CONSTRAINT `afe_static_labels_idfk_1` FOREIGN KEY (`atomic_group_id`) REFERENCES `afe_atomic_groups` (`id`) ON DELETE NO ACTION 774 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 775 /*!40101 SET character_set_client = @saved_cs_client */; 776 777 -- 778 -- Table structure for table `afe_test_parameters` 779 -- 780 781 DROP TABLE IF EXISTS `afe_test_parameters`; 782 /*!40101 SET @saved_cs_client = @@character_set_client */; 783 /*!40101 SET character_set_client = utf8 */; 784 CREATE TABLE `afe_test_parameters` ( 785 `id` int(11) NOT NULL AUTO_INCREMENT, 786 `test_id` int(11) NOT NULL, 787 `name` varchar(255) NOT NULL, 788 PRIMARY KEY (`id`), 789 UNIQUE KEY `afe_test_parameters_unique` (`test_id`,`name`), 790 CONSTRAINT `afe_test_parameters_test_ibfk` FOREIGN KEY (`test_id`) REFERENCES `afe_autotests` (`id`) 791 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 792 /*!40101 SET character_set_client = @saved_cs_client */; 793 794 -- 795 -- Table structure for table `afe_users` 796 -- 797 798 DROP TABLE IF EXISTS `afe_users`; 799 /*!40101 SET @saved_cs_client = @@character_set_client */; 800 /*!40101 SET character_set_client = utf8 */; 801 CREATE TABLE `afe_users` ( 802 `id` int(11) NOT NULL AUTO_INCREMENT, 803 `login` varchar(255) DEFAULT NULL, 804 `access_level` int(11) DEFAULT '0', 805 `reboot_before` smallint(6) NOT NULL, 806 `reboot_after` smallint(6) NOT NULL, 807 `show_experimental` tinyint(1) NOT NULL DEFAULT '0', 808 `drone_set_id` int(11) DEFAULT NULL, 809 PRIMARY KEY (`id`), 810 UNIQUE KEY `login_unique` (`login`), 811 KEY `afe_users_drone_set_ibfk` (`drone_set_id`), 812 CONSTRAINT `afe_users_drone_set_ibfk` FOREIGN KEY (`drone_set_id`) REFERENCES `afe_drone_sets` (`id`) 813 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; 814 /*!40101 SET character_set_client = @saved_cs_client */; 815 816 -- 817 -- Table structure for table `auth_group` 818 -- 819 820 DROP TABLE IF EXISTS `auth_group`; 821 /*!40101 SET @saved_cs_client = @@character_set_client */; 822 /*!40101 SET character_set_client = utf8 */; 823 CREATE TABLE `auth_group` ( 824 `id` int(11) NOT NULL AUTO_INCREMENT, 825 `name` varchar(80) NOT NULL, 826 PRIMARY KEY (`id`), 827 UNIQUE KEY `name` (`name`) 828 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; 829 /*!40101 SET character_set_client = @saved_cs_client */; 830 831 -- 832 -- Table structure for table `auth_group_permissions` 833 -- 834 835 DROP TABLE IF EXISTS `auth_group_permissions`; 836 /*!40101 SET @saved_cs_client = @@character_set_client */; 837 /*!40101 SET character_set_client = utf8 */; 838 CREATE TABLE `auth_group_permissions` ( 839 `id` int(11) NOT NULL AUTO_INCREMENT, 840 `group_id` int(11) NOT NULL, 841 `permission_id` int(11) NOT NULL, 842 PRIMARY KEY (`id`), 843 UNIQUE KEY `group_id` (`group_id`,`permission_id`), 844 KEY `auth_group_permissions_5f412f9a` (`group_id`), 845 KEY `auth_group_permissions_83d7f98b` (`permission_id`), 846 CONSTRAINT `group_id_refs_id_f4b32aac` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`), 847 CONSTRAINT `permission_id_refs_id_6ba0f519` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) 848 ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8; 849 /*!40101 SET character_set_client = @saved_cs_client */; 850 851 -- 852 -- Table structure for table `auth_permission` 853 -- 854 855 DROP TABLE IF EXISTS `auth_permission`; 856 /*!40101 SET @saved_cs_client = @@character_set_client */; 857 /*!40101 SET character_set_client = utf8 */; 858 CREATE TABLE `auth_permission` ( 859 `id` int(11) NOT NULL AUTO_INCREMENT, 860 `name` varchar(50) NOT NULL, 861 `content_type_id` int(11) NOT NULL, 862 `codename` varchar(100) NOT NULL, 863 PRIMARY KEY (`id`), 864 UNIQUE KEY `content_type_id` (`content_type_id`,`codename`), 865 KEY `auth_permission_37ef4eb4` (`content_type_id`), 866 CONSTRAINT `content_type_id_refs_id_d043b34a` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) 867 ) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8; 868 /*!40101 SET character_set_client = @saved_cs_client */; 869 870 -- 871 -- Table structure for table `auth_user` 872 -- 873 874 DROP TABLE IF EXISTS `auth_user`; 875 /*!40101 SET @saved_cs_client = @@character_set_client */; 876 /*!40101 SET character_set_client = utf8 */; 877 CREATE TABLE `auth_user` ( 878 `id` int(11) NOT NULL AUTO_INCREMENT, 879 `password` varchar(128) NOT NULL, 880 `last_login` datetime NOT NULL, 881 `is_superuser` tinyint(1) NOT NULL, 882 `username` varchar(30) NOT NULL, 883 `first_name` varchar(30) NOT NULL, 884 `last_name` varchar(30) NOT NULL, 885 `email` varchar(75) NOT NULL, 886 `is_staff` tinyint(1) NOT NULL, 887 `is_active` tinyint(1) NOT NULL, 888 `date_joined` datetime NOT NULL, 889 PRIMARY KEY (`id`), 890 UNIQUE KEY `username` (`username`) 891 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 892 /*!40101 SET character_set_client = @saved_cs_client */; 893 894 -- 895 -- Table structure for table `auth_user_groups` 896 -- 897 898 DROP TABLE IF EXISTS `auth_user_groups`; 899 /*!40101 SET @saved_cs_client = @@character_set_client */; 900 /*!40101 SET character_set_client = utf8 */; 901 CREATE TABLE `auth_user_groups` ( 902 `id` int(11) NOT NULL AUTO_INCREMENT, 903 `user_id` int(11) NOT NULL, 904 `group_id` int(11) NOT NULL, 905 PRIMARY KEY (`id`), 906 UNIQUE KEY `user_id` (`user_id`,`group_id`), 907 KEY `auth_user_groups_6340c63c` (`user_id`), 908 KEY `auth_user_groups_5f412f9a` (`group_id`), 909 CONSTRAINT `user_id_refs_id_40c41112` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`), 910 CONSTRAINT `group_id_refs_id_274b862c` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) 911 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 912 /*!40101 SET character_set_client = @saved_cs_client */; 913 914 -- 915 -- Table structure for table `auth_user_user_permissions` 916 -- 917 918 DROP TABLE IF EXISTS `auth_user_user_permissions`; 919 /*!40101 SET @saved_cs_client = @@character_set_client */; 920 /*!40101 SET character_set_client = utf8 */; 921 CREATE TABLE `auth_user_user_permissions` ( 922 `id` int(11) NOT NULL AUTO_INCREMENT, 923 `user_id` int(11) NOT NULL, 924 `permission_id` int(11) NOT NULL, 925 PRIMARY KEY (`id`), 926 UNIQUE KEY `user_id` (`user_id`,`permission_id`), 927 KEY `auth_user_user_permissions_6340c63c` (`user_id`), 928 KEY `auth_user_user_permissions_83d7f98b` (`permission_id`), 929 CONSTRAINT `user_id_refs_id_4dc23c39` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`), 930 CONSTRAINT `permission_id_refs_id_35d9ac25` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) 931 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 932 /*!40101 SET character_set_client = @saved_cs_client */; 933 934 -- 935 -- Table structure for table `django_admin_log` 936 -- 937 938 DROP TABLE IF EXISTS `django_admin_log`; 939 /*!40101 SET @saved_cs_client = @@character_set_client */; 940 /*!40101 SET character_set_client = utf8 */; 941 CREATE TABLE `django_admin_log` ( 942 `id` int(11) NOT NULL AUTO_INCREMENT, 943 `action_time` datetime NOT NULL, 944 `user_id` int(11) NOT NULL, 945 `content_type_id` int(11) DEFAULT NULL, 946 `object_id` longtext, 947 `object_repr` varchar(200) NOT NULL, 948 `action_flag` smallint(5) unsigned NOT NULL, 949 `change_message` longtext NOT NULL, 950 PRIMARY KEY (`id`), 951 KEY `django_admin_log_6340c63c` (`user_id`), 952 KEY `django_admin_log_37ef4eb4` (`content_type_id`), 953 CONSTRAINT `content_type_id_refs_id_93d2d1f8` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`), 954 CONSTRAINT `user_id_refs_id_c0d12874` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) 955 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 956 /*!40101 SET character_set_client = @saved_cs_client */; 957 958 -- 959 -- Table structure for table `django_content_type` 960 -- 961 962 DROP TABLE IF EXISTS `django_content_type`; 963 /*!40101 SET @saved_cs_client = @@character_set_client */; 964 /*!40101 SET character_set_client = utf8 */; 965 CREATE TABLE `django_content_type` ( 966 `id` int(11) NOT NULL AUTO_INCREMENT, 967 `name` varchar(100) NOT NULL, 968 `app_label` varchar(100) NOT NULL, 969 `model` varchar(100) NOT NULL, 970 PRIMARY KEY (`id`), 971 UNIQUE KEY `app_label` (`app_label`,`model`) 972 ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8; 973 /*!40101 SET character_set_client = @saved_cs_client */; 974 975 -- 976 -- Table structure for table `django_session` 977 -- 978 979 DROP TABLE IF EXISTS `django_session`; 980 /*!40101 SET @saved_cs_client = @@character_set_client */; 981 /*!40101 SET character_set_client = utf8 */; 982 CREATE TABLE `django_session` ( 983 `session_key` varchar(40) NOT NULL, 984 `session_data` longtext NOT NULL, 985 `expire_date` datetime NOT NULL, 986 PRIMARY KEY (`session_key`), 987 KEY `django_session_b7b81f0c` (`expire_date`) 988 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 989 /*!40101 SET character_set_client = @saved_cs_client */; 990 991 -- 992 -- Table structure for table `django_site` 993 -- 994 995 DROP TABLE IF EXISTS `django_site`; 996 /*!40101 SET @saved_cs_client = @@character_set_client */; 997 /*!40101 SET character_set_client = utf8 */; 998 CREATE TABLE `django_site` ( 999 `id` int(11) NOT NULL AUTO_INCREMENT, 1000 `domain` varchar(100) NOT NULL, 1001 `name` varchar(50) NOT NULL, 1002 PRIMARY KEY (`id`) 1003 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; 1004 /*!40101 SET character_set_client = @saved_cs_client */; 1005 1006 -- 1007 -- Table structure for table `migrate_info` 1008 -- 1009 1010 DROP TABLE IF EXISTS `migrate_info`; 1011 /*!40101 SET @saved_cs_client = @@character_set_client */; 1012 /*!40101 SET character_set_client = utf8 */; 1013 CREATE TABLE `migrate_info` ( 1014 `version` int(11) DEFAULT NULL 1015 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 1016 /*!40101 SET character_set_client = @saved_cs_client */; 1017 1018 -- 1019 -- Table structure for table `tko_embedded_graphing_queries` 1020 -- 1021 1022 DROP TABLE IF EXISTS `tko_embedded_graphing_queries`; 1023 /*!40101 SET @saved_cs_client = @@character_set_client */; 1024 /*!40101 SET character_set_client = utf8 */; 1025 CREATE TABLE `tko_embedded_graphing_queries` ( 1026 `id` int(11) NOT NULL AUTO_INCREMENT, 1027 `url_token` text NOT NULL, 1028 `graph_type` varchar(16) NOT NULL, 1029 `params` text NOT NULL, 1030 `last_updated` datetime NOT NULL, 1031 `refresh_time` datetime DEFAULT NULL, 1032 `cached_png` mediumblob, 1033 PRIMARY KEY (`id`), 1034 KEY `url_token` (`url_token`(128)) 1035 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1036 /*!40101 SET character_set_client = @saved_cs_client */; 1037 1038 -- 1039 -- Table structure for table `tko_iteration_attributes` 1040 -- 1041 1042 DROP TABLE IF EXISTS `tko_iteration_attributes`; 1043 /*!40101 SET @saved_cs_client = @@character_set_client */; 1044 /*!40101 SET character_set_client = utf8 */; 1045 CREATE TABLE `tko_iteration_attributes` ( 1046 `test_idx` int(10) unsigned NOT NULL, 1047 `iteration` int(11) DEFAULT NULL, 1048 `attribute` varchar(30) DEFAULT NULL, 1049 `value` varchar(1024) DEFAULT NULL, 1050 KEY `test_idx` (`test_idx`), 1051 CONSTRAINT `tko_iteration_attributes_ibfk_1` FOREIGN KEY (`test_idx`) REFERENCES `tko_tests` (`test_idx`) ON DELETE CASCADE 1052 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1053 /*!40101 SET character_set_client = @saved_cs_client */; 1054 1055 -- 1056 -- Table structure for table `tko_iteration_perf_value` 1057 -- 1058 1059 DROP TABLE IF EXISTS `tko_iteration_perf_value`; 1060 /*!40101 SET @saved_cs_client = @@character_set_client */; 1061 /*!40101 SET character_set_client = utf8 */; 1062 CREATE TABLE `tko_iteration_perf_value` ( 1063 `test_idx` int(10) unsigned NOT NULL, 1064 `iteration` int(11) DEFAULT NULL, 1065 `description` varchar(256) DEFAULT NULL, 1066 `value` float DEFAULT NULL, 1067 `stddev` float DEFAULT NULL, 1068 `units` varchar(32) DEFAULT NULL, 1069 `higher_is_better` tinyint(1) NOT NULL DEFAULT '1', 1070 `graph` varchar(256) DEFAULT NULL, 1071 KEY `test_idx` (`test_idx`), 1072 KEY `description` (`description`(255)), 1073 KEY `value` (`value`), 1074 CONSTRAINT `tko_iteration_perf_value_ibfk` FOREIGN KEY (`test_idx`) REFERENCES `tko_tests` (`test_idx`) ON DELETE CASCADE 1075 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 1076 /*!40101 SET character_set_client = @saved_cs_client */; 1077 1078 -- 1079 -- Table structure for table `tko_iteration_result` 1080 -- 1081 1082 DROP TABLE IF EXISTS `tko_iteration_result`; 1083 /*!40101 SET @saved_cs_client = @@character_set_client */; 1084 /*!40101 SET character_set_client = utf8 */; 1085 CREATE TABLE `tko_iteration_result` ( 1086 `test_idx` int(10) unsigned NOT NULL, 1087 `iteration` int(11) DEFAULT NULL, 1088 `attribute` varchar(256) DEFAULT NULL, 1089 `value` float DEFAULT NULL, 1090 KEY `test_idx` (`test_idx`), 1091 KEY `attribute` (`attribute`), 1092 KEY `value` (`value`), 1093 CONSTRAINT `tko_iteration_result_ibfk_1` FOREIGN KEY (`test_idx`) REFERENCES `tko_tests` (`test_idx`) ON DELETE CASCADE 1094 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1095 /*!40101 SET character_set_client = @saved_cs_client */; 1096 1097 -- 1098 -- Table structure for table `tko_job_keyvals` 1099 -- 1100 1101 DROP TABLE IF EXISTS `tko_job_keyvals`; 1102 /*!40101 SET @saved_cs_client = @@character_set_client */; 1103 /*!40101 SET character_set_client = utf8 */; 1104 CREATE TABLE `tko_job_keyvals` ( 1105 `id` int(11) NOT NULL AUTO_INCREMENT, 1106 `job_id` int(10) unsigned NOT NULL, 1107 `key` varchar(90) NOT NULL, 1108 `value` varchar(300) NOT NULL, 1109 PRIMARY KEY (`id`), 1110 KEY `tko_job_keyvals_job_id` (`job_id`), 1111 KEY `tko_job_keyvals_key` (`key`), 1112 CONSTRAINT `tko_job_keyvals_ibfk_1` FOREIGN KEY (`job_id`) REFERENCES `tko_jobs` (`job_idx`) ON DELETE CASCADE 1113 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1114 /*!40101 SET character_set_client = @saved_cs_client */; 1115 1116 -- 1117 -- Table structure for table `tko_jobs` 1118 -- 1119 1120 DROP TABLE IF EXISTS `tko_jobs`; 1121 /*!40101 SET @saved_cs_client = @@character_set_client */; 1122 /*!40101 SET character_set_client = utf8 */; 1123 CREATE TABLE `tko_jobs` ( 1124 `job_idx` int(10) unsigned NOT NULL AUTO_INCREMENT, 1125 `tag` varchar(100) DEFAULT NULL, 1126 `label` varchar(100) DEFAULT NULL, 1127 `username` varchar(80) DEFAULT NULL, 1128 `machine_idx` int(10) unsigned NOT NULL, 1129 `queued_time` datetime DEFAULT NULL, 1130 `started_time` datetime DEFAULT NULL, 1131 `finished_time` datetime DEFAULT NULL, 1132 `afe_job_id` int(11) DEFAULT NULL, 1133 `afe_parent_job_id` int(11) DEFAULT NULL, 1134 `build` varchar(255) DEFAULT NULL, 1135 `build_version` varchar(255) DEFAULT NULL, 1136 `suite` varchar(40) DEFAULT NULL, 1137 `board` varchar(40) DEFAULT NULL, 1138 PRIMARY KEY (`job_idx`), 1139 UNIQUE KEY `tag` (`tag`), 1140 KEY `label` (`label`), 1141 KEY `username` (`username`), 1142 KEY `machine_idx` (`machine_idx`), 1143 KEY `afe_job_id` (`afe_job_id`), 1144 KEY `afe_parent_job_id` (`afe_parent_job_id`), 1145 KEY `build` (`build`), 1146 KEY `build_version_suite_board` (`build_version`,`suite`,`board`), 1147 KEY `started_time_index` (`started_time`), 1148 KEY `queued_time` (`queued_time`), 1149 KEY `finished_time` (`finished_time`), 1150 CONSTRAINT `tko_jobs_ibfk_1` FOREIGN KEY (`machine_idx`) REFERENCES `tko_machines` (`machine_idx`) ON DELETE CASCADE 1151 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1152 /*!40101 SET character_set_client = @saved_cs_client */; 1153 1154 -- 1155 -- Table structure for table `tko_kernels` 1156 -- 1157 1158 DROP TABLE IF EXISTS `tko_kernels`; 1159 /*!40101 SET @saved_cs_client = @@character_set_client */; 1160 /*!40101 SET character_set_client = utf8 */; 1161 CREATE TABLE `tko_kernels` ( 1162 `kernel_idx` int(10) unsigned NOT NULL AUTO_INCREMENT, 1163 `kernel_hash` varchar(35) DEFAULT NULL, 1164 `base` varchar(30) DEFAULT NULL, 1165 `printable` varchar(100) DEFAULT NULL, 1166 PRIMARY KEY (`kernel_idx`), 1167 KEY `printable` (`printable`) 1168 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1169 /*!40101 SET character_set_client = @saved_cs_client */; 1170 1171 -- 1172 -- Table structure for table `tko_machines` 1173 -- 1174 1175 DROP TABLE IF EXISTS `tko_machines`; 1176 /*!40101 SET @saved_cs_client = @@character_set_client */; 1177 /*!40101 SET character_set_client = utf8 */; 1178 CREATE TABLE `tko_machines` ( 1179 `machine_idx` int(10) unsigned NOT NULL AUTO_INCREMENT, 1180 `hostname` varchar(700) DEFAULT NULL, 1181 `machine_group` varchar(80) DEFAULT NULL, 1182 `owner` varchar(80) DEFAULT NULL, 1183 PRIMARY KEY (`machine_idx`), 1184 UNIQUE KEY `hostname` (`hostname`) 1185 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1186 /*!40101 SET character_set_client = @saved_cs_client */; 1187 1188 -- 1189 -- Table structure for table `tko_patches` 1190 -- 1191 1192 DROP TABLE IF EXISTS `tko_patches`; 1193 /*!40101 SET @saved_cs_client = @@character_set_client */; 1194 /*!40101 SET character_set_client = utf8 */; 1195 CREATE TABLE `tko_patches` ( 1196 `kernel_idx` int(10) unsigned NOT NULL, 1197 `name` varchar(80) DEFAULT NULL, 1198 `url` varchar(300) DEFAULT NULL, 1199 `hash` varchar(35) DEFAULT NULL, 1200 KEY `kernel_idx` (`kernel_idx`), 1201 CONSTRAINT `tko_patches_ibfk_1` FOREIGN KEY (`kernel_idx`) REFERENCES `tko_kernels` (`kernel_idx`) ON DELETE CASCADE 1202 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1203 /*!40101 SET character_set_client = @saved_cs_client */; 1204 1205 -- 1206 -- Temporary table structure for view `tko_perf_view` 1207 -- 1208 1209 DROP TABLE IF EXISTS `tko_perf_view`; 1210 /*!50001 DROP VIEW IF EXISTS `tko_perf_view`*/; 1211 SET @saved_cs_client = @@character_set_client; 1212 SET character_set_client = utf8; 1213 /*!50001 CREATE TABLE `tko_perf_view` ( 1214 `test_idx` tinyint NOT NULL, 1215 `job_idx` tinyint NOT NULL, 1216 `test` tinyint NOT NULL, 1217 `subdir` tinyint NOT NULL, 1218 `kernel_idx` tinyint NOT NULL, 1219 `status` tinyint NOT NULL, 1220 `reason` tinyint NOT NULL, 1221 `machine_idx` tinyint NOT NULL, 1222 `test_started_time` tinyint NOT NULL, 1223 `test_finished_time` tinyint NOT NULL, 1224 `job_tag` tinyint NOT NULL, 1225 `job_label` tinyint NOT NULL, 1226 `job_username` tinyint NOT NULL, 1227 `job_queued_time` tinyint NOT NULL, 1228 `job_started_time` tinyint NOT NULL, 1229 `job_finished_time` tinyint NOT NULL, 1230 `machine_hostname` tinyint NOT NULL, 1231 `machine_group` tinyint NOT NULL, 1232 `machine_owner` tinyint NOT NULL, 1233 `kernel_hash` tinyint NOT NULL, 1234 `kernel_base` tinyint NOT NULL, 1235 `kernel_printable` tinyint NOT NULL, 1236 `status_word` tinyint NOT NULL, 1237 `iteration` tinyint NOT NULL, 1238 `iteration_key` tinyint NOT NULL, 1239 `iteration_value` tinyint NOT NULL 1240 ) ENGINE=MyISAM */; 1241 SET character_set_client = @saved_cs_client; 1242 1243 -- 1244 -- Temporary table structure for view `tko_perf_view_2` 1245 -- 1246 1247 DROP TABLE IF EXISTS `tko_perf_view_2`; 1248 /*!50001 DROP VIEW IF EXISTS `tko_perf_view_2`*/; 1249 SET @saved_cs_client = @@character_set_client; 1250 SET character_set_client = utf8; 1251 /*!50001 CREATE TABLE `tko_perf_view_2` ( 1252 `test_idx` tinyint NOT NULL, 1253 `job_idx` tinyint NOT NULL, 1254 `test_name` tinyint NOT NULL, 1255 `subdir` tinyint NOT NULL, 1256 `kernel_idx` tinyint NOT NULL, 1257 `status_idx` tinyint NOT NULL, 1258 `reason` tinyint NOT NULL, 1259 `machine_idx` tinyint NOT NULL, 1260 `test_started_time` tinyint NOT NULL, 1261 `test_finished_time` tinyint NOT NULL, 1262 `job_tag` tinyint NOT NULL, 1263 `job_name` tinyint NOT NULL, 1264 `job_owner` tinyint NOT NULL, 1265 `job_queued_time` tinyint NOT NULL, 1266 `job_started_time` tinyint NOT NULL, 1267 `job_finished_time` tinyint NOT NULL, 1268 `hostname` tinyint NOT NULL, 1269 `platform` tinyint NOT NULL, 1270 `machine_owner` tinyint NOT NULL, 1271 `kernel_hash` tinyint NOT NULL, 1272 `kernel_base` tinyint NOT NULL, 1273 `kernel` tinyint NOT NULL, 1274 `status` tinyint NOT NULL, 1275 `iteration` tinyint NOT NULL, 1276 `iteration_key` tinyint NOT NULL, 1277 `iteration_value` tinyint NOT NULL 1278 ) ENGINE=MyISAM */; 1279 SET character_set_client = @saved_cs_client; 1280 1281 -- 1282 -- Table structure for table `tko_query_history` 1283 -- 1284 1285 DROP TABLE IF EXISTS `tko_query_history`; 1286 /*!40101 SET @saved_cs_client = @@character_set_client */; 1287 /*!40101 SET character_set_client = utf8 */; 1288 CREATE TABLE `tko_query_history` ( 1289 `uid` varchar(32) DEFAULT NULL, 1290 `time_created` varchar(32) DEFAULT NULL, 1291 `user_comment` varchar(256) DEFAULT NULL, 1292 `url` varchar(1000) DEFAULT NULL 1293 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1294 /*!40101 SET character_set_client = @saved_cs_client */; 1295 1296 -- 1297 -- Table structure for table `tko_saved_queries` 1298 -- 1299 1300 DROP TABLE IF EXISTS `tko_saved_queries`; 1301 /*!40101 SET @saved_cs_client = @@character_set_client */; 1302 /*!40101 SET character_set_client = utf8 */; 1303 CREATE TABLE `tko_saved_queries` ( 1304 `id` int(11) NOT NULL AUTO_INCREMENT, 1305 `owner` varchar(80) NOT NULL, 1306 `name` varchar(100) NOT NULL, 1307 `url_token` longtext NOT NULL, 1308 PRIMARY KEY (`id`) 1309 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1310 /*!40101 SET character_set_client = @saved_cs_client */; 1311 1312 -- 1313 -- Table structure for table `tko_status` 1314 -- 1315 1316 DROP TABLE IF EXISTS `tko_status`; 1317 /*!40101 SET @saved_cs_client = @@character_set_client */; 1318 /*!40101 SET character_set_client = utf8 */; 1319 CREATE TABLE `tko_status` ( 1320 `status_idx` int(10) unsigned NOT NULL AUTO_INCREMENT, 1321 `word` varchar(10) DEFAULT NULL, 1322 PRIMARY KEY (`status_idx`), 1323 KEY `word` (`word`) 1324 ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1; 1325 /*!40101 SET character_set_client = @saved_cs_client */; 1326 1327 -- 1328 -- Dumping data for table `tko_status` 1329 -- 1330 1331 LOCK TABLES `tko_status` WRITE; 1332 /*!40000 ALTER TABLE `tko_status` DISABLE KEYS */; 1333 INSERT INTO `tko_status` (word) VALUES ('ABORT'),('ALERT'),('ERROR'),('FAIL'),('GOOD'),('NOSTATUS'),('RUNNING'),('TEST_NA'),('WARN'); 1334 /*!40000 ALTER TABLE `tko_status` ENABLE KEYS */; 1335 UNLOCK TABLES; 1336 1337 -- 1338 -- Table structure for table `tko_task_references` 1339 -- 1340 1341 DROP TABLE IF EXISTS `tko_task_references`; 1342 /*!40101 SET @saved_cs_client = @@character_set_client */; 1343 /*!40101 SET character_set_client = utf8 */; 1344 CREATE TABLE `tko_task_references` ( 1345 `id` int(11) NOT NULL AUTO_INCREMENT, 1346 `reference_type` enum('skylab','afe') NOT NULL, 1347 `tko_job_idx` int(10) unsigned NOT NULL, 1348 `task_id` varchar(20) DEFAULT NULL, 1349 `parent_task_id` varchar(20) DEFAULT NULL, 1350 PRIMARY KEY (`id`), 1351 KEY `tko_task_references_ibfk_1` (`tko_job_idx`), 1352 KEY `reference_type_id` (`reference_type`,`id`), 1353 KEY `reference_type_task_id` (`reference_type`,`task_id`), 1354 KEY `reference_type_parent_task_id` (`reference_type`,`parent_task_id`), 1355 CONSTRAINT `tko_task_references_ibfk_1` FOREIGN KEY (`tko_job_idx`) REFERENCES `tko_jobs` (`job_idx`) ON DELETE CASCADE 1356 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 1357 /*!40101 SET character_set_client = @saved_cs_client */; 1358 1359 -- 1360 -- Table structure for table `tko_test_attributes` 1361 -- 1362 1363 DROP TABLE IF EXISTS `tko_test_attributes`; 1364 /*!40101 SET @saved_cs_client = @@character_set_client */; 1365 /*!40101 SET character_set_client = utf8 */; 1366 CREATE TABLE `tko_test_attributes` ( 1367 `test_idx` int(10) unsigned NOT NULL, 1368 `attribute` varchar(30) DEFAULT NULL, 1369 `value` varchar(1024) DEFAULT NULL, 1370 `id` bigint(20) NOT NULL AUTO_INCREMENT, 1371 `user_created` tinyint(1) NOT NULL DEFAULT '0', 1372 PRIMARY KEY (`id`), 1373 KEY `test_idx` (`test_idx`), 1374 KEY `attribute` (`attribute`), 1375 KEY `value` (`value`(767)), 1376 CONSTRAINT `tko_test_attributes_ibfk_1` FOREIGN KEY (`test_idx`) REFERENCES `tko_tests` (`test_idx`) ON DELETE CASCADE 1377 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1378 /*!40101 SET character_set_client = @saved_cs_client */; 1379 1380 -- 1381 -- Table structure for table `tko_test_labels` 1382 -- 1383 1384 DROP TABLE IF EXISTS `tko_test_labels`; 1385 /*!40101 SET @saved_cs_client = @@character_set_client */; 1386 /*!40101 SET character_set_client = utf8 */; 1387 CREATE TABLE `tko_test_labels` ( 1388 `id` int(11) NOT NULL AUTO_INCREMENT, 1389 `name` varchar(80) NOT NULL, 1390 `description` longtext NOT NULL, 1391 PRIMARY KEY (`id`), 1392 UNIQUE KEY `tko_test_labels_unique` (`name`) 1393 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; 1394 /*!40101 SET character_set_client = @saved_cs_client */; 1395 1396 -- 1397 -- Table structure for table `tko_test_labels_tests` 1398 -- 1399 1400 DROP TABLE IF EXISTS `tko_test_labels_tests`; 1401 /*!40101 SET @saved_cs_client = @@character_set_client */; 1402 /*!40101 SET character_set_client = utf8 */; 1403 CREATE TABLE `tko_test_labels_tests` ( 1404 `id` int(11) NOT NULL AUTO_INCREMENT, 1405 `testlabel_id` int(11) NOT NULL, 1406 `test_id` int(10) unsigned NOT NULL, 1407 PRIMARY KEY (`id`), 1408 UNIQUE KEY `testlabel_id` (`testlabel_id`,`test_id`), 1409 KEY `test_labels_tests_test_id` (`test_id`), 1410 CONSTRAINT `tests_labels_tests_ibfk_2` FOREIGN KEY (`test_id`) REFERENCES `tko_tests` (`test_idx`) ON DELETE CASCADE, 1411 CONSTRAINT `tko_test_labels_tests_ibfk_1` FOREIGN KEY (`testlabel_id`) REFERENCES `tko_test_labels` (`id`) ON DELETE CASCADE, 1412 CONSTRAINT `tko_test_labels_tests_ibfk_2` FOREIGN KEY (`test_id`) REFERENCES `tko_tests` (`test_idx`) ON DELETE CASCADE 1413 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1414 /*!40101 SET character_set_client = @saved_cs_client */; 1415 1416 -- 1417 -- Temporary table structure for view `tko_test_view` 1418 -- 1419 1420 DROP TABLE IF EXISTS `tko_test_view`; 1421 /*!50001 DROP VIEW IF EXISTS `tko_test_view`*/; 1422 SET @saved_cs_client = @@character_set_client; 1423 SET character_set_client = utf8; 1424 /*!50001 CREATE TABLE `tko_test_view` ( 1425 `test_idx` tinyint NOT NULL, 1426 `job_idx` tinyint NOT NULL, 1427 `test` tinyint NOT NULL, 1428 `subdir` tinyint NOT NULL, 1429 `kernel_idx` tinyint NOT NULL, 1430 `status` tinyint NOT NULL, 1431 `reason` tinyint NOT NULL, 1432 `machine_idx` tinyint NOT NULL, 1433 `test_started_time` tinyint NOT NULL, 1434 `test_finished_time` tinyint NOT NULL, 1435 `job_tag` tinyint NOT NULL, 1436 `job_label` tinyint NOT NULL, 1437 `job_username` tinyint NOT NULL, 1438 `job_queued_time` tinyint NOT NULL, 1439 `job_started_time` tinyint NOT NULL, 1440 `job_finished_time` tinyint NOT NULL, 1441 `machine_hostname` tinyint NOT NULL, 1442 `machine_group` tinyint NOT NULL, 1443 `machine_owner` tinyint NOT NULL, 1444 `kernel_hash` tinyint NOT NULL, 1445 `kernel_base` tinyint NOT NULL, 1446 `kernel_printable` tinyint NOT NULL, 1447 `status_word` tinyint NOT NULL 1448 ) ENGINE=MyISAM */; 1449 SET character_set_client = @saved_cs_client; 1450 1451 -- 1452 -- Temporary table structure for view `tko_test_view_2` 1453 -- 1454 1455 DROP TABLE IF EXISTS `tko_test_view_2`; 1456 /*!50001 DROP VIEW IF EXISTS `tko_test_view_2`*/; 1457 SET @saved_cs_client = @@character_set_client; 1458 SET character_set_client = utf8; 1459 /*!50001 CREATE TABLE `tko_test_view_2` ( 1460 `test_idx` tinyint NOT NULL, 1461 `job_idx` tinyint NOT NULL, 1462 `test_name` tinyint NOT NULL, 1463 `subdir` tinyint NOT NULL, 1464 `kernel_idx` tinyint NOT NULL, 1465 `status_idx` tinyint NOT NULL, 1466 `reason` tinyint NOT NULL, 1467 `machine_idx` tinyint NOT NULL, 1468 `invalid` tinyint NOT NULL, 1469 `invalidates_test_idx` tinyint NOT NULL, 1470 `test_started_time` tinyint NOT NULL, 1471 `test_finished_time` tinyint NOT NULL, 1472 `job_tag` tinyint NOT NULL, 1473 `job_name` tinyint NOT NULL, 1474 `job_owner` tinyint NOT NULL, 1475 `job_queued_time` tinyint NOT NULL, 1476 `job_started_time` tinyint NOT NULL, 1477 `job_finished_time` tinyint NOT NULL, 1478 `afe_job_id` tinyint NOT NULL, 1479 `afe_parent_job_id` tinyint NOT NULL, 1480 `build` tinyint NOT NULL, 1481 `build_version` tinyint NOT NULL, 1482 `suite` tinyint NOT NULL, 1483 `board` tinyint NOT NULL, 1484 `hostname` tinyint NOT NULL, 1485 `platform` tinyint NOT NULL, 1486 `machine_owner` tinyint NOT NULL, 1487 `kernel_hash` tinyint NOT NULL, 1488 `kernel_base` tinyint NOT NULL, 1489 `kernel` tinyint NOT NULL, 1490 `status` tinyint NOT NULL 1491 ) ENGINE=MyISAM */; 1492 SET character_set_client = @saved_cs_client; 1493 1494 -- 1495 -- Temporary table structure for view `tko_test_view_outer_joins` 1496 -- 1497 1498 DROP TABLE IF EXISTS `tko_test_view_outer_joins`; 1499 /*!50001 DROP VIEW IF EXISTS `tko_test_view_outer_joins`*/; 1500 SET @saved_cs_client = @@character_set_client; 1501 SET character_set_client = utf8; 1502 /*!50001 CREATE TABLE `tko_test_view_outer_joins` ( 1503 `test_idx` tinyint NOT NULL, 1504 `job_idx` tinyint NOT NULL, 1505 `test_name` tinyint NOT NULL, 1506 `subdir` tinyint NOT NULL, 1507 `kernel_idx` tinyint NOT NULL, 1508 `status_idx` tinyint NOT NULL, 1509 `reason` tinyint NOT NULL, 1510 `machine_idx` tinyint NOT NULL, 1511 `test_started_time` tinyint NOT NULL, 1512 `test_finished_time` tinyint NOT NULL, 1513 `job_tag` tinyint NOT NULL, 1514 `job_name` tinyint NOT NULL, 1515 `job_owner` tinyint NOT NULL, 1516 `job_queued_time` tinyint NOT NULL, 1517 `job_started_time` tinyint NOT NULL, 1518 `job_finished_time` tinyint NOT NULL, 1519 `hostname` tinyint NOT NULL, 1520 `platform` tinyint NOT NULL, 1521 `machine_owner` tinyint NOT NULL, 1522 `kernel_hash` tinyint NOT NULL, 1523 `kernel_base` tinyint NOT NULL, 1524 `kernel` tinyint NOT NULL, 1525 `status` tinyint NOT NULL 1526 ) ENGINE=MyISAM */; 1527 SET character_set_client = @saved_cs_client; 1528 1529 -- 1530 -- Table structure for table `tko_tests` 1531 -- 1532 1533 DROP TABLE IF EXISTS `tko_tests`; 1534 /*!40101 SET @saved_cs_client = @@character_set_client */; 1535 /*!40101 SET character_set_client = utf8 */; 1536 CREATE TABLE `tko_tests` ( 1537 `test_idx` int(10) unsigned NOT NULL AUTO_INCREMENT, 1538 `job_idx` int(10) unsigned NOT NULL, 1539 `test` varchar(300) DEFAULT NULL, 1540 `subdir` varchar(300) DEFAULT NULL, 1541 `kernel_idx` int(10) unsigned NOT NULL, 1542 `status` int(10) unsigned NOT NULL, 1543 `reason` varchar(4096) DEFAULT NULL, 1544 `machine_idx` int(10) unsigned NOT NULL, 1545 `invalid` tinyint(1) DEFAULT '0', 1546 `finished_time` datetime DEFAULT NULL, 1547 `started_time` datetime DEFAULT NULL, 1548 `invalidates_test_idx` int(10) unsigned DEFAULT NULL, 1549 PRIMARY KEY (`test_idx`), 1550 KEY `kernel_idx` (`kernel_idx`), 1551 KEY `status` (`status`), 1552 KEY `machine_idx` (`machine_idx`), 1553 KEY `job_idx` (`job_idx`), 1554 KEY `reason` (`reason`(767)), 1555 KEY `test` (`test`), 1556 KEY `subdir` (`subdir`), 1557 KEY `started_time` (`started_time`), 1558 KEY `invalidates_test_idx` (`invalidates_test_idx`), 1559 KEY `finished_time_idx` (`finished_time`), 1560 CONSTRAINT `invalidates_test_idx_fk_1` FOREIGN KEY (`invalidates_test_idx`) REFERENCES `tko_tests` (`test_idx`) ON DELETE CASCADE, 1561 CONSTRAINT `tests_to_jobs_ibfk` FOREIGN KEY (`job_idx`) REFERENCES `tko_jobs` (`job_idx`), 1562 CONSTRAINT `tko_tests_ibfk_1` FOREIGN KEY (`kernel_idx`) REFERENCES `tko_kernels` (`kernel_idx`) ON DELETE CASCADE, 1563 CONSTRAINT `tko_tests_ibfk_2` FOREIGN KEY (`status`) REFERENCES `tko_status` (`status_idx`) ON DELETE CASCADE, 1564 CONSTRAINT `tko_tests_ibfk_3` FOREIGN KEY (`machine_idx`) REFERENCES `tko_machines` (`machine_idx`) ON DELETE CASCADE 1565 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 1566 /*!40101 SET character_set_client = @saved_cs_client */; 1567 1568 -- 1569 -- Final view structure for view `tko_perf_view` 1570 -- 1571 1572 /*!50001 DROP TABLE IF EXISTS `tko_perf_view`*/; 1573 /*!50001 DROP VIEW IF EXISTS `tko_perf_view`*/; 1574 /*!50001 SET @saved_cs_client = @@character_set_client */; 1575 /*!50001 SET @saved_cs_results = @@character_set_results */; 1576 /*!50001 SET @saved_col_connection = @@collation_connection */; 1577 /*!50001 SET character_set_client = utf8 */; 1578 /*!50001 SET character_set_results = utf8 */; 1579 /*!50001 SET collation_connection = utf8_general_ci */; 1580 /*!50001 CREATE ALGORITHM=UNDEFINED */ 1581 /*!50013 DEFINER=`chromeosqa-admin`@`localhost` SQL SECURITY DEFINER */ 1582 /*!50001 VIEW `tko_perf_view` AS select `tko_tests`.`test_idx` AS `test_idx`,`tko_tests`.`job_idx` AS `job_idx`,`tko_tests`.`test` AS `test`,`tko_tests`.`subdir` AS `subdir`,`tko_tests`.`kernel_idx` AS `kernel_idx`,`tko_tests`.`status` AS `status`,`tko_tests`.`reason` AS `reason`,`tko_tests`.`machine_idx` AS `machine_idx`,`tko_tests`.`started_time` AS `test_started_time`,`tko_tests`.`finished_time` AS `test_finished_time`,`tko_jobs`.`tag` AS `job_tag`,`tko_jobs`.`label` AS `job_label`,`tko_jobs`.`username` AS `job_username`,`tko_jobs`.`queued_time` AS `job_queued_time`,`tko_jobs`.`started_time` AS `job_started_time`,`tko_jobs`.`finished_time` AS `job_finished_time`,`tko_machines`.`hostname` AS `machine_hostname`,`tko_machines`.`machine_group` AS `machine_group`,`tko_machines`.`owner` AS `machine_owner`,`tko_kernels`.`kernel_hash` AS `kernel_hash`,`tko_kernels`.`base` AS `kernel_base`,`tko_kernels`.`printable` AS `kernel_printable`,`tko_status`.`word` AS `status_word`,`tko_iteration_result`.`iteration` AS `iteration`,`tko_iteration_result`.`attribute` AS `iteration_key`,`tko_iteration_result`.`value` AS `iteration_value` from (((((`tko_tests` join `tko_jobs` on((`tko_jobs`.`job_idx` = `tko_tests`.`job_idx`))) join `tko_machines` on((`tko_machines`.`machine_idx` = `tko_jobs`.`machine_idx`))) join `tko_kernels` on((`tko_kernels`.`kernel_idx` = `tko_tests`.`kernel_idx`))) join `tko_status` on((`tko_status`.`status_idx` = `tko_tests`.`status`))) join `tko_iteration_result` on((`tko_iteration_result`.`test_idx` = `tko_tests`.`test_idx`))) */; 1583 /*!50001 SET character_set_client = @saved_cs_client */; 1584 /*!50001 SET character_set_results = @saved_cs_results */; 1585 /*!50001 SET collation_connection = @saved_col_connection */; 1586 1587 -- 1588 -- Final view structure for view `tko_perf_view_2` 1589 -- 1590 1591 /*!50001 DROP TABLE IF EXISTS `tko_perf_view_2`*/; 1592 /*!50001 DROP VIEW IF EXISTS `tko_perf_view_2`*/; 1593 /*!50001 SET @saved_cs_client = @@character_set_client */; 1594 /*!50001 SET @saved_cs_results = @@character_set_results */; 1595 /*!50001 SET @saved_col_connection = @@collation_connection */; 1596 /*!50001 SET character_set_client = utf8 */; 1597 /*!50001 SET character_set_results = utf8 */; 1598 /*!50001 SET collation_connection = utf8_general_ci */; 1599 /*!50001 CREATE ALGORITHM=UNDEFINED */ 1600 /*!50013 DEFINER=`chromeosqa-admin`@`localhost` SQL SECURITY DEFINER */ 1601 /*!50001 VIEW `tko_perf_view_2` AS select `tko_tests`.`test_idx` AS `test_idx`,`tko_tests`.`job_idx` AS `job_idx`,`tko_tests`.`test` AS `test_name`,`tko_tests`.`subdir` AS `subdir`,`tko_tests`.`kernel_idx` AS `kernel_idx`,`tko_tests`.`status` AS `status_idx`,`tko_tests`.`reason` AS `reason`,`tko_tests`.`machine_idx` AS `machine_idx`,`tko_tests`.`started_time` AS `test_started_time`,`tko_tests`.`finished_time` AS `test_finished_time`,`tko_jobs`.`tag` AS `job_tag`,`tko_jobs`.`label` AS `job_name`,`tko_jobs`.`username` AS `job_owner`,`tko_jobs`.`queued_time` AS `job_queued_time`,`tko_jobs`.`started_time` AS `job_started_time`,`tko_jobs`.`finished_time` AS `job_finished_time`,`tko_machines`.`hostname` AS `hostname`,`tko_machines`.`machine_group` AS `platform`,`tko_machines`.`owner` AS `machine_owner`,`tko_kernels`.`kernel_hash` AS `kernel_hash`,`tko_kernels`.`base` AS `kernel_base`,`tko_kernels`.`printable` AS `kernel`,`tko_status`.`word` AS `status`,`tko_iteration_result`.`iteration` AS `iteration`,`tko_iteration_result`.`attribute` AS `iteration_key`,`tko_iteration_result`.`value` AS `iteration_value` from (((((`tko_tests` left join `tko_jobs` on((`tko_jobs`.`job_idx` = `tko_tests`.`job_idx`))) left join `tko_machines` on((`tko_machines`.`machine_idx` = `tko_jobs`.`machine_idx`))) left join `tko_kernels` on((`tko_kernels`.`kernel_idx` = `tko_tests`.`kernel_idx`))) left join `tko_status` on((`tko_status`.`status_idx` = `tko_tests`.`status`))) left join `tko_iteration_result` on((`tko_iteration_result`.`test_idx` = `tko_tests`.`test_idx`))) */; 1602 /*!50001 SET character_set_client = @saved_cs_client */; 1603 /*!50001 SET character_set_results = @saved_cs_results */; 1604 /*!50001 SET collation_connection = @saved_col_connection */; 1605 1606 -- 1607 -- Final view structure for view `tko_test_view` 1608 -- 1609 1610 /*!50001 DROP TABLE IF EXISTS `tko_test_view`*/; 1611 /*!50001 DROP VIEW IF EXISTS `tko_test_view`*/; 1612 /*!50001 SET @saved_cs_client = @@character_set_client */; 1613 /*!50001 SET @saved_cs_results = @@character_set_results */; 1614 /*!50001 SET @saved_col_connection = @@collation_connection */; 1615 /*!50001 SET character_set_client = utf8 */; 1616 /*!50001 SET character_set_results = utf8 */; 1617 /*!50001 SET collation_connection = utf8_general_ci */; 1618 /*!50001 CREATE ALGORITHM=UNDEFINED */ 1619 /*!50013 DEFINER=`chromeosqa-admin`@`localhost` SQL SECURITY DEFINER */ 1620 /*!50001 VIEW `tko_test_view` AS select `tko_tests`.`test_idx` AS `test_idx`,`tko_tests`.`job_idx` AS `job_idx`,`tko_tests`.`test` AS `test`,`tko_tests`.`subdir` AS `subdir`,`tko_tests`.`kernel_idx` AS `kernel_idx`,`tko_tests`.`status` AS `status`,`tko_tests`.`reason` AS `reason`,`tko_tests`.`machine_idx` AS `machine_idx`,`tko_tests`.`started_time` AS `test_started_time`,`tko_tests`.`finished_time` AS `test_finished_time`,`tko_jobs`.`tag` AS `job_tag`,`tko_jobs`.`label` AS `job_label`,`tko_jobs`.`username` AS `job_username`,`tko_jobs`.`queued_time` AS `job_queued_time`,`tko_jobs`.`started_time` AS `job_started_time`,`tko_jobs`.`finished_time` AS `job_finished_time`,`tko_machines`.`hostname` AS `machine_hostname`,`tko_machines`.`machine_group` AS `machine_group`,`tko_machines`.`owner` AS `machine_owner`,`tko_kernels`.`kernel_hash` AS `kernel_hash`,`tko_kernels`.`base` AS `kernel_base`,`tko_kernels`.`printable` AS `kernel_printable`,`tko_status`.`word` AS `status_word` from ((((`tko_tests` join `tko_jobs` on((`tko_jobs`.`job_idx` = `tko_tests`.`job_idx`))) join `tko_machines` on((`tko_machines`.`machine_idx` = `tko_jobs`.`machine_idx`))) join `tko_kernels` on((`tko_kernels`.`kernel_idx` = `tko_tests`.`kernel_idx`))) join `tko_status` on((`tko_status`.`status_idx` = `tko_tests`.`status`))) */; 1621 /*!50001 SET character_set_client = @saved_cs_client */; 1622 /*!50001 SET character_set_results = @saved_cs_results */; 1623 /*!50001 SET collation_connection = @saved_col_connection */; 1624 1625 -- 1626 -- Final view structure for view `tko_test_view_2` 1627 -- 1628 1629 /*!50001 DROP TABLE IF EXISTS `tko_test_view_2`*/; 1630 /*!50001 DROP VIEW IF EXISTS `tko_test_view_2`*/; 1631 /*!50001 SET @saved_cs_client = @@character_set_client */; 1632 /*!50001 SET @saved_cs_results = @@character_set_results */; 1633 /*!50001 SET @saved_col_connection = @@collation_connection */; 1634 /*!50001 SET character_set_client = utf8 */; 1635 /*!50001 SET character_set_results = utf8 */; 1636 /*!50001 SET collation_connection = utf8_general_ci */; 1637 /*!50001 CREATE ALGORITHM=UNDEFINED */ 1638 /*!50013 DEFINER=`chromeosqa-admin`@`localhost` SQL SECURITY DEFINER */ 1639 /*!50001 VIEW `tko_test_view_2` AS select `tko_tests`.`test_idx` AS `test_idx`,`tko_tests`.`job_idx` AS `job_idx`,`tko_tests`.`test` AS `test_name`,`tko_tests`.`subdir` AS `subdir`,`tko_tests`.`kernel_idx` AS `kernel_idx`,`tko_tests`.`status` AS `status_idx`,`tko_tests`.`reason` AS `reason`,`tko_tests`.`machine_idx` AS `machine_idx`,`tko_tests`.`invalid` AS `invalid`,`tko_tests`.`invalidates_test_idx` AS `invalidates_test_idx`,`tko_tests`.`started_time` AS `test_started_time`,`tko_tests`.`finished_time` AS `test_finished_time`,`tko_jobs`.`tag` AS `job_tag`,`tko_jobs`.`label` AS `job_name`,`tko_jobs`.`username` AS `job_owner`,`tko_jobs`.`queued_time` AS `job_queued_time`,`tko_jobs`.`started_time` AS `job_started_time`,`tko_jobs`.`finished_time` AS `job_finished_time`,`tko_jobs`.`afe_job_id` AS `afe_job_id`,`tko_jobs`.`afe_parent_job_id` AS `afe_parent_job_id`,`tko_jobs`.`build` AS `build`,`tko_jobs`.`build_version` AS `build_version`,`tko_jobs`.`suite` AS `suite`,`tko_jobs`.`board` AS `board`,`tko_machines`.`hostname` AS `hostname`,`tko_machines`.`machine_group` AS `platform`,`tko_machines`.`owner` AS `machine_owner`,`tko_kernels`.`kernel_hash` AS `kernel_hash`,`tko_kernels`.`base` AS `kernel_base`,`tko_kernels`.`printable` AS `kernel`,`tko_status`.`word` AS `status` from ((((`tko_tests` join `tko_jobs` on((`tko_jobs`.`job_idx` = `tko_tests`.`job_idx`))) join `tko_machines` on((`tko_machines`.`machine_idx` = `tko_jobs`.`machine_idx`))) join `tko_kernels` on((`tko_kernels`.`kernel_idx` = `tko_tests`.`kernel_idx`))) join `tko_status` on((`tko_status`.`status_idx` = `tko_tests`.`status`))) */; 1640 /*!50001 SET character_set_client = @saved_cs_client */; 1641 /*!50001 SET character_set_results = @saved_cs_results */; 1642 /*!50001 SET collation_connection = @saved_col_connection */; 1643 1644 -- 1645 -- Final view structure for view `tko_test_view_outer_joins` 1646 -- 1647 1648 /*!50001 DROP TABLE IF EXISTS `tko_test_view_outer_joins`*/; 1649 /*!50001 DROP VIEW IF EXISTS `tko_test_view_outer_joins`*/; 1650 /*!50001 SET @saved_cs_client = @@character_set_client */; 1651 /*!50001 SET @saved_cs_results = @@character_set_results */; 1652 /*!50001 SET @saved_col_connection = @@collation_connection */; 1653 /*!50001 SET character_set_client = utf8 */; 1654 /*!50001 SET character_set_results = utf8 */; 1655 /*!50001 SET collation_connection = utf8_general_ci */; 1656 /*!50001 CREATE ALGORITHM=UNDEFINED */ 1657 /*!50013 DEFINER=`chromeosqa-admin`@`localhost` SQL SECURITY DEFINER */ 1658 /*!50001 VIEW `tko_test_view_outer_joins` AS select `tko_tests`.`test_idx` AS `test_idx`,`tko_tests`.`job_idx` AS `job_idx`,`tko_tests`.`test` AS `test_name`,`tko_tests`.`subdir` AS `subdir`,`tko_tests`.`kernel_idx` AS `kernel_idx`,`tko_tests`.`status` AS `status_idx`,`tko_tests`.`reason` AS `reason`,`tko_tests`.`machine_idx` AS `machine_idx`,`tko_tests`.`started_time` AS `test_started_time`,`tko_tests`.`finished_time` AS `test_finished_time`,`tko_jobs`.`tag` AS `job_tag`,`tko_jobs`.`label` AS `job_name`,`tko_jobs`.`username` AS `job_owner`,`tko_jobs`.`queued_time` AS `job_queued_time`,`tko_jobs`.`started_time` AS `job_started_time`,`tko_jobs`.`finished_time` AS `job_finished_time`,`tko_machines`.`hostname` AS `hostname`,`tko_machines`.`machine_group` AS `platform`,`tko_machines`.`owner` AS `machine_owner`,`tko_kernels`.`kernel_hash` AS `kernel_hash`,`tko_kernels`.`base` AS `kernel_base`,`tko_kernels`.`printable` AS `kernel`,`tko_status`.`word` AS `status` from ((((`tko_tests` left join `tko_jobs` on((`tko_jobs`.`job_idx` = `tko_tests`.`job_idx`))) left join `tko_machines` on((`tko_machines`.`machine_idx` = `tko_jobs`.`machine_idx`))) left join `tko_kernels` on((`tko_kernels`.`kernel_idx` = `tko_tests`.`kernel_idx`))) left join `tko_status` on((`tko_status`.`status_idx` = `tko_tests`.`status`))) */; 1659 /*!50001 SET character_set_client = @saved_cs_client */; 1660 /*!50001 SET character_set_results = @saved_cs_results */; 1661 /*!50001 SET collation_connection = @saved_col_connection */; 1662 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 1663 1664 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 1665 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 1666 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 1667 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 1668 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 1669 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 1670 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 1671 1672 -- Dump completed on 2018-06-18 15:46:13 1673
