[sr-dev] git:master: utils: Updated auto-generated db schema changes.

Andreas Granig agranig at linguin.org
Thu Dec 22 00:24:47 CET 2011


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

Author: Andreas Granig <agranig at sipwise.com>
Committer: Andreas Granig <agranig at sipwise.com>
Date:   Thu Dec 22 00:23:36 2011 +0100

utils: Updated auto-generated db schema changes.

- Generated schema files for lcr ip_addr changes.

---

 utils/kamctl/db_sqlite/lcr-create.sql |    2 +-
 utils/kamctl/mysql/lcr-create.sql     |    2 +-
 utils/kamctl/oracle/lcr-create.sql    |    2 +-
 utils/kamctl/postgres/lcr-create.sql  |    2 +-
 4 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/utils/kamctl/db_sqlite/lcr-create.sql b/utils/kamctl/db_sqlite/lcr-create.sql
index 0671625..8cb83e6 100644
--- a/utils/kamctl/db_sqlite/lcr-create.sql
+++ b/utils/kamctl/db_sqlite/lcr-create.sql
@@ -3,7 +3,7 @@ CREATE TABLE lcr_gw (
     id INTEGER PRIMARY KEY NOT NULL,
     lcr_id SMALLINT NOT NULL,
     gw_name VARCHAR(128),
-    ip_addr VARCHAR(15),
+    ip_addr VARCHAR(47),
     hostname VARCHAR(64),
     port SMALLINT,
     params VARCHAR(64),
diff --git a/utils/kamctl/mysql/lcr-create.sql b/utils/kamctl/mysql/lcr-create.sql
index f0887c5..696e095 100644
--- a/utils/kamctl/mysql/lcr-create.sql
+++ b/utils/kamctl/mysql/lcr-create.sql
@@ -3,7 +3,7 @@ CREATE TABLE lcr_gw (
     id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
     lcr_id SMALLINT UNSIGNED NOT NULL,
     gw_name VARCHAR(128),
-    ip_addr VARCHAR(15),
+    ip_addr VARCHAR(47),
     hostname VARCHAR(64),
     port SMALLINT UNSIGNED,
     params VARCHAR(64),
diff --git a/utils/kamctl/oracle/lcr-create.sql b/utils/kamctl/oracle/lcr-create.sql
index bdf3dc2..9c2f090 100644
--- a/utils/kamctl/oracle/lcr-create.sql
+++ b/utils/kamctl/oracle/lcr-create.sql
@@ -3,7 +3,7 @@ CREATE TABLE lcr_gw (
     id NUMBER(10) PRIMARY KEY,
     lcr_id NUMBER(5),
     gw_name VARCHAR2(128),
-    ip_addr VARCHAR2(15),
+    ip_addr VARCHAR2(47),
     hostname VARCHAR2(64),
     port NUMBER(5),
     params VARCHAR2(64),
diff --git a/utils/kamctl/postgres/lcr-create.sql b/utils/kamctl/postgres/lcr-create.sql
index 316e3ab..669c1c9 100644
--- a/utils/kamctl/postgres/lcr-create.sql
+++ b/utils/kamctl/postgres/lcr-create.sql
@@ -3,7 +3,7 @@ CREATE TABLE lcr_gw (
     id SERIAL PRIMARY KEY NOT NULL,
     lcr_id SMALLINT NOT NULL,
     gw_name VARCHAR(128),
-    ip_addr VARCHAR(15),
+    ip_addr VARCHAR(47),
     hostname VARCHAR(64),
     port SMALLINT,
     params VARCHAR(64),




More information about the sr-dev mailing list