--
-- PostgreSQL database dump
--

SET client_encoding = 'LATIN9';
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: accesscontrolsettings; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE accesscontrolsettings (
    name character varying(32),
    address character varying(32),
    port integer,
    connectatstartup boolean,
    connectiontimeout integer,
    lastmessagedate timestamp without time zone
);


ALTER TABLE public.accesscontrolsettings OWNER TO postgres;

--
-- Name: asterisksettings; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

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,
    busycallcounter integer DEFAULT 3 NOT NULL,
    connectatstartup 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,
    callcenteractivationatconnect boolean DEFAULT false NOT NULL
);


ALTER TABLE public.asterisksettings OWNER TO postgres;

--
-- Name: callcenter; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE callcenter (
    identificationnumber integer NOT NULL,
    status character varying(32) DEFAULT ''::character varying NOT NULL,
    hangup timestamp without time zone
);


ALTER TABLE public.callcenter OWNER TO postgres;

--
-- Name: callmessages; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE callmessages (
    number character varying(32) DEFAULT ''::character varying NOT NULL,
    message character varying(64) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.callmessages OWNER TO postgres;

--
-- Name: cdr; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

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
);


ALTER TABLE public.cdr OWNER TO postgres;

--
-- Name: cdr_acctid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('cdr', 'acctid'), 24025, true);

--
-- Name: ldapsettings; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE ldapsettings (
    host character varying(32),
    "password" character varying(16),
    version integer,
    port integer,
    "login" character varying(16),
    connect boolean
);


ALTER TABLE public.ldapsettings OWNER TO postgres;

--
-- Name: license; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE license (
    licensename character varying(64),
    hash character varying(34)
);


ALTER TABLE public.license OWNER TO postgres;

--
-- Name: meetme; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

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 NOT NULL
);


ALTER TABLE public.meetme OWNER TO postgres;

--
-- Name: numbergroups; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE numbergroups (
    number character varying(32) DEFAULT ''::character varying NOT NULL,
    identificationnumber integer NOT NULL
);


ALTER TABLE public.numbergroups OWNER TO postgres;

--
-- Name: phonebookusers; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE phonebookusers (
    name character varying(32) DEFAULT ''::character varying NOT NULL,
    identificationnumber integer NOT NULL,
    phonebookname character varying(32) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.phonebookusers OWNER TO postgres;

--
-- Name: sbsmm; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE sbsmm (
    passwd character varying(32),
    number character varying(32),
    name character varying(64),
    status character varying(32),
    phonebookname character varying(32),
    enddate timestamp without time zone,
    startdate timestamp without time zone,
    presencenote character varying(64),
    nextstatus character varying(16)
);


ALTER TABLE public.sbsmm OWNER TO postgres;

--
-- Name: sbsmmextensions; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE sbsmmextensions (
    extension character varying(8) DEFAULT ''::character varying NOT NULL,
    status character varying(16) DEFAULT 'available'::character varying NOT NULL,
    messageextension character varying(16) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.sbsmmextensions OWNER TO postgres;

--
-- Name: settings; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE settings (
    value character varying(16) DEFAULT ''::character varying NOT NULL,
    "key" character varying(32) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.settings OWNER TO postgres;

--
-- Name: snomphones; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE snomphones (
    redirect boolean DEFAULT false NOT NULL,
    dnd boolean DEFAULT false NOT NULL,
    number character varying(16) DEFAULT ''::character varying NOT NULL,
    ipaddress character varying(15) DEFAULT ''::character varying NOT NULL,
    redirectnumber character varying(64)
);


ALTER TABLE public.snomphones OWNER TO postgres;

--
-- Name: userdata; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

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,
    identificationnumber integer 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,
    acs_level character varying(16) DEFAULT 'NORMAL'::character varying
);


ALTER TABLE public.userdata OWNER TO postgres;

--
-- Name: userentries; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

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,
    identificationnumber integer NOT NULL,
    info character varying(100) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.userentries OWNER TO postgres;


--
-- Data for Name: asterisksettings; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY asterisksettings (asteriskname, address, port, clientport, clientname, busycallcounter, connectatstartup, calleridprefix, "login", passwd, callcenteractivationatconnect) FROM stdin;
Asterisk	127.0.0.1	5038	58867	AsteriskCaller	3	t		login	passwd	f
\.


--
-- Data for Name: meetme; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY meetme (meetmenumber, busy, callerchannel, priority) FROM stdin;
3	f		601
2	f		501
1	f		401
\.


--
-- Data for Name: sbsmmextensions; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY sbsmmextensions (extension, status, messageextension) FROM stdin;
*01	available	
*03	away	away
*02	busy	occupied
*04	lunch	lunch
*06	brb	brb
*05	dnd	dnd
\.


--
-- Data for Name: settings; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY settings (value, "key") FROM stdin;
3	callQueueDelay
false	maximizeWindow
false	nightswitch
\.


--
-- Data for Name: userdata; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY userdata (name, username, passwd, number, sip_addr, identificationnumber, asteriskname, mailbox, context, status, info, acs_level) FROM stdin;
Administrator	admin	admin	0	0	0	Asterisk	default	away		ADMINISTRATOR
\.


--
-- Name: cdr_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY cdr
    ADD CONSTRAINT cdr_pkey PRIMARY KEY (acctid);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- Name: callcenter; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE callcenter FROM PUBLIC;
REVOKE ALL ON TABLE callcenter FROM postgres;
GRANT ALL ON TABLE callcenter TO postgres;
GRANT ALL ON TABLE callcenter TO PUBLIC;


--
-- Name: callmessages; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE callmessages FROM PUBLIC;
REVOKE ALL ON TABLE callmessages FROM postgres;
GRANT ALL ON TABLE callmessages TO postgres;
GRANT ALL ON TABLE callmessages TO PUBLIC;


--
-- Name: cdr; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE cdr FROM PUBLIC;
REVOKE ALL ON TABLE cdr FROM postgres;
GRANT ALL ON TABLE cdr TO postgres;
GRANT ALL ON TABLE cdr TO PUBLIC;


--
-- Name: meetme; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE meetme FROM PUBLIC;
REVOKE ALL ON TABLE meetme FROM postgres;
GRANT ALL ON TABLE meetme TO postgres;
GRANT ALL ON TABLE meetme TO PUBLIC;


--
-- Name: numbergroups; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE numbergroups FROM PUBLIC;
REVOKE ALL ON TABLE numbergroups FROM postgres;
GRANT ALL ON TABLE numbergroups TO postgres;
GRANT ALL ON TABLE numbergroups TO PUBLIC;


--
-- Name: userdata; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE userdata FROM PUBLIC;
REVOKE ALL ON TABLE userdata FROM postgres;
GRANT ALL ON TABLE userdata TO postgres;
GRANT ALL ON TABLE userdata TO PUBLIC;


--
-- Name: userentries; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE userentries FROM PUBLIC;
REVOKE ALL ON TABLE userentries FROM postgres;
GRANT ALL ON TABLE userentries TO postgres;
GRANT ALL ON TABLE userentries TO PUBLIC;


--
-- PostgreSQL database dump complete
--