-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathmySQL_database_data.txt
More file actions
23 lines (12 loc) · 9.93 KB
/
Copy pathmySQL_database_data.txt
File metadata and controls
23 lines (12 loc) · 9.93 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
INSERT INTO `airline` VALUES (1,'OK','Czech Airlines','Czech Republic'),(2,'DL','Delta Air Lines','United States'),(3,'EW','Eurowings','Germany'),(4,'MU','China Eastern Airlines','China'),(5,'BA','British Airways','United Kingdom');
INSERT INTO `airport` VALUES (1,'Guangzhou Baiyun International Airport','China','Guangdong','Guangzhou'),(2,'Hartsfield–Jackson Atlanta International Airport','United States','Georgia','Atlanta'),(3,'Chengdu Shuangliu International Airport','China','Sichuan','Chengdu'),(4,'Dallas/Fort Worth International Airport','United States','Texas','Dallas'),(5,'Shenzhen Bao\'an International Airport','China','Guangdong','Shenzhen'),(6,'Chongqing Jiangbei International Airport','China','Chongqing','Yubei'),(7,'Beijing Capital International Airport','China','Beijing','Beijing'),(8,'Denver International Airport','United States','Colorado','Denver'),(9,'Kunming Changshui International Airport','China','Yunnan','Kunming'),(10,'Shanghai Hongqiao International Airport','China','Shanghai','Shanghai'),(11,'Xi\'an Xianyang International Airport','China','Shaanxi','Xianyang'),(12,'Tokyo Haneda Airport','China','Tokyo','Tokyo'),(13,'O\'Hare International Airport','United States','Illinois','Chicago'),(14,'Shanghai Pudong International Airport','China','Shanghai','Shanghai'),(15,'Los Angeles International Airport','United States','California','Los Angeles'),(16,'Indira Gandhi International Airport','India','Delhi','Delhi'),(17,'Hangzhou Xiaoshan International Airport','China','Zhejiang','Hangzhou'),(18,'Charlotte Douglas International Airport','United States','North Carolina','Charlotte'),(19,'Dubai International Airport','United Arab Emirates','Dubai','Dubai'),(20,'Istanbul Airport','Turkey','Istanbul','Istanbul'),(21,'Charles de Gaulle Airport','France','Île-de-France','Paris'),(22,'Heathrow Airport','United Kingdom','London','London'),(23,'Mexico City International Airport','Mexico','Mexico City','Mexico City'),(24,'Phoenix Sky Harbor International Airport','United States','Arizona','Phoenix'),(25,'Tan Son Nhat International Airport','Vietnam','Ho Chi Minh City','Ho Chi Minh City'),(26,'Orlando International Airport','United States','Florida','Orlando'),(27,'Zhengzhou Xinzheng International Airport','China','Henan','Zhengzhou'),(28,'Jeju International Airport','South Korea','Jeju Province','Jeju City'),(29,'Amsterdam Airport Schiphol','Netherlands','North Holland','Haarlemmermeer'),(30,'São Paulo/Guarulhos International Airport','Brazil','Guarulhos','Guarulhos'),(31,'Seattle–Tacoma International Airport','United States','Washington','SeaTac'),(32,'Nanjing Lukou International Airport','China','Jiangsu','Nanjing'),(33,'Sheremetyevo International Airport','Russia','Moscow Oblast','Khimki'),(34,'Changsha Huanghua International Airport','China','Hunan','Changsha'),(35,'Frankfurt Airport','Germany','Hesse','Frankfurt'),(36,'Miami International Airport','United States','Florida','Miami'),(37,'George Bush Intercontinental Airport','United States','Texas','Houston'),(38,'Gimpo International Airport','South Korea','Seoul','Seoul'),(39,'Madrid Barajas Airport','Spain','Madrid','Madrid'),(40,'Istanbul Sabiha Gökçen International Airport','Turkey','Istanbul','Istanbul'),(41,'Xiamen Gaoqi International Airport','China','Fujian','Xiamen'),(42,'Suvarnabhumi Airport','Thailand','Samut Prakan','Bang Phli'),(43,'John F. Kennedy International Airport','United States','New York','New York'),(44,'Guiyang Longdongbao International Airport','China','Guizhou','Guiyang'),(45,'Haikou Meilan International Airport','China','Hainan','Haikou'),(46,'Fort Lauderdale–Hollywood International Airport','United States','Florida','Broward County'),(47,'San Francisco International Airport','United States','California','San Mateo Country'),(48,'Moscow Domodedovo Airport','Russia','Moscow Oblast','Domodedovo'),(49,'Beijing Daxing International Airport','China','Beijing','Beijing'),(50,'Newark Liberty International Airport','United States','New Jersey','Newark');
INSERT INTO `baggage` VALUES (1,3.25,1),(2,2.13,1),(3,5.58,2),(4,3.07,2),(5,7.17,4);
INSERT INTO `baggage_check` VALUES (1,'OK',NULL,1),(2,'OK',NULL,2),(3,'OK',NULL,3),(4,'PENDING','found fruit and vegetable',4),(5,'FAILED','not proper type of baggage',5);
INSERT INTO `boarding_pass` VALUES (1,'lapsingw5vhj59i8h2xd'),(2,'6fea8nhpz0q3a5c82d5e'),(3,'qb5c6az8b5q3y6s5d8bb'),(4,'33agrtmhfcqb5c6az8b5'),(5,'6adcvbttrfasf58ecvbg'),(6,'saf5e8asc2ert9vfastg'),(7,'dalgfivclst58x6v2f4a');
INSERT INTO `booking` VALUES (1,'confirmed','booking.com','2021-02-07 23:00:00','2021-02-07 23:00:00',7,1),(2,'confirmed','booking.com','2021-06-23 19:59:30','2021-06-24 06:22:30',8,2),(3,'pending','booking.com','2021-11-01 21:35:27','2021-11-01 21:35:27',39,3),(4,'confirmed','booking.com','2021-08-02 23:22:04','2021-08-02 23:22:04',16,4),(5,'cancelled','booking.com','2021-08-09 10:21:30','2021-09-01 15:12:30',3,5),(6,'confirmed','booking.com','2021-12-01 22:25:27','2021-12-01 22:25:27',9,6),(7,'confirmed','booking.com','2021-09-03 09:22:04','2021-09-03 09:22:04',10,7);
INSERT INTO `booking_has_flights` VALUES (1,1),(2,2),(4,3),(6,4),(7,5);
INSERT INTO `covid_certificate` VALUES (1,'URN:UVCI:01:CZ:EHSU2S4F8YYYQVKMW5DF7BDYGEACB9D2','YES',1),(2,'URN:UVCI:01:CZ:EHSU2SAFKLMSDNFNA5DF7BDYGEASASCVE','YES',6),(3,'URN:UVCI:03:CZ:ASDJKLNKMNASMNDKW5DF7BDYGEASPXIQ2','YES',7),(4,'URN:UVCI:11:CZ:EHSWASDMNWAMNIXKWJA7BDYGEASA3Q5','NO',13),(5,'URN:UVCI:05:CZ:EHSU2S4F8YYYQVKMW5DASDAWKJJSKWJS','YES',8);
INSERT INTO `flights` VALUES (1,'J44','A13',1,9,2),(2,'C23','B19',6,7,3),(3,'B1','A8',34,20,4),(4,'C5','A1',1,2,5),(5,'A7','A2',14,34,4);
INSERT INTO `no_fly_list` VALUES (1,'2020-03-15','2120-03-15','suspected member of terorist organization',43),(2,'2017-07-19','2117-07-19','member of terorist organization',28),(3,'2003-01-01','2006-01-01','insulting other passangers during flight',38),(4,'2005-11-12','2010-11-12','damaging airline seats during flight',40),(5,'2011-12-11','2051-12-11','dangerous criminal',46);
INSERT INTO `passenger` VALUES (1,'Pavel','Ostrý','2001-03-21','Czech Republic','Czech Republic','16851250'),(2,'Karolína','Kopřivová','1984-10-06','Czech Republic','Czech Republic','95723548'),(3,'Věra','Štarhová','1989-04-25','Czech Republic','Czech Republic','68745135'),(4,'Marie','Hrbáčová','1939-04-01','Czech Republic','Czech Republic','54862418'),(5,'Tereza','Kadlečková','1953-02-06','Czech Republic','Czech Republic','85245600'),(6,'Michael','Dohnal','1990-02-22','Czech Republic','Czech Republic','21557896'),(7,'Aleš','Mach','1955-08-19','Czech Republic','Czech Republic','78965412'),(8,'Pavel','Mach','1982-03-08','Czech Republic','Czech Republic','35412856'),(9,'Leona','Ottová','1996-11-22','Czech Republic','Czech Republic','32165485'),(10,'Elena','Juráková','1985-12-06','Czech Republic','Czech Republic','84563572'),(11,'Rostislav','Bartík','1979-07-15','Czech Republic','Czech Republic','55588866'),(12,'Helena','Štorkánová','2009-12-04','Czech Republic','Czech Republic','65488749'),(13,'Marie','Petrželová','1973-10-25','Czech Republic','Czech Republic','35445123'),(14,'Miroslav','Bošek','1978-09-13','Czech Republic','Germany','65485521'),(15,'Miroslav','Černý','1996-07-07','Czech Republic','Canada','33215789'),(16,'Jiřina','Hermanová','2007-06-29','Czech Republic','Brazil','54877862'),(17,'David','Novák','1997-04-20','Czech Republic','France','24158796'),(18,'František','Marek','1969-02-21','Czech Republic','Austria','95632157'),(19,'Monika','Pechanová','1997-12-14','Czech Republic','Estonia','22115588'),(20,'Michala','Jeriová','1990-07-05','Czech Republic','Tunisia','35125870'),(21,'Louis','Eusebio','1971-03-03','United States','United States','57803651'),(22,'Toya','Benally','1965-05-27','United States','United States','45122500'),(23,'Katie','Raymond','1989-04-12','United States','United States','32521356'),(24,'Christiana','Summerfield','1995-06-11','United States','United States','65488004'),(25,'Marry','Puccio','2003-12-21','United States','United States','54009573'),(26,'Larry','Crowley','2005-06-09','United States','United States','65248900'),(27,'James','Jones','1987-11-16','United States','Poland','20062048'),(28,'Ed','Jason','1963-07-03','United States','Tunisia','65002587'),(29,'Eugine','Conrad','1988-09-11','United States','Sweden','97060842'),(30,'John','Houston','1998-11-04','United States','Switzeland','03654028'),(31,'George','Savage','1983-11-05','United States','United Kingdom','60054826'),(32,'Elliot','Reyes','1982-08-22','United States','Belgium','89632175'),(33,'Neil','Harris','1958-10-28','United States','Brazil','00585200'),(34,'Edward','Bray','1974-01-23','United States','Austria','65090275'),(35,'Manuela','Nagel','1957-10-03','Germany','Germany','15589635'),(36,'Thomas','Fenstermacher','1996-05-05','Germany','Germany','32896540'),(37,'Uta','Farber','2006-07-13','Germany','Germany','59674005'),(38,'Sussane','Eggers','1954-02-22','Germany','Germany','68000528'),(39,'Marco','Friedman','1952-12-23','Germany','Germany','20080540'),(40,'Marcel','Gerste','1992-09-26','Germany','Germany','97080506'),(41,'Monika','Herzog','1969-03-21','Germany','Germany','56984000'),(42,'Swen','Seiler','1980-04-18','Germany','Czech Republic','00580548'),(43,'Philipp','Herman','1949-06-16','Germany','Poland','50487365'),(44,'Vanessa','Kaufmann','1963-08-02','Germany','Estonia','60154780'),(45,'Kristian','Voglet','1967-03-27','Germany','Finland','02459024'),(46,'Sabrina','Fuerst','1994-02-23','Germany','France','06900582'),(47,'Lena','Hertzog','1998-05-19','Germany','Spain','99085460'),(48,'Florian','Neudorf','1991-09-20','Germany','Sweden','30069087'),(49,'Leon','Gerste','1957-11-01','Germany','Portugal','30685420'),(50,'Ralph','Kastner','1966-02-12','Germany','Italy','56804569');
INSERT INTO `security_check` VALUES (1,'OK',NULL,'2021-10-31 23:00:00','2021-10-31 23:00:00',7),(2,'OK',NULL,'2021-10-28 22:00:00','2021-10-28 22:00:00',8),(3,'OK',NULL,'2021-10-19 22:00:00','2021-10-19 22:00:00',16),(4,'OK',NULL,'2021-10-06 22:00:00','2021-10-06 22:00:00',9),(5,'OK',NULL,'2021-10-24 22:00:00','2021-10-24 22:00:00',10);