pre-db revamp