Differences

This shows you the differences between two versions of the page.

--- install:upgrade:5.3.x-to-5.4.0 [2020/07/17 07:05] – [MySQL Database Structure] miconda
+++ install:upgrade:5.3.x-to-5.4.0 [2020/08/03 11:44] (current) – [MySQL Database Structure] miconda
@@ Line 1: / Line 1: @@
-====== Upgrade Kamailio from v5.3.x to v5.4.0 (devel) ======
+====== Upgrade Kamailio from v5.3.x to v5.4.0 ======
 The page contains the details about the changes that were made to old components during the development of v5.4.0 compared with what existed in v5.3.x. It does not include the brand new modules, focusing on how to upgrade database and configuration file from v5.3.x to run with Kamailio devel.
@@ Line 61: / Line 61: @@
 -- version table - added id column to facilitate records management with external tools
 -- * the column is not used by Kamailio, thus is optional to be create
-ALTER TABLE version ADD COLUMN `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
-ALTER TABLE version ADD PRIMARY KEY (`id`);
+ALTER TABLE `version` ADD COLUMN `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (`id`);
 </code>