[sr-dev] git:master: lib/srdb1/schema: use &ip_addr_len; entity in address and lcr_gw schema

Module: sip-router Branch: master Commit: dba0691a98a329be489d83dfc1cd9560419bc35e URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=dba0691… Author: Juha Heinanen &lt;jh(a)tutpro.com&gt; Committer: Juha Heinanen &lt;jh(a)tutpro.com&gt; Date: Sun Oct 28 14:32:36 2012 +0200 lib/srdb1/schema: use &ip_addr_len; entity in address and lcr_gw schema --- lib/srdb1/schema/address.xml | 4 ++-- lib/srdb1/schema/lcr_gw.xml | 4 ++-- modules/lcr/lcr_mod.c | 2 +- modules_k/permissions/address.c | 2 +- utils/kamctl/db_berkeley/kamailio/version | 4 ++-- utils/kamctl/db_sqlite/lcr-create.sql | 4 ++-- utils/kamctl/db_sqlite/permissions-create.sql | 4 ++-- utils/kamctl/dbtext/kamailio/version | 4 ++-- utils/kamctl/mysql/lcr-create.sql | 4 ++-- utils/kamctl/mysql/permissions-create.sql | 4 ++-- utils/kamctl/oracle/lcr-create.sql | 4 ++-- utils/kamctl/oracle/permissions-create.sql | 4 ++-- utils/kamctl/postgres/lcr-create.sql | 4 ++-- utils/kamctl/postgres/permissions-create.sql | 4 ++-- 14 files changed, 26 insertions(+), 26 deletions(-) diff --git a/lib/srdb1/schema/address.xml b/lib/srdb1/schema/address.xml index be380ee..d757f1a 100644 --- a/lib/srdb1/schema/address.xml +++ b/lib/srdb1/schema/address.xml @@ -9,7 +9,7 @@ <table id="address" xmlns:db="http://docbook.org/ns/docbook"> <name>address</name> - <version>5</version> + <version>6</version> <type db="mysql">&MYSQL_TABLE_TYPE;</type> <description> <db:para>This table is used by the permissions module. More information is available at: &KAMAILIO_MOD_DOC;permissions.html @@ -38,7 +38,7 @@ <column> <name>ip_addr</name> <type>string</type> - <size>48</size> + <size>&ip_add_len;</size> <description>IP address</description> </column> diff --git a/lib/srdb1/schema/lcr_gw.xml b/lib/srdb1/schema/lcr_gw.xml index 3c9513b..cb8a8c0 100644 --- a/lib/srdb1/schema/lcr_gw.xml +++ b/lib/srdb1/schema/lcr_gw.xml @@ -10,7 +10,7 @@ <table id="lcr_gw" xmlns:db="http://docbook.org/ns/docbook"> <name>lcr_gw</name> - <version>2</version> + <version>3</version> <type db="mysql">&MYSQL_TABLE_TYPE;</type> <description> <db:para>This table is used by lcr (Least Cost Routing) module @@ -46,7 +46,7 @@ <column id="ip_addr"> <name>ip_addr</name> <type>string</type> - <size>47</size> + <size>&ip_add_len;</size> <null/> <description>IPv4 or IPv6 Address of the gateway</description> </column> diff --git a/modules/lcr/lcr_mod.c b/modules/lcr/lcr_mod.c index 6574229..757734d 100644 --- a/modules/lcr/lcr_mod.c +++ b/modules/lcr/lcr_mod.c @@ -91,7 +91,7 @@ MODULE_VERSION */ #define LCR_RULE_TABLE_VERSION 2 #define LCR_RULE_TARGET_TABLE_VERSION 1 -#define LCR_GW_TABLE_VERSION 2 +#define LCR_GW_TABLE_VERSION 3 /* database defaults */ diff --git a/modules_k/permissions/address.c b/modules_k/permissions/address.c index 3279310..5dbe547 100644 --- a/modules_k/permissions/address.c +++ b/modules_k/permissions/address.c @@ -44,7 +44,7 @@ #include "../../ut.h" #include "../../resolve.h" -#define TABLE_VERSION 5 +#define TABLE_VERSION 6 struct addr_list ***addr_hash_table; /* Ptr to current hash table ptr */ struct addr_list **addr_hash_table_1; /* Pointer to hash table 1 */ diff --git a/utils/kamctl/db_berkeley/kamailio/version b/utils/kamctl/db_berkeley/kamailio/version index 4d0e5ee..61f4be3 100644 --- a/utils/kamctl/db_berkeley/kamailio/version +++ b/utils/kamctl/db_berkeley/kamailio/version @@ -13,7 +13,7 @@ acc|4 active_watchers| active_watchers|11 address| -address|5 +address|6 aliases| aliases|6 carrier_name| @@ -61,7 +61,7 @@ imc_members|1 imc_rooms| imc_rooms|1 lcr_gw| -lcr_gw|2 +lcr_gw|3 lcr_rule| lcr_rule|2 lcr_rule_target| diff --git a/utils/kamctl/db_sqlite/lcr-create.sql b/utils/kamctl/db_sqlite/lcr-create.sql index 63eb37d..b660922 100644 --- a/utils/kamctl/db_sqlite/lcr-create.sql +++ b/utils/kamctl/db_sqlite/lcr-create.sql @@ -1,9 +1,9 @@ -INSERT INTO version (table_name, table_version) values ('lcr_gw','2'); +INSERT INTO version (table_name, table_version) values ('lcr_gw','3'); CREATE TABLE lcr_gw ( id INTEGER PRIMARY KEY NOT NULL, lcr_id SMALLINT NOT NULL, gw_name VARCHAR(128), - ip_addr VARCHAR(47), + ip_addr VARCHAR(50), hostname VARCHAR(64), port SMALLINT, params VARCHAR(64), diff --git a/utils/kamctl/db_sqlite/permissions-create.sql b/utils/kamctl/db_sqlite/permissions-create.sql index e0c3f59..0875431 100644 --- a/utils/kamctl/db_sqlite/permissions-create.sql +++ b/utils/kamctl/db_sqlite/permissions-create.sql @@ -9,11 +9,11 @@ CREATE TABLE trusted ( CREATE INDEX trusted_peer_idx ON trusted (src_ip); -INSERT INTO version (table_name, table_version) values ('address','5'); +INSERT INTO version (table_name, table_version) values ('address','6'); CREATE TABLE address ( id INTEGER PRIMARY KEY NOT NULL, grp INTEGER DEFAULT 1 NOT NULL, - ip_addr VARCHAR(48) NOT NULL, + ip_addr VARCHAR(50) NOT NULL, mask INTEGER DEFAULT 32 NOT NULL, port SMALLINT DEFAULT 0 NOT NULL, tag VARCHAR(64) diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version index 996c37f..b362eef 100644 --- a/utils/kamctl/dbtext/kamailio/version +++ b/utils/kamctl/dbtext/kamailio/version @@ -1,7 +1,7 @@ table_name(string) table_version(int) acc:4 active_watchers:11 -address:5 +address:6 aliases:6 carrier_name:1 carrierfailureroute:2 @@ -25,7 +25,7 @@ grp:2 htable:2 imc_members:1 imc_rooms:1 -lcr_gw:2 +lcr_gw:3 lcr_rule:2 lcr_rule_target:1 location:6 diff --git a/utils/kamctl/mysql/lcr-create.sql b/utils/kamctl/mysql/lcr-create.sql index efa65b2..f6e2037 100644 --- a/utils/kamctl/mysql/lcr-create.sql +++ b/utils/kamctl/mysql/lcr-create.sql @@ -1,9 +1,9 @@ -INSERT INTO version (table_name, table_version) values ('lcr_gw','2'); +INSERT INTO version (table_name, table_version) values ('lcr_gw','3'); 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(47), + ip_addr VARCHAR(50), hostname VARCHAR(64), port SMALLINT UNSIGNED, params VARCHAR(64), diff --git a/utils/kamctl/mysql/permissions-create.sql b/utils/kamctl/mysql/permissions-create.sql index 660ac6f..dfa158c 100644 --- a/utils/kamctl/mysql/permissions-create.sql +++ b/utils/kamctl/mysql/permissions-create.sql @@ -9,11 +9,11 @@ CREATE TABLE trusted ( CREATE INDEX peer_idx ON trusted (src_ip); -INSERT INTO version (table_name, table_version) values ('address','5'); +INSERT INTO version (table_name, table_version) values ('address','6'); CREATE TABLE address ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, grp INT(11) UNSIGNED DEFAULT 1 NOT NULL, - ip_addr VARCHAR(48) NOT NULL, + ip_addr VARCHAR(50) NOT NULL, mask INT DEFAULT 32 NOT NULL, port SMALLINT(5) UNSIGNED DEFAULT 0 NOT NULL, tag VARCHAR(64) diff --git a/utils/kamctl/oracle/lcr-create.sql b/utils/kamctl/oracle/lcr-create.sql index 5fe88a0..8c022d8 100644 --- a/utils/kamctl/oracle/lcr-create.sql +++ b/utils/kamctl/oracle/lcr-create.sql @@ -1,9 +1,9 @@ -INSERT INTO version (table_name, table_version) values ('lcr_gw','2'); +INSERT INTO version (table_name, table_version) values ('lcr_gw','3'); CREATE TABLE lcr_gw ( id NUMBER(10) PRIMARY KEY, lcr_id NUMBER(5), gw_name VARCHAR2(128), - ip_addr VARCHAR2(47), + ip_addr VARCHAR2(50), hostname VARCHAR2(64), port NUMBER(5), params VARCHAR2(64), diff --git a/utils/kamctl/oracle/permissions-create.sql b/utils/kamctl/oracle/permissions-create.sql index 6b934cc..32ccb22 100644 --- a/utils/kamctl/oracle/permissions-create.sql +++ b/utils/kamctl/oracle/permissions-create.sql @@ -17,11 +17,11 @@ BEGIN map2users('trusted'); END; / CREATE INDEX trusted_peer_idx ON trusted (src_ip); -INSERT INTO version (table_name, table_version) values ('address','5'); +INSERT INTO version (table_name, table_version) values ('address','6'); CREATE TABLE address ( id NUMBER(10) PRIMARY KEY, grp NUMBER(10) DEFAULT 1 NOT NULL, - ip_addr VARCHAR2(48), + ip_addr VARCHAR2(50), mask NUMBER(10) DEFAULT 32 NOT NULL, port NUMBER(5) DEFAULT 0 NOT NULL, tag VARCHAR2(64) diff --git a/utils/kamctl/postgres/lcr-create.sql b/utils/kamctl/postgres/lcr-create.sql index 958213a..655d116 100644 --- a/utils/kamctl/postgres/lcr-create.sql +++ b/utils/kamctl/postgres/lcr-create.sql @@ -1,9 +1,9 @@ -INSERT INTO version (table_name, table_version) values ('lcr_gw','2'); +INSERT INTO version (table_name, table_version) values ('lcr_gw','3'); CREATE TABLE lcr_gw ( id SERIAL PRIMARY KEY NOT NULL, lcr_id SMALLINT NOT NULL, gw_name VARCHAR(128), - ip_addr VARCHAR(47), + ip_addr VARCHAR(50), hostname VARCHAR(64), port SMALLINT, params VARCHAR(64), diff --git a/utils/kamctl/postgres/permissions-create.sql b/utils/kamctl/postgres/permissions-create.sql index 9e48623..95f13de 100644 --- a/utils/kamctl/postgres/permissions-create.sql +++ b/utils/kamctl/postgres/permissions-create.sql @@ -9,11 +9,11 @@ CREATE TABLE trusted ( CREATE INDEX trusted_peer_idx ON trusted (src_ip); -INSERT INTO version (table_name, table_version) values ('address','5'); +INSERT INTO version (table_name, table_version) values ('address','6'); CREATE TABLE address ( id SERIAL PRIMARY KEY NOT NULL, grp INTEGER DEFAULT 1 NOT NULL, - ip_addr VARCHAR(48) NOT NULL, + ip_addr VARCHAR(50) NOT NULL, mask INTEGER DEFAULT 32 NOT NULL, port SMALLINT DEFAULT 0 NOT NULL, tag VARCHAR(64)