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
|
/*
** Zabbix
** Copyright (C) 2001-2019 Zabbix SIA
**
** 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; either version 2 of the License, or
** (at your option) any later version.
**
** 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 ZABBIX_DBSCHEMA_H
#define ZABBIX_DBSCHEMA_H
/* flags */
#define ZBX_NOTNULL 0x01
#define ZBX_PROXY 0x02
/* FK flags */
#define ZBX_FK_CASCADE_DELETE 0x01
/* field types */
#define ZBX_TYPE_INT 0
#define ZBX_TYPE_CHAR 1
#define ZBX_TYPE_FLOAT 2
#define ZBX_TYPE_BLOB 3
#define ZBX_TYPE_TEXT 4
#define ZBX_TYPE_UINT 5
#define ZBX_TYPE_ID 6
#define ZBX_TYPE_SHORTTEXT 7
#define ZBX_TYPE_LONGTEXT 8
#define ZBX_MAX_FIELDS 73 /* maximum number of fields in a table plus one for null terminator in dbschema.c */
#define ZBX_TABLENAME_LEN 26
#define ZBX_TABLENAME_LEN_MAX (ZBX_TABLENAME_LEN + 1)
#define ZBX_FIELDNAME_LEN 28
#define ZBX_FIELDNAME_LEN_MAX (ZBX_FIELDNAME_LEN + 1)
typedef struct
{
const char *name;
const char *default_value;
const char *fk_table;
const char *fk_field;
unsigned short length;
unsigned char type;
unsigned char flags;
unsigned char fk_flags;
}
ZBX_FIELD;
typedef struct
{
const char *table;
const char *recid;
unsigned char flags;
ZBX_FIELD fields[ZBX_MAX_FIELDS];
const char *uniq;
}
ZBX_TABLE;
extern const ZBX_TABLE tables[];
extern const char *const db_schema;
extern const char *const db_schema_fkeys[];
extern const char *const db_schema_fkeys_drop[];
#endif
|
