From ffcee6514bb06eff0069016954668fbde7e7bb9c Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 28 May 2026 15:00:34 +0000 Subject: [PATCH] Convert the follow_map_time_problems table into the clean schema --- conversion/clean_names.sql | 5 +++++ conversion/tidy.sql | 5 +++++ 2 files changed, 10 insertions(+) diff --git a/conversion/clean_names.sql b/conversion/clean_names.sql index 9c6c3a3..454a253 100644 --- a/conversion/clean_names.sql +++ b/conversion/clean_names.sql @@ -526,6 +526,11 @@ ALTER TABLE follow_map_time RENAME "FMT_update" TO FMT_update; +ALTER TABLE "FOLLOW_MAP_TIME_PROBLEMS" RENAME TO FOLLOW_MAP_TIME_PROBLEMS; +ALTER TABLE follow_map_time_problems + RENAME "FMTP_Date" TO FMTP_Date; + + ALTER TABLE "FOOD_BOUT" RENAME TO FOOD_BOUT; ALTER TABLE food_bout RENAME "FB_FOL_date" TO FB_FOL_date; diff --git a/conversion/tidy.sql b/conversion/tidy.sql index ec8ae28..5823dc7 100644 --- a/conversion/tidy.sql +++ b/conversion/tidy.sql @@ -158,6 +158,11 @@ ALTER TABLE "FOLLOW_MAP_TIME" ALTER "FMT_time" TYPE TIME WITHOUT TIME ZONE, ALTER "FMT_update" TYPE DATE; +SELECT checktime('FOLLOW_MAP_TIME_PROBLEMS', 'FMTP_Date'); +SELECT checkdate('FOLLOW_MAP_TIME_PROBLEMS', 'map_time'); +ALTER TABLE "FOLLOW_MAP_TIME_PROBLEMS" + ALTER "FMTP_Date" TYPE DATE; + SELECT checktime('FOOD_BOUT', 'FB_FOL_date'); SELECT checkdate('FOOD_BOUT', 'FB_begin_feed_time'); SELECT checkdate('FOOD_BOUT', 'FB_end_feed_time'); -- 2.34.1