-
Notifications
You must be signed in to change notification settings - Fork 0
/
appauths_database_backup.sql
177 lines (119 loc) · 3.94 KB
/
appauths_database_backup.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
--
-- PostgreSQL database dump
--
-- Dumped from database version 16.3 (Ubuntu 16.3-1.pgdg22.04+1)
-- Dumped by pg_dump version 16.3 (Ubuntu 16.3-1.pgdg22.04+1)
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
SET default_tablespace = '';
SET default_table_access_method = heap;
--
-- Name: auth_user; Type: TABLE; Schema: public; Owner: i9
--
CREATE TABLE public.auth_user (
user_id integer NOT NULL,
email character varying NOT NULL,
username character varying NOT NULL,
password character varying,
totp_setup_key character varying,
mfa_enabled boolean DEFAULT false NOT NULL,
mfa_type character varying,
CONSTRAINT mfa_type_options CHECK ((((mfa_type)::text = 'otp'::text) OR ((mfa_type)::text = 'totp'::text)))
);
ALTER TABLE public.auth_user OWNER TO i9;
--
-- Name: auth_user_user_id_seq; Type: SEQUENCE; Schema: public; Owner: i9
--
CREATE SEQUENCE public.auth_user_user_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER SEQUENCE public.auth_user_user_id_seq OWNER TO i9;
--
-- Name: auth_user_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: i9
--
ALTER SEQUENCE public.auth_user_user_id_seq OWNED BY public.auth_user.user_id;
--
-- Name: ongoing_auth; Type: TABLE; Schema: public; Owner: i9
--
CREATE TABLE public.ongoing_auth (
k character varying(64) DEFAULT ''::character varying NOT NULL,
v bytea NOT NULL,
e bigint DEFAULT '0'::bigint NOT NULL
);
ALTER TABLE public.ongoing_auth OWNER TO i9;
--
-- Name: ongoing_process; Type: TABLE; Schema: public; Owner: i9
--
CREATE TABLE public.ongoing_process (
k character varying(64) DEFAULT ''::character varying NOT NULL,
v bytea NOT NULL,
e bigint DEFAULT '0'::bigint NOT NULL
);
ALTER TABLE public.ongoing_process OWNER TO i9;
--
-- Name: auth_user user_id; Type: DEFAULT; Schema: public; Owner: i9
--
ALTER TABLE ONLY public.auth_user ALTER COLUMN user_id SET DEFAULT nextval('public.auth_user_user_id_seq'::regclass);
--
-- Data for Name: auth_user; Type: TABLE DATA; Schema: public; Owner: i9
--
COPY public.auth_user (user_id, email, username, password, totp_setup_key, mfa_enabled, mfa_type) FROM stdin;
\.
--
-- Data for Name: ongoing_auth; Type: TABLE DATA; Schema: public; Owner: i9
--
COPY public.ongoing_auth (k, v, e) FROM stdin;
\.
--
-- Data for Name: ongoing_process; Type: TABLE DATA; Schema: public; Owner: i9
--
COPY public.ongoing_process (k, v, e) FROM stdin;
\.
--
-- Name: auth_user_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: i9
--
SELECT pg_catalog.setval('public.auth_user_user_id_seq', 1, false);
--
-- Name: auth_user auth_user_email_key; Type: CONSTRAINT; Schema: public; Owner: i9
--
ALTER TABLE ONLY public.auth_user
ADD CONSTRAINT auth_user_email_key UNIQUE (email);
--
-- Name: auth_user auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: i9
--
ALTER TABLE ONLY public.auth_user
ADD CONSTRAINT auth_user_username_key UNIQUE (username);
--
-- Name: ongoing_auth ongoing_auth_pkey; Type: CONSTRAINT; Schema: public; Owner: i9
--
ALTER TABLE ONLY public.ongoing_auth
ADD CONSTRAINT ongoing_auth_pkey PRIMARY KEY (k);
--
-- Name: ongoing_process ongoing_process_pkey; Type: CONSTRAINT; Schema: public; Owner: i9
--
ALTER TABLE ONLY public.ongoing_process
ADD CONSTRAINT ongoing_process_pkey PRIMARY KEY (k);
--
-- Name: auth_user user_id_pk; Type: CONSTRAINT; Schema: public; Owner: i9
--
ALTER TABLE ONLY public.auth_user
ADD CONSTRAINT user_id_pk PRIMARY KEY (user_id);
--
-- Name: e; Type: INDEX; Schema: public; Owner: i9
--
CREATE INDEX e ON public.ongoing_auth USING btree (e);
--
-- PostgreSQL database dump complete
--