The recommended My SQL quires for database schema change during Kamailio upgrading from v.5.3 to 5.4 fails:

``` mysql> ALTER TABLE version ADD COLUMN `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT; ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key ``` The correct command is: ``` mysql> ALTER TABLE `version` ADD COLUMN `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (`id`); Query OK, 0 rows affected (0.80 sec) ``` In this case the second recommended command ``` ALTER TABLE version ADD PRIMARY KEY (`id`); ``` is not needed.

Tested on Ubuntu 18.04, with mysql v.5.7.31

Best regards, Leonid Fainshtein