CREATE TABLE products (ID INT, Name VARCHAR(255), Amount INT, Price DECIMAL(10,2));
CREATE TABLE products_audit (ID INT, Name VARCHAR(255), Amount INT, Price DECIMAL(10,2));


CREATE TRIGGER products_inserted
AFTER INSERT ON products
FOR EACH ROW INSERT INTO products_audit (ID, Name, Amount, Price) VALUES (NEW.ID, NEW.Name, NEW.Amount, NEW.Price);


INSERT INTO products (ID, Name, Amount, Price) VALUES (1, 'TEST ONE', 10, 100.12);
INSERT INTO products (ID, Name, Amount, Price) VALUES (2, 'TEST TWO', 20, 200.12);
INSERT INTO products (ID, Name, Amount, Price) VALUES (3, 'TEST THREE', 30, 300.12);
INSERT INTO products (ID, Name, Amount, Price) VALUES (4, 'TEST FOUR', 40, 400.12);