I have no idea which tables need to be updated, or indeed whether anything actually needs to be done other than pruning logs.
On the one hand you could argue that the items should be deleted, on the other you could argue that all you really need do is ensure that the table joins don't flake out because there's no longer a matching relation to the members table, it would have the same practical effect as resetting the ids to 0.
Also, while we're on that note, do we need to add the facility to reassign owners of albums and so on? Are the old details recorded, e.g. email address? Same deal for items, on that same note.