-- MySQL dump 10.13 Distrib 8.0.46, for Win64 (x86_64) -- -- Host: 127.0.0.1 Database: xbspi -- ------------------------------------------------------ -- Server version 8.0.46 /*!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 */; /*!50503 SET NAMES utf8 */; /*!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 `batches` -- DROP TABLE IF EXISTS `batches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `batches` ( `id` char(36) NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `batch` (`batch`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `batches` -- LOCK TABLES `batches` WRITE; /*!40000 ALTER TABLE `batches` DISABLE KEYS */; INSERT INTO `batches` VALUES ('a0cdeec6-9ff2-11f1-87a3-e8d8d1a2cb0a',1),('a0cdf211-9ff2-11f1-87a3-e8d8d1a2cb0a',2),('a0cdf3b9-9ff2-11f1-87a3-e8d8d1a2cb0a',3),('a0cdf43f-9ff2-11f1-87a3-e8d8d1a2cb0a',4),('a0cdf4af-9ff2-11f1-87a3-e8d8d1a2cb0a',5),('a0cdf519-9ff2-11f1-87a3-e8d8d1a2cb0a',6),('a0cdf580-9ff2-11f1-87a3-e8d8d1a2cb0a',7),('a0cdf5e7-9ff2-11f1-87a3-e8d8d1a2cb0a',8),('a0cdf652-9ff2-11f1-87a3-e8d8d1a2cb0a',9),('a0cdf6b8-9ff2-11f1-87a3-e8d8d1a2cb0a',10),('a0cdf722-9ff2-11f1-87a3-e8d8d1a2cb0a',11),('a0cdf786-9ff2-11f1-87a3-e8d8d1a2cb0a',12),('a0cdf7f2-9ff2-11f1-87a3-e8d8d1a2cb0a',13),('a0cdf857-9ff2-11f1-87a3-e8d8d1a2cb0a',14),('a0cdf8bc-9ff2-11f1-87a3-e8d8d1a2cb0a',15),('a0cdf92a-9ff2-11f1-87a3-e8d8d1a2cb0a',16),('a0cdf999-9ff2-11f1-87a3-e8d8d1a2cb0a',17),('a0cdfa02-9ff2-11f1-87a3-e8d8d1a2cb0a',18),('a0cdfa68-9ff2-11f1-87a3-e8d8d1a2cb0a',19),('a0cdfacc-9ff2-11f1-87a3-e8d8d1a2cb0a',20),('a0cdfb2f-9ff2-11f1-87a3-e8d8d1a2cb0a',21),('a0cdfb96-9ff2-11f1-87a3-e8d8d1a2cb0a',22),('a0cdfbfb-9ff2-11f1-87a3-e8d8d1a2cb0a',23),('a0cdfc5c-9ff2-11f1-87a3-e8d8d1a2cb0a',24),('a0cdfce9-9ff2-11f1-87a3-e8d8d1a2cb0a',25),('a0cdfe46-9ff2-11f1-87a3-e8d8d1a2cb0a',26),('a0cdfeec-9ff2-11f1-87a3-e8d8d1a2cb0a',27),('a0cdff53-9ff2-11f1-87a3-e8d8d1a2cb0a',28),('a0cdffb7-9ff2-11f1-87a3-e8d8d1a2cb0a',29),('a0ce001c-9ff2-11f1-87a3-e8d8d1a2cb0a',30),('a0ce0089-9ff2-11f1-87a3-e8d8d1a2cb0a',31),('a0ce00ec-9ff2-11f1-87a3-e8d8d1a2cb0a',32),('a0ce014e-9ff2-11f1-87a3-e8d8d1a2cb0a',33),('a0ce01af-9ff2-11f1-87a3-e8d8d1a2cb0a',34),('a0ce0217-9ff2-11f1-87a3-e8d8d1a2cb0a',35),('a0ce0279-9ff2-11f1-87a3-e8d8d1a2cb0a',36),('a0ce02dc-9ff2-11f1-87a3-e8d8d1a2cb0a',37),('a0ce033e-9ff2-11f1-87a3-e8d8d1a2cb0a',38),('a0ce03a4-9ff2-11f1-87a3-e8d8d1a2cb0a',39),('a0ce0406-9ff2-11f1-87a3-e8d8d1a2cb0a',40),('a0ce046d-9ff2-11f1-87a3-e8d8d1a2cb0a',41),('a0ce04d2-9ff2-11f1-87a3-e8d8d1a2cb0a',42),('a0ce0536-9ff2-11f1-87a3-e8d8d1a2cb0a',43),('a0ce0597-9ff2-11f1-87a3-e8d8d1a2cb0a',44),('a0ce05fa-9ff2-11f1-87a3-e8d8d1a2cb0a',45),('a0ce065d-9ff2-11f1-87a3-e8d8d1a2cb0a',46),('a0ce06c4-9ff2-11f1-87a3-e8d8d1a2cb0a',47),('a0ce0728-9ff2-11f1-87a3-e8d8d1a2cb0a',48),('a0ce079e-9ff2-11f1-87a3-e8d8d1a2cb0a',49),('a0ce08ad-9ff2-11f1-87a3-e8d8d1a2cb0a',50),('a0ce091b-9ff2-11f1-87a3-e8d8d1a2cb0a',51),('a0ce0982-9ff2-11f1-87a3-e8d8d1a2cb0a',52),('a0ce09e8-9ff2-11f1-87a3-e8d8d1a2cb0a',53),('a0ce0a49-9ff2-11f1-87a3-e8d8d1a2cb0a',54),('a0ce0aac-9ff2-11f1-87a3-e8d8d1a2cb0a',55),('a0ce0b0c-9ff2-11f1-87a3-e8d8d1a2cb0a',56),('a0ce0b70-9ff2-11f1-87a3-e8d8d1a2cb0a',57),('a0ce0bd5-9ff2-11f1-87a3-e8d8d1a2cb0a',58),('a0ce0c39-9ff2-11f1-87a3-e8d8d1a2cb0a',59),('a0ce0c9d-9ff2-11f1-87a3-e8d8d1a2cb0a',60),('a0ce0d04-9ff2-11f1-87a3-e8d8d1a2cb0a',61),('a0ce0d68-9ff2-11f1-87a3-e8d8d1a2cb0a',62),('a0ce0ded-9ff2-11f1-87a3-e8d8d1a2cb0a',63); /*!40000 ALTER TABLE `batches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `blog_comment_likes` -- DROP TABLE IF EXISTS `blog_comment_likes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `blog_comment_likes` ( `id` char(36) NOT NULL, `commentId` char(36) NOT NULL, `authorEmail` varchar(150) NOT NULL, `createdAt` datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `unique_comment_like` (`commentId`,`authorEmail`), KEY `idx_comment_likes_comment` (`commentId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `blog_comment_likes` -- LOCK TABLES `blog_comment_likes` WRITE; /*!40000 ALTER TABLE `blog_comment_likes` DISABLE KEYS */; INSERT INTO `blog_comment_likes` VALUES ('b06268bd-801f-4d14-8249-0fb4c323584a','a5822028-e257-4d94-92d5-074c01bf3d5b','rihanthedev@gmail.com','2026-09-19 21:49:12'),('de30e7d2-2d92-4031-998c-26c87614a066','comment-id','another@example.com','2026-09-19 21:52:29'); /*!40000 ALTER TABLE `blog_comment_likes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `blog_comment_replies` -- DROP TABLE IF EXISTS `blog_comment_replies`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `blog_comment_replies` ( `id` char(36) NOT NULL, `postId` char(36) NOT NULL, `commentId` char(36) NOT NULL, `authorEmail` varchar(150) NOT NULL, `comment` text NOT NULL, `createdAt` datetime DEFAULT CURRENT_TIMESTAMP, `updatedAt` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_replies_comment` (`commentId`), KEY `idx_replies_post` (`postId`), KEY `idx_replies_author` (`authorEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `blog_comment_replies` -- LOCK TABLES `blog_comment_replies` WRITE; /*!40000 ALTER TABLE `blog_comment_replies` DISABLE KEYS */; INSERT INTO `blog_comment_replies` VALUES ('5c172b34-875a-4fc0-b833-472f8a42f436','ac188183-3101-4ce8-8e51-27a05c62997e','a5822028-e257-4d94-92d5-074c01bf3d5b','rihanthedev@gmail.com','Yes, I completely agree.','2026-09-19 21:53:31','2026-09-19 21:53:31'),('b0fc0021-228f-4989-9f5b-dcf32aeb9071','ac188183-3101-4ce8-8e51-27a05c62997e','a5822028-e257-4d94-92d5-074c01bf3d5b','rihanthedev@gmail.com','Yes, I completely agree. by postman','2026-09-19 21:53:45','2026-09-19 21:53:45'),('e8dee566-2b03-49cc-8749-8ba2551189ed','ac188183-3101-4ce8-8e51-27a05c62997e','a5822028-e257-4d94-92d5-074c01bf3d5b','rihanthedev@gmail.com','Yes, I completely agree.','2026-09-19 21:53:34','2026-09-19 21:53:34'); /*!40000 ALTER TABLE `blog_comment_replies` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `blog_comments` -- DROP TABLE IF EXISTS `blog_comments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `blog_comments` ( `id` char(36) NOT NULL, `postId` char(36) NOT NULL, `authorEmail` varchar(150) NOT NULL, `comment` text NOT NULL, `createdAt` datetime DEFAULT CURRENT_TIMESTAMP, `updatedAt` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_comments_post` (`postId`), KEY `idx_comments_author` (`authorEmail`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `blog_comments` -- LOCK TABLES `blog_comments` WRITE; /*!40000 ALTER TABLE `blog_comments` DISABLE KEYS */; INSERT INTO `blog_comments` VALUES ('0b9a5cc3-af9a-4aed-bc59-ab0bdb359386','ac188183-3101-4ce8-8e51-27a05c62997e','rihanthedev@gmail.comm','this is testing comment by postman... ','2026-09-19 21:46:36','2026-09-19 21:46:36'),('31927eb0-9dad-4727-8b4f-cf40c91d34dc','ac188183-3101-4ce8-8e51-27a05c62997e','rihanthedev@gmail.comm','this is testing comment by postman... ','2026-09-19 21:46:33','2026-09-19 21:46:33'),('4351ee5b-b4ff-4a9e-9a2c-5c4dfc2355a0','ac188183-3101-4ce8-8e51-27a05c62997e','raihanul@example.com','this is testing comment by postman... ','2026-09-19 21:46:25','2026-09-19 21:46:25'),('53793be5-0ed0-457c-baa5-0196c26e5d4c','ac188183-3101-4ce8-8e51-27a05c62997e','rihanthedev@gmail.comm','this is testing comment by postman... ','2026-09-19 21:46:35','2026-09-19 21:46:35'),('65441d11-38dd-42d8-ad33-050076738122','ac188183-3101-4ce8-8e51-27a05c62997e','raihanul@example.com','this is testing comment by postman... ','2026-09-19 21:44:34','2026-09-19 21:44:34'),('840fb97e-3a7d-4235-963c-c0555975fe95','ac188183-3101-4ce8-8e51-27a05c62997e','raihanul@example.com','This is a really useful post.','2026-09-19 21:44:12','2026-09-19 21:44:12'),('a5822028-e257-4d94-92d5-074c01bf3d5b','ac188183-3101-4ce8-8e51-27a05c62997e','rihanthedev@gmail.com','this is testing comment by postman... ','2026-09-19 21:47:45','2026-09-19 21:47:45'),('fe8c3f2d-9770-41d0-b8d3-e9fca456ba82','ac188183-3101-4ce8-8e51-27a05c62997e','raihanul@example.com','this is testing comment by postman... ','2026-09-19 21:44:33','2026-09-19 21:44:33'); /*!40000 ALTER TABLE `blog_comments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `blog_post_likes` -- DROP TABLE IF EXISTS `blog_post_likes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `blog_post_likes` ( `id` char(36) NOT NULL, `postId` char(36) NOT NULL, `authorEmail` varchar(150) NOT NULL, `createdAt` datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `unique_post_like` (`postId`,`authorEmail`), KEY `idx_post_likes_post` (`postId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `blog_post_likes` -- LOCK TABLES `blog_post_likes` WRITE; /*!40000 ALTER TABLE `blog_post_likes` DISABLE KEYS */; INSERT INTO `blog_post_likes` VALUES ('3e29f1af-bd22-460b-ba27-37f269127b5a','ac188183-3101-4ce8-8e51-27a05c62997e','raihanul@example.com','2026-09-19 21:43:30'); /*!40000 ALTER TABLE `blog_post_likes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `blog_posts` -- DROP TABLE IF EXISTS `blog_posts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `blog_posts` ( `id` char(36) NOT NULL, `titleName` varchar(255) NOT NULL, `description` text NOT NULL, `authorEmail` varchar(150) NOT NULL, `galleries` json DEFAULT NULL, `createdAt` datetime DEFAULT CURRENT_TIMESTAMP, `updatedAt` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_blog_author_email` (`authorEmail`), KEY `idx_blog_created_at` (`createdAt`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `blog_posts` -- LOCK TABLES `blog_posts` WRITE; /*!40000 ALTER TABLE `blog_posts` DISABLE KEYS */; INSERT INTO `blog_posts` VALUES ('3632b790-68c7-4d53-8e82-a9be8fbfe3a3','secound blogs from postman','this is frist blog from POstman .........','rihanthedev@gmail.com','[\"BDBA9B8E-ACE4-4699-8BB7-4662A4B28318\", \"761AF892-6D34-45FA-8B6F-902385250BCB\"]','2026-09-19 21:33:43','2026-09-19 21:33:43'),('95c98fa0-1248-4130-b4d1-75ce01e00639','frist blogs from postman','this is frist blog from POstman .........','rihanthedev@gmail.com','[\"BDBA9B8E-ACE4-4699-8BB7-4662A4B28318\", \"761AF892-6D34-45FA-8B6F-902385250BCB\"]','2026-09-19 21:33:35','2026-09-19 21:33:35'),('ac188183-3101-4ce8-8e51-27a05c62997e','trhid blogs from postman','this is frist blog from POstman .........','rihanthedev@gmail.com','[\"BDBA9B8E-ACE4-4699-8BB7-4662A4B28318\", \"761AF892-6D34-45FA-8B6F-902385250BCB\"]','2026-09-19 21:33:53','2026-09-19 21:33:53'); /*!40000 ALTER TABLE `blog_posts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `blog_reply_likes` -- DROP TABLE IF EXISTS `blog_reply_likes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `blog_reply_likes` ( `id` char(36) NOT NULL, `replyId` char(36) NOT NULL, `authorEmail` varchar(150) NOT NULL, `createdAt` datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `unique_reply_like` (`replyId`,`authorEmail`), KEY `idx_reply_likes_reply` (`replyId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `blog_reply_likes` -- LOCK TABLES `blog_reply_likes` WRITE; /*!40000 ALTER TABLE `blog_reply_likes` DISABLE KEYS */; INSERT INTO `blog_reply_likes` VALUES ('2ef84320-cf61-4a43-a83d-c25bf76d9ef6','e8dee566-2b03-49cc-8749-8ba2551189ed','rihanthedev@gmail.com','2026-09-19 21:56:24'); /*!40000 ALTER TABLE `blog_reply_likes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `blood_banks` -- DROP TABLE IF EXISTS `blood_banks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `blood_banks` ( `id` char(36) NOT NULL, `bloodGroupId` char(36) NOT NULL, `title` varchar(255) NOT NULL, `description` text, `location` varchar(255) DEFAULT NULL, `contactNo` varchar(50) DEFAULT NULL, `galleries` json DEFAULT NULL, `sorting` int DEFAULT '0', `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `blood_banks` -- LOCK TABLES `blood_banks` WRITE; /*!40000 ALTER TABLE `blood_banks` DISABLE KEYS */; INSERT INTO `blood_banks` VALUES ('243bb3ae-793f-4090-8dfe-d501e505ce5f','31581C3D-DA6B-4367-ADC8-3C57889811BC','This is POST UPDATE FROM TEST API','test','Dhaka','0172772606','[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\"]',1,'2026-09-18 09:34:51','2026-09-18 09:43:05'),('6979d691-19a6-40c2-8536-167b5e347d1b','a0cd0484-9ff2-11f1-87a3-e8d8d1a2cb0a','Help me and needed the blood','Help help help','Dhaka','01777606656','[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\"]',1,'2026-09-18 09:34:41','2026-09-18 09:34:41'),('c37163c1-b1a6-4760-bfa6-9947086bde02','a0cd0484-9ff2-11f1-87a3-e8d8d1a2cb0a','Help me and needed the blood','Help help help','Dhaka','01777606656','[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\"]',1,'2026-09-18 09:34:45','2026-09-18 09:34:45'),('feb75575-a747-46d7-9134-62d486a7f8a7','a0cd0484-9ff2-11f1-87a3-e8d8d1a2cb0a','Help me and needed the blood','Help help help','Dhaka','01777606656','[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\"]',1,'2026-09-18 09:34:36','2026-09-18 09:34:36'); /*!40000 ALTER TABLE `blood_banks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `blood_groups` -- DROP TABLE IF EXISTS `blood_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `blood_groups` ( `id` char(36) NOT NULL, `name` varchar(20) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `blood_groups` -- LOCK TABLES `blood_groups` WRITE; /*!40000 ALTER TABLE `blood_groups` DISABLE KEYS */; INSERT INTO `blood_groups` VALUES ('a0cd0368-9ff2-11f1-87a3-e8d8d1a2cb0a','A-'),('a0ccfdcf-9ff2-11f1-87a3-e8d8d1a2cb0a','A+'),('a0cd061d-9ff2-11f1-87a3-e8d8d1a2cb0a','AB-'),('a0cd05a8-9ff2-11f1-87a3-e8d8d1a2cb0a','AB+'),('a0cd0511-9ff2-11f1-87a3-e8d8d1a2cb0a','B-'),('a0cd0484-9ff2-11f1-87a3-e8d8d1a2cb0a','B+'),('a0cd06ff-9ff2-11f1-87a3-e8d8d1a2cb0a','O-'),('a0cd068f-9ff2-11f1-87a3-e8d8d1a2cb0a','O+'); /*!40000 ALTER TABLE `blood_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cart_items` -- DROP TABLE IF EXISTS `cart_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cart_items` ( `id` char(36) NOT NULL, `cartId` char(36) NOT NULL, `skillId` char(36) NOT NULL, `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `unique_cart_skill` (`cartId`,`skillId`), KEY `idx_cart_items_cart` (`cartId`), KEY `idx_cart_items_skill` (`skillId`), CONSTRAINT `fk_cart_items_cart` FOREIGN KEY (`cartId`) REFERENCES `carts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_cart_items_skill` FOREIGN KEY (`skillId`) REFERENCES `skills` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cart_items` -- LOCK TABLES `cart_items` WRITE; /*!40000 ALTER TABLE `cart_items` DISABLE KEYS */; INSERT INTO `cart_items` VALUES ('14da6788-d078-406d-af6b-cbd9ff4af28e','a4468d40-87fa-49c7-8e2a-a232a2f19bb8','67eae355-e2b5-4112-a5d8-8e76225b466e','2026-09-18 15:11:55','2026-09-18 15:11:55'); /*!40000 ALTER TABLE `cart_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `carts` -- DROP TABLE IF EXISTS `carts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `carts` ( `id` char(36) NOT NULL, `userId` char(36) NOT NULL, `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `userId` (`userId`), KEY `idx_cart_user` (`userId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `carts` -- LOCK TABLES `carts` WRITE; /*!40000 ALTER TABLE `carts` DISABLE KEYS */; INSERT INTO `carts` VALUES ('a4468d40-87fa-49c7-8e2a-a232a2f19bb8','1adfc154-ce8b-4ee8-b5bd-a58ef3e1409e','2026-09-18 15:11:55','2026-09-18 15:11:55'); /*!40000 ALTER TABLE `carts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `checkout_details` -- DROP TABLE IF EXISTS `checkout_details`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `checkout_details` ( `id` char(36) NOT NULL, `checkoutId` char(36) NOT NULL, `skillId` char(36) NOT NULL, `coursePrice` decimal(10,2) DEFAULT '0.00', `discountPrice` decimal(10,2) DEFAULT '0.00', `discountPercentage` decimal(5,2) DEFAULT '0.00', `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_checkout_detail_checkout` (`checkoutId`), KEY `idx_checkout_detail_skill` (`skillId`), CONSTRAINT `fk_checkout_details_checkout` FOREIGN KEY (`checkoutId`) REFERENCES `checkouts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_checkout_details_skill` FOREIGN KEY (`skillId`) REFERENCES `skills` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `checkout_details` -- LOCK TABLES `checkout_details` WRITE; /*!40000 ALTER TABLE `checkout_details` DISABLE KEYS */; INSERT INTO `checkout_details` VALUES ('0f5ff2dc-0860-48a6-8f8f-c853e1671a5e','113c0c0d-96ea-4042-8cb2-ec257f486a6e','67eae355-e2b5-4112-a5d8-8e76225b466e',2500.00,2000.00,5.00,'2026-09-19 20:05:46'),('3c574c8c-93e0-4c48-843c-c93cbe2d6940','70b9cb0b-374b-48f1-94e2-cb658685a316','67eae355-e2b5-4112-a5d8-8e76225b466e',2500.00,2000.00,5.00,'2026-09-19 19:08:55'),('470f6457-8611-4f35-a268-617027515b37','1823ac0c-70da-455e-a2f8-c0954688cd00','67eae355-e2b5-4112-a5d8-8e76225b466e',2500.00,2000.00,5.00,'2026-09-19 19:08:16'),('67b4245b-18d3-4b7c-8ae1-3f3d74c1b1ea','608d05d9-4d2f-4788-8442-565b02a769e5','67eae355-e2b5-4112-a5d8-8e76225b466e',2500.00,2000.00,5.00,'2026-09-18 15:13:47'),('d2694eb9-ba60-458c-aea7-832f6dd5893d','13e28b18-9496-43f5-afbc-8965958ee5bc','67eae355-e2b5-4112-a5d8-8e76225b466e',2500.00,2000.00,5.00,'2026-09-19 19:08:52'),('dd573f25-733d-4594-bc58-8697630423b5','93679069-eb84-48df-881f-8d98e3c6742f','67eae355-e2b5-4112-a5d8-8e76225b466e',200000.00,2000000.00,5.00,'2026-09-19 20:07:05'); /*!40000 ALTER TABLE `checkout_details` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `checkouts` -- DROP TABLE IF EXISTS `checkouts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `checkouts` ( `id` char(36) NOT NULL, `userId` char(36) NOT NULL, `totalAmount` decimal(10,2) DEFAULT '0.00', `totalDiscount` decimal(10,2) DEFAULT '0.00', `payableAmount` decimal(10,2) DEFAULT '0.00', `status` varchar(50) DEFAULT 'PENDING', `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_checkout_user` (`userId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `checkouts` -- LOCK TABLES `checkouts` WRITE; /*!40000 ALTER TABLE `checkouts` DISABLE KEYS */; INSERT INTO `checkouts` VALUES ('113c0c0d-96ea-4042-8cb2-ec257f486a6e','1adfc154-ce8b-4ee8-b5bd-a58ef3e1409e',2500.00,500.00,2000.00,'COMPLETED','2026-09-19 20:05:46','2026-09-19 20:05:46'),('13e28b18-9496-43f5-afbc-8965958ee5bc','1adfc154-ce8b-4ee8-b5bd-a58ef3e1409e',2500.00,500.00,2000.00,'COMPLETED','2026-09-19 19:08:52','2026-09-19 20:03:19'),('1823ac0c-70da-455e-a2f8-c0954688cd00','1adfc154-ce8b-4ee8-b5bd-a58ef3e1409e',2500.00,500.00,2000.00,'COMPLETED','2026-09-19 19:08:16','2026-09-19 20:03:19'),('608d05d9-4d2f-4788-8442-565b02a769e5','1adfc154-ce8b-4ee8-b5bd-a58ef3e1409e',2500.00,500.00,2000.00,'COMPLETED','2026-09-18 15:13:47','2026-09-19 20:03:19'),('70b9cb0b-374b-48f1-94e2-cb658685a316','1adfc154-ce8b-4ee8-b5bd-a58ef3e1409e',2500.00,500.00,2000.00,'COMPLETED','2026-09-19 19:08:55','2026-09-19 20:03:19'),('93679069-eb84-48df-881f-8d98e3c6742f','1adfc154-ce8b-4ee8-b5bd-a58ef3e1409e',200000.00,-1800000.00,2000000.00,'COMPLETED','2026-09-19 20:07:05','2026-09-19 20:07:05'); /*!40000 ALTER TABLE `checkouts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department` -- DROP TABLE IF EXISTS `department`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `department` ( `Id` char(36) NOT NULL, `Name` varchar(255) NOT NULL, `CreatedByContactId` char(36) DEFAULT NULL, `UpdatedByContactId` char(36) DEFAULT NULL, `ObjectId` char(36) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `UpdatedDate` datetime DEFAULT NULL, `IsDeleted` tinyint(1) DEFAULT '0', `IsActive` tinyint(1) DEFAULT '0', PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department` -- LOCK TABLES `department` WRITE; /*!40000 ALTER TABLE `department` DISABLE KEYS */; INSERT INTO `department` VALUES ('d3b9551f-95ad-11f1-83c3-e8d8d1a2cb0a','Computer',NULL,NULL,NULL,'2026-08-11 17:55:23',NULL,0,1),('d3b95c7c-95ad-11f1-83c3-e8d8d1a2cb0a','Mechanical',NULL,NULL,NULL,'2026-08-11 17:55:23',NULL,0,1),('d3b95f14-95ad-11f1-83c3-e8d8d1a2cb0a','Civil',NULL,NULL,NULL,'2026-08-11 17:55:23',NULL,0,1),('d3b96031-95ad-11f1-83c3-e8d8d1a2cb0a','Electrical',NULL,NULL,NULL,'2026-08-11 17:55:23',NULL,0,1),('d3b9611e-95ad-11f1-83c3-e8d8d1a2cb0a','Electronics',NULL,NULL,NULL,'2026-08-11 17:55:23',NULL,0,1),('d3b96204-95ad-11f1-83c3-e8d8d1a2cb0a','Architecture',NULL,NULL,NULL,'2026-08-11 17:55:23',NULL,0,1); /*!40000 ALTER TABLE `department` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `departments` -- DROP TABLE IF EXISTS `departments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `departments` ( `id` char(36) NOT NULL, `name` varchar(150) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `departments` -- LOCK TABLES `departments` WRITE; /*!40000 ALTER TABLE `departments` DISABLE KEYS */; INSERT INTO `departments` VALUES ('a0cd762e-9ff2-11f1-87a3-e8d8d1a2cb0a','Automobile Technology'),('a0cd7a37-9ff2-11f1-87a3-e8d8d1a2cb0a','Civil-Wood'),('a0cd6df8-9ff2-11f1-87a3-e8d8d1a2cb0a','Computer Science & Technology'),('a0cd7981-9ff2-11f1-87a3-e8d8d1a2cb0a','Construction'),('a0cd77d7-9ff2-11f1-87a3-e8d8d1a2cb0a','Electrical'),('a0cd78bd-9ff2-11f1-87a3-e8d8d1a2cb0a','Mechanical'); /*!40000 ALTER TABLE `departments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `donations` -- DROP TABLE IF EXISTS `donations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `donations` ( `id` char(36) NOT NULL, `giftAndDonationPostId` char(36) NOT NULL, `authorEmail` varchar(150) NOT NULL, `amount` decimal(12,2) NOT NULL, `transactionRefId` varchar(255) DEFAULT NULL, `createdAt` datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_donation_post_id` (`giftAndDonationPostId`), KEY `idx_donation_author_email` (`authorEmail`), KEY `idx_donation_transaction_ref` (`transactionRefId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `donations` -- LOCK TABLES `donations` WRITE; /*!40000 ALTER TABLE `donations` DISABLE KEYS */; INSERT INTO `donations` VALUES ('123331d0-f22e-4e5d-8765-3ac40adc71be','35ee3124-c38d-43df-9e69-b8ff99c909a4','donor@example.com',1200.00,'BKASH-TXN-123456','2026-09-19 22:43:58'),('3633751b-83da-4ebf-a6f3-3ffcf6b752c1','35ee3124-c38d-43df-9e69-b8ff99c909a4','rihanthedev@gmail.com',1200.00,'BKASH-TXN-123456','2026-09-19 22:44:09'),('36688490-2009-4486-bedf-0004d12dab72','35ee3124-c38d-43df-9e69-b8ff99c909a4','rihanulislam2015@gmail.com',1200.00,'BKASH-TXN-123456','2026-09-20 20:02:27'); /*!40000 ALTER TABLE `donations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `event_fees` -- DROP TABLE IF EXISTS `event_fees`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `event_fees` ( `id` char(36) NOT NULL, `eventId` char(36) NOT NULL, `feeName` varchar(255) NOT NULL, `feeAmount` decimal(10,2) NOT NULL, PRIMARY KEY (`id`), KEY `eventId` (`eventId`), CONSTRAINT `event_fees_ibfk_1` FOREIGN KEY (`eventId`) REFERENCES `events` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `event_fees` -- LOCK TABLES `event_fees` WRITE; /*!40000 ALTER TABLE `event_fees` DISABLE KEYS */; INSERT INTO `event_fees` VALUES ('2f309a77-8a68-428b-8b5a-c360a415e405','63ab5218-a044-451b-bb7a-d65553aa0b2a','Student',50.00),('43ccac71-fb88-4169-ba80-9a7fddac8c2d','4872507e-e472-4788-bced-3b2e73db02ef','Driver',100.00),('61ee8187-57de-4258-ac62-2f1a31dae54b','7bee75d5-d2b2-4e5b-9780-603024333a32','Student',50.00),('6cee5e01-a555-4e02-b772-33d5f868b8e1','7bee75d5-d2b2-4e5b-9780-603024333a32','General',100.00),('73556991-559a-4011-b623-0a776ca791db','3d160521-a71b-4ba8-9f9d-ba3bbe7c8b40','General',150.00),('89df0a08-2378-4133-b0bd-22bf78b0d70a','c6d846e7-8860-4034-af9a-be39142dcb48','Driver',100.00),('96880a80-71a4-42f7-81cd-c738d0ed7834','56da8b4b-a546-4e26-b212-a984958ff395','Driver',100.00),('9eb878d5-6b4c-4085-9caf-ad413af576e3','3d160521-a71b-4ba8-9f9d-ba3bbe7c8b40','VIP',300.00),('c3a4c6ea-93af-42ae-ba9b-74726763d5a9','63ab5218-a044-451b-bb7a-d65553aa0b2a','General',100.00); /*!40000 ALTER TABLE `event_fees` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `events` -- DROP TABLE IF EXISTS `events`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `events` ( `id` char(36) NOT NULL, `date` date NOT NULL, `title` varchar(255) NOT NULL, `time` varchar(50) NOT NULL, `location` varchar(255) NOT NULL, `description` text, `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `galleries` json DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `events` -- LOCK TABLES `events` WRITE; /*!40000 ALTER TABLE `events` DISABLE KEYS */; INSERT INTO `events` VALUES ('3d160521-a71b-4ba8-9f9d-ba3bbe7c8b40','2026-09-25','Updated BSPI Programming Contest','11:00 AM','BSPI Auditorium','Updated event description.','2026-09-13 06:00:44','2026-09-13 07:02:30','[\"gallery-uuid-1\", \"gallery-uuid-2\"]'),('4872507e-e472-4788-bced-3b2e73db02ef','2026-09-20','Dhaka king','10:00 AM','BSPI Campus','Programming contest for students.','2026-09-13 06:19:47','2026-09-13 06:19:47',NULL),('56da8b4b-a546-4e26-b212-a984958ff395','2026-09-20','Dhaka king','10:00 AM','BSPI Campus','Programming contest for students.','2026-09-13 06:52:40','2026-09-13 06:52:40','[\"3fa85f64-5717-4562-b3fc-2c963f66afa6\"]'),('63ab5218-a044-451b-bb7a-d65553aa0b2a','2026-09-20','BSPI Programming Contest','10:00 AM','BSPI Campus','Programming contest for students.','2026-09-13 04:49:12','2026-09-13 04:49:12',NULL),('7bee75d5-d2b2-4e5b-9780-603024333a32','2026-09-20','BSPI Programming Contest','10:00 AM','BSPI Campus','Programming contest for students.','2026-09-13 06:19:17','2026-09-13 06:19:17',NULL),('c6d846e7-8860-4034-af9a-be39142dcb48','2026-09-20','BSPI Programming Contest','10:00 AM','BSPI Campus','Programming contest for students.','2026-09-13 06:19:37','2026-09-13 06:19:37',NULL); /*!40000 ALTER TABLE `events` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faqs` -- DROP TABLE IF EXISTS `faqs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `faqs` ( `id` char(36) NOT NULL, `icon` varchar(255) DEFAULT NULL, `question` varchar(500) NOT NULL, `answer` text NOT NULL, `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faqs` -- LOCK TABLES `faqs` WRITE; /*!40000 ALTER TABLE `faqs` DISABLE KEYS */; INSERT INTO `faqs` VALUES ('5fbbbb98-cb39-4b5b-9b42-fddce4851f6f','question-new','How can I register? update api','You can register by completing the registration form.','2026-09-20 15:21:59','2026-09-20 15:23:07'),('e01f18b4-7b5e-49c6-87b9-8f335ac7135d','question','How can I register?','You can register from the registration page.','2026-09-20 15:21:49','2026-09-20 15:21:49'); /*!40000 ALTER TABLE `faqs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `galleries` -- DROP TABLE IF EXISTS `galleries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `galleries` ( `id` char(36) NOT NULL, `image_url` varchar(500) NOT NULL, `sorting` int NOT NULL DEFAULT '0', `is_home_page` tinyint(1) NOT NULL DEFAULT '0', `is_popup_show` tinyint(1) NOT NULL DEFAULT '0', `is_deleted` tinyint(1) NOT NULL DEFAULT '0', `is_active` tinyint(1) NOT NULL DEFAULT '1', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `galleries` -- LOCK TABLES `galleries` WRITE; /*!40000 ALTER TABLE `galleries` DISABLE KEYS */; INSERT INTO `galleries` VALUES ('2394c53c-8c4d-4829-aabe-41b2f08b0e1a','/uploads/galleries/7860324010043cc021475b7ca1690389',1,0,0,0,1,'2026-09-13 03:56:19','2026-09-13 03:56:19'),('80d2039e-99ce-4ebb-932d-415782837b26','/uploads/galleries/a8dd6f4deae8906bd6cd8b5fcb20532f',0,0,0,0,1,'2026-09-20 09:07:16','2026-09-20 09:07:16'),('8179f5e0-325f-4327-aebb-f73d49359c67','/uploads/galleries/6d74545c54ff806bd268ce4cb1e59af9',1,0,0,0,1,'2026-09-13 04:39:38','2026-09-13 04:39:38'),('85faeeb2-26ca-45e1-bd36-857c0b301eca','/uploads/galleries/ad1c5236bcce96d43bb72a574a1e05cc',2,1,1,0,1,'2026-08-24 20:03:45','2026-08-24 20:21:55'); /*!40000 ALTER TABLE `galleries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gift_and_donation_posts` -- DROP TABLE IF EXISTS `gift_and_donation_posts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gift_and_donation_posts` ( `id` char(36) NOT NULL, `title` varchar(255) NOT NULL, `description` text NOT NULL, `amount` decimal(12,2) NOT NULL, `authorEmail` varchar(150) NOT NULL, `galleries` json DEFAULT NULL, `isActive` tinyint(1) DEFAULT '1', `isDeleted` tinyint(1) DEFAULT '0', `createdAt` datetime DEFAULT CURRENT_TIMESTAMP, `updatedAt` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_donation_author_email` (`authorEmail`), KEY `idx_donation_active_deleted` (`isActive`,`isDeleted`), KEY `idx_donation_created_at` (`createdAt`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gift_and_donation_posts` -- LOCK TABLES `gift_and_donation_posts` WRITE; /*!40000 ALTER TABLE `gift_and_donation_posts` DISABLE KEYS */; INSERT INTO `gift_and_donation_posts` VALUES ('35ee3124-c38d-43df-9e69-b8ff99c909a4','Helped him and save him','Updated description',150000.00,'rihanthedev@gmail.com','[\"07549879-C0A0-4733-86D1-AD179430C260\"]',1,0,'2026-09-19 22:40:08','2026-09-19 22:56:39'),('589dca76-5ff4-4396-bdef-d6f283acc276','Helped him and save him','Helpmed him',100000.00,'raihanul@example.com','[\"07549879-C0A0-4733-86D1-AD179430C260\"]',1,0,'2026-09-19 22:39:28','2026-09-19 22:39:28'),('6e54c268-2ed8-4210-85e5-5860f8020ccf','Helped him and save him','Helpmed him',100000.00,'rihanthedev@gmail.com','[\"07549879-C0A0-4733-86D1-AD179430C260\"]',1,0,'2026-09-19 22:39:46','2026-09-19 22:39:46'),('e7cf1281-79e7-4195-9cd2-0022de0b1da5','Helped him and save him','Helpmed him',100000.00,'rihanthedev@gmail.com','[\"07549879-C0A0-4733-86D1-AD179430C260\"]',1,0,'2026-09-19 22:39:48','2026-09-19 22:39:48'); /*!40000 ALTER TABLE `gift_and_donation_posts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `jobs` ( `id` char(36) NOT NULL, `departmentId` char(36) NOT NULL, `postName` varchar(255) NOT NULL, `companyName` varchar(255) NOT NULL, `location` varchar(255) DEFAULT NULL, `jobTypeId` char(36) NOT NULL, `deadline` datetime DEFAULT NULL, `websiteUrl` varchar(500) DEFAULT NULL, `description` text, `galleryIds` json DEFAULT NULL, `isDeleted` tinyint(1) NOT NULL DEFAULT '0', `isActive` tinyint(1) NOT NULL DEFAULT '1', `sorting` int NOT NULL DEFAULT '0', `createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `updatedAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; INSERT INTO `jobs` VALUES ('311c8b21-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Software Engineer','Tech Solutions Ltd','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-10-15 00:00:00','https://techsolutions.com','Looking for a Software Engineer to join our development team.','[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\", \"761AF892-6D34-45FA-8B6F-902385250BCB\"]',0,1,1,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311c996a-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Backend Developer','Digital BD','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-10-20 00:00:00','https://digitalbd.com','We are looking for a Backend Developer with Node.js experience.','[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\"]',0,1,2,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311c9b4d-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Frontend Developer','Creative Soft','Chattogram','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-10-25 00:00:00','https://creativesoft.com','Frontend Developer required with React experience.','[\"761AF892-6D34-45FA-8B6F-902385250BCB\"]',0,1,3,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311c9c56-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Full Stack Developer','WebCraft Ltd','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-11-01 00:00:00','https://webcraft.com','Full Stack Developer with React and Node.js experience.','[]',0,1,4,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311c9d00-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Junior Software Engineer','CodeLab Bangladesh','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-11-05 00:00:00','https://codelab.com','Entry-level Software Engineer position for fresh graduates.','[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\"]',0,1,5,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311c9dba-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Senior Backend Engineer','Cloud Systems Ltd','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-11-10 00:00:00','https://cloudsystems.com','Senior Backend Engineer with distributed systems experience.','[\"761AF892-6D34-45FA-8B6F-902385250BCB\"]',0,1,6,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311c9e54-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','React Developer','Pixel IT','Rajshahi','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-11-15 00:00:00','https://pixelit.com','React Developer needed for building modern web applications.','[]',0,1,7,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311c9ee2-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','DevOps Engineer','InfraTech','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-11-20 00:00:00','https://infratech.com','DevOps Engineer with Docker and cloud infrastructure experience.','[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\"]',0,1,8,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311c9f77-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Mobile App Developer','AppZone','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-11-25 00:00:00','https://appzone.com','Mobile application developer required for our product team.','[\"761AF892-6D34-45FA-8B6F-902385250BCB\"]',0,1,9,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311ca017-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','QA Engineer','QualityTech','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-12-01 00:00:00','https://qualitytech.com','QA Engineer required for manual and automated testing.','[]',0,1,10,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311ca0a7-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Software Architect','Enterprise Systems','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-12-05 00:00:00','https://enterprisesystems.com','Software Architect responsible for designing scalable systems.','[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\", \"761AF892-6D34-45FA-8B6F-902385250BCB\"]',0,1,11,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311ca172-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Software Engineering Intern','Startup Labs','Chattogram','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-12-10 00:00:00','https://startuplabs.com','Software engineering internship for students and fresh graduates.','[]',0,1,12,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311d52e8-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Software Engineer','Tech Solutions Ltd','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-10-15 00:00:00','https://techsolutions.com','Looking for a Software Engineer to join our development team.','[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\", \"761AF892-6D34-45FA-8B6F-902385250BCB\"]',0,1,1,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311d5ce2-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Backend Developer','Digital BD','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-10-20 00:00:00','https://digitalbd.com','We are looking for a Backend Developer with Node.js experience.','[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\"]',0,1,2,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311d5e29-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Frontend Developer','Creative Soft','Chattogram','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-10-25 00:00:00','https://creativesoft.com','Frontend Developer required with React experience.','[\"761AF892-6D34-45FA-8B6F-902385250BCB\"]',0,1,3,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311d5f73-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Full Stack Developer','WebCraft Ltd','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-11-01 00:00:00','https://webcraft.com','Full Stack Developer with React and Node.js experience.','[]',0,1,4,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311d6094-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Junior Software Engineer','CodeLab Bangladesh','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-11-05 00:00:00','https://codelab.com','Entry-level Software Engineer position for fresh graduates.','[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\"]',0,1,5,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311d6189-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Senior Backend Engineer','Cloud Systems Ltd','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-11-10 00:00:00','https://cloudsystems.com','Senior Backend Engineer with distributed systems experience.','[\"761AF892-6D34-45FA-8B6F-902385250BCB\"]',0,1,6,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311d629a-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','React Developer','Pixel IT','Rajshahi','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-11-15 00:00:00','https://pixelit.com','React Developer needed for building modern web applications.','[]',0,1,7,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311d6359-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','DevOps Engineer','InfraTech','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-11-20 00:00:00','https://infratech.com','DevOps Engineer with Docker and cloud infrastructure experience.','[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\"]',0,1,8,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311d648f-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Mobile App Developer','AppZone','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-11-25 00:00:00','https://appzone.com','Mobile application developer required for our product team.','[\"761AF892-6D34-45FA-8B6F-902385250BCB\"]',0,1,9,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311d654d-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','QA Engineer','QualityTech','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-12-01 00:00:00','https://qualitytech.com','QA Engineer required for manual and automated testing.','[]',0,1,10,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311d6621-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Software Architect','Enterprise Systems','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-12-05 00:00:00','https://enterprisesystems.com','Software Architect responsible for designing scalable systems.','[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\", \"761AF892-6D34-45FA-8B6F-902385250BCB\"]',0,1,11,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('311d6752-b045-11f1-8a66-e8d8d1a2cb0a','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Software Engineering Intern','Startup Labs','Chattogram','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-12-10 00:00:00','https://startuplabs.com','Software engineering internship for students and fresh graduates.','[]',0,1,12,'2026-09-14 20:04:24','2026-09-14 20:04:24'),('537a83f9-7288-4108-8148-0d2f5ca3303c','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Software Engineer','Nil Tech IT','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-12-29 00:00:00','https://niltechit.com','We are looking for a Software Engineer with experience in modern web development.','[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\", \"761AF892-6D34-45FA-8B6F-902385250BCB\"]',0,1,0,'2026-09-14 19:49:25','2026-09-14 19:49:25'),('8f491afa-5012-474b-b479-71f09826a30e','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Senior Software Engineer','Nil Tech IT','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-12-30 00:00:00','https://niltechit.com/careers','Updated job description for the Senior Software Engineer position.','[\"761AF892-6D34-45FA-8B6F-902385250BCB\"]',0,1,1,'2026-09-14 19:49:53','2026-09-14 19:52:25'),('d72492e1-6864-42cb-8e5c-b3917a70a9d0','5D317BB9-0337-4AFD-ADA3-C3B36808AFEA','Software Engineer L2','Nil Tech IT','Dhaka','710CFADD-2C6E-416B-B242-EF320AEA6A65','2026-12-29 00:00:00','https://niltechit.com','We are looking for a Software Engineer with experience in modern web development.','[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\", \"761AF892-6D34-45FA-8B6F-902385250BCB\"]',0,1,0,'2026-09-14 19:49:39','2026-09-14 19:49:39'); /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobtypes` -- DROP TABLE IF EXISTS `jobtypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `jobtypes` ( `id` char(36) NOT NULL, `name` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobtypes` -- LOCK TABLES `jobtypes` WRITE; /*!40000 ALTER TABLE `jobtypes` DISABLE KEYS */; INSERT INTO `jobtypes` VALUES ('5f8c6804-b046-11f1-8a66-e8d8d1a2cb0a','Full Time'),('5f8c720f-b046-11f1-8a66-e8d8d1a2cb0a','Part Time'); /*!40000 ALTER TABLE `jobtypes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `memberships` -- DROP TABLE IF EXISTS `memberships`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `memberships` ( `id` char(36) NOT NULL, `title` varchar(255) NOT NULL, `description` text, `membershipType` varchar(100) NOT NULL, `discount` decimal(5,2) DEFAULT '0.00', `galleries` json DEFAULT NULL, `facility` json DEFAULT NULL, `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `memberships` -- LOCK TABLES `memberships` WRITE; /*!40000 ALTER TABLE `memberships` DISABLE KEYS */; INSERT INTO `memberships` VALUES ('4e57745f-b0bd-11f1-8a66-e8d8d1a2cb0a','Lifetime Membership','Lifetime membership benefit','Lifetime',10.00,'[]','[]','2026-09-15 04:24:13','2026-09-15 04:24:13'),('4e577fcd-b0bd-11f1-8a66-e8d8d1a2cb0a','Part-Time Membership','Part-time membership benefit','Part-Time',5.00,'[]','[]','2026-09-15 04:24:13','2026-09-15 04:24:13'),('668b8459-223f-4072-85cd-3a858037384d','Lifetime Membership','Lifetime membership with all benefits','Lifetime',10.00,'[\"94e99f63-5742-49bd-876c-e6f03dc016d3\"]','[\"Lab \", \"Robotric CLub Pool\", \"BSPI HOSTEL CLUB\", \"Sports Ground\"]','2026-09-15 04:26:48','2026-09-15 04:35:58'),('c1e97f0f-a2b8-4ae2-b9d4-a4241df8f06a','Lifetime Membership','Lifetime membership with all benefits','Lifetime',10.00,'[\"94e99f63-5742-49bd-876c-e6f03dc016d3\"]','[\"Gym\", \"Swimming Pool\", \"Library\"]','2026-09-15 04:32:57','2026-09-15 04:32:57'); /*!40000 ALTER TABLE `memberships` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `passing_years` -- DROP TABLE IF EXISTS `passing_years`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `passing_years` ( `id` char(36) NOT NULL, `year` int NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `year` (`year`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `passing_years` -- LOCK TABLES `passing_years` WRITE; /*!40000 ALTER TABLE `passing_years` DISABLE KEYS */; INSERT INTO `passing_years` VALUES ('a0d018f2-9ff2-11f1-87a3-e8d8d1a2cb0a',1963),('a0d0228e-9ff2-11f1-87a3-e8d8d1a2cb0a',1964),('a0d0240d-9ff2-11f1-87a3-e8d8d1a2cb0a',1965),('a0d024e8-9ff2-11f1-87a3-e8d8d1a2cb0a',1966),('a0d025cf-9ff2-11f1-87a3-e8d8d1a2cb0a',1967),('a0d02696-9ff2-11f1-87a3-e8d8d1a2cb0a',1968),('a0d02758-9ff2-11f1-87a3-e8d8d1a2cb0a',1969),('a0d02851-9ff2-11f1-87a3-e8d8d1a2cb0a',1970),('a0d0291b-9ff2-11f1-87a3-e8d8d1a2cb0a',1971),('a0d029d9-9ff2-11f1-87a3-e8d8d1a2cb0a',1972),('a0d02a90-9ff2-11f1-87a3-e8d8d1a2cb0a',1973),('a0d02b48-9ff2-11f1-87a3-e8d8d1a2cb0a',1974),('a0d02c05-9ff2-11f1-87a3-e8d8d1a2cb0a',1975),('a0d02cbf-9ff2-11f1-87a3-e8d8d1a2cb0a',1976),('a0d02d68-9ff2-11f1-87a3-e8d8d1a2cb0a',1977),('a0d02e34-9ff2-11f1-87a3-e8d8d1a2cb0a',1978),('a0d02f5c-9ff2-11f1-87a3-e8d8d1a2cb0a',1979),('a0d03014-9ff2-11f1-87a3-e8d8d1a2cb0a',1980),('a0d0316e-9ff2-11f1-87a3-e8d8d1a2cb0a',1981),('a0d03224-9ff2-11f1-87a3-e8d8d1a2cb0a',1982),('a0d032e3-9ff2-11f1-87a3-e8d8d1a2cb0a',1983),('a0d03394-9ff2-11f1-87a3-e8d8d1a2cb0a',1984),('a0d03432-9ff2-11f1-87a3-e8d8d1a2cb0a',1985),('a0d034e0-9ff2-11f1-87a3-e8d8d1a2cb0a',1986),('a0d0359e-9ff2-11f1-87a3-e8d8d1a2cb0a',1987),('a0d0381b-9ff2-11f1-87a3-e8d8d1a2cb0a',1988),('a0d038fc-9ff2-11f1-87a3-e8d8d1a2cb0a',1989),('a0d039bd-9ff2-11f1-87a3-e8d8d1a2cb0a',1990),('a0d03b4e-9ff2-11f1-87a3-e8d8d1a2cb0a',1991),('a0d03f0c-9ff2-11f1-87a3-e8d8d1a2cb0a',1992),('a0d041ed-9ff2-11f1-87a3-e8d8d1a2cb0a',1993),('a0d04482-9ff2-11f1-87a3-e8d8d1a2cb0a',1994),('a0d045ef-9ff2-11f1-87a3-e8d8d1a2cb0a',1995),('a0d04841-9ff2-11f1-87a3-e8d8d1a2cb0a',1996),('a0d04b01-9ff2-11f1-87a3-e8d8d1a2cb0a',1997),('a0d04c84-9ff2-11f1-87a3-e8d8d1a2cb0a',1998),('a0d04e74-9ff2-11f1-87a3-e8d8d1a2cb0a',1999),('a0d04fd8-9ff2-11f1-87a3-e8d8d1a2cb0a',2000),('a0d05259-9ff2-11f1-87a3-e8d8d1a2cb0a',2001),('a0d053ac-9ff2-11f1-87a3-e8d8d1a2cb0a',2002),('a0d05760-9ff2-11f1-87a3-e8d8d1a2cb0a',2003),('a0d05b1a-9ff2-11f1-87a3-e8d8d1a2cb0a',2004),('a0d05ce5-9ff2-11f1-87a3-e8d8d1a2cb0a',2005),('a0d05e4d-9ff2-11f1-87a3-e8d8d1a2cb0a',2006),('a0d05faa-9ff2-11f1-87a3-e8d8d1a2cb0a',2007),('a0d061ce-9ff2-11f1-87a3-e8d8d1a2cb0a',2008),('a0d06425-9ff2-11f1-87a3-e8d8d1a2cb0a',2009),('a0d064d2-9ff2-11f1-87a3-e8d8d1a2cb0a',2010),('a0d0661e-9ff2-11f1-87a3-e8d8d1a2cb0a',2011),('a0d06752-9ff2-11f1-87a3-e8d8d1a2cb0a',2012),('a0d06984-9ff2-11f1-87a3-e8d8d1a2cb0a',2013),('a0d06a4c-9ff2-11f1-87a3-e8d8d1a2cb0a',2014),('a0d06b2c-9ff2-11f1-87a3-e8d8d1a2cb0a',2015),('a0d06bf1-9ff2-11f1-87a3-e8d8d1a2cb0a',2016),('a0d06ca7-9ff2-11f1-87a3-e8d8d1a2cb0a',2017),('a0d06e24-9ff2-11f1-87a3-e8d8d1a2cb0a',2018),('a0d06eea-9ff2-11f1-87a3-e8d8d1a2cb0a',2019),('a0d0717f-9ff2-11f1-87a3-e8d8d1a2cb0a',2020),('a0d072bc-9ff2-11f1-87a3-e8d8d1a2cb0a',2021),('a0d0738e-9ff2-11f1-87a3-e8d8d1a2cb0a',2022),('a0d07432-9ff2-11f1-87a3-e8d8d1a2cb0a',2023),('a0d076eb-9ff2-11f1-87a3-e8d8d1a2cb0a',2024),('a0d0778e-9ff2-11f1-87a3-e8d8d1a2cb0a',2025),('a0d07828-9ff2-11f1-87a3-e8d8d1a2cb0a',2026); /*!40000 ALTER TABLE `passing_years` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `security_contact` -- DROP TABLE IF EXISTS `security_contact`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `security_contact` ( `Id` char(36) NOT NULL, `CompanyId` char(36) DEFAULT NULL, `FirstName` varchar(100) NOT NULL, `LastName` varchar(100) DEFAULT NULL, `DesignationId` char(36) DEFAULT NULL, `Email` varchar(100) DEFAULT NULL, `Phone` varchar(20) DEFAULT NULL, `ProfileImageUrl` varchar(200) DEFAULT NULL, `Status` int DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `CreatedByContactId` char(36) DEFAULT NULL, `UpdatedDate` datetime DEFAULT NULL, `UpdatedByContactId` char(36) DEFAULT NULL, `IsEmployee` tinyint(1) DEFAULT NULL, `IsDeleted` tinyint(1) DEFAULT '0', `IsActive` tinyint(1) DEFAULT '0', PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `security_contact` -- LOCK TABLES `security_contact` WRITE; /*!40000 ALTER TABLE `security_contact` DISABLE KEYS */; INSERT INTO `security_contact` VALUES ('3d511652-b657-4950-8df3-5548afbc3cbb',NULL,'Raihanul Islam','Sharif',NULL,'rihasssssssnulislam2015@gmail.com','01317172725',NULL,NULL,'2026-08-11 18:10:17',NULL,NULL,NULL,NULL,0,1),('76365b28-ffbd-42a8-8192-2938e25000f6',NULL,'Raihanul Islam','Sharif',NULL,'rihanthedev@gmail.com','01317172725',NULL,NULL,'2026-08-11 18:18:44',NULL,NULL,NULL,NULL,0,1),('828bada1-6106-45c4-9af5-6f967b6fc700',NULL,'Raihanul Islam','Sharif',NULL,'rihanthedev@gmail.com','01317172725',NULL,NULL,'2026-09-15 04:51:54',NULL,NULL,NULL,NULL,0,1); /*!40000 ALTER TABLE `security_contact` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `security_role` -- DROP TABLE IF EXISTS `security_role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `security_role` ( `Id` char(36) NOT NULL, `Name` varchar(100) NOT NULL, `Status` tinyint DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `CreatedByContactId` char(36) DEFAULT NULL, `UpdatedDate` datetime DEFAULT NULL, `UpdatedByContactId` char(36) DEFAULT NULL, `ObjectId` varchar(40) DEFAULT NULL, `CompanyId` char(36) DEFAULT NULL, `IsFixed` tinyint(1) DEFAULT NULL, `IsDeleted` tinyint(1) DEFAULT '0', `IsActive` tinyint(1) DEFAULT '0', PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `security_role` -- LOCK TABLES `security_role` WRITE; /*!40000 ALTER TABLE `security_role` DISABLE KEYS */; INSERT INTO `security_role` VALUES ('7a98f013-95aa-11f1-83c3-e8d8d1a2cb0a','USER',1,'2026-08-11 17:31:25',NULL,NULL,NULL,NULL,NULL,0,0,1); /*!40000 ALTER TABLE `security_role` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `security_user` -- DROP TABLE IF EXISTS `security_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `security_user` ( `Id` char(36) NOT NULL, `CompanyId` char(36) DEFAULT NULL, `ContactId` char(36) DEFAULT NULL, `Username` varchar(100) DEFAULT NULL, `ProfileImageUrl` varchar(250) DEFAULT NULL, `PasswordHash` varchar(255) DEFAULT NULL, `PasswordSalt` varchar(512) DEFAULT NULL, `RegistrationToken` varchar(50) DEFAULT NULL, `PasswordResetToken` varchar(50) DEFAULT NULL, `LastLoginDateUtc` datetime DEFAULT NULL, `LastLogoutDateUtc` datetime DEFAULT NULL, `LastPasswordChangeUtc` datetime DEFAULT NULL, `Status` int DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `CreatedByContactId` char(36) DEFAULT NULL, `UpdatedDate` datetime DEFAULT NULL, `UpdatedByContactId` char(36) DEFAULT NULL, `IsDeleted` tinyint(1) DEFAULT '0', `IsActive` tinyint(1) DEFAULT '0', `DesignationId` char(36) DEFAULT NULL, `BloodGroupId` char(36) DEFAULT NULL, `BatchId` char(36) DEFAULT NULL, `PassingYearId` char(36) DEFAULT NULL, `DepartmentId` char(36) DEFAULT NULL, `UserTypeId` char(36) DEFAULT NULL, `MemberTypeId` char(36) DEFAULT NULL, `VerifiedToken` varchar(500) DEFAULT NULL, `SMSOTP` int DEFAULT NULL, `IsVerified` tinyint(1) DEFAULT '0', PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `security_user` -- LOCK TABLES `security_user` WRITE; /*!40000 ALTER TABLE `security_user` DISABLE KEYS */; INSERT INTO `security_user` VALUES ('b3add9bd-fd5b-4b79-8acb-0273d02564dd',NULL,'3d511652-b657-4950-8df3-5548afbc3cbb','rihasssssssnulislam2015@gmail.com',NULL,'BAE373A2106553926B001784C57099DFA12682AD47909576ECE2AC1233958E8A27152AD77F9EF580B61238C4C5EE424743FB218832009F0D82B93CAB2B583907','E2830235530A72CEF0006FD96E8C5064F470CA9DBAFDA875A22A0A5F3EBE5B80D706BBC2B8448A92445979F614CCC244E8CB3C3D2D1A009EB7A9189282C5A1C05333F5B38AD12A1A1ADA135A87588907D973159E4E71F3CD21F76A829956546EEB263056A3CFC231CD08C9B96DE398D04AA2B4156F246ADB41A8E124D083714E',NULL,NULL,NULL,NULL,'2026-08-11 18:58:43',0,'2026-08-11 18:10:17',NULL,NULL,NULL,0,1,NULL,'A3ED207B-1AB9-462D-8B21-DD4AFE30077C','171265B5-FB77-4282-86A2-C31140403235','C0E4C1D1-E028-4EBA-9141-3209FEC6146A','d3b9551f-95ad-11f1-83c3-e8d8d1a2cb0a','0581FDF1-91F9-4396-9783-C450B3620E01','0581FDF1-91F9-4396-9783-C450B3620E01','4FF6155B3D362706111DF6DDE123DD90E805B0E6E417678ACE39C612B245DB19',NULL,0),('c4487ce7-aeff-4cf0-b637-6b8e74a9138e',NULL,'76365b28-ffbd-42a8-8192-2938e25000f6','rihanthedev@gmail.com',NULL,'33ABF9F4B4F3058FE5DB3571D7F064D425C0A0329ACC7E2EAC34F09195B3935995526FC81A4739796CA4B64A3E49F91850A0806F1BF95DAC27A2948E7BD43BB5','30014DCF7D919B28F596A297BC26164C7FF3AC9E4296550A80E3FF2B41EB2427E41F2E7DB1F24B4BF6104DE9542E3F8422F7556F6576915844557CE92446B08D78F64D090551B55002738CC3DD7A46692E4C9907B20C6F28E5F9E4357A3276917B01066DBC4EF3CDFF03A104157B6DE800DE128B5A61AF5B8D0DB5E839A07359',NULL,NULL,NULL,NULL,NULL,0,'2026-08-11 18:18:44',NULL,NULL,NULL,0,1,NULL,'A3ED207B-1AB9-462D-8B21-DD4AFE30077C','171265B5-FB77-4282-86A2-C31140403235','C0E4C1D1-E028-4EBA-9141-3209FEC6146A','d3b9551f-95ad-11f1-83c3-e8d8d1a2cb0a','0581FDF1-91F9-4396-9783-C450B3620E01','0581FDF1-91F9-4396-9783-C450B3620E01','E7B932853F7808DFF5D5D64C5CCB599D51371251055EF4522E6594A7619E22C0',123456,0),('c9ca52cb-ad88-4fd0-a1f3-ee71ef5ec3a7',NULL,'828bada1-6106-45c4-9af5-6f967b6fc700','rihanthedev@gmail.com',NULL,'10F2C5667455008DFFD5E59AEC1CD612D71AC77AD0EFDECB4F921EBD4ED66578A3B3D1DD46CA73B68D4C263019AEDBF97CA27A4D7878113B5777BE660B4B818E','3AB5723654D450BC6337BC6ED4EF974CD7EBA10737C9AF4567E2EBB1E289F52EFAD31F1208E2C886C3D51B30F97AF45871169BF8E134A48E92EA7ED80D1F3C0149C4CE44EEA6A3EB1ED9367449A379F0465EFD0E1B3F9C10337CB6668FDFE3BADF0F954416BB8EA43CB076862786E3080DDDC2415954772B967E21C3D10EF24B',NULL,NULL,NULL,NULL,NULL,0,'2026-09-15 04:51:54',NULL,NULL,NULL,0,1,NULL,'A3ED207B-1AB9-462D-8B21-DD4AFE30077C','171265B5-FB77-4282-86A2-C31140403235','C0E4C1D1-E028-4EBA-9141-3209FEC6146A','d3b9551f-95ad-11f1-83c3-e8d8d1a2cb0a','0581FDF1-91F9-4396-9783-C450B3620E01','0581FDF1-91F9-4396-9783-C450B3620E01','AD08246307F67AB5334BD60ABB5FBD04F0D0A958F84A2CBC11A1F7B2D3C1252F',123456,0); /*!40000 ALTER TABLE `security_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `security_userrole` -- DROP TABLE IF EXISTS `security_userrole`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `security_userrole` ( `Id` char(36) NOT NULL, `UserId` char(36) DEFAULT NULL, `RoleId` char(36) DEFAULT NULL, `UpdatedDate` datetime DEFAULT NULL, `UpdatedByContactId` char(36) DEFAULT NULL, `CreatedDate` datetime DEFAULT NULL, `IsDeleted` tinyint(1) DEFAULT '0', `IsActive` tinyint(1) DEFAULT '0', PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `security_userrole` -- LOCK TABLES `security_userrole` WRITE; /*!40000 ALTER TABLE `security_userrole` DISABLE KEYS */; INSERT INTO `security_userrole` VALUES ('5dc311af-5cd8-45de-a803-6ffbe89a5e6a','c4487ce7-aeff-4cf0-b637-6b8e74a9138e','7a98f013-95aa-11f1-83c3-e8d8d1a2cb0a',NULL,NULL,'2026-08-11 18:18:44',0,1),('eb2a1442-359d-4c74-b4cf-f256fe49eb37','b3add9bd-fd5b-4b79-8acb-0273d02564dd','7a98f013-95aa-11f1-83c3-e8d8d1a2cb0a',NULL,NULL,'2026-08-11 18:10:17',0,1),('ecbdc330-936a-4fb0-894b-40302520b378','c9ca52cb-ad88-4fd0-a1f3-ee71ef5ec3a7','7a98f013-95aa-11f1-83c3-e8d8d1a2cb0a',NULL,NULL,'2026-09-15 04:51:54',0,1); /*!40000 ALTER TABLE `security_userrole` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `skill_types` -- DROP TABLE IF EXISTS `skill_types`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `skill_types` ( `id` char(36) NOT NULL, `title` varchar(100) NOT NULL, `sorting` int DEFAULT '0', `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `skill_types` -- LOCK TABLES `skill_types` WRITE; /*!40000 ALTER TABLE `skill_types` DISABLE KEYS */; INSERT INTO `skill_types` VALUES ('7EE9E9A5-614A-4C09-B0FE-8D49F75C80F2','Academic',1,'2026-09-18 14:02:41','2026-09-18 14:02:41'),('8EE9E9A5-614A-4C09-B0FE-8D49F75C80F3','Non Academic',2,'2026-09-18 14:02:41','2026-09-18 14:02:41'); /*!40000 ALTER TABLE `skill_types` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `skills` -- DROP TABLE IF EXISTS `skills`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `skills` ( `id` char(36) NOT NULL, `title` varchar(255) NOT NULL, `courseDetails` text, `skillTypesId` char(36) NOT NULL, `totalLession` int DEFAULT '0', `totalPrice` decimal(10,2) DEFAULT '0.00', `discountPricePercentage` decimal(5,2) DEFAULT '0.00', `totalHour` decimal(10,2) DEFAULT '0.00', `galleries` json DEFAULT NULL, `skillDetails` json DEFAULT NULL, `sorting` int DEFAULT '0', `createdAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updatedAt` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_skill_type` (`skillTypesId`), CONSTRAINT `fk_skills_skill_type` FOREIGN KEY (`skillTypesId`) REFERENCES `skill_types` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `skills` -- LOCK TABLES `skills` WRITE; /*!40000 ALTER TABLE `skills` DISABLE KEYS */; INSERT INTO `skills` VALUES ('426a2a06-a310-4119-bbd3-6ccca9cba481','Testing Skills add','Details learn checkout','7EE9E9A5-614A-4C09-B0FE-8D49F75C80F2',12,2500.00,10.00,160.00,'[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\", \"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\"]','[{\"title\": \"1st Class\", \"videoLinkURL\": \"https://www.youtube.com/watch?v=y7mCa_uVHVw\", \"classSchedule\": \"2026-09-20T18:00:00.000Z\"}, {\"title\": \"2nd Class\", \"videoLinkURL\": \"https://www.youtube.com/watch?v=example\", \"classSchedule\": \"2026-09-21T18:00:00.000Z\"}]',1,'2026-09-18 14:26:48','2026-09-18 14:26:48'),('63a1b087-2378-4b1d-9f8e-4fe287477668','Testing Skills add','Details learn checkout','7EE9E9A5-614A-4C09-B0FE-8D49F75C80F2',12,2500.00,10.00,160.00,'[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\", \"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\"]','[{\"title\": \"1st Class\", \"videoLinkURL\": \"https://www.youtube.com/watch?v=y7mCa_uVHVw\", \"classSchedule\": \"2026-09-20T18:00:00.000Z\"}, {\"title\": \"2nd Class\", \"videoLinkURL\": \"https://www.youtube.com/watch?v=example\", \"classSchedule\": \"2026-09-21T18:00:00.000Z\"}]',1,'2026-09-18 14:26:46','2026-09-18 14:26:46'),('67eae355-e2b5-4112-a5d8-8e76225b466e','How to learn C# Advanced','Updated course details','7EE9E9A5-614A-4C09-B0FE-8D49F75C80F2',20,3000.00,15.00,200.00,'[\"gallery-id-1\", \"gallery-id-2\"]','[{\"title\": \"Class 1\", \"videoLinkURL\": \"https://youtube.com/example\", \"classSchedule\": \"2026-09-20T18:00:00.000Z\"}]',1,'2026-09-18 14:27:02','2026-09-18 14:34:07'),('7e620a66-583d-468e-923a-a5bcbeaa0c5b','Testing Skills add 3','Details learn checkout','7EE9E9A5-614A-4C09-B0FE-8D49F75C80F2',12,2500.00,10.00,160.00,'[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\", \"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\"]','[{\"title\": \"1st Class\", \"videoLinkURL\": \"https://www.youtube.com/watch?v=y7mCa_uVHVw\", \"classSchedule\": \"2026-09-20T18:00:00.000Z\"}, {\"title\": \"2nd Class\", \"videoLinkURL\": \"https://www.youtube.com/watch?v=example\", \"classSchedule\": \"2026-09-21T18:00:00.000Z\"}]',1,'2026-09-18 14:26:54','2026-09-18 14:26:54'),('b08db45f-fe94-443c-a585-6d8689200c74','Testing Skills add','Details learn checkout','7EE9E9A5-614A-4C09-B0FE-8D49F75C80F2',12,2500.00,10.00,160.00,'[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\", \"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\"]','[{\"title\": \"1st Class\", \"videoLinkURL\": \"https://www.youtube.com/watch?v=y7mCa_uVHVw\", \"classSchedule\": \"2026-09-20T18:00:00.000Z\"}, {\"title\": \"2nd Class\", \"videoLinkURL\": \"https://www.youtube.com/watch?v=example\", \"classSchedule\": \"2026-09-21T18:00:00.000Z\"}]',1,'2026-09-18 14:26:43','2026-09-18 14:26:43'),('d064e85a-470c-4b71-8897-2c3ebcd734ac','Testing Skills add 4','Details learn checkout','7EE9E9A5-614A-4C09-B0FE-8D49F75C80F2',12,2500.00,10.00,160.00,'[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\", \"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\"]','[{\"title\": \"1st Class\", \"videoLinkURL\": \"https://www.youtube.com/watch?v=y7mCa_uVHVw\", \"classSchedule\": \"2026-09-20T18:00:00.000Z\"}, {\"title\": \"2nd Class\", \"videoLinkURL\": \"https://www.youtube.com/watch?v=example\", \"classSchedule\": \"2026-09-21T18:00:00.000Z\"}]',1,'2026-09-18 14:26:58','2026-09-18 14:26:58'),('eed80d97-c29e-48c7-8235-cdde4d401263','How to learn C# Basic','Details learn checkout','7EE9E9A5-614A-4C09-B0FE-8D49F75C80F2',12,2500.00,10.00,160.00,'[\"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\", \"007BF9EE-3429-473B-A19B-ADE0B7C3CEF7\"]','[{\"title\": \"1st Class\", \"videoLinkURL\": \"https://www.youtube.com/watch?v=y7mCa_uVHVw\", \"classSchedule\": \"2026-09-20T18:00:00.000Z\"}, {\"title\": \"2nd Class\", \"videoLinkURL\": \"https://www.youtube.com/watch?v=example\", \"classSchedule\": \"2026-09-21T18:00:00.000Z\"}]',1,'2026-09-18 14:26:18','2026-09-18 14:26:18'); /*!40000 ALTER TABLE `skills` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `transactions` -- DROP TABLE IF EXISTS `transactions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `transactions` ( `id` char(36) NOT NULL, `transactionRefId` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `transactionCode` varchar(100) NOT NULL, `transactionAmount` decimal(12,2) NOT NULL, `createdAt` datetime DEFAULT CURRENT_TIMESTAMP, `authorEmail` varchar(150) NOT NULL, PRIMARY KEY (`id`), KEY `idx_transaction_ref_id` (`transactionRefId`), KEY `idx_transaction_code` (`transactionCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `transactions` -- LOCK TABLES `transactions` WRITE; /*!40000 ALTER TABLE `transactions` DISABLE KEYS */; INSERT INTO `transactions` VALUES ('0d4ebe0c-8aa7-4727-9e2a-a8cd54df9f8a','35ee3124-c38d-43df-9e69-b8ff99c909a4','Course Fee','sf001',1200.00,'2026-09-20 20:22:55','rihanulislam2015@gmail.com'),('38996171-6b30-40fa-a7ac-b33cf36fba8a','35ee3124-c38d-43df-9e69-b8ff99c909a4','Course Fee','sf001',1200.00,'2026-09-20 20:22:24','rihanulislam2015@gmail.com'),('529a60a5-de4e-40ed-8c43-cbd65acb3520','35ee3124-c38d-43df-9e69-b8ff99c909a4','Course Fee','sf001',1200.00,'2026-09-19 22:49:51',''),('5c0df60d-2c7a-46f1-9a8c-7ee713449565','35ee3124-c38d-43df-9e69-b8ff99c909a4','Course Fee','sf001',1200.00,'2026-09-20 20:21:06','rihanulislam2015@gmail.com'),('678a070f-54db-4bc7-b77a-ab8a6483f9b0','35ee3124-c38d-43df-9e69-b8ff99c909a4','Course Fee','sf001',1200.00,'2026-09-20 20:03:01',''),('8c112ace-c033-4f9f-942a-9487c72d34ed','35ee3124-c38d-43df-9e69-b8ff99c909a4','Course Fee','sf001',1200.00,'2026-09-20 20:18:00','rihanulislam2015@gmail.com'),('d97577a6-f02d-4e77-a7be-840c87fbfa06','35ee3124-c38d-43df-9e69-b8ff99c909a4','Course Fee','sf001',1200.00,'2026-09-20 20:14:57','rihanulislam2015@gmail.com'),('f0975351-8924-439f-b8b2-8746e9271274','35ee3124-c38d-43df-9e69-b8ff99c909a4','Course Fee','sf001',1200.00,'2026-09-20 20:14:54','rihanulislam2015@gmail.com'); /*!40000 ALTER TABLE `transactions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` char(36) NOT NULL, `firstName` varchar(100) NOT NULL, `lastName` varchar(100) DEFAULT NULL, `email` varchar(150) NOT NULL, `phone` varchar(20) DEFAULT NULL, `passwordHash` varchar(255) NOT NULL, `profileImageUrl` varchar(500) DEFAULT NULL, `roleId` char(36) DEFAULT NULL, `bloodGroupId` char(36) DEFAULT NULL, `batchId` char(36) DEFAULT NULL, `passingYearId` char(36) DEFAULT NULL, `departmentId` char(36) DEFAULT NULL, `memberTypeId` char(36) DEFAULT NULL, `status` int DEFAULT '1', `isActive` tinyint(1) DEFAULT '1', `isVerified` tinyint(1) DEFAULT '0', `isDeleted` tinyint(1) DEFAULT '0', `resetPasswordToken` varchar(255) DEFAULT NULL, `resetPasswordExpires` datetime DEFAULT NULL, `lastLoginDate` datetime DEFAULT NULL, `createdAt` datetime DEFAULT CURRENT_TIMESTAMP, `updatedAt` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `otp` int DEFAULT NULL, `isLeaderShip` tinyint(1) DEFAULT '0', `isNotableAlumni` tinyint(1) DEFAULT '0', `isDonors` tinyint(1) DEFAULT '0', `galleryIds` text, `socialMediaLinks` json DEFAULT NULL, `description` text, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_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 ('1adfc154-ce8b-4ee8-b5bd-a58ef3e1409e','Raihanul','Islam','raihanul@example.com','01700000000','$2b$10$L8mHVfv3Wlfl6/xnXRXt0OAGhiC6pObGqOysfMg7NmbUnzYFzXovO','/uploads/galleries/a8dd6f4deae8906bd6cd8b5fcb20532f','7a98f013-95aa-11f1-83c3-e8d8d1a2cb0a','3fa85f64-5717-4562-b3fc-2c963f66afa6','3fa85f64-5717-4562-b3fc-2c963f66afa6','3fa85f64-5717-4562-b3fc-2c963f66afa6','3fa85f64-5717-4562-b3fc-2c963f66afa6','3fa85f64-5717-4562-b3fc-2c963f66afa6',1,1,0,0,NULL,NULL,'2026-09-18 21:11:34','2026-09-18 20:40:22','2026-09-20 15:07:16',NULL,1,1,1,'3fa85f64-5717-4562-b3fc-2c963f66afa6','[{\"url\": \"https://facebook.com/example\", \"icon\": \"facebook\", \"title\": \"Facebook\"}]','Software Engineer'),('9075b39c-3855-4d98-a97e-8573c7a048f1','Raihanul Islam','Sharif','rihanthedev@gmail.com','01317172725','$2b$10$YdRMOtG8ZncQUKwm.NAadOQJctNKtczXJkCsGj23B/PxOE7oGdUha','https://avatars.githubusercontent.com/u/109515629?v=4','7a98f013-95aa-11f1-83c3-e8d8d1a2cb0a','A3ED207B-1AB9-462D-8B21-DD4AFE30077C','171265B5-FB77-4282-86A2-C31140403235','C0E4C1D1-E028-4EBA-9141-3209FEC6146A','d3b9551f-95ad-11f1-83c3-e8d8d1a2cb0a','0581FDF1-91F9-4396-9783-C450B3620E01',1,1,0,0,NULL,NULL,'2026-09-15 11:58:06','2026-09-15 11:52:34','2026-09-19 21:40:24',NULL,0,0,0,NULL,NULL,NULL); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `video_galleries` -- DROP TABLE IF EXISTS `video_galleries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `video_galleries` ( `id` char(36) NOT NULL, `filename` varchar(255) NOT NULL, `video_url` varchar(500) NOT NULL, `sorting` int NOT NULL DEFAULT '0', `is_deleted` tinyint(1) NOT NULL DEFAULT '0', `is_active` tinyint(1) NOT NULL DEFAULT '1', `is_home_page` tinyint(1) NOT NULL DEFAULT '0', `is_popup_show` tinyint(1) NOT NULL DEFAULT '0', `is_top_slide` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `video_galleries` -- LOCK TABLES `video_galleries` WRITE; /*!40000 ALTER TABLE `video_galleries` DISABLE KEYS */; INSERT INTO `video_galleries` VALUES ('b938fe0a-23c7-4b43-bd3c-fa8e5a4677ac','How to publish Api','https://youtu.be/2NTHpR2SN-A',0,0,1,0,0,0,'2026-08-24 20:26:19','2026-08-24 20:26:19'),('f4f03a3c-37a2-4476-a133-598e2f4837f5','How to publish website','https://youtuwwwwwwwwwbe.com/...',5,1,1,0,1,0,'2026-08-24 20:26:19','2026-08-24 20:28:50'); /*!40000 ALTER TABLE `video_galleries` 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-09-20 21:48:20