-- -------------------------------------------------------
-- reconfigure ic_notification table to include which user
-- and move some columns around for better logic
-- -------------------------------------------------------
ALTER TABLE `ic_notification` 
DROP PRIMARY KEY,
CHANGE COLUMN `today_overdue_sent_on` `sent` DATE NULL DEFAULT NULL AFTER `client`,
CHANGE COLUMN `id` `username` VARCHAR(12) NOT NULL ,
ADD PRIMARY KEY (`username`, `system`, `client`);