mysql> select * from subscriber; +----+----------+------------+----------+---------------+----------------------------------+----------------------------------+------+ | id | username | domain | password | email_address | ha1 | ha1b | rpid | +----+----------+------------+----------+---------------+----------------------------------+----------------------------------+------+ | 6 | saghul | sipdoc.net | | | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | NULL | | 7 | ibc | sipdoc.net | | | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | NULL | | 8 | manwe | sipdoc.net | | | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | NULL | | 9 | wapi | sipdoc.net | | | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | NULL | +----+----------+------------+----------+---------------+----------------------------------+----------------------------------+------+ 4 rows in set (0.00 sec) mysql> select * from dbaliases; +----+----------------+--------------+----------+------------+ | id | alias_username | alias_domain | username | domain | +----+----------------+--------------+----------+------------+ | 1 | 2001 | sipdoc.net | saghul | sipdoc.net | | 2 | 2002 | sipdoc.net | manwe | sipdoc.net | | 3 | 2003 | sipdoc.net | ibc | sipdoc.net | | 4 | 2004 | sipdoc.net | wapi | sipdoc.net | +----+----------------+--------------+----------+------------+ 4 rows in set (0.00 sec) mysql>