text: CREATE TABLE "game_types" (
    "id" bigint PRIMARY KEY,
    "table_type" varchar(20)
  );
  
  CREATE TABLE "games" (
    "id" bigint PRIMARY KEY,
    "demo_file" varchar(1000),
    "demo_tick_rate" double precision,
    "game_tick_rate" double precision,
    "game_type" bigint
  );
  
  CREATE TABLE "players" (
    "id" bigint PRIMARY KEY,
    "game_id" bigint,
    "name" varchar(255),
    "steam_id" bigint
  );
  
  CREATE TABLE "equipment" (
    "id" smallint PRIMARY KEY,
    "name" varchar(30)
  );
  
  CREATE TABLE "rounds" (
    "id" bigint PRIMARY KEY,
    "game_id" bigint,
    "start_tick" bigint,
    "end_tick" bigint,
    "warmup" boolean,
    "freeze_time_end" bigint,
    "round_number" smallint,
    "round_end_reason" smallint,
    "winner" smallint,
    "t_wins" smallint,
    "ct_wins" smallint
  );
  
  CREATE TABLE "ticks" (
    "id" bigint PRIMARY KEY,
    "round_id" bigint,
    "game_time" bigint,
    "demo_tick_number" bigint,
    "game_tick_number" bigint,
    "bomb_carrier" bigint,
    "bomb_x" double precision,
    "bomb_y" double precision,
    "bomb_z" double precision
  );
  
  CREATE TABLE "player_at_tick" (
    "id" bigint PRIMARY KEY,
    "player_id" bigint,
    "tick_id" bigint,
    "pos_x" double precision,
    "pos_y" double precision,
    "pos_z" double precision,
    "view_x" double precision,
    "view_y" double precision,
    "team" smallint,
    "health" double precision,
    "armor" double precision,
    "has_helmet" boolean,
    "is_alive" boolean,
    "is_crouching" boolean,
    "is_airborne" boolean,
    "remaining_flash_time" double precision,
    "active_weapon" smallint,
    "primary_weapon" smallint,
    "primary_bullets_clip" smallint,
    "primary_bullets_reserve" smallint,
    "secondary_weapon" smallint,
    "secondary_bullets_clip" smallint,
    "secondary_bullets_reserve" smallint,
    "num_he" smallint,
    "num_flash" smallint,
    "num_smoke" smallint,
    "num_molotov" smallint,
    "num_incendiary" smallint,
    "num_decoy" smallint,
    "num_zeus" smallint,
    "has_defuser" boolean,
    "has_bomb" boolean,
    "money" int
  );
  
  CREATE TABLE "spotted" (
    "id" bigint PRIMARY KEY,
    "tick_id" bigint,
    "spotted_player" bigint,
    "spotter_player" bigint,
    "is_spotted" boolean
  );
  
  CREATE TABLE "weapon_fire" (
    "id" bigint PRIMARY KEY,
    "tick_id" bigint,
    "shooter" bigint,
    "weapon" smallint
  );
  
  CREATE TABLE "hit_groups" (
    "id" bigint PRIMARY KEY,
    "group_name" varchar(30)
  );
  
  CREATE TABLE "hurt" (
    "id" bigint PRIMARY KEY,
    "tick_id" bigint,
    "victim" bigint,
    "attacker" bigint,
    "weapon" smallint,
    "armor_damage" integer,
    "armor" integer,
    "health_damage" integer,
    "health" integer,
    "hit_group" bigint
  );
  
  CREATE TABLE "grenades" (
    "id" bigint PRIMARY KEY,
    "thrower" bigint,
    "grenade_type" smallint,
    "throw_tick" bigint,
    "active_tick" bigint,
    "expired_tick" bigint,
    "destroy_tick" bigint
  );
  
  CREATE TABLE "grenade_trajectories" (
    "id" bigint PRIMARY KEY,
    "grenade_id" bigint,
    "id_per_grenade" int,
    "pos_x" double precision,
    "pos_y" double precision,
    "pos_z" double precision
  );
  
  CREATE TABLE "flashed" (
    "id" bigint PRIMARY KEY,
    "tick_id" bigint,
    "grenade_id" bigint,
    "thrower" bigint,
    "victim" bigint
  );
  
  CREATE TABLE "kills" (
    "id" bigint PRIMARY KEY,
    "tick_id" bigint,
    "killer" bigint,
    "victim" bigint,
    "weapon" smallint,
    "assister" bigint,
    "is_headshot" boolean,
    "is_wallbang" boolean,
    "penetrated_objects" integer
  );
  
  CREATE TABLE "plants" (
    "id" bigint PRIMARY KEY,
    "start_tick" bigint,
    "end_tick" bigint,
    "planter" bigint,
    "succesful" boolean
  );
  
  CREATE TABLE "defusals" (
    "id" bigint PRIMARY KEY,
    "plant_id" bigint,
    "start_tick" bigint,
    "end_tick" bigint,
    "defuser" bigint,
    "succesful" boolean
  );
  
  CREATE TABLE "explosions" (
    "id" bigint PRIMARY KEY,
    "plant_id" bigint,
    "tick_id" bigint
  );
  