Debian Codegraph @

database/sqlite/fieldmapping.h

raw
1 /* fieldmapping.h -- Contains mapping from internal eurephia field ID to
2 * SQLite3 specific field names per table
3 *
4 * GPLv2 only - Copyright (C) 2008 - 2012
5 * David Sommerseth <[email protected]>
6 *
7 * This program is free software; you can redistribute it and/or
8 * modify it under the terms of the GNU General Public License
9 * as published by the Free Software Foundation; version 2
10 * of the License.
11 *
12 * This program is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU General Public License for more details.
16 *
17 * You should have received a copy of the GNU General Public License
18 * along with this program; if not, write to the Free Software
19 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
20 *
21 */
22
23 /**
24 * @file fieldmapping.h
25 * @author David Sommerseth <[email protected]>
26 * @date 2008-12-06
27 *
28 * @brief Maps fields names from the generic field names into the ones
29 * being used in the SQLite3 database
30 *
31 */
32
33
34 #ifndef FIELDMAPPING_H_
35 # define FIELDMAPPING_H_
36
37 #ifdef FMAP_USERS
38 static eDBfieldMap tbl_sqlite_users[] = {
39 {TABLE_USERS, NULL, FIELD_RECID, ft_INT , flt_NOTSET, "uid", NULL, NULL},
40 {TABLE_USERS, NULL, FIELD_UNAME, ft_STRING , flt_NOTSET, "username", NULL, NULL},
41 {TABLE_USERS, NULL, FIELD_PASSWD, ft_PASSWD , flt_NOTSET, "password", NULL, NULL},
42 {TABLE_USERS, NULL, FIELD_ACTIVATED, ft_DATETIME, flt_NOTSET, "activated", NULL, NULL},
43 {TABLE_USERS, NULL, FIELD_DEACTIVATED, ft_DATETIME, flt_NOTSET, "deactivated", NULL, NULL},
44 {TABLE_USERS, NULL, FIELD_LASTACCESS, ft_DATETIME, flt_NOTSET, "last_accessed", NULL, NULL},
45 {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
46 };
47 #endif
48
49 #ifdef FMAP_CERTS
50 static eDBfieldMap tbl_sqlite_certs[] = {
51 {TABLE_CERTS, NULL, FIELD_RECID, ft_INT , flt_NOTSET, "certid", NULL, NULL},
52 {TABLE_CERTS, NULL, FIELD_CERTDEPTH, ft_INT , flt_NOTSET, "depth", NULL, NULL},
53 {TABLE_CERTS, NULL, FIELD_CERTDIGEST, ft_STRING_LOWER, flt_NOTSET, "digest", NULL, NULL},
54 {TABLE_CERTS, NULL, FIELD_CNAME, ft_STRING , flt_NOTSET, "common_name", NULL, NULL},
55 {TABLE_CERTS, NULL, FIELD_ORG, ft_STRING , flt_NOTSET, "organisation", NULL, NULL},
56 {TABLE_CERTS, NULL, FIELD_EMAIL, ft_STRING , flt_NOTSET, "email", NULL, NULL},
57 {TABLE_CERTS, NULL, FIELD_REGISTERED, ft_DATETIME , flt_NOTSET, "registered", NULL, NULL},
58 {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
59 };
60 #endif
61
62 #ifdef FMAP_USERCERTS
63 static eDBfieldMap tbl_sqlite_usercerts[] = {
64 {TABLE_USERCERTS, NULL, FIELD_UID, ft_INT, flt_NOTSET, "uid", NULL, NULL},
65 {TABLE_USERCERTS, NULL, FIELD_CERTID, ft_INT, flt_NOTSET, "certid", NULL, NULL},
66 {TABLE_USERCERTS, NULL, FIELD_ACCPROFILE, ft_INT, flt_NOTSET, "accessprofile", NULL, NULL},
67 {TABLE_USERCERTS, NULL, FIELD_REGISTERED, ft_INT, flt_NOTSET, "registered", NULL, NULL},
68 {TABLE_USERCERTS, NULL, FIELD_RECID, ft_INT, flt_NOTSET, "uicid", NULL, NULL},
69 {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
70 };
71 #endif
72
73 #ifdef FMAP_ADMINACCESS
74 static eDBfieldMap tbl_sqlite_eurephiaadmacc[] = {
75 {TABLE_EUREPHIAADMACC, NULL, FIELD_UID, ft_INT , flt_NOTSET, "uid", NULL, NULL},
76 {TABLE_EUREPHIAADMACC, NULL, FIELD_INTERFACE, ft_STRING, flt_NOTSET, "interface", NULL, NULL},
77 {TABLE_EUREPHIAADMACC, NULL, FIELD_ACCESSLVL, ft_STRING, flt_NOTSET, "access", NULL, NULL},
78 {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
79 };
80 #endif
81
82 #ifdef FMAP_LASTLOG
83 static eDBfieldMap tbl_sqlite_lastlog[] = {
84 {TABLE_LASTLOG, NULL, FIELD_UID, ft_INT , flt_NOTSET, "uid", NULL, NULL},
85 {TABLE_LASTLOG, NULL, FIELD_CERTID, ft_INT , flt_NOTSET, "certid", NULL, NULL},
86 {TABLE_LASTLOG, NULL, FIELD_REMOTEIP, ft_STRING , flt_NOTSET, "remotehost", NULL, NULL},
87 {TABLE_LASTLOG, NULL, FIELD_VPNIP, ft_STRING , flt_NOTSET, "vpnipaddr", NULL, NULL},
88 {TABLE_LASTLOG, NULL, FIELD_SESSTATUS, ft_STRING , flt_NOTSET, "sessionstatus", NULL, NULL},
89 {TABLE_LASTLOG, NULL, FIELD_LOGIN, ft_DATETIME, flt_NOTSET, "login" , NULL, NULL},
90 {TABLE_LASTLOG, NULL, FIELD_LOGOUT, ft_DATETIME, flt_NOTSET, "logout", NULL, NULL},
91 {TABLE_LASTLOG, NULL, FIELD_RECID, ft_INT , flt_NOTSET, "llid", NULL, NULL},
92 {TABLE_LASTLOG, NULL, FIELD_UNAME, ft_STRING , flt_NOTSET, "username", NULL, NULL},
93 {TABLE_LASTLOG, NULL, FIELD_MACADDR, ft_STRING , flt_NOTSET, "macaddr", NULL, NULL},
94 {TABLE_LASTLOG, NULL, FIELD_UICID, ft_STRING , flt_NOTSET, "uicid", NULL, NULL},
95 {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
96 };
97 #endif
98
99 #ifdef FMAP_OVPNACCESSES
100 static eDBfieldMap tbl_sqlite_openvpnaccesses[] = {
101 {TABLE_FWPROFILES, NULL, FIELD_DESCR, ft_STRING , flt_NOTSET, "access_descr", NULL, NULL},
102 {TABLE_FWPROFILES, NULL, FIELD_FWPROFILE, ft_STRING , flt_NOTSET, "fw_profile", NULL, NULL},
103 {TABLE_FWPROFILES, NULL, FIELD_RECID, ft_INT , flt_NOTSET, "accessprofile", NULL, NULL},
104 {TABLE_FWPROFILES, NULL, FIELD_UID, ft_INT , flt_NOTSET, "uid", NULL, NULL},
105 {TABLE_FWPROFILES, NULL, FIELD_UNAME, ft_STRING , flt_NOTSET, "username", NULL, NULL},
106 {TABLE_FWPROFILES, NULL, FIELD_CERTID, ft_INT , flt_NOTSET, "certid", NULL, NULL},
107 {TABLE_FWPROFILES, NULL, FIELD_CNAME, ft_STRING , flt_NOTSET, "common_name", NULL, NULL},
108 {TABLE_FWPROFILES, NULL, FIELD_ORG, ft_STRING , flt_NOTSET, "organisation", NULL, NULL},
109 {TABLE_FWPROFILES, NULL, FIELD_EMAIL, ft_STRING , flt_NOTSET, "email", NULL, NULL},
110 {TABLE_FWPROFILES, NULL, FIELD_CERTDIGEST, ft_STRING_LOWER, flt_NOTSET, "digest", NULL, NULL},
111 {TABLE_FWPROFILES, NULL, FIELD_REGISTERED, ft_DATETIME , flt_NOTSET, "registered", NULL, NULL},
112 {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
113 };
114 #endif
115
116 #ifdef FMAP_OVPNATTEMPTS
117 static eDBfieldMap tbl_sqlite_attempts[] = {
118 {TABLE_ATTEMPTS, NULL, FIELD_UNAME, ft_STRING , flt_NOTSET, "username", NULL, NULL},
119 {TABLE_ATTEMPTS, NULL, FIELD_REMOTEIP, ft_STRING , flt_NOTSET, "remoteip", NULL, NULL},
120 {TABLE_ATTEMPTS, NULL, FIELD_CERTDIGEST, ft_STRING_LOWER, flt_NOTSET, "digest", NULL, NULL},
121 {TABLE_ATTEMPTS, NULL, FIELD_ATTEMPTS, ft_INT , flt_NOTSET, "attempts", NULL, NULL},
122 {TABLE_ATTEMPTS, NULL, FIELD_REGISTERED, ft_DATETIME , flt_NOTSET, "registered", NULL, NULL},
123 {TABLE_ATTEMPTS, NULL, FIELD_LASTATTEMPT, ft_DATETIME , flt_NOTSET, "last_attempt", NULL, NULL},
124 {TABLE_ATTEMPTS, NULL, FIELD_RECID, ft_INT , flt_NOTSET, "atpid", NULL, NULL },
125 {0, NULL, FIELD_NONE, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
126 };
127 #endif
128
129 #ifdef FMAP_OVPNBLACKLIST
130 static eDBfieldMap tbl_sqlite_blacklist[] = {
131 {TABLE_BLACKLIST, NULL, FIELD_UNAME, ft_STRING , flt_NOTSET, "username", NULL, NULL},
132 {TABLE_BLACKLIST, NULL, FIELD_REMOTEIP, ft_STRING , flt_NOTSET, "remoteip", NULL, NULL},
133 {TABLE_BLACKLIST, NULL, FIELD_CERTDIGEST, ft_STRING_LOWER, flt_NOTSET, "digest", NULL, NULL},
134 {TABLE_BLACKLIST, NULL, FIELD_REGISTERED, ft_DATETIME , flt_NOTSET, "registered", NULL, NULL},
135 {TABLE_BLACKLIST, NULL, FIELD_LASTACCESS, ft_DATETIME , flt_NOTSET, "last_accessed", NULL, NULL},
136 {TABLE_BLACKLIST, NULL, FIELD_RECID, ft_INT , flt_NOTSET, "blid", NULL, NULL},
137 {0, NULL, 0, ft_UNDEF, flt_NOTSET, NULL, NULL, NULL}
138 };
139 #endif
140
141 #endif /* !FIELDMAPPING_H_ */