Differences

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

--- install:upgrade:4.2.x-to-4.3.0 [2015/06/10 17:22]
miconda [rtpengine]
+++ install:upgrade:4.2.x-to-4.3.0 [2015/07/20 20:00]
miconda [Upgrade Old MySQL Database Structure]
@@ Line 58: / Line 58: @@
 <code sql>
 -- table: location
-ALTER TABLE location ADD COLUMN server_id INT(11) DEFAULT 0 NOT NULL;
+ALTER TABLE location ADD COLUMN `server_id` INT(11) DEFAULT 0 NOT NULL;
-ALTER TABLE location ADD COLUMN connection_id INT(11) DEFAULT 0 NOT NULL;
+ALTER TABLE location ADD COLUMN `connection_id` INT(11) DEFAULT 0 NOT NULL;
-ALTER TABLE location ADD COLUMN keepalive INT(11) DEFAULT 0 NOT NULL;
+ALTER TABLE location ADD COLUMN `keepalive` INT(11) DEFAULT 0 NOT NULL;
-ALTER TABLE location ADD COLUMN partition INT(11) DEFAULT 0 NOT NULL;
+ALTER TABLE location ADD COLUMN `partition` INT(11) DEFAULT 0 NOT NULL;
 DELETE FROM version WHERE table_name='location';
 INSERT INTO version (`table_name`, `table_version`) values ('location','8');
 -- table: presentity
-ALTER TABLE presentity ADD COLUMN priority INT(11) DEFAULT 0 NOT NULL;
+ALTER TABLE presentity ADD COLUMN `priority` INT(11) DEFAULT 0 NOT NULL;
 DELETE FROM version WHERE table_name='presentity';
 INSERT INTO version (`table_name`, `table_version`) values ('presentity','4');
 -- table: sip_trace
-ALTER TABLE sip_trace ADD COLUMN totag VARCHAR(64) DEFAULT '' NOT NULL;
+ALTER TABLE sip_trace ADD COLUMN `totag` VARCHAR(64) DEFAULT '' NOT NULL;
 UPDATE version SET table_version='4' WHERE table_name='sip_trace';

Kamailio SIP Server Wiki