--
-- PostgreSQL database dump
--

SET client_encoding = 'LATIN1';
SET check_function_bodies = false;

SET SESSION AUTHORIZATION 'postgres';

SET search_path = public, pg_catalog;

--
-- TOC entry 3 (OID 62099)
-- Name: tb_voicemail_messages; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE tb_voicemail_messages (
    id serial NOT NULL,
    msgnum integer,
    dir character varying(80),
    context character varying(80),
    macrocontext character varying(80),
    callerid character varying(40),
    origtime character varying(40),
    duration character varying(20),
    mailboxuser character varying(80),
    mailboxcontext character varying(80),
    recording oid,
    label character varying(30),
    "read" boolean DEFAULT false,
    sip_id integer,
    pabx_id integer,
    iax_id integer
);


--
-- TOC entry 6 (OID 62385)
-- Name: ix_fk_tb_voicemail_messages_tb_sip_conf; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ix_fk_tb_voicemail_messages_tb_sip_conf ON tb_voicemail_messages USING btree (sip_id);


--
-- TOC entry 4 (OID 62470)
-- Name: ix_fk_tb_voicemail_messages_tb_iax_conf; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ix_fk_tb_voicemail_messages_tb_iax_conf ON tb_voicemail_messages USING btree (iax_id);


--
-- TOC entry 5 (OID 62845)
-- Name: ix_fk_tb_voicemail_messages_tb_pabx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX ix_fk_tb_voicemail_messages_tb_pabx ON tb_voicemail_messages USING btree (pabx_id);


--
-- TOC entry 7 (OID 62103)
-- Name: tb_voicemail_messages_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY tb_voicemail_messages
    ADD CONSTRAINT tb_voicemail_messages_pkey PRIMARY KEY (id);


--
-- TOC entry 8 (OID 62386)
-- Name: $1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY tb_voicemail_messages
    ADD CONSTRAINT "$1" FOREIGN KEY (sip_id) REFERENCES tb_sip_conf(sip_id) ON UPDATE RESTRICT ON DELETE CASCADE;


--
-- TOC entry 9 (OID 62471)
-- Name: $2; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY tb_voicemail_messages
    ADD CONSTRAINT "$2" FOREIGN KEY (iax_id) REFERENCES tb_iax_conf(iax_id) ON UPDATE RESTRICT ON DELETE CASCADE;


--
-- TOC entry 10 (OID 62846)
-- Name: $3; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY tb_voicemail_messages
    ADD CONSTRAINT "$3" FOREIGN KEY (pabx_id) REFERENCES tb_pabx(pabx_id) ON UPDATE RESTRICT ON DELETE CASCADE;