[sr-dev] git:master: modules/ims_usrloc_scscf: updated sql creation script

[Richard Good]

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

Author: Richard Good <richard.good at smilecoms.com>
Committer: Richard Good <richard.good at smilecoms.com>
Date:   Thu Oct 23 15:49:57 2014 +0200

modules/ims_usrloc_scscf: updated sql creation script

---

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

diff --git a/utils/kamctl/mysql/ims_usrloc_scscf-create.sql b/utils/kamctl/mysql/ims_usrloc_scscf-create.sql
index fc17166..62f41c5 100644
--- a/utils/kamctl/mysql/ims_usrloc_scscf-create.sql
+++ b/utils/kamctl/mysql/ims_usrloc_scscf-create.sql
@@ -34,3 +34,31 @@ CREATE TABLE `impu_contact` (
   PRIMARY KEY (`id`),
   UNIQUE KEY `impu_id` (`impu_id`,`contact_id`)
 );
+
+INSERT INTO version (table_name, table_version) values ('subscriber','6');
+CREATE TABLE `subscriber` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `watcher_uri` varchar(50) NOT NULL,
+  `watcher_contact` varchar(50) NOT NULL,
+  `presentity_uri` varchar(50) NOT NULL,
+  `event` int(11) NOT NULL,
+  `expires` datetime NOT NULL,
+  `version` int(11) NOT NULL,
+  `local_cseq` int(11) NOT NULL,
+  `call_id` varchar(50) NOT NULL,
+  `from_tag` varchar(50) NOT NULL,
+  `to_tag` varchar(50) NOT NULL,
+  `record_route` varchar(50) NOT NULL,
+  `sockinfo_str` varchar(50) NOT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `watcher_uri` (`event`,`watcher_contact`,`presentity_uri`)
+);
+
+INSERT INTO version (table_name, table_version) values ('impu_subscriber','6');
+CREATE TABLE `impu_subscriber` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `impu_id` int(11) NOT NULL,
+  `subscriber_id` int(11) NOT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `impu_id` (`impu_id`,`subscriber_id`)
+);