@mattab opened this Issue on December 17th 2017 Member

Currently:

  1. when a site is deleted we do not actually delete the log_ records for this site, ie. we keep all historical RAW data
  2. when a website is deleted, we delete the row completely from the site table.

so 1) is fine and by design, but 2) is not good enough, as it leads to "orphaned" RAW data logs where we don't know which website the logs (used to) refer to.

-> Instead we should use a soft delete where the row would have a flag deleted=1.

This would make the database represent the real state of the data and be more consistent with our newer practises (ie. soft deletes are used for Goals / Funnels / Forms / Heatmaps / Sessions / Scheduled reports / Segments)

@mattab commented on May 14th 2018 Member

see also #12907 When website has been deleted, we should also delete the raw data for this website

Powered by GitHub Issue Mirror