TYPE=VIEW
query=select `d`.`Date` AS `date`,`d`.`Acc_No` AS `acc_no`,`a`.`Name` AS `name`,`ba`.`text` AS `acc_type`,`d`.`Deposit_Type` AS `deposit_type`,\'Deposit\' AS `vch_type`,`d`.`Amt` AS `cr_amt`,\'0\' AS `dr_amt` from ((`co-operativebank`.`deposit` `d` join `co-operativebank`.`account` `a`) join `co-operativebank`.`bank_account` `ba`) where ((`d`.`Acc_No` = `a`.`Acc_no`) and (`ba`.`value` = `a`.`Acc_Type`) and (`d`.`status` = \'1\')) union all select `w`.`Date` AS `date`,`w`.`Acc_no` AS `acc_no`,`a`.`Name` AS `name`,`ba`.`text` AS `text`,`w`.`Withdrawl_Type` AS `withdrawl_type`,\'Withdrawl\' AS `Withdrawl`,0 AS `0`,`w`.`Amt` AS `amt` from ((`co-operativebank`.`withdrawl` `w` join `co-operativebank`.`account` `a`) join `co-operativebank`.`bank_account` `ba`) where ((`w`.`Acc_no` = `a`.`Acc_no`) and (`ba`.`value` = `a`.`Acc_Type`))
md5=46a8a8e5c634f7bd893cad0130f81916
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2015-10-12 17:31:59
create-version=1
source=select  `d`.`Date`  AS  `date` ,\n `d`.`Acc_No`  AS  `acc_no` ,\n `a`.`Name`  AS  `name` ,\n `ba`.`text`  AS  `acc_type` ,\n `d`.`Deposit_Type`  AS  `deposit_type` ,\n \'Deposit\' AS  `vch_type` ,\n `d`.`Amt`  AS  `cr_amt` ,\n \'0\' AS  `dr_amt`  from ( (  `co-operativebank`.`deposit`  `d`  join  `co-operativebank`.`account`  `a`  ) join  `co-operativebank`.`bank_account`  `ba`  ) where ( (  `d`.`Acc_No`  =  `a`.`Acc_no`  ) and (  `ba`.`value`  =  `a`.`Acc_Type`  ) and (  `d`.`status`  =  \'1\' ) ) union  all  select  `w`.`Date`  AS  `date` ,\n `w`.`Acc_no`  AS  `acc_no` ,\n `a`.`Name`  AS  `name` ,\n `ba`.`text`  AS  `text` ,\n `w`.`Withdrawl_Type`  AS  `withdrawl_type` ,\n \'Withdrawl\' AS  `Withdrawl` ,\n0 AS  `0` ,\n `w`.`Amt`  AS  `amt`  from ( (  `co-operativebank`.`withdrawl`  `w`  join  `co-operativebank`.`account`  `a`  ) join  `co-operativebank`.`bank_account`  `ba`  ) where ( (  `w`.`Acc_no`  =  `a`.`Acc_no`  ) and (  `ba`.`value`  =  `a`.`Acc_Type`  ) )
client_cs_name=utf8
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `d`.`Date` AS `date`,`d`.`Acc_No` AS `acc_no`,`a`.`Name` AS `name`,`ba`.`text` AS `acc_type`,`d`.`Deposit_Type` AS `deposit_type`,\'Deposit\' AS `vch_type`,`d`.`Amt` AS `cr_amt`,\'0\' AS `dr_amt` from ((`co-operativebank`.`deposit` `d` join `co-operativebank`.`account` `a`) join `co-operativebank`.`bank_account` `ba`) where ((`d`.`Acc_No` = `a`.`Acc_no`) and (`ba`.`value` = `a`.`Acc_Type`) and (`d`.`status` = \'1\')) union all select `w`.`Date` AS `date`,`w`.`Acc_no` AS `acc_no`,`a`.`Name` AS `name`,`ba`.`text` AS `text`,`w`.`Withdrawl_Type` AS `withdrawl_type`,\'Withdrawl\' AS `Withdrawl`,0 AS `0`,`w`.`Amt` AS `amt` from ((`co-operativebank`.`withdrawl` `w` join `co-operativebank`.`account` `a`) join `co-operativebank`.`bank_account` `ba`) where ((`w`.`Acc_no` = `a`.`Acc_no`) and (`ba`.`value` = `a`.`Acc_Type`))
