Lines Matching refs:KEY
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 …
32 …CONSTRAINT `aborted_host_queue_entries_queue_entry_id_fk` FOREIGN KEY (`queue_entry_id`) REFERENCE…
47 PRIMARY KEY (`id`)
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_group…
66 …CONSTRAINT `acl_groups_hosts_host_id_fk` FOREIGN KEY (`host_id`) REFERENCES `afe_hosts` (`id`) ON …
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_group…
85 …CONSTRAINT `acl_groups_users_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `afe_users` (`id`) ON …
102 PRIMARY KEY (`id`),
103 UNIQUE KEY `name` (`name`)
130 PRIMARY KEY (`id`)
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_labe…
149 …CONSTRAINT `autotests_dependency_labels_test_id_fk` FOREIGN KEY (`test_id`) REFERENCES `afe_autote…
163 PRIMARY KEY (`id`),
164 UNIQUE KEY `afe_drone_sets_unique` (`name`)
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` (`i…
183 …CONSTRAINT `afe_drone_sets_drones_droneset_ibfk` FOREIGN KEY (`droneset_id`) REFERENCES `afe_drone…
197 PRIMARY KEY (`id`),
198 UNIQUE KEY `afe_drones_unique` (`hostname`)
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`)
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_…
258 …CONSTRAINT `host_queue_entries_host_id_fk` FOREIGN KEY (`host_id`) REFERENCES `afe_hosts` (`id`) O…
259 …CONSTRAINT `host_queue_entries_job_id_fk` FOREIGN KEY (`job_id`) REFERENCES `afe_jobs` (`id`) ON D…
260 …CONSTRAINT `host_queue_entries_meta_host_fk` FOREIGN KEY (`meta_host`) REFERENCES `afe_labels` (`i…
275 PRIMARY KEY (`id`),
276 KEY `afe_hqe_insert_times_index` (`insert_time`)
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 DELE…
306 CONSTRAINT `hosts_to_shard_ibfk` FOREIGN KEY (`shard_id`) REFERENCES `afe_shards` (`id`)
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 DELE…
325 …CONSTRAINT `hosts_labels_label_id_fk` FOREIGN KEY (`label_id`) REFERENCES `afe_labels` (`id`) ON D…
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…
344 …CONSTRAINT `ineligible_host_queues_job_id_fk` FOREIGN KEY (`job_id`) REFERENCES `afe_jobs` (`id`) …
360 PRIMARY KEY (`job_id`),
361 CONSTRAINT `job_fk` FOREIGN KEY (`job_id`) REFERENCES `afe_jobs` (`id`) ON DELETE CASCADE
377 PRIMARY KEY (`id`),
378 KEY `afe_job_keyvals_job_id` (`job_id`),
379 KEY `afe_job_keyvals_key` (`key`)
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_…
425 CONSTRAINT `jobs_to_shard_ibfk` FOREIGN KEY (`shard_id`) REFERENCES `afe_shards` (`id`)
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`) …
444 …CONSTRAINT `jobs_dependency_labels_label_id_fk` FOREIGN KEY (`label_id`) REFERENCES `afe_labels` (…
459 PRIMARY KEY (`id`),
460 UNIQUE KEY `afe_kernals_unique` (`version`,`cmdline`)
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…
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`…
503 …CONSTRAINT `afe_parameterized_job_parameters_job_ibfk` FOREIGN KEY (`parameterized_job_id`) REFERE…
520 PRIMARY KEY (`id`),
521 …UNIQUE KEY `afe_parameterized_job_profiler_parameters_unique` (`parameterized_job_profiler_id`,`pa…
522 …CONSTRAINT `afe_parameterized_job_profiler_parameters_ibfk` FOREIGN KEY (`parameterized_job_profil…
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` (`…
544 …CONSTRAINT `afe_parameterized_jobs_test_ibfk` FOREIGN KEY (`test_id`) REFERENCES `afe_autotests` (…
558 PRIMARY KEY (`parameterized_job_id`,`kernel_id`),
559 …CONSTRAINT `afe_parameterized_jobs_kernels_parameterized_job_ibfk` FOREIGN KEY (`parameterized_job…
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 …
578 …CONSTRAINT `afe_parameterized_jobs_profilers_parameterized_job_ibfk` FOREIGN KEY (`parameterized_j…
593 PRIMARY KEY (`id`),
594 UNIQUE KEY `name` (`name`)
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…
616 …CONSTRAINT `recurring_run_owner_id_fk` FOREIGN KEY (`owner_id`) REFERENCES `afe_users` (`id`) ON D…
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…
646 PRIMARY KEY (`id`)
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`)
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` …
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 `a…
712 PRIMARY KEY (`id`),
713 UNIQUE KEY `board_UNIQUE` (`board`)
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…
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`) …
751 …CONSTRAINT `static_hosts_labels_label_id_fk` FOREIGN KEY (`staticlabel_id`) REFERENCES `afe_static…
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_group…
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…
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` (`i…
826 PRIMARY KEY (`id`),
827 UNIQUE KEY `name` (`name`)
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_permiss…
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_c…
889 PRIMARY KEY (`id`),
890 UNIQUE KEY `username` (`username`)
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`)
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_permiss…
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_c…
954 CONSTRAINT `user_id_refs_id_c0d12874` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
970 PRIMARY KEY (`id`),
971 UNIQUE KEY `app_label` (`app_label`,`model`)
986 PRIMARY KEY (`session_key`),
987 KEY `django_session_b7b81f0c` (`expire_date`)
1002 PRIMARY KEY (`id`)
1033 PRIMARY KEY (`id`),
1034 KEY `url_token` (`url_token`(128))
1050 KEY `test_idx` (`test_idx`),
1051 …CONSTRAINT `tko_iteration_attributes_ibfk_1` FOREIGN KEY (`test_idx`) REFERENCES `tko_tests` (`tes…
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_…
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_id…
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 DE…
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`)…
1166 PRIMARY KEY (`kernel_idx`),
1167 KEY `printable` (`printable`)
1183 PRIMARY KEY (`machine_idx`),
1184 UNIQUE KEY `hostname` (`hostname`)
1200 KEY `kernel_idx` (`kernel_idx`),
1201 …CONSTRAINT `tko_patches_ibfk_1` FOREIGN KEY (`kernel_idx`) REFERENCES `tko_kernels` (`kernel_idx`)…
1308 PRIMARY KEY (`id`)
1322 PRIMARY KEY (`status_idx`),
1323 KEY `word` (`word`)
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_id…
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…
1391 PRIMARY KEY (`id`),
1392 UNIQUE KEY `tko_test_labels_unique` (`name`)
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`)…
1411 …CONSTRAINT `tko_test_labels_tests_ibfk_1` FOREIGN KEY (`testlabel_id`) REFERENCES `tko_test_labels…
1412 …CONSTRAINT `tko_test_labels_tests_ibfk_2` FOREIGN KEY (`test_id`) REFERENCES `tko_tests` (`test_id…
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`…
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`) O…
1563 …CONSTRAINT `tko_tests_ibfk_2` FOREIGN KEY (`status`) REFERENCES `tko_status` (`status_idx`) ON DEL…
1564 …CONSTRAINT `tko_tests_ibfk_3` FOREIGN KEY (`machine_idx`) REFERENCES `tko_machines` (`machine_idx`…