leetify-data/sqitch/deploy/profile-game.sql

-- Deploy leetify-data:profile-game to pg
-- requires: data-schema

BEGIN;

  CREATE TABLE IF NOT EXISTS data.profile_game (
     leetify_user_id TEXT,
     ct_Leetify_rating NUMERIC,
     ct_Leetify_rating_rounds NUMERIC,
     data_source TEXT,
     elo NUMERIC,
     game_finished_at TIMESTAMP,
     game_id TEXT,
     is_cs2 BOOL,
     map_name TEXT,
     match_result TEXT,
     scores TEXT, -- has to be extracted from array
     skill_level NUMERIC,
     t_leetify_rating NUMERIC,
     t_leetify_rating_rounds NUMERIC,
     deaths NUMERIC,
     has_banned_player BOOL,
     kills NUMERIC,
     party_size NUMERIC
  );


COMMIT;