Define certificate digests as ft_STRING_LOWER

This means this field will always be processed with lower case

1 files changed, 32 insertions, 32 deletions

diff --git a/database/eurephiadb_mapping.h b/database/eurephiadb_mapping.h
index 37c9f44..b2cc67d 100644
--- a/database/eurephiadb_mapping.h
+++ b/database/eurephiadb_mapping.h
@@ -43,7 +43,7 @@
 /**
  *  Enumeration of different field types
  */
-typedef enum eDBfieldType_e { ft_UNDEF, ft_INT, ft_STRING, ft_DATETIME, ft_PASSWD, ft_SETNULL } eDBfieldType;
+typedef enum eDBfieldType_e { ft_UNDEF, ft_INT, ft_STRING, ft_STRING_LOWER, ft_DATETIME, ft_PASSWD, ft_SETNULL } eDBfieldType;
 
 /**
  *  Enumeration of different SQL filter types (IS NULL, =, !=,  <=, >=, >, <, etc)
@@ -157,13 +157,13 @@ static eDBfieldMap eTblMap_user[] = {
  * Unified eurephia field names for the 'certificates' table
  */
 static eDBfieldMap eTblMap_certificates[] = {
-        {TABLE_CERTS, NULL, FIELD_RECID,       ft_INT,      flt_EQ, "certid",      NULL, NULL},
-        {TABLE_CERTS, NULL, FIELD_CERTDEPTH,   ft_INT,      flt_EQ, "depth",       NULL, NULL},
-        {TABLE_CERTS, NULL, FIELD_CERTDIGEST,  ft_STRING,   flt_EQ, "digest",      NULL, NULL},
-        {TABLE_CERTS, NULL, FIELD_CNAME,       ft_STRING,   flt_EQ, "cname",       NULL, NULL},
-        {TABLE_CERTS, NULL, FIELD_ORG,         ft_STRING,   flt_EQ, "org",         NULL, NULL},
-        {TABLE_CERTS, NULL, FIELD_EMAIL,       ft_STRING,   flt_EQ, "email",       NULL, NULL},
-        {TABLE_CERTS, NULL, FIELD_REGISTERED,  ft_DATETIME, flt_EQ, "registered",  NULL, NULL},
+        {TABLE_CERTS, NULL, FIELD_RECID,       ft_INT         , flt_EQ, "certid",      NULL, NULL},
+        {TABLE_CERTS, NULL, FIELD_CERTDEPTH,   ft_INT         , flt_EQ, "depth",       NULL, NULL},
+        {TABLE_CERTS, NULL, FIELD_CERTDIGEST,  ft_STRING_LOWER, flt_EQ, "digest",      NULL, NULL},
+        {TABLE_CERTS, NULL, FIELD_CNAME,       ft_STRING      , flt_EQ, "cname",       NULL, NULL},
+        {TABLE_CERTS, NULL, FIELD_ORG,         ft_STRING      , flt_EQ, "org",         NULL, NULL},
+        {TABLE_CERTS, NULL, FIELD_EMAIL,       ft_STRING      , flt_EQ, "email",       NULL, NULL},
+        {TABLE_CERTS, NULL, FIELD_REGISTERED,  ft_DATETIME    , flt_EQ, "registered",  NULL, NULL},
         {0, NULL, 0, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
 };
 
@@ -189,13 +189,13 @@ static eDBfieldMap eTblMap_lastlog[] = {
  * Unified eurephia field names for the 'attempts log' table
  */
 static eDBfieldMap eTblMap_attempts[] = {
-        {TABLE_ATTEMPTS, NULL, FIELD_UNAME,       ft_STRING,   flt_EQ, "username",    NULL, NULL},
-        {TABLE_ATTEMPTS, NULL, FIELD_REMOTEIP,    ft_STRING,   flt_EQ, "ip",          NULL, NULL},
-        {TABLE_ATTEMPTS, NULL, FIELD_CERTDIGEST,  ft_STRING,   flt_EQ, "digest",      NULL, NULL},
-        {TABLE_ATTEMPTS, NULL, FIELD_ATTEMPTS,    ft_INT,      flt_EQ, "attempts",    NULL, NULL},
-        {TABLE_ATTEMPTS, NULL, FIELD_REGISTERED,  ft_DATETIME, flt_EQ, "registered",  NULL, NULL},
-        {TABLE_ATTEMPTS, NULL, FIELD_LASTATTEMPT, ft_DATETIME, flt_EQ, "lastattempt", NULL, NULL},
-        {TABLE_ATTEMPTS, NULL, FIELD_RECID,       ft_INT,      flt_EQ, "id",          NULL, NULL },
+        {TABLE_ATTEMPTS, NULL, FIELD_UNAME,       ft_STRING      , flt_EQ, "username",    NULL, NULL},
+        {TABLE_ATTEMPTS, NULL, FIELD_REMOTEIP,    ft_STRING      , flt_EQ, "ip",          NULL, NULL},
+        {TABLE_ATTEMPTS, NULL, FIELD_CERTDIGEST,  ft_STRING_LOWER, flt_EQ, "digest",      NULL, NULL},
+        {TABLE_ATTEMPTS, NULL, FIELD_ATTEMPTS,    ft_INT         , flt_EQ, "attempts",    NULL, NULL},
+        {TABLE_ATTEMPTS, NULL, FIELD_REGISTERED,  ft_DATETIME    , flt_EQ, "registered",  NULL, NULL},
+        {TABLE_ATTEMPTS, NULL, FIELD_LASTATTEMPT, ft_DATETIME    , flt_EQ, "lastattempt", NULL, NULL},
+        {TABLE_ATTEMPTS, NULL, FIELD_RECID,       ft_INT         , flt_EQ, "id",          NULL, NULL },
         {0, NULL, 0, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
 };
 
@@ -204,12 +204,12 @@ static eDBfieldMap eTblMap_attempts[] = {
  * Unified eurephia field names for the 'blacklist' table
  */
 static eDBfieldMap eTblMap_blacklist[] = {
-        {TABLE_BLACKLIST, NULL, FIELD_UNAME,       ft_STRING,   flt_EQ, "username",     NULL, NULL},
-        {TABLE_BLACKLIST, NULL, FIELD_REMOTEIP,    ft_STRING,   flt_EQ, "ip",           NULL, NULL},
-        {TABLE_BLACKLIST, NULL, FIELD_CERTDIGEST,  ft_STRING,   flt_EQ, "digest",       NULL, NULL},
-        {TABLE_BLACKLIST, NULL, FIELD_REGISTERED,  ft_DATETIME, flt_EQ, "registered",   NULL, NULL},
-        {TABLE_BLACKLIST, NULL, FIELD_LASTACCESS,  ft_DATETIME, flt_EQ, "lastaccessed", NULL, NULL},
-        {TABLE_BLACKLIST, NULL, FIELD_RECID,       ft_INT,      flt_EQ, "id",           NULL, NULL},
+        {TABLE_BLACKLIST, NULL, FIELD_UNAME,       ft_STRING      , flt_EQ, "username",     NULL, NULL},
+        {TABLE_BLACKLIST, NULL, FIELD_REMOTEIP,    ft_STRING      , flt_EQ, "ip",           NULL, NULL},
+        {TABLE_BLACKLIST, NULL, FIELD_CERTDIGEST,  ft_STRING_LOWER, flt_EQ, "digest",       NULL, NULL},
+        {TABLE_BLACKLIST, NULL, FIELD_REGISTERED,  ft_DATETIME    , flt_EQ, "registered",   NULL, NULL},
+        {TABLE_BLACKLIST, NULL, FIELD_LASTACCESS,  ft_DATETIME    , flt_EQ, "lastaccessed", NULL, NULL},
+        {TABLE_BLACKLIST, NULL, FIELD_RECID,       ft_INT         , flt_EQ, "id",           NULL, NULL},
         {0, NULL, 0, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
 };
 
@@ -241,17 +241,17 @@ static eDBfieldMap eTblMap_eurephiaadmacc[] = {
  * Unified eurephia field names for the 'accessprofiles' table
  */
 static eDBfieldMap eTblMap_fwprofiles[] = {
-        {TABLE_FWPROFILES,   NULL,     FIELD_DESCR,      ft_STRING  , flt_EQ, "description",   NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_FWPROFILE,  ft_STRING  , flt_EQ, "fwprofile",     NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_RECID,      ft_INT     , flt_EQ, "accessprofile", NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_UID,        ft_INT     , flt_EQ, "uid",           NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_UNAME,      ft_STRING  , flt_EQ, "username",      NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_CERTID,     ft_INT     , flt_EQ, "certid",        NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_CNAME,      ft_STRING  , flt_EQ, "cname",         NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_ORG,        ft_STRING  , flt_EQ, "org",           NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_EMAIL,      ft_STRING  , flt_EQ, "email",         NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_CERTDIGEST, ft_STRING  , flt_EQ, "digest",        NULL, NULL},
-        {TABLE_FWPROFILES,   NULL,     FIELD_REGISTERED, ft_DATETIME, flt_EQ, "registered",    NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,  FIELD_DESCR,      ft_STRING      , flt_EQ, "description",   NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,  FIELD_FWPROFILE,  ft_STRING      , flt_EQ, "fwprofile",     NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,  FIELD_RECID,      ft_INT         , flt_EQ, "accessprofile", NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,  FIELD_UID,        ft_INT         , flt_EQ, "uid",           NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,  FIELD_UNAME,      ft_STRING      , flt_EQ, "username",      NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,  FIELD_CERTID,     ft_INT         , flt_EQ, "certid",        NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,  FIELD_CNAME,      ft_STRING      , flt_EQ, "cname",         NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,  FIELD_ORG,        ft_STRING      , flt_EQ, "org",           NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,  FIELD_EMAIL,      ft_STRING      , flt_EQ, "email",         NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,  FIELD_CERTDIGEST, ft_STRING_LOWER, flt_EQ, "digest",        NULL, NULL},
+        {TABLE_FWPROFILES,   NULL,  FIELD_REGISTERED, ft_DATETIME, flt_EQ, "registered",    NULL, NULL},
         {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
 };