A design for the type of schema that was recommended to you might look like the following. I've made various changes to what you provided in order to correct SQL syntax and according to my personal...

I recommend daily tables. For applications like these, I use a template table called something like lotsofdata_template and individual per-day tables called lotsofdata_YYYYMMDD, e.g....