-- =====================================================================
-- Herbal & Wellness E-commerce  |  MODULE 1 : Core + Product Schema
-- MySQL 8.0 / MariaDB 10.5+  |  PHP 8.2
-- Charset utf8mb4 (Bangla safe)
-- =====================================================================

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

CREATE DATABASE IF NOT EXISTS `herbal_shop`
  DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE `herbal_shop`;

-- ---------------------------------------------------------------------
-- 1. SETTINGS  (everything key/value, nothing hardcoded in code)
-- ---------------------------------------------------------------------
CREATE TABLE `settings` (
  `id`          INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `group_name`  VARCHAR(50)  NOT NULL DEFAULT 'general', -- general|seo|smtp|sms|social
  `key_name`    VARCHAR(100) NOT NULL,
  `value`       LONGTEXT NULL,
  `autoload`    TINYINT(1) NOT NULL DEFAULT 1,
  `updated_at`  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY `uq_key` (`key_name`),
  KEY `idx_group` (`group_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ---------------------------------------------------------------------
-- 2. CATEGORIES (unlimited, self nesting)
-- ---------------------------------------------------------------------
CREATE TABLE `categories` (
  `id`          INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `parent_id`   INT UNSIGNED NULL,
  `name`        VARCHAR(160) NOT NULL,
  `name_bn`     VARCHAR(160) NULL,
  `slug`        VARCHAR(180) NOT NULL,
  `image`       VARCHAR(255) NULL,
  `description` TEXT NULL,
  `meta_title`  VARCHAR(180) NULL,
  `meta_description` VARCHAR(320) NULL,
  `sort_order`  INT NOT NULL DEFAULT 0,
  `status`      TINYINT(1) NOT NULL DEFAULT 1,
  `created_at`  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at`  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY `uq_cat_slug` (`slug`),
  KEY `idx_parent` (`parent_id`),
  CONSTRAINT `fk_cat_parent` FOREIGN KEY (`parent_id`)
    REFERENCES `categories`(`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ---------------------------------------------------------------------
-- 3. BRANDS
-- ---------------------------------------------------------------------
CREATE TABLE `brands` (
  `id`         INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `name`       VARCHAR(160) NOT NULL,
  `slug`       VARCHAR(180) NOT NULL,
  `logo`       VARCHAR(255) NULL,
  `description` TEXT NULL,
  `status`     TINYINT(1) NOT NULL DEFAULT 1,
  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY `uq_brand_slug` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ---------------------------------------------------------------------
-- 4. PRODUCTS
-- ---------------------------------------------------------------------
CREATE TABLE `products` (
  `id`               INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `category_id`      INT UNSIGNED NULL,
  `brand_id`         INT UNSIGNED NULL,
  `name`             VARCHAR(200) NOT NULL,
  `name_bn`          VARCHAR(200) NULL,
  `slug`             VARCHAR(220) NOT NULL,
  `sku`              VARCHAR(80)  NULL,
  `short_description` TEXT NULL,
  `long_description`  LONGTEXT NULL,
  `ingredients`      LONGTEXT NULL,
  `usage_info`       LONGTEXT NULL,   -- "How to use"
  `warnings`         LONGTEXT NULL,
  `benefits`         LONGTEXT NULL,
  `thumbnail`        VARCHAR(255) NULL,
  `video_url`        VARCHAR(255) NULL,
  `regular_price`    DECIMAL(10,2) NOT NULL DEFAULT 0.00,
  `offer_price`      DECIMAL(10,2) NULL,
  `stock`            INT NOT NULL DEFAULT 0,
  `weight`           VARCHAR(50) NULL,
  `tags`             VARCHAR(500) NULL,
  `status`           TINYINT(1) NOT NULL DEFAULT 1,
  `is_featured`      TINYINT(1) NOT NULL DEFAULT 0,
  `is_trending`      TINYINT(1) NOT NULL DEFAULT 0,
  `is_best_seller`   TINYINT(1) NOT NULL DEFAULT 0,
  `meta_title`       VARCHAR(200) NULL,
  `meta_description` VARCHAR(320) NULL,
  `views`            INT UNSIGNED NOT NULL DEFAULT 0,
  `sort_order`       INT NOT NULL DEFAULT 0,
  `created_at`       TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at`       TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY `uq_prod_slug` (`slug`),
  KEY `idx_cat`   (`category_id`),
  KEY `idx_brand` (`brand_id`),
  KEY `idx_flags` (`status`,`is_featured`,`is_best_seller`),
  FULLTEXT KEY `ft_search` (`name`,`short_description`,`tags`),
  CONSTRAINT `fk_prod_cat`   FOREIGN KEY (`category_id`) REFERENCES `categories`(`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_prod_brand` FOREIGN KEY (`brand_id`)    REFERENCES `brands`(`id`)     ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ---------------------------------------------------------------------
-- 5. PRODUCT GALLERY
-- ---------------------------------------------------------------------
CREATE TABLE `product_images` (
  `id`         INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `product_id` INT UNSIGNED NOT NULL,
  `image`      VARCHAR(255) NOT NULL,
  `alt_text`   VARCHAR(200) NULL,
  `sort_order` INT NOT NULL DEFAULT 0,
  KEY `idx_pi_product` (`product_id`),
  CONSTRAINT `fk_pi_product` FOREIGN KEY (`product_id`)
    REFERENCES `products`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ---------------------------------------------------------------------
-- 6. VARIANT TYPES + VARIANTS  (Size / Weight / Quantity ... unlimited)
-- ---------------------------------------------------------------------
CREATE TABLE `variant_types` (
  `id`     INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `name`   VARCHAR(80) NOT NULL,     -- Size, Weight, Quantity
  `name_bn` VARCHAR(80) NULL,
  `status` TINYINT(1) NOT NULL DEFAULT 1,
  UNIQUE KEY `uq_vt_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `product_variants` (
  `id`              INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `product_id`      INT UNSIGNED NOT NULL,
  `variant_type_id` INT UNSIGNED NULL,
  `title`           VARCHAR(120) NOT NULL,   -- 500ml / 100gm / 2 Pieces
  `title_bn`        VARCHAR(120) NULL,
  `sku`             VARCHAR(80) NULL,
  `regular_price`   DECIMAL(10,2) NOT NULL DEFAULT 0.00,
  `offer_price`     DECIMAL(10,2) NULL,
  `stock`           INT NOT NULL DEFAULT 0,
  `image`           VARCHAR(255) NULL,
  `is_default`      TINYINT(1) NOT NULL DEFAULT 0,
  `sort_order`      INT NOT NULL DEFAULT 0,
  `status`          TINYINT(1) NOT NULL DEFAULT 1,
  KEY `idx_pv_product` (`product_id`),
  CONSTRAINT `fk_pv_product` FOREIGN KEY (`product_id`) REFERENCES `products`(`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_pv_type`    FOREIGN KEY (`variant_type_id`) REFERENCES `variant_types`(`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ---------------------------------------------------------------------
-- 7. REVIEWS  (admin approval + verified badge)
-- ---------------------------------------------------------------------
CREATE TABLE `reviews` (
  `id`          INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `product_id`  INT UNSIGNED NOT NULL,
  `customer_name` VARCHAR(120) NOT NULL,
  `customer_email` VARCHAR(160) NULL,
  `rating`      TINYINT UNSIGNED NOT NULL,          -- 1..5
  `title`       VARCHAR(180) NULL,
  `comment`     TEXT NULL,
  `image`       VARCHAR(255) NULL,
  `is_verified` TINYINT(1) NOT NULL DEFAULT 0,
  `is_approved` TINYINT(1) NOT NULL DEFAULT 0,
  `ip_address`  VARCHAR(45) NULL,
  `created_at`  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY `idx_rv_product` (`product_id`,`is_approved`),
  CONSTRAINT `chk_rating` CHECK (`rating` BETWEEN 1 AND 5),
  CONSTRAINT `fk_rv_product` FOREIGN KEY (`product_id`) REFERENCES `products`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ---------------------------------------------------------------------
-- 8. FAQ  (global or per product)
-- ---------------------------------------------------------------------
CREATE TABLE `faqs` (
  `id`         INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `product_id` INT UNSIGNED NULL,
  `question`   VARCHAR(300) NOT NULL,
  `answer`     TEXT NOT NULL,
  `sort_order` INT NOT NULL DEFAULT 0,
  `status`     TINYINT(1) NOT NULL DEFAULT 1,
  KEY `idx_faq_product` (`product_id`),
  CONSTRAINT `fk_faq_product` FOREIGN KEY (`product_id`) REFERENCES `products`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ---------------------------------------------------------------------
-- 9. PRODUCT FEATURES  (icon + text rows on landing page)
-- ---------------------------------------------------------------------
CREATE TABLE `product_features` (
  `id`         INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `product_id` INT UNSIGNED NOT NULL,
  `icon`       VARCHAR(80) NULL,       -- bootstrap icon class
  `title`      VARCHAR(180) NOT NULL,
  `description` VARCHAR(400) NULL,
  `sort_order` INT NOT NULL DEFAULT 0,
  KEY `idx_pf_product` (`product_id`),
  CONSTRAINT `fk_pf_product` FOREIGN KEY (`product_id`) REFERENCES `products`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ---------------------------------------------------------------------
-- 10. TRUST BADGES / SLIDERS (landing page, DB driven)
-- ---------------------------------------------------------------------
CREATE TABLE `trust_badges` (
  `id`         INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `icon`       VARCHAR(80) NOT NULL,
  `title`      VARCHAR(120) NOT NULL,
  `subtitle`   VARCHAR(180) NULL,
  `sort_order` INT NOT NULL DEFAULT 0,
  `status`     TINYINT(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `sliders` (
  `id`         INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `title`      VARCHAR(200) NULL,
  `subtitle`   VARCHAR(300) NULL,
  `image`      VARCHAR(255) NOT NULL,
  `button_text` VARCHAR(80) NULL,
  `button_link` VARCHAR(255) NULL,
  `sort_order` INT NOT NULL DEFAULT 0,
  `status`     TINYINT(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ---------------------------------------------------------------------
-- 11. LOCATIONS (Division / District / Upazila) + delivery charge
-- ---------------------------------------------------------------------
CREATE TABLE `divisions` (
  `id`      INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `name`    VARCHAR(100) NOT NULL,
  `name_bn` VARCHAR(100) NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `districts` (
  `id`          INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `division_id` INT UNSIGNED NOT NULL,
  `name`        VARCHAR(100) NOT NULL,
  `name_bn`     VARCHAR(100) NULL,
  `delivery_charge` DECIMAL(10,2) NOT NULL DEFAULT 0.00,
  KEY `idx_d_div` (`division_id`),
  CONSTRAINT `fk_d_div` FOREIGN KEY (`division_id`) REFERENCES `divisions`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `upazilas` (
  `id`          INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `district_id` INT UNSIGNED NOT NULL,
  `name`        VARCHAR(100) NOT NULL,
  `name_bn`     VARCHAR(100) NULL,
  KEY `idx_u_dist` (`district_id`),
  CONSTRAINT `fk_u_dist` FOREIGN KEY (`district_id`) REFERENCES `districts`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ---------------------------------------------------------------------
-- 12. ORDERS (COD)  - needed by the landing page sticky order form
-- ---------------------------------------------------------------------
CREATE TABLE `orders` (
  `id`            INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `order_no`      VARCHAR(30) NOT NULL,
  `customer_name` VARCHAR(150) NOT NULL,
  `mobile`        VARCHAR(20) NOT NULL,
  `alt_mobile`    VARCHAR(20) NULL,
  `email`         VARCHAR(160) NULL,
  `division_id`   INT UNSIGNED NULL,
  `district_id`   INT UNSIGNED NULL,
  `upazila_id`    INT UNSIGNED NULL,
  `area`          VARCHAR(160) NULL,
  `address`       TEXT NOT NULL,
  `coupon_code`   VARCHAR(60) NULL,
  `discount`      DECIMAL(10,2) NOT NULL DEFAULT 0.00,
  `subtotal`      DECIMAL(10,2) NOT NULL DEFAULT 0.00,
  `delivery_charge` DECIMAL(10,2) NOT NULL DEFAULT 0.00,
  `total`         DECIMAL(10,2) NOT NULL DEFAULT 0.00,
  `note`          TEXT NULL,
  `payment_method` VARCHAR(30) NOT NULL DEFAULT 'COD',
  `status` ENUM('pending','confirmed','processing','shipped','delivered','cancelled','returned')
           NOT NULL DEFAULT 'pending',
  `ip_address`    VARCHAR(45) NULL,
  `created_at`    TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at`    TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY `uq_order_no` (`order_no`),
  KEY `idx_status` (`status`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `order_items` (
  `id`          INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `order_id`    INT UNSIGNED NOT NULL,
  `product_id`  INT UNSIGNED NULL,
  `variant_id`  INT UNSIGNED NULL,
  `product_name` VARCHAR(220) NOT NULL,
  `variant_title` VARCHAR(120) NULL,
  `price`       DECIMAL(10,2) NOT NULL,
  `quantity`    INT NOT NULL DEFAULT 1,
  `subtotal`    DECIMAL(10,2) NOT NULL,
  KEY `idx_oi_order` (`order_id`),
  CONSTRAINT `fk_oi_order` FOREIGN KEY (`order_id`) REFERENCES `orders`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

SET FOREIGN_KEY_CHECKS = 1;

-- =====================================================================
-- SEED DATA (minimum needed so the landing page renders from DB)
-- =====================================================================
INSERT INTO `settings` (`group_name`,`key_name`,`value`) VALUES
('general','site_name','Herbal Care BD'),
('general','site_tagline','প্রাকৃতিক হারবাল ও ওয়েলনেস পণ্য'),
('general','logo','assets/images/logo.png'),
('general','currency','৳'),
('general','phone','+8801700000000'),
('general','whatsapp','8801700000000'),
('general','messenger','https://m.me/herbalcarebd'),
('general','address','Dhaka, Bangladesh'),
('general','default_delivery_charge','60'),
('general','landing_product_slug','organic-neem-hair-oil'),
('seo','meta_title','Herbal Care BD | 100% Natural Herbal & Wellness Products'),
('seo','meta_description','Premium natural herbal & wellness products in Bangladesh. Cash on delivery all over the country.'),
('seo','og_image','assets/images/og.jpg'),
('smtp','mail_host','smtp.gmail.com'),
('smtp','mail_port','587'),
('smtp','mail_username',''),
('smtp','mail_password',''),
('smtp','mail_encryption','tls'),
('smtp','from_email','no-reply@herbalcarebd.com'),
('smtp','from_name','Herbal Care BD'),
('smtp','admin_email','admin@herbalcarebd.com'),
('smtp','reply_email','support@herbalcarebd.com'),
('sms','sms_api_url',''),
('sms','sms_api_key',''),
('sms','sms_sender_id',''),
('sms','sms_enabled','0');

INSERT INTO `brands` (`name`,`slug`) VALUES ('Herbal Care','herbal-care');
INSERT INTO `categories` (`name`,`name_bn`,`slug`) VALUES ('Hair Care','হেয়ার কেয়ার','hair-care');

INSERT INTO `products`
(`category_id`,`brand_id`,`name`,`name_bn`,`slug`,`sku`,`short_description`,`long_description`,
 `ingredients`,`usage_info`,`warnings`,`benefits`,`thumbnail`,`video_url`,
 `regular_price`,`offer_price`,`stock`,`weight`,`tags`,`is_featured`,`is_best_seller`,
 `meta_title`,`meta_description`)
VALUES
(1,1,'Organic Neem Hair Oil','অর্গানিক নিম হেয়ার অয়েল','organic-neem-hair-oil','HC-NHO-001',
 '100% natural neem hair oil for hair fall control and dandruff free scalp.',
 '<p>Organic Neem Hair Oil is cold pressed from pure neem leaves and blended with coconut, amla and bhringraj oil.</p>',
 'Neem Extract, Coconut Oil, Amla, Bhringraj, Vitamin E',
 'Apply 5-10 ml on scalp, massage 5 minutes, keep 2 hours or overnight, then wash.',
 'For external use only. Keep away from children. Do a patch test first.',
 'Reduces hair fall|Removes dandruff|Promotes new hair growth|Cools the scalp',
 'assets/images/products/neem-oil.jpg','https://www.youtube.com/embed/dQw4w9WgXcQ',
 850.00,650.00,120,'200ml','neem,hair oil,herbal',1,1,
 'Organic Neem Hair Oil - 100% Natural | Herbal Care BD',
 'Buy Organic Neem Hair Oil online in Bangladesh. Cash on delivery, 100% natural ingredients.');

INSERT INTO `variant_types` (`name`,`name_bn`) VALUES ('Size','সাইজ'),('Weight','ওজন'),('Quantity','পরিমাণ');

INSERT INTO `product_variants`
(`product_id`,`variant_type_id`,`title`,`title_bn`,`sku`,`regular_price`,`offer_price`,`stock`,`is_default`,`sort_order`)
VALUES
(1,1,'100 ml','১০০ মিলি','HC-NHO-100',500.00,390.00,80,0,1),
(1,1,'200 ml','২০০ মিলি','HC-NHO-200',850.00,650.00,120,1,2),
(1,1,'500 ml','৫০০ মিলি','HC-NHO-500',1800.00,1390.00,40,0,3);

INSERT INTO `product_images` (`product_id`,`image`,`alt_text`,`sort_order`) VALUES
(1,'assets/images/products/neem-oil.jpg','Organic Neem Hair Oil bottle',1),
(1,'assets/images/products/neem-oil-2.jpg','Neem oil ingredients',2),
(1,'assets/images/products/neem-oil-3.jpg','Neem oil usage',3);

INSERT INTO `product_features` (`product_id`,`icon`,`title`,`description`,`sort_order`) VALUES
(1,'bi-leaf','100% Organic','No chemicals, no parabens, no artificial fragrance.',1),
(1,'bi-shield-check','Lab Tested','Every batch is quality tested before packaging.',2),
(1,'bi-truck','Fast Delivery','Delivery within 24-72 hours all over Bangladesh.',3),
(1,'bi-cash-coin','Cash on Delivery','Pay after you receive the product.',4);

INSERT INTO `faqs` (`product_id`,`question`,`answer`,`sort_order`) VALUES
(1,'কতদিন ব্যবহার করলে ফল পাওয়া যাবে?','নিয়মিত ব্যবহারে ৩-৪ সপ্তাহের মধ্যে দৃশ্যমান পরিবর্তন দেখা যায়।',1),
(1,'Is it safe for all hair types?','Yes, it is suitable for all hair types including sensitive scalp.',2),
(1,'ডেলিভারি চার্জ কত?','ঢাকার ভিতরে ৬০ টাকা এবং ঢাকার বাইরে ১২০ টাকা।',3);

INSERT INTO `reviews` (`product_id`,`customer_name`,`rating`,`title`,`comment`,`is_verified`,`is_approved`) VALUES
(1,'Rahim Uddin',5,'দারুণ প্রোডাক্ট','এক মাস ব্যবহার করে চুল পড়া অনেক কমেছে।',1,1),
(1,'Sadia Islam',5,'Really works','Dandruff completely gone within 3 weeks.',1,1),
(1,'Kamal Hossain',4,'Good','Nice smell and good quality oil.',0,1);

INSERT INTO `trust_badges` (`icon`,`title`,`subtitle`,`sort_order`) VALUES
('bi-cash-coin','Cash On Delivery','পণ্য হাতে পেয়ে টাকা দিন',1),
('bi-truck','Fast Delivery','২৪-৭২ ঘন্টায় সারাদেশে',2),
('bi-lock','Secure Order','আপনার তথ্য সম্পূর্ণ নিরাপদ',3),
('bi-patch-check','100% Authentic','অরিজিনাল পণ্যের নিশ্চয়তা',4);

INSERT INTO `divisions` (`name`,`name_bn`) VALUES
('Dhaka','ঢাকা'),('Chattogram','চট্টগ্রাম'),('Khulna','খুলনা'),('Rajshahi','রাজশাহী'),
('Barishal','বরিশাল'),('Sylhet','সিলেট'),('Rangpur','রংপুর'),('Mymensingh','ময়মনসিংহ');

INSERT INTO `districts` (`division_id`,`name`,`name_bn`,`delivery_charge`) VALUES
(1,'Dhaka','ঢাকা',60.00),(1,'Gazipur','গাজীপুর',100.00),(1,'Narayanganj','নারায়ণগঞ্জ',100.00),
(2,'Chattogram','চট্টগ্রাম',120.00),(3,'Khulna','খুলনা',120.00),(4,'Rajshahi','রাজশাহী',120.00),
(5,'Barishal','বরিশাল',120.00),(6,'Sylhet','সিলেট',120.00),(7,'Rangpur','রংপুর',120.00),
(8,'Mymensingh','ময়মনসিংহ',120.00);

INSERT INTO `upazilas` (`district_id`,`name`,`name_bn`) VALUES
(1,'Dhanmondi','ধানমন্ডি'),(1,'Mirpur','মিরপুর'),(1,'Uttara','উত্তরা'),(1,'Gulshan','গুলশান'),
(2,'Tongi','টঙ্গী'),(2,'Sreepur','শ্রীপুর'),(4,'Pahartali','পাহাড়তলী'),(4,'Kotwali','কোতোয়ালী');