PLAT-6369 - Added database changes required to add snapshot type

Fixed failing test - Reviewed-by: Jon