woofwalkdb.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 16.3
-- Dumped by pg_dump version 16.3 (Debian 16.3-1.pgdg120+1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

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

CREATE TABLE public.dogs (
    id bigint NOT NULL,
    age character varying(255) NOT NULL,
    breed character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    photo character varying(255),
    sex character varying(255) NOT NULL,
    size character varying(255) NOT NULL,
    user_id bigint NOT NULL,
    CONSTRAINT dogs_age_check CHECK (((age)::text = ANY ((ARRAY['PUPPY'::character varying, 'YOUNG'::character varying, 'ADULT'::character varying, 'SENIOR'::character varying])::text[]))),
    CONSTRAINT dogs_breed_check CHECK (((breed)::text = ANY ((ARRAY['AFGHAN_HOUND'::character varying, 'AIREDALE_TERRIER'::character varying, 'AKITA'::character varying, 'ALASKAN_MALAMUTE'::character varying, 'AMERICAN_BULLDOG'::character varying, 'AMERICAN_PIT_BULL_TERRIER'::character varying, 'AMERICAN_STAFFORDSHIRE_TERRIER'::character varying, 'AUSTRALIAN_CATTLE_DOG'::character varying, 'AUSTRALIAN_SHEPHERD'::character varying, 'BASENJI'::character varying, 'BASSET_HOUND'::character varying, 'BEAGLE'::character varying, 'BELGIAN_MALINOIS'::character varying, 'BERNESE_MOUNTAIN_DOG'::character varying, 'BICHON_FRISE'::character varying, 'BLOODHOUND'::character varying, 'BORDER_COLLIE'::character varying, 'BORDER_TERRIER'::character varying, 'BOSTON_TERRIER'::character varying, 'BOXER'::character varying, 'BULLDOG'::character varying, 'BULLMASTIFF'::character varying, 'CAIRN_TERRIER'::character varying, 'CANE_CORSO'::character varying, 'CAVALIER_KING_CHARLES_SPANIEL'::character varying, 'CHIHUAHUA'::character varying, 'CHINESE_SHAR_PEI'::character varying, 'CHOW_CHOW'::character varying, 'COCKER_SPANIEL'::character varying, 'COLLIE'::character varying, 'DACHSHUND'::character varying, 'DALMATIAN'::character varying, 'DOBERMAN_PINSCHER'::character varying, 'ENGLISH_SETTER'::character varying, 'ENGLISH_SPRINGER_SPANIEL'::character varying, 'FRENCH_BULLDOG'::character varying, 'GERMAN_SHEPHERD'::character varying, 'GERMAN_SHORTHAIRED_POINTER'::character varying, 'GOLDEN_RETRIEVER'::character varying, 'GREAT_DANE'::character varying, 'GREAT_PYRENEES'::character varying, 'GREYHOUND'::character varying, 'HAVANESE'::character varying, 'IRISH_SETTER'::character varying, 'IRISH_WOLFHOUND'::character varying, 'JACK_RUSSELL_TERRIER'::character varying, 'JAPANESE_CHIN'::character varying, 'LABRADOR_RETRIEVER'::character varying, 'LHASA_APSO'::character varying, 'MALTESE'::character varying, 'MASTIFF'::character varying, 'MINIATURE_SCHNAUZER'::character varying, 'NEWFOUNDLAND'::character varying, 'NORWEGIAN_ELKHOUND'::character varying, 'PAPILLON'::character varying, 'PEKINGESE'::character varying, 'PEMBROKE_WELSH_CORGI'::character varying, 'PIT_BULL'::character varying, 'POINTER'::character varying, 'POMERANIAN'::character varying, 'POODLE'::character varying, 'PORTUGUESE_WATER_DOG'::character varying, 'PUG'::character varying, 'ROTTWEILER'::character varying, 'SAINT_BERNARD'::character varying, 'SAMOYED'::character varying, 'SCHIPPERKE'::character varying, 'SCOTTISH_TERRIER'::character varying, 'SHETLAND_SHEEPDOG'::character varying, 'SHIH_TZU'::character varying, 'SIBERIAN_HUSKY'::character varying, 'STAFFORDSHIRE_BULL_TERRIER'::character varying, 'STANDARD_SCHNAUZER'::character varying, 'TIBETAN_TERRIER'::character varying, 'TOY_POODLE'::character varying, 'VIZSLA'::character varying, 'WEIMARANER'::character varying, 'WELSH_TERRIER'::character varying, 'WEST_HIGHLAND_WHITE_TERRIER'::character varying, 'WHIPPET'::character varying, 'YORKSHIRE_TERRIER'::character varying, 'MIXED'::character varying, 'OTHER'::character varying])::text[]))),
    CONSTRAINT dogs_sex_check CHECK (((sex)::text = ANY ((ARRAY['MALE'::character varying, 'FEMALE'::character varying])::text[]))),
    CONSTRAINT dogs_size_check CHECK (((size)::text = ANY ((ARRAY['SMALL'::character varying, 'MEDIUM'::character varying, 'LARGE'::character varying])::text[])))
);


ALTER TABLE public.dogs OWNER TO postgres;

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

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


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

CREATE TABLE public.events (
    id bigint NOT NULL,
    name character varying(255) NOT NULL,
    placeid bigint NOT NULL
);


ALTER TABLE public.events OWNER TO postgres;

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

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


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

CREATE TABLE public.group_chat (
    id bigint NOT NULL,
    name character varying(255) NOT NULL
);


ALTER TABLE public.group_chat OWNER TO postgres;

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

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


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

CREATE TABLE public.group_chat_members (
    group_chat_id bigint NOT NULL,
    user_id bigint NOT NULL
);


ALTER TABLE public.group_chat_members OWNER TO postgres;

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

CREATE TABLE public.group_message (
    id bigint NOT NULL,
    content character varying(255) NOT NULL,
    sender character varying(255) NOT NULL,
    "timestamp" bigint NOT NULL,
    group_chat_id bigint NOT NULL
);


ALTER TABLE public.group_message OWNER TO postgres;

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

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


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

CREATE TABLE public.invitations (
    id bigint NOT NULL,
    receiver character varying(255) NOT NULL,
    sender character varying(255) NOT NULL,
    status character varying(255) NOT NULL
);


ALTER TABLE public.invitations OWNER TO postgres;

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

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


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

CREATE TABLE public.location_images (
    location_id bigint NOT NULL,
    image_url character varying(255)
);


ALTER TABLE public.location_images OWNER TO postgres;

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

CREATE TABLE public.locations (
    id bigint NOT NULL,
    category character varying(255) NOT NULL,
    date character varying(255),
    description character varying(255),
    latitude double precision NOT NULL,
    longitude double precision NOT NULL,
    name character varying(255) NOT NULL,
    rating double precision,
    rating_count integer,
    CONSTRAINT locations_category_check CHECK (((category)::text = ANY ((ARRAY['PARK'::character varying, 'BEACH'::character varying, 'LAKE'::character varying, 'FOREST'::character varying, 'MOUNTAIN'::character varying, 'URBAN'::character varying, 'RIVER'::character varying, 'CAFE'::character varying, 'RESTAURANT'::character varying, 'MEADOW'::character varying, 'OTHER'::character varying, 'EVENT'::character varying])::text[])))
);


ALTER TABLE public.locations OWNER TO postgres;

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

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


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

CREATE TABLE public.message (
    id bigint NOT NULL,
    content character varying(255) NOT NULL,
    recipient character varying(255) NOT NULL,
    sender character varying(255) NOT NULL,
    "timestamp" bigint NOT NULL,
    group_chat_id bigint,
    private_chat_id bigint
);


ALTER TABLE public.message OWNER TO postgres;

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

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


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

CREATE TABLE public.private_chat (
    id bigint NOT NULL
);


ALTER TABLE public.private_chat OWNER TO postgres;

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

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


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

CREATE TABLE public.private_chat_participants (
    private_chat_id bigint NOT NULL,
    user_id bigint NOT NULL
);


ALTER TABLE public.private_chat_participants OWNER TO postgres;

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

CREATE TABLE public.ratings (
    id bigint NOT NULL,
    opinion character varying(255),
    rating integer NOT NULL,
    location_id bigint NOT NULL,
    user_id bigint NOT NULL
);


ALTER TABLE public.ratings OWNER TO postgres;

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

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


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

CREATE TABLE public.user_events (
    user_id bigint NOT NULL,
    event_id bigint NOT NULL
);


ALTER TABLE public.user_events OWNER TO postgres;

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

CREATE TABLE public.user_friends (
    user_id bigint NOT NULL,
    friend_id bigint NOT NULL
);


ALTER TABLE public.user_friends OWNER TO postgres;

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

CREATE TABLE public.users (
    id bigint NOT NULL,
    address character varying(255),
    email character varying(255) NOT NULL,
    nickname character varying(255) NOT NULL,
    phone_number character varying(255),
    profile_picture_id character varying(255),
    sub character varying(255) NOT NULL
);


ALTER TABLE public.users OWNER TO postgres;

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

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


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

COPY public.dogs (id, age, breed, name, photo, sex, size, user_id) FROM stdin;
1	SENIOR	AKITA	Artur	\N	FEMALE	SMALL	2
2	PUPPY	MIXED	Artur60	1cde3c2d-4869-4acb-bd33-5815c5ae1fdd	FEMALE	SMALL	1
3	SENIOR	AMERICAN_BULLDOG	BUREK	\N	MALE	LARGE	2
4	SENIOR	AMERICAN_BULLDOG	BUREK	\N	MALE	LARGE	2
5	SENIOR	AMERICAN_BULLDOG	BUREK	\N	MALE	LARGE	2
6	SENIOR	AMERICAN_BULLDOG	BUREK	\N	MALE	LARGE	2
7	SENIOR	AMERICAN_BULLDOG	BUREK	\N	MALE	LARGE	2
8	PUPPY	AIREDALE_TERRIER	Rr	\N	MALE	MEDIUM	2
9	YOUNG	SHETLAND_SHEEPDOG	Artur	\N	MALE	MEDIUM	5
\.


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

COPY public.events (id, name, placeid) FROM stdin;
1	Super miejsce	1
2	Dog Show	25
\.


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

COPY public.group_chat (id, name) FROM stdin;
2	Grupa au
3	Grpa
\.


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

COPY public.group_chat_members (group_chat_id, user_id) FROM stdin;
2	3
2	2
2	1
3	1
3	2
\.


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

COPY public.group_message (id, content, sender, "timestamp", group_chat_id) FROM stdin;
1	Elo elo	auth0|66563f84a6666512e389a436	1719948146340	2
2	Siema	auth0|66563f84a6666512e389a436	1719952626266	2
3	Siema	auth0|66563f84a6666512e389a436	1719952645982	2
4	Yo	auth0|66563f84a6666512e389a436	1719952695235	2
5	Ziema	auth0|66563f84a6666512e389a436	1719952760808	2
6	yoyo	auth0|6655a580a6666512e388fdeb	1719952770141	2
7	Co tam	auth0|66563f84a6666512e389a436	1719952848710	2
8	123	auth0|66563f84a6666512e389a436	1719953962740	2
9	345	auth0|6655a580a6666512e388fdeb	1719953969372	2
10	Tes test	auth0|66563f84a6666512e389a436	1719953985928	2
11	tescik	auth0|6655a580a6666512e388fdeb	1719953993080	2
12	hej	auth0|6655a580a6666512e388fdeb	1719954485315	2
13	Co tamm	auth0|66563f84a6666512e389a436	1719954493709	2
14	Test	auth0|66563f84a6666512e389a436	1719956455222	2
15	Siema	auth0|66563f84a6666512e389a436	1719956481983	2
16	Test	auth0|66563f84a6666512e389a436	1719956494955	2
17	elo elo tu maciek	auth0|6679f5df2688557f5d2b65d9	1719957459670	2
18	Co tam maciek	auth0|66563f84a6666512e389a436	1719957471646	2
19	ruh horzuw au	auth0|6655a580a6666512e388fdeb	1719957486683	2
20	Czesc	auth0|66563f84a6666512e389a436	1720105600356	3
21	test	auth0|6655a580a6666512e388fdeb	1720105643573	3
\.


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

COPY public.invitations (id, receiver, sender, status) FROM stdin;
\.


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

COPY public.location_images (location_id, image_url) FROM stdin;
19	13f5e8bb-eaa6-45d2-8cf2-6cc93f58b549
5	19508d07-5bc4-4b55-89ed-83f95d8aaa8d
7	59ffbb0a-820f-4c96-bfbe-7b9c4dca3a0f
7	c6b27f15-8776-4e7c-a0c8-97d3f68294d9
23	be137299-274e-4be6-8fa4-3df66f3f9f31
22	5d4ba101-9641-4074-b886-be37ad00e0b1
17	faa4babf-08f3-432f-85c1-cab47966bc61
21	a7415ade-d803-4bdd-888f-5845efc3864d
16	ac94be5b-68cf-4760-8271-5ed865282532
8	a2db999a-cacb-4fa9-a3d5-a957748b4e14
24	40985319-ddf8-4692-90a0-96282a773715
24	fe7f8052-89f2-4d7f-96a7-8ed5a5b3b59e
10	c0425d61-8833-4f78-b8b9-50185ca1a6fb
9	6628a7e4-fffd-4a01-9a3d-535519ce378d
9	d498558e-718d-442c-8a55-4787aa8fafec
6	630ee065-0dba-4b7c-bc7b-4af53480822d
6	5bf4ba1a-fcaf-46e6-a730-77321e4ed569
6	b15664ef-38a6-4dea-b86f-0264d6ce9e67
12	4b8dff38-e98d-4a8f-87bd-45e53191cea6
14	158b79df-7f45-40cb-9cab-119b26d0f97a
18	be0790a8-e0ff-4765-8776-c08763c1f364
26	c914f8a2-a217-44b3-a0ff-2c6abb0993fc
27	778bf3b3-743c-42a7-b0a3-118a8f982e56
28	4f8b5fc0-447c-451d-bd5f-230b30abda6a
\.


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

COPY public.locations (id, category, date, description, latitude, longitude, name, rating, rating_count) FROM stdin;
13	OTHER	\N	Dog-friendly place, distinguished by our sticker!	50.04415884447643	19.947668742388487	Goldsmith Workshop Krzysztof Bocheński	0	0
19	PARK	\N	Vast space for leisurely walks. Watch out for other dog owners.	50.057663430187766	19.905380699783564	Krakowskie Błonia in Kraków	4	1
5	PARK	\N	A dog run is a secure, fenced area where dogs can exercise, play, and socialize off-leash.	50.07368215770724	19.89681640639901	Dog run	5	1
7	FOREST	\N	An ideal spot for a walk with your dog, offering extensive trails and lush greenery.	50.054781457153084	19.852742347866297	Wolski Forest	5	1
23	CAFE	\N	Charming café with delicious coffee and cozy atmosphere.	50.07793352268336	19.91741208359599	Castor Coffee&Lunch	3	1
22	PARK	\N	A dog run is a secure, fenced area where dogs can exercise, play, and socialize off-leash.	50.089806331316026	19.918790068477392	Dog run	5	1
15	RESTAURANT	\N	A completely dog-friendly place distinguished by our sticker :)	50.046678691507225	19.951388631016016	\nBistro Boulevard 11	4	1
17	CAFE	\N	A place friendly to all dogs. Size and breed don't matter. Every dog can expect a warm welcome and a bowl of water.	50.04962927547528	19.939783718436956	"Spółdzielnia Ogniwo"	4	1
20	RESTAURANT	\N	A place friendly to all well-behaved dogs.	50.05642443668708	19.906249400228262	Any Time	2.5	2
25	EVENT	06-07-2024	dog show with free entry, amazing prizes and many other attractions!	50.05906547840808	19.93745991960168	Dog Show	0	0
21	URBAN	\N	Dog-friendly museum welcomes dogs.	50.058953434820324	19.92565518245101	Stained Glass Museum	5	1
16	URBAN	\N	The fitness club offers classes for people, while dogs can stay at the reception during this time. In the summer, spontaneous running sessions with dogs are organized. Club members also arrange weekend trips with dogs, coordinated by the club's staff.	50.04960864755376	19.94233986362815	Multi Fitness	4	1
8	URBAN	\N	\nDog-friendly shopping mall, but some stores may have their own policies.	50.02729191753102	19.949411172419786	Bonarka shopping mall	4	1
24	FOREST	\N	Forest offers serene woodland trails, perfect for peaceful walks with your dog	50.010969587538156	19.91392621770501	Las Borkowski	5	1
10	RESTAURANT	\N	A place friendly to all well-behaved dogs :) For large dogs and those considered aggressive breeds, please bring a muzzle :)	50.008452968157705	19.93434889242053	La Forchetta	4	1
9	PARK	\N	A dog park is a designated fenced area where dogs can play off-leash, socialize with other dogs, and exercise freely in a safe environment.	50.00387240656146	19.938300121575594	Dog park	5	1
6	PARK	\N	A great place to take dog for a walk	50.03513353699279	19.911404605954885	Zakrzowek Park	3	1
12	PARK	\N	A dog run is a secure, fenced area where dogs can exercise, play, and socialize off-leash.	50.03236627627042	19.92893686518073	dog run	4	1
14	RESTAURANT	\N	Place friendly only to small dogs.	50.04508069137415	19.952246602624655	Chili Chili	5	1
18	RESTAURANT	\N	A place friendly to all well-behaved dogs. Despite the small space, there's room for every pup and a bowl of fresh water - small for small dogs and large for big dogs.	50.050289837065584	19.94057698175311	Hummus Amamamusi	4	1
26	URBAN	\N	aviation museum, amazing place to people, and dogs which love to travel with plane! History associated with this place is hard to describe	50.07430516359603	19.990754071623087	Aviation musem	5	1
27	URBAN	\N	NIE BYLES W MIELNIE JESLI NIE BYLES W BAJCE	54.20352638907518	16.035744175314903	KLUB BAJAK MIELNO	5	1
28	MOUNTAIN	\N	calkiem dobre w smaku	49.193300180481884	19.939641058444977	tatry	5	1
29	OTHER	\N	Boisko sportowe ze sztuczna trawa	52.45704406606342	16.923708077520132	Boisko im. Dzordzo5	0	0
\.


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

COPY public.message (id, content, recipient, sender, "timestamp", group_chat_id, private_chat_id) FROM stdin;
7	Siema	auth0|6655a580a6666512e388fdeb	auth0|66563f84a6666512e389a436	1719830848371	\N	1
8	Elo elo	auth0|6655a580a6666512e388fdeb	auth0|66563f84a6666512e389a436	1719956112774	\N	1
9	test est	auth0|66563f84a6666512e389a436	auth0|6655a580a6666512e388fdeb	1719956117953	\N	1
10	Spam	auth0|6655a580a6666512e388fdeb	auth0|66563f84a6666512e389a436	1719956283270	\N	1
11	Au	auth0|6655a580a6666512e388fdeb	auth0|66563f84a6666512e389a436	1719956285649	\N	1
12	Cho na spacer	auth0|6655a580a6666512e388fdeb	auth0|66563f84a6666512e389a436	1719956291780	\N	1
13	Jest maciek w domu?	auth0|6655a580a6666512e388fdeb	auth0|66563f84a6666512e389a436	1719956296964	\N	1
14	Halo	auth0|6655a580a6666512e388fdeb	auth0|66563f84a6666512e389a436	1719956444862	\N	1
15	nie ma macka w domu	auth0|66563f84a6666512e389a436	auth0|6655a580a6666512e388fdeb	1720104354470	\N	1
16	Jak to nie ma	auth0|6655a580a6666512e388fdeb	auth0|66563f84a6666512e389a436	1720104393290	\N	1
17	Widze ze gra w lige	auth0|6655a580a6666512e388fdeb	auth0|66563f84a6666512e389a436	1720104397925	\N	1
\.


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

COPY public.private_chat (id) FROM stdin;
1
\.


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

COPY public.private_chat_participants (private_chat_id, user_id) FROM stdin;
1	2
1	1
\.


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

COPY public.ratings (id, opinion, rating, location_id, user_id) FROM stdin;
10	Great place for a walk !	4	19	5
11	\N	5	5	5
12	Lovely forest !	5	7	5
13	Good food but really pricy!	3	23	5
14	My favourite park to go to !	5	22	5
15	closed :(	1	20	5
16	Amazing	4	17	5
17	nice place etc	4	20	2
18	Amazing art!	5	21	2
19	Nice gym with possibility to go with dog!	4	16	2
20	Too much people	4	8	2
21	Amazing air, lots of friendly people!	5	24	2
22	Amazing food, also for dog!	4	10	2
23	Amazing place	5	9	2
24	Very beautiful place, but a lot of people.	3	6	2
25	amazing, extra super	4	12	2
26	Spicy food for me and dog	5	14	2
27	delicious food!	4	15	2
28	Amazing, delicious food	4	18	2
29	FULL AGREEMENT WITH AUTHOR	5	26	2
30	DJ HEJZEJ 	5	27	2
31	10/10 recommend	5	28	5
\.


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

COPY public.user_events (user_id, event_id) FROM stdin;
1	1
2	1
5	1
2	2
\.


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

COPY public.user_friends (user_id, friend_id) FROM stdin;
1	2
2	1
2	3
3	2
2	4
4	2
2	5
5	2
1	5
5	1
\.


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

COPY public.users (id, address, email, nickname, phone_number, profile_picture_id, sub) FROM stdin;
3	\N	maciek@gmail.com	maciek	\N	2201f7f6-e2d7-46e2-be40-485395e6db6e	auth0|6679f5df2688557f5d2b65d9
4	\N	test@gmail.com	test	\N	b8f2318b-b5af-4235-984c-e46c735debf6	auth0|66675e12cedc89aa7e6a2d04
5	\N	nieckulawaliwiadro@gmail.com	nieckulawaliwiadro	555-555-555	4786ae27-7886-436b-8360-26de6e10a443	auth0|66621a64245859180dc30dfa
2	Krakow, Rostafinskiego 6	maciekjur123@gmail.com	maciekjur123	884 039 391	b0b838ce-03ce-4d54-81fe-617d011413dd	auth0|6655a580a6666512e388fdeb
1	Pustynna 17A	pz@gmail.com	pz	789013666	296a9d73-a1a4-4a77-af70-c28689ff6b9e	auth0|66563f84a6666512e389a436
\.


--
-- Name: dogs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.dogs_id_seq', 9, true);


--
-- Name: events_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.events_id_seq', 2, true);


--
-- Name: group_chat_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.group_chat_id_seq', 3, true);


--
-- Name: group_message_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.group_message_id_seq', 21, true);


--
-- Name: invitations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.invitations_id_seq', 5, true);


--
-- Name: locations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.locations_id_seq', 29, true);


--
-- Name: message_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.message_id_seq', 17, true);


--
-- Name: private_chat_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.private_chat_id_seq', 1, true);


--
-- Name: ratings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.ratings_id_seq', 31, true);


--
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.users_id_seq', 5, true);


--
-- Name: dogs dogs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.dogs
    ADD CONSTRAINT dogs_pkey PRIMARY KEY (id);


--
-- Name: events events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.events
    ADD CONSTRAINT events_pkey PRIMARY KEY (id);


--
-- Name: group_chat_members group_chat_members_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_chat_members
    ADD CONSTRAINT group_chat_members_pkey PRIMARY KEY (group_chat_id, user_id);


--
-- Name: group_chat group_chat_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_chat
    ADD CONSTRAINT group_chat_pkey PRIMARY KEY (id);


--
-- Name: group_message group_message_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_message
    ADD CONSTRAINT group_message_pkey PRIMARY KEY (id);


--
-- Name: invitations invitations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invitations
    ADD CONSTRAINT invitations_pkey PRIMARY KEY (id);


--
-- Name: locations locations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.locations
    ADD CONSTRAINT locations_pkey PRIMARY KEY (id);


--
-- Name: message message_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.message
    ADD CONSTRAINT message_pkey PRIMARY KEY (id);


--
-- Name: private_chat_participants private_chat_participants_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.private_chat_participants
    ADD CONSTRAINT private_chat_participants_pkey PRIMARY KEY (private_chat_id, user_id);


--
-- Name: private_chat private_chat_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.private_chat
    ADD CONSTRAINT private_chat_pkey PRIMARY KEY (id);


--
-- Name: ratings ratings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.ratings
    ADD CONSTRAINT ratings_pkey PRIMARY KEY (id);


--
-- Name: users uk6dotkott2kjsp8vw4d0m25fb7; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT uk6dotkott2kjsp8vw4d0m25fb7 UNIQUE (email);


--
-- Name: users ukmtuf0eryuefwgkh9e3m5jdn8t; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT ukmtuf0eryuefwgkh9e3m5jdn8t UNIQUE (sub);


--
-- Name: events ukn4yvotmsa9412ywsvgwujhuk; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.events
    ADD CONSTRAINT ukn4yvotmsa9412ywsvgwujhuk UNIQUE (placeid);


--
-- Name: user_events user_events_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_events
    ADD CONSTRAINT user_events_pkey PRIMARY KEY (user_id, event_id);


--
-- Name: user_friends user_friends_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_friends
    ADD CONSTRAINT user_friends_pkey PRIMARY KEY (user_id, friend_id);


--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- Name: location_images fk10mqrg01s8jam7j9x6wfo02ix; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.location_images
    ADD CONSTRAINT fk10mqrg01s8jam7j9x6wfo02ix FOREIGN KEY (location_id) REFERENCES public.locations(id);


--
-- Name: user_friends fk11y5boh1e7gh60rdqixyetv3x; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_friends
    ADD CONSTRAINT fk11y5boh1e7gh60rdqixyetv3x FOREIGN KEY (friend_id) REFERENCES public.users(id);


--
-- Name: private_chat_participants fk1njuvbb8b9bag78xlrov7gxs7; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.private_chat_participants
    ADD CONSTRAINT fk1njuvbb8b9bag78xlrov7gxs7 FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: message fk4sxmsikwpltv6336dexn0j8e8; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.message
    ADD CONSTRAINT fk4sxmsikwpltv6336dexn0j8e8 FOREIGN KEY (private_chat_id) REFERENCES public.private_chat(id);


--
-- Name: group_chat_members fk5kyum8picuhaumu92gummgyi3; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_chat_members
    ADD CONSTRAINT fk5kyum8picuhaumu92gummgyi3 FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: message fk9k6vg7sks4wvy21qx5wrpi4m2; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.message
    ADD CONSTRAINT fk9k6vg7sks4wvy21qx5wrpi4m2 FOREIGN KEY (group_chat_id) REFERENCES public.group_chat(id);


--
-- Name: ratings fkb3354ee2xxvdrbyq9f42jdayd; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.ratings
    ADD CONSTRAINT fkb3354ee2xxvdrbyq9f42jdayd FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: ratings fkdogc3w4gk6rtbuej6i4ijb511; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.ratings
    ADD CONSTRAINT fkdogc3w4gk6rtbuej6i4ijb511 FOREIGN KEY (location_id) REFERENCES public.locations(id);


--
-- Name: user_events fkg3rv1yxrs56ohyn30rlt7vum7; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_events
    ADD CONSTRAINT fkg3rv1yxrs56ohyn30rlt7vum7 FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: group_chat_members fkhd5exxa52jmgofefef2bidgur; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_chat_members
    ADD CONSTRAINT fkhd5exxa52jmgofefef2bidgur FOREIGN KEY (group_chat_id) REFERENCES public.group_chat(id);


--
-- Name: user_friends fkk08ugelrh9cea1oew3hgxryw2; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_friends
    ADD CONSTRAINT fkk08ugelrh9cea1oew3hgxryw2 FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: group_message fkolt7yw2cek9wtqlu5ne2j4ah2; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.group_message
    ADD CONSTRAINT fkolt7yw2cek9wtqlu5ne2j4ah2 FOREIGN KEY (group_chat_id) REFERENCES public.group_chat(id);


--
-- Name: user_events fkqh8jukuil4jkihri1o262hik7; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.user_events
    ADD CONSTRAINT fkqh8jukuil4jkihri1o262hik7 FOREIGN KEY (event_id) REFERENCES public.events(id);


--
-- Name: private_chat_participants fkqmkranmrtr2209kc76qebo9xa; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.private_chat_participants
    ADD CONSTRAINT fkqmkranmrtr2209kc76qebo9xa FOREIGN KEY (private_chat_id) REFERENCES public.private_chat(id);


--
-- Name: dogs fksk4f0m5le3o4n8mjugyribthu; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.dogs
    ADD CONSTRAINT fksk4f0m5le3o4n8mjugyribthu FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- PostgreSQL database dump complete
--