Add mastodon protocol support for web auth

O01eg

May 5, 2023, 11:55 AM

YQGD4AILRS5AEV4V7TPSIHQIZLO4XLVAZXCHPKKD7I5IAA45QQUAC

Dependencies

• [2] IXY6NZLM Start to use migrations files for PostgreSQL database

Change contents

• file addition: 20230505_0_protocol_mastodon.sql (----------)
  [2.15]
  + -- Add new type to contact enum

  + -- Use mastodon for web auth

  +

  + DO $$

  + BEGIN

  + IF NOT EXISTS (

  + SELECT 1 FROM pg_type t

  + INNER JOIN pg_namespace p ON t.typnamespace=p.oid

  + INNER JOIN pg_enum e ON e.enumtypid = t.oid

  + WHERE t.typname='contact_protocol' AND p.nspname='auth' AND e.enumlabel = 'mastodon'

  + ) THEN

  + ALTER TYPE auth.contact_protocol ADD VALUE 'mastodon';

  + END IF;

  + END

  + $$;

  +