User Tools

Site Tools


install:upgrade:4.2.x-to-4.3.0

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
install:upgrade:4.2.x-to-4.3.0 [2015/10/09 13:28]
klaus3000
install:upgrade:4.2.x-to-4.3.0 [2015/10/09 14:03] (current)
klaus3000
Line 46: Line 46:
 There are several changes to the database structure, in short: There are several changes to the database structure, in short:
  
-  * location table has three new columns: server_id, connection_id,​ keepalive+  * location ​(aliases) ​table has three new columns: server_id, connection_id,​ keepalive
   * presentity table has a new column: priority   * presentity table has a new column: priority
   * sip_trace table has a new column: totag   * sip_trace table has a new column: totag
Line 64: Line 64:
 DELETE FROM version WHERE table_name='​location';​ DELETE FROM version WHERE table_name='​location';​
 INSERT INTO version (`table_name`,​ `table_version`) values ('​location','​8'​);​ INSERT INTO version (`table_name`,​ `table_version`) values ('​location','​8'​);​
 +
 +-- table: aliases
 +ALTER TABLE aliases ADD COLUMN `server_id` INT(11) DEFAULT 0 NOT NULL;
 +ALTER TABLE aliases ADD COLUMN `connection_id` INT(11) DEFAULT 0 NOT NULL;
 +ALTER TABLE aliases ADD COLUMN `keepalive` INT(11) DEFAULT 0 NOT NULL;
 +ALTER TABLE aliases ADD COLUMN `partition` INT(11) DEFAULT 0 NOT NULL;
 +DELETE FROM version WHERE table_name='​aliases';​
 +INSERT INTO version (`table_name`,​ `table_version`) values ('​aliases','​8'​);​
  
 -- table: presentity -- table: presentity
Line 105: Line 113:
 INSERT INTO version (table_name,​ table_version) VALUES ('​location','​8'​);​ INSERT INTO version (table_name,​ table_version) VALUES ('​location','​8'​);​
    
 +-- table: aliases
 +ALTER TABLE aliases ADD COLUMN server_id INTEGER DEFAULT 0 NOT NULL;
 +ALTER TABLE aliases ADD COLUMN connection_id INTEGER DEFAULT 0 NOT NULL;
 +ALTER TABLE aliases ADD COLUMN keepalive INTEGER DEFAULT 0 NOT NULL;
 +ALTER TABLE aliases ADD COLUMN partition INTEGER DEFAULT 0 NOT NULL;
 +DELETE FROM version WHERE TABLE_NAME='​aliases';​
 +INSERT INTO version (table_name,​ table_version) VALUES ('​aliases','​8'​);​
 +
 -- table: presentity -- table: presentity
 ALTER TABLE presentity ADD COLUMN priority INTEGER DEFAULT 0 NOT NULL; ALTER TABLE presentity ADD COLUMN priority INTEGER DEFAULT 0 NOT NULL;
install/upgrade/4.2.x-to-4.3.0.txt ยท Last modified: 2015/10/09 14:03 by klaus3000