tests: use 'check_PROGRAMS' instead of 'noinst_PROGRAMS'

When using 'check_PROGRAMS', autoconf/automake generates smarter
Makefiles, so that the test programs are not being compiled during
the normal 'make all', but only during 'make check'.

Change-Id: I13b519e61ca0d9ce038e8c989ddac012de4a6c61
diff --git a/tests/db_sms/Makefile.am b/tests/db_sms/Makefile.am
index 4e85067..52fd35e 100644
--- a/tests/db_sms/Makefile.am
+++ b/tests/db_sms/Makefile.am
@@ -24,7 +24,7 @@
 	db_sms_test.err \
 	$(NULL)
 
-noinst_PROGRAMS = \
+check_PROGRAMS = \
 	db_sms_test \
 	$(NULL)