Module: kamailio Branch: master Commit: 859ee540c593c25a2a96893795ac1ec6e22b9c22 URL: https://github.com/kamailio/kamailio/commit/859ee540c593c25a2a96893795ac1ec6e22b9c22
Author: Carsten Bock <[email protected]> Committer: Carsten Bock <[email protected]> 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', _______________________________________________ sr-dev mailing list [email protected] http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
