-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `digixyei_digitijara`
--

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `excerpt` text DEFAULT NULL,
  `content` longtext DEFAULT NULL,
  `featured_image` varchar(255) DEFAULT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `author_id` bigint(20) UNSIGNED NOT NULL,
  `store_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('draft','published','scheduled') NOT NULL DEFAULT 'draft',
  `published_at` timestamp NULL DEFAULT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `allow_comments` tinyint(1) NOT NULL DEFAULT 1,
  `views` int(11) NOT NULL DEFAULT 0,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `focus_keyword` varchar(255) DEFAULT NULL,
  `index_in_search` 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;

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

--
-- Table structure for table `blog_blog_tag`
--

CREATE TABLE `blog_blog_tag` (
  `blog_id` bigint(20) UNSIGNED NOT NULL,
  `blog_tag_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `blog_categories`
--

CREATE TABLE `blog_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `store_id` bigint(20) UNSIGNED NOT NULL,
  `created_by` bigint(20) UNSIGNED NOT NULL,
  `post_count` int(11) 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 `blog_comments`
--

CREATE TABLE `blog_comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `blog_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `author_name` varchar(255) DEFAULT NULL,
  `author_email` varchar(255) DEFAULT NULL,
  `content` text NOT NULL,
  `is_approved` tinyint(1) NOT NULL DEFAULT 0,
  `parent_id` bigint(20) UNSIGNED 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 `blog_tags`
--

CREATE TABLE `blog_tags` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `store_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;

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

--
-- 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 `categories`
--

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

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `slug`, `description`, `image`, `parent_id`, `store_id`, `sort_order`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Bathroom Decor', 'bathroom-decor', 'Stylish bathroom accessories and decor items', 'storage/media/1236/conversions/bathroom-decor-thumb.png', NULL, 1, 1, 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(2, 'Furniture', 'furniture', 'Quality furniture for every room', 'storage/media/1237/conversions/furniture-thumb.png', NULL, 1, 2, 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(3, 'Kitchen & Dining Decor', 'kitchen-dining-decor', 'Kitchen and dining room essentials', 'storage/media/1238/conversions/kitchen-dining-decor-thumb.png', NULL, 1, 3, 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(4, 'Lighting', 'lighting', 'Beautiful lighting solutions for your home', 'storage/media/1239/conversions/lighting-thumb.png', NULL, 1, 4, 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(5, 'Outdoor & Garden Decor', 'outdoor-garden-decor', 'Outdoor and garden decoration items', 'storage/media/1240/conversions/outdoor-garden-decor-thumb.png', NULL, 1, 5, 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(6, 'Men\'s Wear', 'mens-wear', NULL, '/storage/media/64/mujdaddy-fabrics.png', NULL, 2, -1, 1, '2026-01-01 11:33:25', '2026-02-18 20:57:21'),
(8, 'Accessories', 'accessories', NULL, '/storage/media/86/accessories.webp', NULL, 3, 1, 1, '2026-01-01 12:51:30', '2026-03-11 00:17:20'),
(9, 'Lightning', 'lightning', NULL, '/storage/media/84/lighting.webp', NULL, 3, 2, 1, '2026-01-01 12:52:02', '2026-03-11 00:17:34'),
(10, 'Decor', 'decor', NULL, '/storage/media/85/decor.webp', NULL, 3, 0, 1, '2026-01-01 12:52:35', '2026-03-11 00:17:53'),
(13, 'CHAWALA FABRICS', 'chawala-fabrics', NULL, '/storage/media/66/WhatsApp-Image-2026-01-13-at-9.47.41-AM.png', NULL, 2, 2, 1, '2026-02-18 20:58:21', '2026-02-18 20:59:03');

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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `state_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `status` 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 `cities`
--

INSERT INTO `cities` (`id`, `state_id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'Los Angeles', 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(2, 1, 'San Francisco', 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(3, 2, 'Houston', 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(4, 2, 'Dallas', 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32');

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` text NOT NULL,
  `is_landing_page` 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 `countries`
--

CREATE TABLE `countries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `code` varchar(3) NOT NULL,
  `status` 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 `countries`
--

INSERT INTO `countries` (`id`, `name`, `code`, `status`, `created_at`, `updated_at`) VALUES
(1, 'United States', 'US', 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(3, 'Pakistan', 'PK', 1, '2026-01-01 16:51:54', '2026-01-01 16:51:54');

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

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` enum('percentage','flat') NOT NULL,
  `minimum_spend` decimal(10,2) DEFAULT NULL,
  `maximum_spend` decimal(10,2) DEFAULT NULL,
  `discount_amount` decimal(10,2) NOT NULL,
  `use_limit_per_coupon` int(11) DEFAULT NULL,
  `use_limit_per_user` int(11) DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `code` varchar(255) NOT NULL,
  `code_type` enum('manual','auto') NOT NULL DEFAULT 'manual',
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_by` 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 `coupons`
--

INSERT INTO `coupons` (`id`, `name`, `type`, `minimum_spend`, `maximum_spend`, `discount_amount`, `use_limit_per_coupon`, `use_limit_per_user`, `expiry_date`, `code`, `code_type`, `status`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'bestek-Developer', 'percentage', 0.00, NULL, 99.00, NULL, NULL, NULL, 'BESTEK-DEVELOPER', 'manual', 1, 1, '2026-02-16 10:34:47', '2026-02-16 10:34:47');

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

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `code` varchar(10) NOT NULL,
  `symbol` varchar(10) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `is_default` 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 `currencies`
--

INSERT INTO `currencies` (`id`, `name`, `code`, `symbol`, `description`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 'US Dollar', 'USD', '$', 'United States Dollar', 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(2, 'Euro', 'EUR', '€', 'Euro', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(3, 'British Pound', 'GBP', '£', 'British Pound Sterling', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(4, 'Japanese Yen', 'JPY', '¥', 'Japanese Yen', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(5, 'Canadian Dollar', 'CAD', 'C$', 'Canadian Dollar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(6, 'Australian Dollar', 'AUD', 'A$', 'Australian Dollar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(7, 'Swiss Franc', 'CHF', 'CHF', 'Swiss Franc', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(8, 'Chinese Yuan', 'CNY', '¥', 'Chinese Yuan', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(9, 'Swedish Krona', 'SEK', 'kr', 'Swedish Krona', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(10, 'New Zealand Dollar', 'NZD', 'NZ$', 'New Zealand Dollar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(11, 'Mexican Peso', 'MXN', '$', 'Mexican Peso', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(12, 'Singapore Dollar', 'SGD', 'S$', 'Singapore Dollar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(13, 'Hong Kong Dollar', 'HKD', 'HK$', 'Hong Kong Dollar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(14, 'Norwegian Krone', 'NOK', 'kr', 'Norwegian Krone', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(15, 'South Korean Won', 'KRW', '₩', 'South Korean Won', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(16, 'Turkish Lira', 'TRY', '₺', 'Turkish Lira', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(17, 'Russian Ruble', 'RUB', '₽', 'Russian Ruble', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(18, 'Indian Rupee', 'INR', '₹', 'Indian Rupee', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(19, 'Brazilian Real', 'BRL', 'R$', 'Brazilian Real', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(20, 'South African Rand', 'ZAR', 'R', 'South African Rand', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(21, 'Polish Zloty', 'PLN', 'zł', 'Polish Zloty', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(22, 'Israeli Shekel', 'ILS', '₪', 'Israeli Shekel', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(23, 'Danish Krone', 'DKK', 'kr', 'Danish Krone', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(24, 'Czech Koruna', 'CZK', 'Kč', 'Czech Koruna', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(25, 'Hungarian Forint', 'HUF', 'Ft', 'Hungarian Forint', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(26, 'Romanian Leu', 'RON', 'lei', 'Romanian Leu', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(27, 'Croatian Kuna', 'HRK', 'kn', 'Croatian Kuna', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(28, 'Bulgarian Lev', 'BGN', 'лв', 'Bulgarian Lev', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(29, 'Thai Baht', 'THB', '฿', 'Thai Baht', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(30, 'Malaysian Ringgit', 'MYR', 'RM', 'Malaysian Ringgit', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(31, 'Indonesian Rupiah', 'IDR', 'Rp', 'Indonesian Rupiah', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(32, 'Philippine Peso', 'PHP', '₱', 'Philippine Peso', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(33, 'Vietnamese Dong', 'VND', '₫', 'Vietnamese Dong', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(34, 'Argentine Peso', 'ARS', '$', 'Argentine Peso', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(35, 'Chilean Peso', 'CLP', '$', 'Chilean Peso', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(36, 'Colombian Peso', 'COP', '$', 'Colombian Peso', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(37, 'Peruvian Sol', 'PEN', 'S/', 'Peruvian Sol', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(38, 'Uruguayan Peso', 'UYU', '$U', 'Uruguayan Peso', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(39, 'Egyptian Pound', 'EGP', '£', 'Egyptian Pound', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(40, 'Nigerian Naira', 'NGN', '₦', 'Nigerian Naira', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(41, 'Kenyan Shilling', 'KES', 'KSh', 'Kenyan Shilling', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(42, 'Moroccan Dirham', 'MAD', 'DH', 'Moroccan Dirham', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(43, 'Tunisian Dinar', 'TND', 'د.ت', 'Tunisian Dinar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(44, 'UAE Dirham', 'AED', 'د.إ', 'UAE Dirham', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(45, 'Saudi Riyal', 'SAR', '﷼', 'Saudi Riyal', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(46, 'Qatari Riyal', 'QAR', '﷼', 'Qatari Riyal', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(47, 'Kuwaiti Dinar', 'KWD', 'د.ك', 'Kuwaiti Dinar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(48, 'Bahraini Dinar', 'BHD', '.د.ب', 'Bahraini Dinar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(49, 'Omani Rial', 'OMR', '﷼', 'Omani Rial', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(50, 'Jordanian Dinar', 'JOD', 'د.ا', 'Jordanian Dinar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(51, 'Lebanese Pound', 'LBP', '£', 'Lebanese Pound', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(52, 'Pakistani Rupee', 'PKR', '₨', 'Pakistani Rupee', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(53, 'Bangladeshi Taka', 'BDT', '৳', 'Bangladeshi Taka', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(54, 'Sri Lankan Rupee', 'LKR', '₨', 'Sri Lankan Rupee', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(55, 'Nepalese Rupee', 'NPR', '₨', 'Nepalese Rupee', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(56, 'Myanmar Kyat', 'MMK', 'K', 'Myanmar Kyat', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(57, 'Cambodian Riel', 'KHR', '៛', 'Cambodian Riel', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(58, 'Laotian Kip', 'LAK', '₭', 'Laotian Kip', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(59, 'Mongolian Tugrik', 'MNT', '₮', 'Mongolian Tugrik', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(60, 'Kazakhstani Tenge', 'KZT', '₸', 'Kazakhstani Tenge', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(61, 'Uzbekistani Som', 'UZS', 'лв', 'Uzbekistani Som', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(62, 'Ukrainian Hryvnia', 'UAH', '₴', 'Ukrainian Hryvnia', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(63, 'Belarusian Ruble', 'BYN', 'Br', 'Belarusian Ruble', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(64, 'Moldovan Leu', 'MDL', 'L', 'Moldovan Leu', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(65, 'Georgian Lari', 'GEL', '₾', 'Georgian Lari', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(66, 'Armenian Dram', 'AMD', '֏', 'Armenian Dram', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(67, 'Azerbaijani Manat', 'AZN', '₼', 'Azerbaijani Manat', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(68, 'Icelandic Krona', 'ISK', 'kr', 'Icelandic Krona', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(69, 'Albanian Lek', 'ALL', 'L', 'Albanian Lek', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(70, 'Serbian Dinar', 'RSD', 'дин', 'Serbian Dinar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(71, 'Bosnian Mark', 'BAM', 'KM', 'Bosnian Mark', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(72, 'North Macedonian Denar', 'MKD', 'ден', 'North Macedonian Denar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(73, 'Ethiopian Birr', 'ETB', 'Br', 'Ethiopian Birr', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(74, 'Ghanaian Cedi', 'GHS', '₵', 'Ghanaian Cedi', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(75, 'Tanzanian Shilling', 'TZS', 'TSh', 'Tanzanian Shilling', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(76, 'Ugandan Shilling', 'UGX', 'USh', 'Ugandan Shilling', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(77, 'Zambian Kwacha', 'ZMW', 'ZK', 'Zambian Kwacha', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(78, 'Botswana Pula', 'BWP', 'P', 'Botswana Pula', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(79, 'Namibian Dollar', 'NAD', 'N$', 'Namibian Dollar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(80, 'Mauritian Rupee', 'MUR', '₨', 'Mauritian Rupee', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(81, 'Seychellois Rupee', 'SCR', '₨', 'Seychellois Rupee', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(82, 'Maldivian Rufiyaa', 'MVR', '.ރ', 'Maldivian Rufiyaa', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(83, 'Fijian Dollar', 'FJD', 'FJ$', 'Fijian Dollar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(84, 'Papua New Guinean Kina', 'PGK', 'K', 'Papua New Guinean Kina', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(85, 'Tongan Paʻanga', 'TOP', 'T$', 'Tongan Paʻanga', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(86, 'Samoan Tala', 'WST', 'T', 'Samoan Tala', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(87, 'Vanuatu Vatu', 'VUV', 'VT', 'Vanuatu Vatu', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(88, 'Solomon Islands Dollar', 'SBD', 'SI$', 'Solomon Islands Dollar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(89, 'Brunei Dollar', 'BND', 'B$', 'Brunei Dollar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(90, 'East Caribbean Dollar', 'XCD', 'EC$', 'East Caribbean Dollar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(91, 'Barbadian Dollar', 'BBD', 'Bds$', 'Barbadian Dollar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(92, 'Jamaican Dollar', 'JMD', 'J$', 'Jamaican Dollar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(93, 'Trinidad and Tobago Dollar', 'TTD', 'TT$', 'Trinidad and Tobago Dollar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(94, 'Bahamian Dollar', 'BSD', 'B$', 'Bahamian Dollar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(95, 'Belize Dollar', 'BZD', 'BZ$', 'Belize Dollar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(96, 'Costa Rican Colon', 'CRC', '₡', 'Costa Rican Colon', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(97, 'Guatemalan Quetzal', 'GTQ', 'Q', 'Guatemalan Quetzal', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(98, 'Honduran Lempira', 'HNL', 'L', 'Honduran Lempira', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(99, 'Nicaraguan Cordoba', 'NIO', 'C$', 'Nicaraguan Cordoba', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(100, 'Panamanian Balboa', 'PAB', 'B/.', 'Panamanian Balboa', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(101, 'Dominican Peso', 'DOP', 'RD$', 'Dominican Peso', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(102, 'Haitian Gourde', 'HTG', 'G', 'Haitian Gourde', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(103, 'Cuban Peso', 'CUP', '₱', 'Cuban Peso', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(104, 'Bolivian Boliviano', 'BOB', '$b', 'Bolivian Boliviano', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(105, 'Paraguayan Guarani', 'PYG', 'Gs', 'Paraguayan Guarani', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(106, 'Guyanese Dollar', 'GYD', 'G$', 'Guyanese Dollar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(107, 'Surinamese Dollar', 'SRD', 'Sr$', 'Surinamese Dollar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(108, 'Venezuelan Bolivar', 'VES', 'Bs.S', 'Venezuelan Bolivar', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(109, 'Ecuadorian Sucre', 'ECS', 'S/.', 'Ecuadorian Sucre', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32');

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

--
-- Table structure for table `customer_addresses`
--

CREATE TABLE `customer_addresses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL,
  `type` enum('billing','shipping') NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) DEFAULT NULL,
  `postal_code` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `is_default` 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 `customer_addresses`
--

INSERT INTO `customer_addresses` (`id`, `customer_id`, `type`, `address`, `city`, `state`, `postal_code`, `country`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 1, 'billing', '', '', '', '', 'us', 1, '2026-01-01 12:56:40', '2026-01-01 12:56:40'),
(2, 1, 'shipping', '', '', '', '', 'us', 1, '2026-01-01 12:56:40', '2026-01-01 12:56:40');

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

--
-- Table structure for table `customer_password_resets`
--

CREATE TABLE `customer_password_resets` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `store_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `custom_pages`
--

CREATE TABLE `custom_pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `content` longtext DEFAULT NULL,
  `store_id` bigint(20) UNSIGNED NOT NULL,
  `template` varchar(255) NOT NULL DEFAULT 'default',
  `status` enum('draft','published','private') NOT NULL DEFAULT 'draft',
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `show_in_navigation` tinyint(1) NOT NULL DEFAULT 0,
  `allow_comments` tinyint(1) NOT NULL DEFAULT 0,
  `views` int(11) NOT NULL DEFAULT 0,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `canonical_url` varchar(255) DEFAULT NULL,
  `index_in_search` tinyint(1) NOT NULL DEFAULT 1,
  `follow_links` 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 `custom_pages`
--

INSERT INTO `custom_pages` (`id`, `title`, `slug`, `content`, `store_id`, `template`, `status`, `parent_id`, `order`, `show_in_navigation`, `allow_comments`, `views`, `meta_title`, `meta_description`, `meta_keywords`, `canonical_url`, `index_in_search`, `follow_links`, `created_at`, `updated_at`) VALUES
(1, 'About Us', 'about-us-1', '<div class=\"about-us-page\">\n            <h1>About Home Decor Haven</h1>\n            <div class=\"hero-section\">\n                <p class=\"lead\">We are committed to providing quality products and excellent customer service that exceeds expectations in the retail and e-commerce industry.</p>\n            </div>\n            \n            <div class=\"story-section\">\n                <h2>Our Story</h2>\n                <p>Founded with a passion for excellence, Home Decor Haven started with a simple mission: to bring high-quality products directly to customers worldwide. What began as a small business has grown into a trusted brand serving thousands of satisfied customers.</p>\n                <p>Our team specializes in sourcing products from trusted suppliers and manufacturers, and we pride ourselves on customer satisfaction, innovation, and sustainable business practices.</p>\n            </div>\n            \n            <div class=\"values-section\">\n                <h2>Our Values</h2>\n                <ul>\n                    <li><strong>Quality First:</strong> We source only the finest products from trusted suppliers</li>\n                    <li><strong>Customer Focus:</strong> Your satisfaction is our top priority</li>\n                    <li><strong>Innovation:</strong> We continuously improve our services and product offerings</li>\n                    <li><strong>Sustainability:</strong> We are committed to environmentally responsible practices</li>\n                </ul>\n            </div>\n            \n            <div class=\"team-section\">\n                <h2>Meet Our Team</h2>\n                <p>Our dedicated team of professionals works tirelessly to ensure you have the best shopping experience possible. From our customer service representatives to our logistics team, everyone is committed to excellence.</p>\n            </div>\n        </div>', 1, 'default', 'published', NULL, 1, 1, 0, 40, 'About Us', 'Learn more about our store, our story, values, and commitment to quality products and customer service.', NULL, NULL, 1, 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(2, 'Contact Us', 'contact-us-1', '<div class=\"contact-us\">\n            <h1>Contact Home Decor Haven</h1>\n            <p class=\"intro\">We\'d love to hear from you! Get in touch with our team for any questions, support, or feedback.</p>\n            \n            <div class=\"contact-methods\">\n                <div class=\"contact-method\">\n                    <h2>Customer Support</h2>\n                    <p><strong>Email:</strong> support@homedecorhaven.com</p>\n                    <p><strong>Phone:</strong> +1 (555) 546-9083</p>\n                    <p><strong>Hours:</strong> Monday - Friday, 9:00 AM - 6:00 PM EST</p>\n                </div>\n                \n                <div class=\"contact-method\">\n                    <h2>Business Inquiries</h2>\n                    <p><strong>Email:</strong> business@homedecorhaven.com</p>\n                    <p><strong>Phone:</strong> +1 (555) 765-7437</p>\n                </div>\n                \n                <div class=\"contact-method\">\n                    <h2>Press & Media</h2>\n                    <p><strong>Email:</strong> press@homedecorhaven.com</p>\n                </div>\n            </div>\n            \n            <div class=\"office-info\">\n                <h2>Our Office</h2>\n                <address>\n                    886 Business Street<br>\n                    Suite 183<br>\n                    New York, NY 10001<br>\n                    United States\n                </address>\n            </div>\n            \n            <div class=\"response-time\">\n                <h2>Response Times</h2>\n                <ul>\n                    <li><strong>General Inquiries:</strong> Within 24 hours</li>\n                    <li><strong>Technical Support:</strong> Within 4 hours</li>\n                    <li><strong>Order Issues:</strong> Within 2 hours</li>\n                </ul>\n            </div>\n        </div>', 1, 'default', 'published', NULL, 4, 1, 0, 45, 'Contact Us', 'Contact information, office location, and ways to reach our support team for assistance.', NULL, NULL, 1, 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(3, 'FAQ', 'faq-1', '<div class=\"faq-page\">\n                    <h1>Frequently Asked Questions</h1>\n                    <p class=\"intro\">Find answers to the most common questions about our products, services, and policies.</p>\n                    \n                    <div class=\"faq-section\">\n                        <h2>Orders & Shipping</h2>\n                        \n                        <div class=\"faq-item\">\n                            <h3>How long does shipping take?</h3>\n                            <p>Standard shipping typically takes 3-7 business days. Express shipping options are available for faster delivery (1-3 business days).</p>\n                        </div>\n                        \n                        <div class=\"faq-item\">\n                            <h3>Do you ship internationally?</h3>\n                            <p>Yes, we ship to most countries worldwide. International shipping times vary by destination (7-21 business days).</p>\n                        </div>\n                        \n                        <div class=\"faq-item\">\n                            <h3>Can I track my order?</h3>\n                            <p>Absolutely! Once your order ships, you\'ll receive a tracking number via email to monitor your package\'s progress.</p>\n                        </div>\n                    </div>\n                    \n                    <div class=\"faq-section\">\n                        <h2>Returns & Exchanges</h2>\n                        \n                        <div class=\"faq-item\">\n                            <h3>What is your return policy?</h3>\n                            <p>We offer a 30-day return policy for unused items in original packaging. Return shipping is free for defective items.</p>\n                        </div>\n                        \n                        <div class=\"faq-item\">\n                            <h3>How do I initiate a return?</h3>\n                            <p>Contact our customer service team or use our online return portal. We\'ll provide a prepaid return label and instructions.</p>\n                        </div>\n                    </div>\n                    \n                    <div class=\"faq-section\">\n                        <h2>Payment & Security</h2>\n                        \n                        <div class=\"faq-item\">\n                            <h3>What payment methods do you accept?</h3>\n                            <p>We accept all major credit cards, PayPal, Apple Pay, Google Pay, and bank transfers.</p>\n                        </div>\n                        \n                        <div class=\"faq-item\">\n                            <h3>Is my payment information secure?</h3>\n                            <p>Yes, we use industry-standard SSL encryption and comply with PCI DSS standards to protect your payment information.</p>\n                        </div>\n                    </div>\n                    \n                    <div class=\"faq-section\">\n                        <h2>Account & Technical</h2>\n                        \n                        <div class=\"faq-item\">\n                            <h3>Do I need an account to place an order?</h3>\n                            <p>No, you can checkout as a guest. However, creating an account allows you to track orders and save preferences.</p>\n                        </div>\n                        \n                        <div class=\"faq-item\">\n                            <h3>I forgot my password. How can I reset it?</h3>\n                            <p>Click the \"Forgot Password\" link on the login page and follow the instructions sent to your email.</p>\n                        </div>\n                    </div>\n                </div>', 1, 'default', 'published', NULL, 5, 1, 0, 23, 'FAQ', 'Frequently asked questions about orders, shipping, returns, payments, and account management.', NULL, NULL, 1, 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32');

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

--
-- Table structure for table `email_templates`
--

CREATE TABLE `email_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `from` varchar(255) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED 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 `email_templates`
--

INSERT INTO `email_templates` (`id`, `name`, `from`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'Order Created', 'STORGENIE', 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(2, 'Order Created For Owner', 'STORGENIE', 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(3, 'Owner And Store Created', 'STORGENIE', 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(4, 'Status Change', 'STORGENIE', 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32');

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

--
-- Table structure for table `email_template_langs`
--

CREATE TABLE `email_template_langs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `parent_id` bigint(20) UNSIGNED NOT NULL,
  `lang` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `content` longtext 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 `email_template_langs`
--

INSERT INTO `email_template_langs` (`id`, `parent_id`, `lang`, `subject`, `content`, `created_at`, `updated_at`) VALUES
(1, 1, 'en', 'Order Complete', '<p>Hello,</p><p>Welcome to {app_name}.</p><p>Hi, {order_name}, Thank you for Shopping</p><p>We received your purchase request, we\'ll be in touch shortly!</p><p>Thanks,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(2, 1, 'es', 'Pedido Completado', '<p>Hola,</p><p>Bienvenido a {app_name}.</p><p>Hola, {order_name}, Gracias por comprar</p><p>Recibimos su solicitud de compra, ¡estaremos en contacto en breve!</p><p>Gracias,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(3, 1, 'ar', 'اكتمال الطلب', '<p>مرحبا،</p><p>مرحبا بك في {app_name}.</p><p>مرحبا، {order_name}، شكرا لك على التسوق</p><p>لقد تلقينا طلب الشراء الخاص بك، سنتواصل معك قريبا!</p><p>شكرا،</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(4, 1, 'da', 'Ordre Fuldført', '<p>Hej,</p><p>Velkommen til {app_name}.</p><p>Hej, {order_name}, Tak for at handle</p><p>Vi modtog din købsanmodning, vi kontakter dig snart!</p><p>Tak,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(5, 1, 'de', 'Bestellung Abgeschlossen', '<p>Hallo,</p><p>Willkommen bei {app_name}.</p><p>Hallo, {order_name}, Danke fürs Einkaufen</p><p>Wir haben Ihre Kaufanfrage erhalten, wir melden uns bald!</p><p>Danke,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(6, 1, 'fr', 'Commande Terminée', '<p>Bonjour,</p><p>Bienvenue dans {app_name}.</p><p>Salut, {order_name}, Merci pour vos achats</p><p>Nous avons reçu votre demande d\'achat, nous vous contacterons bientôt!</p><p>Merci,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(7, 1, 'he', 'הזמנה הושלמה', '<p>שלום,</p><p>ברוכים הבאים ל-{app_name}.</p><p>שלום, {order_name}, תודה על הקנייה</p><p>קיבלנו את בקשת הרכישה שלך, נחזור אליך בקרוב!</p><p>תודה,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(8, 1, 'it', 'Ordine Completato', '<p>Ciao,</p><p>Benvenuto in {app_name}.</p><p>Ciao, {order_name}, Grazie per aver fatto acquisti</p><p>Abbiamo ricevuto la tua richiesta di acquisto, ti contatteremo presto!</p><p>Grazie,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(9, 1, 'ja', '注文完了', '<p>こんにちは、</p><p>{app_name}へようこそ。</p><p>こんにちは、{order_name}さん、お買い物ありがとうございます</p><p>ご購入リクエストを受け取りました。すぐにご連絡いたします！</p><p>ありがとうございます、</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(10, 1, 'nl', 'Bestelling Voltooid', '<p>Hallo,</p><p>Welkom bij {app_name}.</p><p>Hallo, {order_name}, Bedankt voor het winkelen</p><p>We hebben je aankoopverzoek ontvangen, we nemen binnenkort contact op!</p><p>Bedankt,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(11, 1, 'pl', 'Zamówienie Zakończone', '<p>Cześć,</p><p>Witamy w {app_name}.</p><p>Cześć, {order_name}, Dziękujemy za zakupy</p><p>Otrzymaliśmy Twoje żądanie zakupu, wkrótce się skontaktujemy!</p><p>Dzięki,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(12, 1, 'pt', 'Pedido Completo', '<p>Olá,</p><p>Bem-vindo ao {app_name}.</p><p>Olá, {order_name}, Obrigado por comprar</p><p>Recebemos seu pedido de compra, entraremos em contato em breve!</p><p>Obrigado,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(13, 1, 'pt-BR', 'Pedido Completo', '<p>Olá,</p><p>Bem-vindo ao {app_name}.</p><p>Olá, {order_name}, Obrigado por comprar</p><p>Recebemos sua solicitação de compra, entraremos em contato em breve!</p><p>Obrigado,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(14, 1, 'ru', 'Заказ Завершен', '<p>Привет,</p><p>Добро пожаловать в {app_name}.</p><p>Привет, {order_name}, Спасибо за покупку</p><p>Мы получили ваш запрос на покупку, скоро свяжемся с вами!</p><p>Спасибо,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(15, 1, 'tr', 'Sipariş Tamamlandı', '<p>Merhaba,</p><p>{app_name}\'e hoş geldiniz.</p><p>Merhaba, {order_name}, Alışveriş yaptığınız için teşekkürler</p><p>Satın alma talebinizi aldık, yakında sizinle iletişime geçeceğiz!</p><p>Teşekkürler,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(16, 1, 'zh', '订单完成', '<p>你好，</p><p>欢迎来到{app_name}。</p><p>你好，{order_name}，感谢您的购买</p><p>我们收到了您的购买请求，我们很快会联系您！</p><p>谢谢，</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(17, 2, 'en', 'Order Detail', '<p>Hello,</p><p>Dear {owner_name}.</p><p>This is Confirmation Order {order_id} place on <span style=\"font-size: 1rem;\">{order_date}.</span></p><p>Thanks,</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(18, 2, 'es', 'Detalle del Pedido', '<p>Hola,</p><p>Estimado {owner_name}.</p><p>Esta es la confirmación del pedido {order_id} realizado el <span style=\"font-size: 1rem;\">{order_date}.</span></p><p>Gracias,</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(19, 2, 'ar', 'تفاصيل الطلب', '<p>مرحبا،</p><p>عزيزي {owner_name}.</p><p>هذا تأكيد الطلب {order_id} المقدم في <span style=\"font-size: 1rem;\">{order_date}.</span></p><p>شكرا،</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(20, 2, 'da', 'Ordre Detaljer', '<p>Hej,</p><p>Kære {owner_name}.</p><p>Dette er bekræftelse af ordre {order_id} afgivet den <span style=\"font-size: 1rem;\">{order_date}.</span></p><p>Tak,</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(21, 2, 'de', 'Bestelldetails', '<p>Hallo,</p><p>Lieber {owner_name}.</p><p>Dies ist die Bestätigung der Bestellung {order_id} vom <span style=\"font-size: 1rem;\">{order_date}.</span></p><p>Danke,</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(22, 2, 'fr', 'Détail de la Commande', '<p>Bonjour,</p><p>Cher {owner_name}.</p><p>Ceci est la confirmation de commande {order_id} passée le <span style=\"font-size: 1rem;\">{order_date}.</span></p><p>Merci,</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(23, 2, 'he', 'פרטי הזמנה', '<p>שלום,</p><p>יקר {owner_name}.</p><p>זהו אישור הזמנה {order_id} שהוגשה ב-<span style=\"font-size: 1rem;\">{order_date}.</span></p><p>תודה,</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(24, 2, 'it', 'Dettagli Ordine', '<p>Ciao,</p><p>Caro {owner_name}.</p><p>Questa è la conferma dell\'ordine {order_id} effettuato il <span style=\"font-size: 1rem;\">{order_date}.</span></p><p>Grazie,</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(25, 2, 'ja', '注文詳細', '<p>こんにちは、</p><p>{owner_name}様。</p><p>これは<span style=\"font-size: 1rem;\">{order_date}</span>に行われた注文{order_id}の確認です。</p><p>ありがとうございます、</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(26, 2, 'nl', 'Bestelling Details', '<p>Hallo,</p><p>Beste {owner_name}.</p><p>Dit is bevestiging van bestelling {order_id} geplaatst op <span style=\"font-size: 1rem;\">{order_date}.</span></p><p>Bedankt,</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(27, 2, 'pl', 'Szczegóły Zamówienia', '<p>Cześć,</p><p>Drogi {owner_name}.</p><p>To jest potwierdzenie zamówienia {order_id} złożonego <span style=\"font-size: 1rem;\">{order_date}.</span></p><p>Dzięki,</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(28, 2, 'pt', 'Detalhes do Pedido', '<p>Olá,</p><p>Caro {owner_name}.</p><p>Esta é a confirmação do pedido {order_id} feito em <span style=\"font-size: 1rem;\">{order_date}.</span></p><p>Obrigado,</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(29, 2, 'pt-BR', 'Detalhes do Pedido', '<p>Olá,</p><p>Caro {owner_name}.</p><p>Esta é a confirmação do pedido {order_id} feito em <span style=\"font-size: 1rem;\">{order_date}.</span></p><p>Obrigado,</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(30, 2, 'ru', 'Детали Заказа', '<p>Привет,</p><p>Дорогой {owner_name}.</p><p>Это подтверждение заказа {order_id}, размещенного <span style=\"font-size: 1rem;\">{order_date}.</span></p><p>Спасибо,</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(31, 2, 'tr', 'Sipariş Detayları', '<p>Merhaba,</p><p>Sayın {owner_name}.</p><p>Bu, <span style=\"font-size: 1rem;\">{order_date}</span> tarihinde verilen {order_id} siparişinin onayıdır.</p><p>Teşekkürler,</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(32, 2, 'zh', '订单详情', '<p>你好，</p><p>亲爱的{owner_name}。</p><p>这是在<span style=\"font-size: 1rem;\">{order_date}</span>下的订单{order_id}的确认。</p><p>谢谢，</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(33, 3, 'en', 'Owner And Store Detail', '<p>Hello,<b> {owner_name} </b>!</p><p>Welcome to our app your login detail for <b> {app_name}</b> is <br></p><p><b>Email : </b>{owner_email}</p><p><b>Password : </b>{owner_password}</p><p><b>App url : </b>{app_url}</p><p><b>Store url : </b>{store_url}</p><p>Thank you for connecting with us,</p><p>{app_name}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(34, 3, 'es', 'Detalles del Propietario y Tienda', '<p>¡Hola,<b> {owner_name} </b>!</p><p>Bienvenido a nuestra aplicación, sus detalles de inicio de sesión para <b> {app_name}</b> son <br></p><p><b>Email : </b>{owner_email}</p><p><b>Contraseña : </b>{owner_password}</p><p><b>URL de la aplicación : </b>{app_url}</p><p><b>URL de la tienda : </b>{store_url}</p><p>Gracias por conectarse con nosotros,</p><p>{app_name}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(35, 3, 'ar', 'تفاصيل المالك والمتجر', '<p>مرحبا،<b> {owner_name} </b>!</p><p>مرحبا بك في تطبيقنا، تفاصيل تسجيل الدخول الخاصة بك لـ <b> {app_name}</b> هي <br></p><p><b>البريد الإلكتروني : </b>{owner_email}</p><p><b>كلمة المرور : </b>{owner_password}</p><p><b>رابط التطبيق : </b>{app_url}</p><p><b>رابط المتجر : </b>{store_url}</p><p>شكرا لك على التواصل معنا،</p><p>{app_name}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(36, 3, 'da', 'Ejer og Butik Detaljer', '<p>Hej,<b> {owner_name} </b>!</p><p>Velkommen til vores app, dine login detaljer for <b> {app_name}</b> er <br></p><p><b>Email : </b>{owner_email}</p><p><b>Adgangskode : </b>{owner_password}</p><p><b>App url : </b>{app_url}</p><p><b>Butik url : </b>{store_url}</p><p>Tak for at forbinde med os,</p><p>{app_name}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(37, 3, 'de', 'Eigentümer und Shop Details', '<p>Hallo,<b> {owner_name} </b>!</p><p>Willkommen in unserer App, Ihre Anmeldedaten für <b> {app_name}</b> sind <br></p><p><b>E-Mail : </b>{owner_email}</p><p><b>Passwort : </b>{owner_password}</p><p><b>App-URL : </b>{app_url}</p><p><b>Shop-URL : </b>{store_url}</p><p>Vielen Dank für die Verbindung mit uns,</p><p>{app_name}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(38, 3, 'fr', 'Détails du Propriétaire et du Magasin', '<p>Bonjour,<b> {owner_name} </b>!</p><p>Bienvenue dans notre application, vos détails de connexion pour <b> {app_name}</b> sont <br></p><p><b>Email : </b>{owner_email}</p><p><b>Mot de passe : </b>{owner_password}</p><p><b>URL de l\'application : </b>{app_url}</p><p><b>URL du magasin : </b>{store_url}</p><p>Merci de vous connecter avec nous,</p><p>{app_name}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(39, 3, 'he', 'פרטי בעלים וחנות', '<p>שלום,<b> {owner_name} </b>!</p><p>ברוכים הבאים לאפליקציה שלנו, פרטי ההתחברות שלך ל-<b> {app_name}</b> הם <br></p><p><b>אימייל : </b>{owner_email}</p><p><b>סיסמה : </b>{owner_password}</p><p><b>כתובת האפליקציה : </b>{app_url}</p><p><b>כתובת החנות : </b>{store_url}</p><p>תודה על ההתחברות אלינו,</p><p>{app_name}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(40, 3, 'it', 'Dettagli Proprietario e Negozio', '<p>Ciao,<b> {owner_name} </b>!</p><p>Benvenuto nella nostra app, i tuoi dettagli di accesso per <b> {app_name}</b> sono <br></p><p><b>Email : </b>{owner_email}</p><p><b>Password : </b>{owner_password}</p><p><b>URL app : </b>{app_url}</p><p><b>URL negozio : </b>{store_url}</p><p>Grazie per esserti connesso con noi,</p><p>{app_name}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(41, 3, 'ja', 'オーナーとストアの詳細', '<p>こんにちは、<b> {owner_name} </b>さん！</p><p>私たちのアプリへようこそ。<b> {app_name}</b>のログイン詳細は <br></p><p><b>メール : </b>{owner_email}</p><p><b>パスワード : </b>{owner_password}</p><p><b>アプリURL : </b>{app_url}</p><p><b>ストアURL : </b>{store_url}</p><p>私たちとつながっていただき、ありがとうございます。</p><p>{app_name}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(42, 3, 'nl', 'Eigenaar en Winkel Details', '<p>Hallo,<b> {owner_name} </b>!</p><p>Welkom bij onze app, je inloggegevens voor <b> {app_name}</b> zijn <br></p><p><b>Email : </b>{owner_email}</p><p><b>Wachtwoord : </b>{owner_password}</p><p><b>App url : </b>{app_url}</p><p><b>Winkel url : </b>{store_url}</p><p>Bedankt voor het verbinden met ons,</p><p>{app_name}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(43, 3, 'pl', 'Szczegóły Właściciela i Sklepu', '<p>Cześć,<b> {owner_name} </b>!</p><p>Witamy w naszej aplikacji, Twoje dane logowania do <b> {app_name}</b> to <br></p><p><b>Email : </b>{owner_email}</p><p><b>Hasło : </b>{owner_password}</p><p><b>URL aplikacji : </b>{app_url}</p><p><b>URL sklepu : </b>{store_url}</p><p>Dziękujemy za połączenie z nami,</p><p>{app_name}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(44, 3, 'pt', 'Detalhes do Proprietário e Loja', '<p>Olá,<b> {owner_name} </b>!</p><p>Bem-vindo ao nosso app, seus detalhes de login para <b> {app_name}</b> são <br></p><p><b>Email : </b>{owner_email}</p><p><b>Senha : </b>{owner_password}</p><p><b>URL do app : </b>{app_url}</p><p><b>URL da loja : </b>{store_url}</p><p>Obrigado por se conectar conosco,</p><p>{app_name}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(45, 3, 'pt-BR', 'Detalhes do Proprietário e Loja', '<p>Olá,<b> {owner_name} </b>!</p><p>Bem-vindo ao nosso app, seus detalhes de login para <b> {app_name}</b> são <br></p><p><b>Email : </b>{owner_email}</p><p><b>Senha : </b>{owner_password}</p><p><b>URL do app : </b>{app_url}</p><p><b>URL da loja : </b>{store_url}</p><p>Obrigado por se conectar conosco,</p><p>{app_name}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(46, 3, 'ru', 'Детали Владельца и Магазина', '<p>Привет,<b> {owner_name} </b>!</p><p>Добро пожаловать в наше приложение, ваши данные для входа в <b> {app_name}</b> <br></p><p><b>Email : </b>{owner_email}</p><p><b>Пароль : </b>{owner_password}</p><p><b>URL приложения : </b>{app_url}</p><p><b>URL магазина : </b>{store_url}</p><p>Спасибо за связь с нами,</p><p>{app_name}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(47, 3, 'tr', 'Sahip ve Mağaza Detayları', '<p>Merhaba,<b> {owner_name} </b>!</p><p>Uygulamamıza hoş geldiniz, <b> {app_name}</b> için giriş bilgileriniz <br></p><p><b>Email : </b>{owner_email}</p><p><b>Şifre : </b>{owner_password}</p><p><b>Uygulama url : </b>{app_url}</p><p><b>Mağaza url : </b>{store_url}</p><p>Bizimle bağlantı kurduğunuz için teşekkürler,</p><p>{app_name}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(48, 3, 'zh', '店主和商店详情', '<p>你好，<b> {owner_name} </b>！</p><p>欢迎使用我们的应用，您的<b> {app_name}</b>登录详情是 <br></p><p><b>邮箱 : </b>{owner_email}</p><p><b>密码 : </b>{owner_password}</p><p><b>应用网址 : </b>{app_url}</p><p><b>商店网址 : </b>{store_url}</p><p>感谢您与我们联系，</p><p>{app_name}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(49, 4, 'en', 'Order Status', '<p>Hello,</p><p>Welcome to {app_name}.</p><p>Your Order is {order_status}!</p><p>Hi {order_name}, Thank you for Shopping</p><p>Thanks,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(50, 4, 'es', 'Estado del Pedido', '<p>Hola,</p><p>Bienvenido a {app_name}.</p><p>¡Su pedido está {order_status}!</p><p>Hola {order_name}, Gracias por comprar</p><p>Gracias,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(51, 4, 'ar', 'حالة الطلب', '<p>مرحبا،</p><p>مرحبا بك في {app_name}.</p><p>طلبك {order_status}!</p><p>مرحبا {order_name}، شكرا لك على التسوق</p><p>شكرا،</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(52, 4, 'da', 'Ordre Status', '<p>Hej,</p><p>Velkommen til {app_name}.</p><p>Din ordre er {order_status}!</p><p>Hej {order_name}, Tak for at handle</p><p>Tak,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(53, 4, 'de', 'Bestellstatus', '<p>Hallo,</p><p>Willkommen bei {app_name}.</p><p>Ihre Bestellung ist {order_status}!</p><p>Hallo {order_name}, Danke fürs Einkaufen</p><p>Danke,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(54, 4, 'fr', 'Statut de la Commande', '<p>Bonjour,</p><p>Bienvenue dans {app_name}.</p><p>Votre commande est {order_status}!</p><p>Salut {order_name}, Merci pour vos achats</p><p>Merci,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(55, 4, 'he', 'סטטוס הזמנה', '<p>שלום,</p><p>ברוכים הבאים ל-{app_name}.</p><p>ההזמנה שלך {order_status}!</p><p>שלום {order_name}, תודה על הקנייה</p><p>תודה,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(56, 4, 'it', 'Stato Ordine', '<p>Ciao,</p><p>Benvenuto in {app_name}.</p><p>Il tuo ordine è {order_status}!</p><p>Ciao {order_name}, Grazie per aver fatto acquisti</p><p>Grazie,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(57, 4, 'ja', '注文ステータス', '<p>こんにちは、</p><p>{app_name}へようこそ。</p><p>あなたの注文は{order_status}です！</p><p>こんにちは{order_name}さん、お買い物ありがとうございます</p><p>ありがとうございます、</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(58, 4, 'nl', 'Bestelling Status', '<p>Hallo,</p><p>Welkom bij {app_name}.</p><p>Je bestelling is {order_status}!</p><p>Hallo {order_name}, Bedankt voor het winkelen</p><p>Bedankt,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(59, 4, 'pl', 'Status Zamówienia', '<p>Cześć,</p><p>Witamy w {app_name}.</p><p>Twoje zamówienie jest {order_status}!</p><p>Cześć {order_name}, Dziękujemy za zakupy</p><p>Dzięki,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(60, 4, 'pt', 'Status do Pedido', '<p>Olá,</p><p>Bem-vindo ao {app_name}.</p><p>Seu pedido está {order_status}!</p><p>Olá {order_name}, Obrigado por comprar</p><p>Obrigado,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(61, 4, 'pt-BR', 'Status do Pedido', '<p>Olá,</p><p>Bem-vindo ao {app_name}.</p><p>Seu pedido está {order_status}!</p><p>Olá {order_name}, Obrigado por comprar</p><p>Obrigado,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(62, 4, 'ru', 'Статус Заказа', '<p>Привет,</p><p>Добро пожаловать в {app_name}.</p><p>Ваш заказ {order_status}!</p><p>Привет {order_name}, Спасибо за покупку</p><p>Спасибо,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(63, 4, 'tr', 'Sipariş Durumu', '<p>Merhaba,</p><p>{app_name}\'e hoş geldiniz.</p><p>Siparişiniz {order_status}!</p><p>Merhaba {order_name}, Alışveriş yaptığınız için teşekkürler</p><p>Teşekkürler,</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(64, 4, 'zh', '订单状态', '<p>你好，</p><p>欢迎来到{app_name}。</p><p>您的订单是{order_status}！</p><p>你好{order_name}，感谢您的购买</p><p>谢谢，</p><p>{app_name}</p><p>{order_url}</p>', '2026-01-01 10:54:32', '2026-01-01 10:54:32');

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

--
-- Table structure for table `express_checkouts`
--

CREATE TABLE `express_checkouts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `store_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `button_text` varchar(255) NOT NULL DEFAULT 'Buy Now',
  `button_color` varchar(255) NOT NULL DEFAULT '#000000',
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `payment_methods` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`payment_methods`)),
  `default_payment_method` varchar(255) DEFAULT NULL,
  `skip_cart` tinyint(1) NOT NULL DEFAULT 1,
  `auto_fill_customer_data` tinyint(1) NOT NULL DEFAULT 1,
  `guest_checkout_allowed` tinyint(1) NOT NULL DEFAULT 0,
  `mobile_optimized` tinyint(1) NOT NULL DEFAULT 1,
  `save_payment_methods` tinyint(1) NOT NULL DEFAULT 0,
  `success_redirect_url` varchar(255) DEFAULT NULL,
  `cancel_redirect_url` varchar(255) DEFAULT NULL,
  `conversions` int(11) NOT NULL DEFAULT 0,
  `revenue` decimal(10,2) NOT NULL DEFAULT 0.00,
  `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 `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 `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 `landing_page_custom_pages`
--

CREATE TABLE `landing_page_custom_pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `content` longtext NOT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `landing_page_custom_pages`
--

INSERT INTO `landing_page_custom_pages` (`id`, `title`, `slug`, `content`, `meta_title`, `meta_description`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES
(1, 'About Us', 'about-us', 'About Our Multi-Store E-commerce Platform: Empowering entrepreneurs to <b>create, manage, and scale multiple online stores smarter</b>.<br>We are dedicated to helping businesses streamline e-commerce operations, optimize store management, and grow their revenue with ease.<br>Our platform centralizes store data, automates sales processes, and provides actionable insights to drive business growth.<br>Whether you\'re launching your first store or managing multiple brands, our platform adapts to your needs—from product management to customer analytics—ensuring efficiency, scalability, and measurable success.<br><b>Stats:</b> &bull; 4+ Years E-commerce Experience &bull; 25K+ Active Stores &bull; 120+ Countries Served<br><b>Our Mission:</b> Transform the way businesses operate online by providing scalable, intelligent, and user-friendly multi-store e-commerce solutions.<br><b>Our Values:</b> Innovation, reliability, and merchant success are at the heart of everything we build.<br><b>Our Commitment:</b> Deliver secure, scalable, and reliable e-commerce solutions with world-class support.<br><b>Our Vision:</b> A future where every entrepreneur maximizes their potential through automated store management, data-driven decisions, and seamless customer experiences.', 'About Us - StoreGo Multi-Store E-commerce Platform', 'Learn more about StoreGo – designed to simplify multi-store operations, optimize inventory management, and accelerate business growth for entrepreneurs worldwide.', 1, 1, '2025-12-06 10:54:32', '2025-12-06 10:54:32'),
(2, 'Privacy Policy', 'privacy-policy', 'Your privacy is important to us. This Privacy Policy explains how our multi-store e-commerce platform collects, uses, and protects your information.<br><b>Information We Collect:</b> &bull; Business and store details such as name, address, phone, and company information &bull; Product inventory, pricing, and sales transaction data &bull; Customer information and purchase history for analytics &bull; Payment processing details and order management data &bull; System usage analytics to enhance platform performance<br><b>How We Use Your Information:</b> &bull; Provide, maintain, and improve e-commerce platform services &bull; Enable store management, product listings, and order processing &bull; Process payments, transactions, and generate invoices securely &bull; Send important updates, notifications, and feature announcements (with your consent) &bull; Monitor and enhance security, prevent fraud, and ensure compliance<br><b>Information Sharing:</b> We do not sell or trade business or customer data. Information may be shared with: &bull; Authorized store owners and administrators &bull; Trusted third-party service providers (e.g., payment gateways, shipping providers) &bull; Legal authorities when required by law<br><b>Data Security:</b> We use encryption, firewalls, access control, and regular audits to safeguard business and transaction data from unauthorized access or misuse.<br><b>Data Retention:</b> Data is stored as long as your account remains active or as legally required. Upon request, data can be deleted, anonymized, or exported as needed.<br><b>Your Rights:</b> You have the right to access, correct, or request deletion of your business data. You may also manage communication preferences or withdraw consent anytime by contacting our support team.', 'Privacy Policy - StoreGo Multi-Store Platform', 'Read the privacy policy of StoreGo to understand how business, store, and transaction data is collected, used, and protected.', 1, 2, '2025-11-28 10:54:32', '2025-11-28 10:54:32'),
(3, 'Terms of Service', 'terms-of-service', 'Please read these terms carefully before using our multi-store e-commerce platform. By accessing or using our services, you agree to these terms.<br><br><b>Acceptance of Terms:</b> By creating an account or using our StoreGo platform, you confirm that you have read, understood, and agree to be bound by these Terms of Service. If you do not agree, you may not use the platform.<br><br><b>Service Description:</b> Our platform provides businesses with multi-store e-commerce solutions, including but not limited to:<br>&bull; Store creation and management tools<br>&bull; Product catalog and inventory management<br>&bull; Order processing and customer management<br>&bull; Payment gateway integrations<br>&bull; Analytics and reporting features<br><br><b>User Responsibilities:</b> As a user of our e-commerce platform, you agree to:<br>&bull; Provide accurate and updated information when creating an account<br>&bull; Maintain confidentiality of your login credentials<br>&bull; Ensure that all uploaded content complies with applicable laws<br>&bull; Use the platform only for lawful e-commerce and business purposes<br><br><b>Subscription & Payments:</b> You agree to pay all fees associated with your chosen plan in accordance with the billing terms. Failure to pay may result in suspension or termination of your account.<br><br><b>Termination of Service:</b> We reserve the right to suspend or terminate your access if you violate these Terms or engage in harmful activities.<br><br><b>Data & Privacy:</b> Your data will be handled per our Privacy Policy. You are responsible for safeguarding your account access.<br><br><b>Limitation of Liability:</b> Our company shall not be held liable for any indirect, incidental, or consequential damages arising from your use of the StoreGo platform.', 'Terms of Service - StoreGo Multi-Store Platform', 'Read our terms of service to understand the rules and responsibilities for using our StoreGo e-commerce platform.', 1, 3, '2025-12-17 10:54:32', '2025-12-17 10:54:32'),
(4, 'Contact Us', 'contact-us', 'Have questions about <b>StoreGo</b>? Our team is here to assist you with demos, pricing, integrations, and more.<br><br><b>Send us a Message:</b> Fill out the form with your Full Name, Email Address, Subject, and Message. Our dedicated support team will get back to you promptly.<br><br><b>Contact Information:</b><br>&bull; <b>Email Us:</b> support@storego.com (Average response time: within 24 hours)<br>&bull; <b>Call Us:</b> +1 (555) 123-4567 (Available Monday – Friday, 9am – 6pm EST)<br>&bull; <b>Visit Us:</b> 123 E-commerce Street, Suite 100, San Francisco, CA 94105<br><br><b>Business Hours:</b><br>&bull; Monday - Friday: 9:00 AM - 6:00 PM EST<br>&bull; Saturday: 10:00 AM - 2:00 PM EST<br>&bull; Sunday: Closed', 'Contact Us - StoreGo Support', 'Reach out to our StoreGo support team for inquiries, demos, pricing, or technical assistance. We\'re here to help you succeed.', 1, 4, '2025-11-13 10:54:32', '2025-11-13 10:54:32'),
(5, 'FAQ', 'faq', 'Find quick answers to the most <b>common questions</b> about using our multi-store e-commerce platform.<br><br><b>Getting Started:</b><br><b>What is StoreGo?</b> StoreGo is a comprehensive multi-store e-commerce platform that helps businesses create unlimited online stores, manage products, process orders, handle customers, and generate detailed analytics.<br><b>How do I get started?</b> You can sign up for a free trial, set up your business profile, create your first store, configure products, and start selling right away.<br><br><b>Features & Operations:</b><br><b>Which subscription plans are available?</b> We offer Free, Starter, Professional, and Enterprise plans to fit businesses of all sizes, each with advanced features such as multi-store management, payment integrations, and analytics tools.<br><b>Can I integrate StoreGo with other tools?</b> Yes, StoreGo integrates with popular payment gateways, shipping providers, accounting software, and marketing tools.<br><br><b>Analytics & Support:</b><br><b>How does reporting work?</b> Our analytics dashboard provides real-time insights into sales performance, customer behavior, product analytics, and store performance across all your stores.<br><b>What support options are available?</b> We offer 24/7 email support, live chat, and phone assistance for premium users. You can also explore our Help Center for detailed guides and tutorials.', 'FAQ - StoreGo Help Center', 'Get answers to frequently asked questions about StoreGo, including features, pricing plans, integrations, and support options.', 1, 5, '2025-12-08 10:54:32', '2025-12-08 10:54:32'),
(6, 'Refund Policy', 'refund-policy', 'We value your trust in <b>StoreGo</b> and are committed to delivering the best experience. Please review our refund policy below.<br><br><b>30-Day Money Back Guarantee:</b> We offer a 30-day money-back guarantee on all premium subscription plans. If StoreGo does not meet your expectations, you can request a full refund within 30 days of purchase.<br><br><b>Eligible Refunds:</b><br>&bull; Monthly and annual subscription plans<br>&bull; One-time premium features or add-ons<br>&bull; Unused portions of prepaid services<br><br><b>Refund Process:</b><br>1. Contact our support team within 30 days of purchase.<br>2. Provide your registered account details and reason for the refund.<br>3. Our team will review and process your request within 3–5 business days.<br>4. Refunds will be credited to your original payment method.<br><br><b>Non-Refundable Items:</b><br>&bull; Custom development, consulting, or integration services<br>&bull; Third-party services or marketplace add-ons<br>&bull; Domain registration or external licensing fees<br>&bull; Subscriptions after the 30-day guarantee period<br><br>If you have any questions about our refund policy, please reach out to <b>support@storego.com</b>. Our team is here to help.', 'Refund Policy - StoreGo', 'Read about the StoreGo refund policy, including our 30-day money-back guarantee and eligibility details.', 1, 6, '2025-11-13 10:54:32', '2025-11-13 10:54:32');

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

--
-- Table structure for table `landing_page_settings`
--

CREATE TABLE `landing_page_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `company_name` varchar(255) DEFAULT 'StoreGo',
  `contact_email` varchar(255) DEFAULT 'support@storego.com',
  `contact_phone` varchar(255) DEFAULT '+1 (555) 123-4567',
  `contact_address` varchar(255) DEFAULT 'San Francisco, CA',
  `config_sections` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`config_sections`)),
  `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 `landing_page_settings`
--

INSERT INTO `landing_page_settings` (`id`, `company_name`, `contact_email`, `contact_phone`, `contact_address`, `config_sections`, `created_at`, `updated_at`) VALUES
(1, 'DigiTijara', 'support@digitijara.com', '+92 308 420 7067', 'Lahore, Pakistan', '{\"sections\":[{\"key\":\"header\",\"transparent\":true,\"background_color\":\"#ffffff\",\"logo_position\":\"left\",\"menu_style\":\"horizontal\",\"show_cta\":true,\"cta_text\":\"Start Free Trial\",\"cta_link\":\"\\/register\",\"sticky\":true,\"shadow\":true},{\"key\":\"hero\",\"title\":\"Pakistan\\u2019s Next-Gen Store Builder\",\"subtitle\":\"DigiTijara is Pakistan\\u2019s powerful all-in-one e-commerce platform designed to help businesses launch, manage, and scale online stores with professional standards \\u2014 without technical complexity.\",\"description\":\"Join thousands of entrepreneurs who use our multi-store SaaS platform to build successful online businesses. Start your free trial today.\",\"announcement_text\":\"\\ud83d\\ude80 New: Advanced Multi-Store Analytics Dashboard Now Available\",\"cta_text\":\"Start Free Trial\",\"cta_link\":\"\\/register\",\"primary_button_text\":\"Start Free Trial\",\"secondary_cta_text\":\"View Live Demo\",\"secondary_cta_link\":\"\\/store\\/demo-store\",\"secondary_button_text\":\"View Live Demo\",\"background_color\":\"#f8fafc\",\"background_image\":\"\\/storage\\/placeholder\\/hero-ecommerce.svg\",\"overlay\":true,\"overlay_opacity\":0.7,\"animation\":\"fade-in\",\"video_url\":null,\"show_stats\":true,\"stats\":[{\"label\":\"Stores Launched\",\"value\":\"25,00+\"},{\"label\":\"Growing Businesses\",\"value\":\"1500+\"},{\"label\":\"Ready-to-Use Themes\",\"value\":\"10+\"}],\"hero_cards\":[{\"title\":\"Quick Setup\",\"description\":\"Launch your store in under 5 minutes\",\"icon\":\"rocket\",\"color\":\"#3b82f6\"},{\"title\":\"Secure Payments\",\"description\":\"30+ payment gateways integrated\",\"icon\":\"shield\",\"color\":\"#10b981\"},{\"title\":\"Multi-Store\",\"description\":\"Manage unlimited stores from one dashboard\",\"icon\":\"store\",\"color\":\"#8b5cf6\"}],\"card\":{\"name\":\"Sarah Sheikh\",\"title\":\"E-commerce Director\",\"company\":\"Digital Commerce Solutions\",\"initials\":\"SS\"},\"image\":\"\\/storage\\/media\\/44\\/ChatGPT-Image-Feb-18,-2026,-04_31_45-PM.png\",\"image_position\":\"right\"},{\"key\":\"features\",\"title\":\"Complete Multi-Store SaaS Platform\",\"subtitle\":\"Everything you need to build and manage unlimited online stores\",\"description\":\"From store creation to theme customization, our SaaS platform provides all the tools you need to run a successful multi-store business.\",\"background_color\":\"#ffffff\",\"layout\":\"alternating\",\"columns\":4,\"show_icons\":true,\"icon_style\":\"modern\",\"features\":[{\"icon\":\"store\",\"title\":\"Unlimited Store Creation\",\"description\":\"Create and manage unlimited online stores from a single SaaS dashboard\",\"color\":\"#3b82f6\",\"link\":\"\\/features\\/multi-store\"},{\"icon\":\"palette\",\"title\":\"Multiple Store Themes\",\"description\":\"Choose from 10+ professional themes: Fashion, Electronics, Beauty, Jewelry, and more\",\"color\":\"#10b981\",\"link\":\"\\/features\\/themes\"},{\"icon\":\"payment\",\"title\":\"30+ Payment Gateways\",\"description\":\"Stripe, PayPal, Razorpay, Flutterwave, and 26+ more payment gateways integrated\",\"color\":\"#f59e0b\",\"link\":\"\\/features\\/payments\"},{\"icon\":\"inventory\",\"title\":\"Product & Inventory Management\",\"description\":\"Manage products, categories, and inventory across all your stores\",\"color\":\"#8b5cf6\",\"link\":\"\\/features\\/inventory\"},{\"icon\":\"users\",\"title\":\"Customer Management\",\"description\":\"Manage customers, orders, and reviews across all stores from one place\",\"color\":\"#ef4444\",\"link\":\"\\/features\\/customers\"},{\"icon\":\"blog\",\"title\":\"Built-in Blog System\",\"description\":\"Each store comes with a complete blog system for content marketing\",\"color\":\"#06b6d4\",\"link\":\"\\/features\\/blog\"}]},{\"key\":\"screenshots\",\"title\":\"See Our SaaS Platform in Action\",\"subtitle\":\"Explore the multi-store dashboard and theme management features\",\"description\":\"Get a glimpse of how easy it is to create and manage multiple online stores with our SaaS platform.\",\"background_color\":\"#f8fafc\",\"layout\":\"carousel\",\"autoplay\":true,\"autoplay_speed\":5000,\"show_thumbnails\":true,\"screenshots_list\":[{\"title\":\"Multi-Store Dashboard\",\"description\":\"Manage all your stores from one central SaaS dashboard\",\"src\":\"\\/storage\\/placeholder\\/landing-page\\/multi-store-dashboard.png\",\"alt\":\"Multi-store SaaS dashboard overview\"},{\"title\":\"Product Management\",\"description\":\"Add products, manage categories, and track inventory for each store\",\"src\":\"\\/storage\\/placeholder\\/landing-page\\/product-management.png\",\"alt\":\"Product management interface\"},{\"title\":\"Theme Selection\",\"description\":\"Choose from 10+ professional themes for each store\",\"src\":\"\\/storage\\/placeholder\\/landing-page\\/theme-selection.png\",\"alt\":\"Store theme selection interface\"},{\"title\":\"Order Management\",\"description\":\"Process orders and manage customer transactions\",\"src\":\"\\/storage\\/placeholder\\/landing-page\\/order-management.png\",\"alt\":\"Order management system\"},{\"title\":\"Blog Management\",\"description\":\"Built-in blog system for each store with content management\",\"src\":\"\\/storage\\/placeholder\\/landing-page\\/blog-management.png\",\"alt\":\"Blog management interface\"},{\"title\":\"Payment Integration\",\"description\":\"30+ payment gateways ready to integrate with your stores\",\"src\":\"\\/storage\\/placeholder\\/landing-page\\/payment-integration.png\",\"alt\":\"Payment gateway integration\"}]},{\"key\":\"why_choose_us\",\"title\":\"Why Choose Our SaaS Platform?\",\"subtitle\":\"The complete multi-store e-commerce SaaS solution\",\"description\":\"Unlike single-store platforms, our SaaS solution is built specifically for managing unlimited stores with different themes and configurations.\",\"background_color\":\"#ffffff\",\"layout\":\"split\",\"image\":\"\\/storage\\/placeholder\\/multi-store-dashboard.svg\",\"image_position\":\"left\",\"reasons\":[{\"title\":\"Complete E-commerce Features\",\"description\":\"Product management, order processing, customer management, and blog system built-in\",\"icon\":\"features\"},{\"title\":\"Ready-to-Use Themes\",\"description\":\"10+ professional themes ready to use - no customization needed, just select and go live\",\"icon\":\"themes\"}],\"stats\":[{\"value\":\"25,000+\",\"label\":\"Active Stores\",\"color\":\"#3b82f6\"},{\"value\":\"98.5%\",\"label\":\"Uptime\",\"color\":\"#10b981\"},{\"value\":\"$2.5M+\",\"label\":\"Revenue Generated\",\"color\":\"#f59e0b\"},{\"value\":\"120+\",\"label\":\"Countries Served\",\"color\":\"#8b5cf6\"}],\"stats_title\":\"Trusted by Entrepreneurs Worldwide\",\"stats_subtitle\":\"Join thousands of successful merchants who chose StoreGo\",\"cta_title\":\"Ready to Launch Your Store?\",\"cta_subtitle\":\"Start your 14-day free trial today - no credit card required\"},{\"key\":\"about\",\"title\":\"About Our Platform\",\"subtitle\":\"Empowering entrepreneurs with multi-store SaaS technology\",\"description\":\"Founded by SaaS and e-commerce experts, our platform is built to solve the real challenges of managing multiple online stores.\",\"background_color\":\"#f8fafc\",\"layout\":\"image-right\",\"image\":\"\\/storage\\/placeholder\\/about-storego.svg\",\"image_position\":\"right\",\"parallax\":false,\"story_title\":\"Revolutionizing Multi-Store E-commerce Since 2019\",\"story_content\":\"StoreGo emerged from the vision of experienced e-commerce professionals who recognized the growing need for unified multi-store management. What started as a solution for managing multiple online stores has evolved into a comprehensive platform serving over 25,000 entrepreneurs across 120+ countries. Our mission is to democratize e-commerce by providing powerful, intuitive tools that enable anyone to build, manage, and scale successful online businesses without technical barriers.\",\"stats\":[{\"label\":\"Store Themes\",\"value\":\"10+\",\"color\":\"#3b82f6\"},{\"label\":\"Payment Gateways\",\"value\":\"30+\",\"color\":\"#10b981\"},{\"label\":\"Active Features\",\"value\":\"50+\",\"color\":\"#8b5cf6\"},{\"label\":\"Customer Rating\",\"value\":\"4.9\\/5\",\"color\":\"#f59e0b\"},{\"label\":\"Support Response\",\"value\":\"<4hrs\",\"color\":\"#ef4444\"},{\"label\":\"Success Rate\",\"value\":\"94%\",\"color\":\"#06b6d4\"}],\"values\":[{\"title\":\"Our Mission\",\"description\":\"To democratize e-commerce by providing powerful, easy-to-use tools that enable anyone to build and manage successful online stores.\",\"icon\":\"target\"},{\"title\":\"Innovation First\",\"description\":\"We continuously innovate to stay ahead of e-commerce trends and provide cutting-edge solutions for modern businesses.\",\"icon\":\"lightbulb\"},{\"title\":\"Customer Success\",\"description\":\"Your success is our success. We provide exceptional support and resources to help you grow your online business.\",\"icon\":\"heart\"},{\"title\":\"Reliability\",\"description\":\"Built on enterprise-grade infrastructure with 99.9% uptime guarantee and world-class security standards.\",\"icon\":\"shield\"}],\"image_title\":\"Innovation Driven\",\"image_subtitle\":\"Building the future of e-commerce\",\"image_icon\":\"\\ud83d\\ude80\"},{\"key\":\"team\",\"title\":\"Meet Our Team\",\"subtitle\":\"Meet the passionate team behind StoreGo\'s success\",\"description\":\"Our diverse team of e-commerce experts, engineers, and designers is dedicated to helping entrepreneurs build successful online businesses.\",\"background_color\":\"#f8fafc\",\"layout\":\"grid\",\"columns\":3,\"members\":[{\"name\":\"Alex Rodriguez\",\"role\":\"CEO & Co-Founder\",\"bio\":\"Former Shopify executive with 10+ years in e-commerce. Passionate about empowering entrepreneurs worldwide.\",\"image\":\"\\/storage\\/placeholder\\/team\\/alex.svg\",\"linkedin\":\"https:\\/\\/linkedin.com\\/in\\/\",\"twitter\":\"https:\\/\\/twitter.com\\/\",\"email\":\"alex@storego.com\"},{\"name\":\"Sarah Kim\",\"role\":\"CTO & Co-Founder\",\"bio\":\"Tech leader specializing in scalable e-commerce platforms. Expert in cloud architecture and SaaS development.\",\"image\":\"\\/storage\\/placeholder\\/team\\/sarah.svg\",\"linkedin\":\"https:\\/\\/linkedin.com\\/in\\/\",\"twitter\":\"https:\\/\\/twitter.com\\/\",\"email\":\"sarah@storego.com\"},{\"name\":\"David Wilson\",\"role\":\"Head of Customer Success\",\"bio\":\"Helping merchants grow their businesses since day one. 8+ years in customer success and e-commerce consulting.\",\"image\":\"\\/storage\\/placeholder\\/team\\/david.svg\",\"linkedin\":\"https:\\/\\/linkedin.com\\/in\\/\",\"email\":\"david@storego.com\"},{\"name\":\"Maria Garcia\",\"role\":\"VP of Engineering\",\"bio\":\"Full-stack engineer with expertise in React, Laravel, and microservices. Leading our product development team.\",\"image\":\"\\/storage\\/placeholder\\/team\\/maria.svg\",\"linkedin\":\"https:\\/\\/linkedin.com\\/in\\/\",\"twitter\":\"https:\\/\\/twitter.com\\/\",\"email\":\"maria@storego.com\"}],\"cta_title\":\"Join Our Growing Team\",\"cta_description\":\"We\'re always looking for talented individuals who are passionate about e-commerce, technology, and helping entrepreneurs succeed. Join us in building the future of multi-store SaaS platforms.\",\"cta_button_text\":\"View Open Positions\"},{\"key\":\"plans\",\"title\":\"Choose Your Plan\",\"subtitle\":\"Transparent pricing that grows with your business\",\"description\":\"Start free and upgrade as you grow. No hidden fees, no transaction charges.\",\"background_color\":\"#f8fafc\",\"billing_toggle\":true,\"highlight_popular\":true,\"show_features\":true,\"money_back_guarantee\":\"30-day money back guarantee\",\"guarantee_text\":\"Try risk-free with our 30-day money back guarantee\",\"annual_discount\":\"Save 20% with annual billing\",\"contact_sales_text\":\"Need a custom enterprise plan?\",\"contact_sales_link\":\"\\/contact-sales\"},{\"key\":\"testimonials\",\"title\":\"What Our Merchants Say\",\"subtitle\":\"Join thousands of successful store owners\",\"description\":\"Don\'t just take our word for it. See what our successful merchants have to say about StoreGo.\",\"background_color\":\"#ffffff\",\"layout\":\"carousel\",\"autoplay\":true,\"autoplay_speed\":6000,\"show_ratings\":true,\"show_navigation\":true,\"show_trust_indicators\":true,\"trust_indicators\":[{\"metric\":\"Customer Satisfaction\",\"value\":\"98.5%\",\"description\":\"of merchants recommend StoreGo to others\"},{\"metric\":\"Average Rating\",\"value\":\"4.9\\/5\",\"description\":\"based on 8,500+ verified reviews\"},{\"metric\":\"Success Rate\",\"value\":\"94%\",\"description\":\"of stores see growth in first 90 days\"},{\"metric\":\"Revenue Growth\",\"value\":\"340%\",\"description\":\"average increase in first year\"},{\"metric\":\"Platform Uptime\",\"value\":\"99.9%\",\"description\":\"guaranteed service availability\"}],\"trust_title\":\"Trusted by Entrepreneurs Worldwide\",\"trust_stats\":[{\"value\":\"98.5%\",\"label\":\"Customer Satisfaction\",\"color\":\"#10b981\"},{\"value\":\"4.9\\/5\",\"label\":\"Average Rating\",\"color\":\"#f59e0b\"},{\"value\":\"94%\",\"label\":\"Success Rate\",\"color\":\"#3b82f6\"},{\"value\":\"99.9%\",\"label\":\"Platform Uptime\",\"color\":\"#8b5cf6\"},{\"value\":\"<2hrs\",\"label\":\"Support Response\",\"color\":\"#ef4444\"}],\"testimonials\":[{\"name\":\"Emma Thompson\",\"role\":\"Store Owner\",\"company\":\"Boutique Fashion Co.\",\"content\":\"StoreGo made it incredibly easy to launch my fashion store. The multi-store feature lets me manage different brands from one dashboard. Sales increased 400% in the first 6 months!\",\"rating\":5,\"avatar\":\"\\/storage\\/placeholder\\/testimonials\\/emma.svg\",\"location\":\"London, UK\"},{\"name\":\"Carlos Martinez\",\"role\":\"E-commerce Manager\",\"company\":\"Electronics Plus\",\"content\":\"The inventory management and POS integration are game-changers. We can track everything in real-time across our online and physical stores.\",\"rating\":5,\"avatar\":\"\\/storage\\/placeholder\\/testimonials\\/carlos.svg\",\"location\":\"Madrid, Spain\"},{\"name\":\"Priya Patel\",\"role\":\"Entrepreneur\",\"company\":\"Handmade Crafts\",\"content\":\"The payment gateway integrations are fantastic. I can accept payments from customers worldwide with no hassle. Customer support is always there when I need help.\",\"rating\":5,\"avatar\":\"\\/storage\\/placeholder\\/testimonials\\/priya.svg\",\"location\":\"Mumbai, India\"}]},{\"key\":\"faq\",\"title\":\"Frequently Asked Questions\",\"subtitle\":\"Everything you need to know about StoreGo\",\"description\":\"Got questions? We\'ve got answers. Browse our most frequently asked questions below.\",\"background_color\":\"#f8fafc\",\"layout\":\"accordion\",\"show_search\":true,\"show_categories\":true,\"contact_support_text\":\"Still have questions? Our support team is here to help.\",\"contact_support_link\":\"\\/contact\",\"cta_text\":\"Ready to Start Your E-commerce Journey?\",\"button_text\":\"Start Free Trial Now\",\"faqs\":[{\"question\":\"How quickly can I set up my first store?\",\"answer\":\"You can create a store in minutes by selecting a theme, adding your products, and configuring basic settings. The platform is designed for quick setup.\",\"category\":\"Getting Started\"},{\"question\":\"Can I manage multiple stores from one account?\",\"answer\":\"Yes! This is a multi-store SaaS platform. You can create and manage unlimited stores from a single dashboard.\",\"category\":\"Multi-Store\"},{\"question\":\"What payment gateways are supported?\",\"answer\":\"We support 30+ payment gateways including Stripe, PayPal, Razorpay, Flutterwave, and many other regional and international providers.\",\"category\":\"Payments\"},{\"question\":\"What themes are available?\",\"answer\":\"We offer 10+ professional themes including Fashion, Electronics, Beauty & Cosmetics, Jewelry, Watches, Furniture, Cars, Baby & Kids, Perfume, and Home & Accessories.\",\"category\":\"Themes\"},{\"question\":\"Does each store have a blog system?\",\"answer\":\"Yes! Every store comes with a built-in blog system for content marketing, with categories, tags, and full content management.\",\"category\":\"Features\"},{\"question\":\"Can customers create accounts and track orders?\",\"answer\":\"Yes! The platform includes complete customer management with registration, login, order tracking, and customer profiles.\",\"category\":\"Customer Management\"}]},{\"key\":\"newsletter\",\"title\":\"Stay Updated\",\"subtitle\":\"Get the latest e-commerce tips and StoreGo updates\",\"description\":\"Join our newsletter and get exclusive insights, tips, and updates delivered to your inbox.\",\"background_color\":\"#3b82f6\",\"text_color\":\"#ffffff\",\"placeholder\":\"Enter your email address\",\"button_text\":\"Subscribe Now\",\"privacy_text\":\"We respect your privacy. Unsubscribe at any time.\",\"benefits\":[{\"icon\":\"\\ud83d\\udcc8\",\"title\":\"Growth Strategies\",\"description\":\"Weekly e-commerce growth tips and best practices\"},{\"icon\":\"\\ud83d\\ude80\",\"title\":\"Early Access\",\"description\":\"Be first to try new StoreGo features and updates\"},{\"icon\":\"\\ud83d\\udca1\",\"title\":\"Success Stories\",\"description\":\"Learn from successful merchant case studies\"}],\"subscriber_count\":\"95,000+\",\"frequency\":\"Weekly\",\"success_message\":\"Thank you for subscribing! Check your email for confirmation.\"},{\"key\":\"contact\",\"title\":\"Get in Touch\",\"subtitle\":\"Ready to start your e-commerce journey?\",\"description\":\"Our team of e-commerce experts is here to help you succeed. Get in touch and let\'s build something amazing together.\",\"background_color\":\"#ffffff\",\"show_form\":true,\"show_info\":true,\"contact_info_title\":\"Contact Information\",\"contact_info_description\":\"Reach out to us through any of these channels. We\'re here to help you build your dream e-commerce business.\",\"form_fields\":[\"name\",\"email\",\"subject\",\"message\"],\"form_title\":\"Send us a message\",\"form_subtitle\":\"We\'ll get back to you within 4 hours\",\"contact_methods\":[{\"type\":\"email\",\"value\":\"support@storego.com\",\"label\":\"Email Support\",\"description\":\"Get help via email\"},{\"type\":\"phone\",\"value\":\"+1 (555) 123-4567\",\"label\":\"Phone Support\",\"description\":\"Speak with our team\"},{\"type\":\"chat\",\"value\":\"Live Chat\",\"label\":\"Live Chat\",\"description\":\"Chat with us instantly\"}],\"response_time\":\"4 hours\",\"support_hours\":\"24\\/7\",\"contact_faqs\":[{\"question\":\"How quickly do you respond to inquiries?\",\"answer\":\"We typically respond to all inquiries within 4 hours during business hours, often much sooner.\"},{\"question\":\"Do you offer phone support?\",\"answer\":\"Yes! Phone support is available for all paid plan customers. Free trial users can access email and chat support.\"},{\"question\":\"Can you help with store setup and migration?\",\"answer\":\"Absolutely! Our team offers free store setup assistance and migration services for all customers.\"}]},{\"key\":\"footer\",\"background_color\":\"#1f2937\",\"text_color\":\"#ffffff\",\"show_social\":true,\"show_newsletter\":true,\"show_logo\":true,\"logo_position\":\"top\",\"description\":\"StoreGo is the leading multi-store e-commerce SaaS platform that empowers entrepreneurs to create, manage, and scale unlimited online stores from a single dashboard. Join thousands of successful merchants worldwide.\",\"newsletter_title\":\"Stay Connected with StoreGo\",\"newsletter_subtitle\":\"Get exclusive e-commerce insights, platform updates, and growth strategies delivered to your inbox\",\"links\":{\"product\":[{\"name\":\"Features\",\"href\":\"#\"},{\"name\":\"Store Themes\",\"href\":\"#\"},{\"name\":\"Pricing Plans\",\"href\":\"#\"},{\"name\":\"Live Demo\",\"href\":\"#\"}],\"company\":[{\"name\":\"About Us\",\"href\":\"#\"},{\"name\":\"Contact Us\",\"href\":\"#\"}],\"support\":[{\"name\":\"FAQ\",\"href\":\"#\"},{\"name\":\"Dashboard\",\"href\":\"#\"}],\"legal\":[{\"name\":\"Privacy Policy\",\"href\":\"#\"},{\"name\":\"Terms of Service\",\"href\":\"#\"},{\"name\":\"Refund Policy\",\"href\":\"#\"}]},\"section_titles\":{\"product\":\"Platform\",\"company\":\"Company\",\"support\":\"Resources\",\"legal\":\"Legal & Security\"},\"social_links\":[],\"copyright\":\"\\u00a9 2024 StoreGo. All rights reserved.\",\"bottom_text\":\"Built for entrepreneurs, by entrepreneurs. Trusted by 25,000+ merchants across 120+ countries worldwide. SOC 2 Type II compliant with 99.9% uptime guarantee.\"}],\"theme\":{\"primary_color\":\"#10b77f\",\"secondary_color\":\"#ffffff\",\"accent_color\":\"#f7f7f7\",\"logo_light\":null,\"logo_dark\":null,\"favicon\":null},\"colors\":{\"primary\":\"#0F3B5F\",\"secondary\":\"#1d4ed8\",\"accent\":\"#F7931E\"},\"seo\":{\"meta_title\":\"DigiTijara- Ecommerce Builder | Launch Your Online Store\",\"meta_description\":\"Create and manage multiple online stores with DigiTijara. 10+ beautiful themes, inventory management, POS, and more. Start your free trial today.\",\"meta_keywords\":\"ecommerce platform, online store builder, multi-store management, sell online, ecommerce website, store builder\"},\"custom_css\":null,\"custom_js\":null,\"section_order\":[\"header\",\"hero\",\"features\",\"screenshots\",\"why_choose_us\",\"about\",\"team\",\"plans\",\"testimonials\",\"faq\",\"newsletter\",\"contact\",\"footer\"],\"section_visibility\":{\"header\":true,\"hero\":true,\"features\":true,\"screenshots\":false,\"why_choose_us\":true,\"about\":true,\"campaigns\":true,\"team\":false,\"plans\":false,\"testimonials\":true,\"faq\":true,\"newsletter\":true,\"contact\":true,\"footer\":true}}', '2026-01-01 10:54:32', '2026-02-18 17:25:29');

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) DEFAULT NULL,
  `collection_name` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `mime_type` varchar(255) DEFAULT NULL,
  `disk` varchar(255) NOT NULL,
  `conversions_disk` varchar(255) DEFAULT NULL,
  `size` bigint(20) UNSIGNED NOT NULL,
  `manipulations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`manipulations`)),
  `custom_properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`custom_properties`)),
  `generated_conversions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`generated_conversions`)),
  `responsive_images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`responsive_images`)),
  `order_column` int(10) UNSIGNED DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED 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 `media`
--

INSERT INTO `media` (`id`, `model_type`, `model_id`, `uuid`, `collection_name`, `name`, `file_name`, `mime_type`, `disk`, `conversions_disk`, `size`, `manipulations`, `custom_properties`, `generated_conversions`, `responsive_images`, `order_column`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'App\\Models\\MediaItem', 5, '467c8c81-f7b3-42e4-aed6-c8ab0f630b9e', 'images', 'hunarsaaz_logo', 'hunarsaaz_logo.png', 'image/png', 'public', 'public', 16118, '[]', '[]', '{\"thumb\":true}', '[]', 1, 4, '2026-01-01 11:47:45', '2026-01-01 11:47:46'),
(14, 'App\\Models\\MediaItem', 18, '0634b103-5bc7-48b9-83b4-6df5bc431b65', 'images', 'edited-image', 'edited-image.webp', 'image/webp', 'public', 'public', 78536, '[]', '[]', '{\"thumb\":true}', '[]', 1, 4, '2026-01-21 09:47:13', '2026-01-21 09:47:13'),
(15, 'App\\Models\\MediaItem', 19, '107fa525-5325-4155-ad15-e9a3babfd719', 'images', 'Armani-Amal-Terrace-Night-View-scaled-1', 'Armani-Amal-Terrace-Night-View-scaled-1.jpg', 'image/jpeg', 'public', 'public', 748639, '[]', '[]', '{\"thumb\":true}', '[]', 1, 4, '2026-01-21 09:49:17', '2026-01-21 09:49:17'),
(25, 'App\\Models\\MediaItem', 38, 'ddb3889c-88c9-4d25-a15f-b874fec87649', 'images', 'image_2026-02-18_155726272', 'image_2026-02-18_155726272.png', 'image/png', 'public', 'public', 21914, '[]', '[]', '{\"thumb\":true}', '[]', 1, 1, '2026-02-18 15:57:28', '2026-02-18 15:57:28'),
(26, 'App\\Models\\MediaItem', 39, 'a83fd874-f7c9-4cb6-95aa-b7f3e0f07599', 'images', 'ChatGPT Image Feb 18, 2026, 03_56_23 PM', 'ChatGPT-Image-Feb-18,-2026,-03_56_23-PM.png', 'image/png', 'public', 'public', 205372, '[]', '[]', '{\"thumb\":true}', '[]', 1, 1, '2026-02-18 15:57:34', '2026-02-18 15:57:34'),
(27, 'App\\Models\\MediaItem', 40, '389264c5-2f90-4137-a50a-a6c661204f1c', 'images', 'image_2026-02-18_155827319', 'image_2026-02-18_155827319.png', 'image/png', 'public', 'public', 21914, '[]', '[]', '{\"thumb\":true}', '[]', 1, 1, '2026-02-18 15:58:28', '2026-02-18 15:58:28'),
(28, 'App\\Models\\MediaItem', 41, 'efecd508-2e97-4cb0-9393-88fe71a92ecf', 'images', 'digitijara', 'digitijara.png', 'image/png', 'public', 'public', 172787, '[]', '[]', '{\"thumb\":true}', '[]', 1, 1, '2026-02-18 15:58:37', '2026-02-18 15:58:37'),
(29, 'App\\Models\\MediaItem', 42, '832e8b8d-ed5c-45a9-99c4-714801e20771', 'images', 'digitijara-favicon', 'digitijara-favicon.png', 'image/png', 'public', 'public', 56950, '[]', '[]', '{\"thumb\":true}', '[]', 1, 1, '2026-02-18 15:59:53', '2026-02-18 15:59:53'),
(30, 'App\\Models\\MediaItem', 43, '01c6e64e-128a-493c-813e-a1fb8f38afc7', 'images', 'digitijara-light', 'digitijara-light.png', 'image/png', 'public', 'public', 196049, '[]', '[]', '{\"thumb\":true}', '[]', 1, 1, '2026-02-18 16:08:00', '2026-02-18 16:08:00'),
(31, 'App\\Models\\MediaItem', 44, '78a2fb95-4dfc-4877-ae99-b559f21b9edb', 'images', 'ChatGPT Image Feb 18, 2026, 04_31_45 PM', 'ChatGPT-Image-Feb-18,-2026,-04_31_45-PM.png', 'image/png', 'public', 'public', 1226372, '[]', '[]', '{\"thumb\":true}', '[]', 1, 1, '2026-02-18 16:32:08', '2026-02-18 16:32:08'),
(33, 'App\\Models\\MediaItem', 53, '66f70b26-6a70-4ef8-bbcd-8934dd364361', 'images', 'facebook logo.jpg (1)', 'facebook-logo.jpg-(1).png', 'image/png', 'public', 'public', 116043, '[]', '[]', '{\"thumb\":true}', '[]', 1, 5, '2026-02-18 19:26:25', '2026-02-18 19:26:25'),
(34, 'App\\Models\\MediaItem', 54, 'fb1e8c7d-9e61-4075-9245-206a23e38186', 'images', 'glutathione mobile product page banners-02.jpg', 'glutathione-mobile-product-page-banners-02.jpg.png', 'image/png', 'public', 'public', 439321, '[]', '[]', '{\"thumb\":true}', '[]', 1, 5, '2026-02-18 19:26:25', '2026-02-18 19:26:25'),
(35, 'App\\Models\\MediaItem', 55, 'b46a559f-2bf4-46e0-baf4-e252aa58678f', 'images', 'serum small banners-05.jpg', 'serum-small-banners-05.jpg.png', 'image/png', 'public', 'public', 1377728, '[]', '[]', '{\"thumb\":true}', '[]', 1, 5, '2026-02-18 19:26:25', '2026-02-18 19:26:26'),
(36, 'App\\Models\\MediaItem', 56, 'e2f422b9-c71b-4e6c-a24e-3f77ef31802e', 'images', 'serum small banners-06.jpg', 'serum-small-banners-06.jpg.png', 'image/png', 'public', 'public', 1352658, '[]', '[]', '{\"thumb\":true}', '[]', 1, 5, '2026-02-18 19:26:26', '2026-02-18 19:26:26'),
(37, 'App\\Models\\MediaItem', 57, 'db4c2ff1-2341-482e-a1d8-c5487be8878e', 'images', 'serum small banners-08.jpg', 'serum-small-banners-08.jpg.png', 'image/png', 'public', 'public', 1013059, '[]', '[]', '{\"thumb\":true}', '[]', 1, 5, '2026-02-18 19:26:26', '2026-02-18 19:26:26'),
(38, 'App\\Models\\MediaItem', 58, '8b8051f7-4fc4-4a62-86dd-aed58f0447eb', 'images', 'serum-facebook-cover.jpg', 'serum-facebook-cover.jpg.png', 'image/png', 'public', 'public', 309558, '[]', '[]', '{\"thumb\":true}', '[]', 1, 5, '2026-02-18 19:26:26', '2026-02-18 19:26:26'),
(39, 'App\\Models\\MediaItem', 59, '96b1c5c4-a8c1-4986-93d7-984dfda75079', 'images', 'serum small banners-07.jpg', 'serum-small-banners-07.jpg.png', 'image/png', 'public', 'public', 1047291, '[]', '[]', '{\"thumb\":true}', '[]', 1, 5, '2026-02-18 19:26:26', '2026-02-18 19:26:27'),
(40, 'App\\Models\\MediaItem', 60, '1e3c909d-8735-43e6-b27d-cfe6b0f9f470', 'images', 'sg serum', 'sg-serum.png', 'image/png', 'public', 'public', 1430643, '[]', '[]', '{\"thumb\":true}', '[]', 1, 5, '2026-02-18 19:34:18', '2026-02-18 19:34:18'),
(41, 'App\\Models\\MediaItem', 61, 'b8e402a4-4977-4a70-8f75-5e7cd0be85ed', 'images', 'SG Face Serum Logo', 'SG-Face-Serum-Logo.png', 'image/png', 'public', 'public', 13373, '[]', '[]', '{\"thumb\":true}', '[]', 1, 5, '2026-02-18 19:37:29', '2026-02-18 19:37:29'),
(42, 'App\\Models\\MediaItem', 63, '13f4cc69-a874-4736-a404-67670b15edf8', 'images', 'Mujaddy Logo.jpg (1)', 'Mujaddy-Logo.jpg-(1).png', 'image/png', 'public', 'public', 112933, '[]', '[]', '{\"thumb\":true}', '[]', 1, 3, '2026-02-18 19:46:54', '2026-02-18 19:46:54'),
(43, 'App\\Models\\MediaItem', 64, '8c7cb445-4b4e-46ad-9da4-40ab78d47ea4', 'images', 'mujdaddy fabrics', 'mujdaddy-fabrics.png', 'image/png', 'public', 'public', 298216, '[]', '[]', '{\"thumb\":true}', '[]', 1, 3, '2026-02-18 20:38:39', '2026-02-18 20:38:39'),
(44, 'App\\Models\\MediaItem', 66, 'b5310207-ad22-40b5-929e-48641cccfb17', 'images', 'WhatsApp Image 2026-01-13 at 9.47.41 AM', 'WhatsApp-Image-2026-01-13-at-9.47.41-AM.png', 'image/png', 'public', 'public', 500161, '[]', '[]', '{\"thumb\":true}', '[]', 1, 3, '2026-02-18 20:41:45', '2026-02-18 20:41:45'),
(45, 'App\\Models\\MediaItem', 67, '8646d3fd-1673-4f3a-b6d8-f29713669cd1', 'images', 'banner', 'banner.png', 'image/png', 'public', 'public', 526331, '[]', '[]', '{\"thumb\":true}', '[]', 1, 3, '2026-02-18 20:43:12', '2026-02-18 20:43:12'),
(46, 'App\\Models\\MediaItem', 68, '6f338d38-7bb0-419e-83cb-3d331928e3bb', 'images', '619347463_17844938955672871_7276050781174341220_n', '619347463_17844938955672871_7276050781174341220_n.jpg', 'image/jpeg', 'public', 'public', 103598, '[]', '[]', '{\"thumb\":true}', '[]', 1, 3, '2026-02-18 21:02:15', '2026-02-18 21:02:15'),
(47, 'App\\Models\\MediaItem', 69, '29046918-e22b-4f53-a7f2-22f6d52432a8', 'images', '2_2cafa97c-628a-45ca-a3b9-ec33a1c7b05a', '2_2cafa97c-628a-45ca-a3b9-ec33a1c7b05a.webp', 'image/webp', 'public', 'public', 256900, '[]', '[]', '{\"thumb\":true}', '[]', 1, 3, '2026-02-18 21:13:21', '2026-02-18 21:13:21'),
(48, 'App\\Models\\MediaItem', 70, '87aa0c19-b59d-4108-b13b-e9c936f5b561', 'images', '1_f947ca7f-7f37-4631-8da4-6c4d03851099', '1_f947ca7f-7f37-4631-8da4-6c4d03851099.webp', 'image/webp', 'public', 'public', 401856, '[]', '[]', '{\"thumb\":true}', '[]', 1, 3, '2026-02-18 21:13:21', '2026-02-18 21:13:21'),
(49, 'App\\Models\\MediaItem', 71, '1aad13af-9c75-44f0-a8eb-716cbee44b96', 'images', '41_3019346f-ce14-4df5-bc97-a8fa52007af2', '41_3019346f-ce14-4df5-bc97-a8fa52007af2.webp', 'image/webp', 'public', 'public', 388872, '[]', '[]', '{\"thumb\":true}', '[]', 1, 3, '2026-02-18 21:13:21', '2026-02-18 21:13:22'),
(50, 'App\\Models\\MediaItem', 72, '751518f1-8a4a-424e-a2ac-dc550302b7a1', 'images', '40', '40.webp', 'image/webp', 'public', 'public', 311702, '[]', '[]', '{\"thumb\":true}', '[]', 1, 3, '2026-02-18 21:13:22', '2026-02-18 21:13:22'),
(51, 'App\\Models\\MediaItem', 73, 'ec8745dc-f374-4591-a9c2-cf2664319997', 'images', '22_8bedb162-962a-40a4-adf6-56d56aedd735', '22_8bedb162-962a-40a4-adf6-56d56aedd735.webp', 'image/webp', 'public', 'public', 385198, '[]', '[]', '{\"thumb\":true}', '[]', 1, 3, '2026-02-18 21:23:46', '2026-02-18 21:23:47'),
(52, 'App\\Models\\MediaItem', 74, '9892a671-201d-4278-890c-ac5941d88acd', 'images', '17_c92d2ef9-1ff7-41f2-9697-d0f2caf3a529', '17_c92d2ef9-1ff7-41f2-9697-d0f2caf3a529.webp', 'image/webp', 'public', 'public', 580100, '[]', '[]', '{\"thumb\":true}', '[]', 1, 3, '2026-02-18 21:23:56', '2026-02-18 21:23:57'),
(53, 'App\\Models\\MediaItem', 75, '7a5c5e0a-cd08-462d-9aec-af8031af4e62', 'images', '19_ec8c774e-0cc4-4697-96e8-ce161ea0de88', '19_ec8c774e-0cc4-4697-96e8-ce161ea0de88.webp', 'image/webp', 'public', 'public', 319484, '[]', '[]', '{\"thumb\":true}', '[]', 1, 3, '2026-02-18 21:24:05', '2026-02-18 21:24:05'),
(54, 'App\\Models\\MediaItem', 76, '7b83b873-7b1f-4463-b4aa-cc4c82989aef', 'images', '20_7e69b972-1218-40cb-bf26-314e4916f862', '20_7e69b972-1218-40cb-bf26-314e4916f862.webp', 'image/webp', 'public', 'public', 306038, '[]', '[]', '{\"thumb\":true}', '[]', 1, 3, '2026-02-18 21:24:13', '2026-02-18 21:24:13'),
(55, 'App\\Models\\MediaItem', 77, '314f5152-c828-499b-a1da-10200219aa28', 'images', 'Hunarsaaz', 'Hunarsaaz.png', 'image/png', 'public', 'public', 225115, '[]', '[]', '{\"thumb\":true}', '[]', 1, 4, '2026-03-10 22:58:04', '2026-03-10 22:58:04'),
(56, 'App\\Models\\MediaItem', 78, '0809db7b-d7af-4d4a-9ac6-8c233f1b7175', 'images', 'Hunarsaaz-transparent(1)', 'Hunarsaaz-transparent(1).webp', 'image/webp', 'public', 'public', 11372, '[]', '[]', '{\"thumb\":true}', '[]', 1, 4, '2026-03-10 23:02:24', '2026-03-10 23:02:24'),
(57, 'App\\Models\\MediaItem', 79, 'add6ef36-72be-4c97-a774-7cdb8c765a06', 'images', 'Hunarsaaz(1)(1)', 'Hunarsaaz(1)(1).webp', 'image/webp', 'public', 'public', 10676, '[]', '[]', '{\"thumb\":true}', '[]', 1, 4, '2026-03-10 23:07:10', '2026-03-10 23:07:10'),
(58, 'App\\Models\\MediaItem', 80, '0d72ad2e-50f7-4b37-a2a6-67b881df3e33', 'images', 'Hunarsaaz_dark_favicon', 'Hunarsaaz_dark_favicon.webp', 'image/webp', 'public', 'public', 2812, '[]', '[]', '{\"thumb\":true}', '[]', 1, 4, '2026-03-10 23:09:23', '2026-03-10 23:09:23'),
(60, 'App\\Models\\MediaItem', 82, '6daa6703-5230-4ec2-8b61-62386ba7000d', 'images', 'Hunarsaaz-Hero_Banner', 'Hunarsaaz-Hero_Banner.webp', 'image/webp', 'public', 'public', 57202, '[]', '[]', '{\"thumb\":true}', '[]', 1, 4, '2026-03-10 23:36:17', '2026-03-10 23:36:17'),
(61, 'App\\Models\\MediaItem', 83, '3101a7d4-7cd7-49ab-8025-a4b2d82da05d', 'images', 'accessories', 'accessories.png', 'image/png', 'public', 'public', 1957223, '[]', '[]', '{\"thumb\":true}', '[]', 1, 4, '2026-03-10 23:53:57', '2026-03-10 23:53:58'),
(62, 'App\\Models\\MediaItem', 84, '5c6bfbbe-9032-4f7e-a339-cf63fdedb503', 'images', 'lighting', 'lighting.webp', 'image/webp', 'public', 'public', 57382, '[]', '[]', '{\"thumb\":true}', '[]', 1, 4, '2026-03-11 00:12:39', '2026-03-11 00:12:40'),
(63, 'App\\Models\\MediaItem', 85, '0c9d92d1-3508-4922-b14c-caefafb84f11', 'images', 'decor', 'decor.webp', 'image/webp', 'public', 'public', 68086, '[]', '[]', '{\"thumb\":true}', '[]', 1, 4, '2026-03-11 00:12:40', '2026-03-11 00:12:40'),
(64, 'App\\Models\\MediaItem', 86, 'ce32bf28-5e8a-4755-8099-9b4c41e2c2b9', 'images', 'accessories', 'accessories.webp', 'image/webp', 'public', 'public', 71252, '[]', '[]', '{\"thumb\":true}', '[]', 1, 4, '2026-03-11 00:12:40', '2026-03-11 00:12:40'),
(65, 'App\\Models\\MediaItem', 87, '6634cb8b-0a7c-4131-ac8b-423bb1783272', 'images', 'Mujadaddy_banner', 'Mujadaddy_banner.webp', 'image/webp', 'public', 'public', 34028, '[]', '[]', '{\"thumb\":true}', '[]', 1, 3, '2026-03-11 01:00:38', '2026-03-11 01:00:38');

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

--
-- Table structure for table `media_items`
--

CREATE TABLE `media_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` 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 `media_items`
--

INSERT INTO `media_items` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(5, 'hunarsaaz_logo.png', NULL, '2026-01-01 11:47:45', '2026-01-01 11:47:45'),
(18, 'edited-image.webp', NULL, '2026-01-21 09:47:13', '2026-01-21 09:47:13'),
(19, 'Armani-Amal-Terrace-Night-View-scaled-1.jpg', NULL, '2026-01-21 09:49:17', '2026-01-21 09:49:17'),
(38, 'image_2026-02-18_155726272.png', NULL, '2026-02-18 15:57:27', '2026-02-18 15:57:27'),
(39, 'ChatGPT Image Feb 18, 2026, 03_56_23 PM.png', NULL, '2026-02-18 15:57:34', '2026-02-18 15:57:34'),
(40, 'image_2026-02-18_155827319.png', NULL, '2026-02-18 15:58:28', '2026-02-18 15:58:28'),
(41, 'digitijara.png', NULL, '2026-02-18 15:58:37', '2026-02-18 15:58:37'),
(42, 'digitijara-favicon.png', NULL, '2026-02-18 15:59:53', '2026-02-18 15:59:53'),
(43, 'digitijara-light.png', NULL, '2026-02-18 16:07:59', '2026-02-18 16:07:59'),
(44, 'ChatGPT Image Feb 18, 2026, 04_31_45 PM.png', NULL, '2026-02-18 16:32:08', '2026-02-18 16:32:08'),
(53, 'facebook logo.jpg (1).png', NULL, '2026-02-18 19:26:25', '2026-02-18 19:26:25'),
(54, 'glutathione mobile product page banners-02.jpg.png', NULL, '2026-02-18 19:26:25', '2026-02-18 19:26:25'),
(55, 'serum small banners-05.jpg.png', NULL, '2026-02-18 19:26:25', '2026-02-18 19:26:25'),
(56, 'serum small banners-06.jpg.png', NULL, '2026-02-18 19:26:26', '2026-02-18 19:26:26'),
(57, 'serum small banners-08.jpg.png', NULL, '2026-02-18 19:26:26', '2026-02-18 19:26:26'),
(58, 'serum-facebook-cover.jpg.png', NULL, '2026-02-18 19:26:26', '2026-02-18 19:26:26'),
(59, 'serum small banners-07.jpg.png', NULL, '2026-02-18 19:26:26', '2026-02-18 19:26:26'),
(60, 'sg serum.png', NULL, '2026-02-18 19:34:18', '2026-02-18 19:34:18'),
(61, 'SG Face Serum Logo.png', NULL, '2026-02-18 19:37:29', '2026-02-18 19:37:29'),
(63, 'Mujaddy Logo.jpg (1).png', NULL, '2026-02-18 19:46:54', '2026-02-18 19:46:54'),
(64, 'mujdaddy fabrics.png', NULL, '2026-02-18 20:38:39', '2026-02-18 20:38:39'),
(66, 'WhatsApp Image 2026-01-13 at 9.47.41 AM.png', NULL, '2026-02-18 20:41:45', '2026-02-18 20:41:45'),
(67, 'banner.png', NULL, '2026-02-18 20:43:12', '2026-02-18 20:43:12'),
(68, '619347463_17844938955672871_7276050781174341220_n.jpg', NULL, '2026-02-18 21:02:15', '2026-02-18 21:02:15'),
(69, '2_2cafa97c-628a-45ca-a3b9-ec33a1c7b05a.webp', NULL, '2026-02-18 21:13:21', '2026-02-18 21:13:21'),
(70, '1_f947ca7f-7f37-4631-8da4-6c4d03851099.webp', NULL, '2026-02-18 21:13:21', '2026-02-18 21:13:21'),
(71, '41_3019346f-ce14-4df5-bc97-a8fa52007af2.webp', NULL, '2026-02-18 21:13:21', '2026-02-18 21:13:21'),
(72, '40.webp', NULL, '2026-02-18 21:13:22', '2026-02-18 21:13:22'),
(73, '22_8bedb162-962a-40a4-adf6-56d56aedd735.webp', NULL, '2026-02-18 21:23:46', '2026-02-18 21:23:46'),
(74, '17_c92d2ef9-1ff7-41f2-9697-d0f2caf3a529.webp', NULL, '2026-02-18 21:23:56', '2026-02-18 21:23:56'),
(75, '19_ec8c774e-0cc4-4697-96e8-ce161ea0de88.webp', NULL, '2026-02-18 21:24:05', '2026-02-18 21:24:05'),
(76, '20_7e69b972-1218-40cb-bf26-314e4916f862.webp', NULL, '2026-02-18 21:24:13', '2026-02-18 21:24:13'),
(77, 'Hunarsaaz.png', NULL, '2026-03-10 22:58:04', '2026-03-10 22:58:04'),
(78, 'Hunarsaaz-transparent(1).webp', NULL, '2026-03-10 23:02:24', '2026-03-10 23:02:24'),
(79, 'Hunarsaaz(1)(1).webp', NULL, '2026-03-10 23:07:10', '2026-03-10 23:07:10'),
(80, 'Hunarsaaz_dark_favicon.webp', NULL, '2026-03-10 23:09:23', '2026-03-10 23:09:23'),
(82, 'Hunarsaaz-Hero_Banner.webp', NULL, '2026-03-10 23:36:16', '2026-03-10 23:36:16'),
(83, 'accessories.png', NULL, '2026-03-10 23:53:57', '2026-03-10 23:53:57'),
(84, 'lighting.webp', NULL, '2026-03-11 00:12:39', '2026-03-11 00:12:39'),
(85, 'decor.webp', NULL, '2026-03-11 00:12:40', '2026-03-11 00:12:40'),
(86, 'accessories.webp', NULL, '2026-03-11 00:12:40', '2026-03-11 00:12:40'),
(87, 'Mujadaddy_banner.webp', NULL, '2026-03-11 01:00:38', '2026-03-11 01:00:38');

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

--
-- 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, '2024_07_17_000001_create_stores_table', 1),
(5, '2025_01_27_084150_create_landing_page_settings_table', 1),
(6, '2025_01_28_000001_create_webhooks_table', 1),
(7, '2025_01_30_083444_create_customers_table', 1),
(8, '2025_01_31_000001_add_domain_fields_to_stores_table', 1),
(9, '2025_01_31_000002_remove_legacy_domain_from_stores_table', 1),
(10, '2025_01_31_020641_create_taxes_table', 1),
(11, '2025_01_31_041251_create_categories_table', 1),
(12, '2025_01_31_043555_create_products_table', 1),
(13, '2025_01_31_062413_create_shippings_table', 1),
(14, '2025_01_31_083511_create_customer_addresses_table', 1),
(15, '2025_01_31_120000_create_orders_table', 1),
(16, '2025_01_31_120001_create_order_items_table', 1),
(17, '2025_01_31_150000_add_whatsapp_support_to_orders_table', 1),
(18, '2025_02_01_000000_create_wishlist_items_table', 1),
(19, '2025_02_01_000001_create_product_reviews_table', 1),
(20, '2025_02_01_000002_add_store_response_to_product_reviews_table', 1),
(21, '2025_02_01_000003_create_newsletter_subscriptions_table', 1),
(22, '2025_02_02_000001_create_store_settings_table', 1),
(23, '2025_02_03_000001_create_countries_table', 1),
(24, '2025_02_03_000002_create_states_table', 1),
(25, '2025_02_03_000003_create_cities_table', 1),
(26, '2025_05_25_000000_create_permission_tables', 1),
(27, '2025_06_18_000001_create_plans_table', 1),
(28, '2025_06_18_000004_add_plan_id_foreign_key', 1),
(29, '2025_06_18_105755_create_settings_table', 1),
(30, '2025_06_19_051735_create_coupons_table', 1),
(31, '2025_06_19_084856_create_plan_requests_table', 1),
(32, '2025_06_19_085023_create_plan_orders_table', 1),
(33, '2025_06_20_044143_create_referral_settings_table', 1),
(34, '2025_06_20_044158_create_referrals_table', 1),
(35, '2025_06_20_044206_create_payout_requests_table', 1),
(36, '2025_06_24_044208_create_currencies_table', 1),
(37, '2025_06_25_061851_add_created_by_to_roles_table', 1),
(38, '2025_06_26_000000_fix_roles_unique_constraint', 1),
(39, '2025_06_26_100501_create_payment_settings_table', 1),
(40, '2025_06_27_053245_create_media_table', 1),
(41, '2025_06_27_060535_create_media_items_table', 1),
(42, '2025_06_27_115807_create_email_templates_table', 1),
(43, '2025_06_27_115820_create_email_template_langs_table', 1),
(44, '2025_06_27_115828_create_user_email_templates_table', 1),
(45, '2025_07_02_094334_create_landing_page_custom_pages_table', 1),
(46, '2025_07_04_000001_update_plans_table_structure', 1),
(47, '2025_07_18_071850_create_store_coupons_table', 1),
(48, '2025_07_18_101606_create_blog_categories_table', 1),
(49, '2025_07_18_105208_create_blogs_table', 1),
(50, '2025_07_18_105318_create_blog_tags_table', 1),
(51, '2025_07_18_105525_create_blog_comments_table', 1),
(52, '2025_07_21_035233_create_custom_pages_table', 1),
(53, '2025_07_21_094201_create_express_checkouts_table', 1),
(54, '2025_07_21_110136_create_pos_tables', 1),
(55, '2025_07_25_072209_create_cart_items_table', 1),
(56, '2025_08_06_104003_create_store_configurations_table', 1),
(57, '2025_08_19_000002_create_newsletters_table', 1),
(58, '2025_08_20_091433_add_duration_to_plan_requests_table', 1),
(59, '2025_09_08_041622_add_landing_page_fields_to_stores_table', 1),
(60, '2025_11_13_085144_add_pwa_fields_to_stores_table', 1),
(61, '2025_11_18_072120_create_contacts_table', 1),
(62, '2025_01_28_000002_create_customer_password_resets_table', 2),
(63, '2025_11_19_161335_enhance_webhooks_table', 2),
(64, '2025_11_21_064235_create_notifications_table', 2),
(65, '2025_11_21_064250_create_notification_template_langs_table', 2);

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

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1),
(2, 'App\\Models\\User', 2),
(2, 'App\\Models\\User', 3),
(2, 'App\\Models\\User', 4),
(2, 'App\\Models\\User', 5),
(2, 'App\\Models\\User', 6),
(2, 'App\\Models\\User', 7);

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

--
-- Table structure for table `newsletters`
--

CREATE TABLE `newsletters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(255) NOT NULL,
  `status` enum('active','unsubscribed') NOT NULL DEFAULT 'active',
  `subscribed_at` timestamp NULL DEFAULT NULL,
  `unsubscribed_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 `newsletter_subscriptions`
--

CREATE TABLE `newsletter_subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `store_id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `subscribed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `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 `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `status` enum('on','off') NOT NULL DEFAULT 'on',
  `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 `notifications`
--

INSERT INTO `notifications` (`id`, `type`, `action`, `status`, `created_at`, `updated_at`) VALUES
(1, 'SMS', 'Order Created', 'on', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(2, 'SMS', 'Order Status Updated', 'on', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(3, 'SMS', 'New Customer', 'on', '2026-02-16 17:02:42', '2026-02-16 17:02:42');

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

--
-- Table structure for table `notification_template_langs`
--

CREATE TABLE `notification_template_langs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `parent_id` bigint(20) UNSIGNED NOT NULL,
  `lang` varchar(10) NOT NULL,
  `variables` text DEFAULT NULL,
  `content` text 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 `notification_template_langs`
--

INSERT INTO `notification_template_langs` (`id`, `parent_id`, `lang`, `variables`, `content`, `created_at`, `updated_at`) VALUES
(1, 1, 'en', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"customer_name\": \"customer_name\"}', 'New order #{order_number} created for {customer_name} at {store_name} by {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(2, 1, 'es', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"customer_name\": \"customer_name\"}', 'Nueva orden #{order_number} creada para {customer_name} en {store_name} por {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(3, 1, 'ar', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"customer_name\": \"customer_name\"}', 'طلب جديد #{order_number} تم إنشاؤه لـ {customer_name} في {store_name} بواسطة {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(4, 1, 'da', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"customer_name\": \"customer_name\"}', 'Ny ordre #{order_number} oprettet for {customer_name} hos {store_name} af {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(5, 1, 'de', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"customer_name\": \"customer_name\"}', 'Neue Bestellung #{order_number} für {customer_name} bei {store_name} von {company_name} erstellt.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(6, 1, 'fr', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"customer_name\": \"customer_name\"}', 'Nouvelle commande #{order_number} créée pour {customer_name} chez {store_name} par {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(7, 1, 'he', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"customer_name\": \"customer_name\"}', 'הזמנה חדשה #{order_number} נוצרה עבור {customer_name} ב-{store_name} על ידי {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(8, 1, 'it', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"customer_name\": \"customer_name\"}', 'Nuovo ordine #{order_number} creato per {customer_name} presso {store_name} da {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(9, 1, 'ja', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"customer_name\": \"customer_name\"}', '新しい注文 #{order_number} が {customer_name} のために {store_name} で {company_name} によって作成されました。', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(10, 1, 'nl', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"customer_name\": \"customer_name\"}', 'Nieuwe bestelling #{order_number} aangemaakt voor {customer_name} bij {store_name} door {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(11, 1, 'pl', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"customer_name\": \"customer_name\"}', 'Nowe zamówienie #{order_number} utworzone dla {customer_name} w {store_name} przez {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(12, 1, 'pt', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"customer_name\": \"customer_name\"}', 'Novo pedido #{order_number} criado para {customer_name} em {store_name} por {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(13, 1, 'pt-BR', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"customer_name\": \"customer_name\"}', 'Novo pedido #{order_number} criado para {customer_name} em {store_name} por {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(14, 1, 'ru', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"customer_name\": \"customer_name\"}', 'Новый заказ #{order_number} создан для {customer_name} в {store_name} компанией {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(15, 1, 'tr', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"customer_name\": \"customer_name\"}', 'Yeni sipariş #{order_number}, {customer_name} için {store_name} mağazasında {company_name} tarafından oluşturuldu.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(16, 1, 'zh', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"customer_name\": \"customer_name\"}', '新订单 #{order_number} 已为 {customer_name} 在 {store_name} 由 {company_name} 创建。', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(17, 2, 'en', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"status\": \"status\"}', 'Order #{order_number} status updated to {status} at {store_name} by {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(18, 2, 'es', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"status\": \"status\"}', 'Estado de la orden #{order_number} actualizado a {status} en {store_name} por {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(19, 2, 'ar', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"status\": \"status\"}', 'تم تحديث حالة الطلب #{order_number} إلى {status} في {store_name} بواسطة {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(20, 2, 'da', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"status\": \"status\"}', 'Ordre #{order_number} status opdateret til {status} hos {store_name} af {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(21, 2, 'de', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"status\": \"status\"}', 'Bestellstatus #{order_number} auf {status} bei {store_name} von {company_name} aktualisiert.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(22, 2, 'fr', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"status\": \"status\"}', 'Statut de la commande #{order_number} mis à jour vers {status} chez {store_name} par {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(23, 2, 'he', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"status\": \"status\"}', 'סטטוס הזמנה #{order_number} עודכן ל-{status} ב-{store_name} על ידי {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(24, 2, 'it', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"status\": \"status\"}', 'Stato ordine #{order_number} aggiornato a {status} presso {store_name} da {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(25, 2, 'ja', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"status\": \"status\"}', '注文 #{order_number} のステータスが {store_name} で {company_name} によって {status} に更新されました。', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(26, 2, 'nl', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"status\": \"status\"}', 'Bestelstatus #{order_number} bijgewerkt naar {status} bij {store_name} door {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(27, 2, 'pl', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"status\": \"status\"}', 'Status zamówienia #{order_number} zaktualizowany do {status} w {store_name} przez {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(28, 2, 'pt', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"status\": \"status\"}', 'Status do pedido #{order_number} atualizado para {status} em {store_name} por {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(29, 2, 'pt-BR', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"status\": \"status\"}', 'Status do pedido #{order_number} atualizado para {status} em {store_name} por {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(30, 2, 'ru', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"status\": \"status\"}', 'Статус заказа #{order_number} обновлен на {status} в {store_name} компанией {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(31, 2, 'tr', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"status\": \"status\"}', 'Sipariş #{order_number} durumu {store_name} mağazasında {company_name} tarafından {status} olarak güncellendi.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(32, 2, 'zh', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"order_number\": \"order_number\", \"status\": \"status\"}', '订单 #{order_number} 状态已在 {store_name} 由 {company_name} 更新为 {status}。', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(33, 3, 'en', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"customer_name\": \"customer_name\"}', 'Welcome {customer_name}! You have successfully registered at {store_name} by {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(34, 3, 'es', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"customer_name\": \"customer_name\"}', '¡Bienvenido {customer_name}! Te has registrado exitosamente en {store_name} por {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(35, 3, 'ar', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"customer_name\": \"customer_name\"}', 'مرحباً {customer_name}! لقد تم تسجيلك بنجاح في {store_name} بواسطة {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(36, 3, 'da', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"customer_name\": \"customer_name\"}', 'Velkommen {customer_name}! Du har registreret dig hos {store_name} af {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(37, 3, 'de', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"customer_name\": \"customer_name\"}', 'Willkommen {customer_name}! Sie haben sich erfolgreich bei {store_name} von {company_name} registriert.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(38, 3, 'fr', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"customer_name\": \"customer_name\"}', 'Bienvenue {customer_name}! Vous vous êtes inscrit avec succès chez {store_name} par {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(39, 3, 'he', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"customer_name\": \"customer_name\"}', 'ברוכים הבאים {customer_name}! נרשמת בהצלחה ב-{store_name} על ידי {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(40, 3, 'it', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"customer_name\": \"customer_name\"}', 'Benvenuto {customer_name}! Ti sei registrato con successo presso {store_name} da {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(41, 3, 'ja', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"customer_name\": \"customer_name\"}', 'ようこそ {customer_name}! {company_name} の {store_name} に正常に登録されました。', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(42, 3, 'nl', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"customer_name\": \"customer_name\"}', 'Welkom {customer_name}! Je hebt je succesvol geregistreerd bij {store_name} door {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(43, 3, 'pl', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"customer_name\": \"customer_name\"}', 'Witamy {customer_name}! Pomyślnie zarejestrowaliś się w {store_name} przez {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(44, 3, 'pt', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"customer_name\": \"customer_name\"}', 'Bem-vindo {customer_name}! Você se registrou com sucesso em {store_name} por {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(45, 3, 'pt-BR', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"customer_name\": \"customer_name\"}', 'Bem-vindo {customer_name}! Você se registrou com sucesso em {store_name} por {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(46, 3, 'ru', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"customer_name\": \"customer_name\"}', 'Добро пожаловать {customer_name}! Вы успешно зарегистрировались в {store_name} компанией {company_name}.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(47, 3, 'tr', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"customer_name\": \"customer_name\"}', 'Hoş geldiniz {customer_name}! {company_name} tarafından {store_name} mağazasına başarıyla kayıt oldunuz.', '2026-02-16 17:02:42', '2026-02-16 17:02:42'),
(48, 3, 'zh', '{\"company_name\": \"company_name\", \"store_name\": \"store_name\", \"customer_name\": \"customer_name\"}', '欢迎 {customer_name}! 您已成功在 {company_name} 的 {store_name} 注册。', '2026-02-16 17:02:42', '2026-02-16 17:02:42');

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

--
-- 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,
  `product_name` varchar(255) NOT NULL,
  `product_sku` varchar(255) DEFAULT NULL,
  `product_price` decimal(10,2) NOT NULL,
  `quantity` int(11) NOT NULL,
  `product_variants` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`product_variants`)),
  `unit_price` decimal(10,2) NOT NULL,
  `total_price` decimal(10,2) NOT 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 `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 `payout_requests`
--

CREATE TABLE `payout_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `company_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending',
  `notes` text 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 `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `module` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `description` 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 `permissions`
--

INSERT INTO `permissions` (`id`, `module`, `name`, `guard_name`, `label`, `description`, `created_at`, `updated_at`) VALUES
(1, 'dashboard', 'manage-dashboard', 'web', 'Manage Dashboard', 'Can view dashboard', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(2, 'dashboard', 'export-dashboard', 'web', 'Export Dashboard', 'Can export dashboard data', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(3, 'users', 'manage-users', 'web', 'Manage Users', 'Can manage users', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(4, 'users', 'manage-any-users', 'web', 'Manage All Users', 'Manage Any Users', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(5, 'users', 'manage-own-users', 'web', 'Manage Own Users', 'Manage Limited Users that is created by own', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(6, 'users', 'view-users', 'web', 'Manage Users', 'View Users', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(7, 'users', 'create-users', 'web', 'Create Users', 'Can create users', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(8, 'users', 'edit-users', 'web', 'Edit Users', 'Can edit users', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(9, 'users', 'delete-users', 'web', 'Delete Users', 'Can delete users', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(10, 'users', 'reset-password-users', 'web', 'Reset Password Users', 'Can reset password users', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(11, 'users', 'toggle-status-users', 'web', 'Change Status Users', 'Can change status users', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(12, 'roles', 'manage-roles', 'web', 'Manage Roles', 'Can manage roles', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(13, 'roles', 'manage-any-roles', 'web', 'Manage All Roles', 'Manage Any Roles', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(14, 'roles', 'manage-own-roles', 'web', 'Manage Own Roles', 'Manage Limited Roles that is created by own', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(15, 'roles', 'view-roles', 'web', 'View Roles', 'View Roles', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(16, 'roles', 'create-roles', 'web', 'Create Roles', 'Can create roles', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(17, 'roles', 'edit-roles', 'web', 'Edit Roles', 'Can edit roles', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(18, 'roles', 'delete-roles', 'web', 'Delete Roles', 'Can delete roles', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(19, 'permissions', 'manage-permissions', 'web', 'Manage Permissions', 'Can manage permissions', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(20, 'permissions', 'manage-any-permissions', 'web', 'Manage All Permissions', 'Manage Any Permissions', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(21, 'permissions', 'manage-own-permissions', 'web', 'Manage Own Permissions', 'Manage Limited Permissions that is created by own', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(22, 'permissions', 'view-permissions', 'web', 'View Permissions', 'View Permissions', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(23, 'permissions', 'create-permissions', 'web', 'Create Permissions', 'Can create permissions', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(24, 'permissions', 'edit-permissions', 'web', 'Edit Permissions', 'Can edit permissions', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(25, 'permissions', 'delete-permissions', 'web', 'Delete Permissions', 'Can delete permissions', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(26, 'companies', 'manage-companies', 'web', 'Manage Companies', 'Can manage Companies', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(27, 'companies', 'manage-any-companies', 'web', 'Manage All Companies', 'Manage Any Companies', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(28, 'companies', 'manage-own-companies', 'web', 'Manage Own Companies', 'Manage Limited Companies that is created by own', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(29, 'companies', 'view-companies', 'web', 'View Companies', 'View Companies', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(30, 'companies', 'create-companies', 'web', 'Create Companies', 'Can create Companies', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(31, 'companies', 'edit-companies', 'web', 'Edit Companies', 'Can edit Companies', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(32, 'companies', 'delete-companies', 'web', 'Delete Companies', 'Can delete Companies', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(33, 'companies', 'reset-password-companies', 'web', 'Reset Password Companies', 'Can reset password Companies', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(34, 'companies', 'toggle-status-companies', 'web', 'Change Status Companies', 'Can change status companies', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(35, 'companies', 'manage-plans-companies', 'web', 'Manage Plan Companies', 'Can manage plans companies', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(36, 'companies', 'upgrade-plan-companies', 'web', 'Upgrade Plan Companies', 'Can upgrade plan of companies', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(37, 'plans', 'manage-plans', 'web', 'Manage Plans', 'Can manage subscription plans', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(38, 'plans', 'manage-any-plans', 'web', 'Manage All Plans', 'Manage Any Plans', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(39, 'plans', 'manage-own-plans', 'web', 'Manage Own Plans', 'Manage Limited Plans that is created by own', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(40, 'plans', 'view-plans', 'web', 'View Plans', 'View Plans', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(41, 'plans', 'create-plans', 'web', 'Create Plans', 'Can create subscription plans', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(42, 'plans', 'edit-plans', 'web', 'Edit Plans', 'Can edit subscription plans', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(43, 'plans', 'delete-plans', 'web', 'Delete Plans', 'Can delete subscription plans', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(44, 'plans', 'request-plans', 'web', 'Request Plans', 'Can request subscription plans', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(45, 'plans', 'trial-plans', 'web', 'Trial Plans', 'Can start trial for subscription plans', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(46, 'plans', 'subscribe-plans', 'web', 'Subscribe Plans', 'Can subscribe to subscription plans', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(47, 'coupons', 'manage-coupons', 'web', 'Manage Coupons', 'Can manage subscription Coupons', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(48, 'coupons', 'manage-any-coupons', 'web', 'Manage All Coupons', 'Manage Any Coupons', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(49, 'coupons', 'manage-own-coupons', 'web', 'Manage Own Coupons', 'Manage Limited Coupons that is created by own', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(50, 'coupons', 'view-coupons', 'web', 'View Coupons', 'View Coupons', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(51, 'coupons', 'create-coupons', 'web', 'Create Coupons', 'Can create subscription Coupons', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(52, 'coupons', 'edit-coupons', 'web', 'Edit Coupons', 'Can edit subscription Coupons', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(53, 'coupons', 'delete-coupons', 'web', 'Delete Coupons', 'Can delete subscription Coupons', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(54, 'coupons', 'toggle-status-coupons', 'web', 'Change Status Coupons', 'Can change status Coupons', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(55, 'plan_requests', 'manage-plan-requests', 'web', 'Manage Plan Requests', 'Can manage plan requests', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(56, 'plan_requests', 'view-plan-requests', 'web', 'View Plan Requests', 'View Plan Requests', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(57, 'plan_requests', 'edit-plan-requests', 'web', 'Edit Plan Requests', 'Can edit plan requests', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(58, 'plan_requests', 'delete-plan-requests', 'web', 'Delete Plan Requests', 'Can delete plan requests', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(59, 'plan_requests', 'approve-plan-requests', 'web', 'Approve plan requests', 'Can approve plan requests', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(60, 'plan_requests', 'reject-plan-requests', 'web', 'Reject plan requests', 'Can reject plplan requests', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(61, 'plan_orders', 'manage-plan-orders', 'web', 'Manage Plan Orders', 'Can manage plan orders', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(62, 'plan_orders', 'view-plan-orders', 'web', 'View Plan Orders', 'View Plan Orders', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(63, 'plan_orders', 'create-plan-orders', 'web', 'Create Plan Orders', 'Can create plan orders', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(64, 'plan_orders', 'edit-plan-orders', 'web', 'Edit Plan Orders', 'Can edit plan orders', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(65, 'plan_orders', 'delete-plan-orders', 'web', 'Delete Plan Orders', 'Can delete plan orders', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(66, 'plan_orders', 'approve-plan-orders', 'web', 'Approve Plan Orders', 'Can approve plan orders', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(67, 'plan_orders', 'reject-plan-orders', 'web', 'Reject Plan Orders', 'Can reject plan orders', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(68, 'settings', 'manage-settings', 'web', 'Manage Settings', 'Can manage All settings', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(69, 'settings', 'manage-system-settings', 'web', 'Manage System Settings', 'Can manage system settings', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(70, 'settings', 'manage-email-settings', 'web', 'Manage Email Settings', 'Can manage email settings', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(71, 'settings', 'manage-brand-settings', 'web', 'Manage Brand Settings', 'Can manage brand settings', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(72, 'settings', 'manage-company-settings', 'web', 'Manage Company Settings', 'Can manage Company settings', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(73, 'settings', 'manage-storage-settings', 'web', 'Manage Storage Settings', 'Can manage storage settings', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(74, 'settings', 'manage-payment-settings', 'web', 'Manage Payment Settings', 'Can manage payment settings', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(75, 'settings', 'manage-currency-settings', 'web', 'Manage Currency Settings', 'Can manage currency settings', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(76, 'settings', 'manage-recaptcha-settings', 'web', 'Manage ReCaptch Settings', 'Can manage recaptcha settings', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(77, 'settings', 'manage-chatgpt-settings', 'web', 'Manage ChatGpt Settings', 'Can manage chatgpt settings', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(78, 'settings', 'manage-cookie-settings', 'web', 'Manage Cookie(GDPR) Settings', 'Can manage cookie settings', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(79, 'settings', 'manage-seo-settings', 'web', 'Manage Seo Settings', 'Can manage seo settings', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(80, 'settings', 'manage-cache-settings', 'web', 'Manage Cache Settings', 'Can manage cache settings', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(81, 'settings', 'manage-account-settings', 'web', 'Manage Account Settings', 'Can manage account settings', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(82, 'businesses', 'manage-businesses', 'web', 'Manage Businesses', 'Can manage businesses', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(83, 'businesses', 'manage-any-businesses', 'web', 'Manage All businesses', 'Manage Any businesses', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(84, 'businesses', 'manage-own-businesses', 'web', 'Manage Own businesses', 'Manage Limited businesses that is created by own', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(85, 'businesses', 'view-businesses', 'web', 'View Businesses', 'View Businesses', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(86, 'businesses', 'create-businesses', 'web', 'Create Businesses', 'Can create businesses', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(87, 'businesses', 'edit-businesses', 'web', 'Edit Businesses', 'Can edit businesses', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(88, 'businesses', 'delete-businesses', 'web', 'Delete Businesses', 'Can delete businesses', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(89, 'currencies', 'manage-currencies', 'web', 'Manage Currencies', 'Can manage currencies', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(90, 'currencies', 'manage-any-currencies', 'web', 'Manage All currencies', 'Manage Any currencies', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(91, 'currencies', 'manage-own-currencies', 'web', 'Manage Own currencies', 'Manage Limited currencies that is created by own', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(92, 'currencies', 'view-currencies', 'web', 'View Currencies', 'View Currencies', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(93, 'currencies', 'create-currencies', 'web', 'Create Currencies', 'Can create currencies', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(94, 'currencies', 'edit-currencies', 'web', 'Edit Currencies', 'Can edit currencies', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(95, 'currencies', 'delete-currencies', 'web', 'Delete Currencies', 'Can delete currencies', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(96, 'referral', 'manage-referral', 'web', 'Manage Referral', 'Can manage referral program', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(97, 'referral', 'manage-setting-referral', 'web', 'Manage Referral Setting', 'Can manage Referral Setting', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(98, 'referral', 'manage-payout-referral', 'web', 'Manage Referral Payout', 'Can manage Referral Payout program', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(99, 'referral', 'approve-payout-referral', 'web', 'Approve Referral Payout', 'Can approve payout request', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(100, 'referral', 'reject-payout-referral', 'web', 'Reject Referral Payout', 'Can reject payout request', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(101, 'language', 'manage-language', 'web', 'Manage Language', 'Can manage language', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(102, 'language', 'edit-language', 'web', 'Edit Language', 'Edit Language', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(103, 'language', 'view-language', 'web', 'View Language', 'View Language', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(104, 'media', 'manage-media', 'web', 'Manage Media', 'Can manage media', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(105, 'media', 'manage-any-media', 'web', 'Manage All Media', 'Manage Any media', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(106, 'media', 'manage-own-media', 'web', 'Manage Own Media', 'Manage Limited media that is created by own', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(107, 'media', 'create-media', 'web', 'Create media', 'Create media', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(108, 'media', 'edit-media', 'web', 'Edit media', 'Edit media', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(109, 'media', 'delete-media', 'web', 'Delete media', 'Delete media', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(110, 'media', 'view-media', 'web', 'View media', 'View media', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(111, 'media', 'download-media', 'web', 'Download media', 'Download media', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(112, 'settings', 'manage-webhook-settings', 'web', 'Manage Webhook Settings', 'Can manage webhook settings', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(113, 'landing_page', 'manage-landing-page', 'web', 'Manage Landing Page', 'Can manage landing page', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(114, 'landing_page', 'view-landing-page', 'web', 'View Landing Page', 'View landing page', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(115, 'landing_page', 'edit-landing-page', 'web', 'Edit Landing Page', 'Edit landing page', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(116, 'stores', 'manage-stores', 'web', 'Manage Stores', 'Can manage stores', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(117, 'stores', 'view-stores', 'web', 'View Stores', 'View stores', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(118, 'stores', 'create-stores', 'web', 'Create Stores', 'Can create stores', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(119, 'stores', 'edit-stores', 'web', 'Edit Stores', 'Can edit stores', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(120, 'stores', 'delete-stores', 'web', 'Delete Stores', 'Can delete stores', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(121, 'stores', 'export-stores', 'web', 'Export Stores', 'Can export stores data', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(122, 'stores', 'manage-store-content', 'web', 'Manage Store Content', 'Can manage store content', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(123, 'stores', 'view-store-content', 'web', 'View Store Content', 'Can view store content', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(124, 'stores', 'edit-store-content', 'web', 'Edit Store Content', 'Can edit store content', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(125, 'stores', 'manage-store-settings', 'web', 'Manage Store Settings', 'Can manage store settings', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(126, 'stores', 'switch-stores', 'web', 'Switch Stores', 'Can switch between stores', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(127, 'products', 'manage-products', 'web', 'Manage Products', 'Can manage products', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(128, 'products', 'view-products', 'web', 'View Products', 'View products', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(129, 'products', 'create-products', 'web', 'Create Products', 'Can create products', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(130, 'products', 'edit-products', 'web', 'Edit Products', 'Can edit products', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(131, 'products', 'delete-products', 'web', 'Delete Products', 'Can delete products', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(132, 'products', 'export-products', 'web', 'Export Products', 'Can export products data', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(133, 'categories', 'manage-categories', 'web', 'Manage Categories', 'Can manage categories', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(134, 'categories', 'view-categories', 'web', 'View Categories', 'View categories', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(135, 'categories', 'create-categories', 'web', 'Create Categories', 'Can create categories', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(136, 'categories', 'edit-categories', 'web', 'Edit Categories', 'Can edit categories', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(137, 'categories', 'delete-categories', 'web', 'Delete Categories', 'Can delete categories', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(138, 'categories', 'export-categories', 'web', 'Export Categories', 'Can export categories data', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(139, 'tax', 'manage-tax', 'web', 'Manage Tax', 'Can manage tax rules', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(140, 'tax', 'view-tax', 'web', 'View Tax', 'View tax rules', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(141, 'tax', 'create-tax', 'web', 'Create Tax', 'Can create tax rules', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(142, 'tax', 'edit-tax', 'web', 'Edit Tax', 'Can edit tax rules', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(143, 'tax', 'delete-tax', 'web', 'Delete Tax', 'Can delete tax rules', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(144, 'tax', 'export-tax', 'web', 'Export Tax', 'Can export tax rules data', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(145, 'orders', 'manage-orders', 'web', 'Manage Orders', 'Can manage orders', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(146, 'orders', 'view-orders', 'web', 'View Orders', 'View orders', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(147, 'orders', 'edit-orders', 'web', 'Edit Orders', 'Can edit orders', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(148, 'orders', 'delete-orders', 'web', 'Delete Orders', 'Can delete orders', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(149, 'orders', 'export-orders', 'web', 'Export Orders', 'Can export orders data', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(150, 'customers', 'manage-customers', 'web', 'Manage Customers', 'Can manage customers', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(151, 'customers', 'view-customers', 'web', 'View Customers', 'View customers', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(152, 'customers', 'create-customers', 'web', 'Create Customers', 'Can create customers', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(153, 'customers', 'edit-customers', 'web', 'Edit Customers', 'Can edit customers', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(154, 'customers', 'delete-customers', 'web', 'Delete Customers', 'Can delete customers', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(155, 'customers', 'export-customers', 'web', 'Export Customers', 'Can export customers data', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(156, 'coupon_system', 'manage-coupon-system', 'web', 'Manage Coupon System', 'Can manage store coupons', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(157, 'coupon_system', 'view-coupon-system', 'web', 'View Coupon System', 'View store coupons', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(158, 'coupon_system', 'create-coupon-system', 'web', 'Create Coupon System', 'Can create store coupons', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(159, 'coupon_system', 'edit-coupon-system', 'web', 'Edit Coupon System', 'Can edit store coupons', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(160, 'coupon_system', 'delete-coupon-system', 'web', 'Delete Coupon System', 'Can delete store coupons', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(161, 'coupon_system', 'toggle-status-coupon-system', 'web', 'Toggle Status Coupon System', 'Can toggle store coupon status', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(162, 'coupon_system', 'export-coupon-system', 'web', 'Export Coupon System', 'Can export store coupons data', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(163, 'shipping', 'manage-shipping', 'web', 'Manage Shipping', 'Can manage shipping methods', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(164, 'shipping', 'view-shipping', 'web', 'View Shipping', 'View shipping methods', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(165, 'shipping', 'create-shipping', 'web', 'Create Shipping', 'Can create shipping methods', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(166, 'shipping', 'edit-shipping', 'web', 'Edit Shipping', 'Can edit shipping methods', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(167, 'shipping', 'delete-shipping', 'web', 'Delete Shipping', 'Can delete shipping methods', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(168, 'shipping', 'export-shipping', 'web', 'Export Shipping', 'Can export shipping methods data', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(169, 'blog', 'manage-blog', 'web', 'Manage Blog', 'Can manage blog posts', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(170, 'blog', 'view-blog', 'web', 'View Blog', 'View blog posts', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(171, 'blog', 'create-blog', 'web', 'Create Blog', 'Can create blog posts', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(172, 'blog', 'edit-blog', 'web', 'Edit Blog', 'Can edit blog posts', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(173, 'blog', 'delete-blog', 'web', 'Delete Blog', 'Can delete blog posts', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(174, 'pos', 'manage-pos', 'web', 'Manage POS', 'Can manage POS system', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(175, 'pos', 'view-pos', 'web', 'View POS', 'View POS interface', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(176, 'pos', 'process-transactions-pos', 'web', 'Process Transactions', 'Can process POS transactions', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(177, 'pos', 'view-transactions-pos', 'web', 'View Transactions', 'View POS transactions', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(178, 'pos', 'manage-settings-pos', 'web', 'Manage POS Settings', 'Can manage POS settings', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(179, 'reviews', 'manage-reviews', 'web', 'Manage Reviews', 'Can manage product reviews', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(180, 'reviews', 'view-reviews', 'web', 'View Reviews', 'View product reviews', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(181, 'reviews', 'edit-reviews', 'web', 'Edit Reviews', 'Can edit product reviews', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(182, 'reviews', 'delete-reviews', 'web', 'Delete Reviews', 'Can delete product reviews', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(183, 'reviews', 'approve-reviews', 'web', 'Approve Reviews', 'Can approve product reviews', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(184, 'newsletter_subscribers', 'manage-newsletter-subscribers', 'web', 'Manage Newsletter Subscribers', 'Can manage newsletter subscribers', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(185, 'newsletter_subscribers', 'view-newsletter-subscribers', 'web', 'View Newsletter Subscribers', 'View newsletter subscribers', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(186, 'newsletter_subscribers', 'delete-newsletter-subscribers', 'web', 'Delete Newsletter Subscribers', 'Can delete newsletter subscribers', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(187, 'custom_pages', 'manage-custom-pages', 'web', 'Manage Custom Pages', 'Can manage custom pages', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(188, 'custom_pages', 'view-custom-pages', 'web', 'View Custom Pages', 'View custom pages', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(189, 'custom_pages', 'create-custom-pages', 'web', 'Create Custom Pages', 'Can create custom pages', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(190, 'custom_pages', 'edit-custom-pages', 'web', 'Edit Custom Pages', 'Can edit custom pages', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(191, 'custom_pages', 'delete-custom-pages', 'web', 'Delete Custom Pages', 'Can delete custom pages', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(192, 'express_checkout', 'manage-express-checkout', 'web', 'Manage Express Checkout', 'Overall express checkout management access', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(193, 'express_checkout', 'view-express-checkout', 'web', 'View Express Checkout', 'View express checkout list and details', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(194, 'express_checkout', 'create-express-checkout', 'web', 'Create Express Checkout', 'Create new express checkout configurations', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(195, 'express_checkout', 'edit-express-checkout', 'web', 'Edit Express Checkout', 'Edit existing express checkout configurations', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(196, 'express_checkout', 'delete-express-checkout', 'web', 'Delete Express Checkout', 'Delete express checkout configurations', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(197, 'analytics', 'manage-analytics', 'web', 'Manage Analytics', 'Overall analytics and reporting management access', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(198, 'analytics', 'view-analytics', 'web', 'View Analytics', 'View analytics dashboard and reports', '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(199, 'analytics', 'export-analytics', 'web', 'Export Analytics', 'Export analytics data and reports', '2026-01-01 10:54:31', '2026-01-01 10:54:31');

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

--
-- Table structure for table `plans`
--

CREATE TABLE `plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `price` double NOT NULL DEFAULT 0,
  `yearly_price` double DEFAULT NULL,
  `duration` varchar(100) NOT NULL,
  `themes` text DEFAULT NULL,
  `max_stores` int(11) NOT NULL DEFAULT 0,
  `max_users_per_store` int(11) NOT NULL DEFAULT 0,
  `max_products_per_store` int(11) NOT NULL DEFAULT 0,
  `description` text DEFAULT NULL,
  `enable_custdomain` varchar(255) NOT NULL DEFAULT 'off',
  `enable_custsubdomain` varchar(255) NOT NULL DEFAULT 'off',
  `enable_branding` varchar(255) NOT NULL DEFAULT 'on',
  `pwa_business` varchar(255) NOT NULL DEFAULT 'off',
  `enable_chatgpt` varchar(255) NOT NULL DEFAULT 'on',
  `enable_custom_pages` varchar(255) NOT NULL DEFAULT 'off',
  `enable_blog` varchar(255) NOT NULL DEFAULT 'off',
  `enable_shipping_method` varchar(255) NOT NULL DEFAULT 'off',
  `storage_limit` float NOT NULL DEFAULT 0,
  `is_trial` varchar(255) DEFAULT NULL,
  `trial_day` int(11) NOT NULL DEFAULT 0,
  `is_plan_enable` varchar(255) NOT NULL DEFAULT 'on',
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `module` 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 `plans`
--

INSERT INTO `plans` (`id`, `name`, `price`, `yearly_price`, `duration`, `themes`, `max_stores`, `max_users_per_store`, `max_products_per_store`, `description`, `enable_custdomain`, `enable_custsubdomain`, `enable_branding`, `pwa_business`, `enable_chatgpt`, `enable_custom_pages`, `enable_blog`, `enable_shipping_method`, `storage_limit`, `is_trial`, `trial_day`, `is_plan_enable`, `is_default`, `module`, `created_at`, `updated_at`) VALUES
(1, 'Free', 0, 0, 'monthly', '[\"home-accessories\",\"beauty-cosmetics\",\"furniture-interior\",\"perfume-fragrances\",\"fashion\",\"jewelry\",\"cars-automotive\",\"electronics\",\"watches\",\"baby-kids\"]', 5, 25, 100, 'Basic plan for small businesses just getting started.', 'on', 'on', 'on', 'on', 'on', 'on', 'on', 'on', 5, NULL, 0, 'on', 1, NULL, '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(2, 'Pro', 49.99, 479.9, 'monthly', '[\"home-accessories\",\"beauty-cosmetics\",\"furniture-interior\",\"fashion\",\"jewelry\",\"electronics\",\"watches\",\"baby-kids\",\"perfume-fragrances\"]', 50, 100, 5000, 'Ideal for growing businesses with multiple stores and advanced needs.', 'on', 'on', 'off', 'on', 'on', 'on', 'on', 'on', 100, 'on', 14, 'on', 0, NULL, '2026-01-01 10:54:31', '2026-02-16 10:35:56'),
(3, 'Enterprise', 99.99, 959.9, 'monthly', '[\"home-accessories\",\"beauty-cosmetics\",\"furniture-interior\",\"perfume-fragrances\",\"fashion\",\"jewelry\",\"cars-automotive\",\"electronics\",\"watches\",\"baby-kids\"]', 200, 500, 10000, 'Complete solution for large businesses with unlimited resources and premium support.', 'on', 'on', 'on', 'on', 'on', 'on', 'on', 'on', 1000, 'on', 30, 'on', 0, NULL, '2026-01-01 10:54:31', '2026-01-01 10:54:31');

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

--
-- Table structure for table `plan_orders`
--

CREATE TABLE `plan_orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `plan_id` bigint(20) UNSIGNED NOT NULL,
  `coupon_id` bigint(20) UNSIGNED DEFAULT NULL,
  `billing_cycle` varchar(255) DEFAULT NULL,
  `order_number` varchar(255) NOT NULL,
  `original_price` decimal(10,2) NOT NULL,
  `discount_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `final_price` decimal(10,2) NOT NULL,
  `coupon_code` varchar(255) DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `payment_id` text DEFAULT NULL,
  `status` enum('pending','approved','rejected','cancelled') NOT NULL DEFAULT 'pending',
  `ordered_at` timestamp NOT NULL,
  `processed_at` timestamp NULL DEFAULT NULL,
  `processed_by` bigint(20) UNSIGNED DEFAULT NULL,
  `notes` text 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 `plan_requests`
--

CREATE TABLE `plan_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `plan_id` bigint(20) UNSIGNED NOT NULL,
  `duration` varchar(255) NOT NULL DEFAULT 'monthly',
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `message` text DEFAULT NULL,
  `approved_at` timestamp NULL DEFAULT NULL,
  `rejected_at` timestamp NULL DEFAULT NULL,
  `approved_by` bigint(20) UNSIGNED DEFAULT NULL,
  `rejected_by` bigint(20) UNSIGNED 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 `pos_payments`
--

CREATE TABLE `pos_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `transaction_id` bigint(20) UNSIGNED NOT NULL,
  `payment_method` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `change_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `reference_number` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'completed',
  `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 `pos_settings`
--

CREATE TABLE `pos_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `store_id` bigint(20) UNSIGNED NOT NULL,
  `currency` varchar(255) NOT NULL DEFAULT 'usd',
  `tax_rate` decimal(5,2) NOT NULL DEFAULT 10.00,
  `default_discount` decimal(5,2) NOT NULL DEFAULT 0.00,
  `enable_guest_checkout` tinyint(1) NOT NULL DEFAULT 1,
  `low_stock_alerts` tinyint(1) NOT NULL DEFAULT 1,
  `auto_sync_online_orders` tinyint(1) NOT NULL DEFAULT 0,
  `receipt_header` text DEFAULT NULL,
  `receipt_footer` text DEFAULT NULL,
  `show_logo_on_receipt` tinyint(1) NOT NULL DEFAULT 1,
  `show_tax_details` tinyint(1) NOT NULL DEFAULT 1,
  `show_cashier_name` tinyint(1) NOT NULL DEFAULT 1,
  `email_receipt` tinyint(1) NOT NULL DEFAULT 1,
  `receipt_printer` varchar(255) NOT NULL DEFAULT 'thermal',
  `barcode_scanner` varchar(255) NOT NULL DEFAULT 'usb',
  `cash_drawer` varchar(255) NOT NULL DEFAULT 'manual',
  `card_reader` varchar(255) NOT NULL DEFAULT 'integrated',
  `auto_open_cash_drawer` tinyint(1) NOT NULL DEFAULT 1,
  `auto_print_receipt` 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 `pos_settings`
--

INSERT INTO `pos_settings` (`id`, `store_id`, `currency`, `tax_rate`, `default_discount`, `enable_guest_checkout`, `low_stock_alerts`, `auto_sync_online_orders`, `receipt_header`, `receipt_footer`, `show_logo_on_receipt`, `show_tax_details`, `show_cashier_name`, `email_receipt`, `receipt_printer`, `barcode_scanner`, `cash_drawer`, `card_reader`, `auto_open_cash_drawer`, `auto_print_receipt`, `created_at`, `updated_at`) VALUES
(1, 2, 'USD', 10.00, 0.00, 1, 1, 0, 'Thank you for shopping with us!', 'All sales are final. Returns accepted within 30 days with receipt.', 1, 1, 1, 1, 'thermal', 'usb', 'manual', 'integrated', 1, 1, '2026-01-01 11:04:32', '2026-01-01 11:04:32'),
(2, 3, 'USD', 10.00, 0.00, 1, 1, 0, 'Thank you for shopping with us!', 'All sales are final. Returns accepted within 30 days with receipt.', 1, 1, 1, 1, 'thermal', 'usb', 'manual', 'integrated', 1, 1, '2026-01-01 12:53:22', '2026-01-01 12:53:22');

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

--
-- Table structure for table `pos_transactions`
--

CREATE TABLE `pos_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `store_id` bigint(20) UNSIGNED NOT NULL,
  `transaction_number` varchar(255) NOT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `cashier_id` bigint(20) UNSIGNED NOT NULL,
  `subtotal` decimal(10,2) NOT NULL DEFAULT 0.00,
  `tax` 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,
  `status` varchar(255) NOT NULL DEFAULT 'completed',
  `notes` text 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 `pos_transaction_items`
--

CREATE TABLE `pos_transaction_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `transaction_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `variant_name` varchar(255) DEFAULT NULL,
  `quantity` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `tax` decimal(10,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `total` decimal(10,2) NOT 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 `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `sku` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `specifications` text DEFAULT NULL,
  `details` text DEFAULT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `sale_price` decimal(10,2) DEFAULT NULL,
  `stock` int(11) NOT NULL DEFAULT 0,
  `cover_image` varchar(255) DEFAULT NULL,
  `images` text DEFAULT NULL,
  `variants` text DEFAULT NULL,
  `custom_fields` text DEFAULT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `tax_id` bigint(20) UNSIGNED DEFAULT NULL,
  `store_id` bigint(20) UNSIGNED NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `is_downloadable` tinyint(1) NOT NULL DEFAULT 0,
  `downloadable_file` 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 `products`
--

INSERT INTO `products` (`id`, `name`, `sku`, `description`, `specifications`, `details`, `price`, `sale_price`, `stock`, `cover_image`, `images`, `variants`, `custom_fields`, `category_id`, `tax_id`, `store_id`, `is_active`, `is_downloadable`, `downloadable_file`, `created_at`, `updated_at`) VALUES
(1, 'Bathroom Accessories', 'S1C1P2471', 'High quality Bathroom Accessories for your needs', 'Material: Premium quality materials\nDimensions: Standard size with optimal proportions\nWeight: Lightweight and portable design\nColor: Available in multiple attractive colors', 'This Bathroom Accessories is crafted with attention to detail and quality. Perfect for everyday use with durable construction. Features modern design that complements any style.', 151.99, 96.99, 65, '/storage/media/70/bathroom-accessories1.png', '/storage/media/69/bathroom-accessories2.png,/storage/media/68/bathroom-accessories3.png,/storage/media/67/bathroom-accessories4.png,/storage/media/66/bathroom-accessories5.png', NULL, NULL, 1, 1, 1, 1, 0, NULL, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(2, 'Beds', 'S1C2P6303', 'High quality Beds for your needs', 'Material: Premium quality materials\nDimensions: Standard size with optimal proportions\nWeight: Lightweight and portable design\nColor: Available in multiple attractive colors\nBrand: Trusted brand with quality assurance', 'This Beds is crafted with attention to detail and quality. Perfect for everyday use with durable construction. Features modern design that complements any style. Easy to use with user-friendly functionality. Suitable for all age groups and preferences.', 99.99, 79.99, 93, '/storage/media/105/beds1.png', '/storage/media/104/beds2.png,/storage/media/103/beds3.png,/storage/media/102/beds4.png,/storage/media/101/beds5.png', NULL, NULL, 2, 1, 1, 1, 0, NULL, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(3, 'Cookware Bakeware', 'S1C3P9995', 'High quality Cookware Bakeware for your needs', 'Material: Premium quality materials\nDimensions: Standard size with optimal proportions\nWeight: Lightweight and portable design\nColor: Available in multiple attractive colors', 'This Cookware Bakeware is crafted with attention to detail and quality. Perfect for everyday use with durable construction. Features modern design that complements any style. Easy to use with user-friendly functionality. Suitable for all age groups and preferences.', 147.99, NULL, 67, '/storage/media/80/cookware-bakeware1.png', '/storage/media/79/cookware-bakeware2.png,/storage/media/78/cookware-bakeware3.png,/storage/media/77/cookware-bakeware4.png,/storage/media/76/cookware-bakeware5.png', NULL, NULL, 3, 1, 1, 1, 0, NULL, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(4, 'Ceiling Lights', 'S1C4P1718', 'High quality Ceiling Lights for your needs', 'Material: Premium quality materials\nDimensions: Standard size with optimal proportions\nWeight: Lightweight and portable design\nColor: Available in multiple attractive colors\nBrand: Trusted brand with quality assurance\nWarranty: 1 year manufacturer warranty included', 'This Ceiling Lights is crafted with attention to detail and quality. Perfect for everyday use with durable construction. Features modern design that complements any style.', 50.99, NULL, 3, '/storage/media/55/ceiling-lights1.png', '/storage/media/54/ceiling-lights2.png,/storage/media/53/ceiling-lights3.png,/storage/media/52/ceiling-lights4.png,/storage/media/51/ceiling-lights5.png', NULL, NULL, 4, 1, 1, 1, 0, NULL, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(5, 'Birdhouse', 'S1C5P9986', 'High quality Birdhouse for your needs', 'Material: Premium quality materials\nDimensions: Standard size with optimal proportions\nWeight: Lightweight and portable design\nColor: Available in multiple attractive colors', 'This Birdhouse is crafted with attention to detail and quality. Perfect for everyday use with durable construction. Features modern design that complements any style. Easy to use with user-friendly functionality.', 204.99, NULL, 88, '/storage/media/30/birdhouse1.png', '/storage/media/29/birdhouse2.png,/storage/media/28/birdhouse3.png,/storage/media/27/birdhouse4.png,/storage/media/26/birdhouse5.png', NULL, NULL, 5, 1, 1, 1, 0, NULL, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(7, 'tst', '121', NULL, NULL, NULL, 12.00, NULL, 100, '/storage/media/19/Armani-Amal-Terrace-Night-View-scaled-1.jpg', NULL, '[]', '[]', 8, NULL, 3, 1, 0, NULL, '2026-01-21 09:40:45', '2026-01-21 09:49:40'),
(8, 'Cotton All Over - CB-01', 'CB-01', '<p><strong>Chawla Fabrics brings you premium quality men’s unstitched shalwar kameez fabrics, crafted for comfort, elegance, and durability. Perfect for every occasion, our collection reflects timeless style with superior finishing.</strong></p><p><strong><br></strong></p>', '<ul><li><p><strong>Brand: Chawla Fabrics</strong></p></li><li><p><strong>Product: CB-01 Cotton All Over</strong></p></li><li><p><strong>Material: Premium-quality cotton fabric</strong></p></li><li><p><strong>Design: All-over pattern with a consistent weave</strong></p></li><li><p><strong>Features: Breathable, soft, and durable for repeated washing</strong></p></li><li><p><strong>Uses: Ideal for casual wear, dresses, and home textiles</strong></p></li><li><p><strong>Benefit: Reliable quality with aesthetic appeal and everyday comfort</strong></p></li><li><p><strong>Availability: Standard widths for easy production integration</strong></p></li></ul>', '<h6><strong>Delivery:</strong></h6><p><span><strong>Estimated delivery time: 5-7 days</strong></span></p><h6><strong>Exchange:</strong></h6><p><span><strong>Within 7 days of purchase</strong></span></p>', 6750.00, 6750.00, 10, '/storage/media/72/40.webp', '/storage/media/72/40.webp,/storage/media/69/2_2cafa97c-628a-45ca-a3b9-ec33a1c7b05a.webp,/storage/media/71/41_3019346f-ce14-4df5-bc97-a8fa52007af2.webp,/storage/media/70/1_f947ca7f-7f37-4631-8da4-6c4d03851099.webp', '[]', '[]', 13, NULL, 2, 1, 0, NULL, '2026-02-18 21:03:54', '2026-02-18 21:15:44'),
(9, 'Cotton All Over - CB-02', 'CB-02', '<p><strong>Chawla Fabrics brings you premium quality men’s unstitched shalwar kameez fabrics, crafted for comfort, elegance, and durability. Perfect for every occasion, our collection reflects timeless style with superior finishing.</strong></p><p><br></p>', '<ul><li><p><strong>Brand: Chawla Fabrics</strong></p></li><li><p><strong>Product: CB-02 Cotton All Over</strong></p></li><li><p><strong>Material: Premium-quality cotton fabric</strong></p></li><li><p><strong>Design: All-over pattern with a consistent weave</strong></p></li><li><p><strong>Features: Breathable, soft, and durable for repeated washing</strong></p></li><li><p><strong>Uses: Ideal for casual wear, dresses, and home textiles</strong></p></li><li><p><strong>Benefit: Reliable quality with aesthetic appeal and everyday comfort</strong></p></li><li><p><strong>Availability: Standard widths for easy production integration</strong></p></li></ul>', '<h6><strong>Delivery:</strong></h6><p><span><strong>Estimated delivery time: 5-7 days</strong></span></p><h6><strong>Exchange:</strong></h6><p><span><strong>Within 7 days of purchase</strong></span></p>', 6750.00, 6750.00, 10, '/storage/media/73/22_8bedb162-962a-40a4-adf6-56d56aedd735.webp', '/storage/media/74/17_c92d2ef9-1ff7-41f2-9697-d0f2caf3a529.webp,/storage/media/75/19_ec8c774e-0cc4-4697-96e8-ce161ea0de88.webp,/storage/media/76/20_7e69b972-1218-40cb-bf26-314e4916f862.webp', '[]', '[]', 13, 5, 2, 1, 0, NULL, '2026-02-18 21:26:15', '2026-02-18 21:26:52');

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

--
-- Table structure for table `product_reviews`
--

CREATE TABLE `product_reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL,
  `store_id` bigint(20) UNSIGNED NOT NULL,
  `rating` int(10) UNSIGNED NOT NULL COMMENT '1-5 star rating',
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `is_approved` tinyint(1) NOT NULL DEFAULT 1,
  `store_response` text 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 `referrals`
--

CREATE TABLE `referrals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `company_id` bigint(20) UNSIGNED NOT NULL,
  `commission_percentage` decimal(5,2) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `plan_id` bigint(20) UNSIGNED 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 `referral_settings`
--

CREATE TABLE `referral_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `is_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `commission_percentage` decimal(5,2) NOT NULL DEFAULT 10.00,
  `threshold_amount` decimal(10,2) NOT NULL DEFAULT 50.00,
  `guidelines` 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 `referral_settings`
--

INSERT INTO `referral_settings` (`id`, `is_enabled`, `commission_percentage`, `threshold_amount`, `guidelines`, `created_at`, `updated_at`) VALUES
(1, 1, 10.00, 50.00, 'Welcome to our referral program! Earn commission when users sign up using your referral link and purchase a plan. Commission is calculated based on the plan price and will be available for payout once you reach the minimum threshold.', '2026-01-01 10:54:32', '2026-01-01 10:54:32');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED 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 `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `label`, `description`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 'superadmin', 'web', 'Super Admin', 'Super Admin has full access to all features', NULL, '2026-01-01 10:54:31', '2026-01-01 10:54:31'),
(2, 'company', 'web', 'Company', 'Company has access to manage buissness', NULL, '2026-01-01 10:54:31', '2026-01-01 10:54:31');

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

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(29, 1),
(30, 1),
(31, 1),
(32, 1),
(33, 1),
(34, 1),
(35, 1),
(36, 1),
(37, 1),
(38, 1),
(39, 1),
(40, 1),
(41, 1),
(42, 1),
(43, 1),
(44, 1),
(45, 1),
(46, 1),
(47, 1),
(48, 1),
(49, 1),
(50, 1),
(51, 1),
(52, 1),
(53, 1),
(54, 1),
(55, 1),
(56, 1),
(57, 1),
(58, 1),
(59, 1),
(60, 1),
(61, 1),
(62, 1),
(63, 1),
(64, 1),
(65, 1),
(66, 1),
(67, 1),
(68, 1),
(69, 1),
(70, 1),
(71, 1),
(72, 1),
(73, 1),
(74, 1),
(75, 1),
(76, 1),
(77, 1),
(78, 1),
(79, 1),
(80, 1),
(81, 1),
(82, 1),
(83, 1),
(84, 1),
(85, 1),
(86, 1),
(87, 1),
(88, 1),
(89, 1),
(90, 1),
(91, 1),
(92, 1),
(93, 1),
(94, 1),
(95, 1),
(96, 1),
(97, 1),
(98, 1),
(99, 1),
(100, 1),
(101, 1),
(102, 1),
(103, 1),
(104, 1),
(105, 1),
(106, 1),
(107, 1),
(108, 1),
(109, 1),
(110, 1),
(111, 1),
(112, 1),
(113, 1),
(114, 1),
(115, 1),
(116, 1),
(117, 1),
(118, 1),
(119, 1),
(120, 1),
(121, 1),
(122, 1),
(123, 1),
(124, 1),
(125, 1),
(126, 1),
(127, 1),
(128, 1),
(129, 1),
(130, 1),
(131, 1),
(132, 1),
(133, 1),
(134, 1),
(135, 1),
(136, 1),
(137, 1),
(138, 1),
(139, 1),
(140, 1),
(141, 1),
(142, 1),
(143, 1),
(144, 1),
(145, 1),
(146, 1),
(147, 1),
(148, 1),
(149, 1),
(150, 1),
(151, 1),
(152, 1),
(153, 1),
(154, 1),
(155, 1),
(156, 1),
(157, 1),
(158, 1),
(159, 1),
(160, 1),
(161, 1),
(162, 1),
(163, 1),
(164, 1),
(165, 1),
(166, 1),
(167, 1),
(168, 1),
(169, 1),
(170, 1),
(171, 1),
(172, 1),
(173, 1),
(174, 1),
(175, 1),
(176, 1),
(177, 1),
(178, 1),
(179, 1),
(180, 1),
(181, 1),
(182, 1),
(183, 1),
(184, 1),
(185, 1),
(186, 1),
(187, 1),
(188, 1),
(189, 1),
(190, 1),
(191, 1),
(192, 1),
(193, 1),
(194, 1),
(195, 1),
(196, 1),
(197, 1),
(198, 1),
(199, 1),
(1, 2),
(2, 2),
(3, 2),
(6, 2),
(7, 2),
(8, 2),
(9, 2),
(10, 2),
(11, 2),
(12, 2),
(15, 2),
(16, 2),
(17, 2),
(18, 2),
(40, 2),
(44, 2),
(45, 2),
(46, 2),
(55, 2),
(56, 2),
(61, 2),
(62, 2),
(68, 2),
(69, 2),
(70, 2),
(71, 2),
(74, 2),
(96, 2),
(97, 2),
(98, 2),
(99, 2),
(100, 2),
(101, 2),
(102, 2),
(103, 2),
(104, 2),
(106, 2),
(107, 2),
(108, 2),
(109, 2),
(110, 2),
(111, 2),
(112, 2),
(116, 2),
(117, 2),
(118, 2),
(119, 2),
(120, 2),
(121, 2),
(122, 2),
(123, 2),
(124, 2),
(125, 2),
(126, 2),
(127, 2),
(128, 2),
(129, 2),
(130, 2),
(131, 2),
(132, 2),
(133, 2),
(134, 2),
(135, 2),
(136, 2),
(137, 2),
(138, 2),
(139, 2),
(140, 2),
(141, 2),
(142, 2),
(143, 2),
(144, 2),
(145, 2),
(146, 2),
(147, 2),
(148, 2),
(149, 2),
(150, 2),
(151, 2),
(152, 2),
(153, 2),
(154, 2),
(155, 2),
(156, 2),
(157, 2),
(158, 2),
(159, 2),
(160, 2),
(161, 2),
(162, 2),
(163, 2),
(164, 2),
(165, 2),
(166, 2),
(167, 2),
(168, 2),
(169, 2),
(170, 2),
(171, 2),
(172, 2),
(173, 2),
(174, 2),
(175, 2),
(176, 2),
(177, 2),
(178, 2),
(179, 2),
(180, 2),
(181, 2),
(182, 2),
(183, 2),
(184, 2),
(185, 2),
(186, 2),
(187, 2),
(188, 2),
(189, 2),
(190, 2),
(191, 2),
(192, 2),
(193, 2),
(194, 2),
(195, 2),
(196, 2),
(197, 2),
(198, 2),
(199, 2);

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

--
-- 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;

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

--
-- Table structure for table `shippings`
--

CREATE TABLE `shippings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `store_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `cost` decimal(10,2) NOT NULL DEFAULT 0.00,
  `min_order_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `delivery_time` varchar(255) DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `zone_type` varchar(255) DEFAULT NULL,
  `countries` text DEFAULT NULL,
  `postal_codes` varchar(255) DEFAULT NULL,
  `max_distance` decimal(10,2) DEFAULT NULL,
  `max_weight` decimal(10,2) DEFAULT NULL,
  `max_dimensions` varchar(255) DEFAULT NULL,
  `require_signature` tinyint(1) NOT NULL DEFAULT 0,
  `insurance_required` tinyint(1) NOT NULL DEFAULT 0,
  `tracking_available` tinyint(1) NOT NULL DEFAULT 1,
  `handling_fee` decimal(10,2) NOT NULL DEFAULT 0.00,
  `views` int(11) 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 `shippings`
--

INSERT INTO `shippings` (`id`, `store_id`, `name`, `type`, `description`, `cost`, `min_order_amount`, `delivery_time`, `sort_order`, `is_active`, `zone_type`, `countries`, `postal_codes`, `max_distance`, `max_weight`, `max_dimensions`, `require_signature`, `insurance_required`, `tracking_available`, `handling_fee`, `views`, `created_at`, `updated_at`) VALUES
(1, 1, 'Free Shipping', 'free', 'Free standard shipping on orders over $50', 0.00, 50.00, '5-7 business days', 1, 1, 'global', NULL, NULL, NULL, NULL, NULL, 0, 0, 1, 0.00, 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32');

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

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `country_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `code` varchar(10) DEFAULT NULL,
  `status` 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 `states`
--

INSERT INTO `states` (`id`, `country_id`, `name`, `code`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'California', 'CA', 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(2, 1, 'Texas', 'TX', 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(5, 3, 'Azad Jammu Kashmir', 'AJK', 1, '2026-01-01 16:52:35', '2026-01-01 16:52:35'),
(6, 3, 'Balochistan', 'BL', 1, '2026-01-01 16:52:58', '2026-01-01 16:55:42'),
(7, 3, 'Khyber Pakhtukhuwan', 'KPK', 1, '2026-01-01 16:53:27', '2026-01-01 16:53:27'),
(8, 3, 'Punjab', 'PB', 1, '2026-01-01 16:53:45', '2026-01-01 16:53:55'),
(9, 3, 'SINDH', 'SD', 1, '2026-01-01 16:54:27', '2026-01-01 16:55:33'),
(10, 3, 'Islamabad', 'ISD', 1, '2026-01-01 16:54:44', '2026-01-01 16:54:44');

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

--
-- Table structure for table `stores`
--

CREATE TABLE `stores` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `theme` varchar(255) NOT NULL DEFAULT 'modern',
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `custom_domain` varchar(255) DEFAULT NULL,
  `custom_subdomain` varchar(255) DEFAULT NULL,
  `enable_custom_domain` tinyint(1) NOT NULL DEFAULT 0,
  `enable_custom_subdomain` tinyint(1) NOT NULL DEFAULT 0,
  `email` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `enable_pwa` tinyint(1) NOT NULL DEFAULT 0,
  `pwa_name` varchar(255) DEFAULT NULL,
  `pwa_short_name` varchar(12) DEFAULT NULL,
  `pwa_description` text DEFAULT NULL,
  `pwa_theme_color` varchar(7) NOT NULL DEFAULT '#3B82F6',
  `pwa_background_color` varchar(7) NOT NULL DEFAULT '#ffffff',
  `pwa_icon` varchar(255) DEFAULT NULL,
  `pwa_display` enum('standalone','fullscreen','minimal-ui','browser') NOT NULL DEFAULT 'standalone',
  `pwa_orientation` enum('portrait','landscape','any') NOT NULL DEFAULT 'portrait',
  `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 `stores`
--

INSERT INTO `stores` (`id`, `name`, `slug`, `description`, `theme`, `user_id`, `custom_domain`, `custom_subdomain`, `enable_custom_domain`, `enable_custom_subdomain`, `email`, `is_active`, `enable_pwa`, `pwa_name`, `pwa_short_name`, `pwa_description`, `pwa_theme_color`, `pwa_background_color`, `pwa_icon`, `pwa_display`, `pwa_orientation`, `is_featured`, `created_at`, `updated_at`) VALUES
(1, 'Home Decor Haven', 'home-decor-haven', 'Beautiful home decor items, furniture, and accessories to transform your living space.', 'home-accessories', 2, NULL, NULL, 0, 0, 'design@homedecor.com', 1, 0, NULL, NULL, NULL, '#3B82F6', '#ffffff', NULL, 'standalone', 'portrait', 0, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(2, 'Mujadaddy Fabrics', 'mujadaddy-fabrics', 'Welcome to Mujadaddy Fabrics store', 'fashion', 3, NULL, NULL, 0, 0, 'sultancollectionsonline@gmail.com', 1, 1, 'Sultan\'s Store', 'Sultan\'s Sto', 'Welcome to Sultan\'s store', '#3B82F6', '#ffffff', NULL, 'standalone', 'portrait', 0, '2026-01-01 11:01:39', '2026-02-17 17:32:18'),
(3, 'hunarsaaz.com\'s Store', 'hunarsaaz', 'Welcome to hunarsaaz.com\'s store', 'furniture-interior', 4, 'hunarsaaz.com', NULL, 1, 0, 'admin@hunarsaaz.com', 1, 1, 'hunarsaaz.com\'s Store', 'hunarsaaz', 'Welcome to hunarsaaz.com\'s store', '#3B82F6', '#ffffff', NULL, 'standalone', 'portrait', 0, '2026-01-01 11:40:50', '2026-03-10 22:15:22'),
(5, 'sgserum\'s Store', 'sgserums-store', 'Welcome to sgserum\'s store', 'beauty-cosmetics', 5, NULL, NULL, 0, 0, 'rehan@sgserum.pk', 1, 1, 'sgserum\'s Store', 'sgserum\'s St', 'Welcome to sgserum\'s store', '#3B82F6', '#ffffff', NULL, 'standalone', 'portrait', 0, '2026-02-17 12:28:14', '2026-02-17 12:31:06'),
(6, 'ahilscollection\'s Store', 'ahilscollections-store', 'Welcome to ahilscollection\'s store', 'home-accessories', 6, NULL, NULL, 0, 0, 'umair@ahilscollection.com', 1, 0, NULL, NULL, NULL, '#3B82F6', '#ffffff', NULL, 'standalone', 'portrait', 0, '2026-02-18 11:49:17', '2026-02-18 11:49:17'),
(7, 'TrendyTrends\'s Store', 'trendytrendss-store', 'Welcome to TrendyTrends\'s store', 'home-accessories', 7, NULL, NULL, 0, 0, 't70973344@gmail.com', 1, 0, NULL, NULL, NULL, '#3B82F6', '#ffffff', NULL, 'standalone', 'portrait', 0, '2026-03-08 19:39:44', '2026-03-08 19:39:44');

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

--
-- Table structure for table `store_coupons`
--

CREATE TABLE `store_coupons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `code_type` varchar(255) NOT NULL DEFAULT 'manual',
  `type` enum('percentage','flat') NOT NULL DEFAULT 'percentage',
  `discount_amount` decimal(10,2) NOT NULL,
  `minimum_spend` decimal(10,2) DEFAULT NULL,
  `maximum_spend` decimal(10,2) DEFAULT NULL,
  `use_limit_per_coupon` int(11) DEFAULT NULL,
  `use_limit_per_user` int(11) DEFAULT NULL,
  `used_count` int(11) NOT NULL DEFAULT 0,
  `start_date` date DEFAULT NULL,
  `expiry_date` date DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `store_id` bigint(20) UNSIGNED NOT NULL,
  `created_by` bigint(20) UNSIGNED 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 `store_settings`
--

CREATE TABLE `store_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `store_id` bigint(20) UNSIGNED NOT NULL,
  `theme` varchar(255) NOT NULL DEFAULT 'default',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`content`)),
  `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 `store_settings`
--

INSERT INTO `store_settings` (`id`, `store_id`, `theme`, `content`, `created_at`, `updated_at`) VALUES
(1, 3, 'home-accessories', '{\"header\":{\"welcome_text\":\"Cash on Delivery all over Pakistan\",\"phone_text\":\"Call us: +92 332 893 6001\",\"show_welcome\":true,\"show_phone\":true},\"hero\":{\"badge_text\":\"New Collection\",\"title\":\"Beautiful Home Accessories\",\"subtitle\":\"Discover more products in the decor category\",\"button_text\":\"Shop Collection\",\"button_link\":\"#\",\"secondary_button_text\":\"View Catalog\",\"secondary_button_link\":\"#\",\"image\":\"\\/storage\\/media\\/43\\/home-banner-home-accessories.png\",\"info_boxes\":[{\"icon\":\"truck\",\"title\":\"Free Shipping\",\"description\":\"On orders over 5000pkr\"},{\"icon\":\"refresh-cw\",\"title\":\"Easy Returns\",\"description\":\"7-day return policy\"},{\"icon\":\"shield-check\",\"title\":\"Secure Checkout\",\"description\":\"100% protected\"}]},\"categories\":{\"title\":\"Browse Categories\",\"description\":\"Find the perfect accessories for every room in your home with our organized categories.\"},\"featured_products\":{\"title\":\"Featured Home Decor\",\"description\":\"Handpicked accessories that bring style and functionality to your living space.\"},\"newsletter\":{\"title\":\"Home Decor Updates\",\"subtitle\":\"Get the latest home styling tips and exclusive product launches delivered to your inbox.\",\"placeholder_text\":\"Your email address\",\"button_text\":\"Subscribe Now\",\"privacy_text\":\"No spam, only beautiful home inspiration.\"},\"cta_boxes\":[{\"icon\":\"home\",\"title\":\"Interior Design\",\"subtitle\":\"Professional home styling\"},{\"icon\":\"palette\",\"title\":\"Custom Colors\",\"subtitle\":\"Match your perfect style\"},{\"icon\":\"award\",\"title\":\"Award Winning\",\"subtitle\":\"Recognized quality products\"},{\"icon\":\"users\",\"title\":\"Expert Support\",\"subtitle\":\"Dedicated customer service\"}],\"trending_products\":{\"title\":\"Trending collection of the week\",\"description\":\"Discover the most popular home accessories that are trending this season.\"},\"brand_logos\":{\"logos\":[{\"image\":\"\\/storage\\/media\\/44\\/brand-logo-home-accessories-1.png\"},{\"image\":\"\\/storage\\/media\\/45\\/brand-logo-home-accessories-2.png\"},{\"image\":\"\\/storage\\/media\\/46\\/brand-logo-home-accessories-3.png\"},{\"image\":\"\\/storage\\/media\\/47\\/brand-logo-home-accessories-4.png\"},{\"image\":\"\\/storage\\/media\\/48\\/brand-logo-home-accessories-5.png\"},{\"image\":\"\\/storage\\/media\\/49\\/brand-logo-home-accessories-6.png\"}]},\"blog\":{\"title\":\"Home Styling Blog\",\"description\":\"Expert tips, trends, and inspiration for creating your perfect home environment.\"},\"footer\":{\"description\":\"Your premier destination for quality home accessories and interior design solutions.\",\"menu\":{\"title\":\"Quick Links\",\"links\":[{\"name\":\"About Us\",\"href\":\"\\/about-us\"},{\"name\":\"Contact Us\",\"href\":\"#\"},{\"name\":\"Privacy Policy\",\"href\":\"#\"},{\"name\":\"Terms & Conditions\",\"href\":\"#\"}]},\"contact\":{\"address\":\"456 Design Avenue, Creative District, NY 10001\",\"phone\":\"+92 332 893 6001\",\"email\":\"contact@hunarsaaz.com\"},\"social_links\":[{\"platform\":\"facebook\",\"url\":\"http:\\/\\/www.alfadecor.pk\\/hunarsaaz\"},{\"platform\":\"instagram\",\"url\":\"http:\\/\\/www.instagram.pk\\/hunar.saaz\"},{\"platform\":\"whatsapp\",\"url\":\"https:\\/\\/api.whatsapp.com\\/send?phone=923328936001\"}],\"copyright_text\":\"\\u00a9 {year} {store_name}. All rights reserved.\"}}', '2026-01-01 12:01:41', '2026-01-21 09:51:41'),
(3, 5, 'beauty-cosmetics', '{\"header\":{\"welcome_text\":\"Free shipping on orders over $75\",\"phone_text\":\"Beauty Hotline: +1 555 BEAUTY\",\"show_welcome\":true,\"show_phone\":true},\"hero\":{\"badge_text\":\"Dermatology-Inspired Skincare\",\"title\":\"Targeted Serums for Real Skin Results\",\"subtitle\":\"Powered by clinically trusted ingredients like Vitamin C, Niacinamide & Glutathione  our lightweight serums are designed to reduce acne, control oil, fade pigmentation, and restore your natural glow.\",\"button_text\":\"Shop Collection\",\"button_link\":\"#\",\"secondary_button_text\":\"Beauty Guide\",\"secondary_button_link\":\"\\/beauty-guide\",\"image\":\"\\/storage\\/media\\/60\\/sg-serum.png\",\"floating_card\":{\"title\":\"Loved by 50K+\",\"subtitle\":\"Beauty enthusiasts\"},\"info_boxes\":[{\"icon\":\"sparkles\",\"title\":\"Clean Beauty\",\"description\":\"Cruelty-free & natural ingredients\"},{\"icon\":\"heart\",\"title\":\"Skin-First\",\"description\":\"Dermatologist tested formulas\"},{\"icon\":\"shield\",\"title\":\"Safe & Pure\",\"description\":\"No harmful chemicals\"}]},\"categories\":{\"title\":\"Shop By Skin Concern\",\"description\":\"Every skin is different and so is every solution. Choose a serum tailored to your concern and start seeing visible improvements.\"},\"featured_products\":{\"title\":\"Best-Selling Serums\",\"description\":\"Our most-loved formulas delivering visible skin transformation.\"},\"newsletter\":{\"title\":\"Get 10% Off Your First Order\",\"subtitle\":\"Join our skincare community and receive exclusive offers, early access to new launches, and expert skin tips.\",\"highlight_text\":\"\\ud83d\\udc84 Get 15% off your first order!\",\"placeholder_text\":\"Enter your email for beauty updates\",\"button_text\":\"Join Community\",\"benefits\":[{\"icon\":\"\\ud83c\\udf81\",\"title\":\"Exclusive Offers\",\"description\":\"Member-only discounts & early access\"},{\"icon\":\"\\u2728\",\"title\":\"Beauty Tips\",\"description\":\"Weekly tutorials & expert advice\"},{\"icon\":\"\\ud83d\\udc8c\",\"title\":\"New Arrivals\",\"description\":\"First to know about latest products\"}]},\"cta_boxes\":[{\"icon\":\"Lab Flask\",\"title\":\"Science-Backed Skincare\",\"subtitle\":\"Science-Backed Skincare\"},{\"icon\":\"calendar\",\"title\":\"Beauty Calendar\",\"subtitle\":\"Track your skincare routine\"},{\"icon\":\"gift\",\"title\":\"Beauty Box\",\"subtitle\":\"Monthly curated surprises\"},{\"icon\":\"star\",\"title\":\"Rewards Program\",\"subtitle\":\"Earn points with every purchase\"}],\"trending_products\":{\"title\":\"Trending Now\",\"description\":\"Most loved by our customers this season.\"},\"brand_logos\":{\"logos\":[{\"image\":\"\\/storage\\/media\\/13\\/brand-logo-beauty-1.png\"},{\"image\":\"\\/storage\\/media\\/14\\/brand-logo-beauty-2.png\"},{\"image\":\"\\/storage\\/media\\/15\\/brand-logo-beauty-3.png\"},{\"image\":\"\\/storage\\/media\\/16\\/brand-logo-beauty-4.png\"},{\"image\":\"\\/storage\\/media\\/17\\/brand-logo-beauty-5.png\"},{\"image\":\"\\/storage\\/media\\/18\\/brand-logo-beauty-6.png\"}],\"stats\":[{\"number\":\"50K+\",\"label\":\"Happy Customers\"},{\"number\":\"200+\",\"label\":\"Beauty Brands\"},{\"number\":\"5K+\",\"label\":\"Products\"},{\"number\":\"98%\",\"label\":\"Satisfaction Rate\"}]},\"blog\":{\"title\":\"Skincare Insights & Tips\",\"description\":\"Expert-backed skincare guides, ingredient breakdowns, and routine tips to help you make smarter choices for healthier, glowing skin.\"},\"footer\":{\"description\":\"At Digitiyara, we believe skincare should be simple, effective, and science-backed. Our targeted serums are formulated with clinically trusted ingredients to treat real skin concerns without unnecessary complexity.\",\"menu1\":{\"title\":\"Customer Care\",\"links\":[{\"name\":\"Beauty Consultation\",\"href\":\"#\"},{\"name\":\"Shipping & Returns\",\"href\":\"#\"},{\"name\":\"Contact Us\",\"href\":\"#\"},{\"name\":\"Ingredient Guide\",\"href\":\"#\"}]},\"menu2\":{\"title\":\"Company\",\"links\":[{\"name\":\"About Us\",\"href\":\"#\"},{\"name\":\"Careers\",\"href\":\"#\"},{\"name\":\"Press\",\"href\":\"#\"},{\"name\":\"Privacy Policy\",\"href\":\"#\"}]},\"contact\":{\"address\":\"456 Beauty Boulevard, Wellness District, CA 90210\",\"phone\":\"+1 (555) 239-8847\",\"email\":\"hello@beautystore.com\"},\"social_links\":[{\"platform\":\"instagram\",\"url\":null},{\"platform\":\"youtube\",\"url\":null},{\"platform\":\"tiktok\",\"url\":null},{\"platform\":\"pinterest\",\"url\":null}],\"copyright_text\":\"\\u00a9 {year} {store_name}. All rights reserved.\"}}', '2026-02-18 19:11:18', '2026-02-18 19:34:49'),
(4, 2, 'fashion', '{\"header\":{\"welcome_text\":\"Free shipping on orders over $100\",\"phone_text\":\"Style Hotline: +1 555 FASHION\",\"show_welcome\":true,\"show_phone\":true},\"hero\":{\"badge_text\":\"Summer Collection 2026\",\"title\":\"Premium Eastern Menswear\",\"subtitle\":\"Discover finely tailored kameez shalwar and waistcoat designs crafted for the modern gentleman who values heritage and style.\",\"button_text\":null,\"button_link\":\"#\",\"secondary_button_text\":null,\"secondary_button_link\":\"#\",\"image\":\"\\/storage\\/media\\/87\\/Mujadaddy_banner.webp\",\"info_boxes\":[{\"icon\":\"truck\",\"title\":\"Express Delivery\",\"description\":null},{\"icon\":\"refresh-cw\",\"title\":\"Easy Exchanges\",\"description\":\"60-day exchange policy\"},{\"icon\":\"award\",\"title\":\"Premium Quality\",\"description\":\"Curated designer pieces\"}]},\"categories\":{\"title\":\"Shop By Style\",\"description\":\"Explore our curated menswear collections designed for every occasion \\u2014 from everyday elegance to festive sophistication\"},\"featured_products\":{\"title\":\"Signature Pieces\",\"description\":\"Handpicked designs that define confidence and class.\"},\"newsletter\":{\"title\":\"Join The Mujdaddy Circle\",\"subtitle\":\"Be the first to access new collections, exclusive offers, and refined styling inspiration crafted for the modern gentleman.\",\"placeholder_text\":\"Enter your email address\",\"button_text\":\"Subscribe Now\",\"privacy_text\":\"No spam. Only exclusive updates. Unsubscribe anytime.\"},\"cta_boxes\":[{\"icon\":\"Redefine Your Wardrobe\",\"title\":\"Personal Styling\",\"subtitle\":\"Get expert guidance to choose the perfect outfit for weddings, formal events, and special occasions.\"},{\"icon\":\"crown\",\"title\":\"Exclusive Collections\",\"subtitle\":\"Discover limited-edition designs crafted for refined taste.\"},{\"icon\":\"box-open\",\"title\":\"Premium Packaging\",\"subtitle\":\"Carefully packed to preserve elegance and quality.\"},{\"icon\":\"shield\",\"title\":\"Quality Assured\",\"subtitle\":\"Crafted with premium fabrics and expert finishing.\"}],\"trending_products\":{\"title\":\"Trending Now\",\"description\":\"Explore our most sought-after designs crafted with premium fabrics and tailored for timeless elegance.\"},\"brand_logos\":{\"logos\":[{\"image\":\"\\/storage\\/media\\/37\\/brand-logo-fashion-1.png\"},{\"image\":\"\\/storage\\/media\\/38\\/brand-logo-fashion-2.png\"},{\"image\":\"\\/storage\\/media\\/39\\/brand-logo-fashion-3.png\"},{\"image\":\"\\/storage\\/media\\/40\\/brand-logo-fashion-4.png\"}]},\"blog\":{\"title\":\"Style Journal\",\"description\":\"Explore expert styling tips, fabric guides, and seasonal trends crafted for the modern gentleman who values tradition and sophistication.\"},\"footer\":{\"description\":\"Mujdaddy Fabrics offers premium eastern menswear crafted with quality fabrics and expert tailoring. Our collections blend tradition with modern sophistication for the confident gentleman.\",\"menu1\":{\"title\":\"Customer Care\",\"links\":[{\"name\":\"Size Guide\",\"href\":\"#\"},{\"name\":\"Shipping & Returns\",\"href\":\"#\"},{\"name\":\"Contact Us\",\"href\":\"#\"},{\"name\":\"Style Advice\",\"href\":\"#\"}]},\"menu2\":{\"title\":\"Company\",\"links\":[{\"name\":\"About Us\",\"href\":\"#\"},{\"name\":\"Careers\",\"href\":\"#\"},{\"name\":\"Press\",\"href\":\"#\"},{\"name\":\"Privacy Policy\",\"href\":\"#\"}]},\"contact\":{\"address\":\"Pakistan Market, Lahore\",\"phone\":\"+92 321 4903270\",\"email\":\"sultancollectionsonline@gmail.com\"},\"social_links\":[{\"platform\":\"instagram\",\"url\":null},{\"platform\":\"tiktok\",\"url\":null},{\"platform\":\"pinterest\",\"url\":null},{\"platform\":\"youtube\",\"url\":null}],\"copyright_text\":\"\\u00a9 {year} {store_name}. All rights reserved.\"}}', '2026-02-18 20:16:12', '2026-03-11 01:02:35'),
(5, 3, 'furniture-interior', '{\"header\":{\"welcome_text\":\"Free Nationwide Delivery on Orders Above PKR 5,000\",\"phone_text\":\"Design Help: +92 332 8936001 DESIGN\",\"show_welcome\":true,\"show_phone\":true},\"hero\":{\"badge_text\":\"Premium Home Decor\",\"title\":\"Decor Your Space\",\"subtitle\":\"Minimal, elegant, and thoughtfully designed decor to elevate every corner of your living space.\",\"button_text\":\"Shop Collection\",\"button_link\":\"#\",\"secondary_button_text\":\"Best Combination\",\"secondary_button_link\":\"\\/design-services\",\"image\":\"\\/storage\\/media\\/82\\/Hunarsaaz-Hero_Banner.webp\",\"stats\":[{\"number\":\"3,000+\",\"label\":\"Homes Decorated\"},{\"number\":\"15+\",\"label\":\"Years\"}],\"room_section\":{\"title\":\"Shop by Room\",\"rooms\":[{\"name\":\"Living Room\"},{\"name\":\"Bedroom\"},{\"name\":\"Dining Room\"},{\"name\":\"Office\"}]},\"catalog_info\":{\"title\":\"Furniture Catalog 2026\",\"description\":\"Premium Decor collection\",\"button_text\":\"Browse All\",\"button_link\":\"#\",\"stats\":[{\"number\":\"150+\",\"label\":\"Unique Decor Pieces\"},{\"number\":\"100%\",\"label\":\"Quality Crafted Decor\"},{\"number\":\"50+\",\"label\":\"Cities Delivered\"}]},\"floating_badge\":\"NEW 2026\"},\"categories\":{\"title\":\"Explore Our Collections\",\"description\":\"Discover thoughtfully curated decor pieces designed to elevate every corner of your home.\"},\"featured_products\":{\"title\":\"Signature Pieces\",\"description\":\"Explore our most iconic decor selections curated for refined interiors.\"},\"newsletter\":{\"title\":\"Join the Hunarsaaz Community\",\"subtitle\":\"Subscribe to receive exclusive decor inspiration, new arrivals, and special offers.\",\"placeholder_text\":\"your@email.com\",\"button_text\":\"Join Community\",\"privacy_text\":\"No spam. Only beautiful decor inspiration.\",\"benefits\":[{\"text\":\"Premium Quality\"},{\"text\":\"Secure Checkout\"},{\"text\":\"Fast Delivery Across Pakistan\"}]},\"cta_boxes\":[{\"icon\":\"car\",\"title\":\"Free Delivery\",\"subtitle\":\"Delivery across Pakistan\"},{\"icon\":\"award\",\"title\":\"Premium Quality\",\"subtitle\":\"Carefully crafted decor pieces\"},{\"icon\":\"lock\",\"title\":\"Secure Payment\",\"subtitle\":\"Shop with confidence\"},{\"icon\":\"phone\",\"title\":\"Customer Support\",\"subtitle\":\"24\\/7 Support\"}],\"cta_bottom\":{\"title\":\"Transform Your Space with Hunarsaaz\",\"description\":\"Discover elegant decor pieces crafted to bring beauty and style to your home.\",\"primary_button_text\":\"Shop Collection\",\"primary_button_link\":\"\\/consultation\",\"secondary_button_text\":\"View Portfolio\",\"secondary_button_link\":\"\\/portfolio\"},\"trending_products\":{\"title\":\"Popular Right Now\",\"description\":\"See what other customers are loving in their spaces.\"},\"design_process\":{\"title\":\"Our Process\",\"description\":\"At Hunarsaaz, every piece is thoughtfully selected to bring elegance and character to your home. From design inspiration to delivery, we ensure a seamless experience.\",\"steps\":[{\"step\":\"01\",\"title\":\"Discover the Collection\",\"description\":\"Browse decor pieces designed to elevate your living space.\"},{\"step\":\"02\",\"title\":\"Choose Your Favorites\",\"description\":\"Select the decor items that match your style and create a space that reflects your personality.\"},{\"step\":\"03\",\"title\":\"Secure Checkout\",\"description\":\"Place your order easily through our safe and secure checkout process.\"},{\"step\":\"04\",\"title\":\"Delivered to Your Door\",\"description\":\"Sit back and relax while we deliver your beautiful decor pieces straight to your home.\"}]},\"stats_section\":{\"title\":\"Trusted by Thousands\",\"stats\":[{\"number\":\"50+\",\"label\":\"Premium Brands\"},{\"number\":\"25+\",\"label\":\"Years Experience\"},{\"number\":\"10K+\",\"label\":\"Happy Customers\"},{\"number\":\"99%\",\"label\":\"Satisfaction Rate\"}]},\"brand_logos\":{\"title\":\"Trusted Partners\",\"description\":\"We work with premium material suppliers and craftsmen worldwide.\",\"logos\":[{\"image\":\"\\/storage\\/media\\/71\\/brand-logo-furniture-interior-1.png\",\"name\":\"Premium Woods\"},{\"image\":\"\\/storage\\/media\\/72\\/brand-logo-furniture-interior-2.png\",\"name\":\"Eco Materials\"},{\"image\":\"\\/storage\\/media\\/73\\/brand-logo-furniture-interior-3.png\",\"name\":\"Luxury Finishes\"},{\"image\":\"\\/storage\\/media\\/74\\/brand-logo-furniture-interior-4.png\",\"name\":\"Sustainable Sources\"},{\"image\":\"\\/storage\\/media\\/75\\/brand-logo-furniture-interior-5.png\",\"name\":\"Artisan Craft\"},{\"image\":\"\\/storage\\/media\\/76\\/brand-logo-furniture-interior-6.png\",\"name\":\"Quality Design\"}]},\"blog\":{\"title\":\"Design Inspiration\",\"description\":\"Ideas and tips to help you create the perfect space.\"},\"footer\":{\"description\":\"Creating beautiful, comfortable homes with thoughtfully designed furniture and expert design services.\",\"menu1\":{\"title\":\"Customer Care\",\"links\":[{\"name\":\"Design Help\",\"href\":\"#\"},{\"name\":\"Delivery Info\",\"href\":\"#\"},{\"name\":\"Care Guide\",\"href\":\"#\"},{\"name\":\"Contact Us\",\"href\":\"#\"}]},\"menu2\":{\"title\":\"Company\",\"links\":[{\"name\":\"About Us\",\"href\":\"#\"},{\"name\":\"Our Story\",\"href\":\"#\"},{\"name\":\"Showrooms\",\"href\":\"#\"},{\"name\":\"Privacy\",\"href\":\"#\"}]},\"contact\":{\"address\":\"Shah Alam Market, Lahore\",\"phone\":\"+92 332 8936001\",\"email\":\"hello@hunarsaaz.com\"},\"social_links\":[{\"platform\":\"instagram\",\"url\":null},{\"platform\":\"pinterest\",\"url\":null},{\"platform\":\"facebook\",\"url\":null},{\"platform\":\"youtube\",\"url\":null}],\"copyright_text\":\"\\u00a9 {year} {store_name}. All rights reserved.\"}}', '2026-03-10 23:28:04', '2026-03-11 00:19:35');

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

--
-- Table structure for table `taxes`
--

CREATE TABLE `taxes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `rate` decimal(8,2) NOT NULL,
  `type` enum('percentage','fixed') NOT NULL DEFAULT 'percentage',
  `region` varchar(255) DEFAULT NULL,
  `priority` int(11) NOT NULL DEFAULT 1,
  `compound` tinyint(1) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `store_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 `taxes`
--

INSERT INTO `taxes` (`id`, `name`, `rate`, `type`, `region`, `priority`, `compound`, `is_active`, `store_id`, `created_at`, `updated_at`) VALUES
(1, 'Standard VAT', 20.00, 'percentage', 'Global', 1, 0, 1, 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(2, 'Reduced Rate', 5.00, 'percentage', 'Global', 2, 0, 1, 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(3, 'Zero Rate', 0.00, 'percentage', 'Global', 3, 0, 1, 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(4, 'Luxury Tax', 25.00, 'percentage', 'Global', 4, 0, 1, 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(5, 'Sales Tax', 0.00, 'percentage', 'Pakistan', 1, 0, 1, 2, '2026-01-01 12:29:20', '2026-02-18 20:56:14');

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

--
-- Table structure for table `user_email_templates`
--

CREATE TABLE `user_email_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `template_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT 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 `user_email_templates`
--

INSERT INTO `user_email_templates` (`id`, `template_id`, `user_id`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(2, 2, 1, 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(3, 3, 1, 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32'),
(4, 4, 1, 1, '2026-01-01 10:54:32', '2026-01-01 10:54:32');

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

--
-- Table structure for table `webhooks`
--

CREATE TABLE `webhooks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `store_id` bigint(20) UNSIGNED DEFAULT NULL,
  `module` varchar(50) NOT NULL,
  `method` enum('GET','POST') NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `url` 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;

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

--
-- Table structure for table `wishlist_items`
--

CREATE TABLE `wishlist_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `store_id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `session_id` varchar(255) DEFAULT 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;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `blogs_slug_unique` (`slug`),
  ADD KEY `blogs_category_id_foreign` (`category_id`),
  ADD KEY `blogs_author_id_foreign` (`author_id`),
  ADD KEY `blogs_store_id_foreign` (`store_id`);

--
-- Indexes for table `blog_blog_tag`
--
ALTER TABLE `blog_blog_tag`
  ADD PRIMARY KEY (`blog_id`,`blog_tag_id`),
  ADD KEY `blog_blog_tag_blog_tag_id_foreign` (`blog_tag_id`);

--
-- Indexes for table `blog_categories`
--
ALTER TABLE `blog_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `blog_categories_slug_unique` (`slug`),
  ADD KEY `blog_categories_store_id_foreign` (`store_id`),
  ADD KEY `blog_categories_created_by_foreign` (`created_by`);

--
-- Indexes for table `blog_comments`
--
ALTER TABLE `blog_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `blog_comments_blog_id_foreign` (`blog_id`),
  ADD KEY `blog_comments_user_id_foreign` (`user_id`),
  ADD KEY `blog_comments_parent_id_foreign` (`parent_id`);

--
-- Indexes for table `blog_tags`
--
ALTER TABLE `blog_tags`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `blog_tags_slug_store_id_unique` (`slug`,`store_id`),
  ADD KEY `blog_tags_store_id_foreign` (`store_id`);

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

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

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `categories_slug_store_id_unique` (`slug`,`store_id`),
  ADD UNIQUE KEY `categories_slug_unique` (`slug`),
  ADD KEY `categories_parent_id_foreign` (`parent_id`),
  ADD KEY `categories_store_id_foreign` (`store_id`);

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cities_state_id_foreign` (`state_id`);

--
-- Indexes for table `contacts`
--
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `contacts_is_landing_page_created_at_index` (`is_landing_page`,`created_at`);

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

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `coupons_code_unique` (`code`),
  ADD KEY `coupons_created_by_foreign` (`created_by`);

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

--
-- Indexes for table `customer_addresses`
--
ALTER TABLE `customer_addresses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_addresses_customer_id_foreign` (`customer_id`);

--
-- Indexes for table `customer_password_resets`
--
ALTER TABLE `customer_password_resets`
  ADD KEY `customer_password_resets_store_id_foreign` (`store_id`),
  ADD KEY `customer_password_resets_email_index` (`email`);

--
-- Indexes for table `custom_pages`
--
ALTER TABLE `custom_pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `custom_pages_slug_unique` (`slug`),
  ADD KEY `custom_pages_store_id_foreign` (`store_id`),
  ADD KEY `custom_pages_parent_id_foreign` (`parent_id`);

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

--
-- Indexes for table `email_template_langs`
--
ALTER TABLE `email_template_langs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `email_template_langs_parent_id_foreign` (`parent_id`);

--
-- Indexes for table `express_checkouts`
--
ALTER TABLE `express_checkouts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `express_checkouts_store_id_foreign` (`store_id`);

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

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

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

--
-- Indexes for table `landing_page_custom_pages`
--
ALTER TABLE `landing_page_custom_pages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `landing_page_custom_pages_slug_unique` (`slug`);

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

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `media_uuid_unique` (`uuid`),
  ADD KEY `media_model_type_model_id_index` (`model_type`,`model_id`),
  ADD KEY `media_user_id_foreign` (`user_id`),
  ADD KEY `media_order_column_index` (`order_column`);

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

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

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `newsletters`
--
ALTER TABLE `newsletters`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `newsletters_email_unique` (`email`),
  ADD KEY `newsletters_status_created_at_index` (`status`,`created_at`),
  ADD KEY `newsletters_email_index` (`email`);

--
-- Indexes for table `newsletter_subscriptions`
--
ALTER TABLE `newsletter_subscriptions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `newsletter_subscriptions_store_id_email_unique` (`store_id`,`email`),
  ADD KEY `newsletter_subscriptions_store_id_is_active_index` (`store_id`,`is_active`);

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

--
-- Indexes for table `notification_template_langs`
--
ALTER TABLE `notification_template_langs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notification_template_langs_parent_id_foreign` (`parent_id`);

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

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

--
-- Indexes for table `payout_requests`
--
ALTER TABLE `payout_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payout_requests_company_id_foreign` (`company_id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `plans`
--
ALTER TABLE `plans`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `plans_name_unique` (`name`);

--
-- Indexes for table `plan_orders`
--
ALTER TABLE `plan_orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `plan_orders_order_number_unique` (`order_number`),
  ADD KEY `plan_orders_user_id_foreign` (`user_id`),
  ADD KEY `plan_orders_plan_id_foreign` (`plan_id`),
  ADD KEY `plan_orders_coupon_id_foreign` (`coupon_id`),
  ADD KEY `plan_orders_processed_by_foreign` (`processed_by`);

--
-- Indexes for table `plan_requests`
--
ALTER TABLE `plan_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `plan_requests_user_id_foreign` (`user_id`),
  ADD KEY `plan_requests_plan_id_foreign` (`plan_id`),
  ADD KEY `plan_requests_approved_by_foreign` (`approved_by`),
  ADD KEY `plan_requests_rejected_by_foreign` (`rejected_by`);

--
-- Indexes for table `pos_payments`
--
ALTER TABLE `pos_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pos_payments_transaction_id_foreign` (`transaction_id`);

--
-- Indexes for table `pos_settings`
--
ALTER TABLE `pos_settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pos_settings_store_id_foreign` (`store_id`);

--
-- Indexes for table `pos_transactions`
--
ALTER TABLE `pos_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pos_transactions_store_id_foreign` (`store_id`),
  ADD KEY `pos_transactions_customer_id_foreign` (`customer_id`),
  ADD KEY `pos_transactions_cashier_id_foreign` (`cashier_id`);

--
-- Indexes for table `pos_transaction_items`
--
ALTER TABLE `pos_transaction_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pos_transaction_items_transaction_id_foreign` (`transaction_id`),
  ADD KEY `pos_transaction_items_product_id_foreign` (`product_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_category_id_foreign` (`category_id`),
  ADD KEY `products_tax_id_foreign` (`tax_id`),
  ADD KEY `products_store_id_foreign` (`store_id`);

--
-- Indexes for table `product_reviews`
--
ALTER TABLE `product_reviews`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_customer_product_review` (`product_id`,`customer_id`),
  ADD KEY `product_reviews_customer_id_foreign` (`customer_id`),
  ADD KEY `product_reviews_store_id_foreign` (`store_id`),
  ADD KEY `product_reviews_product_id_is_approved_index` (`product_id`,`is_approved`);

--
-- Indexes for table `referrals`
--
ALTER TABLE `referrals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `referrals_user_id_foreign` (`user_id`),
  ADD KEY `referrals_company_id_foreign` (`company_id`),
  ADD KEY `referrals_plan_id_foreign` (`plan_id`);

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

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`),
  ADD KEY `roles_created_by_foreign` (`created_by`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_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 `shippings`
--
ALTER TABLE `shippings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shippings_store_id_foreign` (`store_id`);

--
-- Indexes for table `states`
--
ALTER TABLE `states`
  ADD PRIMARY KEY (`id`),
  ADD KEY `states_country_id_foreign` (`country_id`);

--
-- Indexes for table `stores`
--
ALTER TABLE `stores`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `stores_slug_unique` (`slug`),
  ADD KEY `stores_user_id_foreign` (`user_id`);

--
-- Indexes for table `store_coupons`
--
ALTER TABLE `store_coupons`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `store_coupons_code_unique` (`code`),
  ADD KEY `store_coupons_store_id_foreign` (`store_id`),
  ADD KEY `store_coupons_created_by_foreign` (`created_by`);

--
-- Indexes for table `store_settings`
--
ALTER TABLE `store_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `store_settings_store_id_theme_unique` (`store_id`,`theme`);

--
-- Indexes for table `taxes`
--
ALTER TABLE `taxes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `taxes_name_store_id_unique` (`name`,`store_id`),
  ADD KEY `taxes_store_id_foreign` (`store_id`);

--
-- Indexes for table `user_email_templates`
--
ALTER TABLE `user_email_templates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_email_templates_template_id_foreign` (`template_id`);

--
-- Indexes for table `webhooks`
--
ALTER TABLE `webhooks`
  ADD PRIMARY KEY (`id`),
  ADD KEY `webhooks_user_id_foreign` (`user_id`),
  ADD KEY `webhooks_store_id_foreign` (`store_id`),
  ADD KEY `webhooks_user_id_store_id_index` (`user_id`,`store_id`);

--
-- Indexes for table `wishlist_items`
--
ALTER TABLE `wishlist_items`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `wishlist_customer_unique` (`store_id`,`customer_id`,`product_id`),
  ADD UNIQUE KEY `wishlist_session_unique` (`store_id`,`session_id`,`product_id`),
  ADD KEY `wishlist_items_customer_id_foreign` (`customer_id`),
  ADD KEY `wishlist_items_product_id_foreign` (`product_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `blogs`
--
ALTER TABLE `blogs`
  ADD CONSTRAINT `blogs_author_id_foreign` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `blogs_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `blog_categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `blogs_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `blog_blog_tag`
--
ALTER TABLE `blog_blog_tag`
  ADD CONSTRAINT `blog_blog_tag_blog_id_foreign` FOREIGN KEY (`blog_id`) REFERENCES `blogs` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `blog_blog_tag_blog_tag_id_foreign` FOREIGN KEY (`blog_tag_id`) REFERENCES `blog_tags` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `blog_categories`
--
ALTER TABLE `blog_categories`
  ADD CONSTRAINT `blog_categories_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `blog_categories_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `blog_comments`
--
ALTER TABLE `blog_comments`
  ADD CONSTRAINT `blog_comments_blog_id_foreign` FOREIGN KEY (`blog_id`) REFERENCES `blogs` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `blog_comments_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `blog_comments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `blog_comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `blog_tags`
--
ALTER TABLE `blog_tags`
  ADD CONSTRAINT `blog_tags_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `categories_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `categories_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cities`
--
ALTER TABLE `cities`
  ADD CONSTRAINT `cities_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `coupons`
--
ALTER TABLE `coupons`
  ADD CONSTRAINT `coupons_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `customer_addresses`
--
ALTER TABLE `customer_addresses`
  ADD CONSTRAINT `customer_addresses_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `customer_password_resets`
--
ALTER TABLE `customer_password_resets`
  ADD CONSTRAINT `customer_password_resets_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `custom_pages`
--
ALTER TABLE `custom_pages`
  ADD CONSTRAINT `custom_pages_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `custom_pages` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `custom_pages_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `email_template_langs`
--
ALTER TABLE `email_template_langs`
  ADD CONSTRAINT `email_template_langs_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `email_templates` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `express_checkouts`
--
ALTER TABLE `express_checkouts`
  ADD CONSTRAINT `express_checkouts_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `media`
--
ALTER TABLE `media`
  ADD CONSTRAINT `media_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `newsletter_subscriptions`
--
ALTER TABLE `newsletter_subscriptions`
  ADD CONSTRAINT `newsletter_subscriptions_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `notification_template_langs`
--
ALTER TABLE `notification_template_langs`
  ADD CONSTRAINT `notification_template_langs_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `notifications` (`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`) ON DELETE CASCADE;

--
-- Constraints for table `payout_requests`
--
ALTER TABLE `payout_requests`
  ADD CONSTRAINT `payout_requests_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `plan_orders`
--
ALTER TABLE `plan_orders`
  ADD CONSTRAINT `plan_orders_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `plan_orders_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `plan_orders_processed_by_foreign` FOREIGN KEY (`processed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `plan_orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `plan_requests`
--
ALTER TABLE `plan_requests`
  ADD CONSTRAINT `plan_requests_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `plan_requests_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `plan_requests_rejected_by_foreign` FOREIGN KEY (`rejected_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `plan_requests_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pos_payments`
--
ALTER TABLE `pos_payments`
  ADD CONSTRAINT `pos_payments_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `pos_transactions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pos_settings`
--
ALTER TABLE `pos_settings`
  ADD CONSTRAINT `pos_settings_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pos_transactions`
--
ALTER TABLE `pos_transactions`
  ADD CONSTRAINT `pos_transactions_cashier_id_foreign` FOREIGN KEY (`cashier_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `pos_transactions_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `pos_transactions_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `pos_transaction_items`
--
ALTER TABLE `pos_transaction_items`
  ADD CONSTRAINT `pos_transaction_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `pos_transaction_items_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `pos_transactions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `products_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `products_tax_id_foreign` FOREIGN KEY (`tax_id`) REFERENCES `taxes` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `product_reviews`
--
ALTER TABLE `product_reviews`
  ADD CONSTRAINT `product_reviews_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_reviews_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_reviews_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `referrals`
--
ALTER TABLE `referrals`
  ADD CONSTRAINT `referrals_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `referrals_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `referrals_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `roles`
--
ALTER TABLE `roles`
  ADD CONSTRAINT `roles_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `shippings`
--
ALTER TABLE `shippings`
  ADD CONSTRAINT `shippings_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `states`
--
ALTER TABLE `states`
  ADD CONSTRAINT `states_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `store_coupons`
--
ALTER TABLE `store_coupons`
  ADD CONSTRAINT `store_coupons_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `store_coupons_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `store_settings`
--
ALTER TABLE `store_settings`
  ADD CONSTRAINT `store_settings_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `taxes`
--
ALTER TABLE `taxes`
  ADD CONSTRAINT `taxes_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `user_email_templates`
--
ALTER TABLE `user_email_templates`
  ADD CONSTRAINT `user_email_templates_template_id_foreign` FOREIGN KEY (`template_id`) REFERENCES `email_templates` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `webhooks`
--
ALTER TABLE `webhooks`
  ADD CONSTRAINT `webhooks_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `webhooks_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `wishlist_items`
--
ALTER TABLE `wishlist_items`
  ADD CONSTRAINT `wishlist_items_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `wishlist_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `wishlist_items_store_id_foreign` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE;
COMMIT;

