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

COPY public.item_email_customs (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated, custom_text, to_email, subject) FROM stdin;
\.


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

COPY public.item_email_depositcrosssells (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_docusigns (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_drip_captures (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_drip_churn_polrs (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_drip_churns (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_drips (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_dtv_leads (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_errors (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_google_reviews (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_hold_order_notifications (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_hold_order_reminders (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_hold_orders (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_lead_dtvs (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_leads (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_myaccount_claim_rafs (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_myaccount_contract_expirations (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_myaccount_rafs (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_myaccount_registers (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_myaccount_renewals (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_myaccounts (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_order_cancelleds (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_orderss (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_outbox_notifications (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_outboxs (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_partial_cart_firsts (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_partial_cart_seconds (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_partial_cart_thirds (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_partial_carts (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_prepared_cart_reminders (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_prepared_carts (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_rate_receiveds (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_rejecteds (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_renewals (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_rep_questionnaires (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_review_approveds (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_review_comment_ters (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_review_comments (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_review_pendings (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_review_receiveds (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_reviews (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_solar_leads (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_email_write_reviews (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_emails (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
\.


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

COPY public.item_file_customer_uploads (id, error_log, file_type, file_size, file_name, file_path) FROM stdin;
\.


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

COPY public.item_file_emails (id, error_log, file_type, file_size, file_name, file_path) FROM stdin;
\.


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

COPY public.item_file_legals (id, error_log, file_type, file_size, file_name, file_path) FROM stdin;
\.


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

COPY public.item_file_phonecall_dcs (id, error_log, file_type, file_size, file_name, file_path, phone, call_date, original_path_hash) FROM stdin;
\.


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

COPY public.item_file_phonecall_fivenines (id, error_log, file_type, file_size, file_name, file_path, phone, call_date) FROM stdin;
\.


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

COPY public.item_file_phonecall_ivrs (id, error_log, file_type, file_size, file_name, file_path, phone, call_date, campaign, disposition, dnis, call_seconds, ivr_path) FROM stdin;
\.


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

COPY public.item_file_phonecall_primes (id, error_log, file_type, file_size, file_name, file_path, phone, call_date) FROM stdin;
\.


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

COPY public.item_file_phonecall_trusteds (id, error_log, file_type, file_size, file_name, file_path, phone, call_date) FROM stdin;
\.


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

COPY public.item_file_phonecall_vsynergizes (id, error_log, file_type, file_size, file_name, file_path, phone, call_date) FROM stdin;
\.


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

COPY public.item_file_phonecalls (id, error_log, file_type, file_size, file_name, file_path, phone, call_date) FROM stdin;
\.


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

COPY public.item_file_screenshots (id, error_log, file_type, file_size, file_name, file_path) FROM stdin;
1623107249665360879		jpg	0	submit	
1623107249603560879		txt	0	ip	/var/local/files/screenshot_dev/162/31/0/1623103078188059729_1623107249603560879_ip_1.txt
1623165771708774833		jpg	0	submit	
1623169196000210028		txt	0	ip	/var/local/files/screenshot_dev/162/31/6/1623169180875574832_1623169196000210028_ip_1.txt
1623165771584374833		txt	0	ip	/var/local/files/screenshot_dev/162/31/6/1623165712102293646_1623165771584374833_ip_1.txt
1623168995031274832		jpg	0	submit	
1623168994962974832		txt	0	ip	/var/local/files/screenshot_dev/162/31/6/1623168961726399495_1623168994962974832_ip_1.txt
1623169042282796400		jpg	0	submit	
1623169042188196400		txt	0	ip	/var/local/files/screenshot_dev/162/31/6/1623169038009999495_1623169042188196400_ip_1.txt
1623169091997810016		txt	0	ip	/var/local/files/screenshot_dev/162/31/6/1623169087523474832_1623169091997810016_ip_1.txt
1623169184969910009		txt	0	ip	/var/local/files/screenshot_dev/162/31/6/1623169180875574832_1623169184969910009_ip_1.txt
1623169196090210028		jpg	883	submit	/var/local/files/screenshot_dev/162/31/6/1623169180875574832_1623169196090210028_submit_1.jpg
\.


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

COPY public.item_file_texts (id, error_log, file_type, file_size, file_name, file_path) FROM stdin;
\.


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

COPY public.item_file_upload_amazons (id, error_log, file_type, file_size, file_name, file_path, cis_user) FROM stdin;
\.


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

COPY public.item_file_upload_ftps (id, error_log, file_type, file_size, file_name, file_path, cis_user, ftp_host, ftp_username, ftp_password, ftp_path) FROM stdin;
\.


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

COPY public.item_file_upload_orderss (id, error_log, file_type, file_size, file_name, file_path, cis_user) FROM stdin;
\.


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

COPY public.item_file_uploads (id, error_log, file_type, file_size, file_name, file_path, cis_user) FROM stdin;
\.


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

COPY public.item_files (id, error_log, file_type, file_size, file_name, file_path) FROM stdin;
\.


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

COPY public.item_giftcard_rafs (id, error_log, amount, reference_id, reference, earned, claimed, paid) FROM stdin;
\.


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

COPY public.item_giftcards (id, error_log, amount, reference_id, reference, earned, claimed, paid) FROM stdin;
\.


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

COPY public.item_list_company_leads (id, error_log, value, company_id) FROM stdin;
\.


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

COPY public.item_list_dncs (id, error_log, value) FROM stdin;
\.


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

COPY public.item_list_email_presets (id, error_log, value, html) FROM stdin;
\.


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

COPY public.item_list_five_docs (id, error_log, value, rep_id, provider, state, commodity, market, market_id, demand_min, demand_max, usage_min, usage_max, updated) FROM stdin;
\.


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

COPY public.item_list_five_markets (id, error_log, value, five_id) FROM stdin;
\.


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

COPY public.item_list_five_partners (id, error_log, value, five_id) FROM stdin;
\.


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

COPY public.item_list_five_rep_names (id, error_log, value, rep_id) FROM stdin;
\.


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

COPY public.item_list_orders_flowings (id, error_log, value, "row", recalc) FROM stdin;
\.


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

COPY public.item_list_serviceability_consty_acs (id, error_log, value) FROM stdin;
\.


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

COPY public.item_list_serviceability_constys (id, error_log, value) FROM stdin;
\.


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

COPY public.item_list_serviceability_scanas (id, error_log, value, pool, updated) FROM stdin;
\.


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

COPY public.item_list_serviceabilitys (id, error_log, value) FROM stdin;
\.


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

COPY public.item_list_sms_presets (id, error_log, value, html) FROM stdin;
\.


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

COPY public.item_list_unsubscribes (id, error_log, value, reason) FROM stdin;
\.


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

COPY public.item_lists (id, error_log, value) FROM stdin;
\.


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

COPY public.item_location_commercial_usas (id, error_log, address_1, address_2, city, state, zip, location_code, company_name, monthly_bill, fein, monthly_usage, dba, title, credit_type, sq_ft, biz_type, load_factor, start_date, market_id, mills, five_partner_name, is_five, load_zone) FROM stdin;
\.


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

COPY public.item_location_postal_usas (id, error_log, address_1, address_2, city, state, zip, location_code) FROM stdin;
1623169087526874832		19102 CHALLE CIR E		SPRING	TX	77373	19102 CHALLE CIR E~SPRING~TX~77373~TX
1623165712112993646		19102 CHALLE CIR E		SPRING	TX	77373	19102 CHALLE CIR E~SPRING~TX~77373~TX
1623168961733199495		19102 CHALLE CIR E		SPRING	TX	77373	19102 CHALLE CIR E~SPRING~TX~77373~TX
1623103078194959729		19102 CHALLE CIR E		SPRING	TX	77373	19102 CHALLE CIR E~SPRING~TX~77373~TX
1623169038014399495		19102 CHALLE CIR E		SPRING	TX	77373	19102 CHALLE CIR E~SPRING~TX~77373~TX
1623169180881674832		19102 CHALLE CIR E		SPRING	TX	77373	19102 CHALLE CIR E~SPRING~TX~77373~TX
1623171575616210148		19102 CHALLE CIR E		SPRING	TX	77373	19102 CHALLE CIR E~SPRING~TX~77373~TX
\.


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

COPY public.item_location_postals (id, error_log, address_1, address_2, city, state, zip, location_code) FROM stdin;
\.


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

COPY public.item_location_previous_usas (id, error_log, address_1, address_2, city, state, zip, location_code, previous_time, previous_val) FROM stdin;
\.


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

COPY public.item_location_previouss (id, error_log, address_1, address_2, city, state, zip, location_code) FROM stdin;
\.


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

COPY public.item_location_solar_usas (id, error_log, address_1, address_2, city, state, zip, location_code, ownership) FROM stdin;
\.


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

COPY public.item_location_utility_californias (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date, meter_number, utility_account_number) FROM stdin;
\.


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

COPY public.item_location_utility_connecticuts (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date, utility_account_number, name_key, service_reference_number, pod_id) FROM stdin;
\.


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

COPY public.item_location_utility_dcs (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date, utility_account_number) FROM stdin;
\.


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

COPY public.item_location_utility_delawares (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date, authorization_id) FROM stdin;
\.


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

COPY public.item_location_utility_georgias (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date, meter_number, tdsp) FROM stdin;
\.


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

COPY public.item_location_utility_illinoiss (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date, meter_number, utility_account_number) FROM stdin;
\.


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

COPY public.item_location_utility_indianas (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date, meter_number, utility_account_number) FROM stdin;
\.


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

COPY public.item_location_utility_marylands (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date, choice_id, utility_account_number, service_number, customer_number) FROM stdin;
\.


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

COPY public.item_location_utility_massachusettss (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date, utility_account_number, name_key, meter_number, service_reference_number) FROM stdin;
\.


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

COPY public.item_location_utility_michigans (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date, utility_account_number, meter_number, pod_id) FROM stdin;
\.


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

COPY public.item_location_utility_newhampshires (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date) FROM stdin;
\.


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

COPY public.item_location_utility_newjerseys (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date, utility_account_number, service_number, customer_number, service_agreement_id) FROM stdin;
\.


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

COPY public.item_location_utility_newyorks (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date, utility_account_number) FROM stdin;
\.


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

COPY public.item_location_utility_ohios (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date, utility_account_number, service_delivery_id, customer_number) FROM stdin;
\.


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

COPY public.item_location_utility_pennsylvanias (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date, utility_account_number) FROM stdin;
\.


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

COPY public.item_location_utility_rhodeislands (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date) FROM stdin;
\.


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

COPY public.item_location_utility_texass (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date, esiid, tdsp) FROM stdin;
1623171575616610148		19102 CHALLE CIRCLE EAST		SPRING	TX	77373	19102 CHALLE CIRCLE EAST~SPRING~TX~77373~TX	1008901016546994200100					3	\N	1008901016546994200100	\N
1623169087527274832		19102 CHALLE CIRCLE EAST		SPRING	TX	77373	19102 CHALLE CIRCLE EAST~SPRING~TX~77373~TX	1008901016546994200100					3	\N	1008901016546994200100	\N
1623168961733599495		19102 CHALLE CIRCLE EAST		SPRING	TX	77373	19102 CHALLE CIRCLE EAST~SPRING~TX~77373~TX	1008901016546994200100					3	\N	1008901016546994200100	\N
1623169180882074832		19102 CHALLE CIRCLE EAST		SPRING	TX	77373	19102 CHALLE CIRCLE EAST~SPRING~TX~77373~TX	1008901016546994200100					3	\N	1008901016546994200100	\N
1623169038014799495		19102 CHALLE CIRCLE EAST		SPRING	TX	77373	19102 CHALLE CIRCLE EAST~SPRING~TX~77373~TX	1008901016546994200100					3	\N	1008901016546994200100	\N
1623103078200859729		19102 CHALLE CIRCLE EAST		SPRING	TX	77373	19102 CHALLE CIRCLE EAST~SPRING~TX~77373~TX	1008901016546994200100					3	\N	1008901016546994200100	\N
1623165712118593646	2021-06-08 10:22:34~api~<br>The plan you selected was for Oncor (Dallas/FW Metro) but your meter is serviced by Centerpoint (Houston).\n\t\t\t\t\t\t\t\t  <br><br>We have updated your order with the correct plan and rate for Centerpoint (Houston).\n\t\t\t\t\t\t\t\t  <br><br>Your Oncor (Dallas/FW Metro) rate of 11.2&cent; is not the same as your Centerpoint (Houston) rate of 11.3&cent;, check your <a target='_blank' href='/plan-documents/terrific-12-efl-cnp.pdf'>Electricity Facts Label</a> for details or <a href='https://devlando.getpounceenergy.com/electricity-rates/zip/77373/Spring'>click here</a> to view other Centerpoint (Houston) plans.<br><br> To order this plan in the Centerpoint (Houston) area, ignore this message and continue below.<pre style="display:none;">#0  Ter_model->addError() called at [/var/www/public_html/base/application/models/ItemLocationUtility_model.php:501]<br />#1  ItemLocationUtility_model->validateZipTdsp() called at [/var/www/public_html/base/application/models/ItemLocationUtility_model.php:265]<br />#2  ItemLocationUtility_model->validate() called at [/var/www/public_html/base/application/models/ItemLocationUtilityTexas_model.php:158]<br />#3  ItemLocationUtilityTexas_model->validate() called at [/var/www/public_html/base/application/models/TicketCart_model.php:954]<br />#4  TicketCart_model->validateAll() called at [/var/www/public_html/cart/application/controllers/Checkout.php:363]<br />#5  Checkout->submit() called at [/var/www/public_html/base/system/core/CodeIgniter.php:514]<br />#6  require_once(/var/www/public_html/base/system/core/CodeIgniter.php) called at [/var/www/public_html/cart/index.php:316]<br /></pre>	19102 CHALLE CIRCLE EAST		SPRING	TX	77373	19102 CHALLE CIRCLE EAST~SPRING~TX~77373~TX	1008901016546994200100					3	\N	1008901016546994200100	\N
\.


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

COPY public.item_location_utilitys (id, error_log, address_1, address_2, city, state, zip, location_code, uan1, uan2, uan3, uan4, uan5, market_id, start_date) FROM stdin;
\.


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

COPY public.item_locations (id, error_log, address_1, address_2, city, state, zip, location_code) FROM stdin;
\.


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

COPY public.item_myaccount_usages (id, error_log, start_date, end_date, amount, cost, estimate, period, commodity, month) FROM stdin;
\.


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

COPY public.item_myaccounts (id, error_log) FROM stdin;
\.


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

COPY public.item_notes (id, error_log, user_id, username, note) FROM stdin;
1623107250325060879		0	Outbound Email	Template : confirmation
1623165772285574833		0	Outbound Email	Template : confirmation
1623168995531074832		0	Outbound Email	Template : confirmation
1623169042780296400		0	Outbound Email	Template : confirmation
1623169196626010028		0	Outbound Email	Template : confirmation
\.


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

COPY public.item_partner_energytexas_brand_energytexas_cas (id, error_log, rep_id) FROM stdin;
\.


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

COPY public.item_partner_energytexas_brand_energytexas_cts (id, error_log, rep_id) FROM stdin;
\.


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

COPY public.item_partner_energytexas_brand_energytexas_gas (id, error_log, rep_id) FROM stdin;
\.


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

COPY public.item_partner_energytexas_brand_energytexas_ils (id, error_log, rep_id) FROM stdin;
\.


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

COPY public.item_partner_energytexas_brand_energytexas_mas (id, error_log, rep_id) FROM stdin;
\.


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

COPY public.item_partner_energytexas_brand_energytexas_mds (id, error_log, rep_id) FROM stdin;
\.


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

COPY public.item_partner_energytexas_brand_energytexas_mis (id, error_log, rep_id) FROM stdin;
\.


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

COPY public.item_partner_energytexas_brand_energytexas_nhs (id, error_log, rep_id) FROM stdin;
\.


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

COPY public.item_partner_energytexas_brand_energytexas_njs (id, error_log, rep_id) FROM stdin;
\.


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

COPY public.item_partner_energytexas_brand_energytexas_nys (id, error_log, rep_id) FROM stdin;
\.


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

COPY public.item_partner_energytexas_brand_energytexas_ohs (id, error_log, rep_id) FROM stdin;
\.


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

COPY public.item_partner_energytexas_brand_energytexas_pas (id, error_log, rep_id) FROM stdin;
\.


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

COPY public.item_partner_energytexas_brand_energytexas_ris (id, error_log, rep_id) FROM stdin;
\.


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

COPY public.item_partner_energytexas_brand_energytexas_txs (id, error_log, rep_id) FROM stdin;
1623171575616510148		1
1623169180881974832		1
1623168961733499495		1
1623169038014699495		1
1623103078198559729		1
1623169087527174832		1
1623165712116493646		1
\.


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

COPY public.item_partner_energytexas_brand_energytexass (id, error_log, rep_id) FROM stdin;
\.


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

COPY public.item_partner_energytexass (id, error_log, rep_id) FROM stdin;
\.


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

COPY public.item_partners (id, error_log, rep_id) FROM stdin;
\.


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

COPY public.item_payaccounts (id, error_log) FROM stdin;
\.


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

COPY public.item_person_customers (id, error_log, first_name, last_name, email, phone_1, phone_2, lang, ssn, communication_method, sms) FROM stdin;
\.


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

COPY public.item_person_shopper_commercials (id, error_log, first_name, last_name, email, phone_1, phone_2, lang, ssn, communication_method, sms, lando_session, ter_username, ter_password, credit_level, birthdate, dl_state, dl_number, partner_person_id, birthdate_day, birthdate_month, birthdate_year, timezone_offset, ip, site_id, fax, visitor_session_id, customer_name, allow_marketing, company_name, monthly_bill) FROM stdin;
\.


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

COPY public.item_person_shoppers_old (id, error_log, first_name, last_name, email, phone_1, phone_2, lang, ssn, communication_method, sms, lando_session, ter_username, ter_password, credit_level, birthdate, dl_state, dl_number, partner_person_id, birthdate_day, birthdate_month, birthdate_year, timezone_offset, ip, site_id, fax, visitor_session_id, customer_name, allow_marketing, cleaned, ticket_cleaned) FROM stdin;
\.


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

COPY public.item_persons (id, error_log, first_name, last_name, email, phone_1, phone_2, lang, ssn, communication_method, sms) FROM stdin;
\.


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

COPY public.item_rekeys (old_item_id, new_item_id) FROM stdin;
\.


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

COPY public.item_review_calls (id, error_log, agent_id, company_id, reviewing_agent_id, tier_one_score, tier_two_score, tier_three_score, overall_score, pass_fail, tpv_pass_fail) FROM stdin;
\.


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

COPY public.item_review_company_usas (id, error_log, title, location, body, author, url, rating_criteria_id1, rating_score1, rating_criteria_id2, rating_score2, rating_criteria_id3, rating_score3, rating_criteria_id4, rating_score4, rating_criteria_id5, rating_score5, ctime, rep_comment, rep_comment_time, rep_comment_user_id, rep_comment_author, rep_id, site_id, visitor_ip, useful, notuseful, username, email, state, product, rating_overall, approve, rating_plans, rating_billing, rating_order_experience, rating_customer_service, rating_recommend, our_comment, customer_comment, customer_comment_time, show_email, duplicate) FROM stdin;
\.


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

COPY public.item_review_companys (id, error_log) FROM stdin;
\.


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

COPY public.item_reviews (id, error_log) FROM stdin;
\.


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

COPY public.item_sms_autoreplys (id, error_log, sms, fingerprint, template, username) FROM stdin;
\.


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

COPY public.item_sms_customs (id, error_log, sms, fingerprint, template, username, custom_text) FROM stdin;
\.


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

COPY public.item_sms_docusigns (id, error_log, sms, fingerprint, template, username) FROM stdin;
\.


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

COPY public.item_sms_hold_orders (id, error_log, sms, fingerprint, template, username) FROM stdin;
\.


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

COPY public.item_sms_order_by_text_completes (id, error_log, sms, fingerprint, template, username) FROM stdin;
\.


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

COPY public.item_sms_order_by_text_sents (id, error_log, sms, fingerprint, template, username) FROM stdin;
\.


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

COPY public.item_sms_partial_carts (id, error_log, sms, fingerprint, template, username) FROM stdin;
\.


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

COPY public.item_sms_prepared_carts (id, error_log, sms, fingerprint, template, username) FROM stdin;
\.


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

COPY public.item_smss (id, error_log, sms, fingerprint, template, username) FROM stdin;
\.


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

COPY public.item_survey_answer_multiples (id, error_log, name, description, selected, title) FROM stdin;
\.


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

COPY public.item_survey_answer_plandetails (id, error_log, name, description, selected, title, value) FROM stdin;
\.


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

COPY public.item_survey_answer_textareas (id, error_log, name, description, selected, title, value) FROM stdin;
\.


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

COPY public.item_survey_answer_texts (id, error_log, name, description, selected, title, value) FROM stdin;
\.


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

COPY public.item_survey_answers (id, error_log, name, description, selected, title) FROM stdin;
\.


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

COPY public.item_tpv_prepareds (id, error_log) FROM stdin;
\.


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

COPY public.item_tpv_trusteds (id, error_log, confirmation_number, json) FROM stdin;
\.


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

COPY public.item_tpvs (id, error_log) FROM stdin;
\.


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

COPY public.item_values (id, item_id, item_model, "values") FROM stdin;
\.


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

COPY public.items (id, error_log) FROM stdin;
\.


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

COPY public.junk (order_id_seq) FROM stdin;
\.


--
-- Data for Name: kpi_numbers; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.kpi_numbers (id, rep_id, period, row_type, submit, accept, paid, value, as_of, state) FROM stdin;
\.


--
-- Data for Name: kpi_numbers_daily; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.kpi_numbers_daily (id, rep_id, period, row_type, submit, accept, paid, value, as_of, state) FROM stdin;
\.


--
-- Data for Name: kpi_values; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.kpi_values (id, name, value, effective_date, state, value_text) FROM stdin;
\.


--
-- Data for Name: kw_action_compare; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.kw_action_compare (id, action_compare) FROM stdin;
\.


--
-- Data for Name: kw_action_switch; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.kw_action_switch (id, action_switch) FROM stdin;
\.


--
-- Data for Name: kw_energy_name; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.kw_energy_name (id, energy_type) FROM stdin;
\.


--
-- Data for Name: kw_provider; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.kw_provider (id, key_word) FROM stdin;
\.


--
-- Data for Name: kw_rates_prices; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.kw_rates_prices (id, price) FROM stdin;
\.


--
-- Data for Name: kw_reviews; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.kw_reviews (id, kw_reviews) FROM stdin;
\.


--
-- Data for Name: kw_utility; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.kw_utility (id, utility) FROM stdin;
\.


--
-- Data for Name: kw_value; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.kw_value (id, kw_value) FROM stdin;
\.


--
-- Data for Name: langs; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.langs (id, app, key, en, es) FROM stdin;
\.


--
-- Data for Name: more_info_clicks; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.more_info_clicks (id, vid, site_id, rep_id, plan_id, market_id, ctime) FROM stdin;
\.


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

COPY public.order_ids (id, ticket_id) FROM stdin;
\.


--
-- Data for Name: page_update_log; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.page_update_log (id, page_id, name, url, description, created) FROM stdin;
\.


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

COPY public.phone_calls (id, campaign, call_type, agent, agent_name, disposition, ani, customer_name, dnis, call_time, bill_time, ivr_time, queue_time, ring_time, talk_time, hold_time, park_time, after_call_time, cost, transfers, conferences, holds, abandons, recordings, created, call_id) FROM stdin;
\.


--
-- Data for Name: plan_click_summary; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.plan_click_summary (id, site_id, week_start, week_end, clicks, flux_clicks, resolved_clicks, orders, flux_orders, resolved_orders, pending, flowing, outbox, cancelled, complete, visitors, spend, created, modified) FROM stdin;
\.


--
-- Data for Name: plan_clicks; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.plan_clicks (id, market_id, plan_id, ctime, vid, click_type, page, section, section_filter, item_index, guid, site_id, ticket_id) FROM stdin;
\.


--
-- Data for Name: plan_features; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.plan_features (id, name, image) FROM stdin;
\.


--
-- Data for Name: plan_group_log; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.plan_group_log (id, name, plan_id, sort_order, started, ended) FROM stdin;
\.


--
-- Data for Name: plan_groups; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.plan_groups (id, name, description, plan_id, sort_order, created, modified) FROM stdin;
\.


--
-- Data for Name: plan_market_charges; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.plan_market_charges (id, rep_id, plan_id, market_id, plan_market_id, commodity, charge_type, charge_per, charge_source, start_units, end_units, charge_amt, offset_units, cap_units, is_efl, manual) FROM stdin;
\.


--
-- Data for Name: plan_market_schedules; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.plan_market_schedules (id, plan_market_id, rep_id, plan_id, market_id, effective, rate_elec_2000, rate_elec_1000, rate_elec_500, rate_gas, efl_url) FROM stdin;
\.


--
-- Data for Name: plan_markets; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.plan_markets (id, plan_id, market_id, rate, roll_off_rate, efl_url, login_page_url, plan_page_url, ctime, mtime, partner_product_id, partner_plan_id, partner_utility_name, partner_raw_data, tdu_customer_charge, tdu_delivery_charge, energy_charge, rate_elec, rate_gas, rate_gas_therm, rate_gas_ccf, rate_gas_mcf, partner_rate_id, rate_elec_2000, rate_elec_1000, rate_elec_500, legal_script, rate_summer, rate_winter, rate_promo, rate_promo_months, rate_after_promo, rate_daily, updated, calc_rate_elec_500, calc_rate_elec_1000, calc_rate_elec_2000, calc_rate_gas, avg_rate_elec_500, avg_rate_elec_1000, avg_rate_elec_2000, avg_rate_gas) FROM stdin;
\.


--
-- Data for Name: plan_markets_historical; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.plan_markets_historical (id, plan_id, market_id, rate_gas, rate_elec_2000, rate_elec_1000, rate_elec_500, old_rate_gas, old_rate_elec_2000, old_rate_elec_1000, old_rate_elec_500, start_date, end_date, rate_change_notified) FROM stdin;
\.


--
-- Data for Name: plan_markets_snapshot; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.plan_markets_snapshot (id, plan_id, market_id, rate, roll_off_rate, efl_url, login_page_url, plan_page_url, ctime, mtime, partner_product_id, partner_plan_id, partner_utility_name, partner_raw_data, tdu_customer_charge, tdu_delivery_charge, energy_charge, rate_elec, rate_gas, rate_gas_therm, rate_gas_ccf, rate_gas_mcf, partner_rate_id, rate_elec_2000, rate_elec_1000, rate_elec_500, legal_script, rate_summer, rate_winter, rate_promo, rate_promo_months, rate_after_promo, rate_daily, updated, calc_rate_elec_500, calc_rate_elec_1000, calc_rate_elec_2000, calc_rate_gas, avg_rate_elec_500, avg_rate_elec_1000, avg_rate_elec_2000, avg_rate_gas) FROM stdin;
\.


--
-- Data for Name: plan_markets_tx; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.plan_markets_tx (id, rep_id, plan_id, market_id, plan_market_id, rate_elec_50, rate_elec_100, rate_elec_150, rate_elec_200, rate_elec_250, rate_elec_300, rate_elec_350, rate_elec_400, rate_elec_450, rate_elec_500, rate_elec_550, rate_elec_600, rate_elec_650, rate_elec_700, rate_elec_750, rate_elec_800, rate_elec_850, rate_elec_900, rate_elec_950, rate_elec_1000, rate_elec_1050, rate_elec_1100, rate_elec_1150, rate_elec_1200, rate_elec_1250, rate_elec_1300, rate_elec_1350, rate_elec_1400, rate_elec_1450, rate_elec_1500, rate_elec_1550, rate_elec_1600, rate_elec_1650, rate_elec_1700, rate_elec_1750, rate_elec_1800, rate_elec_1850, rate_elec_1900, rate_elec_1950, rate_elec_2000, rate_elec_2050, rate_elec_2100, rate_elec_2150, rate_elec_2200, rate_elec_2250, rate_elec_2300, rate_elec_2350, rate_elec_2400, rate_elec_2450, rate_elec_2500, rate_elec_2550, rate_elec_2600, rate_elec_2650, rate_elec_2700, rate_elec_2750, rate_elec_2800, rate_elec_2850, rate_elec_2900, rate_elec_2950, rate_elec_3000, created, modified) FROM stdin;
\.


--
-- Data for Name: plan_views; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.plan_views (id, visitor_id, plan_id, uri, ctime, vid, site_id) FROM stdin;
\.


--
-- Data for Name: plans; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.plans (id, rep_id, name, ptc_name, ptc_energy_type, term, energy_type, renewable, prepaid, cancellation_fee, ave_cost, description, html_title, meta_desc, meta_key, page_title, address_box_title, pricegrid_tag_line, login_page_url, sort_order, slug, plan_page_url, css_class, recommended, lock, status, ctime, mtime, old_plan_id, monthly_recurring_charge, terms_and_conditions_url, partner_plan_key, promo_img, promo_tip, special_terms, minutia, plan_pricing_code, commodity, state, clicks_per_kviews, view_value, floater_description, deposits, house_size, legal_script, value_rewards, value_promos, friend_usp, friend_simple, friend_bighouse, friend_mediumhouse, friend_smallhouse, friend_rewards, friend_promos, friend_deposits, updated, partner_description, promo_smarthome, promo_freepower, promo_rewards, promo_greenpct, from_scrape, daily_recurring_charge, our_opinion, customer_type, min_balance, exclusive, mills, site_id, upfront_adder) FROM stdin;
\.


--
-- Data for Name: plans_snapshot; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.plans_snapshot (id, rep_id, name, ptc_name, ptc_energy_type, term, energy_type, renewable, prepaid, cancellation_fee, ave_cost, description, html_title, meta_desc, meta_key, page_title, address_box_title, pricegrid_tag_line, login_page_url, sort_order, slug, plan_page_url, css_class, recommended, lock, status, ctime, mtime, old_plan_id, monthly_recurring_charge, terms_and_conditions_url, partner_plan_key, promo_img, promo_tip, special_terms, minutia, plan_pricing_code, commodity, state, clicks_per_kviews, view_value, floater_description, deposits, house_size, legal_script, value_rewards, value_promos, friend_usp, friend_simple, friend_bighouse, friend_mediumhouse, friend_smallhouse, friend_rewards, friend_promos, friend_deposits, updated, partner_description, promo_smarthome, promo_freepower, promo_rewards, promo_greenpct, from_scrape, daily_recurring_charge, our_opinion, customer_type, min_balance, exclusive, mills, site_id, upfront_adder) FROM stdin;
\.


--
-- Data for Name: plugin_users; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.plugin_users (id, name, email, phone, domain, api_key, hits, status, created, modified) FROM stdin;
\.


--
-- Data for Name: price_to_compare; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.price_to_compare (id, tdsp, rate_start, rate_end, rate) FROM stdin;
\.


--
-- Data for Name: ptc_data; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.ptc_data (id, tdsp, zip, rep_company_name, tdu_company_name, rep_company, product, kwh500, kwh1000, kwh2000, kwh500_per_month, kwh1000_per_month, kwh2000_per_month, prepaid, prepaid_url, fixed, rate_type, renewable, term_type_key, term_type_desc, term_value, term_type, cancel_type_key, cancel_type_desc, cancel_type, website, special_terms, terms_url, facts_url, promotion, promotion_desc, ctime) FROM stdin;
\.


--
-- Data for Name: ptc_stats; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.ptc_stats (id, n_plans, n_updated, n_new, n_new_reps, ctime) FROM stdin;
\.


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

COPY public.puc_reps (id, state, rep_scrape_id) FROM stdin;
\.


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

COPY public.queue_agent_production_highs (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_agent_production_lows (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_agent_production_meds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_agent_productions (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_agent_standing_as (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_agent_standing_bs (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_agent_standing_cs (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_agent_standing_ds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_agent_standing_fs (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_agent_standings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_agents (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_books (id, ticket_id, reason, rep_id) FROM stdin;
\.


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

COPY public.queue_call_cancelleds (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queue_call_fulfilleds (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queue_call_saveds (id, ticket_id, reason, user_id, phone, zip, market, commodity) FROM stdin;
\.


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

COPY public.queue_call_starts (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queue_calls (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queue_cart_abandons (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_accepteds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_actives (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_archives (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_autopay_requireds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_balancedues (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_deads (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_deposits (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_dualfuels (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fraudpotentials (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_cancelleds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_churneds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_deposits (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_docusigns (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_flowings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_holds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_outbox_holds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_outboxs (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_rejected_autopays (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_rejected_errors (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_rejected_existings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_rejected_plans (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_rejected_switchholds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_rejected_uans (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_rejecteds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_tpv_completes (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_tpv_faileds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_tpv_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilled_tpv_reviews (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_fulfilleds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_nodeposits (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_prepared_clickeds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_prepareds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_starts (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_status_reviews (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_submits (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_switchholds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_systemdowns (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_text_cancelleds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_text_completeds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_text_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_text_respondeds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_texts (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cart_writeoffs (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_carts (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cost_bankeds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cost_casheds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cost_helds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cost_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cost_removeds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_cost_sents (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_costs (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_counts_daily (table_name, as_of, net, ins, outs) FROM stdin;
\.


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

COPY public.queue_lead_abandoneds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_lead_accepteds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_lead_cancelleds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_lead_completes (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_lead_contract_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_lead_quote_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_lead_quote_requireds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_lead_rate_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_lead_rate_receiveds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_lead_rejecteds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_leads (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_ledger_archives (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_ledger_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_ledger_sents (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_ledgers (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_meeting_archiveds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_meeting_completeds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_meeting_followups (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_meeting_initiates (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_meeting_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_meetings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_myaccount_hiddens (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_myaccount_raf_dues (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_myaccount_raf_earneds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_myaccount_raf_paids (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_myaccount_raf_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_myaccount_rafs (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_myaccounts (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_ops (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_ops_contact_faileds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_ops_contact_inbounds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_ops_contact_initiates (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_ops_contact_reacheds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_ops_contact_requireds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_ops_contacts (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_ops_data_entrys (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_review_approveds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_review_call_archives (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_review_call_assigneds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_review_call_completeds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_review_call_faileds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_review_call_passeds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_review_call_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_review_calls (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_review_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_review_rejecteds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_reviews (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_summary (table_name, records, updated) FROM stdin;
queue_cart_fulfilled_rejected_switchholds	1298	y
queue_cart_fulfilled_tpv_completes	2	y
queue_cart_fulfilled_tpv_pendings	15	y
queue_cart_fulfilled_tpv_reviews	3	y
queue_cart_prepared_clickeds	6	y
queue_cart_prepareds	1175	y
queue_cart_starts	91778	y
queue_cart_submits	2911	y
queue_cart_switchholds	961	y
queue_cart_systemdowns	196	y
queue_cart_text_cancelleds	1633	y
queue_cart_text_pendings	163	y
queue_cart_text_respondeds	143	y
queue_cart_writeoffs	134538	y
queue_cost_bankeds	1	y
queue_cost_casheds	47	y
queue_cost_helds	7	y
queue_cost_pendings	25	y
queue_cost_removeds	2	y
queue_cost_sents	37	y
queue_lead_accepteds	7	y
queue_lead_cancelleds	271	y
queue_lead_completes	41	y
queue_lead_contract_pendings	821	y
queue_lead_quote_pendings	2225	y
queue_lead_quote_requireds	90	y
queue_lead_rate_pendings	1	y
queue_lead_rate_receiveds	2	y
queue_ledger_sents	740	y
queue_myaccount_hiddens	384	y
queue_myaccount_raf_dues	2	y
queue_myaccount_raf_paids	11	y
queue_myaccount_raf_pendings	4	y
queue_ops_contact_inbounds	829	y
queue_ops_contact_initiates	1089	y
queue_ops_contact_reacheds	247070	y
queue_ops_contact_requireds	3183	y
queue_ops_data_entrys	67	y
queue_review_approveds	11996	y
queue_review_call_pendings	132	y
queue_review_pendings	167	y
queue_review_rejecteds	4636	y
queue_upload_orders_sents	661	y
queue_cart_fulfilled_rejected_uans	92	y
queue_cart_fulfilled_rejected_errors	19	y
queue_books	43159	y
queue_call_cancelleds	16	y
queue_call_fulfilleds	11767	y
queue_call_saveds	2	y
queue_call_starts	28401	y
queue_cart_abandons	570831	y
queue_cart_accepteds	9459	y
queue_cart_actives	35470	y
queue_cart_autopay_requireds	90	y
queue_cart_balancedues	943	y
queue_cart_deads	4240	y
queue_cart_deposits	13216	y
queue_cart_dualfuels	6	y
queue_cart_fraudpotentials	14648	y
queue_cart_fulfilleds	204	y
queue_cart_fulfilled_cancelleds	98918	y
queue_cart_fulfilled_churneds	63812	y
queue_cart_fulfilled_deposits	10952	y
queue_cart_fulfilled_docusigns	79	y
queue_cart_fulfilled_flowings	67109	y
queue_cart_fulfilled_holds	186	y
queue_cart_fulfilled_outboxs	162	y
queue_cart_fulfilled_outbox_holds	231	y
queue_cart_fulfilled_pendings	18272	y
queue_cart_fulfilled_rejecteds	9934	y
queue_cart_fulfilled_rejected_existings	4526	y
queue_cart_fulfilled_rejected_plans	261	y
\.


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

COPY public.queue_upload_order_sents (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_upload_orders (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_upload_orders_sents (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queue_uploads (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_production_highs (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_production_highs_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_production_highs_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_production_lows (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_production_lows_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_production_lows_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_production_meds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_production_meds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_production_meds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_productions (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_productions_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_productions_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standing_as (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standing_as_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standing_as_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standing_bs (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standing_bs_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standing_bs_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standing_cs (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standing_cs_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standing_cs_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standing_ds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standing_ds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standing_ds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standing_fs (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standing_fs_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standing_fs_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standings_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agent_standings_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agents (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agents_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_agents_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_books (id, ticket_id, reason, rep_id) FROM stdin;
\.


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

COPY public.queuelog_books_in (id, ticket_id, reason, rep_id) FROM stdin;
\.


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

COPY public.queuelog_books_out (id, ticket_id, reason, rep_id) FROM stdin;
\.


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

COPY public.queuelog_call_cancelleds (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queuelog_call_cancelleds_in (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queuelog_call_cancelleds_out (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queuelog_call_fulfilleds (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queuelog_call_fulfilleds_in (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queuelog_call_fulfilleds_out (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queuelog_call_saveds (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queuelog_call_saveds_in (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queuelog_call_saveds_out (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queuelog_call_starts (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queuelog_call_starts_in (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queuelog_call_starts_out (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queuelog_calls (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queuelog_calls_in (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queuelog_calls_out (id, ticket_id, reason, user_id, phone) FROM stdin;
\.


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

COPY public.queuelog_cart (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_abanadons (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_abandons_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_abandons_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_accepteds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_accepteds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_accepteds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_actives (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_actives_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_actives_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_archives (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_archives_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_archives_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_autopay_requireds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_autopay_requireds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_autopay_requireds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_balancedues (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_balancedues_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_balancedues_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_deads (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_deads_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_deads_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_deposits (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_deposits_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_deposits_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_dualfuels (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_dualfuels_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_dualfuels_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fraudpotentials (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fraudpotentials_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fraudpotentials_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_cancelleds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_cancelleds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_cancelleds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_churneds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_churneds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_churneds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_churns (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_churns_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_churns_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_deposits (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_deposits_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_deposits_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_docusigns (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_docusigns_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_docusigns_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_flowings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_flowings_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_flowings_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_holds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_holds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_holds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_outbox_holds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_outbox_holds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_outbox_holds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_outboxs (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_outboxs_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_outboxs_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_pendings_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_pendings_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_autopays (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_autopays_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_autopays_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_errors (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_errors_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_errors_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_existings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_existings_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_existings_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_plans (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_plans_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_plans_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_switchholds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_switchholds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_switchholds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_uans (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_uans_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejected_uans_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejecteds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejecteds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_rejecteds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_tpv_completes (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_tpv_completes_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_tpv_completes_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_tpv_faileds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_tpv_faileds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_tpv_faileds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_tpv_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_tpv_pendings_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_tpv_pendings_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_tpv_reviews (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_tpv_reviews_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilled_tpv_reviews_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilleds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilleds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_fulfilleds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_nodeposits (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_nodeposits_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_nodeposits_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_prepared_clickeds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_prepared_clickeds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_prepared_clickeds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_prepareds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_prepareds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_prepareds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_starteds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_starteds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_starteds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_starts (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_starts_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_starts_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_status_reviews (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_status_reviews_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_status_reviews_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_submits (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_submits_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_submits_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_switchholds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_switchholds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_switchholds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_systemdowns (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_systemdowns_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_systemdowns_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_text_cancelleds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_text_cancelleds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_text_cancelleds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_text_completeds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_text_completeds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_text_completeds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_text_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_text_pendings_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_text_pendings_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_text_respondeds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_text_respondeds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_text_respondeds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_texts (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_writeoffs (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_writeoffs_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cart_writeoffs_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_commission_ars (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_commission_ars_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_commission_ars_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_commission_paids (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_commission_paids_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_commission_paids_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_commissions (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cost (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cost_bankeds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cost_bankeds_in (id, ticket_id, reason) FROM stdin;
1542145948530660136	1542145948516260136	
\.


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

COPY public.queuelog_cost_bankeds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cost_casheds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cost_casheds_in (id, ticket_id, reason) FROM stdin;
1488212557107633439	1487092044772412242	
1488896814226551320	1487626220240953797	
1488910248890011299	1488323674785751125	
1490036513095533019	1488902138234575310	
1490123927104671730	1489447701962124857	
1490645884757344088	1490198295147516289	
1491408442607322950	1490651732857359410	
1491928536913516728	1491420863811820563	
1498849578327411890	1488637510576717932	
1510755129274129242	1501619144570419888	
1510755154939529242	1501014444509610871	
1515605334502562804	1510699288077245874	
1522959200608145378	1522264553531015062	
1543435951578558315	1543247952970150324	
1543435988718961078	1540491980786016834	
1543436091031162581	1539642357912362041	
1547502655976240877	1547227220571460416	
1549039660570138063	1548447015142026183	
1549380804111722169	1548444404592326183	
1549380838445121696	1548441366327926183	
1554412635284419709	1551902553025331242	
1554412649427419709	1551308505591748020	
1559663410828161980	1553526622730521055	
1559663433808537020	1554737537928460971	
1559663459452555440	1556136929412751114	
1568056877393925758	1564517711091756475	
1568057057052226357	1565712877164148032	
1568057135911623099	1562188729692735209	
1568133252287125716	1567620873826458128	
1573764933172942941	1571164240985648700	
1582063511588282730	1576262818902256464	
1582063526808979980	1579030989196146467	
1582316385858210887	1581350536604323047	
1597245109195829220	1593715282526137800	
1606939982205822396	1601917215687718269	
1606939982620122270	1600195851738713212	
1606939982820222226	1598458956794321190	
1606939996547522326	1597260316775251842	
1610557734332821999	1607539816995218138	
1611090318215390506	1605554404504028044	
1620919270285614748	1609868018047626816	
1620919365428114996	1614363030992131773	
1620919389022814996	1619461832165122644	
1620919407823415186	1620055231536521199	
1620920046142415356	1610984528310744104	
1620920052849815356	1613160021032517086	
1620920107540115402	1614628401649581763	
\.


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

COPY public.queuelog_cost_casheds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cost_helds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cost_helds_in (id, ticket_id, reason) FROM stdin;
1487610530285333840	1487092044772412242	
1488318288536332261	1487626220240953797	
1488895284047542100	1488323674785751125	
1489438582891244130	1488902138234575310	
1570651817601343287	1570565353220165207	
1584456416699826116	1581717923747559640	
1584456421513827814	1582224058590865528	
1602014120245316222	1601916643313117043	
1602014125946116298	1597419609092349101	
1602014130945516238	1597269367575222300	
1611089301690581209	1605221512397239639	
\.


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

COPY public.queuelog_cost_helds_out (id, ticket_id, reason) FROM stdin;
1488212557098333439	1487092044772412242	
1488896814217951320	1487626220240953797	
1488910248882011299	1488323674785751125	
1490036513087733019	1488902138234575310	
\.


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

COPY public.queuelog_cost_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cost_pendings_in (id, ticket_id, reason) FROM stdin;
1486564677246426281	1486564677240326281	\N
1486997556474767700	1486997556462067700	\N
1487092044778412242	1487092044772412242	\N
1487626220250253797	1487626220240953797	
1488323674804351125	1488323674785751125	
1488637510589617932	1488637510576717932	
1488902138245175310	1488902138234575310	
1489447701976524857	1489447701962124857	
1490198295163816289	1490198295147516289	
1490651732873559410	1490651732857359410	
1491420863821720563	1491420863811820563	
1494859543059525387	1494859543041625387	
1501014444522910871	1501014444509610871	
1501619144582419888	1501619144570419888	
1510699288092745874	1510699288077245874	
1515540435399426150	1515540435384926150	
1516694766295083280	1516694766278583280	
1522264553550215062	1522264553531015062	
1524686433357441967	1524686433344541967	
1524694596254059060	1524694596246059060	
1526938141121625031	1526938140906825031	
1526942224638248131	1526942224630648131	
1526994113729947098	1526994113717647098	
1539642357927662041	1539642357912362041	
1539878333499618098	1539878333488318098	
1540491980793916834	1540491980786016834	
1543247952982450324	1543247952970150324	
1545159297956436452	1545159297947936452	
1547227220579860416	1547227220571460416	
1547233849423260416	1547233849416060416	
1548441366348026183	1548441366327926183	
1548444404603926183	1548444404592326183	
1548447015151926183	1548447015142026183	
1550608751313029114	1550608751303829114	
1551301368608848020	1551301368598148020	
1551308505599448020	1551308505591748020	
1551388488870953599	1551388488858753599	
1551719094490583650	1551719094481183650	
1551902553038831242	1551902553025331242	
1553526622744821055	1553526622730521055	
1554737537943760971	1554737537928460971	
1555348577582633246	1555348577567433246	
1556136929424151114	1556136929412751114	
1556145372162046790	1556145372154446790	
1556145426294646790	1556145426289546790	
1557258439217445060	1557258439201245060	
1559246559127532812	1559246559117732812	
1559675678750923300	1559675678742523300	
1560869659907162400	1560869659893462400	
1560875812791462400	1560875812785362400	
1561997765498754956	1561997765493454956	
1562188729706535209	1562188729692735209	
1562600453513315763	1562188729692735209	
1564517711111456475	1564517711091756475	
1565712877176648032	1565712877164148032	
1566326655116343297	1566326655100043297	
1567613164269742754	1567613164258642754	
1567620873834458128	1567620873826458128	
1568157782186545090	1568157782176345090	
1569362640940743557	1569362640931143557	
1570477194043052080	1570477194034152080	
1570565353235965207	1570565353220165207	
1571164240997748700	1571164240985648700	
1573751684717712220	1573751684706312220	
1574717570165734469	1574717570151434469	
1575391214492330580	1575391214480930580	
1576262818915956464	1576262818902256464	
1579027285671939084	1579027285654739084	
1579030989205246467	1579030989196146467	
1581350536653723047	1581350536604323047	
1581717923760059640	1581717923747559640	
1582224058606865528	1582224058590865528	
1582656208929452000	1582656208912452000	
1583943006578945922	1583943006556145922	
1585322407522141627	1585322407507141627	
1586369700684831445	1586369700668931445	
1586882412332420749	1586882412313220749	
1589380886713138521	1589380886699938521	
1590070651016234721	1590070651003934721	
1593715282540537800	1593715282526137800	
1597260316785051842	1597260316775251842	
1597269367583822300	1597269367575222300	
1597419609106549101	1597419609092349101	
1598458956809121190	1598458956794321190	
1600195851744313212	1600195851738713212	
1601916643321017043	1601916643313117043	
1601917215692918269	1601917215687718269	
1602225994104696506	1602225994096496506	
1604956202577512467	1604956202568712467	
1604956230057912467	1604956230053512467	
1605221512407539639	1605221512397239639	
1605554404512028044	1605554404504028044	
1607104390073515708	1607104390062815708	
1607539817009018138	1607539816995218138	
1608232819189235958	1608232819179535958	
1609798941791235847	1609798941783935847	
1609868018059326816	1609868018047626816	
1609868134850126816	1609868134845726816	
1610984404024144104	1610984404012344104	
1610984528315144104	1610984528310744104	
1612893140369478809	1612893140359678809	
1612893144967778809	1612893144964378809	
1613160021043117086	1613160021032517086	
1614031227236537606	1614031227225537606	
1614363031003431773	1614363030992131773	
1614628349829881763	1614628349822081763	
1614628401653781763	1614628401649581763	
1614634008188514909	1614634008182714909	
1614892949960235219	1614892949948435219	
1615881185075116641	1615881185065216641	
1617998442951326760	1617998442938126760	
1618842750293944630	1618842750282244630	
1619099948880420994	1619099948867320994	
1619461832176122644	1619461832165122644	
1620055226465321199	1620055226456521199	
1620055231540321199	1620055231536521199	
1620915014035811479	1620915014025711479	
1621275040008069662	1621275039997569662	
1621275046401369662	1621275046396869662	
1621279885678412504	1621279885672612504	
1622582056505836676	1622582056493736676	
1622583421157238000	1622583421151038000	
1622737803505830028	1622737803493530028	
\.


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

COPY public.queuelog_cost_pendings_out (id, ticket_id, reason) FROM stdin;
1487610530276733840	1487092044772412242	
1488318288528032261	1487626220240953797	
1488895284039642100	1488323674785751125	
1489438582881044130	1488902138234575310	
1490123927096671730	1489447701962124857	
1490645884748444088	1490198295147516289	
1491408442598922950	1490651732857359410	
1491928536905316728	1491420863811820563	
1498849578318211890	1488637510576717932	
1510755129263929242	1501619144570419888	
1510755154929929242	1501014444509610871	
1515605334491162804	1510699288077245874	
1518560307265851653	1516694766278583280	
1518560693037253194	1515540435384926150	
1522959200594445378	1522264553531015062	
1526321526355249060	1524694596246059060	
1526321532684765530	1524686433344541967	
1536608768182515814	1526938140906825031	
1536608829644815814	1526942224630648131	
1536608927270715814	1526994113717647098	
1543435951567958315	1543247952970150324	
1543435988712161078	1540491980786016834	
1543436091024562581	1539642357912362041	
1547499232068524469	1545159297947936452	
1547499257851830861	1539878333488318098	
1547502655968040877	1547227220571460416	
1549039660552538063	1548447015142026183	
1549380804103322169	1548444404592326183	
1549380838438921696	1548441366327926183	
1551305509073129307	1550608751303829114	
1554412635272719709	1551902553025331242	
1554412649417719709	1551308505591748020	
1559663410816361980	1553526622730521055	
1559663433800637020	1554737537928460971	
1559663459443655440	1556136929412751114	
1559770947458229821	1557258439201245060	
1559770963349737753	1559246559117732812	
1559850496707349175	1555348577567433246	
1561997744090254956	1560869659893462400	
1562600404738416948	1562188729692735209	
1562600492407816855	1559675678742523300	
1562600679289119750	1560875812785362400	
1568056877381425758	1564517711091756475	
1568057057043026357	1565712877164148032	
1568057135903323099	1562188729692735209	
1568133252271025716	1567620873826458128	
1570651817587443287	1570565353220165207	
1571066018312713496	1569362640931143557	
1571066019180910907	1570477194034152080	
1571066045690011882	1568157782176345090	
1573764933161442941	1571164240985648700	
1573839661962062954	1573751684706312220	
1576186163775828393	1574717570151434469	
1576186178794029400	1575391214480930580	
1582063511575382730	1576262818902256464	
1582063526796179980	1579030989196146467	
1582316385839510887	1581350536604323047	
1584456416683426116	1581717923747559640	
1584456421502527814	1582224058590865528	
1584456427927929006	1582656208912452000	
1584456432371429006	1583943006556145922	
1586551954229631816	1586369700668931445	
1586551958882431816	1585322407507141627	
1591736295501422101	1586882412313220749	
1591736306349819895	1589380886699938521	
1591736443550218314	1590070651003934721	
1597245109180629220	1593715282526137800	
1597422754680359223	1597260316775251842	
1602014098700816065	1601917215687718269	
1602014115342316304	1600195851738713212	
1602014115663811755	1598458956794321190	
1602014120239016222	1601916643313117043	
1602014125939916298	1597419609092349101	
1602014130939516238	1597269367575222300	
1606939923330322467	1605554404504028044	
1606939936665222438	1604956202568712467	
1606939936856622543	1602225994096496506	
1610557734317521999	1607539816995218138	
1611089301676881209	1605221512397239639	
1611090259319790510	1609798941783935847	
1611090269980688713	1608232819179535958	
1611090270246289358	1607104390062815708	
1614627209705173328	1614031227225537606	
1614627220809873328	1612893144964378809	
1614627230571771767	1610984404012344104	
1614627328728475148	1610984528310744104	
1614627332831975148	1613160021032517086	
1617385700498428623	1615881185065216641	
1617385731638628823	1614628349822081763	
1620678613769317994	1620055226456521199	
1620678619073718192	1618842750282244630	
1620919270271014748	1609868018047626816	
1620919365420714996	1614363030992131773	
1620919389014614996	1619461832165122644	
1620919407813515186	1620055231536521199	
1620920107529715402	1614628401649581763	
\.


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

COPY public.queuelog_cost_removeds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cost_removeds_in (id, ticket_id, reason) FROM stdin;
1487610860480233243	1487610860469933243	
1522959200639345378	1522959200627245378	
1559850474297356774	1559850474285756774	
1561997734807458930	1561997734795258930	
\.


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

COPY public.queuelog_cost_removeds_out (id, ticket_id, reason) FROM stdin;
1559850665382058114	1559850474285756774	
1561997771926238550	1561997734795258930	
\.


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

COPY public.queuelog_cost_sents (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_cost_sents_in (id, ticket_id, reason) FROM stdin;
1518560307279151653	1516694766278583280	
1518560693046953194	1515540435384926150	
1526321526367149060	1524694596246059060	
1526321532694765530	1524686433344541967	
1536608768190215814	1526938140906825031	
1536608829666715814	1526942224630648131	
1536608927286615814	1526994113717647098	
1551305509083129307	1550608751303829114	
1559770947476129821	1557258439201245060	
1559770963357137753	1559246559117732812	
1562600404751716948	1562188729692735209	
1562600492415616855	1559675678742523300	
1562600679297819750	1560875812785362400	
1571066018328013496	1569362640931143557	
1571066019188410907	1570477194034152080	
1571066045699111882	1568157782176345090	
1573839661978862954	1573751684706312220	
1576186163790628393	1574717570151434469	
1576186178804329400	1575391214480930580	
1584456427939129006	1582656208912452000	
1584456432380829006	1583943006556145922	
1586551954249331816	1586369700668931445	
1586551958893731816	1585322407507141627	
1591736295515422101	1586882412313220749	
1591736306356019895	1589380886699938521	
1591736443556818314	1590070651003934721	
1597422754694459223	1597260316775251842	
1602014098715816065	1601917215687718269	
1602014115348116304	1600195851738713212	
1602014115672711755	1598458956794321190	
1606939923344422467	1605554404504028044	
1606939936672322438	1604956202568712467	
1606939936865822543	1602225994096496506	
1611090259333490510	1609798941783935847	
1611090269991188713	1608232819179535958	
1611090270255789358	1607104390062815708	
1614627209719173328	1614031227225537606	
1614627220817973328	1612893144964378809	
1614627230580571767	1610984404012344104	
1614627328742375148	1610984528310744104	
1614627332840475148	1613160021032517086	
1617385700514428623	1615881185065216641	
1617385731651028823	1614628349822081763	
1620678613783117994	1620055226456521199	
1620678619082918192	1618842750282244630	
\.


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

COPY public.queuelog_cost_sents_out (id, ticket_id, reason) FROM stdin;
1562600453506315763	1562188729692735209	
1606939982189122396	1601917215687718269	
1606939982608922270	1600195851738713212	
1606939982813422226	1598458956794321190	
1606939996537022326	1597260316775251842	
1611090318201090506	1605554404504028044	
1620920046127115356	1610984528310744104	
1620920052842215356	1613160021032517086	
\.


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

COPY public.queuelog_lead_abandoneds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_abandoneds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_abandoneds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_accepteds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_accepteds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_accepteds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_cancelleds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_cancelleds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_cancelleds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_completes (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_completes_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_completes_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_contract_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_contract_pendings_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_contract_pendings_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_quote_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_quote_pendings_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_quote_pendings_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_quote_requireds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_quote_requireds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_quote_requireds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_rate_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_rate_pendings_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_rate_pendings_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_rate_receiveds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_rate_receiveds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_rate_receiveds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_rejecteds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_rejecteds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_lead_rejecteds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_leads (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ledger_archives (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ledger_archives_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ledger_archives_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ledger_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ledger_pendings_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ledger_pendings_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ledger_sents (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ledger_sents_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ledger_sents_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ledgers (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ledgers_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ledgers_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meeting_archiveds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meeting_archiveds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meeting_archiveds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meeting_completeds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meeting_completeds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meeting_completeds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meeting_followups (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meeting_followups_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meeting_followups_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meeting_initiates (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meeting_initiates_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meeting_initiates_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meeting_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meeting_pendings_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meeting_pendings_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meetings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meetings_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_meetings_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_hiddens (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_hiddens_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_hiddens_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_raf_dues (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_raf_dues_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_raf_dues_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_raf_earneds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_raf_earneds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_raf_earneds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_raf_paids (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_raf_paids_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_raf_paids_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_raf_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_raf_pendings_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_raf_pendings_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_rafs (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_rafs_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccount_rafs_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccounts (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccounts_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_myaccounts_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_contact_faileds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_contact_faileds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_contact_faileds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_contact_inbounds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_contact_inbounds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_contact_inbounds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_contact_initiates (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_contact_initiates_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_contact_initiates_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_contact_reacheds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_contact_reacheds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_contact_reacheds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_contact_requireds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_contact_requireds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_contact_requireds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_contacts (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_data_entrys (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_data_entrys_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_ops_data_entrys_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_approveds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_approveds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_approveds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_archives (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_archives_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_archives_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_assigneds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_assigneds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_assigneds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_completeds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_completeds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_completeds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_faileds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_faileds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_faileds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_passeds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_passeds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_passeds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_pendings_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_call_pendings_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_calls (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_calls_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_calls_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_pendings (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_pendings_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_pendings_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_rejecteds (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_rejecteds_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_review_rejecteds_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_reviews (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_upload_orders_sents (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_upload_orders_sents_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_upload_orders_sents_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_upload_orderss (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queuelog_uploads (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queues (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queulog_cart_actives_in (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.queulog_cart_actives_out (id, ticket_id, reason) FROM stdin;
\.


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

COPY public.quickbooks (id, vendor, state, period, booked_upfront, booked_residual, commission_upfront, commission_residual, ticket_id, modified, writeoff_upfront, writeoff_residual, extra_upfront, extra_residual, affiliate, affiliate_upfront, affiliate_residual, affiliate_paid_upfront, affiliate_paid_residual) FROM stdin;
\.


--
-- Data for Name: rating_category; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.rating_category (id, name, description) FROM stdin;
\.


--
-- Data for Name: rating_category_rating_criteria; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.rating_category_rating_criteria (id, rating_category_id, rating_criteria_id) FROM stdin;
\.


--
-- Data for Name: rating_criteria; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.rating_criteria (id, name, description, user_ratable, state) FROM stdin;
\.


--
-- Data for Name: rating_formula; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.rating_formula (id, name, description, state) FROM stdin;
\.


--
-- Data for Name: rating_formula_rating_criteria; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.rating_formula_rating_criteria (id, rating_formula_id, rating_criteria_id, weight) FROM stdin;
\.


--
-- Data for Name: ratings; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.ratings (id, item_id, rating_criteria_id, review_id, score) FROM stdin;
\.


--
-- Data for Name: recipie_data; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.recipie_data (google_sheet_id, plan_id, tx_upfront, tx_mills, tx_usage, mill_value, term, total_mills, mill_npv, renewal_pct, renewal_value, accept_value, accept_pct, submit_value, submit_pct, xsell_value, xsell_pct, cart_value, clicks_per_view, market_price, plan_price, percent_of_market, adjusted_clicks_per_view, view_value, company, desktop, mobile, rep, plan, old_sort_order, new_sort_order, friend_linkoff_phone, friend_reporting, friend_strategic, friend_tactical, friend_deep_links, friend_usp, friend_simple, friend_bighouse, friend_mediumhouse, friend_smallhouse, friend_rewards, friend_promos, friend_deposits, partner_score, overall_score, plan_clicks_yesterday, rep_clicks_yesterday, click_adjustment, customer_type) FROM stdin;
\.


--
-- Data for Name: recipies; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.recipies (start_date, end_date, google_sheet_id) FROM stdin;
\.


--
-- Data for Name: rep_blocks; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.rep_blocks (id, rep_id, name, content, created, modified) FROM stdin;
\.


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

COPY public.rep_complaints (id, rep_id, rep_scrape_id, rep_name, docket_number, status, date_filed, complaint, created, state) FROM stdin;
\.


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

COPY public.rep_complaints_current (string, rep) FROM stdin;
pem	PENNSYLVANIA ELECTRIC CO.
\.


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

COPY public.rep_complaints_summary (id, rep_id, rep_scrape_id, rep_name, year, month, customers, size_scale, billing_complaints, service_complaints, marketing_complaints, avg_temp, hdds, cdds, state, total_complaints) FROM stdin;
\.


--
-- Data for Name: rep_efls; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.rep_efls (id, rep_id, plan_id, market_id, effective_date, path, url) FROM stdin;
\.


--
-- Data for Name: rep_info; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.rep_info (id, rep_id, logo, description, contact, email, phone, addr1, addr2, city, state, zip, status) FROM stdin;
\.


--
-- Data for Name: rep_info_to_market; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.rep_info_to_market (id, rep_info_id, market_id) FROM stdin;
\.


--
-- Data for Name: rep_moneys; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.rep_moneys (id, rep_id, period, value) FROM stdin;
\.


--
-- Data for Name: rep_puc; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.rep_puc (id, rep_id, commodity, state, market_id, value) FROM stdin;
\.


--
-- Data for Name: rep_scores; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.rep_scores (id, rep_id, state, criteria_1, criteria_2, value, weight, modified) FROM stdin;
\.


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

COPY public.rep_scrapes (name, rep_id, id) FROM stdin;
\.


--
-- Data for Name: rep_states; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.rep_states (id, rep_id, state, type, status, state_value) FROM stdin;
\.


--
-- Data for Name: rep_users; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.rep_users (id, rep_id, username, password, date, f_name, l_name, job_title, email_addr, phone, disposition, account_status, accept_decline_status, decline_reason, deactivate_reason, ctime) FROM stdin;
\.


--
-- Data for Name: reps; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.reps (id, name, ptc_name, slug, model, logo, logo_big, description, old_rep_id, status, contact, email, phone, addr1, addr2, city, state, zip, credit_threshold, ctime, regulatory_identifier, yrac_url, use_cart, use_ter_phone, review_blurb, use_cart_tx, use_cart_ct, use_cart_ny, use_cart_ga, use_ter_phone_tx, phone_tx, use_ter_phone_ct, phone_ct, use_ter_phone_ny, phone_ny, use_ter_phone_ga, phone_ga, regulatory_identifier_tx, regulatory_identifier_ct, regulatory_identifier_ny, regulatory_identifier_ga, market_status, market_status_tx, market_status_ga, market_status_ct, market_status_ny, status_tx, status_ga, status_ct, status_ny, score_tx, tx_customers, score_ga, ga_customers, score_ct, ct_customers, score_ny, ny_customers, score_ma, ma_customers, market_status_ma, regulatory_identifier_ma, use_cart_ma, use_phone_ma, market_status_ca, use_linkoff, commercial_email_tx, commercial_email_ny, commercial_email_ga, commercial_email_ct, use_cart_dc, use_ter_phone_dc, phone_dc, regulatory_identifier_dc, market_status_dc, status_dc, score_dc, dc_customers, use_cart_md, use_ter_phone_md, phone_md, regulatory_identifier_md, market_status_md, status_md, score_md, md_xsell, md_customers, use_cart_nj, use_ter_phone_nj, phone_nj, regulatory_identifier_nj, market_status_nj, status_nj, score_nj, nj_customers, use_cart_oh, use_ter_phone_oh, phone_oh, regulatory_identifier_oh, market_status_oh, status_oh, score_oh, oh_customers, use_cart_nh, use_ter_phone_nh, phone_nh, regulatory_identifier_nh, market_status_nh, status_nh, score_nh, nh_customers, use_cart_il, use_ter_phone_il, phone_il, regulatory_identifier_il, market_status_il, status_il, score_il, il_customers, use_cart_pa, use_ter_phone_pa, phone_pa, regulatory_identifier_pa, market_status_pa, status_pa, score_pa, pa_customers, status_ma, tx_mills, tx_upfront, tx_usage, tx_renewal, tx_accept, tx_xsell, tx_submit, pa_mills, pa_upfront, pa_usage, pa_renewal, pa_submit, pa_accept, pa_xsell, commercial_email_pa, nj_mills, nj_upfront, nj_usage, nj_renewal, nj_submit, nj_accept, nj_xsell, commercial_email_nj, use_ter_phone_ma, phone_ma, ma_mills, ma_upfront, ma_usage, ma_renewal, ma_submit, ma_accept, ma_xsell, commercial_email_ma, il_mills, il_upfront, il_usage, il_renewal, il_submit, il_accept, il_xsell, commercial_email_il, oh_mills, oh_upfront, oh_usage, oh_renewal, oh_submit, oh_accept, oh_xsell, commercial_email_oh, use_cart_de, use_ter_phone_de, phone_de, regulatory_identifier_de, market_status_de, status_de, score_de, de_customers, de_mills, de_upfront, de_usage, de_renewal, de_submit, de_accept, de_doc1, de_doc2, de_doc3, de_doc4, de_doc5, de_doc5_label, de_doc4_label, de_doc3_label, de_doc2_label, de_doc1_label, commercial_email_de, md_mills, md_upfront, md_usage, md_renewal, md_submit, md_accept, commercial_email_md, nh_mills, nh_upfront, nh_usage, nh_renewal, nh_submit, nh_accept, nh_xsell, commercial_email_nh, dc_mills, dc_upfront, dc_usage, dc_renewal, dc_submit, dc_accept, dc_doc5, dc_doc5_label, dc_doc4, dc_doc4_label, dc_doc3, dc_doc3_label, dc_doc2, dc_doc2_label, dc_doc1, dc_doc1_label, commercial_email_dc, use_cart_ky, use_ter_phone_ky, phone_ky, regulatory_identifier_ky, market_status_ky, status_ky, score_ky, ky_mills, ky_upfront, ky_usage, ky_renewal, ky_submit, ky_accept, commercial_email_ky, use_cart_mi, use_ter_phone_mi, phone_mi, regulatory_identifier_mi, market_status_mi, status_mi, score_mi, mi_customers, mi_mills, mi_upfront, mi_usage, mi_renewal, mi_submit, mi_accept, mi_xsell, commercial_email_mi, use_cart_me, use_ter_phone_me, phone_me, regulatory_identifier_me, market_status_me, status_me, score_me, me_customers, me_mills, me_upfront, me_usage, me_renewal, me_submit, me_accept, me_xsell, commercial_email_me, use_cart_in, use_ter_phone_in, phone_in, regulatory_identifier_in, market_status_in, status_in, score_in, in_mills, in_upfront, in_usage, in_renewal, in_submit, in_accept, commercial_email_in, use_cart_ri, use_ter_phone_ri, phone_ri, regulatory_identifier_ri, market_status_ri, status_ri, score_ri, ri_customers, ri_mills, ri_upfront, ri_usage, ri_renewal, ri_submit, ri_accept, ri_xsell, commercial_email_ri, use_cart_ca, use_ter_phone_ca, phone_ca, regulatory_identifier_ca, status_ca, score_ca, ca_customers, ca_mills, ca_upfront, ca_usage, ca_renewal, ca_submit, ca_accept, ca_xsell, commercial_email_ca, utility, friend_linkoff_phone, friend_reporting, friend_strategic, friend_tactical, friend_deep_links, site, ny_doc1, ny_doc1_label, ny_doc2, ny_doc2_label, ny_doc3, ny_doc3_label, ny_doc4, ny_doc4_label, ny_doc5, ny_doc5_label, tx_review_blurb, pa_review_blurb, nj_review_blurb, ma_review_blurb, il_review_blurb, oh_review_blurb, de_review_blurb, md_review_blurb, nh_review_blurb, nh_doc1, nh_doc2, nh_doc3, nh_doc4, nh_doc5, nh_doc5_label, nh_doc4_label, nh_doc3_label, nh_doc2_label, nh_doc1_label, dc_review_blurb, ky_review_blurb, mi_review_blurb, me_review_blurb, in_review_blurb, ri_review_blurb, ca_review_blurb, ct_review_blurb, ny_review_blurb, ga_review_blurb, use_cart_ab, use_ter_phone_ab, phone_ab, regulatory_identifier_ab, market_status_ab, status_ab, score_ab, ab_mills, ab_upfront, ab_usage, ab_renewal, ab_submit, ab_accept, ab_review_blurb, commercial_email_ab, ab_doc1, ab_doc1_label, pa_doc1, pa_doc2, pa_doc3, pa_doc4, pa_doc5, pa_doc5_label, pa_doc4_label, pa_doc3_label, pa_doc2_label, pa_doc1_label, ct_mills, ct_upfront, ct_usage, ct_renewal, ct_submit, ct_accept, ct_xsell, ct_doc1, ct_doc1_label, ny_mills, ny_upfront, ny_usage, ny_renewal, ny_submit, ny_accept, ny_xsell, ma_doc1_label, md_doc1, md_doc1_label, mi_doc1, mi_doc1_label, oh_doc1_label, oh_doc1, oh_doc2_label, oh_doc2, oh_doc3_label, oh_doc3, oh_doc4_label, oh_doc4, oh_doc5_label, oh_doc5, ga_mills, ga_upfront, ga_usage, ga_renewal, ga_submit, ga_accept, ga_xsell, ga_doc1_label, tx_doc1, tx_doc1_label, tx_doc2, tx_doc2_label, tx_doc3, tx_doc3_label, tx_doc4, tx_doc4_label, tx_doc5, tx_doc5_label, nj_doc1, nj_doc1_label, nj_doc2, nj_doc2_label, nj_doc3, nj_doc3_label, nj_doc4, nj_doc4_label, nj_doc5, nj_doc5_label, il_doc1, il_doc1_label, il_doc2, il_doc2_label, il_doc3, il_doc3_label, il_doc4, il_doc4_label, il_doc5, il_doc5_label, show_cis, customer_service_phone, biz_phone, biz_phone_ext, me_doc1, me_doc1_label, me_doc2, me_doc2_label, me_doc3, me_doc3_label, me_doc4, me_doc4_label, me_doc5, me_doc5_label, default_state, biz_quote_email, biz_contract_email, biz_admin_email, quickbooks_entity, green_provider, prepaid_provider, batch_email, biz_phone_tx, biz_phone_ct, biz_phone_ny, biz_phone_ga, biz_phone_dc, biz_phone_md, biz_phone_nj, biz_phone_oh, biz_phone_nh, biz_phone_il, biz_phone_pa, biz_phone_ma, biz_phone_de, biz_phone_ky, biz_phone_mi, biz_phone_me, biz_phone_in, biz_phone_ri, biz_phone_ca, biz_phone_ab) FROM stdin;
\.


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

COPY public.residual (id, rep_id, partner_name, brand_name, state_short_name, state_long_name, state, last_name, first_name, edc, esiid, account_number, usage_start, usage_end, pay_date, usage_amt, payment, period_id, pk_bill_number, customer_type, order_number, order_date, flow_date, checkout_class, upfront, backdated_upfront, residual, mills, commodity, ticket_id, item_id, term, created) FROM stdin;
\.


--
-- Data for Name: review; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.review (id, title, body, author, location, review_item_id, site_id, visitorip, ctime, useful, notuseful, approve, username, email, state, product, migrated) FROM stdin;
\.


--
-- Data for Name: review_comment; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.review_comment (id, review_id, author, ctime, body, rep_user_id) FROM stdin;
\.


--
-- Data for Name: scholarships; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.scholarships (id, reviewed_by, scholarship_name, first_name, last_name, phone, email, birthday, street, unit, city, state, zip, gpa, class_rank, school_grade, class_size, graduate_year, sat_score, critical_reading, act_score, math, writing, awards, community_service, organizations, career_goals, college_organizations, personal_essay, transcript_contents, transcript_type, transcript_name, signature, created, vid, status, confirmation_number, modified) FROM stdin;
\.


--
-- Data for Name: spinner_values; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.spinner_values (id, name, value, sort, type) FROM stdin;
\.


--
-- Data for Name: spinners; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.spinners (id, name, sequence, updated, site_id) FROM stdin;
\.


--
-- Data for Name: tdsp_fees; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.tdsp_fees (id, market_id, type, price, effective_date, created) FROM stdin;
\.


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

COPY public.ticket_batchs (id, error_log, ticket_call_id) FROM stdin;
\.


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

COPY public.ticket_batchs_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_bills (id, error_log, ticket_call_id, start_date, end_date, usage_amount, bill_amount, commodity, market_id, units) FROM stdin;
\.


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

COPY public.ticket_bills_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_carts (id, error_log, ticket_call_id, order_id_seq) FROM stdin;
1623165712102293646		0	1341948
1623171575609810148		0	1341953
1623168961726399495		0	1341949
1623169180875574832		0	1341952
1623169038009999495		0	1341950
1623103078188059729		0	1341947
1623169087523474832		0	1341951
\.


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

COPY public.ticket_carts_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_commission_upfronts (id, error_log, ticket_call_id, rep_id, period) FROM stdin;
\.


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

COPY public.ticket_commission_upfronts_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_commission_usages (id, error_log, ticket_call_id, rep_id, period) FROM stdin;
\.


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

COPY public.ticket_commission_usages_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_commissions (id, error_log, ticket_call_id, rep_id, period) FROM stdin;
\.


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

COPY public.ticket_commissions_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_contact_call_inbounds (id, error_log, ticket_call_id, disposition, disposition_page, pbx_id, pbx_call_id, pbx_did, pbx_ter_number, pbx_cust_number, pbx_agent_id, pbx_queue, pbx_username, pbx_market_id, user_id) FROM stdin;
\.


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

COPY public.ticket_contact_call_inbounds_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_contact_call_outbounds (id, error_log, ticket_call_id, disposition, disposition_page, pbx_id, pbx_call_id, pbx_did, pbx_ter_number, pbx_cust_number, pbx_agent_id, pbx_queue, pbx_username, pbx_market_id, user_id) FROM stdin;
\.


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

COPY public.ticket_contact_call_outbounds_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_contact_calls (id, error_log, ticket_call_id, disposition, disposition_page, pbx_id, pbx_call_id, pbx_did, pbx_ter_number, pbx_cust_number, pbx_agent_id, pbx_queue, pbx_username, pbx_market_id, user_id) FROM stdin;
\.


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

COPY public.ticket_contact_calls_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_contact_chat_inbounds (id, error_log, ticket_call_id, disposition, disposition_page, user_open, user_url, user_url_time, user_market_id, chat_bot_name, init_time, pop_time, input_time, close_time, respond_time) FROM stdin;
\.


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

COPY public.ticket_contact_chat_inbounds_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_contact_chat_outbounds (id, error_log, ticket_call_id, disposition, disposition_page, user_open, user_url, user_url_time, user_market_id, chat_bot_name, init_time, pop_time, input_time, close_time, respond_time) FROM stdin;
\.


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

COPY public.ticket_contact_chat_outbounds_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_contact_chats (id, error_log, ticket_call_id, disposition, disposition_page, user_open, user_url, user_url_time, user_market_id, chat_bot_name, init_time, pop_time, input_time, close_time, respond_time) FROM stdin;
1623106890258159764		0		https://devcart.getpounceenergy.com/checkout/resume/1623103078188059729	m		0	0		2021-06-07 18:00:45	2021-06-07 18:01:30	\N	\N	\N
\.


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

COPY public.ticket_contact_chats_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_contact_email_inbounds (id, error_log, ticket_call_id, disposition, disposition_page, email) FROM stdin;
\.


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

COPY public.ticket_contact_email_inbounds_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_contact_email_outbounds (id, error_log, ticket_call_id, disposition, disposition_page, email) FROM stdin;
1623107250324860879		0			developer@texaselectricityratings.com
1623165772285374833		0			developer@texaselectricityratings.com
1623168995530974832		0			developer@texaselectricityratings.com
1623169042780196400		0			developer@texaselectricityratings.com
1623169196625910028		0			developer@texaselectricityratings.com
\.


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

COPY public.ticket_contact_email_outbounds_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_contact_emails (id, error_log, ticket_call_id, disposition, disposition_page, email) FROM stdin;
\.


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

COPY public.ticket_contact_emails_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_contact_sms_inbounds (id, error_log, ticket_call_id, disposition, disposition_page, phone) FROM stdin;
\.


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

COPY public.ticket_contact_sms_inbounds_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_contact_sms_outbounds (id, error_log, ticket_call_id, disposition, disposition_page, phone) FROM stdin;
\.


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

COPY public.ticket_contact_sms_outbounds_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_contact_smss (id, error_log, ticket_call_id, disposition, disposition_page, phone) FROM stdin;
\.


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

COPY public.ticket_contact_smss_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_contacts (id, error_log, ticket_call_id, disposition, disposition_page) FROM stdin;
\.


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

COPY public.ticket_contacts_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_costs (id, error_log, ticket_call_id, amount, period, vendor_id, transaction_number, due_date) FROM stdin;
\.


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

COPY public.ticket_costs_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_credit_checks (id, error_log, ticket_call_id) FROM stdin;
\.


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

COPY public.ticket_credit_checks_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_deleteds (id, error_log, ticket_call_id) FROM stdin;
\.


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

COPY public.ticket_deleteds_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_lead_commercials (id, error_log, ticket_call_id) FROM stdin;
\.


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

COPY public.ticket_lead_commercials_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_lead_dtvs (id, error_log, ticket_call_id) FROM stdin;
\.


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

COPY public.ticket_lead_dtvs_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_lead_solars (id, error_log, ticket_call_id) FROM stdin;
\.


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

COPY public.ticket_lead_solars_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_leads (id, error_log, ticket_call_id) FROM stdin;
\.


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

COPY public.ticket_leads_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_ledgers (id, error_log, ticket_call_id, period, vendor, description, doc_number, type, entity) FROM stdin;
\.


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

COPY public.ticket_ledgers_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_locations (id, error_log, ticket_call_id, location_code, address_1, address_2, city, state, zip, uan1_e, uan2_e, uan3_e, uan4_e, uan5_e, market_id_e, uan1_g, uan2_g, uan3_g, uan4_g, uan5_g, market_id_g) FROM stdin;
\.


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

COPY public.ticket_locations_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_meetings (id, error_log, ticket_call_id, company_id, meeting_date, note, user_id) FROM stdin;
\.


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

COPY public.ticket_meetings_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_myaccounts (id, error_log, ticket_call_id, email, email_hash, password_hash, account_id_seq, current_ticket_id, current_location_id, phone, active_ticket_id, active_ticket_term_end) FROM stdin;
\.


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

COPY public.ticket_myaccounts_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_orders (inherits) FROM stdin;
\.


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

COPY public.ticket_phone_imports (id, error_log, ticket_call_id, phone) FROM stdin;
\.


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

COPY public.ticket_phone_imports_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_phones (id, error_log, ticket_call_id, phone) FROM stdin;
\.


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

COPY public.ticket_phones_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_rekeys (old_ticket_id, new_ticket_id) FROM stdin;
\.


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

COPY public.ticket_reviews (id, error_log, ticket_call_id) FROM stdin;
\.


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

COPY public.ticket_reviews_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_survey_order_completes (id, error_log, ticket_call_id, name, description, title) FROM stdin;
\.


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

COPY public.ticket_survey_order_completes_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_survey_plan_analyzers (id, error_log, ticket_call_id, name, description, title) FROM stdin;
\.


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

COPY public.ticket_survey_plan_analyzers_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_survey_plan_pickers (id, error_log, ticket_call_id, name, description, title) FROM stdin;
\.


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

COPY public.ticket_survey_plan_pickers_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_surveys (id, error_log, ticket_call_id, name, description, title) FROM stdin;
\.


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

COPY public.ticket_surveys_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_commissions (id, error_log, ticket_call_id, type, period, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_commissions_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partner_clearviews (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partner_clearviews_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partner_directs (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partner_directs_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partner_firsts (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partner_firsts_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partner_justs (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partner_justs_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partner_lifes (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partner_lifes_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partner_mercurys (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partner_mercurys_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partner_nrgs (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partner_nrgs_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partner_powerexpresss (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partner_powerexpresss_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partner_publics (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partner_publics_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partner_santannas (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partner_santannas_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partner_spark_brand_censtars (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partner_spark_brand_censtars_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partner_spark_brand_oasiss (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partner_spark_brand_oasiss_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partner_sparks (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partner_sparks_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partner_starions (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partner_starions_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partner_texpo_brand_yeps (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partner_texpo_brand_yeps_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partner_texpos (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partner_texpos_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partner_vistas (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partner_vistas_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upload_partners (id, error_log, ticket_call_id, type, rep_id) FROM stdin;
\.


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

COPY public.ticket_upload_partners_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_uploads (id, error_log, ticket_call_id, type) FROM stdin;
\.


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

COPY public.ticket_uploads_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upsell_ac_hvacs (id, error_log, ticket_call_id) FROM stdin;
\.


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

COPY public.ticket_upsell_ac_hvacs_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upsell_acs (id, error_log, ticket_call_id) FROM stdin;
\.


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

COPY public.ticket_upsell_acs_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.ticket_upsells (id, error_log, ticket_call_id) FROM stdin;
\.


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

COPY public.ticket_upsells_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


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

COPY public.tickets (id, error_log, ticket_call_id) FROM stdin;
1623165777326574833		0
1623165777479574833		0
1623171449877710161		0
\.


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

COPY public.tickets_serialized (ticket_id, data) FROM stdin;
\.


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

COPY public.tickets_to_item_archives (ticket_id, item_id, id) FROM stdin;
\.


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

COPY public.tickets_to_items (ticket_id, item_id, id, item_model) FROM stdin;
\.


--
-- Data for Name: tmp_pages_2; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.tmp_pages_2 (id, page_type_id, site_id, parent_id, template_id, slug, html_title, meta_desc, meta_key, head_content, page_title, content_primary, content_secondary, content_parent, content_auxiliary, content_mobile, pricegrid_type_id, pricegrid_more_link, pricegrid_header_title, pricegrid_plan_page_link_option, pricegrid_order_page_slug, address_box_title, default_msid, default_premise, canonical, bold_chat_rule_id, phone, web_source_id, formula_id, market_label, redirect, promo_code, symlink_of, no_index, hard_cache) FROM stdin;
\.


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

COPY public.user_logins (id, user_id, company_id, logged_in, logged_out) FROM stdin;
\.


--
-- Data for Name: utilities; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.utilities (id, name, rep_id, website, state) FROM stdin;
\.


--
-- Data for Name: visitor; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.visitor (id, ip, uri, referrer, user_agent, site_id, page_views, market_id, zip, ctime, zip4, city, state, esiid, vid, street1, street2) FROM stdin;
\.


--
-- Data for Name: visitor_msid; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.visitor_msid (id, msid_vendor, msid_state, msid_campaign, msid_group, msid_ad, vid, created, visitor_session_id, msid) FROM stdin;
\.


--
-- Data for Name: visitor_promo; Type: TABLE DATA; Schema: public; Owner: phpuser
--

COPY public.visitor_promo (id, vid, promo) FROM stdin;
\.


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

COPY public.visitor_sessions (id, ip, uri, referrer, user_agent, site_id, vid, created, modified) FROM stdin;
\.



--
-- Name: blackout_days blackout_days_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.blackout_days
    ADD CONSTRAINT blackout_days_pkey PRIMARY KEY (id);


--
-- Name: adwords_v_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX adwords_v_index ON public.adwords USING btree (v);


--
-- Name: adwords_vs_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX adwords_vs_index ON public.adwords USING btree (v, s);


--
-- Name: adwords_vsc_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX adwords_vsc_index ON public.adwords USING btree (v, s, c);


--
-- Name: adwords_vscg_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX adwords_vscg_index ON public.adwords USING btree (v, s, c, g);


--
-- Name: adwords_vscga_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX adwords_vscga_index ON public.adwords USING btree (v, s, c, g, a);


--
-- Name: alarmclocks_ticket_id_ticket_method_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX alarmclocks_ticket_id_ticket_method_index ON public.alarmclocks USING btree (ticket_id, ticket_method);


--
-- Name: cart_errors_item_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX cart_errors_item_id_index ON public.cart_errors USING btree (item_id);


--
-- Name: city_datas_city_state_key_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX city_datas_city_state_key_index ON public.city_datas USING btree (city, state, key);


--
-- Name: dirty_items_item_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX dirty_items_item_id_index ON public.dirty_items USING btree (item_id);


--
-- Name: eia_generators_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX eia_generators_id_index ON public.eia_generators USING btree (id);


--
-- Name: eia_generators_key_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX eia_generators_key_index ON public.eia_generators USING btree (key);


--
-- Name: eia_generators_state_county_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX eia_generators_state_county_index ON public.eia_generators USING btree (state, county);


--
-- Name: email_dump_email_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX email_dump_email_index ON public.email_dump USING btree (email);


--
-- Name: email_dump_site_id_email_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX email_dump_site_id_email_index ON public.email_dump USING btree (site_id, email);


--
-- Name: email_dump_site_id_exported_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX email_dump_site_id_exported_id_index ON public.email_dump USING btree (site_id, exported, id);


--
-- Name: idx_0008552785c5608051d8cdbee9a809b3; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0008552785c5608051d8cdbee9a809b3 ON public.company_role_plans USING btree (sort_order);


--
-- Name: idx_001f0b195681f9298b967c9210fd787a; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_001f0b195681f9298b967c9210fd787a ON public.queuelog_cart_text_cancelleds_out USING btree (reason);


--
-- Name: idx_0026c5e1c775c1c9d091928db0f513ca; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0026c5e1c775c1c9d091928db0f513ca ON public.item_email_depositcrosssells USING btree (dropped);


--
-- Name: idx_00384436d07ce8b0e46012c098bb8a70; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_00384436d07ce8b0e46012c098bb8a70 ON public.queuelog_cart_fulfilled_flowings_in USING btree (ticket_id);


--
-- Name: idx_00518f35435845a4844126eb1b33480d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_00518f35435845a4844126eb1b33480d ON public.queuelog_cart_fulfilled_tpv_faileds_in USING btree (ticket_id);


--
-- Name: idx_00b174b3593691d6c7484881eeb9436d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_00b174b3593691d6c7484881eeb9436d ON public.item_location_utility_massachusettss USING btree (name_key);


--
-- Name: idx_00e43381b081698e75c5ba371e9753da; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_00e43381b081698e75c5ba371e9753da ON public.queuelog_cart_fulfilled_tpv_pendings USING btree (reason);


--
-- Name: idx_00e7e6fb94129daa8f661a716121cb8c; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_00e7e6fb94129daa8f661a716121cb8c ON public.ticket_costs USING btree (amount);


--
-- Name: idx_00f267eaa1788125b25f022004a3dd3a; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_00f267eaa1788125b25f022004a3dd3a ON public.item_checkout_external_phones USING btree (id);


--
-- Name: idx_010140329dea61e2479008fede1054ce; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_010140329dea61e2479008fede1054ce ON public.queuelog_cart_fulfilled_rejected_switchholds_out USING btree (reason);


--
-- Name: idx_0131d0cc838fff67009d59b648a353a9; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0131d0cc838fff67009d59b648a353a9 ON public.item_electricity_leads USING btree (partner_order_status);


--
-- Name: idx_0135b074ccc8ea207c9ad0ffa56c346f; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0135b074ccc8ea207c9ad0ffa56c346f ON public.queuelog_cart_status_reviews_in USING btree (id);


--
-- Name: idx_014439d4164a97e391d99a7ed777eff6; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_014439d4164a97e391d99a7ed777eff6 ON public.queuelog_myaccount_raf_paids_in USING btree (id);


--
-- Name: idx_01584cbbd2be1a3a6d37a90abab54906; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_01584cbbd2be1a3a6d37a90abab54906 ON public.queuelog_cart_fulfilled_tpv_reviews_in USING btree (reason);


--
-- Name: idx_0160f5e2a7ba0c1eb643533ad7f16648; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0160f5e2a7ba0c1eb643533ad7f16648 ON public.queuelog_ops_contact_initiates_in USING btree (ticket_id);


--
-- Name: idx_0161d8b88260d7f9cc246a30475287fc; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0161d8b88260d7f9cc246a30475287fc ON public.item_location_solar_usas USING btree (address_2);


--
-- Name: idx_01691149b940fcd6cc85f986ee129278; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_01691149b940fcd6cc85f986ee129278 ON public.queuelog_lead_abandoneds USING btree (id);


--
-- Name: idx_01766baa67a769b660fd0e3fa9b34329; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_01766baa67a769b660fd0e3fa9b34329 ON public.item_email_depositcrosssells USING btree (last_updated);


--
-- Name: idx_01804d61edc55bd33cc5bcface0e2638; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_01804d61edc55bd33cc5bcface0e2638 ON public.queuelog_meetings USING btree (id);


--
-- Name: idx_0197dd4604acfc9203817a4c670a3881; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0197dd4604acfc9203817a4c670a3881 ON public.queuelog_meeting_archiveds_in USING btree (id);


--
-- Name: idx_01980770cc542b46983354bdbea4bc9e; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_01980770cc542b46983354bdbea4bc9e ON public.item_person_shopper_commercials USING btree (lando_session);


--
-- Name: idx_01a17bb1d5f76947b3040c31fe9f2b6b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_01a17bb1d5f76947b3040c31fe9f2b6b ON public.queuelog_cart_nodeposits_in USING btree (ticket_id);


--
-- Name: idx_01b0b3cb94ef3ebe7b087658386f1d53; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_01b0b3cb94ef3ebe7b087658386f1d53 ON public.queuelog_review_calls_in USING btree (ticket_id);


--
-- Name: idx_01ba5d496cc70f699195ce74b971f3a8; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_01ba5d496cc70f699195ce74b971f3a8 ON public.queuelog_meeting_archiveds USING btree (ticket_id);


--
-- Name: idx_01c4ea44002b82be7aba3178d9b07b43; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_01c4ea44002b82be7aba3178d9b07b43 ON public.queue_cart_autopay_requireds USING btree (reason);


--
-- Name: idx_01edfceb98cf3caff5ac86d3706a1e4d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_01edfceb98cf3caff5ac86d3706a1e4d ON public.queue_call_saveds USING btree (user_id);


--
-- Name: idx_01fba9b37ae6201fa4f4434462aa7b3d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_01fba9b37ae6201fa4f4434462aa7b3d ON public.item_electricity_leads USING btree (payment_amt);


--
-- Name: idx_021bf67ce674f2eb4b5ecd5350507900; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_021bf67ce674f2eb4b5ecd5350507900 ON public.queue_cart_balancedues USING btree (reason);


--
-- Name: idx_023e0cb4d006a9d6b9f589d382ee7fb7; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_023e0cb4d006a9d6b9f589d382ee7fb7 ON public.ticket_phone_imports_to_items USING btree (id);


--
-- Name: idx_0268f6460bb355aaff24256aef41975a; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0268f6460bb355aaff24256aef41975a ON public.queuelog_call_saveds_out USING btree (ticket_id);


--
-- Name: idx_02ddda875b35f43ee44920a62b1895a2; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_02ddda875b35f43ee44920a62b1895a2 ON public.queuelog_cart_fulfilled_holds_in USING btree (id);


--
-- Name: idx_0335b1d09d53e5a21d9f51b3bc21ae1e; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0335b1d09d53e5a21d9f51b3bc21ae1e ON public.actions USING btree (ticket_id);


--
-- Name: idx_036d60b6deb0eca4e10602666ddb5fcc; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_036d60b6deb0eca4e10602666ddb5fcc ON public.queues USING btree (id);


--
-- Name: idx_0377bb3f894b988fd9831f940dcd9575; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0377bb3f894b988fd9831f940dcd9575 ON public.queuelog_upload_orderss USING btree (ticket_id);


--
-- Name: idx_039f6ab1b26f985102aabe68ffa6dbd7; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_039f6ab1b26f985102aabe68ffa6dbd7 ON public.queuelog_cart_fulfilled_rejected_autopays_in USING btree (id);


--
-- Name: idx_03b03e55d730688f02cd9c5ce0eb215b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_03b03e55d730688f02cd9c5ce0eb215b ON public.queue_ops_contact_faileds USING btree (ticket_id);


--
-- Name: idx_03d6a8d95be8df1db285f9a606dbb0e3; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_03d6a8d95be8df1db285f9a606dbb0e3 ON public.queuelog_agent_standing_bs_out USING btree (id);


--
-- Name: idx_0420188a51a8b7847c585962288af64b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0420188a51a8b7847c585962288af64b ON public.item_location_previous_usas USING btree (state);


--
-- Name: idx_0429ddcf724e43a8beac35b40031e820; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0429ddcf724e43a8beac35b40031e820 ON public.item_email_hold_order_reminders USING btree (last_updated);


--
-- Name: idx_042fc14ec6b4b864682983af57f4c308; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_042fc14ec6b4b864682983af57f4c308 ON public.ticket_leads_to_items USING btree (id);


--
-- Name: idx_0448cb6e24f78b720bff08ae439947de; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0448cb6e24f78b720bff08ae439947de ON public.ticket_meetings USING btree (id);


--
-- Name: idx_046af8bf7456c99fb8cb0a6b69d745a6; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_046af8bf7456c99fb8cb0a6b69d745a6 ON public.queuelog_cart_fulfilled_rejected_autopays USING btree (id);


--
-- Name: idx_0471e4eef6604a9657ae642427e46409; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0471e4eef6604a9657ae642427e46409 ON public.queuelog_cart_fulfilled_flowings_out USING btree (ticket_id);


--
-- Name: idx_04d6f0c93018b591ae7d252b0e6b4b70; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_04d6f0c93018b591ae7d252b0e6b4b70 ON public.ticket_contact_call_outbounds USING btree (pbx_id);


--
-- Name: idx_04eec49a8db524e287e7a3cdd9bbbf11; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_04eec49a8db524e287e7a3cdd9bbbf11 ON public.queue_lead_accepteds USING btree (reason);


--
-- Name: idx_04facde6da33636cf4407463f50c7e93; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_04facde6da33636cf4407463f50c7e93 ON public.queuelog_cart_text_pendings_out USING btree (reason);


--
-- Name: idx_05185cd17a14acd81451b0ca6a07f69c; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_05185cd17a14acd81451b0ca6a07f69c ON public.queue_cart_fulfilled_rejected_switchholds USING btree (id);


--
-- Name: idx_05285a3bf4ae22c34c22fc047e14b474; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_05285a3bf4ae22c34c22fc047e14b474 ON public.queuelog_leads USING btree (id);


--
-- Name: idx_0533b99767eb3611a36d2b076701628d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0533b99767eb3611a36d2b076701628d ON public.ticket_commission_usages_to_items USING btree (ticket_id);


--
-- Name: idx_0535cd56b5fa2570106740d36e33613a; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0535cd56b5fa2570106740d36e33613a ON public.queuelog_cart_switchholds_out USING btree (id);


--
-- Name: idx_0547342d0955fc25c0d6f6b21c9f740e; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0547342d0955fc25c0d6f6b21c9f740e ON public.queuelog_ops_data_entrys USING btree (reason);


--
-- Name: idx_056bee28dad726d34e0648684a583e00; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_056bee28dad726d34e0648684a583e00 ON public.item_email_hold_orders USING btree (dropped);


--
-- Name: idx_05817afa322bec45278251d4fe407884; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_05817afa322bec45278251d4fe407884 ON public.queuelog_reviews USING btree (id);


--
-- Name: idx_0596011d068c1ab9d7b5b2b8b8b3de2c; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0596011d068c1ab9d7b5b2b8b8b3de2c ON public.ticket_contact_email_outbounds USING btree (error_log);


--
-- Name: idx_05f6d3d6c77174ec0e8c8489112e5e09; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_05f6d3d6c77174ec0e8c8489112e5e09 ON public.adwords USING btree (s);


--
-- Name: idx_06202487fa84782d85d5a712e43cba9b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_06202487fa84782d85d5a712e43cba9b ON public.item_cost_upfronts USING btree (vendor_id);


--
-- Name: idx_0626801b6319798e8e26b5e174b99886; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0626801b6319798e8e26b5e174b99886 ON public.queuelog_lead_rate_receiveds_out USING btree (id);


--
-- Name: idx_063823306991c03211b707c2ba07fe7b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_063823306991c03211b707c2ba07fe7b ON public.bucket_lifecycles USING btree (id);


--
-- Name: idx_065d0b8ef5d4dfa9abf02acf2cf30cdc; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_065d0b8ef5d4dfa9abf02acf2cf30cdc ON public.queuelog_cart_autopay_requireds_out USING btree (reason);


--
-- Name: idx_067d893c98bdb578ec8d887e6e834f45; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_067d893c98bdb578ec8d887e6e834f45 ON public.item_reviews USING btree (id);


--
-- Name: idx_068883f8e6eba3562abc4dba89f13c31; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_068883f8e6eba3562abc4dba89f13c31 ON public.ticket_contact_call_inbounds_to_items USING btree (ticket_id);


--
-- Name: idx_069340b14df130e38f41f3cf3d42bd85; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_069340b14df130e38f41f3cf3d42bd85 ON public.item_checkout_external_carts USING btree (error_log);


--
-- Name: idx_06a49928ab7867aab48fdfe50ccdf869; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_06a49928ab7867aab48fdfe50ccdf869 ON public.item_accountings USING btree (period);


--
-- Name: idx_06c70e83e7df204fd97e31e19a8f893b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_06c70e83e7df204fd97e31e19a8f893b ON public.item_location_utility_indianas USING btree (zip);


--
-- Name: idx_06caa4fac7ca8dd57b8ac58804284fcc; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_06caa4fac7ca8dd57b8ac58804284fcc ON public.item_emails USING btree (clicked);


--
-- Name: idx_070de1ec3dc9343400c4899ede16eee0; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_070de1ec3dc9343400c4899ede16eee0 ON public.queuelog_cart_fulfilled_tpv_completes_out USING btree (id);


--
-- Name: idx_07267ff4c4de11f0a014ee891bedbaaa; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_07267ff4c4de11f0a014ee891bedbaaa ON public.item_sms_order_by_text_completes USING btree (template);


--
-- Name: idx_0784860112b50c18f8873b5082298302; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0784860112b50c18f8873b5082298302 ON public.item_location_solar_usas USING btree (state);


--
-- Name: idx_079dd6c3005242b0b8339819ca17487a; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_079dd6c3005242b0b8339819ca17487a ON public.item_sms_order_by_text_sents USING btree (fingerprint);


--
-- Name: idx_07b3740a175f3c4c17244891cf04d654; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_07b3740a175f3c4c17244891cf04d654 ON public.queuelog_call_saveds_in USING btree (ticket_id);


--
-- Name: idx_07c5c55a9c258499437907f8797dfcf5; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_07c5c55a9c258499437907f8797dfcf5 ON public.queuelog_call_fulfilleds_in USING btree (phone);


--
-- Name: idx_07d7f3539099b76f001f2bec77e3b598; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_07d7f3539099b76f001f2bec77e3b598 ON public.queuelog_cart_deposits USING btree (id);


--
-- Name: idx_07de994e01f2fd701af79552eea4d480; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_07de994e01f2fd701af79552eea4d480 ON public.queuelog_cart_archives_out USING btree (id);


--
-- Name: idx_07f77a5cfaa60f7fef7ed41edbb8e3f5; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_07f77a5cfaa60f7fef7ed41edbb8e3f5 ON public.ticket_contact_emails_to_items USING btree (ticket_id);


--
-- Name: idx_0835c916acb71ee63c9ca98f8dc99564; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0835c916acb71ee63c9ca98f8dc99564 ON public.queuelog_myaccounts_out USING btree (reason);


--
-- Name: idx_083940dea110c07492fe9b3d3b733d68; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_083940dea110c07492fe9b3d3b733d68 ON public.queuelog_myaccount_raf_pendings_in USING btree (reason);


--
-- Name: idx_085d71d582472f8831918f1148571c25; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_085d71d582472f8831918f1148571c25 ON public.item_persons USING btree (lang);


--
-- Name: idx_086ba0c058289af9c6ae205e10a67678; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_086ba0c058289af9c6ae205e10a67678 ON public.queuelog_meeting_followups USING btree (ticket_id);


--
-- Name: idx_0872ce75a70398507fc7bdccad63bd51; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0872ce75a70398507fc7bdccad63bd51 ON public.item_location_utility_illinoiss USING btree (error_log);


--
-- Name: idx_0882c0a33543ea83293f3df72537e41c; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0882c0a33543ea83293f3df72537e41c ON public.item_location_utility_massachusettss USING btree (error_log);


--
-- Name: idx_0884acc1cb8523a874cb0ef3c91579eb; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0884acc1cb8523a874cb0ef3c91579eb ON public.queuelog_cost_pendings USING btree (ticket_id);


--
-- Name: idx_08885f3144dbfea9ee97f621665e468e; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_08885f3144dbfea9ee97f621665e468e ON public.tickets_to_items USING btree (ticket_id);


--
-- Name: idx_089dac85781010455be513f7bc053204; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_089dac85781010455be513f7bc053204 ON public.queuelog_lead_abandoneds USING btree (reason);


--
-- Name: idx_08aabda7efae188850b754d4e633fab1; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_08aabda7efae188850b754d4e633fab1 ON public.queue_cart_fulfilled_flowings USING btree (reason);


--
-- Name: idx_08ab623fb5f5f4f6de347616042f02a5; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_08ab623fb5f5f4f6de347616042f02a5 ON public.queuelog_agent_production_meds_in USING btree (reason);


--
-- Name: idx_090024c6275b261edb1fe89d3dc8d5e5; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_090024c6275b261edb1fe89d3dc8d5e5 ON public.queuelog_ops_contact_inbounds_in USING btree (reason);


--
-- Name: idx_09311143f1e881bd823d1f1222847961; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_09311143f1e881bd823d1f1222847961 ON public.queuelog_cart_text_cancelleds_in USING btree (reason);


--
-- Name: idx_0931643c5c7c1cfa212509a4036fdfa4; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0931643c5c7c1cfa212509a4036fdfa4 ON public.item_checkout_external_unknowns USING btree (id);


--
-- Name: idx_0955933fdf5a3d53b16dad453719cfec; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0955933fdf5a3d53b16dad453719cfec ON public.queuelog_agent_standing_fs USING btree (id);


--
-- Name: idx_098537dd5b10fecd2544a18379a837bb; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_098537dd5b10fecd2544a18379a837bb ON public.queuelog_cart_prepared_clickeds_in USING btree (id);


--
-- Name: idx_0993687f47f16befff6ebe72f609ee94; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0993687f47f16befff6ebe72f609ee94 ON public.item_cost_flowings USING btree (period);


--
-- Name: idx_09bbae4dff35cc09f4cea49978098996; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_09bbae4dff35cc09f4cea49978098996 ON public.item_sms_prepared_carts USING btree (sms);


--
-- Name: idx_09d2746bdfdc9c6b7f79452f25c3083c; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_09d2746bdfdc9c6b7f79452f25c3083c ON public.item_file_phonecall_trusteds USING btree (error_log);


--
-- Name: idx_09d6fbdfae6cc6d0ef063901634e5319; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_09d6fbdfae6cc6d0ef063901634e5319 ON public.queuelog_cart_fulfilled_rejecteds_in USING btree (id);


--
-- Name: idx_09e2eab3cc69cb96a9e200737394248e; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_09e2eab3cc69cb96a9e200737394248e ON public.queuelog_meeting_initiates USING btree (id);


--
-- Name: idx_0a0da213e28c1d8fcb5f4db9313e4b73; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0a0da213e28c1d8fcb5f4db9313e4b73 ON public.item_electricity_lead_dtvs USING btree (payment_amt);


--
-- Name: idx_0a21e0f981cf210e627d2e25cfb19985; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0a21e0f981cf210e627d2e25cfb19985 ON public.item_email_depositcrosssells USING btree (clicked);


--
-- Name: idx_0a4631151ba881f96ea745ed83107f7c; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0a4631151ba881f96ea745ed83107f7c ON public.item_sms_order_by_text_completes USING btree (id);


--
-- Name: idx_0a5aa0874086a0d08cb59b1be7a337ac; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0a5aa0874086a0d08cb59b1be7a337ac ON public.queues USING btree (reason);


--
-- Name: idx_0a99337c4ba3858a6c201dbfcd338e73; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0a99337c4ba3858a6c201dbfcd338e73 ON public.queuelog_myaccount_rafs USING btree (id);


--
-- Name: idx_0aa23568aa63804181cb96ac83b41b33; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0aa23568aa63804181cb96ac83b41b33 ON public.item_location_previous_usas USING btree (address_1);


--
-- Name: idx_0aa58f1b74c9ff4955c7262ef04ab493; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0aa58f1b74c9ff4955c7262ef04ab493 ON public.queuelog_myaccount_raf_dues_in USING btree (ticket_id);


--
-- Name: idx_0ab7f8ed69fdf7826082a446e4252b30; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0ab7f8ed69fdf7826082a446e4252b30 ON public.item_email_review_receiveds USING btree (dropped);


--
-- Name: idx_0ac84fef9a862b974cdfa9c284fc6364; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0ac84fef9a862b974cdfa9c284fc6364 ON public.ticket_lead_solars USING btree (id);


--
-- Name: idx_0ae18d6d751a848a8c885a42df4fe2a3; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0ae18d6d751a848a8c885a42df4fe2a3 ON public.item_review_calls USING btree (id);


--
-- Name: idx_0af7726082136a8b3166ed577ff2dd08; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0af7726082136a8b3166ed577ff2dd08 ON public.item_sms_customs USING btree (custom_text);


--
-- Name: idx_0b471ea7694be5c9446d53e3f7f61c92; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0b471ea7694be5c9446d53e3f7f61c92 ON public.item_sms_customs USING btree (fingerprint);


--
-- Name: idx_0b4a8fbe7deb2a41bf9c72ea4e710b62; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0b4a8fbe7deb2a41bf9c72ea4e710b62 ON public.queuelog_ledgers_out USING btree (id);


--
-- Name: idx_0b6bd2f1ae9d32733a6a40f93859257e; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0b6bd2f1ae9d32733a6a40f93859257e ON public.item_file_phonecalls USING btree (error_log);


--
-- Name: idx_0b8128c5d7ac91c9706b0ecbe4c2c9f6; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0b8128c5d7ac91c9706b0ecbe4c2c9f6 ON public.queue_cart_fulfilled_rejecteds USING btree (reason);


--
-- Name: idx_0b81c277491d881a169686f295b79ef7; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0b81c277491d881a169686f295b79ef7 ON public.item_electricity_lead_dtvs USING btree (plan_efl_url);


--
-- Name: idx_0ba7fe64aff88fbf9d8bef7556053cd7; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0ba7fe64aff88fbf9d8bef7556053cd7 ON public.queuelog_cart_fulfilled_tpv_faileds_out USING btree (id);


--
-- Name: idx_0bce0efd4a44c5be43c7afe48d89d66c; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0bce0efd4a44c5be43c7afe48d89d66c ON public.queuelog_lead_quote_pendings USING btree (id);


--
-- Name: idx_0bd0967dbd324267df164fbe1403e54c; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0bd0967dbd324267df164fbe1403e54c ON public.queuelog_ops_contact_faileds_in USING btree (id);


--
-- Name: idx_0bd4b951c30961c533ed1faf2103f95a; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0bd4b951c30961c533ed1faf2103f95a ON public.item_electricity_lead_dtvs USING btree (flag_payment_due);


--
-- Name: idx_0bfeeccf76123e32417a56c5c8c87293; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0bfeeccf76123e32417a56c5c8c87293 ON public.item_file_phonecall_trusteds USING btree (phone);


--
-- Name: idx_0c9ba46308a41b060ffbf1fb712b9086; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0c9ba46308a41b060ffbf1fb712b9086 ON public.ticket_upload_partner_clearviews_to_items USING btree (id);


--
-- Name: idx_0cab48c90edaebd442cb932741741386; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0cab48c90edaebd442cb932741741386 ON public.queuelog_cart_fulfilled_rejected_existings USING btree (id);


--
-- Name: idx_0cbbc40952bff89bd7fdcbe1081129ff; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0cbbc40952bff89bd7fdcbe1081129ff ON public.item_review_company_usas USING btree (rating_score3);


--
-- Name: idx_0ce17654ee203b1e94c1473cd56508c7; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0ce17654ee203b1e94c1473cd56508c7 ON public.queuelog_meeting_pendings_in USING btree (ticket_id);


--
-- Name: idx_0ce22c202c4a95505f00acca9161d3e0; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0ce22c202c4a95505f00acca9161d3e0 ON public.queue_lead_abandoneds USING btree (reason);


--
-- Name: idx_0ce3df825224d991bcccb17b109eaa2e; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0ce3df825224d991bcccb17b109eaa2e ON public.ticket_upload_partner_publics_to_items USING btree (ticket_id);


--
-- Name: idx_0cfdce6af558a0012ad504b0a8e874ac; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0cfdce6af558a0012ad504b0a8e874ac ON public.queuelog_cart_fulfilled_rejected_switchholds USING btree (reason);


--
-- Name: idx_0d15a1ef9d225916af6b74a233b91362; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0d15a1ef9d225916af6b74a233b91362 ON public.item_review_company_usas USING btree (rep_comment_time);


--
-- Name: idx_0d244753d25836ced2cd92526064accc; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0d244753d25836ced2cd92526064accc ON public.bucket_plans USING btree (id);


--
-- Name: idx_0d2db5b6f730fb7c041a5a06ce0585f6; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0d2db5b6f730fb7c041a5a06ce0585f6 ON public.ticket_carts_to_items USING btree (ticket_id);


--
-- Name: idx_0d5f7f56ecbb3ed25936d4f86bb92bb3; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0d5f7f56ecbb3ed25936d4f86bb92bb3 ON public.item_location_utility_newjerseys USING btree (address_1);


--
-- Name: idx_0d77a24982fd64c6dd81ab235262f827; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0d77a24982fd64c6dd81ab235262f827 ON public.cis_notifications USING btree (status);


--
-- Name: idx_0da36502a70d9eefebb6895cb7515547; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0da36502a70d9eefebb6895cb7515547 ON public.queuelog_review_approveds_in USING btree (ticket_id);


--
-- Name: idx_0dad81f5f58eb0927e9abef801c74755; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0dad81f5f58eb0927e9abef801c74755 ON public.queuelog_cart_archives_in USING btree (id);


--
-- Name: idx_0dbf991c7556c9b175ce5f2334bb87d9; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0dbf991c7556c9b175ce5f2334bb87d9 ON public.queuelog_lead_completes_out USING btree (ticket_id);


--
-- Name: idx_0e2ed51bfe18ef65175a26750581ccad; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0e2ed51bfe18ef65175a26750581ccad ON public.queuelog_upload_orderss USING btree (reason);


--
-- Name: idx_0e9c89c40bbc3c8eb1c8d57d365a97de; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0e9c89c40bbc3c8eb1c8d57d365a97de ON public.item_review_company_usas USING btree (rating_score5);


--
-- Name: idx_0ea56d38388120be916579ee20cf651f; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0ea56d38388120be916579ee20cf651f ON public.queuelog_cost_sents_in USING btree (reason);


--
-- Name: idx_0ec15600da06d5cb0e73163a5b2a5596; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0ec15600da06d5cb0e73163a5b2a5596 ON public.queuelog_cart_fulfilled_tpv_faileds USING btree (id);


--
-- Name: idx_0efb85c124ddf10ca2a071bfecbf70bf; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0efb85c124ddf10ca2a071bfecbf70bf ON public.item_file_screenshots USING btree (file_size);


--
-- Name: idx_0f222120fddaf39c092f07fe81e5d4ff; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0f222120fddaf39c092f07fe81e5d4ff ON public.queuelog_review_call_passeds USING btree (reason);


--
-- Name: idx_0f2ebb61eabbc25e076267dd837a3b6e; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0f2ebb61eabbc25e076267dd837a3b6e ON public.item_location_utility_newyorks USING btree (city);


--
-- Name: idx_0f402f0a17eaa2bcc4922487523b280f; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0f402f0a17eaa2bcc4922487523b280f ON public.queuelog_lead_abandoneds_out USING btree (ticket_id);


--
-- Name: idx_0f456774a94f08cbc962bbc7b21476a6; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0f456774a94f08cbc962bbc7b21476a6 ON public.queuelog_cart_switchholds USING btree (ticket_id);


--
-- Name: idx_0f6eb4b98c8adf1894addb68d2d555c7; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0f6eb4b98c8adf1894addb68d2d555c7 ON public.queuelog_ledger_pendings_out USING btree (reason);


--
-- Name: idx_0f7a3bdca048e2e2e3644f4987d7cdd6; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0f7a3bdca048e2e2e3644f4987d7cdd6 ON public.queue_agent_standing_bs USING btree (ticket_id);


--
-- Name: idx_0fcb7a369dd3a65c7d8d2caf6d68b199; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0fcb7a369dd3a65c7d8d2caf6d68b199 ON public.item_payaccounts USING btree (id);


--
-- Name: idx_0ffbff33599299ad3bcee3271f091e59; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_0ffbff33599299ad3bcee3271f091e59 ON public.queuelog_cart_fulfilled_outboxs_out USING btree (id);


--
-- Name: idx_100c04193928940e1fb21aa0fee8bc03; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_100c04193928940e1fb21aa0fee8bc03 ON public.queuelog_cart_status_reviews_out USING btree (ticket_id);


--
-- Name: idx_100d6adf6b9b83c1275520b53a41a98d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_100d6adf6b9b83c1275520b53a41a98d ON public.queuelog_meeting_initiates_out USING btree (ticket_id);


--
-- Name: idx_102df946f1b1a7405665fc15a5390782; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_102df946f1b1a7405665fc15a5390782 ON public.queuelog_lead_rate_receiveds USING btree (ticket_id);


--
-- Name: idx_102fc8409765d4d84f2377b36bccfb31; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_102fc8409765d4d84f2377b36bccfb31 ON public.item_review_company_usas USING btree (rating_criteria_id3);


--
-- Name: idx_10581ca199d961d843d8c4c9447187d7; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_10581ca199d961d843d8c4c9447187d7 ON public.queuelog_review_call_passeds_in USING btree (ticket_id);


--
-- Name: idx_106b290ffa01491bcd8ccef29c12ec2d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_106b290ffa01491bcd8ccef29c12ec2d ON public.queuelog_lead_rate_pendings_in USING btree (reason);


--
-- Name: idx_106c6135ce1920498c3b05d07fe27e1d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_106c6135ce1920498c3b05d07fe27e1d ON public.queuelog_cart_status_reviews_in USING btree (reason);


--
-- Name: idx_10d09a5ff10485ea1c79728db836abf5; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_10d09a5ff10485ea1c79728db836abf5 ON public.item_location_utility_indianas USING btree (address_2);


--
-- Name: idx_10d933b5eb7c7daa508e7de68a84ce2f; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_10d933b5eb7c7daa508e7de68a84ce2f ON public.queuelog_ledger_archives USING btree (id);


--
-- Name: idx_10e21183ea8349d5e8a607130cba479e; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_10e21183ea8349d5e8a607130cba479e ON public.queuelog_lead_quote_pendings USING btree (reason);


--
-- Name: idx_10f274a69cd29ecea696e4f70c6f66a3; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_10f274a69cd29ecea696e4f70c6f66a3 ON public.queuelog_review_call_passeds_out USING btree (ticket_id);


--
-- Name: idx_1120158ed7168e26b2a0aecd2a79bbcb; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1120158ed7168e26b2a0aecd2a79bbcb ON public.ticket_contact_call_outbounds USING btree (pbx_cust_number);


--
-- Name: idx_11292a5593523b9622572964e41f3c5e; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_11292a5593523b9622572964e41f3c5e ON public.queuelog_ops_contact_inbounds_out USING btree (id);


--
-- Name: idx_114464770896e11a15d0f8ebbcee3913; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_114464770896e11a15d0f8ebbcee3913 ON public.queuelog_lead_quote_pendings_in USING btree (reason);


--
-- Name: idx_11b0345bcf0b62b493ff82e0f25763ac; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_11b0345bcf0b62b493ff82e0f25763ac ON public.alarmclock_archives USING btree (ticket_method);


--
-- Name: idx_11c8f5166dc79406819062cf241a4e60; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_11c8f5166dc79406819062cf241a4e60 ON public.item_electricity_lead_dtvs USING btree (plan_id);


--
-- Name: idx_11d469c253dce30b8b9e5f8eb61e7235; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_11d469c253dce30b8b9e5f8eb61e7235 ON public.item_email_hold_order_notifications USING btree (fingerprint);


--
-- Name: idx_11db8b11cf47b943b1b23f0142214abb; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_11db8b11cf47b943b1b23f0142214abb ON public.item_email_review_receiveds USING btree (id);


--
-- Name: idx_11f7ca576e39eab5a056aca96e850bf6; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_11f7ca576e39eab5a056aca96e850bf6 ON public.item_review_company_usas USING btree (rating_order_experience);


--
-- Name: idx_120911f49be42156199f9ec4d9d20efd; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_120911f49be42156199f9ec4d9d20efd ON public.queuelog_cart_deads_out USING btree (reason);


--
-- Name: idx_1212dc6cbd603af173675e00a634f91d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1212dc6cbd603af173675e00a634f91d ON public.queue_review_approveds USING btree (ticket_id);


--
-- Name: idx_12371312_primary; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE UNIQUE INDEX idx_12371312_primary ON public.ad_groups USING btree (id);


--
-- Name: idx_12371321_blocked_ips_ip_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX idx_12371321_blocked_ips_ip_index ON public.blocked_ips USING btree (ip);


--
-- Name: idx_12371321_blocked_ips_vid_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX idx_12371321_blocked_ips_vid_index ON public.blocked_ips USING btree (vid);


--
-- Name: idx_12371321_primary; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE UNIQUE INDEX idx_12371321_primary ON public.blocked_ips USING btree (id);


--
-- Name: idx_12371330_cached_pages_market_rates_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX idx_12371330_cached_pages_market_rates_index ON public.cached_pages USING btree (market_id, has_rates);


--
-- Name: idx_12371330_cached_pages_site_page_index; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE INDEX idx_12371330_cached_pages_site_page_index ON public.cached_pages USING btree (site_id, page_id);


--
-- Name: idx_12371330_primary; Type: INDEX; Schema: public; Owner: phpuser
--

CREATE UNIQUE INDEX idx_12371330_primary ON public.cached_pages USING btree (id);


--
-- Name: idx_128251f998915de60e8f0aaec18b2b24; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_128251f998915de60e8f0aaec18b2b24 ON public.item_email_confirmations USING btree (error_log);


--
-- Name: idx_129ebebe76ee5c4f5f29d2cd15929cc4; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_129ebebe76ee5c4f5f29d2cd15929cc4 ON public.queuelog_agent_standing_fs_in USING btree (ticket_id);


--
-- Name: idx_12b43be565bc9eec45875e4ec71bd7bd; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_12b43be565bc9eec45875e4ec71bd7bd ON public.queuelog_cart_autopay_requireds USING btree (ticket_id);


--
-- Name: idx_12cfdafdd8217ca9ce1eb701f719b724; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_12cfdafdd8217ca9ce1eb701f719b724 ON public.queue_review_call_completeds USING btree (ticket_id);


--
-- Name: idx_13266f180e4b001e1ce606e30635bfd7; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_13266f180e4b001e1ce606e30635bfd7 ON public.queue_upload_orders_sents USING btree (ticket_id);


--
-- Name: idx_13335b5f8d0f45c0f144cfb7d91b497d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_13335b5f8d0f45c0f144cfb7d91b497d ON public.item_location_utility_californias USING btree (zip);


--
-- Name: idx_13346de498d4a4b2556fefad05cdafd2; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_13346de498d4a4b2556fefad05cdafd2 ON public.company_logs USING btree (message);


--
-- Name: idx_1349bde6d25898d51d9adc632887e86b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1349bde6d25898d51d9adc632887e86b ON public.queuelog_meeting_initiates_out USING btree (id);


--
-- Name: idx_13511d66694b839e42d1137249024a4a; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_13511d66694b839e42d1137249024a4a ON public.queuelog_agent_standing_fs USING btree (ticket_id);


--
-- Name: idx_136003cb18ee0a51b7bca5d1a7c15093; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_136003cb18ee0a51b7bca5d1a7c15093 ON public.queuelog_cart_fulfilled_rejected_autopays USING btree (ticket_id);


--
-- Name: idx_136ab16b968513b733931bb1824ea274; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_136ab16b968513b733931bb1824ea274 ON public.queue_cart_prepareds USING btree (id);


--
-- Name: idx_136bbfbe72c298654d4783d2c43199e1; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_136bbfbe72c298654d4783d2c43199e1 ON public.item_location_utility_georgias USING btree (city);


--
-- Name: idx_13782785cc60e504b9cf3e109516fed9; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_13782785cc60e504b9cf3e109516fed9 ON public.item_checkout_external_unknowns USING btree (error_log);


--
-- Name: idx_13865b57084441c250892076b65ce039; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_13865b57084441c250892076b65ce039 ON public.actions USING btree (agent_id);


--
-- Name: idx_139b1d12c889405417b5bc88749a1e69; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_139b1d12c889405417b5bc88749a1e69 ON public.item_electricity_lead_dtvs USING btree (partner_order_status);


--
-- Name: idx_13fe948a3caea12655c1a4ddab831a40; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_13fe948a3caea12655c1a4ddab831a40 ON public.queuelog_agent_standing_ds_in USING btree (id);


--
-- Name: idx_1406b3601685161d12cdfab2a405ad67; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1406b3601685161d12cdfab2a405ad67 ON public.ticket_contact_call_outbounds_to_items USING btree (ticket_id);


--
-- Name: idx_142405fa41c85d31472d8ecddef197ae; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_142405fa41c85d31472d8ecddef197ae ON public.queuelog_review_call_faileds_in USING btree (reason);


--
-- Name: idx_143d22b7fcd8d4e3e61447514d469759; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_143d22b7fcd8d4e3e61447514d469759 ON public.item_review_company_usas USING btree (rating_overall);


--
-- Name: idx_1442a7653ecc508a899eccfb6f0162a7; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1442a7653ecc508a899eccfb6f0162a7 ON public.alarmclock_archives USING btree (id);


--
-- Name: idx_14afed6f89a72717097908b6380e359b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_14afed6f89a72717097908b6380e359b ON public.ticket_meetings USING btree (note);


--
-- Name: idx_14c1feebfbe40e010420443d89637599; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_14c1feebfbe40e010420443d89637599 ON public.item_location_utility_pennsylvanias USING btree (utility_account_number);


--
-- Name: idx_14fe1072de08dac311e85ca1140f0073; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_14fe1072de08dac311e85ca1140f0073 ON public.queue_cart_deads USING btree (id);


--
-- Name: idx_1504a4ae0a9bcfc3e31888a1e063e418; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1504a4ae0a9bcfc3e31888a1e063e418 ON public.queuelog_call_starts USING btree (phone);


--
-- Name: idx_15105fe1c5970b2cd868a3642d63dcb8; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_15105fe1c5970b2cd868a3642d63dcb8 ON public.queuelog_cart_deads USING btree (ticket_id);


--
-- Name: idx_152ba32354faf830a61d289b4bd3f29d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_152ba32354faf830a61d289b4bd3f29d ON public.ticket_phones_to_items USING btree (item_id);


--
-- Name: idx_1542320c44f2e81aac809223d96442c2; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1542320c44f2e81aac809223d96442c2 ON public.item_location_utility_delawares USING btree (city);


--
-- Name: idx_156a8e405d5bdb921908c317d5d532a7; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_156a8e405d5bdb921908c317d5d532a7 ON public.queuelog_myaccount_hiddens_in USING btree (id);


--
-- Name: idx_15720d4d2c9ff7b5c9019b53f751d569; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_15720d4d2c9ff7b5c9019b53f751d569 ON public.queuelog_agent_standing_cs_in USING btree (ticket_id);


--
-- Name: idx_157d015984c5780a15b1d3c1fd68721b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_157d015984c5780a15b1d3c1fd68721b ON public.queuelog_myaccount_raf_paids_out USING btree (id);


--
-- Name: idx_15db2d0a72f83905a040c05d5b167da2; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_15db2d0a72f83905a040c05d5b167da2 ON public.item_email_reviews USING btree (id);


--
-- Name: idx_1620637e5ddca260d4d4ab7e6d1dcfdc; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1620637e5ddca260d4d4ab7e6d1dcfdc ON public.queuelog_myaccount_raf_dues USING btree (id);


--
-- Name: idx_163412a36e00ea3958f60a6ab86d4bb0; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_163412a36e00ea3958f60a6ab86d4bb0 ON public.item_review_company_usas USING btree (url);


--
-- Name: idx_164f020687ff594fe5657b85debf2e8a; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_164f020687ff594fe5657b85debf2e8a ON public.ticket_contact_calls USING btree (user_id);


--
-- Name: idx_164f94812ed3772aeaaa32ab5e7fe4f8; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_164f94812ed3772aeaaa32ab5e7fe4f8 ON public.item_location_utility_pennsylvanias USING btree (state);


--
-- Name: idx_16631130c4048a497a03b595afa911d7; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_16631130c4048a497a03b595afa911d7 ON public.item_location_utility_californias USING btree (error_log);


--
-- Name: idx_16634b31c01c870f64abedcbdbab8f59; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_16634b31c01c870f64abedcbdbab8f59 ON public.queuelog_cart_fulfilled_pendings_in USING btree (reason);


--
-- Name: idx_168856c5d439792a0544a593154f91fa; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_168856c5d439792a0544a593154f91fa ON public.cron_logs USING btree (last_updated);


--
-- Name: idx_168f5aa36196e2a940dc25c7acd4c6b2; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_168f5aa36196e2a940dc25c7acd4c6b2 ON public.queuelog_cart_fulfilled_rejected_autopays_out USING btree (reason);


--
-- Name: idx_16a75d7664e100c5c17be3060dfbb970; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_16a75d7664e100c5c17be3060dfbb970 ON public.item_commission_usages USING btree (end_date);


--
-- Name: idx_16ab768f97e53ffa777989e637671ec5; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_16ab768f97e53ffa777989e637671ec5 ON public.item_location_utility_illinoiss USING btree (utility_account_number);


--
-- Name: idx_16b16b0fe14a6efbadb46588fd55a48c; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_16b16b0fe14a6efbadb46588fd55a48c ON public.item_electricitys USING btree (mills);


--
-- Name: idx_16c5787b940bc21588ae55bbf0215c70; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_16c5787b940bc21588ae55bbf0215c70 ON public.queue_agent_standing_ds USING btree (reason);


--
-- Name: idx_16d2762cca751681027d13fa3912c9c5; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_16d2762cca751681027d13fa3912c9c5 ON public.queuelog_cart_autopay_requireds_in USING btree (ticket_id);


--
-- Name: idx_16d6a9712498cbcdf0746f1fbda0d81c; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_16d6a9712498cbcdf0746f1fbda0d81c ON public.item_email_review_approveds USING btree (fingerprint);


--
-- Name: idx_16e27294cc9cd3268c024658204cbbbc; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_16e27294cc9cd3268c024658204cbbbc ON public.item_checkout_cart_split_credits USING btree (error_log);


--
-- Name: idx_16ee583109cfb3df5f0b7c966cc17ca8; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_16ee583109cfb3df5f0b7c966cc17ca8 ON public.queuelog_meeting_archiveds_out USING btree (ticket_id);


--
-- Name: idx_170a1b929a311e8c397cdb969c17d689; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_170a1b929a311e8c397cdb969c17d689 ON public.queuelog_review_call_assigneds_out USING btree (ticket_id);


--
-- Name: idx_1719dace55fbca2d85e1336870c2e209; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1719dace55fbca2d85e1336870c2e209 ON public.item_person_shopper_commercials USING btree (dl_state);


--
-- Name: idx_177cf4841000ac6bf93baf85ea8f61c4; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_177cf4841000ac6bf93baf85ea8f61c4 ON public.queuelog_cart_abandons_in USING btree (id);


--
-- Name: idx_178ec9293c96e0a519ed299ffd88604d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_178ec9293c96e0a519ed299ffd88604d ON public.queuelog_cart_fulfilled_cancelleds_out USING btree (ticket_id);


--
-- Name: idx_17a0f9d25735cb9d2dd5150cc6de4805; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_17a0f9d25735cb9d2dd5150cc6de4805 ON public.queuelog_call_cancelleds USING btree (user_id);


--
-- Name: idx_17df497d552f8bfff437bc15bacab0eb; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_17df497d552f8bfff437bc15bacab0eb ON public.queue_calls USING btree (phone);


--
-- Name: idx_17ef7f799779630d30025572023e9f2d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_17ef7f799779630d30025572023e9f2d ON public.queue_review_approveds USING btree (id);


--
-- Name: idx_1802eddf5a11da437fa94aa2c122f440; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1802eddf5a11da437fa94aa2c122f440 ON public.ticket_deleteds_to_items USING btree (ticket_id);


--
-- Name: idx_1819385480c25be251a71a4bd2e7d5ee; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1819385480c25be251a71a4bd2e7d5ee ON public.queuelog_review_call_completeds USING btree (ticket_id);


--
-- Name: idx_182039e208189b668c3d5614c319bb74; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_182039e208189b668c3d5614c319bb74 ON public.queuelog_ledger_sents_in USING btree (id);


--
-- Name: idx_186d7961fa99093dec7a35c23f63edd6; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_186d7961fa99093dec7a35c23f63edd6 ON public.item_email_hold_orders USING btree (send_with_us_key);


--
-- Name: idx_18779cea7561b1d8ece3368aa92d4920; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_18779cea7561b1d8ece3368aa92d4920 ON public.bucket_marketings USING btree (search_source);


--
-- Name: idx_188f43e3838fc5ea783f16005e8210bd; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_188f43e3838fc5ea783f16005e8210bd ON public.item_location_utility_ohios USING btree (error_log);


--
-- Name: idx_18a74d0a3872a7ba0ad650826ab78fc0; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_18a74d0a3872a7ba0ad650826ab78fc0 ON public.queuelog_cart_text_respondeds_out USING btree (id);


--
-- Name: idx_18b2823e0955c73790bebacdaa8e55be; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_18b2823e0955c73790bebacdaa8e55be ON public.queuelog_cart_text_pendings_out USING btree (ticket_id);


--
-- Name: idx_18dce57ee25fad2bb450c8c922035093; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_18dce57ee25fad2bb450c8c922035093 ON public.queuelog_lead_cancelleds_out USING btree (id);


--
-- Name: idx_18f6e88de637e223848247ab78aa1f5b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_18f6e88de637e223848247ab78aa1f5b ON public.queue_cost_casheds USING btree (reason);


--
-- Name: idx_191d2ac7f0c182975426e00b6809c5a4; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_191d2ac7f0c182975426e00b6809c5a4 ON public.queuelog_cart_fulfilled_rejected_existings_in USING btree (id);


--
-- Name: idx_193218d7abfb35a863b13cd496700568; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_193218d7abfb35a863b13cd496700568 ON public.item_email_confirmations USING btree (id);


--
-- Name: idx_193249c21d4bf21ec4514b09dec321cd; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_193249c21d4bf21ec4514b09dec321cd ON public.queue_ops_contact_reacheds USING btree (ticket_id);


--
-- Name: idx_1962e455c9eacde51ee2f3af21e92d25; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1962e455c9eacde51ee2f3af21e92d25 ON public.item_person_shopper_commercials USING btree (monthly_bill);


--
-- Name: idx_196db3508512c07b0d00da55e861f7c2; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_196db3508512c07b0d00da55e861f7c2 ON public.queuelog_ops_data_entrys_out USING btree (reason);


--
-- Name: idx_197380e3b5bef09da987f0923278d11d; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_197380e3b5bef09da987f0923278d11d ON public.queuelog_ops_contact_requireds_out USING btree (ticket_id);


--
-- Name: idx_197c8361308b28727871bcac32efa160; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_197c8361308b28727871bcac32efa160 ON public.queuelog_review_rejecteds_in USING btree (id);


--
-- Name: idx_199239ed9f01c79ec59efba15db25d7a; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_199239ed9f01c79ec59efba15db25d7a ON public.item_file_texts USING btree (error_log);


--
-- Name: idx_199758c2add6cb6d53e2f1fc026070a4; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_199758c2add6cb6d53e2f1fc026070a4 ON public.queuelog_ops_data_entrys_in USING btree (ticket_id);


--
-- Name: idx_19d3c0b47af7caa81e78209afe7045ab; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_19d3c0b47af7caa81e78209afe7045ab ON public.ticket_reviews_to_items USING btree (ticket_id);


--
-- Name: idx_19d8ba5ba14372aed664da9a498b91e3; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_19d8ba5ba14372aed664da9a498b91e3 ON public.item_accountings USING btree (journal_entry_id);


--
-- Name: idx_1a1cab6d3b161e6c6ffaeedc7619092b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1a1cab6d3b161e6c6ffaeedc7619092b ON public.queuelog_meetings USING btree (reason);


--
-- Name: idx_1a25e958a7bb6aa791c88785d20f4782; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1a25e958a7bb6aa791c88785d20f4782 ON public.queuelog_lead_quote_pendings_out USING btree (reason);


--
-- Name: idx_1a2702c20d38cbd49fc95ddc3858300b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1a2702c20d38cbd49fc95ddc3858300b ON public.queue_leads USING btree (reason);


--
-- Name: idx_1a3a9e9148d6820c050105092b4a97fe; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1a3a9e9148d6820c050105092b4a97fe ON public.ticket_carts USING btree (error_log);


--
-- Name: idx_1a7447bb979019fb006f386698da88ad; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1a7447bb979019fb006f386698da88ad ON public.queuelog_agent_standing_fs_in USING btree (id);


--
-- Name: idx_1a7c5b214cbcdfc8bacbfc4108a97413; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1a7c5b214cbcdfc8bacbfc4108a97413 ON public.queuelog_cart_fulfilled_holds_out USING btree (id);


--
-- Name: idx_1ad52c11b8febc2756196f72559c9fba; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1ad52c11b8febc2756196f72559c9fba ON public.queuelog_lead_rate_pendings_out USING btree (ticket_id);


--
-- Name: idx_1adc0a5ccac4cceb530ae20c0120a82f; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1adc0a5ccac4cceb530ae20c0120a82f ON public.queuelog_agent_standing_bs_in USING btree (ticket_id);


--
-- Name: idx_1b0496cb5458cdb95ef3f85338ccd287; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1b0496cb5458cdb95ef3f85338ccd287 ON public.queuelog_cart_prepared_clickeds_out USING btree (id);


--
-- Name: idx_1b2df538d33349b563080382e1cdcc5e; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1b2df538d33349b563080382e1cdcc5e ON public.queuelog_cart_fulfilled_rejected_existings USING btree (reason);


--
-- Name: idx_1b38a700b2e61353075ef701cd82a39a; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1b38a700b2e61353075ef701cd82a39a ON public.queuelog_agent_standing_ds_in USING btree (reason);


--
-- Name: idx_1b3f1cd6eb845d65514dbeb3a57d68f2; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1b3f1cd6eb845d65514dbeb3a57d68f2 ON public.item_cost_flowings USING btree (vendor_id);


--
-- Name: idx_1b450f031f32740778b83c035e6468c4; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1b450f031f32740778b83c035e6468c4 ON public.queuelog_reviews USING btree (ticket_id);


--
-- Name: idx_1b4e87757240cb71c21ca7d89253b738; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1b4e87757240cb71c21ca7d89253b738 ON public.queuelog_cart_fulfilled_tpv_faileds_out USING btree (ticket_id);


--
-- Name: idx_1b6e93baffe4f03a8a706346a2407377; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1b6e93baffe4f03a8a706346a2407377 ON public.queuelog_meeting_followups_out USING btree (ticket_id);


--
-- Name: idx_1b830fcd2cdd730073702b3c128a99d3; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1b830fcd2cdd730073702b3c128a99d3 ON public.queuelog_agent_standing_ds_out USING btree (ticket_id);


--
-- Name: idx_1c490c746ecbea6bb16fc618cf76b6e7; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1c490c746ecbea6bb16fc618cf76b6e7 ON public.ticket_deleteds_to_items USING btree (id);


--
-- Name: idx_1c887d527a529142fff1b2adfb4ae859; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1c887d527a529142fff1b2adfb4ae859 ON public.item_checkout_cart_mobiles USING btree (id);


--
-- Name: idx_1c92c76fe76012bb4c3dd4c06ba2fc6b; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1c92c76fe76012bb4c3dd4c06ba2fc6b ON public.queue_agent_production_highs USING btree (reason);


--
-- Name: idx_1cd3fed6c4bb2dcf4b55231745d07f80; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1cd3fed6c4bb2dcf4b55231745d07f80 ON public.queue_calls USING btree (id);


--
-- Name: idx_1cdf1d1f01611aedf6f31bc3daae7bd9; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1cdf1d1f01611aedf6f31bc3daae7bd9 ON public.queue_cart_fulfilled_rejected_existings USING btree (ticket_id);


--
-- Name: idx_1ceb787257adcdccbb912e1a2d3c8f58; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1ceb787257adcdccbb912e1a2d3c8f58 ON public.queuelog_cart_fulfilled_tpv_completes USING btree (id);


--
-- Name: idx_1d1f061f12116657b3d98f827b28aa97; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX idx_1d1f061f12116657b3d98f827b28aa97 ON public.queuelog_cart_fulfilled_tpv_faileds USING btree (reason);


--
