[sr-dev] git:master:9be2a966: p_usrloc: Fix #1265: missing columns in location.sql file.
Andrew Siplas
andrew at asiplas.net
Mon Oct 9 14:36:27 CEST 2017
Module: kamailio
Branch: master
Commit: 9be2a96651f743af0a22d0534ee9fc90e857d484
URL: https://github.com/kamailio/kamailio/commit/9be2a96651f743af0a22d0534ee9fc90e857d484
Author: Andrew Siplas <andrew at asiplas.net>
Committer: Andrew Siplas <andrew at asiplas.net>
Date: 2017-10-08T05:41:00-04:00
p_usrloc: Fix #1265: missing columns in location.sql file.
Add columns referenced by [p_usrloc_mod.c](https://github.com/kamailio/kamailio/blob/6c01e2692d5ff56dda54d21469d32c4d3dcbfbff/src/modules/p_usrloc/p_usrloc_mod.c#L65)
---
Modified: src/modules/p_usrloc/location.sql
---
Diff: https://github.com/kamailio/kamailio/commit/9be2a96651f743af0a22d0534ee9fc90e857d484.diff
Patch: https://github.com/kamailio/kamailio/commit/9be2a96651f743af0a22d0534ee9fc90e857d484.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