text: -- phpMyAdmin SQL Dump
  -- version 5.1.1
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Mar 13, 2022 at 05:08 AM
  -- Server version: 10.4.20-MariaDB
  -- PHP Version: 7.4.21
  
  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: `test`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `accounts`
  --
  
  CREATE TABLE `accounts` (
    `id` int(10) UNSIGNED NOT NULL,
    `account_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `initial_balance` double DEFAULT NULL,
    `total_balance` double NOT NULL,
    `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_default` tinyint(1) DEFAULT NULL,
    `is_active` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `accounts`
  --
  
  INSERT INTO `accounts` (`id`, `account_no`, `name`, `initial_balance`, `total_balance`, `note`, `is_default`, `is_active`, `created_at`, `updated_at`) VALUES
  (1, '11111', 'Sales Account', 1000, 1000, 'this is first account', 0, 1, '2018-12-18 02:58:02', '2021-06-03 05:52:55'),
  (3, '21211', 'Sa', NULL, 0, NULL, 0, 1, '2018-12-18 02:58:56', '2021-06-03 05:52:58'),
  (4, '12345678', 'purchase account', 500, 500, 'sample note', 0, 1, '2020-12-02 05:21:21', '2021-06-03 05:53:01'),
  (5, '151289', 'Management Account', 2000, 2000, 'Sample Management Account', 1, 1, '2020-12-30 04:06:12', '2021-06-03 05:53:01');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `adjustments`
  --
  
  CREATE TABLE `adjustments` (
    `id` int(10) UNSIGNED NOT NULL,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `warehouse_id` int(11) NOT NULL,
    `document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `total_qty` double NOT NULL,
    `item` int(11) NOT NULL,
    `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `attendances`
  --
  
  CREATE TABLE `attendances` (
    `id` int(10) UNSIGNED NOT NULL,
    `date` date NOT NULL,
    `employee_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `checkin` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `checkout` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` int(11) NOT NULL,
    `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `billers`
  --
  
  CREATE TABLE `billers` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `company_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `vat_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `city` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `postal_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `billers`
  --
  
  INSERT INTO `billers` (`id`, `name`, `image`, `company_name`, `vat_number`, `email`, `phone_number`, `address`, `city`, `state`, `postal_code`, `country`, `is_active`, `created_at`, `updated_at`) VALUES
  (1, 'yousuf', 'aks.jpg', 'aks', '31123', 'yousuf@kds.com', '442343324', 'halishahar', 'chittagong', NULL, NULL, 'sdgs', 1, '2018-05-12 21:49:30', '2019-03-02 05:20:38'),
  (2, 'Tariq', 'ABCCompany.png', 'ABC Company', NULL, 'tariq@bigtree.com', '321312', 'dhaka', 'chittagong', NULL, NULL, 'bangladesh', 1, '2018-05-12 21:57:54', '2021-12-04 00:08:13'),
  (3, 'test', NULL, 'test', NULL, 'test@test.com', '3211', 'erewrwqre', 'afsf', NULL, NULL, NULL, 0, '2018-05-30 02:38:58', '2018-05-30 02:39:57'),
  (5, 'modon', 'mogaTel.jpg', 'mogaTel', '', 'modon@gmail.com', '32321', 'nasirabad', 'chittagong', '', '', 'bd', 0, '2018-09-01 03:59:54', '2021-10-17 01:17:45'),
  (6, 'a', NULL, 'a', NULL, 'a@a.com', 'q', 'q', 'q', NULL, NULL, NULL, 0, '2018-10-07 02:33:39', '2018-10-07 02:34:18'),
  (7, 'a', NULL, 'a', NULL, 'a@a.com', 'a', 'a', 'a', NULL, NULL, NULL, 0, '2018-10-07 02:34:36', '2018-10-07 02:36:07'),
  (8, 'x', 'x.png', 'x', NULL, 'x@x.com', 'x', 'x', 'x', NULL, NULL, NULL, 0, '2019-03-18 11:02:42', '2021-10-17 01:17:38'),
  (9, 'Safi', 'AcquaintTechnologies.jpg', 'Acquaint Technologies', 'Sahid', 'safiulsahid151289@gmail.com', '01521100281', 'mohanagar project', 'Dhaka', 'Dhaka', '1000', 'Bangladesh', 0, '2020-12-02 22:56:33', '2021-10-17 01:17:31'),
  (10, 'mou', NULL, 'Company Name', 'mou', 'mou@gmail.com', '01211255166', 'Dhaka', 'dhaka', 'dhaka', '256545', 'Bangladesh', 1, '2021-12-04 00:12:02', '2021-12-04 00:12:02'),
  (11, 'fdgdfg', NULL, 'Company Name', 'mou', 'mou@gmail.com', '01211255166', 'Dhaka', 'dhaka', 'dhaka', '256545', 'Bangladesh', 1, '2021-12-04 00:19:04', '2021-12-04 00:19:04');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `blogs`
  --
  
  CREATE TABLE `blogs` (
    `id` bigint(20) NOT NULL,
    `blog_title` varchar(255) NOT NULL,
    `blog_image` varchar(255) NOT NULL,
    `blog` longtext NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `blogs`
  --
  
  INSERT INTO `blogs` (`id`, `blog_title`, `blog_image`, `blog`, `created_at`, `updated_at`) VALUES
  (5, 'The Ultimate Vegan Skin Care Set to Gift This Holiday Season', 'public/images/blogs/1718462496688269.png', 'With Thanksgiving now passed, it’s time we start to double down on finding the perfect presents for our friends and family.\r\nIt can totally be stressful discovering a gift that fits your giftee’s individual interests and hobbies. So, we’re knocking one task off of your holiday purchase list and outlining our favorite skin care set for all the vegan beauty lovers out there. What better way to show your appreciation for your vegan friends than by introducing them to a vegan skin care routine that complements their lifestyle AND will leave their skin glowing and hydrated?\r\nLuckily, Soko Glam made this super easy with their carefully curated The Essential Vegan Skin Care Set, which contains all the necessary vegan skin care products for a conscious and cruelty free skin care routine! Who knows, maybe you’ll want to snag a product or two from this epic groups of goodies for all of your non-vegan skin care loving friends too!', '2021-01-27 04:39:19', '2021-12-06 23:05:46'),
  (6, '5 Ways to be Gentler to Sensitive Skin and Prevent Irritation', 'public/images/blogs/1718462378970429.png', 'The biggest question for those with sensitive skin? How to prevent skin irritation. Below, our best five tips.\r\nOne could argue that people with sensitive skin, as a whole, are one of the most conscientious when it comes to skin care. They must be in order to prevent uncomfortable—sometimes painful—irritation, flare ups, and breakouts. One sideways move can lead to weeks or months of picking up the pieces, so patch testing, label reading, and extended research are all par for the course.', '2021-01-27 05:29:48', '2021-12-06 23:03:54'),
  (7, 'Do You Really Need…Gluten-Free Beauty Products?', 'public/images/blogs/1718462277105710.png', 'If a product is all over Instagram or in all of your friends’ medicine cabinets should you be using it too? Welcome to “Do You Really Need…”, a new series where we discuss, with the help of some experts, how to determine whether or not a trendy or divisive product really belongs in YOUR skin care routine. Today we’re discussing gluten-free skin care.\r\nIn the interest of being transparent – and to ride the clean beauty wave – more and more beauty brands are getting into the habit of listing the “bad” ingredients that their products are free of on the packaging. Often, you’ll see parabens, phthalates, and artificial fragrances on these lists – the usual suspects. A less common one, but one that sticks out, is gluten. If you’ve seen a gluten-free claim and thought to yourself, “What? Why the heck is there gluten in beauty products?,” well, same.\r\nAs it turns out, sources of gluten are used in skin care as conditioning agents, and in hair care to thicken and strengthen.', '2021-01-27 05:35:30', '2021-12-06 23:02:17');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `brands`
  --
  
  CREATE TABLE `brands` (
    `id` int(10) UNSIGNED NOT NULL,
    `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `brands`
  --
  
  INSERT INTO `brands` (`id`, `title`, `image`, `is_active`, `created_at`, `updated_at`) VALUES
  (1, 'L\'oreal', '20211207051342.jpg', 1, '2021-11-03 03:55:32', '2021-12-06 23:13:42'),
  (2, 'acwell', '20211207051431.png', 1, '2021-11-03 03:55:44', '2021-12-06 23:14:31');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `carts`
  --
  
  CREATE TABLE `carts` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `product_id` int(11) NOT NULL,
    `product_quantity` int(11) NOT NULL,
    `product_price` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `carts`
  --
  
  INSERT INTO `carts` (`id`, `product_id`, `product_quantity`, `product_price`, `user_ip`, `created_at`, `updated_at`) VALUES
  (21, 2, 2, '500', '103.111.90.10', NULL, '2021-12-07 22:55:31'),
  (22, 9, 1, '7500', '::1', NULL, NULL),
  (24, 8, 1, '3000', '223.27.94.123', NULL, NULL),
  (25, 8, 1, '3000', '103.111.90.10', NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `cash_registers`
  --
  
  CREATE TABLE `cash_registers` (
    `id` int(10) UNSIGNED NOT NULL,
    `cash_in_hand` double NOT NULL,
    `user_id` int(11) NOT NULL,
    `warehouse_id` int(11) NOT NULL,
    `status` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `cash_registers`
  --
  
  INSERT INTO `cash_registers` (`id`, `cash_in_hand`, `user_id`, `warehouse_id`, `status`, `created_at`, `updated_at`) VALUES
  (1, 0, 1, 1, 1, '2021-11-04 03:14:30', '2021-11-04 03:14:30'),
  (2, 0, 1, 2, 1, '2021-11-04 03:14:56', '2021-11-04 03:14:56'),
  (3, 0, 1, 3, 1, '2022-03-05 05:11:21', '2022-03-05 05:11:21');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `categories`
  --
  
  CREATE TABLE `categories` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `parent_id` int(11) DEFAULT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `categories`
  --
  
  INSERT INTO `categories` (`id`, `name`, `image`, `parent_id`, `is_active`, `created_at`, `updated_at`) VALUES
  (1, 'Skin Care', '20211207043725.png', NULL, 1, '2021-11-03 03:53:21', '2021-12-06 22:37:25'),
  (2, 'Hair & Body', '20211207043751.png', NULL, 1, '2021-11-03 03:54:21', '2021-12-06 22:37:51'),
  (3, 'Makeup', '20211207043738.png', NULL, 1, '2021-11-29 02:53:49', '2021-12-06 22:37:38'),
  (4, 'Baby Care', '20211204042413.jpg', 3, 1, '2021-12-03 22:24:13', '2021-12-03 22:24:13'),
  (5, 'health Care', '20211204050942.jpg', 3, 1, '2021-12-03 23:09:42', '2021-12-03 23:09:42');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `checkouts`
  --
  
  CREATE TABLE `checkouts` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `customer_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `city` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `courier` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `payment` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `total_price` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `shipping_price` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `notes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `user_ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `colors`
  --
  
  CREATE TABLE `colors` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `color_name` varchar(191) NOT NULL,
    `color_description` text DEFAULT NULL,
    `color_image` varchar(191) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `contacts`
  --
  
  CREATE TABLE `contacts` (
    `id` bigint(20) NOT NULL,
    `name` varchar(255) NOT NULL,
    `email` varchar(255) NOT NULL,
    `phone_number` varchar(255) NOT NULL,
    `message` text NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `coupons`
  --
  
  CREATE TABLE `coupons` (
    `id` int(10) UNSIGNED NOT NULL,
    `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `amount` double NOT NULL,
    `minimum_amount` double DEFAULT NULL,
    `quantity` int(11) NOT NULL,
    `used` int(11) NOT NULL,
    `expired_date` date NOT NULL,
    `user_id` int(11) NOT NULL,
    `is_active` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `currencies`
  --
  
  CREATE TABLE `currencies` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `exchange_rate` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `currencies`
  --
  
  INSERT INTO `currencies` (`id`, `name`, `code`, `exchange_rate`, `created_at`, `updated_at`) VALUES
  (1, 'US Dollar', 'USD', 1, '2020-11-01 00:22:58', '2020-11-01 00:34:55'),
  (2, 'Bangladeshi Taka', 'BDT', 1, '2020-11-01 01:29:12', '2020-12-30 03:34:37');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `customers`
  --
  
  CREATE TABLE `customers` (
    `id` int(10) UNSIGNED NOT NULL,
    `customer_group_id` int(11) NOT NULL,
    `user_id` int(11) DEFAULT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `company_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `tax_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `city` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `postal_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `deposit` double DEFAULT NULL,
    `expense` double DEFAULT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `customers`
  --
  
  INSERT INTO `customers` (`id`, `customer_group_id`, `user_id`, `name`, `company_name`, `email`, `phone_number`, `tax_no`, `address`, `city`, `state`, `postal_code`, `country`, `deposit`, `expense`, `is_active`, `created_at`, `updated_at`) VALUES
  (1, 1, 36, 'Safi U sahid', 'Delware', 'safi@gmail.com', '01778744654', '78446163354', 'Rampura,Dhaka', 'Dhaka', 'Rampura', '775', 'Bangladesh', NULL, NULL, 1, '2021-06-03 04:46:38', '2021-06-03 04:46:38'),
  (2, 1, NULL, 'Hasan Mahmud', 'Binimoy', 'sales@acquaintbd.com', '01734222391', NULL, 'Dhaka', 'Dhaka', NULL, NULL, NULL, NULL, NULL, 1, '2021-10-17 01:54:54', '2021-10-17 01:54:54'),
  (3, 1, NULL, 'ranakhan', 'company', 'rana@gmail.com', '01738298666', NULL, 'Dhaka', 'dhaka', 'dhaka', NULL, NULL, NULL, NULL, 1, '2021-11-27 22:26:53', '2021-11-27 22:26:53'),
  (4, 1, NULL, 'kamal', 'company', 'kamal@acquaintbd.com', '01738298666', NULL, 'Dhaka', 'dhaka', 'dhaka', '256545', 'bangladesh', NULL, NULL, 1, '2021-11-27 23:07:33', '2021-11-27 23:07:33'),
  (5, 1, 37, 'jalalkhan', 'Company Name', 'jalal@gmail.com', '526565454', NULL, 'Dhaka', 'dhaka', 'dhaka', '256545', 'Bangladesh', NULL, NULL, 1, '2021-11-29 02:45:45', '2021-11-29 02:45:45'),
  (6, 1, 38, 'mou100', 'dsfsdf', 'mou@gmail.com', '01211255166', NULL, 'Dhaka', 'dhaka', 'dhaka', '256545', 'Bangladesh', NULL, NULL, 1, '2021-11-29 05:00:19', '2021-11-30 03:55:20');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `customer_groups`
  --
  
  CREATE TABLE `customer_groups` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `percentage` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `customer_groups`
  --
  
  INSERT INTO `customer_groups` (`id`, `name`, `percentage`, `is_active`, `created_at`, `updated_at`) VALUES
  (1, 'general', '0', 1, '2018-05-12 08:09:36', '2019-03-02 06:01:35'),
  (2, 'distributor', '-10', 1, '2018-05-12 08:12:14', '2019-03-02 06:02:12'),
  (3, 'reseller', '5', 1, '2018-05-12 08:12:26', '2018-05-30 01:18:14'),
  (4, 'test', '12', 0, '2018-05-30 01:17:16', '2018-05-30 01:17:57'),
  (5, 'test', '0', 0, '2018-08-03 09:10:27', '2018-08-03 09:10:34'),
  (6, 'Major', '15', 1, '2020-12-03 02:45:00', '2020-12-03 02:45:00');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `deliveries`
  --
  
  CREATE TABLE `deliveries` (
    `id` int(10) UNSIGNED NOT NULL,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `sale_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `address` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `delivered_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `recieved_by` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `note` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `departments`
  --
  
  CREATE TABLE `departments` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `is_active` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `deposits`
  --
  
  CREATE TABLE `deposits` (
    `id` int(10) UNSIGNED NOT NULL,
    `amount` double NOT NULL,
    `customer_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `employees`
  --
  
  CREATE TABLE `employees` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `department_id` int(11) NOT NULL,
    `user_id` int(11) DEFAULT NULL,
    `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_active` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `expenses`
  --
  
  CREATE TABLE `expenses` (
    `id` int(10) UNSIGNED NOT NULL,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `expense_category_id` int(11) NOT NULL,
    `warehouse_id` int(11) NOT NULL,
    `account_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `cash_register_id` int(11) DEFAULT NULL,
    `amount` int(11) NOT NULL,
    `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `expense_categories`
  --
  
  CREATE TABLE `expense_categories` (
    `id` int(10) UNSIGNED NOT NULL,
    `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `is_active` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `failed_jobs`
  --
  
  CREATE TABLE `failed_jobs` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `general_settings`
  --
  
  CREATE TABLE `general_settings` (
    `id` int(10) UNSIGNED NOT NULL,
    `site_title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `site_logo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `currency` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `staff_access` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `date_format` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `developed_by` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `invoice_format` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `state` int(11) DEFAULT NULL,
    `theme` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `currency_position` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `general_settings`
  --
  
  INSERT INTO `general_settings` (`id`, `site_title`, `address`, `phone`, `email`, `site_logo`, `currency`, `staff_access`, `date_format`, `developed_by`, `invoice_format`, `state`, `theme`, `created_at`, `updated_at`, `currency_position`) VALUES
  (1, 'AtechSalesPOS', 'G.A Bhaban, 3rd Floor, Purana Paltan, Dhaka 1000', '+8801734222391', 'sales@acquaintbd.com', 'atech-logo-small2.png', '2', 'own', 'd/m/Y', 'Acquaint Technologies', 'standard', 1, 'default.css', '2018-07-06 06:13:11', '2021-10-17 01:15:05', 'prefix');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `gift_cards`
  --
  
  CREATE TABLE `gift_cards` (
    `id` int(10) UNSIGNED NOT NULL,
    `card_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `amount` double NOT NULL,
    `expense` double NOT NULL,
    `customer_id` int(11) DEFAULT NULL,
    `user_id` int(11) DEFAULT NULL,
    `expired_date` date DEFAULT NULL,
    `created_by` int(11) NOT NULL,
    `is_active` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `gift_card_recharges`
  --
  
  CREATE TABLE `gift_card_recharges` (
    `id` int(10) UNSIGNED NOT NULL,
    `gift_card_id` int(11) NOT NULL,
    `amount` double NOT NULL,
    `user_id` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `holidays`
  --
  
  CREATE TABLE `holidays` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` int(11) NOT NULL,
    `from_date` date NOT NULL,
    `to_date` date NOT NULL,
    `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_approved` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `hrm_settings`
  --
  
  CREATE TABLE `hrm_settings` (
    `id` int(10) UNSIGNED NOT NULL,
    `checkin` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `checkout` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `hrm_settings`
  --
  
  INSERT INTO `hrm_settings` (`id`, `checkin`, `checkout`, `created_at`, `updated_at`) VALUES
  (1, '10:00am', '6:00pm', '2019-01-02 02:20:08', '2019-01-02 04:20:53');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `languages`
  --
  
  CREATE TABLE `languages` (
    `id` int(10) UNSIGNED NOT NULL,
    `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `languages`
  --
  
  INSERT INTO `languages` (`id`, `code`, `created_at`, `updated_at`) VALUES
  (1, 'en', '2018-07-07 22:59:17', '2019-12-24 17:34:20');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `migrations`
  --
  
  CREATE TABLE `migrations` (
    `id` int(10) UNSIGNED NOT NULL,
    `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `migrations`
  --
  
  INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
  (1, '2014_10_12_000000_create_users_table', 1),
  (2, '2014_10_12_100000_create_password_resets_table', 1),
  (3, '2018_02_17_060412_create_categories_table', 1),
  (4, '2018_02_20_035727_create_brands_table', 1),
  (5, '2018_02_25_100635_create_suppliers_table', 1),
  (6, '2018_02_27_101619_create_warehouse_table', 1),
  (7, '2018_03_03_040448_create_units_table', 1),
  (8, '2018_03_04_041317_create_taxes_table', 1),
  (9, '2018_03_10_061915_create_customer_groups_table', 1),
  (10, '2018_03_10_090534_create_customers_table', 1),
  (11, '2018_03_11_095547_create_billers_table', 1),
  (12, '2018_04_05_054401_create_products_table', 1),
  (13, '2018_04_06_133606_create_purchases_table', 1),
  (14, '2018_04_06_154600_create_product_purchases_table', 1),
  (15, '2018_04_06_154915_create_product_warhouse_table', 1),
  (16, '2018_04_10_085927_create_sales_table', 1),
  (17, '2018_04_10_090133_create_product_sales_table', 1),
  (18, '2018_04_10_090254_create_payments_table', 1),
  (19, '2018_04_10_090341_create_payment_with_cheque_table', 1),
  (20, '2018_04_10_090509_create_payment_with_credit_card_table', 1),
  (21, '2018_04_13_121436_create_quotation_table', 1),
  (22, '2018_04_13_122324_create_product_quotation_table', 1),
  (23, '2018_04_14_121802_create_transfers_table', 1),
  (24, '2018_04_14_121913_create_product_transfer_table', 1),
  (25, '2018_05_13_082847_add_payment_id_and_change_sale_id_to_payments_table', 2),
  (26, '2018_05_13_090906_change_customer_id_to_payment_with_credit_card_table', 3),
  (27, '2018_05_20_054532_create_adjustments_table', 4),
  (28, '2018_05_20_054859_create_product_adjustments_table', 4),
  (29, '2018_05_21_163419_create_returns_table', 5),
  (30, '2018_05_21_163443_create_product_returns_table', 5),
  (31, '2018_06_02_050905_create_roles_table', 6),
  (32, '2018_06_02_073430_add_columns_to_users_table', 7),
  (33, '2018_06_03_053738_create_permission_tables', 8),
  (36, '2018_06_21_063736_create_pos_setting_table', 9),
  (37, '2018_06_21_094155_add_user_id_to_sales_table', 10),
  (38, '2018_06_21_101529_add_user_id_to_purchases_table', 11),
  (39, '2018_06_21_103512_add_user_id_to_transfers_table', 12),
  (40, '2018_06_23_061058_add_user_id_to_quotations_table', 13),
  (41, '2018_06_23_082427_add_is_deleted_to_users_table', 14),
  (42, '2018_06_25_043308_change_email_to_users_table', 15),
  (43, '2018_07_06_115449_create_general_settings_table', 16),
  (44, '2018_07_08_043944_create_languages_table', 17),
  (45, '2018_07_11_102144_add_user_id_to_returns_table', 18),
  (46, '2018_07_11_102334_add_user_id_to_payments_table', 18),
  (47, '2018_07_22_130541_add_digital_to_products_table', 19),
  (49, '2018_07_24_154250_create_deliveries_table', 20),
  (50, '2018_08_16_053336_create_expense_categories_table', 21),
  (51, '2018_08_17_115415_create_expenses_table', 22),
  (55, '2018_08_18_050418_create_gift_cards_table', 23),
  (56, '2018_08_19_063119_create_payment_with_gift_card_table', 24),
  (57, '2018_08_25_042333_create_gift_card_recharges_table', 25),
  (58, '2018_08_25_101354_add_deposit_expense_to_customers_table', 26),
  (59, '2018_08_26_043801_create_deposits_table', 27),
  (60, '2018_09_02_044042_add_keybord_active_to_pos_setting_table', 28),
  (61, '2018_09_09_092713_create_payment_with_paypal_table', 29),
  (62, '2018_09_10_051254_add_currency_to_general_settings_table', 30),
  (63, '2018_10_22_084118_add_biller_and_store_id_to_users_table', 31),
  (65, '2018_10_26_034927_create_coupons_table', 32),
  (66, '2018_10_27_090857_add_coupon_to_sales_table', 33),
  (67, '2018_11_07_070155_add_currency_position_to_general_settings_table', 34),
  (68, '2018_11_19_094650_add_combo_to_products_table', 35),
  (69, '2018_12_09_043712_create_accounts_table', 36),
  (70, '2018_12_17_112253_add_is_default_to_accounts_table', 37),
  (71, '2018_12_19_103941_add_account_id_to_payments_table', 38),
  (72, '2018_12_20_065900_add_account_id_to_expenses_table', 39),
  (73, '2018_12_20_082753_add_account_id_to_returns_table', 40),
  (74, '2018_12_26_064330_create_return_purchases_table', 41),
  (75, '2018_12_26_144210_create_purchase_product_return_table', 42),
  (76, '2018_12_26_144708_create_purchase_product_return_table', 43),
  (77, '2018_12_27_110018_create_departments_table', 44),
  (78, '2018_12_30_054844_create_employees_table', 45),
  (79, '2018_12_31_125210_create_payrolls_table', 46),
  (80, '2018_12_31_150446_add_department_id_to_employees_table', 47),
  (81, '2019_01_01_062708_add_user_id_to_expenses_table', 48),
  (82, '2019_01_02_075644_create_hrm_settings_table', 49),
  (83, '2019_01_02_090334_create_attendances_table', 50),
  (84, '2019_01_27_160956_add_three_columns_to_general_settings_table', 51),
  (85, '2019_02_15_183303_create_stock_counts_table', 52),
  (86, '2019_02_17_101604_add_is_adjusted_to_stock_counts_table', 53),
  (87, '2019_04_13_101707_add_tax_no_to_customers_table', 54),
  (89, '2019_10_14_111455_create_holidays_table', 55),
  (90, '2019_11_13_145619_add_is_variant_to_products_table', 56),
  (91, '2019_11_13_150206_create_product_variants_table', 57),
  (92, '2019_11_13_153828_create_variants_table', 57),
  (93, '2019_11_25_134041_add_qty_to_product_variants_table', 58),
  (94, '2019_11_25_134922_add_variant_id_to_product_purchases_table', 58),
  (95, '2019_11_25_145341_add_variant_id_to_product_warehouse_table', 58),
  (96, '2019_11_29_182201_add_variant_id_to_product_sales_table', 59),
  (97, '2019_12_04_121311_add_variant_id_to_product_quotation_table', 60),
  (98, '2019_12_05_123802_add_variant_id_to_product_transfer_table', 61),
  (100, '2019_12_08_114954_add_variant_id_to_product_returns_table', 62),
  (101, '2019_12_08_203146_add_variant_id_to_purchase_product_return_table', 63),
  (102, '2020_02_28_103340_create_money_transfers_table', 64),
  (103, '2020_07_01_193151_add_image_to_categories_table', 65),
  (105, '2020_09_26_130426_add_user_id_to_deliveries_table', 66),
  (107, '2020_10_11_125457_create_cash_registers_table', 67),
  (108, '2020_10_13_155019_add_cash_register_id_to_sales_table', 68),
  (109, '2020_10_13_172624_add_cash_register_id_to_returns_table', 69),
  (110, '2020_10_17_212338_add_cash_register_id_to_payments_table', 70),
  (111, '2020_10_18_124200_add_cash_register_id_to_expenses_table', 71),
  (112, '2020_10_21_121632_add_developed_by_to_general_settings_table', 72),
  (113, '2019_08_19_000000_create_failed_jobs_table', 73),
  (114, '2020_10_30_135557_create_notifications_table', 73),
  (115, '2020_11_01_044954_create_currencies_table', 74),
  (116, '2020_11_01_140736_add_price_to_product_warehouse_table', 75),
  (117, '2020_11_02_050633_add_is_diff_price_to_products_table', 76),
  (118, '2020_11_09_055222_add_user_id_to_customers_table', 77),
  (119, '2020_11_17_054806_add_invoice_format_to_general_settings_table', 78),
  (120, '2021_12_07_065812_create_tags_table', 79),
  (121, '2021_12_07_091902_create_product_tags_table', 80);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `money_transfers`
  --
  
  CREATE TABLE `money_transfers` (
    `id` int(10) UNSIGNED NOT NULL,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci 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=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `newsletters`
  --
  
  CREATE TABLE `newsletters` (
    `id` bigint(20) NOT NULL,
    `email` varchar(255) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `newsletters`
  --
  
  INSERT INTO `newsletters` (`id`, `email`, `created_at`, `updated_at`) VALUES
  (1, 'sales@acquaintbd.com', '2021-01-26 23:26:22', '2021-01-26 23:26:22'),
  (2, 'ashiqur@gmail.com', '2021-01-26 23:28:29', '2021-01-26 23:28:29'),
  (3, 'sahid@gmail.com', '2021-01-26 23:29:34', '2021-01-26 23:29:34'),
  (4, 'safiulsahid151289@gmail.com', '2021-01-26 23:34:37', '2021-01-26 23:34:37'),
  (5, 'aldeen@gmail.com', '2021-12-08 00:44:12', '2021-12-08 00:44:12'),
  (6, 'deen@gmail.com', '2021-12-08 00:45:12', '2021-12-08 00:45:12'),
  (7, 'a@gmail.com', '2021-12-08 00:48:57', '2021-12-08 00:48:57'),
  (8, 'khan@gmail.com', '2021-12-08 00:49:45', '2021-12-08 00:49:45'),
  (9, 'j@gmail.com', '2021-12-08 00:51:50', '2021-12-08 00:51:50'),
  (10, 'l@gmail.com', '2021-12-08 00:52:50', '2021-12-08 00:52:50'),
  (11, 'admin@gmail.com', '2021-12-08 00:53:13', '2021-12-08 00:53:13'),
  (12, 'safi11@gmail.com', '2021-12-08 00:53:41', '2021-12-08 00:53:41'),
  (13, 'gfdsg@gmail.com', '2021-12-08 00:54:03', '2021-12-08 00:54:03'),
  (14, 'rayhan@gmail.com', '2021-12-08 00:54:54', '2021-12-08 00:54:54'),
  (15, 'jara@gmail.com', '2021-12-08 00:56:16', '2021-12-08 00:56:16');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `notifications`
  --
  
  CREATE TABLE `notifications` (
    `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
    `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `notifiable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `notifiable_id` bigint(20) UNSIGNED NOT NULL,
    `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `read_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `orders`
  --
  
  CREATE TABLE `orders` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `checkout_id` bigint(20) NOT NULL,
    `product_id` int(11) NOT NULL,
    `product_quantity` int(11) NOT NULL,
    `product_price` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_ip` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `password_resets`
  --
  
  CREATE TABLE `password_resets` (
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `payments`
  --
  
  CREATE TABLE `payments` (
    `id` int(10) UNSIGNED NOT NULL,
    `payment_reference` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(11) NOT NULL,
    `purchase_id` int(11) DEFAULT NULL,
    `sale_id` int(11) DEFAULT NULL,
    `cash_register_id` int(11) DEFAULT NULL,
    `account_id` int(11) NOT NULL,
    `amount` double NOT NULL,
    `change` double NOT NULL,
    `paying_method` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `payment_note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `payments`
  --
  
  INSERT INTO `payments` (`id`, `payment_reference`, `user_id`, `purchase_id`, `sale_id`, `cash_register_id`, `account_id`, `amount`, `change`, `paying_method`, `payment_note`, `created_at`, `updated_at`) VALUES
  (132, 'spr-20211129-111022', 1, NULL, 80, 1, 5, 4100, 0, 'Cash', 'done', '2021-11-29 05:10:22', '2021-11-29 05:10:22'),
  (133, 'spr-20211130-052511', 1, NULL, 79, 1, 5, 30060, 0, 'Cash', NULL, '2021-11-29 23:25:11', '2021-11-29 23:25:11'),
  (134, 'spr-20211130-091837', 38, NULL, 86, 1, 1, 3100, 0, 'Bkash', NULL, '2021-11-30 03:18:37', '2021-11-30 03:18:37'),
  (135, 'spr-20211130-092824', 38, NULL, 87, 1, 1, 6100, 0, 'Cash', NULL, '2021-11-30 03:28:24', '2021-11-30 03:28:24'),
  (136, 'spr-20211130-095520', 38, NULL, 88, 1, 1, 2100, 0, 'Bkash', 'payment done by bkash', '2021-11-30 03:55:20', '2021-11-30 03:55:20'),
  (137, 'spr-20211212-044743', 1, NULL, 89, 1, 5, 2200, 0, 'Cash', 'hgfhfdhhg', '2021-12-11 22:47:43', '2021-12-11 22:47:43'),
  (138, 'spr-20211212-104805', 1, NULL, 90, 2, 5, 1980, 0, 'Cash', NULL, '2021-12-12 04:48:05', '2021-12-12 04:48:05'),
  (139, 'spr-20211212-111451', 1, NULL, 91, 2, 5, 1540, 0, 'Cash', NULL, '2021-12-12 05:14:51', '2021-12-12 05:14:51'),
  (140, 'spr-20211212-113805', 1, NULL, 92, 1, 5, 450, 0, 'Cash', 'gddfg', '2021-12-12 05:38:05', '2021-12-12 05:38:05');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `payment_with_cheque`
  --
  
  CREATE TABLE `payment_with_cheque` (
    `id` int(10) UNSIGNED NOT NULL,
    `payment_id` int(11) NOT NULL,
    `cheque_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `payment_with_credit_card`
  --
  
  CREATE TABLE `payment_with_credit_card` (
    `id` int(10) UNSIGNED NOT NULL,
    `payment_id` int(11) NOT NULL,
    `customer_id` int(11) DEFAULT NULL,
    `customer_stripe_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `charge_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `payment_with_gift_card`
  --
  
  CREATE TABLE `payment_with_gift_card` (
    `id` int(10) UNSIGNED NOT NULL,
    `payment_id` int(11) NOT NULL,
    `gift_card_id` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `payment_with_paypal`
  --
  
  CREATE TABLE `payment_with_paypal` (
    `id` int(10) UNSIGNED NOT NULL,
    `payment_id` int(11) NOT NULL,
    `transaction_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `payrolls`
  --
  
  CREATE TABLE `payrolls` (
    `id` int(10) UNSIGNED NOT NULL,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `employee_id` int(11) NOT NULL,
    `account_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `amount` double NOT NULL,
    `paying_method` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `permissions`
  --
  
  CREATE TABLE `permissions` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `permissions`
  --
  
  INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
  (4, 'products-edit', 'web', '2018-06-03 01:00:09', '2018-06-03 01:00:09'),
  (5, 'products-delete', 'web', '2018-06-03 22:54:22', '2018-06-03 22:54:22'),
  (6, 'products-add', 'web', '2018-06-04 00:34:14', '2018-06-04 00:34:14'),
  (7, 'products-index', 'web', '2018-06-04 03:34:27', '2018-06-04 03:34:27'),
  (8, 'purchases-index', 'web', '2018-06-04 08:03:19', '2018-06-04 08:03:19'),
  (9, 'purchases-add', 'web', '2018-06-04 08:12:25', '2018-06-04 08:12:25'),
  (10, 'purchases-edit', 'web', '2018-06-04 09:47:36', '2018-06-04 09:47:36'),
  (11, 'purchases-delete', 'web', '2018-06-04 09:47:36', '2018-06-04 09:47:36'),
  (12, 'sales-index', 'web', '2018-06-04 10:49:08', '2018-06-04 10:49:08'),
  (13, 'sales-add', 'web', '2018-06-04 10:49:52', '2018-06-04 10:49:52'),
  (14, 'sales-edit', 'web', '2018-06-04 10:49:52', '2018-06-04 10:49:52'),
  (15, 'sales-delete', 'web', '2018-06-04 10:49:53', '2018-06-04 10:49:53'),
  (16, 'quotes-index', 'web', '2018-06-04 22:05:10', '2018-06-04 22:05:10'),
  (17, 'quotes-add', 'web', '2018-06-04 22:05:10', '2018-06-04 22:05:10'),
  (18, 'quotes-edit', 'web', '2018-06-04 22:05:10', '2018-06-04 22:05:10'),
  (19, 'quotes-delete', 'web', '2018-06-04 22:05:10', '2018-06-04 22:05:10'),
  (20, 'transfers-index', 'web', '2018-06-04 22:30:03', '2018-06-04 22:30:03'),
  (21, 'transfers-add', 'web', '2018-06-04 22:30:03', '2018-06-04 22:30:03'),
  (22, 'transfers-edit', 'web', '2018-06-04 22:30:03', '2018-06-04 22:30:03'),
  (23, 'transfers-delete', 'web', '2018-06-04 22:30:03', '2018-06-04 22:30:03'),
  (24, 'returns-index', 'web', '2018-06-04 22:50:24', '2018-06-04 22:50:24'),
  (25, 'returns-add', 'web', '2018-06-04 22:50:24', '2018-06-04 22:50:24'),
  (26, 'returns-edit', 'web', '2018-06-04 22:50:25', '2018-06-04 22:50:25'),
  (27, 'returns-delete', 'web', '2018-06-04 22:50:25', '2018-06-04 22:50:25'),
  (28, 'customers-index', 'web', '2018-06-04 23:15:54', '2018-06-04 23:15:54'),
  (29, 'customers-add', 'web', '2018-06-04 23:15:55', '2018-06-04 23:15:55'),
  (30, 'customers-edit', 'web', '2018-06-04 23:15:55', '2018-06-04 23:15:55'),
  (31, 'customers-delete', 'web', '2018-06-04 23:15:55', '2018-06-04 23:15:55'),
  (32, 'suppliers-index', 'web', '2018-06-04 23:40:12', '2018-06-04 23:40:12'),
  (33, 'suppliers-add', 'web', '2018-06-04 23:40:12', '2018-06-04 23:40:12'),
  (34, 'suppliers-edit', 'web', '2018-06-04 23:40:12', '2018-06-04 23:40:12'),
  (35, 'suppliers-delete', 'web', '2018-06-04 23:40:12', '2018-06-04 23:40:12'),
  (36, 'product-report', 'web', '2018-06-24 23:05:33', '2018-06-24 23:05:33'),
  (37, 'purchase-report', 'web', '2018-06-24 23:24:56', '2018-06-24 23:24:56'),
  (38, 'sale-report', 'web', '2018-06-24 23:33:13', '2018-06-24 23:33:13'),
  (39, 'customer-report', 'web', '2018-06-24 23:36:51', '2018-06-24 23:36:51'),
  (40, 'due-report', 'web', '2018-06-24 23:39:52', '2018-06-24 23:39:52'),
  (41, 'users-index', 'web', '2018-06-25 00:00:10', '2018-06-25 00:00:10'),
  (42, 'users-add', 'web', '2018-06-25 00:00:10', '2018-06-25 00:00:10'),
  (43, 'users-edit', 'web', '2018-06-25 00:01:30', '2018-06-25 00:01:30'),
  (44, 'users-delete', 'web', '2018-06-25 00:01:30', '2018-06-25 00:01:30'),
  (45, 'profit-loss', 'web', '2018-07-14 21:50:05', '2018-07-14 21:50:05'),
  (46, 'best-seller', 'web', '2018-07-14 22:01:38', '2018-07-14 22:01:38'),
  (47, 'daily-sale', 'web', '2018-07-14 22:24:21', '2018-07-14 22:24:21'),
  (48, 'monthly-sale', 'web', '2018-07-14 22:30:41', '2018-07-14 22:30:41'),
  (49, 'daily-purchase', 'web', '2018-07-14 22:36:46', '2018-07-14 22:36:46'),
  (50, 'monthly-purchase', 'web', '2018-07-14 22:48:17', '2018-07-14 22:48:17'),
  (51, 'payment-report', 'web', '2018-07-14 23:10:41', '2018-07-14 23:10:41'),
  (52, 'warehouse-stock-report', 'web', '2018-07-14 23:16:55', '2018-07-14 23:16:55'),
  (53, 'product-qty-alert', 'web', '2018-07-14 23:33:21', '2018-07-14 23:33:21'),
  (54, 'supplier-report', 'web', '2018-07-30 03:00:01', '2018-07-30 03:00:01'),
  (55, 'expenses-index', 'web', '2018-09-05 01:07:10', '2018-09-05 01:07:10'),
  (56, 'expenses-add', 'web', '2018-09-05 01:07:10', '2018-09-05 01:07:10'),
  (57, 'expenses-edit', 'web', '2018-09-05 01:07:10', '2018-09-05 01:07:10'),
  (58, 'expenses-delete', 'web', '2018-09-05 01:07:11', '2018-09-05 01:07:11'),
  (59, 'general_setting', 'web', '2018-10-19 23:10:04', '2018-10-19 23:10:04'),
  (60, 'mail_setting', 'web', '2018-10-19 23:10:04', '2018-10-19 23:10:04'),
  (61, 'pos_setting', 'web', '2018-10-19 23:10:04', '2018-10-19 23:10:04'),
  (62, 'hrm_setting', 'web', '2019-01-02 10:30:23', '2019-01-02 10:30:23'),
  (63, 'purchase-return-index', 'web', '2019-01-02 21:45:14', '2019-01-02 21:45:14'),
  (64, 'purchase-return-add', 'web', '2019-01-02 21:45:14', '2019-01-02 21:45:14'),
  (65, 'purchase-return-edit', 'web', '2019-01-02 21:45:14', '2019-01-02 21:45:14'),
  (66, 'purchase-return-delete', 'web', '2019-01-02 21:45:14', '2019-01-02 21:45:14'),
  (67, 'account-index', 'web', '2019-01-02 22:06:13', '2019-01-02 22:06:13'),
  (68, 'balance-sheet', 'web', '2019-01-02 22:06:14', '2019-01-02 22:06:14'),
  (69, 'account-statement', 'web', '2019-01-02 22:06:14', '2019-01-02 22:06:14'),
  (70, 'department', 'web', '2019-01-02 22:30:01', '2019-01-02 22:30:01'),
  (71, 'attendance', 'web', '2019-01-02 22:30:01', '2019-01-02 22:30:01'),
  (72, 'payroll', 'web', '2019-01-02 22:30:01', '2019-01-02 22:30:01'),
  (73, 'employees-index', 'web', '2019-01-02 22:52:19', '2019-01-02 22:52:19'),
  (74, 'employees-add', 'web', '2019-01-02 22:52:19', '2019-01-02 22:52:19'),
  (75, 'employees-edit', 'web', '2019-01-02 22:52:19', '2019-01-02 22:52:19'),
  (76, 'employees-delete', 'web', '2019-01-02 22:52:19', '2019-01-02 22:52:19'),
  (77, 'user-report', 'web', '2019-01-16 06:48:18', '2019-01-16 06:48:18'),
  (78, 'stock_count', 'web', '2019-02-17 10:32:01', '2019-02-17 10:32:01'),
  (79, 'adjustment', 'web', '2019-02-17 10:32:02', '2019-02-17 10:32:02'),
  (80, 'sms_setting', 'web', '2019-02-22 05:18:03', '2019-02-22 05:18:03'),
  (81, 'create_sms', 'web', '2019-02-22 05:18:03', '2019-02-22 05:18:03'),
  (82, 'print_barcode', 'web', '2019-03-07 05:02:19', '2019-03-07 05:02:19'),
  (83, 'empty_database', 'web', '2019-03-07 05:02:19', '2019-03-07 05:02:19'),
  (84, 'customer_group', 'web', '2019-03-07 05:37:15', '2019-03-07 05:37:15'),
  (85, 'unit', 'web', '2019-03-07 05:37:15', '2019-03-07 05:37:15'),
  (86, 'tax', 'web', '2019-03-07 05:37:15', '2019-03-07 05:37:15'),
  (87, 'gift_card', 'web', '2019-03-07 06:29:38', '2019-03-07 06:29:38'),
  (88, 'coupon', 'web', '2019-03-07 06:29:38', '2019-03-07 06:29:38'),
  (89, 'holiday', 'web', '2019-10-19 08:57:15', '2019-10-19 08:57:15'),
  (90, 'warehouse-report', 'web', '2019-10-22 06:00:23', '2019-10-22 06:00:23'),
  (91, 'warehouse', 'web', '2020-02-26 06:47:32', '2020-02-26 06:47:32'),
  (92, 'brand', 'web', '2020-02-26 06:59:59', '2020-02-26 06:59:59'),
  (93, 'billers-index', 'web', '2020-02-26 07:11:15', '2020-02-26 07:11:15'),
  (94, 'billers-add', 'web', '2020-02-26 07:11:15', '2020-02-26 07:11:15'),
  (95, 'billers-edit', 'web', '2020-02-26 07:11:15', '2020-02-26 07:11:15'),
  (96, 'billers-delete', 'web', '2020-02-26 07:11:15', '2020-02-26 07:11:15'),
  (97, 'money-transfer', 'web', '2020-03-02 05:41:48', '2020-03-02 05:41:48'),
  (98, 'category', 'web', '2020-07-13 12:13:16', '2020-07-13 12:13:16'),
  (99, 'delivery', 'web', '2020-07-13 12:13:16', '2020-07-13 12:13:16'),
  (100, 'send_notification', 'web', '2020-10-31 06:21:31', '2020-10-31 06:21:31'),
  (101, 'today_sale', 'web', '2020-10-31 06:57:04', '2020-10-31 06:57:04'),
  (102, 'today_profit', 'web', '2020-10-31 06:57:04', '2020-10-31 06:57:04'),
  (103, 'currency', 'web', '2020-11-09 00:23:11', '2020-11-09 00:23:11'),
  (104, 'backup_database', 'web', '2020-11-15 00:16:55', '2020-11-15 00:16:55'),
  (105, 'date', 'web', '2021-10-27 03:27:27', '2021-10-27 03:27:27'),
  (106, 'product-expiry-alert', 'web', '2021-11-06 00:16:06', '2021-11-06 00:16:06'),
  (107, 'brand-product-report', 'web', '2022-03-05 05:06:52', '2022-03-05 05:06:52'),
  (108, 'stock_list', 'web', '2022-03-05 05:06:53', '2022-03-05 05:06:53');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `pos_setting`
  --
  
  CREATE TABLE `pos_setting` (
    `id` int(11) NOT NULL,
    `customer_id` int(11) NOT NULL,
    `warehouse_id` int(11) NOT NULL,
    `biller_id` int(11) NOT NULL,
    `product_number` int(11) NOT NULL,
    `keybord_active` tinyint(1) NOT NULL,
    `stripe_public_key` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `stripe_secret_key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `pos_setting`
  --
  
  INSERT INTO `pos_setting` (`id`, `customer_id`, `warehouse_id`, `biller_id`, `product_number`, `keybord_active`, `stripe_public_key`, `stripe_secret_key`, `created_at`, `updated_at`) VALUES
  (1, 11, 2, 1, 4, 0, 'pk_test_ITN7KOYiIsHSCQ0UMRcgaYUB', 'sk_test_TtQQaawhEYRwa3mU9CzttrEy', '2018-09-02 03:17:04', '2020-04-17 13:59:54');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `products`
  --
  
  CREATE TABLE `products` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `barcode_symbology` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `brand_id` int(11) DEFAULT NULL,
    `category_id` int(11) NOT NULL,
    `unit_id` int(11) NOT NULL,
    `purchase_unit_id` int(11) NOT NULL,
    `sale_unit_id` int(11) NOT NULL,
    `cost` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `price` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `qty` double DEFAULT NULL,
    `alert_quantity` double DEFAULT NULL,
    `promotion` tinyint(4) DEFAULT NULL,
    `promotion_price` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `starting_date` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `last_date` date DEFAULT NULL,
    `tax_id` int(11) DEFAULT NULL,
    `tax_method` int(11) DEFAULT NULL,
    `image` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_variant` tinyint(1) DEFAULT NULL,
    `is_diffPrice` tinyint(1) DEFAULT NULL,
    `is_diffAlertQty` tinyint(4) DEFAULT NULL,
    `featured` tinyint(4) DEFAULT NULL,
    `product_list` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `qty_list` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `price_list` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `product_details` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `products`
  --
  
  INSERT INTO `products` (`id`, `name`, `code`, `type`, `barcode_symbology`, `brand_id`, `category_id`, `unit_id`, `purchase_unit_id`, `sale_unit_id`, `cost`, `price`, `qty`, `alert_quantity`, `promotion`, `promotion_price`, `starting_date`, `last_date`, `tax_id`, `tax_method`, `image`, `file`, `is_variant`, `is_diffPrice`, `is_diffAlertQty`, `featured`, `product_list`, `qty_list`, `price_list`, `product_details`, `is_active`, `created_at`, `updated_at`) VALUES
  (2, 'Rich Moist Soothing Cream', '93125824', 'standard', 'C128', 1, 1, 1, 1, 1, '400', '500', 101, 20, NULL, NULL, NULL, '2030-12-30', NULL, 1, '1638176150443Rich-Moist-Soothing-Cream-thumbnail-01-product.jpg,1638176150447Rich-Moist-Soothing-Cream-thumbnail-03-info3.jpg', NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '<p>This product has been renewed to 80ml (from 60ml).<br /><br />Infused with yeast-derived Beta Glucan, this cream fortifies the skin\'s natural moisture barrier. The Rich Moist Soothing Cream enhances the skin\'s ability to repair cells by strengthening the protective layer of dry and sensitive skin from the inside out.<br />This cream makes skin the most comfortable condition by balancing proper oil and water balance. With its spreadable and non-sticky texture, it absorbs effectively on the skin.</p>', 1, '2021-11-03 04:02:55', '2021-12-12 05:37:58'),
  (7, 'REST AND RELAX PACKAGE', '36270453', 'standard', 'C128', 1, 2, 1, 1, 1, '1500', '2000', 0, 10, NULL, NULL, NULL, '2030-12-30', NULL, 1, '1638177339374Rest-and-Relax-Package-thumbnail-01-product-2.jpg,1638177339377Rest-and-Relax-Package-thumbnail-04-concept01.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '<p>This is a moisturizing skincare routine stuffed with winter essentials from a nourishing wash-off mask to an eye butter, all products that are perfect to use for the cold &amp; dry season. In the winter, your skin gets stretchy and dry, not to mention the redness and irritation. The harsh cold climate and dry indoor air during winter can leave skin in less-than-ideal shape. Follow this skincare routine so that you can keep your skin healthy moisturized and looking good all season long.</p>\r\n<p>Honey Mask is one of our best sellers that delivers deep moisturization and nourishment containing 46.44g of natural honey. Another best-seller, rice toner is made with 77.78% Rice Extract effective in elasticity care. The skin illuminating solution, only found exclusively in Wishtrend, delivers effective brightening care thanks to a superstar formula that features 51.91% grape and pomegranate extracts, which are rich in antioxidants that swiftly work to uncover a bright, healthy complexion. The Quad Active Boosting Essence is a serum booster that contains ingredients that are widely known to help with anti-inflammatory, anti-pollution, and anti-bacterial effects to maintain your skin to stay healthy and lively. For extra moisturization, enjoy our new Green Golden Ruler from Chasin\' Rabbits. The yogurt-like cream fills the skin with moisture without stickiness.</p>\r\n<p>For the eyes, the Fundamental Nourishing Eye Butter contains sunflower seed oil that&rsquo;s rich in vitamin A and vitamin E to protect the thin skin around your eyes. Last but not least, using sunscreen during winter is important just as in the summer. The 100% mineral Aqua Soothing UV Protector will protect your skin from UV rays that don\'t cause irritation.</p>\r\n<p>Effect |<br />Vitalizing, Hydration, Moisture, Glowing Skin, Eyecare, Suncare, Exfoliating</p>\r\n<p>Recommend to |<br />For those who are looking for a hydrating &amp; moisturizing skincare routine for cold season that includes sun protection &amp; eye care.</p>\r\n<p>Includes |<br />I\'m From Honey Mask (120g) x 1<br />I\'m From Rice Toner (150ml) x 1<br />elmt Skin Illuminating Solution (150ml) x 1<br />By Wishtrend Quad Active Boosting Essence (100ml) x 1<br />Chasin\' Rabbits Green Golden Ruler (75ml) x 1<br />Klairs Fundamental Nourishing Eye Butter (20g) x 1<br />Rovectin Aqua Soothing UV Protector (50ml) x 1<br />FREE&nbsp;Klairs Gentle Black Fresh Cleansing Oil (30ml) x 1<br />FREE&nbsp;Klairs Gentle Black Facial Cleanser (20ml) x 1</p>', 1, '2021-11-29 03:16:23', '2021-11-29 03:16:23'),
  (8, 'Correcting Post Pigmentation Clearing Box', '32837594', 'standard', 'C128', 1, 3, 1, 1, 1, '2500', '3000', 0, 10, NULL, NULL, NULL, '2030-12-30', NULL, 1, '1638177558436Correcting-Post-Pigmentation-Clearing-Box-thumbnail-01-product-.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '<p>This set revives dull skin. Rice toner, vitamin drop and vitamin E mask improve pigmentation/texture and brighten the skin, blue cream has excellent soothing effects and the sheet mask provides ample moisturization to the deep layers of the skin.<br /><br />Includes |<br />I\'m from Rice Toner (150ml) x 1<br />Klairs Freshly Juiced Vitamin Drop (35ml) x 1<br />Klairs Freshly Juiced Vitamin E Mask (90ml) x 1<br />Klairs Midnight Blue Calming Cream (60ml) x 1<br />FREE&nbsp;Klairs Toner Mate 2 in 1 Cotton pad (60 compressed pads + 60 sponge pads) x 1<br />FREE&nbsp;Klairs Rich Moist Soothing Tencel Sheet Mask (25ml) x 5<br />FREE&nbsp;By Wishtrend Clear Skin Shield Patch (39 Patches) x 1</p>', 1, '2021-11-29 03:19:54', '2021-11-29 03:19:54'),
  (9, 'Combo Face wash', '13538010', 'combo', 'C128', 1, 1, 0, 0, 0, '0', '7500', 0, NULL, NULL, NULL, NULL, '2030-12-30', NULL, 1, 'zummXD2dvAtI.png', NULL, NULL, NULL, NULL, NULL, '2,7,8', '1,2,1', '500,2000,3000', '<p>test combo pack</p>', 1, '2021-11-30 05:51:41', '2021-11-30 05:51:41'),
  (10, 'Baby powder', '95129938', 'standard', 'C128', 1, 4, 1, 1, 1, '500', '700', 0, 50, NULL, NULL, NULL, '2030-12-30', NULL, 1, '1638595368707baby.jpg', NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', 1, '2021-12-03 23:11:30', '2021-12-03 23:22:50'),
  (11, 'abcCombo', '97268013', 'combo', 'C128', 1, 3, 0, 0, 0, '0', '3500', 0, NULL, NULL, NULL, NULL, '2030-12-30', NULL, 1, 'zummXD2dvAtI.png', NULL, NULL, NULL, NULL, NULL, '2,8', '1,1', '500,3000', '', 1, '2022-03-05 05:09:23', '2022-03-05 05:09:23'),
  (12, 'testCombo', '39620720', 'combo', 'C128', 2, 3, 0, 0, 0, '0', '3700', 3, NULL, 1, '3500', '2022-03-05', '2030-12-30', NULL, 1, 'zummXD2dvAtI.png', NULL, NULL, 0, NULL, 0, '8,10', '1,1', '3000,700', '', 1, '2022-03-05 05:38:01', '2022-03-05 06:30:32');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `product_adjustments`
  --
  
  CREATE TABLE `product_adjustments` (
    `id` int(10) UNSIGNED NOT NULL,
    `adjustment_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `qty` double NOT NULL,
    `action` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `product_purchases`
  --
  
  CREATE TABLE `product_purchases` (
    `id` int(10) UNSIGNED NOT NULL,
    `purchase_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `variant_id` int(11) DEFAULT NULL,
    `qty` double NOT NULL,
    `recieved` double NOT NULL,
    `purchase_unit_id` int(11) NOT NULL,
    `net_unit_cost` double NOT NULL,
    `discount` double NOT NULL,
    `tax_rate` double NOT NULL,
    `tax` double NOT NULL,
    `total` double NOT NULL,
    `ex_date` date DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `product_purchases`
  --
  
  INSERT INTO `product_purchases` (`id`, `purchase_id`, `product_id`, `variant_id`, `qty`, `recieved`, `purchase_unit_id`, `net_unit_cost`, `discount`, `tax_rate`, `tax`, `total`, `ex_date`, `created_at`, `updated_at`) VALUES
  (1, 1, 1, NULL, 100, 100, 1, 14000, 0, 0, 0, 1400000, '2021-11-30', '2021-11-03 04:15:47', '2021-11-03 04:15:47'),
  (2, 1, 2, NULL, 100, 100, 1, 400, 0, 0, 0, 40000, '2021-11-30', '2021-11-03 04:15:48', '2021-11-03 04:15:48'),
  (3, 2, 1, NULL, 50, 50, 1, 14000, 0, 0, 0, 700000, '2021-11-25', '2021-11-03 04:29:57', '2021-11-03 04:29:57'),
  (105, 4, 6, NULL, 100, 100, 1, 2000, 0, 0, 0, 200000, '2021-11-30', '2021-11-06 23:38:05', '2021-11-06 23:38:05'),
  (106, 5, 1, NULL, 100, 100, 1, 14000, 0, 0, 0, 1400000, '2023-04-27', '2021-11-26 23:07:15', '2021-11-26 23:07:15'),
  (107, 6, 1, NULL, 100, 100, 1, 14000, 0, 0, 0, 1400000, NULL, '2021-11-26 23:19:28', '2021-11-26 23:19:28');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `product_quotation`
  --
  
  CREATE TABLE `product_quotation` (
    `id` int(10) UNSIGNED NOT NULL,
    `quotation_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `variant_id` int(11) DEFAULT NULL,
    `qty` double NOT NULL,
    `sale_unit_id` int(11) NOT NULL,
    `net_unit_price` double NOT NULL,
    `discount` double NOT NULL,
    `tax_rate` double NOT NULL,
    `tax` double NOT NULL,
    `total` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `product_returns`
  --
  
  CREATE TABLE `product_returns` (
    `id` int(10) UNSIGNED NOT NULL,
    `return_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `variant_id` int(11) DEFAULT NULL,
    `qty` double NOT NULL,
    `sale_unit_id` int(11) NOT NULL,
    `net_unit_price` double NOT NULL,
    `discount` double NOT NULL,
    `tax_rate` double NOT NULL,
    `tax` double NOT NULL,
    `total` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `product_sales`
  --
  
  CREATE TABLE `product_sales` (
    `id` int(10) UNSIGNED NOT NULL,
    `sale_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `variant_id` int(11) DEFAULT NULL,
    `qty` double NOT NULL,
    `sale_unit_id` int(11) NOT NULL,
    `net_unit_price` double NOT NULL,
    `discount` double NOT NULL,
    `tax_rate` double NOT NULL,
    `tax` double NOT NULL,
    `total` double NOT NULL,
    `created_at` date DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB 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
  (81, 80, 7, NULL, 2, 1, 2000, 0, 0, 0, 4000, '2021-11-29', '2021-11-29 05:00:19'),
  (82, 81, 2, NULL, 1, 1, 500, 0, 0, 0, 500, '2021-11-30', '2021-11-30 02:48:09'),
  (83, 84, 8, NULL, 1, 1, 3000, 0, 0, 0, 3000, '2021-11-30', '2021-11-30 03:13:34'),
  (84, 85, 8, NULL, 1, 1, 3000, 0, 0, 0, 3000, '2021-11-30', '2021-11-30 03:14:54'),
  (85, 86, 8, NULL, 1, 1, 3000, 0, 0, 0, 3000, '2021-11-30', '2021-11-30 03:18:37'),
  (86, 87, 8, NULL, 2, 1, 3000, 0, 0, 0, 6000, '2021-11-30', '2021-11-30 03:28:24'),
  (87, 88, 7, NULL, 1, 1, 2000, 0, 0, 0, 2000, '2021-11-30', '2021-11-30 03:55:20'),
  (88, 89, 2, NULL, 1, 1, 2200, 0, 0, 0, 2200, '2021-12-12', '2021-12-11 22:47:38'),
  (89, 90, 2, NULL, 1, 1, 1980, 220, 0, 0, 1980, '2021-12-12', '2021-12-12 04:48:03'),
  (90, 91, 2, NULL, 1, 1, 1540, 660, 0, 0, 1540, '2021-12-12', '2021-12-12 05:14:50'),
  (91, 92, 2, NULL, 1, 1, 450, 50, 0, 0, 450, '2021-12-12', '2021-12-12 05:37:58');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `product_tags`
  --
  
  CREATE TABLE `product_tags` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `product_id` int(11) NOT NULL,
    `tag_id` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `product_tags`
  --
  
  INSERT INTO `product_tags` (`id`, `product_id`, `tag_id`, `created_at`, `updated_at`) VALUES
  (1, 2, 1, '2021-12-07 23:04:14', '2021-12-07 23:04:14'),
  (3, 2, 3, '2021-12-07 23:04:14', '2021-12-07 23:04:14'),
  (4, 2, 4, '2021-12-07 23:04:14', '2021-12-07 23:04:14'),
  (5, 2, 9, '2021-12-07 23:04:14', '2021-12-07 23:04:14'),
  (6, 8, 10, '2021-12-07 23:07:36', '2021-12-07 23:07:36'),
  (7, 8, 4, '2021-12-07 23:07:36', '2021-12-07 23:51:44'),
  (8, 10, 4, '2021-12-08 01:05:26', '2021-12-08 01:05:26'),
  (9, 10, 5, '2021-12-08 01:05:26', '2021-12-08 01:05:26'),
  (10, 10, 6, '2021-12-08 01:05:26', '2021-12-08 01:05:26'),
  (11, 10, 7, '2021-12-08 01:05:26', '2021-12-08 01:05:26'),
  (12, 9, 2, '2021-12-08 01:23:43', '2021-12-08 01:23:43'),
  (13, 9, 4, '2021-12-08 01:23:43', '2021-12-08 01:23:43'),
  (14, 7, 5, '2021-12-08 01:23:43', '2021-12-08 01:23:43');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `product_transfer`
  --
  
  CREATE TABLE `product_transfer` (
    `id` int(10) UNSIGNED NOT NULL,
    `transfer_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `variant_id` int(11) DEFAULT NULL,
    `qty` double NOT NULL,
    `purchase_unit_id` int(11) NOT NULL,
    `net_unit_cost` double NOT NULL,
    `tax_rate` double NOT NULL,
    `tax` double NOT NULL,
    `total` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `product_transfer`
  --
  
  INSERT INTO `product_transfer` (`id`, `transfer_id`, `product_id`, `variant_id`, `qty`, `purchase_unit_id`, `net_unit_cost`, `tax_rate`, `tax`, `total`, `created_at`, `updated_at`) VALUES
  (3, 3, 2, NULL, 1, 1, 400, 0, 0, 400, '2021-12-04 03:25:27', '2021-12-04 03:25:27');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `product_variants`
  --
  
  CREATE TABLE `product_variants` (
    `id` int(10) UNSIGNED NOT NULL,
    `product_id` int(11) NOT NULL,
    `variant_id` int(11) NOT NULL,
    `position` int(11) NOT NULL,
    `item_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `additional_price` double DEFAULT NULL,
    `qty` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `product_variants`
  --
  
  INSERT INTO `product_variants` (`id`, `product_id`, `variant_id`, `position`, `item_code`, `additional_price`, `qty`, `created_at`, `updated_at`) VALUES
  (1, 3, 1, 1, 'S-9999', 0, 0, '2021-11-04 03:24:01', '2021-11-04 03:24:01'),
  (2, 3, 2, 2, 'M-9999', 0, 0, '2021-11-04 03:24:01', '2021-11-04 03:24:01'),
  (3, 3, 3, 3, 'L-9999', 10, 0, '2021-11-04 03:24:01', '2021-11-04 03:24:01');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `product_warehouse`
  --
  
  CREATE TABLE `product_warehouse` (
    `id` int(10) UNSIGNED NOT NULL,
    `product_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `variant_id` int(11) DEFAULT NULL,
    `warehouse_id` int(11) NOT NULL,
    `qty` double NOT NULL,
    `alert_qty` double DEFAULT NULL,
    `price` double DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `product_warehouse`
  --
  
  INSERT INTO `product_warehouse` (`id`, `product_id`, `variant_id`, `warehouse_id`, `qty`, `alert_qty`, `price`, `created_at`, `updated_at`) VALUES
  (2, '2', NULL, 1, 102, NULL, 3000, '2021-11-03 04:15:48', '2021-12-12 05:37:58'),
  (10, '2', NULL, 2, 0, 35, 2200, '2021-11-06 04:04:28', '2021-12-12 05:14:50'),
  (11, '2', NULL, 3, 14, 18, 2500, '2021-11-06 04:04:28', '2021-11-08 02:45:50'),
  (12, '8', NULL, 3, 0, 19, 2600, '2021-11-06 04:04:28', '2021-11-08 02:45:50');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `purchases`
  --
  
  CREATE TABLE `purchases` (
    `id` int(10) UNSIGNED NOT NULL,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(11) NOT NULL,
    `warehouse_id` int(11) NOT NULL,
    `supplier_id` int(11) DEFAULT NULL,
    `item` int(11) NOT NULL,
    `total_qty` double NOT NULL,
    `total_discount` double NOT NULL,
    `total_tax` double NOT NULL,
    `total_cost` double NOT NULL,
    `order_tax_rate` double DEFAULT NULL,
    `order_tax` double DEFAULT NULL,
    `order_discount` double DEFAULT NULL,
    `shipping_cost` double DEFAULT NULL,
    `grand_total` double NOT NULL,
    `paid_amount` double NOT NULL,
    `status` int(11) NOT NULL,
    `payment_status` int(11) NOT NULL,
    `document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` date DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `purchases`
  --
  
  INSERT INTO `purchases` (`id`, `reference_no`, `user_id`, `warehouse_id`, `supplier_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`, `document`, `note`, `created_at`, `updated_at`) VALUES
  (1, 'pr-20211103-101547', 1, 1, 1, 2, 200, 0, 0, 1440000, 0, 0, NULL, NULL, 1440000, 0, 1, 1, NULL, NULL, '2021-11-03', '2021-11-03 04:15:47'),
  (2, 'pr-20211103-102957', 1, 2, 1, 1, 50, 0, 0, 700000, 0, 0, NULL, NULL, 700000, 700000, 1, 2, NULL, NULL, '2021-11-03', '2021-11-06 00:38:37'),
  (4, 'pr-20211107-053805', 1, 1, 1, 1, 100, 0, 0, 200000, 0, 0, NULL, NULL, 200000, 0, 1, 1, NULL, NULL, '2021-11-07', '2021-11-06 23:38:05'),
  (5, 'pr-20211127-050715', 1, 1, 1, 1, 100, 0, 0, 1400000, 0, 0, NULL, NULL, 1400000, 1400000, 1, 2, NULL, NULL, '2021-11-27', '2021-11-26 23:09:28'),
  (6, 'pr-20211127-051928', 1, 2, 1, 1, 100, 0, 0, 1400000, 0, 0, NULL, NULL, 1400000, 1400000, 1, 2, NULL, NULL, '2021-11-27', '2021-11-26 23:19:56');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `purchase_product_return`
  --
  
  CREATE TABLE `purchase_product_return` (
    `id` int(10) UNSIGNED NOT NULL,
    `return_id` int(11) NOT NULL,
    `product_id` int(11) NOT NULL,
    `variant_id` int(11) DEFAULT NULL,
    `qty` double NOT NULL,
    `purchase_unit_id` int(11) NOT NULL,
    `net_unit_cost` double NOT NULL,
    `discount` double NOT NULL,
    `tax_rate` double NOT NULL,
    `tax` double NOT NULL,
    `total` double NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `quotations`
  --
  
  CREATE TABLE `quotations` (
    `id` int(10) UNSIGNED NOT NULL,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(11) NOT NULL,
    `biller_id` int(11) NOT NULL,
    `supplier_id` int(11) DEFAULT NULL,
    `customer_id` int(11) NOT NULL,
    `warehouse_id` int(11) NOT 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,
    `order_tax_rate` double DEFAULT NULL,
    `order_tax` double DEFAULT NULL,
    `order_discount` double DEFAULT NULL,
    `shipping_cost` double DEFAULT NULL,
    `grand_total` double NOT NULL,
    `quotation_status` int(11) NOT NULL,
    `document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` date DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `report_settings`
  --
  
  CREATE TABLE `report_settings` (
    `id` int(10) UNSIGNED NOT NULL,
    `company_name` varchar(191) NOT NULL,
    `address` varchar(255) DEFAULT NULL,
    `phone` varchar(255) DEFAULT NULL,
    `email` varchar(255) DEFAULT NULL,
    `fax` varchar(255) DEFAULT NULL,
    `website` varchar(255) DEFAULT NULL,
    `site_logo` varchar(191) DEFAULT NULL,
    `logo_position` tinyint(4) DEFAULT NULL COMMENT '1=center|0=left',
    `text_font` tinyint(4) DEFAULT NULL COMMENT '0=small|1=medium|2=large',
    `text_format` tinyint(4) DEFAULT NULL COMMENT '0=ariel|1=roman|2=lucida',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `developed_by` varchar(191) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `report_settings`
  --
  
  INSERT INTO `report_settings` (`id`, `company_name`, `address`, `phone`, `email`, `fax`, `website`, `site_logo`, `logo_position`, `text_font`, `text_format`, `created_at`, `updated_at`, `developed_by`) VALUES
  (1, 'Acquaint Technologies', 'G.A Bhaban, 3rd Floor, Purana Paltan, Dhaka 1000', '01521100281', 'safi151289@gmail.com', 'Fax-12345678', 'acquaintbd.com', 'Acquaint Logo Whit.png', 0, 0, 0, '2018-07-06 06:13:11', '2021-11-28 04:49:16', 'Acquaint');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `returns`
  --
  
  CREATE TABLE `returns` (
    `id` int(10) UNSIGNED NOT NULL,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(11) NOT NULL,
    `cash_register_id` int(11) DEFAULT NULL,
    `customer_id` int(11) NOT NULL,
    `warehouse_id` int(11) NOT NULL,
    `biller_id` int(11) NOT NULL,
    `account_id` int(11) NOT 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,
    `order_tax_rate` double DEFAULT NULL,
    `order_tax` double DEFAULT NULL,
    `grand_total` double NOT NULL,
    `document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `return_note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `staff_note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `return_purchases`
  --
  
  CREATE TABLE `return_purchases` (
    `id` int(10) UNSIGNED NOT NULL,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `supplier_id` int(11) DEFAULT NULL,
    `warehouse_id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `account_id` int(11) NOT NULL,
    `item` int(11) NOT NULL,
    `total_qty` double NOT NULL,
    `total_discount` double NOT NULL,
    `total_tax` double NOT NULL,
    `total_cost` double NOT NULL,
    `order_tax_rate` double DEFAULT NULL,
    `order_tax` double DEFAULT NULL,
    `grand_total` double NOT NULL,
    `document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `return_note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `staff_note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `roles`
  --
  
  CREATE TABLE `roles` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `guard_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_active` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `roles`
  --
  
  INSERT INTO `roles` (`id`, `name`, `description`, `guard_name`, `is_active`, `created_at`, `updated_at`) VALUES
  (1, 'Admin', 'admin can access all data...', 'web', 1, '2018-06-01 23:46:44', '2018-06-02 23:13:05'),
  (2, 'Owner', 'Owner of shop...', 'web', 1, '2018-10-22 02:38:13', '2018-10-22 02:38:13'),
  (4, 'staff', 'staff has specific acess...', 'web', 1, '2018-06-02 00:05:27', '2018-06-02 00:05:27'),
  (5, 'Customer', NULL, 'web', 1, '2020-11-05 06:43:16', '2020-11-15 00:24:15'),
  (6, 'IT Officer', 'Simple IT Officer', 'web', 1, '2020-12-03 02:39:19', '2020-12-03 02:39:19');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `role_has_permissions`
  --
  
  CREATE TABLE `role_has_permissions` (
    `permission_id` int(10) UNSIGNED NOT NULL,
    `role_id` int(10) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `role_has_permissions`
  --
  
  INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
  (4, 1),
  (4, 2),
  (4, 4),
  (5, 1),
  (5, 2),
  (6, 1),
  (6, 2),
  (6, 4),
  (7, 1),
  (7, 2),
  (7, 4),
  (8, 1),
  (8, 2),
  (8, 4),
  (9, 1),
  (9, 2),
  (9, 4),
  (10, 1),
  (10, 2),
  (11, 1),
  (11, 2),
  (12, 1),
  (12, 2),
  (12, 4),
  (13, 1),
  (13, 2),
  (13, 4),
  (14, 1),
  (14, 2),
  (15, 1),
  (15, 2),
  (16, 1),
  (16, 2),
  (17, 1),
  (17, 2),
  (18, 1),
  (18, 2),
  (19, 1),
  (19, 2),
  (20, 1),
  (20, 2),
  (20, 4),
  (21, 1),
  (21, 2),
  (21, 4),
  (22, 1),
  (22, 2),
  (22, 4),
  (23, 1),
  (23, 2),
  (24, 1),
  (24, 2),
  (24, 4),
  (25, 1),
  (25, 2),
  (25, 4),
  (26, 1),
  (26, 2),
  (27, 1),
  (27, 2),
  (28, 1),
  (28, 2),
  (28, 4),
  (29, 1),
  (29, 2),
  (29, 4),
  (30, 1),
  (30, 2),
  (31, 1),
  (31, 2),
  (32, 1),
  (32, 2),
  (33, 1),
  (33, 2),
  (34, 1),
  (34, 2),
  (35, 1),
  (35, 2),
  (36, 1),
  (36, 2),
  (37, 1),
  (37, 2),
  (38, 1),
  (38, 2),
  (39, 1),
  (39, 2),
  (40, 1),
  (40, 2),
  (41, 1),
  (41, 2),
  (42, 1),
  (42, 2),
  (43, 1),
  (43, 2),
  (44, 1),
  (44, 2),
  (45, 1),
  (45, 2),
  (46, 1),
  (46, 2),
  (47, 1),
  (47, 2),
  (48, 1),
  (48, 2),
  (49, 1),
  (49, 2),
  (50, 1),
  (50, 2),
  (51, 1),
  (51, 2),
  (52, 1),
  (52, 2),
  (53, 1),
  (53, 2),
  (54, 1),
  (54, 2),
  (55, 1),
  (55, 2),
  (55, 4),
  (56, 1),
  (56, 2),
  (56, 4),
  (57, 1),
  (57, 2),
  (57, 4),
  (58, 1),
  (58, 2),
  (59, 1),
  (59, 2),
  (60, 1),
  (60, 2),
  (61, 1),
  (61, 2),
  (62, 1),
  (62, 2),
  (63, 1),
  (63, 2),
  (63, 4),
  (64, 1),
  (64, 2),
  (64, 4),
  (65, 1),
  (65, 2),
  (66, 1),
  (66, 2),
  (67, 1),
  (67, 2),
  (68, 1),
  (68, 2),
  (69, 1),
  (69, 2),
  (70, 1),
  (70, 2),
  (71, 1),
  (71, 2),
  (72, 1),
  (72, 2),
  (73, 1),
  (73, 2),
  (74, 1),
  (74, 2),
  (75, 1),
  (75, 2),
  (76, 1),
  (76, 2),
  (77, 1),
  (77, 2),
  (78, 1),
  (78, 2),
  (79, 1),
  (79, 2),
  (80, 1),
  (80, 2),
  (81, 1),
  (81, 2),
  (82, 1),
  (82, 2),
  (83, 1),
  (83, 2),
  (84, 1),
  (84, 2),
  (85, 1),
  (85, 2),
  (86, 1),
  (86, 2),
  (87, 1),
  (87, 2),
  (88, 1),
  (88, 2),
  (89, 1),
  (89, 2),
  (90, 1),
  (90, 2),
  (91, 1),
  (91, 2),
  (92, 1),
  (92, 2),
  (93, 1),
  (93, 2),
  (94, 1),
  (94, 2),
  (95, 1),
  (95, 2),
  (96, 1),
  (96, 2),
  (97, 1),
  (97, 2),
  (98, 1),
  (98, 2),
  (99, 1),
  (99, 2),
  (100, 1),
  (100, 2),
  (101, 1),
  (101, 2),
  (102, 1),
  (102, 2),
  (103, 1),
  (103, 2),
  (104, 1),
  (104, 2),
  (105, 1),
  (105, 2),
  (106, 1),
  (106, 2),
  (107, 1),
  (107, 2),
  (108, 1),
  (108, 2);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `sales`
  --
  
  CREATE TABLE `sales` (
    `id` int(10) UNSIGNED NOT NULL,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(11) NOT NULL,
    `cash_register_id` int(11) DEFAULT NULL,
    `customer_id` int(11) NOT NULL,
    `warehouse_id` int(11) NOT NULL,
    `biller_id` int(11) 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` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `paid_amount` double DEFAULT NULL,
    `sale_note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `staff_note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` date DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `user_ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `sales`
  --
  
  INSERT INTO `sales` (`id`, `reference_no`, `user_id`, `cash_register_id`, `customer_id`, `warehouse_id`, `biller_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`, `paid_amount`, `sale_note`, `staff_note`, `created_at`, `updated_at`, `user_ip`) VALUES
  (78, 'ecom-20211128-050733', 28, NULL, 4, 1, 1, 1, 1, 0, 0, 15000, 15000, NULL, NULL, NULL, NULL, NULL, NULL, 3, 2, NULL, NULL, NULL, NULL, '2021-11-28', '2021-11-27 23:07:33', NULL),
  (79, 'ecom-20211129-084545', 37, NULL, 5, 1, 1, 1, 2, 0, 0, 30000, 30060, NULL, NULL, NULL, NULL, NULL, 60, 2, 4, NULL, 30060, NULL, NULL, '2021-11-29', '2021-11-29 23:25:11', NULL),
  (80, 'ecom-20211129-110019', 38, NULL, 6, 1, 1, 1, 2, 0, 0, 4000, 4100, NULL, NULL, NULL, NULL, NULL, 100, 2, 4, NULL, 4100, NULL, NULL, '2021-11-29', '2021-11-29 05:10:22', NULL),
  (81, 'ecom-20211130-084808', 38, NULL, 6, 1, 1, 1, 1, 0, 0, 500, 560, NULL, NULL, NULL, NULL, NULL, 60, 2, 2, NULL, NULL, NULL, NULL, '2021-11-30', '2021-11-30 02:48:08', NULL),
  (82, 'ecom-20211130-085025', 38, NULL, 6, 1, 1, 0, 0, 0, 0, 0, 60, NULL, NULL, NULL, NULL, NULL, 60, 2, 2, NULL, NULL, NULL, NULL, '2021-11-30', '2021-11-30 02:50:25', NULL),
  (83, 'ecom-20211130-085201', 38, NULL, 6, 1, 1, 1, 1, 0, 0, 3000, 3100, NULL, NULL, NULL, NULL, NULL, 100, 2, 2, NULL, NULL, NULL, NULL, '2021-11-30', '2021-11-30 02:52:01', NULL),
  (84, 'ecom-20211130-091334', 38, NULL, 6, 1, 1, 1, 1, 0, 0, 3000, 3100, NULL, NULL, NULL, NULL, NULL, 100, 2, 2, NULL, NULL, NULL, NULL, '2021-11-30', '2021-11-30 03:13:34', NULL),
  (85, 'ecom-20211130-091454', 38, NULL, 6, 1, 1, 1, 1, 0, 0, 3000, 3100, NULL, NULL, NULL, NULL, NULL, 100, 2, 2, NULL, NULL, NULL, NULL, '2021-11-30', '2021-11-30 03:14:54', NULL),
  (86, 'ecom-20211130-091837', 38, NULL, 6, 1, 1, 1, 1, 0, 0, 3000, 3100, NULL, NULL, NULL, NULL, NULL, 100, 2, 2, NULL, NULL, NULL, NULL, '2021-11-30', '2021-11-30 03:18:37', NULL),
  (87, 'ecom-20211130-092824', 38, NULL, 6, 1, 1, 1, 2, 0, 0, 6000, 6100, NULL, NULL, NULL, NULL, NULL, 100, 1, 4, NULL, 6100, NULL, NULL, '2021-11-30', '2021-11-30 03:28:24', NULL),
  (88, 'ecom-20211130-095520', 38, NULL, 6, 1, 1, 1, 1, 0, 0, 2000, 2100, NULL, NULL, NULL, NULL, NULL, 100, 1, 4, NULL, 2100, NULL, NULL, '2021-11-30', '2021-11-30 03:55:20', NULL),
  (89, 'posr-20211212-044736', 1, 1, 1, 1, 2, 1, 1, 0, 0, 2200, 2200, 0, 0, NULL, NULL, NULL, NULL, 1, 4, NULL, 2200, 'hfgh', 'hfgh', '2021-12-12', '2021-12-11 22:47:36', NULL),
  (90, 'posr-20211212-104802', 1, 2, 1, 2, 1, 1, 1, 0, 0, 1980, 1980, 0, 0, NULL, NULL, NULL, NULL, 1, 4, NULL, 1980, NULL, NULL, '2021-12-12', '2021-12-12 04:48:02', NULL),
  (91, 'posr-20211212-111449', 1, 2, 5, 2, 11, 1, 1, 0, 0, 1540, 1540, 0, 0, NULL, NULL, NULL, NULL, 1, 4, NULL, 1540, NULL, NULL, '2021-12-12', '2021-12-12 05:14:49', NULL),
  (92, 'posr-20211212-113758', 1, 1, 1, 1, 1, 1, 1, 50, 0, 450, 450, 0, 0, NULL, NULL, NULL, NULL, 1, 4, NULL, 450, 'dggf', 'gf', '2021-12-12', '2021-12-12 05:37:58', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `stock_counts`
  --
  
  CREATE TABLE `stock_counts` (
    `id` int(10) UNSIGNED NOT NULL,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `warehouse_id` int(11) NOT NULL,
    `category_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `brand_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `user_id` int(11) NOT NULL,
    `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `initial_file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `final_file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_adjusted` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `suppliers`
  --
  
  CREATE TABLE `suppliers` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `company_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `vat_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `city` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `postal_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `suppliers`
  --
  
  INSERT INTO `suppliers` (`id`, `name`, `image`, `company_name`, `vat_number`, `email`, `phone_number`, `address`, `city`, `state`, `postal_code`, `country`, `is_active`, `created_at`, `updated_at`) VALUES
  (1, 'Jony', 'chaldal.jpg', 'chaldal', '787946685', 'jony@gmail.com', '01778744654', 'Badda,Dhaka', 'Dhaka', 'Badda', '775', 'Bangladesh', 1, '2021-06-03 04:51:47', '2021-06-03 04:51:47');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tags`
  --
  
  CREATE TABLE `tags` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `tag_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `tag_parent_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `tags`
  --
  
  INSERT INTO `tags` (`id`, `tag_name`, `tag_parent_name`, `image`, `status`, `created_at`, `updated_at`) VALUES
  (1, 'Combination', 'Skin Type', 'public/images/tags/1718487704374045.jpg', '1', '2021-12-07 02:46:33', '2021-12-07 05:46:26'),
  (2, 'Dry', 'Skin Type', 'public/images/tags/1718487669806992.jpg', '1', '2021-12-07 03:50:27', '2021-12-07 05:45:53'),
  (3, 'Oily', 'Skin Type', 'public/images/tags/1718487608712865.jpg', '1', '2021-12-07 03:54:55', '2021-12-07 05:44:55'),
  (4, 'Normal', 'Skin Type', 'public/images/tags/1718487741824813.jpg', '1', '2021-12-07 05:47:02', '2021-12-07 05:47:02'),
  (5, 'Sensitive', 'Skin Type', 'public/images/tags/1718487763777113.jpg', '1', '2021-12-07 05:47:23', '2021-12-07 05:47:23'),
  (6, 'Acne', 'Skin Concern', 'public/images/tags/1718487795080720.jpg', '1', '2021-12-07 05:47:53', '2021-12-07 05:47:53'),
  (7, 'Anti-Aging', 'Skin Concern', 'public/images/tags/1718487823938713.jpg', '1', '2021-12-07 05:48:20', '2021-12-07 05:48:20'),
  (8, 'Dryness', 'Skin Concern', 'public/images/tags/1718487853957386.jpg', '1', '2021-12-07 05:48:49', '2021-12-07 05:48:49'),
  (9, 'Oil Control', 'Skin Concern', 'public/images/tags/1718487897685443.jpg', '1', '2021-12-07 05:49:31', '2021-12-07 05:49:31'),
  (10, 'Oil Cleanser', 'Routine', 'public/images/tags/1718487943181288.jpeg', '1', '2021-12-07 05:50:14', '2021-12-07 05:50:14'),
  (11, 'Water Cleanser', 'Routine', 'public/images/tags/1718487978526649.jpeg', '1', '2021-12-07 05:50:48', '2021-12-07 05:50:48'),
  (12, 'Toner', 'Routine', 'public/images/tags/1718487998133532.jpeg', '1', '2021-12-07 05:51:06', '2021-12-07 05:51:06'),
  (13, 'Essence', 'Routine', 'public/images/tags/1718488029888911.jpeg', '1', '2021-12-07 05:51:37', '2021-12-07 05:51:37');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `taxes`
  --
  
  CREATE TABLE `taxes` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `rate` double NOT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `transfers`
  --
  
  CREATE TABLE `transfers` (
    `id` int(10) UNSIGNED NOT NULL,
    `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(11) NOT NULL,
    `status` int(11) NOT NULL,
    `from_warehouse_id` int(11) NOT NULL,
    `to_warehouse_id` int(11) NOT NULL,
    `item` int(11) NOT NULL,
    `total_qty` double NOT NULL,
    `total_tax` double NOT NULL,
    `total_cost` double NOT NULL,
    `shipping_cost` double DEFAULT NULL,
    `grand_total` double NOT NULL,
    `document` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` date DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `transfers`
  --
  
  INSERT INTO `transfers` (`id`, `reference_no`, `user_id`, `status`, `from_warehouse_id`, `to_warehouse_id`, `item`, `total_qty`, `total_tax`, `total_cost`, `shipping_cost`, `grand_total`, `document`, `note`, `created_at`, `updated_at`) VALUES
  (3, 'tr-20211204-092527', 1, 1, 1, 2, 1, 1, 0, 400, NULL, 400, NULL, NULL, '2021-12-01', '2021-12-04 03:25:27');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `units`
  --
  
  CREATE TABLE `units` (
    `id` int(10) UNSIGNED NOT NULL,
    `unit_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `unit_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `base_unit` int(11) DEFAULT NULL,
    `operator` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `operation_value` double DEFAULT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `units`
  --
  
  INSERT INTO `units` (`id`, `unit_code`, `unit_name`, `base_unit`, `operator`, `operation_value`, `is_active`, `created_at`, `updated_at`) VALUES
  (1, 'pc', 'Piece', NULL, '*', 1, 1, '2018-05-12 02:27:46', '2018-08-17 21:41:53'),
  (2, 'dozen', 'dozen box', 1, '*', 12, 1, '2018-05-12 09:57:05', '2018-05-12 09:57:05'),
  (3, 'cartoon', 'cartoon box', 1, '*', 24, 1, '2018-05-12 09:57:45', '2020-03-11 10:36:59'),
  (4, 'm', 'meter', NULL, '*', 1, 1, '2018-05-12 09:58:07', '2018-05-27 23:20:57'),
  (6, 'test', 'test', NULL, '*', 1, 0, '2018-05-27 23:20:20', '2018-05-27 23:20:25'),
  (7, 'kg', 'kilogram', NULL, '*', 1, 1, '2018-06-25 00:49:26', '2018-06-25 00:49:26'),
  (8, '20', 'ni33', 8, '*', 1, 0, '2018-07-31 22:35:51', '2018-07-31 22:40:54'),
  (9, 'gm', 'gram', 7, '/', 1000, 1, '2018-09-01 00:06:28', '2018-09-01 00:06:28'),
  (10, 'gz', 'goz', NULL, '*', 1, 0, '2018-11-29 03:40:29', '2019-03-02 11:53:29'),
  (11, '70331946', 'Sample', 7, 'safi', 12, 1, '2020-12-03 02:49:38', '2020-12-03 02:49:38');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE `users` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `company_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `role_id` int(11) NOT NULL,
    `biller_id` int(11) DEFAULT NULL,
    `warehouse_id` int(11) DEFAULT NULL,
    `is_active` tinyint(1) NOT NULL,
    `is_deleted` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `users`
  --
  
  INSERT INTO `users` (`id`, `name`, `email`, `password`, `remember_token`, `phone`, `company_name`, `role_id`, `biller_id`, `warehouse_id`, `is_active`, `is_deleted`, `created_at`, `updated_at`) VALUES
  (1, 'admin', 'admin@acquaintbd.com', '$2y$10$zx7xatY7N0zgdDuNTxR7du8OeXWql86mpksOEfDMs3YEk.bo3.6qW', 'yv0lJywXY3hD8uvRBY0mX1NPitGEi2viuwQXQBEkzpYM6kCGbEeuHUscifS2', '12112', 'Acquaint Technologies', 1, NULL, NULL, 1, 0, '2018-06-02 03:24:15', '2021-01-21 03:58:42'),
  (3, 'dhiman da', 'dhiman@gmail.com', '$2y$10$Fef6vu5E67nm11hX7V5a2u1ThNCQ6n9DRCvRF9TD7stk.Pmt2R6O.', '5ehQM6JIfiQfROgTbB5let0Z93vjLHS7rd9QD5RPNgOxli3xdo7fykU7vtTt', '212', 'lioncoders', 1, NULL, NULL, 0, 1, '2018-06-13 22:00:31', '2020-11-05 07:06:51'),
  (6, 'test', 'test@gmail.com', '$2y$10$TDAeHcVqHyCmurki0wjLZeIl1SngKX3WLOhyTiCoZG3souQfqv.LS', 'KpW1gYYlOFacumklO2IcRfSsbC3KcWUZzOI37gqoqM388Xie6KdhaOHIFEYm', '1234', '212312', 4, NULL, NULL, 0, 1, '2018-06-23 03:05:33', '2018-06-23 03:13:45'),
  (8, 'test', 'test@yahoo.com', '$2y$10$hlMigidZV0j2/IPkgE/xsOSb8WM2IRlsMv.1hg1NM7kfyd6bGX3hC', NULL, '31231', NULL, 4, NULL, NULL, 0, 1, '2018-06-24 22:35:49', '2018-07-02 01:07:39'),
  (9, 'staff', 'anda@gmail.com', '$2y$10$A1v6PDzJcd6O/oXmiGR0PeQ9PrSV2t/358KGKQmvGKHF5/YEgGuhm', 'CDYfUSB3xU1XQW7jcYafo4xO6LKkTTYhFNMQksn9fTD90ucljLVJ6iW4omjI', '3123', 'AtechPOS', 4, 1, 1, 1, 0, '2018-07-02 01:08:08', '2021-10-17 03:09:02'),
  (10, 'testadmin', 'testadmin@acquaintbd.com', '$2y$10$d6Rtw/1SXDg8ZtNwL98ePu9xXbbpu6ts8iPAuSv8NbTDmyogQh1ra', 'pDGTv0V5qFUD2KrdoU9eORPYuYHeQnvw7lGiaq08Q4X1gsVHG3G6gfCbsQz9', '123423123', 'Acquaint Technologies', 1, NULL, NULL, 1, 0, '2018-09-07 23:44:48', '2021-01-21 03:57:38'),
  (11, 'teststaff', 'a@a.com', '$2y$10$5KNBIIhZzvvZEQEhkHaZGu.Q8bbQNfqYvYgL5N55B8Pb4P5P/b/Li', 'DkHDEcCA0QLfsKPkUK0ckL0CPM6dPiJytNa0k952gyTbeAyMthW3vi7IRitp', '111', 'aa', 4, 5, 1, 0, 1, '2018-10-22 02:47:56', '2018-10-23 02:10:56'),
  (12, 'john', 'john@gmail.com', '$2y$10$P/pN2J/uyTYNzQy2kRqWwuSv7P2f6GE/ykBwtHdda7yci3XsfOKWe', 'O0f1WJBVjT5eKYl3Js5l1ixMMtoU6kqrH7hbHDx9I1UCcD9CmiSmCBzHbQZg', '10001', NULL, 4, 2, 2, 0, 1, '2018-12-30 00:48:37', '2019-03-06 04:59:49'),
  (13, 'jjj', 'test@test.com', '$2y$10$/Qx3gHWYWUhlF1aPfzXaCeZA7fRzfSEyCIOnk/dcC4ejO8PsoaalG', NULL, '1213', NULL, 1, NULL, NULL, 0, 1, '2019-01-03 00:08:31', '2019-03-03 04:02:29'),
  (19, 'shakalaka', 'shakalaka@gmail.com', '$2y$10$ketLWT0Ib/JXpo00eJlxoeSw.7leS8V1CUGInfbyOWT4F5.Xuo7S2', NULL, '1212', 'Digital image', 5, NULL, NULL, 0, 1, '2020-11-09 00:07:16', '2021-10-31 10:16:13'),
  (21, 'modon', 'modon@gmail.com', '$2y$10$7VpoeGMkP8QCvL5zLwFW..6MYJ5MRumDLDoX.TTQtClS561rpFHY.', NULL, '2222', 'modon company', 5, NULL, NULL, 0, 1, '2020-11-13 07:12:08', '2021-10-31 10:16:13'),
  (22, 'dhiman', 'dhiman@gmail.com', '$2y$10$3mPygsC6wwnDtw/Sg85IpuExtUhgaHx52Lwp7Rz0.FNfuFdfKVpRq', NULL, '+8801111111101', 'lioncoders', 5, NULL, NULL, 0, 1, '2020-11-15 06:14:58', '2021-10-31 10:16:13'),
  (27, 'customer', 'customer@gmail.com', '$2y$10$fzFP.skqLyjrbgUQ9D/fvuM8avi9ySy96PjQcLA0DvxG9pv96LtE6', NULL, '01521100281', 'Acquaint Technologies', 5, NULL, NULL, 0, 1, '2020-11-30 23:21:19', '2021-10-31 10:16:13'),
  (28, 'Sahid', 'sahid@gmail.com', '$2y$10$zx7xatY7N0zgdDuNTxR7du8OeXWql86mpksOEfDMs3YEk.bo3.6qW', NULL, '01911160762', 'Acquaint Technologies', 1, NULL, NULL, 0, 1, '2020-11-30 23:29:10', '2021-10-31 10:16:13'),
  (29, 'safi ul', 'safiul@gmail.com', '$2y$10$r0c5672vQK6N.F6t./jP3OWTj2s.UBiox6tFV33mJz4cXfyhDociK', NULL, '01521100281', 'Acquaint Technologies', 2, NULL, NULL, 0, 1, '2020-12-01 00:51:48', '2021-10-31 10:16:13'),
  (30, 'nur', 'nur@gmail.com', '$2y$10$860RC4Bi4OzY.MrVwXNpEuMBQd7EsUrZfRKs25nPAPSk4RZ/Ec3me', NULL, '01911160762', 'Acquaint Technologies', 4, 1, 1, 0, 1, '2020-12-01 00:54:29', '2021-10-31 10:16:13'),
  (31, 'Rafi Ul Sahid', 'rafi@gmail.com', '$2y$10$GcOyJlKbcbn3x5hDHwaBxeL.iYEAyyWMkjwBmNCPk0OQsW42pzKjG', NULL, '01717626265', 'Bangla Trac Ltd', 2, NULL, NULL, 0, 1, '2020-12-02 22:50:01', '2021-10-31 10:16:28'),
  (32, 'khadem', 'mim@gmail.com', '$2y$10$pIbQy5mhA4mmHe2AQhhuXOHdSt4kAhBsyCKFau0EDXj.l5bkNiQl.', NULL, '01922270873', 'khadem', 5, 1, 1, 0, 1, '2021-01-16 22:40:32', '2021-10-31 10:16:28'),
  (33, 'karim', 'karim@gmail.com', '$2y$10$fUPj.ReEuy6pRaK/TteHa.VYV2N1i7hzBdE6RK.Om/m3gYAjUh7Q6', NULL, '01521100281', 'dream', 5, NULL, NULL, 0, 1, '2021-01-17 00:02:42', '2021-10-31 10:16:28'),
  (34, 'Robiul', 'robi@gmail.com', '$2y$10$/pMLi6I2zGYYBrQyif/.2.QNe.or2QdzidnQk/zqD7bGH.Io1Zg96', NULL, '0155522811', 'None', 5, 1, 1, 0, 1, '2021-01-17 00:22:53', '2021-10-31 10:16:28'),
  (35, 'sunny', 'sun@gmail.com', '$2y$10$mCo0R8.wbBWs9qS8h9eWY.CueD7yuUyNDKp7ZPYaxD30tW.t54FUi', NULL, '01632211392', 'None', 5, 1, 1, 0, 1, '2021-01-17 22:22:10', '2021-10-31 10:16:28'),
  (36, 'safi123', 'safi@gmail.com', '$2y$10$BNNfjd1zNgV2KQiGMuktgedNKVAE2pS2jafHEkFpHUoglSQ9jhDkC', NULL, '01778744654', 'Delware', 5, NULL, NULL, 0, 1, '2021-06-03 04:46:34', '2021-10-31 10:16:28'),
  (37, 'jal97', 'jalal@gmail.com', '$2y$10$gHcJtklqqakuxh8b2nSPOOZCaZaCYUDxxhh7AfcpCkt2/8sGgYIGu', NULL, '526565454', NULL, 5, NULL, NULL, 1, 0, '2021-11-29 02:45:45', '2021-11-29 02:45:45'),
  (38, 'mou100', 'mou@gmail.com', '$2y$10$rGJfkGuKbGsT3BlaRBX41uRV9rt6C26rA9j8t51sDwIP7GV3VWCIe', NULL, '01211255166', NULL, 5, NULL, NULL, 1, 0, '2021-11-29 05:00:19', '2021-11-29 05:00:19');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `variants`
  --
  
  CREATE TABLE `variants` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `variants`
  --
  
  INSERT INTO `variants` (`id`, `name`, `created_at`, `updated_at`) VALUES
  (1, 'S', '2021-11-04 03:24:01', '2021-11-04 03:24:01'),
  (2, 'M', '2021-11-04 03:24:01', '2021-11-04 03:24:01'),
  (3, 'L', '2021-11-04 03:24:01', '2021-11-04 03:24:01');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `warehouses`
  --
  
  CREATE TABLE `warehouses` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `is_active` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `warehouses`
  --
  
  INSERT INTO `warehouses` (`id`, `name`, `phone`, `email`, `address`, `is_active`, `created_at`, `updated_at`) VALUES
  (1, 'warehouse 1', '2312121', 'war1@lion.com', 'khatungonj, chittagong', 1, '2018-05-12 07:51:44', '2019-03-02 15:40:17'),
  (2, 'warehouse 2', '1234', NULL, 'boropul, chittagong', 1, '2018-05-12 08:09:03', '2018-06-19 22:30:38'),
  (3, 'warehouse 3', '01521100281', 'warehouse3@gmail.com', 'New warehouse', 1, '2020-12-03 02:42:13', '2020-12-03 02:42:13');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `accounts`
  --
  ALTER TABLE `accounts`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `adjustments`
  --
  ALTER TABLE `adjustments`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `attendances`
  --
  ALTER TABLE `attendances`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `billers`
  --
  ALTER TABLE `billers`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `blogs`
  --
  ALTER TABLE `blogs`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `brands`
  --
  ALTER TABLE `brands`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `carts`
  --
  ALTER TABLE `carts`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `cash_registers`
  --
  ALTER TABLE `cash_registers`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `categories`
  --
  ALTER TABLE `categories`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `checkouts`
  --
  ALTER TABLE `checkouts`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `colors`
  --
  ALTER TABLE `colors`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `contacts`
  --
  ALTER TABLE `contacts`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `coupons`
  --
  ALTER TABLE `coupons`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `currencies`
  --
  ALTER TABLE `currencies`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `customers`
  --
  ALTER TABLE `customers`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `customer_groups`
  --
  ALTER TABLE `customer_groups`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `deliveries`
  --
  ALTER TABLE `deliveries`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `departments`
  --
  ALTER TABLE `departments`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `deposits`
  --
  ALTER TABLE `deposits`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `employees`
  --
  ALTER TABLE `employees`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `expenses`
  --
  ALTER TABLE `expenses`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `expense_categories`
  --
  ALTER TABLE `expense_categories`
    ADD PRIMARY KEY (`id`);
  
  --
  -- 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`);
  
  --
  -- Indexes for table `gift_cards`
  --
  ALTER TABLE `gift_cards`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `gift_card_recharges`
  --
  ALTER TABLE `gift_card_recharges`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `holidays`
  --
  ALTER TABLE `holidays`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `hrm_settings`
  --
  ALTER TABLE `hrm_settings`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `languages`
  --
  ALTER TABLE `languages`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `money_transfers`
  --
  ALTER TABLE `money_transfers`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `newsletters`
  --
  ALTER TABLE `newsletters`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `notifications`
  --
  ALTER TABLE `notifications`
    ADD PRIMARY KEY (`id`),
    ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);
  
  --
  -- Indexes for table `orders`
  --
  ALTER TABLE `orders`
    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`);
  
  --
  -- Indexes for table `payment_with_cheque`
  --
  ALTER TABLE `payment_with_cheque`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `payment_with_credit_card`
  --
  ALTER TABLE `payment_with_credit_card`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `payment_with_gift_card`
  --
  ALTER TABLE `payment_with_gift_card`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `payment_with_paypal`
  --
  ALTER TABLE `payment_with_paypal`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `payrolls`
  --
  ALTER TABLE `payrolls`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `permissions`
  --
  ALTER TABLE `permissions`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `pos_setting`
  --
  ALTER TABLE `pos_setting`
    ADD UNIQUE KEY `pos_setting_id_unique` (`id`);
  
  --
  -- Indexes for table `products`
  --
  ALTER TABLE `products`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `product_adjustments`
  --
  ALTER TABLE `product_adjustments`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `product_purchases`
  --
  ALTER TABLE `product_purchases`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `product_quotation`
  --
  ALTER TABLE `product_quotation`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `product_returns`
  --
  ALTER TABLE `product_returns`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `product_sales`
  --
  ALTER TABLE `product_sales`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `product_tags`
  --
  ALTER TABLE `product_tags`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `product_transfer`
  --
  ALTER TABLE `product_transfer`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `product_variants`
  --
  ALTER TABLE `product_variants`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `product_warehouse`
  --
  ALTER TABLE `product_warehouse`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `purchases`
  --
  ALTER TABLE `purchases`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `purchase_product_return`
  --
  ALTER TABLE `purchase_product_return`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `quotations`
  --
  ALTER TABLE `quotations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `report_settings`
  --
  ALTER TABLE `report_settings`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `returns`
  --
  ALTER TABLE `returns`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `return_purchases`
  --
  ALTER TABLE `return_purchases`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `roles`
  --
  ALTER TABLE `roles`
    ADD PRIMARY KEY (`id`);
  
  --
  -- 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`);
  
  --
  -- Indexes for table `stock_counts`
  --
  ALTER TABLE `stock_counts`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `suppliers`
  --
  ALTER TABLE `suppliers`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `tags`
  --
  ALTER TABLE `tags`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `taxes`
  --
  ALTER TABLE `taxes`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `transfers`
  --
  ALTER TABLE `transfers`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `units`
  --
  ALTER TABLE `units`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `variants`
  --
  ALTER TABLE `variants`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `warehouses`
  --
  ALTER TABLE `warehouses`
    ADD PRIMARY KEY (`id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `accounts`
  --
  ALTER TABLE `accounts`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `adjustments`
  --
  ALTER TABLE `adjustments`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `attendances`
  --
  ALTER TABLE `attendances`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `billers`
  --
  ALTER TABLE `billers`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
  
  --
  -- AUTO_INCREMENT for table `blogs`
  --
  ALTER TABLE `blogs`
    MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  
  --
  -- AUTO_INCREMENT for table `brands`
  --
  ALTER TABLE `brands`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `carts`
  --
  ALTER TABLE `carts`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
  
  --
  -- AUTO_INCREMENT for table `cash_registers`
  --
  ALTER TABLE `cash_registers`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `categories`
  --
  ALTER TABLE `categories`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `checkouts`
  --
  ALTER TABLE `checkouts`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `colors`
  --
  ALTER TABLE `colors`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `contacts`
  --
  ALTER TABLE `contacts`
    MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `coupons`
  --
  ALTER TABLE `coupons`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `currencies`
  --
  ALTER TABLE `currencies`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `customers`
  --
  ALTER TABLE `customers`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT for table `customer_groups`
  --
  ALTER TABLE `customer_groups`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT for table `deliveries`
  --
  ALTER TABLE `deliveries`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `departments`
  --
  ALTER TABLE `departments`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `deposits`
  --
  ALTER TABLE `deposits`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `employees`
  --
  ALTER TABLE `employees`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `expenses`
  --
  ALTER TABLE `expenses`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `expense_categories`
  --
  ALTER TABLE `expense_categories`
    MODIFY `id` int(10) 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` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `gift_cards`
  --
  ALTER TABLE `gift_cards`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `gift_card_recharges`
  --
  ALTER TABLE `gift_card_recharges`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `holidays`
  --
  ALTER TABLE `holidays`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `hrm_settings`
  --
  ALTER TABLE `hrm_settings`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `languages`
  --
  ALTER TABLE `languages`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=122;
  
  --
  -- AUTO_INCREMENT for table `money_transfers`
  --
  ALTER TABLE `money_transfers`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `newsletters`
  --
  ALTER TABLE `newsletters`
    MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
  
  --
  -- AUTO_INCREMENT for table `orders`
  --
  ALTER TABLE `orders`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `payments`
  --
  ALTER TABLE `payments`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=141;
  
  --
  -- AUTO_INCREMENT for table `payment_with_cheque`
  --
  ALTER TABLE `payment_with_cheque`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;
  
  --
  -- AUTO_INCREMENT for table `payment_with_credit_card`
  --
  ALTER TABLE `payment_with_credit_card`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `payment_with_gift_card`
  --
  ALTER TABLE `payment_with_gift_card`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `payment_with_paypal`
  --
  ALTER TABLE `payment_with_paypal`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `payrolls`
  --
  ALTER TABLE `payrolls`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `permissions`
  --
  ALTER TABLE `permissions`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=109;
  
  --
  -- AUTO_INCREMENT for table `products`
  --
  ALTER TABLE `products`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
  
  --
  -- AUTO_INCREMENT for table `product_adjustments`
  --
  ALTER TABLE `product_adjustments`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `product_purchases`
  --
  ALTER TABLE `product_purchases`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=108;
  
  --
  -- AUTO_INCREMENT for table `product_quotation`
  --
  ALTER TABLE `product_quotation`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `product_returns`
  --
  ALTER TABLE `product_returns`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `product_sales`
  --
  ALTER TABLE `product_sales`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92;
  
  --
  -- AUTO_INCREMENT for table `product_tags`
  --
  ALTER TABLE `product_tags`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
  
  --
  -- AUTO_INCREMENT for table `product_transfer`
  --
  ALTER TABLE `product_transfer`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `product_variants`
  --
  ALTER TABLE `product_variants`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `product_warehouse`
  --
  ALTER TABLE `product_warehouse`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
  
  --
  -- AUTO_INCREMENT for table `purchases`
  --
  ALTER TABLE `purchases`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT for table `purchase_product_return`
  --
  ALTER TABLE `purchase_product_return`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `quotations`
  --
  ALTER TABLE `quotations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `report_settings`
  --
  ALTER TABLE `report_settings`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `returns`
  --
  ALTER TABLE `returns`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `return_purchases`
  --
  ALTER TABLE `return_purchases`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `roles`
  --
  ALTER TABLE `roles`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT for table `sales`
  --
  ALTER TABLE `sales`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=93;
  
  --
  -- AUTO_INCREMENT for table `stock_counts`
  --
  ALTER TABLE `stock_counts`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `suppliers`
  --
  ALTER TABLE `suppliers`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `tags`
  --
  ALTER TABLE `tags`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
  
  --
  -- AUTO_INCREMENT for table `taxes`
  --
  ALTER TABLE `taxes`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `transfers`
  --
  ALTER TABLE `transfers`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `units`
  --
  ALTER TABLE `units`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
  
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;
  
  --
  -- AUTO_INCREMENT for table `variants`
  --
  ALTER TABLE `variants`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `warehouses`
  --
  ALTER TABLE `warehouses`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `role_has_permissions`
  --
  ALTER TABLE `role_has_permissions`
    ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
  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 */;
  