-- Schema [ireland]
--
--
-- Table [districts]
-- INSERT
--
-- DROP TRIGGER if exists `trgInsdistricts`;
DELIMITER $$
Create trigger trgInsdistricts
BEFORE INSERT on ireland.districts
FOR EACH ROW
BEGIN
Insert into webreporter.DatabaseAudit (AuditTime,DatabaseUser,AuditType,AuditFunction,AuditTable,AuditColumn,OldValue,NewValue) values (CURRENT_TIMESTAMP(), USER(), 'TRIGGER','INSERT', 'districts','DistrictID','',NEW.DistrictID);
Insert into webreporter.DatabaseAudit (AuditTime,DatabaseUser,AuditType,AuditFunction,AuditTable,AuditColumn,OldValue,NewValue) values (CURRENT_TIMESTAMP(), USER(), 'TRIGGER','INSERT', 'districts','DistrictName','',NEW.DistrictName);
Insert into webreporter.DatabaseAudit (AuditTime,DatabaseUser,AuditType,AuditFunction,AuditTable,AuditColumn,OldValue,NewValue) values (CURRENT_TIMESTAMP(), USER(), 'TRIGGER','INSERT', 'districts','DistrictRep','',NEW.DistrictRep);
End;
$$
-- UPDATE
--
-- DROP TRIGGER if exists trgUpddistricts;
Create trigger trgUpddistricts
BEFORE UPDATE on ireland.districts
FOR EACH ROW
BEGIN
Insert into webreporter.DatabaseAudit (AuditTime,DatabaseUser,AuditType,AuditFunction,AuditTable,AuditColumn,OldValue,NewValue) values (CURRENT_TIMESTAMP(), USER(), 'TRIGGER','UPDATE', 'districts','DistrictID',OLD.DistrictID,NEW.DistrictID);
Insert into webreporter.DatabaseAudit (AuditTime,DatabaseUser,AuditType,AuditFunction,AuditTable,AuditColumn,OldValue,NewValue) values (CURRENT_TIMESTAMP(), USER(), 'TRIGGER','UPDATE', 'districts','DistrictName',OLD.DistrictName,NEW.DistrictName);
Insert into webreporter.DatabaseAudit (AuditTime,DatabaseUser,AuditType,AuditFunction,AuditTable,AuditColumn,OldValue,NewValue) values (CURRENT_TIMESTAMP(), USER(), 'TRIGGER','UPDATE', 'districts','DistrictRep',OLD.DistrictRep,NEW.DistrictRep);
End;
$$
-- DELETE
--
-- DROP TRIGGER trgDeldistricts;
Create trigger trgDeldistricts
BEFORE DELETE on ireland.districts
FOR EACH ROW
BEGIN
Insert into webreporter.DatabaseAudit (AuditTime,DatabaseUser,AuditType,AuditFunction,AuditTable,AuditColumn,OldValue,NewValue) values (CURRENT_TIMESTAMP(), USER(), 'TRIGGER','DELETE', 'districts','DistrictID',OLD.DistrictID,'');
Insert into webreporter.DatabaseAudit (AuditTime,DatabaseUser,AuditType,AuditFunction,AuditTable,AuditColumn,OldValue,NewValue) values (CURRENT_TIMESTAMP(), USER(), 'TRIGGER','DELETE', 'districts','DistrictName',OLD.DistrictName,'');
Insert into webreporter.DatabaseAudit (AuditTime,DatabaseUser,AuditType,AuditFunction,AuditTable,AuditColumn,OldValue,NewValue) values (CURRENT_TIMESTAMP(), USER(), 'TRIGGER','DELETE', 'districts','DistrictRep',OLD.DistrictRep,'');
End;
$$
DELIMITER ;