/*
SQLyog Ultimate v12.09 (64 bit)
MySQL - 5.6.23-log 
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;

create table `questionnaire` (
	`id` int (11),
	`ip_address` varchar (300),
	`country_id` varchar (300),
	`currency_id` varchar (300),
	`dom_spend_vol` int (100),
	`dom_trans_no` int (100),
	`int_spend_vol` int (100),
	`int_trans_no` int (100),
	`hotel_spend_vol` int (100),
	`hotel_trans_no` int (100),
	`other_spend_vol` int (100),
	`other_trans_no` int (100),
	`misc_spend_vol` int (100),
	`misc_trans_no` int (100),
	`airlineDomestic` varchar (765),
	`airlineInternational` varchar (765),
	`dom_city_pair` varchar (765),
	`int_city_pair` varchar (765),
	`percentage_cancellation` int (100),
	`int_travel_percentage` int (100),
	`airline_consolidators_use` varchar (300),
	`payment` varchar (300),
	`usa_canada_spend` int (100),
	`south_east_asia_spend` int (100),
	`aus_newzealand_spend` int (100),
	`middle_east_spend` int (100),
	`others_spend` int (100),
	`hostel_consolidators` varchar (300),
	`retail_plans` varchar (300),
	`foreign_exchange` varchar (300),
	`refund_processing_days` varchar (300),
	`car_rental_contract` varchar (300),
	`remark` varchar (765),
	`corporate_deals` varchar (300),
	`TIMESTAMP` datetime ,
	`hotel_destination` varchar (765)
); 
insert into `questionnaire` (`id`, `ip_address`, `country_id`, `currency_id`, `dom_spend_vol`, `dom_trans_no`, `int_spend_vol`, `int_trans_no`, `hotel_spend_vol`, `hotel_trans_no`, `other_spend_vol`, `other_trans_no`, `misc_spend_vol`, `misc_trans_no`, `airlineDomestic`, `airlineInternational`, `dom_city_pair`, `int_city_pair`, `percentage_cancellation`, `int_travel_percentage`, `airline_consolidators_use`, `payment`, `usa_canada_spend`, `south_east_asia_spend`, `aus_newzealand_spend`, `middle_east_spend`, `others_spend`, `hostel_consolidators`, `retail_plans`, `foreign_exchange`, `refund_processing_days`, `car_rental_contract`, `remark`, `corporate_deals`, `TIMESTAMP`, `hotel_destination`) values('1','::1','1','1','12','11','12','12','12','12','12','12','12','12','airindia,indigo,jetlite','bangkokairways,bhutanairline,blueair','MAA-BLR,HYD-DEL,KLH-HYD','IN-AU,IN-EG,IN-HK','30','30','yes','yes','20','20','20','20','20','yes','combination','no','+14','day_usage','remarlk','','2019-07-08 12:32:05',NULL);
insert into `questionnaire` (`id`, `ip_address`, `country_id`, `currency_id`, `dom_spend_vol`, `dom_trans_no`, `int_spend_vol`, `int_trans_no`, `hotel_spend_vol`, `hotel_trans_no`, `other_spend_vol`, `other_trans_no`, `misc_spend_vol`, `misc_trans_no`, `airlineDomestic`, `airlineInternational`, `dom_city_pair`, `int_city_pair`, `percentage_cancellation`, `int_travel_percentage`, `airline_consolidators_use`, `payment`, `usa_canada_spend`, `south_east_asia_spend`, `aus_newzealand_spend`, `middle_east_spend`, `others_spend`, `hostel_consolidators`, `retail_plans`, `foreign_exchange`, `refund_processing_days`, `car_rental_contract`, `remark`, `corporate_deals`, `TIMESTAMP`, `hotel_destination`) values('2','::1','1','1','100','100','100','100','100','100','100','100','100','100','airindia,jetlite,spicejet','bhutanairline,blueair,chinaairline','BOM-HYD,MAA-BLR,HYD-DEL','IN-CA,IN-EG,IN-HK','20','20','yes','yes','20','20','20','20','20','yes','combination','no','7-14','day_usage','REMARK','no','2019-07-08 12:40:36',NULL);
insert into `questionnaire` (`id`, `ip_address`, `country_id`, `currency_id`, `dom_spend_vol`, `dom_trans_no`, `int_spend_vol`, `int_trans_no`, `hotel_spend_vol`, `hotel_trans_no`, `other_spend_vol`, `other_trans_no`, `misc_spend_vol`, `misc_trans_no`, `airlineDomestic`, `airlineInternational`, `dom_city_pair`, `int_city_pair`, `percentage_cancellation`, `int_travel_percentage`, `airline_consolidators_use`, `payment`, `usa_canada_spend`, `south_east_asia_spend`, `aus_newzealand_spend`, `middle_east_spend`, `others_spend`, `hostel_consolidators`, `retail_plans`, `foreign_exchange`, `refund_processing_days`, `car_rental_contract`, `remark`, `corporate_deals`, `TIMESTAMP`, `hotel_destination`) values('3','::1','1','1','100','100','100','100','100','100','100','100','100','100','airindia,jetlite,spicejet','bangkokairways,bhutanairline,chinaairline','DEL-BLR,MAA-BLR,KLH-HYD','IN-AU,IN-EG,IN-HK','20','20','yes','yes','20','20','20','20','20','yes','combination','no','no_visibility','vendor_bills','remark','yes','2019-08-05 12:43:51','Australia,Canada,USA');
insert into `questionnaire` (`id`, `ip_address`, `country_id`, `currency_id`, `dom_spend_vol`, `dom_trans_no`, `int_spend_vol`, `int_trans_no`, `hotel_spend_vol`, `hotel_trans_no`, `other_spend_vol`, `other_trans_no`, `misc_spend_vol`, `misc_trans_no`, `airlineDomestic`, `airlineInternational`, `dom_city_pair`, `int_city_pair`, `percentage_cancellation`, `int_travel_percentage`, `airline_consolidators_use`, `payment`, `usa_canada_spend`, `south_east_asia_spend`, `aus_newzealand_spend`, `middle_east_spend`, `others_spend`, `hostel_consolidators`, `retail_plans`, `foreign_exchange`, `refund_processing_days`, `car_rental_contract`, `remark`, `corporate_deals`, `TIMESTAMP`, `hotel_destination`) values('4','::1','11','11','100','100','200','100','100','100','100','100','100','100','goair,indigo','bangkokairways','BOM-HYD,DEL-BLR','IN-AU,IN-CA','20','20','yes','no','20','20','20','20','20','yes','combination','no','no_visibility','vendor_bills','remarkkkk','no','2019-09-12 11:38:14','USA,Srilanka,China');
insert into `questionnaire` (`id`, `ip_address`, `country_id`, `currency_id`, `dom_spend_vol`, `dom_trans_no`, `int_spend_vol`, `int_trans_no`, `hotel_spend_vol`, `hotel_trans_no`, `other_spend_vol`, `other_trans_no`, `misc_spend_vol`, `misc_trans_no`, `airlineDomestic`, `airlineInternational`, `dom_city_pair`, `int_city_pair`, `percentage_cancellation`, `int_travel_percentage`, `airline_consolidators_use`, `payment`, `usa_canada_spend`, `south_east_asia_spend`, `aus_newzealand_spend`, `middle_east_spend`, `others_spend`, `hostel_consolidators`, `retail_plans`, `foreign_exchange`, `refund_processing_days`, `car_rental_contract`, `remark`, `corporate_deals`, `TIMESTAMP`, `hotel_destination`) values('9','::1','2','2','10','10','10','10','10','10','10','10','10','10','airindia,goair,indigo','airarabia,bangkokairways,bhutanairline','BOM-HYD,DEL-BLR,HYD-DEL','IN-AU,IN-CA,IN-EG','10','10','yes','yes','20','20','20','20','20','yes','combination','no','no_visibility','vendor_bills','remark','yes','2019-09-09 18:05:24','Canada,USA,Srilanka');
insert into `questionnaire` (`id`, `ip_address`, `country_id`, `currency_id`, `dom_spend_vol`, `dom_trans_no`, `int_spend_vol`, `int_trans_no`, `hotel_spend_vol`, `hotel_trans_no`, `other_spend_vol`, `other_trans_no`, `misc_spend_vol`, `misc_trans_no`, `airlineDomestic`, `airlineInternational`, `dom_city_pair`, `int_city_pair`, `percentage_cancellation`, `int_travel_percentage`, `airline_consolidators_use`, `payment`, `usa_canada_spend`, `south_east_asia_spend`, `aus_newzealand_spend`, `middle_east_spend`, `others_spend`, `hostel_consolidators`, `retail_plans`, `foreign_exchange`, `refund_processing_days`, `car_rental_contract`, `remark`, `corporate_deals`, `TIMESTAMP`, `hotel_destination`) values('10','::1','12','12','100','100','100','100','100','100','100','100','100','100','airasia,airindia','airarabia,bangkokairways','BOM-HYD,DEL-BLR','IN-LK,IN-CA','20','20','yes','no','20','20','20','20','20','yes','combination','no','no_visibility','vendor_bills','remark','yes','2019-09-12 13:09:47','Canada,USA');
insert into `questionnaire` (`id`, `ip_address`, `country_id`, `currency_id`, `dom_spend_vol`, `dom_trans_no`, `int_spend_vol`, `int_trans_no`, `hotel_spend_vol`, `hotel_trans_no`, `other_spend_vol`, `other_trans_no`, `misc_spend_vol`, `misc_trans_no`, `airlineDomestic`, `airlineInternational`, `dom_city_pair`, `int_city_pair`, `percentage_cancellation`, `int_travel_percentage`, `airline_consolidators_use`, `payment`, `usa_canada_spend`, `south_east_asia_spend`, `aus_newzealand_spend`, `middle_east_spend`, `others_spend`, `hostel_consolidators`, `retail_plans`, `foreign_exchange`, `refund_processing_days`, `car_rental_contract`, `remark`, `corporate_deals`, `TIMESTAMP`, `hotel_destination`) values('11','::1','','','0','0','0','0','0','0','0','0','0','0','','','','','0','0','','','0','0','0','0','0','','','','','','','','2019-09-12 14:06:50','');
insert into `questionnaire` (`id`, `ip_address`, `country_id`, `currency_id`, `dom_spend_vol`, `dom_trans_no`, `int_spend_vol`, `int_trans_no`, `hotel_spend_vol`, `hotel_trans_no`, `other_spend_vol`, `other_trans_no`, `misc_spend_vol`, `misc_trans_no`, `airlineDomestic`, `airlineInternational`, `dom_city_pair`, `int_city_pair`, `percentage_cancellation`, `int_travel_percentage`, `airline_consolidators_use`, `payment`, `usa_canada_spend`, `south_east_asia_spend`, `aus_newzealand_spend`, `middle_east_spend`, `others_spend`, `hostel_consolidators`, `retail_plans`, `foreign_exchange`, `refund_processing_days`, `car_rental_contract`, `remark`, `corporate_deals`, `TIMESTAMP`, `hotel_destination`) values('12','::1','','','0','0','0','0','0','0','0','0','0','0','','','','','0','0','','','20','20','20','30','10','','','','','','','','2019-09-12 14:06:23','');
insert into `questionnaire` (`id`, `ip_address`, `country_id`, `currency_id`, `dom_spend_vol`, `dom_trans_no`, `int_spend_vol`, `int_trans_no`, `hotel_spend_vol`, `hotel_trans_no`, `other_spend_vol`, `other_trans_no`, `misc_spend_vol`, `misc_trans_no`, `airlineDomestic`, `airlineInternational`, `dom_city_pair`, `int_city_pair`, `percentage_cancellation`, `int_travel_percentage`, `airline_consolidators_use`, `payment`, `usa_canada_spend`, `south_east_asia_spend`, `aus_newzealand_spend`, `middle_east_spend`, `others_spend`, `hostel_consolidators`, `retail_plans`, `foreign_exchange`, `refund_processing_days`, `car_rental_contract`, `remark`, `corporate_deals`, `TIMESTAMP`, `hotel_destination`) values('13','','','','0','0','0','0','0','0','0','0','0','0','','','','','0','0','','','0','0','0','0','0','','','','','','','','2019-09-23 12:01:32','');
insert into `questionnaire` (`id`, `ip_address`, `country_id`, `currency_id`, `dom_spend_vol`, `dom_trans_no`, `int_spend_vol`, `int_trans_no`, `hotel_spend_vol`, `hotel_trans_no`, `other_spend_vol`, `other_trans_no`, `misc_spend_vol`, `misc_trans_no`, `airlineDomestic`, `airlineInternational`, `dom_city_pair`, `int_city_pair`, `percentage_cancellation`, `int_travel_percentage`, `airline_consolidators_use`, `payment`, `usa_canada_spend`, `south_east_asia_spend`, `aus_newzealand_spend`, `middle_east_spend`, `others_spend`, `hostel_consolidators`, `retail_plans`, `foreign_exchange`, `refund_processing_days`, `car_rental_contract`, `remark`, `corporate_deals`, `TIMESTAMP`, `hotel_destination`) values('14','','','','0','0','0','0','0','0','0','0','0','0','','','','','0','0','','','0','0','0','0','0','','','','','','','','2019-09-23 12:10:15','');
insert into `questionnaire` (`id`, `ip_address`, `country_id`, `currency_id`, `dom_spend_vol`, `dom_trans_no`, `int_spend_vol`, `int_trans_no`, `hotel_spend_vol`, `hotel_trans_no`, `other_spend_vol`, `other_trans_no`, `misc_spend_vol`, `misc_trans_no`, `airlineDomestic`, `airlineInternational`, `dom_city_pair`, `int_city_pair`, `percentage_cancellation`, `int_travel_percentage`, `airline_consolidators_use`, `payment`, `usa_canada_spend`, `south_east_asia_spend`, `aus_newzealand_spend`, `middle_east_spend`, `others_spend`, `hostel_consolidators`, `retail_plans`, `foreign_exchange`, `refund_processing_days`, `car_rental_contract`, `remark`, `corporate_deals`, `TIMESTAMP`, `hotel_destination`) values('15','::1','','','0','0','0','0','0','0','0','0','0','0','','','','','0','0','','','0','0','0','0','0','','','','','','','','2019-09-23 12:11:28','');
