AddWMSystemOptionsForAutoCalculateEstimatedDowntimesMigration
| Database |
Schema |
Description |
| Transaction |
wm |
Add system options for auto calculation of estimated downtimes and durations |
SQL Statements
ALTER TABLE wm.module_option
ADD COLUMN auto_calculate_estimated_downtime_for_scheduled_work_orders bool NOT NULL DEFAULT true,
ADD COLUMN auto_calculate_estimated_downtime_for_manual_work_orders bool NOT NULL DEFAULT true,
ADD COLUMN auto_calculate_estimated_downtime_for_follow_up_work_orders bool NOT NULL DEFAULT true,
ADD COLUMN auto_calculate_estimated_duration_for_scheduled_work_orders bool NOT NULL DEFAULT true,
ADD COLUMN auto_calculate_estimated_duration_for_manual_work_orders bool NOT NULL DEFAULT true,
ADD COLUMN auto_calculate_estimated_duration_for_follow_up_work_orders bool NOT NULL DEFAULT true;