Module: sip-router Branch: tmp/ims_usrloc_pcscf_db_support Commit: 59b5752a7a610bff2d89f9c279386801946b91c2 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=59b5752… Author: Jason Penton <jason.penton(a)gmail.com> Committer: Jason Penton <jason.penton(a)gmail.com> Date: Fri Nov 29 11:08:37 2013 +0200 modules/ims_usrloc_pcscf: added mysql schema for DB storage --- modules/ims_usrloc_pcscf/doc/location_pcscf.sql | 20 ++++++++++++++++++++ 1 files changed, 20 insertions(+), 0 deletions(-) diff --git a/modules/ims_usrloc_pcscf/doc/location_pcscf.sql b/modules/ims_usrloc_pcscf/doc/location_pcscf.sql new file mode 100644 index 0000000..fa46d6c --- /dev/null +++ b/modules/ims_usrloc_pcscf/doc/location_pcscf.sql @@ -0,0 +1,20 @@ +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, + PRIMARY KEY (`id`), + KEY `expires_idx` (`expires`) +) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; + +