|
|
|
-- Job Arranger upgrade table SQL for MySQL (Ver 6.0.3) - 2023/09/15 -
|
|
|
|
-- Copyright (C) 2012-2014 FitechForce, Inc. All Rights Reserved.
|
|
-- Copyright (C) 2013 Daiwa Institute of Research Business Innovation Ltd. All Rights Reserved.
|
|
|
|
CREATE INDEX `ja_run_job_idx3` ON `ja_run_job_table` (`job_type`, `status`);
|
|
CREATE INDEX `ja_run_icon_job_idx1` ON `ja_run_icon_job_table` (`host_flag`, `host_name`);
|
|
CREATE UNIQUE INDEX `ja_run_icon_job_idx2` ON `ja_run_icon_job_table` (`inner_job_id`, `host_flag`);
|
|
CREATE UNIQUE INDEX `ja_run_value_before_idx2` ON `ja_run_value_before_table` (`inner_job_id`, `value_name`, `seq_no`);
|
|
CREATE UNIQUE INDEX `ja_run_icon_reboot_idx2` ON `ja_run_icon_reboot_table` (`inner_job_id`, `host_flag`);
|