[sr-dev] git:master: kamctl: added files for uac remote registrations

Module: sip-router Branch: master Commit: dc95326f228e0276c7a0b749120015e38b194027 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=dc95326… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Thu Jan 28 15:49:07 2010 +0100 kamctl: added files for uac remote registrations --- utils/kamctl/mysql/uac-create.sql | 16 ++++++++++++++++ utils/kamctl/oracle/uac-create.sql | 24 ++++++++++++++++++++++++ utils/kamctl/postgres/uac-create.sql | 16 ++++++++++++++++ 3 files changed, 56 insertions(+), 0 deletions(-) diff --git a/utils/kamctl/mysql/uac-create.sql b/utils/kamctl/mysql/uac-create.sql new file mode 100644 index 0000000..b72b5e6 --- /dev/null +++ b/utils/kamctl/mysql/uac-create.sql @@ -0,0 +1,16 @@ +INSERT INTO version (table_name, table_version) values ('uacreg','1'); +CREATE TABLE uacreg ( + id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, + l_uuid VARCHAR(64) DEFAULT '' NOT NULL, + l_username VARCHAR(64) DEFAULT '' NOT NULL, + l_domain VARCHAR(128) DEFAULT '' NOT NULL, + r_username VARCHAR(64) DEFAULT '' NOT NULL, + r_domain VARCHAR(128) DEFAULT '' NOT NULL, + realm VARCHAR(64) DEFAULT '' NOT NULL, + auth_username VARCHAR(64) DEFAULT '' NOT NULL, + auth_password VARCHAR(64) DEFAULT '' NOT NULL, + auth_proxy VARCHAR(64) DEFAULT '' NOT NULL, + expires INT DEFAULT 0 NOT NULL, + CONSTRAINT l_uuid_idx UNIQUE (l_uuid) +) ENGINE=MyISAM; + diff --git a/utils/kamctl/oracle/uac-create.sql b/utils/kamctl/oracle/uac-create.sql new file mode 100644 index 0000000..f27a269 --- /dev/null +++ b/utils/kamctl/oracle/uac-create.sql @@ -0,0 +1,24 @@ +INSERT INTO version (table_name, table_version) values ('uacreg','1'); +CREATE TABLE uacreg ( + id NUMBER(10) PRIMARY KEY, + l_uuid VARCHAR2(64) DEFAULT '', + l_username VARCHAR2(64) DEFAULT '', + l_domain VARCHAR2(128) DEFAULT '', + r_username VARCHAR2(64) DEFAULT '', + r_domain VARCHAR2(128) DEFAULT '', + realm VARCHAR2(64) DEFAULT '', + auth_username VARCHAR2(64) DEFAULT '', + auth_password VARCHAR2(64) DEFAULT '', + auth_proxy VARCHAR2(64) DEFAULT '', + expires NUMBER(10) DEFAULT 0 NOT NULL, + CONSTRAINT uacreg_l_uuid_idx UNIQUE (l_uuid) +); + +CREATE OR REPLACE TRIGGER uacreg_tr +before insert on uacreg FOR EACH ROW +BEGIN + auto_id(:NEW.id); +END uacreg_tr; +/ +BEGIN map2users('uacreg'); END; +/ diff --git a/utils/kamctl/postgres/uac-create.sql b/utils/kamctl/postgres/uac-create.sql new file mode 100644 index 0000000..19d0ca7 --- /dev/null +++ b/utils/kamctl/postgres/uac-create.sql @@ -0,0 +1,16 @@ +INSERT INTO version (table_name, table_version) values ('uacreg','1'); +CREATE TABLE uacreg ( + id SERIAL PRIMARY KEY NOT NULL, + l_uuid VARCHAR(64) DEFAULT '' NOT NULL, + l_username VARCHAR(64) DEFAULT '' NOT NULL, + l_domain VARCHAR(128) DEFAULT '' NOT NULL, + r_username VARCHAR(64) DEFAULT '' NOT NULL, + r_domain VARCHAR(128) DEFAULT '' NOT NULL, + realm VARCHAR(64) DEFAULT '' NOT NULL, + auth_username VARCHAR(64) DEFAULT '' NOT NULL, + auth_password VARCHAR(64) DEFAULT '' NOT NULL, + auth_proxy VARCHAR(64) DEFAULT '' NOT NULL, + expires INTEGER DEFAULT 0 NOT NULL, + CONSTRAINT uacreg_l_uuid_idx UNIQUE (l_uuid) +); +