[sr-dev] git:tmp/ims_usrloc_pcscf_db_support: modules/ims_usrloc_pcscf: added mysql schema for DB storage

[Jason Penton]

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=59b5752a7a610bff2d89f9c279386801946b91c2

Author: Jason Penton <jason.penton at gmail.com>
Committer: Jason Penton <jason.penton at 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;
+
+