CREATE TABLE PriceLogs (
    id INT AUTO_INCREMENT,
    productCode VARCHAR(15) NOT NULL,
    price DECIMAL(10,2) NOT NULL,
    username varchar(64) NOT NULL,#  <------------?
    hostname varchar(64) NOT NULL DEFAULT 'XEZ', # <----?
    updated_at TIMESTAMP NOT NULL 	DEFAULT CURRENT_TIMESTAMP 
            ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (id),
    FOREIGN KEY (productCode)
        REFERENCES products (productCode)
        ON DELETE CASCADE 
        ON UPDATE CASCADE
);

DELIMITER $$

CREATE TRIGGER before_products_update 
   BEFORE UPDATE ON products 
   FOR EACH ROW 
BEGIN
DECLARE vuser varchar(64);
 set vuser:=user(); 
 set @vhozt:=CONCAT(@@hostname,':',cast(@@port as char));
 IF OLD.msrp <> NEW.msrp 
 THEN
	 INSERT INTO PriceLOgs(productCode,price, username, hstname)
	 VALUES(old.productCode,old.msrp, vuser,@vhozt);
 END IF;
END$$

DELIMITER ;