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:16] – [Upgrade Kamailio from v5.3.x to v5.4.0 (devel)] miconda
+++ install:upgrade:5.3.x-to-5.4.0 [2020/08/03 11:44] (current) – [MySQL Database Structure] miconda
@@ 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>