title: Storing daily event start and end times in MySQL
body: <p>I currently have an Events table that stores the event and what days of the week the event occurs, the table looks something like this.</p>
  
  <pre><code>EventID  Title       Mon Tue Wed Thu Fri Sat Sun
  1        EventName   1   1   0   0   1   0   0   
  </code></pre>
  
  <p>I want to be able to add START and END times for each event, usually I would just add two extra columns such as StartTime and EndTime, but the start and end times are often different for on each day of the week.</p>
  
  <p>What would be the best way to set up my tables to achieve this?</p>
  
  <p>Thanks</p>