Database structure change from version 1.17
Posted: 04 Mar 2014, 11:16
From release 1.17 there will be some changes in database structure:
TxPwr and RxPwr fields will be removed from newly deployed databases, and replaced with TxPwrDecimal and RxPwrDecimal (both fields will store DECIMAL fields). This limitation is due to the limitation in sqlite to REMOVE fields and CHANGE fields data structure (from INT to DECIMAL should be possible, but it's not supported).
They should not be used anymore.
New fields will be added (some are not used yet):
ClubLogQsoUploadDate
ClubLogQsoUploadStatus
HrdlogQsoUploadDate
HrdlogQsoUploadStatus
MyFists
MySotaRef
MyUsacaCounties
MyVuccGrids
AwardSubmitted
AwardGranted
Fists
FistsCc
QrzcomQsoUploadDate
QrzcomQsoUploadStatus
RxPwrDecimal
Skcc
SotaRef
SubMode
TxPwrDecimal
UsacaCounties
VuccGrids
QsoAwards
TxPwr and RxPwr fields will be removed from newly deployed databases, and replaced with TxPwrDecimal and RxPwrDecimal (both fields will store DECIMAL fields). This limitation is due to the limitation in sqlite to REMOVE fields and CHANGE fields data structure (from INT to DECIMAL should be possible, but it's not supported).
They should not be used anymore.
New fields will be added (some are not used yet):
ClubLogQsoUploadDate
ClubLogQsoUploadStatus
HrdlogQsoUploadDate
HrdlogQsoUploadStatus
MyFists
MySotaRef
MyUsacaCounties
MyVuccGrids
AwardSubmitted
AwardGranted
Fists
FistsCc
QrzcomQsoUploadDate
QrzcomQsoUploadStatus
RxPwrDecimal
Skcc
SotaRef
SubMode
TxPwrDecimal
UsacaCounties
VuccGrids
QsoAwards