   `attendance_date` date NOT NULL,
   KEY `training` (`meeting_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Dumping data for table `meeting_attendance`
---
-
-INSERT INTO `meeting_attendance` (`meeting_id`, `unit`, `attendance_date`) VALUES
-(6, '50', '2017-04-27'),
-(6, '40', '2017-04-27'),
-(6, '09', '2017-04-27');
 
 -- --------------------------------------------------------
 

  KEY `schedule` (`schedule`),
  KEY `unit_2` (`unit`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `duty_attendance`
--

INSERT INTO `duty_attendance` (`unit`, `attendance_date`, `time_in`, `time_out`, `schedule`, `date_created`) VALUES
('45', '2017-04-30', '07:07 PM', '07:07 AM', 'Sunday', '2017-05-01 23:28:36'),
('88', '2017-04-28', '08:00 PM', '08:00 AM', 'Friday', '2017-05-02 22:36:57'),
('88', '2017-05-02', '08:00 PM', '08:00 AM', 'Tuesday', '2017-05-02 22:37:35'),
('94', '2017-05-01', '08:00 PM', '06:00 AM', 'Monday', '2017-05-02 23:37:48'),
('90', '2017-05-01', '08:59 PM', '08:08 AM', 'Monday', '2017-05-02 23:40:53'),
('92', '2017-05-02', '10:02 PM', '08:00 AM', 'Tuesday', '2017-05-02 23:41:07'),
('83', '2017-05-02', '09:00 PM', '08:00 AM', 'Tuesday', '2017-05-02 23:41:25'),
('94', '2017-05-14', '08:00 PM', '08:00 AM', 'Sunday', '2017-05-14 21:22:27'),
('90', '2017-05-14', '09:00 PM', '08:00 AM', 'Sunday', '2017-05-14 21:26:59'),
('90', '2017-05-15', '07:48 PM', '80:00 AM', 'Monday', '2017-05-16 00:53:49'),
('92', '2017-05-15', '10:30 PM', '08:08 AM', 'Monday', '2017-05-16 00:55:11'),
('94', '2017-05-15', '08:00 PM', '08:00 AM', 'Monday', '2017-05-16 01:31:54'),
('92', '2017-05-01', '10:02 PM', '08:08 AM', 'Monday', '2017-05-16 01:33:20'),
('83', '2017-05-01', '09:00 PM', '08:00 AM', 'Monday', '2017-05-16 01:34:11'),
('84', '2017-05-13', '03:30 PM', '10:45 AM', 'Saturday', '2017-05-16 01:36:17'),
('93', '2017-05-13', '05:37 PM', '03:00 PM', 'Saturday', '2017-05-16 01:37:40'),
('90', '2017-05-13', '08:00 PM', '01:00 PM', 'Saturday', '2017-05-16 01:38:21'),
('91', '2017-05-13', '09:04 PM', '10:45 AM', 'Saturday', '2017-05-16 01:38:55'),
('97', '2017-05-13', '09:15 PM', '12:10 PM', 'Saturday', '2017-05-16 01:39:10'),
('95', '2017-05-13', '09:25 PM', '10:12 AM', 'Saturday', '2017-05-16 01:39:27'),
('94', '2017-05-13', '09:46 PM', '10:10 AM', 'Saturday', '2017-05-16 01:39:48'),
('96', '2017-05-13', '11:46 PM', '09:30 AM', 'Saturday', '2017-05-16 01:40:11'),
('86', '2017-05-13', '07:00 PM', '12:00 PM', 'Saturday', '2017-05-16 01:40:28'),
('90', '2017-05-12', '07:52 PM', '08:00 AM', 'Friday', '2017-05-16 01:41:17'),
('84', '2017-05-12', '08:27 PM', '04:45 AM', 'Friday', '2017-05-16 01:41:36'),
('88', '2017-05-12', '09:27 PM', '07:04 AM', 'Friday', '2017-05-16 01:41:45'),
('92', '2017-05-12', '09:00 PM', '08:07 AM', 'Friday', '2017-05-16 01:41:56'),
('94', '2017-04-09', '08:00 PM', '08:00 AM', 'Sunday', '2017-05-16 17:56:07');

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


  KEY `unit` (`unit`),
  KEY `date_of_fire` (`date_of_fire`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ;

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

