Advertisement
Guest User

MySQL queries

a guest
Oct 7th, 2015
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.71 KB | None | 0 0
  1. lcr_gw:
  2. mysql> select * from lcr_gw;
  3. +----+--------+----------------------+---------------+----------+------+--------+------------+-----------+-------+--------+------+-------+---------+
  4. | id | lcr_id | gw_name              | ip_addr       | hostname | port | params | uri_scheme | transport | strip | prefix | tag  | flags | defunct |
  5. +----+--------+----------------------+---------------+----------+------+--------+------------+-----------+-------+--------+------+-------+---------+
  6. |  1 |      1 | voip innovations out | 64.136.174.30 |          | 5060 |        |          1 |         1 |     0 |        |      |     0 |       0 |
  7. +----+--------+----------------------+---------------+----------+------+--------+------------+-----------+-------+--------+------+-------+---------+
  8. 1 row in set (0.00 sec)
  9.  
  10. lcr_rule (I am in the area code 419 so I thought using the prefix would be appropriate here)
  11. mysql> select * from lcr_rule;
  12. +----+--------+--------+----------+-------------+---------+---------+
  13. | id | lcr_id | prefix | from_uri | request_uri | stopper | enabled |
  14. +----+--------+--------+----------+-------------+---------+---------+
  15. |  1 |      1 | 1419   |          |             |       0 |       1 |
  16. |  2 |      1 | 419    |          |             |       0 |       1 |
  17. +----+--------+--------+----------+-------------+---------+---------+
  18. 2 rows in set (0.00 sec)
  19.  
  20. lcr_rule_target:
  21. mysql> select * from lcr_rule_target;
  22. +----+--------+---------+-------+----------+--------+
  23. | id | lcr_id | rule_id | gw_id | priority | weight |
  24. +----+--------+---------+-------+----------+--------+
  25. |  1 |      1 |       1 |     1 |        0 |      1 |
  26. +----+--------+---------+-------+----------+--------+
  27. 1 row in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement