
SET transaction_timeout = 0;



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

CREATE TABLE public.auth_event_logs (
    id bigint NOT NULL,
    event_type character varying(30) NOT NULL,
    ip_address character varying(45),
    user_agent text,
    created_at timestamp with time zone NOT NULL,
    user_id bigint
);


ALTER TABLE public.auth_event_logs OWNER TO postgres;

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

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


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

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


ALTER TABLE public.auth_group OWNER TO postgres;

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

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

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

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

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

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

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

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

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


ALTER TABLE public.django_admin_log OWNER TO postgres;

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

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

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

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

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

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

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

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

CREATE TABLE public.login_attempts (
    id bigint NOT NULL,
    failed_attempts integer NOT NULL,
    is_locked boolean NOT NULL,
    locked_at timestamp with time zone,
    user_id bigint NOT NULL,
    CONSTRAINT login_attempts_failed_attempts_check CHECK ((failed_attempts >= 0))
);


ALTER TABLE public.login_attempts OWNER TO postgres;

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

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


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

CREATE TABLE public.mfa_settings (
    id bigint NOT NULL,
    method character varying(10) NOT NULL
);


ALTER TABLE public.mfa_settings OWNER TO postgres;

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

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

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

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


ALTER TABLE public.users_groups OWNER TO postgres;

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

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


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

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


ALTER TABLE public.users_user_permissions OWNER TO postgres;

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

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


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

COPY public.auth_event_logs (id, event_type, ip_address, user_agent, created_at, user_id) FROM stdin;
1	LOGIN_SUCCESS	127.0.0.1	Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.26100.8655	2026-06-15 14:50:23.40353+05:30	1
2	LOGIN_FAIL	127.0.0.1	Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.26100.8655	2026-06-15 14:50:24.420323+05:30	1
3	LOGIN_SUCCESS	127.0.0.1	Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.26100.8655	2026-06-15 15:01:43.179298+05:30	1
4	LOGIN_SUCCESS	127.0.0.1	Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.26100.8655	2026-06-15 15:01:46.966996+05:30	1
5	MFA_FAIL	127.0.0.1	Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.26100.8655	2026-06-15 15:01:47.081474+05:30	1
6	LOGIN_SUCCESS	127.0.0.1	Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.26100.8655	2026-06-15 15:05:58.77261+05:30	1
7	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-15 15:14:00.778789+05:30	1
8	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-15 15:19:13.313403+05:30	1
9	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-15 15:26:45.275415+05:30	1
10	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-16 10:07:18.506687+05:30	1
11	LOGIN_FAIL	127.0.0.1	python-httpx/0.28.1	2026-06-16 12:19:40.502058+05:30	1
12	LOGIN_FAIL	127.0.0.1	python-httpx/0.28.1	2026-06-16 12:19:55.522216+05:30	1
13	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-17 15:21:42.1379+05:30	1
14	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-17 15:22:27.34618+05:30	1
15	MFA_FAIL	127.0.0.1	python-httpx/0.28.1	2026-06-17 15:24:10.547273+05:30	1
16	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-17 15:24:39.659856+05:30	1
17	LOGIN_SUCCESS	127.0.0.1	Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.26100.8655	2026-06-19 20:06:48.980704+05:30	1
18	MFA_FAIL	127.0.0.1	Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.26100.8655	2026-06-19 20:06:56.765537+05:30	1
19	LOGIN_SUCCESS	127.0.0.1	Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.26100.8655	2026-06-19 20:07:30.90303+05:30	1
20	MFA_FAIL	127.0.0.1	python-httpx/0.28.1	2026-06-19 20:31:13.388771+05:30	1
21	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-19 20:43:28.330813+05:30	1
22	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-19 20:55:20.652109+05:30	1
23	MFA_FAIL	127.0.0.1	python-httpx/0.28.1	2026-06-19 20:57:35.197333+05:30	1
24	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-19 20:57:40.181603+05:30	1
25	MFA_FAIL	127.0.0.1	python-httpx/0.28.1	2026-06-19 21:06:45.662463+05:30	1
26	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-19 21:06:57.495716+05:30	1
27	LOGIN_SUCCESS	127.0.0.1	Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.26100.8655	2026-06-19 21:11:20.449971+05:30	1
28	MFA_FAIL	127.0.0.1	python-httpx/0.28.1	2026-06-19 21:18:18.880711+05:30	1
29	MFA_FAIL	127.0.0.1	Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.26100.8655	2026-06-19 21:20:08.364647+05:30	1
30	MFA_FAIL	127.0.0.1	curl/8.12.1	2026-06-19 21:20:50.555106+05:30	1
31	MFA_FAIL	127.0.0.1	python-httpx/0.28.1	2026-06-19 21:22:39.71827+05:30	1
32	MFA_FAIL	127.0.0.1	python-httpx/0.28.1	2026-06-19 21:23:10.310031+05:30	1
33	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-19 21:24:12.677076+05:30	1
34	LOGIN_SUCCESS	127.0.0.1	Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.26100.8655	2026-06-19 21:59:00.378402+05:30	1
35	LOGIN_SUCCESS	127.0.0.1	Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.26100.8655	2026-06-19 22:13:07.346176+05:30	1
36	LOGIN_SUCCESS	127.0.0.1	Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.26100.8655	2026-06-19 22:26:39.35926+05:30	1
37	LOGIN_SUCCESS	127.0.0.1	Mozilla/5.0 (Windows NT; Windows NT 10.0; en-US) WindowsPowerShell/5.1.26100.8655	2026-06-20 06:55:40.931806+05:30	1
38	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-20 06:58:09.203133+05:30	1
39	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-20 07:00:09.338066+05:30	1
40	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-20 07:00:28.258068+05:30	1
41	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-20 07:13:11.11909+05:30	1
42	MFA_FAIL	127.0.0.1	python-httpx/0.28.1	2026-06-20 07:14:39.717757+05:30	1
43	MFA_FAIL	127.0.0.1	python-httpx/0.28.1	2026-06-20 07:14:49.422079+05:30	1
44	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-20 07:14:53.339714+05:30	1
45	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-20 10:07:38.361344+05:30	1
46	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-20 11:45:36.356076+05:30	1
47	MFA_FAIL	127.0.0.1	python-httpx/0.28.1	2026-06-20 11:53:40.417035+05:30	1
48	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-20 11:53:47.435579+05:30	1
49	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-20 13:33:11.047969+05:30	1
50	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-20 13:34:05.928857+05:30	1
51	LOGIN_SUCCESS	127.0.0.1	python-httpx/0.28.1	2026-06-22 10:24:09.005348+05:30	1
\.


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

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


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

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


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

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	3	add_permission
6	Can change permission	3	change_permission
7	Can delete permission	3	delete_permission
8	Can view permission	3	view_permission
9	Can add group	2	add_group
10	Can change group	2	change_group
11	Can delete group	2	delete_group
12	Can view group	2	view_group
13	Can add content type	4	add_contenttype
14	Can change content type	4	change_contenttype
15	Can delete content type	4	delete_contenttype
16	Can view content type	4	view_contenttype
17	Can add session	5	add_session
18	Can change session	5	change_session
19	Can delete session	5	delete_session
20	Can view session	5	view_session
21	Can add user	6	add_user
22	Can change user	6	change_user
23	Can delete user	6	delete_user
24	Can view user	6	view_user
25	Can add login attempt	7	add_loginattempt
26	Can change login attempt	7	change_loginattempt
27	Can delete login attempt	7	delete_loginattempt
28	Can view login attempt	7	view_loginattempt
29	Can add otp record	8	add_otprecord
30	Can change otp record	8	change_otprecord
31	Can delete otp record	8	delete_otprecord
32	Can view otp record	8	view_otprecord
33	Can add auth event log	9	add_autheventlog
34	Can change auth event log	9	change_autheventlog
35	Can delete auth event log	9	delete_autheventlog
36	Can view auth event log	9	view_autheventlog
37	Can add MFA Settings	10	add_mfasettings
38	Can change MFA Settings	10	change_mfasettings
39	Can delete MFA Settings	10	delete_mfasettings
40	Can view MFA Settings	10	view_mfasettings
\.


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

COPY public.django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) FROM stdin;
1	2026-06-19 20:10:06.751709+05:30	1	MFA Settings	2	[{"changed": {"fields": ["Email enabled"]}}]	10	1
2	2026-06-19 20:10:25.291597+05:30	1	MFA Settings	2	[]	10	1
3	2026-06-19 20:27:09.982524+05:30	1	MFA Settings	2	[{"changed": {"fields": ["Totp enabled", "Email enabled"]}}]	10	1
4	2026-06-19 22:16:48.154922+05:30	1	MFA Settings	2	[{"changed": {"fields": ["Totp enabled", "Email enabled"]}}]	10	1
5	2026-06-19 22:31:23.980163+05:30	1	MFA method: email	2	[{"changed": {"fields": ["Method"]}}]	10	1
6	2026-06-19 22:35:07.824895+05:30	1	MFA method: totp	2	[{"changed": {"fields": ["Method"]}}]	10	1
7	2026-06-20 07:13:53.216153+05:30	1	MFA method: email	2	[{"changed": {"fields": ["Method"]}}]	10	1
8	2026-06-20 09:43:21.403584+05:30	1	MFA method: email	2	[]	10	1
9	2026-06-20 11:52:45.97021+05:30	1	MFA method: email	2	[]	10	1
10	2026-06-20 11:55:14.045913+05:30	1	MFA method: totp	2	[{"changed": {"fields": ["Method"]}}]	10	1
11	2026-06-20 13:32:36.880055+05:30	1	MFA method: email	2	[{"changed": {"fields": ["Method"]}}]	10	1
12	2026-06-20 13:33:30.10992+05:30	1	MFA method: totp	2	[{"changed": {"fields": ["Method"]}}]	10	1
13	2026-06-20 13:37:06.602831+05:30	1	MFA method: email	2	[{"changed": {"fields": ["Method"]}}]	10	1
14	2026-06-20 13:37:10.702992+05:30	1	MFA method: email	2	[]	10	1
\.


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

COPY public.django_content_type (id, app_label, model) FROM stdin;
1	admin	logentry
2	auth	group
3	auth	permission
4	contenttypes	contenttype
5	sessions	session
6	users	user
7	authentication	loginattempt
8	authentication	otprecord
9	audit_logs	autheventlog
10	authentication	mfasettings
\.


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

COPY public.django_migrations (id, app, name, applied) FROM stdin;
1	contenttypes	0001_initial	2026-06-15 14:48:57.599233+05:30
2	contenttypes	0002_remove_content_type_name	2026-06-15 14:48:57.60867+05:30
3	auth	0001_initial	2026-06-15 14:48:57.649949+05:30
4	auth	0002_alter_permission_name_max_length	2026-06-15 14:48:57.656191+05:30
5	auth	0003_alter_user_email_max_length	2026-06-15 14:48:57.661531+05:30
6	auth	0004_alter_user_username_opts	2026-06-15 14:48:57.665537+05:30
7	auth	0005_alter_user_last_login_null	2026-06-15 14:48:57.668538+05:30
8	auth	0006_require_contenttypes_0002	2026-06-15 14:48:57.669537+05:30
9	auth	0007_alter_validators_add_error_messages	2026-06-15 14:48:57.671533+05:30
10	auth	0008_alter_user_username_max_length	2026-06-15 14:48:57.678556+05:30
11	auth	0009_alter_user_last_name_max_length	2026-06-15 14:48:57.683221+05:30
12	auth	0010_alter_group_name_max_length	2026-06-15 14:48:57.689221+05:30
13	auth	0011_update_proxy_permissions	2026-06-15 14:48:57.694254+05:30
14	auth	0012_alter_user_first_name_max_length	2026-06-15 14:48:57.698448+05:30
15	users	0001_initial	2026-06-15 14:48:57.749651+05:30
16	admin	0001_initial	2026-06-15 14:48:57.771566+05:30
17	admin	0002_logentry_remove_auto_add	2026-06-15 14:48:57.778392+05:30
18	admin	0003_logentry_add_action_flag_choices	2026-06-15 14:48:57.783388+05:30
19	audit_logs	0001_initial	2026-06-15 14:48:57.797934+05:30
20	authentication	0001_initial	2026-06-15 14:48:57.847718+05:30
21	sessions	0001_initial	2026-06-15 14:48:57.968222+05:30
22	authentication	0002_mfasettings	2026-06-19 20:03:59.058855+05:30
23	users	0002_user_mfa_method	2026-06-19 20:03:59.119375+05:30
24	authentication	0003_remove_mfasettings_email_enabled_and_more	2026-06-19 22:22:11.891882+05:30
\.


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

COPY public.login_attempts (id, failed_attempts, is_locked, locked_at, user_id) FROM stdin;
1	0	f	\N	1
\.


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

COPY public.mfa_settings (id, method) FROM stdin;
1	email
\.


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

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


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

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



--
-- Name: auth_event_logs auth_event_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_event_logs
    ADD CONSTRAINT auth_event_logs_pkey PRIMARY KEY (id);


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

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

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

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

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

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

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


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

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

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

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

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


--
-- Name: login_attempts login_attempts_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.login_attempts
    ADD CONSTRAINT login_attempts_pkey PRIMARY KEY (id);


--
-- Name: login_attempts login_attempts_user_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.login_attempts
    ADD CONSTRAINT login_attempts_user_id_key UNIQUE (user_id);


--
-- Name: mfa_settings mfa_settings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.mfa_settings
    ADD CONSTRAINT mfa_settings_pkey PRIMARY KEY (id);


--
-- Name: users_groups users_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_groups
    ADD CONSTRAINT users_groups_pkey PRIMARY KEY (id);


--
-- Name: users_groups users_groups_user_id_group_id_fc7788e8_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_groups
    ADD CONSTRAINT users_groups_user_id_group_id_fc7788e8_uniq UNIQUE (user_id, group_id);


--
-- Name: users_user_permissions users_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_user_permissions
    ADD CONSTRAINT users_user_permissions_pkey PRIMARY KEY (id);


--
-- Name: users_user_permissions users_user_permissions_user_id_permission_id_3b86cbdf_uniq; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_user_permissions
    ADD CONSTRAINT users_user_permissions_user_id_permission_id_3b86cbdf_uniq UNIQUE (user_id, permission_id);


--
-- Name: auth_event_logs_user_id_96985d65; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX auth_event_logs_user_id_96985d65 ON public.auth_event_logs USING btree (user_id);


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

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

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

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

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


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

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

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


--
-- Name: users_groups_group_id_2f3517aa; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX users_groups_group_id_2f3517aa ON public.users_groups USING btree (group_id);


--
-- Name: users_groups_user_id_f500bee5; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX users_groups_user_id_f500bee5 ON public.users_groups USING btree (user_id);


--
-- Name: users_user_permissions_permission_id_6d08dcd2; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX users_user_permissions_permission_id_6d08dcd2 ON public.users_user_permissions USING btree (permission_id);


--
-- Name: users_user_permissions_user_id_92473840; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX users_user_permissions_user_id_92473840 ON public.users_user_permissions USING btree (user_id);


--
-- Name: auth_event_logs auth_event_logs_user_id_96985d65_fk_users_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.auth_event_logs
    ADD CONSTRAINT auth_event_logs_user_id_96985d65_fk_users_id FOREIGN KEY (user_id) REFERENCES public.users(id) DEFERRABLE INITIALLY DEFERRED;


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

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

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

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: django_admin_log django_admin_log_content_type_id_c4bce8eb_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

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_users_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

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


--
-- Name: login_attempts login_attempts_user_id_8779072f_fk_users_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.login_attempts
    ADD CONSTRAINT login_attempts_user_id_8779072f_fk_users_id FOREIGN KEY (user_id) REFERENCES public.users(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: users_groups users_groups_group_id_2f3517aa_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

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


--
-- Name: users_groups users_groups_user_id_f500bee5_fk_users_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_groups
    ADD CONSTRAINT users_groups_user_id_f500bee5_fk_users_id FOREIGN KEY (user_id) REFERENCES public.users(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: users_user_permissions users_user_permissio_permission_id_6d08dcd2_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

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


--
-- Name: users_user_permissions users_user_permissions_user_id_92473840_fk_users_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users_user_permissions
    ADD CONSTRAINT users_user_permissions_user_id_92473840_fk_users_id FOREIGN KEY (user_id) REFERENCES public.users(id) DEFERRABLE INITIALLY DEFERRED;