[sr-dev] git:master: utils: Add database creation scripts for dialog variable table

Daniel-Constantin Mierla miconda at gmail.com
Thu Oct 6 23:26:12 CEST 2011


Hi Timo,

do you have also the xml schema for the definition of dialog_vars table? 
The table creation scripts are generated from xml spec files located in 
lib/srdb1/schema/, but i do not see the one for dialog_vars.

Also, the sql creation scripts followed the pattern: 
tablename-create.sql, in this case it is dialog-vars-create.sql instead 
of dialog_vars-create.sql -- this should be easy to fix with:

git mv oldfile newfile
...

Keeping the same pattern for these scripts is important for kamdbctl.

Cheers,
Daniel

On 8/16/11 8:33 PM, Timo Reimann wrote:
> Module: sip-router
> Branch: master
> Commit: ec21c13b86139f10d2280fe75a7ba15f3e30a83a
> URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=ec21c13b86139f10d2280fe75a7ba15f3e30a83a
>
> Author: Timo Reimann<timo.reimann at 1und1.de>
> Committer: Timo Reimann<timo.reimann at 1und1.de>
> Date:   Tue Aug 16 20:33:06 2011 +0200
>
> utils: Add database creation scripts for dialog variable table
> (dialog_vars).
>
> ---
>
>   utils/kamctl/db_berkeley/kamailio/dialog_vars |   10 ++++++++++
>   utils/kamctl/db_sqlite/dialog-vars-create.sql |   11 +++++++++++
>   utils/kamctl/dbtext/kamailio/dialog_vars      |    1 +
>   utils/kamctl/mysql/dialog-vars-create.sql     |   11 +++++++++++
>   utils/kamctl/oracle/dialog-vars-create.sql    |   19 +++++++++++++++++++
>   utils/kamctl/postgres/dialog-vars-create.sql  |   11 +++++++++++
>   6 files changed, 63 insertions(+), 0 deletions(-)
>
> diff --git a/utils/kamctl/db_berkeley/kamailio/dialog_vars b/utils/kamctl/db_berkeley/kamailio/dialog_vars
> new file mode 100644
> index 0000000..1b66d4e
> --- /dev/null
> +++ b/utils/kamctl/db_berkeley/kamailio/dialog_vars
> @@ -0,0 +1,10 @@
> +METADATA_COLUMNS
> +id(int) hash_entry(int) hash_id(int) dialog_key(str) dialog_value(str)
> +METADATA_KEY
> +1 2
> +METADATA_READONLY
> +0
> +METADATA_LOGFLAGS
> +0
> +METADATA_DEFAULTS
> +NIL|NIL|NIL|NIL|NIL
> diff --git a/utils/kamctl/db_sqlite/dialog-vars-create.sql b/utils/kamctl/db_sqlite/dialog-vars-create.sql
> new file mode 100644
> index 0000000..860a87d
> --- /dev/null
> +++ b/utils/kamctl/db_sqlite/dialog-vars-create.sql
> @@ -0,0 +1,11 @@
> +INSERT INTO version (table_name, table_version) values ('dialog_vars','1');
> +CREATE TABLE dialog_vars (
> +    id INTEGER PRIMARY KEY NOT NULL,
> +    hash_entry INTEGER NOT NULL,
> +    hash_id INTEGER NOT NULL,
> +    dialog_key VARCHAR(128) NOT NULL,
> +    dialog_value VARCHAR(512) NOT NULL
> +) ENGINE=MyISAM;
> +
> +CREATE INDEX hash_idx ON dialog_vars (hash_entry, hash_id);
> +
> diff --git a/utils/kamctl/dbtext/kamailio/dialog_vars b/utils/kamctl/dbtext/kamailio/dialog_vars
> new file mode 100644
> index 0000000..d39ef42
> --- /dev/null
> +++ b/utils/kamctl/dbtext/kamailio/dialog_vars
> @@ -0,0 +1 @@
> +id(int,auto) hash_entry(int) hash_id(int) dialog_key(string) dialog_value(string)
> diff --git a/utils/kamctl/mysql/dialog-vars-create.sql b/utils/kamctl/mysql/dialog-vars-create.sql
> new file mode 100644
> index 0000000..c8787e6
> --- /dev/null
> +++ b/utils/kamctl/mysql/dialog-vars-create.sql
> @@ -0,0 +1,11 @@
> +INSERT INTO version (table_name, table_version) values ('dialog_vars','1');
> +CREATE TABLE dialog_vars (
> +    id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
> +    hash_entry INT(10) UNSIGNED NOT NULL,
> +    hash_id INT(10) UNSIGNED NOT NULL,
> +    dialog_key VARCHAR(128) NOT NULL,
> +    dialog_value VARCHAR(512) NOT NULL
> +) ENGINE=MyISAM;
> +
> +CREATE INDEX hash_idx ON dialog_vars (hash_entry, hash_id);
> +
> diff --git a/utils/kamctl/oracle/dialog-vars-create.sql b/utils/kamctl/oracle/dialog-vars-create.sql
> new file mode 100644
> index 0000000..9dbaea7
> --- /dev/null
> +++ b/utils/kamctl/oracle/dialog-vars-create.sql
> @@ -0,0 +1,19 @@
> +INSERT INTO version (table_name, table_version) values ('dialog_vars','1');
> +CREATE TABLE dialog_vars (
> +    id NUMBER(10) PRIMARY KEY,
> +    hash_entry NUMBER(10),
> +    hash_id NUMBER(10),
> +    dialog_key VARCHAR2(128),
> +    dialog_value VARCHAR2(512)
> +);
> +
> +CREATE OR REPLACE TRIGGER dialog_vars_tr
> +before insert on dialog_vars FOR EACH ROW
> +BEGIN
> +  auto_id(:NEW.id);
> +END dialog_vars_tr;
> +/
> +BEGIN map2users('dialog_vars'); END;
> +/
> +CREATE INDEX dialog_vars_hash_idx  ON dialog_vars (hash_entry, hash_id);
> +
> diff --git a/utils/kamctl/postgres/dialog-vars-create.sql b/utils/kamctl/postgres/dialog-vars-create.sql
> new file mode 100644
> index 0000000..ccc7d68
> --- /dev/null
> +++ b/utils/kamctl/postgres/dialog-vars-create.sql
> @@ -0,0 +1,11 @@
> +INSERT INTO version (table_name, table_version) values ('dialog_vars','1');
> +CREATE TABLE dialog_vars (
> +    id SERIAL PRIMARY KEY NOT NULL,
> +    hash_entry INTEGER NOT NULL,
> +    hash_id INTEGER NOT NULL,
> +    dialog_key VARCHAR(128) NOT NULL,
> +    dialog_value VARCHAR(512)
> +);
> +
> +CREATE INDEX dialog_vars_hash_idx ON dialog_vars (hash_entry, hash_id);
> +
>
>
> _______________________________________________
> sr-dev mailing list
> sr-dev at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev

-- 
Daniel-Constantin Mierla -- http://www.asipto.com
Kamailio Advanced Training, Dec 5-8, Berlin: http://asipto.com/u/kat
http://linkedin.com/in/miconda -- http://twitter.com/miconda




More information about the sr-dev mailing list