-- $Id: wfwl_reports_altercol 720 2023-02-09 18:37:09Z bhockney $
--
-- Update definitions for last_accessed and last_saved in table '$WFWL_DB.reports'
--
UPDATE $WFWL_DB.reports SET last_accessed = 0 WHERE last_accessed IS NULL;
UPDATE $WFWL_DB.reports SET last_saved = 0 WHERE last_saved IS NULL;
ALTER TABLE $WFWL_DB.reports CHANGE COLUMN last_accessed last_accessed int(10) UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE $WFWL_DB reports CHANGE COLUMN last_saved last_saved int(10) UNSIGNED NOT NULL DEFAULT 0;

