[sr-dev] git:master: kamctl: regenerated dialog table creation scripts

17 Feb 2012

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

Author: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt;
Committer: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt;
Date:   Fri Feb 17 09:25:16 2012 +0100

kamctl: regenerated dialog table creation scripts

---

 utils/kamctl/db_berkeley/kamailio/dialog  |    4 ++--
 utils/kamctl/db_berkeley/kamailio/version |    2 +-
 utils/kamctl/db_sqlite/dialog-create.sql  |    7 ++++---
 utils/kamctl/dbtext/kamailio/dialog       |    2 +-
 utils/kamctl/dbtext/kamailio/version      |    2 +-
 utils/kamctl/mysql/dialog-create.sql      |    7 ++++---
 utils/kamctl/oracle/dialog-create.sql     |    7 ++++---
 utils/kamctl/postgres/dialog-create.sql   |    7 ++++---
 8 files changed, 21 insertions(+), 17 deletions(-)

diff --git a/utils/kamctl/db_berkeley/kamailio/dialog
b/utils/kamctl/db_berkeley/kamailio/dialog
index 8eb740b..7318a40 100644
--- a/utils/kamctl/db_berkeley/kamailio/dialog
+++ b/utils/kamctl/db_berkeley/kamailio/dialog
@@ -1,5 +1,5 @@
 METADATA_COLUMNS
-id(int) hash_entry(int) hash_id(int) callid(str) from_uri(str) from_tag(str) to_uri(str)
to_tag(str) caller_cseq(str) callee_cseq(str) caller_route_set(str) callee_route_set(str)
caller_contact(str) callee_contact(str) caller_sock(str) callee_sock(str) state(int)
start_time(int) timeout(int) sflags(int) toroute(int) toroute_name(str) req_uri(str)
+id(int) hash_entry(int) hash_id(int) callid(str) from_uri(str) from_tag(str) to_uri(str)
to_tag(str) caller_cseq(str) callee_cseq(str) caller_route_set(str) callee_route_set(str)
caller_contact(str) callee_contact(str) caller_sock(str) callee_sock(str) state(int)
start_time(int) timeout(int) sflags(int) iflags(int) toroute_name(str) req_uri(str)
xdata(str)
 METADATA_KEY
 1 2 
 METADATA_READONLY
@@ -7,4 +7,4 @@ METADATA_READONLY
 METADATA_LOGFLAGS
 0
 METADATA_DEFAULTS
-NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|0|0|0|NIL|NIL
+NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|NIL|0|0|0|NIL|NIL|NIL
diff --git a/utils/kamctl/db_berkeley/kamailio/version
b/utils/kamctl/db_berkeley/kamailio/version
index 09b177d..51069f2 100644
--- a/utils/kamctl/db_berkeley/kamailio/version
+++ b/utils/kamctl/db_berkeley/kamailio/version
@@ -27,7 +27,7 @@ cpl|1
 dbaliases|
 dbaliases|1
 dialog|
-dialog|5
+dialog|6
 dialog_vars|
 dialog_vars|1
 dialplan|
diff --git a/utils/kamctl/db_sqlite/dialog-create.sql
b/utils/kamctl/db_sqlite/dialog-create.sql
index b21c992..780ef0f 100644
--- a/utils/kamctl/db_sqlite/dialog-create.sql
+++ b/utils/kamctl/db_sqlite/dialog-create.sql
@@ -1,4 +1,4 @@
-INSERT INTO version (table_name, table_version) values ('dialog','5');
+INSERT INTO version (table_name, table_version) values ('dialog','6');
 CREATE TABLE dialog (
     id INTEGER PRIMARY KEY NOT NULL,
     hash_entry INTEGER NOT NULL,
@@ -20,9 +20,10 @@ CREATE TABLE dialog (
     start_time INTEGER NOT NULL,
     timeout INTEGER DEFAULT 0 NOT NULL,
     sflags INTEGER DEFAULT 0 NOT NULL,
-    toroute INTEGER DEFAULT 0 NOT NULL,
+    iflags INTEGER DEFAULT 0 NOT NULL,
     toroute_name VARCHAR(32),
-    req_uri VARCHAR(128) NOT NULL
+    req_uri VARCHAR(128) NOT NULL,
+    xdata VARCHAR(512)
 );
 
 CREATE INDEX dialog_hash_idx ON dialog (hash_entry, hash_id);
diff --git a/utils/kamctl/dbtext/kamailio/dialog b/utils/kamctl/dbtext/kamailio/dialog
index f58f905..3b24e90 100644
--- a/utils/kamctl/dbtext/kamailio/dialog
+++ b/utils/kamctl/dbtext/kamailio/dialog
@@ -1 +1 @@
-id(int,auto) hash_entry(int) hash_id(int) callid(string) from_uri(string)
from_tag(string) to_uri(string) to_tag(string) caller_cseq(string) callee_cseq(string)
caller_route_set(string,null) callee_route_set(string,null) caller_contact(string)
callee_contact(string) caller_sock(string) callee_sock(string) state(int) start_time(int)
timeout(int) sflags(int) toroute(int) toroute_name(string,null) req_uri(string) 
+id(int,auto) hash_entry(int) hash_id(int) callid(string) from_uri(string)
from_tag(string) to_uri(string) to_tag(string) caller_cseq(string) callee_cseq(string)
caller_route_set(string,null) callee_route_set(string,null) caller_contact(string)
callee_contact(string) caller_sock(string) callee_sock(string) state(int) start_time(int)
timeout(int) sflags(int) iflags(int) toroute_name(string,null) req_uri(string)
xdata(string,null) 
diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version
index d326bbf..0535359 100644
--- a/utils/kamctl/dbtext/kamailio/version
+++ b/utils/kamctl/dbtext/kamailio/version
@@ -8,7 +8,7 @@ carrierfailureroute:2
 carrierroute:3
 cpl:1
 dbaliases:1
-dialog:5
+dialog:6
 dialog_vars:1
 dialplan:1
 dispatcher:4
diff --git a/utils/kamctl/mysql/dialog-create.sql b/utils/kamctl/mysql/dialog-create.sql
index 6d73ca0..0fbbdb6 100644
--- a/utils/kamctl/mysql/dialog-create.sql
+++ b/utils/kamctl/mysql/dialog-create.sql
@@ -1,4 +1,4 @@
-INSERT INTO version (table_name, table_version) values ('dialog','5');
+INSERT INTO version (table_name, table_version) values ('dialog','6');
 CREATE TABLE dialog (
     id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
     hash_entry INT(10) UNSIGNED NOT NULL,
@@ -20,9 +20,10 @@ CREATE TABLE dialog (
     start_time INT(10) UNSIGNED NOT NULL,
     timeout INT(10) UNSIGNED DEFAULT 0 NOT NULL,
     sflags INT(10) UNSIGNED DEFAULT 0 NOT NULL,
-    toroute INT(10) UNSIGNED DEFAULT 0 NOT NULL,
+    iflags INT(10) UNSIGNED DEFAULT 0 NOT NULL,
     toroute_name VARCHAR(32),
-    req_uri VARCHAR(128) NOT NULL
+    req_uri VARCHAR(128) NOT NULL,
+    xdata VARCHAR(512)
 ) ENGINE=MyISAM;
 
 CREATE INDEX hash_idx ON dialog (hash_entry, hash_id);
diff --git a/utils/kamctl/oracle/dialog-create.sql
b/utils/kamctl/oracle/dialog-create.sql
index 9fdc370..ebedcf8 100644
--- a/utils/kamctl/oracle/dialog-create.sql
+++ b/utils/kamctl/oracle/dialog-create.sql
@@ -1,4 +1,4 @@
-INSERT INTO version (table_name, table_version) values ('dialog','5');
+INSERT INTO version (table_name, table_version) values ('dialog','6');
 CREATE TABLE dialog (
     id NUMBER(10) PRIMARY KEY,
     hash_entry NUMBER(10),
@@ -20,9 +20,10 @@ CREATE TABLE dialog (
     start_time NUMBER(10),
     timeout NUMBER(10) DEFAULT 0 NOT NULL,
     sflags NUMBER(10) DEFAULT 0 NOT NULL,
-    toroute NUMBER(10) DEFAULT 0 NOT NULL,
+    iflags NUMBER(10) DEFAULT 0 NOT NULL,
     toroute_name VARCHAR2(32),
-    req_uri VARCHAR2(128)
+    req_uri VARCHAR2(128),
+    xdata VARCHAR2(512)
 );
 
 CREATE OR REPLACE TRIGGER dialog_tr
diff --git a/utils/kamctl/postgres/dialog-create.sql
b/utils/kamctl/postgres/dialog-create.sql
index c72c5ca..9e44305 100644
--- a/utils/kamctl/postgres/dialog-create.sql
+++ b/utils/kamctl/postgres/dialog-create.sql
@@ -1,4 +1,4 @@
-INSERT INTO version (table_name, table_version) values ('dialog','5');
+INSERT INTO version (table_name, table_version) values ('dialog','6');
 CREATE TABLE dialog (
     id SERIAL PRIMARY KEY NOT NULL,
     hash_entry INTEGER NOT NULL,
@@ -20,9 +20,10 @@ CREATE TABLE dialog (
     start_time INTEGER NOT NULL,
     timeout INTEGER DEFAULT 0 NOT NULL,
     sflags INTEGER DEFAULT 0 NOT NULL,
-    toroute INTEGER DEFAULT 0 NOT NULL,
+    iflags INTEGER DEFAULT 0 NOT NULL,
     toroute_name VARCHAR(32),
-    req_uri VARCHAR(128) NOT NULL
+    req_uri VARCHAR(128) NOT NULL,
+    xdata VARCHAR(512)
 );
 
 CREATE INDEX dialog_hash_idx ON dialog (hash_entry, hash_id);



    

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

[sr-dev] git:master: kamctl: regenerated dialog table creation scripts