1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82
|
CREATE TABLE Client (
N_Client INT (4),
Nom_Client VARCHAR (12)
);
INSERT INTO Client VALUES (1, 'TOTO');
INSERT INTO Client VALUES (2, 'TATA');
INSERT INTO Client VALUES (3, 'TITI');
CREATE TABLE Affaire (
N_Affaire INT (4),
N_Client INT (4),
Champ1 varchar (11)
);
INSERT INTO Affaire VALUES (1, 1, 'Affaire 1');
INSERT INTO Affaire VALUES (2, 1, 'Affaire 2');
INSERT INTO Affaire VALUES (3, 1, 'Affaire 3');
INSERT INTO Affaire VALUES (4, 2, 'Affaire 4');
INSERT INTO Affaire VALUES (5, 2, 'Affaire 5');
INSERT INTO Affaire VALUES (6, 2, 'Affaire 6');
INSERT INTO Affaire VALUES (7, 3, 'Affaire 7');
INSERT INTO Affaire VALUES (8, 3, 'Affaire 8');
INSERT INTO Affaire VALUES (9, 3, 'Affaire 9');
CREATE TABLE Commande (
N_Affaire INT (4),
N_Commande INT (4)
);
INSERT INTO Commande VALUES (1, 1);
INSERT INTO Commande VALUES (2, 2);
INSERT INTO Commande VALUES (3, 3);
INSERT INTO Commande VALUES (4, 4);
INSERT INTO Commande VALUES (5, 5);
INSERT INTO Commande VALUES (6, 6);
INSERT INTO Commande VALUES (7, 7);
INSERT INTO Commande VALUES (8, 8);
INSERT INTO Commande VALUES (9, 9);
CREATE TABLE Ligne_Commande (
N_lig_Commande INT (4),
N_Commande INT (4),
Facture varchar (4),
DateFact datetime,
Montant_Euro numeric (8,2)
);
INSERT INTO Ligne_Commande VALUES (1, 1, 'Oui', '01/01/2006', 100,00);
INSERT INTO Ligne_Commande VALUES (2, 1, 'Non', '01/01/2007', 110,00);
INSERT INTO Ligne_Commande VALUES (3, 1, 'Non', '01/01/2008', 120,00);
INSERT INTO Ligne_Commande VALUES (4, 1, 'Non', '01/01/2009', 130,00);
INSERT INTO Ligne_Commande VALUES (5, 2, 'Oui', '01/01/2005', 140,00);
INSERT INTO Ligne_Commande VALUES (6, 2, 'Oui', '01/01/2006', 150,00);
INSERT INTO Ligne_Commande VALUES (7, 2, 'Non', '01/01/2007', 160,00);
INSERT INTO Ligne_Commande VALUES (8, 2, 'Non', '01/01/2008', 110,00);
INSERT INTO Ligne_Commande VALUES (9, 3, 'Non', '01/01/2006', 120,00);
INSERT INTO Ligne_Commande VALUES (10, 3, 'Non', '01/01/2007', 130,00);
INSERT INTO Ligne_Commande VALUES (11, 3, 'Non', '01/01/2008', 140,00);
INSERT INTO Ligne_Commande VALUES (12, 3, 'Non', '01/01/2009', 100,00);
INSERT INTO Ligne_Commande VALUES (13, 4, 'Oui', '01/01/2005', 110,00);
INSERT INTO Ligne_Commande VALUES (14, 4, 'Non', '01/01/2006', 130,00);
INSERT INTO Ligne_Commande VALUES (15, 4, 'Non', '01/01/2007', 120,00);
INSERT INTO Ligne_Commande VALUES (16, 4, 'Non', '01/01/2008', 130,00);
INSERT INTO Ligne_Commande VALUES (17, 5, 'Oui', '01/01/2006', 110,00);
INSERT INTO Ligne_Commande VALUES (18, 5, 'Non', '01/01/2007', 110,00);
INSERT INTO Ligne_Commande VALUES (19, 5, 'Non', '01/01/2008', 140,00);
INSERT INTO Ligne_Commande VALUES (20, 5, 'Non', '01/01/2008', 140,00);
INSERT INTO Ligne_Commande VALUES (21, 6, 'Oui', '01/01/2004', 150,00);
INSERT INTO Ligne_Commande VALUES (22, 6, 'Non', '01/01/2005', 160,00);
INSERT INTO Ligne_Commande VALUES (23, 6, 'Non', '01/01/2006', 170,00);
INSERT INTO Ligne_Commande VALUES (24, 6, 'Non', '01/01/2007', 110,00);
INSERT INTO Ligne_Commande VALUES (25, 7, 'Oui', '01/01/2006', 120,00);
INSERT INTO Ligne_Commande VALUES (26, 7, 'Non', '01/01/2007', 130,00);
INSERT INTO Ligne_Commande VALUES (27, 7, 'Non', '01/01/2008', 140,00);
INSERT INTO Ligne_Commande VALUES (28, 7, 'Non', '01/01/2009', 150,00);
INSERT INTO Ligne_Commande VALUES (29, 8, 'Oui', '01/01/2004', 140,00);
INSERT INTO Ligne_Commande VALUES (30, 8, 'Oui', '01/01/2005', 150,00);
INSERT INTO Ligne_Commande VALUES (31, 8, 'Non', '01/01/2006', 160,00);
INSERT INTO Ligne_Commande VALUES (32, 8, 'Non', '01/01/2007', 170,00);
INSERT INTO Ligne_Commande VALUES (33, 9, 'Oui', '01/01/2005', 180,00);
INSERT INTO Ligne_Commande VALUES (34, 9, 'Oui', '01/01/2006', 190,00);
INSERT INTO Ligne_Commande VALUES (35, 9, 'Non', '01/01/2007', 100,00);
INSERT INTO Ligne_Commande VALUES (36, 9, 'Non', '01/01/2008', 100,00);
COMMIT; |
Partager