21 lines
829 B
SQL
21 lines
829 B
SQL
DO $$
|
|
BEGIN
|
|
IF EXISTS (
|
|
SELECT 1 FROM information_schema.columns
|
|
WHERE table_schema = current_schema()
|
|
AND table_name = 'social_account'
|
|
AND column_name = 'cookies'
|
|
) THEN
|
|
IF EXISTS (SELECT 1 FROM social_account WHERE credential_reference_id IS NULL OR cookies <> '') THEN
|
|
RAISE EXCEPTION 'legacy migration 13 contains account credentials; migrate them to the credential provider before upgrade';
|
|
END IF;
|
|
ALTER TABLE social_account DROP COLUMN cookies;
|
|
END IF;
|
|
|
|
IF EXISTS (SELECT 1 FROM social_account WHERE credential_reference_id IS NULL) THEN
|
|
RAISE EXCEPTION 'social accounts without credential references block migration 14';
|
|
END IF;
|
|
|
|
ALTER TABLE social_account ALTER COLUMN credential_reference_id SET NOT NULL;
|
|
END $$;
|