openflights/sql at master · sunny0183/openflights

Name		Name	Last commit message	Last commit date
parent directory ..
README.md		README.md
airlines-upgrade.sql		airlines-upgrade.sql
airports-upgrade.sql		airports-upgrade.sql
clean-duplicate-airlines.sql		clean-duplicate-airlines.sql
clean-duplicate-planes.sql		clean-duplicate-planes.sql
create.sql		create.sql
delete-user.sql		delete-user.sql
docker-seed.sh		docker-seed.sh
find-duplicate-airports.sql		find-duplicate-airports.sql
import-arm.sql		import-arm.sql
load-data.sql		load-data.sql
load-other-airport-dbs.sql		load-other-airport-dbs.sql
locales.sql		locales.sql
merge-airports.sql		merge-airports.sql
mysql.sh		mysql.sh
top10.sql		top10.sql
update-demo.sql		update-demo.sql

README.md

create.sql - Create an empty OpenFlights database schema
import-arm.sql - Import and sync a fresh copy of Airline Route Mapper (ARM) data
load-data.sql - Import airlines.dat, airports.dat and routes.dat into the OpenFlights database
load-other-airport-dbs.sql - Import DAFIF and OurAirports; useful but not needed by site

merge-airports.sql - Called by merge-airports.sh for manual merging for duplicate ICAO codes
top10.sql - Generate nightly "Top 10" lists (>data/top10.dat)
update-demo.sql - Update flights for "demo" user