-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathinit.sql
95 lines (89 loc) · 3.02 KB
/
init.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
-- Seed Event types
INSERT INTO public.event_types(id, name)
VALUES (1, 'Password Created')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.event_types(id, name)
VALUES (2, 'Password Updated')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.event_types(id, name)
VALUES (3, 'Password Deleted')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.event_types(id, name)
VALUES (4, 'Secret Created')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.event_types(id, name)
VALUES (5, 'Secret Updated')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.event_types(id, name)
VALUES (6, 'Secret Deleted')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.event_types(id, name)
VALUES (7, 'Identity Created')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.event_types(id, name)
VALUES (8, 'Identity Updated')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.event_types(id, name)
VALUES (9, 'Identity Deleted')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.event_types(id, name)
VALUES (10, 'Totp Created')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.event_types(id, name)
VALUES (11, 'Totp Updated')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.event_types(id, name)
VALUES (12, 'Totp Deleted')
ON CONFLICT (id) DO NOTHING;
-- Seed key types
INSERT INTO public.key_types(id, name, description, has_size)
VALUES (1, 'ED25519', 'Edwards-curve Digital Signature Algorithm (EdDSA)', false)
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.key_types(id, name, description, has_size)
VALUES (2, 'RSA', 'Rivest–Shamir–Adleman (RSA)', true)
ON CONFLICT (id) DO NOTHING;
-- Seed Time Based Code Types
INSERT INTO public.time_based_code_types(id, name)
VALUES (1, 'HOTP')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.time_based_code_types(id, name)
VALUES (2, 'TOTP')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.time_based_code_types(id, name)
VALUES (3, 'OTP')
ON CONFLICT (id) DO NOTHING;
-- Seed the algorithm table
INSERT INTO public.time_based_algorithms(id, name)
VALUES (1, 'AlgorithmSHA1')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.time_based_algorithms(id, name)
VALUES (2, 'AlgorithmSHA256')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.time_based_algorithms(id, name)
VALUES (3, 'AlgorithmSHA512')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.time_based_algorithms(id, name)
VALUES (4, 'AlgorithmMD5')
ON CONFLICT (id) DO NOTHING;
-- Seed the mfa method types
INSERT INTO public.mfa_method_types(id, name)
VALUES (1, 'email')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.mfa_method_types(id, name)
VALUES (2, 'authenticator')
ON CONFLICT (id) DO NOTHING;
INSERT INTO public.device_types(
id, name)
VALUES (1, 'Android');
INSERT INTO public.device_types(
id, name)
VALUES (2, 'IOS');
INSERT INTO public.device_types(
id, name)
VALUES (3, 'Windows');
INSERT INTO public.device_types(
id, name)
VALUES (4, 'Linux');
INSERT INTO public.device_types(
id, name)
VALUES (5, 'MacOS');