TYPE=VIEW
query=select `db_account_9793090153`.`tbl_item_class`.`cl_id` AS `cl_id`,`db_account_9793090153`.`tbl_item_class`.`cl_id_parent` AS `cl_id_parent`,`db_account_9793090153`.`tbl_item_class`.`cl_code` AS `cl_code`,`db_account_9793090153`.`tbl_item_class`.`cl_name` AS `cl_name` from `db_account_9793090153`.`tbl_item_class` union all select (`db_account_9793090153`.`tbl_item`.`it_id` * -(1)) AS `it_id`,`db_account_9793090153`.`tbl_item`.`it_id_class` AS `it_id_class`,`db_account_9793090153`.`tbl_item`.`it_code` AS `it_code`,`db_account_9793090153`.`tbl_item`.`it_name` AS `it_name` from `db_account_9793090153`.`tbl_item`
md5=942b9fd48ba07f852bc4289a7e930a8d
updatable=0
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2014-01-01 21:20:12
create-version=1
source=select `tbl_item_class`.`cl_id` AS `cl_id`,`tbl_item_class`.`cl_id_parent` AS `cl_id_parent`,`tbl_item_class`.`cl_code` AS `cl_code`,`tbl_item_class`.`cl_name` AS `cl_name` from `tbl_item_class` union all select (`tbl_item`.`it_id` * -(1)) AS `it_id`,`tbl_item`.`it_id_class` AS `it_id_class`,`tbl_item`.`it_code` AS `it_code`,`tbl_item`.`it_name` AS `it_name` from `tbl_item`
client_cs_name=cp1256
connection_cl_name=cp1256_general_ci
view_body_utf8=select `db_account_9793090153`.`tbl_item_class`.`cl_id` AS `cl_id`,`db_account_9793090153`.`tbl_item_class`.`cl_id_parent` AS `cl_id_parent`,`db_account_9793090153`.`tbl_item_class`.`cl_code` AS `cl_code`,`db_account_9793090153`.`tbl_item_class`.`cl_name` AS `cl_name` from `db_account_9793090153`.`tbl_item_class` union all select (`db_account_9793090153`.`tbl_item`.`it_id` * -(1)) AS `it_id`,`db_account_9793090153`.`tbl_item`.`it_id_class` AS `it_id_class`,`db_account_9793090153`.`tbl_item`.`it_code` AS `it_code`,`db_account_9793090153`.`tbl_item`.`it_name` AS `it_name` from `db_account_9793090153`.`tbl_item`
