Differences

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

--- install:upgrade:4.2.x-to-4.3.0 [2015/10/09 11:28] – klaus3000
+++ install:upgrade:4.2.x-to-4.3.0 [2015/10/09 12:03] (current) – klaus3000
@@ Line 46: / Line 46: @@
 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
   * sip_trace table has a new column: totag
@@ Line 64: / Line 64: @@
 DELETE FROM version WHERE table_name='location';
 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
@@ Line 105: / Line 113: @@
 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
 ALTER TABLE presentity ADD COLUMN priority INTEGER DEFAULT 0 NOT NULL;