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 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.
- ext_val_1 is my_country.
- ext_val_2 is my_state.
- ext_val_3 is postal_state.