diff options
| author | David Sommerseth <dazo@users.sourceforge.net> | 2008-12-25 16:08:09 +0100 |
|---|---|---|
| committer | David Sommerseth <dazo@users.sourceforge.net> | 2008-12-25 16:08:09 +0100 |
| commit | 79b0dea35d73a52aba5567b15c95665b08e4e26f (patch) | |
| tree | e0f7bf09333f21a8c3558ffd7e8724aedd873fe3 /database | |
| parent | 7ad1e2ded6eedd5db7af93c7d2ea690b9fec2ec8 (diff) | |
| download | eurephia-79b0dea35d73a52aba5567b15c95665b08e4e26f.tar.gz eurephia-79b0dea35d73a52aba5567b15c95665b08e4e26f.tar.xz eurephia-79b0dea35d73a52aba5567b15c95665b08e4e26f.zip | |
Added field mapping for the openvpn_usercerts table
Diffstat (limited to 'database')
| -rw-r--r-- | database/eurephiadb_mapping.c | 3 | ||||
| -rw-r--r-- | database/eurephiadb_mapping.h | 19 | ||||
| -rw-r--r-- | database/sqlite/fieldmapping.h | 9 |
3 files changed, 28 insertions, 3 deletions
diff --git a/database/eurephiadb_mapping.c b/database/eurephiadb_mapping.c index 98a940d..406fece 100644 --- a/database/eurephiadb_mapping.c +++ b/database/eurephiadb_mapping.c @@ -98,6 +98,9 @@ eDBfieldMap *eDBgetTableFieldMapping(int table) { case TABLE_BLACKLIST: srcmap = eTblMap_blacklist; + case TABLE_USERCERTS: + srcmap = eTblMap_usercerts; + default: return NULL; } diff --git a/database/eurephiadb_mapping.h b/database/eurephiadb_mapping.h index 6168a0a..45300d5 100644 --- a/database/eurephiadb_mapping.h +++ b/database/eurephiadb_mapping.h @@ -44,9 +44,10 @@ extern const char *SESSION_STATUS[]; #define TABLE_USERS 0x01 #define TABLE_CERTS 0x02 -#define TABLE_LASTLOG 0x03 -#define TABLE_ATTEMPTS 0x04 -#define TABLE_BLACKLIST 0x05 +#define TABLE_USERCERTS 0x03 +#define TABLE_LASTLOG 0x04 +#define TABLE_ATTEMPTS 0x05 +#define TABLE_BLACKLIST 0x06 #define FIELD_NONE 0x000000 #define FIELD_RECID 0x000001 // Primary keys @@ -74,6 +75,9 @@ extern const char *SESSION_STATUS[]; #define FIELD_PASSWD 0x080000 #define FIELD_CERTDIGEST 0x100000 +#define FIELD_ACCPROFILE 0x200000 + + #ifdef EUREPHIADB_MAPPING_C static eDBfieldMap eTblMap_user[] = { @@ -129,6 +133,15 @@ static eDBfieldMap eTblMap_blacklist[] = { {0, NULL, 0, ft_UNDEF, NULL} }; +static eDBfieldMap eTblMap_usercerts[] = { + {TABLE_USERCERTS, NULL, FIELD_UID, ft_INT, "uid", NULL, NULL}, + {TABLE_USERCERTS, NULL, FIELD_CERTID, ft_INT, "certid", NULL, NULL}, + {TABLE_USERCERTS, NULL, FIELD_ACCPROFILE, ft_INT, "accessprofile", NULL, NULL}, + {TABLE_USERCERTS, NULL, FIELD_REGISTERED, ft_INT, "registered", NULL, NULL}, + {TABLE_USERCERTS, NULL, FIELD_RECID, ft_INT, "uicid", NULL, NULL}, + {0, NULL, FIELD_NONE, ft_UNDEF, NULL, NULL, NULL} +}; + #endif // #ifdef EUREPHIADB_MAPPING_C void eDBfreeMapping(eDBfieldMap *p); diff --git a/database/sqlite/fieldmapping.h b/database/sqlite/fieldmapping.h index c08ecac..64d66c4 100644 --- a/database/sqlite/fieldmapping.h +++ b/database/sqlite/fieldmapping.h @@ -43,4 +43,13 @@ static eDBfieldMap tbl_sqlite_certs[] = { {0, NULL, FIELD_NONE, ft_UNDEF, NULL, NULL, NULL} }; +static eDBfieldMap tbl_sqlite_usercerts[] = { + {TABLE_USERCERTS, NULL, FIELD_UID, ft_INT, "uid", NULL, NULL}, + {TABLE_USERCERTS, NULL, FIELD_CERTID, ft_INT, "certid", NULL, NULL}, + {TABLE_USERCERTS, NULL, FIELD_ACCPROFILE, ft_INT, "accessprofile", NULL, NULL}, + {TABLE_USERCERTS, NULL, FIELD_REGISTERED, ft_INT, "registered", NULL, NULL}, + {TABLE_USERCERTS, NULL, FIELD_RECID, ft_INT, "uicid", NULL, NULL}, + {0, NULL, FIELD_NONE, ft_UNDEF, NULL, NULL, NULL} +}; + #endif /* !FIELDMAPPING_H_ */ |