プロジェクト

全般

プロフィール

ダウンロード (744 Bytes)

その他問い合わせ #3710 » MySQL_JA_UPGRADE_TABLE-6.0.3.sql

保守サポート 担当2, 2023/11/21 21:18

 

-- 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`);
    (1-1/1)