INSERT INTO si_fault_types (name) VALUES
	('Fault Type 1'), ('Fault Type 2'), ('Fault Type 3');

INSERT INTO si_inspection_components (name) VALUES
	('Component 1'), ('Component 2'), ('Component 3');

INSERT INTO si_maintenance_categories (name) VALUES
	('Maintenance Category 1'), ('Maintenance Category 2'), ('Maintenance Category 3');

INSERT INTO si_locations (name, street_addr, suburb) VALUES
	('Example 1', '555 Some Street', 'Syndey'),
	('Example 2', '555 Other Street', 'Sadleir'),
	('Example 3', '555 Yet Another Street', 'Lane Cove');

INSERT INTO si_inspections (username, pmis, location_id, when_date, when_time) VALUES
	('John Smith', 12345, 1, '2011-3-1', '13:25'),
	('Jane Doe', 23456, 1, '2011-3-4', '9:05'),
	('Mark Jones', 34534, 1, '2011-3-7', '11:22');

INSERT INTO si_inspection_faults (
	inspection_id, maintenance_category_id, fault_type_id,
	component_affected_id, priority, which_building,
	which_floor, which_room, action_status,
	inspector_comment)
VALUES
	(1, 2, 2, 2, 1, 'Building A', 1, 5, 0, 'Some Comment');