DROP TRIGGER if EXISTS au_vitals;

CREATE TRIGGER au_vitals 
    AFTER UPDATE ON vitals
    FOR EACH ROW 
INSERT INTO vitals_audit
(vital_id, vital_module,
vital_name, measurement_unit,
description, gender_type,
is_active, is_system,
created_at, created_by)
Value( old.id, old.vital_module,
old.vital_name, old.measurement_unit,
old.description, old.gender_type,
old.is_active, old.is_system,
CURRENT_TIMESTAMP, new.updated_by);
