TYPE=VIEW
query=select `loansatm`.`date` AS `date`,`loansatm`.`openBal` AS `openBal`,\'0\' AS `LoanIssue`,\'0\' AS `LoanCollection`,\'0\' AS `InstAmt` from `co-operativebank-kutubpur`.`loansatm` union all select `loansatm2`.`date` AS `date`,\'0\' AS `openBal`,`loansatm2`.`LoanIssue` AS `LoanIssue`,`loansatm2`.`LoanCollection` AS `LoanCollection`,\'0\' AS `InstAmt` from `co-operativebank-kutubpur`.`loansatm2` union all select `loansatm1`.`date` AS `date`,\'0\' AS `openBal`,\'0\' AS `LoanIssue`,\'0\' AS `LoanCollection`,`loansatm1`.`InstAmt` AS `InstAmt` from `co-operativebank-kutubpur`.`loansatm1`
md5=ec2fcfa5096a1623b44ba7c75525b33b
updatable=0
algorithm=0
definer_user=admin
definer_host=localhost
suid=2
with_check_option=0
timestamp=2026-02-17 12:00:10
create-version=1
source=select  date, openBal, \'0\' as LoanIssue,\'0\' as LoanCollection, \'0\' as InstAmt from loansatm union all select date,\'0\' as openBal,LoanIssue,LoanCollection,\'0\' as InstAmt from loansatm2  union all select  date,\'0\' as openBal,\'0\' as LoanIssue,\'0\' as LoanCollection, InstAmt from loansatm1
client_cs_name=utf8mb4
connection_cl_name=utf8mb4_general_ci
view_body_utf8=select `loansatm`.`date` AS `date`,`loansatm`.`openBal` AS `openBal`,\'0\' AS `LoanIssue`,\'0\' AS `LoanCollection`,\'0\' AS `InstAmt` from `co-operativebank-kutubpur`.`loansatm` union all select `loansatm2`.`date` AS `date`,\'0\' AS `openBal`,`loansatm2`.`LoanIssue` AS `LoanIssue`,`loansatm2`.`LoanCollection` AS `LoanCollection`,\'0\' AS `InstAmt` from `co-operativebank-kutubpur`.`loansatm2` union all select `loansatm1`.`date` AS `date`,\'0\' AS `openBal`,\'0\' AS `LoanIssue`,\'0\' AS `LoanCollection`,`loansatm1`.`InstAmt` AS `InstAmt` from `co-operativebank-kutubpur`.`loansatm1`
