Understanding the Roots Magic 8 Database – Database Diagram #rm8 #database
Database Diagram for RootsMagic version 8 - there are probably more table relationships to be added. RM8.pdfDatabase Diagram as pdf file to download ...
Understanding the RootsMagic 8 database – Type Decodes #rm8 #datadefinitions
Many tables within RootsMagic have fields which are know to mean something but do not have lookup tables. So far I have collected the following: (more to follow) Fields named OwnerType - see Understanding the RootsMagic 8 database – Ownership ...
Understanding the RootsMagic 8 database – Ownership #database #datadefinitions #rm8
The RootsMagic 8 database structure has seen a few changes from RM7 and one of these is that more objects can "own" other objects in the data. A task can have media, citations and web tags for example. To achieve ...
Group Queries #namedgroup #colorcoding #rm8 #rm7
In RootsMagic 7 group names are stored in the LabelTable and the group members in GroupTable with group id and RIN. The LabelTypes in the LabelTable are 0 – groups, and thus it is the label value field that links ...
Common Table Expressions – The Building Blocks of SQL
Common Table Expressions (CTE) are a feature that was first introduced to SQL in about 2005 and provide a method of defining a temporary result set then using that in the query as if it were another table. Yes, subqueries ...
RM8 Data Definitions Spreadsheet #database #datadefinitions
Thanks to member momakid, we have a new spreadsheet of data definitions available on Google Sheets. The new fields in RM8 are not completely described so your input is welcome. You may comment directly on the spreadsheet, on this page ...
Comparing #Database Definitions RM8 versus RM7 #datadefinitions
Comparing the CREATE statements for a database file of each version reveals changes to persisting tables in addition to tables deleted and added per First Look at RM8 #Database. This post provides DDL files from RM7.6.5 and the RM8 Preview ...
First Look at RM8 #Database
More changes than expected with the result that many (most?) of the queries and scripts published on this site won't work with RM8 databases. New Tables CitationLinkTable: was expected to support the announced new feature of master citations. AncestryTable and ...
Query to Search Parents by Children’s Given Names #search #family
Parents-Three_Childrens_Names.sqlDownload File above incorporates revision from discussion below to correct the count of children. Tested with #rm7 #rm8 and should be compatible with prior versions. TH 2021-03-03 The following script was developed in response to the discussion Search for family ...
Updating to WordPress 5.4.1
I'm going to attempt an update from WordPress 4.9.14 to 5.4.1 sometime today. The disruption will either be minimal or disastrous. I've made a backup of the files and database. But I'm no WP expert and things may get broken ...
