diff options
| author | David Sommerseth <dazo@users.sourceforge.net> | 2009-03-28 23:21:53 +0100 |
|---|---|---|
| committer | David Sommerseth <dazo@users.sourceforge.net> | 2009-03-28 23:21:53 +0100 |
| commit | 44423c753476b5960dd129fc8bdde8778f51ffad (patch) | |
| tree | d6fbc0b635daa689e5c00902a3c5f557fc2017b7 /database | |
| parent | add06f4a6033f517b6147a12be703b049ae7338a (diff) | |
| download | eurephia-44423c753476b5960dd129fc8bdde8778f51ffad.tar.gz eurephia-44423c753476b5960dd129fc8bdde8778f51ffad.tar.xz eurephia-44423c753476b5960dd129fc8bdde8778f51ffad.zip | |
Added fieldMapping for the firewall access table (openvpn_accesses)
Diffstat (limited to 'database')
| -rw-r--r-- | database/eurephiadb_mapping.c | 6 | ||||
| -rw-r--r-- | database/eurephiadb_mapping.h | 19 | ||||
| -rw-r--r-- | database/sqlite/fieldmapping.h | 15 |
3 files changed, 40 insertions, 0 deletions
diff --git a/database/eurephiadb_mapping.c b/database/eurephiadb_mapping.c index fb033c8..e91a42e 100644 --- a/database/eurephiadb_mapping.c +++ b/database/eurephiadb_mapping.c @@ -43,6 +43,7 @@ const char *TABLE_NAME[] = { "attempts", "blacklist", "eurephia_adminaccess", + "firewall_profiles", NULL}; // Simple mapping table for session status @@ -109,6 +110,11 @@ eDBfieldMap *eDBgetTableFieldMapping(int table) { case TABLE_EUREPHIAADMACC: srcmap = eTblMap_eurephiaadmacc; break; + + case TABLE_FWPROFILES: + srcmap = eTblMap_fwprofiles; + break; + default: return NULL; } diff --git a/database/eurephiadb_mapping.h b/database/eurephiadb_mapping.h index adbed4e..a200d14 100644 --- a/database/eurephiadb_mapping.h +++ b/database/eurephiadb_mapping.h @@ -46,6 +46,7 @@ extern const char *SESSION_STATUS[]; #define TABLE_ATTEMPTS 0x05 #define TABLE_BLACKLIST 0x06 #define TABLE_EUREPHIAADMACC 0x07 +#define TABLE_FWPROFILES 0x08 #define FIELD_NONE 0x0000000 #define FIELD_RECID 0x0000001 // Primary keys @@ -81,6 +82,9 @@ extern const char *SESSION_STATUS[]; #define FIELD_MACADDR 0x1000000 #define FIELD_UICID 0x2000000 +#define FIELD_DESCR 0x4000000 +#define FIELD_FWPROFILE 0x8000000 + #ifdef EUREPHIADB_MAPPING_C @@ -156,6 +160,21 @@ static eDBfieldMap eTblMap_eurephiaadmacc[] = { {0, NULL, FIELD_NONE, ft_UNDEF, NULL, NULL, NULL} }; +static eDBfieldMap eTblMap_fwprofiles[] = { + {TABLE_FWPROFILES, NULL, FIELD_DESCR, ft_STRING, "description", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_FWPROFILE, ft_STRING, "fwprofile", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_RECID, ft_INT , "accessprofile", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_UID, ft_INT , "uid", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_UNAME, ft_STRING, "username", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_CERTID, ft_INT, "certid", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_CNAME, ft_STRING, "cname", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_ORG, ft_STRING, "org", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_EMAIL, ft_STRING, "email", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_CERTDIGEST, ft_STRING, "digest", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_REGISTERED, ft_DATETIME, "registered", NULL, NULL}, + {0, NULL, FIELD_NONE, ft_UNDEF, NULL, NULL, NULL} +}; + #endif // #ifdef EUREPHIADB_MAPPING_C #ifdef HAVE_LIBXML2 diff --git a/database/sqlite/fieldmapping.h b/database/sqlite/fieldmapping.h index 86ae966..06f2044 100644 --- a/database/sqlite/fieldmapping.h +++ b/database/sqlite/fieldmapping.h @@ -75,4 +75,19 @@ static eDBfieldMap tbl_sqlite_lastlog[] = { {0, NULL, FIELD_NONE, ft_UNDEF, NULL, NULL, NULL} }; +static eDBfieldMap tbl_sqlite_openvpnaccesses[] = { + {TABLE_FWPROFILES, NULL, FIELD_DESCR, ft_STRING, "access_descr", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_FWPROFILE, ft_STRING, "fw_profile", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_RECID, ft_INT , "accessprofile", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_UID, ft_INT , "uid", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_UNAME, ft_STRING, "username", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_CERTID, ft_INT, "certid", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_CNAME, ft_STRING, "common_name", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_ORG, ft_STRING, "organisation", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_EMAIL, ft_STRING, "email", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_CERTDIGEST, ft_STRING, "digest", NULL, NULL}, + {TABLE_FWPROFILES, NULL, FIELD_REGISTERED, ft_DATETIME, "registered", NULL, NULL}, + {0, NULL, FIELD_NONE, ft_UNDEF, NULL, NULL, NULL} +}; + #endif /* !FIELDMAPPING_H_ */ |