@mattab opened this Issue on December 17th 2017 Owner


  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)

Powered by GitHub Issue Mirror