Closes #3142. Move `internal/database/smt/managed/*` into `internal/database` to facilitate other refactoring and to prepare for exporting the database package.

Changelog: refactor