diff options
author | Andris Zeila <andris.zeila@zabbix.com> | 2022-11-09 11:42:02 +0300 |
---|---|---|
committer | Andris Zeila <andris.zeila@zabbix.com> | 2022-11-09 11:42:02 +0300 |
commit | fc92ce1021f3f3760b8e651ab423bf070a1f5057 (patch) | |
tree | b97bb7322b7fb570ce3d1f97cf02ce2b033432dd | |
parent | 11bd530c6d754257dcf47faa16a7d8865c62e77b (diff) | |
parent | 94ed6d554f2faea1576437cea95b18e94e7b9976 (diff) |
.......... [ZBX-21869] fixed database upgrade from 5.0 on setups requiring primary keys for tables
Merge in ZBX/zabbix from feature/ZBX-21869-6.0 to release/6.0
* commit '94ed6d554f2faea1576437cea95b18e94e7b9976':
.D........ [ZBX-21869] added changelog entry
.......... [ZBX-21869] added primary key to the initial trigger_queue table creation patch
-rw-r--r-- | ChangeLog.d/bugfix/ZBX-21869 | 1 | ||||
-rw-r--r-- | src/libs/zbxdbupgrade/dbupgrade_5010.c | 3 |
2 files changed, 3 insertions, 1 deletions
diff --git a/ChangeLog.d/bugfix/ZBX-21869 b/ChangeLog.d/bugfix/ZBX-21869 new file mode 100644 index 00000000000..3591d2cbc09 --- /dev/null +++ b/ChangeLog.d/bugfix/ZBX-21869 @@ -0,0 +1 @@ +.......... [ZBX-21869] fixed database upgrade from 5.0 on setups requiring primary keys for tables (wiper) diff --git a/src/libs/zbxdbupgrade/dbupgrade_5010.c b/src/libs/zbxdbupgrade/dbupgrade_5010.c index c7e8fa983f6..34e25584a9d 100644 --- a/src/libs/zbxdbupgrade/dbupgrade_5010.c +++ b/src/libs/zbxdbupgrade/dbupgrade_5010.c @@ -330,8 +330,9 @@ static int DBpatch_5010036(void) static int DBpatch_5010037(void) { const ZBX_TABLE table = - {"trigger_queue", "", 0, + {"trigger_queue", "trigger_queueid", 0, { + {"trigger_queueid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, {"objectid", NULL, NULL, NULL, 0, ZBX_TYPE_ID, ZBX_NOTNULL, 0}, {"type", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, {"clock", "0", NULL, NULL, 0, ZBX_TYPE_INT, ZBX_NOTNULL, 0}, |