From 8e609ca0b6bc2cfe03e222899f682762b25ff391 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 15 Feb 2024 20:54:59 +0000 Subject: [PATCH] Mark the UNK, unknown person, inactive to prevent future use --- conversion/load_data.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/conversion/load_data.sql b/conversion/load_data.sql index 1c3c2f4..ec0cfb5 100644 --- a/conversion/load_data.sql +++ b/conversion/load_data.sql @@ -199,3 +199,13 @@ INSERT INTO comm_memb_log ( FROM community_membership_update_log -- Get a consistent id generation ORDER BY date_of_update, chimp_id, update_rationale, made_by; + + +-- +-- Finish +-- + +-- Make the unknown person unusable. +UPDATE people + SET active = FALSE + WHERE person = 'UNK'; -- 2.34.1