[sr-dev] git:master:45c38614: kamctl: regenerated db schema files

[Henning Westerholt]

Module: kamailio
Branch: master
Commit: 45c38614cbdc9bde2fa4b1836ae5aef5793b51d4
URL: https://github.com/kamailio/kamailio/commit/45c38614cbdc9bde2fa4b1836ae5aef5793b51d4

Author: Alessio Garzi <agarzi at sipwise.com>
Committer: Henning Westerholt <hw at gilawa.com>
Date: 2022-07-21T16:07:39+02:00

kamctl: regenerated db schema files

- regenerated db schema files for table watchers
  after addition of index time_status_idx

---

Modified: utils/kamctl/db_sqlite/presence-create.sql
Modified: utils/kamctl/mysql/presence-create.sql
Modified: utils/kamctl/oracle/presence-create.sql
Modified: utils/kamctl/postgres/presence-create.sql

---

Diff:  https://github.com/kamailio/kamailio/commit/45c38614cbdc9bde2fa4b1836ae5aef5793b51d4.diff
Patch: https://github.com/kamailio/kamailio/commit/45c38614cbdc9bde2fa4b1836ae5aef5793b51d4.patch

---

diff --git a/utils/kamctl/db_sqlite/presence-create.sql b/utils/kamctl/db_sqlite/presence-create.sql
index aacc80b5826..ef47c600984 100644
--- a/utils/kamctl/db_sqlite/presence-create.sql
+++ b/utils/kamctl/db_sqlite/presence-create.sql
@@ -69,6 +69,8 @@ CREATE TABLE watchers (
     CONSTRAINT watchers_watcher_idx UNIQUE (presentity_uri, watcher_username, watcher_domain, event)
 );
 
+CREATE INDEX watchers_time_status_idx ON watchers (inserted_time, status);
+
 INSERT INTO version (table_name, table_version) values ('watchers','3');
 
 CREATE TABLE xcap (
diff --git a/utils/kamctl/mysql/presence-create.sql b/utils/kamctl/mysql/presence-create.sql
index a3b3d9befef..71283ad7c88 100644
--- a/utils/kamctl/mysql/presence-create.sql
+++ b/utils/kamctl/mysql/presence-create.sql
@@ -69,6 +69,8 @@ CREATE TABLE `watchers` (
     CONSTRAINT watcher_idx UNIQUE (`presentity_uri`, `watcher_username`, `watcher_domain`, `event`)
 );
 
+CREATE INDEX time_status_idx ON watchers (`inserted_time`, `status`);
+
 INSERT INTO version (table_name, table_version) values ('watchers','3');
 
 CREATE TABLE `xcap` (
diff --git a/utils/kamctl/oracle/presence-create.sql b/utils/kamctl/oracle/presence-create.sql
index e63664f0881..eb65f1e928b 100644
--- a/utils/kamctl/oracle/presence-create.sql
+++ b/utils/kamctl/oracle/presence-create.sql
@@ -93,6 +93,8 @@ END watchers_tr;
 /
 BEGIN map2users('watchers'); END;
 /
+CREATE INDEX watchers_time_status_idx  ON watchers (inserted_time, status);
+
 INSERT INTO version (table_name, table_version) values ('watchers','3');
 
 CREATE TABLE xcap (
diff --git a/utils/kamctl/postgres/presence-create.sql b/utils/kamctl/postgres/presence-create.sql
index b17bd76ef51..d2ca3de67b6 100644
--- a/utils/kamctl/postgres/presence-create.sql
+++ b/utils/kamctl/postgres/presence-create.sql
@@ -69,6 +69,8 @@ CREATE TABLE watchers (
     CONSTRAINT watchers_watcher_idx UNIQUE (presentity_uri, watcher_username, watcher_domain, event)
 );
 
+CREATE INDEX watchers_time_status_idx ON watchers (inserted_time, status);
+
 INSERT INTO version (table_name, table_version) values ('watchers','3');
 
 CREATE TABLE xcap (