delimiter // create trigger rekam_jurnal after insert on transaksi_tb for each row begin if new.akun='4100' then insert into pdp_tb value(new.id_transaksi, new.no_rek, new.debet, new.kredit, new.keterangan, new.bulan, new.tahun, new.ta, new.smt, new.kode_unit, new.nama_unit, new.nama_komplek, new.akun, new.no_perkiraan, new.transaksi, new.tgl_update, new.jenis_rincian, new.waktu_catat, new.user_id); else if new.akun='4200' then insert into pdp_tb value(new.id_transaksi, new.no_rek, new.debet, new.kredit, new.keterangan, new.bulan, new.tahun, new.ta, new.smt, new.kode_unit, new.nama_unit, new.nama_komplek, new.akun, new.no_perkiraan, new.transaksi, new.tgl_update, new.jenis_rincian, new.waktu_catat, new.user_id); else if new.akun='4300' then insert into pdp_tb value(new.id_transaksi, new.no_rek, new.debet, new.kredit, new.keterangan, new.bulan, new.tahun, new.ta, new.smt, new.kode_unit, new.nama_unit, new.nama_komplek, new.akun, new.no_perkiraan, new.transaksi, new.tgl_update, new.jenis_rincian, new.waktu_catat, new.user_id); else if new.akun='4400' then insert into pdp_tb value(new.id_transaksi, new.no_rek, new.debet, new.kredit, new.keterangan, new.bulan, new.tahun, new.ta, new.smt, new.kode_unit, new.nama_unit, new.nama_komplek, new.akun, new.no_perkiraan, new.transaksi, new.tgl_update, new.jenis_rincian, new.waktu_catat, new.user_id); else if new.akun='4500' then insert into pdp_tb value(new.id_transaksi, new.no_rek, new.debet, new.kredit, new.keterangan, new.bulan, new.tahun, new.ta, new.smt, new.kode_unit, new.nama_unit, new.nama_komplek, new.akun, new.no_perkiraan, new.transaksi, new.tgl_update, new.jenis_rincian, new.waktu_catat, new.user_id); else if new.akun='5100' then insert into pnl_tb value(new.id_transaksi, new.no_rek, new.debet, new.kredit, new.keterangan, new.bulan, new.tahun, new.ta, new.smt, new.kode_unit, new.nama_unit, new.nama_komplek, new.akun, new.no_perkiraan, new.transaksi, new.tgl_update, new.jenis_rincian, new.waktu_catat, new.user_id); else if new.akun='5200' then insert into pnl_tb value(new.id_transaksi, new.no_rek, new.debet, new.kredit, new.keterangan, new.bulan, new.tahun, new.ta, new.smt, new.kode_unit, new.nama_unit, new.nama_komplek, new.akun, new.no_perkiraan, new.transaksi, new.tgl_update, new.jenis_rincian, new.waktu_catat, new.user_id); else if new.akun='5300' then insert into pnl_tb value(new.id_transaksi, new.no_rek, new.debet, new.kredit, new.keterangan, new.bulan, new.tahun, new.ta, new.smt, new.kode_unit, new.nama_unit, new.nama_komplek, new.akun, new.no_perkiraan, new.transaksi, new.tgl_update, new.jenis_rincian, new.waktu_catat, new.user_id); else if new.akun='5400' then insert into pnl_tb value(new.id_transaksi, new.no_rek, new.debet, new.kredit, new.keterangan, new.bulan, new.tahun, new.ta, new.smt, new.kode_unit, new.nama_unit, new.nama_komplek, new.akun, new.no_perkiraan, new.transaksi, new.tgl_update, new.jenis_rincian, new.waktu_catat, new.user_id); else if new.akun='5500' then insert into pnl_tb value(new.id_transaksi, new.no_rek, new.debet, new.kredit, new.keterangan, new.bulan, new.tahun, new.ta, new.smt, new.kode_unit, new.nama_unit, new.nama_komplek, new.akun, new.no_perkiraan, new.transaksi, new.tgl_update, new.jenis_rincian, new.waktu_catat, new.user_id); else if new.akun='5600' then insert into pnl_tb value(new.id_transaksi, new.no_rek, new.debet, new.kredit, new.keterangan, new.bulan, new.tahun, new.ta, new.smt, new.kode_unit, new.nama_unit, new.nama_komplek, new.akun, new.no_perkiraan, new.transaksi, new.tgl_update, new.jenis_rincian, new.waktu_catat, new.user_id); else if new.akun='5700' then insert into pnl_tb value(new.id_transaksi, new.no_rek, new.debet, new.kredit, new.keterangan, new.bulan, new.tahun, new.ta, new.smt, new.kode_unit, new.nama_unit, new.nama_komplek, new.akun, new.no_perkiraan, new.transaksi, new.tgl_update, new.jenis_rincian, new.waktu_catat, new.user_id); else if new.akun='5800' then insert into pnl_tb value(new.id_transaksi, new.no_rek, new.debet, new.kredit, new.keterangan, new.bulan, new.tahun, new.ta, new.smt, new.kode_unit, new.nama_unit, new.nama_komplek, new.akun, new.no_perkiraan, new.transaksi, new.tgl_update, new.jenis_rincian, new.waktu_catat, new.user_id); else if new.akun='5900' then insert into pnl_tb value(new.id_transaksi, new.no_rek, new.debet, new.kredit, new.keterangan, new.bulan, new.tahun, new.ta, new.smt, new.kode_unit, new.nama_unit, new.nama_komplek, new.akun, new.no_perkiraan, new.transaksi, new.tgl_update, new.jenis_rincian, new.waktu_catat, new.user_id); else insert into trash_tb value(new.id_transaksi, new.no_rek, new.debet, new.kredit, new.keterangan, new.bulan, new.tahun, new.ta, new.smt, new.kode_unit, new.nama_unit, new.nama_komplek, new.akun, new.no_perkiraan, new.transaksi, new.tgl_update, new.jenis_rincian, new.waktu_catat, new.user_id); end if; end if; end if; end if; end if; end if; end if; end if; end if; end if; end if; end if; end if; end if; end; // delimiter ;