From 1a77e20dc357de0869ed641d3f6550b493d73d2e Mon Sep 17 00:00:00 2001
From: Stevan <stevan.earl@asu.edu>
Date: Fri, 1 May 2026 15:44:04 +0000
Subject: [PATCH] change BIOGRAPHY_DATA.animidnum values of 0 to NULL

Solves problem #59
---
 conversion/clean.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/conversion/clean.sql b/conversion/clean.sql
index 8e3664d..b73809a 100644
--- a/conversion/clean.sql
+++ b/conversion/clean.sql
@@ -139,6 +139,16 @@ UPDATE biography
  SET b_sex = 'M'
  WHERE b_animid = 'UNK';
 
+--
+-- Clean other biography rows
+--
+
+-- Someone has a habit of setting the animal id number to 0, whereas
+-- we require > 0 or NULL.  The affected rows seem to be "baby"s.
+-- Problem #59
+UPDATE biography
+  SET b_animid_num = NULL
+  WHERE b_animid_num = 0;
 
 --
 -- follow
-- 
2.34.1