CREATE VIEW sip_peers AS 
SELECT subscriber.username AS name, 
subscriber.username AS defaultuser, 
'friend' AS type, 
NULL AS secret, 
subscriber.domain AS host, 
concat(subscriber.rpid,' ','<',subscriber.username,'>') AS callerid, 
'from-users' AS context, 
subscriber.username AS mailbox, 
'yes' AS nat, 
'no' AS qualify, 
'info' AS dtmfmode, 
subscriber.username AS fromuser, 	
NULL AS authuser, 
subscriber.domain AS fromdomain, 
NULL AS insecure, 
'no' AS canreinvite, 
NULL AS disallow, 
'all' AS allow, 
NULL AS restrictcid, 
subscriber.domain AS defaultip, 
subscriber.domain AS ipaddr, 
subscriber.domain AS outboundproxy, 
'5060' AS port, 
NULL AS regseconds 
FROM kamailio_1.subscriber;