Skip to content

Releases: kbrbe/GeoNames-MySQL-DataImport

Version 0.1.1

16 Apr 12:05
e7c4482

Choose a tag to compare

Added

  • A new composite key to speed up query performance (kbrbe/geonames-lookup#7). This change was applied in February, but is only commited now

Changed

  • Calling script to create indexes and DB schema improvements not only for create-db action, but also for create-tables action in bash and bat script
  • New DB schema improvements script is automatically called when setting up the database (#1)

Version 0.1.0

17 Feb 14:31

Choose a tag to compare

This first version adapts the fork compared to the original.

Added

  • The file geonames_db_index.sql will add indexes (it will be called during the installation)

Changed

  • secrets are stored in an environment file that will be used by the geonames_importer.sh script. Thus you have to create a .env file with variables as shown in example.env (Easist is that you copy example.env and adapt the MySQL connection information)
  • Adding declarations of primary keys in geonames_db_struct.sql