Skip to content

Instantly share code, notes, and snippets.

Avatar
🤖
Building something amazing.

David Saint david-saint

🤖
Building something amazing.
View GitHub Profile
@tanerdogan
tanerdogan / airports.sql
Created Apr 8, 2014
airports.sql - airport list (total 8800 airport)
View airports.sql
This file has been truncated, but you can view the full file.
DROP TABLE IF EXISTS `airports`;
CREATE TABLE IF NOT EXISTS `airports` (
`code` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
`name` varchar(200) COLLATE utf8_turkish_ci DEFAULT NULL,
`cityCode` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
`cityName` varchar(200) COLLATE utf8_turkish_ci DEFAULT NULL,
`countryName` varchar(200) COLLATE utf8_turkish_ci DEFAULT NULL,
`countryCode` varchar(200) COLLATE utf8_turkish_ci DEFAULT NULL,