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

Daniel-Constantin Mierla miconda at gmail.com
Tue Sep 14 09:14:50 CEST 2021


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

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: 2021-09-14T09:14:40+02:00

kamctl: regenerated db schema files

---

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

---

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

---

diff --git a/utils/kamctl/db_sqlite/usrloc-create.sql b/utils/kamctl/db_sqlite/usrloc-create.sql
index 676574f037..e23cc5d8d0 100644
--- a/utils/kamctl/db_sqlite/usrloc-create.sql
+++ b/utils/kamctl/db_sqlite/usrloc-create.sql
@@ -27,6 +27,7 @@ CREATE TABLE location (
 
 CREATE INDEX location_account_contact_idx ON location (username, domain, contact);
 CREATE INDEX location_expires_idx ON location (expires);
+CREATE INDEX location_tcpcon_idx ON location (connection_id);
 CREATE INDEX location_connection_idx ON location (server_id, connection_id);
 
 INSERT INTO version (table_name, table_version) values ('location','9');
diff --git a/utils/kamctl/mysql/usrloc-create.sql b/utils/kamctl/mysql/usrloc-create.sql
index 024123b949..73f8cf111f 100644
--- a/utils/kamctl/mysql/usrloc-create.sql
+++ b/utils/kamctl/mysql/usrloc-create.sql
@@ -27,6 +27,7 @@ CREATE TABLE `location` (
 
 CREATE INDEX account_contact_idx ON location (`username`, `domain`, `contact`);
 CREATE INDEX expires_idx ON location (`expires`);
+CREATE INDEX tcpcon_idx ON location (`connection_id`);
 CREATE INDEX connection_idx ON location (`server_id`, `connection_id`);
 
 INSERT INTO version (table_name, table_version) values ('location','9');
diff --git a/utils/kamctl/oracle/usrloc-create.sql b/utils/kamctl/oracle/usrloc-create.sql
index 0cf6d822f1..7cd93c1105 100644
--- a/utils/kamctl/oracle/usrloc-create.sql
+++ b/utils/kamctl/oracle/usrloc-create.sql
@@ -35,6 +35,7 @@ BEGIN map2users('location'); END;
 /
 CREATE INDEX location_account_contact_idx  ON location (username, domain, contact);
 CREATE INDEX location_expires_idx  ON location (expires);
+CREATE INDEX location_tcpcon_idx  ON location (connection_id);
 CREATE INDEX location_connection_idx  ON location (server_id, connection_id);
 
 INSERT INTO version (table_name, table_version) values ('location','9');
diff --git a/utils/kamctl/postgres/usrloc-create.sql b/utils/kamctl/postgres/usrloc-create.sql
index b9e9c90583..55d22e8857 100644
--- a/utils/kamctl/postgres/usrloc-create.sql
+++ b/utils/kamctl/postgres/usrloc-create.sql
@@ -27,6 +27,7 @@ CREATE TABLE location (
 
 CREATE INDEX location_account_contact_idx ON location (username, domain, contact);
 CREATE INDEX location_expires_idx ON location (expires);
+CREATE INDEX location_tcpcon_idx ON location (connection_id);
 CREATE INDEX location_connection_idx ON location (server_id, connection_id);
 
 INSERT INTO version (table_name, table_version) values ('location','9');




More information about the sr-dev mailing list