1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| CREATE TABLE LIGNE_COMMANDE
(
CommandeId INT NOT NULL
, LigneCdeId INT NOT NULL
, ArticleId INT NOT NULL
, Quantite INT NOT NULL
, CONSTRAINT LIGNE_COMMANDE_PK PRIMARY KEY (CommandeId, LigneCdeId)
, CONSTRAINT LIGNE_COMMANDE_COMMANDE_FK FOREIGN KEY (CommandeId)
REFERENCES COMMANDE ON DELETE CASCADE
, CONSTRAINT LIGNE_COMMANDE_ARTICLE_FK FOREIGN KEY (ArticleId)
REFERENCES ARTICLE
) ;
INSERT INTO LIGNE_COMMANDE (CommandeId, LigneCdeId, ArticleId, Quantite) VALUES (1, 1, 1, 10) ;
INSERT INTO LIGNE_COMMANDE (CommandeId, LigneCdeId, ArticleId, Quantite) VALUES (3, 1, 1, 3) ;
INSERT INTO LIGNE_COMMANDE (CommandeId, LigneCdeId, ArticleId, Quantite) VALUES (3, 2, 5, 4) ;
INSERT INTO LIGNE_COMMANDE (CommandeId, LigneCdeId, ArticleId, Quantite) VALUES (6, 1, 3, 2) ;
INSERT INTO LIGNE_COMMANDE (CommandeId, LigneCdeId, ArticleId, Quantite) VALUES (7, 1, 6, 10) ;
INSERT INTO LIGNE_COMMANDE (CommandeId, LigneCdeId, ArticleId, Quantite) VALUES (8, 1, 6, 4) ; -- Le trigger doit réagir !
SELECT '' AS 'LIGNE_COMMANDE', * FROM LIGNE_COMMANDE ; |
Partager