CREATE FUNCTION GenerateGUID( pid VARCHAR(50) ) RETURNS VARCHAR(32)
BEGIN
    DECLARE temp VARCHAR(32);
    SET temp = CONCAT(temp, CHAR(pid & 0xFF));
    SET pid = pid >> 8;
    SET temp = CONCAT(temp, CHAR(pid & 0xFF));
    SET pid = pid >> 8;
    SET temp = CONCAT(temp, CHAR(pid & 0xFF));
    SET pid = pid >> 8;
    SET temp = CONCAT(temp, CHAR(pid & 0xFF));
    SET pid = pid >> 8;
    SET temp = CONCAT(temp, CHAR(pid & 0xFF));
    SET pid = pid >> 8;
    SET temp = CONCAT(temp, CHAR(pid & 0xFF));
    SET pid = pid >> 8;
    SET temp = CONCAT(temp, CHAR(pid & 0xFF));
    SET pid = pid >> 8;
    SET temp = CONCAT(temp, CHAR(pid & 0xFF));
    SET pid = pid >> 8;
    SET temp = MD5(CONCAT('BE',temp));