mysql> select name, username, host,sippasswd,fromuser,fromdomain,mailbox,context from video1_sipusers;
+------+----------+---------+-----------+----------+------------+---------+----------+
| name | username | host    | sippasswd | fromuser | fromdomain | mailbox | context  |
+------+----------+---------+-----------+----------+------------+---------+----------+
| 106  | 106      | dynamic | 106       | 106      | 10.11.2.47 | 106     | from-sip |
| 107  | 107      | dynamic | 107       | 107      | 10.11.2.47 | 107     | from-sip |
| 108  | 108      | dynamic | 108       | 108      | 10.11.2.47 | 108     | from-sip |
+------+----------+---------+-----------+----------+------------+---------+----------+
3 rows in set (0.01 sec)

mysql> select * from video1_sipregs;
+----+------+-------------------------+--------+------+----------+-----------+------------+
| id | name | fullcontact             | ipaddr | port | username | regserver | regseconds |
+----+------+-------------------------+--------+------+----------+-----------+------------+
|  4 | 106  | sip:106@10.11.2.47:5060 |        |    0 | 106      |           | 1368169282 |
|  5 | 107  | sip:107@10.11.2.47:5060 |        |    0 | 107      |           | 1368176017 |
|  6 | 108  |                         |        |    0 |          | NULL      |          0 |
+----+------+-------------------------+--------+------+----------+-----------+------------+
3 rows in set (0.00 sec)

mysql> select * from video1_voiceboxes;
+----------+-------------+---------+---------+----------+----------+-------+-------+---------+--------+--------+---------+----------+--------+----------+----------+-------------+--------------+---------------+--------+--------------+-----------+----------------+-------------+---------------------+
| uniqueid | customer_id | context | mailbox | password | fullname | email | pager | tz      | attach | saycid | dialout | callback | review | operator | envelope | sayduration | saydurationm | sendvoicemail | delete | nextaftercmd | forcename | forcegreetings | hidefromdir | stamp               |
+----------+-------------+---------+---------+----------+----------+-------+-------+---------+--------+--------+---------+----------+--------+----------+----------+-------------+--------------+---------------+--------+--------------+-----------+----------------+-------------+---------------------+
|        1 | 106         | default | 106     | 1234     | NULL     | NULL  | NULL  | central | yes    | yes    | NULL    | NULL     | no     | no       | no       | no          |            1 | no            | no     | yes          | no        | no             | yes         | 2013-04-28 14:13:57 |
|        2 | 106         | default | 107     | 1234     | NULL     | NULL  | NULL  | central | yes    | yes    | NULL    | NULL     | no     | no       | no       | no          |            1 | no            | no     | yes          | no        | no             | yes         | 2013-04-28 14:14:16 |
|        3 | 106         | default | 108     | 1234     | NULL     | NULL  | NULL  | central | yes    | yes    | NULL    | NULL     | no     | no       | no       | no          |            1 | no            | no     | yes          | no        | no             | yes         | 2013-04-28 14:14:22 |
+----------+-------------+---------+---------+----------+----------+-------+-------+---------+--------+--------+---------+----------+--------+----------+----------+-------------+--------------+---------------+--------+--------------+-----------+----------------+-------------+---------------------+
3 rows in set (0.00 sec)

mysql>