-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Dec 14, 2024 at 06:40 AM
-- Server version: 8.0.30
-- PHP Version: 8.2.24
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `crmdb`
--
-- --------------------------------------------------------
--
-- Table structure for table `admin_users`
--
CREATE TABLE `admin_users` (
`id` bigint UNSIGNED NOT NULL,
`first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`auth_id` bigint UNSIGNED NOT NULL,
`profile_pic` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`profile_pic_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`pic_mime_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` tinyint NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `admin_users`
--
INSERT INTO `admin_users` (`id`, `first_name`, `last_name`, `designation`, `auth_id`, `profile_pic`, `profile_pic_url`, `pic_mime_type`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(10, 'Rony', 'Mia', 'administrator', 16, 'profile_11122023_1702284555.jpg', 'https://crm.dhakasoftwares.com/media/images/profile/profile_11122023_1702284555.jpg', NULL, 1, '2021-03-04 06:23:55', '2023-12-11 14:49:15', NULL),
(11, 'Maidul', 'Islam', 'Team Leader', 17, 'profile_16012024_1705392471.png', 'https://crm.dhakasoftwares.com/media/images/profile/profile_16012024_1705392471.png', NULL, 1, '2022-10-10 10:36:11', '2024-01-16 14:07:51', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `auths`
--
CREATE TABLE `auths` (
`id` bigint UNSIGNED NOT NULL,
`username` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`mobile_no` varchar(14) COLLATE utf8mb4_unicode_ci NOT NULL,
`password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`salt` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`model_id` bigint UNSIGNED NOT NULL COMMENT '1 = Admin',
`gender` tinyint NOT NULL DEFAULT '1',
`dob` date DEFAULT NULL,
`facebook_id` varchar(155) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`google_id` bigint DEFAULT NULL,
`activation_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`activation_code_expire` datetime DEFAULT NULL,
`is_first_login` tinyint NOT NULL DEFAULT '1',
`user_type` tinyint NOT NULL DEFAULT '0' COMMENT '0 = Admin',
`can_login` tinyint NOT NULL DEFAULT '1' COMMENT '1 = Can login, 0 = Can not login',
`status` tinyint NOT NULL DEFAULT '1' COMMENT '1 = Active, 0 = Inactive',
`created_by` int UNSIGNED NOT NULL DEFAULT '0',
`updated_by` int UNSIGNED NOT NULL DEFAULT '0',
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `auths`
--
INSERT INTO `auths` (`id`, `username`, `email`, `mobile_no`, `password`, `salt`, `model_id`, `gender`, `dob`, `facebook_id`, `google_id`, `activation_code`, `activation_code_expire`, `is_first_login`, `user_type`, `can_login`, `status`, `created_by`, `updated_by`, `remember_token`, `created_at`, `updated_at`) VALUES
(16, 'ronymia', 'ronymia.tech@gmail.com', '01767671133', '$2y$10$ol.KtLxyCrVL3TQH1CKeoerNqDOJYs5g59Z0.RhU37uL4t3KvSVYe', NULL, 1, 1, '2023-12-07', NULL, NULL, NULL, NULL, 1, 0, 1, 1, 0, 0, NULL, '2021-03-04 06:23:55', '2022-10-12 15:26:59'),
(17, 'maidul', 'maidul.tech@gmail.com', '01681944126', '$2y$10$FsfRbB1zVTAYwxMc.Ja0LeT6VDSfxByJ5wulM20rTxavpVWCyjtkG', NULL, 1, 1, '1990-05-10', NULL, NULL, NULL, NULL, 1, 0, 1, 1, 0, 0, NULL, '2022-10-10 10:36:11', '2022-10-10 10:36:11');
-- --------------------------------------------------------
--
-- Table structure for table `auth_role`
--
CREATE TABLE `auth_role` (
`id` bigint UNSIGNED NOT NULL,
`auth_id` bigint UNSIGNED NOT NULL,
`role_id` bigint UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`USER_GROUP_ID` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
--
-- Dumping data for table `auth_role`
--
INSERT INTO `auth_role` (`id`, `auth_id`, `role_id`, `created_at`, `updated_at`, `USER_GROUP_ID`) VALUES
(1, 1, 8, '2020-12-07 05:09:39', '2021-03-04 06:25:16', 8),
(2, 7, 8, '2020-12-26 12:35:42', '2021-01-03 13:29:26', 8),
(3, 8, 8, '2021-01-02 11:15:46', '2021-05-09 09:22:59', 8),
(4, 12, 14, '2021-01-05 06:43:22', '2021-03-03 13:14:59', 11),
(5, 13, 14, '2021-01-05 06:46:00', '2021-03-04 06:18:17', 11),
(6, 15, 12, '2021-01-05 06:48:59', '2021-01-05 06:48:59', 9),
(7, 16, 1, '2021-03-04 06:23:55', '2021-03-04 06:23:55', 7),
(8, 17, 1, '2022-10-10 10:36:11', '2022-10-10 10:36:11', 7);
-- --------------------------------------------------------
--
-- Table structure for table `crm_area`
--
CREATE TABLE `crm_area` (
`id` int NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`lon` varchar(100) DEFAULT NULL,
`lat` varchar(100) DEFAULT NULL,
`title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`meta_keywords` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`meta_description` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`note` varchar(500) DEFAULT NULL,
`rh_city_id` int DEFAULT NULL,
`is_delete` int DEFAULT NULL,
`is_active` int DEFAULT NULL,
`orderby` int DEFAULT NULL,
`created_by` varchar(255) DEFAULT NULL,
`modified_by` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`modified_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `crm_area`
--
INSERT INTO `crm_area` (`id`, `name`, `lon`, `lat`, `title`, `meta_keywords`, `meta_description`, `note`, `rh_city_id`, `is_delete`, `is_active`, `orderby`, `created_by`, `modified_by`, `created_at`, `modified_at`) VALUES
(4, 'Gulshan 02', '90.41388631', '23.79471042', 'Apartment or Flat, land Properties for Sale or Rent in Gulshan ', 'Gulshan ', 'Apartment Flat land properties for sale or rent in Gulshan ', NULL, 1, 1, 1, 0, '13', '30', '2016-05-29 12:50:45', '2020-07-02 16:38:43'),
(5, 'Uttara', '90.400304', '23.867800', 'Apartment or Flat, land Properties for Sale or Rent in Uttara', 'Property for Sale in Uttara', 'Apartment or Flat, land Properties for Sale or Rent in Uttara', NULL, 1, 1, 1, 0, '13', '13', '2016-05-29 12:58:46', '2016-08-31 16:17:18'),
(8, 'Mirpur 1', '90.353451', '23.798441', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 1', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 1', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 1', NULL, 1, 1, 1, 0, '13', '11', '2016-05-29 13:52:27', '2016-11-09 16:46:49'),
(9, 'Malibag', '90.414230', '23.744060', 'Apartment flat plot commercial space office space for sale rent in Malibag', 'Malibag, Malibag Rail Gate, Malibagh, Malibag DIT Road, Mouchak, Malibag 1st Lane', 'Apartment flat plot commercial space office space for sale rent in Malibag', NULL, 1, 1, 1, 0, '13', '13', '2016-06-16 03:41:55', '2016-08-31 16:28:06'),
(10, 'Banani', '90.4042719', '23.7939927', 'Apartment Flat for sale or rent in Banai', 'Apartment Flat for sale or rent in Banai', 'Apartment Flat for sale or rent in Banai', NULL, 1, 1, 1, 0, '1', '11', '2016-06-16 12:01:50', '2016-10-30 19:03:06'),
(11, 'Dhanmondi', '90.370435', '23.747654', 'Dhanmondi', 'Dhanmondi', 'Dhanmondi', NULL, 1, 1, 1, 0, '1', '13', '2016-06-16 12:02:23', '2016-08-31 16:30:23'),
(12, 'Rampura', '90.419186', '23.761500', 'Rampura', 'Rampura', 'Rampura', NULL, 1, 1, 1, 0, '1', '13', '2016-06-16 12:02:49', '2016-08-31 16:31:38'),
(13, 'Mohammadpur', '90.3586489', '23.76523198', 'Mohammadpur', 'Mohammadpur', 'Mohammadpur', NULL, 1, 1, 1, 0, '1', '13', '2016-06-16 12:03:12', '2016-08-30 12:40:27'),
(14, 'Badda', '90.425688', '23.780686', 'Badda', 'Badda', 'Badda', NULL, 1, 1, 1, 0, '1', '13', '2016-06-16 12:03:36', '2016-08-31 16:33:07'),
(15, 'Baridhara', '90.412856', '23.813768', 'Baridhara', 'Baridhara', 'Baridhara', NULL, 1, 1, 1, 0, '1', '13', '2016-06-16 12:04:01', '2016-08-31 16:36:37'),
(16, 'Purbachal', '90.496423', '23.840418', 'Purbachal', 'Purbachal', 'Purbachal', NULL, 1, 1, 1, 0, '13', '13', '2016-06-20 01:30:12', '2016-08-23 18:33:49'),
(19, 'Aftab Nagar', '90.448884', '23.764780', 'Property for sale in Aftab Nagar', 'Apartment in aftab Nagar, Flat for sale in aftab nagar, plot for sale in aftab nagar ', '', NULL, 1, 1, 1, 0, '13', '13', '2016-06-25 12:25:44', '2016-08-31 16:41:28'),
(20, 'Bashundhara R/A', '90.430387', '23.813081', 'Apartment, plot, flat, commercial space, office space for sale rent in Basundhara R/A', 'Bashundhra R/A, Bashundhara Resindential Area', 'Apartment, plot, flat, commercial space, office space for sale rent in Basundhara R/A', NULL, 1, 1, 1, 0, '13', '13', '2016-06-30 08:24:52', '2016-08-31 16:43:06'),
(21, 'Ashulia', '90.331253', '23.897623', 'Apartment, land, plot for sale at Ashulia', 'Apartment, land, plot for sale at Ashulia', 'Apartment, land, plot for sale at Ashulia', NULL, 1, 1, 1, 0, '13', '13', '2016-06-30 17:00:57', '2016-08-31 16:44:09'),
(23, 'Savar', '90.257396', '23.847509', 'Apartment Flat Land sale Rent in Savar', 'Property sale in savar', 'Apartment Flat Land sale Rent in Savar', NULL, 1, 1, 1, 0, '13', '13', '2016-07-23 11:09:10', '2016-08-31 16:45:27'),
(24, 'Adabor', '90.3592792', '23.7706569', 'Apartment, plot, flat, commercial space, office space for sale rent in Adabor', 'Apartment, plot, flat, commercial space, office space for sale rent in Adabor', 'Apartment, plot, flat, commercial space, office space for sale rent in Adabor', NULL, 1, 1, 1, 0, '13', '11', '2016-07-23 22:18:10', '2016-12-15 16:27:00'),
(25, 'Agrabad', '91.79575869', '22.33445742', 'Apartment, plot, flat, commercial space, office space for sale rent in Agrabad', 'Apartment, plot, flat, commercial space, office space for sale rent in Agrabad', 'Apartment, plot, flat, commercial space, office space for sale rent in Agrabad', NULL, 4, 1, 1, 0, '13', '13', '2016-07-24 00:10:09', '2016-07-24 00:10:09'),
(26, 'Alkaran', '91.834425', '22.3314072', 'Apartment, plot, flat, commercial space, office space for sale rent in Alkaran', 'Apartment, plot, flat, commercial space, office space for sale rent in Alkaran', 'Apartment, plot, flat, commercial space, office space for sale rent in Alkaran', NULL, 4, 1, 1, 0, '13', '13', '2016-07-24 00:14:46', '2016-07-24 00:14:46'),
(27, 'Anderkilla', '91.8367217', '22.3421925', 'Apartment, plot, flat, commercial space, office space for sale rent in Anderkilla', 'Apartment, plot, flat, commercial space, office space for sale rent in Anderkilla', 'Apartment, plot, flat, commercial space, office space for sale rent in Anderkilla', NULL, 4, 1, 1, 0, '13', '13', '2016-07-24 00:24:04', '2016-07-24 00:24:04'),
(28, 'Anwara', '91.8659809', '22.2337164', 'Apartment, plot, flat, commercial space, office space for sale rent in Anwara', 'Apartment, plot, flat, commercial space, office space for sale rent in Anwara', 'Apartment, plot, flat, commercial space, office space for sale rent in Anwara', NULL, 4, 1, 1, 0, '13', '13', '2016-07-24 00:27:31', '2016-07-24 00:27:31'),
(29, 'Agargaon', '90.380605', '23.776798', 'Apartment, plot, flat, commercial space, office space for sale rent in Agargaon', 'Apartment, plot, flat, commercial space, office space for sale rent in Agargaon', 'Apartment, plot, flat, commercial space, office space for sale rent in Agargaon', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 06:30:40', '2016-08-31 16:50:34'),
(30, 'Arambagh', '90.4189984', '23.7307363', 'Apartment, plot, flat, commercial space, office space for sale rent in Arambagh', 'Apartment, plot, flat, commercial space, office space for sale rent in Arambagh', 'Apartment, plot, flat, commercial space, office space for sale rent in Arambagh', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 06:32:42', '2016-07-24 06:32:42'),
(31, 'Armanitola', '90.4016953', '23.7156272', 'Apartment, plot, flat, commercial space, office space for sale rent in Armanitola', 'Apartment, plot, flat, commercial space, office space for sale rent in Armanitola', 'Apartment, plot, flat, commercial space, office space for sale rent in Armanitola', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 06:34:14', '2016-07-24 06:34:14'),
(32, 'Azimpur', '90.386292', '23.726833', 'Apartment, plot, flat, commercial space, office space for sale rent in Azimpur', 'Apartment, plot, flat, commercial space, office space for sale rent in Azimpur', 'Apartment, plot, flat, commercial space, office space for sale rent in Azimpur', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 06:35:52', '2016-08-31 16:52:09'),
(33, 'Babu Bazar', '90.395441', '23.713646', 'Apartment, plot, flat, commercial space, office space for sale rent in Babu Bazar', 'Apartment, plot, flat, commercial space, office space for sale rent in Babu Bazar', 'Apartment, plot, flat, commercial space, office space for sale rent in Babu Bazar', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 06:49:24', '2016-08-31 16:53:19'),
(34, 'Bakshi Bazar', '90.395733', '23.722374', 'Apartment, plot, flat, commercial space, office space for sale rent in Bakshi Bazar', 'Apartment, plot, flat, commercial space, office space for sale rent in Bakshi Bazar', 'Apartment, plot, flat, commercial space, office space for sale rent in Bakshi Bazar', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 06:54:42', '2016-08-31 16:54:48'),
(35, 'Banasree', '90.43083251', '23.76254643', 'Apartment, plot, flat, commercial space, office space for sale rent in Banasree', 'Apartment, plot, flat, commercial space, office space for sale rent in Banasree', 'Apartment, plot, flat, commercial space, office space for sale rent in Banasree', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 06:56:42', '2016-08-31 16:57:50'),
(36, 'Bangla Bazar', '90.41108876', '23.70675607', 'Apartment, plot, flat, commercial space, office space for sale rent in Bangla Bazar', 'Apartment, plot, flat, commercial space, office space for sale rent in Bangla Bazar', 'Apartment, plot, flat, commercial space, office space for sale rent in Bangla Bazar', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 06:58:16', '2016-08-31 16:58:48'),
(37, 'Bangla Motor', '90.39465219', '23.74589187', 'Apartment, plot, flat, commercial space, office space for sale rent in Bangla Motor', 'Apartment, plot, flat, commercial space, office space for sale rent in Bangla Motor', 'Apartment, plot, flat, commercial space, office space for sale rent in Bangla Motor', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 06:59:56', '2016-08-31 16:59:39'),
(38, 'Bangshal', '90.4007384', '23.71814', 'Apartment, plot, flat, commercial space, office space for sale rent in Bangshal', 'Apartment, plot, flat, commercial space, office space for sale rent in Bangshal', 'Apartment, plot, flat, commercial space, office space for sale rent in Bangshal', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:01:38', '2016-07-24 07:01:38'),
(39, 'Basabo', '90.4307836', '23.7426044', 'Apartment, plot, flat, commercial space, office space for sale rent in Basabo', 'Apartment, plot, flat, commercial space, office space for sale rent in Basabo', 'Apartment, plot, flat, commercial space, office space for sale rent in Basabo', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:03:52', '2016-07-24 07:03:52'),
(40, 'Cantonment', '90.39346933', '23.8225284', 'Apartment, plot, flat, commercial space, office space for sale rent in Cantonment', 'Apartment, plot, flat, commercial space, office space for sale rent in Cantonment', 'Apartment, plot, flat, commercial space, office space for sale rent in Cantonment', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:05:55', '2016-08-31 17:01:22'),
(41, 'Chak Bazar', '90.39604962', '23.71653498', 'Apartment, plot, flat, commercial space, office space for sale rent in Chak Bazar', 'Apartment, plot, flat, commercial space, office space for sale rent in Chak Bazar', 'Apartment, plot, flat, commercial space, office space for sale rent in Chak Bazar', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:07:19', '2016-08-31 17:02:09'),
(42, 'Dakshin khan', '90.42768896', '23.85326455', 'Apartment, plot, flat, commercial space, office space for sale rent in Dakshin khan', 'Apartment, plot, flat, commercial space, office space for sale rent in Dakshin khan', 'Apartment, plot, flat, commercial space, office space for sale rent in Dakshin khan', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:11:37', '2016-08-31 17:03:08'),
(43, 'Dayaganj', '90.42391241', '23.70737986', 'Apartment, plot, flat, commercial space, office space for sale rent in Dayaganj', 'Apartment, plot, flat, commercial space, office space for sale rent in Dayaganj', 'Apartment, plot, flat, commercial space, office space for sale rent in Dayaganj', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:13:01', '2016-08-31 17:04:43'),
(44, 'Demra', '90.49500167', '23.72480547', 'Apartment, plot, flat, commercial space, office space for sale rent in Demra', 'Apartment, plot, flat, commercial space, office space for sale rent in Demra', 'Apartment, plot, flat, commercial space, office space for sale rent in Demra', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:14:21', '2016-08-31 17:06:20'),
(45, 'Dhamrai', '90.21701485', '23.91406276', 'Apartment plot flat commercial space office space for sale rent in Dhamrai', 'Apartment plot flat commercial space office space for sale rent in Dhamrai', 'Apartment plot flat commercial space office space for sale rent in Dhamrai', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:16:20', '2016-08-31 17:07:19'),
(46, 'Dhour', '90.37765771', '23.88995782', 'Apartment plot flat commercial space office space for sale rent in Dhour', 'Apartment plot flat commercial space office space for sale rent in Dhour', 'Apartment plot flat commercial space office space for sale rent in Dhour', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:18:50', '2016-08-31 17:08:45'),
(47, 'Hatirpool', '90.3883735', '23.7427161', 'Apartment plot flat commercial space office space for sale rent in Hatirpool', 'Apartment plot flat commercial space office space for sale rent in Hatirpool', 'Apartment plot flat commercial space office space for sale rent in Hatirpool', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:20:39', '2016-07-24 07:20:39'),
(48, 'Eskaton', '90.39943993', '23.74505712', 'Apartment plot flat commercial space office space for sale rent in Eskaton', 'Apartment plot flat commercial space office space for sale rent in Eskaton', 'Apartment plot flat commercial space office space for sale rent in Eskaton', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:22:10', '2016-08-31 17:10:36'),
(49, 'Farmgate', '90.39011657', '23.75797057', 'Apartment plot flat commercial space office space for sale rent in Farmgate', 'Apartment plot flat commercial space office space for sale rent in Farmgate', 'Apartment plot flat commercial space office space for sale rent in Farmgate', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:23:56', '2016-08-31 17:11:39'),
(50, 'Gabtali', '90.34732461', '23.78289039', 'Apartment plot flat commercial space office space for sale rent in Gabtali', 'Apartment plot flat commercial space office space for sale rent in Gabtali', 'Apartment plot flat commercial space office space for sale rent in Gabtali', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:25:28', '2016-08-31 17:12:37'),
(51, 'Gandaria', '90.42384267', '23.70129901', 'Apartment plot flat commercial space office space for sale rent in Gandaria', 'Apartment plot flat commercial space office space for sale rent in Gandaria', 'Apartment plot flat commercial space office space for sale rent in Gandaria', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:29:23', '2016-08-31 17:13:49'),
(52, 'Green Road', '90.3851759', '23.7457863', 'Apartment plot flat commercial space office space for sale rent in Green Road', 'Apartment plot flat commercial space office space for sale rent in Green Road', 'Apartment plot flat commercial space office space for sale rent in Green Road', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:31:22', '2016-07-24 07:31:22'),
(53, 'Gupibag', '90.42727858', '23.72234501', 'Apartment plot flat commercial space office space for sale rent in Gupibag', 'Apartment plot flat commercial space office space for sale rent in Gupibag', 'Apartment plot flat commercial space office space for sale rent in Gupibag', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:33:21', '2016-08-31 17:15:39'),
(54, 'Hazaribagh', '90.36521763', '23.73481383', 'Apartment plot flat commercial space office space for sale rent in Hazaribagh', 'Apartment plot flat commercial space office space for sale rent in Hazaribagh', 'Apartment plot flat commercial space office space for sale rent in Hazaribagh', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:34:15', '2016-08-31 17:16:50'),
(55, 'Hemayetpur', '90.27160048', '23.79331642', 'Apartment plot flat commercial space office space for sale rent in Hemayetpur', 'Apartment plot flat commercial space office space for sale rent in Hemayetpur', 'Apartment plot flat commercial space office space for sale rent in Hemayetpur', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:35:36', '2016-08-31 17:17:32'),
(56, 'Ibrahimpur', '90.38223356', '23.79432756', 'Apartment plot flat commercial space office space for sale rent in Ibrahimpur', 'Apartment plot flat commercial space office space for sale rent in Ibrahimpur', 'Apartment plot flat commercial space office space for sale rent in Ibrahimpur', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:37:13', '2016-08-31 17:18:47'),
(57, 'Jatrabari', '90.43452859', '23.71017951', 'Apartment plot flat commercial space office space for sale rent in Jatrabari', 'Apartment plot flat commercial space office space for sale rent in Jatrabari', 'Apartment plot flat commercial space office space for sale rent in Jatrabari', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:38:35', '2016-08-31 17:23:41'),
(58, 'Jhigatala', '90.37547708', '23.73950836', 'Apartment plot flat commercial space office space for sale rent in Jhigatala', 'Apartment plot flat commercial space office space for sale rent in Jhigatala', 'Apartment plot flat commercial space office space for sale rent in Jhigatala', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:40:19', '2016-08-31 17:24:40'),
(59, 'Jurain', '90.43963552', '23.68815397', 'Apartment plot flat commercial space office space for sale rent in Jurain', 'Apartment plot flat commercial space office space for sale rent in Jurain', 'Apartment plot flat commercial space office space for sale rent in Jurain', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:41:41', '2016-08-31 17:25:21'),
(60, 'Kafrul', '90.38814247', '23.78959574', 'Apartment plot flat commercial space office space for sale rent in Kafrul', 'Apartment plot flat commercial space office space for sale rent in Kafrul', 'Apartment plot flat commercial space office space for sale rent in Kafrul', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:43:02', '2016-08-31 17:26:56'),
(61, 'Kakrail', '90.40877402', '23.73750486', 'Apartment plot flat commercial space office space for sale rent in Kakrail', 'Apartment plot flat commercial space office space for sale rent in Kakrail', 'Apartment plot flat commercial space office space for sale rent in Kakrail', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:44:01', '2016-08-31 17:27:42'),
(62, 'Kalabagan', '90.38048208', '23.74762027', 'Apartment plot flat commercial space office space for sale rent in Kalabagan', 'Apartment plot flat commercial space office space for sale rent in Kalabagan', 'Apartment plot flat commercial space office space for sale rent in Kalabagan', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:45:45', '2016-08-31 17:28:46'),
(63, 'Kallyanpur', '90.36129355', '23.77792252', 'Apartment plot flat commercial space office space for sale rent in Kallyanpur', 'Apartment plot flat commercial space office space for sale rent in Kallyanpur', 'Apartment plot flat commercial space office space for sale rent in Kallyanpur', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:47:05', '2016-08-31 17:29:54'),
(64, 'Kamalapur', '90.42500138', '23.73294776', 'Apartment plot flat commercial space office space for sale rent in Kamalapur', 'Apartment plot flat commercial space office space for sale rent in Kamalapur', 'Apartment plot flat commercial space office space for sale rent in Kamalapur', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:48:04', '2016-08-31 17:30:39'),
(65, 'Kamrangir Char', '90.36828876', '23.71764495', 'Apartment plot flat commercial space office space for sale rent in Kamrangir Char', 'Apartment plot flat commercial space office space for sale rent in Kamrangir Char', 'Apartment plot flat commercial space office space for sale rent in Kamrangir Char', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:49:46', '2016-08-31 17:31:47'),
(66, 'Kathalbagan', '90.38820684', '23.7482095', 'Apartment plot flat commercial space office space for sale rent in Kathalbagan', 'Apartment plot flat commercial space office space for sale rent in Kathalbagan', 'Apartment plot flat commercial space office space for sale rent in Kathalbagan', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:51:05', '2016-08-31 17:32:48'),
(67, 'Kawran Bazar', '90.39240181', '23.7521965', 'Apartment plot flat commercial space office space for sale rent in Kawran Bazar', 'Apartment plot flat commercial space office space for sale rent in Kawran Bazar', 'Apartment plot flat commercial space office space for sale rent in Kawran Bazar', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:52:24', '2016-08-31 17:33:39'),
(68, 'Kazipara', '90.37213887', '23.79876732', 'Apartment plot flat commercial space office space for sale rent in Kazipara', 'Apartment plot flat commercial space office space for sale rent in Kazipara', 'Apartment plot flat commercial space office space for sale rent in Kazipara', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:55:23', '2016-07-24 07:55:23'),
(69, 'Keraniganj', '90.37245154', '23.70019872', 'Apartment plot flat commercial space office space for sale rent in Keraniganj', 'Apartment plot flat commercial space office space for sale rent in Keraniganj', 'Apartment plot flat commercial space office space for sale rent in Keraniganj', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:56:50', '2016-08-31 17:36:22'),
(70, 'Khilgaon', '90.4643906', '23.7566389', 'Apartment plot flat commercial space office space for sale rent in Khilgaon', 'Apartment plot flat commercial space office space for sale rent in Khilgaon', 'Apartment plot flat commercial space office space for sale rent in Khilgaon', NULL, 1, 1, 1, 0, '13', '13', '2016-07-24 07:58:33', '2016-07-24 07:58:33'),
(71, 'Bagmoniram', '91.8280706', '22.351048', 'Apartment Flat commercial office space for sale or rent in Bagmoniram', 'Apartment Flat commercial office space for sale or rent in Bagmoniram', 'Apartment Flat commercial office space for sale or rent in Bagmoniram', NULL, 4, 1, 1, 0, '13', '13', '2016-07-24 15:55:13', '2016-07-24 15:55:13'),
(72, 'Bayazid', '91.8172069', '22.3891916', 'Apartment Flat commercial office space for sale or rent in Bayazid', 'Apartment Flat commercial office space for sale or rent in Bayazid', 'Apartment Flat commercial office space for sale or rent in Bayazid', NULL, 4, 1, 1, 0, '13', '13', '2016-07-24 15:57:52', '2016-07-24 15:57:52'),
(73, 'Bakoliya', '91.8443037', '22.3459081', 'Apartment Flat commercial office space for sale or rent in Bakoliya', 'Apartment Flat commercial office space for sale or rent in Bakoliya', 'Apartment Flat commercial office space for sale or rent in Bakoliya', NULL, 4, 1, 1, 0, '13', '13', '2016-07-24 16:01:09', '2016-07-24 16:01:09'),
(74, 'Bandar', '91.801367', '22.3104165', 'Apartment Flat commercial office space for sale or rent in Bandar', 'Apartment Flat commercial office space for sale or rent in Bandar', 'Apartment Flat commercial office space for sale or rent in Bandar', NULL, 4, 1, 1, 0, '13', '13', '2016-07-24 16:04:19', '2016-07-24 16:04:19'),
(75, 'Banshkhali', '91.8625259', '22.0930362', 'Apartment Flat commercial office space land plot properties for sale or rent in Banshkhali', 'Apartment Flat commercial office space land plot properties for sale or rent in Banshkhali', 'Apartment Flat commercial office space land plot properties for sale or rent in Banshkhali', NULL, 4, 1, 1, 0, '13', '13', '2016-07-24 16:05:25', '2016-07-24 16:05:25'),
(76, 'Bhujpor', '91.72832123', '22.77321371', 'Apartment Flat commercial office space land plot properties for sale or rent in Bhujpor', 'Apartment Flat commercial office space land plot properties for sale or rent in Bhujpor', 'Apartment Flat commercial office space land plot properties for sale or rent in Bhujpor', NULL, 4, 1, 1, 0, '13', '13', '2016-07-24 16:08:02', '2016-07-24 16:08:02'),
(77, 'Boalkhali', ' 91.9172519', '22.3791057', 'Apartment Flat commercial office space land plot properties for sale or rent in Boalkhali', 'Apartment Flat commercial office space land plot properties for sale or rent in Boalkhali', 'Apartment Flat commercial office space land plot properties for sale or rent in Boalkhali', NULL, 4, 1, 1, 0, '13', '13', '2016-07-24 16:11:54', '2016-07-24 16:11:54'),
(78, 'Chandanaish', '92.0126276', '22.2438942', 'Apartment Flat commercial office space land plot properties for sale or rent in Chandanaish', 'Apartment Flat commercial office space land plot properties for sale or rent in Chandanaish', 'Apartment Flat commercial office space land plot properties for sale or rent in Chandanaish', NULL, 4, 1, 1, 0, '13', '13', '2016-07-24 16:19:29', '2016-07-24 16:19:29'),
(79, 'Chandgaon', '91.8476843', '22.3784211', 'Apartment Flat commercial office space land plot properties for sale or rent in Chandgaon', 'Apartment Flat commercial office space land plot properties for sale or rent in Chandgaon', 'Apartment Flat commercial office space land plot properties for sale or rent in Chandgaon', NULL, 4, 1, 1, 0, '13', '13', '2016-07-24 16:21:02', '2016-07-24 16:21:02'),
(80, 'Chawk Bazar', '91.8330525', '22.3517735', 'Apartment Flat commercial office space land plot properties for sale or rent in Chawk Bazar', 'Apartment Flat commercial office space land plot properties for sale or rent in Chawk Bazar', 'Apartment Flat commercial office space land plot properties for sale or rent in Chawk Bazar', NULL, 4, 1, 1, 0, '13', '13', '2016-07-24 16:22:55', '2016-07-24 16:22:55'),
(81, 'Dewan Bazar', '91.8397581', '22.343505', 'Apartment Flat commercial office space land plot properties for sale or rent in Dewan Bazar', 'Apartment Flat commercial office space land plot properties for sale or rent in Dewan Bazar', 'Apartment Flat commercial office space land plot properties for sale or rent in Dewan Bazar', NULL, 4, 1, 1, 0, '13', '13', '2016-07-24 16:25:27', '2016-07-24 16:25:27'),
(82, 'Double Mooring', '91.8074586', '22.3297149', 'Apartment Flat commercial office space land plot properties for sale or rent in Double Mooring', 'Apartment Flat commercial office space land plot properties for sale or rent in Double Mooring', 'Apartment Flat commercial office space land plot properties for sale or rent in Double Mooring', NULL, 4, 1, 1, 0, '13', '13', '2016-07-24 16:26:49', '2016-07-24 16:26:49'),
(83, 'Shahporan ', '91.8350682', '24.9247172', 'Apartment Flat commercial office space land plot properties for sale or rent in Shahporan ', 'Apartment Flat commercial office space land plot properties for sale or rent in Shahporan ', 'Apartment Flat commercial office space land plot properties for sale or rent in Shahporan ', NULL, 5, 1, 1, 0, '13', '13', '2016-07-24 16:36:53', '2016-07-24 16:36:53'),
(84, 'Akhalia', '91.8123324', '24.9644467', 'Apartment Flat commercial office space land plot properties for sale or rent in Akhalia', 'Apartment Flat commercial office space land plot properties for sale or rent in Akhalia', 'Apartment Flat commercial office space land plot properties for sale or rent in Akhalia', NULL, 5, 1, 1, 0, '13', '13', '2016-07-24 16:41:01', '2016-07-24 16:41:01'),
(85, 'Zinda Bazar', '91.86907589', '24.89493275', 'Apartment Flat commercial office space land plot properties for sale or rent in Zinda Bazar', 'Apartment Flat commercial office space land plot properties for sale or rent in Zinda Bazar', 'Apartment Flat commercial office space land plot properties for sale or rent in Zinda Bazar', NULL, 5, 1, 1, 0, '13', '13', '2016-07-24 16:44:06', '2016-07-24 16:44:06'),
(86, 'Ambarkhana', '91.8720815', '24.9058852', 'Apartment Flat commercial office space land plot properties for sale or rent in Ambarkhana', 'Apartment Flat commercial office space land plot properties for sale or rent in Ambarkhana', 'Apartment Flat commercial office space land plot properties for sale or rent in Ambarkhana', NULL, 5, 1, 1, 0, '13', '13', '2016-07-24 16:45:54', '2016-07-24 16:45:54'),
(87, 'Bimanbondor', '91.8713889', '24.961111', 'Apartment Flat commercial office space land plot properties for sale or rent in Bimanbondor', 'Apartment Flat commercial office space land plot properties for sale or rent in Bimanbondor', 'Apartment Flat commercial office space land plot properties for sale or rent in Bimanbondor', NULL, 5, 1, 1, 0, '13', '13', '2016-07-24 16:47:14', '2016-07-24 16:47:14'),
(88, 'Baghbari', '91.8476843', '24.903222', 'Apartment Flat commercial office space land plot properties for sale or rent in Baghbari', 'Apartment Flat commercial office space land plot properties for sale or rent in Baghbari', 'Apartment Flat commercial office space land plot properties for sale or rent in Baghbari', NULL, 5, 1, 1, 0, '13', '13', '2016-07-24 16:48:28', '2016-07-24 16:48:28'),
(89, 'Balaganj', '91.8233007', '24.6572751', 'Apartment Flat commercial office space land plot properties for sale or rent in Balaganj', 'Apartment Flat commercial office space land plot properties for sale or rent in Balaganj', 'Apartment Flat commercial office space land plot properties for sale or rent in Balaganj', NULL, 5, 1, 1, 0, '13', '13', '2016-07-24 16:50:45', '2016-07-24 16:50:45'),
(90, 'Bondar', '91.8714714', '24.8903225', 'Apartment Flat commercial office space land plot properties for sale or rent in Bandar', 'Apartment Flat commercial office space land plot properties for sale or rent in Bandar', 'Apartment Flat commercial office space land plot properties for sale or rent in Bandar', NULL, 5, 1, 1, 0, '13', '13', '2016-07-24 16:54:02', '2016-07-24 16:54:02'),
(91, 'Sonadanga', '89.5379687', '22.8247809', 'Apartment Flat commercial office space land plot properties for sale or rent in Sonadanga', 'Apartment Flat commercial office space land plot properties for sale or rent in Sonadanga', 'Apartment Flat commercial office space land plot properties for sale or rent in Sonadanga', NULL, 3, 1, 1, 0, '13', '13', '2016-07-24 16:56:46', '2016-07-24 16:56:46'),
(92, 'Khan Jahan Ali', '89.5051029', '22.8984146', 'Apartment Flat commercial office space land plot properties for sale or rent in Khan Jahan Ali', 'Apartment Flat commercial office space land plot properties for sale or rent in Khan Jahan Ali', 'Apartment Flat commercial office space land plot properties for sale or rent in Khan Jahan Ali', NULL, 3, 1, 1, 0, '13', '13', '2016-07-24 16:57:49', '2016-07-24 16:57:49'),
(93, 'Gollamari', '89.54254389', '22.80209673', 'Apartment Flat commercial office space land plot properties for sale or rent in Gollamari', 'Apartment Flat commercial office space land plot properties for sale or rent in Gollamari', 'Apartment Flat commercial office space land plot properties for sale or rent in Gollamari', NULL, 3, 1, 1, 0, '13', '13', '2016-07-24 16:59:17', '2016-07-24 16:59:17'),
(94, 'Lobon Chora', '89.564825', '22.7632047', 'Apartment Flat commercial office space land plot properties for sale or rent in Lobon Chora', 'Apartment Flat commercial office space land plot properties for sale or rent in Lobon Chora', 'Apartment Flat commercial office space land plot properties for sale or rent in Lobon Chora', NULL, 3, 1, 1, 0, '13', '13', '2016-07-24 17:04:29', '2016-07-24 17:04:29'),
(95, 'Dhap', '89.2336462', '25.7658678', 'Apartment plot flat commercial space office space for sale rent in Dhap', 'Apartment plot flat commercial space office space for sale rent in Dhap', 'Apartment plot flat commercial space office space for sale rent in Dhap', NULL, 7, 1, 1, 0, '13', '13', '2016-07-26 22:39:21', '2016-07-26 22:39:21'),
(96, 'Pouro Bazar', '89.2543643', '25.7505388', 'Apartment plot flat commercial space office space for sale rent in Pouro Bazar', 'Apartment plot flat commercial space office space for sale rent in Pouro Bazar', 'Apartment plot flat commercial space office space for sale rent in Pouro Bazar', NULL, 7, 1, 1, 0, '13', '13', '2016-07-26 22:40:41', '2016-07-26 22:40:41'),
(97, 'Mahigonj', '89.2912538', '25.7284374', 'Apartment plot flat commercial space office space for sale rent in Mahigonj', 'Apartment plot flat commercial space office space for sale rent in Mahigonj', 'Apartment plot flat commercial space office space for sale rent in Mahigonj', NULL, 7, 1, 1, 0, '13', '13', '2016-07-26 22:42:00', '2016-07-26 22:42:00'),
(98, 'College Road', '89.254708', '25.7326899', 'Apartment plot flat commercial space office space for sale rent in College Road', 'Apartment plot flat commercial space office space for sale rent in College Road', 'Apartment plot flat commercial space office space for sale rent in College Road', NULL, 7, 1, 1, 0, '13', '13', '2016-07-26 22:44:44', '2016-07-26 22:44:44'),
(99, 'Jahaj Company More', '89.2549159', '25.7489391', 'Apartment plot flat commercial space office space for sale rent in Jahaj Company More', 'Apartment plot flat commercial space office space for sale rent in Jahaj Company More', 'Apartment plot flat commercial space office space for sale rent in Jahaj Company More', NULL, 7, 1, 1, 0, '13', '13', '2016-07-26 23:04:41', '2016-07-26 23:04:41'),
(100, 'Kachari Bazaar', '89.24256', '25.7548205', 'Apartment plot flat commercial space office space for sale rent in Kachari Bazaar', 'Apartment plot flat commercial space office space for sale rent in Kachari Bazaar', 'Apartment plot flat commercial space office space for sale rent in Kachari Bazaar', NULL, 7, 1, 1, 0, '13', '13', '2016-07-26 23:05:45', '2016-07-26 23:05:45'),
(102, 'Mithapukur', '89.2799763', '25.5722678', 'Apartment plot flat commercial space office space for sale rent in Mithapukur', 'Apartment plot flat commercial space office space for sale rent in Mithapukur', 'Apartment plot flat commercial space office space for sale rent in Mithapukur', NULL, 7, 1, 1, 0, '13', '13', '2016-07-26 23:08:55', '2016-07-26 23:08:55'),
(103, 'Paglapir', '89.1450392', '25.8150011', 'Apartment plot flat commercial space office space for sale rent in Paglapir', 'Apartment plot flat commercial space office space for sale rent in Paglapir', 'Apartment plot flat commercial space office space for sale rent in Paglapir', NULL, 7, 1, 1, 0, '13', '13', '2016-07-26 23:11:31', '2016-07-26 23:11:31'),
(104, 'Shathibari', '89.2960382', '25.539063', 'Apartment plot flat commercial space office space for sale rent in Shathibari', 'Apartment plot flat commercial space office space for sale rent in Shathibari', 'Apartment plot flat commercial space office space for sale rent in Shathibari', NULL, 7, 1, 1, 0, '13', '13', '2016-07-26 23:13:00', '2016-07-26 23:13:00'),
(105, 'Rashid Chattar', '91.861101', '24.904539', 'Apartment plot flat commercial space office space for sale rent in Rashid Chattar', 'Apartment plot flat commercial space office space for sale rent in Rashid Chattar', 'Apartment plot flat commercial space office space for sale rent in Rashid Chattar', NULL, 5, 1, 1, 0, '13', '13', '2016-08-03 07:13:53', '2016-08-03 07:13:53'),
(106, 'West Dhanmondi', '90.364276', '23.749795', 'Apartment plot flat commercial space office space for sale rent in west Dhanmondi', 'Apartment plot flat commercial space office space for sale rent in west Dhanmondi', 'Apartment plot flat commercial space office space for sale rent in west Dhanmondi', NULL, 1, 1, 1, 0, '13', '13', '2016-08-05 18:53:52', '2016-08-05 18:53:52'),
(107, 'Shewrapara', '90.37564874', '23.79056764', 'Apartment plot flat commercial space office space for sale rent in Shewrapara', 'Apartment plot flat commercial space office space for sale rent in Shewrapara', 'Apartment plot flat commercial space office space for sale rent in Shewrapara', NULL, 1, 1, 1, 0, '13', '13', '2016-08-05 20:23:22', '2016-08-31 17:40:16'),
(108, 'Khilkhet', '90.4200232', '23.82871154', 'Apartment plot flat commercial space office space for sale rent in Khilkhet', 'Apartment plot flat commercial space office space for sale rent in Khilkhet', 'Apartment plot flat commercial space office space for sale rent in Khilkhet', NULL, 1, 1, 1, 0, '13', '13', '2016-08-05 23:52:35', '2016-08-31 17:39:29'),
(109, 'Kotowali', '90.408984', '23.710680', 'Apartment plot flat commercial space office space for sale rent in College Kotowali', 'Apartment plot flat commercial space office space for sale rent in College Kotowali', 'Apartment plot flat commercial space office space for sale rent in College Kotowali', NULL, 1, 1, 1, 0, '13', '13', '2016-08-05 23:55:48', '2016-08-05 23:55:48'),
(110, 'Lakshmi bazar', '90.415809', '23.704132', 'Apartment plot flat commercial space office space for sale rent in Lakshmi bazar', 'Apartment plot flat commercial space office space for sale rent in Lakshmi bazar', 'Apartment plot flat commercial space office space for sale rent in Lakshmi bazar', NULL, 1, 1, 1, 0, '13', '13', '2016-08-05 23:58:57', '2016-08-05 23:58:57'),
(111, 'Lalbag', '90.38785815', '23.7198452', 'Apartment plot flat commercial space office space for sale rent in Lalbag', 'Apartment plot flat commercial space office space for sale rent in Lalbag', 'Apartment plot flat commercial space office space for sale rent in Lalbag', NULL, 1, 1, 1, 0, '13', '13', '2016-08-06 00:03:54', '2016-08-31 17:41:45'),
(112, 'Lalmatia', '90.36737144', '23.75683149', 'Apartment plot flat commercial space office space for sale rent in Lalmatia', 'Apartment plot flat commercial space office space for sale rent in Lalmatia', 'Apartment plot flat commercial space office space for sale rent in Lalmatia', NULL, 1, 1, 1, 0, '13', '13', '2016-08-06 00:06:58', '2016-08-31 17:42:40'),
(113, 'Moghbazar', '90.40369391', '23.74864159', 'Apartment flat plot commercial space office space for sale rent in College Moghbazar', 'Apartment flat plot commercial space office space for sale rent in College Moghbazar', 'Apartment flat plot commercial space office space for sale rent in College Moghbazar', NULL, 1, 1, 1, 0, '13', '13', '2016-08-06 00:12:03', '2016-08-31 17:43:42'),
(114, 'Mohakhali', '90.398072', '23.77837415', 'Apartment flat plot commercial space office space for sale rent in Mohakhali', 'Apartment flat plot commercial space office space for sale rent in Mohakhali', 'Apartment flat plot commercial space office space for sale rent in Mohakhali', NULL, 1, 1, 1, 0, '13', '13', '2016-08-06 00:14:04', '2016-08-31 17:44:16'),
(115, 'Monipur', '90.3665972', '23.8000358', 'Apartment flat plot commercial space office space for sale rent in Monipur', 'Apartment flat plot commercial space office space for sale rent in Monipur', 'Apartment flat plot commercial space office space for sale rent in Monipur', NULL, 1, 1, 1, 0, '13', '11', '2016-08-06 00:16:31', '2016-12-08 17:29:19'),
(116, 'Motijheel', '90.42171299', '23.72680917', 'Apartment flat plot commercial space office space for sale rent in Motijheel', 'Apartment flat plot commercial space office space for sale rent in Motijheel', 'Apartment flat plot commercial space office space for sale rent in Motijheel', NULL, 1, 1, 1, 0, '13', '13', '2016-08-06 00:19:44', '2016-08-31 17:45:56'),
(117, 'Nakhalpara', '90.3965427', '23.7684477', 'Apartment flat plot commercial space office space for sale rent in Nakhalpara', 'Apartment flat plot commercial space office space for sale rent in Nakhalpara', 'Apartment flat plot commercial space office space for sale rent in Nakhalpara', NULL, 1, 1, 1, 0, '13', '13', '2016-08-06 00:23:33', '2016-08-31 17:46:48'),
(118, 'Narinda', '90.42060792', '23.70970799', 'Apartment flat plot commercial space office space for sale rent in Narinda', 'Apartment flat plot commercial space office space for sale rent in Narinda', 'Apartment flat plot commercial space office space for sale rent in Narinda', NULL, 1, 1, 1, 0, '13', '13', '2016-08-06 00:26:50', '2016-08-31 17:48:15'),
(119, 'Nawabgonj ', '90.151839', '23.653123', 'Apartment flat plot commercial space office space for sale rent in Nawabgonj', 'Apartment flat plot commercial space office space for sale rent in Nawabgonj', 'Apartment flat plot commercial space office space for sale rent in Nawabgonj', NULL, 1, 1, 1, 0, '13', '13', '2016-08-06 00:28:38', '2016-08-06 00:28:38'),
(120, 'Naya Paltan', '90.413693', '23.736360', 'Apartment flat plot commercial space office space for sale rent in Naya Paltan', 'Apartment flat plot commercial space office space for sale rent in Naya Paltan', 'Apartment flat plot commercial space office space for sale rent in Naya Paltan', NULL, 1, 1, 1, 0, '13', '13', '2016-08-06 00:31:29', '2016-08-06 00:31:29'),
(121, 'Niketon', '90.41191757', '23.77460395', 'Apartment flat plot commercial space office space for sale rent in Niketon', 'Apartment flat plot commercial space office space for sale rent in Niketon', 'Apartment flat plot commercial space office space for sale rent in Niketon', NULL, 1, 1, 1, 0, '13', '13', '2016-08-06 00:33:21', '2016-08-31 17:49:46'),
(122, 'Paikpara', '90.35989344', '23.7892914', 'Apartment flat plot commercial space office space for sale rent in Paikpara', 'Apartment flat plot commercial space office space for sale rent in Paikpara', 'Apartment flat plot commercial space office space for sale rent in Paikpara', NULL, 1, 1, 0, 0, '13', '11', '2016-08-06 00:36:38', '2017-02-05 16:24:18'),
(123, 'Pallabi', '90.36155641', '23.82626776', 'Apartment flat plot commercial space office space for sale rent in Pallabi', 'Apartment flat plot commercial space office space for sale rent in Pallabi', 'Apartment flat plot commercial space office space for sale rent in Pallabi', NULL, 1, 1, 1, 0, '13', '13', '2016-08-06 00:37:48', '2016-08-31 17:51:57'),
(124, 'Pirerbag', '90.366597', '23.791111', 'Apartment flat plot commercial space office space for sale rent in Pirerbag', 'Apartment flat plot commercial space office space for sale rent in Pirerbag', 'Apartment flat plot commercial space office space for sale rent in Pirerbag', NULL, 1, 1, 1, 0, '13', '13', '2016-08-06 00:48:45', '2016-08-06 00:48:45'),
(125, 'Khulshi', '91.812071', '22.361718', 'Apartment Flat commercial office space land plot properties for sale or rent in Khulshi', 'Apartment Flat commercial office space land plot properties for sale or rent in Khulshi', 'Apartment Flat commercial office space land plot properties for sale or rent in Khulshi', NULL, 4, 1, 1, 0, '13', '13', '2016-08-06 10:28:12', '2016-08-06 10:28:12'),
(126, 'Lalkhan Bazar', '91.819183', '22.347423', 'Apartment Flat commercial office space land plot properties for sale or rent in Lalkhan Bazar', 'Apartment Flat commercial office space land plot properties for sale or rent in Lalkhan Bazar', 'Apartment Flat commercial office space land plot properties for sale or rent in Lalkhan Bazar', NULL, 4, 1, 1, 0, '13', '13', '2016-08-06 10:31:50', '2016-08-06 10:31:50'),
(127, 'Purana Paltan', '90.41028142', '23.73391026', 'Apartment Flat commercial office space land plot properties for sale or rent in Purana Paltan', 'Apartment Flat commercial office space land plot properties for sale or rent in Purana Paltan', 'Apartment Flat commercial office space land plot properties for sale or rent in Purana Paltan', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 19:06:40', '2016-08-31 17:58:10'),
(128, 'Raja Bazar', '90.38460195', '23.75379716', 'Apartment Flat commercial office space land plot properties for sale or rent in Raja Bazar', 'Apartment Flat commercial office space land plot properties for sale or rent in Raja Bazar', 'Apartment Flat commercial office space land plot properties for sale or rent in Raja Bazar', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 19:08:41', '2016-08-31 17:59:24'),
(129, 'Rajarbagh', '90.41993737', '23.73986192', 'Apartment Flat commercial office space land plot properties for sale or rent in Rajarbagh', 'Apartment Flat commercial office space land plot properties for sale or rent in Rajarbagh', 'Apartment Flat commercial office space land plot properties for sale or rent in Rajarbagh', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 19:10:24', '2016-08-31 18:18:02'),
(130, 'Rayerbazar', '90.3580749', '23.75036996', 'Apartment Flat commercial office space land plot properties for sale or rent in Rayerbazar', 'Apartment Flat commercial office space land plot properties for sale or rent in Rayerbazar', 'Apartment Flat commercial office space land plot properties for sale or rent in Rayerbazar', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 19:13:43', '2016-08-31 18:19:42'),
(131, 'Rupnagar', '90.35605252', '23.81800372', 'Apartment Flat commercial office space land plot properties for sale or rent in Rupnagar', 'Apartment Flat commercial office space land plot properties for sale or rent in Rupnagar', 'Apartment Flat commercial office space land plot properties for sale or rent in Rupnagar', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 19:22:17', '2016-08-31 18:20:38'),
(132, 'Sayedabad', '90.4250443', '23.71463917', 'Apartment Flat commercial office space land plot properties for sale or rent in Sayedabad', 'Apartment Flat commercial office space land plot properties for sale or rent in Sayedabad', 'Apartment Flat commercial office space land plot properties for sale or rent in Sayedabad', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 19:25:36', '2016-08-31 18:21:34'),
(133, 'Shahbag', '90.39592624', '23.73836912', 'Apartment Flat commercial office space land plot properties for sale or rent in Shahbag', 'Apartment Flat commercial office space land plot properties for sale or rent in Shahbag', 'Apartment Flat commercial office space land plot properties for sale or rent in Shahbag', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 19:28:08', '2016-08-31 18:22:21'),
(134, 'Shantinagar', '90.41186929', '23.74153148', 'Apartment Flat commercial office space land plot properties for sale or rent in Shantinagar', 'Apartment Flat commercial office space land plot properties for sale or rent in Shantinagar', 'Apartment Flat commercial office space land plot properties for sale or rent in Shantinagar', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 19:32:39', '2016-08-31 18:23:11'),
(135, 'Goran', '90.432490', '23.752538', 'Apartment Flat commercial office space land plot properties for sale or rent in Goran', 'Apartment Flat commercial office space land plot properties for sale or rent in Goran', 'Apartment Flat commercial office space land plot properties for sale or rent in Goran', NULL, 1, 1, 1, 0, '13', '11', '2016-08-08 19:33:53', '2016-11-09 16:35:27'),
(136, 'Shyamoli', '90.36569238', '23.77515378', 'Apartment Flat commercial office space land plot properties for sale or rent in Shyamoli', 'Apartment Flat commercial office space land plot properties for sale or rent in Shyamoli', 'Apartment Flat commercial office space land plot properties for sale or rent in Shyamoli', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 19:35:45', '2016-08-31 18:26:21'),
(137, 'Shiddheswari', '90.40968597', '23.74388846', 'Apartment Flat commercial office space land plot properties for sale or rent in Shiddheswari', 'Apartment Flat commercial office space land plot properties for sale or rent in Shiddheswari', 'Apartment Flat commercial office space land plot properties for sale or rent in Shiddheswari', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 19:38:16', '2016-08-31 18:27:04'),
(138, 'Siddique Bazar', '90.40775478', '23.721682', 'Apartment Flat commercial office space land plot properties for sale or rent in Siddique Bazar', 'Apartment Flat commercial office space land plot properties for sale or rent in Siddique Bazar', 'Apartment Flat commercial office space land plot properties for sale or rent in Siddique Bazar', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 19:40:07', '2016-08-31 20:02:37'),
(139, 'Sutrapur', '90.41938484', '23.71228166', 'Apartment Flat commercial office space land plot properties for sale or rent in Sutrapur', 'Apartment Flat commercial office space land plot properties for sale or rent in Sutrapur', 'Apartment Flat commercial office space land plot properties for sale or rent in Sutrapur', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 19:42:29', '2016-08-31 20:04:24'),
(140, 'Taltala', '90.422791', '23.753271', 'Apartment Flat commercial office space land plot properties for sale or rent in Taltala', 'Apartment Flat commercial office space land plot properties for sale or rent in Taltala', 'Apartment Flat commercial office space land plot properties for sale or rent in Taltala', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 19:46:04', '2016-08-08 19:46:04'),
(141, 'Tejgaon', '90.39953113', '23.76030762', 'Apartment Flat commercial office space land plot properties for sale or rent in Tejgaon', 'Apartment Flat commercial office space land plot properties for sale or rent in Tejgaon', 'Apartment Flat commercial office space land plot properties for sale or rent in Tejgaon', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 19:47:36', '2016-08-31 20:06:17'),
(142, 'Tejkuni Para', '90.39112508', '23.7634989', 'Apartment Flat commercial office space land plot properties for sale or rent in Tejkuni Para', 'Apartment Flat commercial office space land plot properties for sale or rent in Tejkuni Para', 'Apartment Flat commercial office space land plot properties for sale or rent in Tejkuni Para', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 19:48:53', '2016-08-31 20:07:36'),
(143, 'Tikatuli', '90.42039067', '23.71896609', 'Apartment Flat commercial office space land plot properties for sale or rent in Tikatuli', 'Apartment Flat commercial office space land plot properties for sale or rent in Tikatuli', 'Apartment Flat commercial office space land plot properties for sale or rent in Tikatuli', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 19:50:36', '2016-08-31 20:08:34'),
(144, 'Uttar Khan', '90.44871747', '23.87340789', 'Apartment Flat commercial office space land plot properties for sale or rent in Uttar Khan', 'Apartment Flat commercial office space land plot properties for sale or rent in Uttar Khan', 'Apartment Flat commercial office space land plot properties for sale or rent in Uttar Khan', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 19:52:39', '2016-08-31 20:09:26'),
(145, 'Amin Bazar', '90.331038', '23.786027', 'Apartment Flat commercial office space land plot properties for sale or rent in Amin Bazar', 'Apartment Flat commercial office space land plot properties for sale or rent in Amin Bazar', 'Apartment Flat commercial office space land plot properties for sale or rent in Amin Bazar', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 20:01:09', '2016-08-08 20:01:09'),
(146, 'Baitul Aman Housing', '90.35535514', '23.77099074', 'Apartment Flat commercial office space land plot properties for sale or rent in Baitul Aman Housing', 'Apartment Flat commercial office space land plot properties for sale or rent in Baitul Aman Housing', 'Apartment Flat commercial office space land plot properties for sale or rent in Baitul Aman Housing', NULL, 1, 1, 1, 0, '13', '13', '2016-08-08 20:03:42', '2016-08-31 20:11:10');
INSERT INTO `crm_area` (`id`, `name`, `lon`, `lat`, `title`, `meta_keywords`, `meta_description`, `note`, `rh_city_id`, `is_delete`, `is_active`, `orderby`, `created_by`, `modified_by`, `created_at`, `modified_at`) VALUES
(147, 'Mirpur DOHS', '90.367929', '23.836894', 'Flat, Apartment, Plot, Commercial Space sale and rent in Mirpur DOHS', 'Flat, Apartment, Plot, Commercial Space sale and rent in Mirpur DOHS', 'Flat, Apartment, Plot, Commercial Space sale and rent in Mirpur DOHS', NULL, 1, 1, 1, 0, '13', '13', '2016-10-04 19:52:28', '2016-10-04 19:52:28'),
(148, 'Nasirbad', '91.823301', '22.360821', 'Flat, Apartment, Land, Plot, Commercial Space sale and rent in Nasirbad', 'Flat, Apartment, Land, Plot, Commercial Space sale and rent in Nasirbad', 'Flat, Apartment, Land, Plot, Commercial Space sale and rent in Nasirbad', NULL, 4, 1, 1, 0, '13', '13', '2016-10-09 19:01:06', '2016-10-09 19:01:06'),
(149, 'Pahartali', '91.966902', '22.459586', 'Flat, Apartment, Plot, Commercial Space sale and rent in Pahartali', 'Flat, Apartment, Plot, Commercial Space sale and rent in Pahartali', 'Flat, Apartment, Plot, Commercial Space sale and rent in Pahartali', NULL, 4, 1, 1, 0, '13', '13', '2016-10-09 19:07:51', '2016-10-09 19:07:51'),
(150, 'Wari', '90.417820', '23.717351', 'Flat, Apartment, Plot, Commercial Space sale and rent in Wari', 'Flat, Apartment, Plot, Commercial Space sale and rent in Wari', 'Flat, Apartment, Plot, Commercial Space sale and rent in Wari', NULL, 1, 1, 1, 0, '13', '13', '2016-10-09 19:15:08', '2016-10-09 19:15:08'),
(151, 'Cornelhat', '91.777803', '22.368934', 'Flat, Apartment, Plot, Commercial Space sale and rent in Cornelhat', 'Flat, Apartment, Plot, Commercial Space sale and rent in Cornelhat', 'Flat, Apartment, Plot, Commercial Space sale and rent in Cornelhat', NULL, 4, 1, 1, 1, '13', '13', '2016-10-09 19:33:42', '2016-10-09 19:33:42'),
(152, 'Panchlaish', '91.834272', '22.362187', 'Flat, Apartment, Plot, Commercial Space sale and rent in Panchlaish', 'Flat, Apartment, Plot, Commercial Space sale and rent in Panchlaish', 'Flat, Apartment, Plot, Commercial Space sale and rent in Panchlaish', NULL, 4, 1, 1, 0, '11', '11', '2016-10-10 10:39:47', '2016-10-10 10:39:47'),
(153, 'Uposahar', '88.598796', '24.379695', 'Flat, Apartment, Plot, Commercial Space sale and rent in Uposahar', 'Flat, Apartment, Plot, Commercial Space sale and rent in Uposahar', 'Flat, Apartment, Plot, Commercial Space sale and rent in Uposahar', NULL, 6, 1, 1, 0, '11', '11', '2016-10-10 11:27:19', '2016-10-10 11:27:19'),
(154, 'Bahaddarhat', '91.843785', '22.368540', 'Flat, Apartment, Plot, Commercial Space sale and rent in Bahaddarhat', 'Flat, Apartment, Plot, Commercial Space sale and rent in Bahaddarhat', 'Flat, Apartment, Plot, Commercial Space sale and rent in Bahaddarhat', NULL, 4, 1, 1, 0, '11', '11', '2016-10-10 19:25:05', '2016-10-10 19:25:05'),
(155, 'Ramna', '90.4000566', '23.73608607', 'Flat, Apartment, Plot, Commercial Space sale and rent in Ramna', 'Flat, Apartment, Plot, Commercial Space sale and rent in Ramna', 'Flat, Apartment, Plot, Commercial Space sale and rent in Ramna', NULL, 1, 1, 1, 0, '11', '11', '2016-10-24 14:18:32', '2016-10-24 14:18:32'),
(158, 'test', '91.9881527', '23.1793157', 'eeeee', 'eeeeeeee', '', NULL, 4, 1, 1, 0, '11', '11', '2016-10-30 13:09:05', '2016-10-30 13:09:05'),
(159, 'Kolatoli', '91.98434383', '21.41610257', 'flat studio apartment commercial space hotel motel sale rent in kolatoli', 'flat studio apartment commercial space hotel motel sale rent in kolatoli', 'flat studio apartment commercial space hotel motel sale rent in kolatoli', NULL, 16, 1, 1, 0, '11', '11', '2016-10-30 13:21:43', '2016-10-30 13:21:43'),
(160, 'Himchori', '92.02442408', '21.35481807', 'flat studio apartment commercial space hotel motel sale rent in Himchori', 'flat studio apartment commercial space hotel motel sale rent in Himchori', 'flat studio apartment commercial space hotel motel sale rent in Himchori', NULL, 16, 1, 1, 0, '11', '11', '2016-10-30 13:26:23', '2016-10-30 13:26:23'),
(161, 'Karatia', '89.9744868', '24.2241109', 'flat studio apartment commercial space hotel motel sale rent in Karatia', 'flat studio apartment commercial space hotel motel sale rent in Karatia', 'flat studio apartment commercial space hotel motel sale rent in Karatia', NULL, 17, 1, 1, 0, '11', '11', '2016-10-30 18:32:46', '2016-10-30 18:32:46'),
(162, 'Laksam', '91.03614807', '23.21989294', 'flat studio apartment commercial space hotel motel sale rent in Laksham', 'flat studio apartment commercial space hotel motel sale rent in Laksham', 'flat studio apartment commercial space hotel motel sale rent in Laksham', NULL, 11, 1, 1, 0, '11', '11', '2016-11-01 17:10:03', '2016-11-01 17:10:03'),
(163, 'Tongi', '90.39799588', '23.90871638', 'flat studio apartment commercial space hotel motel sale rent in Tongi', 'flat studio apartment commercial space hotel motel sale rent in Tongi', 'flat studio apartment commercial space hotel motel sale rent in Tongi', NULL, 9, 1, 1, 0, '11', '11', '2016-11-01 17:13:48', '2016-11-01 17:13:48'),
(164, 'Gazipur Sadar', '90.426021', '23.999892', 'flat apartmen land sale rent at flat apartmen', 'flat apartmen land sale rent at flat apartmen', 'flat apartmen land sale rent at flat apartmen', NULL, 9, 1, 1, 0, '11', '11', '2016-11-06 18:12:04', '2016-11-06 18:12:04'),
(165, 'Konabari', '90.322010', '24.010740', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Konabari', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Konabari', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Konabari', NULL, 9, 1, 1, 0, '11', '11', '2016-11-06 18:14:49', '2016-11-06 18:14:49'),
(166, 'Sofipur', '90.277264', '24.023278', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Sofipur', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Sofipur', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Sofipur', NULL, 9, 1, 1, 0, '11', '11', '2016-11-06 18:17:44', '2016-11-06 18:17:44'),
(167, 'Kaliakoir', '90.209770', '24.077847', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Kaliakair', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Kaliakair', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Kaliakair', NULL, 9, 1, 1, 0, '11', '11', '2016-11-06 18:19:21', '2016-11-06 18:19:21'),
(168, 'Ahmed Nagar', '90.358912', '23.793178', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Ahmed Nagar', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Ahmed Nagar', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Ahmed Nagar', NULL, 1, 1, 0, 0, '11', '11', '2016-11-09 16:26:52', '2017-02-05 16:22:55'),
(169, 'Ashkona', '90.417427', '23.852467', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Ashkona', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Ashkona', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Ashkona', NULL, 1, 1, 1, 0, '11', '11', '2016-11-09 16:29:21', '2016-11-09 16:29:21'),
(170, 'Balughat', '90.391152', '23.829618', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Balughat', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Balughat', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Balughat', NULL, 1, 1, 1, 0, '11', '11', '2016-11-09 16:30:58', '2016-11-09 16:30:58'),
(171, 'Doniya', '90.449023', '23.703298', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Doniya', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Doniya', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Doniya', NULL, 1, 1, 1, 0, '11', '11', '2016-11-09 16:33:17', '2016-11-09 16:33:17'),
(172, 'Kalshi', '90.377719', '23.822781', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Kalshi', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Kalshi', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Kalshi', NULL, 1, 1, 1, 0, '11', '11', '2016-11-09 16:37:21', '2016-11-09 16:37:21'),
(173, 'Matuail', '90.458121', '23.707279', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Matuail', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Matuail', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Matuail', NULL, 1, 1, 1, 0, '11', '11', '2016-11-09 16:40:46', '2016-11-09 16:40:46'),
(174, 'Manda', '90.444109', '23.731406', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Manda', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Manda', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Manda', NULL, 1, 1, 1, 0, '11', '11', '2016-11-09 16:42:40', '2016-11-09 16:42:40'),
(175, 'Mirbag', '90.413747', '23.758594', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirbag', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirbag', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirbag', NULL, 1, 1, 1, 0, '11', '11', '2016-11-09 16:44:23', '2016-11-09 16:44:23'),
(176, 'Mirpur 2', '90.361948', '23.807145', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 2', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 2', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 2', NULL, 1, 1, 1, 0, '11', '11', '2016-11-09 16:49:42', '2016-11-09 16:49:42'),
(177, 'Mirpur 6', '90.364770', '23.810159', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 6', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 6', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 6', NULL, 1, 1, 1, 0, '11', '11', '2016-11-09 16:53:22', '2016-11-09 16:53:22'),
(178, 'Mirpur 10', '90.36859989', '23.80701075', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 10', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 10', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 10', NULL, 1, 1, 1, 0, '11', '11', '2016-11-10 11:53:00', '2016-11-10 11:53:00'),
(179, 'Mirpur 11', '90.36613391', '23.81592391', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 11', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 11', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 11', NULL, 1, 1, 1, 0, '11', '11', '2016-11-10 11:54:37', '2016-11-10 11:54:37'),
(180, 'Mirpur 12', '90.36409378', '23.82804496', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 12', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 12', 'Flat Apartment Commercial Space industrial space land shop properties for sale rent at Mirpur 12', NULL, 1, 1, 1, 0, '11', '11', '2016-11-10 11:57:50', '2016-11-10 11:57:50'),
(181, 'Nikunjo', '90.419991', '23.827308', 'Flat apartment commercial space land sare rent at Nikunjo', 'Flat apartment commercial space land sare rent at Nikunjo', 'Flat apartment commercial space land sare rent at Nikunjo', NULL, 1, 1, 1, 0, '11', '11', '2016-11-26 12:25:58', '2016-11-26 12:25:58'),
(182, 'Mirzapur', '90.10299576', '24.10384316', 'Apartment flat plot commercial space office space for sale rent in Mirzapur', 'Apartment flat plot commercial space office space for sale rent in Mirzapur', 'Apartment flat plot commercial space office space for sale rent in Mirzapur', NULL, 17, 1, 1, 0, '11', '11', '2017-01-15 16:45:14', '2017-01-15 16:45:14'),
(183, 'Monipuripara', '90.3860187', '23.7620595', 'Apartment flat plot commercial space office space for sale rent in Monipuripara', 'Apartment flat plot commercial space office space for sale rent in Monipuripara', 'Apartment flat plot commercial space office space for sale rent in Monipuripara', NULL, 1, 1, 1, 0, '11', '11', '2017-01-30 17:48:50', '2017-01-30 17:48:50'),
(184, 'sadar', '1', '1', 'w', 'e', '', NULL, 18, 1, 1, 0, '11', '11', '2017-04-04 16:10:23', '2017-04-04 16:10:23'),
(185, 'Mirpur 14', '90.387561', '23.798269', 'Apartment flat commercial space land plot sale rent at Mirpur 14', 'Mirpur 14', 'Apartment flat commercial space land plot sale rent at Mirpur 14', NULL, 1, 1, 1, 0, '11', '11', '2017-04-06 11:35:21', '2017-04-06 11:35:21'),
(186, 'Mirpur 13', '90.378485', '23.807393', 'Apartment flat commercial space land plot sale rent properties at Mirpur 13', 'Apartment flat commercial space land plot sale rent properties at Mirpur 13', 'Apartment flat commercial space land plot sale rent properties at Mirpur 13', NULL, 1, 1, 1, 0, '11', '11', '2017-04-06 11:40:58', '2017-04-06 11:40:58'),
(187, 'Kuakata', '1', '1', 'kuakata', 'kuakata', '', NULL, 14, 1, 1, 0, '11', '11', '2017-07-22 13:03:50', '2017-07-22 13:03:50'),
(188, 'Comilla Cantonment', '91.119755', '23.468696', 'Property buy sell rent in Comilla cantonment', 'Property buy sell rent in Comilla cantonment', 'Property buy sell rent in Comilla cantonment', NULL, 11, 1, 1, 0, '11', '11', '2017-10-04 18:42:24', '2017-10-04 18:42:24'),
(189, 'Banani DOHS', '90.398972', '23.793263', 'Flat for sale in Banani DOHS Dhaka Bangladesh', 'Flat for sale in Banani DOHS Dhaka Bangladesh, Apartment for sale in Banani DOHS Dhaka Bangladesh, Ready Flat Apartment in Banani DOHS', 'If you are buying a flat or looking around for flat for sale in Banani DOHS Dhaka Bangladesh for more than you can financially afford there is a risk of it going into foreclosure if you cannot make the monthly payments. ', NULL, 1, 1, 1, -2, '12', '12', '2017-10-14 20:33:51', '2017-10-14 20:33:51'),
(190, 'Elephant Road', '90.387204', '23.738995', 'Flat for sale in Elephant Road Dhaka Bangladesh', 'Flat for sale in Elephant Road Dhaka Bangladesh, Aparment for sale in Elephant Road Dhaka Bangladesh', 'Before you think about buying a flat for sale in Elephant Road Dhaka Bangladesh, do check your credit worthiness. It is essential to scrutinize your credit report and see if you are eligible to get a home loan', NULL, 1, 1, 1, 0, '12', '12', '2017-10-18 16:37:02', '2017-10-18 16:37:02'),
(191, 'Mohakhali DOHS', '9', '23.80474989531609', 'Mohakhali', 'Mohakhali', 'Mohakhali', NULL, 1, 1, 1, 1000, '30', '30', '2018-09-02 15:19:49', '2018-09-02 15:19:49'),
(192, 'Narayangonj Sadar', '2222', '22222', 'Narayangonj Sadar Properties', 'Narayangonj Sadar Properties', 'Narayangonj Sadar Properties', NULL, 10, 1, 1, 1, '30', '30', '2019-02-10 10:20:47', '2019-02-10 10:20:47'),
(193, 'Shitakundo', '22.620852', '91.656960', 'Shitakundo', 'Shitakundo', 'Shitakundo', NULL, 4, 1, 1, 1000, '30', '30', '2019-10-22 18:15:49', '2019-10-22 18:15:49'),
(194, 'Vatara', '90.427924', '23.797981', 'Flat I Apartment I Commercial Space I Land sale or rent in Vatara, Dhaka Bangladesh', 'Vatara', 'See all flat apartment commercial space land sale or rent in Vatara, Dhaka Bangladesh', NULL, 1, 1, 1, 122, '30', '30', '2019-10-30 10:54:29', '2019-10-30 10:54:29'),
(195, 'Basila', '90.347245', '23.752384', 'Flat I Apartment I Commercial Space I Land for Sale and Rent In Basila Dhaka', 'Basila Dhaka', 'See all properties of Basila Dhaka', NULL, 1, 1, 1, 123, '30', '30', '2019-10-30 10:58:37', '2019-10-30 10:58:37'),
(196, 'Dholaikhal', '222222', '122222', 'Dholaikhal', 'Dholaikhal', 'Dholaikhal', NULL, 1, 1, 1, 134, '30', '30', '2019-11-06 14:45:03', '2019-11-06 14:45:03'),
(197, 'Mirpur 7', '24', '23', 'Apartment for sale Mirpur 7', 'Apartment for sale Mirpur 7', 'Apartment for sale Mirpur 7', NULL, 1, 1, 1, 211, '30', '30', '2019-11-18 17:09:41', '2019-11-18 17:09:41'),
(198, 'Mugdapara', '23', '23', 'Apartment for sale Mugdapara', 'Apartment for sale Mugdapara', 'Apartment for sale Mugdapara', NULL, 1, 1, 1, 221, '30', '30', '2019-11-18 17:12:34', '2019-11-18 17:12:34'),
(199, 'Gulshan 01', '90.416704', '23.780004', 'gulshan 01', 'gulshan 01', 'gulshan 01', NULL, 1, 1, 1, 0, '30', '30', '2020-07-02 16:53:51', '2020-07-02 16:53:51'),
(200, 'Padma Residential Area', '23', '23', 'Padma Residential Area', 'Padma Residential Area', 'Padma Residential Area', NULL, 6, 1, 1, 1000, '30', '30', '2020-09-23 18:25:59', '2020-09-23 18:25:59'),
(201, 'Mohanonda Residential Area', '23', '23', 'Mohanonda Residential Area', 'Mohanonda Residential Area', 'Mohanonda Residential Area', NULL, 6, 1, 1, 1001, '30', '30', '2020-09-23 18:26:46', '2020-09-23 18:26:46'),
(202, 'Sagor Para', '23', '23', 'Sagor Para', 'Sagor Para', 'Sagor Para', NULL, 6, 1, 1, 1002, '30', '30', '2020-09-23 18:27:24', '2020-09-23 18:27:24'),
(203, 'Belder Para', '23', '23', 'Belder Para', 'Belder Para', 'Belder Para', NULL, 6, 1, 1, 10002, '30', '30', '2020-09-23 18:28:00', '2020-09-23 18:28:00'),
(204, 'Terokhadia', '23', '23', 'Terokhadia', 'Terokhadia', 'Terokhadia', NULL, 6, 1, 1, 12222, '30', '30', '2020-09-23 18:28:47', '2020-09-23 18:28:47'),
(205, 'Shankar', '12', '12', 'Apartment Land Plot Properties for Sale or Rent in Shankar', 'shankar', 'Apartment Land Plot Properties for Sale or Rent in Shankar', NULL, 1, 1, 1, 0, '30', '30', '2020-10-13 21:27:58', '2020-10-13 21:27:58');
-- --------------------------------------------------------
--
-- Table structure for table `crm_categories`
--
CREATE TABLE `crm_categories` (
`id` int NOT NULL,
`name` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`banner_images` varchar(255) NOT NULL,
`is_active` int NOT NULL DEFAULT '1',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=InnoDB DEFAULT CHARSET=utf16le;
--
-- Dumping data for table `crm_categories`
--
INSERT INTO `crm_categories` (`id`, `name`, `slug`, `banner_images`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Ecommerce', '', '', 1, '2022-10-12 09:23:31', '0000-00-00 00:00:00'),
(2, 'Classified', '', '', 1, '2022-10-12 09:23:31', '0000-00-00 00:00:00'),
(3, 'Work Automation web app', '', '', 1, '2022-10-12 15:18:32', '0000-00-00 00:00:00'),
(4, 'Vcard', '', '', 1, '2022-10-12 15:18:32', '0000-00-00 00:00:00'),
(5, 'Company Profile', '', '', 1, '2022-10-12 15:19:12', '0000-00-00 00:00:00'),
(6, 'Blog', '', '', 1, '2022-10-12 15:19:12', '0000-00-00 00:00:00'),
(7, 'Car Tuning', '', '', 1, '2022-10-12 15:19:38', '0000-00-00 00:00:00'),
(8, 'Service Provider', '', '', 1, '2022-10-12 15:19:38', '0000-00-00 00:00:00'),
(9, 'Property Buy/Sell', '', '', 1, '2022-10-12 15:20:05', '0000-00-00 00:00:00'),
(10, 'Product Reviews', '', '', 1, '2022-10-12 15:20:05', '0000-00-00 00:00:00'),
(11, 'Blog', '', '', 1, '2022-10-12 15:20:27', '0000-00-00 00:00:00'),
(12, 'Quiz', '', '', 1, '2022-10-12 15:20:27', '0000-00-00 00:00:00'),
(13, 'MLM', '', '', 1, '2022-10-12 15:20:51', '0000-00-00 00:00:00'),
(14, 'Car Rent', '', '', 1, '2022-10-12 15:20:51', '0000-00-00 00:00:00'),
(15, 'Multivendor Ecommerce', 'multivendor-ecommerce', '', 1, '2022-10-13 15:44:09', '2022-10-13 15:44:09'),
(16, 'Raffle Draw', 'raffle-draw', '', 1, '2022-10-15 12:43:06', '2022-10-15 12:43:06'),
(17, 'Escrow', 'escrow', '', 1, '2022-10-15 13:07:43', '2022-10-15 13:07:43'),
(18, 'Android/Ios Native Apps', 'androidios-native-apps', '', 1, '2022-10-20 13:27:24', '2022-10-20 13:27:24'),
(19, 'Android/Ios PWA Apps', 'androidios-pwa-apps', '', 1, '2022-10-20 13:27:41', '2022-10-20 13:27:41'),
(20, 'IOS PWA', 'ios-pwa', '', 1, '2022-10-20 13:27:54', '2022-10-20 13:27:54'),
(21, 'Android PWA', 'android-pwa', '', 1, '2022-10-20 13:28:10', '2022-10-20 13:28:10'),
(22, 'Hotel Website', 'hotel-website', '', 1, '2022-12-28 17:14:31', '2022-12-28 17:14:31'),
(23, 'Photo Frame Builder', 'photo-frame-builder', '', 1, '2023-01-08 12:19:04', '2023-01-08 12:19:04');
-- --------------------------------------------------------
--
-- Table structure for table `crm_city`
--
CREATE TABLE `crm_city` (
`id` int NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`lon` varchar(100) DEFAULT NULL,
`lat` varchar(100) DEFAULT NULL,
`title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`meta_keywords` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`meta_description` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`note` varchar(500) DEFAULT NULL,
`is_delete` int DEFAULT NULL,
`is_active` int DEFAULT NULL,
`orderby` int DEFAULT NULL,
`created_by` varchar(255) DEFAULT NULL,
`modified_by` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`modified_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `crm_city`
--
INSERT INTO `crm_city` (`id`, `name`, `lon`, `lat`, `title`, `meta_keywords`, `meta_description`, `note`, `is_delete`, `is_active`, `orderby`, `created_by`, `modified_by`, `created_at`, `modified_at`) VALUES
(1, 'Dhaka', '23.778742', '90.398179', 'Apartment Land Plot Properties for Sale or Rent in Dhaka ', 'apartment, plot, land, sale, rent, Dhaka city', 'Looking for apartment or Flat, plot, office space, commercial space properties for sale or rent in Dhaka City? Rehabhousing.com ', 'note', 1, 1, 1, '1', '13', '2016-05-03 17:03:19', '2016-07-16 14:16:44'),
(3, 'Khulna', '89.5403279', '22.845641', 'Apartment Flat Land Properties for sale or rent in khulna', 'Properties for sale or rent in khulna', '', NULL, 1, 1, 4, '13', '13', '2016-05-24 19:10:21', '2016-08-31 20:13:07'),
(4, 'Chittagong', '91.8123324', '22.3475365', 'Apartment Flat Land Properties for sale or rent in Chittagong', 'Properties for sale or rent in Chittagong', 'Properties for sale or rent in Chittagong', NULL, 1, 1, 2, '13', '13', '2016-05-29 13:25:38', '2016-08-31 20:15:50'),
(5, 'Sylhet', '91.8611011', '24.904539', 'Apartment Land Plot Properties for Sale or Rent in Dhaka ', 'apartment, plot, land, sale, rent, Dhaka city', 'Looking for apartment or Flat, plot, office space, commercial space properties for sale or rent in Dhaka City? Rehabhousing.com ', NULL, 1, 1, 3, '1', '13', '2016-05-30 14:09:05', '2016-08-31 20:15:21'),
(6, 'Rajshahi', '88.6241351', '24.3635886', 'Apartment Land Plot Properties for Sale or Rent in Rajshahi', 'apartment, plot, land, sale, rent', 'Apartment Land Plot Properties for Sale or Rent in Rajshahi', NULL, 1, 1, 5, '1', '13', '2016-05-30 15:14:10', '2016-08-31 20:14:54'),
(7, 'Rangpur', '89.275227', '25.7438916', 'Rangpur', 'Rangpur', 'Rangpur', NULL, 1, 1, 6, '1', '13', '2016-06-25 23:55:47', '2016-08-31 20:14:27'),
(8, 'Barisal', '90.3465971', '22.7029212', 'Barisal', 'Barisal', 'Barisal', NULL, 1, 1, 7, '1', '13', '2016-06-25 23:56:30', '2016-08-31 20:14:02'),
(9, 'Gazipur', '90.41995883', '23.99985751', 'Property Sale Rent in Gazipur', 'Property Sale Rent in Gazipur', 'Property Sale Rent in Gazipur', NULL, 1, 1, 8, '13', '13', '2016-08-31 20:20:41', '2016-08-31 20:20:41'),
(10, 'Narayanganj', '90.499797', '23.622640', 'Flat, Apartment, Land, Plot, Commercial Space sale and rent in Narayanganj', 'Flat, Apartment, Land, Plot, Commercial Space sale and rent in Narayanganj', 'Flat, Apartment, Land, Plot, Commercial Space sale and rent in Narayanganj', NULL, 1, 1, 9, '13', '13', '2016-10-04 11:48:42', '2016-10-04 11:48:42'),
(11, 'Comilla', '91.186911', '23.461880', 'Flat, Apartment, Land, Plot, Commercial Space sale and rent in Comilla', 'Flat, Apartment, Land, Plot, Commercial Space sale and rent in Comilla', 'Flat, Apartment, Land, Plot, Commercial Space sale and rent in Comilla', NULL, 1, 1, 10, '13', '13', '2016-10-04 11:58:03', '2016-10-04 11:58:03'),
(12, 'Bogra', '89.370108', '24.843559', 'Flat, Apartment, Land, Plot, Commercial Space sale and rent in Bogra', 'Flat, Apartment, Land, Plot, Commercial Space sale and rent in Bogra', 'Flat, Apartment, Land, Plot, Commercial Space sale and rent in Bogra', NULL, 1, 1, 11, '13', '13', '2016-10-04 15:01:28', '2016-10-04 15:01:28'),
(14, 'Kuakata', '90.121890', '21.815523', 'Flat, Apartment, Land, Plot, Commercial Space sale and rent in Kuakata', 'Flat, Apartment, Land, Plot, Commercial Space sale and rent in Kuakata', 'Flat, Apartment, Land, Plot, Commercial Space sale and rent in Kuakata', NULL, 1, 1, 13, '13', '13', '2016-10-04 15:12:09', '2016-10-04 15:12:09'),
(16, 'Coxs Bazar', '92.007751', '21.439488', 'flat studio apartment commercial space hotel motel sale rent in Cox\'s Bazar', 'flat studio apartment commercial space hotel motel sale rent in Cox\'s Bazar', 'flat studio apartment commercial space hotel motel sale rent in Cox\'s Bazar', NULL, 1, 1, 16, '11', '11', '2016-10-30 13:14:58', '2016-10-30 18:42:25'),
(17, 'Tangail', '89.9113052', '24.244968', 'flat studio apartment commercial space hotel motel sale rent in Tangail', 'flat studio apartment commercial space hotel motel sale rent in Tangail', 'flat studio apartment commercial space hotel motel sale rent in Tangail', NULL, 1, 1, 15, '11', '11', '2016-10-30 18:31:11', '2016-10-30 18:31:11'),
(18, 'Mymensingh', '90.40924072', '24.74659745', 'Apartment flat plot commercial space office space for sale rent in Monipur Mymensingh', 'Apartment flat plot commercial space office space for sale rent in Monipur Mymensingh', 'Apartment flat plot commercial space office space for sale rent in Monipur Mymensingh', NULL, 1, 1, 17, '11', '11', '2017-01-15 15:57:45', '2017-01-15 15:58:24');
-- --------------------------------------------------------
--
-- Table structure for table `crm_countries`
--
CREATE TABLE `crm_countries` (
`id` int NOT NULL,
`iso` char(2) NOT NULL,
`name` varchar(80) NOT NULL,
`nicename` varchar(80) NOT NULL,
`iso3` char(3) DEFAULT NULL,
`numcode` smallint DEFAULT NULL,
`phonecode` int NOT NULL,
`created_at` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
--
-- Dumping data for table `crm_countries`
--
INSERT INTO `crm_countries` (`id`, `iso`, `name`, `nicename`, `iso3`, `numcode`, `phonecode`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES
(1, 'AF', 'AFGHANISTAN', 'Afghanistan', 'AFG', 4, 93, NULL, NULL, NULL, NULL),
(2, 'AL', 'ALBANIA', 'Albania', 'ALB', 8, 355, NULL, NULL, NULL, NULL),
(3, 'DZ', 'ALGERIA', 'Algeria', 'DZA', 12, 213, NULL, NULL, NULL, NULL),
(4, 'AS', 'AMERICAN SAMOA', 'American Samoa', 'ASM', 16, 1684, NULL, NULL, NULL, NULL),
(5, 'AD', 'ANDORRA', 'Andorra', 'AND', 20, 376, NULL, NULL, NULL, NULL),
(6, 'AO', 'ANGOLA', 'Angola', 'AGO', 24, 244, NULL, NULL, NULL, NULL),
(7, 'AI', 'ANGUILLA', 'Anguilla', 'AIA', 660, 1264, NULL, NULL, NULL, NULL),
(8, 'AQ', 'ANTARCTICA', 'Antarctica', NULL, NULL, 0, NULL, NULL, NULL, NULL),
(9, 'AG', 'ANTIGUA AND BARBUDA', 'Antigua and Barbuda', 'ATG', 28, 1268, NULL, NULL, NULL, NULL),
(10, 'AR', 'ARGENTINA', 'Argentina', 'ARG', 32, 54, NULL, NULL, NULL, NULL),
(11, 'AM', 'ARMENIA', 'Armenia', 'ARM', 51, 374, NULL, NULL, NULL, NULL),
(12, 'AW', 'ARUBA', 'Aruba', 'ABW', 533, 297, NULL, NULL, NULL, NULL),
(13, 'AU', 'AUSTRALIA', 'Australia', 'AUS', 36, 61, NULL, NULL, NULL, NULL),
(14, 'AT', 'AUSTRIA', 'Austria', 'AUT', 40, 43, NULL, NULL, NULL, NULL),
(15, 'AZ', 'AZERBAIJAN', 'Azerbaijan', 'AZE', 31, 994, NULL, NULL, NULL, NULL),
(16, 'BS', 'BAHAMAS', 'Bahamas', 'BHS', 44, 1242, NULL, NULL, NULL, NULL),
(17, 'BH', 'BAHRAIN', 'Bahrain', 'BHR', 48, 973, NULL, NULL, NULL, NULL),
(18, 'BD', 'BANGLADESH', 'Bangladesh', 'BGD', 50, 880, NULL, NULL, NULL, NULL),
(19, 'BB', 'BARBADOS', 'Barbados', 'BRB', 52, 1246, NULL, NULL, NULL, NULL),
(20, 'BY', 'BELARUS', 'Belarus', 'BLR', 112, 375, NULL, NULL, NULL, NULL),
(21, 'BE', 'BELGIUM', 'Belgium', 'BEL', 56, 32, NULL, NULL, NULL, NULL),
(22, 'BZ', 'BELIZE', 'Belize', 'BLZ', 84, 501, NULL, NULL, NULL, NULL),
(23, 'BJ', 'BENIN', 'Benin', 'BEN', 204, 229, NULL, NULL, NULL, NULL),
(24, 'BM', 'BERMUDA', 'Bermuda', 'BMU', 60, 1441, NULL, NULL, NULL, NULL),
(25, 'BT', 'BHUTAN', 'Bhutan', 'BTN', 64, 975, NULL, NULL, NULL, NULL),
(26, 'BO', 'BOLIVIA', 'Bolivia', 'BOL', 68, 591, NULL, NULL, NULL, NULL),
(27, 'BA', 'BOSNIA AND HERZEGOVINA', 'Bosnia and Herzegovina', 'BIH', 70, 387, NULL, NULL, NULL, NULL),
(28, 'BW', 'BOTSWANA', 'Botswana', 'BWA', 72, 267, NULL, NULL, NULL, NULL),
(29, 'BV', 'BOUVET ISLAND', 'Bouvet Island', NULL, NULL, 0, NULL, NULL, NULL, NULL),
(30, 'BR', 'BRAZIL', 'Brazil', 'BRA', 76, 55, NULL, NULL, NULL, NULL),
(31, 'IO', 'BRITISH INDIAN OCEAN TERRITORY', 'British Indian Ocean Territory', NULL, NULL, 246, NULL, NULL, NULL, NULL),
(32, 'BN', 'BRUNEI DARUSSALAM', 'Brunei Darussalam', 'BRN', 96, 673, NULL, NULL, NULL, NULL),
(33, 'BG', 'BULGARIA', 'Bulgaria', 'BGR', 100, 359, NULL, NULL, NULL, NULL),
(34, 'BF', 'BURKINA FASO', 'Burkina Faso', 'BFA', 854, 226, NULL, NULL, NULL, NULL),
(35, 'BI', 'BURUNDI', 'Burundi', 'BDI', 108, 257, NULL, NULL, NULL, NULL),
(36, 'KH', 'CAMBODIA', 'Cambodia', 'KHM', 116, 855, NULL, NULL, NULL, NULL),
(37, 'CM', 'CAMEROON', 'Cameroon', 'CMR', 120, 237, NULL, NULL, NULL, NULL),
(38, 'CA', 'CANADA', 'Canada', 'CAN', 124, 1, NULL, NULL, NULL, NULL),
(39, 'CV', 'CAPE VERDE', 'Cape Verde', 'CPV', 132, 238, NULL, NULL, NULL, NULL),
(40, 'KY', 'CAYMAN ISLANDS', 'Cayman Islands', 'CYM', 136, 1345, NULL, NULL, NULL, NULL),
(41, 'CF', 'CENTRAL AFRICAN REPUBLIC', 'Central African Republic', 'CAF', 140, 236, NULL, NULL, NULL, NULL),
(42, 'TD', 'CHAD', 'Chad', 'TCD', 148, 235, NULL, NULL, NULL, NULL),
(43, 'CL', 'CHILE', 'Chile', 'CHL', 152, 56, NULL, NULL, NULL, NULL),
(44, 'CN', 'CHINA', 'China', 'CHN', 156, 86, NULL, NULL, NULL, NULL),
(45, 'CX', 'CHRISTMAS ISLAND', 'Christmas Island', NULL, NULL, 61, NULL, NULL, NULL, NULL),
(46, 'CC', 'COCOS (KEELING) ISLANDS', 'Cocos (Keeling) Islands', NULL, NULL, 672, NULL, NULL, NULL, NULL),
(47, 'CO', 'COLOMBIA', 'Colombia', 'COL', 170, 57, NULL, NULL, NULL, NULL),
(48, 'KM', 'COMOROS', 'Comoros', 'COM', 174, 269, NULL, NULL, NULL, NULL),
(49, 'CG', 'CONGO', 'Congo', 'COG', 178, 242, NULL, NULL, NULL, NULL),
(50, 'CD', 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'Congo, the Democratic Republic of the', 'COD', 180, 242, NULL, NULL, NULL, NULL),
(51, 'CK', 'COOK ISLANDS', 'Cook Islands', 'COK', 184, 682, NULL, NULL, NULL, NULL),
(52, 'CR', 'COSTA RICA', 'Costa Rica', 'CRI', 188, 506, NULL, NULL, NULL, NULL),
(53, 'CI', 'COTE D\'IVOIRE', 'Cote D\'Ivoire', 'CIV', 384, 225, NULL, NULL, NULL, NULL),
(54, 'HR', 'CROATIA', 'Croatia', 'HRV', 191, 385, NULL, NULL, NULL, NULL),
(55, 'CU', 'CUBA', 'Cuba', 'CUB', 192, 53, NULL, NULL, NULL, NULL),
(56, 'CY', 'CYPRUS', 'Cyprus', 'CYP', 196, 357, NULL, NULL, NULL, NULL),
(57, 'CZ', 'CZECH REPUBLIC', 'Czech Republic', 'CZE', 203, 420, NULL, NULL, NULL, NULL),
(58, 'DK', 'DENMARK', 'Denmark', 'DNK', 208, 45, NULL, NULL, NULL, NULL),
(59, 'DJ', 'DJIBOUTI', 'Djibouti', 'DJI', 262, 253, NULL, NULL, NULL, NULL),
(60, 'DM', 'DOMINICA', 'Dominica', 'DMA', 212, 1767, NULL, NULL, NULL, NULL),
(61, 'DO', 'DOMINICAN REPUBLIC', 'Dominican Republic', 'DOM', 214, 1809, NULL, NULL, NULL, NULL),
(62, 'EC', 'ECUADOR', 'Ecuador', 'ECU', 218, 593, NULL, NULL, NULL, NULL),
(63, 'EG', 'EGYPT', 'Egypt', 'EGY', 818, 20, NULL, NULL, NULL, NULL),
(64, 'SV', 'EL SALVADOR', 'El Salvador', 'SLV', 222, 503, NULL, NULL, NULL, NULL),
(65, 'GQ', 'EQUATORIAL GUINEA', 'Equatorial Guinea', 'GNQ', 226, 240, NULL, NULL, NULL, NULL),
(66, 'ER', 'ERITREA', 'Eritrea', 'ERI', 232, 291, NULL, NULL, NULL, NULL),
(67, 'EE', 'ESTONIA', 'Estonia', 'EST', 233, 372, NULL, NULL, NULL, NULL),
(68, 'ET', 'ETHIOPIA', 'Ethiopia', 'ETH', 231, 251, NULL, NULL, NULL, NULL),
(69, 'FK', 'FALKLAND ISLANDS (MALVINAS)', 'Falkland Islands (Malvinas)', 'FLK', 238, 500, NULL, NULL, NULL, NULL),
(70, 'FO', 'FAROE ISLANDS', 'Faroe Islands', 'FRO', 234, 298, NULL, NULL, NULL, NULL),
(71, 'FJ', 'FIJI', 'Fiji', 'FJI', 242, 679, NULL, NULL, NULL, NULL),
(72, 'FI', 'FINLAND', 'Finland', 'FIN', 246, 358, NULL, NULL, NULL, NULL),
(73, 'FR', 'FRANCE', 'France', 'FRA', 250, 33, NULL, NULL, NULL, NULL),
(74, 'GF', 'FRENCH GUIANA', 'French Guiana', 'GUF', 254, 594, NULL, NULL, NULL, NULL),
(75, 'PF', 'FRENCH POLYNESIA', 'French Polynesia', 'PYF', 258, 689, NULL, NULL, NULL, NULL),
(76, 'TF', 'FRENCH SOUTHERN TERRITORIES', 'French Southern Territories', NULL, NULL, 0, NULL, NULL, NULL, NULL),
(77, 'GA', 'GABON', 'Gabon', 'GAB', 266, 241, NULL, NULL, NULL, NULL),
(78, 'GM', 'GAMBIA', 'Gambia', 'GMB', 270, 220, NULL, NULL, NULL, NULL),
(79, 'GE', 'GEORGIA', 'Georgia', 'GEO', 268, 995, NULL, NULL, NULL, NULL),
(80, 'DE', 'GERMANY', 'Germany', 'DEU', 276, 49, NULL, NULL, NULL, NULL),
(81, 'GH', 'GHANA', 'Ghana', 'GHA', 288, 233, NULL, NULL, NULL, NULL),
(82, 'GI', 'GIBRALTAR', 'Gibraltar', 'GIB', 292, 350, NULL, NULL, NULL, NULL),
(83, 'GR', 'GREECE', 'Greece', 'GRC', 300, 30, NULL, NULL, NULL, NULL),
(84, 'GL', 'GREENLAND', 'Greenland', 'GRL', 304, 299, NULL, NULL, NULL, NULL),
(85, 'GD', 'GRENADA', 'Grenada', 'GRD', 308, 1473, NULL, NULL, NULL, NULL),
(86, 'GP', 'GUADELOUPE', 'Guadeloupe', 'GLP', 312, 590, NULL, NULL, NULL, NULL),
(87, 'GU', 'GUAM', 'Guam', 'GUM', 316, 1671, NULL, NULL, NULL, NULL),
(88, 'GT', 'GUATEMALA', 'Guatemala', 'GTM', 320, 502, NULL, NULL, NULL, NULL),
(89, 'GN', 'GUINEA', 'Guinea', 'GIN', 324, 224, NULL, NULL, NULL, NULL),
(90, 'GW', 'GUINEA-BISSAU', 'Guinea-Bissau', 'GNB', 624, 245, NULL, NULL, NULL, NULL),
(91, 'GY', 'GUYANA', 'Guyana', 'GUY', 328, 592, NULL, NULL, NULL, NULL),
(92, 'HT', 'HAITI', 'Haiti', 'HTI', 332, 509, NULL, NULL, NULL, NULL),
(93, 'HM', 'HEARD ISLAND AND MCDONALD ISLANDS', 'Heard Island and Mcdonald Islands', NULL, NULL, 0, NULL, NULL, NULL, NULL),
(94, 'VA', 'HOLY SEE (VATICAN CITY STATE)', 'Holy See (Vatican City State)', 'VAT', 336, 39, NULL, NULL, NULL, NULL),
(95, 'HN', 'HONDURAS', 'Honduras', 'HND', 340, 504, NULL, NULL, NULL, NULL),
(96, 'HK', 'HONG KONG', 'Hong Kong', 'HKG', 344, 852, NULL, NULL, NULL, NULL),
(97, 'HU', 'HUNGARY', 'Hungary', 'HUN', 348, 36, NULL, NULL, NULL, NULL),
(98, 'IS', 'ICELAND', 'Iceland', 'ISL', 352, 354, NULL, NULL, NULL, NULL),
(99, 'IN', 'INDIA', 'India', 'IND', 356, 91, NULL, NULL, NULL, NULL),
(100, 'ID', 'INDONESIA', 'Indonesia', 'IDN', 360, 62, NULL, NULL, NULL, NULL),
(101, 'IR', 'IRAN, ISLAMIC REPUBLIC OF', 'Iran, Islamic Republic of', 'IRN', 364, 98, NULL, NULL, NULL, NULL),
(102, 'IQ', 'IRAQ', 'Iraq', 'IRQ', 368, 964, NULL, NULL, NULL, NULL),
(103, 'IE', 'IRELAND', 'Ireland', 'IRL', 372, 353, NULL, NULL, NULL, NULL),
(104, 'IL', 'ISRAEL', 'Israel', 'ISR', 376, 972, NULL, NULL, NULL, NULL),
(105, 'IT', 'ITALY', 'Italy', 'ITA', 380, 39, NULL, NULL, NULL, NULL),
(106, 'JM', 'JAMAICA', 'Jamaica', 'JAM', 388, 1876, NULL, NULL, NULL, NULL),
(107, 'JP', 'JAPAN', 'Japan', 'JPN', 392, 81, NULL, NULL, NULL, NULL),
(108, 'JO', 'JORDAN', 'Jordan', 'JOR', 400, 962, NULL, NULL, NULL, NULL),
(109, 'KZ', 'KAZAKHSTAN', 'Kazakhstan', 'KAZ', 398, 7, NULL, NULL, NULL, NULL),
(110, 'KE', 'KENYA', 'Kenya', 'KEN', 404, 254, NULL, NULL, NULL, NULL),
(111, 'KI', 'KIRIBATI', 'Kiribati', 'KIR', 296, 686, NULL, NULL, NULL, NULL),
(112, 'KP', 'KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF', 'Korea, Democratic People\'s Republic of', 'PRK', 408, 850, NULL, NULL, NULL, NULL),
(113, 'KR', 'KOREA, REPUBLIC OF', 'Korea, Republic of', 'KOR', 410, 82, NULL, NULL, NULL, NULL),
(114, 'KW', 'KUWAIT', 'Kuwait', 'KWT', 414, 965, NULL, NULL, NULL, NULL),
(115, 'KG', 'KYRGYZSTAN', 'Kyrgyzstan', 'KGZ', 417, 996, NULL, NULL, NULL, NULL),
(116, 'LA', 'LAO PEOPLE\'S DEMOCRATIC REPUBLIC', 'Lao People\'s Democratic Republic', 'LAO', 418, 856, NULL, NULL, NULL, NULL),
(117, 'LV', 'LATVIA', 'Latvia', 'LVA', 428, 371, NULL, NULL, NULL, NULL),
(118, 'LB', 'LEBANON', 'Lebanon', 'LBN', 422, 961, NULL, NULL, NULL, NULL),
(119, 'LS', 'LESOTHO', 'Lesotho', 'LSO', 426, 266, NULL, NULL, NULL, NULL),
(120, 'LR', 'LIBERIA', 'Liberia', 'LBR', 430, 231, NULL, NULL, NULL, NULL),
(121, 'LY', 'LIBYAN ARAB JAMAHIRIYA', 'Libyan Arab Jamahiriya', 'LBY', 434, 218, NULL, NULL, NULL, NULL),
(122, 'LI', 'LIECHTENSTEIN', 'Liechtenstein', 'LIE', 438, 423, NULL, NULL, NULL, NULL),
(123, 'LT', 'LITHUANIA', 'Lithuania', 'LTU', 440, 370, NULL, NULL, NULL, NULL),
(124, 'LU', 'LUXEMBOURG', 'Luxembourg', 'LUX', 442, 352, NULL, NULL, NULL, NULL),
(125, 'MO', 'MACAO', 'Macao', 'MAC', 446, 853, NULL, NULL, NULL, NULL),
(126, 'MK', 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'Macedonia, the Former Yugoslav Republic of', 'MKD', 807, 389, NULL, NULL, NULL, NULL),
(127, 'MG', 'MADAGASCAR', 'Madagascar', 'MDG', 450, 261, NULL, NULL, NULL, NULL),
(128, 'MW', 'MALAWI', 'Malawi', 'MWI', 454, 265, NULL, NULL, NULL, NULL),
(129, 'MY', 'MALAYSIA', 'Malaysia', 'MYS', 458, 60, NULL, NULL, NULL, NULL),
(130, 'MV', 'MALDIVES', 'Maldives', 'MDV', 462, 960, NULL, NULL, NULL, NULL),
(131, 'ML', 'MALI', 'Mali', 'MLI', 466, 223, NULL, NULL, NULL, NULL),
(132, 'MT', 'MALTA', 'Malta', 'MLT', 470, 356, NULL, NULL, NULL, NULL),
(133, 'MH', 'MARSHALL ISLANDS', 'Marshall Islands', 'MHL', 584, 692, NULL, NULL, NULL, NULL),
(134, 'MQ', 'MARTINIQUE', 'Martinique', 'MTQ', 474, 596, NULL, NULL, NULL, NULL),
(135, 'MR', 'MAURITANIA', 'Mauritania', 'MRT', 478, 222, NULL, NULL, NULL, NULL),
(136, 'MU', 'MAURITIUS', 'Mauritius', 'MUS', 480, 230, NULL, NULL, NULL, NULL),
(137, 'YT', 'MAYOTTE', 'Mayotte', NULL, NULL, 269, NULL, NULL, NULL, NULL),
(138, 'MX', 'MEXICO', 'Mexico', 'MEX', 484, 52, NULL, NULL, NULL, NULL),
(139, 'FM', 'MICRONESIA, FEDERATED STATES OF', 'Micronesia, Federated States of', 'FSM', 583, 691, NULL, NULL, NULL, NULL),
(140, 'MD', 'MOLDOVA, REPUBLIC OF', 'Moldova, Republic of', 'MDA', 498, 373, NULL, NULL, NULL, NULL),
(141, 'MC', 'MONACO', 'Monaco', 'MCO', 492, 377, NULL, NULL, NULL, NULL),
(142, 'MN', 'MONGOLIA', 'Mongolia', 'MNG', 496, 976, NULL, NULL, NULL, NULL),
(143, 'MS', 'MONTSERRAT', 'Montserrat', 'MSR', 500, 1664, NULL, NULL, NULL, NULL),
(144, 'MA', 'MOROCCO', 'Morocco', 'MAR', 504, 212, NULL, NULL, NULL, NULL),
(145, 'MZ', 'MOZAMBIQUE', 'Mozambique', 'MOZ', 508, 258, NULL, NULL, NULL, NULL),
(146, 'MM', 'MYANMAR', 'Myanmar', 'MMR', 104, 95, NULL, NULL, NULL, NULL),
(147, 'NA', 'NAMIBIA', 'Namibia', 'NAM', 516, 264, NULL, NULL, NULL, NULL),
(148, 'NR', 'NAURU', 'Nauru', 'NRU', 520, 674, NULL, NULL, NULL, NULL),
(149, 'NP', 'NEPAL', 'Nepal', 'NPL', 524, 977, NULL, NULL, NULL, NULL),
(150, 'NL', 'NETHERLANDS', 'Netherlands', 'NLD', 528, 31, NULL, NULL, NULL, NULL),
(151, 'AN', 'NETHERLANDS ANTILLES', 'Netherlands Antilles', 'ANT', 530, 599, NULL, NULL, NULL, NULL),
(152, 'NC', 'NEW CALEDONIA', 'New Caledonia', 'NCL', 540, 687, NULL, NULL, NULL, NULL),
(153, 'NZ', 'NEW ZEALAND', 'New Zealand', 'NZL', 554, 64, NULL, NULL, NULL, NULL),
(154, 'NI', 'NICARAGUA', 'Nicaragua', 'NIC', 558, 505, NULL, NULL, NULL, NULL),
(155, 'NE', 'NIGER', 'Niger', 'NER', 562, 227, NULL, NULL, NULL, NULL),
(156, 'NG', 'NIGERIA', 'Nigeria', 'NGA', 566, 234, NULL, NULL, NULL, NULL),
(157, 'NU', 'NIUE', 'Niue', 'NIU', 570, 683, NULL, NULL, NULL, NULL),
(158, 'NF', 'NORFOLK ISLAND', 'Norfolk Island', 'NFK', 574, 672, NULL, NULL, NULL, NULL),
(159, 'MP', 'NORTHERN MARIANA ISLANDS', 'Northern Mariana Islands', 'MNP', 580, 1670, NULL, NULL, NULL, NULL),
(160, 'NO', 'NORWAY', 'Norway', 'NOR', 578, 47, NULL, NULL, NULL, NULL),
(161, 'OM', 'OMAN', 'Oman', 'OMN', 512, 968, NULL, NULL, NULL, NULL),
(162, 'PK', 'PAKISTAN', 'Pakistan', 'PAK', 586, 92, NULL, NULL, NULL, NULL),
(163, 'PW', 'PALAU', 'Palau', 'PLW', 585, 680, NULL, NULL, NULL, NULL),
(164, 'PS', 'PALESTINIAN TERRITORY, OCCUPIED', 'Palestinian Territory, Occupied', NULL, NULL, 970, NULL, NULL, NULL, NULL),
(165, 'PA', 'PANAMA', 'Panama', 'PAN', 591, 507, NULL, NULL, NULL, NULL),
(166, 'PG', 'PAPUA NEW GUINEA', 'Papua New Guinea', 'PNG', 598, 675, NULL, NULL, NULL, NULL),
(167, 'PY', 'PARAGUAY', 'Paraguay', 'PRY', 600, 595, NULL, NULL, NULL, NULL),
(168, 'PE', 'PERU', 'Peru', 'PER', 604, 51, NULL, NULL, NULL, NULL),
(169, 'PH', 'PHILIPPINES', 'Philippines', 'PHL', 608, 63, NULL, NULL, NULL, NULL),
(170, 'PN', 'PITCAIRN', 'Pitcairn', 'PCN', 612, 0, NULL, NULL, NULL, NULL),
(171, 'PL', 'POLAND', 'Poland', 'POL', 616, 48, NULL, NULL, NULL, NULL),
(172, 'PT', 'PORTUGAL', 'Portugal', 'PRT', 620, 351, NULL, NULL, NULL, NULL),
(173, 'PR', 'PUERTO RICO', 'Puerto Rico', 'PRI', 630, 1787, NULL, NULL, NULL, NULL),
(174, 'QA', 'QATAR', 'Qatar', 'QAT', 634, 974, NULL, NULL, NULL, NULL),
(175, 'RE', 'REUNION', 'Reunion', 'REU', 638, 262, NULL, NULL, NULL, NULL),
(176, 'RO', 'ROMANIA', 'Romania', 'ROM', 642, 40, NULL, NULL, NULL, NULL),
(177, 'RU', 'RUSSIAN FEDERATION', 'Russian Federation', 'RUS', 643, 70, NULL, NULL, NULL, NULL),
(178, 'RW', 'RWANDA', 'Rwanda', 'RWA', 646, 250, NULL, NULL, NULL, NULL),
(179, 'SH', 'SAINT HELENA', 'Saint Helena', 'SHN', 654, 290, NULL, NULL, NULL, NULL),
(180, 'KN', 'SAINT KITTS AND NEVIS', 'Saint Kitts and Nevis', 'KNA', 659, 1869, NULL, NULL, NULL, NULL),
(181, 'LC', 'SAINT LUCIA', 'Saint Lucia', 'LCA', 662, 1758, NULL, NULL, NULL, NULL),
(182, 'PM', 'SAINT PIERRE AND MIQUELON', 'Saint Pierre and Miquelon', 'SPM', 666, 508, NULL, NULL, NULL, NULL),
(183, 'VC', 'SAINT VINCENT AND THE GRENADINES', 'Saint Vincent and the Grenadines', 'VCT', 670, 1784, NULL, NULL, NULL, NULL),
(184, 'WS', 'SAMOA', 'Samoa', 'WSM', 882, 684, NULL, NULL, NULL, NULL),
(185, 'SM', 'SAN MARINO', 'San Marino', 'SMR', 674, 378, NULL, NULL, NULL, NULL),
(186, 'ST', 'SAO TOME AND PRINCIPE', 'Sao Tome and Principe', 'STP', 678, 239, NULL, NULL, NULL, NULL),
(187, 'SA', 'SAUDI ARABIA', 'Saudi Arabia', 'SAU', 682, 966, NULL, NULL, NULL, NULL),
(188, 'SN', 'SENEGAL', 'Senegal', 'SEN', 686, 221, NULL, NULL, NULL, NULL),
(189, 'CS', 'SERBIA AND MONTENEGRO', 'Serbia and Montenegro', NULL, NULL, 381, NULL, NULL, NULL, NULL),
(190, 'SC', 'SEYCHELLES', 'Seychelles', 'SYC', 690, 248, NULL, NULL, NULL, NULL),
(191, 'SL', 'SIERRA LEONE', 'Sierra Leone', 'SLE', 694, 232, NULL, NULL, NULL, NULL),
(192, 'SG', 'SINGAPORE', 'Singapore', 'SGP', 702, 65, NULL, NULL, NULL, NULL),
(193, 'SK', 'SLOVAKIA', 'Slovakia', 'SVK', 703, 421, NULL, NULL, NULL, NULL),
(194, 'SI', 'SLOVENIA', 'Slovenia', 'SVN', 705, 386, NULL, NULL, NULL, NULL),
(195, 'SB', 'SOLOMON ISLANDS', 'Solomon Islands', 'SLB', 90, 677, NULL, NULL, NULL, NULL),
(196, 'SO', 'SOMALIA', 'Somalia', 'SOM', 706, 252, NULL, NULL, NULL, NULL),
(197, 'ZA', 'SOUTH AFRICA', 'South Africa', 'ZAF', 710, 27, NULL, NULL, NULL, NULL),
(198, 'GS', 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'South Georgia and the South Sandwich Islands', NULL, NULL, 0, NULL, NULL, NULL, NULL),
(199, 'ES', 'SPAIN', 'Spain', 'ESP', 724, 34, NULL, NULL, NULL, NULL),
(200, 'LK', 'SRI LANKA', 'Sri Lanka', 'LKA', 144, 94, NULL, NULL, NULL, NULL),
(201, 'SD', 'SUDAN', 'Sudan', 'SDN', 736, 249, NULL, NULL, NULL, NULL),
(202, 'SR', 'SURINAME', 'Suriname', 'SUR', 740, 597, NULL, NULL, NULL, NULL),
(203, 'SJ', 'SVALBARD AND JAN MAYEN', 'Svalbard and Jan Mayen', 'SJM', 744, 47, NULL, NULL, NULL, NULL),
(204, 'SZ', 'SWAZILAND', 'Swaziland', 'SWZ', 748, 268, NULL, NULL, NULL, NULL),
(205, 'SE', 'SWEDEN', 'Sweden', 'SWE', 752, 46, NULL, NULL, NULL, NULL),
(206, 'CH', 'SWITZERLAND', 'Switzerland', 'CHE', 756, 41, NULL, NULL, NULL, NULL),
(207, 'SY', 'SYRIAN ARAB REPUBLIC', 'Syrian Arab Republic', 'SYR', 760, 963, NULL, NULL, NULL, NULL),
(208, 'TW', 'TAIWAN, PROVINCE OF CHINA', 'Taiwan, Province of China', 'TWN', 158, 886, NULL, NULL, NULL, NULL),
(209, 'TJ', 'TAJIKISTAN', 'Tajikistan', 'TJK', 762, 992, NULL, NULL, NULL, NULL),
(210, 'TZ', 'TANZANIA, UNITED REPUBLIC OF', 'Tanzania, United Republic of', 'TZA', 834, 255, NULL, NULL, NULL, NULL),
(211, 'TH', 'THAILAND', 'Thailand', 'THA', 764, 66, NULL, NULL, NULL, NULL),
(212, 'TL', 'TIMOR-LESTE', 'Timor-Leste', NULL, NULL, 670, NULL, NULL, NULL, NULL),
(213, 'TG', 'TOGO', 'Togo', 'TGO', 768, 228, NULL, NULL, NULL, NULL),
(214, 'TK', 'TOKELAU', 'Tokelau', 'TKL', 772, 690, NULL, NULL, NULL, NULL),
(215, 'TO', 'TONGA', 'Tonga', 'TON', 776, 676, NULL, NULL, NULL, NULL),
(216, 'TT', 'TRINIDAD AND TOBAGO', 'Trinidad and Tobago', 'TTO', 780, 1868, NULL, NULL, NULL, NULL),
(217, 'TN', 'TUNISIA', 'Tunisia', 'TUN', 788, 216, NULL, NULL, NULL, NULL),
(218, 'TR', 'TURKEY', 'Turkey', 'TUR', 792, 90, NULL, NULL, NULL, NULL),
(219, 'TM', 'TURKMENISTAN', 'Turkmenistan', 'TKM', 795, 7370, NULL, NULL, NULL, NULL),
(220, 'TC', 'TURKS AND CAICOS ISLANDS', 'Turks and Caicos Islands', 'TCA', 796, 1649, NULL, NULL, NULL, NULL),
(221, 'TV', 'TUVALU', 'Tuvalu', 'TUV', 798, 688, NULL, NULL, NULL, NULL),
(222, 'UG', 'UGANDA', 'Uganda', 'UGA', 800, 256, NULL, NULL, NULL, NULL),
(223, 'UA', 'UKRAINE', 'Ukraine', 'UKR', 804, 380, NULL, NULL, NULL, NULL),
(224, 'AE', 'UNITED ARAB EMIRATES', 'United Arab Emirates', 'ARE', 784, 971, NULL, NULL, NULL, NULL),
(225, 'GB', 'UNITED KINGDOM', 'United Kingdom', 'GBR', 826, 44, NULL, NULL, NULL, NULL),
(226, 'US', 'UNITED STATES', 'United States', 'USA', 840, 1, NULL, NULL, NULL, NULL),
(227, 'UM', 'UNITED STATES MINOR OUTLYING ISLANDS', 'United States Minor Outlying Islands', NULL, NULL, 1, NULL, NULL, NULL, NULL),
(228, 'UY', 'URUGUAY', 'Uruguay', 'URY', 858, 598, NULL, NULL, NULL, NULL),
(229, 'UZ', 'UZBEKISTAN', 'Uzbekistan', 'UZB', 860, 998, NULL, NULL, NULL, NULL),
(230, 'VU', 'VANUATU', 'Vanuatu', 'VUT', 548, 678, NULL, NULL, NULL, NULL),
(231, 'VE', 'VENEZUELA', 'Venezuela', 'VEN', 862, 58, NULL, NULL, NULL, NULL),
(232, 'VN', 'VIET NAM', 'Viet Nam', 'VNM', 704, 84, NULL, NULL, NULL, NULL),
(233, 'VG', 'VIRGIN ISLANDS, BRITISH', 'Virgin Islands, British', 'VGB', 92, 1284, NULL, NULL, NULL, NULL),
(234, 'VI', 'VIRGIN ISLANDS, U.S.', 'Virgin Islands, U.s.', 'VIR', 850, 1340, NULL, NULL, NULL, NULL),
(235, 'WF', 'WALLIS AND FUTUNA', 'Wallis and Futuna', 'WLF', 876, 681, NULL, NULL, NULL, NULL),
(236, 'EH', 'WESTERN SAHARA', 'Western Sahara', 'ESH', 732, 212, NULL, NULL, NULL, NULL),
(237, 'YE', 'YEMEN', 'Yemen', 'YEM', 887, 967, NULL, NULL, NULL, NULL),
(238, 'ZM', 'ZAMBIA', 'Zambia', 'ZMB', 894, 260, NULL, NULL, NULL, NULL),
(239, 'ZW', 'ZIMBABWE', 'Zimbabwe', 'ZWE', 716, 263, NULL, NULL, NULL, NULL),
(240, 'Te', 'test name', 'Test nicename', 'Te3', 10, 11, NULL, NULL, NULL, NULL),
(241, 'Te', 'test name', 'Test nicename', 'Te3', 10, 11, NULL, NULL, NULL, NULL),
(242, 'Te', 'test name', 'Test nicename', 'Te3', 10, 11, NULL, NULL, NULL, NULL),
(243, 'Te', 'test name', 'Test nicename', 'Te3', 10, 11, NULL, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `crm_currency`
--
CREATE TABLE `crm_currency` (
`id` bigint NOT NULL,
`currency` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
`currency_symbol` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
`conversion_rate` float(13,2) NOT NULL,
`status` int NOT NULL DEFAULT '1' COMMENT ' 1=active,0=inactive',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`report` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `crm_currency`
--
INSERT INTO `crm_currency` (`id`, `currency`, `currency_symbol`, `conversion_rate`, `status`, `created_at`, `updated_at`, `report`) VALUES
(1, 'USD', '$', 1.00, 1, '2024-02-11 08:28:58', NULL, 1),
(2, 'BDT', 'TK', 100.00, 1, '2024-02-11 08:28:58', '2024-08-12 13:57:37', 1);
-- --------------------------------------------------------
--
-- Table structure for table `crm_follow_up`
--
CREATE TABLE `crm_follow_up` (
`pk_id` int NOT NULL,
`lead_status` varchar(50) DEFAULT NULL COMMENT ' 0 => ''Not contacted yet'',\r\n 1 => ''Not Interest'',\r\n 2 => ''Low'',\r\n 3 => ''Average'',\r\n 4 => ''Potential'',\r\n 5 => ''Super Potential''',
`next_act_date` date DEFAULT NULL,
`nxt_act_by` varchar(50) DEFAULT NULL,
`nxt_act_by_name` varchar(255) DEFAULT NULL,
`act_mode` varchar(30) DEFAULT NULL,
`activity_comments` text,
`comments` longtext,
`listing_id` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`lead_id` int DEFAULT NULL,
`is_delete` int DEFAULT '1',
`is_active` int DEFAULT '1',
`created_by` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`modified_by` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`modified_at` datetime DEFAULT NULL,
`lead_rating` int DEFAULT NULL,
`is_done` int DEFAULT NULL COMMENT ' 1 = followup done, 0 = followup not done ',
`remarks` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
-- --------------------------------------------------------
--
-- Table structure for table `crm_images`
--
CREATE TABLE `crm_images` (
`pk_id` int NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`image_url` varchar(255) DEFAULT NULL,
`thumb_url` varchar(255) DEFAULT NULL,
`type` varchar(30) DEFAULT NULL,
`size` varchar(30) DEFAULT NULL,
`listing_id` int DEFAULT NULL,
`created_by` varchar(255) DEFAULT NULL,
`modified_by` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`modified_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `crm_images`
--
INSERT INTO `crm_images` (`pk_id`, `name`, `image_url`, `thumb_url`, `type`, `size`, `listing_id`, `created_by`, `modified_by`, `created_at`, `modified_at`) VALUES
(2, 'kNg6M30510.jpg', 'media/images/2020/12/kNg6M30510.jpg', 'media/images/2020/12/kNg6M30510.jpg', 'floors_plan', NULL, 1, NULL, NULL, '2020-12-30 10:33:48', NULL),
(5, '5GY3f30210.jpg', 'media/images/2020/12/5GY3f30210.jpg', 'media/images/2020/12/5GY3f30210.jpg', 'location_view', NULL, 1, NULL, NULL, '2020-12-30 10:33:48', NULL),
(10, 'bKP0O04403.jpg', 'media/images/2021/01/bKP0O04403.jpg', 'media/images/2021/01/bKP0O04403.jpg', 'location_view', NULL, 2, NULL, NULL, '2021-01-04 03:48:18', NULL),
(11, '8WhwA04704.jpg', 'media/images/2021/01/8WhwA04704.jpg', 'media/images/2021/01/8WhwA04704.jpg', 'feature_image', NULL, 3, NULL, NULL, '2021-01-04 04:05:10', NULL),
(12, 'uLkx804204.jpg', 'media/images/2021/01/uLkx804204.jpg', 'media/images/2021/01/uLkx804204.jpg', 'floors_plan', NULL, 3, NULL, NULL, '2021-01-04 04:05:10', NULL),
(13, 'Ry4q404804.jpg', 'media/images/2021/01/Ry4q404804.jpg', 'media/images/2021/01/Ry4q404804.jpg', 'floors_plan', NULL, 3, NULL, NULL, '2021-01-04 04:05:10', NULL),
(14, '8kZvw04204.jpg', 'media/images/2021/01/8kZvw04204.jpg', 'media/images/2021/01/8kZvw04204.jpg', 'location_view', NULL, 3, NULL, NULL, '2021-01-04 04:05:10', NULL),
(15, 'XNEQC04804.jpg', 'media/images/2021/01/XNEQC04804.jpg', 'media/images/2021/01/XNEQC04804.jpg', 'feature_image', NULL, 4, NULL, NULL, '2021-01-04 04:09:49', NULL),
(16, '5I2Rl04804.jpg', 'media/images/2021/01/5I2Rl04804.jpg', 'media/images/2021/01/5I2Rl04804.jpg', 'feature_image', NULL, 5, NULL, NULL, '2021-01-04 04:13:40', NULL),
(18, 'LC7cD04404.jpg', 'media/images/2021/01/LC7cD04404.jpg', 'media/images/2021/01/LC7cD04404.jpg', 'floors_plan', NULL, 6, NULL, NULL, '2021-01-04 04:17:38', NULL),
(19, 'myKQ504404.jpg', 'media/images/2021/01/myKQ504404.jpg', 'media/images/2021/01/myKQ504404.jpg', 'floors_plan', NULL, 6, NULL, NULL, '2021-01-04 04:17:38', NULL),
(20, 'XJMMb04304.jpg', 'media/images/2021/01/XJMMb04304.jpg', 'media/images/2021/01/XJMMb04304.jpg', 'feature_image', NULL, 7, NULL, NULL, '2021-01-04 04:23:21', NULL),
(21, 'dIjXi04104.jpg', 'media/images/2021/01/dIjXi04104.jpg', 'media/images/2021/01/dIjXi04104.jpg', 'floors_plan', NULL, 7, NULL, NULL, '2021-01-04 04:23:21', NULL),
(22, 'BxEml04904.jpg', 'media/images/2021/01/BxEml04904.jpg', 'media/images/2021/01/BxEml04904.jpg', 'floors_plan', NULL, 7, NULL, NULL, '2021-01-04 04:23:21', NULL),
(24, '3sYJ104504.jpg', 'media/images/2021/01/3sYJ104504.jpg', 'media/images/2021/01/3sYJ104504.jpg', 'feature_image', NULL, 8, NULL, NULL, '2021-01-04 04:27:40', NULL),
(25, 'wFdUW04604.jpg', 'media/images/2021/01/wFdUW04604.jpg', 'media/images/2021/01/wFdUW04604.jpg', 'floors_plan', NULL, 8, NULL, NULL, '2021-01-04 04:27:40', NULL),
(26, 'gLVvC04104.jpg', 'media/images/2021/01/gLVvC04104.jpg', 'media/images/2021/01/gLVvC04104.jpg', 'feature_image', NULL, 9, NULL, NULL, '2021-01-04 04:33:08', NULL),
(27, 'QM60z04204.jpg', 'media/images/2021/01/QM60z04204.jpg', 'media/images/2021/01/QM60z04204.jpg', 'floors_plan', NULL, 9, NULL, NULL, '2021-01-04 04:33:08', NULL),
(28, 'dsY5904204.jpg', 'media/images/2021/01/dsY5904204.jpg', 'media/images/2021/01/dsY5904204.jpg', 'floors_plan', NULL, 9, NULL, NULL, '2021-01-04 04:33:08', NULL),
(29, 'MOvbx04104.jpg', 'media/images/2021/01/MOvbx04104.jpg', 'media/images/2021/01/MOvbx04104.jpg', 'feature_image', NULL, 10, NULL, NULL, '2021-01-04 04:36:37', NULL),
(30, 'Tis3b04504.jpg', 'media/images/2021/01/Tis3b04504.jpg', 'media/images/2021/01/Tis3b04504.jpg', 'floors_plan', NULL, 10, NULL, NULL, '2021-01-04 04:36:37', NULL),
(33, 'LxKwK05912.png', 'media/images/2021/01/LxKwK05912.png', 'media/images/2021/01/LxKwK05912.png', 'feature_image', NULL, 11, NULL, NULL, '2021-01-05 12:23:26', NULL),
(34, 'ugIiz05604.jpeg', 'media/images/2021/01/ugIiz05604.jpeg', 'media/images/2021/01/ugIiz05604.jpeg', 'feature_image', NULL, 13, NULL, NULL, '2021-01-05 04:37:04', NULL),
(35, 'prod_17012021_60044720b5280.jpg', 'media/images/product/prod_17012021_60044720b5280.jpg', 'media/images/product/thumb/prod_17012021_60044720b5287.webp', 'floors_plan', NULL, 1, '1', NULL, '2021-01-17 08:18:08', NULL),
(36, 'prod_17012021_60044720dfcbf.jpg', 'media/images/product/prod_17012021_60044720dfcbf.jpg', 'media/images/product/thumb/prod_17012021_60044720dfcc2.webp', 'location_view', NULL, 1, '1', NULL, '2021-01-17 08:18:09', NULL),
(37, 'prod_17012021_6004475acd20c.jpg', 'media/images/product/prod_17012021_6004475acd20c.jpg', 'media/images/product/thumb/prod_17012021_6004475acd20f.webp', 'feature_image', NULL, 1, '1', NULL, '2021-01-17 08:19:06', NULL),
(38, 'prod_17012021_600447bb6f341.jpg', 'media/images/product/prod_17012021_600447bb6f341.jpg', 'media/images/product/thumb/prod_17012021_600447bb6f343.webp', 'gallery', NULL, 1, '1', NULL, '2021-01-17 08:20:43', NULL),
(39, 'prod_17012021_600447bb8af66.jpg', 'media/images/product/prod_17012021_600447bb8af66.jpg', 'media/images/product/thumb/prod_17012021_600447bb8af68.webp', 'gallery', NULL, 1, '1', NULL, '2021-01-17 08:20:43', NULL),
(40, 'prod_17012021_600447bba703b.jpg', 'media/images/product/prod_17012021_600447bba703b.jpg', 'media/images/product/thumb/prod_17012021_600447bba703d.webp', 'gallery', NULL, 1, '1', NULL, '2021-01-17 08:20:43', NULL),
(41, 'prod_17012021_600447ee62ec1.jpg', 'media/images/product/prod_17012021_600447ee62ec1.jpg', 'media/images/product/thumb/prod_17012021_600447ee62ec3.webp', 'gallery', NULL, 1, '1', NULL, '2021-01-17 08:21:34', NULL),
(42, 'prod_17012021_6004491d20687.jpg', 'media/images/product/prod_17012021_6004491d20687.jpg', 'media/images/product/thumb/prod_17012021_6004491d20689.webp', 'gallery', NULL, 33, '1', NULL, '2021-01-17 08:26:37', NULL),
(43, 'prod_17012021_6004491d411d7.jpg', 'media/images/product/prod_17012021_6004491d411d7.jpg', 'media/images/product/thumb/prod_17012021_6004491d411d9.webp', 'gallery', NULL, 33, '1', NULL, '2021-01-17 08:26:37', NULL),
(44, 'prod_17012021_6004491d63268.jpg', 'media/images/product/prod_17012021_6004491d63268.jpg', 'media/images/product/thumb/prod_17012021_6004491d6326a.webp', 'gallery', NULL, 33, '1', NULL, '2021-01-17 08:26:37', NULL),
(45, 'prod_17012021_6004491d7bfb9.jpg', 'media/images/product/prod_17012021_6004491d7bfb9.jpg', 'media/images/product/thumb/prod_17012021_6004491d7bfbb.webp', 'gallery', NULL, 33, '1', NULL, '2021-01-17 08:26:37', NULL),
(47, 'prod_17012021_600449d28ebde.jpg', 'media/images/product/prod_17012021_600449d28ebde.jpg', 'media/images/product/thumb/prod_17012021_600449d28ebe4.webp', 'feature_image', NULL, 33, '1', NULL, '2021-01-17 08:29:38', NULL),
(48, 'prod_17012021_600449d2a8a1c.jpg', 'media/images/product/prod_17012021_600449d2a8a1c.jpg', 'media/images/product/thumb/prod_17012021_600449d2a8a1e.webp', 'floors_plan', NULL, 33, '1', NULL, '2021-01-17 08:29:38', NULL),
(49, 'prod_17012021_600449d2c1fe2.jpg', 'media/images/product/prod_17012021_600449d2c1fe2.jpg', 'media/images/product/thumb/prod_17012021_600449d2c1fe5.webp', 'floors_plan', NULL, 33, '1', NULL, '2021-01-17 08:29:38', NULL),
(50, 'prod_17012021_600449d2d74df.jpg', 'media/images/product/prod_17012021_600449d2d74df.jpg', 'media/images/product/thumb/prod_17012021_600449d2d74e2.webp', 'floors_plan', NULL, 33, '1', NULL, '2021-01-17 08:29:38', NULL),
(51, 'prod_17012021_60044a4b98bb4.jpg', 'media/images/product/prod_17012021_60044a4b98bb4.jpg', 'media/images/product/thumb/prod_17012021_60044a4b98bb6.webp', 'location_view', NULL, 33, '1', NULL, '2021-01-17 08:31:39', NULL),
(52, 'prod_17012021_60044a4bbb577.jpg', 'media/images/product/prod_17012021_60044a4bbb577.jpg', 'media/images/product/thumb/prod_17012021_60044a4bbb57a.webp', 'location_view', NULL, 33, '1', NULL, '2021-01-17 08:31:39', NULL),
(53, 'prod_17012021_60044a4bd6a03.jpg', 'media/images/product/prod_17012021_60044a4bd6a03.jpg', 'media/images/product/thumb/prod_17012021_60044a4bd6a07.webp', 'location_view', NULL, 33, '1', NULL, '2021-01-17 08:31:39', NULL),
(54, 'prod_17012021_60044a4bec963.jpg', 'media/images/product/prod_17012021_60044a4bec963.jpg', 'media/images/product/thumb/prod_17012021_60044a4bec970.webp', 'location_view', NULL, 33, '1', NULL, '2021-01-17 08:31:40', NULL),
(56, 'prod_17012021_60044b2bd0338.jpg', 'media/images/product/prod_17012021_60044b2bd0338.jpg', 'media/images/product/thumb/prod_17012021_60044b2bd033a.webp', 'feature_image', NULL, 2, '1', NULL, '2021-01-17 08:35:23', NULL),
(57, 'prod_17012021_60044b2bec7cf.jpg', 'media/images/product/prod_17012021_60044b2bec7cf.jpg', 'media/images/product/thumb/prod_17012021_60044b2bec7d1.webp', 'gallery', NULL, 2, '1', NULL, '2021-01-17 08:35:24', NULL),
(58, 'prod_17012021_60044b2c119e0.jpg', 'media/images/product/prod_17012021_60044b2c119e0.jpg', 'media/images/product/thumb/prod_17012021_60044b2c119e2.webp', 'gallery', NULL, 2, '1', NULL, '2021-01-17 08:35:24', NULL),
(59, 'prod_17012021_60044b2c2e2ab.jpg', 'media/images/product/prod_17012021_60044b2c2e2ab.jpg', 'media/images/product/thumb/prod_17012021_60044b2c2e2ac.webp', 'gallery', NULL, 2, '1', NULL, '2021-01-17 08:35:24', NULL),
(60, 'prod_17012021_60044b6fa5b2f.jpg', 'media/images/product/prod_17012021_60044b6fa5b2f.jpg', 'media/images/product/thumb/prod_17012021_60044b6fa5b39.webp', 'location_view', NULL, 2, '1', NULL, '2021-01-17 08:36:31', NULL),
(61, 'prod_17012021_60044b6fc46cb.jpg', 'media/images/product/prod_17012021_60044b6fc46cb.jpg', 'media/images/product/thumb/prod_17012021_60044b6fc46ce.webp', 'location_view', NULL, 2, '1', NULL, '2021-01-17 08:36:31', NULL),
(62, 'prod_17012021_60044b6fded5f.jpg', 'media/images/product/prod_17012021_60044b6fded5f.jpg', 'media/images/product/thumb/prod_17012021_60044b6fded61.webp', 'location_view', NULL, 2, '1', NULL, '2021-01-17 08:36:31', NULL),
(63, 'prod_19012021_6006a3cc201f6.jpg', 'media/images/product/prod_19012021_6006a3cc201f6.jpg', 'media/images/product/thumb/prod_19012021_6006a3cc201f9.webp', 'floors_plan', NULL, 5, '1', NULL, '2021-01-19 03:18:04', NULL),
(64, 'prod_19012021_6006a3cc49821.jpg', 'media/images/product/prod_19012021_6006a3cc49821.jpg', 'media/images/product/thumb/prod_19012021_6006a3cc49823.webp', 'floors_plan', NULL, 5, '1', NULL, '2021-01-19 03:18:04', NULL),
(65, 'prod_19012021_6006a3cc65e58.jpg', 'media/images/product/prod_19012021_6006a3cc65e58.jpg', 'media/images/product/thumb/prod_19012021_6006a3cc65e5a.webp', 'gallery', NULL, 5, '1', NULL, '2021-01-19 03:18:04', NULL),
(66, 'prod_19012021_6006a3cc81b37.jpg', 'media/images/product/prod_19012021_6006a3cc81b37.jpg', 'media/images/product/thumb/prod_19012021_6006a3cc81b3a.webp', 'gallery', NULL, 5, '1', NULL, '2021-01-19 03:18:04', NULL),
(67, 'prod_19012021_6006a3cc9c237.jpg', 'media/images/product/prod_19012021_6006a3cc9c237.jpg', 'media/images/product/thumb/prod_19012021_6006a3cc9c239.webp', 'gallery', NULL, 5, '1', NULL, '2021-01-19 03:18:04', NULL),
(68, 'prod_19012021_6006a3ccb5f7a.jpg', 'media/images/product/prod_19012021_6006a3ccb5f7a.jpg', 'media/images/product/thumb/prod_19012021_6006a3ccb5f7d.webp', 'gallery', NULL, 5, '1', NULL, '2021-01-19 03:18:04', NULL),
(69, 'prod_19012021_6006a3ccd4185.jpg', 'media/images/product/prod_19012021_6006a3ccd4185.jpg', 'media/images/product/thumb/prod_19012021_6006a3ccd4187.webp', 'location_view', NULL, 5, '1', NULL, '2021-01-19 03:18:05', NULL),
(70, 'prod_19012021_6006a3cd0cc22.jpg', 'media/images/product/prod_19012021_6006a3cd0cc22.jpg', 'media/images/product/thumb/prod_19012021_6006a3cd0cc24.webp', 'location_view', NULL, 5, '1', NULL, '2021-01-19 03:18:05', NULL),
(71, 'prod_19012021_6006a3cd3547e.jpg', 'media/images/product/prod_19012021_6006a3cd3547e.jpg', 'media/images/product/thumb/prod_19012021_6006a3cd35480.webp', 'location_view', NULL, 5, '1', NULL, '2021-01-19 03:18:05', NULL),
(72, 'prod_19012021_6006a4378ec0c.jpg', 'media/images/product/prod_19012021_6006a4378ec0c.jpg', 'media/images/product/thumb/prod_19012021_6006a4378ec14.webp', 'floors_plan', NULL, 4, '1', NULL, '2021-01-19 03:19:51', NULL),
(73, 'prod_19012021_6006a437bc158.jpg', 'media/images/product/prod_19012021_6006a437bc158.jpg', 'media/images/product/thumb/prod_19012021_6006a437bc15a.webp', 'floors_plan', NULL, 4, '1', NULL, '2021-01-19 03:19:51', NULL),
(74, 'prod_19012021_6006a437e46e0.jpg', 'media/images/product/prod_19012021_6006a437e46e0.jpg', 'media/images/product/thumb/prod_19012021_6006a437e46e3.webp', 'gallery', NULL, 4, '1', NULL, '2021-01-19 03:19:52', NULL),
(75, 'prod_19012021_6006a4380a550.jpg', 'media/images/product/prod_19012021_6006a4380a550.jpg', 'media/images/product/thumb/prod_19012021_6006a4380a552.webp', 'gallery', NULL, 4, '1', NULL, '2021-01-19 03:19:52', NULL),
(76, 'prod_19012021_6006a438239a1.jpg', 'media/images/product/prod_19012021_6006a438239a1.jpg', 'media/images/product/thumb/prod_19012021_6006a438239a3.webp', 'gallery', NULL, 4, '1', NULL, '2021-01-19 03:19:52', NULL),
(77, 'prod_19012021_6006a43844323.jpg', 'media/images/product/prod_19012021_6006a43844323.jpg', 'media/images/product/thumb/prod_19012021_6006a43844325.webp', 'gallery', NULL, 4, '1', NULL, '2021-01-19 03:19:52', NULL),
(78, 'prod_19012021_6006a43860938.jpg', 'media/images/product/prod_19012021_6006a43860938.jpg', 'media/images/product/thumb/prod_19012021_6006a4386093b.webp', 'location_view', NULL, 4, '1', NULL, '2021-01-19 03:19:52', NULL),
(79, 'prod_19012021_6006a4388d58b.jpg', 'media/images/product/prod_19012021_6006a4388d58b.jpg', 'media/images/product/thumb/prod_19012021_6006a4388d58d.webp', 'location_view', NULL, 4, '1', NULL, '2021-01-19 03:19:52', NULL),
(80, 'prod_19012021_6006a52701b0d.jpg', 'media/images/product/prod_19012021_6006a52701b0d.jpg', 'media/images/product/thumb/prod_19012021_6006a52701b0f.webp', 'gallery', NULL, 6, '1', NULL, '2021-01-19 03:23:51', NULL),
(81, 'prod_19012021_6006a52720213.jpg', 'media/images/product/prod_19012021_6006a52720213.jpg', 'media/images/product/thumb/prod_19012021_6006a52720216.webp', 'gallery', NULL, 6, '1', NULL, '2021-01-19 03:23:51', NULL),
(82, 'prod_19012021_6006a52739f8c.jpg', 'media/images/product/prod_19012021_6006a52739f8c.jpg', 'media/images/product/thumb/prod_19012021_6006a52739f8f.webp', 'gallery', NULL, 6, '1', NULL, '2021-01-19 03:23:51', NULL),
(83, 'prod_19012021_6006a52753e64.jpg', 'media/images/product/prod_19012021_6006a52753e64.jpg', 'media/images/product/thumb/prod_19012021_6006a52753e67.webp', 'gallery', NULL, 6, '1', NULL, '2021-01-19 03:23:51', NULL),
(84, 'prod_19012021_6006a527705f0.jpg', 'media/images/product/prod_19012021_6006a527705f0.jpg', 'media/images/product/thumb/prod_19012021_6006a527705f3.webp', 'location_view', NULL, 6, '1', NULL, '2021-01-19 03:23:51', NULL),
(85, 'prod_19012021_6006a52797a28.jpg', 'media/images/product/prod_19012021_6006a52797a28.jpg', 'media/images/product/thumb/prod_19012021_6006a52797a2b.webp', 'location_view', NULL, 6, '1', NULL, '2021-01-19 03:23:51', NULL),
(86, 'prod_19012021_6006a58593e94.jpg', 'media/images/product/prod_19012021_6006a58593e94.jpg', 'media/images/product/thumb/prod_19012021_6006a58593e96.webp', 'gallery', NULL, 7, '1', NULL, '2021-01-19 03:25:25', NULL),
(87, 'prod_19012021_6006a585ae090.jpg', 'media/images/product/prod_19012021_6006a585ae090.jpg', 'media/images/product/thumb/prod_19012021_6006a585ae092.webp', 'gallery', NULL, 7, '1', NULL, '2021-01-19 03:25:25', NULL),
(88, 'prod_19012021_6006a585c8f1b.jpg', 'media/images/product/prod_19012021_6006a585c8f1b.jpg', 'media/images/product/thumb/prod_19012021_6006a585c8f1e.webp', 'gallery', NULL, 7, '1', NULL, '2021-01-19 03:25:25', NULL),
(89, 'prod_19012021_6006a585e37fe.jpg', 'media/images/product/prod_19012021_6006a585e37fe.jpg', 'media/images/product/thumb/prod_19012021_6006a585e3800.webp', 'location_view', NULL, 7, '1', NULL, '2021-01-19 03:25:26', NULL),
(90, 'prod_19012021_6006a5861b40a.jpg', 'media/images/product/prod_19012021_6006a5861b40a.jpg', 'media/images/product/thumb/prod_19012021_6006a5861b40d.webp', 'location_view', NULL, 7, '1', NULL, '2021-01-19 03:25:26', NULL),
(91, 'prod_19012021_6006a5dea0d1c.jpg', 'media/images/product/prod_19012021_6006a5dea0d1c.jpg', 'media/images/product/thumb/prod_19012021_6006a5dea0d23.webp', 'floors_plan', NULL, 8, '1', NULL, '2021-01-19 03:26:54', NULL),
(92, 'prod_19012021_6006a5decafbf.jpg', 'media/images/product/prod_19012021_6006a5decafbf.jpg', 'media/images/product/thumb/prod_19012021_6006a5decafc1.webp', 'floors_plan', NULL, 8, '1', NULL, '2021-01-19 03:26:54', NULL),
(93, 'prod_19012021_6006a5df00d45.jpg', 'media/images/product/prod_19012021_6006a5df00d45.jpg', 'media/images/product/thumb/prod_19012021_6006a5df00d47.webp', 'gallery', NULL, 8, '1', NULL, '2021-01-19 03:26:55', NULL),
(94, 'prod_19012021_6006a5df198be.jpg', 'media/images/product/prod_19012021_6006a5df198be.jpg', 'media/images/product/thumb/prod_19012021_6006a5df198c0.webp', 'gallery', NULL, 8, '1', NULL, '2021-01-19 03:26:55', NULL),
(95, 'prod_19012021_6006a5df2aa90.jpg', 'media/images/product/prod_19012021_6006a5df2aa90.jpg', 'media/images/product/thumb/prod_19012021_6006a5df2aa92.webp', 'gallery', NULL, 8, '1', NULL, '2021-01-19 03:26:55', NULL),
(96, 'prod_19012021_6006a5df43a15.jpg', 'media/images/product/prod_19012021_6006a5df43a15.jpg', 'media/images/product/thumb/prod_19012021_6006a5df43a17.webp', 'location_view', NULL, 8, '1', NULL, '2021-01-19 03:26:55', NULL),
(97, 'prod_19012021_6006a5df65f36.jpg', 'media/images/product/prod_19012021_6006a5df65f36.jpg', 'media/images/product/thumb/prod_19012021_6006a5df65f39.webp', 'location_view', NULL, 8, '1', NULL, '2021-01-19 03:26:55', NULL),
(98, 'prod_19012021_6006a615dfda7.jpg', 'media/images/product/prod_19012021_6006a615dfda7.jpg', 'media/images/product/thumb/prod_19012021_6006a615dfda9.webp', 'gallery', NULL, 9, '1', NULL, '2021-01-19 03:27:50', NULL),
(99, 'prod_19012021_6006a6160fefe.jpg', 'media/images/product/prod_19012021_6006a6160fefe.jpg', 'media/images/product/thumb/prod_19012021_6006a6160ff00.webp', 'gallery', NULL, 9, '1', NULL, '2021-01-19 03:27:50', NULL),
(100, 'prod_19012021_6006a61632264.jpg', 'media/images/product/prod_19012021_6006a61632264.jpg', 'media/images/product/thumb/prod_19012021_6006a61632267.webp', 'gallery', NULL, 9, '1', NULL, '2021-01-19 03:27:50', NULL),
(101, 'prod_19012021_6006a6164c5e8.jpg', 'media/images/product/prod_19012021_6006a6164c5e8.jpg', 'media/images/product/thumb/prod_19012021_6006a6164c5ec.webp', 'location_view', NULL, 9, '1', NULL, '2021-01-19 03:27:50', NULL),
(102, 'prod_19012021_6006a61678ec7.jpg', 'media/images/product/prod_19012021_6006a61678ec7.jpg', 'media/images/product/thumb/prod_19012021_6006a61678ec9.webp', 'location_view', NULL, 9, '1', NULL, '2021-01-19 03:27:50', NULL),
(103, 'prod_19012021_6006a6418c39b.jpg', 'media/images/product/prod_19012021_6006a6418c39b.jpg', 'media/images/product/thumb/prod_19012021_6006a6418c39c.webp', 'floors_plan', NULL, 10, '1', NULL, '2021-01-19 03:28:33', NULL),
(104, 'prod_19012021_6006a68fb0ccd.jpg', 'media/images/product/prod_19012021_6006a68fb0ccd.jpg', 'media/images/product/thumb/prod_19012021_6006a68fb0ccf.webp', 'gallery', NULL, 10, '1', NULL, '2021-01-19 03:29:51', NULL),
(105, 'prod_19012021_6006a68fd0ee4.jpg', 'media/images/product/prod_19012021_6006a68fd0ee4.jpg', 'media/images/product/thumb/prod_19012021_6006a68fd0ee6.webp', 'gallery', NULL, 10, '1', NULL, '2021-01-19 03:29:51', NULL),
(106, 'prod_19012021_6006a68fe9bc3.jpg', 'media/images/product/prod_19012021_6006a68fe9bc3.jpg', 'media/images/product/thumb/prod_19012021_6006a68fe9bc5.webp', 'gallery', NULL, 10, '1', NULL, '2021-01-19 03:29:52', NULL),
(107, 'prod_19012021_6006a69028c20.jpg', 'media/images/product/prod_19012021_6006a69028c20.jpg', 'media/images/product/thumb/prod_19012021_6006a69028c22.webp', 'gallery', NULL, 10, '1', NULL, '2021-01-19 03:29:52', NULL),
(108, 'prod_19012021_6006a6904514d.jpg', 'media/images/product/prod_19012021_6006a6904514d.jpg', 'media/images/product/thumb/prod_19012021_6006a6904514f.webp', 'location_view', NULL, 10, '1', NULL, '2021-01-19 03:29:52', NULL),
(109, 'prod_19012021_6006a69071b2e.jpg', 'media/images/product/prod_19012021_6006a69071b2e.jpg', 'media/images/product/thumb/prod_19012021_6006a69071b30.webp', 'location_view', NULL, 10, '1', NULL, '2021-01-19 03:29:52', NULL),
(110, 'prod_19012021_6006a6efbf2fa.jpg', 'media/images/product/prod_19012021_6006a6efbf2fa.jpg', 'media/images/product/thumb/prod_19012021_6006a6efbf2fc.webp', 'feature_image', NULL, 31, '1', NULL, '2021-01-19 03:31:27', NULL),
(111, 'prod_19012021_6006a6efef870.jpg', 'media/images/product/prod_19012021_6006a6efef870.jpg', 'media/images/product/thumb/prod_19012021_6006a6efef873.webp', 'floors_plan', NULL, 31, '1', NULL, '2021-01-19 03:31:28', NULL),
(112, 'prod_19012021_6006a6f01cae1.jpg', 'media/images/product/prod_19012021_6006a6f01cae1.jpg', 'media/images/product/thumb/prod_19012021_6006a6f01cae3.webp', 'floors_plan', NULL, 31, '1', NULL, '2021-01-19 03:31:28', NULL),
(113, 'prod_19012021_6006a6f040411.jpg', 'media/images/product/prod_19012021_6006a6f040411.jpg', 'media/images/product/thumb/prod_19012021_6006a6f040413.webp', 'gallery', NULL, 31, '1', NULL, '2021-01-19 03:31:28', NULL),
(114, 'prod_19012021_6006a6f0624e9.jpg', 'media/images/product/prod_19012021_6006a6f0624e9.jpg', 'media/images/product/thumb/prod_19012021_6006a6f0624eb.webp', 'gallery', NULL, 31, '1', NULL, '2021-01-19 03:31:28', NULL),
(115, 'prod_19012021_6006a6f07bbff.jpg', 'media/images/product/prod_19012021_6006a6f07bbff.jpg', 'media/images/product/thumb/prod_19012021_6006a6f07bc01.webp', 'gallery', NULL, 31, '1', NULL, '2021-01-19 03:31:28', NULL),
(116, 'prod_19012021_6006a6f09aece.jpg', 'media/images/product/prod_19012021_6006a6f09aece.jpg', 'media/images/product/thumb/prod_19012021_6006a6f09aed0.webp', 'gallery', NULL, 31, '1', NULL, '2021-01-19 03:31:28', NULL),
(117, 'prod_19012021_6006a6f0b26cf.jpg', 'media/images/product/prod_19012021_6006a6f0b26cf.jpg', 'media/images/product/thumb/prod_19012021_6006a6f0b26d1.webp', 'location_view', NULL, 31, '1', NULL, '2021-01-19 03:31:28', NULL),
(118, 'prod_19012021_6006a6f0cc034.jpg', 'media/images/product/prod_19012021_6006a6f0cc034.jpg', 'media/images/product/thumb/prod_19012021_6006a6f0cc037.webp', 'location_view', NULL, 31, '1', NULL, '2021-01-19 03:31:28', NULL),
(119, 'prod_19012021_6006a741e54fd.jpg', 'media/images/product/prod_19012021_6006a741e54fd.jpg', 'media/images/product/thumb/prod_19012021_6006a741e5504.webp', 'feature_image', NULL, 32, '1', NULL, '2021-01-19 03:32:50', NULL),
(120, 'prod_19012021_6006a74206545.jpg', 'media/images/product/prod_19012021_6006a74206545.jpg', 'media/images/product/thumb/prod_19012021_6006a74206547.webp', 'floors_plan', NULL, 32, '1', NULL, '2021-01-19 03:32:50', NULL),
(121, 'prod_19012021_6006a742214cf.jpg', 'media/images/product/prod_19012021_6006a742214cf.jpg', 'media/images/product/thumb/prod_19012021_6006a742214d1.webp', 'floors_plan', NULL, 32, '1', NULL, '2021-01-19 03:32:50', NULL),
(122, 'prod_19012021_6006a7423f4c4.jpg', 'media/images/product/prod_19012021_6006a7423f4c4.jpg', 'media/images/product/thumb/prod_19012021_6006a7423f4c6.webp', 'gallery', NULL, 32, '1', NULL, '2021-01-19 03:32:50', NULL),
(123, 'prod_19012021_6006a7425a5df.jpg', 'media/images/product/prod_19012021_6006a7425a5df.jpg', 'media/images/product/thumb/prod_19012021_6006a7425a5e3.webp', 'gallery', NULL, 32, '1', NULL, '2021-01-19 03:32:50', NULL),
(124, 'prod_19012021_6006a74272152.jpg', 'media/images/product/prod_19012021_6006a74272152.jpg', 'media/images/product/thumb/prod_19012021_6006a74272154.webp', 'gallery', NULL, 32, '1', NULL, '2021-01-19 03:32:50', NULL),
(125, 'prod_19012021_6006a7428dd4e.jpg', 'media/images/product/prod_19012021_6006a7428dd4e.jpg', 'media/images/product/thumb/prod_19012021_6006a7428dd50.webp', 'gallery', NULL, 32, '1', NULL, '2021-01-19 03:32:50', NULL),
(126, 'prod_19012021_6006a742abdf7.jpg', 'media/images/product/prod_19012021_6006a742abdf7.jpg', 'media/images/product/thumb/prod_19012021_6006a742abdfa.webp', 'location_view', NULL, 32, '1', NULL, '2021-01-19 03:32:50', NULL),
(127, 'prod_19012021_6006a742dac4d.jpg', 'media/images/product/prod_19012021_6006a742dac4d.jpg', 'media/images/product/thumb/prod_19012021_6006a742dac50.webp', 'location_view', NULL, 32, '1', NULL, '2021-01-19 03:32:51', NULL),
(128, 'prod_15022021_602a017ca7215.jpg', 'media/images/product/prod_15022021_602a017ca7215.jpg', 'media/images/product/thumb/prod_15022021_602a017ca721c.webp', 'feature_image', NULL, 40, '1', NULL, '2021-02-15 11:07:08', NULL),
(129, 'prod_15022021_602a017ced196.jpg', 'media/images/product/prod_15022021_602a017ced196.jpg', 'media/images/product/thumb/prod_15022021_602a017ced198.webp', 'floors_plan', NULL, 40, '1', NULL, '2021-02-15 11:07:09', NULL),
(130, 'prod_15022021_602a017d126ec.jpg', 'media/images/product/prod_15022021_602a017d126ec.jpg', 'media/images/product/thumb/prod_15022021_602a017d126ef.webp', 'floors_plan', NULL, 40, '1', NULL, '2021-02-15 11:07:09', NULL),
(131, 'prod_15022021_602a017d2d207.jpg', 'media/images/product/prod_15022021_602a017d2d207.jpg', 'media/images/product/thumb/prod_15022021_602a017d2d209.webp', 'floors_plan', NULL, 40, '1', NULL, '2021-02-15 11:07:09', NULL),
(132, 'prod_15022021_602a017d4e7ab.jpg', 'media/images/product/prod_15022021_602a017d4e7ab.jpg', 'media/images/product/thumb/prod_15022021_602a017d4e7ad.webp', 'gallery', NULL, 40, '1', NULL, '2021-02-15 11:07:09', NULL),
(133, 'prod_15022021_602a017d6bed8.jpg', 'media/images/product/prod_15022021_602a017d6bed8.jpg', 'media/images/product/thumb/prod_15022021_602a017d6beda.webp', 'gallery', NULL, 40, '1', NULL, '2021-02-15 11:07:09', NULL),
(134, 'prod_15022021_602a017d84dfa.jpg', 'media/images/product/prod_15022021_602a017d84dfa.jpg', 'media/images/product/thumb/prod_15022021_602a017d84dfc.webp', 'gallery', NULL, 40, '1', NULL, '2021-02-15 11:07:09', NULL),
(135, 'prod_15022021_602a017da0697.jpg', 'media/images/product/prod_15022021_602a017da0697.jpg', 'media/images/product/thumb/prod_15022021_602a017da069a.webp', 'location_view', NULL, 40, '1', NULL, '2021-02-15 11:07:09', NULL),
(136, 'prod_15022021_602a017dbb079.jpg', 'media/images/product/prod_15022021_602a017dbb079.jpg', 'media/images/product/thumb/prod_15022021_602a017dbb07c.webp', 'location_view', NULL, 40, '1', NULL, '2021-02-15 11:07:09', NULL),
(137, 'prod_15022021_602a017dd4b1c.jpg', 'media/images/product/prod_15022021_602a017dd4b1c.jpg', 'media/images/product/thumb/prod_15022021_602a017dd4b1e.webp', 'location_view', NULL, 40, '1', NULL, '2021-02-15 11:07:09', NULL),
(138, 'prod_03032021_603f17063f860.jpg', 'media/images/product/prod_03032021_603f17063f860.jpg', 'media/images/product/thumb/prod_03032021_603f17063f863.webp', 'feature_image', NULL, 6, '1', NULL, '2021-03-03 10:56:38', NULL),
(139, 'prod_25052021_60ace5376010f.png', 'media/images/product/prod_25052021_60ace5376010f.png', 'media/images/product/thumb/prod_25052021_60ace53760114.webp', 'feature_image', NULL, 41, '16', NULL, '2021-05-25 05:53:27', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `crm_lead_master`
--
CREATE TABLE `crm_lead_master` (
`pk_id` int NOT NULL,
`name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
`source_id` int DEFAULT NULL,
`username` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`country` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`address` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`profession` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`lead_priority_id` int DEFAULT NULL,
`status` tinyint(1) DEFAULT NULL,
`website` varchar(155) COLLATE utf8mb4_general_ci DEFAULT NULL,
`description` text COLLATE utf8mb4_general_ci,
`created_at` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`updated_by` int DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`lead_status_id` int NOT NULL DEFAULT '1',
`phone1` bigint DEFAULT NULL,
`phone2` bigint DEFAULT NULL,
`phone3` bigint DEFAULT NULL,
`business_type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`company_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `crm_lead_master`
--
INSERT INTO `crm_lead_master` (`pk_id`, `name`, `source_id`, `username`, `email`, `country`, `address`, `profession`, `lead_priority_id`, `status`, `website`, `description`, `created_at`, `created_by`, `updated_by`, `updated_at`, `lead_status_id`, `phone1`, `phone2`, `phone3`, `business_type`, `company_name`) VALUES
(1, 'Zen El-Kabbout / Zentune', 1, NULL, 'zentune@outlook.com', '13', 'unit 3 1 Adept lane, Bankstown, New South Wales, 2200', 'Car Tuner', 1, 1, NULL, '', '2022-10-10 10:48:48', NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(2, 'Spencer Suggs / Letsconnect', 1, NULL, 'spencer@letsconnect.site', '226', NULL, 'IT Expert', 1, 1, NULL, '', '2022-10-10 10:54:16', NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(3, 'Jon Priddle / Barrrter', 1, NULL, 'japers@protonmail.com', '225', 'Jon Priddle 21 Fortescue St NA, Norton St Philip, BA2 7PE Jon Priddle 21 Fortescue St NA, Norton St Philip, BA2 7PE United Kingdom', 'Digital Currency Expert', 1, 1, NULL, '', '2022-10-10 10:58:35', NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(4, 'Eslam Galhoum / Masterrit', 1, NULL, NULL, '224', NULL, 'MLM Expert', 1, 1, NULL, '', '2022-10-10 11:02:25', NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(5, 'Enjoy City Tours', 3, NULL, NULL, '105', 'Via Carlo Emanuele I, 37, 00185 Rome, Italy', 'Rental Expert', 1, 1, 'https://enjoycitytours.com', '', '2022-10-10 11:06:53', NULL, NULL, '2024-06-26 11:08:48', 3, NULL, NULL, NULL, NULL, 'Enjoy City Tours'),
(6, 'Farhan / Serviceprovider', 1, NULL, NULL, '224', NULL, 'IT Expert', 1, 1, NULL, '', '2022-10-10 11:19:12', NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(7, 'Sam Baime / Carebah', 1, NULL, 'sambaime3@gmail.com', '226', '125 NW 13th Street Suite B3 Boca Raton, FL 33432 USA L21000133577', 'Ecommerce Business', 1, 1, NULL, '', '2022-10-10 11:23:37', NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(8, 'Amin Mohamed / Dhereye', 1, NULL, 'amin.inbox@outlook.com', '196', 'Hargeisa Somaliland', 'Ecommerce Business', 1, 1, NULL, '', '2022-10-10 11:26:06', NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(9, 'Nikita / Dayagim', 1, NULL, NULL, '104', NULL, 'Classified Website Owner', 1, 1, NULL, '', '2022-10-10 11:30:18', NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(10, 'Ayman / Bikeplus', 1, NULL, 'aymanokal997@gmail.com', '218', NULL, 'IT Expert (Do Local Marketing)', 2, 1, NULL, '', '2022-10-10 11:33:52', NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(11, 'tutawasi', 1, NULL, NULL, '107', NULL, 'marketer', 1, 1, NULL, '', '2022-10-12 15:29:21', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(12, 'tutawasi', 1, NULL, NULL, '107', NULL, 'marketer', 1, 1, NULL, '', '2022-10-12 15:29:21', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(13, 'Mohammad Alkhaled / App.modesign-trier.de', 1, NULL, 'alkhaled@uni-trier.de', '80', NULL, 'IT Expert', 2, 1, 'App.modesign-trier.de', '', '2022-10-12 16:28:28', NULL, NULL, '2022-10-15 12:26:27', 1, NULL, NULL, NULL, NULL, NULL),
(14, 'Bijoy / Artwork Proof', 1, NULL, NULL, '226', NULL, 'IT Expert', 1, 1, NULL, '', '2022-10-12 21:23:29', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(15, 'Edward / Rreeng', 1, NULL, 'espedward9999@gmail.com', '129', NULL, 'Ecommerce Business', 1, 1, NULL, '', '2022-10-12 21:35:10', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(16, 'Gogoads', 1, NULL, NULL, '200', NULL, 'IT Expert', 2, 1, NULL, '', '2022-10-12 21:41:34', NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(17, 'Abigailestanisl', 1, NULL, NULL, '1', NULL, NULL, 2, 1, NULL, '', '2022-10-13 11:49:52', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(18, 'Sharnese Jones', 1, 'Sharnesejone690', 'vendetta150@gmail.com', '226', NULL, NULL, 1, 1, NULL, '', '2022-10-13 11:52:09', NULL, NULL, '2023-04-30 10:10:44', 1, 12152724625, NULL, NULL, NULL, NULL),
(19, 'Rajikai', 1, NULL, NULL, '1', NULL, NULL, 2, 1, NULL, '', '2022-10-13 12:01:06', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(20, 'George Mwenda', 1, NULL, 'iquinnetworkskenya@gmail.com', '1', NULL, NULL, 1, 1, NULL, '', '2022-10-13 12:04:31', NULL, NULL, '2022-10-18 20:30:50', 1, 254718438984, NULL, NULL, NULL, NULL),
(21, 'Abu Yousuf / Bangalio', 3, NULL, 'tuhinbdc92@gmail.com', '18', 'dhaka', 'Accountant', 1, 1, 'https://bangalio.com', '', '2022-10-13 14:18:36', NULL, NULL, '2022-10-15 11:09:36', 3, 8801675757991, 8801675757991, 8801675757991, 'Ecommerce', NULL),
(22, 'Mac Varsani / secretraffledraw', 1, NULL, NULL, '211', NULL, 'Local Marketing', 1, 1, NULL, '', '2022-10-15 12:30:52', NULL, NULL, NULL, 1, 66824155004, NULL, NULL, 'Local Marketing', NULL),
(23, 'Mohammad Junaid / olsify', 1, NULL, 'webmedia.pk@gmail.com', '162', NULL, 'Digital Marketer', 1, 1, 'https://reviewonten.com/', '', '2022-10-15 12:33:14', NULL, NULL, NULL, 3, 923084475004, NULL, NULL, 'Local Marketing', NULL),
(24, 'Tommy/egreen.corpstation-testing.com', 1, NULL, NULL, '224', NULL, 'IT Expert', 1, 1, 'http://egreen.corpstation-testing.com/', '', '2022-10-17 12:21:37', NULL, NULL, '2022-10-17 12:26:08', 3, 971503616517, NULL, NULL, 'classified', NULL),
(25, 'Tutawasi / Grailed', 1, NULL, NULL, '107', NULL, 'IT Expert', 1, 1, NULL, '', '2022-10-17 15:39:56', NULL, NULL, NULL, 1, NULL, NULL, NULL, 'He do Local Marketing', NULL),
(26, 'Daniel Elliot / Appturemarket', 1, NULL, NULL, '226', NULL, 'IT Expert', 1, 1, NULL, '', '2022-10-18 19:21:24', NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, NULL),
(27, 'test', 1, NULL, NULL, '1', NULL, NULL, 1, 1, NULL, '', '2022-10-19 09:50:13', NULL, NULL, '2022-10-19 09:50:27', 1, NULL, NULL, NULL, NULL, NULL),
(28, 'shompa', 3, NULL, NULL, '1', NULL, NULL, 2, 1, NULL, '', '2022-10-20 18:36:15', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(29, 'Sam Baime', 1, NULL, 'sambaime3@gmail.com', '225', NULL, 'Ecommerce Business', 1, 1, NULL, '', '2022-10-22 10:45:35', NULL, NULL, NULL, 3, 15612015709, NULL, NULL, NULL, NULL),
(30, 'Thai Nguyen / Exchangeanything', 1, NULL, 'txn7368@gmail.com', '226', NULL, 'Classified', 1, 1, 'http://exchangeanything.com', '', '2022-10-25 10:21:12', NULL, NULL, NULL, 1, 19492642165, NULL, NULL, 'Classified', NULL),
(31, 'Johan / swedexo.com', 1, NULL, 'jfastberg@gmail.com', '205', NULL, 'Business with Animals', 2, 1, 'swedexo.com', '', '2022-10-25 20:20:07', NULL, NULL, NULL, 3, 46707292621, NULL, NULL, 'individual client', NULL),
(32, 'Frag VH / Koreanmtl', 1, NULL, 'Fragvhmtl@proton.me', '226', '3024 N Powers Dr, Orlando, FL 32818 United States', 'blogger', 1, 1, 'https://www.kmtl.online/', '', '2022-10-27 14:47:34', NULL, NULL, '2022-10-27 14:48:30', 1, 14075029259, NULL, NULL, 'blogger', NULL),
(33, 'Yousof / bdhousing', 3, NULL, NULL, '1', NULL, 'real estate', 1, 1, 'https://www.bdhousing.com/', '', '2022-11-06 09:50:35', NULL, NULL, NULL, 3, 8801730583483, NULL, NULL, 'real estate', NULL),
(34, 'Zayedmm / Abubazar', 1, NULL, NULL, '1', NULL, 'IT', 2, 1, NULL, '', '2022-11-08 11:42:49', NULL, NULL, NULL, 1, 971554867836, NULL, NULL, 'IT', NULL),
(35, 'Martin Cudzilo /ar-check.com', 2, NULL, 'archeck97@gmail.com', '80', NULL, 'IT', 2, 1, 'https://ar-check.com/', '', '2022-11-13 10:05:40', NULL, NULL, NULL, 1, 496994597058, NULL, NULL, 'AI', NULL),
(36, 'queenieyinn/ carema.app', 1, NULL, NULL, '129', NULL, 'it', 2, 1, 'https://carema.app', '', '2022-11-15 14:32:19', NULL, NULL, NULL, 1, NULL, NULL, NULL, 'it', NULL),
(37, 'mshale/mshale.com', 1, NULL, NULL, '226', NULL, 'News/Classifieds', 1, 1, 'mshale.com', '', '2022-11-15 14:56:39', NULL, NULL, NULL, 1, NULL, NULL, NULL, 'classified', NULL),
(38, 'ayoub aghil / raqia group', 1, NULL, 'a.aghil@hotmail.com', '132', NULL, 'recycling company owner', 2, 1, 'https://raqiagroup.com/', '', '2022-11-22 15:16:38', NULL, NULL, NULL, 1, 35699578816, NULL, NULL, 'recycling', NULL),
(39, 'Frank / 405hub.com', 1, NULL, 'arizonexpress@gmail.com', '226', NULL, 'IT', 1, 1, NULL, '', '2022-11-26 12:24:36', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(40, 'Elliot Agius', 1, 'seasidehotelman', 'elliot@seasidehotelmanagement.com', '230', 'Port Vila, Vanuatu', 'Business Man', 1, 1, 'http://everisamting.com/', '', '2022-11-27 19:25:26', NULL, NULL, '2023-12-17 11:55:11', 1, 6785523694, NULL, NULL, 'Classified', 'Everisamting'),
(41, 'Ayokunle', 2, NULL, 'ayoquadri@yahoo.com', '156', NULL, 'lawyer', 2, 1, 'http://lawcompanion.net', '', '2022-12-01 14:47:43', NULL, NULL, '2022-12-01 14:49:03', 1, NULL, NULL, NULL, 'law', NULL),
(42, 'Richard Mutenieks', 1, NULL, 'mucenieksricards@gmail.com', '1', NULL, 'Ecommerce', 1, 1, '2life.lv', '', '2022-12-06 20:15:15', NULL, NULL, NULL, 1, 37120389517, NULL, NULL, 'Ecommerce', NULL),
(43, 'Joe Renter', 1, 'joerenter', 'Jrenter@ymail.com', '226', 'USA', NULL, 2, 1, 'https://mtgpro.me', '', '2022-12-12 09:56:58', NULL, NULL, '2023-12-19 19:32:47', 1, 15162973389, NULL, NULL, 'vcard', 'mtgpro'),
(44, 'developerx_x', 1, NULL, NULL, '226', NULL, 'Classified', 2, 1, NULL, '', '2022-12-19 15:30:09', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(45, 'tag-collection.com', 1, 'lydiekayitesi', NULL, '110', NULL, NULL, 2, 1, 'tag-collection.com', '', '2022-12-26 14:40:06', NULL, NULL, NULL, 1, NULL, NULL, NULL, 'classifieds', NULL),
(46, 'Ayman Hazib', 1, 'Aymanhaz', 'hazib2013@gmail.com', '1', 'Ayman Hazib 7642 - Al Farouk Dist. Makkah, Jeddah, 22349 Saudi Arabia', 'Property type business', 2, 1, 'engez.online', '', '2023-01-02 11:17:13', NULL, NULL, NULL, 1, 966599910996, NULL, NULL, NULL, NULL),
(47, 'Rudol', 1, 'rudolfalhelou', NULL, '1', NULL, 'online business', 2, 1, 'Posterworks.nl', '', '2023-01-08 12:28:28', NULL, NULL, NULL, 1, 31640832549, NULL, NULL, NULL, NULL),
(48, 'Sherman Bowen', 1, 'shermanbowen', 'showoffgrafixs@gmail.com', '226', 'USA', 'Vcard Website', 1, 1, 'https://digitalbizads.com', '', '2023-01-22 11:14:28', NULL, NULL, '2023-12-19 19:48:12', 1, 16625491457, NULL, NULL, 'Vcard', 'digitalbizads'),
(49, 'tapin', 1, 'xarezzxarezz', NULL, '1', NULL, NULL, 1, 1, NULL, '', '2023-01-22 11:49:46', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(50, 'stevew', 1, 'stevew1212', NULL, '226', '305 River green Ave, Canton Ga 30114', NULL, 1, 1, 'https://franchisesavailablenow.com', '', '2023-01-26 09:27:41', NULL, NULL, '2024-02-06 17:05:22', 1, NULL, NULL, NULL, NULL, NULL),
(51, 'Sam Prom', 1, 'spromlee', 'unclebotty@gmail.com', '226', 'Sam Prom PO Box 7445 CA, Santa Rosa, 95407 United States', NULL, 1, 1, NULL, '', '2023-01-29 11:35:19', NULL, NULL, '2023-01-29 12:20:06', 1, 17074908468, NULL, NULL, NULL, NULL),
(52, 'bzharomer330', 1, 'bzharomer330', NULL, '1', NULL, NULL, 1, 1, NULL, '', '2023-02-01 09:58:55', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(53, 'John', 1, 'johnleahyiii', 'havaseller@gmail.com', '226', NULL, NULL, 1, 1, NULL, '', '2023-02-09 11:46:33', NULL, NULL, '2023-02-28 10:02:29', 1, 9498386757, NULL, NULL, NULL, NULL),
(54, 'universe444', 1, 'universe444', NULL, '1', NULL, NULL, 2, 1, NULL, '', '2023-02-13 11:18:21', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(55, 'schon625/dubmediacreations.com', 1, 'schon625', 'rs@dubmediacreations.com', '1', NULL, NULL, 2, 1, 'https://dubmediacreations.com', '', '2023-02-16 15:18:29', NULL, NULL, '2023-02-20 12:51:34', 1, 4154975397, NULL, NULL, NULL, NULL),
(56, 'Bonny Kayiwa', 1, 'alikahsocial', 'ekayzone77@gmail.com', '197', '71 Woburn Avenue Benoni Town, Gauteng Province, S.Africa', 'Classified Business Owner', 2, 1, 'ekayzone.com', '', '2023-02-19 09:09:46', NULL, NULL, '2023-12-17 19:56:22', 1, 27733219261, NULL, NULL, NULL, 'ekayzone.co.za'),
(57, 'Jay/panhandlehub.org', 1, 'smart_guy222', 'research@mmmuagency.com', '226', NULL, NULL, 2, 1, 'panhandlehub.org', '', '2023-02-23 13:57:46', NULL, NULL, NULL, 1, 16467457526, NULL, NULL, NULL, NULL),
(58, 'Samiul Vai', 3, 'samiul', NULL, '1', NULL, NULL, 2, 1, NULL, '', '2023-03-12 10:05:57', NULL, NULL, NULL, 1, 8801718262530, NULL, NULL, NULL, NULL),
(59, 'safestore.tech', 1, 'shikaafi', 'dodnicki@gmail.com', '81', NULL, NULL, 2, 1, 'safestore.tech', '', '2023-04-02 10:49:17', NULL, NULL, NULL, 1, NULL, NULL, NULL, 'classified', NULL),
(60, 'regenchain.org', 1, 'Emirkaraisik', NULL, '1', NULL, NULL, 2, 1, NULL, '', '2023-04-03 15:30:33', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(61, 'Majdalbahri', 1, 'Majdalbahri', NULL, '1', NULL, NULL, 2, 1, NULL, '', '2023-04-15 11:42:10', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(62, 'dannbekk', 1, 'dannbekk', NULL, '1', NULL, NULL, 2, 1, NULL, '', '2023-04-26 16:18:17', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(63, 'mweror', 1, 'mweror', NULL, '1', NULL, NULL, 2, 1, NULL, '', '2023-07-05 13:02:02', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(64, 'Ruwa Mwero', 1, 'mweror', NULL, '110', NULL, NULL, 2, 1, NULL, '', '2023-07-05 13:03:01', NULL, NULL, NULL, 1, 254707844470, NULL, NULL, NULL, NULL),
(65, 'siddharth chowdhury', 1, 'tagways', 'tagwaysindia@gmail.com', '1', 'India', NULL, 2, 1, NULL, '', '2023-08-03 11:47:46', NULL, NULL, NULL, 1, 918806660466, NULL, NULL, NULL, NULL),
(66, 'Sam Black', 1, 'samblack9', 'samblack@easeh.co.uk', '225', 'Easeh LTD 10 Spring Road NA, Altrincham, WA14 2UQ United Kingdom', NULL, 1, 1, NULL, '', '2023-08-08 14:36:46', NULL, NULL, NULL, 1, 447940904206, NULL, NULL, NULL, NULL),
(67, 'mapawan.com', 1, 'min_ba', NULL, '226', NULL, NULL, 2, 1, NULL, '', '2023-08-08 18:32:48', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(68, 'Nuruddin', 3, 'Nuruddin', 'nuruddin@kinetictechnologysolutions.de', '80', NULL, NULL, 2, 1, 'kinetictechnologysolutions.de', '', '2023-09-07 19:37:00', NULL, NULL, NULL, 1, 491624303052, NULL, NULL, NULL, NULL),
(69, 'Queston cooper/BubbyTV', 1, 'questwave', 'info.queston@gmail.com', '1', '1134 sw goodman ave, Port Saint Lucie, Florida, United States 34953', NULL, 2, 1, 'https://bubbytv.com/', NULL, '2023-10-02 12:50:17', NULL, NULL, NULL, 1, 17726720669, NULL, NULL, NULL, NULL),
(70, 'milesweb', 3, 'milesweb', 'webdevsforu@gmail.com', '1', NULL, '123@Arobil@456', 3, 1, 'https://my.milesweb.com/', NULL, '2023-10-02 18:40:22', NULL, NULL, '2023-10-02 18:41:09', 1, NULL, NULL, NULL, NULL, NULL),
(71, 'richdreams', 1, 'richdreams247', NULL, '226', NULL, NULL, 2, 1, NULL, NULL, '2023-10-25 13:42:44', NULL, NULL, '2023-12-20 11:37:14', 1, NULL, NULL, NULL, NULL, 'Linksavvy'),
(72, 'Juhasz/exotap', 1, 'Juhasz_tamas', NULL, '1', NULL, NULL, 2, 1, NULL, NULL, '2023-11-22 15:43:37', NULL, NULL, '2023-11-22 15:44:06', 1, NULL, NULL, NULL, NULL, NULL),
(73, 'Keilaaishere/linksmartt.com', 1, 'Keilaaishere', NULL, '226', NULL, NULL, 2, 1, NULL, NULL, '2023-11-25 17:10:41', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(74, 'Bisshojit/curlware', 3, 'bisshojit', NULL, '1', 'Farmgate, Dhaka Bangladesh', NULL, 2, 1, NULL, NULL, '2023-11-30 17:14:28', NULL, NULL, '2024-02-08 19:54:17', 1, NULL, NULL, NULL, NULL, NULL),
(75, 'Fahad', 1, 'fahadalmaskari', 'fahad.almaskari@outlook.com', '171', 'Poland', NULL, 2, 1, NULL, NULL, '2023-12-12 11:43:57', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(76, 'Gazi Sadek', 3, NULL, 'gazisadek84@gmail.com', '18', 'Dhaka, Bangladesh', NULL, 2, 1, 'corpo-rates.com', NULL, '2023-12-18 13:50:51', NULL, NULL, NULL, 1, 8801766144244, NULL, NULL, NULL, 'corpo-rates.com'),
(77, 'Colaker Group', 1, 'mrtclkr', NULL, '80', 'Colaker, Burak & Colaker Mert GbR Attilastraße 177 12105 Berlin', 'Vcard Website Owner', 1, 1, 'www.vinitycard.com', NULL, '2023-12-27 11:20:21', NULL, NULL, '2024-05-27 15:19:25', 1, NULL, 17621187515, NULL, NULL, 'www.vinitycard.com'),
(78, 'Mr. Dean Aellen', 1, 'tltlch', 'd.aellen@tech-link.ch', '206', 'Bahnhofstrasse 60 8600 Dübendorf', 'Vcard Owner', 2, 1, 'https://cloud-card.ch', NULL, '2023-12-30 12:46:41', NULL, NULL, NULL, 1, 41445514750, NULL, NULL, NULL, 'TECHLink AG'),
(79, 'Sudhir Rao', 1, 'gurgaon_r', 'office@sudhirrao.com', '99', NULL, 'Advocate', 2, 1, 'https://sudhirrao.com', NULL, '2024-04-29 14:45:12', NULL, NULL, NULL, 1, NULL, 9729506771, NULL, NULL, 'sudhirrao.com'),
(80, 'Omar Alouani', 2, 'Hipopsalot', 'info@milrenter.com', '226', '21750 Hardy Oak Blvd Ste 104 PMB 510773 San Antonio, Texas 78258-4946 US', NULL, 1, 1, NULL, NULL, '2024-05-11 12:51:18', NULL, NULL, '2024-05-14 15:54:47', 1, 2107011603, NULL, NULL, 'property selling', 'milrenter.com'),
(81, 'Shaheer', 1, 'Shaheerjafri', 'suljhaao@hotmail.com', '162', NULL, NULL, 1, 1, NULL, NULL, '2024-05-11 12:56:08', NULL, NULL, NULL, 1, 3092429021, NULL, NULL, 'lawyer listing', 'SULJHAAO.COM'),
(82, 'Cueneyt Kurt', 1, 'cuni63', 'Cuneytkurt63@gmail.com', '80', 'Wipperstrasse 4 Niedersachsen, Braunschweig, 38120', NULL, 2, 1, 'venmeo.de', NULL, '2024-05-20 16:32:25', NULL, NULL, NULL, 1, NULL, NULL, 1733910844, 'vcard', 'venmeo.de'),
(83, 'jarapaxen', 1, 'jarapaxen', NULL, '80', NULL, NULL, 2, 1, NULL, NULL, '2024-05-27 19:37:47', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'monetizevirtualfundsoftware.com'),
(84, 'Jacob', 1, 'goncalves_goja', 'gojasettings@gmail.com', '145', NULL, NULL, 2, 1, NULL, NULL, '2024-05-27 19:56:23', NULL, NULL, NULL, 1, 843736665, NULL, NULL, NULL, 'goja.co.mz'),
(85, 'Fakansha', 1, 'Fakansha', NULL, '81', 'ghana', NULL, 2, 1, 'kokonte.com', NULL, '2024-06-23 14:24:18', NULL, NULL, NULL, 1, 550822900, NULL, NULL, NULL, 'kokonte.com'),
(86, 'Lohit Sahu', 1, 'lohitsahu821', NULL, '99', 'India', 'Business', 2, 1, NULL, NULL, '2024-07-03 14:30:38', NULL, NULL, NULL, 1, 9769140932, NULL, NULL, 'online tutorial platform', 'https://flippr.in/'),
(87, 'Conrad A. Bedford', 1, 'seo4fiver', 'rutlandwindow@gmail.com', '226', 'Conrad A. Bedford Assets International Limited - Group Uno Belle Vue Lodge Paignton, DEVON, TQ4 6ER United Kingdom', NULL, 2, 1, NULL, NULL, '2024-07-04 12:08:57', NULL, NULL, '2024-07-08 15:26:32', 1, 34691915232, NULL, NULL, NULL, 'Seo Guest Post'),
(88, 'tender123456', 1, 'tender123456', NULL, '104', NULL, NULL, 2, 1, NULL, NULL, '2024-07-10 15:22:42', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'tholon.automas.co.il'),
(89, 'Reinhard', 1, 'reckstein', NULL, '80', NULL, NULL, 2, 1, NULL, NULL, '2024-08-13 11:36:00', NULL, NULL, '2024-08-13 13:02:32', 1, NULL, NULL, NULL, NULL, 'connectify.cards'),
(90, 'Reinhard', 1, 'Reinhard', NULL, '80', NULL, 'vcard owner', 2, 1, 'connectify.cards', NULL, '2024-08-20 18:12:57', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'connectify.cards'),
(91, 'andrewkanoun', 1, 'andrewkanoun', NULL, '38', NULL, NULL, 2, 1, NULL, NULL, '2024-08-22 12:55:17', NULL, NULL, NULL, 1, NULL, NULL, NULL, 'vcard', 'tap-access.com'),
(92, 'MVCS', 1, 'michaelviehweg', 'michael@mikev-consult.com', '58', 'Skovbyvej 1c, 2740 Skovlunde Denmark', NULL, 2, 1, NULL, NULL, '2024-08-24 12:42:50', NULL, NULL, '2024-12-08 14:22:34', 1, 51228345, 51228345, NULL, NULL, 'https://mvcgroup.ltd/'),
(93, 'Chris N', 1, 'cloudfusions', NULL, '226', NULL, 'website hosting sell', 2, 1, NULL, NULL, '2024-08-27 16:10:36', NULL, NULL, NULL, 1, 8044849719, NULL, NULL, NULL, 'webservices3.com'),
(94, 'balakido', 1, 'balakido', NULL, '1', NULL, NULL, 2, 1, NULL, NULL, '2024-09-14 14:29:32', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'https://myflixer.beauty/'),
(97, 'Gautam Saha', 3, NULL, 'gautmsaha@gmail.com', '18', NULL, NULL, 2, 1, NULL, NULL, '2024-09-18 12:40:28', NULL, NULL, NULL, 1, 1717221113, NULL, NULL, NULL, 'takabazar24.com'),
(99, 'Anthony', 1, 'anthonyverna', NULL, '38', 'Canada', NULL, 2, 1, NULL, NULL, '2024-09-19 12:26:40', NULL, NULL, '2024-10-30 19:47:15', 1, 6045628449, NULL, NULL, NULL, 'shipbymail.com'),
(100, 'dandisav', 1, 'dandisav', NULL, '104', NULL, NULL, 2, 1, NULL, NULL, '2024-10-23 10:43:21', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'craftedfate.com'),
(101, 'Ehis Omoleme', 1, 'mykeehis1', 'ehizconsortium@gmail.com', '80', 'Ehis Omoleme Ehis Michael Omoleme hauptstr. 44 NA, schwebheim, 97525 Germany', NULL, 2, 1, NULL, NULL, '2024-11-23 13:56:21', NULL, NULL, '2024-11-30 16:30:51', 1, 15229508262, NULL, NULL, NULL, NULL),
(102, 'guuava', 1, 'guuava', NULL, '226', NULL, NULL, 1, 1, NULL, NULL, '2024-12-01 15:48:13', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, 'accreal.com'),
(103, 'humphrey', 1, 'humphrey123456', NULL, '110', NULL, NULL, 2, 1, NULL, NULL, '2024-12-03 17:14:20', NULL, NULL, NULL, 1, 720318723, NULL, NULL, NULL, 'sokobuild'),
(104, 'Pascal', 1, 'pascalcisangani', 'pascal.ogs@gmail.com', '197', 'soutafrica', NULL, 2, 1, NULL, NULL, '2024-12-08 14:05:24', NULL, NULL, NULL, 1, 734030207, NULL, NULL, 'school management', 'heconnected.com');
-- --------------------------------------------------------
--
-- Table structure for table `crm_lead_priorities`
--
CREATE TABLE `crm_lead_priorities` (
`id` int NOT NULL,
`name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`order_id` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `crm_lead_priorities`
--
INSERT INTO `crm_lead_priorities` (`id`, `name`, `order_id`, `created_at`, `updated_at`) VALUES
(1, 'High', '1', NULL, NULL),
(2, 'Meidum', '2', NULL, NULL),
(3, 'Low', '2', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `crm_lead_status`
--
CREATE TABLE `crm_lead_status` (
`id` int NOT NULL,
`name` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
`order_id` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `crm_lead_status`
--
INSERT INTO `crm_lead_status` (`id`, `name`, `order_id`, `created_at`, `updated_at`) VALUES
(1, 'New', '1', NULL, NULL),
(2, 'Rejected', '2', NULL, NULL),
(3, 'Existing', '3', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `crm_listings`
--
CREATE TABLE `crm_listings` (
`pk_id` int NOT NULL,
`code` int DEFAULT NULL,
`name` varchar(155) COLLATE utf8mb4_general_ci DEFAULT NULL,
`category_id` int DEFAULT NULL,
`project_type_id` int DEFAULT NULL,
`payment_type_id` int DEFAULT NULL,
`total_budget` float(13,2) NOT NULL DEFAULT '0.00',
`starting_price` float(13,2) DEFAULT '0.00',
`currency_id` int NOT NULL,
`currency_name` varchar(20) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '''USD''',
`start_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
`project_source_id` int DEFAULT NULL,
`payment_status` int DEFAULT NULL,
`project_status` int DEFAULT NULL,
`lead_id` int DEFAULT NULL COMMENT 'crm_lead_master pk',
`user_id` int DEFAULT NULL COMMENT 'Lead Develope',
`is_pipeline` int NOT NULL DEFAULT '0',
`created_at` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` int DEFAULT NULL,
`description` text COLLATE utf8mb4_general_ci,
`is_active` int DEFAULT '1',
`username` varchar(155) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'source user name'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `crm_milestone`
--
CREATE TABLE `crm_milestone` (
`id` int NOT NULL,
`listing_id` int DEFAULT NULL,
`name` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
`start_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
`description` text COLLATE utf8mb4_general_ci,
`created_at` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`status` int NOT NULL DEFAULT '1' COMMENT '1=Running,2=Complete,3=Pending',
`is_deleted` int NOT NULL DEFAULT '0' COMMENT '0=Not Deleted,1=Deleted',
`updated_by` int DEFAULT NULL,
`milestone_price` float(14,2) NOT NULL DEFAULT '0.00',
`milestone_payment_status` int NOT NULL DEFAULT '0' COMMENT '0=due,1=paid',
`milestone_paid_date` date DEFAULT NULL,
`currency_id` int DEFAULT NULL,
`currency_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `crm_notes`
--
CREATE TABLE `crm_notes` (
`id` int NOT NULL,
`title` varchar(255) COLLATE utf8mb4_swedish_ci NOT NULL,
`description` text COLLATE utf8mb4_swedish_ci NOT NULL,
`order_id` int NOT NULL DEFAULT '0',
`status` tinyint NOT NULL DEFAULT '1',
`created_by` int DEFAULT NULL,
`updated_by` int DEFAULT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `crm_project_source`
--
CREATE TABLE `crm_project_source` (
`id` int NOT NULL,
`name` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `crm_requirements`
--
CREATE TABLE `crm_requirements` (
`pk_id` int NOT NULL,
`buy_sale_rommate` varchar(30) DEFAULT NULL,
`property_categories` varchar(100) DEFAULT NULL,
`property_type` varchar(255) DEFAULT NULL,
`property_type_residential` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`property_type_commercial` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`property_type_land` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`email` varchar(70) DEFAULT NULL,
`mobile` varchar(16) DEFAULT NULL,
`message` varchar(510) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`act_mode` varchar(255) DEFAULT NULL,
`country` varchar(100) DEFAULT NULL,
`country_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`dial_code` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_slovenian_ci DEFAULT NULL,
`city` varchar(50) DEFAULT NULL,
`area` varchar(255) DEFAULT NULL,
`prefer_area` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`prefer_lat_lon` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`address` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_turkish_ci DEFAULT NULL,
`roommate_residence_type` varchar(100) DEFAULT NULL,
`roommate_gender` varchar(100) DEFAULT NULL,
`property_size` varchar(30) DEFAULT NULL,
`property_size_min` varchar(100) DEFAULT NULL,
`property_size_max` varchar(100) DEFAULT NULL,
`bedroom` varchar(30) DEFAULT NULL,
`bathroom` varchar(30) DEFAULT NULL,
`bathroom2` varchar(50) DEFAULT NULL,
`sale_resi_preferred_tenant` varchar(30) DEFAULT NULL,
`monthly_rent` varchar(100) DEFAULT NULL,
`room_type` varchar(30) DEFAULT NULL,
`construction_status` varchar(50) DEFAULT NULL,
`land_type` varchar(50) DEFAULT NULL,
`size_katha` varchar(30) DEFAULT NULL,
`salemin` varchar(100) DEFAULT NULL,
`salemax` varchar(100) DEFAULT NULL,
`rentmin` varchar(100) DEFAULT NULL,
`rentmax` varchar(100) DEFAULT NULL,
`landmin` varchar(100) DEFAULT NULL,
`landmax` varchar(100) DEFAULT NULL,
`budgetmin` varchar(100) DEFAULT NULL,
`budgetmax` varchar(100) DEFAULT NULL,
`terms` tinyint(1) NOT NULL DEFAULT '1',
`verification` varchar(255) DEFAULT NULL,
`comments` varchar(510) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`ip_address` varchar(20) DEFAULT NULL,
`send_message_alert` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`customer_id` int DEFAULT NULL,
`listing_id` int DEFAULT NULL,
`inqurie_id` int DEFAULT NULL,
`postrequirement_id` varchar(16) DEFAULT NULL,
`requirements_status` int NOT NULL DEFAULT '0' COMMENT 'status value 1 is post',
`subsciber` int DEFAULT '1',
`property_count` int NOT NULL DEFAULT '1',
`property_count_daily` int NOT NULL DEFAULT '1',
`messege_count` int NOT NULL DEFAULT '1',
`daily` int NOT NULL DEFAULT '1',
`is_delete` int DEFAULT NULL,
`is_active` int DEFAULT NULL,
`daily_m` date DEFAULT NULL,
`months` date DEFAULT NULL,
`weeks` date DEFAULT NULL,
`visited` int DEFAULT NULL,
`self_verification` int DEFAULT '1' COMMENT '1 = not verified, 2 = verified ',
`created_by` varchar(255) DEFAULT NULL,
`modified_by` varchar(255) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`modified_at` datetime DEFAULT NULL,
`lead_modified_at` datetime DEFAULT CURRENT_TIMESTAMP,
`type` varchar(512) DEFAULT NULL COMMENT 'self = Lead Inserted by Company ',
`next_contact_time` datetime DEFAULT NULL,
`pref_contact_time` varchar(1024) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `crm_settings`
--
CREATE TABLE `crm_settings` (
`id` int NOT NULL,
`sms_api` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`sms_username` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`sms_password` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`email_id` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`email_portno` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`email_password` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`mail_host` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`created_by` int DEFAULT NULL,
`updated_by` int DEFAULT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `crm_staff_increment`
--
CREATE TABLE `crm_staff_increment` (
`id` int NOT NULL,
`staff_id` int DEFAULT NULL,
`increment_amount` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
`increment_date` date DEFAULT NULL,
`created_at` date DEFAULT NULL,
`created_by` int DEFAULT NULL,
`updated_at` date DEFAULT NULL,
`updated_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `crm_staff_master`
--
CREATE TABLE `crm_staff_master` (
`pk_id` int NOT NULL,
`full_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
`email_address` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
`phone_number` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
`nid_card` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
`designation` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
`user_type` int NOT NULL DEFAULT '0' COMMENT '0=user,1=admin',
`profile_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`present_address` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`permanent_address` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`basic_salary` int DEFAULT NULL,
`gross_salary` int DEFAULT NULL,
`joining_date` date DEFAULT NULL,
`resign_date` date DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`created_by` int DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` int DEFAULT NULL,
`status` int NOT NULL DEFAULT '1' COMMENT '1 = active, 0 = inactive'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `districts`
--
CREATE TABLE `districts` (
`id` int NOT NULL,
`division_id` int NOT NULL,
`name` varchar(25) COLLATE utf8mb4_general_ci NOT NULL,
`bn_name` varchar(25) COLLATE utf8mb4_general_ci NOT NULL,
`lat` varchar(15) COLLATE utf8mb4_general_ci DEFAULT NULL,
`lon` varchar(15) COLLATE utf8mb4_general_ci DEFAULT NULL,
`url` varchar(50) COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `districts`
--
INSERT INTO `districts` (`id`, `division_id`, `name`, `bn_name`, `lat`, `lon`, `url`) VALUES
(1, 1, 'Comilla', 'কুমিল্লা', '23.4682747', '91.1788135', 'www.comilla.gov.bd'),
(2, 1, 'Feni', 'ফেনী', '23.023231', '91.3840844', 'www.feni.gov.bd'),
(3, 1, 'Brahmanbaria', 'ব্রাহ্মণবাড়িয়া', '23.9570904', '91.1119286', 'www.brahmanbaria.gov.bd'),
(4, 1, 'Rangamati', 'রাঙ্গামাটি', NULL, NULL, 'www.rangamati.gov.bd'),
(5, 1, 'Noakhali', 'নোয়াখালী', '22.869563', '91.099398', 'www.noakhali.gov.bd'),
(6, 1, 'Chandpur', 'চাঁদপুর', '23.2332585', '90.6712912', 'www.chandpur.gov.bd'),
(7, 1, 'Lakshmipur', 'লক্ষ্মীপুর', '22.942477', '90.841184', 'www.lakshmipur.gov.bd'),
(8, 1, 'Chattogram', 'চট্টগ্রাম', '22.335109', '91.834073', 'www.chittagong.gov.bd'),
(9, 1, 'Coxsbazar', 'কক্সবাজার', NULL, NULL, 'www.coxsbazar.gov.bd'),
(10, 1, 'Khagrachhari', 'খাগড়াছড়ি', '23.119285', '91.984663', 'www.khagrachhari.gov.bd'),
(11, 1, 'Bandarban', 'বান্দরবান', '22.1953275', '92.2183773', 'www.bandarban.gov.bd'),
(12, 2, 'Sirajganj', 'সিরাজগঞ্জ', '24.4533978', '89.7006815', 'www.sirajganj.gov.bd'),
(13, 2, 'Pabna', 'পাবনা', '23.998524', '89.233645', 'www.pabna.gov.bd'),
(14, 2, 'Bogura', 'বগুড়া', '24.8465228', '89.377755', 'www.bogra.gov.bd'),
(15, 2, 'Rajshahi', 'রাজশাহী', NULL, NULL, 'www.rajshahi.gov.bd'),
(16, 2, 'Natore', 'নাটোর', '24.420556', '89.000282', 'www.natore.gov.bd'),
(17, 2, 'Joypurhat', 'জয়পুরহাট', NULL, NULL, 'www.joypurhat.gov.bd'),
(18, 2, 'Chapainawabganj', 'চাঁপাইনবাবগঞ্জ', '24.5965034', '88.2775122', 'www.chapainawabganj.gov.bd'),
(19, 2, 'Naogaon', 'নওগাঁ', NULL, NULL, 'www.naogaon.gov.bd'),
(20, 3, 'Jashore', 'যশোর', '23.16643', '89.2081126', 'www.jessore.gov.bd'),
(21, 3, 'Satkhira', 'সাতক্ষীরা', NULL, NULL, 'www.satkhira.gov.bd'),
(22, 3, 'Meherpur', 'মেহেরপুর', '23.762213', '88.631821', 'www.meherpur.gov.bd'),
(23, 3, 'Narail', 'নড়াইল', '23.172534', '89.512672', 'www.narail.gov.bd'),
(24, 3, 'Chuadanga', 'চুয়াডাঙ্গা', '23.6401961', '88.841841', 'www.chuadanga.gov.bd'),
(25, 3, 'Kushtia', 'কুষ্টিয়া', '23.901258', '89.120482', 'www.kushtia.gov.bd'),
(26, 3, 'Magura', 'মাগুরা', '23.487337', '89.419956', 'www.magura.gov.bd'),
(27, 3, 'Khulna', 'খুলনা', '22.815774', '89.568679', 'www.khulna.gov.bd'),
(28, 3, 'Bagerhat', 'বাগেরহাট', '22.651568', '89.785938', 'www.bagerhat.gov.bd'),
(29, 3, 'Jhenaidah', 'ঝিনাইদহ', '23.5448176', '89.1539213', 'www.jhenaidah.gov.bd'),
(30, 4, 'Jhalakathi', 'ঝালকাঠি', NULL, NULL, 'www.jhalakathi.gov.bd'),
(31, 4, 'Patuakhali', 'পটুয়াখালী', '22.3596316', '90.3298712', 'www.patuakhali.gov.bd'),
(32, 4, 'Pirojpur', 'পিরোজপুর', NULL, NULL, 'www.pirojpur.gov.bd'),
(33, 4, 'Barisal', 'বরিশাল', NULL, NULL, 'www.barisal.gov.bd'),
(34, 4, 'Bhola', 'ভোলা', '22.685923', '90.648179', 'www.bhola.gov.bd'),
(35, 4, 'Barguna', 'বরগুনা', NULL, NULL, 'www.barguna.gov.bd'),
(36, 5, 'Sylhet', 'সিলেট', '24.8897956', '91.8697894', 'www.sylhet.gov.bd'),
(37, 5, 'Moulvibazar', 'মৌলভীবাজার', '24.482934', '91.777417', 'www.moulvibazar.gov.bd'),
(38, 5, 'Habiganj', 'হবিগঞ্জ', '24.374945', '91.41553', 'www.habiganj.gov.bd'),
(39, 5, 'Sunamganj', 'সুনামগঞ্জ', '25.0658042', '91.3950115', 'www.sunamganj.gov.bd'),
(40, 6, 'Narsingdi', 'নরসিংদী', '23.932233', '90.71541', 'www.narsingdi.gov.bd'),
(41, 6, 'Gazipur', 'গাজীপুর', '24.0022858', '90.4264283', 'www.gazipur.gov.bd'),
(42, 6, 'Shariatpur', 'শরীয়তপুর', NULL, NULL, 'www.shariatpur.gov.bd'),
(43, 6, 'Narayanganj', 'নারায়ণগঞ্জ', '23.63366', '90.496482', 'www.narayanganj.gov.bd'),
(44, 6, 'Tangail', 'টাঙ্গাইল', NULL, NULL, 'www.tangail.gov.bd'),
(45, 6, 'Kishoreganj', 'কিশোরগঞ্জ', '24.444937', '90.776575', 'www.kishoreganj.gov.bd'),
(46, 6, 'Manikganj', 'মানিকগঞ্জ', NULL, NULL, 'www.manikganj.gov.bd'),
(47, 6, 'Dhaka', 'ঢাকা', '23.7115253', '90.4111451', 'www.dhaka.gov.bd'),
(48, 6, 'Munshiganj', 'মুন্সিগঞ্জ', NULL, NULL, 'www.munshiganj.gov.bd'),
(49, 6, 'Rajbari', 'রাজবাড়ী', '23.7574305', '89.6444665', 'www.rajbari.gov.bd'),
(50, 6, 'Madaripur', 'মাদারীপুর', '23.164102', '90.1896805', 'www.madaripur.gov.bd'),
(51, 6, 'Gopalganj', 'গোপালগঞ্জ', '23.0050857', '89.8266059', 'www.gopalganj.gov.bd'),
(52, 6, 'Faridpur', 'ফরিদপুর', '23.6070822', '89.8429406', 'www.faridpur.gov.bd'),
(53, 7, 'Panchagarh', 'পঞ্চগড়', '26.3411', '88.5541606', 'www.panchagarh.gov.bd'),
(54, 7, 'Dinajpur', 'দিনাজপুর', '25.6217061', '88.6354504', 'www.dinajpur.gov.bd'),
(55, 7, 'Lalmonirhat', 'লালমনিরহাট', NULL, NULL, 'www.lalmonirhat.gov.bd'),
(56, 7, 'Nilphamari', 'নীলফামারী', '25.931794', '88.856006', 'www.nilphamari.gov.bd'),
(57, 7, 'Gaibandha', 'গাইবান্ধা', '25.328751', '89.528088', 'www.gaibandha.gov.bd'),
(58, 7, 'Thakurgaon', 'ঠাকুরগাঁও', '26.0336945', '88.4616834', 'www.thakurgaon.gov.bd'),
(59, 7, 'Rangpur', 'রংপুর', '25.7558096', '89.244462', 'www.rangpur.gov.bd'),
(60, 7, 'Kurigram', 'কুড়িগ্রাম', '25.805445', '89.636174', 'www.kurigram.gov.bd'),
(61, 8, 'Sherpur', 'শেরপুর', '25.0204933', '90.0152966', 'www.sherpur.gov.bd'),
(62, 8, 'Mymensingh', 'ময়মনসিংহ', '24.7465670', '90.4072093', 'www.mymensingh.gov.bd'),
(63, 8, 'Jamalpur', 'জামালপুর', '24.937533', '89.937775', 'www.jamalpur.gov.bd'),
(64, 8, 'Netrokona', 'নেত্রকোণা', '24.870955', '90.727887', 'www.netrokona.gov.bd');
-- --------------------------------------------------------
--
-- Table structure for table `failed_jobs`
--
CREATE TABLE `failed_jobs` (
`id` bigint UNSIGNED NOT NULL,
`connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
`queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `gyms`
--
CREATE TABLE `gyms` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`moto` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`established` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`logo_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`banner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`banner_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status` tinyint NOT NULL DEFAULT '1',
`created_by` bigint UNSIGNED NOT NULL DEFAULT '0',
`updated_by` bigint UNSIGNED NOT NULL DEFAULT '0',
`deleted_by` bigint UNSIGNED NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `income_expense`
--
CREATE TABLE `income_expense` (
`id` int NOT NULL,
`name` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
`head_id` int NOT NULL,
`invoice_number` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`amount` int NOT NULL,
`document` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`description` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`date` date DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`status` int NOT NULL DEFAULT '1' COMMENT '0=inactive,1=active',
`updated_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `income_expense_head`
--
CREATE TABLE `income_expense_head` (
`id` int NOT NULL,
`name` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
`type` enum('income','expense') COLLATE utf8mb4_general_ci NOT NULL,
`created_at` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`status` int NOT NULL DEFAULT '1' COMMENT '0=inactive,1=active',
`updated_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `invoices`
--
CREATE TABLE `invoices` (
`id` int NOT NULL,
`client_id` int DEFAULT NULL,
`project_id` int DEFAULT NULL,
`country_id` int DEFAULT NULL,
`invoice_number` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`currency_id` int DEFAULT NULL,
`currency_name` varchar(20) COLLATE utf8mb4_swedish_ci NOT NULL,
`item` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`description` text COLLATE utf8mb4_swedish_ci,
`quantityOption` enum('qty','hrs') COLLATE utf8mb4_swedish_ci DEFAULT 'qty',
`qty` int DEFAULT NULL,
`rate` float DEFAULT NULL,
`sub_total` float DEFAULT NULL,
`discount` float DEFAULT NULL COMMENT 'discount in percentage (%) ',
`discount_amount` float DEFAULT NULL,
`total` double DEFAULT NULL,
`admin_note` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`client_note` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`terms_condition` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`street` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`city` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`state` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`zip_code` int DEFAULT NULL,
`invoice_date` date DEFAULT NULL,
`due_date` date DEFAULT NULL,
`created_by` int DEFAULT NULL,
`updated_by` int DEFAULT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime DEFAULT NULL,
`payment_status` int NOT NULL DEFAULT '0' COMMENT '0=due,1=paid',
`paid_date` date DEFAULT NULL,
`payment_mode` int NOT NULL DEFAULT '1' COMMENT '1=bank,2=paypal,3=cash'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `jobs`
--
CREATE TABLE `jobs` (
`id` int NOT NULL,
`job_title` varchar(255) NOT NULL,
`workspace_type` enum('Onsite','Remote','Hybrid') NOT NULL,
`job_type` enum('Full Time','Part Time','Contract','Temporary','Freelance') NOT NULL,
`salary_type` enum('Monthly','Hourly','Yearly','Competitive') NOT NULL,
`description` text NOT NULL,
`expires_in` enum('10 days','15 days','20 days') NOT NULL,
`deadline` date NOT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- Table structure for table `job_applications`
--
CREATE TABLE `job_applications` (
`id` int NOT NULL,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`phone_number` varchar(20) NOT NULL,
`country_code` varchar(5) DEFAULT '+880',
`resume` varchar(255) NOT NULL,
`cover_letter` text NOT NULL,
`applied_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- --------------------------------------------------------
--
-- Table structure for table `lead_sources`
--
CREATE TABLE `lead_sources` (
`pk_id` int NOT NULL,
`name` varchar(255) COLLATE utf8mb4_swedish_ci NOT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`updated_by` int DEFAULT NULL,
`is_active` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_swedish_ci;
--
-- Dumping data for table `lead_sources`
--
INSERT INTO `lead_sources` (`pk_id`, `name`, `created_at`, `updated_at`, `created_by`, `updated_by`, `is_active`) VALUES
(1, 'Fiverr', '2022-10-09 14:34:24', NULL, NULL, NULL, 1),
(2, 'Freelancer.com', '2022-10-09 14:34:24', NULL, NULL, NULL, 1),
(3, 'Local Market', '2022-10-09 14:34:42', NULL, NULL, NULL, 1),
(5, 'Upwork', '2022-10-15 08:24:59', NULL, NULL, NULL, 1);
-- --------------------------------------------------------
--
-- Table structure for table `migrations`
--
CREATE TABLE `migrations` (
`id` int UNSIGNED NOT NULL,
`migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `migrations`
--
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_100000_create_password_resets_table', 1),
(2, '2019_08_19_000000_create_failed_jobs_table', 1),
(3, '2019_09_30_123517_create_permission_groups_table', 1),
(4, '2019_09_30_123523_create_permissions_table', 1),
(5, '2019_09_30_123524_create_roles_table', 1),
(6, '2019_09_30_123525_create_group_role_permission_table', 1),
(7, '2019_09_30_123526_create_models_table', 1),
(8, '2019_09_30_123527_create_auths_table', 1),
(9, '2019_09_30_123528_create_auth_group_role_table', 1),
(10, '2019_10_01_073858_create_admin_users_table', 1),
(11, '2019_10_02_073857_create_users_table', 1),
(12, '2020_01_21_060402_create_tokens_table', 1),
(13, '2020_01_22_190558_create_verify_mobile_no_table', 1),
(14, '2020_01_28_173236_create_table_workout_body_part', 1),
(15, '2020_01_28_173340_create_table_workout_items', 1),
(16, '2020_02_12_064858_create_gyms_table', 1),
(17, '2020_02_18_102849_add_gym_id_users_table', 1);
-- --------------------------------------------------------
--
-- Table structure for table `models`
--
CREATE TABLE `models` (
`id` bigint UNSIGNED NOT NULL,
`display_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`model_key` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
`model_class_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status` tinyint NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `models`
--
INSERT INTO `models` (`id`, `display_name`, `model_key`, `model_class_name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'admin', 'AdminInterface', 1, '2020-12-07 05:09:38', '2020-12-07 05:09:38'),
(2, 'User', 'user', 'UserInterface', 1, '2020-12-07 05:09:38', '2020-12-07 05:09:38');
-- --------------------------------------------------------
--
-- Table structure for table `password_resets`
--
CREATE TABLE `password_resets` (
`email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `permissions`
--
CREATE TABLE `permissions` (
`id` bigint UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`display_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`permission_group_id` bigint UNSIGNED NOT NULL,
`status` tinyint NOT NULL DEFAULT '0',
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `permissions`
--
INSERT INTO `permissions` (`id`, `name`, `display_name`, `permission_group_id`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'view_admin_user', 'view_admin_user', 5, 1, NULL, '2021-03-04 06:52:42', '2021-03-04 06:52:42'),
(2, 'add_admin_user', 'add_admin_user', 5, 1, NULL, '2021-03-04 06:52:55', '2021-03-04 06:52:55'),
(3, 'edit_admin_user', 'edit_admin_user', 5, 1, NULL, '2021-03-04 06:53:12', '2021-03-04 06:53:12'),
(4, 'delete_admin_user', 'delete_admin_user', 5, 1, NULL, '2021-03-04 06:53:23', '2021-03-04 06:53:23'),
(5, 'view_user_group', 'view_user_group', 3, 1, NULL, '2021-03-04 06:53:35', '2021-03-04 06:53:35'),
(6, 'new_user_group', 'new_user_group', 3, 1, NULL, '2021-03-04 06:53:52', '2021-03-04 06:53:52'),
(7, 'edit_user_group', 'edit_user_group', 3, 1, NULL, '2021-03-04 06:54:05', '2021-03-04 06:54:05'),
(8, 'delete_user_group', 'delete_user_group', 3, 1, NULL, '2021-03-04 06:54:18', '2021-03-04 06:54:18'),
(9, 'assign_user_access', 'assign_user_access', 2, 1, NULL, '2021-03-04 06:54:34', '2021-03-04 06:54:34'),
(10, 'view_role', 'view_role', 15, 1, NULL, '2021-03-04 06:55:23', '2021-03-04 06:55:23'),
(11, 'add_role', 'add_role', 15, 1, NULL, '2021-03-04 06:55:34', '2021-03-04 06:55:34'),
(12, 'edit_role', 'edit_role', 15, 1, NULL, '2021-03-04 06:55:44', '2021-03-04 06:55:44'),
(13, 'delete_role', 'delete_role', 15, 1, NULL, '2021-03-04 06:55:59', '2021-03-04 06:55:59'),
(14, 'view_menu', 'view_menu', 1, 1, NULL, '2021-03-04 06:56:11', '2021-03-04 06:56:11'),
(15, 'new_menu', 'new_menu', 1, 1, NULL, '2021-03-04 06:56:25', '2021-03-04 06:56:25'),
(16, 'edit_menu', 'edit_menu', 1, 1, NULL, '2021-03-04 06:56:37', '2021-03-04 06:56:37'),
(17, 'delete_menu', 'delete_menu', 1, 1, NULL, '2021-03-04 06:56:50', '2021-03-04 06:56:50'),
(18, 'view_action', 'view_action', 2, 1, NULL, '2021-03-04 06:57:06', '2021-03-04 06:57:06'),
(19, 'new_action', 'new_action', 2, 1, NULL, '2021-03-04 06:57:21', '2021-03-04 06:57:21'),
(20, 'edit_action', 'edit_action', 2, 1, NULL, '2021-03-04 06:57:33', '2021-03-04 06:57:33'),
(21, 'delete_action', 'delete_action', 3, 1, NULL, '2021-03-04 06:57:43', '2021-03-04 06:57:43'),
(22, 'view_listing', 'view_listing', 6, 1, NULL, '2021-03-04 06:57:56', '2021-03-04 06:57:56'),
(23, 'new_listing', 'new_listing', 6, 1, NULL, '2021-03-04 06:58:06', '2021-03-04 06:58:06'),
(24, 'edit_listing', 'edit_listing', 6, 1, NULL, '2021-03-04 06:58:14', '2021-03-04 06:58:14'),
(25, 'delete_listing', 'delete_listing', 6, 1, NULL, '2021-03-04 06:58:31', '2021-03-04 06:58:31'),
(26, 'view_email', 'view_email', 14, 1, NULL, '2021-03-04 06:59:08', '2021-03-04 06:59:08'),
(27, 'view_lead', 'view_lead', 8, 1, NULL, '2021-03-04 06:59:19', '2021-03-04 06:59:19'),
(28, 'new_lead', 'new_lead', 8, 1, NULL, '2021-03-04 06:59:26', '2021-03-04 06:59:26'),
(29, 'edit_lead', 'edit_lead', 8, 1, NULL, '2021-03-04 06:59:35', '2021-03-04 06:59:35'),
(30, 'delete_lead', 'delete_lead', 8, 1, NULL, '2021-03-04 06:59:46', '2021-03-04 06:59:46'),
(32, 'search_lead', 'search_lead', 8, 1, NULL, '2021-03-04 07:01:02', '2021-03-04 07:01:02'),
(33, 'download_lead_pdf', 'download_lead_pdf', 8, 1, NULL, '2021-03-04 07:01:22', '2021-03-04 07:01:22'),
(34, 'download_lead_excel', 'download_lead_excel', 8, 1, NULL, '2021-03-04 07:02:08', '2021-03-04 07:02:08'),
(35, 'import_lead', 'import_lead', 8, 1, NULL, '2021-03-04 07:02:18', '2021-03-04 07:02:18'),
(36, 'view_task', 'view_task', 9, 1, NULL, '2021-03-04 07:02:45', '2021-03-04 07:02:45'),
(37, 'delete_task', 'delete_task', 9, 1, NULL, '2021-03-04 07:03:20', '2021-03-04 07:03:20'),
(38, 'edit_task', 'edit_task', 9, 1, NULL, '2021-03-04 07:03:29', '2021-03-04 07:03:29'),
(39, 'new_task', 'new_task', 9, 1, NULL, '2021-03-04 07:03:38', '2021-03-04 07:03:38'),
(41, 'today_all_task', 'today_all_task', 9, 1, NULL, '2021-03-04 07:05:14', '2021-03-04 07:05:14'),
(42, 'task_details', 'task_details', 9, 1, NULL, '2021-03-04 07:05:39', '2021-03-04 07:05:39'),
(43, 'search_task', 'search_task', 9, 1, NULL, '2021-03-04 07:05:59', '2021-03-04 07:05:59'),
(44, 'tomorrow_task', 'tomorrow_task', 9, 1, NULL, '2021-03-04 07:06:20', '2021-03-04 07:06:20'),
(45, 'pendind_task', 'pendind_task', 9, 1, NULL, '2021-03-04 07:06:41', '2021-03-04 07:06:41'),
(46, 'task_list', 'task_list', 9, 1, NULL, '2021-03-04 07:06:58', '2021-03-04 07:06:58'),
(47, 'close_to_deal', 'close_to_deal', 9, 1, NULL, '2021-03-04 07:07:39', '2021-03-04 07:07:39'),
(49, 'my_task', 'my_task', 9, 1, NULL, '2021-03-04 07:08:57', '2021-03-04 07:08:57'),
(50, 'my_today_task', 'my_today_task', 9, 1, NULL, '2021-03-04 07:09:13', '2021-03-04 07:09:13'),
(51, 'my_pending_task', 'my_pending_task', 9, 1, NULL, '2021-03-04 07:09:23', '2021-03-04 07:09:23'),
(54, 'view_sms', 'view_sms', 14, 1, NULL, '2021-03-04 07:10:37', '2021-03-04 07:10:37'),
(59, 'view_project', 'view_project', 6, 1, NULL, '2021-03-04 07:12:14', '2021-03-04 07:12:14'),
(60, 'new_project', 'new_project', 6, 1, NULL, '2021-03-04 07:12:39', '2021-03-04 07:12:39'),
(61, 'edit_project', 'edit_project', 6, 1, NULL, '2021-03-04 07:12:51', '2021-03-04 07:12:51'),
(62, 'delete_project', 'delete_project', 6, 1, NULL, '2021-03-04 07:13:10', '2021-03-04 07:13:10'),
(66, 'view_profile', 'view_profile', 5, 1, NULL, '2021-03-04 07:21:21', '2021-03-04 07:21:21'),
(67, 'change_password', 'change_password', 5, 1, NULL, '2021-03-04 07:21:35', '2021-03-04 07:21:35'),
(68, 'update_user', 'update_user', 5, 1, NULL, '2021-03-04 07:21:56', '2021-03-04 07:21:56'),
(70, 'view_message', 'view_message', 14, 1, NULL, '2021-03-04 07:22:25', '2021-03-04 07:22:25'),
(72, 'view_email_template', 'view_email_template', 14, 1, NULL, '2021-03-04 07:23:04', '2021-03-04 07:23:04'),
(73, 'view_note', 'view_note', 13, 1, NULL, '2021-03-04 07:23:17', '2021-03-04 07:23:17'),
(74, 'new_note', 'new_note', 13, 1, NULL, '2021-03-04 07:23:31', '2021-03-04 07:23:31'),
(75, 'edit_note', 'edit_note', 13, 1, NULL, '2021-03-04 07:23:51', '2021-03-04 07:23:51'),
(76, 'delete_note', 'delete_note', 13, 1, NULL, '2021-03-04 07:24:05', '2021-03-04 07:24:05'),
(77, 'get_note', 'get_note', 13, 1, NULL, '2021-03-04 07:24:17', '2021-03-04 07:24:17'),
(78, 'setting', 'setting', 19, 1, NULL, '2021-03-04 07:35:22', '2021-03-04 07:35:22'),
(79, 'pending_task', 'pending_task', 9, 1, NULL, '2021-03-04 08:57:04', '2021-03-04 08:57:04');
-- --------------------------------------------------------
--
-- Table structure for table `permission_groups`
--
CREATE TABLE `permission_groups` (
`id` bigint UNSIGNED NOT NULL,
`group_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status` tinyint NOT NULL DEFAULT '0',
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `permission_groups`
--
INSERT INTO `permission_groups` (`id`, `group_name`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Permission group', 1, NULL, '2020-12-07 05:09:38', '2020-12-07 05:09:38'),
(2, 'Permission', 1, NULL, '2020-12-07 05:09:38', '2020-12-07 05:09:38'),
(3, 'UserGroup', 1, NULL, '2020-12-07 05:09:38', '2020-12-07 05:09:38'),
(4, 'Dashboard', 1, NULL, '2020-12-07 05:09:38', '2020-12-07 05:09:38'),
(5, 'Admin User', 1, NULL, '2020-12-07 05:09:38', '2020-12-07 05:09:38'),
(6, 'Listing', 1, NULL, NULL, NULL),
(8, 'Lead', 1, NULL, NULL, NULL),
(9, 'Task', 1, NULL, NULL, '2021-03-04 08:57:22'),
(12, 'Setting', 1, NULL, '2021-01-23 10:34:33', '2021-01-23 10:34:33'),
(13, 'Notes', 1, NULL, '2021-01-23 10:34:55', '2021-01-23 10:34:55'),
(14, 'Marketing', 1, NULL, '2021-01-23 10:35:10', '2021-01-23 10:35:10'),
(15, 'User Role', 1, NULL, '2021-03-04 06:55:09', '2021-03-04 06:55:09'),
(19, 'Web Settings', 1, NULL, '2021-03-04 07:18:02', '2021-03-04 07:18:02');
-- --------------------------------------------------------
--
-- Table structure for table `roles`
--
CREATE TABLE `roles` (
`id` bigint UNSIGNED NOT NULL,
`role_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`status` tinyint NOT NULL DEFAULT '0',
`created_by` int NOT NULL,
`edited_by` int NOT NULL,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `roles`
--
INSERT INTO `roles` (`id`, `role_name`, `status`, `created_by`, `edited_by`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Super admin', 1, 1, 1, '2020-03-04 06:42:11', '2020-03-04 06:42:11', '2017-03-12 16:42:11'),
(8, 'Admin', 1, 1, 1, '2020-03-04 06:42:11', '2020-03-04 06:42:11', NULL),
(12, 'Maneger', 1, 1, 1, NULL, '2020-10-07 05:02:37', '2021-01-23 08:44:08'),
(14, 'General Users', 1, 12, 1, NULL, '2021-03-03 07:00:20', '2021-03-03 07:00:31');
-- --------------------------------------------------------
--
-- Table structure for table `role_permission`
--
CREATE TABLE `role_permission` (
`id` bigint UNSIGNED NOT NULL,
`permissions` text COLLATE utf8mb4_unicode_ci NOT NULL,
`role_id` bigint UNSIGNED NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `role_permission`
--
INSERT INTO `role_permission` (`id`, `permissions`, `role_id`, `created_at`, `updated_at`) VALUES
(1, ',view_dashboard,view_role,edit_role,view_action,delete_action,', 1, '2020-12-07 05:09:39', '2020-12-07 05:09:39'),
(2, ',view_menu,new_menu,edit_menu,delete_menu,assign_user_access,view_action,new_action,edit_action,view_user_group,new_user_group,edit_user_group,delete_user_group,view_admin_user,add_admin_user,edit_admin_user,delete_admin_user,view_profile,change_password,update_user,view_listing,new_listing,edit_listing,delete_listing,view_project,new_project,edit_project,delete_project,view_lead,new_lead,edit_lead,delete_lead,search_lead,download_lead_pdf,download_lead_excel,import_lead,view_task,delete_task,edit_task,new_task,today_all_task,task_details,search_task,tomorrow_task,pendind_task,task_list,close_to_deal,my_task,my_today_task,my_pending_task,view_note,new_note,edit_note,delete_note,view_email,view_sms,view_message,view_email_template,view_role,add_role,edit_role,delete_role,setting,', 8, '2021-01-22 18:00:00', '2021-03-04 07:36:23'),
(3, ',view_admin_user,add_admin_user,edit_admin_user,view_profile,change_password,update_user,new_listing,edit_listing,view_lead,new_lead,edit_lead,delete_lead,view_note,new_note,edit_note,delete_note,get_note,view_email,view_sms,view_email_template,setting,', 12, '2021-01-22 18:00:00', '2021-03-04 07:52:21'),
(4, ',view_profile,change_password,update_user,view_task,delete_task,edit_task,new_task,today_all_task,task_details,search_task,tomorrow_task,close_to_deal,my_task,my_today_task,my_pending_task,pending_task,view_note,new_note,edit_note,delete_note,get_note,', 14, '2021-03-03 07:00:20', '2021-03-04 10:40:56');
-- --------------------------------------------------------
--
-- Table structure for table `tokens`
--
CREATE TABLE `tokens` (
`id` bigint UNSIGNED NOT NULL,
`auth_id` bigint UNSIGNED NOT NULL,
`user_type` tinyint NOT NULL DEFAULT '0',
`token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`client` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`is_expire` tinyint NOT NULL DEFAULT '0' COMMENT '0 = Alive, 0 = Expire',
`started_at` datetime NOT NULL,
`expire_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` bigint UNSIGNED NOT NULL,
`first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`middle_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`alt_mobile_no` varchar(14) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`designation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`auth_id` bigint UNSIGNED NOT NULL,
`gym_id` bigint UNSIGNED DEFAULT NULL,
`profile_pic` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`profile_pic_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`pic_mime_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_type` tinyint NOT NULL DEFAULT '0',
`status` tinyint NOT NULL DEFAULT '1',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `user_groups`
--
CREATE TABLE `user_groups` (
`id` int UNSIGNED NOT NULL,
`group_name` varchar(255) NOT NULL,
`ROLE_ID` int DEFAULT NULL,
`status` tinyint NOT NULL DEFAULT '0',
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`deleted_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC;
--
-- Dumping data for table `user_groups`
--
INSERT INTO `user_groups` (`id`, `group_name`, `ROLE_ID`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(7, 'Super User', 1, 1, '2021-01-02 12:12:37', '2021-01-02 12:28:39', '2021-01-02 12:12:37'),
(8, 'General Admin Group', 8, 1, '2021-01-02 12:13:10', '2021-01-02 12:28:53', '2021-01-02 12:13:10'),
(9, 'Sales Manger Group', 12, 1, '2021-01-02 12:13:38', '2021-01-02 12:13:38', '2021-01-02 12:13:38'),
(10, 'User', 13, 1, '2021-01-02 12:13:55', '2021-01-02 12:13:55', '2021-01-02 12:13:55'),
(11, 'General User', 14, 1, '2021-03-03 12:18:38', '2021-03-03 12:18:38', '2021-03-03 12:18:38');
-- --------------------------------------------------------
--
-- Table structure for table `web_abouts`
--
CREATE TABLE `web_abouts` (
`id` int NOT NULL,
`title` varchar(255) COLLATE utf8mb4_swedish_ci NOT NULL,
`about_description` text COLLATE utf8mb4_swedish_ci NOT NULL,
`about_summary` text COLLATE utf8mb4_swedish_ci,
`slider1` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`slider2` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`slider3` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`slider4` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`btn_link` varchar(255) COLLATE utf8mb4_swedish_ci DEFAULT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime DEFAULT NULL,
`created_by` tinyint DEFAULT NULL,
`updated_by` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_swedish_ci;
--
-- Dumping data for table `web_abouts`
--
INSERT INTO `web_abouts` (`id`, `title`, `about_description`, `about_summary`, `slider1`, `slider2`, `slider3`, `slider4`, `btn_link`, `created_at`, `updated_at`, `created_by`, `updated_by`) VALUES
(7, 'WE ALWAYS TRY TO MAKE OUR CLIENTS HAPPY', '\r\n At Runner Properties Ltd. our endeavor is to serve \r\nour customers with enthusiasm and dedication. We understand that for \r\nmany of us buying an apartment is one of the biggest decisions we may \r\never make. It’s a major financial commitment too. That’s why you need to\r\n take the right decision about whom to buy your apartment from. At RPL \r\nwe like to make it as easy as possible for you to buy your dream \r\napartment ‘your true living’.
\r\n Every single happy client is the soul of our business . RPL strives to serve the soul with our best. Happy and satisfied clients give us the sense of joy and fulfillment.
', '\r\nAt Runner Properties Ltd. our endeavor is to serve our customers with \r\nenthusiasm and dedication. We understand that for many of us buying an \r\napartment is one of the biggest decisions we may ever make. It’s a major\r\n financial commitment too. That’s why you need to take the right \r\ndecision about whom to buy your apartment from. At RPL we like to make \r\nit as easy as possible for you to buy your dream apartment ‘your true \r\nliving’.
\r\n
Every single happy client is the soul of our business. RPL strives to serve the soul with our best. Happy and satisfied clients give us the sense of joy and fulfillment.
\r\n
bdHousing has been the dominant frontier of online real estate marketplace \r\n for the last 17 years. Being the largest real estate portal in Bangladesh, bdHousing occupies a common \r\n platform for property owners, whether individual or company, to promote their properties for sell, rent, & \r\n property seekers, who are looking for property for sale in Bangladesh, to find their dream homes..
bdHousing has been the dominant frontier of online real estate marketplace \r\n for the last 17 years. Being the largest real estate portal in Bangladesh, bdHousing occupies a common \r\n platform for property owners, whether individual or company, to promote their properties for sell, rent, & \r\n property seekers, who are looking for property for sale in Bangladesh, to find their dream homes..
bdHousing has been the dominant frontier of online real estate marketplace \r\n for the last 17 years. Being the largest real estate portal in Bangladesh
', 'media/images/2021/01/pexels-photo-271624-5ff2d3700bf85.webp', 'WHO WE ARE', 'sub title', 'Arobil Ltd has started it’s journey in the year of 2015. After the glorious success in automobile and motor vehicle sector of Bangladesh and beyond, we came in real estate to bring Quality, Commitment, Service and safe investment for the people of our country. Since the inception we have been winning our clients hearts by ensuring timely handover of their desired living as the way we promised.
IN DESIGN, our philosophy is to work closely with our clients, carefully interpreting their particular needs and requirements. MORE AIR MORE LIGHT is the basic theme of every design. Then, after careful examination of the Construction site, its natural environment becomes the basis by which we can creatively fashion a harmonious dwelling uniquely suited to the Owner\'s taste. All the projects of Runner Properties Ltd. are designed by the professional and highly talented architects of Bangladesh.
IN CONSTRUCTION, we commit ourselves to provide the best possible quality adhering engineering codes of building development and RAJUK rules-regulations. We are committed to follow green technology which ensures no hazard to environment. Fully understanding modern building codes, openly working with local building officials and subcontractors as needed, and making that extra effort to keep communication and work flowing is our hallmark. Mostly, you will find that the spaces we create simply feel good, what we say “Your True Living”. This is the result of starting with a harmonious design, then skillfully applying personal care and attention to each and every detail.
understanding modern building codes, openly working with local building \r\nofficials and subcontractors as needed, and making that extra effort to \r\nkeep communication and work flowing is our hallmark. Mostly, you will \r\nfind that the spaces we create simply feel good, what we say “Your True \r\nLiving”. This is the result of starting with a harmonious design, then \r\nskillfully applying personal care and attention to each and every \r\ndetail.
', 'Our Objective', 'Arobil is committed to building long-term relationships based on integrity,\r\n performance, value, and client satisfaction. We will continue to meet \r\nthe changing needs of our clients with our exceptional services \r\ndelivered by the most qualified peop', 'media/images/2021/01/2dedf1ee70c8f7bcf03a1cb7da77cba9-5ff2f26599e7f.jpg', 0, 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `web_pages`
--
CREATE TABLE `web_pages` (
`id` int NOT NULL,
`title` varchar(255) COLLATE utf8mb4_swedish_ci NOT NULL,
`slug` varchar(255) COLLATE utf8mb4_swedish_ci NOT NULL,
`banner_image` varchar(255) COLLATE utf8mb4_swedish_ci NOT NULL,
`body` longtext COLLATE utf8mb4_swedish_ci NOT NULL,
`order_id` int NOT NULL,
`position` varchar(20) COLLATE utf8mb4_swedish_ci NOT NULL,
`status` tinyint(1) NOT NULL DEFAULT '1',
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime DEFAULT NULL,
`created_by` int DEFAULT NULL,
`updated_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_swedish_ci;
-- --------------------------------------------------------
--
-- Table structure for table `web_projects`
--
CREATE TABLE `web_projects` (
`id` int NOT NULL,
`title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
`project_slug` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`address` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`category` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
`project_status` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
`project_description` text COLLATE utf8mb4_general_ci,
`feature_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`pro_image` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
`thumbnail_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`status` tinyint DEFAULT NULL,
`created_by` tinyint DEFAULT NULL,
`updated_by` tinyint DEFAULT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Table structure for table `web_services`
--
CREATE TABLE `web_services` (
`id` int NOT NULL,
`service_image` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
`icon1` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
`title1` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
`description1` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
`icon2` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
`title2` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
`description2` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
`icon3` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
`title3` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
`description3` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
`icon4` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
`title4` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
`description4` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
`created_by` tinyint DEFAULT NULL,
`updated_by` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `web_services`
--
INSERT INTO `web_services` (`id`, `service_image`, `icon1`, `title1`, `description1`, `icon2`, `title2`, `description2`, `icon3`, `title3`, `description3`, `icon4`, `title4`, `description4`, `created_by`, `updated_by`) VALUES
(1, 'media/images/2021/01/architecture-1477041_1280-5ff2d9819297e.jpg', 'fa-wrench', 'On Time Delivery', 'We take it as a challenge and our success rate is 100%', 'fa-cogs', 'Construction Material', 'We believe in Louis Kahn’s quote ‘Architecture is the thoughtful making of space\'.', 'fa-wrench', 'Paramount Architecture', 'Best construction materials used for strongest structure', 'fa-cloud', 'Finest Fittings', 'Finest & Living friendly fittings for exceptional bathrooms and kitchens', NULL, 1);
-- --------------------------------------------------------
--
-- Table structure for table `web_teams`
--
CREATE TABLE `web_teams` (
`id` int NOT NULL,
`name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
`designation` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`photo` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`message` text COLLATE utf8mb4_general_ci,
`status` tinyint DEFAULT NULL,
`created_by` tinyint DEFAULT NULL,
`updated_by` tinyint DEFAULT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `web_teams`
--
INSERT INTO `web_teams` (`id`, `name`, `designation`, `photo`, `message`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'Md. Rezaul Karim', 'Chairman', 'media/images/2021/03/new-4-603e20ec9c072.jpg', '
Mr.Md. Rezaul Karim, born in 1977, is the Chairman of Arobil Group. He completed his Computer Science and Technology form UK. After completion of his education he started his career in a private organization name Arobil Limited in 1990 where he served till 1998. Then, he joined XactIdea Limited and served there till 2005 as Director Operation. Subsequently, he established Arobil Limited and is actively involved in the operations of the company.
He is one of the most experienced industrialists in the automobiles sector. Rezaul Karim has been selected as Commercially Important Person (CIP) for the period 2015-2016.
', 1, NULL, 1, '2020-12-15 18:44:17', NULL),
(7, 'Mr. Jeson Wasib', 'Vice Chairman', 'media/images/2021/03/new-pic-3-603e20f521595.jpg', 'Mr. Jeson Wasib, born in 1978, is the Vice Chairman of Arobil Group. He completed CSE form Canada. Upon completion of education he started his career in 1990 in Arobil Bangladesh Limited and worked there till 1995.
\r\nHe is one of the most experienced industrialists in the automobile and electronics sector.
', 1, NULL, 1, '2020-12-21 19:36:33', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `web_testimonials`
--
CREATE TABLE `web_testimonials` (
`id` int NOT NULL,
`name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`message` text COLLATE utf8mb4_general_ci,
`company_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`status` tinyint DEFAULT NULL,
`created_by` tinyint DEFAULT NULL,
`updated_by` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `web_testimonials`
--
INSERT INTO `web_testimonials` (`id`, `name`, `message`, `company_name`, `image`, `status`, `created_by`, `updated_by`) VALUES
(4, 'Client 2', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent feugiat nulla et aliquet finibus. Morbi feugiat neque lectus, nec tempor mi faucibus eget. Nullam feugiat velit sit amet sem congue consectetur.', 'bdHousing', 'media/images/2020/12/new-pic-one-5fdee051bd224.jpg', 1, NULL, 0),
(6, 'Client 4', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent feugiat nulla et aliquet finibus. Morbi feugiat neque lectus, nec tempor mi faucibus eget. Nullam feugiat velit sit amet sem congue consectetur.', 'Arobil', 'media/images/2020/12/new-4-5fdee0334de97.jpg', 1, NULL, 0),
(11, 'Client 1', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent feugiat nulla et aliquet finibus. Morbi feugiat neque lectus, nec tempor mi faucibus eget. Nullam feugiat velit sit amet sem congue consectetur.', 'NextGen', 'media/images/2021/03/new-4-603e1f4ce88ce.jpg', 1, 1, 0),
(12, 'Client 3', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent feugiat nulla et aliquet finibus. Morbi feugiat neque lectus, nec tempor mi faucibus eget. Nullam feugiat velit sit amet sem congue consectetur.', 'Horizon', 'media/images/2021/03/new-pic-tow-603e1fd6e7ec8.jpg', 1, 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `web_vision_missions`
--
CREATE TABLE `web_vision_missions` (
`id` int NOT NULL,
`title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`vision_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`vision_description` text COLLATE utf8mb4_general_ci,
`status` tinyint DEFAULT NULL,
`created_by` tinyint DEFAULT NULL,
`updated_by` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `web_vision_missions`
--
INSERT INTO `web_vision_missions` (`id`, `title`, `vision_image`, `vision_description`, `status`, `created_by`, `updated_by`) VALUES
(2, 'Vision', 'media/images/2021/01/logoAROfinal-5ff45d0d1abe0.png', 'We Will establish AROBIL as a trusted brand through satisfying \r\ncustomer’s need offering desired products & services at an \r\naffordable price.', 1, NULL, 1),
(3, 'Mission', 'media/images/2021/01/logoAROfinal-5ff45ebf3d9d1.png', '• Our Mission is to \r\nestablish our brand image by meeting customer requirement through \r\nenvironment friendly technology and taking care of return on investment \r\nof stakeholders.
\r\n
• We will materialize our vision with effective and efficient human \r\nresource using lean manufacturing process with high productivity.
\r\n
• We will exceed customer perceived value to make this world a better living.
\r\n
• Respect Customer’s feelings.
\r\n• Unite together as a team and celebrate success.
\r\n• No wastage is permissible.
\r\n• Never being complacent.
\r\n• Enjoy responsibility
\r\n• Recognize social and environmental awareness.
', 1, NULL, 1);
-- --------------------------------------------------------
--
-- Table structure for table `web_website_info`
--
CREATE TABLE `web_website_info` (
`id` int NOT NULL,
`name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
`title` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
`header_logo` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
`footer_logo` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
`address` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`email` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
`paypal_account` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
`currency` varchar(20) COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'USD',
`report_currency` int DEFAULT NULL,
`dollar_rate` double DEFAULT NULL,
`phone_no` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
`facebook` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
`twitter` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
`youtube` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
`instagram` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
`website` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
`meta_keywards` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`meta_title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`meta_description` text COLLATE utf8mb4_general_ci,
`meta_image` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`favicon` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
`copyright` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`header_top_color` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
`header_color` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
`status` tinyint DEFAULT NULL,
`created_by` tinyint NOT NULL,
`updated_by` tinyint DEFAULT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `web_website_info`
--
INSERT INTO `web_website_info` (`id`, `name`, `title`, `header_logo`, `footer_logo`, `address`, `email`, `paypal_account`, `currency`, `report_currency`, `dollar_rate`, `phone_no`, `facebook`, `twitter`, `youtube`, `instagram`, `website`, `meta_keywards`, `meta_title`, `meta_description`, `meta_image`, `favicon`, `copyright`, `header_top_color`, `header_color`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'DhakaSoftwares', 'DhakaSoftwares', 'media/images/2023/12/rony-logo-1-6576ccf8e319e.png', 'media/images/2023/12/rony-logo-1-6576ccf8e3335.png', 'Unit 10A, House 21, Road 17, Banani C/A, Dhaka 1213', 'info@dhakasoftwares.com', 'arobiloutsourcing@gmail.com', 'USD', 1, 110, '+8801767671133', NULL, NULL, NULL, NULL, NULL, 'DhakaSoftwares', 'DhakaSoftwares', 'Your Trusted Partner for Website, Apps Development & Digital Marketing Solutions! At Dhaka Softwares, we believe in turning your ideas into reality by harnessing the power of cutting-edge technology. As a leading software company, we specialize in providing top-notch website development and app development services tailored to meet your unique business requirements', NULL, NULL, 'coppyright, All Rights Reserved by dhakasoftwares- 2023
', '#60c11f', '#ffffff', 1, 16, NULL, '2020-12-17 10:39:34', NULL);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `admin_users`
--
ALTER TABLE `admin_users`
ADD PRIMARY KEY (`id`),
ADD KEY `admin_users_auth_id_foreign` (`auth_id`);
--
-- Indexes for table `auths`
--
ALTER TABLE `auths`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `auths_mobile_no_unique` (`mobile_no`),
ADD UNIQUE KEY `auths_username_unique` (`username`),
ADD UNIQUE KEY `auths_email_unique` (`email`);
--
-- Indexes for table `auth_role`
--
ALTER TABLE `auth_role`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `crm_area`
--
ALTER TABLE `crm_area`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `crm_categories`
--
ALTER TABLE `crm_categories`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `crm_city`
--
ALTER TABLE `crm_city`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `crm_countries`
--
ALTER TABLE `crm_countries`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `crm_currency`
--
ALTER TABLE `crm_currency`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `crm_follow_up`
--
ALTER TABLE `crm_follow_up`
ADD PRIMARY KEY (`pk_id`);
--
-- Indexes for table `crm_images`
--
ALTER TABLE `crm_images`
ADD PRIMARY KEY (`pk_id`);
--
-- Indexes for table `crm_lead_master`
--
ALTER TABLE `crm_lead_master`
ADD PRIMARY KEY (`pk_id`);
--
-- Indexes for table `crm_lead_priorities`
--
ALTER TABLE `crm_lead_priorities`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `crm_lead_status`
--
ALTER TABLE `crm_lead_status`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `crm_listings`
--
ALTER TABLE `crm_listings`
ADD PRIMARY KEY (`pk_id`);
--
-- Indexes for table `crm_milestone`
--
ALTER TABLE `crm_milestone`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `crm_notes`
--
ALTER TABLE `crm_notes`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `crm_project_source`
--
ALTER TABLE `crm_project_source`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `crm_requirements`
--
ALTER TABLE `crm_requirements`
ADD PRIMARY KEY (`pk_id`);
--
-- Indexes for table `crm_settings`
--
ALTER TABLE `crm_settings`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `crm_staff_increment`
--
ALTER TABLE `crm_staff_increment`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `crm_staff_master`
--
ALTER TABLE `crm_staff_master`
ADD PRIMARY KEY (`pk_id`);
--
-- Indexes for table `districts`
--
ALTER TABLE `districts`
ADD PRIMARY KEY (`id`),
ADD KEY `division_id` (`division_id`);
--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `gyms`
--
ALTER TABLE `gyms`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `income_expense`
--
ALTER TABLE `income_expense`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `income_expense_head`
--
ALTER TABLE `income_expense_head`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `invoices`
--
ALTER TABLE `invoices`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `job_applications`
--
ALTER TABLE `job_applications`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `lead_sources`
--
ALTER TABLE `lead_sources`
ADD PRIMARY KEY (`pk_id`);
--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `models`
--
ALTER TABLE `models`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
ADD KEY `password_resets_email_index` (`email`);
--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `name` (`name`),
ADD KEY `permissions_permission_group_id_foreign` (`permission_group_id`);
--
-- Indexes for table `permission_groups`
--
ALTER TABLE `permission_groups`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `role_permission`
--
ALTER TABLE `role_permission`
ADD PRIMARY KEY (`id`),
ADD KEY `role_permission_role_id_foreign` (`role_id`);
--
-- Indexes for table `tokens`
--
ALTER TABLE `tokens`
ADD PRIMARY KEY (`id`),
ADD KEY `tokens_auth_id_foreign` (`auth_id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`),
ADD KEY `users_auth_id_foreign` (`auth_id`),
ADD KEY `users_gym_id_foreign` (`gym_id`);
--
-- Indexes for table `user_groups`
--
ALTER TABLE `user_groups`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `web_abouts`
--
ALTER TABLE `web_abouts`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `web_clients`
--
ALTER TABLE `web_clients`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `web_counters`
--
ALTER TABLE `web_counters`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `web_custom_styles`
--
ALTER TABLE `web_custom_styles`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `web_home_slider`
--
ALTER TABLE `web_home_slider`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `web_our_stories`
--
ALTER TABLE `web_our_stories`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `web_pages`
--
ALTER TABLE `web_pages`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `web_projects`
--
ALTER TABLE `web_projects`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `web_services`
--
ALTER TABLE `web_services`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `web_teams`
--
ALTER TABLE `web_teams`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `web_testimonials`
--
ALTER TABLE `web_testimonials`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `web_vision_missions`
--
ALTER TABLE `web_vision_missions`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `web_website_info`
--
ALTER TABLE `web_website_info`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `admin_users`
--
ALTER TABLE `admin_users`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `auths`
--
ALTER TABLE `auths`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `auth_role`
--
ALTER TABLE `auth_role`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `crm_area`
--
ALTER TABLE `crm_area`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=206;
--
-- AUTO_INCREMENT for table `crm_categories`
--
ALTER TABLE `crm_categories`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
--
-- AUTO_INCREMENT for table `crm_city`
--
ALTER TABLE `crm_city`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT for table `crm_countries`
--
ALTER TABLE `crm_countries`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=244;
--
-- AUTO_INCREMENT for table `crm_currency`
--
ALTER TABLE `crm_currency`
MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `crm_follow_up`
--
ALTER TABLE `crm_follow_up`
MODIFY `pk_id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `crm_images`
--
ALTER TABLE `crm_images`
MODIFY `pk_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=140;
--
-- AUTO_INCREMENT for table `crm_lead_master`
--
ALTER TABLE `crm_lead_master`
MODIFY `pk_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=105;
--
-- AUTO_INCREMENT for table `crm_lead_priorities`
--
ALTER TABLE `crm_lead_priorities`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `crm_lead_status`
--
ALTER TABLE `crm_lead_status`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `crm_listings`
--
ALTER TABLE `crm_listings`
MODIFY `pk_id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `crm_milestone`
--
ALTER TABLE `crm_milestone`
MODIFY `id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `crm_notes`
--
ALTER TABLE `crm_notes`
MODIFY `id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `crm_project_source`
--
ALTER TABLE `crm_project_source`
MODIFY `id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `crm_requirements`
--
ALTER TABLE `crm_requirements`
MODIFY `pk_id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `crm_settings`
--
ALTER TABLE `crm_settings`
MODIFY `id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `crm_staff_increment`
--
ALTER TABLE `crm_staff_increment`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `crm_staff_master`
--
ALTER TABLE `crm_staff_master`
MODIFY `pk_id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `districts`
--
ALTER TABLE `districts`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;
--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `gyms`
--
ALTER TABLE `gyms`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `income_expense`
--
ALTER TABLE `income_expense`
MODIFY `id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `income_expense_head`
--
ALTER TABLE `income_expense_head`
MODIFY `id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `invoices`
--
ALTER TABLE `invoices`
MODIFY `id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
MODIFY `id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `job_applications`
--
ALTER TABLE `job_applications`
MODIFY `id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `lead_sources`
--
ALTER TABLE `lead_sources`
MODIFY `pk_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `models`
--
ALTER TABLE `models`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=80;
--
-- AUTO_INCREMENT for table `permission_groups`
--
ALTER TABLE `permission_groups`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `role_permission`
--
ALTER TABLE `role_permission`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `tokens`
--
ALTER TABLE `tokens`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `user_groups`
--
ALTER TABLE `user_groups`
MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `web_abouts`
--
ALTER TABLE `web_abouts`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `web_clients`
--
ALTER TABLE `web_clients`
MODIFY `id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `web_counters`
--
ALTER TABLE `web_counters`
MODIFY `id` tinyint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `web_custom_styles`
--
ALTER TABLE `web_custom_styles`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `web_home_slider`
--
ALTER TABLE `web_home_slider`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `web_our_stories`
--
ALTER TABLE `web_our_stories`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `web_pages`
--
ALTER TABLE `web_pages`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `web_projects`
--
ALTER TABLE `web_projects`
MODIFY `id` int NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `web_services`
--
ALTER TABLE `web_services`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `web_teams`
--
ALTER TABLE `web_teams`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `web_testimonials`
--
ALTER TABLE `web_testimonials`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `web_vision_missions`
--
ALTER TABLE `web_vision_missions`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `web_website_info`
--
ALTER TABLE `web_website_info`
MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `admin_users`
--
ALTER TABLE `admin_users`
ADD CONSTRAINT `admin_users_auth_id_foreign` FOREIGN KEY (`auth_id`) REFERENCES `auths` (`id`);
--
-- Constraints for table `permissions`
--
ALTER TABLE `permissions`
ADD CONSTRAINT `permissions_permission_group_id_foreign` FOREIGN KEY (`permission_group_id`) REFERENCES `permission_groups` (`id`) ON DELETE CASCADE;
--
-- Constraints for table `role_permission`
--
ALTER TABLE `role_permission`
ADD CONSTRAINT `role_permission_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);
--
-- Constraints for table `tokens`
--
ALTER TABLE `tokens`
ADD CONSTRAINT `tokens_auth_id_foreign` FOREIGN KEY (`auth_id`) REFERENCES `auths` (`id`);
--
-- Constraints for table `users`
--
ALTER TABLE `users`
ADD CONSTRAINT `users_auth_id_foreign` FOREIGN KEY (`auth_id`) REFERENCES `auths` (`id`),
ADD CONSTRAINT `users_gym_id_foreign` FOREIGN KEY (`gym_id`) REFERENCES `gyms` (`id`);
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;