Use location;
INSERT INTO client(codeclient,nom,prenom,codpost, ville) 
VALUES (1,'Martin','Jean',  33000,  'Bordeaux'),
(2,'Lopez','Michel',86000,'Poitiers'),
(3,'Martinez','Marie',86000,'Poitiers'),
(4,'Durand','Chantal',86200,'Loudun'),
(5,'Mendes','Louis',86200,'Loudun'),
(6,'Bousquet','Zoe',86200,'Loudun'),
(7,'Tillon','Stephane',69000,'Lyon'),
(8,'Leroy','Didier',65000,'Tarbes');

insert into categorie(codecat,prix) 
values ('SKF1',5),
('SKF2',5.5),
('SKF3',6),
('SKF4',6.5),
('SKF5',7),
('SKP1',7),
('SKP2',9.5),
('SKP3',10),
('SKP4',12.5),
('SKP5',15),
('SNB1',8),
('SNB2',9.5),
('SNB3',10.5),
('SNB4',14.5),
('SNB5',16),
('CHF1',2.5),
('CHF2',3),
('CHP1',4.5),
('CHP2',6),
('CHS1',5),
('CHS2',8),
('RQ1',9),
('RQ2',13);

insert into fiche(codefiche,datecreation,datefin,modereg,codeclient)
values(1,'2019-12-15','2019-12-21','CHQ',1),
(2,'2019-12-15','2019-12-21','CHQ',2),
(3,'2019-12-15','2019-12-21','CB',3),
(4,'2019-12-15','2019-12-21','CHQ',4),
(5,'2019-12-22','2019-12-28','CHQ',1),
(6,'2019-12-22','2019-12-28','CB',5),
(7,'2019-12-22','2019-12-28','CB',6);

insert into fiche(codefiche,datecreation,datefin,modereg,codeclient)
values(8,'2019-01-01','2019-01-03','CB',7),
(9,'2019-12-28','2019-01-13','CHQ',1);

insert into article(codeart, libelle,codecat)
values(1,'ski de fond de base','SKF1 '),
(2,'ski de fond de base','SKF1 '),
(3,'ski de piste de base','SKP1 '),
(4,'ski de piste parabolique','SKP2 '),
(5,'ski de piste','SKP2 '),
(6,'chaussure fond 42','CHF1 '),
(7,'chaussure piste 38','CHP1 '),
(8,'Chaussure piste 40','CHP1 '),
(9,'ski piste neuf','SKP5 '),
(10,'snow basique ','SNB1 '),
(11,'chaussure snow ','CHS1 '),
(12,'ski de fond de base','SKF1 '),
(13,'ski de fond de base','SKF1 '),
(14,'ski de piste de base','SKP1 '),
(15,'ski de piste parabolique','SKP2 '),
(16,'ski de piste','SKP2 '),
(17,'chaussure fond 42','CHF1 '),
(18,'chaussure piste 38','CHP1 '),
(19,'Chaussure piste 40','CHP1 '),
(20,'ski piste neuf','SKP5 '),
(21,'snow basique ','SNB1 '),
(22,'chaussure snow ','CHS1 ');

insert into lignesfic(codefiche,codeart, nbjour)
values(1,1,7),
(1,7,7),
(1,14,7),
(1,19,7),
(2,2,7),
(2,6,7),
(3,10,7),
(3,11,7),
(4,9,7),
(4,8,7),
(5,1,7),
(5,7,7),
(5,14,7),
(5,19,7),
(6,5,7),
(7,21,7),
(8,20,3),
(9,1,2),
(9,7,2);