Module: sip-router Branch: master Commit: b30267a4669a7621a4e9b86030d59b6ef9759517 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=b30267a4...
Author: Andreas Granig agranig@sipwise.com Committer: Andreas Granig agranig@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),