--
--


SET transaction_timeout = 0;

--
-- 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: 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: 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: 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: 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_newarrivalproducts; Type: TABLE; Schema: public; Owner: dexterton
--

CREATE TABLE public.products_newarrivalproducts (
    id uuid NOT NULL,
    created_at timestamp with time zone NOT NULL,
    product_id uuid NOT NULL
);


ALTER TABLE public.products_newarrivalproducts 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_new_arrival 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: 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;

--
-- 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: activity_logs_activitylogs; Type: TABLE DATA; Schema: public; Owner: dexterton
--

COPY public.activity_logs_activitylogs (id, created_at, action, user_id) FROM stdin;
44ee65ba-a302-4bec-b8a9-0f53a202da1c	2025-05-20 00:45:40.409165+00	Changed from status pending to attended	9247fa77-d408-4e8c-9004-ceaf3da6621e
e6e2c379-cd32-4bc5-ac6c-d9f8fa1a51c5	2025-05-20 00:45:42.621139+00	Changed from status pending to attended	9247fa77-d408-4e8c-9004-ceaf3da6621e
\.


--
-- 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;
\.


--
-- 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;
fcddc4db-d402-4c52-b980-ef5c3a968d7b	2025-05-14 09:04:57.932905+00	Catalogs	aa76a9ec-e9d9-48bb-a3ff-83846157bb70
\.


--
-- 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
169	Can add new arrival products	43	add_newarrivalproducts
170	Can change new arrival products	43	change_newarrivalproducts
171	Can delete new arrival products	43	delete_newarrivalproducts
172	Can view new arrival products	43	view_newarrivalproducts
\.


--
-- 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,[BLOB]\\"></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,[BLOB]