[sr-dev] git:master:70f7a0e3: kamctl: regenerated sql creation scripts

Daniel-Constantin Mierla miconda at gmail.com
Mon Nov 19 12:52:05 CET 2018


Module: kamailio
Branch: master
Commit: 70f7a0e39d039e5154bc7313b18d361cd4ef82f6
URL: https://github.com/kamailio/kamailio/commit/70f7a0e39d039e5154bc7313b18d361cd4ef82f6

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: 2018-11-19T12:51:22+01:00

kamctl: regenerated sql creation scripts

---

Modified: utils/kamctl/db_sqlite/usrloc-create.sql
Modified: utils/kamctl/mysql/usrloc-create.sql
Modified: utils/kamctl/oracle/usrloc-create.sql
Modified: utils/kamctl/postgres/usrloc-create.sql

---

Diff:  https://github.com/kamailio/kamailio/commit/70f7a0e39d039e5154bc7313b18d361cd4ef82f6.diff
Patch: https://github.com/kamailio/kamailio/commit/70f7a0e39d039e5154bc7313b18d361cd4ef82f6.patch

---

diff --git a/utils/kamctl/db_sqlite/usrloc-create.sql b/utils/kamctl/db_sqlite/usrloc-create.sql
index c86c8f8f0b..676574f037 100644
--- a/utils/kamctl/db_sqlite/usrloc-create.sql
+++ b/utils/kamctl/db_sqlite/usrloc-create.sql
@@ -38,7 +38,7 @@ CREATE TABLE location_attrs (
     domain VARCHAR(64) DEFAULT NULL,
     aname VARCHAR(64) DEFAULT '' NOT NULL,
     atype INTEGER DEFAULT 0 NOT NULL,
-    avalue VARCHAR(255) DEFAULT '' NOT NULL,
+    avalue VARCHAR(512) DEFAULT '' NOT NULL,
     last_modified TIMESTAMP WITHOUT TIME ZONE DEFAULT '2000-01-01 00:00:01' NOT NULL
 );
 
diff --git a/utils/kamctl/mysql/usrloc-create.sql b/utils/kamctl/mysql/usrloc-create.sql
index a169ef878c..024123b949 100644
--- a/utils/kamctl/mysql/usrloc-create.sql
+++ b/utils/kamctl/mysql/usrloc-create.sql
@@ -38,7 +38,7 @@ CREATE TABLE `location_attrs` (
     `domain` VARCHAR(64) DEFAULT NULL,
     `aname` VARCHAR(64) DEFAULT '' NOT NULL,
     `atype` INT(11) DEFAULT 0 NOT NULL,
-    `avalue` VARCHAR(255) DEFAULT '' NOT NULL,
+    `avalue` VARCHAR(512) DEFAULT '' NOT NULL,
     `last_modified` DATETIME DEFAULT '2000-01-01 00:00:01' NOT NULL
 );
 
diff --git a/utils/kamctl/oracle/usrloc-create.sql b/utils/kamctl/oracle/usrloc-create.sql
index 4857ed827d..0cf6d822f1 100644
--- a/utils/kamctl/oracle/usrloc-create.sql
+++ b/utils/kamctl/oracle/usrloc-create.sql
@@ -46,7 +46,7 @@ CREATE TABLE location_attrs (
     domain VARCHAR2(64) DEFAULT NULL,
     aname VARCHAR2(64) DEFAULT '',
     atype NUMBER(10) DEFAULT 0 NOT NULL,
-    avalue VARCHAR2(255) DEFAULT '',
+    avalue VARCHAR2(512) DEFAULT '',
     last_modified DATE DEFAULT to_date('2000-01-01 00:00:01','yyyy-mm-dd hh24:mi:ss')
 );
 
diff --git a/utils/kamctl/postgres/usrloc-create.sql b/utils/kamctl/postgres/usrloc-create.sql
index 7046294784..b9e9c90583 100644
--- a/utils/kamctl/postgres/usrloc-create.sql
+++ b/utils/kamctl/postgres/usrloc-create.sql
@@ -38,7 +38,7 @@ CREATE TABLE location_attrs (
     domain VARCHAR(64) DEFAULT NULL,
     aname VARCHAR(64) DEFAULT '' NOT NULL,
     atype INTEGER DEFAULT 0 NOT NULL,
-    avalue VARCHAR(255) DEFAULT '' NOT NULL,
+    avalue VARCHAR(512) DEFAULT '' NOT NULL,
     last_modified TIMESTAMP WITHOUT TIME ZONE DEFAULT '2000-01-01 00:00:01' NOT NULL
 );
 




More information about the sr-dev mailing list