await db.transaction(async (tx) => {
tx.run(sql`
CREATE TRIGGER IF NOT EXISTS TRG_CT_INSERT_BACKUP
AFTER INSERT ON CauThu
BEGIN
INSERT INTO CauThuBackup(modifiedDate, maCT, tenCT, ngaySinh, loaiCT, ghiChu, nuocNgoai)
VALUES(datetime('now'), NEW.maCT, NEW.tenCT, NEW.ngaySinh, NEW.loaiCT, NEW.ghiChu, NEW.nuocNgoai);
END
`);
});
await db.transaction(async (tx) => {
tx.run(sql`
CREATE TRIGGER IF NOT EXISTS TRG_CT_INSERT_BACKUP
AFTER INSERT ON CauThu
BEGIN
INSERT INTO CauThuBackup(modifiedDate, maCT, tenCT, ngaySinh, loaiCT, ghiChu, nuocNgoai)
VALUES(datetime('now'), NEW.maCT, NEW.tenCT, NEW.ngaySinh, NEW.loaiCT, NEW.ghiChu, NEW.nuocNgoai);
END
`);
});