TriggersEq3

/*
TRIGGER EMPLOYEES
*/

DELIMITER #
CREATE TRIGGER insert_uuid_Employees
BEFORE INSERT ON Employees
FOR EACH  ROW
BEGIN
    SET NEW._UUID = UUID();
END;
#
DELIMITER ;

DELIMITER #
CREATE TRIGGER modify_date_Employees
BEFORE UPDATE ON Employees
FOR EACH ROW
BEGIN
    SET NEW.__ModificationTime = current_timestamp();
END
#
DELIMITER ;

/*
TRIGGER EMPLOYEETYPES
*/

DELIMITER #
CREATE TRIGGER insert_uuid_EmployeeTypes
BEFORE INSERT ON EmployeeTypes
FOR EACH  ROW
BEGIN
    SET NEW._UUID = UUID();
END;
#
DELIMITER ;

DELIMITER #
CREATE TRIGGER modify_date_EmployeeTypes
BEFORE UPDATE ON EmployeeTypes
FOR EACH ROW
BEGIN
    SET NEW.__ModificationTime = current_timestamp();
END
#
DELIMITER ;

/*
TRIGGER PURCHASEORDERS
*/

DELIMITER #
CREATE TRIGGER insert_uuid_PurchaseOrders
BEFORE INSERT ON PurchaseOrders
FOR EACH  ROW
BEGIN
    SET NEW._UUID = UUID();
END;
#
DELIMITER ;

DELIMITER #
CREATE TRIGGER modify_date_PurchaseOrders
BEFORE UPDATE ON PurchaseOrders
FOR EACH ROW
BEGIN
    SET NEW.__ModificationTime = current_timestamp();
END
#
DELIMITER ;

/*
TRIGGER PURCHASEORDERDETAILS
*/

DELIMITER #
CREATE TRIGGER insert_uuid_PurchaseOrderDetails
BEFORE INSERT ON PurchaseOrderDetails
FOR EACH  ROW
BEGIN
    SET NEW._UUID = UUID();
END;
#
DELIMITER ;

DELIMITER #
CREATE TRIGGER modify_date_PurchaseOrderDetails
BEFORE UPDATE ON PurchaseOrderDetails
FOR EACH ROW
BEGIN
    SET NEW.__ModificationTime = current_timestamp();
END
#
DELIMITER ;