[sr-dev] git:master: utils/kamctl/mysql: added schema for ims_usrloc_scscf

[Jason Penton]

Module: sip-router
Branch: master
Commit: 9beb8de04fb5c37fef265c54503870e5550fa02b
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=9beb8de04fb5c37fef265c54503870e5550fa02b

Author: Jason Penton <jason.penton at gmail.com>
Committer: Jason Penton <jason.penton at gmail.com>
Date:   Fri Apr  4 11:02:03 2014 +0200

utils/kamctl/mysql: added schema for ims_usrloc_scscf

---

 utils/kamctl/mysql/ims_usrloc_scscf-create.sql |   36 ++++++++++++++++++++++++
 1 files changed, 36 insertions(+), 0 deletions(-)

diff --git a/utils/kamctl/mysql/ims_usrloc_scscf-create.sql b/utils/kamctl/mysql/ims_usrloc_scscf-create.sql
new file mode 100644
index 0000000..fc17166
--- /dev/null
+++ b/utils/kamctl/mysql/ims_usrloc_scscf-create.sql
@@ -0,0 +1,36 @@
+INSERT INTO version (table_name, table_version) values ('contact','6');
+CREATE TABLE `contact` (
+  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `contact` char(255) NOT NULL,
+  `path` varchar(255) DEFAULT NULL,
+  `received` varchar(255) DEFAULT NULL,
+  `user_agent` varchar(255) DEFAULT NULL,
+  `expires` datetime DEFAULT NULL,
+  `callid` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `contact` (`contact`)
+);
+
+INSERT INTO version (table_name, table_version) values ('impu','6');
+CREATE TABLE `impu` (
+  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `impu` char(64) NOT NULL,
+  `barring` int(1) DEFAULT '0',
+  `reg_state` int(11) DEFAULT '0',
+  `ccf1` char(64) DEFAULT NULL,
+  `ccf2` char(64) DEFAULT NULL,
+  `ecf1` char(64) DEFAULT NULL,
+  `ecf2` char(64) DEFAULT NULL,
+  `ims_subscription_data` blob,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `impu` (`impu`)
+);
+
+INSERT INTO version (table_name, table_version) values ('impu_contact','6');
+CREATE TABLE `impu_contact` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `impu_id` int(11) NOT NULL,
+  `contact_id` int(11) NOT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `impu_id` (`impu_id`,`contact_id`)
+);