#!/bin/bash

IFS=$'\t\n'

while read NAME NUMBER
do
	echo "INSERT INTO friends (friend_list_id, sip_uri, subscribe_policy, send_subscribe, ref_key, vCard, vCard_etag, vCard_url, presence_received)
VALUES"
	echo -e "\t(1,\047sip:${NUMBER}@Domain\047,1,0,NULL,replace(replace(\047BEGIN:VCARD\\\r\\\nVERSION:4.0\\\r\\\nFN:${NAME}\\\r\\\nIMPP:sip:${NUMBER}@Domain\\\r\\\nEND:VCARD\\\r\\\n\047,\047\\\r\047,char(13)),\047\\\n\047,char(10)),NULL,NULL,0);"
done < "phonebook.txt"

IFS=$' \t\n'