-- ------------------------------
-- UPDATE TABLES FOR Legacy Risk Management 
-- ------------------------------
ALTER TABLE sod_workflow
ADD violation_id INT;

ALTER TABLE sod_preventive_check_violation
ADD legacy_violation BOOLEAN DEFAULT FALSE;

ALTER TABLE sod_preventive_check_violation
ADD created_timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;

ALTER TABLE sod_approved_user 
ADD timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;