eurephia v1.0 - Developer: database/sqlite/fieldmapping.h Source File

Go to the documentation of this file.
00001 /* fieldmapping.h  --  Contains mapping from internal eurephia field ID to
00002  *                     SQLite3 specific field names per table
00003  *
00004  *  GPLv2 only - Copyright (C) 2008 - 2010
00005  *               David Sommerseth <dazo@users.sourceforge.net>
00006  *
00007  *  This program is free software; you can redistribute it and/or
00008  *  modify it under the terms of the GNU General Public License
00009  *  as published by the Free Software Foundation; version 2
00010  *  of the License.
00011  *
00012  *  This program is distributed in the hope that it will be useful,
00013  *  but WITHOUT ANY WARRANTY; without even the implied warranty of
00014  *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
00015  *  GNU General Public License for more details.
00016  *
00017  *  You should have received a copy of the GNU General Public License
00018  *  along with this program; if not, write to the Free Software
00019  *  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
00020  *
00021  */
00022 
00034 #ifndef         FIELDMAPPING_H_
00035 # define        FIELDMAPPING_H_
00036 
00037 #ifdef FMAP_USERS
00038 static eDBfieldMap tbl_sqlite_users[] = {
00039         {TABLE_USERS, NULL, FIELD_RECID,       ft_INT     , flt_NOTSET,  "uid",           NULL, NULL},
00040         {TABLE_USERS, NULL, FIELD_UNAME,       ft_STRING  , flt_NOTSET,  "username",      NULL, NULL},
00041         {TABLE_USERS, NULL, FIELD_PASSWD,      ft_PASSWD  , flt_NOTSET,  "password",      NULL, NULL},
00042         {TABLE_USERS, NULL, FIELD_ACTIVATED,   ft_DATETIME, flt_NOTSET,  "activated",     NULL, NULL},
00043         {TABLE_USERS, NULL, FIELD_DEACTIVATED, ft_DATETIME, flt_NOTSET,  "deactivated",   NULL, NULL},
00044         {TABLE_USERS, NULL, FIELD_LASTACCESS,  ft_DATETIME, flt_NOTSET,  "last_accessed", NULL, NULL},
00045         {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
00046 };
00047 #endif
00048 
00049 #ifdef FMAP_CERTS
00050 static eDBfieldMap tbl_sqlite_certs[] = {
00051         {TABLE_CERTS, NULL, FIELD_RECID,       ft_INT         , flt_NOTSET, "certid",        NULL, NULL},
00052         {TABLE_CERTS, NULL, FIELD_CERTDEPTH,   ft_INT         , flt_NOTSET, "depth",         NULL, NULL},
00053         {TABLE_CERTS, NULL, FIELD_CERTDIGEST,  ft_STRING_LOWER, flt_NOTSET, "digest",        NULL, NULL},
00054         {TABLE_CERTS, NULL, FIELD_CNAME,       ft_STRING      , flt_NOTSET, "common_name",   NULL, NULL},
00055         {TABLE_CERTS, NULL, FIELD_ORG,         ft_STRING      , flt_NOTSET, "organisation",  NULL, NULL},
00056         {TABLE_CERTS, NULL, FIELD_EMAIL,       ft_STRING      , flt_NOTSET, "email",         NULL, NULL},
00057         {TABLE_CERTS, NULL, FIELD_REGISTERED,  ft_DATETIME    , flt_NOTSET, "registered",    NULL, NULL},
00058         {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
00059 };
00060 #endif
00061 
00062 #ifdef FMAP_USERCERTS
00063 static eDBfieldMap tbl_sqlite_usercerts[] = {
00064         {TABLE_USERCERTS, NULL, FIELD_UID,        ft_INT, flt_NOTSET,  "uid",            NULL, NULL},
00065         {TABLE_USERCERTS, NULL, FIELD_CERTID,     ft_INT, flt_NOTSET,  "certid",         NULL, NULL},
00066         {TABLE_USERCERTS, NULL, FIELD_ACCPROFILE, ft_INT, flt_NOTSET,  "accessprofile",  NULL, NULL},
00067         {TABLE_USERCERTS, NULL, FIELD_REGISTERED, ft_INT, flt_NOTSET,  "registered",     NULL, NULL},
00068         {TABLE_USERCERTS, NULL, FIELD_RECID,      ft_INT, flt_NOTSET,  "uicid",          NULL, NULL},
00069         {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
00070 };
00071 #endif
00072 
00073 #ifdef FMAP_ADMINACCESS
00074 static eDBfieldMap tbl_sqlite_eurephiaadmacc[] = {
00075         {TABLE_EUREPHIAADMACC, NULL, FIELD_UID,       ft_INT   , flt_NOTSET, "uid",           NULL, NULL},
00076         {TABLE_EUREPHIAADMACC, NULL, FIELD_INTERFACE, ft_STRING, flt_NOTSET, "interface",     NULL, NULL},
00077         {TABLE_EUREPHIAADMACC, NULL, FIELD_ACCESSLVL, ft_STRING, flt_NOTSET, "access",        NULL, NULL},
00078         {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
00079 };
00080 #endif
00081 
00082 #ifdef FMAP_LASTLOG
00083 static eDBfieldMap tbl_sqlite_lastlog[] = {
00084         {TABLE_LASTLOG, NULL, FIELD_UID,         ft_INT     , flt_NOTSET,  "uid",           NULL, NULL},
00085         {TABLE_LASTLOG, NULL, FIELD_CERTID,      ft_INT     , flt_NOTSET,  "certid",        NULL, NULL},
00086         {TABLE_LASTLOG, NULL, FIELD_REMOTEIP,    ft_STRING  , flt_NOTSET,  "remotehost",    NULL, NULL},
00087         {TABLE_LASTLOG, NULL, FIELD_VPNIP,       ft_STRING  , flt_NOTSET,  "vpnipaddr",     NULL, NULL},
00088         {TABLE_LASTLOG, NULL, FIELD_SESSTATUS,   ft_STRING  , flt_NOTSET,  "status",        NULL, NULL},
00089         {TABLE_LASTLOG, NULL, FIELD_LOGIN,       ft_DATETIME, flt_NOTSET,  "login" ,        NULL, NULL},
00090         {TABLE_LASTLOG, NULL, FIELD_LOGOUT,      ft_DATETIME, flt_NOTSET,  "logout",        NULL, NULL},
00091         {TABLE_LASTLOG, NULL, FIELD_RECID,       ft_INT     , flt_NOTSET,  "llid",          NULL, NULL},
00092         {TABLE_LASTLOG, NULL, FIELD_UNAME,       ft_STRING  , flt_NOTSET,  "username",      NULL, NULL},
00093         {TABLE_LASTLOG, NULL, FIELD_MACADDR,     ft_STRING  , flt_NOTSET,  "macaddr",       NULL, NULL},
00094         {TABLE_LASTLOG, NULL, FIELD_UICID,       ft_STRING  , flt_NOTSET,  "uicid",         NULL, NULL},
00095         {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
00096 };
00097 #endif
00098 
00099 #ifdef FMAP_OVPNACCESSES
00100 static eDBfieldMap tbl_sqlite_openvpnaccesses[] = {
00101         {TABLE_FWPROFILES,   NULL,     FIELD_DESCR,      ft_STRING      , flt_NOTSET,  "access_descr",  NULL, NULL},
00102         {TABLE_FWPROFILES,   NULL,     FIELD_FWPROFILE,  ft_STRING      , flt_NOTSET,  "fw_profile",    NULL, NULL},
00103         {TABLE_FWPROFILES,   NULL,     FIELD_RECID,      ft_INT         , flt_NOTSET,  "accessprofile", NULL, NULL},
00104         {TABLE_FWPROFILES,   NULL,     FIELD_UID,        ft_INT         , flt_NOTSET,  "uid",           NULL, NULL},
00105         {TABLE_FWPROFILES,   NULL,     FIELD_UNAME,      ft_STRING      , flt_NOTSET,  "username",      NULL, NULL},
00106         {TABLE_FWPROFILES,   NULL,     FIELD_CERTID,     ft_INT         , flt_NOTSET,  "certid",        NULL, NULL},
00107         {TABLE_FWPROFILES,   NULL,     FIELD_CNAME,      ft_STRING      , flt_NOTSET,  "common_name",   NULL, NULL},
00108         {TABLE_FWPROFILES,   NULL,     FIELD_ORG,        ft_STRING      , flt_NOTSET,  "organisation",  NULL, NULL},
00109         {TABLE_FWPROFILES,   NULL,     FIELD_EMAIL,      ft_STRING      , flt_NOTSET,  "email",         NULL, NULL},
00110         {TABLE_FWPROFILES,   NULL,     FIELD_CERTDIGEST, ft_STRING_LOWER, flt_NOTSET,  "digest",        NULL, NULL},
00111         {TABLE_FWPROFILES,   NULL,     FIELD_REGISTERED, ft_DATETIME    , flt_NOTSET,  "registered",    NULL, NULL},
00112         {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
00113 };
00114 #endif
00115 
00116 #ifdef FMAP_OVPNATTEMPTS
00117 static eDBfieldMap tbl_sqlite_attempts[] = {
00118         {TABLE_ATTEMPTS, NULL, FIELD_UNAME,       ft_STRING      , flt_NOTSET, "username",     NULL, NULL},
00119         {TABLE_ATTEMPTS, NULL, FIELD_REMOTEIP,    ft_STRING      , flt_NOTSET, "remoteip",     NULL, NULL},
00120         {TABLE_ATTEMPTS, NULL, FIELD_CERTDIGEST,  ft_STRING_LOWER, flt_NOTSET, "digest",       NULL, NULL},
00121         {TABLE_ATTEMPTS, NULL, FIELD_ATTEMPTS,    ft_INT         , flt_NOTSET, "attempts",     NULL, NULL},
00122         {TABLE_ATTEMPTS, NULL, FIELD_REGISTERED,  ft_DATETIME    , flt_NOTSET, "registered",   NULL, NULL},
00123         {TABLE_ATTEMPTS, NULL, FIELD_LASTATTEMPT, ft_DATETIME    , flt_NOTSET, "last_attempt", NULL, NULL},
00124         {TABLE_ATTEMPTS, NULL, FIELD_RECID,       ft_INT         , flt_NOTSET, "atpid",        NULL, NULL },
00125         {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
00126 };
00127 #endif
00128 
00129 #ifdef FMAP_OVPNBLACKLIST
00130 static eDBfieldMap tbl_sqlite_blacklist[] = {
00131         {TABLE_BLACKLIST, NULL, FIELD_UNAME,       ft_STRING      , flt_NOTSET, "username",      NULL, NULL},
00132         {TABLE_BLACKLIST, NULL, FIELD_REMOTEIP,    ft_STRING      , flt_NOTSET, "remoteip",      NULL, NULL},
00133         {TABLE_BLACKLIST, NULL, FIELD_CERTDIGEST,  ft_STRING_LOWER, flt_NOTSET, "digest",        NULL, NULL},
00134         {TABLE_BLACKLIST, NULL, FIELD_REGISTERED,  ft_DATETIME    , flt_NOTSET, "registered",    NULL, NULL},
00135         {TABLE_BLACKLIST, NULL, FIELD_LASTACCESS,  ft_DATETIME    , flt_NOTSET, "last_accessed", NULL, NULL},
00136         {TABLE_BLACKLIST, NULL, FIELD_RECID,       ft_INT         , flt_NOTSET, "blid",          NULL, NULL},
00137         {0, NULL, 0, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
00138 };
00139 #endif
00140 
00141 #endif      /* !FIELDMAPPING_H_ */