testseed.sql

INSERT INTO pilots(first_name, last_name, age)
VALUES ('Ivo', 'Jarunica', 42);
INSERT INTO pilots(first_name, last_name, age)
VALUES ('Marko', 'Peric', 23);
INSERT INTO pilots(first_name, last_name, age)
VALUES ('Davor', 'Šukalo', 47);
INSERT INTO pilots(first_name, last_name, age)
VALUES ('Petar', 'Pavarovic', 37);
INSERT INTO pilots(first_name, last_name, age)
VALUES ('Borna', 'Krizinsky', 31);
INSERT INTO pilots(first_name, last_name, age)
VALUES ('Bolo', 'Keno', 33);
INSERT INTO pilots(first_name, last_name, age)
VALUES ('Josko', 'Supraca', 28);
INSERT INTO pilots(first_name, last_name, age)
VALUES ('Goran', 'Hektorovic', 56);
INSERT INTO pilots(first_name, last_name, age)
VALUES ('Boro', 'Kavez', 21);

INSERT INTO aircrafts(aircraft_name)
VALUES('Leteca banana MKIII');
INSERT INTO aircrafts(aircraft_name)
VALUES('Boeing 5000');
INSERT INTO aircrafts(aircraft_name)
VALUES('F-161');
INSERT INTO aircrafts(aircraft_name)
VALUES('Neki avion bogati');
INSERT INTO aircrafts(aircraft_name)
VALUES('Mombao Ukutuku');
INSERT INTO aircrafts(aircraft_name)
VALUES('Forgetaboutit');


INSERT INTO pilots_aircrafts(pilot_id, aircraft_id)
VALUES (1, 2);
INSERT INTO pilots_aircrafts(pilot_id, aircraft_id)
VALUES (2, 1);
INSERT INTO pilots_aircrafts(pilot_id, aircraft_id)
VALUES (2, 2);
INSERT INTO pilots_aircrafts(pilot_id, aircraft_id)
VALUES (3, 2);
INSERT INTO pilots_aircrafts(pilot_id, aircraft_id)
VALUES (3, 4);
INSERT INTO pilots_aircrafts(pilot_id, aircraft_id)
VALUES (3, 5);
INSERT INTO pilots_aircrafts(pilot_id, aircraft_id)
VALUES (3, 6);
INSERT INTO pilots_aircrafts(pilot_id, aircraft_id)
VALUES (4, 3);
INSERT INTO pilots_aircrafts(pilot_id, aircraft_id)
VALUES (4, 5);
INSERT INTO pilots_aircrafts(pilot_id, aircraft_id)
VALUES (5, 1);
INSERT INTO pilots_aircrafts(pilot_id, aircraft_id)
VALUES (6, 4);
INSERT INTO pilots_aircrafts(pilot_id, aircraft_id)
VALUES (6, 2);
INSERT INTO pilots_aircrafts(pilot_id, aircraft_id)
VALUES (7, 1);
INSERT INTO pilots_aircrafts(pilot_id, aircraft_id)
VALUES (7, 6);
INSERT INTO pilots_aircrafts(pilot_id, aircraft_id)
VALUES (8, 4);