-- http://www.phpmyadmin.net
--




-- --------------------------------------------------------

--
-- Table structure for table `advertising_post`
--

CREATE TABLE IF NOT EXISTS `advertising_post` (
  `advertising_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `start_time` varchar(120) NOT NULL,
  `end_time` varchar(120) NOT NULL,
  `taka` varchar(120) NOT NULL,
  `position` varchar(120) NOT NULL,
  `document` varchar(200) NOT NULL,
  `admin` int(11) NOT NULL,
  PRIMARY KEY (`advertising_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `advertising_post`
--

INSERT INTO `advertising_post` (`advertising_id`, `title`, `start_time`, `end_time`, `taka`, `position`, `document`, `admin`) VALUES
(1, 'outh leadership is needed to', '2017-06-17', '2017-06-22', '15000', 'header', 'advertising/1497687581.jpg', 1);

-- --------------------------------------------------------

--
-- Table structure for table `agent_price`
--

CREATE TABLE IF NOT EXISTS `agent_price` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `country` varchar(100) NOT NULL,
  `area` varchar(100) NOT NULL,
  `price_form` varchar(100) NOT NULL,
  `price_to` varchar(100) NOT NULL,
  `car` varchar(100) NOT NULL,
  `car_rant` varchar(100) NOT NULL,
  `innovacar` varchar(100) NOT NULL,
  `innova_rant` varchar(100) NOT NULL,
  `van` varchar(100) NOT NULL,
  `van_rant` varchar(100) NOT NULL,
  `bus` varchar(100) DEFAULT NULL,
  `bus_rant` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `agent_price`
--


-- --------------------------------------------------------

--
-- Table structure for table `balance_sheet`
--

CREATE TABLE IF NOT EXISTS `balance_sheet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_type` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `invoice_id` varchar(255) NOT NULL,
  `naretion` varchar(255) NOT NULL,
  `invoice_date` varchar(255) NOT NULL,
  `payment_type` varchar(255) NOT NULL,
  `dr_amount` double NOT NULL,
  `cr_amount` double NOT NULL,
  `balance` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `balance_sheet`
--

INSERT INTO `balance_sheet` (`id`, `user_type`, `user_id`, `invoice_id`, `naretion`, `invoice_date`, `payment_type`, `dr_amount`, `cr_amount`, `balance`) VALUES
(1, '5', '1', '1572070454', 'Hotel Booking Invoice', '2019-10-26', '1', 2900, 0, 2900);

-- --------------------------------------------------------

--
-- Table structure for table `blog_info`
--

CREATE TABLE IF NOT EXISTS `blog_info` (
  `blog_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `description` longtext NOT NULL,
  `image` varchar(250) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`blog_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `blog_info`
--

INSERT INTO `blog_info` (`blog_id`, `title`, `description`, `image`, `date`) VALUES
(1, 'Youth leadership ', 'Bangladessh About Blog - Blog by Pamela Geller has led awareness campaigns in U.S., Europe, and Israel on behalf of the victims and potential victims of honor killing, for the human rights of apostates from Islam, for the freedom of speech, and more. About Blog - Blog by Pamela Geller has led awareness campaigns in U.S., Europe, and Israel on behalf of the victims and potential victims of honor killing, for the human rights of apostates from Islam, for the freedom of speech, and more.', 'image/1497858141.jpg', '2017-06-19 16:26:22'),
(3, 'About Blog - Blog by Pamela Geller has led awareness campaigns ', 'About Blog - Blog by Pamela Geller has led awareness campaigns in U.S., Europe, and Israel on behalf of the victims and potential victims of honor killing, for the human rights of apostates from Islam, for the freedom of speech, and more. \r\nAbout Blog - Blog by Pamela Geller has led awareness campaigns in U.S., Europe, and Israel on behalf of the victims and potential victims of honor killing, for the human rights of apostates from Islam, for the freedom of speech, and more. ', 'image/1497860842.jpg', '2017-06-19 16:26:10');
INSERT INTO `blog_info` (`blog_id`, `title`, `description`, `image`, `date`) VALUES
(4, 'U.S., Europe, and Israel on behalf of the victims', '<p><span style="color: rgb(51, 51, 51); font-size: medium; background-color: rgb(245, 245, 245);">About Blog - Blog by Pamela Geller has led awareness campaigns in U.S., Europe, and Israel on behalf of the victims and potential victims of honor killing, for the human rights of apostates from Islam, for the freedom of speech, and more. About Blog - Blog by Pamela Geller has led awareness campaigns in U.S., Europe, and Israel on behalf of the victims and potential victims of honor killing, for the human rights of apostates from Islam, for the freedom of speech, and more.</span></p><p><img src="data:image/jpeg;base64,[BLOB]" data-filename="7875_1.jpg" style="width: 303.474px; height: 202px;"><span style="color: rgb(51, 51, 51); font-size: medium; background-color: rgb(245, 245, 245);"><br></span></p><p><span style="color: rgb(51, 51, 51); font-size: medium; background-color: rgb(245, 245, 245);">About Blog - Blog by Pamela Geller has led awareness campaigns in U.S., Europe, and Israel on behalf of the victims and potential victims of honor killing, for the human rights of apostates from Islam, for the freedom of speech, and more. About Blog - Blog by Pamela Geller has led awareness campaigns in U.S., Europe, and Israel on behalf of the victims and potential victims of honor killing, for the human rights of apostates from Islam, for the freedom of speech, and more.</span></p>', 'image/1497935961.jpg', '2017-06-20 13:18:09');

-- --------------------------------------------------------

--
-- Table structure for table `car_situation`
--

CREATE TABLE IF NOT EXISTS `car_situation` (
  `situation_id` int(11) NOT NULL AUTO_INCREMENT,
  `situation` varchar(100) NOT NULL,
  PRIMARY KEY (`situation_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `car_situation`
--

INSERT INTO `car_situation` (`situation_id`, `situation`) VALUES
(1, 'Round Trip with Driver'),
(2, 'Auto transmission'),
(3, 'Air Conditioned'),
(4, '8 passengers'),
(5, 'Toyota Land Cruiser Prado');

-- --------------------------------------------------------

--
-- Table structure for table `city`
--

CREATE TABLE IF NOT EXISTS `city` (
  `city_id` int(11) NOT NULL AUTO_INCREMENT,
  `country` int(11) NOT NULL,
  `city_name` varchar(200) NOT NULL,
  PRIMARY KEY (`city_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `city`
--

INSERT INTO `city` (`city_id`, `country`, `city_name`) VALUES
(1, 1, 'Barisal'),
(2, 1, 'Dhaka');

-- --------------------------------------------------------

--
-- Table structure for table `company_information`
--

CREATE TABLE IF NOT EXISTS `company_information` (
  `company_id` int(11) NOT NULL AUTO_INCREMENT,
  `company_name` varchar(1000) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `financial_year` varchar(10) NOT NULL,
  `begaining_from` varchar(50) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `qr_code` varchar(100) NOT NULL,
  PRIMARY KEY (`company_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `company_information`
--

INSERT INTO `company_information` (`company_id`, `company_name`, `mobile`, `email`, `website`, `address`, `financial_year`, `begaining_from`, `logo`, `qr_code`) VALUES
(1, 'Siyam Holidays', '01727-985581', 'sales@siyamholidays.com', 'siyamholidays.com', '15/5 (1st Floor), Block-C, Tajmahal Road, Mohammadpur\r\nDhaka, Bangladesh', '2018', '2019-06-30', 'images/1548198dfdfd313.png', 'images/qr.PNG');

-- --------------------------------------------------------

--
-- Table structure for table `country`
--

CREATE TABLE IF NOT EXISTS `country` (
  `country_id` int(11) NOT NULL AUTO_INCREMENT,
  `country_name` varchar(150) NOT NULL,
  PRIMARY KEY (`country_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `country`
--

INSERT INTO `country` (`country_id`, `country_name`) VALUES
(1, 'Bangladesh '),
(3, 'Nepal');

-- --------------------------------------------------------

--
-- Table structure for table `country_list`
--

CREATE TABLE IF NOT EXISTS `country_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `country_code` varchar(2) NOT NULL DEFAULT '',
  `country_name` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=247 ;

--
-- Dumping data for table `country_list`
--

INSERT INTO `country_list` (`id`, `country_code`, `country_name`) VALUES
(1, 'AF', 'Afghanistan'),
(2, 'AL', 'Albania'),
(3, 'DZ', 'Algeria'),
(4, 'DS', 'American Samoa'),
(5, 'AD', 'Andorra'),
(6, 'AO', 'Angola'),
(7, 'AI', 'Anguilla'),
(8, 'AQ', 'Antarctica'),
(9, 'AG', 'Antigua and Barbuda'),
(10, 'AR', 'Argentina'),
(11, 'AM', 'Armenia'),
(12, 'AW', 'Aruba'),
(13, 'AU', 'Australia'),
(14, 'AT', 'Austria'),
(15, 'AZ', 'Azerbaijan'),
(16, 'BS', 'Bahamas'),
(17, 'BH', 'Bahrain'),
(18, 'BD', 'Bangladesh'),
(19, 'BB', 'Barbados'),
(20, 'BY', 'Belarus'),
(21, 'BE', 'Belgium'),
(22, 'BZ', 'Belize'),
(23, 'BJ', 'Benin'),
(24, 'BM', 'Bermuda'),
(25, 'BT', 'Bhutan'),
(26, 'BO', 'Bolivia'),
(27, 'BA', 'Bosnia and Herzegovina'),
(28, 'BW', 'Botswana'),
(29, 'BV', 'Bouvet Island'),
(30, 'BR', 'Brazil'),
(31, 'IO', 'British Indian Ocean Territory'),
(32, 'BN', 'Brunei Darussalam'),
(33, 'BG', 'Bulgaria'),
(34, 'BF', 'Burkina Faso'),
(35, 'BI', 'Burundi'),
(36, 'KH', 'Cambodia'),
(37, 'CM', 'Cameroon'),
(38, 'CA', 'Canada'),
(39, 'CV', 'Cape Verde'),
(40, 'KY', 'Cayman Islands'),
(41, 'CF', 'Central African Republic'),
(42, 'TD', 'Chad'),
(43, 'CL', 'Chile'),
(44, 'CN', 'China'),
(45, 'CX', 'Christmas Island'),
(46, 'CC', 'Cocos (Keeling) Islands'),
(47, 'CO', 'Colombia'),
(48, 'KM', 'Comoros'),
(49, 'CG', 'Congo'),
(50, 'CK', 'Cook Islands'),
(51, 'CR', 'Costa Rica'),
(52, 'HR', 'Croatia (Hrvatska)'),
(53, 'CU', 'Cuba'),
(54, 'CY', 'Cyprus'),
(55, 'CZ', 'Czech Republic'),
(56, 'DK', 'Denmark'),
(57, 'DJ', 'Djibouti'),
(58, 'DM', 'Dominica'),
(59, 'DO', 'Dominican Republic'),
(60, 'TP', 'East Timor'),
(61, 'EC', 'Ecuador'),
(62, 'EG', 'Egypt'),
(63, 'SV', 'El Salvador'),
(64, 'GQ', 'Equatorial Guinea'),
(65, 'ER', 'Eritrea'),
(66, 'EE', 'Estonia'),
(67, 'ET', 'Ethiopia'),
(68, 'FK', 'Falkland Islands (Malvinas)'),
(69, 'FO', 'Faroe Islands'),
(70, 'FJ', 'Fiji'),
(71, 'FI', 'Finland'),
(72, 'FR', 'France'),
(73, 'FX', 'France, Metropolitan'),
(74, 'GF', 'French Guiana'),
(75, 'PF', 'French Polynesia'),
(76, 'TF', 'French Southern Territories'),
(77, 'GA', 'Gabon'),
(78, 'GM', 'Gambia'),
(79, 'GE', 'Georgia'),
(80, 'DE', 'Germany'),
(81, 'GH', 'Ghana'),
(82, 'GI', 'Gibraltar'),
(83, 'GK', 'Guernsey'),
(84, 'GR', 'Greece'),
(85, 'GL', 'Greenland'),
(86, 'GD', 'Grenada'),
(87, 'GP', 'Guadeloupe'),
(88, 'GU', 'Guam'),
(89, 'GT', 'Guatemala'),
(90, 'GN', 'Guinea'),
(91, 'GW', 'Guinea-Bissau'),
(92, 'GY', 'Guyana'),
(93, 'HT', 'Haiti'),
(94, 'HM', 'Heard and Mc Donald Islands'),
(95, 'HN', 'Honduras'),
(96, 'HK', 'Hong Kong'),
(97, 'HU', 'Hungary'),
(98, 'IS', 'Iceland'),
(99, 'IN', 'India'),
(100, 'IM', 'Isle of Man'),
(101, 'ID', 'Indonesia'),
(102, 'IR', 'Iran (Islamic Republic of)'),
(103, 'IQ', 'Iraq'),
(104, 'IE', 'Ireland'),
(105, 'IL', 'Israel'),
(106, 'IT', 'Italy'),
(107, 'CI', 'Ivory Coast'),
(108, 'JE', 'Jersey'),
(109, 'JM', 'Jamaica'),
(110, 'JP', 'Japan'),
(111, 'JO', 'Jordan'),
(112, 'KZ', 'Kazakhstan'),
(113, 'KE', 'Kenya'),
(114, 'KI', 'Kiribati'),
(115, 'KP', 'Korea, Democratic People''s Republic of'),
(116, 'KR', 'Korea, Republic of'),
(117, 'XK', 'Kosovo'),
(118, 'KW', 'Kuwait'),
(119, 'KG', 'Kyrgyzstan'),
(120, 'LA', 'Lao People''s Democratic Republic'),
(121, 'LV', 'Latvia'),
(122, 'LB', 'Lebanon'),
(123, 'LS', 'Lesotho'),
(124, 'LR', 'Liberia'),
(125, 'LY', 'Libyan Arab Jamahiriya'),
(126, 'LI', 'Liechtenstein'),
(127, 'LT', 'Lithuania'),
(128, 'LU', 'Luxembourg'),
(129, 'MO', 'Macau'),
(130, 'MK', 'Macedonia'),
(131, 'MG', 'Madagascar'),
(132, 'MW', 'Malawi'),
(133, 'MY', 'Malaysia'),
(134, 'MV', 'Maldives'),
(135, 'ML', 'Mali'),
(136, 'MT', 'Malta'),
(137, 'MH', 'Marshall Islands'),
(138, 'MQ', 'Martinique'),
(139, 'MR', 'Mauritania'),
(140, 'MU', 'Mauritius'),
(141, 'TY', 'Mayotte'),
(142, 'MX', 'Mexico'),
(143, 'FM', 'Micronesia, Federated States of'),
(144, 'MD', 'Moldova, Republic of'),
(145, 'MC', 'Monaco'),
(146, 'MN', 'Mongolia'),
(147, 'ME', 'Montenegro'),
(148, 'MS', 'Montserrat'),
(149, 'MA', 'Morocco'),
(150, 'MZ', 'Mozambique'),
(151, 'MM', 'Myanmar'),
(152, 'NA', 'Namibia'),
(153, 'NR', 'Nauru'),
(154, 'NP', 'Nepal'),
(155, 'NL', 'Netherlands'),
(156, 'AN', 'Netherlands Antilles'),
(157, 'NC', 'New Caledonia'),
(158, 'NZ', 'New Zealand'),
(159, 'NI', 'Nicaragua'),
(160, 'NE', 'Niger'),
(161, 'NG', 'Nigeria'),
(162, 'NU', 'Niue'),
(163, 'NF', 'Norfolk Island'),
(164, 'MP', 'Northern Mariana Islands'),
(165, 'NO', 'Norway'),
(166, 'OM', 'Oman'),
(167, 'PK', 'Pakistan'),
(168, 'PW', 'Palau'),
(169, 'PS', 'Palestine'),
(170, 'PA', 'Panama'),
(171, 'PG', 'Papua New Guinea'),
(172, 'PY', 'Paraguay'),
(173, 'PE', 'Peru'),
(174, 'PH', 'Philippines'),
(175, 'PN', 'Pitcairn'),
(176, 'PL', 'Poland'),
(177, 'PT', 'Portugal'),
(178, 'PR', 'Puerto Rico'),
(179, 'QA', 'Qatar'),
(180, 'RE', 'Reunion'),
(181, 'RO', 'Romania'),
(182, 'RU', 'Russian Federation'),
(183, 'RW', 'Rwanda'),
(184, 'KN', 'Saint Kitts and Nevis'),
(185, 'LC', 'Saint Lucia'),
(186, 'VC', 'Saint Vincent and the Grenadines'),
(187, 'WS', 'Samoa'),
(188, 'SM', 'San Marino'),
(189, 'ST', 'Sao Tome and Principe'),
(190, 'SA', 'Saudi Arabia'),
(191, 'SN', 'Senegal'),
(192, 'RS', 'Serbia'),
(193, 'SC', 'Seychelles'),
(194, 'SL', 'Sierra Leone'),
(195, 'SG', 'Singapore'),
(196, 'SK', 'Slovakia'),
(197, 'SI', 'Slovenia'),
(198, 'SB', 'Solomon Islands'),
(199, 'SO', 'Somalia'),
(200, 'ZA', 'South Africa'),
(201, 'GS', 'South Georgia South Sandwich Islands'),
(202, 'SS', 'South Sudan'),
(203, 'ES', 'Spain'),
(204, 'LK', 'Sri Lanka'),
(205, 'SH', 'St. Helena'),
(206, 'PM', 'St. Pierre and Miquelon'),
(207, 'SD', 'Sudan'),
(208, 'SR', 'Suriname'),
(209, 'SJ', 'Svalbard and Jan Mayen Islands'),
(210, 'SZ', 'Swaziland'),
(211, 'SE', 'Sweden'),
(212, 'CH', 'Switzerland'),
(213, 'SY', 'Syrian Arab Republic'),
(214, 'TW', 'Taiwan'),
(215, 'TJ', 'Tajikistan'),
(216, 'TZ', 'Tanzania, United Republic of'),
(217, 'TH', 'Thailand'),
(218, 'TG', 'Togo'),
(219, 'TK', 'Tokelau'),
(220, 'TO', 'Tonga'),
(221, 'TT', 'Trinidad and Tobago'),
(222, 'TN', 'Tunisia'),
(223, 'TR', 'Turkey'),
(224, 'TM', 'Turkmenistan'),
(225, 'TC', 'Turks and Caicos Islands'),
(226, 'TV', 'Tuvalu'),
(227, 'UG', 'Uganda'),
(228, 'UA', 'Ukraine'),
(229, 'AE', 'United Arab Emirates'),
(230, 'GB', 'United Kingdom'),
(231, 'US', 'United States'),
(232, 'UM', 'United States minor outlying islands'),
(233, 'UY', 'Uruguay'),
(234, 'UZ', 'Uzbekistan'),
(235, 'VU', 'Vanuatu'),
(236, 'VA', 'Vatican City State'),
(237, 'VE', 'Venezuela'),
(238, 'VN', 'Vietnam'),
(239, 'VG', 'Virgin Islands (British)'),
(240, 'VI', 'Virgin Islands (U.S.)'),
(241, 'WF', 'Wallis and Futuna Islands'),
(242, 'EH', 'Western Sahara'),
(243, 'YE', 'Yemen'),
(244, 'ZR', 'Zaire'),
(245, 'ZM', 'Zambia'),
(246, 'ZW', 'Zimbabwe');

-- --------------------------------------------------------

--
-- Table structure for table `currency_list`
--

CREATE TABLE IF NOT EXISTS `currency_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `currency` varchar(255) NOT NULL,
  `symble` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `currency_list`
--

INSERT INTO `currency_list` (`id`, `currency`, `symble`) VALUES
(1, 'USD', ''),
(2, 'THB', ''),
(3, 'RM', ''),
(4, 'SGD', ''),
(5, 'BDT', '');

-- --------------------------------------------------------

--
-- Table structure for table `customer_information`
--

CREATE TABLE IF NOT EXISTS `customer_information` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` varchar(100) NOT NULL,
  `customer_type` int(11) NOT NULL,
  `customer_name` varchar(255) NOT NULL,
  `person_name` varchar(255) NOT NULL,
  `mobile_no` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `country_id` int(11) NOT NULL,
  `post_code` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `customer_information`
--

INSERT INTO `customer_information` (`id`, `customer_id`, `customer_type`, `customer_name`, `person_name`, `mobile_no`, `email`, `address`, `city`, `state`, `country_id`, `post_code`, `status`) VALUES
(1, '2019001', 1, 'Md Babul Uddin', '', '01727985581', 'timesmail24@gmail.com', 'Dhaka', 'Dhaka', 'Mohammadpur', 18, '1207', 1),
(2, '2019002', 1, 'Md Nazmul Huda', '', '01831710927', 'infonazmulfci@gmail.com', 'Dhaka', 'Dhaka', 'Mohammadpur', 18, '1207', 1);

-- --------------------------------------------------------

--
-- Table structure for table `damage_coverage`
--

CREATE TABLE IF NOT EXISTS `damage_coverage` (
  `covarage_id` int(11) NOT NULL AUTO_INCREMENT,
  `covarage` varchar(100) NOT NULL,
  PRIMARY KEY (`covarage_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `damage_coverage`
--

INSERT INTO `damage_coverage` (`covarage_id`, `covarage`) VALUES
(1, 'Driver Cost Included'),
(2, 'Damage Cost Not Included');

-- --------------------------------------------------------

--
-- Table structure for table `deposit_list`
--

CREATE TABLE IF NOT EXISTS `deposit_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deposit_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `deposit_list`
--

INSERT INTO `deposit_list` (`id`, `deposit_name`) VALUES
(1, 'Cheque'),
(2, 'Bank Deposit'),
(3, 'Bank Transfer'),
(4, 'Cash'),
(5, 'Mobile Banking'),
(6, 'Debit / Credit Card Payment'),
(7, 'Other');

-- --------------------------------------------------------

--
-- Table structure for table `event_booking_order`
--

CREATE TABLE IF NOT EXISTS `event_booking_order` (
  `event_booking_order_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `entry_quantity` int(11) NOT NULL,
  `all_quantity` int(11) NOT NULL,
  `entry_price` double NOT NULL,
  `entry_price_total` double NOT NULL,
  `all_price` double NOT NULL,
  `all_price_total` double NOT NULL,
  `total_price` double NOT NULL,
  `name` varchar(255) NOT NULL,
  `contact_no` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `add1` varchar(255) NOT NULL,
  `add2` varchar(255) NOT NULL,
  `land_mark` varchar(255) NOT NULL,
  `postal_code` varchar(255) NOT NULL,
  `booking_type` varchar(255) NOT NULL,
  `card_type` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`event_booking_order_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `event_booking_order`
--

INSERT INTO `event_booking_order` (`event_booking_order_id`, `user_id`, `event_id`, `entry_quantity`, `all_quantity`, `entry_price`, `entry_price_total`, `all_price`, `all_price_total`, `total_price`, `name`, `contact_no`, `email`, `add1`, `add2`, `land_mark`, `postal_code`, `booking_type`, `card_type`, `city`, `status`, `date`) VALUES
(1, 1, 1, 1, 1, 200, 200, 340, 340, 540, 'nazmul huda', '2309234234039', 'nazmulfci@gmail.com', '', '', '', '', '1', '', '', 1, '2017-01-26 07:43:38'),
(2, 40000, 1, 1, 1, 200, 200, 340, 340, 540, 'sdf', 'sdf', 'feni@yahoo.com', '', '', '', '', '1', '', '', 0, '2017-02-27 05:01:49'),
(3, 3, 1, 1, 1, 200, 200, 340, 340, 540, 'nazmul huda', '01831710927', 'nazmulfci@gmail.com', '', '', '', '', '1', '', '', 0, '2017-02-27 04:47:32'),
(4, 0, 1, 1, 1, 200, 200, 340, 340, 540, 'Babul ', '01727985581', 'siyamholidays@gmail.com', '', '', '', '', '1', '', '', 0, '2017-03-01 03:00:10'),
(5, 0, 1, 2, 1, 200, 200, 340, 340, 540, 'nazmul huda', '2309234234039', 'nazmulfci@gmail.com', '', '', '', '', '1', '', '', 0, '2017-03-01 03:00:12');

-- --------------------------------------------------------

--
-- Table structure for table `event_information`
--

CREATE TABLE IF NOT EXISTS `event_information` (
  `event_id` int(11) NOT NULL AUTO_INCREMENT,
  `agent_id` int(11) NOT NULL,
  `title` text NOT NULL,
  `date1` date NOT NULL,
  `time1` varchar(200) NOT NULL,
  `entry_ticket_price` double NOT NULL,
  `entry_ticket_price1` double NOT NULL,
  `entry_ticket_price2` double NOT NULL,
  `date2` date NOT NULL,
  `time2` varchar(200) NOT NULL,
  `all_rides_price` double NOT NULL,
  `all_rides_price1` double NOT NULL,
  `all_rides_price2` double NOT NULL,
  `place` varchar(200) NOT NULL,
  `description` longtext NOT NULL,
  `trams_condition` longtext NOT NULL,
  `image` varchar(200) NOT NULL,
  PRIMARY KEY (`event_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `event_information`
--

INSERT INTO `event_information` (`event_id`, `agent_id`, `title`, `date1`, `time1`, `entry_ticket_price`, `entry_ticket_price1`, `entry_ticket_price2`, `date2`, `time2`, `all_rides_price`, `all_rides_price1`, `all_rides_price2`, `place`, `description`, `trams_condition`, `image`) VALUES
(1, 4, 'Fantasy Kingdom', '2017-01-25', '2:00', 200, 0, 0, '2017-01-25', '3:00', 340, 0, 0, 'Ashulia ,Fantasy Kingdom Complex Jamgora, Ashulia, Savar, Dhaka, Bangladesh', 'The best amusement park in Dhaka.', 'Terms & condition', 'photo/1485351946.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `flight_customer_information`
--

CREATE TABLE IF NOT EXISTS `flight_customer_information` (
  `flight_customer_id` int(11) NOT NULL AUTO_INCREMENT,
  `flight_info_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `flight_trip_type` varchar(120) NOT NULL,
  `departure_date` date NOT NULL,
  `return_date` date NOT NULL,
  `number_of_adult` varchar(120) NOT NULL,
  `number_of_child` varchar(100) NOT NULL,
  `contact_person` varchar(200) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `email` varchar(120) NOT NULL,
  `address` varchar(2000) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`flight_customer_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `flight_customer_information`
--

INSERT INTO `flight_customer_information` (`flight_customer_id`, `flight_info_id`, `user_id`, `flight_trip_type`, `departure_date`, `return_date`, `number_of_adult`, `number_of_child`, `contact_person`, `phone`, `email`, `address`, `status`) VALUES
(1, 1, 1, 'one_way', '2017-01-25', '2017-01-25', '2', '2', 'SR Enterprise', '01718-245864', 'nazmulfci@yahoo.com', 'lkjl;j;lk', 1),
(2, 1, 1, 'one_way', '2017-01-25', '2017-01-25', '2', '2', 'SR Enterprise', '01718-245864', 'nazmulfci@yahoo.com', 'lkjl;j;lk', 1);

-- --------------------------------------------------------

--
-- Table structure for table `flight_information`
--

CREATE TABLE IF NOT EXISTS `flight_information` (
  `flight_id` int(11) NOT NULL AUTO_INCREMENT,
  `flight_category_id` varchar(100) NOT NULL,
  `type` varchar(90) NOT NULL COMMENT 'type',
  `title` varchar(150) NOT NULL,
  `country_from` varchar(150) NOT NULL,
  `country_to` varchar(150) NOT NULL,
  `deperture_date` varchar(20) NOT NULL,
  `return_date` varchar(20) NOT NULL,
  `price` double NOT NULL,
  `pakage_description` longtext NOT NULL,
  `image` varchar(120) NOT NULL,
  PRIMARY KEY (`flight_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `flight_information`
--

INSERT INTO `flight_information` (`flight_id`, `flight_category_id`, `type`, `title`, `country_from`, `country_to`, `deperture_date`, `return_date`, `price`, `pakage_description`, `image`) VALUES
(1, '', '', 'Dhaka-Beijing Round Trip', 'Dhaka', 'Beijing', '', '', 38000, 'The city of Beijing is one with not only an unfathomable history, but an amazing beauty that makes it the capital of China. For nearly three millennia, Beijing has been a home to many the ancestors of Chinese people today.', 'photo/1485340801.jpg'),
(2, '', '', 'Pages that you view in incognito tabs', '', '', '', '', 0, 'Pages that you view in incognito tabs won’t stick around in your browser’s history, cookie store or search history after you’ve closed all of your incognito tabs. Any files you download or bookmarks you create will be kep', 'photo/1497857479.jpg'),
(3, '', 'one_way', 'this is test', 'dhakaqq', 'feni', '2017-07-01', '2017-07-15', 3500, 'description', 'photo/1498886944.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `hotel_booking_order`
--

CREATE TABLE IF NOT EXISTS `hotel_booking_order` (
  `hotel_booking_order_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `check_in_date` date NOT NULL,
  `check_out_date` date NOT NULL,
  `total_day` int(11) NOT NULL,
  `hotel_id` int(11) NOT NULL,
  `room_id` int(11) NOT NULL,
  `room_price` double NOT NULL,
  `total_price` double NOT NULL,
  `percent` double NOT NULL,
  `price1` double NOT NULL,
  `person` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `contact_no` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `add1` varchar(255) NOT NULL,
  `add2` varchar(255) NOT NULL,
  `land_mark` varchar(255) NOT NULL,
  `postal_code` varchar(255) NOT NULL,
  `booking_type` varchar(255) NOT NULL,
  `card_type` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`hotel_booking_order_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `hotel_booking_order`
--

INSERT INTO `hotel_booking_order` (`hotel_booking_order_id`, `user_id`, `check_in_date`, `check_out_date`, `total_day`, `hotel_id`, `room_id`, `room_price`, `total_price`, `percent`, `price1`, `person`, `name`, `contact_no`, `email`, `add1`, `add2`, `land_mark`, `postal_code`, `booking_type`, `card_type`, `city`, `status`, `date`) VALUES
(1, 1, '2017-01-25', '2017-01-26', 1, 1, 1, 21000, 21000, 3150, 17850, 2, 'nazmul huda', '2309234234039', 'nazmulfci@gmail.com', '', '', '', '', '1', '', '', 1, '2017-01-26 07:24:37'),
(2, 1, '2017-01-25', '2017-01-26', 1, 1, 1, 21000, 21000, 3150, 17850, 1, 'nazmul huda', '091991911991922', 'nazmulci@yahoo.com', 'Dhaka', 'mohammadpur', 'land mark', '1207', '2', '', '', 1, '2017-06-17 17:13:49'),
(3, 1, '2017-01-25', '2017-01-26', 1, 1, 1, 21000, 21000, 3150, 17850, 1, 'nazmul huda', '01912323399', 'nazmulfci@yahoo.com', '', '', '', '', '3', '', '', 1, '2017-06-17 17:13:54');

-- --------------------------------------------------------

--
-- Table structure for table `hotel_check_in_out`
--

CREATE TABLE IF NOT EXISTS `hotel_check_in_out` (
  `hotel_check_in_out_id` int(11) NOT NULL AUTO_INCREMENT,
  `check_in` date NOT NULL,
  `check_out` date NOT NULL,
  `payment_option` longtext NOT NULL,
  `policy` longtext NOT NULL,
  PRIMARY KEY (`hotel_check_in_out_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `hotel_check_in_out`
--


-- --------------------------------------------------------

--
-- Table structure for table `hotel_contact`
--

CREATE TABLE IF NOT EXISTS `hotel_contact` (
  `hotel_contact_id` int(11) NOT NULL AUTO_INCREMENT,
  `hotel_email` int(11) NOT NULL,
  `hotel_website` int(11) NOT NULL,
  `hotel_phone` int(11) NOT NULL,
  `hotel_facebook` int(11) NOT NULL,
  PRIMARY KEY (`hotel_contact_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `hotel_contact`
--


-- --------------------------------------------------------

--
-- Table structure for table `hotel_facilitie`
--

CREATE TABLE IF NOT EXISTS `hotel_facilitie` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `facilities` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `hotel_facilitie`
--

INSERT INTO `hotel_facilitie` (`id`, `facilities`) VALUES
(1, 'Airport Transport'),
(2, 'Business Center'),
(3, 'Disabled Facilities'),
(4, 'Night Club'),
(5, 'Laundry Service'),
(6, 'Restaurant'),
(7, 'Wi-Fi Internet'),
(8, 'Bar Lounge'),
(9, 'Swimming Pool'),
(10, 'Inside Parking'),
(11, 'Shuttle Bus Service'),
(12, 'Fitness Center'),
(13, 'SPA'),
(14, 'Children Activites'),
(15, 'Air Conditioner'),
(16, 'Banquet Hall'),
(17, 'Cards Accepted'),
(18, 'Elevator'),
(19, 'Pets Allowed');

-- --------------------------------------------------------

--
-- Table structure for table `hotel_facility`
--

CREATE TABLE IF NOT EXISTS `hotel_facility` (
  `facility_id` int(11) NOT NULL AUTO_INCREMENT,
  `facility` varchar(255) NOT NULL,
  PRIMARY KEY (`facility_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `hotel_facility`
--

INSERT INTO `hotel_facility` (`facility_id`, `facility`) VALUES
(1, '24-hours room service'),
(2, 'Business Facilities'),
(3, 'Car Parking'),
(4, 'Coffee Shop'),
(5, 'Courier Service'),
(6, 'Daily newspapers'),
(7, 'Barber service on cal'),
(8, 'Cable TV'),
(9, 'CCTV'),
(10, 'Conferences Facilities'),
(11, 'Credit card payment system'),
(12, 'Drivers Accommodation');

-- --------------------------------------------------------

--
-- Table structure for table `hotel_gallery`
--

CREATE TABLE IF NOT EXISTS `hotel_gallery` (
  `hotel_gallery_id` int(11) NOT NULL AUTO_INCREMENT,
  `hotel_id` varchar(100) NOT NULL,
  `type` int(11) NOT NULL,
  `image` varchar(2000) NOT NULL,
  PRIMARY KEY (`hotel_gallery_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `hotel_gallery`
--

INSERT INTO `hotel_gallery` (`hotel_gallery_id`, `hotel_id`, `type`, `image`) VALUES
(1, '1', 1, 'images/hotel/hotel_view_1559076903.jpg'),
(2, '1', 2, 'images/hotel/hotel_view1_1559076903.jpg'),
(3, '1', 3, 'images/hotel/lobby_1559076903.webp'),
(4, '1', 4, 'images/hotel/lobby1_1559076903.webp'),
(5, '1', 5, 'images/hotel/bedroom_1559076903.webp'),
(6, '1', 6, 'images/hotel/bedroom1_1559076904.webp'),
(7, '1', 7, 'images/hotel/bedroom2_1559076904.webp'),
(8, '1', 8, 'images/hotel/bedroom3_1559076904.webp'),
(9, '1', 9, 'images/hotel/bathroom_1559076904.webp'),
(10, '1', 10, 'images/hotel/bathroom1_1559076904.webp'),
(11, '1', 11, 'images/hotel/others_1559076904.webp'),
(12, '1', 12, 'images/hotel/others1_1559076904.webp');

-- --------------------------------------------------------

--
-- Table structure for table `hotel_general_information`
--

CREATE TABLE IF NOT EXISTS `hotel_general_information` (
  `general_info_id` int(11) NOT NULL AUTO_INCREMENT,
  `create_by` int(11) NOT NULL,
  `hotel_status` int(11) NOT NULL,
  `hotel_name` text NOT NULL,
  `hotel_description` longtext NOT NULL,
  `hotel_star` int(11) NOT NULL,
  `hotel_type` int(11) NOT NULL,
  `featured` int(11) NOT NULL,
  `featured_from` varchar(100) NOT NULL,
  `featured_to` varchar(100) NOT NULL,
  `hotel_address` longtext NOT NULL,
  `location` text NOT NULL,
  `deposit_commission_type` int(11) NOT NULL,
  `deposit_commission_value` double NOT NULL,
  `val_tax_type` int(11) NOT NULL,
  `val_tax_value` double NOT NULL,
  `related_hotel` text NOT NULL,
  `map_address` text NOT NULL,
  `latitued` varchar(255) NOT NULL,
  `longitude` varchar(255) NOT NULL,
  `hotel_facilities` text NOT NULL,
  PRIMARY KEY (`general_info_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `hotel_general_information`
--

INSERT INTO `hotel_general_information` (`general_info_id`, `create_by`, `hotel_status`, `hotel_name`, `hotel_description`, `hotel_star`, `hotel_type`, `featured`, `featured_from`, `featured_to`, `hotel_address`, `location`, `deposit_commission_type`, `deposit_commission_value`, `val_tax_type`, `val_tax_value`, `related_hotel`, `map_address`, `latitued`, `longitude`, `hotel_facilities`) VALUES
(1, 1, 1, 'Welcome Plaza Hotel', '', 3, 2, 1, '', '', 'Pattaya', 'Thailand', 1, 0, 1, 0, '', '', '', '', '2,5,6,8,9,11,12');

-- --------------------------------------------------------

--
-- Table structure for table `hotel_information`
--

CREATE TABLE IF NOT EXISTS `hotel_information` (
  `hotel_id` int(11) NOT NULL AUTO_INCREMENT,
  `hotel_name` varchar(150) NOT NULL,
  `hotel_ratting` int(11) NOT NULL,
  `holtel_address` varchar(500) NOT NULL,
  `holtel_description` longtext NOT NULL,
  `facility_id` varchar(100) NOT NULL,
  `trams_condition` longtext NOT NULL,
  `price` double NOT NULL,
  `location_map` longtext NOT NULL,
  PRIMARY KEY (`hotel_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `hotel_information`
--

INSERT INTO `hotel_information` (`hotel_id`, `hotel_name`, `hotel_ratting`, `holtel_address`, `holtel_description`, `facility_id`, `trams_condition`, `price`, `location_map`) VALUES
(1, 'Six Season Hotel sdsddddsddssdd', 3, 'Road 96, House 19, Gulshan 2, Dhaka 1212, Bangladesh', 'Overlooking the Gulshan Lake and park on one side, and glamorous panoramic views of Dhaka all around, Six Seasons hotel stands tall saluting the city. The magnificent hotel rises 15 floors, full of architectural splendor and replete with mechanical genius and opulence never before seen in Dhaka. Destined to be a landmark, our exquisitely furnished hotel offers lavish decor both inside and outside the building. Under a moonlit sky, our thoughtfully placed bamboo accents on floor-to-ceiling guestroom windows epitomize beauty on the exterior of the building while providing you with utmost privacy in the comfort of your room. As soon you step into our grand lobby, with gleaming white marble floor, a flux of our legendary service and luxury embrace you. Relax, await, or indulge your taste buds in the comfort of our spacious lobby, complete with a restaurant, stunning reception counter, and coffee lounge. Adore the breathtaking views from the hanging and partially transparent rooftop pool, sitting 15 stories high. Indulge in the sumptuous decor- mosaic mural, terracotta paintings, decorated fountains and hand-painted depictions of the six seasons of Bangladesh; Six Seasons thoughtfully integrated captivating views and sights with the latest in modern technology throughout the building. A seamless fusion of traditional and modern, let every aspect of our hotel dazzle you and truly redefine luxury ', '1,2,3,4,5,6,7,8,9,10,11,12,', 'Cancellation is free prior to 5 days ago', 24000, '<iframe src="https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d14602.701366775687!2d90.4193026!3d23.7945727!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0xe0b5315081473ad!2sSix+Seasons+Hotel!5e0!3m2!1sen!2sbd!4v1453101507316" width="100%" height="450" frameborder="0" style="border:0" allowfullscreen=""></iframe>');

-- --------------------------------------------------------

--
-- Table structure for table `hotel_invoice`
--

CREATE TABLE IF NOT EXISTS `hotel_invoice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `sales_by` int(11) NOT NULL,
  `invoice_no` varchar(255) NOT NULL,
  `invoice_date` varchar(255) NOT NULL,
  `due_date` varchar(255) NOT NULL,
  `no_of_guest` int(11) NOT NULL,
  `no_of_adult` int(11) NOT NULL,
  `no_of_room` int(11) NOT NULL,
  `hotel_id` int(11) NOT NULL,
  `check_in_date` varchar(255) NOT NULL,
  `check_out_date` varchar(255) NOT NULL,
  `room_type` varchar(255) NOT NULL,
  `bed_type` varchar(255) NOT NULL,
  `service_id` int(11) NOT NULL,
  `b2c_price` double NOT NULL,
  `quantity` int(11) NOT NULL,
  `unit_price` double NOT NULL,
  `total_price` double NOT NULL,
  `note` text NOT NULL,
  `sub_total` double NOT NULL,
  `vat` double NOT NULL,
  `grand_total` double NOT NULL,
  `discount` double NOT NULL,
  `net_total` double NOT NULL,
  `due_amount` double NOT NULL,
  `present` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `hotel_invoice`
--

INSERT INTO `hotel_invoice` (`id`, `client_id`, `sales_by`, `invoice_no`, `invoice_date`, `due_date`, `no_of_guest`, `no_of_adult`, `no_of_room`, `hotel_id`, `check_in_date`, `check_out_date`, `room_type`, `bed_type`, `service_id`, `b2c_price`, `quantity`, `unit_price`, `total_price`, `note`, `sub_total`, `vat`, `grand_total`, `discount`, `net_total`, `due_amount`, `present`) VALUES
(1, 1, 1, '1572069540', '2019-10-26', '2019-10-26', 1, 1, 1, 1, '2019-10-26', '2019-10-27', '2', '1', 0, 1000, 1, 1000, 0, 'test ', 1000, 0, 1000, 100, 900, 0, 900),
(2, 1, 1, '1572070454', '2019-10-26', '2019-10-26', 1, 1, 3, 1, '2019-10-26', '2019-10-27', '2', '', 0, 1000, 1, 1000, 0, '', 3000, 0, 3000, 100, 2900, 0, 2900);

-- --------------------------------------------------------

--
-- Table structure for table `hotel_meta_information`
--

CREATE TABLE IF NOT EXISTS `hotel_meta_information` (
  `hotel_meta_id` int(11) NOT NULL AUTO_INCREMENT,
  `meta_title` varchar(255) NOT NULL,
  `meta_keyword` text NOT NULL,
  `meta_description` longtext NOT NULL,
  PRIMARY KEY (`hotel_meta_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `hotel_meta_information`
--


-- --------------------------------------------------------

--
-- Table structure for table `hotel_property_type`
--

CREATE TABLE IF NOT EXISTS `hotel_property_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `property_type` text NOT NULL,
  `description` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `hotel_property_type`
--

INSERT INTO `hotel_property_type` (`id`, `property_type`, `description`) VALUES
(1, 'Hotel', 'Establishment that provides accommodations, meals,\r\nand other services for paying guests (travellers, tourists)'),
(2, 'Hostel', 'Budget accommodation (usually shared-room type) rent by\r\nindividual travellers (backpackers) or groups'),
(3, 'Villa', 'Furnished country house located in countryside area that is\r\noften rented for vacation purpose'),
(4, 'Resort', 'A fancy accommodation that is located in a very scenic or\r\nsometimes remote location without compromising modern\r\ntechnology and amenities'),
(5, 'Apartment', 'Serviced apartment complex with hotel-style booking system\r\nthat enables travellers to stay for a period of time'),
(6, 'Guest House/ B&B', 'An establishment that offers a spare room in private\r\naccommodation (e.g. private house, boarding house).\r\nIt also provides breakfast'),
(7, 'Other', '');

-- --------------------------------------------------------

--
-- Table structure for table `hotel_ratting`
--

CREATE TABLE IF NOT EXISTS `hotel_ratting` (
  `ratting_id` int(11) NOT NULL AUTO_INCREMENT,
  `hotel_id` int(11) NOT NULL,
  `ratting` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`ratting_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `hotel_ratting`
--

INSERT INTO `hotel_ratting` (`ratting_id`, `hotel_id`, `ratting`, `user_id`) VALUES
(1, 1, 3, 1);

-- --------------------------------------------------------

--
-- Table structure for table `hotel_room_information`
--

CREATE TABLE IF NOT EXISTS `hotel_room_information` (
  `hotel_room_id` int(11) NOT NULL AUTO_INCREMENT,
  `hotel_category` varchar(120) NOT NULL,
  `hotel_infor_id` varchar(120) NOT NULL,
  `title` varchar(150) NOT NULL,
  `room_type` varchar(100) NOT NULL,
  `capacity` varchar(120) NOT NULL,
  `avilability` varchar(130) NOT NULL,
  `fetures` varchar(1000) NOT NULL,
  `price` double NOT NULL,
  `check_in_date` date NOT NULL,
  `check_out_date` date NOT NULL,
  `photo` varchar(120) NOT NULL,
  `room_description` longtext NOT NULL,
  PRIMARY KEY (`hotel_room_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `hotel_room_information`
--

INSERT INTO `hotel_room_information` (`hotel_room_id`, `hotel_category`, `hotel_infor_id`, `title`, `room_type`, `capacity`, `avilability`, `fetures`, `price`, `check_in_date`, `check_out_date`, `photo`, `room_description`) VALUES
(1, '', '1', 'Silver Deluxe', 'Silver Deluxe', '2', '2 rooms left', '1,2,3,4,5,6,7,8,9,10,', 21000, '2017-01-25', '2017-01-28', 'photo/1485320066.jpg', ''),
(2, '', '1', 'Silver Deluxe1', 'Silver Deluxe1', '2', '2 rooms left', '1,2,3,4,', 4000, '2017-01-25', '2017-01-26', 'photo/1485339626.jpg', ''),
(3, '', '1', 'sdfsd', 'sdfsd', '3', '2', '1,2,3,4,5,', 3500, '2017-06-01', '2017-06-09', 'photo/1498768421.png', '');

-- --------------------------------------------------------

--
-- Table structure for table `hotel_type`
--

CREATE TABLE IF NOT EXISTS `hotel_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `hotel_type`
--

INSERT INTO `hotel_type` (`id`, `type`) VALUES
(1, 'Apartment'),
(2, 'Hotel'),
(3, 'Guest House'),
(4, 'Motel'),
(5, 'Residence'),
(6, 'Resort'),
(7, 'Villa'),
(8, 'Time Share'),
(9, 'Extended Stay');

-- --------------------------------------------------------

--
-- Table structure for table `image`
--

CREATE TABLE IF NOT EXISTS `image` (
  `image_id` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(50) NOT NULL,
  `item_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `img_location` varchar(50) NOT NULL,
  PRIMARY KEY (`image_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `image`
--

INSERT INTO `image` (`image_id`, `category`, `item_id`, `position`, `img_location`) VALUES
(1, 'hotel', 1, 1, 'photo/14853192411.jpg'),
(2, 'hotel', 1, 2, 'photo/14853192412.jpg'),
(3, 'hotel', 1, 3, 'photo/14853192413.jpg'),
(4, 'hotel', 1, 4, 'photo/14853192414.jpg'),
(5, 'hotel', 1, 5, 'photo/14853192415.jpg'),
(6, 'hotel', 1, 6, 'photo/14853192416.jpg'),
(7, 'tour', 1, 1, 'photo/14853439201.jpg'),
(8, 'tour', 1, 2, 'photo/14853439212.jpg'),
(9, 'tour', 1, 3, 'photo/14853439213.jpg'),
(10, 'tour', 1, 4, 'photo/14853439214.jpg'),
(11, 'tour', 1, 5, 'photo/14853439215.jpg'),
(12, 'tour', 1, 6, 'photo/14853439216.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `login_information`
--

CREATE TABLE IF NOT EXISTS `login_information` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `person_id` int(11) NOT NULL,
  `user_name` varchar(255) NOT NULL,
  `pssword` varchar(255) NOT NULL,
  `date_time` varchar(255) NOT NULL,
  `ip_address` varchar(255) NOT NULL,
  `mac_address` varchar(255) NOT NULL,
  `status` int(11) NOT NULL COMMENT '1=login, 0=logout',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=192 ;

--
-- Dumping data for table `login_information`
--

INSERT INTO `login_information` (`id`, `person_id`, `user_name`, `pssword`, `date_time`, `ip_address`, `mac_address`, `status`) VALUES
(130, 1, 'travel', '123', '2019-05-20 02:10:02 am', '::1', '5C-93-A2-D0-7F-F6', 1),
(131, 1, '', '', '2019-05-19 19:14:39 pm', '::1', '5C-93-A2-D0-7F-F6', 0),
(132, 1, 'travel', '123', '2019-05-20 02:15:54 am', '::1', '5C-93-A2-D0-7F-F6', 1),
(133, 1, '', '', '2019-05-19 19:23:49 pm', '::1', '5C-93-A2-D0-7F-F6', 0),
(134, 1, 'travel', '123', '2019-05-20 02:24:00 am', '::1', '5C-93-A2-D0-7F-F6', 1),
(135, 1, '', '', '2019-05-19 19:31:39 pm', '::1', '5C-93-A2-D0-7F-F6', 0),
(136, 1, 'travel', '123', '2019-05-20 02:32:43 am', '::1', '5C-93-A2-D0-7F-F6', 1),
(137, 1, '', '', '2019-05-19 22:29:12 pm', '::1', '5C-93-A2-D0-7F-F6', 0),
(138, 1, 'travel', '123', '2019-05-20 05:31:56 am', '::1', '5C-93-A2-D0-7F-F6', 1),
(139, 1, 'travel', '1', '2019-05-20 23:31:51 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(140, 1, '', '', '2019-05-20 16:36:10 pm', '::1', 'CC-2F-71-D3-F3-0B', 0),
(141, 1, 'travel', '1', '2019-05-20 23:36:22 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(142, 1, '', '', '2019-05-20 20:14:09 pm', '::1', 'CC-2F-71-D3-F3-0B', 0),
(143, 2, 'nazmulfci', '123', '2019-05-21 03:14:24 am', '::1', 'CC-2F-71-D3-F3-0B', 1),
(144, 2, '', '', '2019-05-20 20:19:49 pm', '::1', 'CC-2F-71-D3-F3-0B', 0),
(145, 3, 'saiful', '123', '2019-05-21 03:20:14 am', '::1', 'CC-2F-71-D3-F3-0B', 1),
(146, 3, 'saiful', '123', '2019-05-21 22:43:17 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(147, 3, 'saiful', '123', '2019-05-21 22:52:14 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(148, 3, 'saiful', '123', '2019-05-22 22:37:28 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(149, 3, 'saiful', '123', '2019-05-23 21:51:29 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(150, 3, 'saiful', '123', '2019-05-23 22:49:48 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(151, 3, 'saiful', '123', '2019-05-23 22:56:27 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(152, 3, 'saiful', '123', '2019-05-24 03:06:47 am', '::1', 'CC-2F-71-D3-F3-0B', 1),
(153, 3, 'saiful', '123', '2019-05-25 19:16:40 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(154, 3, 'saiful', '123', '2019-05-25 23:19:30 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(155, 3, 'saiful', '123', '2019-05-26 05:12:07 am', '::1', 'CC-2F-71-D3-F3-0B', 1),
(156, 3, 'saiful', '123', '2019-05-27 21:31:16 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(157, 3, 'saiful', '123', '2019-05-27 23:27:33 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(158, 3, 'saiful', '123', '2019-05-28 22:02:38 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(159, 3, '', '', '2019-05-28 18:28:51 pm', '::1', 'CC-2F-71-D3-F3-0B', 0),
(160, 1, 'travel', '2', '2019-05-29 01:29:02 am', '::1', 'CC-2F-71-D3-F3-0B', 1),
(161, 1, 'travel', '2', '2019-05-29 02:19:54 am', '::1', 'CC-2F-71-D3-F3-0B', 1),
(162, 1, 'travel', '2', '2019-05-29 20:21:19 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(163, 1, 'travel', '2', '2019-05-30 16:40:19 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(164, 1, 'travel', '2', '2019-05-30 16:49:21 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(165, 1, 'travel', '2', '2019-05-30 22:17:33 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(166, 1, 'travel', '2', '2019-05-31 18:35:22 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(167, 1, 'travel', '2', '2019-05-31 20:48:36 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(168, 1, '', '', '2019-05-31 15:35:54 pm', '::1', 'CC-2F-71-D3-F3-0B', 0),
(169, 1, 'travel', '2', '2019-05-31 22:36:14 pm', '::1', 'CC-2F-71-D3-F3-0B', 1),
(170, 1, 'travel', '2', '2019-05-31 23:31:50 pm', '180.148.214.53', '', 1),
(171, 1, 'travel', '2', '2019-06-19 01:42:14 am', '180.148.214.53', '', 1),
(172, 1, '', '', '2019-06-18 15:43:43 pm', '180.148.214.53', '', 0),
(173, 1, 'travel', '2', '2019-06-26 14:34:22 pm', '103.66.177.253', '', 1),
(174, 1, 'travel', '2', '2019-06-27 01:13:07 am', '103.87.212.178', '', 1),
(175, 1, 'travel', '2', '2019-06-27 05:59:04 am', '103.87.212.178', '', 1),
(176, 1, 'travel', '2', '2019-06-27 15:56:49 pm', '111.221.6.25', '', 1),
(177, 1, 'travel', '2', '2019-06-27 17:46:56 pm', '111.221.6.25', '', 1),
(178, 1, 'travel', '2', '2019-09-16 00:42:13 am', '::1', 'D8-FC-93-4E-4A-20', 1),
(179, 1, 'travel', '2', '2019-09-17 12:10:12 pm', '::1', 'D8-FC-93-4E-4A-20', 1),
(180, 1, 'travel', '2', '2019-09-17 14:23:45 pm', '::1', 'D8-FC-93-4E-4A-20', 1),
(181, 1, 'travel', '2', '2019-09-19 17:51:28 pm', '::1', 'D8-FC-93-4E-4A-20', 1),
(182, 1, 'travel', '2', '2019-09-23 11:43:33 am', '::1', 'D8-FC-93-4E-4A-20', 1),
(183, 1, 'travel', '2', '2019-09-23 22:18:18 pm', '::1', 'D8-FC-93-4E-4A-20', 1),
(184, 94, '', '', '2019-09-24 10:57:50 am', '::1', 'D8-FC-93-4E-4A-20', 0),
(185, 1, 'travel', '2', '2019-09-24 17:57:57 pm', '::1', 'D8-FC-93-4E-4A-20', 1),
(186, 1, '', '', '2019-10-02 20:37:03 pm', '::1', 'D8-FC-93-4E-4A-20', 0),
(187, 1, 'travel', '2', '2019-10-02 20:43:30 pm', '::1', 'D8-FC-93-4E-4A-20', 1),
(188, 1, 'travel', '2', '2019-10-07 19:31:05 pm', '::1', 'D8-FC-93-4E-4A-20', 1),
(189, 1, 'siyam', '2', '2019-10-21 19:48:43 pm', '::1', 'D8-FC-93-4E-4A-20', 1),
(190, 1, 'siyam', '2', '2019-10-26 12:46:54 pm', '::1', 'D8-FC-93-4E-4A-20', 1),
(191, 1, 'siyam', '2', '2019-10-27 17:22:47 pm', '::1', 'D8-FC-93-4E-4A-20', 1);

-- --------------------------------------------------------

--
-- Table structure for table `menu`
--

CREATE TABLE IF NOT EXISTS `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_name` varchar(255) NOT NULL,
  `sub_menu` int(11) NOT NULL,
  `sub_menu_class` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `menu`
--


-- --------------------------------------------------------

--
-- Table structure for table `month_list`
--

CREATE TABLE IF NOT EXISTS `month_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `month_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `month_list`
--

INSERT INTO `month_list` (`id`, `month_name`) VALUES
(1, 'January'),
(2, 'February'),
(3, 'March'),
(4, 'April'),
(5, 'May'),
(6, 'June'),
(7, 'July'),
(8, 'August'),
(9, 'September'),
(10, 'October'),
(11, 'November'),
(12, 'December');

-- --------------------------------------------------------

--
-- Table structure for table `payment_option`
--

CREATE TABLE IF NOT EXISTS `payment_option` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `option_name` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `payment_option`
--

INSERT INTO `payment_option` (`id`, `option_name`) VALUES
(1, 'Skrill'),
(2, 'Credit Card'),
(3, 'American Express'),
(4, 'Paypal'),
(5, 'Master/Visa Card'),
(6, 'Pay on Arrival');

-- --------------------------------------------------------

--
-- Table structure for table `processing_fee`
--

CREATE TABLE IF NOT EXISTS `processing_fee` (
  `fee_id` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(55) NOT NULL,
  `website_fee` double NOT NULL,
  `type` varchar(55) NOT NULL,
  `processing_fee` double NOT NULL,
  PRIMARY KEY (`fee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `processing_fee`
--


-- --------------------------------------------------------

--
-- Table structure for table `room_bed_type`
--

CREATE TABLE IF NOT EXISTS `room_bed_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bed_type` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `room_bed_type`
--

INSERT INTO `room_bed_type` (`id`, `bed_type`) VALUES
(1, 'Single Bed'),
(2, 'Twin bed');

-- --------------------------------------------------------

--
-- Table structure for table `room_facilities`
--

CREATE TABLE IF NOT EXISTS `room_facilities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `facilities` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ;

--
-- Dumping data for table `room_facilities`
--

INSERT INTO `room_facilities` (`id`, `facilities`) VALUES
(1, 'Access via exterior corridors'),
(2, 'Bathroom phone'),
(3, 'Climate control'),
(4, 'Courtyard view'),
(5, 'Extra towels/bedding'),
(6, 'Hair dryer'),
(7, 'Individually decorated'),
(8, 'In-room safe (laptop compatible)'),
(9, 'Makeup/shaving mirror'),
(10, 'Refrigerator'),
(11, 'Shower/tub combination'),
(12, 'Welcome amenities'),
(13, 'Air conditioning'),
(14, 'Blackout drapes/curtains'),
(15, 'Complimentary toiletries'),
(16, 'Cribs/infant beds available'),
(17, 'Dial-up Internet access (surcharge)'),
(18, 'Free Wi-Fi'),
(19, 'Handheld showerhead'),
(20, 'Individually furnished'),
(21, 'Iron/ironing board (on request)'),
(22, 'Minibar'),
(23, 'Satellite TV service'),
(24, 'Slippers'),
(25, 'Bathrobes'),
(26, 'City view'),
(27, 'Complimentary weekday newspaper'),
(28, 'Daily housekeeping'),
(29, 'Direct-dial phone'),
(30, 'Free wired high-speed Internet'),
(31, 'Hypo-allergenic bedding available'),
(32, ' In-room childcare (surcharge)'),
(33, 'LCD TV'),
(34, 'Private bathroom'),
(35, 'Bathrobes'),
(36, 'Wake-up calls');

-- --------------------------------------------------------

--
-- Table structure for table `room_gallery`
--

CREATE TABLE IF NOT EXISTS `room_gallery` (
  `room_gallery_id` int(11) NOT NULL AUTO_INCREMENT,
  `room_id` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  PRIMARY KEY (`room_gallery_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `room_gallery`
--

INSERT INTO `room_gallery` (`room_gallery_id`, `room_id`, `type`, `image`) VALUES
(1, 1, 1, 'images/hotel/bedroom_1559142719.webp'),
(2, 1, 2, 'images/hotel/bedroom1_1559142719.webp'),
(3, 1, 3, 'images/hotel/bedroom2_1559142719.webp'),
(4, 1, 4, 'images/hotel/bedroom3_1559142719.webp');

-- --------------------------------------------------------

--
-- Table structure for table `room_information`
--

CREATE TABLE IF NOT EXISTS `room_information` (
  `room_info_id` int(11) NOT NULL AUTO_INCREMENT,
  `room_status` int(11) NOT NULL,
  `room_type` int(11) NOT NULL,
  `bed_type` int(11) NOT NULL,
  `hotel_id` int(11) NOT NULL,
  `room_description` longtext NOT NULL,
  `vendor_price` double NOT NULL,
  `b2c_price` double NOT NULL,
  `b2b_price` double NOT NULL,
  `currency_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `min_stay` int(11) NOT NULL,
  `max_adults` int(11) NOT NULL,
  `max_children` int(11) NOT NULL,
  `ex_bed` int(11) NOT NULL,
  `ex_bed_charge` double NOT NULL,
  `room_facilities` text NOT NULL,
  PRIMARY KEY (`room_info_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `room_information`
--

INSERT INTO `room_information` (`room_info_id`, `room_status`, `room_type`, `bed_type`, `hotel_id`, `room_description`, `vendor_price`, `b2c_price`, `b2b_price`, `currency_id`, `quantity`, `min_stay`, `max_adults`, `max_children`, `ex_bed`, `ex_bed_charge`, `room_facilities`) VALUES
(1, 1, 3, 0, 1, '<p>sdfsdf</p>\r\n', 250, 0, 0, 1, 21, 0, 0, 0, 0, 0, ''),
(2, 2, 2, 1, 1, '<p>sdfsdf</p>\r\n', 150, 1000, 800, 5, 100, 120, 2, 1, 1, 2, '');

-- --------------------------------------------------------

--
-- Table structure for table `room_price_information`
--

CREATE TABLE IF NOT EXISTS `room_price_information` (
  `room_price_information_id` int(11) NOT NULL AUTO_INCREMENT,
  `room_id` int(11) NOT NULL,
  `date_to` varchar(200) NOT NULL,
  `date_from` varchar(200) NOT NULL,
  `adult` int(11) NOT NULL,
  `children` int(11) NOT NULL,
  `extra_bed` int(11) NOT NULL,
  `mon` double NOT NULL,
  `tue` double NOT NULL,
  `wed` double NOT NULL,
  `thu` double NOT NULL,
  `fri` double NOT NULL,
  `sat` double NOT NULL,
  `sun` double NOT NULL,
  PRIMARY KEY (`room_price_information_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `room_price_information`
--

INSERT INTO `room_price_information` (`room_price_information_id`, `room_id`, `date_to`, `date_from`, `adult`, `children`, `extra_bed`, `mon`, `tue`, `wed`, `thu`, `fri`, `sat`, `sun`) VALUES
(1, 3, '2019-05-28', '2019-05-31', 1, 1, 0, 41, 41, 41, 41, 41, 41, 41),
(3, 2, '2019-04-29', '2019-05-16', 2, 1, 0, 5, 45, 45, 54, 54, 54, 54);

-- --------------------------------------------------------

--
-- Table structure for table `room_type`
--

CREATE TABLE IF NOT EXISTS `room_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `room_type`
--

INSERT INTO `room_type` (`id`, `type`) VALUES
(1, 'Superior Room'),
(2, 'Delux Room'),
(3, 'Classic Room'),
(4, 'Executive Suite'),
(5, 'Junior Suite'),
(6, 'Park Suite'),
(7, 'Studio Premier'),
(8, 'Standard Room'),
(9, 'Executive Room'),
(10, 'Executive Family Room');

-- --------------------------------------------------------

--
-- Table structure for table `sightseeing_new`
--

CREATE TABLE IF NOT EXISTS `sightseeing_new` (
  `sightseeing_id` int(11) NOT NULL AUTO_INCREMENT,
  `sightseeing_code` varchar(255) NOT NULL,
  `sightseeing_name` varchar(255) NOT NULL,
  `sightseeing_country_id` int(11) NOT NULL,
  `sightseeing_area` text NOT NULL,
  `sightseeing_logo` varchar(255) NOT NULL,
  `sightseeing_unique_id` varchar(255) NOT NULL,
  `sightseeing_note` text NOT NULL,
  PRIMARY KEY (`sightseeing_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `sightseeing_new`
--


-- --------------------------------------------------------

--
-- Table structure for table `slider`
--

CREATE TABLE IF NOT EXISTS `slider` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) NOT NULL,
  `image` varchar(120) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `title`, `image`) VALUES
(1, 'Best hotel flight tour event platform', 'image/1485318998.jpg'),
(2, 'Best hotel flight tour event platform', 'image/1485319009.jpg'),
(3, 'Best hotel flight tour event platform', 'image/1485319018.jpg'),
(4, 'Best hotel flight tour event platform', 'image/1485319026.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `ss_all_service`
--

CREATE TABLE IF NOT EXISTS `ss_all_service` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` text NOT NULL,
  `public_adult` varchar(100) NOT NULL,
  `public_child` varchar(100) NOT NULL,
  `agent_adult` varchar(100) NOT NULL,
  `agent_child` varbinary(100) NOT NULL,
  `joint_adult` varchar(100) NOT NULL,
  `joint_child` varchar(100) NOT NULL,
  `u_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `ss_all_service`
--


-- --------------------------------------------------------

--
-- Table structure for table `state_position`
--

CREATE TABLE IF NOT EXISTS `state_position` (
  `state_id` int(11) NOT NULL AUTO_INCREMENT,
  `country` int(11) NOT NULL,
  `city` int(11) NOT NULL,
  `state_name` varchar(150) NOT NULL,
  PRIMARY KEY (`state_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `state_position`
--

INSERT INTO `state_position` (`state_id`, `country`, `city`, `state_name`) VALUES
(1, 1, 1, 'Bargun dfdsf');

-- --------------------------------------------------------

--
-- Table structure for table `tours_pakage_information`
--

CREATE TABLE IF NOT EXISTS `tours_pakage_information` (
  `tour_pakage_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) NOT NULL,
  `price` double NOT NULL,
  `place_name` varchar(200) NOT NULL,
  `visa_asset` varchar(200) NOT NULL,
  `tour_type` varchar(200) NOT NULL,
  `tour_duration` varchar(200) NOT NULL,
  `payment_method` varchar(200) NOT NULL,
  `person` int(11) NOT NULL,
  `help_line` varchar(200) NOT NULL,
  `location` varchar(200) NOT NULL,
  `description` longtext NOT NULL,
  `include` varchar(200) NOT NULL,
  `exclude` varchar(200) NOT NULL,
  PRIMARY KEY (`tour_pakage_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `tours_pakage_information`
--

INSERT INTO `tours_pakage_information` (`tour_pakage_id`, `title`, `price`, `place_name`, `visa_asset`, `tour_type`, `tour_duration`, `payment_method`, `person`, `help_line`, `location`, `description`, `include`, `exclude`) VALUES
(1, 'Exclusive Sundarban Tour', 9500, 'Sundarban', 'N/A ', 'Economy', '3 Night(s), 2 Day(s) ', 'bKash and Cash on delivery ', 2, ' 09666770066', 'Sundarban', '“Sundarbanâ€- this word describes almost everything about what one is going to enjoy in this adventurous tour. Literal bengali meaning of Sunderban is beautiful forest. Moreover, world’s largest mangrove forest is Sunderban. It approximately covers 10000 square kilometer area of which 60 percent is in Bangladesh.\r\n\r\nSundarban is the home of various flora and fauna. Sundari, Gewa, Goran, Keora etc. are the main attraction of flora side. On the other side, Royal Bengal tiger, Deer, Monkey and Crocodile are the main attraction of fauna side. \r\n', '1,2,6,7,', '3,4,5,');

-- --------------------------------------------------------

--
-- Table structure for table `tour_booking_order`
--

CREATE TABLE IF NOT EXISTS `tour_booking_order` (
  `tour_booking_order_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `tour_id` int(11) NOT NULL,
  `price` double NOT NULL,
  `adult_price` double NOT NULL,
  `child_price` double NOT NULL,
  `total_price` double NOT NULL,
  `adult` int(11) NOT NULL,
  `child` int(11) NOT NULL,
  `tour_date` date NOT NULL,
  `name` varchar(255) NOT NULL,
  `contact_no` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `add1` varchar(255) NOT NULL,
  `add2` varchar(255) NOT NULL,
  `land_mark` varchar(255) NOT NULL,
  `postal_code` varchar(255) NOT NULL,
  `booking_type` varchar(255) NOT NULL,
  `card_type` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`tour_booking_order_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tour_booking_order`
--

INSERT INTO `tour_booking_order` (`tour_booking_order_id`, `user_id`, `tour_id`, `price`, `adult_price`, `child_price`, `total_price`, `adult`, `child`, `tour_date`, `name`, `contact_no`, `email`, `add1`, `add2`, `land_mark`, `postal_code`, `booking_type`, `card_type`, `city`, `status`, `date`) VALUES
(1, 1, 1, 9500, 9500, 9500, 0, 1, 1, '2017-01-25', 'nazmul huda', '2309234234039', 'nazmulfci@gmail.com', '', '', '', '', '1', '', '', 1, '2017-06-17 19:02:37');

-- --------------------------------------------------------

--
-- Table structure for table `tour_day_info`
--

CREATE TABLE IF NOT EXISTS `tour_day_info` (
  `day_id` int(11) NOT NULL AUTO_INCREMENT,
  `tour_id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `description` longtext NOT NULL,
  PRIMARY KEY (`day_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `tour_day_info`
--

INSERT INTO `tour_day_info` (`day_id`, `tour_id`, `title`, `description`) VALUES
(1, 1, 'Day 1', 'Leave Dhaka at 22:30 pm by reserved AC Night Coach for Khulna.'),
(2, 1, 'Day 2', 'Check in the hotel. \r\nAfter breakfast go for site seeing. \r\nCome back to the hotel. \r\nFinish lunch and take rest. \r\nSet out again to enjoy the afternoon beauty of Sundarban. \r\nFinish the dinner and have a sound sleep to be fit for the next day more adventure.'),
(3, 1, 'Day # 3', 'Get up early in the morning. \r\nEnjoy the nice scene of sunrise. \r\nAfter breakfast go for site seeing. \r\nIf you want you can have your lunch in rural restaurant or come back to the hotel to finish your lunch. \r\nFinish lunch and take rest. \r\nSet out again to enjoy the afternoon beauty of Sundarban. \r\nFinish the dinner and have a sound sleep to be fit for the next day more adventure. \r\nCheck out from the hotel and set out for your sweet home with sweet dreams you have gained from your nice journey.');

-- --------------------------------------------------------

--
-- Table structure for table `tour_facility`
--

CREATE TABLE IF NOT EXISTS `tour_facility` (
  `facility_id` int(11) NOT NULL AUTO_INCREMENT,
  `facility` varchar(200) NOT NULL,
  PRIMARY KEY (`facility_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `tour_facility`
--

INSERT INTO `tour_facility` (`facility_id`, `facility`) VALUES
(1, 'Dhaka - Khulna - Dhaka Non AC Bus.'),
(2, '2 Nights Accommodation on Cruise.'),
(3, 'All Meals During The trip.'),
(4, 'All Activities inside the forest.'),
(5, 'BAR-B-Q dinner on last night.'),
(6, 'Forest fee and Permission.'),
(7, 'Armed forest guard from the forest dep');

-- --------------------------------------------------------

--
-- Table structure for table `transport_booking_order`
--

CREATE TABLE IF NOT EXISTS `transport_booking_order` (
  `transport_order_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `transport_id` int(11) NOT NULL,
  `price` double NOT NULL,
  `name` varchar(255) NOT NULL,
  `contact_no` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `add1` varchar(255) NOT NULL,
  `add2` varchar(255) NOT NULL,
  `land_mark` varchar(255) NOT NULL,
  `postal_code` varchar(255) NOT NULL,
  `booking_type` varchar(255) NOT NULL,
  `card_type` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`transport_order_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `transport_booking_order`
--

INSERT INTO `transport_booking_order` (`transport_order_id`, `user_id`, `transport_id`, `price`, `name`, `contact_no`, `email`, `add1`, `add2`, `land_mark`, `postal_code`, `booking_type`, `card_type`, `city`, `status`, `date`) VALUES
(1, 3, 0, 10000, 'nazmul huda', '2309234234039', 'nazmulfci@gmail.com', '', '', '', '', '1', '', '', 0, '2017-06-17 19:09:22'),
(2, 1, 1, 10000, 'nazmul huda', '091991911991922', 'nazmulci@yahoo.com', 'add', 'addd', 'land', '1207', '2', '', '', 0, '2017-06-17 19:09:05'),
(3, 1, 1, 10000, 'nazmul huda', '01912323399', 'nazmulfci@yahoo.com', '', '', '', '', '3', '', '', 1, '2017-01-26 07:39:14'),
(4, 2, 1, 10000, '', '', '', '', '', '', '', '1', '', '', 0, '2017-06-17 19:09:13');

-- --------------------------------------------------------

--
-- Table structure for table `transport_information`
--

CREATE TABLE IF NOT EXISTS `transport_information` (
  `transport_info_id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL,
  `location1` varchar(250) NOT NULL,
  `date1` varchar(250) NOT NULL,
  `time1` varchar(250) NOT NULL,
  `distance` varchar(250) NOT NULL,
  `situations` varchar(250) NOT NULL,
  `location2` varchar(250) NOT NULL,
  `date2` varchar(250) NOT NULL,
  `time2` varchar(250) NOT NULL,
  `hr` varchar(250) NOT NULL,
  `coverages` varchar(250) NOT NULL,
  `price` double NOT NULL,
  `description` longtext NOT NULL,
  `terms_condition` longtext NOT NULL,
  `image` varchar(250) NOT NULL,
  PRIMARY KEY (`transport_info_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `transport_information`
--

INSERT INTO `transport_information` (`transport_info_id`, `title`, `location1`, `date1`, `time1`, `distance`, `situations`, `location2`, `date2`, `time2`, `hr`, `coverages`, `price`, `description`, `terms_condition`, `image`) VALUES
(1, 'Toyota Land Cruiser Prado', 'Dhaka', '2017-01-26', '01:00 AM', '38km', '1,2,4,5,', 'Gazipur ', '2017-01-26', '3:00', '6(appx.)', '1,2,', 10000, 'If the client take vehicle outside of Dhaka an additional tour allowance will have to be paid by user per day BDT 1000.00 to cover accommodation and food of the Driver & after reaching to the destination the renter will take the responsibility for the safety and security of the vehicle\r\n\r\nThe vehicle will carry only the Passengers & their Luggage and prohibited carry any Contraband Items, heavy materials or Oily/Dirty substances.', 'Photocopy of valid trade license should clearly mention computer-related business.Bank Solvency certificate (current dated and original).Bank Accounts Statement of last year (in original).Photocopy of VAT Registration Certificate.Photocopy of Taxpayers Identification Number (TIN) Certificate. Audited Balance Sheet of last year of the firm.', 'photo/1485346754.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `v_new_passport`
--

CREATE TABLE IF NOT EXISTS `v_new_passport` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) NOT NULL,
  `agent_id` int(11) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `gender` int(11) NOT NULL,
  `nationality` int(11) NOT NULL,
  `dob_date` varchar(50) NOT NULL,
  `country_of_birth` int(11) NOT NULL,
  `country_of_residence` int(11) NOT NULL,
  `passport_no` varchar(255) NOT NULL,
  `pass_issu_date` varchar(255) NOT NULL,
  `pass_exp_date` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `date` varchar(255) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `v_new_passport`
--

INSERT INTO `v_new_passport` (`id`, `type`, `agent_id`, `first_name`, `last_name`, `gender`, `nationality`, `dob_date`, `country_of_birth`, `country_of_residence`, `passport_no`, `pass_issu_date`, `pass_exp_date`, `status`, `date`, `date_time`) VALUES
(1, 1, 1, 'Nazmul ', 'hud', 1, 1, '1994-1-1', 18, 18, 'BW0922894', '2018-6-23', '2019-6-22', 0, '', '2019-09-19 17:13:42');

-- --------------------------------------------------------

--
-- Table structure for table `v_passport_action_list`
--

CREATE TABLE IF NOT EXISTS `v_passport_action_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_list` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `v_passport_action_list`
--

INSERT INTO `v_passport_action_list` (`id`, `action_list`) VALUES
(1, 'Receive from Customer'),
(2, 'Submit to Embassy'),
(3, 'Receive from Embassy'),
(4, 'Delivery to Customer'),
(16, 'Delivery to Agent');

-- --------------------------------------------------------

--
-- Table structure for table `v_visa_duration`
--

CREATE TABLE IF NOT EXISTS `v_visa_duration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `duration` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `v_visa_duration`
--

INSERT INTO `v_visa_duration` (`id`, `duration`) VALUES
(1, '10 Days'),
(2, '15 Days'),
(3, '20 Days'),
(4, '30 Days'),
(5, '45 Days'),
(6, '60 Days'),
(7, '90 Days'),
(8, '120 Days'),
(9, '180 Days'),
(10, '365 Days');

-- --------------------------------------------------------

--
-- Table structure for table `v_visa_information`
--

CREATE TABLE IF NOT EXISTS `v_visa_information` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `visa_type` int(11) NOT NULL,
  `country` int(11) NOT NULL,
  `visa_price` double NOT NULL,
  `vendor_price` double NOT NULL,
  `profit` double NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `v_visa_information`
--


-- --------------------------------------------------------

--
-- Table structure for table `v_visa_price_currency`
--

CREATE TABLE IF NOT EXISTS `v_visa_price_currency` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `corrency` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `v_visa_price_currency`
--

INSERT INTO `v_visa_price_currency` (`id`, `corrency`) VALUES
(1, 'BDT'),
(2, 'USD'),
(3, 'THB'),
(4, 'RM'),
(5, 'SGD'),
(6, 'INR'),
(7, 'AED'),
(8, 'Euro');

-- --------------------------------------------------------

--
-- Table structure for table `v_visa_price_information`
--

CREATE TABLE IF NOT EXISTS `v_visa_price_information` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `visa_id` varchar(100) NOT NULL,
  `country_id` int(11) NOT NULL,
  `visa_type_id` int(11) NOT NULL,
  `visa_cost` double NOT NULL,
  `processing_time_id` int(11) NOT NULL,
  `processing_fee` double NOT NULL,
  `visa_duration_id` int(11) NOT NULL,
  `visa_requirement_ids` varchar(255) NOT NULL,
  `photo_size` varchar(255) NOT NULL,
  `currency_id` int(11) NOT NULL,
  `embassy_information` longtext NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `v_visa_price_information`
--

INSERT INTO `v_visa_price_information` (`id`, `visa_id`, `country_id`, `visa_type_id`, `visa_cost`, `processing_time_id`, `processing_fee`, `visa_duration_id`, `visa_requirement_ids`, `photo_size`, `currency_id`, `embassy_information`, `status`) VALUES
(1, '1', 217, 1, 5000, 1, 200, 1, '1,2,3,4', '12X12  usa standered', 1, '<p>this is embassy information</p>\r\n', 1);

-- --------------------------------------------------------

--
-- Table structure for table `v_visa_processing_time`
--

CREATE TABLE IF NOT EXISTS `v_visa_processing_time` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `v_visa_processing_time`
--

INSERT INTO `v_visa_processing_time` (`id`, `time`) VALUES
(1, 'Minimum 3 Days'),
(2, 'Minimum 5 Days'),
(3, 'Minimum 7 Days'),
(4, 'Minimum 10 Days'),
(5, 'Minimum 15 Days'),
(6, 'Minimum 20 Days'),
(7, 'Minimum 25 Days'),
(8, 'Minimum 30 Days'),
(9, 'Minimum 45 Days'),
(10, 'Minimum 90 Days'),
(11, '96 Hours');

-- --------------------------------------------------------

--
-- Table structure for table `v_visa_requirement`
--

CREATE TABLE IF NOT EXISTS `v_visa_requirement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `requirement` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ;

--
-- Dumping data for table `v_visa_requirement`
--

INSERT INTO `v_visa_requirement` (`id`, `requirement`) VALUES
(1, 'Passport in original with a minimum validity of six months'),
(2, 'Colour photograph not less than 3 months old'),
(3, ' No Objection Certificate from the Employer'),
(4, 'Bank statement 06 month'),
(5, 'Bank Solvency'),
(6, 'Salary / Pay Slip'),
(7, ' Invitation Letter from Renewed Company/Permanent Residence'),
(8, '  NID card and Birthday certificate/School ID'),
(9, ' Marriage Certificate'),
(10, 'Business/Visting Card'),
(11, ' Trade Lisence/MOA With Notary'),
(12, ' Return Ticket/Hotel Confirmation'),
(13, 'Proof of Residence'),
(14, 'Tax Certificate'),
(15, 'Asset Valuation'),
(16, 'Company Balance Sheet'),
(17, 'Travel or Helth Insurance');

-- --------------------------------------------------------

--
-- Table structure for table `v_visa_type`
--

CREATE TABLE IF NOT EXISTS `v_visa_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `v_visa_type`
--

INSERT INTO `v_visa_type` (`id`, `type`) VALUES
(1, 'Tourist Visa'),
(2, 'Business Visa'),
(3, 'Medical Visa'),
(4, 'E-Visa'),
(5, 'Social Visa'),
(6, 'Transit Visa'),
(7, 'Work Visa'),
(8, 'Umrah Visa'),
(9, 'Hajj Visa'),
(10, 'On Arrival Visa');

