-- @(#)Drm_collector-patch02-undo.ddl	1.3 05/11/15
--
-- ##################################################################
--
-- Undo the following:
--
-- What is the change: Update a non-null timestampz value for last_scan
-- column in drm_collector table.
--
-- Why change is needed: Fix for CR 6332340 where the DRM Collector may
-- throw a SQL exception for 'null' timestamp.
--
-- Risks to existing user data: No risk: this is system data, not user data.
--
-- UPDATE drm_collector set last_scan = 'epoch' where last_scan is null;

UPDATE drm_collector set last_scan = null where last_scan = 'epoch';

