DELIMITER $$
DROP TRIGGER if exists trig_user_master_log;
CREATE TRIGGER trig_user_master_log BEFORE UPDATE ON user_master
FOR EACH ROW
BEGIN
INSERT INTO user_master_log
(user_id, user_name, user_password, user_first_name, user_last_name, user_designation, ministry_id, state_code, agency_code, user_role_id, user_mobile, user_email, user_address, user_status, sys_gen_pwd_status, login_attempt, reset_login_token, updated_by, created, updated, ip_address)
VALUES(OLD.user_id, OLD.user_name, OLD.user_password, OLD.user_first_name, OLD.user_last_name, OLD.user_designation, OLD.ministry_id, OLD.state_code, OLD.agency_code, OLD.user_role_id, OLD.user_mobile, OLD.user_email, OLD.user_address, OLD.user_status, OLD.sys_gen_pwd_status, OLD.login_attempt, OLD.reset_login_token, OLD.updated_by, OLD.created, OLD.updated, OLD.ip_address);
END$$
delimiter ;
