[sr-dev] git:master: kamctl: regenerated definition of address table

[Daniel-Constantin Mierla]

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

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date:   Sun Mar 28 19:18:18 2010 +0200

kamctl: regenerated definition of address table

- default value for grp column is 1

---

 utils/kamctl/db_berkeley/kamailio/address    |    2 +-
 utils/kamctl/db_berkeley/kamailio/version    |    4 ++--
 utils/kamctl/dbtext/kamailio/version         |    2 +-
 utils/kamctl/mysql/permissions-create.sql    |    2 +-
 utils/kamctl/oracle/permissions-create.sql   |    2 +-
 utils/kamctl/postgres/permissions-create.sql |    2 +-
 6 files changed, 7 insertions(+), 7 deletions(-)

diff --git a/utils/kamctl/db_berkeley/kamailio/address b/utils/kamctl/db_berkeley/kamailio/address
index 0b0ee35..1292b6d 100644
--- a/utils/kamctl/db_berkeley/kamailio/address
+++ b/utils/kamctl/db_berkeley/kamailio/address
@@ -7,4 +7,4 @@ METADATA_READONLY
 METADATA_LOGFLAGS
 0
 METADATA_DEFAULTS
-NIL|0|NIL|32|0|NIL
+NIL|1|NIL|32|0|NIL
diff --git a/utils/kamctl/db_berkeley/kamailio/version b/utils/kamctl/db_berkeley/kamailio/version
index 86f1a9a..af0c49b 100644
--- a/utils/kamctl/db_berkeley/kamailio/version
+++ b/utils/kamctl/db_berkeley/kamailio/version
@@ -16,10 +16,10 @@ address|
 address|4
 aliases|
 aliases|1004
-carrier_name|
-carrier_name|1
 carrierfailureroute|
 carrierfailureroute|2
+carrier_name|
+carrier_name|1
 carrierroute|
 carrierroute|3
 cpl|
diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version
index 8647481..eb20308 100644
--- a/utils/kamctl/dbtext/kamailio/version
+++ b/utils/kamctl/dbtext/kamailio/version
@@ -3,8 +3,8 @@ acc:4
 active_watchers:9
 address:4
 aliases:1004
-carrier_name:1
 carrierfailureroute:2
+carrier_name:1
 carrierroute:3
 cpl:1
 dbaliases:1
diff --git a/utils/kamctl/mysql/permissions-create.sql b/utils/kamctl/mysql/permissions-create.sql
index 4d71642..ae6ce8b 100644
--- a/utils/kamctl/mysql/permissions-create.sql
+++ b/utils/kamctl/mysql/permissions-create.sql
@@ -12,7 +12,7 @@ CREATE INDEX peer_idx ON trusted (src_ip);
 INSERT INTO version (table_name, table_version) values ('address','4');
 CREATE TABLE address (
     id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
-    grp SMALLINT(5) UNSIGNED DEFAULT 0 NOT NULL,
+    grp SMALLINT(5) UNSIGNED DEFAULT 1 NOT NULL,
     ip_addr VARCHAR(15) NOT NULL,
     mask TINYINT DEFAULT 32 NOT NULL,
     port SMALLINT(5) UNSIGNED DEFAULT 0 NOT NULL,
diff --git a/utils/kamctl/oracle/permissions-create.sql b/utils/kamctl/oracle/permissions-create.sql
index 6caad1a..1e1b31c 100644
--- a/utils/kamctl/oracle/permissions-create.sql
+++ b/utils/kamctl/oracle/permissions-create.sql
@@ -20,7 +20,7 @@ CREATE INDEX trusted_peer_idx  ON trusted (src_ip);
 INSERT INTO version (table_name, table_version) values ('address','4');
 CREATE TABLE address (
     id NUMBER(10) PRIMARY KEY,
-    grp NUMBER(5) DEFAULT 0 NOT NULL,
+    grp NUMBER(5) DEFAULT 1 NOT NULL,
     ip_addr VARCHAR2(15),
     mask NUMBER(5) DEFAULT 32 NOT NULL,
     port NUMBER(5) DEFAULT 0 NOT NULL,
diff --git a/utils/kamctl/postgres/permissions-create.sql b/utils/kamctl/postgres/permissions-create.sql
index e7bee3b..602c399 100644
--- a/utils/kamctl/postgres/permissions-create.sql
+++ b/utils/kamctl/postgres/permissions-create.sql
@@ -12,7 +12,7 @@ CREATE INDEX trusted_peer_idx ON trusted (src_ip);
 INSERT INTO version (table_name, table_version) values ('address','4');
 CREATE TABLE address (
     id SERIAL PRIMARY KEY NOT NULL,
-    grp SMALLINT DEFAULT 0 NOT NULL,
+    grp SMALLINT DEFAULT 1 NOT NULL,
     ip_addr VARCHAR(15) NOT NULL,
     mask SMALLINT DEFAULT 32 NOT NULL,
     port SMALLINT DEFAULT 0 NOT NULL,