INSERT INTO `requests` (`id`, `serial_number`, `service_number`, `full_name`, `sheet_date`, `section`, `cost_centre`, `rostered_shift_id`, `manager_service_number`, `date_submitted`, `last_altered_by`) VALUES
	(1, 0, 39887, 'Peter Terry', '2012-10-09', 'Business Systems Development', 2101, 1, 43880, '2012-10-15 00:24:41', NULL),
	(2, 0, 39887, 'Peter Terry', '2012-10-10', 'Business Systems Development', 2101, 1, 43880, '2012-10-15 00:25:52', NULL),
	(3, 0, 39887, 'Peter Terry', '2012-10-11', 'Business Systems Development', 2101, 1, 43880, '2012-10-15 00:27:06', NULL),
	(4, 0, 39887, 'Peter Terry', '2012-10-17', 'Business Systems Development', 2101, 1, 43880, '2012-10-17 19:37:17', NULL);


INSERT INTO `job_entries` (`id`, `request_id`, `serial_number`, `region_id`, `asset_group_id`, `job_type_id`, `job_type_details`, `job_number`, `start_time`, `end_time`, `trainee_service_number`, `trainee_full_name`, `comments`, `status_id`) VALUES
	(1, 1, 1, 1, 2, NULL, NULL, NULL, '06:00:00', '07:00:00', NULL, NULL, '', 2),
	(2, 1, 2, 1, 1, NULL, NULL, 123456789123, '07:00:00', '08:00:00', NULL, NULL, 'comments', 2),
	(3, 1, 3, 2, 15, 3, 'some comment', NULL, '08:00:00', '09:00:00', 39887, 'Peter Terry', 'comments here', 3),
	(4, 2, 1, 1, 2, NULL, NULL, NULL, '06:00:00', '07:00:00', NULL, NULL, '', 1),
	(5, 2, 2, 1, 1, NULL, NULL, 123456789123, '07:00:00', '08:00:00', NULL, NULL, 'comments', 1),
	(6, 2, 3, 2, 15, 3, 'some comment', NULL, '08:00:00', '09:00:00', 39887, 'Peter Terry', 'comments here', 1),
	(7, 3, 1, 1, 2, NULL, NULL, NULL, '06:00:00', '07:00:00', NULL, NULL, '', 1),
	(8, 3, 2, 1, 1, NULL, NULL, 123456789123, '07:00:00', '08:00:00', NULL, NULL, 'comments', 1),
	(9, 3, 3, 2, 15, 3, 'some comment', NULL, '08:00:00', '09:00:00', 39887, 'Peter Terry', 'comments here', 1),
	(10, 4, 1, 1, 1, NULL, NULL, 112345678912, '05:00:00', '05:30:00', NULL, NULL, 'Over time example', 1),
	(11, 4, 2, 1, 3, 1, NULL, NULL, '05:30:00', '06:15:00', NULL, NULL, 'Over time example', 1),
	(12, 4, 3, 1, 2, NULL, NULL, NULL, '08:00:00', '09:00:00', NULL, NULL, 'Over time example', 1),
	(13, 4, 4, 1, 4, 2, NULL, NULL, '01:30:00', '02:30:00', NULL, NULL, 'Over time example', 1),
	(14, 4, 5, 1, 5, 2, NULL, NULL, '03:00:00', '03:30:00', NULL, NULL, 'Over time example', 1);

INSERT INTO user_roles (service_number, role_id) VALUES
	(47187, 1),
	(47187, 2);
