INSERT INTO professeur_ville(idVille, ville, population)
VALUES 	(93200, 'SAINT-DENIS', 108000),
		(93430, 'VILLETANEUSE', 12400),
		(93800, 'EPINAY SUR SEINE', 55000);
		
		
INSERT INTO professeur_eleve(idEleve, nom, prenom, dateNaissance, idVille)
VALUES 	(1, 'BELKHODJA',	'Abdelkader',	'1998-06-03',	93800),
		(2, 'BERTHELOT',	'Guirec', 		'1997-12-02',	93800),
		(3, 'CUNHA',		'Anthony',		'1998-09-09', 	93430),
		(4, 'DAHBI',		'Ismael',		'1996-08-28', 	93800),
		(5, 'DARRAR', 		'Mohamed',		'1996-05-26', 	93200),
		(6,	'EL AZZAOUI',	'Younes',		'1998-06-26', 	93800),
		(7, 'HOUBION',		'Mélanie',		'1997-12-23', 	93800),
		(8, 'INTHAVONG',	'Jimmy', 		'1998-04-11', 	93800),
		(9, 'LILIA',		'David',		'1997-10-21', 	93200),
		(10, 'N\'DRI',		'Florian', 		'1997-02-10', 	93800),
		(11, 'PETIT',		'D\'jemes',		'1997-04-21', 	93430),
		(12, 'POFAGI',		'Jenniford',	'1998-05-09', 	93430),
		(13, 'ROGIER',		'Roderick',		'1998-06-08', 	93800),
		(14, 'TURCAN0',		'Dimitri',		'1996-12-13', 	93800),
		(15, 'YÜCE',		'Elif',			'1996-09-21', 	93800);
		

INSERT INTO professeur_smartphone(idSmartphone, marque, modele, taille, os, prix)
VALUES 	(1, 'Apple', 'iPhone6s', 4.7, 'iOS9', 859),
		(2, 'Samsung', 'Galaxy S6 edge +', 5.1, 'Android', 699),
		(3, 'Microsoft', 'Lumia 950 XL', 4.7, 'Windows 10', 699);
		
INSERT INTO professeur_posseder(idEleve, idSmartphone)
VALUES 	(1, 1),
		(2, 1),
		(3, 1),
		(4, 2),
		(5, 3),
		(6, 2),
		(7, 2),
		(8, 1),
		(9, 2),
		(10, 1),
		(11, 3),
		(12, 1),
		(13, 2),
		(14, 2),
		(15, 1);

INSERT INTO professeur_user (idUser, login, password, nomUser, prenomUser)
VALUES	(1, 'admin', 'tsig', 'Admin', 'Admin') ;
