From ea49f4a06ac3ef8c2aec1e8fbc0c08703bca36d7 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Sat, 18 Nov 2023 18:16:00 -0600 Subject: [PATCH] Do not need to remove primary key declaration, the data has been cleaned --- conversion/mung_dump.sh | 4 ---- 1 file changed, 4 deletions(-) diff --git a/conversion/mung_dump.sh b/conversion/mung_dump.sh index 76cbe31..0aff2fc 100755 --- a/conversion/mung_dump.sh +++ b/conversion/mung_dump.sh @@ -46,10 +46,6 @@ bunzip2 -c "${DATA_FILE}" \ # 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) { -- 2.34.1