Zabbix

/*

** Zabbix

** Copyright (C) 2001-2025 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.

**/

​

#include "dbupgrade.h"

​

#include "common.h"

#include "db.h"

#include "log.h"

#include "zbxdbupgrade.h"

​

typedef struct

{

    zbx_dbpatch_t   *patches;

    const char  *description;

}

zbx_db_version_t;

​

#ifdef HAVE_MYSQL

#   define ZBX_DB_TABLE_OPTIONS " engine=innodb"

#   define ZBX_DROP_FK      " drop foreign key"

#else

#   define ZBX_DB_TABLE_OPTIONS ""

#   define ZBX_DROP_FK      " drop constraint"

#endif

​

#if defined(HAVE_POSTGRESQL)

#   define ZBX_DB_ALTER_COLUMN  " alter"

#else

#   define ZBX_DB_ALTER_COLUMN  " modify"

#endif

​

#if defined(HAVE_POSTGRESQL)

#   define ZBX_DB_SET_TYPE      " type"

#else

#   define ZBX_DB_SET_TYPE      ""

#endif

​

/* NOTE: Do not forget to sync changes in ZBX_TYPE_*_STR defines for Oracle with zbx_oracle_column_type()! */

​

#if defined(HAVE_MYSQL)

#   define ZBX_TYPE_ID_STR      "bigint unsigned"

#   define ZBX_TYPE_FLOAT_STR   "double precision"

#   define ZBX_TYPE_UINT_STR    "bigint unsigned"

#   define ZBX_TYPE_LONGTEXT_STR    "longtext"

#elif defined(HAVE_ORACLE)

#   define ZBX_TYPE_ID_STR      "number(20)"

#   define ZBX_TYPE_FLOAT_STR   "binary_double"

#   define ZBX_TYPE_UINT_STR    "number(20)"

#   define ZBX_TYPE_LONGTEXT_STR    "nclob"

#elif defined(HAVE_POSTGRESQL)

#   define ZBX_TYPE_ID_STR      "bigint"

#   define ZBX_TYPE_FLOAT_STR   "double precision"

#   define ZBX_TYPE_UINT_STR    "numeric(20)"

#   define ZBX_TYPE_LONGTEXT_STR    "text"

#endif

​

#if defined(HAVE_ORACLE)

#   define ZBX_TYPE_INT_STR     "number(10)"

#   define ZBX_TYPE_CHAR_STR    "nvarchar2"

#   define ZBX_TYPE_SHORTTEXT_STR   "nvarchar2(2048)"

#   define ZBX_TYPE_TEXT_STR    "nclob"

#else

#   define ZBX_TYPE_INT_STR     "integer"

#   define ZBX_TYPE_CHAR_STR    "varchar"

#   define ZBX_TYPE_SHORTTEXT_STR   "text"

#   define ZBX_TYPE_TEXT_STR    "text"

#endif

​

#define ZBX_FIRST_DB_VERSION        2010000

​

extern unsigned char    program_type;

​

#ifndef HAVE_SQLITE3

static void DBfield_type_string(char **sql, size_t *sql_alloc, size_t *sql_offset, const ZBX_FIELD *field)

{