-- MariaDB dump 10.19 Distrib 10.4.32-MariaDB, for Win64 (AMD64) -- -- Host: localhost Database: ivap -- ------------------------------------------------------ -- Server version 10.4.32-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 `application_centers` -- DROP TABLE IF EXISTS `application_centers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `application_centers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `country_slug` varchar(100) NOT NULL, `country_name` varchar(150) NOT NULL, `center_name` varchar(255) NOT NULL, `hub_group` varchar(100) DEFAULT 'Main Centers', `address` text DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `sort_order` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `country_slug_idx` (`country_slug`), KEY `is_active_idx` (`is_active`) ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `application_centers` -- LOCK TABLES `application_centers` WRITE; /*!40000 ALTER TABLE `application_centers` DISABLE KEYS */; INSERT INTO `application_centers` VALUES (1,'india','India','Dhaka - Jamuna Future Park (JFP)','Dhaka Hub','Level 2, Jamuna Future Park, Progoti Sharani, Dhaka',1,1,'2026-10-09 12:35:38','2026-10-09 12:35:38'),(2,'india','India','Dhaka - Gulshan','Dhaka Hub','House 12, Road 137, Gulshan-1, Dhaka',1,2,'2026-10-09 12:35:38','2026-10-09 12:35:38'),(3,'india','India','Dhaka - Dhanmondi','Dhaka Hub','Road 2, Dhanmondi, Dhaka',1,3,'2026-10-09 12:35:38','2026-10-09 12:35:38'),(4,'india','India','Chittagong','Regional Centers','2/1 Habib Lane, World Trade Center, Agrabad C/A, Chittagong',1,4,'2026-10-09 12:35:38','2026-10-09 12:35:38'),(5,'india','India','Rajshahi','Regional Centers','Moron Ali Road, Kazihata, Rajshahi',1,5,'2026-10-09 12:35:38','2026-10-09 12:35:38'),(6,'india','India','Sylhet','Regional Centers','Rose View Complex, Uposhohor, Sylhet',1,6,'2026-10-09 12:35:38','2026-10-09 12:35:38'),(7,'india','India','Khulna','Regional Centers','KDA Avenue, Khulna',1,7,'2026-10-09 12:35:38','2026-10-09 12:35:38'),(8,'india','India','Jessore','Regional Centers','Rail Road, Jessore',1,8,'2026-10-09 12:35:38','2026-10-09 12:35:38'),(9,'india','India','Barisal','Regional Centers','Sadhar Road, Barisal',1,9,'2026-10-09 12:35:38','2026-10-09 12:35:38'),(10,'india','India','Mymensingh','Regional Centers','Choto Bazar, Mymensingh',1,10,'2026-10-09 12:35:38','2026-10-09 12:35:38'),(11,'india','India','Rangpur','Regional Centers','Station Road, Rangpur',1,11,'2026-10-09 12:35:38','2026-10-09 12:35:38'),(12,'india','India','Thakurgaon','Regional Centers','Old Bus Stand, Thakurgaon',1,12,'2026-10-09 12:35:39','2026-10-09 12:35:39'),(13,'india','India','Bogura','Regional Centers','Shatmatha, Bogura',1,13,'2026-10-09 12:35:39','2026-10-09 12:35:39'),(14,'india','India','Satkhira','Regional Centers','Court Road, Satkhira',1,14,'2026-10-09 12:35:39','2026-10-09 12:35:39'),(15,'india','India','Brahmanbaria','Regional Centers','Halder Para, Brahmanbaria',1,15,'2026-10-09 12:35:39','2026-10-09 12:35:39'),(16,'india','India','Noakhali','Regional Centers','Maijdee Court, Noakhali',1,16,'2026-10-09 12:35:39','2026-10-09 12:35:39'),(17,'india','India','Comilla','Regional Centers','Badurtola, Comilla',1,17,'2026-10-09 12:35:39','2026-10-09 12:35:39'),(18,'thailand','Thailand','Dhaka - VFS Global Thailand Center (Gulshan)','Dhaka Hub','Nafi Tower, 53 Gulshan Avenue, Dhaka',1,1,'2026-10-09 12:35:39','2026-10-09 12:35:39'),(19,'thailand','Thailand','Dhaka - Royal Thai Embassy Desk','Dhaka Hub','18 & 20 Madani Avenue, Baridhara, Dhaka',1,2,'2026-10-09 12:35:39','2026-10-09 12:35:39'),(20,'thailand','Thailand','Chittagong - VFS Thailand Visa Desk','Regional Centers','Agrabad Commercial Area, Chittagong',1,3,'2026-10-09 12:35:39','2026-10-09 12:35:39'),(21,'thailand','Thailand','Sylhet - Thailand Visa Drop Center','Regional Centers','Subidbazar, Sylhet',1,4,'2026-10-09 12:35:40','2026-10-09 12:35:40'),(22,'united-kingdom-london','UK (London)','Dhaka - VFS Global UK Visa Center (Delta Life Tower, Gulshan-2)','Dhaka Hub','Delta Life Tower, Plot 37, Road 90, Gulshan-2, Dhaka',1,1,'2026-10-09 12:35:40','2026-10-09 12:35:40'),(23,'united-kingdom-london','UK (London)','Sylhet - VFS Global UK Visa Center (Subidbazar)','Regional Centers','7th Floor, Nirvana Inn, Mirza Jungle Road, Sylhet',1,2,'2026-10-09 12:35:40','2026-10-09 12:35:40'),(24,'china','China','Dhaka - Chinese Visa Application Center (Banani)','Dhaka Hub','Prasad Trade Center, Kemal Ataturk Avenue, Banani, Dhaka',1,1,'2026-10-09 12:35:40','2026-10-09 12:35:40'),(25,'china','China','Chittagong - Chinese Visa Drop Box','Regional Centers','GEC Circle, Chittagong',1,2,'2026-10-09 12:35:40','2026-10-09 12:35:40'),(26,'pakistan','Pakistan','Dhaka - High Commission of Pakistan Visa Desk (Gulshan-2)','Dhaka Hub','NE(C)-2, Road 71, Gulshan-2, Dhaka',1,1,'2026-10-09 12:35:40','2026-10-09 12:35:40'),(27,'indonesia','Indonesia','Dhaka - Embassy of Indonesia Visa Section (Gulshan-2)','Dhaka Hub','Road 53, Plot 14, Gulshan-2, Dhaka',1,1,'2026-10-09 12:35:40','2026-10-09 12:35:40'),(28,'bangladesh-e-passport','Bangladesh','Dhaka - Agargaon Passport Office','Dhaka Hub','Agargaon, Sher-e-Bangla Nagar, Dhaka',1,1,'2026-10-09 12:35:40','2026-10-09 12:35:40'),(29,'bangladesh-e-passport','Bangladesh','Dhaka - Uttara Passport Office','Dhaka Hub','Sector 3, Uttara, Dhaka',1,2,'2026-10-09 12:35:41','2026-10-09 12:35:41'),(30,'bangladesh-e-passport','Bangladesh','Dhaka - Jatrabari Passport Office','Dhaka Hub','South Jatrabari, Dhaka',1,3,'2026-10-09 12:35:41','2026-10-09 12:35:41'),(31,'bangladesh-e-passport','Bangladesh','Regional Passport Office (All 64 Districts)','Regional Centers','Authorized District Passport Office',1,4,'2026-10-09 12:35:41','2026-10-09 12:35:41'); /*!40000 ALTER TABLE `application_centers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache` -- DROP TABLE IF EXISTS `cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL, PRIMARY KEY (`key`), KEY `cache_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache` -- LOCK TABLES `cache` WRITE; /*!40000 ALTER TABLE `cache` DISABLE KEYS */; /*!40000 ALTER TABLE `cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache_locks` -- DROP TABLE IF EXISTS `cache_locks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL, PRIMARY KEY (`key`), KEY `cache_locks_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache_locks` -- LOCK TABLES `cache_locks` WRITE; /*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */; /*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `categories` -- DROP TABLE IF EXISTS `categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `categories` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `icon` varchar(255) DEFAULT NULL, `badge` varchar(255) DEFAULT NULL, `description` text DEFAULT NULL, `sort_order` int(11) NOT NULL DEFAULT 0, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `categories_slug_unique` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `categories` -- LOCK TABLES `categories` WRITE; /*!40000 ALTER TABLE `categories` DISABLE KEYS */; INSERT INTO `categories` VALUES (1,'Visa Processing','visa-processing','fas fa-passport','Most Popular','Comprehensive visa application, embassy appointment, documentation & processing services for worldwide destinations.',1,1,'2026-10-08 03:27:10','2026-10-08 03:27:10'),(2,'Passport Processing','passport-processing','fas fa-id-card','Quick Service','E-Passport new issuance, urgent re-issue, correction, and delivery tracking assistance across Bangladesh.',2,1,'2026-10-08 03:27:10','2026-10-08 03:27:10'),(3,'Dollar Exchanges & Endorsement','dollar-exchanges','fas fa-money-bill-wave','Instant Support','Official passport dollar endorsement, international travel card enrollment, and forex currency exchange advisory.',3,1,'2026-10-08 03:27:10','2026-10-08 03:27:10'); /*!40000 ALTER TABLE `categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contacts` -- DROP TABLE IF EXISTS `contacts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contacts` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) DEFAULT NULL, `subject` varchar(255) NOT NULL, `message` text NOT NULL, `status` enum('unread','read','replied') NOT NULL DEFAULT 'unread', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contacts` -- LOCK TABLES `contacts` WRITE; /*!40000 ALTER TABLE `contacts` DISABLE KEYS */; /*!40000 ALTER TABLE `contacts` 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 = utf8 */; 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 `inbox_messages` -- DROP TABLE IF EXISTS `inbox_messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `inbox_messages` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `folder` enum('inbox','sent','draft','trash','starred','spam') NOT NULL DEFAULT 'inbox', `sender_name` varchar(255) DEFAULT NULL, `sender_email` varchar(255) NOT NULL, `recipient_email` varchar(255) NOT NULL, `subject` varchar(255) NOT NULL, `body` longtext NOT NULL, `is_read` tinyint(1) NOT NULL DEFAULT 0, `is_starred` tinyint(1) NOT NULL DEFAULT 0, `is_important` tinyint(1) NOT NULL DEFAULT 0, `attachments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`attachments`)), `labels` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT 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 `inbox_messages` -- LOCK TABLES `inbox_messages` WRITE; /*!40000 ALTER TABLE `inbox_messages` DISABLE KEYS */; INSERT INTO `inbox_messages` VALUES (1,'inbox','High Commission of India (Dhaka)','visasection.dhaka@mea.gov.in','ivap@devstudioslab.com','IVAC Slot Confirmation & Biometric Appointment Schedule Update','Dear IVAP Support Team,\n\nThis is to confirm that new appointment slots for Tourist, Double Entry, and Medical Visa categories for the upcoming month have been released on the IVAC portal.\n\nPlease ensure that all submitted application forms have barcodes clearly readable and accompanied by the updated utility bill verification.\n\nRegards,\nVisa Section\nHigh Commission of India, Dhaka',1,1,1,NULL,'[\"Embassy Updates\", \"VIP Client\"]','2026-10-08 03:27:15','2026-10-08 03:27:15'),(2,'inbox','Rahim Chowdhury','rahim.chowdhury@gmail.com','ivap@devstudioslab.com','Urgent Medical Visa inquiry for Apollo Hospitals Chennai','Hello IVAP,\n\nI need an urgent Indian Medical Visa for my mother. We have received the invitation letter from Apollo Hospital Chennai today. How soon can we get the appointment and submit our passports?\n\nKindly advice the total cost and required documents.\n\nThank you,\nRahim Chowdhury\nPhone: 01712-334455',1,0,1,NULL,'[\"Urgent\"]','2026-10-08 03:27:15','2026-10-08 08:53:19'),(3,'inbox','UK Visa and Immigration (VFS Global)','notifications@vfshelpline.com','ivap@devstudioslab.com','Document Upload Verification Status - UK Standard Visitor','Dear Partner,\n\nThe self-upload digital document checklist for your corporate clients has been successfully synced with the UKVI Decision Making Centre.\n\nThank you for choosing VFS Global Dhaka.',1,0,0,NULL,'[\"Pending Docs\"]','2026-10-08 03:27:15','2026-10-08 03:27:15'),(4,'sent','IVAP Operations','ivap@devstudioslab.com','user@ivap.com','Your Thailand Tourist Visa has been Approved! (Order: IVAP-202610-1002)','Dear Tanvir Hossain,\n\nCongratulations! Your Thailand Tourist Visa has been approved by the Royal Thai Embassy Dhaka.\n\nYou can now log in to your IVAP dashboard or click the tracking link to download your official approved visa certificate.\n\nSafe travels!\nIVAP Support Team\nivap@devstudioslab.com',1,1,1,NULL,NULL,'2026-10-08 03:27:15','2026-10-08 03:27:15'); /*!40000 ALTER TABLE `inbox_messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_batches` -- DROP TABLE IF EXISTS `job_batches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_batches` -- LOCK TABLES `job_batches` WRITE; /*!40000 ALTER TABLE `job_batches` DISABLE KEYS */; /*!40000 ALTER TABLE `job_batches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) unsigned NOT NULL, `reserved_at` int(10) unsigned DEFAULT NULL, `available_at` int(10) unsigned NOT NULL, `created_at` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mail_labels` -- DROP TABLE IF EXISTS `mail_labels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mail_labels` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `slug` varchar(100) NOT NULL, `color` varchar(20) NOT NULL DEFAULT '#0F52BA', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `slug` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mail_labels` -- LOCK TABLES `mail_labels` WRITE; /*!40000 ALTER TABLE `mail_labels` DISABLE KEYS */; INSERT INTO `mail_labels` VALUES (1,'Urgent','urgent','#EF4444','2026-10-08 14:55:50','2026-10-08 14:55:50'),(2,'Embassy Updates','embassy-updates','#10B981','2026-10-08 14:55:50','2026-10-08 14:55:50'),(3,'VIP Client','vip-client','#8B5CF6','2026-10-08 14:55:50','2026-10-08 14:55:50'),(4,'Pending Docs','pending-docs','#F59E0B','2026-10-08 14:55:50','2026-10-08 14:55:50'),(5,'Billing / Payment','billing-payment','#06B6D4','2026-10-08 14:55:50','2026-10-08 14:55:50'); /*!40000 ALTER TABLE `mail_labels` 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 = utf8 */; 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,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2026_10_08_000001_create_ivap_core_tables',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order_documents` -- DROP TABLE IF EXISTS `order_documents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `order_documents` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `order_id` bigint(20) unsigned NOT NULL, `document_name` varchar(255) NOT NULL, `file_path` varchar(255) NOT NULL, `file_type` varchar(255) DEFAULT NULL, `file_size` varchar(255) DEFAULT NULL, `uploaded_by` varchar(255) NOT NULL DEFAULT 'Admin', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `order_documents_order_id_foreign` (`order_id`), CONSTRAINT `order_documents_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `order_documents` -- LOCK TABLES `order_documents` WRITE; /*!40000 ALTER TABLE `order_documents` DISABLE KEYS */; INSERT INTO `order_documents` VALUES (1,2,'Official E-Visa Grant Letter (Approved)','demo/thailand_visa_approved.pdf','pdf','245 KB','Super Admin','2026-10-09 08:52:46','2026-10-09 08:52:46'),(2,2,'Indian High Commission Visa Sticker Scan','demo/sample_prev_visa.png','png','1.2 MB','Super Admin','2026-10-09 08:52:46','2026-10-09 08:52:46'),(4,1,'Official India Conference Visa Approved Letter','visas/sevVlDRCOtIahAsI0tmWBFjCFqO5NleYHLVSonB8.pdf','pdf','150 KB','Admin','2026-10-09 09:12:58','2026-10-09 09:12:58'),(5,1,'BGDDW3C4FA26NA911009.pdf','visas/Ca4IoZDD1Aa4c6JdDB2linbZUAc9FtzASupx1PwL.pdf','pdf','297.6 KB','IVAP Super Admin','2026-10-09 09:16:51','2026-10-09 09:16:51'); /*!40000 ALTER TABLE `order_documents` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `order_timelines` -- DROP TABLE IF EXISTS `order_timelines`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `order_timelines` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `order_id` bigint(20) unsigned NOT NULL, `status_key` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `updated_by` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `order_timelines_order_id_foreign` (`order_id`), CONSTRAINT `order_timelines_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `order_timelines` -- LOCK TABLES `order_timelines` WRITE; /*!40000 ALTER TABLE `order_timelines` DISABLE KEYS */; INSERT INTO `order_timelines` VALUES (1,1,'order_placed','Order Placed & App Fee Received','Customer initiated order and paid Application Fee BDT 850 via bKash (Trx: BK9X7281A4).','System','2026-10-08 03:27:14','2026-10-08 03:27:14'),(2,1,'document_received','Documents Verified by IVAP Team','Passport, NID, and utility bill verified against high commission checklist.','Admin IVAP','2026-10-08 03:27:14','2026-10-08 03:27:14'),(3,1,'embassy_processing','Submitted to High Commission / In Processing','Application dossier submitted to Indian Visa Application Center (IVAC). Awaiting decision.','Admin IVAP','2026-10-08 03:27:14','2026-10-08 03:27:14'),(4,2,'completed','Visa Approved & Ready for Download','Visa approved by the Royal Thai Embassy. Full payment verified. PDF uploaded.','Admin IVAP','2026-10-08 03:27:15','2026-10-08 03:27:15'),(5,2,'visa_uploaded','Approved Visa Document Uploaded','Official Visa PDF file has been uploaded and made available for customer download.','IVAP Super Admin','2026-10-09 06:37:08','2026-10-09 06:37:08'),(6,1,'due_paid','Remaining Balance Cleared','Customer settled remaining balance of BDT 1700.00 via bkash (Trx: 12345).','Customer','2026-10-09 09:04:01','2026-10-09 09:04:01'),(7,1,'charge_added','Additional Fee Added: BDT 200.00','Reason: VIP Fast Track & Lounge. Updated Total Order Value: BDT 2,550.00. Remaining Due: BDT 1,700.00.','Admin','2026-10-09 09:09:18','2026-10-09 09:09:18'),(8,1,'payment_update','Payment Recorded: BDT 500.00 (bkash)','TrxID: BKTEST9922. Total Paid To Date: BDT 1,350.00. Remaining Due: BDT 1,200.00 (Status: Advance paid).','Admin','2026-10-09 09:09:18','2026-10-09 09:09:18'),(9,1,'visa_uploaded','New Visa Document Uploaded: Official India Conference Visa Approved Letter','Uploaded Test_Approved_Visa.pdf (150 KB). Available for customer portal access and downloads.','Admin','2026-10-09 09:12:58','2026-10-09 09:12:58'),(10,1,'visa_uploaded','New Visa Document Uploaded: BGDDW3C4FA26NA911009.pdf','Uploaded BGDDW3C4FA26NA911009.pdf (297.6 KB). Available for customer portal access and downloads.','IVAP Super Admin','2026-10-09 09:16:51','2026-10-09 09:16:51'),(11,1,'document_deleted','Document Removed: in','Document file was permanently deleted by IVAP Super Admin.','IVAP Super Admin','2026-10-09 09:17:01','2026-10-09 09:17:01'); /*!40000 ALTER TABLE `order_timelines` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orders` -- DROP TABLE IF EXISTS `orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `orders` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `order_number` varchar(255) NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `customer_name` varchar(255) NOT NULL, `customer_email` varchar(255) NOT NULL, `customer_phone` varchar(255) NOT NULL, `customer_address` text DEFAULT NULL, `passport_number` varchar(255) DEFAULT NULL, `nid_number` varchar(255) DEFAULT NULL, `service_id` bigint(20) unsigned DEFAULT NULL, `service_name` varchar(255) NOT NULL, `category_name` varchar(255) DEFAULT NULL, `country_name` varchar(255) DEFAULT NULL, `app_fee` decimal(12,2) NOT NULL DEFAULT 0.00, `processing_fee` decimal(12,2) NOT NULL DEFAULT 0.00, `additional_charges` decimal(12,2) NOT NULL DEFAULT 0.00, `need_noc` tinyint(1) DEFAULT 0, `additional_charges_note` varchar(255) DEFAULT NULL, `total_amount` decimal(12,2) NOT NULL DEFAULT 0.00, `paid_amount` decimal(12,2) NOT NULL DEFAULT 0.00, `due_amount` decimal(12,2) NOT NULL DEFAULT 0.00, `payment_method` varchar(255) DEFAULT NULL, `payment_trx_id` varchar(255) DEFAULT NULL, `payment_receipt` varchar(255) DEFAULT NULL, `payment_status` enum('pending_verification','advance_paid','fully_paid','cancelled') NOT NULL DEFAULT 'pending_verification', `order_status` varchar(50) NOT NULL DEFAULT 'order_placed', `passport_file` varchar(255) DEFAULT NULL, `nid_file` varchar(255) DEFAULT NULL, `utility_bill_file` varchar(255) DEFAULT NULL, `photo_file` varchar(255) DEFAULT NULL, `extra_doc_file` varchar(255) DEFAULT NULL, `admin_note` text DEFAULT NULL, `task_managed_by` varchar(255) DEFAULT NULL, `task_managed_amount` decimal(12,2) NOT NULL DEFAULT 0.00, `file_ready_by` varchar(255) DEFAULT NULL, `file_ready_amount` decimal(12,2) NOT NULL DEFAULT 0.00, `app_processed_by` varchar(255) DEFAULT NULL, `app_processed_amount` decimal(12,2) NOT NULL DEFAULT 0.00, `customer_note` text DEFAULT NULL, `application_data` longtext DEFAULT NULL, `visa_document_file` varchar(255) DEFAULT NULL, `visa_document_name` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `orders_order_number_unique` (`order_number`), KEY `orders_user_id_foreign` (`user_id`), KEY `orders_service_id_foreign` (`service_id`), CONSTRAINT `orders_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE SET NULL, CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orders` -- LOCK TABLES `orders` WRITE; /*!40000 ALTER TABLE `orders` DISABLE KEYS */; INSERT INTO `orders` VALUES (1,'IVAP-202610-1001',2,'Tanvir Hossain','user@ivap.com','+8801819876543','House 42, Road 11, Banani, Dhaka-1213','A08927461','19922692019485721',1,'India Tourist Visa','Visa Processing','India',850.00,1500.00,200.00,0,'VIP Fast Track & Lounge',2550.00,1350.00,1200.00,'bkash','BK9X7281A4 | Due Paid: 12345 (bkash) | Due Paid: BKTEST9922 (bkash)',NULL,'advance_paid','visa_approved','demo/passport_sample.pdf','demo/nid_sample.pdf','demo/utility_bill_sample.pdf','demo/photo_sample.jpg',NULL,'IVAC slot booked for next Tuesday. Submitted to high commission.',NULL,0.00,NULL,0.00,NULL,0.00,'Please expedite if possible as my flight is scheduled next month.','{\"given_name\":\"Tanvir\",\"surname\":\"Hossain\",\"present_address\":\"House 42, Road 11, Banani, Dhaka-1213\",\"permanent_address\":\"House 42, Road 11, Banani, Dhaka-1213 (Permanent District)\",\"ivac_center\":\"Dhaka (Jamuna Future Park - IVAC Hub)\",\"father_birth_place\":\"Dhaka, Bangladesh\",\"mother_birth_place\":\"Chattogram, Bangladesh\",\"visited_india_before\":\"yes\",\"prev_india_visa_number\":\"V9109262\",\"prev_india_visa_file\":null,\"prev_india_hotel_info\":\"Hotel Peerless Inn, Chowringhee Road, Kolkata\",\"marital_status\":\"married\",\"spouse_name\":\"Farhana Akter\",\"spouse_birth_place\":\"Dhaka, Bangladesh\",\"visited_other_countries_10yr\":\"yes\",\"other_countries_list\":\"India, Thailand, Nepal, Malaysia\",\"visited_saarc_countries\":\"yes\",\"saarc_visits\":[{\"country\":\"Nepal\",\"times\":2},{\"country\":\"India\",\"times\":3}],\"emergency_contact\":{\"name\":\"Kabir Hossain\",\"phone\":\"+8801700000000\",\"email\":\"kabir@gmail.com\",\"address\":\"Dhaka, Bangladesh\"},\"professional_info\":{\"company_name\":\"Corporate Enterprise Ltd.\",\"designation\":\"Executive Officer\",\"company_phone\":\"+88029999999\",\"company_address\":\"Gulshan 2, Dhaka-1212\"},\"need_noc\":false}','visas/Ca4IoZDD1Aa4c6JdDB2linbZUAc9FtzASupx1PwL.pdf','BGDDW3C4FA26NA911009.pdf','2026-10-08 03:27:14','2026-10-09 09:16:51'),(2,'IVAP-202610-1002',2,'Tanvir Hossain','user@ivap.com','+8801819876543','Flat 4B, House 42, Road 11, Banani, Dhaka-1213','A08927461','19922692019485721',8,'Thailand Tourist Visa','Visa Processing','Thailand',4000.00,2000.00,0.00,1,NULL,6000.00,6000.00,0.00,'nagad','NG99881122','demo/sample_payment_slip.jpg','fully_paid','completed','demo/passport_sample.pdf','demo/nid_sample.pdf','demo/utility_bill_sample.pdf','demo/photo_sample.jpg','demo/sample_prev_visa.png','Thai Embassy approved single entry tourist visa. Download ready.',NULL,0.00,NULL,0.00,NULL,0.00,'Please expedite document verification before IVAC appointment submission. We need official conference endorsement letter reviewed.','{\"given_name\":\"Tanvir\",\"surname\":\"Hossain\",\"present_address\":\"Flat 4B, House 42, Road 11, Block D, Banani, Dhaka-1213 (Same as DPDC Utility Bill)\",\"permanent_address\":\"Village: Rasulpur, PO: Shibganj, Upazila: Bogura Sadar, District: Bogura-5800 (As per NID)\",\"ivac_center\":\"Dhaka (Jamuna Future Park - IVAC JFP Hub)\",\"father_birth_place\":\"Bogura, Bangladesh\",\"mother_birth_place\":\"Rajshahi, Bangladesh\",\"visited_india_before\":\"yes\",\"prev_india_visa_number\":\"V1948201\",\"prev_india_visa_file\":\"demo\\/sample_prev_visa.png\",\"prev_india_hotel_info\":\"The Oberoi Grand, 15 Jawaharlal Nehru Road, New Market, Kolkata, West Bengal 700013. Phone: +91 33 2249 2323 \\/ reservations@oberoihotels.com\",\"marital_status\":\"married\",\"spouse_name\":\"Nusrat Jahan Chowdhury\",\"spouse_birth_place\":\"Dhaka, Bangladesh\",\"visited_other_countries_10yr\":\"yes\",\"other_countries_list\":\"Thailand (Bangkok, Phuket), Malaysia (Kuala Lumpur), United Arab Emirates (Dubai), Singapore, Turkey (Istanbul)\",\"visited_saarc_countries\":\"yes\",\"saarc_visits\":[{\"country\":\"Nepal\",\"times\":2},{\"country\":\"Bhutan\",\"times\":1},{\"country\":\"Sri Lanka\",\"times\":1}],\"emergency_contact\":{\"name\":\"Rafiqul Islam (Brother-in-Law)\",\"phone\":\"+8801712345678\",\"email\":\"rafiq.islam@gmail.com\",\"address\":\"House 18, Road 4, Sector 3, Uttara, Dhaka-1230\"},\"professional_info\":{\"company_name\":\"Apex Technologies Bangladesh Ltd.\",\"designation\":\"Senior Vice President (International Relations)\",\"company_phone\":\"+88028834567\",\"company_address\":\"Level 8, Concord Tower, 113 Kazi Nazrul Islam Avenue, Banglamotor, Dhaka-1000\"},\"need_noc\":true}','visas/2HVUThCVTpyD0621r568YC24h2t7SQVJ9fURVN0O.pdf','BGDDW3C4FA26NA911009.pdf','2026-10-08 03:27:15','2026-10-09 09:16:43'); /*!40000 ALTER TABLE `orders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_reset_tokens` -- DROP TABLE IF EXISTS `password_reset_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_reset_tokens` -- LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `services` -- DROP TABLE IF EXISTS `services`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `services` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `category_id` bigint(20) unsigned NOT NULL, `subcategory_id` bigint(20) unsigned DEFAULT NULL, `name` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL, `visa_type` varchar(255) DEFAULT NULL, `govt_fee` decimal(12,2) NOT NULL DEFAULT 0.00, `processing_fee` decimal(12,2) NOT NULL DEFAULT 0.00, `estimated_days` varchar(255) DEFAULT NULL, `short_description` text DEFAULT NULL, `detailed_description` longtext DEFAULT NULL, `required_documents` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`required_documents`)), `features` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`features`)), `is_featured` tinyint(1) NOT NULL DEFAULT 0, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `services_slug_unique` (`slug`), KEY `services_category_id_foreign` (`category_id`), KEY `services_subcategory_id_foreign` (`subcategory_id`), CONSTRAINT `services_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, CONSTRAINT `services_subcategory_id_foreign` FOREIGN KEY (`subcategory_id`) REFERENCES `subcategories` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `services` -- LOCK TABLES `services` WRITE; /*!40000 ALTER TABLE `services` DISABLE KEYS */; INSERT INTO `services` VALUES (1,1,1,'India Tourist Visa','india-tourist-visa','tourist',850.00,1500.00,'5-8 Working Days','Complete official processing for India Tourist Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for India Tourist Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',1,1,'2026-10-08 03:27:11','2026-10-08 03:27:11'),(2,1,1,'India Medical Visa / Attendant Visa','india-medical-visa-attendant-visa','medical',850.00,2500.00,'3-5 Working Days (Urgent)','Complete official processing for India Medical Visa / Attendant Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for India Medical Visa / Attendant Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',1,1,'2026-10-08 03:27:11','2026-10-08 03:27:11'),(3,1,1,'India Double Entry Visa','india-double-entry-visa','double_entry',850.00,2000.00,'6-10 Working Days','Complete official processing for India Double Entry Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for India Double Entry Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(4,1,1,'India Business Visa','india-business-visa','business',850.00,3500.00,'7-10 Working Days','Complete official processing for India Business Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for India Business Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(5,1,1,'India Student Visa','india-student-visa','student',850.00,3000.00,'10-15 Working Days','Complete official processing for India Student Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for India Student Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(6,1,1,'India Work Visa / Employment Visa','india-work-visa-employment-visa','work_employment',850.00,5000.00,'15-20 Working Days','Complete official processing for India Work Visa / Employment Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for India Work Visa / Employment Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(7,1,1,'India Conference / Event Visa','india-conference-event-visa','conference_event',850.00,3000.00,'7-10 Working Days','Complete official processing for India Conference / Event Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for India Conference / Event Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(8,1,2,'Thailand Tourist Visa','thailand-tourist-visa','tourist',4000.00,2000.00,'5-7 Working Days','Complete official processing for Thailand Tourist Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Thailand Tourist Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',1,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(9,1,2,'Thailand Medical Visa / Attendant Visa','thailand-medical-visa-attendant-visa','medical',4500.00,3000.00,'4-6 Working Days','Complete official processing for Thailand Medical Visa / Attendant Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Thailand Medical Visa / Attendant Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',1,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(10,1,2,'Thailand Double Entry Visa','thailand-double-entry-visa','double_entry',7500.00,3500.00,'7-10 Working Days','Complete official processing for Thailand Double Entry Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Thailand Double Entry Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(11,1,2,'Thailand Business Visa','thailand-business-visa','business',8000.00,4500.00,'6-8 Working Days','Complete official processing for Thailand Business Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Thailand Business Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(12,1,2,'Thailand Student Visa','thailand-student-visa','student',7000.00,4000.00,'10-14 Working Days','Complete official processing for Thailand Student Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Thailand Student Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(13,1,2,'Thailand Work Visa / Employment Visa','thailand-work-visa-employment-visa','work_employment',9500.00,6000.00,'12-15 Working Days','Complete official processing for Thailand Work Visa / Employment Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Thailand Work Visa / Employment Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(14,1,2,'Thailand Conference / Event Visa','thailand-conference-event-visa','conference_event',6500.00,3500.00,'6-8 Working Days','Complete official processing for Thailand Conference / Event Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Thailand Conference / Event Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(15,1,3,'China Tourist Visa','china-tourist-visa','tourist',5200.00,3000.00,'7-10 Working Days','Complete official processing for China Tourist Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for China Tourist Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',1,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(16,1,3,'China Medical Visa / Attendant Visa','china-medical-visa-attendant-visa','medical',6000.00,4000.00,'7-10 Working Days','Complete official processing for China Medical Visa / Attendant Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for China Medical Visa / Attendant Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',1,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(17,1,3,'China Double Entry Visa','china-double-entry-visa','double_entry',7800.00,4500.00,'8-12 Working Days','Complete official processing for China Double Entry Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for China Double Entry Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(18,1,3,'China Business Visa','china-business-visa','business',7000.00,4500.00,'7-10 Working Days','Complete official processing for China Business Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for China Business Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(19,1,3,'China Student Visa','china-student-visa','student',6500.00,4500.00,'10-15 Working Days','Complete official processing for China Student Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for China Student Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(20,1,3,'China Work Visa / Employment Visa','china-work-visa-employment-visa','work_employment',9000.00,6500.00,'12-18 Working Days','Complete official processing for China Work Visa / Employment Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for China Work Visa / Employment Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(21,1,3,'China Conference / Event Visa','china-conference-event-visa','conference_event',6800.00,4000.00,'7-10 Working Days','Complete official processing for China Conference / Event Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for China Conference / Event Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:12','2026-10-08 03:27:12'),(22,1,4,'Pakistan Tourist Visa','pakistan-tourist-visa','tourist',1200.00,2500.00,'7-12 Working Days','Complete official processing for Pakistan Tourist Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Pakistan Tourist Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',1,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(23,1,4,'Pakistan Medical Visa / Attendant Visa','pakistan-medical-visa-attendant-visa','medical',1500.00,3000.00,'7-10 Working Days','Complete official processing for Pakistan Medical Visa / Attendant Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Pakistan Medical Visa / Attendant Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',1,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(24,1,4,'Pakistan Double Entry Visa','pakistan-double-entry-visa','double_entry',2000.00,3500.00,'8-12 Working Days','Complete official processing for Pakistan Double Entry Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Pakistan Double Entry Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(25,1,4,'Pakistan Business Visa','pakistan-business-visa','business',2500.00,4000.00,'7-10 Working Days','Complete official processing for Pakistan Business Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Pakistan Business Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(26,1,4,'Pakistan Student Visa','pakistan-student-visa','student',2000.00,3500.00,'10-15 Working Days','Complete official processing for Pakistan Student Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Pakistan Student Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(27,1,4,'Pakistan Work Visa / Employment Visa','pakistan-work-visa-employment-visa','work_employment',3500.00,5000.00,'15-20 Working Days','Complete official processing for Pakistan Work Visa / Employment Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Pakistan Work Visa / Employment Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(28,1,4,'Pakistan Conference / Event Visa','pakistan-conference-event-visa','conference_event',2000.00,3000.00,'7-10 Working Days','Complete official processing for Pakistan Conference / Event Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Pakistan Conference / Event Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(29,1,5,'United Kingdom (London) Tourist Visa','united-kingdom-london-tourist-visa','tourist',18500.00,6000.00,'15-20 Working Days','Complete official processing for United Kingdom (London) Tourist Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for United Kingdom (London) Tourist Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',1,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(30,1,5,'United Kingdom (London) Medical Visa / Attendant Visa','united-kingdom-london-medical-visa-attendant-visa','medical',25000.00,8000.00,'10-15 Working Days','Complete official processing for United Kingdom (London) Medical Visa / Attendant Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for United Kingdom (London) Medical Visa / Attendant Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',1,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(31,1,5,'United Kingdom (London) Double Entry Visa','united-kingdom-london-double-entry-visa','double_entry',35000.00,10000.00,'15-20 Working Days','Complete official processing for United Kingdom (London) Double Entry Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for United Kingdom (London) Double Entry Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(32,1,5,'United Kingdom (London) Business Visa','united-kingdom-london-business-visa','business',22000.00,8000.00,'12-15 Working Days','Complete official processing for United Kingdom (London) Business Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for United Kingdom (London) Business Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(33,1,5,'United Kingdom (London) Student Visa','united-kingdom-london-student-visa','student',65000.00,12000.00,'15-25 Working Days','Complete official processing for United Kingdom (London) Student Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for United Kingdom (London) Student Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(34,1,5,'United Kingdom (London) Work Visa / Employment Visa','united-kingdom-london-work-visa-employment-visa','work_employment',95000.00,15000.00,'20-30 Working Days','Complete official processing for United Kingdom (London) Work Visa / Employment Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for United Kingdom (London) Work Visa / Employment Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(35,1,5,'United Kingdom (London) Conference / Event Visa','united-kingdom-london-conference-event-visa','conference_event',22000.00,7500.00,'12-15 Working Days','Complete official processing for United Kingdom (London) Conference / Event Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for United Kingdom (London) Conference / Event Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(36,1,6,'Indonesia Tourist Visa','indonesia-tourist-visa','tourist',5500.00,2500.00,'3-5 Working Days','Complete official processing for Indonesia Tourist Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Indonesia Tourist Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',1,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(37,1,6,'Indonesia Medical Visa / Attendant Visa','indonesia-medical-visa-attendant-visa','medical',6000.00,3000.00,'3-5 Working Days','Complete official processing for Indonesia Medical Visa / Attendant Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Indonesia Medical Visa / Attendant Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',1,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(38,1,6,'Indonesia Double Entry Visa','indonesia-double-entry-visa','double_entry',9000.00,4000.00,'5-7 Working Days','Complete official processing for Indonesia Double Entry Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Indonesia Double Entry Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(39,1,6,'Indonesia Business Visa','indonesia-business-visa','business',7500.00,3500.00,'4-6 Working Days','Complete official processing for Indonesia Business Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Indonesia Business Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:13','2026-10-08 03:27:13'),(40,1,6,'Indonesia Student Visa','indonesia-student-visa','student',8000.00,4000.00,'7-10 Working Days','Complete official processing for Indonesia Student Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Indonesia Student Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:14','2026-10-08 03:27:14'),(41,1,6,'Indonesia Work Visa / Employment Visa','indonesia-work-visa-employment-visa','work_employment',12000.00,6000.00,'10-14 Working Days','Complete official processing for Indonesia Work Visa / Employment Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Indonesia Work Visa / Employment Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:14','2026-10-08 03:27:14'),(42,1,6,'Indonesia Conference / Event Visa','indonesia-conference-event-visa','conference_event',6500.00,3000.00,'4-6 Working Days','Complete official processing for Indonesia Conference / Event Visa including IVAC/Embassy appointment, form filling and document verification.','We provide end-to-end guidance for Indonesia Conference / Event Visa. Our services include high commission slot booking, document vetting, invitation letter compliance check, financial solvency preparation, and application tracking.','[\"Original Passport (min 6 months validity)\",\"National ID Card (NID) or Birth Certificate copy\",\"Latest Utility Bill (Electricity\\/Gas\\/Water) Copy\",\"Recent 2x2 inch Passport Size White Background Photo\",\"Bank Statement & Solvency Certificate (if applicable)\"]','[\"100% Error-free Embassy Form Fillup\",\"Fast Track Appointment Booking\",\"Document Notary & Translation Guidance\",\"Live SMS & Dashboard Tracking\",\"Free Consultation & Re-submission Support\"]',0,1,'2026-10-08 03:27:14','2026-10-08 03:27:14'),(43,2,7,'New E-Passport 10-Year (48 Pages)','new-e-passport-10-year-48-pages','passport_service',5750.00,1500.00,'15-21 Working Days','Complete assistance for new 10-year E-Passport online form, police verification support and biometric slot assistance.','Complete assistance for new 10-year E-Passport online form, police verification support and biometric slot assistance. We guide you through biometric booking, bank challan payments, and local passport office coordination.','[\"Original Old Passport \\/ NID Copy\",\"Birth Certificate\",\"Citizenship Certificate \\/ Chairman Certificate\",\"Utility Bill\"]','[\"Online DIP Form Submission\",\"Bank Challan Slip Payment Handling\",\"Police Verification Guidance\",\"Express Delivery Support\"]',1,1,'2026-10-08 03:27:14','2026-10-08 03:27:14'),(44,2,7,'Urgent E-Passport Renewal / Re-issue','urgent-e-passport-renewal','passport_service',8050.00,2000.00,'7-10 Working Days','Fast track urgent passport re-issue for expired or damaged passports with quick biometric booking.','Fast track urgent passport re-issue for expired or damaged passports with quick biometric booking. We guide you through biometric booking, bank challan payments, and local passport office coordination.','[\"Original Old Passport \\/ NID Copy\",\"Birth Certificate\",\"Citizenship Certificate \\/ Chairman Certificate\",\"Utility Bill\"]','[\"Online DIP Form Submission\",\"Bank Challan Slip Payment Handling\",\"Police Verification Guidance\",\"Express Delivery Support\"]',1,1,'2026-10-08 03:27:14','2026-10-08 03:27:14'),(45,2,7,'Passport Information & Name/DOB Correction','passport-information-correction-assistance','passport_service',3450.00,2500.00,'15-30 Working Days','Legal and affidavit advisory to correct names, parents names, date of birth matching NID according to DIP circular.','Legal and affidavit advisory to correct names, parents names, date of birth matching NID according to DIP circular. We guide you through biometric booking, bank challan payments, and local passport office coordination.','[\"Original Old Passport \\/ NID Copy\",\"Birth Certificate\",\"Citizenship Certificate \\/ Chairman Certificate\",\"Utility Bill\"]','[\"Online DIP Form Submission\",\"Bank Challan Slip Payment Handling\",\"Police Verification Guidance\",\"Express Delivery Support\"]',1,1,'2026-10-08 03:27:14','2026-10-08 03:27:14'),(46,3,8,'Passport Dollar Endorsement Support','passport-dollar-endorsement-support','dollar_endorsement',500.00,1000.00,'Same Day / 24 Hours','Official bank endorsement up to $12,000 yearly quota on your valid Bangladeshi passport with cash forex / card.','Official bank endorsement up to $12,000 yearly quota on your valid Bangladeshi passport with cash forex / card. Authorized partner banking channels for smooth foreign transaction without hassle.','[\"Valid Passport (Original)\",\"Valid Visa \\/ Air Ticket Copy\",\"2 Passport Size Photos\",\"Active NID\"]','[\"Bangladesh Bank Quota Compliance\",\"Zero Hidden Markups\",\"Cash & Card Loading Options\",\"Instant Certificate Receipt\"]',1,1,'2026-10-08 03:27:14','2026-10-08 03:27:14'),(47,3,8,'Dual Currency Travel Card Enrollment','dual-currency-travel-card-enrollment','dollar_endorsement',0.00,1500.00,'1-2 Working Days','Hassle-free international multi-currency Visa/MasterCard card creation with instant e-commerce and POS activation.','Hassle-free international multi-currency Visa/MasterCard card creation with instant e-commerce and POS activation. Authorized partner banking channels for smooth foreign transaction without hassle.','[\"Valid Passport (Original)\",\"Valid Visa \\/ Air Ticket Copy\",\"2 Passport Size Photos\",\"Active NID\"]','[\"Bangladesh Bank Quota Compliance\",\"Zero Hidden Markups\",\"Cash & Card Loading Options\",\"Instant Certificate Receipt\"]',1,1,'2026-10-08 03:27:14','2026-10-08 03:27:14'); /*!40000 ALTER TABLE `services` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `sessions_user_id_index` (`user_id`), KEY `sessions_last_activity_index` (`last_activity`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sessions` -- LOCK TABLES `sessions` WRITE; /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `key` varchar(255) NOT NULL, `value` text DEFAULT NULL, `group` varchar(255) NOT NULL DEFAULT 'general', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `settings_key_unique` (`key`) ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings` -- LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; INSERT INTO `settings` VALUES (1,'site_name','VisaHub Bangladesh','general','2026-10-08 03:27:09','2026-10-09 05:54:59'),(2,'site_tagline','#1 Indian & Global Visa Processing Center in Bangladesh','general','2026-10-08 03:27:09','2026-10-08 05:02:16'),(3,'email','ivap@devstudioslab.com','general','2026-10-08 03:27:09','2026-10-09 11:40:59'),(4,'phone','+880 1711-223344, +880 1911-556677','general','2026-10-08 03:27:09','2026-10-09 11:40:59'),(5,'address','Level 5, Suite 502, Green Landmark Tower, 68/A Gulshan Avenue, Dhaka-1212, Bangladesh','general','2026-10-08 03:27:10','2026-10-09 11:40:59'),(6,'about_us','IVAP (International Visa Application & Processing) is the premier visa facilitation, passport processing, and dollar exchange support consultancy in Bangladesh. Specializing in Indian Visa Application Center (IVAC) appointments, documentation vetting, double entry, medical, tourist, business, student, and work visas, we also cater to Thailand, China, United Kingdom, Pakistan, and Indonesia. Our dedicated immigration lawyers and processing experts ensure error-free submissions, rapid embassy appointments, and complete peace of mind.','general','2026-10-08 03:27:10','2026-10-09 05:54:59'),(7,'how_it_works','1. Select your destination country and visa category.\\n2. Fill out personal details and upload required documents (Passport, NID, Utility Bill, Photo) or proceed with your saved profile vault.\\n3. Pay the fixed Government/Application fee via bKash, Nagad, Rocket, or Bank Transfer to confirm the booking.\\n4. Our expert team verifies your documents, fills government embassy forms, books appointment slots, and submits to the respective high commission.\\n5. Once processed and approved, pay the remaining service charge, download your official invoice, and get your embassy approved visa document instantly.','general','2026-10-08 03:27:10','2026-10-08 03:27:10'),(8,'maintenance_mode','0','general','2026-10-08 03:27:10','2026-10-08 03:27:10'),(9,'maintenance_message','IVAP portal is currently undergoing scheduled maintenance for system upgrades. We will be back shortly. For urgent inquiries, email ivap@devstudioslab.com','general','2026-10-08 03:27:10','2026-10-08 03:27:10'),(10,'facebook_url','https://facebook.com/ivap.visa','general','2026-10-08 03:27:10','2026-10-09 05:54:59'),(11,'whatsapp_number','8801711223344','general','2026-10-08 03:27:10','2026-10-09 11:41:01'),(12,'youtube_url','https://youtube.com/@ivapservices','general','2026-10-08 03:27:10','2026-10-09 05:54:59'),(13,'linkedin_url','https://linkedin.com/company/ivap-global','general','2026-10-08 03:27:10','2026-10-09 05:54:59'),(14,'bkash_number','01711-223344 (Personal)','general','2026-10-08 03:27:10','2026-10-09 05:54:59'),(15,'nagad_number','01911-556677 (Personal)','general','2026-10-08 03:27:10','2026-10-09 05:54:59'),(16,'rocket_number','01711-223344-9','general','2026-10-08 03:27:10','2026-10-09 11:41:00'),(17,'bank_account_info','Bank: Brac Bank PLC\r\nAccount Name: IVAP GLOBAL VISA SERVICES\r\nAccount No: 1502938471001\r\nBranch: Gulshan 2 Avenue Branch\r\nRouting Number: 225272635','general','2026-10-08 03:27:10','2026-10-09 05:54:59'),(18,'contact_email','support@visahub-bd.com','general','2026-10-08 05:02:16','2026-10-08 05:02:16'),(19,'company_name','VisaHub Bangladesh Ltd.','general','2026-10-08 05:02:17','2026-10-08 05:02:17'),(20,'dollar_buy_rate','122.50','general','2026-10-08 05:28:39','2026-10-09 11:41:00'),(21,'dollar_sell_rate','119.50','general','2026-10-08 05:28:39','2026-10-09 11:41:00'),(22,'dollar_exchange_notice','Official dollar exchange rates updated daily. Complies with Bangladesh Bank travel quota endorsement regulations.','general','2026-10-08 05:28:39','2026-10-09 11:41:00'),(29,'bkash_note','Merchant 0% Fee','general','2026-10-09 11:41:00','2026-10-09 11:41:00'),(31,'nagad_note','Merchant A/C','general','2026-10-09 11:41:00','2026-10-09 11:41:00'),(33,'rocket_note','DBBL Rocket','general','2026-10-09 11:41:00','2026-10-09 11:41:00'),(34,'bank_name','Bank Payment','general','2026-10-09 11:41:00','2026-10-09 11:41:00'),(35,'bank_note','Direct Transfer','general','2026-10-09 11:41:00','2026-10-09 11:41:00'),(37,'payment_instructions','Please make payment to any of our official channels above. Keep your Transaction ID (TrxID) handy to submit in the form.','general','2026-10-09 11:41:00','2026-10-09 11:41:00'); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subcategories` -- DROP TABLE IF EXISTS `subcategories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `subcategories` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `category_id` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL, `code` varchar(255) DEFAULT NULL, `slug` varchar(255) NOT NULL, `flag_icon` varchar(255) DEFAULT NULL, `banner_image` varchar(255) DEFAULT NULL, `description` text DEFAULT NULL, `sort_order` int(11) NOT NULL DEFAULT 0, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `subcategories_slug_unique` (`slug`), KEY `subcategories_category_id_foreign` (`category_id`), CONSTRAINT `subcategories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `subcategories` -- LOCK TABLES `subcategories` WRITE; /*!40000 ALTER TABLE `subcategories` DISABLE KEYS */; INSERT INTO `subcategories` VALUES (1,1,'India','in','india','fi fi-in',NULL,'Indian Visa Application Center (IVAC) Tourist, Medical, Business, Double Entry & Student Visas with express appointment slots.',1,1,'2026-10-08 03:27:10','2026-10-08 04:29:27'),(2,1,'Thailand','th','thailand','fi fi-th',NULL,'Royal Thai Embassy Single & Multiple entry tourist, medical, non-immigrant & business visas with full ticket & hotel documentation.',2,1,'2026-10-08 03:27:11','2026-10-08 04:29:28'),(3,1,'China','cn','china','fi fi-cn',NULL,'China Embassy Dhaka Tourist (L), Business (M), Student (X), and Work (Z) visa invitation letter support and processing.',3,1,'2026-10-08 03:27:11','2026-10-08 04:29:28'),(4,1,'Pakistan','pk','pakistan','fi fi-pk',NULL,'Pakistan High Commission Online e-Visa, Family Visit, Business, and Conference entry processing.',4,1,'2026-10-08 03:27:11','2026-10-08 04:29:28'),(5,1,'UK (London)','gb','united-kingdom-london','fi fi-gb',NULL,'UK Visas & Immigration (UKVI) Standard Visitor, Tier 4 Student, Skilled Worker, and Business Conference visas.',5,1,'2026-10-08 03:27:11','2026-10-08 05:10:36'),(6,1,'Indonesia','id','indonesia','fi fi-id',NULL,'Indonesia Electronic Visa (e-VOA / B211A) for tourism, Bali holidays, business meetings and social events.',6,1,'2026-10-08 03:27:11','2026-10-08 04:29:28'),(7,2,'Bangladesh','bd','bangladesh-e-passport','fi fi-bd',NULL,'New 5/10 year E-Passport, Urgent Renewal, and Name/Date of Birth/Address corrections.',1,1,'2026-10-08 03:27:11','2026-10-08 05:10:35'),(8,3,'USD / Forex','us','forex-dollar-endorsement','fi fi-us',NULL,'Authorized Bangladesh Bank compliant passport dollar endorsement and dual currency prepaid card enrollment.',1,1,'2026-10-08 03:27:11','2026-10-08 05:10:36'); /*!40000 ALTER TABLE `subcategories` 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 = utf8 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `role` enum('admin','customer') NOT NULL DEFAULT 'customer', `address` text DEFAULT NULL, `passport_number` varchar(255) DEFAULT NULL, `passport_file` varchar(255) DEFAULT NULL, `nid_number` varchar(255) DEFAULT NULL, `nid_file` varchar(255) DEFAULT NULL, `utility_bill_file` varchar(255) DEFAULT NULL, `photo_file` varchar(255) DEFAULT NULL, `profile_photo_path` varchar(255) DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `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=5 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,'IVAP Super Admin','admin@ivap.com','+8801711223344',NULL,'$2y$12$sR6CZCXJfdqbiSFSaJl2HOAO8cggo2vLR/QHTHhEgrUpuvmNffkjy','admin','Gulshan 2, Dhaka, Bangladesh',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,'2026-10-08 03:27:09','2026-10-08 03:27:09'),(2,'Tanvir Hossain','user@ivap.com','+8801819876543',NULL,'$2y$12$QGEcNYoV7FnpLWlmyj/XhuHlHn6lingCe7e0wFMdxQFE3RVIRV0L.','customer','House 42, Road 11, Banani, Dhaka-1213','A08927461','demo/passport_sample.pdf','19922692019485721','demo/nid_sample.pdf','demo/utility_bill_sample.pdf','demo/photo_sample.jpg',NULL,1,NULL,'2026-10-08 03:27:09','2026-10-08 03:27:09'),(3,'IVAP Super Admin','admin@devstudioslab.com','01700-000001',NULL,'$2y$12$CxzZuxbqn3bnIHRn/n0gce5MkGSI9v2UbAvLvPuCRa8nMd6yrRoPy','admin','IVAP Corporate Office, Gulshan-2, Dhaka',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'0JnfbCBWEaH3nBDTG4CY4nT2z3WnfgCWDlZQKVB72HWYzCQ5sN4waqvAOe1J','2026-10-08 04:45:07','2026-10-08 04:45:07'),(4,'Verified Customer','user@gmail.com','01711-223344',NULL,'$2y$12$aqFtFH9yNlHCMy/cGPQca.B4E/VBf/x8zposm412tCiK885YZ7K2G','customer','Banani, Dhaka-1213','A08927461',NULL,'19922692019485721',NULL,NULL,NULL,NULL,1,NULL,'2026-10-08 04:45:08','2026-10-08 04:45:08'); /*!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-10-09 21:17:05