CHANGELOG.txt

Numbers (#) refer to GitHub issues in project `littlenavmap`.
For example: #3 is https://github.com/albar965/littlenavmap/issues/3.
This text is partially Markdown, hence sometimes strange formatting.

===============================================================================

# Version 1.0.31

## DFD

* Now adding start positions for runways and parking spots to allow departure parking selection.

## X-Plane

* X-Plane 12 manually corrected localizers file is now read.

## MSFS

* Fix for missing aircraft model translations since MSFS SU12.
* Fixed country names appearing as language keys when compiling MSFS. Names are now empty again
  since MSFS does not provide these.
* Corrected detection and reading of Navigraph navdata update in MSFS. Now reading airports from
  update. Navdata and procedures are ignored. The wrongly excluded package is now read. Speed up for
  reading scenery library by ignoring unused procedures from navdata update. #1019
* Fixed issue where MSFS navdata update was recognized despite having its folders excluded.
* More cleanup for MSFS airport names. Now removing space at end and beginning of all names to
  allow search since some airport names are entered wrongly.
* Corrected overzealous filter for MSFS airport dummy structures which removed add-on helipads or
  airports. Example add-on: `willicopta-spital-la-chaux-de-fonds-lsh9` which did not show up.

## Prepar3D

* Added support for Prepar3D v6.

===============================================================================

# Version 1.0.30

## All

* Fixed issue with mapped drives on Windows where add-on airports were not detected when having
  MSFS installed on a mapped drive.
* Now supporting symbolic links, Windows junctions and Windows shortcuts in MSFS `Community` and
  X-Plane `Custom Scenery` folder. Fixed exclude file, exclude directory and exclude add-on
  recognition to consider links.
* Fixed issue where paths were stored with the wrong separators in the database on Windows.
* Now using canonical path to compare scenery library exclusions set from the user interface to
  avoid issues with symbolic links.
* Minor version of database changed to 27 to indicate change in metadata table and parking suffix
  change.
* Windows build is now 64-bit.
* Added option to disable obsolete airport_large and airport_medium tables.

## DFD

* Now populating column ils.loc_width and calculating geometry accordingly. #1011
* Adjusted validation limits for VOR and NDB.

## X-Plane

* Fixed several issues with new X-Plane runway surface types. Fixed dropped runways if they used
  unknown surface types for X-Plane airports. This resulted in airports registered without runways
  and having helipad symbol assigned. Implemented new undocumented asphalt and concrete textures
  found in WED 2.5.
* Removing area/country codes from X-Plane country names now.
* Calculating RNP value now correct for procedures from X-Plane data.
* Fixed remaining issues with macOS aliases. These can now be used in X- Plane `Custom Scenery`.
* Made reading of X-Plane `scenery_packs.ini` more error tolerant for XP12. Now only printing warnings.
* Fixed import and export for X-Plane 11 and 12 `user_fix.dat`. Now allowing null coordinates as well
  exporting and importing waypoint flags and full name. Userpoint tags are used to load and save the
  ID of the airport terminal area and the waypoint type.
* Fixed issue where X-Plane 12 add-on airports were not read from `Custom Scenery`. Airports not
  included in the file `scenery_packs.ini` are now treated like enabled. #927
* Fixed error message when reading XP12 scenery packs file.
* Now falling back to Asphalt for undocumented, unknown or invalid surface types in XP12.

## MSFS

* Adjusted detection of Navigraph package.
* Corrected layer ordering for MSFS scenery library to adhere to priorities in file `Content.xml`.
* Fixed issue where airport city names were missing since MSFS SU11 beta.
* Changed handling for MSFS file `Content.xml` for SU10. Priorities for known base folders are now
  forced to lowest values to ensure the correct loading order. Other folders are loaded without any
  special order.
* Now ignoring waypoints with empty ICAO region code and invalid type as they appear in some MSFS
  add-on sceneries. #910
* Reduced logging for invalid MSFS BGL files.
* Now allowing BGL files from missions to catch respective airports for MSFS.
* Added general properties column to the database metadata table. Now storing in properties if
  navdata update was found for MSFS to allow later database validation.

===============================================================================

# Version 1.0.29

## All

* Minor database version updated to 27 for schema changes.
* Added columns `has_vertical_angle` and `has_rnp` to table `approach`.
* Now renaming output database and adding suffix `BROKEN` to avoid accidental use in case of error.

## X-Plane and DFD

* Added airport transition level for X-Plane and DFD compiler.
* Corrected issues with true course runways like in BGTL for X-Plane and DFD compiler. Approaches
  were missing runway assignments and could not be resolved. #870
* Fixed issues with magnetic variation and inbound course in DFD and X-Plane compiler.
* Holding course is now written as magnetic course to avoid unneeded calculations. This also fixes
  the wrong en-route holding inbound course in Little Navmap.

## X-Plane

* Fixed issue `Index out of bounds: Index: 5, size: 5` when reading X-Plane user_fix.dat with
  optional column missing.
* Now skipping empty X-Plane `apt.dat` files to avoid program freezing in an empty loop for
  malformed files.
* Fixed exception while loading X-Plane scenery library if files `earth_hold.dat`, `earth_mora.dat` or
  `earth_msa.dat` cannot be found in `Custom Data` despite existing fix, nav and airway files.
* Prepared data compilation for X-Plane 12 based on limited information. Added X-Plane 12
  detection. #867
* Fixed database connection leak when compiling X-Plane scenery library.
* Improved transition level and altitude reading for X-Plane since users add various variants.

## MSFS

* Corrected closed airport logic for MSFS. Now fully relying on closed airport flag for MSFS. This
  can result in closed airports having open runways and open airports having all runways open. #876
* Changed handling for MSFS file `Content.xml` for SU10. Priorities for known base folders are now
  forced to lowest values to ensure the correct loading order. Other folders are loaded without any
  special order.
* Now ignoring waypoints with empty ICAO region code and invalid type as they appear in some MSFS
  add-on sceneries. This fixes the exception `NOT NULL constraint failed: tmp_waypoint.region ...`
  when loading. #910
* Now allowing BGL files from missions to catch respective airports for MSFS.
* Community path for MSFS is now optional for detection but will throw an error on loading if missing.
* Added suffix to airport parking.
* Added push request #16 of @flpduarte. Fixed bug in which Little Navmap would only read and
  display a single transition from addon (Community) SIDs and STARs, despite these procedures
  actually having more than one transition. This happens when using the latest MSFS SDK (SU9 or later).
* Added warning messages for encrypted MSFS add-ons when reading scenery library.
* Fixed issue where airport frequencies were written as 0 instead of null for MSFS resulting in
  wrong search results.
* Fixed issue where all airports were recognized as add-on with MSFS update 9.
* Fixed issues for updating airports by disabling a corner case from FSX and P3D which apparently
  does not apply to MSFS. Before a feature was not updated if the new airport did not contain new
  features like aprons or taxiways. Example LICC add-on.
* Reduced logging for invalid MSFS BGL files.

## Build

* Moved version number to variable in file `navdatareader.pro` instead of coding into
  sources. Now writing files `version.txt` and `revision.txt` files into deployment folder allowing
  deployment scripts to automatically name archives.

===============================================================================

# Version 1.0.28

* Navdatareader now exits with failure if basic validation fails.
* Added aircraft category to approach table filled by DFD compiler.
* Added Required Navigation Performance (RNP) field to approach_legs and transition_legs to DFD and
  X-Plane compiler.
* Added compilation of path points to DFD compiler.
* Incremented database version to 23.

===============================================================================

# Version 1.0.27

* Adapted validation to new row numbers for DFD in cycle 2201. This fixes the `idx_boundary_file_id
  already exists` issue.
* Removed exception in table validation. Now only printing a warning if table count does not match.
  This ensures a complete database even if validation finds issues.
* Now keeping indexes when finishing DFD database. This avoids the `preparing database` message in
  Little Navmap when loading the database the first time.

===============================================================================

# Version 1.0.26

## New Features in Database

Airport MSA sectors, enroute holdings, vertical angles in procedures and SBAS/GBAS/RNP/GLS information.

## Notes for Little Navmap versions smaller or equal to 2.6.17

* Additions and fixes should not cause issues and will be fully used in future Little Navmap
  development releases 2.7 as well as stable releases of 2.8.
* GLS paths might incorrctly show up as ILS feathers  but only when using the `Navigraph for all
  Features` scenery selection on DFD compiled databases.
* Airport parking positions can be selected when using `Navigraph for all Features` but are not
  shown on the map.

## All

* Updated database minor version to 22. Database version is now 14.22.
* Changed execution order to allow content checking of table `scripts` in database compiler.
* Changed runway dimension fields in database to floating point to avoid rounding errors with small
  displaced thresholds.
* Now dropping all artificial waypoints created only for procedure or airway resolution from
  nav_search table.

## DFD and X-Plane

* Added compiling of en-route holdings to DFD and X-Plane compiler (new table `holding`).
* Added gate positions to DFD compiler now used in table `parking`.
* Added writing of airport MSA sectors and pre-calculated geometry to DFD and X-Plane compiler.
  Table `airport_msa`. albar965/littlenavmap#498
* Added SBAS/GBAS paths points and stations to X-Plane and DFD databases. Added to table `ils`.
* Added vertical angle to approach and transition legs now read from DFD, X-Plane and MSFS. Column
  `vertical_angle` in tables `approach_leg` and table `transition_leg`. albar965/littlenavmap#803
* Added column `arinc_type` for detailed waypoint information to tables `waypoint` and
  `nav_search`. Populating arinc_type for X-Plane and DFD database compilers.
* Fixed issue where theta and rho in procedures were written as 0 instead of null values in DFD and
  X-Plane compiler. This did not allow to recognize the difference between bearing 0 and bearing not given.
* Fixed issue in DFD compiler where runways with offset threshold were not depicted properly.
* Corrected assignment of runway end ids to ILS in DFD compiler.
* Fixing equal runway end positions for DFD compiler now which resulted in zero-length runways when
  drawing.
* Corrected wrong number of ILS for airports in DFD compiler.
* Fixed issues when resolving recommended procedure fixes in DFD compiler. Now also searching for ILS and other
  approach facilities. albar965/littlenavmap#640

## X-Plane Only

* Fixed issue where runway end table had altitude not set.
* Now skipping empty lines in X-Plane `apt.dat` file header.
* Added X-Plane airport type to airport table.
* Fixed X-Plane scenery compiler wrongly writing ENRT as airport ident for VOR, NDB, waypoints and
  holdings.
* Reading transition altitude from X-Plane airports now.
* Added writing of MORA grid from X-Plane database in data compiler.

## MSFS Only

* Added vertical angle to approach and transition legs. albar965/littlenavmap#803
* Fixed issue in scenery library loader where airports were wrongly recognized as MSFS POI dummies.
* Fixed detection of MSFS Navigraph update due to name change.
* Better error message when failing to read BGL files.
* Enabled new approach type record for MSFS.
* Reduced warnings for unknown BGL records in MSFS to avoid flooding the log with messages when
  reading scenery.
* Fixed issue where runway end table had altitude not set for MSFS.
* Added new record type for airport apron appearing since MSFS SU6 beta. Reading apron structure for
  new MSFS record. Disabled warning about unknown airport record types when compiling MSFS data.
  albar965/littlenavmap#799
* Corrected MSFS dummy POI airport detection. Now ignoring airport closed flag.

===============================================================================

# Version 1.0.25

* Added FAA and local ident columns to airport table for X-Plane loader. Removed xpident column in
  airport table and simplified handling of airport idents. Now always storing ICAO in table if given
  in X-Plane airport metadata. #706
* Adapted MSFS scenery library reader code for procedures to new BGL file structure in MSFS since
  1.18.9. Needed to avoid missing procedures. #735
* Now checking MSFS airports for open runways to work around inconsistencies between closed/not
  closed runways and airport closed flag. Example KODX which has airport closed flag set but an
  open runway.
* Now logging empty or inaccessible XML and JSON files found while scanning for MSFS or P3D scenery
  instead of throwing an exception. #720
* Now computing ARINC approach id (e.g. `I27C`) for all approaches from FSX, P3D and MSFS.
* Database minor version updated to 20.

===============================================================================

# Version 1.0.24

* Corrected airport filter to avoid omitting airport updates when loading FSX/P3D/MSFS scenery.
* Fixed reading of new procedure records in MSFS BGL. Thanks to @icykoneko for the implementation
  and the help. Closes albar965/littlenavmap#649
* Fixed issue where some navaids did not get airport_id assigned if in different BGL file. Now
  resolving id later in database after reading BGLs.
* Added new airspace types MCTR, TRSA and GCA where the last one is for unknown and general
  airspace types. albar965/littlenavmap#607
* Now omitting closed dummy airport structures having no runways which are added as MSFS POIs.
* Write MSFS SIDs and STARs to database
* Changed exception for invalid files in X-Plane CIFP path to warning in log file.
* Now dropping all artificial waypoints created only for procedure or airway resolution from
  nav_search table.

===============================================================================

# Version 1.0.23

* Fixed error when reading procedures with invalid or unknown approach types from FSX, P3D and MSFS.
  Now logging error instead.
* Added verbose logging for X-Plane compiler based on navdatareader.cfg. Added warnings if rows are
  not written to the database.
* Now also including MSFS scenery with content type `CORE`.
* Now skipping maintenance.bgl file in MSFS scenery library which causes error messages when
  loading scenery library.
* Airport names now loaded from base scenery with Navigraph update in MSFS. Were missing previously.
* Now omitting scenery library entries which are marked with active=`false` in Content.xml for MSFS.

===============================================================================

# Version 1.0.22

* Stable version
* Excluding Navigraph manifest file now to avoid error messages with package "navigraph-maintenance"
  when reading MSFS scenery data.
* Limited localizer width to 20 degree to avoid excessive values from FSX and MSFS breaking ILS geometry.

===============================================================================

# Version 1.0.21.beta

## Related notes from atools Version 3.6.3.beta and 3.6.4.beta

* Fixed issue with missing longest runway surface for airports with MSFS.
* Now imitating the behavior of MSFS if an scenery update tries to reuse the ident of an airport
  for a new one. Example: Boyd Field (54XS) in MSFS which actually Bar C Ranch Airport (54XS) in
  real life at another location.
* Fixed issue where military airports were not recognized in add-ons.
* Adjusted detection of MSFS Navigraph navdata update to avoid all airports being detected as add-on.

===============================================================================

# Version 1.0.20.beta

## Related notes from atools Version 3.6.2.beta

* Fixed issue where program could appear frozen while counting files for loading scenery.
* Fixed detection for military airports in MSFS and extended this with new phrases.
* Now capitalizing all airport names for FSX, P3D and MSFS to fix wrong airbase designators
  like  `Afb`.
* Fixed issue with NOAA weather downloads where a missing internet connection flooded the log and
  caused the program to crash. Now applying a grace period of three minutes after an error which
  blocks new downloads for METAR requests.
* Removed wrong rounding of COM frequencies.
* Now checking for all paths `Community`, `fs-base` and `fs-base-nav` before recognizing a MSFS
  installation as valid.
* `asobo-airports-*` in `Official\Steam` or `Official\OneStore` are now flagged as add-on.

===============================================================================

Version 1.0.19.beta

Related notes from atools Version 3.6.1.beta

MSFS:

* Fixed issue with `NOT NULL constraint failed:tmp_waypoint.ident Unable to fetch...`.
  Navids with empty names are now ignored and printed into the log with BGL file name.
* Changed default MSFS Steam flight plan path to base folder `Microsoft Flight Simulator`.
* Localizer heading for MSFS now saved correctly in scenery database.
* Also looking in `OneStore` and `Steam` folder for add-ons now.
* Updating administrative names in airports now if missing in update. This also corrects missing
  names for the Navigraph navdata update.
* Adapted to Navigraph navdata update 12 for MSFS.
  Updating only needed features which are airports, COM and ILS. Everything else is ignored and not
  needed since it can be updated directly for Little Navmap.
* Corrected ILS course for Navigraph update in simulator. Slight variations like for EDDM remain.

Other:

* Airports with empty names now raise an exception which will show an error dialog to the user.
* Removed unneeded indexes from tables `nav_search` and `taxi_path` to shrink database.
* Updated to world magnetic model 2020. This will be used to calculate X-Plane declination when
  loading the scenery database.
* Fixed issue where declination was not created correctly for locale which do not have a . as
  decimal separator. This is due to functions in WMM code. As a result of the issue declination was
  20 degrees off near VORDME STN in X-Plane, for example. #564
* Removed unused delete_airport table to speed up loading and to keep database small.
* Now capitalizing airport, city, state and country names when loading FSX, P3D or MSFS data.

Related notes from atools Version 3.6.0.beta

Scenery Database:

* Full MSFS scenery library support with simulator detection.
* Progress for scenery database loading with FSX/P3D, X-Plane and DFD reworked to avoid
  under- or overflow and to have a more balanced progress rate.
* Fixed issues with user home folders containing special characters. This caused various
  issues when detecting flight simulators.
* Added more invalid taxiway names like `_` to avoid in X-Plane.


Other, technical, internal or development related:

* Updated file roller to allow usage of file rename patterns.
* Updated logging for separate debug message and narrow patterns which remove namespaces from class
  and paths from filenames for better readability.

===============================================================================

Version 1.0.18

All changes from atools version 3.4.7.
Mostly fixes for DFD and other data compilers.

All data compilers and schema changes:
* Updated database minor version to 18 to reflect changes.
* Fixed issue with duplicate waypoints in airways for DFD, X-Plane and FSX/P3D compiler causing
  defects in airway network. Examples: MY/EK and SYA/PA. #516
* Added flag "artificial" for NDB and VOR waypoints which are created to simplify
  airway construction. Useful for debugging or future versions. #516

DFD:
* Updated DFD compiler to create new and separate UIR FIR airspace types besides the old
  deprecated center with "(FIR)" or "(UIR)" in the name. These new types will be used by the next
  Little Navmap version. Current versions 2.4.X are compatible with this change and show
  the old centers. #462
* Fixed issue where runway ends with more than one ILS had all except one detached from runway.
  Example: EDDF RWY25R ILSZ IFNW. #532
* Coordinates for fix and recommended fix in procedure tables added. Used for better navaid
  resolution in next Little Navmap version. #205
* Adding artificial waypoints to allow procedure fix resolution in LNM versions <= 2.4.5 in DFD databases.

X-Plane:
* Improved removal of "[X]" prefixes in X-Plane and fixed issue where military airports were not
  detected in all cases.
* Changed airport ident to ICAO code for X-Plane compiler now. XP internal ids are now avoided
  except in duplicates. Added xpident to airport table which keeps the internal ID for
  X-Plane airports. #448
* Added runway smoothness and airport flatten flags from X-Plane to database schema.
* Corrected navaid range calculation for X-Plane. 125 NM is now treated as unpublished.

P3D:
* Fixed issue with P3D v5 not loading tower, unicom and other frequencies for all airports.
  As a result all airports are shown in magenta color.

===============================================================================

Version 1.0.17

P3D v5: #512
* Added P3D v5 for simulator detection.
* Adapted loading of BGL files to P3D v5 structure changes and added new records as well as new COM
  and other types.
* Enabled loading of add-on packages from `%USERPROFILE%\Documents\Prepar3D v5 Add-ons`.

===============================================================================

Version 1.0.16

DFD:
* Added route type (RNAV, official, etc.) to airway tables. albar965/littlenavmap#466

===============================================================================

Version 1.0.15

All:
* Added IATA and ICAO code to airport tables. These are populated in the X-Plane and DFD compiler.
* Added geomagnetic model calculation. Changed X-Plane and DFD compiler to save
  declination based on current year and month into database. albar965/littlenavmap#300
* Fixed parsing issue with coordinates when using C locale.
* Added debug output to log for scenery configuration when loading scenery libraries.
* Database minor version up to 15 for compatible schema changes.

X-Plane:
* Added real ICAO code to airport to circumvent issues with X-Plane artificial airport ids which are
  kept in column ident.
* Set codec to UTF when reading X-Plane and weather files.
* Added support for gui_label 3D attribute in X-Plane 11.35 and higher. Updated rating calculation.
  albar965/littlenavmap#424
* Fixed error in rating calculation function for X-Plane. albar965/littlenavmap#410
* Added support for X-Plane 8.33 kHz frequency spacing. albar965/littlenavmap#409

FSX and P3D:
* Fixed issue where scenery entries were read despite being disabled in add-ons.cfg for P3D.
* Discovery paths from add-ons.cfg are now read for P3D.
* Removed logging banners inflating log unnecessarily when loading P3D or FSX scenery library.
* Fixed crash that appears when using fsAerodata cycle 1905r1 or later. albar965/littlenavmap#413
* Better error handling and reporting around "magdec.bgl" file and database. Now falling back to WMM
  if file could not be read.

Build and Deployment for Developers: albar965/littlenavmap#387
* Updated for Qt 5.12.4. Changed OpenSSL to 1.1.1.
* Linux compilation now uses system OpenSSL again and is based on Ubuntu 18.04.
* Complete update of project files to allow configuration with environment variables. Removed all hard coded paths.
* Added documentation about environment variables to configure build and updated build instructions
  in "BUILD.txt" and "atools.pro" files.

===============================================================================

Version 1.0.14

related from atools version 3.4.2.beta
See CHANGELOG.txt in atools project for more technical details. Relevant comments were added to list above.

===============================================================================

Version 1.0.13

* Added geomagnetic model calculation based on current year and month where resulting table is written into database.
  This applies to the DFD and X-Plane compiler.

Build and Deployment for Developers: albar965/littlenavmap#387
* Updated for Qt 5.12.4.
* Linux compilation now based on Ubuntu 18.04.
* Complete update of project files to allow configuration with environment variables. Removed all hardcoded paths.
* Added documentation about environment variables to configure build and updated build instructions
  in "BUILD.txt" and "navdatareader.pro" files.

related from atools version 3.4.0.beta
See CHANGELOG.txt in atools project for more technical details. Relevant comments were added to list above.

Version 1.0.12

* Added validation rule for mora_grid table. albar965/littlenavmap#84.

from atools version 3.0.4
* Database minor version updated to 12.
X-Plane:
* X-Plane parking positions are now at correct coordinates. albar965/littlenavmap#256
* Now reading "scenery_packs.ini" for X-Plane to allow disabling of scenery by
  tools. albar965/littlenavmap#151
DFD/X-Plane:
* Added "arinc_descr_code" to database that allows to identify IAF, MAF and FAF. albar965/littlenavmap#196
DFD:
* Added "multiple_code" and "time_code" columns to schema to indicate overlapping
  airspaces. albar965/littlenavmap#279
* Added "mora_grid" table for minimum off route altitude data to schema. DFD compiler
  now populates "mora_grid" table. albar965/littlenavmap#84
* Added restrictive_designation and restrictive_type to boundary table and DFD compiler.
* Refactoring in cleanup in logging system. Log files can now be rotated if a given size is
  exceeded. albar965/littlenavmap#275
* Now populating airport_id in tables vor, ndb and waypoint. albar965/littlenavmap#289

Version 1.0.11

* Updated magnetic variation file to 1801.

Version 1.0.10

* Updated from Qt 5.9.3 to 5.9.5

from atools version 3.0.0.beta
DFD/X-Plane:
* Fixed issue where approach name and/or suffix were not read correctly in X-Plane and DFD compiler.
* Fixed error with duplicate VOR/NDB waypoints in DFD compiler.
* Now ignoring artificial circle-to-land approaches in DFD compiler.
FSX/P3D:
* Added script by Gérard to clean out fake runways for AI in FSX/P3D.
* Added logging for airport altitude when reading delete records from FSX/P3D.
  Example: "Add-on airport altitude for VQ10 changed from 7703 ft (BGL Scenery/0902/APX72220.bgl) to 8363 ft"
* Improved BGL file and scenery reading to include hidden and system files.

Version 1.0.9

from atools version 2.8.7
* Now updating magnetic declination for VOR with calculated value where missing.

Version 1.0.8

from atools version 2.8.6
* Custom Scenery/Global Airports/Earth nav data/earth_nav.dat is now read to get fixed ILS for X-Plane. #209
* Fixed reading of ILS for non consecutive entries in X-Plane dat file. #209
* Corrected wrong runway heading from DFD compilation. #214
* SID and STAR common routes are now merged correctly into procedures for DFD and X-Plane compiler. #193
* Airport idents from DFD compilation are now all converted to original three-letter code if available. #203
* Added new columns runway_end.altitude, approach_leg.approach_fix_type and transition_leg.approach_fix_type
  for future use.
* Updated database minor version to 9.

Version 1.0.7

* Updated from Qt 5.9.1 to 5.9.3
* Now removing any stale output databases to avoid accidental file merge.

from atools version 2.8.5
* Fixed errors when compiling the X-Plane database with PRDAT records in CIFP files since AIRAC 1801. albar965/littlenavmap#202
* Fixes for missing airway segments in DFD compiler.
* Fixed overly eager de-duplication of waypoints. albar965/littlenavmap#201

Version 1.0.6

Although adapted to small schema changes Little Navmap is still compatible with old databases.

from atools version 2.8.4
* Column "arinc_name" in table "approaches" is now filled with TRANS_IDENT for SID and STAR to get runway
  information for multiple or all. Needed for future fixes of albar965/littlenavmap#179.
* Added new columns "region" and "is_3d" (X-Plane) in airport table. Adapted all compilers to fill these.
* Database minor version bumped up to 8 which is an indication for schema changes but still compatible.
* Number of ALS is now correctly assigned to airports in X-Plane data compiler.
  This resulted in many airports having an ALS indication where none is.

Version 1.0.5

* No changes except version.

1.0.4.beta

* Adjusted basic validation for new results after fixes in atools.

from atools version 2.8.2.beta

* DFD compiler now estimates if holding is given in time or distance for procedure legs.
* DFD compiler now always sets region for fixes where it was missing for procedure legs.
* Solved problem where fix was not set for DME distance and radial terminated procedure legs.
  Now copying recommended fix to avoid invalid procedures.

1.0.3.beta

* Calculating range from NDB navaid_class now.
* Basic validation values are now more precise for DFD compilation.
* Fixed logging configuration to produce separate error and warning log now.
* DFD compiler now estimates if holding is given in time or distance for procedure legs.
* DFD compiler now always sets region for fixes where it was missing for procedure legs.
* Solved problem where fix was not set for DME distance and radial terminated procedure legs. Now copying recommended fix.

1.0.2.beta

* Updated manual re. error reporting and compilation failure.
* Program now fails on all kind of errors with return code 1.

from atools version  2.8.0.beta
* Fixed crash when getting simulator base path for unknown simulator type.

1.0.1.beta

* All indexes are dropped after compilation now to save download bandwidth.
  Indexes are created again by Little Navmap on first database usage on the client's side.
* Small fixes in logging where messages went to stderr where they shouldn't.
* Added DropAllIndexes option in configuration file.
* Extended database metadata with optional compiler_version, valid_through and data source columns.
* Increased database minor version to 6.

from atools version 2.8.0.beta

* Finished DFD to Little Navmap database compiler for Navigraph data. #126
* Added script table and option to store create index scripts in that table for preparation by the client. #126
* Added option to drop indexes after database creation to keep the file small.
* Vacuum and analyze option for database creation now defaults to true to get smaller and better organized files. #126
* Fixed error with wrong ILS pitch in X-Plane compiler.
* Disabling maximum airway segment length now for data sources that contain a valid airspace geometry
  (X-Plane and DFD - FSX/P3D contain invalid segments).
* Fixed several problems with bounding box and overlap calculations around the anti meridian.
* Better handling of X-Plane OpenAirspace comments and fixed problem where airspace names contain a comment character.

1.0.0.beta

* Updated database metadata.
* Fixes for bounding box calculation around the anti meridian.

changes from atools 2.7.0.develop:
* Finished DFD compiler
* Disabling maximum airway segment length for data sources that contain a valid airspace geometry
  (X-Plane and DFD - FSX/P3D contain invalid segments).
* Extended database metadata with optional compiler_version, valid_through and data source columns.
* Better handling of X-Plane OpenAirspace comments and fixed problem where airspace names contain a comment character.
* Fixed problems with bounding box and overlap calculations around the anti meridian.

0.9.9.develop

* Added manual
* Support for DFD and X-Plane databases
* Cleanup in option parsing and better error handling

See atools CHANGELOG.txt for more compiler related changes and fixes

0.9.4.develop

* Removed boundary_line table and pre-calculate boundary geometry now which ist stored as binary data.
* Bumped database version up for changed schema.
* Changed ILS to runway assignment logic to fix ILS data updates.
* Added still unused columns in database for speed limit, airway direction and other extensions for future AIRAC support.
* Added option for two external databases besides the real simulators.

0.9.3.develop

* Several fixes when reading airspace boundaries.
* Added missing indexes to boundary table.
* Fixed reading of airspace boundaries and removed hack.
* Reduced size of airspace enums in database.
* Fixed old problem with empty registry entries when detecting simulator

0.9.2.develop

* Solved problem where airports without delete record lost approaches.
* Cleanup in database around transitions and approaches:
** Navaid ids have to be resolved during runtime now and not during compilation time.
** Fix for multiple navaids with the same name and same region in the database.
** Added more redundant information to runway end table to speed up program during runtime.
* Now nearest VOR and NDBs are assigned to waypoint if duplicates exist.
* Fixed reading of airspace boundary bgl files and reduced string field sizes.

0.9.1.develop

* Initial development version.
* Fixed deploy for Windows
* Fixed error opening database
* Disable foreign keys