-- insert test data
INSERT INTO `facility2` (`ID`, `Facility`, `prefecture_id`, `address_1`, `address_2`, `address_3`, `longitude`, `latitude`)
VALUES (1, 'having0',  27, 'osaka', '', '', 135.466589, 34.824418)
;
INSERT INTO `facility2` (`ID`, `Facility`, `prefecture_id`, `address_1`, `address_2`, `address_3`, `longitude`, `latitude`)
VALUES (2, 'having1', 27, 'osaka', '', '', 135.466589, 34.824418)
;
INSERT INTO `facility2_damages` (`ID`, `Facility_ID`, `damage_type`, `comment`, `contact`, `regist_date`, `update_date`)
VALUES (1, 2, 4, 'this is latest.', 'contact1@example.com', '2019-03-05 00:00:00', '2019-03-06 00:00:00')
;
INSERT INTO `facility2` (`ID`, `Facility`, `prefecture_id`, `address_1`, `address_2`, `address_3`, `longitude`, `latitude`)
VALUES (3, 'having2', 27, 'osaka', '', '', 135.466589, 34.824418)
;
INSERT INTO `facility2_damages` (`ID`, `Facility_ID`, `damage_type`, `comment`, `contact`, `regist_date`, `update_date`)
VALUES (2, 3, 4, 'this is not latest.', 'contact2@example.com', '2019-03-05 00:00:00', '2019-03-06 00:00:00')
;
INSERT INTO `facility2_damages` (`ID`, `Facility_ID`, `damage_type`, `comment`, `contact`, `regist_date`, `update_date`)
VALUES (3, 3, 4, 'this is latest2.', 'contact3@example.com', '2019-03-06 00:00:00', '2019-03-05 00:00:00')
;

