-- phpMyAdmin SQL Dump
-- version 5.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 01, 2020 at 02:49 PM
-- 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);

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

--
-- 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`, `FooterMessage`) VALUES
(1, 'Isim Software', '11, Address, Address', 'Address, 431005', 'Address', '+99 12345678', 'contact@isimsoftware.com', '', 'http://isimsoftware.com/', 'INR', 'Indian Rup', 'Thanks for Shopping...');

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

--
-- 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-04-20 21:50:59', 'CASH', 'Petrol Pumn', 'Fuel', 'test', '10.00');

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

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

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `OrderId` varchar(10) NOT NULL,
  `CustomerName` varchar(250) DEFAULT NULL,
  `CustomerMobile` varchar(20) DEFAULT NULL,
  `CustomerEmail` varchar(50) DEFAULT NULL,
  `OrderDate` 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,
  `PaymentMethod` varchar(250) DEFAULT NULL,
  `Status` varchar(50) DEFAULT NULL,
  `UserName` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `orders` (`id`, `OrderId`, `CustomerName`, `CustomerMobile`, `CustomerEmail`, `OrderDate`, `Remark`, `Amount`, `DiscountPer`, `DiscountAmount`, `FinalAmount`, `PaymentMethod`, `Status`, `UserName`) VALUES
(1, 'ORD-00001', 'Walk-In Customer', 'N/A', 'N/A', '2020-04-27 15:14:07', 'test', '1100.00', '0.00', '0.00', '1100.00', 'Cash', 'Completed', ''),
(2, 'ORD-00002', 'Walk-In Customer', 'N/A', 'N/A', '2020-04-28 18:43:44', '', '120.00', '0.00', '0.00', '120.00', 'Cash', 'Completed', 'admin');

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

--
-- 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,
  `Unit` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `orders_items` (`id`, `OrderId`, `ProductId`, `ProductName`, `Price`, `Quantity`, `ProductTotal`, `Unit`) VALUES
(1, 1, 1, 'Test Product', '20.00', '5.00', '100.00', 'KG'),
(2, 1, 5, 'Test Product 3', '1000.00', '1.00', '1000.00', 'PC'),
(3, 2, 1, 'Test Product', '20.00', '1.00', '20.00', 'KG'),
(4, 2, 2, 'Test Product 2', '50.00', '1.00', '50.00', 'KG'),
(5, 2, 4, 'Test Product 2', '50.00', '1.00', '50.00', 'KG');

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

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

CREATE TABLE `payments` (
  `id` int(11) NOT NULL,
  `TransactionID` varchar(20) NOT NULL,
  `Date` datetime NOT NULL,
  `PaymentMethod` varchar(250) DEFAULT NULL,
  `SupplierID` int(11) 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`, `Date`, `PaymentMethod`, `SupplierID`, `Amount`, `Remarks`) VALUES
(1, 'PAY-00001', '2020-04-20 11:30:43', 'Cash', 1, '20.00', 'test'),
(2, 'PAY-00002', '2020-04-29 14:37:23', 'Cash', 2, '2000.00', ''),
(3, 'PAY-00003', '2020-04-29 14:38:52', 'Debit Card', 1, '250.00', ''),
(4, 'PAY-00004', '2020-04-29 14:40:31', 'Debit Card', 3, '50.00', ''),
(5, 'PAY-00005', '2020-04-29 14:43:29', 'Cash', 2, '100.00', '');

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

--
-- 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.'),
(2, 'Credit Card', 'Card'),
(3, 'Debit Card', 'N/A');

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

--
-- 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,
  `Unit` varchar(50) DEFAULT NULL,
  `Description` text DEFAULT NULL,
  `ReorderPoint` decimal(10,2) NOT NULL,
  `SaleRate` decimal(10,2) NOT NULL,
  `PurchaseRate` 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`, `Unit`, `Description`, `ReorderPoint`, `SaleRate`, `PurchaseRate`, `Status`) VALUES
(1, 'PID-00001', '100001', 'Test Product', 'Grocery', 'KG', 'Test Product', '2.00', '20.00', '18.00', 'Active'),
(2, 'PID-00002', '100002', 'Test Product 2', 'Grocery', 'KG', 'Test Product 2', '30.00', '50.00', '45.00', 'Active'),
(3, 'PID-00003', '100003', 'Test Product 1', 'Test', 'KG', 'Product Description', '5.00', '30.00', '25.00', 'Active'),
(4, 'PID-00004', '100004', 'Test Product 2', 'Test 2', 'KG', 'Product Description', '2.00', '50.00', '30.00', 'Active'),
(5, 'PID-00005', '100005', 'Test Product 3', 'Test', 'KG', 'Product Description.', '20.00', '1000.00', '512.00', 'Active');

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

--
-- Table structure for table `product_stock`
--

CREATE TABLE `product_stock` (
  `id` int(11) NOT NULL,
  `ProductId` int(11) NOT NULL,
  `Quantity` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `product_stock`
--

INSERT INTO `product_stock` (`id`, `ProductId`, `Quantity`) VALUES
(1, 1, '20.00'),
(2, 2, '52.00'),
(3, 3, '25.00'),
(4, 4, '14.00'),
(5, 5, '58.00');

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

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

CREATE TABLE `product_style` (
  `id` int(11) NOT NULL,
  `ProductId` int(11) NOT NULL,
  `ProductImage` varchar(1000) DEFAULT 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, 'NULL', -65536, -8040273, -1, -8040273, -4569702),
(2, 2, 'NULL', -29696, -11513736, -1, -11513736, -11513751),
(3, 3, 'NULL', -29696, -11513736, -1, -11513736, -11513751),
(4, 4, 'NULL', -29696, -11513736, -1, -11513736, -11513751),
(5, 5, 'NULL', -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,
  `SupplierId` int(11) NOT NULL,
  `SupplierInvoiceNo` varchar(20) DEFAULT NULL,
  `SupplierInvoiceDate` date DEFAULT NULL,
  `Remark` text DEFAULT NULL,
  `SubTotal` decimal(10,2) NOT NULL,
  `OtherCharges` decimal(10,2) NOT NULL,
  `GrandTotal` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `purchases` (`id`, `InvoiceNo`, `InvoiceDate`, `SupplierId`, `SupplierInvoiceNo`, `SupplierInvoiceDate`, `Remark`, `SubTotal`, `OtherCharges`, `GrandTotal`) VALUES
(1, 'INV-00001', '2019-08-13 20:18:10', 1, '1022', '2019-08-12', 'Test Invoice.', '90.00', '0.00', '90.00'),
(2, 'INV-00002', '2020-04-27 19:47:52', 1, '10001', '2020-04-27', 'test', '1981.00', '0.00', '1981.00'),
(3, 'INV-00003', '2020-04-29 14:35:21', 2, '12522', '2020-04-29', '', '2585.00', '0.00', '2585.00'),
(4, 'INV-00004', '2020-04-29 14:35:47', 3, '52225', '2020-04-29', '', '63.00', '0.00', '63.00'),
(5, 'INV-00005', '2020-04-29 14:57:10', 1, '2522', '2020-04-29', '', '557.00', '0.00', '557.00');

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

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

CREATE TABLE `purchase_items` (
  `id` int(11) NOT NULL,
  `PurchaseId` int(11) NOT NULL,
  `ProductId` int(11) NOT NULL,
  `ProductDisplayId` varchar(20) NOT NULL,
  `Name` varchar(100) NOT NULL,
  `SaleRate` decimal(10,2) 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`, `ProductId`, `ProductDisplayId`, `Name`, `SaleRate`, `PurchaseRate`, `Quantity`, `TotalAmount`) VALUES
(1, 1, 1, 'PID-00001', 'Test Product', '20.00', '18.00', '5.00', '90.00'),
(2, 2, 2, 'PID-00002', 'Test Product 2', '50.00', '45.00', '1.00', '45.00'),
(3, 2, 3, 'PID-00003', 'Test Product 1', '30.00', '25.00', '4.00', '100.00'),
(4, 2, 4, 'PID-00004', 'Test Product 2', '50.00', '30.00', '10.00', '300.00'),
(5, 2, 5, 'PID-00005', 'Test Product 3', '1000.00', '512.00', '3.00', '1536.00'),
(6, 3, 5, 'PID-00005', 'Test Product 3', '1000.00', '512.00', '5.00', '2560.00'),
(7, 3, 3, 'PID-00003', 'Test Product 1', '30.00', '25.00', '1.00', '25.00'),
(8, 4, 1, 'PID-00001', 'Test Product', '20.00', '18.00', '1.00', '18.00'),
(9, 4, 2, 'PID-00002', 'Test Product 2', '50.00', '45.00', '1.00', '45.00'),
(10, 5, 5, 'PID-00005', 'Test Product 3', '1000.00', '512.00', '1.00', '512.00'),
(11, 5, 2, 'PID-00002', 'Test Product 2', '50.00', '45.00', '1.00', '45.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 `supplier`
--

CREATE TABLE `supplier` (
  `id` int(11) NOT NULL,
  `SupplierId` 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,
  `Balance` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `supplier`
--

INSERT INTO `supplier` (`id`, `SupplierId`, `Name`, `MobileNo`, `EmailId`, `AddressLine1`, `AddressLine2`, `AddressLine3`, `Remark`, `Balance`) VALUES
(1, 'SUP-00001', 'Isim Software', '+99 12345678', 'info@isimsoftware.com', 'Address', '.', '', 'N/A', '2358.00'),
(2, 'SUP-00002', 'Test Supplier 2', '+99 12345678', 'test@isimsoftware.com', 'Address', 'Maharastra', 'India', 'Demo Supplier', '485.00'),
(3, 'SUP-00003', 'Test Supplier 3', '+99 12345678', 'test1@isimsoftware.com', 'Address', 'Maharastra', 'India', 'Demo Supplier', '13.00');

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

--
-- 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, 'Sagar-7567', 'Send To OneNote 2016', 'Invoice Printer', 'Active', 'POS 2 In'),
(2, 'Sagar-7567', 'Send To OneNote 2016', 'Report Printer', 'Active', 'POS 2 In'),
(3, 'Sagar-7567', 'Send To OneNote 2013', 'Report Printer', 'Active', 'A4'),
(4, 'Sagar-7567', 'Send To OneNote 2016', 'Label Printer', 'Active', 'POS 2 In'),
(5, 'Sagar-7567', 'Send To OneNote 2013', 'Label Printer', 'Active', 'A4');

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

--
-- 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-04-20 11:30:43', 'Supplier Payment', 'Cash', 'PAY-00001', 'Payment to Isim Software (+99 12345678) dated 20/04/2020 11:30:43 AM', '20.00', '0.00', 'Isim Software', 'Isim Software', 'Debit'),
(2, '2020-04-20 21:50:59', 'Expense Entry', 'CASH', 'EXP-00001', 'Expenses Entry to Petrol Pumn with title Fuel and dated 20/04/2020 09:50:59 PM', '10.00', '0.00', 'Petrol Pumn', 'Isim Software', 'Debit'),
(3, '2020-04-28 18:43:44', 'POS Sale', 'Cash', 'ORD-00002', 'POS Sale Payment from Walk-In Customer (N/A) dated 28/04/2020 06:43:44 PM', '0.00', '120.00', 'Isim Software', 'Walk-In Customer', 'Credit'),
(4, '2020-04-29 14:37:23', 'Supplier Payment', 'Cash', 'PAY-00002', 'Payment to Test Supplier 2 (+99 12345678) dated 29/04/2020 02:37:23 PM', '2000.00', '0.00', 'Test Supplier 2', 'Isim Software', 'Debit'),
(5, '2020-04-29 14:38:52', 'Supplier Payment', 'Debit Card', 'PAY-00003', 'Payment to Isim Software (+99 12345678) dated 29/04/2020 02:38:52 PM', '250.00', '0.00', 'Isim Software', 'Isim Software', 'Debit'),
(6, '2020-04-29 14:40:31', 'Supplier Payment', 'Debit Card', 'PAY-00004', 'Payment to Test Supplier 3 (+99 12345678) dated 29/04/2020 02:40:31 PM', '50.00', '0.00', 'Test Supplier 3', 'Isim Software', 'Debit'),
(7, '2020-04-29 14:43:29', 'Supplier Payment', 'Cash', 'PAY-00005', 'Payment to Test Supplier 2 (+99 12345678) dated 29/04/2020 02:43:29 PM', '100.00', '0.00', 'Test Supplier 2', 'Isim Software', 'Debit');

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

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

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

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

INSERT INTO `units` (`id`, `Name`, `Description`) VALUES
(1, 'KG', 'Kilo Grams.'),
(2, 'PC', 'N/A');

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

--
-- 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` varchar(1000) 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', 'Isim Software', '+99 12345678', 'info@isimsoftware.com', 'Address.', 'Modern', 'Active', 'NULL'),
(2, 'Cashier', 'sale', 'sale', 'Sale', '123456789', 'info@isimsoftware.com', 'abad', 'Clasic', '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 `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_stock`
--
ALTER TABLE `product_stock`
  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 `supplier`
--
ALTER TABLE `supplier`
  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 `units`
--
ALTER TABLE `units`
  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=4;

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

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

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

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

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

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

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

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

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

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

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

--
-- 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 `supplier`
--
ALTER TABLE `supplier`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

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

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

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

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