X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=kmig.d%2Fbin%2Fcsv2mysql;h=840126a79b0f5a89b9c459aa37497d3eb5bfc884;hp=f131f5ba69d460750bd6539f8f7fb4590c69ae5d;hb=3c5da5c51aa7ecf9f6343e1b5599059c55325e82;hpb=cad29b1d892e025e16582f28d540dfa5365c089d

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) {