Module: sip-router Branch: master Commit: 1d44402af09d6252be3bbf6fa2b68140b09de2cf URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1d44402… Author: Jason Penton <jason.penton(a)gmail.com> Committer: Jason Penton <jason.penton(a)gmail.com> Date: Fri Apr 4 10:58:55 2014 +0200 utils/kamctl/mysql: sdded chema for ims_usrloc_pcscf --- utils/kamctl/mysql/ims_usrloc_pcscf-create.sql | 45 ++++++++++++++++++++++++ 1 files changed, 45 insertions(+), 0 deletions(-) diff --git a/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql b/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql new file mode 100644 index 0000000..aa41ef6 --- /dev/null +++ b/utils/kamctl/mysql/ims_usrloc_pcscf-create.sql @@ -0,0 +1,45 @@ +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, + `aor` varchar(255) NOT NULL, + `contact` varchar(255) DEFAULT 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, + `rx_session_id` varchar(256) DEFAULT NULL, + `reg_state` tinyint(4) DEFAULT NULL, + `expires` datetime DEFAULT '2030-05-28 21:32:15', + `service_routes` varchar(2048) DEFAULT NULL, + `socket` varchar(64) DEFAULT NULL, + `public_ids` varchar(2048) DEFAULT NULL, + `security_type` int(11) DEFAULT NULL, + `protocol` char(5) DEFAULT NULL, + `mode` char(10) DEFAULT NULL, + `ck` varchar(100) DEFAULT NULL, + `ik` varchar(100) DEFAULT NULL, + `ealg` char(20) DEFAULT NULL, + `ialg` char(20) DEFAULT NULL, + `port_uc` int(11) unsigned DEFAULT NULL, + `port_us` int(11) unsigned DEFAULT NULL, + `spi_pc` int(11) unsigned DEFAULT NULL, + `spi_ps` int(11) unsigned DEFAULT NULL, + `spi_uc` int(11) unsigned DEFAULT NULL, + `spi_us` int(11) unsigned DEFAULT NULL, + `t_security_type` int(11) DEFAULT NULL, + `t_port_uc` int(11) unsigned DEFAULT NULL, + `t_port_us` int(11) unsigned DEFAULT NULL, + `t_spi_pc` int(11) unsigned DEFAULT NULL, + `t_spi_ps` int(11) unsigned DEFAULT NULL, + `t_spi_uc` int(11) unsigned DEFAULT NULL, + `t_spi_us` int(11) unsigned DEFAULT NULL, + `t_protocol` char(5) DEFAULT NULL, + `t_mode` char(10) DEFAULT NULL, + `t_ck` varchar(100) DEFAULT NULL, + `t_ik` varchar(100) DEFAULT NULL, + `t_ealg` char(20) DEFAULT NULL, + `t_ialg` char(20) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `aor` (`aor`) +);