Advertisement
Guest User

Untitled

a guest
Apr 20th, 2018
611
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.20 KB | None | 0 0
  1. INSERT INTO Customer VALUES (1, 'John', 'Johnson', 'Frederiksgade', 'Denmark', '8700', 'johsenen@gmail.com', '45501142');
  2. INSERT INTO Customer VALUES (2, 'Anders', 'Dernando', 'Amaliegade', 'Denmark', '9000', 'andersdernando@gmail.com', '45501122');
  3. INSERT INTO Customer VALUES (3, 'Joanna', 'Pedersen', 'Sundvej', 'Denmark', '1500', 'joannapedersen@gmail.com', '45513142');
  4. INSERT INTO Customer VALUES (4, 'Mikkel', 'Drytkov', 'Daukanto', 'Lithuania', '20175', 'mikkeldrytkov@gmail.com', '45171142');
  5. INSERT INTO Customer VALUES (5, 'Peter', 'Spoder', 'Fredericiagade', 'Denmark', '5000', 'peterspoder@gmail.com', '45502442');
  6. INSERT INTO Customer VALUES (6, 'Smith', 'Deshen', 'Danskegade', 'Denmark', '1770', 'peterspoder@gmail.com', '45312342');
  7.  
  8. INSERT INTO Employee values
  9. (1,'Vladimir','Petkov','01-03-1943','vladimirpetkov@gmail.com','0416235','Flowers Street 4231','4213','Trainer',1),
  10. (2,'Igor','Chernyi','05-07-1966','igorchernyi@gmail.com','0423152','Castle Street 4231','4213','Trainer',1),
  11. (3,'Vasiliy','Beliy','09-02-1988','vasilyibeliy@gmail.com','0425123','Glen Park 3215','4213','Carrier',1),
  12. (4,'Viktor','Zelenyi','02-10-1999','viktorzelenyi@gmail.com','0429182','Jefersson Motel 3215','4111','Trainer',2),
  13. (5,'Sasha','Seriy','02-22-1988','sashaseriy@gmail.com','0411123','El Corona 3215','4912','Trainer',2),
  14. (6,'Kiril','Tarakan','09-02-1812','kiriltarakan@gmail.com','0423123','Idlewood 3215','4213','Carrier',2),
  15. (7,'Gosha','Rubchinskiy','09-12-1712','gosharubchinskyi@gmail.com','0465423','Grove Street 3215','4213','Trainer',3),
  16. (8,'Komar','Beliy','09-02-1988','komarbeliy@gmail.com','0425123','Glen Park 2231','4213','Carrier',3);
  17.  
  18. INSERT INTO Golf_Court VALUES (1, 'Golden Dragon Court', 'Tokyo', 250.0, 14, true, true, true, true);
  19. INSERT INTO Golf_Court VALUES (2, 'Virgin Beach Court', 'Hawaii', 430.4, 14, true, false, true, true);
  20. INSERT INTO Golf_Court VALUES (3, 'Stormy Sea Court', 'Copenhagen', 130.0, 14, true, true, false, true);
  21. INSERT INTO Golf_Court VALUES (4, 'Privjat Russia Court', 'St.Peterburg', 607.5, 14, false, false, false, false);
  22.  
  23. INSERT INTO Cart VALUES (1, 2, 1);
  24. INSERT INTO Cart VALUES (2, 2, 2);
  25. INSERT INTO Cart VALUES (3, 4, 3);
  26. INSERT INTO Cart VALUES (4, 6, 1);
  27. INSERT INTO Cart VALUES (5, 2, 2);
  28. INSERT INTO Cart VALUES (6, 4, 3);
  29.  
  30. INSERT INTO Hole VALUES (1, 275.5, 3, 1);
  31. INSERT INTO Hole VALUES (2, 100.0, 5, 2);
  32. INSERT INTO Hole VALUES (3, 125.9, 8, 3);
  33. INSERT INTO Hole VALUES (4, 367.0, 4, 1);
  34. INSERT INTO Hole VALUES (5, 525.4, 2, 2);
  35. INSERT INTO Hole VALUES (6, 232.4, 10, 3);
  36.  
  37. INSERT INTO Clubs VALUES (1, 'Wood', 1);
  38. INSERT INTO Clubs VALUES (2, 'Steel', 2);
  39. INSERT INTO Clubs VALUES (3, 'Plastic', 3);
  40. INSERT INTO Clubs VALUES (4, 'Steel', 1);
  41. INSERT INTO Clubs VALUES (5, 'Steel', 2);
  42. INSERT INTO Clubs VALUES (6, 'Steel', 3);
  43.  
  44. INSERT INTO Booking VALUES (1, '05-12-2018','05-17-2018','club',1,1);
  45. INSERT INTO Booking VALUES (2, '05-15-2018','05-21-2018','cart',2,2);
  46. INSERT INTO Booking VALUES (3, '06-07-2018','06-10-2018','null',3,3);
  47. INSERT INTO Booking VALUES (4, '06-12-2018','06-15-2018','cart',1,4);
  48. INSERT INTO Booking VALUES (5, '06-20-2018','06-25-2018','null',2,5);
  49. INSERT INTO Booking VALUES (6, '07-02-2018','07-07-2018','club cart',3,6);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement