From c5181a51c0577612fedc59541f4285a96029e07e Mon Sep 17 00:00:00 2001
From: "Karl O. Pinc" <kop@karlpinc.com>
Date: Mon, 11 Dec 2023 18:07:59 -0600
Subject: [PATCH] Remove more code which worked around invalid primary key data
 in dump

This goes with commit: ea49f4a06a
---
 conversion/mung_dump.sh | 14 --------------
 1 file changed, 14 deletions(-)

diff --git a/conversion/mung_dump.sh b/conversion/mung_dump.sh
index 76cbe31..523c5fd 100755
--- a/conversion/mung_dump.sh
+++ b/conversion/mung_dump.sh
@@ -42,15 +42,6 @@ bunzip2 -c "${DATA_FILE}" \
       / VARCHAR\(255\)/ { print gensub(/ VARCHAR\(255\)/, " TEXT", 1); \
                           printed = 1; }
 
-      # Frob the CREATE TABLE for FOLLOW_MAP_TIME.
-      # Get rid of the comma on the line before the PRIMARY KEY declaration
-      / "FMT_update" TIMESTAMP,/ { print gensub(/,/, "", 1); \
-                                   printed = 1; }
-      # Get rid of the PRIMARY KEY declaration, because the "key" is not
-      # unique.
-      / PRIMARY KEY \("FMT_FOL_date", "FMT_FOL_B_focal_AnimID", "FMT_time"\)/\
-        { printed = 1; }
-
       # Everything else is printed
       {if (printed) {
          printed = 0 ; }
@@ -58,8 +49,3 @@ bunzip2 -c "${DATA_FILE}" \
          print ; }
       }' \
       /dev/stdin
-
-# Create a non-unique index for the primary key index we removed.
-printf '%s%s\n' \
-       'CREATE INDEX "FOLLOW_MAP_TIME_index1" ON "FOLLOW_MAP_TIME"' \
-       '("FMT_FOL_date", "FMT_FOL_B_focal_AnimID", "FMT_time");'
-- 
2.34.1