-- phpMyAdmin SQL Dump
-- version 5.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 30, 2020 at 08:41 AM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.4.3

SET FOREIGN_KEY_CHECKS=0;
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 */;

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Description` text DEFAULT NULL,
  `BackColor` int(11) NOT NULL,
  `ForeColor` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `Name`, `Description`, `BackColor`, `ForeColor`) VALUES
(1, 'Grocery', 'Genral Grocery Items.', -8355648, -1),
(2, 'Test', 'N/A', -13027259, -1),
(3, 'Test 2', 'N/A', -13027259, -1),
(4, 'MEN', 'N/A', -13027259, -1);

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

--
-- Table structure for table `company`
--

CREATE TABLE `company` (
  `id` int(11) NOT NULL,
  `CompanyName` varchar(250) NOT NULL,
  `AddressLine1` varchar(250) DEFAULT NULL,
  `AddressLine2` varchar(250) DEFAULT NULL,
  `AddressLine3` varchar(250) DEFAULT NULL,
  `ContactNo` varchar(100) DEFAULT NULL,
  `Email` varchar(100) DEFAULT NULL,
  `LicenseNo` varchar(100) DEFAULT NULL,
  `Website` varchar(100) DEFAULT NULL,
  `CurrencyCode` varchar(10) DEFAULT NULL,
  `Currency` varchar(100) DEFAULT NULL,
  `Logo` longblob DEFAULT NULL,
  `FooterMessage` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `company`
--

INSERT INTO `company` (`id`, `CompanyName`, `AddressLine1`, `AddressLine2`, `AddressLine3`, `ContactNo`, `Email`, `LicenseNo`, `Website`, `CurrencyCode`, `Currency`, `Logo`, `FooterMessage`) VALUES
(1, 'Isim Software', 'Test', 'City, 431005', 'Place, Country', '+44 1234566789', 'info@isimsoftware.com', '', 'http://isimsoftware.com/', 'INR', 'Countryn Rup', NULL, 'Thanks for Shopping...');

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

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

CREATE TABLE `customers` (
  `id` int(11) NOT NULL,
  `CustomerId` varchar(10) NOT NULL,
  `Name` varchar(100) NOT NULL,
  `MobileNo` varchar(20) NOT NULL,
  `EmailId` varchar(100) DEFAULT NULL,
  `AddressLine1` varchar(250) DEFAULT NULL,
  `AddressLine2` varchar(250) DEFAULT NULL,
  `AddressLine3` varchar(250) DEFAULT NULL,
  `Remark` text DEFAULT NULL,
  `Outstanding` decimal(10,2) NOT NULL,
  `TotalPaid` decimal(10,2) NOT NULL,
  `CustomerType` varchar(100) NOT NULL,
  `Discount` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `customers` (`id`, `CustomerId`, `Name`, `MobileNo`, `EmailId`, `AddressLine1`, `AddressLine2`, `AddressLine3`, `Remark`, `Outstanding`, `TotalPaid`, `CustomerType`, `Discount`) VALUES
(1, 'SUP-00001', 'Test Test', '+44 1234566789', 'info@isimsoftware.com', 'City', '.', '', 'N/A', '565.00', '110.00', 'Weekly', '10.00'),
(2, 'CUS-00002', 'Test Customer', '+441234566789', 'abc@gmail.com', 'Aurangabaf', '', '', '', '80.00', '0.00', 'Walk-In', '0.00'),
(3, 'CUS-00003', 'Test User 3', '1234566789', 'info@isimsoftware.com', 'City', 'dd', '', '', '130.00', '0.00', 'Monthly', '0.00'),
(4, 'CUS-00004', 'Test Customer 1', '+44 1234566789', 'info@isimsoftware.com', 'c', 'Place', 'Country', 'Demo Customer', '100.00', '0.00', 'Monthly', '5.00'),
(5, 'CUS-00005', 'Test Customer 2', '+44 9049049336', 'info@isimsoftware.com', 'City', 'Place', 'Country', 'Demo Customer', '0.00', '0.00', 'Weekly', '0.00'),
(6, 'CUS-00006', 'Test Customer 3', '+44 8446060608', 'info@isimsoftware.com', 'City', 'Place', 'Country', 'Demo Customer', '0.00', '0.00', 'Walk-In', '0.00'),
(7, 'CUS-00001', 'Test Customer 1', '+44 1234566789', 'info@isimsoftware.com', 'City', 'Place', 'Country', 'Demo Customer', '100.00', '0.00', 'Monthly', '5.00'),
(8, 'CUS-00001', 'Test Customer 2', '+44 9049049336', 'info@isimsoftware.com', 'City', 'Place', 'Country', 'Demo Customer', '0.00', '0.00', 'Weekly', '0.00'),
(9, 'CUS-00001', 'Test Customer 3', '+44 8446060608', 'info@isimsoftware.com', 'City', 'Place', 'Country', 'Demo Customer', '0.00', '0.00', 'Walk-In', '0.00'),
(10, 'CUS-00010', 'Test Customer 1', '+44 1234566789', 'info@isimsoftware.com', 'City', 'Place', 'Country', 'Demo Customer', '100.00', '0.00', 'Monthly', '5.00'),
(11, 'CUS-00011', 'Test Customer 2', '+44 9049049336', 'info@isimsoftware.com', 'City', 'Place', 'Country', 'Demo Customer', '0.00', '0.00', 'Weekly', '0.00'),
(12, 'CUS-00012', 'Test Customer 3', '+44 8446060608', 'info@isimsoftware.com', 'City', 'Place', 'Country', 'Demo Customer', '0.00', '0.00', 'Walk-In', '0.00'),
(13, 'CUS-00013', 'Test Customer 1', '+44 1234566789', 'info@isimsoftware.com', 'City', 'Place', 'Country', 'Demo Customer', '98.90', '60.00', 'Monthly', '5.00'),
(14, 'CUS-00014', 'Test Customer 2', '+44 9049049336', 'info@isimsoftware.com', 'City', 'Place', 'Country', 'Demo Customer', '18.00', '50.00', 'Weekly', '0.00'),
(15, 'CUS-00015', 'Test Customer 3', '+44 8446060608', 'info@isimsoftware.com', 'City', 'Place', 'Country', 'Demo Customer', '0.00', '0.00', 'Walk-In', '0.00');

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

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

CREATE TABLE `expenses` (
  `id` int(11) NOT NULL,
  `TransactionID` varchar(50) NOT NULL,
  `TransactionDate` datetime NOT NULL,
  `PaymentMode` varchar(50) NOT NULL,
  `Creditor` varchar(250) NOT NULL,
  `Title` varchar(250) DEFAULT NULL,
  `Remark` mediumtext DEFAULT NULL,
  `Amount` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `expenses` (`id`, `TransactionID`, `TransactionDate`, `PaymentMode`, `Creditor`, `Title`, `Remark`, `Amount`) VALUES
(1, 'EXP-00001', '2020-02-16 22:31:53', 'CHEQUE', 'Test', 'Refund', 'na', '10.00'),
(2, 'EXP-00002', '2020-02-16 22:37:59', 'CASH', 'Test', 'Another Refund', 'no reason', '20.00'),
(3, 'EXP-00003', '2020-03-25 14:40:06', 'CASH', 'Petrol', 'Fuel', '', '150.00');

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

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

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `OrderId` varchar(10) NOT NULL,
  `CustomerId` int(11) NOT NULL,
  `OrderDate` datetime NOT NULL,
  `DeliveryDate` datetime NOT NULL,
  `Remark` mediumtext DEFAULT NULL,
  `Amount` decimal(10,2) NOT NULL,
  `DiscountPer` decimal(10,2) DEFAULT NULL,
  `DiscountAmount` decimal(10,2) DEFAULT NULL,
  `FinalAmount` decimal(10,2) NOT NULL,
  `Status` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `OrderId`, `CustomerId`, `OrderDate`, `DeliveryDate`, `Remark`, `Amount`, `DiscountPer`, `DiscountAmount`, `FinalAmount`, `Status`) VALUES
(2, 'ORD-00002', 2, '2020-02-06 03:07:31', '2020-02-06 03:07:31', '', '120.00', '0.00', '0.00', '120.00', 'Delivered'),
(3, 'ORD-00003', 3, '2020-02-06 03:09:07', '2020-02-11 03:09:07', '', '120.00', '0.00', '0.00', '120.00', 'Delivered'),
(4, 'ORD-00004', 3, '2020-02-06 03:11:07', '2020-02-10 03:11:07', '', '120.00', '0.00', '0.00', '120.00', 'Delivered'),
(5, 'ORD-00005', 3, '2020-02-06 06:29:53', '2020-02-06 06:29:53', '', '70.00', '0.00', '0.00', '70.00', 'Delivered'),
(6, 'ORD-00006', 2, '2020-02-13 12:37:22', '2020-02-15 12:37:22', '', '20.00', '0.00', '0.00', '20.00', 'Washed'),
(7, 'ORD-00007', 2, '2020-02-13 12:40:21', '2020-02-16 12:40:21', '', '20.00', '0.00', '0.00', '20.00', 'Printed'),
(8, 'ORD-00008', 3, '2020-02-13 18:50:30', '2020-02-13 18:50:30', '', '90.00', '0.00', '0.00', '90.00', 'Printed'),
(9, 'ORD-00009', 2, '2020-02-14 21:49:31', '2020-02-17 21:49:31', '', '120.00', '5.00', '6.00', '114.00', 'Printed'),
(10, 'ORD-00010', 2, '2020-02-14 21:54:03', '2020-02-14 21:54:03', '', '20.00', '0.00', '0.00', '20.00', 'Pending'),
(11, 'ORD-00011', 3, '2020-02-14 21:54:59', '2020-02-14 21:54:59', '', '50.00', '0.00', '0.00', '50.00', 'Printed'),
(12, 'ORD-00012', 3, '2020-02-14 21:59:57', '2020-02-16 21:59:57', '', '50.00', '0.00', '5.00', '45.00', 'Pending'),
(13, 'ORD-00013', 3, '2020-02-14 22:07:01', '2020-02-14 22:07:01', '', '50.00', '0.00', '0.00', '50.00', 'Printed'),
(14, 'ORD-00014', 3, '2020-02-14 22:12:28', '2020-02-14 22:12:28', '', '70.00', '0.00', '0.00', '70.00', 'Printed'),
(15, 'ORD-00015', 14, '2020-02-18 15:52:12', '2020-02-18 15:52:12', '', '50.00', '0.00', '0.00', '50.00', 'Pending'),
(16, 'ORD-00016', 14, '2020-02-18 19:34:32', '2020-02-20 19:34:32', '', '18.00', '0.00', '0.00', '18.00', 'Printed'),
(17, 'ORD-00017', 13, '2020-02-24 19:41:26', '2020-02-26 19:41:26', '', '62.00', '5.00', '3.10', '58.90', 'Printed'),
(18, 'ORD-00018', 1, '2020-03-25 14:39:33', '2020-03-27 14:39:33', '', '100.00', '10.00', '10.00', '90.00', 'Pending'),
(19, 'ORD-00019', 1, '2020-03-30 10:30:49', '2020-04-01 10:30:49', 'test', '650.00', '10.00', '65.00', '585.00', 'Pending');

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

--
-- Table structure for table `orders_items`
--

CREATE TABLE `orders_items` (
  `id` int(11) NOT NULL,
  `OrderId` int(11) NOT NULL,
  `ProductId` int(11) NOT NULL,
  `ProductName` varchar(250) NOT NULL,
  `Price` decimal(10,2) NOT NULL,
  `Quantity` decimal(10,2) NOT NULL,
  `ProductTotal` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `orders_items`
--

INSERT INTO `orders_items` (`id`, `OrderId`, `ProductId`, `ProductName`, `Price`, `Quantity`, `ProductTotal`) VALUES
(1, 4, 1, 'Test Product', '20.00', '1.00', '20.00'),
(2, 4, 2, 'Test Product 2', '50.00', '1.00', '50.00'),
(3, 4, 2, 'Test Product 2', '50.00', '1.00', '50.00'),
(4, 5, 1, 'Test Product', '20.00', '1.00', '20.00'),
(5, 5, 2, 'Test Product 2', '50.00', '1.00', '50.00'),
(6, 6, 1, 'Test Product', '20.00', '1.00', '20.00'),
(7, 7, 1, 'Test Product', '20.00', '1.00', '20.00'),
(8, 8, 1, 'Test Product', '20.00', '2.00', '40.00'),
(9, 8, 2, 'Test Product 2', '50.00', '1.00', '50.00'),
(10, 9, 1, 'Test Product', '20.00', '1.00', '20.00'),
(11, 9, 2, 'Test Product 2', '50.00', '2.00', '100.00'),
(12, 10, 1, 'Test Product', '20.00', '1.00', '20.00'),
(13, 11, 2, 'Test Product 2', '50.00', '1.00', '50.00'),
(14, 12, 2, 'Test Product 2', '50.00', '1.00', '50.00'),
(15, 13, 2, 'Test Product 2', '50.00', '1.00', '50.00'),
(16, 14, 1, 'Test Product', '20.00', '1.00', '20.00'),
(17, 14, 2, 'Test Product 2', '50.00', '1.00', '50.00'),
(18, 15, 2, 'Test Product 2', '50.00', '1.00', '50.00'),
(19, 16, 54, 'Track Pant (Only Iron)', '8.00', '1.00', '8.00'),
(20, 16, 55, 'Track Pant (Steam Iron)', '10.00', '1.00', '10.00'),
(21, 17, 10, 'Starch Shirt (Only Iron)', '15.00', '2.00', '30.00'),
(22, 17, 6, 'Shirt (Only Iron)', '8.00', '1.00', '8.00'),
(23, 17, 14, 'T-Shirt (Only Iron)', '8.00', '3.00', '24.00'),
(24, 18, 3, 'Test Product 3', '100.00', '1.00', '100.00'),
(25, 19, 1, 'Test Product 3', '20.00', '1.00', '20.00'),
(26, 19, 11, 'Starch Shirt (Steam Iron)', '0.00', '1.00', '0.00'),
(27, 19, 83, 'Waiscoat (Steam Iron)', '30.00', '1.00', '30.00'),
(28, 19, 79, 'Blazer complete(Steam Iron)', '120.00', '5.00', '600.00');

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

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

CREATE TABLE `payments` (
  `id` int(11) NOT NULL,
  `TransactionID` varchar(20) NOT NULL,
  `CustomerId` int(11) NOT NULL,
  `Date` datetime NOT NULL,
  `PaymentMethod` varchar(250) NOT NULL,
  `Amount` decimal(10,2) NOT NULL,
  `Remarks` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`id`, `TransactionID`, `CustomerId`, `Date`, `PaymentMethod`, `Amount`, `Remarks`) VALUES
(1, 'PAY-00001', 1, '2020-02-01 19:11:44', 'CASH', '50.00', 'test payment'),
(2, 'PAY-00002', 1, '2020-02-03 18:17:45', 'CASH', '20.00', ''),
(3, 'PAY-00003', 3, '2020-02-06 06:30:39', 'CASH', '100.00', ''),
(5, 'PAY-00004', 2, '2020-02-13 13:05:04', 'CASH', '10.00', ''),
(6, 'PAY-00006', 2, '2020-02-13 13:27:15', 'CHEQUE', '20.00', ''),
(7, 'PAY-00007', 3, '2020-02-13 18:52:00', 'ONLINE TRANSFER', '50.00', ''),
(8, 'PAY-00008', 3, '2020-02-14 22:38:35', 'ONLINE TRANSFER', '45.00', ''),
(9, 'PAY-00009', 2, '2020-02-14 23:46:08', 'CHEQUE', '40.00', ''),
(10, 'PAY-00010', 2, '2020-02-14 23:52:53', 'ONLINE TRANSFER', '4.00', ''),
(11, 'PAY-00011', 3, '2020-02-14 23:53:42', 'CASH', '10.00', ''),
(12, 'PAY-00012', 3, '2020-02-14 23:55:50', 'ONLINE TRANSFER', '10.00', ''),
(13, 'PAY-00013', 3, '2020-02-15 00:08:30', 'CASH', '50.00', ''),
(14, 'PAY-00014', 2, '2020-02-15 00:24:33', 'CASH', '20.00', ''),
(15, 'PAY-00015', 14, '2020-02-18 15:52:36', 'ONLINE TRANSFER', '50.00', ''),
(16, 'PAY-00016', 13, '2020-02-18 17:33:56', 'CHEQUE', '10.00', ''),
(17, 'PAY-00017', 13, '2020-02-24 19:42:07', 'CASH', '50.00', 'test'),
(18, 'PAY-00018', 1, '2020-03-30 10:33:07', 'CASH', '110.00', 'test');

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

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

CREATE TABLE `payment_methods` (
  `id` int(11) NOT NULL,
  `Name` varchar(250) NOT NULL,
  `Description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `Name`, `Description`) VALUES
(1, 'Cash', 'Cash Payments.');

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

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

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `ProductCode` varchar(20) NOT NULL,
  `Barcode` varchar(20) NOT NULL,
  `Name` varchar(100) NOT NULL,
  `CategoryName` varchar(50) NOT NULL,
  `SubCategory` varchar(50) NOT NULL,
  `Description` text DEFAULT NULL,
  `SaleRate` decimal(10,2) NOT NULL,
  `Status` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `products` (`id`, `ProductCode`, `Barcode`, `Name`, `CategoryName`, `SubCategory`, `Description`, `SaleRate`, `Status`) VALUES
(1, 'PID-00001', '100001', 'Test Product 3', 'Grocery', 'KG', 'Test Product', '20.00', 'Active'),
(2, 'PID-00002', '100002', 'Test Product 2', 'Grocery', 'KG', 'Test Product 2', '50.00', 'Active'),
(3, 'PID-00003', '100003', 'Test Product 3', 'Test', 'Test Sub', 'Product Description', '100.00', 'Active'),
(4, 'PID-00004', '100004', 'Test Product 3', 'Test 2', 'Test Sub', 'Product Description', '50.00', 'Active'),
(5, 'PID-00005', '100005', 'Test Product 3', 'Test', 'Test Sub 1', 'Product Description', '20.00', 'InActive'),
(6, 'PID-00006', '100006', 'Shirt (Only Iron)', 'MEN', 'Only Iron', '', '8.00', 'Active'),
(7, 'PID-00007', '100007', 'Shirt (Steam Iron)', 'MEN', 'Steam Iron', '', '10.00', 'Active'),
(8, 'PID-00008', '100008', 'Shirt (Iron+Wash)', 'MEN', 'Iron + Wash', '', '30.00', 'Active'),
(9, 'PID-00009', '100009', 'Shirt (Dry Clean)', 'MEN', 'Dry Clean', '', '50.00', 'Active'),
(10, 'PID-00010', '100010', 'Starch Shirt (Only Iron)', 'MEN', 'Only Iron', '', '15.00', 'Active'),
(11, 'PID-00011', '100011', 'Starch Shirt (Steam Iron)', 'MEN', 'Steam Iron', '', '0.00', 'Active'),
(12, 'PID-00012', '100012', 'Starch Shirt (Iron+Wash)', 'MEN', 'Iron + Wash', '', '50.00', 'Active'),
(13, 'PID-00013', '100013', 'Starch Shirt (Dry Clean)', 'MEN', 'Dry Clean', '', '0.00', 'Active'),
(14, 'PID-00014', '100014', 'T-Shirt (Only Iron)', 'MEN', 'Only Iron', '', '8.00', 'Active'),
(15, 'PID-00015', '100015', 'T-Shirt (Steam Iron)', 'MEN', 'Steam Iron', '', '10.00', 'Active'),
(16, 'PID-00016', '100016', 'T-Shirt (Iron+Wash)', 'MEN', 'Iron + Wash', '', '30.00', 'Active'),
(17, 'PID-00017', '100017', 'T-Shirt (Dry Clean)', 'MEN', 'Dry Clean', '', '40.00', 'Active'),
(23, 'PID-00023', '100023', 'Sweater (Steam Iron)', 'MEN', 'Steam Iron', '', '15.00', 'Active'),
(54, 'PID-00054', '100054', 'Track Pant (Only Iron)', 'MEN', 'Only Iron', '', '8.00', 'Active'),
(55, 'PID-00055', '100055', 'Track Pant (Steam Iron)', 'MEN', 'Steam Iron', '', '10.00', 'Active'),
(79, 'PID-00079', '100079', 'Blazer complete(Steam Iron)', 'MEN', 'Steam Iron', '', '120.00', 'Active'),
(83, 'PID-00083', '100083', 'Waiscoat (Steam Iron)', 'MEN', 'Steam Iron', '', '30.00', 'Active');

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

--
-- Table structure for table `product_style`
--

CREATE TABLE `product_style` (
  `id` int(11) NOT NULL,
  `ProductId` int(11) NOT NULL,
  `ProductImage` varchar(250) NOT NULL,
  `BorderColor` int(11) NOT NULL,
  `BackColor` int(11) NOT NULL,
  `ForeColor` int(11) NOT NULL,
  `MouseDownColor` int(11) NOT NULL,
  `MouseOverColor` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `product_style`
--

INSERT INTO `product_style` (`id`, `ProductId`, `ProductImage`, `BorderColor`, `BackColor`, `ForeColor`, `MouseDownColor`, `MouseOverColor`) VALUES
(1, 1, '', -29696, -11513736, -1, -11513736, -11513751),
(2, 2, '', -29696, -11513736, -1, -11513736, -11513751),
(3, 3, '', -29696, -11513736, -1, -11513736, -11513751),
(4, 4, '', -29696, -11513736, -1, -11513736, -11513751),
(5, 5, '', -29696, -11513736, -1, -11513736, -11513751),
(6, 6, '', -29696, -11513736, -1, -11513736, -11513751),
(7, 7, '', -29696, -11513736, -1, -11513736, -11513751),
(8, 8, '', -29696, -11513736, -1, -11513736, -11513751),
(9, 9, '', -29696, -11513736, -1, -11513736, -11513751),
(10, 10, '', -29696, -11513736, -1, -11513736, -11513751),
(11, 11, '', -29696, -11513736, -1, -11513736, -11513751),
(12, 12, '', -29696, -11513736, -1, -11513736, -11513751),
(13, 13, '', -29696, -11513736, -1, -11513736, -11513751),
(14, 14, '', -29696, -11513736, -1, -11513736, -11513751),
(15, 15, '', -29696, -11513736, -1, -11513736, -11513751),
(16, 16, '', -29696, -11513736, -1, -11513736, -11513751),
(17, 17, '', -29696, -11513736, -1, -11513736, -11513751),
(23, 23, '', -29696, -11513736, -1, -11513736, -11513751),
(54, 54, '', -29696, -11513736, -1, -11513736, -11513751),
(55, 55, '', -29696, -11513736, -1, -11513736, -11513751),
(79, 79, '', -29696, -11513736, -1, -11513736, -11513751),
(83, 83, '', -29696, -11513736, -1, -11513736, -11513751);

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

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

CREATE TABLE `purchases` (
  `id` int(11) NOT NULL,
  `InvoiceNo` varchar(10) NOT NULL,
  `InvoiceDate` datetime NOT NULL,
  `PaymentMode` varchar(100) NOT NULL,
  `PaymentDate` datetime NOT NULL,
  `SupplierName` varchar(250) NOT NULL,
  `SupplierContact` varchar(250) DEFAULT NULL,
  `SupplierAddress` text DEFAULT NULL,
  `Remark` text DEFAULT NULL,
  `Total` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `purchases` (`id`, `InvoiceNo`, `InvoiceDate`, `PaymentMode`, `PaymentDate`, `SupplierName`, `SupplierContact`, `SupplierAddress`, `Remark`, `Total`) VALUES
(2, 'INV-00002', '2020-01-17 19:37:19', 'CASH', '2020-01-17 19:37:19', 'Test Test', '1234566789', 'City', 'Test', '325.00');

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

--
-- Table structure for table `purchase_items`
--

CREATE TABLE `purchase_items` (
  `id` int(11) NOT NULL,
  `PurchaseId` int(11) NOT NULL,
  `ProductName` varchar(100) NOT NULL,
  `PurchaseRate` decimal(10,2) NOT NULL,
  `Quantity` decimal(10,2) NOT NULL,
  `TotalAmount` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `purchase_items`
--

INSERT INTO `purchase_items` (`id`, `PurchaseId`, `ProductName`, `PurchaseRate`, `Quantity`, `TotalAmount`) VALUES
(2, 2, 'Test Product 1', '100.00', '2.00', '200.00'),
(3, 2, 'Test Product 2', '25.00', '5.00', '125.00');

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

--
-- Table structure for table `sms_settings`
--

CREATE TABLE `sms_settings` (
  `id` int(11) NOT NULL,
  `API` mediumtext DEFAULT NULL,
  `Status` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `subcategory`
--

CREATE TABLE `subcategory` (
  `id` int(11) NOT NULL,
  `Name` varchar(250) NOT NULL,
  `CategoryName` varchar(50) NOT NULL,
  `Description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `subcategory`
--

INSERT INTO `subcategory` (`id`, `Name`, `CategoryName`, `Description`) VALUES
(1, 'KG', '', 'Kilo Grams.'),
(2, 'Test Sub', 'Test', 'N/A'),
(3, 'Test Sub', 'Test 2', 'N/A'),
(4, 'Test Sub 1', 'Test', 'N/A'),
(5, 'Only Iron', 'MEN', 'N/A'),
(6, 'Steam Iron', 'MEN', 'N/A'),
(7, 'Iron + Wash', 'MEN', 'N/A'),
(8, 'Dry Clean', 'MEN', 'N/A');

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

--
-- Table structure for table `terminal_settings`
--

CREATE TABLE `terminal_settings` (
  `id` int(11) NOT NULL,
  `TillId` varchar(100) NOT NULL,
  `PrinterName` varchar(250) NOT NULL,
  `PrintTemplate` varchar(100) NOT NULL,
  `Status` varchar(20) NOT NULL,
  `Size` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `terminal_settings`
--

INSERT INTO `terminal_settings` (`id`, `TillId`, `PrinterName`, `PrintTemplate`, `Status`, `Size`) VALUES
(1, 'Test-7567', 'Send To OneNote 2016', 'Invoice Printer', 'Active', 'POS 2 In'),
(2, 'Test-7567', 'Send To OneNote 2016', 'Label Printer', 'Active', 'POS 2 In');

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

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

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `Date` datetime NOT NULL,
  `Title` varchar(250) NOT NULL,
  `PaymentMethod` varchar(250) NOT NULL,
  `TransactionId` varchar(10) NOT NULL,
  `Description` varchar(500) DEFAULT NULL,
  `Debit` decimal(10,2) NOT NULL,
  `Credit` decimal(10,2) NOT NULL,
  `Creditor` varchar(250) NOT NULL,
  `Debtor` varchar(250) NOT NULL,
  `Type` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `transactions` (`id`, `Date`, `Title`, `PaymentMethod`, `TransactionId`, `Description`, `Debit`, `Credit`, `Creditor`, `Debtor`, `Type`) VALUES
(1, '2020-02-01 19:11:44', 'Customer Payment', 'CASH', 'PAY-00001', 'Customer Payment from Test Test (+44 1234566789) dated 01/02/2020 07:11:44 PM', '0.00', '50.00', 'Isim Software', 'Test Test', 'Credit'),
(2, '2020-02-03 18:17:45', 'Customer Payment', 'CASH', 'PAY-00002', 'Customer Payment from Test Test (+44 1234566789) dated 03/02/2020 06:17:45 PM', '0.00', '20.00', 'Isim Software', 'Test Test', 'Credit'),
(3, '2020-02-06 06:30:39', 'Customer Payment', 'CASH', 'PAY-00003', 'Customer Payment from Test User 2 (911234566789) dated 06/02/2020 06:30:39 AM', '0.00', '100.00', 'Isim Software', 'Test User 2', 'Credit'),
(5, '2020-02-13 13:05:04', 'Customer Payment', 'CASH', 'PAY-00004', 'Customer Payment from Test Customer (+441234566789) dated 13/02/2020 01:05:04 PM', '0.00', '10.00', 'Isim Software', 'Test Customer', 'Credit'),
(6, '2020-02-13 13:27:15', 'Customer Payment', 'CHEQUE', 'PAY-00006', 'Customer Payment from Test Customer (+441234566789) dated 13/02/2020 01:27:15 PM', '0.00', '20.00', 'Isim Software', 'Test Customer', 'Credit'),
(7, '2020-02-13 18:52:00', 'Customer Payment', 'ONLINE TRANSFER', 'PAY-00007', 'Customer Payment from Test User 2 (911234566789) dated 13/02/2020 06:52:00 PM', '0.00', '50.00', 'Isim Software', 'Test User 2', 'Credit'),
(8, '2020-02-14 22:38:35', 'Customer Payment', 'ONLINE TRANSFER', 'PAY-00008', 'Customer Payment from Test User 2 (911234566789) dated 14/02/2020 10:38:35 PM', '0.00', '45.00', 'Isim Software', 'Test User 2', 'Credit'),
(9, '2020-02-14 23:46:08', 'Customer Payment', 'CHEQUE', 'PAY-00009', 'Customer Payment from Test Customer (+441234566789) dated 14/02/2020 11:46:08 PM', '0.00', '40.00', 'Isim Software', 'Test Customer', 'Credit'),
(10, '2020-02-14 23:52:53', 'Customer Payment', 'ONLINE TRANSFER', 'PAY-00010', 'Customer Payment from Test Customer (+441234566789) dated 14/02/2020 11:52:53 PM', '0.00', '4.00', 'Isim Software', 'Test Customer', 'Credit'),
(11, '2020-02-14 23:53:42', 'Customer Payment', 'CASH', 'PAY-00011', 'Customer Payment from Test User 2 (911234566789) dated 14/02/2020 11:53:42 PM', '0.00', '10.00', 'Isim Software', 'Test User 2', 'Credit'),
(12, '2020-02-14 23:55:50', 'Customer Payment', 'ONLINE TRANSFER', 'PAY-00012', 'Customer Payment from Test User 2 (911234566789) dated 14/02/2020 11:55:50 PM', '0.00', '10.00', 'Isim Software', 'Test User 2', 'Credit'),
(13, '2020-02-15 00:08:30', 'Customer Payment', 'CASH', 'PAY-00013', 'Customer Payment from Test User 2 (911234566789) dated 15/02/2020 12:08:30 AM', '0.00', '50.00', 'Isim Software', 'Test User 2', 'Credit'),
(14, '2020-02-15 00:24:33', 'Customer Payment', 'CASH', 'PAY-00014', 'Customer Payment from Test Customer (+441234566789) dated 15/02/2020 12:24:33 AM', '0.00', '20.00', 'Isim Software', 'Test Customer', 'Credit'),
(15, '2020-02-16 22:31:53', 'Expense Entry', 'CHEQUE', 'EXP-00001', 'Expenses Entry to Test with title Refund and dated 16/02/2020 10:31:53 PM', '10.00', '0.00', 'Test', 'Isim Software', 'Debit'),
(16, '2020-02-16 22:37:59', 'Expense Entry', 'CASH', 'EXP-00002', 'Expenses Entry to Test with title Another Refund and dated 16/02/2020 10:37:59 PM', '20.00', '0.00', 'Test', 'Isim Software', 'Debit'),
(17, '2020-02-18 15:52:36', 'Customer Payment', 'ONLINE TRANSFER', 'PAY-00015', 'Customer Payment from Test Customer 2 (+44 9049049336) dated 18/02/2020 03:52:36 PM', '0.00', '50.00', 'Isim Software', 'Test Customer 2', 'Credit'),
(18, '2020-02-18 17:33:56', 'Customer Payment', 'CHEQUE', 'PAY-00016', 'Customer Payment from Test Customer 1 (+44 1234566789) dated 18/02/2020 05:33:56 PM', '0.00', '10.00', 'Isim Software', 'Test Customer 1', 'Credit'),
(19, '2020-02-24 19:42:07', 'Customer Payment', 'CASH', 'PAY-00017', 'Customer Payment from Test Customer 1 (+44 1234566789) dated 24/02/2020 07:42:07 PM', '0.00', '50.00', 'Isim Software', 'Test Customer 1', 'Credit'),
(20, '2020-03-25 14:40:06', 'Expense Entry', 'CASH', 'EXP-00003', 'Expenses Entry to Petrol with title Fuel and dated 25/03/2020 02:40:06 PM', '150.00', '0.00', 'Petrol', 'Isim Software', 'Debit'),
(21, '2020-03-30 10:33:07', 'Customer Payment', 'CASH', 'PAY-00018', 'Customer Payment from Test Test (+44 1234566789) dated 30/03/2020 10:33:07 AM', '0.00', '110.00', 'Isim Software', 'Test Test', 'Credit');

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `UserType` varchar(100) NOT NULL,
  `UserName` varchar(100) NOT NULL,
  `Password` varchar(100) NOT NULL,
  `Name` varchar(100) NOT NULL,
  `MobileNo` varchar(20) DEFAULT NULL,
  `EmailId` varchar(100) DEFAULT NULL,
  `Address` text DEFAULT NULL,
  `SaleScreen` varchar(20) NOT NULL,
  `Status` varchar(20) NOT NULL,
  `ProfilePic` longblob DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `users` (`id`, `UserType`, `UserName`, `Password`, `Name`, `MobileNo`, `EmailId`, `Address`, `SaleScreen`, `Status`, `ProfilePic`) VALUES
(1, 'Admin', 'admin', 'admin', 'Test Test', '+44 1234566789', 'info@isimsoftware.com', 'City.', 'Modern', 'Active', NULL);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
SET FOREIGN_KEY_CHECKS=1;
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 */;
