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
|
DROP TABLE IF EXISTS _bkp_UP_V0002_totp_configurations;
DROP TABLE IF EXISTS _bkp_UP_V0002_u2f_devices;
DROP TABLE IF EXISTS totp_secrets;
DROP TABLE IF EXISTS identity_verification_tokens;
DROP TABLE IF EXISTS u2f_devices;
DROP TABLE IF EXISTS config;
DROP TABLE IF EXISTS AuthenticationLogs;
DROP TABLE IF EXISTS IdentityVerificationTokens;
DROP TABLE IF EXISTS Preferences;
DROP TABLE IF EXISTS PreferencesTableName;
DROP TABLE IF EXISTS SecondFactorPreferences;
DROP TABLE IF EXISTS TOTPSecrets;
DROP TABLE IF EXISTS U2FDeviceHandles;
ALTER TABLE webauthn_devices
ALTER COLUMN aaguid DROP NOT NULL;
UPDATE webauthn_devices
SET aaguid = NULL
WHERE aaguid = '' OR aaguid = '00000000-00000000-00000000-00000000';
ALTER TABLE duo_devices
DROP CONSTRAINT IF EXISTS duo_devices_username_key;
DROP INDEX IF EXISTS duo_devices_username_key;
CREATE UNIQUE INDEX duo_devices_username_key ON duo_devices (username);
ALTER TABLE encryption
DROP CONSTRAINT IF EXISTS encryption_name_key;
DROP INDEX IF EXISTS encryption_name_key;
CREATE UNIQUE INDEX encryption_name_key ON encryption (name);
ALTER TABLE identity_verification
DROP CONSTRAINT IF EXISTS identity_verification_jti_key;
DROP INDEX IF EXISTS identity_verification_jti_key;
CREATE UNIQUE INDEX identity_verification_jti_key ON identity_verification (jti);
ALTER TABLE user_preferences
DROP CONSTRAINT IF EXISTS user_preferences_username_key;
DROP INDEX IF EXISTS user_preferences_username_key;
CREATE UNIQUE INDEX user_preferences_username_key ON user_preferences (username);
ALTER TABLE totp_configurations
DROP CONSTRAINT IF EXISTS totp_configurations_username_key1,
DROP CONSTRAINT IF EXISTS totp_configurations_username_key,
DROP CONSTRAINT IF EXISTS totp_configurations_pkey,
DROP CONSTRAINT IF EXISTS totp_configurations_pkey1;
DROP INDEX IF EXISTS totp_configurations_username_key1;
DROP INDEX IF EXISTS totp_configurations_username_key;
CREATE UNIQUE INDEX totp_configurations_username_key ON totp_configurations (username);
ALTER TABLE webauthn_devices
DROP CONSTRAINT IF EXISTS webauthn_devices_username_description_key1,
DROP CONSTRAINT IF EXISTS webauthn_devices_kid_key1,
DROP CONSTRAINT IF EXISTS webauthn_devices_lookup_key1,
DROP CONSTRAINT IF EXISTS webauthn_devices_username_description_key,
DROP CONSTRAINT IF EXISTS webauthn_devices_kid_key,
DROP CONSTRAINT IF EXISTS webauthn_devices_lookup_key,
DROP CONSTRAINT IF EXISTS webauthn_devices_pkey,
DROP CONSTRAINT IF EXISTS webauthn_devices_pkey1;
DROP INDEX IF EXISTS webauthn_devices_username_description_key1;
DROP INDEX IF EXISTS webauthn_devices_kid_key1;
DROP INDEX IF EXISTS webauthn_devices_lookup_key1;
DROP INDEX IF EXISTS webauthn_devices_username_description_key;
DROP INDEX IF EXISTS webauthn_devices_kid_key;
DROP INDEX IF EXISTS webauthn_devices_lookup_key;
CREATE UNIQUE INDEX webauthn_devices_kid_key ON webauthn_devices (kid);
CREATE UNIQUE INDEX webauthn_devices_lookup_key ON webauthn_devices (username, description);
ALTER TABLE oauth2_consent_session
DROP CONSTRAINT oauth2_consent_session_subject_fkey,
DROP CONSTRAINT oauth2_consent_session_preconfiguration_fkey;
ALTER TABLE oauth2_consent_preconfiguration
DROP CONSTRAINT IF EXISTS oauth2_consent_preconfiguration_subjct_fkey,
DROP CONSTRAINT IF EXISTS oauth2_consent_preconfiguration_subject_fkey;
ALTER TABLE oauth2_access_token_session
DROP CONSTRAINT oauth2_access_token_session_challenge_id_fkey,
DROP CONSTRAINT oauth2_access_token_session_subject_fkey;
ALTER TABLE oauth2_authorization_code_session
DROP CONSTRAINT oauth2_authorization_code_session_challenge_id_fkey,
DROP CONSTRAINT oauth2_authorization_code_session_subject_fkey;
ALTER TABLE oauth2_openid_connect_session
DROP CONSTRAINT oauth2_openid_connect_session_challenge_id_fkey,
DROP CONSTRAINT oauth2_openid_connect_session_subject_fkey;
ALTER TABLE oauth2_pkce_request_session
DROP CONSTRAINT oauth2_pkce_request_session_challenge_id_fkey,
DROP CONSTRAINT oauth2_pkce_request_session_subject_fkey;
ALTER TABLE oauth2_refresh_token_session
DROP CONSTRAINT oauth2_refresh_token_session_challenge_id_fkey,
DROP CONSTRAINT oauth2_refresh_token_session_subject_fkey;
ALTER TABLE oauth2_consent_session
ADD CONSTRAINT oauth2_consent_session_subject_fkey
FOREIGN KEY (subject)
REFERENCES user_opaque_identifier (identifier) ON UPDATE CASCADE ON DELETE RESTRICT,
ADD CONSTRAINT oauth2_consent_session_preconfiguration_fkey
FOREIGN KEY (preconfiguration)
REFERENCES oauth2_consent_preconfiguration (id) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE oauth2_consent_preconfiguration
ADD CONSTRAINT oauth2_consent_preconfiguration_subject_fkey
FOREIGN KEY (subject)
REFERENCES user_opaque_identifier (identifier) ON UPDATE CASCADE ON DELETE RESTRICT;
ALTER TABLE oauth2_access_token_session
ADD CONSTRAINT oauth2_access_token_session_challenge_id_fkey
FOREIGN KEY (challenge_id)
REFERENCES oauth2_consent_session (challenge_id) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT oauth2_access_token_session_subject_fkey
FOREIGN KEY (subject)
REFERENCES user_opaque_identifier (identifier) ON UPDATE CASCADE ON DELETE RESTRICT;
ALTER TABLE oauth2_authorization_code_session
ADD CONSTRAINT oauth2_authorization_code_session_challenge_id_fkey
FOREIGN KEY (challenge_id)
REFERENCES oauth2_consent_session (challenge_id) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT oauth2_authorization_code_session_subject_fkey
FOREIGN KEY (subject)
REFERENCES user_opaque_identifier (identifier) ON UPDATE CASCADE ON DELETE RESTRICT;
ALTER TABLE oauth2_openid_connect_session
ADD CONSTRAINT oauth2_openid_connect_session_challenge_id_fkey
FOREIGN KEY (challenge_id)
REFERENCES oauth2_consent_session (challenge_id) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT oauth2_openid_connect_session_subject_fkey
FOREIGN KEY (subject)
REFERENCES user_opaque_identifier (identifier) ON UPDATE CASCADE ON DELETE RESTRICT;
ALTER TABLE oauth2_pkce_request_session
ADD CONSTRAINT oauth2_pkce_request_session_challenge_id_fkey
FOREIGN KEY (challenge_id)
REFERENCES oauth2_consent_session (challenge_id) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT oauth2_pkce_request_session_subject_fkey
FOREIGN KEY (subject)
REFERENCES user_opaque_identifier (identifier) ON UPDATE CASCADE ON DELETE RESTRICT;
ALTER TABLE oauth2_refresh_token_session
ADD CONSTRAINT oauth2_refresh_token_session_challenge_id_fkey
FOREIGN KEY (challenge_id)
REFERENCES oauth2_consent_session (challenge_id) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT oauth2_refresh_token_session_subject_fkey
FOREIGN KEY (subject)
REFERENCES user_opaque_identifier (identifier) ON UPDATE CASCADE ON DELETE RESTRICT;
|
