mirror of https://github.com/authelia/authelia.git
10 lines
298 B
SQL
10 lines
298 B
SQL
ALTER TABLE oauth2_consent_session
|
|
RENAME CONSTRAINT oauth2_consent_session_subject_fkey TO oauth2_consent_subject_fkey;
|
|
|
|
DELETE FROM oauth2_consent_session
|
|
WHERE subject IS NULL;
|
|
|
|
ALTER TABLE oauth2_consent_session
|
|
ALTER COLUMN subject SET NOT NULL,
|
|
ALTER COLUMN subject DROP DEFAULT;
|