Module: kamailio Branch: master Commit: e30cbd0010149a595ef7c11963a785ad784ea5c2 URL: https://github.com/kamailio/kamailio/commit/e30cbd0010149a595ef7c11963a785ad...
Author: Daniel-Constantin Mierla miconda@gmail.com Committer: Daniel-Constantin Mierla miconda@gmail.com Date: 2017-12-08T08:42:00+01:00
kamctl: regenerate db creation scripts
---
Modified: utils/kamctl/db_sqlite/topos-create.sql Modified: utils/kamctl/mysql/topos-create.sql Modified: utils/kamctl/oracle/topos-create.sql Modified: utils/kamctl/postgres/topos-create.sql
---
Diff: https://github.com/kamailio/kamailio/commit/e30cbd0010149a595ef7c11963a785ad... Patch: https://github.com/kamailio/kamailio/commit/e30cbd0010149a595ef7c11963a785ad...
---
diff --git a/utils/kamctl/db_sqlite/topos-create.sql b/utils/kamctl/db_sqlite/topos-create.sql index d36c5b62ac..b39af68335 100644 --- a/utils/kamctl/db_sqlite/topos-create.sql +++ b/utils/kamctl/db_sqlite/topos-create.sql @@ -27,6 +27,8 @@ CREATE TABLE topos_d (
CREATE INDEX topos_d_rectime_idx ON topos_d (rectime); CREATE INDEX topos_d_a_callid_idx ON topos_d (a_callid); +CREATE INDEX topos_d_a_uuid_idx ON topos_d (a_uuid); +CREATE INDEX topos_d_b_uuid_idx ON topos_d (b_uuid);
INSERT INTO version (table_name, table_version) values ('topos_d','1');
@@ -60,6 +62,8 @@ CREATE TABLE topos_t (
CREATE INDEX topos_t_rectime_idx ON topos_t (rectime); CREATE INDEX topos_t_a_callid_idx ON topos_t (a_callid); +CREATE INDEX topos_t_x_vbranch_idx ON topos_t (x_vbranch); +CREATE INDEX topos_t_a_uuid_idx ON topos_t (a_uuid);
INSERT INTO version (table_name, table_version) values ('topos_t','1');
diff --git a/utils/kamctl/mysql/topos-create.sql b/utils/kamctl/mysql/topos-create.sql index db305752c6..1d35b2b83d 100644 --- a/utils/kamctl/mysql/topos-create.sql +++ b/utils/kamctl/mysql/topos-create.sql @@ -27,6 +27,8 @@ CREATE TABLE `topos_d` (
CREATE INDEX rectime_idx ON topos_d (`rectime`); CREATE INDEX a_callid_idx ON topos_d (`a_callid`); +CREATE INDEX a_uuid_idx ON topos_d (`a_uuid`); +CREATE INDEX b_uuid_idx ON topos_d (`b_uuid`);
INSERT INTO version (table_name, table_version) values ('topos_d','1');
@@ -60,6 +62,8 @@ CREATE TABLE `topos_t` (
CREATE INDEX rectime_idx ON topos_t (`rectime`); CREATE INDEX a_callid_idx ON topos_t (`a_callid`); +CREATE INDEX x_vbranch_idx ON topos_t (`x_vbranch`); +CREATE INDEX a_uuid_idx ON topos_t (`a_uuid`);
INSERT INTO version (table_name, table_version) values ('topos_t','1');
diff --git a/utils/kamctl/oracle/topos-create.sql b/utils/kamctl/oracle/topos-create.sql index b0f0aa47d5..f7dc8097ce 100644 --- a/utils/kamctl/oracle/topos-create.sql +++ b/utils/kamctl/oracle/topos-create.sql @@ -35,6 +35,8 @@ BEGIN map2users('topos_d'); END; / CREATE INDEX topos_d_rectime_idx ON topos_d (rectime); CREATE INDEX topos_d_a_callid_idx ON topos_d (a_callid); +CREATE INDEX topos_d_a_uuid_idx ON topos_d (a_uuid); +CREATE INDEX topos_d_b_uuid_idx ON topos_d (b_uuid);
INSERT INTO version (table_name, table_version) values ('topos_d','1');
@@ -76,6 +78,8 @@ BEGIN map2users('topos_t'); END; / CREATE INDEX topos_t_rectime_idx ON topos_t (rectime); CREATE INDEX topos_t_a_callid_idx ON topos_t (a_callid); +CREATE INDEX topos_t_x_vbranch_idx ON topos_t (x_vbranch); +CREATE INDEX topos_t_a_uuid_idx ON topos_t (a_uuid);
INSERT INTO version (table_name, table_version) values ('topos_t','1');
diff --git a/utils/kamctl/postgres/topos-create.sql b/utils/kamctl/postgres/topos-create.sql index d98dda3fad..a72be15622 100644 --- a/utils/kamctl/postgres/topos-create.sql +++ b/utils/kamctl/postgres/topos-create.sql @@ -27,6 +27,8 @@ CREATE TABLE topos_d (
CREATE INDEX topos_d_rectime_idx ON topos_d (rectime); CREATE INDEX topos_d_a_callid_idx ON topos_d (a_callid); +CREATE INDEX topos_d_a_uuid_idx ON topos_d (a_uuid); +CREATE INDEX topos_d_b_uuid_idx ON topos_d (b_uuid);
INSERT INTO version (table_name, table_version) values ('topos_d','1');
@@ -60,6 +62,8 @@ CREATE TABLE topos_t (
CREATE INDEX topos_t_rectime_idx ON topos_t (rectime); CREATE INDEX topos_t_a_callid_idx ON topos_t (a_callid); +CREATE INDEX topos_t_x_vbranch_idx ON topos_t (x_vbranch); +CREATE INDEX topos_t_a_uuid_idx ON topos_t (a_uuid);
INSERT INTO version (table_name, table_version) values ('topos_t','1');
-
Daniel-Constantin Mierla