-- BuraqBD Laravel module - MySQL 8+
-- Import into the same database configured in Laravel .env.
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS=0;

CREATE TABLE IF NOT EXISTS `buraq_site_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `value` longtext NULL,
  `type` varchar(255) NOT NULL DEFAULT 'text',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`), UNIQUE KEY `buraq_site_settings_key_unique` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `buraq_sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL DEFAULT 'content',
  `title` varchar(255) NULL,
  `content` longtext NULL,
  `image` varchar(255) NULL,
  `data` json NULL,
  `sort_order` int unsigned NOT NULL DEFAULT 0,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`), UNIQUE KEY `buraq_sections_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `buraq_products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `image` varchar(255) NULL,
  `regular_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `offer_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `stock` int unsigned NOT NULL DEFAULT 0,
  `description` text NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`), UNIQUE KEY `buraq_products_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `buraq_reviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(255) NULL,
  `review` text NULL,
  `video_url` varchar(255) NULL,
  `image` varchar(255) NULL,
  `rating` tinyint unsigned NOT NULL DEFAULT 5,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `sort_order` int unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `buraq_shipping_methods` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `cost` decimal(10,2) NOT NULL DEFAULT 0.00,
  `description` text NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `buraq_orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_no` varchar(255) NOT NULL,
  `product_id` bigint unsigned NULL,
  `customer_name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `district` varchar(255) NULL,
  `area` varchar(255) NULL,
  `quantity` int unsigned NOT NULL DEFAULT 1,
  `unit_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `shipping_cost` decimal(10,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `total` decimal(10,2) NOT NULL DEFAULT 0.00,
  `payment_method` varchar(255) NOT NULL DEFAULT 'cod',
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `note` text NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`), UNIQUE KEY `buraq_orders_order_no_unique` (`order_no`), KEY `buraq_orders_product_id_foreign` (`product_id`),
  CONSTRAINT `buraq_orders_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `buraq_products` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `buraq_site_settings` (`key`,`value`,`type`,`created_at`,`updated_at`) VALUES
('site_title','বুরাক অয়েল','text',NOW(),NOW()),
('phone','01309393364','text',NOW(),NOW()),
('primary_color','#2d7b27','text',NOW(),NOW()),
('secondary_color','#123257','text',NOW(),NOW()),
('hero_badge','পরীক্ষিত প্রাকৃতিক সমাধানে','text',NOW(),NOW()),
('hero_title','ব্য*থামুক্ত জীবন!','text',NOW(),NOW()),
('hero_subtitle','৪,০০,০০০+ মানুষের বাত ব্য*থা, কাঁধ ব্য*থা, হাড় ক্ষয়ের ব্য*থা, পুরনো কোমর ব্য*থা ভালো হয়েছে বুরাক নাইজেলা ম্যাসাজ অয়েল এর মাধ্যমে','text',NOW(),NOW()),
('hero_cta','এখনই অর্ডার করুন','text',NOW(),NOW()),
('stats_1','4,00,000+ Happy Customers','text',NOW(),NOW()),
('stats_2','3,00,000+ Repeated Customer','text',NOW(),NOW()),
('stats_3','4.9/5 Rating','text',NOW(),NOW()),
('review_title','আমাদের কাস্টমার রিভিউ','text',NOW(),NOW()),
('certification','বিএসটিআই বি-মার্ক কর্তৃক অনুমোদিত এবং আইএসও সার্টিফাইড। BCSIR এর ল্যাব থেকে পরীক্ষিত','text',NOW(),NOW()),
('offer_title','অফারটি শীঘ্রই শেষ হতে যাচ্ছে!','text',NOW(),NOW()),
('delivery_text','🚚 (এখন অর্ডার করলে ফ্রি হোম ডেলিভারি সারা বাংলাদেশ!! )','text',NOW(),NOW()),
('call_title','যেকোনো প্রয়োজনে কল করুন','text',NOW(),NOW()),
('order_title','অর্ডার করতে নিচের ফর্মটি পূরণ করে অর্ডার কনফার্ম বাটনে ক্লিক করুন!','text',NOW(),NOW()),
('footer_text','প্রাইভেসি পলিসি | যোগাযোগ','text',NOW(),NOW());

INSERT INTO `buraq_sections` (`slug`,`type`,`title`,`sort_order`,`active`,`created_at`,`updated_at`) VALUES
('hero','hero','Hero',10,1,NOW(),NOW()),('stats','stats','Stats',20,1,NOW(),NOW()),('reviews','reviews','Reviews',30,1,NOW(),NOW()),('certification','certification','Certification',40,1,NOW(),NOW()),('offer','offer','Offer',50,1,NOW(),NOW()),('order','order','Order Form',60,1,NOW(),NOW());

INSERT INTO `buraq_products` (`name`,`slug`,`image`,`regular_price`,`offer_price`,`stock`,`description`,`active`,`created_at`,`updated_at`) VALUES
('Buraq Nigella Massage Oil','buraq-nigella-massage-oil','assets/landing-pages/single-image/zA21HplfxvQxw8byBsoheNVBHfRMK4vIoEouhQs4.webp',1280.00,1040.00,1000,'২০০ মি.লি. বুরাক অয়েল',1,NOW(),NOW());

INSERT INTO `buraq_shipping_methods` (`name`,`cost`,`description`,`active`,`created_at`,`updated_at`) VALUES ('Standard Shipping',0.00,'সারা বাংলাদেশ',1,NOW(),NOW());

SET FOREIGN_KEY_CHECKS=1;