
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

INSERT INTO `requests` (`id`, `uid`, `request_type_id`, `service_number`, `name`, `email_addr`, `cost_centre`, `section_location`, `contact_number`, `delivery_location`, `division_id`, `approver_service_number`, `date_submitted`, `status_id`, `last_altered_date`, `last_altered_by`, `status_reason`) VALUES
	(1, '12Feb001', 1, 47187, 'Field Moe', 'fake@fake.tld', 1234, 'Some Section Location', '0412345678', 'Some Delivery Location', 1, NULL, '2012-02-06 14:22:00', 1, NULL, NULL, NULL),
	(2, '12Feb002', 2, 47187, 'Field Moe', 'fake@fake.tld', 1234, 'Some Location 2', '0412345678', 'Some Delivery Location', 1, NULL, '2012-02-06 14:45:00', 1, NULL, NULL, NULL),
	(3, '12Feb003', 3, 47187, 'Field Moe', 'fake@fake.tld', 1234, 'Some Other Location', '0412345678', 'Some Delivery Location', 1, NULL, '2012-02-06 15:22:00', 1, NULL, NULL, NULL),
	(4, '2012Aug001', 4, NULL, NULL, NULL, 1619, NULL, NULL, NULL, NULL, NULL, '2012-08-14 22:04:47', 1, NULL, NULL, NULL),
	(5, '2012Aug002', 4, NULL, NULL, NULL, 1609, NULL, NULL, NULL, NULL, NULL, '2012-08-14 22:05:21', 1, NULL, NULL, NULL);

INSERT INTO `broadband_card_requests` (`id`, `request_id`, `request_type_id`, `current_number`, `data_id`, `approver_service_number`) VALUES
	(1, 3, 2, '0412345678', 2, 47187);

INSERT INTO `gps_requests` (`id`, `request_id`, `request_type_id`, `screen_id`, `approver_service_number`) VALUES
	(1, 2, 1, 1, 47187);

INSERT INTO `mobile_requests` (`id`, `request_id`, `device_type_id`, `request_type_id`, `data_plan_id`, `current_number`, `current_carrier_id`, `need_nextg_card`, `approver_service_number`) VALUES
	(1, 1, 1, 1, 1, '0412366480', NULL, 0, 47187);

INSERT INTO `mobile_request_accessories` (`mobile_request_id`, `accessory_id`) VALUES
	(1, 1),
	(1, 2);

INSERT INTO `mobile_request_services` (`mobile_request_id`, `service_id`) VALUES
	(1, 1),
	(1, 3);

INSERT INTO `tablet_requests` (`id`, `request_id`, `request_type_id`, `approver_service_number`, `approver_is_acting`) VALUES
	(1, 4, 1, 38050, 0),
	(2, 5, 1, 42357, 0);

INSERT INTO `tablet_tablet_requests` (`id`, `tablet_request_id`, `request_type_id`, `replacement_reason_id`, `police_event_number`, `mount_was_damaged`, `vehicle_fleet_number`, `vehicle_rego_number`, `damage_fault_details`, `replacement_report_id`) VALUES
	(1, 1, 1, NULL, NULL, 0, NULL, NULL, '', NULL),
	(2, 2, 2, 1, NULL, 0, NULL, NULL, 'Something faulty', NULL);

INSERT INTO user_roles (service_number, role_id) VALUES
	(47187, 1), -- superuser
	(44503, 9), -- mobile_admin
	(51264, 13), -- tablet_admin
	(53511, 10); -- mobile_installer
