From 5d85b83bfe1a0a029f6f0312aad08d11b0611aa6 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 15 Feb 2024 20:52:57 +0000 Subject: [PATCH] Add KL and KL_KK codes to COMM_IDS Fixes problem #12. --- conversion/load_data.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/conversion/load_data.sql b/conversion/load_data.sql index 81372c8..1c3c2f4 100644 --- a/conversion/load_data.sql +++ b/conversion/load_data.sql @@ -44,6 +44,10 @@ INSERT INTO comm_ids (commid, name, notes, membcriteria) , community_lookup.cl_details , '' FROM community_lookup; +-- Problem #12 -- hacked here +insert into comm_ids (commid, name, notes, membcriteria) + values ('KL', 'Kalande', '', '') + , ('KL_KK', 'Kasekela/kalande', '', ''); -- departtypes INSERT INTO departtypes (departtype, description) -- 2.34.1