构造一个触发器audit_log

CREATE TABLE employees_test(
ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR(50),
SALARY REAL
);
CREATE TABLE audit(
EMP_no INT NOT NULL,
NAME TEXT NOT NULL
);

create trigger audit_log
    after insert
    on employees_test
    -- for each row
begin
    insert into audit values (new.ID,new.NAME);
end;

create trigger audit_log
    after insert
    on employees_test
    for each row
begin
    insert into audit values (new.ID,new.NAME);
end;