update on lock files
update on sql struct