create table bank_detail_call
(id int auto_increment primary key,
shopper_id int,
quarter int,
date date,
serial_no varchar(10),
client_open tinyint(1),
interviewer_no varchar(10),
approved tinyint(1),
approved_date datetime,
date_Insert datetime,
bankcalled int,
callcenterno varchar(10),
wday tinyint(1),
day int(2),
month int(2),
year int(4),
starttime_hr int(2),
starttime_min int(2),
start_time datetime,
endtime_hr int(2),
endtime_min int(2),
end_time datetime,
vduration_min int(4),
ms_agegrp tinyint(1),
ms_gender tinyint(1),
callpurpose tinyint(1),
callpurpose_1  varchar(50) CHARACTER SET utf8 COLLATE utf8_bin,
callpurpose_2  varchar(50) CHARACTER SET utf8 COLLATE utf8_bin,
callpurpose_3  varchar(50) CHARACTER SET utf8 COLLATE utf8_bin,
callpurpose_4  varchar(50) CHARACTER SET utf8 COLLATE utf8_bin,
callpurpose_5  varchar(50) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_1 tinyint(1),
bvar_2 tinyint(1),
bvar_3 tinyint(1),
bvar_4 tinyint(1),
bvar_5 tinyint(1),
bvar_6 tinyint(1),
bvar_7 tinyint(1),
bvar_8 tinyint(1),
bvar_9 tinyint(1),
bvar_10 tinyint(1),
bvar_11 tinyint(1),
bvar_12 tinyint(1),
bvar_13 tinyint(1),
bvar_14 tinyint(1),
bvar_15 tinyint(1),
bvar_16 tinyint(1),
bvar_17 tinyint(1),
bvar_18 tinyint(1),
bvar_19 tinyint(1),
bvar_20 varchar(5),
bvar_21 tinyint(1),
bvar_22 tinyint(1),
bvar_23 tinyint(1),
bvar_24 tinyint(1),
bvar_25_a tinyint(1),
bvar_25_b tinyint(1),
bvar_25_c tinyint(1),
bvar_26 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_27 tinyint(1),
bvar_28 tinyint(1),
bvar_29 tinyint(1),
bvar_30 tinyint(1),
bvar_31 tinyint(1),
bvar_32 tinyint(1),
bvar_33 tinyint(1),
bvar_34 tinyint(1),
bvar_35 tinyint(1),
bvar_36 tinyint(1),
bvar_37 varchar(5),
bvar_38 varchar(5),
bvar_39 varchar(5),
bvar_40 tinyint(1),
bvar_41 varchar(5),
bvar_com_1 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_2 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_3 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_4 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_5 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_6 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_7 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_8 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_9 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_10 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_11 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_12 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_13 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_14 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_15 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_16 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_17 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_18 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_19 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_21 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_22 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_23 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_24 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_25_a varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_25_b varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_25_c varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_27 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_28 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_29 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_30 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_31 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_32 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_33 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_34 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_35 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_36 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_40 varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,
score_a_point int,
score_a_allot int,
score_b_point int,
score_b_allot int,
score_c_point int,
score_c_allot int,
score_d_point int,
score_d_allot int,
score_e_point int,
score_e_allot int,
total_point int,
total_allot int,
comment1  text CHARACTER SET utf8 COLLATE utf8_bin,
comment2  text CHARACTER SET utf8 COLLATE utf8_bin);

ALTER TABLE `bank_detail_call` ADD UNIQUE `uniq` (`shopper_id`, `quarter`, `serial_no`)




create table bank_detail_check
(id int auto_increment primary key,
shopper_id int,
quarter int,
date date,
serial_no varchar(10),
client_open tinyint(1),
interviewer_no varchar(10),
approved tinyint(1),
approved_date datetime,
date_Insert datetime,
branchcode varchar(10),
branchname varchar(50),
branch_type tinyint(1),
internalcode varchar(10),
transcode varchar(10),
transtype varchar(50),
shopper_number  varchar(10),
shopper_name  varchar(50),
wday tinyint(1),
day int(2),
month int(2),
year int(4),
starttime_hr int(2),
starttime_min int(2),
start_time datetime,
endtime_hr int(2),
endtime_min int(2),
end_time datetime,
vduration_min int(4),
check_in tinyint(1),
check_out tinyint(1),
trans_1_amt decimal(12,2),
trans_2_amt decimal(12,2),
trans_3_amt decimal(12,2),
trans_4_amt decimal(12,2),
trans_5_amt decimal(12,2),
trans_6_amt decimal(12,2),
trans_7_amt decimal(12,2),
trans_8_amt decimal(12,2),
trans_9_amt decimal(12,2),
trans_10_amt decimal(12,2),
trans_11_amt decimal(12,2),
trans_12_amt decimal(12,2),
trans_13_amt decimal(12,2),
trans_1_cur decimal(12,2),
trans_2_cur decimal(12,2),
trans_3_cur decimal(12,2),
trans_4_cur decimal(12,2),
trans_5_cur decimal(12,2),
trans_6_cur decimal(12,2),
trans_7_cur decimal(12,2),
trans_8_cur decimal(12,2),
trans_9_cur decimal(12,2),
trans_10_cur decimal(12,2),
trans_11_cur decimal(12,2),
trans_12_cur decimal(12,2),
trans_13_cur decimal(12,2),
trans_1_fees decimal(12,2),
trans_2_fees decimal(12,2),
trans_3_fees decimal(12,2),
trans_4_fees decimal(12,2),
trans_5_fees decimal(12,2),
trans_6_fees decimal(12,2),
trans_7_fees decimal(12,2),
trans_8_fees decimal(12,2),
trans_9_fees decimal(12,2),
trans_10_fees decimal(12,2),
trans_11_fees decimal(12,2),
trans_12_fees decimal(12,2),
trans_13_fees decimal(12,2),
trans_1_other varchar(50),
trans_2_other varchar(50),
teller_name varchar(50),
cs_name varchar(50),
teller_sex varchar(10),
teller_len varchar(10),
teller_hair varchar(10),
teller_age varchar(10),
teller_eye varchar(10),
teller_gls varchar(10),
cs_sex varchar(10),
cs_len varchar(10),
cs_hair varchar(10),
cs_age varchar(10),
cs_eye varchar(10),
cs_gls varchar(10),
bvar_1 tinyint(1),
bvar_2 tinyint(1),
bvar_3 tinyint(1),
bvar_4 tinyint(1),
bvar_5 tinyint(1),
bvar_6 tinyint(1),
bvar_7 tinyint(1),
bvar_8_1 tinyint(1),
bvar_8_2 tinyint(1),
bvar_8_3 tinyint(1),
bvar_8_4 tinyint(1),
bvar_8_5 tinyint(1),
bvar_8_6 tinyint(1),
bvar_8_7 tinyint(1),
bvar_8_8 tinyint(1),
bvar_8_9 tinyint(1),
bvar_8_10 tinyint(1),
bvar_8_11 tinyint(1),
bvar_9_1 tinyint(1),
bvar_9_2 tinyint(1),
bvar_9_3 tinyint(1),
bvar_9_4 tinyint(1),
bvar_9_5 tinyint(1),
bvar_10_1 tinyint(1),
bvar_10_2 tinyint(1),
bvar_10_3 tinyint(1),
bvar_10_4 tinyint(1),
bvar_11_1 tinyint(1),
bvar_11_2 tinyint(1),
bvar_11_3 tinyint(1),
bvar_12_1 tinyint(1),
bvar_12_2 tinyint(1),
bvar_12_3 tinyint(1),
bvar_12_4 tinyint(1),
bvar_13_1 tinyint(1),
bvar_13_2 tinyint(1),
bvar_13_3 tinyint(1),
bvar_13_4 tinyint(1),
bvar_14_1 tinyint(1),
bvar_14_2 tinyint(1),
bvar_14_3 tinyint(1),
bvar_14_4 tinyint(1),
bvar_14_5 tinyint(1),
bvar_14_6 tinyint(1),
bvar_14_7 tinyint(1),
bvar_15_1 tinyint(1),
bvar_15_2 tinyint(1),
bvar_15_3 tinyint(1),
bvar_15_4 tinyint(1),
bvar_15_5 tinyint(1),
bvar_15_6 tinyint(1),
bvar_15_7 tinyint(1),
bvar_15_others varchar(50) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_16_1 tinyint(1),
bvar_16_2 tinyint(1),
bvar_16_3 tinyint(1),
bvar_16_4 tinyint(1),
bvar_16_5 tinyint(1),
bvar_16_6 tinyint(1),
bvar_16_7 tinyint(1),
bvar_17_1 tinyint(1),
bvar_17_2 tinyint(1),
bvar_17_3 tinyint(1),
bvar_17_4 tinyint(1),
bvar_18 tinyint(1),
bvar_19 tinyint(1),
bvar_20 tinyint(1),
bvar_21_1 tinyint(1),
bvar_21_2 tinyint(1),
bvar_21_3 tinyint(1),
bvar_21_4 tinyint(1),
bvar_22_1 tinyint(1),
bvar_22_2 tinyint(1),
bvar_22_3 tinyint(1),
bvar_23_1 tinyint(1),
bvar_23_2 tinyint(1),
bvar_23_3 tinyint(1),
bvar_24 tinyint(1),
bvar_25_1 tinyint(1),
bvar_25_2 tinyint(1),
bvar_26 tinyint(1),
bvar_27 tinyint(1),
bvar_28_1 tinyint(1),
bvar_28_2 tinyint(1),
bvar_28_3 tinyint(1),
bvar_28_4 tinyint(1),
bvar_29_1 tinyint(1),
bvar_29_2 tinyint(1),
bvar_29_3 tinyint(1),
bvar_29_4 tinyint(1),
bvar_30_1 tinyint(1),
bvar_30_2 tinyint(1),
bvar_30_3 tinyint(1),
bvar_30_4 tinyint(1),
bvar_31 tinyint(1),
bvar_32 tinyint(1),
bvar_33 varchar(50) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_34 tinyint(1),
bvar_35 tinyint(1),
bvar_36 tinyint(1),
bvar_37 tinyint(1),
bvar_38 tinyint(1),
bvar_39_1 tinyint(1),
bvar_39_2 tinyint(1),
bvar_39_3 tinyint(1),
bvar_39_4 tinyint(1),
bvar_40 tinyint(1),
bvar_41 tinyint(1),
bvar_42 tinyint(1),
bvar_43 tinyint(1),
bvar_44 tinyint(1),
bvar_45 varchar(50),
bvar_46 tinyint(1),
bvar_47_1 tinyint(1),
bvar_47_2 tinyint(1),
bvar_47_3 tinyint(1),
bvar_47_4 tinyint(1),
bvar_48 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_49 tinyint(1),
bvar_50 tinyint(1),
bvar_51 tinyint(1),
bvar_52 tinyint(1),
bvar_53 tinyint(1),
bvar_54 tinyint(1),
bvar_55 tinyint(1),
bvar_56 tinyint(1),
bvar_57 tinyint(1),
bvar_58 tinyint(1),
bvar_59 tinyint(1),
bvar_60 tinyint(1),
bvar_61 int,
bvar_62 int,
bvar_63 int,
bvar_64 varchar(50),
bvar_65 varchar(50),
bvar_66_1 tinyint(1),
bvar_66_2 tinyint(1),
bvar_66_3 tinyint(1),
bvar_66_4 tinyint(1),
bvar_67_1 tinyint(1),
bvar_67_2 tinyint(1),
bvar_67_3 tinyint(1),
bvar_67_4 tinyint(1),
bvar_68 tinyint(1),
bvar_69 tinyint(1),
bvar_70 varchar(50) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_71 tinyint(1),
bvar_72 tinyint(1),
bvar_73 tinyint(1),
bvar_74 tinyint(1),
bvar_75 tinyint(1),
bvar_76 tinyint(1),
bvar_77_1 tinyint(1),
bvar_77_2 tinyint(1),
bvar_77_3 tinyint(1),
bvar_77_4 tinyint(1),
bvar_78 tinyint(1),
bvar_79 tinyint(1),
bvar_80 tinyint(1),
bvar_81 tinyint(1),
bvar_82 tinyint(1),
bvar_83 tinyint(1),
bvar_84 tinyint(1),
bvar_85 tinyint(1),
bvar_86_1 tinyint(1),
bvar_86_2 tinyint(1),
bvar_86_3 tinyint(1),
bvar_86_4 tinyint(1),
bvar_87 tinyint(1),
bvar_88 tinyint(1),
bvar_89 tinyint(1),
bvar_90 varchar(50),
bvar_91 tinyint(1),
bvar_92 tinyint(1),
bvar_93_1 tinyint(1),
bvar_93_2 tinyint(1),
bvar_93_3 tinyint(1),
bvar_93_4 tinyint(1),
bvar_94 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_95 tinyint(1),
bvar_96 tinyint(1),
bvar_97 tinyint(1),
bvar_98 tinyint(1),
bvar_99 tinyint(1),
bvar_100 tinyint(1),
bvar_101 tinyint(1),
bvar_102 tinyint(1),
bvar_103 tinyint(1),
bvar_104 tinyint(1),
bvar_105 tinyint(1),
bvar_106 tinyint(1),
bvar_107 tinyint(1),
bvar_108 int,
bvar_109 int,
bvar_110 int,
bvar_111 varchar(50),
bvar_112 varchar(50),
bvar_com_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_5 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_6 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_7 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_8_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_8_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_8_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_8_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_8_5 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_8_6 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_8_7 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_8_8 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_8_9 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_8_10 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_8_11 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_9_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_9_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_9_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_9_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_9_5 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_10_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_10_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_10_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_10_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_11_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_11_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_11_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_12_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_12_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_12_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_12_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_13_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_13_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_13_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_13_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_14_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_14_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_14_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_14_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_14_5 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_14_6 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_14_7 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_15_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_15_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_15_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_15_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_15_5 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_15_6 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_15_7 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_16_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_16_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_16_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_16_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_16_5 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_16_6 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_16_7 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_17_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_17_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_17_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_17_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_18 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_19 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_20 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_21_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_21_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_21_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_21_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_22_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_22_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_22_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_23_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_23_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_23_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_24 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_25_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_25_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_26 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_27 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_28_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_28_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_28_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_28_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_29_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_29_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_29_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_29_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_30_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_30_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_30_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_30_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_31 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_32 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_34 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_35 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_36 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_37 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_38 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_39_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_39_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_39_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_39_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_40 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_41 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_42 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_43 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_44 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_46 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_47_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_47_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_47_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_47_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_49 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_50 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_51 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_52 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_53 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_54 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_55 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_56 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_57 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_58 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_59 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_60 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_66_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_66_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_66_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_66_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_67_1 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_67_2 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_67_3 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_67_4 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_68 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_69 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_71  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_72  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_73  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_74  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_75  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_76  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_77_1  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_77_2  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_77_3  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_77_4  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_78  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_79  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_80  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_81  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_82  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_83  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_84  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_85  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_86_1  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_86_2  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_86_3  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_86_4  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_87  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_88  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_89  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_91  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_92  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_93_1  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_93_2  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_93_3  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_93_4  varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_95 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_96 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_97 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_98 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_99 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_100 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_101 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_102 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_103 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_104 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_105 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_106 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
bvar_com_107 varchar(100) CHARACTER SET utf8 COLLATE utf8_bin,
score_a_point int,
score_a_allot int,
score_b_point int,
score_b_allot int,
score_c_point int,
score_c_allot int,
score_d_point int,
score_d_allot int,
score_e_point int,
score_e_allot int,
score_f_point int,
score_f_allot int,
score_g_point int,
score_g_allot int,
score_h_point int,
score_h_allot int,
score_i_point int,
score_i_allot int,
score_j_point int,
score_j_allot int,
score_k_point int,
score_k_allot int,
score_l_point int,
score_l_allot int,
total_point int,
total_allot int,
comment1  text CHARACTER SET utf8 COLLATE utf8_bin,
comment2  text CHARACTER SET utf8 COLLATE utf8_bin);

ALTER TABLE `bank_detail_check` ADD UNIQUE `uniq` (`shopper_id`, `quarter`, `serial_no`)

