/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.16-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: weblinkltd_domainhostings
-- ------------------------------------------------------
-- 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 `domains_add`
--

DROP TABLE IF EXISTS `domains_add`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `domains_add` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dm_name` varchar(255) NOT NULL,
  `dm_create_date` date NOT NULL,
  `dm_expire_date` date NOT NULL,
  `owner_name` varchar(255) NOT NULL,
  `phone` varchar(16) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `dm_price` int(20) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `email_remainder` varchar(5) NOT NULL,
  `sms_remainder` varchar(5) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `domains_add`
--

LOCK TABLES `domains_add` WRITE;
/*!40000 ALTER TABLE `domains_add` DISABLE KEYS */;
INSERT INTO `domains_add` VALUES
(4,'3fcleaning.com','2022-10-23','2024-09-23','fcleaning','01992029432','accounts@weblinkltd.com','Dhaka',4000,1,'Yes','No','2024-01-05 14:09:44','2024-01-05 14:26:29'),
(5,'alphayogasociety.com','2021-11-12','2024-10-12','bdays','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 14:26:15','2024-01-05 14:26:15'),
(6,'anisconsultant.com','2022-01-17','2024-01-12','anisconsultant','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 14:31:01','2024-01-05 14:31:01'),
(7,'bfkdc.edu.bd','2021-12-23','2024-11-23','bfkdcedu','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 14:33:01','2024-01-05 14:33:01'),
(8,'bridgechemie.com','2021-12-01','2026-01-01','bridgechemie','01992029410','accounts@weblinkltd.com','Dhaka',11,1,'Yes','Yes','2024-01-05 14:50:24','2025-12-08 05:36:11'),
(9,'dhalyinfratech.com','2021-01-14','2026-01-11','dhaly(Hosting)','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 14:54:36','2025-07-31 04:11:55'),
(10,'digitaltechnet.net','2022-11-28','2026-11-28','digitaltechnet','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 15:10:17','2025-11-30 05:12:28'),
(11,'firstsolutions.com.bd','2021-09-21','2024-09-01','firstsolutionsco','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 15:12:11','2024-01-05 15:12:11'),
(12,'galleryclubs.com','2023-07-09','2026-01-01','galleryclubs','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','Yes','2024-01-05 15:13:45','2026-01-18 03:34:04'),
(13,'globalgateways.com.bd','2021-09-04','2024-08-04','globalgatewaysco','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'No','No','2024-01-05 15:15:30','2024-01-06 15:20:43'),
(14,'hariarchana.org','2022-12-29','2026-12-01','hariarchana(Lushine)','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 15:17:00','2025-11-30 05:20:21'),
(15,'knithorizon.com','2022-04-03','2026-03-25','knithori','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 15:18:23','2025-11-30 05:21:11'),
(16,'knithorizon1.com','2023-07-21','2026-06-26','knithorizon1','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 15:19:50','2025-11-30 05:19:38'),
(17,'multazimgroup.com','2022-05-14','2026-05-14','ctrlmzgp','01992029410','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 15:51:08','2025-07-31 04:07:28'),
(18,'nurhomesltd.com','2021-11-13','2024-10-13','bdnurhomes','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 15:52:32','2024-01-05 15:52:32'),
(19,'raywhiteltd.com','2023-11-26','2026-10-26','raywhiteltd','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 15:53:56','2025-11-30 05:19:16'),
(20,'saiham.com','2022-03-30','2026-03-29','bdsaiham','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 15:55:42','2026-02-01 11:17:15'),
(21,'sujabd.com','2021-12-01','2024-11-01','sujabd','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 15:58:37','2024-01-05 15:58:37'),
(22,'sunwaygroupbd.com','2021-11-12','2024-10-12','bdsunwaygroup','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 16:01:04','2024-01-05 16:01:04'),
(23,'telewirebd.net','2022-06-29','2025-06-01','telewirebd','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 16:02:54','2024-07-02 08:26:48'),
(24,'theapparelgiant.com','2023-01-17','2024-12-17','theapparelgiant','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 16:04:19','2024-01-05 16:04:19'),
(25,'thfashionbd.com','2023-01-23','2024-12-23','thfashionbd','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 16:05:29','2024-01-05 16:05:29'),
(26,'thsict.edu.bd','2021-12-23','2024-11-23','thsictedu','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 16:06:33','2024-01-05 16:06:33'),
(27,'tismbd.org','2023-12-13','2024-11-13','wwwtismbd','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 16:08:02','2024-01-05 16:08:02'),
(28,'weblinkltd.com','2022-06-17','2026-07-01','bdweblinkltd','01992029410','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 16:09:27','2025-07-31 04:13:36'),
(29,'weblinkltd.net','2022-01-19','2027-01-18','weblink','01992029410','accounts@weblinkltd.com','Dhaka',19,1,'Yes','Yes','2024-01-05 16:10:26','2026-01-19 10:47:33'),
(30,'weblinkltd.xyz','2021-09-02','2026-08-09','weblinkltd','01992029410','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 16:11:29','2025-07-31 04:09:27'),
(31,'youniformbd.com','2022-11-17','2026-10-17','youniformbd','01992029432','accounts@weblinkltd.com','Dhaka',15,1,'Yes','No','2024-01-05 16:13:31','2025-11-30 05:20:41'),
(32,'Cpanel','2024-01-01','2025-01-31','Cpanel','01992029432','accounts@weblinkltd.com','Dhaka',4500,1,'Yes','No','2024-01-11 03:38:47','2024-07-02 08:24:04'),
(33,'Apnic','2023-11-01','2025-10-01','weblinkltd','01992029432','accounts@weblinkltd.com','Dhaka',1186,1,'Yes','No','2024-01-11 03:46:02','2025-07-31 04:02:02'),
(34,'Apnic','2023-12-24','2025-12-08','Mofent','01992029432','accounts@weblinkltd.com','Dhaka',1186,1,'Yes','No','2024-01-11 03:48:27','2025-11-30 05:18:50'),
(35,'www.hasansalma.com','2025-08-12','2026-08-11','Mr. Numan Ahmed ( IT Manager of Saiham Cotton)','01992029410','accounts@weblinkltd.com','Dhaka',12,1,'Yes','Yes','2025-08-14 05:55:43','2025-11-30 05:18:34');
/*!40000 ALTER TABLE `domains_add` ENABLE KEYS */;
UNLOCK TABLES;

--
-- 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 `hostings_add`
--

DROP TABLE IF EXISTS `hostings_add`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `hostings_add` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ht_create_date` date NOT NULL,
  `ht_expire_date` date NOT NULL,
  `owner_name` varchar(255) NOT NULL,
  `phone` varchar(16) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `remark` varchar(255) NOT NULL,
  `ht_price` int(20) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `email_remainder` varchar(5) NOT NULL,
  `sms_remainder` varchar(5) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hostings_add`
--

LOCK TABLES `hostings_add` WRITE;
/*!40000 ALTER TABLE `hostings_add` DISABLE KEYS */;
INSERT INTO `hostings_add` VALUES
(2,'2023-12-01','2024-02-03','kafi','01300432338','alkafi000@gmail.com','dhakka','kfsjfklsf',1000,1,'Yes','No','2024-01-03 11:40:48','2024-01-03 11:40:48'),
(4,'2023-12-01','2024-02-04','Global Gateway','01624646670','shanara.accounts@weblinkltd.com','Dhaka','Please Let Me Know',6000,1,'Yes','No','2024-01-04 10:07:24','2024-01-04 10:07:24'),
(5,'2023-08-01','2024-02-04','Syneries','01624646670','shanara.accounts@weblinkltd.com','Dhaka','Please Let Me Know',6000,1,'Yes','No','2024-01-04 10:08:57','2024-01-04 10:08:57');
/*!40000 ALTER TABLE `hostings_add` 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=5 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);
/*!40000 ALTER TABLE `migrations` 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 `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,
  `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 `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,
  `mobile` varchar(20) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `type` enum('Admin','User','Head') NOT NULL DEFAULT 'User',
  `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=13 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,'Md. Masud Rana','masud@weblinkltd.com','',NULL,'$2y$10$GdkzS/tl5Z1LgvmaiYU8P.OmXl6q87vu0HS2/c1X.WBRBLmwCB.La','Admin',NULL,'2022-06-20 22:24:27','2022-06-20 22:24:27'),
(8,'Accounts','accounts@weblinkltd.com','',NULL,'$2y$10$wog.7tNJOHbwKlWFfg8u8OAe4w9bFbdym6HpqtoTEcv8Il15mWpNi','Admin',NULL,'2022-06-20 22:24:27','2022-06-20 22:24:27'),
(9,'Kafi','kafi@weblinkltd.com','',NULL,'$2y$10$GdkzS/tl5Z1LgvmaiYU8P.OmXl6q87vu0HS2/c1X.WBRBLmwCB.La','Admin',NULL,NULL,NULL),
(10,'Accounts','nazmul.accounts@weblinkltd.com','',NULL,'$2y$10$GdkzS/tl5Z1LgvmaiYU8P.OmXl6q87vu0HS2/c1X.WBRBLmwCB.La','Admin',NULL,'2022-06-20 22:24:27','2022-06-20 22:24:27'),
(11,'Shanara Akter','shanara@weblinkltd.com','',NULL,'$2y$10$GdkzS/tl5Z1LgvmaiYU8P.OmXl6q87vu0HS2/c1X.WBRBLmwCB.La','Admin',NULL,'2023-02-15 22:24:27','2023-02-15 22:24:27'),
(12,'adminxps','budaklzcrew@gmail.com','',NULL,'$2y$10$kD/26e62Vurs2a1rswq0rO4DCgHdAehG.Ufn/F1KWeUSlDtEFHXsS','User',NULL,'2025-12-21 21:27:45','2025-12-21 21:27:45');
/*!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-03 10:38:02
