TYPE=VIEW
query=select 0 AS `ac_id`,\'\' AS `ac_name` union all select `db_account_9793090153`.`tbl_account`.`ac_id` AS `ac_id`,concat(`db_account_9793090153`.`tbl_account`.`ac_code`,\' - \',`db_account_9793090153`.`tbl_account`.`ac_name`) AS `ac_name` from `db_account_9793090153`.`tbl_account` where (`db_account_9793090153`.`tbl_account`.`ac_branch_type` = 1) union all select `db_account_9793090153`.`tbl_account`.`ac_id` AS `ac_id`,concat(`db_account_9793090153`.`tbl_account`.`ac_name`,\' - \',`db_account_9793090153`.`tbl_account`.`ac_code`) AS `ac_name` from `db_account_9793090153`.`tbl_account` where (`db_account_9793090153`.`tbl_account`.`ac_branch_type` = 1) order by `ac_name`
md5=01ac90b61c9171225e2069aadce238e8
updatable=0
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2014-01-01 21:20:11
create-version=1
source=select 0 AS `ac_id`,\'\' AS `ac_name` union all select `tbl_account`.`ac_id` AS `ac_id`,concat(`tbl_account`.`ac_code`,\' - \',`tbl_account`.`ac_name`) AS `ac_name` from `tbl_account` where (`tbl_account`.`ac_branch_type` = 1) union all select `tbl_account`.`ac_id` AS `ac_id`,concat(`tbl_account`.`ac_name`,\' - \',`tbl_account`.`ac_code`) AS `ac_name` from `tbl_account` where (`tbl_account`.`ac_branch_type` = 1) order by `ac_name`
client_cs_name=cp1256
connection_cl_name=cp1256_general_ci
view_body_utf8=select 0 AS `ac_id`,\'\' AS `ac_name` union all select `db_account_9793090153`.`tbl_account`.`ac_id` AS `ac_id`,concat(`db_account_9793090153`.`tbl_account`.`ac_code`,\' - \',`db_account_9793090153`.`tbl_account`.`ac_name`) AS `ac_name` from `db_account_9793090153`.`tbl_account` where (`db_account_9793090153`.`tbl_account`.`ac_branch_type` = 1) union all select `db_account_9793090153`.`tbl_account`.`ac_id` AS `ac_id`,concat(`db_account_9793090153`.`tbl_account`.`ac_name`,\' - \',`db_account_9793090153`.`tbl_account`.`ac_code`) AS `ac_name` from `db_account_9793090153`.`tbl_account` where (`db_account_9793090153`.`tbl_account`.`ac_branch_type` = 1) order by `ac_name`
