Version 11 schema and initial data
Version 11 schema and initial data
Some results of my Ver 11 schema analysis-
The Database schema in version 11 is exactly the same as in version 10.
The initial data in an 'empty' database is different in only a small number of significant areas.
Details-
The "New empty" database was created in the corresponding version of RM by creating a new empty database with default options then immediately closing the file. The file is then set to ReadOnly in Windows file manager.
This may not perfectly give an initial file, but it's close.
The schema can be retrieved with the command:
SELECT sql FROM main.sqlite_schema ORDER BY type DESC, name ASC;
No differences detected.
Initial data differences-
minor-
All rows in the database have a larger value for their UTCModDate column.
expected-
ConfigTable DataRec column XML has a new value for the Version number.
It is now 11.
This is probably the only change making a ver 11 database not work with RM 10.
new-
Additional parameters for the new Search GUI.
Thanks Richard. I noticed after converting my V10 db that PayloadTable.RecType field values changed -- SavedGroup=5 (was = 2 ) and Saved Search =4 (was =1). I hope to review other tables in the upcoming days/weeks and will update the data dictionary spreadsheet with any findings.