CREATE TABLE sipfriends (
    name character varying(32),
    host character varying(32) DEFAULT 'dynamic' NOT NULL,
    secret character varying(128),
    ipaddr character varying(32),
    username character varying(32),
    callerid character varying(128),
    context character varying(128),
    canreinvite character varying(3),
    nat character varying(3),
    defaultip character varying(64),
    dtmfmode character varying(64) DEFAULT 'rfc2833' NOT NULL,
    callgroup character varying(16),
    pickupgroup character varying(16),
    port character varying(16),
    permit character varying(64),
    "type" character varying(16),
    "language" character varying(2),
    auth character varying(16),
    regseconds integer,
    mailbox character varying(16),
    externip character varying(64),
    fromuser character varying(64),
    fromdomain character varying(64),
    qualify character varying(8)
);



INSERT INTO sipfriends VALUES ('501', 'dynamic', 'letmein', '192.168.1.104', '501', 'Ousmane Wilane <501>', 'inter', 'no', 'no', '192.168.1.104', 'rfc2833', '1-2', '1-2', '5060', '0.0.0.0/0.0.0.0', 'friend', 'fr', 'plaintext', 1097457768, '100', NULL, NULL, NULL, 'no');