-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 23, 2018 at 08:26 AM
-- Server version: 10.1.35-MariaDB
-- PHP Version: 7.2.9

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


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

--
-- Database: `inventory`
--

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

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

CREATE TABLE `category` (
  `categoryname` varchar(250) NOT NULL,
  `categoryid` varchar(250) NOT NULL,
  `total` int(250) NOT NULL,
  `newentry` int(250) NOT NULL,
  `now` int(250) NOT NULL,
  `aa` int(250) NOT NULL,
  `aa1` int(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `category` (`categoryname`, `categoryid`, `total`, `newentry`, `now`, `aa`, `aa1`) VALUES
('Keyboard', 'Cat_Key', 37, 1, 38, 21, 0),
('Laptop', 'Cat_lap', 15, 1, 16, 9, 0),
('Monitor', 'Cat_Mon', 15, 1, 16, 13, 0),
('Mouse', 'Cat_Mouse', 11, 4, 15, 12, 0),
('Printer', 'Cat_Pri', 16, 2, 18, 15, 0),
('Tonner', 'Cat_ton', 11, 1, 12, 10, 0);

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

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

CREATE TABLE `company` (
  `companyname` varchar(250) NOT NULL,
  `companyid` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `company` (`companyname`, `companyid`) VALUES
('dcdsv44', 'dcdsvcdsv_04'),
('FDF', 'FDF_01'),
('HDR', 'HDR_02'),
('HDT', 'HDT_03'),
('Virgo 2', 'Virgo_008'),
('Virgo Fish', 'Virgo_fish_006'),
('Virgo IT', 'Virgo_It_007'),
('Virgo Tobaco', 'Virgo_tobaco_005');

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

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

CREATE TABLE `employee` (
  `employeeid` varchar(250) NOT NULL,
  `employeename` varchar(250) NOT NULL,
  `department` varchar(250) NOT NULL,
  `companyname` varchar(250) NOT NULL,
  `joindate` date NOT NULL,
  `password` varchar(250) NOT NULL,
  `status` enum('admin','user','','') NOT NULL DEFAULT 'admin'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `employee` (`employeeid`, `employeename`, `department`, `companyname`, `joindate`, `password`, `status`) VALUES
('e_151001', 'ghfgfg', 'Finance', 'it', '2018-10-31', '123', 'user'),
('e_151002', 'xcxc', 'Finance', '', '0000-00-00', '123', 'user'),
('e_151003', 'gfgdf', 'HR', 'FDF', '0000-00-00', '123', 'user'),
('e_151004', 'uu', 'HR', 'FDF', '0000-00-00', '123', 'user'),
('e_151005', 'tt', 'Marketing', 'FDF', '0000-00-00', '123', 'user'),
('e_151006', 'tt', 'HR', '', '0000-00-00', '123', 'user'),
('e_151007', 'ererwerw', 'Finance', '', '0000-00-00', '', ''),
('e_151008', 'eewew', 'HR', 'weqeqw', '2018-09-04', '', ''),
('e_151009', 'tre', 'rtere', 'dfdsd', '2018-06-07', '', ''),
('e_151010', 'tytr', 'sdsd', 'sasas', '2018-09-18', '123', ''),
('e_151011', 'tt', 'HR', 'FDH', '2018-09-21', '123', 'user'),
('e_151012', 'ty', 'FF', 'hjghg', '2018-09-06', '123', 'user'),
('e_151013', 'fgfgfd', 'HR', 'FDF', '2018-09-27', '123', 'user'),
('e_151014', 'yutr', 'Finance', 'dcdsvcdsv', '2018-07-12', '123', 'user'),
('e_151015', 'mimi', 'IT', 'HDR ', '2018-09-04', '123', 'user'),
('e_151016', 'jj', 'IT', 'Virgo Tobaco ', '2018-10-25', '123', 'user'),
('e_15103032', 'mimi', 'IT', 'hjghhfgfd', '2018-09-04', '15103032', 'admin');

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

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `categoryid` varchar(250) NOT NULL,
  `code` varchar(250) NOT NULL,
  `avail` int(250) NOT NULL,
  `companyname` varchar(250) NOT NULL,
  `info` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`categoryid`, `code`, `avail`, `companyname`, `info`) VALUES
('Cat_Key ', '001', 0, '', ''),
('Cat_Key ', '002', 1, '', ''),
('Cat_Key ', 'key_003', 0, '', ''),
('Cat_Key ', 'key_004', 0, '', ''),
('Cat_Key ', 'key_005', 0, '', ''),
('Cat_Key ', 'key_006', 0, '', ''),
('Cat_Key ', 'key_007', 0, 'dcdsvcdsv', ''),
('Cat_Key ', 'key_008', 0, 'dcdsvcdsv', ''),
('Cat_Key ', 'key_009', 0, 'FDF', ''),
('Cat_Key ', 'key_010', 0, 'FDF', ''),
('Cat_Key ', 'key_011', 0, 'FDF', ''),
('Cat_Key ', 'key_012', 0, 'dcdsvcdsv', ''),
('Cat_Key ', 'key_013', 0, 'dcdsvcdsv', ''),
('Cat_Key ', 'key_014', 0, 'dcdsvcdsv', ''),
('Cat_Key ', 'key_015', 0, 'dcdsvcdsv', ''),
('Cat_Key ', 'key_016', 1, 'dcdsvcdsv', ''),
('Cat_Key ', 'key_017', 1, 'FDF ', ''),
('Cat_Key ', 'key_018', 1, 'dcdsvcdsv ', ''),
('Cat_Key ', 'key_020', 1, 'dcdsvcdsv ', ''),
('Cat_Key ', 'key_021', 1, 'HDR ', ''),
('Cat_Key ', 'key_022', 1, 'HDT ', ''),
('Cat_Key ', 'key_023', 0, 'HDR ', ''),
('Cat_Key ', 'key_024', 1, 'HDR ', ''),
('Cat_Key', 'key_025', 1, 'HDR ', ''),
('Cat_Key', 'key_026', 0, 'Virgo IT ', ''),
('Cat_Key', 'key_027', 0, 'Virgo Tobaco ', ''),
('Cat_Key', 'key_028', 1, 'Virgo IT ', ''),
('Cat_Key', 'key_029', 1, 'Virgo 2 ', ''),
('Cat_Key', 'key_030', 1, 'Virgo Tobaco ', ''),
('Cat_Key', 'key_031', 1, 'Virgo IT ', ''),
('Cat_Key', 'key_032', 1, 'HDR ', ''),
('Cat_Key', 'key_033', 1, 'Virgo Fish ', ''),
('Cat_Key', 'key_034', 1, 'Virgo Tobaco ', ''),
('Cat_Key', 'key_035', 1, 'Virgo IT ', ''),
('Cat_Key', 'key_036', 1, 'HDR ', ''),
('Cat_Key', 'key_037', 1, 'Virgo Fish ', ''),
('Cat_Key', 'key_038', 1, 'Virgo IT ', ''),
('Cat_Key', 'key_039', 1, 'Virgo Tobaco ', 'kkljhkhgbfgbghrtht'),
('Cat_lap ', 'lap_001', 0, 'dcdsvcdsv ', ''),
('Cat_lap ', 'lap_002', 1, 'HDR ', ''),
('Cat_lap ', 'lap_003', 1, 'HDT ', ''),
('Cat_lap ', 'lap_004', 0, 'HDR ', ''),
('Cat_lap ', 'lap_006', 0, 'HDT ', ''),
('Cat_lap ', 'lap_007', 1, 'dcdsvcdsv ', ''),
('Cat_lap ', 'lap_008', 0, 'HDR ', ''),
('Cat_lap ', 'lap_009', 0, 'HDT ', ''),
('Cat_lap ', 'lap_010', 0, 'HDT ', ''),
('Cat_lap ', 'lap_011', 1, 'dcdsvcdsv ', ''),
('Cat_lap ', 'lap_012', 1, 'FDF ', ''),
('Cat_lap ', 'lap_013', 1, 'HDR ', ''),
('Cat_lap ', 'lap_014', 0, 'dcdsvcdsv ', ''),
('Cat_lap', 'lap_015', 1, 'HDR ', ''),
('Cat_lap', 'lap_016', 1, 'HDR ', ''),
('Cat_lap', 'lap_017', 1, 'Virgo Tobaco ', ''),
('Cat_Mon ', 'mon_001', 0, '', ''),
('Cat_Mon ', 'mon_002', 1, '', ''),
('Cat_Mon ', 'mon_003', 1, '', ''),
('Cat_Mon ', 'mon_004', 1, '', ''),
('Cat_Mon ', 'mon_005', 1, 'FDF', ''),
('Cat_Mon ', 'mon_006', 1, 'FDF', ''),
('Cat_Mon ', 'mon_007', 0, 'FDF', ''),
('Cat_Mon ', 'mon_008', 1, 'FDF', ''),
('Cat_Mon ', 'mon_009', 0, 'FDF', ''),
('Cat_Mon ', 'mon_010', 1, 'FDF', ''),
('Cat_Mon ', 'mon_011', 1, 'dcdsvcdsv ', ''),
('Cat_Mon ', 'mon_012', 1, 'HDR ', ''),
('Cat_Mon ', 'mon_013', 1, 'HDR ', ''),
('Cat_Mon ', 'mon_014', 1, 'FDF ', ''),
('Cat_Mon ', 'mon_015', 1, 'HDR ', ''),
('Cat_Mon', 'mon_016', 1, 'Virgo Tobaco ', ''),
('Cat_Mouse ', 'mouse_001', 0, '', ''),
('Cat_Mouse ', 'mouse_002', 1, '', ''),
('Cat_Mouse ', 'mouse_003', 0, '', ''),
('Cat_Mouse ', 'mouse_004', 1, '', ''),
('Cat_Mouse ', 'mouse_005', 1, '', ''),
('Cat_Mouse ', 'mouse_006', 1, 'dcdsvcdsv', ''),
('Cat_Mouse ', 'mouse_007', 1, 'HDR', ''),
('Cat_Mouse ', 'mouse_008', 1, 'FDF', ''),
('Cat_Mouse ', 'mouse_009', 0, 'FDF', ''),
('Cat_Mouse ', 'mouse_010', 1, 'HDR', ''),
('Cat_Mouse ', 'mouse_011', 1, 'FDF', ''),
('Cat_Mouse', 'mouse_012', 1, 'dcdsvcdsv ', ''),
('Cat_Mouse', 'mouse_013', 1, 'HDR ', ''),
('Cat_Mouse', 'mouse_014', 1, 'HDR ', ''),
('Cat_Mouse', 'mouse_015', 1, 'HDR ', ''),
('Cat_Pri ', 'pri_001', 1, '', ''),
('Cat_Pri ', 'pri_002', 1, '', ''),
('Cat_Pri ', 'pri_003', 0, '', ''),
('Cat_Pri ', 'pri_004', 0, '', ''),
('Cat_Pri ', 'pri_005', 1, '', ''),
('Cat_Pri ', 'pri_006', 1, '', ''),
('Cat_Pri ', 'pri_007', 1, 'dcdsvcdsv', ''),
('Cat_Pri ', 'pri_008', 1, 'FDF', ''),
('Cat_Pri ', 'pri_009', 1, 'HDR', ''),
('Cat_Pri ', 'pri_010', 1, 'HDT', ''),
('Cat_Pri ', 'pri_011', 1, 'HDT', ''),
('Cat_Pri ', 'pri_012', 1, 'HDR', ''),
('Cat_Pri ', 'pri_013', 1, 'HDR', ''),
('Cat_Pri ', 'pri_014', 1, 'HDT', ''),
('Cat_Pri ', 'pri_015', 1, 'HDT', ''),
('Cat_Pri ', 'pri_016', 0, 'dcdsvcdsv', ''),
('Cat_Pri', 'pri_017', 1, 'dcdsvcdsv ', ''),
('Cat_Pri', 'pri_018', 1, 'HDT ', ''),
('Cat_ton ', 'Ton_001', 0, 'FDF ', ''),
('Cat_ton ', 'Ton_002', 1, 'FDF ', ''),
('Cat_ton ', 'Ton_003', 1, 'HDR ', ''),
('Cat_ton', 'Ton_004', 1, 'FDF', ''),
('Cat_ton', 'Ton_005', 0, 'FDF', ''),
('Cat_ton ', 'Ton_006', 1, 'HDR ', ''),
('Cat_ton', 'Ton_007', 1, 'dcdsvcdsv ', ''),
('Cat_ton', 'Ton_008', 1, 'HDR ', ''),
('Cat_ton', 'Ton_009', 1, 'HDR ', ''),
('Cat_ton', 'Ton_011', 1, 'Virgo Tobaco ', ''),
('Cat_ton', 'Ton_012', 1, 'Virgo Tobaco ', ''),
('Cat_ton', 'Ton_110', 1, 'Virgo Tobaco ', 'dcdsvfvbrtnyj5yhgrvg gnyntrnr');

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

--
-- Table structure for table `request`
--

CREATE TABLE `request` (
  `requestsl` int(250) NOT NULL,
  `tdate` date NOT NULL,
  `categoryid` varchar(250) NOT NULL,
  `aa` int(250) NOT NULL,
  `code` varchar(250) NOT NULL,
  `employeeid` varchar(250) NOT NULL,
  `companyname` varchar(250) NOT NULL,
  `text` text NOT NULL,
  `status` int(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `request`
--

INSERT INTO `request` (`requestsl`, `tdate`, `categoryid`, `aa`, `code`, `employeeid`, `companyname`, `text`, `status`) VALUES
(1, '0000-00-00', '', 0, '001', 'e_151010 ', 'eewew ', 'fwewe232fwdwe232', 1),
(2, '0000-00-00', '', 0, '001', 'e_151009 ', 'tre ', 'fwewe232fwdwe232', 1),
(3, '2018-09-18', '', 0, '001', 'e_151005 ', 'tt ', 'gfdrterwer', 1),
(7, '2018-09-21', '', 0, 'key_009', 'e_151007 ', 'FDF', 'ytytyrterterwerw', 1),
(8, '2018-09-21', '', 0, 'mon_004', 'e_151001 ', 'FDF', 'ytyftrtdfghjhkyuiyuy', 1),
(9, '2018-09-21', '', 0, 'key_012', 'e_151007 ', 'HDT', 'jhtyutyrterwerw', 1),
(10, '2018-09-21', '', 0, 'key_013', 'e_151008 ', 'HDR', 'kljkhjghdfghrtyertwersxcvgy', 1),
(11, '2018-09-21', '', 0, 'key_015', 'e_151009 ', 'HDT', 'kouioyuiyffdewerqw', 1),
(12, '2018-09-21', '', 0, 'mon_006', 'e_151013', 'FDF', 'ytyrtdrertdffsd', 1),
(13, '2018-09-23', '', 0, 'key_016', 'e_151011', 'fdf', 'gergtrhrth', 1),
(14, '2018-09-23', '', 0, 'mon_009', 'e_151012', 'HDR ', 'dwef3ef45t56uynfcdgytj', 1),
(15, '2018-09-23', '', 0, 'pri_001', 'e_151014', 'HDR ', 'grgrhtrhtrjy5', 1),
(16, '2018-09-23', '', 0, 'mouse_011', 'e_151013', 'HDR ', 'dfgtrhthyhytjy6', 1),
(17, '2018-10-13', '', 0, 'lap_006', 'e_151014', 'HDR ', 'tfdfsdweqewqwwqw', 1),
(18, '2018-10-13', 'Cat_ton', 0, 'Ton_005', 'e_151013', 'dcdsvcdsv ', 'gggggggggggggggg', 1),
(19, '2018-10-13', 'Cat_Key ', 0, 'key_023', 'e_151011', 'HDR ', '', 0),
(20, '2018-10-13', '', 0, 'mouse_010', 'e_151011', 'dcdsvcdsv ', 'jjjjjjjjjjjjjjj', 0),
(21, '2018-10-13', 'Cat_Mon ', 0, 'mon_008', 'e_151011', 'dcdsvcdsv ', '', 0),
(22, '2018-10-13', 'Cat_Mouse', 0, 'mouse_015', 'e_151011', 'dcdsvcdsv ', 'ffffffffff', 0),
(23, '2018-10-14', 'Cat_Mouse ', 0, 'mouse_005', 'e_151011', 'HDR ', '', 0),
(24, '2018-10-14', 'Cat_lap ', 8, 'lap_011', 'e_151011', 'dcdsvcdsv ', '', 1),
(25, '2018-10-14', 'Cat_Mouse', 8, 'mouse_013', 'e_151012', 'dcdsvcdsv ', '', 1),
(26, '2018-10-14', 'Cat_Key ', 10, 'key_017', 'e_15103032', 'HDR ', '', 1),
(27, '2018-10-14', 'Cat_lap ', 7, 'lap_012', 'e_151012', 'dcdsvcdsv ', '', 1),
(28, '2018-10-14', 'Cat_lap ', 7, 'lap_012', 'e_151011', 'dcdsvcdsv ', '', 1),
(29, '2018-10-14', 'Cat_lap', 6, 'lap_016', 'e_151011', 'dcdsvcdsv ', '', 1),
(30, '2018-10-15', 'Cat_Mon ', 11, 'mon_006', 'e_151011', 'dcdsvcdsv ', '', 1),
(31, '2018-10-18', 'Cat_ton ', 7, 'Ton_006', 'e_151001', 'dcdsvcdsv ', '', 0),
(32, '2018-10-23', 'Cat_Key ', 17, '002', 'e_151015', 'dcdsv44 ', 'fffffffffffffffffffff', 0);

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

--
-- Table structure for table `stock`
--

CREATE TABLE `stock` (
  `sl` int(250) NOT NULL,
  `categoryid` varchar(250) NOT NULL,
  `code` varchar(250) NOT NULL,
  `employeeid` varchar(250) NOT NULL,
  `companyname` varchar(250) NOT NULL,
  `assigndate` date NOT NULL,
  `leavedate` date NOT NULL,
  `textbox` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stock`
--

INSERT INTO `stock` (`sl`, `categoryid`, `code`, `employeeid`, `companyname`, `assigndate`, `leavedate`, `textbox`) VALUES
(1, '', 'mon_001 ', 'e_151001 ', '', '2018-09-14', '2018-09-27', 'tttttt'),
(2, '', 'mon_003 ', 'e_151007 ', '', '2018-09-13', '2018-10-31', ''),
(3, '', 'pri_004 ', 'e_151001 ', '', '2018-09-21', '0000-00-00', ''),
(4, '', 'mouse_005 ', 'e_151004 ', '', '2018-09-14', '0000-00-00', ''),
(5, '', '002 ', 'e_151003 ', '', '2018-09-15', '2018-09-27', 'tttttt'),
(6, '', 'key_003 ', 'e_151006 ', '', '2018-09-15', '0000-00-00', ''),
(7, '', 'mouse_003 ', 'e_151001 ', '', '2018-09-15', '0000-00-00', ''),
(8, '', 'key_006 ', 'e_151003 ', '', '2018-09-21', '0000-00-00', ''),
(9, '', 'key_005', 'e_151003', '', '2018-09-21', '0000-00-00', ''),
(10, '', 'key_006 ', 'e_151006 ', '', '2018-09-18', '0000-00-00', ''),
(11, '', 'mouse_001 ', 'e_151006 ', '', '2018-09-18', '0000-00-00', ''),
(12, '', 'key_004 ', 'e_151006 ', '', '2018-09-18', '0000-00-00', ''),
(13, '', 'pri_003 ', 'e_151006 ', '', '2018-09-18', '0000-00-00', ''),
(14, '', 'pri_005 ', 'e_151007 ', '', '2018-09-18', '0000-00-00', ''),
(15, '', 'mouse_002 ', 'e_151007 ', '', '2018-09-18', '0000-00-00', ''),
(16, '', 'mouse_004 ', 'e_151010 ', '', '2018-09-19', '0000-00-00', ''),
(17, '', 'key_008 ', 'e_151010 ', '', '2018-09-19', '0000-00-00', ''),
(18, '', 'pri_007 ', 'e_151009 ', '', '2018-09-19', '0000-00-00', ''),
(19, '', 'pri_002 ', 'e_151001 ', '', '2018-09-19', '0000-00-00', ''),
(20, '', 'pri_006 ', 'e_151009 ', 'FDF', '2018-09-19', '0000-00-00', ''),
(21, '', 'key_009 ', 'e_151007 ', 'FDF', '2018-09-22', '0000-00-00', ''),
(22, '', 'mon_004 ', 'e_151001 ', 'FDF', '2018-09-22', '0000-00-00', ''),
(23, '', 'key_010 ', 'e_151008 ', 'FDF', '2018-09-22', '0000-00-00', ''),
(24, '', 'key_010 ', 'e_151008 ', 'FDF', '2018-09-22', '0000-00-00', ''),
(25, '', 'key_010 ', 'e_151008 ', 'FDF', '2018-09-22', '0000-00-00', ''),
(26, '', 'key_011 ', 'e_151008 ', 'FDF', '2018-09-22', '0000-00-00', ''),
(27, '', 'mon_002 ', 'e_151006 ', 'FDF', '2018-09-22', '0000-00-00', ''),
(28, '', 'key_014 ', 'e_151008 ', 'HDT', '2018-09-22', '0000-00-00', ''),
(29, '', 'key_012', 'e_151007 ', 'HDT', '2018-09-22', '0000-00-00', ''),
(30, '', 'key_012', 'e_151007 ', 'HDT', '2018-09-22', '0000-00-00', ''),
(31, '', 'key_012', 'e_151007 ', 'HDT', '2018-09-22', '0000-00-00', ''),
(32, '', '$code', '$employeeid', '$companyname', '0000-00-00', '0000-00-00', ''),
(33, '', 'key_013', 'e_151008 ', 'HDR', '0000-00-00', '0000-00-00', ''),
(34, '', '001', 'e_151010 ', 'tytr ', '0000-00-00', '0000-00-00', ''),
(35, '', 'key_009', 'e_151001 ', '', '2018-09-22', '0000-00-00', ''),
(36, '', 'key_009', 'e_151001 ', '', '2018-09-22', '0000-00-00', ''),
(37, '', 'key_009', 'e_151001 ', '', '2018-09-22', '0000-00-00', ''),
(38, '', 'key_012', 'e_151007 ', 'HDT', '0000-00-00', '0000-00-00', ''),
(39, '', 'key_013', 'e_151008 ', 'HDR', '2018-09-22', '0000-00-00', ''),
(40, '', 'key_015', 'e_151009 ', 'HDT', '2018-09-22', '0000-00-00', ''),
(41, '', '001', 'e_151005 ', 'tt ', '2018-09-22', '0000-00-00', ''),
(42, '', 'key_009', 'e_151001 ', 'FDF', '0000-00-00', '0000-00-00', ''),
(43, '', 'key_016', 'e_151011', 'fdf', '2018-09-23', '0000-00-00', ''),
(44, '', 'key_016', 'e_151011', 'fdf', '2018-09-25', '0000-00-00', ''),
(45, '', 'mon_009', 'e_151012', 'HDR ', '0000-00-00', '0000-00-00', ''),
(46, '', 'key_016', 'e_151011', 'fdf', '0000-00-00', '0000-00-00', ''),
(47, '', 'mon_006', 'e_151013', 'FDF', '0000-00-00', '0000-00-00', ''),
(48, '', 'pri_001', 'e_151014', 'HDR ', '2018-09-25', '0000-00-00', ''),
(49, '', 'mouse_011', 'e_151013', 'HDR ', '2018-09-25', '0000-00-00', ''),
(50, '', 'mon_008 ', 'e_151013 ', 'HDR ', '2018-09-23', '0000-00-00', ''),
(51, '', 'mon_005 ', 'e_151010 ', 'HDT ', '2018-09-23', '0000-00-00', ''),
(52, '', '001 ', 'e_151010 ', 'HDR ', '2018-09-26', '0000-00-00', ''),
(53, '', 'key_004 ', 'e_151006 ', 'dcdsvcdsv ', '2018-09-26', '0000-00-00', ''),
(54, '', 'key_004 ', 'e_151007 ', 'HDR ', '2018-09-25', '0000-00-00', ''),
(55, '', 'key_006 ', 'e_151009 ', 'HDR ', '2018-09-27', '0000-00-00', ''),
(56, '', 'key_006 ', 'e_151005 ', 'HDR ', '2018-09-26', '0000-00-00', ''),
(57, '', 'mon_010 ', 'e_151006 ', 'HDR ', '2018-09-26', '2019-09-21', 'aaaaaaaa'),
(58, '', 'mon_009 ', 'e_151007 ', 'HDR ', '2018-12-29', '2019-01-19', 'ssssssssss'),
(59, '', 'mon_010 ', 'e_151008 ', 'HDR ', '2018-09-23', '2019-02-22', 'mmmmm'),
(60, '', 'mon_009 ', 'e_151004 ', 'HDR ', '2018-09-25', '0000-00-00', ''),
(61, '', 'key_007 ', 'e_151001 ', 'dcdsvcdsv ', '2018-09-30', '0000-00-00', ''),
(62, '', 'key_008 ', 'e_151005 ', 'HDR ', '2018-09-25', '0000-00-00', ''),
(63, '', 'key_009 ', 'e_151007 ', 'HDR ', '2018-09-26', '0000-00-00', ''),
(64, '', 'pri_016 ', 'e_151006 ', 'HDR ', '2018-09-25', '0000-00-00', ''),
(65, '', 'pri_013 ', 'e_151004 ', 'HDR ', '2018-09-25', '2018-09-27', 'tttttt'),
(66, '', '002 ', 'e_151004 ', 'HDR ', '2018-09-25', '2018-09-27', 'gggggggggg'),
(67, '', 'key_010 ', 'e_151005 ', 'HDR ', '2018-09-25', '2018-09-26', 'aaaaaaaaa'),
(68, '', 'key_011 ', 'e_151008 ', 'HDR ', '2018-09-24', '0000-00-00', ''),
(69, '', '002 ', 'e_151007 ', 'HDR ', '2018-09-25', '2019-01-19', 'kkkkkkkkkkkkkk'),
(70, '', 'mouse_008 ', 'e_151001 ', 'dcdsvcdsv ', '2018-09-26', '2019-02-16', 'mimi'),
(71, '', 'key_010 ', 'e_151004 ', 'HDR ', '2018-10-13', '0000-00-00', ''),
(72, '', 'key_012 ', 'e_151014 ', 'HDR ', '2018-10-13', '0000-00-00', ''),
(73, '', 'key_012 ', 'e_151014 ', 'HDR ', '2018-10-13', '0000-00-00', ''),
(74, '', 'key_012 ', 'e_151014 ', 'HDR ', '2018-10-13', '0000-00-00', ''),
(75, '', 'lap_001 ', 'e_151012 ', 'HDR ', '2018-10-13', '0000-00-00', ''),
(76, '', 'key_013 ', 'e_151015 ', 'HDR ', '2018-10-13', '0000-00-00', ''),
(77, 'Cat_lap ', 'lap_010 ', 'e_151012 ', 'dcdsvcdsv ', '2018-10-25', '0000-00-00', ''),
(78, '', 'key_014 ', 'e_151005 ', 'dcdsvcdsv ', '2018-10-19', '0000-00-00', ''),
(79, '', 'lap_009 ', 'e_151009 ', 'HDR ', '2018-10-17', '0000-00-00', ''),
(80, '', 'lap_004 ', 'e_151007 ', 'HDR ', '2018-10-18', '0000-00-00', ''),
(81, '', 'lap_004 ', 'e_151007 ', 'HDR ', '2018-10-18', '0000-00-00', ''),
(82, '', 'key_015 ', 'e_151006 ', 'HDR ', '2018-10-25', '0000-00-00', ''),
(83, '', 'Ton_001 ', 'e_151009 ', 'HDR ', '2018-10-24', '0000-00-00', ''),
(84, '', 'lap_014 ', 'e_151009 ', 'HDT ', '2018-10-17', '0000-00-00', ''),
(85, '', 'lap_006', 'e_151014', 'HDR ', '2018-10-18', '0000-00-00', ''),
(86, '', 'lap_006', 'e_151014', 'HDR ', '2018-10-18', '0000-00-00', ''),
(87, '', 'lap_006', 'e_151014', 'HDR ', '2018-10-18', '0000-00-00', ''),
(88, '', 'lap_006', 'e_151014', 'HDR ', '0000-00-00', '0000-00-00', ''),
(89, '', 'Ton_005', 'e_151013', 'dcdsvcdsv ', '0000-00-00', '0000-00-00', ''),
(90, '', 'lap_008 ', 'e_151001 ', 'HDR ', '2018-10-16', '0000-00-00', ''),
(91, '', 'mon_007 ', 'e_151005 ', 'HDR ', '2018-10-19', '0000-00-00', ''),
(92, '', 'mouse_009 ', 'e_151011 ', 'HDR ', '2018-10-26', '0000-00-00', ''),
(93, '', 'Ton_005', 'e_151013', 'dcdsvcdsv ', '0000-00-00', '0000-00-00', ''),
(94, '', 'Ton_005', 'e_151013', 'dcdsvcdsv ', '0000-00-00', '0000-00-00', ''),
(95, '', 'Ton_007 ', 'e_151009 ', 'HDR ', '2018-10-25', '2018-10-31', ''),
(96, '', 'pri_009 ', 'e_151008 ', 'HDT ', '2018-10-24', '2018-10-31', ''),
(97, '', 'lap_011', 'e_151011', 'dcdsvcdsv ', '2018-10-25', '2018-10-31', ''),
(98, '', 'mouse_013', 'e_151012', 'dcdsvcdsv ', '0000-00-00', '2018-10-31', ''),
(99, '', 'key_017', 'e_15103032', 'HDR ', '0000-00-00', '2018-10-31', ''),
(100, '', 'lap_012', 'e_151012', 'dcdsvcdsv ', '0000-00-00', '2018-10-24', 'kkkkkkkkkkkk'),
(101, '', 'lap_012', 'e_151011', 'dcdsvcdsv ', '0000-00-00', '2018-10-24', ''),
(102, '', 'lap_012', 'e_151011', 'dcdsvcdsv ', '0000-00-00', '2018-10-31', ''),
(103, '', 'lap_012', 'e_151011', 'dcdsvcdsv ', '0000-00-00', '2018-10-31', ''),
(104, '', 'lap_016', 'e_151011', 'dcdsvcdsv ', '2018-10-25', '2018-10-31', ''),
(105, '', 'pri_014 ', 'e_151015 ', 'HDR ', '2018-10-31', '2018-10-25', ''),
(106, '', 'key_021 ', 'e_151009 ', 'dcdsvcdsv ', '2018-10-15', '2018-10-31', ''),
(107, '', 'mon_006', 'e_151011', 'dcdsvcdsv ', '2018-10-31', '2018-10-31', ''),
(108, '', 'key_027 ', 'e_151016 ', 'Virgo IT ', '2018-10-31', '0000-00-00', ''),
(109, '', 'key_026 ', 'e_151013 ', 'HDT ', '2018-10-30', '0000-00-00', ''),
(110, '', 'key_026 ', 'e_151013 ', 'HDT ', '2018-10-30', '0000-00-00', ''),
(111, '', 'key_023 ', 'e_151012 ', 'Virgo IT ', '2018-10-31', '0000-00-00', '');

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `product`
--
ALTER TABLE `product`
  ADD PRIMARY KEY (`code`);

--
-- Indexes for table `request`
--
ALTER TABLE `request`
  ADD PRIMARY KEY (`requestsl`);

--
-- Indexes for table `stock`
--
ALTER TABLE `stock`
  ADD PRIMARY KEY (`sl`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `request`
--
ALTER TABLE `request`
  MODIFY `requestsl` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `stock`
--
ALTER TABLE `stock`
  MODIFY `sl` int(250) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=112;
COMMIT;

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