--
-- PostgreSQL database dump
--

--
-- Name: accounts; Type: TABLE; Schema: public; Owner: fsuser
--

CREATE TABLE public.accounts (
    id serial PRIMARY KEY NOT NULL,
    username text NOT NULL,
    password text NOT NULL,
    session text,
    remote_addr character varying(16),
    datetime character varying(32),
    user_agent character varying(256),
    role character varying(16),
    salt integer,
    language character varying(8) DEFAULT 'en-US'::character varying,
    theme character varying(128) DEFAULT 'hero'::character varying
);


ALTER TABLE public.accounts OWNER TO fsuser;


--
-- Name: backups; Type: TABLE; Schema: public; Owner: fsuser
--

CREATE TABLE public.backups (
    id serial PRIMARY KEY NOT NULL,
    name text,
    path text,
    full_name text,
    date timestamp without time zone DEFAULT now(),
    description text,
    session_exe text,
    last_exe timestamp without time zone,
    last_ip character varying(16),
    filesize integer
);


ALTER TABLE public.backups OWNER TO fsuser;

--
-- Name: dialplan_xml; Type: TABLE; Schema: public; Owner: fsuser
--

CREATE TABLE public.dialplan_xml (
    id serial PRIMARY KEY NOT NULL,
    dp_domain text,
    dp_context text,
    dp_name text,
    dp_continue text DEFAULT 'false'::text,
    dp_condtype text DEFAULT 'field'::text,
    dp_condvalue text DEFAULT 'destination_number'::text,
    dp_expr text,
    dp_break text DEFAULT 'on-false'::text,
    dp_xml text,
    enabled boolean DEFAULT false
);


ALTER TABLE public.dialplan_xml OWNER TO fsuser;

--
-- Name: directory_xml; Type: TABLE; Schema: public; Owner: fsuser
--

CREATE TABLE public.directory_xml (
    domain character varying(32) NOT NULL,
    id character varying(32) UNIQUE NOT NULL,
    "number-alias" character varying(32) DEFAULT NULL::character varying,
    mailbox character varying(64) DEFAULT NULL::character varying,
    cidr character varying(64) DEFAULT NULL::character varying,
    password character varying(64) DEFAULT NULL::character varying,
    toll_allow character varying(32) DEFAULT NULL::character varying,
    user_context character varying(32) DEFAULT NULL::character varying,
    default_gateway character varying(32) DEFAULT NULL::character varying,
    effective_caller_id_name character varying(512) DEFAULT NULL::character varying,
    effective_caller_id_number character varying(64) DEFAULT NULL::character varying,
    outbound_caller_id_name character varying(512) DEFAULT NULL::character varying,
    outbound_caller_id_number character varying(64) DEFAULT NULL::character varying,
    callgroup character varying(64) DEFAULT NULL::character varying,
    tls character varying(8) DEFAULT NULL::character varying,
    codec character varying(128) DEFAULT NULL::character varying,
    uservar1 character varying(64) DEFAULT NULL::character varying,
    uservar2 character varying(64) DEFAULT NULL::character varying,
    uservar3 character varying(64) DEFAULT NULL::character varying,
    uservar4 character varying(512) DEFAULT NULL::character varying,
    uservar5 character varying(512) DEFAULT NULL::character varying,
    uservar6 character varying(8) DEFAULT NULL::character varying,
    uservar7 character varying(512) DEFAULT NULL::character varying,
    branch character varying(255) DEFAULT NULL::character varying,
    user_agent character varying(128),
    net_addr character varying(16),
    last_reg character varying(64),
    nibble_account bigserial UNIQUE NOT NULL,
    nibble_rate double precision DEFAULT 1.00
);


ALTER TABLE public.directory_xml OWNER TO fsuser;

--
-- Name: fifo; Type: TABLE; Schema: public; Owner: fsuser
--

CREATE TABLE public.mod_fifo (
    id serial PRIMARY KEY NOT NULL,
    name character varying,
    importance integer DEFAULT 0,
    timeout integer DEFAULT 20,
    simo integer DEFAULT 1,
    lag integer DEFAULT 5,
    member_wait character varying DEFAULT 'nowait'::character varying,
    members character varying
);


ALTER TABLE public.mod_fifo OWNER TO fsuser;

--
-- Name: gateways; Type: TABLE; Schema: public; Owner: fsuser
--

CREATE TABLE public.gateways (
    id serial PRIMARY KEY NOT NULL,
    profile character varying,
    gw_name character varying,
    type character varying,
    name character varying,
    value character varying,
    param_enable boolean DEFAULT false NOT NULL,
    gw_enable boolean DEFAULT false
);


ALTER TABLE public.gateways OWNER TO fsuser;

--
-- Name: incoming_map; Type: TABLE; Schema: public; Owner: fsuser
--

CREATE TABLE public.incoming_map (
    id serial PRIMARY KEY NOT NULL,
    did character varying(32) DEFAULT NULL::character varying,
    did_domain character varying(64) DEFAULT '$${domain}'::character varying,
    did_pre_execute character varying(512) DEFAULT 'ALL_TC'::character varying,
    did_app character varying(32) DEFAULT NULL::character varying,
    did_fail character varying(512) DEFAULT NULL::character varying,
    did_timeout character varying(8) DEFAULT NULL::character varying,
    did_data character varying(512) DEFAULT NULL::character varying,
    did_var character varying(512) DEFAULT NULL::character varying,
    did_post_execute character varying(512) DEFAULT 'ALL_HG'::character varying,
    did_branch character varying(64) DEFAULT NULL::character varying,
    did_codec character varying(128) DEFAULT 'PCMA'::character varying
);


ALTER TABLE public.incoming_map OWNER TO fsuser;

--
-- Name: mod_ivr_entry; Type: TABLE; Schema: public; Owner: fsuser
--

CREATE TABLE public.mod_ivr_entry (
    id serial PRIMARY KEY NOT NULL,
    menu_name character varying(32),
    action character varying(32),
    digits character varying(32),
    param character varying
);

ALTER TABLE public.mod_ivr_entry OWNER TO fsuser;

--
-- Name: mod_ivr_menus; Type: TABLE; Schema: public; Owner: fsuser
--

CREATE TABLE public.mod_ivr_menus (
    id serial PRIMARY KEY NOT NULL,
    name character varying NOT NULL,
    greet_long character varying(256),
    greet_short character varying(256),
    invalid_sound character varying(256),
    exit_sound character varying(256),
    inter_digit_timeout character varying(4),
    timeout character varying(4),
    confirm_macro character varying(256),
    confirm_key character varying(4),
    confirm_attempts character varying(4),
    max_failures character varying(4),
    max_timeouts character varying(4),
    exec_on_max_failures character varying(256),
    exec_on_max_timeouts character varying(256),
    tts_engine character varying(256),
    tts_voice character varying(256),
    digit_len character varying(16)
);


ALTER TABLE public.mod_ivr_menus OWNER TO fsuser;

--
-- Name: mod_cdr_pg; Type: TABLE; Schema: public; Owner: fsuser
--

CREATE TABLE public.mod_cdr_pg (
    id serial PRIMARY KEY NOT NULL,
    local_ip_v4 inet NOT NULL,
    caller_id_name character varying,
    caller_id_number character varying,
    destination_number character varying NOT NULL,
    context character varying NOT NULL,
    start_stamp timestamp with time zone NOT NULL,
    answer_stamp timestamp with time zone,
    end_stamp timestamp with time zone NOT NULL,
    duration integer NOT NULL,
    billsec integer NOT NULL,
    hangup_cause character varying NOT NULL,
    uuid uuid NOT NULL,
    bleg_uuid uuid,
    accountcode character varying,
    read_codec character varying,
    write_codec character varying,
    sip_hangup_disposition character varying,
    ani character varying,
    endpoint_disposition character varying(32),
    recdir character varying(512),
    recfile character varying(512)
);


ALTER TABLE public.mod_cdr_pg OWNER TO fsuser;


--
-- Name: mod_distributor; Type: TABLE; Schema: public; Owner: fsuser
--

CREATE TABLE public.mod_distributor (
    id serial PRIMARY KEY NOT NULL,
    list character varying,
    node character varying,
    weight character varying
);


ALTER TABLE public.mod_distributor OWNER TO fsuser;

--
-- Name: out_map; Type: TABLE; Schema: public; Owner: fsuser
--

CREATE TABLE public.out_map (
    id serial PRIMARY KEY NOT NULL,
    out_prepend character varying(32),
    out_prefix character varying(8),
    out_pattern text,
    out_type character varying(32),
    out_codec character varying(32) DEFAULT 'PCMA'::character varying,
    out_cid character varying(32),
    out_gw character varying(32),
    out_toll_allow character varying(32)
);


ALTER TABLE public.out_map OWNER TO fsuser;

--
-- Name: sip_profiles; Type: TABLE; Schema: public; Owner: fsuser
--

CREATE TABLE public.sip_profiles (
    id serial PRIMARY KEY NOT NULL,
    profile character varying,
    type character varying,
    name character varying,
    value character varying,
    enable boolean DEFAULT false NOT NULL,
    active boolean DEFAULT true
);


ALTER TABLE public.sip_profiles OWNER TO fsuser;

--
-- Name: user_map; Type: TABLE; Schema: public; Owner: fsuser
--

CREATE TABLE public.user_map (
    id integer PRIMARY KEY NOT NULL,
    did_start character varying(8) NOT NULL,
    did_end character varying(8) NOT NULL,
    type character varying(16) DEFAULT NULL::character varying,
    data character varying(512) DEFAULT NULL::character varying,
    codec character varying(128) DEFAULT NULL::character varying,
    branch character varying(128) DEFAULT NULL::character varying
);


ALTER TABLE public.user_map OWNER TO fsuser;

--
-- Name: agent_status; Type: TYPE; Schema: public; Owner: fsuser
--

CREATE TYPE public.agent_status AS ENUM (
    'Logged Out',
    'Available',
    'Available (On Demand)',
    'On Break'
);

ALTER TYPE public.agent_status OWNER TO fsuser;

--
-- Name: agent_type; Type: TYPE; Schema: public; Owner: fsuser
--

CREATE TYPE public.agent_type AS ENUM (
    'callback',
    'uuid-standby'
);

ALTER TYPE public.agent_type OWNER TO fsuser;

--
-- Name: queue_strategy; Type: TYPE; Schema: public; Owner: fsuser
--

CREATE TYPE public.queue_strategy AS ENUM (
    'ring-all',
    'longest-idle-agent',
    'round-robin',
    'top-down',
    'agent-with-least-talk-time',
    'agent-with-fewest-calls',
    'sequentially-by-agent-order',
    'random',
    'ring-progressively'
);

ALTER TYPE public.queue_strategy OWNER TO fsuser;

--
-- Name: mod_cc_agents; Type: TABLE; Schema: public; Owner: fsuser
--

CREATE TABLE public.mod_cc_agents (
    id serial PRIMARY KEY NOT NULL,
    name character varying,
    type public.agent_type,
    contact character varying NOT NULL,
    status public.agent_status,
    max_no_answer integer DEFAULT 3 NOT NULL,
    wrap_up_time integer DEFAULT 10 NOT NULL,
    reject_delay_time integer DEFAULT 3 NOT NULL,
    busy_delay_time integer DEFAULT 60 NOT NULL,
    no_answer_delay_time integer DEFAULT 5 NOT NULL,
    reserve_agents character varying DEFAULT 'false'::character varying NOT NULL,
    truncate_agents_on_load character varying DEFAULT 'false'::character varying NOT NULL,
    truncate_tiers_on_load character varying DEFAULT 'false'::character varying NOT NULL
);
 
 
ALTER TABLE public.mod_cc_agents OWNER TO fsuser;

--
-- Name: mod_cc_queues; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.mod_cc_queues (
    id serial PRIMARY KEY NOT NULL,
    name character varying,
    strategy public.queue_strategy,
    moh_sound character varying DEFAULT '$${hold_music}'::character varying NOT NULL,
    record_template character varying,
    time_base_score character varying DEFAULT 'queue'::character varying NOT NULL,
    max_wait_time integer DEFAULT 0 NOT NULL,
    max_wait_time_wna integer DEFAULT 0 NOT NULL,
    max_wait_time_wna_tr integer DEFAULT 5 NOT NULL,
    tier_rules_apply character varying DEFAULT 'false'::character varying NOT NULL,
    tier_rule_wait_second integer DEFAULT 300 NOT NULL,
    tier_rule_wait_ml character varying DEFAULT 'true'::character varying NOT NULL,
    tier_rule_no_agent_no_wait character varying DEFAULT 'false'::character varying NOT NULL,
    discard_abandoned_after integer DEFAULT 60 NOT NULL,
    abandoned_resume_allowed character varying DEFAULT 'false'::character varying NOT NULL,
    ring_progressively_delay integer DEFAULT 60 NOT NULL
);


ALTER TABLE public.mod_cc_queues OWNER TO fsuser;

--
-- Name: mod_cc_tiers; Type: TABLE; Schema: public; Owner: fsuser
--
 
CREATE TABLE public.mod_cc_tiers (
    id serial PRIMARY KEY NOT NULL,
    agent character varying NOT NULL,
    queue character varying NOT NULL,
    level integer DEFAULT 1 NOT NULL,
    "position" integer DEFAULT 1 NOT NULL
);

ALTER TABLE public.mod_cc_tiers OWNER TO fsuser;

--
-- Name: mod_cc_settings; Type: TABLE; Schema: public; Owner: fsuser
--

CREATE TABLE public.mod_cc_settings (
    id serial PRIMARY KEY NOT NULL,
    odbc_dsn character varying(1024),
    dbname character varying
);

ALTER TABLE public.mod_cc_settings OWNER TO fsuser;

--
-- PostgreSQL database dump complete
--