--
--


SET transaction_timeout = 0;
SELECT pg_catalog.set_config('search_path', '', false);

--
-- Name: public; Type: SCHEMA; Schema: -; Owner: dexterton
--

-- *not* creating schema, since initdb creates it


ALTER SCHEMA public OWNER TO dexterton;

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

COMMENT ON SCHEMA public IS '';




--
-- Name: account_emailaddress; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.account_emailaddress (
    id integer NOT NULL,
    email character varying(254) NOT NULL,
    verified boolean NOT NULL,
    "primary" boolean NOT NULL,
    user_id uuid NOT NULL
);


ALTER TABLE public.account_emailaddress OWNER TO dexterton;

--
-- Name: account_emailaddress_id_seq; Type: SEQUENCE; Schema: public; Owner: dexterton
--

ALTER TABLE public.account_emailaddress ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.account_emailaddress_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: account_emailconfirmation; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.account_emailconfirmation (
    id integer NOT NULL,
    created timestamp with time zone NOT NULL,
    sent timestamp with time zone,
    key character varying(64) NOT NULL,
    email_address_id integer NOT NULL
);


ALTER TABLE public.account_emailconfirmation OWNER TO dexterton;

--
-- Name: account_emailconfirmation_id_seq; Type: SEQUENCE; Schema: public; Owner: dexterton
--

ALTER TABLE public.account_emailconfirmation ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.account_emailconfirmation_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: activity_logs_activitylogs; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.activity_logs_activitylogs (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    action character varying(525) NOT NULL,
    user_id uuid
);


ALTER TABLE public.activity_logs_activitylogs OWNER TO dexterton;

--
-- Name: appointment_appointments; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.appointment_appointments (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    first_name character varying(255) NOT NULL,
    last_name character varying(255) NOT NULL,
    email character varying(254) NOT NULL,
    contact_number character varying(500) NOT NULL,
    company_name character varying(500),
    branch character varying(255) NOT NULL,
    scheduled_date_time timestamp with time zone NOT NULL,
    remarks text
);


ALTER TABLE public.appointment_appointments OWNER TO dexterton;

--
-- Name: archives_archives; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.archives_archives (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    model character varying(255) NOT NULL,
    model_object_id character varying(525) NOT NULL
);


ALTER TABLE public.archives_archives OWNER TO dexterton;

--
-- Name: auth_group; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.auth_group (
    id integer NOT NULL,
    name character varying(150) NOT NULL
);


ALTER TABLE public.auth_group OWNER TO dexterton;

--
-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: dexterton
--

ALTER TABLE public.auth_group ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_group_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.auth_group_permissions (
    id integer NOT NULL,
    group_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_group_permissions OWNER TO dexterton;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: dexterton
--

ALTER TABLE public.auth_group_permissions ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_group_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: auth_permission; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.auth_permission (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    content_type_id integer NOT NULL,
    codename character varying(100) NOT NULL
);


ALTER TABLE public.auth_permission OWNER TO dexterton;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: dexterton
--

ALTER TABLE public.auth_permission ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.auth_permission_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: authtoken_token; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.authtoken_token (
    key character varying(40) NOT NULL,
    created timestamp with time zone NOT NULL,
    user_id uuid NOT NULL
);


ALTER TABLE public.authtoken_token OWNER TO dexterton;

--
-- Name: blogs_blogs; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.blogs_blogs (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    image_banner text NOT NULL,
    title character varying(525) NOT NULL,
    body text NOT NULL,
    date_created timestamp with time zone NOT NULL
);


ALTER TABLE public.blogs_blogs OWNER TO dexterton;

--
-- Name: contact_us_contactus; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.contact_us_contactus (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    first_name character varying(255) NOT NULL,
    last_name character varying(255) NOT NULL,
    email character varying(254) NOT NULL,
    contact_number character varying(500) NOT NULL,
    inquiry text NOT NULL,
    status character varying(255) NOT NULL
);


ALTER TABLE public.contact_us_contactus OWNER TO dexterton;

--
-- Name: django_admin_log; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.django_admin_log (
    id integer NOT NULL,
    action_time timestamp with time zone NOT NULL,
    object_id text,
    object_repr character varying(200) NOT NULL,
    action_flag smallint NOT NULL,
    change_message text NOT NULL,
    content_type_id integer,
    user_id uuid NOT NULL,
    CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
);


ALTER TABLE public.django_admin_log OWNER TO dexterton;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: dexterton
--

ALTER TABLE public.django_admin_log ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_admin_log_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_celery_beat_clockedschedule; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.django_celery_beat_clockedschedule (
    id integer NOT NULL,
    clocked_time timestamp with time zone NOT NULL
);


ALTER TABLE public.django_celery_beat_clockedschedule OWNER TO dexterton;

--
-- Name: django_celery_beat_clockedschedule_id_seq; Type: SEQUENCE; Schema: public; Owner: dexterton
--

ALTER TABLE public.django_celery_beat_clockedschedule ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_celery_beat_clockedschedule_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_celery_beat_crontabschedule; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.django_celery_beat_crontabschedule (
    id integer NOT NULL,
    minute character varying(240) NOT NULL,
    hour character varying(96) NOT NULL,
    day_of_week character varying(64) NOT NULL,
    day_of_month character varying(124) NOT NULL,
    month_of_year character varying(64) NOT NULL,
    timezone character varying(63) NOT NULL
);


ALTER TABLE public.django_celery_beat_crontabschedule OWNER TO dexterton;

--
-- Name: django_celery_beat_crontabschedule_id_seq; Type: SEQUENCE; Schema: public; Owner: dexterton
--

ALTER TABLE public.django_celery_beat_crontabschedule ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_celery_beat_crontabschedule_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_celery_beat_intervalschedule; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.django_celery_beat_intervalschedule (
    id integer NOT NULL,
    every integer NOT NULL,
    period character varying(24) NOT NULL
);


ALTER TABLE public.django_celery_beat_intervalschedule OWNER TO dexterton;

--
-- Name: django_celery_beat_intervalschedule_id_seq; Type: SEQUENCE; Schema: public; Owner: dexterton
--

ALTER TABLE public.django_celery_beat_intervalschedule ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_celery_beat_intervalschedule_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_celery_beat_periodictask; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.django_celery_beat_periodictask (
    id integer NOT NULL,
    name character varying(200) NOT NULL,
    task character varying(200) NOT NULL,
    args text NOT NULL,
    kwargs text NOT NULL,
    queue character varying(200),
    exchange character varying(200),
    routing_key character varying(200),
    expires timestamp with time zone,
    enabled boolean NOT NULL,
    last_run_at timestamp with time zone,
    total_run_count integer NOT NULL,
    date_changed timestamp with time zone NOT NULL,
    description text NOT NULL,
    crontab_id integer,
    interval_id integer,
    solar_id integer,
    one_off boolean NOT NULL,
    start_time timestamp with time zone,
    priority integer,
    headers text NOT NULL,
    clocked_id integer,
    expire_seconds integer,
    CONSTRAINT django_celery_beat_periodictask_expire_seconds_check CHECK ((expire_seconds >= 0)),
    CONSTRAINT django_celery_beat_periodictask_priority_check CHECK ((priority >= 0)),
    CONSTRAINT django_celery_beat_periodictask_total_run_count_check CHECK ((total_run_count >= 0))
);


ALTER TABLE public.django_celery_beat_periodictask OWNER TO dexterton;

--
-- Name: django_celery_beat_periodictask_id_seq; Type: SEQUENCE; Schema: public; Owner: dexterton
--

ALTER TABLE public.django_celery_beat_periodictask ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_celery_beat_periodictask_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_celery_beat_periodictasks; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.django_celery_beat_periodictasks (
    ident smallint NOT NULL,
    last_update timestamp with time zone NOT NULL
);


ALTER TABLE public.django_celery_beat_periodictasks OWNER TO dexterton;

--
-- Name: django_celery_beat_solarschedule; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.django_celery_beat_solarschedule (
    id integer NOT NULL,
    event character varying(24) NOT NULL,
    latitude numeric(9,6) NOT NULL,
    longitude numeric(9,6) NOT NULL
);


ALTER TABLE public.django_celery_beat_solarschedule OWNER TO dexterton;

--
-- Name: django_celery_beat_solarschedule_id_seq; Type: SEQUENCE; Schema: public; Owner: dexterton
--

ALTER TABLE public.django_celery_beat_solarschedule ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_celery_beat_solarschedule_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_content_type; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.django_content_type (
    id integer NOT NULL,
    app_label character varying(100) NOT NULL,
    model character varying(100) NOT NULL
);


ALTER TABLE public.django_content_type OWNER TO dexterton;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: dexterton
--

ALTER TABLE public.django_content_type ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_content_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_migrations; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.django_migrations (
    id integer NOT NULL,
    app character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    applied timestamp with time zone NOT NULL
);


ALTER TABLE public.django_migrations OWNER TO dexterton;

--
-- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: dexterton
--

ALTER TABLE public.django_migrations ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.django_migrations_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: django_session; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.django_session (
    session_key character varying(40) NOT NULL,
    session_data text NOT NULL,
    expire_date timestamp with time zone NOT NULL
);


ALTER TABLE public.django_session OWNER TO dexterton;

--
-- Name: inquiry_inquiries; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.inquiry_inquiries (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    first_name character varying(255),
    last_name character varying(255),
    email character varying(254) NOT NULL,
    contact_number character varying(500) NOT NULL,
    inquiry text NOT NULL,
    status character varying(255) NOT NULL,
    product_id uuid
);


ALTER TABLE public.inquiry_inquiries OWNER TO dexterton;

--
-- Name: integration_appclients; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.integration_appclients (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    application_name character varying(255) NOT NULL,
    application_type character varying(255) NOT NULL,
    contact_email character varying(254) NOT NULL,
    contact_person_name character varying(255) NOT NULL,
    purpose text NOT NULL,
    client_id character varying(525),
    client_secret character varying(525),
    approval_status character varying(20) NOT NULL
);


ALTER TABLE public.integration_appclients OWNER TO dexterton;

--
-- Name: integration_integrationtokens; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.integration_integrationtokens (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    access_token character varying(525) NOT NULL,
    refresh_token character varying(525) NOT NULL,
    access_token_expires_at timestamp with time zone,
    refresh_token_expires_at timestamp with time zone,
    client_id uuid,
    updated_at timestamp with time zone NOT NULL
);


ALTER TABLE public.integration_integrationtokens OWNER TO dexterton;

--
-- Name: newsletter_newsletterreceipents; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.newsletter_newsletterreceipents (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    email character varying(254) NOT NULL
);


ALTER TABLE public.newsletter_newsletterreceipents OWNER TO dexterton;

--
-- Name: products_catalogs; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.products_catalogs (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    title character varying(500) NOT NULL,
    image_path text NOT NULL,
    link text NOT NULL
);


ALTER TABLE public.products_catalogs OWNER TO dexterton;

--
-- Name: products_categories; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.products_categories (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    main_category_name character varying(500)[] NOT NULL,
    sub_category_name character varying(255) NOT NULL,
    link text,
    is_active boolean NOT NULL,
    multiple_orderings jsonb,
    meta_description text,
    meta_keywords character varying
);


ALTER TABLE public.products_categories OWNER TO dexterton;

--
-- Name: products_featuredproducts; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.products_featuredproducts (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    model_object_id uuid NOT NULL,
    model_id integer NOT NULL,
    product_id uuid NOT NULL
);


ALTER TABLE public.products_featuredproducts OWNER TO dexterton;

--
-- Name: products_newsandpressreleases; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.products_newsandpressreleases (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    title character varying(255) NOT NULL,
    short_description text,
    long_description text,
    image_path text,
    link text,
    type character varying(255) NOT NULL
);


ALTER TABLE public.products_newsandpressreleases OWNER TO dexterton;

--
-- Name: products_newsgallery; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.products_newsgallery (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    image_path text NOT NULL,
    news_id uuid NOT NULL
);


ALTER TABLE public.products_newsgallery OWNER TO dexterton;

--
-- Name: products_productgallery; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.products_productgallery (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    image_path text NOT NULL,
    is_shown boolean NOT NULL,
    product_id uuid NOT NULL
);


ALTER TABLE public.products_productgallery OWNER TO dexterton;

--
-- Name: products_products; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.products_products (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    name character varying(255) NOT NULL,
    image_path text,
    edp_number character varying(255) NOT NULL,
    article_number character varying(255),
    description text,
    finish character varying(255),
    size character varying(255),
    price double precision NOT NULL,
    is_active boolean NOT NULL,
    sold_as_set boolean NOT NULL,
    is_discounted boolean NOT NULL,
    discount_rate integer NOT NULL,
    discount_valid_until timestamp with time zone,
    quantity bigint NOT NULL,
    arrival_date timestamp with time zone,
    is_best_seller boolean NOT NULL,
    category_id uuid NOT NULL,
    series_id uuid,
    is_coming_soon boolean NOT NULL,
    CONSTRAINT products_products_discount_rate_check CHECK ((discount_rate >= 0)),
    CONSTRAINT products_products_quantity_check CHECK ((quantity >= 0))
);


ALTER TABLE public.products_products OWNER TO dexterton;

--
-- Name: products_series; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.products_series (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    name character varying(255) NOT NULL,
    is_active boolean NOT NULL
);


ALTER TABLE public.products_series OWNER TO dexterton;

--
-- Name: products_settings; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.products_settings (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    name character varying(255) NOT NULL,
    type character varying(255) NOT NULL,
    options character varying(500)[],
    value character varying(500)
);


ALTER TABLE public.products_settings OWNER TO dexterton;

--
-- Name: projects_productfocus; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.projects_productfocus (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    product_image_path text NOT NULL,
    collection character varying(255) NOT NULL,
    product_name character varying(255) NOT NULL,
    product_description character varying(1000) NOT NULL,
    project_id uuid NOT NULL
);


ALTER TABLE public.projects_productfocus OWNER TO dexterton;

--
-- Name: projects_projects; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.projects_projects (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    title character varying(525) NOT NULL,
    images text[] NOT NULL,
    description text NOT NULL,
    article_copy text NOT NULL,
    video_type character varying(255) NOT NULL,
    video_link text NOT NULL,
    video_description text NOT NULL,
    video_title character varying(255) NOT NULL,
    date_created timestamp with time zone,
    thumbnail character varying NOT NULL
);


ALTER TABLE public.projects_projects OWNER TO dexterton;

--
-- Name: reports_reports; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.reports_reports (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    title character varying(525) NOT NULL,
    description text NOT NULL,
    type character varying NOT NULL
);


ALTER TABLE public.reports_reports OWNER TO dexterton;

--
-- Name: socialaccount_socialaccount; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.socialaccount_socialaccount (
    id integer NOT NULL,
    provider character varying(30) NOT NULL,
    uid character varying(191) NOT NULL,
    last_login timestamp with time zone NOT NULL,
    date_joined timestamp with time zone NOT NULL,
    extra_data text NOT NULL,
    user_id uuid NOT NULL
);


ALTER TABLE public.socialaccount_socialaccount OWNER TO dexterton;

--
-- Name: socialaccount_socialaccount_id_seq; Type: SEQUENCE; Schema: public; Owner: dexterton
--

ALTER TABLE public.socialaccount_socialaccount ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.socialaccount_socialaccount_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: socialaccount_socialapp; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.socialaccount_socialapp (
    id integer NOT NULL,
    provider character varying(30) NOT NULL,
    name character varying(40) NOT NULL,
    client_id character varying(191) NOT NULL,
    secret character varying(191) NOT NULL,
    key character varying(191) NOT NULL
);


ALTER TABLE public.socialaccount_socialapp OWNER TO dexterton;

--
-- Name: socialaccount_socialapp_id_seq; Type: SEQUENCE; Schema: public; Owner: dexterton
--

ALTER TABLE public.socialaccount_socialapp ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.socialaccount_socialapp_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: socialaccount_socialtoken; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.socialaccount_socialtoken (
    id integer NOT NULL,
    token text NOT NULL,
    token_secret text NOT NULL,
    expires_at timestamp with time zone,
    account_id integer NOT NULL,
    app_id integer NOT NULL
);


ALTER TABLE public.socialaccount_socialtoken OWNER TO dexterton;

--
-- Name: socialaccount_socialtoken_id_seq; Type: SEQUENCE; Schema: public; Owner: dexterton
--

ALTER TABLE public.socialaccount_socialtoken ALTER COLUMN id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.socialaccount_socialtoken_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: users_userinvitation; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.users_userinvitation (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    invitor_email character varying(525) NOT NULL,
    invitation_link text NOT NULL,
    expires_at timestamp with time zone,
    invitee_id uuid NOT NULL
);


ALTER TABLE public.users_userinvitation OWNER TO dexterton;

--
-- Name: users_users; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.users_users (
    is_superuser boolean NOT NULL,
    is_staff boolean NOT NULL,
    is_active boolean NOT NULL,
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    first_name character varying(255) NOT NULL,
    last_name character varying(255) NOT NULL,
    email character varying(254) NOT NULL,
    mobile_number character varying(255),
    company character varying(255),
    office_address text,
    company_website text,
    password character varying,
    how_did_you_know text,
    touchpoint character varying(500),
    brand character varying(255),
    is_approved boolean,
    reset_password_token character varying(255),
    role character varying(500) NOT NULL,
    birthdate timestamp with time zone
);


ALTER TABLE public.users_users OWNER TO dexterton;

--
-- Data for Name: account_emailaddress; Type: TABLE DATA; Schema: public; Owner: dexterton
--

COPY public.account_emailaddress (id, email, verified, "primary", user_id) FROM stdin;
\.


--
-- Data for Name: account_emailconfirmation; Type: TABLE DATA; Schema: public; Owner: dexterton
--

COPY public.account_emailconfirmation (id, created, sent, key, email_address_id) FROM stdin;
\.


--
-- Data for Name: activity_logs_activitylogs; Type: TABLE DATA; Schema: public; Owner: dexterton
--

COPY public.activity_logs_activitylogs (id, created_at, action, user_id) FROM stdin;
bffe362e-445e-4129-9f0e-9cf1869b8e9d	2025-04-29 05:41:59.737759+00	Uploaded image banner web_banner_0.jpg	a787f73e-197c-4043-9325-50e14986b368
78a3fce7-2037-4ec8-8f6e-67fb22057063	2025-04-29 06:14:10.338459+00	Created catalog Sample	a787f73e-197c-4043-9325-50e14986b368
1e874b49-664f-4556-8dcc-72d6980cf543	2025-04-29 06:24:16.854018+00	Marked inquiry from webdev@dexterton.com for Reserved Seating to 'resolved'	a787f73e-197c-4043-9325-50e14986b368
2b05a5c3-0f77-4416-85e2-7bea2002b791	2025-04-29 07:52:22.102052+00	Uploaded image banner web_banner_0.jpg	a787f73e-197c-4043-9325-50e14986b368
c1ee5c76-f794-4658-b5a4-9d1f5b932f49	2025-05-05 02:11:28.642568+00	Marked inquiry from alyza.magsombol@dexterton.com for Center Pointe Sofa to 'resolved'	9247fa77-d408-4e8c-9004-ceaf3da6621e
e7622256-4ccb-425e-9288-c51fab8ea514	2025-05-05 02:11:34.062277+00	Marked inquiry from ktfpaguio2000@gmail.com for Palm Beach to 'resolved'	9247fa77-d408-4e8c-9004-ceaf3da6621e
bd9a0099-447f-4321-a2db-c7abf54475f5	2025-05-05 02:25:47.982229+00	Marked inquiry from ktfpaguio2000@gmail.com for Gamma to 'resolved'	9247fa77-d408-4e8c-9004-ceaf3da6621e
4f339bd6-6b83-4c19-ad47-e2b45ac82eb8	2025-05-05 02:25:56.090288+00	Marked inquiry from ktfpaguio2000@gmail.com for Gamma to 'resolved'	9247fa77-d408-4e8c-9004-ceaf3da6621e
e46e23aa-8962-4b5d-b49e-a458b0ac71b6	2025-05-06 06:25:39.665381+00	Marked inquiry from alyza.magsombol@dexterton.com for Center Pointe Sofa to 'endorsed'	a787f73e-197c-4043-9325-50e14986b368
3689ef5f-d363-4250-98de-14b15dba1243	2025-05-06 06:25:41.656009+00	Marked inquiry from webdev@dexterton.com for Reserved Seating to 'endorsed'	a787f73e-197c-4043-9325-50e14986b368
20b574c8-af35-4f25-8e59-f74e4068fb5a	2025-05-06 06:25:43.494749+00	Marked inquiry from ktfpaguio2000@gmail.com for Palm Beach to 'endorsed'	a787f73e-197c-4043-9325-50e14986b368
592f30e3-0d5a-4cef-8197-cc873676dd88	2025-05-06 06:25:45.591007+00	Marked inquiry from ktfpaguio2000@gmail.com for Gamma to 'endorsed'	a787f73e-197c-4043-9325-50e14986b368
7366811f-458c-4cda-9595-c66e9d149f81	2025-05-06 06:25:48.750726+00	Marked inquiry from dan.lazaro00@gmail.com for Beauty Sleep Ame. King to 'pending'	a787f73e-197c-4043-9325-50e14986b368
3ea57ab9-ec6c-49a6-9058-68d63eb63690	2025-05-06 06:25:50.998601+00	Marked inquiry from dan.lazaro00@gmail.com for Champagne to 'pending'	a787f73e-197c-4043-9325-50e14986b368
8d74f180-8547-4988-9178-679d52a2e486	2025-05-06 08:33:03.720905+00	Created catalog NEW ARRIVALS 2025	9247fa77-d408-4e8c-9004-ceaf3da6621e
491831a9-9017-4b58-9672-89bd6b4eab11	2025-05-06 08:41:42.415024+00	Created catalog CARACOLE HP 2024	9247fa77-d408-4e8c-9004-ceaf3da6621e
4be2458d-f378-420e-8e42-6c02e86e7282	2025-05-06 09:21:21.661248+00	Created catalog Test Only	a787f73e-197c-4043-9325-50e14986b368
dcbb4f03-b092-4aa8-9c03-c652148a06eb	2025-05-06 09:22:53.490669+00	Created catalog Test Only	a787f73e-197c-4043-9325-50e14986b368
32e807a1-9a10-4a31-9104-7fd2a53e54e4	2025-05-06 09:23:26.540136+00	Created catalog Test Only	a787f73e-197c-4043-9325-50e14986b368
e84eff57-fdfe-4844-8102-df82d13c31f6	2025-05-06 09:24:10.259763+00	Created catalog Test Only	a787f73e-197c-4043-9325-50e14986b368
daf11b36-be49-4846-91d3-8635394f304b	2025-05-06 09:24:57.99114+00	Created catalog Test Only	a787f73e-197c-4043-9325-50e14986b368
38c27c45-6896-4234-a0d3-0eadf17ca22c	2025-05-06 09:25:06.248771+00	Created catalog Test Only	a787f73e-197c-4043-9325-50e14986b368
1c531e92-a3b1-456e-b1b9-39b7ffed4452	2025-05-06 09:25:10.811194+00	Created catalog Test Only	a787f73e-197c-4043-9325-50e14986b368
43772d73-ac29-4890-8be2-92bc3bf1f428	2025-05-06 09:27:04.366339+00	Created catalog CARACOLE HP 2024	a787f73e-197c-4043-9325-50e14986b368
8b8e6b5c-fbbc-40ea-930d-773da0509a58	2025-05-07 00:55:21.627942+00	Created catalog Test Only	a787f73e-197c-4043-9325-50e14986b368
dbff6e40-56fe-4618-804b-169854f528b7	2025-05-07 00:56:54.800375+00	Created catalog Test Only	a787f73e-197c-4043-9325-50e14986b368
1896b091-c8d4-4412-9c60-4ce62c47b607	2025-05-07 00:57:05.269486+00	Created catalog Test Only	a787f73e-197c-4043-9325-50e14986b368
06c793c4-80b4-4e44-bb0f-45a7a2851991	2025-05-07 00:57:21.923705+00	Created catalog Test Only	a787f73e-197c-4043-9325-50e14986b368
59a6c12f-1cf7-4662-8616-d2bba110ef3d	2025-05-07 00:58:00.191669+00	Created catalog Test Only	a787f73e-197c-4043-9325-50e14986b368
362a575a-3cbd-4ff2-a335-b2c26e6de681	2025-05-07 03:49:05.122898+00	Marked general inquiry from rovic.dimacali@dexterton.com as 'endorsed'	a787f73e-197c-4043-9325-50e14986b368
0686f29a-a407-4a1a-9cb8-1eedfff0223d	2025-05-07 03:49:06.983457+00	Marked general inquiry from rovic.dimacali@dexterton.com as 'spam'	a787f73e-197c-4043-9325-50e14986b368
8fac5aae-e3c2-4bc0-946d-a872e5861a3b	2025-05-07 03:49:10.463388+00	Marked general inquiry from rovic.dimacali@dexterton.com as 'pending'	a787f73e-197c-4043-9325-50e14986b368
8cd2598e-6ee9-4c4d-9cae-7349f355f890	2025-05-08 06:01:36.33641+00	Created the blog 'Pinnacle Award Winners'	a787f73e-197c-4043-9325-50e14986b368
3c8e4ca9-15fe-45e6-9469-c8b84fab165c	2025-05-08 07:46:03.985628+00	Modified the blog 'Pinnacle Award Winners'	a787f73e-197c-4043-9325-50e14986b368
771577c3-5cea-4595-8d96-936ea2bf83ba	2025-05-08 08:06:29.380214+00	Created the blog 'Behind The Design: Live Wire'	a787f73e-197c-4043-9325-50e14986b368
6bb63d95-8a84-47ca-9610-ed8cef04a806	2025-05-08 08:15:37.035664+00	Created the blog 'DETAILS MATTER: Unique in Nature'	a787f73e-197c-4043-9325-50e14986b368
163f3109-0059-4a6a-9910-7225e1340263	2025-05-08 08:31:59.478116+00	Created the blog 'Trend Report: Play Up Pattern'	a787f73e-197c-4043-9325-50e14986b368
2f2626aa-3936-4c80-9b5a-a6e9491099b1	2025-05-08 08:33:17.970578+00	Modified the blog 'Trend Report: Play Up Pattern'	a787f73e-197c-4043-9325-50e14986b368
654f7610-7b20-4f0a-9eb8-946d95d90984	2025-05-09 01:48:12.971554+00	Modified the blog 'Trend Report: Play Up Pattern'	a787f73e-197c-4043-9325-50e14986b368
39f0beab-a617-4566-9640-9b368e3b2f91	2025-05-09 01:48:39.771049+00	Modified the blog 'Trend Report: Play Up Pattern'	a787f73e-197c-4043-9325-50e14986b368
c88df042-a617-45c6-a01d-f5e22fabed2d	2025-05-09 01:50:35.90321+00	Modified the blog 'Trend Report: Play Up Pattern'	a787f73e-197c-4043-9325-50e14986b368
5d1f7e43-b143-4677-b1e3-87aa87cc8d99	2025-05-09 01:51:02.515989+00	Modified the blog 'Trend Report: Play Up Pattern'	a787f73e-197c-4043-9325-50e14986b368
7297d399-86cd-48e0-a55d-74c4aa2ba2d7	2025-05-09 01:51:29.915478+00	Modified the blog 'Trend Report: Play Up Pattern'	a787f73e-197c-4043-9325-50e14986b368
6c953c3c-f697-459c-bec1-748ac076f3b9	2025-05-09 01:52:55.362385+00	Modified the blog 'Trend Report: Play Up Pattern'	a787f73e-197c-4043-9325-50e14986b368
4e5de07b-78e7-4870-8e3d-2811dcba0c71	2025-05-09 01:54:16.650427+00	Modified the blog 'Trend Report: Play Up Pattern'	a787f73e-197c-4043-9325-50e14986b368
7beb94d2-1051-4107-aba1-99b28d867874	2025-05-09 03:10:13.46122+00	Created the blog 'DETAILS MATTER: Custom Hardware'	a787f73e-197c-4043-9325-50e14986b368
53e8b1da-dd9e-425a-b2d8-5d2baab57431	2025-05-09 03:10:48.309654+00	Created the blog 'Testing Test'	a787f73e-197c-4043-9325-50e14986b368
139ae6a0-887b-46f3-8499-912a6dd4d92f	2025-05-09 03:13:03.377913+00	Modified the blog 'DETAILS MATTER: Custom Hardware'	a787f73e-197c-4043-9325-50e14986b368
2241d6af-f754-4111-8643-ec9948f5b2e1	2025-05-09 03:38:51.031559+00	Created the blog 'Casually Chic Style Spotlight'	a787f73e-197c-4043-9325-50e14986b368
c31e99e6-9e4b-437c-8942-1acda9a9e3d3	2025-05-09 05:35:48.486705+00	Modified the blog 'Pinnacle Award Winners'	a787f73e-197c-4043-9325-50e14986b368
\.


--
-- Data for Name: appointment_appointments; Type: TABLE DATA; Schema: public; Owner: dexterton
--

COPY public.appointment_appointments (id, created_at, updated_at, first_name, last_name, email, contact_number, company_name, branch, scheduled_date_time, remarks) FROM stdin;
c802b3dc-615b-4abd-b80b-7870295380f4	2025-03-29 11:26:54.777817+00	2025-03-29 11:26:54.777847+00	Rovic	Dimacali	joserovic.dimacali@gmail.com	09274815025	\N	QUEZON CITY	2025-03-30 08:26:40+00	\N
4f6e28f3-3207-4443-964b-4fa0b8a70fea	2025-03-31 08:57:13.83499+00	2025-03-31 08:57:13.835+00	Alyza	Magsombol	dan.lazaro00@gmail.com	094880242541234	Dexterton	QUEZON CITY	2025-04-08 01:00:24+00	\N
c729b7f9-4101-483d-a0e9-a415fc7609b5	2025-04-02 00:41:08.769385+00	2025-04-02 00:41:08.769395+00	Juan	Doe	kurtpaguio0430@gmail.com	09167065890	Google	BGC	2025-04-10 01:40:13+00	\N
fd807339-20ea-45ae-bc3a-32a5c08f4114	2025-04-02 00:48:34.845599+00	2025-04-23 05:28:40.603717+00	John	Doe	kurtpaguio0430@gmail.com	09167065890	Google	QUEZON CITY	2025-04-02 01:40:13+00	Attended
60cb770b-4112-4910-b437-30b326613b23	2025-04-29 06:34:12.467222+00	2025-04-29 06:34:12.467229+00	Rovic	Dimacali	rovic.dimacali@dexterton.com	09123456789	Dexterton	DEXTERTON QUEZON CITY	2025-04-30 07:45:44+00	\N
3c65cbdb-d56b-4f23-b2a7-fd50e60b8491	2025-04-30 06:36:43.632811+00	2025-04-30 06:36:43.632858+00	Kurt	Paguio	ktfpaguio2000@gmail.com	09167065890	Google	QC	2025-05-23 06:36:00+00	
964d2870-02a3-440b-aa72-b27df775e844	2025-04-30 07:19:50.36494+00	2025-04-30 07:19:50.364973+00	Kurt	Paguio	ktfpaguio2000@gmail.com	09167065890	Google	QC	2025-05-09 07:19:00+00	
ce2669ad-d580-40c8-bb33-f987c85a197e	2025-04-30 07:25:41.944474+00	2025-04-30 07:25:41.944519+00	Kurt	Paguio	ktfpaguio2000@gmail.com	09167065890	Google	QC	2025-05-15 07:25:00+00	
81f20076-073a-450f-9c22-53cc620b4902	2025-04-30 07:28:34.807004+00	2025-04-30 07:28:34.807066+00	Kurt	Paguio	ktfpaguio2000@gmail.com	09167065890	Google	QC	2025-05-21 07:28:00+00	
\.


--
-- Data for Name: archives_archives; Type: TABLE DATA; Schema: public; Owner: dexterton
--

COPY public.archives_archives (id, created_at, model, model_object_id) FROM stdin;
8a7fadad-08f9-447b-97d0-3a85fd085c9c	2025-04-29 06:14:58.063497+00	Catalogs	1cca43fd-5c09-468c-9777-096d1b159479
905b9a94-d674-42c8-a257-f0fb32149f41	2025-04-29 08:22:29.933023+00	Products	cba229f3-061f-4ca8-bf3b-721ccfc91cd7
94404c71-6e72-45bd-9446-fbd296cf50ce	2025-04-14 05:53:11.147628+00	Products	1503007b-9e48-4fd7-bd5d-0b46efb4a23c
176b80f8-aa1b-4e33-aba9-fb2b79d75665	2025-04-23 02:04:46.646989+00	Blogs	54f89693-ad9a-45fe-bb41-ace9969efbdb
8f556761-a551-4b1f-8b3e-864c4dc99c96	2025-04-23 03:23:53.03496+00	Projects	beeabda1-ca7c-4635-99be-4ff586f06c5a
d2703d48-cb84-4329-8cf2-d315528c30cb	2025-04-29 05:59:45.937755+00	Products	c0f467e5-4c5d-4d47-bd0b-f0e888600ba4
9bc5a449-b774-4d25-bbe9-ac85cbdbdc74	2025-04-29 06:07:43.737019+00	Products	077cea75-a403-4c2f-b270-c3f6d5d82e8f
7e67487b-27b6-41e9-ad48-c7ba24b9f7af	2025-04-29 06:08:00.285604+00	Products	0ac312cb-5bf0-4bef-992e-02ee341148b4
926ccf64-b70d-4923-ab16-5ce3da01eae6	2025-04-29 06:08:53.203824+00	Products	398d5691-f7d9-4523-8ca5-2ce6dd18358e
c0ac7acb-6d60-4d7c-86c3-79e66ccf9c64	2025-04-29 06:09:29.405397+00	Categories	dbdcb641-111c-499f-a9ac-86a4f1274f1e
2ccd30e4-7c9c-4fca-8bf2-11be117b8f8a	2025-04-29 06:10:17.698959+00	Products	00d43a99-e332-4dac-85d6-542741fdd761
1251c8dc-0d1b-4b60-ab96-30565b21aa37	2025-04-29 06:10:19.615545+00	Products	980280a4-ed2e-4d5e-84e5-0762a3bc1dca
67fd8cd9-4d19-4e57-a481-119ce46f1ba1	2025-05-07 01:13:31.45006+00	Catalogs	1fb30de3-8ce6-4a36-a0ef-a0e9ac5ce233
76523071-e94a-4ea8-bcc0-46589dd466bd	2025-05-09 04:44:21.052353+00	Blogs	a0f1e053-8987-4c75-9c91-7fd8a4e48bf6
\.


--
-- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: dexterton
--

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


--
-- Data for Name: auth_group_permissions; Type: TABLE DATA; Schema: public; Owner: dexterton
--

COPY public.auth_group_permissions (id, group_id, permission_id) FROM stdin;
\.


--
-- Data for Name: auth_permission; Type: TABLE DATA; Schema: public; Owner: dexterton
--

COPY public.auth_permission (id, name, content_type_id, codename) FROM stdin;
1	Can add log entry	1	add_logentry
2	Can change log entry	1	change_logentry
3	Can delete log entry	1	delete_logentry
4	Can view log entry	1	view_logentry
5	Can add permission	2	add_permission
6	Can change permission	2	change_permission
7	Can delete permission	2	delete_permission
8	Can view permission	2	view_permission
9	Can add group	3	add_group
10	Can change group	3	change_group
11	Can delete group	3	delete_group
12	Can view group	3	view_group
13	Can add content type	4	add_contenttype
14	Can change content type	4	change_contenttype
15	Can delete content type	4	delete_contenttype
16	Can view content type	4	view_contenttype
17	Can add session	5	add_session
18	Can change session	5	change_session
19	Can delete session	5	delete_session
20	Can view session	5	view_session
21	Can add email address	6	add_emailaddress
22	Can change email address	6	change_emailaddress
23	Can delete email address	6	delete_emailaddress
24	Can view email address	6	view_emailaddress
25	Can add email confirmation	7	add_emailconfirmation
26	Can change email confirmation	7	change_emailconfirmation
27	Can delete email confirmation	7	delete_emailconfirmation
28	Can view email confirmation	7	view_emailconfirmation
29	Can add social account	8	add_socialaccount
30	Can change social account	8	change_socialaccount
31	Can delete social account	8	delete_socialaccount
32	Can view social account	8	view_socialaccount
33	Can add social application	9	add_socialapp
34	Can change social application	9	change_socialapp
35	Can delete social application	9	delete_socialapp
36	Can view social application	9	view_socialapp
37	Can add social application token	10	add_socialtoken
38	Can change social application token	10	change_socialtoken
39	Can delete social application token	10	delete_socialtoken
40	Can view social application token	10	view_socialtoken
41	Can add Token	11	add_token
42	Can change Token	11	change_token
43	Can delete Token	11	delete_token
44	Can view Token	11	view_token
45	Can add Token	12	add_tokenproxy
46	Can change Token	12	change_tokenproxy
47	Can delete Token	12	delete_tokenproxy
48	Can view Token	12	view_tokenproxy
49	Can add crontab	13	add_crontabschedule
50	Can change crontab	13	change_crontabschedule
51	Can delete crontab	13	delete_crontabschedule
52	Can view crontab	13	view_crontabschedule
53	Can add interval	14	add_intervalschedule
54	Can change interval	14	change_intervalschedule
55	Can delete interval	14	delete_intervalschedule
56	Can view interval	14	view_intervalschedule
57	Can add periodic task	15	add_periodictask
58	Can change periodic task	15	change_periodictask
59	Can delete periodic task	15	delete_periodictask
60	Can view periodic task	15	view_periodictask
61	Can add periodic task track	16	add_periodictasks
62	Can change periodic task track	16	change_periodictasks
63	Can delete periodic task track	16	delete_periodictasks
64	Can view periodic task track	16	view_periodictasks
65	Can add solar event	17	add_solarschedule
66	Can change solar event	17	change_solarschedule
67	Can delete solar event	17	delete_solarschedule
68	Can view solar event	17	view_solarschedule
69	Can add clocked	18	add_clockedschedule
70	Can change clocked	18	change_clockedschedule
71	Can delete clocked	18	delete_clockedschedule
72	Can view clocked	18	view_clockedschedule
73	Can add log entry	19	add_logentry
74	Can change log entry	19	change_logentry
75	Can delete log entry	19	delete_logentry
76	Can view log entry	19	view_logentry
77	Can add user	20	add_users
78	Can change user	20	change_users
79	Can delete user	20	delete_users
80	Can view user	20	view_users
81	Can add user invitation	21	add_userinvitation
82	Can change user invitation	21	change_userinvitation
83	Can delete user invitation	21	delete_userinvitation
84	Can view user invitation	21	view_userinvitation
85	Can add inquiries	22	add_inquiries
86	Can change inquiries	22	change_inquiries
87	Can delete inquiries	22	delete_inquiries
88	Can view inquiries	22	view_inquiries
89	Can add catalogs	23	add_catalogs
90	Can change catalogs	23	change_catalogs
91	Can delete catalogs	23	delete_catalogs
92	Can view catalogs	23	view_catalogs
93	Can add categories	24	add_categories
94	Can change categories	24	change_categories
95	Can delete categories	24	delete_categories
96	Can view categories	24	view_categories
97	Can add news and press releases	25	add_newsandpressreleases
98	Can change news and press releases	25	change_newsandpressreleases
99	Can delete news and press releases	25	delete_newsandpressreleases
161	Can add reports	41	add_reports
100	Can view news and press releases	25	view_newsandpressreleases
101	Can add series	26	add_series
102	Can change series	26	change_series
103	Can delete series	26	delete_series
104	Can view series	26	view_series
105	Can add settings	27	add_settings
106	Can change settings	27	change_settings
107	Can delete settings	27	delete_settings
108	Can view settings	27	view_settings
109	Can add news gallery	28	add_newsgallery
110	Can change news gallery	28	change_newsgallery
111	Can delete news gallery	28	delete_newsgallery
112	Can view news gallery	28	view_newsgallery
113	Can add products	29	add_products
114	Can change products	29	change_products
115	Can delete products	29	delete_products
116	Can view products	29	view_products
117	Can add product gallery	30	add_productgallery
118	Can change product gallery	30	change_productgallery
119	Can delete product gallery	30	delete_productgallery
120	Can view product gallery	30	view_productgallery
121	Can add featured products	31	add_featuredproducts
122	Can change featured products	31	change_featuredproducts
123	Can delete featured products	31	delete_featuredproducts
124	Can view featured products	31	view_featuredproducts
125	Can add appointments	32	add_appointments
126	Can change appointments	32	change_appointments
127	Can delete appointments	32	delete_appointments
128	Can view appointments	32	view_appointments
129	Can add blogs	33	add_blogs
130	Can change blogs	33	change_blogs
131	Can delete blogs	33	delete_blogs
132	Can view blogs	33	view_blogs
133	Can add archives	34	add_archives
134	Can change archives	34	change_archives
135	Can delete archives	34	delete_archives
136	Can view archives	34	view_archives
137	Can add projects	35	add_projects
138	Can change projects	35	change_projects
139	Can delete projects	35	delete_projects
140	Can view projects	35	view_projects
141	Can add product focus	36	add_productfocus
142	Can change product focus	36	change_productfocus
143	Can delete product focus	36	delete_productfocus
144	Can view product focus	36	view_productfocus
145	Can add contact us	37	add_contactus
146	Can change contact us	37	change_contactus
147	Can delete contact us	37	delete_contactus
148	Can view contact us	37	view_contactus
149	Can add news letter receipents	38	add_newsletterreceipents
150	Can change news letter receipents	38	change_newsletterreceipents
151	Can delete news letter receipents	38	delete_newsletterreceipents
152	Can view news letter receipents	38	view_newsletterreceipents
153	Can add app clients	39	add_appclients
154	Can change app clients	39	change_appclients
155	Can delete app clients	39	delete_appclients
156	Can view app clients	39	view_appclients
157	Can add integration tokens	40	add_integrationtokens
158	Can change integration tokens	40	change_integrationtokens
159	Can delete integration tokens	40	delete_integrationtokens
160	Can view integration tokens	40	view_integrationtokens
162	Can change reports	41	change_reports
163	Can delete reports	41	delete_reports
164	Can view reports	41	view_reports
165	Can add activity logs	42	add_activitylogs
166	Can change activity logs	42	change_activitylogs
167	Can delete activity logs	42	delete_activitylogs
168	Can view activity logs	42	view_activitylogs
\.


--
-- Data for Name: authtoken_token; Type: TABLE DATA; Schema: public; Owner: dexterton
--

COPY public.authtoken_token (key, created, user_id) FROM stdin;
\.


--
-- Data for Name: blogs_blogs; Type: TABLE DATA; Schema: public; Owner: dexterton
--

COPY public.blogs_blogs (id, created_at, updated_at, image_banner, title, body, date_created) FROM stdin;
2bac2e10-5a12-4ea7-8f65-9ce79ba63671	2025-05-08 08:06:29.356077+00	2025-05-08 08:06:29.356088+00	https://cdn.caracole.ph/blogs/blogs_banners/Behind_The_Design:_Live_Wire/Christopher-Sandomenico-Live-Wire-chair.jpg	Behind The Design: Live Wire	{"delta": "", "html": "<p><span style=\\"color: rgb(139, 139, 139);\\">Award-winning,&nbsp;in-house&nbsp;designer&nbsp;Christopher&nbsp;Sandomenico&nbsp;Director&nbsp;of&nbsp;Product&nbsp;Development,&nbsp;created&nbsp;a&nbsp;perfect&nbsp;scale&nbsp;model&nbsp;to&nbsp;refine&nbsp;the&nbsp;design&nbsp;details&nbsp;of&nbsp;our&nbsp;new&nbsp;Live&nbsp;Wire&nbsp;chair.&nbsp;Inspired&nbsp;by&nbsp;a&nbsp;suspension&nbsp;bridge&nbsp;in&nbsp;harmony&nbsp;with&nbsp;its&nbsp;natural&nbsp;environment,&nbsp;this&nbsp;sleek&nbsp;modern&nbsp;chair&nbsp;balances&nbsp;resilience&nbsp;with&nbsp;form&nbsp;and&nbsp;proportion&nbsp;to&nbsp;create&nbsp;its&nbsp;sturdy,&nbsp;yet&nbsp;elegant&nbsp;frame.&nbsp;</span></p><p></p><p><span style=\\"color: rgb(139, 139, 139);\\">&quot;This&nbsp;was&nbsp;a&nbsp;special&nbsp;chair&nbsp;that&nbsp;was&nbsp;so&nbsp;different&nbsp;than&nbsp;anything&nbsp;we&#39;ve&nbsp;ever&nbsp;done...&nbsp;It&nbsp;was&nbsp;an&nbsp;absolute&nbsp;necessity&nbsp;to&nbsp;create&nbsp;to&nbsp;3D&nbsp;model&nbsp;to&nbsp;make&nbsp;sure&nbsp;the&nbsp;form&nbsp;remains&nbsp;functional&nbsp;as&nbsp;a&nbsp;chair.&quot;&nbsp;-Christopher&nbsp;Sandomenico,&nbsp;Director&nbsp;of&nbsp;Product&nbsp;Development</span></p><p></p><p><span style=\\"color: rgb(139, 139, 139);\\">The&nbsp;designer&nbsp;created&nbsp;a&nbsp;perfect&nbsp;scale&nbsp;model&nbsp;to&nbsp;refine&nbsp;the&nbsp;details&nbsp;of&nbsp;this&nbsp;sleek&nbsp;modern&nbsp;chair,&nbsp;poised&nbsp;to&nbsp;make&nbsp;an&nbsp;unforgettable&nbsp;statement&nbsp;in&nbsp;a&nbsp;Tungsten&nbsp;finish.&nbsp;Architecturally&nbsp;inspired,&nbsp;its&nbsp;curvilinear&nbsp;form&nbsp;is&nbsp;meticulously&nbsp;crafted&nbsp;from&nbsp;a&nbsp;series&nbsp;of&nbsp;tubular&nbsp;metal&nbsp;spokes&nbsp;radiating&nbsp;from&nbsp;a&nbsp;sturdy,&nbsp;yet&nbsp;elegant&nbsp;hoop&nbsp;frame.&nbsp;Igniting&nbsp;and&nbsp;inviting:&nbsp;a&nbsp;channel-tufted&nbsp;back&nbsp;and&nbsp;rounded&nbsp;seat&nbsp;in&nbsp;a&nbsp;platinum-toned,&nbsp;embossed&nbsp;fabric&nbsp;with&nbsp;the&nbsp;luxe&nbsp;look&nbsp;and&nbsp;feel&nbsp;of&nbsp;leather.</span></p><p></p><p><span style=\\"color: rgb(139, 139, 139);\\">Poised&nbsp;to&nbsp;make&nbsp;an&nbsp;unforgettable&nbsp;statement&nbsp;in&nbsp;a&nbsp;Tungsten&nbsp;finish,&nbsp;our&nbsp;</span><strong style=\\"color: rgb(139, 139, 139);\\">Live&nbsp;Wire</strong><span style=\\"color: rgb(139, 139, 139);\\">&nbsp;chair&nbsp;features&nbsp;a&nbsp;channel-tufted&nbsp;back&nbsp;and&nbsp;rounded&nbsp;seat&nbsp;in&nbsp;a&nbsp;platinum-toned,&nbsp;embossed&nbsp;fabric&nbsp;with&nbsp;the&nbsp;luxe&nbsp;look&nbsp;and&nbsp;feel&nbsp;of&nbsp;leather.</span></p><p></p><p><span style=\\"color: rgb(139, 139, 139);\\">Its&nbsp;curvilinear&nbsp;form&nbsp;beautifully&nbsp;fuses&nbsp;ideation&nbsp;and&nbsp;innovation&nbsp;with&nbsp;functionality.</span></p>"}	2022-03-03 16:00:00+00
fa6eae1f-61b7-4e4c-9afe-bb323e464477	2025-05-08 08:15:37.012688+00	2025-05-08 08:15:37.012699+00	https://cdn.caracole.ph/blogs/blogs_banners/DETAILS_MATTER:_Unique_in_Nature/cla-020-0611.jpg	DETAILS MATTER: Unique in Nature	{"delta": "", "html": "<p><span style=\\"color: rgb(139, 139, 139);\\">A&nbsp;natural&nbsp;work&nbsp;of&nbsp;art,&nbsp;spalted&nbsp;maple&nbsp;is&nbsp;prized&nbsp;for&nbsp;its&nbsp;seemingly&nbsp;hand-drawn&nbsp;lines&nbsp;and&nbsp;unique&nbsp;colorations&nbsp;formed&nbsp;from&nbsp;a&nbsp;symbiotic&nbsp;relationship&nbsp;between&nbsp;fungi&nbsp;and&nbsp;wood.&nbsp;Digitally&nbsp;printing&nbsp;this&nbsp;intricately&nbsp;patterned&nbsp;wood&nbsp;grain&nbsp;on&nbsp;maple&nbsp;veneer&nbsp;integrates&nbsp;an&nbsp;organic&nbsp;artform&nbsp;with&nbsp;new&nbsp;technology&nbsp;to&nbsp;beautifully&nbsp;capture&nbsp;what&nbsp;nature&nbsp;creates&nbsp;randomly.</span></p><p></p><p><span style=\\"color: rgb(139, 139, 139);\\">The&nbsp;great&nbsp;outdoors&nbsp;has&nbsp;always&nbsp;been&nbsp;the&nbsp;best&nbsp;remedy&nbsp;for&nbsp;the&nbsp;mind&nbsp;and&nbsp;body,&nbsp;but&nbsp;also&nbsp;the&nbsp;home.&nbsp;For&nbsp;many,&nbsp;the&nbsp;use&nbsp;of&nbsp;natural&nbsp;and&nbsp;organic&nbsp;elements&nbsp;in&nbsp;home&nbsp;d\\u00e9cor&nbsp;helps&nbsp;them&nbsp;feel&nbsp;balanced&nbsp;and&nbsp;at&nbsp;peace.&nbsp;Science&nbsp;proves&nbsp;that&nbsp;being&nbsp;in&nbsp;nature,&nbsp;or&nbsp;even&nbsp;viewing&nbsp;scenes&nbsp;of&nbsp;nature,&nbsp;reduces&nbsp;anger,&nbsp;fear,&nbsp;and&nbsp;stress&nbsp;and&nbsp;increases&nbsp;pleasant&nbsp;feelings.&nbsp;Exposure&nbsp;to&nbsp;nature&nbsp;and&nbsp;natural&nbsp;elements&nbsp;not&nbsp;only&nbsp;makes&nbsp;you&nbsp;feel&nbsp;better&nbsp;emotionally,&nbsp;but&nbsp;also&nbsp;contributes&nbsp;to&nbsp;your&nbsp;physical&nbsp;wellbeing.</span></p><p></p><p><span style=\\"color: rgb(139, 139, 139);\\">At&nbsp;Caracole&nbsp;the&nbsp;concept&nbsp;of&nbsp;natural&nbsp;decorating&nbsp;has&nbsp;been&nbsp;taken&nbsp;to&nbsp;a&nbsp;more&nbsp;sophisticated,&nbsp;intercontinental&nbsp;level,&nbsp;combining&nbsp;unusual&nbsp;woods,&nbsp;beautiful&nbsp;finishes,&nbsp;specialty&nbsp;details,&nbsp;and&nbsp;unique&nbsp;interpretations&nbsp;of&nbsp;the&nbsp;natural&nbsp;world&nbsp;around&nbsp;us.&nbsp;Since&nbsp;we&nbsp;can\\u2019t&nbsp;spend&nbsp;all&nbsp;of&nbsp;our&nbsp;time&nbsp;outdoors&nbsp;in&nbsp;nature,&nbsp;it\\u2019s&nbsp;important&nbsp;to&nbsp;bring&nbsp;natural&nbsp;elements&nbsp;inside&nbsp;to&nbsp;encourage&nbsp;peace&nbsp;and&nbsp;calmness&nbsp;at&nbsp;home.&nbsp;</span></p><p></p>"}	2022-03-03 16:00:00+00
3c449cd2-df1b-493c-8532-b0d520733eb0	2025-05-08 08:31:59.46119+00	2025-05-09 01:54:16.578625+00	https://cdn.caracole.ph/blogs/blogs_banners/Trend_Report:_Play_Up_Pattern/cla-420-531-rs2.jpg	Trend Report: Play Up Pattern	{"delta": "", "html": "<p class=\\"ql-align-justify\\"><span style=\\"color: rgb(139, 139, 139);\\">Whether&nbsp;understated&nbsp;or&nbsp;a&nbsp;bold&nbsp;focal&nbsp;feature,&nbsp;patterns&nbsp;play&nbsp;up&nbsp;the&nbsp;innate&nbsp;geometry&nbsp;and&nbsp;shapes&nbsp;within&nbsp;a&nbsp;space&nbsp;for&nbsp;a&nbsp;sense&nbsp;of&nbsp;balance&nbsp;and&nbsp;symmetry.&nbsp;As&nbsp;a&nbsp;graphic&nbsp;element,&nbsp;patterns&nbsp;add&nbsp;embellishment&nbsp;and&nbsp;visual&nbsp;interest.&nbsp;Repeating&nbsp;patterns&nbsp;create&nbsp;rhythm&nbsp;and&nbsp;tactile&nbsp;appeal&nbsp;for&nbsp;a&nbsp;dynamic&nbsp;accent&nbsp;that&nbsp;sets&nbsp;the&nbsp;mood&nbsp;and&nbsp;transforms&nbsp;a&nbsp;room.</span></p><p class=\\"ql-align-justify\\"></p><p class=\\"ql-align-center\\"><span style=\\"color: rgb(139, 139, 139);\\">Layering&nbsp;patterns&nbsp;-&nbsp;like&nbsp;the&nbsp;cut-metal&nbsp;motifs&nbsp;accenting&nbsp;the&nbsp;cocktail&nbsp;table&nbsp;with&nbsp;the&nbsp;raised&nbsp;fretwork&nbsp;side&nbsp;panels&nbsp;of&nbsp;the&nbsp;sofa&nbsp;and&nbsp;chairs&nbsp;-&nbsp;creates&nbsp;visual&nbsp;allure.</span></p><p class=\\"ql-align-center\\"></p><p class=\\"ql-align-center\\"><img src=\\"data:image/jpeg;base64,[encoded data, 161764 characters]\\"></p><p class=\\"ql-align-center\\"></p><p class=\\"ql-align-justify\\"><span style=\\"color: rgb(139, 139, 139);\\">Destined&nbsp;to&nbsp;steal&nbsp;the&nbsp;scene,&nbsp;this&nbsp;luxurious&nbsp;console&nbsp;offers&nbsp;exquisite&nbsp;styling&nbsp;and&nbsp;modern&nbsp;media&nbsp;storage.&nbsp;Its&nbsp;signature&nbsp;look&nbsp;is&nbsp;brought&nbsp;to&nbsp;life&nbsp;with&nbsp;six&nbsp;doors&nbsp;featuring&nbsp;antique&nbsp;mirror&nbsp;fronts&nbsp;highlighted&nbsp;with&nbsp;elegant&nbsp;fretwork&nbsp;in&nbsp;Taupe&nbsp;Silver&nbsp;Leaf.&nbsp;Balanced&nbsp;in&nbsp;every&nbsp;way,&nbsp;its&nbsp;symmetrical&nbsp;design&nbsp;is&nbsp;accented&nbsp;by&nbsp;unique&nbsp;Mother&nbsp;of&nbsp;pearl&nbsp;hardware.&nbsp;Inside,&nbsp;you\\u2019ll&nbsp;find&nbsp;integrated&nbsp;wire&nbsp;management&nbsp;and&nbsp;ventilation&nbsp;that&nbsp;makes&nbsp;media&nbsp;and&nbsp;electronics&nbsp;storage&nbsp;a&nbsp;breeze.&nbsp;Two&nbsp;soft-close&nbsp;tray&nbsp;drawers&nbsp;add&nbsp;function&nbsp;to&nbsp;its&nbsp;center&nbsp;section&nbsp;while&nbsp;two&nbsp;adjustable&nbsp;shelves&nbsp;can&nbsp;be&nbsp;found&nbsp;behind&nbsp;each&nbsp;pair&nbsp;of&nbsp;outside&nbsp;doors.&nbsp;Fashionable&nbsp;metal&nbsp;feet&nbsp;and&nbsp;stretchers&nbsp;add&nbsp;beauty&nbsp;to&nbsp;its&nbsp;long,&nbsp;lean&nbsp;profile&nbsp;while&nbsp;emphasizing&nbsp;its&nbsp;overall&nbsp;allure.</span></p><p class=\\"ql-align-justify\\"></p><p class=\\"ql-align-justify\\"><span style=\\"color: rgb(139, 139, 139);\\">Metal&nbsp;fretwork&nbsp;in&nbsp;an&nbsp;open&nbsp;graphic&nbsp;pattern&nbsp;introduces&nbsp;an&nbsp;element&nbsp;of&nbsp;distinction.</span></p><p class=\\"ql-align-right\\"></p><p class=\\"ql-align-right\\"><img src=\\"data:image/png;base64,[encoded data, 307082 characters]