From 3c5da5c51aa7ecf9f6343e1b5599059c55325e82 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Wed, 15 Apr 2020 16:32:46 -0400 Subject: [PATCH] if we come across these, make them BIGINT. mysql/mariadb can't index TEXT Signed-off-by: Jason Etheridge --- kmig.d/bin/csv2mysql | 6 +++++- 1 files changed, 5 insertions(+), 1 deletions(-) diff --git a/kmig.d/bin/csv2mysql b/kmig.d/bin/csv2mysql index f131f5b..840126a 100755 --- a/kmig.d/bin/csv2mysql +++ b/kmig.d/bin/csv2mysql @@ -112,7 +112,11 @@ sub write_sql_table { $col_info =~ s/^\$VAR1 = //; print $sql "ALTER TABLE $cfg->{table_name} ADD COLUMN "; print $sql "l_" unless $cfg->{no_legacy_prefix} or $column->{'header'} =~ /^x_/ or $column->{'header'} =~ /^l_/; - print $sql "$cn TEXT; "; + if ($column->{'header'} eq 'x_egid' || $column->{'header'} eq 'x_hseq') { + print $sql "$cn BIGINT; "; + } else { + print $sql "$cn TEXT; "; + } print $sql " /*\n $col_info */\n"; } foreach my $cn (@indices) { -- 1.7.2.5