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