mysql> show create view view_payment \G
*************************** 1. row ***************************
                View: view_payment
         Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`ehofmann`@`macehofmann-wlan.gs.activate.de` SQL SECURITY DEFINER VIEW `view_payment` AS select `payment`.`payment_id` AS `payment_id`,`payment`.`booking_id` AS `booking_id`,`payment`.`owner` AS `owner`,`payment`.`method` AS `method`,`payment`.`cc_type` AS `cc_type`,if(((`payment`.`method` = _latin1'CC') and ((`payment`.`cc_number` is not null) or (`payment`.`cc_number` <> _latin1''))),concat(_latin1'************',substr(`payment`.`cc_number`,12,4)),_latin1'') AS `IF(method = 'CC' AND (cc_number IS NOT NULL OR cc_number != ''),CONCAT('************',SUBSTR(cc_number,12,4)),'')`,`payment`.`cc_cvc2` AS `cc_cvc2`,`payment`.`cc_valid` AS `cc_valid`,`payment`.`bank_code` AS `bank_code`,`payment`.`bank_name` AS `bank_name`,if(((`payment`.`method` <> _latin1'CC') and ((`payment`.`bank_account` is not null) or (`payment`.`bank_account` <> _latin1''))),concat(_latin1'**',substr(`payment`.`bank_account`,3,3),_latin1'****'),_latin1'') AS `IF(method != 'CC' AND (bank_account IS NOT NULL OR bank_account != ''),CONCAT('**',SUBSTR(bank_account,3,3), '****'),'')`,`payment`.`amount` AS `amount`,`payment`.`cc_fee` AS `cc_fee`,`payment`.`update_ok` AS `update_ok` from `payment`
character_set_client: utf8
collation_connection: utf8_general_ci
