This shows you the differences between two versions of the page.
Next revision Both sides next revision | |||
install:upgrade:5.3.x-to-5.4.0 [2020/06/19 08:28] miconda created |
install:upgrade:5.3.x-to-5.4.0 [2020/07/17 09:05] miconda [MySQL Database Structure] |
||
---|---|---|---|
Line 59: | Line 59: | ||
<code sql> | <code sql> | ||
- | ... | + | -- 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`); | ||
</ | </ |