From 346f7c6c0e5d182ed799b3f7d716a8179ebe0407 Mon Sep 17 00:00:00 2001
From: ventulis <72085617+ventulis@users.noreply.github.com>
Date: Tue, 29 Sep 2020 16:30:13 +0200
Subject: [PATCH] [FIX] Clickhouse Migrations SQL Syntax Error

---
 src/plugins/lua/clickhouse.lua | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/src/plugins/lua/clickhouse.lua b/src/plugins/lua/clickhouse.lua
index 280957008..c9d0c71cc 100644
--- a/src/plugins/lua/clickhouse.lua
+++ b/src/plugins/lua/clickhouse.lua
@@ -210,7 +210,7 @@ local migrations = {
   [4] = {
     [[ALTER TABLE rspamd
       MODIFY COLUMN Action Enum8('reject' = 0, 'rewrite subject' = 1, 'add header' = 2, 'greylist' = 3, 'no action' = 4, 'soft reject' = 5, 'custom' = 6) DEFAULT 'no action',
-      ADD IF NOT EXISTS COLUMN CustomAction String AFTER Action
+      ADD COLUMN IF NOT EXISTS CustomAction String AFTER Action
     ]],
     -- New version
     [[INSERT INTO rspamd_version (Version) Values (5)]],
-- 
2.39.5