asd

CREATE TRIGGER insert_trigger
BEFORE INSERT ON klienci
FOR EACH ROW
BEGIN
DECLARE numer_id VARCHAR(100);
SET numer_id = CONCAT("dodano rekord o id: ", NEW.id);
INSERT INTO logs VALUES (NULL, numer_id, GETDATE());
END


CREATE TRIGGER delete_trigger
BEFORE DELETE ON klienci
FOR EACH ROW
BEGIN
DECLARE numer_id VARCHAR(100);
SET numer_id = CONCAT("usunięto rekord o id: ", OLD.id);
INSERT INTO logs VALUES (NULL, numer_id, GETDATE());
END