[sr-dev] git:master: kamctl: regenerated sql scripts from latest db schema
Daniel-Constantin Mierla
miconda at gmail.com
Thu Sep 8 16:06:31 CEST 2011
Module: sip-router
Branch: master
Commit: 3dde3b652f8ceb7300cf8ac3b4ce4a04dcf6b642
URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=3dde3b652f8ceb7300cf8ac3b4ce4a04dcf6b642
Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: Thu Sep 8 16:05:42 2011 +0200
kamctl: regenerated sql scripts from latest db schema
---
utils/kamctl/db_sqlite/mtree-create.sql | 9 +++++++++
utils/kamctl/db_sqlite/presence-create.sql | 2 +-
utils/kamctl/mysql/mtree-create.sql | 9 +++++++++
utils/kamctl/mysql/presence-create.sql | 2 +-
utils/kamctl/oracle/mtree-create.sql | 17 +++++++++++++++++
utils/kamctl/oracle/presence-create.sql | 2 +-
utils/kamctl/postgres/mtree-create.sql | 9 +++++++++
utils/kamctl/postgres/presence-create.sql | 2 +-
8 files changed, 48 insertions(+), 4 deletions(-)
diff --git a/utils/kamctl/db_sqlite/mtree-create.sql b/utils/kamctl/db_sqlite/mtree-create.sql
index 9b6f56f..77c0e38 100644
--- a/utils/kamctl/db_sqlite/mtree-create.sql
+++ b/utils/kamctl/db_sqlite/mtree-create.sql
@@ -6,3 +6,12 @@ CREATE TABLE mtree (
CONSTRAINT mtree_tprefix_idx UNIQUE (tprefix)
);
+INSERT INTO version (table_name, table_version) values ('mtrees','1');
+CREATE TABLE mtrees (
+ id INTEGER PRIMARY KEY NOT NULL,
+ tname VARCHAR(128) DEFAULT '' NOT NULL,
+ tprefix VARCHAR(32) DEFAULT '' NOT NULL,
+ tvalue VARCHAR(128) DEFAULT '' NOT NULL,
+ CONSTRAINT mtrees_tname_tprefix_idx UNIQUE (tname, tprefix)
+);
+
diff --git a/utils/kamctl/db_sqlite/presence-create.sql b/utils/kamctl/db_sqlite/presence-create.sql
index ae28db5..c99f3a9 100644
--- a/utils/kamctl/db_sqlite/presence-create.sql
+++ b/utils/kamctl/db_sqlite/presence-create.sql
@@ -60,7 +60,7 @@ CREATE TABLE xcap (
doc_type INTEGER NOT NULL,
etag VARCHAR(64) NOT NULL,
source INTEGER NOT NULL,
- doc_uri VARCHAR(128) NOT NULL,
+ doc_uri VARCHAR(255) NOT NULL,
port INTEGER NOT NULL,
CONSTRAINT xcap_account_doc_type_idx UNIQUE (username, domain, doc_type, doc_uri)
);
diff --git a/utils/kamctl/mysql/mtree-create.sql b/utils/kamctl/mysql/mtree-create.sql
index d3ecf46..8834163 100644
--- a/utils/kamctl/mysql/mtree-create.sql
+++ b/utils/kamctl/mysql/mtree-create.sql
@@ -6,3 +6,12 @@ CREATE TABLE mtree (
CONSTRAINT tprefix_idx UNIQUE (tprefix)
) ENGINE=MyISAM;
+INSERT INTO version (table_name, table_version) values ('mtrees','1');
+CREATE TABLE mtrees (
+ id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
+ tname VARCHAR(128) DEFAULT '' NOT NULL,
+ tprefix VARCHAR(32) DEFAULT '' NOT NULL,
+ tvalue VARCHAR(128) DEFAULT '' NOT NULL,
+ CONSTRAINT tname_tprefix_idx UNIQUE (tname, tprefix)
+) ENGINE=MyISAM;
+
diff --git a/utils/kamctl/mysql/presence-create.sql b/utils/kamctl/mysql/presence-create.sql
index 6caa1f6..577ad81 100644
--- a/utils/kamctl/mysql/presence-create.sql
+++ b/utils/kamctl/mysql/presence-create.sql
@@ -60,7 +60,7 @@ CREATE TABLE xcap (
doc_type INT(11) NOT NULL,
etag VARCHAR(64) NOT NULL,
source INT(11) NOT NULL,
- doc_uri VARCHAR(128) NOT NULL,
+ doc_uri VARCHAR(255) NOT NULL,
port INT(11) NOT NULL,
CONSTRAINT account_doc_type_idx UNIQUE (username, domain, doc_type, doc_uri)
) ENGINE=MyISAM;
diff --git a/utils/kamctl/oracle/mtree-create.sql b/utils/kamctl/oracle/mtree-create.sql
index 7b74db4..f791897 100644
--- a/utils/kamctl/oracle/mtree-create.sql
+++ b/utils/kamctl/oracle/mtree-create.sql
@@ -14,3 +14,20 @@ END mtree_tr;
/
BEGIN map2users('mtree'); END;
/
+INSERT INTO version (table_name, table_version) values ('mtrees','1');
+CREATE TABLE mtrees (
+ id NUMBER(10) PRIMARY KEY,
+ tname VARCHAR2(128) DEFAULT '',
+ tprefix VARCHAR2(32) DEFAULT '',
+ tvalue VARCHAR2(128) DEFAULT '',
+ CONSTRAINT mtrees_tname_tprefix_idx UNIQUE (tname, tprefix)
+);
+
+CREATE OR REPLACE TRIGGER mtrees_tr
+before insert on mtrees FOR EACH ROW
+BEGIN
+ auto_id(:NEW.id);
+END mtrees_tr;
+/
+BEGIN map2users('mtrees'); END;
+/
diff --git a/utils/kamctl/oracle/presence-create.sql b/utils/kamctl/oracle/presence-create.sql
index 97d99de..cd3dbf5 100644
--- a/utils/kamctl/oracle/presence-create.sql
+++ b/utils/kamctl/oracle/presence-create.sql
@@ -84,7 +84,7 @@ CREATE TABLE xcap (
doc_type NUMBER(10),
etag VARCHAR2(64),
source NUMBER(10),
- doc_uri VARCHAR2(128),
+ doc_uri VARCHAR2(255),
port NUMBER(10),
CONSTRAINT xcap_account_doc_type_idx UNIQUE (username, domain, doc_type, doc_uri)
);
diff --git a/utils/kamctl/postgres/mtree-create.sql b/utils/kamctl/postgres/mtree-create.sql
index 6d60f20..a7d0164 100644
--- a/utils/kamctl/postgres/mtree-create.sql
+++ b/utils/kamctl/postgres/mtree-create.sql
@@ -6,3 +6,12 @@ CREATE TABLE mtree (
CONSTRAINT mtree_tprefix_idx UNIQUE (tprefix)
);
+INSERT INTO version (table_name, table_version) values ('mtrees','1');
+CREATE TABLE mtrees (
+ id SERIAL PRIMARY KEY NOT NULL,
+ tname VARCHAR(128) DEFAULT '' NOT NULL,
+ tprefix VARCHAR(32) DEFAULT '' NOT NULL,
+ tvalue VARCHAR(128) DEFAULT '' NOT NULL,
+ CONSTRAINT mtrees_tname_tprefix_idx UNIQUE (tname, tprefix)
+);
+
diff --git a/utils/kamctl/postgres/presence-create.sql b/utils/kamctl/postgres/presence-create.sql
index 2c74fef..104e5bf 100644
--- a/utils/kamctl/postgres/presence-create.sql
+++ b/utils/kamctl/postgres/presence-create.sql
@@ -60,7 +60,7 @@ CREATE TABLE xcap (
doc_type INTEGER NOT NULL,
etag VARCHAR(64) NOT NULL,
source INTEGER NOT NULL,
- doc_uri VARCHAR(128) NOT NULL,
+ doc_uri VARCHAR(255) NOT NULL,
port INTEGER NOT NULL,
CONSTRAINT xcap_account_doc_type_idx UNIQUE (username, domain, doc_type, doc_uri)
);
More information about the sr-dev
mailing list