-- Name: queuelog_lead_rejecteds_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_lead_rejecteds_in (
)
INHERITS (public.queuelog_lead_rejecteds);


ALTER TABLE public.queuelog_lead_rejecteds_in OWNER TO postgres;

--
-- Name: queuelog_lead_rejecteds_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_lead_rejecteds_out (
)
INHERITS (public.queuelog_lead_rejecteds);


ALTER TABLE public.queuelog_lead_rejecteds_out OWNER TO postgres;

--
-- Name: queuelog_ledgers; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ledgers (
)
INHERITS (public.queuelog);


ALTER TABLE public.queuelog_ledgers OWNER TO postgres;

--
-- Name: queuelog_ledger_archives; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ledger_archives (
)
INHERITS (public.queuelog_ledgers);


ALTER TABLE public.queuelog_ledger_archives OWNER TO postgres;

--
-- Name: queuelog_ledger_archives_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ledger_archives_in (
)
INHERITS (public.queuelog_ledger_archives);


ALTER TABLE public.queuelog_ledger_archives_in OWNER TO postgres;

--
-- Name: queuelog_ledger_archives_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ledger_archives_out (
)
INHERITS (public.queuelog_ledger_archives);


ALTER TABLE public.queuelog_ledger_archives_out OWNER TO postgres;

--
-- Name: queuelog_ledger_pendings; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ledger_pendings (
)
INHERITS (public.queuelog_ledgers);


ALTER TABLE public.queuelog_ledger_pendings OWNER TO postgres;

--
-- Name: queuelog_ledger_pendings_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ledger_pendings_in (
)
INHERITS (public.queuelog_ledger_pendings);


ALTER TABLE public.queuelog_ledger_pendings_in OWNER TO postgres;

--
-- Name: queuelog_ledger_pendings_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ledger_pendings_out (
)
INHERITS (public.queuelog_ledger_pendings);


ALTER TABLE public.queuelog_ledger_pendings_out OWNER TO postgres;

--
-- Name: queuelog_ledger_sents; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ledger_sents (
)
INHERITS (public.queuelog_ledgers);


ALTER TABLE public.queuelog_ledger_sents OWNER TO postgres;

--
-- Name: queuelog_ledger_sents_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ledger_sents_in (
)
INHERITS (public.queuelog_ledger_sents);


ALTER TABLE public.queuelog_ledger_sents_in OWNER TO postgres;

--
-- Name: queuelog_ledger_sents_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ledger_sents_out (
)
INHERITS (public.queuelog_ledger_sents);


ALTER TABLE public.queuelog_ledger_sents_out OWNER TO postgres;

--
-- Name: queuelog_ledgers_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ledgers_in (
)
INHERITS (public.queuelog_ledgers);


ALTER TABLE public.queuelog_ledgers_in OWNER TO postgres;

--
-- Name: queuelog_ledgers_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ledgers_out (
)
INHERITS (public.queuelog_ledgers);


ALTER TABLE public.queuelog_ledgers_out OWNER TO postgres;

--
-- Name: queuelog_meetings; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meetings (
)
INHERITS (public.queuelog);


ALTER TABLE public.queuelog_meetings OWNER TO postgres;

--
-- Name: queuelog_meeting_archiveds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meeting_archiveds (
)
INHERITS (public.queuelog_meetings);


ALTER TABLE public.queuelog_meeting_archiveds OWNER TO postgres;

--
-- Name: queuelog_meeting_archiveds_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meeting_archiveds_in (
)
INHERITS (public.queuelog_meeting_archiveds);


ALTER TABLE public.queuelog_meeting_archiveds_in OWNER TO postgres;

--
-- Name: queuelog_meeting_archiveds_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meeting_archiveds_out (
)
INHERITS (public.queuelog_meeting_archiveds);


ALTER TABLE public.queuelog_meeting_archiveds_out OWNER TO postgres;

--
-- Name: queuelog_meeting_completeds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meeting_completeds (
)
INHERITS (public.queuelog_meetings);


ALTER TABLE public.queuelog_meeting_completeds OWNER TO postgres;

--
-- Name: queuelog_meeting_completeds_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meeting_completeds_in (
)
INHERITS (public.queuelog_meeting_completeds);


ALTER TABLE public.queuelog_meeting_completeds_in OWNER TO postgres;

--
-- Name: queuelog_meeting_completeds_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meeting_completeds_out (
)
INHERITS (public.queuelog_meeting_completeds);


ALTER TABLE public.queuelog_meeting_completeds_out OWNER TO postgres;

--
-- Name: queuelog_meeting_followups; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meeting_followups (
)
INHERITS (public.queuelog_meetings);


ALTER TABLE public.queuelog_meeting_followups OWNER TO postgres;

--
-- Name: queuelog_meeting_followups_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meeting_followups_in (
)
INHERITS (public.queuelog_meeting_followups);


ALTER TABLE public.queuelog_meeting_followups_in OWNER TO postgres;

--
-- Name: queuelog_meeting_followups_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meeting_followups_out (
)
INHERITS (public.queuelog_meeting_followups);


ALTER TABLE public.queuelog_meeting_followups_out OWNER TO postgres;

--
-- Name: queuelog_meeting_initiates; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meeting_initiates (
)
INHERITS (public.queuelog_meetings);


ALTER TABLE public.queuelog_meeting_initiates OWNER TO postgres;

--
-- Name: queuelog_meeting_initiates_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meeting_initiates_in (
)
INHERITS (public.queuelog_meeting_initiates);


ALTER TABLE public.queuelog_meeting_initiates_in OWNER TO postgres;

--
-- Name: queuelog_meeting_initiates_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meeting_initiates_out (
)
INHERITS (public.queuelog_meeting_initiates);


ALTER TABLE public.queuelog_meeting_initiates_out OWNER TO postgres;

--
-- Name: queuelog_meeting_pendings; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meeting_pendings (
)
INHERITS (public.queuelog_meetings);


ALTER TABLE public.queuelog_meeting_pendings OWNER TO postgres;

--
-- Name: queuelog_meeting_pendings_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meeting_pendings_in (
)
INHERITS (public.queuelog_meeting_pendings);


ALTER TABLE public.queuelog_meeting_pendings_in OWNER TO postgres;

--
-- Name: queuelog_meeting_pendings_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meeting_pendings_out (
)
INHERITS (public.queuelog_meeting_pendings);


ALTER TABLE public.queuelog_meeting_pendings_out OWNER TO postgres;

--
-- Name: queuelog_meetings_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meetings_in (
)
INHERITS (public.queuelog_meetings);


ALTER TABLE public.queuelog_meetings_in OWNER TO postgres;

--
-- Name: queuelog_meetings_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_meetings_out (
)
INHERITS (public.queuelog_meetings);


ALTER TABLE public.queuelog_meetings_out OWNER TO postgres;

--
-- Name: queuelog_myaccounts; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccounts (
)
INHERITS (public.queuelog);


ALTER TABLE public.queuelog_myaccounts OWNER TO postgres;

--
-- Name: queuelog_myaccount_hiddens; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_hiddens (
)
INHERITS (public.queuelog_myaccounts);


ALTER TABLE public.queuelog_myaccount_hiddens OWNER TO postgres;

--
-- Name: queuelog_myaccount_hiddens_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_hiddens_in (
)
INHERITS (public.queuelog_myaccount_hiddens);


ALTER TABLE public.queuelog_myaccount_hiddens_in OWNER TO postgres;

--
-- Name: queuelog_myaccount_hiddens_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_hiddens_out (
)
INHERITS (public.queuelog_myaccount_hiddens);


ALTER TABLE public.queuelog_myaccount_hiddens_out OWNER TO postgres;

--
-- Name: queuelog_myaccount_rafs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_rafs (
)
INHERITS (public.queuelog_myaccounts);


ALTER TABLE public.queuelog_myaccount_rafs OWNER TO postgres;

--
-- Name: queuelog_myaccount_raf_dues; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_raf_dues (
)
INHERITS (public.queuelog_myaccount_rafs);


ALTER TABLE public.queuelog_myaccount_raf_dues OWNER TO postgres;

--
-- Name: queuelog_myaccount_raf_dues_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_raf_dues_in (
)
INHERITS (public.queuelog_myaccount_raf_dues);


ALTER TABLE public.queuelog_myaccount_raf_dues_in OWNER TO postgres;

--
-- Name: queuelog_myaccount_raf_dues_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_raf_dues_out (
)
INHERITS (public.queuelog_myaccount_raf_dues);


ALTER TABLE public.queuelog_myaccount_raf_dues_out OWNER TO postgres;

--
-- Name: queuelog_myaccount_raf_earneds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_raf_earneds (
)
INHERITS (public.queuelog_myaccount_rafs);


ALTER TABLE public.queuelog_myaccount_raf_earneds OWNER TO postgres;

--
-- Name: queuelog_myaccount_raf_earneds_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_raf_earneds_in (
)
INHERITS (public.queuelog_myaccount_raf_earneds);


ALTER TABLE public.queuelog_myaccount_raf_earneds_in OWNER TO postgres;

--
-- Name: queuelog_myaccount_raf_earneds_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_raf_earneds_out (
)
INHERITS (public.queuelog_myaccount_raf_earneds);


ALTER TABLE public.queuelog_myaccount_raf_earneds_out OWNER TO postgres;

--
-- Name: queuelog_myaccount_raf_paids; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_raf_paids (
)
INHERITS (public.queuelog_myaccount_rafs);


ALTER TABLE public.queuelog_myaccount_raf_paids OWNER TO postgres;

--
-- Name: queuelog_myaccount_raf_paids_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_raf_paids_in (
)
INHERITS (public.queuelog_myaccount_raf_paids);


ALTER TABLE public.queuelog_myaccount_raf_paids_in OWNER TO postgres;

--
-- Name: queuelog_myaccount_raf_paids_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_raf_paids_out (
)
INHERITS (public.queuelog_myaccount_raf_paids);


ALTER TABLE public.queuelog_myaccount_raf_paids_out OWNER TO postgres;

--
-- Name: queuelog_myaccount_raf_pendings; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_raf_pendings (
)
INHERITS (public.queuelog_myaccount_rafs);


ALTER TABLE public.queuelog_myaccount_raf_pendings OWNER TO postgres;

--
-- Name: queuelog_myaccount_raf_pendings_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_raf_pendings_in (
)
INHERITS (public.queuelog_myaccount_raf_pendings);


ALTER TABLE public.queuelog_myaccount_raf_pendings_in OWNER TO postgres;

--
-- Name: queuelog_myaccount_raf_pendings_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_raf_pendings_out (
)
INHERITS (public.queuelog_myaccount_raf_pendings);


ALTER TABLE public.queuelog_myaccount_raf_pendings_out OWNER TO postgres;

--
-- Name: queuelog_myaccount_rafs_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_rafs_in (
)
INHERITS (public.queuelog_myaccount_rafs);


ALTER TABLE public.queuelog_myaccount_rafs_in OWNER TO postgres;

--
-- Name: queuelog_myaccount_rafs_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccount_rafs_out (
)
INHERITS (public.queuelog_myaccount_rafs);


ALTER TABLE public.queuelog_myaccount_rafs_out OWNER TO postgres;

--
-- Name: queuelog_myaccounts_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccounts_in (
)
INHERITS (public.queuelog_myaccounts);


ALTER TABLE public.queuelog_myaccounts_in OWNER TO postgres;

--
-- Name: queuelog_myaccounts_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_myaccounts_out (
)
INHERITS (public.queuelog_myaccounts);


ALTER TABLE public.queuelog_myaccounts_out OWNER TO postgres;

--
-- Name: queuelog_ops; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops (
)
INHERITS (public.queuelog);


ALTER TABLE public.queuelog_ops OWNER TO postgres;

--
-- Name: queuelog_ops_contacts; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_contacts (
)
INHERITS (public.queuelog_ops);


ALTER TABLE public.queuelog_ops_contacts OWNER TO postgres;

--
-- Name: queuelog_ops_contact_faileds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_contact_faileds (
)
INHERITS (public.queuelog_ops_contacts);


ALTER TABLE public.queuelog_ops_contact_faileds OWNER TO postgres;

--
-- Name: queuelog_ops_contact_faileds_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_contact_faileds_in (
)
INHERITS (public.queuelog_ops_contact_faileds);


ALTER TABLE public.queuelog_ops_contact_faileds_in OWNER TO postgres;

--
-- Name: queuelog_ops_contact_faileds_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_contact_faileds_out (
)
INHERITS (public.queuelog_ops_contact_faileds);


ALTER TABLE public.queuelog_ops_contact_faileds_out OWNER TO postgres;

--
-- Name: queuelog_ops_contact_inbounds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_contact_inbounds (
)
INHERITS (public.queuelog_ops_contacts);


ALTER TABLE public.queuelog_ops_contact_inbounds OWNER TO postgres;

--
-- Name: queuelog_ops_contact_inbounds_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_contact_inbounds_in (
)
INHERITS (public.queuelog_ops_contact_inbounds);


ALTER TABLE public.queuelog_ops_contact_inbounds_in OWNER TO postgres;

--
-- Name: queuelog_ops_contact_inbounds_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_contact_inbounds_out (
)
INHERITS (public.queuelog_ops_contact_inbounds);


ALTER TABLE public.queuelog_ops_contact_inbounds_out OWNER TO postgres;

--
-- Name: queuelog_ops_contact_initiates; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_contact_initiates (
)
INHERITS (public.queuelog_ops_contacts);


ALTER TABLE public.queuelog_ops_contact_initiates OWNER TO postgres;

--
-- Name: queuelog_ops_contact_initiates_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_contact_initiates_in (
)
INHERITS (public.queuelog_ops_contact_initiates);


ALTER TABLE public.queuelog_ops_contact_initiates_in OWNER TO postgres;

--
-- Name: queuelog_ops_contact_initiates_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_contact_initiates_out (
)
INHERITS (public.queuelog_ops_contact_initiates);


ALTER TABLE public.queuelog_ops_contact_initiates_out OWNER TO postgres;

--
-- Name: queuelog_ops_contact_reacheds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_contact_reacheds (
)
INHERITS (public.queuelog_ops_contacts);


ALTER TABLE public.queuelog_ops_contact_reacheds OWNER TO postgres;

--
-- Name: queuelog_ops_contact_reacheds_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_contact_reacheds_in (
)
INHERITS (public.queuelog_ops_contact_reacheds);


ALTER TABLE public.queuelog_ops_contact_reacheds_in OWNER TO postgres;

--
-- Name: queuelog_ops_contact_reacheds_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_contact_reacheds_out (
)
INHERITS (public.queuelog_ops_contact_reacheds);


ALTER TABLE public.queuelog_ops_contact_reacheds_out OWNER TO postgres;

--
-- Name: queuelog_ops_contact_requireds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_contact_requireds (
)
INHERITS (public.queuelog_ops_contacts);


ALTER TABLE public.queuelog_ops_contact_requireds OWNER TO postgres;

--
-- Name: queuelog_ops_contact_requireds_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_contact_requireds_in (
    reason text
)
INHERITS (public.queuelog_ops_contact_requireds);


ALTER TABLE public.queuelog_ops_contact_requireds_in OWNER TO postgres;

--
-- Name: queuelog_ops_contact_requireds_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_contact_requireds_out (
    reason text
)
INHERITS (public.queuelog_ops_contact_requireds);


ALTER TABLE public.queuelog_ops_contact_requireds_out OWNER TO postgres;

--
-- Name: queuelog_ops_data_entrys; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_data_entrys (
)
INHERITS (public.queuelog_ops);


ALTER TABLE public.queuelog_ops_data_entrys OWNER TO postgres;

--
-- Name: queuelog_ops_data_entrys_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_data_entrys_in (
)
INHERITS (public.queuelog_ops_data_entrys);


ALTER TABLE public.queuelog_ops_data_entrys_in OWNER TO postgres;

--
-- Name: queuelog_ops_data_entrys_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_ops_data_entrys_out (
)
INHERITS (public.queuelog_ops_data_entrys);


ALTER TABLE public.queuelog_ops_data_entrys_out OWNER TO postgres;

--
-- Name: queuelog_reviews; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_reviews (
)
INHERITS (public.queuelog);


ALTER TABLE public.queuelog_reviews OWNER TO postgres;

--
-- Name: queuelog_review_approveds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_approveds (
)
INHERITS (public.queuelog_reviews);


ALTER TABLE public.queuelog_review_approveds OWNER TO postgres;

--
-- Name: queuelog_review_approveds_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_approveds_in (
)
INHERITS (public.queuelog_review_approveds);


ALTER TABLE public.queuelog_review_approveds_in OWNER TO postgres;

--
-- Name: queuelog_review_approveds_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_approveds_out (
)
INHERITS (public.queuelog_review_approveds);


ALTER TABLE public.queuelog_review_approveds_out OWNER TO postgres;

--
-- Name: queuelog_review_calls; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_calls (
)
INHERITS (public.queuelog_reviews);


ALTER TABLE public.queuelog_review_calls OWNER TO postgres;

--
-- Name: queuelog_review_call_archives; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_archives (
)
INHERITS (public.queuelog_review_calls);


ALTER TABLE public.queuelog_review_call_archives OWNER TO postgres;

--
-- Name: queuelog_review_call_archives_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_archives_in (
)
INHERITS (public.queuelog_review_call_archives);


ALTER TABLE public.queuelog_review_call_archives_in OWNER TO postgres;

--
-- Name: queuelog_review_call_archives_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_archives_out (
)
INHERITS (public.queuelog_review_call_archives);


ALTER TABLE public.queuelog_review_call_archives_out OWNER TO postgres;

--
-- Name: queuelog_review_call_assigneds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_assigneds (
)
INHERITS (public.queuelog_review_calls);


ALTER TABLE public.queuelog_review_call_assigneds OWNER TO postgres;

--
-- Name: queuelog_review_call_assigneds_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_assigneds_in (
)
INHERITS (public.queuelog_review_call_assigneds);


ALTER TABLE public.queuelog_review_call_assigneds_in OWNER TO postgres;

--
-- Name: queuelog_review_call_assigneds_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_assigneds_out (
)
INHERITS (public.queuelog_review_call_assigneds);


ALTER TABLE public.queuelog_review_call_assigneds_out OWNER TO postgres;

--
-- Name: queuelog_review_call_completeds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_completeds (
)
INHERITS (public.queuelog_review_calls);


ALTER TABLE public.queuelog_review_call_completeds OWNER TO postgres;

--
-- Name: queuelog_review_call_completeds_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_completeds_in (
)
INHERITS (public.queuelog_review_call_completeds);


ALTER TABLE public.queuelog_review_call_completeds_in OWNER TO postgres;

--
-- Name: queuelog_review_call_completeds_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_completeds_out (
)
INHERITS (public.queuelog_review_call_completeds);


ALTER TABLE public.queuelog_review_call_completeds_out OWNER TO postgres;

--
-- Name: queuelog_review_call_faileds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_faileds (
)
INHERITS (public.queuelog_review_calls);


ALTER TABLE public.queuelog_review_call_faileds OWNER TO postgres;

--
-- Name: queuelog_review_call_faileds_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_faileds_in (
)
INHERITS (public.queuelog_review_call_faileds);


ALTER TABLE public.queuelog_review_call_faileds_in OWNER TO postgres;

--
-- Name: queuelog_review_call_faileds_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_faileds_out (
)
INHERITS (public.queuelog_review_call_faileds);


ALTER TABLE public.queuelog_review_call_faileds_out OWNER TO postgres;

--
-- Name: queuelog_review_call_passeds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_passeds (
)
INHERITS (public.queuelog_review_calls);


ALTER TABLE public.queuelog_review_call_passeds OWNER TO postgres;

--
-- Name: queuelog_review_call_passeds_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_passeds_in (
)
INHERITS (public.queuelog_review_call_passeds);


ALTER TABLE public.queuelog_review_call_passeds_in OWNER TO postgres;

--
-- Name: queuelog_review_call_passeds_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_passeds_out (
)
INHERITS (public.queuelog_review_call_passeds);


ALTER TABLE public.queuelog_review_call_passeds_out OWNER TO postgres;

--
-- Name: queuelog_review_call_pendings; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_pendings (
)
INHERITS (public.queuelog_review_calls);


ALTER TABLE public.queuelog_review_call_pendings OWNER TO postgres;

--
-- Name: queuelog_review_call_pendings_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_pendings_in (
)
INHERITS (public.queuelog_review_call_pendings);


ALTER TABLE public.queuelog_review_call_pendings_in OWNER TO postgres;

--
-- Name: queuelog_review_call_pendings_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_call_pendings_out (
)
INHERITS (public.queuelog_review_call_pendings);


ALTER TABLE public.queuelog_review_call_pendings_out OWNER TO postgres;

--
-- Name: queuelog_review_calls_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_calls_in (
)
INHERITS (public.queuelog_review_calls);


ALTER TABLE public.queuelog_review_calls_in OWNER TO postgres;

--
-- Name: queuelog_review_calls_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_calls_out (
)
INHERITS (public.queuelog_review_calls);


ALTER TABLE public.queuelog_review_calls_out OWNER TO postgres;

--
-- Name: queuelog_review_pendings; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_pendings (
)
INHERITS (public.queuelog_reviews);


ALTER TABLE public.queuelog_review_pendings OWNER TO postgres;

--
-- Name: queuelog_review_pendings_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_pendings_in (
)
INHERITS (public.queuelog_review_pendings);


ALTER TABLE public.queuelog_review_pendings_in OWNER TO postgres;

--
-- Name: queuelog_review_pendings_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_pendings_out (
)
INHERITS (public.queuelog_review_pendings);


ALTER TABLE public.queuelog_review_pendings_out OWNER TO postgres;

--
-- Name: queuelog_review_rejecteds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_rejecteds (
)
INHERITS (public.queuelog_reviews);


ALTER TABLE public.queuelog_review_rejecteds OWNER TO postgres;

--
-- Name: queuelog_review_rejecteds_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_rejecteds_in (
)
INHERITS (public.queuelog_review_rejecteds);


ALTER TABLE public.queuelog_review_rejecteds_in OWNER TO postgres;

--
-- Name: queuelog_review_rejecteds_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_review_rejecteds_out (
)
INHERITS (public.queuelog_review_rejecteds);


ALTER TABLE public.queuelog_review_rejecteds_out OWNER TO postgres;

--
-- Name: queuelog_upload_orderss; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_upload_orderss (
)
INHERITS (public.queuelog);


ALTER TABLE public.queuelog_upload_orderss OWNER TO postgres;

--
-- Name: queuelog_upload_orders_sents; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_upload_orders_sents (
)
INHERITS (public.queuelog_upload_orderss);


ALTER TABLE public.queuelog_upload_orders_sents OWNER TO postgres;

--
-- Name: queuelog_upload_orders_sents_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_upload_orders_sents_in (
)
INHERITS (public.queuelog_upload_orders_sents);


ALTER TABLE public.queuelog_upload_orders_sents_in OWNER TO postgres;

--
-- Name: queuelog_upload_orders_sents_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_upload_orders_sents_out (
)
INHERITS (public.queuelog_upload_orders_sents);


ALTER TABLE public.queuelog_upload_orders_sents_out OWNER TO postgres;

--
-- Name: queuelog_uploads; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queuelog_uploads (
)
INHERITS (public.queuelog);


ALTER TABLE public.queuelog_uploads OWNER TO postgres;

--
-- Name: queulog_cart_actives_in; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queulog_cart_actives_in (
)
INHERITS (public.queuelog_cart_actives);


ALTER TABLE public.queulog_cart_actives_in OWNER TO postgres;

--
-- Name: queulog_cart_actives_out; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.queulog_cart_actives_out (
)
INHERITS (public.queuelog_cart_actives);


ALTER TABLE public.queulog_cart_actives_out OWNER TO postgres;

--
-- Name: quickbooks; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.quickbooks (
    id bigint,
    vendor character varying(100),
    state character(2),
    period character(6),
    booked_upfront numeric(12,2),
    booked_residual numeric(12,2),
    commission_upfront numeric(12,2),
    commission_residual numeric(12,2),
    ticket_id bigint,
    modified timestamp without time zone,
    writeoff_upfront numeric(12,2),
    writeoff_residual numeric(12,2),
    extra_upfront numeric(12,2),
    extra_residual numeric(12,2),
    affiliate character varying(50),
    affiliate_upfront numeric(12,2),
    affiliate_residual numeric(12,2),
    affiliate_paid_upfront numeric(12,2),
    affiliate_paid_residual numeric(12,2)
);


ALTER TABLE public.quickbooks OWNER TO postgres;

--
-- Name: rating_category; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.rating_category (
    id bigint NOT NULL,
    name text NOT NULL,
    description text NOT NULL
);


ALTER TABLE public.rating_category OWNER TO phpuser;

--
-- Name: rating_category_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.rating_category_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.rating_category_id_seq OWNER TO phpuser;

--
-- Name: rating_category_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.rating_category_id_seq OWNED BY public.rating_category.id;


--
-- Name: rating_category_rating_criteria; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.rating_category_rating_criteria (
    id bigint NOT NULL,
    rating_category_id bigint,
    rating_criteria_id bigint
);


ALTER TABLE public.rating_category_rating_criteria OWNER TO phpuser;

--
-- Name: rating_category_rating_criteria_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.rating_category_rating_criteria_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.rating_category_rating_criteria_id_seq OWNER TO phpuser;

--
-- Name: rating_category_rating_criteria_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.rating_category_rating_criteria_id_seq OWNED BY public.rating_category_rating_criteria.id;


--
-- Name: rating_criteria; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.rating_criteria (
    id bigint NOT NULL,
    name text NOT NULL,
    description text NOT NULL,
    user_ratable integer DEFAULT 1,
    state character varying(2)
);


ALTER TABLE public.rating_criteria OWNER TO phpuser;

--
-- Name: rating_criteria_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.rating_criteria_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.rating_criteria_id_seq OWNER TO phpuser;

--
-- Name: rating_criteria_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.rating_criteria_id_seq OWNED BY public.rating_criteria.id;


--
-- Name: rating_formula; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.rating_formula (
    id bigint NOT NULL,
    name text NOT NULL,
    description text NOT NULL,
    state character varying(2)
);


ALTER TABLE public.rating_formula OWNER TO phpuser;

--
-- Name: rating_formula_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.rating_formula_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.rating_formula_id_seq OWNER TO phpuser;

--
-- Name: rating_formula_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.rating_formula_id_seq OWNED BY public.rating_formula.id;


--
-- Name: rating_formula_rating_criteria; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.rating_formula_rating_criteria (
    id bigint NOT NULL,
    rating_formula_id bigint,
    rating_criteria_id bigint,
    weight integer DEFAULT 1
);


ALTER TABLE public.rating_formula_rating_criteria OWNER TO phpuser;

--
-- Name: rating_formula_rating_criteria_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.rating_formula_rating_criteria_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.rating_formula_rating_criteria_id_seq OWNER TO phpuser;

--
-- Name: rating_formula_rating_criteria_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.rating_formula_rating_criteria_id_seq OWNED BY public.rating_formula_rating_criteria.id;


--
-- Name: ratings; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.ratings (
    id bigint NOT NULL,
    item_id bigint NOT NULL,
    rating_criteria_id bigint NOT NULL,
    review_id bigint NOT NULL,
    score double precision NOT NULL
);


ALTER TABLE public.ratings OWNER TO phpuser;

--
-- Name: ratings_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.ratings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ratings_id_seq OWNER TO phpuser;

--
-- Name: ratings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.ratings_id_seq OWNED BY public.ratings.id;


--
-- Name: recipie_data; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.recipie_data (
    google_sheet_id text,
    plan_id bigint,
    tx_upfront numeric(6,2),
    tx_mills bigint,
    tx_usage bigint,
    mill_value numeric(5,2),
    term bigint,
    total_mills numeric(6,2),
    mill_npv numeric(6,2),
    renewal_pct numeric(5,2),
    renewal_value numeric(6,2),
    accept_value numeric(6,2),
    accept_pct numeric(5,2),
    submit_value numeric(6,2),
    submit_pct numeric(5,2),
    xsell_value numeric(6,2),
    xsell_pct numeric(5,2),
    cart_value numeric(6,2),
    clicks_per_view numeric(5,3),
    market_price numeric(6,3),
    plan_price numeric(6,1),
    percent_of_market numeric(6,2),
    adjusted_clicks_per_view numeric(5,3),
    view_value numeric(6,2),
    company character varying(1),
    desktop character varying(1),
    mobile character varying(1),
    rep text,
    plan text,
    old_sort_order bigint,
    new_sort_order bigint,
    friend_linkoff_phone bigint,
    friend_reporting bigint,
    friend_strategic bigint,
    friend_tactical bigint,
    friend_deep_links bigint,
    friend_usp bigint,
    friend_simple bigint,
    friend_bighouse bigint,
    friend_mediumhouse bigint,
    friend_smallhouse bigint,
    friend_rewards bigint,
    friend_promos bigint,
    friend_deposits bigint,
    partner_score bigint,
    overall_score bigint,
    plan_clicks_yesterday bigint,
    rep_clicks_yesterday bigint,
    click_adjustment numeric(6,0),
    customer_type character varying(1)
);


ALTER TABLE public.recipie_data OWNER TO phpuser;

--
-- Name: recipies; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.recipies (
    start_date date,
    end_date date,
    google_sheet_id text
);


ALTER TABLE public.recipies OWNER TO phpuser;

--
-- Name: rep_blocks; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.rep_blocks (
    id bigint NOT NULL,
    rep_id numeric,
    name text,
    content bytea,
    created timestamp with time zone,
    modified timestamp with time zone DEFAULT now() NOT NULL
);


ALTER TABLE public.rep_blocks OWNER TO phpuser;

--
-- Name: rep_blocks_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.rep_blocks_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.rep_blocks_id_seq OWNER TO phpuser;

--
-- Name: rep_blocks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.rep_blocks_id_seq OWNED BY public.rep_blocks.id;


--
-- Name: rep_complaints; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.rep_complaints (
    id bigint,
    rep_id bigint,
    rep_scrape_id bigint,
    rep_name character varying(255),
    docket_number character varying(25),
    status character varying(25),
    date_filed date,
    complaint text,
    created timestamp without time zone,
    state character(2)
);


ALTER TABLE public.rep_complaints OWNER TO postgres;

--
-- Name: rep_complaints_current; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.rep_complaints_current (
    string character varying(4),
    rep character varying(255)
);


ALTER TABLE public.rep_complaints_current OWNER TO postgres;

--
-- Name: rep_complaints_summary; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.rep_complaints_summary (
    id bigint,
    rep_id bigint,
    rep_scrape_id bigint,
    rep_name character varying(255),
    year integer,
    month integer,
    customers integer,
    size_scale integer,
    billing_complaints integer,
    service_complaints integer,
    marketing_complaints integer,
    avg_temp integer,
    hdds integer,
    cdds integer,
    state character(2),
    total_complaints integer
);


ALTER TABLE public.rep_complaints_summary OWNER TO postgres;

--
-- Name: rep_efls; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.rep_efls (
    id bigint NOT NULL,
    rep_id bigint,
    plan_id bigint,
    market_id bigint,
    effective_date date,
    path text,
    url text
);


ALTER TABLE public.rep_efls OWNER TO phpuser;

--
-- Name: rep_efls_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.rep_efls_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.rep_efls_id_seq OWNER TO phpuser;

--
-- Name: rep_efls_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.rep_efls_id_seq OWNED BY public.rep_efls.id;


--
-- Name: rep_info; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.rep_info (
    id bigint NOT NULL,
    rep_id bigint,
    logo text,
    description text,
    contact text,
    email text,
    phone text,
    addr1 text,
    addr2 text,
    city text,
    state text,
    zip text,
    status character varying(1) DEFAULT 'a'::character varying
);


ALTER TABLE public.rep_info OWNER TO phpuser;

--
-- Name: rep_info_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.rep_info_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.rep_info_id_seq OWNER TO phpuser;

--
-- Name: rep_info_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.rep_info_id_seq OWNED BY public.rep_info.id;


--
-- Name: rep_info_to_market; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.rep_info_to_market (
    id bigint NOT NULL,
    rep_info_id bigint NOT NULL,
    market_id bigint NOT NULL
);


ALTER TABLE public.rep_info_to_market OWNER TO phpuser;

--
-- Name: rep_info_to_market_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.rep_info_to_market_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.rep_info_to_market_id_seq OWNER TO phpuser;

--
-- Name: rep_info_to_market_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.rep_info_to_market_id_seq OWNED BY public.rep_info_to_market.id;


--
-- Name: rep_moneys; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.rep_moneys (
    id bigint NOT NULL,
    rep_id bigint,
    period character varying(6),
    value numeric(12,2)
);


ALTER TABLE public.rep_moneys OWNER TO phpuser;

--
-- Name: rep_moneys_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.rep_moneys_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.rep_moneys_id_seq OWNER TO phpuser;

--
-- Name: rep_moneys_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.rep_moneys_id_seq OWNED BY public.rep_moneys.id;


--
-- Name: rep_puc; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.rep_puc (
    id bigint NOT NULL,
    rep_id bigint,
    commodity text,
    state text,
    market_id bigint,
    value text
);


ALTER TABLE public.rep_puc OWNER TO phpuser;

--
-- Name: rep_puc_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.rep_puc_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.rep_puc_id_seq OWNER TO phpuser;

--
-- Name: rep_puc_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.rep_puc_id_seq OWNED BY public.rep_puc.id;


--
-- Name: rep_scores; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.rep_scores (
    id bigint NOT NULL,
    rep_id bigint,
    state character varying(2),
    criteria_1 text,
    criteria_2 text,
    value bigint,
    weight bigint,
    modified timestamp with time zone DEFAULT now() NOT NULL
);


ALTER TABLE public.rep_scores OWNER TO phpuser;

--
-- Name: rep_scores_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.rep_scores_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.rep_scores_id_seq OWNER TO phpuser;

--
-- Name: rep_scores_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.rep_scores_id_seq OWNED BY public.rep_scores.id;


--
-- Name: rep_scrapes; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.rep_scrapes (
    name character varying(255),
    rep_id integer,
    id bigint
);


ALTER TABLE public.rep_scrapes OWNER TO postgres;

--
-- Name: rep_states; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.rep_states (
    id bigint NOT NULL,
    rep_id bigint,
    state text,
    type text,
    status character varying(1) DEFAULT 'a'::character varying NOT NULL,
    state_value text
);


ALTER TABLE public.rep_states OWNER TO phpuser;

--
-- Name: rep_states_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.rep_states_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.rep_states_id_seq OWNER TO phpuser;

--
-- Name: rep_states_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.rep_states_id_seq OWNED BY public.rep_states.id;


--
-- Name: rep_users; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.rep_users (
    id bigint NOT NULL,
    rep_id bigint,
    username text,
    password text,
    date timestamp with time zone DEFAULT now() NOT NULL,
    f_name text,
    l_name text,
    job_title text NOT NULL,
    email_addr text,
    phone text,
    disposition public.rep_users_disposition,
    account_status public.rep_users_account_status,
    accept_decline_status public.rep_users_accept_decline_status,
    decline_reason text,
    deactivate_reason text,
    ctime timestamp with time zone
);


ALTER TABLE public.rep_users OWNER TO phpuser;

--
-- Name: rep_users_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.rep_users_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.rep_users_id_seq OWNER TO phpuser;

--
-- Name: rep_users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.rep_users_id_seq OWNED BY public.rep_users.id;


--
-- Name: reps; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.reps (
    id bigint NOT NULL,
    name text,
    ptc_name text,
    slug text,
    model text,
    logo text,
    logo_big text,
    description text,
    old_rep_id character varying(20),
    status character varying(1) DEFAULT 'a'::character varying,
    contact text,
    email text,
    phone text,
    addr1 text,
    addr2 text,
    city text,
    state text,
    zip text,
    credit_threshold bigint,
    ctime timestamp with time zone,
    regulatory_identifier text,
    yrac_url text,
    use_cart character varying(1),
    use_ter_phone character varying(1),
    review_blurb text,
    use_cart_tx character varying(1) DEFAULT 'n'::character varying NOT NULL,
    use_cart_ct character varying(1) DEFAULT 'n'::character varying NOT NULL,
    use_cart_ny character varying(1) DEFAULT 'n'::character varying NOT NULL,
    use_cart_ga character varying(1) DEFAULT 'n'::character varying NOT NULL,
    use_ter_phone_tx character varying(1) DEFAULT 'n'::character varying NOT NULL,
    phone_tx text,
    use_ter_phone_ct character varying(1) DEFAULT 'n'::character varying NOT NULL,
    phone_ct text,
    use_ter_phone_ny character varying(1) DEFAULT 'n'::character varying NOT NULL,
    phone_ny text,
    use_ter_phone_ga character varying(1) DEFAULT 'n'::character varying NOT NULL,
    phone_ga text,
    regulatory_identifier_tx text,
    regulatory_identifier_ct text,
    regulatory_identifier_ny text,
    regulatory_identifier_ga text,
    market_status character varying(1),
    market_status_tx character varying(1) DEFAULT 'n'::character varying NOT NULL,
    market_status_ga character varying(1) DEFAULT 'n'::character varying NOT NULL,
    market_status_ct character varying(1) DEFAULT 'n'::character varying NOT NULL,
    market_status_ny character varying(1) DEFAULT 'n'::character varying NOT NULL,
    status_tx character varying(1) DEFAULT 'n'::character varying NOT NULL,
    status_ga character varying(1) DEFAULT 'n'::character varying NOT NULL,
    status_ct character varying(1) DEFAULT 'n'::character varying NOT NULL,
    status_ny character varying(1) DEFAULT 'n'::character varying NOT NULL,
    score_tx numeric(7,3),
    tx_customers bigint,
    score_ga numeric(7,3),
    ga_customers bigint,
    score_ct numeric(7,3),
    ct_customers bigint,
    score_ny numeric(7,3),
    ny_customers bigint,
    score_ma numeric(7,3),
    ma_customers bigint,
    market_status_ma character varying(1) DEFAULT 'n'::character varying NOT NULL,
    regulatory_identifier_ma text,
    use_cart_ma character varying(1) DEFAULT 'n'::character varying NOT NULL,
    use_phone_ma character varying(1),
    market_status_ca character varying(1) DEFAULT 'n'::character varying NOT NULL,
    use_linkoff character varying(1) DEFAULT 'y'::character varying,
    commercial_email_tx text,
    commercial_email_ny text,
    commercial_email_ga text,
    commercial_email_ct text,
    use_cart_dc character varying(1),
    use_ter_phone_dc character varying(1),
    phone_dc text,
    regulatory_identifier_dc text,
    market_status_dc character varying(1),
    status_dc character varying(1),
    score_dc numeric(7,3),
    dc_customers bigint,
    use_cart_md character varying(1) DEFAULT 'n'::character varying NOT NULL,
    use_ter_phone_md character varying(1) DEFAULT 'n'::character varying NOT NULL,
    phone_md text,
    regulatory_identifier_md text,
    market_status_md character varying(1) DEFAULT 'n'::character varying NOT NULL,
    status_md character varying(1) DEFAULT 'n'::character varying NOT NULL,
    score_md numeric(7,3),
    md_xsell numeric(5,2),
    md_customers bigint,
    use_cart_nj character varying(1) DEFAULT 'n'::character varying NOT NULL,
    use_ter_phone_nj character varying(1) DEFAULT 'n'::character varying NOT NULL,
    phone_nj text,
    regulatory_identifier_nj text,
    market_status_nj character varying(1) DEFAULT 'n'::character varying NOT NULL,
    status_nj character varying(1) DEFAULT 'n'::character varying NOT NULL,
    score_nj numeric(7,3),
    nj_customers bigint,
    use_cart_oh character varying(1) DEFAULT 'n'::character varying NOT NULL,
    use_ter_phone_oh character varying(1) DEFAULT 'n'::character varying NOT NULL,
    phone_oh text,
    regulatory_identifier_oh text,
    market_status_oh character varying(1) DEFAULT 'n'::character varying NOT NULL,
    status_oh character varying(1) DEFAULT 'n'::character varying NOT NULL,
    score_oh numeric(7,3),
    oh_customers bigint,
    use_cart_nh character varying(1) DEFAULT 'n'::character varying NOT NULL,
    use_ter_phone_nh character varying(1) DEFAULT 'n'::character varying NOT NULL,
    phone_nh text,
    regulatory_identifier_nh text,
    market_status_nh character varying(1) DEFAULT 'n'::character varying NOT NULL,
    status_nh character varying(1) DEFAULT 'n'::character varying NOT NULL,
    score_nh numeric(7,3),
    nh_customers bigint,
    use_cart_il character varying(1) DEFAULT 'n'::character varying NOT NULL,
    use_ter_phone_il character varying(1) DEFAULT 'n'::character varying NOT NULL,
    phone_il text,
    regulatory_identifier_il text,
    market_status_il character varying(1) DEFAULT 'n'::character varying NOT NULL,
    status_il character varying(1) DEFAULT 'n'::character varying NOT NULL,
    score_il numeric(7,3),
    il_customers bigint,
    use_cart_pa character varying(1) DEFAULT 'n'::character varying NOT NULL,
    use_ter_phone_pa character varying(1) DEFAULT 'n'::character varying NOT NULL,
    phone_pa text,
    regulatory_identifier_pa text,
    market_status_pa character varying(1) DEFAULT 'n'::character varying NOT NULL,
    status_pa character varying(1) DEFAULT 'n'::character varying NOT NULL,
    score_pa numeric(7,3),
    pa_customers bigint,
    status_ma character varying(1) DEFAULT 'n'::character varying NOT NULL,
    tx_mills numeric(3,1),
    tx_upfront numeric(4,2),
    tx_usage bigint,
    tx_renewal numeric(4,1),
    tx_accept numeric(4,1),
    tx_xsell numeric(5,2),
    tx_submit numeric(4,1),
    pa_mills numeric(3,1),
    pa_upfront numeric(4,2),
    pa_usage bigint,
    pa_renewal numeric(4,1),
    pa_submit numeric(4,1),
    pa_accept numeric(4,1),
    pa_xsell numeric(5,2),
    commercial_email_pa text,
    nj_mills numeric(3,1),
    nj_upfront numeric(4,2),
    nj_usage bigint,
    nj_renewal numeric(4,1),
    nj_submit numeric(4,1),
    nj_accept numeric(4,1),
    nj_xsell numeric(5,2),
    commercial_email_nj text,
    use_ter_phone_ma character varying(1) DEFAULT 'n'::character varying NOT NULL,
    phone_ma text,
    ma_mills numeric(3,1),
    ma_upfront numeric(4,2),
    ma_usage bigint,
    ma_renewal numeric(4,1),
    ma_submit numeric(4,1),
    ma_accept numeric(4,1),
    ma_xsell numeric(5,2),
    commercial_email_ma text,
    il_mills numeric(3,1),
    il_upfront numeric(4,2),
    il_usage bigint,
    il_renewal numeric(4,1),
    il_submit numeric(4,1),
    il_accept numeric(4,1),
    il_xsell numeric(5,2),
    commercial_email_il text,
    oh_mills numeric(3,1),
    oh_upfront numeric(4,2),
    oh_usage bigint,
    oh_renewal numeric(4,1),
    oh_submit numeric(4,1),
    oh_accept numeric(4,1),
    oh_xsell numeric(5,2),
    commercial_email_oh text,
    use_cart_de character varying(1),
    use_ter_phone_de character varying(1),
    phone_de text,
    regulatory_identifier_de text,
    market_status_de character varying(1),
    status_de character varying(1),
    score_de numeric(7,3),
    de_customers bigint,
    de_mills numeric(3,1),
    de_upfront numeric(4,2),
    de_usage bigint,
    de_renewal numeric(4,1),
    de_submit numeric(4,1),
    de_accept numeric(4,1),
    de_doc1 text,
    de_doc2 text,
    de_doc3 text,
    de_doc4 text,
    de_doc5 text,
    de_doc5_label text,
    de_doc4_label text,
    de_doc3_label text,
    de_doc2_label text,
    de_doc1_label text,
    commercial_email_de text,
    md_mills numeric(3,1),
    md_upfront numeric(4,2),
    md_usage bigint,
    md_renewal numeric(4,1),
    md_submit numeric(4,1),
    md_accept numeric(4,1),
    commercial_email_md text,
    nh_mills numeric(3,1),
    nh_upfront numeric(4,2),
    nh_usage bigint,
    nh_renewal numeric(4,1),
    nh_submit numeric(4,1),
    nh_accept numeric(4,1),
    nh_xsell numeric(5,2),
    commercial_email_nh text,
    dc_mills numeric(3,1),
    dc_upfront numeric(4,2),
    dc_usage bigint,
    dc_renewal numeric(4,1),
    dc_submit numeric(4,1),
    dc_accept numeric(4,1),
    dc_doc5 text,
    dc_doc5_label text,
    dc_doc4 text,
    dc_doc4_label text,
    dc_doc3 text,
    dc_doc3_label text,
    dc_doc2 text,
    dc_doc2_label text,
    dc_doc1 text,
    dc_doc1_label text,
    commercial_email_dc text,
    use_cart_ky character varying(1),
    use_ter_phone_ky character varying(1),
    phone_ky text,
    regulatory_identifier_ky text,
    market_status_ky character varying(1),
    status_ky character varying(1),
    score_ky numeric(7,3),
    ky_mills numeric(3,1),
    ky_upfront numeric(4,2),
    ky_usage bigint,
    ky_renewal numeric(4,1),
    ky_submit numeric(4,1),
    ky_accept numeric(4,1),
    commercial_email_ky text,
    use_cart_mi character varying(1) DEFAULT 'n'::character varying NOT NULL,
    use_ter_phone_mi character varying(1) DEFAULT 'n'::character varying NOT NULL,
    phone_mi text,
    regulatory_identifier_mi text,
    market_status_mi character varying(1) DEFAULT 'n'::character varying NOT NULL,
    status_mi character varying(1) DEFAULT 'n'::character varying NOT NULL,
    score_mi numeric(7,3),
    mi_customers bigint,
    mi_mills numeric(3,1),
    mi_upfront numeric(4,2),
    mi_usage bigint,
    mi_renewal numeric(4,1),
    mi_submit numeric(4,1),
    mi_accept numeric(4,1),
    mi_xsell numeric(5,2),
    commercial_email_mi text,
    use_cart_me character varying(1) DEFAULT 'n'::character varying NOT NULL,
    use_ter_phone_me character varying(1) DEFAULT 'n'::character varying NOT NULL,
    phone_me text,
    regulatory_identifier_me text,
    market_status_me character varying(1) DEFAULT 'n'::character varying NOT NULL,
    status_me character varying(1) DEFAULT 'n'::character varying NOT NULL,
    score_me numeric(7,3),
    me_customers bigint,
    me_mills numeric(3,1),
    me_upfront numeric(4,2),
    me_usage bigint,
    me_renewal numeric(4,1),
    me_submit numeric(4,1),
    me_accept numeric(4,1),
    me_xsell numeric(5,2),
    commercial_email_me text,
    use_cart_in character varying(1),
    use_ter_phone_in character varying(1),
    phone_in text,
    regulatory_identifier_in text,
    market_status_in character varying(1),
    status_in character varying(1),
    score_in numeric(7,3),
    in_mills numeric(3,1),
    in_upfront numeric(4,2),
    in_usage bigint,
    in_renewal numeric(4,1),
    in_submit numeric(4,1),
    in_accept numeric(4,1),
    commercial_email_in text,
    use_cart_ri character varying(1) DEFAULT 'n'::character varying NOT NULL,
    use_ter_phone_ri character varying(1) DEFAULT 'n'::character varying NOT NULL,
    phone_ri text,
    regulatory_identifier_ri text,
    market_status_ri character varying(1) DEFAULT 'n'::character varying NOT NULL,
    status_ri character varying(1) DEFAULT 'n'::character varying NOT NULL,
    score_ri numeric(7,3),
    ri_customers bigint,
    ri_mills numeric(3,1),
    ri_upfront numeric(4,2),
    ri_usage bigint,
    ri_renewal numeric(4,1),
    ri_submit numeric(4,1),
    ri_accept numeric(4,1),
    ri_xsell numeric(5,2),
    commercial_email_ri text,
    use_cart_ca character varying(1) DEFAULT 'n'::character varying NOT NULL,
    use_ter_phone_ca character varying(1) DEFAULT 'n'::character varying NOT NULL,
    phone_ca text,
    regulatory_identifier_ca text,
    status_ca character varying(1) DEFAULT 'n'::character varying NOT NULL,
    score_ca numeric(7,3),
    ca_customers bigint,
    ca_mills numeric(3,1),
    ca_upfront numeric(4,2),
    ca_usage bigint,
    ca_renewal numeric(4,1),
    ca_submit numeric(4,1),
    ca_accept numeric(4,1),
    ca_xsell numeric(5,2),
    commercial_email_ca text,
    utility boolean DEFAULT false NOT NULL,
    friend_linkoff_phone bigint,
    friend_reporting bigint,
    friend_strategic bigint,
    friend_tactical bigint,
    friend_deep_links bigint,
    site text,
    ny_doc1 text,
    ny_doc1_label text,
    ny_doc2 text,
    ny_doc2_label text,
    ny_doc3 text,
    ny_doc3_label text,
    ny_doc4 text,
    ny_doc4_label text,
    ny_doc5 text,
    ny_doc5_label text,
    tx_review_blurb bytea,
    pa_review_blurb bytea,
    nj_review_blurb bytea,
    ma_review_blurb bytea,
    il_review_blurb bytea,
    oh_review_blurb bytea,
    de_review_blurb bytea,
    md_review_blurb bytea,
    nh_review_blurb bytea,
    nh_doc1 text,
    nh_doc2 text,
    nh_doc3 text,
    nh_doc4 text,
    nh_doc5 text,
    nh_doc5_label text,
    nh_doc4_label text,
    nh_doc3_label text,
    nh_doc2_label text,
    nh_doc1_label text,
    dc_review_blurb bytea,
    ky_review_blurb bytea,
    mi_review_blurb bytea,
    me_review_blurb bytea,
    in_review_blurb bytea,
    ri_review_blurb bytea,
    ca_review_blurb bytea,
    ct_review_blurb bytea,
    ny_review_blurb bytea,
    ga_review_blurb bytea,
    use_cart_ab character varying(1),
    use_ter_phone_ab character varying(1),
    phone_ab text,
    regulatory_identifier_ab text,
    market_status_ab character varying(1),
    status_ab character varying(1),
    score_ab numeric(7,3),
    ab_mills numeric(3,1),
    ab_upfront numeric(4,2),
    ab_usage bigint,
    ab_renewal numeric(4,1),
    ab_submit numeric(4,1),
    ab_accept numeric(4,1),
    ab_review_blurb bytea,
    commercial_email_ab text,
    ab_doc1 text,
    ab_doc1_label text,
    pa_doc1 text,
    pa_doc2 text,
    pa_doc3 text,
    pa_doc4 text,
    pa_doc5 text,
    pa_doc5_label text,
    pa_doc4_label text,
    pa_doc3_label text,
    pa_doc2_label text,
    pa_doc1_label text,
    ct_mills numeric(3,1),
    ct_upfront numeric(4,2),
    ct_usage bigint,
    ct_renewal numeric(4,1),
    ct_submit numeric(4,1),
    ct_accept numeric(4,1),
    ct_xsell numeric(5,2),
    ct_doc1 text,
    ct_doc1_label text,
    ny_mills numeric(3,1),
    ny_upfront numeric(4,2),
    ny_usage bigint,
    ny_renewal numeric(4,1),
    ny_submit numeric(4,1),
    ny_accept numeric(4,1),
    ny_xsell numeric(5,2),
    ma_doc1_label text,
    md_doc1 text,
    md_doc1_label text,
    mi_doc1 text,
    mi_doc1_label text,
    oh_doc1_label text,
    oh_doc1 text,
    oh_doc2_label text,
    oh_doc2 text,
    oh_doc3_label text,
    oh_doc3 text,
    oh_doc4_label text,
    oh_doc4 text,
    oh_doc5_label text,
    oh_doc5 text,
    ga_mills numeric(3,1),
    ga_upfront numeric(4,2),
    ga_usage bigint,
    ga_renewal numeric(4,1),
    ga_submit numeric(4,1),
    ga_accept numeric(4,1),
    ga_xsell numeric(5,2),
    ga_doc1_label text,
    tx_doc1 text,
    tx_doc1_label text,
    tx_doc2 text,
    tx_doc2_label text,
    tx_doc3 text,
    tx_doc3_label text,
    tx_doc4 text,
    tx_doc4_label text,
    tx_doc5 text,
    tx_doc5_label text,
    nj_doc1 text,
    nj_doc1_label text,
    nj_doc2 text,
    nj_doc2_label text,
    nj_doc3 text,
    nj_doc3_label text,
    nj_doc4 text,
    nj_doc4_label text,
    nj_doc5 text,
    nj_doc5_label text,
    il_doc1 text,
    il_doc1_label text,
    il_doc2 text,
    il_doc2_label text,
    il_doc3 text,
    il_doc3_label text,
    il_doc4 text,
    il_doc4_label text,
    il_doc5 text,
    il_doc5_label text,
    show_cis character varying(1) DEFAULT 'n'::character varying NOT NULL,
    customer_service_phone text,
    biz_phone text,
    biz_phone_ext bigint,
    me_doc1 text,
    me_doc1_label text,
    me_doc2 text,
    me_doc2_label text,
    me_doc3 text,
    me_doc3_label text,
    me_doc4 text,
    me_doc4_label text,
    me_doc5 text,
    me_doc5_label text,
    default_state character varying(2),
    biz_quote_email text,
    biz_contract_email text,
    biz_admin_email text,
    quickbooks_entity text,
    green_provider character varying(1) DEFAULT 'n'::character varying NOT NULL,
    prepaid_provider character varying(1) DEFAULT 'n'::character varying NOT NULL,
    batch_email character varying(255),
    biz_phone_tx character varying(20),
    biz_phone_ct character varying(20),
    biz_phone_ny character varying(20),
    biz_phone_ga character varying(20),
    biz_phone_dc character varying(20),
    biz_phone_md character varying(20),
    biz_phone_nj character varying(20),
    biz_phone_oh character varying(20),
    biz_phone_nh character varying(20),
    biz_phone_il character varying(20),
    biz_phone_pa character varying(20),
    biz_phone_ma character varying(20),
    biz_phone_de character varying(20),
    biz_phone_ky character varying(20),
    biz_phone_mi character varying(20),
    biz_phone_me character varying(20),
    biz_phone_in character varying(20),
    biz_phone_ri character varying(20),
    biz_phone_ca character varying(20),
    biz_phone_ab character varying(20)
);


ALTER TABLE public.reps OWNER TO phpuser;

--
-- Name: reps_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.reps_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.reps_id_seq OWNER TO phpuser;

--
-- Name: reps_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.reps_id_seq OWNED BY public.reps.id;


--
-- Name: residual; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.residual (
    id bigint NOT NULL,
    rep_id integer,
    partner_name character varying(50) DEFAULT NULL::character varying,
    brand_name character varying(50) DEFAULT NULL::character varying,
    state_short_name character(2) DEFAULT NULL::bpchar,
    state_long_name character varying(50) DEFAULT NULL::character varying,
    state character varying(2) DEFAULT NULL::character varying,
    last_name character varying(50) DEFAULT NULL::character varying,
    first_name character varying(50) DEFAULT NULL::character varying,
    edc character varying(50) DEFAULT NULL::character varying,
    esiid character varying(255) DEFAULT NULL::character varying,
    account_number character varying(255) DEFAULT NULL::character varying,
    usage_start date,
    usage_end date,
    pay_date date,
    usage_amt numeric(10,2) DEFAULT NULL::numeric,
    payment character varying(255) DEFAULT NULL::character varying,
    period_id character varying(255) DEFAULT NULL::character varying,
    pk_bill_number character varying(50) DEFAULT NULL::character varying,
    customer_type character varying(255) DEFAULT NULL::character varying,
    order_number character varying(50) DEFAULT NULL::character varying,
    order_date date,
    flow_date date,
    checkout_class character varying(50) DEFAULT NULL::character varying,
    upfront numeric(6,2) DEFAULT NULL::numeric,
    backdated_upfront numeric(6,2) DEFAULT NULL::numeric,
    residual numeric(6,2) DEFAULT NULL::numeric,
    mills numeric(4,3) DEFAULT NULL::numeric,
    commodity character(1) DEFAULT 'e'::bpchar NOT NULL,
    ticket_id bigint,
    item_id bigint,
    term integer,
    created timestamp without time zone
);


ALTER TABLE public.residual OWNER TO postgres;

--
-- Name: residual_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.residual_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.residual_id_seq OWNER TO postgres;

--
-- Name: residual_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.residual_id_seq OWNED BY public.residual.id;


--
-- Name: review; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.review (
    id bigint NOT NULL,
    title text DEFAULT ''::text NOT NULL,
    body text NOT NULL,
    author text DEFAULT ''::text NOT NULL,
    location text DEFAULT ''::text NOT NULL,
    review_item_id bigint DEFAULT '0'::bigint NOT NULL,
    site_id bigint DEFAULT '0'::bigint NOT NULL,
    visitorip text DEFAULT '0'::text NOT NULL,
    ctime timestamp with time zone NOT NULL,
    useful bigint DEFAULT '0'::bigint NOT NULL,
    notuseful bigint DEFAULT '0'::bigint NOT NULL,
    approve public.review_approve DEFAULT 'n'::public.review_approve NOT NULL,
    username text DEFAULT ''::text NOT NULL,
    email text,
    state character varying(2),
    product text,
    migrated boolean DEFAULT false NOT NULL
);


ALTER TABLE public.review OWNER TO phpuser;

--
-- Name: review_comment; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.review_comment (
    id bigint NOT NULL,
    review_id bigint,
    author text DEFAULT ''::text NOT NULL,
    ctime timestamp with time zone,
    body text,
    rep_user_id bigint
);


ALTER TABLE public.review_comment OWNER TO phpuser;

--
-- Name: review_comment_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.review_comment_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.review_comment_id_seq OWNER TO phpuser;

--
-- Name: review_comment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.review_comment_id_seq OWNED BY public.review_comment.id;


--
-- Name: review_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.review_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.review_id_seq OWNER TO phpuser;

--
-- Name: review_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.review_id_seq OWNED BY public.review.id;


--
-- Name: scholarships; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.scholarships (
    id bigint NOT NULL,
    reviewed_by text,
    scholarship_name text,
    first_name text,
    last_name text,
    phone character varying(10),
    email text,
    birthday date,
    street text,
    unit text,
    city text,
    state character varying(2),
    zip character varying(5),
    gpa text,
    class_rank text,
    school_grade text,
    class_size text,
    graduate_year text,
    sat_score text,
    critical_reading text,
    act_score text,
    math text,
    writing text,
    awards bytea,
    community_service bytea,
    organizations bytea,
    career_goals bytea,
    college_organizations bytea,
    personal_essay bytea,
    transcript_contents bytea,
    transcript_type text,
    transcript_name text,
    signature text,
    created timestamp with time zone,
    vid text,
    status character varying(1),
    confirmation_number character varying(6),
    modified timestamp with time zone DEFAULT now() NOT NULL
);


ALTER TABLE public.scholarships OWNER TO phpuser;

--
-- Name: scholarships_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.scholarships_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.scholarships_id_seq OWNER TO phpuser;

--
-- Name: scholarships_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.scholarships_id_seq OWNED BY public.scholarships.id;


--
-- Name: spinner_values; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.spinner_values (
    id bigint NOT NULL,
    name text,
    value text,
    sort bigint,
    type text
);


ALTER TABLE public.spinner_values OWNER TO phpuser;

--
-- Name: spinner_values_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.spinner_values_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.spinner_values_id_seq OWNER TO phpuser;

--
-- Name: spinner_values_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.spinner_values_id_seq OWNED BY public.spinner_values.id;


--
-- Name: spinners; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.spinners (
    id bigint NOT NULL,
    name text,
    sequence character varying(30),
    updated numeric,
    site_id bigint
);


ALTER TABLE public.spinners OWNER TO phpuser;

--
-- Name: spinners_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.spinners_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.spinners_id_seq OWNER TO phpuser;

--
-- Name: spinners_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.spinners_id_seq OWNED BY public.spinners.id;


--
-- Name: tdsp_fees; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.tdsp_fees (
    id bigint NOT NULL,
    market_id bigint,
    type text,
    price numeric(10,5),
    effective_date date,
    created timestamp with time zone
);


ALTER TABLE public.tdsp_fees OWNER TO phpuser;

--
-- Name: tdsp_fees_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.tdsp_fees_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tdsp_fees_id_seq OWNER TO phpuser;

--
-- Name: tdsp_fees_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.tdsp_fees_id_seq OWNED BY public.tdsp_fees.id;


--
-- Name: tickets; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tickets (
    id bigint,
    error_log text,
    ticket_call_id bigint
);


ALTER TABLE public.tickets OWNER TO postgres;

--
-- Name: ticket_batchs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_batchs (
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_batchs OWNER TO postgres;

--
-- Name: tickets_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tickets_to_items (
    ticket_id bigint,
    item_id bigint,
    id bigint,
    item_model character varying(255)
);


ALTER TABLE public.tickets_to_items OWNER TO postgres;

--
-- Name: ticket_batchs_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_batchs_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_batchs_to_items OWNER TO postgres;

--
-- Name: ticket_bills; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_bills (
    start_date date,
    end_date date,
    usage_amount integer,
    bill_amount numeric(12,2),
    commodity character(1),
    market_id integer,
    units character varying(10)
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_bills OWNER TO postgres;

--
-- Name: ticket_bills_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_bills_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_bills_to_items OWNER TO postgres;

--
-- Name: ticket_carts; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_carts (
    order_id_seq integer
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_carts OWNER TO postgres;

--
-- Name: ticket_carts_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_carts_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_carts_to_items OWNER TO postgres;

--
-- Name: ticket_commissions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_commissions (
    rep_id bigint,
    period integer
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_commissions OWNER TO postgres;

--
-- Name: ticket_commission_upfronts; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_commission_upfronts (
)
INHERITS (public.ticket_commissions);


ALTER TABLE public.ticket_commission_upfronts OWNER TO postgres;

--
-- Name: ticket_commissions_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_commissions_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_commissions_to_items OWNER TO postgres;

--
-- Name: ticket_commission_upfronts_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_commission_upfronts_to_items (
)
INHERITS (public.ticket_commissions_to_items);


ALTER TABLE public.ticket_commission_upfronts_to_items OWNER TO postgres;

--
-- Name: ticket_commission_usages; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_commission_usages (
)
INHERITS (public.ticket_commissions);


ALTER TABLE public.ticket_commission_usages OWNER TO postgres;

--
-- Name: ticket_commission_usages_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_commission_usages_to_items (
)
INHERITS (public.ticket_commissions_to_items);


ALTER TABLE public.ticket_commission_usages_to_items OWNER TO postgres;

--
-- Name: ticket_contacts; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contacts (
    disposition character varying(50),
    disposition_page character varying(255)
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_contacts OWNER TO postgres;

--
-- Name: ticket_contact_calls; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_calls (
    pbx_id bigint,
    pbx_call_id character varying(250),
    pbx_did character varying(20),
    pbx_ter_number character varying(20),
    pbx_cust_number character varying(20),
    pbx_agent_id character varying(20),
    pbx_queue character varying(20),
    pbx_username character varying(75),
    pbx_market_id integer,
    user_id bigint
)
INHERITS (public.ticket_contacts);


ALTER TABLE public.ticket_contact_calls OWNER TO postgres;

--
-- Name: ticket_contact_call_inbounds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_call_inbounds (
)
INHERITS (public.ticket_contact_calls);


ALTER TABLE public.ticket_contact_call_inbounds OWNER TO postgres;

--
-- Name: ticket_contacts_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contacts_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_contacts_to_items OWNER TO postgres;

--
-- Name: ticket_contact_calls_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_calls_to_items (
)
INHERITS (public.ticket_contacts_to_items);


ALTER TABLE public.ticket_contact_calls_to_items OWNER TO postgres;

--
-- Name: ticket_contact_call_inbounds_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_call_inbounds_to_items (
)
INHERITS (public.ticket_contact_calls_to_items);


ALTER TABLE public.ticket_contact_call_inbounds_to_items OWNER TO postgres;

--
-- Name: ticket_contact_call_outbounds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_call_outbounds (
)
INHERITS (public.ticket_contact_calls);


ALTER TABLE public.ticket_contact_call_outbounds OWNER TO postgres;

--
-- Name: ticket_contact_call_outbounds_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_call_outbounds_to_items (
)
INHERITS (public.ticket_contact_calls_to_items);


ALTER TABLE public.ticket_contact_call_outbounds_to_items OWNER TO postgres;

--
-- Name: ticket_contact_chats; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_chats (
    user_open character(1) DEFAULT 'c'::bpchar NOT NULL,
    user_url character varying(255),
    user_url_time integer,
    user_market_id integer,
    chat_bot_name character varying(50),
    init_time timestamp without time zone,
    pop_time timestamp without time zone,
    input_time timestamp without time zone,
    close_time timestamp without time zone,
    respond_time timestamp without time zone
)
INHERITS (public.ticket_contacts);


ALTER TABLE public.ticket_contact_chats OWNER TO postgres;

--
-- Name: ticket_contact_chat_inbounds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_chat_inbounds (
)
INHERITS (public.ticket_contact_chats);


ALTER TABLE public.ticket_contact_chat_inbounds OWNER TO postgres;

--
-- Name: ticket_contact_chats_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_chats_to_items (
)
INHERITS (public.ticket_contacts_to_items);


ALTER TABLE public.ticket_contact_chats_to_items OWNER TO postgres;

--
-- Name: ticket_contact_chat_inbounds_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_chat_inbounds_to_items (
)
INHERITS (public.ticket_contact_chats_to_items);


ALTER TABLE public.ticket_contact_chat_inbounds_to_items OWNER TO postgres;

--
-- Name: ticket_contact_chat_outbounds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_chat_outbounds (
)
INHERITS (public.ticket_contact_chats);


ALTER TABLE public.ticket_contact_chat_outbounds OWNER TO postgres;

--
-- Name: ticket_contact_chat_outbounds_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_chat_outbounds_to_items (
)
INHERITS (public.ticket_contact_chats_to_items);


ALTER TABLE public.ticket_contact_chat_outbounds_to_items OWNER TO postgres;

--
-- Name: ticket_contact_emails; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_emails (
    email character varying(255)
)
INHERITS (public.ticket_contacts);


ALTER TABLE public.ticket_contact_emails OWNER TO postgres;

--
-- Name: ticket_contact_email_inbounds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_email_inbounds (
)
INHERITS (public.ticket_contact_emails);


ALTER TABLE public.ticket_contact_email_inbounds OWNER TO postgres;

--
-- Name: ticket_contact_emails_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_emails_to_items (
)
INHERITS (public.ticket_contacts_to_items);


ALTER TABLE public.ticket_contact_emails_to_items OWNER TO postgres;

--
-- Name: ticket_contact_email_inbounds_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_email_inbounds_to_items (
)
INHERITS (public.ticket_contact_emails_to_items);


ALTER TABLE public.ticket_contact_email_inbounds_to_items OWNER TO postgres;

--
-- Name: ticket_contact_email_outbounds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_email_outbounds (
)
INHERITS (public.ticket_contact_emails);


ALTER TABLE public.ticket_contact_email_outbounds OWNER TO postgres;

--
-- Name: ticket_contact_email_outbounds_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_email_outbounds_to_items (
)
INHERITS (public.ticket_contact_emails_to_items);


ALTER TABLE public.ticket_contact_email_outbounds_to_items OWNER TO postgres;

--
-- Name: ticket_contact_smss; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_smss (
    phone character varying(50)
)
INHERITS (public.ticket_contacts);


ALTER TABLE public.ticket_contact_smss OWNER TO postgres;

--
-- Name: ticket_contact_sms_inbounds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_sms_inbounds (
)
INHERITS (public.ticket_contact_smss);


ALTER TABLE public.ticket_contact_sms_inbounds OWNER TO postgres;

--
-- Name: ticket_contact_smss_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_smss_to_items (
)
INHERITS (public.ticket_contacts_to_items);


ALTER TABLE public.ticket_contact_smss_to_items OWNER TO postgres;

--
-- Name: ticket_contact_sms_inbounds_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_sms_inbounds_to_items (
)
INHERITS (public.ticket_contact_smss_to_items);


ALTER TABLE public.ticket_contact_sms_inbounds_to_items OWNER TO postgres;

--
-- Name: ticket_contact_sms_outbounds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_sms_outbounds (
)
INHERITS (public.ticket_contact_smss);


ALTER TABLE public.ticket_contact_sms_outbounds OWNER TO postgres;

--
-- Name: ticket_contact_sms_outbounds_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_contact_sms_outbounds_to_items (
)
INHERITS (public.ticket_contact_smss_to_items);


ALTER TABLE public.ticket_contact_sms_outbounds_to_items OWNER TO postgres;

--
-- Name: ticket_costs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_costs (
    amount numeric(12,2),
    period integer,
    vendor_id bigint,
    transaction_number character varying(50),
    due_date date
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_costs OWNER TO postgres;

--
-- Name: ticket_costs_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_costs_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_costs_to_items OWNER TO postgres;

--
-- Name: ticket_credit_checks; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_credit_checks (
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_credit_checks OWNER TO postgres;

--
-- Name: ticket_credit_checks_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_credit_checks_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_credit_checks_to_items OWNER TO postgres;

--
-- Name: ticket_deleteds; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_deleteds (
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_deleteds OWNER TO postgres;

--
-- Name: ticket_deleteds_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_deleteds_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_deleteds_to_items OWNER TO postgres;

--
-- Name: ticket_leads; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_leads (
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_leads OWNER TO postgres;

--
-- Name: ticket_lead_commercials; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_lead_commercials (
)
INHERITS (public.ticket_leads);


ALTER TABLE public.ticket_lead_commercials OWNER TO postgres;

--
-- Name: ticket_leads_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_leads_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_leads_to_items OWNER TO postgres;

--
-- Name: ticket_lead_commercials_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_lead_commercials_to_items (
)
INHERITS (public.ticket_leads_to_items);


ALTER TABLE public.ticket_lead_commercials_to_items OWNER TO postgres;

--
-- Name: ticket_lead_dtvs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_lead_dtvs (
)
INHERITS (public.ticket_leads);


ALTER TABLE public.ticket_lead_dtvs OWNER TO postgres;

--
-- Name: ticket_lead_dtvs_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_lead_dtvs_to_items (
)
INHERITS (public.ticket_leads_to_items);


ALTER TABLE public.ticket_lead_dtvs_to_items OWNER TO postgres;

--
-- Name: ticket_lead_solars; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_lead_solars (
)
INHERITS (public.ticket_leads);


ALTER TABLE public.ticket_lead_solars OWNER TO postgres;

--
-- Name: ticket_lead_solars_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_lead_solars_to_items (
)
INHERITS (public.ticket_leads_to_items);


ALTER TABLE public.ticket_lead_solars_to_items OWNER TO postgres;

--
-- Name: ticket_ledgers; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_ledgers (
    period integer,
    vendor character varying(200),
    description character varying(255),
    doc_number character varying(21),
    type character varying(50),
    entity character varying(100)
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_ledgers OWNER TO postgres;

--
-- Name: ticket_ledgers_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_ledgers_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_ledgers_to_items OWNER TO postgres;

--
-- Name: ticket_locations; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_locations (
    location_code character varying(255),
    address_1 character varying(100),
    address_2 character varying(50),
    city character varying(50),
    state character varying(50),
    zip character varying(11),
    uan1_e character varying(50),
    uan2_e character varying(50),
    uan3_e character varying(50),
    uan4_e character varying(50),
    uan5_e character varying(50),
    market_id_e integer,
    uan1_g character varying(50),
    uan2_g character varying(50),
    uan3_g character varying(50),
    uan4_g character varying(50),
    uan5_g character varying(50),
    market_id_g integer
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_locations OWNER TO postgres;

--
-- Name: ticket_locations_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_locations_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_locations_to_items OWNER TO postgres;

--
-- Name: ticket_meetings; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_meetings (
    company_id bigint,
    meeting_date timestamp without time zone,
    note text,
    user_id bigint
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_meetings OWNER TO postgres;

--
-- Name: ticket_meetings_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_meetings_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_meetings_to_items OWNER TO postgres;

--
-- Name: ticket_myaccounts; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_myaccounts (
    email character varying(255),
    email_hash character varying(255),
    password_hash character varying(255),
    account_id_seq bigint,
    current_ticket_id bigint,
    current_location_id bigint,
    phone character varying(10),
    active_ticket_id bigint,
    active_ticket_term_end timestamp without time zone
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_myaccounts OWNER TO postgres;

--
-- Name: ticket_myaccounts_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_myaccounts_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_myaccounts_to_items OWNER TO postgres;

--
-- Name: ticket_orders; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_orders (
    inherits public.tickets
);


ALTER TABLE public.ticket_orders OWNER TO postgres;

--
-- Name: ticket_phones; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_phones (
    phone character varying(20)
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_phones OWNER TO postgres;

--
-- Name: ticket_phone_imports; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_phone_imports (
)
INHERITS (public.ticket_phones);


ALTER TABLE public.ticket_phone_imports OWNER TO postgres;

--
-- Name: ticket_phones_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_phones_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_phones_to_items OWNER TO postgres;

--
-- Name: ticket_phone_imports_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_phone_imports_to_items (
)
INHERITS (public.ticket_phones_to_items);


ALTER TABLE public.ticket_phone_imports_to_items OWNER TO postgres;

--
-- Name: ticket_rekeys; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_rekeys (
    old_ticket_id bigint,
    new_ticket_id bigint
);


ALTER TABLE public.ticket_rekeys OWNER TO postgres;

--
-- Name: ticket_reviews; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_reviews (
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_reviews OWNER TO postgres;

--
-- Name: ticket_reviews_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_reviews_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_reviews_to_items OWNER TO postgres;

--
-- Name: ticket_surveys; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_surveys (
    name character varying(255),
    description text,
    title character varying(255)
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_surveys OWNER TO postgres;

--
-- Name: ticket_survey_order_completes; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_survey_order_completes (
)
INHERITS (public.ticket_surveys);


ALTER TABLE public.ticket_survey_order_completes OWNER TO postgres;

--
-- Name: ticket_surveys_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_surveys_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_surveys_to_items OWNER TO postgres;

--
-- Name: ticket_survey_order_completes_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_survey_order_completes_to_items (
)
INHERITS (public.ticket_surveys_to_items);


ALTER TABLE public.ticket_survey_order_completes_to_items OWNER TO postgres;

--
-- Name: ticket_survey_plan_analyzers; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_survey_plan_analyzers (
)
INHERITS (public.ticket_surveys);


ALTER TABLE public.ticket_survey_plan_analyzers OWNER TO postgres;

--
-- Name: ticket_survey_plan_analyzers_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_survey_plan_analyzers_to_items (
)
INHERITS (public.ticket_surveys_to_items);


ALTER TABLE public.ticket_survey_plan_analyzers_to_items OWNER TO postgres;

--
-- Name: ticket_survey_plan_pickers; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_survey_plan_pickers (
)
INHERITS (public.ticket_surveys);


ALTER TABLE public.ticket_survey_plan_pickers OWNER TO postgres;

--
-- Name: ticket_survey_plan_pickers_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_survey_plan_pickers_to_items (
)
INHERITS (public.ticket_surveys_to_items);


ALTER TABLE public.ticket_survey_plan_pickers_to_items OWNER TO postgres;

--
-- Name: ticket_uploads; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_uploads (
    type character varying(100)
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_uploads OWNER TO postgres;

--
-- Name: ticket_upload_commissions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_commissions (
    period character(6),
    rep_id integer
)
INHERITS (public.ticket_uploads);


ALTER TABLE public.ticket_upload_commissions OWNER TO postgres;

--
-- Name: ticket_uploads_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_uploads_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_uploads_to_items OWNER TO postgres;

--
-- Name: ticket_upload_commissions_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_commissions_to_items (
)
INHERITS (public.ticket_uploads_to_items);


ALTER TABLE public.ticket_upload_commissions_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partners; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partners (
    rep_id integer
)
INHERITS (public.ticket_uploads);


ALTER TABLE public.ticket_upload_partners OWNER TO postgres;

--
-- Name: ticket_upload_partner_clearviews; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_clearviews (
)
INHERITS (public.ticket_upload_partners);


ALTER TABLE public.ticket_upload_partner_clearviews OWNER TO postgres;

--
-- Name: ticket_upload_partners_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partners_to_items (
)
INHERITS (public.ticket_uploads_to_items);


ALTER TABLE public.ticket_upload_partners_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partner_clearviews_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_clearviews_to_items (
)
INHERITS (public.ticket_upload_partners_to_items);


ALTER TABLE public.ticket_upload_partner_clearviews_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partner_directs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_directs (
)
INHERITS (public.ticket_upload_partners);


ALTER TABLE public.ticket_upload_partner_directs OWNER TO postgres;

--
-- Name: ticket_upload_partner_directs_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_directs_to_items (
)
INHERITS (public.ticket_upload_partners_to_items);


ALTER TABLE public.ticket_upload_partner_directs_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partner_firsts; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_firsts (
)
INHERITS (public.ticket_upload_partners);


ALTER TABLE public.ticket_upload_partner_firsts OWNER TO postgres;

--
-- Name: ticket_upload_partner_firsts_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_firsts_to_items (
)
INHERITS (public.ticket_upload_partners_to_items);


ALTER TABLE public.ticket_upload_partner_firsts_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partner_justs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_justs (
)
INHERITS (public.ticket_upload_partners);


ALTER TABLE public.ticket_upload_partner_justs OWNER TO postgres;

--
-- Name: ticket_upload_partner_justs_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_justs_to_items (
)
INHERITS (public.ticket_upload_partners_to_items);


ALTER TABLE public.ticket_upload_partner_justs_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partner_lifes; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_lifes (
)
INHERITS (public.ticket_upload_partners);


ALTER TABLE public.ticket_upload_partner_lifes OWNER TO postgres;

--
-- Name: ticket_upload_partner_lifes_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_lifes_to_items (
)
INHERITS (public.ticket_upload_partners_to_items);


ALTER TABLE public.ticket_upload_partner_lifes_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partner_mercurys; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_mercurys (
)
INHERITS (public.ticket_upload_partners);


ALTER TABLE public.ticket_upload_partner_mercurys OWNER TO postgres;

--
-- Name: ticket_upload_partner_mercurys_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_mercurys_to_items (
)
INHERITS (public.ticket_upload_partners_to_items);


ALTER TABLE public.ticket_upload_partner_mercurys_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partner_nrgs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_nrgs (
)
INHERITS (public.ticket_upload_partners);


ALTER TABLE public.ticket_upload_partner_nrgs OWNER TO postgres;

--
-- Name: ticket_upload_partner_nrgs_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_nrgs_to_items (
)
INHERITS (public.ticket_upload_partners_to_items);


ALTER TABLE public.ticket_upload_partner_nrgs_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partner_powerexpresss; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_powerexpresss (
)
INHERITS (public.ticket_upload_partners);


ALTER TABLE public.ticket_upload_partner_powerexpresss OWNER TO postgres;

--
-- Name: ticket_upload_partner_powerexpresss_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_powerexpresss_to_items (
)
INHERITS (public.ticket_upload_partners_to_items);


ALTER TABLE public.ticket_upload_partner_powerexpresss_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partner_publics; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_publics (
)
INHERITS (public.ticket_upload_partners);


ALTER TABLE public.ticket_upload_partner_publics OWNER TO postgres;

--
-- Name: ticket_upload_partner_publics_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_publics_to_items (
)
INHERITS (public.ticket_upload_partners_to_items);


ALTER TABLE public.ticket_upload_partner_publics_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partner_santannas; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_santannas (
)
INHERITS (public.ticket_upload_partners);


ALTER TABLE public.ticket_upload_partner_santannas OWNER TO postgres;

--
-- Name: ticket_upload_partner_santannas_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_santannas_to_items (
)
INHERITS (public.ticket_upload_partners_to_items);


ALTER TABLE public.ticket_upload_partner_santannas_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partner_sparks; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_sparks (
)
INHERITS (public.ticket_upload_partners);


ALTER TABLE public.ticket_upload_partner_sparks OWNER TO postgres;

--
-- Name: ticket_upload_partner_spark_brand_censtars; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_spark_brand_censtars (
)
INHERITS (public.ticket_upload_partner_sparks);


ALTER TABLE public.ticket_upload_partner_spark_brand_censtars OWNER TO postgres;

--
-- Name: ticket_upload_partner_sparks_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_sparks_to_items (
)
INHERITS (public.ticket_upload_partners_to_items);


ALTER TABLE public.ticket_upload_partner_sparks_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partner_spark_brand_censtars_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_spark_brand_censtars_to_items (
)
INHERITS (public.ticket_upload_partner_sparks_to_items);


ALTER TABLE public.ticket_upload_partner_spark_brand_censtars_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partner_spark_brand_oasiss; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_spark_brand_oasiss (
)
INHERITS (public.ticket_upload_partner_sparks);


ALTER TABLE public.ticket_upload_partner_spark_brand_oasiss OWNER TO postgres;

--
-- Name: ticket_upload_partner_spark_brand_oasiss_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_spark_brand_oasiss_to_items (
)
INHERITS (public.ticket_upload_partner_sparks_to_items);


ALTER TABLE public.ticket_upload_partner_spark_brand_oasiss_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partner_starions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_starions (
)
INHERITS (public.ticket_upload_partners);


ALTER TABLE public.ticket_upload_partner_starions OWNER TO postgres;

--
-- Name: ticket_upload_partner_starions_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_starions_to_items (
)
INHERITS (public.ticket_upload_partners_to_items);


ALTER TABLE public.ticket_upload_partner_starions_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partner_texpos; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_texpos (
)
INHERITS (public.ticket_upload_partners);


ALTER TABLE public.ticket_upload_partner_texpos OWNER TO postgres;

--
-- Name: ticket_upload_partner_texpo_brand_yeps; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_texpo_brand_yeps (
)
INHERITS (public.ticket_upload_partner_texpos);


ALTER TABLE public.ticket_upload_partner_texpo_brand_yeps OWNER TO postgres;

--
-- Name: ticket_upload_partner_texpos_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_texpos_to_items (
)
INHERITS (public.ticket_upload_partners_to_items);


ALTER TABLE public.ticket_upload_partner_texpos_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partner_texpo_brand_yeps_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_texpo_brand_yeps_to_items (
)
INHERITS (public.ticket_upload_partner_texpos_to_items);


ALTER TABLE public.ticket_upload_partner_texpo_brand_yeps_to_items OWNER TO postgres;

--
-- Name: ticket_upload_partner_vistas; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_vistas (
)
INHERITS (public.ticket_upload_partners);


ALTER TABLE public.ticket_upload_partner_vistas OWNER TO postgres;

--
-- Name: ticket_upload_partner_vistas_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upload_partner_vistas_to_items (
)
INHERITS (public.ticket_upload_partners_to_items);


ALTER TABLE public.ticket_upload_partner_vistas_to_items OWNER TO postgres;

--
-- Name: ticket_upsells; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upsells (
)
INHERITS (public.tickets);


ALTER TABLE public.ticket_upsells OWNER TO postgres;

--
-- Name: ticket_upsell_acs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upsell_acs (
)
INHERITS (public.ticket_upsells);


ALTER TABLE public.ticket_upsell_acs OWNER TO postgres;

--
-- Name: ticket_upsell_ac_hvacs; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upsell_ac_hvacs (
)
INHERITS (public.ticket_upsell_acs);


ALTER TABLE public.ticket_upsell_ac_hvacs OWNER TO postgres;

--
-- Name: ticket_upsells_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upsells_to_items (
)
INHERITS (public.tickets_to_items);


ALTER TABLE public.ticket_upsells_to_items OWNER TO postgres;

--
-- Name: ticket_upsell_acs_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upsell_acs_to_items (
)
INHERITS (public.ticket_upsells_to_items);


ALTER TABLE public.ticket_upsell_acs_to_items OWNER TO postgres;

--
-- Name: ticket_upsell_ac_hvacs_to_items; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.ticket_upsell_ac_hvacs_to_items (
)
INHERITS (public.ticket_upsell_acs_to_items);


ALTER TABLE public.ticket_upsell_ac_hvacs_to_items OWNER TO postgres;

--
-- Name: tickets_serialized; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tickets_serialized (
    ticket_id bigint,
    data text
);


ALTER TABLE public.tickets_serialized OWNER TO postgres;

--
-- Name: tickets_to_item_archives; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tickets_to_item_archives (
    ticket_id bigint,
    item_id bigint,
    id bigint
);


ALTER TABLE public.tickets_to_item_archives OWNER TO postgres;

--
-- Name: tmp_pages_2; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.tmp_pages_2 (
    id bigint DEFAULT '0'::bigint NOT NULL,
    page_type_id bigint NOT NULL,
    site_id bigint,
    parent_id bigint NOT NULL,
    template_id bigint,
    slug text,
    html_title text,
    meta_desc text,
    meta_key text,
    head_content text,
    page_title text,
    content_primary text,
    content_secondary text,
    content_parent text,
    content_auxiliary text,
    content_mobile text,
    pricegrid_type_id bigint,
    pricegrid_more_link text,
    pricegrid_header_title text,
    pricegrid_plan_page_link_option smallint,
    pricegrid_order_page_slug text,
    address_box_title text,
    default_msid text,
    default_premise character varying(1) DEFAULT 'R'::character varying,
    canonical character varying(1) DEFAULT '1'::character varying,
    bold_chat_rule_id bigint NOT NULL,
    phone text NOT NULL,
    web_source_id bigint NOT NULL,
    formula_id bigint NOT NULL,
    market_label text,
    redirect character varying(1) DEFAULT '0'::character varying,
    promo_code text,
    symlink_of bigint,
    no_index bigint DEFAULT '0'::bigint,
    hard_cache bigint DEFAULT '0'::bigint NOT NULL
);


ALTER TABLE public.tmp_pages_2 OWNER TO phpuser;

--
-- Name: user_logins; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.user_logins (
    id bigint,
    user_id bigint,
    company_id bigint,
    logged_in timestamp without time zone,
    logged_out timestamp without time zone
);


ALTER TABLE public.user_logins OWNER TO postgres;

--
-- Name: utilities; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.utilities (
    id bigint NOT NULL,
    name text,
    rep_id bigint,
    website text,
    state character varying(2)
);


ALTER TABLE public.utilities OWNER TO phpuser;

--
-- Name: utilities_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.utilities_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.utilities_id_seq OWNER TO phpuser;

--
-- Name: utilities_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.utilities_id_seq OWNED BY public.utilities.id;


--
-- Name: visitor; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.visitor (
    id bigint NOT NULL,
    ip character varying(16),
    uri text,
    referrer text,
    user_agent text,
    site_id bigint,
    page_views bigint,
    market_id bigint,
    zip character varying(5),
    ctime timestamp with time zone,
    zip4 character varying(4),
    city text,
    state character varying(4),
    esiid text,
    vid text,
    street1 text,
    street2 text
);


ALTER TABLE public.visitor OWNER TO phpuser;

--
-- Name: visitor_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.visitor_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.visitor_id_seq OWNER TO phpuser;

--
-- Name: visitor_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.visitor_id_seq OWNED BY public.visitor.id;


--
-- Name: visitor_msid; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.visitor_msid (
    id bigint NOT NULL,
    msid_vendor text,
    msid_state text,
    msid_campaign text,
    msid_group text,
    msid_ad text,
    vid text,
    created timestamp with time zone,
    visitor_session_id integer,
    msid character varying(200)
);


ALTER TABLE public.visitor_msid OWNER TO phpuser;

--
-- Name: visitor_msid_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.visitor_msid_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.visitor_msid_id_seq OWNER TO phpuser;

--
-- Name: visitor_msid_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.visitor_msid_id_seq OWNED BY public.visitor_msid.id;


--
-- Name: visitor_promo; Type: TABLE; Schema: public; Owner: phpuser
--

CREATE TABLE public.visitor_promo (
    id bigint NOT NULL,
    vid text,
    promo text
);


ALTER TABLE public.visitor_promo OWNER TO phpuser;

--
-- Name: visitor_promo_id_seq; Type: SEQUENCE; Schema: public; Owner: phpuser
--

CREATE SEQUENCE public.visitor_promo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.visitor_promo_id_seq OWNER TO phpuser;

--
-- Name: visitor_promo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: phpuser
--

ALTER SEQUENCE public.visitor_promo_id_seq OWNED BY public.visitor_promo.id;


--
-- Name: visitor_sessions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.visitor_sessions (
    id bigint,
    ip character varying(16),
    uri text,
    referrer text,
    user_agent text,
    site_id integer,
    vid character varying(255),
    created timestamp without time zone,
    modified timestamp without time zone
);


ALTER TABLE public.visitor_sessions OWNER TO postgres;

--
-- Name: ad_groups id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.ad_groups ALTER COLUMN id SET DEFAULT nextval('public.ad_groups_id_seq'::regclass);


--
-- Name: blackout_days id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.blackout_days ALTER COLUMN id SET DEFAULT nextval('public.blackout_days_id_seq'::regclass);


--
-- Name: blocked_ips id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.blocked_ips ALTER COLUMN id SET DEFAULT nextval('public.blocked_ips_id_seq'::regclass);


--
-- Name: c_serviceability_zips id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.c_serviceability_zips ALTER COLUMN id SET DEFAULT nextval('public.c_serviceability_zips_id_seq'::regclass);


--
-- Name: cached_pages id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cached_pages ALTER COLUMN id SET DEFAULT nextval('public.cached_pages_id_seq'::regclass);


--
-- Name: cart_click_errors id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cart_click_errors ALTER COLUMN id SET DEFAULT nextval('public.cart_click_errors_id_seq'::regclass);


--
-- Name: cart_clicks id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cart_clicks ALTER COLUMN id SET DEFAULT nextval('public.cart_clicks_id_seq'::regclass);


--
-- Name: cart_errors id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cart_errors ALTER COLUMN id SET DEFAULT nextval('public.cart_errors_id_seq'::regclass);


--
-- Name: chats id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.chats ALTER COLUMN id SET DEFAULT nextval('public.chats_id_seq'::regclass);


--
-- Name: cis_tests id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cis_tests ALTER COLUMN id SET DEFAULT nextval('public.cis_tests_id_seq'::regclass);


--
-- Name: city_to_market id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.city_to_market ALTER COLUMN id SET DEFAULT nextval('public.city_to_market_id_seq'::regclass);


--
-- Name: cms_anchors id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_anchors ALTER COLUMN id SET DEFAULT nextval('public.cms_anchors_id_seq'::regclass);


--
-- Name: cms_block_categories id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_block_categories ALTER COLUMN id SET DEFAULT nextval('public.cms_block_categories_id_seq'::regclass);


--
-- Name: cms_blocks id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_blocks ALTER COLUMN id SET DEFAULT nextval('public.cms_blocks_id_seq'::regclass);


--
-- Name: cms_bold_chat_rules id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_bold_chat_rules ALTER COLUMN id SET DEFAULT nextval('public.cms_bold_chat_rules_id_seq'::regclass);


--
-- Name: cms_bundle_list_items id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_bundle_list_items ALTER COLUMN id SET DEFAULT nextval('public.cms_bundle_list_items_id_seq'::regclass);


--
-- Name: cms_category id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_category ALTER COLUMN id SET DEFAULT nextval('public.cms_category_id_seq'::regclass);


--
-- Name: cms_cities id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_cities ALTER COLUMN id SET DEFAULT nextval('public.cms_cities_id_seq'::regclass);


--
-- Name: cms_cities_to_markets id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_cities_to_markets ALTER COLUMN id SET DEFAULT nextval('public.cms_cities_to_markets_id_seq'::regclass);


--
-- Name: cms_form_required_fields id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_form_required_fields ALTER COLUMN id SET DEFAULT nextval('public.cms_form_required_fields_id_seq'::regclass);


--
-- Name: cms_forms id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_forms ALTER COLUMN id SET DEFAULT nextval('public.cms_forms_id_seq'::regclass);


--
-- Name: cms_map_cities id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_map_cities ALTER COLUMN id SET DEFAULT nextval('public.cms_map_cities_id_seq'::regclass);


--
-- Name: cms_markets id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_markets ALTER COLUMN id SET DEFAULT nextval('public.cms_markets_id_seq'::regclass);


--
-- Name: cms_nav_items id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_nav_items ALTER COLUMN id SET DEFAULT nextval('public.cms_nav_items_id_seq'::regclass);


--
-- Name: cms_nav_types id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_nav_types ALTER COLUMN id SET DEFAULT nextval('public.cms_nav_types_id_seq'::regclass);


--
-- Name: cms_page_components id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_page_components ALTER COLUMN id SET DEFAULT nextval('public.cms_page_components_id_seq'::regclass);


--
-- Name: cms_page_to_bundle id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_page_to_bundle ALTER COLUMN id SET DEFAULT nextval('public.cms_page_to_bundle_id_seq'::regclass);


--
-- Name: cms_page_to_component id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_page_to_component ALTER COLUMN id SET DEFAULT nextval('public.cms_page_to_component_id_seq'::regclass);


--
-- Name: cms_page_to_market id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_page_to_market ALTER COLUMN id SET DEFAULT nextval('public.cms_page_to_market_id_seq'::regclass);


--
-- Name: cms_page_to_rep id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_page_to_rep ALTER COLUMN id SET DEFAULT nextval('public.cms_page_to_rep_id_seq'::regclass);


--
-- Name: cms_page_types id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_page_types ALTER COLUMN id SET DEFAULT nextval('public.cms_page_types_id_seq'::regclass);


--
-- Name: cms_page_votes id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cms_page_votes ALTER COLUMN id SET DEFAULT nextval('public.cms_page_votes_id_seq'::regclass);


--
-- Name: cms_pages id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_pages ALTER COLUMN id SET DEFAULT nextval('public.cms_pages_id_seq'::regclass);


--
-- Name: cms_pricegrid_to_bundle id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_pricegrid_to_bundle ALTER COLUMN id SET DEFAULT nextval('public.cms_pricegrid_to_bundle_id_seq'::regclass);


--
-- Name: cms_pricegrid_to_rep id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_pricegrid_to_rep ALTER COLUMN id SET DEFAULT nextval('public.cms_pricegrid_to_rep_id_seq'::regclass);


--
-- Name: cms_pricegrid_types id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_pricegrid_types ALTER COLUMN id SET DEFAULT nextval('public.cms_pricegrid_types_id_seq'::regclass);


--
-- Name: cms_pricegrids id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_pricegrids ALTER COLUMN id SET DEFAULT nextval('public.cms_pricegrids_id_seq'::regclass);


--
-- Name: cms_random_block_items id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_random_block_items ALTER COLUMN id SET DEFAULT nextval('public.cms_random_block_items_id_seq'::regclass);


--
-- Name: cms_random_blocks id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_random_blocks ALTER COLUMN id SET DEFAULT nextval('public.cms_random_blocks_id_seq'::regclass);


--
-- Name: cms_random_bundle_items id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_random_bundle_items ALTER COLUMN id SET DEFAULT nextval('public.cms_random_bundle_items_id_seq'::regclass);


--
-- Name: cms_random_list_items id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_random_list_items ALTER COLUMN id SET DEFAULT nextval('public.cms_random_list_items_id_seq'::regclass);


--
-- Name: cms_random_lists id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_random_lists ALTER COLUMN id SET DEFAULT nextval('public.cms_random_lists_id_seq'::regclass);


--
-- Name: cms_rss_feeds id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_rss_feeds ALTER COLUMN id SET DEFAULT nextval('public.cms_rss_feeds_id_seq'::regclass);


--
-- Name: cms_site_to_bundle id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_site_to_bundle ALTER COLUMN id SET DEFAULT nextval('public.cms_site_to_bundle_id_seq'::regclass);


--
-- Name: cms_site_to_market id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_site_to_market ALTER COLUMN id SET DEFAULT nextval('public.cms_site_to_market_id_seq'::regclass);


--
-- Name: cms_site_to_rep id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_site_to_rep ALTER COLUMN id SET DEFAULT nextval('public.cms_site_to_rep_id_seq'::regclass);


--
-- Name: cms_sites id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_sites ALTER COLUMN id SET DEFAULT nextval('public.cms_sites_id_seq'::regclass);


--
-- Name: cms_slide_show_slides id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_slide_show_slides ALTER COLUMN id SET DEFAULT nextval('public.cms_slide_show_slides_id_seq'::regclass);


--
-- Name: cms_slide_shows id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_slide_shows ALTER COLUMN id SET DEFAULT nextval('public.cms_slide_shows_id_seq'::regclass);


--
-- Name: cms_slp_data id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_slp_data ALTER COLUMN id SET DEFAULT nextval('public.cms_slp_data_id_seq'::regclass);


--
-- Name: cms_states id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_states ALTER COLUMN id SET DEFAULT nextval('public.cms_states_id_seq'::regclass);


--
-- Name: cms_tab_to_bundle id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_tab_to_bundle ALTER COLUMN id SET DEFAULT nextval('public.cms_tab_to_bundle_id_seq'::regclass);


--
-- Name: cms_tab_to_rep id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_tab_to_rep ALTER COLUMN id SET DEFAULT nextval('public.cms_tab_to_rep_id_seq'::regclass);


--
-- Name: cms_tabs id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_tabs ALTER COLUMN id SET DEFAULT nextval('public.cms_tabs_id_seq'::regclass);


--
-- Name: cms_templates id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_templates ALTER COLUMN id SET DEFAULT nextval('public.cms_templates_id_seq'::regclass);


--
-- Name: cms_testimonials id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_testimonials ALTER COLUMN id SET DEFAULT nextval('public.cms_testimonials_id_seq'::regclass);


--
-- Name: cms_users id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.cms_users ALTER COLUMN id SET DEFAULT nextval('public.cms_users_id_seq'::regclass);


--
-- Name: commercial id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.commercial ALTER COLUMN id SET DEFAULT nextval('public.commercial_id_seq'::regclass);


--
-- Name: commission_structures id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.commission_structures ALTER COLUMN id SET DEFAULT nextval('public.commission_structures_id_seq'::regclass);


--
-- Name: eia_data id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.eia_data ALTER COLUMN id SET DEFAULT nextval('public.eia_data_id_seq'::regclass);


--
-- Name: email_dump id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.email_dump ALTER COLUMN id SET DEFAULT nextval('public.email_dump_id_seq'::regclass);


--
-- Name: geo_data id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.geo_data ALTER COLUMN id SET DEFAULT nextval('public.geo_data_id_seq'::regclass);


--
-- Name: google_analytics id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.google_analytics ALTER COLUMN id SET DEFAULT nextval('public.google_analytics_id_seq'::regclass);


--
-- Name: historical_order_averages id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.historical_order_averages ALTER COLUMN id SET DEFAULT nextval('public.historical_order_averages_id_seq'::regclass);


--
-- Name: item_checkout_cart_mobile_pages single_page; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_checkout_cart_mobile_pages ALTER COLUMN single_page SET DEFAULT 'n'::bpchar;


--
-- Name: item_checkout_cart_mobile_stacked_myaccounts single_page; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_checkout_cart_mobile_stacked_myaccounts ALTER COLUMN single_page SET DEFAULT 'n'::bpchar;


--
-- Name: item_checkout_cart_mobile_stackeds single_page; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_checkout_cart_mobile_stackeds ALTER COLUMN single_page SET DEFAULT 'n'::bpchar;


--
-- Name: item_commission_upfronts commodity; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_commission_upfronts ALTER COLUMN commodity SET DEFAULT 'e'::bpchar;


--
-- Name: item_cost_clawbacks paid; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_cost_clawbacks ALTER COLUMN paid SET DEFAULT 'n'::bpchar;


--
-- Name: item_cost_flowings paid; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_cost_flowings ALTER COLUMN paid SET DEFAULT 'n'::bpchar;


--
-- Name: item_cost_upfronts paid; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_cost_upfronts ALTER COLUMN paid SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_commercial_contracts opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_commercial_contracts ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_commercial_contracts clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_commercial_contracts ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_commercial_contracts dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_commercial_contracts ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_commercial_contracts last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_commercial_contracts ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_commercial_leads opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_commercial_leads ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_commercial_leads clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_commercial_leads ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_commercial_leads dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_commercial_leads ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_commercial_leads last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_commercial_leads ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_confirmation_commercial_contracts opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_confirmation_commercial_contracts ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_confirmation_commercial_contracts clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_confirmation_commercial_contracts ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_confirmation_commercial_contracts dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_confirmation_commercial_contracts ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_confirmation_commercial_contracts last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_confirmation_commercial_contracts ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_confirmation_commercials opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_confirmation_commercials ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_confirmation_commercials clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_confirmation_commercials ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_confirmation_commercials dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_confirmation_commercials ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_confirmation_commercials last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_confirmation_commercials ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_confirmations opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_confirmations ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_confirmations clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_confirmations ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_confirmations dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_confirmations ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_confirmations last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_confirmations ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_customs opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_customs ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_customs clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_customs ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_customs dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_customs ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_customs last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_customs ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_depositcrosssells opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_depositcrosssells ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_depositcrosssells clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_depositcrosssells ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_depositcrosssells dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_depositcrosssells ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_depositcrosssells last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_depositcrosssells ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_docusigns opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_docusigns ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_docusigns clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_docusigns ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_docusigns dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_docusigns ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_docusigns last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_docusigns ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_drip_captures opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_drip_captures ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_drip_captures clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_drip_captures ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_drip_captures dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_drip_captures ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_drip_captures last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_drip_captures ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_drip_churn_polrs opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_drip_churn_polrs ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_drip_churn_polrs clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_drip_churn_polrs ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_drip_churn_polrs dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_drip_churn_polrs ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_drip_churn_polrs last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_drip_churn_polrs ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_drip_churns opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_drip_churns ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_drip_churns clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_drip_churns ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_drip_churns dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_drip_churns ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_drip_churns last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_drip_churns ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_drips opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_drips ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_drips clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_drips ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_drips dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_drips ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_drips last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_drips ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_dtv_leads opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_dtv_leads ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_dtv_leads clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_dtv_leads ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_dtv_leads dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_dtv_leads ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_dtv_leads last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_dtv_leads ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_errors opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_errors ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_errors clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_errors ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_errors dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_errors ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_errors last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_errors ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_google_reviews opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_google_reviews ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_google_reviews clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_google_reviews ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_google_reviews dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_google_reviews ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_google_reviews last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_google_reviews ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_hold_order_notifications opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_hold_order_notifications ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_hold_order_notifications clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_hold_order_notifications ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_hold_order_notifications dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_hold_order_notifications ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_hold_order_notifications last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_hold_order_notifications ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_hold_order_reminders opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_hold_order_reminders ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_hold_order_reminders clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_hold_order_reminders ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_hold_order_reminders dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_hold_order_reminders ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_hold_order_reminders last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_hold_order_reminders ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_hold_orders opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_hold_orders ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_hold_orders clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_hold_orders ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_hold_orders dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_hold_orders ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_hold_orders last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_hold_orders ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_lead_dtvs opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_lead_dtvs ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_lead_dtvs clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_lead_dtvs ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_lead_dtvs dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_lead_dtvs ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_lead_dtvs last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_lead_dtvs ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_leads opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_leads ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_leads clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_leads ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_leads dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_leads ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_leads last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_leads ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_myaccount_claim_rafs opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_claim_rafs ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccount_claim_rafs clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_claim_rafs ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccount_claim_rafs dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_claim_rafs ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccount_claim_rafs last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_claim_rafs ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_myaccount_contract_expirations opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_contract_expirations ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccount_contract_expirations clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_contract_expirations ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccount_contract_expirations dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_contract_expirations ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccount_contract_expirations last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_contract_expirations ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_myaccount_rafs opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_rafs ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccount_rafs clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_rafs ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccount_rafs dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_rafs ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccount_rafs last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_rafs ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_myaccount_registers opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_registers ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccount_registers clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_registers ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccount_registers dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_registers ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccount_registers last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_registers ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_myaccount_renewals opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_renewals ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccount_renewals clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_renewals ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccount_renewals dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_renewals ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccount_renewals last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccount_renewals ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_myaccounts opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccounts ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccounts clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccounts ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccounts dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccounts ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_myaccounts last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_myaccounts ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_order_cancelleds opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_order_cancelleds ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_order_cancelleds clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_order_cancelleds ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_order_cancelleds dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_order_cancelleds ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_order_cancelleds last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_order_cancelleds ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_orderss opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_orderss ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_orderss clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_orderss ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_orderss dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_orderss ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_orderss last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_orderss ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_outbox_notifications opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_outbox_notifications ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_outbox_notifications clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_outbox_notifications ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_outbox_notifications dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_outbox_notifications ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_outbox_notifications last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_outbox_notifications ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_outboxs opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_outboxs ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_outboxs clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_outboxs ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_outboxs dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_outboxs ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_outboxs last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_outboxs ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_partial_cart_firsts opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_partial_cart_firsts ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_partial_cart_firsts clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_partial_cart_firsts ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_partial_cart_firsts dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_partial_cart_firsts ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_partial_cart_firsts last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_partial_cart_firsts ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_partial_cart_seconds opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_partial_cart_seconds ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_partial_cart_seconds clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_partial_cart_seconds ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_partial_cart_seconds dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_partial_cart_seconds ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_partial_cart_seconds last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_partial_cart_seconds ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_partial_cart_thirds opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_partial_cart_thirds ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_partial_cart_thirds clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_partial_cart_thirds ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_partial_cart_thirds dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_partial_cart_thirds ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_partial_cart_thirds last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_partial_cart_thirds ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_partial_carts opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_partial_carts ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_partial_carts clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_partial_carts ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_partial_carts dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_partial_carts ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_partial_carts last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_partial_carts ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_prepared_cart_reminders opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_prepared_cart_reminders ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_prepared_cart_reminders clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_prepared_cart_reminders ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_prepared_cart_reminders dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_prepared_cart_reminders ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_prepared_cart_reminders last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_prepared_cart_reminders ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_prepared_carts opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_prepared_carts ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_prepared_carts clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_prepared_carts ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_prepared_carts dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_prepared_carts ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_prepared_carts last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_prepared_carts ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_rate_receiveds opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_rate_receiveds ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_rate_receiveds clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_rate_receiveds ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_rate_receiveds dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_rate_receiveds ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_rate_receiveds last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_rate_receiveds ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_rejecteds opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_rejecteds ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_rejecteds clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_rejecteds ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_rejecteds dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_rejecteds ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_rejecteds last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_rejecteds ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_renewals opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_renewals ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_renewals clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_renewals ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_renewals dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_renewals ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_renewals last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_renewals ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_rep_questionnaires opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_rep_questionnaires ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_rep_questionnaires clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_rep_questionnaires ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_rep_questionnaires dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_rep_questionnaires ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_rep_questionnaires last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_rep_questionnaires ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_review_approveds opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_approveds ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_review_approveds clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_approveds ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_review_approveds dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_approveds ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_review_approveds last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_approveds ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_review_comment_ters opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_comment_ters ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_review_comment_ters clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_comment_ters ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_review_comment_ters dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_comment_ters ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_review_comment_ters last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_comment_ters ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_review_comments opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_comments ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_review_comments clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_comments ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_review_comments dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_comments ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_review_comments last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_comments ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_review_pendings opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_pendings ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_review_pendings clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_pendings ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_review_pendings dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_pendings ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_review_pendings last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_pendings ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_review_receiveds opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_receiveds ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_review_receiveds clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_receiveds ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_review_receiveds dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_receiveds ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_review_receiveds last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_review_receiveds ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_reviews opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_reviews ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_reviews clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_reviews ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_reviews dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_reviews ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_reviews last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_reviews ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_solar_leads opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_solar_leads ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_solar_leads clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_solar_leads ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_solar_leads dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_solar_leads ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_solar_leads last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_solar_leads ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: item_email_write_reviews opened; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_write_reviews ALTER COLUMN opened SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_write_reviews clicked; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_write_reviews ALTER COLUMN clicked SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_write_reviews dropped; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_write_reviews ALTER COLUMN dropped SET DEFAULT 'n'::bpchar;


--
-- Name: item_email_write_reviews last_updated; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.item_email_write_reviews ALTER COLUMN last_updated SET DEFAULT 0;


--
-- Name: kpi_numbers id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.kpi_numbers ALTER COLUMN id SET DEFAULT nextval('public.kpi_numbers_id_seq'::regclass);


--
-- Name: kpi_numbers_daily id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.kpi_numbers_daily ALTER COLUMN id SET DEFAULT nextval('public.kpi_numbers_daily_id_seq'::regclass);


--
-- Name: kpi_values id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.kpi_values ALTER COLUMN id SET DEFAULT nextval('public.kpi_values_id_seq'::regclass);


--
-- Name: kw_action_compare id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.kw_action_compare ALTER COLUMN id SET DEFAULT nextval('public.kw_action_compare_id_seq'::regclass);


--
-- Name: kw_action_switch id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.kw_action_switch ALTER COLUMN id SET DEFAULT nextval('public.kw_action_switch_id_seq'::regclass);


--
-- Name: kw_energy_name id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.kw_energy_name ALTER COLUMN id SET DEFAULT nextval('public.kw_energy_name_id_seq'::regclass);


--
-- Name: kw_provider id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.kw_provider ALTER COLUMN id SET DEFAULT nextval('public.kw_provider_id_seq'::regclass);


--
-- Name: kw_rates_prices id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.kw_rates_prices ALTER COLUMN id SET DEFAULT nextval('public.kw_rates_prices_id_seq'::regclass);


--
-- Name: kw_reviews id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.kw_reviews ALTER COLUMN id SET DEFAULT nextval('public.kw_reviews_id_seq'::regclass);


--
-- Name: kw_utility id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.kw_utility ALTER COLUMN id SET DEFAULT nextval('public.kw_utility_id_seq'::regclass);


--
-- Name: kw_value id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.kw_value ALTER COLUMN id SET DEFAULT nextval('public.kw_value_id_seq'::regclass);


--
-- Name: langs id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.langs ALTER COLUMN id SET DEFAULT nextval('public.langs_id_seq'::regclass);


--
-- Name: more_info_clicks id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.more_info_clicks ALTER COLUMN id SET DEFAULT nextval('public.more_info_clicks_id_seq'::regclass);


--
-- Name: page_update_log id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.page_update_log ALTER COLUMN id SET DEFAULT nextval('public.page_update_log_id_seq'::regclass);


--
-- Name: plan_click_summary id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.plan_click_summary ALTER COLUMN id SET DEFAULT nextval('public.plan_click_summary_id_seq'::regclass);


--
-- Name: plan_clicks id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.plan_clicks ALTER COLUMN id SET DEFAULT nextval('public.plan_clicks_id_seq'::regclass);


--
-- Name: plan_features id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.plan_features ALTER COLUMN id SET DEFAULT nextval('public.plan_features_id_seq'::regclass);


--
-- Name: plan_group_log id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.plan_group_log ALTER COLUMN id SET DEFAULT nextval('public.plan_group_log_id_seq'::regclass);


--
-- Name: plan_groups id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.plan_groups ALTER COLUMN id SET DEFAULT nextval('public.plan_groups_id_seq'::regclass);


--
-- Name: plan_market_charges id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.plan_market_charges ALTER COLUMN id SET DEFAULT nextval('public.plan_market_charges_id_seq'::regclass);


--
-- Name: plan_market_schedules id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.plan_market_schedules ALTER COLUMN id SET DEFAULT nextval('public.plan_market_schedules_id_seq'::regclass);


--
-- Name: plan_markets id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.plan_markets ALTER COLUMN id SET DEFAULT nextval('public.plan_markets_id_seq'::regclass);


--
-- Name: plan_markets_historical id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.plan_markets_historical ALTER COLUMN id SET DEFAULT nextval('public.plan_markets_historical_id_seq'::regclass);


--
-- Name: plan_markets_tx id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.plan_markets_tx ALTER COLUMN id SET DEFAULT nextval('public.plan_markets_tx_id_seq'::regclass);


--
-- Name: plan_views id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.plan_views ALTER COLUMN id SET DEFAULT nextval('public.plan_views_id_seq'::regclass);


--
-- Name: plans id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.plans ALTER COLUMN id SET DEFAULT nextval('public.plans_id_seq'::regclass);


--
-- Name: plugin_users id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.plugin_users ALTER COLUMN id SET DEFAULT nextval('public.plugin_users_id_seq'::regclass);


--
-- Name: price_to_compare id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.price_to_compare ALTER COLUMN id SET DEFAULT nextval('public.price_to_compare_id_seq'::regclass);


--
-- Name: ptc_data id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.ptc_data ALTER COLUMN id SET DEFAULT nextval('public.ptc_data_id_seq'::regclass);


--
-- Name: ptc_stats id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.ptc_stats ALTER COLUMN id SET DEFAULT nextval('public.ptc_stats_id_seq'::regclass);


--
-- Name: rating_category id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.rating_category ALTER COLUMN id SET DEFAULT nextval('public.rating_category_id_seq'::regclass);


--
-- Name: rating_category_rating_criteria id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.rating_category_rating_criteria ALTER COLUMN id SET DEFAULT nextval('public.rating_category_rating_criteria_id_seq'::regclass);


--
-- Name: rating_criteria id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.rating_criteria ALTER COLUMN id SET DEFAULT nextval('public.rating_criteria_id_seq'::regclass);


--
-- Name: rating_formula id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.rating_formula ALTER COLUMN id SET DEFAULT nextval('public.rating_formula_id_seq'::regclass);


--
-- Name: rating_formula_rating_criteria id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.rating_formula_rating_criteria ALTER COLUMN id SET DEFAULT nextval('public.rating_formula_rating_criteria_id_seq'::regclass);


--
-- Name: ratings id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.ratings ALTER COLUMN id SET DEFAULT nextval('public.ratings_id_seq'::regclass);


--
-- Name: rep_blocks id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.rep_blocks ALTER COLUMN id SET DEFAULT nextval('public.rep_blocks_id_seq'::regclass);


--
-- Name: rep_efls id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.rep_efls ALTER COLUMN id SET DEFAULT nextval('public.rep_efls_id_seq'::regclass);


--
-- Name: rep_info id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.rep_info ALTER COLUMN id SET DEFAULT nextval('public.rep_info_id_seq'::regclass);


--
-- Name: rep_info_to_market id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.rep_info_to_market ALTER COLUMN id SET DEFAULT nextval('public.rep_info_to_market_id_seq'::regclass);


--
-- Name: rep_moneys id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.rep_moneys ALTER COLUMN id SET DEFAULT nextval('public.rep_moneys_id_seq'::regclass);


--
-- Name: rep_puc id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.rep_puc ALTER COLUMN id SET DEFAULT nextval('public.rep_puc_id_seq'::regclass);


--
-- Name: rep_scores id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.rep_scores ALTER COLUMN id SET DEFAULT nextval('public.rep_scores_id_seq'::regclass);


--
-- Name: rep_states id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.rep_states ALTER COLUMN id SET DEFAULT nextval('public.rep_states_id_seq'::regclass);


--
-- Name: rep_users id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.rep_users ALTER COLUMN id SET DEFAULT nextval('public.rep_users_id_seq'::regclass);


--
-- Name: reps id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.reps ALTER COLUMN id SET DEFAULT nextval('public.reps_id_seq'::regclass);


--
-- Name: residual id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.residual ALTER COLUMN id SET DEFAULT nextval('public.residual_id_seq'::regclass);


--
-- Name: review id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.review ALTER COLUMN id SET DEFAULT nextval('public.review_id_seq'::regclass);


--
-- Name: review_comment id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.review_comment ALTER COLUMN id SET DEFAULT nextval('public.review_comment_id_seq'::regclass);


--
-- Name: scholarships id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.scholarships ALTER COLUMN id SET DEFAULT nextval('public.scholarships_id_seq'::regclass);


--
-- Name: spinner_values id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.spinner_values ALTER COLUMN id SET DEFAULT nextval('public.spinner_values_id_seq'::regclass);


--
-- Name: spinners id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.spinners ALTER COLUMN id SET DEFAULT nextval('public.spinners_id_seq'::regclass);


--
-- Name: tdsp_fees id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.tdsp_fees ALTER COLUMN id SET DEFAULT nextval('public.tdsp_fees_id_seq'::regclass);


--
-- Name: ticket_contact_chat_inbounds user_open; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.ticket_contact_chat_inbounds ALTER COLUMN user_open SET DEFAULT 'c'::bpchar;


--
-- Name: ticket_contact_chat_outbounds user_open; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.ticket_contact_chat_outbounds ALTER COLUMN user_open SET DEFAULT 'c'::bpchar;


--
-- Name: utilities id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.utilities ALTER COLUMN id SET DEFAULT nextval('public.utilities_id_seq'::regclass);


--
-- Name: visitor id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.visitor ALTER COLUMN id SET DEFAULT nextval('public.visitor_id_seq'::regclass);


--
-- Name: visitor_msid id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.visitor_msid ALTER COLUMN id SET DEFAULT nextval('public.visitor_msid_id_seq'::regclass);


--
-- Name: visitor_promo id; Type: DEFAULT; Schema: public; Owner: phpuser
--

ALTER TABLE ONLY public.visitor_promo ALTER COLUMN id SET DEFAULT nextval('public.visitor_promo_id_seq'::regclass);


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

COPY public.action_api_energytexas_creates (id, ticket_id, item_id, queue_id, jdoc, agent_id, logtype, method, start_time, end_time, seconds) FROM stdin;
\.


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

COPY public.action_api_energytexas_dispositions (id, ticket_id, item_id, queue_id, jdoc, agent_id, logtype, method, start_time, end_time, seconds) FROM stdin;
\.


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

COPY public.action_api_energytexas_logins (id, ticket_id, item_id, queue_id, jdoc, agent_id, logtype, method, start_time, end_time, seconds) FROM stdin;
\.


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

COPY public.action_api_energytexas_validates (id, ticket_id, item_id, queue_id, jdoc, agent_id, logtype, method, start_time, end_time, seconds) FROM stdin;
\.


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

COPY public.action_api_energytexass (id, ticket_id, item_id, queue_id, jdoc, agent_id, logtype, method, start_time, end_time, seconds) FROM stdin;
\.


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

COPY public.action_apis (id, ticket_id, item_id, queue_id, jdoc, agent_id, logtype, method, start_time, end_time, seconds) FROM stdin;
\.


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

COPY public.action_emails (id, ticket_id, item_id, queue_id, jdoc, agent_id, logtype) FROM stdin;
\.


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

COPY public.actions (id, ticket_id, item_id, queue_id, jdoc, agent_id, logtype) FROM stdin;
\.


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

COPY public.ad_groups (id, auto_created, name, words_geo, words_energy, words_state, campaign, ad_group, ad_text_1, ad_text_2, ad_text_3, ad_text_link, words_valueprop) FROM stdin;
3	\N	NY Green Geo	Albany,Buffalo,Manhattan	green	NY, New York	NYER	~geo~~energy~	~geo~ should get ~energy~ power too!	\N	\N	\N	\N
5	\N	NY Geo	Albany,Buffalo,Manhattan	\N	NY,New York	NYER	~geo~~state~	~geo~, ~state~ electricity rates	\N	\N	\N	\N
6	\N	NY Provider	\N	\N	NY,New York	NYER	~provider~~state~	Electricity ~provider~ - learn more	\N	\N	\N	\N
7	\N	NY Compare	\N	\N	NY,New York	NYER	~compare~~state~|~valueprop~~state~	You have choices in ~state~	\N	\N	\N	\N
8	\N	NY Valueprop	\N	\N	NY,New York	NYER	~valueprop~~state~	Shop the ~valueprop~ power in ~state~	\N	\N	\N	Lowest Cost,Cheapest
9	\N	NY Valueprop Provider	\N	\N	NY,New York	NYER	~valueprop~~provider~	Find the ~valueprop~ power ~provider~	\N	\N	\N	\N
10	\N	NY Green Geo 2	Albany,Buffalo,Manhattan	green		NYER	~energy~~geo~~energy_type~	Get ~energy~ ~energy_type~ in ~geo~	\N	\N	\N	\N
\.


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

COPY public.adwords (id, v, s, c, g, a, headline1, headline2, body1, body2) FROM stdin;
\.


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

COPY public.alarmclock_archives (id, ticket_id, ticket_class, ticket_method, called_class, epoch, start_epoch, end_epoch, results) FROM stdin;
\.


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

COPY public.alarmclocks (id, ticket_id, ticket_class, ticket_method, called_class, epoch) FROM stdin;
\.


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

COPY public.blackout_days (blackout_date, rep, id) FROM stdin;
2019-05-27	all	1
2019-09-02	all	3
2019-11-28	all	4
2019-11-29	all	7
2019-11-30	all	8
2020-12-25	all	6
2020-12-24	all	5
2020-07-04	all	2
2020-10-31	all	9
2020-11-01	all	10
2021-01-18	all	34
2021-02-15	1303	35
2020-11-05	TX-E-ONCOR	11
2020-11-06	TX-E-ONCOR	12
2020-11-07	TX-E-ONCOR	13
2020-11-08	TX-E-ONCOR	14
2020-11-09	TX-E-ONCOR	15
2020-11-05	TX-E-TNMP	16
2020-11-06	TX-E-TNMP	17
2020-11-07	TX-E-TNMP	18
2020-11-08	TX-E-TNMP	19
2020-11-09	TX-E-TNMP	20
2021-02-16	1303	36
2021-02-17	1303	37
2021-02-18	1303	38
2021-02-19	1303	39
2020-11-06	TX-E-AEPCENTRAL	21
2020-11-07	TX-E-AEPCENTRAL	22
2020-11-08	TX-E-AEPCENTRAL	23
2020-11-09	TX-E-AEPCENTRAL	24
2021-02-20	1303	40
2020-11-06	TX-E-AEPNORTH	26
2021-02-21	1303	41
2020-11-08	TX-E-AEPNORTH	28
2020-11-09	TX-E-AEPNORTH	29
2020-11-10	TX-E-AEPCENTRAL	25
2020-11-10	TX-E-AEPNORTH	30
2020-11-07	TX-E-AEPNORTH	27
2020-11-09	TX-E-CENTERPOINT	31
2020-11-10	TX-E-CENTERPOINT	32
2020-11-11	TX-E-CENTERPOINT	33
2021-02-21	1253	102
2021-02-20	1253	101
2021-02-24	1582	114
2021-12-24	all	103
2021-12-25	all	104
2021-02-15	1547	42
2021-02-16	1547	43
2021-02-17	1547	44
2021-02-18	1547	45
2021-02-19	1547	46
2021-02-20	1547	47
2021-02-21	1547	48
2021-05-31	all	119
2021-02-16	all	105
2021-02-15	1256	84
2021-02-16	1256	85
2021-02-17	1256	86
2021-02-18	1256	87
2021-02-19	1256	88
2021-02-20	1256	89
2021-02-21	1256	90
2021-02-15	1270	49
2021-02-16	1270	50
2021-02-17	1270	51
2021-02-18	1270	52
2021-02-19	1270	53
2021-02-20	1270	54
2021-02-21	1270	55
2021-02-15	1322	63
2021-02-16	1322	64
2021-02-17	1322	65
2021-02-18	1322	66
2021-02-19	1322	67
2021-02-20	1322	68
2021-02-21	1322	69
2021-02-22	1322	70
2021-02-15	1287	56
2021-02-16	1287	57
2021-02-17	1287	58
2021-02-18	1287	59
2021-02-19	1287	60
2021-02-20	1287	61
2021-02-21	1287	62
2021-02-23	1322	71
2021-02-24	1322	72
2021-02-25	1322	73
2021-02-26	1322	74
2021-02-27	1322	75
2021-02-28	1322	76
2021-02-17	1551	92
2021-02-18	1551	93
2021-02-16	1551	91
2021-02-19	1551	94
2021-02-21	1551	95
2021-02-22	1551	96
2021-02-15	1274	77
2021-02-16	1274	78
2021-02-17	1274	79
2021-02-18	1274	80
2021-02-19	1274	81
2021-02-20	1274	82
2021-02-21	1274	83
2021-02-25	1582	115
2021-02-26	1582	116
2021-02-16	1253	97
2021-02-16	1253	98
2021-02-16	1253	99
2021-02-16	1253	100
2021-02-27	1582	117
\N	\N	120
2021-02-28	1582	118
2021-02-16	1582	106
2021-02-20	1582	110
2021-02-17	1582	107
2021-02-18	1582	108
2021-02-19	1582	109
2021-02-21	1582	111
2021-02-22	1582	112
2021-02-23	1582	113
\.


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

COPY public.blocked_ips (id, ip, vid, created) FROM stdin;
\.


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

COPY public.bookings (id, rep_id, state, period, upfront, residual, orders, residual_orders, upfront_item_id, residual_item_id) FROM stdin;
\.


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

COPY public.bucket_lifecycles (id, ticket_id, entered, submitted, errors, deposit, sent, flowing, churned, cancelled) FROM stdin;
\.


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

COPY public.bucket_marketings (id, ticket_id, market_source, search_type, company, search_source, search_company, search_referrer) FROM stdin;
\.


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

COPY public.bucket_plans (id, ticket_id, months, plan_name, rep_name, state) FROM stdin;
\.


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

COPY public.bucket_tpvs (id, ticket_id, tpv_completed, tpv_approved, tpv_rejected) FROM stdin;
\.


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

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


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

COPY public.c_serviceability_zips (zip_code, tdsp, tdsp_id, city, city_name_url, state, commodity, overlap, conflicted, default_utility, population, id, updated) FROM stdin;
\.


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

COPY public.cached_pages (id, uri, site_id, market_id, page_id, file_name, dirty, has_rates, counter, hard_cache, created, modified, checked) FROM stdin;
\.


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

COPY public.cart_click_errors (id, cart_click_id, field_name, error_message) FROM stdin;
\.


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

COPY public.cart_clicks (id, plan_id, ticket_id, guid) FROM stdin;
\.


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

COPY public.cart_errors (id, ticket_id, item_id, rep_id, state, item_model, field, error, created) FROM stdin;
\.


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

COPY public.chats (id, ticket_id, author, user_id, message, created) FROM stdin;
\.


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

COPY public.cis_notifications (id, user_id, title, message, url, created, group_key, status, allow_handle) FROM stdin;
\.


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

COPY public.cis_tests (id, name, model, method, data, status, result, started, finished) FROM stdin;
\.


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

COPY public.city_datas (id, city, state, key, value, description) FROM stdin;
\.


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

COPY public.city_to_market (id, city, state, market_id, plans, created, modified, zips) FROM stdin;
\.


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

COPY public.city_to_zip_count (city, zip5, thecount) FROM stdin;
\.


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

COPY public.cms_anchors (id, slug, href, content, is_nofollow) FROM stdin;
\.


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

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


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

COPY public.cms_blocks (id, slug, content, category_id) FROM stdin;
\.


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

COPY public.cms_bold_chat_rules (id, name, code) FROM stdin;
\.


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

COPY public.cms_bundle_list_items (id, bundle_custom_id, list_item_content, hover_content, sort_order) FROM stdin;
\.


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

COPY public.cms_category (id, title) FROM stdin;
\.


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

COPY public.cms_cities (id, name, state_id) FROM stdin;
\.


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

COPY public.cms_cities_to_markets (id, city, region_id, market_id, state_id) FROM stdin;
\.


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

COPY public.cms_form_required_fields (id, form_id, field_name) FROM stdin;
\.


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

COPY public.cms_forms (id, name, email_subject_line, email_recipients, confirmation_page_url, event_name) FROM stdin;
\.


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

COPY public.cms_map_cities (id, name, state) FROM stdin;
\.


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

COPY public.cms_markets (id, parent_id, name, type, description, state, phone, duns_number, status, commodity) FROM stdin;
\.


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

COPY public.cms_nav_items (id, parent, site_id, page_id, category_id, nav_item_type_id, nav_title, class, url, sort_order) FROM stdin;
\.


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

COPY public.cms_nav_types (id, type) FROM stdin;
\.


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

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


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

COPY public.cms_page_to_bundle (id, page_id, bundle_id) FROM stdin;
\.


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

COPY public.cms_page_to_component (id, page_id, component_id) FROM stdin;
\.


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

COPY public.cms_page_to_market (id, page_id, market_id) FROM stdin;
\.


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

COPY public.cms_page_to_rep (id, page_id, rep_id) FROM stdin;
\.


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

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


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

COPY public.cms_page_votes (id, vid, page_id, vote, created) FROM stdin;
\.


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

COPY public.cms_pages (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, rep_id, depth) FROM stdin;
\.


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

COPY public.cms_pages_deleting (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_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) FROM stdin;
\.


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

COPY public.cms_pricegrid_to_bundle (id, pricegrid_id, bundle_id) FROM stdin;
\.


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

COPY public.cms_pricegrid_to_rep (id, pricegrid_id, rep_id) FROM stdin;
\.


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

COPY public.cms_pricegrid_types (id, type, sort_order) FROM stdin;
\.


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

COPY public.cms_pricegrids (id, slug, description, type_id, more_link, header_title, plan_page_link_option, order_page_slug) FROM stdin;
\.


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

COPY public.cms_random_block_items (id, random_block_id, content) FROM stdin;
\.


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

COPY public.cms_random_blocks (id, slug, description) FROM stdin;
\.


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

COPY public.cms_random_bundle_items (id, bundle_custom_id, description) FROM stdin;
\.


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

COPY public.cms_random_list_items (id, random_list_id, content) FROM stdin;
\.


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

COPY public.cms_random_lists (id, slug, description) FROM stdin;
\.


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

COPY public.cms_rss_feeds (id, slug, description, feed_url) FROM stdin;
\.


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

COPY public.cms_site_to_bundle (id, site_id, bundle_id) FROM stdin;
\.


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

COPY public.cms_site_to_market (id, site_id, market_id) FROM stdin;
\.


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

COPY public.cms_site_to_rep (id, site_id, rep_id) FROM stdin;
\.


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

COPY public.cms_sites (id, name, short_name, tag_line, domain, domain_pretty, city_id, state_id, google_analytics_id, google_maps_key, phone, phone_tx, phone_ga, footer_content, address_box_title, bold_chat_rule_id, plan_page_url, category_id, logo, formula_id, all_reviews, zip_entry_redirect_url, base_url, cart_base_url, location_street, location_city, location_state, location_zip, star_rating, star_count) FROM stdin;
\.


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

COPY public.cms_slide_show_slides (id, slide_show_id, sort_order, duration, content) FROM stdin;
\.


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

COPY public.cms_slide_shows (id, slug, description, css_class) FROM stdin;
\.


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

COPY public.cms_slp_data (id, slp_slug, page_slug, geo_1, geo_2, energy_type, var_1, sitemap_title, sitemap_category, market_id) FROM stdin;
\.


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

COPY public.cms_states (id, name, abbrev) FROM stdin;
\.


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

COPY public.cms_tab_to_bundle (id, tab_id, bundle_id, "order") FROM stdin;
\.


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

COPY public.cms_tab_to_rep (id, tab_id, rep_id) FROM stdin;
\.


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

COPY public.cms_tabs (id, grid_id, name, label, "order", style, label_style, viewall) FROM stdin;
\.


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

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


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

COPY public.cms_testimonials (id, content, person_name, person_location) FROM stdin;
\.


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

COPY public.cms_users (id, username, password) FROM stdin;
\.


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

COPY public.commercial (id, company_name, email, first_name, last_name, phone, zip_code, monthly_bill, ctime, email_sent, recipients, sent_time, commodity, state) FROM stdin;
\.


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

COPY public.commission_structures (id, rep_id, state, commodity, start_date, end_date, upfront, mills, promo_code) FROM stdin;
\.


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

COPY public.company_logs (id, company_id, agent_id, message, ticket_id) FROM stdin;
\.


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

COPY public.company_plans (id, company_id, plan_id) FROM stdin;
1510695232814648466	1485366834806228017	4611
1510695232819048466	1485366834806228017	4406
1510695232822048466	1485366834806228017	4612
1510695232825048466	1485366834806228017	4240
1510695232828148466	1485366834806228017	4404
1510695232831248466	1485366834806228017	4405
1510695232834248466	1485366834806228017	4613
1510695232837348466	1485366834806228017	4672
1510695232840348466	1485366834806228017	4407
1510695232843348466	1485366834806228017	4530
1512404559712318910	1484949957586253110	4616
1512404559716418910	1484949957586253110	4617
1512404559718918910	1484949957586253110	4611
1512404559721218910	1484949957586253110	4406
1512404559723618910	1484949957586253110	4612
1512404559726018910	1484949957586253110	4404
1512404559728218910	1484949957586253110	4405
1512404559730618910	1484949957586253110	4613
1512404559732918910	1484949957586253110	4407
1512404559735318910	1484949957586253110	4530
1512404559737718910	1484949957586253110	4458
1512404559740018910	1484949957586253110	4521
1512404559742418910	1484949957586253110	4522
1512404559744718910	1484949957586253110	4455
1512404559747018910	1484949957586253110	4456
1512404559749518910	1484949957586253110	4457
1512404559751918910	1484949957586253110	4454
1512404559754418910	1484949957586253110	5595
1512404559757018910	1484949957586253110	4408
1512404559759618910	1484949957586253110	4459
1512404559761918910	1484949957586253110	4409
1512404559764318910	1484949957586253110	5496
1512404559766718910	1484949957586253110	5495
1512404559769218910	1484949957586253110	5494
1485300876023752268	1485300747153051805	4174
1485300876026352268	1485300747153051805	4173
1485300876028852268	1485300747153051805	2324
1485300876031452268	1485300747153051805	7
1485300876033752268	1485300747153051805	1146
1485300876036352268	1485300747153051805	3972
1485300876038752268	1485300747153051805	2513
1485300876041252268	1485300747153051805	1241
1485300876043752268	1485300747153051805	2080
1485300876046052268	1485300747153051805	4143
1485300876048352268	1485300747153051805	30
1485300876050752268	1485300747153051805	3892
1485300876053252268	1485300747153051805	2519
1485300876055652268	1485300747153051805	4258
1485300876058052268	1485300747153051805	4220
1485300876060452268	1485300747153051805	4221
1485300876062752268	1485300747153051805	4198
1485300876065252268	1485300747153051805	39
1485300876067552268	1485300747153051805	68
1485300876069952268	1485300747153051805	2524
1485300876072452268	1485300747153051805	2410
1485300876074752268	1485300747153051805	4199
1485300876077152268	1485300747153051805	130
1485300876079652268	1485300747153051805	2412
1485300876082052268	1485300747153051805	2411
1485300876084452268	1485300747153051805	2570
1485300876086952268	1485300747153051805	2408
1485300876089552268	1485300747153051805	4611
1485300876091952268	1485300747153051805	4612
1485300876094452268	1485300747153051805	4406
1485300876097652268	1485300747153051805	4240
1485300876100752268	1485300747153051805	4404
1485300876103552268	1485300747153051805	4405
1485300876106452268	1485300747153051805	4272
1485300876109552268	1485300747153051805	4613
1485300876112352268	1485300747153051805	4239
1485300876114652268	1485300747153051805	4407
1485300876117252268	1485300747153051805	4530
1485300876119752268	1485300747153051805	4271
1485300876122152268	1485300747153051805	4408
1485300876124452268	1485300747153051805	4459
1485300876126952268	1485300747153051805	4409
1485300876129352268	1485300747153051805	4466
1485300876131852268	1485300747153051805	4504
1485300876134252268	1485300747153051805	4502
1485300876137352268	1485300747153051805	4503
1485300876139752268	1485300747153051805	4449
1485300876142152268	1485300747153051805	4317
1485300876144652268	1485300747153051805	4318
1485300876147152268	1485300747153051805	4320
1485300876149552268	1485300747153051805	4501
1485300876151952268	1485300747153051805	4321
1485300876154352268	1485300747153051805	4465
1485300876156852268	1485300747153051805	4512
1485300876159252268	1485300747153051805	4447
1485300876161852268	1485300747153051805	4448
1485300876164352268	1485300747153051805	4322
1510695193361248466	1484165049340238402	30
1510695193364248466	1484165049340238402	4611
1510695193367148466	1484165049340238402	4406
1510695193370148466	1484165049340238402	4612
1510695193373048466	1484165049340238402	4240
1510695193375948466	1484165049340238402	4404
1510695193380748466	1484165049340238402	4405
1510695193383548466	1484165049340238402	4272
1510695193386448466	1484165049340238402	4613
1510695193390248466	1484165049340238402	4239
1510695193393548466	1484165049340238402	4407
1510695193396848466	1484165049340238402	4530
1510695193399548466	1484165049340238402	4271
1510695193402048466	1484165049340238402	4442
1510695193404748466	1484165049340238402	4445
1510695193407348466	1484165049340238402	1197
1510695193409648466	1484165049340238402	4408
1510695193412148466	1484165049340238402	4459
1510695193414548466	1484165049340238402	4409
1510695193416948466	1484165049340238402	4374
1510695193419248466	1484165049340238402	2582
1507129524181152923	1507062624703638877	4271
1617284525754429374	1534345612202751525	8439
1617284525758129374	1534345612202751525	4442
1617284525760829374	1534345612202751525	8108
1617284525764029374	1534345612202751525	4445
1617284525767429374	1534345612202751525	4446
1617284525769829374	1534345612202751525	4444
1617284525773629374	1534345612202751525	4441
1617284525778529374	1534345612202751525	4427
1617284525780929374	1534345612202751525	22150
1617284525783629374	1534345612202751525	22152
1617284525786229374	1534345612202751525	22151
1617284525788629374	1534345612202751525	22153
1617284525793229374	1534345612202751525	22154
1617284525796029374	1534345612202751525	5569
1617284525798729374	1534345612202751525	5570
1617284525801129374	1534345612202751525	4267
1617284525803729374	1534345612202751525	4317
1617284525806229374	1534345612202751525	7745
\.


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

COPY public.company_role_plans (id, company_role_id, plan_id, sort_order) FROM stdin;
1491427742503827937	1485294339821342570	4611	100
1491427742506827937	1485294339821342570	4406	1
1491427742509527937	1485294339821342570	4612	100
1491427742512627937	1485294339821342570	4613	100
1498575705088093000	1484165089138839084	4442	100
1498575705092693000	1484165089138839084	4300	100
1498575705094893000	1484165089138839084	4449	3
1498575705096893000	1484165089138839084	4465	1
1498575705098893000	1484165089138839084	4447	2
1498575705100993000	1484165089138839084	2582	100
1498575705103893000	1484165089138839084	6411	100
1497369696903716804	1486664221009962191	7	2
1497369696906816804	1486664221009962191	1072	3
1497369696909216804	1486664221009962191	6180	4
1497369696911516804	1486664221009962191	4375	1
1516219896093813796	2	7518	100
1516219896097813796	2	7341	100
1516219896100713796	2	7342	1
1516219896104613796	2	7343	2
1516219896107513796	2	7674	100
1516219896110513796	2	7676	100
1516219896113413796	2	7521	100
1516219896116213796	2	7522	100
1516219896119413796	2	7675	100
1516219896123013796	2	7523	100
1516219896125813796	2	7498	100
1516219896128613796	2	7499	100
1516219896131513796	2	7351	100
1516219896134213796	2	7350	100
1516219896137013796	2	7497	100
1516219896139813796	2	7352	100
1516219896142613796	2	7753	100
1516219896145413796	2	7471	100
1516219896148113796	2	7344	100
1516219896151113796	2	7346	100
1516219896153813796	2	7345	100
1516219896156613796	2	7506	100
1516219896159313796	2	7503	100
1516219896162113796	2	7508	100
1516219896164813796	2	7504	100
1516219896167513796	2	7507	100
1516219896170313796	2	7505	100
1516219896173013796	2	7501	100
1516219896175613796	2	7354	100
1516219896179013796	2	7353	100
1516219896181713796	2	7359	100
1516219896184513796	2	7357	100
1516219896187213796	2	7519	100
1516219896190013796	2	7355	100
1516219896192813796	2	7512	100
1516219896195513796	2	7564	100
1516219896198313796	2	7617	100
1516219896201113796	2	7567	100
1516219896203913796	2	7565	100
1516219896206613796	2	7566	100
1516219896209413796	2	4455	3
1516219896212113796	2	4236	6
1516219896214913796	2	4403	7
1516219896217713796	2	4312	8
1516219896220513796	2	4313	9
1516219896223213796	2	4270	10
1516219896226013796	2	4314	11
1516219896228713796	2	4268	12
1516219896231713796	2	4408	6
1516219896234813796	2	7408	7
1516219896237613796	2	4241	1
1516219896240913796	2	6467	2
1516219896243713796	2	4263	3
1516219896246413796	2	4242	4
1516219896249313796	2	4267	5
1516219896252013796	2	5565	100
1516219896255013796	2	5566	100
\.


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

COPY public.company_roles (id, company_id, name, tx, ct, ny, ga, ca, nj, il, mi, oh, pa, md, ri, ma) FROM stdin;
1	1	admin	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N	\N
1486658215332861137	1	Other	0	0	0	0	\N	\N	\N	\N	\N	\N	\N	\N	\N
1485294339821342570	1	External Admin	0	1	1	0	0	\N	\N	\N	\N	\N	\N	\N	\N
1486664221009962191	1	External CSR - TX	1	0	0	0	0	\N	\N	\N	\N	\N	\N	\N	\N
1494861669560926385	1	Partner	0	0	0	0	0	\N	\N	\N	\N	\N	\N	\N	\N
1484165089138839084	1	External CSR	1	1	1	0	1	1	0	0	0	0	\N	\N	\N
2	1	Internal CSR	1	1	1	1	1	1	1	0	1	1	0	0	1
\.


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

COPY public.companys (id, name, code, upfront_cost, max_users, flowing_cost, clawback_cost, accepted_cost, tpvcomplete_cost, upfront_cost_gas, flowing_cost_gas, accepted_cost_gas, tpvcomplete_cost_gas, clawback_cost_gas, pay_schedule, payment_bank) FROM stdin;
1568324669774128032	Gas South	gassouth	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1569333254865350000	Starion	starion	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1569333274037250397	Public Power	publicpower	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1569333286491548896	Just Energy	just	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1569333306955448193	Quake Energy	quake	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1569333328242748896	Provision Power & Gas	provision	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1569333339413850692	Santanna	santanna	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1569333357016349577	XOOM Energy	xoom	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1570645677412430738	Spark Energy	spark	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1583957015858719000	Georgia Natural Gas	gng	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1593019072796432615	Vivint	vivint	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1571760926249351418	Electricity Maine	provider-me	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1571760896844451013	ENH Power	provider-nh	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1571760884268251013	Provider Power	provider-ma	0.00	5	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1571760981474051418	Verde Energy	verde	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1534345612202751525	DC Solutions	dcs	0.00	100	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	bi-monthly	-25.00
1549486121378639892	wordpress.potentiallyvital.com	wordpress.potentiallyvital.com	0.00	5	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1571761304850451921	Major Energy	major	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1594847616943119050	Five	five	0.00	50	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1	TER	ter	0.00	100000	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	\N	monthly	0.00
1485300747153051805	DEMO	demo	10.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	77.77	\N	monthly	0.00
1507062624703638877	SCANA Energy	scana	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	monthly	0.00
1509051290045952251	360 Home	360-home	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	monthly	0.00
1509051316670452251	Youthful Home	youthful-home	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	monthly	0.00
1494861819339826285	PowerExpress	powerexpress	0.00	50	20.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	monthly	0.00
1509571161474738744	ChangeOfAddressForm	coaf	0.00	10	0.35	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	monthly	0.00
1494353559901932852	ChangeOfAddressForm	dtv	0.00	1	0.35	0.30	0.00	0.00	0.00	0.00	0.00	0.00	0.00	monthly	0.00
1484949957586253110	YASH	yash	0.00	10	35.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	monthly	0.00
1484165049340238402	PSG	prime	0.00	7	40.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	monthly	0.00
1485366834806228017	VSynergize	vsyn	0.00	100	0.00	0.00	0.00	40.00	0.00	0.00	0.00	30.00	0.00	monthly	0.00
1519224957724328364	American Light & Power	american	0.00	0	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	monthly	0.00
1527612459474255748	Bid On Energy	bid-on-energy	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	monthly	0.00
1537983371297320858	BillCutterz	billcutterz	0.00	20	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	monthly	0.00
1539199176030362973	Constellation	consty	0.00	100	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	monthly	0.00
1546977137928489280	Simplify Solar	simplify	0.00	10	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1614713498735087300	RV - Choose	choose	0.00	1	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1614713505876811372	RV - SaveOn	soe	0.00	1	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1614713512902611120	RV - TXER	txer	0.00	1	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1614713519323011381	RV - CTXP	ctxp	0.00	1	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
1619533743302237837	Electricity Match	em	0.00	1	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00		0.00
\.


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

COPY public.cron_logs (id, cron, start_time, end_time, last_updated, run_seconds) FROM stdin;
\.


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

COPY public.dirty_items (item_id) FROM stdin;
\.


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

COPY public.eia_data (id, name, commodity, state, year, month, value, as_of) FROM stdin;
\.


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

COPY public.eia_generators (id, key, state, county, type, capacity, birthday, status, green, updated, year, latitude, longitude) FROM stdin;
\.


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

COPY public.email_dump (id, email, site_id, exported, created, quarterly_sent, daily_sent, myacct_sent, churn_sent, unsubscribe) FROM stdin;
\.


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

COPY public.geo_data (id, zipcode, ziptype, cityname, citytype, countyname, countyfips, statename, stateabbr, statefips, msacode, areacode, timezone, utc, dst, latitude, longitude, population) FROM stdin;
\.


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

COPY public.geo_data_other (id, zipcode, ziptype, cityname, citytype, countyname, countyfips, statename, stateabbr, statefips, msacode, areacode, timezone, utc, dst, latitude, longitude, population) FROM stdin;
\.


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

COPY public.google_analytics (id, view_date, type, impressions, sessions, keyword, page_url, state) FROM stdin;
\.


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

COPY public.historical_order_averages (id, state, commodity, order_date, rep_id, market_id, average_rate, average_term, orders, declined) FROM stdin;
\.


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

COPY public.item_accounting_bookings (id, error_log, period, effective_date, type, vendor, state, amount, ticket_id, item_id, label, journal_entry_id, entity) FROM stdin;
\.


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

COPY public.item_accounting_cost_allowances (id, error_log, period, effective_date, type, vendor, state, amount, ticket_id, item_id, label, journal_entry_id, entity, max_allowance, manual) FROM stdin;
\.


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

COPY public.item_accounting_cost_ppcs (id, error_log, period, effective_date, type, vendor, state, amount, ticket_id, item_id, label, journal_entry_id, entity, impressions, "position", clicks, ctr, cpc) FROM stdin;
\.


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

COPY public.item_accounting_costs (id, error_log, period, effective_date, type, vendor, state, amount, ticket_id, item_id, label, journal_entry_id, entity) FROM stdin;
\.


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

COPY public.item_accounting_revenue_residuals (id, error_log, period, effective_date, type, vendor, state, amount, ticket_id, item_id, label, journal_entry_id, entity) FROM stdin;
\.


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

COPY public.item_accounting_revenue_upfronts (id, error_log, period, effective_date, type, vendor, state, amount, ticket_id, item_id, label, journal_entry_id, entity) FROM stdin;
\.


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

COPY public.item_accounting_revenues (id, error_log, period, effective_date, type, vendor, state, amount, ticket_id, item_id, label, journal_entry_id, entity) FROM stdin;
\.


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

COPY public.item_accountings (id, error_log, period, effective_date, type, vendor, state, amount, ticket_id, item_id, label, journal_entry_id, entity) FROM stdin;
\.


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

COPY public.item_chat_auto_phrases (id, error_log, phrase, chat_id) FROM stdin;
\.


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

COPY public.item_chat_auto_urls (id, error_log, url, chat_id, wait_seconds) FROM stdin;
\.


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

COPY public.item_chat_autos (id, error_log, parent_id, name, message) FROM stdin;
\.


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

COPY public.item_chats (id, error_log, author, seen_agent, seen_user, message, user_id, seen_window, auto_id) FROM stdin;
1623106890277759764		h	n	n	User re-opened chat box	0	n	0
1623106890402661622		h	n	n	User minimized chat box	0	n	0
1623106890488259764		h	n	n	User re-opened chat box	0	n	0
1623106890581761622		h	n	n	User minimized chat box	0	n	0
\.


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

COPY public.item_checkout_cart_mobile_pages (id, error_log, user_mouse_x, user_mouse_y, agent_mouse_x, agent_mouse_y, refresh_user, refresh_agent, user_field, agent_field, max_page, current_page, current_page_label, max_page_label, single_page) FROM stdin;
\.


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

COPY public.item_checkout_cart_mobile_stacked_myaccounts (id, error_log, user_mouse_x, user_mouse_y, agent_mouse_x, agent_mouse_y, refresh_user, refresh_agent, user_field, agent_field, max_page, current_page, current_page_label, max_page_label, single_page) FROM stdin;
\.


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

COPY public.item_checkout_cart_mobile_stackeds (id, error_log, user_mouse_x, user_mouse_y, agent_mouse_x, agent_mouse_y, refresh_user, refresh_agent, user_field, agent_field, max_page, current_page, current_page_label, max_page_label, single_page) FROM stdin;
1623171575616410148		0	0	0	0	 	 			1	1			y
1623169180881874832		0	0	0	0	 	 			1	1			y
1623168961733399495		0	0	0	0	 	 			1	1			y
1623169038014599495		0	0	0	0	 	 			1	1			y
1623103078198459729		0	0	0	0	 	 			1	1			y
1623169087527074832		0	0	0	0	 	 			1	1			y
1623165712116393646		0	0	0	0	 	 			1	1			y
\.


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

COPY public.item_checkout_cart_mobiles (id, error_log, user_mouse_x, user_mouse_y, agent_mouse_x, agent_mouse_y, refresh_user, refresh_agent, user_field, agent_field, max_page, current_page, current_page_label, max_page_label, single_page) FROM stdin;
\.


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

COPY public.item_checkout_cart_single (id, error_log, user_mouse_x, user_mouse_y, agent_mouse_x, agent_mouse_y, refresh_user, refresh_agent, user_field, agent_field) FROM stdin;
\.


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

COPY public.item_checkout_cart_singles (id, error_log, user_mouse_x, user_mouse_y, agent_mouse_x, agent_mouse_y, refresh_user, refresh_agent, user_field, agent_field) FROM stdin;
\.


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

COPY public.item_checkout_cart_split (id, error_log, user_mouse_x, user_mouse_y, agent_mouse_x, agent_mouse_y, refresh_user, refresh_agent, user_field, agent_field) FROM stdin;
\.


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

COPY public.item_checkout_cart_split_credits (id, error_log, user_mouse_x, user_mouse_y, agent_mouse_x, agent_mouse_y, refresh_user, refresh_agent, user_field, agent_field) FROM stdin;
\.


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

COPY public.item_checkout_cart_splits (id, error_log, user_mouse_x, user_mouse_y, agent_mouse_x, agent_mouse_y, refresh_user, refresh_agent, user_field, agent_field) FROM stdin;
\.


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

COPY public.item_checkout_carts (id, error_log, user_mouse_x, user_mouse_y, agent_mouse_x, agent_mouse_y, refresh_user, refresh_agent, user_field, agent_field) FROM stdin;
\.


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

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


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

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


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

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


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

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


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

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


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

COPY public.item_commission_structures (id, error_log, company_id, type, value_dollars, value_percent, commodity, customer_type, term_length, prepaid, state) FROM stdin;
\.


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

COPY public.item_commission_upfronts (id, error_log, rep_id, amount, period, commodity, amount_offset) FROM stdin;
\.


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

COPY public.item_commission_usages (id, error_log, rep_id, amount, period, commodity, amount_offset, start_date, end_date, usage, bill_pk) FROM stdin;
\.


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

COPY public.item_commissions (id, error_log, rep_id, amount, period, commodity, amount_offset) FROM stdin;
\.


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

COPY public.item_cost_clawbacks (id, error_log, amount, period, vendor_id, ticket_id, agent_id, paid, paid_date) FROM stdin;
\.


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

COPY public.item_cost_flowings (id, error_log, amount, period, vendor_id, ticket_id, agent_id, paid, paid_date) FROM stdin;
\.


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

COPY public.item_cost_upfronts (id, error_log, amount, period, vendor_id, ticket_id, agent_id, paid, paid_date) FROM stdin;
\.


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

COPY public.item_costs (id, error_log, amount, period, vendor_id, ticket_id, agent_id, paid, paid_date) FROM stdin;
\.


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

COPY public.item_electricity_lead_dtvs (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id, rooms, dvrs) FROM stdin;
\.


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

COPY public.item_electricity_lead_solars (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

COPY public.item_electricity_leads (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

COPY public.item_electricity_partner_energytexas_brand_energytexas_cas (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

COPY public.item_electricity_partner_energytexas_brand_energytexas_cts (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

COPY public.item_electricity_partner_energytexas_brand_energytexas_gas (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

COPY public.item_electricity_partner_energytexas_brand_energytexas_ils (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

COPY public.item_electricity_partner_energytexas_brand_energytexas_mas (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

COPY public.item_electricity_partner_energytexas_brand_energytexas_mds (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

COPY public.item_electricity_partner_energytexas_brand_energytexas_mis (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

COPY public.item_electricity_partner_energytexas_brand_energytexas_nhs (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

COPY public.item_electricity_partner_energytexas_brand_energytexas_njs (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

COPY public.item_electricity_partner_energytexas_brand_energytexas_nys (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

COPY public.item_electricity_partner_energytexas_brand_energytexas_ohs (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

COPY public.item_electricity_partner_energytexas_brand_energytexas_pas (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

COPY public.item_electricity_partner_energytexas_brand_energytexas_ris (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

COPY public.item_electricity_partner_energytexas_brand_energytexas_txs (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
1623103078193059729		\N	3	move	2021-06-08		1	Terrific 12	11.3000	12	\N		/plan-documents/terrific-12-efl.-cnp.pdf	T12-CNP			24682468	y	n	n	n	n	n	n	0.0000	0.0000	0.000	0.00	0	 	 	 	0		\N	0		{"rep_id":1,"plan_id":1,"plan_name":"Terrific 12","plan_slug":"terrific-12","plan_mills":"0","plan_customer_type":"r","plan_term":"12","commodity":"e","plan_etf":"150","plan_commodity":"Electricity","plan_site_id":"0","plan_mrc":"4.95","plan_other_charges":null,"plan_drc":"0.00","plan_rate":"11.30000","plan_rate_bill":"0","plan_rate_bill_estimate":"0","plan_energy_charge":"0","plan_rate_elec_2000":"10.30000","plan_rate_elec_1000":"11.30000","plan_rate_elec_500":"12.30000","plan_calc_rate_elec_2000":"0","plan_calc_rate_elec_1000":"0","plan_calc_rate_elec_500":"0","plan_rate_gas":"0","plan_rate_gas_therm":"0","plan_rate_gas_ccf":"0","plan_rate_gas_mcf":"0","plan_rate_daily":"0","plan_rate_promo":"0","plan_rate_promo_months":"0","plan_rate_after_promo":"0","plan_rate_summer":"0","plan_rate_winter":"0","plan_partner_plan_id":"T12-CNP","plan_partner_product_id":"","plan_partner_rate_id":"","plan_partner_raw_data":null,"plan_partner_utility_id":null,"plan_partner_utility_name":"","plan_promo_tip":"","plan_promo_img":"","plan_special_terms":"","plan_minutia":"","plan_pricing_code":"","plan_prepaid":"N","plan_min_balance":"0","plan_legal_script":null,"plan_description":"A wonderful 12 month plan","plan_floater_description":"","plan_yrac_url":"","plan_terms_and_conditions":"","plan_toc_url":"\\/plan-documents\\/terrific-12-tos.pdf","plan_efl_url":"\\/plan-documents\\/terrific-12-efl.-cnp.pdf","plan_market_id":3,"market_name":"Centerpoint ","rep_phone":"","rep_phone_alt":"","rep_phone_biz":"","rep_upfront":null,"rep_mills":null,"plan_upfront":"0.00","rep_name":"Energy Texas","rep_logo":"","rep_logo_big":"","rep_slug":"energy-texas","use_cart_tx":"y","upfront":0,"up_front":0,"mills":0,"documents":["<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-efl.-cnp.pdf\\" target=\\"_blank\\">Electricity Facts Label<\\/a>","<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-tos.pdf\\" target=\\"_blank\\">Terms of Service<\\/a>"]}	0.0000	 	e		\N	14			3	n		n		n	1	x	\N	0.00	0.00		\N
1623165754115574833		\N	3	move	2021-06-08		1	Terrific 12	11.3000	12	\N		/plan-documents/terrific-12-efl-cnp.pdf	T12-CNP			24682468	y	n	n	n	n	n	n	0.0000	0.0000	0.000	0.00	0	 	 	 	0		\N	0		{"rep_id":1,"plan_id":1,"plan_name":"Terrific 12","plan_slug":"terrific-12","plan_mills":"0","plan_customer_type":"r","plan_term":"12","commodity":"e","plan_etf":"150","plan_commodity":"Electricity","plan_site_id":"0","plan_mrc":"4.95","plan_other_charges":null,"plan_drc":"0.00","plan_rate":"11.30000","plan_rate_bill":"0","plan_rate_bill_estimate":"0","plan_energy_charge":"0","plan_rate_elec_2000":"10.30000","plan_rate_elec_1000":"11.30000","plan_rate_elec_500":"12.30000","plan_calc_rate_elec_2000":"0","plan_calc_rate_elec_1000":"0","plan_calc_rate_elec_500":"0","plan_rate_gas":"0","plan_rate_gas_therm":"0","plan_rate_gas_ccf":"0","plan_rate_gas_mcf":"0","plan_rate_daily":"0","plan_rate_promo":"0","plan_rate_promo_months":"0","plan_rate_after_promo":"0","plan_rate_summer":"0","plan_rate_winter":"0","plan_partner_plan_id":"T12-CNP","plan_partner_product_id":"","plan_partner_rate_id":"","plan_partner_raw_data":null,"plan_partner_utility_id":null,"plan_partner_utility_name":"","plan_promo_tip":"","plan_promo_img":"","plan_special_terms":"","plan_minutia":"","plan_pricing_code":"","plan_prepaid":"N","plan_min_balance":"0","plan_legal_script":null,"plan_description":"A no-frills, low-cost 12 month fixed rate plan.","plan_floater_description":"","plan_yrac_url":"","plan_terms_and_conditions":"","plan_toc_url":"\\/plan-documents\\/terrific-12-tos.pdf","plan_efl_url":"\\/plan-documents\\/terrific-12-efl-cnp.pdf","plan_market_id":3,"market_name":"Centerpoint ","rep_phone":"","rep_phone_alt":"","rep_phone_biz":"","rep_upfront":null,"rep_mills":null,"plan_upfront":"0.00","rep_name":"Energy Texas","rep_logo":"","rep_logo_big":"","rep_slug":"energy-texas","use_cart_tx":"y","upfront":0,"up_front":0,"mills":0,"documents":["<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-efl-cnp.pdf\\" target=\\"_blank\\">Electricity Facts Label<\\/a>","<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-tos.pdf\\" target=\\"_blank\\">Terms of Service<\\/a>"]}	0.0000	 	e		\N	0			3	n		n		n	1	x	\N	0.00	0.00		\N
1623168961732799495		\N	3	switch	\N		1	Terrific 12	11.3000	12	\N	/plan-documents/yrac.pdf	/plan-documents/terrific-12-efl-cnp.pdf	T12-CNP			24682468	y	n	n	n	n	n	n	0.0000	0.0000	0.000	0.00	0	 	 	 	0		\N	0		{"rep_id":1,"plan_id":1,"plan_name":"Terrific 12","plan_slug":"terrific-12","plan_mills":"0","plan_customer_type":"r","plan_term":"12","commodity":"e","plan_etf":"150","plan_commodity":"Electricity","plan_site_id":"0","plan_mrc":"4.95","plan_other_charges":null,"plan_drc":"0.00","plan_rate":"11.30000","plan_rate_bill":"0","plan_rate_bill_estimate":"0","plan_energy_charge":"0","plan_rate_elec_2000":"10.30000","plan_rate_elec_1000":"11.30000","plan_rate_elec_500":"12.30000","plan_calc_rate_elec_2000":"0","plan_calc_rate_elec_1000":"0","plan_calc_rate_elec_500":"0","plan_rate_gas":"0","plan_rate_gas_therm":"0","plan_rate_gas_ccf":"0","plan_rate_gas_mcf":"0","plan_rate_daily":"0","plan_rate_promo":"0","plan_rate_promo_months":"0","plan_rate_after_promo":"0","plan_rate_summer":"0","plan_rate_winter":"0","plan_partner_plan_id":"T12-CNP","plan_partner_product_id":"","plan_partner_rate_id":"","plan_partner_raw_data":null,"plan_partner_utility_id":null,"plan_partner_utility_name":"","plan_promo_tip":"","plan_promo_img":"","plan_special_terms":"","plan_minutia":"","plan_pricing_code":"","plan_prepaid":"N","plan_min_balance":"0","plan_legal_script":null,"plan_description":"A no-frills, low-cost 12 month fixed rate plan.","plan_floater_description":"","plan_yrac_url":"\\/plan-documents\\/yrac.pdf","plan_terms_and_conditions":"","plan_toc_url":"\\/plan-documents\\/terrific-12-tos.pdf","plan_efl_url":"\\/plan-documents\\/terrific-12-efl-cnp.pdf","plan_market_id":3,"market_name":"Centerpoint ","rep_phone":"","rep_phone_alt":"","rep_phone_biz":"","rep_upfront":null,"rep_mills":null,"plan_upfront":"0.00","rep_name":"Energy Texas","rep_logo":"","rep_logo_big":"","rep_slug":"energy-texas","use_cart_tx":"y","upfront":0,"up_front":0,"mills":0,"documents":["<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-efl-cnp.pdf\\" target=\\"_blank\\">Electricity Facts Label<\\/a>","<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/yrac.pdf\\" target=\\"_blank\\">Your Rights as a Customer<\\/a>","<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-tos.pdf\\" target=\\"_blank\\">Terms of Service<\\/a>"]}	0.0000	 	e		\N	16			3	n		n		n	1	x	\N	0.00	0.00		\N
1623171575615910148		\N	3	move	2021-06-14		1	Terrific 12	11.3000	12	\N	/plan-documents/yrac.pdf	/plan-documents/terrific-12-efl-cnp.pdf	T12-CNP				n	n	n	n	n	n	n	0.0000	0.0000	0.000	0.00	0	 	 	 	0		\N	0		{"rep_id":1,"plan_id":1,"plan_name":"Terrific 12","plan_slug":"terrific-12","plan_mills":"0","plan_customer_type":"r","plan_term":"12","commodity":"e","plan_etf":"150","plan_commodity":"Electricity","plan_site_id":"0","plan_mrc":"4.95","plan_other_charges":null,"plan_drc":"0.00","plan_rate":"11.30000","plan_rate_bill":"0","plan_rate_bill_estimate":"0","plan_energy_charge":"0","plan_rate_elec_2000":"10.30000","plan_rate_elec_1000":"11.30000","plan_rate_elec_500":"12.30000","plan_calc_rate_elec_2000":"0","plan_calc_rate_elec_1000":"0","plan_calc_rate_elec_500":"0","plan_rate_gas":"0","plan_rate_gas_therm":"0","plan_rate_gas_ccf":"0","plan_rate_gas_mcf":"0","plan_rate_daily":"0","plan_rate_promo":"0","plan_rate_promo_months":"0","plan_rate_after_promo":"0","plan_rate_summer":"0","plan_rate_winter":"0","plan_partner_plan_id":"T12-CNP","plan_partner_product_id":"","plan_partner_rate_id":"","plan_partner_raw_data":null,"plan_partner_utility_id":null,"plan_partner_utility_name":"","plan_promo_tip":"","plan_promo_img":"","plan_special_terms":"","plan_minutia":"","plan_pricing_code":"","plan_prepaid":"N","plan_min_balance":"0","plan_legal_script":null,"plan_description":"A no-frills, low-cost 12 month fixed rate plan.","plan_floater_description":"","plan_yrac_url":"\\/plan-documents\\/yrac.pdf","plan_terms_and_conditions":"","plan_toc_url":"\\/plan-documents\\/terrific-12-tos.pdf","plan_efl_url":"\\/plan-documents\\/terrific-12-efl-cnp.pdf","plan_market_id":3,"market_name":"Centerpoint ","rep_phone":"","rep_phone_alt":"","rep_phone_biz":"","rep_upfront":null,"rep_mills":null,"plan_upfront":"0.00","rep_name":"Energy Texas","rep_logo":"","rep_logo_big":"","rep_slug":"energy-texas","use_cart_tx":"y","upfront":0,"up_front":0,"mills":0,"documents":["<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-efl-cnp.pdf\\" target=\\"_blank\\">Electricity Facts Label<\\/a>","<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/yrac.pdf\\" target=\\"_blank\\">Your Rights as a Customer<\\/a>","<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-tos.pdf\\" target=\\"_blank\\">Terms of Service<\\/a>"]}	0.0000	 	e		\N	20			3	n		n		n	1	x	\N	0.00	0.00		\N
1623169038013999495		\N	3	move	2021-06-14		1	Terrific 12	11.3000	12	\N	/plan-documents/yrac.pdf	/plan-documents/terrific-12-efl-cnp.pdf	T12-CNP			24682468	y	n	n	n	n	n	n	0.0000	0.0000	0.000	0.00	0	 	 	 	0		\N	0		{"rep_id":1,"plan_id":1,"plan_name":"Terrific 12","plan_slug":"terrific-12","plan_mills":"0","plan_customer_type":"r","plan_term":"12","commodity":"e","plan_etf":"150","plan_commodity":"Electricity","plan_site_id":"0","plan_mrc":"4.95","plan_other_charges":null,"plan_drc":"0.00","plan_rate":"11.30000","plan_rate_bill":"0","plan_rate_bill_estimate":"0","plan_energy_charge":"0","plan_rate_elec_2000":"10.30000","plan_rate_elec_1000":"11.30000","plan_rate_elec_500":"12.30000","plan_calc_rate_elec_2000":"0","plan_calc_rate_elec_1000":"0","plan_calc_rate_elec_500":"0","plan_rate_gas":"0","plan_rate_gas_therm":"0","plan_rate_gas_ccf":"0","plan_rate_gas_mcf":"0","plan_rate_daily":"0","plan_rate_promo":"0","plan_rate_promo_months":"0","plan_rate_after_promo":"0","plan_rate_summer":"0","plan_rate_winter":"0","plan_partner_plan_id":"T12-CNP","plan_partner_product_id":"","plan_partner_rate_id":"","plan_partner_raw_data":null,"plan_partner_utility_id":null,"plan_partner_utility_name":"","plan_promo_tip":"","plan_promo_img":"","plan_special_terms":"","plan_minutia":"","plan_pricing_code":"","plan_prepaid":"N","plan_min_balance":"0","plan_legal_script":null,"plan_description":"A no-frills, low-cost 12 month fixed rate plan.","plan_floater_description":"","plan_yrac_url":"\\/plan-documents\\/yrac.pdf","plan_terms_and_conditions":"","plan_toc_url":"\\/plan-documents\\/terrific-12-tos.pdf","plan_efl_url":"\\/plan-documents\\/terrific-12-efl-cnp.pdf","plan_market_id":3,"market_name":"Centerpoint ","rep_phone":"","rep_phone_alt":"","rep_phone_biz":"","rep_upfront":null,"rep_mills":null,"plan_upfront":"0.00","rep_name":"Energy Texas","rep_logo":"","rep_logo_big":"","rep_slug":"energy-texas","use_cart_tx":"y","upfront":0,"up_front":0,"mills":0,"documents":["<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-efl-cnp.pdf\\" target=\\"_blank\\">Electricity Facts Label<\\/a>","<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/yrac.pdf\\" target=\\"_blank\\">Your Rights as a Customer<\\/a>","<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-tos.pdf\\" target=\\"_blank\\">Terms of Service<\\/a>"]}	0.0000	 	e		\N	17			3	n		n		n	1	x	\N	0.00	0.00		\N
1623169087526474832		\N	3	switch	2021-06-14		1	Terrific 12	11.3000	12	\N	/plan-documents/yrac.pdf	/plan-documents/terrific-12-efl-cnp.pdf	T12-CNP				n	n	n	n	n	n	n	0.0000	0.0000	0.000	0.00	0	 	 	 	0		\N	0		{"rep_id":1,"plan_id":1,"plan_name":"Terrific 12","plan_slug":"terrific-12","plan_mills":"0","plan_customer_type":"r","plan_term":"12","commodity":"e","plan_etf":"150","plan_commodity":"Electricity","plan_site_id":"0","plan_mrc":"4.95","plan_other_charges":null,"plan_drc":"0.00","plan_rate":"11.30000","plan_rate_bill":"0","plan_rate_bill_estimate":"0","plan_energy_charge":"0","plan_rate_elec_2000":"10.30000","plan_rate_elec_1000":"11.30000","plan_rate_elec_500":"12.30000","plan_calc_rate_elec_2000":"0","plan_calc_rate_elec_1000":"0","plan_calc_rate_elec_500":"0","plan_rate_gas":"0","plan_rate_gas_therm":"0","plan_rate_gas_ccf":"0","plan_rate_gas_mcf":"0","plan_rate_daily":"0","plan_rate_promo":"0","plan_rate_promo_months":"0","plan_rate_after_promo":"0","plan_rate_summer":"0","plan_rate_winter":"0","plan_partner_plan_id":"T12-CNP","plan_partner_product_id":"","plan_partner_rate_id":"","plan_partner_raw_data":null,"plan_partner_utility_id":null,"plan_partner_utility_name":"","plan_promo_tip":"","plan_promo_img":"","plan_special_terms":"","plan_minutia":"","plan_pricing_code":"","plan_prepaid":"N","plan_min_balance":"0","plan_legal_script":null,"plan_description":"A no-frills, low-cost 12 month fixed rate plan.","plan_floater_description":"","plan_yrac_url":"\\/plan-documents\\/yrac.pdf","plan_terms_and_conditions":"","plan_toc_url":"\\/plan-documents\\/terrific-12-tos.pdf","plan_efl_url":"\\/plan-documents\\/terrific-12-efl-cnp.pdf","plan_market_id":3,"market_name":"Centerpoint ","rep_phone":"","rep_phone_alt":"","rep_phone_biz":"","rep_upfront":null,"rep_mills":null,"plan_upfront":"0.00","rep_name":"Energy Texas","rep_logo":"","rep_logo_big":"","rep_slug":"energy-texas","use_cart_tx":"y","upfront":0,"up_front":0,"mills":0,"documents":["<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-efl-cnp.pdf\\" target=\\"_blank\\">Electricity Facts Label<\\/a>","<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/yrac.pdf\\" target=\\"_blank\\">Your Rights as a Customer<\\/a>","<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-tos.pdf\\" target=\\"_blank\\">Terms of Service<\\/a>"]}	0.0000	 	e		\N	18			3	n		n		n	1	x	\N	0.00	0.00		\N
1623169180881274832		\N	3	move	2021-06-14		2	Long Lasting 60	11.2000	60	\N	/plan-documents/yrac.pdf	/plan-documents/long-lasting-60-efl-cnp.pdf	LL60-CNP			24682468	y	n	n	n	n	n	n	0.0000	0.0000	0.000	0.00	0	 	 	 	0		\N	0		{"rep_id":1,"plan_id":2,"plan_name":"Long Lasting 60","plan_slug":"long-lasting-60","plan_mills":"0","plan_customer_type":"r","plan_term":"60","commodity":"e","plan_etf":"600","plan_commodity":"Electricity","plan_site_id":"0","plan_mrc":"1.95","plan_other_charges":null,"plan_drc":"0.00","plan_rate":"11.20000","plan_rate_bill":"0","plan_rate_bill_estimate":"0","plan_energy_charge":"0","plan_rate_elec_2000":"11.10000","plan_rate_elec_1000":"11.20000","plan_rate_elec_500":"11.30000","plan_calc_rate_elec_2000":"0","plan_calc_rate_elec_1000":"0","plan_calc_rate_elec_500":"0","plan_rate_gas":"0","plan_rate_gas_therm":"0","plan_rate_gas_ccf":"0","plan_rate_gas_mcf":"0","plan_rate_daily":"0","plan_rate_promo":"0","plan_rate_promo_months":"0","plan_rate_after_promo":"0","plan_rate_summer":"0","plan_rate_winter":"0","plan_partner_plan_id":"LL60-CNP","plan_partner_product_id":"","plan_partner_rate_id":"","plan_partner_raw_data":null,"plan_partner_utility_id":null,"plan_partner_utility_name":"","plan_promo_tip":"","plan_promo_img":"","plan_special_terms":"","plan_minutia":"","plan_pricing_code":"","plan_prepaid":"N","plan_min_balance":"0","plan_legal_script":null,"plan_description":"The future can be scary. Settle in for this 5-year no-surprises fixed rate plan.","plan_floater_description":"","plan_yrac_url":"\\/plan-documents\\/yrac.pdf","plan_terms_and_conditions":"","plan_toc_url":"\\/plan-documents\\/long-lasting-60-tos.pdf","plan_efl_url":"\\/plan-documents\\/long-lasting-60-efl-cnp.pdf","plan_market_id":8,"market_name":"Centerpoint ","rep_phone":"","rep_phone_alt":"","rep_phone_biz":"","rep_upfront":null,"rep_mills":null,"plan_upfront":"0.00","rep_name":"Energy Texas","rep_logo":"","rep_logo_big":"","rep_slug":"energy-texas","use_cart_tx":"y","upfront":0,"up_front":0,"mills":0,"documents":["<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/long-lasting-60-efl-cnp.pdf\\" target=\\"_blank\\">Electricity Facts Label<\\/a>","<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/yrac.pdf\\" target=\\"_blank\\">Your Rights as a Customer<\\/a>","<a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/long-lasting-60-tos.pdf\\" target=\\"_blank\\">Terms of Service<\\/a>"]}	0.0000	 	e		\N	19			8	n		n		n	1	x	\N	0.00	0.00		\N
\.


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

COPY public.item_electricity_partner_energytexas_brand_energytexass (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

COPY public.item_electricity_partner_energytexass (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

COPY public.item_electricitys (id, error_log, state, market_id, move_switch, move_switch_date, move_switch_expedite, plan_id, plan_name, plan_rate, plan_term, plan_etf, plan_yrac_url, plan_efl_url, plan_partner_plan_id, plan_partner_product_id, partner_order_status, partner_order_id, flag_accepted, flag_deposit_due, flag_balance_due, flag_payment_due, flag_fraud_potential, flag_service_down, flag_cancelled, deposit_amt, payment_amt, mills, up_front, hold_order, critical_care, flag_prepared_cart, flag_tpv_cart, rate_shown, promo_code, amount_paid, annual_usage, plan_partner_rate_id, original_click_data, balance_amt, flag_order_valid, commodity, e_sig, e_sig_date, plan_click_id, partner_account_id, plan_price_structure, plan_market_id, flag_switchhold, own_rent, flag_existing_customer, docusign_url, flag_apartment, rep_id, flag_other_plans, other_plan_ids, plan_rate_bill, plan_rate_bill_estimate, covid, five_plan_id) FROM stdin;
\.


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

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


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

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


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

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


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

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


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

COPY public.item_email_confirmations (id, error_log, fingerprint, send_with_us_key, cmd, opened, clicked, dropped, last_updated) FROM stdin;
1623107249827260879		1623103078188059729~confirmation	log_8917dfdc45f166d5df5254a60954b229-3	curl \\\n  -X POST \\\n  -u live_6bef044e1cd97bfefa967e5ff72b13a5f7e9dc10: \\\n  -d '{\n    "template": "tem_RKjxcPSqb9fpHQVV4FRDxb6W",\n    "recipient": {\n      "address": "developer@texaselectricityratings.com"\n    },\n    "sender": {\n      "address": "customersupport@texaselectricityratings.com",\n      "reply_to": "customersupport@texaselectricityratings.com",\n      "name": "DEV Texas Electricity Ratings"\n    },\n    "template_data": {\n      "ticket_id": "1623103078188059729",\n      "base64_email": "ZGV2ZWxvcGVyQHRleGFzZWxlY3RyaWNpdHlyYXRpbmdzLmNvbQ==",\n      "ter_order_id": "1341947",\n      "ter_username": "",\n      "cart_summary": "CART SUMMARY STUB",\n      "provider_order_id": "24682468",\n      "first_name": "Test",\n      "last_name": "Test",\n      "provider_name": "Energy Texas",\n      "provider_customer_service": "",\n      "plan_name": "Terrific 12",\n      "plan_rate": "11.30000",\n      "plan_term": "12",\n      "plan_start": "6/8/2021",\n      "partner_name": "Energy Texas",\n      "service_addr1": "19102 CHALLE CIRCLE EAST",\n      "service_addr2": "",\n      "service_city": "SPRING",\n      "service_state": "TX",\n      "service_zip": "77373",\n      "tos": "/plan-documents/terrific-12-tos.pdf",\n      "efl": "Your Documents:<br><a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-efl.-cnp.pdf\\" target=\\"_blank\\">Electricity Facts Label<\\/a><br><a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-tos.pdf\\" target=\\"_blank\\">Terms of Service<\\/a>",\n      "contact": "<b>This email is for your records only. Energy Texas will confirm your enrollment details via email.</b>",\n      "site_logo": "https://www.texaselectricityratings.com/images/logos/tx-logo.png",\n      "site_url": "TexasElectricityRatings.com",\n      "site_url_lc": "texaselectricityratings.com",\n      "site_name": "DEV Texas Electricity Ratings",\n      "site_phone": "(866) 303-9147",\n      "site_short_name": "TER",\n      "commodity": "Electricity",\n      "plan_rate_desc": "&cent;/kWh",\n      "button_text": "Click"\n    }\n  }' \\\nhttps://api.sendwithus.com/api/v1/send\n	n	n	 	0
1623165771827574833		1623165712102293646~confirmation	log_a21576e1e6f3fe5d03a83ca4c22c3c54-3	curl \\\n  -X POST \\\n  -u live_6bef044e1cd97bfefa967e5ff72b13a5f7e9dc10: \\\n  -d '{\n    "template": "tem_RKjxcPSqb9fpHQVV4FRDxb6W",\n    "recipient": {\n      "address": "developer@texaselectricityratings.com"\n    },\n    "sender": {\n      "address": "customersupport@texaselectricityratings.com",\n      "reply_to": "customersupport@texaselectricityratings.com",\n      "name": "DEV Texas Electricity Ratings"\n    },\n    "template_data": {\n      "ticket_id": "1623165712102293646",\n      "base64_email": "ZGV2ZWxvcGVyQHRleGFzZWxlY3RyaWNpdHlyYXRpbmdzLmNvbQ==",\n      "ter_order_id": "1341948",\n      "ter_username": "",\n      "cart_summary": "CART SUMMARY STUB",\n      "provider_order_id": "24682468",\n      "first_name": "Test",\n      "last_name": "Test",\n      "provider_name": "Energy Texas",\n      "provider_customer_service": "",\n      "plan_name": "Terrific 12",\n      "plan_rate": "11.30000",\n      "plan_term": "12",\n      "plan_start": "6/8/2021",\n      "partner_name": "Energy Texas",\n      "service_addr1": "19102 CHALLE CIRCLE EAST",\n      "service_addr2": "",\n      "service_city": "SPRING",\n      "service_state": "TX",\n      "service_zip": "77373",\n      "tos": "/plan-documents/terrific-12-tos.pdf",\n      "efl": "Your Documents:<br><a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-efl-cnp.pdf\\" target=\\"_blank\\">Electricity Facts Label<\\/a><br><a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-tos.pdf\\" target=\\"_blank\\">Terms of Service<\\/a>",\n      "contact": "<b>This email is for your records only. Energy Texas will confirm your enrollment details via email.</b>",\n      "site_logo": "https://www.texaselectricityratings.com/images/logos/tx-logo.png",\n      "site_url": "TexasElectricityRatings.com",\n      "site_url_lc": "texaselectricityratings.com",\n      "site_name": "DEV Texas Electricity Ratings",\n      "site_phone": "(866) 303-9147",\n      "site_short_name": "TER",\n      "commodity": "Electricity",\n      "plan_rate_desc": "&cent;/kWh",\n      "button_text": "Click"\n    }\n  }' \\\nhttps://api.sendwithus.com/api/v1/send\n	n	n	 	0
1623168995140074832		1623168961726399495~confirmation	log_430c3afb38a3da87a9032089adac8119-3	curl \\\n  -X POST \\\n  -u live_6bef044e1cd97bfefa967e5ff72b13a5f7e9dc10: \\\n  -d '{\n    "template": "tem_RKjxcPSqb9fpHQVV4FRDxb6W",\n    "recipient": {\n      "address": "developer@texaselectricityratings.com"\n    },\n    "sender": {\n      "address": "customersupport@texaselectricityratings.com",\n      "reply_to": "customersupport@texaselectricityratings.com",\n      "name": "DEV Texas Electricity Ratings"\n    },\n    "template_data": {\n      "ticket_id": "1623168961726399495",\n      "base64_email": "ZGV2ZWxvcGVyQHRleGFzZWxlY3RyaWNpdHlyYXRpbmdzLmNvbQ==",\n      "ter_order_id": "1341949",\n      "ter_username": "",\n      "cart_summary": "CART SUMMARY STUB",\n      "provider_order_id": "24682468",\n      "first_name": "Test",\n      "last_name": "Test",\n      "provider_name": "Energy Texas",\n      "provider_customer_service": "",\n      "plan_name": "Terrific 12",\n      "plan_rate": "11.30000",\n      "plan_term": "12",\n      "plan_start": "6/8/2021",\n      "partner_name": "Energy Texas",\n      "service_addr1": "19102 CHALLE CIRCLE EAST",\n      "service_addr2": "",\n      "service_city": "SPRING",\n      "service_state": "TX",\n      "service_zip": "77373",\n      "tos": "/plan-documents/terrific-12-tos.pdf",\n      "efl": "Your Documents:<br><a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-efl-cnp.pdf\\" target=\\"_blank\\">Electricity Facts Label<\\/a><br><a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/yrac.pdf\\" target=\\"_blank\\">Your Rights as a Customer<\\/a><br><a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-tos.pdf\\" target=\\"_blank\\">Terms of Service<\\/a>",\n      "contact": "<b>This email is for your records only. Energy Texas will confirm your enrollment details via email.</b>",\n      "site_logo": "https://www.texaselectricityratings.com/images/logos/tx-logo.png",\n      "site_url": "TexasElectricityRatings.com",\n      "site_url_lc": "texaselectricityratings.com",\n      "site_name": "DEV Texas Electricity Ratings",\n      "site_phone": "(866) 303-9147",\n      "site_short_name": "TER",\n      "commodity": "Electricity",\n      "plan_rate_desc": "&cent;/kWh",\n      "button_text": "Click"\n    }\n  }' \\\nhttps://api.sendwithus.com/api/v1/send\n	n	n	 	0
1623169042393096400		1623169038009999495~confirmation	log_f6fdb6bbcf976c924314464b6bb96599-3	curl \\\n  -X POST \\\n  -u live_6bef044e1cd97bfefa967e5ff72b13a5f7e9dc10: \\\n  -d '{\n    "template": "tem_RKjxcPSqb9fpHQVV4FRDxb6W",\n    "recipient": {\n      "address": "developer@texaselectricityratings.com"\n    },\n    "sender": {\n      "address": "customersupport@texaselectricityratings.com",\n      "reply_to": "customersupport@texaselectricityratings.com",\n      "name": "DEV Texas Electricity Ratings"\n    },\n    "template_data": {\n      "ticket_id": "1623169038009999495",\n      "base64_email": "ZGV2ZWxvcGVyQHRleGFzZWxlY3RyaWNpdHlyYXRpbmdzLmNvbQ==",\n      "ter_order_id": "1341950",\n      "ter_username": "",\n      "cart_summary": "CART SUMMARY STUB",\n      "provider_order_id": "24682468",\n      "first_name": "Test",\n      "last_name": "Test",\n      "provider_name": "Energy Texas",\n      "provider_customer_service": "",\n      "plan_name": "Terrific 12",\n      "plan_rate": "11.30000",\n      "plan_term": "12",\n      "plan_start": "6/14/2021",\n      "partner_name": "Energy Texas",\n      "service_addr1": "19102 CHALLE CIRCLE EAST",\n      "service_addr2": "",\n      "service_city": "SPRING",\n      "service_state": "TX",\n      "service_zip": "77373",\n      "tos": "/plan-documents/terrific-12-tos.pdf",\n      "efl": "Your Documents:<br><a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-efl-cnp.pdf\\" target=\\"_blank\\">Electricity Facts Label<\\/a><br><a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/yrac.pdf\\" target=\\"_blank\\">Your Rights as a Customer<\\/a><br><a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/terrific-12-tos.pdf\\" target=\\"_blank\\">Terms of Service<\\/a>",\n      "contact": "<b>This email is for your records only. Energy Texas will confirm your enrollment details via email.</b>",\n      "site_logo": "https://www.texaselectricityratings.com/images/logos/tx-logo.png",\n      "site_url": "TexasElectricityRatings.com",\n      "site_url_lc": "texaselectricityratings.com",\n      "site_name": "DEV Texas Electricity Ratings",\n      "site_phone": "(866) 303-9147",\n      "site_short_name": "TER",\n      "commodity": "Electricity",\n      "plan_rate_desc": "&cent;/kWh",\n      "button_text": "Click"\n    }\n  }' \\\nhttps://api.sendwithus.com/api/v1/send\n	n	n	 	0
1623169196210810028		1623169180875574832~confirmation	log_7ba4e86d892a2a698e174c04ee480a42-3	curl \\\n  -X POST \\\n  -u live_6bef044e1cd97bfefa967e5ff72b13a5f7e9dc10: \\\n  -d '{\n    "template": "tem_RKjxcPSqb9fpHQVV4FRDxb6W",\n    "recipient": {\n      "address": "developer@texaselectricityratings.com"\n    },\n    "sender": {\n      "address": "customersupport@texaselectricityratings.com",\n      "reply_to": "customersupport@texaselectricityratings.com",\n      "name": "DEV Texas Electricity Ratings"\n    },\n    "template_data": {\n      "ticket_id": "1623169180875574832",\n      "base64_email": "ZGV2ZWxvcGVyQHRleGFzZWxlY3RyaWNpdHlyYXRpbmdzLmNvbQ==",\n      "ter_order_id": "1341952",\n      "ter_username": "",\n      "cart_summary": "CART SUMMARY STUB",\n      "provider_order_id": "24682468",\n      "first_name": "Test",\n      "last_name": "Test",\n      "provider_name": "Energy Texas",\n      "provider_customer_service": "",\n      "plan_name": "Long Lasting 60",\n      "plan_rate": "11.20000",\n      "plan_term": "60",\n      "plan_start": "6/14/2021",\n      "partner_name": "Energy Texas",\n      "service_addr1": "19102 CHALLE CIRCLE EAST",\n      "service_addr2": "",\n      "service_city": "SPRING",\n      "service_state": "TX",\n      "service_zip": "77373",\n      "tos": "/plan-documents/long-lasting-60-tos.pdf",\n      "efl": "Your Documents:<br><a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/long-lasting-60-efl-cnp.pdf\\" target=\\"_blank\\">Electricity Facts Label<\\/a><br><a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/yrac.pdf\\" target=\\"_blank\\">Your Rights as a Customer<\\/a><br><a class=\\"alt\\" rel=\\"nofollow\\" href=\\"\\/plan-documents\\/long-lasting-60-tos.pdf\\" target=\\"_blank\\">Terms of Service<\\/a>",\n      "contact": "<b>This email is for your records only. Energy Texas will confirm your enrollment details via email.</b>",\n      "site_logo": "https://www.texaselectricityratings.com/images/logos/tx-logo.png",\n      "site_url": "TexasElectricityRatings.com",\n      "site_url_lc": "texaselectricityratings.com",\n      "site_name": "DEV Texas Electricity Ratings",\n      "site_phone": "(866) 303-9147",\n      "site_short_name": "TER",\n      "commodity": "Electricity",\n      "plan_rate_desc": "&cent;/kWh",\n      "button_text": "Click"\n    }\n  }' \\\nhttps://api.sendwithus.com/api/v1/send\n	n	n	 	0
\.


--
