-- phpMyAdmin SQL Dump
-- version 4.6.6
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Aug 14, 2017 at 09:39 AM
-- Server version: 5.5.55-cll
-- PHP Version: 5.6.30

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

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

--
-- Table structure for table `late_coming_daily_summary_aud`
--

CREATE TABLE `late_coming_daily_summary_aud` (
  `AUDROWID` int(11) NOT NULL,
  `LCDS_ID` int(11) NOT NULL DEFAULT '0',
  `ATTEND_CALENDAR_ID` int(11) NOT NULL,
  `PUNCH_IN_UTC_TIME` datetime NOT NULL,
  `DAY_NM` varchar(250) NOT NULL,
  `ATTND_EMP_ID` int(11) NOT NULL,
  `ATTND_EMP_NAME` varchar(250) NOT NULL,
  `SHIFT_TIME` time NOT NULL,
  `LATE_BY` time NOT NULL,
  `OA_ID` int(11) NOT NULL,
  `OA_BRAND_ID` int(11) NOT NULL,
  `USER_ID` int(11) NOT NULL,
  `ACTIONMODE` varchar(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `late_coming_daily_summary_aud`
--

INSERT INTO `late_coming_daily_summary_aud` (`AUDROWID`, `LCDS_ID`, `ATTEND_CALENDAR_ID`, `PUNCH_IN_UTC_TIME`, `DAY_NM`, `ATTND_EMP_ID`, `ATTND_EMP_NAME`, `SHIFT_TIME`, `LATE_BY`, `OA_ID`, `OA_BRAND_ID`, `USER_ID`, `ACTIONMODE`) VALUES
(1, 143, 564, '0000-00-00 00:00:00', 'Monday', 179, 'Oscar', '00:00:00', '00:00:00', 310, 333, 596, 'I'),
(2, 144, 564, '0000-00-00 00:00:00', 'Monday', 185, 'Izzat', '00:00:00', '00:00:00', 310, 333, 613, 'I'),
(3, 145, 564, '0000-00-00 00:00:00', 'Monday', 186, 'sparrow', '00:00:00', '00:00:00', 310, 333, 614, 'I'),
(4, 146, 564, '0000-00-00 00:00:00', 'Monday', 188, 'Starboy', '00:00:00', '00:00:00', 310, 333, 618, 'I'),
(5, 147, 564, '0000-00-00 00:00:00', 'Monday', 189, 'Schindler', '00:00:00', '00:00:00', 310, 333, 619, 'I'),
(6, 148, 564, '0000-00-00 00:00:00', 'Monday', 190, 'Pushpa', '00:00:00', '00:00:00', 310, 333, 620, 'I'),
(7, 149, 564, '0000-00-00 00:00:00', 'Monday', 191, 'Roger', '00:00:00', '00:00:00', 310, 333, 621, 'I'),
(8, 150, 564, '0000-00-00 00:00:00', 'Monday', 192, 'Stuart', '00:00:00', '00:00:00', 310, 333, 622, 'I'),
(9, 151, 564, '0000-00-00 00:00:00', 'Monday', 193, 'rahul', '00:00:00', '00:00:00', 310, 333, 623, 'I'),
(10, 152, 564, '0000-00-00 00:00:00', 'Monday', 195, 'Yuvraj', '00:00:00', '00:00:00', 310, 333, 625, 'I'),
(11, 153, 564, '0000-00-00 00:00:00', 'Monday', 196, 'Franklin', '00:00:00', '00:00:00', 310, 333, 626, 'I'),
(12, 154, 564, '0000-00-00 00:00:00', 'Monday', 199, 'Litleboy', '00:00:00', '00:00:00', 310, 333, 630, 'I'),
(13, 155, 564, '0000-00-00 00:00:00', 'Monday', 257, 'Laura', '00:00:00', '00:00:00', 310, 333, 712, 'I'),
(14, 156, 564, '0000-00-00 00:00:00', 'Monday', 258, 'Alexia', '00:00:00', '00:00:00', 310, 333, 713, 'I'),
(15, 157, 568, '0000-00-00 00:00:00', 'Friday', 268, 'SBRadmin', '00:00:00', '00:00:00', 372, 393, 728, 'I'),
(16, 158, 568, '0000-00-00 00:00:00', 'Friday', 269, 'swararaj', '00:00:00', '00:00:00', 372, 393, 729, 'I'),
(17, 159, 568, '0000-00-00 00:00:00', 'Friday', 270, 'Deepraj', '00:00:00', '00:00:00', 372, 393, 730, 'I'),
(18, 160, 568, '0000-00-00 00:00:00', 'Friday', 271, 'Sharayu', '00:00:00', '00:00:00', 372, 393, 731, 'I'),
(19, 161, 568, '0000-00-00 00:00:00', 'Friday', 272, 'Vinit', '00:00:00', '00:00:00', 372, 393, 732, 'I'),
(20, 162, 568, '0000-00-00 00:00:00', 'Friday', 273, 'Swaraj', '00:00:00', '00:00:00', 372, 393, 733, 'I'),
(21, 157, 568, '0000-00-00 00:00:00', 'Friday', 268, 'SBRadmin', '00:00:00', '00:00:00', 372, 393, 728, 'D'),
(22, 158, 568, '0000-00-00 00:00:00', 'Friday', 269, 'swararaj', '00:00:00', '00:00:00', 372, 393, 729, 'D'),
(23, 159, 568, '0000-00-00 00:00:00', 'Friday', 270, 'Deepraj', '00:00:00', '00:00:00', 372, 393, 730, 'D'),
(24, 160, 568, '0000-00-00 00:00:00', 'Friday', 271, 'Sharayu', '00:00:00', '00:00:00', 372, 393, 731, 'D'),
(25, 161, 568, '0000-00-00 00:00:00', 'Friday', 272, 'Vinit', '00:00:00', '00:00:00', 372, 393, 732, 'D'),
(26, 162, 568, '0000-00-00 00:00:00', 'Friday', 273, 'Swaraj', '00:00:00', '00:00:00', 372, 393, 733, 'D'),
(27, 163, 569, '0000-00-00 00:00:00', 'Saturday', 268, 'SBRadmin', '00:00:00', '00:00:00', 372, 393, 728, 'I'),
(28, 164, 569, '0000-00-00 00:00:00', 'Saturday', 269, 'swararaj', '00:00:00', '00:00:00', 372, 393, 729, 'I'),
(29, 165, 569, '0000-00-00 00:00:00', 'Saturday', 270, 'Deepraj', '00:00:00', '00:00:00', 372, 393, 730, 'I'),
(30, 166, 569, '0000-00-00 00:00:00', 'Saturday', 271, 'Sharayu', '00:00:00', '00:00:00', 372, 393, 731, 'I'),
(31, 167, 569, '0000-00-00 00:00:00', 'Saturday', 272, 'Vinit', '00:00:00', '00:00:00', 372, 393, 732, 'I'),
(32, 168, 569, '0000-00-00 00:00:00', 'Saturday', 273, 'Swaraj', '00:00:00', '00:00:00', 372, 393, 733, 'I'),
(33, 169, 572, '2017-07-25 09:30:23', 'Tuesday', 129, 'Amol Agre', '09:00:00', '00:30:23', 278, 301, 542, 'I'),
(34, 170, 572, '0000-00-00 00:00:00', 'Tuesday', 277, 'Nagendra', '00:00:00', '00:00:00', 278, 301, 737, 'I'),
(35, 171, 572, '0000-00-00 00:00:00', 'Tuesday', 278, 'Sanjeev', '00:00:00', '00:00:00', 278, 301, 738, 'I'),
(36, 169, 572, '2017-07-25 09:30:23', 'Tuesday', 129, 'Amol Agre', '09:00:00', '00:30:23', 278, 301, 542, 'D'),
(37, 170, 572, '0000-00-00 00:00:00', 'Tuesday', 277, 'Nagendra', '00:00:00', '00:00:00', 278, 301, 737, 'D'),
(38, 171, 572, '0000-00-00 00:00:00', 'Tuesday', 278, 'Sanjeev', '00:00:00', '00:00:00', 278, 301, 738, 'D'),
(39, 172, 572, '2017-07-25 09:30:23', 'Tuesday', 129, 'Amol Agre', '09:00:00', '00:30:23', 278, 301, 542, 'I'),
(40, 173, 572, '0000-00-00 00:00:00', 'Tuesday', 277, 'Nagendra', '00:00:00', '00:00:00', 278, 301, 737, 'I'),
(41, 174, 572, '0000-00-00 00:00:00', 'Tuesday', 278, 'Sanjeev', '00:00:00', '00:00:00', 278, 301, 738, 'I'),
(42, 175, 573, '0000-00-00 00:00:00', 'Wednesday', 263, 'Sunil', '00:00:00', '00:00:00', 370, 391, 721, 'I'),
(43, 176, 573, '2017-07-26 09:40:17', 'Wednesday', 274, 'Prachi', '00:00:00', '00:00:00', 370, 391, 734, 'I'),
(44, 177, 573, '0000-00-00 00:00:00', 'Wednesday', 275, 'Pradnya', '00:00:00', '00:00:00', 370, 391, 735, 'I'),
(45, 178, 573, '0000-00-00 00:00:00', 'Wednesday', 276, 'Kumar', '00:00:00', '00:00:00', 370, 391, 736, 'I'),
(46, 179, 575, '0000-00-00 00:00:00', 'Friday', 1, 'DEMOadmi', '00:00:00', '00:00:00', 151, 149, 254, 'I'),
(47, 180, 575, '0000-00-00 00:00:00', 'Friday', 3, 'vishal pandey', '00:00:00', '00:00:00', 151, 149, 297, 'I'),
(48, 181, 575, '0000-00-00 00:00:00', 'Friday', 4, 'Aakash shah', '00:00:00', '00:00:00', 151, 149, 309, 'I'),
(49, 182, 575, '0000-00-00 00:00:00', 'Friday', 5, 'maxsteel john', '05:00:00', '00:00:00', 151, 149, 310, 'I'),
(50, 183, 575, '0000-00-00 00:00:00', 'Friday', 6, 'mrzero', '00:00:00', '00:00:00', 151, 149, 318, 'I'),
(51, 184, 575, '0000-00-00 00:00:00', 'Friday', 7, 'Ruffy', '00:00:00', '00:00:00', 151, 149, 319, 'I'),
(52, 185, 575, '0000-00-00 00:00:00', 'Friday', 8, 'Anderson', '00:00:00', '00:00:00', 151, 149, 320, 'I'),
(53, 186, 575, '0000-00-00 00:00:00', 'Friday', 9, 'Vivek', '00:00:00', '00:00:00', 151, 149, 321, 'I'),
(54, 187, 575, '0000-00-00 00:00:00', 'Friday', 10, '', '00:00:00', '00:00:00', 151, 149, 322, 'I'),
(55, 188, 575, '0000-00-00 00:00:00', 'Friday', 11, 'Walker', '00:00:00', '00:00:00', 151, 149, 323, 'I'),
(56, 189, 575, '0000-00-00 00:00:00', 'Friday', 12, 'Bipin', '00:00:00', '00:00:00', 151, 149, 327, 'I'),
(57, 190, 575, '0000-00-00 00:00:00', 'Friday', 13, 'Vishal', '00:00:00', '00:00:00', 151, 149, 328, 'I'),
(58, 191, 575, '0000-00-00 00:00:00', 'Friday', 14, 'river', '00:00:00', '00:00:00', 151, 149, 329, 'I'),
(59, 192, 575, '0000-00-00 00:00:00', 'Friday', 15, 'neha', '00:00:00', '00:00:00', 151, 149, 331, 'I'),
(60, 193, 575, '0000-00-00 00:00:00', 'Friday', 16, 'nehapandey', '00:00:00', '00:00:00', 151, 149, 332, 'I'),
(61, 194, 575, '0000-00-00 00:00:00', 'Friday', 17, 'neha12', '00:00:00', '00:00:00', 151, 149, 333, 'I'),
(62, 195, 575, '0000-00-00 00:00:00', 'Friday', 18, 'neha14', '00:00:00', '00:00:00', 151, 149, 334, 'I'),
(63, 196, 575, '0000-00-00 00:00:00', 'Friday', 19, 'neha0404', '00:00:00', '00:00:00', 151, 149, 335, 'I'),
(64, 197, 575, '0000-00-00 00:00:00', 'Friday', 20, 'neha', '00:00:00', '00:00:00', 151, 149, 336, 'I'),
(65, 198, 575, '0000-00-00 00:00:00', 'Friday', 21, 'Jimmy', '00:00:00', '00:00:00', 151, 149, 342, 'I'),
(66, 199, 575, '0000-00-00 00:00:00', 'Friday', 22, '', '00:00:00', '00:00:00', 151, 149, 343, 'I'),
(67, 200, 575, '0000-00-00 00:00:00', 'Friday', 23, '', '00:00:00', '00:00:00', 151, 149, 344, 'I'),
(68, 201, 575, '0000-00-00 00:00:00', 'Friday', 63, 'depika', '00:00:00', '00:00:00', 151, 149, 408, 'I'),
(69, 202, 575, '0000-00-00 00:00:00', 'Friday', 162, 'DemoUser149', '00:00:00', '00:00:00', 151, 149, 567, 'I'),
(70, 203, 575, '0000-00-00 00:00:00', 'Friday', 164, 'lahsiv21', '00:00:00', '00:00:00', 151, 149, 579, 'I'),
(71, 204, 575, '0000-00-00 00:00:00', 'Friday', 166, 'sameerp', '00:00:00', '00:00:00', 151, 149, 583, 'I'),
(72, 205, 575, '0000-00-00 00:00:00', 'Friday', 167, 'Aditya', '00:00:00', '00:00:00', 151, 149, 584, 'I'),
(73, 206, 575, '0000-00-00 00:00:00', 'Friday', 168, 'Jimbei', '09:00:00', '00:00:00', 151, 149, 296, 'I'),
(74, 207, 575, '0000-00-00 00:00:00', 'Friday', 169, 'vishal', '00:00:00', '00:00:00', 151, 149, 297, 'I'),
(75, 208, 575, '0000-00-00 00:00:00', 'Friday', 170, 'Aakash', '00:00:00', '00:00:00', 151, 149, 309, 'I'),
(76, 209, 575, '0000-00-00 00:00:00', 'Friday', 172, 'shraddhar', '00:00:00', '00:00:00', 151, 149, 585, 'I'),
(77, 210, 575, '0000-00-00 00:00:00', 'Friday', 279, 'maxsteel', '00:00:00', '00:00:00', 151, 149, 310, 'I'),
(78, 211, 575, '0000-00-00 00:00:00', 'Friday', 280, 'priya', '00:00:00', '00:00:00', 151, 149, 404, 'I'),
(79, 179, 575, '0000-00-00 00:00:00', 'Friday', 1, 'DEMOadmi', '00:00:00', '00:00:00', 151, 149, 254, 'D'),
(80, 180, 575, '0000-00-00 00:00:00', 'Friday', 3, 'vishal pandey', '00:00:00', '00:00:00', 151, 149, 297, 'D'),
(81, 181, 575, '0000-00-00 00:00:00', 'Friday', 4, 'Aakash shah', '00:00:00', '00:00:00', 151, 149, 309, 'D'),
(82, 182, 575, '0000-00-00 00:00:00', 'Friday', 5, 'maxsteel john', '05:00:00', '00:00:00', 151, 149, 310, 'D'),
(83, 183, 575, '0000-00-00 00:00:00', 'Friday', 6, 'mrzero', '00:00:00', '00:00:00', 151, 149, 318, 'D'),
(84, 184, 575, '0000-00-00 00:00:00', 'Friday', 7, 'Ruffy', '00:00:00', '00:00:00', 151, 149, 319, 'D'),
(85, 185, 575, '0000-00-00 00:00:00', 'Friday', 8, 'Anderson', '00:00:00', '00:00:00', 151, 149, 320, 'D'),
(86, 186, 575, '0000-00-00 00:00:00', 'Friday', 9, 'Vivek', '00:00:00', '00:00:00', 151, 149, 321, 'D'),
(87, 187, 575, '0000-00-00 00:00:00', 'Friday', 10, '', '00:00:00', '00:00:00', 151, 149, 322, 'D'),
(88, 188, 575, '0000-00-00 00:00:00', 'Friday', 11, 'Walker', '00:00:00', '00:00:00', 151, 149, 323, 'D'),
(89, 189, 575, '0000-00-00 00:00:00', 'Friday', 12, 'Bipin', '00:00:00', '00:00:00', 151, 149, 327, 'D'),
(90, 190, 575, '0000-00-00 00:00:00', 'Friday', 13, 'Vishal', '00:00:00', '00:00:00', 151, 149, 328, 'D'),
(91, 191, 575, '0000-00-00 00:00:00', 'Friday', 14, 'river', '00:00:00', '00:00:00', 151, 149, 329, 'D'),
(92, 192, 575, '0000-00-00 00:00:00', 'Friday', 15, 'neha', '00:00:00', '00:00:00', 151, 149, 331, 'D'),
(93, 193, 575, '0000-00-00 00:00:00', 'Friday', 16, 'nehapandey', '00:00:00', '00:00:00', 151, 149, 332, 'D'),
(94, 194, 575, '0000-00-00 00:00:00', 'Friday', 17, 'neha12', '00:00:00', '00:00:00', 151, 149, 333, 'D'),
(95, 195, 575, '0000-00-00 00:00:00', 'Friday', 18, 'neha14', '00:00:00', '00:00:00', 151, 149, 334, 'D'),
(96, 196, 575, '0000-00-00 00:00:00', 'Friday', 19, 'neha0404', '00:00:00', '00:00:00', 151, 149, 335, 'D'),
(97, 197, 575, '0000-00-00 00:00:00', 'Friday', 20, 'neha', '00:00:00', '00:00:00', 151, 149, 336, 'D'),
(98, 198, 575, '0000-00-00 00:00:00', 'Friday', 21, 'Jimmy', '00:00:00', '00:00:00', 151, 149, 342, 'D'),
(99, 199, 575, '0000-00-00 00:00:00', 'Friday', 22, '', '00:00:00', '00:00:00', 151, 149, 343, 'D'),
(100, 200, 575, '0000-00-00 00:00:00', 'Friday', 23, '', '00:00:00', '00:00:00', 151, 149, 344, 'D'),
(101, 201, 575, '0000-00-00 00:00:00', 'Friday', 63, 'depika', '00:00:00', '00:00:00', 151, 149, 408, 'D'),
(102, 202, 575, '0000-00-00 00:00:00', 'Friday', 162, 'DemoUser149', '00:00:00', '00:00:00', 151, 149, 567, 'D'),
(103, 203, 575, '0000-00-00 00:00:00', 'Friday', 164, 'lahsiv21', '00:00:00', '00:00:00', 151, 149, 579, 'D'),
(104, 204, 575, '0000-00-00 00:00:00', 'Friday', 166, 'sameerp', '00:00:00', '00:00:00', 151, 149, 583, 'D'),
(105, 205, 575, '0000-00-00 00:00:00', 'Friday', 167, 'Aditya', '00:00:00', '00:00:00', 151, 149, 584, 'D'),
(106, 206, 575, '0000-00-00 00:00:00', 'Friday', 168, 'Jimbei', '09:00:00', '00:00:00', 151, 149, 296, 'D'),
(107, 207, 575, '0000-00-00 00:00:00', 'Friday', 169, 'vishal', '00:00:00', '00:00:00', 151, 149, 297, 'D'),
(108, 208, 575, '0000-00-00 00:00:00', 'Friday', 170, 'Aakash', '00:00:00', '00:00:00', 151, 149, 309, 'D'),
(109, 209, 575, '0000-00-00 00:00:00', 'Friday', 172, 'shraddhar', '00:00:00', '00:00:00', 151, 149, 585, 'D'),
(110, 210, 575, '0000-00-00 00:00:00', 'Friday', 279, 'maxsteel', '00:00:00', '00:00:00', 151, 149, 310, 'D'),
(111, 211, 575, '0000-00-00 00:00:00', 'Friday', 280, 'priya', '00:00:00', '00:00:00', 151, 149, 404, 'D'),
(112, 212, 578, '0000-00-00 00:00:00', 'Monday', 1, 'DEMOadmi', '00:00:00', '00:00:00', 151, 149, 254, 'I'),
(113, 213, 578, '0000-00-00 00:00:00', 'Monday', 3, 'vishal pandey', '00:00:00', '00:00:00', 151, 149, 297, 'I'),
(114, 214, 578, '0000-00-00 00:00:00', 'Monday', 4, 'Aakash shah', '00:00:00', '00:00:00', 151, 149, 309, 'I'),
(115, 215, 578, '0000-00-00 00:00:00', 'Monday', 5, 'maxsteel john', '05:00:00', '00:00:00', 151, 149, 310, 'I'),
(116, 216, 578, '0000-00-00 00:00:00', 'Monday', 6, 'mrzero', '00:00:00', '00:00:00', 151, 149, 318, 'I'),
(117, 217, 578, '0000-00-00 00:00:00', 'Monday', 7, 'Ruffy', '00:00:00', '00:00:00', 151, 149, 319, 'I'),
(118, 218, 578, '0000-00-00 00:00:00', 'Monday', 8, 'Anderson', '00:00:00', '00:00:00', 151, 149, 320, 'I'),
(119, 219, 578, '0000-00-00 00:00:00', 'Monday', 9, 'Vivek', '00:00:00', '00:00:00', 151, 149, 321, 'I'),
(120, 220, 578, '0000-00-00 00:00:00', 'Monday', 10, '', '00:00:00', '00:00:00', 151, 149, 322, 'I'),
(121, 221, 578, '0000-00-00 00:00:00', 'Monday', 11, 'Walker', '00:00:00', '00:00:00', 151, 149, 323, 'I'),
(122, 222, 578, '0000-00-00 00:00:00', 'Monday', 12, 'Bipin', '00:00:00', '00:00:00', 151, 149, 327, 'I'),
(123, 223, 578, '0000-00-00 00:00:00', 'Monday', 13, 'Vishal', '00:00:00', '00:00:00', 151, 149, 328, 'I'),
(124, 224, 578, '0000-00-00 00:00:00', 'Monday', 14, 'river', '00:00:00', '00:00:00', 151, 149, 329, 'I'),
(125, 225, 578, '0000-00-00 00:00:00', 'Monday', 15, 'neha', '00:00:00', '00:00:00', 151, 149, 331, 'I'),
(126, 226, 578, '0000-00-00 00:00:00', 'Monday', 16, 'nehapandey', '00:00:00', '00:00:00', 151, 149, 332, 'I'),
(127, 227, 578, '0000-00-00 00:00:00', 'Monday', 17, 'neha12', '00:00:00', '00:00:00', 151, 149, 333, 'I'),
(128, 228, 578, '0000-00-00 00:00:00', 'Monday', 18, 'neha14', '00:00:00', '00:00:00', 151, 149, 334, 'I'),
(129, 229, 578, '0000-00-00 00:00:00', 'Monday', 19, 'neha0404', '00:00:00', '00:00:00', 151, 149, 335, 'I'),
(130, 230, 578, '0000-00-00 00:00:00', 'Monday', 20, 'neha', '00:00:00', '00:00:00', 151, 149, 336, 'I'),
(131, 231, 578, '0000-00-00 00:00:00', 'Monday', 21, 'Jimmy', '00:00:00', '00:00:00', 151, 149, 342, 'I'),
(132, 232, 578, '0000-00-00 00:00:00', 'Monday', 22, '', '00:00:00', '00:00:00', 151, 149, 343, 'I'),
(133, 233, 578, '0000-00-00 00:00:00', 'Monday', 23, '', '00:00:00', '00:00:00', 151, 149, 344, 'I'),
(134, 234, 578, '0000-00-00 00:00:00', 'Monday', 63, 'depika', '00:00:00', '00:00:00', 151, 149, 408, 'I'),
(135, 235, 578, '0000-00-00 00:00:00', 'Monday', 162, 'DemoUser149', '00:00:00', '00:00:00', 151, 149, 567, 'I'),
(136, 236, 578, '0000-00-00 00:00:00', 'Monday', 164, 'lahsiv21', '00:00:00', '00:00:00', 151, 149, 579, 'I'),
(137, 237, 578, '0000-00-00 00:00:00', 'Monday', 166, 'sameerp', '00:00:00', '00:00:00', 151, 149, 583, 'I'),
(138, 238, 578, '0000-00-00 00:00:00', 'Monday', 167, 'Aditya', '00:00:00', '00:00:00', 151, 149, 584, 'I'),
(139, 239, 578, '0000-00-00 00:00:00', 'Monday', 168, 'Jimbei', '09:00:00', '00:00:00', 151, 149, 296, 'I'),
(140, 240, 578, '0000-00-00 00:00:00', 'Monday', 169, 'vishal', '00:00:00', '00:00:00', 151, 149, 297, 'I'),
(141, 241, 578, '0000-00-00 00:00:00', 'Monday', 170, 'Aakash', '09:00:00', '00:00:00', 151, 149, 309, 'I'),
(142, 242, 578, '0000-00-00 00:00:00', 'Monday', 172, 'shraddhar', '00:00:00', '00:00:00', 151, 149, 585, 'I'),
(143, 243, 578, '0000-00-00 00:00:00', 'Monday', 279, 'maxsteel', '00:00:00', '00:00:00', 151, 149, 310, 'I'),
(144, 244, 578, '0000-00-00 00:00:00', 'Monday', 280, 'priya', '00:00:00', '00:00:00', 151, 149, 404, 'I');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `late_coming_daily_summary_aud`
--
ALTER TABLE `late_coming_daily_summary_aud`
  ADD PRIMARY KEY (`AUDROWID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `late_coming_daily_summary_aud`
--
ALTER TABLE `late_coming_daily_summary_aud`
  MODIFY `AUDROWID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=145;
/*!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 */;
