-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Dec 12, 2025 at 08:58 PM
-- Server version: 10.11.10-MariaDB-log
-- PHP Version: 8.1.32

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: `sql_pos_kodetr_c`
--

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

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

CREATE TABLE `accounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `account_no` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `initial_balance` double DEFAULT NULL,
  `total_balance` double NOT NULL,
  `note` text DEFAULT NULL,
  `is_default` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `attendances`
--

CREATE TABLE `attendances` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `employee_id` bigint(20) UNSIGNED NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `date` date NOT NULL,
  `checkin` time NOT NULL,
  `checkout` time NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `brands` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `title` varchar(191) NOT NULL,
  `thumbnail_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `brands` (`id`, `shop_id`, `created_by`, `title`, `thumbnail_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 2, 'Bogasari', 11, '2025-09-01 03:17:09', '2025-09-02 05:45:00', '2025-09-02 05:45:00'),
(2, 1, 2, 'Kunci Mas', 13, '2025-09-02 06:09:00', '2025-09-02 06:38:46', NULL),
(3, 1, 2, 'Kunci Mas', 14, '2025-09-02 06:14:31', '2025-09-02 06:38:34', NULL),
(9, 1, 2, 'Rose Brand', 20, '2025-09-02 06:42:32', '2025-09-02 06:42:32', NULL),
(4, 1, 2, 'Minyak kita', 15, '2025-09-02 06:16:02', '2025-09-02 06:38:23', NULL),
(5, 1, 2, 'Minyak Kita', 16, '2025-09-02 06:16:26', '2025-09-02 06:38:12', NULL),
(6, 1, 2, 'Minyak Kita', 17, '2025-09-02 06:16:59', '2025-09-02 06:38:02', NULL),
(7, 1, 2, 'Minyak Rizki', 18, '2025-09-02 06:17:30', '2025-09-02 06:17:30', NULL),
(8, 1, 2, 'Minyak Kita', 19, '2025-09-02 06:17:58', '2025-09-02 06:37:30', NULL),
(10, 1, 2, 'Rose Brand', 21, '2025-09-02 06:43:32', '2025-09-02 06:43:32', NULL),
(11, 1, 2, 'interflour', 22, '2025-09-02 06:44:38', '2025-09-02 06:44:38', NULL),
(12, 1, 2, 'kutilang', 23, '2025-09-02 06:58:07', '2025-09-02 06:58:07', NULL),
(13, 1, 2, 'victory', 24, '2025-09-02 07:41:56', '2025-09-02 07:41:56', NULL),
(14, 1, 2, 'Send', 25, '2025-09-02 07:50:38', '2025-09-02 07:50:38', NULL),
(15, 1, 2, 'LUX', 26, '2025-09-02 07:57:18', '2025-09-02 07:57:18', NULL),
(16, 1, 2, 'Matahari', 27, '2025-09-02 08:00:46', '2025-09-02 08:00:46', NULL),
(17, 1, 2, 'Nasional', 28, '2025-09-02 08:07:46', '2025-09-02 08:07:46', NULL),
(18, 1, 2, 'simpang', 29, '2025-09-02 08:15:07', '2025-09-02 08:15:07', NULL),
(19, 1, 2, 'paper cup', 30, '2025-09-02 08:26:01', '2025-09-02 08:26:01', NULL),
(20, 1, 2, 'paper bowl', 31, '2025-09-02 08:26:21', '2025-09-02 08:26:21', NULL);

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

--
-- Table structure for table `business_modules`
--

CREATE TABLE `business_modules` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `label` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `business_modules`
--

INSERT INTO `business_modules` (`id`, `name`, `label`, `created_at`, `updated_at`) VALUES
(1, 'purchases', 'Purchases', '2025-08-24 16:29:13', '2025-08-24 16:29:13'),
(2, 'barcodes', 'Barcodes', '2025-08-24 16:29:13', '2025-08-24 16:29:13'),
(3, 'product_variants', 'Product Variants', '2025-08-24 16:29:13', '2025-08-24 16:29:13'),
(4, 'product_serial_numbers', 'Product Serial/IMEI Numbers', '2025-08-24 16:29:13', '2025-08-24 16:29:13'),
(5, 'product_batch_and_expire_date', 'Product batch and expire date', '2025-08-24 16:29:13', '2025-08-24 16:29:13');

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

--
-- Table structure for table `business_modules_shop`
--

CREATE TABLE `business_modules_shop` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `business_modules_id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `business_modules_shop`
--

INSERT INTO `business_modules_shop` (`id`, `business_modules_id`, `shop_id`) VALUES
(1, 1, 1),
(2, 2, 1),
(3, 3, 1),
(4, 4, 1),
(5, 5, 1);

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

--
-- Table structure for table `business_modules_shop_category`
--

CREATE TABLE `business_modules_shop_category` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `business_modules_id` bigint(20) UNSIGNED NOT NULL,
  `shop_category_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `thumbnail_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `parent_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` (`id`, `shop_id`, `created_by`, `thumbnail_id`, `name`, `parent_id`, `created_at`, `updated_at`, `deleted_at`) VALUES
(2, 1, 2, NULL, 'Pelastik', NULL, '2025-09-02 05:54:53', '2025-09-02 05:54:53', NULL),
(3, 1, 2, NULL, 'bahan pokok', NULL, '2025-10-17 10:09:21', '2025-10-17 10:09:21', NULL);

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

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

CREATE TABLE `coupons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `code` varchar(191) NOT NULL,
  `type` varchar(191) NOT NULL,
  `amount` double NOT NULL DEFAULT 0,
  `min_amount` double DEFAULT NULL,
  `max_amount` double DEFAULT NULL,
  `qty` int(11) NOT NULL DEFAULT 0,
  `expired_at` date DEFAULT NULL,
  `used` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `currencies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `code` varchar(191) NOT NULL,
  `symbol` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` (`id`, `shop_id`, `created_by`, `name`, `code`, `symbol`, `created_at`, `updated_at`, `deleted_at`) VALUES
(4, NULL, 1, 'Rupiah', 'IDR', 'Rp', '2025-08-24 16:37:03', '2025-08-24 16:37:03', NULL),
(6, 1, 2, 'Rupiah', 'IDR', 'Rp', '2025-08-28 13:11:14', '2025-08-28 13:11:14', NULL),
(7, 2, 3, 'US Dollar', 'USD', '$', '2025-08-28 14:09:55', '2025-08-28 14:09:55', NULL),
(8, NULL, 1, 'Dollar', 'USD', '$', '2025-09-02 22:11:00', '2025-09-02 22:11:00', NULL);

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

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

CREATE TABLE `customers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `customer_group_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `company_name` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `phone_number` varchar(191) NOT NULL,
  `tax_no` varchar(191) DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `postal_code` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `deposit` double DEFAULT NULL,
  `expense` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `customer_groups`
--

CREATE TABLE `customer_groups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `percentage` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `email_verifications`
--

CREATE TABLE `email_verifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `email_verifications`
--

INSERT INTO `email_verifications` (`id`, `user_id`, `token`, `created_at`, `updated_at`) VALUES
(2, 3, 'YIs1tds5D67QVwgDzxt29QCOjgM7cKzQqP4iKodGJC91BXhBVMhJkHOsmXMbSLW3', '2025-08-28 14:09:55', '2025-08-28 14:09:55');

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

--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `department_id` bigint(20) UNSIGNED DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `staff_id` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `reference_no` varchar(191) NOT NULL,
  `expense_category_id` bigint(20) UNSIGNED NOT NULL,
  `warehouse_id` bigint(20) UNSIGNED NOT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `amount` double NOT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `expense_categories`
--

CREATE TABLE `expense_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `code` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `general_settings`
--

CREATE TABLE `general_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `site_title` varchar(191) NOT NULL,
  `logo_id` bigint(20) UNSIGNED DEFAULT NULL,
  `small_logo_id` bigint(20) UNSIGNED DEFAULT NULL,
  `fav_id` bigint(20) UNSIGNED DEFAULT NULL,
  `currency_id` bigint(20) UNSIGNED NOT NULL,
  `currency_position` varchar(191) DEFAULT NULL,
  `date_with_time` varchar(191) NOT NULL,
  `date_format` varchar(191) DEFAULT NULL,
  `developed_by` varchar(191) DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `direction` varchar(191) DEFAULT NULL,
  `lang` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `barcode_digits` int(11) DEFAULT NULL,
  `copyright_text` varchar(191) DEFAULT NULL,
  `copyright_url` varchar(191) DEFAULT NULL,
  `dark_mode` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `general_settings`
--

INSERT INTO `general_settings` (`id`, `shop_id`, `site_title`, `logo_id`, `small_logo_id`, `fav_id`, `currency_id`, `currency_position`, `date_with_time`, `date_format`, `developed_by`, `address`, `email`, `phone`, `direction`, `lang`, `created_at`, `updated_at`, `barcode_digits`, `copyright_text`, `copyright_url`, `dark_mode`) VALUES
(1, NULL, 'POS', 7, NULL, 6, 4, 'Prefix', 'Enable', 'd-m-Y', NULL, 'Jl. Raya Lembar, Desa lembar selatan, Kab. Lombok Barat, Pos 83364', 'team@kodetr.com', '085156350839', 'ltr', 'id', '2025-08-24 16:29:13', '2025-09-21 21:32:50', 8, '2025 Kodetr. All rights reserved', NULL, 0),
(2, 1, 'POS UMKM', 8, 9, NULL, 6, 'Prefix', 'Enable', 'd-m-Y', 'Ridho Haries Hidayat', 'Lombok Timur', 'mridhoharieshidayat@gmail.com', '085955295041', 'ltr', 'id', '2025-08-24 17:08:16', '2025-12-06 10:57:58', 8, NULL, NULL, 0);

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

--
-- Table structure for table `holidays`
--

CREATE TABLE `holidays` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `from` date NOT NULL,
  `to` date NOT NULL,
  `reason` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `thumbnail_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`id`, `title`, `name`, `created_at`, `updated_at`, `thumbnail_id`) VALUES
(5, 'English', 'en', '2025-09-02 22:01:07', '2025-09-02 22:01:07', 31),
(4, 'Indonesia', 'id', '2025-09-02 22:01:07', '2025-09-02 22:01:07', 32);

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

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

CREATE TABLE `media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `extension` varchar(191) DEFAULT NULL,
  `src` varchar(191) NOT NULL,
  `path` varchar(191) DEFAULT NULL,
  `type` varchar(191) NOT NULL DEFAULT 'image',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media`
--

INSERT INTO `media` (`id`, `name`, `extension`, `src`, `path`, `type`, `created_at`, `updated_at`) VALUES
(1, NULL, 'jpg', 'uploaded/languages/tPMoctsluD5BoIniyFucmlMb2yeQIelRLrMDPLKLlrz7NvMXRv.jpg', '/languages', 'Image', '2025-08-24 16:29:13', '2025-09-02 21:59:26'),
(4, NULL, 'jpg', 'users/kAkR6Wy2UfFqIdA70Bpge1gRmQvb50TVoYZ5nNk0.jpg', '/users', 'Image', '2025-08-24 16:30:22', '2025-08-24 16:38:40'),
(5, NULL, NULL, 'default/default.jpg', 'default/', 'Image', '2025-08-24 16:30:22', '2025-08-24 16:30:22'),
(6, NULL, 'png', 'settings/lBaSvrzIKCV2c9WbfwYD46PrAihyVbRVkBCKVZeJ.png', '/settings', 'Image', '2025-08-24 16:51:43', '2025-08-24 16:51:43'),
(7, NULL, 'png', 'uploaded/settings/ZtwOXN4N38Mfa3yGFQ8O9WJzcAowRGxTGScGRDy4s0t2LUOaiz.png', '/settings', 'Image', '2025-09-01 01:46:25', '2025-09-01 01:53:29'),
(8, NULL, 'png', 'uploaded/settings/dwR0gtfAlbwJECAgBL3Q6TKahPOeo7ZxJDsRTzSJW7WG2jlOaO.png', '/settings', 'Image', '2025-09-01 01:59:36', '2025-09-01 02:01:27'),
(9, NULL, 'png', 'uploaded/settings/ym7sjDjsSh0XrIBOf3C2wtJ0oluyTFkIro1OWH1WpSw2NAl5xI.png', '/settings', 'Image', '2025-09-01 02:01:51', '2025-09-01 02:01:51'),
(10, NULL, 'jpg', 'uploaded/category/uKqzeNuENZeRQsdqtyNHoA9OlV6LFnkKf1bxqo2NxcAww0NfNA.jpg', '/category', 'Image', '2025-09-01 03:06:05', '2025-09-01 03:22:42'),
(11, NULL, NULL, 'uploaded/brand/sgFSmCgcTMzI9NHc44kIFEiyJc3g6FJ2azEW2SBawnavXLbDUD.png', NULL, 'Image', '2025-09-01 03:17:09', '2025-09-01 03:17:09'),
(12, NULL, NULL, 'uploaded/product/JZbAmKD2mZmQ4mPre5vZCqLE4RHJVhWp8cNEJrqpftBur6AD1F.jpg', NULL, 'Image', '2025-09-01 03:27:49', '2025-09-01 03:27:49'),
(13, NULL, 'jpg', 'uploaded/brand/mkCc5dVIJEPOwBpzeRaD5C3RM6iZyHX8qUG6FWinL43HWuKXet.jpg', '/brand', 'Image', '2025-09-02 06:09:00', '2025-09-02 06:15:17'),
(14, NULL, NULL, 'uploaded/brand/Mhf6HDKpysXxtyFnLsoNt3pOlnRmym25bv4Hcv64VBeoPGhZSy.jpg', NULL, 'Image', '2025-09-02 06:14:31', '2025-09-02 06:14:31'),
(15, NULL, NULL, 'uploaded/brand/cuFHVrRzrkyoswMpyRIz2wHkIFdE9Zd4lEeSXO3OnmjAJ03FNb.jpg', NULL, 'Image', '2025-09-02 06:16:02', '2025-09-02 06:16:02'),
(16, NULL, NULL, 'uploaded/brand/XzA4DqQM8fIRrKfJQrish6KtX8xEW9jUDEzscPOlOx2odRFG4F.jpg', NULL, 'Image', '2025-09-02 06:16:26', '2025-09-02 06:16:26'),
(17, NULL, NULL, 'uploaded/brand/A4JhM6nVMdELNe5mb9fbFQBLWMeeaHd9y2OTvy9r6lrSY0OoXa.jpg', NULL, 'Image', '2025-09-02 06:16:59', '2025-09-02 06:16:59'),
(18, NULL, NULL, 'uploaded/brand/Mj7XrWNJ59AHt4JgUOEnELBrsdS1kqY2BtmpxhAYorbBekfBLV.jpg', NULL, 'Image', '2025-09-02 06:17:30', '2025-09-02 06:17:30'),
(19, NULL, NULL, 'uploaded/brand/eKo3u0GB4OCxjp44Eh1PWpR8XSIYLALbH6KSMlDI5BBTveojyV.jpg', NULL, 'Image', '2025-09-02 06:17:58', '2025-09-02 06:17:58'),
(20, NULL, NULL, 'uploaded/brand/SYJHBkBGu2YG0As6N894EqHvYVIAY6ot7EdPE3tqgBC0i7Pdow.jpg', NULL, 'Image', '2025-09-02 06:42:32', '2025-09-02 06:42:32'),
(21, NULL, NULL, 'uploaded/brand/h05iikjyJ9IdDdjs9xbuUpuE2cjHHfZJnVKCF2Hvn5aQBUKt5M.jpg', NULL, 'Image', '2025-09-02 06:43:32', '2025-09-02 06:43:32'),
(22, NULL, NULL, 'uploaded/brand/3VsPrcJXZsj396cCuVPvQWBH0jUe2AhKAceFdmdgEL2zm6ATM4.jpg', NULL, 'Image', '2025-09-02 06:44:38', '2025-09-02 06:44:38'),
(23, NULL, NULL, 'uploaded/brand/fjPxGm11U5uwseQ5sQrLGZK1kuAemzDVw4oxTHyLInmfF1Alx2.jpg', NULL, 'Image', '2025-09-02 06:58:07', '2025-09-02 06:58:07'),
(24, NULL, NULL, 'uploaded/brand/Ysj0mHZIElAKOf6sJXW8ub9wONNphoJhvCJmF8701qcPb4TlXi.jpg', NULL, 'Image', '2025-09-02 07:41:56', '2025-09-02 07:41:56'),
(25, NULL, NULL, 'uploaded/brand/1FzgOZo4K9PN1dAOcwnW5gzT1c03EyMg3CPJr3a5Gog2LIGiLW.jpg', NULL, 'Image', '2025-09-02 07:50:38', '2025-09-02 07:50:38'),
(26, NULL, NULL, 'uploaded/brand/M4Xv0kK4dWZ31VZ0eb5Ig3cq7R0Vof8uTiJXxR7s0Ubv1liSq2.jpg', NULL, 'Image', '2025-09-02 07:57:18', '2025-09-02 07:57:18'),
(27, NULL, NULL, 'uploaded/brand/kcvWy7iPhnWUEDNx7d7KcMIXzpt8uwyTUj8AZg9Pz8fXf1qM3W.jpg', NULL, 'Image', '2025-09-02 08:00:46', '2025-09-02 08:00:46'),
(28, NULL, NULL, 'uploaded/brand/OccJxXzbm7idnaflip456OANzPOspGHRnkFPtInccPeabsKVvr.jpg', NULL, 'Image', '2025-09-02 08:07:46', '2025-09-02 08:07:46'),
(29, NULL, NULL, 'uploaded/brand/7igaowcXVKAMxqKcn6mnfAIRGCStACTJAxKFplicZyo2BZBbYr.jpg', NULL, 'Image', '2025-09-02 08:15:07', '2025-09-02 08:15:07'),
(30, NULL, NULL, 'uploaded/brand/D2dwqqn3Sz60tHRpiy5G1mCAZ84tUG2bZ0FKamlrGgLDh796Qm.jpg', NULL, 'Image', '2025-09-02 08:26:01', '2025-09-02 08:26:01'),
(31, NULL, 'png', 'uploaded/languages/BqhQux0eTLau8pkXTbhXerrjKCabsLF2XOfmdsTx77qnNkyZft.png', '/languages', 'Image', '2025-09-02 08:26:21', '2025-12-10 16:41:05'),
(32, NULL, 'png', 'uploaded/languages/8Ai2BIAffxnSfgWin3MAx8nV917rZzRFdrrhjX3t1P0tv3quoG.png', '/languages', 'Image', '2025-09-02 22:01:07', '2025-09-02 22:22:44'),
(33, NULL, 'png', 'uploaded/product/CwxjM9r4VJ4kw1oro9FzueJw8USD2xdQ8H8hxSOYHLvhLSQysv.png', '/product', 'Image', '2025-12-09 15:42:55', '2025-12-09 15:42:55'),
(34, NULL, 'png', 'uploaded/product/H3zbJCQdNJGW8TibXSRmLdmHiFzYkWFeDPcXzdSU7LOZFq22hN.png', '/product', 'Image', '2025-12-09 15:43:22', '2025-12-09 15:45:18'),
(35, NULL, 'jpg', 'uploaded/product/Az8muQpbpJxAmZmXv8ZRhJTKzqkSogSFrGMCcqNVMabkBnKjpo.jpg', '/product', 'Image', '2025-12-09 15:46:39', '2025-12-11 17:12:08'),
(36, NULL, NULL, 'uploaded/product/XTAlotyqwIJXgCEQ6uqgnoGuCQvP6paCAUoifWSqEqXCeRY42g.jpg', NULL, 'Image', '2025-12-10 16:02:24', '2025-12-10 16:02:24'),
(37, NULL, 'jpg', 'uploaded/product/pg8xn68oduJD9XfT7UbutUv2sgKHmGf6FPxlfCL4EZu9WVaJ2z.jpg', '/product', 'Image', '2025-12-11 17:12:58', '2025-12-11 17:12:58'),
(38, NULL, 'jpg', 'uploaded/product/CESSTUzUoMpkUcSjRc5W4GNzSnXFSIkUpaDY8C286nGzLI9AYo.jpg', '/product', 'Image', '2025-12-11 17:13:57', '2025-12-11 17:13:57'),
(39, NULL, 'jpg', 'uploaded/product/hyo03JYawmM58xK7R5ayVlOUGHo6SMxLBrO9OsItGpxVorUTaZ.jpg', '/product', 'Image', '2025-12-11 17:14:35', '2025-12-11 17:14:35'),
(40, NULL, 'jpg', 'uploaded/product/k9sUueHbWcDc4ZtnioqAjyH9kpzSZLt00H2D0oT0GVYOEcNI6K.jpg', '/product', 'Image', '2025-12-11 17:15:22', '2025-12-11 17:15:22'),
(41, NULL, 'jpg', 'uploaded/product/2AUwZxcm3W2pMdfaYGiKDJMQXsTQQ0Be8PI85wQerqFJGPlBtS.jpg', '/product', 'Image', '2025-12-11 17:15:57', '2025-12-11 17:15:57'),
(42, NULL, 'jpg', 'uploaded/product/m07zHrCKDLK0GqyCqEWu2EJYtVJX6lRzu0eUqTR5F4uT4lh5jo.jpg', '/product', 'Image', '2025-12-11 17:16:30', '2025-12-11 17:16:30'),
(43, NULL, 'jpg', 'uploaded/product/YqPgUaoye0VcjIzGPYuo9LIbjsDeI1sPfWbxTpT4ZWlQlzG9g6.jpg', '/product', 'Image', '2025-12-11 17:16:57', '2025-12-11 17:16:57'),
(44, NULL, 'jpg', 'uploaded/product/RFyXZ60lb1uhvHql9OVml75N7X6HJ8q2i8eNbOAaBXxqw9mAWE.jpg', '/product', 'Image', '2025-12-11 17:21:26', '2025-12-11 17:21:26'),
(45, NULL, 'jpg', 'uploaded/product/RV43AAvRWGJpKpNPRSf7eEHlYeMj6AzBSEQY8dKA3NEwIj88rs.jpg', '/product', 'Image', '2025-12-11 17:22:40', '2025-12-11 17:22:40'),
(46, NULL, 'jpg', 'uploaded/product/EfcmLRlXiT1Ox5n2qxrdc0AC6n1dvxk0qovReVU0CtyGI4Lbvq.jpg', '/product', 'Image', '2025-12-11 17:25:50', '2025-12-11 17:25:50');

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_11_000000_create_media_table', 1),
(2, '2014_10_11_000001_create_users_table', 1),
(3, '2014_10_11_000002_create_shop_categories_table', 1),
(4, '2014_10_11_000003_create_shops_table', 1),
(5, '2014_10_12_000098_create_warehouse_table', 1),
(6, '2014_10_12_100000_create_password_resets_table', 1),
(7, '2018_02_17_060412_create_categories_table', 1),
(8, '2018_02_18_060412_create_variants_table', 1),
(9, '2018_02_20_035727_create_brands_table', 1),
(10, '2018_02_25_100635_create_suppliers_table', 1),
(11, '2018_03_03_040448_create_units_table', 1),
(12, '2018_03_04_041317_create_taxes_table', 1),
(13, '2018_03_10_061915_create_customer_groups_table', 1),
(14, '2018_03_10_090534_create_customers_table', 1),
(15, '2018_04_05_054401_create_products_table', 1),
(16, '2018_04_06_133606_create_purchases_table', 1),
(17, '2018_04_06_154600_create_product_purchases_table', 1),
(18, '2018_04_06_154915_create_product_warhouse_table', 1),
(19, '2018_04_10_085927_create_sales_table', 1),
(20, '2018_04_10_090132_create_accounts_table', 1),
(21, '2018_04_10_090133_create_product_sales_table', 1),
(22, '2018_04_10_090254_create_payments_table', 1),
(23, '2018_06_26_043308_create_currencies_table', 1),
(24, '2018_07_06_115449_create_general_settings_table', 1),
(25, '2018_08_16_053336_create_expense_categories_table', 1),
(26, '2018_08_17_115415_create_expenses_table', 1),
(27, '2018_10_26_034927_create_coupons_table', 1),
(28, '2019_02_15_183303_create_stock_counts_table', 1),
(29, '2019_08_19_000000_create_failed_jobs_table', 1),
(30, '2019_11_13_150206_create_product_variants_table', 1),
(31, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(32, '2020_02_28_103340_create_money_transfers_table', 1),
(33, '2023_07_23_135440_create_permission_tables', 1),
(34, '2023_09_10_060353_create_recovery_password_codes_table', 1),
(35, '2023_10_01_054351_create_transections_table', 1),
(36, '2023_10_01_074048_create_wallets_table', 1),
(37, '2023_10_18_032147_create_purchase_batches_table', 1),
(38, '2023_11_12_234600_create_email_verifications_table', 1),
(39, '2023_11_18_110022_create_languages_table', 1),
(40, '2023_11_18_223944_create_sale_returns_table', 1),
(41, '2023_11_19_061906_create_sale_return_products_table', 1),
(42, '2023_11_28_012836_create_subscriptions_table', 1),
(43, '2023_12_02_020245_create_subscription_requests_table', 1),
(44, '2023_12_09_061608_create_payment_gateways_table', 1),
(45, '2023_12_20_012158_add_paid_to_roles_table', 1),
(46, '2023_12_20_033144_create_stores_table', 1),
(47, '2023_12_23_012951_create_shop_subscriptions_table', 1),
(48, '2023_12_26_044436_create_shop_users_table', 1),
(49, '2024_01_02_005516_modify_table_customers_change_email_and_phone', 1),
(50, '2024_01_14_022925_add_token_column_to_recovery_password_codes_table', 1),
(51, '2024_02_07_102953_modify_column_in_table_purchase', 1),
(52, '2024_02_14_062141_add_is_lifetime_to_shops_table', 1),
(53, '2024_02_24_234411_add_barcode_digits_to_general_settings_table', 1),
(54, '2024_03_03_001950_create_departments_table', 1),
(55, '2024_03_03_012249_create_employees_table', 1),
(56, '2024_03_03_024615_create_attendances_table', 1),
(57, '2024_03_03_055639_create_holidays_table', 1),
(58, '2024_03_03_075511_add_delete_to_shops_table', 1),
(59, '2024_03_04_105301_create_payrolls_table', 1),
(60, '2024_03_27_143247_add_payment_method_to_sales_table', 1),
(61, '2024_05_07_182458_add_copyright_text_and_copyright_url', 1),
(62, '2024_06_06_114903_modify_products_table_column_image_nullable', 1),
(63, '2024_06_08_175135_add_image_to_language_table', 1),
(64, '2024_06_30_124744_add_dark_mode_to_general_settings_table', 1),
(65, '2024_07_26_114724_create_business_modules_table', 1),
(66, '2024_07_29_105732_create_business_modules_shop_category_table', 1),
(67, '2024_07_29_114046_create_business_modules_shop_table', 1),
(68, '2024_07_31_093320_add_serial_imei_number_to_products_table', 1),
(69, '2024_08_01_094843_create_purchase_product_serial_numbers_table', 1),
(70, '2024_09_22_154751_modify_column_to_product_variants', 1),
(71, '2024_11_17_235621_update_payment_gateways_table', 1),
(72, '2024_12_03_064657_create_orange_pays_table', 1);

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

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

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

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

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

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(191) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) 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),
(2, 'App\\Models\\User', 2),
(2, 'App\\Models\\User', 3);

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

--
-- Table structure for table `money_transfers`
--

CREATE TABLE `money_transfers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `reference_no` varchar(191) NOT NULL,
  `from_account_id` int(11) NOT NULL,
  `to_account_id` int(11) NOT NULL,
  `amount` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `orange_pays`
--

CREATE TABLE `orange_pays` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `password_resets` (
  `email` varchar(191) NOT NULL,
  `token` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `purchase_id` bigint(20) UNSIGNED DEFAULT NULL,
  `sale_id` bigint(20) UNSIGNED DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `payment_reference` varchar(191) NOT NULL,
  `amount` double NOT NULL,
  `paying_method` varchar(191) NOT NULL,
  `payment_note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `payment_gateways` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `title` varchar(191) NOT NULL,
  `mode` varchar(191) NOT NULL DEFAULT 'test' COMMENT 'test or live',
  `alias` varchar(191) DEFAULT NULL COMMENT 'controller namespace',
  `config` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`config`)),
  `is_active` tinyint(1) NOT NULL DEFAULT 0,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `media_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_gateways`
--

INSERT INTO `payment_gateways` (`id`, `name`, `title`, `mode`, `alias`, `config`, `is_active`, `shop_id`, `media_id`, `created_at`, `updated_at`) VALUES
(2, 'paypal', 'PayPal', 'test', 'paypal', '{\"client_id\":\"AShCDsPwsx8ofXTVqabC3deF_Q82WS8dAz31_GT58KxYVzLX2m0iGf-Ki5NjgRKJ34bYXfLvebkq45aS\",\"client_secret\":\"EBoCw9uJSNRPVhIny1GJhyDSeOnstvXFrJRoT-mAQar8WC8e-Vl5iyAj9hqK5a5-KOYvokCEjgpVIVF3\"}', 1, NULL, NULL, NULL, '2025-08-24 16:49:31');

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

--
-- Table structure for table `payrolls`
--

CREATE TABLE `payrolls` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `date` date NOT NULL,
  `employee_id` bigint(20) UNSIGNED NOT NULL,
  `account_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `note` text DEFAULT NULL,
  `payment_method` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `guard_name` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM 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, 'root', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(2, 'dashboard', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(3, 'signout', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(4, 'subscription.index', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(5, 'subscription.store', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(6, 'subscription.status.chanage', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(7, 'subscription.update', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(8, 'subscription.report', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(9, 'payment-gateway.index', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(10, 'payment-gateway.update', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(11, 'payment-gateway.toggle', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(12, 'landing.install', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(13, 'landing.store', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(14, 'payment.method', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(15, 'payment.process', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(16, 'razorpay', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(17, 'paypal.return', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(18, 'paypal.cancel', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(19, 'paytab.success', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(20, 'paytab.callback', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(21, 'paytab.cancel', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(22, 'payment.paypal', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(23, 'payment.paypal.success', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(24, 'payment.paypal.cancel', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(25, 'shop-payment-gateway.index', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(26, 'shop-payment-gateway.update', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(27, 'shop-payment-gateway.toggle', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(28, 'shop-payment.process', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(29, 'stripe-intent-create', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(30, 'payment.notify', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(31, 'payment.success', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(32, 'payment.cancel', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(33, 'payment.initiate', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(34, 'orange.money.payment.process', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(35, 'subscription.purchase.index', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(36, 'subscription.purchase.update', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(37, 'product.index', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(38, 'product.create', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(39, 'product.store', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(40, 'product.edit', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(41, 'product.update', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(42, 'product.destroy', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(43, 'product.sale.unit', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(44, 'product.generate.code', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(45, 'product.barcode.generate', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(46, 'barcode.print', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(47, 'product.search', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(48, 'product.details', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(49, 'product.import', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(50, 'download.product.sample', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(51, 'stock.count.index', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(52, 'stock.count.store', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(53, 'purchase.index', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(54, 'purchase.create', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(55, 'purchase.store', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(56, 'purchase.edit', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(57, 'purchase.update', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(58, 'purchase.destroy', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(59, 'purchase.add.payment', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(60, 'purchase.delete.payment', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(61, 'purchase.batch', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(62, 'payment.callback', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(63, 'category.index', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(64, 'category.store', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(65, 'category.update', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(66, 'category.delete', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(67, 'category.import', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(68, 'download.category.sample', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(69, 'category.print', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(70, 'expenseCategory.index', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(71, 'expenseCategory.store', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(72, 'expenseCategory.update', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(73, 'expenseCategory.destroy', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(74, 'expenseCategory.code', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(75, 'expense.index', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(76, 'expense.store', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(77, 'expense.update', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(78, 'expense.destroy', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(79, 'account.index', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(80, 'account.store', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(81, 'account.update', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(82, 'account.update.balance', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(83, 'account.destroy', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(84, 'account.balancesheet', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(85, 'money.transfer.index', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(86, 'money.transfer.store', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(87, 'money.transfer.update', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(88, 'money.transfer.destroy', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(89, 'transection.index', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(90, 'coupon.index', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(91, 'coupon.store', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(92, 'coupon.update', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(93, 'coupon.destroy', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(94, 'coupon.apply', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(95, 'supplier.index', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(96, 'supplier.create', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(97, 'supplier.store', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(98, 'supplier.edit', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(99, 'supplier.update', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(100, 'supplier.destroy', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(101, 'supplier.import', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(102, 'download.supplier.sample', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(103, 'customer.index', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(104, 'customer.create', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(105, 'customer.store', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(106, 'customer.edit', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(107, 'customer.update', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(108, 'customer.destroy', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(109, 'customer.import', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(110, 'download.customer.sample', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(111, 'customer.search', 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10'),
(112, 'customer.add', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(113, 'profile.index', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(114, 'profile.update', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(115, 'user.password', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(116, 'sale.index', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(117, 'sale.draft', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(118, 'sale.draft.delete', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(119, 'sale.pos', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(120, 'sale.pos.store', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(121, 'sale.pos.data', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(122, 'sale.invoice.generate', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(123, 'sale.pdf.download', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(124, 'report.summary', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(125, 'report.purchases', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(126, 'purchases.print', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(127, 'report.sales', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(128, 'sale.print', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(129, 'report.product', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(130, 'product.print', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(131, 'report.expense', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(132, 'expense.print', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(133, 'report.profit.loss', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(134, 'sale.return.index', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(135, 'sale.return.search', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(136, 'sale.return.details', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(137, 'sale.return.product.store', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(138, 'role.index', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(139, 'role.store', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(140, 'role.update', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(141, 'role.permission', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(142, 'role.set.permission', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(143, 'warehouse.index', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(144, 'warehouse.store', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(145, 'warehouse.update', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(146, 'warehouse.delete', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(147, 'customer.group.index', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(148, 'customer.group.store', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(149, 'customer.group.update', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(150, 'customer.group.delete', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(151, 'brand.index', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(152, 'brand.store', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(153, 'brand.update', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(154, 'brand.delete', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(155, 'unit.index', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(156, 'unit.store', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(157, 'unit.update', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(158, 'unit.delete', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(159, 'currency.index', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(160, 'currency.store', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(161, 'currency.update', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(162, 'currency.delete', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(163, 'tax.index', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(164, 'tax.store', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(165, 'tax.update', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(166, 'tax.delete', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(167, 'settings.general', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(168, 'settings.general.store', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(169, 'settings.mail', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(170, 'settings.mail.store', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(171, 'settings.database.backup', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(172, 'settings.theme', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(173, 'settings.business.modules', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(174, 'settings.business.modules.update', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(175, 'language.index', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(176, 'language.create', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(177, 'language.store', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(178, 'language.edit', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(179, 'language.update', 'web', '2025-08-24 16:29:11', '2025-08-24 16:29:11'),
(180, 'language.delete', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(181, 'shop.category.index', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(182, 'shop.category.store', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(183, 'shop.category.update', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(184, 'shop.category.delete', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(185, 'shop.category.status.chanage', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(186, 'shop.category.business.module.update', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(187, 'shop.index', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(188, 'shop.create', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(189, 'shop.store', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(190, 'shop.update', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(191, 'shop.delete', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(192, 'shop.status.chanage', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(193, 'shop.owner.reset.password', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(194, 'shop.life.time.expire.chanage', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(195, 'shop.subscription.chanage', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(196, 'store.index', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(197, 'store.create', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(198, 'store.edit', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(199, 'store.store', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(200, 'store.update', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(201, 'store.delete', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(202, 'store.status.chanage', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(203, 'department.index', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(204, 'department.store', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(205, 'department.update', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(206, 'department.delete', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(207, 'employee.index', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(208, 'employee.create', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(209, 'employee.store', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(210, 'employee.edit', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(211, 'employee.update', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(212, 'employee.delete', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(213, 'attendance.index', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(214, 'attendance.store', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(215, 'attendance.delete', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(216, 'holiday.index', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(217, 'holiday.store', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(218, 'holiday.update', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(219, 'holiday.delete', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(220, 'payroll.index', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(221, 'payroll.store', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(222, 'payroll.update', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12'),
(223, 'payroll.delete', 'web', '2025-08-24 16:29:12', '2025-08-24 16:29:12');

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

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

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(191) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `code` varchar(191) NOT NULL,
  `type` varchar(191) NOT NULL,
  `barcode_symbology` varchar(191) NOT NULL,
  `brand_id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `unit_id` bigint(20) UNSIGNED DEFAULT NULL,
  `purchase_unit_id` int(11) DEFAULT NULL,
  `sale_unit_id` int(11) DEFAULT NULL,
  `cost` double DEFAULT NULL,
  `price` double NOT NULL,
  `qty` double DEFAULT NULL,
  `alert_quantity` double DEFAULT NULL,
  `is_promotion_price` tinyint(4) DEFAULT NULL,
  `promotion_price` double DEFAULT NULL,
  `starting_date` date DEFAULT NULL,
  `ending_date` date DEFAULT NULL,
  `tax_id` bigint(20) UNSIGNED DEFAULT NULL,
  `tax_method` varchar(191) DEFAULT NULL,
  `thumbnail_id` bigint(20) UNSIGNED DEFAULT NULL,
  `is_featured` tinyint(4) DEFAULT NULL,
  `product_details` text DEFAULT NULL,
  `product_list` varchar(191) DEFAULT NULL,
  `qty_list` varchar(191) DEFAULT NULL,
  `price_list` varchar(191) DEFAULT NULL,
  `is_batch` tinyint(4) DEFAULT NULL,
  `is_variant` tinyint(4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `serial_imei_number` varchar(191) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `products` (`id`, `shop_id`, `created_by`, `name`, `code`, `type`, `barcode_symbology`, `brand_id`, `category_id`, `unit_id`, `purchase_unit_id`, `sale_unit_id`, `cost`, `price`, `qty`, `alert_quantity`, `is_promotion_price`, `promotion_price`, `starting_date`, `ending_date`, `tax_id`, `tax_method`, `thumbnail_id`, `is_featured`, `product_details`, `product_list`, `qty_list`, `price_list`, `is_batch`, `is_variant`, `created_at`, `updated_at`, `deleted_at`, `serial_imei_number`) VALUES
(2, 1, 2, 'Kunci Mas 12x900 ml', '89928261', 'Standard', 'Code 128', 2, 3, 16, 16, 16, 220000, 226000, 198, 40, NULL, NULL, NULL, NULL, NULL, NULL, 40, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 06:25:33', '2025-12-11 17:15:22', NULL, NULL),
(3, 1, 2, 'Kunci Mas 2L', '89928262', 'Standard', 'Code 128', 3, 1, 16, 16, 16, 224000, 230000, 0, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 06:28:47', '2025-12-10 15:51:01', '2025-12-10 15:51:01', NULL),
(4, 1, 2, 'Minyak Kita 2L', '89928263', 'Standard', 'Code 128', 4, 1, 16, 16, 16, 224000, 230000, 0, 34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 06:30:40', '2025-12-11 15:32:10', '2025-12-11 15:32:10', NULL),
(5, 1, 2, 'Minyak Kita 1L', '89928264', 'Standard', 'Code 128', 5, 3, 16, 16, 16, 190000, 198000, 149, 70, NULL, NULL, NULL, NULL, NULL, NULL, 41, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 06:31:54', '2025-12-11 17:15:57', NULL, NULL),
(6, 1, 2, 'Minyak Kita 1L Refil', '89928265', 'Standard', 'Code 128', 6, 1, 16, 16, 16, 193000, 200000, 0, 50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 06:33:31', '2025-12-11 15:36:48', '2025-12-11 15:36:48', NULL),
(7, 1, 2, 'Minyak Rizki', '89928266', 'Standard', 'Code 128', 7, 3, 16, 16, 16, 189000, 196000, 130, 50, NULL, NULL, NULL, NULL, NULL, NULL, 42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 06:34:57', '2025-12-11 17:16:30', NULL, NULL),
(8, 1, 2, 'Minyak Kita Botol', '89928267', 'Standard', 'Code 128', 8, 3, 16, 16, 16, 187000, 195000, 93, 50, NULL, NULL, NULL, NULL, NULL, NULL, 43, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 06:36:27', '2025-12-11 17:16:57', NULL, NULL),
(9, 1, 2, 'Gatot Kaca', '89928269', 'Standard', 'Code 128', 11, 3, 20, 20, 20, 170000, 178000, 200, 10, NULL, NULL, NULL, NULL, NULL, NULL, 39, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 06:49:09', '2025-12-11 17:14:35', NULL, NULL),
(10, 1, 2, 'Tepung Ketan Putih', '89928219', 'Standard', 'Code 128', 9, 3, 15, 15, 15, 196000, 110000, 89, 9, NULL, NULL, NULL, NULL, NULL, NULL, 38, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 06:51:11', '2025-12-11 17:13:57', NULL, NULL),
(11, 1, 2, 'opp 5-10', '89928229', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:01:46', '2025-12-11 15:48:03', '2025-12-11 15:48:03', NULL),
(12, 1, 2, 'opp 5-13', '89928239', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:02:55', '2025-12-11 15:47:33', '2025-12-11 15:47:33', NULL),
(13, 1, 2, '0pp 6-10', '89928249', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:03:48', '2025-12-11 15:47:21', '2025-12-11 15:47:21', NULL),
(14, 1, 2, 'opp 6-13', '89928259', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:04:50', '2025-12-11 15:47:53', '2025-12-11 15:47:53', NULL),
(15, 1, 2, 'opp 7-13', '89928279', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:06:30', '2025-12-11 15:46:53', '2025-12-11 15:46:53', NULL),
(16, 1, 2, 'opp 7-15', '89928289', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:07:21', '2025-12-11 15:46:45', '2025-12-11 15:46:45', NULL),
(17, 1, 2, 'opp 7-20', '89928299', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:08:07', '2025-12-11 15:46:39', '2025-12-11 15:46:39', NULL),
(18, 1, 2, 'opp 8-13', '89928129', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:09:14', '2025-12-11 15:46:31', '2025-12-11 15:46:31', NULL),
(19, 1, 2, 'opp 8-15', '89928329', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:10:24', '2025-12-11 15:46:03', '2025-12-11 15:46:03', NULL),
(20, 1, 2, 'opp 8-20', '89928429', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:11:26', '2025-12-11 15:45:53', '2025-12-11 15:45:53', NULL),
(21, 1, 2, 'opp 9-13', '89928529', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:12:12', '2025-12-11 15:45:43', '2025-12-11 15:45:43', NULL),
(22, 1, 2, 'opp 9-15', '89928629', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:13:03', '2025-12-11 15:45:37', '2025-12-11 15:45:37', NULL),
(23, 1, 2, 'opp 9-20', '89928729', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:14:15', '2025-12-11 15:45:31', '2025-12-11 15:45:31', NULL),
(24, 1, 2, 'opp 9-25', '89928829', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:15:19', '2025-12-11 15:45:25', '2025-12-11 15:45:25', NULL),
(25, 1, 2, 'opp 10-15', '89928929', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:16:37', '2025-12-11 15:45:15', '2025-12-11 15:45:15', NULL),
(26, 1, 2, 'opp 10-17', '89921229', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:17:43', '2025-12-11 15:45:09', '2025-12-11 15:45:09', NULL),
(27, 1, 2, 'opp 10-20', '89923229', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:19:24', '2025-12-11 15:45:03', '2025-12-11 15:45:03', NULL),
(28, 1, 2, 'opp 10-25', '89924229', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 25, 10, NULL, NULL, NULL, NULL, NULL, NULL, 46, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:20:06', '2025-12-11 17:25:50', NULL, NULL),
(29, 1, 2, 'opp 16-30', '89925229', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:21:59', '2025-12-11 15:37:24', '2025-12-11 15:37:24', NULL),
(30, 1, 2, 'opp 16-25', '89926229', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:23:05', '2025-12-11 15:37:09', '2025-12-11 15:37:09', NULL),
(31, 1, 2, 'opp 8-25', '89927229', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:24:02', '2025-12-11 15:36:59', '2025-12-11 15:36:59', NULL),
(32, 1, 2, 'opp 12-25', '89929229', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:25:36', '2025-12-11 15:36:18', '2025-12-11 15:36:18', NULL),
(33, 1, 2, 'opp 13-25', '89929221', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:26:44', '2025-12-11 15:36:06', '2025-12-11 15:36:06', NULL),
(34, 1, 2, 'opp 14-25', '89929223', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:27:42', '2025-12-11 15:35:50', '2025-12-11 15:35:50', NULL),
(35, 1, 2, 'opp 15-30', '89929224', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:29:02', '2025-12-11 15:35:39', '2025-12-11 15:35:39', NULL),
(36, 1, 2, 'opp 16-25', '89929225', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:31:03', '2025-12-11 15:35:31', '2025-12-11 15:35:31', NULL),
(37, 1, 2, 'opp 20-25', '89929226', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:33:15', '2025-12-11 15:35:21', '2025-12-11 15:35:21', NULL),
(38, 1, 2, 'opp 20-30', '89929227', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:34:23', '2025-12-11 15:35:08', '2025-12-11 15:35:08', NULL),
(39, 1, 2, 'opp 23-25', '89929228', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:35:27', '2025-12-11 15:34:42', '2025-12-11 15:34:42', NULL),
(40, 1, 2, 'opp 23-30', '89919228', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:38:55', '2025-12-11 15:44:55', '2025-12-11 15:44:55', NULL),
(41, 1, 2, 'opp 23-35', '89939228', 'Standard', 'Code 128', 12, 2, 14, 14, 14, 40000, 45000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:40:04', '2025-12-11 15:33:45', '2025-12-11 15:33:45', NULL),
(42, 1, 2, 'thin wall 100ml', '89949228', 'Standard', 'Code 128', 13, 2, 13, 13, 13, 9000, 14000, 0, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:45:15', '2025-12-11 15:33:34', '2025-12-11 15:33:34', NULL),
(43, 1, 2, 'thin wall 200ml', '89959228', 'Standard', 'Code 128', 13, 2, 13, 13, 13, 10000, 17000, 0, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:46:24', '2025-12-11 15:34:32', '2025-12-11 15:34:32', NULL),
(44, 1, 2, 'thin wall 350ml', '89969228', 'Standard', 'Code 128', 13, 2, 13, 13, 13, 12000, 20000, 0, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:47:32', '2025-12-11 15:33:02', '2025-12-11 15:33:02', NULL),
(45, 1, 2, 'thin wall 500ml', '89979228', 'Standard', 'Code 128', 13, 2, 13, 13, 13, 15000, 23000, 0, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:48:31', '2025-12-11 15:32:39', '2025-12-11 15:32:39', NULL),
(46, 1, 2, 'mika S-7', '89179228', 'Standard', 'Code 128', 14, 2, 13, 13, 13, 4000, 6000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:52:04', '2025-12-11 15:32:32', '2025-12-11 15:32:32', NULL),
(47, 1, 2, 'Mika CX 3CA', '89279228', 'Standard', 'Code 128', 14, 2, 13, 13, 13, 28000, 32000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:54:22', '2025-12-10 15:50:39', '2025-12-10 15:50:39', NULL),
(48, 1, 2, 'Mika CX 4CA', '89379228', 'Standard', 'Code 128', 14, 2, 13, 13, 13, 30000, 34000, 0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:55:27', '2025-12-10 15:50:32', '2025-12-10 15:50:32', NULL),
(49, 1, 2, 'styrofoam L01', '89479228', 'Standard', 'Code 128', 15, 2, 13, 13, 13, 23000, 28000, 0, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 07:59:06', '2025-12-11 15:33:25', '2025-12-11 15:33:25', NULL),
(50, 1, 2, 'cup oz 10', '89579228', 'Standard', 'Code 128', 16, 2, 18, 18, 18, 8000, 12000, 0, 45, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 08:02:24', '2025-12-10 15:50:04', '2025-12-10 15:50:04', NULL),
(51, 1, 2, 'cup oz 12', '89679228', 'Standard', 'Code 128', 16, 2, 18, 18, 18, 8000, 12000, 0, 45, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 08:03:13', '2025-12-11 15:32:19', '2025-12-11 15:32:19', NULL),
(52, 1, 2, 'cup oz 16', '89779228', 'Standard', 'Code 128', 16, 2, 18, 18, 18, 8000, 12000, 0, 45, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 08:04:03', '2025-12-10 15:49:57', '2025-12-10 15:49:57', NULL),
(53, 1, 2, 'pelastik seal 8.7 x13', '89719228', 'Standard', 'Code 128', 17, 2, 13, 13, 13, 20000, 24000, 0, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 08:09:25', '2025-12-10 15:49:49', '2025-12-10 15:49:49', NULL),
(54, 1, 2, 'pelastik seal 7 x 10', '89729228', 'Standard', 'Code 128', 17, 2, 13, 13, 13, 18000, 22000, 0, 25, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 08:11:09', '2025-12-10 15:49:40', '2025-12-10 15:49:40', NULL),
(55, 1, 2, 'pelastik seal 8 x 12', '89739228', 'Standard', 'Code 128', 17, 2, 13, 13, 13, 28000, 35000, 47, 25, NULL, NULL, NULL, NULL, NULL, NULL, 45, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 08:12:10', '2025-12-11 17:22:40', NULL, NULL),
(56, 1, 2, 'simpang 1/4 kg', '89749228', 'Standard', 'Code 128', 18, 2, 13, 13, 13, 8000, 10000, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 08:16:46', '2025-12-10 15:49:31', '2025-12-10 15:49:31', NULL),
(57, 1, 2, 'simpang 1/2 kg', '89759228', 'Standard', 'Code 128', 18, 2, 13, 13, 13, 10000, 15000, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 08:18:05', '2025-12-10 15:50:18', '2025-12-10 15:50:18', NULL),
(58, 1, 2, 'simpang 1 kg', '89769228', 'Standard', 'Code 128', 18, 2, 13, 13, 13, 15000, 19000, 29, 30, NULL, NULL, NULL, NULL, NULL, NULL, 44, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 08:18:55', '2025-12-11 17:21:26', NULL, NULL),
(59, 1, 2, 'simpang 2 kg', '89799228', 'Standard', 'Code 128', 18, 2, 13, 13, 13, 20000, 27000, 2, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 08:20:02', '2025-12-11 15:50:22', '2025-12-11 15:50:22', NULL),
(60, 1, 2, 'paper cup', '19799228', 'Standard', 'Code 128', 19, 2, 13, 13, 13, 11000, 16000, 69, 70, NULL, NULL, NULL, NULL, NULL, NULL, 37, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 08:27:46', '2025-12-11 17:12:58', NULL, NULL),
(61, 1, 2, 'paper bowl', '29799228', 'Standard', 'Code 128', 20, 2, 13, 13, 13, 25000, 30000, 50, 40, NULL, NULL, NULL, NULL, NULL, NULL, 35, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-09-02 08:29:17', '2025-12-11 15:44:24', NULL, NULL),
(62, 1, 2, 'gelas kopi', '16543876', 'Standard', 'Code 128', 19, 2, 18, 18, 18, 31000, 30200, 28, 10, NULL, NULL, NULL, NULL, 1, 'Inclusive', 34, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-10-06 12:31:49', '2025-12-10 16:10:19', NULL, NULL),
(63, 1, 2, 'cup kopi', '13244139', 'Standard', 'Code 128', 19, 2, 18, 18, 18, 1244234, 40000, 40, 35, NULL, NULL, NULL, NULL, NULL, NULL, 33, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-10-17 10:05:48', '2025-12-11 15:43:34', NULL, NULL),
(64, 1, 2, 'fg', '12345678', 'Standard', 'Code 128', 20, 3, 14, 14, 14, 10000, 20000, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 16:01:40', '2025-12-10 16:02:18', '2025-12-10 16:02:18', NULL),
(65, 1, 2, 'gelas', '12222223', 'Standard', 'Code 128', 14, 2, 18, 18, 18, 12, 15800, 23, 30, NULL, NULL, NULL, NULL, NULL, NULL, 36, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-10 16:02:24', '2025-12-10 16:38:18', NULL, NULL);

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

--
-- Table structure for table `product_purchases`
--

CREATE TABLE `product_purchases` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `purchase_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `Variant_id` int(11) DEFAULT NULL,
  `qty` bigint(20) NOT NULL,
  `purchase_unit_id` int(11) NOT NULL,
  `net_unit_cost` double NOT NULL,
  `discount` double NOT NULL,
  `tax_rate` double DEFAULT NULL,
  `tax` double NOT NULL,
  `total` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_purchases`
--

INSERT INTO `product_purchases` (`id`, `purchase_id`, `product_id`, `Variant_id`, `qty`, `purchase_unit_id`, `net_unit_cost`, `discount`, `tax_rate`, `tax`, `total`, `created_at`, `updated_at`) VALUES
(4, 2, 61, NULL, 2, 1, 25000, 0, 12, 0, 50000, '2025-09-03 00:57:00', '2025-09-03 00:57:00'),
(5, 2, 60, NULL, 1, 1, 11000, 0, 12, 0, 11000, '2025-09-03 00:57:00', '2025-09-03 00:57:00'),
(6, 3, 59, NULL, 2, 1, 20000, 0, 12, 0, 40000, '2025-09-03 05:56:52', '2025-09-03 05:56:52'),
(7, 4, 5, NULL, 1, 1, 190000, 0, NULL, 0, 190000, '2025-10-06 12:41:09', '2025-10-06 12:41:09'),
(8, 4, 62, NULL, 10, 1, 1, 0, NULL, 3624, 36250, '2025-10-06 12:41:09', '2025-10-06 12:41:09'),
(9, 5, 62, NULL, 40, 1, 1, 0, NULL, 3624, 145000, '2025-10-06 12:47:59', '2025-10-06 12:47:59'),
(10, 6, 65, NULL, 50, 1, 12, 0, NULL, 0, 600, '2025-12-10 16:16:53', '2025-12-10 16:16:53'),
(11, 7, 63, NULL, 40, 1, 1244234, 0, NULL, 0, 49769360, '2025-12-11 15:43:34', '2025-12-11 15:43:34'),
(12, 8, 61, NULL, 48, 1, 25000, 0, NULL, 0, 1200000, '2025-12-11 15:44:24', '2025-12-11 15:44:24'),
(13, 9, 9, NULL, 200, 1, 170000, 0, NULL, 0, 34000000, '2025-12-11 15:49:59', '2025-12-11 15:49:59'),
(14, 10, 60, NULL, 68, 1, 11000, 0, NULL, 0, 748000, '2025-12-11 15:51:46', '2025-12-11 15:51:46'),
(15, 11, 58, NULL, 1, 1, 15000, 0, NULL, 0, 15000, '2025-12-11 15:52:34', '2025-12-11 15:52:34'),
(16, 12, 58, NULL, 28, 1, 15000, 0, NULL, 0, 420000, '2025-12-11 15:52:58', '2025-12-11 15:52:58'),
(17, 13, 55, NULL, 47, 1, 28000, 0, NULL, 0, 1316000, '2025-12-11 15:54:00', '2025-12-11 15:54:00'),
(18, 14, 28, NULL, 25, 1, 40000, 0, NULL, 0, 1000000, '2025-12-11 15:55:12', '2025-12-11 15:55:12'),
(19, 15, 10, NULL, 89, 1, 196000, 0, NULL, 0, 17444000, '2025-12-11 15:56:21', '2025-12-11 15:56:21'),
(20, 16, 8, NULL, 93, 1, 187000, 0, NULL, 0, 17391000, '2025-12-11 16:15:01', '2025-12-11 16:15:01'),
(21, 17, 7, NULL, 130, 1, 189000, 0, NULL, 0, 24570000, '2025-12-11 16:16:41', '2025-12-11 16:16:41'),
(22, 18, 5, NULL, 150, 1, 190000, 0, NULL, 0, 28500000, '2025-12-11 16:18:38', '2025-12-11 16:18:38'),
(23, 19, 2, NULL, 200, 1, 220000, 0, NULL, 0, 44000000, '2025-12-11 16:19:32', '2025-12-11 16:19:32');

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

--
-- Table structure for table `product_sales`
--

CREATE TABLE `product_sales` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sale_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `qty` bigint(20) NOT NULL,
  `sale_unit_id` int(11) DEFAULT NULL,
  `net_unit_price` double DEFAULT NULL,
  `discount` double DEFAULT NULL,
  `tax_rate` double DEFAULT NULL,
  `tax` double DEFAULT NULL,
  `total` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_sales`
--

INSERT INTO `product_sales` (`id`, `sale_id`, `product_id`, `variant_id`, `qty`, `sale_unit_id`, `net_unit_price`, `discount`, `tax_rate`, `tax`, `total`, `created_at`, `updated_at`) VALUES
(1, 1, 62, NULL, 16, NULL, 33824, 0, 12, 4058.88, 606126.08, '2025-10-17 10:16:09', '2025-10-17 10:16:09'),
(2, 2, 62, NULL, 1, NULL, 33824, 0, 12, 4058.88, 37882.88, '2025-10-17 10:17:09', '2025-10-17 10:17:09'),
(3, 3, 62, NULL, 5, NULL, 30200, 0, 12, 3624, 169120, '2025-12-10 16:10:19', '2025-12-10 16:10:19'),
(4, 4, 65, NULL, 3, NULL, 15800, 0, NULL, 0, 47400, '2025-12-10 16:18:22', '2025-12-10 16:18:22'),
(5, 5, 65, NULL, 3, NULL, 15800, 0, NULL, 0, 47400, '2025-12-10 16:18:40', '2025-12-10 16:18:40'),
(6, 6, 65, NULL, 3, NULL, 15800, 0, NULL, 0, 47400, '2025-12-10 16:20:18', '2025-12-10 16:20:18'),
(7, 7, 65, NULL, 3, NULL, 15800, 0, NULL, 0, 47400, '2025-12-10 16:20:19', '2025-12-10 16:20:19'),
(8, 8, 65, NULL, 3, NULL, 15800, 0, NULL, 0, 47400, '2025-12-10 16:20:34', '2025-12-10 16:20:34'),
(9, 9, 65, NULL, 2, NULL, 15800, 0, NULL, 0, 31600, '2025-12-10 16:20:48', '2025-12-10 16:20:48'),
(10, 10, 65, NULL, 3, NULL, 15800, 0, NULL, 0, 47400, '2025-12-10 16:21:32', '2025-12-10 16:21:32'),
(11, 11, 65, NULL, 2, NULL, 15800, 0, NULL, 0, 31600, '2025-12-10 16:22:30', '2025-12-10 16:22:30'),
(12, 12, 65, NULL, 2, NULL, 15800, 0, NULL, 0, 31600, '2025-12-10 16:22:58', '2025-12-10 16:22:58'),
(13, 13, 65, NULL, 2, NULL, 15800, 0, NULL, 0, 31600, '2025-12-10 16:23:55', '2025-12-10 16:23:55'),
(17, 15, 65, NULL, 1, NULL, 198000, 0, NULL, 0, 198000, '2025-12-10 16:38:18', '2025-12-10 16:38:18'),
(16, 15, 5, NULL, 2, NULL, 31600, 0, NULL, 0, 63200, '2025-12-10 16:38:18', '2025-12-10 16:38:18'),
(18, 16, 2, NULL, 2, NULL, 226000, 0, NULL, 0, 452000, '2025-12-11 16:38:12', '2025-12-11 16:38:12');

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

--
-- Table structure for table `product_variants`
--

CREATE TABLE `product_variants` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `variant_id` bigint(20) UNSIGNED NOT NULL,
  `item_code` varchar(191) NOT NULL,
  `additional_price` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_warehouse`
--

CREATE TABLE `product_warehouse` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `warehouse_id` bigint(20) UNSIGNED NOT NULL,
  `qty` bigint(20) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchases`
--

CREATE TABLE `purchases` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `reference_no` varchar(191) NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `warehouse_id` bigint(20) UNSIGNED NOT NULL,
  `supplier_id` bigint(20) UNSIGNED NOT NULL,
  `tax_id` bigint(20) UNSIGNED DEFAULT NULL,
  `item` int(11) NOT NULL,
  `total_qty` int(11) NOT NULL,
  `total_discount` double(25,2) NOT NULL,
  `total_tax` double(25,2) NOT NULL,
  `total_cost` double(25,2) NOT NULL,
  `order_tax_rate` double(25,2) DEFAULT NULL,
  `order_tax` double(25,2) DEFAULT NULL,
  `order_discount` double(25,2) DEFAULT NULL,
  `shipping_cost` double(25,2) DEFAULT NULL,
  `grand_total` double(25,2) NOT NULL,
  `paid_amount` double(25,2) DEFAULT NULL,
  `status` tinyint(1) DEFAULT NULL,
  `payment_status` tinyint(1) NOT NULL DEFAULT 0,
  `payment_method` varchar(191) DEFAULT NULL,
  `document_id` bigint(20) UNSIGNED DEFAULT NULL,
  `note` longtext DEFAULT NULL,
  `date` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `purchases`
--

INSERT INTO `purchases` (`id`, `shop_id`, `reference_no`, `created_by`, `warehouse_id`, `supplier_id`, `tax_id`, `item`, `total_qty`, `total_discount`, `total_tax`, `total_cost`, `order_tax_rate`, `order_tax`, `order_discount`, `shipping_cost`, `grand_total`, `paid_amount`, `status`, `payment_status`, `payment_method`, `document_id`, `note`, `date`, `created_at`, `updated_at`, `deleted_at`) VALUES
(2, 1, 'pr-20250903-085700', 2, 1, 1, NULL, 2, 3, 0.00, 0.00, 61000.00, 12.00, 7320.00, 0.00, 0.00, 68320.00, 68320.00, NULL, 1, 'Cash', NULL, NULL, '2025-09-03', '2025-09-03 00:57:00', '2025-09-03 00:57:00', NULL),
(3, 1, 'pr-20250903-015652', 2, 1, 1, NULL, 1, 2, 0.00, 0.00, 40000.00, 12.00, 4800.00, 0.00, 0.00, 44800.00, 44800.00, NULL, 1, 'Cash', NULL, NULL, '2025-09-03', '2025-09-03 05:56:52', '2025-09-03 05:56:52', NULL),
(4, 1, 'pr-20251006-124109', 2, 1, 1, NULL, 2, 11, 0.00, 3624.00, 226250.00, NULL, 0.00, NULL, NULL, 226250.00, 0.00, NULL, 0, 'Cash', NULL, NULL, '2025-10-06', '2025-10-06 12:41:09', '2025-10-06 12:41:09', NULL),
(5, 1, 'pr-20251006-124759', 2, 1, 1, NULL, 1, 40, 0.00, 3624.00, 145000.00, NULL, 0.00, NULL, NULL, 145000.00, 0.00, NULL, 0, NULL, NULL, NULL, '2025-10-06', '2025-10-06 12:47:59', '2025-10-06 12:47:59', NULL),
(6, 1, 'pr-20251210-041653', 2, 2, 1, NULL, 1, 50, 0.00, 0.00, 600.00, NULL, 0.00, NULL, NULL, 600.00, 0.00, NULL, 0, NULL, NULL, NULL, '2025-12-10', '2025-12-10 16:16:53', '2025-12-10 16:16:53', NULL),
(7, 1, 'pr-20251211-034334', 2, 2, 2, NULL, 1, 40, 0.00, 0.00, 49769360.00, NULL, 0.00, NULL, NULL, 49769360.00, 0.00, NULL, 0, NULL, NULL, NULL, '2025-12-11', '2025-12-11 15:43:34', '2025-12-11 15:43:34', NULL),
(8, 1, 'pr-20251211-034424', 2, 2, 2, NULL, 1, 48, 0.00, 0.00, 1200000.00, NULL, 0.00, NULL, NULL, 1200000.00, 0.00, NULL, 0, NULL, NULL, NULL, '2025-12-11', '2025-12-11 15:44:24', '2025-12-11 15:44:24', NULL),
(9, 1, 'pr-20251211-034959', 2, 1, 1, NULL, 1, 200, 0.00, 0.00, 34000000.00, NULL, 0.00, NULL, NULL, 34000000.00, 0.00, NULL, 0, NULL, NULL, NULL, '2025-12-11', '2025-12-11 15:49:59', '2025-12-11 15:49:59', NULL),
(10, 1, 'pr-20251211-035146', 2, 1, 2, NULL, 1, 68, 0.00, 0.00, 748000.00, NULL, 0.00, NULL, NULL, 748000.00, 0.00, NULL, 0, NULL, NULL, NULL, '2025-12-11', '2025-12-11 15:51:46', '2025-12-11 15:51:46', NULL),
(11, 1, 'pr-20251211-035234', 2, 1, 2, NULL, 1, 1, 0.00, 0.00, 15000.00, NULL, 0.00, NULL, NULL, 15000.00, 0.00, NULL, 0, NULL, NULL, NULL, '2025-12-11', '2025-12-11 15:52:34', '2025-12-11 15:52:34', NULL),
(12, 1, 'pr-20251211-035258', 2, 2, 2, NULL, 1, 28, 0.00, 0.00, 420000.00, NULL, 0.00, NULL, NULL, 420000.00, 0.00, NULL, 0, NULL, NULL, NULL, '2025-12-11', '2025-12-11 15:52:58', '2025-12-11 15:52:58', NULL),
(13, 1, 'pr-20251211-035400', 2, 2, 1, NULL, 1, 47, 0.00, 0.00, 1316000.00, NULL, 0.00, NULL, NULL, 1316000.00, 0.00, NULL, 0, NULL, NULL, NULL, '2025-12-11', '2025-12-11 15:54:00', '2025-12-11 15:54:00', NULL),
(14, 1, 'pr-20251211-035512', 2, 1, 2, NULL, 1, 25, 0.00, 0.00, 1000000.00, NULL, 0.00, NULL, NULL, 1000000.00, 0.00, NULL, 0, NULL, NULL, NULL, '2025-12-11', '2025-12-11 15:55:12', '2025-12-11 15:55:12', NULL),
(15, 1, 'pr-20251211-035621', 2, 2, 1, NULL, 1, 89, 0.00, 0.00, 17444000.00, NULL, 0.00, NULL, NULL, 17444000.00, 0.00, NULL, 0, NULL, NULL, NULL, '2025-12-11', '2025-12-11 15:56:21', '2025-12-11 15:56:21', NULL),
(16, 1, 'pr-20251211-041501', 2, 2, 2, NULL, 1, 93, 0.00, 0.00, 17391000.00, NULL, 0.00, NULL, NULL, 17391000.00, 0.00, NULL, 0, NULL, NULL, NULL, '2025-12-11', '2025-12-11 16:15:01', '2025-12-11 16:15:01', NULL),
(17, 1, 'pr-20251211-041641', 2, 2, 2, NULL, 1, 130, 0.00, 0.00, 24570000.00, NULL, 0.00, NULL, NULL, 24570000.00, 0.00, NULL, 0, NULL, NULL, NULL, '2025-12-11', '2025-12-11 16:16:41', '2025-12-11 16:16:41', NULL),
(18, 1, 'pr-20251211-041838', 2, 1, 1, NULL, 1, 150, 0.00, 0.00, 28500000.00, NULL, 0.00, NULL, NULL, 28500000.00, 0.00, NULL, 0, NULL, NULL, NULL, '2025-12-11', '2025-12-11 16:18:38', '2025-12-11 16:18:38', NULL),
(19, 1, 'pr-20251211-041932', 2, 2, 2, NULL, 1, 200, 0.00, 0.00, 44000000.00, NULL, 0.00, NULL, NULL, 44000000.00, 0.00, NULL, 0, NULL, NULL, NULL, '2025-12-11', '2025-12-11 16:19:32', '2025-12-11 16:19:32', NULL);

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

--
-- Table structure for table `purchase_batches`
--

CREATE TABLE `purchase_batches` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `purchase_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `qty` int(11) NOT NULL,
  `sale_qty` int(11) NOT NULL,
  `expire_date` date DEFAULT NULL,
  `purchase_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `purchase_product_serial_numbers`
--

CREATE TABLE `purchase_product_serial_numbers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `purchase_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `serial_number` varchar(191) NOT NULL,
  `selling_status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `recovery_password_codes`
--

CREATE TABLE `recovery_password_codes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `email` varchar(191) NOT NULL,
  `code` bigint(20) NOT NULL,
  `token` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` longtext DEFAULT NULL,
  `guard_name` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `description`, `guard_name`, `created_at`, `updated_at`, `shop_id`, `created_by`) VALUES
(1, 'super admin', NULL, 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10', NULL, NULL),
(2, 'admin', NULL, 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10', NULL, NULL),
(3, 'owner', NULL, 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10', NULL, NULL),
(4, 'store', NULL, 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10', NULL, NULL),
(5, 'customer', NULL, 'web', '2025-08-24 16:29:10', '2025-08-24 16:29:10', NULL, NULL);

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

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

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=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, 2),
(1, 4),
(1, 5),
(2, 1),
(3, 1),
(3, 2),
(3, 4),
(3, 5),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(8, 2),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 2),
(15, 2),
(16, 2),
(17, 2),
(18, 2),
(19, 2),
(20, 2),
(21, 2),
(22, 2),
(23, 2),
(24, 2),
(25, 2),
(26, 2),
(27, 2),
(28, 2),
(29, 2),
(30, 2),
(31, 2),
(32, 2),
(33, 2),
(34, 2),
(35, 2),
(36, 2),
(37, 2),
(38, 2),
(39, 2),
(40, 2),
(41, 2),
(42, 2),
(43, 2),
(44, 2),
(45, 2),
(46, 2),
(47, 2),
(47, 4),
(48, 2),
(48, 4),
(49, 2),
(50, 2),
(51, 2),
(52, 2),
(53, 2),
(54, 2),
(55, 2),
(56, 2),
(57, 2),
(58, 2),
(59, 2),
(60, 2),
(61, 2),
(62, 2),
(63, 2),
(64, 2),
(65, 2),
(66, 2),
(67, 2),
(68, 2),
(69, 2),
(70, 2),
(71, 2),
(72, 2),
(73, 2),
(74, 2),
(75, 2),
(76, 2),
(77, 2),
(78, 2),
(79, 2),
(80, 2),
(81, 2),
(82, 2),
(83, 2),
(84, 2),
(85, 2),
(86, 2),
(87, 2),
(88, 2),
(89, 2),
(90, 2),
(91, 2),
(92, 2),
(93, 2),
(94, 2),
(94, 4),
(95, 2),
(96, 2),
(97, 2),
(98, 2),
(99, 2),
(100, 2),
(101, 2),
(102, 2),
(103, 2),
(104, 2),
(105, 2),
(106, 2),
(107, 2),
(108, 2),
(109, 2),
(110, 2),
(111, 2),
(111, 4),
(112, 2),
(112, 4),
(113, 1),
(113, 2),
(113, 4),
(114, 1),
(114, 2),
(114, 4),
(115, 1),
(115, 2),
(115, 4),
(116, 2),
(116, 4),
(117, 2),
(117, 4),
(118, 2),
(118, 4),
(119, 2),
(119, 4),
(120, 2),
(120, 4),
(121, 2),
(121, 4),
(122, 2),
(122, 4),
(123, 2),
(123, 4),
(124, 2),
(125, 2),
(126, 2),
(127, 2),
(128, 2),
(129, 2),
(130, 2),
(131, 2),
(132, 2),
(133, 2),
(134, 2),
(135, 2),
(136, 2),
(137, 2),
(138, 2),
(139, 2),
(140, 2),
(141, 2),
(142, 2),
(143, 2),
(144, 2),
(145, 2),
(146, 2),
(147, 2),
(148, 2),
(149, 2),
(150, 2),
(151, 2),
(152, 2),
(153, 2),
(154, 2),
(155, 2),
(156, 2),
(157, 2),
(158, 2),
(159, 1),
(159, 2),
(160, 1),
(160, 2),
(161, 1),
(161, 2),
(162, 1),
(162, 2),
(163, 2),
(164, 2),
(165, 2),
(166, 2),
(167, 1),
(167, 2),
(168, 1),
(168, 2),
(169, 1),
(170, 1),
(171, 1),
(172, 1),
(172, 2),
(173, 2),
(174, 2),
(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, 2),
(197, 2),
(198, 2),
(199, 2),
(200, 2),
(201, 2),
(202, 2),
(203, 2),
(204, 2),
(205, 2),
(206, 2),
(207, 2),
(208, 2),
(209, 2),
(210, 2),
(211, 2),
(212, 2),
(213, 2),
(214, 2),
(215, 2),
(216, 2),
(217, 2),
(218, 2),
(219, 2),
(220, 2),
(221, 2),
(222, 2),
(223, 2);

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

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

CREATE TABLE `sales` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `reference_no` varchar(191) NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `warehouse_id` bigint(20) UNSIGNED DEFAULT NULL,
  `item` int(11) NOT NULL,
  `total_qty` double NOT NULL,
  `total_discount` double NOT NULL,
  `total_tax` double NOT NULL,
  `total_price` double NOT NULL,
  `grand_total` double NOT NULL,
  `order_tax_rate` double DEFAULT NULL,
  `order_tax` double DEFAULT NULL,
  `order_discount` double DEFAULT NULL,
  `coupon_id` int(11) DEFAULT NULL,
  `coupon_discount` double DEFAULT NULL,
  `shipping_cost` double DEFAULT NULL,
  `sale_status` int(11) NOT NULL,
  `payment_status` int(11) NOT NULL,
  `document_id` bigint(20) UNSIGNED DEFAULT NULL,
  `paid_amount` double DEFAULT NULL,
  `sale_note` text DEFAULT NULL,
  `staff_note` text DEFAULT NULL,
  `type` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `payment_method` varchar(191) NOT NULL DEFAULT 'Cash'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `sales` (`id`, `shop_id`, `reference_no`, `created_by`, `customer_id`, `warehouse_id`, `item`, `total_qty`, `total_discount`, `total_tax`, `total_price`, `grand_total`, `order_tax_rate`, `order_tax`, `order_discount`, `coupon_id`, `coupon_discount`, `shipping_cost`, `sale_status`, `payment_status`, `document_id`, `paid_amount`, `sale_note`, `staff_note`, `type`, `created_at`, `updated_at`, `payment_method`) VALUES
(1, 1, 'posr-20251017-101609', 2, NULL, NULL, 1, 1, 0, 64942.08, 606126.08, 606126.08, NULL, 0, 0, NULL, 0, NULL, 1, 3, NULL, 541184, NULL, NULL, 'Sales', '2025-10-17 10:16:09', '2025-10-17 10:16:09', 'Cash'),
(2, 1, 'posr-20251017-101709', 2, NULL, NULL, 1, 1, 0, 4058.88, 37882.88, 37882.88, NULL, 0, 0, NULL, 0, NULL, 1, 3, NULL, 33824, NULL, NULL, 'Sales', '2025-10-17 10:17:09', '2025-10-17 10:17:09', 'Cash'),
(3, 1, 'posr-20251210-041019', 2, NULL, NULL, 1, 1, 0, 18120, 169120, 169120, NULL, 0, 0, NULL, 0, NULL, 1, 3, NULL, 169120, NULL, NULL, 'Sales', '2025-12-10 16:10:19', '2025-12-10 16:10:19', 'cash'),
(4, 1, 'posr-20251210-041822', 2, NULL, NULL, 1, 1, 0, 0, 47400, 47400, NULL, 0, 0, NULL, 0, NULL, 1, 3, NULL, 47400, NULL, NULL, 'Sales', '2025-12-10 16:18:22', '2025-12-10 16:18:22', 'Cash'),
(5, 1, 'posr-20251210-041840', 2, NULL, NULL, 1, 1, 0, 0, 47400, 47400, NULL, 0, 0, NULL, 0, NULL, 1, 3, NULL, 47400, NULL, NULL, 'Sales', '2025-12-10 16:18:40', '2025-12-10 16:18:40', 'Cash'),
(6, 1, 'posr-20251210-042018', 2, NULL, NULL, 1, 1, 0, 0, 47400, 47400, NULL, 0, 0, NULL, 0, NULL, 1, 3, NULL, 47400, NULL, NULL, 'Sales', '2025-12-10 16:20:18', '2025-12-10 16:20:18', 'Cash'),
(7, 1, 'posr-20251210-042019', 2, NULL, NULL, 1, 1, 0, 0, 47400, 47400, NULL, 0, 0, NULL, 0, NULL, 1, 3, NULL, 47400, NULL, NULL, 'Sales', '2025-12-10 16:20:19', '2025-12-10 16:20:19', 'Cash'),
(8, 1, 'posr-20251210-042034', 2, NULL, NULL, 1, 1, 0, 0, 47400, 47400, NULL, 0, 0, NULL, 0, NULL, 1, 3, NULL, 47400, NULL, NULL, 'Sales', '2025-12-10 16:20:34', '2025-12-10 16:20:34', 'Cash'),
(9, 1, 'posr-20251210-042048', 2, NULL, NULL, 1, 1, 0, 0, 31600, 31600, NULL, 0, 0, NULL, 0, NULL, 1, 3, NULL, 31600, NULL, NULL, 'Sales', '2025-12-10 16:20:48', '2025-12-10 16:20:48', 'Cash'),
(10, 1, 'posr-20251210-042132', 2, NULL, NULL, 1, 1, 0, 0, 47400, 47400, NULL, 0, 0, NULL, 0, NULL, 1, 3, NULL, 47400, NULL, NULL, 'Sales', '2025-12-10 16:21:32', '2025-12-10 16:21:32', 'Cash'),
(11, 1, 'posr-20251210-042230', 2, NULL, NULL, 1, 1, 0, 0, 31600, 31600, NULL, 0, 0, NULL, 0, NULL, 1, 3, NULL, 31600, NULL, NULL, 'Sales', '2025-12-10 16:22:30', '2025-12-10 16:22:30', 'Cash'),
(12, 1, 'posr-20251210-042258', 2, NULL, NULL, 1, 1, 0, 0, 31600, 31600, NULL, 0, 0, NULL, 0, NULL, 1, 3, NULL, 31600, NULL, NULL, 'Sales', '2025-12-10 16:22:58', '2025-12-10 16:22:58', 'Cash'),
(13, 1, 'posr-20251210-042355', 2, NULL, NULL, 1, 1, 0, 0, 31600, 31600, NULL, 0, 0, NULL, 0, NULL, 1, 3, NULL, 31600, NULL, NULL, 'Sales', '2025-12-10 16:23:55', '2025-12-10 16:23:55', 'Cash'),
(15, 1, 'posr-20251210-043818', 2, NULL, NULL, 2, 2, 0, 0, 261200, 261200, NULL, 0, 0, NULL, 0, NULL, 1, 3, NULL, 261200, NULL, NULL, 'Sales', '2025-12-10 16:38:18', '2025-12-10 16:38:18', 'Cash'),
(16, 1, 'posr-20251211-043812', 2, NULL, NULL, 1, 1, 0, 0, 452000, 452000, NULL, 0, 0, NULL, 0, NULL, 1, 3, NULL, 452000, NULL, NULL, 'Sales', '2025-12-11 16:38:12', '2025-12-11 16:38:12', 'Cash');

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

--
-- Table structure for table `sale_returns`
--

CREATE TABLE `sale_returns` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `reference_no` varchar(191) NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `item` int(11) NOT NULL,
  `total_qty` double NOT NULL,
  `total_discount` double NOT NULL,
  `total_tax` double NOT NULL,
  `total_price` double NOT NULL,
  `grand_total` double NOT NULL,
  `order_tax_rate` double DEFAULT NULL,
  `sale_note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sale_return_products`
--

CREATE TABLE `sale_return_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sale_return_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `qty` bigint(20) NOT NULL,
  `sale_unit_id` int(11) DEFAULT NULL,
  `net_unit_price` double DEFAULT NULL,
  `discount` double DEFAULT NULL,
  `tax_rate` double DEFAULT NULL,
  `tax` double DEFAULT NULL,
  `total` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `shops`
--

CREATE TABLE `shops` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `shop_category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `status` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_lifetime` tinyint(1) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shops`
--

INSERT INTO `shops` (`id`, `user_id`, `shop_category_id`, `name`, `status`, `created_at`, `updated_at`, `is_lifetime`, `deleted_at`) VALUES
(1, 2, 2, 'Rafif Shop', 'Active', '2025-08-24 17:08:16', '2025-08-24 17:36:11', 1, NULL);

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

--
-- Table structure for table `shop_categories`
--

CREATE TABLE `shop_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `primary_color` varchar(191) NOT NULL,
  `secondary_color` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `status` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shop_categories`
--

INSERT INTO `shop_categories` (`id`, `created_by`, `name`, `primary_color`, `secondary_color`, `description`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'Restaurant', '#000000', '#000000', NULL, 'Active', '2025-08-24 17:01:18', '2025-08-24 17:01:18', NULL),
(2, 1, 'Minimarket', '#000000', '#02c2f2', NULL, 'Active', '2025-08-24 17:01:48', '2025-09-01 02:14:51', NULL),
(3, 1, 'Retail Store', '#000000', '#000000', NULL, 'Active', '2025-08-24 17:03:37', '2025-08-24 17:03:37', NULL),
(4, 1, 'Pharmacy', '#000000', '#000000', NULL, 'Active', '2025-08-24 17:06:03', '2025-08-24 17:06:03', NULL),
(5, 1, 'Service', '#000000', '#000000', NULL, 'Active', '2025-08-24 17:06:25', '2025-08-24 17:06:25', NULL);

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

--
-- Table structure for table `shop_subscriptions`
--

CREATE TABLE `shop_subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED NOT NULL,
  `subscription_id` bigint(20) UNSIGNED NOT NULL,
  `is_current` varchar(191) NOT NULL,
  `payment_gateway` varchar(191) DEFAULT NULL,
  `expired_at` date DEFAULT NULL,
  `payment_status` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `shop_users`
--

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

--
-- Dumping data for table `shop_users`
--

INSERT INTO `shop_users` (`id`, `user_id`, `shop_id`, `created_at`, `updated_at`) VALUES
(1, 2, 1, NULL, NULL);

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

--
-- Table structure for table `stock_counts`
--

CREATE TABLE `stock_counts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `reference_no` varchar(191) NOT NULL,
  `warehouse_id` bigint(20) UNSIGNED NOT NULL,
  `category_id` varchar(191) DEFAULT NULL,
  `brand_id` varchar(191) DEFAULT NULL,
  `type` varchar(191) NOT NULL,
  `initial_file` varchar(191) DEFAULT NULL,
  `final_file` varchar(191) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `is_adjusted` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `stock_counts`
--

INSERT INTO `stock_counts` (`id`, `shop_id`, `created_by`, `reference_no`, `warehouse_id`, `category_id`, `brand_id`, `type`, `initial_file`, `final_file`, `note`, `is_adjusted`, `created_at`, `updated_at`) VALUES
(1, 1, 2, 'scr-2025-09-01 11:33:32', 1, '[\"1\"]', '[\"1\"]', 'partial', '2025-09-01 11:33:32.csv', NULL, NULL, 0, '2025-09-01 03:33:32', '2025-09-01 03:33:32'),
(2, 1, 2, 'scr-2025-10-06 12:39:19', 1, NULL, NULL, 'full', '2025-10-06 12:39:19.csv', NULL, NULL, 0, '2025-10-06 12:39:19', '2025-10-06 12:39:19');

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

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

CREATE TABLE `stores` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED NOT NULL,
  `created_by` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` longtext DEFAULT NULL,
  `email` varchar(191) NOT NULL,
  `phone_number` varchar(191) DEFAULT NULL,
  `address` varchar(191) NOT NULL,
  `city` varchar(191) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `postal_code` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `status` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `price` double(8,2) NOT NULL,
  `description` longtext DEFAULT NULL,
  `shop_limit` int(11) NOT NULL,
  `product_limit` int(11) NOT NULL,
  `recurring_type` varchar(191) NOT NULL,
  `status` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--

INSERT INTO `subscriptions` (`id`, `title`, `price`, `description`, `shop_limit`, `product_limit`, `recurring_type`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Trail', 0.00, 'Langganan POS Mingguan memberikan fleksibilitas bagi pemilik usaha untuk menikmati fitur lengkap sistem Point of Sale tanpa komitmen jangka panjang. Dengan paket ini, Anda bisa mengelola penjualan, stok, dan laporan secara mudah serta praktis hanya dalam satu minggu penggunaan. Cocok bagi yang ingin mencoba layanan terlebih dahulu sebelum beralih ke paket bulanan atau tahunan, langganan mingguan hadir dengan biaya terjangkau dan dapat diperpanjang sesuai kebutuhan bisnis.', 1, 5, 'Weekly', 'Inactive', '2025-08-24 16:29:13', '2025-09-02 22:11:50'),
(2, 'Basic', 49999.99, 'Langganan POS 1 Bulan memungkinkan Anda menikmati seluruh fitur Point of Sale secara penuh selama 30 hari, mulai dari pencatatan penjualan, pengelolaan stok, laporan keuangan, hingga analisis bisnis. Paket ini cocok untuk pemilik usaha yang membutuhkan solusi stabil dengan biaya terjangkau, tanpa harus berkomitmen jangka panjang. Dengan fleksibilitas perpanjangan setiap bulan, Anda dapat menyesuaikan kebutuhan bisnis sekaligus memastikan operasional tetap berjalan lancar.', 2, 25, 'Monthly', 'Inactive', '2025-08-24 16:29:13', '2025-09-02 22:11:50'),
(3, 'Premium', 99999.99, 'Langganan POS 1 Tahun menawarkan solusi terbaik bagi pemilik usaha yang menginginkan sistem kasir digital dengan akses penuh selama 12 bulan penuh. Dengan paket tahunan, Anda bisa menikmati semua fitur premium mulai dari pencatatan penjualan, manajemen stok, laporan keuangan, hingga analisis bisnis secara lebih efisien. Selain lebih hemat dibandingkan paket bulanan, langganan ini juga memberikan stabilitas jangka panjang sehingga Anda tidak perlu khawatir memperpanjang layanan setiap saat, menjadikannya pilihan tepat untuk mendukung pertumbuhan bisnis secara berkelanjutan.', 5, 50, 'Yearly', 'Inactive', '2025-08-24 16:29:13', '2025-09-02 22:11:52');

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

--
-- Table structure for table `subscription_requests`
--

CREATE TABLE `subscription_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `subscription_id` bigint(20) UNSIGNED NOT NULL,
  `payment_gateway` varchar(191) DEFAULT NULL,
  `payment_status` varchar(191) NOT NULL,
  `status` varchar(191) NOT NULL,
  `transaction_id` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `suppliers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `thumbnail_id` bigint(20) UNSIGNED DEFAULT NULL,
  `company_name` varchar(191) NOT NULL,
  `vat_number` varchar(191) DEFAULT NULL,
  `email` varchar(191) NOT NULL,
  `phone_number` varchar(191) NOT NULL,
  `address` varchar(191) NOT NULL,
  `city` varchar(191) NOT NULL,
  `state` varchar(191) DEFAULT NULL,
  `postal_code` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `suppliers`
--

INSERT INTO `suppliers` (`id`, `shop_id`, `created_by`, `name`, `thumbnail_id`, `company_name`, `vat_number`, `email`, `phone_number`, `address`, `city`, `state`, `postal_code`, `country`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 2, 'Ismayani', NULL, 'PT. Sembako Jaya', NULL, 'ismayani@gmail.com', '08786550322', 'Jl. Raya mataram', 'Mataram', 'Nusa Tenggara Barat', '83111', 'Indonesia', '2025-09-01 03:45:03', '2025-09-01 03:45:03', NULL),
(2, 1, 2, 'dimas', NULL, 'PT. Garuda food', NULL, 'dimas123@gmail.com', '08746524536', 'ampenan, samping pasar kebon roek', 'Mataram', NULL, '83242', NULL, '2025-12-11 15:42:37', '2025-12-11 15:42:37', NULL);

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

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

CREATE TABLE `taxes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `rate` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `taxes`
--

INSERT INTO `taxes` (`id`, `shop_id`, `created_by`, `name`, `rate`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 2, 'PPN', 12, '2025-09-01 03:35:43', '2025-09-01 03:35:43', NULL);

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

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

CREATE TABLE `transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `purpose` varchar(191) DEFAULT NULL,
  `payment_method` varchar(191) NOT NULL,
  `transection_type` varchar(191) NOT NULL,
  `amount` varchar(191) NOT NULL,
  `date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `transactions` (`id`, `shop_id`, `user_id`, `account_id`, `purpose`, `payment_method`, `transection_type`, `amount`, `date`, `created_at`, `updated_at`) VALUES
(5, 1, 2, NULL, 'Purchased 1 new products', 'Cash', 'Debit', '44800', '2025-09-03', '2025-09-03 05:56:52', '2025-09-03 05:56:52'),
(4, 1, 2, NULL, 'Purchased 2 new products', 'Cash', 'Debit', '68320', '2025-09-03', '2025-09-03 00:57:00', '2025-09-03 00:57:00'),
(6, 1, 2, NULL, NULL, 'Cash', 'Credit', '3', '2025-12-10', '2025-12-10 16:21:26', '2025-12-10 16:21:26'),
(7, 1, 2, NULL, NULL, 'Cash', 'Credit', '800000', '2025-12-10', '2025-12-10 16:22:16', '2025-12-10 16:22:16');

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

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

CREATE TABLE `units` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `code` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `base_unit_id` bigint(20) UNSIGNED DEFAULT NULL,
  `operator` varchar(191) DEFAULT NULL,
  `operation_value` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `units` (`id`, `shop_id`, `created_by`, `code`, `name`, `base_unit_id`, `operator`, `operation_value`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 2, 'UNIT01', 'Piece', 1, 'Minimal 1 Buah', 1, '2025-09-01 03:10:26', '2025-09-02 05:29:59', '2025-09-02 05:29:59'),
(2, 1, 2, 'UNIT02', 'Kilograms', 2, 'Minimum 1 Kilograms', 10, '2025-09-01 03:11:46', '2025-09-02 05:28:01', '2025-09-02 05:28:01'),
(3, 1, 2, 'UNIT03', 'Grams', 3, NULL, NULL, '2025-09-01 03:12:48', '2025-09-02 05:28:10', '2025-09-02 05:28:10'),
(4, 1, 2, 'UNIT04', 'Kg', 4, NULL, NULL, '2025-09-01 03:14:41', '2025-09-02 05:34:31', '2025-09-02 05:34:31'),
(5, 1, 2, 'UNIT05', 'Dus', 5, NULL, NULL, '2025-09-01 05:16:06', '2025-09-02 05:34:24', '2025-09-02 05:34:24'),
(6, 1, 2, 'UNIT06', 'BUNGKUS', NULL, NULL, NULL, '2025-09-01 05:17:19', '2025-09-01 05:17:35', '2025-09-01 05:17:35'),
(7, 1, 2, 'UNIT06', 'BUNGKUS', NULL, NULL, NULL, '2025-09-01 05:17:58', '2025-09-02 05:28:18', '2025-09-02 05:28:18'),
(9, 1, 2, 'UNIT01', 'Botol', NULL, NULL, NULL, '2025-09-02 05:32:42', '2025-09-02 05:34:09', '2025-09-02 05:34:09'),
(8, 1, 2, 'UNIT02', 'Bungkus', NULL, NULL, NULL, '2025-09-02 05:31:31', '2025-09-02 05:34:17', '2025-09-02 05:34:17'),
(10, 1, 2, 'UNIT03', 'Pack', NULL, NULL, NULL, '2025-09-02 05:33:11', '2025-09-02 05:33:27', '2025-09-02 05:33:27'),
(11, 1, 2, 'UNIT03', 'Pack', NULL, NULL, NULL, '2025-09-02 05:33:52', '2025-09-02 05:34:03', '2025-09-02 05:34:03'),
(12, 1, 2, 'UNIT01', 'Bungkus', 12, NULL, NULL, '2025-09-02 05:34:46', '2025-09-03 00:09:24', NULL),
(13, 1, 2, 'UNIT02', 'Pack', 13, NULL, NULL, '2025-09-02 05:35:09', '2025-09-03 00:09:15', NULL),
(14, 1, 2, 'UNIT03', 'Kg', 14, NULL, NULL, '2025-09-02 05:35:24', '2025-09-03 00:09:07', NULL),
(15, 1, 2, 'UNIT04', 'Piece', 15, NULL, NULL, '2025-09-02 05:36:11', '2025-09-03 00:08:59', NULL),
(16, 1, 2, 'UNIT05', 'Dus', 16, NULL, NULL, '2025-09-02 05:36:49', '2025-09-03 00:08:49', NULL),
(17, 1, 2, 'UNIT06', 'Botol', 17, NULL, NULL, '2025-09-02 05:37:20', '2025-09-03 00:08:40', NULL),
(18, 1, 2, 'UNIT07', 'Slop', 18, NULL, NULL, '2025-09-02 05:37:38', '2025-09-03 00:08:31', NULL),
(19, 1, 2, 'UNIT08', 'Butir/Biji', 19, NULL, NULL, '2025-09-02 05:38:02', '2025-09-03 00:08:20', NULL),
(20, 1, 2, 'UNIT09', 'Karung', 20, NULL, NULL, '2025-09-02 06:47:53', '2025-09-03 00:07:40', NULL);

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `password` varchar(191) NOT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `thumbnail_id` bigint(20) UNSIGNED DEFAULT NULL,
  `email_verified_at` datetime DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `email`, `password`, `phone`, `thumbnail_id`, `email_verified_at`, `remember_token`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Super Admin', 'team@kodetr.com', '$2y$10$T5HF1oOfYNJqBEyR5r6BUuRJz65FVMjocCxLmIaFQU0hFpA4dvrHa', '085156350839', 4, '2025-08-24 23:30:22', 'mnVkBxdFHAB7GLFAnbRlHuK5ktH3iWnuiGISiB0DAgoYaH44rPBUsWxcsvnC', '2025-08-24 16:30:22', '2025-08-24 16:59:44', NULL),
(2, 'Ridho Haries Hidayat', 'mridhoharieshidayat@gmail.com', '$2y$10$i9Gxe/d1rgdvrAFHC2wgSOKCAiiBQGoVEt/Nj6KyTNLxNdHdR0RCG', '085955295041', NULL, '2025-08-25 00:10:57', NULL, '2025-08-24 17:08:16', '2025-12-07 19:39:56', NULL);

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

--
-- Table structure for table `variants`
--

CREATE TABLE `variants` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `wallets`
--

CREATE TABLE `wallets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `account_id` bigint(20) UNSIGNED DEFAULT NULL,
  `balance` double NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wallets`
--

INSERT INTO `wallets` (`id`, `user_id`, `account_id`, `balance`, `created_at`, `updated_at`) VALUES
(1, 2, NULL, 1366725.96, '2025-10-17 10:16:09', '2025-12-11 16:38:12');

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

--
-- Table structure for table `warehouses`
--

CREATE TABLE `warehouses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shop_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `address` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `warehouses`
--

INSERT INTO `warehouses` (`id`, `shop_id`, `created_by`, `name`, `phone`, `email`, `address`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 2, 'Julian', '085955295042', 'julian@gmail.com', 'Jl. Raya mataram', '2025-09-01 03:18:56', '2025-09-01 03:18:56', NULL),
(2, 1, 2, 'Yuris', '085955295041', 'srcyuris@gmail.com', 'kp.kebonlauq, Masbagik selatan, lombok timur', '2025-10-06 12:46:46', '2025-10-06 12:46:46', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accounts`
--
ALTER TABLE `accounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `accounts_shop_id_foreign` (`shop_id`),
  ADD KEY `accounts_created_by_foreign` (`created_by`);

--
-- Indexes for table `attendances`
--
ALTER TABLE `attendances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `attendances_shop_id_foreign` (`shop_id`),
  ADD KEY `attendances_employee_id_foreign` (`employee_id`),
  ADD KEY `attendances_created_by_foreign` (`created_by`);

--
-- Indexes for table `brands`
--
ALTER TABLE `brands`
  ADD PRIMARY KEY (`id`),
  ADD KEY `brands_shop_id_foreign` (`shop_id`),
  ADD KEY `brands_created_by_foreign` (`created_by`),
  ADD KEY `brands_thumbnail_id_foreign` (`thumbnail_id`);

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

--
-- Indexes for table `business_modules_shop`
--
ALTER TABLE `business_modules_shop`
  ADD PRIMARY KEY (`id`),
  ADD KEY `business_modules_shop_business_modules_id_foreign` (`business_modules_id`),
  ADD KEY `business_modules_shop_shop_id_foreign` (`shop_id`);

--
-- Indexes for table `business_modules_shop_category`
--
ALTER TABLE `business_modules_shop_category`
  ADD PRIMARY KEY (`id`),
  ADD KEY `business_modules_shop_category_business_modules_id_foreign` (`business_modules_id`),
  ADD KEY `business_modules_shop_category_shop_category_id_foreign` (`shop_category_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `categories_shop_id_foreign` (`shop_id`),
  ADD KEY `categories_created_by_foreign` (`created_by`),
  ADD KEY `categories_thumbnail_id_foreign` (`thumbnail_id`),
  ADD KEY `categories_parent_id_foreign` (`parent_id`);

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`),
  ADD KEY `coupons_shop_id_foreign` (`shop_id`),
  ADD KEY `coupons_created_by_foreign` (`created_by`);

--
-- Indexes for table `currencies`
--
ALTER TABLE `currencies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `currencies_shop_id_foreign` (`shop_id`),
  ADD KEY `currencies_created_by_foreign` (`created_by`);

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customers_shop_id_foreign` (`shop_id`),
  ADD KEY `customers_created_by_foreign` (`created_by`),
  ADD KEY `customers_customer_group_id_foreign` (`customer_group_id`);

--
-- Indexes for table `customer_groups`
--
ALTER TABLE `customer_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_groups_shop_id_foreign` (`shop_id`),
  ADD KEY `customer_groups_created_by_foreign` (`created_by`);

--
-- Indexes for table `departments`
--
ALTER TABLE `departments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `departments_shop_id_foreign` (`shop_id`),
  ADD KEY `departments_created_by_foreign` (`created_by`);

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

--
-- Indexes for table `employees`
--
ALTER TABLE `employees`
  ADD PRIMARY KEY (`id`),
  ADD KEY `employees_shop_id_foreign` (`shop_id`),
  ADD KEY `employees_created_by_foreign` (`created_by`),
  ADD KEY `employees_user_id_foreign` (`user_id`),
  ADD KEY `employees_department_id_foreign` (`department_id`);

--
-- Indexes for table `expenses`
--
ALTER TABLE `expenses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `expenses_shop_id_foreign` (`shop_id`),
  ADD KEY `expenses_created_by_foreign` (`created_by`),
  ADD KEY `expenses_expense_category_id_foreign` (`expense_category_id`),
  ADD KEY `expenses_warehouse_id_foreign` (`warehouse_id`),
  ADD KEY `expenses_account_id_foreign` (`account_id`);

--
-- Indexes for table `expense_categories`
--
ALTER TABLE `expense_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `expense_categories_shop_id_foreign` (`shop_id`),
  ADD KEY `expense_categories_created_by_foreign` (`created_by`);

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

--
-- Indexes for table `general_settings`
--
ALTER TABLE `general_settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `general_settings_shop_id_foreign` (`shop_id`),
  ADD KEY `general_settings_logo_id_foreign` (`logo_id`),
  ADD KEY `general_settings_small_logo_id_foreign` (`small_logo_id`),
  ADD KEY `general_settings_fav_id_foreign` (`fav_id`),
  ADD KEY `general_settings_currency_id_foreign` (`currency_id`);

--
-- Indexes for table `holidays`
--
ALTER TABLE `holidays`
  ADD PRIMARY KEY (`id`),
  ADD KEY `holidays_created_by_foreign` (`created_by`),
  ADD KEY `holidays_shop_id_foreign` (`shop_id`);

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `languages_thumbnail_id_foreign` (`thumbnail_id`);

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

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

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

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

--
-- Indexes for table `money_transfers`
--
ALTER TABLE `money_transfers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `money_transfers_shop_id_foreign` (`shop_id`),
  ADD KEY `money_transfers_created_by_foreign` (`created_by`);

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

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

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payments_purchase_id_foreign` (`purchase_id`),
  ADD KEY `payments_sale_id_foreign` (`sale_id`),
  ADD KEY `payments_account_id_foreign` (`account_id`),
  ADD KEY `payments_user_id_foreign` (`user_id`);

--
-- Indexes for table `payment_gateways`
--
ALTER TABLE `payment_gateways`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payment_gateways_media_id_foreign` (`media_id`);

--
-- Indexes for table `payrolls`
--
ALTER TABLE `payrolls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payrolls_created_by_foreign` (`created_by`),
  ADD KEY `payrolls_shop_id_foreign` (`shop_id`),
  ADD KEY `payrolls_employee_id_foreign` (`employee_id`),
  ADD KEY `payrolls_account_id_foreign` (`account_id`);

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

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_shop_id_foreign` (`shop_id`),
  ADD KEY `products_created_by_foreign` (`created_by`),
  ADD KEY `products_brand_id_foreign` (`brand_id`),
  ADD KEY `products_category_id_foreign` (`category_id`),
  ADD KEY `products_unit_id_foreign` (`unit_id`),
  ADD KEY `products_tax_id_foreign` (`tax_id`),
  ADD KEY `products_thumbnail_id_foreign` (`thumbnail_id`);

--
-- Indexes for table `product_purchases`
--
ALTER TABLE `product_purchases`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_purchases_purchase_id_foreign` (`purchase_id`),
  ADD KEY `product_purchases_product_id_foreign` (`product_id`);

--
-- Indexes for table `product_sales`
--
ALTER TABLE `product_sales`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_sales_sale_id_foreign` (`sale_id`),
  ADD KEY `product_sales_product_id_foreign` (`product_id`);

--
-- Indexes for table `product_variants`
--
ALTER TABLE `product_variants`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_variants_product_id_foreign` (`product_id`),
  ADD KEY `product_variants_variant_id_foreign` (`variant_id`);

--
-- Indexes for table `product_warehouse`
--
ALTER TABLE `product_warehouse`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_warehouse_product_id_foreign` (`product_id`),
  ADD KEY `product_warehouse_warehouse_id_foreign` (`warehouse_id`);

--
-- Indexes for table `purchases`
--
ALTER TABLE `purchases`
  ADD PRIMARY KEY (`id`),
  ADD KEY `purchases_shop_id_foreign` (`shop_id`),
  ADD KEY `purchases_created_by_foreign` (`created_by`),
  ADD KEY `purchases_warehouse_id_foreign` (`warehouse_id`),
  ADD KEY `purchases_supplier_id_foreign` (`supplier_id`),
  ADD KEY `purchases_tax_id_foreign` (`tax_id`),
  ADD KEY `purchases_document_id_foreign` (`document_id`);

--
-- Indexes for table `purchase_batches`
--
ALTER TABLE `purchase_batches`
  ADD PRIMARY KEY (`id`),
  ADD KEY `purchase_batches_purchase_id_foreign` (`purchase_id`),
  ADD KEY `purchase_batches_product_id_foreign` (`product_id`);

--
-- Indexes for table `purchase_product_serial_numbers`
--
ALTER TABLE `purchase_product_serial_numbers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `purchase_product_serial_numbers_purchase_id_foreign` (`purchase_id`),
  ADD KEY `purchase_product_serial_numbers_product_id_foreign` (`product_id`);

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

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

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `sales`
--
ALTER TABLE `sales`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sales_shop_id_foreign` (`shop_id`),
  ADD KEY `sales_created_by_foreign` (`created_by`),
  ADD KEY `sales_customer_id_foreign` (`customer_id`),
  ADD KEY `sales_warehouse_id_foreign` (`warehouse_id`),
  ADD KEY `sales_document_id_foreign` (`document_id`);

--
-- Indexes for table `sale_returns`
--
ALTER TABLE `sale_returns`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sale_returns_shop_id_foreign` (`shop_id`),
  ADD KEY `sale_returns_created_by_foreign` (`created_by`);

--
-- Indexes for table `sale_return_products`
--
ALTER TABLE `sale_return_products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sale_return_products_sale_return_id_foreign` (`sale_return_id`),
  ADD KEY `sale_return_products_product_id_foreign` (`product_id`);

--
-- Indexes for table `shops`
--
ALTER TABLE `shops`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shops_user_id_foreign` (`user_id`),
  ADD KEY `shops_shop_category_id_foreign` (`shop_category_id`);

--
-- Indexes for table `shop_categories`
--
ALTER TABLE `shop_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shop_categories_created_by_foreign` (`created_by`);

--
-- Indexes for table `shop_subscriptions`
--
ALTER TABLE `shop_subscriptions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shop_subscriptions_shop_id_foreign` (`shop_id`),
  ADD KEY `shop_subscriptions_subscription_id_foreign` (`subscription_id`);

--
-- Indexes for table `shop_users`
--
ALTER TABLE `shop_users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `shop_users_user_id_foreign` (`user_id`),
  ADD KEY `shop_users_shop_id_foreign` (`shop_id`);

--
-- Indexes for table `stock_counts`
--
ALTER TABLE `stock_counts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `stock_counts_shop_id_foreign` (`shop_id`),
  ADD KEY `stock_counts_created_by_foreign` (`created_by`),
  ADD KEY `stock_counts_warehouse_id_foreign` (`warehouse_id`);

--
-- Indexes for table `stores`
--
ALTER TABLE `stores`
  ADD PRIMARY KEY (`id`),
  ADD KEY `stores_shop_id_foreign` (`shop_id`),
  ADD KEY `stores_created_by_foreign` (`created_by`),
  ADD KEY `stores_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `subscription_requests`
--
ALTER TABLE `subscription_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subscription_requests_user_id_foreign` (`user_id`),
  ADD KEY `subscription_requests_subscription_id_foreign` (`subscription_id`);

--
-- Indexes for table `suppliers`
--
ALTER TABLE `suppliers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `suppliers_shop_id_foreign` (`shop_id`),
  ADD KEY `suppliers_created_by_foreign` (`created_by`),
  ADD KEY `suppliers_thumbnail_id_foreign` (`thumbnail_id`);

--
-- Indexes for table `taxes`
--
ALTER TABLE `taxes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `taxes_shop_id_foreign` (`shop_id`),
  ADD KEY `taxes_created_by_foreign` (`created_by`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `transactions_shop_id_foreign` (`shop_id`),
  ADD KEY `transactions_user_id_foreign` (`user_id`),
  ADD KEY `transactions_account_id_foreign` (`account_id`);

--
-- Indexes for table `units`
--
ALTER TABLE `units`
  ADD PRIMARY KEY (`id`),
  ADD KEY `units_shop_id_foreign` (`shop_id`),
  ADD KEY `units_created_by_foreign` (`created_by`),
  ADD KEY `units_base_unit_id_foreign` (`base_unit_id`);

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

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

--
-- Indexes for table `wallets`
--
ALTER TABLE `wallets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wallets_user_id_foreign` (`user_id`),
  ADD KEY `wallets_account_id_foreign` (`account_id`);

--
-- Indexes for table `warehouses`
--
ALTER TABLE `warehouses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `warehouses_shop_id_foreign` (`shop_id`),
  ADD KEY `warehouses_created_by_foreign` (`created_by`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `warehouses`
--
ALTER TABLE `warehouses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
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 */;