-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `admin_user_list`
--

CREATE TABLE `admin_user_list` (
  `admin_user_list_id` int(11) NOT NULL,
  `admin_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp(),
  `removed_on` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `admin_user_list`
--

INSERT INTO `admin_user_list` (`admin_user_list_id`, `admin_id`, `user_id`, `created_on`, `removed_on`) VALUES
(20, 42, 3, '2022-06-20 03:34:54', NULL),
(21, 42, 42, '2022-06-20 03:34:54', NULL),
(36, 10, 3, '2022-06-20 03:45:31', NULL),
(37, 10, 6, '2022-06-20 03:45:31', NULL),
(38, 10, 10, '2022-06-20 03:45:31', NULL),
(39, 10, 30, '2022-06-20 03:45:31', NULL),
(40, 5, 1, '2022-06-20 03:48:11', NULL),
(41, 5, 4, '2022-06-20 03:48:11', NULL),
(42, 5, 5, '2022-06-20 03:48:11', NULL),
(43, 5, 7, '2022-06-20 03:48:11', NULL),
(44, 5, 42, '2022-06-20 03:48:11', NULL),
(52, 1, 1, '2022-06-20 05:09:06', NULL),
(53, 1, 5, '2022-06-20 05:09:06', NULL),
(54, 1, 2, '2022-06-20 05:09:06', NULL),
(55, 1, 3, '2022-06-20 05:09:06', NULL),
(72, 30, 30, '2022-06-20 05:12:40', NULL),
(73, 30, 10, '2022-06-20 05:12:40', NULL),
(74, 30, 7, '2022-06-20 05:12:40', NULL),
(75, 30, 4, '2022-06-20 05:12:40', NULL);

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

--
-- Table structure for table `apply_leave`
--

CREATE TABLE `apply_leave` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `leave_type` varchar(200) DEFAULT NULL,
  `image` varchar(200) DEFAULT NULL,
  `frm_date` varchar(300) DEFAULT NULL,
  `to_date` varchar(300) DEFAULT NULL,
  `count` varchar(255) DEFAULT NULL,
  `full_causaul_leave` varchar(200) DEFAULT NULL,
  `half_causaul_leave` varchar(200) DEFAULT NULL,
  `unpaid` varchar(200) DEFAULT NULL,
  `reason` varchar(300) DEFAULT NULL,
  `remarks` varchar(300) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `created_on` timestamp NULL DEFAULT current_timestamp(),
  `removed_on` timestamp NULL DEFAULT NULL,
  `year` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `apply_leave`
--

INSERT INTO `apply_leave` (`id`, `user_id`, `name`, `leave_type`, `image`, `frm_date`, `to_date`, `count`, `full_causaul_leave`, `half_causaul_leave`, `unpaid`, `reason`, `remarks`, `status`, `created_on`, `removed_on`, `year`) VALUES
(1, 2, 'Sameer  Jadhav', 'Vacation Leave', NULL, '08/01/2022', '08/10/2022', '8', 'undefined', 'undefined', NULL, 'a', NULL, 'denied', '2022-06-19 17:34:27', NULL, '2022'),
(2, 3, 'siddhant sawant', 'Vacation Leave', NULL, '08/02/2022', '08/11/2022', '8', '8', '0', NULL, 'A', NULL, 'denied', '2022-06-19 17:44:30', NULL, '2022'),
(3, 4, 'Shweta ', 'Sick Leave', 'images/2022_06_19_10_18_04_Sunflower_from_Silesia2.jpg', '08/03/2022', '08/12/2022', '8', '8', '0', NULL, 'w', NULL, 'approved', '2022-06-19 20:18:04', NULL, '2022'),
(4, 6, 'Rahul Mishra', 'Maternity Leave', 'images/2022_06_19_10_21_54_Sunflower_from_Silesia2.jpg', '08/04/2022', '08/13/2022', '7', '7', '0', NULL, 's', NULL, 'denied', '2022-06-19 20:21:54', NULL, '2022'),
(5, 7, 'Namrata Sharma', 'Unpaid Leave', NULL, '08/05/2022', '08/14/2022', '6', '6', '0', NULL, 'a', NULL, 'pending', '2022-06-19 20:30:31', '0000-00-00 00:00:00', '2022'),
(6, 7, 'Namrata Sharma', 'Unpaid Leave', NULL, '08/05/2022', '08/14/2022', '6', '6', '0', NULL, 'a', NULL, 'pending', '2022-06-19 20:31:37', '0000-00-00 00:00:00', '2022'),
(7, 7, 'Namrata Sharma', 'Unpaid Leave', NULL, '08/05/2022', '08/14/2022', '6', '6', '0', NULL, 'a', NULL, 'pending', '2022-06-19 20:32:15', '0000-00-00 00:00:00', '2022'),
(8, 7, 'Namrata Sharma', 'Unpaid Leave', NULL, '08/05/2022', '08/14/2022', '6', '6', '0', NULL, 'a', NULL, 'denied', '2022-06-19 20:33:09', NULL, '2022'),
(9, 2, 'Sameer  Jadhav', 'Vacation Leave', NULL, '10/01/2022', '10/03/2022', '1', '1', '0', NULL, 'd', NULL, 'denied', '2022-06-19 20:42:21', NULL, '2022'),
(10, 3, 'siddhant sawant', 'Casual Leave', NULL, '10/02/2022', '10/04/2022', '2', '2', '0', NULL, 'f', NULL, 'denied', '2022-06-19 20:51:45', NULL, '2022'),
(11, 4, 'Shweta ', 'Sick Leave', 'images/2022_06_19_11_03_32_Sunflower_from_Silesia2.jpg', '10/03/2022', '10/04/2022', '2', '2', '0', NULL, 'a', NULL, 'approved', '2022-06-19 21:03:32', NULL, '2022'),
(12, 6, 'Rahul Mishra', 'Maternity Leave', 'images/2022_06_19_11_19_58_Sunflower_from_Silesia2.jpg', '10/04/2022', '10/06/2022', '3', '3', '0', NULL, 'a', NULL, 'denied', '2022-06-19 21:19:58', NULL, '2022'),
(13, 7, 'Namrata Sharma', 'Unpaid Leave', NULL, '10/07/2022', '10/10/2022', '2', '2', '0', NULL, 'a', NULL, 'denied', '2022-06-19 21:22:15', NULL, '2022'),
(14, 2, 'Sameer  Jadhav', 'Vacation Leave', NULL, '09/01/2022', '09/03/2022', '2', '2', '0', NULL, 'a', NULL, 'approved', '2022-06-19 21:37:30', NULL, '2022'),
(15, 3, 'siddhant sawant', 'Casual Leave', NULL, '09/02/2022', '09/04/2022', '1', '1', '0', NULL, 'A', NULL, 'denied', '2022-06-20 03:03:49', NULL, '2022'),
(16, 4, 'Shweta ', 'Casual Leave', NULL, '09/03/2022', '09/06/2022', '1.5', '1', '1', NULL, 'F', NULL, 'approved', '2022-06-20 03:08:04', NULL, '2022'),
(17, 6, 'Rahul Mishra', 'Maternity Leave', 'images/2022_06_20_05_09_52_Sunflower_from_Silesia2.jpg', '09/04/2022', '09/06/2022', '2', '2', '0', NULL, 'A', NULL, 'denied', '2022-06-20 03:09:52', NULL, '2022'),
(18, 7, 'Namrata Sharma', 'Unpaid Leave', NULL, '09/05/2022', '09/07/2022', '3', '3', '0', NULL, 'A', NULL, 'approved', '2022-06-20 03:11:22', NULL, '2022'),
(19, 2, 'Sameer  Jadhav', 'Vacation Leave', NULL, '11/01/2022', '11/03/2022', '3', '3', '0', NULL, 'A', NULL, 'approved', '2022-06-20 03:14:02', NULL, '2022'),
(20, 3, 'siddhant sawant', 'Casual Leave', NULL, '11/02/2022', '11/04/2022', '2.5', '2', '1', NULL, 'A', NULL, 'denied', '2022-06-20 03:17:20', NULL, '2022'),
(21, 4, 'Shweta ', 'Maternity Leave', 'images/2022_06_20_05_20_01_Sunflower_from_Silesia2.jpg', '11/02/2022', '11/05/2022', '3', '3', '0', NULL, 'A', NULL, 'approved', '2022-06-20 03:20:01', NULL, '2022'),
(22, 7, 'Namrata Sharma', 'Unpaid Leave', NULL, '11/05/2022', '11/07/2022', '1', '1', '0', NULL, 'A', NULL, 'approved', '2022-06-20 03:22:37', NULL, '2022'),
(23, 1, 'david m', 'Vacation Leave', NULL, '08/06/2022', '08/08/2022', '1', '1', '0', NULL, 'A', NULL, 'approved', '2022-06-20 03:24:36', NULL, '2022'),
(24, 30, 'Aparna Gharlute', 'Casual Leave', NULL, '08/07/2022', '08/09/2022', '1', '0', '2', NULL, 'A', NULL, 'denied', '2022-06-20 03:26:13', NULL, '2022'),
(25, 42, 'Harshitha  Polamarasetti', 'Sick Leave', 'images/2022_06_20_05_33_11_Sunflower_from_Silesia2.jpg', '08/08/2022', '08/10/2022', '3', '3', '0', NULL, 'a', NULL, 'approved', '2022-06-20 03:33:11', NULL, '2022'),
(26, 10, 'Nalin Bera', 'Maternity Leave', 'images/2022_06_20_05_36_12_Sunflower_from_Silesia2.jpg', '08/09/2022', '08/11/2022', '3', '3', '0', NULL, 'a', NULL, 'denied', '2022-06-20 03:36:12', NULL, '2022'),
(27, 5, 'Micheal ', 'Unpaid Leave', NULL, '08/10/2022', '08/12/2022', '3', '3', '0', NULL, 'a', NULL, 'approved', '2022-06-20 03:38:24', NULL, '2022'),
(28, 1, 'david m', 'Vacation Leave', NULL, '09/01/2022', '09/03/2022', '2', '2', '0', NULL, 'a', NULL, 'approved', '2022-06-20 03:40:39', NULL, '2022'),
(29, 30, 'Aparna Gharlute', 'Casual Leave', NULL, '09/02/2022', '09/04/2022', '1', '1', '0', NULL, 'a', NULL, 'denied', '2022-06-20 03:43:01', NULL, '2022'),
(30, 42, 'Harshitha  Polamarasetti', 'Sick Leave', 'images/2022_06_20_05_47_18_Sunflower_from_Silesia2.jpg', '09/03/2022', '09/05/2022', '1', '1', '0', NULL, 'a', NULL, 'approved', '2022-06-20 03:47:18', NULL, '2022'),
(31, 10, 'Nalin Bera', 'Maternity Leave', 'images/2022_06_20_05_51_21_Sunflower_from_Silesia2.jpg', '09/04/2022', '09/06/2022', '2', '2', '0', NULL, 'a', NULL, 'denied', '2022-06-20 03:51:21', NULL, '2022'),
(32, 5, 'Micheal ', 'Unpaid Leave', NULL, '09/05/2022', '09/07/2022', '3', '3', '0', NULL, 's', NULL, 'approved', '2022-06-20 03:53:34', NULL, '2022'),
(33, 2, 'Sameer  Jadhav', 'Vacation Leave', NULL, '12/01/2022', '12/03/2022', '2', 'undefined', 'undefined', NULL, 'a', NULL, 'pending', '2022-06-20 05:09:29', NULL, '2022'),
(34, 3, 'siddhant sawant', 'Casual Leave', NULL, '12/06/2022', '12/08/2022', '3', '3', '0', NULL, 'a', NULL, 'approved', '2022-06-20 04:20:01', NULL, '2022'),
(35, 4, 'Shweta ', 'Maternity Leave', 'images/2022_06_20_06_22_06_Sunflower_from_Silesia2.jpg', '12/03/2022', '12/05/2022', '1', '1', '0', NULL, 'a', NULL, 'pending', '2022-06-20 04:22:06', NULL, '2022'),
(36, 6, 'Rahul Mishra', 'Maternity Leave', 'images/2022_06_20_06_28_03_Sunflower_from_Silesia2.jpg', '12/08/2022', '12/10/2022', '2', 'undefined', 'undefined', NULL, 'a', NULL, 'pending', '2022-06-20 04:28:20', NULL, '2022'),
(37, 7, 'Namrata Sharma', 'Vacation Leave', NULL, '12/09/2022', '12/11/2022', '1', 'undefined', 'undefined', NULL, 'a', NULL, 'denied', '2022-06-20 04:56:35', NULL, '2022'),
(38, 1, 'david m', 'Vacation Leave', NULL, '06/29/2022', '06/30/2022', '2', '2', '0', NULL, 'a', NULL, 'pending', '2022-06-20 06:43:22', NULL, '2022'),
(39, 1, 'david m', 'Maternity Leave', 'images/2022_06_20_10_55_23_Sunflower_from_Silesia2.jpg', '06/27/2022', '06/29/2022', '2', '2', '0', NULL, 'a', NULL, 'pending', '2022-06-20 08:55:23', NULL, '2022'),
(40, 1, 'david m', 'Maternity Leave', 'images/2022_06_20_11_40_50_Sunflower_from_Silesia2.jpg', '06/21/2022', '08/11/2022', '38', 'undefined', 'undefined', NULL, 's', NULL, 'pending', '2022-06-20 09:52:00', NULL, '2022'),
(41, 3, 'siddhant sawant', 'Vacation Leave', NULL, '01/03/2022', '01/05/2022', '3', 'undefined', 'undefined', NULL, 'qa', NULL, 'pending', '2022-06-20 17:50:09', NULL, '2022');

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

--
-- Table structure for table `bal_leave`
--

CREATE TABLE `bal_leave` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `vacation_leave` varchar(255) NOT NULL DEFAULT '0',
  `causaul_leave` varchar(255) DEFAULT '0',
  `full_causaul_leave` varchar(200) DEFAULT NULL,
  `half_causaul_leave` varchar(200) DEFAULT NULL,
  `sick_leave` varchar(255) DEFAULT '0',
  `annual_leave` varchar(255) DEFAULT '0',
  `unpaid_leave` varchar(255) DEFAULT '0',
  `maternity_leave` varchar(255) DEFAULT '0',
  `public_holiday` int(255) DEFAULT 0,
  `vacation_status` int(11) DEFAULT 0,
  `sick_status` int(11) DEFAULT 0,
  `unpaid_status` int(11) DEFAULT 0,
  `public_status` int(11) DEFAULT 0,
  `causaul_status` int(11) DEFAULT 0,
  `removed_on` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bal_leave`
--

INSERT INTO `bal_leave` (`id`, `user_id`, `vacation_leave`, `causaul_leave`, `full_causaul_leave`, `half_causaul_leave`, `sick_leave`, `annual_leave`, `unpaid_leave`, `maternity_leave`, `public_holiday`, `vacation_status`, `sick_status`, `unpaid_status`, `public_status`, `causaul_status`, `removed_on`) VALUES
(1, 1, '18', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(2, 3, '19', '5', '1', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(3, 2, '16', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(4, 4, '21', '6.5', '3', '7', '0', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(5, 5, '21', '8', '4', '8', '10', '0', '24', '182', 0, 4, 4, 1, 0, 1, NULL),
(6, 6, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(7, 7, '21', '8', '4', '8', '10', '0', '26', '182', 0, 4, 4, 1, 0, 1, NULL),
(8, 8, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(9, 9, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(10, 10, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(11, 11, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(12, 12, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(13, 13, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(14, 14, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(15, 15, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(16, 16, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(17, 17, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(18, 18, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(19, 19, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(20, 20, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(21, 21, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(22, 22, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(23, 23, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(24, 24, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(25, 25, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(26, 26, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(27, 27, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(28, 28, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(29, 29, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(30, 30, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(31, 31, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(32, 32, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(33, 33, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(34, 34, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(35, 35, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(36, 36, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(37, 37, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(38, 38, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(39, 39, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(40, 40, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(41, 41, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(42, 42, '21', '8', '4', '8', '6', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(43, 66, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL),
(44, 67, '21', '8', '4', '8', '10', '0', '30', '182', 0, 4, 4, 1, 0, 1, NULL);

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

--
-- Table structure for table `cal`
--

CREATE TABLE `cal` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `tooltip` varchar(200) DEFAULT NULL,
  `dates` varchar(200) DEFAULT NULL,
  `status` varchar(200) DEFAULT NULL,
  `removed_on` timestamp NULL DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `cal`
--

INSERT INTO `cal` (`id`, `user_id`, `name`, `tooltip`, `dates`, `status`, `removed_on`, `type`) VALUES
(10, NULL, 'Sameer  Jadhav', 'Holiday Denied for Sameer  Jadhav', '1-8-2022', 'Denied', NULL, 'undefined'),
(11, NULL, 'Sameer  Jadhav', 'Holiday Denied for Sameer  Jadhav', '2-8-2022', 'Denied', NULL, '1'),
(12, NULL, 'Sameer  Jadhav', 'Holiday Denied for Sameer  Jadhav', '3-8-2022', 'Denied', NULL, '1'),
(13, NULL, 'Sameer  Jadhav', 'Holiday Denied for Sameer  Jadhav', '4-8-2022', 'Denied', NULL, '1'),
(14, NULL, 'Sameer  Jadhav', 'Holiday Denied for Sameer  Jadhav', '5-8-2022', 'Denied', NULL, '1'),
(15, NULL, 'Sameer  Jadhav', 'Holiday Denied for Sameer  Jadhav', '6-8-2022', 'Denied', NULL, '1'),
(16, NULL, 'Sameer  Jadhav', 'Holiday Denied for Sameer  Jadhav', '7-8-2022', 'Denied', NULL, '1'),
(17, NULL, 'Sameer  Jadhav', 'Holiday Denied for Sameer  Jadhav', '8-8-2022', 'Denied', NULL, '1'),
(18, NULL, 'Sameer  Jadhav', 'Holiday Denied for Sameer  Jadhav', '9-8-2022', 'Denied', NULL, '1'),
(19, NULL, 'Sameer  Jadhav', 'Holiday Denied for Sameer  Jadhav', '10-8-2022', 'Denied', NULL, 'undefined'),
(20, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '2-8-2022', 'Denied', NULL, '1'),
(21, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '3-8-2022', 'Denied', NULL, '1'),
(22, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '4-8-2022', 'Denied', NULL, '1'),
(23, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '5-8-2022', 'Denied', NULL, '1'),
(24, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '6-8-2022', 'Denied', NULL, '1'),
(25, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '7-8-2022', 'Denied', NULL, '1'),
(26, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '8-8-2022', 'Denied', NULL, '1'),
(27, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '9-8-2022', 'Denied', NULL, '1'),
(28, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '10-8-2022', 'Denied', NULL, '1'),
(29, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '11-8-2022', 'Denied', NULL, '1'),
(30, 4, 'Shweta ', 'Holiday Approved for Shweta ', '3-8-2022', 'Approved', NULL, '1'),
(31, 4, 'Shweta ', 'Holiday Approved for Shweta ', '4-8-2022', 'Approved', NULL, '1'),
(32, 4, 'Shweta ', 'Holiday Approved for Shweta ', '5-8-2022', 'Approved', NULL, '1'),
(33, 4, 'Shweta ', 'Holiday Approved for Shweta ', '6-8-2022', 'Approved', NULL, '1'),
(34, 4, 'Shweta ', 'Holiday Approved for Shweta ', '7-8-2022', 'Approved', NULL, '1'),
(35, 4, 'Shweta ', 'Holiday Approved for Shweta ', '8-8-2022', 'Approved', NULL, '1'),
(36, 4, 'Shweta ', 'Holiday Approved for Shweta ', '9-8-2022', 'Approved', NULL, '1'),
(37, 4, 'Shweta ', 'Holiday Approved for Shweta ', '10-8-2022', 'Approved', NULL, '1'),
(38, 4, 'Shweta ', 'Holiday Approved for Shweta ', '11-8-2022', 'Approved', NULL, '1'),
(39, 4, 'Shweta ', 'Holiday Approved for Shweta ', '12-8-2022', 'Approved', NULL, '1'),
(40, 6, 'Rahul Mishra', 'Holiday Denied for Rahul Mishra', '4-8-2022', 'Denied', NULL, '1'),
(41, 6, 'Rahul Mishra', 'Holiday Denied for Rahul Mishra', '5-8-2022', 'Denied', NULL, '1'),
(42, 6, 'Rahul Mishra', 'Holiday Denied for Rahul Mishra', '6-8-2022', 'Denied', NULL, '1'),
(43, 6, 'Rahul Mishra', 'Holiday Denied for Rahul Mishra', '7-8-2022', 'Denied', NULL, '1'),
(44, 6, 'Rahul Mishra', 'Holiday Denied for Rahul Mishra', '8-8-2022', 'Denied', NULL, '1'),
(45, 6, 'Rahul Mishra', 'Holiday Denied for Rahul Mishra', '9-8-2022', 'Denied', NULL, '1'),
(46, 6, 'Rahul Mishra', 'Holiday Denied for Rahul Mishra', '10-8-2022', 'Denied', NULL, '1'),
(47, 6, 'Rahul Mishra', 'Holiday Denied for Rahul Mishra', '11-8-2022', 'Denied', NULL, '1'),
(48, 6, 'Rahul Mishra', 'Holiday Denied for Rahul Mishra', '12-8-2022', 'Denied', NULL, '1'),
(49, 6, 'Rahul Mishra', 'Holiday Denied for Rahul Mishra', '13-8-2022', 'Denied', NULL, '1'),
(50, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '5-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(51, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '6-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(52, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '7-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(53, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '8-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(54, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '9-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(55, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '10-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(56, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '11-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(57, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '12-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(58, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '13-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(59, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '14-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(60, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '5-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(61, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '6-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(62, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '7-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(63, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '8-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(64, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '9-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(65, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '10-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(66, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '11-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(67, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '12-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(68, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '13-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(69, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '14-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(70, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '5-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(71, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '6-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(72, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '7-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(73, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '8-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(74, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '9-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(75, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '10-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(76, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '11-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(77, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '12-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(78, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '13-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(79, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '14-8-2022', 'Denied', '2022-06-19 20:32:57', '1'),
(80, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '5-8-2022', 'Denied', NULL, '1'),
(81, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '6-8-2022', 'Denied', NULL, '1'),
(82, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '7-8-2022', 'Denied', NULL, '1'),
(83, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '8-8-2022', 'Denied', NULL, '1'),
(84, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '9-8-2022', 'Denied', NULL, '1'),
(85, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '10-8-2022', 'Denied', NULL, '1'),
(86, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '11-8-2022', 'Denied', NULL, '1'),
(87, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '12-8-2022', 'Denied', NULL, '1'),
(88, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '13-8-2022', 'Denied', NULL, '1'),
(89, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '14-8-2022', 'Denied', NULL, '1'),
(90, 2, 'Sameer  Jadhav', 'Holiday Denied for Sameer  Jadhav', '1-10-2022', 'Denied', NULL, '1'),
(91, 2, 'Sameer  Jadhav', 'Holiday Denied for Sameer  Jadhav', '2-10-2022', 'Denied', NULL, '1'),
(92, 2, 'Sameer  Jadhav', 'Holiday Denied for Sameer  Jadhav', '3-10-2022', 'Denied', NULL, '1'),
(93, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '2-10-2022', 'Denied', NULL, '1'),
(94, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '3-10-2022', 'Denied', NULL, '1'),
(95, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '4-10-2022', 'Denied', NULL, '1'),
(108, 4, 'Shweta ', 'Holiday Approved for Shweta ', '3-10-2022', 'Approved', NULL, '1'),
(109, 4, 'Shweta ', 'Holiday Approved for Shweta ', '4-10-2022', 'Approved', NULL, '1'),
(110, 6, 'Rahul Mishra', 'Holiday Denied for Rahul Mishra', '4-10-2022', 'Denied', NULL, '1'),
(111, 6, 'Rahul Mishra', 'Holiday Denied for Rahul Mishra', '5-10-2022', 'Denied', NULL, '1'),
(112, 6, 'Rahul Mishra', 'Holiday Denied for Rahul Mishra', '6-10-2022', 'Denied', NULL, '1'),
(113, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '7-10-2022', 'Denied', NULL, '1'),
(114, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '8-10-2022', 'Denied', NULL, '1'),
(115, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '9-10-2022', 'Denied', NULL, '1'),
(116, 7, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '10-10-2022', 'Denied', NULL, '1'),
(117, 2, 'Sameer  Jadhav', 'Holiday Approved for Sameer  Jadhav', '1-9-2022', 'Approved', NULL, '1'),
(118, 2, 'Sameer  Jadhav', 'Holiday Approved for Sameer  Jadhav', '2-9-2022', 'Approved', NULL, '1'),
(119, 2, 'Sameer  Jadhav', 'Holiday Approved for Sameer  Jadhav', '3-9-2022', 'Approved', NULL, '1'),
(120, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '2-9-2022', 'Denied', NULL, '1'),
(121, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '3-9-2022', 'Denied', NULL, '1'),
(122, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '4-9-2022', 'Denied', NULL, '1'),
(123, 4, 'Shweta ', 'Holiday Approved for Shweta ', '3-9-2022', 'Approved', NULL, '2'),
(124, 4, 'Shweta ', 'Holiday Approved for Shweta ', '4-9-2022', 'Approved', NULL, '1'),
(125, 4, 'Shweta ', 'Holiday Approved for Shweta ', '5-9-2022', 'Approved', NULL, '1'),
(126, 4, 'Shweta ', 'Holiday Approved for Shweta ', '6-9-2022', 'Approved', NULL, '1'),
(127, 6, 'Rahul Mishra', 'Holiday Denied for Rahul Mishra', '4-9-2022', 'Denied', NULL, '1'),
(128, 6, 'Rahul Mishra', 'Holiday Denied for Rahul Mishra', '5-9-2022', 'Denied', NULL, '1'),
(129, 6, 'Rahul Mishra', 'Holiday Denied for Rahul Mishra', '6-9-2022', 'Denied', NULL, '1'),
(130, 7, 'Namrata Sharma', 'Holiday Approved for Namrata Sharma', '5-9-2022', 'Approved', NULL, '1'),
(131, 7, 'Namrata Sharma', 'Holiday Approved for Namrata Sharma', '6-9-2022', 'Approved', NULL, '1'),
(132, 7, 'Namrata Sharma', 'Holiday Approved for Namrata Sharma', '7-9-2022', 'Approved', NULL, '1'),
(133, 2, 'Sameer  Jadhav', 'Holiday Approved for Sameer  Jadhav', '1-11-2022', 'Approved', NULL, '1'),
(134, 2, 'Sameer  Jadhav', 'Holiday Approved for Sameer  Jadhav', '2-11-2022', 'Approved', NULL, '1'),
(135, 2, 'Sameer  Jadhav', 'Holiday Approved for Sameer  Jadhav', '3-11-2022', 'Approved', NULL, '1'),
(136, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '2-11-2022', 'Denied', NULL, '1'),
(137, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '3-11-2022', 'Denied', NULL, '1'),
(138, 3, 'siddhant sawant', 'Holiday Denied for siddhant sawant', '4-11-2022', 'Denied', NULL, '2'),
(139, 4, 'Shweta ', 'Holiday Approved for Shweta ', '2-11-2022', 'Approved', NULL, '1'),
(140, 4, 'Shweta ', 'Holiday Approved for Shweta ', '3-11-2022', 'Approved', NULL, '1'),
(141, 4, 'Shweta ', 'Holiday Approved for Shweta ', '4-11-2022', 'Approved', NULL, '1'),
(142, 4, 'Shweta ', 'Holiday Approved for Shweta ', '5-11-2022', 'Approved', NULL, '1'),
(143, 7, 'Namrata Sharma', 'Holiday Approved for Namrata Sharma', '5-11-2022', 'Approved', NULL, '1'),
(144, 7, 'Namrata Sharma', 'Holiday Approved for Namrata Sharma', '6-11-2022', 'Approved', NULL, '1'),
(145, 7, 'Namrata Sharma', 'Holiday Approved for Namrata Sharma', '7-11-2022', 'Approved', NULL, '1'),
(149, 30, 'Aparna Gharlute', 'Holiday Denied for Aparna Gharlute', '7-8-2022', 'Denied', NULL, '2'),
(150, 30, 'Aparna Gharlute', 'Holiday Denied for Aparna Gharlute', '8-8-2022', 'Denied', NULL, '1'),
(151, 30, 'Aparna Gharlute', 'Holiday Denied for Aparna Gharlute', '9-8-2022', 'Denied', NULL, '3'),
(152, 42, 'Harshitha  Polamarasetti', 'Holiday Approved for Harshitha  Polamarasetti', '8-8-2022', 'Approved', NULL, '1'),
(153, 42, 'Harshitha  Polamarasetti', 'Holiday Approved for Harshitha  Polamarasetti', '9-8-2022', 'Approved', NULL, '1'),
(154, 42, 'Harshitha  Polamarasetti', 'Holiday Approved for Harshitha  Polamarasetti', '10-8-2022', 'Approved', NULL, '1'),
(155, 10, 'Nalin Bera', 'Holiday Denied for Nalin Bera', '9-8-2022', 'Denied', NULL, '1'),
(156, 10, 'Nalin Bera', 'Holiday Denied for Nalin Bera', '10-8-2022', 'Denied', NULL, '1'),
(157, 10, 'Nalin Bera', 'Holiday Denied for Nalin Bera', '11-8-2022', 'Denied', NULL, '1'),
(158, 5, 'Micheal ', 'Holiday Approved for Micheal ', '10-8-2022', 'Approved', NULL, '1'),
(159, 5, 'Micheal ', 'Holiday Approved for Micheal ', '11-8-2022', 'Approved', NULL, '1'),
(160, 5, 'Micheal ', 'Holiday Approved for Micheal ', '12-8-2022', 'Approved', NULL, '1'),
(161, 1, 'david m', 'Holiday Approved for david m', '1-9-2022', 'Approved', NULL, '1'),
(162, 1, 'david m', 'Holiday Approved for david m', '2-9-2022', 'Approved', NULL, '1'),
(163, 1, 'david m', 'Holiday Approved for david m', '3-9-2022', 'Approved', NULL, '1'),
(164, 30, 'Aparna Gharlute', 'Holiday Denied for Aparna Gharlute', '2-9-2022', 'Denied', NULL, '1'),
(165, 30, 'Aparna Gharlute', 'Holiday Denied for Aparna Gharlute', '3-9-2022', 'Denied', NULL, '1'),
(166, 30, 'Aparna Gharlute', 'Holiday Denied for Aparna Gharlute', '4-9-2022', 'Denied', NULL, '1'),
(167, 42, 'Harshitha  Polamarasetti', 'Holiday Approved for Harshitha  Polamarasetti', '3-9-2022', 'Approved', NULL, '1'),
(168, 42, 'Harshitha  Polamarasetti', 'Holiday Approved for Harshitha  Polamarasetti', '4-9-2022', 'Approved', NULL, '1'),
(169, 42, 'Harshitha  Polamarasetti', 'Holiday Approved for Harshitha  Polamarasetti', '5-9-2022', 'Approved', NULL, '1'),
(170, 10, 'Nalin Bera', 'Holiday Denied for Nalin Bera', '4-9-2022', 'Denied', NULL, '1'),
(171, 10, 'Nalin Bera', 'Holiday Denied for Nalin Bera', '5-9-2022', 'Denied', NULL, '1'),
(172, 10, 'Nalin Bera', 'Holiday Denied for Nalin Bera', '6-9-2022', 'Denied', NULL, '1'),
(173, 5, 'Micheal ', 'Holiday Approved for Micheal ', '5-9-2022', 'Approved', NULL, '1'),
(174, 5, 'Micheal ', 'Holiday Approved for Micheal ', '6-9-2022', 'Approved', NULL, '1'),
(175, 5, 'Micheal ', 'Holiday Approved for Micheal ', '7-9-2022', 'Approved', NULL, '1'),
(185, NULL, 'siddhant sawant', 'Holiday Approved for siddhant sawant', '6-12-2022', 'Approved', NULL, '1'),
(186, NULL, 'siddhant sawant', 'Holiday Approved for siddhant sawant', '7-12-2022', 'Approved', NULL, '1'),
(187, NULL, 'siddhant sawant', 'Holiday Approved for siddhant sawant', '8-12-2022', 'Approved', NULL, '1'),
(188, 4, 'Shweta ', 'Holiday Pending for Shweta ', '3-12-2022', 'Pending', NULL, '1'),
(189, 4, 'Shweta ', 'Holiday Pending for Shweta ', '4-12-2022', 'Pending', NULL, '1'),
(190, 4, 'Shweta ', 'Holiday Pending for Shweta ', '5-12-2022', 'Pending', NULL, '1'),
(194, NULL, 'Rahul Mishra', 'Holiday Pending for Rahul Mishra', '8-12-2022', 'Pending', NULL, 'undefined'),
(195, NULL, 'Rahul Mishra', 'Holiday Pending for Rahul Mishra', '9-12-2022', 'Pending', NULL, '1'),
(196, NULL, 'Rahul Mishra', 'Holiday Pending for Rahul Mishra', '10-12-2022', 'Pending', NULL, 'undefined'),
(200, NULL, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '9-12-2022', 'Denied', NULL, 'undefined'),
(201, NULL, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '10-12-2022', 'Denied', NULL, '1'),
(202, NULL, 'Namrata Sharma', 'Holiday Denied for Namrata Sharma', '11-12-2022', 'Denied', NULL, 'undefined'),
(203, NULL, 'Sameer  Jadhav', 'Holiday Pending for Sameer  Jadhav', '1-12-2022', 'Pending', NULL, 'undefined'),
(204, NULL, 'Sameer  Jadhav', 'Holiday Pending for Sameer  Jadhav', '2-12-2022', 'Pending', NULL, '1'),
(205, NULL, 'Sameer  Jadhav', 'Holiday Pending for Sameer  Jadhav', '3-12-2022', 'Pending', NULL, 'undefined'),
(208, NULL, 'a', 'Holiday for a', '28-6-2022', 'holiday', '2022-06-20 09:22:42', '4'),
(264, NULL, 'david m', 'Holiday Pending for david m', '21-6-2022', 'Pending', NULL, 'undefined'),
(265, NULL, 'david m', 'Holiday Pending for david m', '22-6-2022', 'Pending', NULL, '1'),
(266, NULL, 'david m', 'Holiday Pending for david m', '23-6-2022', 'Pending', NULL, '1'),
(267, NULL, 'david m', 'Holiday Pending for david m', '24-6-2022', 'Pending', NULL, '1'),
(268, NULL, 'david m', 'Holiday Pending for david m', '25-6-2022', 'Pending', NULL, '1'),
(269, NULL, 'david m', 'Holiday Pending for david m', '26-6-2022', 'Pending', NULL, '1'),
(270, NULL, 'david m', 'Holiday Pending for david m', '27-6-2022', 'Pending', NULL, '1'),
(271, NULL, 'david m', 'Holiday Pending for david m', '28-6-2022', 'Pending', NULL, '1'),
(272, NULL, 'david m', 'Holiday Pending for david m', '29-6-2022', 'Pending', NULL, '1'),
(273, NULL, 'david m', 'Holiday Pending for david m', '30-6-2022', 'Pending', NULL, '1'),
(274, NULL, 'david m', 'Holiday Pending for david m', '1-7-2022', 'Pending', NULL, '1'),
(275, NULL, 'david m', 'Holiday Pending for david m', '2-7-2022', 'Pending', NULL, '1'),
(276, NULL, 'david m', 'Holiday Pending for david m', '3-7-2022', 'Pending', NULL, '1'),
(277, NULL, 'david m', 'Holiday Pending for david m', '4-7-2022', 'Pending', NULL, '1'),
(278, NULL, 'david m', 'Holiday Pending for david m', '5-7-2022', 'Pending', NULL, '1'),
(279, NULL, 'david m', 'Holiday Pending for david m', '6-7-2022', 'Pending', NULL, '1'),
(280, NULL, 'david m', 'Holiday Pending for david m', '7-7-2022', 'Pending', NULL, '1'),
(281, NULL, 'david m', 'Holiday Pending for david m', '8-7-2022', 'Pending', NULL, '1'),
(282, NULL, 'david m', 'Holiday Pending for david m', '9-7-2022', 'Pending', NULL, '1'),
(283, NULL, 'david m', 'Holiday Pending for david m', '10-7-2022', 'Pending', NULL, '1'),
(284, NULL, 'david m', 'Holiday Pending for david m', '11-7-2022', 'Pending', NULL, '1'),
(285, NULL, 'david m', 'Holiday Pending for david m', '12-7-2022', 'Pending', NULL, '1'),
(286, NULL, 'david m', 'Holiday Pending for david m', '13-7-2022', 'Pending', NULL, '1'),
(287, NULL, 'david m', 'Holiday Pending for david m', '14-7-2022', 'Pending', NULL, '1'),
(288, NULL, 'david m', 'Holiday Pending for david m', '15-7-2022', 'Pending', NULL, '1'),
(289, NULL, 'david m', 'Holiday Pending for david m', '16-7-2022', 'Pending', NULL, '1'),
(290, NULL, 'david m', 'Holiday Pending for david m', '17-7-2022', 'Pending', NULL, '1'),
(291, NULL, 'david m', 'Holiday Pending for david m', '18-7-2022', 'Pending', NULL, '1'),
(292, NULL, 'david m', 'Holiday Pending for david m', '19-7-2022', 'Pending', NULL, '1'),
(293, NULL, 'david m', 'Holiday Pending for david m', '20-7-2022', 'Pending', NULL, '1'),
(294, NULL, 'david m', 'Holiday Pending for david m', '21-7-2022', 'Pending', NULL, '1'),
(295, NULL, 'david m', 'Holiday Pending for david m', '22-7-2022', 'Pending', NULL, '1'),
(296, NULL, 'david m', 'Holiday Pending for david m', '23-7-2022', 'Pending', NULL, '1'),
(297, NULL, 'david m', 'Holiday Pending for david m', '24-7-2022', 'Pending', NULL, '1'),
(298, NULL, 'david m', 'Holiday Pending for david m', '25-7-2022', 'Pending', NULL, '1'),
(299, NULL, 'david m', 'Holiday Pending for david m', '26-7-2022', 'Pending', NULL, '1'),
(300, NULL, 'david m', 'Holiday Pending for david m', '27-7-2022', 'Pending', NULL, '1'),
(301, NULL, 'david m', 'Holiday Pending for david m', '28-7-2022', 'Pending', NULL, '1'),
(302, NULL, 'david m', 'Holiday Pending for david m', '29-7-2022', 'Pending', NULL, '1'),
(303, NULL, 'david m', 'Holiday Pending for david m', '30-7-2022', 'Pending', NULL, '1'),
(304, NULL, 'david m', 'Holiday Pending for david m', '31-7-2022', 'Pending', NULL, '1'),
(305, NULL, 'david m', 'Holiday Pending for david m', '1-8-2022', 'Pending', NULL, '1'),
(306, NULL, 'david m', 'Holiday Pending for david m', '2-8-2022', 'Pending', NULL, '1'),
(307, NULL, 'david m', 'Holiday Pending for david m', '3-8-2022', 'Pending', NULL, '1'),
(308, NULL, 'david m', 'Holiday Pending for david m', '4-8-2022', 'Pending', NULL, '1'),
(309, NULL, 'david m', 'Holiday Pending for david m', '5-8-2022', 'Pending', NULL, '1'),
(310, NULL, 'david m', 'Holiday Approved for david m', '6-8-2022', 'Approved', NULL, '1'),
(311, NULL, 'david m', 'Holiday Approved for david m', '7-8-2022', 'Approved', NULL, '1'),
(312, NULL, 'david m', 'Holiday Approved for david m', '8-8-2022', 'Approved', NULL, '1'),
(313, NULL, 'david m', 'Holiday Pending for david m', '9-8-2022', 'Pending', NULL, '1'),
(314, NULL, 'david m', 'Holiday Pending for david m', '10-8-2022', 'Pending', NULL, '1'),
(315, NULL, 'david m', 'Holiday Pending for david m', '11-8-2022', 'Pending', NULL, 'undefined'),
(316, NULL, 'a', 'Holiday for a', '22-6-2022', 'holiday', '2022-06-20 13:50:36', '4'),
(319, NULL, 'siddhant sawant', 'Holiday Pending for siddhant sawant', '3-1-2022', 'Pending', NULL, 'undefined'),
(320, NULL, 'siddhant sawant', 'Holiday Pending for siddhant sawant', '4-1-2022', 'Pending', NULL, '1'),
(321, NULL, 'siddhant sawant', 'Holiday Pending for siddhant sawant', '5-1-2022', 'Pending', NULL, 'undefined'),
(322, NULL, 's', 'Holiday for s', '11-6-2022', 'holiday', NULL, '4');

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

--
-- Table structure for table `funcmgr_apply`
--

CREATE TABLE `funcmgr_apply` (
  `id` int(11) NOT NULL,
  `apy_lv_id` int(11) DEFAULT NULL,
  `funct_status` varchar(300) DEFAULT NULL,
  `func_approved_date` timestamp NULL DEFAULT NULL,
  `removed_on` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `funcmgr_apply`
--

INSERT INTO `funcmgr_apply` (`id`, `apy_lv_id`, `funct_status`, `func_approved_date`, `removed_on`) VALUES
(1, 1, 'approved', '2022-06-19 17:43:06', NULL),
(2, 2, 'denied', '2022-06-19 17:52:48', NULL),
(3, 3, 'approved', '2022-06-19 20:18:48', NULL),
(4, 4, 'denied', '2022-06-19 20:23:00', NULL),
(5, 5, 'pending', NULL, '2022-06-19 20:31:25'),
(6, 6, 'pending', NULL, '2022-06-19 20:32:04'),
(7, 7, 'pending', NULL, '2022-06-19 20:32:57'),
(8, 8, 'approved', '2022-06-19 20:34:06', NULL),
(9, 9, 'approved', '2022-06-19 20:45:20', NULL),
(10, 10, 'denied', '2022-06-19 20:53:19', NULL),
(11, 11, 'approved', '2022-06-19 21:05:57', NULL),
(12, 12, 'denied', '2022-06-19 21:20:48', NULL),
(13, 13, 'approved', '2022-06-19 21:23:05', NULL),
(14, 14, 'approved', '2022-06-20 02:56:08', NULL),
(15, 15, 'denied', '2022-06-20 03:05:18', NULL),
(16, 16, 'approved', '2022-06-20 03:08:49', NULL),
(17, 17, 'denied', '2022-06-20 03:10:31', NULL),
(18, 18, 'approved', '2022-06-20 03:11:50', NULL),
(19, 19, 'approved', '2022-06-20 03:15:08', NULL),
(20, 20, 'denied', '2022-06-20 03:18:40', NULL),
(21, 21, 'approved', '2022-06-20 03:20:55', NULL),
(22, 22, 'approved', '2022-06-20 03:23:15', NULL),
(23, 23, 'approved', '2022-06-20 03:25:13', NULL),
(24, 24, 'denied', '2022-06-20 03:26:56', NULL),
(25, 25, 'approved', '2022-06-20 03:35:06', NULL),
(26, 26, 'denied', '2022-06-20 03:36:41', NULL),
(27, 27, 'approved', '2022-06-20 03:38:58', NULL),
(28, 28, 'approved', '2022-06-20 03:41:54', NULL),
(29, 29, 'denied', '2022-06-20 03:45:47', NULL),
(30, 30, 'approved', '2022-06-20 03:48:25', NULL),
(31, 31, 'denied', '2022-06-20 03:52:04', NULL),
(32, 32, 'approved', '2022-06-20 04:10:33', NULL),
(33, 33, 'pending', NULL, NULL),
(34, 34, 'approved', '2022-06-20 06:31:43', NULL),
(35, 35, 'pending', NULL, NULL),
(36, 36, 'pending', NULL, NULL),
(37, 37, 'denied', '2022-06-20 05:42:46', NULL),
(38, 38, 'pending', NULL, NULL),
(39, 39, 'pending', NULL, NULL),
(40, 40, 'pending', NULL, NULL),
(41, 41, 'pending', NULL, NULL);

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

--
-- Table structure for table `functional_mgr`
--

CREATE TABLE `functional_mgr` (
  `id` int(11) NOT NULL,
  `name_F` varchar(200) DEFAULT NULL,
  `login_id` int(11) DEFAULT NULL,
  `removed_on` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `functional_mgr`
--

INSERT INTO `functional_mgr` (`id`, `name_F`, `login_id`, `removed_on`) VALUES
(1, 'david m', 1, NULL),
(2, 'Harshitha  Polamarasetti', 42, NULL),
(19, 'Nalin Bera', 10, NULL),
(20, 'Micheal', 5, NULL),
(21, 'Aparna Gharlute', 30, NULL);

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

--
-- Table structure for table `holiday_list`
--

CREATE TABLE `holiday_list` (
  `id` int(11) NOT NULL,
  `year_id` int(11) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `day` varchar(200) DEFAULT NULL,
  `dates` varchar(200) DEFAULT NULL,
  `holiday` varchar(200) NOT NULL,
  `status` varchar(200) DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp(),
  `removed_on` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `holiday_list`
--

INSERT INTO `holiday_list` (`id`, `year_id`, `location_id`, `day`, `dates`, `holiday`, `status`, `created_on`, `removed_on`) VALUES
(1, NULL, NULL, '', '06/28/2022', 'a', NULL, '2022-06-20 08:55:04', '2022-06-20 09:22:42'),
(2, NULL, NULL, '', '06/22/2022', 'a', NULL, '2022-06-20 13:42:45', '2022-06-20 13:50:36'),
(3, NULL, NULL, '', '06/11/2022', 's', NULL, '2022-06-21 11:55:11', NULL);

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

--
-- Table structure for table `positional_mgr`
--

CREATE TABLE `positional_mgr` (
  `id` int(11) NOT NULL,
  `name_P` varchar(200) DEFAULT NULL,
  `login_id` int(11) DEFAULT NULL,
  `removed_on` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `positional_mgr`
--

INSERT INTO `positional_mgr` (`id`, `name_P`, `login_id`, `removed_on`) VALUES
(1, 'david m', 1, NULL),
(2, 'Harshitha  Polamarasetti', 42, NULL),
(19, 'Nalin Bera', 10, NULL),
(20, 'Micheal', 5, NULL),
(21, 'Aparna Gharlute', 30, NULL);

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

--
-- Table structure for table `postnmgr_apply`
--

CREATE TABLE `postnmgr_apply` (
  `id` int(11) NOT NULL,
  `apy_lv_id` int(11) DEFAULT NULL,
  `post_status` varchar(300) DEFAULT NULL,
  `post_approved_date` timestamp NULL DEFAULT NULL,
  `removed_on` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `postnmgr_apply`
--

INSERT INTO `postnmgr_apply` (`id`, `apy_lv_id`, `post_status`, `post_approved_date`, `removed_on`) VALUES
(1, 1, 'denied', '2022-06-19 17:43:27', NULL),
(2, 2, 'pending', NULL, NULL),
(3, 3, 'approved', '2022-06-19 20:20:20', NULL),
(4, 4, 'denied', '2022-06-19 20:25:15', NULL),
(5, 5, 'pending', NULL, '2022-06-19 20:31:25'),
(6, 6, 'pending', NULL, '2022-06-19 20:32:04'),
(7, 7, 'pending', NULL, '2022-06-19 20:32:57'),
(8, 8, 'denied', '2022-06-19 20:35:15', NULL),
(9, 9, 'denied', '2022-06-19 20:47:19', NULL),
(10, 10, 'approved', '2022-06-19 20:54:02', NULL),
(11, 11, 'approved', '2022-06-19 21:06:50', NULL),
(12, 12, 'denied', '2022-06-19 21:21:25', NULL),
(13, 13, 'denied', '2022-06-19 21:24:41', NULL),
(14, 14, 'approved', '2022-06-20 02:56:08', NULL),
(15, 15, 'denied', '2022-06-20 03:05:18', NULL),
(16, 16, 'approved', '2022-06-20 03:08:49', NULL),
(17, 17, 'denied', '2022-06-20 03:10:31', NULL),
(18, 18, 'approved', '2022-06-20 03:11:50', NULL),
(19, 19, 'approved', '2022-06-20 03:15:08', NULL),
(20, 20, 'denied', '2022-06-20 03:18:40', NULL),
(21, 21, 'approved', '2022-06-20 03:20:55', NULL),
(22, 22, 'approved', '2022-06-20 03:23:15', NULL),
(23, 23, 'approved', '2022-06-20 03:25:13', NULL),
(24, 24, 'denied', '2022-06-20 03:26:56', NULL),
(25, 25, 'approved', '2022-06-20 03:35:06', NULL),
(26, 26, 'denied', '2022-06-20 03:36:41', NULL),
(27, 27, 'approved', '2022-06-20 03:38:58', NULL),
(28, 28, 'approved', '2022-06-20 03:41:54', NULL),
(29, 29, 'denied', '2022-06-20 03:45:47', NULL),
(30, 30, 'approved', '2022-06-20 03:48:25', NULL),
(31, 31, 'denied', '2022-06-20 03:52:04', NULL),
(32, 32, 'approved', '2022-06-20 04:10:33', NULL),
(33, 33, 'pending', NULL, NULL),
(34, 34, 'approved', '2022-06-20 06:31:43', NULL),
(35, 35, 'pending', NULL, NULL),
(36, 36, 'pending', NULL, NULL),
(37, 37, 'denied', '2022-06-20 05:42:46', NULL),
(38, 38, 'pending', NULL, NULL),
(39, 39, 'pending', NULL, NULL),
(40, 40, 'pending', NULL, NULL),
(41, 41, 'pending', NULL, NULL);

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

--
-- Table structure for table `public_holiday`
--

CREATE TABLE `public_holiday` (
  `public_id` int(11) NOT NULL,
  `holiday` varchar(200) DEFAULT NULL,
  `holiday_date` date DEFAULT NULL,
  `holiday_day` varchar(200) DEFAULT NULL,
  `sat_date` date DEFAULT NULL,
  `mon_date` date DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp(),
  `removed_on` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `staffinfo`
--

CREATE TABLE `staffinfo` (
  `staffID` int(11) NOT NULL,
  `memberID` int(10) DEFAULT NULL,
  `departmentID` int(11) DEFAULT NULL,
  `clearanceLevel` int(11) NOT NULL DEFAULT 1 COMMENT '1 - intern level, 2 - employee level, 3 - head level, 4 - high head level, 5 - admin level',
  `firstName` varchar(50) CHARACTER SET utf8mb4 NOT NULL,
  `middleName` varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL,
  `lastName` varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL,
  `email` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `phoneNumber` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
  `city` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `state` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `country` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `avatar` varchar(150) CHARACTER SET utf8mb4 DEFAULT NULL,
  `planned` int(10) DEFAULT NULL,
  `joinDate` date DEFAULT NULL,
  `leaveDate` date DEFAULT NULL,
  `location` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `functionalManager` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `locationManager` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `removed_By` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `removed_On` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `photo_id` int(11) DEFAULT NULL,
  `birthDate` varchar(11) COLLATE utf8mb4_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `staffinfo`
--

INSERT INTO `staffinfo` (`staffID`, `memberID`, `departmentID`, `clearanceLevel`, `firstName`, `middleName`, `lastName`, `email`, `phoneNumber`, `city`, `state`, `country`, `avatar`, `planned`, `joinDate`, `leaveDate`, `location`, `functionalManager`, `locationManager`, `removed_By`, `removed_On`, `photo_id`, `birthDate`) VALUES
(1, 1, NULL, 5, 'david', 'NULL', 'm', 'siddhant@72dragons.com', '5', NULL, NULL, NULL, 'images/2022_04_11_06_11_21_david.jpg', NULL, '2020-06-09', NULL, 'USA', '66', '66', NULL, NULL, NULL, NULL),
(2, 3, NULL, 1, 'siddhant', 'NULL', 'sawant', 'siddhantsawant29@gmail.com', '5', NULL, NULL, NULL, 'images/2022_04_11_06_11_54_siddhant.jpg', NULL, '2022-04-01', NULL, 'India', '1', '1', NULL, NULL, NULL, NULL),
(3, 2, NULL, 1, 'Sameer ', NULL, 'Jadhav', 'Sameer@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(4, 4, NULL, 1, 'Shweta', NULL, '', 'shweta@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(5, 5, NULL, 1, 'Micheal', NULL, '', 'Micheal@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(6, 6, NULL, 1, 'Rahul', NULL, 'Mishra', 'Rahulm@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(7, 7, NULL, 1, 'Namrata', NULL, 'Sharma', 'Namrata@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(8, 8, NULL, 1, 'Divya', NULL, 'Venkatesh', 'Divya@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(9, 9, NULL, 1, 'Shabnam', NULL, 'Shaikh', 'Shabnam@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(10, 10, NULL, 1, 'Nalin', NULL, 'Bera', 'Nalin@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(11, 11, NULL, 1, 'Rahul', NULL, 'Dhakan', 'Rahuld@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(12, 12, NULL, 1, 'Ashish', NULL, '', 'Ashish@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(13, 13, NULL, 1, 'Space', NULL, 'Wu', 'Space@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(14, 14, NULL, 1, 'Ria', NULL, 'Arora', 'Ria@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(15, 15, NULL, 1, 'Zeno', NULL, 'Pereria', 'Zeno@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(16, 16, NULL, 1, 'Kirti', NULL, 'Maurya', 'Kirti@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(17, 17, NULL, 1, 'Asawari', NULL, 'Parsekar', 'Asawari@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(18, 18, NULL, 1, 'Ratan', NULL, 'Paul', 'Ratan@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(19, 19, NULL, 1, 'Rohit', NULL, 'Sharma', 'Rohit@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(20, 20, NULL, 1, 'Amol', NULL, '', 'Amol@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(21, 21, NULL, 1, 'Priyanshu', NULL, '', 'Priyanshu@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(22, 22, NULL, 1, 'Anya', NULL, 'Wang', 'Anya@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(23, 23, NULL, 1, 'Ayushya', NULL, '', 'Ayushya@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(24, 24, NULL, 1, 'Altamash', NULL, 'Shaikh', 'Altamash@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(25, 25, NULL, 1, 'Devidutta', NULL, 'Moharana', 'Devidutta@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(26, 26, NULL, 1, 'Raviraj', NULL, '', 'Raviraj@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(27, 27, NULL, 1, 'Neha', NULL, 'Singh', 'Neha@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(28, 28, NULL, 1, 'Manjusha', NULL, '', 'Manjusha@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(29, 29, NULL, 1, 'Sudipta', NULL, 'Chakraborty', 'Sudipta@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(30, 30, NULL, 1, 'Aparna', NULL, 'Gharlute', 'Aparna@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(31, 31, NULL, 1, 'Dhwanika', NULL, 'Bhansali', 'Dhwanika@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(32, 32, NULL, 1, 'Sashi', NULL, '', 'Sashi@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(33, 33, NULL, 1, 'Xixie', NULL, '', 'Xixie@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(34, 34, NULL, 1, 'Yao', NULL, 'Ching', 'Yao@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(35, 35, NULL, 1, 'Lu', NULL, 'Cheng', 'Lu@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(36, 36, NULL, 1, 'Alajandro', NULL, '', 'Alajandro@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(37, 37, NULL, 1, 'Fatima', NULL, '', 'Fatima@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(38, 38, NULL, 1, 'Asteria', NULL, 'zhang', 'asteria@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(39, 39, NULL, 1, 'kartik', NULL, 'm', 'kartik@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(40, 40, NULL, 1, 'Girisuta', NULL, 'Nag', 'girisuta@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(41, 41, NULL, 1, 'Martin', NULL, 'm', 'martin@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(42, 42, NULL, 4, 'Harshitha', NULL, ' Polamarasetti', 'harstita@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(62, 66, NULL, 4, 'Bradley', NULL, 'M', 'Brad@gmail.com', NULL, NULL, NULL, NULL, 'images/2022_04_08_03_39_18_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', NULL, NULL, NULL, NULL, NULL, NULL),
(63, 67, NULL, 1, 'pooja', 'NULL', 'NULL', 'pooja@gmail.com', '5', NULL, NULL, NULL, 'images/2022_04_11_12_27_45_Sunflower_from_Silesia2.jpg', NULL, '2020-06-09', NULL, 'India', '1', '1', NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `user_funcmgr`
--

CREATE TABLE `user_funcmgr` (
  `id` int(11) NOT NULL,
  `funcMgr_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `removed_on` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_funcmgr`
--

INSERT INTO `user_funcmgr` (`id`, `funcMgr_id`, `user_id`, `removed_on`) VALUES
(20, 42, 3, NULL),
(21, 42, 42, NULL),
(36, 10, 3, NULL),
(37, 10, 6, NULL),
(38, 10, 10, NULL),
(39, 10, 30, NULL),
(40, 5, 1, NULL),
(41, 5, 4, NULL),
(42, 5, 5, NULL),
(43, 5, 7, NULL),
(44, 5, 42, NULL),
(52, 1, 1, NULL),
(53, 1, 5, NULL),
(54, 1, 2, NULL),
(55, 1, 3, NULL),
(72, 30, 30, NULL),
(73, 30, 10, NULL),
(74, 30, 7, NULL),
(75, 30, 4, NULL);

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

--
-- Table structure for table `user_posimgr`
--

CREATE TABLE `user_posimgr` (
  `id` int(11) NOT NULL,
  `posiMgr_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `removed_on` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_posimgr`
--

INSERT INTO `user_posimgr` (`id`, `posiMgr_id`, `user_id`, `removed_on`) VALUES
(20, 42, 3, NULL),
(21, 42, 42, NULL),
(36, 10, 3, NULL),
(37, 10, 6, NULL),
(38, 10, 10, NULL),
(39, 10, 30, NULL),
(40, 5, 1, NULL),
(41, 5, 4, NULL),
(42, 5, 5, NULL),
(43, 5, 7, NULL),
(44, 5, 42, NULL),
(52, 1, 1, NULL),
(53, 1, 5, NULL),
(54, 1, 2, NULL),
(55, 1, 3, NULL),
(72, 30, 30, NULL),
(73, 30, 10, NULL),
(74, 30, 7, NULL),
(75, 30, 4, NULL);

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

--
-- Table structure for table `working_list`
--

CREATE TABLE `working_list` (
  `id` int(11) NOT NULL,
  `year_id` int(11) DEFAULT NULL,
  `location_id` int(11) DEFAULT NULL,
  `day` varchar(200) DEFAULT NULL,
  `dates` varchar(200) DEFAULT NULL,
  `holiday` varchar(200) NOT NULL,
  `status` varchar(200) DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT current_timestamp(),
  `removed_on` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for table `admin_user_list`
--
ALTER TABLE `admin_user_list`
  ADD PRIMARY KEY (`admin_user_list_id`);

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

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

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

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

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

--
-- Indexes for table `holiday_list`
--
ALTER TABLE `holiday_list`
  ADD PRIMARY KEY (`id`) USING BTREE;

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

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

--
-- Indexes for table `public_holiday`
--
ALTER TABLE `public_holiday`
  ADD PRIMARY KEY (`public_id`);

--
-- Indexes for table `staffinfo`
--
ALTER TABLE `staffinfo`
  ADD PRIMARY KEY (`staffID`);

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

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

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

--
-- AUTO_INCREMENT for table `admin_user_list`
--
ALTER TABLE `admin_user_list`
  MODIFY `admin_user_list_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `public_holiday`
--
ALTER TABLE `public_holiday`
  MODIFY `public_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `staffinfo`
--
ALTER TABLE `staffinfo`
  MODIFY `staffID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

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

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

--
-- AUTO_INCREMENT for table `working_list`
--
ALTER TABLE `working_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

