Define "corrupt". This would be all I'd have to do to restore the data…
INSERT INTO `core_stream_subscriptions` (`id`, `member_id`, `stream_id`, `frequency`, `sent`, `added`) VALUES (2,99547,1,'daily',1642337822,1636000819),(8,101722,4,'daily',1642265420,1642351820);
I've verified that the members and the streams exist.