The table is called 'pkg_annotation' not 'pkg_annotate'
Fix some SQL: that table has a column named annotation_id, not tag_id.
Employing ATF more correctly:

- use Atffiles to run tests.
- Basic testing is to run 'atf-run | atf-report'
- Only use Makefiles where necessary to build test programs
- As tests are run in a temporary dir, use atf_get_srcdir() liberally
  to make absolute paths
- Temporarily disable testing in lib: needs more work