Zabbix

/*

** Zabbix

** Copyright (C) 2001-2023 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_TYPE_CUID       9

#define ZBX_TYPE_SERIAL     10

​

#define ZBX_MAX_FIELDS      104 /* 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;

​

typedef struct

{

    const char  *table;

    int     object;

}

zbx_db_table_changelog_t;

​

extern ZBX_TABLE            tables[];

extern const zbx_db_table_changelog_t   changelog_tables[];

extern const char           *const db_schema;

extern const char           *const db_schema_fkeys[];

extern const char           *const db_schema_fkeys_drop[];

​

#endif