CREATE TABLE `dim_date` (
  `date_key` INT(11) NOT NULL,
  `date_value` DATE DEFAULT NULL,
  `date_iso` CHAR(10) DEFAULT NULL,
  `year` SMALLINT(6) DEFAULT NULL,
  `quarter` tinyint(4) DEFAULT NULL,
  `quarter_name` CHAR(2) DEFAULT NULL,
  `month` tinyint(4) DEFAULT NULL,
  `month_name` VARCHAR(10) DEFAULT NULL,
  `month_abbreviation` VARCHAR(10) DEFAULT NULL,
  `week` CHAR(2) DEFAULT NULL,
  `day_of_month` tinyint(4) DEFAULT NULL,
  `day_of_year` SMALLINT(6) DEFAULT NULL,
  `day_of_week` SMALLINT(6) DEFAULT NULL,
  `day_name` VARCHAR(10) DEFAULT NULL,
  `day_abbreviation` VARCHAR(10) DEFAULT NULL,
  `is_weekend` tinyint(4) DEFAULT NULL,
  `is_weekday` tinyint(4) DEFAULT NULL,
  `is_today` tinyint(4) DEFAULT NULL,
  `is_yesterday` tinyint(4) DEFAULT NULL,
  `is_this_week` tinyint(4) DEFAULT NULL,
  `is_last_week` tinyint(4) DEFAULT NULL,
  `is_this_month` tinyint(4) DEFAULT NULL,
  `is_last_month` tinyint(4) DEFAULT NULL,
  `is_this_year` tinyint(4) DEFAULT NULL,
  `is_last_year` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`date_key`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1