populateDb.sql

INSERT INTO avion VALUES (6001, 'Airbus A330' , 'the Netherlands');
INSERT INTO avion VALUES (6002, 'Airbus A350 XWB', 'France');
INSERT INTO avion VALUES (6003, 'Airbus A319', 'Germany');
INSERT INTO avion VALUES (6004, 'Boeing 707', 'United States');
INSERT INTO avion VALUES (6005, 'Boeing 777', 'United States');

INSERT INTO locatii VALUES (7001, 'Porto', 'Europa');
INSERT INTO locatii VALUES (7002, 'Málaga', 'Europa');
INSERT INTO locatii VALUES (7003, 'Paris', 'Europa');
INSERT INTO locatii VALUES (7004, 'London', 'Europa');
INSERT INTO locatii VALUES (7005, 'Vienna', 'Europa');
INSERT INTO locatii VALUES (7006, 'Madrid', 'Europa');
INSERT INTO locatii VALUES (7007, 'Athens', 'Europa');
INSERT INTO locatii VALUES (7008, 'Tel Aviv', 'Asia');
INSERT INTO locatii VALUES (7009, 'Lisbon', 'Europa');
INSERT INTO locatii VALUES (7010, 'Casablanca', 'Africa');
INSERT INTO locatii VALUES (7011, 'Nevada', 'America');

insert into discount values(001,'Fidelitate',10);
insert into discount values(002,'Promotie',5);
insert into discount values(003,'Early-Buy',10);

INSERT INTO aeroport VALUES (3001, 'Porto Francisco Sa Carneiro International Airport', 7001 , 'International');
INSERT INTO aeroport VALUES (3002, 'Málaga–Costa del Sol Airport', 7002 , 'International');
INSERT INTO aeroport VALUES (3003, 'Paris Charles de Gaulle Airport', 7003 , 'International');
INSERT INTO aeroport VALUES (3004, 'Heathrow Airport', 7004 , 'International');
INSERT INTO aeroport VALUES (3005, 'Vienna International Airport', 7005 , 'International');
INSERT INTO aeroport VALUES (3006, 'Adolfo Suárez Madrid–Barajas Airport', 7006 , 'International');
INSERT INTO aeroport VALUES (3007, 'Athens International Airport Eleftherios Venizelos', 7007 , 'International');
INSERT INTO aeroport VALUES (3008, 'Ben Gurion Airport', 7008 , 'International');
INSERT INTO aeroport VALUES (3009, 'Humberto Delgado Airport', 7009 , 'International');
INSERT INTO aeroport VALUES (3010, 'Mohammed V International Airport', 7010 , 'International');
INSERT INTO aeroport VALUES (3011, 'Area 51', 7011 , 'Militar');

INSERT INTO ZBORURI VALUES (4001, 'easyJet Europe' , 3008, 3001, 6001, 'International');
INSERT INTO ZBORURI VALUES (4002, 'Brussels Airlines', 3002, 3003, 6003, 'International');
INSERT INTO ZBORURI VALUES (4003, 'Bulgaria Air', 3004, 3002, 6001, 'National');
INSERT INTO ZBORURI VALUES (4004, 'Smartwings', 3010, 3009, 6004, 'International');
INSERT INTO ZBORURI VALUES (4005, 'Air France' , 3010, 3005, 6005, 'International');
INSERT INTO ZBORURI VALUES (4006, 'Austrian Airlines' , 3005, 3010, 6002, 'International');
INSERT INTO ZBORURI VALUES (4007, 'British Airways', 3010, 3001, 6005, 'International');
INSERT INTO ZBORURI VALUES (4008, 'Corendon Airlines', 3001, 3002, 6001, 'International');
INSERT INTO ZBORURI VALUES (4009, 'Emirates', 3001, 3003, 6005, 'International');
INSERT INTO ZBORURI VALUES (4010, 'Lufthansa', 3001, 3007, 6005, 'International');
INSERT INTO ZBORURI VALUES (4011, 'Royal Air Maroc', 3002, 3001, 6005, 'International');
INSERT INTO ZBORURI VALUES (4012, 'TAP Air Portugal', 3002, 3007, 6004, 'International');
INSERT INTO ZBORURI VALUES (4013, 'Wizz Air', 3002, 3010, 6004, 'International');
INSERT INTO ZBORURI VALUES (4014, 'Ryanair' , 3003, 3001, 6004, 'International');
INSERT INTO ZBORURI VALUES (4015, 'KLM Royal Dutch Airlines', 3003, 3009, 6005, 'International');
INSERT INTO ZBORURI VALUES (4016, 'Aegean Airlines', 3007, 3003, 6003, 'International');
INSERT INTO ZBORURI VALUES (4017, 'TAROM' , 3008, 3010, 6001, 'International');
INSERT INTO ZBORURI VALUES (4018, 'Alitalia' , 3004, 3003, 6002, 'International');
INSERT INTO ZBORURI VALUES (4019, 'Iberia' , 3004, 3001, 6002, 'National');
INSERT INTO ZBORURI VALUES (4020, 'Arkia', 3005, 3006, 6001, 'International');
INSERT INTO ZBORURI VALUES (4021, 'U.S. Air Forces', 3008, 3011, 6005, 'International');

insert into escale values (4021,'NATO',3003);
insert into escale values (4021,'MI6',3004);


insert into bagaj VALUES (01 ,'Categoria A, bagaj M ',10);
insert into bagaj VALUES (02 ,'Categoria B, bagaj M+C ',33);
insert into bagaj VALUES (03 ,'Categoria C, , bagaj M+C',42);

insert into pasageri VALUES (0001 ,' Ioana ',' Popescu ','Romania', 02 , '2020-06-13' ,'Bucuresti, strada Primaverii, nr2 ','ioanapopescu@gmail.com' ,0755943844);
insert into pasageri VALUES (0002 ,' Alina',' Rotaru ','Romania', 03 , '2021-06-13' ,'Iasi, strada Primaverii ,nr1 ','alinaR@yahoo.com' ,0755900844);
insert into pasageri VALUES (0003 ,' Rick ',' Grims ','Belgia ', 11 , '2022-09-16' ,'Bruxelles, strada Principala,  nr1110 ',' rickG@yahoo.com' ,0755223844);
insert into pasageri VALUES (0004 ,' Daryl ',' Dixon  ','Danemarca ', 12 , '2025-01-13' ,' Copenhaga, strada Copen,nr7 ',' dayldixon@gmail.com' ,0755943114);
insert into pasageri VALUES (0005 ,' Norman ',' Reedus ',' Italia ', 04 , '2021-03-22' ,'Roma, strada Romeiii, nr301 ','redussu@yahoo.com' ,0755934844);
insert into pasageri VALUES (0006,' Andrew ',' Lincoln','Anglia', 13 , '2022-01-03' ,' Londra, strada Andwee, nr211 ','lincolAndrew@yahoo.com' ,0755900844);
insert into pasageri VALUES (0007 ,' Elena  ',' Morosan ','Romania', 05 , '2023-01-22' ,'Cluj-Napoca, strada Garii, nr 13','Emorosan@yahoo.com' ,0755943344);
insert into pasageri  VALUES (0008 ,' Ana-Maria ',' Pintilescu ','Romania', 22 , '2024-02-11' ,'Suceava, strada George Enescu A nr44 ',' anapintilescu@gmail.com' ,0757743844);
insert into pasageri  VALUES (0009 ,' Madalina ',' Enache  ','Romania', 17 , '2021-06-13' ,'Bucau , strada Verii nr27',' enachem@gmail.com' ,0755909844);
insert into pasageri VALUES (0010 ,' Robert ',' Weber ','Germania', 20 , '2021-12-16' ,'Hoffmann, strada  Scheider ,nr401 ','robertWe@yahoo.com' ,0755943855);
insert into pasageri  VALUES (0011 ,' Ioana ',' Popescu ','Romania', 56 , '2025-11-13' ,'Bucuresti strada Primaverii nr2, ','ioanapopescu@yahoo.com' ,0755943844);
insert into pasageri  VALUES (0012 ,' Napoleon ',' Martin','Franta', 33 , '2020-09-07' , ' Paris, strada Blanc, nr2001 ','martinN@yahoo.com' ,0552843844);
insert into pasageri VALUES (0013 ,' Alina',' Zale ','Romania', 44 , '2024-01-09' ,'Gura-Humorului, strada Damone,nr21A ',' alinazale@yahoo.com' ,0755943812);
insert into pasageri VALUES (0014 ,' Daniel ',' Morosan ','Romania', 55 , '2022-08-13' ,'Suceava,strada Leca, nr1 ','Morosandaniel@yahoo.com' ,0755948844);
insert into pasageri VALUES (0015 ,' Ioan ',' Nastiuc ','Romania', 76 , '2022-11-11' ,'Iasi, strada Sendrea,nr3B ','ioannastiuc3@yahoo.com' ,0755907844);
insert into pasageri  VALUES (0016 ,' Antonio ',' Lupescu ','Romania', 62 , '2024-01-01' ,'Brasov, strada Cetatii,nr200 ','lupescuantonio@yahoo.com' ,0235943844);
insert into pasageri VALUES (0017 ,' Patricia',' Atudorei ','Romania', 67 , '2021-07-03' ,'Constanta, strada Marii,nr12','patriatudorei@gmail.com' ,0055943844);
insert into pasageri VALUES (0018 ,' Andrei ',' Petrescu','Romania', 99 , '2023-04-10' ,'Sibiu, strada Morariu, nr217','andreipetrescu@yahoo.com' ,0115943844);
insert into pasageri VALUES (0019 ,' Sanda ',' Zaharia ','Romania', 59, '2022-08-04' ,'Piatra Neamt, strada Cetatuii,nr155 ','sandazaharia8@gmail.com' ,0395943844);
insert into pasageri VALUES (0020 ,' Carmen',' Bernard ','Romania', 98 , '2022-09-11' ,'Timisoara, strada Timeia,nr20','carmenbernadr@yahoo.com' ,0985943844);

insert into locuri VALUES (001,6001,'A-Light', 1);
insert into locuri VALUES (002,6001,'A-Light', 2);
insert into locuri VALUES (003,6001,'A-Light', 3);
insert into locuri VALUES (004,6001,'A-Light', 4);
insert into locuri VALUES (005,6001,'A-Light', 5);
insert into locuri VALUES (006,6001,'B-Classic', 1);
insert into locuri VALUES (007,6001,'B-Classic', 2);
insert into locuri VALUES (008,6001,'B-Classic', 3);
insert into locuri VALUES (009,6001,'B-Classic', 4);
insert into locuri VALUES (010,6001,'B-Classic', 5);
insert into locurI VALUES  (011,6001,'C-Premium', 1);
insert into locurI VALUES  (012,6001,'C-Premium', 2);
insert into locurI VALUES  (013,6001,'C-Premium', 3);
insert into locurI VALUES  (014,6001,'C-Premium', 4);
insert into locurI VALUES  (015,6001,'C-Premium', 5);
insert into locuri VALUES (016,6003,'A-Light', 1);
insert into locuri VALUES (017,6003,'A-Light', 2);
insert into locuri VALUES (018,6003,'A-Light', 3);
insert into locuri VALUES (019,6003,'A-Light', 4);
insert into locuri VALUES (020,6003,'A-Light', 5);
insert into locuri VALUES (021,6003,'B-Classic', 1);
insert into locuri VALUES (022,6003,'B-Classic', 2);
insert into locuri VALUES (023,6003,'B-Classic', 3);
insert into locuri VALUES (024,6003,'B-Classic', 4);
insert into locuri VALUES (025,6003,'B-Classic', 5);
insert into locurI VALUES  (026,6003,'C-Premium', 1);
insert into locurI VALUES  (027,6003,'C-Premium', 2);
insert into locurI VALUES  (028,6003,'C-Premium', 3);
insert into locurI VALUES  (029,6003,'C-Premium', 4);
insert into locurI VALUES  (030,6003,'C-Premium', 5);

insert into rezervari values(1,0001,4001,'2021-06-30',2,001,01,001);
insert into rezervari values(2,0004,4002,'2021-07-10',5,016,01,002);
insert into rezervari values(3,0007,4003,'2021-08-11',3,003,01.001);
insert into rezervari values(4,0010,4008,'2021-10-12',2,004,01);
insert into rezervari values(5,0015,4017,'2021-12-18',1,019,01);
insert into rezervari values(6,0003,4020,'2021-01-17',1,012,01,003);
insert into rezervari values(7,0019,4020,'2021-03-14',6,011,01,001);
insert into rezervari values(8,0020,4003,'2021-05-21',5,014,01);
insert into rezervari values(9,0008,4001,'2021-07-12',3,03,01,002);