
--------------------------------------------------
-- 02/09/2020
-- Author: Tony Chen 
-- Following changes are made to calculate SU_COMPUTED 
-- from 'start.txt'.  If the start.txt is not available
-- the previous implementation calculating from DATE_SUBMITTED
-- will be used. 
--------------------------------------------------

-- Add a new column 'DATE_STARTED'. 
ALTER TABLE `job_stats` 
  ADD COLUMN `DATE_STARTED` DATETIME NULL AFTER `DATE_SUBMITTED`
;
-- --------------------------------------------------

INSERT INTO `version` (`VERSION`, `LAST_MODIFIED_TIME`) VALUES 
    ('2020-02-09', NOW())
;
-- --------------------------------------------------
