Exploit your RootsMagic family tree database with SQLite Tools
The birth of a child is a major life event for a person so I thought it would be worth adding to the stream of events query for a person. This query is designed to be pasted into the AllFacts4Person5.sql file – it follows the same columnar format – or it can be run on…
RootsMagic 4 Database System Catalog A singular system table, sqlite_master, resides in a SQLite database. The table essentially defines the RootsMagic 4 database tables, indices, and fields as follows: type name tbl_name rootpage sql table AddressLinkTable AddressLinkTable 52 CREATE TABLE AddressLinkTable (LinkID INTEGER PRIMARY KEY, OwnerType INTEGER, AddressID INTEGER, OwnerID INTEGER, AddressNum INTEGER, Details TEXT…
Gedcom 5.5 Gedcom 5.5 Gedcom 5.5 in Windows Help (chm) format
RootsMagic 4 File Types Ext Description More rmgc family tree database SQLite 3-format file readable with SQLiteManagers rmgb family tree database backup ZIP-format file extractable not only within RM, but also by PKZip, WinRAR, et al. st Source Template master file used to create sourcetemplatetable on creation of family tree database Source Templates adl…