AFTER Triggers

CREATE TABLE Employees (
    EmpID INT AUTO_INCREMENT PRIMARY KEY,
    Name VARCHAR(100),
    Position VARCHAR(100),
    Salary DECIMAL(10, 2)
);

CREATE TABLE EmployeeAudit (
    AuditID INT AUTO_INCREMENT PRIMARY KEY,
    EmpID INT,
    AuditAction VARCHAR(50),
    AuditTime DATETIME
);

DELIMITER //

CREATE TRIGGER trgAfterInsert
AFTER INSERT ON Employees
FOR EACH ROW
BEGIN
    INSERT INTO EmployeeAudit (EmpID, AuditAction, AuditTime)
    VALUES (NEW.EmpID, 'INSERT', NOW());
END;
//

DELIMITER ;

DELIMITER //

CREATE TRIGGER trgAfterDelete
AFTER DELETE ON Employees
FOR EACH ROW
BEGIN
    INSERT INTO EmployeeAudit (EmpID, AuditAction, AuditTime)
    VALUES (OLD.EmpID, 'DELETE', NOW());
END;
//

DELIMITER ;