From 564a3f5456476587abc3b52c0952f4443d7de3b5 Mon Sep 17 00:00:00 2001
From: Vsevolod Stakhov <vsevolod@highsecure.ru>
Date: Fri, 19 Dec 2014 16:58:55 +0000
Subject: [PATCH] Add simple insertion statement.

---
 src/libserver/fuzzy_backend.c | 8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

diff --git a/src/libserver/fuzzy_backend.c b/src/libserver/fuzzy_backend.c
index 2d33c4b92..e170a61a9 100644
--- a/src/libserver/fuzzy_backend.c
+++ b/src/libserver/fuzzy_backend.c
@@ -69,7 +69,8 @@ static struct rspamd_fuzzy_stmts {
 				"id INTEGER PRIMARY KEY,"
 				"flag INTEGER NOT NULL,"
 				"digest TEXT NOT NULL,"
-				"value INTEGER);"
+				"value INTEGER,"
+				"time INTEGER);"
 				""
 				"CREATE TABLE shingles("
 				"value INTEGER NOT NULL,"
@@ -106,8 +107,9 @@ static struct rspamd_fuzzy_stmts {
 	},
 	{
 		.idx = RSPAMD_FUZZY_BACKEND_INSERT,
-		.sql = "",
-		.args = "",
+		.sql = "INSERT INTO digests(flag, digest, value, time) VALUES"
+				"(?1, ?2, ?3, ?4)",
+		.args = "ITII",
 		.stmt = NULL
 	},
 	{
-- 
2.39.5