title: Create a time (by half hours) table in MySQL
body: <p>For reporting purposes I need a Time table that acts as a lookup table that lists every half hour in a day. It will function the same way as a date table except it's time. </p>
  
  <p>I found a great example of a 24 hour table: </p>
  
  <pre><code>    CREATE TABLE hourly_data
  (
      id INT PRIMARY KEY AUTO_INCREMENT,
      date DATE NOT NULL,
      hour INT NOT NULL,
      f1 INT NOT NULL,
      f2 INT NOT NULL,
      f3 INT NOT NULL,
      f4 INT NOT NULL,
      f5 INT NOT NULL,
      f6 INT NOT NULL,
      inserted timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  )
  </code></pre>
  
  <p>But I would rather it be every half hour. Any ideas on how to do this? This would help with shifts and create specialized reports. Thanks in advance! </p>