1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
/* fieldmapping.h -- Contains mapping from internal eurephia field ID to
* SQLite3 specific field names per table
*
* GPLv2 - 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}
};
#endif /* !FIELDMAPPING_H_ */
|