-- ------------------------------------------------
-- Calendar: add monday_of_week to support weekly
--           UM dashboard figures
-- Created 20120912
-- ------------------------------------------------

--ALTER TABLE `calendar`
--  ADD COLUMN `monday_of_week` DATE NOT NULL DEFAULT 0  AFTER `date`, 
--  ADD INDEX `monday` (`monday_of_week` ASC) ;
  
--UPDATE calendar
--  SET monday_of_week = DATE_SUB(date, INTERVAL WEEKDAY(date) DAY);