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

Module: sip-router Branch: master Commit: 9beb8de04fb5c37fef265c54503870e5550fa02b URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=9beb8de… Author: Jason Penton <jason.penton(a)gmail.com> Committer: Jason Penton <jason.penton(a)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`) +);