sr-dev May 2020

sr-dev@lists.kamailio.org

24 participants
393 discussions

[kamailio/kamailio] ndb_redis: redis_cmd() check reply type to detect command errors (#2314)
by Victor Seva 07 May '20

07 May '20

#### Pre-Submission Checklist    - [x] Commit message has the format required by CONTRIBUTING guide - [x] Commits are split per component (core, individual modules, libs, utils, ...) - [x] Each component has a single commit (if not, squash them into one commit) - [x] No commits to README files for modules (changes must be done to docbook files in `doc/` subfolder, the README file is autogenerated) #### Type Of Change - [x] Small bug fix (non-breaking change which fixes an issue) - [ ] New feature (non-breaking change which adds new functionality) - [ ] Breaking change (fix or feature that would change existing functionality) #### Checklist:  - [ ] PR should be backported to stable branches - [x] Tested changes locally - [x] Related to issue #2300 #### Description from https://github.com/redis/hiredis#using-replies > The standard replies that redisCommand are of the type redisReply. The type field in the redisReply should be used to test what kind of reply was received: > > - REDIS_REPLY_STATUS: > The command replied with a status reply. The status string can be accessed using reply->str. The length of this string can be accessed using reply->len. > > - REDIS_REPLY_ERROR: > The command replied with an error. The error string can be accessed identical to REDIS_REPLY_STATUS. adding checks for the reply type to detect command errors You can view, comment on, or merge this pull request online at: https://github.com/kamailio/kamailio/pull/2314 -- Commit Summary -- * ndb_redis: redis_cmd() check reply type to detect command errors -- File Changes -- M src/modules/ndb_redis/redis_client.c (13) -- Patch Links -- https://github.com/kamailio/kamailio/pull/2314.patch https://github.com/kamailio/kamailio/pull/2314.diff -- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/kamailio/kamailio/pull/2314

2 2

git:master:d00b1470: ndb_redis: redis_cmd() check reply type to detect command errors
by Victor Seva 07 May '20

07 May '20

Module: kamailio Branch: master Commit: d00b14704805d728f5a845a6af900eff1ed372ac URL: https://github.com/kamailio/kamailio/commit/d00b14704805d728f5a845a6af900ef… Author: Victor Seva <linuxmaniac(a)torreviejawireless.org> Committer: Victor Seva <linuxmaniac(a)torreviejawireless.org> Date: 2020-05-07T13:09:15+02:00 ndb_redis: redis_cmd() check reply type to detect command errors fix #2300 --- Modified: src/modules/ndb_redis/redis_client.c --- Diff: https://github.com/kamailio/kamailio/commit/d00b14704805d728f5a845a6af900ef… Patch: https://github.com/kamailio/kamailio/commit/d00b14704805d728f5a845a6af900ef… --- diff --git a/src/modules/ndb_redis/redis_client.c b/src/modules/ndb_redis/redis_client.c index edeee8d597..44460aa2fd 100644 --- a/src/modules/ndb_redis/redis_client.c +++ b/src/modules/ndb_redis/redis_client.c @@ -950,6 +950,14 @@ int redisc_exec(str *srv, str *res, str *cmd, ...) goto error_exec; } } + + LM_DBG("rpl->rplRedis->type:%d\n", rpl->rplRedis->type); + if(rpl->rplRedis->type == REDIS_REPLY_ERROR) { + LM_ERR("Redis error:%.*s\n", + (int)rpl->rplRedis->len, rpl->rplRedis->str); + goto error_exec; + } + if (check_cluster_reply(rpl->rplRedis, &rsrv)) { LM_DBG("rsrv->ctxRedis = %p\n", rsrv->ctxRedis); if(rsrv->ctxRedis==NULL) @@ -984,6 +992,13 @@ int redisc_exec(str *srv, str *res, str *cmd, ...) goto error_exec; } } + + LM_DBG("rpl->rplRedis->type:%d\n", rpl->rplRedis->type); + if(rpl->rplRedis->type == REDIS_REPLY_ERROR) { + LM_ERR("Redis error:%.*s\n", + (int)rpl->rplRedis->len, rpl->rplRedis->str); + goto error_exec; + } } STR_ZTOV(cmd->s[cmd->len], c); rsrv->disable.consecutive_errors = 0;

1 0

[kamailio/kamailio] keepalive: custom pinging interval per destination (#2313)
by Nacho G. 07 May '20

07 May '20

- This functionality it's just available when using api.h bindings. For exported functions current value ka_ping_interval is used. - Modified add_destination function to provide this new parameter. - Now we have one timer per destination, instead of multiple, so we don't need to iterate over all destinations. Timers are cleaned when destinations are removed.   #### Pre-Submission Checklist    - [x] Commit message has the format required by CONTRIBUTING guide - [x] Commits are split per component (core, individual modules, libs, utils, ...) - [x] Each component has a single commit (if not, squash them into one commit) - [x] No commits to README files for modules (changes must be done to docbook files in `doc/` subfolder, the README file is autogenerated) #### Type Of Change - [ ] Small bug fix (non-breaking change which fixes an issue) - [ ] New feature (non-breaking change which adds new functionality) - [x] Breaking change (fix or feature that would change existing functionality) #### Checklist:  - [ ] PR should be backported to stable branches - [x] Tested changes locally - [ ] Related to issue #XXXX (replace XXXX with an open issue number) #### Description  With this code, you can have a different pinging timeout for each destination, instead of the fixed (default 30 seconds) one. This change is compatible (not breaking) with .cfg or kemi invocations, but it's breaking developers api. You can view, comment on, or merge this pull request online at: https://github.com/kamailio/kamailio/pull/2313 -- Commit Summary -- * keepalive: custom pinging interval per destination -- File Changes -- M src/modules/keepalive/api.h (2) M src/modules/keepalive/doc/keepalive.xml (3) M src/modules/keepalive/doc/keepalive_devel.xml (9) M src/modules/keepalive/keepalive.h (9) M src/modules/keepalive/keepalive_api.c (23) M src/modules/keepalive/keepalive_core.c (46) M src/modules/keepalive/keepalive_mod.c (12) M src/modules/keepalive/keepalive_rpc.c (2) -- Patch Links -- https://github.com/kamailio/kamailio/pull/2313.patch https://github.com/kamailio/kamailio/pull/2313.diff -- You are receiving this because you are subscribed to this thread. Reply to this email directly or view it on GitHub: https://github.com/kamailio/kamailio/pull/2313

2 4

git:master:10fd9fb2: Merge pull request #2313 from NGSegovia/keepalive/custom_ping_interval
by GitHub 07 May '20

07 May '20

Module: kamailio Branch: master Commit: 10fd9fb2d8785fe9670a96b8e699135cbde3f28e URL: https://github.com/kamailio/kamailio/commit/10fd9fb2d8785fe9670a96b8e699135… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: GitHub <noreply(a)github.com> Date: 2020-05-07T13:08:51+02:00 Merge pull request #2313 from NGSegovia/keepalive/custom_ping_interval keepalive: custom pinging interval per destination --- Modified: src/modules/drouting/drouting.c Modified: src/modules/keepalive/api.h Modified: src/modules/keepalive/doc/keepalive.xml Modified: src/modules/keepalive/doc/keepalive_devel.xml Modified: src/modules/keepalive/keepalive.h Modified: src/modules/keepalive/keepalive_api.c Modified: src/modules/keepalive/keepalive_core.c Modified: src/modules/keepalive/keepalive_mod.c Modified: src/modules/keepalive/keepalive_rpc.c --- Diff: https://github.com/kamailio/kamailio/commit/10fd9fb2d8785fe9670a96b8e699135… Patch: https://github.com/kamailio/kamailio/commit/10fd9fb2d8785fe9670a96b8e699135…

1 0

git:master:616aa146: drouting: update to new keepalive interface, using custom pinging interval per destination
by Nacho Garcia Segovia 07 May '20

07 May '20

Module: kamailio Branch: master Commit: 616aa146f919b8a42101a323c611a6a525b19236 URL: https://github.com/kamailio/kamailio/commit/616aa146f919b8a42101a323c611a6a… Author: Nacho Garcia Segovia <nacho.gs(a)zaleos.net> Committer: Nacho Garcia Segovia <nacho.gs(a)zaleos.net> Date: 2020-05-06T23:13:27+02:00 drouting: update to new keepalive interface, using custom pinging interval per destination - Changes required because of dependencies from module keepalive. --- Modified: src/modules/drouting/drouting.c --- Diff: https://github.com/kamailio/kamailio/commit/616aa146f919b8a42101a323c611a6a… Patch: https://github.com/kamailio/kamailio/commit/616aa146f919b8a42101a323c611a6a… --- diff --git a/src/modules/drouting/drouting.c b/src/modules/drouting/drouting.c index e16f5ae804..4fd0786ffe 100644 --- a/src/modules/drouting/drouting.c +++ b/src/modules/drouting/drouting.c @@ -223,7 +223,7 @@ static int dr_update_keepalive(pgw_t *addrs) for(cur = addrs; cur != NULL; cur = cur->next) { LM_DBG("uri: %.*s\n", cur->ip.len, cur->ip.s); keepalive_api.add_destination( - &cur->ip, &owner, 0, dr_keepalive_statechanged, cur); + &cur->ip, &owner, 0, 0, dr_keepalive_statechanged, cur); } return 0;

1 0

git:master:4cebb16b: keepalive: custom pinging interval per destination
by Nacho Garcia Segovia 07 May '20

07 May '20

Module: kamailio Branch: master Commit: 4cebb16b536c35ec74ecbdf595c5c6dbafe5afa1 URL: https://github.com/kamailio/kamailio/commit/4cebb16b536c35ec74ecbdf595c5c6d… Author: Nacho Garcia Segovia <nacho.gs(a)zaleos.net> Committer: Nacho Garcia Segovia <nacho.gs(a)zaleos.net> Date: 2020-05-06T23:10:40+02:00 keepalive: custom pinging interval per destination - This functionality it's just available when using api.h bindings. For exported functions current value ka_ping_interval is used. - Modified add_destination function to provide this new parameter. - Now we have one timer per destination, instead of multiple, so we don't need to iterate over all destinations. Timers are cleaned when destinations are removed. --- Modified: src/modules/keepalive/api.h Modified: src/modules/keepalive/doc/keepalive.xml Modified: src/modules/keepalive/doc/keepalive_devel.xml Modified: src/modules/keepalive/keepalive.h Modified: src/modules/keepalive/keepalive_api.c Modified: src/modules/keepalive/keepalive_core.c Modified: src/modules/keepalive/keepalive_mod.c Modified: src/modules/keepalive/keepalive_rpc.c --- Diff: https://github.com/kamailio/kamailio/commit/4cebb16b536c35ec74ecbdf595c5c6d… Patch: https://github.com/kamailio/kamailio/commit/4cebb16b536c35ec74ecbdf595c5c6d…

1 0

git:5.3:f977da4c: kamctl: regenerated db schema for secfilter
by Daniel-Constantin Mierla 07 May '20

07 May '20

Module: kamailio Branch: 5.3 Commit: f977da4c7058a62919557eba3f6edcd5faa61cda URL: https://github.com/kamailio/kamailio/commit/f977da4c7058a62919557eba3f6edcd… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: 2020-05-07T08:21:12+02:00 kamctl: regenerated db schema for secfilter (cherry picked from commit 59c49af039f468466b0d853a4ceab8fe7f566215) --- Modified: utils/kamctl/db_berkeley/kamailio/secfilter Modified: utils/kamctl/db_sqlite/secfilter-create.sql Modified: utils/kamctl/mongodb/kamailio/secfilter.json Modified: utils/kamctl/mysql/secfilter-create.sql Modified: utils/kamctl/oracle/secfilter-create.sql Modified: utils/kamctl/postgres/secfilter-create.sql --- Diff: https://github.com/kamailio/kamailio/commit/f977da4c7058a62919557eba3f6edcd… Patch: https://github.com/kamailio/kamailio/commit/f977da4c7058a62919557eba3f6edcd… --- diff --git a/utils/kamctl/db_berkeley/kamailio/secfilter b/utils/kamctl/db_berkeley/kamailio/secfilter index 38fbb9a05e..b264e5b0a3 100644 --- a/utils/kamctl/db_berkeley/kamailio/secfilter +++ b/utils/kamctl/db_berkeley/kamailio/secfilter @@ -7,4 +7,4 @@ METADATA_READONLY METADATA_LOGFLAGS 0 METADATA_DEFAULTS -NIL|''|''|'' +NIL|0|0|'' diff --git a/utils/kamctl/db_sqlite/secfilter-create.sql b/utils/kamctl/db_sqlite/secfilter-create.sql index 476ea46de4..44e1f4e4c2 100644 --- a/utils/kamctl/db_sqlite/secfilter-create.sql +++ b/utils/kamctl/db_sqlite/secfilter-create.sql @@ -1,7 +1,7 @@ CREATE TABLE secfilter ( id INTEGER PRIMARY KEY NOT NULL, - action SMALLINT DEFAULT '' NOT NULL, - type SMALLINT DEFAULT '' NOT NULL, + action SMALLINT DEFAULT 0 NOT NULL, + type SMALLINT DEFAULT 0 NOT NULL, data VARCHAR(64) DEFAULT '' NOT NULL ); diff --git a/utils/kamctl/mongodb/kamailio/secfilter.json b/utils/kamctl/mongodb/kamailio/secfilter.json index 1f7baf47fc..7c433e929d 100644 --- a/utils/kamctl/mongodb/kamailio/secfilter.json +++ b/utils/kamctl/mongodb/kamailio/secfilter.json @@ -9,12 +9,12 @@ }, "action": { "type": "int", - "default": "", + "default": 0, "null": false }, "type": { "type": "int", - "default": "", + "default": 0, "null": false }, "data": { diff --git a/utils/kamctl/mysql/secfilter-create.sql b/utils/kamctl/mysql/secfilter-create.sql index 18a67c79b6..9b35b8d570 100644 --- a/utils/kamctl/mysql/secfilter-create.sql +++ b/utils/kamctl/mysql/secfilter-create.sql @@ -1,7 +1,7 @@ CREATE TABLE `secfilter` ( `id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, - `action` SMALLINT DEFAULT '' NOT NULL, - `type` SMALLINT DEFAULT '' NOT NULL, + `action` SMALLINT DEFAULT 0 NOT NULL, + `type` SMALLINT DEFAULT 0 NOT NULL, `data` VARCHAR(64) DEFAULT '' NOT NULL ); diff --git a/utils/kamctl/oracle/secfilter-create.sql b/utils/kamctl/oracle/secfilter-create.sql index 684d1c44cf..d980915525 100644 --- a/utils/kamctl/oracle/secfilter-create.sql +++ b/utils/kamctl/oracle/secfilter-create.sql @@ -1,7 +1,7 @@ CREATE TABLE secfilter ( id NUMBER(10) PRIMARY KEY, - action NUMBER(5) DEFAULT '', - type NUMBER(5) DEFAULT '', + action NUMBER(5) DEFAULT 0 NOT NULL, + type NUMBER(5) DEFAULT 0 NOT NULL, data VARCHAR2(64) DEFAULT '' ); diff --git a/utils/kamctl/postgres/secfilter-create.sql b/utils/kamctl/postgres/secfilter-create.sql index 71badd4ece..ce048396fa 100644 --- a/utils/kamctl/postgres/secfilter-create.sql +++ b/utils/kamctl/postgres/secfilter-create.sql @@ -1,7 +1,7 @@ CREATE TABLE secfilter ( id SERIAL PRIMARY KEY NOT NULL, - action SMALLINT DEFAULT '' NOT NULL, - type SMALLINT DEFAULT '' NOT NULL, + action SMALLINT DEFAULT 0 NOT NULL, + type SMALLINT DEFAULT 0 NOT NULL, data VARCHAR(64) DEFAULT '' NOT NULL );

1 0

git:5.3:221175ff: srdb1: default value set to 0 for number types
by Daniel-Constantin Mierla 07 May '20

07 May '20

Module: kamailio Branch: 5.3 Commit: 221175ff31bfead160ef9f3bc8ac613a107f98cf URL: https://github.com/kamailio/kamailio/commit/221175ff31bfead160ef9f3bc8ac613… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: 2020-05-07T08:21:02+02:00 srdb1: default value set to 0 for number types (cherry picked from commit b0f1486f8a656922aac02020c9e3141639f2ecb9) --- Modified: src/lib/srdb1/schema/secfilter.xml --- Diff: https://github.com/kamailio/kamailio/commit/221175ff31bfead160ef9f3bc8ac613… Patch: https://github.com/kamailio/kamailio/commit/221175ff31bfead160ef9f3bc8ac613… --- diff --git a/src/lib/srdb1/schema/secfilter.xml b/src/lib/srdb1/schema/secfilter.xml index 4edab34e6c..0b3cbc8878 100644 --- a/src/lib/srdb1/schema/secfilter.xml +++ b/src/lib/srdb1/schema/secfilter.xml @@ -37,14 +37,14 @@ <column id="action"> <name>action</name> <type>short</type> - <default/> + <default>0</default> <description>Action to do (0=blacklisted data, 1=whitelisted data, 2=blacklisted destination).</description> </column> <column id="type"> <name>type</name> <type>short</type> - <default/> + <default>0</default> <description>Type of data (0=user-agent, 1=country, 2=domain, 3=IP address, 4=user).</description> </column>

1 0

git:5.3:ac1b7f30: pua: use file name specific include guard
by Daniel-Constantin Mierla 07 May '20

07 May '20

Module: kamailio Branch: 5.3 Commit: ac1b7f30b4cdc6d48d77f19421822300bcaa34be URL: https://github.com/kamailio/kamailio/commit/ac1b7f30b4cdc6d48d77f1942182230… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: 2020-05-07T08:20:53+02:00 pua: use file name specific include guard (cherry picked from commit 076649793bfdbdc4f03f96961f23997c87ce4268) --- Modified: src/modules/pua/hash.h Modified: src/modules/pua/pua.h --- Diff: https://github.com/kamailio/kamailio/commit/ac1b7f30b4cdc6d48d77f1942182230… Patch: https://github.com/kamailio/kamailio/commit/ac1b7f30b4cdc6d48d77f1942182230… --- diff --git a/src/modules/pua/hash.h b/src/modules/pua/hash.h index cc73d3e761..454e4bb853 100644 --- a/src/modules/pua/hash.h +++ b/src/modules/pua/hash.h @@ -15,8 +15,8 @@ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * - * You should have received a copy of the GNU General Public License - * along with this program; if not, write to the Free Software + * You should have received a copy of the GNU General Public License + * along with this program; if not, write to the Free Software * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA */ diff --git a/src/modules/pua/pua.h b/src/modules/pua/pua.h index 57cc379ebe..908f5b0cb3 100644 --- a/src/modules/pua/pua.h +++ b/src/modules/pua/pua.h @@ -15,13 +15,13 @@ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * - * You should have received a copy of the GNU General Public License - * along with this program; if not, write to the Free Software + * You should have received a copy of the GNU General Public License + * along with this program; if not, write to the Free Software * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA */ -#ifndef PUBLISH_H -#define PUBLISH_H +#ifndef _PUA_H_ +#define _PUA_H_ #include "../../core/str.h" #include "../../lib/srdb1/db.h"

1 0

git:master:59c49af0: kamctl: regenerated db schema for secfilter
by Daniel-Constantin Mierla 07 May '20

07 May '20

Module: kamailio Branch: master Commit: 59c49af039f468466b0d853a4ceab8fe7f566215 URL: https://github.com/kamailio/kamailio/commit/59c49af039f468466b0d853a4ceab8f… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: 2020-05-07T08:19:36+02:00 kamctl: regenerated db schema for secfilter --- Modified: utils/kamctl/db_berkeley/kamailio/secfilter Modified: utils/kamctl/db_sqlite/secfilter-create.sql Modified: utils/kamctl/mongodb/kamailio/secfilter.json Modified: utils/kamctl/mysql/secfilter-create.sql Modified: utils/kamctl/oracle/secfilter-create.sql Modified: utils/kamctl/postgres/secfilter-create.sql --- Diff: https://github.com/kamailio/kamailio/commit/59c49af039f468466b0d853a4ceab8f… Patch: https://github.com/kamailio/kamailio/commit/59c49af039f468466b0d853a4ceab8f… --- diff --git a/utils/kamctl/db_berkeley/kamailio/secfilter b/utils/kamctl/db_berkeley/kamailio/secfilter index 38fbb9a05e..b264e5b0a3 100644 --- a/utils/kamctl/db_berkeley/kamailio/secfilter +++ b/utils/kamctl/db_berkeley/kamailio/secfilter @@ -7,4 +7,4 @@ METADATA_READONLY METADATA_LOGFLAGS 0 METADATA_DEFAULTS -NIL|''|''|'' +NIL|0|0|'' diff --git a/utils/kamctl/db_sqlite/secfilter-create.sql b/utils/kamctl/db_sqlite/secfilter-create.sql index 476ea46de4..44e1f4e4c2 100644 --- a/utils/kamctl/db_sqlite/secfilter-create.sql +++ b/utils/kamctl/db_sqlite/secfilter-create.sql @@ -1,7 +1,7 @@ CREATE TABLE secfilter ( id INTEGER PRIMARY KEY NOT NULL, - action SMALLINT DEFAULT '' NOT NULL, - type SMALLINT DEFAULT '' NOT NULL, + action SMALLINT DEFAULT 0 NOT NULL, + type SMALLINT DEFAULT 0 NOT NULL, data VARCHAR(64) DEFAULT '' NOT NULL ); diff --git a/utils/kamctl/mongodb/kamailio/secfilter.json b/utils/kamctl/mongodb/kamailio/secfilter.json index 1f7baf47fc..7c433e929d 100644 --- a/utils/kamctl/mongodb/kamailio/secfilter.json +++ b/utils/kamctl/mongodb/kamailio/secfilter.json @@ -9,12 +9,12 @@ }, "action": { "type": "int", - "default": "", + "default": 0, "null": false }, "type": { "type": "int", - "default": "", + "default": 0, "null": false }, "data": { diff --git a/utils/kamctl/mysql/secfilter-create.sql b/utils/kamctl/mysql/secfilter-create.sql index 18a67c79b6..9b35b8d570 100644 --- a/utils/kamctl/mysql/secfilter-create.sql +++ b/utils/kamctl/mysql/secfilter-create.sql @@ -1,7 +1,7 @@ CREATE TABLE `secfilter` ( `id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, - `action` SMALLINT DEFAULT '' NOT NULL, - `type` SMALLINT DEFAULT '' NOT NULL, + `action` SMALLINT DEFAULT 0 NOT NULL, + `type` SMALLINT DEFAULT 0 NOT NULL, `data` VARCHAR(64) DEFAULT '' NOT NULL ); diff --git a/utils/kamctl/oracle/secfilter-create.sql b/utils/kamctl/oracle/secfilter-create.sql index 684d1c44cf..d980915525 100644 --- a/utils/kamctl/oracle/secfilter-create.sql +++ b/utils/kamctl/oracle/secfilter-create.sql @@ -1,7 +1,7 @@ CREATE TABLE secfilter ( id NUMBER(10) PRIMARY KEY, - action NUMBER(5) DEFAULT '', - type NUMBER(5) DEFAULT '', + action NUMBER(5) DEFAULT 0 NOT NULL, + type NUMBER(5) DEFAULT 0 NOT NULL, data VARCHAR2(64) DEFAULT '' ); diff --git a/utils/kamctl/postgres/secfilter-create.sql b/utils/kamctl/postgres/secfilter-create.sql index 71badd4ece..ce048396fa 100644 --- a/utils/kamctl/postgres/secfilter-create.sql +++ b/utils/kamctl/postgres/secfilter-create.sql @@ -1,7 +1,7 @@ CREATE TABLE secfilter ( id SERIAL PRIMARY KEY NOT NULL, - action SMALLINT DEFAULT '' NOT NULL, - type SMALLINT DEFAULT '' NOT NULL, + action SMALLINT DEFAULT 0 NOT NULL, + type SMALLINT DEFAULT 0 NOT NULL, data VARCHAR(64) DEFAULT '' NOT NULL );

1 0

← Newer
1
...
27
28
29
30
31
32
33
...
40
Older →

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

sr-dev May 2020