Table of Contents

AddTriggerColumnsToAssetTypeTaskFollowUpTaskMigration

Database Schema Description
Transaction ampc Add Trigger Columns To Asset Type Task Follow Up Task

SQL Statements


ALTER TABLE ampc.asset_type_task_follow_up_task
    ADD COLUMN trigger_when_upper_critical_exceeded boolean NOT NULL DEFAULT false,
    ADD COLUMN trigger_when_upper_warning_exceeded boolean NOT NULL DEFAULT false, 
    ADD COLUMN trigger_when_lower_critical_exceeded boolean NOT NULL DEFAULT false, 
    ADD COLUMN trigger_when_lower_warning_exceeded boolean NOT NULL DEFAULT false;