Add job for puring old access log entries from the databaseHEADmain

1 files changed, 4 insertions, 0 deletions

diff --git a/src/sql.cpp b/src/sql.cpp
index 9c0d992..da95f18 100644
--- a/src/sql.cpp
+++ b/src/sql.cpp
@@ -9,6 +9,9 @@ namespace WebStat::SQL {
 	const std::string ACCESS_LOG_INSERT {
 #embed "sql/accessLogInsert.sql"
 	};
+	const std::string ACCESS_LOG_PURGE_OLD {
+#embed "sql/accessLogPurgeOld.sql"
+	};
 	const std::string ENTITY_INSERT {
 #embed "sql/entityInsert.sql"
 	};
@@ -21,6 +24,7 @@ namespace WebStat::SQL {
 #define HASH_OPTS(VAR) \
 	const DB::CommandOptionsPtr VAR##_OPTS = std::make_shared<DB::CommandOptions>(std::hash<std::string> {}(VAR))
 	HASH_OPTS(ACCESS_LOG_INSERT);
+	HASH_OPTS(ACCESS_LOG_PURGE_OLD);
 	HASH_OPTS(ENTITY_INSERT);
 	HASH_OPTS(ENTITY_UPDATE_DETAIL);
 	HASH_OPTS(HOST_UPSERT);