--
-- Host: 127.0.0.1    Database: e-zone
-- ------------------------------------------------------


--
-- Table structure for table `districts`
--

CREATE TABLE `districts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `division_id` int NOT NULL,
  `name` varchar(25) NOT NULL,
  `bn_name` varchar(25) NOT NULL,
  `lat` varchar(15) DEFAULT NULL,
  `lon` varchar(15) DEFAULT NULL,
  `url` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=65;

--
-- Dumping data for table `districts`
--

INSERT INTO `districts` VALUES (1,1,'Comilla','কুমিল্লা','23.4682747','91.1788135','www.comilla.gov.bd'),(2,1,'Feni','ফেনী','23.023231','91.3840844','www.feni.gov.bd'),(3,1,'Brahmanbaria','ব্রাহ্মণবাড়িয়া','23.9570904','91.1119286','www.brahmanbaria.gov.bd'),(4,1,'Rangamati','রাঙ্গামাটি','22.65561018','92.17541121','www.rangamati.gov.bd'),(5,1,'Noakhali','নোয়াখালী','22.869563','91.099398','www.noakhali.gov.bd'),(6,1,'Chandpur','চাঁদপুর','23.2332585','90.6712912','www.chandpur.gov.bd'),(7,1,'Lakshmipur','লক্ষ্মীপুর','22.942477','90.841184','www.lakshmipur.gov.bd'),(8,1,'Chattogram','চট্টগ্রাম','22.335109','91.834073','www.chittagong.gov.bd'),(9,1,'Coxsbazar','কক্সবাজার','21.44315751','91.97381741','www.coxsbazar.gov.bd'),(10,1,'Khagrachhari','খাগড়াছড়ি','23.119285','91.984663','www.khagrachhari.gov.bd'),(11,1,'Bandarban','বান্দরবান','22.1953275','92.2183773','www.bandarban.gov.bd'),(12,2,'Sirajganj','সিরাজগঞ্জ','24.4533978','89.7006815','www.sirajganj.gov.bd'),(13,2,'Pabna','পাবনা','23.998524','89.233645','www.pabna.gov.bd'),(14,2,'Bogura','বগুড়া','24.8465228','89.377755','www.bogra.gov.bd'),(15,2,'Rajshahi','রাজশাহী','24.37230298','88.56307623','www.rajshahi.gov.bd'),(16,2,'Natore','নাটোর','24.420556','89.000282','www.natore.gov.bd'),(17,2,'Joypurhat','জয়পুরহাট','25.09636876','89.04004280','www.joypurhat.gov.bd'),(18,2,'Chapainawabganj','চাঁপাইনবাবগঞ্জ','24.5965034','88.2775122','www.chapainawabganj.gov.bd'),(19,2,'Naogaon','নওগাঁ','24.83256191','88.92485205','www.naogaon.gov.bd'),(20,3,'Jashore','যশোর','23.16643','89.2081126','www.jessore.gov.bd'),(21,3,'Satkhira','সাতক্ষীরা','22.7180905','89.0687033','www.satkhira.gov.bd'),(22,3,'Meherpur','মেহেরপুর','23.762213','88.631821','www.meherpur.gov.bd'),(23,3,'Narail','নড়াইল','23.172534','89.512672','www.narail.gov.bd'),(24,3,'Chuadanga','চুয়াডাঙ্গা','23.6401961','88.841841','www.chuadanga.gov.bd'),(25,3,'Kushtia','কুষ্টিয়া','23.901258','89.120482','www.kushtia.gov.bd'),(26,3,'Magura','মাগুরা','23.487337','89.419956','www.magura.gov.bd'),(27,3,'Khulna','খুলনা','22.815774','89.568679','www.khulna.gov.bd'),(28,3,'Bagerhat','বাগেরহাট','22.651568','89.785938','www.bagerhat.gov.bd'),(29,3,'Jhenaidah','ঝিনাইদহ','23.5448176','89.1539213','www.jhenaidah.gov.bd'),(30,4,'Jhalakathi','ঝালকাঠি','22.6422689','90.2003932','www.jhalakathi.gov.bd'),(31,4,'Patuakhali','পটুয়াখালী','22.3596316','90.3298712','www.patuakhali.gov.bd'),(32,4,'Pirojpur','পিরোজপুর','22.5781398','89.9983909','www.pirojpur.gov.bd'),(33,4,'Barisal','বরিশাল','22.7004179','90.3731568','www.barisal.gov.bd'),(34,4,'Bhola','ভোলা','22.685923','90.648179','www.bhola.gov.bd'),(35,4,'Barguna','বরগুনা','22.159182','90.125581','www.barguna.gov.bd'),(36,5,'Sylhet','সিলেট','24.8897956','91.8697894','www.sylhet.gov.bd'),(37,5,'Moulvibazar','মৌলভীবাজার','24.482934','91.777417','www.moulvibazar.gov.bd'),(38,5,'Habiganj','হবিগঞ্জ','24.374945','91.41553','www.habiganj.gov.bd'),(39,5,'Sunamganj','সুনামগঞ্জ','25.0658042','91.3950115','www.sunamganj.gov.bd'),(40,6,'Narsingdi','নরসিংদী','23.932233','90.71541','www.narsingdi.gov.bd'),(41,6,'Gazipur','গাজীপুর','24.0022858','90.4264283','www.gazipur.gov.bd'),(42,6,'Shariatpur','শরীয়তপুর','23.2060195','90.3477725','www.shariatpur.gov.bd'),(43,6,'Narayanganj','নারায়ণগঞ্জ','23.63366','90.496482','www.narayanganj.gov.bd'),(44,6,'Tangail','টাঙ্গাইল','24.264145','89.918029','www.tangail.gov.bd'),(45,6,'Kishoreganj','কিশোরগঞ্জ','24.444937','90.776575','www.kishoreganj.gov.bd'),(46,6,'Manikganj','মানিকগঞ্জ','23.8602262','90.0018293','www.manikganj.gov.bd'),(47,6,'Dhaka','ঢাকা','23.7115253','90.4111451','www.dhaka.gov.bd'),(48,6,'Munshiganj','মুন্সিগঞ্জ','23.5435742','90.5354327','www.munshiganj.gov.bd'),(49,6,'Rajbari','রাজবাড়ী','23.7574305','89.6444665','www.rajbari.gov.bd'),(50,6,'Madaripur','মাদারীপুর','23.164102','90.1896805','www.madaripur.gov.bd'),(51,6,'Gopalganj','গোপালগঞ্জ','23.0050857','89.8266059','www.gopalganj.gov.bd'),(52,6,'Faridpur','ফরিদপুর','23.6070822','89.8429406','www.faridpur.gov.bd'),(53,7,'Panchagarh','পঞ্চগড়','26.3411','88.5541606','www.panchagarh.gov.bd'),(54,7,'Dinajpur','দিনাজপুর','25.6217061','88.6354504','www.dinajpur.gov.bd'),(55,7,'Lalmonirhat','লালমনিরহাট','25.9165451','89.4532409','www.lalmonirhat.gov.bd'),(56,7,'Nilphamari','নীলফামারী','25.931794','88.856006','www.nilphamari.gov.bd'),(57,7,'Gaibandha','গাইবান্ধা','25.328751','89.528088','www.gaibandha.gov.bd'),(58,7,'Thakurgaon','ঠাকুরগাঁও','26.0336945','88.4616834','www.thakurgaon.gov.bd'),(59,7,'Rangpur','রংপুর','25.7558096','89.244462','www.rangpur.gov.bd'),(60,7,'Kurigram','কুড়িগ্রাম','25.805445','89.636174','www.kurigram.gov.bd'),(61,8,'Sherpur','শেরপুর','25.0204933','90.0152966','www.sherpur.gov.bd'),(62,8,'Mymensingh','ময়মনসিংহ','24.7465670','90.4072093','www.mymensingh.gov.bd'),(63,8,'Jamalpur','জামালপুর','24.937533','89.937775','www.jamalpur.gov.bd'),(64,8,'Netrokona','নেত্রকোণা','24.870955','90.727887','www.netrokona.gov.bd');

--
-- Table structure for table `divisions`
--

CREATE TABLE `divisions` (
  `id` int NOT NULL,
  `name` varchar(25) NOT NULL,
  `bn_name` varchar(25) NOT NULL,
  `url` varchar(50) NOT NULL
);

--
-- Dumping data for table `divisions`
--

INSERT INTO `divisions` VALUES (1,'Chattagram','চট্টগ্রাম','www.chittagongdiv.gov.bd'),(2,'Rajshahi','রাজশাহী','www.rajshahidiv.gov.bd'),(3,'Khulna','খুলনা','www.khulnadiv.gov.bd'),(4,'Barisal','বরিশাল','www.barisaldiv.gov.bd'),(5,'Sylhet','সিলেট','www.sylhetdiv.gov.bd'),(6,'Dhaka','ঢাকা','www.dhakadiv.gov.bd'),(7,'Rangpur','রংপুর','www.rangpurdiv.gov.bd'),(8,'Mymensingh','ময়মনসিংহ','www.mymensinghdiv.gov.bd');

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

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
);

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


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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (21,'2014_10_12_100000_create_password_resets_table',1),(22,'2019_08_19_000000_create_failed_jobs_table',1),(23,'2019_12_14_000001_create_personal_access_tokens_table',1),(24,'2023_12_07_032723_create_tbl_users_table',1),(25,'2023_12_07_032907_create_tbl_seller_shops',1),(26,'2023_12_07_032941_create_tbl_deller_shops',1),(27,'2023_12_07_033239_create_tbl_delivery_hub',1),(28,'2023_12_07_033248_create_tbl_banner',1),(29,'2023_12_07_033319_create_tbl_offers',1),(30,'2023_12_07_033336_create_tbl_offer_to_products',1),(31,'2023_12_07_033346_create_tbl_coupon',1),(32,'2023_12_07_033357_create_tbl_product_category',1),(33,'2023_12_07_033407_create_tbl_product_subcategory',1),(34,'2023_12_07_033414_create_tbl_product',1),(35,'2023_12_07_033426_create_tbl_product_to_image',1),(36,'2023_12_07_033434_create_tbl_product_details',1),(37,'2023_12_07_033444_create_tbl_sizes',1),(38,'2023_12_07_033453_create_tbl_colors',1),(39,'2023_12_07_033505_create_tbl_wishlist',1),(40,'2023_12_07_033514_create_tbl_orders',1),(41,'2023_12_07_033534_create_tbl_order_items',1),(42,'2023_12_07_033545_create_tbl_order_transaction',1),(43,'2023_12_07_033556_create_tbl_order_status_history',1),(44,'2023_12_07_033608_create_tbl_order_item_history',1),(45,'2023_12_07_033635_create_tbl_return_items',1),(46,'2023_12_07_033649_create_tbl_cash_wallet_history',1),(47,'2023_12_07_033705_create_tbl_withdrawal',1);

--
-- Table structure for table `tbl_app_settings`
--

CREATE TABLE `tbl_app_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tag` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6;

--
-- Dumping data for table `tbl_app_settings`
--

INSERT INTO `tbl_app_settings` VALUES (1,'order_tax','Order Tax','12'),(2,'withdrwal_charge','Withdrawal Charge','10'),(3,'comission_level','Comission Level','12'),(4,'comission_limit','Comission Limit','12'),(5,'comission_status','Comission Status','1');

--
-- Table structure for table `tbl_banner`
--

CREATE TABLE `tbl_banner` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `banner_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_banner`
--

INSERT INTO `tbl_banner` VALUES (1,'/banner/2023-12-09-16-19-36-1702138776327.jpeg','3','/12432',1,NULL,'2023-12-09 10:19:36',NULL);

--
-- Table structure for table `tbl_brand`
--

CREATE TABLE `tbl_brand` (
  `id` int NOT NULL AUTO_INCREMENT,
  `brand_name_en` varchar(255) DEFAULT NULL,
  `brand_name_bn` varchar(255) DEFAULT NULL,
  `status` int DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2;

--
-- Dumping data for table `tbl_brand`
--

INSERT INTO `tbl_brand` VALUES (1,'Apple','Apple updated',0,'2023-12-28 03:59:08','2023-12-28 10:55:50',NULL);

--
-- Table structure for table `tbl_cash_wallet_history`
--

CREATE TABLE `tbl_cash_wallet_history` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `order_id` bigint unsigned DEFAULT NULL,
  `amount` double(8,2) NOT NULL,
  `transaction_type` int DEFAULT NULL,
  `message` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_method` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_id` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_cash_wallet_history`
--

INSERT INTO `tbl_cash_wallet_history` VALUES (3,2,NULL,-100.00,2,'Your withdrawal reqest has been cancelled by admin ( rejecting )','bkash','0','2024-01-01 11:08:11','2024-01-01 11:08:11'),(4,2,NULL,-90.00,2,'Your withdrawal reqest has been cancelled by admin ( qwert )','bkash',NULL,'2024-01-01 11:08:50','2024-01-01 11:08:50'),(5,2,NULL,-110.00,2,'Your withdrawal reqest has been cancelled by admin (  )','bkash',NULL,'2024-01-01 11:09:24','2024-01-01 11:09:24'),(6,2,NULL,-110.00,2,'Your withdrawal reqest has been cancelled by admin ( done )','bkash',NULL,'2024-01-01 11:23:02','2024-01-01 11:23:02'),(7,2,NULL,-110.00,2,'Your withdrawal reqest has been cancelled by admin ( ewe )','bkash',NULL,'2024-01-01 11:23:32','2024-01-01 11:23:32'),(8,2,NULL,-110.00,2,'Your withdrawal reqest has been cancelled by admin ( Rejected )','bkash',NULL,'2024-01-01 11:28:15','2024-01-01 11:28:15');

--
-- Table structure for table `tbl_category_images`
--

CREATE TABLE `tbl_category_images` (
  `id` int NOT NULL AUTO_INCREMENT,
  `image` varchar(150) DEFAULT NULL,
  `category_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6;

--
-- Dumping data for table `tbl_category_images`
--

INSERT INTO `tbl_category_images` VALUES (3,'/category/2024-01-16-18-12-36-1705428756180.png',1),(5,'/category/2024-01-16-18-19-33-1705429173245.png',1);

--
-- Table structure for table `tbl_colors`
--

CREATE TABLE `tbl_colors` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `color_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_colors`
--

INSERT INTO `tbl_colors` VALUES (1,'#000','Red',NULL,'2023-12-09 10:52:57');

--
-- Table structure for table `tbl_comission_wallet_history`
--

CREATE TABLE `tbl_comission_wallet_history` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `order_id` bigint unsigned NOT NULL,
  `amount` double(8,2) NOT NULL,
  `transaction_type` int DEFAULT NULL,
  `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

--
-- Dumping data for table `tbl_comission_wallet_history`
--


--
-- Table structure for table `tbl_comissions`
--

CREATE TABLE `tbl_comissions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `level` varchar(45) DEFAULT NULL,
  `comission` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14;

--
-- Dumping data for table `tbl_comissions`
--

INSERT INTO `tbl_comissions` VALUES (1,'1',12),(2,'2',10),(3,'3',5),(4,'4',10),(5,'5',10),(6,'6',10),(7,'7',10),(8,'8',10),(9,'9',10),(10,'10',10),(12,'11',5),(13,'12',7);

--
-- Table structure for table `tbl_coupon`
--

CREATE TABLE `tbl_coupon` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `coupon_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `coupon_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `amount_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double(8,2) NOT NULL,
  `minimum_order_amount` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_coupon`
--

INSERT INTO `tbl_coupon` VALUES (1,'Coupon name','231121','2023-12-10','2024-12-24','F',15.00,1234.00,NULL,'2023-12-09 22:33:28',NULL);

--
-- Table structure for table `tbl_deller_shop`
--

CREATE TABLE `tbl_deller_shop` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `dealer_id` bigint unsigned NOT NULL,
  `shop_name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shop_name_bn` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shop_logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shop_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lat` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lon` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_deller_shop`
--

INSERT INTO `tbl_deller_shop` VALUES (1,9,'Hamish','Adrian','/deller/2023-12-17-17-46-44-1702835204314.png','Serina','12.12112','12.12112',0,'2023-12-12 19:21:56','2023-12-17 11:46:44',NULL),(2,10,'GCB','GCB',NULL,'Facere minus laudant','12.3445632','12.0000',1,'2023-12-17 10:41:51','2023-12-17 10:41:51',NULL),(3,11,'Hamish','Adrian',NULL,'Serina','12.12112','12.12112',0,'2023-12-17 10:59:20','2023-12-17 10:59:20',NULL),(4,12,'Hamish','Adrian',NULL,'Serina','12.12112','12.12112',0,'2023-12-17 10:59:37','2023-12-17 10:59:37',NULL);

--
-- Table structure for table `tbl_offer_products`
--

CREATE TABLE `tbl_offer_products` (
  `id` int NOT NULL AUTO_INCREMENT,
  `product_id` int NOT NULL,
  `offer_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4;

--
-- Dumping data for table `tbl_offer_products`
--

INSERT INTO `tbl_offer_products` VALUES (2,1,1),(3,3,3);

--
-- Table structure for table `tbl_offers`
--

CREATE TABLE `tbl_offers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `offer_name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `offer_name_bn` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `amount_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double(8,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_offers`
--

INSERT INTO `tbl_offers` VALUES (1,'','Name en','Name ar',NULL,'2023-12-17 14:13:25','2023-12-11','2023-12-15','F',150.00),(3,'/offer/2023-12-29-17-44-36-1703871876197.jpg','Jaquelyn Vaughn','Kerry Mack','2023-12-29 11:44:36','2023-12-29 11:44:36','1995-05-04','1974-11-15','F',100.00);

--
-- Table structure for table `tbl_order_items`
--

CREATE TABLE `tbl_order_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint unsigned NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  `shop_id` bigint unsigned NOT NULL,
  `qty` int NOT NULL,
  `price` double(8,2) NOT NULL,
  `discount` float DEFAULT '0',
  `status` int NOT NULL,
  `hub_id` bigint unsigned DEFAULT NULL,
  `size` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_order_items`
--

INSERT INTO `tbl_order_items` VALUES (1,1,2,1,1,100.00,20,2,1,NULL,NULL,NULL,NULL),(2,1,2,1,1,100.00,20,2,1,NULL,NULL,NULL,NULL),(11,10,2,1,1,19.80,52,2,1,'S','#000',NULL,NULL),(12,10,3,1,1,354.60,10,2,1,'S','#000',NULL,NULL),(13,11,2,1,1,19.80,52,1,1,'S','#000',NULL,NULL),(14,11,3,1,1,354.60,10,1,1,'S','#000',NULL,NULL),(17,13,2,1,1,19.80,52,1,1,'S','#000',NULL,NULL),(18,13,3,1,1,354.60,10,1,1,'S','#000',NULL,NULL),(19,14,2,1,1,19.80,52,1,1,'S','#000',NULL,NULL),(20,14,3,1,1,354.60,10,1,1,'S','#000',NULL,NULL);

--
-- Table structure for table `tbl_order_items_history`
--

CREATE TABLE `tbl_order_items_history` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int NOT NULL,
  `order_item_id` bigint unsigned NOT NULL,
  `product_id` int DEFAULT NULL,
  `hub_id` bigint unsigned DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_order_items_history`
--

INSERT INTO `tbl_order_items_history` VALUES (1,1,1,2,1,'ready  for delivery',2,'2023-12-29 16:04:18','2023-12-30 14:41:24'),(2,1,2,2,1,'qwet',2,'2023-12-29 23:46:33','2023-12-30 14:41:24'),(3,10,12,3,1,'accepted',2,'2024-01-13 09:48:54','2024-01-13 09:48:54'),(4,10,11,2,1,'Accepted',2,'2024-01-13 09:49:05','2024-01-13 09:49:05');

--
-- Table structure for table `tbl_order_status_history`
--

CREATE TABLE `tbl_order_status_history` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint unsigned NOT NULL,
  `status_id` bigint unsigned NOT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_order_status_history`
--

INSERT INTO `tbl_order_status_history` VALUES (1,1,1,'Order place by user','2023-12-12 19:21:56','2023-12-12 19:21:56'),(2,1,2,'admin','2023-12-30 13:56:07','2023-12-30 13:56:07'),(3,1,3,'Order status has been changed by admin','2023-12-30 13:59:23','2023-12-30 13:59:23'),(4,1,4,'Order status has been changed by admin','2023-12-30 13:59:27','2023-12-30 13:59:27'),(5,1,5,'Order status has been changed by admin','2023-12-30 14:05:20','2023-12-30 14:05:20'),(6,1,6,'Order status has been changed by admin','2023-12-30 14:05:24','2023-12-30 14:05:24'),(7,9,1,'Order place by user','2024-01-13 09:36:18','2024-01-13 15:47:21'),(8,10,1,'Order place by user','2024-01-13 09:40:43','2024-01-13 15:46:18'),(9,13,1,'Order place by user','2024-01-13 09:46:57','2024-01-13 09:46:57'),(10,10,2,'Order status has been changed by admin','2024-01-13 09:47:30','2024-01-13 09:47:30'),(11,10,3,'Order status has been changed by admin','2024-01-13 09:47:35','2024-01-13 09:47:35'),(12,10,4,'Order status has been changed by admin','2024-01-13 09:47:40','2024-01-13 09:47:40'),(13,14,1,'Order place by user','2024-01-13 10:01:14','2024-01-13 10:01:14');

--
-- Table structure for table `tbl_order_transaction`
--

CREATE TABLE `tbl_order_transaction` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_order_transaction`
--

INSERT INTO `tbl_order_transaction` VALUES (1,10,19,'COD','843819262',NULL,NULL),(2,11,19,'COD','966453356',NULL,NULL),(4,13,19,'COD','793183055',NULL,NULL),(5,14,19,'COD','966093744',NULL,NULL);

--
-- Table structure for table `tbl_orders`
--

CREATE TABLE `tbl_orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_number` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `dropshipper_id` bigint unsigned DEFAULT NULL,
  `qty` int NOT NULL,
  `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_total` double(8,2) NOT NULL,
  `tax` double(8,2) NOT NULL DEFAULT '0.00',
  `delivery_charge` double(8,2) NOT NULL DEFAULT '0.00',
  `status` int NOT NULL DEFAULT '1',
  `payment_status` int NOT NULL DEFAULT '0',
  `hub_id` bigint unsigned DEFAULT NULL,
  `coupon_id` bigint unsigned DEFAULT NULL,
  `discount_amount` double(8,2) NOT NULL DEFAULT '0.00',
  `order_from` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_orders`
--

INSERT INTO `tbl_orders` VALUES (1,100001,1,1,1,'COD',100.20,2.50,2.40,6,1,2,1,20.00,'customer',NULL,'2023-12-31 23:38:23'),(10,100002,19,NULL,2,'COD',374.40,12.00,100.00,4,1,1,1,15.00,'customer','2024-01-13 09:36:18','2024-01-13 09:47:40'),(11,100003,19,NULL,2,'COD',374.40,12.00,100.00,1,1,1,1,15.00,'customer','2024-01-13 09:40:43','2024-01-13 09:40:43'),(13,100004,19,NULL,2,'COD',374.40,12.00,100.00,1,1,1,1,15.00,'agent','2024-01-13 09:46:57','2024-01-16 21:49:19'),(14,100005,19,NULL,2,'COD',374.40,12.00,100.00,1,1,1,1,15.00,'customer','2024-01-13 10:01:14','2024-01-13 10:01:14');

--
-- Table structure for table `tbl_product`
--

CREATE TABLE `tbl_product` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `basic_info_id` bigint unsigned NOT NULL,
  `category_id` int DEFAULT NULL,
  `subcategory_id` int DEFAULT NULL,
  `brand_id` int DEFAULT NULL,
  `product_name_en` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_name_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thumbnail` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shop_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `details` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `warranty_time` int DEFAULT NULL,
  `refund_time` int DEFAULT NULL,
  `original_price` double(8,2) NOT NULL DEFAULT '0.00',
  `sale_price` double(8,2) NOT NULL DEFAULT '0.00',
  `customer_discount` float DEFAULT NULL,
  `agent_discount` double(8,2) DEFAULT '0.00',
  `dropshipper_discount` float DEFAULT NULL,
  `spot_comission` float DEFAULT NULL,
  `team_comission` float DEFAULT NULL,
  `dropshipper_pre_payment` float DEFAULT NULL,
  `dropshipper_min_price` double(8,2) NOT NULL DEFAULT '0.00',
  `dropshipper_max_price` double(8,2) NOT NULL DEFAULT '0.00',
  `sizes` text COLLATE utf8mb4_unicode_ci,
  `colors` text COLLATE utf8mb4_unicode_ci,
  `is_featured` int DEFAULT NULL,
  `show_in_home` int DEFAULT '0',
  `status` int NOT NULL,
  `total_rating` float DEFAULT '0',
  `total_review` float DEFAULT '0',
  `total_sold` int DEFAULT '0',
  `stock` int DEFAULT '0',
  `product_form` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'seller/deller',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_product`
--

INSERT INTO `tbl_product` VALUES (2,2,1,1,1,'Wynne Green En','Wynne Green Bn','/product/2023-12-28-08-59-19-1703753959170.jpg',1,NULL,'Et dolorem voluptate',47,30,784.00,22.00,10,776.00,724,12,12,352,411.00,460.00,'S,M','#000',1,1,1,0,0,0,6,NULL,'2023-12-29 09:29:07','2024-01-13 10:01:14',NULL),(3,1,1,1,1,'Wynne Green','Chadwick Rosario','/product/2023-12-28-04-31-06-1703737866258.jpg',1,17,'Natus non adipisci a',62,32,306.00,394.00,10,512.00,206,775,979,606,671.00,528.00,'S','#000',NULL,NULL,1,0,0,0,6,NULL,'2023-12-29 14:34:01','2024-01-16 15:14:57',NULL),(6,1,1,1,1,'Wynne Green','Chadwick Rosario','/product/2023-12-28-04-31-06-1703737866258.jpg',2,18,'Dolorem quis laborum',61,56,206.00,642.00,434,167.00,751,855,371,365,192.00,923.00,'S,M','#000',1,1,1,0,0,0,0,NULL,'2024-01-16 15:33:49','2024-01-16 15:33:49',NULL);

--
-- Table structure for table `tbl_product_basic_info`
--

CREATE TABLE `tbl_product_basic_info` (
  `id` int NOT NULL AUTO_INCREMENT,
  `product_name_en` varchar(255) NOT NULL,
  `product_name_bn` varchar(255) NOT NULL,
  `category_id` int NOT NULL,
  `subcategory_id` int NOT NULL,
  `brand_id` int NOT NULL,
  `thumbnail` varchar(150) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3;

--
-- Dumping data for table `tbl_product_basic_info`
--

INSERT INTO `tbl_product_basic_info` VALUES (1,'Wynne Green','Chadwick Rosario',1,1,1,'/product/2023-12-28-04-31-06-1703737866258.jpg','2023-12-27 22:31:06','2023-12-27 22:31:06',NULL),(2,'Wynne Green En','Wynne Green Bn',1,1,1,'/product/2023-12-28-08-59-19-1703753959170.jpg','2023-12-28 02:59:19','2023-12-28 02:59:19',NULL);

--
-- Table structure for table `tbl_product_category`
--

CREATE TABLE `tbl_product_category` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_name_bn` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `show_in_home` int DEFAULT '0',
  `status` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_product_category`
--

INSERT INTO `tbl_product_category` VALUES (1,'CAT EN','CAT BN','/category/2024-01-16-18-12-36-1705428756236.jpeg',1,1,NULL,'2024-01-16 12:12:36',NULL),(2,'Colette Lynch','Madonna Randolph','/category/2024-01-16-18-07-36-1705428456141.jpeg',1,1,'2024-01-16 12:07:36','2024-01-16 12:07:36',NULL);

--
-- Table structure for table `tbl_product_image`
--

CREATE TABLE `tbl_product_image` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `basic_info_id` bigint unsigned NOT NULL,
  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT 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;

--
-- Dumping data for table `tbl_product_image`
--

INSERT INTO `tbl_product_image` VALUES (3,2,'/product/2023-12-28-08-59-19-1703753959275.jpg',NULL,NULL),(4,2,'/product/2023-12-28-08-59-45-1703753985267.jpg',NULL,NULL);

--
-- Table structure for table `tbl_product_review`
--

CREATE TABLE `tbl_product_review` (
  `id` int NOT NULL AUTO_INCREMENT,
  `product_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `rating` float DEFAULT NULL,
  `review` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

--
-- Dumping data for table `tbl_product_review`
--


--
-- Table structure for table `tbl_product_subcategory`
--

CREATE TABLE `tbl_product_subcategory` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint unsigned NOT NULL,
  `subcategory_name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subcategory_name_bn` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subcategory_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_product_subcategory`
--

INSERT INTO `tbl_product_subcategory` VALUES (1,1,'Subcat en','Subcat Ar',NULL,0,NULL,'2023-12-09 11:20:15',NULL);

--
-- Table structure for table `tbl_return_items`
--

CREATE TABLE `tbl_return_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `seller_id` bigint unsigned NOT NULL,
  `item_id` bigint unsigned NOT NULL,
  `price` double(8,2) NOT NULL,
  `status` int NOT NULL,
  `return_reason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
);

--
-- Dumping data for table `tbl_return_items`
--


--
-- Table structure for table `tbl_returned_items`
--

CREATE TABLE `tbl_returned_items` (
  `id` int NOT NULL AUTO_INCREMENT,
  `order_id` int DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `order_item_id` int DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `note` text,
  `admin_note` text,
  `status` int DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2;

--
-- Dumping data for table `tbl_returned_items`
--

INSERT INTO `tbl_returned_items` VALUES (1,4,19,1,'[{\"name\":\"lsdkfj\"}, {\"name\":\"lsdkfj\"}]','231121s','sdfsd',NULL,0,'2024-01-13 16:18:39','2024-01-13 16:18:39');

--
-- Table structure for table `tbl_shop`
--

CREATE TABLE `tbl_shop` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `shop_name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shop_name_bn` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shop_logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shop_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` int NOT NULL DEFAULT '1',
  `lat` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lon` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hub_id` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_shop`
--

INSERT INTO `tbl_shop` VALUES (1,17,'Limpark','Limpark','/deller/2024-01-16-20-02-19-1705435339266.jpeg','Liorder',1,'12.3445632','12342',1,'2023-12-17 13:15:51','2024-01-16 14:02:19',NULL),(2,18,'MacKensie','Rhea','/deller/2023-12-31-23-29-27-1704065367250.jpg','Jillian',1,'Karleigh','Baxter',1,'2023-12-31 17:29:27','2023-12-31 17:29:27',NULL);

--
-- Table structure for table `tbl_sizes`
--

CREATE TABLE `tbl_sizes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `size_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_sizes`
--

INSERT INTO `tbl_sizes` VALUES (1,'S',NULL,NULL),(3,'M',NULL,NULL);

--
-- Table structure for table `tbl_wishlist`
--

CREATE TABLE `tbl_wishlist` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
);

--
-- Dumping data for table `tbl_wishlist`
--


--
-- Table structure for table `tbl_withdrawal`
--

CREATE TABLE `tbl_withdrawal` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `bkash_number` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double(8,2) NOT NULL,
  `message` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `charge` float DEFAULT NULL,
  `transaction_id` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `wallet_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbl_withdrawal`
--

INSERT INTO `tbl_withdrawal` VALUES (1,2,'01781985376',100.00,'Hi','agent',10,NULL,'Rejected','cash_wallet',2,'2024-01-01 05:34:12','2024-01-01 05:34:12',NULL),(2,2,'01781985376',150.00,'I want this money within 3 days , please','agent',10,'987434567','Okay you will recive the amount within 3 days','cash_wallet',1,'2024-01-01 05:34:12','2024-01-01 05:34:12',NULL),(3,2,'01781985376',150.00,'I want this money within 3 days , please','agent',10,NULL,'ewe','cash_wallet',0,'2024-01-01 05:34:12','2024-01-01 05:34:12',NULL);

--
-- Table structure for table `upazilas`
--

CREATE TABLE `upazilas` (
  `id` int NOT NULL,
  `district_id` int NOT NULL,
  `name` varchar(25) NOT NULL,
  `bn_name` varchar(25) NOT NULL,
  `url` varchar(50) NOT NULL
) ENGINE=InnoDB;

--
-- Dumping data for table `upazilas`
--



