-- -- PostgreSQL database dump -- SET SESSION AUTHORIZATION 'postgres'; -- -- TOC entry 3 (OID 2200) -- Name: public; Type: ACL; Schema: -; Owner: postgres -- REVOKE ALL ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; SET search_path = public, pg_catalog; -- -- TOC entry 4 (OID 64370) -- Name: asterisksettings; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE asterisksettings ( asteriskname character varying(32) DEFAULT ''::character varying NOT NULL, address character varying(32) DEFAULT '127.0.0.1'::character varying NOT NULL, port integer DEFAULT 5038 NOT NULL, clientport integer DEFAULT 58867 NOT NULL, clientname character varying(32) DEFAULT ''::character varying NOT NULL, timer integer DEFAULT 3 NOT NULL, connected boolean DEFAULT false NOT NULL, calleridprefix character varying(32) DEFAULT ''::character varying NOT NULL, login character varying(8) DEFAULT ''::character varying NOT NULL, passwd character varying(8) DEFAULT ''::character varying NOT NULL ); -- -- TOC entry 5 (OID 64382) -- Name: infomessages; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE infomessages ( number character varying(32) DEFAULT ''::character varying NOT NULL, message character varying(64) DEFAULT ''::character varying NOT NULL ); -- -- TOC entry 6 (OID 64382) -- Name: infomessages; Type: ACL; Schema: public; Owner: postgres -- REVOKE ALL ON TABLE infomessages FROM PUBLIC; GRANT ALL ON TABLE infomessages TO PUBLIC; -- -- TOC entry 7 (OID 64386) -- Name: userdata; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE userdata ( name character varying(32) DEFAULT ''::character varying NOT NULL, username character varying(16) DEFAULT ''::character varying NOT NULL, passwd character varying(16) DEFAULT ''::character varying NOT NULL, number character varying(32) DEFAULT ''::character varying NOT NULL, sip_addr character varying(32) DEFAULT ''::character varying NOT NULL, userid integer NOT NULL, acs_level integer DEFAULT 2 NOT NULL, asteriskname character varying(32) DEFAULT ''::character varying NOT NULL, mailbox character varying(16) DEFAULT ''::character varying NOT NULL, context character varying(32) DEFAULT 'default'::character varying NOT NULL, status character varying(16) DEFAULT ''::character varying NOT NULL, info character varying(100) DEFAULT ''::character varying NOT NULL ); -- -- TOC entry 8 (OID 64386) -- Name: userdata; Type: ACL; Schema: public; Owner: postgres -- REVOKE ALL ON TABLE userdata FROM PUBLIC; GRANT ALL ON TABLE userdata TO PUBLIC; -- -- TOC entry 9 (OID 64400) -- Name: userentries; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE userentries ( name character varying(32) DEFAULT ''::character varying NOT NULL, number character varying(32) DEFAULT ''::character varying NOT NULL, phonetype character varying(16) DEFAULT ''::character varying NOT NULL, status character varying(16) DEFAULT 'available'::character varying NOT NULL, userid integer NOT NULL, info character varying(100) DEFAULT ''::character varying NOT NULL ); -- -- TOC entry 10 (OID 64400) -- Name: userentries; Type: ACL; Schema: public; Owner: postgres -- REVOKE ALL ON TABLE userentries FROM PUBLIC; GRANT ALL ON TABLE userentries TO PUBLIC; -- -- TOC entry 11 (OID 64407) -- Name: numbergroups; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE numbergroups ( number character varying(32) DEFAULT ''::character varying NOT NULL, userid integer NOT NULL ); -- -- TOC entry 12 (OID 64407) -- Name: numbergroups; Type: ACL; Schema: public; Owner: postgres -- REVOKE ALL ON TABLE numbergroups FROM PUBLIC; GRANT ALL ON TABLE numbergroups TO PUBLIC; -- -- TOC entry 13 (OID 64410) -- Name: meetme; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE meetme ( meetmenumber character varying(4) DEFAULT ''::character varying NOT NULL, busy boolean DEFAULT false NOT NULL, callerchannel character varying(32) DEFAULT ''::character varying NOT NULL, priority integer ); -- -- TOC entry 14 (OID 64410) -- Name: meetme; Type: ACL; Schema: public; Owner: postgres -- REVOKE ALL ON TABLE meetme FROM PUBLIC; GRANT ALL ON TABLE meetme TO PUBLIC; -- -- TOC entry 15 (OID 64415) -- Name: callcenter; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE callcenter ( userid integer NOT NULL, status character varying(32) DEFAULT ''::character varying NOT NULL, hangup timestamp without time zone ); -- -- TOC entry 16 (OID 64415) -- Name: callcenter; Type: ACL; Schema: public; Owner: postgres -- REVOKE ALL ON TABLE callcenter FROM PUBLIC; GRANT ALL ON TABLE callcenter TO PUBLIC; -- -- TOC entry 19 (OID 64432) -- Name: cdr; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE cdr ( acctid bigserial NOT NULL, calldate timestamp with time zone DEFAULT now() NOT NULL, clid character varying(80) DEFAULT ''::character varying NOT NULL, src character varying(80) DEFAULT ''::character varying NOT NULL, dst character varying(80) DEFAULT ''::character varying NOT NULL, dcontext character varying(80) DEFAULT ''::character varying NOT NULL, channel character varying(80) DEFAULT ''::character varying NOT NULL, dstchannel character varying(80) DEFAULT ''::character varying NOT NULL, lastapp character varying(80) DEFAULT ''::character varying NOT NULL, lastdata character varying(80) DEFAULT ''::character varying NOT NULL, duration integer DEFAULT 0 NOT NULL, billsec integer DEFAULT 0 NOT NULL, disposition character varying(45) DEFAULT ''::character varying NOT NULL, amaflags integer DEFAULT 0 NOT NULL, accountcode character varying(20) DEFAULT ''::character varying NOT NULL, uniqueid character varying(32) DEFAULT ''::character varying NOT NULL, userfield character varying(255) DEFAULT ''::character varying NOT NULL ); -- -- TOC entry 20 (OID 64432) -- Name: cdr; Type: ACL; Schema: public; Owner: postgres -- REVOKE ALL ON TABLE cdr FROM PUBLIC; GRANT ALL ON TABLE cdr TO PUBLIC; -- -- TOC entry 21 (OID 64451) -- Name: settings; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE settings ( value character varying(16) DEFAULT ''::character varying NOT NULL, "key" character varying(32) DEFAULT ''::character varying NOT NULL ); -- -- TOC entry 23 (OID 64461) -- Name: spreadsheets; Type: TABLE; Schema: public; Owner: postgres -- CREATE TABLE spreadsheets ( name character varying(32) DEFAULT ''::character varying NOT NULL, userid integer NOT NULL ); -- -- Data for TOC entry 26 (OID 64370) -- Name: asterisksettings; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY asterisksettings (asteriskname, address, port, clientport, clientname, timer, connected, calleridprefix, login, passwd) FROM stdin; Asterisk 127.0.0.1 5038 58867 asteriskCaller 2 t 020 login passwd \. -- -- Data for TOC entry 28 (OID 64386) -- Name: userdata; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY userdata (name, username, passwd, number, sip_addr, userid, acs_level, asteriskname, mailbox, context, status, info) FROM stdin; Administrator admin ice 0 0 0 0 Asterisk 0 default away \. -- -- Data for TOC entry 31 (OID 64410) -- Name: meetme; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY meetme (meetmenumber, busy, callerchannel, priority) FROM stdin; 222 f 501 111 f 401 \. -- -- Data for TOC entry 36 (OID 64451) -- Name: settings; Type: TABLE DATA; Schema: public; Owner: postgres -- COPY settings (value, "key") FROM stdin; 9000 applet_port 30 applet_check_time 4 size_attendants 10 timer_delay_bypass 8060 nightswitchnumber 3 timer_delay_queue \. -- -- TOC entry 25 (OID 64487) -- Name: cdr_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres -- ALTER TABLE ONLY cdr ADD CONSTRAINT cdr_pkey PRIMARY KEY (acctid); -- -- TOC entry 24 (OID 64430) -- Name: cdr_acctid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('cdr_acctid_seq', 7770, true); -- -- TOC entry 2 (OID 2200) -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres -- COMMENT ON SCHEMA public IS 'Standard public schema';