Create events_log table

[jaredatron]

Right now we store when a learner checks a skill checkbox in the table checks. We also log every time a learner checks or unchecks a skill checkbox in check_log.

We want to log more than just the checks now that were about to add support for checking challenge checkboxes.

• Create the event_log table with the following columns:
  • user_id (integer)
  • occurred_at (Datetime)
  • metadata (PG Hash)
• Migrate the check_log table into another table called event_logs with a new column of type which is a string.
• All rows migrated from event_logs should have the type skill_check.
• label, checked and referrer should be moved into properties of the metadata column hash
• Update the queries in /database to retrieve the log of skill checks from the new table.

[je-lopez]

pr: https://github.com/LearnersGuild/curriculum/pull/303

[je-lopez]

pr: https://github.com/LearnersGuild/curriculum/pull/324

[je-lopez]

latest pr with your refactoring: https://github.com/LearnersGuild/curriculum/pull/333