changed the database schema to rely on a central device table instead of having each table store the client_id / mac.
sql contains a migration script for existing data, please note this relies on ALTER TABLE DROP COLUMN, which is only supported in fairly recent sqlite versions (? 3.35+ ??)