Zabbix

/*

** Copyright (C) 2001-2024 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 "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

​

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

#   define ZBX_TYPE_BLOB_STR        "bytea"

#   define ZBX_TYPE_SERIAL_STR      "bigserial"

#   define ZBX_TYPE_SERIAL_SUFFIX_STR   ""

#endif

​

#define ZBX_TYPE_INT_STR    "integer"

#define ZBX_TYPE_CHAR_STR   "varchar"