INSERT INTO CLIENT (id_client, Clientnom) VALUES (1, 'Ets Naudin') ;
INSERT INTO CLIENT (id_client, Clientnom) VALUES (2, 'Volfoni SA') ;
INSERT INTO CLIENT (id_client, Clientnom) VALUES (3, 'Dubicobit') ;
SELECT *, '' AS '<= CLIENT' FROM CLIENT ;
INSERT INTO TACHE (id_tache, TacheNom) VALUES (1, 'tâche 1') ;
INSERT INTO TACHE (id_tache, TacheNom) VALUES (2, 'tâche 2') ;
INSERT INTO TACHE (id_tache, TacheNom) VALUES (3, 'tâche 3') ;
INSERT INTO TACHE (id_tache, TacheNom) VALUES (4, 'tâche 4') ;
SELECT *, '' AS '<= TACHE' FROM TACHE ;
INSERT INTO PROJET (id_client, id_projet, id_tache, Reference, LangueSource) VALUES (1, 1, 1, 'réf 1 Naudin', 'provençal') ;
INSERT INTO PROJET (id_client, id_projet, id_tache, Reference, LangueSource) VALUES (1, 2, 1, 'réf 2 Naudin', 'chitimi') ;
INSERT INTO PROJET (id_client, id_projet, id_tache, Reference, LangueSource) VALUES (1, 3, 1, 'réf 2 Naudin', 'gallois') ;
INSERT INTO PROJET (id_client, id_projet, id_tache, Reference, LangueSource) VALUES (2, 1, 1, 'réf 1 de Volfoni', 'javanais') ;
INSERT INTO PROJET (id_client, id_projet, id_tache, Reference, LangueSource) VALUES (2, 2, 1, 'réf 2 de Volfoni', 'quebecois') ;
INSERT INTO PROJET (id_client, id_projet, id_tache, Reference, LangueSource) VALUES (2, 3, 1, 'réf 3 de Volfoni', 'breton') ;
INSERT INTO PROJET (id_client, id_projet, id_tache, Reference, LangueSource) VALUES (3, 1, 2, 'réf 1 de Dubicobit', 'basque') ;
SELECT *, '' AS '<= PROJET' FROM PROJET ;
-- --------------------------------------------------------------------------------------
INSERT INTO FACTURE (id_client, id_facture, num_facture, date_facture) VALUES (1, 1, 123456789, '2015_01_26') ;
INSERT INTO FACTURE (id_client, id_facture, num_facture, date_facture) VALUES (1, 2, 145320147, '2015_01_26') ;
INSERT INTO FACTURE (id_client, id_facture, num_facture, date_facture) VALUES (1, 3, 158500036, '2015_01_27') ;
INSERT INTO FACTURE (id_client, id_facture, num_facture, date_facture) VALUES (2, 1, 247820143, '2015_01_26') ;
INSERT INTO FACTURE (id_client, id_facture, num_facture, date_facture) VALUES (2, 2, 257896022, '2015_01_27') ;
INSERT INTO FACTURE (id_client, id_facture, num_facture, date_facture) VALUES (2, 3, 281478943, '2015_01_28') ;
INSERT INTO FACTURE (id_client, id_facture, num_facture, date_facture) VALUES (2, 4, 291475478, '2015_01_29') ;
INSERT INTO FACTURE (id_client, id_facture, num_facture, date_facture) VALUES (3, 1, 347820143, '2015_01_19') ;
SELECT *, '' AS '<= FACTURE' FROM FACTURE ;
INSERT INTO FORFAIT (id_client, id_projet, tarif_forfait) VALUES (1, 1,10000) ;
SELECT *, '' AS '<= FORFAIT' FROM FORFAIT ;
INSERT INTO MOT (id_client, id_projet, id_mot, NbMots, Tarif, MatchValeur) VALUES (1, 1, 0, 50, 100, 'doublonne avec FORFAIT !') ;
INSERT INTO MOT (id_client, id_projet, id_mot, NbMots, Tarif, MatchValeur) VALUES (1, 2, 0, 50, 100, 'Bonjour Madame') ;
INSERT INTO MOT (id_client, id_projet, id_mot, NbMots, Tarif, MatchValeur) VALUES (1, 2, 0, 50, 200, 'Bonsoir Monsieur') ;
INSERT INTO MOT (id_client, id_projet, id_mot, NbMots, Tarif, MatchValeur) VALUES (2, 1, 0, 10, 300, 'Sorry') ;
INSERT INTO MOT (id_client, id_projet, id_mot, NbMots, Tarif, MatchValeur) VALUES (2, 1, 0, 10, 400, 'Query') ;
INSERT INTO MOT (id_client, id_projet, id_mot, NbMots, Tarif, MatchValeur) VALUES (2, 1, 0, 10, 500, 'Language') ;
Si vous codez :
Partager