How should I save statistics to a database

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:

CREATE TABLE stats(year,month,day,hour,joinedChannel,TotalFollowers);

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.