added zmarkdeleted and updated a few tables missing these fields