# Dummy SQL file to set schema version to 0.1.04 so next update will work
;

ALTER TABLE `#__ggprovider_subscribers`
  ADD COLUMN content_denied_at TIMESTAMP NULL,
  ADD COLUMN paid_at TIMESTAMP NULL
;

UPDATE `#__ggprovider_subscribers` SET
  content_denied_at = GREATEST(closed_at, updated_at+INTERVAL 1 DAY),
  paid_at = updated_at
;
