INSERT INTO person (person_id, first_name, last_name, address, phone, email, photo)   
VALUES
(NULL, 'Bob', 'Bobbison', '32 The Main Street', 4564587, 'bob@bobby.com', NULL),
(NULL, 'Nick', 'Little', '21 Eglinton Road', 4554515, 'nick@flat21.co.nz', NULL),
(NULL, 'Jasmine', 'Smith', '58 Brandon Street', 4487324, 'j_smith@windowslive.com','NULL'),
(NULL, 'Josh', 'Wight', '342 Ferris Road', 4483257, 'wight_01@hotmail.com','NULL'),
(NULL, 'Angus', 'Young', '984 The Glen Road', 4563465, 'ayoung@xtra.co.nz','NULL'),
(NULL, 'Freddy', 'Mercury', '324 The Side Road', 4564415, 'f_m_r@xtra.co.nz','NULL'),
(NULL, 'Bob', 'Marley', '111 Police Road', 4561112, 'bobbie@slingshot.co.nz','NULL'),
(NULL, 'Joe', 'Dirt', '4 Campbell Avenue', 4551033, 'joe.dirt@xtra.co.nz','NULL'),
(NULL, 'Harry', 'Potter', '666 Hogwarts Road', 4512943, 'harrypotter@harryp.com','NULL'),
(NULL, 'Albus', 'Dumbledore', '234 Alley Avenue', 4542465, 'alboy@msn.com','NULL'),
(NULL, 'Severus', 'Snape', '754 Evergreen Terrace', 4232343, 'ssnape@snapemail.com','NULL'),
(NULL, 'Pringles', 'Original', '253 The Tracks', 4543215, 'po@msn.com','NULL'),
(NULL, 'Erica', 'Sweetie', '2 Sideande Avenue', 4532153, 'erica@windowslive.com','NULL'),
(NULL, 'Afghan', 'Biscuit', '53 Elgin Road', 4482921, 'afgan@yahoo.com','NULL'),
(NULL, 'Turbo', 'Little', '21 Eglinton Road', 4554515, 'turbo@aol.com','NULL');

INSERT INTO player (player_ID, dob)
VALUES
('', '16-12-91'),
('', '12/08-92'),
('', '05-12-95'),
('', '02-11-96'),
('', '07-11-92');


INSERT INTO caregiver (caregiver_ID, player_ID)    
VALUES
('6', '1'),  
('7', '2'), 
('8', '3'), 
('9', '4'), 
('10', '5');


INSERT INTO team (team_ID, name, age_range, year)     
VALUES
('', 'The Tigers', 'U7', 'Y9'),
('', 'The Lions', 'U8', 'Y9'),
('', 'The Force', 'U9', 'Y9'),
('', 'The Cheetahs', 'U10', 'Y9'),
('', 'The Bulls', 'U11', 'Y9');



/*INSERT INTO player_team (team_ID, player_ID)
VALUES
('16', '1'),
('17', '2'),
('18', '3'),
('19', '4'),
('20', '5');*/	


INSERT INTO coach (person_ID, years_experience)
VALUES
('', '1'),  
('', '3'), 
('', '2'), 
('', '6'), 
('', '4');

/*
INSERT INTO team_coach (team_ID, person_ID)
		VALUES
		  	('', ''),  
			('', ''), 
			('', ''), 
			('', ''), 
			('', '');


INSERT INTO qualifications (team_ID, person_ID)
		VALUES
		  	('', ''),  
			('', ''), 
			('', ''), 
			('', ''), 
			('', '');

INSERT INTO coach_qualification (person_ID, qualification_ID)
		VALUES
		  	('', ''),  
			('', ''), 
			('', ''), 
			('', ''), 
			('', '');
*/
/*CREATE VIEW phonelist AS (SELECT
p.First_Name AS 'Player First Name', p.Last_Name AS 'Player Last Name', team.Name AS 'Team Name',
p2.First_Name AS 'Guardian First Name', p2.Last_Name AS 'Guardian Last Name', p2.Phone AS 'Guardian Phone No.'
FROM person p JOIN player ON(p.Person_ID=player.Person_ID)
JOIN caregiver ON (caregiver.Person_ID=player.Person_ID)
JOIN person p2 ON (p2.Person_ID=caregiver.Caregiver_ID)
JOIN player pla ON (p.Person_ID=pla.Person_ID)
JOIN player_team ON (player_team.Person_ID=pla.Person_ID)
JOIN team ON (team.Team_ID=player_team.Team_ID));
*/