complete db functions
update pre-complete