   KEY `unit` (`unit`),
   KEY `date_of_fire` (`date_of_fire`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ;
-
---
--- Dumping data for table `fire_data`
---
-
-INSERT INTO `fire_data` (`id`, `date_of_fire`, `location`, `classification`, `caller`, `contact_number`, `time_received`, `time_controlled`, `unit`, `oic`, `water_used`, `dispatch`, `proceeding`, `at_base`) VALUES
-(27, '2017-05-15', 'Golden Valley', 'Working Fire', 'direct', '', '09:03 AM', '10:12 AM', 'michelle', 94, 0, 'Yes', '09,45', '92,93,');
 
 -- --------------------------------------------------------
 

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `training_attendance`
--

INSERT INTO `training_attendance` (`training_id`, `unit`, `attendance_date`) VALUES
(6, '90', '2017-05-14'),
(6, '92', '2017-05-14'),
(6, '94', '2017-05-14'),
(6, '95', '2017-05-14'),
(6, '96', '2017-05-14'),
(6, '30', '2017-05-14'),
(7, '50', '2017-05-07'),
(7, '13', '2017-05-07'),
(7, '45', '2017-05-07'),
(8, '50', '2017-04-23'),
(8, '13', '2017-04-23'),
(8, '45', '2017-04-23'),
(9, '50', '2017-02-12'),
(9, '13', '2017-02-12'),
(9, '45', '2017-02-12'),
(10, '50', '2017-01-15'),
(10, '13', '2017-01-15'),
(10, '45', '2017-01-15'),
(10, '55', '2017-01-15'),
(10, '72', '2017-01-15');

--
-- Constraints for dumped tables
--


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

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

