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