text: /*
  TODO: document
  */
  
  /*
  +--------------+-------------+------+-----+---------+----------------+
  | Field        | Type        | Null | Key | Default | Extra          |
  +--------------+-------------+------+-----+---------+----------------+
  | id           | int(11)     | NO   | PRI | NULL    | auto_increment |
  | release_date | date        | NO   |     | NULL    |                |
  | issue        | int(11)     | NO   | MUL | NULL    |                |
  | epiweek      | int(11)     | NO   |     | NULL    |                |
  | lag          | int(11)     | NO   |     | NULL    |                |
  | region       | varchar(12) | NO   |     | NULL    |                |
  | ili          | double      | NO   |     | NULL    |                |
  +--------------+-------------+------+-----+---------+----------------+
  */
  
  CREATE TABLE `kcdc_ili` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `release_date` date NOT NULL,
    `issue` int(11) NOT NULL,
    `epiweek` int(11) NOT NULL,
    `lag` int(11) NOT NULL,
    `region` varchar(12) NOT NULL,
    `ili` double NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `issue` (`issue`,`epiweek`,`region`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  