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`)
61 UNIQUE KEY `acl_groups_hosts_both_ids` (`aclgroup_id`,`host_id`),
62 KEY `acl_groups_hosts_host_id` (`host_id`),
63 …CONSTRAINT `acl_groups_hosts_aclgroup_id_fk` FOREIGN KEY (`aclgroup_id`) REFERENCES `afe_acl_group…
64 …CONSTRAINT `acl_groups_hosts_host_id_fk` FOREIGN KEY (`host_id`) REFERENCES `afe_hosts` (`id`) ON …
78 UNIQUE KEY `acl_groups_users_both_ids` (`aclgroup_id`,`user_id`),
79 KEY `acl_groups_users_user_id` (`user_id`),
80 …CONSTRAINT `acl_groups_users_aclgroup_id_fk` FOREIGN KEY (`aclgroup_id`) REFERENCES `afe_acl_group…
81 …CONSTRAINT `acl_groups_users_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `afe_users` (`id`) ON …
98 PRIMARY KEY (`id`),
99 UNIQUE KEY `name` (`name`)
124 PRIMARY KEY (`id`)
139 PRIMARY KEY (`id`),
140 UNIQUE KEY `test_id` (`test_id`,`label_id`),
141 KEY `autotests_dependency_labels_label_id_fk` (`label_id`),
142 …CONSTRAINT `autotests_dependency_labels_label_id_fk` FOREIGN KEY (`label_id`) REFERENCES `afe_labe…
143 …CONSTRAINT `autotests_dependency_labels_test_id_fk` FOREIGN KEY (`test_id`) REFERENCES `afe_autote…
159 PRIMARY KEY (`id`),
160 KEY `host_id` (`host_id`),
161 KEY `attribute` (`attribute`),
162 CONSTRAINT `afe_host_attributes_ibfk_1` FOREIGN KEY (`host_id`) REFERENCES `afe_hosts` (`id`)
186 PRIMARY KEY (`id`),
187 UNIQUE KEY `host_queue_entries_job_id_and_host_id` (`job_id`,`host_id`),
188 KEY `host_queue_entries_host_id` (`host_id`),
189 KEY `host_queue_entries_meta_host` (`meta_host`),
190 KEY `atomic_group_id` (`atomic_group_id`),
191 …CONSTRAINT `afe_host_queue_entries_ibfk_1` FOREIGN KEY (`atomic_group_id`) REFERENCES `afe_atomic_…
192 …CONSTRAINT `host_queue_entries_host_id_fk` FOREIGN KEY (`host_id`) REFERENCES `afe_hosts` (`id`) O…
193 …CONSTRAINT `host_queue_entries_job_id_fk` FOREIGN KEY (`job_id`) REFERENCES `afe_jobs` (`id`) ON D…
194 …CONSTRAINT `host_queue_entries_meta_host_fk` FOREIGN KEY (`meta_host`) REFERENCES `afe_labels` (`i…
216 PRIMARY KEY (`id`),
217 KEY `hosts_locked_by_fk` (`locked_by_id`),
218 …CONSTRAINT `hosts_locked_by_fk` FOREIGN KEY (`locked_by_id`) REFERENCES `afe_users` (`id`) ON DELE…
232 UNIQUE KEY `hosts_labels_both_ids` (`label_id`,`host_id`),
233 KEY `hosts_labels_host_id` (`host_id`),
234 …CONSTRAINT `hosts_labels_host_id_fk` FOREIGN KEY (`host_id`) REFERENCES `afe_hosts` (`id`) ON DELE…
235 …CONSTRAINT `hosts_labels_label_id_fk` FOREIGN KEY (`label_id`) REFERENCES `afe_labels` (`id`) ON D…
250 PRIMARY KEY (`id`),
251 UNIQUE KEY `ineligible_host_queues_both_ids` (`host_id`,`job_id`),
252 KEY `ineligible_host_queues_job_id` (`job_id`),
253 …CONSTRAINT `ineligible_host_queues_host_id_fk` FOREIGN KEY (`host_id`) REFERENCES `afe_hosts` (`id…
254 …CONSTRAINT `ineligible_host_queues_job_id_fk` FOREIGN KEY (`job_id`) REFERENCES `afe_jobs` (`id`) …
270 PRIMARY KEY (`id`),
271 KEY `afe_job_keyvals_job_id` (`job_id`),
272 KEY `afe_job_keyvals_key` (`key`),
273 …CONSTRAINT `afe_job_keyvals_ibfk_1` FOREIGN KEY (`job_id`) REFERENCES `afe_jobs` (`id`) ON DELETE …
300 PRIMARY KEY (`id`)
315 PRIMARY KEY (`id`),
316 UNIQUE KEY `job_id` (`job_id`,`label_id`),
317 KEY `jobs_dependency_labels_label_id_fk` (`label_id`),
318 …CONSTRAINT `jobs_dependency_labels_job_id_fk` FOREIGN KEY (`job_id`) REFERENCES `afe_jobs` (`id`) …
319 …CONSTRAINT `jobs_dependency_labels_label_id_fk` FOREIGN KEY (`label_id`) REFERENCES `afe_labels` (…
338 PRIMARY KEY (`id`),
339 UNIQUE KEY `name` (`name`),
340 KEY `atomic_group_id` (`atomic_group_id`),
341 …CONSTRAINT `afe_labels_ibfk_1` FOREIGN KEY (`atomic_group_id`) REFERENCES `afe_atomic_groups` (`id…
356 PRIMARY KEY (`id`),
357 UNIQUE KEY `name` (`name`)
375 PRIMARY KEY (`id`),
376 KEY `recurring_run_job_id` (`job_id`),
377 KEY `recurring_run_owner_id` (`owner_id`),
378 …CONSTRAINT `recurring_run_job_id_fk` FOREIGN KEY (`job_id`) REFERENCES `afe_jobs` (`id`) ON DELETE…
379 …CONSTRAINT `recurring_run_owner_id_fk` FOREIGN KEY (`owner_id`) REFERENCES `afe_users` (`id`) ON D…
401 PRIMARY KEY (`id`),
402 KEY `special_tasks_host_id` (`host_id`),
403 KEY `special_tasks_host_queue_entry_id` (`queue_entry_id`),
404 KEY `special_tasks_requested_by_id` (`requested_by_id`),
405 …CONSTRAINT `special_tasks_requested_by_id` FOREIGN KEY (`requested_by_id`) REFERENCES `afe_users` …
406 CONSTRAINT `special_tasks_to_hosts_ibfk` FOREIGN KEY (`host_id`) REFERENCES `afe_hosts` (`id`),
407 …CONSTRAINT `special_tasks_to_host_queue_entries_ibfk` FOREIGN KEY (`queue_entry_id`) REFERENCES `a…
425 PRIMARY KEY (`id`)
442 PRIMARY KEY (`id`),
443 KEY `planner_autoprocess_plan_id` (`plan_id`),
444 CONSTRAINT `autoprocess_plan_id_fk` FOREIGN KEY (`plan_id`) REFERENCES `planner_plans` (`id`)
459 PRIMARY KEY (`id`),
460 UNIQUE KEY `autoprocess_id` (`autoprocess_id`,`bug_id`),
461 KEY `autoprocess_bugs_bug_id_fk` (`bug_id`),
462 …CONSTRAINT `autoprocess_bugs_autoprocess_id_fk` FOREIGN KEY (`autoprocess_id`) REFERENCES `planner…
463 CONSTRAINT `autoprocess_bugs_bug_id_fk` FOREIGN KEY (`bug_id`) REFERENCES `planner_bugs` (`id`)
478 PRIMARY KEY (`id`),
479 UNIQUE KEY `autoprocess_id` (`autoprocess_id`,`keyval_id`),
480 KEY `autoprocess_keyvals_keyval_id_fk` (`keyval_id`),
481 …CONSTRAINT `autoprocess_keyvals_autoprocess_id_fk` FOREIGN KEY (`autoprocess_id`) REFERENCES `plan…
482 …CONSTRAINT `autoprocess_keyvals_keyval_id_fk` FOREIGN KEY (`keyval_id`) REFERENCES `planner_keyval…
497 PRIMARY KEY (`id`),
498 UNIQUE KEY `autoprocess_id` (`autoprocess_id`,`testlabel_id`),
499 KEY `autoprocess_labels_testlabel_id_fk` (`testlabel_id`),
500 …CONSTRAINT `autoprocess_labels_autoprocess_id_fk` FOREIGN KEY (`autoprocess_id`) REFERENCES `plann…
501 …CONSTRAINT `autoprocess_labels_testlabel_id_fk` FOREIGN KEY (`testlabel_id`) REFERENCES `tko_test_…
515 PRIMARY KEY (`id`),
516 UNIQUE KEY `external_uid` (`external_uid`)
531 PRIMARY KEY (`id`),
532 KEY `planner_custom_queries_plan_id` (`plan_id`),
533 CONSTRAINT `custom_queries_plan_id_fk` FOREIGN KEY (`plan_id`) REFERENCES `planner_plans` (`id`)
548 PRIMARY KEY (`id`)
569 PRIMARY KEY (`id`),
570 KEY `planner_history_plan_id` (`plan_id`),
571 KEY `planner_history_user_id` (`user_id`),
572 KEY `planner_history_data_type_id` (`data_type_id`),
573 …CONSTRAINT `history_data_type_id_fk` FOREIGN KEY (`data_type_id`) REFERENCES `planner_data_types` …
574 CONSTRAINT `history_plan_id_fk` FOREIGN KEY (`plan_id`) REFERENCES `planner_plans` (`id`),
575 CONSTRAINT `history_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `afe_users` (`id`)
593 PRIMARY KEY (`id`),
594 KEY `planner_hosts_plan_id` (`plan_id`),
595 KEY `planner_hosts_host_id` (`host_id`),
596 CONSTRAINT `hosts_host_id_fk` FOREIGN KEY (`host_id`) REFERENCES `afe_hosts` (`id`),
597 CONSTRAINT `hosts_plan_id_fk` FOREIGN KEY (`plan_id`) REFERENCES `planner_plans` (`id`)
613 PRIMARY KEY (`id`),
614 UNIQUE KEY `the_hash` (`the_hash`)
629 PRIMARY KEY (`id`),
630 KEY `plan_host_labels_plan_id_fk` (`plan_id`),
631 KEY `plan_host_labels_label_id_fk` (`label_id`),
632 CONSTRAINT `plan_host_labels_label_id_fk` FOREIGN KEY (`label_id`) REFERENCES `afe_labels` (`id`),
633 CONSTRAINT `plan_host_labels_plan_id_fk` FOREIGN KEY (`plan_id`) REFERENCES `planner_plans` (`id`)
648 PRIMARY KEY (`id`),
649 UNIQUE KEY `plan_id` (`plan_id`,`user_id`),
650 KEY `plan_owners_user_id_fk` (`user_id`),
651 CONSTRAINT `plan_owners_plan_id_fk` FOREIGN KEY (`plan_id`) REFERENCES `planner_plans` (`id`),
652 CONSTRAINT `plan_owners_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `afe_users` (`id`)
671 PRIMARY KEY (`id`),
672 UNIQUE KEY `name` (`name`)
689 PRIMARY KEY (`id`),
690 UNIQUE KEY `user_id` (`user_id`,`type`,`name`),
691 KEY `planner_saved_objects_user_id` (`user_id`),
692 CONSTRAINT `saved_objects_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `afe_users` (`id`)
711 PRIMARY KEY (`id`),
712 UNIQUE KEY `tests_plan_id_alias_unique` (`plan_id`,`alias`),
713 KEY `planner_tests_plan_id` (`plan_id`),
714 KEY `planner_tests_control_file_id` (`control_file_id`),
715 …CONSTRAINT `tests_control_file_id_fk` FOREIGN KEY (`control_file_id`) REFERENCES `planner_test_con…
716 CONSTRAINT `tests_plan_id_fk` FOREIGN KEY (`plan_id`) REFERENCES `planner_plans` (`id`)
731 PRIMARY KEY (`id`),
732 UNIQUE KEY `the_hash` (`the_hash`)
748 PRIMARY KEY (`id`),
749 KEY `planner_test_jobs_plan_id` (`plan_id`),
750 KEY `planner_test_jobs_afe_job_id` (`afe_job_id`),
751 KEY `planner_test_jobs_test_config_id` (`test_config_id`),
752 CONSTRAINT `test_jobs_afe_job_id_fk` FOREIGN KEY (`afe_job_id`) REFERENCES `afe_jobs` (`id`),
753 CONSTRAINT `test_jobs_plan_id_fk` FOREIGN KEY (`plan_id`) REFERENCES `planner_plans` (`id`),
754 …CONSTRAINT `test_jobs_test_config_id_fk` FOREIGN KEY (`test_config_id`) REFERENCES `planner_test_c…
769 PRIMARY KEY (`id`),
770 UNIQUE KEY `testrun_id` (`testrun_id`,`bug_id`),
771 KEY `test_run_bugs_bug_id_fk` (`bug_id`),
772 CONSTRAINT `test_run_bugs_bug_id_fk` FOREIGN KEY (`bug_id`) REFERENCES `planner_bugs` (`id`),
773 …CONSTRAINT `test_run_bugs_testrun_id_fk` FOREIGN KEY (`testrun_id`) REFERENCES `planner_test_runs`…
794 PRIMARY KEY (`id`),
795 UNIQUE KEY `test_runs_unique` (`plan_id`,`test_job_id`,`tko_test_id`,`host_id`),
796 KEY `planner_test_runs_plan_id` (`plan_id`),
797 KEY `planner_test_runs_test_job_id` (`test_job_id`),
798 KEY `planner_test_runs_tko_test_id` (`tko_test_id`),
799 KEY `test_runs_host_id_fk` (`host_id`),
800 CONSTRAINT `test_runs_host_id_fk` FOREIGN KEY (`host_id`) REFERENCES `planner_hosts` (`id`),
801 CONSTRAINT `test_runs_plan_id_fk` FOREIGN KEY (`plan_id`) REFERENCES `planner_plans` (`id`),
802 …CONSTRAINT `test_runs_test_job_id_fk` FOREIGN KEY (`test_job_id`) REFERENCES `planner_test_jobs` (…
803 …CONSTRAINT `test_runs_tko_test_id_fk` FOREIGN KEY (`tko_test_id`) REFERENCES `tko_tests` (`test_id…
822 PRIMARY KEY (`id`),
823 KEY `url_token` (`url_token`(128))
839 KEY `test_idx` (`test_idx`),
840 …CONSTRAINT `tko_iteration_attributes_ibfk_1` FOREIGN KEY (`test_idx`) REFERENCES `tko_tests` (`tes…
856 KEY `test_idx` (`test_idx`),
857 KEY `attribute` (`attribute`),
858 KEY `value` (`value`),
859 …CONSTRAINT `tko_iteration_result_ibfk_1` FOREIGN KEY (`test_idx`) REFERENCES `tko_tests` (`test_id…
875 PRIMARY KEY (`id`),
876 KEY `tko_job_keyvals_job_id` (`job_id`),
877 KEY `tko_job_keyvals_key` (`key`),
878 …CONSTRAINT `tko_job_keyvals_ibfk_1` FOREIGN KEY (`job_id`) REFERENCES `tko_jobs` (`job_idx`) ON DE…
899 PRIMARY KEY (`job_idx`),
900 UNIQUE KEY `tag` (`tag`),
901 KEY `label` (`label`),
902 KEY `username` (`username`),
903 KEY `machine_idx` (`machine_idx`),
904 KEY `afe_job_id` (`afe_job_id`),
905 …CONSTRAINT `tko_jobs_ibfk_1` FOREIGN KEY (`machine_idx`) REFERENCES `tko_machines` (`machine_idx`)…
921 PRIMARY KEY (`kernel_idx`),
922 KEY `printable` (`printable`)
938 PRIMARY KEY (`machine_idx`),
939 UNIQUE KEY `hostname` (`hostname`)
955 KEY `kernel_idx` (`kernel_idx`),
956 …CONSTRAINT `tko_patches_ibfk_1` FOREIGN KEY (`kernel_idx`) REFERENCES `tko_kernels` (`kernel_idx`)…
1057 PRIMARY KEY (`id`)
1071 PRIMARY KEY (`status_idx`),
1072 KEY `word` (`word`)
1100 PRIMARY KEY (`id`),
1101 KEY `test_idx` (`test_idx`),
1102 KEY `attribute` (`attribute`),
1103 KEY `value` (`value`(767)),
1104 …CONSTRAINT `tko_test_attributes_ibfk_1` FOREIGN KEY (`test_idx`) REFERENCES `tko_tests` (`test_idx…
1119 PRIMARY KEY (`id`)
1134 PRIMARY KEY (`id`),
1135 UNIQUE KEY `testlabel_id` (`testlabel_id`,`test_id`),
1136 KEY `test_labels_tests_test_id` (`test_id`),
1137 …CONSTRAINT `tests_labels_tests_ibfk_1` FOREIGN KEY (`testlabel_id`) REFERENCES `tko_test_labels` (…
1138 CONSTRAINT `tests_labels_tests_ibfk_2` FOREIGN KEY (`test_id`) REFERENCES `tko_tests` (`test_idx`)
1258 PRIMARY KEY (`test_idx`),
1259 KEY `kernel_idx` (`kernel_idx`),
1260 KEY `status` (`status`),
1261 KEY `machine_idx` (`machine_idx`),
1262 KEY `job_idx` (`job_idx`),
1263 KEY `reason` (`reason`(767)),
1264 KEY `test` (`test`),
1265 KEY `subdir` (`subdir`),
1266 CONSTRAINT `tests_to_jobs_ibfk` FOREIGN KEY (`job_idx`) REFERENCES `tko_jobs` (`job_idx`),
1267 …CONSTRAINT `tko_tests_ibfk_1` FOREIGN KEY (`kernel_idx`) REFERENCES `tko_kernels` (`kernel_idx`) O…
1268 …CONSTRAINT `tko_tests_ibfk_2` FOREIGN KEY (`status`) REFERENCES `tko_status` (`status_idx`) ON DEL…
1269 …CONSTRAINT `tko_tests_ibfk_3` FOREIGN KEY (`machine_idx`) REFERENCES `tko_machines` (`machine_idx`…