-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3307
-- Generation Time: Jul 15, 2026 at 12:13 PM
-- Server version: 11.4.9-MariaDB
-- PHP Version: 8.3.28

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


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

--
-- Database: `captex`
--

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

--
-- Table structure for table `accounts`
--

DROP TABLE IF EXISTS `accounts`;
CREATE TABLE IF NOT EXISTS `accounts` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `code` varchar(191) DEFAULT NULL,
  `provider` varchar(191) DEFAULT NULL,
  `type_method` varchar(191) NOT NULL DEFAULT 'offline',
  `account_type` varchar(191) NOT NULL DEFAULT 'offline',
  `type` enum('asset','liability','income','expense','equity') NOT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `store_id` varchar(125) DEFAULT NULL,
  `store_password` varchar(125) DEFAULT NULL,
  `merchant_id` varchar(125) DEFAULT NULL,
  `api_key` varchar(125) DEFAULT NULL,
  `signature_key` varchar(125) DEFAULT NULL,
  `app_key` varchar(125) DEFAULT NULL,
  `app_secret` varchar(125) DEFAULT NULL,
  `username` varchar(125) DEFAULT NULL,
  `password` varchar(125) DEFAULT NULL,
  `merchant_number` varchar(125) DEFAULT NULL,
  `public_key` varchar(125) DEFAULT NULL,
  `private_key` varchar(125) DEFAULT NULL,
  `client_id` varchar(125) DEFAULT NULL,
  `secret` varchar(125) DEFAULT NULL,
  `publishable` varchar(125) DEFAULT NULL,
  `cash` varchar(125) NOT NULL DEFAULT 'cash',
  `branch_id` varchar(125) NOT NULL DEFAULT '0',
  `sandbox_status` varchar(125) NOT NULL DEFAULT '1',
  `charge` decimal(8,2) NOT NULL DEFAULT 1.00,
  `banach` varchar(125) DEFAULT NULL,
  `country` varchar(125) DEFAULT NULL,
  `creator` bigint(20) UNSIGNED NOT NULL DEFAULT 1,
  `updater` bigint(20) UNSIGNED NOT NULL DEFAULT 1,
  `upload_id` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `balance` decimal(12,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `achivements`
--

DROP TABLE IF EXISTS `achivements`;
CREATE TABLE IF NOT EXISTS `achivements` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(125) DEFAULT NULL,
  `counter` int(11) NOT NULL DEFAULT 0,
  `sub_title` varchar(125) DEFAULT NULL,
  `icon` varchar(125) DEFAULT NULL,
  `creator` varchar(125) NOT NULL DEFAULT '0',
  `updater` varchar(125) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `blogs`;
CREATE TABLE IF NOT EXISTS `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(125) NOT NULL,
  `slug` varchar(125) NOT NULL,
  `short_description` varchar(125) NOT NULL,
  `upload_id` varchar(125) DEFAULT NULL,
  `creator` varchar(125) NOT NULL,
  `updater` varchar(125) NOT NULL,
  `published_at` datetime DEFAULT NULL,
  `description` text NOT NULL,
  `status` varchar(125) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `blog_blog_category`
--

DROP TABLE IF EXISTS `blog_blog_category`;
CREATE TABLE IF NOT EXISTS `blog_blog_category` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `blog_id` bigint(20) UNSIGNED NOT NULL,
  `blog_category_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `blog_blog_category_blog_id_foreign` (`blog_id`),
  KEY `blog_blog_category_blog_category_id_foreign` (`blog_category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `blog_categories`;
CREATE TABLE IF NOT EXISTS `blog_categories` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) NOT NULL,
  `slug` varchar(125) NOT NULL,
  `upload_id` varchar(125) DEFAULT NULL,
  `status` varchar(125) NOT NULL,
  `creator` varchar(125) NOT NULL,
  `updater` varchar(125) NOT NULL,
  `position_order` int(11) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `brands`;
CREATE TABLE IF NOT EXISTS `brands` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `creator` bigint(20) NOT NULL,
  `name` varchar(125) NOT NULL,
  `slug` varchar(125) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `upload_id` varchar(125) DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `brands` (`id`, `creator`, `name`, `slug`, `status`, `upload_id`, `created_at`, `updated_at`) VALUES
(1, 1, 'Uncategorized', 'uncategorized', 1, NULL, '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000');

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

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

DROP TABLE IF EXISTS `cache`;
CREATE TABLE IF NOT EXISTS `cache` (
  `key` varchar(191) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` bigint(20) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache`
--

INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES
('captex-cache-setting_server_side_tracking_status_24', 's:27:\"Server Side Tracking Status\";', 1784120762),
('captex-cache-setting_google_tag_analysis_status_24', 's:26:\"Google Tag Analysis Status\";', 1784120762),
('captex-cache-setting_facebook_pixel_status_24', 's:21:\"Facebook Pixel Status\";', 1784120762),
('captex-cache-setting_app_image_9', 's:9:\"App Image\";', 1784120763),
('captex-cache-upload_name_App Image', 'b:0;', 1784120763),
('captex-cache-setting_app_footer_image_9', 's:16:\"App Footer Image\";', 1784120763),
('captex-cache-upload_name_App Footer Image', 'b:0;', 1784120763),
('captex-cache-spatie.permission.cache', 'a:3:{s:5:\"alias\";a:4:{s:1:\"a\";s:2:\"id\";s:1:\"b\";s:4:\"name\";s:1:\"c\";s:10:\"guard_name\";s:1:\"r\";s:5:\"roles\";}s:11:\"permissions\";a:197:{i:0;a:4:{s:1:\"a\";i:1;s:1:\"b\";s:9:\"user read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:1;a:4:{s:1:\"a\";i:2;s:1:\"b\";s:11:\"user create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:2;a:4:{s:1:\"a\";i:3;s:1:\"b\";s:9:\"user edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:3;a:4:{s:1:\"a\";i:4;s:1:\"b\";s:15:\"user rolechange\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:4;a:4:{s:1:\"a\";i:5;s:1:\"b\";s:11:\"user delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:5;a:4:{s:1:\"a\";i:6;s:1:\"b\";s:9:\"role read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:6;a:4:{s:1:\"a\";i:7;s:1:\"b\";s:11:\"role create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:7;a:4:{s:1:\"a\";i:8;s:1:\"b\";s:9:\"role edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:8;a:4:{s:1:\"a\";i:9;s:1:\"b\";s:11:\"role delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:9;a:4:{s:1:\"a\";i:10;s:1:\"b\";s:12:\"account read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:10;a:4:{s:1:\"a\";i:11;s:1:\"b\";s:14:\"account create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:11;a:4:{s:1:\"a\";i:12;s:1:\"b\";s:12:\"account edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:12;a:4:{s:1:\"a\";i:13;s:1:\"b\";s:14:\"account delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:13;a:4:{s:1:\"a\";i:14;s:1:\"b\";s:12:\"product read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:14;a:4:{s:1:\"a\";i:15;s:1:\"b\";s:14:\"product create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:15;a:4:{s:1:\"a\";i:16;s:1:\"b\";s:12:\"product edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:16;a:4:{s:1:\"a\";i:17;s:1:\"b\";s:14:\"product delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:17;a:4:{s:1:\"a\";i:18;s:1:\"b\";s:15:\"product barcode\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:18;a:4:{s:1:\"a\";i:19;s:1:\"b\";s:9:\"unit read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:19;a:4:{s:1:\"a\";i:20;s:1:\"b\";s:11:\"unit create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:20;a:4:{s:1:\"a\";i:21;s:1:\"b\";s:9:\"unit edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:21;a:4:{s:1:\"a\";i:22;s:1:\"b\";s:11:\"unit delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:22;a:4:{s:1:\"a\";i:23;s:1:\"b\";s:13:\"purchase read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:23;a:4:{s:1:\"a\";i:24;s:1:\"b\";s:15:\"purchase create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:24;a:4:{s:1:\"a\";i:25;s:1:\"b\";s:13:\"purchase edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:25;a:4:{s:1:\"a\";i:26;s:1:\"b\";s:15:\"purchase delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:26;a:4:{s:1:\"a\";i:27;s:1:\"b\";s:16:\"refcustomer read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:27;a:4:{s:1:\"a\";i:28;s:1:\"b\";s:13:\"customer read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:28;a:4:{s:1:\"a\";i:29;s:1:\"b\";s:15:\"customer create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:29;a:4:{s:1:\"a\";i:30;s:1:\"b\";s:13:\"customer edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:30;a:4:{s:1:\"a\";i:31;s:1:\"b\";s:15:\"customer delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:31;a:4:{s:1:\"a\";i:32;s:1:\"b\";s:10:\"stock read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:32;a:4:{s:1:\"a\";i:33;s:1:\"b\";s:12:\"generic read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:33;a:4:{s:1:\"a\";i:34;s:1:\"b\";s:14:\"generic create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:34;a:4:{s:1:\"a\";i:35;s:1:\"b\";s:12:\"generic edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:35;a:4:{s:1:\"a\";i:36;s:1:\"b\";s:14:\"generic delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:36;a:4:{s:1:\"a\";i:37;s:1:\"b\";s:13:\"supplier read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:37;a:4:{s:1:\"a\";i:38;s:1:\"b\";s:15:\"supplier create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:38;a:4:{s:1:\"a\";i:39;s:1:\"b\";s:13:\"supplier edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:39;a:4:{s:1:\"a\";i:40;s:1:\"b\";s:15:\"supplier delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:40;a:4:{s:1:\"a\";i:41;s:1:\"b\";s:13:\"category read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:41;a:4:{s:1:\"a\";i:42;s:1:\"b\";s:15:\"category create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:42;a:4:{s:1:\"a\";i:43;s:1:\"b\";s:13:\"category edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:43;a:4:{s:1:\"a\";i:44;s:1:\"b\";s:15:\"category delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:44;a:4:{s:1:\"a\";i:45;s:1:\"b\";s:16:\"subcategory read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:45;a:4:{s:1:\"a\";i:46;s:1:\"b\";s:18:\"subcategory create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:46;a:4:{s:1:\"a\";i:47;s:1:\"b\";s:16:\"subcategory edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:47;a:4:{s:1:\"a\";i:48;s:1:\"b\";s:18:\"subcategory delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:48;a:4:{s:1:\"a\";i:49;s:1:\"b\";s:19:\"subsubcategory read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:49;a:4:{s:1:\"a\";i:50;s:1:\"b\";s:21:\"subsubcategory create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:50;a:4:{s:1:\"a\";i:51;s:1:\"b\";s:19:\"subsubcategory edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:51;a:4:{s:1:\"a\";i:52;s:1:\"b\";s:21:\"subsubcategory delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:52;a:4:{s:1:\"a\";i:53;s:1:\"b\";s:10:\"brand read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:53;a:4:{s:1:\"a\";i:54;s:1:\"b\";s:12:\"brand create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:54;a:4:{s:1:\"a\";i:55;s:1:\"b\";s:10:\"brand edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:55;a:4:{s:1:\"a\";i:56;s:1:\"b\";s:12:\"brand delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:56;a:4:{s:1:\"a\";i:57;s:1:\"b\";s:11:\"client read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:57;a:4:{s:1:\"a\";i:58;s:1:\"b\";s:13:\"client create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:58;a:4:{s:1:\"a\";i:59;s:1:\"b\";s:11:\"client edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:59;a:4:{s:1:\"a\";i:60;s:1:\"b\";s:13:\"client delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:60;a:4:{s:1:\"a\";i:61;s:1:\"b\";s:12:\"project read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:61;a:4:{s:1:\"a\";i:62;s:1:\"b\";s:14:\"project create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:62;a:4:{s:1:\"a\";i:63;s:1:\"b\";s:12:\"project edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:63;a:4:{s:1:\"a\";i:64;s:1:\"b\";s:14:\"project delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:64;a:4:{s:1:\"a\";i:65;s:1:\"b\";s:8:\"vat read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:65;a:4:{s:1:\"a\";i:66;s:1:\"b\";s:10:\"vat create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:66;a:4:{s:1:\"a\";i:67;s:1:\"b\";s:8:\"vat edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:67;a:4:{s:1:\"a\";i:68;s:1:\"b\";s:10:\"vat delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:68;a:4:{s:1:\"a\";i:69;s:1:\"b\";s:11:\"coupon read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:69;a:4:{s:1:\"a\";i:70;s:1:\"b\";s:13:\"coupon create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:70;a:4:{s:1:\"a\";i:71;s:1:\"b\";s:11:\"coupon edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:71;a:4:{s:1:\"a\";i:72;s:1:\"b\";s:13:\"coupon delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:72;a:4:{s:1:\"a\";i:73;s:1:\"b\";s:13:\"discount read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:73;a:4:{s:1:\"a\";i:74;s:1:\"b\";s:15:\"discount create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:74;a:4:{s:1:\"a\";i:75;s:1:\"b\";s:13:\"discount edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:75;a:4:{s:1:\"a\";i:76;s:1:\"b\";s:15:\"discount delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:76;a:4:{s:1:\"a\";i:77;s:1:\"b\";s:8:\"pos read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:77;a:4:{s:1:\"a\";i:78;s:1:\"b\";s:10:\"pos create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:78;a:4:{s:1:\"a\";i:79;s:1:\"b\";s:8:\"pos edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:79;a:4:{s:1:\"a\";i:80;s:1:\"b\";s:10:\"pos delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:80;a:4:{s:1:\"a\";i:81;s:1:\"b\";s:21:\"siteverification read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:81;a:4:{s:1:\"a\";i:82;s:1:\"b\";s:21:\"siteverification edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:82;a:4:{s:1:\"a\";i:83;s:1:\"b\";s:18:\"tagmanagement read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:83;a:4:{s:1:\"a\";i:84;s:1:\"b\";s:18:\"tagmanagement edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:84;a:4:{s:1:\"a\";i:85;s:1:\"b\";s:8:\"pwa read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:85;a:4:{s:1:\"a\";i:86;s:1:\"b\";s:8:\"pwa edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:86;a:4:{s:1:\"a\";i:87;s:1:\"b\";s:10:\"takto read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:87;a:4:{s:1:\"a\";i:88;s:1:\"b\";s:10:\"takto edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:88;a:4:{s:1:\"a\";i:89;s:1:\"b\";s:11:\"cookie read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:89;a:4:{s:1:\"a\";i:90;s:1:\"b\";s:11:\"cookie edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:90;a:4:{s:1:\"a\";i:91;s:1:\"b\";s:9:\"smtp read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:91;a:4:{s:1:\"a\";i:92;s:1:\"b\";s:9:\"smtp edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:92;a:4:{s:1:\"a\";i:93;s:1:\"b\";s:24:\"payment_credentials read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:93;a:4:{s:1:\"a\";i:94;s:1:\"b\";s:24:\"payment_credentials edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:94;a:4:{s:1:\"a\";i:95;s:1:\"b\";s:16:\"maintenance mode\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:95;a:4:{s:1:\"a\";i:96;s:1:\"b\";s:17:\"maintenance debug\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:96;a:4:{s:1:\"a\";i:97;s:1:\"b\";s:20:\"maintenance database\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:97;a:4:{s:1:\"a\";i:98;s:1:\"b\";s:15:\"database backup\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:98;a:4:{s:1:\"a\";i:99;s:1:\"b\";s:29:\"settings payment_configration\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:99;a:4:{s:1:\"a\";i:100;s:1:\"b\";s:13:\"settings main\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:100;a:4:{s:1:\"a\";i:101;s:1:\"b\";s:26:\"settings site_verification\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:101;a:4:{s:1:\"a\";i:102;s:1:\"b\";s:17:\"settings site_tag\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:102;a:4:{s:1:\"a\";i:103;s:1:\"b\";s:24:\"settings tracking_report\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:103;a:4:{s:1:\"a\";i:104;s:1:\"b\";s:17:\"settings site_pwa\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:104;a:4:{s:1:\"a\";i:105;s:1:\"b\";s:19:\"settings messagesdk\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:105;a:4:{s:1:\"a\";i:106;s:1:\"b\";s:15:\"settings cookie\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:106;a:4:{s:1:\"a\";i:107;s:1:\"b\";s:22:\"settings email_setting\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:107;a:4:{s:1:\"a\";i:108;s:1:\"b\";s:15:\"imap management\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:108;a:4:{s:1:\"a\";i:109;s:1:\"b\";s:25:\"settings sms_configration\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:109;a:4:{s:1:\"a\";i:110;s:1:\"b\";s:29:\"settings courier_configration\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:110;a:4:{s:1:\"a\";i:111;s:1:\"b\";s:22:\"settings custom_js_css\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:111;a:4:{s:1:\"a\";i:112;s:1:\"b\";s:16:\"sms_configration\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:112;a:4:{s:1:\"a\";i:113;s:1:\"b\";s:9:\"sale read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:113;a:4:{s:1:\"a\";i:114;s:1:\"b\";s:11:\"sale create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:114;a:4:{s:1:\"a\";i:115;s:1:\"b\";s:9:\"sale edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:115;a:4:{s:1:\"a\";i:116;s:1:\"b\";s:11:\"sale delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:116;a:4:{s:1:\"a\";i:117;s:1:\"b\";s:12:\"view_reports\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:117;a:4:{s:1:\"a\";i:118;s:1:\"b\";s:12:\"reports read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:118;a:4:{s:1:\"a\";i:119;s:1:\"b\";s:14:\"reports export\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:119;a:4:{s:1:\"a\";i:120;s:1:\"b\";s:16:\"whychooseus read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:120;a:4:{s:1:\"a\";i:121;s:1:\"b\";s:18:\"whychooseus create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:121;a:4:{s:1:\"a\";i:122;s:1:\"b\";s:16:\"whychooseus edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:122;a:4:{s:1:\"a\";i:123;s:1:\"b\";s:18:\"whychooseus delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:123;a:4:{s:1:\"a\";i:124;s:1:\"b\";s:15:\"achivement read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:124;a:4:{s:1:\"a\";i:125;s:1:\"b\";s:17:\"achivement create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:125;a:4:{s:1:\"a\";i:126;s:1:\"b\";s:15:\"achivement edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:126;a:4:{s:1:\"a\";i:127;s:1:\"b\";s:17:\"achivement delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:127;a:4:{s:1:\"a\";i:128;s:1:\"b\";s:21:\"custom_sale type read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:128;a:4:{s:1:\"a\";i:129;s:1:\"b\";s:21:\"custom_sale bulk read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:129;a:4:{s:1:\"a\";i:130;s:1:\"b\";s:23:\"custom_sale custom read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:130;a:4:{s:1:\"a\";i:131;s:1:\"b\";s:16:\"sale_status read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:131;a:4:{s:1:\"a\";i:132;s:1:\"b\";s:18:\"sale_status delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:132;a:4:{s:1:\"a\";i:133;s:1:\"b\";s:16:\"sale_status edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:133;a:4:{s:1:\"a\";i:134;s:1:\"b\";s:18:\"sale_status create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:134;a:4:{s:1:\"a\";i:135;s:1:\"b\";s:16:\"offerbanner read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:135;a:4:{s:1:\"a\";i:136;s:1:\"b\";s:18:\"offerbanner create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:136;a:4:{s:1:\"a\";i:137;s:1:\"b\";s:16:\"offerbanner edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:137;a:4:{s:1:\"a\";i:138;s:1:\"b\";s:18:\"offerbanner delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:138;a:4:{s:1:\"a\";i:139;s:1:\"b\";s:12:\"profile read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:139;a:4:{s:1:\"a\";i:140;s:1:\"b\";s:14:\"profile create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:140;a:4:{s:1:\"a\";i:141;s:1:\"b\";s:12:\"profile edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:141;a:4:{s:1:\"a\";i:142;s:1:\"b\";s:14:\"profile delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:142;a:4:{s:1:\"a\";i:143;s:1:\"b\";s:10:\"theme read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:143;a:4:{s:1:\"a\";i:144;s:1:\"b\";s:18:\"blog category read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:144;a:4:{s:1:\"a\";i:145;s:1:\"b\";s:20:\"blog category create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:145;a:4:{s:1:\"a\";i:146;s:1:\"b\";s:18:\"blog category edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:146;a:4:{s:1:\"a\";i:147;s:1:\"b\";s:20:\"blog category delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:147;a:4:{s:1:\"a\";i:148;s:1:\"b\";s:9:\"blog read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:148;a:4:{s:1:\"a\";i:149;s:1:\"b\";s:11:\"blog create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:149;a:4:{s:1:\"a\";i:150;s:1:\"b\";s:9:\"blog edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:150;a:4:{s:1:\"a\";i:151;s:1:\"b\";s:11:\"blog delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:151;a:4:{s:1:\"a\";i:152;s:1:\"b\";s:17:\"sub-scribers read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:152;a:4:{s:1:\"a\";i:153;s:1:\"b\";s:19:\"sub-scribers create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:153;a:4:{s:1:\"a\";i:154;s:1:\"b\";s:17:\"sub-scribers edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:154;a:4:{s:1:\"a\";i:155;s:1:\"b\";s:19:\"sub-scribers delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:155;a:4:{s:1:\"a\";i:156;s:1:\"b\";s:19:\"sub-scribers mailer\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:156;a:4:{s:1:\"a\";i:157;s:1:\"b\";s:19:\"reftransection read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:157;a:4:{s:1:\"a\";i:158;s:1:\"b\";s:16:\"transection read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:158;a:4:{s:1:\"a\";i:159;s:1:\"b\";s:18:\"transection create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:159;a:4:{s:1:\"a\";i:160;s:1:\"b\";s:16:\"transection edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:160;a:4:{s:1:\"a\";i:161;s:1:\"b\";s:18:\"transection delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:161;a:4:{s:1:\"a\";i:162;s:1:\"b\";s:11:\"slider read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:162;a:4:{s:1:\"a\";i:163;s:1:\"b\";s:13:\"slider create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:163;a:4:{s:1:\"a\";i:164;s:1:\"b\";s:11:\"slider edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:164;a:4:{s:1:\"a\";i:165;s:1:\"b\";s:13:\"slider delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:165;a:4:{s:1:\"a\";i:166;s:1:\"b\";s:12:\"service read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:166;a:4:{s:1:\"a\";i:167;s:1:\"b\";s:14:\"service create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:167;a:4:{s:1:\"a\";i:168;s:1:\"b\";s:12:\"service edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:168;a:4:{s:1:\"a\";i:169;s:1:\"b\";s:14:\"service delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:169;a:4:{s:1:\"a\";i:170;s:1:\"b\";s:16:\"testimonial read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:170;a:4:{s:1:\"a\";i:171;s:1:\"b\";s:18:\"testimonial create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:171;a:4:{s:1:\"a\";i:172;s:1:\"b\";s:16:\"testimonial edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:172;a:4:{s:1:\"a\";i:173;s:1:\"b\";s:18:\"testimonial delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:173;a:4:{s:1:\"a\";i:174;s:1:\"b\";s:22:\"footerlinkheading read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:174;a:4:{s:1:\"a\";i:175;s:1:\"b\";s:24:\"footerlinkheading create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:175;a:4:{s:1:\"a\";i:176;s:1:\"b\";s:22:\"footerlinkheading edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:176;a:4:{s:1:\"a\";i:177;s:1:\"b\";s:24:\"footerlinkheading delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:177;a:4:{s:1:\"a\";i:178;s:1:\"b\";s:25:\"footerlinksubheading read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:178;a:4:{s:1:\"a\";i:179;s:1:\"b\";s:27:\"footerlinksubheading create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:179;a:4:{s:1:\"a\";i:180;s:1:\"b\";s:25:\"footerlinksubheading edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:180;a:4:{s:1:\"a\";i:181;s:1:\"b\";s:27:\"footerlinksubheading delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:181;a:4:{s:1:\"a\";i:182;s:1:\"b\";s:14:\"headernav read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:182;a:4:{s:1:\"a\";i:183;s:1:\"b\";s:16:\"headernav create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:183;a:4:{s:1:\"a\";i:184;s:1:\"b\";s:14:\"headernav edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:184;a:4:{s:1:\"a\";i:185;s:1:\"b\";s:16:\"headernav delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:185;a:4:{s:1:\"a\";i:186;s:1:\"b\";s:8:\"faq read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:186;a:4:{s:1:\"a\";i:187;s:1:\"b\";s:10:\"faq create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:187;a:4:{s:1:\"a\";i:188;s:1:\"b\";s:8:\"faq edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:188;a:4:{s:1:\"a\";i:189;s:1:\"b\";s:10:\"faq delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:189;a:4:{s:1:\"a\";i:190;s:1:\"b\";s:9:\"page read\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:190;a:4:{s:1:\"a\";i:191;s:1:\"b\";s:11:\"page create\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:191;a:4:{s:1:\"a\";i:192;s:1:\"b\";s:9:\"page edit\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:192;a:4:{s:1:\"a\";i:193;s:1:\"b\";s:11:\"page delete\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:193;a:4:{s:1:\"a\";i:194;s:1:\"b\";s:12:\"migrate seed\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:194;a:4:{s:1:\"a\";i:195;s:1:\"b\";s:7:\"migrate\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:195;a:4:{s:1:\"a\";i:196;s:1:\"b\";s:12:\"catche clear\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}i:196;a:4:{s:1:\"a\";i:197;s:1:\"b\";s:13:\"migrate fresh\";s:1:\"c\";s:3:\"web\";s:1:\"r\";a:1:{i:0;i:1;}}}s:5:\"roles\";a:1:{i:0;a:3:{s:1:\"a\";i:1;s:1:\"b\";s:10:\"superadmin\";s:1:\"c\";s:3:\"web\";}}}', 1784185670),
('captex-cache-setting_app_fav_image_9', 's:13:\"App Fav Image\";', 1784120870),
('captex-cache-upload_name_App Fav Image', 'b:0;', 1784120870),
('captex-cache-setting_theme_brand_link_1', 's:16:\"Theme Brand Link\";', 1784120870),
('captex-cache-upload_name_35', 's:72:\"Artboard_3_c81fab2e_4e65_466a_b12f_abaa0bf312ca_1784102345607_8h3je6.jpg\";', 1784128022),
('captex-cache-upload_name_19', 's:64:\"01_c20354f5_8ab1_4214_a2f5_719eed27c6de_1784099890709_rw2a0p.jpg\";', 1784121986),
('captex-cache-upload_name_14', 's:63:\"9_fd67f579_970e_4041_80ad_4bddab0782fe_1784099889874_pvgmle.jpg\";', 1784121996),
('captex-cache-upload_name_5', 's:64:\"04_6880cdbf_7434_4b9d_8f56_436718be7932_1784099888448_gw2bs3.jpg\";', 1784121996),
('captex-cache-upload_name_1', 's:64:\"01_559a6cc1_7f4b_4fe9_9b88_3bbf4bd5c202_1784099853063_x6276e.jpg\";', 1784122037),
('captex-cache-upload_name_6', 's:63:\"4_a5c1f162_975f_4867_b50b_85407330084e_1784099888593_pxd0rp.jpg\";', 1784123037),
('captex-cache-upload_name_11', 's:72:\"Artboard_1_307e0336_71c0_49d3_ae57_5aa7d6a5933a_1784099889363_4u7n95.jpg\";', 1784123037),
('captex-cache-upload_name_17', 's:63:\"8_42e3cb15_3613_4a65_a824_b7e83024ba22_1784099890416_r8g3ch.jpg\";', 1784123051),
('captex-cache-upload_name_44', 's:47:\"Homeland_Series_Poster_1784102347143_lbfdcn.jpg\";', 1784124059),
('captex-cache-upload_name_28', 's:64:\"19_2249d0da_9788_4ff8_b44e_8540940abca3_1784102344363_fgt1ir.jpg\";', 1784124059),
('captex-cache-upload_name_42', 's:42:\"Elegante_Zero_jpg_1784102346810_8ki02x.jpg\";', 1784124320),
('captex-cache-upload_name_4', 's:64:\"03_1c9bc672_903d_4a4d_88af_4d1a166250ef_1784099888289_bmhkz5.jpg\";', 1784124389),
('captex-cache-upload_name_8', 's:63:\"7_4eaf2343_36d5_4709_9e37_de5240f69fb3_1784099888900_2540zx.jpg\";', 1784124389),
('captex-cache-upload_name_13', 's:63:\"3_aa312958_3bbe_41e0_8440_e10217f59508_1784099889709_9x42e2.jpg\";', 1784124554),
('captex-cache-upload_name_3', 's:64:\"02_e4c86bd2_9aeb_4f1f_b2cd_c9d576822e84_1784099888129_zygoyx.jpg\";', 1784124554),
('captex-cache-upload_name_26', 's:64:\"13_55ea5a20_cb51_431a_8619_5b536f7d52ca_1784102344013_kvyljl.jpg\";', 1784124681),
('captex-cache-upload_name_49', 's:31:\"Square_1784102347962_cxvfx8.jpg\";', 1784124763),
('captex-cache-upload_name_27', 's:64:\"17_8d45c7d1_7e35_4344_9378_a7201a177037_1784102344204_1f99vd.jpg\";', 1784124763),
('captex-cache-upload_name_40', 's:36:\"Edge_Series_1784102346488_9r9dwx.jpg\";', 1784125892),
('captex-cache-upload_name_60', 's:23:\"2064071724587762728.jpg\";', 1784126565),
('captex-cache-upload_name_32', 's:72:\"Artboard_2_9b736da4_a72a_420c_b6b2_5b9ee4f4d8cd_1784102345001_hugic9.jpg\";', 1784126586),
('captex-cache-upload_name_37', 's:72:\"Artboard_8_45726dfa_2572_4be9_883d_bd7abed88794_1784102345935_79wxq3.jpg\";', 1784126804),
('captex-cache-upload_name_21', 's:41:\"01__CYBER_STRIKE_1784102343134_6m2z6m.jpg\";', 1784127135),
('captex-cache-upload_name_22', 's:82:\"01_01_Product_Poster_d7b960ee_a3b5_4deb_af4b_36bc1df33a7d_1784102343305_v77q29.jpg\";', 1784127135),
('captex-cache-upload_name_29', 's:78:\"484996597_965701689035653_9030764570763038217_n_1000x_1784102344520_mg4qy4.jpg\";', 1784127270),
('captex-cache-upload_name_33', 's:72:\"Artboard_2_c2d1d514_b6cd_4409_a490_a50bb5a3a1af_1784102345271_bvq949.jpg\";', 1784127648),
('captex-cache-setting_currency_symbol_9', 's:11:\"BDT `price`\";', 1784127361),
('captex-cache-setting_app_name_short_9', 's:14:\"App Name Short\";', 1784127361),
('captex-cache-setting_login_admin_image_9', 's:17:\"Login Admin Image\";', 1784127313),
('captex-cache-upload_name_Login Admin Image', 'b:0;', 1784127313),
('captex-cache-setting_category_10', 's:8:\"Category\";', 1784134358),
('captex-cache-setting_app_maps_9', 's:8:\"App Maps\";', 1784127313),
('captex-cache-setting_app_map_embaded_url_9', 's:19:\"App Map Embaded Url\";', 1784127313),
('captex-cache-setting_opening_time_9', 's:12:\"Opening Time\";', 1784127313),
('captex-cache-setting_app_address_9', 's:11:\"App Address\";', 1784127313),
('captex-cache-setting_theme_color_9', 's:11:\"Theme Color\";', 1784127313),
('captex-cache-setting_is_demo_mode_status_9', 's:19:\"Is Demo Mode Status\";', 1784127313),
('captex-cache-setting_same_type_product_buy_status_9', 's:28:\"Same Type Product Buy Status\";', 1784127313),
('captex-cache-setting_out_of_inventory_status_9', 's:23:\"Out Of Inventory Status\";', 1784127313),
('captex-cache-setting_invoice_terms_9', 's:13:\"Invoice Terms\";', 1784127313),
('captex-cache-upload_name_15', 's:72:\"Artboard_5_46d4851d_2de9_46ff_92c5_032e405fa763_1784099890035_mhftf4.jpg\";', 1784128043),
('captex-cache-upload_name_43', 's:38:\"Forever_Black_1784102346963_iig1c3.jpg\";', 1784128229),
('captex-cache-upload_name_16', 's:72:\"Artboard_4_96a12e13_b897_4212_9a09_90f5de533c3e_1784099890270_nfq0wk.jpg\";', 1784128273),
('captex-cache-upload_name_23', 's:51:\"1__SPEEDSTER_CAP___HGCSS04_1784102343485_l96g2u.jpg\";', 1784128273),
('captex-cache-setting_role_permision_10', 's:14:\"Role Permision\";', 1784129038),
('captex-cache-setting_app_title_9', 's:9:\"App Title\";', 1784133238),
('captex-cache-setting_currency_symbol_code_9', 's:20:\"Currency Symbol Code\";', 1784133238),
('captex-cache-setting_app_about_9', 's:9:\"App About\";', 1784133238),
('captex-cache-setting_app_keywords_9', 's:12:\"App Keywords\";', 1784133238),
('captex-cache-setting_return_refund_policy_editor_9', 's:34:\"<p>Return Refund Policy Editor</p>\";', 1784133238),
('captex-cache-setting_sliders_10', 's:7:\"Sliders\";', 1784133265),
('captex-cache-setting_services_10', 's:8:\"Services\";', 1784133288);

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

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

DROP TABLE IF EXISTS `cache_locks`;
CREATE TABLE IF NOT EXISTS `cache_locks` (
  `key` varchar(191) NOT NULL,
  `owner` varchar(191) NOT NULL,
  `expiration` bigint(20) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `carts`
--

DROP TABLE IF EXISTS `carts`;
CREATE TABLE IF NOT EXISTS `carts` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `unique_user` varchar(125) NOT NULL,
  `items` text DEFAULT NULL,
  `total_price` varchar(125) NOT NULL DEFAULT '0',
  `total_items` varchar(125) NOT NULL DEFAULT '0',
  `wishlist` text DEFAULT NULL,
  `wishlist_items` varchar(125) NOT NULL DEFAULT '0',
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
CREATE TABLE IF NOT EXISTS `categories` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `creator` bigint(20) NOT NULL,
  `name` varchar(125) NOT NULL,
  `slug` varchar(125) NOT NULL,
  `position_order` bigint(20) NOT NULL DEFAULT 0,
  `description` text DEFAULT NULL,
  `primary_description` text DEFAULT NULL,
  `additional_description` text DEFAULT NULL,
  `need_additional` varchar(125) NOT NULL DEFAULT '1',
  `status` varchar(125) NOT NULL DEFAULT '1',
  `upload_id` varchar(125) DEFAULT NULL,
  `upload_bg` varchar(125) DEFAULT NULL,
  `service_status` tinyint(1) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` (`id`, `creator`, `name`, `slug`, `position_order`, `description`, `primary_description`, `additional_description`, `need_additional`, `status`, `upload_id`, `upload_bg`, `service_status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'Uncategorized', 'uncategorized', 0, '', '', '', '1', '0', '0', '0', 0, NULL, '2026-07-15 01:07:41.000000', '2026-07-15 02:43:21.000000'),
(2, 1, 'Mountain Cap', 'mountain-cap', 0, '', '', '', '0', '1', '44', '28', 0, NULL, '2026-07-15 01:19:37.000000', '2026-07-15 02:18:48.000000'),
(3, 1, 'Dark Cap', 'dark-cap', 0, '', '', '', '0', '1', '26', '49', 1, NULL, '2026-07-15 02:11:16.000000', '2026-07-15 02:19:03.000000'),
(4, 1, 'Yoyo Cap', 'yoyo-cap', 0, '', '', '', '0', '1', '27', '49', 1, NULL, '2026-07-15 02:12:08.000000', '2026-07-15 02:19:18.000000'),
(5, 1, 'premium Cap', 'premium-cap', 0, '', '', '', '0', '1', '40', '32', 1, NULL, '2026-07-15 02:30:50.000000', '2026-07-15 02:30:50.000000'),
(6, 1, 'D cap', 'd-cap', 0, '', '', '', '0', '1', '37', '21', 1, NULL, '2026-07-15 02:44:51.000000', '2026-07-15 02:44:51.000000'),
(7, 1, 'S Cap', 's-cap', 0, '', '', '', '0', '1', '33', '29', 1, NULL, '2026-07-15 02:53:03.000000', '2026-07-15 02:53:03.000000'),
(8, 1, 'E cap', 'e-cap', 0, '', '', '', '0', '1', '15', '35', 1, NULL, '2026-07-15 03:06:11.000000', '2026-07-15 03:06:11.000000');

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

--
-- Table structure for table `clients`
--

DROP TABLE IF EXISTS `clients`;
CREATE TABLE IF NOT EXISTS `clients` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `creator` bigint(20) NOT NULL,
  `name` varchar(125) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `upload_id` varchar(125) DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `company_permissions`
--

DROP TABLE IF EXISTS `company_permissions`;
CREATE TABLE IF NOT EXISTS `company_permissions` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `key` bigint(20) NOT NULL DEFAULT 0,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `compare_styles`
--

DROP TABLE IF EXISTS `compare_styles`;
CREATE TABLE IF NOT EXISTS `compare_styles` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` varchar(125) NOT NULL,
  `title` varchar(125) NOT NULL,
  `upload_id` varchar(125) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `background_color` varchar(125) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `coupons`;
CREATE TABLE IF NOT EXISTS `coupons` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `code` varchar(125) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '0 = percent, 1 = fixed',
  `amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `expire_date` datetime DEFAULT NULL,
  `creator` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `updater` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `coupons`
--

INSERT INTO `coupons` (`id`, `title`, `code`, `details`, `type`, `amount`, `expire_date`, `creator`, `updater`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Uncategorized', 'uncategorized', 'percentage', 1, 10.00, '2026-08-14 07:07:41', 0, 0, 1, '2026-07-15 01:07:41', '2026-07-15 01:07:41'),
(2, 'Mirpur', 'Mirpur-11', 'Mirpur-11', 1, 50.00, '2026-07-16 16:58:00', 0, 0, 1, '2026-07-15 04:58:18', '2026-07-15 04:58:18');

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

--
-- Table structure for table `coupon_use_histories`
--

DROP TABLE IF EXISTS `coupon_use_histories`;
CREATE TABLE IF NOT EXISTS `coupon_use_histories` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `customer_id` varchar(125) DEFAULT NULL,
  `coupon_id` varchar(125) DEFAULT NULL,
  `sale_id` varchar(125) DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `courier_credentials`
--

DROP TABLE IF EXISTS `courier_credentials`;
CREATE TABLE IF NOT EXISTS `courier_credentials` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `upload_id` varchar(125) DEFAULT NULL,
  `provider` varchar(125) DEFAULT NULL,
  `Secret_Key` varchar(125) DEFAULT NULL,
  `Api_Key` varchar(125) DEFAULT NULL,
  `client_id` varchar(125) DEFAULT NULL,
  `client_secret` varchar(125) DEFAULT NULL,
  `secret_token` varchar(125) DEFAULT NULL,
  `key` varchar(125) DEFAULT NULL,
  `sandbox_status` varchar(125) NOT NULL DEFAULT '1',
  `status` varchar(125) NOT NULL DEFAULT '1',
  `creator` bigint(20) NOT NULL DEFAULT 1,
  `updater` bigint(20) NOT NULL DEFAULT 1,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `customers`
--

DROP TABLE IF EXISTS `customers`;
CREATE TABLE IF NOT EXISTS `customers` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) DEFAULT NULL,
  `email` varchar(125) DEFAULT NULL,
  `phone` varchar(125) DEFAULT NULL,
  `shop_name` varchar(125) DEFAULT NULL,
  `shop_phone` varchar(125) DEFAULT NULL,
  `shop_address` varchar(125) DEFAULT NULL,
  `type` varchar(125) DEFAULT NULL,
  `user_id` varchar(125) DEFAULT NULL,
  `creator` varchar(125) DEFAULT NULL,
  `location` varchar(125) DEFAULT NULL,
  `account_holder` varchar(125) DEFAULT NULL,
  `account_number` varchar(125) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `bank_name` varchar(125) DEFAULT NULL,
  `password` varchar(125) DEFAULT NULL,
  `v_code` varchar(125) DEFAULT NULL,
  `v_status` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `bank_branch` varchar(125) DEFAULT NULL,
  `upload_id` varchar(125) NOT NULL DEFAULT '0',
  `facebook_id` varchar(125) DEFAULT NULL,
  `github_id` varchar(125) DEFAULT NULL,
  `twitter_id` varchar(125) DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `customers_user_id_foreign` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `shop_name`, `shop_phone`, `shop_address`, `type`, `user_id`, `creator`, `location`, `account_holder`, `account_number`, `note`, `bank_name`, `password`, `v_code`, `v_status`, `status`, `bank_branch`, `upload_id`, `facebook_id`, `github_id`, `twitter_id`, `created_at`, `updated_at`) VALUES
(1, 'General Customer', 'general@example.com', '0170xxxxxxx', '', '', '', NULL, NULL, '1', 'Walking Customer', NULL, NULL, NULL, NULL, '$2y$12$eAD6UCut3h3zN7gaKdDT/uE0vdYGwRsSv2TECilc9BZCg7..Zdng6', NULL, 0, 1, NULL, '0', NULL, NULL, NULL, '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000');

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

--
-- Table structure for table `daily_sales_reports`
--

DROP TABLE IF EXISTS `daily_sales_reports`;
CREATE TABLE IF NOT EXISTS `daily_sales_reports` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sale_id` bigint(20) UNSIGNED NOT NULL,
  `report_date` date NOT NULL,
  `source_channel` varchar(80) NOT NULL DEFAULT 'web',
  `total_amount` decimal(14,2) NOT NULL DEFAULT 0.00,
  `paid_amount` decimal(14,2) NOT NULL DEFAULT 0.00,
  `due_amount` decimal(14,2) NOT NULL DEFAULT 0.00,
  `ledger_posted` tinyint(1) NOT NULL DEFAULT 0,
  `inventory_verified` tinyint(1) NOT NULL DEFAULT 0,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `daily_sales_reports_sale_id_unique` (`sale_id`),
  KEY `daily_sales_reports_report_date_index` (`report_date`),
  KEY `daily_sales_reports_source_channel_index` (`source_channel`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `expriences`
--

DROP TABLE IF EXISTS `expriences`;
CREATE TABLE IF NOT EXISTS `expriences` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `company` varchar(125) DEFAULT NULL,
  `designation` varchar(125) DEFAULT NULL,
  `joining_date` varchar(125) DEFAULT NULL,
  `exit_date` varchar(125) DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `failed_jobs`;
CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(125) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` text NOT NULL,
  `exception` text NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `faqs`
--

DROP TABLE IF EXISTS `faqs`;
CREATE TABLE IF NOT EXISTS `faqs` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(125) DEFAULT NULL,
  `answer` text DEFAULT NULL,
  `status` varchar(125) NOT NULL DEFAULT '0',
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `features`
--

DROP TABLE IF EXISTS `features`;
CREATE TABLE IF NOT EXISTS `features` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `icon_class` varchar(125) DEFAULT NULL,
  `title` varchar(125) DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `upload_id` bigint(20) NOT NULL DEFAULT 0,
  `slug` varchar(125) DEFAULT NULL,
  `status` varchar(125) DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `footer_link_sub_headings`
--

DROP TABLE IF EXISTS `footer_link_sub_headings`;
CREATE TABLE IF NOT EXISTS `footer_link_sub_headings` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `heading_id` varchar(125) NOT NULL DEFAULT '1',
  `title` varchar(125) DEFAULT NULL,
  `url` varchar(125) DEFAULT NULL,
  `icon` varchar(125) DEFAULT NULL,
  `onclick` varchar(125) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `updater` varchar(125) NOT NULL DEFAULT '0',
  `creator` varchar(125) NOT NULL DEFAULT '0',
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `generics`
--

DROP TABLE IF EXISTS `generics`;
CREATE TABLE IF NOT EXISTS `generics` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `creator` bigint(20) NOT NULL DEFAULT 0,
  `updater` bigint(20) NOT NULL DEFAULT 0,
  `name` varchar(125) NOT NULL,
  `slug` varchar(125) NOT NULL,
  `description` text DEFAULT NULL,
  `status` varchar(125) NOT NULL DEFAULT '1',
  `upload_id` varchar(125) DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `home_page_manages`
--

DROP TABLE IF EXISTS `home_page_manages`;
CREATE TABLE IF NOT EXISTS `home_page_manages` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` varchar(125) NOT NULL,
  `title` text DEFAULT NULL,
  `title_status` varchar(125) NOT NULL DEFAULT '1',
  `sub_title` text DEFAULT NULL,
  `sub_title_status` varchar(125) NOT NULL DEFAULT '1',
  `short_read_more` varchar(125) NOT NULL DEFAULT 'Read More',
  `short_read_more_status` tinyint(1) NOT NULL DEFAULT 1,
  `short_read_more_page_url` varchar(125) DEFAULT NULL,
  `view_all` varchar(125) NOT NULL DEFAULT 'See All',
  `view_all_status` tinyint(1) NOT NULL DEFAULT 1,
  `view_all_page_url` varchar(125) DEFAULT NULL,
  `items_per_row_xxl` int(11) NOT NULL DEFAULT 4,
  `items_per_row_xl` int(11) NOT NULL DEFAULT 3,
  `items_per_row_lg` int(11) NOT NULL DEFAULT 3,
  `items_per_row_md` int(11) NOT NULL DEFAULT 2,
  `items_per_row_sm` int(11) NOT NULL DEFAULT 1,
  `items_per_row` int(11) NOT NULL DEFAULT 1,
  `items_show` int(11) NOT NULL DEFAULT 4,
  `is_details_page` int(11) NOT NULL DEFAULT 0,
  `details_or_view_all_align` varchar(125) NOT NULL DEFAULT 'center',
  `background` varchar(125) NOT NULL DEFAULT '0',
  `background_color` varchar(125) NOT NULL DEFAULT '#eeeeee',
  `background_type` tinyint(1) NOT NULL DEFAULT 1,
  `controlby` varchar(125) NOT NULL DEFAULT '1' COMMENT '1 => Homepage',
  `order` int(11) NOT NULL DEFAULT 1,
  `status` varchar(125) NOT NULL DEFAULT '1',
  `creator` varchar(125) NOT NULL DEFAULT '0',
  `updater` varchar(125) NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  `category` varchar(125) NOT NULL DEFAULT '0',
  `title_style` varchar(125) NOT NULL DEFAULT 'title_style_0',
  `upload_id1` varchar(125) NOT NULL DEFAULT '0',
  `upload_id2` varchar(125) NOT NULL DEFAULT '0',
  `upload_id3` varchar(125) NOT NULL DEFAULT '0',
  `short_code_status` tinyint(1) NOT NULL DEFAULT 0,
  `short_code` varchar(100) DEFAULT NULL,
  `order_by_direction` varchar(100) DEFAULT NULL,
  `views_by_direction` varchar(100) DEFAULT NULL,
  `created_by_direction` varchar(100) DEFAULT NULL,
  `updated_by_direction` varchar(100) DEFAULT NULL,
  `feature_product_status` tinyint(1) NOT NULL DEFAULT 0,
  `feature_card_status` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `jobs`;
CREATE TABLE IF NOT EXISTS `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `queue` varchar(191) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` smallint(5) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `mail_settings`
--

DROP TABLE IF EXISTS `mail_settings`;
CREATE TABLE IF NOT EXISTS `mail_settings` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `from_address` varchar(125) DEFAULT NULL,
  `from_name` varchar(125) DEFAULT NULL,
  `smtp_encryption` varchar(125) DEFAULT NULL,
  `smtp_host` varchar(125) DEFAULT NULL,
  `smtp_password` varchar(125) DEFAULT NULL,
  `smtp_port` varchar(125) DEFAULT NULL,
  `smtp_username` varchar(125) DEFAULT NULL,
  `status` varchar(125) DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  `imap_port` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mail_settings`
--

INSERT INTO `mail_settings` (`id`, `from_address`, `from_name`, `smtp_encryption`, `smtp_host`, `smtp_password`, `smtp_port`, `smtp_username`, `status`, `created_at`, `updated_at`, `imap_port`) VALUES
(1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-07-15 04:35:36.000000', '2026-07-15 04:35:36.000000', NULL);

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

--
-- Table structure for table `mail_templates`
--

DROP TABLE IF EXISTS `mail_templates`;
CREATE TABLE IF NOT EXISTS `mail_templates` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) NOT NULL,
  `keywords` varchar(125) NOT NULL,
  `template` text DEFAULT NULL,
  `creator` bigint(20) NOT NULL DEFAULT 0,
  `updater_id` bigint(20) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `menubars`
--

DROP TABLE IF EXISTS `menubars`;
CREATE TABLE IF NOT EXISTS `menubars` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) DEFAULT '',
  `slug` varchar(125) NOT NULL DEFAULT '',
  `position` varchar(125) NOT NULL COMMENT ' left ,  center,  right',
  `order` int(11) NOT NULL DEFAULT 0,
  `parents` int(11) NOT NULL DEFAULT 0,
  `class` varchar(125) DEFAULT NULL,
  `key_name` varchar(125) DEFAULT NULL,
  `icon_class` varchar(125) DEFAULT NULL,
  `preset` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `migrations`;
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=88 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2025_12_10_103831_create_accounts_table', 1),
(2, '2025_12_10_103831_create_achivements_table', 1),
(3, '2025_12_10_103831_create_blog_blog_category_table', 1),
(4, '2025_12_10_103831_create_blog_categories_table', 1),
(5, '2025_12_10_103831_create_blogs_table', 1),
(6, '2025_12_10_103831_create_brands_table', 1),
(7, '2025_12_10_103831_create_carts_table', 1),
(8, '2025_12_10_103831_create_categories_table', 1),
(9, '2025_12_10_103831_create_clients_table', 1),
(10, '2025_12_10_103831_create_company_permissions_table', 1),
(11, '2025_12_10_103831_create_compare_styles_table', 1),
(12, '2025_12_10_103831_create_coupon_use_histories_table', 1),
(13, '2025_12_10_103831_create_courier_credentials_table', 1),
(14, '2025_12_10_103831_create_customers_table', 1),
(15, '2025_12_10_103831_create_discounts_table', 1),
(16, '2025_12_10_103831_create_expriences_table', 1),
(17, '2025_12_10_103831_create_failed_jobs_table', 1),
(18, '2025_12_10_103831_create_faqs_table', 1),
(19, '2025_12_10_103831_create_features_table', 1),
(20, '2025_12_10_103831_create_footer_link_sub_headings_table', 1),
(21, '2025_12_10_103831_create_home_page_manages_table', 1),
(22, '2025_12_10_103831_create_mail_settings_table', 1),
(23, '2025_12_10_103831_create_mail_templates_table', 1),
(24, '2025_12_10_103831_create_menubars_table', 1),
(25, '2025_12_10_103831_create_model_has_permissions_table', 1),
(26, '2025_12_10_103831_create_model_has_roles_table', 1),
(27, '2025_12_10_103831_create_order_events_table', 1),
(28, '2025_12_10_103831_create_order_items_table', 1),
(29, '2025_12_10_103831_create_orders_table', 1),
(30, '2025_12_10_103831_create_pages_table', 1),
(31, '2025_12_10_103831_create_password_reset_tokens_table', 1),
(32, '2025_12_10_103831_create_payment_methods_table', 1),
(33, '2025_12_10_103831_create_payments_table', 1),
(34, '2025_12_10_103831_create_permissions_table', 1),
(35, '2025_12_10_103831_create_personal_access_tokens_table', 1),
(36, '2025_12_10_103831_create_product_faqs_table', 1),
(37, '2025_12_10_103831_create_product_flat_styles_table', 1),
(38, '2025_12_10_103831_create_product_refs_table', 1),
(39, '2025_12_10_103831_create_product_styles_table', 1),
(40, '2025_12_10_103831_create_products_table', 1),
(41, '2025_12_10_103831_create_refrence_users_table', 1),
(42, '2025_12_10_103831_create_review_products_table', 1),
(43, '2025_12_10_103831_create_role_has_permissions_table', 1),
(44, '2025_12_10_103831_create_roles_table', 1),
(45, '2025_12_10_103831_create_sale_events_table', 1),
(46, '2025_12_10_103831_create_sale_items_table', 1),
(47, '2025_12_10_103831_create_sale_statuses_table', 1),
(48, '2025_12_10_103831_create_sales_table', 1),
(49, '2025_12_10_103831_create_services_table', 1),
(50, '2025_12_10_103831_create_sessions_table', 1),
(51, '2025_12_10_103831_create_settings_table', 1),
(52, '2025_12_10_103831_create_shipping_charges_table', 1),
(53, '2025_12_10_103831_create_sliders_table', 1),
(54, '2025_12_10_103831_create_special_events_table', 1),
(55, '2025_12_10_103831_create_sub_categories_table', 1),
(56, '2025_12_10_103831_create_sub_scribers_table', 1),
(57, '2025_12_10_103831_create_suppliers_table', 1),
(58, '2025_12_10_103831_create_testimonials_table', 1),
(59, '2025_12_10_103831_create_topbars_table', 1),
(60, '2025_12_10_103831_create_transactions_parts_table', 1),
(61, '2025_12_10_103831_create_units_table', 1),
(62, '2025_12_10_103831_create_uploads_table', 1),
(63, '2025_12_10_103831_create_users_table', 1),
(64, '2025_12_10_103831_create_variant_options_table', 1),
(65, '2025_12_10_103831_create_visitors_table', 1),
(66, '2025_12_10_103831_create_why_choose_us_table', 1),
(67, '2026_01_15_121733_create_generics_table', 1),
(68, '2026_04_07_185214_add_default_status_to_shipping_charges_table', 1),
(69, '2026_04_08_030002_add_landing_page_columns_to_sales_table', 1),
(70, '2026_04_08_030003_create_daily_sales_reports_table', 1),
(71, '2026_04_08_040001_seed_report_permissions', 1),
(72, '2026_04_16_220001_drop_vats_table', 1),
(73, '2026_04_16_230001_drop_discount_id_from_products_table', 1),
(74, '2026_04_16_230002_drop_discounts_table', 1),
(75, '2026_04_18_120001_create_coupons_table', 1),
(76, '2026_04_19_000001_add_payment_channel_columns_to_accounts_table', 1),
(77, '2026_04_19_000002_add_legacy_payment_columns_to_accounts_table', 1),
(78, '2026_07_10_110157_create_cache_table', 1),
(79, '2026_07_10_111403_create_permission_tables', 1),
(80, '2026_07_13_000001_create_selected_roots_table', 1),
(81, '2026_07_13_000002_create_selected_items_table', 1),
(82, '2026_07_13_000003_add_user_type_to_users_table', 1),
(83, '2026_07_13_000004_add_customer_auth_columns_to_users_table', 1),
(84, '2026_07_14_000001_add_tracking_fields_to_sale_statuses_table', 1),
(85, '2026_07_14_000002_add_final_flag_to_sale_statuses_table', 1),
(86, '2026_07_14_181005_create_jobs_table', 1),
(87, '2026_07_15_000001_add_variant_option_to_products_table', 1);

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

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

DROP TABLE IF EXISTS `model_has_permissions`;
CREATE TABLE IF NOT EXISTS `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(125) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `model_has_roles`;
CREATE TABLE IF NOT EXISTS `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(125) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1);

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

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

DROP TABLE IF EXISTS `orders`;
CREATE TABLE IF NOT EXISTS `orders` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(20) NOT NULL DEFAULT 0,
  `customer_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '0 Means General Customer',
  `qty` bigint(20) NOT NULL DEFAULT 0,
  `price` int(11) NOT NULL DEFAULT 0,
  `discount` int(11) NOT NULL DEFAULT 0,
  `vat` varchar(125) NOT NULL DEFAULT '0',
  `coupon_id` varchar(125) NOT NULL DEFAULT '0',
  `coupon_discount` varchar(125) NOT NULL DEFAULT '0',
  `ref_id` varchar(125) NOT NULL DEFAULT '0',
  `ref_type` varchar(125) NOT NULL DEFAULT '0',
  `ref_commission` varchar(125) NOT NULL DEFAULT '0',
  `ref_commission_amount` varchar(125) NOT NULL DEFAULT '0',
  `shipping_charge_id` varchar(125) NOT NULL DEFAULT '0',
  `shipping_charge` int(11) NOT NULL DEFAULT 0,
  `grand_total` int(11) NOT NULL DEFAULT 0,
  `type` bigint(20) NOT NULL DEFAULT 0 COMMENT '0 for mix, 1 = service, 2 = product',
  `status` int(11) NOT NULL DEFAULT 0 COMMENT '0 = Pending, 1 = Ongoing, 2 = Cancel, 3 Complete',
  `courier_status` int(11) NOT NULL DEFAULT 0 COMMENT '0 for not assign ,1 =  assign',
  `courier_log_id` int(11) NOT NULL DEFAULT 0 COMMENT '0 for not assign, 1 =  assign',
  `name` varchar(125) DEFAULT NULL,
  `email` varchar(125) DEFAULT NULL,
  `phone` varchar(125) DEFAULT NULL,
  `address` varchar(125) DEFAULT NULL,
  `address_optional` varchar(125) DEFAULT NULL,
  `district` varchar(125) DEFAULT NULL,
  `country` varchar(125) DEFAULT NULL,
  `state` varchar(125) DEFAULT NULL,
  `postal` varchar(125) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  `delete_status` tinyint(1) NOT NULL DEFAULT 0,
  `paid` bigint(20) NOT NULL DEFAULT 0,
  `payment_status` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `order_events`
--

DROP TABLE IF EXISTS `order_events`;
CREATE TABLE IF NOT EXISTS `order_events` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sale_id` bigint(20) NOT NULL,
  `status_id` bigint(20) NOT NULL,
  `creator` bigint(20) NOT NULL,
  `updater` bigint(20) NOT NULL,
  `upload_id` bigint(20) NOT NULL DEFAULT 0,
  `note` text DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `order_items`;
CREATE TABLE IF NOT EXISTS `order_items` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) NOT NULL DEFAULT 0,
  `customer_id` bigint(20) NOT NULL DEFAULT 0,
  `product_id` bigint(20) NOT NULL DEFAULT 0,
  `variant_id` bigint(20) NOT NULL DEFAULT 0,
  `quantity` int(11) NOT NULL DEFAULT 0,
  `discount_id` varchar(125) NOT NULL DEFAULT '0',
  `discount` int(11) NOT NULL DEFAULT 0,
  `price` int(11) NOT NULL DEFAULT 0,
  `vat` varchar(125) NOT NULL DEFAULT '0',
  `status` varchar(125) NOT NULL DEFAULT '0',
  `type` bigint(20) NOT NULL DEFAULT 0 COMMENT '1 = service, 2 = product',
  `grand_total` int(11) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  `delete_status` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `pages`;
CREATE TABLE IF NOT EXISTS `pages` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `tags` text DEFAULT NULL,
  `slug` varchar(125) DEFAULT NULL,
  `status` varchar(125) NOT NULL DEFAULT '1',
  `order` varchar(125) NOT NULL DEFAULT '1',
  `page_type` varchar(125) DEFAULT NULL COMMENT 'Like filter, homepage',
  `creator` varchar(125) NOT NULL DEFAULT '0',
  `updater` varchar(125) NOT NULL DEFAULT '0',
  `permission` varchar(125) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  `params` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `password_reset_tokens`;
CREATE TABLE IF NOT EXISTS `password_reset_tokens` (
  `email` varchar(125) NOT NULL,
  `token` varchar(125) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `payments`
--

DROP TABLE IF EXISTS `payments`;
CREATE TABLE IF NOT EXISTS `payments` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sale_id` bigint(20) NOT NULL,
  `amount` bigint(20) NOT NULL,
  `method` bigint(20) NOT NULL,
  `tnxid` bigint(20) NOT NULL,
  `status` bigint(20) NOT NULL,
  `note` text NOT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `payment_gateways`
--

DROP TABLE IF EXISTS `payment_gateways`;
CREATE TABLE IF NOT EXISTS `payment_gateways` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `payment_method_id` bigint(20) UNSIGNED NOT NULL,
  `provider` varchar(191) NOT NULL,
  `api_key` varchar(191) DEFAULT NULL,
  `secret` varchar(191) DEFAULT NULL,
  `store_id` varchar(191) DEFAULT NULL,
  `store_password` varchar(191) DEFAULT NULL,
  `signature_key` varchar(191) DEFAULT NULL,
  `publishable_key` varchar(191) DEFAULT NULL,
  `client_id` varchar(191) DEFAULT NULL,
  `merchant_id` varchar(191) DEFAULT NULL,
  `public_key` varchar(191) DEFAULT NULL,
  `private_key` varchar(191) DEFAULT NULL,
  `sandbox` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `payment_methods`;
CREATE TABLE IF NOT EXISTS `payment_methods` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `charge` float NOT NULL DEFAULT 0,
  `type` enum('cash','bank','mobile','gateway') NOT NULL,
  `account_id` bigint(20) UNSIGNED NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) NOT NULL,
  `guard_name` varchar(125) NOT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=MyISAM AUTO_INCREMENT=198 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'user read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(2, 'user create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(3, 'user edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(4, 'user rolechange', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(5, 'user delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(6, 'role read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(7, 'role create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(8, 'role edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(9, 'role delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(10, 'account read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(11, 'account create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(12, 'account edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(13, 'account delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(14, 'product read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(15, 'product create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(16, 'product edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(17, 'product delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(18, 'product barcode', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(19, 'unit read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(20, 'unit create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(21, 'unit edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(22, 'unit delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(23, 'purchase read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(24, 'purchase create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(25, 'purchase edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(26, 'purchase delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(27, 'refcustomer read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(28, 'customer read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(29, 'customer create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(30, 'customer edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(31, 'customer delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(32, 'stock read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(33, 'generic read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(34, 'generic create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(35, 'generic edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(36, 'generic delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(37, 'supplier read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(38, 'supplier create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(39, 'supplier edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(40, 'supplier delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(41, 'category read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(42, 'category create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(43, 'category edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(44, 'category delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(45, 'subcategory read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(46, 'subcategory create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(47, 'subcategory edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(48, 'subcategory delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(49, 'subsubcategory read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(50, 'subsubcategory create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(51, 'subsubcategory edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(52, 'subsubcategory delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(53, 'brand read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(54, 'brand create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(55, 'brand edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(56, 'brand delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(57, 'client read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(58, 'client create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(59, 'client edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(60, 'client delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(61, 'project read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(62, 'project create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(63, 'project edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(64, 'project delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(65, 'vat read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(66, 'vat create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(67, 'vat edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(68, 'vat delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(69, 'coupon read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(70, 'coupon create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(71, 'coupon edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(72, 'coupon delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(73, 'discount read', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(74, 'discount create', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(75, 'discount edit', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(76, 'discount delete', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000'),
(77, 'pos read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(78, 'pos create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(79, 'pos edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(80, 'pos delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(81, 'siteverification read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(82, 'siteverification edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(83, 'tagmanagement read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(84, 'tagmanagement edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(85, 'pwa read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(86, 'pwa edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(87, 'takto read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(88, 'takto edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(89, 'cookie read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(90, 'cookie edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(91, 'smtp read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(92, 'smtp edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(93, 'payment_credentials read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(94, 'payment_credentials edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(95, 'maintenance mode', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(96, 'maintenance debug', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(97, 'maintenance database', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(98, 'database backup', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(99, 'settings payment_configration', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(100, 'settings main', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(101, 'settings site_verification', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(102, 'settings site_tag', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(103, 'settings tracking_report', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(104, 'settings site_pwa', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(105, 'settings messagesdk', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(106, 'settings cookie', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(107, 'settings email_setting', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(108, 'imap management', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(109, 'settings sms_configration', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(110, 'settings courier_configration', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(111, 'settings custom_js_css', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(112, 'sms_configration', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(113, 'sale read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(114, 'sale create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(115, 'sale edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(116, 'sale delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(117, 'view_reports', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(118, 'reports read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(119, 'reports export', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(120, 'whychooseus read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(121, 'whychooseus create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(122, 'whychooseus edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(123, 'whychooseus delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(124, 'achivement read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(125, 'achivement create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(126, 'achivement edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(127, 'achivement delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(128, 'custom_sale type read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(129, 'custom_sale bulk read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(130, 'custom_sale custom read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(131, 'sale_status read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(132, 'sale_status delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(133, 'sale_status edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(134, 'sale_status create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(135, 'offerbanner read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(136, 'offerbanner create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(137, 'offerbanner edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(138, 'offerbanner delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(139, 'profile read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(140, 'profile create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(141, 'profile edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(142, 'profile delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(143, 'theme read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(144, 'blog category read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(145, 'blog category create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(146, 'blog category edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(147, 'blog category delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(148, 'blog read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(149, 'blog create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(150, 'blog edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(151, 'blog delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(152, 'sub-scribers read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(153, 'sub-scribers create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(154, 'sub-scribers edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(155, 'sub-scribers delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(156, 'sub-scribers mailer', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(157, 'reftransection read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(158, 'transection read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(159, 'transection create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(160, 'transection edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(161, 'transection delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(162, 'slider read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(163, 'slider create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(164, 'slider edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(165, 'slider delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(166, 'service read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(167, 'service create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(168, 'service edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(169, 'service delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(170, 'testimonial read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(171, 'testimonial create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(172, 'testimonial edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(173, 'testimonial delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(174, 'footerlinkheading read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(175, 'footerlinkheading create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(176, 'footerlinkheading edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(177, 'footerlinkheading delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(178, 'footerlinksubheading read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(179, 'footerlinksubheading create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(180, 'footerlinksubheading edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(181, 'footerlinksubheading delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(182, 'headernav read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(183, 'headernav create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(184, 'headernav edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(185, 'headernav delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(186, 'faq read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(187, 'faq create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(188, 'faq edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(189, 'faq delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(190, 'page read', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(191, 'page create', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(192, 'page edit', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(193, 'page delete', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(194, 'migrate seed', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(195, 'migrate', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(196, 'catche clear', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(197, 'migrate fresh', 'web', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000');

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

--
-- Table structure for table `personal_access_tokens`
--

DROP TABLE IF EXISTS `personal_access_tokens`;
CREATE TABLE IF NOT EXISTS `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(125) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(125) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` datetime DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `products`;
CREATE TABLE IF NOT EXISTS `products` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) DEFAULT NULL,
  `sku` varchar(125) DEFAULT NULL,
  `slug` varchar(125) DEFAULT NULL,
  `category_id` varchar(125) DEFAULT NULL,
  `brand_id` varchar(125) DEFAULT NULL,
  `weight` varchar(125) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `additional_description` text DEFAULT NULL,
  `unit_id` varchar(125) DEFAULT NULL,
  `for_selling` varchar(125) NOT NULL DEFAULT '0',
  `garage` varchar(125) NOT NULL DEFAULT '0',
  `route` varchar(125) NOT NULL DEFAULT '0',
  `feature` varchar(125) NOT NULL DEFAULT '0',
  `alert_quantity` varchar(125) NOT NULL DEFAULT '0',
  `inventory` bigint(20) NOT NULL DEFAULT 0,
  `creator` varchar(125) NOT NULL DEFAULT '0',
  `upload_id` varchar(125) NOT NULL DEFAULT '0',
  `uploads_id` varchar(125) NOT NULL DEFAULT '0',
  `sub_category` varchar(125) DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `youtube_video` varchar(125) DEFAULT NULL,
  `tags` varchar(1500) DEFAULT NULL,
  `views` bigint(20) NOT NULL DEFAULT 0,
  `old_price` int(11) NOT NULL DEFAULT 0,
  `selling_price` int(11) NOT NULL DEFAULT 0,
  `free_delivery` int(11) NOT NULL DEFAULT 0,
  `vat` varchar(125) NOT NULL DEFAULT '0',
  `service` tinyint(1) NOT NULL DEFAULT 0,
  `variant_on` tinyint(1) NOT NULL DEFAULT 0,
  `variant_option` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`variant_option`)),
  `status` varchar(125) NOT NULL DEFAULT '0',
  `landing_page_bg` varchar(125) DEFAULT NULL,
  `landing_page_color` varchar(125) DEFAULT NULL,
  `landing_page_deasing_id` varchar(125) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `updater` bigint(20) NOT NULL DEFAULT 0,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  `free_delivery_area` varchar(50) NOT NULL DEFAULT '0',
  `position_order` bigint(20) NOT NULL DEFAULT 0,
  `short_info` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `products` (`id`, `name`, `sku`, `slug`, `category_id`, `brand_id`, `weight`, `description`, `additional_description`, `unit_id`, `for_selling`, `garage`, `route`, `feature`, `alert_quantity`, `inventory`, `creator`, `upload_id`, `uploads_id`, `sub_category`, `short_description`, `youtube_video`, `tags`, `views`, `old_price`, `selling_price`, `free_delivery`, `vat`, `service`, `variant_on`, `variant_option`, `status`, `landing_page_bg`, `landing_page_color`, `landing_page_deasing_id`, `deleted_at`, `updater`, `created_at`, `updated_at`, `free_delivery_area`, `position_order`, `short_info`) VALUES
(1, 'Uncategorized', 'uncategorized', 'uncategorized', '1', '1', NULL, 'This is an uncategorized product description.', 'This is an additional description for the uncategorized product.', '1', '1', '0', 'uncategorized', '0', '0', 0, '1', '0', '0', '1', 'Uncategorized product', '', '', 0, 100, 150, 0, '0', 0, 0, NULL, '1', NULL, NULL, NULL, '2026-07-15 01:52:05', 0, '2026-07-15 01:07:41.000000', '2026-07-15 01:52:05.000000', '0', 0, NULL),
(2, 'Cap', 'cap-1', 'cap', '2', '0', '0', NULL, NULL, '1', '0', '0', '0', '0', '3', 12, '1', '19', '14,5', '0', NULL, NULL, '', 0, 550, 550, 0, '0.1', 0, 0, '{\"variant_key\":\"\",\"vairant_value\":\"\",\"variant_details_key\":\"\",\"variant_details_value\":\"\"}', '1', '#a72a2a', '#dd9797', '1', NULL, 0, '2026-07-15 01:25:07.000000', '2026-07-15 02:38:51.000000', '0', 0, NULL),
(3, 'Cap', 'cap-1', 'cap-1', '3', '0', '0', NULL, NULL, '1', '0', '0', '0', '0', '3', 10, '1', '1', '13,3', '0', NULL, NULL, '', 0, 550, 550, 0, '0.1', 0, 0, '{\"variant_key\":\"\",\"vairant_value\":\"\",\"variant_details_key\":\"\",\"variant_details_value\":\"\"}', '1', '#a72a2a', '#dd9797', '1', NULL, 0, '2026-07-15 01:25:34.000000', '2026-07-15 03:19:25.000000', '0', 0, NULL),
(4, 'Cap', 'cap10', 'cap10', '4', '0', '0', NULL, NULL, '1', '0', '0', '0', '0', '2', 10, '1', '6', '4,8,11', '3', NULL, NULL, '', 0, 750, 650, 0, '0.1', 0, 0, '{\"variant_key\":\"\",\"vairant_value\":\"\",\"variant_details_key\":\"\",\"variant_details_value\":\"\"}', '1', '#000000', '#000000', '1', NULL, 0, '2026-07-15 01:30:25.000000', '2026-07-15 02:29:34.000000', '0', 0, NULL),
(5, 'Cap', 'cap-1', 'cap-3', '5', '0', '0', NULL, NULL, '1', '0', '0', '0', '0', '2', 10, '1', '11', '4,8,11', '0', NULL, NULL, '', 0, 750, 650, 0, '0.1', 0, 0, '{\"variant_key\":\"\",\"vairant_value\":\"\",\"variant_details_key\":\"\",\"variant_details_value\":\"\"}', '1', '#000000', '#000000', '1', NULL, 0, '2026-07-15 01:37:05.000000', '2026-07-15 02:31:05.000000', '0', 0, NULL),
(6, 'Cap', 'cap-1', 'cap-4', '2', '0', '0', NULL, NULL, '1', '0', '0', '0', '0', '2', 0, '1', '11', '4,8,11', '0', NULL, NULL, '', 0, 750, 650, 0, '0.1', 0, 0, '{\"variant_key\":\"\",\"vairant_value\":\"\",\"variant_details_key\":\"\",\"variant_details_value\":\"\"}', '0', '#000000', '#000000', '1', '2026-07-15 01:51:54', 0, '2026-07-15 01:37:28.000000', '2026-07-15 01:51:54.000000', '0', 0, NULL),
(7, 'Cap', 'cap-12', 'cap-7', '2', '0', '120', NULL, NULL, '0', '0', '0', '0', '0', '3', 0, '1', '11', '6,14,17', '0', NULL, NULL, '', 0, 450, 450, 0, '0.1', 0, 0, '{\"variant_key\":\"\",\"vairant_value\":\"\",\"variant_details_key\":\"\",\"variant_details_value\":\"\"}', '0', '#000000', '#000000', '1', '2026-07-15 01:51:30', 0, '2026-07-15 01:43:45.000000', '2026-07-15 01:51:30.000000', '0', 0, NULL),
(8, 'D Cap', 'cap-1', 'd-cap', '6', '0', '0', NULL, NULL, '0', '1', '0', '0', '0', '2', 4, '1', '37', '21,22', '0', NULL, NULL, '', 0, 950, 750, 0, '0.2', 0, 0, '{\"variant_key\":\"\",\"vairant_value\":\"\",\"variant_details_key\":\"\",\"variant_details_value\":\"\"}', '1', '#000000', '#000000', '1', NULL, 0, '2026-07-15 02:46:03.000000', '2026-07-15 05:18:04.000000', '0', 0, NULL),
(9, 'S Cap', 'cap-1', 's-cap', '7', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '2', 0, '1', '29', '33,23', '0', NULL, NULL, '', 0, 450, 450, 0, '0', 1, 0, '{\"variant_key\":\"\",\"vairant_value\":\"\",\"variant_details_key\":\"\",\"variant_details_value\":\"\"}', '0', '#000000', '#000000', '1', NULL, 0, '2026-07-15 02:54:21.000000', '2026-07-15 02:54:21.000000', '0', 0, NULL),
(10, 'Cap', 'cap-1', '1cap', '0', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '2', 1, '1', '11', '11,13', '0', NULL, NULL, '', 0, 300, 300, 0, '0', 0, 0, '{\"variant_key\":\"\",\"vairant_value\":\"\",\"variant_details_key\":\"\",\"variant_details_value\":\"\"}', '1', '#000000', '#000000', '1', NULL, 0, '2026-07-15 02:57:30.000000', '2026-07-15 05:20:01.000000', '0', 0, NULL),
(11, 'E Cap', 'cap-1', 'e-cap', '8', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '3', 1, '1', '35', '14,15', '0', NULL, NULL, '', 0, 300, 300, 0, '0', 0, 0, '{\"variant_key\":\"\",\"vairant_value\":\"\",\"variant_details_key\":\"\",\"variant_details_value\":\"\"}', '1', '#000000', '#000000', '1', NULL, 0, '2026-07-15 03:06:50.000000', '2026-07-15 05:20:33.000000', '0', 0, NULL),
(12, 'Sajjad Vai er cap', 'cap-1', 'sajjad-vai-er-cap', '8', '0', '0', NULL, NULL, '0', '0', '0', '0', '0', '0', 7, '1', '22', '13,16', '0', NULL, NULL, '', 0, 300, 300, 0, '0', 0, 0, '{\"variant_key\":\"\",\"vairant_value\":\"\",\"variant_details_key\":\"\",\"variant_details_value\":\"\"}', '1', '#000000', '#000000', '1', NULL, 0, '2026-07-15 03:09:43.000000', '2026-07-15 05:19:04.000000', '0', 0, NULL),
(13, 'Hat', 'cap-1', 'hat', '6', '0', '0', NULL, NULL, '1', '1', '0', '0', '1', '2', 8, '1', '14', '11,13', '0', NULL, NULL, '', 0, 450, 400, 0, '0.12', 0, 0, '{\"variant_key\":\"\",\"vairant_value\":\"\",\"variant_details_key\":\"\",\"variant_details_value\":\"\"}', '1', '#000000', '#000000', '1', NULL, 0, '2026-07-15 05:06:37.000000', '2026-07-15 05:18:59.000000', '0', 0, NULL);

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

--
-- Table structure for table `product_faqs`
--

DROP TABLE IF EXISTS `product_faqs`;
CREATE TABLE IF NOT EXISTS `product_faqs` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `question` varchar(125) DEFAULT NULL,
  `answer` varchar(125) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `order_sort` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_flat_styles`
--

DROP TABLE IF EXISTS `product_flat_styles`;
CREATE TABLE IF NOT EXISTS `product_flat_styles` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` varchar(125) NOT NULL,
  `title` varchar(125) NOT NULL,
  `upload_id` varchar(125) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `background_color` varchar(125) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_refs`
--

DROP TABLE IF EXISTS `product_refs`;
CREATE TABLE IF NOT EXISTS `product_refs` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) DEFAULT NULL,
  `model_no` varchar(125) DEFAULT NULL,
  `taka` varchar(125) DEFAULT NULL,
  `creator` varchar(125) NOT NULL,
  `updater` varchar(125) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_styles`
--

DROP TABLE IF EXISTS `product_styles`;
CREATE TABLE IF NOT EXISTS `product_styles` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` varchar(125) NOT NULL,
  `title` varchar(125) NOT NULL,
  `upload_id` varchar(125) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `background_color` varchar(125) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `refrence_users`
--

DROP TABLE IF EXISTS `refrence_users`;
CREATE TABLE IF NOT EXISTS `refrence_users` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `review_products`
--

DROP TABLE IF EXISTS `review_products`;
CREATE TABLE IF NOT EXISTS `review_products` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) DEFAULT NULL,
  `email` varchar(125) DEFAULT NULL,
  `comment` varchar(125) DEFAULT NULL,
  `rating` varchar(125) DEFAULT NULL,
  `creator` varchar(125) DEFAULT NULL,
  `product_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `roles`;
CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) NOT NULL,
  `guard_name` varchar(125) NOT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'superadmin', 'web', '2026-07-15 01:07:40.000000', '2026-07-15 01:07:40.000000');

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

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

DROP TABLE IF EXISTS `role_has_permissions`;
CREATE TABLE IF NOT EXISTS `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

--
-- Table structure for table `sales`
--

DROP TABLE IF EXISTS `sales`;
CREATE TABLE IF NOT EXISTS `sales` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(20) NOT NULL DEFAULT 0,
  `customer_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '0 Means General Customer',
  `qty` bigint(20) NOT NULL DEFAULT 0,
  `price` int(11) NOT NULL DEFAULT 0,
  `discount` int(11) NOT NULL DEFAULT 0,
  `vat` varchar(125) NOT NULL DEFAULT '0',
  `coupon_id` varchar(125) NOT NULL DEFAULT '0',
  `coupon_discount` varchar(125) NOT NULL DEFAULT '0',
  `ref_id` varchar(125) NOT NULL DEFAULT '0',
  `ref_type` varchar(125) NOT NULL DEFAULT '0',
  `ref_commission` varchar(125) NOT NULL DEFAULT '0',
  `ref_commission_amount` varchar(125) NOT NULL DEFAULT '0',
  `shipping_charge_id` varchar(125) NOT NULL DEFAULT '0',
  `shipping_charge` int(11) NOT NULL DEFAULT 0,
  `grand_total` decimal(11,2) NOT NULL DEFAULT 0.00,
  `type` bigint(20) NOT NULL DEFAULT 0 COMMENT '0 for mix, 1 = service, 2 = product',
  `status` int(11) NOT NULL DEFAULT 0 COMMENT '0 = Pending, 1 = Ongoing, 2 = Cancel, 3 Complete',
  `courier_status` int(11) NOT NULL DEFAULT 0 COMMENT '0 for not assign ,1 =  assign',
  `courier_log_id` int(11) NOT NULL DEFAULT 0 COMMENT '0 for not assign, 1 =  assign',
  `name` varchar(125) DEFAULT NULL,
  `email` varchar(125) DEFAULT NULL,
  `phone` varchar(125) DEFAULT NULL,
  `address` varchar(125) DEFAULT NULL,
  `address_optional` varchar(125) DEFAULT NULL,
  `district` varchar(125) DEFAULT NULL,
  `country` varchar(125) DEFAULT NULL,
  `state` varchar(125) DEFAULT NULL,
  `postal` varchar(125) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  `delete_status` tinyint(1) NOT NULL DEFAULT 0,
  `paid` decimal(11,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sales`
--

INSERT INTO `sales` (`id`, `invoice_id`, `customer_id`, `qty`, `price`, `discount`, `vat`, `coupon_id`, `coupon_discount`, `ref_id`, `ref_type`, `ref_commission`, `ref_commission_amount`, `shipping_charge_id`, `shipping_charge`, `grand_total`, `type`, `status`, `courier_status`, `courier_log_id`, `name`, `email`, `phone`, `address`, `address_optional`, `district`, `country`, `state`, `postal`, `note`, `deleted_at`, `created_at`, `updated_at`, `delete_status`, `paid`) VALUES
(1, 1784106936, 1, 2, 1100, 0, '0', '0', '0', '0', '0', '0', '0', '2', 120, 1220.00, 2, 4, 0, 0, 'cfgh', '', '01452454544', 'fgh', '', '', 'Bangladesh', '', '', 'Cash on Delivery', NULL, '2026-07-15 03:15:36.000000', '2026-07-15 03:19:56.000000', 0, 1220.00),
(2, 1784113118, 1, 3, 1400, 0, '0', '0', '0', '0', '0', '0', '0', '1', 50, 1450.00, 2, 2, 0, 0, 'dfgfg', '', '01710000000', 'fdgdf', '', '', 'Bangladesh', '', '', 'Cash on Delivery', NULL, '2026-07-15 04:58:38.000000', '2026-07-15 05:02:03.000000', 0, 0.00),
(3, 1784113250, 1, 1, 300, 0, '0', '0', '0', '0', '0', '0', '0', '1', 50, 350.00, 2, 2, 0, 0, 'fasdf', '', '01710000000', 'Mirpur 6,bloc c,lean 12,house 24', '', '', 'Bangladesh', '', '', 'Cash on Delivery', NULL, '2026-07-15 05:00:50.000000', '2026-07-15 05:01:48.000000', 0, 0.00);

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

--
-- Table structure for table `sale_events`
--

DROP TABLE IF EXISTS `sale_events`;
CREATE TABLE IF NOT EXISTS `sale_events` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sale_id` bigint(20) NOT NULL,
  `status_id` bigint(20) NOT NULL,
  `creator` bigint(20) NOT NULL,
  `updater` bigint(20) NOT NULL,
  `upload_id` bigint(20) NOT NULL DEFAULT 0,
  `note` text DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sale_events`
--

INSERT INTO `sale_events` (`id`, `sale_id`, `status_id`, `creator`, `updater`, `upload_id`, `note`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1, 1, 0, NULL, '2026-07-15 03:15:36.000000', '2026-07-15 03:15:36.000000'),
(2, 1, 2, 1, 1, 0, 'Status changed from sale panel', '2026-07-15 03:18:29.000000', '2026-07-15 03:18:29.000000'),
(3, 1, 1, 1, 1, 0, 'Status changed from sale panel', '2026-07-15 03:18:47.000000', '2026-07-15 03:18:47.000000'),
(4, 1, 5, 1, 1, 0, 'Status changed from sale panel', '2026-07-15 03:19:01.000000', '2026-07-15 03:19:01.000000'),
(5, 1, 2, 1, 1, 0, 'Status changed from sale panel', '2026-07-15 03:19:11.000000', '2026-07-15 03:19:11.000000'),
(6, 1, 4, 1, 1, 0, 'Status changed from sale panel', '2026-07-15 03:19:25.000000', '2026-07-15 03:19:25.000000'),
(7, 2, 1, 1, 1, 0, NULL, '2026-07-15 04:58:38.000000', '2026-07-15 04:58:38.000000'),
(8, 3, 1, 1, 1, 0, NULL, '2026-07-15 05:00:50.000000', '2026-07-15 05:00:50.000000'),
(9, 3, 2, 1, 1, 0, 'Status changed from sale panel', '2026-07-15 05:01:48.000000', '2026-07-15 05:01:48.000000'),
(10, 2, 2, 1, 1, 0, 'Status changed from sale panel', '2026-07-15 05:02:03.000000', '2026-07-15 05:02:03.000000');

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

--
-- Table structure for table `sale_items`
--

DROP TABLE IF EXISTS `sale_items`;
CREATE TABLE IF NOT EXISTS `sale_items` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sale_id` bigint(20) NOT NULL DEFAULT 0,
  `customer_id` bigint(20) NOT NULL DEFAULT 0,
  `product_id` bigint(20) NOT NULL DEFAULT 0,
  `variant_id` bigint(20) NOT NULL DEFAULT 0,
  `quantity` int(11) NOT NULL DEFAULT 0,
  `discount_id` varchar(125) NOT NULL DEFAULT '0',
  `discount` int(11) NOT NULL DEFAULT 0,
  `price` int(11) NOT NULL DEFAULT 0,
  `vat` varchar(125) NOT NULL DEFAULT '0',
  `status` varchar(125) NOT NULL DEFAULT '0',
  `type` bigint(20) NOT NULL DEFAULT 0 COMMENT '1 = service, 2 = product',
  `grand_total` int(11) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  `delete_status` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sale_items`
--

INSERT INTO `sale_items` (`id`, `sale_id`, `customer_id`, `product_id`, `variant_id`, `quantity`, `discount_id`, `discount`, `price`, `vat`, `status`, `type`, `grand_total`, `deleted_at`, `created_at`, `updated_at`, `delete_status`) VALUES
(1, 1, 1, 3, 0, 2, '0', 0, 550, '0', '1', 2, 1100, NULL, '2026-07-15 03:15:36.000000', '2026-07-15 03:15:36.000000', 0),
(2, 2, 1, 12, 0, 1, '0', 0, 300, '0', '1', 2, 300, NULL, '2026-07-15 04:58:38.000000', '2026-07-15 04:58:38.000000', 0),
(3, 2, 1, 2, 0, 1, '0', 0, 550, '0', '1', 2, 550, NULL, '2026-07-15 04:58:38.000000', '2026-07-15 04:58:38.000000', 0),
(4, 2, 1, 3, 0, 1, '0', 0, 550, '0', '1', 2, 550, NULL, '2026-07-15 04:58:38.000000', '2026-07-15 04:58:38.000000', 0),
(5, 3, 1, 11, 0, 1, '0', 0, 300, '0', '1', 2, 300, NULL, '2026-07-15 05:00:50.000000', '2026-07-15 05:00:50.000000', 0);

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

--
-- Table structure for table `sale_statuses`
--

DROP TABLE IF EXISTS `sale_statuses`;
CREATE TABLE IF NOT EXISTS `sale_statuses` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `is_trackable` tinyint(1) NOT NULL DEFAULT 1,
  `is_final` tinyint(1) NOT NULL DEFAULT 0,
  `qty` int(11) NOT NULL DEFAULT 0,
  `qty_status` int(11) NOT NULL DEFAULT 0,
  `under_items` text DEFAULT NULL,
  `creator` bigint(20) NOT NULL DEFAULT 0,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sale_statuses`
--

INSERT INTO `sale_statuses` (`id`, `name`, `sort_order`, `is_trackable`, `is_final`, `qty`, `qty_status`, `under_items`, `creator`, `created_at`, `updated_at`) VALUES
(1, 'Pending', 5, 1, 0, 0, 0, NULL, 0, '2026-07-15 03:17:14.000000', '2026-07-15 03:18:01.000000'),
(2, 'In Review', 4, 1, 0, 0, 0, NULL, 0, '2026-07-15 03:17:29.000000', '2026-07-15 03:18:01.000000'),
(3, 'On The Way', 3, 1, 0, 0, 0, NULL, 0, '2026-07-15 03:17:43.000000', '2026-07-15 03:18:01.000000'),
(4, 'Delivered', 2, 1, 1, 0, 0, NULL, 0, '2026-07-15 03:17:53.000000', '2026-07-15 03:18:01.000000'),
(5, 'Canceled', 1, 1, 0, 0, 0, NULL, 0, '2026-07-15 03:18:01.000000', '2026-07-15 03:18:01.000000');

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

--
-- Table structure for table `selected_items`
--

DROP TABLE IF EXISTS `selected_items`;
CREATE TABLE IF NOT EXISTS `selected_items` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `selected_root_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `position_order` bigint(20) NOT NULL DEFAULT 0,
  `creator` bigint(20) NOT NULL DEFAULT 0,
  `updater` bigint(20) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `selected_root_product_unique` (`selected_root_id`,`product_id`),
  KEY `selected_items_root_order_index` (`selected_root_id`,`position_order`),
  KEY `selected_items_product_index` (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `selected_items`
--

INSERT INTO `selected_items` (`id`, `selected_root_id`, `product_id`, `position_order`, `creator`, `updater`, `created_at`, `updated_at`) VALUES
(1, 1, 5, 1, 1, 1, '2026-07-15 02:08:59', '2026-07-15 02:08:59'),
(2, 1, 4, 2, 1, 1, '2026-07-15 02:09:00', '2026-07-15 02:09:00'),
(3, 1, 3, 3, 1, 1, '2026-07-15 02:09:00', '2026-07-15 02:09:00'),
(4, 1, 2, 4, 1, 1, '2026-07-15 02:09:01', '2026-07-15 02:09:01'),
(5, 2, 4, 1, 1, 1, '2026-07-15 02:09:34', '2026-07-15 02:09:34'),
(6, 2, 5, 2, 1, 1, '2026-07-15 02:09:36', '2026-07-15 02:09:36'),
(7, 3, 5, 1, 1, 1, '2026-07-15 02:09:44', '2026-07-15 02:09:44'),
(8, 3, 4, 2, 1, 1, '2026-07-15 02:09:45', '2026-07-15 02:09:45'),
(9, 5, 5, 1, 1, 1, '2026-07-15 02:09:59', '2026-07-15 02:09:59'),
(10, 4, 5, 1, 1, 1, '2026-07-15 05:24:06', '2026-07-15 05:24:06'),
(11, 4, 8, 2, 1, 1, '2026-07-15 05:24:07', '2026-07-15 05:24:07'),
(12, 6, 8, 1, 1, 1, '2026-07-15 05:24:16', '2026-07-15 05:24:16'),
(13, 6, 5, 2, 1, 1, '2026-07-15 05:24:17', '2026-07-15 05:24:17'),
(14, 7, 2, 1, 1, 1, '2026-07-15 05:24:24', '2026-07-15 05:24:24'),
(15, 7, 3, 2, 1, 1, '2026-07-15 05:24:25', '2026-07-15 05:24:25'),
(16, 7, 4, 3, 1, 1, '2026-07-15 05:24:26', '2026-07-15 05:24:26'),
(17, 7, 5, 4, 1, 1, '2026-07-15 05:24:26', '2026-07-15 05:24:26'),
(18, 7, 8, 5, 1, 1, '2026-07-15 05:24:27', '2026-07-15 05:24:27');

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

--
-- Table structure for table `selected_roots`
--

DROP TABLE IF EXISTS `selected_roots`;
CREATE TABLE IF NOT EXISTS `selected_roots` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(190) NOT NULL,
  `slug` varchar(190) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `position_order` bigint(20) NOT NULL DEFAULT 0,
  `creator` bigint(20) NOT NULL DEFAULT 0,
  `updater` bigint(20) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `selected_roots_slug_unique` (`slug`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `selected_roots`
--

INSERT INTO `selected_roots` (`id`, `name`, `slug`, `description`, `status`, `position_order`, `creator`, `updater`, `created_at`, `updated_at`) VALUES
(1, 'Cap People Love', 'cap_people_love', NULL, 1, 0, 1, 1, '2026-07-15 01:07:41', '2026-07-15 01:07:41'),
(2, 'Top 10 Cap Bd', 'top_10_cap_bd', NULL, 1, 1, 1, 1, '2026-07-15 01:07:41', '2026-07-15 01:07:41'),
(3, 'Weekly Selected', 'weekly-selected', NULL, 1, 2, 1, 1, '2026-07-15 01:07:41', '2026-07-15 01:07:41'),
(4, 'Today Deal', 'today-deal', NULL, 1, 3, 1, 1, '2026-07-15 01:07:41', '2026-07-15 01:07:41'),
(5, 'Featured Products', 'featured-products', NULL, 0, 4, 1, 1, '2026-07-15 01:07:41', '2026-07-15 01:07:41'),
(6, 'Best Sellers', 'best-sellers', NULL, 1, 5, 1, 1, '2026-07-15 01:07:41', '2026-07-15 01:07:41'),
(7, 'New Arrivals', 'new-arrivals', NULL, 1, 6, 1, 1, '2026-07-15 01:07:41', '2026-07-15 01:07:41');

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

--
-- Table structure for table `services`
--

DROP TABLE IF EXISTS `services`;
CREATE TABLE IF NOT EXISTS `services` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `icon_class` varchar(125) DEFAULT NULL,
  `title` varchar(125) DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `upload_id` bigint(20) NOT NULL DEFAULT 0,
  `bg_upload_id` bigint(20) NOT NULL DEFAULT 0,
  `status` varchar(125) DEFAULT NULL,
  `slug` varchar(125) DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `sessions`;
CREATE TABLE IF NOT EXISTS `sessions` (
  `id` varchar(125) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` text NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('WygDFkRm2Uy3HC94mvk6uQSpjq9dt4qaxvfhRKkt', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJ5d3VXNFFEeGU5Rkw3WkVTU2tVWjVXSVFsVjRtUm02RWJMTnNXTnhNIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJ1cmwiOnsiaW50ZW5kZWQiOiJodHRwOlwvXC8xMjcuMC4wLjE6ODAwMFwvcHJvZHVjdHNcL2NhcCJ9LCJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI6MSwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzEyNy4wLjAuMTo4MDAwXC9zZWFyY2hcL3N1Z2dlc3Rpb25zIiwicm91dGUiOiJzZWFyY2guc3VnZ2VzdGlvbnMifX0=', 1784117393);

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

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

DROP TABLE IF EXISTS `settings`;
CREATE TABLE IF NOT EXISTS `settings` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) DEFAULT NULL,
  `value` text DEFAULT NULL,
  `key` varchar(125) DEFAULT NULL,
  `creator_id` varchar(125) NOT NULL DEFAULT '0',
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` (`id`, `name`, `value`, `key`, `creator_id`, `created_at`, `updated_at`) VALUES
(1, 'server_side_tracking_status', 'Server Side Tracking Status', '24', '0', '2026-07-15 01:06:02.000000', '2026-07-15 01:06:02.000000'),
(2, 'google_tag_analysis_status', 'Google Tag Analysis Status', '24', '0', '2026-07-15 01:06:02.000000', '2026-07-15 01:06:02.000000'),
(3, 'facebook_pixel_status', 'Facebook Pixel Status', '24', '0', '2026-07-15 01:06:02.000000', '2026-07-15 01:06:02.000000'),
(4, 'app_image', 'App Image', '9', '0', '2026-07-15 01:06:03.000000', '2026-07-15 01:06:03.000000'),
(5, 'app_footer_image', 'App Footer Image', '9', '0', '2026-07-15 01:06:03.000000', '2026-07-15 01:06:03.000000'),
(6, 'app_name_short', 'App Name Short', '9', '0', '2026-07-15 01:07:50.000000', '2026-07-15 01:07:50.000000'),
(7, 'app_fav_image', 'App Fav Image', '9', '0', '2026-07-15 01:07:50.000000', '2026-07-15 01:07:50.000000'),
(8, 'theme_brand_link', 'Theme Brand Link', '1', '0', '2026-07-15 01:07:50.000000', '2026-07-15 01:07:50.000000'),
(9, 'currency_symbol', 'BDT `price`', '9', '0', '2026-07-15 01:07:51.000000', '2026-07-15 02:55:49.000000'),
(10, 'app_title', 'App Title', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(11, 'currency_symbol_code', 'Currency Symbol Code', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(12, 'app_about', 'App About', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(13, 'app_keywords', 'App Keywords', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(14, 'return_refund_policy_editor', '<p>Return Refund Policy Editor</p>', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:49.000000'),
(15, 'login_admin_image', 'Login Admin Image', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(16, 'app_instagram', 'App Instagram', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(17, 'app_facebook', 'App Facebook', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(18, 'app_twitter', 'App Twitter', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(19, 'app_linkedin', 'App Linkedin', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(20, 'app_website', 'App Website', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(21, 'app_email', 'App Email', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(22, 'app_tel', '01701010101', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 04:37:40.000000'),
(23, 'app_whatsapp', '01701010101', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 04:37:40.000000'),
(24, 'app_whatssap_fixed_status', '0', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 04:36:30.000000'),
(25, 'app_messenger_fixed_status', '0', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 04:36:30.000000'),
(26, 'app_maps', 'App Maps', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(27, 'app_map_embaded_url', 'App Map Embaded Url', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(28, 'opening_time', 'Opening Time', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(29, 'app_address', 'App Address', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(30, 'theme_color', 'Theme Color', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(31, 'is_demo_mode_status', 'Is Demo Mode Status', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(32, 'same_type_product_buy_status', 'Same Type Product Buy Status', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(33, 'out_of_inventory_status', 'Out Of Inventory Status', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(34, 'invoice_terms', 'Invoice Terms', '9', '0', '2026-07-15 02:55:13.000000', '2026-07-15 02:55:13.000000'),
(35, 'role_permision', 'Role Permision', '10', '0', '2026-07-15 03:23:58.000000', '2026-07-15 03:23:58.000000'),
(36, 'sliders', 'Sliders', '10', '0', '2026-07-15 04:34:25.000000', '2026-07-15 04:34:25.000000'),
(37, 'services', 'Services', '10', '0', '2026-07-15 04:34:48.000000', '2026-07-15 04:34:48.000000'),
(38, 'category', 'Category', '10', '0', '2026-07-15 04:52:38.000000', '2026-07-15 04:52:38.000000');

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

--
-- Table structure for table `shipping_charges`
--

DROP TABLE IF EXISTS `shipping_charges`;
CREATE TABLE IF NOT EXISTS `shipping_charges` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) DEFAULT NULL,
  `amount` varchar(125) DEFAULT NULL,
  `creator` varchar(125) DEFAULT NULL,
  `updater` varchar(125) DEFAULT NULL,
  `status` varchar(125) NOT NULL DEFAULT '1',
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  `charge_negatiate_status` int(11) NOT NULL DEFAULT 0,
  `note` text DEFAULT NULL,
  `default_status` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shipping_charges`
--

INSERT INTO `shipping_charges` (`id`, `name`, `amount`, `creator`, `updater`, `status`, `created_at`, `updated_at`, `charge_negatiate_status`, `note`, `default_status`) VALUES
(1, 'Inside Dhaka', '50', '1', NULL, '1', '2026-07-15 03:14:28.000000', '2026-07-15 03:14:28.000000', 1, 'Placed in 3 days', 1),
(2, 'Outside Dhaka', '120', '1', NULL, '1', '2026-07-15 03:14:59.000000', '2026-07-15 03:14:59.000000', 1, 'Placed in 7 days', 0);

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

--
-- Table structure for table `sliders`
--

DROP TABLE IF EXISTS `sliders`;
CREATE TABLE IF NOT EXISTS `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(125) DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `sub_description` text DEFAULT NULL,
  `upload_id` bigint(20) DEFAULT NULL,
  `upload_bg` bigint(20) DEFAULT NULL,
  `button_title` varchar(125) DEFAULT NULL,
  `button_link` varchar(125) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `special_events`
--

DROP TABLE IF EXISTS `special_events`;
CREATE TABLE IF NOT EXISTS `special_events` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sub_categories`
--

DROP TABLE IF EXISTS `sub_categories`;
CREATE TABLE IF NOT EXISTS `sub_categories` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `creator` bigint(20) NOT NULL DEFAULT 0,
  `updater` bigint(20) NOT NULL DEFAULT 0,
  `name` varchar(125) NOT NULL,
  `slug` varchar(125) NOT NULL,
  `description` text DEFAULT NULL,
  `primary_description` text DEFAULT NULL,
  `additional_description` text DEFAULT NULL,
  `need_additional` varchar(125) NOT NULL DEFAULT '1',
  `category_id` varchar(125) NOT NULL,
  `special_status` varchar(125) NOT NULL DEFAULT '0',
  `status` varchar(125) NOT NULL DEFAULT '1',
  `feature` varchar(125) NOT NULL DEFAULT '0',
  `upload_id` varchar(125) DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sub_categories`
--

INSERT INTO `sub_categories` (`id`, `creator`, `updater`, `name`, `slug`, `description`, `primary_description`, `additional_description`, `need_additional`, `category_id`, `special_status`, `status`, `feature`, `upload_id`, `created_at`, `updated_at`) VALUES
(1, 0, 0, 'Uncategorized', 'uncategorized', NULL, NULL, NULL, '1', '1', '0', '0', '0', NULL, '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000'),
(2, 1, 1, 'Cap', 'cap', '', '', '', '0', '2', '0', '1', '0', '42', '2026-07-15 02:02:35.000000', '2026-07-15 02:02:35.000000'),
(3, 1, 1, 'Huny sing Cap', 'huny-sing-cap', '', '', '', '0', '4', '0', '1', '0', '43', '2026-07-15 02:21:48.000000', '2026-07-15 02:21:48.000000');

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

--
-- Table structure for table `sub_scribers`
--

DROP TABLE IF EXISTS `sub_scribers`;
CREATE TABLE IF NOT EXISTS `sub_scribers` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `email` varchar(125) NOT NULL,
  `name` varchar(125) NOT NULL,
  `verified` varchar(125) NOT NULL DEFAULT '0',
  `token` varchar(125) DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sub_scribers_email_unique` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `suppliers`
--

DROP TABLE IF EXISTS `suppliers`;
CREATE TABLE IF NOT EXISTS `suppliers` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) DEFAULT NULL,
  `email` varchar(125) DEFAULT NULL,
  `phone` varchar(125) DEFAULT NULL,
  `location` varchar(125) DEFAULT NULL,
  `business_name` varchar(125) DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `note` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `suppliers_account_id_index` (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `testimonials`
--

DROP TABLE IF EXISTS `testimonials`;
CREATE TABLE IF NOT EXISTS `testimonials` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) DEFAULT NULL,
  `designation` varchar(125) DEFAULT NULL,
  `description` varchar(125) DEFAULT NULL,
  `upload_id` bigint(20) NOT NULL DEFAULT 0,
  `rating` int(11) NOT NULL DEFAULT 2,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `creator` tinyint(1) NOT NULL DEFAULT 1,
  `updater` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `topbars`
--

DROP TABLE IF EXISTS `topbars`;
CREATE TABLE IF NOT EXISTS `topbars` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) DEFAULT '',
  `slug` varchar(125) NOT NULL DEFAULT '',
  `position` varchar(125) NOT NULL COMMENT ' left ,  center,  right',
  `order` int(11) NOT NULL DEFAULT 0,
  `parents` int(11) NOT NULL DEFAULT 0,
  `class` varchar(125) DEFAULT NULL,
  `key_name` varchar(125) DEFAULT NULL,
  `icon_class` varchar(125) DEFAULT NULL,
  `preset` tinyint(1) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `transactions`;
CREATE TABLE IF NOT EXISTS `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `payment_method_id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(191) NOT NULL,
  `reference` varchar(191) DEFAULT NULL,
  `amount` decimal(12,2) NOT NULL,
  `status` varchar(191) NOT NULL DEFAULT 'pending',
  `response` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`response`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `transactions_parts`
--

DROP TABLE IF EXISTS `transactions_parts`;
CREATE TABLE IF NOT EXISTS `transactions_parts` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `amount` decimal(12,2) NOT NULL,
  `fortrang_id` bigint(20) NOT NULL DEFAULT 0,
  `transaction_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `units`
--

DROP TABLE IF EXISTS `units`;
CREATE TABLE IF NOT EXISTS `units` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) DEFAULT NULL,
  `sort_name` varchar(125) DEFAULT NULL,
  `decimal` varchar(125) NOT NULL DEFAULT '0',
  `sub_items_id` varchar(125) NOT NULL DEFAULT '0',
  `sub_items` varchar(125) NOT NULL DEFAULT '0',
  `creator` varchar(125) NOT NULL DEFAULT '0',
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `units`
--

INSERT INTO `units` (`id`, `name`, `sort_name`, `decimal`, `sub_items_id`, `sub_items`, `creator`, `created_at`, `updated_at`) VALUES
(1, 'Piece', 'Piece', '0', '0', '0', '0', '2026-07-15 01:07:41.000000', '2026-07-15 01:07:41.000000');

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

--
-- Table structure for table `uploads`
--

DROP TABLE IF EXISTS `uploads`;
CREATE TABLE IF NOT EXISTS `uploads` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(2800) DEFAULT NULL,
  `extension` varchar(125) DEFAULT NULL,
  `size` varchar(125) DEFAULT NULL,
  `source` varchar(125) DEFAULT NULL,
  `user_id` varchar(125) DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `uploads`
--

INSERT INTO `uploads` (`id`, `name`, `extension`, `size`, `source`, `user_id`, `created_at`, `updated_at`) VALUES
(1, '01_559a6cc1_7f4b_4fe9_9b88_3bbf4bd5c202_1784099853063_x6276e.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:17:33.000000', '2026-07-15 01:17:33.000000'),
(2, '1_31c49203_b7f6_45cb_bffc_fca9ed751398_1784099887856_4e4515.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:08.000000', '2026-07-15 01:18:08.000000'),
(3, '02_e4c86bd2_9aeb_4f1f_b2cd_c9d576822e84_1784099888129_zygoyx.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:08.000000', '2026-07-15 01:18:08.000000'),
(4, '03_1c9bc672_903d_4a4d_88af_4d1a166250ef_1784099888289_bmhkz5.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:08.000000', '2026-07-15 01:18:08.000000'),
(5, '04_6880cdbf_7434_4b9d_8f56_436718be7932_1784099888448_gw2bs3.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:08.000000', '2026-07-15 01:18:08.000000'),
(6, '4_a5c1f162_975f_4867_b50b_85407330084e_1784099888593_pxd0rp.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:08.000000', '2026-07-15 01:18:08.000000'),
(7, '6_8d3e122e_279c_4509_a66c_82d5ad77161e_1784099888745_1awtwq.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:08.000000', '2026-07-15 01:18:08.000000'),
(8, '7_4eaf2343_36d5_4709_9e37_de5240f69fb3_1784099888900_2540zx.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:09.000000', '2026-07-15 01:18:09.000000'),
(9, '10_79a16c7a_62a3_4724_8a4a_abfc7b20b56a_1784099889061_7h1g2t.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:09.000000', '2026-07-15 01:18:09.000000'),
(10, '10_3137ca07_a5f5_4034_aa98_c2c15a76a221_1784099889213_az6hzs.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:09.000000', '2026-07-15 01:18:09.000000'),
(11, 'Artboard_1_307e0336_71c0_49d3_ae57_5aa7d6a5933a_1784099889363_4u7n95.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:09.000000', '2026-07-15 01:18:09.000000'),
(12, 'Artboard_4_83031de4_7d3a_423b_a96b_8d3e0b3a0771_1784099889530_khh9sh.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:09.000000', '2026-07-15 01:18:09.000000'),
(13, '3_aa312958_3bbe_41e0_8440_e10217f59508_1784099889709_9x42e2.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:09.000000', '2026-07-15 01:18:09.000000'),
(14, '9_fd67f579_970e_4041_80ad_4bddab0782fe_1784099889874_pvgmle.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:10.000000', '2026-07-15 01:18:10.000000'),
(15, 'Artboard_5_46d4851d_2de9_46ff_92c5_032e405fa763_1784099890035_mhftf4.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:10.000000', '2026-07-15 01:18:10.000000'),
(16, 'Artboard_4_96a12e13_b897_4212_9a09_90f5de533c3e_1784099890270_nfq0wk.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:10.000000', '2026-07-15 01:18:10.000000'),
(17, '8_42e3cb15_3613_4a65_a824_b7e83024ba22_1784099890416_r8g3ch.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:10.000000', '2026-07-15 01:18:10.000000'),
(18, '01_559a6cc1_7f4b_4fe9_9b88_3bbf4bd5c202_1784099890565_j7n1ju.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:10.000000', '2026-07-15 01:18:10.000000'),
(19, '01_c20354f5_8ab1_4214_a2f5_719eed27c6de_1784099890709_rw2a0p.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:18:10.000000', '2026-07-15 01:18:10.000000'),
(20, '2024_01_16_1000x_1784102342836_t0uq6z.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:03.000000', '2026-07-15 01:59:03.000000'),
(21, '01__CYBER_STRIKE_1784102343134_6m2z6m.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:03.000000', '2026-07-15 01:59:03.000000'),
(22, '01_01_Product_Poster_d7b960ee_a3b5_4deb_af4b_36bc1df33a7d_1784102343305_v77q29.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:03.000000', '2026-07-15 01:59:03.000000'),
(23, '1__SPEEDSTER_CAP___HGCSS04_1784102343485_l96g2u.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:03.000000', '2026-07-15 01:59:03.000000'),
(24, '02_05_Product_Poster_1784102343638_tzx8sv.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:03.000000', '2026-07-15 01:59:03.000000'),
(25, '3__Outland_1784102343853_7u258i.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:04.000000', '2026-07-15 01:59:04.000000'),
(26, '13_55ea5a20_cb51_431a_8619_5b536f7d52ca_1784102344013_kvyljl.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:04.000000', '2026-07-15 01:59:04.000000'),
(27, '17_8d45c7d1_7e35_4344_9378_a7201a177037_1784102344204_1f99vd.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:04.000000', '2026-07-15 01:59:04.000000'),
(28, '19_2249d0da_9788_4ff8_b44e_8540940abca3_1784102344363_fgt1ir.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:04.000000', '2026-07-15 01:59:04.000000'),
(29, '484996597_965701689035653_9030764570763038217_n_1000x_1784102344520_mg4qy4.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:04.000000', '2026-07-15 01:59:04.000000'),
(30, 'Artboard_1_41a04d16_f832_41b0_aa34_1ab3d6716fcd_1784102344671_spzwxj.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:04.000000', '2026-07-15 01:59:04.000000'),
(31, 'Artboard_1_copy_2_5354693c_2ffc_4def_8c71_00020169b0fa_1784102344830_mnv4a0.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:04.000000', '2026-07-15 01:59:04.000000'),
(32, 'Artboard_2_9b736da4_a72a_420c_b6b2_5b9ee4f4d8cd_1784102345001_hugic9.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:05.000000', '2026-07-15 01:59:05.000000'),
(33, 'Artboard_2_c2d1d514_b6cd_4409_a490_a50bb5a3a1af_1784102345271_bvq949.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:05.000000', '2026-07-15 01:59:05.000000'),
(34, 'Artboard_3_61e8991c_2298_4425_b6ee_36cab42d1133_1784102345459_3o93s2.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:05.000000', '2026-07-15 01:59:05.000000'),
(35, 'Artboard_3_c81fab2e_4e65_466a_b12f_abaa0bf312ca_1784102345607_8h3je6.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:05.000000', '2026-07-15 01:59:05.000000'),
(36, 'Artboard_4_cfb7aaf9_9342_443c_b7a8_63b4708866fb_1784102345753_bmdzlq.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:05.000000', '2026-07-15 01:59:05.000000'),
(37, 'Artboard_8_45726dfa_2572_4be9_883d_bd7abed88794_1784102345935_79wxq3.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:06.000000', '2026-07-15 01:59:06.000000'),
(38, 'Artboard_15_c4ca0a6f_468a_4f07_8e5c_db4ae9882636_1784102346112_ncuy6h.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:06.000000', '2026-07-15 01:59:06.000000'),
(39, 'Dignified_Poster1_1784102346280_kd9ptq.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:06.000000', '2026-07-15 01:59:06.000000'),
(40, 'Edge_Series_1784102346488_9r9dwx.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:06.000000', '2026-07-15 01:59:06.000000'),
(41, 'Elegante_Zero_1784102346649_a63yo2.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:06.000000', '2026-07-15 01:59:06.000000'),
(42, 'Elegante_Zero_jpg_1784102346810_8ki02x.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:06.000000', '2026-07-15 01:59:06.000000'),
(43, 'Forever_Black_1784102346963_iig1c3.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:07.000000', '2026-07-15 01:59:07.000000'),
(44, 'Homeland_Series_Poster_1784102347143_lbfdcn.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:07.000000', '2026-07-15 01:59:07.000000'),
(45, 'KV_5ed62438_a307_4a86_bf00_ddaded4a4c86_1784102347299_y1wtr0.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:07.000000', '2026-07-15 01:59:07.000000'),
(46, 'Mitchmached_1784102347487_ebr8d3.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:07.000000', '2026-07-15 01:59:07.000000'),
(47, 'Own_The_City_1784102347647_fmokzq.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:07.000000', '2026-07-15 01:59:07.000000'),
(48, 'Own_The_City_jpg_1784102347807_b8bzy4.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:07.000000', '2026-07-15 01:59:07.000000'),
(49, 'Square_1784102347962_cxvfx8.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:08.000000', '2026-07-15 01:59:08.000000'),
(50, 'Suede_Cord_5_1784102348117_nhf3kx.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:08.000000', '2026-07-15 01:59:08.000000'),
(51, 'Top_Tier_1784102348372_0894nb.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:08.000000', '2026-07-15 01:59:08.000000'),
(52, 'truly_Classic_PP_1784102348562_w6a8e2.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:08.000000', '2026-07-15 01:59:08.000000'),
(53, 'unnamed_1000x_1784102348720_rucrs4.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:08.000000', '2026-07-15 01:59:08.000000'),
(54, 'Velvet_5_1784102348887_ch0h46.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:09.000000', '2026-07-15 01:59:09.000000'),
(55, 'WhatsApp_Image_2026_01_18_at_4_50_35_PM_1000x_1784102349056_io1sr5.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:09.000000', '2026-07-15 01:59:09.000000'),
(56, 'Wide_1784102349223_9ligik.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:09.000000', '2026-07-15 01:59:09.000000'),
(57, 'Artboard_5_74e79798_3898_4d26_937f_ac83a95a7c15_1784102349435_qx5nfo.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:09.000000', '2026-07-15 01:59:09.000000'),
(58, '01_559a6cc1_7f4b_4fe9_9b88_3bbf4bd5c202_1784102349587_56bg93.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:09.000000', '2026-07-15 01:59:09.000000'),
(59, '01_c20354f5_8ab1_4214_a2f5_719eed27c6de_1784102349736_h3die1.jpg', 'jpg', NULL, 'Local', '1', '2026-07-15 01:59:09.000000', '2026-07-15 01:59:09.000000'),
(60, '2064071724587762728.jpg', 'jpg', '268201', 'Local', '1', '2026-07-15 02:42:45.000000', '2026-07-15 02:42:45.000000');

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

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

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `prefix` varchar(125) DEFAULT NULL,
  `name` varchar(125) NOT NULL,
  `username` varchar(125) DEFAULT NULL,
  `email` varchar(125) NOT NULL,
  `mobile_number` varchar(125) DEFAULT NULL,
  `salary` varchar(125) NOT NULL DEFAULT '0',
  `joining_date` date DEFAULT NULL,
  `exit_date` date DEFAULT NULL,
  `upload_id` varchar(125) NOT NULL DEFAULT '0',
  `status` varchar(125) NOT NULL DEFAULT '0',
  `sales_status` varchar(125) NOT NULL DEFAULT '0',
  `sales_commission_present` varchar(125) NOT NULL DEFAULT '0',
  `email_verified_at` datetime DEFAULT NULL,
  `password` varchar(125) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  `employee_status` tinyint(1) NOT NULL DEFAULT 0,
  `degination` varchar(150) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `user_type` varchar(20) NOT NULL DEFAULT 'customer',
  `v_code` varchar(125) DEFAULT NULL,
  `v_status` tinyint(1) NOT NULL DEFAULT 0,
  `instagram_id` varchar(125) DEFAULT NULL,
  `linkedin_id` varchar(125) DEFAULT NULL,
  `twitter_id` varchar(125) DEFAULT NULL,
  `github_id` varchar(125) DEFAULT NULL,
  `facebook_id` varchar(125) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `prefix`, `name`, `username`, `email`, `mobile_number`, `salary`, `joining_date`, `exit_date`, `upload_id`, `status`, `sales_status`, `sales_commission_present`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `employee_status`, `degination`, `note`, `user_type`, `v_code`, `v_status`, `instagram_id`, `linkedin_id`, `twitter_id`, `github_id`, `facebook_id`) VALUES
(1, NULL, 'Super Admin', 'superadmin', 'admin@gmail.com', '', '0', NULL, NULL, '60', '1', '0', '0', NULL, '$2y$12$1HB0hmHRe37Re2SGnPbYZezbUB3ydxjGiy8iOnH0Om2aq3H5QO9OC', NULL, '2026-07-15 01:07:40.000000', '2026-07-15 03:19:56.000000', 0, NULL, NULL, 'admin', NULL, 0, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `variant_options`
--

DROP TABLE IF EXISTS `variant_options`;
CREATE TABLE IF NOT EXISTS `variant_options` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) NOT NULL,
  `name` varchar(125) DEFAULT NULL,
  `details_key_value_0` varchar(125) DEFAULT NULL,
  `details_key_value_1` varchar(125) DEFAULT NULL,
  `details_key_value_2` varchar(125) DEFAULT NULL,
  `details_key_value_3` varchar(125) DEFAULT NULL,
  `details_key_value_4` varchar(125) DEFAULT NULL,
  `details_key_value_5` varchar(125) DEFAULT NULL,
  `details_key_value_6` varchar(125) DEFAULT NULL,
  `details_key_value_7` varchar(125) DEFAULT NULL,
  `details_key_value_8` varchar(125) DEFAULT NULL,
  `details_key_value_9` varchar(125) DEFAULT NULL,
  `details_key_value_10` varchar(125) DEFAULT NULL,
  `details_key_value_11` varchar(125) DEFAULT NULL,
  `details_key_value_12` varchar(125) DEFAULT NULL,
  `details_key_value_13` varchar(125) DEFAULT NULL,
  `details_key_value_14` varchar(125) DEFAULT NULL,
  `details_key_value_15` varchar(125) DEFAULT NULL,
  `details_key_value_16` varchar(125) DEFAULT NULL,
  `details_key_value_17` varchar(125) DEFAULT NULL,
  `details_key_value_18` varchar(125) DEFAULT NULL,
  `details_key_value_19` varchar(125) DEFAULT NULL,
  `old_price` varchar(125) NOT NULL DEFAULT '0',
  `selling_price` varchar(125) NOT NULL DEFAULT '0',
  `alert_quantity` varchar(125) NOT NULL DEFAULT '0',
  `creator` bigint(20) NOT NULL DEFAULT 0,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  `upload_id` bigint(20) NOT NULL DEFAULT 0,
  `purchase_price` bigint(20) NOT NULL DEFAULT 0,
  `inventory` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `visitors`
--

DROP TABLE IF EXISTS `visitors`;
CREATE TABLE IF NOT EXISTS `visitors` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(125) NOT NULL,
  `user_agent` varchar(125) NOT NULL,
  `browser` varchar(125) NOT NULL,
  `visit_date` date NOT NULL,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `visitors_ip_address_visit_date_unique` (`ip_address`,`visit_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `why_choose_us`
--

DROP TABLE IF EXISTS `why_choose_us`;
CREATE TABLE IF NOT EXISTS `why_choose_us` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(125) DEFAULT NULL,
  `icon` varchar(125) DEFAULT NULL,
  `creator` varchar(125) NOT NULL DEFAULT '0',
  `updater` varchar(125) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp(6) NULL DEFAULT NULL,
  `updated_at` timestamp(6) NULL DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
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 */;