Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('admin','admin', 'admin@admin.com', TRUE );
- INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Zbigniew','zbigniew', 'zbigniew@gmail.com', FALSE );
- INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Jan','jan', 'jan@gmail.com', FALSE );
- INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Mateusz','mateusz', 'mateusz@gmail.com', FALSE );
- INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Anna','anna', 'anna@onet.pl', FALSE );
- INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Krzysztof','krzysztof', 'krzysztof@o2.pl', FALSE );
- INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Przemysław','przemo', 'przemo@admin.com', FALSE );
- INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Katarzyna','katarzyna', 'kate@gmail.com', FALSE );
- INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Maria','maria', 'maria@gmail.com', FALSE );
- INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Piotr','piotrek', 'piotr@gmail.com', FALSE );
- INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('Paweł','pablo', 'pawel@onet.pl', FALSE );
- INSERT INTO "Users" (nickname, PASSWORD, mail, is_admin) VALUES ('John','littlejohnny', 'johnny@gmail.gmail', FALSE );
- INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
- VALUES ('Orlen', 'Krzywoustego 172', 'Wrocław', '50-312', 4.40, 4.70, 4.20, 2.00, 400, 10);
- INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
- VALUES ('BP', 'Głogowska 15', 'Ostrów Wielkopolski', '60-400', 4.37, 4.66, 4.22, 1.97, 250, 20);
- INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
- VALUES ('Shell', 'Traugutta 1', 'Poznań', '61-514', 4.42, 4.73, 4.12, 1.92, 300, 10);
- INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
- VALUES ('Lotos', 'Trzebnicka 39', 'Wrocław', '50-231', 4.35, 4.74, 4.25, 2.01, 100, 6);
- INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
- VALUES ('Orlen', 'Piątkowska 68', 'Poznań', '60-649', 4.37, 4.68, 4.11, 1.92, 520, 23);
- INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
- VALUES ('Shell', 'Kaliska 104', 'Ostrów Wielkopolski', '63-400', 4.41, 4.71, 4.19, 1.99, 120, 3);
- INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
- VALUES ('Orlen', 'Słowackiego 172', 'Gdańsk', '80-802', 4.42, 4.68, 4.21, 2.03, 780, 23);
- INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
- VALUES ('BP', 'Swobodna 60', 'Wrocław', '50-089', 4.38, 4.67, 4.19, 1.97, 430, 46);
- INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
- VALUES ('Shell', 'Jagiellońska 29', 'Częstochowa', '42-200', 4.43, 4.70, 4.10, 1.99, 311, 16);
- INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
- VALUES ('Lotos', 'Warszawska 98', 'Radom', '26-600', 4.35, 4.74, 4.25, 2.01, 543, 43);
- INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
- VALUES ('Orlen', 'Maratońska 57', 'Radom', '26-600', 4.37, 4.68, 4.11, 1.92, 520, 23);
- INSERT INTO "Petrol_stations" (NAME, street, city, postal_code, pb95_price, pb98_price, on_price, gas_price, likes, unlikes)
- VALUES ('Shell', 'aleja Rzeczypospolitej 8', 'Gdańsk', '80-369', 4.43, 4.68, 4.19, 1.97, 325, 10);
- INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
- VALUES (2, 'Rodzinny', '', 'Opel', 'Vectra', 130000, 'Diesel', 'DEMO 001', '10-12-2018', '10-12-2018', TRUE);
- INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
- VALUES (2, 'Sluzbowy', '', 'Skoda', 'Suberb', 30000, 'Petrol', 'DEMO 002', '11-10-2020', '11-10-2020', TRUE);
- INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
- VALUES (3, 'Rodzinny', '', 'Volkswagen', 'Passat', 300000, 'Diesel', 'DEMO 003', '10-03-2017', '10-03-2017', TRUE);
- INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
- VALUES (4, 'SUV', '', 'Renault', 'Koleos', 50000, 'Petrol', 'DEMO 004', '21-06-2019', '21-06-2019', TRUE);
- INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
- VALUES (5, 'Miejski', '', 'Mini', 'Cooper', 100000, 'Petrol + Gas', 'DEMO 005', '04-07-2018', '04-07-2018', TRUE);
- INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
- VALUES (6, 'Muscle', '', 'Ford', 'Mustang', 160000, 'Petrol', 'DEMO 006', '10-12-2019', '10-12-2019', TRUE);
- INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
- VALUES (7, 'Auto1', '', 'Mercedes-Benz', 'E220', 32000, 'Petrol', 'DEMO 007', '19-03-2018', '19-03-2018', TRUE);
- INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
- VALUES (8, 'MyCar', '', 'Opel', 'Zafira', 230000, 'Diesel', 'DEMO 008', '11-07-2020', '11-07-2020', TRUE);
- INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
- VALUES (9, 'Motocykl', '', 'Yamaha', 'YZF-R3', 50000, 'Petrol', 'DEMO 009', '03-06-2019', '03-06-2019', TRUE);
- INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
- VALUES (10, 'SUV', '', 'Hummer', 'H3', 70000, 'Petrol', 'DEMO 010', '25-12-2019', '25-12-2019', TRUE);
- INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
- VALUES (11, 'MojSamochod', '', 'Opel', 'Corsa', 100000, 'Petrol + Gas', 'DEMO 011', '23-07-2018', '23-07-2018', TRUE);
- INSERT INTO "Cars" (owner_id, NAME, description, brand, model, mileage, fuel_type, registration_number, next_review, next_oil_change, notifications_allowed)
- VALUES (12, 'Cabrio', '', 'Mercedes-Benz', 'CLK', 150000, 'Diesel', 'DEMO 012', '11-04-2019', '11-04-2019', TRUE);
- INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (2, 1);
- INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (2, 4);
- INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (3, 2);
- INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (3, 6);
- INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (4, 5);
- INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (4, 3);
- INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (5, 1);
- INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (6, 2);
- INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (7, 9);
- INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (8, 9);
- INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (9, 7);
- INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (10, 7);
- INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (11, 11);
- INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (11, 10);
- INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (12, 7);
- INSERT INTO "Favourite_stations" (user_id, petrol_station_id) VALUES (12, 12);
- INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
- VALUES (1, 1, 'Do pelna', 176.30, 40, 129700, '01-02-2017');
- INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
- VALUES (1, 2, '', 132.55, 30, 299300, '10-02-2017');
- INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
- VALUES (2, 3, '', 160.30, 40, 299700, '15-04-2017');
- INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
- VALUES (2, 3, '', 40.00, 10, 299920, '16-05-2017');
- INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
- VALUES (3, 5, '', 220.70, 50, 49600, '01-03-2017');
- INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
- VALUES (1, 5, '', 88.30, 20, 99800, '17-03-2017');
- INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
- VALUES (7, 7, '', 176.30, 40, 32400, '01-05-2017');
- INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
- VALUES (8, 8, '', 132.55, 30, 230300, '10-02-2017');
- INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
- VALUES (9, 9, '', 160.30, 40, 50200, '15-04-2017');
- INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
- VALUES (7, 12, '', 40.00, 10, 32700, '16-05-2017');
- INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
- VALUES (10, 10, '', 220.70, 50, 70000, '01-03-2017');
- INSERT INTO "Refuellings" (petrol_station_id, car_id, description, total_price, liters, mileage, datetime)
- VALUES (10, 11, '', 88.30, 20, 70300, '17-03-2017');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement