mysql root@ser> select * from gw_cap;
+--------+-----------+------------+----------------------+
| cap_id | cap_value | cap_prefix | cap_description      |
+--------+-----------+------------+----------------------+
|      1 |         1 |            | default phone trunk  |
|      2 |         1 | 01         | prefixed phone trunk |
|      3 |         2 | 02         | prefixed fax trunk   |
+--------+-----------+------------+----------------------+
3 rows in set (0.00 sec)

mysql root@ser> select * from gw_grp;
+--------+-------------------------+--------+
| grp_id | grp_name                | cap_id |
+--------+-------------------------+--------+
|      1 | priority_1_phone        |      1 |
|      2 | priority_1_phone_prefix |      2 |
|      3 | priority_1_fax_prefix   |      3 |
|      4 | priority_2_phone        |      1 |
|      5 | priority_2_phone_prefix |      2 |
|      6 | priority_3_phone_prefix |      2 |
+--------+-------------------------+--------+
6 rows in set (0.00 sec)

mysql root@ser> select * from gw;    
+--------------+-----------+------+--------+
| gw_name      | ip_addr   | port | grp_id |
+--------------+-----------+------+--------+
| sipgw1       | 184592576 | 5060 |      4 |
| sipgw2-fax   | 201369792 | 5060 |      3 |
| sipgw2-phone | 201369792 | 5060 |      6 |
| sipgw3       | 218147008 | 5060 |      4 |
| sipgw4       | 234924224 | 5060 |      4 |
| sipgw5       | 251701440 | 5060 |      4 |
| sipgw6-fax   | 268478656 | 5060 |      3 |
| sipgw6-phone | 268478656 | 5060 |      2 |
+--------------+-----------+------+--------+
8 rows in set (0.00 sec)

mysql root@ser> select * from lcr;
+--------+----------+--------+----------+
| prefix | from_uri | grp_id | priority |
+--------+----------+--------+----------+
|        | %        |      1 |        1 |
|        | %        |      2 |        1 |
|        | %        |      3 |        1 |
|        | %        |      4 |        2 |
|        | %        |      5 |        2 |
|        | %        |      6 |        3 |
+--------+----------+--------+----------+
6 rows in set (0.00 sec)