INSERT INTO client(nom, solde)
	VALUES ('Marc', 10), ('Manuelle', 2),
	('Nour', 5), ('Jean', 6), ('Frank', 3) ;
INSERT INTO ligne(id_client, numero, tarif)
	VALUES (1, '0201020304', 0.03),
	(1, '0290546810', 0.03),
	(1, '0245986752', 0.04),
	(2, '0509080706', 0.05),
	(2, '0568794520', 0.03),
	(3, '0564823791', 0.05),
	(4, '0105816008', 0.01),
	(4, '0100659002', 0.06),
	(5, '0246875920', 0.02),
	(5, '0251469800', 0.02) ;
INSERT INTO appel(id_ligne_appelant, id_ligne_appele, debut, fin)
	VALUES (1, 2, '2015-03-6 13:50', '2015-03-6 13:58'),
	(1, 5, '2015-03-6 22:11', '2015-03-6 22:36'),
	(1, 8, '2015-03-7 09:56', '2015-03-7 09:58'),
	(2, 1, '2015-03-6 11:03', '2015-03-6 11:04'),
	(2, 1, '2015-03-7 09:06', '2015-03-7 09:20'),
	(2, 10, '2015-03-7 10:00', '2015-03-7 10:06'),
	(3, 5, '2015-03-6 15:20', '2015-03-6 15:22'),
	(3, 4, '2015-03-6 15:33', '2015-03-6 15:39'),
	(3, 1, '2015-03-7 22:08', '2015-03-7 22:31'),
	(4, 9, '2015-03-6 02:40', '2015-03-6 02:59'),
	(4, 2, '2015-03-6 05:27', '2015-03-6 05:30'),
	(4, 3, '2015-03-7 04:45', '2015-03-7 04:52'),
	(5, 4, '2015-03-7 12:01', '2015-03-7 12:43'),
	(5, 10, '2015-03-7 15:32', '2015-03-7 15:37'),
	(5, 8, '2015-03-7 16:02', '2015-03-7 17:10'),
	(6, 1, '2015-03-6 03:21', '2015-03-6 03:26'),
	(6, 2, '2015-03-6 23:59', '2015-03-7 00:11'),
	(6, 5, '2015-03-7 00:46', '2015-03-7 01:01'),
	(7, 8, '2015-03-6 10:10', '2015-03-6 10:12'),
	(7, 9, '2015-03-6 15:50', '2015-03-6 15:57'),
	(7, 10, '2015-03-6 17:03', '2015-03-6 17:30'),
	(8, 2, '2015-03-6 12:02', '2015-03-6 12:45'),
	(8, 7, '2015-03-6 17:22', '2015-03-6 18:00'),
	(8, 6, '2015-03-7 14:05', '2015-03-7 14:09'),
	(9, 8, '2015-03-7 11:01', '2015-03-7 11:02'),
	(9, 2, '2015-03-7 11:20', '2015-03-7 11:42'),
	(9, 4, '2015-03-7 15:05', '2015-03-7 15:12'),
	(10, 4, '2015-03-6 02:23', '2015-03-6 02:56'),
	(10, 5, '2015-03-6 08:20', '2015-03-6 08:25'),
	(10, 1, '2015-03-7 22:30', '2015-03-7 22:46') ;
