API tools faq
paste
Guest User

Untitled

a guest
Dec 20th, 2017
157
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 10.34 KB | None | 0 0
raw download clone embed print report
  1. INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('admin','admin', 'admin@admin.com', TRUE );
  2. INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Zbigniew','zbigniew', 'zbigniew@gmail.com', FALSE );
  3. INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Jan','jan', 'jan@gmail.com', FALSE );
  4. INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Mateusz','mateusz', 'mateusz@gmail.com', FALSE );
  5. INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Anna','anna', 'anna@onet.pl', FALSE );
  6. INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Krzysztof','krzysztof', 'krzysztof@o2.pl', FALSE );
  7. INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Przemysław','przemo', 'przemo@admin.com', FALSE );
  8. INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Katarzyna','katarzyna', 'kate@gmail.com', FALSE );
  9. INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Maria','maria', 'maria@gmail.com', FALSE );
  10. INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Piotr','piotrek', 'piotr@gmail.com', FALSE );
  11. INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Paweł','pablo', 'pawel@onet.pl', FALSE );
  12. INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('John','littlejohnny', 'johnny@gmail.gmail', FALSE );
  13.  
  14. INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
  15.     VALUES ('Orlen', 'Krzywoustego 172', 'Wrocław', '50-312', 4.40, 4.70, 4.20, 2.00, 400, 10);
  16. INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
  17.     VALUES ('BP', 'Głogowska 15', 'Ostrów Wielkopolski', '60-400', 4.37, 4.66, 4.22, 1.97, 250, 20);
  18. INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
  19.     VALUES ('Shell', 'Traugutta 1', 'Poznań', '61-514', 4.42, 4.73, 4.12, 1.92, 300, 10);
  20. INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
  21.     VALUES ('Lotos', 'Trzebnicka 39', 'Wrocław', '50-231', 4.35, 4.74, 4.25, 2.01, 100, 6);
  22. INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
  23.     VALUES ('Orlen', 'Piątkowska 68', 'Poznań', '60-649', 4.37, 4.68, 4.11, 1.92, 520, 23);
  24. INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
  25.     VALUES ('Shell', 'Kaliska 104', 'Ostrów Wielkopolski', '63-400', 4.41, 4.71, 4.19, 1.99, 120, 3);
  26. INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
  27.     VALUES ('Orlen', 'Słowackiego 172', 'Gdańsk', '80-802', 4.42, 4.68, 4.21, 2.03, 780, 23);
  28. INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
  29.     VALUES ('BP', 'Swobodna 60', 'Wrocław', '50-089', 4.38, 4.67, 4.19, 1.97, 430, 46);
  30. INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
  31.     VALUES ('Shell', 'Jagiellońska 29', 'Częstochowa', '42-200', 4.43, 4.70, 4.10, 1.99, 311, 16);
  32. INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
  33.     VALUES ('Lotos', 'Warszawska 98', 'Radom', '26-600', 4.35, 4.74, 4.25, 2.01, 543, 43);
  34. INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
  35.     VALUES ('Orlen', 'Maratońska 57', 'Radom', '26-600', 4.37, 4.68, 4.11, 1.92, 520, 23);
  36. INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
  37.     VALUES ('Shell', 'aleja Rzeczypospolitej 8', 'Gdańsk', '80-369', 4.43, 4.68, 4.19, 1.97, 325, 10);
  38.  
  39. INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
  40.     VALUES (2, 'Rodzinny', '', 'Opel', 'Vectra', 130000, 'Diesel', 'DEMO 001', '10-12-2018', '10-12-2018', TRUE);
  41. INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
  42.     VALUES (2, 'Sluzbowy', '', 'Skoda', 'Suberb', 30000, 'Petrol', 'DEMO 002', '11-10-2020', '11-10-2020', TRUE);
  43. INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
  44.     VALUES (3, 'Rodzinny', '', 'Volkswagen', 'Passat', 300000, 'Diesel', 'DEMO 003', '10-03-2017', '10-03-2017', TRUE);
  45. INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
  46.     VALUES (4, 'SUV', '', 'Renault', 'Koleos', 50000, 'Petrol', 'DEMO 004', '21-06-2019', '21-06-2019', TRUE);
  47. INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
  48.     VALUES (5, 'Miejski', '', 'Mini', 'Cooper', 100000, 'Petrol + Gas', 'DEMO 005', '04-07-2018', '04-07-2018', TRUE);
  49. INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
  50.     VALUES (6, 'Muscle', '', 'Ford', 'Mustang', 160000, 'Petrol', 'DEMO 006', '10-12-2019', '10-12-2019', TRUE);
  51. INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
  52.     VALUES (7, 'Auto1', '', 'Mercedes-Benz', 'E220', 32000, 'Petrol', 'DEMO 007', '19-03-2018', '19-03-2018', TRUE);
  53. INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
  54.     VALUES (8, 'MyCar', '', 'Opel', 'Zafira', 230000, 'Diesel', 'DEMO 008', '11-07-2020', '11-07-2020', TRUE);
  55. INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
  56.     VALUES (9, 'Motocykl', '', 'Yamaha', 'YZF-R3', 50000, 'Petrol', 'DEMO 009', '03-06-2019', '03-06-2019', TRUE);
  57. INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
  58.     VALUES (10, 'SUV', '', 'Hummer', 'H3', 70000, 'Petrol', 'DEMO 010', '25-12-2019', '25-12-2019', TRUE);
  59. INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
  60.     VALUES (11, 'MojSamochod', '', 'Opel', 'Corsa', 100000, 'Petrol + Gas', 'DEMO 011', '23-07-2018', '23-07-2018', TRUE);
  61. INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
  62.     VALUES (12, 'Cabrio', '', 'Mercedes-Benz', 'CLK', 150000, 'Diesel', 'DEMO 012', '11-04-2019', '11-04-2019', TRUE);
  63.  
  64. INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (2, 1);
  65. INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (2, 4);
  66. INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (3, 2);
  67. INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (3, 6);
  68. INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (4, 5);
  69. INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (4, 3);
  70. INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (5, 1);
  71. INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (6, 2);
  72. INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (7, 9);
  73. INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (8, 9);
  74. INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (9, 7);
  75. INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (10, 7);
  76. INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (11, 11);
  77. INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (11, 10);
  78. INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (12, 7);
  79. INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (12, 12);
  80.  
  81. INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
  82.     VALUES (1, 1, 'Do pelna', 176.30, 40, 129700, '01-02-2017');
  83. INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
  84.     VALUES (1, 2, '', 132.55, 30, 299300, '10-02-2017');
  85. INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
  86.     VALUES (2, 3, '', 160.30, 40, 299700, '15-04-2017');
  87. INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
  88.     VALUES (2, 3, '', 40.00, 10, 299920, '16-05-2017');
  89. INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
  90.     VALUES (3, 5, '', 220.70, 50, 49600, '01-03-2017');
  91. INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
  92.     VALUES (1, 5, '', 88.30, 20, 99800, '17-03-2017');
  93. INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
  94.     VALUES (7, 7, '', 176.30, 40, 32400, '01-05-2017');
  95. INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
  96.     VALUES (8, 8, '', 132.55, 30, 230300, '10-02-2017');
  97. INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
  98.     VALUES (9, 9, '', 160.30, 40, 50200, '15-04-2017');
  99. INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
  100.     VALUES (7, 12, '', 40.00, 10, 32700, '16-05-2017');
  101. INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
  102.     VALUES (10, 10, '', 220.70, 50, 70000, '01-03-2017');
  103. INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
  104.     VALUES (10, 11, '', 88.30, 20, 70300, '17-03-2017');
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!