diff options
-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 7c982585efc..4c5a690be0e 100644 --- a/src/libs/zbxdbupgrade/dbupgrade_5010.c +++ b/src/libs/zbxdbupgrade/dbupgrade_5010.c @@ -329,8 +329,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}, |