-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Oct 16, 2023 at 06:15 PM
-- Server version: 10.1.13-MariaDB
-- PHP Version: 5.6.20

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `udt`
--

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

--
-- Table structure for table `admin_login`
--

CREATE TABLE `admin_login` (
  `id` int(11) NOT NULL,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `loginstatus` tinyint(4) NOT NULL COMMENT '1-activestatus, 2-inactivestatus, 0-deletestatus',
  `flag` tinyint(4) NOT NULL COMMENT '1-active,0-delete',
  `user_permisson` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `admin_login`
--

INSERT INTO `admin_login` (`id`, `username`, `password`, `loginstatus`, `flag`, `user_permisson`) VALUES
(1, 'superadmin', 'admin', 1, 1, 'ADMIN');

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

--
-- Table structure for table `admin_usermenulist`
--

CREATE TABLE `admin_usermenulist` (
  `id` int(11) NOT NULL,
  `filenames` text,
  `uadd` tinyint(4) DEFAULT NULL,
  `uedit` tinyint(4) DEFAULT NULL,
  `udelete` tinyint(4) DEFAULT NULL,
  `ushow` tinyint(4) DEFAULT NULL,
  `uprintout` tinyint(4) DEFAULT NULL,
  `uexcelformat` tinyint(4) DEFAULT NULL,
  `ustatus` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `brand_master`
--

CREATE TABLE `brand_master` (
  `id` int(11) NOT NULL,
  `brand_name` varchar(250) DEFAULT NULL,
  `brand_type` varchar(200) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `brand_master`
--

INSERT INTO `brand_master` (`id`, `brand_name`, `brand_type`, `createdate`, `createdby`, `userID`, `isdelete`) VALUES
(1, 'Tata', 'transport', '2023-10-11', 'admin', 1, 1),
(2, 'Ashok Layland', 'transport', '2023-10-11', 'admin', 1, 1),
(3, 'JCB', 'equipment', '2023-10-11', 'admin', 1, 1),
(4, 'Hailstones', 'equipment', '2023-10-11', 'admin', 1, 1);

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

--
-- Table structure for table `employee_advance`
--

CREATE TABLE `employee_advance` (
  `id` int(11) NOT NULL,
  `advance_no` varchar(250) DEFAULT NULL,
  `advance_date` date DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `employeename` varchar(120) DEFAULT NULL,
  `advance_amount` decimal(10,2) DEFAULT NULL,
  `remarks` longtext NOT NULL,
  `status` varchar(32) NOT NULL,
  `create_date` varchar(50) DEFAULT NULL,
  `flag` tinyint(2) DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `employee_advance_collection`
--

CREATE TABLE `employee_advance_collection` (
  `id` int(11) NOT NULL,
  `advance_no` varchar(250) DEFAULT NULL,
  `advance_date` date DEFAULT NULL,
  `employee_id` int(11) DEFAULT NULL,
  `employeename` varchar(120) DEFAULT NULL,
  `advance_amount` decimal(10,2) DEFAULT NULL,
  `advance_collection_amount` decimal(10,2) NOT NULL,
  `remarks` longtext NOT NULL,
  `status` varchar(32) NOT NULL,
  `create_date` varchar(50) DEFAULT NULL,
  `flag` tinyint(2) DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `employee_attendance_dtl`
--

CREATE TABLE `employee_attendance_dtl` (
  `id` int(11) NOT NULL,
  `hdr_id` int(11) DEFAULT NULL,
  `invoicedate` date DEFAULT NULL,
  `enameid` bigint(12) DEFAULT NULL,
  `shifttype` text,
  `extraworkinghrs` int(12) DEFAULT NULL,
  `shiftworkamt` double(10,0) DEFAULT NULL,
  `extrahoursamt` decimal(10,0) DEFAULT NULL,
  `payedsalary` tinyint(4) DEFAULT '0',
  `payedsalarydate` date DEFAULT NULL,
  `advancesalary` decimal(10,2) DEFAULT '0.00',
  `collectadvanceamt` decimal(10,0) DEFAULT '0',
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `employee_attendance_hdr`
--

CREATE TABLE `employee_attendance_hdr` (
  `id` int(11) NOT NULL,
  `invoicedate` date DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `employee_master`
--

CREATE TABLE `employee_master` (
  `id` int(11) NOT NULL,
  `ename` varchar(250) DEFAULT NULL,
  `eaddress` text,
  `mobile` varchar(20) DEFAULT NULL,
  `ecode` varchar(250) DEFAULT NULL,
  `shiftworkamt` decimal(10,2) NOT NULL,
  `extrahoursamt` decimal(10,2) NOT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `employee_master`
--

INSERT INTO `employee_master` (`id`, `ename`, `eaddress`, `mobile`, `ecode`, `shiftworkamt`, `extrahoursamt`, `createdate`, `createdby`, `userID`, `isdelete`) VALUES
(1, 'RAMA CHANDRAN', 'CBE', '8098647506', 'EMP-1', '750.00', '0.00', '2023-10-05', 'admin', 1, 1),
(2, 'MUTHUKUMARESAN', 'CBE', '8144372005', 'EMP-2', '750.00', '0.00', '2023-10-05', 'admin', 1, 1),
(3, 'SELVAMANI', 'CBE', '8438668407', 'EMP-3', '750.00', '0.00', '2023-10-05', 'admin', 1, 1),
(4, 'BASKAR', 'CBE', '9003958381', 'EMP-4', '750.00', '0.00', '2023-10-05', 'admin', 1, 1),
(5, 'MANIKANDAN', 'CBE', '8122567678', 'EMP-5', '750.00', '0.00', '2023-10-05', 'admin', 1, 1),
(6, 'JOTHIRAJ', 'CBE', '9842209925', 'EMP-6', '750.00', '0.00', '2023-10-05', 'admin', 1, 1),
(7, 'Jegan', 'Pn Palayam', '7708858562', 'EMP-7', '300.00', '150.00', '2023-10-11', 'admin', 1, 1);

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

--
-- Table structure for table `expense_entry`
--

CREATE TABLE `expense_entry` (
  `id` int(11) NOT NULL,
  `cashno` varchar(200) DEFAULT NULL,
  `expensedate` varchar(250) DEFAULT NULL,
  `expensetype` text,
  `expense` varchar(200) DEFAULT NULL,
  `expenser` varchar(32) NOT NULL,
  `paymenttype` text,
  `silverAQUA` text,
  `availableAmount` decimal(10,4) DEFAULT NULL,
  `amount` decimal(10,4) DEFAULT NULL,
  `mode` varchar(32) NOT NULL,
  `remark` varchar(256) NOT NULL,
  `flag` tinyint(2) DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `expense_entry`
--

INSERT INTO `expense_entry` (`id`, `cashno`, `expensedate`, `expensetype`, `expense`, `expenser`, `paymenttype`, `silverAQUA`, `availableAmount`, `amount`, `mode`, `remark`, `flag`, `accountyear`) VALUES
(1, 'EE-1', '2023-10-12', '1', '1', 'Jega', NULL, NULL, NULL, '200.0000', 'Cash', '', 1, '2023-2024');

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

--
-- Table structure for table `expense_master`
--

CREATE TABLE `expense_master` (
  `id` int(11) NOT NULL,
  `expense` text NOT NULL,
  `flag` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `expense_master`
--

INSERT INTO `expense_master` (`id`, `expense`, `flag`) VALUES
(1, 'Stationary', 1);

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

--
-- Table structure for table `explosive_return_dtl`
--

CREATE TABLE `explosive_return_dtl` (
  `id` int(11) NOT NULL,
  `hdr_id` int(11) DEFAULT NULL,
  `explosiveID` int(11) DEFAULT NULL,
  `explosiveqty` int(11) DEFAULT NULL,
  `explosivereturnqty` varchar(12) NOT NULL,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `explosive_return_hdr`
--

CREATE TABLE `explosive_return_hdr` (
  `id` int(11) NOT NULL,
  `invoice` varchar(50) DEFAULT NULL,
  `invoicedate` date DEFAULT NULL,
  `vehicleno` int(11) DEFAULT NULL,
  `givenby` varchar(240) DEFAULT NULL,
  `receivedby` varchar(240) DEFAULT NULL,
  `remarks` text,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `lastupdated` date DEFAULT NULL,
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `explosive_stock`
--

CREATE TABLE `explosive_stock` (
  `id` int(11) NOT NULL,
  `explosivecode` varchar(100) NOT NULL,
  `explosivename` varchar(100) NOT NULL,
  `stock` varchar(28) NOT NULL,
  `isdelete` tinyint(4) NOT NULL,
  `createdby` varchar(200) NOT NULL,
  `userID` int(11) NOT NULL,
  `createdate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `explosive_stock`
--

INSERT INTO `explosive_stock` (`id`, `explosivecode`, `explosivename`, `stock`, `isdelete`, `createdby`, `userID`, `createdate`) VALUES
(1, 'EX-1', 'ED', '0', 1, 'admin', 1, '2023-10-11'),
(2, 'EX-2', 'Thotta', '0', 1, 'admin', 1, '2023-10-11');

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

--
-- Table structure for table `explosive_utiliz`
--

CREATE TABLE `explosive_utiliz` (
  `id` int(11) NOT NULL,
  `utilize_code` varchar(64) NOT NULL,
  `utilizedate` date NOT NULL,
  `one` varchar(32) NOT NULL,
  `two` varchar(32) NOT NULL,
  `twoandhalf` varchar(32) NOT NULL,
  `three` varchar(32) NOT NULL,
  `four` varchar(32) NOT NULL,
  `five` varchar(32) NOT NULL,
  `six` varchar(32) NOT NULL,
  `seven` varchar(32) NOT NULL,
  `sevenandhalf` varchar(32) NOT NULL,
  `eight` varchar(32) NOT NULL,
  `hole` varchar(32) NOT NULL,
  `totalfeet` varchar(32) NOT NULL,
  `labour` varchar(32) NOT NULL,
  `ed` varchar(32) NOT NULL,
  `thotta90` varchar(32) NOT NULL,
  `nonel3m` varchar(32) NOT NULL,
  `nonel4m` varchar(32) NOT NULL,
  `dd` varchar(32) NOT NULL,
  `cost_feet` varchar(32) NOT NULL,
  `total_cost` varchar(32) NOT NULL,
  `contractor` varchar(32) NOT NULL,
  `remark` varchar(128) NOT NULL,
  `isdelete` tinyint(4) NOT NULL,
  `accountyear` varchar(32) NOT NULL,
  `createdby` varchar(32) NOT NULL,
  `userID` int(11) NOT NULL,
  `createdate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `explosive_utiliz_dtl`
--

CREATE TABLE `explosive_utiliz_dtl` (
  `id` int(11) NOT NULL,
  `hdr_id` int(11) NOT NULL,
  `utilizedate` varchar(32) NOT NULL,
  `explosiveID` int(11) NOT NULL,
  `explosivename` varchar(32) NOT NULL,
  `qty` varchar(32) NOT NULL,
  `status` varchar(16) NOT NULL,
  `create_date` date NOT NULL,
  `flag` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `explosive_utiliz_dtl`
--

INSERT INTO `explosive_utiliz_dtl` (`id`, `hdr_id`, `utilizedate`, `explosiveID`, `explosivename`, `qty`, `status`, `create_date`, `flag`) VALUES
(1, 6, '2023-10-16', 1, 'ED', '20', 'DELETED', '0000-00-00', 1),
(2, 6, '2023-10-16', 2, 'Thotta', '10', 'DELETED', '0000-00-00', 1),
(3, 10, '2023-10-16', 1, 'ED', '20', '', '2023-10-16', 1),
(4, 10, '2023-10-16', 2, 'Thotta', '10', '', '2023-10-16', 1);

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

--
-- Table structure for table `explosive_utiliz_hdr`
--

CREATE TABLE `explosive_utiliz_hdr` (
  `id` int(11) NOT NULL,
  `utilize_code` varchar(64) NOT NULL,
  `utilizedate` date NOT NULL,
  `contractor` varchar(32) NOT NULL,
  `contractor_name` varchar(64) NOT NULL,
  `process_type` varchar(32) NOT NULL,
  `starting_hrs` decimal(10,2) NOT NULL,
  `closing_hrs` decimal(10,2) NOT NULL,
  `starting_unit` decimal(10,2) NOT NULL,
  `closing_unit` decimal(10,2) NOT NULL,
  `running_hrs` decimal(10,2) NOT NULL,
  `running_unit` decimal(10,2) NOT NULL,
  `one` varchar(32) NOT NULL,
  `two` varchar(32) NOT NULL,
  `three` int(11) NOT NULL,
  `four` varchar(32) NOT NULL,
  `six` varchar(32) NOT NULL,
  `eight` varchar(32) NOT NULL,
  `hole` varchar(32) NOT NULL,
  `totalfeet` varchar(32) NOT NULL,
  `labour` varchar(32) NOT NULL,
  `cost_feet` varchar(32) NOT NULL,
  `total_cost` varchar(32) NOT NULL,
  `remark` varchar(128) NOT NULL,
  `status` varchar(16) NOT NULL,
  `isdelete` tinyint(4) NOT NULL,
  `accountyear` varchar(32) NOT NULL,
  `createdby` varchar(32) NOT NULL,
  `userID` int(11) NOT NULL,
  `createdate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `explosive_utiliz_hdr`
--

INSERT INTO `explosive_utiliz_hdr` (`id`, `utilize_code`, `utilizedate`, `contractor`, `contractor_name`, `process_type`, `starting_hrs`, `closing_hrs`, `starting_unit`, `closing_unit`, `running_hrs`, `running_unit`, `one`, `two`, `three`, `four`, `six`, `eight`, `hole`, `totalfeet`, `labour`, `cost_feet`, `total_cost`, `remark`, `status`, `isdelete`, `accountyear`, `createdby`, `userID`, `createdate`) VALUES
(1, '1', '2023-10-16', '5', 'KCP', 'process_type', '5.00', '20.00', '50.00', '60.00', '15.00', '10.00', '1', '2', 3, '4', '6', '8', '24', '130', '6', '5', '650', 'test', 'DELETED', 1, '2023-2024', 'admin', 1, '2023-10-16'),
(6, '1', '2023-10-16', '5', 'KCP', 'process_type', '5.00', '20.00', '50.00', '60.00', '15.00', '10.00', '1', '2', 3, '4', '6', '8', '24', '130', '6', '5', '650', 'test', 'DELETED', 1, '2023-2024', 'admin', 1, '2023-10-16'),
(10, '1', '2023-10-16', '5', 'KCP', 'process_type', '5.00', '20.00', '50.00', '60.00', '15.00', '10.00', '1', '2', 3, '4', '6', '8', '24', '130', '6', '5', '650', 'test', '', 1, '2023-2024', 'admin', 1, '2023-10-16');

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

--
-- Table structure for table `externalfill_diesel`
--

CREATE TABLE `externalfill_diesel` (
  `id` int(11) NOT NULL,
  `invoice` varchar(50) DEFAULT NULL,
  `dieseldate` date DEFAULT NULL,
  `supplierid` int(11) NOT NULL,
  `sname` varchar(100) NOT NULL,
  `vehicleid` int(11) NOT NULL,
  `vehicleno` varchar(11) DEFAULT NULL,
  `driverid` varchar(20) NOT NULL,
  `drivername` varchar(40) NOT NULL,
  `inchargeid` varchar(20) NOT NULL,
  `inchargename` varchar(40) NOT NULL,
  `previouskms` varchar(200) NOT NULL,
  `previoushrs` varchar(200) NOT NULL,
  `preiousqty` varchar(100) NOT NULL,
  `intakekm` float DEFAULT NULL,
  `intakehrs` decimal(19,2) DEFAULT NULL,
  `litres` float DEFAULT NULL,
  `rate` varchar(100) NOT NULL,
  `amount` decimal(10,0) NOT NULL,
  `mileage` varchar(20) NOT NULL,
  `hmileage` varchar(20) NOT NULL,
  `remarks` varchar(512) NOT NULL,
  `filling_type` varchar(64) NOT NULL,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `lastupdated` date DEFAULT NULL,
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `externalfill_diesel`
--

INSERT INTO `externalfill_diesel` (`id`, `invoice`, `dieseldate`, `supplierid`, `sname`, `vehicleid`, `vehicleno`, `driverid`, `drivername`, `inchargeid`, `inchargename`, `previouskms`, `previoushrs`, `preiousqty`, `intakekm`, `intakehrs`, `litres`, `rate`, `amount`, `mileage`, `hmileage`, `remarks`, `filling_type`, `accountyear`, `createdate`, `lastupdated`, `createdby`, `userID`, `isdelete`) VALUES
(1, '1', '2023-10-12', 3, 'Indian Agencies', 24, 'TN88Z1864', '5', 'MANIKANDAN', '', 'Nirmal', '150', '210.00', '50.00   ', 260, '280.00', 100, '102', '10200', '1.10', '0.70', '', 'fill', '2023-2024', '2023-10-12', '2023-10-12', 'admin', 1, 1);

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

--
-- Table structure for table `externalpro_diesel`
--

CREATE TABLE `externalpro_diesel` (
  `id` int(11) NOT NULL,
  `invoice` varchar(50) DEFAULT NULL,
  `dieseldate` date DEFAULT NULL,
  `supplierid` int(11) NOT NULL,
  `sname` varchar(70) NOT NULL,
  `vehicleid` int(11) NOT NULL,
  `vehicleno` varchar(11) DEFAULT NULL,
  `driverid` int(11) NOT NULL,
  `drivername` varchar(100) NOT NULL,
  `intakekm` float DEFAULT NULL,
  `intakehrs` decimal(19,2) DEFAULT NULL,
  `litres` float DEFAULT NULL,
  `rate` varchar(100) NOT NULL,
  `amount` decimal(10,0) NOT NULL,
  `filling_type` varchar(64) NOT NULL,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `lastupdated` date DEFAULT NULL,
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `externalpro_diesel`
--

INSERT INTO `externalpro_diesel` (`id`, `invoice`, `dieseldate`, `supplierid`, `sname`, `vehicleid`, `vehicleno`, `driverid`, `drivername`, `intakekm`, `intakehrs`, `litres`, `rate`, `amount`, `filling_type`, `accountyear`, `createdate`, `lastupdated`, `createdby`, `userID`, `isdelete`) VALUES
(1, '1', '2023-10-12', 3, 'Indian Agencies', 24, 'TN88Z1864', 4, 'BASKAR', 250, '270.00', 60, '101', '6060', 'unfill', '2023-2024', '2023-10-12', '2023-10-12', 'admin', 1, 1);

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

--
-- Table structure for table `fill_diesel`
--

CREATE TABLE `fill_diesel` (
  `id` int(11) NOT NULL,
  `invoice` varchar(50) NOT NULL,
  `dieseldate` date NOT NULL,
  `vehicleid` int(11) NOT NULL,
  `vehicleno` varchar(44) NOT NULL,
  `driverid` varchar(44) NOT NULL,
  `drivername` varchar(55) NOT NULL,
  `intakekm` decimal(10,0) NOT NULL,
  `intakehrs` decimal(19,2) NOT NULL,
  `litres` float NOT NULL,
  `filling_type` varchar(55) NOT NULL,
  `accountyear` varchar(55) NOT NULL,
  `createdate` date NOT NULL,
  `createdby` varchar(55) NOT NULL,
  `userID` int(11) NOT NULL,
  `isdelete` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fill_diesel`
--

INSERT INTO `fill_diesel` (`id`, `invoice`, `dieseldate`, `vehicleid`, `vehicleno`, `driverid`, `drivername`, `intakekm`, `intakehrs`, `litres`, `filling_type`, `accountyear`, `createdate`, `createdby`, `userID`, `isdelete`) VALUES
(1, '1', '2023-10-11', 24, 'TN88Z1864', '1', 'RAMA CHANDRAN', '150', '210.00', 50, 'internalfill', '2023-2024', '2023-10-11', 'admin', 1, 1),
(2, '1', '2023-10-12', 24, 'TN88Z1864', '5', 'MANIKANDAN', '260', '280.00', 100, 'externalfill', '2023-2024', '2023-10-12', 'admin', 1, 1);

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

--
-- Table structure for table `internalpro_diesel`
--

CREATE TABLE `internalpro_diesel` (
  `id` int(11) NOT NULL,
  `invoice` varchar(50) DEFAULT NULL,
  `dieseldate` date DEFAULT NULL,
  `vehicleid` int(11) NOT NULL,
  `vehicleno` varchar(11) DEFAULT NULL,
  `driverid` varchar(20) NOT NULL,
  `drivername` varchar(40) NOT NULL,
  `inchargeid` varchar(20) NOT NULL,
  `inchargename` varchar(40) NOT NULL,
  `previouskms` varchar(200) NOT NULL,
  `previoushrs` varchar(200) NOT NULL,
  `preiousqty` varchar(100) NOT NULL,
  `intakekm` float DEFAULT NULL,
  `intakehrs` decimal(19,2) DEFAULT NULL,
  `litres` float DEFAULT NULL,
  `mileage` varchar(20) NOT NULL,
  `hmileage` varchar(20) NOT NULL,
  `remarks` varchar(512) NOT NULL,
  `filling_type` varchar(64) NOT NULL,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `lastupdated` date DEFAULT NULL,
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `internalpro_diesel`
--

INSERT INTO `internalpro_diesel` (`id`, `invoice`, `dieseldate`, `vehicleid`, `vehicleno`, `driverid`, `drivername`, `inchargeid`, `inchargename`, `previouskms`, `previoushrs`, `preiousqty`, `intakekm`, `intakehrs`, `litres`, `mileage`, `hmileage`, `remarks`, `filling_type`, `accountyear`, `createdate`, `lastupdated`, `createdby`, `userID`, `isdelete`) VALUES
(1, '1', '2023-10-11', 24, 'TN88Z1864', '1', 'RAMA CHANDRAN', '2', 'MUTHUKUMARESAN', '100', '200', '0   ', 150, '210.00', 50, '1.00', '0.20', '', 'fill', '2023-2024', '2023-10-11', '2023-10-11', 'admin', 1, 1);

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

--
-- Table structure for table `internalpro_explosive_dtl`
--

CREATE TABLE `internalpro_explosive_dtl` (
  `id` int(11) NOT NULL,
  `hdr_id` int(11) DEFAULT NULL,
  `explosiveID` int(11) DEFAULT NULL,
  `explosiveqty` int(11) DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `internalpro_explosive_dtl`
--

INSERT INTO `internalpro_explosive_dtl` (`id`, `hdr_id`, `explosiveID`, `explosiveqty`, `accountyear`, `createdate`, `createdby`, `userID`, `isdelete`) VALUES
(1, 1, 1, 25, '2023-2024', '2023-10-12', 'admin', 1, 1),
(2, 1, 2, 10, '2023-2024', '2023-10-12', 'admin', 1, 1);

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

--
-- Table structure for table `internalpro_explosive_hdr`
--

CREATE TABLE `internalpro_explosive_hdr` (
  `id` int(11) NOT NULL,
  `invoice` varchar(50) DEFAULT NULL,
  `invoicedate` date DEFAULT NULL,
  `vehicleno` int(11) DEFAULT NULL,
  `givenby` varchar(240) DEFAULT NULL,
  `receivedby` varchar(240) DEFAULT NULL,
  `remarks` text,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `lastupdated` date DEFAULT NULL,
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `internalpro_explosive_hdr`
--

INSERT INTO `internalpro_explosive_hdr` (`id`, `invoice`, `invoicedate`, `vehicleno`, `givenby`, `receivedby`, `remarks`, `accountyear`, `createdate`, `lastupdated`, `createdby`, `userID`, `isdelete`) VALUES
(1, '1', '2023-10-12', 0, 'Jega', 'Bala', 'test', '2023-2024', '2023-10-12', NULL, 'admin', 1, 1);

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

--
-- Table structure for table `internalpro_spare_dtl`
--

CREATE TABLE `internalpro_spare_dtl` (
  `id` int(11) NOT NULL,
  `hdr_id` int(11) DEFAULT NULL,
  `spareID` int(11) DEFAULT NULL,
  `spareqty` int(11) DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `internalpro_spare_dtl`
--

INSERT INTO `internalpro_spare_dtl` (`id`, `hdr_id`, `spareID`, `spareqty`, `accountyear`, `createdate`, `createdby`, `userID`, `isdelete`) VALUES
(3, 1, 3, 20, '2023-2024', '2023-10-16', 'admin', 1, 1),
(4, 1, 5, 30, '2023-2024', '2023-10-16', 'admin', 1, 1);

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

--
-- Table structure for table `internalpro_spare_hdr`
--

CREATE TABLE `internalpro_spare_hdr` (
  `id` int(11) NOT NULL,
  `invoice` varchar(50) DEFAULT NULL,
  `invoicedate` date DEFAULT NULL,
  `vehicleno` int(11) DEFAULT NULL,
  `kms` varchar(16) NOT NULL,
  `hrs` varchar(16) NOT NULL,
  `givenby` varchar(240) DEFAULT NULL,
  `receivedby` varchar(240) DEFAULT NULL,
  `remarks` text,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `lastupdated` date DEFAULT NULL,
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `internalpro_spare_hdr`
--

INSERT INTO `internalpro_spare_hdr` (`id`, `invoice`, `invoicedate`, `vehicleno`, `kms`, `hrs`, `givenby`, `receivedby`, `remarks`, `accountyear`, `createdate`, `lastupdated`, `createdby`, `userID`, `isdelete`) VALUES
(1, '1', '2023-10-16', 22, '2500', '1500', 'Jega', 'Bala', 'test', '2023-2024', '2023-10-16', '2023-10-16', 'admin', 1, 1);

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

--
-- Table structure for table `internalunfillpro_diesel`
--

CREATE TABLE `internalunfillpro_diesel` (
  `id` int(11) NOT NULL,
  `invoice` varchar(50) DEFAULT NULL,
  `dieseldate` date DEFAULT NULL,
  `vehicleid` int(11) DEFAULT NULL,
  `vehicleno` varchar(100) NOT NULL,
  `driverid` int(11) NOT NULL,
  `drivername` varchar(100) NOT NULL,
  `litres` float DEFAULT NULL,
  `filling_type` varchar(64) NOT NULL,
  `intakekm` float DEFAULT NULL,
  `intakehrs` decimal(19,2) DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `lastupdated` date DEFAULT NULL,
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `internalunfillpro_diesel`
--

INSERT INTO `internalunfillpro_diesel` (`id`, `invoice`, `dieseldate`, `vehicleid`, `vehicleno`, `driverid`, `drivername`, `litres`, `filling_type`, `intakekm`, `intakehrs`, `accountyear`, `createdate`, `lastupdated`, `createdby`, `userID`, `isdelete`) VALUES
(1, '1', '2023-10-12', 24, 'TN88Z1864', 2, 'MUTHUKUMARESAN', 50, 'unfill', 220, '230.00', '2023-2024', '2023-10-12', '2023-10-12', 'admin', 1, 1);

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

--
-- Table structure for table `login_details`
--

CREATE TABLE `login_details` (
  `id` bigint(20) NOT NULL,
  `login_date_start` datetime DEFAULT NULL,
  `ip` text,
  `useragent` text,
  `userid` int(11) DEFAULT NULL,
  `session_code` int(11) DEFAULT NULL,
  `login_date_end` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `login_details`
--

INSERT INTO `login_details` (`id`, `login_date_start`, `ip`, `useragent`, `userid`, `session_code`, `login_date_end`) VALUES
(0, '2023-10-10 10:31:44', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 1, 95790, NULL),
(1, '2023-10-09 14:32:31', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 1, 73935, NULL),
(2, NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 1, 23367, '2023-10-09 16:23:22'),
(3, '2023-10-09 16:25:01', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 1, 20102, NULL),
(4, NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 0, 0, '2023-10-12 14:05:32'),
(5, '2023-10-12 14:05:41', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 1, 95040, NULL),
(6, '2023-10-13 11:12:23', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 1, 42121, NULL),
(7, NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 0, 0, '2023-10-13 16:07:02'),
(8, '2023-10-13 16:07:07', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 1, 42311, NULL),
(9, NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 0, 0, '2023-10-16 10:49:30'),
(10, '2023-10-16 10:49:35', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36', 1, 44568, NULL),
(11, '2023-10-16 20:51:49', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 1, 98086, NULL),
(12, NULL, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 0, 0, '2023-10-16 21:03:15'),
(13, '2023-10-16 21:03:19', '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36', 1, 36639, NULL);

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

--
-- Table structure for table `product_master`
--

CREATE TABLE `product_master` (
  `id` int(11) NOT NULL,
  `productcode` text,
  `productname` text,
  `product_type` varchar(32) NOT NULL,
  `qty_type` varchar(32) NOT NULL,
  `purchase_rate` text,
  `gst` text,
  `hsn_code` varchar(250) DEFAULT NULL,
  `prodct_description` text,
  `create_date` varchar(50) DEFAULT NULL,
  `isdelete` tinyint(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `product_master`
--

INSERT INTO `product_master` (`id`, `productcode`, `productname`, `product_type`, `qty_type`, `purchase_rate`, `gst`, `hsn_code`, `prodct_description`, `create_date`, `isdelete`) VALUES
(1, '1', 'ED', 'Explosive', 'Nos', '100', '18', '52586', '', '2023-10-13 16:23:35', 1),
(2, '2', 'Thotta', 'Explosive', 'Nos', '1500', '18', '3455', '', '2023-10-13 16:23:53', 1),
(3, '3', 'Bearin', 'Spare', 'Nos', '18', '5', '152', '', '2023-10-13 16:24:15', 1),
(4, '4', 'Liver', 'Spare', 'Nos', '5000', '18', '2542', '', '2023-10-13 16:25:50', 1),
(5, '5', 'Bolt', 'Spare', 'Nos', '1500', '18', '2568', '', '2023-10-13 16:26:14', 1);

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

--
-- Table structure for table `purchasedetails`
--

CREATE TABLE `purchasedetails` (
  `id` int(11) NOT NULL,
  `purchaseheader_id` int(11) DEFAULT NULL,
  `productID` int(11) DEFAULT NULL,
  `product_type` varchar(32) NOT NULL,
  `purchase_eqty` decimal(10,2) DEFAULT NULL,
  `purchase_prate` decimal(10,2) DEFAULT NULL,
  `purchase_gst` decimal(10,2) DEFAULT NULL,
  `purchase_cgst` decimal(10,2) DEFAULT NULL,
  `purchase_sgst` decimal(10,2) DEFAULT NULL,
  `purchasenetamt` decimal(10,2) DEFAULT NULL,
  `status` varchar(32) NOT NULL,
  `create_date` varchar(150) DEFAULT NULL,
  `flag` tinyint(2) DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `purchasedetails`
--

INSERT INTO `purchasedetails` (`id`, `purchaseheader_id`, `productID`, `product_type`, `purchase_eqty`, `purchase_prate`, `purchase_gst`, `purchase_cgst`, `purchase_sgst`, `purchasenetamt`, `status`, `create_date`, `flag`, `accountyear`) VALUES
(1, 1, 3, 'Spare', '100.00', '250.00', '5.00', '625.00', '625.00', '25000.00', '', '2023-10-16 11:10:55', 1, '2023-2024'),
(2, 1, 5, 'Spare', '150.00', '1500.00', '18.00', '20250.00', '20250.00', '225000.00', '', '2023-10-16 11:10:55', 1, '2023-2024'),
(3, 2, 1, 'Explosive', '200.00', '100.00', '18.00', '1800.00', '1800.00', '20000.00', '', '2023-10-16 11:14:48', 1, '2023-2024'),
(4, 2, 2, 'Explosive', '250.00', '1500.00', '18.00', '33750.00', '33750.00', '375000.00', '', '2023-10-16 11:14:48', 1, '2023-2024');

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

--
-- Table structure for table `purchasedetailswo`
--

CREATE TABLE `purchasedetailswo` (
  `id` int(11) NOT NULL,
  `purchaseheader_id` int(11) DEFAULT NULL,
  `productID` int(11) DEFAULT NULL,
  `product_type` varchar(32) NOT NULL,
  `purchase_eqty` decimal(10,2) DEFAULT NULL,
  `purchase_prate` decimal(10,2) DEFAULT NULL,
  `purchase_gst` decimal(10,2) DEFAULT NULL,
  `purchase_cgst` decimal(10,2) DEFAULT NULL,
  `purchase_sgst` decimal(10,2) DEFAULT NULL,
  `purchasenetamt` decimal(10,2) DEFAULT NULL,
  `status` varchar(32) NOT NULL,
  `create_date` varchar(150) DEFAULT NULL,
  `flag` tinyint(2) DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `purchasedetailswo`
--

INSERT INTO `purchasedetailswo` (`id`, `purchaseheader_id`, `productID`, `product_type`, `purchase_eqty`, `purchase_prate`, `purchase_gst`, `purchase_cgst`, `purchase_sgst`, `purchasenetamt`, `status`, `create_date`, `flag`, `accountyear`) VALUES
(1, 1, 3, 'Spare', '20.00', '18.00', '0.00', '0.00', '0.00', '360.00', '', '2023-10-16 11:12:09', 1, '2023-2024'),
(2, 1, 5, 'Spare', '30.00', '1500.00', '0.00', '0.00', '0.00', '45000.00', '', '2023-10-16 11:12:09', 1, '2023-2024'),
(3, 2, 1, 'Explosive', '50.00', '100.00', '0.00', '0.00', '0.00', '5000.00', '', '2023-10-16 11:15:23', 1, '2023-2024'),
(4, 2, 2, 'Explosive', '60.00', '1500.00', '0.00', '0.00', '0.00', '90000.00', '', '2023-10-16 11:15:23', 1, '2023-2024');

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

--
-- Table structure for table `purchaseheader`
--

CREATE TABLE `purchaseheader` (
  `id` int(11) NOT NULL,
  `invoice_no` varchar(250) DEFAULT NULL,
  `purchase_date` date DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `po_num` varchar(120) DEFAULT NULL,
  `btime` varchar(32) NOT NULL,
  `itemcount` int(11) DEFAULT NULL,
  `tamount` varchar(50) DEFAULT NULL,
  `remark` varchar(1024) NOT NULL,
  `status` varchar(32) NOT NULL,
  `create_date` varchar(50) DEFAULT NULL,
  `flag` tinyint(2) DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `purchaseheader`
--

INSERT INTO `purchaseheader` (`id`, `invoice_no`, `purchase_date`, `supplier_id`, `po_num`, `btime`, `itemcount`, `tamount`, `remark`, `status`, `create_date`, `flag`, `accountyear`) VALUES
(1, 'G/2023-2024/001', '2023-10-16', 2, '1', '11:10:00 AM', 2, '291750', 'test', '', '2023-10-16 11:10:55', 1, '2023-2024'),
(2, 'G/2023-2024/002', '2023-10-18', 1, '35', '11:14:11 AM', 2, '466100', 'qwerty', '', '2023-10-16 11:14:48', 1, '2023-2024');

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

--
-- Table structure for table `purchaseheaderwo`
--

CREATE TABLE `purchaseheaderwo` (
  `id` int(11) NOT NULL,
  `invoice_no` varchar(250) DEFAULT NULL,
  `purchase_date` date DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `po_num` varchar(120) DEFAULT NULL,
  `btime` varchar(32) NOT NULL,
  `itemcount` int(11) DEFAULT NULL,
  `tamount` varchar(50) DEFAULT NULL,
  `remark` varchar(1024) NOT NULL,
  `status` varchar(32) NOT NULL,
  `create_date` varchar(50) DEFAULT NULL,
  `flag` tinyint(2) DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `purchaseheaderwo`
--

INSERT INTO `purchaseheaderwo` (`id`, `invoice_no`, `purchase_date`, `supplier_id`, `po_num`, `btime`, `itemcount`, `tamount`, `remark`, `status`, `create_date`, `flag`, `accountyear`) VALUES
(1, 'E/2023-2024/001', '2023-10-17', 2, '2', '11:11:44 AM', 2, '45360', '231', '', '2023-10-16 11:12:09', 1, '2023-2024'),
(2, 'E/2023-2024/002', '2023-10-18', 1, '32', '11:14:53 AM', 2, '95000', '', '', '2023-10-16 11:15:23', 1, '2023-2024');

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

--
-- Table structure for table `purchase_dieselinvoice`
--

CREATE TABLE `purchase_dieselinvoice` (
  `id` int(11) NOT NULL,
  `dieselinvoice` varchar(50) DEFAULT NULL,
  `dieseldate` date DEFAULT NULL,
  `supplierid` int(11) DEFAULT NULL,
  `sname` varchar(100) NOT NULL,
  `supplierinvoice` varchar(10) DEFAULT NULL,
  `vehicleno` varchar(200) DEFAULT NULL,
  `litres` float DEFAULT NULL,
  `rate1` varchar(20) NOT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `diesel_stock` float DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `lastupdated` date DEFAULT NULL,
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `purchase_dieselinvoice`
--

INSERT INTO `purchase_dieselinvoice` (`id`, `dieselinvoice`, `dieseldate`, `supplierid`, `sname`, `supplierinvoice`, `vehicleno`, `litres`, `rate1`, `amount`, `diesel_stock`, `accountyear`, `createdate`, `lastupdated`, `createdby`, `userID`, `isdelete`) VALUES
(1, '1', '2023-10-11', 3, 'Indian Agencies', '258', 'TN81R1244', 1250, '102', '127500.00', NULL, '2023-2024', '2023-10-11', '2023-10-11', 'admin', 1, 1);

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

--
-- Table structure for table `purchase_explosiveinvoice_dtl`
--

CREATE TABLE `purchase_explosiveinvoice_dtl` (
  `id` int(11) NOT NULL,
  `hdr_id` int(11) DEFAULT NULL,
  `explosiveID` int(11) DEFAULT NULL,
  `explosivename` varchar(64) NOT NULL,
  `explosiveqty` int(11) DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `purchase_explosiveinvoice_dtl`
--

INSERT INTO `purchase_explosiveinvoice_dtl` (`id`, `hdr_id`, `explosiveID`, `explosivename`, `explosiveqty`, `accountyear`, `createdate`, `createdby`, `userID`, `isdelete`) VALUES
(3, 1, 1, 'ED', 100, '2023-2024', '2023-10-11', 'admin', 1, 1),
(4, 1, 2, 'Thotta', 150, '2023-2024', '2023-10-11', 'admin', 1, 1);

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

--
-- Table structure for table `purchase_explosiveinvoice_hdr`
--

CREATE TABLE `purchase_explosiveinvoice_hdr` (
  `id` int(11) NOT NULL,
  `explosiveinvoice` varchar(50) DEFAULT NULL,
  `invoicedate` date DEFAULT NULL,
  `supplierdetails` int(11) DEFAULT NULL,
  `supplierinvoice_no` varchar(30) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `lastupdated` date DEFAULT NULL,
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `purchase_explosiveinvoice_hdr`
--

INSERT INTO `purchase_explosiveinvoice_hdr` (`id`, `explosiveinvoice`, `invoicedate`, `supplierdetails`, `supplierinvoice_no`, `amount`, `accountyear`, `createdate`, `lastupdated`, `createdby`, `userID`, `isdelete`) VALUES
(1, '1', '2023-10-11', 1, '456', '13000.00', '2023-2024', '2023-10-11', '2023-10-11', 'admin', 1, 1);

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

--
-- Table structure for table `purchase_spareinvoice_dtl`
--

CREATE TABLE `purchase_spareinvoice_dtl` (
  `id` int(11) NOT NULL,
  `hdr_id` int(11) DEFAULT NULL,
  `spareID` int(11) DEFAULT NULL,
  `spareqty` int(11) DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `purchase_spareinvoice_hdr`
--

CREATE TABLE `purchase_spareinvoice_hdr` (
  `id` int(11) NOT NULL,
  `spareinvoice` varchar(50) DEFAULT NULL,
  `invoicedate` date DEFAULT NULL,
  `supplierdetails` int(11) DEFAULT NULL,
  `supplierinvoice_no` varchar(30) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `lastupdated` date DEFAULT NULL,
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `supplier_master`
--

CREATE TABLE `supplier_master` (
  `id` int(11) NOT NULL,
  `sname` varchar(250) DEFAULT NULL,
  `saddress` text,
  `supplier_state` varchar(250) DEFAULT NULL,
  `pincode` varchar(50) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `email` varchar(250) DEFAULT NULL,
  `gstin` text,
  `pan` varchar(12) NOT NULL,
  `other_ref` text,
  `scode` varchar(250) DEFAULT NULL,
  `stype` varchar(23) NOT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `supplier_master`
--

INSERT INTO `supplier_master` (`id`, `sname`, `saddress`, `supplier_state`, `pincode`, `mobile`, `email`, `gstin`, `pan`, `other_ref`, `scode`, `stype`, `createdate`, `createdby`, `userID`, `isdelete`) VALUES
(1, 'Feenixinfotech', 'PN Palayam', 'TamilNadu', '641038', '7708852568', '', '33AA64646', '', NULL, 'SUPP-1', 'Explosive', '2023-10-11', 'admin', 1, 1),
(2, 'Rapidtech', 'Bharathiyar Road', 'TamilNadu', '641035', '8124010235', '', '33AA64646', '', NULL, 'SUPP-2', 'Spare', '2023-10-11', 'admin', 1, 1),
(3, 'Indian Agencies', 'Cbe', 'TamilNadu', '637412', '8422532155', '', '', '', NULL, 'SUPP-3', 'Diesel', '2023-10-11', 'admin', 1, 1),
(4, 'VSI', 'PT', 'SELECT STATE', '641025', '7758852569', '', '', '', NULL, 'SUPP-4', 'Contractor', '2023-10-16', 'admin', 1, 1),
(5, 'KCP', 'PNP', 'TamilNadu', '6410258', '9975525285', '', '', '', NULL, 'SUPP-5', 'Contractor', '2023-10-16', 'admin', 1, 1);

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

--
-- Table structure for table `supplier_payment`
--

CREATE TABLE `supplier_payment` (
  `id` int(11) NOT NULL,
  `invoice` varchar(50) DEFAULT NULL,
  `invoicedate` date DEFAULT NULL,
  `supplierid` int(11) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `pay_type` varchar(100) DEFAULT NULL,
  `paymentreference` text,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `lastupdated` date DEFAULT NULL,
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `supplier_payment`
--

INSERT INTO `supplier_payment` (`id`, `invoice`, `invoicedate`, `supplierid`, `amount`, `pay_type`, `paymentreference`, `accountyear`, `createdate`, `lastupdated`, `createdby`, `userID`, `isdelete`) VALUES
(1, '1', '2023-10-16', 5, '50.00', 'cash', '', '2023-2024', '2023-10-16', '2023-10-16', 'admin', 1, 1);

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

--
-- Table structure for table `supplier_payment_header`
--

CREATE TABLE `supplier_payment_header` (
  `id` int(11) NOT NULL,
  `cashno` varchar(255) DEFAULT NULL,
  `collectiondate` varchar(100) DEFAULT NULL,
  `supplierID` int(11) DEFAULT NULL,
  `pending` decimal(10,2) NOT NULL,
  `paymenttype` varchar(32) NOT NULL,
  `paymentreference` varchar(32) NOT NULL,
  `flag` tinyint(2) DEFAULT NULL,
  `status` varchar(32) NOT NULL,
  `bank_name` varchar(32) NOT NULL,
  `handover` varchar(32) NOT NULL,
  `transactionno` varchar(32) NOT NULL,
  `remark` varchar(512) NOT NULL,
  `paidby` varchar(32) NOT NULL,
  `received_amount` decimal(10,2) NOT NULL,
  `accountyear` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `supplier_payment_header`
--

INSERT INTO `supplier_payment_header` (`id`, `cashno`, `collectiondate`, `supplierID`, `pending`, `paymenttype`, `paymentreference`, `flag`, `status`, `bank_name`, `handover`, `transactionno`, `remark`, `paidby`, `received_amount`, `accountyear`) VALUES
(1, 'C-2023-2024-1', '2023-10-16', 1, '466100.00', 'cash', '', 1, 'DELETED', '', 'te', '', 'df', 'admin', '6100.00', '2023-2024'),
(2, 'C-2023-2024-1', '2023-10-16', 1, '466100.00', 'cash', '', 1, '', '', 'te', '', 'df', 'admin', '6100.00', '2023-2024');

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

--
-- Table structure for table `supplier_payment_headerwo`
--

CREATE TABLE `supplier_payment_headerwo` (
  `id` int(11) NOT NULL,
  `cashno` varchar(255) DEFAULT NULL,
  `collectiondate` varchar(100) DEFAULT NULL,
  `supplierID` int(11) DEFAULT NULL,
  `pending` decimal(10,2) NOT NULL,
  `paymenttype` varchar(32) NOT NULL,
  `paymentreference` varchar(32) NOT NULL,
  `flag` tinyint(2) DEFAULT NULL,
  `status` varchar(32) NOT NULL,
  `bank_name` varchar(32) NOT NULL,
  `handover` varchar(32) NOT NULL,
  `transactionno` varchar(32) NOT NULL,
  `remark` varchar(512) NOT NULL,
  `paidby` varchar(32) NOT NULL,
  `received_amount` decimal(10,2) NOT NULL,
  `accountyear` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `supplier_payment_headerwo`
--

INSERT INTO `supplier_payment_headerwo` (`id`, `cashno`, `collectiondate`, `supplierID`, `pending`, `paymenttype`, `paymentreference`, `flag`, `status`, `bank_name`, `handover`, `transactionno`, `remark`, `paidby`, `received_amount`, `accountyear`) VALUES
(1, 'ESTC-2023-2024-1', '2023-10-17', 1, '95000.00', 'cash', '', 1, 'DELETED', '', '', '', '', 'admin', '4000.00', '2023-2024'),
(2, 'ESTC-2023-2024-1', '2023-10-17', 1, '95000.00', 'cash', '', 1, 'DELETED', '', '', '', '', 'admin', '4000.00', '2023-2024'),
(3, 'ESTC-2023-2024-1', '2023-10-17', 1, '95000.00', 'cash', '', 1, '', '', '', '', '', 'admin', '5000.00', '2023-2024');

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

--
-- Table structure for table `supplier_payment_spare`
--

CREATE TABLE `supplier_payment_spare` (
  `id` int(11) NOT NULL,
  `cashno` varchar(255) DEFAULT NULL,
  `collectiondate` varchar(100) DEFAULT NULL,
  `supplierID` int(11) DEFAULT NULL,
  `pending` decimal(10,2) DEFAULT NULL,
  `paymenttype` text,
  `amount` decimal(10,2) DEFAULT NULL,
  `flag` tinyint(2) DEFAULT NULL,
  `purchaseID` int(11) DEFAULT NULL,
  `paymentreference` varchar(250) DEFAULT NULL,
  `bank_name` varchar(32) NOT NULL,
  `handover` varchar(32) NOT NULL,
  `transactionno` varchar(32) NOT NULL,
  `remark` varchar(256) NOT NULL,
  `status` varchar(32) NOT NULL,
  `paidby` varchar(32) NOT NULL,
  `pending_billamount` decimal(10,2) NOT NULL,
  `received_amount` decimal(10,2) NOT NULL,
  `accountyear` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `total_litres`
--

CREATE TABLE `total_litres` (
  `id` int(11) NOT NULL,
  `invoice` varchar(55) NOT NULL,
  `dieseldate` date NOT NULL,
  `vehicleid` int(11) NOT NULL,
  `vehicleno` varchar(33) NOT NULL,
  `driverid` varchar(33) NOT NULL,
  `drivername` varchar(55) NOT NULL,
  `intakekm` decimal(10,0) NOT NULL,
  `intakehrs` decimal(19,2) NOT NULL,
  `litres` decimal(19,2) NOT NULL,
  `filling_type` varchar(55) NOT NULL,
  `accountyear` varchar(55) NOT NULL,
  `createdate` date NOT NULL,
  `createdby` varchar(55) NOT NULL,
  `userID` int(11) NOT NULL,
  `isdelete` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `total_litres`
--

INSERT INTO `total_litres` (`id`, `invoice`, `dieseldate`, `vehicleid`, `vehicleno`, `driverid`, `drivername`, `intakekm`, `intakehrs`, `litres`, `filling_type`, `accountyear`, `createdate`, `createdby`, `userID`, `isdelete`) VALUES
(1, '1', '2023-10-11', 24, 'TN88Z1864', '1', 'RAMA CHANDRAN', '150', '210.00', '50.00', 'internalfill', '2023-2024', '2023-10-11', 'admin', 1, 1),
(2, '1', '2023-10-12', 24, 'TN88Z1864', '2', 'MUTHUKUMARESAN', '220', '230.00', '50.00', 'internalunfill', '2023-2024', '2023-10-12', 'admin', 1, 1),
(3, '1', '2023-10-12', 24, 'TN88Z1864', '4', 'BASKAR', '250', '270.00', '60.00', 'externalunfill', '2023-2024', '2023-10-12', 'admin', 1, 1),
(4, '1', '2023-10-12', 24, 'TN88Z1864', '5', 'MANIKANDAN', '260', '280.00', '100.00', 'externalfill', '2023-2024', '2023-10-12', 'admin', 1, 1);

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

--
-- Table structure for table `trip_equipment_dtl`
--

CREATE TABLE `trip_equipment_dtl` (
  `id` int(11) NOT NULL,
  `trip_hdr_id` int(11) DEFAULT NULL,
  `vehicleID` int(11) NOT NULL,
  `worktypeID` int(11) DEFAULT NULL,
  `siteID` int(11) DEFAULT NULL,
  `startHr` float DEFAULT NULL,
  `endHr` float DEFAULT NULL,
  `totalHr` float DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `trip_equipment_hdr`
--

CREATE TABLE `trip_equipment_hdr` (
  `id` int(11) NOT NULL,
  `tripeinvoice` varchar(50) DEFAULT NULL,
  `tripedate` date DEFAULT NULL,
  `shifttype` varchar(20) DEFAULT NULL,
  `vehiclestatus` varchar(30) DEFAULT NULL,
  `vehicleno` int(11) DEFAULT NULL,
  `tripsheet_no` varchar(10) DEFAULT NULL,
  `drivername` int(11) DEFAULT NULL,
  `make` text,
  `model` text,
  `enginestart_hr` float DEFAULT NULL,
  `engineclosing_hr` float DEFAULT NULL,
  `enginetotal_hr` float DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `trip_transportation_dtl`
--

CREATE TABLE `trip_transportation_dtl` (
  `id` int(11) NOT NULL,
  `trip_hdr_id` int(11) DEFAULT NULL,
  `materialID` int(11) DEFAULT NULL,
  `sitefromID` int(11) DEFAULT NULL,
  `sitetoID` int(11) DEFAULT NULL,
  `loadcount` varchar(10) DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `trip_transportation_hdr`
--

CREATE TABLE `trip_transportation_hdr` (
  `id` int(11) NOT NULL,
  `triptinvoice` varchar(50) DEFAULT NULL,
  `triptdate` date DEFAULT NULL,
  `shifttype` varchar(20) DEFAULT NULL,
  `vehicleno` int(11) DEFAULT NULL,
  `tripsheet_no` varchar(10) DEFAULT NULL,
  `drivername` int(11) DEFAULT NULL,
  `opening_km` int(11) DEFAULT NULL,
  `closing_km` int(11) DEFAULT NULL,
  `total_km` int(11) DEFAULT NULL,
  `opening_hr` varchar(40) DEFAULT NULL,
  `closing_hr` varchar(40) DEFAULT NULL,
  `totalrunning_hr` varchar(40) DEFAULT NULL,
  `enginestart_hr` float DEFAULT NULL,
  `engineclosing_hr` float DEFAULT NULL,
  `enginetotal_hr` float DEFAULT NULL,
  `accountyear` varchar(15) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `user_login`
--

CREATE TABLE `user_login` (
  `id` int(11) NOT NULL,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `loginstatus` tinyint(4) NOT NULL COMMENT '1-activestatus, 2-inactivestatus, 0-deletestatus',
  `flag` tinyint(4) NOT NULL COMMENT '1-active,0-delete',
  `user_permisson` varchar(200) NOT NULL,
  `session_code` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_login`
--

INSERT INTO `user_login` (`id`, `username`, `password`, `loginstatus`, `flag`, `user_permisson`, `session_code`) VALUES
(1, 'admin', 'admin', 1, 1, 'ADMIN@thinkofmind.com', 36639);

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

--
-- Table structure for table `user_permission`
--

CREATE TABLE `user_permission` (
  `id` int(11) NOT NULL,
  `userID` int(11) NOT NULL,
  `filenames` text NOT NULL,
  `dataadd` tinyint(4) NOT NULL,
  `dataedit` tinyint(4) NOT NULL,
  `datadelete` tinyint(4) NOT NULL,
  `datashow` tinyint(4) NOT NULL,
  `dataprint` tinyint(4) NOT NULL,
  `dataexcelformat` tinyint(4) NOT NULL,
  `activestatus` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_permission`
--

INSERT INTO `user_permission` (`id`, `userID`, `filenames`, `dataadd`, `dataedit`, `datadelete`, `datashow`, `dataprint`, `dataexcelformat`, `activestatus`) VALUES
(1, 1, 'SupplierMaster', 1, 1, 1, 1, 1, 1, 1),
(2, 1, 'BrandMaster', 1, 1, 1, 1, 1, 1, 1),
(3, 1, 'vehiclereg', 1, 1, 1, 1, 1, 1, 1),
(4, 1, 'explosiveMaster', 1, 1, 1, 1, 1, 1, 1),
(5, 1, 'spareMaster', 1, 1, 1, 1, 1, 1, 1),
(6, 1, 'employeeMaster', 1, 1, 1, 1, 1, 1, 1),
(7, 1, 'vehicleMaster', 1, 1, 1, 1, 1, 1, 1),
(8, 1, 'expenseMaster', 1, 1, 1, 1, 1, 1, 1),
(9, 1, 'SpareInvoice', 1, 1, 1, 1, 1, 1, 1),
(10, 1, 'DieselPurchase', 1, 1, 1, 1, 1, 1, 1),
(11, 1, 'ExplosivePurchase', 1, 1, 1, 1, 1, 1, 1),
(12, 1, 'InternalDiesel', 1, 1, 1, 1, 1, 1, 1),
(13, 1, 'ExternalDiesel', 1, 1, 1, 1, 1, 1, 1),
(14, 1, 'Employee_Advance', 1, 1, 1, 1, 1, 1, 1),
(15, 1, 'Employee_Attendance', 1, 1, 1, 1, 1, 1, 1),
(16, 1, 'SpareOut', 1, 1, 1, 1, 1, 1, 1),
(17, 1, 'SupplierPayment', 1, 1, 1, 1, 1, 1, 1),
(18, 1, 'reports', 1, 1, 1, 1, 1, 1, 1),
(19, 1, 'expense', 1, 1, 1, 1, 1, 1, 1),
(20, 1, 'ExplosiveOut', 1, 1, 1, 1, 1, 1, 1),
(21, 1, 'productMaster', 1, 1, 1, 1, 1, 1, 1),
(22, 1, 'Purchase', 1, 1, 1, 1, 1, 1, 1),
(23, 1, 'Explosive_utilize', 1, 1, 1, 1, 1, 1, 1);

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

--
-- Table structure for table `user_permission_master`
--

CREATE TABLE `user_permission_master` (
  `id` int(11) NOT NULL,
  `filenames` text NOT NULL,
  `dataadd` tinyint(4) NOT NULL,
  `dataedit` tinyint(4) NOT NULL,
  `datadelete` tinyint(4) NOT NULL,
  `datashow` tinyint(4) NOT NULL,
  `dataprint` tinyint(4) NOT NULL,
  `dataexcelformat` tinyint(4) NOT NULL,
  `activestatus` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_permission_master`
--

INSERT INTO `user_permission_master` (`id`, `filenames`, `dataadd`, `dataedit`, `datadelete`, `datashow`, `dataprint`, `dataexcelformat`, `activestatus`) VALUES
(1, 'SupplierMaster', 0, 0, 0, 0, 0, 0, 1),
(2, 'BrandMaster', 0, 0, 0, 0, 0, 0, 1),
(3, 'vehiclereg', 0, 0, 0, 0, 0, 0, 1),
(4, 'explosiveMaster', 0, 0, 0, 0, 0, 0, 1),
(5, 'spareMaster', 0, 0, 0, 0, 0, 0, 1),
(6, 'employeeMaster', 0, 0, 0, 0, 0, 0, 1),
(7, 'vehicleMaster', 0, 0, 0, 0, 0, 0, 1),
(8, 'expenseMaster', 0, 0, 0, 0, 0, 0, 1),
(9, 'SpareInvoice', 0, 0, 0, 0, 0, 0, 1),
(10, 'DieselPurchase', 0, 0, 0, 0, 0, 0, 1),
(11, 'ExplosivePurchase', 0, 0, 0, 0, 0, 0, 1),
(12, 'InternalDiesel', 0, 0, 0, 0, 0, 0, 1),
(13, 'ExternalDiesel', 0, 0, 0, 0, 0, 0, 1),
(14, 'Employee_Advance', 0, 0, 0, 0, 0, 0, 1),
(15, 'Employee_Attendance', 0, 0, 0, 0, 0, 0, 1),
(16, 'SpareOut', 0, 0, 0, 0, 0, 0, 1),
(17, 'SupplierPayment', 0, 0, 0, 0, 0, 0, 1),
(18, 'reports', 0, 0, 0, 0, 0, 0, 1),
(19, 'expense', 0, 0, 0, 0, 0, 0, 1),
(20, 'ExplosiveOut', 0, 0, 0, 0, 0, 0, 1),
(21, 'productMaster', 0, 0, 0, 0, 0, 0, 1),
(22, 'Purchase', 0, 0, 0, 0, 0, 0, 1),
(23, 'Explosive_utilize', 0, 0, 0, 0, 0, 0, 1);

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

--
-- Table structure for table `vehiclereg`
--

CREATE TABLE `vehiclereg` (
  `id` int(11) NOT NULL,
  `regcode` varchar(25) DEFAULT NULL,
  `regname` text,
  `reg_address` varchar(512) NOT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `vehiclereg`
--

INSERT INTO `vehiclereg` (`id`, `regcode`, `regname`, `reg_address`, `createdate`, `createdby`, `userID`, `isdelete`) VALUES
(1, 'REG-1', 'NSK Constructions', 'No:158, Kurinji Nagar, Vellisemandalam, Cuddalore-607001', '2020-01-26', 'admin', 1, 1),
(2, 'REG-2', 'NSK Bluemetals', 'S.F.No: 8/2, 8/6B, Keezhbhoothaeri Road, Nalmukkal Village, Marakkanam Post, Tindivanam Taluk, Villupuram District-604301', '2020-01-26', 'admin', 1, 1),
(3, 'REG-3', 'NSK Minerrals', 'S.F.No: 4/4B, 21/1A, Keezhsiviri Road, Nalmukkal Village, Marakkanam Post, Tindivanam Taluk, Villupuram District-604301', '2020-01-29', 'admin', 1, 1),
(4, 'REG-4', 'N.Rajammal', 'No:3, State Bank Colony, Vellisemandalam, Cuddalore-607001', '2020-01-29', 'admin', 1, 1),
(5, 'REG-5', 'N.Venkatesh', 'No:158, Kurinji Nagar, Vellisemandalam, Cuddalore-607001', '2020-01-29', 'admin', 1, 1),
(6, 'REG-6', 'V.Kousalya', 'No:158, Kurinji Nagar, Vellisemandalam, Cuddalore-607001', '2020-01-29', 'admin', 1, 1),
(7, 'REG-7', 'Jegatheesh', 'PN P', '2023-10-11', 'admin', 1, 1),
(8, 'REG-8', 'Bala K', 'Salem', '2023-10-11', 'admin', 1, 1);

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

--
-- Table structure for table `vehicle_master`
--

CREATE TABLE `vehicle_master` (
  `id` int(11) NOT NULL,
  `vehicleno` varchar(250) DEFAULT NULL,
  `brandtype` varchar(100) DEFAULT NULL,
  `brandname` int(11) DEFAULT NULL,
  `model` varchar(250) DEFAULT NULL,
  `purchasedate` date DEFAULT NULL,
  `openingkm` bigint(20) DEFAULT NULL,
  `openinghrs` varchar(100) NOT NULL,
  `vehicletype` varchar(80) DEFAULT NULL,
  `vownership` varchar(80) DEFAULT NULL,
  `regname` varchar(100) NOT NULL,
  `reg_address` varchar(512) NOT NULL,
  `companymileage` varchar(25) NOT NULL,
  `fastag` varchar(200) NOT NULL,
  `ins_policynumber` varchar(250) DEFAULT NULL,
  `ins_policyfrom` date DEFAULT NULL,
  `ins_policyto` date DEFAULT NULL,
  `ins_policyremindon` varchar(50) DEFAULT NULL,
  `insurancecompany` varchar(100) NOT NULL,
  `fcnumber` varchar(250) DEFAULT NULL,
  `fcfrom` date DEFAULT NULL,
  `fcto` date DEFAULT NULL,
  `fcremindon` varchar(250) DEFAULT NULL,
  `permitnumber` varchar(250) DEFAULT NULL,
  `permitfrom` date DEFAULT NULL,
  `permitto` date DEFAULT NULL,
  `permitremindon` varchar(250) DEFAULT NULL,
  `pypermitnumber` varchar(200) NOT NULL,
  `pypermitfrom` varchar(20) NOT NULL,
  `pypermitto` varchar(20) NOT NULL,
  `pypermitremindon` date NOT NULL,
  `taxnumber` varchar(250) DEFAULT NULL,
  `taxfrom` varchar(20) DEFAULT NULL,
  `taxto` varchar(20) DEFAULT NULL,
  `taxremindon` varchar(250) DEFAULT NULL,
  `pytaxnumber` varchar(200) NOT NULL,
  `pytaxfrom` date NOT NULL,
  `pytaxto` date NOT NULL,
  `pytaxremindon` date NOT NULL,
  `loannumber` varchar(250) DEFAULT NULL,
  `loanfrom` varchar(20) DEFAULT NULL,
  `loanto` varchar(20) DEFAULT NULL,
  `loanremindon` varchar(250) DEFAULT NULL,
  `loan_financier` text,
  `loan_amt` decimal(10,2) DEFAULT NULL,
  `loan_interest` decimal(10,2) DEFAULT NULL,
  `loan_tenure` varchar(250) DEFAULT NULL,
  `loan_emiamt` decimal(10,2) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `vehicle_master`
--

INSERT INTO `vehicle_master` (`id`, `vehicleno`, `brandtype`, `brandname`, `model`, `purchasedate`, `openingkm`, `openinghrs`, `vehicletype`, `vownership`, `regname`, `reg_address`, `companymileage`, `fastag`, `ins_policynumber`, `ins_policyfrom`, `ins_policyto`, `ins_policyremindon`, `insurancecompany`, `fcnumber`, `fcfrom`, `fcto`, `fcremindon`, `permitnumber`, `permitfrom`, `permitto`, `permitremindon`, `pypermitnumber`, `pypermitfrom`, `pypermitto`, `pypermitremindon`, `taxnumber`, `taxfrom`, `taxto`, `taxremindon`, `pytaxnumber`, `pytaxfrom`, `pytaxto`, `pytaxremindon`, `loannumber`, `loanfrom`, `loanto`, `loanremindon`, `loan_financier`, `loan_amt`, `loan_interest`, `loan_tenure`, `loan_emiamt`, `createdate`, `createdby`, `userID`, `isdelete`) VALUES
(1, 'TN31BE4554', 'transport', 1, 'Bharat Benz - 2523C 6x4', '2017-04-07', 292088, '8448', 'new', 'owned', 'N.Rajammal', 'No:3, State Bank Colony, Vellisemandalam, Cuddalore-607001', '3.50 to 3.80', 'C0038410/34161FA820328D9A021D51C0/607949-001-0060046', '506040311810000805', '2019-03-30', '2020-03-29', '2020-03-20', 'National Insurance Company Ltd', 'TN190415V0631473', '2019-04-15', '2020-04-14', '2020-03-10', '191(207)/TN31/GV/2017', '2017-04-07', '2022-04-06', '2022-03-10', '212/PY/GV/2018', '2018-04-12', '2022-04-06', '2022-03-10', 'TN190408V9523380', '2019-04-01', '2020-03-31', '2020-03-15', '7046/01-382464', '2019-04-01', '2020-03-31', '2020-03-15', '83701373', '2019-04-05', '2022-02-05', '2022-01-05', 'HDFC Bank Ltd', '1700000.00', '0.00', '36', '57815.00', '2020-01-07', 'admin', 1, 1),
(2, 'TN31CA8388', 'transport', 2, 'U-3123 T', '2019-04-16', 84819, '2787.40', 'new', 'owned', 'NSK Constructions', 'No:158, Kurinji Nagar, Vellisemandalam, Cuddalore-607001', '3.00 to 3.30', 'C0042140/6079490010060086', '0902003119P100568523', '2019-04-08', '2020-04-07', '2020-03-20', 'United India Insurance Company Ltd', 'New', '2019-04-16', '2021-04-15', '2021-03-15', 'TN/31/GP/PC/2019/288', '2019-04-16', '2024-04-15', '2024-03-15', '417/PY/GV/2019', '2019-05-03', '2024-04-15', '2024-03-25', 'New', '2019-07-01', '2020-03-31', '2020-03-15', '5410/01-393437', '2019-05-03', '2020-03-31', '2020-03-15', 'CVL054200500195', '2019-05-02', '2023-03-02', '2023-02-02', 'Yes Bank Ltd', '4087500.00', '9.85', '47', '104515.00', '2020-01-07', 'admin', 1, 1),
(3, 'TN31CA2277', 'transport', 2, 'U-2518 T/1', '2018-11-28', 130447, '3749.30', 'new', 'owned', 'NSK Constructions', 'No:158, Kurinji Nagar, Vellisemandalam, Cuddalore-607001', '3.40 to 3.70', 'C0042140/34161FA820328D9A021A4F00/607949-001-0053880', 'oi', '2019-11-22', '2020-11-20', '2020-11-10', 'The Oriental Insurance Company Ltd', 'New', '2018-11-28', '2020-11-27', '2020-11-01', 'TN/31/GP/PC/2018/376', '2018-11-28', '2023-11-27', '2023-11-01', '843/PY/GV/2018', '2018-12-10', '2023-11-27', '2023-11-01', 'TN190409V6613823', '2019-04-01', '2020-03-31', '2020-03-15', '2731/01-391906', '2019-04-01', '2020-03-31', '2020-03-15', '83484312', '2019-01-15', '2021-11-15', '2021-10-15', 'HDFC Bank Ltd', '3200000.00', '0.00', '36', '104670.00', '2020-01-07', 'admin', 1, 1),
(4, 'TN16E8199', 'transport', 2, 'U-3123 T', '2019-06-27', 46763, '1527.00', 'new', 'owned', 'NSK Minerrals', 'S.F.No: 4/4B, 21/1A, Keezhsiviri Road, Nalmukkal Village, Marakkanam Post, Tindivanam Taluk, Villupuram District-604301', '3.00 to 3.30', 'C0042046/34161FA820328D9A021D5660/607949-001-0060083', 'VGC0561362000100', '2019-06-27', '2020-06-26', '2020-06-15', 'TVS Insurance Broking Ltd', 'New', '2019-06-27', '2021-06-26', '2021-06-01', 'TN/571/GP/PC/2019/459', '2019-06-28', '2024-06-27', '2024-06-01', 'Temprory', '2020-01-07', '2020-01-07', '2020-01-07', 'New', '2019-04-01', '2020-03-31', '2020-03-20', 'New', '2019-06-01', '2020-03-31', '2020-03-20', 'P042200318', '2019-08-17', '2023-06-17', '2023-05-17', 'Sundaram Finance Ltd', '3800000.00', '0.00', '47', '98310.00', '2020-01-07', 'admin', 1, 1),
(5, 'TN31CA8595', 'transport', 2, 'U-3123 T', '2019-04-16', 69379, '2492.20', 'new', 'owned', 'NSK Constructions', 'No:158, Kurinji Nagar, Vellisemandalam, Cuddalore-607001', '3.00 to 3.30', 'C0042140/6079490010060085', 'oi', '2019-04-16', '2020-04-15', '2020-04-01', 'United India Insurance Company Ltd', 'New', '2019-04-16', '2021-04-15', '2021-03-25', 'TN/31/GP/PC/2019/289', '2019-04-16', '2024-04-15', '2024-03-15', '419/PY/GV/2019', '2019-05-03', '2024-04-15', '2024-03-15', 'TN190724V9256716', '2019-07-01', '2020-03-31', '2020-03-15', '5417/01-393438', '2019-05-03', '2020-03-31', '2020-03-15', 'LK16514932253', '2019-05-10', '2023-03-10', '2022-02-10', 'Citi Corp Finance Ltd', '3460000.00', '9.01', '47', '87642.00', '2020-01-07', 'admin', 1, 1),
(6, 'TN31CA5355', 'transport', 2, 'U-3123 T', '2019-02-15', 85398, '2903.70', 'new', 'owned', 'NSK Constructions', 'No:158, Kurinji Nagar, Vellisemandalam, Cuddalore-607001', '3.00 to 3.30', 'C0042140/34161FA820328D9A021D5700/6007949-001-0060088', 'USGIA/2020014238', '2020-02-05', '2021-02-04', '2021-01-25', 'Universal Sompo General Insurance Co. Ltd', 'New', '2019-02-15', '2021-02-14', '2021-02-01', 'TN/31/GP/PC/2019/99', '2019-02-15', '2024-02-14', '2024-01-15', '201/PY/GV/2019', '2020-01-07', '2024-02-14', '2024-01-15', 'TN190409V8614970', '2019-04-01', '2020-03-31', '2020-03-15', '3958/01-391904', '2019-04-01', '2020-03-31', '2020-03-15', 'N024201146', '2019-03-17', '2023-01-17', '2022-12-17', 'Sundaram Finance Ltd', '3600000.00', '0.00', '47', '93122.50', '2020-01-07', 'admin', 1, 1),
(7, 'TN31BA7677', 'transport', 1, 'Bharart Benz - 2523C 6x4', '2014-04-02', 621934, '17526', 'new', 'owned', 'N.Venkatesh', 'No:158, Kurinji Nagar, Vellisemandalam, Cuddalore-607001', '3.40 - 3.70', 'C0041681/34161FA820328D9A021A5260/607949-001-0053907', '506040311810000806', '2019-03-30', '2020-03-29', '2020-03-15', 'National Insurance Company Ltd', 'TN190408V9487516', '2019-04-08', '2020-04-07', '2020-03-10', 'TN/31/GP/PC/2019/273', '2019-04-10', '2024-04-09', '2024-03-10', '336/PY/GV/2019', '2019-04-22', '2024-04-09', '2024-03-10', 'TN190408V3481913', '2019-04-01', '2020-03-31', '2020-03-15', '3601/01-392102', '2019-04-01', '2020-03-31', '2020-03-15', 'P024200773', '2020-01-10', '2021-03-10', '2021-02-10', 'Sundaram Finance Ltd', '1000000.00', '0.00', '15', '73565.00', '2020-01-07', 'admin', 1, 1),
(8, 'TN31BC8199', 'transport', 2, '2518 T IL Tipper', '2016-02-18', 376601, '11360', 'new', 'owned', 'N.Rajammal', 'No:3, State Bank Colony, Vellisemandalam, Cuddalore-607001', '3.40 -3.70', 'C0038410/34161FA820328D9A021A4E20/607949-001-0053873', '413901/31/2020/2076', '2020-02-16', '2021-02-15', '2021-02-01', 'The Oriental Insurance Company Limited', 'TN190313V2762659', '2019-03-13', '2020-03-12', '2020-02-15', '62(88)/TN31/GV/2016', '2016-02-19', '2021-02-18', '2021-01-15', '268/PY/GV/2016', '2016-04-01', '2021-02-18', '2021-01-15', 'TN190408V4521948', '2019-04-01', '2020-03-31', '2020-03-15', '7293/01-391910', '2019-04-01', '2020-03-31', '2020-03-15', 'P024200775', '2020-01-10', '2021-03-10', '2021-02-10', 'Sundaram Finance Ltd', '1600000.00', '0.00', '15', '117710.00', '2020-01-07', 'admin', 1, 1),
(9, 'TN16E8388', 'transport', 2, 'U-3123 T', '2019-06-27', 44516, '1471.20', 'new', 'owned', 'NSK Minerrals', 'S.F.No: 4/4B, 21/1A, Keezhsiviri Road, Nalmukkal Village, Marakkanam Post, Tindivanam Taluk, Villupuram District-604301', '3.00 to 3.30', 'C0042046/34161FA820328D9A021D5680/607949-001-0060084', 'VGC0561364000100', '2019-06-27', '2020-06-26', '2020-06-10', 'TVS Insurance Broking Ltd', 'New', '2019-06-27', '2020-06-26', '2020-05-20', 'TN/571/GP/PC/2019/458', '2019-06-28', '2024-06-27', '2024-05-25', '664/PY/GV/2019', '2019-07-15', '2024-06-27', '2024-05-25', 'New', '2020-04-01', '2020-03-31', '2020-03-15', '7834/01-393010', '2019-07-13', '2020-03-31', '2020-03-15', 'P024200318', '2019-08-17', '2023-07-17', '2023-06-17', 'Sundaram Finance Ltd', '3800000.00', '0.00', '47', '98310.00', '2020-01-07', 'admin', 1, 1),
(10, 'TN31CA6264', 'transport', 2, 'U-3123 T', '2019-02-15', 87091, '2828.50', 'new', 'owned', 'NSK Constructions', 'No:158, Kurinji Nagar, Vellisemandalam, Cuddalore-607001', '3.00 to 3.30', 'C0042140/6079490010060087', 'USGIA/2020014239', '2020-02-05', '2021-02-04', '2021-01-25', 'Universal Sompo General Insurance Co. Ltd', 'New', '2019-02-15', '2021-02-14', '2021-01-25', 'TN/31/GP/PC/2019/98', '2019-02-15', '2024-02-14', '2024-01-10', '202/PY/GV/2019', '2019-02-15', '2024-02-14', '2024-01-10', 'TN190409V9635075', '2019-04-01', '2020-03-31', '2020-03-15', '3967/01-391905', '2019-04-01', '2020-03-31', '2020-03-15', 'N024201146', '2019-03-17', '2023-01-17', '2022-12-17', 'Sundaram Finance Ltd', '3600000.00', '0.00', '47', '93122.50', '2020-01-08', 'admin', 1, 1),
(11, 'TN31CA1881', 'transport', 2, 'U-2518 T/1', '2018-11-28', 125778, '3462.30', 'new', 'owned', 'NSK Constructions', 'No:158, Kurinji Nagar, Vellisemandalam, Cuddalore-607001', '3.40 to 3.70', 'C0042140/34161FA820328D9A021A4F20/607949-001-0053881', '413901/31/2020/1569', '2019-11-14', '2020-11-12', '2020-11-01', 'The Oriental Insurance Company Ltd', 'New', '2018-11-28', '2020-11-27', '2020-11-01', 'TN/31/GP/PC/2018/376', '2019-11-28', '2023-11-27', '2023-11-01', '843/PY/GV/2018', '2018-12-10', '2023-11-27', '2023-11-01', 'TN190409V6613823', '2019-04-01', '2020-03-31', '2020-03-15', '2732/01-391907', '2019-04-01', '2020-03-31', '2020-03-15', '83484312', '2019-01-15', '2021-11-15', '2021-10-15', 'HDFC Bank Ltd', '3200000.00', '0.00', '36', '104670.00', '2020-01-08', 'admin', 1, 1),
(12, 'TN31BH3141', 'transport', 2, 'U-2523 T', '2018-06-01', 284251, '', 'new', 'owned', 'NSK Constructions', 'No:158, Kurinji Nagar, Vellisemandalam, Cuddalore-607001', '3.40 to 3.70', 'C0042140/34161FA820328D9A021A4F40/607949-001-0053882', '501504311810001077', '2019-05-31', '2020-05-30', '2020-05-20', 'National Insurance Company Ltd', 'New', '2018-06-01', '2020-05-31', '2020-05-10', '388(469)/TN31/GV/2018', '2018-06-01', '2022-05-31', '2023-05-01', '512/PY/GV/2018', '2018-07-13', '2023-05-31', '2023-05-01', 'TN31D19040002953', '2019-04-01', '2020-03-31', '2020-03-15', '837/01-391908', '2019-04-01', '2020-03-31', '2020-03-15', 'N024200193', '2018-07-03', '2020-05-03', '2020-02-05', 'Sundaram Finance Ltd', '3200000.00', '0.00', '22', '152570.00', '2020-01-08', 'admin', 1, 1),
(13, 'TN31BE4446', 'transport', 1, 'Bharat Benz - 2523C 6x4', '2017-04-07', 293329, '8138', 'new', 'owned', 'N.Venkatesh', 'No:158, Kurinji Nagar, Vellisemandalam, Cuddalore-607001', '3.50 to 3.80', 'C0041681/34161FA820328D9A021A5280/607949-001-0053907', '506040311810000804', '2019-03-30', '2020-03-29', '2020-03-20', 'National Insurance Company Ltd', 'TN190415V7992183', '2019-04-15', '2020-04-14', '2020-03-25', '190(206)/TN31/GV/2017', '2017-04-07', '2022-04-06', '2022-03-10', '211/PY/GV/2018', '2018-04-12', '2022-04-06', '2022-03-10', 'TN190408V6522742', '2019-04-01', '2020-03-31', '2020-03-15', '7045/01-391903', '2019-04-01', '2020-03-31', '2020-03-15', '83689971', '2019-04-05', '2022-02-05', '2022-01-05', 'HDFC Bank Ltd', '1700000.00', '0.00', '36', '57815.00', '2020-01-08', 'admin', 1, 1),
(14, 'TN16E8587', 'transport', 2, 'U-3123 T', '2019-07-08', 46901, '1518.50', 'new', 'owned', 'NSK Bluemetals', 'S.F.No: 8/2, 8/6B, Keezhbhoothaeri Road, Nalmukkal Village, Marakkanam Post, Tindivanam Taluk, Villupuram District-604301', '3.00 to 3.30', 'C0042045/34161FA820328D9A021D5620/607949-001-0060081', 'VGC0562679000100', '2019-07-03', '2020-07-02', '2020-06-20', 'Royal Sundaram General Insurance Co Limited', 'New', '2019-07-08', '2021-07-07', '2021-06-15', 'TN/571/GP/PC/2019/485', '2019-07-09', '2024-07-08', '2024-06-10', 'Temprory', '2020-01-08', '2020-01-08', '2020-01-08', 'New', '2019-07-01', '2020-03-31', '2020-03-15', 'Temprory', '2020-01-08', '2020-01-08', '2020-01-08', 'CVL054200541598', '2019-08-22', '2023-06-22', '2023-05-31', 'Yes Bank Ltd', '3790000.00', '9.81', '47', '97540.00', '2020-01-08', 'admin', 1, 1),
(15, 'TN16E8686', 'transport', 2, 'U-3123 T', '2019-07-08', 49811, '1539.60', 'new', 'owned', 'NSK Bluemetals', 'S.F.No: 8/2, 8/6B, Keezhbhoothaeri Road, Nalmukkal Village, Marakkanam Post, Tindivanam Taluk, Villupuram District-604301', '3.00 to 3.30', 'C0042045/34161FA820328D9A021D5640/607949-001-0060082', 'VGC056268000100', '2019-07-03', '2020-07-02', '2020-06-20', 'Royal Sundaram General Insurance Co Limited', 'New', '2019-07-08', '2021-07-07', '2021-06-15', 'TN/571/GP/PC/2019/483', '2019-07-09', '2024-07-08', '2024-06-10', 'Temprory', '2020-01-08', '2020-01-08', '2020-01-08', 'New', '2019-07-01', '2020-03-31', '2020-03-15', 'Temprory', '2020-01-08', '2020-01-08', '2020-01-08', 'CVL054200541617', '2019-08-22', '2023-06-22', '2023-05-25', 'Yes Bank Ltd', '3790000.00', '9.81', '47', '97540.00', '2020-01-08', 'admin', 1, 1),
(16, 'TN16E8485', 'transport', 2, 'U-3123 T', '2019-07-08', 52110, '1601.00', 'new', 'owned', 'NSK Bluemetals', 'S.F.No: 8/2, 8/6B, Keezhbhoothaeri Road, Nalmukkal Village, Marakkanam Post, Tindivanam Taluk, Villupuram District-604301', '3.00 to 3.30', 'C0042045/34161FA820328D9A021D5600/607949-001-0060080', 'VGC0562677000100', '2019-07-03', '2020-07-02', '2020-06-20', 'Royal Sundaram General Insurance Co. Limited', 'New', '2019-07-08', '2021-07-07', '2021-06-15', 'TN/571/GP/PC/2019/484', '2019-07-09', '2024-07-08', '2024-06-10', 'Temprory', '2020-01-08', '2020-01-08', '2020-01-08', 'New', '2019-07-01', '2020-03-31', '2020-03-15', 'Temprory', '2020-01-08', '2020-01-08', '2020-01-08', 'CVL054200541616', '2019-08-22', '2023-06-22', '2023-05-25', 'Yes Bank Ltd', '3790000.00', '9.81', '47', '97540.00', '2020-01-08', 'admin', 1, 1),
(17, 'TN31BD8199', 'transport', 2, '2518 T IL Tipper', '2016-09-30', 333011, '9615', 'new', 'owned', 'N.Venkatesh', 'No:158, Kurinji Nagar, Vellisemandalam, Cuddalore-607001', '3.50 to 3.80', 'C0041681/34161FA820328D9A021A5240/607949-001-0053906', '413901/312020/1296', '2019-09-26', '2020-09-25', '2020-09-10', 'Tne Oriental Insurance Company Limited', 'TN190917C8523667', '2020-09-18', '2020-09-17', '2020-08-15', '375(566)/TN31/GV/2016', '2016-09-30', '2021-09-28', '2021-09-01', '1159/PY/GV/2016', '2016-12-12', '2021-09-28', '2021-09-01', 'TN190408V9522331', '2019-04-01', '2020-03-31', '2020-03-15', '5946/01-391909', '2019-04-01', '2020-03-31', '2020-03-15', 'P024200774', '2020-01-10', '2021-03-10', '2021-02-10', 'Sundaram Finance Ltd', '1600000.00', '0.00', '15', '165665.00', '2020-01-08', 'admin', 1, 1),
(18, 'TN37BS3367', 'transport', 2, 'ALCT 1616 XL', '2011-09-12', 672673, '', 'used', 'owned', 'N.Venkatesh', 'No:158, Kurinji Nagar, Vellisemandalam, Cuddalore-607001', '', 'C0041681/6079490010059489', '413901/312020/1576', '2019-11-12', '2020-11-11', '2020-11-01', 'The Oriental Insurance Company Ltd', 'TN190826V9974739', '2019-08-26', '2020-08-25', '2020-08-01', 'TN/31/GP/PC/2019/142', '2019-03-01', '2024-02-29', '2024-02-01', '239/PY/GV/2019', '2019-03-14', '2024-02-29', '2024-02-01', 'TN190409V4612425', '2019-04-01', '2020-03-31', '2020-03-15', '6943/01-391912', '2019-04-01', '2020-03-31', '2020-03-15', 'P024200770', '2020-01-17', '2021-03-17', '2021-02-17', 'Sundaram Finance Ltd', '750000.00', '0.00', '15', '55315.00', '2020-01-08', 'admin', 1, 1),
(19, 'TN16E6678', 'transport', 1, 'Bharat Benz - 2523C 6x4', '2019-09-24', 54654, '100', 'new', 'owned', 'NSK Bluemetals', 'S.F.No: 8/2, 8/6B, Keezhbhoothaeri Road, Nalmukkal Village, Marakkanam Post, Tindivanam Taluk, Villupuram District-604301', '3.40 to 3.70', 'C0042045-34161FA820328D9A021A4B80-6079490010053852', '506040311910000091', '2019-04-24', '2020-04-23', '2020-04-15', 'National Insurance Company Ltd', 'New', '2019-04-29', '2021-04-28', '2021-04-01', 'TN/571/GP/PC/2019/296', '2019-04-29', '2024-04-28', '2024-04-01', 'NA', '2020-01-08', '2020-01-08', '2020-01-08', 'New', '2019-07-01', '2020-03-31', '2020-03-15', 'NA', '2020-01-08', '2020-01-08', '2020-01-08', 'P02420062', '2019-06-03', '2023-04-03', '2023-03-03', 'Sundaram Finance Ltd', '3400000.00', '0.00', '47', '87400.00', '2020-01-08', 'admin', 1, 1),
(20, 'TN818299', 'transport', 2, '1616 IL/1', '2014-07-11', 656777, '', 'used', 'owned', 'V.Kousalya', 'No:158, Kurinji Nagar, Vellisemandalam, Cuddalore-607001', '', 'C0038460/6079490010054378', '506040311910000341', '2019-07-14', '2020-07-13', '2020-07-01', 'National Insurance Company Ltd', 'TN190715V8616431', '2019-07-15', '2020-07-14', '2020-06-15', '41/TN31/GV/2016', '2016-01-22', '2021-01-21', '2020-12-20', '271/PY/GV/2016', '2016-04-01', '2021-01-21', '2020-12-21', 'TN190409V6616070', '2019-04-01', '2020-03-31', '2020-03-15', '7281/01-391911', '2019-04-01', '2020-03-31', '2020-03-15', 'P024200778', '2020-01-03', '2023-03-03', '2023-02-03', 'Sundaram Finance Limited', '850000.00', '0.00', '15', '62370.00', '2020-01-08', 'admin', 1, 1),
(22, 'JCB 2020', 'equipment', 3, '2015', '2020-01-07', 5, '10', 'new', 'owned', 'N.Venkatesh', 'No:158, Kurinji Nagar, Vellisemandalam, Cuddalore-607001', '', 'C0038410/6079490010053881-CA1881', '123', '2020-01-22', '2021-01-21', '2021-01-20', 'feenix', '234', '2020-01-22', '2021-01-21', '2021-01-20', '345', '2020-01-22', '2021-01-21', '2021-01-20', '34', '2020-01-22', '2021-01-21', '2021-01-20', '45', '2020-01-22', '2021-01-21', '2021-01-20', '56', '2020-01-22', '2021-01-21', '2021-01-20', '2345', '2020-01-22', '2021-01-21', '2021-01-20', 'sbi', '1000000.00', '2.00', '30', '60000.00', '2020-01-30', 'admin', 1, 1),
(23, 'TN31CC2223', 'transport', 2, 'U-3123 T', '2020-02-15', 582, '21.60', 'new', 'owned', 'NSK Constructions', 'No:158, Kurinji Nagar, Vellisemandalam, Cuddalore-607001', '3.00 to 3.30', 'C0042140-2223', 'VGC0609581000100', '2020-02-15', '2021-02-14', '2021-02-01', 'Royal Sundaram General Insurance Company', 'New', '2020-02-21', '2022-02-20', '2022-01-11', 'TN2020-GP-7852A', '2020-02-21', '2025-02-20', '2025-01-11', 'New', '2020-02-21', '2025-02-20', '2025-01-11', 'New', '2020-02-15', '2020-03-31', '2020-03-16', 'New', '2020-02-15', '2020-03-31', '2020-03-16', 'P024201002', '2020-04-03', '2023-02-03', '2023-01-03', 'Sundaram Finance Limited', '3750000.00', '9.83', '36', '123618.00', '2020-03-01', 'admin', 1, 1),
(24, 'TN88Z1864', 'transport', 2, '2023', '2023-10-11', 100, '200', 'new', 'owned', 'Jegatheesh', 'PN P', '3.5', '', '', '0000-00-00', '0000-00-00', '', '', '', '0000-00-00', '0000-00-00', '', '', '0000-00-00', '0000-00-00', '', '', '', '', '0000-00-00', '', '', '', '', '', '0000-00-00', '0000-00-00', '0000-00-00', '', '', '', '', '', '0.00', '0.00', '', '0.00', '2023-10-11', 'admin', 1, 1);

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

--
-- Table structure for table `vehicle_renewal`
--

CREATE TABLE `vehicle_renewal` (
  `id` int(11) NOT NULL,
  `invoice` int(11) DEFAULT NULL,
  `invoicedate` date DEFAULT NULL,
  `vehicleno` varchar(250) DEFAULT NULL,
  `ins_policynumber` varchar(250) DEFAULT NULL,
  `ins_policyfrom` date DEFAULT NULL,
  `ins_policyto` date DEFAULT NULL,
  `ins_policyremindon` varchar(50) DEFAULT NULL,
  `insurancecompany` varchar(100) NOT NULL,
  `fcnumber` varchar(250) DEFAULT NULL,
  `fcfrom` date DEFAULT NULL,
  `fcto` date DEFAULT NULL,
  `fcremindon` varchar(250) DEFAULT NULL,
  `permitnumber` varchar(250) DEFAULT NULL,
  `permitfrom` date DEFAULT NULL,
  `permitto` date DEFAULT NULL,
  `permitremindon` varchar(250) DEFAULT NULL,
  `pypermitnumber` varchar(200) NOT NULL,
  `pypermitfrom` varchar(20) NOT NULL,
  `pypermitto` varchar(20) NOT NULL,
  `pypermitremindon` date NOT NULL,
  `taxnumber` varchar(250) DEFAULT NULL,
  `taxfrom` date DEFAULT NULL,
  `taxto` date DEFAULT NULL,
  `taxremindon` varchar(250) DEFAULT NULL,
  `pytaxnumber` varchar(200) NOT NULL,
  `pytaxfrom` varchar(20) NOT NULL,
  `pytaxto` varchar(20) NOT NULL,
  `pytaxremindon` date NOT NULL,
  `loannumber` varchar(250) DEFAULT NULL,
  `loanfrom` varchar(20) DEFAULT NULL,
  `loanto` varchar(20) DEFAULT NULL,
  `loanremindon` varchar(250) DEFAULT NULL,
  `createdate` date DEFAULT NULL COMMENT 'logined user name save ',
  `lastupdated` date DEFAULT NULL,
  `createdby` varchar(200) DEFAULT NULL,
  `userID` int(11) DEFAULT NULL COMMENT 'logined user name id',
  `isdelete` tinyint(2) DEFAULT '1' COMMENT '0-Delete,1-Not Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `vehicle_renewal`
--

INSERT INTO `vehicle_renewal` (`id`, `invoice`, `invoicedate`, `vehicleno`, `ins_policynumber`, `ins_policyfrom`, `ins_policyto`, `ins_policyremindon`, `insurancecompany`, `fcnumber`, `fcfrom`, `fcto`, `fcremindon`, `permitnumber`, `permitfrom`, `permitto`, `permitremindon`, `pypermitnumber`, `pypermitfrom`, `pypermitto`, `pypermitremindon`, `taxnumber`, `taxfrom`, `taxto`, `taxremindon`, `pytaxnumber`, `pytaxfrom`, `pytaxto`, `pytaxremindon`, `loannumber`, `loanfrom`, `loanto`, `loanremindon`, `createdate`, `lastupdated`, `createdby`, `userID`, `isdelete`) VALUES
(1, NULL, NULL, '1', '506040311810000805', '2019-03-30', '2020-03-29', '2020-03-20', 'National Insurance Company Ltd', 'TN190415V0631473', '2019-04-15', '2020-04-14', '2020-03-10', '191(207)/TN31/GV/2017', '2017-04-07', '2022-04-06', '2022-03-10', '212/PY/GV/2018', '2018-04-12', '2022-04-06', '2022-03-10', 'TN190408V9523380', '2019-04-01', '2020-03-31', '2020-03-15', '7046/01-382464', '2019-04-01', '2020-03-31', '2020-03-15', '83701373', '2019-04-05', '2022-02-05', '2022-01-05', '2020-01-07', NULL, 'admin', 1, 1),
(2, NULL, NULL, '2', '0902003119P100568523', '2019-04-08', '2020-04-07', '2020-03-20', 'United India Insurance Company Ltd', 'New', '2019-04-16', '2021-04-15', '2021-03-15', 'TN/31/GP/PC/2019/288', '2019-04-16', '2024-04-15', '2024-03-15', '417/PY/GV/2019', '2019-05-03', '2024-04-15', '2024-03-25', 'New', '2019-07-01', '2020-03-31', '2020-03-15', '5410/01-393437', '2019-05-03', '2020-03-31', '2020-03-15', 'CVL054200500195', '2019-05-02', '2023-03-02', '2023-02-02', '2020-01-07', NULL, 'admin', 1, 1),
(3, NULL, NULL, '3', 'oi', '2019-11-22', '2020-11-20', '2020-11-10', 'The Oriental Insurance Company Ltd', 'New', '2018-11-28', '2020-11-27', '2020-11-01', 'TN/31/GP/PC/2018/376', '2018-11-28', '2023-11-27', '2023-11-01', '843/PY/GV/2018', '2018-12-10', '2023-11-27', '2023-11-01', 'TN190409V6613823', '2019-04-01', '2020-03-31', '2020-03-15', '2731/01-391906', '2019-04-01', '2020-03-31', '2020-03-15', '83484312', '2019-01-15', '2021-11-15', '2021-10-15', '2020-01-07', NULL, 'admin', 1, 1),
(4, NULL, NULL, '4', 'VGC0561362000100', '2019-06-27', '2020-06-26', '2020-06-15', 'TVS Insurance Broking Ltd', 'New', '2019-06-27', '2021-06-26', '2021-06-01', 'TN/571/GP/PC/2019/459', '2019-06-28', '2024-06-27', '2024-06-01', 'Temprory', '2020-01-07', '2020-01-07', '2020-01-07', 'New', '2019-04-01', '2020-03-31', '2020-03-20', 'New', '2019-06-01', '2020-03-31', '2020-03-20', 'P042200318', '2019-08-17', '2023-06-17', '2023-05-17', '2020-01-07', NULL, 'admin', 1, 1),
(5, NULL, NULL, '5', 'oi', '2019-04-16', '2020-04-15', '2020-04-01', 'United India Insurance Company Ltd', 'New', '2019-04-16', '2021-04-15', '2021-03-25', 'TN/31/GP/PC/2019/289', '2019-04-16', '2024-04-15', '2024-03-15', '419/PY/GV/2019', '2019-05-03', '2024-04-15', '2024-03-15', 'TN190724V9256716', '2019-07-01', '2020-03-31', '2020-03-15', '5417/01-393438', '2019-05-03', '2020-03-31', '2020-03-15', 'LK16514932253', '2019-05-10', '2023-03-10', '2022-02-10', '2020-01-07', NULL, 'admin', 1, 1),
(6, NULL, NULL, '6', 'USGIA/2020014238', '2020-02-05', '2021-02-04', '2021-01-25', 'Universal Sompo General Insurance Co. Ltd', 'New', '2019-02-15', '2021-02-14', '2021-02-01', 'TN/31/GP/PC/2019/99', '2019-02-15', '2024-02-14', '2024-01-15', '201/PY/GV/2019', '2020-01-07', '2024-02-14', '2024-01-15', 'TN190409V8614970', '2019-04-01', '2020-03-31', '2020-03-15', '3958/01-391904', '2019-04-01', '2020-03-31', '2020-03-15', 'N024201146', '2019-03-17', '2023-01-17', '2022-12-17', '2020-01-07', NULL, 'admin', 1, 1),
(7, NULL, NULL, '7', '506040311810000806', '2019-03-30', '2020-03-29', '2020-03-15', 'National Insurance Company Ltd', 'TN190408V9487516', '2019-04-08', '2020-04-07', '2020-03-10', 'TN/31/GP/PC/2019/273', '2019-04-10', '2024-04-09', '2024-03-10', '336/PY/GV/2019', '2019-04-22', '2024-04-09', '2024-03-10', 'TN190408V3481913', '2019-04-01', '2020-03-31', '2020-03-15', '3601/01-392102', '2019-04-01', '2020-03-31', '2020-03-15', 'P024200773', '2020-01-10', '2021-03-10', '2021-02-10', '2020-01-07', NULL, 'admin', 1, 1),
(8, NULL, NULL, '8', '413901/31/2020/2076', '2020-02-16', '2021-02-15', '2021-02-01', 'The Oriental Insurance Company Limited', 'TN190313V2762659', '2019-03-13', '2020-03-12', '2020-02-15', '62(88)/TN31/GV/2016', '2016-02-19', '2021-02-18', '2021-01-15', '268/PY/GV/2016', '2016-04-01', '2021-02-18', '2021-01-15', 'TN190408V4521948', '2019-04-01', '2020-03-31', '2020-03-15', '7293/01-391910', '2019-04-01', '2020-03-31', '2020-03-15', 'P024200775', '2020-01-10', '2021-03-10', '2021-02-10', '2020-01-07', NULL, 'admin', 1, 1),
(9, NULL, NULL, '9', 'VGC0561364000100', '2019-06-27', '2020-06-26', '2020-06-10', 'TVS Insurance Broking Ltd', 'New', '2019-06-27', '2020-06-26', '2020-05-20', 'TN/571/GP/PC/2019/458', '2019-06-28', '2024-06-27', '2024-05-25', '664/PY/GV/2019', '2019-07-15', '2024-06-27', '2024-05-25', 'New', '2020-04-01', '2020-03-31', '2020-03-15', '7834/01-393010', '2019-07-13', '2020-03-31', '2020-01-07', 'P024200318', '2019-08-17', '2023-07-17', '2023-06-17', '2020-01-07', NULL, 'admin', 1, 1),
(10, NULL, NULL, '10', 'USGIA/2020014239', '2020-02-05', '2021-02-04', '2021-01-25', 'Universal Sompo General Insurance Co. Ltd', 'New', '2019-02-15', '2021-02-14', '2021-01-25', 'TN/31/GP/PC/2019/98', '2019-02-15', '2024-02-14', '2024-01-10', '202/PY/GV/2019', '2019-02-15', '2024-02-14', '2024-01-10', 'TN190409V9635075', '2019-04-01', '2020-03-31', '2020-03-15', '3967/01-391905', '2019-04-01', '2020-03-31', '2020-03-15', 'N024201146', '2019-03-17', '2023-01-17', '2022-12-17', '2020-01-08', NULL, 'admin', 1, 1),
(11, NULL, NULL, '11', '413901/31/2020/1569', '2019-11-14', '2020-11-12', '2020-11-01', 'The Oriental Insurance Company Ltd', 'New', '2018-11-28', '2020-11-27', '2020-11-01', 'TN/31/GP/PC/2018/376', '2019-11-28', '2023-11-27', '2023-11-01', '843/PY/GV/2018', '2018-12-10', '2023-11-27', '2023-11-01', 'TN190409V6613823', '2019-04-01', '2020-03-31', '2020-03-15', '2732/01-391907', '2019-04-01', '2020-03-31', '2020-03-15', '83484312', '2019-01-15', '2021-11-15', '2021-10-15', '2020-01-08', NULL, 'admin', 1, 1),
(12, NULL, NULL, '12', '501504311810001077', '2019-05-31', '2020-05-30', '2020-05-20', 'National Insurance Company Ltd', 'New', '2018-06-01', '2020-05-31', '2020-05-10', '388(469)/TN31/GV/2018', '2018-06-01', '2022-05-31', '2023-05-01', '512/PY/GV/2018', '2018-07-13', '2023-05-31', '2023-05-01', 'TN31D19040002953', '2019-04-01', '2020-03-31', '2020-03-15', '837/01-391908', '2019-04-01', '2020-03-31', '2020-03-15', 'N024200193', '2018-07-03', '2020-05-03', '2020-02-05', '2020-01-08', NULL, 'admin', 1, 1),
(13, NULL, NULL, '13', '506040311810000804', '2019-03-30', '2020-03-29', '2020-03-20', 'National Insurance Company Ltd', 'TN190415V7992183', '2019-04-15', '2020-04-14', '2020-03-25', '190(206)/TN31/GV/2017', '2017-04-07', '2022-04-06', '2022-03-10', '211/PY/GV/2018', '2018-04-12', '2022-04-06', '2022-03-10', 'TN190408V6522742', '2019-04-01', '2020-03-31', '2020-03-15', '7045/01-391903', '2019-04-01', '2020-03-31', '2020-03-15', '83689971', '2019-04-05', '2022-02-05', '2022-01-05', '2020-01-08', NULL, 'admin', 1, 1),
(14, NULL, NULL, '14', 'VGC0562679000100', '2019-07-03', '2020-07-02', '2020-06-20', 'Royal Sundaram General Insurance Co Limited', 'New', '2019-07-08', '2021-07-07', '2021-06-15', 'TN/571/GP/PC/2019/485', '2019-07-09', '2024-07-08', '2024-06-10', 'Temprory', '2020-01-08', '2020-01-08', '2020-01-08', 'New', '2019-07-01', '2020-03-31', '2020-03-15', 'Temprory', '2020-01-08', '2020-01-08', '2020-01-08', 'CVL054200541598', '2019-08-22', '2023-06-22', '2023-05-31', '2020-01-08', NULL, 'admin', 1, 1),
(15, NULL, NULL, '15', 'VGC056268000100', '2019-07-03', '2020-07-02', '2020-06-20', 'Royal Sundaram General Insurance Co Limited', 'New', '2019-07-08', '2021-07-07', '2021-06-15', 'TN/571/GP/PC/2019/483', '2019-07-09', '2024-07-08', '2024-06-10', 'Temprory', '2020-01-08', '2020-01-08', '2020-01-08', 'New', '2019-07-01', '2020-03-31', '2020-03-15', 'Temprory', '2020-01-08', '2020-01-08', '2020-01-08', 'CVL054200541617', '2019-08-22', '2023-06-22', '2023-05-25', '2020-01-08', NULL, 'admin', 1, 1),
(16, NULL, NULL, '16', 'VGC0562677000100', '2019-07-03', '2020-07-02', '2020-06-20', 'Royal Sundaram General Insurance Co. Limited', 'New', '2019-07-08', '2021-07-07', '2021-06-15', 'TN/571/GP/PC/2019/484', '2019-07-09', '2024-07-08', '2024-06-10', 'Temprory', '2020-01-08', '2020-01-08', '2020-01-08', 'New', '2019-07-01', '2020-03-31', '2020-03-15', 'Temprory', '2020-01-08', '2020-01-08', '2020-01-08', 'CVL054200541616', '2019-08-22', '2023-06-22', '2023-05-25', '2020-01-08', NULL, 'admin', 1, 1),
(17, NULL, NULL, '17', '413901/312020/1296', '2019-09-26', '2020-09-25', '2020-09-10', 'Tne Oriental Insurance Company Limited', 'TN190917C8523667', '2020-09-18', '2020-09-17', '2020-08-15', '375(566)/TN31/GV/2016', '2016-09-30', '2021-09-28', '2021-09-01', '1159/PY/GV/2016', '2016-12-12', '2021-09-28', '2021-09-01', 'TN190408V9522331', '2019-04-01', '2020-03-31', '2020-03-15', '5946/01-391909', '2019-04-01', '2020-03-31', '2020-03-15', 'P024200774', '2020-01-10', '2021-03-10', '2021-02-10', '2020-01-08', NULL, 'admin', 1, 1),
(18, NULL, NULL, '18', '413901/312020/1576', '2019-11-12', '2020-11-11', '2020-11-01', 'The Oriental Insurance Company Ltd', 'TN190826V9974739', '2019-08-26', '2020-08-25', '2020-08-01', 'TN/31/GP/PC/2019/142', '2019-03-01', '2024-02-29', '2024-02-01', '239/PY/GV/2019', '2019-03-14', '2024-02-29', '2024-02-01', 'TN190409V4612425', '2019-04-01', '2020-03-31', '2020-03-15', '6943/01-391912', '2019-04-01', '2020-03-31', '2020-03-15', 'P024200770', '2020-01-17', '2021-03-17', '2021-02-17', '2020-01-08', NULL, 'admin', 1, 1),
(19, NULL, NULL, '19', '506040311910000091', '2019-04-24', '2020-04-23', '2020-04-15', 'National Insurance Company Ltd', 'New', '2019-04-29', '2021-04-28', '2021-04-01', 'TN/571/GP/PC/2019/296', '2019-04-29', '2024-04-28', '2024-04-01', 'NA', '2020-01-08', '2020-01-08', '2020-01-08', 'New', '2019-07-01', '2020-03-31', '2020-03-15', 'NA', '2020-01-08', '2020-01-08', '2020-01-08', 'P02420062', '2019-06-03', '2023-04-03', '2023-03-03', '2020-01-08', NULL, 'admin', 1, 1),
(20, NULL, NULL, '20', '506040311910000341', '2019-07-14', '2020-07-13', '2020-07-01', 'National Insurance Company Ltd', 'TN190715V8616431', '2019-07-15', '2020-07-14', '2020-06-15', '41/TN31/GV/2016', '2016-01-22', '2021-01-21', '2020-12-20', '271/PY/GV/2016', '2016-04-01', '2021-01-21', '2020-12-21', 'TN190409V6616070', '2019-04-01', '2020-03-31', '2020-03-15', '7281/01-391911', '2019-04-01', '2020-03-31', '2020-03-15', 'P024200778', '2020-01-03', '2023-03-03', '2023-02-03', '2020-01-08', NULL, 'admin', 1, 1),
(22, NULL, NULL, '22', '123', '2020-01-22', '2021-01-21', '2021-01-20', 'feenix', '234', '2020-01-22', '2021-01-21', '2021-01-20', '345', '2020-01-22', '2021-01-21', '2021-01-20', '34', '2020-01-22', '2021-01-21', '2021-01-20', '45', '2020-01-22', '2021-01-21', '2021-01-20', '56', '2020-01-22', '2021-01-21', '2021-01-20', '2345', '2020-01-22', '2021-01-21', '2021-01-20', '2020-01-30', NULL, 'admin', 1, 1),
(23, NULL, NULL, '23', 'VGC0609581000100', '2020-02-15', '2021-02-14', '2021-02-01', 'Royal Sundaram General Insurance Company', 'New', '2020-02-21', '2022-02-20', '2022-01-11', 'TN2020-GP-7852A', '2020-02-21', '2025-02-20', '2025-01-11', 'New', '2020-02-21', '2025-02-20', '2025-01-11', 'New', '2020-02-15', '2020-03-31', '2020-03-16', 'New', '2020-02-15', '2020-03-31', '2020-03-16', 'P024201002', '2020-04-03', '2023-02-03', '2023-01-03', '2020-03-01', NULL, 'admin', 1, 1);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin_login`
--
ALTER TABLE `admin_login`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `admin_usermenulist`
--
ALTER TABLE `admin_usermenulist`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `brand_master`
--
ALTER TABLE `brand_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `employee_advance`
--
ALTER TABLE `employee_advance`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `employee_advance_collection`
--
ALTER TABLE `employee_advance_collection`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `employee_attendance_dtl`
--
ALTER TABLE `employee_attendance_dtl`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `employee_attendance_hdr`
--
ALTER TABLE `employee_attendance_hdr`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `employee_master`
--
ALTER TABLE `employee_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `expense_entry`
--
ALTER TABLE `expense_entry`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `expense_master`
--
ALTER TABLE `expense_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `explosive_return_dtl`
--
ALTER TABLE `explosive_return_dtl`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `explosive_return_hdr`
--
ALTER TABLE `explosive_return_hdr`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `explosive_stock`
--
ALTER TABLE `explosive_stock`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `explosive_utiliz_dtl`
--
ALTER TABLE `explosive_utiliz_dtl`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `explosive_utiliz_hdr`
--
ALTER TABLE `explosive_utiliz_hdr`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `externalfill_diesel`
--
ALTER TABLE `externalfill_diesel`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `externalpro_diesel`
--
ALTER TABLE `externalpro_diesel`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `fill_diesel`
--
ALTER TABLE `fill_diesel`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `internalpro_diesel`
--
ALTER TABLE `internalpro_diesel`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `internalpro_explosive_dtl`
--
ALTER TABLE `internalpro_explosive_dtl`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `internalpro_explosive_hdr`
--
ALTER TABLE `internalpro_explosive_hdr`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `internalpro_spare_dtl`
--
ALTER TABLE `internalpro_spare_dtl`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `internalpro_spare_hdr`
--
ALTER TABLE `internalpro_spare_hdr`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `internalunfillpro_diesel`
--
ALTER TABLE `internalunfillpro_diesel`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `login_details`
--
ALTER TABLE `login_details`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `product_master`
--
ALTER TABLE `product_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `purchasedetails`
--
ALTER TABLE `purchasedetails`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `purchasedetailswo`
--
ALTER TABLE `purchasedetailswo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `purchaseheader`
--
ALTER TABLE `purchaseheader`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `purchaseheaderwo`
--
ALTER TABLE `purchaseheaderwo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `purchase_dieselinvoice`
--
ALTER TABLE `purchase_dieselinvoice`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `purchase_explosiveinvoice_dtl`
--
ALTER TABLE `purchase_explosiveinvoice_dtl`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `purchase_explosiveinvoice_hdr`
--
ALTER TABLE `purchase_explosiveinvoice_hdr`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `purchase_spareinvoice_dtl`
--
ALTER TABLE `purchase_spareinvoice_dtl`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `purchase_spareinvoice_hdr`
--
ALTER TABLE `purchase_spareinvoice_hdr`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `supplier_master`
--
ALTER TABLE `supplier_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `supplier_payment`
--
ALTER TABLE `supplier_payment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `supplier_payment_header`
--
ALTER TABLE `supplier_payment_header`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `supplier_payment_headerwo`
--
ALTER TABLE `supplier_payment_headerwo`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `supplier_payment_spare`
--
ALTER TABLE `supplier_payment_spare`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `total_litres`
--
ALTER TABLE `total_litres`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `user_login`
--
ALTER TABLE `user_login`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `user_permission`
--
ALTER TABLE `user_permission`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
--
-- AUTO_INCREMENT for table `user_permission_master`
--
ALTER TABLE `user_permission_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
--
-- AUTO_INCREMENT for table `vehiclereg`
--
ALTER TABLE `vehiclereg`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `vehicle_master`
--
ALTER TABLE `vehicle_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
/*!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 */;
