INSERT INTO request_statuses (id, name) VALUES
	(1, 'Pending'),
	(2, 'Declined'),
	(3, 'Approved'),
	(4, 'Authorised'),
	(5, 'Rejected'),
	(6, 'Ordered'),
	(7, 'Delivered'),
	(8, 'Incomplete'),
	(9, 'Processing'),
	(10, 'Complete');

INSERT INTO request_types (id, name, code) VALUES
	(1, 'Mobile Phone', 'mobile'),
	(2, 'GPS', 'gps'),
	(3, 'Broadband Card', 'broadband_card'),
	(4, 'Tablet / Mount', 'tablet'),
	(5, 'iPad', 'ipad');

INSERT INTO divisions (id, name, code) VALUES
	(1, 'DO&R', 'DO&R'),
	(2, 'Transmission & System Operations', 'TSO'),
	(3, 'SP&R', 'SP&R'),
	(4, 'Shared Services', 'SS'),
	(5, 'Retail', 'RT'),
	(6, 'Finance & Corporate', 'FNC'),
	(7, 'Office of the MD', 'OMD'),
	(8, 'Human Resources', 'HR');

INSERT INTO gps_request_types (id, name) VALUES
	(1, 'New'),
	(2, 'Replacement');

INSERT INTO gps_screens (id, screen_size) VALUES
	(1, 3.5),
	(2, 4.3);

INSERT INTO broadband_card_request_types (id, name) VALUES
	(1, 'New'),
	(2, 'Replacement');

INSERT INTO broadband_card_data_packages (id, gigabytes, cost) VALUES
	(1, 1, 39.00),
	(2, 4, 49.00),
	(3, 7, 69.00);

INSERT INTO mobile_devices (id, name, code) VALUES
	(1, 'Nokia C5', 'nokia_c5'),
	(2, 'Nokia E72', 'nokia_e72'),
	(3, 'Apple iPhone', 'apple_iphone'),
	(4, 'No Phone - Services Only', 'services'),
	(5, 'No Phone - Accessories Only', 'accessories');

INSERT INTO mobile_request_types (id, name, code) VALUES
	(1, 'New Device - New mobile number', 'new_new_number'),
	(2, 'Replacement Device - Faulty/Lost/Stolen/Damaged', 'replacement'),
	(3, 'New Device - Use Existing Mobile Number', 'new_existing_number'),
	(4, 'Bulk Order', 'bulk');

INSERT INTO mobile_services (id, name, code) VALUES
	(1, 'MMS - 50c/image, 75c/video', 'mms'),
	(2, 'Voice to text - extra $10/mo', 'vtt'),
	(3, 'Data plan', 'data'),
	(4, 'SIM Card', 'sim');

INSERT INTO mobile_data_plans (id, data_gb, extra_cost) VALUES
	(1, 1, 10.95),
	(2, 2, 19.95),
	(3, 3, 29.95),
	(4, 7, 49.95);

INSERT INTO mobile_accessories (id, device_id, name) VALUES
	(1, 1, 'Car Charger'),
	(2, 1, 'Portable Bluetooth Car Kit $99'),
	(3, 1, 'Life Style Kit (Car Charger, Case and Earphones)'),
	(4, 2, 'Car Charger'),
	(5, 3, 'Case'),
	(6, 3, 'Charging Kit');

INSERT INTO mobile_replacement_reasons (id, name, code) VALUES
	(1, 'Faulty / Damaged', 'damaged'),
	(2, 'Lost / Stolen', 'lost');

INSERT INTO mobile_carriers (id, name, code) VALUES
	(1, 'Optus', 'optus'),
	(2, 'Vodafone', 'vodafone');

INSERT INTO tablet_request_types (id, name, code) VALUES
	(1, 'Tablet', 'tablet'),
	(2, 'Vehicle Mount', 'mount'),
	(3, 'Accessories', 'accessories'),
	(4, 'Services', 'services');

INSERT INTO tablet_services_service_types (id, name, code) VALUES
	(1, 'Documents', 'documents'),
	(2, 'Training', 'training'),
	(3, 'Tablet Suggestions/Enhancements', 'suggestions'),
	(4, 'Report Other Issues', 'issues');

INSERT INTO tablet_tablet_additional_items (id, name, code) VALUES
	(1, 'Vehicle charge mount', 'charge_mount'),
	(2, 'Portable pack', 'portable_pack');

INSERT INTO tablet_tablet_request_types (id, name, code) VALUES
	(1, 'New', 'new'),
	(2, 'Replacement', 'replacement');

INSERT INTO tablet_tablet_replacement_reasons (id, name, code) VALUES
	(1, 'Faulty', 'faulty'),
	(2, 'Damaged', 'damaged'),
	(3, 'Lost', 'lost'),
	(4, 'Stolen', 'stolen');

INSERT INTO tablet_mount_request_reasons (id, name, code) VALUES
	(1, 'Faulty', 'faulty'),
	(2, 'Damaged', 'damaged'),
	(3, 'Transfer between vehicles', 'transfer_vehicle'),
	(4, 'New vehicle mount (share tablet with another vehicle)', 'new_vehicle');

INSERT INTO tablet_accessory_accessories (id, name, code) VALUES
	(1, 'Stylus', 'stylus'),
	(2, 'Screen Cloth', 'screen_cloth'),
	(3, 'Hand Strap', 'hand_strap'),
	(4, 'Screen Protector', 'screen_protect'),
	(5, 'Laptop Bag', 'laptop_bag'),
	(6, 'Car Charger', 'car_charger'),
	(7, 'Desktop Charger', 'desktop_charger');

INSERT INTO ipad_request_types (id, name, code) VALUES
	(1, 'New Device', 'new'),
	(2, 'Replacement Device', 'replacement');

INSERT INTO ipad_replacement_reasons (id, name, code) VALUES
	(1, 'Faulty / Damaged', 'damaged'),
	(2, 'Lost / Stolen', 'lost');

INSERT INTO ipad_accessories (id, name, code) VALUES
	(1, 'Spare power adapter', 'power_adapter'),
	(2, 'Case', 'case');

INSERT INTO request_history_types (id, name, code) VALUES
	(1, 'Comment', 'comment'),
	(2, 'Status Change', 'status_change');