Define certificate digests as ft_STRING_LOWER

This means this field will always be processed with lower case

1 files changed, 31 insertions, 31 deletions

diff --git a/database/sqlite/fieldmapping.h b/database/sqlite/fieldmapping.h
index 7d156fb..b4b8336 100644
--- a/database/sqlite/fieldmapping.h
+++ b/database/sqlite/fieldmapping.h
@@ -48,13 +48,13 @@ static eDBfieldMap tbl_sqlite_users[] = {
 
 #ifdef FMAP_CERTS
 static eDBfieldMap tbl_sqlite_certs[] = {
-        {TABLE_CERTS, NULL, FIELD_RECID,       ft_INT     , flt_NOTSET, "certid",        NULL, NULL},
-        {TABLE_CERTS, NULL, FIELD_CERTDEPTH,   ft_INT     , flt_NOTSET, "depth",         NULL, NULL},
-        {TABLE_CERTS, NULL, FIELD_CERTDIGEST,  ft_STRING  , flt_NOTSET, "digest",        NULL, NULL},
-        {TABLE_CERTS, NULL, FIELD_CNAME,       ft_STRING  , flt_NOTSET, "common_name",   NULL, NULL},
-        {TABLE_CERTS, NULL, FIELD_ORG,         ft_STRING  , flt_NOTSET, "organisation",  NULL, NULL},
-        {TABLE_CERTS, NULL, FIELD_EMAIL,       ft_STRING  , flt_NOTSET, "email",         NULL, NULL},
-        {TABLE_CERTS, NULL, FIELD_REGISTERED,  ft_DATETIME, flt_NOTSET, "registered",    NULL, NULL},
+        {TABLE_CERTS, NULL, FIELD_RECID,       ft_INT         , flt_NOTSET, "certid",        NULL, NULL},
+        {TABLE_CERTS, NULL, FIELD_CERTDEPTH,   ft_INT         , flt_NOTSET, "depth",         NULL, NULL},
+        {TABLE_CERTS, NULL, FIELD_CERTDIGEST,  ft_STRING_LOWER, flt_NOTSET, "digest",        NULL, NULL},
+        {TABLE_CERTS, NULL, FIELD_CNAME,       ft_STRING      , flt_NOTSET, "common_name",   NULL, NULL},
+        {TABLE_CERTS, NULL, FIELD_ORG,         ft_STRING      , flt_NOTSET, "organisation",  NULL, NULL},
+        {TABLE_CERTS, NULL, FIELD_EMAIL,       ft_STRING      , flt_NOTSET, "email",         NULL, NULL},
+        {TABLE_CERTS, NULL, FIELD_REGISTERED,  ft_DATETIME    , flt_NOTSET, "registered",    NULL, NULL},
         {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
 };
 #endif
@@ -98,42 +98,42 @@ static eDBfieldMap tbl_sqlite_lastlog[] = {
 
 #ifdef FMAP_OVPNACCESSES
 static eDBfieldMap tbl_sqlite_openvpnaccesses[] = {
-        {TABLE_FWPROFILES,   NULL,     FIELD_DESCR,      ft_STRING  , flt_NOTSET,  "access_descr",  NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_FWPROFILE,  ft_STRING  , flt_NOTSET,  "fw_profile",    NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_RECID,      ft_INT     , flt_NOTSET,  "accessprofile", NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_UID,        ft_INT     , flt_NOTSET,  "uid",           NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_UNAME,      ft_STRING  , flt_NOTSET,  "username",      NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_CERTID,     ft_INT     , flt_NOTSET,  "certid",        NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_CNAME,      ft_STRING  , flt_NOTSET,  "common_name",   NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_ORG,        ft_STRING  , flt_NOTSET,  "organisation",  NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_EMAIL,      ft_STRING  , flt_NOTSET,  "email",         NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_CERTDIGEST, ft_STRING  , flt_NOTSET,  "digest",        NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_REGISTERED, ft_DATETIME, flt_NOTSET,  "registered",    NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,     FIELD_DESCR,      ft_STRING      , flt_NOTSET,  "access_descr",  NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,     FIELD_FWPROFILE,  ft_STRING      , flt_NOTSET,  "fw_profile",    NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,     FIELD_RECID,      ft_INT         , flt_NOTSET,  "accessprofile", NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,     FIELD_UID,        ft_INT         , flt_NOTSET,  "uid",           NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,     FIELD_UNAME,      ft_STRING      , flt_NOTSET,  "username",      NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,     FIELD_CERTID,     ft_INT         , flt_NOTSET,  "certid",        NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,     FIELD_CNAME,      ft_STRING      , flt_NOTSET,  "common_name",   NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,     FIELD_ORG,        ft_STRING      , flt_NOTSET,  "organisation",  NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,     FIELD_EMAIL,      ft_STRING      , flt_NOTSET,  "email",         NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,     FIELD_CERTDIGEST, ft_STRING_LOWER, flt_NOTSET,  "digest",        NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,     FIELD_REGISTERED, ft_DATETIME    , flt_NOTSET,  "registered",    NULL, NULL},
         {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
 };
 #endif
 
 #ifdef FMAP_OVPNATTEMPTS
 static eDBfieldMap tbl_sqlite_attempts[] = {
-        {TABLE_ATTEMPTS, NULL, FIELD_UNAME,       ft_STRING,   flt_NOTSET, "username",     NULL, NULL},
-        {TABLE_ATTEMPTS, NULL, FIELD_REMOTEIP,    ft_STRING,   flt_NOTSET, "remoteip",     NULL, NULL},
-        {TABLE_ATTEMPTS, NULL, FIELD_CERTDIGEST,  ft_STRING,   flt_NOTSET, "digest",       NULL, NULL},
-        {TABLE_ATTEMPTS, NULL, FIELD_ATTEMPTS,    ft_INT,      flt_NOTSET, "attempts",     NULL, NULL},
-        {TABLE_ATTEMPTS, NULL, FIELD_REGISTERED,  ft_DATETIME, flt_NOTSET, "registered",   NULL, NULL},
-        {TABLE_ATTEMPTS, NULL, FIELD_LASTATTEMPT, ft_DATETIME, flt_NOTSET, "last_attempt", NULL, NULL},
-        {TABLE_ATTEMPTS, NULL, FIELD_RECID,       ft_INT,      flt_NOTSET, "atpid",        NULL, NULL },
+        {TABLE_ATTEMPTS, NULL, FIELD_UNAME,       ft_STRING      , flt_NOTSET, "username",     NULL, NULL},
+        {TABLE_ATTEMPTS, NULL, FIELD_REMOTEIP,    ft_STRING      , flt_NOTSET, "remoteip",     NULL, NULL},
+        {TABLE_ATTEMPTS, NULL, FIELD_CERTDIGEST,  ft_STRING_LOWER, flt_NOTSET, "digest",       NULL, NULL},
+        {TABLE_ATTEMPTS, NULL, FIELD_ATTEMPTS,    ft_INT         , flt_NOTSET, "attempts",     NULL, NULL},
+        {TABLE_ATTEMPTS, NULL, FIELD_REGISTERED,  ft_DATETIME    , flt_NOTSET, "registered",   NULL, NULL},
+        {TABLE_ATTEMPTS, NULL, FIELD_LASTATTEMPT, ft_DATETIME    , flt_NOTSET, "last_attempt", NULL, NULL},
+        {TABLE_ATTEMPTS, NULL, FIELD_RECID,       ft_INT         , flt_NOTSET, "atpid",        NULL, NULL },
         {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
 };
 #endif
 
 #ifdef FMAP_OVPNBLACKLIST
 static eDBfieldMap tbl_sqlite_blacklist[] = {
-        {TABLE_BLACKLIST, NULL, FIELD_UNAME,       ft_STRING,   flt_NOTSET, "username",      NULL, NULL},
-        {TABLE_BLACKLIST, NULL, FIELD_REMOTEIP,    ft_STRING,   flt_NOTSET, "remoteip",      NULL, NULL},
-        {TABLE_BLACKLIST, NULL, FIELD_CERTDIGEST,  ft_STRING,   flt_NOTSET, "digest",        NULL, NULL},
-        {TABLE_BLACKLIST, NULL, FIELD_REGISTERED,  ft_DATETIME, flt_NOTSET, "registered",    NULL, NULL},
-        {TABLE_BLACKLIST, NULL, FIELD_LASTACCESS,  ft_DATETIME, flt_NOTSET, "last_accessed", NULL, NULL},
-        {TABLE_BLACKLIST, NULL, FIELD_RECID,       ft_INT,      flt_NOTSET, "blid",          NULL, NULL},
+        {TABLE_BLACKLIST, NULL, FIELD_UNAME,       ft_STRING      , flt_NOTSET, "username",      NULL, NULL},
+        {TABLE_BLACKLIST, NULL, FIELD_REMOTEIP,    ft_STRING      , flt_NOTSET, "remoteip",      NULL, NULL},
+        {TABLE_BLACKLIST, NULL, FIELD_CERTDIGEST,  ft_STRING_LOWER, flt_NOTSET, "digest",        NULL, NULL},
+        {TABLE_BLACKLIST, NULL, FIELD_REGISTERED,  ft_DATETIME    , flt_NOTSET, "registered",    NULL, NULL},
+        {TABLE_BLACKLIST, NULL, FIELD_LASTACCESS,  ft_DATETIME    , flt_NOTSET, "last_accessed", NULL, NULL},
+        {TABLE_BLACKLIST, NULL, FIELD_RECID,       ft_INT         , flt_NOTSET, "blid",          NULL, NULL},
         {0, NULL, 0, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
 };
 #endif