관리-도구

편집 파일: saintsaccessoriesFinalbackup(hc1).sql

-- phpMyAdmin SQL Dump
-- version 4.9.11
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Mar 07, 2023 at 05:38 PM
-- Server version: 10.5.19-MariaDB
-- PHP Version: 7.4.33

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

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `customamgdigital_saintsaccessories`
--

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

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

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `is_featured` text DEFAULT NULL,
  `title` text DEFAULT NULL,
  `sub_title` text DEFAULT NULL,
  `content` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `button_text` varchar(255) DEFAULT NULL,
  `button_link` varchar(255) DEFAULT NULL,
  `blog_category_id` bigint(20) DEFAULT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `is_featured`, `title`, `sub_title`, `content`, `image`, `button_text`, `button_link`, `blog_category_id`, `is_active`, `created_at`, `updated_at`) VALUES
(1, NULL, 'How much marijuana should you pack into your joint?', '.', 'Saint Accessories answers all your questions about everything marijuana. From how to get high and when to how to buy and consume the best strains, Saint Accessories provides information on marijuana products that are not', '[\"category-img-1 (1).png\"]', 'Read More', '#', 5, 1, '2023-01-03 20:20:53', '2023-03-06 20:10:09'),
(2, NULL, 'Rolling papers decompose naturally', '.', 'Blaze Papers reusable rolling papers will be totally unrecognizable after the 12th use. These are the world\'s first decomposing rolling papers. They no longer produce sheet ash, by-product, or secondary residue. Each sheet is', '[\"category-img-2 (1).png\"]', 'Read More', '#', 1, 1, '2023-01-03 20:20:56', '2023-03-06 20:10:21'),
(3, NULL, 'Purple Rolling Papers and Pre Rolls for cannabis users!', '.', 'Saint Accessories is a leading provider of top-of-the-line cannabis via the internet and other various channels to the worldwide community. We at Saint Accessories set out to make sure our customers are', '[\"category-img-1 (1).png\"]', 'Read More', '#', 3, 1, '2023-01-03 20:53:59', '2023-03-06 20:10:31'),
(11, NULL, 'Here is a bit about our product - Half Moon Rolling Papers', '.', 'Saint Accessories Half Moon Rolling Papers is a portable rolling tray that doubles as a bowl. Whether you\'re on the go, working, or entertaining at home or in the office, Saint Accessories offers a way to collect and transport your food.', '[\"category-img-2 (1).png\"]', 'Read More', '/blogs', 2, 1, '2023-03-06 18:48:19', '2023-03-06 20:10:45'),
(12, NULL, 'Customizable Dab Mats are Available', '.', 'Saint Accessories is the leading provider of Dab Mats for the on-the-go consumer. Our commitment to delivering excellence in our products allows us to help take the hassle and mess out of your daily', '[\"category-img-1 (1).png\"]', 'Read More', '/blogs', 2, 1, '2023-03-06 18:49:20', '2023-03-06 20:11:12'),
(13, NULL, 'Let your smoking session be more fun with Saint Accessories!', '.', 'Saint Accessories is a professional smoke shop offering you a wide range of smoking products such as shisha and Hookah Pen, e-cigarettes, cannabis oil, herbal incense, and dab pen. Contact us to know', '[\"category-img-2 (1).png\"]', 'Read More', '/blogs', 5, 1, '2023-03-06 18:50:16', '2023-03-06 20:11:28');

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

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

CREATE TABLE `blog_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `image` text DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `blog_categories`
--

INSERT INTO `blog_categories` (`id`, `name`, `image`, `created_at`, `updated_at`) VALUES
(1, 'Personal', NULL, '2023-03-06 22:14:08', '2023-03-06 22:14:08'),
(2, 'Business/corporate', NULL, '2023-03-06 22:14:08', '2023-03-06 22:14:08'),
(3, 'Personal brand/professional', NULL, '2023-03-06 22:14:28', '2023-03-06 22:14:28'),
(4, 'Fashion', NULL, '2023-03-06 22:14:28', '2023-03-06 22:14:28'),
(5, 'Blog newsletter', NULL, '2023-03-06 22:14:49', '2023-03-06 22:14:49'),
(6, 'Lifestyle', NULL, '2023-03-06 22:14:49', '2023-03-06 22:14:49'),
(7, 'Travel', NULL, '2023-03-06 22:15:09', '2023-03-06 22:15:09'),
(8, 'Food', NULL, '2023-03-06 22:15:09', '2023-03-06 22:15:09'),
(9, 'Affiliate/review', NULL, '2023-03-06 22:15:40', '2023-03-06 22:15:40'),
(10, 'Multimedia', NULL, '2023-03-06 22:15:40', '2023-03-06 22:15:40'),
(11, 'News', NULL, '2023-03-06 22:16:02', '2023-03-06 22:16:02');

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

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

CREATE TABLE `brands` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(191) 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 `brands_translation`
--

CREATE TABLE `brands_translation` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `brand_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `name` varchar(191) 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 `category`
--

CREATE TABLE `category` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(191) NOT NULL,
  `parent_id` bigint(20) 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 `category`
--

INSERT INTO `category` (`id`, `slug`, `parent_id`, `created_at`, `updated_at`) VALUES
(31, 'trays', NULL, '2023-03-03 14:51:23', '2023-03-03 14:51:23'),
(32, 'accessories', NULL, '2023-03-03 14:51:34', '2023-03-03 14:51:34'),
(33, 'paper', NULL, '2023-03-03 14:51:46', '2023-03-03 14:51:46'),
(34, 'merch', NULL, '2023-03-03 14:51:54', '2023-03-03 14:51:54'),
(35, 'affiliates', NULL, '2023-03-03 14:52:02', '2023-03-03 14:52:02'),
(36, 'rolling-papers', 33, '2023-03-03 14:52:47', '2023-03-03 14:52:47'),
(37, 'pre-rolled-cones', 33, '2023-03-03 14:53:02', '2023-03-03 14:53:02'),
(38, 'pipes', 32, '2023-03-03 14:53:23', '2023-03-03 14:53:23'),
(39, 'bubblers', 32, '2023-03-03 14:53:35', '2023-03-03 14:53:35'),
(40, 'grinders', 32, '2023-03-03 14:53:45', '2023-03-03 14:53:45');

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

--
-- Table structure for table `category_translation`
--

CREATE TABLE `category_translation` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `name` varchar(191) 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 `category_translation`
--

INSERT INTO `category_translation` (`id`, `category_id`, `locale`, `name`, `description`, `created_at`, `updated_at`) VALUES
(31, 31, 'English', 'Trays', NULL, '2023-03-03 14:51:23', '2023-03-03 14:51:23'),
(32, 32, 'English', 'Accessories', NULL, '2023-03-03 14:51:34', '2023-03-03 14:51:34'),
(33, 33, 'English', 'Paper', NULL, '2023-03-03 14:51:46', '2023-03-03 14:51:46'),
(34, 34, 'English', 'Merch', NULL, '2023-03-03 14:51:54', '2023-03-03 14:51:54'),
(35, 35, 'English', 'Affiliates', NULL, '2023-03-03 14:52:02', '2023-03-03 14:52:02'),
(36, 36, 'English', 'Rolling Papers', NULL, '2023-03-03 14:52:47', '2023-03-03 14:52:47'),
(37, 37, 'English', 'Pre-rolled cones', NULL, '2023-03-03 14:53:02', '2023-03-03 14:53:02'),
(38, 38, 'English', 'Pipes', NULL, '2023-03-03 14:53:23', '2023-03-03 14:53:23'),
(39, 39, 'English', 'Bubblers', NULL, '2023-03-03 14:53:35', '2023-03-03 14:53:35'),
(40, 40, 'English', 'Grinders', NULL, '2023-03-03 14:53:45', '2023-03-03 14:53:45');

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

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

CREATE TABLE `coupons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(191) NOT NULL,
  `value` decimal(10,2) UNSIGNED DEFAULT NULL,
  `is_percent` tinyint(1) NOT NULL,
  `free_shipping` tinyint(1) NOT NULL,
  `minimum_spend` decimal(10,2) UNSIGNED DEFAULT NULL,
  `maximum_spend` decimal(10,2) UNSIGNED DEFAULT NULL,
  `usage_limit_per_coupon` int(10) UNSIGNED DEFAULT NULL,
  `usage_limit_per_customer` int(10) UNSIGNED DEFAULT NULL,
  `used` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date 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 `coupon_categories`
--

CREATE TABLE `coupon_categories` (
  `coupon_id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `exclude` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `coupon_products`
--

CREATE TABLE `coupon_products` (
  `coupon_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `exclude` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `coupon_translations`
--

CREATE TABLE `coupon_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `coupon_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `currency`
--

CREATE TABLE `currency` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(3) NOT NULL,
  `base_currency` tinyint(4) NOT NULL,
  `exchange_rate` decimal(10,6) DEFAULT NULL,
  `status` tinyint(4) 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 `currency`
--

INSERT INTO `currency` (`id`, `name`, `base_currency`, `exchange_rate`, `status`, `created_at`, `updated_at`) VALUES
(1, 'USD', 1, '1.000000', 1, NULL, '2023-03-03 22:15:40'),
(2, 'EUR', 0, '0.850000', 1, NULL, NULL),
(3, 'INR', 0, '72.450000', 1, NULL, NULL);

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

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

CREATE TABLE `customer_addresses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) NOT NULL,
  `name` varchar(191) NOT NULL,
  `country` varchar(30) NOT NULL,
  `state` varchar(50) NOT NULL,
  `city` varchar(191) NOT NULL,
  `address` text NOT NULL,
  `post_code` varchar(50) NOT NULL,
  `is_default` tinyint(1) 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 `customer_addresses`
--

INSERT INTO `customer_addresses` (`id`, `customer_id`, `name`, `country`, `state`, `city`, `address`, `post_code`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 1, 'demo', 'AS', 'Eastern', 'new york', 'new york', '51454', 1, '2023-03-03 20:48:02', '2023-03-03 20:48:02');

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

--
-- Table structure for table `database_backups`
--

CREATE TABLE `database_backups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `file` varchar(191) NOT NULL,
  `user_id` bigint(20) 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 `email_templates`
--

CREATE TABLE `email_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `subject` text NOT NULL,
  `body` 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_templates`
--

INSERT INTO `email_templates` (`id`, `name`, `subject`, `body`, `created_at`, `updated_at`) VALUES
(1, 'welcome_email', 'Welcome to Ultra Store', '<table role=\"presentation\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td style=\"padding: 20px 0 30px 0;\"><table style=\"border-collapse: collapse; border: 1px solid #cccccc;\" border=\"0\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"><tbody><tr><td style=\"padding: 40px 0 30px 0;\" align=\"center\" bgcolor=\"#1e1e2c\"><img style=\"display: block;\" src=\"https://ultrastore.trickycode.net/company-logo.png\" alt=\"Creating Email Magic.\" width=\"80\" height=\"80\"/></td></tr><tr><td style=\"padding: 40px 30px 40px 30px;\" bgcolor=\"#ffffff\"><table style=\"border-collapse: collapse; height: 95px; width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr style=\"height: 30px;\"><td style=\"color: #153643; font-family: Arial, sans-serif; height: 30px;\"><h1 style=\"font-size: 24px; margin: 0;\">Welcome to Ultra Store</h1></td></tr><tr style=\"height: 47px;\"><td style=\"color: #153643; font-family: Arial, sans-serif; font-size: 16px; line-height: 24px; padding: 20px 0px 30px; height: 47px;\"><p style=\"margin: 0;\">Hi {name},</p><p style=\"margin: 0;\">Your account is now ready to use. You can now login to your portal using your email and password.</p><p style=\"margin: 0;\">&nbsp;</p><p style=\"margin: 0;\">Thank You</p><p style=\"margin: 0;\">Ultra Store</p></td></tr></tbody></table></td></tr><tr><td style=\"padding: 30px 30px;\" bgcolor=\"#1e1e2c\"><table style=\"border-collapse: collapse; width: 99.4769%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td style=\"color: #ffffff; font-family: Arial, sans-serif; font-size: 14px; width: 99.8141%;\"><p style=\"margin: 0px; text-align: center;\">&reg; Tricky Code 2021</p></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table>', NULL, NULL),
(2, 'order_placed', 'Your Order Placed Successfully', '<table role=\"presentation\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td style=\"padding: 20px 0 30px 0;\"><table style=\"border-collapse: collapse; border: 1px solid #cccccc;\" border=\"0\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"><tbody><tr><td style=\"padding: 40px 0 30px 0;\" align=\"center\" bgcolor=\"#1e1e2c\"><img style=\"display: block;\" src=\"https://ultrastore.trickycode.net/company-logo.png\" alt=\"Creating Email Magic.\" width=\"80\" height=\"80\"/></td></tr><tr><td style=\"padding: 40px 30px 40px 30px;\" bgcolor=\"#ffffff\"><table style=\"border-collapse: collapse; height: 95px; width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr style=\"height: 30px;\"><td style=\"color: #153643; font-family: Arial, sans-serif; height: 30px;\"><h1 style=\"font-size: 24px; margin: 0;\">Your Order Placed Successfully</h1></td></tr><tr style=\"height: 47px;\"><td style=\"color: #153643; font-family: Arial, sans-serif; font-size: 16px; line-height: 24px; padding: 20px 0px 30px; height: 47px;\"><p style=\"margin: 0;\">Hi {name},</p><p style=\"margin: 0;\">Your Order (Order ID:{order_id}) has been placed sucessfully. Your order will be shipped within next 3 business days.</p><p style=\"margin: 0;\">&nbsp;</p><p style=\"margin: 0;\">Order ID:{order_id}</p><p style=\"margin: 0;\">Order Status:{order_status}</p><p style=\"margin: 0;\">Payment Status:{payment_status}</p><p style=\"margin: 0;\">Payment Method:{payment_method}</p><p style=\"margin: 0;\">&nbsp;</p><p style=\"margin: 0;\">Thank you for shopping with us.</p><p style=\"margin: 0;\">&nbsp;</p><p style=\"margin: 0;\">Thank You</p><p style=\"margin: 0;\">Ultra Store</p></td></tr></tbody></table></td></tr><tr><td style=\"padding: 30px 30px;\" bgcolor=\"#1e1e2c\"><table style=\"border-collapse: collapse; width: 99.4769%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td style=\"color: #ffffff; font-family: Arial, sans-serif; font-size: 14px; width: 99.8141%;\"><p style=\"margin: 0px; text-align: center;\">&reg; Tricky Code 2021</p></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table>', NULL, NULL),
(3, 'order_processing', 'Your Order Marked as Processing', '<table role=\"presentation\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td style=\"padding: 20px 0 30px 0;\"><table style=\"border-collapse: collapse; border: 1px solid #cccccc;\" border=\"0\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"><tbody><tr><td style=\"padding: 40px 0 30px 0;\" align=\"center\" bgcolor=\"#1e1e2c\"><img style=\"display: block;\" src=\"https://ultrastore.trickycode.net/company-logo.png\" alt=\"Creating Email Magic.\" width=\"80\" height=\"80\"/></td></tr><tr><td style=\"padding: 40px 30px 40px 30px;\" bgcolor=\"#ffffff\"><table style=\"border-collapse: collapse; height: 95px; width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr style=\"height: 30px;\"><td style=\"color: #153643; font-family: Arial, sans-serif; height: 30px;\"><h1 style=\"font-size: 24px; margin: 0;\">Your Order has been processed</h1></td></tr><tr style=\"height: 47px;\"><td style=\"color: #153643; font-family: Arial, sans-serif; font-size: 16px; line-height: 24px; padding: 20px 0px 30px; height: 47px;\"><p style=\"margin: 0;\">Hi {name},</p><p style=\"margin: 0;\">Your Order (Order ID:{order_id}) has been processed.</p><p style=\"margin: 0;\">&nbsp;</p><p style=\"margin: 0;\">Order ID:{order_id}</p><p style=\"margin: 0;\">Order Status:{order_status}</p><p style=\"margin: 0;\">Payment Status:{payment_status}</p><p style=\"margin: 0;\">Payment Method:{payment_method}</p><p style=\"margin: 0;\">&nbsp;</p><p style=\"margin: 0;\">Thank you for shopping with us.</p><p style=\"margin: 0;\">&nbsp;</p><p style=\"margin: 0;\">Thank You</p><p style=\"margin: 0;\">Ultra Store</p></td></tr></tbody></table></td></tr><tr><td style=\"padding: 30px 30px;\" bgcolor=\"#1e1e2c\"><table style=\"border-collapse: collapse; width: 99.4769%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td style=\"color: #ffffff; font-family: Arial, sans-serif; font-size: 14px; width: 99.8141%;\"><p style=\"margin: 0px; text-align: center;\">&reg; Tricky Code 2021</p></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table>', NULL, NULL),
(4, 'order_completed', 'Your Order Marked as Completed', '<table role=\"presentation\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td style=\"padding: 20px 0 30px 0;\"><table style=\"border-collapse: collapse; border: 1px solid #cccccc;\" border=\"0\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"><tbody><tr><td style=\"padding: 40px 0 30px 0;\" align=\"center\" bgcolor=\"#1e1e2c\"><img style=\"display: block;\" src=\"https://ultrastore.trickycode.net/company-logo.png\" alt=\"Creating Email Magic.\" width=\"80\" height=\"80\"/></td></tr><tr><td style=\"padding: 40px 30px 40px 30px;\" bgcolor=\"#ffffff\"><table style=\"border-collapse: collapse; height: 95px; width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr style=\"height: 30px;\"><td style=\"color: #153643; font-family: Arial, sans-serif; height: 30px;\"><h1 style=\"font-size: 24px; margin: 0;\">Your Order has Completed</h1></td></tr><tr style=\"height: 47px;\"><td style=\"color: #153643; font-family: Arial, sans-serif; font-size: 16px; line-height: 24px; padding: 20px 0px 30px; height: 47px;\"><p style=\"margin: 0;\">Hi {name},</p><p style=\"margin: 0;\">Your Order (Order ID:{order_id}) has completed.</p><p style=\"margin: 0;\">&nbsp;</p><p style=\"margin: 0;\">Order ID:{order_id}</p><p style=\"margin: 0;\">Order Status:{order_status}</p><p style=\"margin: 0;\">Payment Status:{payment_status}</p><p style=\"margin: 0;\">Payment Method:{payment_method}</p><p style=\"margin: 0;\">&nbsp;</p><p style=\"margin: 0;\">Thank you for shopping with us.</p><p style=\"margin: 0;\">&nbsp;</p><p style=\"margin: 0;\">Thank You</p><p style=\"margin: 0;\">Ultra Store</p></td></tr></tbody></table></td></tr><tr><td style=\"padding: 30px 30px;\" bgcolor=\"#1e1e2c\"><table style=\"border-collapse: collapse; width: 99.4769%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td style=\"color: #ffffff; font-family: Arial, sans-serif; font-size: 14px; width: 99.8141%;\"><p style=\"margin: 0px; text-align: center;\">&reg; Tricky Code 2021</p></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table>', NULL, NULL),
(5, 'order_canceled', '	Your Order Marked as Canceled', '<table role=\"presentation\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td style=\"padding: 20px 0 30px 0;\"><table style=\"border-collapse: collapse; border: 1px solid #cccccc;\" border=\"0\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"><tbody><tr><td style=\"padding: 40px 0 30px 0;\" align=\"center\" bgcolor=\"#1e1e2c\"><img style=\"display: block;\" src=\"https://ultrastore.trickycode.net/company-logo.png\" alt=\"Creating Email Magic.\" width=\"80\" height=\"80\"/></td></tr><tr><td style=\"padding: 40px 30px 40px 30px;\" bgcolor=\"#ffffff\"><table style=\"border-collapse: collapse; height: 95px; width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr style=\"height: 30px;\"><td style=\"color: #153643; font-family: Arial, sans-serif; height: 30px;\"><h1 style=\"font-size: 24px; margin: 0;\">Your Order has been canceled</h1></td></tr><tr style=\"height: 47px;\"><td style=\"color: #153643; font-family: Arial, sans-serif; font-size: 16px; line-height: 24px; padding: 20px 0px 30px; height: 47px;\"><p style=\"margin: 0;\">Hi {name},</p><p style=\"margin: 0;\">Your Order (Order ID:{order_id}) has been canceled.</p><p style=\"margin: 0;\">&nbsp;</p><p style=\"margin: 0;\">Order ID:{order_id}</p><p style=\"margin: 0;\">Order Status:{order_status}</p><p style=\"margin: 0;\">Payment Status:{payment_status}</p><p style=\"margin: 0;\">Payment Method:{payment_method}</p><p style=\"margin: 0;\">&nbsp;</p><p style=\"margin: 0;\">Thank you for shopping with us.</p><p style=\"margin: 0;\">&nbsp;</p><p style=\"margin: 0;\">Thank You</p><p style=\"margin: 0;\">Ultra Store</p></td></tr></tbody></table></td></tr><tr><td style=\"padding: 30px 30px;\" bgcolor=\"#1e1e2c\"><table style=\"border-collapse: collapse; width: 99.4769%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td style=\"color: #ffffff; font-family: Arial, sans-serif; font-size: 14px; width: 99.8141%;\"><p style=\"margin: 0px; text-align: center;\">&reg; Tricky Code 2021</p></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table>', NULL, NULL),
(6, 'order_on_hold', 'Your Order Marked as On Hold', '<table role=\"presentation\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td style=\"padding: 20px 0 30px 0;\"><table style=\"border-collapse: collapse; border: 1px solid #cccccc;\" border=\"0\" width=\"600\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"><tbody><tr><td style=\"padding: 40px 0 30px 0;\" align=\"center\" bgcolor=\"#1e1e2c\"><img style=\"display: block;\" src=\"https://ultrastore.trickycode.net/company-logo.png\" alt=\"Creating Email Magic.\" width=\"80\" height=\"80\"/></td></tr><tr><td style=\"padding: 40px 30px 40px 30px;\" bgcolor=\"#ffffff\"><table style=\"border-collapse: collapse; height: 95px; width: 100%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr style=\"height: 30px;\"><td style=\"color: #153643; font-family: Arial, sans-serif; height: 30px;\"><h1 style=\"font-size: 24px; margin: 0;\">Your Order Marked as On Hold</h1></td></tr><tr style=\"height: 47px;\"><td style=\"color: #153643; font-family: Arial, sans-serif; font-size: 16px; line-height: 24px; padding: 20px 0px 30px; height: 47px;\"><p style=\"margin: 0;\">Hi {name},</p><p style=\"margin: 0;\">Your Order (Order ID:{order_id}) has been hold.</p><p style=\"margin: 0;\">&nbsp;</p><p style=\"margin: 0;\">Order ID:{order_id}</p><p style=\"margin: 0;\">Order Status:{order_status}</p><p style=\"margin: 0;\">Payment Status:{payment_status}</p><p style=\"margin: 0;\">Payment Method:{payment_method}</p><p style=\"margin: 0;\">&nbsp;</p><p style=\"margin: 0;\">Thank you for shopping with us.</p><p style=\"margin: 0;\">&nbsp;</p><p style=\"margin: 0;\">Thank You</p><p style=\"margin: 0;\">Ultra Store</p></td></tr></tbody></table></td></tr><tr><td style=\"padding: 30px 30px;\" bgcolor=\"#1e1e2c\"><table style=\"border-collapse: collapse; width: 99.4769%;\" border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td style=\"color: #ffffff; font-family: Arial, sans-serif; font-size: 14px; width: 99.8141%;\"><p style=\"margin: 0px; text-align: center;\">&reg; Tricky Code 2021</p></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table>', NULL, NULL),
(7, 'order_refunded', 'Money Refunded', '<p>Your Order Money has been refunded.</p>', NULL, NULL);

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

--
-- Table structure for table `entity_files`
--

CREATE TABLE `entity_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `media_id` bigint(20) UNSIGNED NOT NULL,
  `entity_type` varchar(191) NOT NULL,
  `entity_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) 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 `entity_files`
--

INSERT INTO `entity_files` (`id`, `media_id`, `entity_type`, `entity_id`, `name`, `created_at`, `updated_at`) VALUES
(2, 2, 'App\\Entity\\Product\\Product', 2, 'product_image', '2023-03-02 19:10:46', '2023-03-02 19:10:46'),
(3, 2, 'App\\Entity\\Product\\Product', 1, 'product_image', '2023-03-02 19:10:59', '2023-03-02 19:10:59'),
(4, 2, 'App\\Entity\\Product\\Product', 3, 'product_image', '2023-03-02 19:12:17', '2023-03-02 19:12:17'),
(5, 2, 'App\\Entity\\Product\\Product', 4, 'product_image', '2023-03-02 19:12:18', '2023-03-02 19:12:18'),
(6, 2, 'App\\Entity\\Product\\Product', 5, 'product_image', '2023-03-02 19:13:24', '2023-03-02 19:13:24'),
(8, 2, 'App\\Entity\\Product\\Product', 6, 'product_image', '2023-03-03 14:58:34', '2023-03-03 14:58:34'),
(9, 2, 'App\\Entity\\Product\\Product', 7, 'product_image', '2023-03-03 14:59:22', '2023-03-03 14:59:22'),
(11, 6, 'App\\Entity\\Product\\Product', 8, 'product_image', '2023-03-03 15:01:08', '2023-03-03 15:01:08'),
(12, 5, 'App\\Entity\\Product\\Product', 9, 'product_image', '2023-03-03 15:01:44', '2023-03-03 15:01:44'),
(13, 4, 'App\\Entity\\Product\\Product', 10, 'product_image', '2023-03-03 15:02:07', '2023-03-03 15:02:07'),
(14, 3, 'App\\Entity\\Product\\Product', 11, 'product_image', '2023-03-03 15:02:28', '2023-03-03 15:02:28'),
(15, 9, 'App\\Entity\\Product\\Product', 12, 'product_image', '2023-03-03 15:06:38', '2023-03-03 15:06:38'),
(16, 7, 'App\\Entity\\Product\\Product', 13, 'product_image', '2023-03-03 15:07:07', '2023-03-03 15:07:07'),
(18, 8, 'App\\Entity\\Product\\Product', 14, 'product_image', '2023-03-03 18:57:26', '2023-03-03 18:57:26'),
(19, 8, 'App\\Entity\\Product\\Product', 14, 'gallery_images', '2023-03-03 18:57:26', '2023-03-03 18:57:26');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED 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 `media`
--

CREATE TABLE `media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `filename` varchar(191) NOT NULL,
  `file_path` varchar(191) NOT NULL,
  `file_type` varchar(191) NOT NULL,
  `file_size` varchar(191) NOT NULL,
  `file_extension` varchar(191) NOT NULL,
  `user_id` bigint(20) 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 `media`
--

INSERT INTO `media` (`id`, `filename`, `file_path`, `file_type`, `file_size`, `file_extension`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'logout.png', 'media/XTMZXN1781UDrgZTjPQFmbvKpb6EgLFNLf7TnFUY.png', 'image/png', '7623', 'png', 1, '2023-03-02 17:11:58', '2023-03-02 17:11:58'),
(2, 'Product.png', 'media/1XfrOtpGUPBWrGMkTJ3C7gnwowTWc4mdtpbQW83T.png', 'image/png', '82997', 'png', 1, '2023-03-02 19:10:42', '2023-03-02 19:10:42'),
(3, 'product-img-3.png', 'media/YfP48yJ2MghXAHLmWYi94pBnrnz72zjhDN4lAiI3.png', 'image/png', '142202', 'png', 1, '2023-03-03 15:00:35', '2023-03-03 15:00:35'),
(4, 'product-img-4.png', 'media/LjWzNUul5xjFCX3AP0Y4Copi6cGBMih6xOnmPUNz.png', 'image/png', '111644', 'png', 1, '2023-03-03 15:00:35', '2023-03-03 15:00:35'),
(5, 'product-img-1.png', 'media/c96ziXeW7ry0KnygwbbdsKmzo85OFtDqYgLWvsN9.png', 'image/png', '36439', 'png', 1, '2023-03-03 15:00:36', '2023-03-03 15:00:36'),
(6, 'product-img-2.png', 'media/jmxyFE14xKCBh8MnAEF3OUDYdFQFULy58kz7oS92.png', 'image/png', '117763', 'png', 1, '2023-03-03 15:00:38', '2023-03-03 15:00:38'),
(7, 'product-img-7.jpg', 'media/qiSZIrNBDVgETgHEXtCNEu78hm4oBewzeM2GOSQI.jpg', 'image/jpeg', '66896', 'jpg', 1, '2023-03-03 15:06:23', '2023-03-03 15:06:23'),
(8, 'product-img-6.jpg', 'media/d75VROQNIdAqdj1VadAoOsPYyFQpIdNycXGXygDB.jpg', 'image/jpeg', '48107', 'jpg', 1, '2023-03-03 15:06:29', '2023-03-03 15:06:29'),
(9, 'product-img-5.jpg', 'media/sq0FQa7IgY6luD7qmMbM6rrQXdHFEPH8AUlf88u3.jpg', 'image/jpeg', '86228', 'jpg', 1, '2023-03-03 15:06:33', '2023-03-03 15:06:33');

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

--
-- Table structure for table `meta_data`
--

CREATE TABLE `meta_data` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `entity_type` varchar(191) NOT NULL,
  `entity_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 `meta_data`
--

INSERT INTO `meta_data` (`id`, `entity_type`, `entity_id`, `created_at`, `updated_at`) VALUES
(1, 'App\\Entity\\Page\\Page', 1, '2023-03-02 16:01:50', '2023-03-02 16:01:50'),
(2, 'App\\Entity\\Product\\Product', 1, '2023-03-02 17:12:02', '2023-03-02 17:12:02'),
(3, 'App\\Entity\\Product\\Product', 2, '2023-03-02 19:10:46', '2023-03-02 19:10:46'),
(4, 'App\\Entity\\Product\\Product', 3, '2023-03-02 19:12:17', '2023-03-02 19:12:17'),
(5, 'App\\Entity\\Product\\Product', 4, '2023-03-02 19:12:18', '2023-03-02 19:12:18'),
(6, 'App\\Entity\\Product\\Product', 5, '2023-03-02 19:13:24', '2023-03-02 19:13:24'),
(7, 'App\\Entity\\Page\\Page', 12, '2023-03-02 20:51:00', '2023-03-02 20:51:00'),
(8, 'App\\Entity\\Page\\Page', 13, '2023-03-02 20:56:49', '2023-03-02 20:56:49'),
(9, 'App\\Entity\\Page\\Page', 5, '2023-03-02 20:59:17', '2023-03-02 20:59:17'),
(10, 'App\\Entity\\Page\\Page', 14, '2023-03-02 21:01:29', '2023-03-02 21:01:29'),
(11, 'App\\Entity\\Page\\Page', 6, '2023-03-02 21:02:38', '2023-03-02 21:02:38'),
(13, 'App\\Entity\\Page\\Page', 16, '2023-03-02 21:17:49', '2023-03-02 21:17:49'),
(14, 'App\\Entity\\Page\\Page', 17, '2023-03-02 21:21:27', '2023-03-02 21:21:27'),
(15, 'App\\Entity\\Page\\Page', 11, '2023-03-02 21:26:52', '2023-03-02 21:26:52'),
(16, 'App\\Entity\\Product\\Product', 6, '2023-03-03 14:58:04', '2023-03-03 14:58:04'),
(17, 'App\\Entity\\Product\\Product', 7, '2023-03-03 14:59:22', '2023-03-03 14:59:22'),
(18, 'App\\Entity\\Product\\Product', 8, '2023-03-03 15:00:48', '2023-03-03 15:00:48'),
(19, 'App\\Entity\\Product\\Product', 9, '2023-03-03 15:01:32', '2023-03-03 15:01:32'),
(20, 'App\\Entity\\Product\\Product', 10, '2023-03-03 15:02:07', '2023-03-03 15:02:07'),
(21, 'App\\Entity\\Product\\Product', 11, '2023-03-03 15:02:28', '2023-03-03 15:02:28'),
(22, 'App\\Entity\\Product\\Product', 12, '2023-03-03 15:06:38', '2023-03-03 15:06:38'),
(23, 'App\\Entity\\Product\\Product', 13, '2023-03-03 15:07:07', '2023-03-03 15:07:07'),
(24, 'App\\Entity\\Product\\Product', 14, '2023-03-03 15:07:42', '2023-03-03 15:07:42');

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

--
-- Table structure for table `meta_data_translations`
--

CREATE TABLE `meta_data_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `meta_data_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `meta_title` varchar(191) DEFAULT NULL,
  `meta_keywords` text DEFAULT NULL,
  `meta_description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `meta_data_translations`
--

INSERT INTO `meta_data_translations` (`id`, `meta_data_id`, `locale`, `meta_title`, `meta_keywords`, `meta_description`) VALUES
(1, 1, 'English', NULL, NULL, NULL),
(2, 2, 'English', NULL, NULL, NULL),
(3, 3, 'English', NULL, NULL, NULL),
(4, 4, 'English', NULL, NULL, NULL),
(5, 5, 'English', NULL, NULL, NULL),
(6, 6, 'English', NULL, NULL, NULL),
(7, 7, 'English', NULL, NULL, NULL),
(8, 8, 'English', NULL, NULL, NULL),
(9, 9, 'English', NULL, NULL, NULL),
(10, 10, 'English', NULL, NULL, NULL),
(11, 11, 'English', NULL, NULL, NULL),
(13, 13, 'English', NULL, NULL, NULL),
(14, 14, 'English', NULL, NULL, NULL),
(15, 15, 'English', NULL, NULL, NULL),
(16, 16, 'English', NULL, NULL, NULL),
(17, 17, 'English', NULL, NULL, NULL),
(18, 18, 'English', NULL, NULL, NULL),
(19, 19, 'English', NULL, NULL, NULL),
(20, 20, 'English', NULL, NULL, NULL),
(21, 21, 'English', NULL, NULL, NULL),
(22, 22, 'English', NULL, NULL, NULL),
(23, 23, 'English', NULL, NULL, NULL),
(24, 24, 'English', NULL, NULL, NULL);

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) 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, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2018_11_12_152015_create_email_templates_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_09_01_080940_create_settings_table', 1),
(6, '2020_07_02_145857_create_database_backups_table', 1),
(7, '2020_07_06_142817_create_roles_table', 1),
(8, '2020_07_06_143240_create_permissions_table', 1),
(9, '2020_07_25_061549_create_currency_table', 1),
(10, '2020_07_29_095329_create_tax_classes_table', 1),
(11, '2020_07_29_095340_create_tax_classes_translation_table', 1),
(12, '2020_07_29_095348_create_tax_rates_table', 1),
(13, '2020_07_29_095357_create_tax_rates_translation_table', 1),
(14, '2020_07_30_074942_create_media_table', 1),
(15, '2020_07_30_152834_create_tags_table', 1),
(16, '2020_07_30_153031_create_tags_translation_table', 1),
(17, '2020_07_31_135138_create_brands_table', 1),
(18, '2020_07_31_140257_create_brands_translation_table', 1),
(19, '2020_07_31_145819_create_entity_files_table', 1),
(20, '2020_08_11_135105_create_category_table', 1),
(21, '2020_08_11_135531_create_category_translation_table', 1),
(22, '2020_08_23_160650_create_products_table', 1),
(23, '2020_08_23_161219_create_product_translations_table', 1),
(24, '2020_08_23_163548_create_product_categories_table', 1),
(25, '2020_08_23_163600_create_product_tags_table', 1),
(26, '2020_08_24_152430_create_product_variations_table', 1),
(27, '2020_08_24_152831_create_product_variation_items_table', 1),
(28, '2020_08_24_171314_create_product_variation_prices_table', 1),
(29, '2020_08_24_171315_create_coupons_table', 1),
(30, '2020_08_24_171316_create_coupon_translations_table', 1),
(31, '2020_08_24_171317_create_coupon_products_table', 1),
(32, '2020_08_24_171318_create_coupon_categories_table', 1),
(33, '2020_08_24_171319_create_meta_data_table', 1),
(34, '2020_08_24_171320_create_meta_data_translations_table', 1),
(35, '2020_09_02_145504_create_pages_table', 1),
(36, '2020_09_02_145952_create_page_translations_table', 1),
(37, '2020_09_04_084255_create_navigations_table', 1),
(38, '2020_09_04_084515_create_navigation_items_table', 1),
(39, '2020_09_04_084719_create_navigation_item_translations_table', 1),
(40, '2020_11_08_153213_create_customer_addresses_table', 1),
(41, '2020_11_11_172141_create_orders_table', 1),
(42, '2020_11_11_172303_create_order_products_table', 1),
(43, '2020_11_11_172521_create_order_taxes_table', 1),
(44, '2020_11_13_142034_create_transactions_table', 1),
(45, '2021_01_22_171533_create_wish_lists_table', 1),
(46, '2021_01_24_064834_create_product_comments_table', 1),
(47, '2021_01_27_104627_create_product_reviews_table', 1),
(48, '2021_03_22_071324_create_setting_translations', 1),
(49, '2021_04_26_071834_add_city_to_customer_addresses_table', 1),
(50, '2021_04_26_074440_change_exchange_rate_length_to_currency_table', 1),
(51, '2023_03_06_164042_create_blogs_table', 2);

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

--
-- Table structure for table `navigations`
--

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

INSERT INTO `navigations` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Primary Menu', 1, '2020-11-16 12:30:14', '2021-03-17 06:54:42'),
(2, 'Category Menu', 1, '2021-03-17 06:55:09', '2021-03-17 06:55:09'),
(3, 'Footer Menu 1', 1, '2021-03-17 12:47:10', '2021-03-17 12:47:10'),
(4, 'Footer Menu 2', 1, '2021-03-17 13:34:08', '2021-03-17 13:34:08');

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

--
-- Table structure for table `navigation_items`
--

CREATE TABLE `navigation_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `navigation_id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(20) NOT NULL,
  `page_id` bigint(20) UNSIGNED DEFAULT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `url` varchar(191) DEFAULT NULL,
  `icon` varchar(191) DEFAULT NULL,
  `target` varchar(191) NOT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `position` int(10) UNSIGNED DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `css_class` varchar(191) DEFAULT NULL,
  `css_id` varchar(191) 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 `navigation_items`
--

INSERT INTO `navigation_items` (`id`, `navigation_id`, `type`, `page_id`, `category_id`, `url`, `icon`, `target`, `parent_id`, `position`, `status`, `css_class`, `css_id`, `created_at`, `updated_at`) VALUES
(1, 1, 'page', 13, NULL, '/reviews', NULL, '_self', NULL, 1, 1, NULL, NULL, '2021-03-15 15:58:36', '2023-03-03 15:36:43'),
(2, 1, 'page', 5, NULL, '/faq', NULL, '_self', NULL, 2, 1, NULL, NULL, '2021-03-15 15:59:23', '2023-03-03 15:36:49'),
(3, 1, 'page', 14, NULL, '/blogs', NULL, '_self', NULL, 3, 1, NULL, NULL, '2021-03-15 15:59:37', '2023-03-03 15:37:00'),
(4, 1, 'page', 16, NULL, '/wholesale', NULL, '_self', NULL, 4, 1, NULL, NULL, '2021-03-15 15:59:59', '2023-03-03 15:37:06'),
(5, 1, 'page', 1, NULL, NULL, NULL, '_self', NULL, 5, 1, NULL, NULL, '2021-03-15 16:00:13', '2023-03-03 15:37:12'),
(30, 3, 'page', 1, NULL, NULL, NULL, '_self', NULL, 1, 1, NULL, NULL, '2021-03-17 12:47:37', '2021-03-17 12:56:21'),
(31, 3, 'page', 5, NULL, NULL, NULL, '_self', NULL, 2, 1, NULL, NULL, '2021-03-17 12:47:51', '2021-03-17 12:56:21'),
(32, 3, 'page', 6, NULL, NULL, NULL, '_self', NULL, 3, 1, NULL, NULL, '2021-03-17 12:48:06', '2021-03-17 12:56:21'),
(33, 3, 'page', 2, NULL, NULL, NULL, '_self', NULL, 5, 1, NULL, NULL, '2021-03-17 12:53:24', '2021-03-17 12:56:22'),
(34, 3, 'custom_url', 10, NULL, '/blogs', NULL, '_self', NULL, 4, 1, NULL, NULL, '2021-03-17 12:56:16', '2023-03-07 13:45:20'),
(35, 4, 'page', 7, NULL, NULL, NULL, '_self', NULL, 9999, 1, NULL, NULL, '2021-03-17 13:36:27', '2021-03-17 13:36:27'),
(36, 4, 'page', 8, NULL, NULL, NULL, '_self', NULL, 9999, 1, NULL, NULL, '2021-03-17 13:36:46', '2021-03-17 13:36:46'),
(37, 4, 'page', 9, NULL, NULL, NULL, '_self', NULL, 9999, 1, NULL, NULL, '2021-03-17 13:37:00', '2021-03-17 13:37:00'),
(38, 4, 'page', 11, NULL, NULL, NULL, '_self', NULL, 9999, 1, NULL, NULL, '2021-03-17 13:37:53', '2021-03-17 13:37:53'),
(42, 1, 'page', 2, NULL, NULL, NULL, '_self', NULL, 6, 1, NULL, NULL, '2023-03-03 15:28:15', '2023-03-03 15:29:44'),
(43, 1, 'page', 6, NULL, NULL, NULL, '_self', NULL, 7, 1, NULL, NULL, '2023-03-03 15:28:47', '2023-03-03 15:29:44'),
(44, 1, 'page', 11, NULL, NULL, NULL, '_self', NULL, 8, 1, NULL, NULL, '2023-03-03 15:29:09', '2023-03-03 15:29:44'),
(45, 1, 'page', 17, NULL, NULL, NULL, '_self', NULL, 9, 1, NULL, NULL, '2023-03-03 15:29:26', '2023-03-03 15:29:44');

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

--
-- Table structure for table `navigation_item_translations`
--

CREATE TABLE `navigation_item_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `navigation_item_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `name` varchar(191) 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 `navigation_item_translations`
--

INSERT INTO `navigation_item_translations` (`id`, `navigation_item_id`, `locale`, `name`, `created_at`, `updated_at`) VALUES
(1, 1, 'English', 'Reviews', '2021-03-15 15:58:36', '2023-03-03 15:24:51'),
(2, 2, 'English', 'FAQ', '2021-03-15 15:59:23', '2023-03-03 15:25:12'),
(3, 3, 'English', 'Blog', '2021-03-15 15:59:37', '2023-03-03 15:25:30'),
(4, 4, 'English', 'Wholesale', '2021-03-15 15:59:59', '2023-03-03 15:25:57'),
(5, 5, 'English', 'About Us', '2021-03-15 16:00:13', '2023-03-03 15:27:54'),
(30, 30, 'English', 'About Us', '2021-03-17 12:47:37', '2021-03-17 12:47:37'),
(31, 31, 'English', 'FAQ', '2021-03-17 12:47:51', '2021-03-17 12:47:51'),
(32, 32, 'English', 'Terms & Conditions', '2021-03-17 12:48:06', '2021-03-17 12:48:06'),
(33, 33, 'English', 'Contact Us', '2021-03-17 12:53:24', '2021-03-17 12:53:24'),
(34, 34, 'English', 'Blogs', '2021-03-17 12:56:16', '2023-03-07 13:45:20'),
(35, 35, 'English', 'Payment Methods', '2021-03-17 13:36:27', '2021-03-17 13:36:27'),
(36, 36, 'English', 'Money Back', '2021-03-17 13:36:46', '2021-03-17 13:36:46'),
(37, 37, 'English', 'Return', '2021-03-17 13:37:00', '2021-03-17 13:37:00'),
(38, 38, 'English', 'Shipping', '2021-03-17 13:37:53', '2021-03-17 13:37:53'),
(42, 42, 'English', 'Contact US', '2023-03-03 15:28:15', '2023-03-03 15:28:15'),
(43, 43, 'English', 'Terms & Conditions', '2023-03-03 15:28:48', '2023-03-03 15:28:48'),
(44, 44, 'English', 'Shipping', '2023-03-03 15:29:09', '2023-03-03 15:29:09'),
(45, 45, 'English', 'Order Management', '2023-03-03 15:29:26', '2023-03-03 15:29:26');

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

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

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `customer_name` varchar(191) NOT NULL,
  `customer_email` varchar(191) NOT NULL,
  `customer_phone` varchar(191) NOT NULL,
  `billing_name` varchar(191) NOT NULL,
  `billing_city` varchar(191) DEFAULT NULL,
  `billing_state` varchar(191) NOT NULL,
  `billing_post_code` varchar(191) NOT NULL,
  `billing_country` varchar(191) NOT NULL,
  `billing_address` text NOT NULL,
  `shipping_name` varchar(191) NOT NULL,
  `shipping_city` varchar(191) DEFAULT NULL,
  `shipping_state` varchar(191) NOT NULL,
  `shipping_post_code` varchar(191) NOT NULL,
  `shipping_country` varchar(191) NOT NULL,
  `shipping_address` text NOT NULL,
  `sub_total` decimal(10,2) UNSIGNED NOT NULL,
  `shipping_method` varchar(191) NOT NULL,
  `shipping_cost` decimal(10,2) UNSIGNED NOT NULL,
  `coupon_id` bigint(20) DEFAULT NULL,
  `discount` decimal(10,2) UNSIGNED NOT NULL,
  `total` decimal(10,2) UNSIGNED NOT NULL,
  `payment_method` varchar(191) DEFAULT NULL,
  `currency` varchar(191) NOT NULL,
  `currency_rate` decimal(10,2) DEFAULT NULL,
  `locale` varchar(191) NOT NULL,
  `status` varchar(30) NOT NULL,
  `note` 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 `orders`
--

INSERT INTO `orders` (`id`, `customer_id`, `customer_name`, `customer_email`, `customer_phone`, `billing_name`, `billing_city`, `billing_state`, `billing_post_code`, `billing_country`, `billing_address`, `shipping_name`, `shipping_city`, `shipping_state`, `shipping_post_code`, `shipping_country`, `shipping_address`, `sub_total`, `shipping_method`, `shipping_cost`, `coupon_id`, `discount`, `total`, `payment_method`, `currency`, `currency_rate`, `locale`, `status`, `note`, `created_at`, `updated_at`) VALUES
(1, 1, 'Admin', 'admin@gmail.com', '120120000', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', '12.00', 'local', '100.00', NULL, '0.00', '112.00', NULL, 'USD', '0.00', 'English', 'pending_payment', NULL, '2023-03-03 20:49:22', '2023-03-03 20:49:22'),
(2, 1, 'Admin', 'admin@gmail.com', '120120000', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', '350.00', 'local', '100.00', NULL, '0.00', '450.00', NULL, 'USD', '0.00', 'English', 'pending_payment', NULL, '2023-03-03 21:31:23', '2023-03-03 21:31:23'),
(3, 1, 'Admin', 'admin@gmail.com', '120120000', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', '12.00', 'local', '100.00', NULL, '0.00', '112.00', NULL, 'USD', '0.00', 'English', 'pending_payment', NULL, '2023-03-03 21:36:30', '2023-03-03 21:36:30'),
(4, 1, 'Admin', 'admin@gmail.com', '120120000', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', '12.00', 'local', '100.00', NULL, '0.00', '112.00', NULL, 'USD', '0.00', 'English', 'pending_payment', NULL, '2023-03-03 21:39:13', '2023-03-03 21:39:13'),
(5, 1, 'Admin', 'admin@gmail.com', '120120000', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', '12.00', 'local', '100.00', NULL, '0.00', '112.00', NULL, 'USD', '0.00', 'English', 'pending_payment', NULL, '2023-03-03 21:48:35', '2023-03-03 21:48:35'),
(6, 1, 'Admin', 'admin@gmail.com', '120120000', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', '12.00', 'local', '100.00', NULL, '0.00', '112.00', NULL, 'USD', '0.00', 'English', 'pending_payment', NULL, '2023-03-03 21:52:11', '2023-03-03 21:52:11'),
(7, 1, 'Admin', 'admin@gmail.com', '120120000', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', '12.00', 'local', '100.00', NULL, '0.00', '112.00', NULL, 'USD', '0.00', 'English', 'pending_payment', NULL, '2023-03-03 21:52:50', '2023-03-03 21:52:50'),
(8, 1, 'Admin', 'admin@gmail.com', '120120000', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', '12.00', 'local', '100.00', NULL, '0.00', '112.00', 'Stripe', 'USD', '0.00', 'English', 'pending', NULL, '2023-03-03 21:54:17', '2023-03-03 21:54:31'),
(9, 1, 'Admin', 'admin@gmail.com', '120120000', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', '48.00', 'local', '100.00', NULL, '0.00', '148.00', NULL, 'USD', '0.00', 'English', 'pending_payment', NULL, '2023-03-03 22:03:47', '2023-03-03 22:03:47'),
(10, 1, 'Admin', 'admin@gmail.com', '120120000', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', '12.00', 'local', '100.00', NULL, '0.00', '112.00', NULL, 'USD', '0.00', 'English', 'pending_payment', NULL, '2023-03-03 22:12:52', '2023-03-03 22:12:52'),
(11, 1, 'Admin', 'admin@gmail.com', '120120000', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', '36.00', 'local', '100.00', NULL, '0.00', '136.00', NULL, 'USD', NULL, 'English', 'pending_payment', NULL, '2023-03-03 22:41:54', '2023-03-03 22:41:54'),
(12, 1, 'Admin', 'admin@gmail.com', '120120000', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', '12.00', 'local', '100.00', NULL, '0.00', '112.00', NULL, 'USD', NULL, 'English', 'pending_payment', NULL, '2023-03-03 22:43:54', '2023-03-03 22:43:54'),
(13, 1, 'Admin', 'admin@gmail.com', '120120000', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', '399.00', 'local', '100.00', NULL, '0.00', '499.00', 'Stripe', 'USD', NULL, 'English', 'pending', NULL, '2023-03-03 22:48:08', '2023-03-03 22:48:28'),
(14, 1, 'Admin', 'admin@gmail.com', '120120000', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', 'demo', 'new york', 'Eastern', '51454', 'AS', 'new york', '58.00', 'local', '100.00', NULL, '0.00', '158.00', 'Stripe', 'USD', NULL, 'English', 'pending', NULL, '2023-03-03 22:51:26', '2023-03-03 22:51:44');

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

--
-- Table structure for table `order_products`
--

CREATE TABLE `order_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `product_attributes` text DEFAULT NULL,
  `unit_price` decimal(10,2) UNSIGNED NOT NULL,
  `qty` int(11) NOT NULL,
  `line_total` decimal(10,2) 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 `order_products`
--

INSERT INTO `order_products` (`id`, `order_id`, `product_id`, `product_attributes`, `unit_price`, `qty`, `line_total`, `created_at`, `updated_at`) VALUES
(1, 1, 8, 'a:0:{}', '12.00', 1, '12.00', '2023-03-03 20:49:22', '2023-03-03 20:49:22'),
(2, 2, 13, 'a:0:{}', '350.00', 1, '350.00', '2023-03-03 21:31:23', '2023-03-03 21:31:23'),
(3, 3, 8, 'a:0:{}', '12.00', 1, '12.00', '2023-03-03 21:36:30', '2023-03-03 21:36:30'),
(4, 4, 8, 'a:0:{}', '12.00', 1, '12.00', '2023-03-03 21:39:13', '2023-03-03 21:39:13'),
(5, 5, 8, 'a:0:{}', '12.00', 1, '12.00', '2023-03-03 21:48:35', '2023-03-03 21:48:35'),
(6, 6, 8, 'a:0:{}', '12.00', 1, '12.00', '2023-03-03 21:52:11', '2023-03-03 21:52:11'),
(7, 7, 8, 'a:0:{}', '12.00', 1, '12.00', '2023-03-03 21:52:50', '2023-03-03 21:52:50'),
(8, 8, 8, 'a:0:{}', '12.00', 1, '12.00', '2023-03-03 21:54:17', '2023-03-03 21:54:17'),
(9, 9, 8, 'a:0:{}', '12.00', 4, '48.00', '2023-03-03 22:03:47', '2023-03-03 22:03:47'),
(10, 10, 8, 'a:0:{}', '12.00', 1, '12.00', '2023-03-03 22:12:52', '2023-03-03 22:12:52'),
(11, 11, 8, 'a:0:{}', '12.00', 3, '36.00', '2023-03-03 22:41:54', '2023-03-03 22:41:54'),
(12, 12, 8, 'a:0:{}', '12.00', 1, '12.00', '2023-03-03 22:43:54', '2023-03-03 22:43:54'),
(13, 13, 14, 'a:0:{}', '399.00', 1, '399.00', '2023-03-03 22:48:08', '2023-03-03 22:48:08'),
(14, 14, 9, 'a:0:{}', '58.00', 1, '58.00', '2023-03-03 22:51:26', '2023-03-03 22:51:26');

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

--
-- Table structure for table `order_taxes`
--

CREATE TABLE `order_taxes` (
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `tax_rate_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(15,4) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(191) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `template` varchar(191) 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 `pages`
--

INSERT INTO `pages` (`id`, `slug`, `status`, `template`, `created_at`, `updated_at`) VALUES
(1, 'about-us', 1, NULL, '2021-03-15 10:28:45', '2021-03-15 10:28:45'),
(2, 'contact-us', 1, 'contact', '2021-03-15 10:29:26', '2021-03-15 10:29:26'),
(5, 'faq', 1, NULL, '2021-03-17 12:43:29', '2021-03-17 12:43:29'),
(6, 'terms-&-conditions', 1, NULL, '2021-03-17 12:45:00', '2021-03-17 12:45:00'),
(7, 'payment-methods', 1, NULL, '2021-03-17 12:46:06', '2021-03-17 12:46:06'),
(8, 'money-back', 1, NULL, '2021-03-17 12:46:23', '2021-03-17 12:46:23'),
(9, 'returns', 1, NULL, '2021-03-17 12:46:38', '2021-03-17 12:46:38'),
(10, 'privacy-policy', 1, NULL, '2021-03-17 12:46:52', '2021-03-17 12:46:52'),
(11, 'shipping', 1, NULL, '2021-03-17 13:37:25', '2021-03-17 13:37:25'),
(12, 'coming-soon', 1, NULL, '2023-03-02 20:51:00', '2023-03-02 20:51:00'),
(13, 'reviews', 0, NULL, '2023-03-02 20:56:49', '2023-03-06 22:49:32'),
(14, 'blogs', 0, NULL, '2023-03-02 21:01:29', '2023-03-07 14:29:54'),
(16, 'wholesale', 1, NULL, '2023-03-02 21:17:49', '2023-03-02 21:17:49'),
(17, 'order-management', 1, NULL, '2023-03-02 21:21:27', '2023-03-02 21:21:27');

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

--
-- Table structure for table `page_translations`
--

CREATE TABLE `page_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `page_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `title` text NOT NULL,
  `body` longtext 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 `page_translations`
--

INSERT INTO `page_translations` (`id`, `page_id`, `locale`, `title`, `body`, `created_at`, `updated_at`) VALUES
(1, 1, 'English', 'About US', '\r\n<div class=\"banner banner--mini\">\r\n<div class=\"banner__bg wow fadeInUpBig\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/banner-bg-1.png\" alt=\"image\" /></div>\r\n<div class=\"container wow zoomIn\" data-wow-delay=\"750ms\">\r\n<div class=\"row\">\r\n<div class=\"col-12\">\r\n<div class=\"banner__content section-content section-content--light\">\r\n<h3 class=\"heading\">About Us</h3>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"section py-5 my-5\">\r\n<div class=\"container\">\r\n<div class=\"row align-items-center justify-content-center\">\r\n<div class=\"col-12 col-lg-5 wow zoomInDown\">\r\n<div class=\"section-img\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/about-img-2.png\" alt=\"image\" /></div>\r\n</div>\r\n<div class=\"col-12 col-lg-6 wow fadeInRightBig\">\r\n<div class=\"section-content\">\r\n<h2 class=\"heading\">Your Heading goes here</h2>\r\n<p>Lorem ipsum dolor sit amet consectetur adipisicing elit. Temporibus, ab? Voluptate vero asperiores culpa error ipsum ut sed minima expedita aperiam atque tempora itaque, laborum ipsa dolor, obcaecati amet qui aut reprehenderit in laudantium ipsam. Vel, labore quod. Amet quibusdam provident distinctio! Maiores, voluptate. Facere maiores saepe repellat praesentium omnis?</p>\r\n<a class=\"themeBtn themeBtn--rounded\" href=\"#\">Learn More</a></div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"section pb-5 my-5 cta-about\">\r\n<div class=\"about-bg section__bg--75 wow fadeInUp\">&nbsp;</div>\r\n<div class=\"container pt-5\">\r\n<div class=\"row justify-content-center\">\r\n<div class=\"col-12 col-lg-9 wow zoomInUp\">\r\n<div class=\"section-content text-center\">\r\n<h2 class=\"heading\">What we do?</h2>\r\n<p>Lorem ipsum dolor sit amet consectetur adipisicing elit. Temporibus, ab? Voluptate vero asperiores culpa error ipsum ut sed minima expedita aperiam atque tempora itaque, laborum ipsa dolor, obcaecati amet qui aut reprehenderit in laudantium ipsam. Vel, labore quod. Amet quibusdam provident distinctio! Maiores, voluptate. Facere maiores saepe repellat praesentium omnis?</p>\r\n</div>\r\n</div>\r\n<div class=\"col-12 wow fadeInDownBig\">\r\n<div class=\"section-img\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/about-img-1.png\" alt=\"image\" /></div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', '2021-03-15 10:28:46', '2023-03-02 16:01:50'),
(2, 2, 'English', 'Contact Us', NULL, '2021-03-15 10:29:26', '2021-03-15 10:29:26'),
(5, 5, 'English', 'FAQ', '\r\n<div class=\"banner banner--mini\">\r\n<div class=\"banner__bg wow fadeInUpBig\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/banner-bg-1.png\" alt=\"image\" /></div>\r\n<div class=\"container wow zoomIn\" data-wow-delay=\"750ms\">\r\n<div class=\"row\">\r\n<div class=\"col-12\">\r\n<div class=\"banner__content section-content section-content--light\">\r\n<h3 class=\"heading\">FAQs</h3>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"container py-5  my-5 wow zoomIn\">\r\n<div class=\"row justify-content-center\">\r\n<div class=\"col-12 col-lg-9\">\r\n<div class=\"section-content text-center\">\r\n<div class=\"heading\">Frequently Asked questions</div>\r\n<p>Lorem ipsum dolor sit, amet consectetur adipisicing elit. Molestias ipsa minima exercitationem ducimus corrupti ipsum voluptatem itaque laborum fugiat ratione.</p>\r\n</div>\r\n</div>\r\n<div class=\"col-lg-12\">\r\n<div id=\"accordionExample\" class=\"accordion\">\r\n<div class=\"card\">\r\n<div id=\"headingOne\" class=\"card-header\">\r\n<h2 class=\"mb-0\"><button class=\"btn btn-link btn-block text-left\" type=\"button\" data-toggle=\"collapse\" data-target=\"#collapseOne\" aria-expanded=\"true\" aria-controls=\"collapseOne\"> 1. Are you hiring? </button></h2>\r\n</div>\r\n<div id=\"collapseOne\" class=\"collapse show\" aria-labelledby=\"headingOne\" data-parent=\"#accordionExample\">\r\n<div class=\"card-body\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s,</div>\r\n</div>\r\n</div>\r\n<div class=\"card\">\r\n<div id=\"headingTwo\" class=\"card-header\">\r\n<h2 class=\"mb-0\"><button class=\"btn btn-link btn-block text-left collapsed\" type=\"button\" data-toggle=\"collapse\" data-target=\"#collapseTwo\" aria-expanded=\"false\" aria-controls=\"collapseTwo\"> 2. Where can I buy Saint Accessories locally? </button></h2>\r\n</div>\r\n<div id=\"collapseTwo\" class=\"collapse\" aria-labelledby=\"headingTwo\" data-parent=\"#accordionExample\">\r\n<div class=\"card-body\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s,</div>\r\n</div>\r\n</div>\r\n<div class=\"card\">\r\n<div id=\"headingThree\" class=\"card-header\">\r\n<h2 class=\"mb-0\"><button class=\"btn btn-link btn-block text-left collapsed\" type=\"button\" data-toggle=\"collapse\" data-target=\"#collapseThree\" aria-expanded=\"false\" aria-controls=\"collapseThree\"> 3. Is your packaging discreet? </button></h2>\r\n</div>\r\n<div id=\"collapseThree\" class=\"collapse\" aria-labelledby=\"headingThree\" data-parent=\"#accordionExample\">\r\n<div class=\"card-body\">Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s,</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n                                          </div>\r\n</div>', '2021-03-17 12:43:29', '2023-03-07 14:33:06'),
(6, 6, 'English', 'Terms & Conditions', '\r\n<div class=\"banner banner--mini\">\r\n<div class=\"banner__bg wow fadeInUpBig\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/banner-bg-1.png\" alt=\"image\" /></div>\r\n<div class=\"container wow zoomIn\" data-wow-delay=\"750ms\">\r\n<div class=\"row\">\r\n<div class=\"col-12\">\r\n<div class=\"banner__content section-content section-content--light\">\r\n<h3 class=\"heading sub-title-content\">Terms &amp; Conditions</h3>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"section pt-5  wow zoomIn\">\r\n<div class=\"container\">\r\n<div class=\"row align-items-center justify-content-center\">\r\n<div class=\"col-12 wow fadeInRightBig\">\r\n<div class=\"section-content\">\r\n<h2 class=\"heading sub-title-content\">Terms &amp; Conditions</h2>\r\n<p>This website is operated by Saints Accessories . Throughout the site, the terms &ldquo;we&rdquo;, &ldquo;us&rdquo; and &ldquo;our&rdquo; refer to Saints Accessories. Saints Accessories offers this website, including all information, tools and services available from this site to you, the user, conditioned upon your acceptance of all terms, conditions, policies and notices stated here.</p>\r\n<p>By visiting our site and/ or purchasing something from us, you engage in our &ldquo;Service&rdquo; and agree to be bound by the following terms and conditions (&ldquo;Terms of Service&rdquo;, &ldquo;Terms&rdquo;), including those additional terms and conditions and policies referenced herein and/or available by hyperlink. These Terms of Service apply to all users of the site, including without limitation users who are browsers, vendors, customers, merchants, and/ or contributors of content.</p>\r\n<p>Please read these Terms of Service carefully before accessing or using our website. By accessing or using any part of the site, you agree to be bound by these Terms of Service. If you do not agree to all the terms and conditions of this agreement, then you may not access the website or use any services. If these Terms of Service are considered an offer, acceptance is expressly limited to these Terms of Service.</p>\r\n<p>Any new features or tools which are added to the current store shall also be subject to the Terms of Service. You can review the most current version of the Terms of Service at any time on this page. We reserve the right to update, change or replace any part of these Terms of Service by posting updates and/or changes to our website. It is your responsibility to check this page periodically for changes. Your continued use of or access to the website following the posting of any changes constitutes acceptance of those changes</p>\r\n<h2 class=\"heading1 sub-title-content mt-5\">ONLINE STORE TERMS</h2>\r\n<p>By agreeing to these Terms of Service, you represent that you are at least the age of majority in your state or province of residence, or that you are the age of majority in your state or province of residence and you have given us your consent to allow any of your minor dependents to use this site.</p>\r\n<p>You may not use our products for any illegal or unauthorized purpose nor may you, in the use of the Service, violate any laws in your jurisdiction (including but not limited to copyright laws).</p>\r\n<p>You must not transmit any worms or viruses or any code of a destructive nature. A breach or violation of any of the Terms will result in an immediate termination of your Services.</p>\r\n</div>\r\n</div>\r\n<div class=\"col-12 wow fadeInLeftBig\">\r\n<div class=\"section-content\">\r\n<h2 class=\"heading1 sub-title-content\">GENERAL CONDITIONS</h2>\r\n<p>We reserve the right to refuse service to anyone for any reason at any time.</p>\r\n<p>You understand that your content (not including credit card information), may be transferred unencrypted and involve (a) transmissions over various networks; and (b) changes to conform and adapt to technical requirements of connecting networks or devices. Credit card information is always encrypted during transfer over networks.</p>\r\n<p>You agree not to reproduce, duplicate, copy, sell, resell or exploit any portion of the Service, use of the Service, or access to the Service or any contact on the website through which the service is provided, without express written permission by us. The heading sub-title-contents used in this agreement are included for convenience only and will not limit or otherwise affect these Terms.</p>\r\n<h2 class=\"heading1 sub-title-content mt-5\">ACCURACY, COMPLETENESS AND TIMELINESS OF INFORMATION</h2>\r\n<p>We are not responsible if information made available on this site is not accurate, complete or current. The material on this site is provided for general information only and should not be relied upon or used as the sole basis for making decisions without consulting primary, more accurate, more complete or more timely sources of information. Any reliance on the material on this site is at your own risk.</p>\r\n<p>This site may contain certain historical information. Historical information, necessarily, is not current and is provided for your reference only. We reserve the right to modify the contents of this site at any time, but we have no obligation to update any information on our site. You agree that it is your responsibility to monitor changes to our site.</p>\r\n</div>\r\n</div>\r\n<div class=\"col-12 wow fadeInRightBig\">\r\n<div class=\"section-content\">\r\n<h2 class=\"heading1 sub-title-content\">MODIFICATIONS TO THE SERVICE AND PRICES</h2>\r\n<p>Prices for our products are subject to change without notice.</p>\r\n<p>We reserve the right at any time to modify or discontinue the Service (or any part or content thereof) without notice at any time.We shall not be liable to you or to any third-party for any modification, price change, suspension or discontinuance of the Service</p>\r\n<h2 class=\"heading1 sub-title-content mt-5\">PRODUCTS OR SERVICES (if applicable)</h2>\r\n<p>Certain products or services may be available exclusively online through the website. These products or services may have limited quantities and are subject to return or exchange only according to our Return Policy</p>\r\n<p>We have made every effort to display as accurately as possible the colors and images of our products that appear at the store. We cannot guarantee that your computer monitor&rsquo;s display of any color will be accurate.</p>\r\n<p>We reserve the right, but are not obligated, to limit the sales of our products or Services to any person, geographic region or jurisdiction. We may exercise this right on a case-by-case basis. We reserve the right to limit the quantities of any products or services that we offer. All descriptions of products or product pricing are subject to change at anytime without notice, at the sole discretion of us. We reserve the right to discontinue any product at any time. Any offer for any product or service made on this site is void where prohibited.</p>\r\n<p>We do not warrant that the quality of any products, services, information, or other material purchased or obtained by you will meet your expectations, or that any errors in the Service will be corrected.</p>\r\n</div>\r\n</div>\r\n<div class=\"col-12 wow fadeInLeftBig\">\r\n<div class=\"section-content\">\r\n<h2 class=\"heading1 sub-title-content\">ACCURACY OF BILLING AND ACCOUNT INFORMATION</h2>\r\n<p>We reserve the right to refuse any order you place with us. We may, in our sole discretion, limit or cancel quantities purchased per person, per household or per order. These restrictions may include orders placed by or under the same customer account, the same credit card, and/or orders that use the same billing and/or shipping address. In the event that we make a change to or cancel an order, we may attempt to notify you by contacting the e-mail and/or billing address/phone number provided at the time the order was made. We reserve the right to limit or prohibit orders that, in our sole judgment, appear to be placed by dealers, resellers or distributors.</p>\r\n<p>You agree to provide current, complete and accurate purchase and account information for all purchases made at our store. You agree to promptly update your account and other information, including your email address and credit card numbers and expiration dates, so that we can complete your transactions and contact you as needed. For more detail, please review our Returns Policy.</p>\r\n<h2 class=\"heading1 sub-title-content mt-5\">OPTIONAL TOOLS</h2>\r\n<p>We may provide you with access to third-party tools over which we neither monitor nor have any control nor input.</p>\r\n<p>You acknowledge and agree that we provide access to such tools &rdquo;as is&rdquo; and &ldquo;as available&rdquo; without any warranties, representations or conditions of any kind and without any endorsement. We shall have no liability whatsoever arising from or relating to your use of optional third-party tools.</p>\r\n<p>Any use by you of optional tools offered through the site is entirely at your own risk and discretion and you should ensure that you are familiar with and approve of the terms on which tools are provided by the relevant third-party provider(s).</p>\r\n<p>We may also, in the future, offer new services and/or features through the website (including, the release of new tools and resources). Such new features and/or services shall also be subject to these Terms of Service.</p>\r\n</div>\r\n</div>\r\n<div class=\"col-12 wow fadeInLeftBig\">\r\n<div class=\"section-content\">\r\n<h2 class=\"heading1 sub-title-content\">THIRD-PARTY LINKS</h2>\r\n<p>Certain content, products and services available via our Service may include materials from third-parties.</p>\r\n<p>Third-party links on this site may direct you to third-party websites that are not affiliated with us. We are not responsible for examining or evaluating the content or accuracy and we do not warrant and will not have any liability or responsibility for any third-party materials or websites, or for any other materials, products, or services of third-parties.</p>\r\n<p>We are not liable for any harm or damages related to the purchase or use of goods, services, resources, content, or any other transactions made in connection with any third-party websites. Please review carefully the third-party&rsquo;s policies and practices and make sure you understand them before you engage in any transaction. Complaints, claims, concerns, or questions regarding third-party products should be directed to the third-party.</p>\r\n<h2 class=\"heading1 sub-title-content mt-5\">USER COMMENTS, FEEDBACK AND OTHER SUBMISSIONS</h2>\r\n<p>If, at our request, you send certain specific submissions (for example contest entries) or without a request from us you send creative ideas, suggestions, proposals, plans, or other materials, whether online, by email, by postal mail, or otherwise (collectively, &lsquo;comments&rsquo;), you agree that we may, at any time, without restriction, edit, copy, publish, distribute, translate and otherwise use in any medium any comments that you forward to us. We are and shall be under no obligation (1) to maintain any comments in confidence; (2) to pay compensation for any comments; or (3) to respond to any comments.</p>\r\n<p>We may, but have no obligation to, monitor, edit or remove content that we determine in our sole discretion are unlawful, offensive, threatening, libelous, defamatory, pornographic, obscene or otherwise objectionable or violates any party&rsquo;s intellectual property or these Terms of Service.</p>\r\n<p>You agree that your comments will not violate any right of any third-party, including copyright, trademark, privacy, personality or other personal or proprietary right. You further agree that your comments will not contain libelous or otherwise unlawful, abusive or obscene material, or contain any computer virus or other malware that could in any way affect the operation of the Service or any related website. You may not use a false e-mail address, pretend to be someone other than yourself, or otherwise mislead us or third-parties as to the origin of any comments. You are solely responsible for any comments you make and their accuracy. We take no responsibility and assume no liability for any comments posted by you or any third-party.</p>\r\n</div>\r\n</div>\r\n<div class=\"col-12 wow fadeInRightBig\">\r\n<div class=\"section-content\">\r\n<h2 class=\"heading1 sub-title-content\">PERSONAL INFORMATION</h2>\r\n<p>Your submission of personal information through the store is governed by our Privacy Policy. To view our Privacy Policy.</p>\r\n<h2 class=\"heading1 sub-title-content mt-5\">ERRORS, INACCURACIES AND OMISSIONS</h2>\r\n<p>Occasionally there may be information on our site or in the Service that contains typographical errors, inaccuracies or omissions that may relate to product descriptions, pricing, promotions, offers, product shipping charges, transit times and availability. We reserve the right to correct any errors, inaccuracies or omissions, and to change or update information or cancel orders if any information in the Service or on any related website is inaccurate at any time without prior notice (including after you have submitted your order).</p>\r\n<p>We undertake no obligation to update, amend or clarify information in the Service or on any related website, including without limitation, pricing information, except as required by law. No specified update or refresh date applied in the Service or on any related website, should be taken to indicate that all information in the Service or on any related website has been modified or updated.</p>\r\n</div>\r\n</div>\r\n<div class=\"col-12 wow fadeInLeftBig\">\r\n<div class=\"section-content\">\r\n<h2 class=\"heading1 sub-title-content\">PROHIBITED USES</h2>\r\n<p>In addition to other prohibitions as set forth in the Terms of Service, you are prohibited from using the site or its content: (a) for any unlawful purpose; (b) to solicit others to perform or participate in any unlawful acts; (c) to violate any international, federal, provincial or state regulations, rules, laws, or local ordinances; (d) to infringe upon or violate our intellectual property rights or the intellectual property rights of others; (e) to harass, abuse, insult, harm, defame, slander, disparage, intimidate, or discriminate based on gender, sexual orientation, religion, ethnicity, race, age, national origin, or disability; (f) to submit false or misleading information; (g) to upload or transmit viruses or any other type of malicious code that will or may be used in any way that will affect the functionality or operation of the Service or of any related website, other websites, or the Internet; (h) to collect or track the personal information of others; (i) to spam, phish, pharm, pretext, spider, crawl, or scrape; (j) for any obscene or immoral purpose; or (k) to interfere with or circumvent the security features of the Service or any related website, other websites, or the Internet. We reserve the right to terminate your use of the Service or any related website for violating any of the prohibited uses.</p>\r\n<h2 class=\"heading1 sub-title-content mt-5\">DISCLAIMER OF WARRANTIES; LIMITATION OF LIABILITY</h2>\r\n<p>We do not guarantee, represent or warrant that your use of our service will be uninterrupted, timely, secure or error-free.</p>\r\n<p>We do not warrant that the results that may be obtained from the use of the service will be accurate or reliable.</p>\r\n<p>You agree that from time to time we may remove the service for indefinite periods of time or cancel the service at any time, without notice to you</p>\r\n<p>You expressly agree that your use of, or inability to use, the service is at your sole risk. The service and all products and services delivered to you through the service are (except as expressly stated by us) provided &lsquo;as is&rsquo; and &lsquo;as available&rsquo; for your use, without any representation, warranties or conditions of any kind, either express or implied, including all implied warranties or conditions of merchantability, merchantable quality, fitness for a particular purpose, durability, title, and non-infringement.</p>\r\n<p>In no case shall Saints Accessories, our directors, officers, employees, affiliates, agents, contractors, interns, suppliers, service providers or licensors be liable for any injury, loss, claim, or any direct, indirect, incidental, punitive, special, or consequential damages of any kind, including, without limitation lost profits, lost revenue, lost savings, loss of data, replacement costs, or any similar damages, whether based in contract, tort (including negligence), strict liability or otherwise, arising from your use of any of the service or any products procured using the service, or for any other claim related in any way to your use of the service or any product, including, but not limited to, any errors or omissions in any content, or any loss or damage of any kind incurred as a result of the use of the service or any content (or product) posted, transmitted, or otherwise made available via the service, even if advised of their possibility. Because some states or jurisdictions do not allow the exclusion or the limitation of liability for consequential or incidental damages, in such states or jurisdictions, our liability shall be limited to the maximum extent permitted by law.</p>\r\n</div>\r\n</div>\r\n<div class=\"col-12 wow fadeInRightBig\">\r\n<div class=\"section-content\">\r\n<h2 class=\"heading1 sub-title-content\">INDEMNIFICATION</h2>\r\n<p>You agree to indemnify, defend and hold harmless Saints Accessories and our parent, subsidiaries, affiliates, partners, officers, directors, agents, contractors, licensors, service providers, subcontractors, suppliers, interns and employees, harmless from any claim or demand, including reasonable attorneys&rsquo; fees, made by any third-party due to or arising out of your breach of these Terms of Service or the documents they incorporate by reference, or your violation of any law or the rights of a third-party.</p>\r\n<h2 class=\"heading1 sub-title-content mt-5\">SEVERABILITY</h2>\r\n<p>In the event that any provision of these Terms of Service is determined to be unlawful, void or unenforceable, such provision shall nonetheless be enforceable to the fullest extent permitted by applicable law, and the unenforceable portion shall be deemed to be severed from these Terms of Service, such determination shall not affect the validity and enforceability of any other remaining provisions.</p>\r\n</div>\r\n</div>\r\n<div class=\"col-12 wow fadeInRightBig\">\r\n<div class=\"section-content\">\r\n<h2 class=\"heading1 sub-title-content\">TERMINATION</h2>\r\n<p>The obligations and liabilities of the parties incurred prior to the termination date shall survive the termination of this agreement for all purposes.</p>\r\n<p>These Terms of Service are effective unless and until terminated by either you or us. You may terminate these Terms of Service at any time by notifying us that you no longer wish to use our Services, or when you cease using our site.</p>\r\n<p>If in our sole judgment you fail, or we suspect that you have failed, to comply with any term or provision of these Terms of Service, we also may terminate this agreement at any time without notice and you will remain liable for all amounts due up to and including the date of termination; and/or accordingly may deny you access to our Services (or any part thereof).</p>\r\n<h2 class=\"heading1 sub-title-content mt-5\">ENTIRE AGREEMENT</h2>\r\n<p>The failure of us to exercise or enforce any right or provision of these Terms of Service shall not constitute a waiver of such right or provision.</p>\r\n<p>These Terms of Service and any policies or operating rules posted by us on this site or in respect to The Service constitutes the entire agreement and understanding between you and us and govern your use of the Service, superseding any prior or contemporaneous agreements, communications and proposals, whether oral or written, between you and us (including, but not limited to, any prior versions of the Terms of Service).Any ambiguities in the interpretation of these Terms of Service shall not be construed against the drafting party.</p>\r\n</div>\r\n</div>\r\n<div class=\"col-12 wow fadeInRightBig\">\r\n<div class=\"section-content\">\r\n<h2 class=\"heading1 sub-title-content\">GOVERNING LAW</h2>\r\n<p>These Terms of Service and any separate agreements whereby we provide you Services shall be governed by and construed in accordance with the laws of Washington State.</p>\r\n<h2 class=\"heading1 sub-title-content mt-5\">CHANGES TO TERMS OF SERVICE</h2>\r\n<p>You can review the most current version of the Terms of Service at any time at this page.We reserve the right, at our sole discretion, to update, change or replace any part of these Terms of Service by posting updates and changes to our website. It is your responsibility to check our website periodically for changes. Your continued use of or access to our website or the Service following the posting of any changes to these Terms of Service constitutes acceptance of those changes.</p>\r\n</div>\r\n</div>\r\n<div class=\"col-12 wow fadeInRightBig\">\r\n<div class=\"section-content\">\r\n<h2 class=\"heading1 sub-title-content\">CONTACT INFORMATION</h2>\r\n<p>Questions about the Terms of Service should be sent to us at <a href=\"mailto:admin@saintsaccessories.com;\">admin@saintsaccessories.com</a>.</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', '2021-03-17 12:45:00', '2023-03-07 14:31:30'),
(7, 7, 'English', 'Payment Methods', '<p>This is payment method page</p>', '2021-03-17 12:46:06', '2021-03-17 12:46:06'),
(8, 8, 'English', 'Money Back', '<p>This is money back page</p>', '2021-03-17 12:46:23', '2021-03-17 12:46:23'),
(9, 9, 'English', 'Returns', '<p>This is return page</p>', '2021-03-17 12:46:38', '2021-03-17 12:46:38'),
(10, 10, 'English', 'Privacy Policy', '<p>This is privacy policy page</p>', '2021-03-17 12:46:52', '2021-03-17 12:46:52'),
(11, 11, 'English', 'Shipping', '\r\n<div class=\"banner banner--mini\">\r\n<div class=\"banner__bg wow fadeInUpBig\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/banner-bg-1.png\" alt=\"image\" /></div>\r\n<div class=\"container wow zoomIn\" data-wow-delay=\"750ms\">\r\n<div class=\"row\">\r\n<div class=\"col-12\">\r\n<div class=\"banner__content section-content section-content--light\">\r\n<h3 class=\"heading\">Shipping</h3>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"section pt-5 wow zoomIn\">\r\n<div class=\"container\">\r\n<div class=\"row align-items-center justify-content-center\">\r\n<div class=\"col-12 wow fadeInRightBig\">\r\n<div class=\"section-content\">\r\n<h2 class=\"heading mb-3\">Shipping</h2>\r\n<p><strong>1. Shipping Cost</strong></p>\r\n<p>Prices are only provided here for domestic consumers. Please go to our international FAQ for information about other countries.</p>\r\n<p>Our free/flat-cost shipping service employs USPS for door-to-door delivery and UPS for the first distribution. Depending on your location and the volume of mail being delivered, this service might take 3&ndash;10 business days (up to 2 weeks) to reach you.</p>\r\n<p>Depending on the amount of your order, we provide flat-rate delivery for orders under $50 for $5 or $10. Free delivery is available for purchases over $50!</p>\r\n<p>Do you require your order by a specific date? No issue! We provide two upgrade choices. For delivery in 3-5 business days (up to one week), select UPS Ground; for even quicker delivery, select UPS 2nd-Day Air. Please be aware that PO boxes and APO items cannot be shipped using enhanced shipping options.</p>\r\n<p><strong>2. Production &amp; Shipping Timeframes</strong></p>\r\n<p>Orders are sent Monday through Friday during regular business hours. Orders that contain all in-stock products will be delivered in 1-2* business days. We do not split ship. Thus orders, including back-ordered goods, may take anywhere from 1-2 weeks to 1-2 months. If you re-order an item or think about making two separate transactions, please be prepared to wait.</p>\r\n<p>We provide free delivery for domestic purchases over $50 and flat-cost shipping for orders under $50. Depending on the region and postal service volume, Free/Flat Rate Shipping takes 3&ndash;10 business days. Our free/flat-cost shipping service employs USPS for door-to-door delivery and UPS for the first distribution.</p>\r\n<p>Additionally, UPS Ground (3-5 business days) and UPS Second-Day Air are our two expedited delivery options. Please be aware that orders sent to PO boxes cannot be shipped with enhanced shipping options.</p>\r\n<p>Shipping costs for international consumers vary depending on the location and the products. For additional information, please go to our International FAQ.</p>\r\n<p>You will be sent a confirmation email as soon as your order ships with a tracking number so you can follow the progress of your package! Please send an email to help@SaintAccessories.com with the subject \"MISSING TRACKING LINK\" if you do not receive a confirmation email. Include the entire name that was used to place the order as well as the order\'s placement date in the body.</p>\r\n<p>*Note: If there is a surge in orders (such as on 4/20 or around Christmas), processing time may increase to 3 business days.</p>\r\n<p><strong>3. How do I track my order?</strong></p>\r\n<p>Once your order ships, you\'ll get an email with a tracking number as a shipment confirmation. Through your account\'s order history, you may also follow your order! If you\'re still experiencing issues, send an email to help@SaintAccessories.com with the subject \"Missing Tracking Link\" and your purchase number.</p>\r\n<p><strong>4. Can I ship to more than one address?</strong></p>\r\n<p>Per order, we only deliver to one address. You should submit numerous orders if you need to ship to different addresses.</p>\r\n<p><strong>5. Can I ship to an APO address?</strong></p>\r\n<p>Yes! Please choose our flat rate/free delivery option. For APO locations, kindly don\'t choose any UPS shipping options. Please take note that the address part of our label does indeed say \"Saint Accessories.\"</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', '2021-03-17 13:37:25', '2023-03-07 14:30:44'),
(12, 12, 'English', 'coming soon', '\r\n<div class=\"banner banner--mini\">\r\n<div class=\"banner__bg wow fadeInUpBig\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/banner-bg-1.png\" alt=\"image\" /></div>\r\n<div class=\"container wow zoomIn\" data-wow-delay=\"750ms\">\r\n<div class=\"row\">\r\n<div class=\"col-12\">\r\n<div class=\"banner__content section-content section-content--light\">\r\n<h3 class=\"heading\">Coming Soon</h3>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', '2023-03-02 20:51:00', '2023-03-02 20:51:00'),
(13, 13, 'English', 'reviews', '\r\n<div class=\"banner banner--mini\">\r\n<div class=\"banner__bg wow fadeInUpBig\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/banner-bg-1.png\" alt=\"image\" /></div>\r\n<div class=\"container wow zoomIn\" data-wow-delay=\"750ms\">\r\n<div class=\"row\">\r\n<div class=\"col-12\">\r\n<div class=\"banner__content section-content section-content--light\">\r\n<h3 class=\"heading\">Reviews</h3>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"container py-5 my-5 wow zoomIn\">\r\n<div class=\"row justify-content-center\">\r\n<div class=\"col-12 col-lg-9\">\r\n<div class=\"section-content text-center\">\r\n<div class=\"heading\">What our clients say</div>\r\n<p>Our clients have experienced the exceptional! Your happiness is our priority and motivation. Nothing defines our success better than your satisfaction reviews.</p>\r\n</div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"testimonial-card\">\r\n<div class=\"testimonial-card__top\">\r\n<div class=\"testimonial-card__img\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/testimonial-img-1.png\" alt=\"image\" /></div>\r\n</div>\r\n<div class=\"testimonial-card__desc\">I have tried many types of pre-roll cones, but this one is absolutely THE BEST! I am amazed by the whole transaction. I purchased these as a gift for my nephew, and he absolutely loved them! He is now a huge fan of the pre-roll cones.😀\r\n<p><strong>-David Montes</strong></p>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"testimonial-card\">\r\n<div class=\"testimonial-card__top\">\r\n<div class=\"testimonial-card__img\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/testimonial-img-1.png\" alt=\"image\" /></div>\r\n</div>\r\n<div class=\"testimonial-card__desc\">I am sure most folks are familiar with the pre-rolls brand as I am writing this review. I have been using pre-rolls for over a year, and I must say that I am pleased with them. I am not one to shop around for the best deal.😍 I am pleased with the pricing and the quality.\r\n<p><strong>-Warner Burg</strong></p>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"testimonial-card\">\r\n<div class=\"testimonial-card__top\">\r\n<div class=\"testimonial-card__img\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/testimonial-img-1.png\" alt=\"image\" /></div>\r\n</div>\r\n<div class=\"testimonial-card__desc\">I was searching for a water pipe with a slim, comfortable design,.😍 and the Pre-Rolls Pipe on your website caught my eye! I hold them in my hand, and they felt great! The color is vibrant, and the design is beautiful. A very happy customer!\r\n<p><strong>-James Henry</strong></p>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"testimonial-card\">\r\n<div class=\"testimonial-card__top\">\r\n<div class=\"testimonial-card__img\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/testimonial-img-1.png\" alt=\"image\" /></div>\r\n</div>\r\n<div class=\"testimonial-card__desc\">.Recently, I only used Saint\'s rose-flavored pre-roll cones. I have never visited a new store ever since I started using it. Now, I have been using pre-roll cones for over a year now, and I must say that I am impressed with them. I am not one to try and find the best price.\r\n<p><strong>-Jimmy Coco</strong></p>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"testimonial-card\">\r\n<div class=\"testimonial-card__top\">\r\n<div class=\"testimonial-card__img\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/testimonial-img-1.png\" alt=\"image\" /></div>\r\n</div>\r\n<div class=\"testimonial-card__desc\">.😍 I was first introduced to your company by my sister, who purchased a couple of your products from your website. I was so impressed with the quality that she ordered. After that, I order a few items for my wife and myself. We were happy with the products, and the customer service was also very friendly and professional.\r\n<p><strong>-Mark Bator</strong></p>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"testimonial-card\">\r\n<div class=\"testimonial-card__top\">\r\n<div class=\"testimonial-card__img\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/testimonial-img-1.png\" alt=\"image\" /></div>\r\n</div>\r\n<div class=\"testimonial-card__desc\">You have the best quality pipes I have ever had. They are very comfortable to hand, and the vibrant colors are a pleasure to look at.💗 I love that they are slim and easy to carry around. I feel safe knowing that my pipes are snug and secure in my hands. Really appreciated!\r\n<p><strong>- Roger Orozco</strong></p>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"testimonial-card\">\r\n<div class=\"testimonial-card__top\">\r\n<div class=\"testimonial-card__img\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/testimonial-img-1.png\" alt=\"image\" /></div>\r\n</div>\r\n<div class=\"testimonial-card__desc\">I was searching for a water pipe with a slim, comfortable design, and the Pre-Rolls Pipe on your website caught my eye! I hold them in my hand, and they felt great! The color is vibrant, and the design is beautiful. A very happy customer!😍\r\n<p><strong>- James Henry</strong></p>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"testimonial-card\">\r\n<div class=\"testimonial-card__top\">\r\n<div class=\"testimonial-card__img\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/testimonial-img-1.png\" alt=\"image\" /></div>\r\n</div>\r\n<div class=\"testimonial-card__desc\">I was searching for a water pipe with a slim, comfortable design, and the Pre-Rolls Pipe on your website caught my eye! I hold them in my hand, and they felt great! The color is vibrant, and the design is beautiful. ❤\r\n<p><strong>-James Henry</strong></p>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"testimonial-card\">\r\n<div class=\"testimonial-card__top\">\r\n<div class=\"testimonial-card__img\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/testimonial-img-1.png\" alt=\"image\" /></div>\r\n</div>\r\n<div class=\"testimonial-card__desc\">Recently, I only used Saint\'s rose-flavored pre-roll cones.😃 I have never visited a new store ever since I started using it.\r\n<p>💗</p>\r\n<p><strong>-Jimmy Coco</strong></p>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"testimonial-card\">\r\n<div class=\"testimonial-card__top\">\r\n<div class=\"testimonial-card__img\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/testimonial-img-1.png\" alt=\"image\" /></div>\r\n</div>\r\n<div class=\"testimonial-card__desc\">Soft, beautiful💗, &amp; burns slow\r\n<p><strong>Maddie</strong></p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', '2023-03-02 20:56:49', '2023-03-02 21:25:21'),
(14, 14, 'English', 'blogs', NULL, '2023-03-02 21:01:29', '2023-03-02 21:01:29');
INSERT INTO `page_translations` (`id`, `page_id`, `locale`, `title`, `body`, `created_at`, `updated_at`) VALUES
(16, 16, 'English', 'wholesale', '\r\n<div class=\"banner banner--mini\">\r\n<div class=\"banner__bg wow fadeInUpBig\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/banner-bg-1.png\" alt=\"image\" /></div>\r\n<div class=\"container wow zoomIn\" data-wow-delay=\"750ms\">\r\n<div class=\"row\">\r\n<div class=\"col-12\">\r\n<div class=\"banner__content section-content section-content--light\">\r\n<h3 class=\"heading\">Wholesale</h3>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"section pt-5 \">\r\n<div class=\"container\">\r\n<div class=\"row align-items-center justify-content-center\">\r\n<div class=\"col-12 wow fadeInRightBig\">\r\n<div class=\"section-content\">\r\n<h2 class=\"heading mb-3\">Wholesale</h2>\r\n<p><strong>1. Wholesale Account Sign-Up</strong></p>\r\n<p>Our sales staff will contact you when you complete the application at http://SaintAccessories.com/wholesale with our catalog and any questions you may have.</p>\r\n<p><strong>2. Unilateral Wholesale Pricing</strong></p>\r\n<p>The goal of this strategy is to set the price floor at a level that will motivate dealers to offer better service. This is intended to motivate you as a distributor for Saint Accessories to promote the brand and promote Interbrand rivalry. This enables any distributor in the Saints network, regardless of scale, to compete while upholding our high standard of excellence. Instead of going to the lowest online reseller, customers will search for the best service and delivery rates, helping Saints to flourish in your network!</p>\r\n<p>Visit this link to view our complete policy: https://SaintAccessories.com/resources/wholesale/.</p>\r\n<p><strong>3. I don\'t have a Tax ID. Can I still get Wholesale Pricing?</strong></p>\r\n<p>Without a resale tax ID, we are not able to sell wholesale.</p>\r\n<p><strong>4. Wholesale Marketing Materials</strong></p>\r\n<p>We will love to give you some promotional goods if you sell Saints at your business!</p>\r\n<p>For further information, get in touch with your representative if you have a wholesale account with us.</p>\r\n<p>Send an email to help@SaintAccessories.com with your shop name, address, and contact details if you do not do direct wholesale orders via us.</p>\r\n<p><strong>5. Custom Displays &amp; Custom Store Builds</strong></p>\r\n<p>The Saints Builds crew will put all of its resources into making you some incredible displays or assisting you in developing a one-of-a-kind smoke shop experience.</p>\r\n<p>If you already work with a wholesale representative, get in touch with them to learn more.</p>\r\n<p>If you would still like to explore bespoke displays or a custom shop construction but do not already have a wholesale account with us, send an email to help@SaintAccessories.com with the specifics of your business and what you\'re looking for!</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"container py-5 my-5 wow zoomIn\">\r\n<div class=\"row justify-content-center\">\r\n<div class=\"col-12\">\r\n<div class=\"section-content text-center\">\r\n<div class=\"heading\">Are you a wholesaler</div>\r\n<p>Please fill out form below</p>\r\n</div>\r\n</div>\r\n</div>\r\n<form class=\"auth-form mt-4\" action=\"#\">\r\n<div class=\"row\">\r\n<div class=\"col-12\">\r\n<div class=\"input-field\"><label>Business Name <span class=\"required\">*</span></label> <input type=\"text\" /></div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"input-field\"><label>First Name</label> <input type=\"text\" /></div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"input-field\"><label>Last Name</label> <input type=\"text\" /></div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"input-field\"><label>Email</label> <input type=\"email\" /></div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"input-field\"><label>Phone Number</label> <input type=\"tel\" /></div>\r\n</div>\r\n<div class=\"col-12\">\r\n<div class=\"input-field\"><label>Street Address</label> <input type=\"text\" /></div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"input-field\"><label>Apt or Unit</label> <input type=\"text\" /></div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"input-field\"><label>City</label> <input type=\"text\" /></div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"input-field\"><label>State</label> <input type=\"text\" /></div>\r\n</div>\r\n<div class=\"col-12 col-lg-6\">\r\n<div class=\"input-field\"><label>Zip Code</label> <input type=\"text\" /></div>\r\n</div>\r\n<div class=\"col-12\">\r\n<div class=\"input-field\"><label>Tax ID</label> <input type=\"text\" /></div>\r\n</div>\r\n<div class=\"col-12\">\r\n<div class=\"input-field\"><label>Which best describes you?</label><select>\r\n<option value=\"\">Select</option>\r\n</select></div>\r\n</div>\r\n<div class=\"col-12\">\r\n<div class=\"input-field\"><label>How many locations?</label> <input type=\"text\" /></div>\r\n</div>\r\n<div class=\"col-12\">\r\n<div class=\"input-field\"><label>referred by</label> <input type=\"text\" /></div>\r\n</div>\r\n<div class=\"col-12\">\r\n<div class=\"input-field\"><label>message</label> <textarea rows=\"5\"></textarea></div>\r\n</div>\r\n<div class=\"col-12\"><button class=\"themeBtn themeBtn--center themeBtn--rounded\" type=\"submit\">Send Message</button></div>\r\n</div>\r\n</form></div>', '2023-03-02 21:17:49', '2023-03-07 14:29:15'),
(17, 17, 'English', 'order management', '\r\n<div class=\"banner banner--mini\">\r\n<div class=\"banner__bg wow fadeInUpBig\"><img class=\"imgFluid\" src=\"https://saintsaccessories.custom.amgdigitalagency.com/public/theme/saintsaccessories/images/banner-bg-1.png\" alt=\"image\" /></div>\r\n<div class=\"container wow zoomIn\" data-wow-delay=\"750ms\">\r\n<div class=\"row\">\r\n<div class=\"col-12\">\r\n<div class=\"banner__content section-content section-content--light\">\r\n<h3 class=\"heading\">Order Management</h3>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"section pt-5 wow zoomIn\">\r\n<div class=\"container\">\r\n<div class=\"row align-items-center justify-content-center\">\r\n<div class=\"col-12 wow fadeInRightBig\">\r\n<div class=\"section-content\">\r\n<h2 class=\"heading mb-3\">Order Management</h2>\r\n<p><strong>1. Can I change the items on my order?</strong></p>\r\n<p>After your order is placed, we\'re unable to add items, remove items, or change the color of any products.</p>\r\n<p><strong>2. Account Dashboard</strong></p>\r\n<p>You may adjust your shipping and billing addresses, check your most recent orders, change your password, and access your account information from your account dashboard after logging in.</p>\r\n<p><strong>3. Update My Address</strong></p>\r\n<p>Send us an email at help@SaintAccessories.com straight soon if you need to update your address, and we\'ll try our best to accomplish it for you. Despite our best efforts, we cannot guarantee that the address will be updated once an order has been placed because orders are processed rapidly. Once the order has left our warehouse, we are 100% unable to modify addresses. Although we are unable to change the location where your product is being sent, we do advise getting in touch with the carrier or your local post office to set up a forwarding address for shipments in the future!</p>\r\n<p><strong>4. Cancel my order!</strong></p>\r\n<p>Until your order is recorded as dispatched, we can cancel it. Send a quick email to help@SaintAccessories.com with your order number. Orders are dispatched fast from our fulfillment center. However, we will try our best to fulfill your request. Once an order has been listed as shipped, we are unable to cancel it.</p>\r\n<p><strong>5. Returns</strong></p>\r\n<p>Products may be returned for any reason, up to 15 days after delivery, unopened and unused. Send an email to help@SaintAccessories.com with the subject \"Return Request,\" and we\'ll provide you with the return address and further instructions.</p>\r\n<p>For your return to be accepted:</p>\r\n<ul>\r\n<li>The product(s) must be unused and in its original packaging.</li>\r\n<li>The product(s) must be in its original packing</li>\r\n<li>Within 15 days of the delivery date, the return must be postmarked.</li>\r\n</ul>\r\n<p>Please be aware that the consumer is responsible for the return shipping charges.</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>', '2023-03-02 21:21:27', '2023-03-07 14:28:59');

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_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,
  `role_id` bigint(20) NOT NULL,
  `permission` varchar(191) 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,
  `brand_id` bigint(20) UNSIGNED DEFAULT NULL,
  `tax_class_id` bigint(20) UNSIGNED DEFAULT NULL,
  `slug` varchar(191) NOT NULL,
  `product_type` varchar(191) NOT NULL,
  `price` decimal(10,2) UNSIGNED NOT NULL,
  `special_price` decimal(10,2) UNSIGNED DEFAULT NULL,
  `special_price_start` date DEFAULT NULL,
  `special_price_end` date DEFAULT NULL,
  `sku` varchar(191) DEFAULT NULL,
  `manage_stock` tinyint(1) NOT NULL,
  `qty` bigint(20) DEFAULT NULL,
  `in_stock` tinyint(1) NOT NULL,
  `viewed` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL,
  `featured_tag` varchar(30) DEFAULT NULL,
  `digital_file` 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 `products`
--

INSERT INTO `products` (`id`, `brand_id`, `tax_class_id`, `slug`, `product_type`, `price`, `special_price`, `special_price_start`, `special_price_end`, `sku`, `manage_stock`, `qty`, `in_stock`, `viewed`, `is_active`, `featured_tag`, `digital_file`, `created_at`, `updated_at`) VALUES
(6, NULL, NULL, 'rose-pre-rolls', 'simple_product', '50.00', NULL, NULL, NULL, NULL, 0, NULL, 1, 2, 1, NULL, '', '2023-03-03 14:58:04', '2023-03-03 15:33:10'),
(7, NULL, NULL, 'slim-holographic-pipes', 'simple_product', '86.00', NULL, NULL, NULL, NULL, 0, NULL, 1, 0, 1, NULL, '', '2023-03-03 14:59:22', '2023-03-03 14:59:22'),
(8, NULL, NULL, 'lorem', 'simple_product', '12.00', NULL, NULL, NULL, NULL, 0, NULL, 1, 7, 1, NULL, '', '2023-03-03 15:00:48', '2023-03-03 22:19:26'),
(9, NULL, NULL, 'lorem2', 'simple_product', '58.00', NULL, NULL, NULL, NULL, 0, NULL, 1, 0, 1, NULL, '', '2023-03-03 15:01:32', '2023-03-03 15:01:32'),
(10, NULL, NULL, 'lorem3', 'simple_product', '63.00', NULL, NULL, NULL, NULL, 0, NULL, 1, 0, 1, NULL, '', '2023-03-03 15:02:07', '2023-03-03 15:02:07'),
(11, NULL, NULL, 'lorem4', 'simple_product', '73.00', NULL, NULL, NULL, NULL, 0, NULL, 1, 3, 1, NULL, '', '2023-03-03 15:02:28', '2023-03-03 20:34:53'),
(12, NULL, NULL, 'lorem5', 'simple_product', '280.00', NULL, NULL, NULL, NULL, 0, NULL, 1, 1, 1, NULL, '', '2023-03-03 15:06:38', '2023-03-03 19:19:27'),
(13, NULL, NULL, 'lorem6', 'simple_product', '350.00', NULL, NULL, NULL, NULL, 0, NULL, 1, 3, 1, NULL, '', '2023-03-03 15:07:07', '2023-03-03 21:30:49'),
(14, NULL, NULL, 'lorem7', 'simple_product', '399.00', NULL, NULL, NULL, NULL, 0, NULL, 1, 4, 1, NULL, '', '2023-03-03 15:07:42', '2023-03-03 22:47:52');

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

--
-- Table structure for table `product_categories`
--

CREATE TABLE `product_categories` (
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_categories`
--

INSERT INTO `product_categories` (`product_id`, `category_id`) VALUES
(6, 37),
(8, 31),
(9, 31),
(10, 31),
(11, 31),
(12, 34),
(13, 34),
(14, 34);

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

--
-- Table structure for table `product_comments`
--

CREATE TABLE `product_comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `body` text 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 `product_reviews`
--

CREATE TABLE `product_reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `rating` bigint(20) NOT NULL,
  `comment` text NOT NULL,
  `is_approved` tinyint(1) 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 `product_tags`
--

CREATE TABLE `product_tags` (
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `tag_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_translations`
--

CREATE TABLE `product_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `name` text NOT NULL,
  `description` longtext NOT NULL,
  `short_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 `product_translations`
--

INSERT INTO `product_translations` (`id`, `product_id`, `locale`, `name`, `description`, `short_description`, `created_at`, `updated_at`) VALUES
(6, 6, 'English', 'Flavored pre-rolled cones', '<p>sample product</p>', 'sample product', '2023-03-03 14:58:04', '2023-03-03 14:58:34'),
(7, 7, 'English', 'Slim Holographic pipes', '<p>sample product</p>', 'sample product', '2023-03-03 14:59:22', '2023-03-03 14:59:22'),
(8, 8, 'English', 'Lorem', '<p>sample product</p>', 'sample product', '2023-03-03 15:00:48', '2023-03-03 15:00:48'),
(9, 9, 'English', 'Lorem', '<p>sample product</p>', 'sample product', '2023-03-03 15:01:32', '2023-03-03 15:01:32'),
(10, 10, 'English', 'Lorem', '<p>sample product</p>', 'sample product', '2023-03-03 15:02:07', '2023-03-03 15:02:07'),
(11, 11, 'English', 'Lorem', '<p>sample product</p>', 'sample product', '2023-03-03 15:02:28', '2023-03-03 15:02:28'),
(12, 12, 'English', 'Lorem', '<p>Sample Product</p>', 'Sample Product', '2023-03-03 15:06:38', '2023-03-03 15:06:38'),
(13, 13, 'English', 'Lorem', '<p>Sample Product</p>', 'Sample Product', '2023-03-03 15:07:07', '2023-03-03 15:07:07'),
(14, 14, 'English', 'Lorem', '<p>Sample Product</p>', 'Sample Product', '2023-03-03 15:07:42', '2023-03-03 15:07:42');

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

--
-- Table structure for table `product_variations`
--

CREATE TABLE `product_variations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_variation_items`
--

CREATE TABLE `product_variation_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `variation_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_variation_prices`
--

CREATE TABLE `product_variation_prices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `option` text NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `special_price` decimal(10,2) UNSIGNED DEFAULT NULL,
  `is_available` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(50) 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;

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

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

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `value` 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 `settings`
--

INSERT INTO `settings` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES
(1, 'mail_type', 'sendmail', NULL, '2023-03-03 20:31:08'),
(2, 'backend_direction', 'ltr', NULL, '2023-03-03 21:27:51'),
(3, 'language', 'English', NULL, NULL),
(4, 'email_verification', 'enabled', NULL, '2023-03-03 21:27:51'),
(5, 'company_name', 'saintsaccessories', '2023-03-02 18:02:55', '2023-03-02 18:02:55'),
(6, 'site_title', 'saintsaccessories', '2023-03-02 18:02:55', '2023-03-02 18:02:55'),
(7, 'phone', '0000000', '2023-03-02 18:02:55', '2023-03-02 18:02:55'),
(8, 'email', 'example@gmail.com', '2023-03-02 18:02:55', '2023-03-02 18:02:55'),
(9, 'timezone', 'America/Araguaina', '2023-03-02 18:02:55', '2023-03-02 18:02:55'),
(68, 'primary_menu', '1', '2021-03-16 16:45:35', '2021-03-22 07:39:21'),
(69, 'category_menu', '2', '2021-03-16 16:45:35', '2021-03-22 07:39:21'),
(70, 'footer_menu_1_title', 'Information', '2021-03-16 16:45:35', '2021-03-22 07:52:49'),
(71, 'footer_menu_1', '3', '2021-03-16 16:45:35', '2021-03-22 07:39:22'),
(72, 'footer_menu_2_title', 'Customer Service', '2021-03-16 16:45:35', '2021-03-22 08:00:36'),
(73, 'footer_menu_2', '4', '2021-03-16 16:45:35', '2021-03-22 07:39:22'),
(74, 'footer_about_us', '', '2021-03-16 16:49:23', '2023-03-07 14:12:03'),
(75, 'copyright_text', 'Copyright © 2023 Saints Accessories  -  All Rights Reserved.', '2021-03-16 16:49:23', '2023-03-02 22:06:43'),
(77, 'meta_keywords', 'shop, online store, online shop', '2021-03-17 14:08:50', '2021-03-17 14:08:50'),
(78, 'meta_description', 'Online Shopping', '2021-03-17 14:08:50', '2021-03-17 14:08:50'),
(79, 'service_1_title', 'FREE SHIPING', '2021-03-18 07:33:35', '2021-03-22 08:03:01'),
(80, 'service_1_sub_title', 'Free Shipping Over 100', '2021-03-18 07:33:35', '2021-03-27 07:53:29'),
(81, 'service_1_icon', '<i class=\"ti-rocket\"></i>', '2021-03-18 07:33:35', '2021-03-22 08:03:03'),
(82, 'service_2_title', 'FREE RETURN', '2021-03-18 07:33:35', '2021-03-22 08:03:04'),
(83, 'service_2_sub_title', 'Within 30 days returns', '2021-03-18 07:33:35', '2021-03-22 08:03:04'),
(84, 'service_2_icon', '<i class=\"ti-reload\"></i>', '2021-03-18 07:33:35', '2021-03-22 08:03:04'),
(85, 'service_3_title', 'SUCURE PAYMENT', '2021-03-18 07:33:37', '2021-03-22 08:03:04'),
(86, 'service_3_sub_title', '100% secure payment', '2021-03-18 07:33:38', '2021-03-22 08:03:05'),
(87, 'service_3_icon', '<i class=\"ti-lock\"></i>', '2021-03-18 07:33:38', '2021-03-22 08:03:06'),
(88, 'service_4_title', 'BEST PEICE', '2021-03-18 07:33:38', '2021-03-22 08:03:06'),
(89, 'service_4_sub_title', 'Guaranteed price', '2021-03-18 07:33:38', '2021-03-22 08:03:06'),
(90, 'service_4_icon', '<i class=\"ti-tag\"></i>', '2021-03-18 07:33:38', '2021-03-22 08:03:06'),
(91, 'hero_title', 'Good vibes', '2021-03-30 21:41:43', '2023-03-03 16:44:29'),
(92, 'hero_content', 'Modern, healthier, flavored, colored smoking accessories for an unbelievably satisfying smoking experience', '2021-03-30 21:41:43', '2023-03-03 16:44:29'),
(93, 'hero_button_text', 'Shop Now', '2021-03-30 21:41:43', '2021-03-30 21:41:43'),
(94, 'hero_button_link', '/shop', '2021-03-30 21:41:43', '2023-03-03 16:44:29'),
(95, 'theme_color', '#e91e63', '2023-03-02 17:57:02', '2023-03-02 17:57:02'),
(96, 'navigation_color', '#1d2224', '2023-03-02 17:57:02', '2023-03-02 17:57:02'),
(97, 'custom_css', '', '2023-03-02 17:57:02', '2023-03-02 17:57:02'),
(98, 'free_shipping_active', 'Yes', '2023-03-02 19:15:49', '2023-03-03 21:23:04'),
(99, 'free_shipping_label', 'Free Shipping', '2023-03-02 19:15:49', '2023-03-03 21:23:04'),
(100, 'free_shipping_minimum_amount', '1000', '2023-03-02 19:15:49', '2023-03-03 21:23:04'),
(101, 'logo', 'logo.png', '2023-03-02 20:01:43', '2023-03-02 20:05:46'),
(102, 'facebook_link', 'https://www.facebook.com/', '2023-03-02 21:48:34', '2023-03-02 21:48:34'),
(103, 'twitter_link', 'https://www.twitter.com/', '2023-03-02 21:48:34', '2023-03-02 21:48:34'),
(104, 'instagram_link', 'https://www.instagram.com/', '2023-03-02 21:48:34', '2023-03-02 21:48:34'),
(105, 'youtube_link', 'https://www.youtube.com/', '2023-03-02 21:48:34', '2023-03-02 21:48:34'),
(106, 'payment_method_image', 'file_6401484b249f0.png', '2023-03-02 22:07:23', '2023-03-02 22:07:23'),
(107, 'hero_sub_title1', 'and heavenly encounters! ', '2023-03-03 16:57:29', '2023-03-03 16:59:12'),
(108, 'hero_sub_title2', 'Saint accessories', '2023-03-03 16:57:29', '2023-03-03 16:59:12'),
(109, 'hero_button1_text', 'Shop Now', '2023-03-03 16:57:29', '2023-03-03 16:57:29'),
(110, 'hero_button1_link', '/shop', '2023-03-03 16:57:29', '2023-03-03 16:57:29'),
(111, 'hero_button2_text', 'Read More', '2023-03-03 16:57:29', '2023-03-03 16:57:29'),
(112, 'hero_button2_link', '/about-us', '2023-03-03 16:57:29', '2023-03-03 16:57:29'),
(113, 'hero_banner', 'file_64025129bc2fc.png', '2023-03-03 16:57:29', '2023-03-03 16:57:29'),
(114, 'what_we_do_title', 'What We Do?', '2023-03-03 17:19:55', '2023-03-03 17:19:55'),
(115, 'what_we_do_content', '<p>Saint accessories were built upon the passion for delivering quality smoking accessories and enhanced smoking experience from colorful flavored pre-rolls and slim holographic glassware to retail merchandise. We directly deliver to smoke shop dispensaries throughout the U.S.</p>', '2023-03-03 17:19:55', '2023-03-03 17:19:55'),
(116, 'what_we_do_image', 'file_6402566be14e8.png', '2023-03-03 17:19:55', '2023-03-03 17:19:55'),
(117, 'home_sec4_title', 'Flavoring Your Smoking Pleasure', '2023-03-03 17:43:50', '2023-03-03 17:43:50'),
(118, 'home_sec4_animation_title', 'Saint Accessories', '2023-03-03 17:43:50', '2023-03-03 17:51:02'),
(119, 'home_sec4_content', '<p>Unwind, indulge, and enjoy with the new line of colored smoking accessories for a vibrant life. Puff your sadness away with quality products flavored as per your preference for infinite bliss. Relax during your downtime with creative, beautiful accessories as your innovative smoking partner. Saint Accessories - healthier smoking made possible with accessories that make smoking more desirable (no chalk, dyes, or burn additives).</p>', '2023-03-03 17:43:50', '2023-03-03 17:43:50'),
(120, 'home_sec4_button1_text', 'Read More', '2023-03-03 17:43:50', '2023-03-03 17:43:50'),
(121, 'home_sec4_button1_link', '#', '2023-03-03 17:43:50', '2023-03-03 17:44:20'),
(122, 'home_sec4_image', 'file_64025db6a6aa4.png', '2023-03-03 17:44:20', '2023-03-03 17:51:02'),
(123, 'home_sec4_scroll_title', 'SAINTS', '2023-03-03 17:53:28', '2023-03-03 17:53:28'),
(124, 'home_sec1_heading1', 'Latest Products', '2023-03-03 20:16:12', '2023-03-03 20:16:12'),
(125, 'home_sec3_heading1', 'Best Sellers/New Arrivels', '2023-03-03 20:16:12', '2023-03-03 20:16:12'),
(126, 'home_sec6_heading1', 'Our Clients Have Experienced The Exceptional!', '2023-03-03 20:16:12', '2023-03-03 20:16:12'),
(127, 'from_email', 'admin@saintsaccessories.com', '2023-03-03 20:31:00', '2023-03-03 20:31:08'),
(128, 'from_name', 'Saintsaccessories', '2023-03-03 20:31:00', '2023-03-03 20:31:08'),
(129, 'smtp_host', 'smtp.gmail.com', '2023-03-03 20:31:00', '2023-03-03 20:31:08'),
(130, 'smtp_port', '465', '2023-03-03 20:31:00', '2023-03-03 20:31:08'),
(131, 'smtp_username', 'admin@saintsaccessories.com', '2023-03-03 20:31:00', '2023-03-03 20:31:08'),
(132, 'smtp_password', '', '2023-03-03 20:31:00', '2023-03-03 20:31:08'),
(133, 'smtp_encryption', 'ssl', '2023-03-03 20:31:00', '2023-03-03 20:31:08'),
(134, 'stripe_active', 'Yes', '2023-03-03 20:34:30', '2023-03-03 21:34:53'),
(135, 'stripe_label', 'Stripe', '2023-03-03 20:34:30', '2023-03-03 21:34:53'),
(136, 'stripe_description', 'Pay Via Credit Card', '2023-03-03 20:34:30', '2023-03-03 21:34:53'),
(137, 'stripe_secret_key', 'sk_test_51MgbxjEilGowYMOJKGWBQiQHarkNQCyzj6pSU0bNoBagXWFzG2etJwjXecGXoU3ruUBIKXGCngzgSZlU2w1AqcP100jz3jnGxc', '2023-03-03 20:34:30', '2023-03-03 21:34:53'),
(138, 'stripe_publishable_key', 'pk_test_51MgbxjEilGowYMOJ9pZ7ZMuer7So6zuTCOcnoKa7A7YdH8ZJ9XOdb8j6xa9Qo3bE3O7FsOiXcTRZoFoOyekMIf0h00szPnwgCA', '2023-03-03 20:34:30', '2023-03-03 21:34:53'),
(139, 'local_pickup_active', 'Yes', '2023-03-03 20:45:09', '2023-03-03 21:23:30'),
(140, 'local_pickup_label', 'local', '2023-03-03 20:45:09', '2023-03-03 21:23:30'),
(141, 'local_pickup_cost', '100', '2023-03-03 20:45:09', '2023-03-03 21:23:30'),
(142, 'supported_countries', '[\"American Samoa\",\"United States\"]', '2023-03-03 20:47:31', '2023-03-03 21:27:51'),
(143, 'date_format', 'Y-m-d', '2023-03-03 20:47:31', '2023-03-03 21:27:51'),
(144, 'time_format', '24', '2023-03-03 20:47:31', '2023-03-03 21:27:51'),
(145, 'media_file_types_supported', 'png,jpg,jpeg', '2023-03-03 20:47:31', '2023-03-03 21:27:51'),
(146, 'media_max_upload_size', '2', '2023-03-03 20:47:31', '2023-03-03 21:27:51'),
(147, 'digital_file_max_upload_size', '2', '2023-03-03 20:47:31', '2023-03-03 21:27:51'),
(148, 'currency_converter', 'fixer', '2023-03-03 21:29:08', '2023-03-03 22:04:16'),
(149, 'fixer_api_key', 'zo3yAOwRzIoQs7Sxq6i2IBCLS9FSj12w', '2023-03-03 21:29:08', '2023-03-03 22:04:16'),
(150, 'currency_position', 'left', '2023-03-03 21:29:08', '2023-03-03 22:04:16'),
(151, 'thousand_sep', ',', '2023-03-03 21:29:08', '2023-03-03 22:04:16'),
(152, 'decimal_sep', '.', '2023-03-03 21:29:08', '2023-03-03 22:04:16'),
(153, 'decimal_places', '2', '2023-03-03 21:29:08', '2023-03-03 22:04:16'),
(154, 'footer_heading1', 'Quick Links', '2023-03-07 14:02:39', '2023-03-07 14:02:39'),
(155, 'footer_heading2', 'Contact Us', '2023-03-07 14:02:39', '2023-03-07 14:02:39'),
(156, 'footer_display_image1', 'file_640773c8deb3a.png', '2023-03-07 14:26:32', '2023-03-07 14:26:32'),
(157, 'footer_display_image2', 'file_640773c8deec2.png', '2023-03-07 14:26:32', '2023-03-07 14:26:32'),
(158, 'footer_display_image3', 'file_640773c8df205.png', '2023-03-07 14:26:32', '2023-03-07 14:26:32'),
(159, 'footer_display_image4', 'file_640773c8df4f2.png', '2023-03-07 14:26:32', '2023-03-07 14:26:32'),
(160, 'footer_display_image5', 'file_640773c8df7dd.png', '2023-03-07 14:26:32', '2023-03-07 14:26:32'),
(161, 'footer_display_image6', 'file_640773c8dfb0d.png', '2023-03-07 14:26:32', '2023-03-07 14:26:32'),
(162, 'footer_display_image7', 'file_640773c8dfff4.png', '2023-03-07 14:26:32', '2023-03-07 14:26:32'),
(163, 'footer_display_image8', 'file_640773c8e0309.png', '2023-03-07 14:26:32', '2023-03-07 14:26:32');

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

--
-- Table structure for table `setting_translations`
--

CREATE TABLE `setting_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `setting_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `value` 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 `setting_translations`
--

INSERT INTO `setting_translations` (`id`, `setting_id`, `locale`, `value`, `created_at`, `updated_at`) VALUES
(1, 95, 'English', '#e91e63', '2023-03-02 17:57:02', '2023-03-02 17:57:02'),
(2, 96, 'English', '#1d2224', '2023-03-02 17:57:02', '2023-03-02 17:57:02'),
(3, 97, 'English', '', '2023-03-02 17:57:02', '2023-03-02 17:57:02'),
(4, 102, 'English', 'https://www.facebook.com/', '2023-03-02 21:48:34', '2023-03-02 21:48:34'),
(5, 103, 'English', 'https://www.twitter.com/', '2023-03-02 21:48:34', '2023-03-02 21:48:34'),
(6, 104, 'English', 'https://www.instagram.com/', '2023-03-02 21:48:34', '2023-03-02 21:48:34'),
(7, 105, 'English', 'https://www.youtube.com/', '2023-03-02 21:48:34', '2023-03-02 21:48:34'),
(8, 74, 'English', '', '2023-03-02 22:06:43', '2023-03-07 14:12:03'),
(9, 75, 'English', 'Copyright © 2023 Saints Accessories  -  All Rights Reserved.', '2023-03-02 22:06:43', '2023-03-02 22:06:43'),
(10, 91, 'English', 'Good vibes', '2023-03-03 16:44:29', '2023-03-03 16:44:29'),
(11, 92, 'English', 'Modern, healthier, flavored, colored smoking accessories for an unbelievably satisfying smoking experience', '2023-03-03 16:44:29', '2023-03-03 16:44:29'),
(12, 93, 'English', 'Shop Now', '2023-03-03 16:44:29', '2023-03-03 16:44:29'),
(13, 94, 'English', '/shop', '2023-03-03 16:44:29', '2023-03-03 16:44:29'),
(14, 107, 'English', 'and heavenly encounters! ', '2023-03-03 16:57:29', '2023-03-03 16:59:12'),
(15, 108, 'English', 'Saint accessories', '2023-03-03 16:57:29', '2023-03-03 16:59:12'),
(16, 109, 'English', 'Shop Now', '2023-03-03 16:57:29', '2023-03-03 16:57:29'),
(17, 110, 'English', '/shop', '2023-03-03 16:57:29', '2023-03-03 16:57:29'),
(18, 111, 'English', 'Read More', '2023-03-03 16:57:29', '2023-03-03 16:57:29'),
(19, 112, 'English', '/about-us', '2023-03-03 16:57:29', '2023-03-03 16:57:29'),
(20, 114, 'English', 'What We Do?', '2023-03-03 17:19:55', '2023-03-03 17:19:55'),
(21, 115, 'English', '<p>Saint accessories were built upon the passion for delivering quality smoking accessories and enhanced smoking experience from colorful flavored pre-rolls and slim holographic glassware to retail merchandise. We directly deliver to smoke shop dispensaries throughout the U.S.</p>', '2023-03-03 17:19:55', '2023-03-03 17:19:55'),
(22, 117, 'English', 'Flavoring Your Smoking Pleasure', '2023-03-03 17:43:50', '2023-03-03 17:43:50'),
(23, 118, 'English', 'Saint Accessories', '2023-03-03 17:43:50', '2023-03-03 17:51:02'),
(24, 119, 'English', '<p>Unwind, indulge, and enjoy with the new line of colored smoking accessories for a vibrant life. Puff your sadness away with quality products flavored as per your preference for infinite bliss. Relax during your downtime with creative, beautiful accessories as your innovative smoking partner. Saint Accessories - healthier smoking made possible with accessories that make smoking more desirable (no chalk, dyes, or burn additives).</p>', '2023-03-03 17:43:50', '2023-03-03 17:43:50'),
(25, 120, 'English', 'Read More', '2023-03-03 17:43:50', '2023-03-03 17:43:50'),
(26, 121, 'English', '#', '2023-03-03 17:43:50', '2023-03-03 17:44:20'),
(27, 123, 'English', 'SAINTS', '2023-03-03 17:53:28', '2023-03-03 17:53:28'),
(28, 124, 'English', 'Latest Products', '2023-03-03 20:16:12', '2023-03-03 20:16:12'),
(29, 125, 'English', 'Best Sellers/New Arrivels', '2023-03-03 20:16:12', '2023-03-03 20:16:12'),
(30, 126, 'English', 'Our Clients Have Experienced The Exceptional!', '2023-03-03 20:16:12', '2023-03-03 20:16:12'),
(31, 154, 'English', 'Quick Links', '2023-03-07 14:02:39', '2023-03-07 14:02:39'),
(32, 155, 'English', 'Contact Us', '2023-03-07 14:02:39', '2023-03-07 14:02:39');

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

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(191) 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 `tags_translation`
--

CREATE TABLE `tags_translation` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tag_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `name` varchar(191) 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 `tax_classes`
--

CREATE TABLE `tax_classes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `based_on` varchar(30) 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 `tax_classes_translation`
--

CREATE TABLE `tax_classes_translation` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tax_class_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `name` varchar(191) 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 `tax_rates`
--

CREATE TABLE `tax_rates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tax_class_id` bigint(20) UNSIGNED NOT NULL,
  `country` varchar(191) NOT NULL,
  `state` varchar(191) NOT NULL,
  `rate` decimal(8,4) 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 `tax_rates_translation`
--

CREATE TABLE `tax_rates_translation` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tax_rate_id` bigint(20) UNSIGNED NOT NULL,
  `locale` varchar(191) NOT NULL,
  `name` varchar(191) 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 `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `is_featured` text DEFAULT NULL,
  `title` text DEFAULT NULL,
  `sub_title` text DEFAULT NULL,
  `content` text DEFAULT NULL,
  `image` text DEFAULT NULL,
  `button_text` varchar(255) DEFAULT NULL,
  `button_link` varchar(255) DEFAULT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `is_featured`, `title`, `sub_title`, `content`, `image`, `button_text`, `button_link`, `is_active`, `created_at`, `updated_at`) VALUES
(1, NULL, '- Mark Bator', 'Client', 'I must say quality products, great prices, and fast shipping can’t be beaten. Thankfully, I don’t have to buy those boring pre-rolls at my local liquor store again.', '[\"testimonial-img-1.png\"]', 'Read More', '#', 1, '2023-01-03 20:20:53', '2023-03-06 22:14:07'),
(2, NULL, '-  David Montes', 'Client', 'I only use Saint’s rose-flavored pre-roll cones. I have never visited a new store ever since I started using it. Good price and creative design!', '[\"testimonial-img-1.png\"]', 'Read More', '#', 1, '2023-01-03 20:20:56', '2023-03-06 22:28:17'),
(3, NULL, '- Jimmy coco', 'Client', 'I have tried many types of pre-roll cones, but this one is absolutely THE BEST! I am amazed by the whole transaction. Definitely Recommended!', '[\"testimonial-img-1.png\"]', 'Read More', '#', 1, '2023-01-03 20:53:59', '2023-03-06 22:24:14'),
(11, NULL, 'Mark.B', '.', '.😍 I was first introduced to your company by my sister, who purchased a couple of your products from your website. I was so impressed with the quality that she ordered. After that, I order a few items for my wife and myself. We were happy with the products, and the customer service was also very friendly and professional.', '[\"testimonial-img-1.png\"]', 'Read More', '#', 1, '2023-03-06 23:19:50', '2023-03-06 23:19:50');

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

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

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `transaction_id` varchar(191) NOT NULL,
  `payment_method` varchar(30) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `payment_data` 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 `transactions`
--

INSERT INTO `transactions` (`id`, `order_id`, `transaction_id`, `payment_method`, `amount`, `payment_data`, `created_at`, `updated_at`) VALUES
(1, 8, 'ch_3MhjMpEilGowYMOJ19PNVgJB', 'Stripe', '112.00', NULL, '2023-03-03 21:54:31', '2023-03-03 21:54:31'),
(2, 13, 'ch_3MhkD1EilGowYMOJ1LaU0p2b', 'Stripe', '499.00', NULL, '2023-03-03 22:48:28', '2023-03-03 22:48:28'),
(3, 14, 'ch_3MhkGBEilGowYMOJ1FuOCN0h', 'Stripe', '158.00', NULL, '2023-03-03 22:51:44', '2023-03-03 22:51:44');

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `user_type` varchar(20) NOT NULL,
  `role_id` bigint(20) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `profile_picture` varchar(191) DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(191) DEFAULT NULL,
  `provider` varchar(191) DEFAULT NULL,
  `provider_id` varchar(191) DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `email`, `phone`, `user_type`, `role_id`, `status`, `profile_picture`, `email_verified_at`, `password`, `provider`, `provider_id`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Admin', 'admin@gmail.com', '120120000', 'admin', NULL, 1, 'profile_1678139711.jpg', '2023-03-02 18:02:15', '$2y$10$2yGpap7H2IShDjfHrvPHruD/eroRH3pEjvH/VqZh5Wc6i0P1/i5H.', NULL, NULL, NULL, '2023-03-02 18:02:15', '2023-03-06 18:55:11'),
(2, 'test', 'test@gmail.com', '120120000', 'customer', NULL, 1, 'default.png', '2023-03-03 14:16:21', '$2y$10$FMHVgQbmLFwVYoxaozVlUuWioTsKcL6fmHophdMdDAT/zDnFRlA9e', NULL, NULL, NULL, '2023-03-03 14:16:21', '2023-03-03 14:16:21');

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

--
-- Table structure for table `wish_lists`
--

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

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `brands_translation`
--
ALTER TABLE `brands_translation`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `brands_translation_brand_id_locale_unique` (`brand_id`,`locale`);

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

--
-- Indexes for table `category_translation`
--
ALTER TABLE `category_translation`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `category_translation_category_id_locale_unique` (`category_id`,`locale`);

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`),
  ADD KEY `coupons_code_index` (`code`);

--
-- Indexes for table `coupon_categories`
--
ALTER TABLE `coupon_categories`
  ADD PRIMARY KEY (`coupon_id`,`category_id`,`exclude`),
  ADD KEY `coupon_categories_category_id_foreign` (`category_id`);

--
-- Indexes for table `coupon_products`
--
ALTER TABLE `coupon_products`
  ADD PRIMARY KEY (`coupon_id`,`product_id`,`exclude`),
  ADD KEY `coupon_products_product_id_foreign` (`product_id`);

--
-- Indexes for table `coupon_translations`
--
ALTER TABLE `coupon_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `coupon_translations_coupon_id_locale_unique` (`coupon_id`,`locale`);

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

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

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

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

--
-- Indexes for table `entity_files`
--
ALTER TABLE `entity_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `entity_files_entity_type_entity_id_index` (`entity_type`,`entity_id`),
  ADD KEY `entity_files_media_id_index` (`media_id`),
  ADD KEY `entity_files_name_index` (`name`);

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

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

--
-- Indexes for table `meta_data`
--
ALTER TABLE `meta_data`
  ADD PRIMARY KEY (`id`),
  ADD KEY `meta_data_entity_type_entity_id_index` (`entity_type`,`entity_id`);

--
-- Indexes for table `meta_data_translations`
--
ALTER TABLE `meta_data_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `meta_data_translations_meta_data_id_locale_unique` (`meta_data_id`,`locale`);

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

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

--
-- Indexes for table `navigation_items`
--
ALTER TABLE `navigation_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `navigation_items_parent_id_foreign` (`parent_id`),
  ADD KEY `navigation_items_category_id_foreign` (`category_id`),
  ADD KEY `navigation_items_page_id_foreign` (`page_id`),
  ADD KEY `navigation_items_navigation_id_index` (`navigation_id`);

--
-- Indexes for table `navigation_item_translations`
--
ALTER TABLE `navigation_item_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `navigation_item_translations_navigation_item_id_locale_unique` (`navigation_item_id`,`locale`);

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

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

--
-- Indexes for table `order_taxes`
--
ALTER TABLE `order_taxes`
  ADD PRIMARY KEY (`order_id`,`tax_rate_id`),
  ADD KEY `order_taxes_tax_rate_id_foreign` (`tax_rate_id`);

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

--
-- Indexes for table `page_translations`
--
ALTER TABLE `page_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `page_translations_page_id_locale_unique` (`page_id`,`locale`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

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

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

--
-- Indexes for table `product_categories`
--
ALTER TABLE `product_categories`
  ADD PRIMARY KEY (`product_id`,`category_id`),
  ADD KEY `product_categories_category_id_foreign` (`category_id`);

--
-- Indexes for table `product_comments`
--
ALTER TABLE `product_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_comments_user_id_foreign` (`user_id`),
  ADD KEY `product_comments_product_id_foreign` (`product_id`),
  ADD KEY `product_comments_parent_id_foreign` (`parent_id`);

--
-- Indexes for table `product_reviews`
--
ALTER TABLE `product_reviews`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_reviews_user_id_foreign` (`user_id`),
  ADD KEY `product_reviews_product_id_foreign` (`product_id`);

--
-- Indexes for table `product_tags`
--
ALTER TABLE `product_tags`
  ADD PRIMARY KEY (`product_id`,`tag_id`),
  ADD KEY `product_tags_tag_id_foreign` (`tag_id`);

--
-- Indexes for table `product_translations`
--
ALTER TABLE `product_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `product_translations_product_id_locale_unique` (`product_id`,`locale`);

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

--
-- Indexes for table `product_variation_items`
--
ALTER TABLE `product_variation_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_variation_items_variation_id_foreign` (`variation_id`);

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

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

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

--
-- Indexes for table `setting_translations`
--
ALTER TABLE `setting_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_translations_setting_id_locale_unique` (`setting_id`,`locale`);

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

--
-- Indexes for table `tags_translation`
--
ALTER TABLE `tags_translation`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tags_translation_tag_id_locale_unique` (`tag_id`,`locale`);

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

--
-- Indexes for table `tax_classes_translation`
--
ALTER TABLE `tax_classes_translation`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tax_classes_translation_tax_class_id_locale_unique` (`tax_class_id`,`locale`);

--
-- Indexes for table `tax_rates`
--
ALTER TABLE `tax_rates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tax_rates_tax_class_id_index` (`tax_class_id`);

--
-- Indexes for table `tax_rates_translation`
--
ALTER TABLE `tax_rates_translation`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tax_rates_translation_tax_rate_id_locale_unique` (`tax_rate_id`,`locale`);

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

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

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

--
-- Indexes for table `wish_lists`
--
ALTER TABLE `wish_lists`
  ADD PRIMARY KEY (`user_id`,`product_id`),
  ADD KEY `wish_lists_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=16;

--
-- AUTO_INCREMENT for table `blog_categories`
--
ALTER TABLE `blog_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  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=15;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `brands_translation`
--
ALTER TABLE `brands_translation`
  ADD CONSTRAINT `brands_translation_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `category_translation`
--
ALTER TABLE `category_translation`
  ADD CONSTRAINT `category_translation_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `coupon_categories`
--
ALTER TABLE `coupon_categories`
  ADD CONSTRAINT `coupon_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `coupon_categories_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `coupon_products`
--
ALTER TABLE `coupon_products`
  ADD CONSTRAINT `coupon_products_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `coupon_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `coupon_translations`
--
ALTER TABLE `coupon_translations`
  ADD CONSTRAINT `coupon_translations_coupon_id_foreign` FOREIGN KEY (`coupon_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `entity_files`
--
ALTER TABLE `entity_files`
  ADD CONSTRAINT `entity_files_media_id_foreign` FOREIGN KEY (`media_id`) REFERENCES `media` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `meta_data_translations`
--
ALTER TABLE `meta_data_translations`
  ADD CONSTRAINT `meta_data_translations_meta_data_id_foreign` FOREIGN KEY (`meta_data_id`) REFERENCES `meta_data` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `navigation_items`
--
ALTER TABLE `navigation_items`
  ADD CONSTRAINT `navigation_items_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `navigation_items_navigation_id_foreign` FOREIGN KEY (`navigation_id`) REFERENCES `navigations` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `navigation_items_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `navigation_items_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `navigation_items` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `navigation_item_translations`
--
ALTER TABLE `navigation_item_translations`
  ADD CONSTRAINT `navigation_item_translations_navigation_item_id_foreign` FOREIGN KEY (`navigation_item_id`) REFERENCES `navigation_items` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `order_taxes`
--
ALTER TABLE `order_taxes`
  ADD CONSTRAINT `order_taxes_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `order_taxes_tax_rate_id_foreign` FOREIGN KEY (`tax_rate_id`) REFERENCES `tax_rates` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `page_translations`
--
ALTER TABLE `page_translations`
  ADD CONSTRAINT `page_translations_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `product_categories`
--
ALTER TABLE `product_categories`
  ADD CONSTRAINT `product_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_categories_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_comments`
--
ALTER TABLE `product_comments`
  ADD CONSTRAINT `product_comments_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `product_comments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_comments_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `product_tags`
--
ALTER TABLE `product_tags`
  ADD CONSTRAINT `product_tags_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_tags_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE;

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

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

--
-- Constraints for table `product_variation_items`
--
ALTER TABLE `product_variation_items`
  ADD CONSTRAINT `product_variation_items_variation_id_foreign` FOREIGN KEY (`variation_id`) REFERENCES `product_variations` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `setting_translations`
--
ALTER TABLE `setting_translations`
  ADD CONSTRAINT `setting_translations_setting_id_foreign` FOREIGN KEY (`setting_id`) REFERENCES `settings` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tags_translation`
--
ALTER TABLE `tags_translation`
  ADD CONSTRAINT `tags_translation_tag_id_foreign` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tax_classes_translation`
--
ALTER TABLE `tax_classes_translation`
  ADD CONSTRAINT `tax_classes_translation_tax_class_id_foreign` FOREIGN KEY (`tax_class_id`) REFERENCES `tax_classes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tax_rates`
--
ALTER TABLE `tax_rates`
  ADD CONSTRAINT `tax_rates_tax_class_id_foreign` FOREIGN KEY (`tax_class_id`) REFERENCES `tax_classes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tax_rates_translation`
--
ALTER TABLE `tax_rates_translation`
  ADD CONSTRAINT `tax_rates_translation_tax_rate_id_foreign` FOREIGN KEY (`tax_rate_id`) REFERENCES `tax_rates` (`id`) ON DELETE CASCADE;

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

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;