INSERT INTO regions (id, name) VALUES
	(1, 'Central'),
	(2, 'South'),
	(3, 'Central Coast'),
	(4, 'Newcastle');

INSERT INTO rostered_shift_categories (id, code, name) VALUES
	(1, 'day', 'Day'),
	(2, 'afternoon', 'Afternoon'),
	(3, 'night', 'Night');

INSERT INTO rostered_shifts (id, category_id, start_time, end_time) VALUES
	(1, 1, '06:00', '14:00'),
	(2, 1, '07:00', '17:00'),
	(3, 2, '14:00', '22:00'),
	(4, 2, '15:00', '23:00'),
	(5, 3, '22:00', '06:00'),
	(6, 3, '23:00', '07:00');

INSERT INTO asset_groups (id, code, name) VALUES
	(1, 'PW', 'Planned Work'),
	(2, 'SBT',  'Standby Time'),
	(3, 'DS', 'Distribution Subs'),
	(4, 'ZS', 'Zone Substations'),
	(5, 'TS', 'Subtrans Substations'),
	(6, 'UT', 'Subtrans UG Mains'),
	(7, 'OT', 'Subtrans OH Mains'),
	(8, 'DO', 'Distribution OH Mains'),
	(9, 'DU', 'Distribution UG Mains'),
	(10, 'SL', 'Street Lighting'),
	(11, 'NPT', 'Non-Productive Time'),
	(12, 'PIO', 'Proj / Int Order #'),
	(13, 'DEP', 'Damage by Ext Parties'),
	(14, 'TRN', 'Training'),
	(15, 'OTH', 'Other');

INSERT INTO job_types (id, code, name, requires_details) VALUES
	(1, 'breakdown', 'Breakdown', 0),
	(2, 'nature_induced', 'Nature Induced', 0),
	(3, 'other', 'Other', 1);

INSERT INTO entry_statuses (id, code, name) VALUES
	(1, 'pending', 'Pending'),
	(2, 'completed', 'Completed'),
	(3, 'rejected', 'Rejected');

INSERT INTO trainees (service_number, first_name, last_name) VALUES
	(47660, 'Chong', 'Ding'),
	(46897, 'Murray', 'Roach'),
	(49623, 'Phillip', 'Holden'),
	(46683, 'Tim', 'Holman'),
	(47852, 'Scott', 'Stanborough'),
	(48151, 'Mark', 'Buskens'),
	(48154, 'Tim', 'Carney'),
	(48411, 'Luke', 'Weatherstone'),
	(48165, 'Scott', 'Miller'),
	(49628, 'Aaron', 'Mote'),
	(49815, 'Nigel', 'Lasheras'),
	(42113, 'Craig', 'Birkbeck'),
	(44797, 'Casey', 'Dabovic'),
	(46180, 'Jason', 'Bridge'),
	(47570, 'Andrew', 'Dally'),
	(43812, 'Sean', 'Fitzpatrick'),
	(48737, 'John', 'Bennis'),
	(47265, 'James', 'Huby'),
	(47605, 'Aaron', 'Mills');
