TriggerEq1

/*
TRIGGER COMBOS
*/

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

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

/*
TRIGGER PRODUCTS
*/

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

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

/*
TRIGGER PRODUCTSCATEGORIES
*/

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

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