Module: kamailio Branch: master Commit: 45c38614cbdc9bde2fa4b1836ae5aef5793b51d4 URL: https://github.com/kamailio/kamailio/commit/45c38614cbdc9bde2fa4b1836ae5aef… Author: Alessio Garzi <agarzi(a)sipwise.com> Committer: Henning Westerholt <hw(a)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/45c38614cbdc9bde2fa4b1836ae5aef… Patch: https://github.com/kamailio/kamailio/commit/45c38614cbdc9bde2fa4b1836ae5aef… --- 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 (