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

[Daniel-Constantin Mierla]

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

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at 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)
+);
+