-- the pilots
INSERT INTO pilots (id,name) VALUES (1,'Francis Drake');
INSERT INTO pilots (id,name) VALUES (2,'Samuel Verner');
INSERT INTO pilots (id,name) VALUES (3,'Tricia McMillian');
INSERT INTO pilots (id,name) VALUES (4,'Arthur Denton');
INSERT INTO pilots (id,name) VALUES (5,'Ford Prefect');
INSERT INTO pilots (id,name) VALUES (6,'Zaphod Beeblebrox');
INSERT INTO pilots (id,name) VALUES (7,'Slartibartfast');

-- the planes
INSERT INTO planes (id,name) VALUES (1,'Golden heart');
INSERT INTO planes (id,name) VALUES (2,'Metroliner');
INSERT INTO planes (id,name) VALUES (3,'Ambassador');

-- knows
INSERT INTO knows (pilotid,planeid) VALUES (1,1);
INSERT INTO knows (pilotid,planeid) VALUES (1,2);
INSERT INTO knows (pilotid,planeid) VALUES (2,3);
INSERT INTO knows (pilotid,planeid) VALUES (3,1);
INSERT INTO knows (pilotid,planeid) VALUES (3,2);
INSERT INTO knows (pilotid,planeid) VALUES (3,3);
INSERT INTO knows (pilotid,planeid) VALUES (4,1);
INSERT INTO knows (pilotid,planeid) VALUES (4,2);
INSERT INTO knows (pilotid,planeid) VALUES (4,3);
INSERT INTO knows (pilotid,planeid) VALUES (5,3);
INSERT INTO knows (pilotid,planeid) VALUES (5,1);
INSERT INTO knows (pilotid,planeid) VALUES (6,2);
INSERT INTO knows (pilotid,planeid) VALUES (6,1);
INSERT INTO knows (pilotid,planeid) VALUES (7,2);

