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

START TRANSACTION;



--
-- Database: `mcwtop_pos2`
--

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

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

CREATE TABLE `accounts` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_no` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `initial_balance` double DEFAULT NULL,
  `total_balance` double NOT NULL,
  `note` text DEFAULT NULL,
  `is_default` tinyint(1) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `type` varchar(255) NOT NULL DEFAULT 'Bank Account',
  `parent_account_id` int(11) DEFAULT NULL,
  `is_payment` tinyint(1) NOT NULL DEFAULT 1
) 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`, `code`, `type`, `parent_account_id`, `is_payment`) VALUES
(1, '11111', 'Sales Accounts', 1000, 1000, 'this is first account', 1, 1, '2018-12-18 02:58:02', '2024-03-12 07:57:50', NULL, 'Bank Account', NULL, 1),
(3, '21211', 'Sa', NULL, 0, NULL, 0, 1, '2018-12-18 02:58:56', '2019-01-20 09:59:06', NULL, 'Bank Account', NULL, 1),
(5, 'bank-1', 'zuhair', 100000, 100000, NULL, NULL, 1, '2022-11-28 05:58:18', '2022-11-28 05:58:18', NULL, 'Bank Account', NULL, 1);

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

--
-- Table structure for table `adjustments`
--

CREATE TABLE `adjustments` (
  `id` int(10) UNSIGNED NOT NULL,
  `reference_no` varchar(191) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `document` varchar(191) DEFAULT NULL,
  `total_qty` double NOT NULL,
  `item` int(11) NOT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- 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(255) NOT NULL,
  `checkout` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `barcodes`
--

CREATE TABLE `barcodes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `width` double(22,4) DEFAULT NULL,
  `height` double(22,4) DEFAULT NULL,
  `paper_width` double(22,4) DEFAULT NULL,
  `paper_height` double(22,4) DEFAULT NULL,
  `top_margin` double(22,4) DEFAULT NULL,
  `left_margin` double(22,4) DEFAULT NULL,
  `row_distance` double(22,4) DEFAULT NULL,
  `col_distance` double(22,4) DEFAULT NULL,
  `stickers_in_one_row` int(11) DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `is_continuous` tinyint(1) NOT NULL DEFAULT 0,
  `stickers_in_one_sheet` int(11) DEFAULT NULL,
  `is_custom` int(11) 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 `barcodes`
--

INSERT INTO `barcodes` (`id`, `name`, `description`, `width`, `height`, `paper_width`, `paper_height`, `top_margin`, `left_margin`, `row_distance`, `col_distance`, `stickers_in_one_row`, `is_default`, `is_continuous`, `stickers_in_one_sheet`, `is_custom`, `created_at`, `updated_at`) VALUES
(7, '20 Labels per Sheet', 'Sheet Size: 8.5\" x 11\", Label Size: 4\" x 1\", Label...', 4.0000, 1.0000, 8.5000, 11.0000, 0.5000, 0.1250, 0.0000, 0.1875, 2, 0, 0, 20, NULL, NULL, NULL),
(8, '30 Labels per sheet', 'Sheet Size: 8.5\" x 11\", Label Size: 2.625\" x 1\", Labels per sheet: 30', 2.6250, 1.0000, 8.5000, 11.0000, 0.5000, 0.1880, 0.0000, 0.1250, 3, 0, 0, 30, NULL, NULL, NULL),
(9, '32 Labels per sheet', 'Sheet Size: 8.5\" x 11\", Label Size: 2\" x 1.25\", Labels per sheet: 32', 2.0000, 1.2500, 8.5000, 11.0000, 0.5000, 0.2500, 0.0000, 0.0000, 4, 0, 0, 32, NULL, NULL, NULL),
(10, '40 Labels per sheet', 'Sheet Size: 8.5\" x 11\", Label Size: 2\" x 1\", Labels per sheet: 40', 2.0000, 1.0000, 8.5000, 11.0000, 0.5000, 0.2500, 0.0000, 0.0000, 4, 0, 0, 40, NULL, NULL, NULL),
(11, '50 Labels per Sheet', 'Sheet Size: 8.5\" x 11\", Label Size: 1.5\" x 1\", Labels per sheet: 50', 1.5000, 1.0000, 8.5000, 11.0000, 0.5000, 0.5000, 0.0000, 0.0000, 5, 0, 0, 50, NULL, NULL, NULL),
(12, 'Continuous Rolls - 31.75mm x 25.4mm', 'Label Size: 31.75mm x 25.4mm, Gap: 3.18mm', 1.2500, 1.0000, 1.2500, 0.0000, 0.1250, 0.0000, 0.1250, 0.0000, 1, 0, 1, NULL, NULL, NULL, NULL),
(13, 'custom', NULL, 2.0000, 0.5000, 3.0000, NULL, 2.0000, 2.0000, 0.3000, 0.3000, 1, 0, 1, 28, 1, NULL, NULL);

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

--
-- Table structure for table `billers`
--

CREATE TABLE `billers` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `image` varchar(191) DEFAULT NULL,
  `company_name` varchar(191) NOT NULL,
  `vat_number` varchar(191) DEFAULT NULL,
  `email` varchar(191) NOT NULL,
  `phone_number` varchar(191) NOT NULL,
  `address` varchar(191) NOT NULL,
  `city` varchar(191) NOT NULL,
  `state` varchar(191) DEFAULT NULL,
  `postal_code` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `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, 'John Watson', NULL, 'The solution', NULL, 'john@gmail.com', '312313', '36 housing road', 'london', NULL, NULL, 'England', 1, '2024-01-19 13:30:23', '2024-01-19 13:30:23');

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

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

CREATE TABLE `brands` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(191) NOT NULL,
  `image` varchar(191) 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, 'Apple', '20240114102326.png', 1, '2024-01-08 05:25:12', '2024-01-14 16:23:26'),
(2, 'Samsung', '20240114102343.png', 1, '2024-01-08 05:25:12', '2024-01-14 16:23:43'),
(3, 'Huawei', '20240114102512.png', 1, '2024-01-08 05:25:12', '2024-01-14 16:25:12'),
(4, 'Xiaomi', '20240114103640.png', 1, '2024-01-08 05:25:12', '2024-01-14 16:36:40'),
(5, 'Whirlpool', '20240114103701.png', 1, '2024-01-08 05:25:12', '2024-01-14 16:37:01'),
(6, 'Nestle', '20240114103717.png', 1, '2024-01-08 05:25:12', '2024-01-14 16:37:17'),
(7, 'Kraft', '20240114103851.png', 1, '2024-01-08 05:25:12', '2024-01-14 16:38:51'),
(8, 'Kellogs', '20240114103906.png', 1, '2024-01-08 05:25:12', '2024-01-14 16:39:06'),
(9, 'Unilever', '20240114103928.png', 1, '2024-01-08 05:25:12', '2024-01-14 16:39:28'),
(10, 'LG', '20240114103943.png', 1, '2024-01-08 05:25:12', '2024-01-14 16:39:43'),
(11, 'Haier', '20240114102407.png', 1, '2024-01-08 05:25:12', '2024-01-14 16:24:07'),
(12, 'Bosch', '20240114103618.png', 1, '2024-01-08 05:25:12', '2024-01-14 16:36:18'),
(13, 'Siemens', '20240114104008.png', 1, '2024-01-08 05:25:12', '2024-01-14 16:40:08'),
(14, 'Philips', '20240114104027.png', 1, '2024-01-08 05:25:12', '2024-01-14 16:40:27'),
(15, 'Nike', '20240114104052.png', 1, '2024-01-08 05:25:12', '2024-01-14 16:40:52'),
(16, 'Adidas', '20240114104112.png', 1, '2024-01-08 05:25:12', '2024-01-14 16:41:12'),
(17, 'Canon', '20240114034815.png', 1, '2024-01-14 09:48:15', '2024-01-14 09:48:15'),
(18, 'Omega', '20240119071354.jpg', 1, '2024-01-19 13:13:54', '2024-01-19 13:14:59'),
(19, 'jhakanaka', NULL, 1, '2024-04-29 12:28:31', '2024-04-29 12:28:31');

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

--
-- 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, 100, 1, 2, 0, '2024-01-19 14:46:52', '2024-08-25 23:03:17'),
(2, 150, 1, 1, 0, '2024-01-19 14:47:08', '2024-08-25 23:03:24'),
(3, 200, 1, 1, 1, '2024-08-25 23:04:20', '2024-08-25 23:04:20');

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

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

CREATE TABLE `categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `image` varchar(191) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `woocommerce_category_id` int(11) DEFAULT NULL,
  `is_sync_disable` tinyint(4) 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`, `woocommerce_category_id`, `is_sync_disable`, `created_at`, `updated_at`) VALUES
(1, 'Smartphone & Gadges', NULL, NULL, 1, NULL, NULL, '2024-01-04 19:22:14', '2024-01-08 06:22:02'),
(2, 'Phone Accessories', NULL, 1, 1, NULL, NULL, '2024-01-04 19:22:14', '2024-01-08 06:22:03'),
(3, 'iPhone', NULL, 1, 1, NULL, NULL, '2024-01-04 19:22:14', '2024-01-08 06:22:03'),
(4, 'Samsung', NULL, 1, 1, NULL, NULL, '2024-01-04 19:22:14', '2024-01-08 06:22:03'),
(5, 'Phone Cases', NULL, 1, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:03'),
(6, 'Laptops & Computers', NULL, NULL, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:03'),
(7, 'Keyboards', NULL, 6, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:03'),
(8, 'Laptop Bags', NULL, 6, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:04'),
(9, 'Mouses', NULL, 6, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:04'),
(10, 'Webcams', NULL, 6, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:04'),
(11, 'Monitors', NULL, 6, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:04'),
(12, 'Smartwatches', NULL, NULL, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:04'),
(13, 'Sport Watches', NULL, 12, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:05'),
(14, 'Kids Watches', NULL, 12, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:05'),
(15, 'Women Watches', NULL, 12, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:05'),
(16, 'Men Watches', NULL, 12, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:05'),
(17, 'Appliances', '20240117121109.png', NULL, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:05'),
(18, 'Dishwashers', NULL, 17, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:05'),
(19, 'Dryers', NULL, 17, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:05'),
(20, 'Washing machine', NULL, 17, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:05'),
(21, 'Refrigerators', NULL, 17, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:05'),
(22, 'Vacuum cleaners', NULL, 17, 1, NULL, NULL, '2024-01-04 19:22:15', '2024-01-08 06:22:05'),
(23, 'TVs, Audio & Video', NULL, NULL, 1, NULL, NULL, '2024-01-04 19:22:16', '2024-01-08 06:22:05'),
(24, 'Television Accessories', NULL, 23, 1, NULL, NULL, '2024-01-04 19:22:16', '2024-01-08 06:22:05'),
(25, 'HD, DVD Players', NULL, 23, 1, NULL, NULL, '2024-01-04 19:22:16', '2024-01-08 06:22:05'),
(26, 'TV-DVD Combos', NULL, 23, 1, NULL, NULL, '2024-01-04 19:22:16', '2024-01-08 06:22:05'),
(27, 'Projectors', NULL, 23, 1, NULL, NULL, '2024-01-04 19:22:16', '2024-01-08 06:22:05'),
(28, 'Projection Screen', NULL, 23, 1, NULL, NULL, '2024-01-04 19:22:16', '2024-01-08 06:22:05'),
(29, 'Fruits & Vegetables', NULL, NULL, 1, NULL, NULL, '2024-01-04 19:22:16', '2024-01-08 06:22:05'),
(30, 'Dairy & Egg', NULL, NULL, 1, NULL, NULL, '2024-01-04 19:22:16', '2024-01-08 06:22:05'),
(31, 'Meat & Fish', NULL, NULL, 1, NULL, NULL, '2024-01-04 19:22:16', '2024-01-08 06:22:05'),
(32, 'Sauces & Pickles', NULL, NULL, 0, NULL, NULL, '2024-01-04 19:22:16', '2024-01-08 06:22:05'),
(33, 'Candy & Chocolates', NULL, NULL, 1, NULL, NULL, '2024-01-04 19:22:16', '2024-01-08 06:22:05'),
(34, 'Foods', NULL, NULL, 1, NULL, NULL, '2024-01-04 19:22:16', '2024-01-08 06:22:05'),
(35, 'Cooking', NULL, 34, 1, NULL, NULL, '2024-01-04 19:22:16', '2024-01-08 06:22:05'),
(36, 'Breakfast', NULL, 34, 1, NULL, NULL, '2024-01-04 19:22:16', '2024-01-08 06:22:05'),
(37, 'Beverages', NULL, 34, 1, NULL, NULL, '2024-01-04 19:22:16', '2024-01-08 06:22:05'),
(38, 'BackPack', '20240119070653.jpg', NULL, 1, NULL, NULL, NULL, NULL),
(40, 'spices', NULL, NULL, 1, NULL, NULL, '2024-04-29 12:28:15', '2024-04-29 12:28:15');

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

--
-- Table structure for table `challans`
--

CREATE TABLE `challans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reference_no` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `courier_id` int(11) NOT NULL,
  `packing_slip_list` longtext NOT NULL,
  `amount_list` longtext NOT NULL,
  `cash_list` longtext DEFAULT NULL,
  `online_payment_list` longtext DEFAULT NULL,
  `cheque_list` longtext DEFAULT NULL,
  `delivery_charge_list` longtext DEFAULT NULL,
  `status_list` longtext DEFAULT NULL,
  `closing_date` date DEFAULT NULL,
  `created_by_id` int(11) NOT NULL,
  `closed_by_id` int(11) 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 `challans`
--

INSERT INTO `challans` (`id`, `reference_no`, `status`, `courier_id`, `packing_slip_list`, `amount_list`, `cash_list`, `online_payment_list`, `cheque_list`, `delivery_charge_list`, `status_list`, `closing_date`, `created_by_id`, `closed_by_id`, `created_at`, `updated_at`) VALUES
(1, '1001', 'Close', 1, '1', '577', '500', '', '77', '50', 'Delivered', '2024-08-11', 1, 1, '2024-08-11 05:27:04', '2024-08-11 05:28:06'),
(2, '1002', 'Active', 1, '2', '599', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2024-08-11 05:39:22', '2024-08-11 05:39:22');

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

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

CREATE TABLE `coupons` (
  `id` int(10) UNSIGNED NOT NULL,
  `code` varchar(191) NOT NULL,
  `type` varchar(191) 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 `couriers`
--

CREATE TABLE `couriers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone_number` varchar(255) NOT NULL,
  `address` text 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;

--
-- Dumping data for table `couriers`
--

INSERT INTO `couriers` (`id`, `name`, `phone_number`, `address`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Fedex', '3122312', 'london,uk', 1, '2024-08-11 05:26:49', '2024-08-11 05:26:49');

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

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

CREATE TABLE `currencies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `code` varchar(191) NOT NULL,
  `exchange_rate` double NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `currencies` (`id`, `name`, `code`, `exchange_rate`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Bangladeshi Taka', 'BDT', 1, 1, '2020-11-01 00:22:58', '2025-09-28 17:02:00'),
(2, 'Euro', 'Euro', 0.95, 0, '2020-11-01 01:29:12', '2025-09-28 17:02:13'),
(3, 'Bangladeshi Taka', 'BDT', 110, 0, '2023-09-06 07:05:29', '2023-09-06 07:05:46');

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

--
-- 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) NOT NULL,
  `company_name` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `phone_number` varchar(191) NOT NULL,
  `tax_no` varchar(191) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(191) DEFAULT NULL,
  `postal_code` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `points` double 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,
  `ecom` varchar(255) DEFAULT NULL,
  `dsf` varchar(255) DEFAULT 'df',
  `arabic_name` varchar(255) DEFAULT NULL,
  `admin` varchar(255) DEFAULT NULL,
  `franchise_location` varchar(255) DEFAULT NULL,
  `customer_type` varchar(255) DEFAULT 'Same as Customer',
  `customer_assigned_to` varchar(255) DEFAULT 'Advocate',
  `assigned` varchar(255) DEFAULT 'Advocate',
  `aaaaaaaa` varchar(255) DEFAULT 'aa',
  `district` varchar(255) 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`, `points`, `deposit`, `expense`, `is_active`, `created_at`, `updated_at`, `ecom`, `dsf`, `arabic_name`, `admin`, `franchise_location`, `customer_type`, `customer_assigned_to`, `assigned`, `aaaaaaaa`, `district`) VALUES
(1, 1, 44, 'James Bond', 'MI6', NULL, '313131', NULL, '221 Baker Street', 'London', NULL, NULL, 'England', 26, 20, 0, 1, '2024-01-19 13:23:29', '2024-07-11 06:28:52', NULL, 'df', NULL, NULL, NULL, 'Same as Customer', 'Advocate', 'Advocate', 'aa', NULL),
(2, 1, NULL, 'Walk in Customer', NULL, NULL, '231313', NULL, 'Halishahar', 'chittagong', NULL, NULL, 'Bangladesh', 290, NULL, NULL, 1, '2024-01-19 13:31:51', '2025-09-28 17:07:23', NULL, 'df', NULL, NULL, NULL, 'Same as Customer', 'Advocate', 'Advocate', 'aa', NULL),
(4, 1, 46, 'bkk', NULL, 'bkk@bkk.com', '87897', NULL, 'jhkjh', 'gjhgh', NULL, NULL, NULL, NULL, NULL, NULL, 1, '2024-06-10 10:40:15', '2024-06-10 10:40:15', NULL, 'df', NULL, NULL, NULL, 'Same as Customer', 'Advocate', 'Advocate', 'aa', NULL);

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

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

CREATE TABLE `customer_groups` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `percentage` varchar(191) 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, 'Regular', '0', 1, '2024-01-19 13:19:29', '2024-01-19 13:19:29');

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

--
-- Table structure for table `custom_fields`
--

CREATE TABLE `custom_fields` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `belongs_to` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `type` varchar(191) NOT NULL,
  `default_value` text DEFAULT NULL,
  `option_value` text DEFAULT NULL,
  `grid_value` int(11) NOT NULL,
  `is_table` tinyint(1) NOT NULL,
  `is_invoice` tinyint(1) NOT NULL,
  `is_required` tinyint(1) NOT NULL,
  `is_admin` tinyint(1) NOT NULL,
  `is_disable` 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 `deliveries`
--

CREATE TABLE `deliveries` (
  `id` int(10) UNSIGNED NOT NULL,
  `reference_no` varchar(191) NOT NULL,
  `sale_id` int(11) NOT NULL,
  `packing_slip_ids` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `courier_id` int(11) DEFAULT NULL,
  `address` text NOT NULL,
  `delivered_by` varchar(191) DEFAULT NULL,
  `recieved_by` varchar(191) DEFAULT NULL,
  `file` varchar(191) DEFAULT NULL,
  `note` varchar(191) DEFAULT NULL,
  `status` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `deliveries`
--

INSERT INTO `deliveries` (`id`, `reference_no`, `sale_id`, `packing_slip_ids`, `user_id`, `courier_id`, `address`, `delivered_by`, `recieved_by`, `file`, `note`, `status`, `created_at`, `updated_at`) VALUES
(1, 'dr-20240811-112542', 42, '1', 1, 1, 'Halishahar', NULL, NULL, NULL, NULL, '3', '2024-08-11 05:25:42', '2024-08-11 05:28:06'),
(2, 'dr-20240811-113738', 43, '2', 1, 1, 'Halishahar', NULL, NULL, NULL, NULL, '2', '2024-08-11 05:37:38', '2024-08-11 05:39:22');

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

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

CREATE TABLE `departments` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) 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 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 `deposits`
--

INSERT INTO `deposits` (`id`, `amount`, `customer_id`, `user_id`, `note`, `created_at`, `updated_at`) VALUES
(1, 20, 1, 1, NULL, '2024-07-08 05:54:31', '2024-07-08 05:54:31');

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

--
-- Table structure for table `discounts`
--

CREATE TABLE `discounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `applicable_for` varchar(191) NOT NULL,
  `product_list` longtext DEFAULT NULL,
  `valid_from` date NOT NULL,
  `valid_till` date NOT NULL,
  `type` varchar(191) NOT NULL,
  `value` double NOT NULL,
  `minimum_qty` double NOT NULL,
  `maximum_qty` double NOT NULL,
  `days` varchar(191) 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 `discount_plans`
--

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

CREATE TABLE `discount_plan_customers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `discount_plan_id` int(11) NOT NULL,
  `customer_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 `discount_plan_discounts`
--

CREATE TABLE `discount_plan_discounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `discount_id` int(11) NOT NULL,
  `discount_plan_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 `dso_alerts`
--

CREATE TABLE `dso_alerts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_info` longtext NOT NULL,
  `number_of_products` 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 `employees`
--

CREATE TABLE `employees` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `phone_number` varchar(191) NOT NULL,
  `department_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `staff_id` varchar(191) DEFAULT NULL,
  `image` varchar(191) DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `country` varchar(191) 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) 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` double NOT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expenses`
--

INSERT INTO `expenses` (`id`, `reference_no`, `expense_category_id`, `warehouse_id`, `account_id`, `user_id`, `cash_register_id`, `amount`, `note`, `created_at`, `updated_at`) VALUES
(1, 'er-20240119-085023', 1, 1, 1, 1, 2, 200, NULL, '2024-01-19 14:50:23', '2024-01-19 14:50:23'),
(2, 'er-20240119-085046', 1, 2, 1, 1, 1, 120, NULL, '2024-01-19 14:50:46', '2024-01-19 14:50:46'),
(3, 'er-20240825-063016', 1, 2, 1, 1, NULL, 450, NULL, '2024-08-25 23:30:15', '2024-08-25 23:30:16');

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

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

CREATE TABLE `expense_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `code` varchar(191) NOT NULL,
  `name` varchar(191) 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;

--
-- Dumping data for table `expense_categories`
--

INSERT INTO `expense_categories` (`id`, `code`, `name`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Electric Bill', 'Electric Bill', 1, '2024-01-19 14:50:02', '2024-01-19 14:50:02');

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

--
-- Table structure for table `external_services`
--

CREATE TABLE `external_services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `details` longtext DEFAULT NULL,
  `module_status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`module_status`)),
  `active` int(11) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `external_services`
--

INSERT INTO `external_services` (`id`, `name`, `type`, `details`, `module_status`, `active`, `created_at`, `updated_at`) VALUES
(1, 'PayPal', 'payment', 'Client ID,Client Secret;abcd1234,wxyz5678', NULL, 0, NULL, NULL),
(2, 'Stripe', 'payment', 'Public Key,Private Key;efgh1234,stuv5678', NULL, 0, NULL, NULL),
(3, 'Razorpay', 'payment', 'Key,Secret;rzp_test_Y4MCcpHfZNU6rR,3Hr7SDqaZ0G5waN0jsLgsiLx', NULL, 1, NULL, NULL),
(4, 'Paystack', 'payment', 'public_Key,Secret_Key;pk_test_e8d220b7463d64569f0053e78534f38e6b10cf4a,sk_test_6d62cb976e1e0ab43f1e48b2934b0dfc7f32a1fe', NULL, 1, NULL, NULL),
(6, 'Mollie', 'payment', 'api_key;test_dHar4XY7LxsDOtmnkVtjNVWXLSlXsM', NULL, 0, NULL, NULL),
(7, 'Xendit', 'payment', 'secret_key,callback_token;xnd_development_aKJVKYbc4lHkEjcCLzWLrBsKs6jF6nbM6WaCMfnJerP3JW57CLis553XNRdDU,YPZxND92Mt8tdXntTYIEkRX802onZ5OcdKBUzycebuqYvN4n', NULL, 1, NULL, NULL),
(8, 'bkash', 'payment', 'Mode,app_key,app_secret,username,password;sandbox,0vWQuCRGiUX7EPVjQDr0EUAYtc,jcUNPBgbcqEDedNKdvE4G1cAK7D3hCjmJccNPZZBq96QIxxwAMEx,01770618567,D7DaC<*E*eG', NULL, 1, NULL, NULL),
(9, 'sslcommerz', 'payment', 'appkey,appsecret;12341234,asdfa23423', NULL, 1, NULL, NULL),
(10, 'Pesapal', 'payment', 'Mode,Consumer Key,Consumer Secret;sandbox,qkio1BGGYAXTu2JOfm7XSXNruoZsrqEW,osGQ364R49cXKeOYSpaOnT++rHs=', NULL, 1, NULL, NULL);

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

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

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

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

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

CREATE TABLE `general_settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `site_title` varchar(191) NOT NULL,
  `site_logo` varchar(191) DEFAULT NULL,
  `is_rtl` tinyint(1) DEFAULT NULL,
  `currency` varchar(191) NOT NULL,
  `package_id` int(11) DEFAULT NULL,
  `subscription_type` varchar(255) DEFAULT NULL,
  `staff_access` varchar(191) NOT NULL,
  `without_stock` varchar(255) NOT NULL DEFAULT 'no',
  `date_format` varchar(191) NOT NULL,
  `developed_by` varchar(191) DEFAULT NULL,
  `invoice_format` varchar(191) DEFAULT NULL,
  `decimal` int(11) DEFAULT 2,
  `state` int(11) DEFAULT NULL,
  `theme` varchar(191) NOT NULL,
  `modules` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `currency_position` varchar(191) NOT NULL,
  `expiry_date` date DEFAULT NULL,
  `expiry_type` varchar(255) NOT NULL DEFAULT 'days',
  `expiry_value` varchar(255) NOT NULL DEFAULT '0',
  `is_zatca` tinyint(1) DEFAULT NULL,
  `company_name` varchar(191) DEFAULT NULL,
  `vat_registration_number` varchar(191) DEFAULT NULL,
  `is_packing_slip` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `general_settings` (`id`, `site_title`, `site_logo`, `is_rtl`, `currency`, `package_id`, `subscription_type`, `staff_access`, `without_stock`, `date_format`, `developed_by`, `invoice_format`, `decimal`, `state`, `theme`, `modules`, `created_at`, `updated_at`, `currency_position`, `expiry_date`, `expiry_type`, `expiry_value`, `is_zatca`, `company_name`, `vat_registration_number`, `is_packing_slip`) VALUES
(1, 'EasyPOS Pro', '20250928052021.png', 0, '1', NULL, NULL, 'all', 'yes', 'd-m-Y', 'Global MCW', 'standard', 2, 1, 'default.css', 'manufacturing', '2018-07-06 06:13:11', '2025-09-28 17:20:21', 'prefix', NULL, 'days', '0', 0, 'The MCW', '98098007', 1);

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

--
-- Table structure for table `gift_cards`
--

CREATE TABLE `gift_cards` (
  `id` int(10) UNSIGNED NOT NULL,
  `card_no` varchar(191) 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 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) NOT NULL,
  `checkout` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `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 `incomes`
--

CREATE TABLE `incomes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reference_no` varchar(255) NOT NULL,
  `income_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` double NOT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `incomes`
--

INSERT INTO `incomes` (`id`, `reference_no`, `income_category_id`, `warehouse_id`, `account_id`, `user_id`, `cash_register_id`, `amount`, `note`, `created_at`, `updated_at`) VALUES
(1, 'ir-20240811-105709', 1, 1, 1, 1, 2, 100, NULL, '2024-08-11 04:57:09', '2024-08-11 04:57:09'),
(2, 'ir-20241202-100021', 1, 1, 1, 1, 3, 77, NULL, '2024-12-05 06:00:00', '2024-12-03 04:00:21');

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

--
-- Table structure for table `income_categories`
--

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

--
-- Dumping data for table `income_categories`
--

INSERT INTO `income_categories` (`id`, `code`, `name`, `is_active`, `created_at`, `updated_at`) VALUES
(1, '99903833', 'Foreign investment', 1, '2024-08-11 04:56:46', '2024-08-11 04:56:46');

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

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

CREATE TABLE `languages` (
  `id` int(10) UNSIGNED NOT NULL,
  `code` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `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) 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_02_10_074859_add_variant_id_to_product_adjustments_table', 79),
(121, '2021_03_07_093606_create_product_batches_table', 80),
(122, '2021_03_07_093759_add_product_batch_id_to_product_warehouse_table', 80),
(123, '2021_03_07_093900_add_product_batch_id_to_product_purchases_table', 80),
(124, '2021_03_11_132603_add_product_batch_id_to_product_sales_table', 81),
(127, '2021_03_25_125421_add_is_batch_to_products_table', 82),
(128, '2021_05_19_120127_add_product_batch_id_to_product_returns_table', 82),
(130, '2021_05_22_105611_add_product_batch_id_to_purchase_product_return_table', 83),
(131, '2021_05_23_124848_add_product_batch_id_to_product_transfer_table', 84),
(132, '2021_05_26_153106_add_product_batch_id_to_product_quotation_table', 85),
(133, '2021_06_08_213007_create_reward_point_settings_table', 86),
(134, '2021_06_16_104155_add_points_to_customers_table', 87),
(135, '2021_06_17_101057_add_used_points_to_payments_table', 88),
(136, '2021_07_06_132716_add_variant_list_to_products_table', 89),
(137, '2021_09_27_161141_add_is_imei_to_products_table', 90),
(138, '2021_09_28_170052_add_imei_number_to_product_warehouse_table', 91),
(139, '2021_09_28_170126_add_imei_number_to_product_purchases_table', 91),
(140, '2021_10_03_170652_add_imei_number_to_product_sales_table', 92),
(141, '2021_10_10_145214_add_imei_number_to_product_returns_table', 93),
(142, '2021_10_11_104504_add_imei_number_to_product_transfer_table', 94),
(143, '2021_10_12_160107_add_imei_number_to_purchase_product_return_table', 95),
(144, '2021_10_12_205146_add_is_rtl_to_general_settings_table', 96),
(145, '2021_10_23_142451_add_is_approve_to_payments_table', 97),
(146, '2022_01_13_191242_create_discount_plans_table', 97),
(147, '2022_01_14_174318_create_discount_plan_customers_table', 97),
(148, '2022_01_14_202439_create_discounts_table', 98),
(149, '2022_01_16_153506_create_discount_plan_discounts_table', 98),
(150, '2022_02_05_174210_add_order_discount_type_and_value_to_sales_table', 99),
(154, '2022_05_26_195506_add_daily_sale_objective_to_products_table', 100),
(155, '2022_05_28_104209_create_dso_alerts_table', 101),
(156, '2022_06_01_112100_add_is_embeded_to_products_table', 102),
(157, '2022_06_14_130505_add_sale_id_to_returns_table', 103),
(159, '2022_07_19_115504_add_variant_data_to_products_table', 104),
(160, '2022_07_25_194300_add_additional_cost_to_product_variants_table', 104),
(161, '2022_09_04_195610_add_purchase_id_to_return_purchases_table', 105),
(162, '2023_01_18_123842_alter_table_pos_setting', 106),
(164, '2023_01_18_125040_alter_table_general_settings', 107),
(165, '2023_01_18_133701_alter_table_pos_setting', 108),
(166, '2023_01_25_145309_add_expiry_date_to_general_settings_table', 109),
(167, '2023_02_23_125656_alter_table_sales', 110),
(168, '2023_02_26_124100_add_package_id_to_general_settings_table', 111),
(169, '2023_03_04_120325_create_custom_fields_table', 111),
(170, '2023_03_22_174352_add_currency_id_and_exchange_rate_to_returns_table', 112),
(171, '2023_03_27_114320_add_currency_id_and_exchange_rate_to_purchases_table', 113),
(172, '2023_03_27_132747_add_currency_id_and_exchange_rate_to_return_purchases_table', 114),
(173, '2023_04_25_150236_create_mail_settings_table', 115),
(174, '2023_05_13_125424_add_zatca_to_general_settings_table', 116),
(175, '2023_05_28_155540_create_tables_table', 117),
(176, '2023_05_29_115039_add_is_table_to_pos_setting_table', 117),
(177, '2023_05_29_115301_add_table_id_to_sales_table', 117),
(178, '2023_05_31_165049_add_queue_no_to_sales_table', 117),
(190, '2023_08_12_124016_add_staff_id_to_employees_table', 121),
(192, '2023_07_23_160254_create_couriers_table', 122),
(193, '2023_07_23_174343_add_courier_id_to_deliveries_table', 122),
(194, '2023_08_14_142608_add_is_active_to_currencies_table', 122),
(195, '2023_08_24_130203_change_columns_to_attendances_table', 122),
(196, '2023_09_10_134503_add_without_stock_to_general_settings_table', 123),
(204, '2023_09_26_211542_add_modules_to_general_settings_table', 125),
(217, '2023_10_15_124306_add_return_qty_to_product_sales_table', 129),
(219, '2023_12_03_235606_crete_external_services_table', 131),
(221, '2023_03_14_174658_add_subscription_type_to_general_setting_table', 130),
(222, '2024_02_04_131826_add_unit_cost_to_product_adjustments_table', 132),
(223, '2024_02_13_173126_change_modules_to_general_settings_table', 133),
(224, '2024_05_02_114215_add_payment_receiver_to_payments', 134),
(225, '2024_05_06_132553_create_sms_templates_table', 135),
(226, '2024_05_07_102225_add_send_sms_to_pos_setting_table', 135),
(227, '2024_05_07_132625_add_is_default_to_sms_templates_table', 135),
(228, '2024_05_08_112211_change_address_and_city_field_to_nullable_in_customers_table', 135),
(229, '2024_05_08_151050_add_is_default_ecommerce_columne_to_sms_templates_table', 135),
(230, '2024_05_20_182757_add_wholesale_price_to_products_table', 136),
(231, '2024_05_21_170500_add_is_sent_to_transfers_table', 137),
(232, '2023_02_05_132001_add_change_to_payments_table', 138),
(233, '2024_06_04_225113_create_income_categories_table', 138),
(234, '2024_06_04_225128_create_incomes_table', 138),
(235, '2024_06_29_131917_add_is_packing_slip_to_general_settings_table', 138),
(236, '2024_07_05_192531_create_packing_slips_table', 138),
(237, '2024_07_05_193002_create_packing_slip_products_table', 138),
(238, '2024_07_05_194501_add_is_packing_and_delivered_to_product_sales_table', 138),
(239, '2024_07_14_122245_add_delivery_id_to_packing_slips_table', 138),
(240, '2024_07_14_122415_add_variant_id_to_packing_slip_products_table', 138),
(241, '2024_07_14_122519_add_packing_slip_ids_to_deliveries_table', 138),
(242, '2024_07_16_125908_create_challans_table', 138),
(245, '2023_03_18_141537_add_woocommerce_category_id_to_categories_table', 139),
(246, '2023_03_20_214553_add_column_for_woocommerce_to_products_table', 139),
(247, '2023_03_20_214563_add_woocommerce_tax_id_to_taxes_table', 139),
(248, '2023_03_20_214565_add_woocommerce_order_id_to_sales_table', 139),
(249, '2023_08_01_134406_add_is_sync_disable_to_categories_table', 139),
(250, '2023_08_01_135252_add_product_status_to_woocommerce_settings_table', 139),
(251, '2024_08_12_112830_add_thermal_invoice_size_to_pos_setting', 139),
(252, '2024_08_14_133351_add_expiry_type_value_to_general_settings', 139),
(253, '2024_09_11_151744_add_return_qty_to_product_purchases_table', 140),
(254, '2024_09_12_162309_create_barcodes_table', 140),
(255, '2024_10_10_121312_add_data_to_payment_with_credit_card_table', 141),
(256, '2024_10_10_212501_alter_attendances_table', 142),
(257, '2024_10_10_213757_alter_attendances_table', 142),
(258, '2024_10_14_144917_change_column_to_nullable_to_payment_with_credit_card_table', 142),
(259, '2024_09_01_120515_create_productions_table', 143),
(260, '2024_09_01_120536_create_product_productions_table', 143),
(261, '2024_11_10_121521_add_code_and_type_to_accounts_table', 144),
(262, '2024_11_24_100926_add_module_status_to_external_services_table', 145);

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

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

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

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(191) NOT NULL,
  `notifiable_type` varchar(191) NOT NULL,
  `notifiable_id` bigint(20) UNSIGNED NOT NULL,
  `data` text 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 `packing_slips`
--

CREATE TABLE `packing_slips` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reference_no` varchar(255) NOT NULL,
  `sale_id` int(11) NOT NULL,
  `delivery_id` int(11) DEFAULT NULL,
  `amount` double NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `packing_slips`
--

INSERT INTO `packing_slips` (`id`, `reference_no`, `sale_id`, `delivery_id`, `amount`, `status`, `created_at`, `updated_at`) VALUES
(1, '1001', 42, 1, 577, 'Delivered', '2024-08-11 05:25:41', '2024-08-11 05:28:06'),
(2, '1002', 43, 2, 599, 'In Transit', '2024-08-11 05:37:38', '2024-08-11 05:39:22');

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

--
-- Table structure for table `packing_slip_products`
--

CREATE TABLE `packing_slip_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `packing_slip_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `variant_id` int(11) 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 `packing_slip_products`
--

INSERT INTO `packing_slip_products` (`id`, `packing_slip_id`, `product_id`, `variant_id`, `created_at`, `updated_at`) VALUES
(1, 1, 23, NULL, '2024-08-11 05:25:41', '2024-08-11 05:25:41'),
(2, 2, 18, NULL, '2024-08-11 05:37:38', '2024-08-11 05:37:38');

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

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

CREATE TABLE `payments` (
  `id` int(10) UNSIGNED NOT NULL,
  `payment_reference` varchar(191) 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,
  `payment_receiver` varchar(255) DEFAULT NULL,
  `amount` double NOT NULL,
  `used_points` double DEFAULT NULL,
  `change` double DEFAULT NULL,
  `paying_method` varchar(191) NOT NULL,
  `payment_note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=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`, `payment_receiver`, `amount`, `used_points`, `change`, `paying_method`, `payment_note`, `created_at`, `updated_at`) VALUES
(1, 'spr-20240119-084017', 1, NULL, 1, NULL, 1, NULL, 1758, NULL, NULL, 'Cash', NULL, '2024-01-19 14:40:17', '2024-01-19 14:40:17'),
(2, 'spr-20240119-084441', 1, NULL, 2, NULL, 1, NULL, 3017, NULL, NULL, 'Cash', NULL, '2024-01-19 14:44:41', '2024-01-19 14:44:41'),
(3, 'spr-20240210-122224', 1, NULL, 5, 2, 1, NULL, 1259, NULL, NULL, 'Cash', NULL, '2024-02-10 06:22:24', '2024-02-10 06:22:24'),
(4, 'spr-20240225-014951', 1, NULL, 6, 2, 1, NULL, 1299.99, NULL, NULL, 'Credit Card', NULL, '2024-02-25 07:49:51', '2024-02-25 07:49:51'),
(5, 'spr-20240225-015013', 1, NULL, 7, 2, 1, NULL, 2599.98, NULL, NULL, 'Cash', NULL, '2024-02-25 07:50:13', '2024-02-25 07:50:13'),
(6, 'spr-20240228-112744', 1, NULL, 8, 2, 1, NULL, 2558.99, NULL, NULL, 'Cash', NULL, '2024-02-28 05:27:44', '2024-02-28 05:27:44'),
(7, 'spr-20240421-110143', 1, NULL, 9, 2, 1, NULL, 350, NULL, NULL, 'Cash', NULL, '2024-04-21 05:01:43', '2024-04-21 05:01:43'),
(8, 'spr-20240428-121544', 1, NULL, 13, 2, 1, NULL, 1409, NULL, NULL, 'Cash', NULL, '2024-04-28 06:15:44', '2024-04-28 06:15:44'),
(9, 'spr-20240429-062956', 1, NULL, 14, 2, 1, NULL, 3800.99, NULL, NULL, 'Cash', NULL, '2024-04-29 12:29:56', '2024-04-29 12:29:56'),
(12, 'spr-20240505-052905', 1, NULL, 20, 2, 1, NULL, 2549.99, NULL, NULL, 'Cash', NULL, '2024-05-05 11:29:05', '2024-05-05 11:29:05'),
(13, 'spr-20240508-020851', 1, NULL, 22, 2, 1, NULL, 1349.99, NULL, NULL, 'Cash', NULL, '2024-05-08 08:08:51', '2024-05-08 08:08:51'),
(14, 'spr-20240519-022423', 1, NULL, 23, 2, 1, NULL, 1299.99, NULL, NULL, 'Cash', NULL, '2024-05-19 08:24:23', '2024-05-19 08:24:23'),
(15, 'spr-20240519-022530', 1, NULL, 24, 2, 1, NULL, 1300, NULL, NULL, 'Cash', NULL, '2024-05-19 08:25:30', '2024-05-19 08:25:30'),
(16, 'spr-20240519-023055', 1, NULL, 25, 2, 1, NULL, 1300, NULL, NULL, 'Cash', NULL, '2024-05-19 08:30:55', '2024-05-19 08:30:55'),
(18, 'spr-20240521-013249', 1, NULL, 28, 2, 1, NULL, 1050, NULL, NULL, 'Cash', NULL, '2024-05-21 07:32:49', '2024-05-21 07:32:49'),
(19, 'spr-20240603-122701', 1, NULL, 29, 2, 1, NULL, 1000, NULL, NULL, 'Cash', NULL, '2024-06-03 06:27:01', '2024-06-03 06:27:01'),
(20, 'spr-20240603-122810', 1, NULL, 29, 2, 1, NULL, 1000, NULL, NULL, 'Credit Card', NULL, '2024-06-03 06:28:10', '2024-06-03 06:28:10'),
(21, 'spr-20240603-122906', 1, NULL, 29, 2, 1, NULL, 549.99, NULL, NULL, 'Cheque', NULL, '2024-06-03 06:29:06', '2024-06-03 06:29:06'),
(22, 'spr-20240603-053022', 1, NULL, 30, 2, 1, NULL, 2300, NULL, NULL, 'Cash', NULL, '2024-06-03 11:30:22', '2024-06-03 11:30:22'),
(23, 'spr-20240626-010119', 1, NULL, 33, 2, 1, NULL, 1299.99, NULL, NULL, 'Cash', NULL, '2024-06-26 07:01:19', '2024-06-26 07:01:19'),
(24, 'spr-20240718-113630', 1, NULL, 38, 2, 1, NULL, 1299.99, NULL, 0, 'Cash', NULL, '2024-07-18 05:36:30', '2024-07-18 05:36:30'),
(25, 'spr-20240718-015913', 1, NULL, 39, 2, 1, NULL, 250, NULL, 0, 'Cash', NULL, '2024-07-18 07:59:13', '2024-07-18 07:59:13'),
(26, 'spr-20240718-020145', 1, NULL, 40, 1, 1, NULL, 250, NULL, 0, 'Cash', NULL, '2024-07-18 08:01:45', '2024-07-18 08:01:45'),
(27, 'spr-20240811-112806', 1, NULL, 42, 2, 1, NULL, 500, NULL, 0, 'Cash', NULL, '2024-08-11 05:28:06', '2024-08-11 05:28:06'),
(28, 'spr-20240811-112806', 1, NULL, 42, 2, 1, NULL, 77, NULL, 0, 'Cheque', NULL, '2024-08-11 05:28:06', '2024-08-11 05:28:06'),
(29, 'spr-20240811-114852', 1, NULL, 45, 2, 1, NULL, 1600, NULL, 0, 'Cash', NULL, '2024-08-11 05:48:52', '2024-08-11 05:48:52'),
(30, 'spr-20240825-062616', 1, NULL, 46, 3, 1, NULL, 1299.99, NULL, 0, '', NULL, '2024-08-25 23:26:16', '2024-08-25 23:26:16'),
(31, 'spr-20240825-062630', 1, NULL, 47, 3, 1, NULL, 1050, NULL, 0, 'Cash', NULL, '2024-08-25 23:26:30', '2024-08-25 23:26:30'),
(34, 'spr-20240825-062929', 1, NULL, 50, 3, 1, NULL, 350, NULL, 0, '', NULL, '2024-08-25 23:29:29', '2024-08-25 23:29:29'),
(35, 'spr-20241126-101724', 1, NULL, 51, 3, 1, NULL, 31.9, NULL, 0, 'Cash', NULL, '2024-11-26 16:17:24', '2024-11-26 16:17:24'),
(36, 'spr-20241128-112142', 1, NULL, 53, 3, 1, NULL, 1299.99, NULL, 0, 'Cash', NULL, '2024-11-28 05:21:42', '2024-11-28 05:21:42'),
(37, 'spr-20241128-091248', 1, NULL, 56, 3, 1, NULL, 1497, NULL, 0, 'Cash', NULL, '2024-11-28 15:12:48', '2024-11-28 15:12:48'),
(38, 'spr-20250928-050723', 1, NULL, 57, 3, 1, NULL, 2249.99, NULL, 0, 'Cash', NULL, '2025-09-28 17:07:23', '2025-09-28 17:07:23');

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

--
-- 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) 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 `payment_with_cheque`
--

INSERT INTO `payment_with_cheque` (`id`, `payment_id`, `cheque_no`, `created_at`, `updated_at`) VALUES
(1, 21, '34242423', '2024-06-03 06:29:06', '2024-06-03 06:29:06');

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

--
-- 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) DEFAULT NULL,
  `charge_id` varchar(191) NOT NULL,
  `data` longtext 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 `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) 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) 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) NOT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `permissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `guard_name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `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, 'reward_point_setting', 'web', '2021-06-27 04:34:42', '2021-06-27 04:34:42'),
(106, 'revenue_profit_summary', 'web', '2022-02-08 13:57:21', '2022-02-08 13:57:21'),
(107, 'cash_flow', 'web', '2022-02-08 13:57:22', '2022-02-08 13:57:22'),
(108, 'monthly_summary', 'web', '2022-02-08 13:57:22', '2022-02-08 13:57:22'),
(109, 'yearly_report', 'web', '2022-02-08 13:57:22', '2022-02-08 13:57:22'),
(110, 'discount_plan', 'web', '2022-02-16 09:12:26', '2022-02-16 09:12:26'),
(111, 'discount', 'web', '2022-02-16 09:12:38', '2022-02-16 09:12:38'),
(112, 'product-expiry-report', 'web', '2022-03-30 05:39:20', '2022-03-30 05:39:20'),
(113, 'purchase-payment-index', 'web', '2022-06-05 14:12:27', '2022-06-05 14:12:27'),
(114, 'purchase-payment-add', 'web', '2022-06-05 14:12:28', '2022-06-05 14:12:28'),
(115, 'purchase-payment-edit', 'web', '2022-06-05 14:12:28', '2022-06-05 14:12:28'),
(116, 'purchase-payment-delete', 'web', '2022-06-05 14:12:28', '2022-06-05 14:12:28'),
(117, 'sale-payment-index', 'web', '2022-06-05 14:12:28', '2022-06-05 14:12:28'),
(118, 'sale-payment-add', 'web', '2022-06-05 14:12:28', '2022-06-05 14:12:28'),
(119, 'sale-payment-edit', 'web', '2022-06-05 14:12:28', '2022-06-05 14:12:28'),
(120, 'sale-payment-delete', 'web', '2022-06-05 14:12:28', '2022-06-05 14:12:28'),
(121, 'all_notification', 'web', '2022-06-05 14:12:29', '2022-06-05 14:12:29'),
(122, 'sale-report-chart', 'web', '2022-06-05 14:12:29', '2022-06-05 14:12:29'),
(123, 'dso-report', 'web', '2022-06-05 14:12:29', '2022-06-05 14:12:29'),
(124, 'product_history', 'web', '2022-08-25 14:04:05', '2022-08-25 14:04:05'),
(125, 'supplier-due-report', 'web', '2022-08-31 09:46:33', '2022-08-31 09:46:33'),
(126, 'custom_field', 'web', '2023-05-02 07:41:35', '2023-05-02 07:41:35'),
(127, 'incomes-index', 'web', '2024-08-11 04:50:59', '2024-08-11 04:50:59'),
(128, 'incomes-add', 'web', '2024-08-11 04:50:59', '2024-08-11 04:50:59'),
(129, 'incomes-edit', 'web', '2024-08-11 04:50:59', '2024-08-11 04:50:59'),
(130, 'incomes-delete', 'web', '2024-08-11 04:50:59', '2024-08-11 04:50:59'),
(131, 'packing_slip_challan', 'web', '2024-08-11 04:51:00', '2024-08-11 04:51:00'),
(132, 'biller-report', 'web', '2024-08-25 23:30:44', '2024-08-25 23:30:44');

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

--
-- Table structure for table `productions`
--

CREATE TABLE `productions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reference_no` varchar(255) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `item` int(11) NOT NULL,
  `total_qty` int(11) NOT NULL,
  `total_tax` double NOT NULL,
  `total_cost` double NOT NULL,
  `shipping_cost` double DEFAULT NULL,
  `grand_total` double NOT NULL,
  `status` int(11) NOT NULL,
  `document` varchar(255) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `products` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `code` varchar(191) NOT NULL,
  `type` varchar(191) NOT NULL,
  `barcode_symbology` varchar(191) 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` double NOT NULL,
  `price` double NOT NULL,
  `wholesale_price` double DEFAULT NULL,
  `qty` double DEFAULT NULL,
  `alert_quantity` double DEFAULT NULL,
  `daily_sale_objective` double DEFAULT NULL,
  `promotion` tinyint(4) DEFAULT NULL,
  `promotion_price` varchar(191) DEFAULT NULL,
  `starting_date` varchar(200) DEFAULT NULL,
  `last_date` date DEFAULT NULL,
  `tax_id` int(11) DEFAULT NULL,
  `tax_method` int(11) DEFAULT NULL,
  `image` longtext DEFAULT NULL,
  `file` varchar(191) DEFAULT NULL,
  `is_embeded` tinyint(1) DEFAULT NULL,
  `is_variant` tinyint(1) DEFAULT NULL,
  `is_batch` tinyint(1) DEFAULT NULL,
  `is_diffPrice` tinyint(1) DEFAULT NULL,
  `is_imei` tinyint(1) DEFAULT NULL,
  `featured` tinyint(4) DEFAULT NULL,
  `product_list` varchar(191) DEFAULT NULL,
  `variant_list` varchar(191) DEFAULT NULL,
  `qty_list` varchar(191) DEFAULT NULL,
  `price_list` varchar(191) DEFAULT NULL,
  `product_details` text DEFAULT NULL,
  `variant_option` text DEFAULT NULL,
  `variant_value` text DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `is_sync_disable` tinyint(4) DEFAULT NULL,
  `woocommerce_product_id` int(11) DEFAULT NULL,
  `woocommerce_media_id` int(11) 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`, `wholesale_price`, `qty`, `alert_quantity`, `daily_sale_objective`, `promotion`, `promotion_price`, `starting_date`, `last_date`, `tax_id`, `tax_method`, `image`, `file`, `is_embeded`, `is_variant`, `is_batch`, `is_diffPrice`, `is_imei`, `featured`, `product_list`, `variant_list`, `qty_list`, `price_list`, `product_details`, `variant_option`, `variant_value`, `is_active`, `is_sync_disable`, `woocommerce_product_id`, `woocommerce_media_id`, `created_at`, `updated_at`) VALUES
(1, 'Zenbook 14 OLED (UX3402)｜Laptops For Home – ASUS', '59028109', 'standard', 'C128', 2, 6, 1, 1, 1, 1099.99, 1299.99, NULL, 12, NULL, NULL, 1, '1050.99', '2024-01-08', NULL, 1, 2, '202401081146401.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-08 05:46:42', '2024-11-28 05:21:40'),
(2, '2021 Apple 12.9-inch iPad Pro Wi-Fi 512GB', '2035892312345', 'standard', 'C128', 3, 6, 1, 1, 1, 1000, 1250, 1230, 11, NULL, NULL, 1, '1200.00', '2024-01-08', NULL, 1, 2, '202401081246041.png,202401081246062.png,202401081246063.png,202401081246064.png', NULL, 0, NULL, NULL, 0, NULL, 1, NULL, NULL, NULL, NULL, '<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-08 06:46:07', '2025-09-28 17:07:23'),
(3, 'Apple iPhone 11 (4GB-64GB) Black', '49251814', 'standard', 'C128', 1, 1, 1, 1, 1, 300, 350, NULL, 13, NULL, NULL, 1, NULL, '2024-01-08', NULL, 1, 2, '202401081255081.png,202401081255112.png,202401081255123.png,202401081255134.png,202401081255135.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-08 06:55:14', '2024-11-26 16:37:06'),
(4, 'Samsung Galaxy Chromebook Go, 14″ HD LED, Intel Celeron N4500', '28090345', 'standard', 'C128', 2, 6, 1, 1, 1, 900, 1050, NULL, 15, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, '202401080121221.png,202401080121242.png,202401080121243.png,202401080121254.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-08 07:21:25', '2024-11-26 16:38:31'),
(5, 'SAMSUNG Galaxy Book Pro 15.6 Laptop – Intel Core i5', '67015642', 'standard', 'C128', 2, 6, 1, 1, 1, 950.99, 1150.99, NULL, 20, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, '202401080124321.png,202401080124342.png,202401080124353.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-08 07:24:36', '2024-08-25 23:29:53'),
(6, 'Microsoft – Surface Laptop 4 13.5â€ Touch-Screen – AMD Ryzen 5', '24005329', 'standard', 'C128', 3, 6, 1, 1, 1, 999.99, 1111.99, NULL, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '202401080127451.png,202401080127462.png,202401080127473.jpg,202401080127484.jpg,202401080127485.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-08 07:27:49', '2024-01-19 14:28:35'),
(7, 'Acer Chromebook 315, 15.6 HD – Intel Celeron N4000', '30798200', 'standard', 'C128', 4, 6, 1, 1, 1, 899.99, 999.99, 950, 22, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, '202401080130241.png,202401080130242.png,202401080130253.png', NULL, 0, NULL, NULL, 0, NULL, 1, NULL, NULL, NULL, NULL, '<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-08 07:30:25', '2025-09-28 17:07:23'),
(8, 'HP Victus 16-e00244AX GTX 1650 Gaming Laptop 16.1â€ FHD 144Hz', '81526930', 'standard', 'C128', 4, 6, 1, 1, 1, 1199, 1300, NULL, 18, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, '202401080134061.png,202401080134072.png,202401080134073.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-08 07:34:08', '2024-05-19 08:30:55'),
(9, 'Epson Inkjet WorkForce Pro WF-3820DWF', '20142029', 'standard', 'C128', 2, 6, 1, 1, 1, 399, 559, NULL, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '202401080141091.png,202401080141102.png,202401080141103.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-08 07:41:11', '2024-01-19 14:44:41'),
(10, 'iPhone 14 Pro 256GB Gold', '29733132', 'standard', 'C128', 1, 1, 1, 1, 1, 990, 1250, NULL, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '202401080143591.png,202401080144002.png,202401080144013.png,202401080144014.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-08 07:44:02', '2024-01-19 14:28:35'),
(11, 'Electrolux EW6F449ST PerfectCare 9 Kg Washing Machine', '23279148', 'standard', 'C128', 5, 20, 1, 1, 1, 1500, 1750, NULL, 20, NULL, NULL, 1, '1650', '2024-01-13', NULL, 1, 2, '202401130329581.png,202401130330002.png,202401130330013.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-13 09:30:02', '2024-01-19 14:28:35'),
(12, 'GORENJE Waschmaschine WHP74EPS Waschmaschine', '43879312', 'standard', 'C128', 2, 20, 1, 1, 1, 999, 1250, NULL, 20, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, '202401130338301.png,202401130338322.png,202401130338323.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-13 09:38:33', '2024-01-19 14:28:35'),
(13, 'iRobot Roomba E6 (6199) Robot Vacuum', '56858702', 'standard', 'C128', 4, 22, 1, 1, 1, 250, 349, NULL, 20, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, '202401130343221.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-13 09:43:24', '2024-01-19 14:28:35'),
(14, 'Sony Bravia 55X90J 4K Ultra HD 55″ 140 Screen Google Smart LED TV', '16530612', 'standard', 'C128', 3, 23, 1, 1, 1, 350, 499, NULL, 19, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-13 09:53:32', '2024-01-19 14:40:16'),
(15, 'Samsung 43AU7000 4K Ultra HD 43″ 109 Screen Smart LED TV', '73189124', 'standard', 'C128', 2, 23, 1, 1, 1, 499, 547, NULL, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '202401130357131.png,202401130357152.png,202401130357153.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-13 09:57:16', '2024-01-19 14:26:49'),
(16, 'Apple TV HD 32GB (2nd Generation)', '71493353', 'standard', 'C128', 1, 23, 1, 1, 1, 79, 109, NULL, 19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '202401130401491.png,202401130401522.png,202401130401533.png,202401130401544.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-13 10:01:55', '2024-07-11 06:31:01'),
(17, 'Apple Watch SE GPS + Cellular 40mm Space Gray', '92178104', 'standard', 'C128', 1, 12, 1, 1, 1, 349, 499, NULL, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '202401130410191.png,202401130410222.jpg,202401130410233.jpg', NULL, 0, NULL, NULL, 0, NULL, 1, NULL, NULL, NULL, NULL, '<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-13 10:10:24', '2024-04-28 06:05:43'),
(18, 'Xbox One Wireless Controller Black Color', '93060790', 'standard', 'C128', NULL, 1, 1, 1, 1, 459, 599, NULL, 17, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, '202401150808421.jpg,202401150808432.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<div class=@item-description@>\r\n<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>\r\n</div>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-15 14:08:43', '2024-08-11 05:37:38'),
(19, 'Apple iPhone XS Max-64GB -white', '22061536', 'standard', 'C128', 1, 1, 1, 1, 1, 899, 1059, NULL, 19, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, '202401150814131.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<div class=@item-description@>\r\n<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>\r\n</div>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-15 14:14:14', '2024-04-28 06:15:44'),
(20, 'Apple Watch Series 8 GPS 45mm Midnight Aluminum Case', '31429623', 'standard', 'C128', 1, 12, 1, 1, 1, 399, 499, NULL, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '202401151009571.png,202401151009582.png,202401151009583.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<div class=@item-description@>\r\n<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>\r\n</div>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-15 16:09:59', '2024-11-28 15:12:48'),
(21, 'Huawei Watch GT 2 Sport Stainless Steel 46mm', '02456392', 'standard', 'C128', 3, 12, 1, 1, 1, 369, 599, NULL, 20, NULL, NULL, 1, '499', '2024-01-15', NULL, NULL, 1, '202401151013061.png,202401151013062.png,202401151013073.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<div class=@item-description@>\r\n<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>\r\n</div>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-15 16:13:07', '2024-01-19 14:28:35'),
(22, 'Samsung Galaxy Active 2 R835U Smartwatch 40mm', '10203743', 'standard', 'C128', 2, 12, 1, 1, 1, 275, 399, NULL, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '202401151019301.png,202401151019302.png,202401151019313.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<div class=@item-description@>\r\n<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>\r\n</div>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-15 16:19:31', '2024-01-19 14:26:49'),
(23, 'Canon EOS R10 RF-S 18-45 IS STM', '13929367', 'standard', 'C128', 17, 1, 1, 1, 1, 439, 577, NULL, 16, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '202401151024231.png,202401151024232.png,202401151024233.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<div class=@item-description@>\r\n<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>\r\n</div>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-15 16:24:24', '2024-08-11 05:25:42'),
(24, 'Sony A7 III Mirrorless Camera Body Only', '99421096', 'standard', 'C128', 2, 1, 1, 1, 1, 299, 379, NULL, 20, NULL, NULL, NULL, NULL, NULL, NULL, 1, 2, '202401151026581.png,202401151026592.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<div class=@item-description@>\r\n<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>\r\n</div>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-15 16:27:00', '2024-01-19 14:26:49'),
(25, 'WOLFANG GA420 Action Camera 4K 60FPS 24MP', '99218280', 'standard', 'C128', 4, 1, 1, 1, 1, 130, 157.99, NULL, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '202401151029321.png,202401151029332.jpg,202401151029343.jpg', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<div class=@item-description@>\r\n<p>Quisque varius diam vel metus mattis, id aliquam diam rhoncus. Proin vitae magna in dui finibus malesuada et at nulla. Morbi elit ex, viverra vitae ante vel, blandit feugiat ligula. Fusce fermentum iaculis nibh, at sodales leo maximus a. Nullam ultricies sodales nunc, in pellentesque lorem mattis quis. Cras imperdiet est in nunc tristique lacinia. Nullam aliquam mauris eu accumsan tincidunt. Suspendisse velit ex, aliquet vel ornare vel, dignissim a tortor.</p>\r\n<p>Morbi ut sapien vitae odio accumsan gravida. Morbi vitae erat auctor, eleifend nunc a, lobortis neque. Praesent aliquam dignissim viverra. Maecenas lacus odio, feugiat eu nunc sit amet, maximus sagittis dolor. Vivamus nisi sapien, elementum sit amet eros sit amet, ultricies cursus ipsum. Sed consequat luctus ligula. Curabitur laoreet rhoncus blandit. Aenean vel diam ut arcu pharetra dignissim ut sed leo. Vivamus faucibus, ipsum in vestibulum vulputate, lorem orci convallis quam, sit amet consequat nulla felis pharetra lacus. Duis semper erat mauris, sed egestas purus commodo vel.</p>\r\n</div>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-15 16:29:34', '2024-01-19 14:26:48'),
(26, 'Fresh Organic Navel Orange', '33887520', 'standard', 'C128', NULL, 29, 4, 4, 4, 2.99, 3.99, NULL, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '202401151115301.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<p>Fresh Organic Navel Orange</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-15 17:15:32', '2024-01-19 14:28:35'),
(27, 'Banana (pack of 12)', '27583341', 'standard', 'C128', NULL, 29, 1, 1, 1, 0.89, 1.29, NULL, 17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '202401151118271.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-15 17:18:28', '2024-07-11 06:12:35'),
(28, 'Water Melon ~ 3KG', '19186147', 'standard', 'C128', NULL, 29, 1, 1, 1, 2.39, 3.3, NULL, 20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '202401151142511.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<p>Water Melon ~ 3KG</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-15 17:42:53', '2024-01-19 14:26:48'),
(29, 'Gala Original Apple - 1KG', '80912386', 'standard', 'C128', NULL, 29, 1, 1, 1, 2.39, 3.19, NULL, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '202401151144271.png', NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, '<p>Gala Original Apple - 1KG</p>', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-15 17:44:27', '2024-11-26 16:36:03'),
(30, 'Apple Smart Watch', '12010761', 'standard', 'C128', 1, 12, 1, 1, 1, 100, 200, NULL, 20, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, '202401190429592.jpg', NULL, 0, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, NULL, '', NULL, NULL, 1, NULL, NULL, NULL, '2024-01-19 09:43:44', '2024-01-19 14:28:26'),
(31, 'Alpha Cheese', '33357221', 'standard', 'C128', NULL, 34, 1, 1, 1, 120, 200, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'zummXD2dvAtI.png', NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, 1, NULL, NULL, NULL, '2024-04-14 06:15:06', '2024-04-14 06:15:06'),
(32, 'green spice', '61226895', 'standard', 'C128', 19, 40, 1, 1, 1, 10, 20, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 3, 1, 'zummXD2dvAtI.png', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, 1, NULL, NULL, NULL, '2024-04-29 12:29:17', '2024-04-29 12:29:17'),
(33, 'Samsung Adapter', '99767039', 'standard', 'C128', 2, 6, 1, 1, 1, 100, 250, NULL, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'zummXD2dvAtI.png', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, 1, NULL, NULL, NULL, '2024-07-18 07:39:33', '2024-07-18 08:01:45');

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

--
-- 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,
  `variant_id` int(11) DEFAULT NULL,
  `unit_cost` double DEFAULT NULL,
  `qty` double NOT NULL,
  `action` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_batches`
--

CREATE TABLE `product_batches` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` int(11) NOT NULL,
  `batch_no` varchar(191) NOT NULL,
  `expired_date` date NOT 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;

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

--
-- Table structure for table `product_productions`
--

CREATE TABLE `product_productions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `production_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `qty` double NOT NULL,
  `recieved` 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;

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

--
-- 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,
  `product_batch_id` int(11) DEFAULT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `imei_number` text DEFAULT NULL,
  `qty` double NOT NULL,
  `recieved` double NOT NULL,
  `return_qty` double NOT NULL DEFAULT 0,
  `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;

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

INSERT INTO `product_purchases` (`id`, `purchase_id`, `product_id`, `product_batch_id`, `variant_id`, `imei_number`, `qty`, `recieved`, `return_qty`, `purchase_unit_id`, `net_unit_cost`, `discount`, `tax_rate`, `tax`, `total`, `created_at`, `updated_at`) VALUES
(1, 1, 23, NULL, NULL, NULL, 10, 10, 0, 1, 439, 0, 0, 0, 4390, '2024-01-19 13:46:04', '2024-01-19 13:46:04'),
(2, 1, 27, NULL, NULL, NULL, 10, 10, 0, 1, 0.89, 0, 0, 0, 8.9, '2024-01-19 13:46:04', '2024-01-19 13:46:04'),
(3, 1, 20, NULL, NULL, NULL, 10, 10, 0, 1, 399, 0, 0, 0, 3990, '2024-01-19 13:46:04', '2024-01-19 13:46:04'),
(4, 1, 17, NULL, NULL, NULL, 10, 10, 0, 1, 349, 0, 0, 0, 3490, '2024-01-19 13:46:04', '2024-01-19 13:46:04'),
(5, 1, 16, NULL, NULL, NULL, 10, 10, 0, 1, 79, 0, 0, 0, 790, '2024-01-19 13:46:04', '2024-01-19 13:46:04'),
(6, 1, 30, NULL, NULL, NULL, 10, 10, 0, 1, 100, 0, 10, 100, 1100, '2024-01-19 13:46:04', '2024-01-19 13:46:04'),
(7, 1, 19, NULL, NULL, NULL, 10, 10, 0, 1, 817.27, 0, 10, 817.27, 8990, '2024-01-19 13:46:04', '2024-01-19 13:46:04'),
(8, 1, 3, NULL, NULL, NULL, 10, 10, 0, 1, 272.73, 0, 10, 272.73, 3000, '2024-01-19 13:46:05', '2024-01-19 13:46:05'),
(9, 1, 7, NULL, NULL, NULL, 10, 10, 0, 1, 818.17, 0, 10, 818.17, 8999.9, '2024-01-19 13:46:05', '2024-01-19 13:46:05'),
(10, 1, 2, NULL, NULL, NULL, 10, 10, 0, 1, 909.09, 0, 10, 909.09, 10000, '2024-01-19 13:46:05', '2024-01-19 13:46:05'),
(11, 2, 6, NULL, NULL, NULL, 10, 10, 0, 1, 999.99, 0, 0, 0, 9999.9, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(12, 2, 13, NULL, NULL, NULL, 10, 10, 0, 1, 227.27, 0, 10, 227.27, 2500, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(13, 2, 10, NULL, NULL, NULL, 10, 10, 0, 1, 990, 0, 0, 0, 9900, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(14, 2, 21, NULL, NULL, NULL, 10, 10, 0, 1, 369, 0, 0, 0, 3690, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(15, 2, 8, NULL, NULL, NULL, 10, 10, 0, 1, 1090, 0, 10, 1090, 11990, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(16, 2, 12, NULL, NULL, NULL, 10, 10, 0, 1, 908.18, 0, 10, 908.18, 9990, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(17, 2, 29, NULL, NULL, NULL, 10, 10, 0, 1, 2.39, 0, 0, 0, 23.9, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(18, 2, 26, NULL, NULL, NULL, 10, 10, 0, 4, 2.99, 0, 0, 0, 29.9, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(19, 2, 9, NULL, NULL, NULL, 10, 10, 0, 1, 399, 0, 0, 0, 3990, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(20, 2, 11, NULL, NULL, NULL, 10, 10, 0, 1, 1363.64, 0, 10, 1363.64, 15000, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(21, 3, 1, NULL, NULL, NULL, 10, 10, 0, 1, 999.99, 0, 10, 999.99, 10999.9, '2024-01-19 13:53:21', '2024-01-19 13:53:21'),
(22, 3, 18, NULL, NULL, NULL, 10, 10, 0, 1, 417.27, 0, 10, 417.27, 4590, '2024-01-19 13:53:21', '2024-01-19 13:53:21'),
(23, 3, 25, NULL, NULL, NULL, 10, 10, 0, 1, 130, 0, 0, 0, 1300, '2024-01-19 13:53:21', '2024-01-19 13:53:21'),
(24, 3, 28, NULL, NULL, NULL, 10, 10, 0, 1, 2.39, 0, 0, 0, 23.9, '2024-01-19 13:53:21', '2024-01-19 13:53:21'),
(25, 3, 14, NULL, NULL, NULL, 10, 10, 0, 1, 318.18, 0, 10, 318.18, 3500, '2024-01-19 13:53:21', '2024-01-19 13:53:21'),
(26, 3, 24, NULL, NULL, NULL, 10, 10, 0, 1, 271.82, 0, 10, 271.82, 2990, '2024-01-19 13:53:21', '2024-01-19 13:53:21'),
(27, 3, 4, NULL, NULL, NULL, 10, 10, 0, 1, 818.18, 0, 10, 818.18, 9000, '2024-01-19 13:53:21', '2024-01-19 13:53:21'),
(28, 3, 5, NULL, NULL, NULL, 10, 10, 0, 1, 864.54, 0, 10, 864.54, 9509.9, '2024-01-19 13:53:21', '2024-01-19 13:53:21'),
(29, 3, 22, NULL, NULL, NULL, 10, 10, 0, 1, 275, 0, 0, 0, 2750, '2024-01-19 13:53:21', '2024-01-19 13:53:21'),
(30, 3, 15, NULL, NULL, NULL, 10, 10, 0, 1, 499, 0, 0, 0, 4990, '2024-01-19 13:53:21', '2024-01-19 13:53:21'),
(31, 4, 1, NULL, NULL, NULL, 11, 11, 0, 1, 999.99, 0, 10, 1099.99, 12099.89, '2024-01-19 14:26:48', '2024-01-19 14:26:48'),
(32, 4, 18, NULL, NULL, NULL, 10, 10, 0, 1, 417.27, 0, 10, 417.27, 4590, '2024-01-19 14:26:48', '2024-01-19 14:26:48'),
(33, 4, 25, NULL, NULL, NULL, 10, 10, 0, 1, 130, 0, 0, 0, 1300, '2024-01-19 14:26:48', '2024-01-19 14:26:48'),
(34, 4, 28, NULL, NULL, NULL, 10, 10, 0, 1, 2.39, 0, 0, 0, 23.9, '2024-01-19 14:26:48', '2024-01-19 14:26:48'),
(35, 4, 14, NULL, NULL, NULL, 10, 10, 0, 1, 318.18, 0, 10, 318.18, 3500, '2024-01-19 14:26:49', '2024-01-19 14:26:49'),
(36, 4, 24, NULL, NULL, NULL, 10, 10, 0, 1, 271.82, 0, 10, 271.82, 2990, '2024-01-19 14:26:49', '2024-01-19 14:26:49'),
(37, 4, 4, NULL, NULL, NULL, 10, 10, 0, 1, 818.18, 0, 10, 818.18, 9000, '2024-01-19 14:26:49', '2024-01-19 14:26:49'),
(38, 4, 5, NULL, NULL, NULL, 10, 10, 0, 1, 864.54, 0, 10, 864.54, 9509.9, '2024-01-19 14:26:49', '2024-01-19 14:26:49'),
(39, 4, 22, NULL, NULL, NULL, 10, 10, 0, 1, 275, 0, 0, 0, 2750, '2024-01-19 14:26:49', '2024-01-19 14:26:49'),
(40, 4, 15, NULL, NULL, NULL, 10, 10, 0, 1, 499, 0, 0, 0, 4990, '2024-01-19 14:26:49', '2024-01-19 14:26:49'),
(41, 5, 23, NULL, NULL, NULL, 10, 10, 0, 1, 439, 0, 0, 0, 4390, '2024-01-19 14:28:26', '2024-01-19 14:28:26'),
(42, 5, 27, NULL, NULL, NULL, 10, 10, 0, 1, 0.89, 0, 0, 0, 8.9, '2024-01-19 14:28:26', '2024-01-19 14:28:26'),
(43, 5, 20, NULL, NULL, NULL, 10, 10, 0, 1, 399, 0, 0, 0, 3990, '2024-01-19 14:28:26', '2024-01-19 14:28:26'),
(44, 5, 17, NULL, NULL, NULL, 10, 10, 0, 1, 349, 0, 0, 0, 3490, '2024-01-19 14:28:26', '2024-01-19 14:28:26'),
(45, 5, 16, NULL, NULL, NULL, 10, 10, 0, 1, 79, 0, 0, 0, 790, '2024-01-19 14:28:26', '2024-01-19 14:28:26'),
(46, 5, 30, NULL, NULL, NULL, 10, 10, 0, 1, 100, 0, 10, 100, 1100, '2024-01-19 14:28:26', '2024-01-19 14:28:26'),
(47, 5, 19, NULL, NULL, NULL, 10, 10, 0, 1, 817.27, 0, 10, 817.27, 8990, '2024-01-19 14:28:26', '2024-01-19 14:28:26'),
(48, 5, 3, NULL, NULL, NULL, 10, 10, 0, 1, 272.73, 0, 10, 272.73, 3000, '2024-01-19 14:28:26', '2024-01-19 14:28:26'),
(49, 5, 7, NULL, NULL, NULL, 10, 10, 0, 1, 818.17, 0, 10, 818.17, 8999.9, '2024-01-19 14:28:26', '2024-01-19 14:28:26'),
(50, 5, 2, NULL, NULL, NULL, 10, 10, 0, 1, 909.09, 0, 10, 909.09, 10000, '2024-01-19 14:28:26', '2024-01-19 14:28:26'),
(51, 6, 6, NULL, NULL, NULL, 10, 10, 0, 1, 999.99, 0, 0, 0, 9999.9, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(52, 6, 13, NULL, NULL, NULL, 10, 10, 0, 1, 227.27, 0, 10, 227.27, 2500, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(53, 6, 10, NULL, NULL, NULL, 10, 10, 0, 1, 990, 0, 0, 0, 9900, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(54, 6, 21, NULL, NULL, NULL, 10, 10, 0, 1, 369, 0, 0, 0, 3690, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(55, 6, 8, NULL, NULL, NULL, 10, 10, 0, 1, 1090, 0, 10, 1090, 11990, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(56, 6, 12, NULL, NULL, NULL, 10, 10, 0, 1, 908.18, 0, 10, 908.18, 9990, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(57, 6, 29, NULL, NULL, NULL, 10, 10, 0, 1, 2.39, 0, 0, 0, 23.9, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(58, 6, 26, NULL, NULL, NULL, 10, 10, 0, 4, 2.99, 0, 0, 0, 29.9, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(59, 6, 9, NULL, NULL, NULL, 10, 10, 0, 1, 399, 0, 0, 0, 3990, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(60, 6, 11, NULL, NULL, NULL, 10, 10, 0, 1, 1363.64, 0, 10, 1363.64, 15000, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(61, 7, 17, NULL, NULL, NULL, 1, 1, 0, 1, 349, 0, 0, 0, 349, '2024-01-19 14:52:02', '2024-01-19 14:52:02'),
(62, 7, 20, NULL, NULL, NULL, 1, 1, 0, 1, 399, 0, 0, 0, 399, '2024-01-19 14:52:02', '2024-01-19 14:52:02'),
(64, 8, 7, NULL, NULL, NULL, 6, 6, 0, 1, 800, 0, 10, 480, 5280, '2024-06-20 05:08:26', '2024-06-20 05:08:26'),
(65, 9, 33, NULL, NULL, '1001,1002,1003,1004,1005', 5, 5, 0, 1, 100, 0, 0, 0, 500, '2024-07-18 07:41:45', '2024-07-18 07:41:45'),
(67, 10, 33, NULL, NULL, '2001,2002,2003,2004,2005', 5, 5, 0, 1, 100, 0, 0, 0, 500, '2024-07-18 07:51:35', '2024-07-18 07:51:35');

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

--
-- 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,
  `product_batch_id` int(11) DEFAULT 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;

--
-- Dumping data for table `product_quotation`
--

INSERT INTO `product_quotation` (`id`, `quotation_id`, `product_id`, `product_batch_id`, `variant_id`, `qty`, `sale_unit_id`, `net_unit_price`, `discount`, `tax_rate`, `tax`, `total`, `created_at`, `updated_at`) VALUES
(1, 1, 17, NULL, NULL, 1, 1, 499, 0, 0, 0, 499, '2024-01-19 14:51:32', '2024-01-19 14:51:32'),
(2, 1, 20, NULL, NULL, 1, 1, 499, 0, 0, 0, 499, '2024-01-19 14:51:32', '2024-01-19 14:51:32'),
(3, 2, 20, NULL, NULL, 3, 1, 499, 0, 0, 0, 1497, '2024-08-25 23:01:17', '2024-08-25 23:01:17');

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

--
-- 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,
  `product_batch_id` int(11) DEFAULT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `imei_number` text 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;

--
-- Dumping data for table `product_returns`
--

INSERT INTO `product_returns` (`id`, `return_id`, `product_id`, `product_batch_id`, `variant_id`, `imei_number`, `qty`, `sale_unit_id`, `net_unit_price`, `discount`, `tax_rate`, `tax`, `total`, `created_at`, `updated_at`) VALUES
(1, 1, 1, NULL, NULL, NULL, 1, 1, 1181.81, 0, 10, 118.18, 1299.99, '2024-03-24 07:08:23', '2024-03-24 07:08:23'),
(2, 2, 5, NULL, NULL, NULL, 1, 1, 1046.35, 0, 10, 104.64, 1150.99, '2024-04-29 12:30:38', '2024-04-29 12:30:38'),
(3, 2, 3, NULL, NULL, NULL, 1, 1, 318.18, 0, 10, 31.82, 350, '2024-04-29 12:30:38', '2024-04-29 12:30:38'),
(4, 3, 1, NULL, NULL, NULL, 1, 1, 1181.81, 0, 10, 118.18, 1299.99, '2024-06-26 07:01:42', '2024-06-26 07:01:42');

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

--
-- 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,
  `product_batch_id` int(11) DEFAULT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `imei_number` text DEFAULT NULL,
  `qty` double NOT NULL,
  `return_qty` double NOT NULL DEFAULT 0,
  `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,
  `is_delivered` tinyint(1) DEFAULT NULL,
  `is_packing` tinyint(1) 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`, `product_batch_id`, `variant_id`, `imei_number`, `qty`, `return_qty`, `sale_unit_id`, `net_unit_price`, `discount`, `tax_rate`, `tax`, `total`, `created_at`, `updated_at`, `is_delivered`, `is_packing`) VALUES
(1, 1, 14, NULL, NULL, NULL, 1, 0, 1, 453.64, 0, 10, 45.36, 499, '2024-01-19 14:40:16', '2024-01-19 14:40:16', NULL, NULL),
(2, 1, 2, NULL, NULL, NULL, 1, 0, 1, 1144.55, 0, 10, 114.45, 1259, '2024-01-19 14:40:16', '2024-01-19 14:40:16', NULL, NULL),
(3, 2, 16, NULL, NULL, NULL, 1, 0, 1, 109, 0, 0, 0, 109, '2024-01-19 14:44:41', '2024-01-19 14:44:41', NULL, NULL),
(4, 2, 18, NULL, NULL, NULL, 1, 0, 1, 544.55, 0, 10, 54.45, 599, '2024-01-19 14:44:41', '2024-01-19 14:44:41', NULL, NULL),
(5, 2, 9, NULL, NULL, NULL, 1, 0, 1, 559, 0, 0, 0, 559, '2024-01-19 14:44:41', '2024-01-19 14:44:41', NULL, NULL),
(6, 2, 4, NULL, NULL, NULL, 1, 0, 1, 954.55, 0, 10, 95.45, 1050, '2024-01-19 14:44:41', '2024-01-19 14:44:41', NULL, NULL),
(7, 2, 3, NULL, NULL, NULL, 2, 0, 1, 318.18, 0, 10, 63.64, 700, '2024-01-19 14:44:41', '2024-01-19 14:44:41', NULL, NULL),
(8, 3, 18, NULL, NULL, NULL, 1, 0, 1, 544.55, 0, 10, 54.45, 599, '2024-01-19 14:48:33', '2024-01-19 14:48:33', NULL, NULL),
(9, 3, 23, NULL, NULL, NULL, 1, 0, 1, 577, 0, 0, 0, 577, '2024-01-19 14:48:33', '2024-01-19 14:48:33', NULL, NULL),
(10, 3, 27, NULL, NULL, NULL, 3, 0, 1, 2, 0, 0, 0, 6, '2024-01-19 14:48:33', '2024-01-19 14:48:33', NULL, NULL),
(11, 4, 7, NULL, NULL, NULL, 1, 0, 1, 908.18, 0, 10, 90.82, 999, '2024-01-19 14:52:42', '2024-01-19 14:53:31', NULL, NULL),
(12, 4, 17, NULL, NULL, NULL, 1, 0, 1, 499, 0, 0, 0, 499, '2024-01-19 14:52:42', '2024-01-19 14:53:31', NULL, NULL),
(13, 4, 20, NULL, NULL, NULL, 1, 0, 1, 499, 0, 0, 0, 499, '2024-01-19 14:52:42', '2024-01-19 14:53:31', NULL, NULL),
(14, 5, 2, NULL, NULL, NULL, 1, 0, 1, 1144.55, 0, 10, 114.45, 1259, '2024-02-10 06:22:24', '2024-02-10 06:22:24', NULL, NULL),
(15, 6, 1, NULL, NULL, NULL, 1, 0, 1, 1181.81, 0, 10, 118.18, 1299.99, '2024-02-25 07:49:51', '2024-02-25 07:49:51', NULL, NULL),
(16, 7, 1, NULL, NULL, NULL, 2, 0, 1, 1181.81, 0, 10, 236.36, 2599.98, '2024-02-25 07:50:13', '2024-02-25 07:50:13', NULL, NULL),
(17, 8, 2, NULL, NULL, NULL, 1, 0, 1, 1144.55, 0, 10, 114.45, 1259, '2024-02-28 05:27:44', '2024-02-28 05:27:44', NULL, NULL),
(18, 8, 1, NULL, NULL, NULL, 1, 1, 1, 1181.81, 0, 10, 118.18, 1299.99, '2024-02-28 05:27:44', '2024-03-24 07:08:23', NULL, NULL),
(19, 9, 3, NULL, NULL, NULL, 1, 0, 1, 318.18, 0, 10, 31.82, 350, '2024-04-21 05:01:43', '2024-04-21 05:01:43', NULL, NULL),
(25, 13, 3, NULL, NULL, NULL, 1, 0, 1, 318.18, 0, 10, 31.82, 350, '2024-04-28 06:15:44', '2024-04-28 06:15:44', NULL, NULL),
(26, 13, 19, NULL, NULL, NULL, 1, 0, 1, 962.73, 0, 10, 96.27, 1059, '2024-04-28 06:15:44', '2024-04-28 06:15:44', NULL, NULL),
(27, 14, 5, NULL, NULL, NULL, 1, 1, 1, 1046.35, 0, 10, 104.64, 1150.99, '2024-04-29 12:29:56', '2024-04-29 12:30:38', NULL, NULL),
(28, 14, 4, NULL, NULL, NULL, 1, 0, 1, 954.55, 0, 10, 95.45, 1050, '2024-04-29 12:29:56', '2024-04-29 12:29:56', NULL, NULL),
(29, 14, 3, NULL, NULL, NULL, 1, 1, 1, 318.18, 0, 10, 31.82, 350, '2024-04-29 12:29:56', '2024-04-29 12:30:38', NULL, NULL),
(30, 14, 2, NULL, NULL, NULL, 1, 0, 1, 1136.36, 0, 10, 113.64, 1250, '2024-04-29 12:29:56', '2024-04-29 12:29:56', NULL, NULL),
(31, 15, 20, NULL, NULL, NULL, 1, 0, 1, 499, 0, 0, 0, 499, '2024-05-05 05:19:02', '2024-05-05 05:19:02', NULL, NULL),
(37, 20, 2, NULL, NULL, NULL, 1, 0, 1, 1136.36, 0, 10, 113.64, 1250, '2024-05-05 11:29:05', '2024-05-05 11:29:05', NULL, NULL),
(38, 20, 1, NULL, NULL, NULL, 1, 0, 1, 1181.81, 0, 10, 118.18, 1299.99, '2024-05-05 11:29:05', '2024-05-05 11:29:05', NULL, NULL),
(40, 22, 7, NULL, NULL, NULL, 1, 0, 1, 909.08, 0, 10, 90.91, 999.99, '2024-05-08 08:08:51', '2024-05-08 08:08:51', NULL, NULL),
(41, 22, 3, NULL, NULL, NULL, 1, 0, 1, 318.18, 0, 10, 31.82, 350, '2024-05-08 08:08:51', '2024-05-08 08:08:51', NULL, NULL),
(42, 23, 1, NULL, NULL, NULL, 1, 0, 1, 1181.81, 0, 10, 118.18, 1299.99, '2024-05-19 08:24:23', '2024-05-19 08:24:23', NULL, NULL),
(43, 24, 8, NULL, NULL, NULL, 1, 0, 1, 1181.82, 0, 10, 118.18, 1300, '2024-05-19 08:25:30', '2024-05-19 08:25:30', NULL, NULL),
(44, 25, 8, NULL, NULL, NULL, 1, 0, 1, 1181.82, 0, 10, 118.18, 1300, '2024-05-19 08:30:55', '2024-05-19 08:30:55', NULL, NULL),
(49, 28, 4, NULL, NULL, NULL, 1, 0, 1, 954.55, 0, 10, 95.45, 1050, '2024-05-21 07:32:49', '2024-05-21 07:32:49', NULL, NULL),
(50, 29, 2, NULL, NULL, NULL, 1, 0, 1, 1136.36, 0, 10, 113.64, 1250, '2024-06-03 06:26:51', '2024-06-03 06:26:51', NULL, NULL),
(51, 29, 1, NULL, NULL, NULL, 1, 0, 1, 1181.81, 0, 10, 118.18, 1299.99, '2024-06-03 06:26:51', '2024-06-03 06:26:51', NULL, NULL),
(52, 30, 4, NULL, NULL, NULL, 1, 0, 1, 954.55, 0, 10, 95.45, 1050, '2024-06-03 11:30:15', '2024-06-03 11:30:15', NULL, NULL),
(53, 30, 2, NULL, NULL, NULL, 1, 0, 1, 1136.36, 0, 10, 113.64, 1250, '2024-06-03 11:30:15', '2024-06-03 11:30:15', NULL, NULL),
(54, 31, 23, NULL, NULL, NULL, 1, 0, 1, 577, 0, 0, 0, 577, '2024-06-03 11:30:58', '2024-06-03 11:30:58', NULL, NULL),
(55, 32, 1, NULL, NULL, NULL, 1, 0, 1, 1181.81, 0, 10, 118.18, 1299.99, '2024-06-20 07:54:56', '2024-06-20 07:54:56', NULL, NULL),
(56, 33, 1, NULL, NULL, NULL, 1, 1, 1, 1181.81, 0, 10, 118.18, 1299.99, '2024-06-26 07:01:15', '2024-06-26 07:01:42', NULL, NULL),
(59, 36, 23, NULL, NULL, NULL, 1, 0, 1, 577, 0, 0, 0, 577, '2024-07-11 06:10:41', '2024-07-11 06:10:41', NULL, NULL),
(61, 38, 1, NULL, NULL, NULL, 1, 0, 1, 1181.81, 0, 10, 118.18, 1299.99, '2024-07-18 05:36:30', '2024-07-18 05:36:30', NULL, NULL),
(62, 39, 33, NULL, NULL, '1003', 1, 0, 1, 250, 0, 0, 0, 250, '2024-07-18 07:59:13', '2024-07-18 07:59:13', NULL, NULL),
(63, 40, 33, NULL, NULL, '2001', 1, 0, 1, 250, 0, 0, 0, 250, '2024-07-18 08:01:45', '2024-07-18 08:01:45', NULL, NULL),
(65, 42, 23, NULL, NULL, NULL, 1, 0, 1, 577, 0, 0, 0, 577, '2024-08-11 05:06:29', '2024-08-11 05:28:06', 1, 1),
(66, 43, 18, NULL, NULL, NULL, 1, 0, 1, 544.55, 0, 10, 54.45, 599, '2024-08-11 05:37:22', '2024-08-11 05:37:38', NULL, 1),
(68, 45, 2, NULL, NULL, NULL, 1, 0, 1, 1136.36, 0, 10, 113.64, 1250, '2024-08-11 05:48:52', '2024-11-26 16:37:06', NULL, NULL),
(69, 45, 3, NULL, NULL, NULL, 1, 0, 1, 318.18, 0, 10, 31.82, 350, '2024-08-11 05:48:52', '2024-11-26 16:37:07', NULL, NULL),
(70, 46, 1, NULL, NULL, NULL, 1, 0, 1, 1181.81, 0, 10, 118.18, 1299.99, '2024-08-25 23:26:16', '2024-11-26 16:35:18', NULL, NULL),
(71, 47, 4, NULL, NULL, NULL, 1, 0, 1, 954.55, 0, 10, 95.45, 1050, '2024-08-25 23:26:30', '2024-11-26 16:38:31', NULL, NULL),
(74, 50, 3, NULL, NULL, NULL, 1, 0, 1, 318.18, 0, 10, 31.82, 350, '2024-08-25 23:29:29', '2024-11-26 16:20:14', NULL, NULL),
(75, 51, 29, NULL, NULL, 'null', 10, 0, 1, 3.19, 0, 0, 0, 31.9, '2024-11-26 16:17:24', '2024-11-26 16:36:03', NULL, NULL),
(76, 52, 20, NULL, NULL, NULL, 3, 0, 1, 499, 0, 0, 0, 1497, '2024-11-26 16:41:34', '2024-11-26 16:41:34', NULL, NULL),
(77, 53, 1, NULL, NULL, 'null', 1, 0, 1, 1181.81, 0, 10, 118.18, 1299.99, '2024-11-28 05:21:41', '2024-11-28 05:21:41', NULL, NULL),
(78, 54, 20, NULL, NULL, NULL, 3, 0, 1, 499, 0, 0, 0, 1497, '2024-11-28 15:04:21', '2024-11-28 15:04:21', NULL, NULL),
(79, 55, 20, NULL, NULL, NULL, 3, 0, 1, 499, 0, 0, 0, 1497, '2024-11-28 15:07:19', '2024-11-28 15:07:19', NULL, NULL),
(80, 56, 20, NULL, NULL, NULL, 3, 0, 1, 499, 0, 0, 0, 1497, '2024-11-28 15:12:48', '2024-11-28 15:12:48', NULL, NULL),
(81, 57, 2, NULL, NULL, 'null', 1, 0, 1, 1136.36, 0, 10, 113.64, 1250, '2025-09-28 17:07:23', '2025-09-28 17:07:23', NULL, NULL),
(82, 57, 7, NULL, NULL, 'null', 1, 0, 1, 909.08, 0, 10, 90.91, 999.99, '2025-09-28 17:07:23', '2025-09-28 17:07:23', NULL, NULL);

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

--
-- 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,
  `product_batch_id` int(11) DEFAULT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `imei_number` text 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`, `product_batch_id`, `variant_id`, `imei_number`, `qty`, `purchase_unit_id`, `net_unit_cost`, `tax_rate`, `tax`, `total`, `created_at`, `updated_at`) VALUES
(11, 11, 23, NULL, NULL, NULL, 1, 1, 439, 0, 0, 439, '2024-05-28 09:05:50', '2024-05-28 09:05:50'),
(12, 12, 20, NULL, NULL, NULL, 1, 1, 399, 0, 0, 399, '2024-05-28 09:07:14', '2024-05-28 09:07:14');

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

--
-- 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) NOT NULL,
  `additional_cost` double DEFAULT 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;

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

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

CREATE TABLE `product_warehouse` (
  `id` int(10) UNSIGNED NOT NULL,
  `product_id` varchar(191) NOT NULL,
  `product_batch_id` int(11) DEFAULT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `imei_number` text DEFAULT NULL,
  `warehouse_id` int(11) NOT NULL,
  `qty` double NOT 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`, `product_batch_id`, `variant_id`, `imei_number`, `warehouse_id`, `qty`, `price`, `created_at`, `updated_at`) VALUES
(1, '23', NULL, NULL, NULL, 1, 6, 577, '2024-01-19 13:46:04', '2024-08-11 05:25:42'),
(2, '27', NULL, NULL, NULL, 1, 10, 1.29, '2024-01-19 13:46:04', '2024-07-11 06:12:35'),
(3, '20', NULL, NULL, NULL, 1, -4, 499, '2024-01-19 13:46:04', '2024-11-28 15:12:48'),
(4, '17', NULL, NULL, NULL, 1, 10, 499, '2024-01-19 13:46:04', '2024-04-28 06:05:43'),
(5, '16', NULL, NULL, NULL, 1, 10, 109, '2024-01-19 13:46:04', '2024-07-11 06:31:01'),
(6, '30', NULL, NULL, NULL, 1, 10, 200, '2024-01-19 13:46:04', '2024-01-19 13:46:04'),
(7, '19', NULL, NULL, NULL, 1, 9, 1059, '2024-01-19 13:46:04', '2024-05-28 08:46:50'),
(8, '3', NULL, NULL, '', 1, 5, 350, '2024-01-19 13:46:05', '2024-11-26 16:37:06'),
(9, '7', NULL, NULL, NULL, 1, 12, NULL, '2024-01-19 13:46:05', '2025-09-28 17:07:23'),
(10, '2', NULL, NULL, '', 1, 1, NULL, '2024-01-19 13:46:05', '2025-09-28 17:07:23'),
(11, '6', NULL, NULL, NULL, 1, 10, 1111.99, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(12, '13', NULL, NULL, NULL, 1, 10, 349, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(13, '10', NULL, NULL, NULL, 1, 10, 1250, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(14, '21', NULL, NULL, NULL, 1, 10, 599, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(15, '8', NULL, NULL, NULL, 1, 8, 1300, '2024-01-19 13:50:04', '2024-05-19 08:30:55'),
(16, '12', NULL, NULL, NULL, 1, 10, 1250, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(17, '29', NULL, NULL, NULL, 1, 0, 3.19, '2024-01-19 13:50:04', '2024-11-26 16:36:03'),
(18, '26', NULL, NULL, NULL, 1, 10, 3.99, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(19, '9', NULL, NULL, NULL, 1, 10, 559, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(20, '11', NULL, NULL, NULL, 1, 10, 1750, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(21, '1', NULL, NULL, '', 1, 1, 1299.99, '2024-01-19 13:53:21', '2024-11-28 05:21:41'),
(22, '18', NULL, NULL, NULL, 1, 10, 599, '2024-01-19 13:53:21', '2024-01-19 13:53:21'),
(23, '25', NULL, NULL, NULL, 1, 10, 157.99, '2024-01-19 13:53:21', '2024-01-19 13:53:21'),
(24, '28', NULL, NULL, NULL, 1, 10, 3.3, '2024-01-19 13:53:21', '2024-01-19 13:53:21'),
(25, '14', NULL, NULL, NULL, 1, 9, 499, '2024-01-19 13:53:21', '2024-01-19 14:40:16'),
(26, '24', NULL, NULL, NULL, 1, 10, 379, '2024-01-19 13:53:21', '2024-01-19 13:53:21'),
(27, '4', NULL, NULL, '', 1, 6, 1050, '2024-01-19 13:53:21', '2024-11-26 16:38:31'),
(28, '5', NULL, NULL, NULL, 1, 10, 1150.99, '2024-01-19 13:53:21', '2024-08-25 23:29:53'),
(29, '22', NULL, NULL, NULL, 1, 10, 399, '2024-01-19 13:53:21', '2024-01-19 13:53:21'),
(30, '15', NULL, NULL, NULL, 1, 10, 547, '2024-01-19 13:53:21', '2024-01-19 13:53:21'),
(31, '1', NULL, NULL, NULL, 2, 11, 1299.99, '2024-01-19 14:26:48', '2024-01-19 14:26:48'),
(32, '18', NULL, NULL, NULL, 2, 7, 599, '2024-01-19 14:26:48', '2024-08-11 05:37:38'),
(33, '25', NULL, NULL, NULL, 2, 10, 157.99, '2024-01-19 14:26:48', '2024-01-19 14:26:48'),
(34, '28', NULL, NULL, NULL, 2, 10, 3.3, '2024-01-19 14:26:48', '2024-01-19 14:26:48'),
(35, '14', NULL, NULL, NULL, 2, 10, 499, '2024-01-19 14:26:49', '2024-01-19 14:26:49'),
(36, '24', NULL, NULL, NULL, 2, 10, 379, '2024-01-19 14:26:49', '2024-01-19 14:26:49'),
(37, '4', NULL, NULL, NULL, 2, 9, 1050, '2024-01-19 14:26:49', '2024-01-19 14:44:41'),
(38, '5', NULL, NULL, NULL, 2, 10, 1150.99, '2024-01-19 14:26:49', '2024-01-19 14:26:49'),
(39, '22', NULL, NULL, NULL, 2, 10, 399, '2024-01-19 14:26:49', '2024-01-19 14:26:49'),
(40, '15', NULL, NULL, NULL, 2, 10, 547, '2024-01-19 14:26:49', '2024-01-19 14:26:49'),
(41, '23', NULL, NULL, NULL, 2, 10, 577, '2024-01-19 14:28:26', '2024-05-28 09:05:50'),
(42, '27', NULL, NULL, NULL, 2, 7, 1.29, '2024-01-19 14:28:26', '2024-01-19 14:48:33'),
(43, '20', NULL, NULL, NULL, 2, 11, 499, '2024-01-19 14:28:26', '2024-05-28 09:07:14'),
(44, '17', NULL, NULL, NULL, 2, 10, 499, '2024-01-19 14:28:26', '2024-01-19 14:28:26'),
(45, '16', NULL, NULL, NULL, 2, 9, 109, '2024-01-19 14:28:26', '2024-01-19 14:44:41'),
(46, '30', NULL, NULL, NULL, 2, 10, 200, '2024-01-19 14:28:26', '2024-01-19 14:28:26'),
(47, '19', NULL, NULL, NULL, 2, 10, 1059, '2024-01-19 14:28:26', '2024-05-28 08:46:50'),
(48, '3', NULL, NULL, NULL, 2, 8, 350, '2024-01-19 14:28:26', '2024-01-19 14:44:41'),
(49, '7', NULL, NULL, NULL, 2, 10, NULL, '2024-01-19 14:28:26', '2024-05-23 07:38:12'),
(50, '2', NULL, NULL, NULL, 2, 10, NULL, '2024-01-19 14:28:26', '2024-03-07 07:13:42'),
(51, '6', NULL, NULL, NULL, 2, 10, 1111.99, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(52, '13', NULL, NULL, NULL, 2, 10, 349, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(53, '10', NULL, NULL, NULL, 2, 10, 1250, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(54, '21', NULL, NULL, NULL, 2, 10, 599, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(55, '8', NULL, NULL, NULL, 2, 10, 1300, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(56, '12', NULL, NULL, NULL, 2, 10, 1250, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(57, '29', NULL, NULL, NULL, 2, 10, 3.19, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(58, '26', NULL, NULL, NULL, 2, 10, 3.99, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(59, '9', NULL, NULL, NULL, 2, 9, 559, '2024-01-19 14:28:35', '2024-01-19 14:44:41'),
(60, '11', NULL, NULL, NULL, 2, 10, 1750, '2024-01-19 14:28:35', '2024-01-19 14:28:35'),
(61, '32', NULL, NULL, NULL, 1, 0, NULL, '2024-04-29 12:29:17', '2024-04-29 12:29:17'),
(62, '32', NULL, NULL, NULL, 2, 0, NULL, '2024-04-29 12:29:17', '2024-04-29 12:29:17'),
(63, '33', NULL, NULL, '1001,1002,1004,1005', 1, 4, NULL, '2024-07-18 07:39:33', '2024-07-18 07:59:13'),
(64, '33', NULL, NULL, '2002,2003,2004,2005,', 2, 4, NULL, '2024-07-18 07:39:33', '2024-07-18 08:01:45');

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

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

CREATE TABLE `purchases` (
  `id` int(10) UNSIGNED NOT NULL,
  `reference_no` varchar(191) NOT NULL,
  `user_id` int(11) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `currency_id` int(11) DEFAULT NULL,
  `exchange_rate` double 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) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `purchases` (`id`, `reference_no`, `user_id`, `warehouse_id`, `supplier_id`, `currency_id`, `exchange_rate`, `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-20240119-074604', 1, 1, 1, 1, 1, 10, 100, 0, 2917.26, 44758.8, 0, 0, 0, 0, 44758.8, 0, 1, 1, NULL, NULL, '2024-01-19 13:46:04', '2024-01-19 13:46:04'),
(2, 'pr-20240119-075004', 1, 1, 1, 1, 1, 10, 100, 0, 3589.09, 67113.7, 0, 0, 0, 0, 67113.7, 0, 1, 1, NULL, NULL, '2024-01-19 13:50:04', '2024-01-19 13:50:04'),
(3, 'pr-20240119-075321', 1, 1, NULL, 1, 1, 10, 100, 0, 3689.98, 49653.7, 0, 0, 0, 0, 49653.7, 0, 1, 1, NULL, NULL, '2024-01-19 13:53:21', '2024-01-19 13:53:21'),
(4, 'pr-20240119-082648', 1, 2, 1, NULL, NULL, 10, 101, 0, 3789.98, 50753.69, 0, 0, 0, 0, 50753.69, 0, 1, 1, NULL, NULL, '2024-01-18 18:00:00', '2024-01-19 14:26:48'),
(5, 'pr-20240119-082826', 1, 2, 1, NULL, NULL, 10, 100, 0, 2917.26, 44758.8, 0, 0, 0, 0, 44758.8, 0, 1, 1, NULL, NULL, '2024-01-18 18:00:00', '2024-01-19 14:28:26'),
(6, 'pr-20240119-082835', 1, 2, 1, NULL, NULL, 10, 100, 0, 3589.09, 67113.7, 0, 0, 0, 0, 67113.7, 0, 1, 1, NULL, NULL, '2024-01-18 18:00:00', '2024-01-19 14:28:35'),
(7, 'pr-20240119-085202', 1, 1, 1, NULL, NULL, 2, 2, 0, 0, 748, 0, 0, 0, 0, 748, 0, 1, 1, NULL, NULL, '2024-01-19 14:52:02', '2024-01-19 14:52:02'),
(8, 'pr-20240204-011347', 1, 1, NULL, 1, 1, 1, 6, 0, 480, 5280, 0, 0, 0, 0, 5280, 0, 1, 1, NULL, NULL, '2024-02-03 18:00:00', '2024-06-20 05:08:26'),
(9, 'pr-20240718-014145', 1, 1, 1, 1, 1, 1, 5, 0, 0, 500, 0, 0, 0, 0, 500, 0, 1, 1, NULL, NULL, '2024-07-18 07:41:45', '2024-07-18 07:41:45'),
(10, 'pr-20240718-014928', 1, 2, 2, NULL, NULL, 1, 5, 0, 0, 500, 0, 0, 0, 0, 500, 0, 1, 1, NULL, NULL, '2024-07-17 18:00:00', '2024-07-18 07:51:35');

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

--
-- 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,
  `product_batch_id` int(11) DEFAULT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `imei_number` text 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) 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) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quotations`
--

INSERT INTO `quotations` (`id`, `reference_no`, `user_id`, `biller_id`, `supplier_id`, `customer_id`, `warehouse_id`, `item`, `total_qty`, `total_discount`, `total_tax`, `total_price`, `order_tax_rate`, `order_tax`, `order_discount`, `shipping_cost`, `grand_total`, `quotation_status`, `document`, `note`, `created_at`, `updated_at`) VALUES
(1, 'qr-20240119-085132', 1, 1, 1, 1, 1, 2, 2, 0, 0, 998, 0, 0, NULL, NULL, 998, 1, NULL, NULL, '2024-01-19 14:51:32', '2024-01-19 14:51:32'),
(2, 'qr-20240825-060117', 1, 1, 1, 2, 1, 1, 3, 0, 0, 1497, 0, 0, NULL, NULL, 1497, 1, NULL, NULL, '2024-08-25 23:01:17', '2024-08-25 23:01:17');

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

--
-- Table structure for table `returns`
--

CREATE TABLE `returns` (
  `id` int(10) UNSIGNED NOT NULL,
  `reference_no` varchar(191) NOT NULL,
  `user_id` int(11) NOT NULL,
  `sale_id` int(11) DEFAULT 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,
  `currency_id` int(11) DEFAULT NULL,
  `exchange_rate` double 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,
  `order_tax_rate` double DEFAULT NULL,
  `order_tax` double DEFAULT NULL,
  `grand_total` double NOT NULL,
  `document` varchar(191) DEFAULT NULL,
  `return_note` text DEFAULT NULL,
  `staff_note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `returns`
--

INSERT INTO `returns` (`id`, `reference_no`, `user_id`, `sale_id`, `cash_register_id`, `customer_id`, `warehouse_id`, `biller_id`, `account_id`, `currency_id`, `exchange_rate`, `item`, `total_qty`, `total_discount`, `total_tax`, `total_price`, `order_tax_rate`, `order_tax`, `grand_total`, `document`, `return_note`, `staff_note`, `created_at`, `updated_at`) VALUES
(1, 'rr-20240324-010823', 1, 8, 2, 2, 1, 1, 1, 1, 1, 1, 1, 0, 118.18, 1299.99, 0, 0, 1299.99, NULL, NULL, NULL, '2024-03-24 07:08:23', '2024-03-24 07:08:23'),
(2, 'rr-20240429-063038', 1, 14, 2, 2, 1, 1, 1, 1, 1, 2, 2, 0, 136.46, 1500.99, 0, 0, 1500.99, NULL, NULL, NULL, '2024-04-29 12:30:38', '2024-04-29 12:30:38'),
(3, 'rr-20240626-010142', 1, 33, 2, 2, 1, 1, 1, 1, 1, 1, 1, 0, 118.18, 1299.99, 0, 0, 1299.99, NULL, NULL, NULL, '2024-06-26 07:01:42', '2024-06-26 07:01:42');

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

--
-- Table structure for table `return_purchases`
--

CREATE TABLE `return_purchases` (
  `id` int(10) UNSIGNED NOT NULL,
  `reference_no` varchar(191) NOT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `warehouse_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `purchase_id` int(11) DEFAULT NULL,
  `account_id` int(11) NOT NULL,
  `currency_id` int(11) DEFAULT NULL,
  `exchange_rate` double 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,
  `grand_total` double NOT NULL,
  `document` varchar(191) DEFAULT NULL,
  `return_note` text DEFAULT NULL,
  `staff_note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `reward_point_settings`
--

CREATE TABLE `reward_point_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `per_point_amount` double NOT NULL,
  `minimum_amount` double NOT NULL,
  `duration` int(11) DEFAULT NULL,
  `type` varchar(191) 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 `reward_point_settings`
--

INSERT INTO `reward_point_settings` (`id`, `per_point_amount`, `minimum_amount`, `duration`, `type`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 300, 1000, 1, 'Year', 1, '2021-06-08 15:40:15', '2021-06-27 05:20:55');

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

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

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` text DEFAULT NULL,
  `guard_name` varchar(191) 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', 'Staff of shop', 'web', 1, '2018-10-22 02:38:13', '2022-02-01 13:13:30'),
(4, 'staff', 'staff has specific acess...', 'web', 1, '2018-06-02 00:05:27', '2022-02-01 13:13:04'),
(5, 'Customer', NULL, 'web', 1, '2020-11-05 06:43:16', '2020-11-15 00:24:15');

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

--
-- 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),
(89, 4),
(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, 4),
(107, 1),
(108, 1),
(109, 1),
(110, 1),
(111, 1),
(112, 1),
(113, 1),
(114, 1),
(115, 1),
(116, 1),
(117, 1),
(118, 1),
(119, 1),
(120, 1),
(121, 1),
(122, 1),
(123, 1),
(124, 1),
(125, 1),
(126, 1),
(127, 1),
(128, 1),
(129, 1),
(130, 1),
(131, 1),
(132, 1);

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

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

CREATE TABLE `sales` (
  `id` int(10) UNSIGNED NOT NULL,
  `reference_no` varchar(191) NOT NULL,
  `user_id` int(11) NOT NULL,
  `cash_register_id` int(11) DEFAULT NULL,
  `table_id` int(11) DEFAULT NULL,
  `queue` 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,
  `currency_id` int(11) DEFAULT NULL,
  `exchange_rate` double DEFAULT NULL,
  `order_tax_rate` double DEFAULT NULL,
  `order_tax` double DEFAULT NULL,
  `order_discount_type` varchar(191) DEFAULT NULL,
  `order_discount_value` 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) DEFAULT NULL,
  `paid_amount` double DEFAULT NULL,
  `sale_note` text DEFAULT NULL,
  `staff_note` text DEFAULT NULL,
  `woocommerce_order_id` int(11) 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 `sales`
--

INSERT INTO `sales` (`id`, `reference_no`, `user_id`, `cash_register_id`, `table_id`, `queue`, `customer_id`, `warehouse_id`, `biller_id`, `item`, `total_qty`, `total_discount`, `total_tax`, `total_price`, `grand_total`, `currency_id`, `exchange_rate`, `order_tax_rate`, `order_tax`, `order_discount_type`, `order_discount_value`, `order_discount`, `coupon_id`, `coupon_discount`, `shipping_cost`, `sale_status`, `payment_status`, `document`, `paid_amount`, `sale_note`, `staff_note`, `woocommerce_order_id`, `created_at`, `updated_at`) VALUES
(1, 'posr-20240119-084016', 1, NULL, NULL, NULL, 1, 1, 1, 2, 2, 0, 159.81, 1758, 1758, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 1758, NULL, NULL, NULL, '2024-01-19 14:40:16', '2024-01-19 14:40:16'),
(2, 'posr-20240119-084441', 1, NULL, NULL, NULL, 1, 2, 1, 5, 6, 0, 213.54, 3017, 3017, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 3017, NULL, NULL, NULL, '2024-01-19 14:44:41', '2024-01-19 14:44:41'),
(3, 'sr-20240119-084833', 1, 1, NULL, NULL, 2, 2, 1, 3, 5, 0, 54.45, 1182, 1182, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, '2024-01-19 14:48:33', '2024-01-19 14:48:33'),
(4, 'sr-20240119-085242', 1, 2, NULL, NULL, 1, 1, 1, 3, 3, 0, 90.82, 1997, 1997, NULL, NULL, 0, 0, 'Flat', 0, 0, NULL, NULL, 0, 1, 2, NULL, NULL, NULL, NULL, NULL, '2024-01-18 18:00:00', '2024-01-19 14:53:31'),
(5, 'posr-20240210-122224', 1, 2, NULL, NULL, 2, 1, 1, 1, 1, 0, 114.45, 1259, 1259, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 1259, NULL, NULL, NULL, '2024-02-10 06:22:24', '2024-02-10 06:22:24'),
(6, 'posr-20240225-014951', 1, 2, NULL, NULL, 2, 1, 1, 1, 1, 0, 118.18, 1299.99, 1299.99, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 1299.99, NULL, NULL, NULL, '2024-02-25 07:49:51', '2024-02-25 07:49:51'),
(7, 'posr-20240225-015013', 1, 2, NULL, NULL, 2, 1, 1, 1, 2, 0, 236.36, 2599.98, 2599.98, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 2599.98, NULL, NULL, NULL, '2024-02-25 07:50:13', '2024-02-25 07:50:13'),
(8, 'posr-20240228-112744', 1, 2, NULL, NULL, 2, 1, 1, 2, 2, 0, 232.63, 2558.99, 2558.99, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 2558.99, NULL, NULL, NULL, '2024-02-28 05:27:44', '2024-02-28 05:27:44'),
(9, 'posr-20240421-110143', 1, 2, 1, 1, 2, 1, 1, 1, 1, 0, 31.82, 350, 350, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 350, NULL, NULL, NULL, '2024-04-21 05:01:43', '2024-04-21 05:01:43'),
(13, 'posr-20240428-121544', 1, 2, NULL, NULL, 2, 1, 1, 2, 2, 0, 128.09, 1409, 1409, 1, 1, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, 1, 4, NULL, 1409, NULL, NULL, NULL, '2024-04-28 06:15:44', '2024-04-28 06:15:44'),
(14, 'posr-20240429-062956', 1, 2, NULL, NULL, 2, 1, 1, 4, 4, 0, 345.55, 3800.99, 3800.99, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 3800.99, NULL, NULL, NULL, '2024-04-29 12:29:56', '2024-04-29 12:29:56'),
(15, 'sr-20240505-111902', 1, 2, NULL, NULL, 2, 1, 1, 1, 1, 0, 0, 499, 499, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 2, NULL, 0, NULL, NULL, NULL, '2024-05-05 05:19:02', '2024-05-05 05:20:14'),
(20, 'posr-20240505-052905', 1, 2, NULL, NULL, 2, 1, 1, 2, 2, 0, 231.82, 2549.99, 2549.99, 1, 1, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, 1, 4, NULL, 2549.99, NULL, NULL, NULL, '2024-05-05 11:29:05', '2024-05-05 11:29:05'),
(22, 'posr-20240508-020851', 1, 2, NULL, NULL, 2, 1, 1, 2, 2, 0, 122.73, 1349.99, 1349.99, 1, 1, NULL, 0, NULL, NULL, 0, NULL, NULL, 0, 1, 4, NULL, 1349.99, NULL, NULL, NULL, '2024-05-08 08:08:51', '2024-05-08 08:08:51'),
(23, 'posr-20240519-022423', 1, 2, NULL, NULL, 2, 1, 1, 1, 1, 0, 118.18, 1299.99, 1299.99, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 1299.99, NULL, NULL, NULL, '2024-05-19 08:24:23', '2024-05-19 08:24:23'),
(24, 'posr-20240519-022530', 1, 2, NULL, NULL, 2, 1, 1, 1, 1, 0, 118.18, 1300, 1300, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 1300, NULL, NULL, NULL, '2024-05-19 08:25:30', '2024-05-19 08:25:30'),
(25, 'posr-20240519-023055', 1, 2, NULL, NULL, 2, 1, 1, 1, 1, 0, 118.18, 1300, 1300, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 1300, NULL, NULL, NULL, '2024-05-19 08:30:55', '2024-05-19 08:30:55'),
(28, 'posr-20240521-013249', 1, 2, NULL, NULL, 2, 1, 1, 1, 1, 0, 95.45, 1050, 1050, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 1050, NULL, NULL, NULL, '2024-05-21 07:32:49', '2024-05-21 07:32:49'),
(29, 'posr-20240603-122651', 1, 2, NULL, NULL, 2, 1, 1, 2, 2, 0, 231.82, 2549.99, 2549.99, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 2549.99, NULL, NULL, NULL, '2024-06-03 06:26:51', '2024-06-03 06:29:06'),
(30, 'posr-20240603-053015', 1, 2, NULL, NULL, 2, 1, 1, 2, 2, 0, 209.09, 2300, 2300, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 2300, NULL, NULL, NULL, '2024-06-03 11:30:15', '2024-06-03 11:30:15'),
(31, 'sr-20240603-053058', 1, 2, NULL, NULL, 1, 1, 1, 1, 1, 0, 0, 577, 577, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, '2024-06-03 11:30:58', '2024-06-03 11:30:58'),
(32, 'posr-20240620-015456', 1, 2, NULL, NULL, 2, 1, 1, 1, 1, 0, 118.18, 1299.99, 1299.99, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 3, 2, NULL, NULL, NULL, NULL, NULL, '2024-06-20 07:54:56', '2024-06-20 07:54:56'),
(33, 'posr-20240626-010115', 1, 2, NULL, NULL, 2, 1, 1, 1, 1, 0, 118.18, 1299.99, 1299.99, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 4, 4, NULL, 1299.99, NULL, NULL, NULL, '2024-06-26 07:01:15', '2024-06-26 07:01:42'),
(36, 'sr-20240711-121041', 1, 2, NULL, NULL, 1, 1, 1, 1, 1, 0, 0, 577, 577, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, '2024-07-07 18:00:00', '2024-07-11 06:10:41'),
(38, 'posr-20240718-113630', 1, 2, NULL, NULL, 2, 1, 1, 1, 1, 0, 118.18, 1299.99, 1299.99, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 1299.99, NULL, NULL, NULL, '2024-07-18 05:36:30', '2024-07-18 05:36:30'),
(39, 'posr-20240718-015913', 1, 2, NULL, NULL, 2, 1, 1, 1, 1, 0, 0, 250, 250, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 250, NULL, NULL, NULL, '2024-07-18 07:59:13', '2024-07-18 07:59:13'),
(40, 'posr-20240718-020145', 1, 1, NULL, NULL, 2, 2, 1, 1, 1, 0, 0, 250, 250, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 250, NULL, NULL, NULL, '2024-07-18 08:01:45', '2024-07-18 08:01:45'),
(42, 'sr-20240811-110629', 1, 2, NULL, NULL, 2, 1, 1, 1, 1, 0, 0, 577, 577, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 1, 4, NULL, 577, NULL, NULL, NULL, '2024-08-11 05:06:29', '2024-08-11 05:28:06'),
(43, 'sr-20240811-113722', 1, 1, NULL, NULL, 2, 2, 1, 1, 1, 0, 54.45, 599, 599, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, NULL, 0, 5, 1, NULL, NULL, NULL, NULL, NULL, '2024-08-11 05:37:22', '2024-08-11 05:37:38'),
(45, 'posr-20240811-114852', 1, 2, NULL, NULL, 2, 1, 1, 2, 2, 0, 145.46, 1600, 1600, 1, 1, 0, 0, 'Flat', 0, 0, NULL, NULL, 0, 1, 4, NULL, 1600, NULL, NULL, NULL, '2024-08-11 16:37:06', '2024-11-26 16:37:07'),
(46, 'posr-20240825-062616', 1, 3, NULL, NULL, 2, 1, 1, 1, 1, 0, 118.18, 1299.99, 1299.99, 1, 1, 0, 0, 'Flat', 0, 0, NULL, NULL, 0, 1, 4, NULL, 1299.99, NULL, NULL, NULL, '2024-08-25 18:00:00', '2024-11-26 16:35:18'),
(47, 'posr-20240825-062630', 1, 3, NULL, NULL, 2, 1, 1, 1, 1, 0, 95.45, 1050, 1050, 1, 1, 0, 0, 'Flat', 0, 0, NULL, NULL, 0, 1, 4, NULL, 1050, NULL, NULL, NULL, '2024-08-26 16:38:31', '2024-11-26 16:38:31'),
(50, 'posr-20240825-062929', 1, 3, NULL, NULL, 2, 1, 1, 1, 1, 0, 31.82, 350, 350, 1, 1, 0, 0, 'Flat', 0, 0, NULL, NULL, 0, 1, 4, NULL, 350, NULL, NULL, NULL, '2024-08-26 16:20:15', '2024-11-26 16:20:15'),
(51, 'sr-20241126-101723', 1, 3, NULL, NULL, 2, 1, 1, 1, 10, 0, 0, 31.9, 31.9, 1, 1, 0, 0, 'Flat', 0, 0, NULL, NULL, 0, 1, 4, NULL, 31.9, NULL, NULL, NULL, '2024-11-26 16:36:03', '2024-11-26 16:36:04'),
(52, 'sr-20241126-104134', 1, 3, NULL, NULL, 2, 1, 1, 1, 3, 0, 0, 1497, 1497, NULL, NULL, 0, 0, 'Flat', 0, NULL, NULL, NULL, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, '2024-11-26 16:41:34', '2024-11-26 16:41:34'),
(53, 'posr-20241128-112140', 1, 3, NULL, NULL, 2, 1, 1, 1, 1, 0, 118.18, 1299.99, 1299.99, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, 0, 0, 1, 4, NULL, 1299.99, NULL, NULL, NULL, '2024-11-28 05:21:40', '2024-11-28 05:21:40'),
(54, 'sr-20241128-090420', 1, 3, NULL, NULL, 2, 1, 1, 1, 3, 0, 0, 1497, 1497, NULL, NULL, 0, 0, 'Flat', 0, NULL, NULL, NULL, 0, 1, 4, NULL, 1497, NULL, NULL, NULL, '2024-11-28 15:04:20', '2024-11-28 15:04:20'),
(55, 'sr-20241128-090719', 1, 3, NULL, NULL, 2, 1, 1, 1, 3, 0, 0, 1497, 1497, NULL, NULL, 0, 0, 'Flat', 0, NULL, NULL, NULL, 0, 1, 4, NULL, 1497, NULL, NULL, NULL, '2024-11-28 15:07:19', '2024-11-28 15:07:19'),
(56, 'sr-20241128-091248', 1, 3, NULL, NULL, 2, 1, 1, 1, 3, 0, 0, 1497, 1497, NULL, NULL, 0, 0, 'Flat', 0, NULL, NULL, NULL, 0, 1, 4, NULL, 1497, NULL, NULL, NULL, '2024-11-28 15:12:48', '2024-11-28 15:12:48'),
(57, 'posr-20250928-050723', 1, 3, NULL, NULL, 2, 1, 1, 2, 2, 0, 204.55, 2249.99, 2249.99, 1, 1, 0, 0, 'Flat', NULL, 0, NULL, 0, 0, 1, 4, NULL, 2249.99, NULL, NULL, NULL, '2025-09-28 17:07:23', '2025-09-28 17:07:23');

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

--
-- Table structure for table `sms_templates`
--

CREATE TABLE `sms_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `is_default_ecommerce` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sms_templates`
--

INSERT INTO `sms_templates` (`id`, `name`, `content`, `is_default`, `is_default_ecommerce`, `created_at`, `updated_at`) VALUES
(1, 'test template', 'eso nije kori...', 1, 0, '2024-05-19 08:14:12', '2024-10-28 20:07:53'),
(2, 'test template 2', 'fsdfsdf', 0, 1, '2024-05-19 08:20:25', '2024-10-28 20:07:53');

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

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

CREATE TABLE `stock_counts` (
  `id` int(10) UNSIGNED NOT NULL,
  `reference_no` varchar(191) NOT NULL,
  `warehouse_id` int(11) NOT NULL,
  `category_id` varchar(191) DEFAULT NULL,
  `brand_id` varchar(191) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `type` varchar(191) NOT NULL,
  `initial_file` varchar(191) DEFAULT NULL,
  `final_file` varchar(191) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `is_adjusted` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `stock_counts` (`id`, `reference_no`, `warehouse_id`, `category_id`, `brand_id`, `user_id`, `type`, `initial_file`, `final_file`, `note`, `is_adjusted`, `created_at`, `updated_at`) VALUES
(1, 'scr-20240825-060302', 1, NULL, NULL, 1, 'full', '20240825-060302.csv', NULL, NULL, 0, '2024-08-25 23:03:02', '2024-08-25 23:03:02');

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

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

CREATE TABLE `suppliers` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `image` varchar(191) DEFAULT NULL,
  `company_name` varchar(191) NOT NULL,
  `vat_number` varchar(191) DEFAULT NULL,
  `email` varchar(191) NOT NULL,
  `phone_number` varchar(191) NOT NULL,
  `address` varchar(191) NOT NULL,
  `city` varchar(191) NOT NULL,
  `state` varchar(191) DEFAULT NULL,
  `postal_code` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `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, 'Abdullah', NULL, 'Global Tech', '31213131', 'abdullah@gmail.com', '312313', 'Mirpur', 'Dhaka', NULL, NULL, 'Bangladesh', 1, '2024-01-19 13:41:37', '2024-01-19 13:41:37'),
(2, 'rahmatullah', NULL, 'Samsung', NULL, 'info@microsoft.com', '213123123', 'boropul, halishahr', 'chittagong', NULL, NULL, NULL, 1, '2024-07-18 07:51:07', '2024-07-18 07:51:07');

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

--
-- Table structure for table `tables`
--

CREATE TABLE `tables` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `number_of_person` int(11) DEFAULT NULL,
  `description` text 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 `tables`
--

INSERT INTO `tables` (`id`, `name`, `number_of_person`, `description`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Table 1', 3, 'middle table', 1, '2024-04-21 04:58:24', '2024-04-21 04:58:24');

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

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

CREATE TABLE `taxes` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `rate` double NOT NULL,
  `is_active` tinyint(1) DEFAULT NULL,
  `woocommerce_tax_id` int(11) 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 `taxes`
--

INSERT INTO `taxes` (`id`, `name`, `rate`, `is_active`, `woocommerce_tax_id`, `created_at`, `updated_at`) VALUES
(1, '@10', 10, 1, NULL, '2024-01-08 05:26:16', '2024-01-08 05:26:16'),
(2, '@15', 15, 1, NULL, '2024-01-08 05:26:29', '2024-01-08 05:26:29'),
(3, 'vat 20%', 20, 1, NULL, '2024-04-29 12:28:49', '2024-04-29 12:28:49');

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

--
-- Table structure for table `transfers`
--

CREATE TABLE `transfers` (
  `id` int(10) UNSIGNED NOT NULL,
  `reference_no` varchar(191) 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) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `is_sent` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `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`, `is_sent`, `created_at`, `updated_at`) VALUES
(11, 'tr-20240528-030550', 1, 1, 1, 2, 1, 1, 0, 439, NULL, 439, NULL, NULL, 1, '2024-05-28 09:05:50', '2024-05-28 09:05:56'),
(12, 'tr-20240528-030714', 1, 1, 1, 2, 1, 1, 0, 399, NULL, 399, NULL, NULL, 1, '2024-05-28 09:07:14', '2024-05-28 09:07:20');

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

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

CREATE TABLE `units` (
  `id` int(10) UNSIGNED NOT NULL,
  `unit_code` varchar(191) NOT NULL,
  `unit_name` varchar(191) NOT NULL,
  `base_unit` int(11) DEFAULT NULL,
  `operator` varchar(191) 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, '2024-01-08 05:37:39', '2024-01-08 05:37:39'),
(2, 'dozen', 'Dozen', 1, '*', 12, 1, '2024-01-08 05:38:27', '2024-01-08 05:38:27'),
(3, 'carton', 'Carton', 1, '*', 24, 1, '2024-01-08 05:39:01', '2024-01-08 05:39:01'),
(4, 'kg', 'Kilogram', NULL, '*', 1, 1, '2024-01-08 05:39:37', '2024-01-08 05:39:37'),
(5, 'gm', 'Gram', 4, '/', 1000, 1, '2024-01-08 05:40:00', '2024-01-08 05:40:00');

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

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

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

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

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

CREATE TABLE `warehouses` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `address` text 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, 'Shop 1', '97090998', 'ashfaqdev.php@gmail.com', 'london', 1, '2024-01-19 13:28:31', '2024-05-28 07:56:14'),
(2, 'Shop 2', '8098098', 'ashfaqdev.php@gmail.com', 'Liverpool', 1, '2024-01-19 13:28:52', '2024-05-28 07:57:05');

--
-- 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 `barcodes`
--
ALTER TABLE `barcodes`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `brands`
--
ALTER TABLE `brands`
  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 `challans`
--
ALTER TABLE `challans`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `couriers`
--
ALTER TABLE `couriers`
  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 `custom_fields`
--
ALTER TABLE `custom_fields`
  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 `discounts`
--
ALTER TABLE `discounts`
  ADD PRIMARY KEY (`id`);

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

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

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

--
-- Indexes for table `dso_alerts`
--
ALTER TABLE `dso_alerts`
  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 `external_services`
--
ALTER TABLE `external_services`
  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 `incomes`
--
ALTER TABLE `incomes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `income_categories`
--
ALTER TABLE `income_categories`
  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 `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);

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

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

--
-- 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 `productions`
--
ALTER TABLE `productions`
  ADD PRIMARY KEY (`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_batches`
--
ALTER TABLE `product_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_productions`
--
ALTER TABLE `product_productions`
  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_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 `returns`
--
ALTER TABLE `returns`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `reward_point_settings`
--
ALTER TABLE `reward_point_settings`
  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 `sms_templates`
--
ALTER TABLE `sms_templates`
  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 `tables`
--
ALTER TABLE `tables`
  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 `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 `barcodes`
--
ALTER TABLE `barcodes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `dso_alerts`
--
ALTER TABLE `dso_alerts`
  MODIFY `id` bigint(20) 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=4;

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

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

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

--
-- AUTO_INCREMENT for table `income_categories`
--
ALTER TABLE `income_categories`
  MODIFY `id` bigint(20) 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=263;

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `product_adjustments`
--
ALTER TABLE `product_adjustments`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `product_productions`
--
ALTER TABLE `product_productions`
  MODIFY `id` bigint(20) 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=68;

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `return_purchases`
--
ALTER TABLE `return_purchases`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `warehouses`
--
ALTER TABLE `warehouses`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

