From d11e3d912a9caa83b1ebb5c0e0b6bef6cef050a4 Mon Sep 17 00:00:00 2001 From: olivier Date: Mon, 16 Jun 2008 19:52:24 +0000 Subject: [PATCH] raw_conversion: fix enum extraction git-svn-id: http://svn.parisson.org/svn/crem@31 3bf09e05-f825-4182-b9bc-eedd7160adf0 --- import/raw_conversion/import | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/import/raw_conversion/import b/import/raw_conversion/import index 2d694c4..a020f39 100755 --- a/import/raw_conversion/import +++ b/import/raw_conversion/import @@ -7,7 +7,7 @@ function extract_enum from_field=$3 echo "DROP TABLE IF EXISTS \`$to_table\`;" echo "CREATE TABLE \`$to_table\` (value TEXT NOT NULL) CHARSET=latin1;" - echo "INSERT INTO \`$to_table\` SELECT \`$from_field\` FROM \`$from_table\`;"; + echo "INSERT INTO \`$to_table\` SELECT DISTINCT \`$from_field\` FROM \`$from_table\` WHERE \`$from_field\` <> '';"; } src=$1 -- 2.39.5