The missing Look-Up Tables in RM

#1 · 2026-05-08, 9:37 pm

Someone on the Facebook group side of things asked about location of the custom color names. I wrote some scripts, with Copilot help, to create a view showing all color set names and all custom color names, and a bunch of other missing lookup tables.

I may use them in some of my SQL queriers and reports.
I hope someone finds them useful.

The folder of files is at-

https://github.com/RichardOtter/Genealogy-scripts/tree/main/DB%20schema%20changes/LookUp%20Tables

I created two versions of the color views, one uses an XML processing extension for SQLite, the other parses xml with string function (yuck!),

An example of the simple LU tables-

CREATE TABLE IF NOT EXISTS LU_ColorName (

ColorID INTEGER PRIMARY KEY,

ColorName TEXT NOT NULL

);

INSERT OR IGNORE INTO LU_ColorName (ColorID, ColorName) VALUES

(4, "Pink"),

(15, "Apricot"),

(16, "Lemon"),

(17, "Chartreuse"),

(18, "Mint"),

(6, "Aqua"),

(19, "Azure"),

(20, "Mauve"),

(7, "Silver"),