-- phpMyAdmin SQL Dump
-- version 5.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 16, 2024 at 10:51 PM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.4.2

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


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

--
-- Database: `pos`
--

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

--
-- Table structure for table `ci_sessions`
--

CREATE TABLE `ci_sessions` (
  `id` varchar(128) NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `timestamp` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `data` blob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
 
-- --------------------------------------------------------

--
-- Table structure for table `db_account`
--

CREATE TABLE `db_account` (
  `id` int(11) NOT NULL,
  `bank_name` varchar(255) NOT NULL,
  `account_number` varchar(255) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` int(11) NOT NULL DEFAULT 1,
  `note` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `db_asset`
--

CREATE TABLE `db_asset` (
  `id` int(11) NOT NULL,
  `asset_name` varchar(255) NOT NULL,
  `asset_type` int(100) NOT NULL,
  `asset_cost` varchar(255) NOT NULL,
  `depreciation` int(11) NOT NULL DEFAULT 1,
  `note` varchar(255) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `db_asset_type`
--

CREATE TABLE `db_asset_type` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `note` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `db_asset_type`
--

INSERT INTO `db_asset_type` (`id`, `name`, `note`, `status`) VALUES
(22, 'Development Team Test', 'test', '0');

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

--
-- Table structure for table `db_authority`
--

CREATE TABLE `db_authority` (
  `id` int(11) NOT NULL,
  `authority_name` varchar(255) NOT NULL,
  `authority_email` varchar(255) NOT NULL,
  `authority_contact_number` varchar(255) NOT NULL,
  `authority_cash_credit` varchar(255) NOT NULL,
  `authority_status` int(11) NOT NULL DEFAULT 1,
  `authority_address` varchar(255) NOT NULL,
  `authority_note` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `db_authority`
--

INSERT INTO `db_authority` (`id`, `authority_name`, `authority_email`, `authority_contact_number`, `authority_cash_credit`, `authority_status`, `authority_address`, `authority_note`) VALUES
(2, 'mudassar iqbal', 'mudassar.3278.it@gmail.com', '03315068670', '345', 1, '02 02', 'tet');

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

--
-- Table structure for table `db_brands`
--

CREATE TABLE `db_brands` (
  `id` int(50) NOT NULL,
  `brand_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `brand_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int(5) DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_brands`
--

INSERT INTO `db_brands` (`id`, `brand_code`, `brand_name`, `description`, `company_id`, `status`) VALUES
(1, 'CT0001', 'Continental', 'Continental Tire For All-Season Performance—Find a New Road Forward. 100+ Years Of Excellence', NULL, 1),
(2, 'CT0002', 'Harris', '', NULL, 1),
(3, 'CT0003', 'UniChem', '', NULL, 1),
(4, 'CT0004', 'Sacato', '', NULL, 1),
(5, 'CT0005', 'Black &amp; Decker', '', NULL, 1),
(6, 'CT0006', 'Pyroil', '', NULL, 1),
(7, 'CT0007', 'Golden Supreme', '', NULL, 1),
(8, 'CT0008', 'Permatex', '', NULL, 1),
(9, 'CT0009', 'Cristal', '', NULL, 1),
(10, 'CT0010', 'Mechanics Brand', '', NULL, 1),
(11, 'CT0011', 'Lucas Oil Products', '', NULL, 1),
(12, 'CT0012', 'BlueDevil', '', NULL, 1),
(13, 'CT0013', 'Foset', '', NULL, 1),
(14, 'CT0014', 'SK2.000', '', NULL, 1),
(15, 'CT0015', 'Gunk', '', NULL, 1),
(16, 'CT0016', 'Rislone', '', NULL, 1),
(17, 'CT0017', 'CRC', '', NULL, 1),
(18, 'CT0018', 'Amsoil', '', NULL, 1),
(19, 'CT0019', 'Pretul', '', NULL, 1),
(20, 'CT0020', 'Truper', '', NULL, 1),
(21, 'CT0021', 'Dap', '', NULL, 1),
(22, 'CT0022', 'Stanley', '', NULL, 1),
(23, 'CT0023', '3M', '', NULL, 1),
(24, 'CT0024', 'Wix', '', NULL, 1),
(25, 'CT0025', 'Penzoil', '', NULL, 1),
(26, 'CT0026', 'Valvoline', '', NULL, 1),
(27, 'CT0027', 'Xcel', '', NULL, 1),
(28, 'CT0028', 'DuraPower', '', NULL, 1),
(29, 'CT0029', 'Interstate Batteries', '', NULL, 1),
(30, 'CT0030', 'K29', '', NULL, 1),
(31, 'CT0031', 'GreatNeck', '', NULL, 1),
(32, 'CT0032', 'California Scent', '', NULL, 1),
(33, 'CT0033', 'Exotica Fresheners', '', NULL, 1),
(34, 'CT0034', 'ET Accesorios', '', NULL, 1),
(35, 'CT0035', 'ASI Chemical', '', NULL, 1),
(36, 'CT0036', 'Power Eagle', '', NULL, 1),
(37, 'CT0037', 'OEM Industrial', '', NULL, 1),
(38, 'CT0038', 'Master Lock', '', NULL, 1),
(39, 'CT0039', 'Fiero', '', NULL, 1),
(40, 'CT0040', 'Eastman Tools', '', NULL, 1),
(41, 'CT0041', 'Panasonic', '', NULL, 1),
(42, 'CT0042', 'Purolator', '', NULL, 1),
(43, 'CT0043', 'Brava', '', NULL, 1),
(44, 'CT0044', 'NGK', '', NULL, 1),
(45, 'CT0045', 'Angel Guard', '', NULL, 1),
(46, 'CT0046', 'Armorall', '', NULL, 1),
(47, 'CT0047', 'Rain X', '', NULL, 1),
(48, 'CT0048', 'STP', '', NULL, 1),
(49, 'CT0049', 'Supercool', '', NULL, 1),
(50, 'CT0050', 'AC PRO', '', NULL, 1),
(51, 'CT0051', 'JB-Weld', '', NULL, 1),
(52, 'CT0052', 'DMX', '', NULL, 1),
(53, 'CT0053', 'Chispas', '', NULL, 1),
(54, 'CT0054', 'formula 1', '', NULL, 1),
(55, 'CT0055', 'Motor Trent', '', NULL, 1),
(56, 'CT0056', 'ECO Lighting', '', NULL, 1),
(57, 'CT0057', 'Protol', '', NULL, 1),
(58, 'CT0058', 'Firestone', '', NULL, 1),
(59, 'CT0059', 'Good year', '', NULL, 1),
(60, 'CT0060', 'Bridgestone', '', NULL, 1),
(61, 'CT0061', 'Thunderer', '', NULL, 1),
(62, 'CT0062', 'Volteck', '', NULL, 1),
(63, 'CT0063', 'Nelson Melendez', 'herramientas', NULL, 1),
(64, 'CT0064', 'Valley', 'herramientas', NULL, 1);

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

--
-- Table structure for table `db_category`
--

CREATE TABLE `db_category` (
  `id` int(50) NOT NULL,
  `category_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int(5) DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_category`
--

INSERT INTO `db_category` (`id`, `category_code`, `category_name`, `description`, `company_id`, `status`) VALUES
(6, 'CT0001', 'Accesorios', '', NULL, 1),
(7, 'CT0007', 'Aditivos', '', NULL, 1),
(8, 'CT0008', 'Brillo', '', NULL, 1),
(9, 'CT0009', 'Ferreteria', '', NULL, 1),
(10, 'CT0010', 'Gomas', '', NULL, 1),
(11, 'CT0011', 'Herramientas', '', NULL, 1),
(12, 'CT0012', 'Plomeria', '', NULL, 1),
(13, 'CT0013', 'Desinfectantes', '', NULL, 1),
(14, 'CT0014', 'Pinturas', '', NULL, 1),
(15, 'CT0015', 'Electricidad', '', NULL, 1),
(16, 'CT0016', 'Jardineria', '', NULL, 1),
(17, 'CT0017', 'Baterias', '', NULL, 1),
(18, 'CT0018', 'Gaming Console', '', NULL, 1),
(19, 'CT0019', 'test', '', NULL, 1),
(20, 'CT0020', 'test1', '', NULL, 1),
(21, 'CT0021', 'Category Name*', 'Description', NULL, 1),
(22, 'CT0022', 'cccccccccccccccccc', 'ddddddddddddddd', NULL, 1);

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

--
-- Table structure for table `db_cobpayments`
--

CREATE TABLE `db_cobpayments` (
  `id` int(50) NOT NULL,
  `customer_id` int(5) DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `payment_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment` double(20,2) DEFAULT NULL,
  `payment_note` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_time` time DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `db_company`
--

CREATE TABLE `db_company` (
  `id` int(50) NOT NULL,
  `company_code` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_website` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_logo` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upi_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upi_code` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postcode` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gst_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vat_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pan_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_details` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cid` int(10) DEFAULT NULL,
  `category_init` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_init` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'INITAL CODE',
  `supplier_init` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'INITAL CODE',
  `purchase_init` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'INITAL CODE',
  `purchase_return_init` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_init` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'INITAL CODE',
  `sales_init` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'INITAL CODE',
  `sales_return_init` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expense_init` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `invoice_view` int(5) DEFAULT NULL COMMENT '1=Standard,2=Indian GST',
  `status` int(1) DEFAULT NULL,
  `sms_status` int(1) DEFAULT NULL COMMENT '1=Enable 0=Disable',
  `sales_terms_and_conditions` text COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_company`
--

INSERT INTO `db_company` (`id`, `company_code`, `company_name`, `company_website`, `mobile`, `phone`, `email`, `website`, `company_logo`, `logo`, `upi_id`, `upi_code`, `country`, `state`, `city`, `address`, `postcode`, `gst_no`, `vat_no`, `pan_no`, `bank_details`, `cid`, `category_init`, `item_init`, `supplier_init`, `purchase_init`, `purchase_return_init`, `customer_init`, `sales_init`, `sales_return_init`, `expense_init`, `invoice_view`, `status`, `sms_status`, `sales_terms_and_conditions`) VALUES
(1, '', 'Justiniano Tire Shop', NULL, '7876011585', '', 'support@justinianotireshop.com', '', 'download2.jpg', 'logo-0.png', '', 'download3.jpg', 'USA', 'PR', 'San German', 'Carretera 119 Km 78.3', '00683', '', '66-0925908', '', '', 1, 'CT', 'IT', 'SP', 'PU', 'PR', 'CU', 'SL', 'PR', 'EX', 1, 1, 0, '');

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

--
-- Table structure for table `db_country`
--

CREATE TABLE `db_country` (
  `id` int(50) NOT NULL,
  `country_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(4050) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `added_on` date DEFAULT NULL,
  `company_id` int(5) DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_country`
--

INSERT INTO `db_country` (`id`, `country_code`, `country`, `added_on`, `company_id`, `status`) VALUES
(2, NULL, 'USA', NULL, NULL, 1),
(3, NULL, 'Puerto Rico', NULL, NULL, 1);

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

--
-- Table structure for table `db_currency`
--

CREATE TABLE `db_currency` (
  `id` int(50) NOT NULL,
  `currency_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` blob DEFAULT NULL,
  `symbol` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(5) DEFAULT NULL,
  `exchange_rate` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT 'NULL'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_currency`
--

INSERT INTO `db_currency` (`id`, `currency_name`, `currency_code`, `currency`, `symbol`, `status`, `exchange_rate`) VALUES
(1, 'Bulgaria-Bulgarian lev(BGN)', '', 0xd0bbd0b2, '', 1, 'NULL'),
(2, 'Switzerland \r-Swiss franc (CHF)', NULL, 0x434846, NULL, 1, NULL),
(3, 'Czechia-Czech koruna(CZK))', NULL, 0x4bc48d20, NULL, 1, NULL),
(4, 'Denmark-Danish krone(DKK)', NULL, 0x6b7220, NULL, 1, NULL),
(5, 'Euro area countries -Euro(EUR)', NULL, 0xe282ac20, NULL, 1, NULL),
(6, 'United Kingdom-Pounds sterling (GBP)', NULL, 0xc2a3, NULL, 1, NULL),
(7, 'Croatia -Croatian Kuna (HRK)', NULL, 0x6b6e, NULL, 1, NULL),
(8, 'Georgia -Georgian lari (GEL)', NULL, 0x2623383338323b, NULL, 1, NULL),
(9, 'Hungary -Hungarian forint (HUF)', NULL, 0x6674, NULL, 1, NULL),
(10, 'Norway -Norwegian krone (NOK)', NULL, 0x6b72, NULL, 1, NULL),
(11, 'Poland -Polish zloty (PLN)', NULL, 0x7ac58220, NULL, 1, NULL),
(12, 'Russia -Russian ruble (RUB)', NULL, 0x2623383338313b20, NULL, 1, NULL),
(13, 'Romania -Romanian leu (RON)', NULL, 0x6c6569, NULL, 1, NULL),
(14, 'Sweden - Swedish krona (SEK)', NULL, 0x6b72, NULL, 1, NULL),
(15, 'Turkey -Turkish lira (TRY)', NULL, 0x2623383337383b20, NULL, 1, NULL),
(16, 'Ukraine - Ukrainian hryvna  (UAH)', NULL, 0xe282b420, NULL, 1, NULL),
(17, 'UAE -Emirati dirham (AED)', NULL, 0xd8af2ed8a520, NULL, 1, NULL),
(18, 'Israel - Israeli shekel (ILS)', NULL, 0x2623383336323b20, NULL, 1, NULL),
(19, 'Kenya - Kenyan shilling(KES)', NULL, 0x4b7368, NULL, 1, NULL),
(20, 'Morocco - Moroccan dirham (MAD)', NULL, 0x2ed8af2ed98520, NULL, 1, NULL),
(21, 'Nigeria - Nigerian naira (NGN)', NULL, 0xe282a620, NULL, 1, NULL),
(22, 'South Africa -South african rand** (ZAR)', NULL, 0x52, NULL, 1, NULL),
(23, 'Brazil- Brazilian real(BRL)', NULL, 0x5224, NULL, 1, NULL),
(24, 'Canada-Canadian dollars (CAD)', NULL, 0x24, NULL, 1, NULL),
(25, 'Chile -Chilean peso (CLP)', NULL, 0x24, NULL, 1, NULL),
(26, 'Colombia -Colombian peso (COP)', NULL, 0x24, NULL, 1, NULL),
(27, 'Mexico - Mexican peso (MXN)', NULL, 0x24, NULL, 1, NULL),
(28, 'Peru -Peruvian sol(PEN)', NULL, 0x532f2e20, NULL, 1, NULL),
(29, 'USA -US dollar (USD)', '', 0x24, NULL, 1, '1'),
(30, 'Australia -Australian dollars (AUD)', NULL, 0x24, NULL, 1, NULL),
(31, 'Bangladesh -Bangladeshi taka (BDT) ', NULL, 0x2623323534373b20, NULL, 1, NULL),
(32, 'China - Chinese yuan (CNY)', NULL, 0x262332303830333b20, NULL, 1, NULL),
(33, 'Hong Kong - Hong Kong dollar(HKD)', NULL, 0x262333363b20, NULL, 1, NULL),
(34, 'Indonesia - Indonesian rupiah (IDR)', NULL, 0x5270, NULL, 1, NULL),
(35, 'India - Indian rupee', 'INR', 0xe282b9, '?', 1, NULL),
(36, 'Japan - Japanese yen (JPY)', NULL, 0xc2a5, NULL, 1, NULL),
(37, 'Malaysia - Malaysian ringgit (MYR)', NULL, 0x524d, NULL, 1, NULL),
(38, 'New Zealand - New Zealand dollar (NZD)', NULL, 0x24, NULL, 1, NULL),
(39, 'Philippines- Philippine peso (PHP)', NULL, 0xe282b120, NULL, 1, NULL),
(40, 'Pakistan- Pakistani rupee (PKR)', 'PKR', 0x527320, NULL, 1, '276'),
(41, 'Singapore - Singapore dollar (SGD)', NULL, 0x24, NULL, 1, NULL),
(42, 'South Korea - South Korean won (KRW)', NULL, 0x2623383336313b20, NULL, 1, NULL),
(43, 'Sri Lanka - Sri Lankan rupee (LKR)', NULL, 0x5273, NULL, 1, NULL),
(44, 'Thailand- Thai baht (THB)', NULL, 0x2623333634373b20, NULL, 1, NULL),
(45, 'Vietnam - Vietnamese dong', 'VND', 0xe282ab, NULL, 1, NULL),
(46, 'Bitcoin - BTC or XBT', 'BTC ', 0xe282bf, NULL, 1, NULL),
(47, 'Ripples', 'XRP', 0x585250, NULL, 1, NULL),
(48, 'Monero', 'XMR', 0xc9b1, NULL, 1, NULL),
(49, 'Litecoin', 'LTC', 0xc581, NULL, 1, NULL),
(50, 'Ethereum', 'ETH', 0xce9e, NULL, 1, NULL),
(51, 'Euro', 'EUR', 0xe282ac, NULL, 1, '1.07'),
(52, 'Pounds sterling', 'GBP', 0xc2a3, NULL, 1, NULL),
(53, 'US dollar', 'USD', 0x24, NULL, 1, '1'),
(54, 'Japanese yen', 'JPY', 0xc2a5, NULL, 1, NULL),
(55, 'Omani rial', 'OMR', 0xd8b12ed8b92e, NULL, 1, '');

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

--
-- Table structure for table `db_customers`
--

CREATE TABLE `db_customers` (
  `id` int(50) NOT NULL,
  `customer_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gstin` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vatin` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `opening_balance` double(20,2) DEFAULT NULL,
  `sales_due` double(20,2) DEFAULT NULL,
  `sales_return_due` double(20,2) DEFAULT NULL,
  `country_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_time` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int(5) DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_customers`
--

INSERT INTO `db_customers` (`id`, `customer_code`, `customer_name`, `mobile`, `phone`, `email`, `gstin`, `tax_number`, `vatin`, `opening_balance`, `sales_due`, `sales_return_due`, `country_id`, `state_id`, `city`, `postcode`, `address`, `system_ip`, `system_name`, `created_date`, `created_time`, `created_by`, `company_id`, `status`) VALUES
(1, 'CU0001', 'Walk-in customer', '', '', '', '', '', NULL, NULL, -158.56, 0.00, '', '', NULL, '', '', NULL, NULL, '2019-01-01', '10:55:54 pm', 'admin', NULL, 1),
(2, 'CU0002', 'carlos irizarry', NULL, '', NULL, '', '', NULL, 0.00, 4.07, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2022-02-03', '10:04:30 am', 'admin', NULL, 1),
(3, 'CU0003', 'Ramon Rodriguez', NULL, '', '', '', '', NULL, 0.00, 0.00, 0.00, NULL, NULL, NULL, '', '', NULL, NULL, '2022-02-09', '08:28:14 am', 'admin', NULL, 1),
(4, 'CU0004', 'Yamilette Gonzalez', NULL, '', '', '', '', NULL, 0.00, 0.00, 0.00, NULL, NULL, '', NULL, '', NULL, NULL, '2022-02-11', '08:12:52 am', 'admin', NULL, 1),
(5, 'CU0005', 'Municipio San German', '', '', '', '', '', NULL, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '2022-02-11', '08:58:11 am', 'admin', NULL, 1),
(6, 'CU0006', 'mudassar iqbal', '03315068670', '', 'mudassar.3278.it@gmail.com', '', '', NULL, 0.00, NULL, NULL, '2', NULL, 'Islamabad', '45211', '02 02', '::1', 'DESKTOP-5RQCT8P', '2024-04-21', '04:11:52 pm', 'admin', NULL, 1);

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

--
-- Table structure for table `db_customer_payments`
--

CREATE TABLE `db_customer_payments` (
  `id` int(50) NOT NULL,
  `salespayment_id` int(5) DEFAULT NULL,
  `customer_id` int(5) DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `payment_type` varchar(50) DEFAULT NULL,
  `payment` double(20,2) DEFAULT NULL,
  `payment_note` text DEFAULT NULL,
  `system_ip` varchar(50) DEFAULT NULL,
  `system_name` varchar(50) DEFAULT NULL,
  `created_time` varchar(50) DEFAULT NULL,
  `created_date` varchar(50) DEFAULT NULL,
  `created_by` varchar(50) DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `db_customer_payments`
--

INSERT INTO `db_customer_payments` (`id`, `salespayment_id`, `customer_id`, `payment_date`, `payment_type`, `payment`, `payment_note`, `system_ip`, `system_name`, `created_time`, `created_date`, `created_by`, `status`) VALUES
(42, 15, 5, '2024-04-21', 'ATH', 4.74, '', '::1', 'DESKTOP-5RQCT8P', '01:13:12', '2024-04-21', 'admin', 1),
(161, 11, 2, '2024-04-21', 'ATH', 0.85, '', '::1', 'DESKTOP-5RQCT8P', '04:42:14', '2024-04-21', 'admin', 1),
(162, 30, 2, '2024-05-04', 'Cash', 1.62, 'Paid By Cash', '::1', 'DESKTOP-5RQCT8P', '02:15:18', '2024-05-04', 'admin', 1),
(333, 15, 1, '2024-04-21', 'ATH', 4.74, '', '::1', 'DESKTOP-5RQCT8P', '01:13:12', '2024-04-21', 'admin', 1),
(334, 21, 1, '2024-04-26', 'ATH', 1.62, 'yment Not', '::1', 'DESKTOP-5RQCT8P', '07:34:35', '2024-04-26', 'admin', 1),
(335, 28, 1, '2024-04-26', 'ATH', 3.26, '', '::1', 'DESKTOP-5RQCT8P', '08:34:38', '2024-04-26', 'admin', 1),
(336, 5, 1, '2022-02-11', 'ATH Movil', 4.18, '', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '08:14:09', '2022-02-11', 'justiniano', 1),
(337, 3, 1, '2022-02-03', 'Cash', 3.00, '', '107.72.164.16', '107.72.164.16', '09:22:01', '2022-02-03', 'justiniano', 1),
(338, 4, 1, '2022-02-09', 'Cash', 19.78, '', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '09:33:31', '2022-02-09', 'justiniano', 1),
(339, 6, 1, '2022-02-17', 'Cash', 15.43, '', '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '11:56:25', '2022-02-17', 'justiniano', 1),
(340, 7, 1, '2022-02-17', 'Cash', 93.66, 'Paid By Cash', '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '12:51:48', '2022-02-17', 'justiniano', 1),
(341, 10, 1, '2024-04-02', 'Cash', 3.02, '', '::1', 'DESKTOP-5RQCT8P', '03:40:33', '2024-04-21', 'admin', 1),
(342, 20, 1, '2024-04-26', 'Cash', 1.62, 'Paid By Cash', '::1', 'DESKTOP-5RQCT8P', '06:53:46', '2024-04-26', 'admin', 1),
(343, 22, 1, '2024-04-26', 'Cash', 3.26, '', '::1', 'DESKTOP-5RQCT8P', '07:41:46', '2024-04-26', 'admin', 1),
(344, 23, 1, '2024-04-26', 'Cash', 33.09, 'Paid By Cash', '::1', 'DESKTOP-5RQCT8P', '07:42:14', '2024-04-26', 'admin', 1),
(345, 24, 1, '2024-04-26', 'Cash', 3.81, '', '::1', 'DESKTOP-5RQCT8P', '07:42:33', '2024-04-26', 'admin', 1),
(346, 25, 1, '2024-04-26', 'Cash', 1.62, '1.62', '::1', 'DESKTOP-5RQCT8P', '07:42:57', '2024-04-26', 'admin', 1),
(347, 26, 1, '2024-04-26', 'Cash', 33.09, '', '::1', 'DESKTOP-5RQCT8P', '07:43:34', '2024-04-26', 'admin', 1),
(348, 27, 1, '2024-04-26', 'Cash', 3.74, '', '::1', 'DESKTOP-5RQCT8P', '07:44:43', '2024-04-26', 'admin', 1),
(349, 31, 1, '2024-05-04', 'Cash', 1.62, 'Paid By Cash', '::1', 'DESKTOP-5RQCT8P', '02:30:18', '2024-05-04', 'admin', 1),
(350, 32, 1, '2024-05-05', 'Cash', 1.62, 'Paid By Cash', '::1', 'DESKTOP-5RQCT8P', '02:12:51', '2024-05-05', 'admin', 1),
(351, 33, 1, '2024-05-05', 'Cash', 4.36, 'Paid By Cash', '::1', 'DESKTOP-5RQCT8P', '02:13:19', '2024-05-05', 'admin', 1),
(352, 34, 1, '2024-05-05', 'Cash', 4.36, 'Paid By Cash', '::1', 'DESKTOP-5RQCT8P', '02:13:37', '2024-05-05', 'admin', 1),
(353, 35, 1, '2024-05-06', 'Cash', 1.62, 'Paid By Cash', '::1', 'DESKTOP-5RQCT8P', '03:26:45', '2024-05-06', 'admin', 1),
(354, 36, 1, '2024-05-16', 'Cash', 1.62, 'Paid By Cash', '::1', 'DESKTOP-5RQCT8P', '03:23:11', '2024-05-16', 'admin', 1),
(355, 38, 1, '2024-05-16', 'Cash', 33.09, 'Paid By Cash', '::1', 'DESKTOP-5RQCT8P', '04:05:31', '2024-05-16', 'admin', 1),
(356, 8, 1, '2024-04-21', 'Credit Card', 13.13, 'test', '::1', 'DESKTOP-5RQCT8P', '03:38:17', '2024-04-21', 'admin', 1),
(357, 9, 1, '2024-04-21', 'Credit Card', 13.13, 'test', '::1', 'DESKTOP-5RQCT8P', '03:38:34', '2024-04-21', 'admin', 1),
(358, 29, 1, '2024-04-27', 'Credit Card', 7.04, '', '::1', 'DESKTOP-5RQCT8P', '06:21:55', '2024-04-27', 'admin', 1);

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

--
-- Table structure for table `db_expense`
--

CREATE TABLE `db_expense` (
  `id` int(50) NOT NULL,
  `expense_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` int(5) DEFAULT NULL,
  `expense_date` date DEFAULT NULL,
  `reference_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expense_for` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expense_amt` double(20,2) DEFAULT NULL,
  `note` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_time` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `db_expense_category`
--

CREATE TABLE `db_expense_category` (
  `id` int(50) NOT NULL,
  `category_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `db_hold`
--

CREATE TABLE `db_hold` (
  `id` int(50) NOT NULL,
  `reference_id` varchar(50) DEFAULT NULL,
  `reference_no` varchar(50) DEFAULT NULL,
  `sales_date` date DEFAULT NULL,
  `sales_status` varchar(50) DEFAULT NULL,
  `customer_id` int(5) DEFAULT NULL,
  `other_charges_input` double(20,2) DEFAULT NULL,
  `other_charges_tax_id` int(5) DEFAULT NULL,
  `other_charges_amt` double(20,2) DEFAULT NULL,
  `discount_to_all_input` double(20,2) DEFAULT NULL,
  `discount_to_all_type` varchar(50) DEFAULT NULL,
  `tot_discount_to_all_amt` double(20,2) DEFAULT NULL,
  `subtotal` double(20,2) DEFAULT NULL,
  `round_off` double(20,2) DEFAULT NULL,
  `grand_total` double(20,2) DEFAULT NULL,
  `sales_note` text DEFAULT NULL,
  `pos` int(1) DEFAULT NULL COMMENT '1=yes 0=no'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `db_hold`
--

INSERT INTO `db_hold` (`id`, `reference_id`, `reference_no`, `sales_date`, `sales_status`, `customer_id`, `other_charges_input`, `other_charges_tax_id`, `other_charges_amt`, `discount_to_all_input`, `discount_to_all_type`, `tot_discount_to_all_amt`, `subtotal`, `round_off`, `grand_total`, `sales_note`, `pos`) VALUES
(22, '202202215', NULL, '2022-02-11', 'Final', 5, NULL, NULL, 0.00, 0.00, 'in_percentage', 0.00, 3611.00, 0.00, 3611.00, '', 1),
(23, 'fsdf', NULL, '2024-04-26', 'Final', 1, NULL, NULL, 0.00, 0.00, 'in_percentage', 0.00, 0.00, 0.00, 0.00, '', 1),
(24, '12', NULL, '2024-04-26', 'Final', 1, NULL, NULL, 0.00, 0.00, 'in_percentage', 0.00, 0.00, 0.00, 0.00, '', 1),
(25, 'rwar', NULL, '2024-04-26', 'Final', 1, NULL, NULL, 0.00, 0.00, 'in_percentage', 0.00, 0.00, 0.00, 0.00, '', 1),
(27, '2', NULL, '2024-04-26', 'Final', 1, NULL, NULL, 0.00, 0.00, 'in_percentage', 0.00, 0.00, 0.00, 0.00, '', 1),
(28, '3434', NULL, '2024-04-26', 'Final', 1, NULL, NULL, 0.00, 0.00, 'in_percentage', 0.00, 1.62, 0.00, 1.62, '', 1);

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

--
-- Table structure for table `db_holditems`
--

CREATE TABLE `db_holditems` (
  `id` int(50) NOT NULL,
  `hold_id` int(5) DEFAULT NULL,
  `item_id` int(5) DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sales_qty` double(20,2) DEFAULT NULL,
  `price_per_unit` double(20,2) DEFAULT NULL,
  `tax_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_id` int(5) DEFAULT NULL,
  `tax_amt` double(20,2) DEFAULT NULL,
  `discount_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_input` double(20,2) DEFAULT NULL,
  `discount_amt` double(20,2) DEFAULT NULL,
  `unit_total_cost` double(20,2) DEFAULT NULL,
  `total_cost` double(20,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_holditems`
--

INSERT INTO `db_holditems` (`id`, `hold_id`, `item_id`, `description`, `sales_qty`, `price_per_unit`, `tax_type`, `tax_id`, `tax_amt`, `discount_type`, `discount_input`, `discount_amt`, `unit_total_cost`, `total_cost`) VALUES
(22, 22, 129, '', 4.00, 106.72, 'Inclusive', NULL, NULL, 'Percentage', 0.00, 0.00, 106.72, 426.88),
(23, 22, 130, '', 4.00, 300.50, 'Inclusive', NULL, NULL, 'Percentage', 0.00, 0.00, 300.50, 1202.00),
(24, 22, 131, '', 4.00, 158.22, 'Inclusive', NULL, NULL, 'Percentage', 0.00, 0.00, 158.22, 632.88),
(25, 22, 132, '', 6.00, 116.94, 'Inclusive', NULL, NULL, 'Percentage', 0.00, 0.00, 116.94, 701.64),
(26, 22, 133, '', 4.00, 161.90, 'Inclusive', NULL, NULL, 'Percentage', 0.00, 0.00, 161.90, 647.60);

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

--
-- Table structure for table `db_items`
--

CREATE TABLE `db_items` (
  `id` int(50) NOT NULL,
  `item_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `custom_barcode` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` int(10) DEFAULT NULL,
  `warehouse_id` int(11) DEFAULT NULL,
  `sku` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hsn` varbinary(50) DEFAULT NULL,
  `unit_id` int(10) DEFAULT NULL,
  `alert_qty` int(10) DEFAULT NULL,
  `brand_id` int(5) DEFAULT NULL,
  `lot_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expire_date` date DEFAULT NULL,
  `price` double(20,2) DEFAULT NULL,
  `tax_id` int(5) DEFAULT NULL,
  `purchase_price` double(20,2) DEFAULT NULL,
  `tax_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profit_margin` double(20,2) DEFAULT NULL,
  `sales_price` double(20,2) DEFAULT NULL,
  `final_price` double(20,2) DEFAULT NULL,
  `stock` double(20,2) DEFAULT NULL,
  `item_image` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_time` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int(5) DEFAULT NULL,
  `status` int(5) DEFAULT NULL,
  `discount_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount` double(20,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_items`
--

INSERT INTO `db_items` (`id`, `item_code`, `custom_barcode`, `item_name`, `description`, `category_id`, `warehouse_id`, `sku`, `hsn`, `unit_id`, `alert_qty`, `brand_id`, `lot_number`, `expire_date`, `price`, `tax_id`, `purchase_price`, `tax_type`, `profit_margin`, `sales_price`, `final_price`, `stock`, `item_image`, `system_ip`, `system_name`, `created_date`, `created_time`, `created_by`, `company_id`, `status`, `discount_type`, `discount`) VALUES
(1, 'IT0001', '820909082200', '3 Led Cap Light With Batteries', '', 6, 3, '8220', '', 17, 1, 0, '', NULL, 0.75, 4, 0.84, 'Exclusive', 73.00, 1.45, 1.62, 47.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(2, 'IT0002', '826942654893', '4pc Heavy Duty Car &amp; Truck Mats Motor Trend', NULL, 6, 1, 'MT-921-BK', '', 17, 0, NULL, '', NULL, 0.00, 1, 0.00, 'Exclusive', NULL, 29.95, 33.09, 1.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(3, 'IT0003', '731015000142', 'Bl8nd Spot Mirror Round', NULL, 6, 3, 'CA086', '', 17, 0, NULL, '', NULL, 1.25, 1, 1.38, 'Exclusive', NULL, 2.95, 3.26, 10.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(4, 'IT0004', '070158000030', 'Krazy Glue All Purpose Super Glue', NULL, 6, 1, 'KG58348MR', '', 17, 0, NULL, '', NULL, 0.99, 1, 1.09, 'Exclusive', NULL, 1.65, 1.82, 17.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(5, 'IT0005', '078727442090', '4 Minute Epoxy Steel', NULL, 7, 3, '44209', '', 17, 0, NULL, '', NULL, 0.00, 1, 0.00, 'Exclusive', NULL, 4.45, 4.92, 4.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(6, 'IT0006', '078727431094', '5 Minutes Epoxy Adhesive', NULL, 7, 1, '43109', '', 17, 0, NULL, '', NULL, 0.00, 1, 0.00, 'Exclusive', NULL, 4.45, 4.92, 12.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(7, 'IT0007', '043425313195', 'J-B Weld Black Silicone RTV', NULL, 7, 3, '31319', '', 17, 0, NULL, '', NULL, 0.00, 1, 0.00, 'Exclusive', NULL, 3.45, 3.81, 0.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(8, 'IT0008', '043425313102', 'J-B Weld Clear Silicone ', NULL, 7, 1, '31310', '', 17, 0, NULL, '', NULL, 0.00, 1, 0.00, 'Exclusive', NULL, 3.45, 3.81, 4.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(9, 'IT0009', '043425323279', 'J-B Weld Ultimate Grey Gasket Maker &amp; Sealant', '', 7, 3, '32327', '', 17, 1, 51, '', NULL, 0.00, 4, 0.00, 'Exclusive', NULL, 3.45, 3.81, 0.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(10, 'IT0010', '672264024087', 'Leak Stop R-134a A/C System', '', 7, 1, '24087', '', 17, 1, 49, '', NULL, 0.00, 4, 0.00, 'Exclusive', NULL, 5.95, 6.57, 12.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(11, 'IT0011', '048168452514', 'PAG 100 Oil Charge R-134A With ICE 32', '', 7, 3, '765-3139', '', 17, 1, 50, '', NULL, 0.00, 4, 0.00, 'Exclusive', NULL, 5.95, 6.57, 12.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(12, 'IT0012', '078727275698', 'Prime Lok Stud &amp; Bearing Red 275', NULL, 7, 1, '27569', '', 17, 0, NULL, '', NULL, 0.00, 1, 0.00, 'Exclusive', NULL, 3.25, 3.59, 13.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(13, 'IT0013', '048168049264', 'R-12 To R-134a Retrofit Parts Kit', NULL, 7, 3, '765-3144', '', 17, 0, NULL, '', NULL, 0.00, 1, 0.00, 'Exclusive', NULL, 12.95, 14.31, 2.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(14, 'IT0014', '048168025213', 'R-134a Recharge Hose Adapter Standard To Self Sealing', NULL, 7, 1, '765-3152', '', 17, 0, NULL, '', NULL, 0.00, 1, 0.00, 'Exclusive', NULL, 3.95, 4.36, 1.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(15, 'IT0015', '686226818447', 'Rearview Mirror Adhesive', NULL, 7, 3, '765-1184', '', 17, 0, NULL, '', NULL, 0.00, 1, 0.00, 'Exclusive', NULL, 3.45, 3.81, 11.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(16, 'IT0016', '048168053070', 'Refrigerant 134a With Stop Leak ', NULL, 7, 1, 'Id1902', '', 17, 0, NULL, '', NULL, 0.00, 1, 0.00, 'Exclusive', NULL, 8.95, 9.89, 5.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(17, 'IT0017', '080319000168', 'Refrigerant R-134a', NULL, 7, 3, 'GHS 012R134a', '', 17, 0, NULL, '', NULL, 0.00, 1, 0.00, 'Exclusive', NULL, 6.95, 7.68, 11.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(18, 'IT0018', '078727999396', 'VersaChem Mega Grey Silicone Gasket Maker ', NULL, 7, 1, '99939', '', 17, 0, NULL, '', NULL, 0.00, 1, 0.00, 'Exclusive', NULL, 3.95, 4.36, 5.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(19, 'IT0019', '897444000280', 'M-16 Flowshine All In 1 Cherry Scent', NULL, 8, 3, '', '', 17, 0, NULL, '', NULL, 4.23, 1, 4.67, 'Exclusive', NULL, 5.95, 6.57, 11.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(20, 'IT0020', '078175051004', 'Mag &amp; Aluminum Polish', NULL, 8, 1, '05100', '', 17, 0, NULL, '', NULL, 0.00, 1, 0.00, 'Exclusive', NULL, 8.45, 9.34, 4.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(21, 'IT0021', '811656004409', 'Metal &amp; Aluminum Polish Angel Guatd', NULL, 8, 3, 'ANG 440', '', 17, 0, NULL, '', NULL, 2.49, 1, 2.75, 'Exclusive', NULL, 3.95, 4.36, 10.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(22, 'IT0022', '897444000327', 'Mr. Wash &amp; Wax  Multi-Cleaner Uvita ', NULL, 8, 1, '', '', 17, 0, NULL, '', NULL, 2.40, 1, 2.65, 'Exclusive', NULL, 3.95, 4.36, 83.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(23, 'IT0023', '071099138110', 'Scratch Out Fórmula 1 Swirl Remover', NULL, 8, 3, '653644', '', 17, 0, NULL, '', NULL, 0.00, 1, 0.00, 'Exclusive', NULL, 4.95, 5.47, 11.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(24, 'IT0024', '013948260184', 'Harris Chromall', '', 14, 1, 'chromall', '', 17, 1, 2, '', NULL, 3.25, 4, 3.62, 'Exclusive', 37.00, 4.95, 5.52, 5.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(25, 'IT0025', '013948250154', 'Harris Paint &amp; Primer 2X dark blue', '', 14, 3, 'dark blue', '', 17, 1, 2, '', NULL, 2.35, 4, 2.62, 'Exclusive', 28.00, 3.35, 3.74, 6.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(26, 'IT0026', '013948250024', 'Harris Paint &amp; Primer 2X Flat White', '', 14, 1, 'flat white', '', 17, 1, 2, '', NULL, 2.35, 4, 2.62, 'Exclusive', 28.00, 3.35, 3.74, 5.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(27, 'IT0027', '013948250253', 'Harris Paint &amp; Primer 2X Walnut', '', 14, 3, 'walnut', '', 17, 1, 2, '', NULL, 2.35, 4, 2.62, 'Exclusive', 28.00, 3.35, 3.74, 3.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(28, 'IT0028', '013948250000', 'Harris Paint &amp; Primer 2X Clear Acrylic', '', 14, 1, 'clear acrylic', '', 17, 1, 2, '', NULL, 2.35, 4, 2.62, 'Exclusive', 28.00, 3.35, 3.74, 6.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(29, 'IT0029', '013948250017', 'Harris Paint &amp; Primer 2X Gloss White', '', 14, 3, 'gloss white', '', 17, 0, 2, ' ', NULL, 2.35, 4, 2.62, 'Exclusive', 28.00, 3.35, 3.74, 5.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(30, 'IT0030', '013948250086', 'Harris Paint &amp; Primer 2X  Gray Primer', '', 14, 1, 'FCP.80 gray primer', '', 17, 1, 2, '', NULL, 2.35, 4, 2.62, 'Exclusive', 28.00, 3.35, 3.74, 5.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(31, 'IT0031', '013948250147', 'Harris Paint &amp; Primer 2X Red Primer', '', 14, 3, 'fcp.80 red primer', '', 17, 1, 2, '', NULL, 2.35, 4, 2.62, 'Exclusive', 28.00, 3.35, 3.74, 6.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(32, 'IT0032', '013948250208', 'Harris Paint &amp; Primer 2X Yellow', '', 14, 1, 'NFP .95 Yellow', '', 17, 1, 2, '', NULL, 2.35, 4, 2.62, 'Exclusive', 28.00, 3.35, 3.74, 6.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(33, 'IT0033', '013948250109', 'Harris Paint &amp; Primer 2X Copper', '', 14, 3, 'NFP .95 Copper', '', 17, 1, 2, '', NULL, 2.35, 4, 2.62, 'Exclusive', 28.00, 3.35, 3.74, 6.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(34, 'IT0034', '013948250055', 'Harris Paint &amp; Primer 2X Dark Green', '', 14, 1, 'NFP .95 Dark green', '', 17, 1, 2, '', NULL, 2.35, 4, 2.62, 'Exclusive', 28.00, 3.35, 3.74, 6.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(35, 'IT0035', '013948250307', 'Harris Paint &amp; Primer 2X Beige', '', 14, 3, 'NFP.95 beige', '', 17, 1, 2, '', NULL, 2.45, 4, 2.73, 'Exclusive', 23.00, 3.35, 3.74, 6.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(36, 'IT0036', '013948260252', 'Engine Enamel Harris Recond Flat Black', '', 14, 1, '1.20 Recond Flat Black', '', 17, 1, 2, '', NULL, 0.00, 4, 0.00, 'Exclusive', NULL, 3.35, 3.74, 6.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(37, 'IT0037', '013948260160', 'Engine enamel Harris Cast Iron Grey', '', 14, 3, 'FCP.80 Cast iron Grey', '', 17, 1, 2, '', NULL, 0.00, 4, 0.00, 'Exclusive', NULL, 3.35, 3.74, 6.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(38, 'IT0038', '013948260009', 'Engine Enamel Harris Univ Black', '', 14, 1, 'NFP 1.40 Univ Black', '', 17, 1, 2, '', NULL, 0.00, 4, 0.00, 'Exclusive', NULL, 3.35, 3.74, 4.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(39, 'IT0039', '013948260221', 'Engine Enamel Harris Universal Gray', '', 14, 3, 'NFP .95 Universal Grey', '', 17, 1, 2, '', NULL, 0.00, 4, 0.00, 'Exclusive', NULL, 3.35, 3.74, 6.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(40, 'IT0040', '013948260399', 'Engine Enamel Harris Gold E/E', '', 14, 1, 'NFP .95 Gold', '', 17, 1, 2, '', NULL, 0.00, 4, 0.00, 'Exclusive', NULL, 3.35, 3.74, 5.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(41, 'IT0041', '013948260177', 'Engine Enamel Harris Hi-Temp Aluminum', '', 14, 3, 'HTC 1.85 Aluminum', '', 17, 1, 2, '', NULL, 0.00, 4, 0.00, 'Exclusive', NULL, 3.35, 3.74, 6.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(42, 'IT0042', '013948260030', 'Engine Enamel Harris Chevy Orange', '', 14, 1, 'NFP .95 Chevy Orange', '', 17, 1, 2, '', NULL, 0.00, 4, 0.00, 'Exclusive', NULL, 3.35, 3.74, 6.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(43, 'IT0043', '013948260016', 'Engine Enamel Harris Ford Red', '', 14, 3, 'NFP .95 Ford Red', '', 17, 2, 2, '', NULL, 0.00, 4, 0.00, 'Exclusive', NULL, 3.35, 3.74, 6.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(44, 'IT0044', '013948260054', 'Engine Enamel Harris Ford Blue', '', 14, 1, 'NFP .95 Ford Blue', '', 17, 0, 2, '', NULL, 0.00, 4, 0.00, 'Exclusive', NULL, 3.35, 3.74, 6.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(45, 'IT0045', '013948260146', 'Engine Enamel Harris Cater Yellow', '', 14, 3, 'NFP .95  CATER YELLOW', '', 17, 0, 2, '', NULL, 0.00, 4, 0.00, 'Exclusive', NULL, 3.35, 3.74, 6.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(46, 'IT0046', '0', '235/35ZR20 92W XL SPORT NS1', NULL, 10, 1, '', '', 17, 0, NULL, '', NULL, 0.00, 1, 0.00, 'Exclusive', NULL, 99.95, 110.44, 1.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(47, 'IT0047', '885911524643', 'B &amp; D High Pressure Washer 1450 Psi', '', 11, 3, 'BW13-B3', '', 17, 1, 5, '', NULL, 65.95, 4, 73.53, 'Exclusive', 29.00, 94.95, 105.87, 3.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(48, 'IT0048', '7506240634577', 'Basin Stainless Steel Flexible Hose FLA-30XL', NULL, 12, 1, '45488', '', 17, 0, NULL, '', NULL, 0.00, 1, 0.00, 'Exclusive', NULL, 2.95, 3.26, 6.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(49, 'IT0049', '7506240634584', 'Manguera Flexible De Acero Inoxidable FLA-40XL', NULL, 12, 3, '45489', '', 17, 0, NULL, '', NULL, 0.00, 1, 0.00, 'Exclusive', NULL, 3.75, 4.14, 2.00, NULL, '216.164.121.166', '216.164.121.166', '2022-02-02', '01:07:10 am', 'admin', NULL, 1, 'Percentage', 0.00),
(50, 'IT0050', '098968400116', '70% Ethyl Alcohol UniChem 32oz', '70% Alcohol Ethyl  32 oz', 13, 1, '', '', 17, 1, 3, '', NULL, 3.00, 4, 3.34, 'Exclusive', 48.00, 4.95, 5.52, 24.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-04', '08:47:03 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(52, 'IT0052', '013948389038', 'Appliance Hard Epoxy Enamel Almond', '', 14, 3, 'appliance almond', '', 17, 1, 2, '', NULL, 3.50, 4, 3.90, 'Exclusive', 27.00, 4.95, 5.52, 5.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-04', '12:54:05 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(53, 'IT0053', '013948389014', 'Appliance Hard Epoxy Enamel White', '', 14, 1, 'appliance White', '', 17, 1, 2, '', NULL, 3.50, 4, 3.90, 'Exclusive', 27.00, 4.95, 5.52, 5.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-04', '12:58:04 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(54, 'IT0054', '815179020021', 'Brake Parts Cleaner', '', 7, 3, 'py4003', '', 17, 1, 6, '', NULL, 2.39, 4, 2.66, 'Exclusive', 48.00, 3.95, 4.40, 10.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-04', '01:38:16 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(55, 'IT0055', '718890007794', 'Carburetor &amp; Choke Cleaner', '', 7, 1, 'che-121c', '', 17, 1, 7, '', NULL, 2.45, 4, 2.73, 'Exclusive', 37.00, 3.75, 4.18, 10.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-04', '01:40:22 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(56, 'IT0056', '686226818331', 'Rubberized Undercoating', '', 7, 1, '765-2644', '', 17, 0, 8, '', NULL, 3.25, 4, 3.62, 'Exclusive', 37.00, 4.95, 5.52, 5.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-04', '01:43:11 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(57, 'IT0057', '018890145633', 'Brake Cleaner Cristal 14oz', '', 7, 3, '', '', 17, 1, 9, '', NULL, 2.25, 4, 2.51, 'Exclusive', 51.00, 3.79, 4.23, 9.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-04', '01:45:55 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(58, 'IT0058', '718890007978', 'Starting Fluid 11oz', '', 7, 1, 'che-124-cs', '', 17, 1, 7, '', NULL, 2.25, 4, 2.51, 'Exclusive', 51.00, 3.79, 4.23, 8.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-04', '01:48:06 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(59, 'IT0059', '076768115003', 'Tire Fixer Inflator &amp; Repair', '', 7, 3, '51150mb', '', 17, 1, 10, '', NULL, 3.00, 4, 3.34, 'Exclusive', 27.00, 4.25, 4.74, 4.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-04', '01:50:51 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(60, 'IT0060', '018890039017', 'Quick Fix Inflates &amp; Seals', '', 7, 1, 'che-106-c', '', 17, 1, 7, '', NULL, 2.65, 4, 2.95, 'Exclusive', 44.00, 4.25, 4.74, 5.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-04', '01:52:33 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(61, 'IT0061', '049807100094', 'Lucas Transmission Fix (24 oz.)', '', 7, 3, '10009', '', 17, 1, 11, '', NULL, 8.50, 4, 9.48, 'Exclusive', 58.00, 14.99, 16.71, 2.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-04', '01:57:59 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(62, 'IT0062', '091838002058', 'BlueDevil Radiator and Block Sealer', '', 7, 1, '00205', '', 17, 0, 12, '', NULL, 15.00, 4, 16.73, 'Exclusive', 55.00, 25.99, 28.98, 3.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-04', '02:25:34 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(63, 'IT0063', '891838002362', 'Transmission Sealer Pour - N - Go', '', 7, 3, '', '', 17, 0, 12, '', NULL, 14.00, 4, 15.61, 'Exclusive', 66.00, 25.95, 28.93, 2.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '07:32:14 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(64, 'IT0064', '717666106082', 'Super Kote 2.000 Tratamiento Motor', '', 7, 1, '', '', 17, 1, 14, '', NULL, 18.00, 4, 20.07, 'Exclusive', 24.00, 24.95, 27.82, 7.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '08:18:04 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(65, 'IT0065', '078698131825', 'Oil Treatment Motor Medic', '', 7, 3, 'm1815', '', 17, 1, 15, '', NULL, 3.00, 4, 3.34, 'Exclusive', 49.00, 4.99, 5.56, 9.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '08:21:12 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(66, 'IT0066', '078615041022', 'Engine Treatment Rislone 16.9oz', '', 7, 1, '4102', '', 17, 1, 16, '', NULL, 4.00, 4, 4.46, 'Exclusive', 40.00, 6.25, 6.97, 6.00, 'uploads/items/1645111935.jpg', '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '08:23:47 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(67, 'IT0067', '078254061627', 'Fuel Stabilizer CRC', '', 7, 3, 'crc#899a 14a', '', 17, 1, 17, '', NULL, 5.00, 4, 5.58, 'Exclusive', 34.00, 7.45, 8.31, 11.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '08:26:48 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(68, 'IT0068', '078254050638', 'Guaranteed To Pass', '', 7, 1, 'crc#425f', '', 17, 1, 17, '', NULL, 12.99, 4, 14.48, 'Exclusive', 38.00, 19.99, 22.29, 1.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '08:29:19 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(69, 'IT0069', '810006220834', 'TransMedic Tratamiento Transmision', '', 7, 3, 'm3616', '', 17, 1, 15, '', NULL, 3.25, 4, 3.62, 'Exclusive', 49.00, 4.99, 5.56, 10.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '08:31:30 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(70, 'IT0070', '097012308019', 'Engine &amp; Trasmission Flush Amsoil', '', 7, 1, 'flshcn', '', 17, 1, 18, '', NULL, 6.00, 4, 6.69, 'Exclusive', 124.00, 14.99, 16.71, 1.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '09:04:08 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(71, 'IT0071', '097012043002', 'Power Foam Induction System Cleaner', '', 7, 3, 'apf-sc', '', 17, 0, 18, '', NULL, 7.00, 4, 7.80, 'Exclusive', 92.00, 14.99, 16.71, 2.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '09:06:06 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(72, 'IT0072', '656489130006', 'Interstate Batteries D  pack of 2 Alkaline', '', 17, 1, 'dry0020', '', 17, 1, 29, '', '2026-12-31', 1.99, 4, 2.22, 'Exclusive', 80.00, 3.99, 4.45, 12.00, 'uploads/items/1645190693.jpg', '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '09:08:38 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(73, 'IT0073', '656489129994', 'Interstate Batteries C  pack of 2 Alkaline', '', 17, 3, 'dry0015', '', 17, 1, 29, '', '2026-12-31', 2.50, 4, 2.79, 'Exclusive', 43.00, 3.99, 4.45, 12.00, 'uploads/items/1645190653.jpg', '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '09:10:47 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(74, 'IT0074', '656489129963', 'Interstate Batteries 9V  Alkaline', '', 17, 1, 'dry0005', '', 17, 1, 29, '', '2026-12-31', 1.99, 4, 2.22, 'Exclusive', 80.00, 3.99, 4.45, 12.00, 'uploads/items/1645190620.jpg', '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '09:13:18 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(75, 'IT0075', '811656004508', 'Headlight Lens Restorer', '', 8, 3, 'ang-450', '', 17, 1, 45, '', NULL, 2.66, 4, 2.97, 'Exclusive', 68.00, 4.99, 5.56, 10.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '09:54:55 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(76, 'IT0076', '018890386067', 'Untouchable Wet Tire Finish', '', 8, 1, '', '', 17, 0, 9, '', NULL, 3.00, 4, 3.34, 'Exclusive', 49.00, 4.99, 5.56, 2.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '09:56:59 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(77, 'IT0077', '718890008623', 'Untouchable Glass Cleaner', '', 8, 3, 'cri-305-c', '', 17, 1, 9, '', NULL, 2.25, 4, 2.51, 'Exclusive', 59.00, 3.99, 4.45, 6.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '09:59:01 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(78, 'IT0078', '070612100108', 'Armorall Protectant 10oz', '', 8, 1, '', '', 17, 1, 46, '', NULL, 3.00, 4, 3.34, 'Exclusive', 76.00, 5.89, 6.57, 12.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '10:00:58 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(79, 'IT0079', '071153003507', 'Tuff Stuff Multi - Purpose Foam Cleaner', '', 8, 3, '11-12007', '', 17, 1, 48, '', NULL, 1.95, 4, 2.17, 'Exclusive', 107.00, 4.49, 5.01, 6.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '10:03:44 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(80, 'IT0080', '018890038638', 'GX-3 Plastic Restorer', '', 8, 1, 'cri-113-c', '', 17, 1, 9, '', NULL, 2.89, 4, 3.22, 'Exclusive', 55.00, 4.99, 5.56, 20.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '10:06:39 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(81, 'IT0081', '846351079933', 'Performance Octane Booster', '', 7, 3, '79933', '', 17, 1, 43, '', NULL, 1.50, 4, 1.67, 'Exclusive', 137.00, 3.95, 4.40, 6.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '10:09:46 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(82, 'IT0082', '846351079926', 'Fuel Injector Cleaner', '', 7, 1, '79926', '', 17, 1, 43, '', NULL, 1.50, 4, 1.67, 'Exclusive', 137.00, 3.95, 4.40, 6.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '10:11:01 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(83, 'IT0083', '846351079902', 'Super Gas Treatment', '', 7, 3, '79902', '', 17, 1, 43, '', NULL, 1.50, 4, 1.67, 'Exclusive', 137.00, 3.95, 4.40, 8.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '10:32:51 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(84, 'IT0084', '846351079919', 'High Mileage Fuel Treatment', '', 7, 1, '79919', '', 17, 1, 43, '', NULL, 1.50, 4, 1.67, 'Exclusive', 137.00, 3.95, 4.40, 8.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '10:34:34 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(85, 'IT0085', '815179020052', 'Fuel injector Cleaner Pyroil', '', 7, 3, 'pyafl12p', '', 17, 1, 6, '', NULL, 1.89, 4, 2.11, 'Exclusive', 87.00, 3.95, 4.40, 8.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '10:36:32 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(86, 'IT0086', '810006220063', 'Fuel Injection System Treatment Motor Medic', '', 7, 1, 'm5212', '', 17, 1, 15, '', NULL, 2.25, 4, 2.51, 'Exclusive', 59.00, 3.99, 4.45, 4.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '10:39:28 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(87, 'IT0087', '074130790773', 'Water Remover Valvoline', '', 7, 3, '602247', '', 17, 1, 26, '', NULL, 2.25, 4, 2.51, 'Exclusive', 59.00, 3.99, 4.45, 7.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '10:41:44 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(88, 'IT0088', '079118010645', 'Rain X 7oz', '', 8, 1, '0611', '', 17, 1, 47, '', NULL, 3.15, 4, 3.51, 'Exclusive', 42.00, 4.99, 5.56, 11.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '10:57:36 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(89, 'IT0089', '811656001309', 'Wet Look Cristalizer Angel Guard', '', 8, 3, 'ang-130', '', 17, 1, 45, '', NULL, 4.95, 4, 5.52, 'Exclusive', 40.00, 7.73, 8.62, 7.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '11:01:02 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(90, 'IT0090', '811656006663', 'Engine Shine &amp; Protectant', '', 8, 1, 'ang-666', '', 17, 1, 45, '', NULL, 4.50, 4, 5.02, 'Exclusive', 40.00, 7.03, 7.84, 10.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '11:04:20 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(91, 'IT0091', '013948386051', 'Ever Black Plastic Restorer', '', 8, 1, '', '', 17, 1, 2, '', NULL, 3.50, 4, 3.90, 'Exclusive', 54.00, 5.99, 6.68, 7.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '12:27:57 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(92, 'IT0092', '013948386044', 'Ever Wet Tire Shine', '', 8, 3, '', '', 17, 1, 2, '', NULL, 3.50, 4, 3.90, 'Exclusive', 54.00, 5.99, 6.68, 23.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '12:30:13 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(93, 'IT0093', '079118959739', '2 in 1 Glass Cleaner + Rain Repellent', '', 8, 1, '1112', '', 17, 1, 47, '', NULL, 3.50, 4, 3.90, 'Exclusive', 54.00, 5.99, 6.68, 2.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '12:32:31 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(94, 'IT0094', '713283231282', 'ASI Carpet &amp; Upholstery Cleaner', '', 8, 3, '', '', 17, 1, 35, '', NULL, 5.00, 4, 5.58, 'Exclusive', 79.00, 9.99, 11.14, 1.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '12:36:21 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(95, 'IT0095', '713283230162', 'ASI Vinyl &amp; Leather Conditioner', '', 8, 1, '', '', 17, 1, 35, '', NULL, 5.00, 4, 5.58, 'Exclusive', 79.00, 9.99, 11.14, 3.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '12:38:03 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(96, 'IT0096', '713283270328', 'ASI Rubber &amp; Trim', '', 8, 3, '', '', 17, 1, 35, '', NULL, 7.50, 4, 8.36, 'Exclusive', 79.00, 14.99, 16.71, 5.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '12:39:26 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(97, 'IT0097', '713283221283', 'ASI Car Wash Soap PH Balanceado', '', 8, 1, '', '', 17, 1, 35, '', NULL, 5.00, 4, 5.58, 'Exclusive', 79.00, 9.99, 11.14, 5.00, NULL, '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '12:40:52 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(98, 'IT0098', '656489130020', 'Interstate Batteries AA paquete 4 Alkaline', '', 17, 3, 'dry0030', '', 17, 1, 29, '', '2026-12-31', 1.99, 4, 2.22, 'Exclusive', 80.00, 3.99, 4.45, 7.00, 'uploads/items/1645190589.jpg', '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '12:43:55 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(99, 'IT0099', '656489130051', 'Interstate Batteries AAA  pack of 4 Alkaline', '', 17, 1, 'dry0035', '', 17, 1, 29, '', '2026-12-31', 1.99, 4, 2.22, 'Exclusive', 80.00, 3.99, 4.45, 3.00, 'uploads/items/1645190535.jpg', '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '12:46:20 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(100, 'IT0100', '656489302427', 'Interstate Batteries AAA  pack of 24 Alkaline', '', 17, 3, 'dry0191', '', 17, 1, 29, '', '2026-12-31', 7.50, 4, 8.36, 'Exclusive', 79.00, 14.99, 16.71, 3.00, 'uploads/items/1645188787.jpg', '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '12:48:57 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(101, 'IT0101', '656489302410', 'Interstate Batteries AA  pack of 24 Alkaline', 'Interstate Batteries AA  pack of 24 Alkaline', 17, 1, 'dry0190', '', 17, 1, 29, '', '2026-12-31', 7.50, 4, 8.36, 'Exclusive', 79.00, 14.99, 16.71, 2.00, 'uploads/items/1645188696.jpg', '107.77.216.81', 'mobile-107-77-216-81.mobile.att.net', '2022-02-05', '12:50:37 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(102, 'IT0102', '018890000321', 'Visible Glass Cleaner 32oz', '', 8, 3, '', '', 17, 1, 9, '', NULL, 1.25, 4, 1.39, 'Exclusive', 43.00, 1.99, 2.22, 8.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-07', '12:49:13 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(103, 'IT0103', '018890040013', 'Wash &amp; Wax Cristal 16oz', '', 8, 1, '', '', 17, 1, 9, '', NULL, 1.75, 4, 1.95, 'Exclusive', 53.00, 2.99, 3.33, 4.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-07', '12:50:46 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(104, 'IT0104', '811656003334', 'Car Wash 16 oz', '', 8, 3, 'ang-333', '', 17, 1, 45, '', NULL, 1.75, 4, 1.95, 'Exclusive', 53.00, 2.99, 3.33, 12.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-07', '12:52:28 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(105, 'IT0105', 'cocat5nr', 'Carretilla 5.5ft3, mangos madera,llanta neumática 16&quot;', 'Llanta neumática reforzada con rin de 3 aspas\r\nConcha de lámina calibre 23 (0.68 mm)\r\nBastidores cuadrados de madera (41 x 41 mm)\r\nPuente que brinda mayor estabilidad\r\nCapacidad (Copeteada / Ras) 5.5 ft³ (156 L) / 2.8 ft³ (80 L)\r\nMedidas de la concha 27&quot; (69 cm) x 36 1/2&quot; (93 cm) x 11&quot; (28 cm)\r\nMedidas de llanta 16&quot; (41 cm) x 4&quot; (10 cm)\r\nResistencia de carga 350 kg\r\nPuente con doble tornillo Calibre 19 (1 mm)\r\nSoporte y tacón Calibre 16 (1.5 mm)', 9, 1, '20622', 0x4341502d35574e4452, 17, 1, 19, '', NULL, 64.95, 4, 72.42, 'Exclusive', 24.00, 89.95, 100.29, 2.00, 'uploads/items/1644930709.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '11:12:43 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(106, 'IT0106', '7501206600115', 'Wire Wheel Brush 1 1/2 diametro', '', 9, 3, '11573', '', 17, 1, 20, '', NULL, 1.76, 4, 1.96, 'Exclusive', 40.00, 2.75, 3.07, 3.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '11:19:49 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(107, 'IT0107', '7501206675670', 'Wire Wheel Brush 2&quot; diametro', '', 9, 1, '11569', '', 17, 1, 20, '', NULL, 1.55, 4, 1.73, 'Exclusive', 59.00, 2.75, 3.07, 1.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '11:24:07 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(108, 'IT0108', '7501206643655', 'Wire Wheel Set for Drills', '', 9, 3, '11577', '', 17, 1, 20, '', NULL, 10.91, 4, 12.16, 'Exclusive', 39.00, 16.95, 18.90, 2.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '11:26:16 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(109, 'IT0109', '7501206600160', 'Wire Wheel Brush 4&quot; diametro', '', 9, 1, '11590', '', 17, 1, 20, '', NULL, 3.54, 4, 3.95, 'Exclusive', 41.00, 5.55, 6.19, 3.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '11:29:17 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(110, 'IT0110', '7501206600139', 'Wire Wheel Brush 3&quot; diametro', '', 9, 3, '11575', '', 17, 1, 20, '', NULL, 2.72, 4, 3.03, 'Exclusive', 40.00, 4.25, 4.74, 3.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '11:32:08 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(111, 'IT0111', '7501206600184', 'Wire Wheel Cup Brush 2&quot; 3/4 diametro', '', 9, 1, '11592', '', 17, 1, 20, '', NULL, 4.07, 4, 4.54, 'Exclusive', 40.00, 6.35, 7.08, 3.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '11:34:51 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(112, 'IT0112', '704300960223', 'DMX Wash &amp; Wax 16oz', '', 8, 3, '', '', 17, 1, 52, '', NULL, 1.50, 4, 1.67, 'Exclusive', 79.00, 2.99, 3.33, 10.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '12:39:36 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(113, 'IT0113', '704300960216', 'DMX Wash &amp; Wax 64oz', '', 8, 1, '', '', 17, 1, 52, '', NULL, 2.50, 4, 2.79, 'Exclusive', 115.00, 5.99, 6.68, 5.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '12:41:33 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(114, 'IT0114', '7506240600183', 'Regulador para Gas una via', '', 9, 3, '49225', '', 17, 1, 13, '', NULL, 7.51, 4, 8.37, 'Exclusive', 43.00, 11.95, 13.32, 4.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '12:43:39 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(115, 'IT0115', '7501206635124', 'Pistola calafateadora lisa, Pretul Caulk Gun', 'Pistola calafateadora lisa, Pretul\r\nCuerpo de acero\r\n', 9, 1, '22800', 0x504943412d394c, 17, 1, 19, '', NULL, 2.72, 4, 3.03, 'Exclusive', 40.00, 4.25, 4.74, 5.00, 'uploads/items/1644933454.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '12:45:59 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(116, 'IT0116', '7506240672531', 'Revolvedor Cemento y Lechada', '', 9, 3, '11975', '', 17, 1, 20, '', NULL, 6.99, 4, 7.79, 'Exclusive', 41.00, 10.95, 12.21, 2.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '12:48:06 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(117, 'IT0117', '7501206643211', 'Remachadora 10&quot; Pretul', '', 9, 1, '22850', '', 17, 1, 19, '', NULL, 4.99, 4, 5.56, 'Exclusive', 79.00, 9.95, 11.09, 3.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '12:50:32 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(118, 'IT0118', '7501206603543', 'Cautin 30W Pretul', '', 9, 3, '22805', '', 17, 1, 19, '', NULL, 6.97, 4, 7.77, 'Exclusive', 40.00, 10.85, 12.10, 3.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '12:52:13 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(119, 'IT0119', '7501206698143', 'Manguera Flexible para Gas', '', 9, 1, '49136', '', 17, 1, 13, '', NULL, 5.31, 4, 5.92, 'Exclusive', 51.00, 8.95, 9.98, 6.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '12:54:46 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(120, 'IT0120', '7501206618646', 'Llavero tipo Bandola', 'Fabricados en aluminio\r\nTipo bandola\r\nColores surtidos', 9, 3, '65002', '', 17, 1, 19, '', NULL, 0.68, 4, 0.76, 'Exclusive', 64.00, 1.25, 1.39, 27.00, 'uploads/items/1644609147.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '12:58:38 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(121, 'IT0121', '075650000311', 'Touch &#039;n Foam Max 3x Fill', '', 9, 1, '2919006', '', 17, 1, 21, '', NULL, 5.35, 4, 5.97, 'Exclusive', 42.00, 8.45, 9.42, 12.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '01:41:05 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(122, 'IT0122', '7706912650366', 'Machete Chispas 14.5&quot;  #1820 Cabo Madera', '', 9, 3, '1102076', 0x2331383230, 17, 1, 53, '', NULL, 5.05, 4, 5.63, 'Exclusive', 77.00, 9.95, 11.09, 7.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '02:45:34 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(123, 'IT0123', '', 'Tornillo Acoplar Tanque 5/16 x 3&quot;', '', 9, 1, '380015-sip', 0x30313239303230, 17, 1, 0, '', NULL, 1.03, 4, 1.15, 'Exclusive', 61.00, 1.85, 2.06, 10.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '03:32:51 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(124, 'IT0124', '', 'Tornillo Inodoro piso 1/4 x 2 1/4', '', 9, 3, 'EB28', 0x30313239303231, 17, 1, 0, '', NULL, 0.47, 4, 0.52, 'Exclusive', 44.00, 0.75, 0.84, 10.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '03:34:45 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(125, 'IT0125', '074130790759', 'Fuel Injector Cleaner Valvoline', '', 7, 1, '602378', '', 17, 1, 26, '', NULL, 2.28, 4, 2.54, 'Exclusive', 48.00, 3.75, 4.18, 12.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-09', '03:49:27 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(126, 'IT0126', '', 'Lampara de Emergencia Led', '', 9, 3, 'Skem-7012', 0x3331393938303641, 17, 1, 56, '', NULL, 20.95, 4, 23.36, 'Exclusive', 41.00, 32.95, 36.74, 3.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '08:17:53 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(127, 'IT0127', '0657559717677', 'Led Lightbulb 12w /100w', 'Lifetime 40.000h\r\n6500 K ( Pure White )\r\nBright 1600', 9, 1, '60-enled-12w', 0x3331303431363243, 17, 1, 57, '', NULL, 2.92, 4, 3.26, 'Exclusive', 43.00, 4.65, 5.18, 12.00, 'uploads/items/1644609736.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '08:21:38 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(128, 'IT0128', '0657559685877', 'Led Lightbulb 9w /75w', 'Lifetime 40.000h\r\n6500 K ( Pure White )\r\nBright 1300', 9, 3, '60-enled-9w', 0x3331303431363262, 17, 1, 57, '', NULL, 2.67, 4, 2.98, 'Exclusive', 43.00, 4.25, 4.74, 12.00, 'uploads/items/1644609702.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '08:32:34 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(129, 'IT0129', '', 'EFFICIENTGRIP PERF - 215/55R16 Good Year', '', 10, 1, 'GY 109708', '', 17, 1, 59, '', NULL, 83.23, 4, 92.80, 'Exclusive', 15.00, 106.72, 118.99, 8.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '09:01:06 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(130, 'IT0130', '', 'Alenza A/S 02 - 275/50R22 Bridgestone', '', 10, 3, 'BR 007157', '', 17, 1, 60, '', NULL, 245.00, 4, 273.18, 'Exclusive', 10.00, 300.50, 335.06, 8.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '09:02:49 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(131, 'IT0131', '', 'DUELER A/T REVO 2 - 245/65R17', '', 10, 1, 'BR 14946005', '', 17, 1, 60, '', NULL, 129.00, 4, 143.84, 'Exclusive', 10.00, 158.22, 176.42, 8.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '09:04:12 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(132, 'IT0132', '', 'Thunderer Ranger R402 - 195/75R16C', '', 10, 3, 'TH TH0412', '', 17, 1, 61, '', NULL, 87.40, 4, 97.45, 'Exclusive', 20.00, 116.94, 130.39, 8.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '09:05:24 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(133, 'IT0133', '', 'Transforce CV - 235/65R16C', '', 10, 1, 'FIR 004709', '', 17, 1, 58, '', NULL, 132.00, 4, 147.18, 'Exclusive', 10.00, 161.90, 180.52, 8.00, NULL, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '09:06:47 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(134, 'IT0134', '7501206693902', 'Nudo para Cable 3/8', 'Fabricados en hierro maleable, acabado galvanizado\r\nPara conexiones de cables donde no se pueden usar terminales ni prensarse\r\nPara uniones temporales', 9, 3, '44086', '', 17, 1, 39, '', NULL, 1.02, 4, 1.14, 'Exclusive', 75.00, 1.99, 2.22, 6.00, 'uploads/items/1644609063.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '12:10:46 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(135, 'IT0135', '', 'Cable Rigido 1/8 recubierto pvc 7x7', 'Fabricados de acero con acabado galvanizado\r\nRecubrimiento de PVC que evita maltratos a productos que se fijan o aseguran con el cable', 9, 1, '44219', '', 19, 1, 39, '', NULL, 0.16, 4, 0.18, 'Exclusive', 67.00, 0.30, 0.33, 246.00, 'uploads/items/1644609002.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '12:15:37 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(136, 'IT0136', '7501206693865', 'Nudo para Cable 1/8 (2 piezas)', 'Fabricados en hierro maleable, acabado galvanizado\r\nPara conexiones de cables donde no se pueden usar terminales ni prensarse\r\nPara uniones temporales', 9, 3, '44082', '', 17, 1, 39, '', NULL, 0.62, 4, 0.69, 'Exclusive', 116.00, 1.49, 1.66, 12.00, 'uploads/items/1644608469.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '12:17:50 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(137, 'IT0137', '7501206693872', 'Nudo para Cable 3/16 (2 piezas)', 'Fabricados en hierro maleable, acabado galvanizado\r\nPara conexiones de cables donde no se pueden usar terminales ni prensarse\r\nPara uniones temporales', 9, 1, '44083', '', 17, 1, 39, '', NULL, 0.81, 4, 0.90, 'Exclusive', 99.00, 1.79, 2.00, 12.00, 'uploads/items/1644608443.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '12:54:26 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(138, 'IT0138', '7501206693889', 'Nudo para Cable 1/4 (2 piezas)', 'Fabricados en hierro maleable, acabado galvanizado\r\nPara conexiones de cables donde no se pueden usar terminales ni prensarse\r\nPara uniones temporales', 9, 3, '44084', '', 17, 1, 39, '', NULL, 1.16, 4, 1.29, 'Exclusive', 93.00, 2.49, 2.78, 12.00, 'uploads/items/1644608416.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '12:55:44 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(139, 'IT0139', '7501206693896', 'Nudo para Cable 5/16 (2 piezas)', 'Fabricados en hierro maleable, acabado galvanizado\r\nPara conexiones de cables donde no se pueden usar terminales ni prensarse\r\nPara uniones temporales', 9, 1, '44085', '', 17, 1, 39, '', NULL, 1.23, 4, 1.37, 'Exclusive', 82.00, 2.49, 2.78, 12.00, 'uploads/items/1644608384.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '12:57:42 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(140, 'IT0140', '750120663919', 'Nudo para Cable 1/2', 'Fabricados en hierro maleable, acabado galvanizado\r\nPara conexiones de cables donde no se pueden usar terminales ni prensarse\r\nPara uniones temporales', 9, 3, '44087', '', 17, 1, 39, '', NULL, 1.36, 4, 1.52, 'Exclusive', 64.00, 2.49, 2.78, 6.00, 'uploads/items/1644608360.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '12:59:32 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(141, 'IT0141', '7501206694633', 'Tensor Gancho 3/16', 'Cuerpo metálico\r\nArgolla y gancho fabricados en acero, acabado galvanizado\r\nPara tensar o emparejar cables', 9, 1, '44053', '', 17, 1, 39, '', NULL, 1.34, 4, 1.49, 'Exclusive', 67.00, 2.49, 2.78, 6.00, 'uploads/items/1644607842.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '01:02:13 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(142, 'IT0142', '7501206694794', 'Tensor Gancho 1/4', 'Cuerpo metálico\r\nArgolla y gancho fabricados en acero, acabado galvanizado\r\nPara tensar o emparejar cables', 9, 3, '44054', '', 17, 1, 39, '', NULL, 1.83, 4, 2.04, 'Exclusive', 61.00, 3.29, 3.67, 6.00, 'uploads/items/1644607814.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '01:04:37 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(143, 'IT0143', '7501206694640', 'Tensor Gancho 5/16', 'Cuerpo metálico\r\nArgolla y gancho fabricados en acero, acabado galvanizado\r\nPara tensar o emparejar cables', 9, 1, '44055', '', 17, 1, 39, '', NULL, 2.44, 4, 2.72, 'Exclusive', 58.00, 4.29, 4.78, 6.00, 'uploads/items/1644607792.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '01:06:28 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(144, 'IT0144', '7501206694657', 'Tensor Gancho 3/8', 'Cuerpo metálico\r\nArgolla y gancho fabricados en acero, acabado galvanizado\r\nPara tensar o emparejar cables', 9, 3, '44056', '', 17, 1, 39, '', NULL, 2.74, 4, 3.06, 'Exclusive', 63.00, 4.99, 5.56, 6.00, 'uploads/items/1644607771.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '01:07:54 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(145, 'IT0145', '7501206694459', 'Bandola Destorcedor 7/16', 'Cuerpo metálico\r\nOjo giratorio\r\nIdeales para sujetar cordones, correas para perros', 9, 3, '44030', '', 17, 1, 39, '', NULL, 1.30, 4, 1.45, 'Exclusive', 55.00, 2.25, 2.51, 6.00, 'uploads/items/1644607634.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '01:13:26 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(146, 'IT0146', '7501206694473', 'Bandola Destorcedor 7/8', 'Cuerpo metálico\r\nOjo giratorio\r\nIdeales para sujetar cordones, correas para perros', 9, 1, '44032', '', 17, 1, 39, '', NULL, 2.04, 4, 2.27, 'Exclusive', 43.00, 3.25, 3.62, 6.00, 'uploads/items/1644607609.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '01:15:03 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(147, 'IT0147', '0657559804254', 'Pressure Switch 40-60 PSI', 'PRESSUE SWITCH 40-60 PSI\r\n• For automatic operation or jet and submersible well pumps when used in conjunction with a diaphragm pressure tank or galvanized holding tank.\r\n• The pressure of the switch you are replacing is shown inside the cap.\r\n• Air pressure in tank must be set to 38 PSI', 12, 3, 'pr-ps4060', 0x32303230303037, 17, 1, 57, '', NULL, 5.95, 4, 6.63, 'Exclusive', 276.00, 24.95, 27.82, 3.00, 'uploads/items/1644607255.jpg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '01:23:07 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(148, 'IT0148', '079118958558', 'Rain X 2 in 1 Glass Cleaner Trigguer 23oz', 'This Rain-X 2-In-1 Glass Cleaner is used on exterior and comes in 23 ounce spray bottle.', 8, 1, '5071268', '', 17, 1, 47, '', NULL, 2.71, 4, 3.02, 'Exclusive', 74.00, 5.25, 5.85, 6.00, 'uploads/items/1644607117.jpeg', '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '2022-02-11', '03:18:37 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(149, 'IT0149', '7501206658383', 'Portalámpara de porcelana, 4-1/2&quot;, circular, Volteck', 'Tensión / Corriente: 120 V / 4 A\r\nCasquillo de aluminio\r\nDe sobreponer para fijar en pared o techo\r\nSoporta temperaturas elevadas (hasta 350 °C)', 9, 3, '46524', 0x706f706f2d3138, 17, 1, 62, '', NULL, 1.20, 4, 1.34, 'Exclusive', 46.00, 1.95, 2.17, 12.00, 'uploads/items/1644930527.jpg', '107.77.215.19', 'mobile-107-77-215-19.mobile.att.net', '2022-02-15', '09:08:47 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(150, 'IT0150', '', 'Cavador mango de madera 45&quot; Gemelas', 'Hojas de acero templado\r\nMangos redondos de madera\r\nLargo de mangos 45&quot; (114 cm)\r\nApertura máxima 6&quot; (150 mm)\r\nEspesor de cabeza 1.8 mm', 9, 1, '11973', 0x43412d3336, 17, 1, 20, '', NULL, 22.95, 4, 25.59, 'Exclusive', 37.00, 34.95, 38.97, 1.00, 'uploads/items/1644936693.jpg', '107.77.215.19', 'mobile-107-77-215-19.mobile.att.net', '2022-02-15', '10:51:33 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(151, 'IT0151', '', 'Cavador mango de acero 45&quot; Gemela', 'Hojas de acero templado\r\nMangos de acero con grips', 9, 3, '11131', 0x43412d33364d, 17, 1, 20, '', NULL, 19.79, 4, 22.07, 'Exclusive', 36.00, 29.95, 33.39, 1.00, 'uploads/items/1644936885.jpg', '107.77.215.19', 'mobile-107-77-215-19.mobile.att.net', '2022-02-15', '10:54:45 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(152, 'IT0152', '7501206658345', 'PALA de corte ESCARRAMAN, MANGO LARGO', 'PALA ESCARRAMAN, MANGO LARGO', 9, 3, '25022', 0x7065732d6c7270, 17, 1, 19, '', NULL, 7.99, 4, 8.91, 'Exclusive', 45.00, 12.95, 14.44, 2.00, 'uploads/items/1644941805.png', '107.77.215.19', 'mobile-107-77-215-19.mobile.att.net', '2022-02-15', '12:16:45 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(153, 'IT0153', '7501206634387', 'Pala cuadrada mango largo, 56&quot;, Pretul', 'Mango largo fabricado en madera tropical con acabado encerado\r\nCabeza de acero al carbono con doble tratamiento térmico y acabado en pintura epóxica negra\r\nEnsamble: Interferencia y remache\r\nPara cavar o desplazar materiales de un sitio a otro\r\nModelo Pretul\r\nPuño Mango largo\r\nAncho de la cabeza (A) 9&quot; (23 cm)\r\nLargo de la cabeza (B) 19&quot; (48 cm)\r\nLargo total 56&quot; (142 cm)\r\nHombros Al frente\r\nAtado 3', 9, 1, '22508', 0x5043442d4c, 17, 1, 19, '', NULL, 7.99, 4, 8.91, 'Exclusive', 45.00, 12.95, 14.44, 2.00, 'uploads/items/1644942228.jpg', '107.77.215.19', 'mobile-107-77-215-19.mobile.att.net', '2022-02-15', '12:23:48 pm', 'justiniano', NULL, 1, 'Percentage', 0.00);
INSERT INTO `db_items` (`id`, `item_code`, `custom_barcode`, `item_name`, `description`, `category_id`, `warehouse_id`, `sku`, `hsn`, `unit_id`, `alert_qty`, `brand_id`, `lot_number`, `expire_date`, `price`, `tax_id`, `purchase_price`, `tax_type`, `profit_margin`, `sales_price`, `final_price`, `stock`, `item_image`, `system_ip`, `system_name`, `created_date`, `created_time`, `created_by`, `company_id`, `status`, `discount_type`, `discount`) VALUES
(154, 'IT0154', '7501206612026', 'Azadón Lane, No.2, mango 54&quot;, 2 lb', 'Azadón Lane, No.2, mango 54&quot;, 2 lb', 9, 3, '10618', 0x414c2d324d, 17, 1, 20, '', NULL, 15.99, 4, 17.83, 'Exclusive', 40.00, 24.95, 27.82, 2.00, 'uploads/items/1644942582.jpg', '107.77.215.19', 'mobile-107-77-215-19.mobile.att.net', '2022-02-15', '12:29:42 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(155, 'IT0155', '7501206657782', 'Placa 2 modulos ABS, línea standard', 'PPDO-S 2 34.1 mm x 28.5 mm Dúplex\r\nColor Marfil\r\nDimensiones de la placa 114.0 mm x 69.6 mm\r\nEmpaque individual Bolsa', 9, 1, '46406', 0x7070646f2d73, 17, 0, 62, '', NULL, 0.39, 4, 0.43, 'Exclusive', 40.00, 0.60, 0.67, 10.00, 'uploads/items/1644943476.jpg', '107.77.215.19', 'mobile-107-77-215-19.mobile.att.net', '2022-02-15', '12:44:36 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(156, 'IT0156', '7501206657836', 'Placa para interruptor vertical', 'Placa para interruptor vertical', 9, 3, '46415', 0x707061702d73, 17, 1, 62, '', NULL, 0.35, 4, 0.39, 'Exclusive', 54.00, 0.60, 0.67, 10.00, 'uploads/items/1645020009.jpg', '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '2022-02-16', '10:00:09 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(157, 'IT0157', '7501206657751', 'Placa Ciega ABS', 'Placa Ciega ABS', 9, 1, '46400', 0x707063692d73, 17, 1, 62, '', NULL, 0.39, 4, 0.43, 'Exclusive', 40.00, 0.60, 0.67, 10.00, 'uploads/items/1645020156.jpg', '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '2022-02-16', '10:02:36 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(158, 'IT0158', '7501206657843', 'Placa contacto redondo ABS, línea standard', 'Placa contacto redondo ABS, línea standard', 9, 3, '46412', 0x707073652d73, 17, 1, 62, '', NULL, 0.39, 4, 0.43, 'Exclusive', 40.00, 0.60, 0.67, 10.00, 'uploads/items/1645020291.jpg', '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '2022-02-16', '10:04:51 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(159, 'IT0159', '639469185005', 'Work Glove Leather / Canvas Large set', 'Work Glove Leather / Canvas Large set', 9, 1, 'glove-001', '', 17, 1, 64, '', NULL, 2.25, 4, 2.51, 'Exclusive', 29.00, 3.25, 3.62, 12.00, 'uploads/items/1645029708.jpg', '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '2022-02-16', '12:41:48 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(160, 'IT0160', '026000070102', 'Wood Glue 8oz Elmer&#039;s', 'Wood Glue 8oz Elmer&#039;s', 9, 3, 'E7010', 0x373031302d31313030317573, 17, 1, 65, '', NULL, 1.69, 4, 1.88, 'Exclusive', 41.00, 2.65, 2.95, 12.00, 'uploads/items/1645033397.jpg', '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '2022-02-16', '01:43:17 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(161, 'IT0161', '639469020184', '18 pc Pneumatic Accessory Set 1/4 Brass', '18 pc Pneumatic Accessory Set 1/4 Brass', 9, 1, 'ataha-18b', '', 17, 1, 64, '', NULL, 13.00, 4, 14.50, 'Exclusive', 38.00, 19.95, 22.24, 2.00, 'uploads/items/1645036217.jpg', '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '2022-02-16', '02:30:17 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(162, 'IT0162', '794685126406', '7pcs Insulated Screwdriver &amp; tester set', '7pcs Insulated Screwdriver &amp; tester set', 9, 3, 'chis43007', '', 17, 1, 66, '', NULL, 13.00, 4, 14.50, 'Exclusive', 38.00, 19.95, 22.24, 1.00, 'uploads/items/1645038667.jpg', '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '2022-02-16', '03:11:07 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(163, 'IT0163', '', 'Lion Ball Loose Pin Hinges 3&quot;x3&quot;', 'Lion Ball Loose Pin Hinges 3&quot;x3&quot;', 9, 1, '2275814457_PH-10269857876', 0x33303037303031, 17, 1, 67, '', NULL, 1.50, 4, 1.67, 'Exclusive', 41.00, 2.35, 2.62, 6.00, 'uploads/items/1645113931.jpg', '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '2022-02-17', '12:05:31 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(164, 'IT0164', '', 'Lion Ball Loose Pin Hinges 3 1/2 x 3 1/2', 'Lion Ball Loose Pin Hinges 3 1/2 x 3 1/2', 9, 3, '3007002', 0x33303037303032, 17, 1, 67, '', NULL, 1.90, 4, 2.12, 'Exclusive', 39.00, 2.95, 3.29, 6.00, 'uploads/items/1645114135.jpg', '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '2022-02-17', '12:08:55 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(165, 'IT0165', '', 'Lion Ball Loose Pin Hinges 4x4', 'Lion Ball Loose Pin Hinges 4x4', 9, 1, '3007005', 0x33303037303035, 17, 1, 67, '', NULL, 2.55, 4, 2.84, 'Exclusive', 39.00, 3.95, 4.40, 6.00, 'uploads/items/1645114323.jpg', '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '2022-02-17', '12:12:03 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(166, 'IT0166', '', 'Brak Rub Water Hose  50&#039; 5/8&quot;', '', 9, 3, 'brk-50r', '', 17, 1, 68, '', NULL, 26.95, 4, 30.05, 'Exclusive', 40.00, 42.00, 46.83, 1.00, NULL, '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '2022-02-17', '12:48:48 pm', 'justiniano', NULL, 1, 'Percentage', 0.00),
(167, 'IT0167', '656489162212', 'Interstate Batteries CR1620 watch', 'Interstate Batteries CR1620 watch', 9, 1, 'lit0156', '', 17, 1, 29, '', '2024-07-31', 1.50, 4, 1.67, 'Exclusive', 35.00, 2.25, 2.51, 12.00, 'uploads/items/1645188481.jpg', '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '2022-02-18', '08:48:01 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(168, 'IT0168', '656489162519', 'Interstate Batteries CR2032  Alkaline', 'Interstate Batteries CR2032  Alkaline', 9, 3, 'LIT0155', '', 17, 1, 29, '', '2031-12-31', 1.25, 4, 1.39, 'Exclusive', 62.00, 2.25, 2.51, 11.00, 'uploads/items/1645190920.jpg', '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '2022-02-18', '09:28:40 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(169, 'IT0169', '656489162502', 'Interstate Batteries CR2025  Alkaline', 'Interstate Batteries CR2025  Alkaline', 9, 1, 'LIT0150', '', 17, 1, 29, '', '2031-12-31', 1.25, 4, 1.39, 'Exclusive', 62.00, 2.25, 2.51, 10.00, 'uploads/items/1645191041.jpg', '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '2022-02-18', '09:30:41 am', 'justiniano', NULL, 1, 'Percentage', 0.00),
(170, 'IT0170', 'Ad optio assumenda ', 'Asher Shepard', 'Dolor corporis sit r', 10, 3, 'Fugit quas aut blan', 0x56656c20667567696174206172636869746563, 16, 224, 43, '599', '2006-01-07', 80.00, 1, 80.00, 'Inclusive', 330.00, 297.00, 297.00, 0.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-04-17', '03:09:31 pm', 'admin', NULL, 1, 'Fixed', 0.00),
(171, 'IT0171', 'Ad optio assumenda ', '44', ' 23423', 8, 1, 'Fugit quas aut blan', 0x56656c20667567696174206172636869746563, 17, 32423, 1, '599', '2024-05-01', 24000.00, 1, 26520.00, 'Exclusive', 330.00, 114036.00, 126009.78, 3.00, 'uploads/items/1713381037.jpeg', '::1', 'DESKTOP-5RQCT8P', '2024-04-17', '03:10:37 pm', 'admin', NULL, 1, 'Fixed', 234.00),
(172, 'IT0172', '1122', 'Naseer Bhah', 'Test Desc', 8, 3, '1122', 0x31313232, 17, 11, 2, '1122', '2024-04-18', 24000.00, 1, 24000.00, 'Inclusive', 330.00, 103200.00, 103200.00, 1122.00, 'uploads/items/1713381135.jpeg', '::1', 'DESKTOP-5RQCT8P', '2024-04-17', '03:12:15 pm', 'admin', NULL, 1, 'Fixed', 11222.00),
(173, 'IT0173', '1122', '44', '1122', 6, 3, '1122', 0x31, 16, 1, 3, '1122', '2024-04-22', 1122.00, 4, 1122.00, 'Exclusive', 5.00, 1178.10, 1178.10, 3.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-04-21', '03:49:41 pm', 'admin', NULL, 1, 'Percentage', 5.00),
(174, 'IT0174', '345', '44', '4353', 7, 1, 'Fugit quas aut blan', 0x3435333435, 17, 45, 3, '599', '2024-04-24', 24000.00, 5, 24000.00, 'Inclusive', 330.00, 103200.00, 103200.00, 6.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-04-23', '04:49:27 pm', 'admin', NULL, 1, 'Percentage', 4.00),
(175, 'IT0175', '345', '44', ' DescriDescriptionption', 8, 0, '1122', 0x31, 19, 6, 1, '599', '2024-05-08', 24000.00, 4, 24000.00, 'Inclusive', 330.00, 103200.00, 103200.00, 4.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-04-26', '08:22:23 pm', 'admin', NULL, 1, '', 0.00),
(176, 'IT0176', '345', '44', ' Description', 8, 1, '1122SKU', 0x31, 17, 2, 1, '599', '2024-05-10', 24000.00, 2, 24240.00, 'Exclusive', 330.00, 104232.00, 105274.32, 0.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-04-26', '08:29:10 pm', 'admin', NULL, 1, '', 0.00),
(177, 'IT0177', '345', '44', ' Description', 8, 1, '1122SKU', 0x31, 17, 2, 1, '599', '2024-05-10', 24000.00, 2, 24240.00, 'Exclusive', 330.00, 104232.00, 105274.32, 4.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-04-26', '08:30:14 pm', 'admin', NULL, 1, '', 0.00),
(178, 'IT0178', '345', '44', ' Description', 8, 1, '1122SKU', 0x31, 17, 2, 1, '599', '2024-05-10', 24000.00, 2, 24240.00, 'Exclusive', 330.00, 104232.00, 105274.32, 4.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-04-26', '08:31:26 pm', 'admin', NULL, 1, '', 0.00),
(179, 'IT0179', '345', '44', ' Description', 8, 1, '1122SKU', 0x31, 17, 2, 1, '599', '2024-05-10', 24000.00, 2, 24240.00, 'Exclusive', 330.00, 104232.00, 105274.32, 4.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-04-26', '08:32:44 pm', 'admin', NULL, 1, NULL, 0.00),
(180, 'IT0180', '111', '1', ' 1111', 6, 1, '111', 0x313131, 16, 111, 1, '111', '2024-05-03', 111.00, 7, 112.11, 'Exclusive', 1.00, 113.23, 114.36, 1.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-04-26', '09:05:07 pm', 'admin', NULL, 1, NULL, 0.00),
(181, 'IT0181', '345', '44', '3453', 7, 1, '', 0x31, 17, 345, 0, '', '2024-04-30', 345.00, 2, 345.00, 'Inclusive', 345.00, 1535.25, 1535.25, 35.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-05-12', '12:46:10 pm', 'admin', NULL, 1, NULL, 345.00),
(182, 'IT0182', '345', '44', '3453', 7, 1, '', 0x31, 17, 345, 0, '', '2024-04-30', 345.00, 2, 345.00, 'Inclusive', 345.00, 1535.25, 1535.25, 35.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-05-12', '12:46:18 pm', 'admin', NULL, 1, NULL, 345.00),
(183, 'IT0183', '', '', '', 0, 0, '', '', 0, 0, 0, '', NULL, 0.00, 5, 0.00, 'Exclusive', NULL, 0.00, 0.00, 0.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-05-12', '12:46:36 pm', 'admin', NULL, 1, NULL, 0.00),
(184, 'IT0184', '', '', '', 0, 0, '', '', 0, 0, 0, '', NULL, 0.00, 5, 0.00, 'Exclusive', NULL, 0.00, 0.00, 0.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-05-12', '02:38:05 pm', 'admin', NULL, 1, NULL, 0.00),
(185, 'IT0185', '', '', '', 0, 0, '', '', 0, 0, 0, '', NULL, 0.00, 5, 0.00, 'Exclusive', NULL, 0.00, 0.00, 0.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-05-12', '02:39:12 pm', 'admin', NULL, 1, NULL, 0.00),
(186, 'IT0186', '', '', '', 0, 0, '', '', 0, 0, 0, '', NULL, 0.00, 5, 0.00, 'Exclusive', NULL, 0.00, 0.00, 0.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-05-12', '02:39:32 pm', 'admin', NULL, 1, NULL, 0.00),
(187, 'IT0187', '', '', '', 0, 0, NULL, '', 0, 0, 0, '', NULL, 0.00, 5, 0.00, 'Exclusive', NULL, 0.00, 0.00, 0.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-05-12', '02:43:33 pm', 'admin', NULL, 1, NULL, 0.00),
(188, 'IT0188', '', '', '', 0, 0, '', '', 0, 0, 0, '', NULL, 0.00, 5, 0.00, 'Exclusive', NULL, 0.00, 0.00, 0.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-05-12', '02:44:54 pm', 'admin', NULL, 1, NULL, 0.00),
(189, 'IT0189', '', '', '', 0, 0, '', '', 0, 0, 0, '', NULL, 0.00, 5, 0.00, 'Exclusive', NULL, 0.00, 0.00, 0.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-05-12', '02:45:42 pm', 'admin', NULL, 1, NULL, 0.00),
(190, 'IT0190', '', '', '', 0, 0, '', '', 0, 0, 0, '', NULL, 0.00, 5, 0.00, 'Exclusive', NULL, 0.00, 0.00, 0.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-05-12', '02:51:31 pm', 'admin', NULL, 1, NULL, 0.00),
(191, 'IT0191', '345', '44', '345345', 7, 3, '', 0x333435, 16, 345, 2, '', '2024-05-07', 345345.00, 6, 345345.00, 'Inclusive', 345.00, 1536785.25, 1536785.25, 345.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-05-12', '02:52:55 pm', 'admin', NULL, 1, NULL, 345.00),
(192, 'IT0192', '345', '44', '345345', 7, 3, NULL, 0x333435, 16, 345, 2, '', '2024-05-07', 345345.00, 6, 345345.00, 'Inclusive', 345.00, 1536785.25, 1536785.25, 345.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-05-12', '02:53:13 pm', 'admin', NULL, 1, NULL, 345.00),
(193, 'IT0193', '345', '44', '345345', 7, 3, NULL, 0x333435, 16, 345, 2, NULL, '2024-05-07', 345345.00, 6, 345345.00, 'Inclusive', 345.00, 1536785.25, 1536785.25, 345.00, NULL, '::1', 'DESKTOP-5RQCT8P', '2024-05-12', '02:53:27 pm', 'admin', NULL, 1, NULL, 345.00),
(194, 'IT0194', '234234', 'Asher Shepard', '234', 0, 5, NULL, 0x323334, 18, 234, 3, NULL, '2024-05-29', 234234.00, 5, 234234.00, 'Exclusive', 234.00, 234.00, 234.00, 234.00, 'uploads/items/1715540098.jpg', '::1', 'DESKTOP-5RQCT8P', '2024-05-12', '02:54:58 pm', 'admin', NULL, 1, NULL, 234.00);

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

--
-- Table structure for table `db_languages`
--

CREATE TABLE `db_languages` (
  `id` int(50) NOT NULL,
  `language` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_languages`
--

INSERT INTO `db_languages` (`id`, `language`, `status`) VALUES
(1, 'English', 1),
(2, 'Hindi', 1),
(3, 'Kannada', 1),
(4, 'Indonesian', 1),
(5, 'Chinese', 1),
(6, 'Russian', 1),
(7, 'Spanish', 1),
(8, 'Arabic', 1),
(9, 'Albanian', 1),
(10, 'Dutch', 1),
(11, 'Bangla', 1),
(12, 'Urdu', 1),
(13, 'Italian', 1),
(14, 'Marathi', 1),
(15, 'Khmer', 1);

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

--
-- Table structure for table `db_loan`
--

CREATE TABLE `db_loan` (
  `id` int(11) NOT NULL,
  `loan_authority` int(11) NOT NULL,
  `account` int(11) NOT NULL,
  `loan_reason` varchar(255) NOT NULL,
  `referance` varchar(255) NOT NULL,
  `loan_type` int(11) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `interest` varchar(255) NOT NULL,
  `payment_type` varchar(255) NOT NULL,
  `duration` varchar(255) NOT NULL,
  `per_month` varchar(255) NOT NULL,
  `payable_amount` varchar(255) NOT NULL,
  `date` date NOT NULL DEFAULT current_timestamp(),
  `note` varchar(255) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `db_loan`
--

INSERT INTO `db_loan` (`id`, `loan_authority`, `account`, `loan_reason`, `referance`, `loan_type`, `amount`, `interest`, `payment_type`, `duration`, `per_month`, `payable_amount`, `date`, `note`, `status`) VALUES
(6, 2, 4, '42', '52', 4, '67', '83', 'daily', '27', '80.4', '71.37', '2024-05-14', 'Voluptas dicta non m', 1),
(7, 2, 4, '9', '78', 5, '42', '51', 'monthly', '2', '2.83', '67.92', '2024-05-12', 'Sunt assumenda proid', 1);

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

--
-- Table structure for table `db_loan_payment`
--

CREATE TABLE `db_loan_payment` (
  `id` int(11) NOT NULL,
  `loan` varchar(255) NOT NULL,
  `reference` varchar(255) NOT NULL,
  `date` datetime NOT NULL,
  `status` int(11) DEFAULT 1,
  `note` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `db_loan_payment`
--

INSERT INTO `db_loan_payment` (`id`, `loan`, `reference`, `date`, `status`, `note`) VALUES
(1, '2', '243423', '2024-03-18 15:03:21', 0, 'testtttttttttttt');

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

--
-- Table structure for table `db_paymenttypes`
--

CREATE TABLE `db_paymenttypes` (
  `id` int(50) NOT NULL,
  `payment_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_paymenttypes`
--

INSERT INTO `db_paymenttypes` (`id`, `payment_type`, `status`) VALUES
(1, 'Cash', 1),
(2, 'Credit Card', 1),
(5, 'ATH Movil', 1),
(6, 'ATH', 1),
(7, 'PayPal', 1),
(8, 'On Account', 1);

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

--
-- Table structure for table `db_permissions`
--

CREATE TABLE `db_permissions` (
  `id` int(50) NOT NULL,
  `role_id` int(5) DEFAULT NULL,
  `permissions` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_permissions`
--

INSERT INTO `db_permissions` (`id`, `role_id`, `permissions`) VALUES
(95, 2, 'users_add'),
(96, 2, 'users_edit'),
(97, 2, 'users_delete'),
(98, 2, 'users_view'),
(99, 2, 'tax_add'),
(100, 2, 'tax_edit'),
(101, 2, 'tax_delete'),
(102, 2, 'tax_view'),
(103, 2, 'currency_add'),
(104, 2, 'currency_edit'),
(105, 2, 'currency_delete'),
(106, 2, 'currency_view'),
(107, 2, 'company_edit'),
(108, 2, 'units_add'),
(109, 2, 'units_edit'),
(110, 2, 'units_delete'),
(111, 2, 'units_view'),
(112, 2, 'places_add'),
(113, 2, 'places_edit'),
(114, 2, 'places_delete'),
(115, 2, 'places_view'),
(116, 2, 'expense_add'),
(117, 2, 'expense_edit'),
(118, 2, 'expense_delete'),
(119, 2, 'expense_view'),
(120, 2, 'items_add'),
(121, 2, 'items_edit'),
(122, 2, 'items_delete'),
(123, 2, 'items_view'),
(124, 2, 'brand_add'),
(125, 2, 'brand_edit'),
(126, 2, 'brand_delete'),
(127, 2, 'brand_view'),
(128, 2, 'suppliers_add'),
(129, 2, 'suppliers_edit'),
(130, 2, 'suppliers_delete'),
(131, 2, 'suppliers_view'),
(132, 2, 'customers_add'),
(133, 2, 'customers_edit'),
(134, 2, 'customers_delete'),
(135, 2, 'customers_view'),
(136, 2, 'purchase_add'),
(137, 2, 'purchase_edit'),
(138, 2, 'purchase_delete'),
(139, 2, 'purchase_view'),
(140, 2, 'sales_add'),
(141, 2, 'sales_edit'),
(142, 2, 'sales_delete'),
(143, 2, 'sales_view'),
(144, 2, 'sales_payment_view'),
(145, 2, 'sales_payment_add'),
(146, 2, 'sales_payment_delete'),
(147, 2, 'sales_report'),
(148, 2, 'purchase_report'),
(149, 2, 'expense_report'),
(150, 2, 'profit_report'),
(151, 2, 'stock_report'),
(152, 2, 'item_sales_report'),
(153, 2, 'purchase_payments_report'),
(154, 2, 'sales_payments_report'),
(155, 2, 'expired_items_report'),
(156, 2, 'items_category_add'),
(157, 2, 'items_category_edit'),
(158, 2, 'items_category_delete'),
(159, 2, 'items_category_view'),
(160, 2, 'print_labels'),
(161, 2, 'import_items'),
(162, 2, 'expense_category_add'),
(163, 2, 'expense_category_edit'),
(164, 2, 'expense_category_delete'),
(165, 2, 'expense_category_view'),
(166, 2, 'dashboard_view'),
(167, 2, 'purchase_return_add'),
(168, 2, 'purchase_return_edit'),
(169, 2, 'purchase_return_delete'),
(170, 2, 'purchase_return_view'),
(171, 2, 'purchase_return_report'),
(172, 2, 'sales_return_add'),
(173, 2, 'sales_return_edit'),
(174, 2, 'sales_return_delete'),
(175, 2, 'sales_return_view'),
(176, 2, 'sales_return_report'),
(177, 2, 'sales_return_payment_view'),
(178, 2, 'sales_return_payment_add'),
(179, 2, 'sales_return_payment_delete'),
(180, 2, 'purchase_return_payment_view'),
(181, 2, 'purchase_return_payment_add'),
(182, 2, 'purchase_return_payment_delete'),
(183, 2, 'purchase_payment_view'),
(184, 2, 'purchase_payment_add'),
(185, 2, 'purchase_payment_delete'),
(186, 2, 'payment_types_add'),
(187, 2, 'payment_types_edit'),
(188, 2, 'payment_types_delete'),
(189, 2, 'payment_types_view'),
(190, 2, 'import_customers'),
(191, 2, 'import_suppliers'),
(192, 2, 'item_purchase_report'),
(211, 3, 'places_view'),
(212, 3, 'items_view'),
(213, 3, 'brand_view'),
(214, 3, 'customers_add'),
(215, 3, 'customers_view'),
(216, 3, 'purchase_add'),
(217, 3, 'purchase_view'),
(218, 3, 'sales_add'),
(219, 3, 'sales_edit'),
(220, 3, 'sales_view'),
(221, 3, 'sales_payment_view'),
(222, 3, 'sales_payment_add'),
(223, 3, 'sales_payment_delete'),
(224, 3, 'items_category_view'),
(225, 3, 'print_labels'),
(226, 3, 'dashboard_view'),
(227, 3, 'purchase_return_view'),
(228, 3, 'sales_return_add'),
(229, 3, 'sales_return_view'),
(230, 3, 'sales_return_payment_view'),
(231, 3, 'purchase_return_payment_view'),
(232, 3, 'purchase_payment_view'),
(233, 3, 'purchase_payment_add');

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

--
-- Table structure for table `db_purchase`
--

CREATE TABLE `db_purchase` (
  `id` int(50) NOT NULL,
  `purchase_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `purchase_date` date DEFAULT NULL,
  `purchase_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `supplier_id` int(5) DEFAULT NULL,
  `warehouse_id` int(5) DEFAULT NULL,
  `other_charges_input` double(20,2) DEFAULT NULL,
  `other_charges_tax_id` int(5) DEFAULT NULL,
  `other_charges_amt` double(20,2) DEFAULT NULL,
  `discount_to_all_input` double(20,2) DEFAULT NULL,
  `discount_to_all_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tot_discount_to_all_amt` double(20,2) DEFAULT NULL,
  `subtotal` double(20,2) DEFAULT NULL COMMENT 'Purchased qty',
  `round_off` double(20,2) DEFAULT NULL COMMENT 'Pending Qty',
  `grand_total` double(20,2) DEFAULT NULL,
  `purchase_note` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paid_amount` double(20,2) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_time` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_ip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int(5) DEFAULT NULL,
  `status` int(1) DEFAULT NULL,
  `return_bit` int(1) DEFAULT NULL COMMENT 'Purchase return raised'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `db_purchaseitems`
--

CREATE TABLE `db_purchaseitems` (
  `id` int(50) NOT NULL,
  `purchase_id` int(5) DEFAULT NULL,
  `purchase_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_id` int(5) DEFAULT NULL,
  `purchase_qty` double(20,2) DEFAULT NULL,
  `price_per_unit` double(20,2) DEFAULT NULL,
  `tax_id` int(5) DEFAULT NULL,
  `tax_amt` double(20,2) DEFAULT NULL,
  `tax_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unit_discount_per` double(20,2) DEFAULT NULL,
  `discount_amt` double(20,2) DEFAULT NULL,
  `unit_total_cost` double(20,2) DEFAULT NULL,
  `total_cost` double(20,2) DEFAULT NULL,
  `profit_margin_per` double(20,2) DEFAULT NULL,
  `unit_sales_price` double(20,2) DEFAULT NULL,
  `status` int(5) DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_input` double(20,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_purchaseitems`
--

INSERT INTO `db_purchaseitems` (`id`, `purchase_id`, `purchase_status`, `item_id`, `purchase_qty`, `price_per_unit`, `tax_id`, `tax_amt`, `tax_type`, `unit_discount_per`, `discount_amt`, `unit_total_cost`, `total_cost`, `profit_margin_per`, `unit_sales_price`, `status`, `description`, `discount_type`, `discount_input`) VALUES
(8, 3, 'Pending', 4, 1.00, 0.99, 1, 0.10, 'Exclusive', NULL, 0.00, 1.09, 1.09, NULL, NULL, 1, '', 'Percentage', 0.00);

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

--
-- Table structure for table `db_purchaseitemsreturn`
--

CREATE TABLE `db_purchaseitemsreturn` (
  `id` int(50) NOT NULL,
  `purchase_id` int(5) DEFAULT NULL,
  `return_id` int(5) DEFAULT NULL,
  `return_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_id` int(5) DEFAULT NULL,
  `return_qty` double(20,2) DEFAULT NULL,
  `price_per_unit` double(20,2) DEFAULT NULL,
  `tax_id` int(5) DEFAULT NULL,
  `tax_amt` double(20,2) DEFAULT NULL,
  `tax_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unit_discount_per` double(20,2) DEFAULT NULL,
  `discount_amt` double(20,2) DEFAULT NULL,
  `unit_total_cost` double(20,2) DEFAULT NULL,
  `total_cost` double(20,2) DEFAULT NULL,
  `profit_margin_per` double(20,2) DEFAULT NULL,
  `unit_sales_price` double(20,2) DEFAULT NULL,
  `status` int(5) DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_input` double(20,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_purchaseitemsreturn`
--

INSERT INTO `db_purchaseitemsreturn` (`id`, `purchase_id`, `return_id`, `return_status`, `item_id`, `return_qty`, `price_per_unit`, `tax_id`, `tax_amt`, `tax_type`, `unit_discount_per`, `discount_amt`, `unit_total_cost`, `total_cost`, `profit_margin_per`, `unit_sales_price`, `status`, `description`, `discount_type`, `discount_input`) VALUES
(3, NULL, 1, 'Cancel', 3, 1.00, 1.38, 1, 0.14, 'Exclusive', NULL, 0.00, 1.52, 1.52, NULL, NULL, 1, '', 'Percentage', 0.00),
(4, NULL, 1, 'Cancel', 7, 1.00, 0.00, 1, NULL, 'Exclusive', NULL, 0.00, 0.00, 0.00, NULL, NULL, 1, '', 'Percentage', 0.00);

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

--
-- Table structure for table `db_purchasepayments`
--

CREATE TABLE `db_purchasepayments` (
  `id` int(50) NOT NULL,
  `purchase_id` int(5) DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `payment_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment` double(20,2) DEFAULT NULL,
  `payment_note` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_time` time DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_purchasepayments`
--

INSERT INTO `db_purchasepayments` (`id`, `purchase_id`, `payment_date`, `payment_type`, `payment`, `payment_note`, `system_ip`, `system_name`, `created_time`, `created_date`, `created_by`, `status`) VALUES
(1, 3, '2024-04-23', 'Credit Card', 1.00, '', '::1', 'DESKTOP-5RQCT8P', '04:24:28', '2024-04-23', 'admin', 1);

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

--
-- Table structure for table `db_purchasepaymentsreturn`
--

CREATE TABLE `db_purchasepaymentsreturn` (
  `id` int(50) NOT NULL,
  `purchase_id` int(11) DEFAULT NULL,
  `return_id` int(5) DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `payment_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment` double(20,2) DEFAULT NULL,
  `payment_note` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_time` time DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `db_purchasereturn`
--

CREATE TABLE `db_purchasereturn` (
  `id` int(50) NOT NULL,
  `purchase_id` int(11) DEFAULT NULL,
  `return_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `return_date` date DEFAULT NULL,
  `return_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `supplier_id` int(5) DEFAULT NULL,
  `warehouse_id` int(5) DEFAULT NULL,
  `other_charges_input` double(20,2) DEFAULT NULL,
  `other_charges_tax_id` int(5) DEFAULT NULL,
  `other_charges_amt` double(20,2) DEFAULT NULL,
  `discount_to_all_input` double(20,2) DEFAULT NULL,
  `discount_to_all_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tot_discount_to_all_amt` double(20,2) DEFAULT NULL,
  `subtotal` double(20,2) DEFAULT NULL COMMENT 'Purchased qty',
  `round_off` double(20,2) DEFAULT NULL COMMENT 'Pending Qty',
  `grand_total` double(20,2) DEFAULT NULL,
  `return_note` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paid_amount` double(20,2) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_time` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_ip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int(5) DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_purchasereturn`
--

INSERT INTO `db_purchasereturn` (`id`, `purchase_id`, `return_code`, `reference_no`, `return_date`, `return_status`, `supplier_id`, `warehouse_id`, `other_charges_input`, `other_charges_tax_id`, `other_charges_amt`, `discount_to_all_input`, `discount_to_all_type`, `tot_discount_to_all_amt`, `subtotal`, `round_off`, `grand_total`, `return_note`, `payment_status`, `paid_amount`, `created_date`, `created_time`, `created_by`, `system_ip`, `system_name`, `company_id`, `status`) VALUES
(1, NULL, 'PR0001', '3333', '2024-04-23', 'Cancel', 2, 5, NULL, NULL, NULL, NULL, 'in_percentage', NULL, 1.52, NULL, 1.52, '', 'Unpaid', 0.00, '2024-04-23', '04:33:27 pm', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1);

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

--
-- Table structure for table `db_roles`
--

CREATE TABLE `db_roles` (
  `id` int(50) NOT NULL,
  `role_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_roles`
--

INSERT INTO `db_roles` (`id`, `role_name`, `description`, `status`) VALUES
(1, 'Admin', 'All Rights Permitted.', 1),
(2, 'Owner', '', 1),
(3, 'Clerk', '', 1);

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

--
-- Table structure for table `db_sales`
--

CREATE TABLE `db_sales` (
  `id` int(50) NOT NULL,
  `sales_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sales_date` date DEFAULT NULL,
  `sales_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_id` int(5) DEFAULT NULL,
  `warehouse_id` int(5) DEFAULT NULL,
  `other_charges_input` double(20,2) DEFAULT NULL,
  `other_charges_tax_id` int(5) DEFAULT NULL,
  `other_charges_amt` double(20,2) DEFAULT NULL,
  `discount_to_all_input` double(20,2) DEFAULT NULL,
  `discount_to_all_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tot_discount_to_all_amt` double(20,2) DEFAULT NULL,
  `subtotal` double(20,2) DEFAULT NULL,
  `round_off` double(20,2) DEFAULT NULL,
  `grand_total` double(20,2) DEFAULT NULL,
  `sales_note` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paid_amount` double(20,2) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_time` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_ip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int(5) DEFAULT NULL,
  `pos` int(1) DEFAULT NULL COMMENT '1=yes 0=no',
  `status` int(1) DEFAULT NULL,
  `return_bit` int(1) DEFAULT NULL COMMENT 'sales return raised'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_sales`
--

INSERT INTO `db_sales` (`id`, `sales_code`, `reference_no`, `sales_date`, `sales_status`, `customer_id`, `warehouse_id`, `other_charges_input`, `other_charges_tax_id`, `other_charges_amt`, `discount_to_all_input`, `discount_to_all_type`, `tot_discount_to_all_amt`, `subtotal`, `round_off`, `grand_total`, `sales_note`, `payment_status`, `paid_amount`, `created_date`, `created_time`, `created_by`, `system_ip`, `system_name`, `company_id`, `pos`, `status`, `return_bit`) VALUES
(1, 'SL0001', '12', '2024-04-23', 'Final', 2, 1, NULL, NULL, NULL, NULL, 'in_percentage', NULL, 4.92, NULL, 4.92, '', 'Unpaid', 0.00, '2024-04-23', '04:07:20 pm', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, NULL, 1, NULL),
(2, 'SL0002', NULL, '2024-04-26', 'Final', 1, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 1.62, 0.00, 1.62, NULL, 'Paid', 1.62, '2024-04-26', '06:53:46 pm', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL),
(3, 'SL0003', NULL, '2024-04-26', 'Final', 1, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 0.00, 0.00, 0.00, NULL, '', 4.62, '2024-04-26', '07:34:35 pm', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL),
(4, 'SL0004', NULL, '2024-04-26', 'Final', 1, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 3.26, 0.00, 3.26, NULL, '', 23.04, '2024-04-26', '07:41:46 pm', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL),
(5, 'SL0005', NULL, '2024-04-26', 'Final', 1, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 33.09, 0.00, 33.09, NULL, '', 37.27, '2024-04-26', '07:42:14 pm', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL),
(6, 'SL0006', NULL, '2024-04-26', 'Final', 1, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 3.81, 0.00, 3.81, NULL, 'Paid', 3.81, '2024-04-26', '07:42:33 pm', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL),
(7, 'SL0007', NULL, '2024-04-26', 'Final', 1, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 1.62, 0.00, 1.62, NULL, '', 17.05, '2024-04-26', '07:42:57 pm', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL),
(8, 'SL0008', NULL, '2024-04-26', 'Final', 1, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 33.09, 0.00, 33.09, NULL, '', 126.75, '2024-04-26', '07:43:34 pm', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL),
(9, 'SL0009', NULL, '2024-04-26', 'Final', 1, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 3.74, 0.00, 3.74, NULL, '', 16.87, '2024-04-26', '07:44:43 pm', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL),
(10, 'SL0010', '', '2024-04-26', 'Quotation', 1, 3, NULL, NULL, NULL, NULL, 'in_percentage', NULL, 3.26, NULL, 3.26, '', '', 16.39, '2024-04-26', '08:34:38 pm', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, NULL, 1, NULL),
(11, 'SL0011', NULL, '2024-04-27', 'Final', 1, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 7.04, 0.00, 7.04, NULL, '', 10.06, '2024-04-27', '06:21:55 am', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL),
(12, 'SL0012', NULL, '2024-05-04', 'Final', 2, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 1.62, 0.00, 1.62, NULL, '', 2.47, '2024-05-04', '02:15:18 pm', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL),
(13, 'SL0013', NULL, '2024-05-04', 'Final', 1, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 1.62, 0.00, 1.62, NULL, '', 6.36, '2024-05-04', '02:30:18 pm', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL),
(14, 'SL0014', NULL, '2024-05-05', 'Final', 1, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 1.62, 0.00, 1.62, NULL, 'Paid', 1.62, '2024-05-05', '02:12:51 am', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL),
(15, 'SL0015', NULL, '2024-05-05', 'Final', 1, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 4.36, 0.00, 4.36, NULL, 'Paid', 4.36, '2024-05-05', '02:13:19 am', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL),
(16, 'SL0016', NULL, '2024-05-05', 'Final', 1, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 4.36, 0.00, 4.36, NULL, 'Paid', 4.36, '2024-05-05', '02:13:37 am', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL),
(17, 'SL0017', NULL, '2024-05-06', 'Final', 1, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 1.62, 0.00, 1.62, NULL, 'Paid', 1.62, '2024-05-06', '03:26:45 pm', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL),
(18, 'SL0018', NULL, '2024-05-16', 'Final', 1, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 1.62, 0.00, 1.62, NULL, 'Paid', 1.62, '2024-05-16', '03:23:11 pm', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL),
(19, 'SL0019', NULL, '2024-05-16', 'Final', 25, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 34.71, 0.00, 34.71, NULL, 'Paid', 34.71, '2024-05-16', '04:05:20 pm', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL),
(20, 'SL0020', NULL, '2024-05-16', 'Final', 1, NULL, 0.00, NULL, 0.00, 0.00, 'in_percentage', 0.00, 33.09, 0.00, 33.09, NULL, 'Paid', 33.09, '2024-05-16', '04:05:31 pm', 'admin', '::1', 'DESKTOP-5RQCT8P', NULL, 1, 1, NULL);

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

--
-- Table structure for table `db_salesitems`
--

CREATE TABLE `db_salesitems` (
  `id` int(50) NOT NULL,
  `sales_id` int(5) DEFAULT NULL,
  `sales_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_id` int(5) DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sales_qty` double(20,2) DEFAULT NULL,
  `price_per_unit` double(20,2) DEFAULT NULL,
  `tax_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_id` int(5) DEFAULT NULL,
  `tax_amt` double(20,2) DEFAULT NULL,
  `discount_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_input` double(20,2) DEFAULT NULL,
  `discount_amt` double(20,2) DEFAULT NULL,
  `unit_total_cost` double(20,2) DEFAULT NULL,
  `total_cost` double(20,2) DEFAULT NULL,
  `status` int(5) DEFAULT NULL,
  `purchase_price` double(20,2) DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_salesitems`
--

INSERT INTO `db_salesitems` (`id`, `sales_id`, `sales_status`, `item_id`, `description`, `sales_qty`, `price_per_unit`, `tax_type`, `tax_id`, `tax_amt`, `discount_type`, `discount_input`, `discount_amt`, `unit_total_cost`, `total_cost`, `status`, `purchase_price`) VALUES
(3, 3, 'Final', 1, '', 2.00, 1.45, 'Exclusive', 1, 0.30, 'Percentage', 0.00, 0.00, 1.60, 3.20, 1, 0.83),
(4, 4, 'Final', 16, '', 2.00, 8.95, 'Exclusive', 1, 1.88, 'Percentage', 0.00, 0.00, 9.89, 19.78, 1, 0.00),
(5, 5, 'Final', 120, '', 3.00, 1.25, 'Exclusive', 4, 0.43, 'Percentage', 0.00, 0.00, 1.39, 4.18, 1, 0.76),
(6, 6, 'Quotation', 129, '', 4.00, 106.72, 'Inclusive', NULL, NULL, 'Fixed', NULL, 0.00, 106.72, 426.88, 1, 92.80),
(7, 6, 'Quotation', 130, '', 4.00, 300.50, 'Inclusive', NULL, NULL, 'Fixed', NULL, 0.00, 300.50, 1202.00, 1, 273.18),
(8, 6, 'Quotation', 131, '', 4.00, 158.22, 'Inclusive', NULL, NULL, 'Percentage', NULL, 0.00, 158.22, 632.88, 1, 143.84),
(9, 6, 'Quotation', 132, '', 6.00, 116.94, 'Inclusive', NULL, NULL, 'Percentage', NULL, 0.00, 116.94, 701.64, 1, 97.45),
(10, 6, 'Quotation', 133, '', 4.00, 161.90, 'Inclusive', NULL, NULL, 'Percentage', NULL, 0.00, 161.90, 647.60, 1, 147.18),
(11, 7, 'Final', 92, '', 1.00, 5.99, 'Exclusive', 4, 0.69, 'Percentage', 0.00, 0.00, 6.68, 6.68, 1, 3.90),
(12, 7, 'Final', 91, '', 1.00, 4.49, 'Exclusive', 4, 0.52, 'Percentage', 0.00, 0.00, 5.01, 5.01, 1, 3.90),
(13, 7, 'Final', 36, '', 1.00, 3.35, 'Exclusive', 4, 0.39, 'Percentage', 0.00, 0.00, 3.74, 3.74, 1, 0.00),
(14, 8, 'Final', 166, '', 2.00, 42.00, 'Exclusive', 4, 9.66, 'Percentage', 0.00, 0.00, 46.83, 93.66, 1, 30.05),
(15, 9, 'Quotation', 3, '', 1.00, 2.95, 'Exclusive', 1, 0.31, 'Percentage', NULL, 0.00, 3.26, 3.26, 1, 1.38),
(16, 10, 'Quotation', 3, '', 1.00, 2.95, 'Exclusive', 1, 0.31, 'Percentage', NULL, 0.00, 3.26, 3.26, 1, 1.38),
(18, 12, 'Final', 9, '', 1.00, 3.45, 'Exclusive', 4, 0.40, 'Percentage', NULL, 0.00, 3.85, 3.85, 1, 0.00),
(19, 11, 'Quotation', 6, '', 1.00, 4.45, 'Exclusive', 1, 0.47, 'Percentage', NULL, 0.00, 4.92, 4.92, 1, 0.00),
(24, 13, 'Quotation', 60, '', 1.00, 4.25, 'Exclusive', 4, 0.49, 'Percentage', NULL, 0.00, 4.74, 4.74, 1, 2.95),
(33, 1, 'Final', 5, '', 1.00, 4.45, 'Exclusive', 1, 0.47, 'Percentage', NULL, 0.00, 4.92, 4.92, 1, 0.00),
(34, 2, 'Final', 1, '', 1.00, 1.45, 'Exclusive', 4, 0.17, 'Percentage', 0.00, 0.00, 1.62, 1.62, 1, 0.84),
(35, 5, 'Final', 2, '', 1.00, 29.95, 'Exclusive', 1, 3.14, 'Percentage', 0.00, 0.00, 33.09, 33.09, 1, 0.00),
(36, 6, 'Final', 7, '', 1.00, 3.45, 'Exclusive', 1, 0.36, 'Percentage', 0.00, 0.00, 3.81, 3.81, 1, 0.00),
(37, 7, 'Final', 1, '', 1.00, 1.45, 'Exclusive', 4, 0.17, 'Percentage', 0.00, 0.00, 1.62, 1.62, 1, 0.84),
(38, 10, 'Quotation', 3, '', 1.00, 2.95, 'Exclusive', 1, 0.31, 'Percentage', NULL, 0.00, 3.26, 3.26, 1, 1.38),
(39, 11, 'Final', 1, '', 2.00, 1.45, 'Exclusive', 4, 0.33, 'Percentage', 0.00, 0.00, 1.62, 3.23, 1, 0.84),
(40, 11, 'Final', 7, '', 1.00, 3.45, 'Exclusive', 1, 0.36, 'Percentage', 0.00, 0.00, 3.81, 3.81, 1, 0.00),
(41, 12, 'Final', 1, '', 1.00, 1.45, 'Exclusive', 4, 0.17, 'Percentage', 0.00, 0.00, 1.62, 1.62, 1, 0.84),
(42, 13, 'Final', 1, '', 1.00, 1.45, 'Exclusive', 4, 0.17, 'Percentage', 0.00, 0.00, 1.62, 1.62, 1, 0.84),
(43, 14, 'Final', 1, '', 1.00, 1.45, 'Exclusive', 4, 0.17, 'Percentage', 0.00, 0.00, 1.62, 1.62, 1, 0.84),
(44, 15, 'Final', 14, '', 1.00, 3.95, 'Exclusive', 1, 0.41, 'Percentage', 0.00, 0.00, 4.36, 4.36, 1, 0.00),
(45, 16, 'Final', 14, '', 1.00, 3.95, 'Exclusive', 1, 0.41, 'Percentage', 0.00, 0.00, 4.36, 4.36, 1, 0.00),
(46, 17, 'Final', 1, '', 1.00, 1.45, 'Exclusive', 4, 0.17, 'Percentage', 0.00, 0.00, 1.62, 1.62, 1, 0.84),
(47, 18, 'Final', 1, '', 1.00, 1.45, 'Exclusive', 4, 0.17, 'Percentage', 0.00, 0.00, 1.62, 1.62, 1, 0.84);

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

--
-- Table structure for table `db_salesitemsreturn`
--

CREATE TABLE `db_salesitemsreturn` (
  `id` int(50) NOT NULL,
  `sales_id` int(5) DEFAULT NULL,
  `return_id` int(5) DEFAULT NULL,
  `return_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `item_id` int(5) DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `return_qty` double(20,2) DEFAULT NULL,
  `price_per_unit` double(20,2) DEFAULT NULL,
  `tax_id` int(5) DEFAULT NULL,
  `tax_amt` double(20,2) DEFAULT NULL,
  `tax_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_input` double(20,2) DEFAULT NULL,
  `discount_amt` double(20,2) DEFAULT NULL,
  `discount_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unit_total_cost` double(20,2) DEFAULT NULL,
  `total_cost` double(20,2) DEFAULT NULL,
  `status` int(5) DEFAULT NULL,
  `purchase_price` double(20,2) DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `db_salespayments`
--

CREATE TABLE `db_salespayments` (
  `id` int(50) NOT NULL,
  `sales_id` int(5) DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `payment_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment` double(20,2) DEFAULT NULL,
  `payment_note` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `change_return` double(20,2) DEFAULT NULL COMMENT 'Refunding the greater amount',
  `system_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_time` time DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_salespayments`
--

INSERT INTO `db_salespayments` (`id`, `sales_id`, `payment_date`, `payment_type`, `payment`, `payment_note`, `change_return`, `system_ip`, `system_name`, `created_time`, `created_date`, `created_by`, `status`) VALUES
(3, 3, '2022-02-03', 'Cash', 3.00, '', 2.00, '107.72.164.16', '107.72.164.16', '09:22:01', '2022-02-03', 'justiniano', 1),
(4, 4, '2022-02-09', 'Cash', 19.78, '', 0.22, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '09:33:31', '2022-02-09', 'justiniano', 1),
(5, 5, '2022-02-11', 'ATH Movil', 4.18, '', 0.00, '107.77.215.226', 'mobile-107-77-215-226.mobile.att.net', '08:14:09', '2022-02-11', 'justiniano', 1),
(6, 7, '2022-02-17', 'Cash', 15.43, '', 4.57, '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '11:56:25', '2022-02-17', 'justiniano', 1),
(7, 8, '2022-02-17', 'Cash', 93.66, 'Paid By Cash', 0.00, '107.77.216.171', 'mobile-107-77-216-171.mobile.att.net', '12:51:48', '2022-02-17', 'justiniano', 1),
(8, 9, '2024-04-21', 'Credit Card', 13.13, 'test', NULL, '::1', 'DESKTOP-5RQCT8P', '03:38:17', '2024-04-21', 'admin', 1),
(9, 10, '2024-04-21', 'Credit Card', 13.13, 'test', NULL, '::1', 'DESKTOP-5RQCT8P', '03:38:34', '2024-04-21', 'admin', 1),
(10, 11, '2024-04-02', 'Cash', 3.02, '', NULL, '::1', 'DESKTOP-5RQCT8P', '03:40:33', '2024-04-21', 'admin', 1),
(11, 12, '2024-04-21', 'ATH', 0.85, '', NULL, '::1', 'DESKTOP-5RQCT8P', '04:42:14', '2024-04-21', 'admin', 1),
(15, 13, '2024-04-21', 'ATH', 4.74, '', NULL, '::1', 'DESKTOP-5RQCT8P', '01:13:12', '2024-04-21', 'admin', 1),
(20, 2, '2024-04-26', 'Cash', 1.62, 'Paid By Cash', 0.00, '::1', 'DESKTOP-5RQCT8P', '06:53:46', '2024-04-26', 'admin', 1),
(21, 3, '2024-04-26', 'ATH', 1.62, 'yment Not', 0.00, '::1', 'DESKTOP-5RQCT8P', '07:34:35', '2024-04-26', 'admin', 1),
(22, 4, '2024-04-26', 'Cash', 3.26, '', 0.00, '::1', 'DESKTOP-5RQCT8P', '07:41:46', '2024-04-26', 'admin', 1),
(23, 5, '2024-04-26', 'Cash', 33.09, 'Paid By Cash', 0.00, '::1', 'DESKTOP-5RQCT8P', '07:42:14', '2024-04-26', 'admin', 1),
(24, 6, '2024-04-26', 'Cash', 3.81, '', 0.00, '::1', 'DESKTOP-5RQCT8P', '07:42:33', '2024-04-26', 'admin', 1),
(25, 7, '2024-04-26', 'Cash', 1.62, '1.62', 0.00, '::1', 'DESKTOP-5RQCT8P', '07:42:57', '2024-04-26', 'admin', 1),
(26, 8, '2024-04-26', 'Cash', 33.09, '', 0.00, '::1', 'DESKTOP-5RQCT8P', '07:43:34', '2024-04-26', 'admin', 1),
(27, 9, '2024-04-26', 'Cash', 3.74, '', 0.00, '::1', 'DESKTOP-5RQCT8P', '07:44:43', '2024-04-26', 'admin', 1),
(28, 10, '2024-04-26', 'ATH', 3.26, '', NULL, '::1', 'DESKTOP-5RQCT8P', '08:34:38', '2024-04-26', 'admin', 1),
(29, 11, '2024-04-27', 'Credit Card', 7.04, '', 0.01, '::1', 'DESKTOP-5RQCT8P', '06:21:55', '2024-04-27', 'admin', 1),
(30, 12, '2024-05-04', 'Cash', 1.62, 'Paid By Cash', 0.00, '::1', 'DESKTOP-5RQCT8P', '02:15:18', '2024-05-04', 'admin', 1),
(31, 13, '2024-05-04', 'Cash', 1.62, 'Paid By Cash', 0.00, '::1', 'DESKTOP-5RQCT8P', '02:30:18', '2024-05-04', 'admin', 1),
(32, 14, '2024-05-05', 'Cash', 1.62, 'Paid By Cash', 0.00, '::1', 'DESKTOP-5RQCT8P', '02:12:51', '2024-05-05', 'admin', 1),
(33, 15, '2024-05-05', 'Cash', 4.36, 'Paid By Cash', 0.00, '::1', 'DESKTOP-5RQCT8P', '02:13:19', '2024-05-05', 'admin', 1),
(34, 16, '2024-05-05', 'Cash', 4.36, 'Paid By Cash', 0.00, '::1', 'DESKTOP-5RQCT8P', '02:13:37', '2024-05-05', 'admin', 1),
(35, 17, '2024-05-06', 'Cash', 1.62, 'Paid By Cash', 0.00, '::1', 'DESKTOP-5RQCT8P', '03:26:45', '2024-05-06', 'admin', 1),
(36, 18, '2024-05-16', 'Cash', 1.62, 'Paid By Cash', 0.00, '::1', 'DESKTOP-5RQCT8P', '03:23:11', '2024-05-16', 'admin', 1),
(37, 19, '2024-05-16', 'ATH', 34.71, '234234', 199.29, '::1', 'DESKTOP-5RQCT8P', '04:05:20', '2024-05-16', 'admin', 1),
(38, 20, '2024-05-16', 'Cash', 33.09, 'Paid By Cash', 0.00, '::1', 'DESKTOP-5RQCT8P', '04:05:31', '2024-05-16', 'admin', 1);

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

--
-- Table structure for table `db_salespaymentsreturn`
--

CREATE TABLE `db_salespaymentsreturn` (
  `id` int(50) NOT NULL,
  `sales_id` int(5) DEFAULT NULL,
  `return_id` int(5) DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `payment_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment` double(20,2) DEFAULT NULL,
  `payment_note` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `change_return` double(20,2) DEFAULT NULL COMMENT 'Refunding the greater amount',
  `system_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_time` time DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `db_salesreturn`
--

CREATE TABLE `db_salesreturn` (
  `id` int(50) NOT NULL,
  `sales_id` int(5) DEFAULT NULL,
  `return_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `return_date` date DEFAULT NULL,
  `return_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_id` int(5) DEFAULT NULL,
  `warehouse_id` int(5) DEFAULT NULL,
  `other_charges_input` double(20,2) DEFAULT NULL,
  `other_charges_tax_id` int(5) DEFAULT NULL,
  `other_charges_amt` double(20,2) DEFAULT NULL,
  `discount_to_all_input` double(20,2) DEFAULT NULL,
  `discount_to_all_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tot_discount_to_all_amt` double(20,2) DEFAULT NULL,
  `subtotal` double(20,2) DEFAULT NULL,
  `round_off` double(20,2) DEFAULT NULL,
  `grand_total` double(20,2) DEFAULT NULL,
  `return_note` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_status` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paid_amount` double(20,2) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_time` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_ip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int(5) DEFAULT NULL,
  `pos` int(1) DEFAULT NULL COMMENT '1=yes 0=no',
  `status` int(1) DEFAULT NULL,
  `return_bit` int(1) DEFAULT NULL COMMENT 'Return raised or not 1 or null'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `db_sitesettings`
--

CREATE TABLE `db_sitesettings` (
  `id` int(50) NOT NULL,
  `version` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'path',
  `language_id` int(5) DEFAULT NULL,
  `currency_id` int(5) DEFAULT NULL,
  `currency_placement` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timezone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_format` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `time_format` int(5) DEFAULT NULL,
  `sales_discount` double(20,2) DEFAULT NULL,
  `site_url` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_title` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_desc` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keywords` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currencysymbol_id` int(5) DEFAULT NULL,
  `regno_key` varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `copyright` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook_url` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter_url` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `youtube_url` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `analytic_code` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fav_icon` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'path',
  `footer_logo` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'path',
  `company_id` int(1) DEFAULT NULL,
  `purchase_code` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `change_return` int(1) DEFAULT NULL COMMENT 'show in pos',
  `sales_invoice_format_id` int(5) DEFAULT NULL,
  `sales_invoice_footer_text` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `round_off` int(1) DEFAULT NULL COMMENT '1=Enble, 0=Disable',
  `machine_id` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `domain` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `show_upi_code` int(1) DEFAULT 0,
  `unique_code` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disable_tax` int(1) DEFAULT 0 COMMENT 'If set Disable the tax from app'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_sitesettings`
--

INSERT INTO `db_sitesettings` (`id`, `version`, `site_name`, `logo`, `language_id`, `currency_id`, `currency_placement`, `timezone`, `date_format`, `time_format`, `sales_discount`, `site_url`, `site_title`, `meta_title`, `meta_desc`, `meta_keywords`, `currencysymbol_id`, `regno_key`, `copyright`, `facebook_url`, `twitter_url`, `youtube_url`, `analytic_code`, `fav_icon`, `footer_logo`, `company_id`, `purchase_code`, `change_return`, `sales_invoice_format_id`, `sales_invoice_footer_text`, `round_off`, `machine_id`, `domain`, `show_upi_code`, `unique_code`, `disable_tax`) VALUES
(1, '2.0', 'Babiato Travel Agency', 'download.jpg', 1, 45, 'Left', 'America/Puerto_Rico\r\n', 'dd-mm-yyyy', 12, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 3, ' This is footer text. You can set it from Site Settings.', 0, '1', 'www.babiato.co', 0, 'i49trbfy8kmd20gs6xp51z3vwe7lao', 0);

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

--
-- Table structure for table `db_smsapi`
--

CREATE TABLE `db_smsapi` (
  `id` int(50) NOT NULL,
  `info` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `key` varchar(600) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `key_value` varchar(600) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delete_bit` int(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_smsapi`
--

INSERT INTO `db_smsapi` (`id`, `info`, `key`, `key_value`, `delete_bit`) VALUES
(144, 'url', 'weblink', 'http://www.example.in/api/sendhttp.php', NULL),
(145, 'mobile', 'mobiles', '', NULL),
(146, 'message', 'message', '', NULL),
(147, '', 'authkey', 'xxxxxxxxxxxxxxxxxxxx', NULL),
(148, '', 'sender', 'ULTPOS', NULL),
(149, '', 'route', '1', NULL);

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

--
-- Table structure for table `db_smstemplates`
--

CREATE TABLE `db_smstemplates` (
  `id` int(50) NOT NULL,
  `template_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `variables` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int(5) DEFAULT NULL,
  `status` int(5) DEFAULT NULL,
  `undelete_bit` int(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_smstemplates`
--

INSERT INTO `db_smstemplates` (`id`, `template_name`, `content`, `variables`, `company_id`, `status`, `undelete_bit`) VALUES
(1, 'GREETING TO CUSTOMER ON SALES', 'Hi {{customer_name}},\r\nYour sales Id is {{sales_id}},\r\nSales Date {{sales_date}},\r\nTotal amount  {{sales_amount}},\r\nYou have paid  {{paid_amt}},\r\nand customer total due amount is  {{cust_tot_due_amt}}\r\nThank you Visit Again', '{{customer_name}}<br>\r\n{{sales_id}}<br>\r\n{{sales_date}}<br>\r\n{{sales_amount}}<br>\r\n{{paid_amt}}<br>\r\n{{cust_tot_due_amt}}<br>\r\n{{invoice_due_amt}}<br>\r\n{{company_name}}<br>\r\n{{company_mobile}}<br>\r\n{{company_address}}<br>\r\n{{company_website}}<br>\r\n{{company_email}}<br>', NULL, 1, 1),
(2, 'GREETING TO CUSTOMER ON SALES RETURN', 'Hi {{customer_name}},\r\nYour sales return Id is {{return_id}},\r\nReturn Date {{return_date}},\r\nTotal amount  {{return_amount}},\r\nWe paid  {{paid_amt}},\r\nand customer total due amount is  {{cust_tot_due_amt}}\r\nThank you Visit Again', '{{customer_name}}<br>\r\n{{return_id}}<br>\r\n{{return_date}}<br>\r\n{{return_amount}}<br>\r\n{{paid_amt}}<br>\r\n{{cust_tot_due_amt}}<br>\r\n{{invoice_due_amt}}<br>\r\n{{company_name}}<br>\r\n{{company_mobile}}<br>\r\n{{company_address}}<br>\r\n{{company_website}}<br>\r\n{{company_email}}<br>', NULL, 1, 1);

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

--
-- Table structure for table `db_sobpayments`
--

CREATE TABLE `db_sobpayments` (
  `id` int(50) NOT NULL,
  `supplier_id` int(5) DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `payment_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment` double(20,2) DEFAULT NULL,
  `payment_note` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_time` time DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `db_states`
--

CREATE TABLE `db_states` (
  `id` int(50) NOT NULL,
  `state_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(4050) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_code` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` int(5) DEFAULT NULL,
  `country` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `added_on` date DEFAULT NULL,
  `company_id` int(5) DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_states`
--

INSERT INTO `db_states` (`id`, `state_code`, `state`, `country_code`, `country_id`, `country`, `added_on`, `company_id`, `status`) VALUES
(23, 'ST0001', 'Karnataka', 'CNT0001', NULL, 'India', '2017-07-10', 1, 1),
(24, 'ST0024', 'Maharashtra', 'CNT0001', NULL, 'India', '2018-04-13', 1, 1),
(25, 'ST0025', 'Andhra Pradesh', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(26, 'ST0026', 'Arunachal Pradesh', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(27, 'ST0027', 'Assam', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(28, 'ST0028', 'Bihar', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(29, 'ST0029', 'Chhattisgarh', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(30, 'ST0030', 'Goa', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(31, 'ST0031', 'Gujarat', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(32, 'ST0032', 'Haryana', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(33, 'ST0033', 'Himachal Pradesh', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(34, 'ST0034', 'Jammu and Kashmir', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(35, 'ST0035', 'Jharkhand', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(36, 'ST0036', 'Kerala', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(37, 'ST0037', 'Madhya Pradesh', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(38, 'ST0038', 'Manipur', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(39, 'ST0039', 'Meghalaya', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(40, 'ST0040', 'Mizoram', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(41, 'ST0041', 'Nagaland', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(42, 'ST0042', 'Odisha', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(43, 'ST0043', 'Punjab', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(44, 'ST0044', 'Rajasthan', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(46, 'ST0046', 'Tamil Nadu', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(47, 'ST0047', 'Telangana', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(48, 'ST0048', 'Tripura', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(49, 'ST0049', 'Uttar Pradesh', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(50, 'ST0050', 'Uttarakhand', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(51, 'ST0051', 'West Bengal', 'CNT0001', NULL, 'India', '2018-11-02', NULL, 1),
(52, NULL, 'New York', NULL, NULL, 'USA', NULL, NULL, 1),
(53, NULL, 'Delhi', NULL, NULL, 'India', NULL, NULL, 1),
(54, NULL, 'PR', NULL, NULL, 'Puerto Rico', NULL, NULL, 1);

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

--
-- Table structure for table `db_stockentry`
--

CREATE TABLE `db_stockentry` (
  `id` int(50) NOT NULL,
  `entry_date` date DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `qty` int(5) DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_stockentry`
--

INSERT INTO `db_stockentry` (`id`, `entry_date`, `item_id`, `qty`, `note`, `status`) VALUES
(3, '2022-02-02', 1, 60, NULL, 1),
(4, '2022-02-02', 1, 0, '', 1),
(5, '2022-02-02', 2, 2, NULL, 1),
(6, '2022-02-02', 2, 0, '', 1),
(7, '2022-02-02', 3, 11, NULL, 1),
(8, '2022-02-02', 3, 0, '', 1),
(9, '2022-02-02', 4, 17, NULL, 1),
(10, '2022-02-02', 4, 0, '', 1),
(11, '2022-02-02', 5, 4, NULL, 1),
(12, '2022-02-02', 5, 0, '', 1),
(13, '2022-02-02', 6, 11, NULL, 1),
(14, '2022-02-02', 6, 0, '', 1),
(15, '2022-02-02', 7, 3, NULL, 1),
(16, '2022-02-02', 7, 0, '', 1),
(17, '2022-02-02', 8, 3, NULL, 1),
(18, '2022-02-02', 8, 0, '', 1),
(19, '2022-02-02', 9, 1, NULL, 1),
(20, '2022-02-02', 9, 0, '', 1),
(21, '2022-02-02', 10, 12, NULL, 1),
(22, '2022-02-02', 10, 0, '', 1),
(23, '2022-02-02', 11, 12, NULL, 1),
(24, '2022-02-02', 11, 0, '', 1),
(25, '2022-02-02', 12, 12, NULL, 1),
(26, '2022-02-02', 12, 0, '', 1),
(27, '2022-02-02', 13, 2, NULL, 1),
(28, '2022-02-02', 13, 0, '', 1),
(29, '2022-02-02', 14, 3, NULL, 1),
(30, '2022-02-02', 14, 0, '', 1),
(31, '2022-02-02', 15, 11, NULL, 1),
(32, '2022-02-02', 15, 0, '', 1),
(33, '2022-02-02', 16, 7, NULL, 1),
(34, '2022-02-02', 16, 0, '', 1),
(35, '2022-02-02', 17, 11, NULL, 1),
(36, '2022-02-02', 17, 0, '', 1),
(37, '2022-02-02', 18, 5, NULL, 1),
(38, '2022-02-02', 18, 0, '', 1),
(39, '2022-02-02', 19, 11, NULL, 1),
(40, '2022-02-02', 19, 0, '', 1),
(41, '2022-02-02', 20, 4, NULL, 1),
(42, '2022-02-02', 20, 0, '', 1),
(43, '2022-02-02', 21, 10, NULL, 1),
(44, '2022-02-02', 21, 0, '', 1),
(45, '2022-02-02', 22, 83, NULL, 1),
(46, '2022-02-02', 22, 0, '', 1),
(47, '2022-02-02', 23, 11, NULL, 1),
(48, '2022-02-02', 23, 0, '', 1),
(49, '2022-02-02', 24, 5, NULL, 1),
(50, '2022-02-02', 24, 0, '', 1),
(51, '2022-02-02', 25, 6, NULL, 1),
(52, '2022-02-02', 25, 0, '', 1),
(53, '2022-02-02', 26, 5, NULL, 1),
(54, '2022-02-02', 26, 0, '', 1),
(55, '2022-02-02', 27, 3, NULL, 1),
(56, '2022-02-02', 27, 0, '', 1),
(57, '2022-02-02', 28, 6, NULL, 1),
(58, '2022-02-02', 28, 0, '', 1),
(59, '2022-02-02', 29, 5, NULL, 1),
(60, '2022-02-02', 29, 0, '', 1),
(61, '2022-02-02', 30, 5, NULL, 1),
(62, '2022-02-02', 30, 0, '', 1),
(63, '2022-02-02', 31, 6, NULL, 1),
(64, '2022-02-02', 31, 0, '', 1),
(65, '2022-02-02', 32, 6, NULL, 1),
(66, '2022-02-02', 32, 0, '', 1),
(67, '2022-02-02', 33, 6, NULL, 1),
(68, '2022-02-02', 33, 0, '', 1),
(69, '2022-02-02', 34, 6, NULL, 1),
(70, '2022-02-02', 34, 0, '', 1),
(71, '2022-02-02', 35, 6, NULL, 1),
(72, '2022-02-02', 35, 0, '', 1),
(73, '2022-02-02', 36, 7, NULL, 1),
(74, '2022-02-02', 36, 0, '', 1),
(75, '2022-02-02', 37, 6, NULL, 1),
(76, '2022-02-02', 37, 0, '', 1),
(77, '2022-02-02', 38, 4, NULL, 1),
(78, '2022-02-02', 38, 0, '', 1),
(79, '2022-02-02', 39, 6, NULL, 1),
(80, '2022-02-02', 39, 0, '', 1),
(81, '2022-02-02', 40, 5, NULL, 1),
(82, '2022-02-02', 40, 0, '', 1),
(83, '2022-02-02', 41, 6, NULL, 1),
(84, '2022-02-02', 41, 0, '', 1),
(85, '2022-02-02', 42, 6, NULL, 1),
(86, '2022-02-02', 42, 0, '', 1),
(87, '2022-02-02', 43, 6, NULL, 1),
(88, '2022-02-02', 43, 0, '', 1),
(89, '2022-02-02', 44, 6, NULL, 1),
(90, '2022-02-02', 44, 0, '', 1),
(91, '2022-02-02', 45, 6, NULL, 1),
(92, '2022-02-02', 45, 0, '', 1),
(93, '2022-02-02', 46, 1, NULL, 1),
(94, '2022-02-02', 46, 0, '', 1),
(95, '2022-02-02', 47, 3, NULL, 1),
(96, '2022-02-02', 47, 0, '', 1),
(97, '2022-02-02', 48, 6, NULL, 1),
(98, '2022-02-02', 48, 0, '', 1),
(99, '2022-02-02', 49, 2, NULL, 1),
(100, '2022-02-02', 49, 0, '', 1),
(101, '2022-02-04', 50, 24, '', 1),
(103, '2022-02-04', 52, 5, '', 1),
(104, '2022-02-04', 53, 5, '', 1),
(105, '2022-02-04', 54, 10, '', 1),
(106, '2022-02-04', 55, 10, '', 1),
(107, '2022-02-04', 56, 5, '', 1),
(108, '2022-02-04', 57, 9, '', 1),
(109, '2022-02-04', 58, 8, '', 1),
(110, '2022-02-04', 59, 4, '', 1),
(111, '2022-02-04', 60, 5, '', 1),
(112, '2022-02-04', 61, 2, '', 1),
(113, '2022-02-04', 62, 3, '', 1),
(114, '2022-02-05', 63, 2, '', 1),
(115, '2022-02-05', 64, 7, '', 1),
(116, '2022-02-05', 65, 9, '', 1),
(117, '2022-02-05', 66, 1, '', 1),
(118, '2022-02-05', 67, 11, '', 1),
(119, '2022-02-05', 68, 1, '', 1),
(120, '2022-02-05', 69, 10, '', 1),
(121, '2022-02-05', 70, 1, '', 1),
(122, '2022-02-05', 71, 2, '', 1),
(123, '2022-02-05', 72, 12, '', 1),
(124, '2022-02-05', 73, 12, '', 1),
(125, '2022-02-05', 74, 12, '', 1),
(126, '2022-02-05', 75, 10, '', 1),
(127, '2022-02-05', 76, 2, '', 1),
(128, '2022-02-05', 77, 6, '', 1),
(129, '2022-02-05', 78, 12, '', 1),
(130, '2022-02-05', 79, 6, '', 1),
(131, '2022-02-05', 80, 20, '', 1),
(132, '2022-02-05', 81, 6, '', 1),
(133, '2022-02-05', 82, 6, '', 1),
(134, '2022-02-05', 83, 8, '', 1),
(135, '2022-02-05', 84, 8, '', 1),
(136, '2022-02-05', 85, 8, '', 1),
(137, '2022-02-05', 86, 4, '', 1),
(138, '2022-02-05', 87, 7, '', 1),
(139, '2022-02-05', 88, 11, '', 1),
(140, '2022-02-05', 89, 7, '', 1),
(141, '2022-02-05', 90, 10, '', 1),
(142, '2022-02-05', 91, 8, '', 1),
(143, '2022-02-05', 92, 24, '', 1),
(144, '2022-02-05', 93, 2, '', 1),
(145, '2022-02-05', 94, 1, '', 1),
(146, '2022-02-05', 95, 3, '', 1),
(147, '2022-02-05', 96, 5, '', 1),
(148, '2022-02-05', 97, 5, '', 1),
(149, '2022-02-05', 98, 7, '', 1),
(150, '2022-02-05', 99, 3, '', 1),
(151, '2022-02-05', 100, 3, '', 1),
(152, '2022-02-05', 101, 2, '', 1),
(153, '2022-02-07', 1, -2, '', 1),
(154, '2022-02-07', 102, 8, '', 1),
(155, '2022-02-07', 103, 4, '', 1),
(156, '2022-02-07', 104, 12, '', 1),
(158, '2022-02-09', 105, 2, '', 1),
(159, '2022-02-09', 106, 3, '', 1),
(160, '2022-02-09', 107, 1, '', 1),
(161, '2022-02-09', 108, 2, '', 1),
(162, '2022-02-09', 109, 3, '', 1),
(163, '2022-02-09', 110, 3, '', 1),
(164, '2022-02-09', 111, 3, '', 1),
(165, '2022-02-09', 112, 10, '', 1),
(166, '2022-02-09', 113, 5, '', 1),
(167, '2022-02-09', 114, 4, '', 1),
(168, '2022-02-09', 115, 3, '', 1),
(169, '2022-02-09', 116, 2, '', 1),
(170, '2022-02-09', 117, 3, '', 1),
(171, '2022-02-09', 118, 3, '', 1),
(172, '2022-02-09', 119, 6, '', 1),
(173, '2022-02-09', 120, 30, '', 1),
(174, '2022-02-09', 121, 12, '', 1),
(175, '2022-02-09', 122, 7, '', 1),
(176, '2022-02-09', 123, 10, '', 1),
(177, '2022-02-09', 124, 10, '', 1),
(178, '2022-02-09', 125, 12, '', 1),
(179, '2022-02-11', 126, 3, '', 1),
(180, '2022-02-11', 127, 12, '', 1),
(181, '2022-02-11', 128, 12, '', 1),
(182, '2022-02-11', 129, 8, '', 1),
(183, '2022-02-11', 130, 8, '', 1),
(184, '2022-02-11', 131, 8, '', 1),
(185, '2022-02-11', 132, 8, '', 1),
(186, '2022-02-11', 133, 8, '', 1),
(187, '2022-02-11', 134, 6, '', 1),
(188, '2022-02-11', 135, 246, '', 1),
(189, '2022-02-11', 136, 12, '', 1),
(190, '2022-02-11', 137, 12, '', 1),
(191, '2022-02-11', 138, 12, '', 1),
(192, '2022-02-11', 139, 12, '', 1),
(193, '2022-02-11', 140, 6, '', 1),
(194, '2022-02-11', 141, 6, '', 1),
(195, '2022-02-11', 142, 6, '', 1),
(196, '2022-02-11', 143, 6, '', 1),
(197, '2022-02-11', 144, 6, '', 1),
(198, '2022-02-11', 145, 6, '', 1),
(199, '2022-02-11', 146, 6, '', 1),
(200, '2022-02-11', 147, 3, '', 1),
(201, '2022-02-11', 148, 6, '', 1),
(202, '2022-02-15', 149, 12, '', 1),
(203, '2022-02-15', 115, 2, '', 1),
(204, '2022-02-15', 150, 1, '', 1),
(205, '2022-02-15', 151, 1, '', 1),
(206, '2022-02-15', 152, 2, '', 1),
(207, '2022-02-15', 153, 2, '', 1),
(208, '2022-02-15', 154, 2, '', 1),
(209, '2022-02-15', 155, 10, '', 1),
(210, '2022-02-16', 156, 10, '', 1),
(211, '2022-02-16', 157, 10, '', 1),
(212, '2022-02-16', 158, 10, '', 1),
(213, '2022-02-16', 159, 12, '', 1),
(214, '2022-02-16', 160, 12, '', 1),
(215, '2022-02-16', 161, 2, '', 1),
(216, '2022-02-16', 162, 1, '', 1),
(217, '2022-02-17', 66, 5, '', 1),
(218, '2022-02-17', 163, 6, '', 1),
(219, '2022-02-17', 164, 6, '', 1),
(220, '2022-02-17', 165, 6, '', 1),
(221, '2022-02-17', 166, 3, '', 1),
(222, '2022-02-18', 167, 12, '', 1),
(223, '2022-02-18', 168, 11, '', 1),
(224, '2022-02-18', 169, 10, '', 1),
(225, '2024-04-17', 171, 3, ' 342', 1),
(226, '2024-04-17', 172, 1122, 'Adjustment Note1', 1),
(228, '2024-04-21', 173, 3, '', 1),
(229, '2024-04-23', 174, 2, '2', 1),
(230, '2024-04-23', 174, 4, '4', 1),
(231, '2024-04-26', 175, 4, ' \r\n4\r\nAdjustment Note', 1),
(232, '2024-04-26', 177, 4, ' Adjustment Not', 1),
(233, '2024-04-26', 178, 4, ' Adjustment Not', 1),
(234, '2024-04-26', 179, 4, ' Adjustment Not', 1),
(235, '2024-04-26', 180, 1, ' 1', 1),
(236, '2024-05-12', 181, 35, '345', 1),
(237, '2024-05-12', 182, 35, '345', 1),
(238, '2024-05-12', 191, 345, '345', 1),
(239, '2024-05-12', 192, 345, '345', 1),
(240, '2024-05-12', 193, 345, '345', 1),
(241, '2024-05-12', 194, 234, '234234', 1);

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

--
-- Table structure for table `db_suppliers`
--

CREATE TABLE `db_suppliers` (
  `id` int(50) NOT NULL,
  `supplier_code` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `supplier_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gstin` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vatin` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `opening_balance` double(20,2) DEFAULT NULL,
  `purchase_due` double(20,2) DEFAULT NULL,
  `purchase_return_due` double(20,2) DEFAULT NULL,
  `country_id` int(5) DEFAULT NULL,
  `state_id` int(5) DEFAULT NULL,
  `city` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_time` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int(5) DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_suppliers`
--

INSERT INTO `db_suppliers` (`id`, `supplier_code`, `supplier_name`, `mobile`, `phone`, `email`, `gstin`, `tax_number`, `vatin`, `opening_balance`, `purchase_due`, `purchase_return_due`, `country_id`, `state_id`, `city`, `postcode`, `address`, `system_ip`, `system_name`, `created_date`, `created_time`, `created_by`, `company_id`, `status`) VALUES
(1, 'SP0001', 'Vento', '', '', '', '', '', NULL, 5000.00, 0.00, 0.00, 2, 54, '', '', '', '2600:387:f:a10::2', '2600:387:f:a10::2', '2022-02-02', '11:25:27 pm', 'justiniano', NULL, 1),
(2, 'SP0002', 'Ricardo Cruz Dist', '', '', '', '', '', NULL, 10000.00, 0.00, 1.52, 2, NULL, '', '', '', '2600:387:f:a10::2', '2600:387:f:a10::2', '2022-02-02', '11:26:25 pm', 'justiniano', NULL, 1),
(3, 'SP0003', 'Correa Tire', '', '', '', '', '', NULL, 0.00, NULL, NULL, 2, NULL, '', '', '', '2600:387:f:a10::2', '2600:387:f:a10::2', '2022-02-02', '11:26:39 pm', 'justiniano', NULL, 1),
(4, 'SP0004', 'Centeno Tire', '', '', '', '', '', NULL, 0.00, NULL, 0.00, 2, NULL, '', '', '', '2600:387:f:a10::2', '2600:387:f:a10::2', '2022-02-02', '11:26:52 pm', 'justiniano', NULL, 1),
(5, 'SP0005', 'Carribean Rubber', '', '', '', '', '', NULL, 0.00, NULL, NULL, 2, NULL, '', '', '', '2600:387:f:a10::2', '2600:387:f:a10::2', '2022-02-02', '11:27:07 pm', 'justiniano', NULL, 1),
(6, 'SP0006', 'Burgos tire', '', '', '', '', '', NULL, 0.00, NULL, NULL, 2, NULL, '', '', '', '2600:387:f:a10::2', '2600:387:f:a10::2', '2022-02-02', '11:27:22 pm', 'justiniano', NULL, 1),
(7, 'SP0007', 'A Garcia Ferreteria', '', '', '', '', '', NULL, 0.00, NULL, NULL, 2, NULL, '', '', '', '2600:387:f:a10::2', '2600:387:f:a10::2', '2022-02-02', '11:27:47 pm', 'justiniano', NULL, 1),
(8, 'SP0008', 'M Group Truper Ferreteria', '', '', '', '', '', NULL, 0.00, NULL, NULL, 3, 54, '', '', '', '2600:387:f:a10::2', '2600:387:f:a10::2', '2022-02-02', '11:28:14 pm', 'justiniano', NULL, 1),
(9, 'SP0009', 'Olein Oil', '', '', '', '', '', NULL, 0.00, NULL, NULL, 2, NULL, '', '', '', '2600:387:f:a10::2', '2600:387:f:a10::2', '2022-02-02', '11:28:42 pm', 'justiniano', NULL, 1),
(10, 'SP0010', 'Universal Manufaturer', '', '', '', '', '', NULL, 0.00, NULL, NULL, 2, NULL, '', '', '', '2600:387:f:a10::2', '2600:387:f:a10::2', '2022-02-02', '11:29:08 pm', 'justiniano', NULL, 1);

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

--
-- Table structure for table `db_supplier_payments`
--

CREATE TABLE `db_supplier_payments` (
  `id` int(50) NOT NULL,
  `purchasepayment_id` int(5) DEFAULT NULL,
  `supplier_id` int(5) DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `payment_type` varchar(50) DEFAULT NULL,
  `payment` double(20,2) DEFAULT NULL,
  `payment_note` text DEFAULT NULL,
  `system_ip` varchar(50) DEFAULT NULL,
  `system_name` varchar(50) DEFAULT NULL,
  `created_time` varchar(50) DEFAULT NULL,
  `created_date` varchar(50) DEFAULT NULL,
  `created_by` varchar(50) DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `db_tax`
--

CREATE TABLE `db_tax` (
  `id` int(50) NOT NULL,
  `tax_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tax` double(20,2) DEFAULT NULL,
  `group_bit` int(1) DEFAULT NULL COMMENT '1=Yes, 0=No',
  `subtax_ids` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Tax groups IDs',
  `status` int(1) DEFAULT NULL,
  `undelete_bit` int(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_tax`
--

INSERT INTO `db_tax` (`id`, `tax_name`, `tax`, `group_bit`, `subtax_ids`, `status`, `undelete_bit`) VALUES
(1, 'State Tax', 10.50, NULL, NULL, 1, 0),
(2, 'Mun Tax', 1.00, NULL, NULL, 1, 0),
(4, 'IVU', 11.50, 1, '1,2', 1, 0),
(5, 'None', 0.00, NULL, NULL, 1, 1),
(6, 'test', 1.00, NULL, NULL, 1, 0),
(7, '1', 1.00, NULL, NULL, 1, 0),
(8, '23123123123', 10.00, NULL, NULL, 1, 0),
(9, 'werwerwerwe', 10.00, NULL, NULL, 1, 0),
(10, 'Name*', 34.00, NULL, NULL, 1, 0);

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

--
-- Table structure for table `db_timezone`
--

CREATE TABLE `db_timezone` (
  `id` int(50) NOT NULL,
  `timezone` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_timezone`
--

INSERT INTO `db_timezone` (`id`, `timezone`, `status`) VALUES
(1, 'Africa/Abidjan\r', 1),
(2, 'Africa/Accra\r', 1),
(3, 'Africa/Addis_Ababa\r', 1),
(4, 'Africa/Algiers\r', 1),
(5, 'Africa/Asmara\r', 1),
(6, 'Africa/Asmera\r', 1),
(7, 'Africa/Bamako\r', 1),
(8, 'Africa/Bangui\r', 1),
(9, 'Africa/Banjul\r', 1),
(10, 'Africa/Bissau\r', 1),
(11, 'Africa/Blantyre\r', 1),
(12, 'Africa/Brazzaville\r', 1),
(13, 'Africa/Bujumbura\r', 1),
(14, 'Africa/Cairo\r', 1),
(15, 'Africa/Casablanca\r', 1),
(16, 'Africa/Ceuta\r', 1),
(17, 'Africa/Conakry\r', 1),
(18, 'Africa/Dakar\r', 1),
(19, 'Africa/Dar_es_Salaam\r', 1),
(20, 'Africa/Djibouti\r', 1),
(21, 'Africa/Douala\r', 1),
(22, 'Africa/El_Aaiun\r', 1),
(23, 'Africa/Freetown\r', 1),
(24, 'Africa/Gaborone\r', 1),
(25, 'Africa/Harare\r', 1),
(26, 'Africa/Johannesburg\r', 1),
(27, 'Africa/Juba\r', 1),
(28, 'Africa/Kampala\r', 1),
(29, 'Africa/Khartoum\r', 1),
(30, 'Africa/Kigali\r', 1),
(31, 'Africa/Kinshasa\r', 1),
(32, 'Africa/Lagos\r', 1),
(33, 'Africa/Libreville\r', 1),
(34, 'Africa/Lome\r', 1),
(35, 'Africa/Luanda\r', 1),
(36, 'Africa/Lubumbashi\r', 1),
(37, 'Africa/Lusaka\r', 1),
(38, 'Africa/Malabo\r', 1),
(39, 'Africa/Maputo\r', 1),
(40, 'Africa/Maseru\r', 1),
(41, 'Africa/Mbabane\r', 1),
(42, 'Africa/Mogadishu\r', 1),
(43, 'Africa/Monrovia\r', 1),
(44, 'Africa/Nairobi\r', 1),
(45, 'Africa/Ndjamena\r', 1),
(46, 'Africa/Niamey\r', 1),
(47, 'Africa/Nouakchott\r', 1),
(48, 'Africa/Ouagadougou\r', 1),
(49, 'Africa/Porto-Novo\r', 1),
(50, 'Africa/Sao_Tome\r', 1),
(51, 'Africa/Timbuktu\r', 1),
(52, 'Africa/Tripoli\r', 1),
(53, 'Africa/Tunis\r', 1),
(54, 'Africa/Windhoek\r', 1),
(55, 'AKST9AKDT\r', 1),
(56, 'America/Adak\r', 1),
(57, 'America/Anchorage\r', 1),
(58, 'America/Anguilla\r', 1),
(59, 'America/Antigua\r', 1),
(60, 'America/Araguaina\r', 1),
(61, 'America/Argentina/Buenos_Aires\r', 1),
(62, 'America/Argentina/Catamarca\r', 1),
(63, 'America/Argentina/ComodRivadavia\r', 1),
(64, 'America/Argentina/Cordoba\r', 1),
(65, 'America/Argentina/Jujuy\r', 1),
(66, 'America/Argentina/La_Rioja\r', 1),
(67, 'America/Argentina/Mendoza\r', 1),
(68, 'America/Argentina/Rio_Gallegos\r', 1),
(69, 'America/Argentina/Salta\r', 1),
(70, 'America/Argentina/San_Juan\r', 1),
(71, 'America/Argentina/San_Luis\r', 1),
(72, 'America/Argentina/Tucuman\r', 1),
(73, 'America/Argentina/Ushuaia\r', 1),
(74, 'America/Aruba\r', 1),
(75, 'America/Asuncion\r', 1),
(76, 'America/Atikokan\r', 1),
(77, 'America/Atka\r', 1),
(78, 'America/Bahia\r', 1),
(79, 'America/Bahia_Banderas\r', 1),
(80, 'America/Barbados\r', 1),
(81, 'America/Belem\r', 1),
(82, 'America/Belize\r', 1),
(83, 'America/Blanc-Sablon\r', 1),
(84, 'America/Boa_Vista\r', 1),
(85, 'America/Bogota\r', 1),
(86, 'America/Boise\r', 1),
(87, 'America/Buenos_Aires\r', 1),
(88, 'America/Cambridge_Bay\r', 1),
(89, 'America/Campo_Grande\r', 1),
(90, 'America/Cancun\r', 1),
(91, 'America/Caracas\r', 1),
(92, 'America/Catamarca\r', 1),
(93, 'America/Cayenne\r', 1),
(94, 'America/Cayman\r', 1),
(95, 'America/Chicago\r', 1),
(96, 'America/Chihuahua\r', 1),
(97, 'America/Coral_Harbour\r', 1),
(98, 'America/Cordoba\r', 1),
(99, 'America/Costa_Rica\r', 1),
(100, 'America/Creston\r', 1),
(101, 'America/Cuiaba\r', 1),
(102, 'America/Curacao\r', 1),
(103, 'America/Danmarkshavn\r', 1),
(104, 'America/Dawson\r', 1),
(105, 'America/Dawson_Creek\r', 1),
(106, 'America/Denver\r', 1),
(107, 'America/Detroit\r', 1),
(108, 'America/Dominica\r', 1),
(109, 'America/Edmonton\r', 1),
(110, 'America/Eirunepe\r', 1),
(111, 'America/El_Salvador\r', 1),
(112, 'America/Ensenada\r', 1),
(113, 'America/Fort_Wayne\r', 1),
(114, 'America/Fortaleza\r', 1),
(115, 'America/Glace_Bay\r', 1),
(116, 'America/Godthab\r', 1),
(117, 'America/Goose_Bay\r', 1),
(118, 'America/Grand_Turk\r', 1),
(119, 'America/Grenada\r', 1),
(120, 'America/Guadeloupe\r', 1),
(121, 'America/Guatemala\r', 1),
(122, 'America/Guayaquil\r', 1),
(123, 'America/Guyana\r', 1),
(124, 'America/Halifax\r', 1),
(125, 'America/Havana\r', 1),
(126, 'America/Hermosillo\r', 1),
(127, 'America/Indiana/Indianapolis\r', 1),
(128, 'America/Indiana/Knox\r', 1),
(129, 'America/Indiana/Marengo\r', 1),
(130, 'America/Indiana/Petersburg\r', 1),
(131, 'America/Indiana/Tell_City\r', 1),
(132, 'America/Indiana/Vevay\r', 1),
(133, 'America/Indiana/Vincennes\r', 1),
(134, 'America/Indiana/Winamac\r', 1),
(135, 'America/Indianapolis\r', 1),
(136, 'America/Inuvik\r', 1),
(137, 'America/Iqaluit\r', 1),
(138, 'America/Jamaica\r', 1),
(139, 'America/Jujuy\r', 1),
(140, 'America/Juneau\r', 1),
(141, 'America/Kentucky/Louisville\r', 1),
(142, 'America/Kentucky/Monticello\r', 1),
(143, 'America/Knox_IN\r', 1),
(144, 'America/Kralendijk\r', 1),
(145, 'America/La_Paz\r', 1),
(146, 'America/Lima\r', 1),
(147, 'America/Los_Angeles\r', 1),
(148, 'America/Louisville\r', 1),
(149, 'America/Lower_Princes\r', 1),
(150, 'America/Maceio\r', 1),
(151, 'America/Managua\r', 1),
(152, 'America/Manaus\r', 1),
(153, 'America/Marigot\r', 1),
(154, 'America/Martinique\r', 1),
(155, 'America/Matamoros\r', 1),
(156, 'America/Mazatlan\r', 1),
(157, 'America/Mendoza\r', 1),
(158, 'America/Menominee\r', 1),
(159, 'America/Merida\r', 1),
(160, 'America/Metlakatla\r', 1),
(161, 'America/Mexico_City\r', 1),
(162, 'America/Miquelon\r', 1),
(163, 'America/Moncton\r', 1),
(164, 'America/Monterrey\r', 1),
(165, 'America/Montevideo\r', 1),
(166, 'America/Montreal\r', 1),
(167, 'America/Montserrat\r', 1),
(168, 'America/Nassau\r', 1),
(169, 'America/New_York\r', 1),
(170, 'America/Nipigon\r', 1),
(171, 'America/Nome\r', 1),
(172, 'America/Noronha\r', 1),
(173, 'America/North_Dakota/Beulah\r', 1),
(174, 'America/North_Dakota/Center\r', 1),
(175, 'America/North_Dakota/New_Salem\r', 1),
(176, 'America/Ojinaga\r', 1),
(177, 'America/Panama\r', 1),
(178, 'America/Pangnirtung\r', 1),
(179, 'America/Paramaribo\r', 1),
(180, 'America/Phoenix\r', 1),
(181, 'America/Port_of_Spain\r', 1),
(182, 'America/Port-au-Prince\r', 1),
(183, 'America/Porto_Acre\r', 1),
(184, 'America/Porto_Velho\r', 1),
(185, 'America/Puerto_Rico\r', 1),
(186, 'America/Rainy_River\r', 1),
(187, 'America/Rankin_Inlet\r', 1),
(188, 'America/Recife\r', 1),
(189, 'America/Regina\r', 1),
(190, 'America/Resolute\r', 1),
(191, 'America/Rio_Branco\r', 1),
(192, 'America/Rosario\r', 1),
(193, 'America/Santa_Isabel\r', 1),
(194, 'America/Santarem\r', 1),
(195, 'America/Santiago\r', 1),
(196, 'America/Santo_Domingo\r', 1),
(197, 'America/Sao_Paulo\r', 1),
(198, 'America/Scoresbysund\r', 1),
(199, 'America/Shiprock\r', 1),
(200, 'America/Sitka\r', 1),
(201, 'America/St_Barthelemy\r', 1),
(202, 'America/St_Johns\r', 1),
(203, 'America/St_Kitts\r', 1),
(204, 'America/St_Lucia\r', 1),
(205, 'America/St_Thomas\r', 1),
(206, 'America/St_Vincent\r', 1),
(207, 'America/Swift_Current\r', 1),
(208, 'America/Tegucigalpa\r', 1),
(209, 'America/Thule\r', 1),
(210, 'America/Thunder_Bay\r', 1),
(211, 'America/Tijuana\r', 1),
(212, 'America/Toronto\r', 1),
(213, 'America/Tortola\r', 1),
(214, 'America/Vancouver\r', 1),
(215, 'America/Virgin\r', 1),
(216, 'America/Whitehorse\r', 1),
(217, 'America/Winnipeg\r', 1),
(218, 'America/Yakutat\r', 1),
(219, 'America/Yellowknife\r', 1),
(220, 'Antarctica/Casey\r', 1),
(221, 'Antarctica/Davis\r', 1),
(222, 'Antarctica/DumontDUrville\r', 1),
(223, 'Antarctica/Macquarie\r', 1),
(224, 'Antarctica/Mawson\r', 1),
(225, 'Antarctica/McMurdo\r', 1),
(226, 'Antarctica/Palmer\r', 1),
(227, 'Antarctica/Rothera\r', 1),
(228, 'Antarctica/South_Pole\r', 1),
(229, 'Antarctica/Syowa\r', 1),
(230, 'Antarctica/Vostok\r', 1),
(231, 'Arctic/Longyearbyen\r', 1),
(232, 'Asia/Aden\r', 1),
(233, 'Asia/Almaty\r', 1),
(234, 'Asia/Amman\r', 1),
(235, 'Asia/Anadyr\r', 1),
(236, 'Asia/Aqtau\r', 1),
(237, 'Asia/Aqtobe\r', 1),
(238, 'Asia/Ashgabat\r', 1),
(239, 'Asia/Ashkhabad\r', 1),
(240, 'Asia/Baghdad\r', 1),
(241, 'Asia/Bahrain\r', 1),
(242, 'Asia/Baku\r', 1),
(243, 'Asia/Bangkok\r', 1),
(244, 'Asia/Beirut\r', 1),
(245, 'Asia/Bishkek\r', 1),
(246, 'Asia/Brunei\r', 1),
(247, 'Asia/Calcutta\r', 1),
(248, 'Asia/Choibalsan\r', 1),
(249, 'Asia/Chongqing\r', 1),
(250, 'Asia/Chungking\r', 1),
(251, 'Asia/Colombo\r', 1),
(252, 'Asia/Dacca\r', 1),
(253, 'Asia/Damascus\r', 1),
(254, 'Asia/Dhaka\r', 1),
(255, 'Asia/Dili\r', 1),
(256, 'Asia/Dubai\r', 1),
(257, 'Asia/Dushanbe\r', 1),
(258, 'Asia/Gaza\r', 1),
(259, 'Asia/Harbin\r', 1),
(260, 'Asia/Hebron\r', 1),
(261, 'Asia/Ho_Chi_Minh\r', 1),
(262, 'Asia/Hong_Kong\r', 1),
(263, 'Asia/Hovd\r', 1),
(264, 'Asia/Irkutsk\r', 1),
(265, 'Asia/Istanbul\r', 1),
(266, 'Asia/Jakarta\r', 1),
(267, 'Asia/Jayapura\r', 1),
(268, 'Asia/Jerusalem\r', 1),
(269, 'Asia/Kabul\r', 1),
(270, 'Asia/Kamchatka\r', 1),
(271, 'Asia/Karachi\r', 1),
(272, 'Asia/Kashgar\r', 1),
(273, 'Asia/Kathmandu\r', 1),
(274, 'Asia/Katmandu\r', 1),
(275, 'Asia/Kolkata\r', 1),
(276, 'Asia/Krasnoyarsk\r', 1),
(277, 'Asia/Kuala_Lumpur\r', 1),
(278, 'Asia/Kuching\r', 1),
(279, 'Asia/Kuwait\r', 1),
(280, 'Asia/Macao\r', 1),
(281, 'Asia/Macau\r', 1),
(282, 'Asia/Magadan\r', 1),
(283, 'Asia/Makassar\r', 1),
(284, 'Asia/Manila\r', 1),
(285, 'Asia/Muscat\r', 1),
(286, 'Asia/Nicosia\r', 1),
(287, 'Asia/Novokuznetsk\r', 1),
(288, 'Asia/Novosibirsk\r', 1),
(289, 'Asia/Omsk\r', 1),
(290, 'Asia/Oral\r', 1),
(291, 'Asia/Phnom_Penh\r', 1),
(292, 'Asia/Pontianak\r', 1),
(293, 'Asia/Pyongyang\r', 1),
(294, 'Asia/Qatar\r', 1),
(295, 'Asia/Qyzylorda\r', 1),
(296, 'Asia/Rangoon\r', 1),
(297, 'Asia/Riyadh\r', 1),
(298, 'Asia/Saigon\r', 1),
(299, 'Asia/Sakhalin\r', 1),
(300, 'Asia/Samarkand\r', 1),
(301, 'Asia/Seoul\r', 1),
(302, 'Asia/Shanghai\r', 1),
(303, 'Asia/Singapore\r', 1),
(304, 'Asia/Taipei\r', 1),
(305, 'Asia/Tashkent\r', 1),
(306, 'Asia/Tbilisi\r', 1),
(307, 'Asia/Tehran\r', 1),
(308, 'Asia/Tel_Aviv\r', 1),
(309, 'Asia/Thimbu\r', 1),
(310, 'Asia/Thimphu\r', 1),
(311, 'Asia/Tokyo\r', 1),
(312, 'Asia/Ujung_Pandang\r', 1),
(313, 'Asia/Ulaanbaatar\r', 1),
(314, 'Asia/Ulan_Bator\r', 1),
(315, 'Asia/Urumqi\r', 1),
(316, 'Asia/Vientiane\r', 1),
(317, 'Asia/Vladivostok\r', 1),
(318, 'Asia/Yakutsk\r', 1),
(319, 'Asia/Yekaterinburg\r', 1),
(320, 'Asia/Yerevan\r', 1),
(321, 'Atlantic/Azores\r', 1),
(322, 'Atlantic/Bermuda\r', 1),
(323, 'Atlantic/Canary\r', 1),
(324, 'Atlantic/Cape_Verde\r', 1),
(325, 'Atlantic/Faeroe\r', 1),
(326, 'Atlantic/Faroe\r', 1),
(327, 'Atlantic/Jan_Mayen\r', 1),
(328, 'Atlantic/Madeira\r', 1),
(329, 'Atlantic/Reykjavik\r', 1),
(330, 'Atlantic/South_Georgia\r', 1),
(331, 'Atlantic/St_Helena\r', 1),
(332, 'Atlantic/Stanley\r', 1),
(333, 'Australia/ACT\r', 1),
(334, 'Australia/Adelaide\r', 1),
(335, 'Australia/Brisbane\r', 1),
(336, 'Australia/Broken_Hill\r', 1),
(337, 'Australia/Canberra\r', 1),
(338, 'Australia/Currie\r', 1),
(339, 'Australia/Darwin\r', 1),
(340, 'Australia/Eucla\r', 1),
(341, 'Australia/Hobart\r', 1),
(342, 'Australia/LHI\r', 1),
(343, 'Australia/Lindeman\r', 1),
(344, 'Australia/Lord_Howe\r', 1),
(345, 'Australia/Melbourne\r', 1),
(346, 'Australia/North\r', 1),
(347, 'Australia/NSW\r', 1),
(348, 'Australia/Perth\r', 1),
(349, 'Australia/Queensland\r', 1),
(350, 'Australia/South\r', 1),
(351, 'Australia/Sydney\r', 1),
(352, 'Australia/Tasmania\r', 1),
(353, 'Australia/Victoria\r', 1),
(354, 'Australia/West\r', 1),
(355, 'Australia/Yancowinna\r', 1),
(356, 'Brazil/Acre\r', 1),
(357, 'Brazil/DeNoronha\r', 1),
(358, 'Brazil/East\r', 1),
(359, 'Brazil/West\r', 1),
(360, 'Canada/Atlantic\r', 1),
(361, 'Canada/Central\r', 1),
(362, 'Canada/Eastern\r', 1),
(363, 'Canada/East-Saskatchewan\r', 1),
(364, 'Canada/Mountain\r', 1),
(365, 'Canada/Newfoundland\r', 1),
(366, 'Canada/Pacific\r', 1),
(367, 'Canada/Saskatchewan\r', 1),
(368, 'Canada/Yukon\r', 1),
(369, 'CET\r', 1),
(370, 'Chile/Continental\r', 1),
(371, 'Chile/EasterIsland\r', 1),
(372, 'CST6CDT\r', 1),
(373, 'Cuba\r', 1),
(374, 'EET\r', 1),
(375, 'Egypt\r', 1),
(376, 'Eire\r', 1),
(377, 'EST\r', 1),
(378, 'EST5EDT\r', 1),
(379, 'Etc./GMT\r', 1),
(380, 'Etc./GMT+0\r', 1),
(381, 'Etc./UCT\r', 1),
(382, 'Etc./Universal\r', 1),
(383, 'Etc./UTC\r', 1),
(384, 'Etc./Zulu\r', 1),
(385, 'Europe/Amsterdam\r', 1),
(386, 'Europe/Andorra\r', 1),
(387, 'Europe/Athens\r', 1),
(388, 'Europe/Belfast\r', 1),
(389, 'Europe/Belgrade\r', 1),
(390, 'Europe/Berlin\r', 1),
(391, 'Europe/Bratislava\r', 1),
(392, 'Europe/Brussels\r', 1),
(393, 'Europe/Bucharest\r', 1),
(394, 'Europe/Budapest\r', 1),
(395, 'Europe/Chisinau\r', 1),
(396, 'Europe/Copenhagen\r', 1),
(397, 'Europe/Dublin\r', 1),
(398, 'Europe/Gibraltar\r', 1),
(399, 'Europe/Guernsey\r', 1),
(400, 'Europe/Helsinki\r', 1),
(401, 'Europe/Isle_of_Man\r', 1),
(402, 'Europe/Istanbul\r', 1),
(403, 'Europe/Jersey\r', 1),
(404, 'Europe/Kaliningrad\r', 1),
(405, 'Europe/Kiev\r', 1),
(406, 'Europe/Lisbon\r', 1),
(407, 'Europe/Ljubljana\r', 1),
(408, 'Europe/London\r', 1),
(409, 'Europe/Luxembourg\r', 1),
(410, 'Europe/Madrid\r', 1),
(411, 'Europe/Malta\r', 1),
(412, 'Europe/Mariehamn\r', 1),
(413, 'Europe/Minsk\r', 1),
(414, 'Europe/Monaco\r', 1),
(415, 'Europe/Moscow\r', 1),
(416, 'Europe/Nicosia\r', 1),
(417, 'Europe/Oslo\r', 1),
(418, 'Europe/Paris\r', 1),
(419, 'Europe/Podgorica\r', 1),
(420, 'Europe/Prague\r', 1),
(421, 'Europe/Riga\r', 1),
(422, 'Europe/Rome\r', 1),
(423, 'Europe/Samara\r', 1),
(424, 'Europe/San_Marino\r', 1),
(425, 'Europe/Sarajevo\r', 1),
(426, 'Europe/Simferopol\r', 1),
(427, 'Europe/Skopje\r', 1),
(428, 'Europe/Sofia\r', 1),
(429, 'Europe/Stockholm\r', 1),
(430, 'Europe/Tallinn\r', 1),
(431, 'Europe/Tirane\r', 1),
(432, 'Europe/Tiraspol\r', 1),
(433, 'Europe/Uzhgorod\r', 1),
(434, 'Europe/Vaduz\r', 1),
(435, 'Europe/Vatican\r', 1),
(436, 'Europe/Vienna\r', 1),
(437, 'Europe/Vilnius\r', 1),
(438, 'Europe/Volgograd\r', 1),
(439, 'Europe/Warsaw\r', 1),
(440, 'Europe/Zagreb\r', 1),
(441, 'Europe/Zaporozhye\r', 1),
(442, 'Europe/Zurich\r', 1),
(443, 'GB\r', 1),
(444, 'GB-Eire\r', 1),
(445, 'GMT\r', 1),
(446, 'GMT+0\r', 1),
(447, 'GMT0\r', 1),
(448, 'GMT-0\r', 1),
(449, 'Greenwich\r', 1),
(450, 'Hong Kong\r', 1),
(451, 'HST\r', 1),
(452, 'Iceland\r', 1),
(453, 'Indian/Antananarivo\r', 1),
(454, 'Indian/Chagos\r', 1),
(455, 'Indian/Christmas\r', 1),
(456, 'Indian/Cocos\r', 1),
(457, 'Indian/Comoro\r', 1),
(458, 'Indian/Kerguelen\r', 1),
(459, 'Indian/Mahe\r', 1),
(460, 'Indian/Maldives\r', 1),
(461, 'Indian/Mauritius\r', 1),
(462, 'Indian/Mayotte\r', 1),
(463, 'Indian/Reunion\r', 1),
(464, 'Iran\r', 1),
(465, 'Israel\r', 1),
(466, 'Jamaica\r', 1),
(467, 'Japan\r', 1),
(468, 'JST-9\r', 1),
(469, 'Kwajalein\r', 1),
(470, 'Libya\r', 1),
(471, 'MET\r', 1),
(472, 'Mexico/BajaNorte\r', 1),
(473, 'Mexico/BajaSur\r', 1),
(474, 'Mexico/General\r', 1),
(475, 'MST\r', 1),
(476, 'MST7MDT\r', 1),
(477, 'Navajo\r', 1),
(478, 'NZ\r', 1),
(479, 'NZ-CHAT\r', 1),
(480, 'Pacific/Apia\r', 1),
(481, 'Pacific/Auckland\r', 1),
(482, 'Pacific/Chatham\r', 1),
(483, 'Pacific/Chuuk\r', 1),
(484, 'Pacific/Easter\r', 1),
(485, 'Pacific/Efate\r', 1),
(486, 'Pacific/Enderbury\r', 1),
(487, 'Pacific/Fakaofo\r', 1),
(488, 'Pacific/Fiji\r', 1),
(489, 'Pacific/Funafuti\r', 1),
(490, 'Pacific/Galapagos\r', 1),
(491, 'Pacific/Gambier\r', 1),
(492, 'Pacific/Guadalcanal\r', 1),
(493, 'Pacific/Guam\r', 1),
(494, 'Pacific/Honolulu\r', 1),
(495, 'Pacific/Johnston\r', 1),
(496, 'Pacific/Kiritimati\r', 1),
(497, 'Pacific/Kosrae\r', 1),
(498, 'Pacific/Kwajalein\r', 1),
(499, 'Pacific/Majuro\r', 1),
(500, 'Pacific/Marquesas\r', 1),
(501, 'Pacific/Midway\r', 1),
(502, 'Pacific/Nauru\r', 1),
(503, 'Pacific/Niue\r', 1),
(504, 'Pacific/Norfolk\r', 1),
(505, 'Pacific/Noumea\r', 1),
(506, 'Pacific/Pago_Pago\r', 1),
(507, 'Pacific/Palau\r', 1),
(508, 'Pacific/Pitcairn\r', 1),
(509, 'Pacific/Pohnpei\r', 1),
(510, 'Pacific/Ponape\r', 1),
(511, 'Pacific/Port_Moresby\r', 1),
(512, 'Pacific/Rarotonga\r', 1),
(513, 'Pacific/Saipan\r', 1),
(514, 'Pacific/Samoa\r', 1),
(515, 'Pacific/Tahiti\r', 1),
(516, 'Pacific/Tarawa\r', 1),
(517, 'Pacific/Tongatapu\r', 1),
(518, 'Pacific/Truk\r', 1),
(519, 'Pacific/Wake\r', 1),
(520, 'Pacific/Wallis\r', 1),
(521, 'Pacific/Yap\r', 1),
(522, 'Poland\r', 1),
(523, 'Portugal\r', 1),
(524, 'PRC\r', 1),
(525, 'PST8PDT\r', 1),
(526, 'ROC\r', 1),
(527, 'ROK\r', 1),
(528, 'Singapore\r', 1),
(529, 'Turkey\r', 1),
(530, 'UCT\r', 1),
(531, 'Universal\r', 1),
(532, 'US/Alaska\r', 1),
(533, 'US/Aleutian\r', 1),
(534, 'US/Arizona\r', 1),
(535, 'US/Central\r', 1),
(536, 'US/Eastern\r', 1),
(537, 'US/East-Indiana\r', 1),
(538, 'US/Hawaii\r', 1),
(539, 'US/Indiana-Starke\r', 1),
(540, 'US/Michigan\r', 1),
(541, 'US/Mountain\r', 1),
(542, 'US/Pacific\r', 1),
(543, 'US/Pacific-New\r', 1),
(544, 'US/Samoa\r', 1),
(545, 'UTC\r', 1),
(546, 'WET\r', 1),
(547, 'W-SU\r', 1),
(548, 'Zulu\r', 1);

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

--
-- Table structure for table `db_units`
--

CREATE TABLE `db_units` (
  `id` int(50) NOT NULL,
  `unit_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int(5) DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_units`
--

INSERT INTO `db_units` (`id`, `unit_name`, `description`, `company_id`, `status`) VALUES
(16, 'N/A', '', NULL, 1),
(17, 'Unit', '', NULL, 1),
(18, 'LB', 'Pound', NULL, 1),
(19, 'pies', '', NULL, 1),
(20, 'sdfsdf', 'sdf', NULL, 1),
(21, 'Unite Name Modal Test', 'Tst modal uni desc', NULL, 1),
(22, 'dsfsdfsdfsdf', '', NULL, 1),
(23, 'test', '', NULL, 1),
(24, 'Unit Name', 'Description', NULL, 1),
(25, 'Unit Name*', 'Description', NULL, 1),
(26, 'dddddddddddddddddd', 'eeeeeeeeeeeeeeeeeeeee', NULL, 1);

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

--
-- Table structure for table `db_users`
--

CREATE TABLE `db_users` (
  `id` int(50) NOT NULL,
  `username` varchar(1350) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` blob DEFAULT NULL,
  `member_of` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `firstname` varchar(1350) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lastname` varchar(1350) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(405) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(1350) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo` blob DEFAULT NULL,
  `gender` varchar(1350) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `country` varchar(1620) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(1350) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(1620) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` blob DEFAULT NULL,
  `postcode` varchar(270) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role_name` varchar(1350) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `role_id` int(5) DEFAULT NULL,
  `profile_picture` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `created_time` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_ip` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `system_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int(5) DEFAULT NULL,
  `status` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_users`
--

INSERT INTO `db_users` (`id`, `username`, `password`, `member_of`, `firstname`, `lastname`, `mobile`, `email`, `photo`, `gender`, `dob`, `country`, `state`, `city`, `address`, `postcode`, `role_name`, `role_id`, `profile_picture`, `created_date`, `created_time`, `created_by`, `system_ip`, `system_name`, `company_id`, `status`) VALUES
(1, 'admin', 0x6531306164633339343962613539616262653536653035376632306638383365, '', NULL, NULL, '4847445932', 'fake@fake.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '', '2018-11-27', '::1', NULL, NULL, NULL, 1, 1);

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

--
-- Table structure for table `db_warehouse`
--

CREATE TABLE `db_warehouse` (
  `id` int(50) NOT NULL,
  `warehouse_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `db_warehouse`
--

INSERT INTO `db_warehouse` (`id`, `warehouse_name`, `mobile`, `email`, `status`) VALUES
(1, 'winsoftttt', 'ertet', 'tst@gmail.com', 1),
(3, 'tetestesaasdfsdf', '03315568689', 'sh@gmail.com', 1),
(5, '02 02', '923315068670', 'mudassar.3278.it@gmail.com', 1);

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

--
-- Table structure for table `entitlements`
--

CREATE TABLE `entitlements` (
  `id` int(11) NOT NULL,
  `company_name` varchar(255) NOT NULL,
  `entitlements_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ci_sessions`
--
ALTER TABLE `ci_sessions`
  ADD KEY `ci_sessions_timestamp` (`timestamp`);

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `db_customer_payments`
--
ALTER TABLE `db_customer_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_id` (`customer_id`),
  ADD KEY `salespayment_id` (`salespayment_id`);

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

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

--
-- Indexes for table `db_hold`
--
ALTER TABLE `db_hold`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_id` (`customer_id`);

--
-- Indexes for table `db_holditems`
--
ALTER TABLE `db_holditems`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sales_id` (`hold_id`),
  ADD KEY `item_id` (`item_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `db_sitesettings`
--
ALTER TABLE `db_sitesettings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `currencysymbol_id` (`currencysymbol_id`);

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

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

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

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

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

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

--
-- Indexes for table `db_supplier_payments`
--
ALTER TABLE `db_supplier_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `supplier_id` (`supplier_id`),
  ADD KEY `purchasepayment_id` (`purchasepayment_id`);

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for table `db_brands`
--
ALTER TABLE `db_brands`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85;

--
-- AUTO_INCREMENT for table `db_category`
--
ALTER TABLE `db_category`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `db_cobpayments`
--
ALTER TABLE `db_cobpayments`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `db_company`
--
ALTER TABLE `db_company`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `db_country`
--
ALTER TABLE `db_country`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `db_currency`
--
ALTER TABLE `db_currency`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;

--
-- AUTO_INCREMENT for table `db_customers`
--
ALTER TABLE `db_customers`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `db_customer_payments`
--
ALTER TABLE `db_customer_payments`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=364;

--
-- AUTO_INCREMENT for table `db_expense`
--
ALTER TABLE `db_expense`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `db_expense_category`
--
ALTER TABLE `db_expense_category`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `db_hold`
--
ALTER TABLE `db_hold`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `db_holditems`
--
ALTER TABLE `db_holditems`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `db_items`
--
ALTER TABLE `db_items`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=195;

--
-- AUTO_INCREMENT for table `db_languages`
--
ALTER TABLE `db_languages`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

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

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

--
-- AUTO_INCREMENT for table `db_paymenttypes`
--
ALTER TABLE `db_paymenttypes`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `db_permissions`
--
ALTER TABLE `db_permissions`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=234;

--
-- AUTO_INCREMENT for table `db_purchase`
--
ALTER TABLE `db_purchase`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `db_purchaseitemsreturn`
--
ALTER TABLE `db_purchaseitemsreturn`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `db_purchasepayments`
--
ALTER TABLE `db_purchasepayments`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `db_purchasepaymentsreturn`
--
ALTER TABLE `db_purchasepaymentsreturn`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `db_purchasereturn`
--
ALTER TABLE `db_purchasereturn`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `db_roles`
--
ALTER TABLE `db_roles`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `db_sales`
--
ALTER TABLE `db_sales`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `db_salesitems`
--
ALTER TABLE `db_salesitems`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `db_salesitemsreturn`
--
ALTER TABLE `db_salesitemsreturn`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `db_salespayments`
--
ALTER TABLE `db_salespayments`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `db_salespaymentsreturn`
--
ALTER TABLE `db_salespaymentsreturn`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `db_salesreturn`
--
ALTER TABLE `db_salesreturn`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `db_sitesettings`
--
ALTER TABLE `db_sitesettings`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `db_smsapi`
--
ALTER TABLE `db_smsapi`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=150;

--
-- AUTO_INCREMENT for table `db_smstemplates`
--
ALTER TABLE `db_smstemplates`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `db_sobpayments`
--
ALTER TABLE `db_sobpayments`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `db_states`
--
ALTER TABLE `db_states`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

--
-- AUTO_INCREMENT for table `db_stockentry`
--
ALTER TABLE `db_stockentry`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=242;

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

--
-- AUTO_INCREMENT for table `db_supplier_payments`
--
ALTER TABLE `db_supplier_payments`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=293;

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

--
-- AUTO_INCREMENT for table `db_timezone`
--
ALTER TABLE `db_timezone`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=549;

--
-- AUTO_INCREMENT for table `db_units`
--
ALTER TABLE `db_units`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `db_users`
--
ALTER TABLE `db_users`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `db_warehouse`
--
ALTER TABLE `db_warehouse`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `entitlements`
--
ALTER TABLE `entitlements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `db_customer_payments`
--
ALTER TABLE `db_customer_payments`
  ADD CONSTRAINT `db_customer_payments_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `db_customers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `db_customer_payments_ibfk_2` FOREIGN KEY (`salespayment_id`) REFERENCES `db_salespayments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `db_hold`
--
ALTER TABLE `db_hold`
  ADD CONSTRAINT `db_hold_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `db_customers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `db_holditems`
--
ALTER TABLE `db_holditems`
  ADD CONSTRAINT `db_holditems_ibfk_2` FOREIGN KEY (`hold_id`) REFERENCES `db_hold` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `db_holditems_ibfk_3` FOREIGN KEY (`item_id`) REFERENCES `db_items` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `db_supplier_payments`
--
ALTER TABLE `db_supplier_payments`
  ADD CONSTRAINT `db_supplier_payments_ibfk_1` FOREIGN KEY (`supplier_id`) REFERENCES `db_suppliers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `db_supplier_payments_ibfk_2` FOREIGN KEY (`purchasepayment_id`) REFERENCES `db_purchasepayments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

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