, , No Comments
INSERT , UPDATE , DELETE PADA TABEL BELI :

$delimiter
create trigger penjualan.before_insert_beli before insert on
penjualan.beli
for each row begin
insert into log(keterangan,waktu,user_id) values
(concat('Panambahan data pada tabel beli id_beli = ',new.id_beli),now(),user());
end;

$delimiter
create trigger penjualan.before_update_beli before update on
penjualan.beli
for each row begin
insert into log(keterangan,waktu,user_id) values
(concat('Pengubahan data pada tabel beli id_beli = ',new.id_beli),now(),user());
end;

$delimiter
create trigger penjualan.before_delete_beli before delete on
penjualan.beli
for each row begin
insert into log(keterangan,waktu,user_id) values
(concat('Penghapusan data pada tabel beli id_beli = ',old.id_beli),now(),user());
end;

INSERT , UPDATE , DELETE PADA TABEL JUAL :

$delimiter
create trigger penjualan.before_insert_jual before insert on
penjualan.jual
for each row begin
insert into log(keterangan,waktu,user_id) values
(concat('Panambahan data pada tabel beli id_jual = ',new.id_jual),now(),user());
end;

$delimiter
create trigger penjualan.before_update_jual before update on
penjualan.jual
for each row begin
insert into log(keterangan,waktu,user_id) values
(concat('Pengubahan data pada tabel beli id_jual = ',new.id_jual),now(),user());
end;

$delimiter
create trigger penjualan.before_delete_jual before delete on
penjualan.jual
for each row begin
insert into log(keterangan,waktu,user_id) values
(concat('Penghapusan data pada tabel beli id_beli = ',old.id_jual),now(),user());
end;

0 komentar:

Posting Komentar