Modified: freeswitch/trunk/contrib/intralanman/PHP/fs_curl/sql/postgres-8.4.sql (15126 => 15127)
--- freeswitch/trunk/contrib/intralanman/PHP/fs_curl/sql/postgres-8.4.sql 2009-10-09 02:09:49 UTC (rev 15126)
+++ freeswitch/trunk/contrib/intralanman/PHP/fs_curl/sql/postgres-8.4.sql 2009-10-09 05:24:47 UTC (rev 15127)
@@ -25,6 +25,40 @@
SET default_with_oids = false;
--
+-- Name: accounts; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
+--
+
+CREATE TABLE accounts (
+ id bigint NOT NULL,
+ name character varying(256),
+ cash double precision NOT NULL
+);
+
+
+ALTER TABLE public.accounts OWNER TO freeswitch;
+
+--
+-- Name: accounts_id_seq; Type: SEQUENCE; Schema: public; Owner: freeswitch
+--
+
+CREATE SEQUENCE accounts_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MAXVALUE
+ NO MINVALUE
+ CACHE 1;
+
+
+ALTER TABLE public.accounts_id_seq OWNER TO freeswitch;
+
+--
+-- Name: accounts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: freeswitch
+--
+
+ALTER SEQUENCE accounts_id_seq OWNED BY accounts.id;
+
+
+--
-- Name: acl_lists; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -59,13 +93,6 @@
--
--- Name: acl_lists_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('acl_lists_id_seq', 1, false);
-
-
---
-- Name: acl_nodes; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -101,13 +128,6 @@
--
--- Name: acl_nodes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('acl_nodes_id_seq', 1, false);
-
-
---
-- Name: carrier_gateway; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -145,13 +165,6 @@
--
--- Name: carrier_gateway_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('carrier_gateway_id_seq', 1, false);
-
-
---
-- Name: carriers; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -186,13 +199,6 @@
--
--- Name: carriers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('carriers_id_seq', 1, false);
-
-
---
-- Name: conference_advertise; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -227,13 +233,6 @@
--
--- Name: conference_advertise_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('conference_advertise_id_seq', 1, false);
-
-
---
-- Name: conference_controls; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -269,13 +268,6 @@
--
--- Name: conference_controls_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('conference_controls_id_seq', 1, false);
-
-
---
-- Name: conference_profiles; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -311,13 +303,6 @@
--
--- Name: conference_profiles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('conference_profiles_id_seq', 1, false);
-
-
---
-- Name: dialplan; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -368,13 +353,6 @@
--
--- Name: dialplan_actions_action_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('dialplan_actions_action_id_seq', 1, false);
-
-
---
-- Name: dialplan_condition; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -411,13 +389,6 @@
--
--- Name: dialplan_condition_condition_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('dialplan_condition_condition_id_seq', 1, false);
-
-
---
-- Name: dialplan_context; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -453,13 +424,6 @@
--
--- Name: dialplan_context_context_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('dialplan_context_context_id_seq', 1, false);
-
-
---
-- Name: dialplan_dialplan_id_seq; Type: SEQUENCE; Schema: public; Owner: freeswitch
--
@@ -481,13 +445,6 @@
--
--- Name: dialplan_dialplan_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('dialplan_dialplan_id_seq', 1, false);
-
-
---
-- Name: dialplan_extension; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -524,13 +481,6 @@
--
--- Name: dialplan_extension_extension_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('dialplan_extension_extension_id_seq', 1, false);
-
-
---
-- Name: dialplan_special; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -565,13 +515,6 @@
--
--- Name: dialplan_special_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('dialplan_special_id_seq', 1, false);
-
-
---
-- Name: dingaling_profile_params; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -607,13 +550,6 @@
--
--- Name: dingaling_profile_params_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('dingaling_profile_params_id_seq', 1, false);
-
-
---
-- Name: dingaling_profiles; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -648,13 +584,6 @@
--
--- Name: dingaling_profiles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('dingaling_profiles_id_seq', 1, false);
-
-
---
-- Name: dingaling_settings; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -689,13 +618,6 @@
--
--- Name: dingaling_settings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('dingaling_settings_id_seq', 1, false);
-
-
---
-- Name: directory; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -742,13 +664,6 @@
--
--- Name: directory_domains_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('directory_domains_id_seq', 1, false);
-
-
---
-- Name: directory_gateway_params; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -784,13 +699,6 @@
--
--- Name: directory_gateway_params_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('directory_gateway_params_id_seq', 1, false);
-
-
---
-- Name: directory_gateways; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -825,13 +733,6 @@
--
--- Name: directory_gateways_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('directory_gateways_id_seq', 1, false);
-
-
---
-- Name: directory_global_params; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -867,13 +768,6 @@
--
--- Name: directory_global_params_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('directory_global_params_id_seq', 1, false);
-
-
---
-- Name: directory_global_vars; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -909,17 +803,23 @@
--
--- Name: directory_global_vars_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
+-- Name: directory_group_user_map; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
-SELECT pg_catalog.setval('directory_global_vars_id_seq', 1, false);
+CREATE TABLE directory_group_user_map (
+ map_id integer NOT NULL,
+ group_id integer NOT NULL,
+ user_id integer NOT NULL
+);
+ALTER TABLE public.directory_group_user_map OWNER TO freeswitch;
+
--
--- Name: directory_id_seq; Type: SEQUENCE; Schema: public; Owner: freeswitch
+-- Name: directory_group_user_map_map_id_seq; Type: SEQUENCE; Schema: public; Owner: freeswitch
--
-CREATE SEQUENCE directory_id_seq
+CREATE SEQUENCE directory_group_user_map_map_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
@@ -927,23 +827,70 @@
CACHE 1;
-ALTER TABLE public.directory_id_seq OWNER TO freeswitch;
+ALTER TABLE public.directory_group_user_map_map_id_seq OWNER TO freeswitch;
--
--- Name: directory_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: freeswitch
+-- Name: directory_group_user_map_map_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: freeswitch
--
-ALTER SEQUENCE directory_id_seq OWNED BY directory.id;
+ALTER SEQUENCE directory_group_user_map_map_id_seq OWNED BY directory_group_user_map.map_id;
--
--- Name: directory_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
+-- Name: directory_groups; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
-SELECT pg_catalog.setval('directory_id_seq', 1, false);
+CREATE TABLE directory_groups (
+ group_id integer NOT NULL,
+ group_name character varying(256) NOT NULL
+);
+ALTER TABLE public.directory_groups OWNER TO freeswitch;
+
--
+-- Name: directory_groups_group_id_seq; Type: SEQUENCE; Schema: public; Owner: freeswitch
+--
+
+CREATE SEQUENCE directory_groups_group_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MAXVALUE
+ NO MINVALUE
+ CACHE 1;
+
+
+ALTER TABLE public.directory_groups_group_id_seq OWNER TO freeswitch;
+
+--
+-- Name: directory_groups_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: freeswitch
+--
+
+ALTER SEQUENCE directory_groups_group_id_seq OWNED BY directory_groups.group_id;
+
+
+--
+-- Name: directory_id_seq; Type: SEQUENCE; Schema: public; Owner: freeswitch
+--
+
+CREATE SEQUENCE directory_id_seq
+ START WITH 1
+ INCREMENT BY 1
+ NO MAXVALUE
+ NO MINVALUE
+ CACHE 1;
+
+
+ALTER TABLE public.directory_id_seq OWNER TO freeswitch;
+
+--
+-- Name: directory_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: freeswitch
+--
+
+ALTER SEQUENCE directory_id_seq OWNED BY directory.id;
+
+
+--
-- Name: directory_params; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -979,13 +926,6 @@
--
--- Name: directory_params_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('directory_params_id_seq', 1, false);
-
-
---
-- Name: directory_vars; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1021,13 +961,6 @@
--
--- Name: directory_vars_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('directory_vars_id_seq', 1, false);
-
-
---
-- Name: easyroute_conf; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1062,13 +995,6 @@
--
--- Name: easyroute_conf_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('easyroute_conf_id_seq', 1, false);
-
-
---
-- Name: easyroute_data; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1107,13 +1033,6 @@
--
--- Name: easyroute_data_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('easyroute_data_id_seq', 1, false);
-
-
---
-- Name: iax_conf; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1147,13 +1066,6 @@
--
--- Name: iax_conf_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('iax_conf_id_seq', 1, false);
-
-
---
-- Name: iax_settings; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1189,13 +1101,6 @@
--
--- Name: iax_settings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('iax_settings_id_seq', 1, false);
-
-
---
-- Name: ivr_conf; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1237,13 +1142,6 @@
--
--- Name: ivr_conf_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('ivr_conf_id_seq', 1, false);
-
-
---
-- Name: ivr_entries; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1280,13 +1178,6 @@
--
--- Name: ivr_entries_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('ivr_entries_id_seq', 1, false);
-
-
---
-- Name: lcr; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1348,13 +1239,6 @@
--
--- Name: lcr_conf_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('lcr_conf_id_seq', 1, true);
-
-
---
-- Name: lcr_id_seq; Type: SEQUENCE; Schema: public; Owner: freeswitch
--
@@ -1376,13 +1260,6 @@
--
--- Name: lcr_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('lcr_id_seq', 1, false);
-
-
---
-- Name: lcr_profiles; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1416,13 +1293,6 @@
--
--- Name: lcr_profiles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('lcr_profiles_id_seq', 3, true);
-
-
---
-- Name: lcr_settings; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1458,13 +1328,6 @@
--
--- Name: lcr_settings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('lcr_settings_id_seq', 1, true);
-
-
---
-- Name: limit_conf; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1499,13 +1362,6 @@
--
--- Name: limit_conf_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('limit_conf_id_seq', 1, false);
-
-
---
-- Name: limit_data; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1556,13 +1412,6 @@
--
--- Name: local_stream_conf_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('local_stream_conf_id_seq', 1, false);
-
-
---
-- Name: modless_conf; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1596,13 +1445,6 @@
--
--- Name: modless_conf_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('modless_conf_id_seq', 1, false);
-
-
---
-- Name: npa_nxx_company_ocn; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1656,13 +1498,6 @@
--
--- Name: post_load_modules_conf_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('post_load_modules_conf_id_seq', 1, false);
-
-
---
-- Name: rss_conf; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1700,13 +1535,6 @@
--
--- Name: rss_conf_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('rss_conf_id_seq', 1, false);
-
-
---
-- Name: sip_authentication; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1888,13 +1716,6 @@
--
--- Name: sofia_aliases_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('sofia_aliases_id_seq', 1, false);
-
-
---
-- Name: sofia_conf; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1928,13 +1749,6 @@
--
--- Name: sofia_conf_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('sofia_conf_id_seq', 1, false);
-
-
---
-- Name: sofia_domains; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -1970,13 +1784,6 @@
--
--- Name: sofia_domains_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('sofia_domains_id_seq', 1, false);
-
-
---
-- Name: sofia_gateways; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -2013,13 +1820,6 @@
--
--- Name: sofia_gateways_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('sofia_gateways_id_seq', 1, false);
-
-
---
-- Name: sofia_settings; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -2055,13 +1855,6 @@
--
--- Name: sofia_settings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('sofia_settings_id_seq', 1, false);
-
-
---
-- Name: voicemail_conf; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -2095,13 +1888,6 @@
--
--- Name: voicemail_conf_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('voicemail_conf_id_seq', 1, false);
-
-
---
-- Name: voicemail_email; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -2137,13 +1923,6 @@
--
--- Name: voicemail_email_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
---
-
-SELECT pg_catalog.setval('voicemail_email_id_seq', 1, false);
-
-
---
-- Name: voicemail_msgs; Type: TABLE; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -2216,10 +1995,10 @@
--
--- Name: voicemail_settings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: freeswitch
+-- Name: id; Type: DEFAULT; Schema: public; Owner: freeswitch
--
-SELECT pg_catalog.setval('voicemail_settings_id_seq', 1, false);
+ALTER TABLE accounts ALTER COLUMN id SET DEFAULT nextval('accounts_id_seq'::regclass);
--
@@ -2377,6 +2156,20 @@
--
+-- Name: map_id; Type: DEFAULT; Schema: public; Owner: freeswitch
+--
+
+ALTER TABLE directory_group_user_map ALTER COLUMN map_id SET DEFAULT nextval('directory_group_user_map_map_id_seq'::regclass);
+
+
+--
+-- Name: group_id; Type: DEFAULT; Schema: public; Owner: freeswitch
+--
+
+ALTER TABLE directory_groups ALTER COLUMN group_id SET DEFAULT nextval('directory_groups_group_id_seq'::regclass);
+
+
+--
-- Name: id; Type: DEFAULT; Schema: public; Owner: freeswitch
--
@@ -2552,981 +2345,6 @@
--
--- Data for Name: acl_lists; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY acl_lists (id, acl_name, default_policy) FROM stdin;
-1 rfc1918 deny
-2 lan allow
-3 default allow
-\.
-
-
---
--- Data for Name: acl_nodes; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY acl_nodes (id, cidr, type, list_id) FROM stdin;
-1 192.168.0.0/16 allow 1
-2 10.0.0.0/8 allow 1
-3 172.16.0.0/12 allow 1
-\.
-
-
---
--- Data for Name: carrier_gateway; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY carrier_gateway (id, carrier_id, prefix, suffix, codec, enabled) FROM stdin;
-\.
-
-
---
--- Data for Name: carriers; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY carriers (id, carrier_name, enabled) FROM stdin;
-\.
-
-
---
--- Data for Name: conference_advertise; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY conference_advertise (id, room, status) FROM stdin;
-1 3000@$${domain} Freeswitch Conference
-2 3001@$${domain} FreeSWITCH Conference 2
-3 3002@$${domain} FreeSWITCH Conference 3
-\.
-
-
---
--- Data for Name: conference_controls; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY conference_controls (id, conf_group, action, digits) FROM stdin;
-1 default mute 0
-2 default deaf_mute *
-3 default energy up 9
-4 default energy equ 8
-5 default energy dn 7
-6 default vol talk up 3
-7 default vol talk dn 1
-8 default vol talk zero 2
-9 default vol listen up 6
-10 default vol listen dn 4
-11 default vol listen zero 5
-12 default hangup #
-\.
-
-
---
--- Data for Name: conference_profiles; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY conference_profiles (id, profile_name, param_name, param_value) FROM stdin;
-1 default domain $${domain}
-2 default rate 8000
-3 default interval 20
-4 default energy-level 300
-5 default moh-sound $${moh_uri}
-6 default caller-id-name $${outbound_caller_name}
-7 default caller-id-number $${outbound_caller_number}
-\.
-
-
---
--- Data for Name: dialplan; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY dialplan (dialplan_id, domain, ip_address) FROM stdin;
-1 freeswitch 127.0.0.1
-\.
-
-
---
--- Data for Name: dialplan_actions; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY dialplan_actions (action_id, condition_id, application, data, type, weight) FROM stdin;
-1 2 deflect ${destination_number} action 10
-2 5 set domain_name=$${domain} action 20
-3 5 set domain_name=${sip_auth_realm} anti-action 30
-4 7 set domain_name=$${domain} action 40
-5 9 set open=true action 50
-6 10 answer action 60
-7 10 intercept ${db(select/${domain_name}-last_dial/global)} action 70
-8 10 sleep 2000 action 80
-9 11 answer action 90
-10 11 intercept ${db(select/${domain_name}-last_dial/${callgroup})} action 100
-11 11 sleep 2000 action 110
-12 12 answer action 120
-13 12 intercept ${db(select/${domain_name}-last_dial_ext/$1)} action 130
-14 12 sleep 2000 action 140
-15 13 transfer ${db(select/${domain_name}-last_dial/${caller_id_number})} action 150
-16 14 set use_profile=${cond(${acl($${local_ip_v4} rfc1918)} == true ? nat : default)} action 160
-17 14 set use_profile=${cond(${acl(${network_addr} rfc1918)} == true ? nat : default)} anti-action 170
-18 15 set_user default@${domain_name} action 180
-19 16 info action 190
-20 17 set sip_secure_media=true action 200
-21 18 db insert/${domain_name}-spymap/${caller_id_number}/${uuid} action 210
-22 18 db insert/${domain_name}-last_dial/${caller_id_number}/${destination_number} action 220
-23 18 db insert/${domain_name}-last_dial/global/${uuid} action 230
-24 19 eval ${snom_bind_key(2 off DND ${sip_from_user} ${sip_from_host} ${sofia_profile_name} message notused)} action 240
-25 19 transfer 3000 action 250
-26 20 eval ${snom_bind_key(2 on DND ${sip_from_user} ${sip_from_host} ${sofia_profile_name} message api+uuid_transfer ${uuid} 9001)} action 260
-27 20 playback $${hold_music} action 270
-28 21 answer action 280
-29 21 eavesdrop ${db(select/${domain_name}-spymap/$1)} action 290
-30 22 answer action 300
-31 22 set eavesdrop_indicate_failed=tone_stream://%(500, 0, 320) action 310
-32 22 set eavesdrop_indicate_new=tone_stream://%(500, 0, 620) action 320
-33 22 set eavesdrop_indicate_idle=tone_stream://%(250, 0, 920) action 330
-34 22 eavesdrop all action 340
-35 23 transfer ${db(select/${domain_name}-call_return/${caller_id_number})} action 350
-36 24 answer action 360
-37 24 group delete:$1@${domain_name}:${sofia_contact(${sip_from_user}@${domain_name})} action 370
-38 24 gentones %(1000, 0, 320) action 380
-39 25 answer action 390
-40 25 group insert:$1@${domain_name}:${sofia_contact(${sip_from_user}@${domain_name})} action 400
-41 25 gentones %(1000, 0, 640) action 410
-42 26 bridge {ignore_early_media=true}${group(call:$1@${domain_name})} action 420
-43 27 set call_timeout=10 action 430
-44 27 bridge {ignore_early_media=true}${group(call:$1@${domain_name}:order)} action 440
-45 28 set dialed_extension=$1 action 450
-46 28 export sip_auto_answer=true action 460
-47 28 bridge user/${dialed_extension}@${domain_name} action 470
-48 29 set dialed_extension=$1 action 480
-49 29 export dialed_extension=$1 action 490
-50 30 set voicemail_authorized=${sip_authorized} action 500
-51 30 answer action 510
-52 30 sleep 1000 action 520
-53 30 voicemail check default ${domain_name} ${dialed_extension} action 530
-54 30 bind_meta_app 1 b s execute_extension::dx XML features anti-action 540
-55 30 bind_meta_app 2 b s record_session::$${base_dir}/recordings/${caller_id_number}.${strftime(%Y-%m-%d-%H-%M-%S)}.wav anti-action 550
-56 30 bind_meta_app 3 b s execute_extension::cf XML features anti-action 560
-57 30 set ringback=${us-ring} anti-action 570
-58 30 set transfer_ringback=$${hold_music} anti-action 580
-59 30 set call_timeout=30 anti-action 590
-60 30 set hangup_after_bridge=true anti-action 600
-61 30 set continue_on_fail=true anti-action 610
-62 30 db insert/${domain_name}-call_return/${dialed_extension}/${caller_id_number} anti-action 620
-63 30 db insert/${domain_name}-last_dial_ext/${dialed_extension}/${uuid} anti-action 630
-64 30 set called_party_callgroup=${user_data(${dialed_extension}@${domain_name} var callgroup)} anti-action 640
-65 30 db insert/${domain_name}-last_dial/${called_party_callgroup}/${uuid} anti-action 650
-66 30 bridge user/${dialed_extension}@${domain_name} anti-action 660
-67 30 answer anti-action 670
-68 30 sleep 1000 anti-action 680
-69 30 voicemail default ${domain_name} ${dialed_extension} anti-action 690
-70 31 bridge ${group_call(sales@${domain_name})} action 700
-71 32 bridge group/support@${domain_name} action 710
-72 33 bridge group/billing@${domain_name} action 720
-73 34 set transfer_ringback=$${hold_music} action 730
-74 34 transfer 1000 XML features action 740
-75 35 answer action 750
-76 35 sleep 1000 action 760
-77 35 voicemail check default ${domain_name} action 770
-78 36 bridge sofia/${use_profile}/$1 action 780
-79 37 answer action 790
-80 37 conference $1-${domain_name}@default action 800
-81 38 answer action 810
-82 38 conference $1-${domain_name}@wideband action 820
-83 39 answer action 830
-84 39 conference $1-${domain_name}@ultrawideband action 840
-85 40 answer action 850
-86 40 conference $1-${domain_name}@cdquality action 860
-87 41 bridge sofia/${use_profile}/$1@conference.freeswitch.org action 870
-88 42 set conference_auto_outcall_caller_id_name=Mad Boss1 action 880
-89 42 set conference_auto_outcall_caller_id_number=0911 action 890
-90 42 set conference_auto_outcall_timeout=60 action 900
-91 42 set conference_auto_outcall_flags=mute action 910
-92 42 set conference_auto_outcall_prefix={sip_auto_answer=true,execute_on_answer='bind_meta_app 2 a s1 intercept::${uuid}'} action 920
-93 42 set sip_exclude_contact=${network_addr} action 930
-94 42 conference_set_auto_outcall ${group_call(sales)} action 940
-95 42 conference madboss_intercom1@default+flags{endconf|deaf} action 950
-96 43 set conference_auto_outcall_caller_id_name=Mad Boss2 action 960
-97 43 set conference_auto_outcall_caller_id_number=0912 action 970
-98 43 set conference_auto_outcall_timeout=60 action 980
-99 43 set conference_auto_outcall_flags=mute action 990
-100 43 set conference_auto_outcall_prefix={sip_auto_answer=true,execute_on_answer='bind_meta_app 2 a s1 intercept::${uuid}'} action 1000
-101 43 set sip_exclude_contact=${network_addr} action 1010
-102 43 conference_set_auto_outcall loopback/9999 action 1020
-103 43 conference madboss_intercom2@default+flags{endconf|deaf} action 1030
-104 44 set conference_auto_outcall_caller_id_name=Mad Boss action 1040
-105 44 set conference_auto_outcall_caller_id_number=0911 action 1050
-106 44 set conference_auto_outcall_timeout=60 action 1060
-107 44 set conference_auto_outcall_flags=none action 1070
-108 44 conference_set_auto_outcall loopback/9999 action 1080
-109 44 conference madboss3@default action 1090
-110 45 answer action 1100
-111 45 sleep 2000 action 1110
-112 45 ivr demo_ivr action 1120
-113 46 conference bridge:mydynaconf:sofia/${use_profile}/1234@conference.freeswitch.org action 1130
-114 47 answer action 1140
-115 47 esf_page_group action 1150
-116 48 set fifo_music=$${hold_music} action 1160
-117 48 fifo 5900@${domain_name} in action 1170
-118 49 answer action 1180
-119 49 fifo 5900@${domain_name} out nowait action 1190
-120 51 fifo $1@${domain_name} in undef $${hold_music} action 1200
-121 54 answer action 1210
-122 54 fifo $1@${domain_name} out nowait action 1220
-123 57 expression 1230
-124 57 fifo $1@${domain_name} in undef $${hold_music} action 1240
-125 60 answer action 1250
-126 60 fifo $1@${domain_name} out nowait action 1260
-127 61 pre_answer action 1270
-128 61 sleep 20000 action 1280
-129 61 answer action 1290
-130 61 sleep 1000 action 1300
-131 61 playback voicemail/vm-goodbye.wav action 1310
-132 61 hangup action 1320
-133 62 ring_ready action 1330
-134 62 sleep 20000 action 1340
-135 62 answer action 1350
-136 62 sleep 1000 action 1360
-137 62 playback voicemail/vm-goodbye.wav action 1370
-138 62 hangup action 1380
-139 63 set ringback=$${uk-ring} action 1390
-140 63 bridge loopback/wait action 1400
-141 64 set ringback=$${hold_music} action 1410
-142 64 bridge loopback/wait action 1420
-143 65 set transfer_ringback=$${uk-ring} action 1430
-144 65 answer action 1440
-145 65 bridge loopback/wait action 1450
-146 66 set transfer_ringback=$${hold_music} action 1460
-147 66 answer action 1470
-148 66 bridge loopback/wait action 1480
-149 67 answer action 1490
-150 67 info action 1500
-151 67 sleep 250 action 1510
-152 67 hangup action 1520
-153 68 answer action 1530
-154 68 record_fsv /tmp/testrecord.fsv action 1540
-155 69 answer action 1550
-156 69 play_fsv /tmp/testrecord.fsv action 1560
-157 70 answer action 1570
-158 70 delay_echo 5000 action 1580
-159 71 answer action 1590
-160 71 echo action 1600
-161 72 answer action 1610
-162 72 playback tone_stream://%(10000,0,1004);loops=-1 action 1620
-163 73 answer action 1630
-164 73 playback tone_stream://path=${base_dir}/conf/tetris.ttml;loops=10 action 1640
-165 75 answer action 1650
-166 75 execute_extension is_secure XML features action 1660
-167 75 playback $${hold_music} action 1670
-168 75 answer anti-action 1680
-169 75 playback $${hold_music} anti-action 1690
-\.
-
-
---
--- Data for Name: dialplan_condition; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY dialplan_condition (condition_id, extension_id, field, expression, weight) FROM stdin;
-1 1 $${unroll_loops} ^true$ 10
-2 1 ${sip_looped_call} ^true$ 20
-3 2 ${domain_name} ^$ 30
-4 2 source mod_sofia 40
-5 2 ${sip_auth_realm} ^$ 50
-6 3 ${domain_name} ^$ 60
-7 3 source mod_openzap 70
-8 4 ${strftime(%w)} ^([1-5])$ 80
-9 4 ${strftime(%H%M)} ^((09|1[0-7])[0-5][0-9]|1800)$ 90
-10 5 destination_number ^886$ 100
-11 6 destination_number ^*8$ 110
-12 7 destination_number ^**(d+)$ 120
-13 8 destination_number ^870$ 130
-14 9 ${network_addr} ^$ 140
-15 9 ${numbering_plan} ^$ 150
-16 9 ${call_debug} ^true$ 160
-17 9 ${sip_has_crypto} ^(AES_CM_128_HMAC_SHA1_32|AES_CM_128_HMAC_SHA1_80)$ 170
-18 9 180
-19 10 destination_number ^9001$ 190
-20 11 destination_number ^9000$ 200
-21 12 destination_number ^88(.*)$|^*0(.*)$ 210
-22 13 destination_number ^779$ 220
-23 14 destination_number ^*69$|^869$|^lcr$ 230
-24 15 destination_number ^80(d{2})$ 240
-25 16 destination_number ^81(d{2})$ 250
-26 17 destination_number ^82(d{2})$ 260
-27 18 destination_number ^83(d{2})$ 270
-28 19 destination_number ^8(10[01][0-9])$ 280
-29 20 destination_number ^(20[01][0-9])$ 290
-30 20 destination_number ^${caller_id_number}$ 300
-31 21 destination_number ^3000$ 310
-32 22 destination_number ^3001$ 320
-33 23 destination_number ^3002$ 330
-34 24 destination_number ^operator$|^0$ 340
-35 25 destination_number ^vmain|4000$ 350
-36 26 destination_number ^sip:(.*)$ 360
-37 27 destination_number ^(30d{2})$ 370
-38 28 destination_number ^(31d{2})$ 380
-39 29 destination_number ^(32d{2})$ 390
-40 30 destination_number ^(33d{2})$ 400
-41 31 destination_number ^9(888|1616|3232)$ 410
-42 32 destination_number ^0911$ 420
-43 33 destination_number ^0912$ 430
-44 34 destination_number ^0913$ 440
-45 35 destination_number ^5000$ 450
-46 36 destination_number ^5001$ 460
-47 37 destination_number ^pagegroup$|^7243 470
-48 38 destination_number ^5900$ 480
-49 39 destination_number ^5901$ 490
-50 40 source mod_sofia 500
-51 40 destination_number park+(d+) 510
-52 41 source mod_sofia 520
-53 41 destination_number ^parking$ 530
-54 41 ${sip_to_params} fifo=(d+) 540
-55 42 source mod_sofia 550
-56 42 destination_number callpark 560
-57 42 ${sip_refer_to} 570
-58 43 source mod_sofia 580
-59 43 destination_number pickup 590
-60 43 ${sip_to_params} orbit=(d+) 600
-61 44 destination_number ^wait$ 610
-62 45 destination_number ^9980$ 620
-63 46 destination_number ^9981$ 630
-64 47 destination_number ^9982$ 640
-65 48 destination_number ^9983$ 650
-66 49 destination_number ^9984$ 660
-67 50 destination_number ^9992$ 670
-68 51 destination_number ^9993$ 680
-69 52 destination_number ^9994$ 690
-70 53 destination_number ^9995$ 700
-71 54 destination_number ^9996$ 710
-72 55 destination_number ^9997$ 720
-73 56 destination_number ^9998$ 730
-74 57 destination_number ^9999$ 740
-75 57 ${sip_has_crypto} ^(AES_CM_128_HMAC_SHA1_32|AES_CM_128_HMAC_SHA1_80)$ 750
-\.
-
-
---
--- Data for Name: dialplan_context; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY dialplan_context (context_id, dialplan_id, context, weight) FROM stdin;
-1 1 default 10
-2 1 public 20
-\.
-
-
---
--- Data for Name: dialplan_extension; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY dialplan_extension (extension_id, context_id, name, continue, weight) FROM stdin;
-1 1 unloop 10
-2 1 set_domain true 20
-3 1 set_domain_openzap true 30
-4 1 tod_example true 40
-5 1 global-intercept 50
-6 1 group-intercept 60
-7 1 intercept-ext 70
-8 1 redial 80
-9 1 global true 90
-10 1 snom-demo-2 100
-11 1 snom-demo-1 110
-12 1 eavesdrop 120
-13 1 eavesdrop 130
-14 1 call_return 140
-15 1 del-group 150
-16 1 add-group 160
-17 1 call-group-simo 170
-18 1 call-group-order 180
-19 1 extension-intercom 190
-20 1 Local_Extension 200
-21 1 group_dial_sales 210
-22 1 group_dial_support 220
-23 1 group_dial_billing 230
-24 1 operator 240
-25 1 vmain 250
-26 1 sip_uri 260
-27 1 nb_conferences 270
-28 1 wb_conferences 280
-29 1 uwb_conferences 290
-30 1 cdquality_conferences 300
-31 1 freeswitch_public_conf_via_sip 310
-32 1 mad_boss_intercom 320
-33 1 mad_boss_intercom 330
-34 1 mad_boss 340
-35 1 ivr_demo 350
-36 1 dyanmic conference 360
-37 1 rtp_multicast_page 370
-38 1 park 380
-39 1 unpark 390
-40 1 park 400
-41 1 unpark 410
-42 1 park 420
-43 1 unpark 430
-44 1 wait 440
-45 1 ringback_180 450
-46 1 ringback_183_uk_ring 460
-47 1 ringback_183_music_ring 470
-48 1 ringback_post_answer_uk_ring 480
-49 1 ringback_post_answer_music 490
-50 1 show_info 500
-51 1 video_record 510
-52 1 video_playback 520
-53 1 delay_echo 530
-54 1 echo 540
-55 1 milliwatt 550
-56 2 tone_stream 560
-57 2 hold_music 570
-\.
-
-
---
--- Data for Name: dialplan_special; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY dialplan_special (id, context, class_file) FROM stdin;
-\.
-
-
---
--- Data for Name: dingaling_profile_params; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY dingaling_profile_params (id, dingaling_id, param_name, param_value) FROM stdin;
-1 1 password secret
-2 1 dialplan XML,enum
-3 1 server example.org
-4 1 name fs.example.org
-\.
-
-
---
--- Data for Name: dingaling_profiles; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY dingaling_profiles (id, profile_name, type) FROM stdin;
-1 fs.intralanman.servehttp.com component
-\.
-
-
---
--- Data for Name: dingaling_settings; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY dingaling_settings (id, param_name, param_value) FROM stdin;
-1 debug 0
-2 codec-prefs $${global_codec_prefs}
-\.
-
-
---
--- Data for Name: directory; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY directory (id, username, domain) FROM stdin;
-1 1000 example.com
-2 1001 example.org
-3 1002 example.net
-5 1003 example.info
-6 1004 example.com
-7 1005 example.org
-8 1006 example.net
-9 1007 example.info
-10 2000 default
-11 1009 $${local_ip_v4}
-\.
-
-
---
--- Data for Name: directory_domains; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY directory_domains (id, domain_name) FROM stdin;
-1 freeswitch.org
-2 sofaswitch.org
-\.
-
-
---
--- Data for Name: directory_gateway_params; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY directory_gateway_params (id, d_gw_id, param_name, param_value) FROM stdin;
-\.
-
-
---
--- Data for Name: directory_gateways; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY directory_gateways (id, directory_id, gateway_name) FROM stdin;
-\.
-
-
---
--- Data for Name: directory_global_params; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY directory_global_params (id, param_name, param_value, directory_id) FROM stdin;
-\.
-
-
---
--- Data for Name: directory_global_vars; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY directory_global_vars (id, var_name, var_value, directory_id) FROM stdin;
-\.
-
-
---
--- Data for Name: directory_params; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY directory_params (id, directory_id, param_name, param_value) FROM stdin;
-1 1 password 1234
-2 1 vm-password 861000
-3 2 password 1234
-4 2 vm-password 861001
-7 5 password 1234
-8 6 password 1234
-9 7 password 1234
-10 8 password 123456
-11 9 password 1234
-12 10 password 123456
-13 11 password 1234
-14 3 vm-password 861002
-15 3 password 1234
-16 11 vm-password 861009
-17 10 vm-password 1234
-18 9 vm-password 861007
-19 8 vm-password 861006
-20 7 vm-password 861005
-21 6 vm-password 861004
-22 5 vm-password 861003
-\.
-
-
---
--- Data for Name: directory_vars; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY directory_vars (id, directory_id, var_name, var_value) FROM stdin;
-1 1 numbering_plan US
-2 2 numbering_plan US
-3 3 numbering_plan AU
-4 5 numbering_plan US
-5 5 area_code 434
-\.
-
-
---
--- Data for Name: easyroute_conf; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY easyroute_conf (id, param_name, param_value) FROM stdin;
-1 custom-query SELECT * FROM easyroute_data WHERE number = '%s';
-2 db-dsn pgodbc
-3 db-username freeswitch
-4 db-password Fr33Sw1tch
-5 default-techprofile sofia
-6 default-gateway $${local_ip_v4}:5080
-\.
-
-
---
--- Data for Name: easyroute_data; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY easyroute_data (id, gateway, "group", call_limit, tech_prefix, acctcode, destination_number) FROM stdin;
-\.
-
-
---
--- Data for Name: iax_conf; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY iax_conf (id, profile_name) FROM stdin;
-3 test_profile
-\.
-
-
---
--- Data for Name: iax_settings; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY iax_settings (id, iax_id, param_name, param_value) FROM stdin;
-35 3 debug 1
-36 3 ip $${local_ip_v4}
-37 3 port 4569
-38 3 context public
-39 3 dialplan enum,XML
-40 3 codec-prefs $${global_codec_prefs}
-41 3 codec-master us
-42 3 codec-rate 8
-\.
-
-
---
--- Data for Name: ivr_conf; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY ivr_conf (id, name, greet_long, greet_short, invalid_sound, exit_sound, max_failures, timeout, tts_engine, tts_voice) FROM stdin;
-\.
-
-
---
--- Data for Name: ivr_entries; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY ivr_entries (id, ivr_id, action, digits, params) FROM stdin;
-\.
-
-
---
--- Data for Name: lcr; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY lcr (id, digits, rate, intrastate_rate, intralata_rate, carrier_id, lead_strip, trail_strip, prefix, suffix, lcr_profile, date_start, date_end, quality, reliability, cid, enabled) FROM stdin;
-\.
-
-
---
--- Data for Name: lcr_conf; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY lcr_conf (id, param_name, param_value) FROM stdin;
-1 odbc-dsn pgodbc:freeswitch:Fr33Sw1tch
-\.
-
-
---
--- Data for Name: lcr_profiles; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY lcr_profiles (id, profile_name) FROM stdin;
-1 default
-2 test
-3 test2
-\.
-
-
---
--- Data for Name: lcr_settings; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY lcr_settings (id, lcr_id, param_name, param_value) FROM stdin;
-1 1 order_by rate,quality,reliability
-\.
-
-
---
--- Data for Name: limit_conf; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY limit_conf (id, name, value) FROM stdin;
-\.
-
-
---
--- Data for Name: limit_data; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY limit_data (hostname, realm, id, uuid) FROM stdin;
-\.
-
-
---
--- Data for Name: local_stream_conf; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY local_stream_conf (id, directory_name, directory_path, param_name, param_value) FROM stdin;
-\.
-
-
---
--- Data for Name: modless_conf; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY modless_conf (id, conf_name) FROM stdin;
-1 acl.conf
-2 postl_load_switch.conf
-3 post_load_modules.conf
-\.
-
-
---
--- Data for Name: npa_nxx_company_ocn; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY npa_nxx_company_ocn (npa, nxx, company_type, ocn, company_name, lata, ratecenter, state) FROM stdin;
-\.
-
-
---
--- Data for Name: post_load_modules_conf; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY post_load_modules_conf (id, module_name, load_module, priority) FROM stdin;
-1 mod_sofia t 2000
-2 mod_iax t 2000
-3 mod_xml_rpc t 100
-4 mod_portaudio t 1000
-5 mod_enum t 2000
-6 mod_xml_cdr t 1000
-7 mod_spidermonkey t 1000
-8 mod_alsa f 1000
-10 mod_commands t 1000
-11 mod_voicemail t 1000
-12 mod_dialplan_xml t 150
-13 mod_dialplan_asterisk t 150
-14 mod_openzap f 1000
-15 mod_woomera f 1000
-17 mod_speex t 500
-18 mod_ilbc f 1000
-20 mod_g723_1 t 500
-21 mod_g729 t 500
-25 mod_amr t 500
-26 mod_fifo t 1000
-27 mod_limit t 1000
-28 mod_syslog t 0
-29 mod_dingaling t 2000
-30 mod_cdr_csv t 1000
-31 mod_event_socket t 100
-32 mod_multicast f 1000
-33 mod_zeroconf f 1000
-34 mod_xmpp_event f 1000
-35 mod_sndfile t 1000
-36 mod_native_file t 1000
-38 mod_local_stream t 1000
-39 mod_perl f 1000
-40 mod_python f 1000
-41 mod_java f 1000
-42 mod_cepstral f 1000
-43 mod_openmrcp f 1000
-44 mod_lumenvox f 1000
-45 mod_rss f 1000
-47 mod_say_fr f 1000
-48 mod_say_en t 1000
-49 mod_conference t 1000
-50 mod_ivr f 1000
-51 mod_console t 0
-52 mod_dptools t 1500
-53 mod_voipcodecs t 500
-55 mod_celt t 500
-37 mod_shout f 1000
-46 mod_say_de f 1000
-56 mod_say_es t 1000
-57 mod_lcr t 1500
-58 mod_easyroute t 1500
-59 mod_nibblebill t 1500
-54 mod_siren t 500
-9 mod_log_file f 0
-\.
-
-
---
--- Data for Name: rss_conf; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY rss_conf (id, directory_id, feed, local_file, description, priority) FROM stdin;
-\.
-
-
---
--- Data for Name: sip_authentication; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY sip_authentication (nonce, expires, profile_name, hostname) FROM stdin;
-\.
-
-
---
--- Data for Name: sip_dialogs; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY sip_dialogs (call_id, uuid, sip_to_user, sip_to_host, sip_from_user, sip_from_host, contact_user, contact_host, state, direction, user_agent, profile_name, hostname) FROM stdin;
-\.
-
-
---
--- Data for Name: sip_presence; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY sip_presence (sip_user, sip_host, status, rpid, expires, user_agent, profile_name, hostname, network_ip, network_port) FROM stdin;
-\.
-
-
---
--- Data for Name: sip_registrations; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY sip_registrations (call_id, sip_user, sip_host, presence_hosts, contact, status, rpid, expires, user_agent, server_user, server_host, profile_name, hostname, network_ip, network_port, sip_username, sip_realm, mwi_user, mwi_host) FROM stdin;
-\.
-
-
---
--- Data for Name: sip_shared_appearance_dialogs; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY sip_shared_appearance_dialogs (profile_name, hostname, contact_str, call_id, network_ip, expires) FROM stdin;
-\.
-
-
---
--- Data for Name: sip_shared_appearance_subscriptions; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY sip_shared_appearance_subscriptions (subscriber, call_id, aor, profile_name, hostname, contact_str, network_ip) FROM stdin;
-\.
-
-
---
--- Data for Name: sip_subscriptions; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY sip_subscriptions (proto, sip_user, sip_host, sub_to_user, sub_to_host, presence_hosts, event, contact, call_id, full_from, full_via, expires, user_agent, accept, profile_name, hostname, network_port, network_ip) FROM stdin;
-\.
-
-
---
--- Data for Name: sofia_aliases; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY sofia_aliases (id, sofia_id, alias_name) FROM stdin;
-\.
-
-
---
--- Data for Name: sofia_conf; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY sofia_conf (id, profile_name) FROM stdin;
-1 $${domain}
-\.
-
-
---
--- Data for Name: sofia_domains; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY sofia_domains (id, sofia_id, domain_name, parse) FROM stdin;
-\.
-
-
---
--- Data for Name: sofia_gateways; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY sofia_gateways (id, sofia_id, gateway_name, gateway_param, gateway_value) FROM stdin;
-8 1 default proxy asterlink.com
-9 1 default realm asterlink.com
-10 1 default username USERNAME_HERE
-11 1 default register false
-12 1 default expire-seconds 60
-14 1 default password PASSWORD_HERE
-13 1 default retry_seconds 30
-\.
-
-
---
--- Data for Name: sofia_settings; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY sofia_settings (id, sofia_id, param_name, param_value) FROM stdin;
-2 1 auth-calls true
-5 1 debug 1
-6 1 rfc2833-pt 101
-7 1 sip-port 5060
-8 1 dialplan XML
-10 1 codec-prefs $${global_codec_prefs}
-11 1 rtp-timeout-sec 300
-12 1 rtp-ip $${local_ip_v4}
-13 1 sip-ip $${local_ip_v4}
-14 1 context default
-15 1 manage-presence true
-18 1 rtp-rewrite-timestampes true
-19 1 nonce-ttl 60
-16 1 force-register-domain $${domain}
-36 1 odbc-dsn pgodbc:freeswitch:Fr33Sw1tch
-1 1 user-agent-string FreeSWITCH/fs_curl
-\.
-
-
---
--- Data for Name: voicemail_conf; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY voicemail_conf (id, vm_profile) FROM stdin;
-1 default
-\.
-
-
---
--- Data for Name: voicemail_email; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY voicemail_email (id, voicemail_id, param_name, param_value) FROM stdin;
-1 1 template-file voicemail.tpl
-2 1 date-fmt %A, %B %d %Y, %I %M %p
-3 1 email-from ${voicemail_account}@${voicemail_domain}
-\.
-
-
---
--- Data for Name: voicemail_msgs; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY voicemail_msgs (created_epoch, read_epoch, username, domain, uuid, cid_name, cid_number, in_folder, file_path, message_len, flags, read_flags) FROM stdin;
-\.
-
-
---
--- Data for Name: voicemail_prefs; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY voicemail_prefs (username, domain, name_path, greeting_path, password) FROM stdin;
-\.
-
-
---
--- Data for Name: voicemail_settings; Type: TABLE DATA; Schema: public; Owner: freeswitch
---
-
-COPY voicemail_settings (id, voicemail_id, param_name, param_value) FROM stdin;
-1 1 file-extension wav
-2 1 terminator-key #
-3 1 max-login-attempts 3
-4 1 digit-timeout 10000
-6 1 tone-spec %(1000, 0, 640)
-7 1 callback-dialplan XML
-8 1 callback-context default
-9 1 play-new-messages-key 1
-10 1 play-saved-messages-key 2
-11 1 main-menu-key *
-12 1 config-menu-key 5
-13 1 record-greeting-key 1
-14 1 choose-greeting-key 2
-15 1 record-file-key 3
-16 1 listen-file-key 1
-17 1 record-name-key 3
-18 1 save-file-key 9
-19 1 delete-file-key 7
-20 1 undelete-file-key 8
-21 1 email-key 4
-22 1 pause-key 0
-23 1 restart-key 1
-24 1 ff-key 6
-25 1 rew-key 4
-26 1 record-silence-threshold 200
-27 1 record-silence-hits 2
-28 1 web-template-file web-vm.tpl
-29 1 operator-extension operator XML default
-30 1 operator-key 9
-31 1 odbc-dsn pgodbc:freeswitch:Fr33Sw1tch
-\.
-
-
---
-- Name: acl_lists_pkey; Type: CONSTRAINT; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -3775,6 +2593,38 @@
--
+-- Name: directory_group_user_map_group_id_key; Type: CONSTRAINT; Schema: public; Owner: freeswitch; Tablespace:
+--
+
+ALTER TABLE ONLY directory_group_user_map
+ ADD CONSTRAINT directory_group_user_map_group_id_key UNIQUE (group_id, user_id);
+
+
+--
+-- Name: directory_group_user_map_pkey; Type: CONSTRAINT; Schema: public; Owner: freeswitch; Tablespace:
+--
+
+ALTER TABLE ONLY directory_group_user_map
+ ADD CONSTRAINT directory_group_user_map_pkey PRIMARY KEY (map_id);
+
+
+--
+-- Name: directory_groups_group_name_key; Type: CONSTRAINT; Schema: public; Owner: freeswitch; Tablespace:
+--
+
+ALTER TABLE ONLY directory_groups
+ ADD CONSTRAINT directory_groups_group_name_key UNIQUE (group_name);
+
+
+--
+-- Name: directory_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: freeswitch; Tablespace:
+--
+
+ALTER TABLE ONLY directory_groups
+ ADD CONSTRAINT directory_groups_pkey PRIMARY KEY (group_id);
+
+
+--
-- Name: directory_params_directory_id_key; Type: CONSTRAINT; Schema: public; Owner: freeswitch; Tablespace:
--
@@ -4589,6 +3439,22 @@
--
+-- Name: directory_group_user_map_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: freeswitch
+--
+
+ALTER TABLE ONLY directory_group_user_map
+ ADD CONSTRAINT directory_group_user_map_group_id_fkey FOREIGN KEY (group_id) REFERENCES directory_groups(group_id) ON UPDATE CASCADE ON DELETE CASCADE;
+
+
+--
+-- Name: directory_group_user_map_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: freeswitch
+--
+
+ALTER TABLE ONLY directory_group_user_map
+ ADD CONSTRAINT directory_group_user_map_user_id_fkey FOREIGN KEY (user_id) REFERENCES directory(id) ON UPDATE CASCADE ON DELETE CASCADE;
+
+
+--
-- Name: directory_params_directory_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: freeswitch
--