[sr-dev] git:master:859ee540: ims_usr_pcscf: Updated DB-Schema

[Carsten Bock]

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

Author: Carsten Bock <carsten at ng-voice.com>
Committer: Carsten Bock <carsten at ng-voice.com>
Date: 2015-09-28T18:07:42+02:00

ims_usr_pcscf: Updated DB-Schema

---

Modified: utils/kamctl/mysql/ims_usrloc_pcscf-create.sql

---

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

---

diff --git a/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql b/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql
index aa41ef6..1240afa 100644
--- a/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql
+++ b/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql
@@ -1,13 +1,15 @@
 INSERT INTO version (table_name, table_version) values ('location','6');
 CREATE TABLE `location` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `domain` varchar(64) DEFAULT NULL,
+  `domain` varchar(64) NOT NULL,
   `aor` varchar(255) NOT NULL,
-  `contact` varchar(255) DEFAULT NULL,
+  `host` varchar(100) NOT NULL,
+  `port` int(10) NOT NULL,
   `received` varchar(128) DEFAULT NULL,
   `received_port` int(10) unsigned DEFAULT NULL,
   `received_proto` int(10) unsigned DEFAULT NULL,
   `path` varchar(512) DEFAULT NULL,
+  `rinstance` varchar(255) DEFAULT NULL,
   `rx_session_id` varchar(256) DEFAULT NULL,
   `reg_state` tinyint(4) DEFAULT NULL,
   `expires` datetime DEFAULT '2030-05-28 21:32:15',