--
--





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

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


ALTER TABLE public.auth_group OWNER TO wenanitmekazino;

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

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: wenanitmekazino
--

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


ALTER TABLE public.auth_group_permissions OWNER TO wenanitmekazino;

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

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: wenanitmekazino
--

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 wenanitmekazino;

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

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: auth_user_groups; Type: TABLE; Schema: public; Owner: wenanitmekazino
--

CREATE TABLE public.auth_user_groups (
    id bigint NOT NULL,
    user_id integer NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE public.auth_user_groups OWNER TO wenanitmekazino;

--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: wenanitmekazino
--

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


--
-- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: wenanitmekazino
--

CREATE TABLE public.auth_user_user_permissions (
    id bigint NOT NULL,
    user_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_user_user_permissions OWNER TO wenanitmekazino;

--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: wenanitmekazino
--

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


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

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 integer NOT NULL,
    CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
);


ALTER TABLE public.django_admin_log OWNER TO wenanitmekazino;

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

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_content_type; Type: TABLE; Schema: public; Owner: wenanitmekazino
--

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 wenanitmekazino;

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

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: wenanitmekazino
--

CREATE TABLE public.django_migrations (
    id bigint 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 wenanitmekazino;

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

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: website_aboutus; Type: TABLE; Schema: public; Owner: wenanitmekazino
--

CREATE TABLE public.website_aboutus (
    id bigint NOT NULL,
    content text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    core_values text NOT NULL,
    image character varying(100),
    mission_statement text NOT NULL,
    title character varying(200) NOT NULL,
    vision_statement text NOT NULL
);


ALTER TABLE public.website_aboutus OWNER TO wenanitmekazino;

--
-- Name: website_aboutus_id_seq; Type: SEQUENCE; Schema: public; Owner: wenanitmekazino
--

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


--
-- Name: website_careers; Type: TABLE; Schema: public; Owner: wenanitmekazino
--

CREATE TABLE public.website_careers (
    id bigint NOT NULL,
    "position" character varying(200) NOT NULL,
    description text NOT NULL,
    requirements text NOT NULL,
    is_active boolean NOT NULL,
    posted_at timestamp with time zone NOT NULL
);


ALTER TABLE public.website_careers OWNER TO wenanitmekazino;

--
-- Name: website_careers_id_seq; Type: SEQUENCE; Schema: public; Owner: wenanitmekazino
--

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


--
-- Name: website_companyaddress; Type: TABLE; Schema: public; Owner: wenanitmekazino
--

CREATE TABLE public.website_companyaddress (
    id bigint NOT NULL,
    company_name character varying(255) NOT NULL,
    description text NOT NULL,
    address_line_1 character varying(255) NOT NULL,
    address_line_2 character varying(255) NOT NULL,
    city character varying(100) NOT NULL,
    state character varying(100) NOT NULL,
    postal_code character varying(20) NOT NULL,
    country character varying(100) NOT NULL,
    email character varying(254) NOT NULL,
    phone character varying(20) NOT NULL,
    vat_number character varying(50) NOT NULL,
    reg_number character varying(50) NOT NULL,
    contact_person character varying(255) NOT NULL
);


ALTER TABLE public.website_companyaddress OWNER TO wenanitmekazino;

--
-- Name: website_companyaddress_id_seq; Type: SEQUENCE; Schema: public; Owner: wenanitmekazino
--

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


--
-- Name: website_contactmessage; Type: TABLE; Schema: public; Owner: wenanitmekazino
--

CREATE TABLE public.website_contactmessage (
    id bigint NOT NULL,
    name character varying(120) NOT NULL,
    email character varying(254) NOT NULL,
    phone character varying(50) NOT NULL,
    company character varying(120) NOT NULL,
    subject character varying(200) NOT NULL,
    message text NOT NULL,
    created_at timestamp with time zone NOT NULL,
    is_processed boolean NOT NULL
);


ALTER TABLE public.website_contactmessage OWNER TO wenanitmekazino;

--
-- Name: website_contactmessage_id_seq; Type: SEQUENCE; Schema: public; Owner: wenanitmekazino
--

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


--
-- Name: website_faqitem; Type: TABLE; Schema: public; Owner: wenanitmekazino
--

CREATE TABLE public.website_faqitem (
    id bigint NOT NULL,
    question character varying(300) NOT NULL,
    answer text NOT NULL,
    sort_order integer NOT NULL,
    is_active boolean NOT NULL,
    CONSTRAINT website_faqitem_sort_order_check CHECK ((sort_order >= 0))
);


ALTER TABLE public.website_faqitem OWNER TO wenanitmekazino;

--
-- Name: website_faqitem_id_seq; Type: SEQUENCE; Schema: public; Owner: wenanitmekazino
--

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


--
-- Name: website_service; Type: TABLE; Schema: public; Owner: wenanitmekazino
--

CREATE TABLE public.website_service (
    id bigint NOT NULL,
    title character varying(200) NOT NULL,
    short_description character varying(300) NOT NULL,
    description text NOT NULL,
    is_featured boolean NOT NULL,
    sort_order integer NOT NULL,
    is_active boolean NOT NULL,
    CONSTRAINT website_service_sort_order_check CHECK ((sort_order >= 0))
);


ALTER TABLE public.website_service OWNER TO wenanitmekazino;

--
-- Name: website_service_id_seq; Type: SEQUENCE; Schema: public; Owner: wenanitmekazino
--

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


--
-- Name: website_socialmedia; Type: TABLE; Schema: public; Owner: wenanitmekazino
--

CREATE TABLE public.website_socialmedia (
    id bigint NOT NULL,
    name character varying NOT NULL,
    url character varying(200) NOT NULL
);


ALTER TABLE public.website_socialmedia OWNER TO wenanitmekazino;

--
-- Name: website_socialmedia_id_seq; Type: SEQUENCE; Schema: public; Owner: wenanitmekazino
--

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


--
-- Name: website_testimonial; Type: TABLE; Schema: public; Owner: wenanitmekazino
--

CREATE TABLE public.website_testimonial (
    id bigint NOT NULL,
    client_name character varying(120),
    title character varying(200),
    company character varying(120),
    image character varying(100),
    content text NOT NULL,
    rating integer,
    created_at timestamp with time zone NOT NULL,
    website character varying(200),
    is_active boolean NOT NULL,
    sort_order integer NOT NULL,
    CONSTRAINT website_testimonial_rating_check CHECK ((rating >= 0)),
    CONSTRAINT website_testimonial_sort_order_check CHECK ((sort_order >= 0))
);


ALTER TABLE public.website_testimonial OWNER TO wenanitmekazino;

--
-- Name: website_testimonial_id_seq; Type: SEQUENCE; Schema: public; Owner: wenanitmekazino
--

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


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

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


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

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


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

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 user	4	add_user
14	Can change user	4	change_user
15	Can delete user	4	delete_user
16	Can view user	4	view_user
17	Can add content type	5	add_contenttype
18	Can change content type	5	change_contenttype
19	Can delete content type	5	delete_contenttype
20	Can view content type	5	view_contenttype
21	Can add session	6	add_session
22	Can change session	6	change_session
23	Can delete session	6	delete_session
24	Can view session	6	view_session
25	Can add About Us	7	add_aboutus
26	Can change About Us	7	change_aboutus
27	Can delete About Us	7	delete_aboutus
28	Can view About Us	7	view_aboutus
29	Can add Career	8	add_careers
30	Can change Career	8	change_careers
31	Can delete Career	8	delete_careers
32	Can view Career	8	view_careers
33	Can add Contact message	9	add_contactmessage
34	Can change Contact message	9	change_contactmessage
35	Can delete Contact message	9	delete_contactmessage
36	Can view Contact message	9	view_contactmessage
37	Can add FAQ item	10	add_faqitem
38	Can change FAQ item	10	change_faqitem
39	Can delete FAQ item	10	delete_faqitem
40	Can view FAQ item	10	view_faqitem
41	Can add Service	11	add_service
42	Can change Service	11	change_service
43	Can delete Service	11	delete_service
44	Can view Service	11	view_service
45	Can add Testimonial	12	add_testimonial
46	Can change Testimonial	12	change_testimonial
47	Can delete Testimonial	12	delete_testimonial
48	Can view Testimonial	12	view_testimonial
49	Can add Company Address	13	add_companyaddress
50	Can change Company Address	13	change_companyaddress
51	Can delete Company Address	13	delete_companyaddress
52	Can view Company Address	13	view_companyaddress
53	Can add Social Media	14	add_socialmedia
54	Can change Social Media	14	change_socialmedia
55	Can delete Social Media	14	delete_socialmedia
56	Can view Social Media	14	view_socialmedia
\.


--
-- Data for Name: auth_user_groups; Type: TABLE DATA; Schema: public; Owner: wenanitmekazino
--

COPY public.auth_user_groups (id, user_id, group_id) FROM stdin;
\.


--
-- Data for Name: auth_user_user_permissions; Type: TABLE DATA; Schema: public; Owner: wenanitmekazino
--

COPY public.auth_user_user_permissions (id, user_id, permission_id) FROM stdin;
\.


--
-- Data for Name: django_admin_log; Type: TABLE DATA; Schema: public; Owner: wenanitmekazino
--

COPY public.django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) FROM stdin;
\.


--
-- Data for Name: django_content_type; Type: TABLE DATA; Schema: public; Owner: wenanitmekazino
--

COPY public.django_content_type (id, app_label, model) FROM stdin;
1	admin	logentry
2	auth	permission
3	auth	group
4	auth	user
5	contenttypes	contenttype
6	sessions	session
7	website	aboutus
8	website	careers
9	website	contactmessage
10	website	faqitem
11	website	service
12	website	testimonial
13	website	companyaddress
14	website	socialmedia
\.


--
-- Data for Name: django_migrations; Type: TABLE DATA; Schema: public; Owner: wenanitmekazino
--

COPY public.django_migrations (id, app, name, applied) FROM stdin;
1	contenttypes	0001_initial	2026-01-26 16:06:20.070494+01
2	auth	0001_initial	2026-01-26 16:06:20.141686+01
3	admin	0001_initial	2026-01-26 16:06:20.158563+01
4	admin	0002_logentry_remove_auto_add	2026-01-26 16:06:20.166453+01
5	admin	0003_logentry_add_action_flag_choices	2026-01-26 16:06:20.172194+01
6	contenttypes	0002_remove_content_type_name	2026-01-26 16:06:20.187968+01
7	auth	0002_alter_permission_name_max_length	2026-01-26 16:06:20.193959+01
8	auth	0003_alter_user_email_max_length	2026-01-26 16:06:20.199612+01
9	auth	0004_alter_user_username_opts	2026-01-26 16:06:20.206214+01
10	auth	0005_alter_user_last_login_null	2026-01-26 16:06:20.212072+01
11	auth	0006_require_contenttypes_0002	2026-01-26 16:06:20.212871+01
12	auth	0007_alter_validators_add_error_messages	2026-01-26 16:06:20.21818+01
13	auth	0008_alter_user_username_max_length	2026-01-26 16:06:20.228391+01
14	auth	0009_alter_user_last_name_max_length	2026-01-26 16:06:20.234219+01
15	auth	0010_alter_group_name_max_length	2026-01-26 16:06:20.241641+01
16	auth	0011_update_proxy_permissions	2026-01-26 16:06:20.247909+01
17	auth	0012_alter_user_first_name_max_length	2026-01-26 16:06:20.253528+01
18	sessions	0001_initial	2026-01-26 16:06:20.260052+01
19	website	0001_initial	2026-01-26 17:32:51.464982+01
20	website	0002_companyaddress_socialmedia_testimonial_website	2026-01-27 13:15:49.683721+01
21	website	0003_testimonial_is_active_testimonial_sort_order	2026-01-27 16:17:04.006335+01
22	website	0004_alter_testimonial_client_name_and_more	2026-01-27 16:28:16.266269+01
23	website	0005_remove_testimonial_is_approved	2026-01-27 16:44:31.651552+01
24	website	0006_aboutus_core_values_aboutus_image_and_more	2026-01-28 09:12:54.367552+01
\.


--
-- Data for Name: website_aboutus; Type: TABLE DATA; Schema: public; Owner: wenanitmekazino
--

COPY public.website_aboutus (id, content, created_at, updated_at, core_values, image, mission_statement, title, vision_statement) FROM stdin;
1	We provide dependable commercial cleaning with a focus on consistency, safety, and attention to detail.\r\nWhat we do\r\n\r\nWe clean offices, retail spaces, and shared properties with flexible schedules and clear communication.\r\nOur approach\r\n\r\n    Site assessment and tailored checklist\r\n    Trained staff and standard operating procedures\r\n    Quality checks and continuous improvement\r\n\r\nWhy clients choose us\r\n\r\n    Reliable scheduling and transparent pricing\r\n    Professional equipment and supplies\r\n    Insured and accountable team	2026-01-28 09:26:48.746624+01	2026-01-28 09:32:41.882908+01				About Us	
\.


--
-- Data for Name: website_careers; Type: TABLE DATA; Schema: public; Owner: wenanitmekazino
--

COPY public.website_careers (id, "position", description, requirements, is_active, posted_at) FROM stdin;
\.


--
-- Data for Name: website_companyaddress; Type: TABLE DATA; Schema: public; Owner: wenanitmekazino
--

COPY public.website_companyaddress (id, company_name, description, address_line_1, address_line_2, city, state, postal_code, country, email, phone, vat_number, reg_number, contact_person) FROM stdin;
1	Nebsy Cleaning		8-365 Pioneer Dr		Kitchener	Ontario	N2P2A6	Canada	ruthyosief@yahoo.com	+1 (519) 918-6992			Ruth Yosief
\.


--
-- Data for Name: website_contactmessage; Type: TABLE DATA; Schema: public; Owner: wenanitmekazino
--

COPY public.website_contactmessage (id, name, email, phone, company, subject, message, created_at, is_processed) FROM stdin;
1	isaak	isaakyosief@proton.me	+3161058726	JI	Testibg	asdrerr	2026-01-26 20:39:34.228839+01	t
2	Isaak	isaakyosief@proton.me				We need cleaning	2026-01-28 10:05:09.463623+01	f
3	Isaak	isaakyosief@proton.me				we need cleaning	2026-01-28 10:06:15.307455+01	f
4	Isaak	isaakyosief@proton.me				test cleaning	2026-01-28 10:26:53.595914+01	f
5	Isaak	isaakyosief@proton.me			cleaners needed	test cleaning	2026-01-28 10:29:30.448572+01	f
6	Isaak	isaakyosief@proton.me			cleaning service	we need commercial cleaning service	2026-01-28 10:41:50.224665+01	f
7	Isaak	isaakyosief@proton.me				we need more cleaning services	2026-01-28 11:00:33.310682+01	f
8	Isaak	isaakyosief@proton.me			cleaning service	how much do you charge?	2026-01-28 17:08:08.560283+01	f
\.


--
-- Data for Name: website_faqitem; Type: TABLE DATA; Schema: public; Owner: wenanitmekazino
--

COPY public.website_faqitem (id, question, answer, sort_order, is_active) FROM stdin;
2	Do you have experience	plenty	0	t
1	How much do you charge?	negotiable.	0	t
\.


--
-- Data for Name: website_service; Type: TABLE DATA; Schema: public; Owner: wenanitmekazino
--

COPY public.website_service (id, title, short_description, description, is_featured, sort_order, is_active) FROM stdin;
1	Medical cleaning	we clean labs	We have done this before.	t	2	t
3	Residential	we do this too	happy customers	t	3	t
2	Commercial cleaning	we clean commercial places	We do it so good. Yes.	t	1	t
\.


--
-- Data for Name: website_socialmedia; Type: TABLE DATA; Schema: public; Owner: wenanitmekazino
--

COPY public.website_socialmedia (id, name, url) FROM stdin;
1	TikTok	https://www.tiktok.com/@ruthyopro
\.


--
-- Data for Name: website_testimonial; Type: TABLE DATA; Schema: public; Owner: wenanitmekazino
--

COPY public.website_testimonial (id, client_name, title, company, image, content, rating, created_at, website, is_active, sort_order) FROM stdin;
5	Joythi Kumar	Owner	Kumar Inc		"Reliable and trustworthy cleaning service. Great value for money and fantastic results!"	4	2026-01-27 16:30:32.775073+01	\N	t	3
4	Sarah Gofar	Manager	Gofar Tech		"Amazing attention to detail. My home has never looked better. Will definitely use again!"	5	2026-01-27 16:29:30.35578+01	\N	t	2
3	Tom Jansen	COO	Jansen Fruits		"Excellent service! The cleaning team was professional and thorough. Highly recommended!"	5	2026-01-27 16:28:19.314381+01	\N	t	1
\.



--
-- Name: auth_group auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.auth_group
    ADD CONSTRAINT auth_group_name_key UNIQUE (name);


--
-- Name: auth_group_permissions auth_group_permissions_group_id_permission_id_0cd325b0_uniq; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_permission_id_0cd325b0_uniq UNIQUE (group_id, permission_id);


--
-- Name: auth_group_permissions auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_group auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.auth_group
    ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);


--
-- Name: auth_permission auth_permission_content_type_id_codename_01ab375a_uniq; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_codename_01ab375a_uniq UNIQUE (content_type_id, codename);


--
-- Name: auth_permission auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups auth_user_groups_user_id_group_id_94350c0c_uniq; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_group_id_94350c0c_uniq UNIQUE (user_id, group_id);


--
-- Name: auth_user_user_permissions auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_permission_id_14a6b632_uniq; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_permission_id_14a6b632_uniq UNIQUE (user_id, permission_id);


--
-- Name: django_admin_log django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);


--
-- Name: django_content_type django_content_type_app_label_model_76bd3d3b_uniq; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.django_content_type
    ADD CONSTRAINT django_content_type_app_label_model_76bd3d3b_uniq UNIQUE (app_label, model);


--
-- Name: django_content_type django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.django_content_type
    ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);


--
-- Name: django_migrations django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.django_migrations
    ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id);


--
-- Name: website_aboutus website_aboutus_pkey; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.website_aboutus
    ADD CONSTRAINT website_aboutus_pkey PRIMARY KEY (id);


--
-- Name: website_careers website_careers_pkey; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.website_careers
    ADD CONSTRAINT website_careers_pkey PRIMARY KEY (id);


--
-- Name: website_companyaddress website_companyaddress_pkey; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.website_companyaddress
    ADD CONSTRAINT website_companyaddress_pkey PRIMARY KEY (id);


--
-- Name: website_contactmessage website_contactmessage_pkey; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.website_contactmessage
    ADD CONSTRAINT website_contactmessage_pkey PRIMARY KEY (id);


--
-- Name: website_faqitem website_faqitem_pkey; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.website_faqitem
    ADD CONSTRAINT website_faqitem_pkey PRIMARY KEY (id);


--
-- Name: website_service website_service_pkey; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.website_service
    ADD CONSTRAINT website_service_pkey PRIMARY KEY (id);


--
-- Name: website_socialmedia website_socialmedia_name_key; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.website_socialmedia
    ADD CONSTRAINT website_socialmedia_name_key UNIQUE (name);


--
-- Name: website_socialmedia website_socialmedia_pkey; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.website_socialmedia
    ADD CONSTRAINT website_socialmedia_pkey PRIMARY KEY (id);


--
-- Name: website_testimonial website_testimonial_pkey; Type: CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.website_testimonial
    ADD CONSTRAINT website_testimonial_pkey PRIMARY KEY (id);


--
-- Name: auth_group_name_a6ea08ec_like; Type: INDEX; Schema: public; Owner: wenanitmekazino
--

CREATE INDEX auth_group_name_a6ea08ec_like ON public.auth_group USING btree (name varchar_pattern_ops);


--
-- Name: auth_group_permissions_group_id_b120cbf9; Type: INDEX; Schema: public; Owner: wenanitmekazino
--

CREATE INDEX auth_group_permissions_group_id_b120cbf9 ON public.auth_group_permissions USING btree (group_id);


--
-- Name: auth_group_permissions_permission_id_84c5c92e; Type: INDEX; Schema: public; Owner: wenanitmekazino
--

CREATE INDEX auth_group_permissions_permission_id_84c5c92e ON public.auth_group_permissions USING btree (permission_id);


--
-- Name: auth_permission_content_type_id_2f476e4b; Type: INDEX; Schema: public; Owner: wenanitmekazino
--

CREATE INDEX auth_permission_content_type_id_2f476e4b ON public.auth_permission USING btree (content_type_id);


--
-- Name: auth_user_groups_group_id_97559544; Type: INDEX; Schema: public; Owner: wenanitmekazino
--

CREATE INDEX auth_user_groups_group_id_97559544 ON public.auth_user_groups USING btree (group_id);


--
-- Name: auth_user_groups_user_id_6a12ed8b; Type: INDEX; Schema: public; Owner: wenanitmekazino
--

CREATE INDEX auth_user_groups_user_id_6a12ed8b ON public.auth_user_groups USING btree (user_id);


--
-- Name: auth_user_user_permissions_permission_id_1fbb5f2c; Type: INDEX; Schema: public; Owner: wenanitmekazino
--

CREATE INDEX auth_user_user_permissions_permission_id_1fbb5f2c ON public.auth_user_user_permissions USING btree (permission_id);


--
-- Name: auth_user_user_permissions_user_id_a95ead1b; Type: INDEX; Schema: public; Owner: wenanitmekazino
--

CREATE INDEX auth_user_user_permissions_user_id_a95ead1b ON public.auth_user_user_permissions USING btree (user_id);


--
-- Name: django_admin_log_content_type_id_c4bce8eb; Type: INDEX; Schema: public; Owner: wenanitmekazino
--

CREATE INDEX django_admin_log_content_type_id_c4bce8eb ON public.django_admin_log USING btree (content_type_id);


--
-- Name: django_admin_log_user_id_c564eba6; Type: INDEX; Schema: public; Owner: wenanitmekazino
--

CREATE INDEX django_admin_log_user_id_c564eba6 ON public.django_admin_log USING btree (user_id);


--
-- Name: website_socialmedia_name_34836fea_like; Type: INDEX; Schema: public; Owner: wenanitmekazino
--

CREATE INDEX website_socialmedia_name_34836fea_like ON public.website_socialmedia USING btree (name varchar_pattern_ops);


--
-- Name: auth_group_permissions auth_group_permissio_permission_id_84c5c92e_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissio_permission_id_84c5c92e_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_group_permissions auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_b120cbf9_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_permission auth_permission_content_type_id_2f476e4b_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_2f476e4b_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups auth_user_groups_group_id_97559544_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_group_id_97559544_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups auth_user_groups_user_id_6a12ed8b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_6a12ed8b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log django_admin_log_content_type_id_c4bce8eb_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_content_type_id_c4bce8eb_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_log django_admin_log_user_id_c564eba6_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: wenanitmekazino
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_user_id_c564eba6_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
--

