Trigger phpmyadmin

Lisa tabelid trigger jaoks:

CREATE TABLE logitabel(
    id INT PRIMARY KEY AUTO_INCREMENT,
    toiming TEXT,
    aeg DATETIME,
    autoAndmed TEXT
);

CREATE TABLE Avtoregistr(
    id INT PRIMARY KEY AUTO_INCREMENT,
    aeg DATETIME,
    owner TEXT
)

LISA TRIGGER:

insert into avtoregistr(aeg, owner)
VALUES ( (NOW()), 'Vadim Serv' );

KUSTUTA TRIGGER:

delete from avtoregistr where id = 1;

UUENDATUD TRIGGER:

UPDATE avtoregistr SET owner = 'Val tor' WHERE ID=2