--SourceTemplate-AncestryRecord-Reset.sql
/* 2023-05-03 Tom Holden ve3meo
Restores the Ancestry Record template to the OEM built-in template.
Can be used with any version of RM provided the reference and target
databases are of the same version (or at least the same structure...).
*/

-- Edit the following statement to point to a database from the same RM version
-- as your target database and having the original built-in Ancestry Record template.
ATTACH DATABASE 'C:\Users\Tom\Documents\FamilyTree\RM7\RM7-6-5_Empty.rmgc' AS Ref
;

DELETE FROM main.SourceTemplateTable
WHERE TemplateID=439
;
INSERT INTO main.SourceTemplateTable
SELECT * FROM Ref.SourceTemplateTable
WHERE TemplateID=439
;