/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.16-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: weblinkltd_mailcheck
-- ------------------------------------------------------
-- Server version	10.11.16-MariaDB

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES
(1,'2014_10_12_000000_create_users_table',1),
(2,'2014_10_12_100000_create_password_resets_table',1),
(3,'2019_08_19_000000_create_failed_jobs_table',1),
(4,'2019_12_14_000001_create_personal_access_tokens_table',1),
(5,'2023_01_03_062342_create_permission_tables',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `model_has_permissions`
--

DROP TABLE IF EXISTS `model_has_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `model_has_permissions`
--

LOCK TABLES `model_has_permissions` WRITE;
/*!40000 ALTER TABLE `model_has_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `model_has_permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `model_has_roles`
--

DROP TABLE IF EXISTS `model_has_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `model_has_roles`
--

LOCK TABLES `model_has_roles` WRITE;
/*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */;
INSERT INTO `model_has_roles` VALUES
(1,'App\\Models\\User',1),
(1,'App\\Models\\User',2),
(2,'App\\Models\\User',9),
(3,'App\\Models\\User',4),
(3,'App\\Models\\User',10),
(3,'App\\Models\\User',28),
(3,'App\\Models\\User',29),
(4,'App\\Models\\User',5),
(4,'App\\Models\\User',6),
(4,'App\\Models\\User',7),
(4,'App\\Models\\User',11),
(4,'App\\Models\\User',24),
(4,'App\\Models\\User',25),
(4,'App\\Models\\User',26),
(5,'App\\Models\\User',3),
(5,'App\\Models\\User',12),
(5,'App\\Models\\User',13),
(5,'App\\Models\\User',14),
(5,'App\\Models\\User',15),
(5,'App\\Models\\User',16),
(5,'App\\Models\\User',17),
(5,'App\\Models\\User',18),
(5,'App\\Models\\User',19),
(5,'App\\Models\\User',20),
(5,'App\\Models\\User',21),
(5,'App\\Models\\User',22),
(5,'App\\Models\\User',23),
(5,'App\\Models\\User',27),
(5,'App\\Models\\User',30),
(6,'App\\Models\\User',8);
/*!40000 ALTER TABLE `model_has_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_resets` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permissions`
--

LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
INSERT INTO `permissions` VALUES
(1,'site_survey','web','2023-01-08 01:45:49','2023-01-08 01:45:49'),
(2,'site_survey_create','web','2023-01-08 01:45:49','2023-01-08 01:45:49'),
(3,'site_survey_report_list','web','2023-01-08 01:45:49','2023-01-08 01:45:49'),
(4,'site_survey_form_list','web','2023-01-08 01:45:49','2023-01-08 01:45:49'),
(5,'client_add','web','2023-01-08 01:45:49','2023-01-08 01:45:49'),
(6,'customer_list','web','2023-01-08 01:45:49','2023-01-08 01:45:49'),
(7,'work_order','web','2023-01-08 01:45:49','2023-01-08 01:45:49'),
(8,'active_customer_list','web','2023-01-08 01:45:49','2023-01-08 01:45:49'),
(9,'discontinue_customer','web','2023-01-08 01:45:49','2023-01-08 01:45:49'),
(10,'customer_package','web','2023-01-08 01:45:49','2023-01-08 01:45:49'),
(18,'users','web','2023-01-08 01:45:49','2023-01-08 01:45:49'),
(19,'report','web','2023-01-08 01:45:49','2023-01-08 01:45:49');
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `personal_access_tokens`
--

DROP TABLE IF EXISTS `personal_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `personal_access_tokens`
--

LOCK TABLES `personal_access_tokens` WRITE;
/*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `role_has_permissions`
--

DROP TABLE IF EXISTS `role_has_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role_has_permissions`
--

LOCK TABLES `role_has_permissions` WRITE;
/*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */;
INSERT INTO `role_has_permissions` VALUES
(1,1),
(1,4),
(1,6),
(2,1),
(2,4),
(3,1),
(3,4),
(4,1),
(4,2),
(4,6),
(5,1),
(6,1),
(6,2),
(6,3),
(6,5),
(6,6),
(7,1),
(8,1),
(8,2),
(8,3),
(8,4),
(8,5),
(8,6),
(9,1),
(9,2),
(9,3),
(9,4),
(9,5),
(9,6),
(10,1),
(10,2),
(10,3),
(10,4),
(10,5),
(10,6),
(18,1),
(19,1);
/*!40000 ALTER TABLE `role_has_permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roles`
--

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES
(1,'Super Admin','web','2023-01-08 01:44:06','2023-01-08 01:44:06'),
(2,'Admin','web','2023-01-08 01:44:06','2023-01-08 01:44:06'),
(3,'Account','web','2023-01-08 01:44:06','2023-01-08 01:44:06'),
(4,'Marketing','web','2023-01-08 01:44:06','2023-01-08 01:44:06'),
(5,'Support','web','2023-01-08 01:44:06','2023-01-08 01:44:06'),
(6,'Infrastructure','web','2023-02-26 03:42:31','2023-02-26 03:42:34');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `site_servey_details`
--

DROP TABLE IF EXISTS `site_servey_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `site_servey_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `servey_id` int(11) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `service` varchar(55) DEFAULT NULL,
  `bandwidth` varchar(55) DEFAULT NULL,
  `modal_of_connectivity` varchar(100) DEFAULT NULL,
  `modal_of_connectivity_type` varchar(55) DEFAULT NULL,
  `latlong` varchar(255) DEFAULT NULL,
  `pop_name` varchar(255) DEFAULT NULL,
  `switch_port` varchar(255) DEFAULT NULL,
  `pop_activation_date` datetime DEFAULT NULL,
  `pop_config_user_id` int(11) DEFAULT NULL,
  `pop_3rd_party` text DEFAULT NULL,
  `ip_address` varchar(255) DEFAULT NULL,
  `ip_secondary` varchar(255) DEFAULT NULL,
  `switch_port_mode` varchar(255) DEFAULT NULL,
  `lan_ip` varchar(255) DEFAULT NULL,
  `nat_ip` varchar(255) DEFAULT NULL,
  `ip_vlan` varchar(255) DEFAULT NULL,
  `ip_activation_date` datetime DEFAULT NULL,
  `ip_config_user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `site_servey_details`
--

LOCK TABLES `site_servey_details` WRITE;
/*!40000 ALTER TABLE `site_servey_details` DISABLE KEYS */;
INSERT INTO `site_servey_details` VALUES
(1,1,'Gulshan','Internet','20 MB','Single','Fiber','20.22/33.44',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2,3,'Bashundhara','Internet & Data','20 MB , 10 MB','Dual','Fiber&Radio','23.5566/40.2344',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3,2,NULL,NULL,NULL,NULL,NULL,NULL,'POP BBB','45','2023-02-27 16:05:57',8,NULL,'19.66.88.01','19.66.77.08','Access Mode','4455','89','66','2023-03-05 17:11:55',21),
(5,7,'Banani','Internet','10 MB','Single','Fiber','23.5566/40.2344',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(6,8,'Gulshan','Internet','10 MB','Single','Fiber','20.44/25.33',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(7,9,'Banani','Internet','10 MB','Single','Fiber','23.5566/40.2344','POP BBB','MT-44','2023-03-05 12:43:27',8,'F@H','192.168.44.5','19.66.66.25','Trunk Mode','4466','95','77','2023-03-05 15:17:54',21);
/*!40000 ALTER TABLE `site_servey_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `site_servey_reports`
--

DROP TABLE IF EXISTS `site_servey_reports`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `site_servey_reports` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_survey_id` int(11) DEFAULT NULL,
  `site_survey_details_id` int(11) DEFAULT NULL,
  `nttn` varchar(100) DEFAULT NULL,
  `nearest_pop` varchar(255) DEFAULT NULL,
  `pop_location` varchar(255) DEFAULT NULL,
  `distance_from_pop` varchar(255) DEFAULT NULL,
  `required_equipment` varchar(255) DEFAULT NULL,
  `survey_note` text DEFAULT NULL,
  `selected` enum('Yes','No') DEFAULT 'No',
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `site_servey_reports`
--

LOCK TABLES `site_servey_reports` WRITE;
/*!40000 ALTER TABLE `site_servey_reports` DISABLE KEYS */;
INSERT INTO `site_servey_reports` VALUES
(1,3,2,'Fiber@Home','POP AAA','23.5566/40.2344','14','Fiber','Need Fiber','Yes',8,'2023-02-27 10:36:38'),
(2,7,5,'Fiber@Home','POP AAA','20.66/33.22','10','Fiber','Fiber','Yes',8,'2023-03-02 10:28:10'),
(3,9,7,'Fiber@Home','POP AAA','23.5566/40.2344','20','Fiber','Fiber','Yes',8,'2023-03-04 15:51:03');
/*!40000 ALTER TABLE `site_servey_reports` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `site_survey`
--

DROP TABLE IF EXISTS `site_survey`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `site_survey` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(100) NOT NULL,
  `cu_company` varchar(255) NOT NULL,
  `cu_name` varchar(255) DEFAULT NULL,
  `cu_contact_no` varchar(20) DEFAULT NULL,
  `cu_designation` varchar(50) DEFAULT NULL,
  `cu_address` varchar(255) DEFAULT NULL,
  `kam_id` int(11) DEFAULT NULL,
  `survey_status` int(11) NOT NULL DEFAULT 0,
  `new_customer` enum('Sent','survey_done','survey_team','work_order','accounts','md','support','active','infrastructure') DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `update_by` int(11) DEFAULT NULL,
  `update_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `create_by` int(11) DEFAULT NULL,
  `create_dt` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `site_survey`
--

LOCK TABLES `site_survey` WRITE;
/*!40000 ALTER TABLE `site_survey` DISABLE KEYS */;
INSERT INTO `site_survey` VALUES
(1,'2326020001','Customer with survey','Masud','0195677890','Asst. Manager',NULL,6,0,'survey_team','asdfasdfasdfasdfasdfasdfasdfasdfasdf',NULL,'2023-02-26 08:14:02',NULL,'2023-02-26 08:14:02'),
(2,'2326020002','Direct Customer',NULL,NULL,NULL,NULL,6,1,'active',NULL,NULL,'2023-02-26 08:15:12',NULL,'2023-02-26 08:15:12'),
(3,'2327020003','Rasel Fashion','Mr. Nava','01672315302','Manager',NULL,6,1,'accounts','Please process.',NULL,'2023-02-27 04:35:22',NULL,'2023-02-27 04:35:22'),
(4,'2302030004','Direct Customer Muked',NULL,NULL,NULL,NULL,7,1,'accounts',NULL,NULL,'2023-03-02 04:21:08',NULL,'2023-03-02 04:21:08'),
(5,'2302030005','Direct Customer Muked',NULL,NULL,NULL,NULL,7,1,'accounts',NULL,NULL,'2023-03-02 04:23:10',NULL,'2023-03-02 04:23:10'),
(6,'2302030006','Direct Customer Muked',NULL,NULL,NULL,NULL,7,1,'accounts',NULL,NULL,'2023-03-02 04:24:41',NULL,'2023-03-02 04:24:41'),
(7,'2302030007','Muked Fashion','Kabir Khan','01600000000','Manager',NULL,7,1,'accounts','Test',NULL,'2023-03-02 04:26:38',NULL,'2023-03-02 04:26:38'),
(8,'2304030008','Masud Group','Rana','01600000011','Manager',NULL,7,0,'survey_team','Survey please',NULL,'2023-03-04 04:14:15',NULL,'2023-03-04 04:14:15'),
(9,'2304030009','Saturday Fashion','Satuday','01992029433','Manager',NULL,7,1,'accounts','Test',NULL,'2023-03-04 07:14:04',NULL,'2023-03-04 07:14:04'),
(10,'2306030010','New Page Customer',NULL,NULL,NULL,NULL,7,1,'accounts',NULL,NULL,'2023-03-06 03:57:43',NULL,'2023-03-06 03:57:43'),
(11,'2306030011','Mail Check Customer',NULL,NULL,NULL,NULL,6,1,'accounts',NULL,NULL,'2023-03-06 06:26:21',NULL,'2023-03-06 06:26:21'),
(12,'2306030012','Mail Check Customer',NULL,NULL,NULL,NULL,6,1,'accounts',NULL,NULL,'2023-03-06 06:33:59',NULL,'2023-03-06 06:33:59'),
(13,'2306030013','Mail Check Customer',NULL,NULL,NULL,NULL,6,1,'accounts',NULL,NULL,'2023-03-06 06:34:20',NULL,'2023-03-06 06:34:20'),
(14,'2306030014','Testddddd',NULL,NULL,NULL,NULL,7,1,'accounts',NULL,NULL,'2023-03-06 08:17:39',NULL,'2023-03-06 08:17:39'),
(15,'2306030015','Direct Customer',NULL,NULL,NULL,NULL,7,1,'accounts',NULL,NULL,'2023-03-06 08:21:18',NULL,'2023-03-06 08:21:18'),
(16,'2306030016','Direct Customer Test Masud ABC',NULL,NULL,NULL,NULL,7,1,'accounts',NULL,NULL,'2023-03-06 08:27:15',NULL,'2023-03-06 08:27:15'),
(17,'2306030017','Direct Customer Test Masud ABC',NULL,NULL,NULL,NULL,7,1,'accounts',NULL,NULL,'2023-03-06 08:34:38',NULL,'2023-03-06 08:34:38'),
(18,'2306030018','Direct Customer Test Masud ABCdddd',NULL,NULL,NULL,NULL,7,1,'accounts',NULL,NULL,'2023-03-06 09:06:22',NULL,'2023-03-06 09:06:22');
/*!40000 ALTER TABLE `site_survey` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_area`
--

DROP TABLE IF EXISTS `tbl_area`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_area` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `short_name` varchar(10) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `station` int(11) NOT NULL DEFAULT 1 COMMENT '1:Dhaka; 2:Outside Dhaka',
  `create_by` int(11) DEFAULT NULL,
  `create_dt` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_area`
--

LOCK TABLES `tbl_area` WRITE;
/*!40000 ALTER TABLE `tbl_area` DISABLE KEYS */;
INSERT INTO `tbl_area` VALUES
(1,'Banani','Banani',1,1,1,'2020-11-02 17:24:16'),
(2,'Uttara','Uttara',1,1,1,'2020-11-02 17:24:16'),
(3,'Gazipur','Gazipur',1,2,1,'2020-11-02 17:26:15'),
(4,'Mawna','Mawna',1,2,1,'2020-11-02 17:26:15');
/*!40000 ALTER TABLE `tbl_area` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_customer_registration`
--

DROP TABLE IF EXISTS `tbl_customer_registration`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_customer_registration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(255) DEFAULT NULL,
  `survey_id` int(11) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `company_address` text DEFAULT NULL,
  `customer_type` int(11) DEFAULT NULL,
  `station_area` int(11) DEFAULT NULL,
  `area` int(11) DEFAULT NULL,
  `connectivity_address` text DEFAULT NULL,
  `billing_address` text DEFAULT NULL,
  `technical_name` varchar(255) DEFAULT NULL,
  `technical_designation` varchar(255) DEFAULT NULL,
  `technical_mobile` varchar(255) DEFAULT NULL,
  `technical_email` varchar(255) DEFAULT NULL,
  `accounts_name` varchar(255) DEFAULT NULL,
  `accounts_designation` varchar(255) DEFAULT NULL,
  `accounts_mobile` varchar(255) DEFAULT NULL,
  `accounts_email` varchar(255) DEFAULT NULL,
  `static_ip` varchar(255) DEFAULT NULL,
  `deadline_date` date DEFAULT NULL,
  `connection_date` date DEFAULT NULL,
  `billing_starting_date` date DEFAULT NULL,
  `bandwith` int(11) DEFAULT 0,
  `bandwith_price` int(11) DEFAULT 0,
  `youtube` int(11) DEFAULT 0,
  `youtube_price` int(11) DEFAULT 0,
  `facebook` int(11) DEFAULT 0,
  `facebook_price` int(11) DEFAULT 0,
  `bdix` int(11) DEFAULT 0,
  `bdix_price` int(11) DEFAULT 0,
  `data` int(11) DEFAULT 0,
  `data_price` int(11) DEFAULT 0,
  `total_amount` int(11) DEFAULT 0,
  `ip_address` varchar(255) DEFAULT NULL,
  `approval_level` enum('accounts','md','support','active','infrastructure') DEFAULT NULL,
  `status` tinyint(1) DEFAULT 0 COMMENT '1-active , 2-discontinue',
  `remarks_for_support` text DEFAULT NULL,
  `remarks_for_accounts` text DEFAULT NULL,
  `accounts_approved_date` datetime DEFAULT NULL,
  `management_approved_date` datetime DEFAULT NULL,
  `infrastructure_approved_date` datetime DEFAULT NULL,
  `infrastructure_processing` enum('Yes','No') DEFAULT 'No',
  `infrastructure_processing_userid` int(11) DEFAULT NULL,
  `support_approved_date` datetime DEFAULT NULL,
  `support_processing` enum('Yes','No') DEFAULT 'No',
  `support_processing_userid` int(11) DEFAULT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `accounts_approved_id` int(11) DEFAULT NULL,
  `management_approved_id` int(11) DEFAULT NULL,
  `support_approved_id` int(11) DEFAULT NULL,
  `infrastructure_approved_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_customer_registration`
--

LOCK TABLES `tbl_customer_registration` WRITE;
/*!40000 ALTER TABLE `tbl_customer_registration` DISABLE KEYS */;
INSERT INTO `tbl_customer_registration` VALUES
(1,'wcl-2602230001',2,'Direct Customer',NULL,2,1,NULL,'asdfasdfasdf','asdfasdfasdf','Moklesh','Engineer','01992029433','technical@gmail.com','Moklesh Khan','Asst. Manager','01992029444','accounts@gmail.com','/29','2023-02-26',NULL,'2023-03-01',120,100,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10000,NULL,'active',1,'Remarks for technician','Remarks for accounts','2023-02-26 15:10:36','2023-02-27 09:45:50',NULL,'Yes',NULL,'2023-03-05 17:11:55','Yes',NULL,'1677399312.png','2023-02-26 14:15:12',NULL,6,NULL,NULL,21,NULL),
(3,'wcl-2702230003',3,'Rasel Fashion',NULL,2,1,NULL,'Gulshan','Gulshan','Md. Mahmood','Enginner','01992029400','m.rahman@weblinkltd.com','Md. Mahmood','Enginner','01992029400','m.rahman@weblinkltd.com','/29','2023-02-15',NULL,'2023-03-01',100,100,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10000,NULL,'infrastructure',0,'Remarks for technician','Remarks for accounts','2023-02-27 12:51:52','2023-02-27 12:54:52',NULL,'No',8,NULL,'No',NULL,'1677478160.png','2023-02-27 12:09:20',NULL,6,NULL,NULL,NULL,NULL),
(6,'wcl-0203230006',6,'Direct Customer Muked',NULL,2,1,NULL,'Gulshan','Gulshan','Moklesh','Enginner','01992029400','m.rahman@weblinkltd.com','Md. Mahmood','Manager','01992029433','masud@weblinkltd.com','/29','2023-03-02',NULL,'2023-03-15',100,100,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10000,NULL,'active',1,NULL,NULL,NULL,NULL,NULL,'No',NULL,NULL,'No',NULL,'1677731081.png','2023-03-02 10:24:41',NULL,7,NULL,NULL,NULL,NULL),
(7,'wcl-0203230007',7,'Muked Fashion',NULL,2,1,NULL,'Banani','Banani','Md. Mahmood','Manager','01712345637','m.rahman@weblinkltd.com','Md. Mahmood','Manager','01712345637','m.rahman@weblinkltd.com','/29','2023-03-02',NULL,'2023-03-15',120,100,10,100,10,100,12,100,15,100,10000,NULL,'active',1,NULL,NULL,NULL,NULL,NULL,'No',NULL,NULL,'No',NULL,'1677733445.png','2023-03-02 11:04:05',NULL,7,NULL,NULL,NULL,NULL),
(9,'wcl-0603230009',10,'New Page Customer',NULL,3,2,NULL,'Gulshan','Gulshan','Md. Mahmood','Manager','01712345637','m.rahman@weblinkltd.com','Md. Mahmood','Manager','01712345637','m.rahman@weblinkltd.com','/29','2023-03-09',NULL,'2023-03-15',200,100,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,20000,NULL,'accounts',0,'adsfasdf','adsfasdf',NULL,NULL,NULL,'No',NULL,NULL,'No',NULL,'1678075063.png','2023-03-06 09:57:43',NULL,7,NULL,NULL,NULL,NULL),
(12,'wcl-0603230010',9,'Saturday Fashion',NULL,3,2,NULL,'aadsfasdfasdf','aadsfasdfasdf','Md. Mahmood','Enginner','01992029400','m.rahman@weblinkltd.com','Md. Mahmood','Enginner','01992029400','m.rahman@weblinkltd.com','/29','2023-03-08',NULL,'2023-03-15',100,200,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5555,NULL,'accounts',0,'Remarks for technical','Remarks for accounts',NULL,NULL,NULL,'No',NULL,NULL,'No',NULL,'1678078039.png','2023-03-06 10:47:19',NULL,7,NULL,NULL,NULL,NULL),
(13,'wcl-0603230013',11,'Mail Check Customer',NULL,2,1,NULL,'adsfasdf','adsfasdf','Md. Mahmood','Enginner','01992029400','m.rahman@weblinkltd.com','Md. Mahmood','Enginner','01992029400','m.rahman@weblinkltd.com',NULL,'2023-03-16',NULL,'2023-03-22',200,100,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5000,NULL,'accounts',0,'adsf','asdfasdf',NULL,NULL,NULL,'No',NULL,NULL,'No',NULL,'1678083981.PNG','2023-03-06 12:26:21',NULL,6,NULL,NULL,NULL,NULL),
(14,'wcl-0603230014',12,'Mail Check Customer',NULL,2,1,NULL,'adsfasdf','adsfasdf','Md. Mahmood','Enginner','01992029400','m.rahman@weblinkltd.com','Md. Mahmood','Enginner','01992029400','m.rahman@weblinkltd.com',NULL,'2023-03-16',NULL,'2023-03-22',200,100,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5000,NULL,'accounts',0,'adsf','asdfasdf',NULL,NULL,NULL,'No',NULL,NULL,'No',NULL,'1678084439.PNG','2023-03-06 12:33:59',NULL,6,NULL,NULL,NULL,NULL),
(15,'wcl-0603230015',13,'Mail Check Customer',NULL,2,1,NULL,'adsfasdf','adsfasdf','Md. Mahmood','Enginner','01992029400','m.rahman@weblinkltd.com','Md. Mahmood','Enginner','01992029400','m.rahman@weblinkltd.com',NULL,'2023-03-16',NULL,'2023-03-22',200,100,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5000,NULL,'accounts',0,'adsf','asdfasdf',NULL,NULL,NULL,'No',NULL,NULL,'No',NULL,'1678084460.PNG','2023-03-06 12:34:20',NULL,6,NULL,NULL,NULL,NULL),
(16,'wcl-0603230016',14,'Testddddd',NULL,2,1,NULL,'adsfasdfadsfasdfasf','adsfasdfadsfasdfasf','Moklesh','Engineer','01992029433','technical@gmail.com','Moklesh','Engineer','01992029433','technical@gmail.com','/29','2023-03-08',NULL,'2023-03-20',1000,100,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,100000,NULL,'accounts',0,'sdfgadfasdf','adfasdfasdfasdf',NULL,NULL,NULL,'No',NULL,NULL,'No',NULL,'1678090659.png','2023-03-06 14:17:39',NULL,7,NULL,NULL,NULL,NULL),
(17,'wcl-0603230017',15,'Direct Customer',NULL,2,1,NULL,'adfaasdfasdfasdf','adfaasdfasdfasdf','Moklesh','Engineer','01992029433','technical@gmail.com','Moklesh','Engineer','01992029433','technical@gmail.com',NULL,'2023-03-08',NULL,'2023-03-20',100,200,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10000,NULL,'accounts',0,'sdfasdf','asdfasd',NULL,NULL,NULL,'No',NULL,NULL,'No',NULL,'1678090878.png','2023-03-06 14:21:18',NULL,7,NULL,NULL,NULL,NULL),
(18,'wcl-0603230018',16,'Direct Customer Test Masud ABC',NULL,2,1,NULL,'dfasdfasdfasdf','dfasdfasdfasdf','MM','DD','01992029433','technical@gmail.com','MM','DD','01992029433','technical@gmail.com',NULL,'2023-03-08',NULL,'2023-03-21',1000,200,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,444444,NULL,'accounts',0,NULL,NULL,NULL,NULL,NULL,'No',NULL,NULL,'No',NULL,'1678091235.png','2023-03-06 14:27:15',NULL,7,NULL,NULL,NULL,NULL),
(19,'wcl-0603230019',17,'Direct Customer Test Masud ABC',NULL,2,1,NULL,'adfasdf','adfasdf','Moklesh','Engineer','01992029433','technical@gmail.com','Moklesh','Engineer','01992029433','technical@gmail.com',NULL,'2023-03-09',NULL,'2023-03-08',100,100,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4444,NULL,'accounts',0,NULL,NULL,NULL,NULL,NULL,'No',NULL,NULL,'No',NULL,'1678091678.png','2023-03-06 14:34:38',NULL,7,NULL,NULL,NULL,NULL),
(20,'wcl-0603230020',18,'Direct Customer Test Masud ABCdddd',NULL,2,1,NULL,'asdfasdfasdfasdf','asdfasdfasdfasdf','Moklesh','Engineer','01992029433','technical@gmail.com','Moklesh','Engineer','01992029433','technical@gmail.com',NULL,'2023-03-15',NULL,'2023-03-28',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,33333,NULL,'accounts',0,NULL,NULL,NULL,NULL,NULL,'No',NULL,NULL,'No',NULL,'1678093582.png','2023-03-06 15:06:22',NULL,7,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `tbl_customer_registration` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_customer_registration_dummy`
--

DROP TABLE IF EXISTS `tbl_customer_registration_dummy`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_customer_registration_dummy` (
  `cu_id` int(11) NOT NULL AUTO_INCREMENT,
  `cu_name` varchar(255) DEFAULT NULL,
  `cu_mobile` varchar(255) DEFAULT NULL,
  `area` int(11) NOT NULL,
  `ty_id` int(11) NOT NULL,
  `cu_company` varchar(255) NOT NULL,
  `cu_contactno` varchar(255) NOT NULL,
  `cu_email` varchar(255) NOT NULL,
  `cc_address` varchar(255) DEFAULT NULL,
  `cu_short_name` varchar(20) DEFAULT NULL,
  `cu_address` varchar(255) DEFAULT NULL,
  `cu_ip` varchar(30) DEFAULT NULL,
  `vat` int(11) DEFAULT 0,
  `cu_bandwith` int(11) NOT NULL DEFAULT 0,
  `cu_bandwith_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `cu_youtube` int(11) DEFAULT 0,
  `cu_youtube_price` decimal(10,2) DEFAULT 0.00,
  `cu_facebook` int(11) DEFAULT 0,
  `cu_facebook_price` decimal(10,2) DEFAULT 0.00,
  `cu_data` int(11) DEFAULT 0,
  `cu_data_price` decimal(10,2) DEFAULT 0.00,
  `cu_bdix` int(11) DEFAULT 0,
  `cu_bdix_price` decimal(10,2) DEFAULT 0.00,
  `customer_image` decimal(10,0) DEFAULT NULL,
  `station` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1:Dhaka; 2:Outside Dhaka',
  `index_no` int(120) DEFAULT 0,
  `connect_dt` date NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `approve_status` int(11) NOT NULL DEFAULT 0 COMMENT '0=marketing, 1=accounts, 2=md, 3=Support',
  `send_mail_status` tinyint(4) NOT NULL DEFAULT 0,
  `otc_status` tinyint(1) NOT NULL DEFAULT 0,
  `kam_id` int(11) NOT NULL,
  `update_by` int(11) DEFAULT 0,
  `update_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `create_by` int(11) DEFAULT NULL,
  `create_dt` datetime NOT NULL DEFAULT current_timestamp(),
  `servey_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`cu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_customer_registration_dummy`
--

LOCK TABLES `tbl_customer_registration_dummy` WRITE;
/*!40000 ALTER TABLE `tbl_customer_registration_dummy` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbl_customer_registration_dummy` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_customer_type`
--

DROP TABLE IF EXISTS `tbl_customer_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_customer_type` (
  `ty_id` int(11) NOT NULL AUTO_INCREMENT,
  `ty_name` varchar(255) NOT NULL,
  PRIMARY KEY (`ty_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_customer_type`
--

LOCK TABLES `tbl_customer_type` WRITE;
/*!40000 ALTER TABLE `tbl_customer_type` DISABLE KEYS */;
INSERT INTO `tbl_customer_type` VALUES
(1,'Home'),
(2,'Corporate'),
(3,'Reseller');
/*!40000 ALTER TABLE `tbl_customer_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_customer_updowngrade`
--

DROP TABLE IF EXISTS `tbl_customer_updowngrade`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_customer_updowngrade` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cu_bandwith` int(11) DEFAULT 0,
  `exiting_bandwith` int(11) DEFAULT 0,
  `cu_youtube` int(11) DEFAULT 0,
  `exiting_youtube` int(11) DEFAULT 0,
  `cu_facebook` int(11) DEFAULT 0,
  `exiting_facebook` int(11) DEFAULT 0,
  `cu_data` int(11) DEFAULT 0,
  `exiting_data` int(11) DEFAULT 0,
  `nttn_capacity` int(11) DEFAULT 0,
  `exiting_nttn_capacity` int(11) DEFAULT 0,
  `cu_bdix` int(11) DEFAULT 0,
  `exiting_bdix` int(11) DEFAULT 0,
  `cu_bandwith_price` int(11) DEFAULT 0,
  `cu_youtube_price` int(11) DEFAULT 0,
  `cu_facebook_price` int(11) DEFAULT 0,
  `cu_data_price` int(11) DEFAULT 0,
  `cu_bdix_price` int(11) DEFAULT 0,
  `exiting_bandwith_price` int(11) DEFAULT 0,
  `exiting_youtube_price` int(11) DEFAULT 0,
  `exiting_facebook_price` int(11) DEFAULT 0,
  `exiting_data_price` int(11) DEFAULT 0,
  `exiting_bdix_price` int(11) DEFAULT 0,
  `exiting_nttn_capacity_price` int(11) DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0:account; 1:support;2:done',
  `flag` varchar(45) DEFAULT NULL COMMENT 'new, 1:upgrade; 2:downgrade;\r\n3:discontinue;\r\n4:Temporary Up Grade;5:Temporary down Grade;',
  `temporary_date_start` date DEFAULT NULL,
  `temporary_date_end` date DEFAULT NULL,
  `discontinue_date` date DEFAULT NULL,
  `cu_id` int(11) NOT NULL,
  `accounts_approved_date` datetime DEFAULT NULL,
  `support_approved_date` datetime DEFAULT NULL,
  `effective_date` date DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `update_by` int(11) DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  `create_by` int(11) DEFAULT NULL,
  `create_dt` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_customer_updowngrade`
--

LOCK TABLES `tbl_customer_updowngrade` WRITE;
/*!40000 ALTER TABLE `tbl_customer_updowngrade` DISABLE KEYS */;
INSERT INTO `tbl_customer_updowngrade` VALUES
(1,100,0,NULL,0,NULL,0,NULL,0,0,0,NULL,0,100,NULL,NULL,NULL,NULL,0,0,0,0,0,0,2,'new',NULL,NULL,NULL,6,NULL,NULL,'2023-03-15','New Connection',NULL,NULL,7,'2023-03-02 10:24:41'),
(2,100,0,10,0,10,0,15,0,0,0,12,0,100,100,100,100,100,0,0,0,0,0,0,2,'new',NULL,NULL,NULL,7,NULL,NULL,'2023-03-15','New Connection',NULL,NULL,7,'2023-03-02 11:04:05'),
(3,120,0,NULL,0,NULL,0,NULL,0,0,0,NULL,0,100,NULL,NULL,NULL,NULL,0,0,0,0,0,0,2,'upgrade',NULL,NULL,NULL,7,NULL,NULL,'2023-03-30','Upgrade bandwidth',NULL,NULL,7,'2023-03-02 11:26:12'),
(4,80,0,NULL,0,NULL,0,NULL,0,0,0,NULL,0,100,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,'downgrade',NULL,NULL,NULL,7,NULL,NULL,'2023-03-22','Please process . Downgrade bandwidth',NULL,NULL,7,'2023-03-02 11:49:45'),
(5,120,0,NULL,0,NULL,0,NULL,0,0,0,NULL,0,100,NULL,NULL,NULL,NULL,0,0,0,0,0,0,2,'new',NULL,NULL,NULL,1,NULL,NULL,'2023-03-01','New Connection',NULL,NULL,6,'2023-03-05 17:11:55');
/*!40000 ALTER TABLE `tbl_customer_updowngrade` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_follow_up`
--

DROP TABLE IF EXISTS `tbl_follow_up`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_follow_up` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `office_address` varchar(255) NOT NULL,
  `territory` varchar(255) NOT NULL,
  `bus_type` varchar(255) NOT NULL,
  `con_person` varchar(255) NOT NULL,
  `designation` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `comment` varchar(255) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `c_date` date NOT NULL,
  `age` bigint(20) NOT NULL,
  `color` varchar(50) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `userid` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_follow_up`
--

LOCK TABLES `tbl_follow_up` WRITE;
/*!40000 ALTER TABLE `tbl_follow_up` DISABLE KEYS */;
INSERT INTO `tbl_follow_up` VALUES
(4,'BKC Sweater Ltd.','Plot No: 212-214, Dagerchala Main Road, Dagerchala, Gazipura 27, Gazipur.','HQ & Factory','Gazipura 27','Germens','Abdul Aowal','Asst Manager','aowel@bhcsweater.com','He will inform me as soon as possible.','01717341301','2023-01-04',2,'#FFC312',1,25,'2023-01-04 04:35:22','2023-01-04 04:36:13');
/*!40000 ALTER TABLE `tbl_follow_up` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `is_admin` smallint(2) DEFAULT 0,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(1,'Super Admin','milondiucse@gmail.com',NULL,'$2y$10$EFmSj8eyFbjILVsniv2B6eUa05KzHBTaCs6MCSX4hxuXb4fiGm0H.',0,NULL,'2023-01-08 01:43:23','2023-01-08 01:43:23'),
(2,'Masud Rana','masud@weblinkltd.com',NULL,'$2y$10$pEcb8LFgESCBiwyi/6qhJOdQOAVbzxRKj17pFqzsMazeNj5NXwhi2',1,NULL,'2023-01-08 01:51:09','2023-01-08 01:51:09'),
(6,'Md. Kabiruddin Rasel','kabir.rasel@weblinkltd.com',NULL,'$2y$10$Spn7XblKYTJsZzYkGhkuDelRRSQHjDOj8Ac8sO9ogUMAKBIWLguQa',0,NULL,'2023-01-10 21:45:26','2023-01-10 21:45:26'),
(7,'Abdul Muked','muked@weblinkltd.com',NULL,'$2y$10$m8OMMfAi9.bkHwzfDy2FluzoVa869E.Ijq6bdme1umH1C62yweV6a',0,NULL,'2023-01-10 21:46:03','2023-01-10 21:46:03'),
(8,'Md. Mokhlachor Rahman','m.rahman@weblinkltd.com',NULL,'$2y$10$sFP82L5G/ln/VTJP6mo.p.3O1n3uQu/bctxiyPJ6ZLTFHMiA1BR2e',0,NULL,'2023-01-10 21:46:37','2023-01-10 21:46:37'),
(9,'Rashedul Alam','rashed@weblinkltd.com',NULL,'$2y$10$wuSo2nTDHGyeOzuvPzAsfOz7hK2ixk7lghfw2dG7zBgc.G5J/FePW',0,NULL,'2023-01-10 21:47:11','2023-01-10 21:47:11'),
(10,'Accounts Department','accounts@weblinkltd.com',NULL,'$2y$10$sv/LZpWiFKHd0VTAlAyNGuCnYXOhQoYYo/ZCskZuEig4Mq3yVziXq',0,NULL,'2023-01-10 21:47:50','2023-01-10 21:47:50'),
(11,'Md. Towfiqul Islam','towfiq@weblinkltd.com',NULL,'$2y$10$sFP82L5G/ln/VTJP6mo.p.3O1n3uQu/bctxiyPJ6ZLTFHMiA1BR2e',0,NULL,'2023-01-10 21:46:37','2023-01-10 21:46:37'),
(12,'Md Momin Mia','momin@weblinkltd.com',NULL,'$2y$10$mMfABXrUW0nssM5kUEBMkeR1KBelfBBrmLjFI9mOv2qENOJWnjIOe',0,NULL,'2023-01-24 09:31:49','2023-01-24 09:31:49'),
(13,'Morshed Rana','morshed@weblinkltd.com',NULL,'$2y$10$Cb19Ik7zNz9zkAHkIhj/WOR.ExGurLGM3JxDRK5PZTGpn19D7TI8.',0,NULL,'2023-01-24 09:32:11','2023-01-24 09:32:11'),
(14,'Rumpa Saha','rumpa@weblinkltd.com',NULL,'$2y$10$HVtK43VeHzw5HVZei9WWxuTVS10t/CQ3ddik7qYfYlJiVoa1Ipum6',0,NULL,'2023-01-24 09:32:29','2023-01-24 09:32:29'),
(15,'Mahadi Hasan','mahadi@weblinkltd.com',NULL,'$2y$10$ZxvKAHQItrm7fQpzVstKWOHwt3CUc6SDTu1HsdnLnevCLVThUnnBe',0,NULL,'2023-01-24 09:32:49','2023-01-24 09:32:49'),
(16,'Rakibul Hasan','rakibul@weblinkltd.com',NULL,'$2y$10$uqVHLFmsM3RT6nxeyZAcCu.yZOLgAh.QwzuZIsf5qxbIRiv/iSfJm',0,NULL,'2023-01-24 09:33:19','2023-01-24 09:33:19'),
(17,'Sajib Sutradhar','sajib@weblinkltd.com',NULL,'$2y$10$fBV9jqbV3SoEQy3chKZ5Iu724x5AhXt6L5p4Kb0MipFYVbuyCccCS',0,NULL,'2023-01-24 09:33:50','2023-01-24 09:33:50'),
(18,'Abu Bakkar Siddique','siddique@weblinkltd.com',NULL,'$2y$10$dZ34RRZ.MG4AqLPAUVMBZu.uuZs590uTGncan9stLgwvnKrHo8VG.',0,NULL,'2023-01-24 09:34:09','2023-01-24 09:34:09'),
(19,'Ekranul Tanvir','tanvir@weblinkltd.com',NULL,'$2y$10$pMRKUz4Ne5ix5CdDGJa5Du83QUttdFahCcuqzT2TUGewpslVOmP5m',0,NULL,'2023-01-24 09:34:29','2023-01-24 09:34:29'),
(20,'Bijay Kumar Sharma(Rana)','rana@weblinkltd.com',NULL,'$2y$10$/KLyDRZZhgJW/uZ4gCwDhOfYCTkymVxopyOUr0lJxLoom1xc7XhQa',0,NULL,'2023-01-24 09:34:55','2023-01-24 09:34:55'),
(21,'Md. Azad Alam Bhuiyan','azad@weblinkltd.com',NULL,'$2y$10$4QDq8kOdWEuRsYEclyQ7bOVfOtCY467DE5xJw2VIJdmw9pBUQHYl.',0,NULL,'2023-01-24 09:35:14','2023-01-24 09:35:14'),
(22,'Arif Talukder','arif@weblinkltd.com',NULL,'$2y$10$6Tvcq081eoVD3o4Z21ozPuKzFwA7UEe5h95v61kBBfyBXTcW41q3O',0,NULL,'2023-01-24 09:35:45','2023-01-24 09:35:45'),
(23,'Salim Dewan','salim@weblinkltd.com',NULL,'$2y$10$abI6EM6KK7KwyVQ3Cu7RCO1MrxUBNCf/eDkqq2p48ld1lNW20YCEq',0,NULL,'2023-01-24 09:36:06','2023-01-24 09:36:06'),
(24,'Mahamudul Hasan','hasan@weblinkltd.com',NULL,'$2y$10$L2ukHgeqDJrh28NXRPdWce1zzaAgoiRZPDoqiqRjlnubhVYkThNVS',0,NULL,'2023-01-24 09:36:31','2023-01-24 09:36:31'),
(25,'Anis','anis@weblinkltd.com',NULL,'$2y$10$iVdL7Z7ZQvRPI5DaGBfzGex6szzX7KoojVF5UqBe3siAa7/ny41AK',0,NULL,'2023-01-24 09:36:51','2023-01-24 09:36:51'),
(26,'Nayan Chowdhury','nayan@weblinkltd.com',NULL,'$2y$10$wFfDhDUTV9LsSrWMlH/sS.S1IJQgcKkPtz2E7nkn4DN6SdbDe50ba',0,NULL,'2023-01-24 09:37:14','2023-01-24 09:37:14'),
(27,'Test','test@weblinkltd.com',NULL,'$2y$10$J5zEEUEp4V1rTxWvvKodeO3rq.jOSDopbtyg4fNyApQxoijT1s1pK',0,NULL,'2023-01-26 08:50:42','2023-01-26 08:50:42'),
(28,'Nazmul Hasan','nazmul.accounts@weblinkltd.com',NULL,'$2y$10$Bu9iQxxc.8l3pAn4ejAtbevDxv99f34EmMomebaF.Z2xLMhBLAWDu',0,NULL,'2023-02-16 05:30:44','2023-02-16 05:30:44'),
(29,'Shanara Akter','shanara@weblinkltd.com',NULL,'$2y$10$AEIauMj578ayjaK2dejDgOWmhGXjB0V8WTajFSfGVoiwOfhuvhC7W',0,NULL,'2023-02-16 06:37:00','2023-02-16 06:37:00'),
(30,'Mithun','mithun@weblinkltd.com',NULL,'$2y$10$Oc81pManrwxoyP6gsFDn2ebRYX5xXvM3iOdzwy77/VnZHMg3OkZiO',0,NULL,'2023-02-28 04:04:44','2023-02-28 04:04:44');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-05-05 15:29:56
