TYPE=VIEW
query=select `db_account_9793090153`.`tbl_batch_type`.`ba_type_key` AS `ba_list_type`,`db_account_9793090153`.`tbl_batch_type`.`ba_type_id` AS `ba_type_id`,`db_account_9793090153`.`tbl_batch_type`.`ba_type_const` AS `ba_type_const`,`db_account_9793090153`.`tbl_batch_type`.`ba_type_name` AS `ba_type_name` from `db_account_9793090153`.`tbl_batch_type` union all select 4 AS `ba_list_type`,`db_account_9793090153`.`tbl_invoice_type`.`in_type_id` AS `in_type_id`,`db_account_9793090153`.`tbl_invoice_type`.`in_type_const` AS `in_type_const`,`db_account_9793090153`.`tbl_invoice_type`.`in_type_name` AS `in_type_name` from `db_account_9793090153`.`tbl_invoice_type` union all select 12 AS `ba_list_type`,`db_account_9793090153`.`tbl_note_type`.`note_type_id` AS `note_type_id`,`db_account_9793090153`.`tbl_note_type`.`note_type_const` AS `note_type_const`,`db_account_9793090153`.`tbl_note_type`.`note_type_name` AS `note_type_name` from `db_account_9793090153`.`tbl_note_type` union all select 23 AS `ba_list_type`,`db_account_9793090153`.`tbl_installment_type`.`nt_type_id` AS `nt_type_id`,`db_account_9793090153`.`tbl_installment_type`.`nt_type_const` AS `nt_type_const`,`db_account_9793090153`.`tbl_installment_type`.`nt_type_name` AS `nt_type_name` from `db_account_9793090153`.`tbl_installment_type`
md5=16c1f25016af49bb08dab29b42e278a7
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 `tbl_batch_type`.`ba_type_key` AS `ba_list_type`,`tbl_batch_type`.`ba_type_id` AS `ba_type_id`,`tbl_batch_type`.`ba_type_const` AS `ba_type_const`,`tbl_batch_type`.`ba_type_name` AS `ba_type_name` from `tbl_batch_type` union all select 4 AS `ba_list_type`,`tbl_invoice_type`.`in_type_id` AS `in_type_id`,`tbl_invoice_type`.`in_type_const` AS `in_type_const`,`tbl_invoice_type`.`in_type_name` AS `in_type_name` from `tbl_invoice_type` union all select 12 AS `ba_list_type`,`tbl_note_type`.`note_type_id` AS `note_type_id`,`tbl_note_type`.`note_type_const` AS `note_type_const`,`tbl_note_type`.`note_type_name` AS `note_type_name` from `tbl_note_type` union all select 23 AS `ba_list_type`,`tbl_installment_type`.`nt_type_id` AS `nt_type_id`,`tbl_installment_type`.`nt_type_const` AS `nt_type_const`,`tbl_installment_type`.`nt_type_name` AS `nt_type_name` from `tbl_installment_type`
client_cs_name=cp1256
connection_cl_name=cp1256_general_ci
view_body_utf8=select `db_account_9793090153`.`tbl_batch_type`.`ba_type_key` AS `ba_list_type`,`db_account_9793090153`.`tbl_batch_type`.`ba_type_id` AS `ba_type_id`,`db_account_9793090153`.`tbl_batch_type`.`ba_type_const` AS `ba_type_const`,`db_account_9793090153`.`tbl_batch_type`.`ba_type_name` AS `ba_type_name` from `db_account_9793090153`.`tbl_batch_type` union all select 4 AS `ba_list_type`,`db_account_9793090153`.`tbl_invoice_type`.`in_type_id` AS `in_type_id`,`db_account_9793090153`.`tbl_invoice_type`.`in_type_const` AS `in_type_const`,`db_account_9793090153`.`tbl_invoice_type`.`in_type_name` AS `in_type_name` from `db_account_9793090153`.`tbl_invoice_type` union all select 12 AS `ba_list_type`,`db_account_9793090153`.`tbl_note_type`.`note_type_id` AS `note_type_id`,`db_account_9793090153`.`tbl_note_type`.`note_type_const` AS `note_type_const`,`db_account_9793090153`.`tbl_note_type`.`note_type_name` AS `note_type_name` from `db_account_9793090153`.`tbl_note_type` union all select 23 AS `ba_list_type`,`db_account_9793090153`.`tbl_installment_type`.`nt_type_id` AS `nt_type_id`,`db_account_9793090153`.`tbl_installment_type`.`nt_type_const` AS `nt_type_const`,`db_account_9793090153`.`tbl_installment_type`.`nt_type_name` AS `nt_type_name` from `db_account_9793090153`.`tbl_installment_type`
