diff options
Diffstat (limited to 'database/sqlite')
| -rw-r--r-- | database/sqlite/fieldmapping.h | 62 |
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 |