Add fiel to mark game as teamed

O01eg

May 9, 2023, 6:10 PM

FZXHRNJGDLHEKKDI2UQ36UTO6IDDDJ3PUNIKEI73DQSK7S5YBLAQC

Dependencies

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

Change contents

• file addition: 20230509_1_games-teamed-flag.sql (----------)
  [2.15]
  + -- Add field to game to show team info

  +

  + DO $$

  + BEGIN

  + IF NOT EXISTS (

  + SELECT 1 FROM pg_class c

  + INNER JOIN pg_namespace n ON n.oid = c.relnamespace

  + INNER JOIN pg_attribute a ON a.attrelid = c.oid

  + WHERE c.relname = 'games' AND n.nspname = 'games' AND a.attname = 'is_teamed'

  + ) THEN

  + ALTER TABLE games.games ADD COLUMN is_teamed BOOLEAN NOT NULL DEFAULT FALSE;

  + END IF;

  + END

  + $$;

  +