diff options
| author | David Sommerseth <dazo@users.sourceforge.net> | 2008-12-11 14:11:44 +0100 |
|---|---|---|
| committer | David Sommerseth <dazo@users.sourceforge.net> | 2008-12-11 14:11:44 +0100 |
| commit | c132838440c3f602283bf92146433800ee1bf9b2 (patch) | |
| tree | 664857d975507e2631c471d4dd9b71cfc13d40ec /database/eurephiadb_mapping.h | |
| parent | f60ecdff15cf48316b24a73b500c7f9083bd10dc (diff) | |
| download | eurephia-c132838440c3f602283bf92146433800ee1bf9b2.tar.gz eurephia-c132838440c3f602283bf92146433800ee1bf9b2.tar.xz eurephia-c132838440c3f602283bf92146433800ee1bf9b2.zip | |
Enhanced table/field mapping and eDBmkMapping_USERINFO(...) to include possibility for table aliases
Diffstat (limited to 'database/eurephiadb_mapping.h')
| -rw-r--r-- | database/eurephiadb_mapping.h | 79 |
1 files changed, 40 insertions, 39 deletions
diff --git a/database/eurephiadb_mapping.h b/database/eurephiadb_mapping.h index e6f1134..5079490 100644 --- a/database/eurephiadb_mapping.h +++ b/database/eurephiadb_mapping.h @@ -28,6 +28,7 @@ typedef enum eDBfieldType_e { ft_UNDEF, ft_INT, ft_STRING, ft_DATETIME, ft_PASSW typedef struct _eDBfieldMap_s { int tableid; + char *table_alias; long field_id; eDBfieldType field_type; char *field_name; @@ -70,62 +71,62 @@ typedef struct _eDBfieldMap_s { #ifdef EUREPHIADB_MAPPING_C static eDBfieldMap eTblMap_user[] = { - {TABLE_USERS, FIELD_RECID, ft_INT, "id"}, - {TABLE_USERS, FIELD_RECID, ft_INT, "uid"}, - {TABLE_USERS, FIELD_UNAME, ft_STRING, "username"}, - {TABLE_USERS, FIELD_ACTIVATED, ft_DATETIME, "activated"}, - {TABLE_USERS, FIELD_DEACTIVATED, ft_DATETIME, "deactivated"}, - {TABLE_USERS, FIELD_LASTACCESS, ft_DATETIME, "lastaccess"}, - {0, 0, ft_UNDEF, NULL} + {TABLE_USERS, NULL, FIELD_RECID, ft_INT, "id"}, + {TABLE_USERS, NULL, FIELD_RECID, ft_INT, "uid"}, + {TABLE_USERS, NULL, FIELD_UNAME, ft_STRING, "username"}, + {TABLE_USERS, NULL, FIELD_ACTIVATED, ft_DATETIME, "activated"}, + {TABLE_USERS, NULL, FIELD_DEACTIVATED, ft_DATETIME, "deactivated"}, + {TABLE_USERS, NULL, FIELD_LASTACCESS, ft_DATETIME, "lastaccess"}, + {0, NULL, 0, ft_UNDEF, NULL} }; static eDBfieldMap eTblMap_certificates[] = { - {TABLE_CERTS, FIELD_RECID, ft_INT, "id"}, - {TABLE_CERTS, FIELD_RECID, ft_INT, "certid"}, - {TABLE_CERTS, FIELD_CERTDEPTH, ft_INT, "depth"}, - {TABLE_CERTS, FIELD_CNAME, ft_STRING, "name"}, - {TABLE_CERTS, FIELD_ORG, ft_STRING, "org"}, - {TABLE_CERTS, FIELD_EMAIL, ft_STRING, "email"}, - {TABLE_CERTS, FIELD_REGISTERED, ft_DATETIME, "registered"}, - {0, 0, ft_UNDEF, NULL} + {TABLE_CERTS, NULL, FIELD_RECID, ft_INT, "id"}, + {TABLE_CERTS, NULL, FIELD_RECID, ft_INT, "certid"}, + {TABLE_CERTS, NULL, FIELD_CERTDEPTH, ft_INT, "depth"}, + {TABLE_CERTS, NULL, FIELD_CNAME, ft_STRING, "name"}, + {TABLE_CERTS, NULL, FIELD_ORG, ft_STRING, "org"}, + {TABLE_CERTS, NULL, FIELD_EMAIL, ft_STRING, "email"}, + {TABLE_CERTS, NULL, FIELD_REGISTERED, ft_DATETIME, "registered"}, + {0, NULL, 0, ft_UNDEF, NULL} }; static eDBfieldMap eTblMap_lastlog[] = { - {TABLE_LASTLOG, FIELD_UID, ft_INT, "uid"}, - {TABLE_LASTLOG, FIELD_CERTID, ft_INT, "certid"}, - {TABLE_LASTLOG, FIELD_REMOTEIP, ft_STRING, "ip"}, - {TABLE_LASTLOG, FIELD_VPNIP, ft_STRING, "vpnip"}, - {TABLE_LASTLOG, FIELD_SESSTATUS, ft_STRING, "status"}, - {TABLE_LASTLOG, FIELD_LOGIN, ft_DATETIME, "login"}, - {TABLE_LASTLOG, FIELD_LOGOUT, ft_DATETIME, "logout"}, - {TABLE_LASTLOG, FIELD_RECID, ft_INT, "id"}, - {0, 0, ft_UNDEF, NULL} + {TABLE_LASTLOG, NULL, FIELD_UID, ft_INT, "uid"}, + {TABLE_LASTLOG, NULL, FIELD_CERTID, ft_INT, "certid"}, + {TABLE_LASTLOG, NULL, FIELD_REMOTEIP, ft_STRING, "ip"}, + {TABLE_LASTLOG, NULL, FIELD_VPNIP, ft_STRING, "vpnip"}, + {TABLE_LASTLOG, NULL, FIELD_SESSTATUS, ft_STRING, "status"}, + {TABLE_LASTLOG, NULL, FIELD_LOGIN, ft_DATETIME, "login"}, + {TABLE_LASTLOG, NULL, FIELD_LOGOUT, ft_DATETIME, "logout"}, + {TABLE_LASTLOG, NULL, FIELD_RECID, ft_INT, "id"}, + {0, NULL, 0, ft_UNDEF, NULL} }; static eDBfieldMap eTblMap_attempts[] = { - {TABLE_ATTEMPTS, FIELD_UNAME, ft_STRING, "username"}, - {TABLE_ATTEMPTS, FIELD_REMOTEIP, ft_STRING, "ip"}, - {TABLE_ATTEMPTS, FIELD_ATTEMPTS, ft_INT, "attempts"}, - {TABLE_ATTEMPTS, FIELD_REGISTERED, ft_DATETIME, "registered"}, - {TABLE_ATTEMPTS, FIELD_LASTATTEMPT, ft_DATETIME, "lastattempt"}, - {TABLE_ATTEMPTS, FIELD_RECID, ft_INT, "id"}, - {0, 0, ft_UNDEF, NULL} + {TABLE_ATTEMPTS, NULL, FIELD_UNAME, ft_STRING, "username"}, + {TABLE_ATTEMPTS, NULL, FIELD_REMOTEIP, ft_STRING, "ip"}, + {TABLE_ATTEMPTS, NULL, FIELD_ATTEMPTS, ft_INT, "attempts"}, + {TABLE_ATTEMPTS, NULL, FIELD_REGISTERED, ft_DATETIME, "registered"}, + {TABLE_ATTEMPTS, NULL, FIELD_LASTATTEMPT, ft_DATETIME, "lastattempt"}, + {TABLE_ATTEMPTS, NULL, FIELD_RECID, ft_INT, "id"}, + {0, NULL, 0, ft_UNDEF, NULL} }; static eDBfieldMap eTblMap_blacklist[] = { - {TABLE_BLACKLIST, FIELD_UNAME, ft_STRING, "username"}, - {TABLE_BLACKLIST, FIELD_REMOTEIP, ft_STRING, "ip"}, - {TABLE_BLACKLIST, FIELD_REGISTERED, ft_DATETIME, "registered"}, - {TABLE_BLACKLIST, FIELD_LASTACCESS, ft_DATETIME, "lastattempt"}, - {TABLE_BLACKLIST, FIELD_LASTACCESS, ft_DATETIME, "lastaccessed"}, - {TABLE_BLACKLIST, FIELD_RECID, ft_INT, "id"}, - {0, 0, ft_UNDEF, NULL} + {TABLE_BLACKLIST, NULL, FIELD_UNAME, ft_STRING, "username"}, + {TABLE_BLACKLIST, NULL, FIELD_REMOTEIP, ft_STRING, "ip"}, + {TABLE_BLACKLIST, NULL, FIELD_REGISTERED, ft_DATETIME, "registered"}, + {TABLE_BLACKLIST, NULL, FIELD_LASTACCESS, ft_DATETIME, "lastattempt"}, + {TABLE_BLACKLIST, NULL, FIELD_LASTACCESS, ft_DATETIME, "lastaccessed"}, + {TABLE_BLACKLIST, NULL, FIELD_RECID, ft_INT, "id"}, + {0, NULL, 0, ft_UNDEF, NULL} }; #endif // #ifdef EUREPHIADB_MAPPING_C void eDBfreeMapping(eDBfieldMap *p); -eDBfieldMap *eDBmkMapping_USERINFO(eurephiaCTX *ctx, eDBfieldMap *dbmap, eurephiaUSERINFO *user); +eDBfieldMap *eDBmkMapping_USERINFO(eurephiaCTX *ctx, eDBfieldMap *dbmap, const char *alias, eurephiaUSERINFO *user); char *eDBmkSortKeyString(eDBfieldMap *tfmap, const char *skeys_str); #endif // !EUREPHIADB_MAPPING_H |