[sr-dev] git:master:f9115fc5: Merge pull request #1266 from asiplas/master

GitHub noreply at github.com
Mon Oct 9 14:36:28 CEST 2017


Module: kamailio
Branch: master
Commit: f9115fc5fcdc0f4348e3c38b72117e09ce670226
URL: https://github.com/kamailio/kamailio/commit/f9115fc5fcdc0f4348e3c38b72117e09ce670226

Author: Lucian Balaceanu <lucian.balaceanu at 1and1.ro>
Committer: GitHub <noreply at github.com>
Date: 2017-10-09T15:36:23+03:00

Merge pull request #1266 from asiplas/master

p_usrloc: Fix #1265: missing columns in location.sql file.

---

Modified: src/modules/p_usrloc/location.sql

---

Diff:  https://github.com/kamailio/kamailio/commit/f9115fc5fcdc0f4348e3c38b72117e09ce670226.diff
Patch: https://github.com/kamailio/kamailio/commit/f9115fc5fcdc0f4348e3c38b72117e09ce670226.patch

---

diff --git a/src/modules/p_usrloc/location.sql b/src/modules/p_usrloc/location.sql
index a80902abbe..e729c0f94e 100644
--- a/src/modules/p_usrloc/location.sql
+++ b/src/modules/p_usrloc/location.sql
@@ -1,6 +1,7 @@
 drop table if exists location;
 CREATE TABLE location (
     id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
+    ruid VARCHAR(64) DEFAULT '' NOT NULL,
     username VARCHAR(64) DEFAULT '' NOT NULL,
     domain VARCHAR(64) DEFAULT NULL,
     contact VARCHAR(255) DEFAULT '' NOT NULL,
@@ -15,7 +16,8 @@ CREATE TABLE location (
     cflags INT(11) DEFAULT 0 NOT NULL,
     user_agent VARCHAR(255) DEFAULT '' NOT NULL,
     socket VARCHAR(64) DEFAULT NULL,
-    methods INT(11) DEFAULT NULL
+    methods INT(11) DEFAULT NULL,
+    reg_id INTEGER DEFAULT 0 NOT NULL
 ) ENGINE=MyISAM;
 
 CREATE INDEX account_contact_idx ON location (username, domain, contact);




More information about the sr-dev mailing list