-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 15, 2026 at 11:28 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `ourstore`
--

-- --------------------------------------------------------

--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` enum('super_admin','admin','manager') NOT NULL DEFAULT 'admin',
  `permissions` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `last_login` timestamp NULL DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `brands`
--

INSERT INTO `brands` (`id`, `name`, `slug`, `description`, `logo`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'TechPro', 'techpro', 'Leading technology brand', NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(2, 'StyleMax', 'stylemax', 'Premium fashion brand', NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(3, 'ComfortLife', 'comfortlife', 'Home comfort and lifestyle', NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(4, 'ActiveGear', 'activegear', 'Sports and outdoor equipment', NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(5, 'MediaHub', 'mediahub', 'Books and digital media', NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(6, 'GlowBeauty', 'glowbeauty', 'Premium beauty care', NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(7, 'PureFood', 'purefood', 'Organic and quality food products', NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(8, 'FunPlay', 'funplay', 'Toys and games for everyone', NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(9, 'Elite Pro', 'elite-pro', 'Premium professional brand', NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(10, 'ValueFirst', 'valuefirst', 'Budget-friendly quality products', NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31');

-- --------------------------------------------------------

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `discounts`
--

CREATE TABLE `discounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `type` enum('percentage','fixed_amount') NOT NULL DEFAULT 'percentage',
  `value` decimal(10,2) NOT NULL,
  `usage_limit` int(11) DEFAULT NULL,
  `usage_count` int(11) NOT NULL DEFAULT 0,
  `valid_from` date DEFAULT NULL,
  `valid_to` date DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `discounts`
--

INSERT INTO `discounts` (`id`, `code`, `description`, `type`, `value`, `usage_limit`, `usage_count`, `valid_from`, `valid_to`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'WELCOME10', '10% off for new customers', 'percentage', 10.00, 100, 0, '2026-03-13', '2026-06-13', 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(2, 'SAVE20', '20% discount on selected items', 'percentage', 20.00, NULL, 0, '2026-03-13', '2026-04-13', 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(3, 'SUMMER25', 'Flat $25 off on orders', 'fixed_amount', 25.00, 50, 0, '2026-03-13', '2026-05-13', 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(4, 'FREESHIP', 'Free shipping on orders', 'percentage', 0.00, NULL, 0, '2026-03-13', '2026-09-13', 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(5, 'MEMBER15', '15% off for registered members', 'percentage', 15.00, NULL, 0, '2026-03-13', '2027-03-13', 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(6, 'EXPIRED30', 'This discount has expired', 'percentage', 30.00, NULL, 5, '2026-01-13', '2026-03-08', 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31');

-- --------------------------------------------------------

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `inventory`
--

CREATE TABLE `inventory` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 0,
  `reorder_level` int(11) NOT NULL DEFAULT 10,
  `location` varchar(255) DEFAULT NULL,
  `last_updated` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `inventory`
--

INSERT INTO `inventory` (`id`, `product_id`, `quantity`, `reorder_level`, `location`, `last_updated`, `created_at`, `updated_at`) VALUES
(1, 1, 166, 20, 'Warehouse A - Shelf 2', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(2, 2, 21, 20, 'Warehouse A - Shelf 3', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-16 03:23:41'),
(3, 3, 55, 20, 'Warehouse A - Shelf 6', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(4, 4, 103, 20, 'Warehouse A - Shelf 7', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(5, 5, 195, 20, 'Warehouse A - Shelf 9', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(6, 6, 72, 20, 'Warehouse A - Shelf 2', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(7, 7, 167, 20, 'Warehouse A - Shelf 7', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(8, 8, 181, 20, 'Warehouse A - Shelf 3', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(9, 9, 27, 20, 'Warehouse A - Shelf 7', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(10, 10, 35, 20, 'Warehouse A - Shelf 7', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(11, 11, 67, 20, 'Warehouse A - Shelf 2', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(12, 12, 127, 20, 'Warehouse A - Shelf 5', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(13, 13, 78, 20, 'Warehouse A - Shelf 2', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(14, 14, 142, 20, 'Warehouse A - Shelf 4', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(15, 15, 59, 20, 'Warehouse A - Shelf 3', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(16, 16, 45, 20, 'Warehouse A - Shelf 7', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(17, 17, 56, 20, 'Warehouse A - Shelf 7', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(18, 18, 182, 20, 'Warehouse A - Shelf 2', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(19, 19, 48, 20, 'Warehouse A - Shelf 3', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(20, 20, 30, 20, 'Warehouse A - Shelf 1', '2026-03-13 19:43:31', '2026-03-13 19:43:31', '2026-03-13 19:43:31');

-- --------------------------------------------------------

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `job_batches`
--

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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) 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, '2025_01_01_000001_create_admins_table', 1),
(5, '2025_01_01_000002_create_brands_table', 1),
(6, '2025_01_01_000003_create_products_categories_table', 1),
(7, '2025_01_01_000004_create_products_table', 1),
(8, '2025_01_01_000005_create_inventory_table', 1),
(9, '2025_01_01_000006_create_payment_methods_table', 1),
(10, '2025_01_01_000007_create_discounts_table', 1),
(11, '2025_01_01_000008_create_site_settings_table', 1),
(12, '2025_01_01_000009_create_theme_color_managers_table', 1),
(13, '2025_01_01_000010_create_orders_table', 1),
(14, '2025_01_01_000011_create_transactions_table', 1),
(15, '2025_01_01_000012_create_order_tracking_table', 1),
(16, '2025_01_01_000013_add_ecommerce_fields_to_users_table', 1),
(17, '2025_01_01_000014_create_order_items_table', 1),
(18, '2026_03_13_000003_add_fields_to_users_table', 1),
(19, '2026_03_13_000010_create_support_tickets_table', 1),
(20, '2026_03_13_000011_create_support_ticket_replies_table', 1),
(21, '2026_03_13_000012_create_notifications_table', 1),
(22, '2026_03_13_000013_create_reviews_table', 2),
(23, '2026_03_13_000014_create_product_images_table', 3),
(24, '2026_03_14_131551_create_settings_table', 4),
(25, '2026_03_15_080857_add_compare_at_price_to_products_table', 5),
(26, '2026_03_15_082615_create_wishlists_table', 6),
(27, '2026_03_15_120000_expand_payment_method_type_enum', 7),
(28, '2026_03_15_130000_add_currency_to_site_settings_table', 8),
(29, '2026_03_15_141000_add_home_sections_to_site_settings_table', 9),
(30, '2026_03_15_200000_add_branding_and_footer_to_site_settings_table', 10);

-- --------------------------------------------------------

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` longtext NOT NULL,
  `notifiable_type` varchar(255) DEFAULT NULL,
  `notifiable_id` bigint(20) UNSIGNED DEFAULT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_number` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('pending','processing','shipped','delivered','cancelled','refunded') NOT NULL DEFAULT 'pending',
  `subtotal` decimal(10,2) NOT NULL,
  `tax` decimal(10,2) NOT NULL DEFAULT 0.00,
  `shipping` decimal(10,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `total` decimal(10,2) NOT NULL,
  `discount_id` bigint(20) UNSIGNED DEFAULT NULL,
  `shipping_address` varchar(255) DEFAULT NULL,
  `billing_address` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `shipped_date` timestamp NULL DEFAULT NULL,
  `delivered_date` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `order_number`, `user_id`, `status`, `subtotal`, `tax`, `shipping`, `discount`, `total`, `discount_id`, `shipping_address`, `billing_address`, `notes`, `shipped_date`, `delivered_date`, `created_at`, `updated_at`) VALUES
(1, 'ORD-001000', 2, 'cancelled', 179.96, 18.00, 5.99, 0.00, 203.95, NULL, '123 Main Street', '123 Main Street', 'Sample order #1', NULL, NULL, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(2, 'ORD-001001', 2, 'pending', 734.93, 73.49, 5.99, 0.00, 814.41, NULL, '123 Main Street', '123 Main Street', 'Sample order #2', NULL, NULL, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(3, 'ORD-001002', 2, 'shipped', 1299.92, 129.99, 5.99, 0.00, 1435.90, NULL, '123 Main Street', '123 Main Street', 'Sample order #3', NULL, NULL, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(4, 'ORD-001003', 2, 'cancelled', 1474.93, 147.49, 5.99, 0.00, 1628.41, NULL, '123 Main Street', '123 Main Street', 'Sample order #4', NULL, NULL, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(5, 'ORD-001004', 2, 'shipped', 1169.92, 116.99, 5.99, 0.00, 1292.90, NULL, '123 Main Street', '123 Main Street', 'Sample order #5', NULL, NULL, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(6, 'ORD-BDTCXRHH3Z', 2, 'pending', 1199.98, 0.00, 0.00, 0.00, 1199.98, NULL, '123 Main Street', '123 Main Street', NULL, NULL, NULL, '2026-03-15 14:49:12', '2026-03-15 14:49:12'),
(7, 'ORD-URLTOXO56K', 2, 'pending', 599.99, 0.00, 0.00, 0.00, 599.99, NULL, '123 Main Street', '123 Main Street', 'dssdds', NULL, NULL, '2026-03-16 03:23:14', '2026-03-16 03:23:14'),
(8, 'ORD-Y6KIRVXVL0', 2, 'pending', 599.99, 0.00, 0.00, 0.00, 599.99, NULL, '123 Main Street', '123 Main Street', 'dssdds', NULL, NULL, '2026-03-16 03:23:41', '2026-03-16 03:23:41');

-- --------------------------------------------------------

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `product_sku` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` (`id`, `order_id`, `product_id`, `quantity`, `price`, `total`, `product_name`, `product_sku`, `created_at`, `updated_at`) VALUES
(1, 1, 3, 2, 29.99, 59.98, 'Portable Phone Charger 20000mAh', 'SKU-745019', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(2, 1, 9, 2, 59.99, 119.98, 'Garden Tool Set', 'SKU-129521', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(3, 2, 4, 3, 34.99, 104.97, 'Premium Cotton T-Shirt', 'SKU-799371', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(4, 2, 6, 2, 159.99, 319.98, 'Winter Wool Jacket', 'SKU-685782', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(5, 2, 7, 1, 249.99, 249.99, 'Stainless Steel Cookware Set', 'SKU-347712', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(6, 2, 9, 1, 59.99, 59.99, 'Garden Tool Set', 'SKU-129521', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(7, 3, 2, 1, 599.99, 599.99, '4K Smart TV 55\"', 'SKU-623177', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(8, 3, 3, 2, 29.99, 59.98, 'Portable Phone Charger 20000mAh', 'SKU-745019', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(9, 3, 5, 2, 79.99, 159.98, 'Classic Denim Jeans', 'SKU-514256', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(10, 3, 6, 3, 159.99, 479.97, 'Winter Wool Jacket', 'SKU-685782', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(11, 4, 2, 2, 599.99, 1199.98, '4K Smart TV 55\"', 'SKU-623177', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(12, 4, 4, 1, 34.99, 34.99, 'Premium Cotton T-Shirt', 'SKU-799371', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(13, 4, 5, 2, 79.99, 159.98, 'Classic Denim Jeans', 'SKU-514256', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(14, 4, 10, 2, 39.99, 79.98, 'Professional Yoga Mat', 'SKU-838110', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(15, 5, 3, 1, 29.99, 29.99, 'Portable Phone Charger 20000mAh', 'SKU-745019', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(16, 5, 4, 2, 34.99, 69.98, 'Premium Cotton T-Shirt', 'SKU-799371', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(17, 5, 6, 2, 159.99, 319.98, 'Winter Wool Jacket', 'SKU-685782', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(18, 5, 7, 3, 249.99, 749.97, 'Stainless Steel Cookware Set', 'SKU-347712', '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(19, 6, 2, 2, 599.99, 1199.98, '4K Smart TV 55\"', 'SKU-623177', '2026-03-15 14:49:12', '2026-03-15 14:49:12'),
(20, 7, 2, 1, 599.99, 599.99, '4K Smart TV 55\"', 'SKU-623177', '2026-03-16 03:23:14', '2026-03-16 03:23:14'),
(21, 8, 2, 1, 599.99, 599.99, '4K Smart TV 55\"', 'SKU-623177', '2026-03-16 03:23:41', '2026-03-16 03:23:41');

-- --------------------------------------------------------

--
-- Table structure for table `order_tracking`
--

CREATE TABLE `order_tracking` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('pending','processing','packed','shipped','in_transit','out_for_delivery','delivered','returned','cancelled') NOT NULL DEFAULT 'pending',
  `location` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `tracking_number` varchar(255) DEFAULT NULL,
  `carrier` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_tracking`
--

INSERT INTO `order_tracking` (`id`, `order_id`, `status`, `location`, `description`, `tracking_number`, `carrier`, `created_at`, `updated_at`) VALUES
(1, 2, 'pending', 'Order Processing Center', 'Order placed - awaiting payment confirmation', NULL, NULL, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(2, 3, 'pending', 'Order Processing Center', 'Order placed - payment confirmed', NULL, NULL, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(3, 3, 'processing', 'Warehouse', 'Order is being prepared for shipment', NULL, NULL, '2026-03-13 21:43:31', '2026-03-13 19:43:31'),
(4, 3, 'shipped', 'Distribution Center', 'Order has been shipped', 'TRACK216964', NULL, '2026-03-14 01:43:31', '2026-03-13 19:43:31'),
(5, 5, 'pending', 'Order Processing Center', 'Order placed - payment confirmed', NULL, NULL, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(6, 5, 'processing', 'Warehouse', 'Order is being prepared for shipment', NULL, NULL, '2026-03-13 21:43:31', '2026-03-13 19:43:31'),
(7, 5, 'shipped', 'Distribution Center', 'Order has been shipped', 'TRACK850699', NULL, '2026-03-14 01:43:31', '2026-03-13 19:43:31');

-- --------------------------------------------------------

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` enum('credit_card','debit_card','bank_transfer','mobile_money','cash_on_delivery','paypal','wallet','cryptocurrency','other','paystack','flutterwave') NOT NULL DEFAULT 'credit_card',
  `description` text DEFAULT NULL,
  `settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`settings`)),
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `name`, `type`, `description`, `settings`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Credit Card', 'credit_card', 'Visa, Mastercard, American Express', NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(2, 'Debit Card', 'debit_card', 'Direct debit from bank account', NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(3, 'PayPal', 'paypal', 'PayPal digital wallet', NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(4, 'Direct Bank Transfer', 'bank_transfer', 'Direct bank account transfer', NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(5, 'Mobile Money', 'mobile_money', 'Mobile money and digital payment', NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(6, 'Cash on Delivery', 'cash_on_delivery', 'Pay when order is delivered', NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31');

-- --------------------------------------------------------

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `compare_at_price` decimal(10,2) DEFAULT NULL,
  `cost_price` decimal(10,2) DEFAULT NULL,
  `brand_id` bigint(20) UNSIGNED DEFAULT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `sku` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `images` text DEFAULT NULL,
  `rating` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `name`, `slug`, `description`, `price`, `compare_at_price`, `cost_price`, `brand_id`, `category_id`, `sku`, `image`, `images`, `rating`, `is_active`, `is_featured`, `created_at`, `updated_at`) VALUES
(1, 'Wireless Headphones Pro', 'wireless-headphones-pro', 'Premium wireless headphones with active noise cancellation', 199.99, NULL, 80.00, 1, 1, 'SKU-811420', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(2, '4K Smart TV 55\"', '4k-smart-tv-55', '55 inch 4K Ultra HD Smart Television with streaming apps', 599.99, NULL, 250.00, 9, 1, 'SKU-623177', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(3, 'Portable Phone Charger 20000mAh', 'portable-phone-charger', 'Fast charging portable battery pack', 29.99, NULL, 8.00, 1, 1, 'SKU-745019', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(4, 'Premium Cotton T-Shirt', 'premium-cotton-tshirt', '100% organic cotton comfortable t-shirt', 34.99, NULL, 12.00, 2, 2, 'SKU-799371', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(5, 'Classic Denim Jeans', 'classic-denim-jeans', 'Timeless denim jeans for everyday wear', 79.99, NULL, 25.00, 2, 2, 'SKU-514256', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(6, 'Winter Wool Jacket', 'winter-wool-jacket', 'Warm wool jacket for cold weather', 159.99, NULL, 55.00, 2, 2, 'SKU-685782', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(7, 'Stainless Steel Cookware Set', 'stainless-steel-cookware-set', '12-piece professional cookware set', 249.99, NULL, 90.00, 3, 3, 'SKU-347712', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(8, 'Modern LED Desk Lamp', 'modern-led-desk-lamp', 'Energy-efficient LED desk lamp with adjustable brightness', 44.99, NULL, 15.00, 3, 3, 'SKU-341790', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(9, 'Garden Tool Set', 'garden-tool-set', '10-piece garden tool set for outdoor enthusiasts', 59.99, NULL, 18.00, 3, 3, 'SKU-129521', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(10, 'Professional Yoga Mat', 'professional-yoga-mat', 'Non-slip yoga mat for fitness and meditation', 39.99, NULL, 12.00, 4, 4, 'SKU-838110', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(11, 'Mountain Bike 21-Speed', 'mountain-bike-21-speed', 'Durable mountain bike with 21-speed gears', 399.99, NULL, 150.00, 4, 4, 'SKU-719200', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(12, 'Camping Tent 4-Person', 'camping-tent-4-person', '4-person waterproof camping tent', 149.99, NULL, 45.00, 4, 4, 'SKU-728830', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(13, 'Bestseller Novel Collection', 'bestseller-novel-collection', 'Pack of 5 bestseller novels', 79.99, NULL, 20.00, 5, 5, 'SKU-229223', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(14, 'Sci-Fi Movie Blu-ray Box Set', 'scifi-movie-bluray-box-set', 'Ultimate sci-fi movie collection on Blu-ray', 59.99, NULL, 18.00, 5, 5, 'SKU-897864', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(15, 'Organic Face Cream', 'organic-face-cream', 'Natural organic face cream for all skin types', 49.99, NULL, 15.00, 6, 6, 'SKU-610152', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(16, 'Premium Shampoo & Conditioner Set', 'premium-shampoo-conditioner-set', 'Luxurious hair care duo', 39.99, NULL, 12.00, 6, 6, 'SKU-319425', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(17, 'Organic Coffee Beans 1kg', 'organic-coffee-beans-1kg', 'Premium organic coffee beans', 24.99, NULL, 7.00, 7, 7, 'SKU-752424', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(18, 'Gourmet Chocolate Box', 'gourmet-chocolate-box', '24-piece premium chocolate assortment', 34.99, NULL, 10.00, 7, 7, 'SKU-213015', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(19, 'Educational Building Blocks Set', 'educational-building-blocks-set', '500-piece building blocks for creative learning', 29.99, NULL, 8.00, 8, 8, 'SKU-730520', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(20, 'Board Game Collection', 'board-game-collection', '5 classic board games for family fun', 49.99, NULL, 15.00, 8, 8, 'SKU-346969', '', NULL, 0, 1, 0, '2026-03-13 19:43:31', '2026-03-13 19:43:31');

-- --------------------------------------------------------

--
-- Table structure for table `products_categories`
--

CREATE TABLE `products_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `products_categories`
--

INSERT INTO `products_categories` (`id`, `name`, `slug`, `description`, `parent_id`, `image`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Electronics', 'electronics', 'Electronic devices and gadgets', NULL, NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(2, 'Clothing', 'clothing', 'Men, women, and kids clothing', NULL, NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(3, 'Home & Garden', 'home-garden', 'Home essentials and garden products', NULL, NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(4, 'Sports & Outdoors', 'sports-outdoors', 'Sports equipment and outdoor gear', NULL, NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(5, 'Books & Media', 'books-media', 'Books, movies, and digital media', NULL, NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(6, 'Beauty & Personal Care', 'beauty-personal-care', 'Beauty products and personal care items', NULL, NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(7, 'Food & Beverages', 'food-beverages', 'Food items and beverages', NULL, NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(8, 'Toys & Games', 'toys-games', 'Toys and board games for all ages', NULL, NULL, 1, '2026-03-13 19:43:31', '2026-03-13 19:43:31');

-- --------------------------------------------------------

--
-- Table structure for table `product_images`
--

CREATE TABLE `product_images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `is_primary` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `rating` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `is_approved` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sessions`
--

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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('6NPL1nelSK0auLrbt84zHN69nhlDwyBiRDKquSqo', NULL, '::1', 'Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.22621.4249', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMTV4WXl1NGNyaHNwakNzUmFLZmRuQjhHUXI2MWdnTU93VmQ2Y20ydSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9sb2NhbGhvc3Qvc3RvcmUvcHVibGljL2xvZ2luIjtzOjU6InJvdXRlIjtzOjU6ImxvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1773595540),
('BBFuzcxM4pnpL9xPVmIbizoCcH8Ck0RQhYfjvUr1', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36 OPR/127.0.0.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidGFsdmxhZ3A4d2g4MWpBQm1OQU1LZDBWb2toOEl4TEM5djlLeFBJSyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly9sb2NhbGhvc3Qvc3RvcmUvcHVibGljL3Nob3AvY2FydCI7czo1OiJyb3V0ZSI7czoxNToidXNlci5jYXJ0LmluZGV4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1773595253),
('g8TQeySaSIfcPFK3zFw4CgFwQG0DQIjnZZqfP7vj', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:148.0) Gecko/20100101 Firefox/148.0', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRE9Na3VqdXZqVFhHMjdtQ1RHdTZWUEhsMmFPZzhIRjdZWU9ZYzZNeiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDU6Imh0dHA6Ly9sb2NhbGhvc3Qvc3RvcmUvcHVibGljL2FkbWluL2Rhc2hib2FyZCI7czo1OiJyb3V0ZSI7czoxNToiYWRtaW4uZGFzaGJvYXJkIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1773609263),
('H4f7qZ89jX7bmy7suK1YXGs4Qy0wN2FL2oSltF2z', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36 OPR/127.0.0.0', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiS0RXcGFVMHBUaG5HenhTVTRJMVIybWpvUFFoTmU0a1lTRmRtT3FLYiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly9sb2NhbGhvc3Qvc3RvcmUvcHVibGljL3Nob3AvY2FydCI7czo1OiJyb3V0ZSI7czoxNToidXNlci5jYXJ0LmluZGV4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0MzoiaHR0cDovL2xvY2FsaG9zdC9zdG9yZS9wdWJsaWMvc2hvcC9jaGVja291dCI7fX0=', 1773595083),
('iPv7GOd0ZqWBa2CFN5KZiFWGQTBZbh6TEvWWSeYo', NULL, '::1', 'Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.22621.4249', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoic1VvWk1QZUp2amx5a0ZWVEVyemNOcHZ4NXI4dUdTQk0wVUdlZ2hrMyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9sb2NhbGhvc3Qvc3RvcmUvcHVibGljL2xvZ2luIjtzOjU6InJvdXRlIjtzOjU6ImxvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1773595522),
('SEwjSvb5tL9VtOPk75WzBlmv1maaWGZhBlQ6rAdk', 2, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36 OPR/127.0.0.0', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMnZXUzVyNE1NbjNMYjRUYXZoTkV4ajRZcmZxd3RGTjg3aXhHN0FUTiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjk6Imh0dHA6Ly9sb2NhbGhvc3Qvc3RvcmUvcHVibGljIjtzOjU6InJvdXRlIjtzOjEzOiJmcm9udGVuZC5ob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6Mjt9', 1773611222),
('TcwY8dAwAe4xjUfjDaNtXnI6tZs3DKqQiDnbcovX', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36 OPR/127.0.0.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicTJwdDJEU0JHS3lJZkN5RjlNYXc1ZkhiVm5Tb3FBbnk1UjZ3TnFhZCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjk6Imh0dHA6Ly9sb2NhbGhvc3Qvc3RvcmUvcHVibGljIjtzOjU6InJvdXRlIjtzOjEzOiJmcm9udGVuZC5ob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1773613542),
('TKAm0hiOTn9Kh5pgwFVJir3SI8zHIKmIC8asuNOs', NULL, '::1', 'Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.22621.4249', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSWNwS1FxUFFpYWREUTBPR0RVRTBZZ0JZRVpvZUNWcXRxRUFCd0F1NCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9sb2NhbGhvc3Qvc3RvcmUvcHVibGljL2xvZ2luIjtzOjU6InJvdXRlIjtzOjU6ImxvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1773595701),
('vtYh37nI5clIdzWme53yHGhm7iysWu26xJFUCslc', NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36 OPR/127.0.0.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSjhPTHI3OHQxMDVLWlhLdWkwcTZrU0hGUFloZEZteWRkWWF0c2Q3YSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly9sb2NhbGhvc3Qvc3RvcmUvcHVibGljL3Nob3AvY2FydCI7czo1OiJyb3V0ZSI7czoxNToidXNlci5jYXJ0LmluZGV4Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1773595134),
('zg5wVQvl3G1MghLtkdXKHFIqJ1OBvKJ263zdCBZQ', NULL, '::1', 'Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.22621.4249', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTnRYMklzNktyMUJJTThsaFJXamFtTWxoaGU4VFd4N0FLbzJodW4yeiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9sb2NhbGhvc3Qvc3RvcmUvcHVibGljL2xvZ2luIjtzOjU6InJvdXRlIjtzOjU6ImxvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1773595681);

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(255) NOT NULL,
  `value` longtext DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `key`, `value`, `description`, `created_at`, `updated_at`) VALUES
(1, 'theme_primary', '#1f2937', NULL, '2026-03-14 20:51:24', '2026-03-14 20:51:24'),
(2, 'theme_secondary', '#3b82f6', NULL, '2026-03-14 20:51:25', '2026-03-14 20:51:25'),
(3, 'theme_accent', '#ec4899', NULL, '2026-03-14 20:51:25', '2026-03-14 20:51:25'),
(4, 'theme_success', '#10b981', NULL, '2026-03-14 20:51:25', '2026-03-14 20:51:25'),
(5, 'theme_warning', '#f59e0b', NULL, '2026-03-14 20:51:25', '2026-03-14 20:51:25'),
(6, 'theme_danger', '#ef4444', NULL, '2026-03-14 20:51:25', '2026-03-14 20:51:25'),
(7, 'theme_dark', '#111827', NULL, '2026-03-14 20:51:25', '2026-03-14 20:51:25'),
(8, 'theme_light', '#f9fafb', NULL, '2026-03-14 20:51:25', '2026-03-14 20:51:25');

-- --------------------------------------------------------

--
-- Table structure for table `site_settings`
--

CREATE TABLE `site_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `store_name` varchar(255) NOT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `favicon` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `footer_about` text DEFAULT NULL,
  `footer_copyright` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip_code` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `social_links` text DEFAULT NULL,
  `business_hours` text DEFAULT NULL,
  `shipping_cost` decimal(10,2) NOT NULL DEFAULT 0.00,
  `free_shipping_threshold` int(11) DEFAULT NULL,
  `currency_code` varchar(3) NOT NULL DEFAULT 'USD',
  `currency_symbol` varchar(8) NOT NULL DEFAULT '$',
  `hero_title` varchar(255) DEFAULT NULL,
  `hero_description` text DEFAULT NULL,
  `hero_button_text` varchar(255) DEFAULT NULL,
  `hero_button_url` varchar(255) DEFAULT NULL,
  `hero_image` varchar(255) DEFAULT NULL,
  `featured_section_title` varchar(255) DEFAULT NULL,
  `recent_section_title` varchar(255) DEFAULT NULL,
  `categories_section_title` varchar(255) DEFAULT NULL,
  `features_section_title` varchar(255) DEFAULT NULL,
  `feature_shipping_title` varchar(255) DEFAULT NULL,
  `feature_shipping_text` varchar(255) DEFAULT NULL,
  `feature_payment_title` varchar(255) DEFAULT NULL,
  `feature_payment_text` varchar(255) DEFAULT NULL,
  `feature_returns_title` varchar(255) DEFAULT NULL,
  `feature_returns_text` varchar(255) DEFAULT NULL,
  `feature_support_title` varchar(255) DEFAULT NULL,
  `feature_support_text` varchar(255) DEFAULT NULL,
  `about_us` text DEFAULT NULL,
  `terms_conditions` text DEFAULT NULL,
  `privacy_policy` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_settings`
--

INSERT INTO `site_settings` (`id`, `store_name`, `logo`, `favicon`, `description`, `email`, `phone`, `address`, `footer_about`, `footer_copyright`, `city`, `state`, `zip_code`, `country`, `social_links`, `business_hours`, `shipping_cost`, `free_shipping_threshold`, `currency_code`, `currency_symbol`, `hero_title`, `hero_description`, `hero_button_text`, `hero_button_url`, `hero_image`, `featured_section_title`, `recent_section_title`, `categories_section_title`, `features_section_title`, `feature_shipping_title`, `feature_shipping_text`, `feature_payment_title`, `feature_payment_text`, `feature_returns_title`, `feature_returns_text`, `feature_support_title`, `feature_support_text`, `about_us`, `terms_conditions`, `privacy_policy`, `created_at`, `updated_at`) VALUES
(1, 'My Awesome Store', '/images/logo.png', NULL, 'Welcome to My Awesome Store - Your trusted online marketplace for quality products at great prices.', 'support@store.local', '+1-800-STORE-123', '123 Business Street', NULL, NULL, 'New York', 'NY', '10001', 'United States', '\"{\\\"facebook\\\":\\\"https:\\\\\\/\\\\\\/facebook.com\\\\\\/store\\\",\\\"twitter\\\":\\\"https:\\\\\\/\\\\\\/twitter.com\\\\\\/store\\\",\\\"instagram\\\":\\\"https:\\\\\\/\\\\\\/instagram.com\\\\\\/store\\\",\\\"linkedin\\\":\\\"https:\\\\\\/\\\\\\/linkedin.com\\\\\\/company\\\\\\/store\\\"}\"', '\"{\\\"monday_to_friday\\\":\\\"9:00 AM - 6:00 PM\\\",\\\"saturday\\\":\\\"10:00 AM - 4:00 PM\\\",\\\"sunday\\\":\\\"Closed\\\"}\"', 5.99, 75, 'USD', '₦', 'Online Shopping', 'Discover top-quality products at unbeatable prices. Shop smart with secure checkout and fast delivery.', 'Shop Now', 'http://localhost/store/public/shop/products', 'uploads/hero_1773608155_69b71cdbd79f1.png', 'Featured Products', 'Recent Products', 'Popular Categories', 'Why Shop With Us', 'Fast Shipping', 'Free delivery on orders over ₦75', 'Secure Payment', '100% secure and encrypted transactions', 'Easy Returns', '30-day money-back guarantee', '24/7 Support', 'Dedicated customer support always available', 'My Awesome Store is a leading online retailer specializing in quality products across multiple categories. With over 10 years of experience, we serve thousands of satisfied customers worldwide.', 'By using our store, you agree to our terms and conditions. Please read them carefully before making any purchase.', 'We respect your privacy and are committed to protecting your personal data. See our privacy policy for details on how we collect and use information.', '2026-03-13 19:43:31', '2026-03-16 03:55:55');

-- --------------------------------------------------------

--
-- Table structure for table `support_tickets`
--

CREATE TABLE `support_tickets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `ticket_number` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `status` enum('open','in_progress','resolved','closed') NOT NULL DEFAULT 'open',
  `priority` enum('low','medium','high','urgent') NOT NULL DEFAULT 'medium',
  `category` enum('billing','technical','general','complaint','feature_request') NOT NULL DEFAULT 'general',
  `assigned_to` bigint(20) UNSIGNED DEFAULT NULL,
  `resolved_at` timestamp NULL DEFAULT NULL,
  `closed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `support_tickets`
--

INSERT INTO `support_tickets` (`id`, `user_id`, `ticket_number`, `subject`, `description`, `status`, `priority`, `category`, `assigned_to`, `resolved_at`, `closed_at`, `created_at`, `updated_at`) VALUES
(1, 2, 'TKT-20260313124331-OYCH', 'How do I track my order?', 'I placed an order yesterday but I haven\'t received a tracking number yet. Can you help me track my order? I\'m excited to receive my purchase!', 'resolved', 'medium', 'general', NULL, '2026-03-13 19:43:31', NULL, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(2, 2, 'TKT-20260313124331-DEXE', 'Product arrived damaged', 'The product I received was damaged during shipping. The packaging was not adequate. Please help me with a replacement or refund.', 'in_progress', 'high', 'complaint', NULL, NULL, NULL, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(3, 2, 'TKT-20260313124331-MTPG', 'Request for bulk discount', 'I would like to purchase multiple units of your product for my business. Is there a bulk discount available? What quantities do I need to purchase?', 'open', 'low', 'feature_request', NULL, NULL, NULL, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(4, 2, 'TKT-20260313124331-8UHB', 'Cannot login to my account', 'I\'ve forgotten my password and the reset email is not arriving. I\'ve checked my spam folder but nothing is there. Can you help me regain access to my account?', 'open', 'high', 'technical', NULL, NULL, NULL, '2026-03-13 19:43:31', '2026-03-13 19:43:31'),
(5, 2, 'TKT-20260313124331-YIHA', 'Wrong amount charged', 'I was charged $150 instead of the shown price of $99. I have screenshots of the order confirmation. Please refund the difference immediately.', 'resolved', 'urgent', 'billing', NULL, '2026-03-13 19:43:31', NULL, '2026-03-13 19:43:31', '2026-03-13 19:43:31');

-- --------------------------------------------------------

--
-- Table structure for table `support_ticket_replies`
--

CREATE TABLE `support_ticket_replies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `support_ticket_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `message` longtext NOT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `is_admin_reply` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `theme_color_managers`
--

CREATE TABLE `theme_color_managers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `theme_name` varchar(255) NOT NULL DEFAULT 'default',
  `primary_color` varchar(255) NOT NULL DEFAULT '#000000',
  `secondary_color` varchar(255) NOT NULL DEFAULT '#FFFFFF',
  `accent_color` varchar(255) DEFAULT NULL,
  `success_color` varchar(255) NOT NULL DEFAULT '#28A745',
  `warning_color` varchar(255) NOT NULL DEFAULT '#FFC107',
  `danger_color` varchar(255) NOT NULL DEFAULT '#DC3545',
  `info_color` varchar(255) NOT NULL DEFAULT '#17A2B8',
  `text_color` varchar(255) NOT NULL DEFAULT '#333333',
  `background_color` varchar(255) NOT NULL DEFAULT '#F8F9FA',
  `custom_css` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `theme_color_managers`
--

INSERT INTO `theme_color_managers` (`id`, `theme_name`, `primary_color`, `secondary_color`, `accent_color`, `success_color`, `warning_color`, `danger_color`, `info_color`, `text_color`, `background_color`, `custom_css`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Default Light', '#2c3e50', '#3498db', '#e74c3c', '#28A745', '#FFC107', '#DC3545', '#17A2B8', '#333333', '#ffffff', NULL, 0, '2026-03-13 19:43:31', '2026-03-14 02:12:18'),
(2, 'Dark Mode', '#1a1a1a', '#4a9eff', '#ff6b6b', '#28A745', '#FFC107', '#DC3545', '#17A2B8', '#ffffff', '#0a0a0a', NULL, 0, '2026-03-13 19:43:31', '2026-03-14 02:12:18'),
(3, 'Ocean Blue', '#0077be', '#0096c7', '#00b4d8', '#28A745', '#FFC107', '#DC3545', '#17A2B8', '#1a3a52', '#f0f9ff', NULL, 0, '2026-03-13 19:43:31', '2026-03-14 02:12:18'),
(4, 'Forest Green', '#1b5e20', '#388e3c', '#66bb6a', '#28A745', '#FFC107', '#DC3545', '#17A2B8', '#1a3a1a', '#f1f8e9', NULL, 0, '2026-03-13 19:43:31', '2026-03-14 02:12:18'),
(5, 'Sunset Orange', '#ff6f00', '#ff9100', '#ffb74d', '#28A745', '#FFC107', '#DC3545', '#17A2B8', '#331a00', '#fff3e0', NULL, 1, '2026-03-13 19:43:31', '2026-03-14 02:12:18'),
(6, 'Purple Elegance', '#6a1b9a', '#8e24aa', '#ab47bc', '#28A745', '#FFC107', '#DC3545', '#17A2B8', '#2a0845', '#f3e5f5', NULL, 0, '2026-03-13 19:43:31', '2026-03-14 02:12:18');

-- --------------------------------------------------------

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `payment_method_id` bigint(20) UNSIGNED NOT NULL,
  `transaction_id` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` enum('pending','completed','failed','refunded','cancelled') NOT NULL DEFAULT 'pending',
  `response_data` text DEFAULT NULL,
  `reference_number` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `processed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `order_id`, `payment_method_id`, `transaction_id`, `amount`, `status`, `response_data`, `reference_number`, `notes`, `processed_at`, `created_at`, `updated_at`) VALUES
(1, 7, 3, 'PAYPAL-BERT4ZRXWBVGR9', 599.99, 'failed', '[]', NULL, 'PayPal is not configured by admin.', '2026-03-16 03:23:14', '2026-03-16 03:23:14', '2026-03-16 03:23:14'),
(2, 8, 4, 'BANK_TRANSFER-JP1HSMX9QFRKPI', 599.99, 'pending', '{\"bank_transfer\":{\"bank_name\":\"\",\"account_name\":\"\",\"account_number\":\"\",\"instructions\":\"\"}}', NULL, 'Awaiting customer bank transfer', NULL, '2026-03-16 03:23:41', '2026-03-16 03:23:41');

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip_code` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `bio` text DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `zip` varchar(255) DEFAULT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `phone`, `address`, `city`, `state`, `zip_code`, `country`, `bio`, `avatar`, `is_active`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `zip`, `is_admin`) VALUES
(1, 'Admin User', 'admin@store.local', '+1 (555) 123-4567', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '$2y$12$vERFyx6RUGlwZbVGVJ9Q/uJ.8ecFj5jHCbMoSwza21jXQtQXrr/hO', NULL, '2026-03-13 19:43:30', '2026-03-13 19:43:30', NULL, 1),
(2, 'John Doe', 'customer@store.local', '+1 (555) 987-6543', '123 Main Street', 'New York', 'NY', NULL, 'USA', NULL, NULL, 1, NULL, '$2y$12$f4CW9RgpB0nkiQufq6jtTuylYMc.x8X8kkXjtdFX3U5/zvCH9lnFG', NULL, '2026-03-13 19:43:30', '2026-03-13 19:43:30', '10001', 0),
(3, 'Jettie West V', 'dlindgren@example.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-03-13 19:43:30', '$2y$12$oghWSy3p39hOU/5OsRDdBeXby6NwFmr3boVlsZ0ZSPqchspYE2tUu', 'u4rl3SdyLx', '2026-03-13 19:43:31', '2026-03-13 19:43:31', NULL, 0),
(4, 'Miss Angeline O\'Connell PhD', 'lucinda.dibbert@example.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-03-13 19:43:31', '$2y$12$oghWSy3p39hOU/5OsRDdBeXby6NwFmr3boVlsZ0ZSPqchspYE2tUu', 'g2dshPw2YW', '2026-03-13 19:43:31', '2026-03-13 19:43:31', NULL, 0),
(5, 'Velda Oberbrunner', 'yesenia.keebler@example.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-03-13 19:43:31', '$2y$12$oghWSy3p39hOU/5OsRDdBeXby6NwFmr3boVlsZ0ZSPqchspYE2tUu', 'Spt4MPO982', '2026-03-13 19:43:31', '2026-03-13 19:43:31', NULL, 0),
(6, 'Erick Okuneva', 'ava.gleason@example.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-03-13 19:43:31', '$2y$12$oghWSy3p39hOU/5OsRDdBeXby6NwFmr3boVlsZ0ZSPqchspYE2tUu', 'OFz9cG3TAm', '2026-03-13 19:43:31', '2026-03-13 19:43:31', NULL, 0),
(7, 'Robert Larson', 'adonnelly@example.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '2026-03-13 19:43:31', '$2y$12$oghWSy3p39hOU/5OsRDdBeXby6NwFmr3boVlsZ0ZSPqchspYE2tUu', '0A7GXAm2LW', '2026-03-13 19:43:31', '2026-03-13 19:43:31', NULL, 0);

-- --------------------------------------------------------

--
-- Table structure for table `wishlists`
--

CREATE TABLE `wishlists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wishlists`
--

INSERT INTO `wishlists` (`id`, `user_id`, `product_id`, `created_at`, `updated_at`) VALUES
(1, 2, 19, '2026-03-16 02:10:53', '2026-03-16 02:10:53');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admins_email_unique` (`email`);

--
-- Indexes for table `brands`
--
ALTER TABLE `brands`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `brands_name_unique` (`name`),
  ADD UNIQUE KEY `brands_slug_unique` (`slug`);

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_expiration_index` (`expiration`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_locks_expiration_index` (`expiration`);

--
-- Indexes for table `discounts`
--
ALTER TABLE `discounts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `discounts_code_unique` (`code`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `inventory`
--
ALTER TABLE `inventory`
  ADD PRIMARY KEY (`id`),
  ADD KEY `inventory_product_id_foreign` (`product_id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_reserved_at_available_at_index` (`queue`,`reserved_at`,`available_at`);

--
-- Indexes for table `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_user_id_foreign` (`user_id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `orders_order_number_unique` (`order_number`),
  ADD KEY `orders_user_id_foreign` (`user_id`),
  ADD KEY `orders_discount_id_foreign` (`discount_id`);

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_items_order_id_foreign` (`order_id`),
  ADD KEY `order_items_product_id_foreign` (`product_id`);

--
-- Indexes for table `order_tracking`
--
ALTER TABLE `order_tracking`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_tracking_order_id_foreign` (`order_id`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `payment_methods`
--
ALTER TABLE `payment_methods`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `products_slug_unique` (`slug`),
  ADD UNIQUE KEY `products_sku_unique` (`sku`),
  ADD KEY `products_brand_id_foreign` (`brand_id`),
  ADD KEY `products_category_id_foreign` (`category_id`);

--
-- Indexes for table `products_categories`
--
ALTER TABLE `products_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `products_categories_name_unique` (`name`),
  ADD UNIQUE KEY `products_categories_slug_unique` (`slug`),
  ADD KEY `products_categories_parent_id_foreign` (`parent_id`);

--
-- Indexes for table `product_images`
--
ALTER TABLE `product_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_images_product_id_foreign` (`product_id`);

--
-- Indexes for table `reviews`
--
ALTER TABLE `reviews`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `reviews_product_id_user_id_unique` (`product_id`,`user_id`),
  ADD KEY `reviews_user_id_foreign` (`user_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_key_unique` (`key`);

--
-- Indexes for table `site_settings`
--
ALTER TABLE `site_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `support_tickets`
--
ALTER TABLE `support_tickets`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `support_tickets_ticket_number_unique` (`ticket_number`),
  ADD KEY `support_tickets_user_id_foreign` (`user_id`),
  ADD KEY `support_tickets_assigned_to_foreign` (`assigned_to`);

--
-- Indexes for table `support_ticket_replies`
--
ALTER TABLE `support_ticket_replies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `support_ticket_replies_support_ticket_id_foreign` (`support_ticket_id`),
  ADD KEY `support_ticket_replies_user_id_foreign` (`user_id`);

--
-- Indexes for table `theme_color_managers`
--
ALTER TABLE `theme_color_managers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `transactions_transaction_id_unique` (`transaction_id`),
  ADD KEY `transactions_order_id_foreign` (`order_id`),
  ADD KEY `transactions_payment_method_id_foreign` (`payment_method_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Indexes for table `wishlists`
--
ALTER TABLE `wishlists`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `wishlists_user_id_product_id_unique` (`user_id`,`product_id`),
  ADD KEY `wishlists_product_id_foreign` (`product_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `discounts`
--
ALTER TABLE `discounts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inventory`
--
ALTER TABLE `inventory`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `order_items`
--
ALTER TABLE `order_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `order_tracking`
--
ALTER TABLE `order_tracking`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `payment_methods`
--
ALTER TABLE `payment_methods`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `products_categories`
--
ALTER TABLE `products_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `product_images`
--
ALTER TABLE `product_images`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reviews`
--
ALTER TABLE `reviews`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `site_settings`
--
ALTER TABLE `site_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `support_tickets`
--
ALTER TABLE `support_tickets`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `support_ticket_replies`
--
ALTER TABLE `support_ticket_replies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `theme_color_managers`
--
ALTER TABLE `theme_color_managers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `wishlists`
--
ALTER TABLE `wishlists`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `inventory`
--
ALTER TABLE `inventory`
  ADD CONSTRAINT `inventory_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `notifications`
--
ALTER TABLE `notifications`
  ADD CONSTRAINT `notifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_discount_id_foreign` FOREIGN KEY (`discount_id`) REFERENCES `discounts` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `order_items`
--
ALTER TABLE `order_items`
  ADD CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `order_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`);

--
-- Constraints for table `order_tracking`
--
ALTER TABLE `order_tracking`
  ADD CONSTRAINT `order_tracking_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `products_categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products_categories`
--
ALTER TABLE `products_categories`
  ADD CONSTRAINT `products_categories_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `products_categories` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `product_images`
--
ALTER TABLE `product_images`
  ADD CONSTRAINT `product_images_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `reviews`
--
ALTER TABLE `reviews`
  ADD CONSTRAINT `reviews_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `reviews_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `support_tickets`
--
ALTER TABLE `support_tickets`
  ADD CONSTRAINT `support_tickets_assigned_to_foreign` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `support_tickets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `support_ticket_replies`
--
ALTER TABLE `support_ticket_replies`
  ADD CONSTRAINT `support_ticket_replies_support_ticket_id_foreign` FOREIGN KEY (`support_ticket_id`) REFERENCES `support_tickets` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `support_ticket_replies_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `transactions_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`);

--
-- Constraints for table `wishlists`
--
ALTER TABLE `wishlists`
  ADD CONSTRAINT `wishlists_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `wishlists_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

/*!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 */;