rendered paste bodyCREATE TABLE sipfriends ( name text unique not null, username text unique, secret text not null, md5secret text, host text default 'dynamic', defaultip inet, accountcode text, context text, permit text, deny text, auth text, dtmfmode text default 'rfc2833', canreinvite boolean default 'f', nat boolean default 't', callgroup text, pickupgroup text, language text, allow text default 'g729;ulaw', disallow text default 'all', insecure text, trustrpid boolean, progressinband boolean default 'f', promiscredir boolean, callerid text, amaflags text, incominglimit integer, outgoinglimit integer, restrictcid boolean, mailbox text, template text, fromdomain text, fromuser text, mask text, qualify integer default '1000', rtptimeout integer, rtpholdtimeout integer, ipaddr inet, port integer, regseconds integer);CREATE TABLE iaxfriends ( name text not null unique, secret text, dbsecret text, mailbox text, mailboxdetail boolean, trunk boolean default 'f', auth text default 'rsa,md5,plain', notransfer boolean default 't', jitterbuffer boolean default 'f', host text default 'dynamic', defaultip inet, permit text, deny text, mask text, disallow text, allow text default 'g729;ilbc;gsm;ulaw', regexten text, peercontext text, username text, callerid text, sendani boolean default 'f', outkey text default 'ergasio', inkeys text, qualify integer default 1000, timezone text, setvar text, accountcode text, language text, amaflags text default 'billing', regseconds integer, ipaddr inet, port integer);CREATE TABLE voicemail ( uniqueid serial not null unique, mailbox text not null, context text not null, fullname text not null, email text, pager text, attach boolean, serveremail text, language text, tz text, delete boolean, saycid boolean, sendvoicemail boolean, review boolean, operator boolean, envelope boolean, sayduration boolean, saydurationm integer, forcename boolean, forcegreetings boolean, callback text, dialout text, exitcontext text, CONSTRAINT unique_mbox_context UNIQUE (mailbox,context));