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

Module: sip-router Branch: master Commit: 98779e19b3a08a3972ba1af0af48d220359a76e0 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=98779e1… Author: Richard Good <richard.good(a)smilecoms.com> Committer: Richard Good <richard.good(a)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`) +);