mirror of
https://github.com/Ekokumppanit/Lentolaskuri.git
synced 2026-01-26 11:13:58 +00:00
b0258437cd
- Made the application more configurable by the user - Made installation easier - API location is now dynamic based on window.location - Cleaned up some older code that was pointing to dev stuff - Now includes the SQL-table required to run the application - Application now exposes config to console for easier debugging - Search now supports user specified table name - Updated the OpenFlights airport data file source
12 lines
416 B
SQL
12 lines
416 B
SQL
CREATE TABLE IF NOT EXISTS `airports` (
|
|
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(200) NOT NULL,
|
|
`city` varchar(200) NOT NULL,
|
|
`country` varchar(200) NOT NULL,
|
|
`iata` varchar(4) NOT NULL,
|
|
`icao` varchar(4) NOT NULL,
|
|
`lat` float NOT NULL,
|
|
`long` float NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
FULLTEXT KEY `SEARCH` (`name`,`city`,`country`,`iata`)
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |