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 Affero General Public License as published by the Free Software Foundation, version 3.

**

** 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 Affero General Public License for more details.

**

** You should have received a copy of the GNU Affero General Public License along with this program.

** If not, see <https://www.gnu.org/licenses/>.

**/

​

#include "dbupgrade.h"

#include "zbxdbupgrade.h"

​

#include "zbxdbschema.h"

#include "zbxtime.h"

#include "zbxdb.h"

#include "zbxdbhigh.h"

#include "zbxstr.h"

#include "zbx_ha_constants.h"

​

#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"

#   define ZBX_TYPE_BLOB_STR        "longblob"

#   define ZBX_TYPE_SERIAL_STR      "bigint unsigned"

#   define ZBX_TYPE_SERIAL_SUFFIX_STR   "auto_increment"

#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"

#   define ZBX_TYPE_BLOB_STR        "blob"

#   define ZBX_TYPE_SERIAL_STR      "number(20)"

#   define ZBX_TYPE_SERIAL_SUFFIX_STR   ""

#elif defined(HAVE_POSTGRESQL)