From 44423c753476b5960dd129fc8bdde8778f51ffad Mon Sep 17 00:00:00 2001 From: David Sommerseth Date: Sat, 28 Mar 2009 23:21:53 +0100 Subject: Added fieldMapping for the firewall access table (openvpn_accesses) --- database/sqlite/fieldmapping.h | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'database/sqlite') 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_ */ -- cgit