be able to update a restored table/database state when created as VIEWs