CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `aerion`@`localhost` 
    SQL SECURITY DEFINER
VIEW `aerion`.`vw_prosp_open_log` AS
    SELECT 
        `aerion`.`prosp_open_log`.`prosp_open_logid` AS `prosp_open_logid`,
        `aerion`.`prosp_open_log`.`idprosp_open` AS `idprosp_open`,
        `aerion`.`prosp_open_log`.`compname` AS `compname`,
        `aerion`.`prosp_open_log`.`client_name` AS `client_name`,
        `aerion`.`prosp_open_log`.`location` AS `location`,
        `aerion`.`prosp_open_log`.`contact_info` AS `contact_info`,
        `aerion`.`prosp_open_log`.`open_details` AS `open_details`,
        DATE_FORMAT(`aerion`.`prosp_open_log`.`open_dt`,
                _UTF8'%m-%d-%y') AS `open_dt`,
        DATE_FORMAT(`aerion`.`prosp_open_log`.`open_dt`,
                _UTF8'%Y-%m-%d') AS `open_dt1`,
        DATE_FORMAT(`aerion`.`prosp_open_log`.`close_dt`,
                _UTF8'%m-%d-%y') AS `close_dt`,
        DATE_FORMAT(`aerion`.`prosp_open_log`.`close_dt`,
                _UTF8'%Y-%m-%d') AS `close_dt1`,
        DATE_FORMAT(`aerion`.`prosp_open_log`.`last_update`,
                _UTF8'%m-%d-%y') AS `last_update`,
        DATE_FORMAT(`aerion`.`prosp_open_log`.`last_update`,
                _UTF8'%Y-%m-%d') AS `last_update1`,
        `aerion`.`prosp_open_log`.`updated_by` AS `updated_by`,
        (CASE
            WHEN
                (`aerion`.`prosp_open_log`.`updated_by` <> 0)
            THEN
                CONCAT(`aerion`.`emp`.`firstname`,
                        _LATIN1' ',
                        `aerion`.`emp`.`lastname`)
            ELSE 'Admin'
        END) AS `updater_name`,
        `aerion`.`prosp_open_log`.`summary` AS `summary`,
        `aerion`.`prosp_open_log`.`trans_type` AS `trans_type`
    FROM
        (`aerion`.`prosp_open_log`
        LEFT JOIN `aerion`.`emp` ON ((`aerion`.`prosp_open_log`.`updated_by` = `aerion`.`emp`.`emp_id`)))
    ORDER BY `aerion`.`prosp_open_log`.`last_update` DESC