authelia/internal/storage/migrations/V0005.ConsentSubjectNULL.po...

10 lines
298 B
MySQL
Raw Permalink Normal View History

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;