---insertionssssss
insert into Clients(nom, prenom,typeClient, adresse) values 
('Patoche','Alain','v','14 rue Jupiter, Montréal'),
('LeRoy','Singe','v','11 avenue de la Lune, Laval'),
('LeRigolo','Coluche','r','177 rue de Venus, Montréal'),
('Lefou','Ducoin','o','12 rue de Saturne Laval');
insert into clients values('Le magnifique','Simba','r','789 rue des Chats, Laval');
insert into clients values('Ce client','prenom','r','789 rue des clients, Montréal');

--
insert into Articles(descriptions, prix, quantitestock) values
('Imprimantes Laser HP 8000',700,20),
('Écrans tactiles 19p',550,45),
('Routeurs sans fils Azus',200,75),
('Disques durs SSD 500 Go',175,45);

insert into Articles(descriptions, prix, quantitestock) values ('Chaises de bureau',400,20);
insert into Articles(descriptions, prix, quantitestock) values ('Cet Article',400,5);
insert into Articles(descriptions, prix, quantitestock) values ('Mon article',100,10);

---

INSERT INTO Commandes(datecommande,idClient) values('2023-08-21',1);
INSERT INTO Commandes(datecommande,idClient) values('2023-08-28',1);
INSERT INTO Commandes(datecommande,idClient) values('2022-12-05',1);
INSERT INTO Commandes(datecommande,idClient) values('2022-11-17',2);
INSERT INTO Commandes(datecommande,idClient) values('2022-09-12',2);
INSERT INTO Commandes(datecommande,idClient) values('2023-08-12',3);
----------------------------------------

--commande numéro 10
insert into Lignecommande values(10,1,2);
insert into Lignecommande values(10,2,3);
insert into Lignecommande values(10,3,5);
insert into Lignecommande values(10,4,6);
--commande 11
insert into Lignecommande  values(11,4,2);
insert into Lignecommande  values(11,3,3);

--commnande 12
insert into Lignecommande  values(12,3,5);

---commande numéro 13
insert into Lignecommande  values(13,1,1);
insert into Lignecommande values(13,2,5);
insert into Lignecommande  values(13,3,6);
--commnade14
insert into Lignecommande  values(14,3,1);
insert into Lignecommande  values(14,4,1);

--commande 15
insert into Lignecommande  values(15,3,1);