/* fieldmapping.h  --  Contains mapping from internal eurephia field ID to
 *                     SQLite3 specific field names per table
 *
 *  GPLv2 only - Copyright (C) 2008, 2009
 *               David Sommerseth <dazo@users.sourceforge.net>
 *
 *  This program is free software; you can redistribute it and/or
 *  modify it under the terms of the GNU General Public License
 *  as published by the Free Software Foundation; version 2
 *  of the License.
 *
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with this program; if not, write to the Free Software
 *  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 *
 */

#ifndef   	FIELDMAPPING_H_
# define   	FIELDMAPPING_H_

static eDBfieldMap tbl_sqlite_users[] = {
        {TABLE_USERS, NULL, FIELD_RECID,       ft_INT,      "uid",           NULL, NULL},
        {TABLE_USERS, NULL, FIELD_UNAME,       ft_STRING,   "username",      NULL, NULL},
        {TABLE_USERS, NULL, FIELD_PASSWD,      ft_PASSWD,   "password",      NULL, NULL},
        {TABLE_USERS, NULL, FIELD_ACTIVATED,   ft_DATETIME, "activated",     NULL, NULL},
        {TABLE_USERS, NULL, FIELD_DEACTIVATED, ft_DATETIME, "deactivated",   NULL, NULL},
        {TABLE_USERS, NULL, FIELD_LASTACCESS,  ft_DATETIME, "last_accessed", NULL, NULL},
        {0, NULL, FIELD_NONE, ft_UNDEF, NULL, NULL, NULL}
};

static eDBfieldMap tbl_sqlite_certs[] = {
        {TABLE_CERTS, NULL, FIELD_RECID,       ft_INT,      "certid",        NULL, NULL},
        {TABLE_CERTS, NULL, FIELD_CERTDEPTH,   ft_INT,      "depth",         NULL, NULL},
        {TABLE_CERTS, NULL, FIELD_CERTDIGEST,  ft_STRING,   "digest",        NULL, NULL},
        {TABLE_CERTS, NULL, FIELD_CNAME,       ft_STRING,   "common_name",   NULL, NULL},
        {TABLE_CERTS, NULL, FIELD_ORG,         ft_STRING,   "organisation",  NULL, NULL},
        {TABLE_CERTS, NULL, FIELD_EMAIL,       ft_STRING,   "email",         NULL, NULL},
        {TABLE_CERTS, NULL, FIELD_REGISTERED,  ft_DATETIME, "registered",    NULL, NULL},
        {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}
};

static eDBfieldMap tbl_sqlite_eurephiaadmacc[] = {
        {TABLE_EUREPHIAADMACC, NULL, FIELD_UID,       ft_INT,    "uid",           NULL, NULL},
        {TABLE_EUREPHIAADMACC, NULL, FIELD_INTERFACE, ft_STRING, "interface",     NULL, NULL},
        {TABLE_EUREPHIAADMACC, NULL, FIELD_ACCESSLVL, ft_STRING, "access",        NULL, NULL},
        {0, NULL, FIELD_NONE, ft_UNDEF, NULL, NULL, NULL}
};

static eDBfieldMap tbl_sqlite_lastlog[] = {
        {TABLE_LASTLOG, NULL, FIELD_UID,         ft_INT,      "uid",           NULL, NULL},
        {TABLE_LASTLOG, NULL, FIELD_CERTID,      ft_INT,      "certid",        NULL, NULL},
        {TABLE_LASTLOG, NULL, FIELD_REMOTEIP,    ft_STRING,   "remotehost",    NULL, NULL},
        {TABLE_LASTLOG, NULL, FIELD_VPNIP,       ft_STRING,   "vpnipaddr",     NULL, NULL},
        {TABLE_LASTLOG, NULL, FIELD_SESSTATUS,   ft_STRING,   "status",        NULL, NULL},
        {TABLE_LASTLOG, NULL, FIELD_LOGIN,       ft_DATETIME, "login" ,        NULL, NULL},
        {TABLE_LASTLOG, NULL, FIELD_LOGOUT,      ft_DATETIME, "logout",        NULL, NULL},
        {TABLE_LASTLOG, NULL, FIELD_RECID,       ft_INT,      "llid",          NULL, NULL},
        {TABLE_LASTLOG, NULL, FIELD_UNAME,       ft_STRING,   "username",      NULL, NULL},
        {TABLE_LASTLOG, NULL, FIELD_MACADDR,     ft_STRING,   "macaddr",       NULL, NULL},
        {TABLE_LASTLOG, NULL, FIELD_UICID,       ft_STRING,   "uicid",         NULL, NULL},
        {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_ */