Skip to content

Instantly share code, notes, and snippets.

@MorganBorman

MorganBorman/gist:2050629

Created March 16, 2012 15:47
Show Gist options
  • Save MorganBorman/2050629 to your computer and use it in GitHub Desktop.
Save MorganBorman/2050629 to your computer and use it in GitHub Desktop.
Download ZIP
Improved stats schema
Raw
gistfile1.md

user_sums_stats

user_id: Int

mode: Int

day: date

full_games: Int

frags: Int

deaths: Int

suicides: Int

teamkills: Int

damage_spent: Int

damage_dealt: Int

user_stats_playtime

user_id: Int

mode: Int

day: date

hour: TinyInt

playtime: Int

spectime: Int

deadtime: Int

edittime: Int

user_stats_weapons

user_id: Int

mode: Int

weapon_id: TinyInt

day: date

damage_spent: Int

damage_dealt: Int

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment