title: How should I save statistics to a database
body: <p>I have currently made an irc bot for twitch. I want to save statistics to a database with data like, how many users joined the channel, how many new followers were gained and other stuff too. I am not sure how this is done correctly but the way I have done it now is like this:</p>
  
  <pre><code>CREATE TABLE stats(year,month,day,hour,joinedChannel,TotalFollowers);
  </code></pre>
  
  <p>But I feel like this will be a wierd way to do it. My question basicly is if there is a smarter way for me to save statistics like shown above.</p>
  
  <p>edit:
  Hmm well it seems like i didnt supply all the information. Currently I have a table looking like this "CREATE TABLE users(id,points,timespent,follower,followed,wMessage);" I have a few features in my bot like, song request and a queue to join games. I would like to have stats so I can see how many used song requests this day and how many used the queue feature this day and how many followed the channel this day, where "this" would be any chosen day. Wouldn't I need a more complex table design for that? –</p>