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 22DROP TABLE IF EXISTS `afe_aborted_host_queue_entries`; 23/*!40101 SET @saved_cs_client = @@character_set_client */; 24/*!40101 SET character_set_client = utf8 */; 25CREATE 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 40DROP TABLE IF EXISTS `afe_acl_groups`; 41/*!40101 SET @saved_cs_client = @@character_set_client */; 42/*!40101 SET character_set_client = utf8 */; 43CREATE 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 55DROP TABLE IF EXISTS `afe_acl_groups_hosts`; 56/*!40101 SET @saved_cs_client = @@character_set_client */; 57/*!40101 SET character_set_client = utf8 */; 58CREATE 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 74DROP TABLE IF EXISTS `afe_acl_groups_users`; 75/*!40101 SET @saved_cs_client = @@character_set_client */; 76/*!40101 SET character_set_client = utf8 */; 77CREATE 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 93DROP TABLE IF EXISTS `afe_atomic_groups`; 94/*!40101 SET @saved_cs_client = @@character_set_client */; 95/*!40101 SET character_set_client = utf8 */; 96CREATE 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 111DROP TABLE IF EXISTS `afe_autotests`; 112/*!40101 SET @saved_cs_client = @@character_set_client */; 113/*!40101 SET character_set_client = utf8 */; 114CREATE 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 138DROP TABLE IF EXISTS `afe_autotests_dependency_labels`; 139/*!40101 SET @saved_cs_client = @@character_set_client */; 140/*!40101 SET character_set_client = utf8 */; 141CREATE 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 157DROP TABLE IF EXISTS `afe_drone_sets`; 158/*!40101 SET @saved_cs_client = @@character_set_client */; 159/*!40101 SET character_set_client = utf8 */; 160CREATE 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 172DROP TABLE IF EXISTS `afe_drone_sets_drones`; 173/*!40101 SET @saved_cs_client = @@character_set_client */; 174/*!40101 SET character_set_client = utf8 */; 175CREATE 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 191DROP TABLE IF EXISTS `afe_drones`; 192/*!40101 SET @saved_cs_client = @@character_set_client */; 193/*!40101 SET character_set_client = utf8 */; 194CREATE 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 206DROP TABLE IF EXISTS `afe_host_attributes`; 207/*!40101 SET @saved_cs_client = @@character_set_client */; 208/*!40101 SET character_set_client = utf8 */; 209CREATE 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 225DROP TABLE IF EXISTS `afe_host_queue_entries`; 226/*!40101 SET @saved_cs_client = @@character_set_client */; 227/*!40101 SET character_set_client = utf8 */; 228CREATE 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 268DROP 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 */; 271CREATE 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 284DROP TABLE IF EXISTS `afe_hosts`; 285/*!40101 SET @saved_cs_client = @@character_set_client */; 286/*!40101 SET character_set_client = utf8 */; 287CREATE 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 314DROP TABLE IF EXISTS `afe_hosts_labels`; 315/*!40101 SET @saved_cs_client = @@character_set_client */; 316/*!40101 SET character_set_client = utf8 */; 317CREATE 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 333DROP TABLE IF EXISTS `afe_ineligible_host_queues`; 334/*!40101 SET @saved_cs_client = @@character_set_client */; 335/*!40101 SET character_set_client = utf8 */; 336CREATE 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 352DROP TABLE IF EXISTS `afe_job_handoffs`; 353/*!40101 SET @saved_cs_client = @@character_set_client */; 354/*!40101 SET character_set_client = utf8 */; 355CREATE 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 369DROP TABLE IF EXISTS `afe_job_keyvals`; 370/*!40101 SET @saved_cs_client = @@character_set_client */; 371/*!40101 SET character_set_client = utf8 */; 372CREATE 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 387DROP TABLE IF EXISTS `afe_jobs`; 388/*!40101 SET @saved_cs_client = @@character_set_client */; 389/*!40101 SET character_set_client = utf8 */; 390CREATE 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 433DROP TABLE IF EXISTS `afe_jobs_dependency_labels`; 434/*!40101 SET @saved_cs_client = @@character_set_client */; 435/*!40101 SET character_set_client = utf8 */; 436CREATE 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 452DROP TABLE IF EXISTS `afe_kernels`; 453/*!40101 SET @saved_cs_client = @@character_set_client */; 454/*!40101 SET character_set_client = utf8 */; 455CREATE 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 468DROP TABLE IF EXISTS `afe_labels`; 469/*!40101 SET @saved_cs_client = @@character_set_client */; 470/*!40101 SET character_set_client = utf8 */; 471CREATE 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 490DROP TABLE IF EXISTS `afe_parameterized_job_parameters`; 491/*!40101 SET @saved_cs_client = @@character_set_client */; 492/*!40101 SET character_set_client = utf8 */; 493CREATE 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 511DROP TABLE IF EXISTS `afe_parameterized_job_profiler_parameters`; 512/*!40101 SET @saved_cs_client = @@character_set_client */; 513/*!40101 SET character_set_client = utf8 */; 514CREATE 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 530DROP TABLE IF EXISTS `afe_parameterized_jobs`; 531/*!40101 SET @saved_cs_client = @@character_set_client */; 532/*!40101 SET character_set_client = utf8 */; 533CREATE 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 552DROP TABLE IF EXISTS `afe_parameterized_jobs_kernels`; 553/*!40101 SET @saved_cs_client = @@character_set_client */; 554/*!40101 SET character_set_client = utf8 */; 555CREATE 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 567DROP TABLE IF EXISTS `afe_parameterized_jobs_profilers`; 568/*!40101 SET @saved_cs_client = @@character_set_client */; 569/*!40101 SET character_set_client = utf8 */; 570CREATE 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 586DROP TABLE IF EXISTS `afe_profilers`; 587/*!40101 SET @saved_cs_client = @@character_set_client */; 588/*!40101 SET character_set_client = utf8 */; 589CREATE 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 602DROP TABLE IF EXISTS `afe_recurring_run`; 603/*!40101 SET @saved_cs_client = @@character_set_client */; 604/*!40101 SET character_set_client = utf8 */; 605CREATE 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 624DROP TABLE IF EXISTS `afe_replaced_labels`; 625/*!40101 SET @saved_cs_client = @@character_set_client */; 626/*!40101 SET character_set_client = utf8 */; 627CREATE 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 640DROP TABLE IF EXISTS `afe_shards`; 641/*!40101 SET @saved_cs_client = @@character_set_client */; 642/*!40101 SET character_set_client = utf8 */; 643CREATE 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 654DROP TABLE IF EXISTS `afe_shards_labels`; 655/*!40101 SET @saved_cs_client = @@character_set_client */; 656/*!40101 SET character_set_client = utf8 */; 657CREATE 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 673DROP TABLE IF EXISTS `afe_special_tasks`; 674/*!40101 SET @saved_cs_client = @@character_set_client */; 675/*!40101 SET character_set_client = utf8 */; 676CREATE 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 704DROP TABLE IF EXISTS `afe_stable_versions`; 705/*!40101 SET @saved_cs_client = @@character_set_client */; 706/*!40101 SET character_set_client = utf8 */; 707CREATE 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 721DROP TABLE IF EXISTS `afe_static_host_attributes`; 722/*!40101 SET @saved_cs_client = @@character_set_client */; 723/*!40101 SET character_set_client = utf8 */; 724CREATE 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 740DROP TABLE IF EXISTS `afe_static_hosts_labels`; 741/*!40101 SET @saved_cs_client = @@character_set_client */; 742/*!40101 SET character_set_client = utf8 */; 743CREATE 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 759DROP TABLE IF EXISTS `afe_static_labels`; 760/*!40101 SET @saved_cs_client = @@character_set_client */; 761/*!40101 SET character_set_client = utf8 */; 762CREATE 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 781DROP TABLE IF EXISTS `afe_test_parameters`; 782/*!40101 SET @saved_cs_client = @@character_set_client */; 783/*!40101 SET character_set_client = utf8 */; 784CREATE 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 798DROP TABLE IF EXISTS `afe_users`; 799/*!40101 SET @saved_cs_client = @@character_set_client */; 800/*!40101 SET character_set_client = utf8 */; 801CREATE 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 820DROP TABLE IF EXISTS `auth_group`; 821/*!40101 SET @saved_cs_client = @@character_set_client */; 822/*!40101 SET character_set_client = utf8 */; 823CREATE 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 835DROP TABLE IF EXISTS `auth_group_permissions`; 836/*!40101 SET @saved_cs_client = @@character_set_client */; 837/*!40101 SET character_set_client = utf8 */; 838CREATE 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 855DROP TABLE IF EXISTS `auth_permission`; 856/*!40101 SET @saved_cs_client = @@character_set_client */; 857/*!40101 SET character_set_client = utf8 */; 858CREATE 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 874DROP TABLE IF EXISTS `auth_user`; 875/*!40101 SET @saved_cs_client = @@character_set_client */; 876/*!40101 SET character_set_client = utf8 */; 877CREATE 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 898DROP TABLE IF EXISTS `auth_user_groups`; 899/*!40101 SET @saved_cs_client = @@character_set_client */; 900/*!40101 SET character_set_client = utf8 */; 901CREATE 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 918DROP TABLE IF EXISTS `auth_user_user_permissions`; 919/*!40101 SET @saved_cs_client = @@character_set_client */; 920/*!40101 SET character_set_client = utf8 */; 921CREATE 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 938DROP TABLE IF EXISTS `django_admin_log`; 939/*!40101 SET @saved_cs_client = @@character_set_client */; 940/*!40101 SET character_set_client = utf8 */; 941CREATE 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 962DROP TABLE IF EXISTS `django_content_type`; 963/*!40101 SET @saved_cs_client = @@character_set_client */; 964/*!40101 SET character_set_client = utf8 */; 965CREATE 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 979DROP TABLE IF EXISTS `django_session`; 980/*!40101 SET @saved_cs_client = @@character_set_client */; 981/*!40101 SET character_set_client = utf8 */; 982CREATE 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 995DROP TABLE IF EXISTS `django_site`; 996/*!40101 SET @saved_cs_client = @@character_set_client */; 997/*!40101 SET character_set_client = utf8 */; 998CREATE 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 1010DROP TABLE IF EXISTS `migrate_info`; 1011/*!40101 SET @saved_cs_client = @@character_set_client */; 1012/*!40101 SET character_set_client = utf8 */; 1013CREATE 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 1022DROP TABLE IF EXISTS `tko_embedded_graphing_queries`; 1023/*!40101 SET @saved_cs_client = @@character_set_client */; 1024/*!40101 SET character_set_client = utf8 */; 1025CREATE 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 1042DROP TABLE IF EXISTS `tko_iteration_attributes`; 1043/*!40101 SET @saved_cs_client = @@character_set_client */; 1044/*!40101 SET character_set_client = utf8 */; 1045CREATE 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 1059DROP TABLE IF EXISTS `tko_iteration_perf_value`; 1060/*!40101 SET @saved_cs_client = @@character_set_client */; 1061/*!40101 SET character_set_client = utf8 */; 1062CREATE 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 1082DROP TABLE IF EXISTS `tko_iteration_result`; 1083/*!40101 SET @saved_cs_client = @@character_set_client */; 1084/*!40101 SET character_set_client = utf8 */; 1085CREATE 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 1101DROP TABLE IF EXISTS `tko_job_keyvals`; 1102/*!40101 SET @saved_cs_client = @@character_set_client */; 1103/*!40101 SET character_set_client = utf8 */; 1104CREATE 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 1120DROP TABLE IF EXISTS `tko_jobs`; 1121/*!40101 SET @saved_cs_client = @@character_set_client */; 1122/*!40101 SET character_set_client = utf8 */; 1123CREATE 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 1158DROP TABLE IF EXISTS `tko_kernels`; 1159/*!40101 SET @saved_cs_client = @@character_set_client */; 1160/*!40101 SET character_set_client = utf8 */; 1161CREATE 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 1175DROP TABLE IF EXISTS `tko_machines`; 1176/*!40101 SET @saved_cs_client = @@character_set_client */; 1177/*!40101 SET character_set_client = utf8 */; 1178CREATE 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 1192DROP TABLE IF EXISTS `tko_patches`; 1193/*!40101 SET @saved_cs_client = @@character_set_client */; 1194/*!40101 SET character_set_client = utf8 */; 1195CREATE 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 1209DROP TABLE IF EXISTS `tko_perf_view`; 1210/*!50001 DROP VIEW IF EXISTS `tko_perf_view`*/; 1211SET @saved_cs_client = @@character_set_client; 1212SET 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 */; 1241SET character_set_client = @saved_cs_client; 1242 1243-- 1244-- Temporary table structure for view `tko_perf_view_2` 1245-- 1246 1247DROP TABLE IF EXISTS `tko_perf_view_2`; 1248/*!50001 DROP VIEW IF EXISTS `tko_perf_view_2`*/; 1249SET @saved_cs_client = @@character_set_client; 1250SET 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 */; 1279SET character_set_client = @saved_cs_client; 1280 1281-- 1282-- Table structure for table `tko_query_history` 1283-- 1284 1285DROP TABLE IF EXISTS `tko_query_history`; 1286/*!40101 SET @saved_cs_client = @@character_set_client */; 1287/*!40101 SET character_set_client = utf8 */; 1288CREATE 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 1300DROP TABLE IF EXISTS `tko_saved_queries`; 1301/*!40101 SET @saved_cs_client = @@character_set_client */; 1302/*!40101 SET character_set_client = utf8 */; 1303CREATE 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 1316DROP TABLE IF EXISTS `tko_status`; 1317/*!40101 SET @saved_cs_client = @@character_set_client */; 1318/*!40101 SET character_set_client = utf8 */; 1319CREATE 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 1331LOCK TABLES `tko_status` WRITE; 1332/*!40000 ALTER TABLE `tko_status` DISABLE KEYS */; 1333INSERT INTO `tko_status` (word) VALUES ('ABORT'),('ALERT'),('ERROR'),('FAIL'),('GOOD'),('NOSTATUS'),('RUNNING'),('TEST_NA'),('WARN'); 1334/*!40000 ALTER TABLE `tko_status` ENABLE KEYS */; 1335UNLOCK TABLES; 1336 1337-- 1338-- Table structure for table `tko_task_references` 1339-- 1340 1341DROP TABLE IF EXISTS `tko_task_references`; 1342/*!40101 SET @saved_cs_client = @@character_set_client */; 1343/*!40101 SET character_set_client = utf8 */; 1344CREATE 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 1363DROP TABLE IF EXISTS `tko_test_attributes`; 1364/*!40101 SET @saved_cs_client = @@character_set_client */; 1365/*!40101 SET character_set_client = utf8 */; 1366CREATE 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 1384DROP TABLE IF EXISTS `tko_test_labels`; 1385/*!40101 SET @saved_cs_client = @@character_set_client */; 1386/*!40101 SET character_set_client = utf8 */; 1387CREATE 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 1400DROP TABLE IF EXISTS `tko_test_labels_tests`; 1401/*!40101 SET @saved_cs_client = @@character_set_client */; 1402/*!40101 SET character_set_client = utf8 */; 1403CREATE 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 1420DROP TABLE IF EXISTS `tko_test_view`; 1421/*!50001 DROP VIEW IF EXISTS `tko_test_view`*/; 1422SET @saved_cs_client = @@character_set_client; 1423SET 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 */; 1449SET character_set_client = @saved_cs_client; 1450 1451-- 1452-- Temporary table structure for view `tko_test_view_2` 1453-- 1454 1455DROP TABLE IF EXISTS `tko_test_view_2`; 1456/*!50001 DROP VIEW IF EXISTS `tko_test_view_2`*/; 1457SET @saved_cs_client = @@character_set_client; 1458SET 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 */; 1492SET character_set_client = @saved_cs_client; 1493 1494-- 1495-- Temporary table structure for view `tko_test_view_outer_joins` 1496-- 1497 1498DROP TABLE IF EXISTS `tko_test_view_outer_joins`; 1499/*!50001 DROP VIEW IF EXISTS `tko_test_view_outer_joins`*/; 1500SET @saved_cs_client = @@character_set_client; 1501SET 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 */; 1527SET character_set_client = @saved_cs_client; 1528 1529-- 1530-- Table structure for table `tko_tests` 1531-- 1532 1533DROP TABLE IF EXISTS `tko_tests`; 1534/*!40101 SET @saved_cs_client = @@character_set_client */; 1535/*!40101 SET character_set_client = utf8 */; 1536CREATE 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