I'm going use MySQL to log transactions so that I can report on them
CREATE TABLE statistics (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT
, user_id BIGINT UNSIGNED
, entity_id INT UNSIGNED
, transaction_type INTEGER(2) UNSIGNED
, datetime_logged DATETIME
, datetime_logged_gmt DATETIME
, PRIMARY KEY (id)
What are the queries that would get me the data organized by:
Day of Week?
I guess I can add the fields:
and that would make reporting a lot easier!
How do people typically go about doing this without breaking down the