Reset all meter readings

On a development/test environment today I had to reset all meter readings. Maximo is storing the last readings in a set of fields of the ASSETMETER table and the reading history in the METERREADING table.

Here are the SQL statements I have used.

delete from meterreading;

update assetmeter
set lastreading=0, lastreadingdate=null,
sincelastrepair=0, sincelastoverhaul=0, sincelastinspect=0,
sinceinstall=0, lifetodate=0, average=0,
lastreadinginspctr=null;