1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / ilium_latest / db /
Filename : projects_ilium_mani.sql
back
-- phpMyAdmin SQL Dump
-- version 4.9.11
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jul 12, 2024 at 11:53 AM
-- Server version: 8.0.37-0ubuntu0.22.04.3
-- PHP Version: 7.4.33

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: `projects_ilium`
--

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

--
-- Table structure for table `accountnames`
--

CREATE TABLE `accountnames` (
  `accountid` int NOT NULL,
  `company_id` int NOT NULL,
  `groupid` int NOT NULL,
  `categoryid` int NOT NULL,
  `subcategoryid` int NOT NULL,
  `subsubcategoryid` int NOT NULL DEFAULT '0',
  `accountname` varchar(200) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-active,1-inactive,2-deleted',
  `createdBy` int DEFAULT NULL,
  `createdTime` timestamp NOT NULL,
  `modifiedBy` int NOT NULL,
  `modifiedTime` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `accountnames`
--

INSERT INTO `accountnames` (`accountid`, `company_id`, `groupid`, `categoryid`, `subcategoryid`, `subsubcategoryid`, `accountname`, `status`, `createdBy`, `createdTime`, `modifiedBy`, `modifiedTime`) VALUES
(1, 1, 1, 1, 3, 50, 'Bank Account ', 0, NULL, '2024-03-15 13:28:26', 0, '2024-04-01 11:00:29'),
(2, 1, 2, 3, 0, 0, 'Sales Revenue Account', 0, NULL, '2024-03-15 13:34:55', 0, '2024-04-01 10:58:00'),
(3, 1, 2, 5, 0, 0, 'Cost of Sales Account', 0, NULL, '2024-03-16 09:02:09', 0, '0000-00-00 00:00:00'),
(4, 1, 2, 6, 0, 0, 'Bank Charges Account', 0, NULL, '2024-03-16 09:02:44', 0, '2024-03-31 07:50:31'),
(5, 1, 2, 6, 0, 0, 'Entertainment Account', 0, NULL, '2024-03-16 09:05:05', 0, '2024-03-31 06:55:52'),
(6, 1, 2, 5, 0, 0, 'Conveyance Account', 0, NULL, '2024-03-16 09:05:42', 0, '2024-03-19 11:18:45'),
(8, 1, 2, 5, 0, 0, 'Purchases account', 0, 1, '2024-03-16 10:00:47', 1, '2024-03-16 15:46:54'),
(37, 1, 1, 2, 4, 0, 'Profit and loss account', 0, 1, '2015-06-08 16:30:55', 1, '2015-06-08 16:30:55'),
(38, 1, 1, 2, 4, 51, 'Equity share capital.', 0, NULL, '2024-03-18 10:26:11', 0, '2024-03-31 07:06:07'),
(56, 1, 1, 1, 3, 0, 'Inventories on Hand account', 0, 1, '2015-06-30 02:43:29', 0, '2015-06-30 02:43:29'),
(58, 1, 2, 3, 0, 0, 'Closing Inventories account', 0, 1, '2015-06-30 03:24:28', 0, '2015-06-30 03:24:28'),
(59, 1, 2, 6, 0, 0, 'bank Charges A/C', 0, NULL, '2024-03-18 13:48:01', 0, '2024-03-31 06:44:17'),
(60, 1, 2, 6, 0, 0, 'Telephone Expenses A/c', 1, NULL, '2024-03-18 14:12:04', 0, '2024-04-01 11:15:12'),
(61, 1, 2, 6, 0, 0, 'Bank charges account', 0, NULL, '2024-03-18 15:11:47', 0, '2024-03-31 06:46:33'),
(62, 1, 2, 6, 0, 0, 'Director expenses A/c', 0, NULL, '2024-03-18 15:20:56', 0, '0000-00-00 00:00:00'),
(63, 1, 2, 6, 0, 0, 'courier Expenses A/c', 0, NULL, '2024-03-18 15:22:26', 0, '2024-03-31 06:47:23'),
(64, 1, 1, 1, 3, 19, 'Manama Steel Company', 0, NULL, '2024-03-21 05:40:43', 0, '2024-03-31 06:54:32'),
(65, 1, 1, 1, 3, 19, 'Bahrain Steel company', 0, NULL, '2024-03-21 05:40:45', 0, '2024-04-01 10:51:39'),
(66, 1, 1, 2, 4, 0, 'Lakshmi Mittal Steel Ltd', 0, NULL, '2024-03-21 06:49:13', 0, '2024-03-31 06:56:47'),
(67, 1, 1, 2, 6, 4, 'Liberty steel Ltd', 0, NULL, '2024-03-31 07:00:37', 0, '2024-03-31 07:07:15'),
(68, 1, 2, 5, 0, 0, 'Freight inwards.', 0, NULL, '2024-03-31 07:15:39', 0, '0000-00-00 00:00:00'),
(69, 1, 2, 5, 0, 0, 'Direct wages. Alc.', 0, NULL, '2024-03-31 07:16:04', 0, '0000-00-00 00:00:00'),
(70, 1, 2, 3, 0, 0, 'factory overheads.', 0, NULL, '2024-03-31 07:16:49', 0, '0000-00-00 00:00:00'),
(72, 1, 2, 6, 0, 0, 'Rent account', 0, NULL, '2024-03-31 07:23:31', 0, '0000-00-00 00:00:00'),
(88, 1, 2, 3, 0, 0, 'Rent account', 0, NULL, '2024-03-31 07:24:23', 0, '2024-03-31 09:12:25'),
(93, 1, 2, 6, 0, 0, 'Rental expenses account', 0, NULL, '2024-03-31 07:25:31', 0, '0000-00-00 00:00:00'),
(113, 2, 1, 1, 1, 21, 'Plant and Machinery', 0, NULL, '2024-03-31 09:31:43', 0, '0000-00-00 00:00:00'),
(114, 2, 1, 1, 1, 38, 'Computers', 0, NULL, '2024-03-31 09:32:16', 0, '2024-04-02 06:54:34'),
(115, 2, 1, 1, 1, 40, 'Furniture and fixtures', 0, NULL, '2024-03-31 09:34:05', 0, '0000-00-00 00:00:00'),
(116, 2, 1, 1, 1, 39, 'Office Equipment', 0, NULL, '2024-03-31 09:35:03', 0, '0000-00-00 00:00:00'),
(117, 2, 1, 1, 3, 50, 'Cash on hand account', 0, NULL, '2024-03-31 09:36:10', 0, '0000-00-00 00:00:00'),
(118, 2, 1, 1, 3, 19, 'Trade Receivables account', 0, NULL, '2024-03-31 09:37:42', 0, '0000-00-00 00:00:00'),
(119, 2, 1, 1, 3, 50, 'Cash at bank account', 0, NULL, '2024-03-31 09:38:26', 0, '0000-00-00 00:00:00'),
(120, 2, 1, 1, 3, 22, 'Staff loans and advances account', 0, NULL, '2024-03-31 09:39:31', 0, '0000-00-00 00:00:00'),
(121, 1, 2, 3, 0, 0, 'aaa', 2, NULL, '2024-03-31 10:37:28', 0, '2024-04-01 11:18:52'),
(122, 2, 1, 1, 3, 50, 'Cash at Bank -KCB Euro Account', 0, NULL, '2024-04-01 05:31:54', 0, '0000-00-00 00:00:00'),
(123, 2, 1, 1, 3, 2, 'Bank KCB -BHD  Account', 0, NULL, '2024-04-01 05:57:28', 0, '0000-00-00 00:00:00'),
(124, 2, 1, 1, 3, 2, 'Bank BBK-BHD Account', 0, NULL, '2024-04-01 05:58:05', 0, '2024-04-01 07:04:16'),
(125, 2, 1, 1, 3, 2, 'Bank BBK-TR Account', 0, NULL, '2024-04-01 05:58:43', 0, '0000-00-00 00:00:00'),
(126, 2, 1, 1, 3, 6, 'Petty Cash Office Account', 0, NULL, '2024-04-01 05:59:13', 0, '0000-00-00 00:00:00'),
(127, 2, 1, 1, 3, 2, 'BDB Bank A/c', 0, NULL, '2024-04-01 06:00:23', 0, '0000-00-00 00:00:00'),
(128, 2, 1, 1, 3, 2, 'BDB-US Account', 0, NULL, '2024-04-01 06:00:57', 0, '0000-00-00 00:00:00'),
(129, 2, 1, 2, 6, 24, 'Loan BDB Account', 0, NULL, '2024-04-01 06:02:10', 0, '0000-00-00 00:00:00'),
(130, 2, 1, 2, 6, 24, 'Bank Loans -BDB Account', 0, NULL, '2024-04-01 06:08:38', 0, '0000-00-00 00:00:00'),
(131, 2, 1, 1, 3, 8, 'Deposits-Customs Account', 0, NULL, '2024-04-01 06:12:14', 0, '0000-00-00 00:00:00'),
(132, 2, 1, 1, 3, 8, 'Prepaid Insurance Account', 0, NULL, '2024-04-02 06:32:31', 0, '0000-00-00 00:00:00'),
(133, 2, 1, 1, 3, 8, 'Deposits -Customs Account', 0, NULL, '2024-04-02 06:32:55', 0, '0000-00-00 00:00:00'),
(134, 2, 1, 1, 3, 8, 'Staff advance Account', 0, NULL, '2024-04-02 06:33:23', 0, '0000-00-00 00:00:00'),
(135, 2, 1, 1, 1, 59, 'Trade Marks Account', 0, NULL, '2024-04-02 06:34:23', 0, '0000-00-00 00:00:00'),
(136, 2, 2, 5, 0, 0, 'Freight Inwards', 0, NULL, '2024-04-02 15:48:06', 0, '0000-00-00 00:00:00'),
(137, 2, 2, 4, 0, 0, 'Scrap Sales Account', 2, NULL, '2024-04-02 15:58:15', 0, '2024-04-04 13:54:12'),
(138, 2, 2, 4, 0, 0, 'Scrap Sales Account', 0, NULL, '2024-04-02 16:07:10', 0, '0000-00-00 00:00:00'),
(139, 2, 2, 4, 0, 0, 'Scrap Sales Account', 0, NULL, '2024-04-04 15:08:47', 0, '2024-04-04 15:13:02'),
(140, 2, 2, 6, 0, 0, 'Rental Expenses -Head Office Account', 0, NULL, '2024-04-04 16:07:25', 0, '0000-00-00 00:00:00'),
(141, 2, 1, 2, 6, 9, 'Accrual', 0, NULL, '2024-04-04 16:08:47', 0, '0000-00-00 00:00:00'),
(142, 2, 2, 3, 0, 0, 'Sales Revenue Account', 0, NULL, '2024-04-04 16:16:15', 0, '0000-00-00 00:00:00'),
(143, 2, 2, 5, 0, 0, 'Factory Overhead', 0, NULL, '2024-04-07 17:28:38', 0, '0000-00-00 00:00:00'),
(144, 1, 2, 5, 0, 0, 'Tools and Consumables Account', 0, NULL, '2024-04-07 18:01:41', 0, '0000-00-00 00:00:00'),
(145, 2, 2, 5, 0, 0, 'Tools and Consumables Account', 0, NULL, '2024-04-07 18:07:19', 0, '0000-00-00 00:00:00'),
(146, 2, 2, 3, 0, 0, 'asd', 2, NULL, '2024-04-10 10:12:53', 0, '2024-04-10 12:33:45'),
(147, 2, 2, 3, 0, 0, 'gggg', 2, NULL, '2024-04-10 12:33:57', 0, '2024-04-10 12:34:09'),
(148, 2, 2, 3, 0, 0, 'jjjj', 2, NULL, '2024-04-10 12:34:27', 0, '2024-04-10 12:34:48'),
(149, 2, 2, 3, 0, 0, 'dxscdszfcdsfcvdscvf', 2, NULL, '2024-04-10 13:35:22', 0, '2024-04-10 13:35:44'),
(150, 2, 2, 3, 0, 0, 'Arunkumar R', 2, NULL, '2024-04-11 05:30:14', 0, '2024-04-11 05:30:23'),
(151, 2, 2, 3, 0, 0, 'Tr.Debtors-Sulaiman  A/C', 0, NULL, '2024-04-17 14:02:06', 0, '2024-04-17 14:02:51'),
(152, 2, 2, 6, 0, 0, 'Arun', 0, NULL, '2024-04-18 11:15:23', 0, '0000-00-00 00:00:00'),
(153, 2, 2, 4, 0, 0, 'aaaaaa', 0, NULL, '2024-04-18 11:20:46', 0, '0000-00-00 00:00:00');

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

--
-- Table structure for table `bank_transaction`
--

CREATE TABLE `bank_transaction` (
  `trans_id` int NOT NULL,
  `company_id` int NOT NULL,
  `trans_date` date NOT NULL,
  `withdraw` decimal(10,2) NOT NULL,
  `deposit` decimal(10,2) NOT NULL,
  `accountname` int NOT NULL,
  `reference` varchar(200) NOT NULL,
  `description` varchar(500) NOT NULL,
  `balance` decimal(10,2) NOT NULL,
  `voucher_type` tinyint(1) NOT NULL DEFAULT '0',
  `accountname2` int NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-saved,1-submitted',
  `createdBy` int NOT NULL,
  `createdTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `voucherid` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `category` (
  `categoryid` int NOT NULL,
  `groupid` int NOT NULL,
  `categoryname` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `category` (`categoryid`, `groupid`, `categoryname`) VALUES
(1, 1, 'Assets'),
(2, 1, 'Liabilities'),
(3, 2, 'Direct Income'),
(4, 2, 'Other Income'),
(5, 2, 'Direct Expenses'),
(6, 2, 'Indirect Expenses');

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

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

CREATE TABLE `company` (
  `company_id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `landline` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `address` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `locality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `pincode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `website` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currencyused` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `default_company` tinyint(1) NOT NULL DEFAULT '1',
  `vat` int DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `comp` tinyint(1) NOT NULL COMMENT 'flag to get the default company',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `company` (`company_id`, `name`, `email`, `landline`, `mobile`, `logo`, `address`, `locality`, `pincode`, `website`, `currencyused`, `default_company`, `vat`, `status`, `comp`, `created_at`, `updated_at`) VALUES
(1, 'Addobyte', 'ilium@gmail.com', '9344694501', '9344694501', '198883461711693478.jpg', 'vadapalani , chennai', 'vadapalani', '600062', 'www.addobyte.com', 'Bahraini Dinar', 1, 10, 0, 0, '2024-03-29 06:23:00', '2024-03-29 06:23:00'),
(2, 'ilium', 'ilium@gmail.com', '96325874159', '9344694501', '12021458481711693380.png', 'chennai', 'vadapalani', '632514', 'www.ilium.com', 'BD', 1, 10, 0, 1, '2024-03-29 06:24:38', '2024-03-29 06:24:38'),
(5, 'testing', 'someshwaran@addobyte.com', '45534535', '9344694501', 'www.byte.com', '', 'vadapalani', '632514', 'INR', '96 b Nadoor street paramasathu.\r\nponnai village katpadi taluka', 1, 5, 0, 0, '2024-04-24 11:09:11', '2024-04-24 11:09:11');

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `contactid` int NOT NULL,
  `company_id` int NOT NULL,
  `contacttype` tinyint(1) NOT NULL,
  `customername` varchar(200) NOT NULL,
  `address` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `city` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `pincode` varchar(255) DEFAULT NULL,
  `bankname` varchar(200) NOT NULL,
  `accountnumber` varchar(100) NOT NULL,
  `phone` varchar(30) NOT NULL,
  `email` varchar(100) NOT NULL,
  `payment_terms` varchar(255) DEFAULT NULL,
  `incoterms` varchar(255) DEFAULT NULL,
  `transport_name` varchar(255) DEFAULT NULL,
  `website` varchar(100) NOT NULL,
  `gstregistration` varchar(100) NOT NULL,
  `currency` varchar(10) NOT NULL,
  `currencies_name` varchar(255) DEFAULT NULL,
  `notes` text NOT NULL,
  `accountname` int NOT NULL,
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '0-active,1-inactive,2-deleted',
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modifiedTime` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`contactid`, `company_id`, `contacttype`, `customername`, `address`, `city`, `country`, `pincode`, `bankname`, `accountnumber`, `phone`, `email`, `payment_terms`, `incoterms`, `transport_name`, `website`, `gstregistration`, `currency`, `currencies_name`, `notes`, `accountname`, `status`, `modifiedTime`) VALUES
(1, 2, 3, 'Arunkumar R', '96 b Nadoor street paramasathu.', 'chennai', 'Local', '632514', '', '', '9344694501', 'arunkumar@addobyte.com', '60 Days', 'CIF', 'Hand Delivery', 'www.addobyte.com', '2024084518F', '1', 'INR', 'Arunkumar R', 114, 0, '2024-06-29 07:42:53'),
(2, 2, 3, 'ilium', '96 b Nadoor street paramasathu.', 'chennai', 'Local', '632514', '', '', '7092273652', 'arunkumar@addobyte.com', '60 Days', 'DDP', 'Hand Delivery', 'www.ilium.com', '2024084518F', '2', 'USA', 'Arunkumar R', 118, 0, '2024-07-01 09:25:13');

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

--
-- Table structure for table `contacttype`
--

CREATE TABLE `contacttype` (
  `typeid` int NOT NULL,
  `contacttype` varchar(100) NOT NULL,
  `status` tinyint(1) NOT NULL COMMENT '0-active,1-inactive,2-deleted'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contacttype`
--

INSERT INTO `contacttype` (`typeid`, `contacttype`, `status`) VALUES
(1, 'Customer', 0),
(2, 'Vendor', 0),
(3, 'Both', 0);

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

--
-- Table structure for table `creditnotes`
--

CREATE TABLE `creditnotes` (
  `credit_id` int NOT NULL,
  `company_id` int DEFAULT NULL,
  `against_invoice_no` varchar(255) NOT NULL,
  `credit_date` varchar(255) NOT NULL,
  `issue_to` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `amount` varchar(255) NOT NULL,
  `totaldebit` varchar(255) DEFAULT NULL,
  `totalcredit` varchar(255) DEFAULT NULL,
  `invamt` varchar(255) NOT NULL,
  `balanceamonut` varchar(255) NOT NULL,
  `invoicedate` varchar(255) DEFAULT NULL,
  `narration` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `preparedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `authorizedby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `createdBy` int DEFAULT NULL,
  `createdTime` timestamp NULL DEFAULT NULL,
  `status` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `creditnotes`
--

INSERT INTO `creditnotes` (`credit_id`, `company_id`, `against_invoice_no`, `credit_date`, `issue_to`, `type`, `amount`, `totaldebit`, `totalcredit`, `invamt`, `balanceamonut`, `invoicedate`, `narration`, `preparedby`, `authorizedby`, `createdBy`, `createdTime`, `status`) VALUES
(1, 1, '1', '2024-03-29', 'Arunkumar', 'Stock adjustment', '200', '200.00', '200.00', '10560.00', '10560.00', '2024-03-29', 'testing', 'addobyte', 'ramkumar', NULL, '2024-03-29 07:12:09', 0);

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

--
-- Table structure for table `creditnotes_records`
--

CREATE TABLE `creditnotes_records` (
  `credit_id` int NOT NULL,
  `accountname` int NOT NULL,
  `debit` decimal(10,2) NOT NULL,
  `credit` decimal(10,2) NOT NULL,
  `reference` varchar(100) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `creditnotes_records`
--

INSERT INTO `creditnotes_records` (`credit_id`, `accountname`, `debit`, `credit`, `reference`, `status`) VALUES
(1, 2, '200.00', '0.00', 'testing', 0),
(1, 1, '0.00', '200.00', 'testing', 0);

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

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

CREATE TABLE `customers` (
  `customerid` int NOT NULL,
  `company_id` int NOT NULL,
  `name` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `usertype` tinyint NOT NULL COMMENT '1-superadmin,2-admin,3-user',
  `status` tinyint(1) NOT NULL COMMENT '0-avtive,1-inactive,2-deleted',
  `email` varchar(100) NOT NULL,
  `contact` varchar(100) NOT NULL,
  `designationid` varchar(200) NOT NULL DEFAULT '0',
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modifiedTime` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `customers` (`customerid`, `company_id`, `name`, `username`, `password`, `usertype`, `status`, `email`, `contact`, `designationid`, `modifiedTime`) VALUES
(1, 1, 'Superadmin', 'addobyte', 'admin2016', 1, 0, 'admin@mail.com', '', '0', '0000-00-00 00:00:00');

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

--
-- Table structure for table `employee`
--

CREATE TABLE `employee` (
  `employee_id` int NOT NULL,
  `company_id` int DEFAULT NULL,
  `emp_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `employeename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `username` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `contract_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `employee_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `department` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `designation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `emergency_mobile_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `gender` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `employedDate` date DEFAULT NULL,
  `resignedDate` date DEFAULT NULL,
  `address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `spousename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `profile_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `passport_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `passport_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `passport_issue_date` date DEFAULT NULL,
  `passport_expiry_date` date DEFAULT NULL,
  `passport_issue_place` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `passport_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rp_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rp_issue_date` date DEFAULT NULL,
  `rp_expiry_date` date DEFAULT NULL,
  `rp_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `crp_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `crp_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `crp_issue_date` date DEFAULT NULL,
  `crp_expiry_date` date DEFAULT NULL,
  `bank_account_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_iban` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `bank_swift_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `basic_salary` decimal(10,2) DEFAULT NULL,
  `other_allowance` decimal(10,2) DEFAULT NULL,
  `sio` decimal(10,2) DEFAULT NULL,
  `lmra_fee` decimal(10,2) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '1',
  `created_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employee`
--

INSERT INTO `employee` (`employee_id`, `company_id`, `emp_id`, `employeename`, `username`, `password`, `contract_type`, `employee_status`, `department`, `designation`, `mobile`, `emergency_mobile_no`, `email`, `birthdate`, `nationality`, `gender`, `employedDate`, `resignedDate`, `address`, `spousename`, `profile_image`, `passport_name`, `passport_number`, `passport_issue_date`, `passport_expiry_date`, `passport_issue_place`, `passport_file`, `rp_number`, `rp_issue_date`, `rp_expiry_date`, `rp_file`, `crp_name`, `crp_number`, `crp_issue_date`, `crp_expiry_date`, `bank_account_name`, `bank_iban`, `bank_swift_code`, `basic_salary`, `other_allowance`, `sio`, `lmra_fee`, `status`, `created_by`, `created_at`, `updated_by`, `updated_at`) VALUES
(6, 1, '1', 'Colin Locke', 'tester', 'tester', '', 'Local', '13', '12', '9685745849', '5421546845', 'ColinLocke@gmail.com', '1999-09-27', NULL, 'Male', '2014-09-27', NULL, 'bahrain', 'colin', '174721552616793157081_(1)342092814_20230415084324.jpg', 'Colin Locke', '550X50X550', '2022-07-08', '2032-07-05', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219012036497446_20230415084451.jpg', '3726914', '2022-06-22', '2024-09-27', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901674028100_20230415084535.jpg', 'Colin Locke', '780948840', '1970-01-01', '2025-07-17', 'Colin Locke', '956465884585', '65468iug', '1000.00', '300.00', '52.00', '44.00', 1, NULL, NULL, 1, '2023-04-17 09:04:55'),
(7, 1, '3', 'Sandeep K', 'tester', 'tester', '', 'Local', '12', '14', '9685745845', '96584578548', 'Sandeep@gmail.com', '1970-01-01', NULL, 'Male', '2017-02-06', NULL, 'bahrain', 'sandeep', '18564396451680583979.jpg', 'Sandeep K', 'R8310090', '2017-08-23', '2027-08-22', 'bahrain', '209360424116799874661.jpg', '4239187', '2023-01-11', '2025-02-05', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219011572327791_20230415090910.jpg', 'Sandeep K', '841159548', '1970-01-01', '2027-07-03', 'Sandeep K', '42647356756735674236', 'GFEWDF345345DSF', '1500.00', '500.00', '50.00', '20.00', 1, NULL, NULL, 1, '2023-04-17 09:06:02'),
(8, 1, '4', 'Manal S. Husain ', '', NULL, 'PartTime', 'Local', '', '', '8574965845', '3452364545', 'Husain@gmail.com', '2018-12-01', NULL, 'M', '2018-06-24', NULL, '', '', '18564396451680583979.jpg', 'Manal S. Husain ', '325476452', '2021-03-01', '2023-09-01', 'bharain\n', '107273430516799957501.jpg', '34326347', '2022-04-01', '2025-04-11', '107273430516799957502.jpg', 'Manal S. Husain ', '\n53436545', '2023-01-09', '2023-06-22', 'IBAN BANK', '21354325645654', '\nEG45TREG43', '600.00', '200.00', '40.00', '60.00', 1, NULL, NULL, NULL, NULL),
(9, 1, '5', 'Luma Majed Aljishi', '', NULL, 'PartTime', 'Local', '', '', '+973 9874 9630', '+973 8520 7412', 'Aljishi@gmail.com', '1986-06-05', NULL, 'F', '2011-04-03', NULL, 'bahrain', 'alijishi', '15389043741680607328.jpg', 'Luma Majed Aljishi', 'J2987456', '2023-04-05', '2024-09-21', 'bahrain\n', '153890437416806073281.jpg', '985452', '2023-04-05', '2021-10-06', '153890437416806073282.jpg', 'E01', '\n98565', '2022-04-06', '2024-05-01', '85745842', '0253641', '\n2323', '4.00', '50.00', '950.00', '600.00', 1, NULL, NULL, NULL, NULL),
(10, 1, '6', 'Jacques Francois Daniel Paque', '', NULL, 'PartTime', 'Local', '', '', '+973 9874 6352', '+973 8521 7896', 'Jacques@gmail.com', '1983-08-04', NULL, 'M', '2010-08-16', NULL, 'bahrain', 'sana khan', '16645154221680608079.jpg', 'Jacques Francois Daniel Paque', 'J56412302', '2022-06-18', '2024-02-15', 'bahrain\n', '166451542216806080791.jpg', '89755', '2022-04-04', '2024-04-04', '166451542216806080792.jpg', 'E02', '\n874596', '2022-12-05', '2023-08-19', 'Jacques Francois Daniel Paque', '1299123456BH00', '\n0000', '3.00', '0.00', '2020.00', '1235.00', 1, NULL, NULL, NULL, NULL),
(11, 1, '7', 'Jahir Hussain Vena', 'tester', 'tester', 'Full Time', 'Expat', '14', '13', '+973 8546 9874', '+973 7894 9562', 'Jahir @gmail.com', '1983-06-14', NULL, 'Male', '2011-04-03', NULL, 'bahrain', 'jahir', '174721552616793157081_(1)1897499731_20230415090151.jpg', 'Jahir Hussain Vena', 'V8725630', '2022-04-05', '2032-04-04', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901555397419_20230415090309.jpg', '1467677', '2022-12-04', '2025-02-07', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901452976524_20230415090347.jpg', 'E05', '701240822', '1970-01-01', '2026-02-18', '1299123456BH02', '25441', '2031', '600.00', '0.00', '900.00', '150.00', 1, NULL, NULL, 1, '2023-04-17 09:05:23'),
(15, 1, '8', 'Jacques Francois Daniel Paque', 'Jacques', 'Jacques', 'Full Time', 'Expat', '11', '10', '97356412', '97358742', 'Paque@gmail.com', '1986-04-02', NULL, 'Male', '2022-08-19', NULL, 'bahrain', 'jacques', '174721552616793157081_(1)604059878_20230415085654.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, '2023-04-06 06:02:42', 32, '2023-05-06 01:10:43'),
(16, 1, '9', 'Luma Majed Aljishi', 'tester', 'yesyer', 'Full Time', 'Local', '11', '10', '97354869', '97358742', 'Aljishi@gmail.com', '1985-03-12', NULL, 'Female', '2011-04-03', NULL, 'bharain', 'luma', '1616879203504276110200_20230415083043.jpg', 'Luma Majed Aljishi', '550X50X50', '2022-07-08', '2032-07-08', 'Bahrain', '1616879203504227260624_20230415083527.jpg', '3726914', '2022-06-22', '2024-09-27', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901935132215_20230415083621.jpg', 'Luma Majed Aljishi', '701240822', '1970-01-01', '2026-07-18', 'Luma Majed Aljishi', '1299123456BH00', 'NBOBBHBMXXX', '4.00', '0.00', '0.00', '0.00', 1, 1, '2023-04-13 07:09:18', 1, '2023-04-17 09:04:05'),
(17, 1, '10', 'Manal S. Husain ', '', NULL, 'Part Time', 'Local', '15', '15', '97358643', '97389478', 'Husain@gmail.com', '1987-07-07', NULL, 'Male', '2018-06-24', NULL, 'bahrain', 'manal', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901241428479_20230415091257.jpg', 'Manal S. Husain ', 'j8555547775', '2022-03-22', '2032-03-23', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901956781577_20230415091526.jpg', '9879871', '2021-09-06', '2024-09-06', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219011647667363_20230415092006.jpg', 'Manal S. Husain ', '577454', '2021-05-05', '2024-02-10', 'Manal S. Husain ', '225467979', '5254l44', '3.00', '0.00', '300.00', '100.00', 1, 1, '2023-04-15 09:12:57', 1, '2023-04-15 09:22:09'),
(18, 1, '11', 'Santhosh Thampan', '', NULL, 'Full Time', 'Expat', '12', '16', '97358468', '97395420', 'Santhosh@gmail.com', '1979-01-02', NULL, 'Male', '1970-01-01', NULL, 'bahrain', 'thampan', '174721552616793157081_(1)144661737_20230415092834.jpg', 'Santhosh Thampan', 'P5997984', '2017-05-16', '2027-05-15', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219011851172022_20230415093007.jpg', '1858793', '2022-06-26', '2024-08-08', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901676125361_20230415093300.jpg', 'Santhosh Thampan E07', '780514742', '1970-01-01', '2026-02-08', NULL, NULL, NULL, '300.00', '50.00', '325.00', '0.00', 1, 1, '2023-04-15 09:28:34', 1, '2023-04-15 09:38:09'),
(19, 1, '12', 'Sadam Siraz Miah', '', NULL, 'Full Time', 'Expat', '12', '17', '9735847896', '97358974', 'sadam@gmail.com', '1976-09-25', NULL, 'Male', '2013-12-15', NULL, 'bahrain', 'miah', '174721552616793157081_(1)1204111706_20230415094213.jpg', 'Sadam Siraz Miah', 'EE0885271', '2020-01-28', '2025-01-27', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219011903957567_20230415094421.jpg', '3616776', '2023-03-01', '2025-02-13', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219011802302229_20230415094624.jpg', 'Sadam Siraz MiahE08', '850252644', '1970-01-01', '2027-10-13', 'Sadam Siraz Miah', '424242441', 'iu5653320', '225.00', '0.00', '225.00', '0.00', 1, 1, '2023-04-15 09:42:13', 1, '2023-04-15 09:50:25'),
(20, 1, '13', 'Rabin Rahim', '', NULL, 'Full Time', 'Expat', '12', '17', '97358474', '97398741', 'ra@gmail.com', '1979-06-19', NULL, 'Male', '2013-12-15', NULL, 'bahrain', 'rahim', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901142733384_20230415095428.jpg', 'Rabin Rahim', 'EG0973878', '2020-10-01', '2025-09-30', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901683306538_20230415095529.jpg', '3616774', '2023-03-01', '2025-02-13', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901948520522_20230415095610.jpg', 'Rabin RahimE09', '850252644', '1970-01-01', '2027-10-13', 'Rabin Rahim', 'bh53346375', '454xc5235', '225.00', '0.00', '0.00', '100.00', 1, 1, '2023-04-15 09:54:28', 1, '2023-04-15 09:58:14'),
(21, 1, '14', 'Mahmood Isa', '', NULL, 'Full Time', 'Local', '16', '18', '97329852', '97369853', 'm@gmail.com', '1984-04-24', NULL, 'Male', '2018-11-01', NULL, 'bahrain', 'mahmood', '174721552616793157081_(1)608822565_20230415100052.jpg', 'Mahmood Isa', 'R8310090', '2017-08-23', '2027-05-15', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901163674475_20230415100152.jpg', '756756756', '2022-06-26', '2024-08-08', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901798570178_20230415100338.jpg', 'Mahmood Isa E10', '780514742', '1970-01-01', '2026-02-08', 'Mahmood Isa', '54452454', '010412', '50.00', '0.00', '0.00', '0.00', 1, 1, '2023-04-15 10:00:52', 1, '2023-04-15 10:05:46'),
(22, 1, '15', 'Husain Ali Hamad', '', NULL, 'Full Time', 'Local', '12', '22', '97386949', '97309153', 'hussain@gmail.com', '1970-01-01', NULL, 'Male', '2016-04-03', NULL, 'bahrain', 'husain', '174721552616793157081_(1)65078713_20230415100834.jpg', 'Husain Ali Hamad', 'Z2425468', '2016-05-30', '2026-05-29', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901402503981_20230415100946.jpg', '56775542', '2023-02-13', '2025-01-29', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219011751333778_20230415101029.jpg', 'Husain Ali Hamad', '861375262', '1970-01-01', '2025-03-21', 'Husain Ali Hamad', '455442', '011220', '500.00', '0.00', '0.00', '0.00', 1, 1, '2023-04-15 10:08:34', 1, '2023-04-15 10:12:32'),
(23, 1, '16', 'Darusi Twaha Hamiss', '', NULL, 'Full Time', 'Expat', '12', '17', '97395897', '97356594', 'darusi@gmail.com', '1986-06-25', NULL, 'Male', '2017-06-10', NULL, 'bahrain', 'darusi', '174721552616793157081_(1)1516344154_20230415101612.jpg', 'Darusi Twaha Hamiss', 'A00157757', '2019-10-02', '2029-10-01', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901642759304_20230415101758.jpg', '5235577', '2022-10-05', '2024-10-08', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901935224943_20230415102637.jpg', 'Darusi Twaha Hamiss', '890634300', '1970-01-01', '2025-09-12', NULL, NULL, NULL, '180.00', '20.00', '0.00', '25.00', 1, 1, '2023-04-15 10:16:12', 1, '2023-04-15 10:28:06'),
(24, 1, '17', 'Sakil Abadot', '', NULL, 'Full Time', 'Expat', '12', '17', '97358479', '97358479', 'sakil@gmail.com', '1970-01-01', NULL, 'Male', '2017-01-12', NULL, 'bahrain', 'abadot', '174721552616793157081_(1)2065926582_20230415103022.jpg', 'Sakil Abadot', 'BX0697750', '2018-11-01', '2023-10-31', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219011667399271_20230415103112.jpg', '4115422', '2022-11-16', '2024-12-04', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219011416842118_20230415103156.jpg', 'Sakil Abadot E13', '900193468', '1970-01-01', '1970-01-01', 'Sakil Abadot', '234565765uj', '12442', '200.00', '0.00', '0.00', '0.00', 1, 1, '2023-04-15 10:30:22', 1, '2023-04-15 10:33:41'),
(25, 1, '18', 'Akther Hossain Abu Tahir', '', NULL, 'Full Time', 'Expat', '12', '17', '97358415', '97385479', 'akther@gmail.com', '1982-02-19', NULL, 'Male', '2012-06-01', NULL, 'bahrain', 'tahir', '174721552616793157081_(1)719207082_20230415103737.jpg', 'Akther Hossain Abu Tahir', 'EE0035130', '2019-09-25', '2024-09-24', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219012016639758_20230415103844.jpg', '3372424', '2022-10-02', '2024-10-01', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901284054545_20230415103917.jpg', NULL, NULL, NULL, NULL, 'Akther Hossain Abu Tahir', '2434225778', '4421', '200.00', '25.00', '20.00', '20.00', 1, 1, '2023-04-15 10:37:37', 1, '2023-04-15 10:40:44'),
(26, 1, '19', 'Manu Eliyan', '', NULL, 'Full Time', 'Expat', '12', '17', '97389759', '97398429', 'manu@gmail.com', '1976-12-29', NULL, 'Male', '2019-01-02', NULL, 'bahrain', '', '174721552616793157081_(1)788360449_20230415104320.jpg', 'Manu Eliyan', 'N5312548', '2015-12-02', '2025-12-01', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901202568112_20230415104424.jpg', '4524845', '2023-02-13', '2025-01-29', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219011310469460_20230415104458.jpg', 'Manu Eliyan E15', '861375262', '1970-01-01', '2024-03-04', 'Manu Eliyan', '87976542', '1012', '200.00', '0.00', '0.00', '0.00', 1, 1, '2023-04-15 10:43:20', 1, '2023-04-15 10:46:26'),
(27, 1, '20', 'Albert Lucky', '', NULL, 'Full Time', 'Expat', '12', '17', '97385946', '97398746', 'albert12@gmail.com', '0000-00-00', NULL, 'Male', '2020-07-05', NULL, 'bahrain', 'lucky', '174721552616793157081_(1)1329972379_20230415104813.jpg', 'Albert Lucky', 'N5312548', '2015-12-02', '2025-12-01', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901716207691_20230415104908.jpg', '4524845', '2023-02-13', '2025-01-29', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219011154987517_20230415104943.jpg', 'Albert Lucky E16', '861375262', '1970-01-01', '2024-03-04', 'Albert Lucky', '967876554', '2235', '200.00', '200.00', '0.00', '0.00', 1, 1, '2023-04-15 10:48:13', 1, '2023-04-15 10:52:36'),
(28, 1, '21', 'Yusuf Alnajjar', '', NULL, 'Full Time', 'Local', '12', '20', '97389746', '97302687', 'yusuf@gmail.com', '1976-06-19', NULL, 'Male', '2021-07-01', NULL, 'bahrain', 'alnajjar', '174721552616793157081_(1)1893047162_20230415105541.jpg', 'Yusuf Alnajjar', 'BX0697750', '2018-11-01', '2023-10-31', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219011528601837_20230415105635.jpg', '4115422', '2022-11-16', '2024-12-04', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219011012581405_20230415105710.jpg', 'Yusuf Alnajjar E17', '900193468', '1970-01-01', '2027-02-15', 'Yusuf Alnajjar', '564452', '2000', '350.00', '0.00', '0.00', '0.00', 1, 1, '2023-04-15 10:55:41', 1, '2023-04-15 10:58:46'),
(29, 1, '22', 'Khalid Habib', '', NULL, 'Full Time', 'Expat', '12', '21', '97369855', '97398654', 'khalid@gmail.com', '1985-08-05', NULL, 'Male', '2021-07-15', NULL, 'bahrain', 'habib', '174721552616793157081_(1)1892983642_20230415110128.jpg', 'Khalid Habib', 'AC6034373', '2019-04-24', '2024-04-22', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219011083181803_20230415110251.jpg', '1671830', '2022-11-16', '2024-12-07', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219011485778149_20230415110348.jpg', 'Khalid Habib E18', '761127267', '1970-01-01', '2026-01-14', 'Khalid Habib', '6787365454', '2323', '450.00', '0.00', '0.00', '0.00', 1, 1, '2023-04-15 11:01:28', 1, '2023-04-15 11:05:41'),
(30, 1, '23', 'Jahan Zaib', '', NULL, 'Full Time', 'Expat', '12', '23', '97369857', '97389756', 'jahan@gmail.com', '1986-05-18', NULL, 'Male', '2021-11-03', NULL, 'bahrain', 'azhar', '174721552616793157081_(1)78884931_20230415111408.jpg', 'Jahan Zaib', 'AB5936064', '2019-07-01', '2024-06-29', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219011119254216_20230415111644.jpg', '1569027', '2022-11-16', '2024-12-05', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901562919924_20230415111716.jpg', 'Jahan Zaib', '851228216', '1970-01-01', '1970-01-01', 'Jahan Zaib', '655645452', '00102', '900.00', '0.00', '0.00', '0.00', 1, 1, '2023-04-15 11:14:08', 1, '2023-04-15 11:18:36'),
(31, 1, '24', 'Shella Mangubat', '', NULL, 'Full Time', 'Expat', '12', '24', '97365444', '973654894', 'shella@gmail.com', '1989-07-06', NULL, 'Female', '2022-03-09', NULL, 'bahrain', 'shella', '1616879203504420961766_20230415112433.jpg', 'Shella Mangubat', 'P1088288B', '2019-03-18', '2029-03-17', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901954695925_20230415112535.jpg', '3787679', '2022-04-04', '2023-04-04', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901520163924_20230415112609.jpg', 'Shella Mangubat', '870588532', '1970-01-01', '2026-03-29', 'Shella Mangubat', '78765637532', '2322', '350.00', '0.00', '0.00', '0.00', 1, 1, '2023-04-15 11:24:33', 1, '2023-04-15 11:28:03'),
(32, 1, '25', 'Ramesh Pillia', '', NULL, 'Full Time', 'Expat', '12', '17', '97369852', '97398465', 'ramesh@gmail.com', '1989-12-12', NULL, 'Male', '2022-04-13', NULL, 'bahrain', 'ramesh', '174721552616793157081_(1)1410376009_20230415113026.jpg', 'Ramesh Pillia', 'U0436538', '2019-09-03', '2029-09-02', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901272685950_20230415113118.jpg', '3624220', '2022-05-08', '2023-05-08', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219011836015391_20230415113155.jpg', 'Ramesh Pillia', '820943215', '1970-01-01', '2027-07-03', 'Ramesh Pillia', '567867867', '2020', '225.00', '0.00', '0.00', '0.00', 1, 1, '2023-04-15 11:30:26', 1, '2023-04-15 11:33:38'),
(33, 1, '26', 'Ahmed Adbulla Habib', 'aaaa', 'aaaaaa', 'Full Time', 'Local', '12', '20', '97389756', '97398412', 'ahmed@gmail.com', '1980-10-11', '', 'Male', '2023-03-01', NULL, 'bahrain', 'azhar', '174721552616793157081_(1)712584769_20230415113546.jpg', 'Ahmed Adbulla Habib', 'Z2425468', '2016-05-30', '2026-05-29', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901264916443_20230415113632.jpg', '756767675', '2022-06-26', '2024-08-08', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901890441702_20230415113735.jpg', 'Ahmed Adbulla Habib', '780514742', '1970-01-01', '2024-06-06', 'Ahmed Adbulla Habib', '8796876876', '2242', '380.00', '0.00', '0.00', '0.00', 1, 1, '2023-04-15 11:35:46', 36, '2024-04-10 10:38:00'),
(34, 1, '27', 'Vachery Mohamed Aashique ', '', NULL, 'Full Time', 'Expat', '11', '23', '97398656', '97398564', 'Vachery @gmail.com', '1985-04-09', NULL, 'Male', '2023-03-01', NULL, 'bahrain', 'Vachery ', '174721552616793157081_(1)604608095_20230415114036.jpg', 'Vachery Mohamed Aashique ', 'Z2425468', '2016-05-30', '2026-05-29', 'bahrain', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_6921901217189031_20230415114118.jpg', '-', '1970-01-01', '1970-01-01', 'experience_certificate_template_luxury_elegant_curves_calligraphy_stamp_decor_69219011632166589_20230415114143.jpg', 'Vachery Mohamed Aashique ', '700523197', '1970-01-01', '2025-05-20', 'Vachery Mohamed Aashique ', '786767325', '0021', '700.00', '0.00', '0.00', '0.00', 1, 1, '2023-04-15 11:40:36', 1, '2023-04-15 11:43:05');

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

--
-- Table structure for table `employee_certificate`
--

CREATE TABLE `employee_certificate` (
  `id` int NOT NULL,
  `certificate_emp_id` int DEFAULT NULL,
  `certificate_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `certificate_image` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employee_certificate`
--

INSERT INTO `employee_certificate` (`id`, `certificate_emp_id`, `certificate_name`, `certificate_image`, `created_at`, `created_by`) VALUES
(1, 71, 'test', 'pone_0067650_t00299558706_20230406095142.png', '2023-04-06 09:51:42', 32);

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

--
-- Table structure for table `financialyear`
--

CREATE TABLE `financialyear` (
  `yearid` int NOT NULL,
  `startyear` year NOT NULL,
  `endyear` year NOT NULL,
  `company_id` int NOT NULL,
  `startdate` date NOT NULL,
  `enddate` date NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `comp` tinyint(1) NOT NULL,
  `createdBy` int NOT NULL,
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modifiedBy` int NOT NULL,
  `modifiedTime` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `financialyear`
--

INSERT INTO `financialyear` (`yearid`, `startyear`, `endyear`, `company_id`, `startdate`, `enddate`, `status`, `comp`, `createdBy`, `modifiedBy`, `modifiedTime`) VALUES
(1, 2024, 2025, 2, '2024-04-01', '2025-03-31', 0, 1, 0, 0, NULL),
(2, 2024, 2025, 1, '2024-04-01', '2025-03-31', 0, 0, 0, 0, NULL),
(3, 2024, 2024, 2, '2024-04-05', '2024-04-13', 0, 0, 0, 0, NULL);

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

--
-- Table structure for table `gdn`
--

CREATE TABLE `gdn` (
  `gdnid` int NOT NULL,
  `gdnnumber` varchar(100) NOT NULL,
  `salesinvoiceid` int NOT NULL,
  `company_id` int NOT NULL,
  `customerid` int NOT NULL,
  `issuedate` date NOT NULL,
  `vat` varchar(255) NOT NULL,
  `totalquantity` int NOT NULL,
  `totaldispatched` int NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `createdBy` int NOT NULL,
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modifiedBy` int NOT NULL,
  `modifiedTime` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `gdnrecords`
--

CREATE TABLE `gdnrecords` (
  `gdnid` int NOT NULL,
  `itemid` int DEFAULT NULL,
  `dispatched` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `grn`
--

CREATE TABLE `grn` (
  `grnid` int NOT NULL,
  `company_id` int NOT NULL,
  `grnnumber` varchar(100) NOT NULL,
  `purchaseordernum` varchar(100) NOT NULL,
  `batch_refno` varchar(255) DEFAULT NULL,
  `supplierid` int NOT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `issuedate` date NOT NULL,
  `totalquantity` int NOT NULL,
  `totaldifference` int NOT NULL,
  `totalrejected` int NOT NULL,
  `totalaccepted` int NOT NULL,
  `pdf` varchar(255) DEFAULT NULL,
  `notes` text NOT NULL,
  `receivedby` varchar(100) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modifiedTime` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grn`
--

INSERT INTO `grn` (`grnid`, `company_id`, `grnnumber`, `purchaseordernum`, `batch_refno`, `supplierid`, `currency`, `issuedate`, `totalquantity`, `totaldifference`, `totalrejected`, `totalaccepted`, `pdf`, `notes`, `receivedby`, `status`, `modifiedTime`) VALUES
(1, 2, '1', '1', 'AD510918205002', 1, 'INR', '2024-07-06', 43, 2, 2, 41, '1-LISTOFPARTICIPATINGPOLITICALANDABBREVATIONS_ver4_3757186820_20240705180711.pdf', 'testings', 'testings', 0, NULL),
(2, 2, '2', '2', 'AD510918205004', 2, 'USA', '2024-07-06', 20, 0, 2, 18, '1-LISTOFPARTICIPATINGPOLITICALANDABBREVATIONS_ver4_3425463758_20240705180824.pdf', 'testings', 'testings', 0, NULL);

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

--
-- Table structure for table `grnrecords`
--

CREATE TABLE `grnrecords` (
  `grnid` int NOT NULL,
  `itemid` int NOT NULL,
  `itemname` varchar(255) DEFAULT NULL,
  `description` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `unit` varchar(255) DEFAULT NULL,
  `received` int DEFAULT NULL,
  `difference` int NOT NULL,
  `rejected` int NOT NULL,
  `accepted` int NOT NULL,
  `sellerprice` varchar(255) DEFAULT NULL,
  `unitprice` varchar(255) DEFAULT NULL,
  `costprice` decimal(10,3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `grnrecords`
--

INSERT INTO `grnrecords` (`grnid`, `itemid`, `itemname`, `description`, `unit`, `received`, `difference`, `rejected`, `accepted`, `sellerprice`, `unitprice`, `costprice`) VALUES
(1, 1, 'Testing', 'goods product', 'KG', 15, 0, 1, 14, '280.000', '300.000', '288.406'),
(1, 2, 'Addobyte', 'goods product', 'Litter', 13, 2, 0, 13, '140.000', '150.000', '148.406'),
(1, 3, 'test', 'goods product', 'KG', 15, 0, 1, 14, '140.000', '150.000', '148.406'),
(2, 2, 'Addobyte', 'goods product', 'Litter', 10, 0, 1, 9, '135.000', '150.000', '240.867'),
(2, 3, 'test', 'goods product', 'KG', 10, 0, 1, 9, '140.000', '150.000', '245.867');

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

--
-- Table structure for table `itemmaster`
--

CREATE TABLE `itemmaster` (
  `itemid` int NOT NULL,
  `itemcode` varchar(100) NOT NULL,
  `company_id` int NOT NULL,
  `itemname` varchar(100) NOT NULL,
  `category` varchar(100) NOT NULL,
  `subcategory` varchar(100) NOT NULL,
  `brand` varchar(100) NOT NULL,
  `costprice` decimal(10,3) NOT NULL,
  `price` decimal(10,3) NOT NULL,
  `unit` varchar(255) DEFAULT NULL,
  `accountname` int NOT NULL,
  `tax` int NOT NULL,
  `quantity` int NOT NULL,
  `product_origin` varchar(100) NOT NULL,
  `batch_ref` varchar(255) DEFAULT NULL,
  `location` varchar(100) NOT NULL,
  `min_reorder` int NOT NULL,
  `item_type` int NOT NULL COMMENT '1-purchase,2-sales',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `createdBy` int NOT NULL,
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modifiedBy` int NOT NULL,
  `modifiedTime` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `itemmaster`
--

INSERT INTO `itemmaster` (`itemid`, `itemcode`, `company_id`, `itemname`, `category`, `subcategory`, `brand`, `costprice`, `price`, `unit`, `accountname`, `tax`, `quantity`, `product_origin`, `batch_ref`, `location`, `min_reorder`, `item_type`, `status`, `createdBy`, `modifiedBy`, `modifiedTime`) VALUES
(1, '5002', 2, 'Testing', 'testing', 'test', 'Indian', '300.000', '280.000', 'KG', 100, 10, 241, 'India', 'AD510918205002', 'Chennai', 200, 3, 0, 0, 0, NULL),
(2, '5003', 2, 'Addobyte', 'test7', 'test', 'Vadapalani', '150.000', '135.000', 'Litter', 100, 15, 166, 'India', 'AD510918205004', 'Chennai', 200, 3, 0, 0, 0, NULL),
(3, '5004', 2, 'test', 'testing', 'testings', 'Indian', '150.000', '140.000', 'KG', 100, 15, 283, 'India', 'AD510918205004', 'Chennai', 50, 3, 0, 0, 0, NULL);

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

--
-- Table structure for table `loan_master`
--

CREATE TABLE `loan_master` (
  `id` int NOT NULL,
  `employee_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `monthly_salery` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_of_request` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `loan_amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `loan_balance_amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `installment_month` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `emi` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `accounts_feedback` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `previous_loan_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `loan_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime(6) DEFAULT NULL,
  `updated_at` datetime(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `loan_payment_history`
--

CREATE TABLE `loan_payment_history` (
  `id` int NOT NULL,
  `payment_loan_id` int DEFAULT NULL,
  `payment_date` date DEFAULT NULL,
  `payment_amount` int DEFAULT NULL,
  `payment_method` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `payment_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `created_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `maingroup`
--

CREATE TABLE `maingroup` (
  `groupid` int NOT NULL,
  `groupname` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `maingroup`
--

INSERT INTO `maingroup` (`groupid`, `groupname`) VALUES
(1, 'Balance Sheet'),
(2, 'Profit & Loss');

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

--
-- Table structure for table `openingbalance`
--

CREATE TABLE `openingbalance` (
  `company_id` int NOT NULL,
  `yearid` int NOT NULL,
  `accountname` int NOT NULL,
  `debit` decimal(10,2) NOT NULL,
  `credit` decimal(10,2) NOT NULL,
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `purchaseinvoice`
--

CREATE TABLE `purchaseinvoice` (
  `purchaseinvoiceid` int NOT NULL,
  `invoicenumber` varchar(20) NOT NULL,
  `number` varchar(255) DEFAULT NULL,
  `ordernum` varchar(100) NOT NULL,
  `grnnumber` varchar(100) NOT NULL,
  `bl_date` varchar(255) DEFAULT NULL,
  `bl_pdf` varchar(255) DEFAULT NULL,
  `payment_date` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `vat` decimal(10,3) NOT NULL,
  `company_id` int NOT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `invoicedate` date NOT NULL,
  `customerid` int NOT NULL,
  `totalamount` decimal(10,3) NOT NULL,
  `subtotal` decimal(10,3) NOT NULL,
  `initiatedby` varchar(255) DEFAULT NULL,
  `payment_terms` varchar(255) DEFAULT NULL,
  `incoterms` varchar(255) DEFAULT NULL,
  `transport_name` varchar(255) DEFAULT NULL,
  `discount` decimal(10,3) DEFAULT NULL,
  `duty` decimal(10,3) DEFAULT NULL,
  `freight_charge` decimal(10,3) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `pdf` varchar(255) DEFAULT NULL,
  `preparedby` varchar(100) NOT NULL,
  `createdBy` int DEFAULT NULL,
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modifiedBy` int NOT NULL,
  `modifiedTime` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `purchaseinvoicerecords`
--

CREATE TABLE `purchaseinvoicerecords` (
  `invoiceid` int NOT NULL,
  `itemcode` varchar(255) NOT NULL,
  `unit` varchar(255) DEFAULT NULL,
  `itemname` varchar(255) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `quantity` int NOT NULL,
  `sellerprice` decimal(10,3) DEFAULT NULL,
  `unitprice` decimal(10,3) NOT NULL,
  `amount` decimal(10,3) NOT NULL,
  `bd_total` decimal(10,3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `purchaseorder`
--

CREATE TABLE `purchaseorder` (
  `purchaseorderid` int NOT NULL,
  `purchaseordernum` varchar(100) NOT NULL,
  `quoteno` int NOT NULL,
  `company_id` int NOT NULL,
  `issuedate` date NOT NULL,
  `deliverydate` date NOT NULL,
  `supplier` int NOT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `bahraini_dinar` decimal(10,4) DEFAULT NULL,
  `initiatedby` varchar(255) DEFAULT NULL,
  `quote_from` varchar(11) DEFAULT NULL,
  `vat` decimal(10,3) NOT NULL,
  `subtotal` decimal(10,3) NOT NULL,
  `discount` decimal(10,3) DEFAULT NULL,
  `duty` decimal(10,3) DEFAULT NULL,
  `freight_charge` decimal(10,3) DEFAULT NULL,
  `totalamount` decimal(10,3) NOT NULL,
  `pdf` varchar(255) DEFAULT NULL,
  `terms` text NOT NULL,
  `preparedby` varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modifiedTime` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `purchaseorder`
--

INSERT INTO `purchaseorder` (`purchaseorderid`, `purchaseordernum`, `quoteno`, `company_id`, `issuedate`, `deliverydate`, `supplier`, `currency`, `bahraini_dinar`, `initiatedby`, `quote_from`, `vat`, `subtotal`, `discount`, `duty`, `freight_charge`, `totalamount`, `pdf`, `terms`, `preparedby`, `status`, `modifiedTime`) VALUES
(1, '1', 1, 2, '2024-07-06', '2024-07-10', 1, 'INR', '0.0045', 'Sulaiman', '1', '3.580', '37.800', '2.000', '0.000', '30.000', '69.380', NULL, 'testings', 'Arunkumar', 0, NULL),
(2, '2', 2, 2, '2024-07-06', '2024-07-10', 2, 'USA', '0.3800', 'Sulaiman', '1', '104.000', '1045.000', '5.000', '0.000', '20.000', '1164.000', '1-LISTOFPARTICIPATINGPOLITICALANDABBREVATIONS_ver4_3620540099_20240705180523.pdf', 'testings', 'addobyte', 0, NULL);

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

--
-- Table structure for table `purchaseorderrecords`
--

CREATE TABLE `purchaseorderrecords` (
  `purchaseorderid` int NOT NULL,
  `itemcode` int NOT NULL,
  `itemname` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `quantity` int NOT NULL,
  `sellerprice` decimal(10,3) DEFAULT NULL,
  `unit` varchar(255) DEFAULT NULL,
  `unitprice` decimal(10,3) NOT NULL,
  `amount` decimal(10,3) NOT NULL,
  `bd_total` decimal(10,3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `purchaseorderrecords`
--

INSERT INTO `purchaseorderrecords` (`purchaseorderid`, `itemcode`, `itemname`, `description`, `quantity`, `sellerprice`, `unit`, `unitprice`, `amount`, `bd_total`) VALUES
(1, 1, 'Testing', 'goods product', 15, '280.000', 'KG', '300.000', '4200.000', '18.900'),
(1, 2, 'Addobyte', 'goods product', 15, '140.000', 'Litter', '150.000', '2100.000', '9.450'),
(1, 3, 'test', 'goods product', 15, '140.000', 'KG', '150.000', '2100.000', '9.450'),
(2, 2, 'Addobyte', 'goods product', 10, '135.000', 'Litter', '150.000', '1350.000', '513.000'),
(2, 3, 'test', 'goods product', 10, '140.000', 'KG', '150.000', '1400.000', '532.000');

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

--
-- Table structure for table `purchasequote`
--

CREATE TABLE `purchasequote` (
  `purchasequoteid` int NOT NULL,
  `reference_no` int NOT NULL,
  `quote_from` varchar(255) DEFAULT NULL,
  `quotenumber` int NOT NULL,
  `bl_date` varchar(255) DEFAULT NULL,
  `bl_pdf` varchar(255) DEFAULT NULL,
  `payment_date` int DEFAULT NULL,
  `quotedate` date NOT NULL,
  `company_id` int NOT NULL,
  `customerid` int DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `bahraini_dinar` decimal(10,4) DEFAULT NULL,
  `initiatedby` varchar(200) NOT NULL,
  `vat` decimal(10,3) NOT NULL,
  `subtotal` decimal(10,3) NOT NULL,
  `totalamount` decimal(10,3) DEFAULT NULL,
  `discount` decimal(10,3) DEFAULT NULL,
  `freight_charge` decimal(10,3) DEFAULT NULL,
  `duty` decimal(10,3) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `pdf` varchar(255) DEFAULT NULL,
  `preparedby` varchar(100) NOT NULL,
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modifiedTime` varchar(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `purchasequote`
--

INSERT INTO `purchasequote` (`purchasequoteid`, `reference_no`, `quote_from`, `quotenumber`, `bl_date`, `bl_pdf`, `payment_date`, `quotedate`, `company_id`, `customerid`, `currency`, `bahraini_dinar`, `initiatedby`, `vat`, `subtotal`, `totalamount`, `discount`, `freight_charge`, `duty`, `status`, `pdf`, `preparedby`, `modifiedTime`) VALUES
(1, 1, '1', 1, NULL, NULL, NULL, '2024-07-05', 2, 1, 'INR', '0.0045', 'Sulaiman', '3.580', '37.800', '69.380', '2.000', '30.000', '0.000', 0, '1-LISTOFPARTICIPATINGPOLITICALANDABBREVATIONS_ver4_31545969428_20240705180330.pdf', 'Arunkumar', ''),
(2, 2, '1', 2, NULL, NULL, NULL, '2024-07-05', 2, 2, 'USA', '0.3800', 'Sulaiman', '104.000', '1045.000', '1164.000', '5.000', '20.000', '0.000', 0, '3268233490_20240705180427.pdf', 'addobyte', ''),
(3, 3, '1', 3, NULL, NULL, NULL, '2024-07-06', 2, 2, 'USA', '0.3800', 'Arunkumar', '519.600', '5206.000', '7815.600', '10.000', '2100.000', '0.000', 0, 'agreement_ARUNKUMAR_R_17127402132035390734_20240706110350.pdf', 'addobyte', ''),
(4, 1, '1', 4, NULL, NULL, NULL, '2024-07-09', 2, 1, 'INR', '0.0045', 'Sulaiman', '2.726', '37.260', '59.986', '10.000', '30.000', '0.000', 0, NULL, 'Arunkumar RD', '');

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

--
-- Table structure for table `purchasequoterecords`
--

CREATE TABLE `purchasequoterecords` (
  `quoteid` int NOT NULL,
  `reference_no` int DEFAULT NULL,
  `supplier` varchar(255) DEFAULT NULL,
  `itemcode` int NOT NULL,
  `itemname` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `quantity` int NOT NULL,
  `unit` varchar(255) DEFAULT NULL,
  `sellerprice` decimal(10,3) DEFAULT NULL,
  `unitprice` decimal(10,3) NOT NULL,
  `amount` decimal(10,3) NOT NULL,
  `bd_total` decimal(10,3) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `purchasequoterecords`
--

INSERT INTO `purchasequoterecords` (`quoteid`, `reference_no`, `supplier`, `itemcode`, `itemname`, `description`, `quantity`, `unit`, `sellerprice`, `unitprice`, `amount`, `bd_total`) VALUES
(1, 1, '1', 1, 'Testing', 'goods product', 15, 'KG', '280.000', '300.000', '4200.000', '18.900'),
(1, 1, '1', 2, 'Addobyte', 'goods product', 15, 'Litter', '140.000', '150.000', '2100.000', '9.450'),
(1, 1, '1', 3, 'test', 'goods product', 15, 'KG', '140.000', '150.000', '2100.000', '9.450'),
(2, 2, '2', 2, 'Addobyte', 'goods product', 10, 'Litter', '135.000', '150.000', '1350.000', '513.000'),
(2, 2, '2', 3, 'test', 'goods product', 10, 'KG', '140.000', '150.000', '1400.000', '532.000'),
(3, 3, '2', 1, 'Testing', 'goods product', 30, 'KG', '270.000', '300.000', '8100.000', '3078.000'),
(3, 3, '2', 3, 'test', 'goods product', 40, 'KG', '140.000', '150.000', '5600.000', '2128.000'),
(4, 1, '1', 1, 'Testing', 'good', 15, 'KG', '280.000', '300.000', '4200.000', '18.900'),
(4, 1, '1', 2, 'Addobyte', 'good', 15, 'Litter', '130.000', '150.000', '1950.000', '8.775'),
(4, 1, '1', 3, 'test', 'good', 15, 'KG', '142.000', '150.000', '2130.000', '9.585');

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

--
-- Table structure for table `salesinvoice`
--

CREATE TABLE `salesinvoice` (
  `salesinvoiceid` int NOT NULL,
  `invoicenumber` varchar(20) NOT NULL,
  `ordernum` varchar(100) NOT NULL,
  `company_id` int NOT NULL,
  `invoicedate` date NOT NULL,
  `customerid` int NOT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `vat` decimal(10,3) NOT NULL,
  `subtotal` decimal(10,3) NOT NULL,
  `totalamount` decimal(10,3) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `preparedby` varchar(100) NOT NULL,
  `authorizedby` varchar(100) NOT NULL,
  `payment_terms` varchar(255) DEFAULT NULL,
  `incoterms` varchar(255) DEFAULT NULL,
  `ship_via` varchar(255) DEFAULT NULL,
  `validityperiod` varchar(255) DEFAULT NULL,
  `deliveryperiod` varchar(255) DEFAULT NULL,
  `bill_laddingno` varchar(255) DEFAULT NULL,
  `total_netweight` varchar(255) DEFAULT NULL,
  `container_no` varchar(255) DEFAULT NULL,
  `gross_weight` varchar(255) DEFAULT NULL,
  `seal_no` varchar(255) DEFAULT NULL,
  `rolls` varchar(255) DEFAULT NULL,
  `custom_hscode` varchar(255) DEFAULT NULL,
  `pallets` varchar(255) DEFAULT NULL,
  `loading_port` varchar(255) DEFAULT NULL,
  `otherterms` varchar(255) DEFAULT NULL,
  `discharge_port` varchar(255) DEFAULT NULL,
  `beneficiary_name` varchar(255) DEFAULT NULL,
  `conditions` text NOT NULL,
  `quickinvoice` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-normal,1-quick',
  `bank_name` varchar(100) DEFAULT NULL,
  `account_num` varchar(100) DEFAULT NULL,
  `createdat` varchar(255) NOT NULL,
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modifiedBy` int NOT NULL,
  `modifiedTime` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesinvoice`
--

INSERT INTO `salesinvoice` (`salesinvoiceid`, `invoicenumber`, `ordernum`, `company_id`, `invoicedate`, `customerid`, `currency`, `vat`, `subtotal`, `totalamount`, `status`, `preparedby`, `authorizedby`, `payment_terms`, `incoterms`, `ship_via`, `validityperiod`, `deliveryperiod`, `bill_laddingno`, `total_netweight`, `container_no`, `gross_weight`, `seal_no`, `rolls`, `custom_hscode`, `pallets`, `loading_port`, `otherterms`, `discharge_port`, `beneficiary_name`, `conditions`, `quickinvoice`, `bank_name`, `account_num`, `createdat`, `modifiedBy`, `modifiedTime`) VALUES
(1, '1', '1', 2, '2024-07-10', 2, 'USA', '617.400', '6174.000', '6791.400', 0, 'addobyte', '', '90 Days', 'CIF', 'Hand Delivery', '14 days', '1 week', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'testing', NULL, NULL, '', 0, NULL, NULL, '', 0, NULL);

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

--
-- Table structure for table `salesinvoicerecords`
--

CREATE TABLE `salesinvoicerecords` (
  `invoiceid` int NOT NULL,
  `itemcode` int NOT NULL,
  `itemname` varchar(255) NOT NULL,
  `quantity` int NOT NULL,
  `unit` varchar(255) DEFAULT NULL,
  `unitprice` decimal(10,3) NOT NULL,
  `amount` decimal(10,3) NOT NULL,
  `description` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesinvoicerecords`
--

INSERT INTO `salesinvoicerecords` (`invoiceid`, `itemcode`, `itemname`, `quantity`, `unit`, `unitprice`, `amount`, `description`) VALUES
(1, 1, 'Testing', 10, NULL, '280.000', '6174.000', '');

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

--
-- Table structure for table `salesorder`
--

CREATE TABLE `salesorder` (
  `salesorderid` int NOT NULL,
  `company_id` int NOT NULL,
  `salesordernum` varchar(100) NOT NULL,
  `quoteno` int NOT NULL,
  `issuedate` date NOT NULL,
  `deliverydate` date NOT NULL,
  `validityperiod` varchar(255) DEFAULT NULL,
  `deliveryperiod` varchar(255) DEFAULT NULL,
  `customer` int NOT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `vat` varchar(255) NOT NULL,
  `subtotal` decimal(10,3) DEFAULT NULL,
  `totalamount` decimal(10,2) NOT NULL,
  `ship_via` varchar(255) DEFAULT NULL,
  `payment_terms` varchar(255) DEFAULT NULL,
  `incoterms` varchar(255) DEFAULT NULL,
  `bill_laddingno` varchar(255) DEFAULT NULL,
  `total_netweight` varchar(255) DEFAULT NULL,
  `container_no` varchar(255) DEFAULT NULL,
  `gross_weight` varchar(255) DEFAULT NULL,
  `seal_no` varchar(255) DEFAULT NULL,
  `rolls` varchar(255) DEFAULT NULL,
  `custom_hscode` varchar(255) DEFAULT NULL,
  `pallets` varchar(255) DEFAULT NULL,
  `loading_port` varchar(255) DEFAULT NULL,
  `discharge_port` varchar(255) DEFAULT NULL,
  `beneficiary_name` varchar(255) DEFAULT NULL,
  `otherterms` longtext,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `createdBy` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modifiedBy` int NOT NULL,
  `modifiedTime` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesorder`
--

INSERT INTO `salesorder` (`salesorderid`, `company_id`, `salesordernum`, `quoteno`, `issuedate`, `deliverydate`, `validityperiod`, `deliveryperiod`, `customer`, `currency`, `vat`, `subtotal`, `totalamount`, `ship_via`, `payment_terms`, `incoterms`, `bill_laddingno`, `total_netweight`, `container_no`, `gross_weight`, `seal_no`, `rolls`, `custom_hscode`, `pallets`, `loading_port`, `discharge_port`, `beneficiary_name`, `otherterms`, `status`, `modifiedBy`, `modifiedTime`) VALUES
(1, 2, '1', 1, '2024-07-05', '2023-07-17', '14 days', '1 week', 2, 'USA', '617.40', '6174.000', '6791.40', 'Hand Delivery', '90 Days', 'CIF', '5', '25', '2ss', '60ss', '3', '20ss', 'ASDS89756FRG', '4', '2ss', '3ss', 'arun', 'testing', 0, 0, NULL);

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

--
-- Table structure for table `salesorderrecords`
--

CREATE TABLE `salesorderrecords` (
  `salesorderid` int NOT NULL,
  `itemcode` int NOT NULL,
  `itemname` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `quantity` int NOT NULL,
  `unitprice` decimal(10,3) NOT NULL,
  `unit` varchar(255) DEFAULT NULL,
  `amount` decimal(10,3) NOT NULL,
  `lbs` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesorderrecords`
--

INSERT INTO `salesorderrecords` (`salesorderid`, `itemcode`, `itemname`, `description`, `quantity`, `unitprice`, `unit`, `amount`, `lbs`) VALUES
(1, 1, 'Testing', 'testiung', 10, '280.000', NULL, '6174.000', '22.05');

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

--
-- Table structure for table `salesquote`
--

CREATE TABLE `salesquote` (
  `salesquoteid` int NOT NULL,
  `company_id` int NOT NULL,
  `quotenumber` varchar(20) NOT NULL,
  `quotedate` date NOT NULL,
  `customerid` int NOT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `vat` decimal(10,3) NOT NULL,
  `subtotal` decimal(10,3) NOT NULL,
  `totalamount` decimal(10,3) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `payment_terms` varchar(255) DEFAULT NULL,
  `incoterms` varchar(255) DEFAULT NULL,
  `transport_name` varchar(255) DEFAULT NULL,
  `preparedby` varchar(100) NOT NULL,
  `validityperiod` varchar(200) NOT NULL,
  `deliveryperiod` varchar(200) NOT NULL,
  `otherterms` text NOT NULL,
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modifiedBy` int NOT NULL,
  `modifiedTime` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesquote`
--

INSERT INTO `salesquote` (`salesquoteid`, `company_id`, `quotenumber`, `quotedate`, `customerid`, `currency`, `vat`, `subtotal`, `totalamount`, `status`, `payment_terms`, `incoterms`, `transport_name`, `preparedby`, `validityperiod`, `deliveryperiod`, `otherterms`, `modifiedBy`, `modifiedTime`) VALUES
(1, 2, '1', '2024-07-10', 2, 'USA', '1234.800', '12348.000', '13582.800', 0, '90 Days', 'CIF', 'Hand Delivery', 'addobyte', '14 days', '1 week', 'testing', 0, NULL);

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

--
-- Table structure for table `salesquoterecords`
--

CREATE TABLE `salesquoterecords` (
  `quoteid` int NOT NULL,
  `itemcode` int NOT NULL,
  `itemname` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `unitprice` decimal(10,3) NOT NULL,
  `unit` varchar(255) DEFAULT NULL,
  `quantity` decimal(10,3) NOT NULL,
  `lbs` decimal(10,3) DEFAULT NULL,
  `amount` decimal(10,3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salesquoterecords`
--

INSERT INTO `salesquoterecords` (`quoteid`, `itemcode`, `itemname`, `description`, `unitprice`, `unit`, `quantity`, `lbs`, `amount`) VALUES
(1, 1, 'Testing', 'testiung', '280.000', NULL, '20.000', '44.100', '12348.000');

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

--
-- Table structure for table `services_invoice`
--

CREATE TABLE `services_invoice` (
  `reference_no` int NOT NULL,
  `company_id` varchar(11) DEFAULT NULL,
  `supplier_invoiceno` varchar(255) DEFAULT NULL,
  `supplier_invoicedate` varchar(255) DEFAULT NULL,
  `grnnumber` int DEFAULT NULL,
  `customername` varchar(255) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `bahraini_dinar` varchar(255) DEFAULT NULL,
  `initiatedby` varchar(255) DEFAULT NULL,
  `payment_terms` varchar(255) DEFAULT NULL,
  `incoterms` varchar(255) DEFAULT NULL,
  `transport_name` varchar(255) DEFAULT NULL,
  `preparedby` varchar(255) DEFAULT NULL,
  `pdf` varchar(255) DEFAULT NULL,
  `subtotal` decimal(10,3) DEFAULT NULL,
  `discount` decimal(10,3) DEFAULT NULL,
  `vat_amount` decimal(10,3) DEFAULT NULL,
  `duty` decimal(10,3) DEFAULT NULL,
  `freight_charge` decimal(10,3) DEFAULT NULL,
  `totalamount` decimal(10,3) DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modifiedTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `services_invoice`
--

INSERT INTO `services_invoice` (`reference_no`, `company_id`, `supplier_invoiceno`, `supplier_invoicedate`, `grnnumber`, `customername`, `currency`, `bahraini_dinar`, `initiatedby`, `payment_terms`, `incoterms`, `transport_name`, `preparedby`, `pdf`, `subtotal`, `discount`, `vat_amount`, `duty`, `freight_charge`, `totalamount`, `status`, `createdTime`, `modifiedTime`) VALUES
(1, '2', '5002', '2024-07-05', 1, '1', 'INR', '0.0045', 'Arunkumar R', '60 Days', 'DDP', 'Hand Delivery', 'Arunkumar RD', '1-LISTOFPARTICIPATINGPOLITICALANDABBREVATIONS_ver4_3345582115_20240705182955.pdf', '21.500', '10.000', '3.150', '200.000', '120.000', '344.650', 1, '2024-07-05 12:59:55', '2024-07-05 12:59:55'),
(2, '2', '5002', '2024-07-06', 2, '2', 'USA', '0.38', 'Arundear', '60 Days', 'DDP', 'Hand Delivery', 'Arunkumar RD', NULL, '1566.000', '30.000', '159.600', '60.000', '120.000', '1905.600', 1, '2024-07-05 13:01:08', '2024-07-05 13:01:08');

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

--
-- Table structure for table `services_invoice_records`
--

CREATE TABLE `services_invoice_records` (
  `id` int NOT NULL,
  `services_invoice_id` int DEFAULT NULL,
  `description` longtext,
  `quantity` varchar(255) NOT NULL,
  `sellerprice` varchar(255) NOT NULL,
  `amount` decimal(10,3) NOT NULL,
  `bd_total` decimal(10,3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `services_invoice_records`
--

INSERT INTO `services_invoice_records` (`id`, `services_invoice_id`, `description`, `quantity`, `sellerprice`, `amount`, `bd_total`) VALUES
(1, 1, 'goods product', '25', '280', '7000.000', '31.500'),
(2, 2, 'good', '15', '280', '4200.000', '1596.000');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `settingid` int NOT NULL,
  `settingname` varchar(100) NOT NULL,
  `value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`settingid`, `settingname`, `value`) VALUES
(1, 'basicsalaryperhour', '8'),
(2, 'gst', '7'),
(3, 'bank_accounts', '[\"467\"]'),
(4, 'salary_advance', '9'),
(5, 'cpf_contribution', '9'),
(6, 'weekly_holiday', '[\"1\",\"6\",\"7\"]'),
(7, 'medical_leave', '12'),
(8, 'closingstock1', '465'),
(9, 'closingstock2', '466'),
(10, 'quick_bank_accounts', '[[\"51\",\"UOB Bank Account\"],[\"483\",\"234002000000085\"]]');

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

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

CREATE TABLE `subcategory` (
  `subcategoryid` int NOT NULL,
  `categoryid` int NOT NULL,
  `subcategoryname` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `subcategory` (`subcategoryid`, `categoryid`, `subcategoryname`) VALUES
(1, 1, 'Noncurrent Assets'),
(2, 1, 'Investments'),
(3, 1, 'Current Assets'),
(4, 2, 'Equity & Reserve'),
(5, 2, 'Noncurrent Liabilities'),
(6, 2, 'Current Liabilities');

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

--
-- Table structure for table `subsubcategory`
--

CREATE TABLE `subsubcategory` (
  `subsubcategoryid` int NOT NULL,
  `subcategoryid` int NOT NULL,
  `subsubcategoryname` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subsubcategory`
--

INSERT INTO `subsubcategory` (`subsubcategoryid`, `subcategoryid`, `subsubcategoryname`) VALUES
(1, 3, 'Fixed Assets'),
(2, 3, 'Bank Account'),
(4, 6, 'Sundry Creditors'),
(5, 3, 'Sundry Debtors'),
(6, 3, 'Cash in Hand'),
(7, 6, 'Accruals'),
(8, 3, 'Other Receivables'),
(9, 6, 'Other Payables'),
(10, 3, 'Others'),
(16, 1, 'Others'),
(17, 5, 'Others'),
(18, 6, 'Trade Creditors'),
(19, 3, 'Trade Debtors'),
(20, 6, 'Due to directors'),
(21, 1, 'Fixed Assets'),
(22, 3, 'Loans and Advances'),
(23, 1, 'Loans & Advances'),
(24, 6, 'Loan & Advances'),
(25, 1, 'Office fourniture & Fittings'),
(26, 6, 'Duties & Taxes'),
(27, 6, 'Duties & Taxes'),
(28, 1, 'Sundry creditors'),
(29, 6, 'Other Liabilities'),
(30, 1, 'Office Furinutre'),
(31, 6, 'Creditors for store purchase'),
(32, 1, 'Creditors for Store Purchase'),
(33, 6, 'Sundry Creditors'),
(34, 5, 'Sundry Creditors'),
(35, 5, 'Creditors for Store Purchase'),
(36, 5, 'Repairs & Maintance account'),
(37, 6, 'Payable account'),
(38, 1, 'Computers and Software'),
(39, 1, 'Office Equipment'),
(40, 1, 'Furniture and Fixtures'),
(41, 1, 'Electrical & Electronices'),
(42, 1, 'fhdh'),
(43, 1, 'ghdg'),
(44, 1, '\']\''),
(45, 1, 'Fixed Assets'),
(46, 4, 'Payable account1'),
(47, 1, 'Fixed Assets'),
(48, 2, 'Other Payables'),
(49, 1, 'Cash and Cash Equivalents'),
(50, 3, 'Cash and Cash Equivalents'),
(51, 4, 'Equity share capital'),
(52, 6, 'I British steel'),
(53, 6, 'British S\'teel Ltd'),
(54, 6, 'British S\'teel Ltd'),
(55, 6, 'Chelsea steel,'),
(56, 3, 'Inventories'),
(57, 3, 'Stock (Consumbales & Packing )'),
(58, 3, 'Inventories Account'),
(59, 1, 'Intangible Assets'),
(60, 1, 'Property , Plant and Equiment'),
(61, 1, 'Property , Plant and Equiments'),
(62, 1, 'arun');

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

--
-- Table structure for table `taxmaster`
--

CREATE TABLE `taxmaster` (
  `taxid` int NOT NULL,
  `company_id` int NOT NULL,
  `taxcode` varchar(30) NOT NULL,
  `description` varchar(200) NOT NULL,
  `percentage` decimal(10,2) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `createdBy` int NOT NULL,
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `modifiedBy` int NOT NULL,
  `modifiedTime` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `taxmaster`
--

INSERT INTO `taxmaster` (`taxid`, `company_id`, `taxcode`, `description`, `percentage`, `status`, `createdBy`, `modifiedBy`, `modifiedTime`) VALUES
(1, 1, 'GST-0%', 'GST -EXPORT', '0.00', 2, 1, 1, '2017-04-27 01:52:45'),
(2, 1, 'GST-0%', 'GST-Export', '0.00', 0, 1, 0, '0000-00-00 00:00:00'),
(3, 2, '100', '0hgmhg', '12.00', 0, 1, 0, '0000-00-00 00:00:00');

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

--
-- Table structure for table `tbl_attendance_leave_category`
--

CREATE TABLE `tbl_attendance_leave_category` (
  `id` int NOT NULL,
  `category_name` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `category_value` int DEFAULT NULL,
  `category_type` varchar(255) DEFAULT NULL,
  `category_status` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_attendance_leave_category`
--

INSERT INTO `tbl_attendance_leave_category` (`id`, `category_name`, `category_value`, `category_type`, `category_status`, `created_at`, `updated_at`) VALUES
(1, 'Sick Leave', 15, NULL, 'Active', '2023-03-21 11:31:41', '2023-04-10 09:29:47'),
(2, 'Casual Leave', 20, '2', 'Active', '2023-03-27 03:02:06', '2023-05-02 10:31:33'),
(5, 'Annual Leave', 30, '1', 'Active', '2023-04-10 09:25:46', '2023-05-02 10:31:25'),
(6, 'Haj Leave', 21, NULL, 'Active', '2023-04-10 09:28:47', NULL);

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

--
-- Table structure for table `tbl_attendance_master`
--

CREATE TABLE `tbl_attendance_master` (
  `id` int NOT NULL,
  `attend_date` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `attend_emp_id` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `attend_shift` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `attend_in_time` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `attend_out_time` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `attend_work_hours` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `attend_over_time` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `attend_total_hours` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `attend_status` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `attend_notes` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `attend_month_year` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `attend_import_by` int DEFAULT NULL,
  `attend_action_status` int NOT NULL COMMENT '0 - No , 1 - Salary Paid , 2 - OT Paid, 3 - Government Paid , 4 - Deduction',
  `attend_action_by` int DEFAULT NULL,
  `attend_action_notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `attend_action_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_bank_entries`
--

CREATE TABLE `tbl_bank_entries` (
  `id` int NOT NULL,
  `bank_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `openingbalance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_bank_opening`
--

CREATE TABLE `tbl_bank_opening` (
  `id` int NOT NULL,
  `company_id` int NOT NULL,
  `financial_year` int NOT NULL,
  `accountname` int DEFAULT NULL,
  `opening_balance` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_bank_opening`
--

INSERT INTO `tbl_bank_opening` (`id`, `company_id`, `financial_year`, `accountname`, `opening_balance`) VALUES
(7, 0, 0, 35, '452452.00'),
(8, 0, 0, 8, '250000.00'),
(9, 0, 0, 12, '94156331.00'),
(10, 0, 0, 12, '94156331.00'),
(11, 0, 0, 12, '94156331.00');

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

--
-- Table structure for table `tbl_currency`
--

CREATE TABLE `tbl_currency` (
  `id` int NOT NULL,
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currencies_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `exchange_rate` varchar(255) DEFAULT NULL,
  `bahraini_dinar` varchar(255) DEFAULT NULL,
  `currency_status` varchar(2500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_currency`
--

INSERT INTO `tbl_currency` (`id`, `country`, `currencies_name`, `exchange_rate`, `bahraini_dinar`, `currency_status`, `created_at`, `updated_at`) VALUES
(1, 'INDIA', 'INR', '1', '0.0045', 'Active', '2024-06-26 06:17:39', '2024-06-26 06:17:39'),
(2, 'United States Dollar', 'USA', '1', '0.38', 'Active', '2024-06-26 06:22:48', '2024-06-26 06:22:48'),
(3, 'Saudi Arabia', 'SAR', '1', '0.10', 'Active', '2024-06-26 06:24:36', '2024-06-26 06:24:36'),
(4, 'Kuwaiti', 'KD', '1', '1.23', 'Active', '2024-06-26 06:25:39', '2024-06-26 06:25:39'),
(5, 'Oman', 'OMR', '1', '0.98', 'Active', '2024-06-26 06:26:24', '2024-06-26 06:26:24'),
(6, 'Canada', 'C$', '1', '0.28', 'Active', '2024-06-26 06:28:57', '2024-06-26 06:28:57'),
(7, 'Bahrain', 'BD', '1', '1', 'Active', '2024-06-25 19:36:15', '2024-06-26 07:36:15');

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

--
-- Table structure for table `tbl_department_category`
--

CREATE TABLE `tbl_department_category` (
  `id` int NOT NULL,
  `department_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `department_status` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_department_category`
--

INSERT INTO `tbl_department_category` (`id`, `department_name`, `department_status`, `created_at`, `updated_at`) VALUES
(11, 'Management', 'Active', '2023-03-25 02:26:23', '2023-03-25 02:28:05'),
(12, 'Production', 'Active', '2023-03-25 02:26:37', '2023-03-25 02:28:11'),
(13, 'Sales', 'Active', '2023-03-25 02:26:45', '2023-03-25 02:28:19'),
(14, 'Finance', 'Active', '2023-03-25 02:26:54', '2023-03-25 02:27:46'),
(15, 'Human Resources', 'Active', '2023-03-25 02:27:08', '2023-03-25 02:27:58'),
(16, 'Administration', 'Active', '2023-03-25 02:27:20', '2023-03-25 02:27:37');

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

--
-- Table structure for table `tbl_desigantion_category`
--

CREATE TABLE `tbl_desigantion_category` (
  `id` int NOT NULL,
  `designation_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `designation_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_desigantion_category`
--

INSERT INTO `tbl_desigantion_category` (`id`, `designation_name`, `designation_status`, `created_at`, `updated_at`) VALUES
(10, 'Managing Director', 'Active', '2023-03-24 20:56:14', '2023-03-27 06:23:38'),
(11, 'Production Manager ', 'Active', '2023-03-24 20:56:27', '2023-03-25 13:26:27'),
(12, 'Business Development Manager', 'Active', '2023-03-24 20:57:19', '2023-03-25 13:27:19'),
(13, 'Accounts Manager', 'Active', '2023-03-24 20:57:31', '2023-03-27 07:02:36'),
(14, 'Production Supervisor', 'Active', '2023-03-24 20:57:42', '2023-03-25 13:27:42'),
(15, 'HR Manager', 'Active', '2023-03-24 20:57:52', '2023-03-25 13:27:52'),
(16, 'Warehouse & Logistics Operator', 'Active', '2023-03-24 20:58:05', '2023-03-25 13:28:05'),
(17, 'Machine Operator', 'Active', '2023-03-24 20:58:17', '2023-03-25 13:28:17'),
(18, 'General Administrator', 'Active', '2023-03-24 20:58:30', '2023-03-25 13:28:30'),
(20, 'Carpenter', 'Active', '2023-03-24 21:00:35', '2023-03-25 13:30:35'),
(21, 'Supply Chain Administrator', 'Active', '2023-03-24 21:00:48', '2023-03-25 13:30:48'),
(22, 'Quality and Machine Operator', 'Active', '2023-03-24 21:00:58', '2023-03-25 13:30:58'),
(23, 'Maintenance Engineer', 'Active', '2023-03-24 21:01:16', '2023-03-25 13:31:16'),
(24, 'Administrative Assistant', 'Active', '2023-03-24 21:01:36', '2023-03-25 13:31:36'),
(25, 'Manager - Accounts & Cost', 'Active', '2023-03-24 21:01:50', '2023-03-25 13:31:50');

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

--
-- Table structure for table `tbl_employee_performance`
--

CREATE TABLE `tbl_employee_performance` (
  `id` int NOT NULL,
  `employee_id` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_of_review` date DEFAULT NULL,
  `review_period` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `line_manager` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `job_knowledge_rating` tinyint(1) DEFAULT NULL,
  `job_knowledge_comments` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `quality_rating` tinyint(1) DEFAULT NULL,
  `quality_rating_comments` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `attendance_punctuality_rating` tinyint(1) DEFAULT NULL,
  `attendance_punctuality_comments` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `takes_initiative_rating` tinyint(1) DEFAULT NULL,
  `takes_initiative_comments` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `communication_listening_rating` tinyint(1) DEFAULT NULL,
  `communication_listening_comments` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dependability_rating` tinyint(1) DEFAULT NULL,
  `dependability_comments` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `overall_rating` float(5,2) DEFAULT NULL,
  `employee_status` int DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_employee_performance`
--

INSERT INTO `tbl_employee_performance` (`id`, `employee_id`, `date_of_review`, `review_period`, `line_manager`, `job_knowledge_rating`, `job_knowledge_comments`, `quality_rating`, `quality_rating_comments`, `attendance_punctuality_rating`, `attendance_punctuality_comments`, `takes_initiative_rating`, `takes_initiative_comments`, `communication_listening_rating`, `communication_listening_comments`, `dependability_rating`, `dependability_comments`, `overall_rating`, `employee_status`, `created_at`, `updated_at`) VALUES
(40, '1', '2023-04-01', '20', 'Ram', 5, 'perfect                                                                 ', 4, 'good', 5, 'incredible', 3, 'better', 4, 'good', 5, 'perfect', 4.33, 1, '2023-04-05 03:10:45', '2023-04-05 03:13:45.000000'),
(41, '3', '2023-04-12', '12', 'vicky', 5, '                                                                  ', 5, '', 5, '', 5, '', 5, '', 5, '', 5.00, NULL, '2023-04-06 03:29:00', '2023-04-07 07:15:05.000000'),
(43, '11', '2023-04-12', '12', 'vicky', 4, '                                 good', 4, 'good', 4, 'good', 4, 'good', 4, 'good', 4, 'good', 4.00, NULL, '2023-04-20 01:44:02', NULL);

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

--
-- Table structure for table `tbl_history`
--

CREATE TABLE `tbl_history` (
  `id` int NOT NULL,
  `grnno` int DEFAULT NULL,
  `batch_ref` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_history`
--

INSERT INTO `tbl_history` (`id`, `grnno`, `batch_ref`, `created_at`, `updated_at`) VALUES
(1, 1, 'AD510918205002', '2024-07-05 12:37:11', '2024-07-05 12:37:11'),
(2, 2, 'AD510918205004', '2024-07-05 12:38:24', '2024-07-05 12:38:24');

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

--
-- Table structure for table `tbl_history_records`
--

CREATE TABLE `tbl_history_records` (
  `history_id` int DEFAULT NULL,
  `itemid` int DEFAULT NULL,
  `accepted_qty` varchar(11) DEFAULT NULL,
  `sellerprice` varchar(11) DEFAULT NULL,
  `unitprice` varchar(11) DEFAULT NULL,
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_history_records`
--

INSERT INTO `tbl_history_records` (`history_id`, `itemid`, `accepted_qty`, `sellerprice`, `unitprice`, `createdTime`) VALUES
(1, 1, '14', '280.000', '300.000', '2024-07-05 12:37:11'),
(1, 2, '13', '140.000', '150.000', '2024-07-05 12:37:11'),
(1, 3, '14', '140.000', '150.000', '2024-07-05 12:37:11'),
(2, 2, '9', '135.000', '150.000', '2024-07-05 12:38:24'),
(2, 3, '9', '140.000', '150.000', '2024-07-05 12:38:24');

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

--
-- Table structure for table `tbl_holidays`
--

CREATE TABLE `tbl_holidays` (
  `id` int NOT NULL,
  `holidays_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `holidays_date` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `holidays_day` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `holiday_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime(6) DEFAULT NULL,
  `updated_at` datetime(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_holidays`
--

INSERT INTO `tbl_holidays` (`id`, `holidays_name`, `holidays_date`, `holidays_day`, `holiday_status`, `created_at`, `updated_at`) VALUES
(12, 'Labour Day', '05/01/2023', 'Monday', 'Active', '2023-05-08 10:00:05.000000', NULL),
(13, 'Arafat day', '06/27/2023', 'Tuesday', 'Active', '2023-05-08 10:00:27.000000', NULL),
(14, 'Eid al Adha', '06/28/2023', 'Wednesday', 'Active', '2023-05-08 10:01:29.000000', NULL),
(15, 'National Day', '12/18/2023', 'Monday', 'Active', '2023-05-08 10:01:57.000000', NULL),
(16, 'New Year ', '01/01/2023', 'Sunday', 'Active', '2023-05-08 10:02:51.000000', NULL),
(17, 'Eid  Al Fitr', '04/21/2023', 'Friday', 'Active', '2023-05-08 10:04:15.000000', NULL),
(18, 'Islamic New Year', '07/19/2023', 'Wednesday', 'Active', '2023-05-08 10:04:54.000000', NULL);

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

--
-- Table structure for table `tbl_incoterms`
--

CREATE TABLE `tbl_incoterms` (
  `id` int NOT NULL,
  `incoterms` varchar(255) DEFAULT NULL,
  `incoterms_status` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_incoterms`
--

INSERT INTO `tbl_incoterms` (`id`, `incoterms`, `incoterms_status`, `created_at`, `updated_at`) VALUES
(4, 'FOB', 'Active', '2024-06-12 11:50:14', '2024-06-12 11:50:14'),
(5, 'CFR', 'Active', '2024-06-12 11:50:24', '2024-06-12 11:50:24'),
(6, 'CIF', 'Active', '2024-06-12 11:50:30', '2024-06-12 11:50:30'),
(7, 'DDP', 'Active', '2024-06-12 11:50:37', '2024-06-12 11:50:37');

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

--
-- Table structure for table `tbl_leave_request_master`
--

CREATE TABLE `tbl_leave_request_master` (
  `id` int NOT NULL,
  `request_emp_id` int DEFAULT NULL,
  `request_leave_category` int DEFAULT NULL,
  `request_leave_type` int DEFAULT NULL COMMENT '1 - Single , 2 - Multiple',
  `request_start_date` date DEFAULT NULL,
  `request_end_date` date DEFAULT NULL,
  `request_reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `request_attachment` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `request_created_by` int DEFAULT NULL,
  `request_status` int NOT NULL COMMENT '0 - No , 1 - Approve , 2 - Reject',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_leave_request_master`
--

INSERT INTO `tbl_leave_request_master` (`id`, `request_emp_id`, `request_leave_category`, `request_leave_type`, `request_start_date`, `request_end_date`, `request_reason`, `request_attachment`, `request_created_by`, `request_status`, `created_at`, `updated_at`) VALUES
(3, 6, 1, 2, '2023-03-29', '2023-03-30', '', NULL, 1, 1, '2023-03-29 10:28:06', '2023-04-04 11:27:47'),
(4, 6, 1, 1, '2023-04-03', '2023-04-03', 'developer tester', NULL, 1, 2, '2023-04-03 11:07:58', NULL),
(5, 6, 5, 1, '2023-04-10', '2023-04-10', 'testr', NULL, 1, 2, '2023-04-10 09:31:24', NULL),
(7, 8, 2, 1, '2023-05-02', '2023-05-04', '', NULL, 6, 1, '2023-05-01 06:44:57', NULL),
(8, 6, 1, 1, '2023-05-05', '2023-05-06', 'o9p', NULL, 1, 1, '2023-05-04 02:04:41', NULL),
(10, 15, 1, 2, '2023-05-08', '2023-05-18', '', NULL, 32, 1, '2023-05-06 03:49:00', NULL),
(12, 15, 6, 1, '2023-05-06', '2023-05-07', '', NULL, 15, 1, '2023-05-06 04:13:05', NULL),
(13, 15, 5, 1, '2023-05-09', '2023-05-10', 'test', NULL, 15, 1, '2023-05-08 11:40:44', NULL),
(14, 17, 5, 1, '2023-07-23', '2023-07-24', 'fedgfdd', NULL, 32, 1, '2023-07-23 10:19:41', NULL);

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

--
-- Table structure for table `tbl_material_request`
--

CREATE TABLE `tbl_material_request` (
  `reference_id` int NOT NULL,
  `reference_no` varchar(20) NOT NULL,
  `company_id` int DEFAULT NULL,
  `initiator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `delivery_date` varchar(255) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_material_request`
--

INSERT INTO `tbl_material_request` (`reference_id`, `reference_no`, `company_id`, `initiator`, `delivery_date`, `file`, `created_at`, `updated_at`) VALUES
(1, 'MR001', 2, 'Sulaiman', '2024-07-01', NULL, '2024-07-01 10:03:00', '2024-07-01 10:03:00'),
(2, 'MR002', 2, 'Sulaiman', '2024-07-03', NULL, '2024-07-03 08:24:21', '2024-07-03 08:24:21'),
(3, 'MR003', 2, 'Arunkumar', '2024-07-10', NULL, '2024-07-03 08:26:01', '2024-07-03 08:26:01'),
(4, 'MR004', 2, 'Sulaiman', '2024-07-08', 'black1433924843_20240708164407.png', '2024-07-08 11:14:07', '2024-07-08 11:14:07');

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

--
-- Table structure for table `tbl_material_request_records`
--

CREATE TABLE `tbl_material_request_records` (
  `id` int NOT NULL,
  `material_request_id` int NOT NULL,
  `itemcode` varchar(255) DEFAULT NULL,
  `itemname` varchar(255) DEFAULT NULL,
  `unit` varchar(255) DEFAULT NULL,
  `quantity` varchar(255) DEFAULT NULL,
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_material_request_records`
--

INSERT INTO `tbl_material_request_records` (`id`, `material_request_id`, `itemcode`, `itemname`, `unit`, `quantity`, `remark`) VALUES
(1, 1, '1', 'Testing', 'KG', '15', 'testings'),
(2, 1, '2', 'Addobyte', 'Litter', '15', 'testings'),
(3, 1, '3', 'test', 'KG', '15', 'testings'),
(4, 2, '2', 'Addobyte', 'Litter', '10', 'test'),
(5, 2, '3', 'test', 'KG', '10', 'test'),
(6, 3, '1', 'Testing', 'KG', '30', 'test'),
(7, 3, '3', 'test', 'KG', '40', 'test'),
(8, 4, '1', 'Testing', 'KG', '20', 'testings');

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

--
-- Table structure for table `tbl_menu`
--

CREATE TABLE `tbl_menu` (
  `id` int NOT NULL,
  `menu_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `menu_order` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_menu`
--

INSERT INTO `tbl_menu` (`id`, `menu_name`, `menu_order`) VALUES
(1, 'HR', 1),
(2, 'Configuration', 2),
(3, 'Finance', 3),
(4, 'Bank Reconcilliation', 4),
(5, 'Inventory Master', 5),
(6, 'Aging Schedule', 6),
(7, 'Purchase', 7),
(8, 'Sales', 8),
(9, 'Reports', 9),
(10, 'CRM', 10),
(11, 'Users', 11);

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

--
-- Table structure for table `tbl_ot_time`
--

CREATE TABLE `tbl_ot_time` (
  `id` int NOT NULL,
  `employee_id` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rate_type` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rate` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `total_hours` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ot_status` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime(6) DEFAULT NULL,
  `created_by` datetime(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `tbl_payment_terms`
--

CREATE TABLE `tbl_payment_terms` (
  `id` int NOT NULL,
  `payment_terms` varchar(255) DEFAULT NULL,
  `terms_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_payment_terms`
--

INSERT INTO `tbl_payment_terms` (`id`, `payment_terms`, `terms_status`, `created_at`, `updated_at`) VALUES
(4, '30 Days', 'Active', '2024-06-12 11:49:34', '2024-06-12 11:49:34'),
(5, '60 Days', 'Active', '2024-06-12 11:49:40', '2024-06-12 11:49:40'),
(6, '90 Days', 'Active', '2024-06-12 11:49:46', '2024-06-12 11:49:46');

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

--
-- Table structure for table `tbl_salary_deductions`
--

CREATE TABLE `tbl_salary_deductions` (
  `id` int NOT NULL,
  `deductions_name` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `deductions_percent` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `deductions_status` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_salary_deductions`
--

INSERT INTO `tbl_salary_deductions` (`id`, `deductions_name`, `deductions_percent`, `deductions_status`, `created_at`, `updated_at`) VALUES
(1, 'SIO', '19', 'Active', '2023-05-11 11:23:18', NULL);

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

--
-- Table structure for table `tbl_salary_details`
--

CREATE TABLE `tbl_salary_details` (
  `id` int NOT NULL,
  `slip_id` int DEFAULT NULL,
  `details_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `details_amount` int DEFAULT NULL,
  `details_type` int DEFAULT NULL COMMENT '1 - Earnings , 2 - Deductions'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_salary_details`
--

INSERT INTO `tbl_salary_details` (`id`, `slip_id`, `details_name`, `details_amount`, `details_type`) VALUES
(1, 1, 'HRA', 40, 1),
(2, 2, 'HRA', 0, 1),
(3, 3, 'HRA', 24, 1),
(4, 4, 'HRA', 18, 1),
(5, 5, 'HRA', 0, 1),
(6, 5, 'Other Allowances', 0, 1),
(7, 5, 'SIO', 1, 2),
(8, 6, 'HRA', 18, 1),
(9, 6, 'Other Allowances', 5, 1),
(10, 6, 'SIO', 43, 2),
(11, 7, 'HRA', 600, 1),
(12, 7, 'Other Allowances', 20, 1),
(13, 7, 'SIO', 190, 2),
(14, 7, 'Loan', 400, 3),
(15, 7, 'Loan', 100, 3);

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

--
-- Table structure for table `tbl_salary_earninings`
--

CREATE TABLE `tbl_salary_earninings` (
  `id` int NOT NULL,
  `earninings_type` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `earninings_name` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `earninings_percent` varchar(150) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `earninings_status` varchar(250) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_salary_earninings`
--

INSERT INTO `tbl_salary_earninings` (`id`, `earninings_type`, `earninings_name`, `earninings_percent`, `earninings_status`, `created_at`, `updated_at`) VALUES
(1, NULL, 'HRA', '60', 'Active', '2023-04-07 11:49:22', '2023-05-11 12:56:56'),
(2, NULL, 'Other Allowances', '2', 'Active', '2023-05-11 11:45:52', NULL);

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

--
-- Table structure for table `tbl_salary_settings`
--

CREATE TABLE `tbl_salary_settings` (
  `id` int NOT NULL,
  `percentage_hra` double DEFAULT NULL,
  `percentage_transport` double DEFAULT NULL,
  `percentage_other_allowance` double DEFAULT NULL,
  `percentage_others` double DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_salary_settings`
--

INSERT INTO `tbl_salary_settings` (`id`, `percentage_hra`, `percentage_transport`, `percentage_other_allowance`, `percentage_others`, `updated_at`) VALUES
(1, 123, NULL, NULL, 132, '2023-03-21 09:59:32');

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

--
-- Table structure for table `tbl_salary_slip`
--

CREATE TABLE `tbl_salary_slip` (
  `id` int NOT NULL,
  `slip_emp_id` int DEFAULT NULL,
  `slip_month` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `slip_earnings` int DEFAULT NULL,
  `slip_deductions` int DEFAULT NULL,
  `slip_net_pay` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_salary_slip`
--

INSERT INTO `tbl_salary_slip` (`id`, `slip_emp_id`, `slip_month`, `slip_earnings`, `slip_deductions`, `slip_net_pay`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES
(5, 17, 'February - 2023', 0, 1, 0, '2023-05-11 11:47:08', 32, NULL, NULL),
(6, 19, 'February - 2023', 23, 43, -20, '2023-05-11 11:47:14', 32, NULL, NULL),
(7, 6, 'February - 2023', 620, 690, -70, '2023-05-11 02:45:26', 32, NULL, NULL);

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

--
-- Table structure for table `tbl_shift_timing_master`
--

CREATE TABLE `tbl_shift_timing_master` (
  `id` int NOT NULL,
  `shift_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `shift_in_time` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `shift_out_time` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `shift_status` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime(6) DEFAULT NULL,
  `updated_at` datetime(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_shift_timing_master`
--

INSERT INTO `tbl_shift_timing_master` (`id`, `shift_name`, `shift_in_time`, `shift_out_time`, `shift_status`, `created_at`, `updated_at`) VALUES
(3, 'GS', '13:32', '15:34', 'Active', '2023-04-01 08:01:03.000000', NULL);

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

--
-- Table structure for table `tbl_tax_category`
--

CREATE TABLE `tbl_tax_category` (
  `id` int NOT NULL,
  `tax_name` varchar(255) DEFAULT NULL,
  `tax_status` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_tax_category`
--

INSERT INTO `tbl_tax_category` (`id`, `tax_name`, `tax_status`, `created_at`, `updated_at`) VALUES
(1, '5', 'Active', '2024-04-22 08:38:01', NULL),
(2, '10', 'Active', '2024-04-22 08:40:39', NULL),
(3, '15', 'Active', '2024-04-22 08:40:43', NULL);

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

--
-- Table structure for table `tbl_transport`
--

CREATE TABLE `tbl_transport` (
  `id` int NOT NULL,
  `transport_name` varchar(255) NOT NULL,
  `transport_status` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_transport`
--

INSERT INTO `tbl_transport` (`id`, `transport_name`, `transport_status`, `created_at`, `updated_at`) VALUES
(1, 'Air', 'Active', '2024-06-12 12:22:36', '2024-06-12 12:22:36'),
(2, 'Sea', 'Active', '2024-06-12 12:22:47', '2024-06-12 12:22:47'),
(3, 'Road', 'Active', '2024-06-12 12:22:53', '2024-06-12 12:22:53'),
(4, 'Hand Delivery', 'Active', '2024-06-12 12:23:00', '2024-06-12 12:23:00');

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

--
-- Table structure for table `tbl_unit_category`
--

CREATE TABLE `tbl_unit_category` (
  `id` int NOT NULL,
  `unit_name` varchar(255) DEFAULT NULL,
  `unit_status` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_unit_category`
--

INSERT INTO `tbl_unit_category` (`id`, `unit_name`, `unit_status`, `created_at`, `updated_at`) VALUES
(1, 'Litter', 'Active', '2024-04-22 07:13:39', '2024-04-23 10:36:33'),
(3, 'KG', 'Active', '2024-04-22 07:21:49', NULL),
(4, 'No`s', 'Active', '2024-04-30 03:57:20', NULL),
(5, 'metric ton ', 'Active', '2024-04-30 04:16:45', NULL);

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

--
-- Table structure for table `tbl_user_account_type`
--

CREATE TABLE `tbl_user_account_type` (
  `id` int NOT NULL,
  `account_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `account_status` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `account_permission` int DEFAULT NULL COMMENT '1 - Yes , 0 - No',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_user_account_type`
--

INSERT INTO `tbl_user_account_type` (`id`, `account_name`, `account_status`, `account_permission`, `created_at`, `updated_at`) VALUES
(3, 'icici', 'Active', 1, '2023-03-27 01:00:13', '2023-04-17 09:03:45'),
(7, 'HR Manager', 'Active', 1, '2023-04-13 01:45:21', NULL),
(8, 'Indian Bank', 'Active', 1, '2024-03-23 04:26:52', NULL),
(9, 'Addobyte', 'Active', 1, '2024-03-29 06:09:26', NULL);

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

--
-- Table structure for table `tbl_vat_master`
--

CREATE TABLE `tbl_vat_master` (
  `id` int NOT NULL,
  `vat_code` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `percentage` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `vat_status` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime(6) DEFAULT NULL,
  `updated_at` datetime(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_vat_master`
--

INSERT INTO `tbl_vat_master` (`id`, `vat_code`, `description`, `percentage`, `vat_status`, `created_at`, `updated_at`) VALUES
(2, '4144', 'hgvhgv34656565', '22', 'Active', '2023-04-06 08:07:22.000000', '2023-04-06 08:08:02.000000'),
(3, '43223423', 'gnhhcnbvn', '44', 'Active', '2023-04-19 01:16:02.000000', NULL);

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `user_id` int NOT NULL,
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `firstname` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lastname` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `landline` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `permission` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 - Active , 0 -Inactive',
  `user_admin` int NOT NULL COMMENT '1 - Yes , 0 - No',
  `user_role` int DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`user_id`, `username`, `password`, `firstname`, `lastname`, `email`, `mobile`, `landline`, `permission`, `status`, `user_admin`, `user_role`, `created_by`, `created_at`, `updated_by`, `updated_at`) VALUES
(1, 'admin', '$2y$10$8kGTlW/qkN3j/dLkybmnsetnBKBQWbLVR9iz8RqHrXMiNpCpIZfxW', 'Arunkumar', 'R', 'arunkumarn@addobyte.com', '9344694501', NULL, NULL, 1, 0, 9, NULL, '2024-04-11 23:39:37', NULL, NULL);

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

--
-- Table structure for table `user_role`
--

CREATE TABLE `user_role` (
  `id` int NOT NULL,
  `user_id` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `menu_id` int DEFAULT NULL,
  `menu_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `menu_permission_add` int DEFAULT NULL COMMENT '0-no\r\n1-yes',
  `menu_permission_edit` int DEFAULT NULL COMMENT '0-no\r\n1-yes',
  `menu_permission_delete` int DEFAULT NULL COMMENT '0-no\r\n1-yes',
  `menu_permission_view` int DEFAULT NULL COMMENT '0-no\r\n1-yes',
  `menu_permission_download` int DEFAULT NULL COMMENT '0-no\r\n1-yes',
  `created_at` tinyint DEFAULT NULL,
  `created_by` tinyint DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `vendor`
--

CREATE TABLE `vendor` (
  `id` int NOT NULL,
  `vendor_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `account_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `voucher`
--

CREATE TABLE `voucher` (
  `voucherid` bigint NOT NULL,
  `voucherno` varchar(30) NOT NULL,
  `vouchertype` tinyint(1) NOT NULL COMMENT '1-payment,2-receipt,3-journal,4-contra',
  `invoiceno` int DEFAULT '0',
  `jtype` tinyint(1) NOT NULL COMMENT 'journal voucher type',
  `company_id` int NOT NULL,
  `voucherdate` date NOT NULL,
  `preparedby` varchar(100) NOT NULL,
  `authorizedby` varchar(100) NOT NULL,
  `towhom` varchar(100) NOT NULL,
  `totaldebit` decimal(10,2) NOT NULL,
  `totalcredit` decimal(10,2) NOT NULL,
  `narration` text NOT NULL,
  `supplies_type` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `createdBy` int DEFAULT NULL,
  `createdTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `system` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0-manual,1-system',
  `modifiedBy` int NOT NULL,
  `modifiedTime` timestamp NULL DEFAULT NULL,
  `voucherlink` int NOT NULL,
  `voucheramount` varchar(255) DEFAULT NULL,
  `billno` varchar(100) NOT NULL,
  `billnumber` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `voucherrecords`
--

CREATE TABLE `voucherrecords` (
  `voucherid` int NOT NULL,
  `accountname` int DEFAULT NULL,
  `debit` decimal(10,2) NOT NULL,
  `credit` decimal(10,2) NOT NULL,
  `reference` varchar(100) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `accountnames`
--
ALTER TABLE `accountnames`
  ADD PRIMARY KEY (`accountid`);

--
-- Indexes for table `bank_transaction`
--
ALTER TABLE `bank_transaction`
  ADD PRIMARY KEY (`trans_id`);

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

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

--
-- Indexes for table `contacts`
--
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`contactid`);

--
-- Indexes for table `contacttype`
--
ALTER TABLE `contacttype`
  ADD PRIMARY KEY (`typeid`);

--
-- Indexes for table `creditnotes`
--
ALTER TABLE `creditnotes`
  ADD PRIMARY KEY (`credit_id`);

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

--
-- Indexes for table `employee`
--
ALTER TABLE `employee`
  ADD PRIMARY KEY (`employee_id`);

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

--
-- Indexes for table `financialyear`
--
ALTER TABLE `financialyear`
  ADD PRIMARY KEY (`yearid`);

--
-- Indexes for table `gdn`
--
ALTER TABLE `gdn`
  ADD PRIMARY KEY (`gdnid`);

--
-- Indexes for table `grn`
--
ALTER TABLE `grn`
  ADD PRIMARY KEY (`grnid`);

--
-- Indexes for table `itemmaster`
--
ALTER TABLE `itemmaster`
  ADD PRIMARY KEY (`itemid`);

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

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

--
-- Indexes for table `maingroup`
--
ALTER TABLE `maingroup`
  ADD PRIMARY KEY (`groupid`);

--
-- Indexes for table `purchaseinvoice`
--
ALTER TABLE `purchaseinvoice`
  ADD PRIMARY KEY (`purchaseinvoiceid`);

--
-- Indexes for table `purchaseorder`
--
ALTER TABLE `purchaseorder`
  ADD PRIMARY KEY (`purchaseorderid`);

--
-- Indexes for table `purchasequote`
--
ALTER TABLE `purchasequote`
  ADD PRIMARY KEY (`purchasequoteid`),
  ADD UNIQUE KEY `purchasequoteid` (`purchasequoteid`);

--
-- Indexes for table `salesinvoice`
--
ALTER TABLE `salesinvoice`
  ADD PRIMARY KEY (`salesinvoiceid`);

--
-- Indexes for table `salesorder`
--
ALTER TABLE `salesorder`
  ADD PRIMARY KEY (`salesorderid`);

--
-- Indexes for table `salesquote`
--
ALTER TABLE `salesquote`
  ADD PRIMARY KEY (`salesquoteid`);

--
-- Indexes for table `services_invoice`
--
ALTER TABLE `services_invoice`
  ADD PRIMARY KEY (`reference_no`);

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

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`settingid`);

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

--
-- Indexes for table `subsubcategory`
--
ALTER TABLE `subsubcategory`
  ADD PRIMARY KEY (`subsubcategoryid`);

--
-- Indexes for table `taxmaster`
--
ALTER TABLE `taxmaster`
  ADD PRIMARY KEY (`taxid`);

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `tbl_material_request`
--
ALTER TABLE `tbl_material_request`
  ADD PRIMARY KEY (`reference_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`user_id`);

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

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

--
-- Indexes for table `voucher`
--
ALTER TABLE `voucher`
  ADD PRIMARY KEY (`voucherid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `accountnames`
--
ALTER TABLE `accountnames`
  MODIFY `accountid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=154;

--
-- AUTO_INCREMENT for table `bank_transaction`
--
ALTER TABLE `bank_transaction`
  MODIFY `trans_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `categoryid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `company`
--
ALTER TABLE `company`
  MODIFY `company_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `contactid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `contacttype`
--
ALTER TABLE `contacttype`
  MODIFY `typeid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `creditnotes`
--
ALTER TABLE `creditnotes`
  MODIFY `credit_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `customerid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `employee`
--
ALTER TABLE `employee`
  MODIFY `employee_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `employee_certificate`
--
ALTER TABLE `employee_certificate`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `financialyear`
--
ALTER TABLE `financialyear`
  MODIFY `yearid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `gdn`
--
ALTER TABLE `gdn`
  MODIFY `gdnid` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `grn`
--
ALTER TABLE `grn`
  MODIFY `grnid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `itemmaster`
--
ALTER TABLE `itemmaster`
  MODIFY `itemid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `loan_master`
--
ALTER TABLE `loan_master`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `loan_payment_history`
--
ALTER TABLE `loan_payment_history`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `maingroup`
--
ALTER TABLE `maingroup`
  MODIFY `groupid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `purchaseinvoice`
--
ALTER TABLE `purchaseinvoice`
  MODIFY `purchaseinvoiceid` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchaseorder`
--
ALTER TABLE `purchaseorder`
  MODIFY `purchaseorderid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `purchasequote`
--
ALTER TABLE `purchasequote`
  MODIFY `purchasequoteid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `salesinvoice`
--
ALTER TABLE `salesinvoice`
  MODIFY `salesinvoiceid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `salesorder`
--
ALTER TABLE `salesorder`
  MODIFY `salesorderid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `salesquote`
--
ALTER TABLE `salesquote`
  MODIFY `salesquoteid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `services_invoice`
--
ALTER TABLE `services_invoice`
  MODIFY `reference_no` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `services_invoice_records`
--
ALTER TABLE `services_invoice_records`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `settingid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `subcategory`
--
ALTER TABLE `subcategory`
  MODIFY `subcategoryid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `subsubcategory`
--
ALTER TABLE `subsubcategory`
  MODIFY `subsubcategoryid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;

--
-- AUTO_INCREMENT for table `taxmaster`
--
ALTER TABLE `taxmaster`
  MODIFY `taxid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_attendance_leave_category`
--
ALTER TABLE `tbl_attendance_leave_category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `tbl_attendance_master`
--
ALTER TABLE `tbl_attendance_master`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_bank_entries`
--
ALTER TABLE `tbl_bank_entries`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_bank_opening`
--
ALTER TABLE `tbl_bank_opening`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `tbl_currency`
--
ALTER TABLE `tbl_currency`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tbl_department_category`
--
ALTER TABLE `tbl_department_category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `tbl_desigantion_category`
--
ALTER TABLE `tbl_desigantion_category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `tbl_employee_performance`
--
ALTER TABLE `tbl_employee_performance`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `tbl_history`
--
ALTER TABLE `tbl_history`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_holidays`
--
ALTER TABLE `tbl_holidays`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `tbl_incoterms`
--
ALTER TABLE `tbl_incoterms`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tbl_leave_request_master`
--
ALTER TABLE `tbl_leave_request_master`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `tbl_material_request`
--
ALTER TABLE `tbl_material_request`
  MODIFY `reference_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tbl_material_request_records`
--
ALTER TABLE `tbl_material_request_records`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `tbl_menu`
--
ALTER TABLE `tbl_menu`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `tbl_ot_time`
--
ALTER TABLE `tbl_ot_time`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_payment_terms`
--
ALTER TABLE `tbl_payment_terms`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tbl_salary_deductions`
--
ALTER TABLE `tbl_salary_deductions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_salary_details`
--
ALTER TABLE `tbl_salary_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `tbl_salary_earninings`
--
ALTER TABLE `tbl_salary_earninings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_salary_settings`
--
ALTER TABLE `tbl_salary_settings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tbl_salary_slip`
--
ALTER TABLE `tbl_salary_slip`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tbl_shift_timing_master`
--
ALTER TABLE `tbl_shift_timing_master`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_tax_category`
--
ALTER TABLE `tbl_tax_category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_transport`
--
ALTER TABLE `tbl_transport`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_unit_category`
--
ALTER TABLE `tbl_unit_category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `tbl_user_account_type`
--
ALTER TABLE `tbl_user_account_type`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `tbl_vat_master`
--
ALTER TABLE `tbl_vat_master`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `user_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `user_role`
--
ALTER TABLE `user_role`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendor`
--
ALTER TABLE `vendor`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `voucher`
--
ALTER TABLE `voucher`
  MODIFY `voucherid` bigint NOT NULL AUTO_INCREMENT;
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 */;