log_records for this site, ie. we keep all historical RAW data
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
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)
see also #12907 When website has been deleted, we should also delete the raw data for this website