--Reset_SideList_Born_Died_Widths-RM8.sql
/* 2023-02-14 Tome Holden ve3meo
The RM8.5.0 Side Index columns for Born and Died can be made to disappear
by certain adjustments of widths and cannot be made to reappear using the 
UI. This script resets the parameters stored in the database to the default
for a new database. On reopening in RM, the columns will reappear. 

Usage: 
Close the database in RM which will save its current setting in the database.
Open the database in the SQLite manager and execute this script against it.
On reopening in RM, the columns will reappear.
*/
UPDATE ConfigTable
SET DataRec = CAST(REPLACE(DataRec,'SideListBirthWidth>0<','SideListBirthWidth>40<') AS BLOB)
WHERE RecID=1
;

UPDATE ConfigTable
SET DataRec = CAST(REPLACE(DataRec,'SideListDeathWidth>0<','SideListDeathWidth>40<') AS BLOB)
WHERE RecID=1
;