dumpfile.sql

--
-- PostgreSQL database dump
--

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

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: api_friend; Type: TABLE; Schema: public; Owner: smessal
--

CREATE TABLE public.api_friend (
    id bigint NOT NULL,
    friend_id bigint NOT NULL,
    user_id bigint NOT NULL,
    status character varying NOT NULL
);


ALTER TABLE public.api_friend OWNER TO smessal;

--
-- Name: api_friend_id_seq; Type: SEQUENCE; Schema: public; Owner: smessal
--

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


--
-- Name: api_game; Type: TABLE; Schema: public; Owner: smessal
--

CREATE TABLE public.api_game (
    id bigint NOT NULL,
    status character varying(12) NOT NULL,
    start_time timestamp with time zone NOT NULL,
    end_time timestamp with time zone,
    score_player1 integer NOT NULL,
    score_player2 integer NOT NULL,
    player1_id bigint NOT NULL,
    player2_id bigint NOT NULL,
    winner_id bigint
);


ALTER TABLE public.api_game OWNER TO smessal;

--
-- Name: api_game_id_seq; Type: SEQUENCE; Schema: public; Owner: smessal
--

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


--
-- Name: api_user; Type: TABLE; Schema: public; Owner: smessal
--

CREATE TABLE public.api_user (
    id bigint NOT NULL,
    username character varying(255),
    score integer NOT NULL,
    profile_picture character varying(100) NOT NULL,
    is_2fa boolean NOT NULL,
    password character varying(255) NOT NULL,
    created_at timestamp with time zone NOT NULL,
    updated_at timestamp with time zone NOT NULL,
    secret_2fa character varying(50)
);


ALTER TABLE public.api_user OWNER TO smessal;

--
-- Name: api_user_id_seq; Type: SEQUENCE; Schema: public; Owner: smessal
--

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


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

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


ALTER TABLE public.auth_group OWNER TO smessal;

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

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

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

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

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

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

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

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

CREATE TABLE public.auth_user (
    id integer NOT NULL,
    password character varying(128) NOT NULL,
    last_login timestamp with time zone,
    is_superuser boolean NOT NULL,
    username character varying(150) NOT NULL,
    first_name character varying(150) NOT NULL,
    last_name character varying(150) NOT NULL,
    email character varying(254) NOT NULL,
    is_staff boolean NOT NULL,
    is_active boolean NOT NULL,
    date_joined timestamp with time zone NOT NULL
);


ALTER TABLE public.auth_user OWNER TO smessal;

--
-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: smessal
--

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

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

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_id_seq; Type: SEQUENCE; Schema: public; Owner: smessal
--

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


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

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

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

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

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

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

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

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

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

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

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

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

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


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

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


ALTER TABLE public.django_session OWNER TO smessal;

--
-- Data for Name: api_friend; Type: TABLE DATA; Schema: public; Owner: smessal
--

COPY public.api_friend (id, friend_id, user_id, status) FROM stdin;
1	1	8	validated
2	3	8	validated
3	2	8	validated
4	5	8	validated
5	6	8	validated
6	7	8	validated
7	9	8	validated
8	4	8	pending
\.


--
-- Data for Name: api_game; Type: TABLE DATA; Schema: public; Owner: smessal
--

COPY public.api_game (id, status, start_time, end_time, score_player1, score_player2, player1_id, player2_id, winner_id) FROM stdin;
\.


--
-- Data for Name: api_user; Type: TABLE DATA; Schema: public; Owner: smessal
--

COPY public.api_user (id, username, score, profile_picture, is_2fa, password, created_at, updated_at, secret_2fa) FROM stdin;
1	jsauvage	0	profile_pictures/angel.png	f	pbkdf2_sha256$600000$gj4gPbB62UgU7p0dcbFzvt$zTOIWBNniPkGnUHYi3Kls6Cph/ysjESF2W6k45rf7dw=	2024-03-06 16:30:06.068974+00	2024-03-06 16:30:06.06899+00	\N
2	owae	0	profile_pictures/merlin.png	f	pbkdf2_sha256$600000$DazIC9fBQpXrdcz4BO2unU$yqJuaTHahOipT2MrVq5HsFJBn6HEHuLsbYQSZresA3I=	2024-03-06 16:31:35.533824+00	2024-03-06 16:31:35.533839+00	\N
3	rvincent	0	profile_pictures/dracula.png	f	pbkdf2_sha256$600000$esK0Fk5w6eB8gDmAZDwaZH$DEHriYLRvaX/mk+kqbOAoEltri/vNU5pJ5MsNEVkyoM=	2024-03-06 16:32:52.066185+00	2024-03-06 16:32:52.066202+00	\N
4	smessal	0	profile_pictures/king.png	f	pbkdf2_sha256$600000$56kkwqZBsReDZu8W766ouf$xSl6iyY5LUTfK41YMV4Z3+V/p8urhCFeK3rVQ3VXfa4=	2024-03-06 16:33:34.564598+00	2024-03-06 16:33:34.564609+00	\N
5	rvrignon	0	profile_pictures/scaph.png	f	pbkdf2_sha256$600000$MypBxJyXDbwBUvZYj4oOXh$FGX6G/Q8wST+3ug86LTJb1EblFMy/rb5qcu911RzkA4=	2024-03-06 16:34:40.225525+00	2024-03-06 16:34:40.225535+00	\N
6	ychibani	0	profile_pictures/devil.png	f	pbkdf2_sha256$600000$FbIHOpEsbyOG8SkdmekHlX$1S0OdCwD6MojVHlyGy0AtufewqnX0yLlSwD1C+qHmoU=	2024-03-06 16:35:50.308119+00	2024-03-06 16:35:50.308131+00	\N
7	yboudoui	0	profile_pictures/paul.png	f	pbkdf2_sha256$600000$r8IXnLG7wDIb54zwUJgD46$r/GDC12OnTjxqh7fD3Jj77/XoTG15BwZq3SyfkdCHjI=	2024-03-06 16:36:52.246997+00	2024-03-06 16:36:52.247008+00	\N
8	zelkass	0	profile_pictures/knight.png	f	pbkdf2_sha256$600000$rm7xZdIY7baWpxesGKcGnS$pTxp3CzfFpHQl7fR1RgaQrw7DGXjwDuPrfd0DfZI/D8=	2024-03-06 16:37:49.17527+00	2024-03-06 16:37:49.175287+00	\N
9	khuynh	0	profile_pictures/cleopatre.png	f	pbkdf2_sha256$600000$CaH9ippL4gxsJmomcA4LLh$wpUnq0T+ARXgtMnShb9ZMM3H3BPZo/kMODDVfi6PKCM=	2024-03-06 16:40:00.345539+00	2024-03-06 16:40:00.34555+00	\N
\.


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

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


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

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


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

COPY public.auth_permission (id, name, content_type_id, codename) FROM stdin;
1	Can add game	1	add_game
2	Can change game	1	change_game
3	Can delete game	1	delete_game
4	Can view game	1	view_game
5	Can add friend	2	add_friend
6	Can change friend	2	change_friend
7	Can delete friend	2	delete_friend
8	Can view friend	2	view_friend
9	Can add user	3	add_user
10	Can change user	3	change_user
11	Can delete user	3	delete_user
12	Can view user	3	view_user
13	Can add log entry	4	add_logentry
14	Can change log entry	4	change_logentry
15	Can delete log entry	4	delete_logentry
16	Can view log entry	4	view_logentry
17	Can add permission	5	add_permission
18	Can change permission	5	change_permission
19	Can delete permission	5	delete_permission
20	Can view permission	5	view_permission
21	Can add group	6	add_group
22	Can change group	6	change_group
23	Can delete group	6	delete_group
24	Can view group	6	view_group
25	Can add user	7	add_user
26	Can change user	7	change_user
27	Can delete user	7	delete_user
28	Can view user	7	view_user
29	Can add content type	8	add_contenttype
30	Can change content type	8	change_contenttype
31	Can delete content type	8	delete_contenttype
32	Can view content type	8	view_contenttype
33	Can add session	9	add_session
34	Can change session	9	change_session
35	Can delete session	9	delete_session
36	Can view session	9	view_session
\.


--
-- Data for Name: auth_user; Type: TABLE DATA; Schema: public; Owner: smessal
--

COPY public.auth_user (id, password, last_login, is_superuser, username, first_name, last_name, email, is_staff, is_active, date_joined) FROM stdin;
\.


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

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

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

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

COPY public.django_content_type (id, app_label, model) FROM stdin;
1	api	game
2	api	friend
3	api	user
4	admin	logentry
5	auth	permission
6	auth	group
7	auth	user
8	contenttypes	contenttype
9	sessions	session
\.


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

COPY public.django_migrations (id, app, name, applied) FROM stdin;
1	contenttypes	0001_initial	2024-03-06 16:29:30.358634+00
2	auth	0001_initial	2024-03-06 16:29:30.388506+00
3	admin	0001_initial	2024-03-06 16:29:30.39916+00
4	admin	0002_logentry_remove_auto_add	2024-03-06 16:29:30.403377+00
5	admin	0003_logentry_add_action_flag_choices	2024-03-06 16:29:30.407507+00
6	api	0001_initial	2024-03-06 16:29:30.417771+00
7	api	0002_friend	2024-03-06 16:29:30.423945+00
8	api	0003_alter_player_avatar	2024-03-06 16:29:30.426606+00
9	api	0004_alter_player_avatar	2024-03-06 16:29:30.429314+00
10	api	0005_alter_player_avatar	2024-03-06 16:29:30.432695+00
11	api	0006_remove_player_avatar_player_profile_picture	2024-03-06 16:29:30.437603+00
12	api	0007_remove_player_login_player_username	2024-03-06 16:29:30.441742+00
13	api	0008_player_is_default_picture	2024-03-06 16:29:30.444432+00
14	api	0009_alter_player_profile_picture	2024-03-06 16:29:30.44705+00
15	api	0010_alter_player_profile_picture	2024-03-06 16:29:30.450355+00
16	api	0011_player_is_2fa_alter_player_profile_picture	2024-03-06 16:29:30.454504+00
17	api	0012_remove_player_is_default_picture	2024-03-06 16:29:30.457118+00
18	api	0013_alter_player_profile_picture	2024-03-06 16:29:30.459582+00
19	api	0014_friend_status	2024-03-06 16:29:30.463272+00
20	api	0015_user_alter_friend_friend_alter_friend_user_and_more	2024-03-06 16:29:30.48655+00
21	api	0016_alter_friend_status	2024-03-06 16:29:30.489408+00
22	api	0017_alter_friend_status	2024-03-06 16:29:30.491997+00
23	api	0018_user_secret_2fa	2024-03-06 16:29:30.494511+00
24	contenttypes	0002_remove_content_type_name	2024-03-06 16:29:30.504651+00
25	auth	0002_alter_permission_name_max_length	2024-03-06 16:29:30.508761+00
26	auth	0003_alter_user_email_max_length	2024-03-06 16:29:30.512934+00
27	auth	0004_alter_user_username_opts	2024-03-06 16:29:30.517072+00
28	auth	0005_alter_user_last_login_null	2024-03-06 16:29:30.521039+00
29	auth	0006_require_contenttypes_0002	2024-03-06 16:29:30.522004+00
30	auth	0007_alter_validators_add_error_messages	2024-03-06 16:29:30.525856+00
31	auth	0008_alter_user_username_max_length	2024-03-06 16:29:30.531402+00
32	auth	0009_alter_user_last_name_max_length	2024-03-06 16:29:30.535668+00
33	auth	0010_alter_group_name_max_length	2024-03-06 16:29:30.540254+00
34	auth	0011_update_proxy_permissions	2024-03-06 16:29:30.546103+00
35	auth	0012_alter_user_first_name_max_length	2024-03-06 16:29:30.550508+00
36	sessions	0001_initial	2024-03-06 16:29:30.55604+00
\.


--
-- Data for Name: django_session; Type: TABLE DATA; Schema: public; Owner: smessal
--

COPY public.django_session (session_key, session_data, expire_date) FROM stdin;
\.


--
-- Name: api_friend_id_seq; Type: SEQUENCE SET; Schema: public; Owner: smessal
--

SELECT pg_catalog.setval('public.api_friend_id_seq', 8, true);


--
-- Name: api_game_id_seq; Type: SEQUENCE SET; Schema: public; Owner: smessal
--

SELECT pg_catalog.setval('public.api_game_id_seq', 1, false);


--
-- Name: api_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: smessal
--

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


--
-- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: smessal
--

SELECT pg_catalog.setval('public.auth_group_id_seq', 1, false);


--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: smessal
--

SELECT pg_catalog.setval('public.auth_group_permissions_id_seq', 1, false);


--
-- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: smessal
--

SELECT pg_catalog.setval('public.auth_permission_id_seq', 36, true);


--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: smessal
--

SELECT pg_catalog.setval('public.auth_user_groups_id_seq', 1, false);


--
-- Name: auth_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: smessal
--

SELECT pg_catalog.setval('public.auth_user_id_seq', 1, false);


--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: smessal
--

SELECT pg_catalog.setval('public.auth_user_user_permissions_id_seq', 1, false);


--
-- Name: django_admin_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: smessal
--

SELECT pg_catalog.setval('public.django_admin_log_id_seq', 1, false);


--
-- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: smessal
--

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


--
-- Name: django_migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: smessal
--

SELECT pg_catalog.setval('public.django_migrations_id_seq', 36, true);


--
-- Name: api_friend api_friend_pkey; Type: CONSTRAINT; Schema: public; Owner: smessal
--

ALTER TABLE ONLY public.api_friend
    ADD CONSTRAINT api_friend_pkey PRIMARY KEY (id);


--
-- Name: api_game api_game_pkey; Type: CONSTRAINT; Schema: public; Owner: smessal
--

ALTER TABLE ONLY public.api_game
    ADD CONSTRAINT api_game_pkey PRIMARY KEY (id);


--
-- Name: api_user api_user_pkey; Type: CONSTRAINT; Schema: public; Owner: smessal
--

ALTER TABLE ONLY public.api_user
    ADD CONSTRAINT api_user_pkey PRIMARY KEY (id);


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

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

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

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

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

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

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

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

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 auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: smessal
--

ALTER TABLE ONLY public.auth_user
    ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);


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

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

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: auth_user auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: smessal
--

ALTER TABLE ONLY public.auth_user
    ADD CONSTRAINT auth_user_username_key UNIQUE (username);


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

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

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

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

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


--
-- Name: django_session django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: smessal
--

ALTER TABLE ONLY public.django_session
    ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);


--
-- Name: api_friend_friend_id_55bcccbc; Type: INDEX; Schema: public; Owner: smessal
--

CREATE INDEX api_friend_friend_id_55bcccbc ON public.api_friend USING btree (friend_id);


--
-- Name: api_friend_user_id_f89bf4cd; Type: INDEX; Schema: public; Owner: smessal
--

CREATE INDEX api_friend_user_id_f89bf4cd ON public.api_friend USING btree (user_id);


--
-- Name: api_game_player1_id_c89c27f8; Type: INDEX; Schema: public; Owner: smessal
--

CREATE INDEX api_game_player1_id_c89c27f8 ON public.api_game USING btree (player1_id);


--
-- Name: api_game_player2_id_64276fee; Type: INDEX; Schema: public; Owner: smessal
--

CREATE INDEX api_game_player2_id_64276fee ON public.api_game USING btree (player2_id);


--
-- Name: api_game_winner_id_1cbf0b15; Type: INDEX; Schema: public; Owner: smessal
--

CREATE INDEX api_game_winner_id_1cbf0b15 ON public.api_game USING btree (winner_id);


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

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

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

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

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

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

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

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

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


--
-- Name: auth_user_username_6821ab7c_like; Type: INDEX; Schema: public; Owner: smessal
--

CREATE INDEX auth_user_username_6821ab7c_like ON public.auth_user USING btree (username varchar_pattern_ops);


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

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

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


--
-- Name: django_session_expire_date_a5c62663; Type: INDEX; Schema: public; Owner: smessal
--

CREATE INDEX django_session_expire_date_a5c62663 ON public.django_session USING btree (expire_date);


--
-- Name: django_session_session_key_c0390e0f_like; Type: INDEX; Schema: public; Owner: smessal
--

CREATE INDEX django_session_session_key_c0390e0f_like ON public.django_session USING btree (session_key varchar_pattern_ops);


--
-- Name: api_friend api_friend_friend_id_55bcccbc_fk_api_user_id; Type: FK CONSTRAINT; Schema: public; Owner: smessal
--

ALTER TABLE ONLY public.api_friend
    ADD CONSTRAINT api_friend_friend_id_55bcccbc_fk_api_user_id FOREIGN KEY (friend_id) REFERENCES public.api_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: api_friend api_friend_user_id_f89bf4cd_fk_api_user_id; Type: FK CONSTRAINT; Schema: public; Owner: smessal
--

ALTER TABLE ONLY public.api_friend
    ADD CONSTRAINT api_friend_user_id_f89bf4cd_fk_api_user_id FOREIGN KEY (user_id) REFERENCES public.api_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: api_game api_game_player1_id_c89c27f8_fk_api_user_id; Type: FK CONSTRAINT; Schema: public; Owner: smessal
--

ALTER TABLE ONLY public.api_game
    ADD CONSTRAINT api_game_player1_id_c89c27f8_fk_api_user_id FOREIGN KEY (player1_id) REFERENCES public.api_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: api_game api_game_player2_id_64276fee_fk_api_user_id; Type: FK CONSTRAINT; Schema: public; Owner: smessal
--

ALTER TABLE ONLY public.api_game
    ADD CONSTRAINT api_game_player2_id_64276fee_fk_api_user_id FOREIGN KEY (player2_id) REFERENCES public.api_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: api_game api_game_winner_id_1cbf0b15_fk_api_user_id; Type: FK CONSTRAINT; Schema: public; Owner: smessal
--

ALTER TABLE ONLY public.api_game
    ADD CONSTRAINT api_game_winner_id_1cbf0b15_fk_api_user_id FOREIGN KEY (winner_id) REFERENCES public.api_user(id) DEFERRABLE INITIALLY DEFERRED;


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

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

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

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

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

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

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

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

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

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;


--
-- PostgreSQL database dump complete
--