+-------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name      | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| cdr   |          0 | PRIMARY       |            1 | id          | A         |     1611608 |     NULL | NULL   |      | BTREE      |         |               |
| cdr   |          1 | calldate      |            1 | calldate    | A         |     1611608 |     NULL | NULL   |      | BTREE      |         |               |
| cdr   |          1 | dst           |            1 | dst         | A         |       84821 |     NULL | NULL   |      | BTREE      |         |               |
| cdr   |          1 | accountcode   |            1 | accountcode | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |
| cdr   |          1 | uniqueid      |            1 | uniqueid    | A         |     1611608 |     NULL | NULL   |      | BTREE      |         |               |
| cdr   |          1 | linkedid      |            1 | linkedid    | A         |      805804 |     NULL | NULL   |      | BTREE      |         |               |
| cdr   |          1 | did           |            1 | did         | A         |         102 |     NULL | NULL   |      | BTREE      |         |               |
| cdr   |          1 | calldate_2    |            1 | calldate    | A         |     1611608 |     NULL | NULL   |      | BTREE      |         |               |
| cdr   |          1 | clid          |            1 | clid        | A         |      179067 |     NULL | NULL   |      | BTREE      |         |               |
| cdr   |          1 | src           |            1 | src         | A         |      100725 |     NULL | NULL   |      | BTREE      |         |               |
| cdr   |          1 | dst_2         |            1 | dst         | A         |       89533 |     NULL | NULL   |      | BTREE      |         |               |
| cdr   |          1 | dstchannel    |            1 | dstchannel  | A         |     1611608 |     NULL | NULL   |      | BTREE      |         |               |
| cdr   |          1 | uniqueid_2    |            1 | uniqueid    | A         |     1611608 |     NULL | NULL   |      | BTREE      |         |               |
| cdr   |          1 | accountcode_2 |            1 | accountcode | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |
+-------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+



+-------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name  | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| cel   |          0 | PRIMARY   |            1 | id          | A         |    13268121 |     NULL | NULL   |      | BTREE      |         |               |
| cel   |          1 | eventtime |            1 | eventtime   | A         |     2653624 |     NULL | NULL   |      | BTREE      |         |               |
| cel   |          1 | uniqueid  |            1 | uniqueid    | A         |     6634060 |     NULL | NULL   |      | BTREE      |         |               |
| cel   |          1 | linkedid  |            1 | linkedid    | A         |      698322 |     NULL | NULL   |      | BTREE      |         |               |
+-------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+




+-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table     | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| queue_log |          0 | PRIMARY  |            1 | id          | A         |         156 |     NULL | NULL   |      | BTREE      |         |               |
+-----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+



+-------------------------+
| Tables_in_asteriskcdrdb |
+-------------------------+
| a_comments              |
| a_company               |
| a_configs               |
| a_groups                |
| a_numbers               |
| a_numbers_groups        |
| a_numbers_int           |
| a_online                |
| a_supervisors           |
| a_user                  |
| agent_events            |
| agents                  |
| auto_mail               |
| calls                   |
| cdr                     |
| cel                     |
| cel_bridges             |
| cel_calls               |
| cel_chans               |
| cel_events              |
| company_report          |
| last_cel                |
| last_line               |
| queue_log               |
| reports                 |
| settings                |
| users                   |
+-------------------------+