Module: kamailio Branch: master Commit: 9be2a96651f743af0a22d0534ee9fc90e857d484 URL: https://github.com/kamailio/kamailio/commit/9be2a96651f743af0a22d0534ee9fc90...
Author: Andrew Siplas andrew@asiplas.net Committer: Andrew Siplas andrew@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/6c01e2692d5ff56dda54d21469d32c4d3d...)
---
Modified: src/modules/p_usrloc/location.sql
---
Diff: https://github.com/kamailio/kamailio/commit/9be2a96651f743af0a22d0534ee9fc90... Patch: https://github.com/kamailio/kamailio/commit/9be2a96651f743af0a22d0534ee9fc90...
---
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);
-
Andrew Siplas