--
-- PostgreSQL database dump
--

\restrict N7OdbGLVGwZE4LWqqfazVLS6IIaNdGiRMMmpVYZHXM7zVU2fAobLgKYfHSCss3g

-- Dumped from database version 18.4
-- Dumped by pg_dump version 18.4

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_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: 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: django_session; Type: TABLE; Schema: public; Owner: postgres
--

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

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

CREATE TABLE public.otp_records (
    id bigint NOT NULL,
    otp_code character varying(6) NOT NULL,
    created_at timestamp with time zone NOT NULL,
    retry_count integer NOT NULL,
    resend_count integer NOT NULL,
    user_id bigint NOT NULL,
    CONSTRAINT otp_records_resend_count_check CHECK ((resend_count >= 0)),
    CONSTRAINT otp_records_retry_count_check CHECK ((retry_count >= 0))
);


ALTER TABLE public.otp_records OWNER TO postgres;

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

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


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

CREATE TABLE public.users (
    id bigint 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,
    is_staff boolean NOT NULL,
    is_active boolean NOT NULL,
    date_joined timestamp with time zone NOT NULL,
    email character varying(254) NOT NULL,
    role character varying(20) NOT NULL,
    full_name character varying(255) NOT NULL,
    phone character varying(20) NOT NULL,
    location character varying(255) NOT NULL,
    skills text NOT NULL,
    experience_years integer NOT NULL,
    bio text NOT NULL,
    resume character varying(100),
    mfa_enabled boolean NOT NULL,
    totp_secret character varying(32) NOT NULL,
    mfa_method character varying(10) NOT NULL,
    CONSTRAINT users_experience_years_check CHECK ((experience_years >= 0))
);


ALTER TABLE public.users OWNER TO postgres;

--
-- 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_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
);


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

COPY public.django_session (session_key, session_data, expire_date) FROM stdin;
cem6jj5sv3q5fj32buv6txq7yyagjpnz	.eJxVjEEOwiAQRe_C2hCYtgO4dO8ZyDCAVA0kpV0Z765NutDtf-_9l_C0rcVvPS1-juIstDj9boH4keoO4p3qrUludV3mIHdFHrTLa4vpeTncv4NCvXzrkEPSiJPLFpG0joNBbSlTIDuqSKTU5HBIEGxmY4CAGQYwY2ZHkKJ4fwDwCThY:1wZ3oc:VTaYPnzgO02Dh-yxBw9kIDA8ZLnqDqDHQmxKj_pQL30	2026-06-29 15:11:10.474629+05:30
4vb5bs0ydmbqltmsp44t7t97r8muns9m	.eJxVjEEOwiAQRe_C2hCYtgO4dO8ZyDCAVA0kpV0Z765NutDtf-_9l_C0rcVvPS1-juIstDj9boH4keoO4p3qrUludV3mIHdFHrTLa4vpeTncv4NCvXzrkEPSiJPLFpG0joNBbSlTIDuqSKTU5HBIEGxmY4CAGQYwY2ZHkKJ4fwDwCThY:1wZ3wg:ekYdVHWjEZSYo2RB15AA_65GOm8CV1whDtuU40nqgx8	2026-06-29 15:19:30.107011+05:30
xjghtxa50817ibxmldvodbk76jqi3r06	.eJxVjEEOwiAQRe_C2hCYtgO4dO8ZyDCAVA0kpV0Z765NutDtf-_9l_C0rcVvPS1-juIstDj9boH4keoO4p3qrUludV3mIHdFHrTLa4vpeTncv4NCvXzrkEPSiJPLFpG0joNBbSlTIDuqSKTU5HBIEGxmY4CAGQYwY2ZHkKJ4fwDwCThY:1wZ3wg:ekYdVHWjEZSYo2RB15AA_65GOm8CV1whDtuU40nqgx8	2026-06-29 15:19:30.54334+05:30
mueslgxb2nvllaximx7fz2juurahvgau	.eJxVjEEOwiAQRe_C2hCYtgO4dO8ZyDCAVA0kpV0Z765NutDtf-_9l_C0rcVvPS1-juIstDj9boH4keoO4p3qrUludV3mIHdFHrTLa4vpeTncv4NCvXzrkEPSiJPLFpG0joNBbSlTIDuqSKTU5HBIEGxmY4CAGQYwY2ZHkKJ4fwDwCThY:1wZLa9:X_NCAUTz_MdenZj9xXtc5GRKxgs_lLPlBEU7-p0hZfU	2026-06-30 10:09:25.388991+05:30
7pjn9zqntq6fj7m4mmwscica9nhc10s6	.eJxVjEEOwiAQRe_C2hCYtgO4dO8ZyDCAVA0kpV0Z765NutDtf-_9l_C0rcVvPS1-juIstDj9boH4keoO4p3qrUludV3mIHdFHrTLa4vpeTncv4NCvXzrkEPSiJPLFpG0joNBbSlTIDuqSKTU5HBIEGxmY4CAGQYwY2ZHkKJ4fwDwCThY:1waacE:8i0uJWf9HbFllRQp1okOr9DOn1AXdfE9U71EBQcQpJ8	2026-07-03 20:24:42.56598+05:30
y3b7goxlqt61iwlgn6kid06gayhny80e	.eJxVjEEOwiAQRe_C2hCYtgO4dO8ZyDCAVA0kpV0Z765NutDtf-_9l_C0rcVvPS1-juIstDj9boH4keoO4p3qrUludV3mIHdFHrTLa4vpeTncv4NCvXzrkEPSiJPLFpG0joNBbSlTIDuqSKTU5HBIEGxmY4CAGQYwY2ZHkKJ4fwDwCThY:1waacF:Lpvbta-UY5E-0MG01ihJO7LjBUwuE5jtJJzLyaErkq0	2026-07-03 20:24:43.486376+05:30
j4uyae7rtugpxjd21uxsthdvug21wl7x	.eJxVjEEOwiAQRe_C2hCYtgO4dO8ZyDCAVA0kpV0Z765NutDtf-_9l_C0rcVvPS1-juIstDj9boH4keoO4p3qrUludV3mIHdFHrTLa4vpeTncv4NCvXzrkEPSiJPLFpG0joNBbSlTIDuqSKTU5HBIEGxmY4CAGQYwY2ZHkKJ4fwDwCThY:1wan4E:gm88gYmx56FfbqJK73KFzr4LG1twa7yVcxHKY3eVdXw	2026-07-04 09:42:26.4076+05:30
czkyj8gnpgld47ocs1bq99k451elcul0	.eJxVjEEOwiAQRe_C2hCYtgO4dO8ZyDCAVA0kpV0Z765NutDtf-_9l_C0rcVvPS1-juIstDj9boH4keoO4p3qrUludV3mIHdFHrTLa4vpeTncv4NCvXzrkEPSiJPLFpG0joNBbSlTIDuqSKTU5HBIEGxmY4CAGQYwY2ZHkKJ4fwDwCThY:1wan4J:La1xd7XoWGXoVTRvtRt_Ldxe3V8W8FPCxTQtd3EDvEg	2026-07-04 09:42:31.753506+05:30
9gv3p5k77s6kzufl58557m3a39r3j6hj	.eJxVjEEOwiAQRe_C2hCYtgO4dO8ZyDCAVA0kpV0Z765NutDtf-_9l_C0rcVvPS1-juIstDj9boH4keoO4p3qrUludV3mIHdFHrTLa4vpeTncv4NCvXzrkEPSiJPLFpG0joNBbSlTIDuqSKTU5HBIEGxmY4CAGQYwY2ZHkKJ4fwDwCThY:1wap5V:_RgYO2s0guefM3fxQ27i2pmFwVixsfAuxmu_WYUkQK0	2026-07-04 11:51:53.126327+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: otp_records; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.otp_records (id, otp_code, created_at, retry_count, resend_count, user_id) FROM stdin;
15	468494	2026-06-20 16:24:16.949818+05:30	0	0	1
\.


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

COPY public.users (id, password, last_login, is_superuser, username, first_name, last_name, is_staff, is_active, date_joined, email, role, full_name, phone, location, skills, experience_years, bio, resume, mfa_enabled, totp_secret, mfa_method) FROM stdin;
1	pbkdf2_sha256$1200000$ZRXLhoTY6YtobBJ8kjSL7X$tHxpOCiXQZtI8T9y6jCH3F4r3DrBt6z1ugUD+eSllRU=	2026-06-22 10:24:09.00338+05:30	t	admin			t	t	2026-06-15 14:49:52.906483+05:30	alok.nandan@indovisionservices.in	ADMIN					0			t	6WG42Q6NZYMZRTLSOCCN67C3OA446UGS	totp
\.


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

SELECT pg_catalog.setval('public.auth_event_logs_id_seq', 51, true);


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

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


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

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


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

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


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

SELECT pg_catalog.setval('public.django_admin_log_id_seq', 14, true);


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

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


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

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


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

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


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

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


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

SELECT pg_catalog.setval('public.otp_records_id_seq', 15, true);


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

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


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

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


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

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


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

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


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

ALTER TABLE ONLY public.otp_records
    ADD CONSTRAINT otp_records_pkey PRIMARY KEY (id);


--
-- Name: otp_records otp_records_user_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.otp_records
    ADD CONSTRAINT otp_records_user_id_key UNIQUE (user_id);


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

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


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

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (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: users users_username_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_username_key UNIQUE (username);


--
-- 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: django_session_expire_date_a5c62663; Type: INDEX; Schema: public; Owner: postgres
--

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

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


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

CREATE INDEX users_email_0ea73cca_like ON public.users USING btree (email varchar_pattern_ops);


--
-- 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: users_username_e8658fc8_like; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX users_username_e8658fc8_like ON public.users USING btree (username varchar_pattern_ops);


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

ALTER TABLE ONLY public.otp_records
    ADD CONSTRAINT otp_records_user_id_0fd1b5f2_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;


--
-- PostgreSQL database dump complete
--

\unrestrict N7OdbGLVGwZE4LWqqfazVLS6IIaNdGiRMMmpVYZHXM7zVU2fAobLgKYfHSCss3g

