Guest User

Untitled

a guest
Apr 24th, 2018
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. INSERT INTO STATION (nom_station,capacité,lieu,région,tarif)
  2. VALUES
  3. ('Venusa','350','Guadeloupe','Antilles','1200'),
  4. ('Farniente','200','Seychelles','Océan Indien','1500'),
  5. ('Santalba','150','Martinique','Antilles','2000'),
  6. ('Passac','400','Alpes','Europe','1000');
  7.  
  8. INSERT INTO ACTIVITE (nom_station,libellé,prix)
  9. VALUES
  10. ('Venusa','Voile','150'),
  11. ('Venusa','Plongée','120'),
  12. ('Farniente','Plongée','130'),
  13. ('Passac','Ski','200'),
  14. ('Passac','Piscine','20'),
  15. ('Santalba','Kayac','50');
  16.  
  17. INSERT INTO CLIENT (id_client, nom, prénom, ville, région, solde)
  18. VALUES
  19. ('10','Fogg','Phileas','Londres','Europe','12465'),
  20. ('20','Pascal','Blaise','Paris','Europe','6763'),
  21. ('30','Kerouac','Jack','New York','Amerique','9812');
  22.  
  23. INSERT INTO SEJOUR (id_client, nom_station, début, nbplaces)
  24. VALUES
  25. ('10','Passac','1998/07/01','2'),
  26. ('30','Santalba','1996/08/14','5'),
  27. ('20','Santalba','1998/08/03','4'),
  28. ('30','Passac','1998/08/15','3'),
  29. ('30','Venusa','1998/08/03','3'),
  30. ('20','Venusa','1998/08/03','6'),
  31. ('30','Farniente','1999/06/24','5'),
  32. ('10','Farniente','1998/09/05','2');
Add Comment
Please, Sign In to add comment