DROP TRIGGER if EXISTS au_doctors;

CREATE TRIGGER au_doctors
    AFTER UPDATE ON doctors
    FOR EACH ROW 
INSERT INTO doctors_audit
(doctor_id_pk, doctor_id, doctor_name, prnt_name,
qualification, dept_id, sub_dept_id, specialty_id,
dob, gender, phone_no, reg_no, pan_no, attached_with,
is_doctor, doc_type, ip_applicable, ip_pay_mode, 
visit_charge, ipd_charge, hos_share, share_mode, share_rate,
is_registration_applicable, registration_charge, reff_by,
is_active, created_at, created_by)
Value( old.id, old.doctor_id, old.doctor_name, old.prnt_name,
old.qualification, old.dept_id, old.sub_dept_id, old.specialty_id,
old.dob, old.gender, old.phone_no, old.reg_no, old.pan_no, old.attached_with,
old.is_doctor, old.doc_type, old.ip_applicable, old.ip_pay_mode, 
old.visit_charge, old.ipd_charge, old.hos_share, old.share_mode, old.share_rate,
old.is_registration_applicable, old.registration_charge, old.reff_by,
old.is_active, CURRENT_TIMESTAMP, new.updated_by);

