
INSERT INTO fjs_off_road_reasons (name) VALUES
	('Scheduled Service'),
	('Electrical Test'),
	('Mechanical Repair'),
	('Accident Repair'),
	('Modification');

INSERT INTO fjs_work_order_statuses (name) VALUES
	('Booked'),
	('In Progress'),
	('Completed'),
	('Finalised'),
	('No Show');

INSERT INTO fjs_garages (name) VALUES
	('Chatswood'),
	('Dee Why'),
	('Homebush'),
	('Hornsby'),
	('Maitland'),
	('Muswellbrook'),
	('Noraville'),
	('Oatley'),
	('Singleton'),
	('Wallsend'),
	('West Gosford'),
	('Zetland'),
	('Contractor');

INSERT INTO fjs_fgo_classifications	(name) VALUES
	('EWP Plant & Trucks'),
	('Borer Plant & Trucks'),
	('Cable equipment plant & trucks'),
	('Other trucks'),
	('Light commercials'),
	('Minor Plant');

INSERT INTO fjs_fgo_classification_map (type_level1, classification_id) VALUES
	('PANEL VANS & UTILITIES', 5),
	('TRUCKS', 4),
	('TRAILERS', 6),
	('ELEVATING PLATFORM VEHICLE MOUNTED', 1),
	('ELEVATING PLATFORM VEHICLES', 1),
	('STATION WAGONS', 5),
	('VLC (Cranes)', 4),
	('FORKLIFTS', 6),
	('SPECIALS', 4),
	('FEL/BH', 6),
	('PHB/PE VEHICLE MOUNTED', 2),
	('PHB/PE VEHICLES', 2),
	('CABLE DRUM TRAILERS', 3),
	('CABLE TENSIONING EQUIPMENT', 3),
	('MISCELLANEOUS PLANT', 6),
	('AIR COMPRESSORS', 6),
	('ARTICULATED TRAILERS', 4),
	('WINCHES', 3),
	('GENERATING SETS', 6),
	('CARAVANS', 6),
	('DRILL RIG VEHICLE MOUNTED', 6),
	('SEDANS', 5),
	('MG SET VEHICLES', 4),
	('CRANES', 6),
	('WIRE WINDERS', 3),
	('TRECH DIGGER', 6),
	('WOOD CHIPPING UNIT', 6),
	('LIGHT COMMERCIAL CAB/CHASSIS',  '5');

INSERT INTO fjs_figfleet_statuses (name, acronym) VALUES
	('Current', 'C'),
	('Disposed', 'D'),
	('Outstanding', 'O');
