TYPE=VIEW
query=select `co-operativebank`.`sv`.`code` AS `code`,`co-operativebank`.`sv`.`amt` AS `amt`,`co-operativebank`.`sv`.`interest` AS `interest`,\'\' AS `nq`,\'\' AS `Duration`,\'\' AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank`.`sv`.`scheme` AS `Scheme` from `co-operativebank`.`sv` union all select `co-operativebank`.`fd`.`Code` AS `code`,`co-operativebank`.`fd`.`P_Amt` AS `p_amt`,`co-operativebank`.`fd`.`Interest` AS `interest`,\'\' AS `nq`,`co-operativebank`.`fd`.`Duration` AS `Duration`,`co-operativebank`.`fd`.`Durattion_D` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank`.`fd`.`scheme` AS `Scheme` from `co-operativebank`.`fd` union all select `co-operativebank`.`rd`.`code` AS `code`,`co-operativebank`.`rd`.`amt` AS `amt`,`co-operativebank`.`rd`.`interest` AS `interest`,`co-operativebank`.`rd`.`nq` AS `nq`,\'\' AS `Duration`,\'\' AS `Durattion_D`,`co-operativebank`.`rd`.`Inst` AS `Inst`,`co-operativebank`.`rd`.`scheme` AS `Scheme` from `co-operativebank`.`rd` union all select `co-operativebank`.`reinv`.`Code` AS `code`,`co-operativebank`.`reinv`.`amt` AS `amt`,`co-operativebank`.`reinv`.`interst` AS `interst`,\'\' AS `nq`,`co-operativebank`.`reinv`.`dur` AS `Duration`,`co-operativebank`.`reinv`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank`.`reinv`.`scheme` AS `Scheme` from `co-operativebank`.`reinv` union all select `co-operativebank`.`home_sv`.`Code` AS `code`,`co-operativebank`.`home_sv`.`amt` AS `amt`,`co-operativebank`.`home_sv`.`interst` AS `interst`,\'\' AS `nq`,`co-operativebank`.`home_sv`.`dur` AS `Duration`,`co-operativebank`.`home_sv`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank`.`home_sv`.`scheme` AS `Scheme` from `co-operativebank`.`home_sv` union all select `co-operativebank`.`pension`.`Code` AS `code`,`co-operativebank`.`pension`.`amt` AS `amt`,`co-operativebank`.`pension`.`interst` AS `interst`,\'\' AS `nq`,`co-operativebank`.`pension`.`dur` AS `Duration`,`co-operativebank`.`pension`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank`.`pension`.`scheme` AS `Scheme` from `co-operativebank`.`pension` union all select `co-operativebank`.`mis`.`Code` AS `code`,`co-operativebank`.`mis`.`amt` AS `amt`,`co-operativebank`.`mis`.`interst` AS `interst`,\'\' AS `nq`,`co-operativebank`.`mis`.`dur` AS `Duration`,`co-operativebank`.`mis`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank`.`mis`.`scheme` AS `Scheme` from `co-operativebank`.`mis` union all select `co-operativebank`.`other`.`Code` AS `code`,`co-operativebank`.`other`.`P_Amt` AS `p_amt`,`co-operativebank`.`other`.`Interest` AS `interest`,\'\' AS `nq`,`co-operativebank`.`other`.`Duration` AS `Duration`,`co-operativebank`.`other`.`Durattion_D` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank`.`other`.`scheme` AS `Scheme` from `co-operativebank`.`other`
md5=7b48e4ec1ed725fa3eb905dfafbb7383
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2015-12-01 04:25:58
create-version=1
source=select `sv`.`code` AS `code`,`sv`.`amt` AS `amt`,`sv`.`interest` AS `interest`,\'\' AS `nq`,\'\' AS `Duration`,\'\' AS `Durattion_D`,\'\' AS `Inst`,`sv`.`scheme` AS `Scheme` from `sv` union all select `fd`.`Code` AS `code`,`fd`.`P_Amt` AS `p_amt`,`fd`.`Interest` AS `interest`,\'\' AS `nq`,`fd`.`Duration` AS `Duration`,`fd`.`Durattion_D` AS `Durattion_D`,\'\' AS `Inst`,`fd`.`scheme` AS `Scheme` from `fd` union all select `rd`.`code` AS `code`,`rd`.`amt` AS `amt`,`rd`.`interest` AS `interest`,`rd`.`nq` AS `nq`,\'\' AS `Duration`,\'\' AS `Durattion_D`,`rd`.`Inst` AS `Inst`,`rd`.`scheme` AS `Scheme` from `rd` union all select `reinv`.`Code` AS `code`,`reinv`.`amt` AS `amt`,`reinv`.`interst` AS `interst`,\'\' AS `nq`,`reinv`.`dur` AS `Duration`,`reinv`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`reinv`.`scheme` AS `Scheme` from `reinv` union all select `home_sv`.`Code` AS `code`,`home_sv`.`amt` AS `amt`,`home_sv`.`interst` AS `interst`,\'\' AS `nq`,`home_sv`.`dur` AS `Duration`,`home_sv`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`home_sv`.`scheme` AS `Scheme` from `home_sv` union all select `pension`.`Code` AS `code`,`pension`.`amt` AS `amt`,`pension`.`interst` AS `interst`,\'\' AS `nq`,`pension`.`dur` AS `Duration`,`pension`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`pension`.`scheme` AS `Scheme` from `pension` union all select `mis`.`Code` AS `code`,`mis`.`amt` AS `amt`,`mis`.`interst` AS `interst`,\'\' AS `nq`,`mis`.`dur` AS `Duration`,`mis`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`mis`.`scheme` AS `Scheme` from `mis` union all select `other`.`Code` AS `code`,`other`.`P_Amt` AS `p_amt`,`other`.`Interest` AS `interest`,\'\' AS `nq`,`other`.`Duration` AS `Duration`,`other`.`Durattion_D` AS `Durattion_D`,\'\' AS `Inst`,`other`.`scheme` AS `Scheme` from `other`
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `co-operativebank`.`sv`.`code` AS `code`,`co-operativebank`.`sv`.`amt` AS `amt`,`co-operativebank`.`sv`.`interest` AS `interest`,\'\' AS `nq`,\'\' AS `Duration`,\'\' AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank`.`sv`.`scheme` AS `Scheme` from `co-operativebank`.`sv` union all select `co-operativebank`.`fd`.`Code` AS `code`,`co-operativebank`.`fd`.`P_Amt` AS `p_amt`,`co-operativebank`.`fd`.`Interest` AS `interest`,\'\' AS `nq`,`co-operativebank`.`fd`.`Duration` AS `Duration`,`co-operativebank`.`fd`.`Durattion_D` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank`.`fd`.`scheme` AS `Scheme` from `co-operativebank`.`fd` union all select `co-operativebank`.`rd`.`code` AS `code`,`co-operativebank`.`rd`.`amt` AS `amt`,`co-operativebank`.`rd`.`interest` AS `interest`,`co-operativebank`.`rd`.`nq` AS `nq`,\'\' AS `Duration`,\'\' AS `Durattion_D`,`co-operativebank`.`rd`.`Inst` AS `Inst`,`co-operativebank`.`rd`.`scheme` AS `Scheme` from `co-operativebank`.`rd` union all select `co-operativebank`.`reinv`.`Code` AS `code`,`co-operativebank`.`reinv`.`amt` AS `amt`,`co-operativebank`.`reinv`.`interst` AS `interst`,\'\' AS `nq`,`co-operativebank`.`reinv`.`dur` AS `Duration`,`co-operativebank`.`reinv`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank`.`reinv`.`scheme` AS `Scheme` from `co-operativebank`.`reinv` union all select `co-operativebank`.`home_sv`.`Code` AS `code`,`co-operativebank`.`home_sv`.`amt` AS `amt`,`co-operativebank`.`home_sv`.`interst` AS `interst`,\'\' AS `nq`,`co-operativebank`.`home_sv`.`dur` AS `Duration`,`co-operativebank`.`home_sv`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank`.`home_sv`.`scheme` AS `Scheme` from `co-operativebank`.`home_sv` union all select `co-operativebank`.`pension`.`Code` AS `code`,`co-operativebank`.`pension`.`amt` AS `amt`,`co-operativebank`.`pension`.`interst` AS `interst`,\'\' AS `nq`,`co-operativebank`.`pension`.`dur` AS `Duration`,`co-operativebank`.`pension`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank`.`pension`.`scheme` AS `Scheme` from `co-operativebank`.`pension` union all select `co-operativebank`.`mis`.`Code` AS `code`,`co-operativebank`.`mis`.`amt` AS `amt`,`co-operativebank`.`mis`.`interst` AS `interst`,\'\' AS `nq`,`co-operativebank`.`mis`.`dur` AS `Duration`,`co-operativebank`.`mis`.`dur_type` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank`.`mis`.`scheme` AS `Scheme` from `co-operativebank`.`mis` union all select `co-operativebank`.`other`.`Code` AS `code`,`co-operativebank`.`other`.`P_Amt` AS `p_amt`,`co-operativebank`.`other`.`Interest` AS `interest`,\'\' AS `nq`,`co-operativebank`.`other`.`Duration` AS `Duration`,`co-operativebank`.`other`.`Durattion_D` AS `Durattion_D`,\'\' AS `Inst`,`co-operativebank`.`other`.`scheme` AS `Scheme` from `co-operativebank`.`other`
