OLD | NEW |
1 -- MySQL dump 10.11 | 1 -- MySQL dump 10.11 |
2 -- | 2 -- |
3 -- Host: localhost Database: autotest_web | 3 -- Host: localhost Database: autotest_web |
4 -- ------------------------------------------------------ | 4 -- ------------------------------------------------------ |
5 -- Server version 5.0.51a-3ubuntu5.5-log | 5 -- Server version 5.0.51a-3ubuntu5.5-log |
6 | 6 |
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; | 7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; | 8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; | 9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
10 /*!40101 SET NAMES utf8 */; | 10 /*!40101 SET NAMES utf8 */; |
(...skipping 1259 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
1270 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | 1270 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
1271 SET character_set_client = @saved_cs_client; | 1271 SET character_set_client = @saved_cs_client; |
1272 | 1272 |
1273 -- | 1273 -- |
1274 -- Final view structure for view `tko_perf_view` | 1274 -- Final view structure for view `tko_perf_view` |
1275 -- | 1275 -- |
1276 | 1276 |
1277 /*!50001 DROP TABLE `tko_perf_view`*/; | 1277 /*!50001 DROP TABLE `tko_perf_view`*/; |
1278 /*!50001 DROP VIEW IF EXISTS `tko_perf_view`*/; | 1278 /*!50001 DROP VIEW IF EXISTS `tko_perf_view`*/; |
1279 /*!50001 CREATE ALGORITHM=UNDEFINED */ | 1279 /*!50001 CREATE ALGORITHM=UNDEFINED */ |
1280 /*!50013 DEFINER=`%(username)s`@`localhost` SQL SECURITY DEFINER */ | 1280 /*!50013 DEFINER=CURRENT_USER SQL SECURITY DEFINER */ |
1281 /*!50001 VIEW `tko_perf_view` AS select `tko_tests`.`test_idx` AS `test_idx`,`tk
o_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_i
dx`,`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 `j
ob_label`,`tko_jobs`.`username` AS `job_username`,`tko_jobs`.`queued_time` AS `j
ob_queued_time`,`tko_jobs`.`started_time` AS `job_started_time`,`tko_jobs`.`fini
shed_time` AS `job_finished_time`,`tko_machines`.`hostname` AS `machine_hostname
`,`tko_machines`.`machine_group` AS `machine_group`,`tko_machines`.`owner` AS `m
achine_owner`,`tko_kernels`.`kernel_hash` AS `kernel_hash`,`tko_kernels`.`base`
AS `kernel_base`,`tko_kernels`.`printable` AS `kernel_printable`,`tko_status`.`w
ord` AS `status_word`,`tko_iteration_result`.`iteration` AS `iteration`,`tko_ite
ration_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`))) */; | 1281 /*!50001 VIEW `tko_perf_view` AS select `tko_tests`.`test_idx` AS `test_idx`,`tk
o_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_i
dx`,`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 `j
ob_label`,`tko_jobs`.`username` AS `job_username`,`tko_jobs`.`queued_time` AS `j
ob_queued_time`,`tko_jobs`.`started_time` AS `job_started_time`,`tko_jobs`.`fini
shed_time` AS `job_finished_time`,`tko_machines`.`hostname` AS `machine_hostname
`,`tko_machines`.`machine_group` AS `machine_group`,`tko_machines`.`owner` AS `m
achine_owner`,`tko_kernels`.`kernel_hash` AS `kernel_hash`,`tko_kernels`.`base`
AS `kernel_base`,`tko_kernels`.`printable` AS `kernel_printable`,`tko_status`.`w
ord` AS `status_word`,`tko_iteration_result`.`iteration` AS `iteration`,`tko_ite
ration_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`))) */; |
1282 | 1282 |
1283 -- | 1283 -- |
1284 -- Final view structure for view `tko_perf_view_2` | 1284 -- Final view structure for view `tko_perf_view_2` |
1285 -- | 1285 -- |
1286 | 1286 |
1287 /*!50001 DROP TABLE `tko_perf_view_2`*/; | 1287 /*!50001 DROP TABLE `tko_perf_view_2`*/; |
1288 /*!50001 DROP VIEW IF EXISTS `tko_perf_view_2`*/; | 1288 /*!50001 DROP VIEW IF EXISTS `tko_perf_view_2`*/; |
1289 /*!50001 CREATE ALGORITHM=UNDEFINED */ | 1289 /*!50001 CREATE ALGORITHM=UNDEFINED */ |
1290 /*!50013 DEFINER=`%(username)s`@`localhost` SQL SECURITY DEFINER */ | 1290 /*!50013 DEFINER=CURRENT_USER SQL SECURITY DEFINER */ |
1291 /*!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`.`statu
s` 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`.`fi
nished_time` AS `test_finished_time`,`tko_jobs`.`tag` AS `job_tag`,`tko_jobs`.`l
abel` 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 `ke
rnel_base`,`tko_kernels`.`printable` AS `kernel`,`tko_status`.`word` AS `status`
,`tko_iteration_result`.`iteration` AS `iteration`,`tko_iteration_result`.`attri
bute` AS `iteration_key`,`tko_iteration_result`.`value` AS `iteration_value` fro
m (((((`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_job
s`.`machine_idx`))) left join `tko_kernels` on((`tko_kernels`.`kernel_idx` = `tk
o_tests`.`kernel_idx`))) left join `tko_status` on((`tko_status`.`status_idx` =
`tko_tests`.`status`))) left join `tko_iteration_result` on((`tko_iteration_resu
lt`.`test_idx` = `tko_tests`.`test_idx`))) */; | 1291 /*!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`.`statu
s` 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`.`fi
nished_time` AS `test_finished_time`,`tko_jobs`.`tag` AS `job_tag`,`tko_jobs`.`l
abel` 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 `ke
rnel_base`,`tko_kernels`.`printable` AS `kernel`,`tko_status`.`word` AS `status`
,`tko_iteration_result`.`iteration` AS `iteration`,`tko_iteration_result`.`attri
bute` AS `iteration_key`,`tko_iteration_result`.`value` AS `iteration_value` fro
m (((((`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_job
s`.`machine_idx`))) left join `tko_kernels` on((`tko_kernels`.`kernel_idx` = `tk
o_tests`.`kernel_idx`))) left join `tko_status` on((`tko_status`.`status_idx` =
`tko_tests`.`status`))) left join `tko_iteration_result` on((`tko_iteration_resu
lt`.`test_idx` = `tko_tests`.`test_idx`))) */; |
1292 | 1292 |
1293 -- | 1293 -- |
1294 -- Final view structure for view `tko_test_view` | 1294 -- Final view structure for view `tko_test_view` |
1295 -- | 1295 -- |
1296 | 1296 |
1297 /*!50001 DROP TABLE `tko_test_view`*/; | 1297 /*!50001 DROP TABLE `tko_test_view`*/; |
1298 /*!50001 DROP VIEW IF EXISTS `tko_test_view`*/; | 1298 /*!50001 DROP VIEW IF EXISTS `tko_test_view`*/; |
1299 /*!50001 CREATE ALGORITHM=UNDEFINED */ | 1299 /*!50001 CREATE ALGORITHM=UNDEFINED */ |
1300 /*!50013 DEFINER=`%(username)s`@`localhost` SQL SECURITY DEFINER */ | 1300 /*!50013 DEFINER=CURRENT_USER SQL SECURITY DEFINER */ |
1301 /*!50001 VIEW `tko_test_view` AS select `tko_tests`.`test_idx` AS `test_idx`,`tk
o_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_i
dx`,`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 `j
ob_label`,`tko_jobs`.`username` AS `job_username`,`tko_jobs`.`queued_time` AS `j
ob_queued_time`,`tko_jobs`.`started_time` AS `job_started_time`,`tko_jobs`.`fini
shed_time` AS `job_finished_time`,`tko_machines`.`hostname` AS `machine_hostname
`,`tko_machines`.`machine_group` AS `machine_group`,`tko_machines`.`owner` AS `m
achine_owner`,`tko_kernels`.`kernel_hash` AS `kernel_hash`,`tko_kernels`.`base`
AS `kernel_base`,`tko_kernels`.`printable` AS `kernel_printable`,`tko_status`.`w
ord` AS `status_word` from ((((`tko_tests` join `tko_jobs` on((`tko_jobs`.`job_i
dx` = `tko_tests`.`job_idx`))) join `tko_machines` on((`tko_machines`.`machine_i
dx` = `tko_jobs`.`machine_idx`))) join `tko_kernels` on((`tko_kernels`.`kernel_i
dx` = `tko_tests`.`kernel_idx`))) join `tko_status` on((`tko_status`.`status_idx
` = `tko_tests`.`status`))) */; | 1301 /*!50001 VIEW `tko_test_view` AS select `tko_tests`.`test_idx` AS `test_idx`,`tk
o_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_i
dx`,`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 `j
ob_label`,`tko_jobs`.`username` AS `job_username`,`tko_jobs`.`queued_time` AS `j
ob_queued_time`,`tko_jobs`.`started_time` AS `job_started_time`,`tko_jobs`.`fini
shed_time` AS `job_finished_time`,`tko_machines`.`hostname` AS `machine_hostname
`,`tko_machines`.`machine_group` AS `machine_group`,`tko_machines`.`owner` AS `m
achine_owner`,`tko_kernels`.`kernel_hash` AS `kernel_hash`,`tko_kernels`.`base`
AS `kernel_base`,`tko_kernels`.`printable` AS `kernel_printable`,`tko_status`.`w
ord` AS `status_word` from ((((`tko_tests` join `tko_jobs` on((`tko_jobs`.`job_i
dx` = `tko_tests`.`job_idx`))) join `tko_machines` on((`tko_machines`.`machine_i
dx` = `tko_jobs`.`machine_idx`))) join `tko_kernels` on((`tko_kernels`.`kernel_i
dx` = `tko_tests`.`kernel_idx`))) join `tko_status` on((`tko_status`.`status_idx
` = `tko_tests`.`status`))) */; |
1302 | 1302 |
1303 -- | 1303 -- |
1304 -- Final view structure for view `tko_test_view_2` | 1304 -- Final view structure for view `tko_test_view_2` |
1305 -- | 1305 -- |
1306 | 1306 |
1307 /*!50001 DROP TABLE `tko_test_view_2`*/; | 1307 /*!50001 DROP TABLE `tko_test_view_2`*/; |
1308 /*!50001 DROP VIEW IF EXISTS `tko_test_view_2`*/; | 1308 /*!50001 DROP VIEW IF EXISTS `tko_test_view_2`*/; |
1309 /*!50001 CREATE ALGORITHM=UNDEFINED */ | 1309 /*!50001 CREATE ALGORITHM=UNDEFINED */ |
1310 /*!50013 DEFINER=`%(username)s`@`localhost` SQL SECURITY DEFINER */ | 1310 /*!50013 DEFINER=CURRENT_USER SQL SECURITY DEFINER */ |
1311 /*!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`.`statu
s` 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`.`fi
nished_time` AS `test_finished_time`,`tko_jobs`.`tag` AS `job_tag`,`tko_jobs`.`l
abel` 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_machines`.`hostname` AS `hostname`,`tko_machines`.`machine_group` AS `plat
form`,`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_m
achines`.`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`))) */; | 1311 /*!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`.`statu
s` 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`.`fi
nished_time` AS `test_finished_time`,`tko_jobs`.`tag` AS `job_tag`,`tko_jobs`.`l
abel` 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_machines`.`hostname` AS `hostname`,`tko_machines`.`machine_group` AS `plat
form`,`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_m
achines`.`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`))) */; |
1312 | 1312 |
1313 -- | 1313 -- |
1314 -- Final view structure for view `tko_test_view_outer_joins` | 1314 -- Final view structure for view `tko_test_view_outer_joins` |
1315 -- | 1315 -- |
1316 | 1316 |
1317 /*!50001 DROP TABLE `tko_test_view_outer_joins`*/; | 1317 /*!50001 DROP TABLE `tko_test_view_outer_joins`*/; |
1318 /*!50001 DROP VIEW IF EXISTS `tko_test_view_outer_joins`*/; | 1318 /*!50001 DROP VIEW IF EXISTS `tko_test_view_outer_joins`*/; |
1319 /*!50001 CREATE ALGORITHM=UNDEFINED */ | 1319 /*!50001 CREATE ALGORITHM=UNDEFINED */ |
1320 /*!50013 DEFINER=`%(username)s`@`localhost` SQL SECURITY DEFINER */ | 1320 /*!50013 DEFINER=CURRENT_USER SQL SECURITY DEFINER */ |
1321 /*!50001 VIEW `tko_test_view_outer_joins` AS select `tko_tests`.`test_idx` AS `t
est_idx`,`tko_tests`.`job_idx` AS `job_idx`,`tko_tests`.`test` AS `test_name`,`t
ko_tests`.`subdir` AS `subdir`,`tko_tests`.`kernel_idx` AS `kernel_idx`,`tko_tes
ts`.`status` AS `status_idx`,`tko_tests`.`reason` AS `reason`,`tko_tests`.`machi
ne_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`,`tk
o_jobs`.`label` AS `job_name`,`tko_jobs`.`username` AS `job_owner`,`tko_jobs`.`q
ueued_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` A
S `machine_owner`,`tko_kernels`.`kernel_hash` AS `kernel_hash`,`tko_kernels`.`ba
se` AS `kernel_base`,`tko_kernels`.`printable` AS `kernel`,`tko_status`.`word` A
S `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_id
x` = `tko_jobs`.`machine_idx`))) left join `tko_kernels` on((`tko_kernels`.`kern
el_idx` = `tko_tests`.`kernel_idx`))) left join `tko_status` on((`tko_status`.`s
tatus_idx` = `tko_tests`.`status`))) */; | 1321 /*!50001 VIEW `tko_test_view_outer_joins` AS select `tko_tests`.`test_idx` AS `t
est_idx`,`tko_tests`.`job_idx` AS `job_idx`,`tko_tests`.`test` AS `test_name`,`t
ko_tests`.`subdir` AS `subdir`,`tko_tests`.`kernel_idx` AS `kernel_idx`,`tko_tes
ts`.`status` AS `status_idx`,`tko_tests`.`reason` AS `reason`,`tko_tests`.`machi
ne_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`,`tk
o_jobs`.`label` AS `job_name`,`tko_jobs`.`username` AS `job_owner`,`tko_jobs`.`q
ueued_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` A
S `machine_owner`,`tko_kernels`.`kernel_hash` AS `kernel_hash`,`tko_kernels`.`ba
se` AS `kernel_base`,`tko_kernels`.`printable` AS `kernel`,`tko_status`.`word` A
S `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_id
x` = `tko_jobs`.`machine_idx`))) left join `tko_kernels` on((`tko_kernels`.`kern
el_idx` = `tko_tests`.`kernel_idx`))) left join `tko_status` on((`tko_status`.`s
tatus_idx` = `tko_tests`.`status`))) */; |
1322 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; | 1322 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
1323 | 1323 |
1324 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; | 1324 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
1325 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; | 1325 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
1326 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; | 1326 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
1327 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; | 1327 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
1328 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; | 1328 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
1329 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; | 1329 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
1330 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; | 1330 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
1331 | 1331 |
1332 -- Dump completed on 2010-03-09 21:20:11 | 1332 -- Dump completed on 2010-03-09 21:20:11 |
OLD | NEW |