CREATE TABLE valorant_stats (
  "name" VARCHAR,
  "weapon_type" VARCHAR,
  "price" BIGINT,
  "fire_rate" DOUBLE,
  "wall_penetration" VARCHAR,
  "magazine_capacity" BIGINT,
  "hdmg_0" BIGINT,
  "bdmg_0" BIGINT,
  "ldmg_0" BIGINT,
  "hdmg_1" BIGINT,
  "bdmg_1" BIGINT,
  "ldmg_1" BIGINT,
  "hdmg_2" BIGINT,
  "bdmg_2" BIGINT,
  "ldmg_2" BIGINT
);