salix/db/routines/vn2008/views/flight.sql

CREATE OR REPLACE DEFINER=`root`@`localhost`
	SQL SECURITY DEFINER
	VIEW `vn2008`.`flight` 
AS SELECT
	`f`.`id` AS `flight_id`,
	`f`.`duration` AS `duration`,
	`f`.`flightPath` AS `route`,
	`f`.`days` AS `days`,
	`f`.`airlineFk` AS `airline_id`,
	`f`.`airportArrivalFk` AS `airport_out`,
	`f`.`airportDepartureFk` AS `airport_in`
FROM
	`vn`.`flight` `f`;