Data Base Revisioning

When the structure of the data base changes MacLoggerDX does the following when it opens or merges an older version log file:

Creates a backup of the existing log with .v007_backup001.sql appended to the original file name in the same folder. The appended text shows which version of the log db was backed up and how many backups there are. You will only need this backup if you decide to go back to the earlier version of MacLoggerDX.
Renames the old table qso_table to qso_table_v00n (Where n is the new version).
Creates a new table, based on the old table but with the updated structure and name.
Copies the old data into the new table.
Drops the old table.
The new log file will not be usable with older versions of MacLoggerDX but the backup can be.
The new log file will not be usable with MacLoggerDX HD for iPad until it is updated, but v007 files downloaded from the iPad can be upgraded and read on the desktop.

This should all happen transparently to the end user but those of you who are using 3rd party tools to access the database will notice that after you open a log, the old qso_table_v007 has been converted to the latest qso_table_v008.

Data Base Version	MacLoggerDX Version	Table Name	Schema Change
001	Version 5.00	qso_table	Original
002	Version 5.15	qso_table_v002	Fixed power, srx_numeric, stx_numeric and dxcc_id names
003	Version 5.16	qso_table_v003	Fixed qso_start and qso_done GMT offset for DST
004	Version 5.49	qso_table_v004	Added SOTA
005	Version 5.49	qso_table_v005	Added My SOTA
006	Version 5.57	qso_table_v006	Added SKCC
007	Version 5.60	qso_table_v007	TX_PWR (power) changed from integer to real (milliwatts)
008	Version 6.45	qso_table_v008	Added POTA, WWFF, SIG etc.

Notes for 3rd party report generators:

time_on and time_off are stored as the number of seconds UTC since January 1, 1970 (plus or minus).
if time_off is more than 24 hours before or after time_on MacLoggerDX V5.17 and later will display the time_on value (the default) for time_off.